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` = 1 AND `status` = 1 AND `catid` = 44 ) ) AND `spzg_house`.`delete_time` = '0' LIMIT 1 [ RunTime:0.010449s ]
SELECT `id`,`catid`,`title`,`url`,`sort` FROM `spzg_house` WHERE ( ( `status` = 1 AND `catid` = 44 AND `id` = 1 ) ) AND `spzg_house`.`delete_time` = '0' LIMIT 1 [ RunTime:0.010052s ]
SHOW FULL COLUMNS FROM `spzg_house` [ RunTime:0.010546s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_house` WHERE ( ( `sort` < 100 OR ( `sort` = 100 AND `date` = > ) OR ( `sort` = 100 AND `id` > 1 ) ) AND `status` = 1 AND `catid` = 44 ) AND `spzg_house`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.010227s ]
SELECT `id`,`catid`,`title`,`url` FROM `spzg_house` WHERE ( ( `sort` > 100 OR ( `sort` = 100 AND `date` = < ) OR ( `sort` = 100 AND `id` < 1 ) ) AND `status` = 1 AND `catid` = 44 ) AND `spzg_house`.`delete_time` = '0' ORDER BY `sort` ASC,`date` DESC,`id` DESC LIMIT 1 [ RunTime:0.010277s ]
UPDATE `spzg_house` SET `hits` = 4 , `update_time` = 1773672739 WHERE ( `id` = 1 ) AND `spzg_house`.`delete_time` = '0' [ RunTime:0.010122s ]
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.010396s ]
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.010424s ]
