SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001705s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000512s ]
SELECT * FROM `db_city` WHERE `domain` = 'sy' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001239s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000509s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001241s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 69 [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.001006s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000453s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001143s ]
SELECT * FROM `db_seo` WHERE `url` = '/architect' LIMIT 1 [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.002386s ]
SELECT COUNT(*) AS think_count FROM `db_member` WHERE `groupid` = 2 AND `truename` <> '' AND `areaid` = 69 AND `status` = 3 [ RunTime:0.004945s ]
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` = 69 AND `status` = 3 ORDER BY `userid` LIMIT 0,10 [ RunTime:0.008438s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001389s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1662 [ RunTime:0.000385s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1521,1524) [ RunTime:0.000628s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1026,1029,1032) [ RunTime:0.000556s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1523,1534) [ RunTime:0.000613s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1032) [ RunTime:0.000564s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1663 [ RunTime:0.000486s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1525,1535) [ RunTime:0.000569s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1028,1032) [ RunTime:0.000403s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1522,1525) [ RunTime:0.000587s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1026,1028) [ RunTime:0.000508s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1522,1526) [ RunTime:0.000614s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027) [ RunTime:0.000566s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1525) [ RunTime:0.000406s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1026,1032) [ RunTime:0.000563s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1660 [ RunTime:0.000477s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1521,1535) [ RunTime:0.000616s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1032,1188) [ RunTime:0.000620s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 0 [ RunTime:0.000366s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1519,1521,1525,1526) [ RunTime:0.000626s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1031,1032) [ RunTime:0.000567s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1665 [ RunTime:0.000488s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1524,1528,1535) [ RunTime:0.000617s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1029,1032) [ RunTime:0.000541s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1656 [ RunTime:0.000368s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1522,1524,1530,1532,1535) [ RunTime:0.000650s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1026,1032,1161,1298) [ RunTime:0.000567s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE sjs IN (51688,51712,51713,51714,51715,51716,52263,52264,52265,52266) AND status=3 GROUP BY sjs [ RunTime:0.010188s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001190s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `sjs` IN (51688,51712,51713,51714,51715,51716,52263,52264,52265,52266) AND `status` = 3 [ RunTime:0.010287s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `zhuang` = 1514 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 3 [ RunTime:0.000731s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.000923s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000468s ]