[ DB ] CONNECT:[ UseTime:0.080414s ] mysql:host=rm-bp17es4jtht1c0y60ao.mysql.rds.aliyuncs.com;dbname=bt;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.054403s ]
[ 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.054182s ]
[ SQL ] SHOW COLUMNS FROM `fang_nav` [ RunTime:0.054787s ]
[ SQL ] SELECT * FROM `fang_nav` WHERE `status` = 1 AND `pos` = 1 AND `pid` = 0 ORDER BY `ordid` ASC [ RunTime:0.053907s ]
[ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.054627s ]
[ 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` = '5' GROUP BY `h`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.054719s ]
[ 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` = '5' GROUP BY `h`.`id` ORDER BY `h`.`ordid` ASC,`h`.`id` DESC LIMIT 0,10 [ RunTime:0.055284s ]
[ SQL ] SHOW COLUMNS FROM `fang_metro` [ RunTime:0.053866s ]
[ SQL ] SELECT * FROM `fang_metro` WHERE `status` = 1 AND `city` = 244 ORDER BY `ordid` ASC,`id` DESC [ RunTime:0.053556s ]
[ SQL ] SHOW COLUMNS FROM `fang_position` [ RunTime:0.054195s ]
[ 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.055408s ]
[ 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.056356s ]
[ 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.055015s ]
[ 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.054730s ]
[ 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.054946s ]
[ SQL ] SHOW COLUMNS FROM `fang_house_type` [ RunTime:0.053989s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1164 AND `status` = 1 GROUP BY `room` [ RunTime:0.053495s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1158 AND `status` = 1 GROUP BY `room` [ RunTime:0.054308s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1113 AND `status` = 1 GROUP BY `room` [ RunTime:0.053570s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1108 AND `status` = 1 GROUP BY `room` [ RunTime:0.053654s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1080 AND `status` = 1 GROUP BY `room` [ RunTime:0.053620s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1068 AND `status` = 1 GROUP BY `room` [ RunTime:0.054182s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1054 AND `status` = 1 GROUP BY `room` [ RunTime:0.054204s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1041 AND `status` = 1 GROUP BY `room` [ RunTime:0.053525s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1040 AND `status` = 1 GROUP BY `room` [ RunTime:0.053591s ]
[ SQL ] SELECT `room`,COUNT(id) FROM `fang_house_type` WHERE `house_id` = 1022 AND `status` = 1 GROUP BY `room` [ RunTime:0.053609s ]