SHOW FULL COLUMNS FROM `es_classify` [ RunTime:0.050827s ]
SELECT * FROM `es_classify` WHERE `ctype` = 1 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050729s ]
SELECT * FROM `es_classify` WHERE `ctype` = 2 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050694s ]
SELECT * FROM `es_classify` WHERE `ctype` = 3 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050708s ]
SELECT * FROM `es_classify` WHERE `ctype` = 4 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050603s ]
SELECT * FROM `es_classify` WHERE `ctype` = 5 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050530s ]
SELECT * FROM `es_classify` WHERE `ctype` = 6 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050572s ]
SELECT * FROM `es_classify` WHERE `ctype` = 7 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050522s ]
SELECT * FROM `es_classify` WHERE `ctype` = 8 AND `ispid` = 11 ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050585s ]
SELECT * FROM `es_classify` WHERE `ctype` = 9 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050591s ]
SELECT * FROM `es_classify` WHERE `ctype` = 10 AND `ispid` IN (0,11) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050482s ]
SHOW FULL COLUMNS FROM `es_county` [ RunTime:0.050993s ]
SELECT `id`,`title`,`name`,`domain`,`tel` FROM `es_county` WHERE `ispid` = 11 ORDER BY `id` ASC [ RunTime:0.050564s ]
SHOW FULL COLUMNS FROM `es_ispconfig` [ RunTime:0.051016s ]
SELECT * FROM `es_ispconfig` WHERE `ispid` = 11 LIMIT 1 [ RunTime:0.050361s ]
SHOW FULL COLUMNS FROM `es_ispmini` [ RunTime:0.051150s ]
SELECT * FROM `es_ispmini` WHERE `id` = 11 LIMIT 1 [ RunTime:0.050562s ]
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.050550s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 AND `ispid` = 11 ORDER BY `catsort` DESC [ RunTime:0.050659s ]
SELECT `xueduan`,`tianshu` FROM `es_ispconfig` WHERE `ispid` = 11 LIMIT 1 [ RunTime:0.050581s ]
SELECT `id`,`name`,`title`,`tel` FROM `es_county` WHERE `ispid` = 11 ORDER BY `id` ASC [ RunTime:0.050537s ]
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` = '78172' LIMIT 1 [ RunTime:0.052514s ]
SELECT `id`,`title`,`docfile`,`content` FROM `es_cubefore` WHERE `cuid` = 78172 ORDER BY `id` ASC [ RunTime:0.050988s ]
SELECT `title`,`album`,`content` FROM `es_cutrip` WHERE `cuid` = 78172 ORDER BY `id` ASC [ RunTime:0.051627s ]
SELECT `title`,`price`,`content` FROM `es_cucost` WHERE `cuid` = 78172 AND `status` = 1 ORDER BY `price` ASC [ RunTime:0.050939s ]
