SHOW FULL COLUMNS FROM `es_classify` [ RunTime:0.063151s ]
SELECT * FROM `es_classify` WHERE `ctype` = 1 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.063003s ]
SELECT * FROM `es_classify` WHERE `ctype` = 2 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.063099s ]
SELECT * FROM `es_classify` WHERE `ctype` = 3 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.062980s ]
SELECT * FROM `es_classify` WHERE `ctype` = 4 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.062899s ]
SELECT * FROM `es_classify` WHERE `ctype` = 5 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.063046s ]
SELECT * FROM `es_classify` WHERE `ctype` = 6 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.062853s ]
SELECT * FROM `es_classify` WHERE `ctype` = 7 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.062853s ]
SELECT * FROM `es_classify` WHERE `ctype` = 8 AND `ispid` = 11 ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.062905s ]
SELECT * FROM `es_classify` WHERE `ctype` = 9 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.062927s ]
SELECT * FROM `es_classify` WHERE `ctype` = 10 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.062855s ]
SHOW FULL COLUMNS FROM `es_county` [ RunTime:0.063264s ]
SELECT `id`,`title`,`name`,`domain`,`tel` FROM `es_county` WHERE `ispid` = 11 ORDER BY `id` ASC [ RunTime:0.062833s ]
SHOW FULL COLUMNS FROM `es_ispconfig` [ RunTime:0.063368s ]
SELECT * FROM `es_ispconfig` WHERE `ispid` = 11 LIMIT 1 [ RunTime:0.062861s ]
SHOW FULL COLUMNS FROM `es_ispmini` [ RunTime:0.063271s ]
SELECT * FROM `es_ispmini` WHERE `id` = 11 LIMIT 1 [ RunTime:0.062880s ]
SELECT `id`,`domain`,`sitename`,`sitelogo`,`sitekeys`,`sitedesc`,`miniqrcode`,`dingyuehao`,`fuwuhao`,`manager`,`unioncom`,`operation`,`sitetel`,`email`,`icpnum` FROM `es_ispmini` WHERE `id` = 11 LIMIT 1 [ RunTime:0.063045s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 AND `ispid` = 11 ORDER BY `catsort` DESC [ RunTime:0.063068s ]
SELECT `xueduan`,`tianshu` FROM `es_ispconfig` WHERE `ispid` = 11 LIMIT 1 [ RunTime:0.062885s ]
SELECT `id`,`name`,`title`,`tel` FROM `es_county` WHERE `ispid` = 11 ORDER BY `id` ASC [ RunTime:0.062989s ]
SELECT `a`.`id`,`a`.`uid`,`a`.`ispid`,`a`.`title`,`a`.`ctype`,`a`.`shdesc`,`a`.`mantime`,`a`.`vfile`,`a`.`album`,`a`.`xtags`,`a`.`ttags`,`a`.`catname`,`a`.`content`,`b`.`usertype`,`c`.`min_price`,`c`.`max_price`,d.uid as jg_id,d.names as jg_name,d.files as jg_files,d.address as jg_address,`e`.`authappid`,`e`.`authtoken`,`f`.`lat`,`f`.`lng` FROM `es_course` `a` LEFT JOIN ( SELECT `id`,`mobile`,`account`,`nickname`,`names`,`usertype`,`status` FROM `es_user` ) `b` ON `a`.`uid`=`b`.`id` LEFT JOIN ( SELECT `cuid`,MIN(price) as min_price,MAX(price) as max_price FROM `es_cucost` GROUP BY `cuid` ) `c` ON `a`.`id`=`c`.`cuid` LEFT JOIN ( SELECT `uid`,`names`,`files`,`address`,`isauth` FROM `es_orgcom` ) `d` ON `a`.`uid`=`d`.`uid` LEFT JOIN ( SELECT `id`,`mininame`,`authappid`,`authtoken`,`mchid` FROM `es_ispmini` ) `e` ON `a`.`ispid`=`e`.`id` LEFT JOIN ( SELECT * FROM `es_cumaps` ) `f` ON `a`.`id`=`f`.`cuid` WHERE `a`.`id` = '78170' LIMIT 1 [ RunTime:0.064888s ]
SELECT `id`,`title`,`docfile`,`content` FROM `es_cubefore` WHERE `cuid` = 78170 ORDER BY `id` ASC [ RunTime:0.063186s ]
SELECT `title`,`album`,`content` FROM `es_cutrip` WHERE `cuid` = 78170 ORDER BY `id` ASC [ RunTime:0.064118s ]
SELECT `title`,`price`,`content` FROM `es_cucost` WHERE `cuid` = 78170 AND `status` = 1 ORDER BY `price` ASC [ RunTime:0.063192s ]
