SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001148s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000403s ]
SELECT * FROM `db_city` WHERE `domain` = 'jn' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000453s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001130s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000621s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.000975s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 166 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000724s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000334s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.000702s ]
SELECT * FROM `db_seo` WHERE `url` = '/architect' LIMIT 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001253s ]
SELECT COUNT(*) AS think_count FROM `db_member` WHERE `groupid` = 2 AND `truename` <> '' AND `areaid` = 166 AND `status` = 3 [ RunTime:0.000437s ]
SELECT `userid`,`p_userid`,`company_jc`,`exp`,`sj_price_catids`,`sj_style_catids`,`sj_type_catdis`,`thumb`,`truename` FROM `db_member` WHERE `groupid` = 2 AND `truename` <> '' AND `areaid` = 166 AND `status` = 3 ORDER BY `userid` LIMIT 0,10 [ RunTime:0.000539s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001657s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1662 [ RunTime:0.000485s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1520,1523,1530) [ RunTime:0.000435s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 0 [ RunTime:0.000308s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1520,1529,1530) [ RunTime:0.000318s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1522,1523) [ RunTime:0.000275s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1523,1529,1530) [ RunTime:0.000284s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1660 [ RunTime:0.000253s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1530,1531) [ RunTime:0.000265s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1661 [ RunTime:0.000245s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1530) [ RunTime:0.000263s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1659 [ RunTime:0.000248s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1529,1530) [ RunTime:0.000268s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1530) [ RunTime:0.000259s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1524,1530) [ RunTime:0.000269s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE sjs IN (52307,52308,52309,52310,52311,52324,52325,52326,52327,52328) AND status=3 GROUP BY sjs [ RunTime:0.007539s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001040s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `sjs` IN (52307,52308,52309,52310,52311,52324,52325,52326,52327,52328) AND `status` = 3 [ RunTime:0.010900s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `zhuang` = 1514 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 3 [ RunTime:0.001353s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.000941s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000284s ]