SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001315s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000493s ]
SELECT * FROM `db_city` WHERE `domain` = 'yinchuan' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001329s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001240s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 369 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000889s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000290s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001090s ]
SELECT * FROM `db_seo` WHERE `url` = '/cityindex' LIMIT 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `db_ad` [ RunTime:0.003372s ]
SELECT * FROM `db_ad` WHERE `pid` = 10 AND `status` = 3 ORDER BY `listorder` ASC [ RunTime:0.000648s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001529s ]
SELECT * FROM `db_company` WHERE `areaid` = 369 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC LIMIT 18 [ RunTime:0.000602s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.002553s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53001 [ RunTime:0.015076s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.002999s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53001 [ RunTime:0.000383s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53019 [ RunTime:0.008971s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53019 [ RunTime:0.000343s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53058 [ RunTime:0.008973s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53058 [ RunTime:0.000348s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53065 [ RunTime:0.008558s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53065 [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.002517s ]
SELECT `userid`,`company`,`p_userid`,`exp`,`sj_price_catids`,`sj_style_catids`,`sj_type_catdis`,`thumb`,`truename` FROM `db_member` WHERE ( `provinceid` = 369 OR `cityid` = 369 OR `provinceid` = 369 ) AND `groupid` = 2 AND `status` = 3 ORDER BY `exp` DESC LIMIT 15 [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `db_tag` [ RunTime:0.001284s ]
SELECT * FROM `db_tag` WHERE `status` = 3 ORDER BY `id` DESC LIMIT 15 [ RunTime:0.000328s ]
SELECT `p`.`itemid`,`p`.`hits`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`cityjq`,`p`.`community`,`p`.`companyid`,`c`.`userid`,`c`.`company_jc`,`p`.`mianji`,`p`.`zaojia` FROM `db_photo` `p` LEFT JOIN `db_member` `c` ON `c`.`userid`=`p`.`mid` WHERE `p`.`is_tj` = 2 AND `p`.`status` = 3 AND `c`.`status` = 3 AND `c`.`groupid` = 1 AND `c`.`areaid` = 369 ORDER BY `p`.`listorder` DESC,`p`.`itemid` DESC LIMIT 10 [ RunTime:0.014456s ]
SHOW FULL COLUMNS FROM `db_overman` [ RunTime:0.002441s ]
SELECT `ov`.* FROM `db_overman` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 369 AND `ov`.`status` = 3 LIMIT 10 [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.002207s ]
SELECT * FROM `db_news` WHERE `types` = 1 AND ( `provinceid` = 369 OR `cityid` = 369 ) AND `status` = 3 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 12 [ RunTime:0.001690s ]
SHOW FULL COLUMNS FROM `db_company_news` [ RunTime:0.002282s ]
SELECT `ov`.* FROM `db_company_news` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 369 AND `ov`.`status` = 3 ORDER BY `listorder` DESC LIMIT 12 [ RunTime:0.045700s ]
SHOW FULL COLUMNS FROM `db_gongdi` [ RunTime:0.002660s ]
SELECT `g`.*,`m`.`userid` FROM `db_gongdi` `g` LEFT JOIN `db_member` `m` ON `m`.`username`=`g`.`username` WHERE `m`.`areaid` = 369 AND `g`.`status` = 3 AND `g`.`status` = 3 ORDER BY `itemid` ASC LIMIT 0,8 [ RunTime:0.028638s ]
SELECT `company_jc`,`userid`,`thumb`,`thumb2`,`areaid` FROM `db_company` WHERE `areaid` = 369 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC,`is_recomment` DESC LIMIT 15 [ RunTime:0.000599s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53001 [ RunTime:0.000453s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53001 [ RunTime:0.000448s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53019 [ RunTime:0.000461s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53019 [ RunTime:0.000389s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53058 [ RunTime:0.000306s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53058 [ RunTime:0.000315s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 53065 [ RunTime:0.000337s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53065 [ RunTime:0.000297s ]
SELECT * FROM `db_news` WHERE `types` = 2 AND ( `provinceid` = 369 OR `cityid` = 369 OR `areaid` = 369 ) AND `status` = 3 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 6 [ RunTime:0.001709s ]
SELECT `userid`,`truename`,`p_userid`,`thumb`,`sj_style_catids`,`sj_type_catdis`,`exp` FROM `db_member` WHERE `groupid` = 2 AND `areaid` = 369 AND `status` = 3 AND `status` = 3 AND `status` = 3 ORDER BY `userid` DESC LIMIT 10 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.002117s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1522,1524,1534) ORDER BY `listorder` [ RunTime:0.000463s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1523,1525,1534) ORDER BY `listorder` [ RunTime:0.000422s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1525,1526,1527) ORDER BY `listorder` [ RunTime:0.000449s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1522,1524,1527,1528,1534) ORDER BY `listorder` [ RunTime:0.000455s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1520,1524,1525) ORDER BY `listorder` [ RunTime:0.000444s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1521,1523,1527,1530) ORDER BY `listorder` [ RunTime:0.000454s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1525,1529,1531) ORDER BY `listorder` [ RunTime:0.000454s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1521,1524,1528) ORDER BY `listorder` [ RunTime:0.000446s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1524,1529,1535) ORDER BY `listorder` [ RunTime:0.000454s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1524,1526,1528) ORDER BY `listorder` [ RunTime:0.000445s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.002279s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'yinchuan' 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 3 [ RunTime:0.875324s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 369 AND `cityjq` = 'www' AND `itemid` NOT IN (569284,569289,569291) 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 6 [ RunTime:3.680756s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'yinchuan' AND `catid` IN (1695,1694,1696,1693,1692,1697,1698,1699,1700,1712,1441,1442) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.011970s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` IN (1695,1694,1696,1693,1692,1697,1698,1699,1700,1712,1441,1442) AND `cityjqid` = 0 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.004939s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 369 AND `cityjq` = 'www' AND `itemid` NOT IN (2747,566414,566415) AND `catid` IN (1695,1694,1696,1693,1692,1697,1698,1699,1700,1712,1441,1442) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 6 [ RunTime:0.009961s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'www' AND `itemid` NOT IN (2747,566414,566415) AND `catid` IN (1695,1694,1696,1693,1692,1697,1698,1699,1700,1712,1441,1442) AND `itemid` NOT IN (569745,569750,569731,569739,569755) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 1 [ RunTime:0.007398s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'yinchuan' AND `catid` IN (1675,1676,1677,1678,1679,1680,1440) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.091431s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` IN (1675,1676,1677,1678,1679,1680,1440) AND `cityjqid` = 0 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.057050s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 369 AND `cityjq` = 'www' AND `catid` IN (1675,1676,1677,1678,1679,1680,1440) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 6 [ RunTime:0.058087s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'www' AND `catid` IN (1675,1676,1677,1678,1679,1680,1440) AND `itemid` NOT IN (569728,569719,569714,569713,569723) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 1 [ RunTime:0.062051s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`cityjq`,`areaid` FROM `db_article` WHERE `cityjq` = 'yinchuan' 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 3 [ RunTime:0.008998s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`cityjq`,`areaid` FROM `db_article` WHERE `cityjqid` = 369 AND `cityjq` = 'www' AND `itemid` NOT IN (569236,569240,569238) 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 6 [ RunTime:0.008793s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'yinchuan' 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 3 [ RunTime:0.004273s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 369 AND `cityjq` = 'www' AND `itemid` NOT IN (566494,566490,566488) 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 6 [ RunTime:0.005108s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'www' AND `itemid` NOT IN (566494,566490,566488) AND `catid` IN (1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1480) AND `itemid` NOT IN (569448,569433,569446,569437,569442) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 1 [ RunTime:0.006286s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'yinchuan' AND `catid` = 1438 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.047341s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` = 1438 AND `cityjqid` = 0 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.033610s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 369 AND `cityjq` = 'www' AND `itemid` NOT IN (558041,557022,556947) AND `catid` = 1438 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 6 [ RunTime:0.034752s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'www' AND `itemid` NOT IN (558041,557022,556947) AND `catid` = 1438 AND `itemid` <> 569452 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 5 [ RunTime:0.037811s ]
SELECT `c`.*,`m`.`company_jc`,`m`.`areaid` FROM `db_comment` `c` LEFT JOIN `db_member` `m` ON `c`.`userid`=`m`.`userid` WHERE `m`.`areaid` = 369 AND `m`.`groupid` = 1 AND `c`.`pics` <> '' ORDER BY `id` DESC LIMIT 0,12 [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001942s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000288s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53001 [ RunTime:0.000281s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53019 [ RunTime:0.000251s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53058 [ RunTime:0.000246s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 53065 [ RunTime:0.000241s ]