SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001174s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000553s ]
SELECT * FROM `db_city` WHERE `domain` = 'hhht' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000593s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001583s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000570s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001740s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 57 [ RunTime:0.000648s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.001195s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001334s ]
SELECT * FROM `db_seo` WHERE `url` = '/architect' LIMIT 1 [ RunTime:0.000689s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.002445s ]
SELECT COUNT(*) AS think_count FROM `db_member` WHERE `groupid` = 2 AND `truename` <> '' AND `areaid` = 57 AND `status` = 3 [ RunTime:0.039776s ]
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` = 57 AND `status` = 3 ORDER BY `userid` LIMIT 0,10 [ RunTime:0.010696s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001067s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1661 [ RunTime:0.001745s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1522,1523,1526) [ RunTime:0.001306s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1025,1026,1032) [ RunTime:0.001012s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1521,1526,1535) [ RunTime:0.000599s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1026,1028,1032) [ RunTime:0.000582s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1522,1535) [ RunTime:0.000493s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1029,1032,1188) [ RunTime:0.000933s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1662 [ RunTime:0.000483s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1520,1523,1527,1535) [ RunTime:0.000496s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1026,1028,1032) [ RunTime:0.000531s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1656 [ RunTime:0.000488s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1521,1524,1526) [ RunTime:0.000504s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1028,1031,1161) [ RunTime:0.000500s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1526,1529,1535) [ RunTime:0.000479s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1026,1032,1161,1298) [ RunTime:0.000496s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1524,1527,1529,1532) [ RunTime:0.000519s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1161,1297) [ RunTime:0.000495s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1521,1525,1535) [ RunTime:0.000505s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1026,1028,1031,1298) [ RunTime:0.000480s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1522,1523) [ RunTime:0.000457s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1025,1026,1027) [ RunTime:0.000472s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1523,1535) [ RunTime:0.000490s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1298) [ RunTime:0.000477s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE sjs IN (52782,52783,52784,52785,52787,52788,52789,52790,52793,52794) AND status=3 GROUP BY sjs [ RunTime:0.054687s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001483s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `sjs` IN (52782,52783,52784,52785,52787,52788,52789,52790,52793,52794) AND `status` = 3 [ RunTime:0.011108s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `zhuang` = 1514 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 3 [ RunTime:0.001431s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.001220s ]
SELECT `itemid`,`title`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` > 1147 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 8 [ RunTime:0.006151s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1576 ORDER BY `listorder` [ RunTime:0.002006s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1513 ORDER BY `listorder` [ RunTime:0.000457s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1655 ORDER BY `listorder` [ RunTime:0.000910s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` [ RunTime:0.000851s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1474 ORDER BY `listorder` [ RunTime:0.000852s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1610 ORDER BY `listorder` [ RunTime:0.000852s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.000954s ]
SELECT *,areaname as title FROM `db_area` WHERE `parentid` = 57 ORDER BY `areaid` [ RunTime:0.008870s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000419s ]
