WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Pogoda Baxter State of Victoria Australia
JavaScript is turned off in your web browser. Turn it on to take full advantage of this site, then refresh the page.
DEBUG Page meteo.php: Execution Time Init WSP ...: 0 Seconds
Execution Time End Init WSP: 0.014 Seconds
Execution Time Create Page ...: 0.014 Seconds
Execution Time End Create Page: 0.015 Seconds
Execution Time InitializeComponent ...: 0.015 Seconds
Execution Time End InitializeComponent ...: 0.015 Seconds
Execution Time Load ...: 0.015 Seconds
SELECT DISTINCT c.city_code, c.latitude, c.longitude, c.format_name, c.name, c.name_pl, c.population, c.elevation, lc.region_name, lc.latitude_30, lc.longitude_30, lc.population_30, lc.latitude_120, lc.longitude_120, lc.population_120, lc.is_proximity_city, c.is_geonames_data, c.parent_city_code, c.is_duplicate_url_detected, c.is_histo_rate_migrate, r.code_region, r.is_geoname_data, r.big_geoname_id, r.name_pl, c.pic_json, c.pic_json_validated, c.nb_news
FROM geo_db_au.au_link_city lc
INNER JOIN geo_db_au.au_city2 c ON c.city_code=lc.city_code
INNER JOIN geo_db.region r ON r.code_country=c.country_code AND r.code_region=c.code_region
WHERE lc.ctr = 'au'
AND lc.ctr IN ('FJ','FM','PG','SB','TO','VU','AU','CK','KI','MH','NR','NU','NZ','PW','WS','PF','TV','TK','CC','MP','NF','NC','PN')
AND lc.region = 'victoria'
AND lc.city = 'baxter'
[Execution Time: 0.001 Seconds]
SELECT `au_proximity_city`.`city_code`, `au_proximity_city`.`city_code_1`, `au_proximity_city`.`city_1`, `au_proximity_city`.`region_1`, `au_proximity_city`.`city_code_2`, `au_proximity_city`.`city_2`, `au_proximity_city`.`region_2`, `au_proximity_city`.`city_code_3`, `au_proximity_city`.`city_3`, `au_proximity_city`.`region_3`, `au_proximity_city`.`city_code_4`, `au_proximity_city`.`city_4`, `au_proximity_city`.`region_4`, `au_proximity_city`.`city_code_5`, `au_proximity_city`.`city_5`, `au_proximity_city`.`region_5`, `au_proximity_city`.`city_code_6`, `au_proximity_city`.`city_6`, `au_proximity_city`.`region_6`, `au_proximity_city`.`city_code_7`, `au_proximity_city`.`city_7`, `au_proximity_city`.`region_7`, `au_proximity_city`.`city_code_8`, `au_proximity_city`.`city_8`, `au_proximity_city`.`region_8`, `au_proximity_city`.`city_code_9`, `au_proximity_city`.`city_9`, `au_proximity_city`.`region_9`, `au_proximity_city`.`city_code_10`, `au_proximity_city`.`city_10`, `au_proximity_city`.`region_10`, `au_proximity_city`.`city_code_11`, `au_proximity_city`.`city_11`, `au_proximity_city`.`region_11`, `au_proximity_city`.`city_code_12`, `au_proximity_city`.`city_12`, `au_proximity_city`.`region_12`, `au_proximity_city`.`city_code_13`, `au_proximity_city`.`city_13`, `au_proximity_city`.`region_13`, `au_proximity_city`.`city_code_14`, `au_proximity_city`.`city_14`, `au_proximity_city`.`region_14`, `au_proximity_city`.`city_code_15`, `au_proximity_city`.`city_15`, `au_proximity_city`.`region_15`, `au_proximity_city`.`city_code_16`, `au_proximity_city`.`city_16`, `au_proximity_city`.`region_16`, `au_proximity_city`.`city_code_17`, `au_proximity_city`.`city_17`, `au_proximity_city`.`region_17`, `au_proximity_city`.`city_code_18`, `au_proximity_city`.`city_18`, `au_proximity_city`.`region_18`, `au_proximity_city`.`city_code_19`, `au_proximity_city`.`city_19`, `au_proximity_city`.`region_19`, `au_proximity_city`.`city_code_20`, `au_proximity_city`.`city_20`, `au_proximity_city`.`region_20`, `au_proximity_city`.`city_code_21`, `au_proximity_city`.`city_21`, `au_proximity_city`.`region_21` FROM `geo_db_au`.`au_proximity_city` WHERE city_code='107013' [Execution Time: 0 Seconds]
SELECT city_code, name_pl FROM geo_db_au.au_city2 WHERE city_code IN (114662,112535,111525,106850,112682,115533,109765,113685,109764,112284,112576,111864,114517,108232,113492,110462,106826,108231,109115,112728,107289) [Execution Time: 0 Seconds]
SELECT `au_proximity_city`.`city_code`, `au_proximity_city`.`city_code_1`, `au_proximity_city`.`city_1`, `au_proximity_city`.`region_1`, `au_proximity_city`.`city_code_2`, `au_proximity_city`.`city_2`, `au_proximity_city`.`region_2`, `au_proximity_city`.`city_code_3`, `au_proximity_city`.`city_3`, `au_proximity_city`.`region_3`, `au_proximity_city`.`city_code_4`, `au_proximity_city`.`city_4`, `au_proximity_city`.`region_4`, `au_proximity_city`.`city_code_5`, `au_proximity_city`.`city_5`, `au_proximity_city`.`region_5`, `au_proximity_city`.`city_code_6`, `au_proximity_city`.`city_6`, `au_proximity_city`.`region_6`, `au_proximity_city`.`city_code_7`, `au_proximity_city`.`city_7`, `au_proximity_city`.`region_7`, `au_proximity_city`.`city_code_8`, `au_proximity_city`.`city_8`, `au_proximity_city`.`region_8`, `au_proximity_city`.`city_code_9`, `au_proximity_city`.`city_9`, `au_proximity_city`.`region_9`, `au_proximity_city`.`city_code_10`, `au_proximity_city`.`city_10`, `au_proximity_city`.`region_10`, `au_proximity_city`.`city_code_11`, `au_proximity_city`.`city_11`, `au_proximity_city`.`region_11`, `au_proximity_city`.`city_code_12`, `au_proximity_city`.`city_12`, `au_proximity_city`.`region_12`, `au_proximity_city`.`city_code_13`, `au_proximity_city`.`city_13`, `au_proximity_city`.`region_13`, `au_proximity_city`.`city_code_14`, `au_proximity_city`.`city_14`, `au_proximity_city`.`region_14`, `au_proximity_city`.`city_code_15`, `au_proximity_city`.`city_15`, `au_proximity_city`.`region_15`, `au_proximity_city`.`city_code_16`, `au_proximity_city`.`city_16`, `au_proximity_city`.`region_16`, `au_proximity_city`.`city_code_17`, `au_proximity_city`.`city_17`, `au_proximity_city`.`region_17`, `au_proximity_city`.`city_code_18`, `au_proximity_city`.`city_18`, `au_proximity_city`.`region_18`, `au_proximity_city`.`city_code_19`, `au_proximity_city`.`city_19`, `au_proximity_city`.`region_19`, `au_proximity_city`.`city_code_20`, `au_proximity_city`.`city_20`, `au_proximity_city`.`region_20`, `au_proximity_city`.`city_code_21`, `au_proximity_city`.`city_21`, `au_proximity_city`.`region_21` FROM `geo_db_au`.`au_proximity_city` WHERE city_code='107013' [Execution Time: 0 Seconds]
SELECT COUNT(*) FROM `meteo_au`.`au_news` WHERE code_ville in (107013, 114662, 112535, 111525, 106850, 112682, 115533, 109765, 113685, 109764, 112284, 112576, 111864, 114517, 108232, 113492, 110462, 106826, 108231, 109115, 112728, 107289) [Execution Time: 0 Seconds]
SELECT `au_proximity_city`.`city_code`, `au_proximity_city`.`city_code_1`, `au_proximity_city`.`city_1`, `au_proximity_city`.`region_1`, `au_proximity_city`.`city_code_2`, `au_proximity_city`.`city_2`, `au_proximity_city`.`region_2`, `au_proximity_city`.`city_code_3`, `au_proximity_city`.`city_3`, `au_proximity_city`.`region_3`, `au_proximity_city`.`city_code_4`, `au_proximity_city`.`city_4`, `au_proximity_city`.`region_4`, `au_proximity_city`.`city_code_5`, `au_proximity_city`.`city_5`, `au_proximity_city`.`region_5`, `au_proximity_city`.`city_code_6`, `au_proximity_city`.`city_6`, `au_proximity_city`.`region_6`, `au_proximity_city`.`city_code_7`, `au_proximity_city`.`city_7`, `au_proximity_city`.`region_7`, `au_proximity_city`.`city_code_8`, `au_proximity_city`.`city_8`, `au_proximity_city`.`region_8`, `au_proximity_city`.`city_code_9`, `au_proximity_city`.`city_9`, `au_proximity_city`.`region_9`, `au_proximity_city`.`city_code_10`, `au_proximity_city`.`city_10`, `au_proximity_city`.`region_10`, `au_proximity_city`.`city_code_11`, `au_proximity_city`.`city_11`, `au_proximity_city`.`region_11`, `au_proximity_city`.`city_code_12`, `au_proximity_city`.`city_12`, `au_proximity_city`.`region_12`, `au_proximity_city`.`city_code_13`, `au_proximity_city`.`city_13`, `au_proximity_city`.`region_13`, `au_proximity_city`.`city_code_14`, `au_proximity_city`.`city_14`, `au_proximity_city`.`region_14`, `au_proximity_city`.`city_code_15`, `au_proximity_city`.`city_15`, `au_proximity_city`.`region_15`, `au_proximity_city`.`city_code_16`, `au_proximity_city`.`city_16`, `au_proximity_city`.`region_16`, `au_proximity_city`.`city_code_17`, `au_proximity_city`.`city_17`, `au_proximity_city`.`region_17`, `au_proximity_city`.`city_code_18`, `au_proximity_city`.`city_18`, `au_proximity_city`.`region_18`, `au_proximity_city`.`city_code_19`, `au_proximity_city`.`city_19`, `au_proximity_city`.`region_19`, `au_proximity_city`.`city_code_20`, `au_proximity_city`.`city_20`, `au_proximity_city`.`region_20`, `au_proximity_city`.`city_code_21`, `au_proximity_city`.`city_21`, `au_proximity_city`.`region_21` FROM `geo_db_au`.`au_proximity_city` WHERE city_code='107013' [Execution Time: 0 Seconds]
SELECT COUNT(*) FROM `meteo_au`.`au_news` WHERE code_ville in (107013, 114662, 112535, 111525, 106850, 112682, 115533, 109765, 113685, 109764, 112284, 112576, 111864, 114517, 108232, 113492, 110462, 106826, 108231, 109115, 112728, 107289) [Execution Time: 0 Seconds]
replace into meteo_au.au_meteo_histo values (-37.814, 144.96332, curdate(), 'Light Drizzle', '12', '16', '75', '94', '0.1', 'SW', '21', '22:07', '07:11', '', '0', '0') [Execution Time: 0 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_au.au_city_rate WHERE latitude=-38.2 AND longitude=145.15 [Execution Time: 0 Seconds]
SELECT `region_big_city`.`code_country`, `region_big_city`.`code_region`, `region_big_city`.`city_code_1`, `region_big_city`.`city_code_2`, `region_big_city`.`city_code_3`, `region_big_city`.`city_code_4`, `region_big_city`.`city_code_5`, `region_big_city`.`city_code_6`, `region_big_city`.`city_code_7`, `region_big_city`.`city_code_8`, `region_big_city`.`city_code_9`, `region_big_city`.`city_code_10`, `region_big_city`.`city_code_11`, `region_big_city`.`city_code_12`, `region_big_city`.`city_code_13`, `region_big_city`.`city_code_14`, `region_big_city`.`city_code_15`, `region_big_city`.`city_code_16`, `region_big_city`.`city_code_17`, `region_big_city`.`city_code_18`, `region_big_city`.`city_code_19`, `region_big_city`.`city_code_20`, `region_big_city`.`city_code_21` FROM `geo_db`.`region_big_city` WHERE code_country='au' AND code_region='07' [Execution Time: 0 Seconds]
SELECT `au_city2`.`city_code`, `au_city2`.`country_code`, `au_city2`.`format_name`, `au_city2`.`name`, `au_city2`.`code_region`, `au_city2`.`population`, `au_city2`.`latitude`, `au_city2`.`longitude`, `au_city2`.`elevation`, `au_city2`.`capital`, `au_city2`.`name_en`, `au_city2`.`name_fr`, `au_city2`.`name_de`, `au_city2`.`name_it`, `au_city2`.`name_pl`, `au_city2`.`name_es`, `au_city2`.`name_pt`, `au_city2`.`name_ru`, `au_city2`.`name_hi`, `au_city2`.`name_cn`, `au_city2`.`name_jp`, `au_city2`.`name_ar`, `au_city2`.`postal_code`, `au_city2`.`link`, `au_city2`.`geonames_nb_cities_found`, `au_city2`.`is_geonames_data`, `au_city2`.`geonames_id`, `au_city2`.`geonames_date`, `au_city2`.`latitude_orig`, `au_city2`.`longitude_orig`, `au_city2`.`parent_city_code`, `au_city2`.`is_city_created_manually`, `au_city2`.`is_duplicate_url_detected`, `au_city2`.`is_histo_rate_migrate`, `au_city2`.`pic_json`, `au_city2`.`pic_json_date`, `au_city2`.`nb_news`, `au_city2`.`pic_json_validated`, `au_city2`.`pic_json_date_validated` FROM `geo_db_au`.`au_city2` WHERE city_code IN (109850,107134,114580,112576) ORDER BY rand() ASC [Execution Time: 0.001 Seconds]
SELECT `au_link_city`.`ctr`, `au_link_city`.`region`, `au_link_city`.`city`, `au_link_city`.`city_code`, `au_link_city`.`region_name`, `au_link_city`.`latitude_30`, `au_link_city`.`longitude_30`, `au_link_city`.`population_30`, `au_link_city`.`latitude_120`, `au_link_city`.`longitude_120`, `au_link_city`.`population_120`, `au_link_city`.`is_proximity_city` FROM `geo_db_au`.`au_link_city` WHERE ctr='au' AND region='victoria' AND city='geelong' [Execution Time: 0 Seconds]
SELECT `au_link_city`.`ctr`, `au_link_city`.`region`, `au_link_city`.`city`, `au_link_city`.`city_code`, `au_link_city`.`region_name`, `au_link_city`.`latitude_30`, `au_link_city`.`longitude_30`, `au_link_city`.`population_30`, `au_link_city`.`latitude_120`, `au_link_city`.`longitude_120`, `au_link_city`.`population_120`, `au_link_city`.`is_proximity_city` FROM `geo_db_au`.`au_link_city` WHERE ctr='au' AND region='victoria' AND city='bendigo' [Execution Time: 0.001 Seconds]
SELECT `au_link_city`.`ctr`, `au_link_city`.`region`, `au_link_city`.`city`, `au_link_city`.`city_code`, `au_link_city`.`region_name`, `au_link_city`.`latitude_30`, `au_link_city`.`longitude_30`, `au_link_city`.`population_30`, `au_link_city`.`latitude_120`, `au_link_city`.`longitude_120`, `au_link_city`.`population_120`, `au_link_city`.`is_proximity_city` FROM `geo_db_au`.`au_link_city` WHERE ctr='au' AND region='victoria' AND city='shepparton' [Execution Time: 0 Seconds]
SELECT `au_link_city`.`ctr`, `au_link_city`.`region`, `au_link_city`.`city`, `au_link_city`.`city_code`, `au_link_city`.`region_name`, `au_link_city`.`latitude_30`, `au_link_city`.`longitude_30`, `au_link_city`.`population_30`, `au_link_city`.`latitude_120`, `au_link_city`.`longitude_120`, `au_link_city`.`population_120`, `au_link_city`.`is_proximity_city` FROM `geo_db_au`.`au_link_city` WHERE ctr='au' AND region='victoria' AND city='mornington' [Execution Time: 0 Seconds]
SELECT `nameday`.`country_code`, `nameday`.`month`, `nameday`.`day`, `nameday`.`name` FROM `meteo`.`nameday` WHERE country_code='PL' AND month=10 AND day=19 [Execution Time: 0 Seconds]
Execution Time End Load ...: 0.146 Seconds
Execution Time Variables ...: 0.146 Seconds
Execution Time End Variables: 0.146 Seconds
Execution Time Callback ...: 0.146 Seconds
Execution Time End Callback: 0.146 Seconds
Execution Time Loaded ...: 0.146 Seconds
Execution Time End Loaded: 0.146 Seconds
Execution Time Page Header ...: 0.146 Seconds
Execution Time End Page Header ...: 0.146 Seconds
Execution Time Render ...: 0.146 Seconds
Execution Time End Render: 0.155 Seconds