SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001289s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000414s ]
SELECT * FROM `db_city` WHERE `domain` = 'hk' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000407s ]
SELECT `name` FROM `db_city` WHERE `domain` = 'hk' LIMIT 1 [ RunTime:0.005740s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001049s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001152s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 266 [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000918s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001010s ]
SELECT * FROM `db_seo` WHERE `url` = '/cityindex' LIMIT 1 [ RunTime:0.000315s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001421s ]
SELECT * FROM `db_company` WHERE `areaid` = 266 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC LIMIT 18 [ RunTime:0.001423s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001435s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52876 [ RunTime:0.008229s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.001986s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52876 [ RunTime:0.000441s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52883 [ RunTime:0.008060s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52883 [ RunTime:0.000439s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52889 [ RunTime:0.008189s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52889 [ RunTime:0.000404s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52934 [ RunTime:0.008060s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52934 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.002254s ]
SELECT `userid`,`company`,`p_userid`,`exp`,`sj_price_catids`,`sj_style_catids`,`sj_type_catdis`,`thumb`,`truename` FROM `db_member` WHERE ( `provinceid` = 266 OR `cityid` = 266 OR `provinceid` = 266 ) AND `groupid` = 2 AND `status` = 3 ORDER BY `exp` DESC LIMIT 15 [ RunTime:0.006165s ]
SHOW FULL COLUMNS FROM `db_tag` [ RunTime:0.001108s ]
SELECT * FROM `db_tag` WHERE `status` = 3 ORDER BY `id` DESC LIMIT 15 [ RunTime:0.000342s ]
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` = 266 ORDER BY `p`.`listorder` DESC,`p`.`itemid` DESC LIMIT 10 [ RunTime:0.014150s ]
SHOW FULL COLUMNS FROM `db_overman` [ RunTime:0.001890s ]
SELECT `ov`.* FROM `db_overman` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 266 AND `ov`.`status` = 3 LIMIT 10 [ RunTime:0.004150s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.001982s ]
SELECT * FROM `db_news` WHERE `types` = 1 AND ( `provinceid` = 266 OR `cityid` = 266 ) AND `status` = 3 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 12 [ RunTime:0.001490s ]
SHOW FULL COLUMNS FROM `db_company_news` [ RunTime:0.002119s ]
SELECT `ov`.* FROM `db_company_news` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 266 AND `ov`.`status` = 3 ORDER BY `listorder` DESC LIMIT 12 [ RunTime:0.043199s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52876 LIMIT 1 [ RunTime:0.000609s ]
SELECT `domain` FROM `db_city` WHERE `areaid` = 266 LIMIT 1 [ RunTime:0.000495s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52883 LIMIT 1 [ RunTime:0.000408s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52889 LIMIT 1 [ RunTime:0.000405s ]
SHOW FULL COLUMNS FROM `db_gongdi` [ RunTime:0.002154s ]
SELECT `g`.*,`m`.`userid` FROM `db_gongdi` `g` LEFT JOIN `db_member` `m` ON `m`.`username`=`g`.`username` WHERE `m`.`areaid` = 266 AND `g`.`status` = 3 AND `g`.`status` = 3 ORDER BY `itemid` ASC LIMIT 0,8 [ RunTime:0.033153s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001971s ]
SELECT `catid`,`catname` FROM `db_category` WHERE `parentid` = 1674 ORDER BY `listorder` [ RunTime:0.000356s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.002173s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE ( `provinceid` = 266 OR `cityid` = 266 ) AND `catid` = 1713 AND `status` = 3 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 12 [ RunTime:0.006987s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE ( `provinceid` = 266 OR `cityid` = 266 ) AND `catid` = 1714 AND `status` = 3 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 12 [ RunTime:0.008591s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE ( `provinceid` = 266 OR `cityid` = 266 ) AND `catid` = 1715 AND `status` = 3 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 12 [ RunTime:0.028637s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` = 1715 AND `status` = 3 AND `cityjqid` = 0 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 7 [ RunTime:0.002054s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE ( `provinceid` = 266 OR `cityid` = 266 ) AND `catid` = 1716 AND `status` = 3 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 12 [ RunTime:0.020399s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `catid` = 1716 AND `status` = 3 AND `cityjqid` = 0 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 6 [ RunTime:0.001788s ]
SELECT `company_jc`,`userid`,`thumb`,`thumb2`,`areaid` FROM `db_company` WHERE `areaid` = 266 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC,`is_recomment` DESC LIMIT 15 [ RunTime:0.000777s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52876 [ RunTime:0.000369s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52876 [ RunTime:0.000339s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52883 [ RunTime:0.000267s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52883 [ RunTime:0.000291s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52889 [ RunTime:0.000290s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52889 [ RunTime:0.000299s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 52934 [ RunTime:0.000290s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52934 [ RunTime:0.000298s ]
SELECT * FROM `db_news` WHERE `types` = 2 AND ( `provinceid` = 266 OR `cityid` = 266 OR `areaid` = 266 ) AND `status` = 3 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 6 [ RunTime:0.001580s ]
SHOW FULL COLUMNS FROM `db_ask` [ RunTime:0.001411s ]
SELECT `a`.*,m.thumb2 as thumb FROM `db_ask` `a` LEFT JOIN `db_company` `m` ON `a`.`mid`=`m`.`userid` WHERE `a`.`status` = 3 ORDER BY `a`.`is_recommend` DESC,`a`.`id` DESC LIMIT 7 [ RunTime:0.000496s ]
SELECT `userid`,`truename`,`p_userid`,`thumb`,`sj_style_catids`,`sj_type_catdis`,`exp` FROM `db_member` WHERE `groupid` = 2 AND `areaid` = 266 AND `status` = 3 AND `status` = 3 AND `status` = 3 ORDER BY `userid` DESC LIMIT 10 [ RunTime:0.001568s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1521,1522,1535) ORDER BY `listorder` [ RunTime:0.000568s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1520,1521,1522) ORDER BY `listorder` [ RunTime:0.000557s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1521,1524,1527) ORDER BY `listorder` [ RunTime:0.000537s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1521,1522) ORDER BY `listorder` [ RunTime:0.000534s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1521,1524,1525) ORDER BY `listorder` [ RunTime:0.000505s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1521,1526,1527) ORDER BY `listorder` [ RunTime:0.000450s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1524,1525,1527) ORDER BY `listorder` [ RunTime:0.000447s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1523,1526) ORDER BY `listorder` [ RunTime:0.000674s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1522,1524,1527) ORDER BY `listorder` [ RunTime:0.000452s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1520,1523,1527,1530) ORDER BY `listorder` [ RunTime:0.000457s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1424 ORDER BY `listorder` [ RunTime:0.000269s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1426 ORDER BY `listorder` [ RunTime:0.000244s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1427 ORDER BY `listorder` [ RunTime:0.000239s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1428 ORDER BY `listorder` [ RunTime:0.000237s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1430 ORDER BY `listorder` [ RunTime:0.000237s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1429 ORDER BY `listorder` [ RunTime:0.000276s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1669 ORDER BY `listorder` [ RunTime:0.000241s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1670 ORDER BY `listorder` [ RunTime:0.000237s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1431 ORDER BY `listorder` [ RunTime:0.000237s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1671 ORDER BY `listorder` [ RunTime:0.000239s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1435 ORDER BY `listorder` [ RunTime:0.000238s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1432 ORDER BY `listorder` [ RunTime:0.000235s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1433 ORDER BY `listorder` [ RunTime:0.000236s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1434 ORDER BY `listorder` [ RunTime:0.000237s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1436 ORDER BY `listorder` [ RunTime:0.000236s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1673 ORDER BY `listorder` [ RunTime:0.000236s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1437 ORDER BY `listorder` [ RunTime:0.000237s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'hk' 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.812704s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 266 AND `cityjq` = 'www' AND `itemid` NOT IN (568990,568986,568983) 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.911287s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1442 ORDER BY `listorder` [ RunTime:0.000591s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1695 ORDER BY `listorder` [ RunTime:0.000462s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1694 ORDER BY `listorder` [ RunTime:0.000342s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1696 ORDER BY `listorder` [ RunTime:0.000440s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1693 ORDER BY `listorder` [ RunTime:0.000307s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1692 ORDER BY `listorder` [ RunTime:0.000301s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1697 ORDER BY `listorder` [ RunTime:0.000457s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1698 ORDER BY `listorder` [ RunTime:0.000877s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1699 ORDER BY `listorder` [ RunTime:0.000307s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1700 ORDER BY `listorder` [ RunTime:0.000448s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1712 ORDER BY `listorder` [ RunTime:0.000295s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1441 ORDER BY `listorder` [ RunTime:0.000294s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'hk' 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.006350s ]
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 1 [ RunTime:0.004161s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 266 AND `cityjq` = 'www' AND `itemid` NOT IN (571161,571805,2747) 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.007689s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1440 ORDER BY `listorder` [ RunTime:0.000328s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1675 ORDER BY `listorder` [ RunTime:0.000198s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1676 ORDER BY `listorder` [ RunTime:0.000191s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1677 ORDER BY `listorder` [ RunTime:0.000189s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1678 ORDER BY `listorder` [ RunTime:0.000221s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1679 ORDER BY `listorder` [ RunTime:0.000213s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1680 ORDER BY `listorder` [ RunTime:0.000217s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'hk' AND `catid` IN (1675,1676,1677,1678,1679,1680,1440) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.051353s ]
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 2 [ RunTime:0.041456s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 266 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.038038s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1479 ORDER BY `listorder` [ RunTime:0.000292s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1681 ORDER BY `listorder` [ RunTime:0.000180s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1682 ORDER BY `listorder` [ RunTime:0.000176s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1683 ORDER BY `listorder` [ RunTime:0.000176s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1684 ORDER BY `listorder` [ RunTime:0.000173s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1685 ORDER BY `listorder` [ RunTime:0.000173s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1686 ORDER BY `listorder` [ RunTime:0.000175s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1687 ORDER BY `listorder` [ RunTime:0.000176s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1688 ORDER BY `listorder` [ RunTime:0.000175s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1689 ORDER BY `listorder` [ RunTime:0.000177s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1690 ORDER BY `listorder` [ RunTime:0.000231s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1691 ORDER BY `listorder` [ RunTime:0.000231s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`cityjq`,`areaid` FROM `db_article` WHERE `cityjq` = 'hk' 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.005975s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`cityjq`,`areaid` FROM `db_article` WHERE `cityjqid` = 266 AND `cityjq` = 'www' AND `itemid` NOT IN (568989,568982,568985) 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.006096s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'hk' 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.003130s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 266 AND `cityjq` = 'www' AND `itemid` NOT IN (571517,571155,571324) 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.004150s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1438 ORDER BY `listorder` [ RunTime:0.000264s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'hk' AND `catid` = 1438 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.030503s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 266 AND `cityjq` = 'www' AND `itemid` NOT IN (570732,571027,558041) AND `catid` = 1438 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 6 [ RunTime:0.024575s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'www' AND `itemid` NOT IN (570732,571027,558041) AND `catid` = 1438 AND `itemid` NOT IN (569193,569195,571758,571567) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 2 [ RunTime:0.026255s ]
SELECT `c`.*,`m`.`company_jc`,`m`.`areaid` FROM `db_comment` `c` LEFT JOIN `db_member` `m` ON `c`.`userid`=`m`.`userid` WHERE `m`.`areaid` = 266 AND `m`.`groupid` = 1 AND `c`.`pics` <> '' ORDER BY `id` DESC LIMIT 0,12 [ RunTime:0.005013s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001356s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000221s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52876 [ RunTime:0.000204s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52883 [ RunTime:0.000182s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52889 [ RunTime:0.000187s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 52934 [ RunTime:0.000183s ]