SHOW FULL COLUMNS FROM `fm_area` [ RunTime:0.000724s ]
SELECT `id`,`code` FROM `fm_area` WHERE `grade` = 1 AND `pinyin` = 'tianjin' LIMIT 1 [ RunTime:0.000276s ]
SELECT `id`,`country`,`pinyin`,`code` FROM `fm_area` WHERE `grade` = 2 AND `code` BETWEEN '120100' AND '120199' ORDER BY `id` ASC LIMIT 0,99 [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `fm_baike` [ RunTime:0.000670s ]
SHOW FULL COLUMNS FROM `fm_baike_category` [ RunTime:0.000592s ]
SELECT `category_id`,`category_name`,`pid` FROM `fm_baike_category` WHERE `is_del` = 0 ORDER BY `sort` ASC LIMIT 0,99 [ RunTime:0.000240s ]
SHOW FULL COLUMNS FROM `fm_house` [ RunTime:0.001008s ]
SELECT `code`,`province`,`city`,`country` FROM `fm_area` WHERE `code` IN ('120103','120104','120105','120106','120116','120110','120111','120113','120112','120114','120115') LIMIT 0,10 [ RunTime:0.000391s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120103 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000371s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120104 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` = 120105 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000337s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120106 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000336s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120116 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` = 120110 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000332s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120111 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000332s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120113 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000366s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120112 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000347s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120114 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000335s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120115 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `fm_information` [ RunTime:0.000807s ]
SELECT `id`,`title`,`cover`,`abstract`,`create_time` FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 120100 ORDER BY `read_num` DESC LIMIT 0,5 [ RunTime:0.000338s ]
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.000354s ]
SELECT COUNT(*) AS think_count FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `fm_ad` [ RunTime:0.000733s ]
SELECT `id`,`key`,`value` FROM `fm_ad` WHERE `status` = 1 AND `is_del` = 0 AND `valid_time` >= 1701492439 AND `key` IN ('pc_home_1','pc_home_2') ORDER BY `id` ASC LIMIT 0,10 [ RunTime:0.001081s ]