WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Weather Tianchakeng Zhejiang China
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.028 Seconds
Execution Time Create Page ...: 0.028 Seconds
Execution Time End Create Page: 0.029 Seconds
Execution Time InitializeComponent ...: 0.029 Seconds
Execution Time End InitializeComponent ...: 0.029 Seconds
Execution Time Load ...: 0.029 Seconds
SELECT DISTINCT c.city_code, c.latitude, c.longitude, c.format_name, c.name, c.name_en, 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_en, c.pic_json, c.pic_json_validated, c.nb_news
FROM geo_db_cn.cn_link_city lc
INNER JOIN geo_db_cn.cn_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 = 'cn'
AND lc.ctr IN ('ID','AE','AF','AM','AZ','BH','BT','CN','GE','IL','IN','BD','TW','UZ','IQ','IR','JO','JP','KG','KH','KR','KW','KZ','LA','LB','MM','KP','VN','YE','MN','MO','MY','OM','PH','PK','QA','SA','SY','TH','TM','TR','MV','HK','MY','NP','PS','TL','TJ','LK','SG')
AND lc.region = 'zhejiang'
AND lc.city = 'tianchakeng'
[Execution Time: 0.001 Seconds]
SELECT `cn_proximity_city`.`city_code`, `cn_proximity_city`.`city_code_1`, `cn_proximity_city`.`city_1`, `cn_proximity_city`.`region_1`, `cn_proximity_city`.`city_code_2`, `cn_proximity_city`.`city_2`, `cn_proximity_city`.`region_2`, `cn_proximity_city`.`city_code_3`, `cn_proximity_city`.`city_3`, `cn_proximity_city`.`region_3`, `cn_proximity_city`.`city_code_4`, `cn_proximity_city`.`city_4`, `cn_proximity_city`.`region_4`, `cn_proximity_city`.`city_code_5`, `cn_proximity_city`.`city_5`, `cn_proximity_city`.`region_5`, `cn_proximity_city`.`city_code_6`, `cn_proximity_city`.`city_6`, `cn_proximity_city`.`region_6`, `cn_proximity_city`.`city_code_7`, `cn_proximity_city`.`city_7`, `cn_proximity_city`.`region_7`, `cn_proximity_city`.`city_code_8`, `cn_proximity_city`.`city_8`, `cn_proximity_city`.`region_8`, `cn_proximity_city`.`city_code_9`, `cn_proximity_city`.`city_9`, `cn_proximity_city`.`region_9`, `cn_proximity_city`.`city_code_10`, `cn_proximity_city`.`city_10`, `cn_proximity_city`.`region_10`, `cn_proximity_city`.`city_code_11`, `cn_proximity_city`.`city_11`, `cn_proximity_city`.`region_11`, `cn_proximity_city`.`city_code_12`, `cn_proximity_city`.`city_12`, `cn_proximity_city`.`region_12`, `cn_proximity_city`.`city_code_13`, `cn_proximity_city`.`city_13`, `cn_proximity_city`.`region_13`, `cn_proximity_city`.`city_code_14`, `cn_proximity_city`.`city_14`, `cn_proximity_city`.`region_14`, `cn_proximity_city`.`city_code_15`, `cn_proximity_city`.`city_15`, `cn_proximity_city`.`region_15`, `cn_proximity_city`.`city_code_16`, `cn_proximity_city`.`city_16`, `cn_proximity_city`.`region_16`, `cn_proximity_city`.`city_code_17`, `cn_proximity_city`.`city_17`, `cn_proximity_city`.`region_17`, `cn_proximity_city`.`city_code_18`, `cn_proximity_city`.`city_18`, `cn_proximity_city`.`region_18`, `cn_proximity_city`.`city_code_19`, `cn_proximity_city`.`city_19`, `cn_proximity_city`.`region_19`, `cn_proximity_city`.`city_code_20`, `cn_proximity_city`.`city_20`, `cn_proximity_city`.`region_20`, `cn_proximity_city`.`city_code_21`, `cn_proximity_city`.`city_21`, `cn_proximity_city`.`region_21` FROM `geo_db_cn`.`cn_proximity_city` WHERE city_code='451548' [Execution Time: 0.001 Seconds]
SELECT city_code, name_en FROM geo_db_cn.cn_city2 WHERE city_code IN (374026,404673,420491,442562,470156,439104,438734,441548,400465,436667,413132,381966,416024,412627,380093,447744,447688,447752,476662,401964,432638) [Execution Time: 0.001 Seconds]
SELECT `cn_proximity_city`.`city_code`, `cn_proximity_city`.`city_code_1`, `cn_proximity_city`.`city_1`, `cn_proximity_city`.`region_1`, `cn_proximity_city`.`city_code_2`, `cn_proximity_city`.`city_2`, `cn_proximity_city`.`region_2`, `cn_proximity_city`.`city_code_3`, `cn_proximity_city`.`city_3`, `cn_proximity_city`.`region_3`, `cn_proximity_city`.`city_code_4`, `cn_proximity_city`.`city_4`, `cn_proximity_city`.`region_4`, `cn_proximity_city`.`city_code_5`, `cn_proximity_city`.`city_5`, `cn_proximity_city`.`region_5`, `cn_proximity_city`.`city_code_6`, `cn_proximity_city`.`city_6`, `cn_proximity_city`.`region_6`, `cn_proximity_city`.`city_code_7`, `cn_proximity_city`.`city_7`, `cn_proximity_city`.`region_7`, `cn_proximity_city`.`city_code_8`, `cn_proximity_city`.`city_8`, `cn_proximity_city`.`region_8`, `cn_proximity_city`.`city_code_9`, `cn_proximity_city`.`city_9`, `cn_proximity_city`.`region_9`, `cn_proximity_city`.`city_code_10`, `cn_proximity_city`.`city_10`, `cn_proximity_city`.`region_10`, `cn_proximity_city`.`city_code_11`, `cn_proximity_city`.`city_11`, `cn_proximity_city`.`region_11`, `cn_proximity_city`.`city_code_12`, `cn_proximity_city`.`city_12`, `cn_proximity_city`.`region_12`, `cn_proximity_city`.`city_code_13`, `cn_proximity_city`.`city_13`, `cn_proximity_city`.`region_13`, `cn_proximity_city`.`city_code_14`, `cn_proximity_city`.`city_14`, `cn_proximity_city`.`region_14`, `cn_proximity_city`.`city_code_15`, `cn_proximity_city`.`city_15`, `cn_proximity_city`.`region_15`, `cn_proximity_city`.`city_code_16`, `cn_proximity_city`.`city_16`, `cn_proximity_city`.`region_16`, `cn_proximity_city`.`city_code_17`, `cn_proximity_city`.`city_17`, `cn_proximity_city`.`region_17`, `cn_proximity_city`.`city_code_18`, `cn_proximity_city`.`city_18`, `cn_proximity_city`.`region_18`, `cn_proximity_city`.`city_code_19`, `cn_proximity_city`.`city_19`, `cn_proximity_city`.`region_19`, `cn_proximity_city`.`city_code_20`, `cn_proximity_city`.`city_20`, `cn_proximity_city`.`region_20`, `cn_proximity_city`.`city_code_21`, `cn_proximity_city`.`city_21`, `cn_proximity_city`.`region_21` FROM `geo_db_cn`.`cn_proximity_city` WHERE city_code='451548' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (451548, 374026, 404673, 420491, 442562, 470156, 439104, 438734, 441548, 400465, 436667, 413132, 381966, 416024, 412627, 380093, 447744, 447688, 447752, 476662, 401964, 432638) [Execution Time: 0.001 Seconds]
SELECT `cn_proximity_city`.`city_code`, `cn_proximity_city`.`city_code_1`, `cn_proximity_city`.`city_1`, `cn_proximity_city`.`region_1`, `cn_proximity_city`.`city_code_2`, `cn_proximity_city`.`city_2`, `cn_proximity_city`.`region_2`, `cn_proximity_city`.`city_code_3`, `cn_proximity_city`.`city_3`, `cn_proximity_city`.`region_3`, `cn_proximity_city`.`city_code_4`, `cn_proximity_city`.`city_4`, `cn_proximity_city`.`region_4`, `cn_proximity_city`.`city_code_5`, `cn_proximity_city`.`city_5`, `cn_proximity_city`.`region_5`, `cn_proximity_city`.`city_code_6`, `cn_proximity_city`.`city_6`, `cn_proximity_city`.`region_6`, `cn_proximity_city`.`city_code_7`, `cn_proximity_city`.`city_7`, `cn_proximity_city`.`region_7`, `cn_proximity_city`.`city_code_8`, `cn_proximity_city`.`city_8`, `cn_proximity_city`.`region_8`, `cn_proximity_city`.`city_code_9`, `cn_proximity_city`.`city_9`, `cn_proximity_city`.`region_9`, `cn_proximity_city`.`city_code_10`, `cn_proximity_city`.`city_10`, `cn_proximity_city`.`region_10`, `cn_proximity_city`.`city_code_11`, `cn_proximity_city`.`city_11`, `cn_proximity_city`.`region_11`, `cn_proximity_city`.`city_code_12`, `cn_proximity_city`.`city_12`, `cn_proximity_city`.`region_12`, `cn_proximity_city`.`city_code_13`, `cn_proximity_city`.`city_13`, `cn_proximity_city`.`region_13`, `cn_proximity_city`.`city_code_14`, `cn_proximity_city`.`city_14`, `cn_proximity_city`.`region_14`, `cn_proximity_city`.`city_code_15`, `cn_proximity_city`.`city_15`, `cn_proximity_city`.`region_15`, `cn_proximity_city`.`city_code_16`, `cn_proximity_city`.`city_16`, `cn_proximity_city`.`region_16`, `cn_proximity_city`.`city_code_17`, `cn_proximity_city`.`city_17`, `cn_proximity_city`.`region_17`, `cn_proximity_city`.`city_code_18`, `cn_proximity_city`.`city_18`, `cn_proximity_city`.`region_18`, `cn_proximity_city`.`city_code_19`, `cn_proximity_city`.`city_19`, `cn_proximity_city`.`region_19`, `cn_proximity_city`.`city_code_20`, `cn_proximity_city`.`city_20`, `cn_proximity_city`.`region_20`, `cn_proximity_city`.`city_code_21`, `cn_proximity_city`.`city_21`, `cn_proximity_city`.`region_21` FROM `geo_db_cn`.`cn_proximity_city` WHERE city_code='451548' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (451548, 374026, 404673, 420491, 442562, 470156, 439104, 438734, 441548, 400465, 436667, 413132, 381966, 416024, 412627, 380093, 447744, 447688, 447752, 476662, 401964, 432638) [Execution Time: 0 Seconds]
replace into meteo_cn.cn_meteo_histo values (27.99942, 120.66682, curdate(), 'Sunny', '20', '30', '14', '60', '0.0', 'SE', '7', '17:53', '06:34', '', '0', '0') [Execution Time: 0 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_cn.cn_city_rate WHERE latitude=28.47 AND longitude=121.19778 [Execution Time: 0.001 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='cn' AND code_region='02' [Execution Time: 0.001 Seconds]
SELECT `cn_city2`.`city_code`, `cn_city2`.`country_code`, `cn_city2`.`format_name`, `cn_city2`.`name`, `cn_city2`.`code_region`, `cn_city2`.`population`, `cn_city2`.`latitude`, `cn_city2`.`longitude`, `cn_city2`.`elevation`, `cn_city2`.`capital`, `cn_city2`.`name_en`, `cn_city2`.`name_fr`, `cn_city2`.`name_de`, `cn_city2`.`name_it`, `cn_city2`.`name_pl`, `cn_city2`.`name_es`, `cn_city2`.`name_pt`, `cn_city2`.`name_ru`, `cn_city2`.`name_hi`, `cn_city2`.`name_cn`, `cn_city2`.`name_jp`, `cn_city2`.`name_ar`, `cn_city2`.`postal_code`, `cn_city2`.`link`, `cn_city2`.`geonames_nb_cities_found`, `cn_city2`.`is_geonames_data`, `cn_city2`.`geonames_id`, `cn_city2`.`geonames_date`, `cn_city2`.`latitude_orig`, `cn_city2`.`longitude_orig`, `cn_city2`.`parent_city_code`, `cn_city2`.`is_city_created_manually`, `cn_city2`.`is_duplicate_url_detected`, `cn_city2`.`is_histo_rate_migrate`, `cn_city2`.`pic_json`, `cn_city2`.`pic_json_date`, `cn_city2`.`nb_news`, `cn_city2`.`pic_json_validated`, `cn_city2`.`pic_json_date_validated` FROM `geo_db_cn`.`cn_city2` WHERE city_code IN (431839,2699388,402027,475101) ORDER BY rand() ASC [Execution Time: 0.001 Seconds]
SELECT `cn_link_city`.`ctr`, `cn_link_city`.`region`, `cn_link_city`.`city`, `cn_link_city`.`city_code`, `cn_link_city`.`region_name`, `cn_link_city`.`latitude_30`, `cn_link_city`.`longitude_30`, `cn_link_city`.`population_30`, `cn_link_city`.`latitude_120`, `cn_link_city`.`longitude_120`, `cn_link_city`.`population_120`, `cn_link_city`.`is_proximity_city` FROM `geo_db_cn`.`cn_link_city` WHERE ctr='cn' AND region='zhejiang' AND city='shangyu' [Execution Time: 0.001 Seconds]
SELECT `cn_link_city`.`ctr`, `cn_link_city`.`region`, `cn_link_city`.`city`, `cn_link_city`.`city_code`, `cn_link_city`.`region_name`, `cn_link_city`.`latitude_30`, `cn_link_city`.`longitude_30`, `cn_link_city`.`population_30`, `cn_link_city`.`latitude_120`, `cn_link_city`.`longitude_120`, `cn_link_city`.`population_120`, `cn_link_city`.`is_proximity_city` FROM `geo_db_cn`.`cn_link_city` WHERE ctr='cn' AND region='zhejiang' AND city='yuyao' [Execution Time: 0.001 Seconds]
SELECT `cn_link_city`.`ctr`, `cn_link_city`.`region`, `cn_link_city`.`city`, `cn_link_city`.`city_code`, `cn_link_city`.`region_name`, `cn_link_city`.`latitude_30`, `cn_link_city`.`longitude_30`, `cn_link_city`.`population_30`, `cn_link_city`.`latitude_120`, `cn_link_city`.`longitude_120`, `cn_link_city`.`population_120`, `cn_link_city`.`is_proximity_city` FROM `geo_db_cn`.`cn_link_city` WHERE ctr='cn' AND region='zhejiang' AND city='puyangchen' [Execution Time: 0.001 Seconds]
SELECT `cn_link_city`.`ctr`, `cn_link_city`.`region`, `cn_link_city`.`city`, `cn_link_city`.`city_code`, `cn_link_city`.`region_name`, `cn_link_city`.`latitude_30`, `cn_link_city`.`longitude_30`, `cn_link_city`.`population_30`, `cn_link_city`.`latitude_120`, `cn_link_city`.`longitude_120`, `cn_link_city`.`population_120`, `cn_link_city`.`is_proximity_city` FROM `geo_db_cn`.`cn_link_city` WHERE ctr='cn' AND region='zhejiang' AND city='huzhou' [Execution Time: 0.001 Seconds]
SELECT `nameday`.`country_code`, `nameday`.`month`, `nameday`.`day`, `nameday`.`name` FROM `meteo`.`nameday` WHERE country_code='EN' AND month=10 AND day=19 [Execution Time: 0.001 Seconds]
Execution Time End Load ...: 0.277 Seconds
Execution Time Variables ...: 0.277 Seconds
Execution Time End Variables: 0.277 Seconds
Execution Time Callback ...: 0.277 Seconds
Execution Time End Callback: 0.277 Seconds
Execution Time Loaded ...: 0.277 Seconds
Execution Time End Loaded: 0.277 Seconds
Execution Time Page Header ...: 0.277 Seconds
Execution Time End Page Header ...: 0.278 Seconds
Execution Time Render ...: 0.278 Seconds
Execution Time End Render: 0.297 Seconds