SHOW FULL COLUMNS FROM `xy_jingdian` [ RunTime:0.001252s ]
SELECT COUNT(*) AS think_count FROM `xy_jingdian` WHERE `zhuyeid` = 0 [ RunTime:0.018271s ]
SELECT MIN(`id`) AS think_min FROM `xy_jingdian` WHERE `zhuyeid` = 0 [ RunTime:0.018337s ]
SHOW FULL COLUMNS FROM `xy_fubiao` [ RunTime:0.001269s ]
SELECT `Jingdian`.`title`,`Jingdian`.`id`,`Fubiao`.`dlwz`,`Jingdian`.`litpic`,`Fubiao`.`jianjie` FROM `xy_jingdian` `Jingdian` INNER JOIN `xy_fubiao` `Fubiao` ON `Jingdian`.`id`=`Fubiao`.`aid` WHERE `id` IN (3155,4283,4875,5267,6049,4737) AND `zhuyeid` = 0 [ RunTime:0.000446s ]
SHOW FULL COLUMNS FROM `xy_chengshi` [ RunTime:0.001006s ]
SELECT `REGION_NAME`,`REGION_ID`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 1 [ RunTime:0.001237s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000000' [ RunTime:0.001418s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000001' [ RunTime:0.001361s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000002' [ RunTime:0.001344s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000003' [ RunTime:0.001363s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000004' [ RunTime:0.001338s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000005' [ RunTime:0.001354s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000006' [ RunTime:0.001352s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000007' [ RunTime:0.001329s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000008' [ RunTime:0.001322s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000009' [ RunTime:0.001329s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000010' [ RunTime:0.001349s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000011' [ RunTime:0.001386s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000012' [ RunTime:0.001342s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000013' [ RunTime:0.001358s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000014' [ RunTime:0.001346s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000015' [ RunTime:0.001345s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000016' [ RunTime:0.001392s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000017' [ RunTime:0.001364s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000018' [ RunTime:0.001320s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000019' [ RunTime:0.001327s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000020' [ RunTime:0.001315s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000021' [ RunTime:0.001340s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000022' [ RunTime:0.001382s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000023' [ RunTime:0.001355s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000024' [ RunTime:0.001339s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000025' [ RunTime:0.001374s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000026' [ RunTime:0.001336s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000027' [ RunTime:0.001348s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000028' [ RunTime:0.001330s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000029' [ RunTime:0.001343s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000030' [ RunTime:0.001330s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000031' [ RunTime:0.001357s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000032' [ RunTime:0.001368s ]
SELECT `REGION_ID`,`REGION_NAME`,`region_pingyin` FROM `xy_chengshi` WHERE `region_level` = 2 AND `region_parent_id` = '1000033' [ RunTime:0.001328s ]