SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001284s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000410s ]
SELECT * FROM `db_city` WHERE `domain` = 'lasa' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000386s ]
SELECT `name` FROM `db_city` WHERE `domain` = 'lasa' LIMIT 1 [ RunTime:0.002625s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001088s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000442s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001107s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 330 [ RunTime:0.000343s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000840s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.000953s ]
SELECT * FROM `db_seo` WHERE `url` = '/cityindex' LIMIT 1 [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001401s ]
SELECT * FROM `db_company` WHERE `areaid` = 330 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC LIMIT 18 [ RunTime:0.002434s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.002143s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.001748s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000262s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52922 [ RunTime:0.000246s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52922 [ RunTime:0.000247s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52928 [ RunTime:0.000244s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52928 [ RunTime:0.000379s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52983 [ RunTime:0.000287s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52983 [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.002189s ]
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.008913s ]
SHOW FULL COLUMNS FROM `db_tag` [ RunTime:0.001158s ]
SELECT * FROM `db_tag` WHERE `status` = 3 ORDER BY `id` DESC LIMIT 15 [ RunTime:0.000443s ]
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.024832s ]
SHOW FULL COLUMNS FROM `db_overman` [ RunTime:0.001988s ]
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.010418s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.001985s ]
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.015574s ]
SHOW FULL COLUMNS FROM `db_company_news` [ RunTime:0.001938s ]
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.217042s ]
SHOW FULL COLUMNS FROM `db_gongdi` [ RunTime:0.002372s ]
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.038840s ]
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.001067s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52994 [ RunTime:0.000572s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000540s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52922 [ RunTime:0.000507s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52922 [ RunTime:0.000507s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52928 [ RunTime:0.000404s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52928 [ RunTime:0.000517s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52983 [ RunTime:0.000381s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52983 [ RunTime:0.000354s ]
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.001650s ]
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.001177s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001972s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1521,1534,1535) ORDER BY `listorder` [ RunTime:0.000303s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1520,1523,1525) ORDER BY `listorder` [ RunTime:0.000279s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1521,1534,1535) ORDER BY `listorder` [ RunTime:0.000276s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1525,1526,1534) ORDER BY `listorder` [ RunTime:0.000275s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1521,1523,1524,1526) ORDER BY `listorder` [ RunTime:0.000286s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1522,1528,1530) ORDER BY `listorder` [ RunTime:0.002152s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1526,1527,1529) ORDER BY `listorder` [ RunTime:0.000480s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1525,1527,1533) ORDER BY `listorder` [ RunTime:0.000500s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1522,1525,1527) ORDER BY `listorder` [ RunTime:0.000495s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1521,1523,1525) ORDER BY `listorder` [ RunTime:0.000449s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.002084s ]
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.927313s ]
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 (569103,569100,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.666650s ]
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.009152s ]
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.004454s ]
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.007489s ]
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.007169s ]
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.069478s ]
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.055591s ]
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.055081s ]
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,569267,569261,569263,569269) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 1 [ RunTime:0.038503s ]
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.005899s ]
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.005408s ]
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.002813s ]
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.002544s ]
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,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.003655s ]
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 (569282,569280,569283,569288,569286) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 1 [ RunTime:0.004232s ]
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.033133s ]
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.023236s ]
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.024134s ]
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.025005s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001367s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000314s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52994 [ RunTime:0.000331s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52922 [ RunTime:0.000271s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52928 [ RunTime:0.000234s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52983 [ RunTime:0.000171s ]