SHOW FULL COLUMNS FROM `es_classify` [ RunTime:0.001875s ]
SELECT * FROM `es_classify` WHERE `ctype` = 1 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.002907s ]
SELECT * FROM `es_classify` WHERE `ctype` = 2 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001566s ]
SELECT * FROM `es_classify` WHERE `ctype` = 3 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001661s ]
SELECT * FROM `es_classify` WHERE `ctype` = 4 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001826s ]
SELECT * FROM `es_classify` WHERE `ctype` = 5 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001627s ]
SELECT * FROM `es_classify` WHERE `ctype` = 6 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001784s ]
SELECT * FROM `es_classify` WHERE `ctype` = 7 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001666s ]
SELECT * FROM `es_classify` WHERE `ctype` = 8 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001431s ]
SELECT * FROM `es_classify` WHERE `ctype` = 9 AND `ispid` = 7 ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.001631s ]
SELECT * FROM `es_classify` WHERE `ctype` = 10 AND `ispid` IN (0,7) ORDER BY `catsort` DESC,`catid` DESC [ RunTime:0.003320s ]
SHOW FULL COLUMNS FROM `es_county` [ RunTime:0.002922s ]
SELECT `id`,`title`,`name`,`domain`,`tel` FROM `es_county` WHERE `ispid` = 7 ORDER BY `id` ASC [ RunTime:0.002132s ]
SHOW FULL COLUMNS FROM `es_ispconfig` [ RunTime:0.002123s ]
SELECT * FROM `es_ispconfig` WHERE `ispid` = 7 LIMIT 1 [ RunTime:0.002121s ]
SHOW FULL COLUMNS FROM `es_ispmini` [ RunTime:0.002063s ]
SELECT * FROM `es_ispmini` WHERE `id` = 7 LIMIT 1 [ RunTime:0.003630s ]
SHOW FULL COLUMNS FROM `es_arealatlng` [ RunTime:0.001729s ]
SELECT * FROM `es_arealatlng` WHERE `ispid` = 7 [ RunTime:0.004383s ]
SHOW FULL COLUMNS FROM `es_orgcom` [ RunTime:0.003147s ]
SELECT COUNT(*) AS think_count FROM `es_orgcom` WHERE `district` = '饶阳县' AND `ispid` = 7 AND `status` = 1 AND `cid` = 2 AND `isauth` = 1 AND `catid` = 122 AND `level` = '市级' AND ( 1 and (close_time not like '%周一%' or close_time is null) ) LIMIT 1 [ RunTime:0.015523s ]
SELECT `sid`,`uid`,`names`,`cid`,`catname`,`cname`,`tel`,`files`,`province`,`city`,`district`,`level`,`content`,`address` FROM `es_orgcom` WHERE `district` = '饶阳县' AND `ispid` = 7 AND `status` = 1 AND `cid` = 2 AND `isauth` = 1 AND `catid` = 122 AND `level` = '市级' AND ( 1 and (close_time not like '%周一%' or close_time is null) ) ORDER BY sort desc,sid desc LIMIT 0,12 [ RunTime:0.014952s ]
SHOW FULL COLUMNS FROM `es_mallad` [ RunTime:0.002205s ]
SELECT `id`,`adtitle`,`files`,`url` FROM `es_mallad` WHERE `tagend` = 1 AND `position` = 6 AND `status` = 1 AND `ispid` = 7 ORDER BY `sort` DESC,`id` DESC LIMIT 5 [ RunTime:0.001918s ]