SHOW FULL COLUMNS FROM `es_config` [ RunTime:0.057453s ]
SELECT * FROM `es_config` WHERE `id` = 2 LIMIT 1 [ RunTime:0.057051s ]
SHOW FULL COLUMNS FROM `es_arealatlng` [ RunTime:0.057449s ]
SELECT * FROM `es_arealatlng` WHERE `ispid` = 1 [ RunTime:0.057172s ]
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` = '3' AND `a`.`isauth` = '1' LIMIT 1 [ RunTime:0.058213s ]
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` = '3' AND `a`.`isauth` = '1' ORDER BY `a`.`sort` DESC,`a`.`sid` DESC LIMIT 40,10 [ RunTime:0.058426s ]
SELECT `sid`,`uid`,`names`,`files`,`level`,`catname`,`province`,`city` FROM `es_orgcom` WHERE `status` = 1 AND `cid` = 3 AND `isbest` = 1 ORDER BY `sort` DESC,`sid` DESC LIMIT 6 [ RunTime:0.057540s ]