SHOW FULL COLUMNS FROM `spzg_category` [ RunTime:0.011295s ]
SELECT `id`,`title` FROM `spzg_category` WHERE ( `id` = 45 AND `status` = 1 ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC LIMIT 1 [ RunTime:0.010534s ]
SHOW FULL COLUMNS FROM `spzg_parameters` [ RunTime:0.011089s ]
SHOW FULL COLUMNS FROM `spzg_category_parameters` [ RunTime:0.011098s ]
SELECT `spzg_parameters`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`catid` AS `pivot__catid`,`pivot`.`parameter_id` AS `pivot__parameter_id` FROM `spzg_parameters` INNER JOIN `spzg_category_parameters` `pivot` ON `pivot`.`parameter_id`=`spzg_parameters`.`id` WHERE ( `pivot`.`catid` = '45' ) [ RunTime:0.010634s ]
SHOW FULL COLUMNS FROM `spzg_city` [ RunTime:0.011209s ]
SELECT `id`,`title`,`is_hot` FROM `spzg_city` WHERE ( status=1 and pid=0 ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.010542s ]
SELECT `id`,`title` FROM `spzg_category` WHERE ( `id` = 45 AND `status` = 1 ) AND `spzg_category`.`delete_time` = '0' ORDER BY `sort` ASC,`id` ASC LIMIT 1 [ RunTime:0.010629s ]
SELECT `spzg_parameters`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`catid` AS `pivot__catid`,`pivot`.`parameter_id` AS `pivot__parameter_id` FROM `spzg_parameters` INNER JOIN `spzg_category_parameters` `pivot` ON `pivot`.`parameter_id`=`spzg_parameters`.`id` WHERE ( `pivot`.`catid` = '45' ) [ RunTime:0.010467s ]
SELECT COUNT(*) AS think_count FROM `spzg_house` WHERE ( ( status = 1 and catid = 45 ) ) AND `spzg_house`.`delete_time` = '0' [ RunTime:0.010703s ]
SELECT `id`,`catid`,`title`,`url`,`date`,`image`,`price`,`rmb` FROM `spzg_house` WHERE ( ( status = 1 and catid = 45 ) ) AND `spzg_house`.`delete_time` = '0' ORDER BY rand() , hits desc, sort asc, date desc, id desc LIMIT 3 [ RunTime:0.010732s ]
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.010648s ]
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.010553s ]
