WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
天气 Pilgrim Gardens 宾夕法尼亚州 美国
DEBUG Page meteo.php: Execution Time Init WSP ...: 0 Seconds
Execution Time End Init WSP: 0.015 Seconds
Execution Time Create Page ...: 0.015 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_cn, 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_cn, c.pic_json, c.pic_json_validated, c.nb_news
FROM geo_db_us.us_link_city lc
INNER JOIN geo_db_us.us_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 = 'us'
AND lc.ctr IN ('AG','AR','BS','BB','BZ','BO','BR','CA','CL','CO','CR','CU','DO','DM','EC','US','GD','GT','GY','HT','HN','JM','MX','NI','PA','PY','PE','KN','LC','VC','SV','SR','TT','UY','VE','MQ','GP','GF','BM','AI','AW','KY','FK','GS','GL','VG','MS','PM')
AND lc.region = 'pennsylvania'
AND lc.city = 'pilgrim-gardens'
[Execution Time: 0.001 Seconds]
SELECT `us_proximity_city`.`city_code`, `us_proximity_city`.`city_code_1`, `us_proximity_city`.`city_1`, `us_proximity_city`.`region_1`, `us_proximity_city`.`city_code_2`, `us_proximity_city`.`city_2`, `us_proximity_city`.`region_2`, `us_proximity_city`.`city_code_3`, `us_proximity_city`.`city_3`, `us_proximity_city`.`region_3`, `us_proximity_city`.`city_code_4`, `us_proximity_city`.`city_4`, `us_proximity_city`.`region_4`, `us_proximity_city`.`city_code_5`, `us_proximity_city`.`city_5`, `us_proximity_city`.`region_5`, `us_proximity_city`.`city_code_6`, `us_proximity_city`.`city_6`, `us_proximity_city`.`region_6`, `us_proximity_city`.`city_code_7`, `us_proximity_city`.`city_7`, `us_proximity_city`.`region_7`, `us_proximity_city`.`city_code_8`, `us_proximity_city`.`city_8`, `us_proximity_city`.`region_8`, `us_proximity_city`.`city_code_9`, `us_proximity_city`.`city_9`, `us_proximity_city`.`region_9`, `us_proximity_city`.`city_code_10`, `us_proximity_city`.`city_10`, `us_proximity_city`.`region_10`, `us_proximity_city`.`city_code_11`, `us_proximity_city`.`city_11`, `us_proximity_city`.`region_11`, `us_proximity_city`.`city_code_12`, `us_proximity_city`.`city_12`, `us_proximity_city`.`region_12`, `us_proximity_city`.`city_code_13`, `us_proximity_city`.`city_13`, `us_proximity_city`.`region_13`, `us_proximity_city`.`city_code_14`, `us_proximity_city`.`city_14`, `us_proximity_city`.`region_14`, `us_proximity_city`.`city_code_15`, `us_proximity_city`.`city_15`, `us_proximity_city`.`region_15`, `us_proximity_city`.`city_code_16`, `us_proximity_city`.`city_16`, `us_proximity_city`.`region_16`, `us_proximity_city`.`city_code_17`, `us_proximity_city`.`city_17`, `us_proximity_city`.`region_17`, `us_proximity_city`.`city_code_18`, `us_proximity_city`.`city_18`, `us_proximity_city`.`region_18`, `us_proximity_city`.`city_code_19`, `us_proximity_city`.`city_19`, `us_proximity_city`.`region_19`, `us_proximity_city`.`city_code_20`, `us_proximity_city`.`city_20`, `us_proximity_city`.`region_20`, `us_proximity_city`.`city_code_21`, `us_proximity_city`.`city_21`, `us_proximity_city`.`region_21` FROM `geo_db_us`.`us_proximity_city` WHERE city_code='2539110' [Execution Time: 0 Seconds]
SELECT city_code, name_cn FROM geo_db_us.us_city2 WHERE city_code IN (2533473,2537381,2541303,2533286,2537796,2533289,2537572,2541385,2535996,2540362,2535191,2536462) [Execution Time: 0 Seconds]
SELECT `us_proximity_city`.`city_code`, `us_proximity_city`.`city_code_1`, `us_proximity_city`.`city_1`, `us_proximity_city`.`region_1`, `us_proximity_city`.`city_code_2`, `us_proximity_city`.`city_2`, `us_proximity_city`.`region_2`, `us_proximity_city`.`city_code_3`, `us_proximity_city`.`city_3`, `us_proximity_city`.`region_3`, `us_proximity_city`.`city_code_4`, `us_proximity_city`.`city_4`, `us_proximity_city`.`region_4`, `us_proximity_city`.`city_code_5`, `us_proximity_city`.`city_5`, `us_proximity_city`.`region_5`, `us_proximity_city`.`city_code_6`, `us_proximity_city`.`city_6`, `us_proximity_city`.`region_6`, `us_proximity_city`.`city_code_7`, `us_proximity_city`.`city_7`, `us_proximity_city`.`region_7`, `us_proximity_city`.`city_code_8`, `us_proximity_city`.`city_8`, `us_proximity_city`.`region_8`, `us_proximity_city`.`city_code_9`, `us_proximity_city`.`city_9`, `us_proximity_city`.`region_9`, `us_proximity_city`.`city_code_10`, `us_proximity_city`.`city_10`, `us_proximity_city`.`region_10`, `us_proximity_city`.`city_code_11`, `us_proximity_city`.`city_11`, `us_proximity_city`.`region_11`, `us_proximity_city`.`city_code_12`, `us_proximity_city`.`city_12`, `us_proximity_city`.`region_12`, `us_proximity_city`.`city_code_13`, `us_proximity_city`.`city_13`, `us_proximity_city`.`region_13`, `us_proximity_city`.`city_code_14`, `us_proximity_city`.`city_14`, `us_proximity_city`.`region_14`, `us_proximity_city`.`city_code_15`, `us_proximity_city`.`city_15`, `us_proximity_city`.`region_15`, `us_proximity_city`.`city_code_16`, `us_proximity_city`.`city_16`, `us_proximity_city`.`region_16`, `us_proximity_city`.`city_code_17`, `us_proximity_city`.`city_17`, `us_proximity_city`.`region_17`, `us_proximity_city`.`city_code_18`, `us_proximity_city`.`city_18`, `us_proximity_city`.`region_18`, `us_proximity_city`.`city_code_19`, `us_proximity_city`.`city_19`, `us_proximity_city`.`region_19`, `us_proximity_city`.`city_code_20`, `us_proximity_city`.`city_20`, `us_proximity_city`.`region_20`, `us_proximity_city`.`city_code_21`, `us_proximity_city`.`city_21`, `us_proximity_city`.`region_21` FROM `geo_db_us`.`us_proximity_city` WHERE city_code='2539110' [Execution Time: 0 Seconds]
SELECT COUNT(*) FROM `meteo_us`.`us_news` WHERE code_ville in (2539110, 2533473, 2537381, 2541303, 2533286, 2537796, 2533289, 2537572, 2541385, 2535996, 2540362, 2535191, 2536462) [Execution Time: 0 Seconds]
SELECT `us_proximity_city`.`city_code`, `us_proximity_city`.`city_code_1`, `us_proximity_city`.`city_1`, `us_proximity_city`.`region_1`, `us_proximity_city`.`city_code_2`, `us_proximity_city`.`city_2`, `us_proximity_city`.`region_2`, `us_proximity_city`.`city_code_3`, `us_proximity_city`.`city_3`, `us_proximity_city`.`region_3`, `us_proximity_city`.`city_code_4`, `us_proximity_city`.`city_4`, `us_proximity_city`.`region_4`, `us_proximity_city`.`city_code_5`, `us_proximity_city`.`city_5`, `us_proximity_city`.`region_5`, `us_proximity_city`.`city_code_6`, `us_proximity_city`.`city_6`, `us_proximity_city`.`region_6`, `us_proximity_city`.`city_code_7`, `us_proximity_city`.`city_7`, `us_proximity_city`.`region_7`, `us_proximity_city`.`city_code_8`, `us_proximity_city`.`city_8`, `us_proximity_city`.`region_8`, `us_proximity_city`.`city_code_9`, `us_proximity_city`.`city_9`, `us_proximity_city`.`region_9`, `us_proximity_city`.`city_code_10`, `us_proximity_city`.`city_10`, `us_proximity_city`.`region_10`, `us_proximity_city`.`city_code_11`, `us_proximity_city`.`city_11`, `us_proximity_city`.`region_11`, `us_proximity_city`.`city_code_12`, `us_proximity_city`.`city_12`, `us_proximity_city`.`region_12`, `us_proximity_city`.`city_code_13`, `us_proximity_city`.`city_13`, `us_proximity_city`.`region_13`, `us_proximity_city`.`city_code_14`, `us_proximity_city`.`city_14`, `us_proximity_city`.`region_14`, `us_proximity_city`.`city_code_15`, `us_proximity_city`.`city_15`, `us_proximity_city`.`region_15`, `us_proximity_city`.`city_code_16`, `us_proximity_city`.`city_16`, `us_proximity_city`.`region_16`, `us_proximity_city`.`city_code_17`, `us_proximity_city`.`city_17`, `us_proximity_city`.`region_17`, `us_proximity_city`.`city_code_18`, `us_proximity_city`.`city_18`, `us_proximity_city`.`region_18`, `us_proximity_city`.`city_code_19`, `us_proximity_city`.`city_19`, `us_proximity_city`.`region_19`, `us_proximity_city`.`city_code_20`, `us_proximity_city`.`city_20`, `us_proximity_city`.`region_20`, `us_proximity_city`.`city_code_21`, `us_proximity_city`.`city_21`, `us_proximity_city`.`region_21` FROM `geo_db_us`.`us_proximity_city` WHERE city_code='2539110' [Execution Time: 0 Seconds]
SELECT COUNT(*) FROM `meteo_us`.`us_news` WHERE code_ville in (2539110, 2533473, 2537381, 2541303, 2533286, 2537796, 2533289, 2537572, 2541385, 2535996, 2540362, 2535191, 2536462) [Execution Time: 0 Seconds]
replace into meteo_us.us_meteo_histo values (39.95234, -75.16379, curdate(), 'Partly cloudy', '7', '22', '25', '56', '0.0', 'N', '10', '18:52', '08:40', '', '0', '0') [Execution Time: 0 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_us.us_city_rate WHERE latitude=39.9563889 AND longitude=-75.3247222 [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='us' AND code_region='PA' [Execution Time: 0 Seconds]
SELECT `us_city2`.`city_code`, `us_city2`.`country_code`, `us_city2`.`format_name`, `us_city2`.`name`, `us_city2`.`code_region`, `us_city2`.`population`, `us_city2`.`latitude`, `us_city2`.`longitude`, `us_city2`.`elevation`, `us_city2`.`capital`, `us_city2`.`name_en`, `us_city2`.`name_fr`, `us_city2`.`name_de`, `us_city2`.`name_it`, `us_city2`.`name_pl`, `us_city2`.`name_es`, `us_city2`.`name_pt`, `us_city2`.`name_ru`, `us_city2`.`name_hi`, `us_city2`.`name_cn`, `us_city2`.`name_jp`, `us_city2`.`name_ar`, `us_city2`.`postal_code`, `us_city2`.`link`, `us_city2`.`geonames_nb_cities_found`, `us_city2`.`is_geonames_data`, `us_city2`.`geonames_id`, `us_city2`.`geonames_date`, `us_city2`.`latitude_orig`, `us_city2`.`longitude_orig`, `us_city2`.`parent_city_code`, `us_city2`.`is_city_created_manually`, `us_city2`.`is_duplicate_url_detected`, `us_city2`.`is_histo_rate_migrate`, `us_city2`.`pic_json`, `us_city2`.`pic_json_date`, `us_city2`.`nb_news`, `us_city2`.`pic_json_validated`, `us_city2`.`pic_json_date_validated` FROM `geo_db_us`.`us_city2` WHERE city_code IN (2539087,2539423,2533372,2534491) ORDER BY rand() ASC [Execution Time: 0.001 Seconds]
SELECT `us_link_city`.`ctr`, `us_link_city`.`region`, `us_link_city`.`city`, `us_link_city`.`city_code`, `us_link_city`.`region_name`, `us_link_city`.`latitude_30`, `us_link_city`.`longitude_30`, `us_link_city`.`population_30`, `us_link_city`.`latitude_120`, `us_link_city`.`longitude_120`, `us_link_city`.`population_120`, `us_link_city`.`is_proximity_city` FROM `geo_db_us`.`us_link_city` WHERE ctr='us' AND region='pennsylvania' AND city='chester' [Execution Time: 0 Seconds]
SELECT `us_link_city`.`ctr`, `us_link_city`.`region`, `us_link_city`.`city`, `us_link_city`.`city_code`, `us_link_city`.`region_name`, `us_link_city`.`latitude_30`, `us_link_city`.`longitude_30`, `us_link_city`.`population_30`, `us_link_city`.`latitude_120`, `us_link_city`.`longitude_120`, `us_link_city`.`population_120`, `us_link_city`.`is_proximity_city` FROM `geo_db_us`.`us_link_city` WHERE ctr='us' AND region='pennsylvania' AND city='philadelphia' [Execution Time: 0 Seconds]
SELECT `us_link_city`.`ctr`, `us_link_city`.`region`, `us_link_city`.`city`, `us_link_city`.`city_code`, `us_link_city`.`region_name`, `us_link_city`.`latitude_30`, `us_link_city`.`longitude_30`, `us_link_city`.`population_30`, `us_link_city`.`latitude_120`, `us_link_city`.`longitude_120`, `us_link_city`.`population_120`, `us_link_city`.`is_proximity_city` FROM `geo_db_us`.`us_link_city` WHERE ctr='us' AND region='pennsylvania' AND city='altoona' [Execution Time: 0 Seconds]
SELECT `us_link_city`.`ctr`, `us_link_city`.`region`, `us_link_city`.`city`, `us_link_city`.`city_code`, `us_link_city`.`region_name`, `us_link_city`.`latitude_30`, `us_link_city`.`longitude_30`, `us_link_city`.`population_30`, `us_link_city`.`latitude_120`, `us_link_city`.`longitude_120`, `us_link_city`.`population_120`, `us_link_city`.`is_proximity_city` FROM `geo_db_us`.`us_link_city` WHERE ctr='us' AND region='pennsylvania' AND city='reading' [Execution Time: 0 Seconds]
SELECT `nameday`.`country_code`, `nameday`.`month`, `nameday`.`day`, `nameday`.`name` FROM `meteo`.`nameday` WHERE country_code='CN' AND month=10 AND day=19 [Execution Time: 0 Seconds]
Execution Time End Load ...: 0.34 Seconds
Execution Time Variables ...: 0.34 Seconds
Execution Time End Variables: 0.34 Seconds
Execution Time Callback ...: 0.34 Seconds
Execution Time End Callback: 0.34 Seconds
Execution Time Loaded ...: 0.34 Seconds
Execution Time End Loaded: 0.34 Seconds
Execution Time Page Header ...: 0.34 Seconds
Execution Time End Page Header ...: 0.34 Seconds
Execution Time Render ...: 0.34 Seconds
Execution Time End Render: 0.354 Seconds