SHOW FULL COLUMNS FROM `es_config` [ RunTime:0.050026s ]
SELECT * FROM `es_config` WHERE `id` = 2 LIMIT 1 [ RunTime:0.049866s ]
SELECT `catid`,`catname`,`catdesc` FROM `es_classify` WHERE `ctype` = 1 ORDER BY `catsort` DESC [ RunTime:0.049893s ]
SHOW FULL COLUMNS FROM `es_arealatlng` [ RunTime:0.050203s ]
SELECT * FROM `es_arealatlng` WHERE `ispid` = 1 [ RunTime:0.049831s ]
SELECT COUNT(*) AS think_count FROM `es_orgcom` `a` LEFT JOIN ( SELECT `uid`,COUNT(*) as count FROM `es_course` GROUP BY `uid` ) `b` ON `b`.`uid`=`a`.`uid` WHERE `a`.`ispid` = '1' AND `a`.`status` = '1' AND `a`.`cid` = '2' AND `a`.`isauth` = '1' AND `a`.`catid` > '0' LIMIT 1 [ RunTime:0.050934s ]
SELECT a.files,a.names,a.content,a.address,a.level,a.catname,a.uid,IFNULL(b.count, 0) as count FROM `es_orgcom` `a` LEFT JOIN ( SELECT `uid`,COUNT(*) as count FROM `es_course` GROUP BY `uid` ) `b` ON `b`.`uid`=`a`.`uid` WHERE `a`.`ispid` = '1' AND `a`.`status` = '1' AND `a`.`cid` = '2' AND `a`.`isauth` = '1' AND `a`.`catid` > '0' ORDER BY `a`.`sort` DESC,`a`.`sid` DESC LIMIT 50,10 [ RunTime:0.051179s ]
SELECT `sid`,`uid`,`names`,`files`,`level`,`catname`,`province`,`city` FROM `es_orgcom` WHERE `status` = 1 AND `cid` = 2 AND `isbest` = 1 ORDER BY `sort` DESC,`sid` DESC LIMIT 6 [ RunTime:0.050097s ]
