SHOW FULL COLUMNS FROM `fm_area` [ RunTime:0.000868s ]
SELECT `id`,`code` FROM `fm_area` WHERE `grade` = 1 AND `pinyin` = 'beijing' LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`country`,`pinyin`,`code` FROM `fm_area` WHERE `grade` = 2 AND `code` BETWEEN '110100' AND '110199' ORDER BY `id` ASC LIMIT 0,99 [ RunTime:0.000246s ]
SHOW FULL COLUMNS FROM `fm_baike` [ RunTime:0.000695s ]
SHOW FULL COLUMNS FROM `fm_baike_category` [ RunTime:0.000597s ]
SELECT `category_id`,`category_name`,`pid` FROM `fm_baike_category` WHERE `is_del` = 0 ORDER BY `sort` ASC LIMIT 0,99 [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `fm_house` [ RunTime:0.000860s ]
SELECT `code`,`province`,`city`,`country` FROM `fm_area` WHERE `code` IN ('110108','110101','110102','110106','110107','110111','110115','110113','110114','110116','110117','110109') LIMIT 0,10 [ RunTime:0.000324s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 110108 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000289s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 110101 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` = 110102 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000242s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 110106 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000244s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 110107 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000234s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 110111 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` = 110115 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` = 110113 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000239s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 110114 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` = 110116 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` = 110117 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000248s ]
SELECT `house_id`,`house_name`,`areacode`,`cover`,`price`,`status`,`create_time` FROM `fm_house` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 110109 ORDER BY `create_time` DESC LIMIT 0,5 [ RunTime:0.000239s ]
SHOW FULL COLUMNS FROM `fm_information` [ RunTime:0.000614s ]
SELECT `id`,`title`,`cover`,`abstract`,`create_time` FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 AND `areacode` = 110100 ORDER BY `read_num` DESC LIMIT 0,5 [ RunTime:0.000263s ]
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.000256s ]
SELECT COUNT(*) AS think_count FROM `fm_information` WHERE `is_del` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.000253s ]
SHOW FULL COLUMNS FROM `fm_ad` [ RunTime:0.000600s ]
SELECT `id`,`key`,`value` FROM `fm_ad` WHERE `status` = 1 AND `is_del` = 0 AND `valid_time` >= 1702191745 AND `key` IN ('pc_home_1','pc_home_2') ORDER BY `id` ASC LIMIT 0,10 [ RunTime:0.000506s ]
.png)
北京
.png)
.png)
.png)
.png)
.png)
