SHOW FULL COLUMNS FROM `g1700_conf` [ RunTime:0.000638s ]
SELECT `grou`,`name`,`type`,`valu` FROM `g1700_conf` WHERE ( `name` <> '' AND `status` = 1 ) AND `g1700_conf`.`delete_time` IS NULL [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `g1700_othe` [ RunTime:0.000577s ]
SELECT * FROM `g1700_othe` WHERE ( `status` = 1 AND `clas_id` = 1 ) AND `g1700_othe`.`delete_time` IS NULL ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `g1700_link` [ RunTime:0.000535s ]
SELECT * FROM `g1700_link` WHERE ( `status` = 1 ) AND `g1700_link`.`delete_time` IS NULL ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000194s ]
SHOW FULL COLUMNS FROM `g1700_tops` [ RunTime:0.000523s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 21 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000154s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 3 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000118s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 5 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000112s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 4 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000125s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 6 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000150s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 7 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000115s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 17 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000108s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 18 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000125s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 19 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000133s ]
SELECT `title`,`abou` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 20 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000108s ]
SELECT `title`,`abou`,`cont` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 64 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000117s ]
SELECT `title`,`abou`,`cont` FROM `g1700_tops` WHERE ( `status` = 1 AND `id` = 95 ) AND `g1700_tops`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000122s ]
SELECT `pics` FROM `g1700_othe` WHERE ( `status` = 1 AND `id` = 13 ) AND `g1700_othe`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000142s ]
SHOW FULL COLUMNS FROM `g1700_pros` [ RunTime:0.000563s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `g1700_pros` `p` LEFT JOIN `g1700_cass` `c` ON `p`.`id`=`c`.`pros_id` LEFT JOIN `g1700_style` `s` ON `s`.`id`=`c`.`style_id` LEFT JOIN `g1700_house_type` `h` ON `h`.`id`=`c`.`house_type_id` WHERE ( `s`.`delete_time` IS NULL AND `c`.`delete_time` IS NULL AND `h`.`delete_time` IS NULL AND `p`.`clas_id` = '2' AND `p`.`status` = '1' ) AND `p`.`delete_time` IS NULL GROUP BY `p`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000627s ]
SELECT `p`.* FROM `g1700_pros` `p` LEFT JOIN `g1700_cass` `c` ON `p`.`id`=`c`.`pros_id` LEFT JOIN `g1700_style` `s` ON `s`.`id`=`c`.`style_id` LEFT JOIN `g1700_house_type` `h` ON `h`.`id`=`c`.`house_type_id` WHERE ( `s`.`delete_time` IS NULL AND `c`.`delete_time` IS NULL AND `h`.`delete_time` IS NULL AND `p`.`clas_id` = '2' AND `p`.`status` = '1' ) AND `p`.`delete_time` IS NULL GROUP BY `p`.`id` ORDER BY `sort` DESC,`id` DESC LIMIT 0,12 [ RunTime:0.001186s ]
SHOW FULL COLUMNS FROM `g1700_pros_clas` [ RunTime:0.000566s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000135s ]
SHOW FULL COLUMNS FROM `g1700_cass` [ RunTime:0.000531s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '35' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000194s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000124s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '34' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000165s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000143s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '33' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000162s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000126s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '32' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000178s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000125s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '31' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000176s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000134s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '30' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000168s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000141s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '29' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000166s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000143s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '28' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000169s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000133s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '27' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000168s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000136s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '26' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000170s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000130s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '25' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000182s ]
SELECT `title` FROM `g1700_pros_clas` WHERE ( `status` = 1 AND `id` = 2 ) AND `g1700_pros_clas`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000141s ]
SELECT COUNT(*) AS think_count FROM `g1700_cass` WHERE ( `status` = 1 AND `pros_id` = '24' ) AND `g1700_cass`.`delete_time` IS NULL LIMIT 1 [ RunTime:0.000168s ]