SHOW FULL COLUMNS FROM `es_classify` [ RunTime:0.001636s ]
SELECT * FROM `es_classify` WHERE `ctype` = 1 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001391s ]
SELECT * FROM `es_classify` WHERE `ctype` = 2 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001259s ]
SELECT * FROM `es_classify` WHERE `ctype` = 3 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001182s ]
SELECT * FROM `es_classify` WHERE `ctype` = 4 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001138s ]
SELECT * FROM `es_classify` WHERE `ctype` = 5 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001178s ]
SELECT * FROM `es_classify` WHERE `ctype` = 6 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001145s ]
SELECT * FROM `es_classify` WHERE `ctype` = 7 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001106s ]
SELECT * FROM `es_classify` WHERE `ctype` = 8 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001191s ]
SELECT * FROM `es_classify` WHERE `ctype` = 9 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001148s ]
SELECT * FROM `es_classify` WHERE `ctype` = 10 AND `ispid` IN (0,6) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001117s ]
SHOW FULL COLUMNS FROM `es_county` [ RunTime:0.001563s ]
SELECT `id`,`title`,`name`,`domain`,`tel` FROM `es_county` WHERE `ispid` = 6 ORDER BY `id` ASC [ RunTime:0.001188s ]
SHOW FULL COLUMNS FROM `es_ispconfig` [ RunTime:0.001525s ]
SELECT * FROM `es_ispconfig` WHERE `ispid` = 6 LIMIT 1 [ RunTime:0.001167s ]
SHOW FULL COLUMNS FROM `es_ispmini` [ RunTime:0.001560s ]
SELECT * FROM `es_ispmini` WHERE `id` = 6 LIMIT 1 [ RunTime:0.001302s ]
SELECT `id`,`domain`,`sitename`,`sitelogo`,`sitekeys`,`sitedesc`,`miniqrcode`,`dingyuehao`,`fuwuhao`,`manager`,`unioncom`,`operation`,`sitetel`,`email`,`icpnum` FROM `es_ispmini` WHERE `id` = 6 LIMIT 1 [ RunTime:0.001439s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 AND `ispid` = 6 ORDER BY `catsort` DESC [ RunTime:0.001313s ]
SELECT `xueduan`,`tianshu` FROM `es_ispconfig` WHERE `ispid` = 6 LIMIT 1 [ RunTime:0.001262s ]
SELECT `id`,`name`,`title`,`tel` FROM `es_county` WHERE `ispid` = 6 ORDER BY `id` ASC [ RunTime:0.001278s ]
SELECT COUNT(*) AS think_count FROM `es_course` `a` LEFT JOIN ( SELECT `cuid`,MIN(price) as min_price,MAX(price) as max_price FROM `es_cucost` GROUP BY `cuid` ) `b` ON `b`.`cuid`=`a`.`id` LEFT JOIN ( SELECT `uid`,`names`,`files`,`address`,`isauth` FROM `es_orgcom` ) `d` ON `a`.`uid`=`d`.`uid` WHERE `a`.`status` = '1' AND `a`.`ispid` = '6' AND `a`.`ctype` = '2' AND FIND_IN_SET('141', `a`.`catid`) LIMIT 1 [ RunTime:0.003307s ]
SELECT `a`.`id`,`a`.`resite`,`a`.`uid`,`a`.`title`,`a`.`names`,`a`.`files`,`a`.`xtags`,`a`.`ttags`,`a`.`shdesc`,`a`.`vtime`,`a`.`catname`,`a`.`mantime`,`b`.`min_price` FROM `es_course` `a` LEFT JOIN ( SELECT `cuid`,MIN(price) as min_price,MAX(price) as max_price FROM `es_cucost` GROUP BY `cuid` ) `b` ON `b`.`cuid`=`a`.`id` LEFT JOIN ( SELECT `uid`,`names`,`files`,`address`,`isauth` FROM `es_orgcom` ) `d` ON `a`.`uid`=`d`.`uid` WHERE `a`.`status` = '1' AND `a`.`ispid` = '6' AND `a`.`ctype` = '2' AND FIND_IN_SET('141', `a`.`catid`) ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,24 [ RunTime:0.003070s ]
SELECT `sid`,`uid`,`names`,`files`,`level`,`catname`,`province`,`city` FROM `es_orgcom` WHERE `status` = 1 AND `cid` = 3 AND `ispid` = 6 ORDER BY `isbest` DESC,`sort` DESC,`sid` DESC LIMIT 6 [ RunTime:0.001466s ]
