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` = 6 AND `status` = 1 AND `catid` = 44 ) ) AND `spzg_house`.`delete_time` = '0' LIMIT 1 [ RunTime:0.011478s ]
SELECT `id`,`catid`,`title`,`url`,`sort` FROM `spzg_house` WHERE ( ( `status` = 1 AND `catid` = 44 AND `id` = 6 ) ) AND `spzg_house`.`delete_time` = '0' LIMIT 1 [ RunTime:0.010953s ]
SHOW FULL COLUMNS FROM `spzg_house` [ RunTime:0.011592s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_house` WHERE ( ( `sort` < 100 OR ( `sort` = 100 AND `date` = > ) OR ( `sort` = 100 AND `id` > 6 ) ) AND `status` = 1 AND `catid` = 44 ) AND `spzg_house`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.011126s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_house` WHERE ( ( `sort` > 100 OR ( `sort` = 100 AND `date` = < ) OR ( `sort` = 100 AND `id` < 6 ) ) AND `status` = 1 AND `catid` = 44 ) AND `spzg_house`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.011123s ]
UPDATE `spzg_house` SET `hits` = 3 , `update_time` = 1773667559 WHERE ( `id` = 6 ) AND `spzg_house`.`delete_time` = '0' [ RunTime:0.011140s ]
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.010840s ]
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.010843s ]
