SHOW FULL COLUMNS FROM `fm_area` [ RunTime:0.001046s ]
SELECT `id`,`code` FROM `fm_area` WHERE `grade` = 1 AND `pinyin` = 'chengdu' LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`country`,`pinyin`,`code` FROM `fm_area` WHERE `grade` = 2 AND `code` BETWEEN '510100' AND '510199' ORDER BY `id` ASC LIMIT 0,99 [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `fm_baike` [ RunTime:0.000874s ]
SHOW FULL COLUMNS FROM `fm_baike_category` [ RunTime:0.000713s ]
SELECT `category_id`,`category_name`,`pid` FROM `fm_baike_category` WHERE `is_del` = 0 ORDER BY `sort` ASC LIMIT 0,99 [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `fm_house` [ RunTime:0.001018s ]
SELECT `code`,`province`,`city`,`country` FROM `fm_area` WHERE `code` IN ('510184','510129','510181','510121','510182','510131','510122','510132','510183','510124','510104','510105','510106','510107','510108','510112','510113','510114','510115','510140') LIMIT 0,10 [ RunTime:0.005447s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510184 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000471s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510129 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000926s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510181 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.001072s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510121 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000474s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510182 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.001314s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510131 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.001259s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510122 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000797s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510132 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000376s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510183 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000431s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510124 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.001012s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510104 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000417s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510105 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000404s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510106 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000372s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510107 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000357s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510108 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000376s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510112 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000997s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510113 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000420s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510114 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000518s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510115 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000758s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510140 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `fm_information` [ RunTime:0.000732s ]
SELECT `id`,`title`,`cover`,`abstract`,`create_time` FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 510100 ORDER BY `read_num` DESC LIMIT 0,5 [ RunTime:0.000544s ]
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.000289s ]
SELECT COUNT(*) AS think_count FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000259s ]
SHOW FULL COLUMNS FROM `fm_ad` [ RunTime:0.000632s ]
SELECT `id`,`key`,`value` FROM `fm_ad` WHERE `status` = 1 AND `is_del` = 0 AND `valid_time` >= 1701393345 AND `key` IN ('pc_home_1','pc_home_2') ORDER BY `id` ASC LIMIT 0,10 [ RunTime:0.000431s ]