SHOW FULL COLUMNS FROM `fm_area` [ RunTime:0.001047s ]
SELECT `id`,`code` FROM `fm_area` WHERE `grade` = 1 AND `pinyin` = 'zhengzhou' LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`country`,`pinyin`,`code` FROM `fm_area` WHERE `grade` = 2 AND `code` BETWEEN '410100' AND '410199' ORDER BY `id` ASC LIMIT 0,99 [ RunTime:0.000386s ]
SHOW FULL COLUMNS FROM `fm_baike` [ RunTime:0.000827s ]
SHOW FULL COLUMNS FROM `fm_baike_category` [ RunTime:0.000715s ]
SELECT `category_id`,`category_name`,`pid` FROM `fm_baike_category` WHERE `is_del` = 0 ORDER BY `sort` ASC LIMIT 0,99 [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `fm_house` [ RunTime:0.000918s ]
SELECT `code`,`province`,`city`,`country` FROM `fm_area` WHERE `code` IN ('410185','410181','410183','410184','410122','410182','410102','410103','410104','410105','410106','410108','410142') LIMIT 0,10 [ RunTime:0.000418s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410185 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000360s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410181 ORDER BY `create_time` DESC LIMIT 0,5 [ 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` = 410183 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000373s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410184 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000345s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410122 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` = 410182 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000353s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410102 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000348s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410103 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` = 410104 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000352s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410105 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` = 410106 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` = 410108 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000349s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410142 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `fm_information` [ RunTime:0.000787s ]
SELECT `id`,`title`,`cover`,`abstract`,`create_time` FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 410100 ORDER BY `read_num` DESC LIMIT 0,5 [ RunTime:0.000339s ]
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.000358s ]
SELECT COUNT(*) AS think_count FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000325s ]
SHOW FULL COLUMNS FROM `fm_ad` [ RunTime:0.000720s ]
SELECT `id`,`key`,`value` FROM `fm_ad` WHERE `status` = 1 AND `is_del` = 0 AND `valid_time` >= 1702254669 AND `key` IN ('pc_home_1','pc_home_2') ORDER BY `id` ASC LIMIT 0,10 [ RunTime:0.000528s ]
.png)
郑州
.png)
.png)
.png)
.png)
.png)
