SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001559s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000650s ]
SELECT * FROM `db_city` WHERE `domain` = 'cd' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000635s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001097s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001400s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 284 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000868s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.000980s ]
SELECT * FROM `db_seo` WHERE `url` = '/architect' LIMIT 1 [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001547s ]
SELECT COUNT(*) AS think_count FROM `db_member` WHERE `groupid` = 2 AND `truename` <> '' AND `areaid` = 284 AND `status` = 3 [ RunTime:0.039779s ]
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` = 284 AND `status` = 3 ORDER BY `userid` LIMIT 0,10 [ RunTime:0.009468s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.002342s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1521,1525,1530) [ RunTime:0.002775s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1026,1032) [ RunTime:0.001200s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1520,1525,1528,1531) [ RunTime:0.000782s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1032,1188,1297) [ RunTime:0.001256s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1526,1529) [ RunTime:0.000726s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1032,1281) [ RunTime:0.000724s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1528,1534) [ RunTime:0.000712s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1026,1032,1162) [ RunTime:0.000710s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1521,1524) [ RunTime:0.000547s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1026,1032) [ RunTime:0.000355s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1526,1530,1531) [ RunTime:0.000540s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1032,1162) [ RunTime:0.000563s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1523,1535) [ RunTime:0.000549s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1032) [ RunTime:0.000339s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1525,1529) [ RunTime:0.000797s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1032) [ RunTime:0.000542s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1521,1527,1530) [ RunTime:0.000823s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1525,1528) [ RunTime:0.000683s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE sjs IN (51439,51440,51441,51442,51443,51445,51446,51447,51448,51450) AND status=3 GROUP BY sjs [ RunTime:0.012564s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001772s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `sjs` IN (51439,51440,51441,51442,51443,51445,51446,51447,51448,51450) AND `status` = 3 [ RunTime:0.015972s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `zhuang` = 1514 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 3 [ RunTime:0.001849s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.001690s ]
SELECT `itemid`,`title`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` > 1147 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 8 [ RunTime:0.006368s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1576 ORDER BY `listorder` [ RunTime:0.000522s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1513 ORDER BY `listorder` [ RunTime:0.000405s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1655 ORDER BY `listorder` [ RunTime:0.000325s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` [ RunTime:0.000318s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1474 ORDER BY `listorder` [ RunTime:0.000264s ]
SELECT catid as id,parentid as pid,catname as title FROM `db_category` WHERE `parentid` = 1610 ORDER BY `listorder` [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001137s ]
SELECT *,areaname as title FROM `db_area` WHERE `parentid` = 284 ORDER BY `areaid` [ RunTime:0.010012s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000464s ]
