[ DB ] CONNECT:[ UseTime:0.085078s ] mysql:host=rm-bp17es4jtht1c0y60ao.mysql.rds.aliyuncs.com;dbname=bt;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.057217s ]
[ SQL ] SELECT `id`,`name`,`domain`,`seo_title`,`seo_keys`,`seo_desc` FROM `fang_city` WHERE `status` = 1 AND `pid` = 0 ORDER BY `ordid` ASC,`id` ASC LIMIT 1 [ RunTime:0.056948s ]
[ SQL ] SHOW COLUMNS FROM `fang_nav` [ RunTime:0.056960s ]
[ SQL ] SELECT * FROM `fang_nav` WHERE `status` = 1 AND `pos` = 1 AND `pid` = 0 ORDER BY `ordid` ASC [ RunTime:0.057079s ]
[ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.057110s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `fang_house` `h` LEFT JOIN `fang_house_type` `t` ON `h`.`id`=`t`.`house_id` WHERE `h`.`status` = '1' AND `h`.`code` = '1' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') AND `t`.`room` = '3' AND `t`.`acreage` BETWEEN '81' AND '100' GROUP BY `h`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.058563s ]
[ SQL ] SELECT `h`.`id`,`h`.`title`,`h`.`video`,`h`.`img`,`h`.`sale_status`,`h`.`nearby`,`h`.`city`,`h`.`address`,`h`.`tags_id`,`h`.`price`,`h`.`unit`,`h`.`area_addr`,`h`.`update_time`,`h`.`create_time`,`h`.`ceng`,`h`.`xing`,`h`.`mian`,`h`.`chao`,MIN(t.room) AS min_type,MAX(t.room) AS max_type,MIN(t.acreage) AS min_acreage,MAX(t.acreage) AS max_acreage,MIN(t.price) AS min_price,MAX(t.price) AS max_price FROM `fang_house` `h` LEFT JOIN `fang_house_type` `t` ON `h`.`id`=`t`.`house_id` WHERE `h`.`status` = '1' AND `h`.`code` = '1' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') AND `t`.`room` = '3' AND `t`.`acreage` BETWEEN '81' AND '100' GROUP BY `h`.`id` ORDER BY `h`.`ordid` ASC,`h`.`id` DESC LIMIT 0,10 [ RunTime:0.059207s ]
[ SQL ] SHOW COLUMNS FROM `fang_metro` [ RunTime:0.056787s ]
[ SQL ] SELECT * FROM `fang_metro` WHERE `status` = 1 AND `city` = 244 ORDER BY `ordid` ASC,`id` DESC [ RunTime:0.056413s ]
[ SQL ] SHOW COLUMNS FROM `fang_position` [ RunTime:0.056784s ]
[ SQL ] SELECT h.id,h.img,h.title,(case h.price when 0 then '待定' else h.price end) as price,h.unit,h.city,h.area_addr,h.address FROM `fang_position` `p` INNER JOIN `fang_house` `h` ON `p`.`house_id`=`h`.`id` WHERE `p`.`status` = '1' AND `p`.`cate_id` = '4' AND `h`.`status` = '1' AND `p`.`model` = 'house' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') ORDER BY `p`.`ordid` ASC,`h`.`id` DESC LIMIT 6 [ RunTime:0.057718s ]
[ SQL ] SELECT `h`.`id`,`h`.`is_discount`,`h`.`discount`,`h`.`img`,`h`.`title`,`h`.`tags_id`,`h`.`price`,`h`.`unit`,`h`.`city`,`h`.`address`,`h`.`nearby`,`h`.`area_addr`,`s`.`min_type`,`s`.`max_type`,`s`.`min_acreage`,`s`.`max_acreage`,`s`.`min_price`,`s`.`max_price` FROM `fang_house` `h` LEFT JOIN `fang_position` `p` ON `p`.`house_id`=`h`.`id` LEFT JOIN `fang_house_search` `s` ON `s`.`house_id`=`h`.`id` WHERE `p`.`status` = '1' AND `p`.`cate_id` = '5' AND `h`.`status` = '1' AND `p`.`model` = 'house' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') ORDER BY `p`.`ordid` ASC,`h`.`ordid` ASC,`h`.`id` DESC LIMIT 5 [ RunTime:0.062069s ]
[ SQL ] SELECT `h`.`id`,`h`.`is_discount`,`h`.`discount`,`h`.`img`,`h`.`title`,`h`.`tags_id`,`h`.`price`,`h`.`unit`,`h`.`city`,`h`.`address`,`h`.`nearby`,`h`.`area_addr`,`s`.`min_type`,`s`.`max_type`,`s`.`min_acreage`,`s`.`max_acreage`,`s`.`min_price`,`s`.`max_price` FROM `fang_house` `h` LEFT JOIN `fang_position` `p` ON `p`.`house_id`=`h`.`id` LEFT JOIN `fang_house_search` `s` ON `s`.`house_id`=`h`.`id` WHERE `p`.`status` = '1' AND `p`.`cate_id` = '15' AND `h`.`status` = '1' AND `p`.`model` = 'house' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') ORDER BY `p`.`ordid` ASC,`h`.`ordid` ASC,`h`.`id` DESC LIMIT 5 [ RunTime:0.057864s ]
[ SQL ] SELECT `h`.`id`,`h`.`is_discount`,`h`.`discount`,`h`.`img`,`h`.`title`,`h`.`tags_id`,`h`.`price`,`h`.`unit`,`h`.`city`,`h`.`address`,`h`.`nearby`,`h`.`area_addr`,`s`.`min_type`,`s`.`max_type`,`s`.`min_acreage`,`s`.`max_acreage`,`s`.`min_price`,`s`.`max_price` FROM `fang_house` `h` LEFT JOIN `fang_position` `p` ON `p`.`house_id`=`h`.`id` LEFT JOIN `fang_house_search` `s` ON `s`.`house_id`=`h`.`id` WHERE `p`.`status` = '1' AND `p`.`cate_id` = '13' AND `h`.`status` = '1' AND `p`.`model` = 'house' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') ORDER BY `p`.`ordid` ASC,`h`.`ordid` ASC,`h`.`id` DESC LIMIT 5 [ RunTime:0.057741s ]
[ SQL ] SELECT `h`.`id`,`h`.`is_discount`,`h`.`discount`,`h`.`img`,`h`.`title`,`h`.`tags_id`,`h`.`price`,`h`.`unit`,`h`.`city`,`h`.`address`,`h`.`nearby`,`h`.`area_addr`,`s`.`min_type`,`s`.`max_type`,`s`.`min_acreage`,`s`.`max_acreage`,`s`.`min_price`,`s`.`max_price` FROM `fang_house` `h` LEFT JOIN `fang_position` `p` ON `p`.`house_id`=`h`.`id` LEFT JOIN `fang_house_search` `s` ON `s`.`house_id`=`h`.`id` WHERE `p`.`status` = '1' AND `p`.`cate_id` = '14' AND `h`.`status` = '1' AND `p`.`model` = 'house' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') ORDER BY `p`.`ordid` ASC,`h`.`ordid` ASC,`h`.`id` DESC LIMIT 5 [ RunTime:0.057854s ]
[ SQL ] SHOW COLUMNS FROM `fang_house_type` [ RunTime:0.056870s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1165 AND `status` = 1 GROUP BY `room` [ RunTime:0.056523s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1163 AND `status` = 1 GROUP BY `room` [ RunTime:0.056517s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1162 AND `status` = 1 GROUP BY `room` [ RunTime:0.056709s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1160 AND `status` = 1 GROUP BY `room` [ RunTime:0.056665s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1158 AND `status` = 1 GROUP BY `room` [ RunTime:0.056704s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1157 AND `status` = 1 GROUP BY `room` [ RunTime:0.056605s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1156 AND `status` = 1 GROUP BY `room` [ RunTime:0.056612s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1155 AND `status` = 1 GROUP BY `room` [ RunTime:0.056579s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1154 AND `status` = 1 GROUP BY `room` [ RunTime:0.056789s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1153 AND `status` = 1 GROUP BY `room` [ RunTime:0.056729s ]