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.053269s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 ORDER BY `catsort` DESC [ RunTime:0.053285s ]
SELECT `xueduan`,`tianshu` FROM `es_ispconfig` WHERE `ispid` = 1 LIMIT 1 [ RunTime:0.053142s ]
SELECT `id`,`name`,`title`,`tel` FROM `es_county` WHERE `ispid` = 1 ORDER BY `id` ASC [ RunTime:0.053295s ]
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` = '773' LIMIT 1 [ RunTime:0.054765s ]
SELECT `id`,`title`,`docfile`,`content` FROM `es_cubefore` WHERE `cuid` = 773 ORDER BY `id` ASC [ RunTime:0.053560s ]
SELECT `title`,`album`,`content` FROM `es_cutrip` WHERE `cuid` = 773 ORDER BY `id` ASC [ RunTime:0.054087s ]
SELECT `title`,`price`,`content` FROM `es_cucost` WHERE `cuid` = 773 AND `status` = 1 ORDER BY `price` ASC [ RunTime:0.053506s ]
豫公网安备 41030502000371号
