[ DB ] CONNECT:[ UseTime:0.000499s ] mysql:host=127.0.0.1;dbname=ershoufc_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.000525s ]
[ 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.000696s ]
[ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.000690s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `fang_house` `h` LEFT JOIN `fang_house_search` `s` ON `h`.`id`=`s`.`house_id` WHERE `h`.`status` = '1' AND `h`.`city` IN ('6') AND ( find_in_set(14,h.tags_id) ) GROUP BY `h`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000445s ]
[ SQL ] SELECT `h`.`id`,`h`.`title`,`h`.`img`,`h`.`video`,`h`.`sale_status`,`h`.`red_packet`,`h`.`city`,`h`.`address`,`h`.`tags_id`,`h`.`price`,`h`.`unit`,`h`.`pano_url`,`s`.`min_type`,`s`.`max_type`,`s`.`min_acreage`,`s`.`max_acreage` FROM `fang_house` `h` LEFT JOIN `fang_house_search` `s` ON `h`.`id`=`s`.`house_id` WHERE `h`.`status` = '1' AND `h`.`city` IN ('6') AND ( find_in_set(14,h.tags_id) ) GROUP BY `h`.`id` ORDER BY `h`.`ordid` ASC,`h`.`id` DESC LIMIT 0,10 [ RunTime:0.000386s ]
[ SQL ] SHOW COLUMNS FROM `fang_metro` [ RunTime:0.000397s ]
[ SQL ] SELECT * FROM `fang_metro` WHERE `status` = 1 AND `city` = 1 ORDER BY `ordid` ASC,`id` DESC [ RunTime:0.000237s ]
[ SQL ] SHOW COLUMNS FROM `fang_position` [ RunTime:0.000538s ]
[ SQL ] SELECT h.id,h.img,h.title,(case h.price when 0 then '待定' else h.price end) as price,h.unit,h.city 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 ('4','5','6','7','18','19','20','21','22','23','1') ORDER BY `p`.`ordid` ASC,`h`.`id` DESC LIMIT 6 [ RunTime:0.000549s ]
[ SQL ] SHOW COLUMNS FROM `fang_house_type` [ RunTime:0.000688s ]
[ SQL ] SELECT `id`,`room`,`house_id`,`living_room` FROM `fang_house_type` WHERE ( house_id=3 and status=1 ) GROUP BY `room` LIMIT 10 [ RunTime:0.000325s ]
[ SQL ] SELECT `id`,`title` FROM `fang_house` WHERE ( status=1 and city in (4,5,6,7,18,19,20,21,22,23,1) ) ORDER BY `ordid` ASC,`id` DESC LIMIT 50 [ RunTime:0.000537s ]