WARNING: Extension runkit is not installed we cannot used the function runkit_constant_redefine !!!
Weather Tjiajunan 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.049 Seconds
Execution Time Create Page ...: 0.049 Seconds
Execution Time End Create Page: 0.049 Seconds
Execution Time InitializeComponent ...: 0.049 Seconds
Execution Time End InitializeComponent ...: 0.049 Seconds
Execution Time Load ...: 0.049 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 = 'tjiajunan'
[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='1001139' [Execution Time: 0.178 Seconds]
SELECT city_code, name_en FROM geo_db_cn.cn_city2 WHERE city_code IN (959466,1001345,1003048,959950,1001540,961246,965456,959721,966043,966042,1001589,965457,964859,997430,990132,985234,1002521,960758,985436,961119,1002860) [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='1001139' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (1001139, 959466, 1001345, 1003048, 959950, 1001540, 961246, 965456, 959721, 966043, 966042, 1001589, 965457, 964859, 997430, 990132, 985234, 1002521, 960758, 985436, 961119, 1002860) [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='1001139' [Execution Time: 0.001 Seconds]
SELECT COUNT(*) FROM `meteo_cn`.`cn_news` WHERE code_ville in (1001139, 959466, 1001345, 1003048, 959950, 1001540, 961246, 965456, 959721, 966043, 966042, 1001589, 965457, 964859, 997430, 990132, 985234, 1002521, 960758, 985436, 961119, 1002860) [Execution Time: 0.001 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.001 Seconds]
SELECT SUM(rate) / count(*) city_rate, count(*) nb_rate FROM meteo_cn.cn_city_rate WHERE latitude=-7.0333333 AND longitude=107.0333333 [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,993902) 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='pacet' [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='serang' [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='jakarta' [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.001 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 ...: 0.546 Seconds
Execution Time Variables ...: 0.546 Seconds
Execution Time End Variables: 0.546 Seconds
Execution Time Callback ...: 0.547 Seconds
Execution Time End Callback: 0.547 Seconds
Execution Time Loaded ...: 0.547 Seconds
Execution Time End Loaded: 0.547 Seconds
Execution Time Page Header ...: 0.547 Seconds
Execution Time End Page Header ...: 0.547 Seconds
Execution Time Render ...: 0.547 Seconds
Execution Time End Render: 0.571 Seconds