[ DB ] CONNECT:[ UseTime:0.001294s ] mysql:dbname=yxzgj_com;host=127.0.0.1;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.000857s ]
[ SQL ] SELECT * FROM `fang_city` WHERE `domain` = 'cambodia' AND `status` = 1 LIMIT 1 [ RunTime:0.000292s ]
[ SQL ] SHOW COLUMNS FROM `fang_badip` [ RunTime:0.000667s ]
[ SQL ] SELECT * FROM `fang_badip` WHERE `status` = 1 [ RunTime:0.000177s ]
[ SQL ] SHOW COLUMNS FROM `fang_second_house` [ RunTime:0.001684s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fang_second_house` WHERE `status` = 1 AND `city` = 1 AND `total_price` BETWEEN 40 AND 60 LIMIT 1 [ RunTime:0.000255s ]
[ SQL ] SELECT `id`,`title`,`img`,`address`,`price`,`total_price`,`room`,`zhuangxiu`,`chaoxiang`,`ting`,`mianji`,`house_type`,`floor`,`total_floor`,`contact`,`contact_phone` FROM `fang_second_house` WHERE `status` = 1 AND `city` = 1 AND `total_price` BETWEEN 40 AND 60 ORDER BY ordid asc,id desc LIMIT 0,10 [ RunTime:0.000294s ]
[ SQL ] SHOW COLUMNS FROM `fang_position` [ RunTime:0.002637s ]
[ SQL ] SELECT `house_id`,`img`,`title`,`data` FROM `fang_position` WHERE ( status=1 and cate_id=4 and model='second_house' and city=1 ) ORDER BY ordid asc,id desc LIMIT 5 [ RunTime:0.000268s ]
[ SQL ] SHOW COLUMNS FROM `fang_link` [ RunTime:0.000607s ]
[ SQL ] SELECT `name`,`url` FROM `fang_link` WHERE ( status=1 ) ORDER BY ordid asc,id desc LIMIT 50 [ RunTime:0.000221s ]
