WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Fairmount 麻薩諸塞州 美国 城市天气年鉴
Fairmount 麻薩諸塞州 美国 气候的平均值和记录
月份
|
最高温度
|
最低温度
|
平均温度
|
九月
|
29°C
|
12°C
|
18°C
|
十月
|
24°C
|
4°C
|
13°C
|
天气 Fairmount
图片 Fairmount
日出 Fairmount
完整网页版本
DEBUG Page almanac.php: Execution Time Init WSP ...: 0 Seconds
Execution Time End Init WSP: 0.029 Seconds
Execution Time Create Page ...: 0.029 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_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 = 'massachusetts'
AND lc.city = 'fairmount'
[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='2492437' [Execution Time: 0.001 Seconds]
SELECT city_code, name_cn FROM geo_db_us.us_city2 WHERE city_code IN (2492688,2491970,2492941,2493333,2493623,2492109,2492202,2492939,2492877,2493334,2491860,2492341,2492977,2492942,2492938,2493860,2492427,2492287,2492810,2493385,2492480) [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='2492437' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_us`.`us_news` WHERE code_ville in (2492437, 2492688, 2491970, 2492941, 2493333, 2493623, 2492109, 2492202, 2492939, 2492877, 2493334, 2491860, 2492341, 2492977, 2492942, 2492938, 2493860, 2492427, 2492287, 2492810, 2493385, 2492480) [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='2492437' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_us`.`us_news` WHERE code_ville in (2492437, 2492688, 2491970, 2492941, 2493333, 2493623, 2492109, 2492202, 2492939, 2492877, 2493334, 2491860, 2492341, 2492977, 2492942, 2492938, 2493860, 2492427, 2492287, 2492810, 2493385, 2492480) [Execution Time: 0 Seconds]
SELECT month(X.date) month,
concat(round(max(X.max)), '°C') avg_max,
concat(round(min(X.min)), '°C') avg_min,
concat(round((avg(X.max)+avg(X.min))/2), '°C') avg
FROM (
SELECT date date, max max, min min
FROM meteo_us.us_meteo_histo
WHERE latitude=42.35843 and longitude=-71.05977
UNION
SELECT date date, max max, min min
FROM meteo_us.us_meteo_histo_old
WHERE latitude=42.35843 and longitude=-71.05977
) X
GROUP BY month(X.date)
ORDER BY month(X.date) ASC [Execution Time: 0.001 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.158 Seconds
Execution Time Variables ...: 0.158 Seconds
Execution Time End Variables: 0.158 Seconds
Execution Time Callback ...: 0.158 Seconds
Execution Time End Callback: 0.158 Seconds
Execution Time Loaded ...: 0.158 Seconds
Execution Time End Loaded: 0.158 Seconds
Execution Time Page Header ...: 0.158 Seconds
Execution Time End Page Header ...: 0.158 Seconds
Execution Time Render ...: 0.158 Seconds
Execution Time End Render: 0.163 Seconds