SHOW FULL COLUMNS FROM `es_classify` [ RunTime:0.001970s ]
SELECT * FROM `es_classify` WHERE `ctype` = 1 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001745s ]
SELECT * FROM `es_classify` WHERE `ctype` = 2 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001720s ]
SELECT * FROM `es_classify` WHERE `ctype` = 3 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001510s ]
SELECT * FROM `es_classify` WHERE `ctype` = 4 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001459s ]
SELECT * FROM `es_classify` WHERE `ctype` = 5 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001444s ]
SELECT * FROM `es_classify` WHERE `ctype` = 6 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001363s ]
SELECT * FROM `es_classify` WHERE `ctype` = 7 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001423s ]
SELECT * FROM `es_classify` WHERE `ctype` = 8 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001410s ]
SELECT * FROM `es_classify` WHERE `ctype` = 9 AND `ispid` = 7 ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001761s ]
SELECT * FROM `es_classify` WHERE `ctype` = 10 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001498s ]
SHOW FULL COLUMNS FROM `es_county` [ RunTime:0.001840s ]
SELECT `id`,`title`,`name`,`domain`,`tel` FROM `es_county` WHERE `ispid` = 7 ORDER BY `id` ASC [ RunTime:0.001498s ]
SHOW FULL COLUMNS FROM `es_ispconfig` [ RunTime:0.001702s ]
SELECT * FROM `es_ispconfig` WHERE `ispid` = 7 LIMIT 1 [ RunTime:0.001418s ]
SHOW FULL COLUMNS FROM `es_ispmini` [ RunTime:0.001757s ]
SELECT * FROM `es_ispmini` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001408s ]
SELECT `id`,`domain`,`sitename`,`sitelogo`,`sitekeys`,`sitedesc`,`miniqrcode`,`dingyuehao`,`fuwuhao`,`manager`,`unioncom`,`operation`,`sitetel`,`email`,`icpnum` FROM `es_ispmini` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001323s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 AND `ispid` = 7 ORDER BY `catsort` DESC [ RunTime:0.001440s ]
SELECT `xueduan`,`tianshu` FROM `es_ispconfig` WHERE `ispid` = 7 LIMIT 1 [ RunTime:0.001364s ]
SELECT `id`,`name`,`title`,`tel` FROM `es_county` WHERE `ispid` = 7 ORDER BY `id` ASC [ RunTime:0.001355s ]
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` = '7' AND `a`.`ctype` = '2' AND FIND_IN_SET('80', `a`.`catid`) LIMIT 1 [ RunTime:0.003267s ]
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` = '7' AND `a`.`ctype` = '2' AND FIND_IN_SET('80', `a`.`catid`) ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,24 [ RunTime:0.003161s ]
SELECT `sid`,`uid`,`names`,`files`,`level`,`catname`,`province`,`city` FROM `es_orgcom` WHERE `status` = 1 AND `cid` = 3 AND `ispid` = 7 ORDER BY `isbest` DESC,`sort` DESC,`sid` DESC LIMIT 6 [ RunTime:0.001643s ]
