SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001315s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000358s ]
SELECT * FROM `db_city` WHERE `domain` = 'hz' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000381s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001086s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000446s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001227s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 118 [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000835s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.000941s ]
SELECT * FROM `db_seo` WHERE `url` = '/gs' LIMIT 1 [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.000934s ]
SELECT areaname as name,areaid as code FROM `db_area` WHERE `parentid` = 118 [ RunTime:0.007125s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001449s ]
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` = 118 [ RunTime:0.036586s ]
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` = 118 ORDER BY `m`.`vip` DESC,`m`.`is_recomment` DESC,`mm`.`userid` LIMIT 0,15 [ RunTime:0.004518s ]
SELECT p_userid AS userid,COUNT(*) AS num FROM db_member WHERE p_userid IN (51244,51263,51275,51293,51305,51319,51343,51360,51368,51380,51400,51420,52129,52145,52158) AND status=3 GROUP BY p_userid [ RunTime:0.005786s ]
SELECT userid,COUNT(*) AS num FROM db_honor WHERE userid IN (51244,51263,51275,51293,51305,51319,51343,51360,51368,51380,51400,51420,52129,52145,52158) AND status=3 GROUP BY userid [ RunTime:0.006301s ]
SELECT userid,COUNT(*) AS num FROM db_overman WHERE userid IN (51244,51263,51275,51293,51305,51319,51343,51360,51368,51380,51400,51420,52129,52145,52158) AND status=3 GROUP BY userid [ RunTime:0.009001s ]
SELECT username as userid,COUNT(*) AS num FROM db_gongdi WHERE INSTR('51244,51263,51275,51293,51305,51319,51343,51360,51368,51380,51400,51420,52129,52145,52158',username) AND status=3 GROUP BY username [ RunTime:0.025555s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE mid IN (51244,51263,51275,51293,51305,51319,51343,51360,51368,51380,51400,51420,52129,52145,52158) AND status=3 GROUP BY mid [ RunTime:0.011775s ]
SELECT userid ,COUNT(*) AS num FROM db_comment WHERE userid IN (51244,51263,51275,51293,51305,51319,51343,51360,51368,51380,51400,51420,52129,52145,52158) AND status=3 GROUP BY userid [ RunTime:0.003095s ]
SELECT userid ,COUNT(*) AS num FROM db_company_news WHERE userid IN (51244,51263,51275,51293,51305,51319,51343,51360,51368,51380,51400,51420,52129,52145,52158) AND status=3 GROUP BY userid [ RunTime:0.271376s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001797s ]
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` = 51244 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006248s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001652s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51244 LIMIT 1 [ RunTime:0.000609s ]
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` = 51263 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.009234s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51263 LIMIT 1 [ RunTime:0.000495s ]
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` = 51275 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006113s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51275 LIMIT 1 [ RunTime:0.000743s ]
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` = 51293 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006061s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51293 LIMIT 1 [ RunTime:0.000566s ]
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` = 51305 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005962s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51305 LIMIT 1 [ RunTime:0.000596s ]
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` = 51319 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006075s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51319 LIMIT 1 [ RunTime:0.000584s ]
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` = 51343 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005550s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51343 LIMIT 1 [ RunTime:0.000670s ]
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` = 51360 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006276s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51360 LIMIT 1 [ RunTime:0.000615s ]
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` = 51368 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005974s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51368 LIMIT 1 [ RunTime:0.000556s ]
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` = 51380 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005781s ]
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` = 51400 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005905s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51400 LIMIT 1 [ RunTime:0.000641s ]
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` = 51420 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005834s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51420 LIMIT 1 [ RunTime:0.000556s ]
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` = 52129 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005709s ]
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` = 52145 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005683s ]
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` = 52158 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005525s ]
SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.002383s ]
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.004769s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.002204s ]
SELECT `id`,`title` FROM `db_news` WHERE `status` = 3 AND ( `provinceid` = 118 OR `cityid` = 118 ) ORDER BY rand() LIMIT 8 [ RunTime:0.011914s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001965s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000412s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000365s ]
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.000324s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000250s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000249s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000250s ]
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.000249s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000248s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000248s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000248s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000248s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000248s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000248s ]