SHOW FULL COLUMNS FROM `fm_area` [ RunTime:0.000696s ]
SELECT `id`,`code` FROM `fm_area` WHERE `grade` = 1 AND `pinyin` = 'wuhan' LIMIT 1 [ RunTime:0.000275s ]
SELECT `id`,`country`,`pinyin`,`code` FROM `fm_area` WHERE `grade` = 2 AND `code` BETWEEN '420100' AND '420199' ORDER BY `id` ASC LIMIT 0,99 [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `fm_baike` [ RunTime:0.000697s ]
SHOW FULL COLUMNS FROM `fm_baike_category` [ RunTime:0.000631s ]
SELECT `category_id`,`category_name`,`pid` FROM `fm_baike_category` WHERE `is_del` = 0 ORDER BY `sort` ASC LIMIT 0,99 [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `fm_house` [ RunTime:0.000808s ]
SELECT `code`,`province`,`city`,`country` FROM `fm_area` WHERE `code` IN ('420102','420103','420104','420105','420106','420107','420111','420112','420113','420114','420115','420116','420117') LIMIT 0,10 [ RunTime:0.000341s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420102 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000282s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420103 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` = 420104 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000237s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420105 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` = 420106 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000230s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420107 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000246s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420111 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000253s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420112 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` = 420113 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000261s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420114 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000232s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420115 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000232s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420116 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000227s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420117 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `fm_information` [ RunTime:0.000641s ]
SELECT `id`,`title`,`cover`,`abstract`,`create_time` FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 420100 ORDER BY `read_num` DESC LIMIT 0,5 [ RunTime:0.000273s ]
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.000244s ]
SELECT COUNT(*) AS think_count FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000232s ]
SHOW FULL COLUMNS FROM `fm_ad` [ RunTime:0.000584s ]
SELECT `id`,`key`,`value` FROM `fm_ad` WHERE `status` = 1 AND `is_del` = 0 AND `valid_time` >= 1701331604 AND `key` IN ('pc_home_1','pc_home_2') ORDER BY `id` ASC LIMIT 0,10 [ RunTime:0.000449s ]
.png)
武汉
.png)
.png)
.png)
.png)
.png)
