SHOW FULL COLUMNS FROM `fm_area` [ RunTime:0.001045s ]
SELECT `id`,`code` FROM `fm_area` WHERE `grade` = 1 AND `pinyin` = 'suzhou' LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`country`,`pinyin`,`code` FROM `fm_area` WHERE `grade` = 2 AND `code` BETWEEN '320500' AND '320599' ORDER BY `id` ASC LIMIT 0,99 [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `fm_baike` [ RunTime:0.000807s ]
SHOW FULL COLUMNS FROM `fm_baike_category` [ RunTime:0.000737s ]
SELECT `category_id`,`category_name`,`pid` FROM `fm_baike_category` WHERE `is_del` = 0 ORDER BY `sort` ASC LIMIT 0,99 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `fm_house` [ RunTime:0.001016s ]
SELECT `code`,`province`,`city`,`country` FROM `fm_area` WHERE `code` IN ('320581','320583','320585','320584','320582','320508','320505','320506','320507','320540') LIMIT 0,10 [ RunTime:0.000408s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320581 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000369s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320583 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000367s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320585 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000364s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320584 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000350s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320582 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000358s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320508 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000377s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320505 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000362s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320506 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000359s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320507 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000346s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320540 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `fm_information` [ RunTime:0.000781s ]
SELECT `id`,`title`,`cover`,`abstract`,`create_time` FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 320500 ORDER BY `read_num` DESC LIMIT 0,5 [ RunTime:0.000355s ]
SELECT `id`,`title`,`cover`,`abstract`,`create_time`,`type` FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 ORDER BY `create_time` DESC LIMIT 0,4 [ RunTime:0.000355s ]
SELECT COUNT(*) AS think_count FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000313s ]
SHOW FULL COLUMNS FROM `fm_ad` [ RunTime:0.000743s ]
SELECT `id`,`key`,`value` FROM `fm_ad` WHERE `status` = 1 AND `is_del` = 0 AND `valid_time` >= 1701881663 AND `key` IN ('pc_home_1','pc_home_2') ORDER BY `id` ASC LIMIT 0,10 [ RunTime:0.000530s ]