SHOW FULL COLUMNS FROM `qc_regions` [ RunTime:0.000433s ]
SELECT `id`,`names` FROM `qc_regions` WHERE `id` IN (19,30,23,28,21,20,18,17,16,15,14,13,12,11,10,9,8,7,6) [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `qc_abouts` [ RunTime:0.000410s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 1 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.000210s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 2 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.000219s ]
SELECT `id`,`aboutitle` FROM `qc_abouts` WHERE `typeid` = 3 AND `id` <> 11 ORDER BY `id` DESC [ RunTime:0.000204s ]
SHOW FULL COLUMNS FROM `qc_leases` [ RunTime:0.001936s ]
SELECT COUNT(*) AS think_count FROM `qc_leases` WHERE ( `istate` = 3 AND `type1` IN (6,7,8,9,10) AND `type1` = 7 ) [ RunTime:0.000308s ]
SELECT `id`,`titles`,`contents`,`imglist`,`type1`,`type2`,`areas`,`district`,`street`,`address`,`monthpice`,`areapice`,`piceunit`,`roomnum`,`hallnum`,`istop`,`uptime` FROM `qc_leases` WHERE ( `istate` = 3 AND `type1` IN (6,7,8,9,10) AND `type1` = 7 ) ORDER BY `istop` DESC,`uptime` DESC LIMIT 0,24 [ RunTime:0.000653s ]
SELECT `id`,`names` FROM `qc_regions` WHERE `id` IN (19,30,23,28,21,20,18,17,16,15,14,13,12,11,10,9,8,7,6) [ RunTime:0.000286s ]
SELECT `id`,`titles`,`imglist`,`monthpice`,`areapice`,`piceunit`,`areas`,`type2` FROM `qc_leases` WHERE `istate` = 3 AND `type1` IN (6,7,8,9,10) ORDER BY `uptime` DESC LIMIT 6 [ RunTime:0.000630s ]