SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001534s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000631s ]
SELECT * FROM `db_city` WHERE `domain` = 'lasa' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000597s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001384s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000567s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001208s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 330 [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000955s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001098s ]
SELECT * FROM `db_seo` WHERE `url` = '/cityindex' LIMIT 1 [ RunTime:0.000467s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001534s ]
SELECT * FROM `db_company` WHERE `areaid` = 330 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC LIMIT 18 [ RunTime:0.007380s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001577s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.008421s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.002079s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000468s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52922 [ RunTime:0.008280s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52922 [ RunTime:0.001829s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52928 [ RunTime:0.008314s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52928 [ RunTime:0.001677s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52983 [ RunTime:0.008289s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52983 [ RunTime:0.001781s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001658s ]
SELECT `userid`,`company`,`p_userid`,`exp`,`sj_price_catids`,`sj_style_catids`,`sj_type_catdis`,`thumb`,`truename` FROM `db_member` WHERE ( `provinceid` = 330 OR `cityid` = 330 OR `provinceid` = 330 ) AND `groupid` = 2 AND `status` = 3 ORDER BY `exp` DESC LIMIT 15 [ RunTime:0.009064s ]
SHOW FULL COLUMNS FROM `db_tag` [ RunTime:0.001224s ]
SELECT * FROM `db_tag` WHERE `status` = 3 ORDER BY `id` DESC LIMIT 15 [ RunTime:0.000572s ]
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` = 330 ORDER BY `p`.`listorder` DESC,`p`.`itemid` DESC LIMIT 10 [ RunTime:0.014402s ]
SHOW FULL COLUMNS FROM `db_overman` [ RunTime:0.002577s ]
SELECT `ov`.* FROM `db_overman` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 330 AND `ov`.`status` = 3 LIMIT 10 [ RunTime:0.009826s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.002024s ]
SELECT * FROM `db_news` WHERE `types` = 1 AND ( `provinceid` = 330 OR `cityid` = 330 ) AND `status` = 3 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 12 [ RunTime:0.013195s ]
SHOW FULL COLUMNS FROM `db_company_news` [ RunTime:0.001998s ]
SELECT `ov`.* FROM `db_company_news` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 330 AND `ov`.`status` = 3 ORDER BY `listorder` DESC LIMIT 12 [ RunTime:0.041973s ]
SHOW FULL COLUMNS FROM `db_gongdi` [ RunTime:0.002387s ]
SELECT `g`.*,`m`.`userid` FROM `db_gongdi` `g` LEFT JOIN `db_member` `m` ON `m`.`username`=`g`.`username` WHERE `m`.`areaid` = 330 AND `g`.`status` = 3 AND `g`.`status` = 3 ORDER BY `itemid` ASC LIMIT 0,8 [ RunTime:0.031701s ]
SELECT `company_jc`,`userid`,`thumb`,`thumb2`,`areaid` FROM `db_company` WHERE `areaid` = 330 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC,`is_recomment` DESC LIMIT 15 [ RunTime:0.000878s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.000359s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000341s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52922 [ RunTime:0.000310s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52922 [ RunTime:0.000280s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52928 [ RunTime:0.000235s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52928 [ RunTime:0.000223s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52983 [ RunTime:0.000227s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52983 [ RunTime:0.000228s ]
SELECT * FROM `db_news` WHERE `types` = 2 AND ( `provinceid` = 330 OR `cityid` = 330 OR `areaid` = 330 ) AND `status` = 3 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 6 [ RunTime:0.001501s ]
SELECT `userid`,`truename`,`p_userid`,`thumb`,`sj_style_catids`,`sj_type_catdis`,`exp` FROM `db_member` WHERE `groupid` = 2 AND `areaid` = 330 AND `status` = 3 AND `status` = 3 AND `status` = 3 ORDER BY `userid` DESC LIMIT 10 [ RunTime:0.001115s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.002038s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1521,1534,1535) ORDER BY `listorder` [ RunTime:0.002273s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1520,1523,1525) ORDER BY `listorder` [ RunTime:0.000262s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1521,1534,1535) ORDER BY `listorder` [ RunTime:0.000590s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1525,1526,1534) ORDER BY `listorder` [ RunTime:0.000568s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1521,1523,1524,1526) ORDER BY `listorder` [ RunTime:0.000555s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1522,1528,1530) ORDER BY `listorder` [ RunTime:0.000531s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1526,1527,1529) ORDER BY `listorder` [ RunTime:0.000561s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1525,1527,1533) ORDER BY `listorder` [ RunTime:0.000628s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1522,1525,1527) ORDER BY `listorder` [ RunTime:0.000538s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1521,1523,1525) ORDER BY `listorder` [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.002130s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'lasa' 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.842249s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 330 AND `cityjq` = 'www' AND `itemid` NOT IN (569100,569103,569097) 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.842498s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'lasa' 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.016895s ]
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.006447s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 330 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.007903s ]
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 (569273,569278,569279,569271,569276) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 1 [ RunTime:0.007777s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'lasa' AND `catid` IN (1675,1676,1677,1678,1679,1680,1440) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.074626s ]
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.054086s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 330 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.054306s ]
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 (569266,569261,569263,569267,569269) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 1 [ RunTime:0.058606s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`cityjq`,`areaid` FROM `db_article` WHERE `cityjq` = 'lasa' 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.008574s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`cityjq`,`areaid` FROM `db_article` WHERE `cityjqid` = 330 AND `cityjq` = 'www' AND `itemid` NOT IN (569092,569094,569093) 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.008089s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'lasa' 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.004017s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` IN (1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1480) AND `cityjqid` = 0 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.003571s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 330 AND `cityjq` = 'www' AND `itemid` NOT IN (566494,566490,566487) 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.005159s ]
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,566487) AND `catid` IN (1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1480) AND `itemid` NOT IN (569282,569280,569283,569288,569286) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 1 [ RunTime:0.006212s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'lasa' AND `catid` = 1438 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.048112s ]
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.033743s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 330 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.034845s ]
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` <> 569294 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 5 [ RunTime:0.038369s ]
SELECT `c`.*,`m`.`company_jc`,`m`.`areaid` FROM `db_comment` `c` LEFT JOIN `db_member` `m` ON `c`.`userid`=`m`.`userid` WHERE `m`.`areaid` = 330 AND `m`.`groupid` = 1 AND `c`.`pics` <> '' ORDER BY `id` DESC LIMIT 0,12 [ RunTime:0.008551s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.002036s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000463s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000499s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52922 [ RunTime:0.000432s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52928 [ RunTime:0.000435s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52983 [ RunTime:0.000429s ]