SHOW FULL COLUMNS FROM `es_classify` [ RunTime:0.051126s ]
SELECT * FROM `es_classify` WHERE `ctype` = 1 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050820s ]
SELECT * FROM `es_classify` WHERE `ctype` = 2 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050798s ]
SELECT * FROM `es_classify` WHERE `ctype` = 3 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050650s ]
SELECT * FROM `es_classify` WHERE `ctype` = 4 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050746s ]
SELECT * FROM `es_classify` WHERE `ctype` = 5 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050674s ]
SELECT * FROM `es_classify` WHERE `ctype` = 6 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050665s ]
SELECT * FROM `es_classify` WHERE `ctype` = 7 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050620s ]
SELECT * FROM `es_classify` WHERE `ctype` = 8 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050713s ]
SELECT * FROM `es_classify` WHERE `ctype` = 9 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.050720s ]
SELECT * FROM `es_classify` WHERE `ctype` = 10 AND `ispid` IN (0,1) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.054835s ]
SHOW FULL COLUMNS FROM `es_county` [ RunTime:0.051131s ]
SELECT `id`,`title`,`name`,`domain`,`tel` FROM `es_county` WHERE `ispid` = 1 ORDER BY `id` ASC [ RunTime:0.058760s ]
SHOW FULL COLUMNS FROM `es_ispconfig` [ RunTime:0.051183s ]
SELECT * FROM `es_ispconfig` WHERE `ispid` = 1 LIMIT 1 [ RunTime:0.050613s ]
SHOW FULL COLUMNS FROM `es_ispmini` [ RunTime:0.051102s ]
SELECT * FROM `es_ispmini` WHERE `id` = 1 LIMIT 1 [ RunTime:0.050721s ]
SELECT `id`,`domain`,`sitename`,`sitelogo`,`sitekeys`,`sitedesc`,`miniqrcode`,`dingyuehao`,`fuwuhao`,`manager`,`unioncom`,`operation`,`sitetel`,`email`,`icpnum` FROM `es_ispmini` WHERE `id` = 1 LIMIT 1 [ RunTime:0.050625s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 AND `ispid` = 1 ORDER BY `catsort` DESC [ RunTime:0.050712s ]
SELECT `xueduan`,`tianshu` FROM `es_ispconfig` WHERE `ispid` = 1 LIMIT 1 [ RunTime:0.050633s ]
SELECT `id`,`name`,`title`,`tel` FROM `es_county` WHERE `ispid` = 1 ORDER BY `id` ASC [ RunTime:0.050631s ]
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` = '78022' LIMIT 1 [ RunTime:0.052820s ]
SELECT `id`,`title`,`docfile`,`content` FROM `es_cubefore` WHERE `cuid` = 78022 ORDER BY `id` ASC [ RunTime:0.051269s ]
SELECT `title`,`album`,`content` FROM `es_cutrip` WHERE `cuid` = 78022 ORDER BY `id` ASC [ RunTime:0.051929s ]
SELECT `title`,`price`,`content` FROM `es_cucost` WHERE `cuid` = 78022 AND `status` = 1 ORDER BY `price` ASC [ RunTime:0.051061s ]