WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Nasāpa Bāla North-West Frontier 巴基斯坦 城市天气年鉴
DEBUG Page almanac.php: Execution Time Init WSP ...: 0 Seconds
Execution Time End Init WSP: 0.024 Seconds
Execution Time Create Page ...: 0.024 Seconds
Execution Time End Create Page: 0.024 Seconds
Execution Time InitializeComponent ...: 0.024 Seconds
Execution Time End InitializeComponent ...: 0.024 Seconds
Execution Time Load ...: 0.024 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_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 = 'pk'
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 = 'north-west-frontier'
AND lc.city = 'nasapa-bala'
[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='1827306' [Execution Time: 0.001 Seconds]
SELECT city_code, name_cn FROM geo_db_cn.cn_city2 WHERE city_code IN (1827310,1827312,1797509,1797451,1797450,1817576,1832894,1814592,1814304,1841972,1843341,1817558,1814360,1815801,1834691,1834559,1785684,1807264,1785599,1785587,1819211) [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='1827306' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (1827306, 1827310, 1827312, 1797509, 1797451, 1797450, 1817576, 1832894, 1814592, 1814304, 1841972, 1843341, 1817558, 1814360, 1815801, 1834691, 1834559, 1785684, 1807264, 1785599, 1785587, 1819211) [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='1827306' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (1827306, 1827310, 1827312, 1797509, 1797451, 1797450, 1817576, 1832894, 1814592, 1814304, 1841972, 1843341, 1817558, 1814360, 1815801, 1834691, 1834559, 1785684, 1807264, 1785599, 1785587, 1819211) [Execution Time: 0.001 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_cn.cn_city_rate WHERE latitude=34.06995 AND longitude=71.59641 [Execution Time: 0 Seconds]
SELECT month(X.date) month, round(max(X.max)) avg_max, round(min(X.min)) avg_min, round((avg(X.max)+avg(X.min))/2) avg
FROM (
SELECT date date, max max, min min
FROM meteo_cn.cn_meteo_histo
WHERE latitude=34.008 and longitude=71.57849
UNION
SELECT date date, max max, min min
FROM meteo_cn.cn_meteo_histo_old
WHERE latitude=34.008 and longitude=71.57849
) X
GROUP BY month(X.date)
ORDER BY month(X.date) ASC [Execution Time: 0.001 Seconds]
SELECT day(X.date) day,concat(round(avg(X.max)), '°C') avg_max, concat(round(avg(X.min)), '°C') avg_min, concat(round((avg(X.max)+avg(X.min))/2), '°C') avg, concat(max(X.max), '°C / ', min(X.min), '°C') record, concat(round(avg(X.cloud_cover)), '%') avg_cloud_cover, concat(round(avg(X.humidity)), '%') avg_humidity, concat(round(avg(X.precipitation)), ' mm') avg_precipitation, concat(round(avg(X.wind_speed)), ' Km/h') record_wind_speed FROM (
SELECT date date, max max, min min,
cloud_cover cloud_cover, humidity humidity,
precipitation precipitation, wind_speed wind_speed
FROM meteo_cn.cn_meteo_histo
WHERE latitude=34.008 and longitude=71.57849 and month(date) = 10
UNION
SELECT date date, max max, min min,
cloud_cover cloud_cover, humidity humidity,
precipitation precipitation, wind_speed wind_speed
FROM meteo_cn.cn_meteo_histo_old
WHERE latitude=34.008 and longitude=71.57849 and month(date) = 10
) X
GROUP BY day(X.date)
ORDER BY day(X.date) ASC [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='pk' AND code_region='03' [Execution Time: 0 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 (1822412,1823831,1840763,1806032) 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='pk' AND region='north-west-frontier' AND city='haripur' [Execution Time: 0 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='pk' AND region='north-west-frontier' AND city='swabi' [Execution Time: 0 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='pk' AND region='north-west-frontier' AND city='mingora' [Execution Time: 0 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='pk' AND region='north-west-frontier' AND city='mardan' [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.521 Seconds
Execution Time Variables ...: 0.521 Seconds
Execution Time End Variables: 0.521 Seconds
Execution Time Callback ...: 0.521 Seconds
Execution Time End Callback: 0.521 Seconds
Execution Time Loaded ...: 0.521 Seconds
Execution Time End Loaded: 0.521 Seconds
Execution Time Page Header ...: 0.521 Seconds
Execution Time End Page Header ...: 0.522 Seconds
Execution Time Render ...: 0.522 Seconds
Execution Time End Render: 0.534 Seconds