SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001306s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000425s ]
SELECT * FROM `db_city` WHERE `domain` = 'nj' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000530s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.004890s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.005193s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001778s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 105 [ RunTime:0.000608s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.001083s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000302s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001371s ]
SELECT * FROM `db_seo` WHERE `url` = '/gs' LIMIT 1 [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001032s ]
SELECT areaname as name,areaid as code FROM `db_area` WHERE `parentid` = 105 [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001590s ]
SELECT COUNT(*) AS think_count FROM `db_company` `m` LEFT JOIN `db_member_group` `mg` ON `mg`.`groupid`=`m`.`groupid` LEFT JOIN `db_member` `mm` ON `mm`.`userid`=`m`.`userid` WHERE `mm`.`status` = 3 AND `mm`.`groupid` = 1 AND `mm`.`areaid` = 105 [ RunTime:0.006026s ]
SELECT `m`.*,`mg`.`groupname`,`mm`.`regtime` FROM `db_company` `m` LEFT JOIN `db_member_group` `mg` ON `mg`.`groupid`=`m`.`groupid` LEFT JOIN `db_member` `mm` ON `mm`.`userid`=`m`.`userid` WHERE `mm`.`status` = 3 AND `mm`.`groupid` = 1 AND `mm`.`areaid` = 105 ORDER BY `m`.`vip` DESC,`m`.`is_recomment` DESC,`mm`.`userid` LIMIT 0,15 [ RunTime:0.007014s ]
SELECT p_userid AS userid,COUNT(*) AS num FROM db_member WHERE p_userid IN (51596,51604,51605,51607,51610,51618,51625,51634,51643,51654,51666,51671,52102,52117,52134) AND status=3 GROUP BY p_userid [ RunTime:0.007193s ]
SELECT userid,COUNT(*) AS num FROM db_honor WHERE userid IN (51596,51604,51605,51607,51610,51618,51625,51634,51643,51654,51666,51671,52102,52117,52134) AND status=3 GROUP BY userid [ RunTime:0.002903s ]
SELECT userid,COUNT(*) AS num FROM db_overman WHERE userid IN (51596,51604,51605,51607,51610,51618,51625,51634,51643,51654,51666,51671,52102,52117,52134) AND status=3 GROUP BY userid [ RunTime:0.003398s ]
SELECT username as userid,COUNT(*) AS num FROM db_gongdi WHERE INSTR('51596,51604,51605,51607,51610,51618,51625,51634,51643,51654,51666,51671,52102,52117,52134',username) AND status=3 GROUP BY username [ RunTime:0.011121s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE mid IN (51596,51604,51605,51607,51610,51618,51625,51634,51643,51654,51666,51671,52102,52117,52134) AND status=3 GROUP BY mid [ RunTime:0.020129s ]
SELECT userid ,COUNT(*) AS num FROM db_comment WHERE userid IN (51596,51604,51605,51607,51610,51618,51625,51634,51643,51654,51666,51671,52102,52117,52134) AND status=3 GROUP BY userid [ RunTime:0.004923s ]
SELECT userid ,COUNT(*) AS num FROM db_company_news WHERE userid IN (51596,51604,51605,51607,51610,51618,51625,51634,51643,51654,51666,51671,52102,52117,52134) AND status=3 GROUP BY userid [ RunTime:0.011547s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.002276s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51596 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.010416s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.002370s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51596 LIMIT 1 [ RunTime:0.000636s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51604 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.010981s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51604 LIMIT 1 [ RunTime:0.000468s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51605 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006143s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51605 LIMIT 1 [ RunTime:0.000412s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51607 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006151s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51607 LIMIT 1 [ RunTime:0.000421s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51610 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005860s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51610 LIMIT 1 [ RunTime:0.000385s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51618 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005742s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51625 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005732s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51625 LIMIT 1 [ RunTime:0.000499s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51634 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005847s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51634 LIMIT 1 [ RunTime:0.000432s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51643 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005749s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51643 LIMIT 1 [ RunTime:0.000440s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51654 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005794s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51666 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005695s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 51671 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005773s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51671 LIMIT 1 [ RunTime:0.000433s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 52102 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005663s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 52117 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005726s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52117 LIMIT 1 [ RunTime:0.000481s ]
SELECT `p`.`mid`,`p`.`itemid`,`p`.`title`,`p`.`thumb`,`p`.`thumbnail`,`p`.`mianji`,`p`.`zaojia`,`p`.`community`,`m`.`groupid`,`m`.`areaid`,`m`.`company_jc` FROM `db_photo` `p` INNER JOIN `db_member` `m` ON `p`.`mid`=`m`.`userid` WHERE `p`.`itemid` > 118915 AND `p`.`mid` = 52134 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005680s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52134 LIMIT 1 [ RunTime:0.000419s ]
SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.002428s ]
SELECT `itemid`,`title`,`thumb`,`thumbnail`,`thumbzuixiao` FROM `db_photo_item` WHERE `zhuang` = 1514 AND `is_qj` = 0 AND `status` = 3 ORDER BY `itemid` LIMIT 9 [ RunTime:0.001118s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.002236s ]
SELECT `id`,`title` FROM `db_news` WHERE `status` = 3 AND ( `provinceid` = 105 OR `cityid` = 105 ) ORDER BY rand() LIMIT 8 [ RunTime:0.001343s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.002017s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000428s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000378s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000376s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000333s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000259s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000256s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000255s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000259s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000257s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000254s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000260s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000258s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000255s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000260s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000257s ]