SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001164s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000364s ]
SELECT * FROM `db_city` WHERE `domain` = 'jn' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001196s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000309s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001090s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 166 [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000861s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000256s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.000984s ]
SELECT * FROM `db_seo` WHERE `url` = '/gs' LIMIT 1 [ RunTime:0.000277s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.000951s ]
SELECT areaname as name,areaid as code FROM `db_area` WHERE `parentid` = 166 [ RunTime:0.000314s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001500s ]
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` = 166 [ RunTime:0.006963s ]
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` = 166 ORDER BY `m`.`vip` DESC,`m`.`is_recomment` DESC,`mm`.`userid` LIMIT 0,15 [ RunTime:0.004019s ]
SELECT p_userid AS userid,COUNT(*) AS num FROM db_member WHERE p_userid IN (52304,52305,52323,52330,52337,52347,52350,52363,52370,52379,52386,52404,52411,52418,52436) AND status=3 GROUP BY p_userid [ RunTime:0.004832s ]
SELECT userid,COUNT(*) AS num FROM db_honor WHERE userid IN (52304,52305,52323,52330,52337,52347,52350,52363,52370,52379,52386,52404,52411,52418,52436) AND status=3 GROUP BY userid [ RunTime:0.001951s ]
SELECT userid,COUNT(*) AS num FROM db_overman WHERE userid IN (52304,52305,52323,52330,52337,52347,52350,52363,52370,52379,52386,52404,52411,52418,52436) AND status=3 GROUP BY userid [ RunTime:0.001912s ]
SELECT username as userid,COUNT(*) AS num FROM db_gongdi WHERE INSTR('52304,52305,52323,52330,52337,52347,52350,52363,52370,52379,52386,52404,52411,52418,52436',username) AND status=3 GROUP BY username [ RunTime:0.019526s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE mid IN (52304,52305,52323,52330,52337,52347,52350,52363,52370,52379,52386,52404,52411,52418,52436) AND status=3 GROUP BY mid [ RunTime:0.011582s ]
SELECT userid ,COUNT(*) AS num FROM db_comment WHERE userid IN (52304,52305,52323,52330,52337,52347,52350,52363,52370,52379,52386,52404,52411,52418,52436) AND status=3 GROUP BY userid [ RunTime:0.002967s ]
SELECT userid ,COUNT(*) AS num FROM db_company_news WHERE userid IN (52304,52305,52323,52330,52337,52347,52350,52363,52370,52379,52386,52404,52411,52418,52436) AND status=3 GROUP BY userid [ RunTime:0.006803s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001541s ]
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` = 52304 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005736s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001456s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52304 LIMIT 1 [ RunTime:0.000398s ]
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` = 52305 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005766s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52305 LIMIT 1 [ RunTime:0.000377s ]
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` = 52323 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005579s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52323 LIMIT 1 [ RunTime:0.000447s ]
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` = 52330 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005745s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52330 LIMIT 1 [ RunTime:0.000366s ]
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` = 52337 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005522s ]
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` = 52347 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005558s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52347 LIMIT 1 [ RunTime:0.000454s ]
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` = 52350 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005469s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52350 LIMIT 1 [ RunTime:0.000383s ]
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` = 52363 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005525s ]
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` = 52370 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005378s ]
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` = 52379 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005467s ]
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` = 52386 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005528s ]
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` = 52404 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005587s ]
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` = 52411 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005489s ]
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` = 52418 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005728s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52418 LIMIT 1 [ RunTime:0.000387s ]
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` = 52436 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005580s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52436 LIMIT 1 [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.002214s ]
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.005611s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.002083s ]
SELECT `id`,`title` FROM `db_news` WHERE `status` = 3 AND ( `provinceid` = 166 OR `cityid` = 166 ) ORDER BY rand() LIMIT 8 [ RunTime:0.014390s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.002054s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000355s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000328s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000306s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000321s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000304s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000383s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000367s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000350s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000366s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000362s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000366s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000374s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000374s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000363s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000378s ]