SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001375s ]
SELECT * FROM `db_city` WHERE `domain` = 'bj' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001328s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000321s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001254s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `existence` = 1 AND `pt` = 1 [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000808s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001051s ]
SELECT * FROM `db_seo` WHERE `url` = '/cityindex' LIMIT 1 [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `db_ad` [ RunTime:0.002113s ]
SELECT * FROM `db_ad` WHERE `pid` = 12 AND `areaid` = 1 AND `status` = 3 ORDER BY `listorder` ASC [ RunTime:0.002569s ]
SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.001518s ]
SELECT `itemid`,`item`,`thumb`,`title` FROM `db_photo_item` WHERE `status` = 3 ORDER BY `is_tj` DESC,`hits` DESC LIMIT 14 [ RunTime:13.716804s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001227s ]
SELECT * FROM `db_company` WHERE `areaid` = 1 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC LIMIT 60 [ RunTime:0.009609s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001076s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50219 [ RunTime:0.005482s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.001480s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50219 [ RunTime:0.000386s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50034 [ RunTime:0.005427s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50034 [ RunTime:0.000394s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50003 [ RunTime:0.005328s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50003 [ RunTime:0.000384s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51053 [ RunTime:0.005513s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51053 [ RunTime:0.000422s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51008 [ RunTime:0.005248s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51008 [ RunTime:0.000403s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51004 [ RunTime:0.005287s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51004 [ RunTime:0.000384s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50997 [ RunTime:0.005216s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50997 [ RunTime:0.000374s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50990 [ RunTime:0.005348s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50990 [ RunTime:0.000512s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50984 [ RunTime:0.005255s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50984 [ RunTime:0.000240s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50980 [ RunTime:0.005217s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50980 [ RunTime:0.000232s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50935 [ RunTime:0.005174s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50935 [ RunTime:0.001105s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50929 [ RunTime:0.005265s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50929 [ RunTime:0.001011s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50922 [ RunTime:0.005256s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50922 [ RunTime:0.001071s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50920 [ RunTime:0.005109s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50920 [ RunTime:0.001010s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50909 [ RunTime:0.005096s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50909 [ RunTime:0.001039s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50908 [ RunTime:0.006093s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50908 [ RunTime:0.001470s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50902 [ RunTime:0.008245s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50902 [ RunTime:0.001517s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50899 [ RunTime:0.007951s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50899 [ RunTime:0.001591s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50898 [ RunTime:0.007966s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50898 [ RunTime:0.001548s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50896 [ RunTime:0.008144s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50896 [ RunTime:0.001597s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50893 [ RunTime:0.008060s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50893 [ RunTime:0.001581s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50887 [ RunTime:0.008207s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50887 [ RunTime:0.001550s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50882 [ RunTime:0.008138s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50882 [ RunTime:0.001587s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50881 [ RunTime:0.008124s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50881 [ RunTime:0.001558s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50868 [ RunTime:0.008107s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50868 [ RunTime:0.001544s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50864 [ RunTime:0.008018s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50864 [ RunTime:0.001551s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50860 [ RunTime:0.008691s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50860 [ RunTime:0.001727s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50858 [ RunTime:0.008210s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50858 [ RunTime:0.001610s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50851 [ RunTime:0.008076s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50851 [ RunTime:0.001569s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50843 [ RunTime:0.008198s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50843 [ RunTime:0.001599s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50836 [ RunTime:0.008214s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50836 [ RunTime:0.001921s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50834 [ RunTime:0.008501s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50834 [ RunTime:0.001670s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50827 [ RunTime:0.008400s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50827 [ RunTime:0.001696s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50823 [ RunTime:0.008194s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50823 [ RunTime:0.001490s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50818 [ RunTime:0.007998s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50818 [ RunTime:0.001473s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50810 [ RunTime:0.008089s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50810 [ RunTime:0.000251s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50802 [ RunTime:0.008070s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50802 [ RunTime:0.000251s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50794 [ RunTime:0.007895s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50794 [ RunTime:0.000388s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50786 [ RunTime:0.008124s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50786 [ RunTime:0.000396s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50784 [ RunTime:0.008039s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50784 [ RunTime:0.000495s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50778 [ RunTime:0.008080s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50778 [ RunTime:0.000398s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50774 [ RunTime:0.008297s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50774 [ RunTime:0.000393s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50753 [ RunTime:0.008064s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50753 [ RunTime:0.000390s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50747 [ RunTime:0.008124s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50747 [ RunTime:0.000394s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50741 [ RunTime:0.008186s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50741 [ RunTime:0.000395s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50733 [ RunTime:0.008121s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50733 [ RunTime:0.000393s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50730 [ RunTime:0.008176s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50730 [ RunTime:0.000394s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50717 [ RunTime:0.008051s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50717 [ RunTime:0.000396s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50710 [ RunTime:0.008074s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50710 [ RunTime:0.000395s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50708 [ RunTime:0.008138s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50708 [ RunTime:0.000396s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50664 [ RunTime:0.008051s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50664 [ RunTime:0.001556s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50652 [ RunTime:0.008275s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50652 [ RunTime:0.001546s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50646 [ RunTime:0.008185s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50646 [ RunTime:0.001630s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50629 [ RunTime:0.008118s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50629 [ RunTime:0.001614s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50620 [ RunTime:0.008116s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50620 [ RunTime:0.001587s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50608 [ RunTime:0.008119s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50608 [ RunTime:0.001539s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50601 [ RunTime:0.008020s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50601 [ RunTime:0.001757s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50584 [ RunTime:0.008011s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50584 [ RunTime:0.001568s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50578 [ RunTime:0.008130s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50578 [ RunTime:0.001544s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 50572 [ RunTime:0.008261s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 50572 [ RunTime:0.001544s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001648s ]
SELECT `userid`,`company`,`p_userid`,`exp`,`sj_price_catids`,`sj_style_catids`,`sj_type_catdis`,`areaid`,`thumb`,`truename` FROM `db_member` WHERE ( `provinceid` = 1 OR `cityid` = 1 OR `provinceid` = 1 ) AND `groupid` = 2 AND `status` = 3 ORDER BY `exp` DESC LIMIT 8 [ RunTime:0.006315s ]
SHOW FULL COLUMNS FROM `db_tag` [ RunTime:0.001146s ]
SELECT * FROM `db_tag` WHERE `status` = 3 ORDER BY `id` DESC LIMIT 8 [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `db_overman` [ RunTime:0.001898s ]
SELECT `ov`.* FROM `db_overman` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 1 AND `ov`.`status` = 3 LIMIT 10 [ RunTime:0.000917s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`status` = 3 AND `m`.`groupid` = 1 AND `p`.`is_tj` = 2 AND `p`.`companyid` > 0 AND `m`.`areaid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 3 [ RunTime:0.017385s ]
SELECT * FROM `db_photo_item` WHERE `itemid` > 1895428 AND `is_qj` = 1 AND `status` = 3 ORDER BY `is_tj` DESC,`hits` DESC LIMIT 3 [ RunTime:0.002022s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.002213s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE ( `provinceid` = 1 OR `cityid` = 1 ) AND `catid` IN (1426,1427,1428,1430,1429,1669,1670,1431,1671,1435,1432,1433,1434,1436,1673,1437,1424) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 9 [ RunTime:0.847519s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001063s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1674 ORDER BY `listorder` [ RunTime:0.000265s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1713 ORDER BY `listorder` [ RunTime:0.000232s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1714 ORDER BY `listorder` [ RunTime:0.000229s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1715 ORDER BY `listorder` [ RunTime:0.000233s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1716 ORDER BY `listorder` [ RunTime:0.000226s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE ( `provinceid` = 1 OR `cityid` = 1 ) AND `catid` IN (1713,1714,1715,1716,1674) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 9 [ RunTime:0.049551s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE ( `provinceid` = 1 OR `cityid` = 1 ) AND `catid` IN (1681,1682,1683,1684,1685,1686,1687,1688,1689,1690,1691,1479) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 9 [ RunTime:0.013187s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE ( `provinceid` = 1 OR `cityid` = 1 ) AND `catid` IN (1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1480) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 9 [ RunTime:0.003655s ]
SELECT `c`.*,`m`.`company_jc` FROM `db_comment` `c` LEFT JOIN `db_member` `m` ON `c`.`userid`=`m`.`userid` WHERE ( `m`.`cityid` = 1 OR `m`.`provinceid` = 1 ) AND `m`.`groupid` = 1 AND `c`.`pics` <> '' ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.005173s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001653s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000408s ]
SELECT `catname` FROM `db_category` WHERE `catid` = 1566 LIMIT 1 [ RunTime:0.000560s ]
SELECT `catname` FROM `db_category` WHERE `catid` = 1573 LIMIT 1 [ RunTime:0.000246s ]
SELECT `catname` FROM `db_category` WHERE `catid` = 1668 LIMIT 1 [ RunTime:0.000234s ]
SELECT `catname` FROM `db_category` WHERE `catid` = 1574 LIMIT 1 [ RunTime:0.000257s ]
SELECT `catname` FROM `db_category` WHERE `catid` = 1563 LIMIT 1 [ RunTime:0.000183s ]
SELECT `catname` FROM `db_category` WHERE `catid` = 1564 LIMIT 1 [ RunTime:0.000183s ]
SELECT `catname` FROM `db_category` WHERE `catid` = 0 LIMIT 1 [ RunTime:0.000187s ]
