WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Almanaque meteorológicas de Daomaguan Hebei China
JavaScript is turned off in your web browser. Turn it on to take full advantage of this site, then refresh the page.
Avisos legales | En ningún caso se podrán emprender acciones legales contra Weather Avenue en caso de previsiones erróneas.
En el marco de difusión de anuncios o estadísticas, esta página puede almacenar información en su navegador a través de cookies. Copyright © 2011-2024 Weather Avenue
Versión móvil
DEBUG Page almanac.php: Execution Time Init WSP ...: 0 Seconds
Execution Time End Init WSP: 0.036 Seconds
Execution Time Create Page ...: 0.036 Seconds
Execution Time End Create Page: 0.036 Seconds
Execution Time InitializeComponent ...: 0.036 Seconds
Execution Time End InitializeComponent ...: 0.036 Seconds
Execution Time Load ...: 0.036 Seconds
SELECT DISTINCT c.city_code, c.latitude, c.longitude, c.format_name, c.name, c.name_es, 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_es, 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 = 'hebei'
AND lc.city = 'daomaguan'
[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='379077' [Execution Time: 0.001 Seconds]
SELECT city_code, name_es FROM geo_db_cn.cn_city2 WHERE city_code IN (478104,454719,454529,454515,454514,479164,375705,424165,424163,431457,437106,403601) [Execution Time: 0 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='379077' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (379077, 478104, 454719, 454529, 454515, 454514, 479164, 375705, 424165, 424163, 431457, 437106, 403601) [Execution Time: 0 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='379077' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (379077, 478104, 454719, 454529, 454515, 454514, 479164, 375705, 424165, 424163, 431457, 437106, 403601) [Execution Time: 0 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_cn.cn_city_rate WHERE latitude=39.08722 AND longitude=114.62361 [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=38.85111 and longitude=115.49028
UNION
SELECT date date, max max, min min
FROM meteo_cn.cn_meteo_histo_old
WHERE latitude=38.85111 and longitude=115.49028
) 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=38.85111 and longitude=115.49028 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=38.85111 and longitude=115.49028 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='cn' AND code_region='10' [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 (441171,449479,410434,414233) 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='hebei' AND city='shihjiazhuang' [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='cn' AND region='hebei' AND city='langfang' [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='cn' AND region='hebei' AND city='tangshan' [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='cn' AND region='hebei' AND city='linshui' [Execution Time: 0 Seconds]
SELECT `nameday`.`country_code`, `nameday`.`month`, `nameday`.`day`, `nameday`.`name` FROM `meteo`.`nameday` WHERE country_code='ES' AND month=10 AND day=21 [Execution Time: 0 Seconds]
Execution Time End Load ...: 0.592 Seconds
Execution Time Variables ...: 0.592 Seconds
Execution Time End Variables: 0.592 Seconds
Execution Time Callback ...: 0.592 Seconds
Execution Time End Callback: 0.592 Seconds
Execution Time Loaded ...: 0.592 Seconds
Execution Time End Loaded: 0.592 Seconds
Execution Time Page Header ...: 0.592 Seconds
Execution Time End Page Header ...: 0.592 Seconds
Execution Time Render ...: 0.592 Seconds
Execution Time End Render: 0.603 Seconds