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.049570s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 ORDER BY `catsort` DESC [ RunTime:0.049834s ]
SELECT `xueduan`,`tianshu` FROM `es_ispconfig` WHERE `ispid` = 1 LIMIT 1 [ RunTime:0.049449s ]
SELECT `id`,`name`,`title`,`tel` FROM `es_county` WHERE `ispid` = 1 ORDER BY `id` ASC [ RunTime:0.049888s ]
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` = '995' LIMIT 1 [ RunTime:0.051490s ]
SELECT `id`,`title`,`docfile`,`content` FROM `es_cubefore` WHERE `cuid` = 995 ORDER BY `id` ASC [ RunTime:0.049809s ]
SELECT `title`,`album`,`content` FROM `es_cutrip` WHERE `cuid` = 995 ORDER BY `id` ASC [ RunTime:0.050296s ]
SELECT `title`,`price`,`content` FROM `es_cucost` WHERE `cuid` = 995 AND `status` = 1 ORDER BY `price` ASC [ RunTime:0.049715s ]