SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001499s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000606s ]
SELECT * FROM `db_city` WHERE `domain` = 'gz' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000597s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001249s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001252s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 231 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.001028s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000457s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001112s ]
SELECT * FROM `db_seo` WHERE `url` = '/cityindex' LIMIT 1 [ RunTime:0.000497s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001579s ]
SELECT * FROM `db_company` WHERE `areaid` = 231 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC LIMIT 18 [ RunTime:0.000644s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001563s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51212 [ RunTime:0.010112s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.002113s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51212 [ RunTime:0.000436s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51218 [ RunTime:0.008192s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51218 [ RunTime:0.000412s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51223 [ RunTime:0.008270s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51223 [ RunTime:0.000420s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51241 [ RunTime:0.008090s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51241 [ RunTime:0.000400s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51056 [ RunTime:0.008223s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51056 [ RunTime:0.000402s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51063 [ RunTime:0.008203s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51063 [ RunTime:0.000358s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51069 [ RunTime:0.008062s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51069 [ RunTime:0.000368s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51091 [ RunTime:0.008349s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51091 [ RunTime:0.000373s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51113 [ RunTime:0.008181s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51113 [ RunTime:0.000374s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51128 [ RunTime:0.007905s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51128 [ RunTime:0.000368s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51136 [ RunTime:0.008221s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51136 [ RunTime:0.000361s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51156 [ RunTime:0.008167s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51156 [ RunTime:0.000357s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51166 [ RunTime:0.008208s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51166 [ RunTime:0.000353s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51169 [ RunTime:0.008054s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51169 [ RunTime:0.000344s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51173 [ RunTime:0.008146s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51173 [ RunTime:0.000340s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001564s ]
SELECT `userid`,`company`,`p_userid`,`exp`,`sj_price_catids`,`sj_style_catids`,`sj_type_catdis`,`thumb`,`truename` FROM `db_member` WHERE ( `provinceid` = 231 OR `cityid` = 231 OR `provinceid` = 231 ) AND `groupid` = 2 AND `status` = 3 ORDER BY `exp` DESC LIMIT 15 [ RunTime:0.000496s ]
SHOW FULL COLUMNS FROM `db_tag` [ RunTime:0.001078s ]
SELECT * FROM `db_tag` WHERE `status` = 3 ORDER BY `id` DESC LIMIT 15 [ RunTime:0.000364s ]
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` = 231 ORDER BY `p`.`listorder` DESC,`p`.`itemid` DESC LIMIT 10 [ RunTime:0.018850s ]
SHOW FULL COLUMNS FROM `db_overman` [ RunTime:0.001872s ]
SELECT `ov`.* FROM `db_overman` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 231 AND `ov`.`status` = 3 LIMIT 10 [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.001906s ]
SELECT * FROM `db_news` WHERE `types` = 1 AND ( `provinceid` = 231 OR `cityid` = 231 ) AND `status` = 3 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 12 [ RunTime:0.011613s ]
SHOW FULL COLUMNS FROM `db_company_news` [ RunTime:0.001890s ]
SELECT `ov`.* FROM `db_company_news` `ov` LEFT JOIN `db_company` `co` ON `ov`.`userid`=`co`.`userid` WHERE `co`.`areaid` = 231 AND `ov`.`status` = 3 ORDER BY `listorder` DESC LIMIT 12 [ RunTime:0.025924s ]
SHOW FULL COLUMNS FROM `db_gongdi` [ RunTime:0.002266s ]
SELECT `g`.*,`m`.`userid` FROM `db_gongdi` `g` LEFT JOIN `db_member` `m` ON `m`.`username`=`g`.`username` WHERE `m`.`areaid` = 231 AND `g`.`status` = 3 AND `g`.`status` = 3 ORDER BY `itemid` ASC LIMIT 0,8 [ RunTime:0.012060s ]
SELECT `company_jc`,`userid`,`thumb`,`thumb2`,`areaid` FROM `db_company` WHERE `areaid` = 231 AND `groupid` = 1 AND `status` = 3 ORDER BY `vip` DESC,`is_recomment` DESC LIMIT 15 [ RunTime:0.000430s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51212 [ RunTime:0.000356s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51212 [ RunTime:0.000340s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51218 [ RunTime:0.000348s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51218 [ RunTime:0.000349s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51223 [ RunTime:0.000335s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51223 [ RunTime:0.000333s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51241 [ RunTime:0.000344s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51241 [ RunTime:0.000500s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51056 [ RunTime:0.000343s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51056 [ RunTime:0.000347s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51063 [ RunTime:0.000340s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51063 [ RunTime:0.000339s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51069 [ RunTime:0.000343s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51069 [ RunTime:0.000343s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51091 [ RunTime:0.000340s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51091 [ RunTime:0.000338s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51113 [ RunTime:0.000342s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51113 [ RunTime:0.000349s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51128 [ RunTime:0.000347s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51128 [ RunTime:0.000331s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51136 [ RunTime:0.000341s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51136 [ RunTime:0.000337s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51156 [ RunTime:0.000424s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51156 [ RunTime:0.000347s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51166 [ RunTime:0.000342s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51166 [ RunTime:0.000351s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51169 [ RunTime:0.000345s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51169 [ RunTime:0.000350s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51173 [ RunTime:0.000336s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51173 [ RunTime:0.000348s ]
SELECT * FROM `db_news` WHERE `types` = 2 AND ( `provinceid` = 231 OR `cityid` = 231 OR `areaid` = 231 ) AND `status` = 3 AND `status` = 3 ORDER BY `addtime` DESC LIMIT 6 [ RunTime:0.001658s ]
SELECT `userid`,`truename`,`p_userid`,`thumb`,`sj_style_catids`,`sj_type_catdis`,`exp` FROM `db_member` WHERE `groupid` = 2 AND `areaid` = 231 AND `status` = 3 AND `status` = 3 AND `status` = 3 ORDER BY `userid` DESC LIMIT 10 [ RunTime:0.000466s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.002066s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1520,1522,1534) ORDER BY `listorder` [ RunTime:0.000453s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1522,1534) ORDER BY `listorder` [ RunTime:0.000411s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1521,1522,1531,1534) ORDER BY `listorder` [ RunTime:0.000409s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1523,1530,1535) ORDER BY `listorder` [ RunTime:0.000454s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1522,1523,1531,1534) ORDER BY `listorder` [ RunTime:0.000444s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1527) ORDER BY `listorder` [ RunTime:0.000401s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1522,1523) ORDER BY `listorder` [ RunTime:0.000414s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1520,1522) ORDER BY `listorder` [ RunTime:0.000407s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1519,1520,1522,1523) ORDER BY `listorder` [ RunTime:0.000415s ]
SELECT `catname` FROM `db_category` WHERE `catid` IN (1518,1519,1526,1534) ORDER BY `listorder` [ RunTime:0.000430s ]
SHOW FULL COLUMNS FROM `db_article` [ RunTime:0.002137s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'gz' 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.913359s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumb`,`thumbnail`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 231 AND `cityjq` = 'www' AND `itemid` NOT IN (567268,567266,569560) 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.754458s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'gz' 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.011479s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 231 AND `cityjq` = 'www' AND `itemid` NOT IN (567353,567364,567368) 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.004218s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'www' AND `itemid` NOT IN (567353,567364,567368) AND `catid` IN (1695,1694,1696,1693,1692,1697,1698,1699,1700,1712,1441,1442) AND `itemid` <> 570758 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 5 [ RunTime:0.004240s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1440 ORDER BY `listorder` [ RunTime:0.000401s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1675 ORDER BY `listorder` [ RunTime:0.000304s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1676 ORDER BY `listorder` [ RunTime:0.000298s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1677 ORDER BY `listorder` [ RunTime:0.000274s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1678 ORDER BY `listorder` [ RunTime:0.000230s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1679 ORDER BY `listorder` [ RunTime:0.000229s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1680 ORDER BY `listorder` [ RunTime:0.000230s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'gz' AND `catid` IN (1675,1676,1677,1678,1679,1680,1440) AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.046780s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 231 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.036686s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1479 ORDER BY `listorder` [ RunTime:0.000321s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1681 ORDER BY `listorder` [ RunTime:0.000239s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1682 ORDER BY `listorder` [ RunTime:0.000235s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1683 ORDER BY `listorder` [ RunTime:0.000235s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1684 ORDER BY `listorder` [ RunTime:0.000235s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1685 ORDER BY `listorder` [ RunTime:0.000230s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1686 ORDER BY `listorder` [ RunTime:0.000230s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1687 ORDER BY `listorder` [ RunTime:0.000233s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1688 ORDER BY `listorder` [ RunTime:0.000229s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1689 ORDER BY `listorder` [ RunTime:0.000235s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1690 ORDER BY `listorder` [ RunTime:0.000226s ]
SELECT `catid` FROM `db_category` WHERE `parentid` = 1691 ORDER BY `listorder` [ RunTime:0.000233s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`cityjq`,`areaid` FROM `db_article` WHERE `cityjq` = 'gz' 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.005772s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`provinceid`,`cityid`,`cityjq`,`areaid` FROM `db_article` WHERE `cityjqid` = 231 AND `cityjq` = 'www' AND `itemid` NOT IN (570039,567392,567378) 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.005568s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'gz' 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.003013s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 231 AND `cityjq` = 'www' AND `itemid` NOT IN (567594,567598,567410) 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.003599s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'www' AND `itemid` NOT IN (567594,567598,567410) AND `catid` IN (1701,1702,1703,1704,1705,1706,1707,1708,1709,1710,1711,1480) AND `itemid` NOT IN ('') AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 6 [ RunTime:0.004114s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'gz' AND `catid` = 1438 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 3 [ RunTime:0.034370s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjqid` = 231 AND `cityjq` = 'www' AND `itemid` NOT IN (570096,570660,571187) AND `catid` = 1438 AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 6 [ RunTime:0.035818s ]
SELECT `itemid`,`hits`,`catid`,`title`,`addtime`,`introduce`,`thumbnail`,`thumb`,`cityjq`,`provinceid`,`cityid`,`areaid` FROM `db_article` WHERE `cityjq` = 'www' AND `itemid` NOT IN (570096,570660,571187) AND `catid` = 1438 AND `itemid` NOT IN ('') AND `status` = 3 ORDER BY `hits` DESC,`itemid` DESC LIMIT 6 [ RunTime:0.038154s ]
SELECT `c`.*,`m`.`company_jc`,`m`.`areaid` FROM `db_comment` `c` LEFT JOIN `db_member` `m` ON `c`.`userid`=`m`.`userid` WHERE `m`.`areaid` = 231 AND `m`.`groupid` = 1 AND `c`.`pics` <> '' ORDER BY `id` DESC LIMIT 0,12 [ RunTime:0.000614s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.002031s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000390s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51212 [ RunTime:0.000425s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51218 [ RunTime:0.000393s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51223 [ RunTime:0.000342s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51241 [ RunTime:0.000276s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51056 [ RunTime:0.000272s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51063 [ RunTime:0.000269s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51069 [ RunTime:0.000444s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51091 [ RunTime:0.000277s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51113 [ RunTime:0.000276s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51128 [ RunTime:0.000272s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51136 [ RunTime:0.000276s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51156 [ RunTime:0.000271s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51166 [ RunTime:0.000275s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51169 [ RunTime:0.000271s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51173 [ RunTime:0.000272s ]