SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001560s ]
SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000616s ]
SELECT * FROM `db_city` WHERE `domain` = 'hf' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000588s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001313s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000595s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001278s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 129 [ RunTime:0.000511s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.001101s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000447s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001193s ]
SELECT * FROM `db_seo` WHERE `url` = '/gs' LIMIT 1 [ RunTime:0.000557s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001168s ]
SELECT areaname as name,areaid as code FROM `db_area` WHERE `parentid` = 129 [ RunTime:0.000476s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001649s ]
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` = 129 [ RunTime:0.045414s ]
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` = 129 ORDER BY `m`.`vip` DESC,`m`.`is_recomment` DESC,`mm`.`userid` LIMIT 0,15 [ RunTime:0.004432s ]
SELECT p_userid AS userid,COUNT(*) AS num FROM db_member WHERE p_userid IN (51728,51734,51743,51750,51751,51758,51771,51780,52200,52220,52237,52250,52258,52261,52278) AND status=3 GROUP BY p_userid [ RunTime:0.005843s ]
SELECT userid,COUNT(*) AS num FROM db_honor WHERE userid IN (51728,51734,51743,51750,51751,51758,51771,51780,52200,52220,52237,52250,52258,52261,52278) AND status=3 GROUP BY userid [ RunTime:0.006423s ]
SELECT userid,COUNT(*) AS num FROM db_overman WHERE userid IN (51728,51734,51743,51750,51751,51758,51771,51780,52200,52220,52237,52250,52258,52261,52278) AND status=3 GROUP BY userid [ RunTime:0.008171s ]
SELECT username as userid,COUNT(*) AS num FROM db_gongdi WHERE INSTR('51728,51734,51743,51750,51751,51758,51771,51780,52200,52220,52237,52250,52258,52261,52278',username) AND status=3 GROUP BY username [ RunTime:0.026332s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE mid IN (51728,51734,51743,51750,51751,51758,51771,51780,52200,52220,52237,52250,52258,52261,52278) AND status=3 GROUP BY mid [ RunTime:0.011628s ]
SELECT userid ,COUNT(*) AS num FROM db_comment WHERE userid IN (51728,51734,51743,51750,51751,51758,51771,51780,52200,52220,52237,52250,52258,52261,52278) AND status=3 GROUP BY userid [ RunTime:0.029414s ]
SELECT userid ,COUNT(*) AS num FROM db_company_news WHERE userid IN (51728,51734,51743,51750,51751,51758,51771,51780,52200,52220,52237,52250,52258,52261,52278) AND status=3 GROUP BY userid [ RunTime:0.286834s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.002213s ]
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` = 51728 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.009776s ]
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` = 51734 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.009756s ]
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` = 51743 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.007057s ]
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` = 51750 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005514s ]
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` = 51751 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005644s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001780s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51751 LIMIT 1 [ RunTime:0.000631s ]
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` = 51758 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006507s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51758 LIMIT 1 [ RunTime:0.000718s ]
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` = 51771 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006062s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51771 LIMIT 1 [ RunTime:0.000658s ]
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` = 51780 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005774s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51780 LIMIT 1 [ RunTime:0.000601s ]
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` = 52200 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006652s ]
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` = 52220 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005969s ]
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` = 52237 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006177s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 52237 LIMIT 1 [ RunTime:0.000563s ]
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` = 52250 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005733s ]
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` = 52258 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006166s ]
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` = 52261 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005690s ]
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` = 52278 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005778s ]
SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.002536s ]
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.007674s ]
SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.002247s ]
SELECT `id`,`title` FROM `db_news` WHERE `status` = 3 AND ( `provinceid` = 129 OR `cityid` = 129 ) ORDER BY rand() LIMIT 8 [ RunTime:0.013483s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.002520s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000646s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.001076s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000491s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000443s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000341s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000336s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000283s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000280s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000344s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000274s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000283s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000287s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000342s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000318s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000391s ]