[ DB ] CONNECT:[ UseTime:0.093233s ] mysql:host=rm-bp17es4jtht1c0y60ao.mysql.rds.aliyuncs.com;dbname=bt;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.062709s ]
[ 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.062439s ]
[ SQL ] SHOW COLUMNS FROM `fang_nav` [ RunTime:0.062709s ]
[ SQL ] SELECT * FROM `fang_nav` WHERE `status` = 1 AND `pos` = 1 AND `pid` = 0 ORDER BY `ordid` ASC [ RunTime:0.062231s ]
[ SQL ] SHOW COLUMNS FROM `fang_estat` [ RunTime:0.062417s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `fang_estat` `e` INNER JOIN `fang_house` `h` ON `h`.`estate_id`=`e`.`id` LEFT JOIN `fang_house_type` `t` ON `h`.`id`=`t`.`house_id` WHERE `h`.`status` = '1' AND `h`.`code` = '2' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') GROUP BY `e`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.062925s ]
[ SQL ] SELECT `e`.*,`h`.`area_addr`,`h`.`ceng`,`h`.`xing`,`h`.`mian`,`h`.`chao`,count(h.id) as count,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_estat` `e` INNER JOIN `fang_house` `h` ON `h`.`estate_id`=`e`.`id` LEFT JOIN `fang_house_type` `t` ON `h`.`id`=`t`.`house_id` WHERE `h`.`status` = '1' AND `h`.`code` = '2' AND `h`.`city` IN ('245','246','247','248','249','250','251','252','253','244') GROUP BY `e`.`id` ORDER BY `h`.`ordid` ASC,`h`.`id` DESC LIMIT 0,10 [ RunTime:0.097190s ]
[ SQL ] SHOW COLUMNS FROM `fang_metro` [ RunTime:0.062787s ]
[ SQL ] SELECT * FROM `fang_metro` WHERE `status` = 1 AND `city` = 244 ORDER BY `ordid` ASC,`id` DESC [ RunTime:0.062247s ]