WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Weather Mentengpulo Jakarta Indonesia
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.02 Seconds
Execution Time Create Page ...: 0.02 Seconds
Execution Time End Create Page: 0.02 Seconds
Execution Time InitializeComponent ...: 0.02 Seconds
Execution Time End InitializeComponent ...: 0.02 Seconds
Execution Time Load ...: 0.02 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 = 'id'
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 = 'jakarta'
AND lc.city = 'mentengpulo'
[Execution Time: 4.621 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='979637' [Execution Time: 0.002 Seconds]
SELECT city_code, name_en FROM geo_db_cn.cn_city2 WHERE city_code IN (978309,969131,969362,969360,989804,983481,984354,983482,979638,999448,999447,979634) [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='979637' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (979637, 978309, 969131, 969362, 969360, 989804, 983481, 984354, 983482, 979638, 999448, 999447, 979634) [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='979637' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (979637, 978309, 969131, 969362, 969360, 989804, 983481, 984354, 983482, 979638, 999448, 999447, 979634) [Execution Time: 0 Seconds]
replace into meteo_cn.cn_meteo_histo values (-6.1744444, 106.8294444, curdate(), 'Clear ', '28', '33', '14', '62', '0.0', 'NNW', '4', '19:38', '06:47', '', '0', '0') [Execution Time: 0 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_cn.cn_city_rate WHERE latitude=-6.2208333 AND longitude=106.8425 [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='id' AND code_region='06' [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 (966965,983626,999296,959480) 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='id' AND region='jakarta' AND city='tasikmalaya' [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='id' AND region='jakarta' AND city='cibitung' [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='id' AND region='jakarta' AND city='pacet' [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='id' AND region='jakarta' AND city='jakarta' [Execution Time: 0 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 ...: 4.864 Seconds
Execution Time Variables ...: 4.864 Seconds
Execution Time End Variables: 4.864 Seconds
Execution Time Callback ...: 4.864 Seconds
Execution Time End Callback: 4.864 Seconds
Execution Time Loaded ...: 4.864 Seconds
Execution Time End Loaded: 4.864 Seconds
Execution Time Page Header ...: 4.864 Seconds
Execution Time End Page Header ...: 4.864 Seconds
Execution Time Render ...: 4.864 Seconds
Execution Time End Render: 4.878 Seconds