SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001328s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000427s ]
SELECT * FROM `db_city` WHERE `domain` = 'fz' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000422s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001095s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001194s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 146 [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000961s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000317s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001074s ]
SELECT * FROM `db_seo` WHERE `url` = '/architect' LIMIT 1 [ RunTime:0.000385s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.002333s ]
SELECT COUNT(*) AS think_count FROM `db_member` WHERE `groupid` = 2 AND `truename` <> '' AND `areaid` = 146 AND `status` = 3 [ RunTime:0.012220s ]
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` = 146 AND `status` = 3 ORDER BY `userid` LIMIT 0,10 [ RunTime:0.011195s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001302s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1658 [ RunTime:0.001039s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1520,1527,1529) [ RunTime:0.001676s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1032) [ RunTime:0.001315s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1656 [ RunTime:0.000499s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1519,1521,1523) [ RunTime:0.000693s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1026,1028,1032) [ RunTime:0.000710s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1664 [ RunTime:0.000507s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1523,1526,1527) [ RunTime:0.000731s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027) [ RunTime:0.000654s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` = 1661 [ RunTime:0.000510s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1520,1523,1534) [ RunTime:0.000822s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1025,1027,1032,1162,1188) [ RunTime:0.001263s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1521,1523,1527,1535) [ RunTime:0.000735s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1026,1029,1032) [ RunTime:0.000650s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1522,1524,1529,1534,1535) [ RunTime:0.000686s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1026,1032,1188) [ RunTime:0.000676s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1523,1527,1529,1534) [ RunTime:0.000683s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1028,1032,1298) [ RunTime:0.000690s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1522,1524,1527) [ RunTime:0.000518s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1025,1026,1028,1032) [ RunTime:0.000684s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1518,1520,1521,1528,1530) [ RunTime:0.000696s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1521,1523,1524,1527) [ RunTime:0.000630s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `catid` IN (1024,1026,1027) [ RunTime:0.000562s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE sjs IN (52527,52533,52534,52535,52542,52543,52545,52546,52547,52559) AND status=3 GROUP BY sjs [ RunTime:0.011799s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001613s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`mid`,`sjs` FROM `db_photo` WHERE `sjs` IN (52527,52533,52534,52535,52542,52543,52545,52546,52547,52559) 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.002171s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001130s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000350s ]