SHOW FULL COLUMNS FROM `fm_area` [ RunTime:0.000752s ]
SELECT `id`,`code` FROM `fm_area` WHERE `grade` = 1 AND `pinyin` = 'guangzhou' LIMIT 1 [ RunTime:0.000294s ]
SELECT `id`,`country`,`pinyin`,`code` FROM `fm_area` WHERE `grade` = 2 AND `code` BETWEEN '440100' AND '440199' ORDER BY `id` ASC LIMIT 0,99 [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `fm_baike` [ RunTime:0.000678s ]
SHOW FULL COLUMNS FROM `fm_baike_category` [ RunTime:0.000587s ]
SELECT `category_id`,`category_name`,`pid` FROM `fm_baike_category` WHERE `is_del` = 0 ORDER BY `sort` ASC LIMIT 0,99 [ RunTime:0.000252s ]
SHOW FULL COLUMNS FROM `fm_house` [ RunTime:0.000830s ]
SELECT `code`,`province`,`city`,`country` FROM `fm_area` WHERE `code` IN ('440184','440183','440103','440104','440105','440106','440112','440113','440114','440115') LIMIT 0,10 [ RunTime:0.000327s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440184 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000295s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440183 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000262s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440103 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000241s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440104 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000238s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440105 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000243s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440106 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000260s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440112 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000259s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440113 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000275s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440114 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000245s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440115 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `fm_information` [ RunTime:0.000664s ]
SELECT `id`,`title`,`cover`,`abstract`,`create_time` FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 440100 ORDER BY `read_num` DESC LIMIT 0,5 [ RunTime:0.000289s ]
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.000245s ]
SELECT COUNT(*) AS think_count FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000237s ]
SHOW FULL COLUMNS FROM `fm_ad` [ RunTime:0.000591s ]
SELECT `id`,`key`,`value` FROM `fm_ad` WHERE `status` = 1 AND `is_del` = 0 AND `valid_time` >= 1702125696 AND `key` IN ('pc_home_1','pc_home_2') ORDER BY `id` ASC LIMIT 0,10 [ RunTime:0.000472s ]