SELECT `id`,`catid`,`title`,`date`,`image`,`content`,`sort`,`status`,`hits`,`admin_id`,`video`,`address`,`rights`,`building_area`,`purpose`,`use_area`,`house_remark`,`house_num`,`construction`,`building_date`,`property_fee`,`current_status`,`returnof`,`price`,`rmb`,`city_id`,`tag`,`url`,`province_id`,`area_id` FROM `spzg_house` WHERE ( ( `id` = 8 AND `status` = 1 AND `catid` = 44 ) ) AND `spzg_house`.`delete_time` = '0' LIMIT 1 [ RunTime:0.011039s ]
SELECT `id`,`catid`,`title`,`url`,`sort` FROM `spzg_house` WHERE ( ( `status` = 1 AND `catid` = 44 AND `id` = 8 ) ) AND `spzg_house`.`delete_time` = '0' LIMIT 1 [ RunTime:0.010701s ]
SHOW FULL COLUMNS FROM `spzg_house` [ RunTime:0.011068s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_house` WHERE ( ( `sort` < 100 OR ( `sort` = 100 AND `date` = > ) OR ( `sort` = 100 AND `id` > 8 ) ) AND `status` = 1 AND `catid` = 44 ) AND `spzg_house`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.011129s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_house` WHERE ( ( `sort` > 100 OR ( `sort` = 100 AND `date` = < ) OR ( `sort` = 100 AND `id` < 8 ) ) AND `status` = 1 AND `catid` = 44 ) AND `spzg_house`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.010855s ]
UPDATE `spzg_house` SET `hits` = 33 , `update_time` = 1773667560 WHERE ( `id` = 8 ) AND `spzg_house`.`delete_time` = '0' [ RunTime:0.010758s ]
SELECT `id`,`catid`,`title`,`date`,`image`,`address`,`tel`,`tel2` FROM `spzg_map` WHERE ( ( status = 1 and catid = 9 ) ) AND `spzg_map`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC [ RunTime:0.010468s ]
SELECT `id`,`catid`,`title`,`date`,`image`,`url` FROM `spzg_album` WHERE ( ( status = 1 and catid = 309 ) ) AND `spzg_album`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 10 [ RunTime:0.010492s ]