SHOW FULL COLUMNS FROM `es_config` [ RunTime:0.052501s ]
SELECT * FROM `es_config` WHERE `id` = 2 LIMIT 1 [ RunTime:0.052279s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 ORDER BY `catsort` DESC [ RunTime:0.052318s ]
SELECT `xueduan` FROM `es_ispconfig` WHERE `ispid` = 1 LIMIT 1 [ RunTime:0.052163s ]
SELECT `id`,`name` FROM `es_county` WHERE `ispid` = 1 ORDER BY `id` ASC [ RunTime:0.052281s ]
SELECT `tianshu` FROM `es_ispconfig` WHERE `ispid` = 1 LIMIT 1 [ RunTime:0.052066s ]
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` = '1' AND `a`.`ctype` = '2' LIMIT 1 [ RunTime:0.071886s ]
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` = '1' AND `a`.`ctype` = '2' ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 55,5 [ RunTime:0.092335s ]
SELECT `sid`,`uid`,`names`,`files`,`level`,`catname`,`province`,`city` FROM `es_orgcom` WHERE `status` = 1 AND `cid` = 3 AND `isbest` = 1 ORDER BY `sort` DESC,`sid` DESC LIMIT 6 [ RunTime:0.052395s ]
