[ DB ] CONNECT:[ UseTime:0.000389s ] mysql:dbname=yxzgj_com;host=127.0.0.1;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `fang_city` [ RunTime:0.000829s ]
[ SQL ] SELECT * FROM `fang_city` WHERE `domain` = 'cambodia' AND `status` = 1 LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SHOW COLUMNS FROM `fang_badip` [ RunTime:0.000851s ]
[ SQL ] SELECT * FROM `fang_badip` WHERE `status` = 1 [ RunTime:0.000202s ]
[ SQL ] SHOW COLUMNS FROM `fang_house` [ RunTime:0.000901s ]
[ SQL ] SELECT * FROM `fang_house` WHERE `id` = 25 AND `status` = 1 LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SHOW COLUMNS FROM `fang_house_data` [ RunTime:0.000605s ]
[ SQL ] SELECT * FROM `fang_house_data` WHERE `id` = 25 LIMIT 1 [ RunTime:0.000242s ]
[ SQL ] UPDATE `fang_house` SET `hits`=hits+1 WHERE `id` = 25 [ RunTime:0.000236s ]
[ SQL ] SHOW COLUMNS FROM `fang_house_pic` [ RunTime:0.000663s ]
[ SQL ] SELECT `img`,`cate_name` FROM `fang_house_pic` WHERE `house_id` = 25 AND `status` = 1 GROUP BY cate_id [ RunTime:0.000261s ]
[ SQL ] SHOW COLUMNS FROM `fang_house_property_pic` [ RunTime:0.000571s ]
[ SQL ] SELECT * FROM `fang_house_property_pic` WHERE `house_id` = 25 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SHOW COLUMNS FROM `fang_house_type` [ RunTime:0.002019s ]
[ SQL ] SELECT `id`,`house_id`,`title`,`room`,`ting`,`chu`,`wei`,`yang`,`img`,`jianzhu_area` FROM `fang_house_type` WHERE `house_id` = 25 [ RunTime:0.000246s ]
[ SQL ] SELECT * FROM `fang_house_pic` WHERE `house_id` = 25 AND `status` = 1 LIMIT 6 [ RunTime:0.000234s ]
[ SQL ] SELECT `title`,`room`,`jianzhu_area`,`id` FROM `fang_house_type` WHERE ( house_id=25 and status=1 and is_rec = 1 ) LIMIT 4 [ RunTime:0.001105s ]
[ SQL ] SHOW COLUMNS FROM `fang_article` [ RunTime:0.000745s ]
[ SQL ] SELECT `id`,`title`,`create_time`,`cate_id`,`img`,`description` FROM `fang_article` WHERE ( ( house_id=25 and status=1 ) ) AND `fang_article`.`delete_time` IS NULL ORDER BY ordid asc,id desc LIMIT 2 [ RunTime:0.001554s ]
[ SQL ] SELECT `id`,`title`,`room`,`ting`,`wei`,`chu`,`yang`,`price`,`jianzhu_area`,`img` FROM `fang_house_type` WHERE ( status=1 and house_id=25 ) ORDER BY ordid asc,id desc LIMIT 4 [ RunTime:0.000272s ]
[ SQL ] SHOW COLUMNS FROM `fang_ask` [ RunTime:0.001521s ]
[ SQL ] SELECT * FROM `fang_ask` WHERE ( house_id=25 and status=1 ) ORDER BY id desc LIMIT 5 [ RunTime:0.000258s ]
[ SQL ] SHOW COLUMNS FROM `fang_position` [ RunTime:0.000659s ]
[ SQL ] SELECT `house_id`,`img`,`title`,`data` FROM `fang_position` WHERE ( status=1 and cate_id=3 and city=1 ) ORDER BY ordid asc,id desc LIMIT 10 [ RunTime:0.000255s ]
[ SQL ] SHOW COLUMNS FROM `fang_link` [ RunTime:0.000639s ]
[ SQL ] SELECT `name`,`url` FROM `fang_link` WHERE ( status=1 ) ORDER BY ordid asc,id desc LIMIT 50 [ RunTime:0.000194s ]
