SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001445s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000552s ]
SELECT * FROM `db_city` WHERE `domain` = 'yinchuan' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000542s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001085s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001069s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 369 [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.001067s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.000973s ]
SELECT * FROM `db_seo` WHERE `url` = '/architect' LIMIT 1 [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001906s ]
SELECT COUNT(*) AS think_count FROM `db_member` WHERE `groupid` = 2 AND `truename` <> '' AND `areaid` = 369 AND `status` = 3 [ RunTime:0.045757s ]
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` = 369 AND `status` = 3 ORDER BY `userid` LIMIT 0,10 [ RunTime:0.014453s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001354s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1521,1523,1527) [ RunTime:0.002414s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1026,1029,1032) [ RunTime:0.001016s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1526,1528) [ RunTime:0.000670s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1025,1032) [ RunTime:0.000622s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1522,1524,1527) [ RunTime:0.000638s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1029,1032) [ RunTime:0.000599s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1524,1527) [ RunTime:0.000608s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1028,1032) [ RunTime:0.000566s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1521,1526) [ RunTime:0.000600s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1029,1032) [ RunTime:0.000522s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1522,1526,1528,1535) [ RunTime:0.000615s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1032) [ RunTime:0.000516s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1523,1524) [ RunTime:0.000731s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1520,1522,1526,1535) [ RunTime:0.000646s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1026,1029,1032) [ RunTime:0.000524s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1523,1531,1535) [ RunTime:0.000527s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1026,1027,1028,1032) [ RunTime:0.000530s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1520,1524,1531,1535) [ RunTime:0.000542s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1026,1028,1032) [ RunTime:0.000530s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE sjs IN (53002,53003,53004,53005,53006,53020,53021,53022,53023,53024) AND status=3 GROUP BY sjs [ RunTime:0.011498s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001677s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `sjs` IN (53002,53003,53004,53005,53006,53020,53021,53022,53023,53024) AND `status` = 3 [ RunTime:0.015925s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `zhuang` = 1514 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 3 [ RunTime:0.001669s ]
SELECT `domain` FROM `db_city` WHERE `areaid` = 374 LIMIT 1 [ RunTime:0.001771s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001247s ]
SELECT *,areaname as title FROM `db_area` WHERE `parentid` = 369 ORDER BY `areaid` [ RunTime:0.010645s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000478s ]
