[ DB ] CONNECT:[ UseTime:0.000562s ] mysql:host=127.0.0.1;dbname=ershoufc_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.000550s ]
[ 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.000671s ]
[ SQL ] SHOW COLUMNS FROM `fang_rental` [ RunTime:0.000696s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fang_rental` `r` WHERE `r`.`status` = '1' AND `r`.`city` IN ('4','5','6','7','18','19','20','21','22','23','1') AND `r`.`timeout` > '1751524072' AND `r`.`top_time` < '1751524072' LIMIT 1 [ RunTime:0.000363s ]
[ SQL ] SELECT `r`.`id`,`r`.`title`,`r`.`estate_name`,`r`.`img`,`r`.`pano_url`,`r`.`room`,`r`.`living_room`,`r`.`toilet`,`r`.`price`,`r`.`rent_type`,`r`.`tags`,`r`.`address`,`r`.`acreage`,`r`.`orientations`,`r`.`renovation`,`r`.`user_type`,`r`.`contacts`,`r`.`update_time` FROM `fang_rental` `r` WHERE `r`.`status` = '1' AND `r`.`city` IN ('4','5','6','7','18','19','20','21','22','23','1') AND `r`.`timeout` > '1751524072' AND `r`.`top_time` < '1751524072' ORDER BY `ordid` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.000374s ]
[ SQL ] SELECT `r`.`id`,`r`.`title`,`r`.`estate_name`,`r`.`img`,`r`.`pano_url`,`r`.`room`,`r`.`living_room`,`r`.`toilet`,`r`.`price`,`r`.`rent_type`,`r`.`tags`,`r`.`address`,`r`.`acreage`,`r`.`orientations`,`r`.`renovation`,`r`.`user_type`,`r`.`contacts`,`r`.`update_time` FROM `fang_rental` `r` WHERE `r`.`status` = '1' AND `r`.`city` IN ('4','5','6','7','18','19','20','21','22','23','1') AND `r`.`timeout` > '1751524072' AND `r`.`top_time` > '1751524072' ORDER BY `top_time` DESC,`id` DESC [ RunTime:0.000347s ]
[ SQL ] SHOW COLUMNS FROM `fang_metro` [ RunTime:0.000373s ]
[ SQL ] SELECT * FROM `fang_metro` WHERE `status` = 1 AND `city` = 1 ORDER BY `ordid` ASC,`id` DESC [ RunTime:0.000235s ]
[ SQL ] SHOW COLUMNS FROM `fang_position` [ RunTime:0.000554s ]
[ SQL ] SELECT h.id,h.img,h.title,(case h.price when 0 then '待定' else h.price end) as price,h.estate_name,h.room,h.living_room,h.acreage,h.city FROM `fang_position` `p` INNER JOIN `fang_rental` `h` ON `p`.`house_id`=`h`.`id` WHERE `p`.`status` = '1' AND `p`.`cate_id` = '6' AND `h`.`status` = '1' AND `p`.`model` = 'rental' AND `h`.`city` IN ('4','5','6','7','18','19','20','21','22','23','1') AND `timeout` > '1751524072' ORDER BY `p`.`ordid` ASC,`h`.`id` DESC LIMIT 4 [ RunTime:0.000525s ]
[ SQL ] SHOW COLUMNS FROM `fang_article` [ RunTime:0.000678s ]
[ SQL ] SELECT `id`,`title` FROM `fang_article` WHERE ( ( cate_id=6 and status=1 and city=1 ) ) AND `fang_article`.`delete_time` IS NULL ORDER BY `ordid` ASC LIMIT 8 [ RunTime:0.000384s ]
[ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.000481s ]
[ 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.000327s ]