[ DB ] CONNECT:[ UseTime:0.000462s ] mysql:host=127.0.0.1;dbname=ershoufc_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.000588s ]
[ 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.000686s ]
[ SQL ] SHOW COLUMNS FROM `fang_second_house` [ RunTime:0.000721s ]
[ SQL ] SHOW COLUMNS FROM `fang_rental` [ RunTime:0.000618s ]
[ SQL ] SHOW COLUMNS FROM `fang_user` [ RunTime:0.000423s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fang_user` `u` INNER JOIN `fang_user_info` `d` ON `u`.`id`=`d`.`user_id` WHERE `u`.`status` = '1' AND ( find_in_set(4,d.service_area) or find_in_set(5,d.service_area) or find_in_set(6,d.service_area) or find_in_set(7,d.service_area) or find_in_set(18,d.service_area) or find_in_set(19,d.service_area) or find_in_set(20,d.service_area) or find_in_set(21,d.service_area) or find_in_set(22,d.service_area) or find_in_set(23,d.service_area) or find_in_set(1,d.service_area) ) AND `u`.`model` <> '1' LIMIT 1 [ RunTime:0.000423s ]
[ SQL ] SELECT u.id,u.nick_name,u.mobile,d.service_area,d.company,d.tags,d.point,(FORMAT((d.point/5)*100,0)) as goods,( SELECT count(id) as second_total FROM `fang_second_house` WHERE `broker_id` = u.id AND `status` = 1 ) as second_total,( SELECT count(id) as second_total FROM `fang_rental` WHERE `broker_id` = u.id AND `status` = 1 ) as rental_total FROM `fang_user` `u` INNER JOIN `fang_user_info` `d` ON `u`.`id`=`d`.`user_id` WHERE `u`.`status` = '1' AND ( find_in_set(4,d.service_area) or find_in_set(5,d.service_area) or find_in_set(6,d.service_area) or find_in_set(7,d.service_area) or find_in_set(18,d.service_area) or find_in_set(19,d.service_area) or find_in_set(20,d.service_area) or find_in_set(21,d.service_area) or find_in_set(22,d.service_area) or find_in_set(23,d.service_area) or find_in_set(1,d.service_area) ) AND `u`.`model` <> '1' ORDER BY second_total+rental_total desc LIMIT 0,10 [ RunTime:0.000641s ]
[ SQL ] SELECT `id`,`title`,`img`,`price`,`room`,`living_room`,`acreage`,`estate_name` FROM `fang_second_house` WHERE ( status=1 and city in (4,5,6,7,18,19,20,21,22,23,1) ) ORDER BY `create_time` DESC LIMIT 8 [ RunTime:0.000536s ]
[ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.000611s ]
[ 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.000321s ]
