SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001259s ]
SELECT * FROM `db_city` WHERE `domain` = 'bj' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001050s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001161s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `existence` = 1 AND `pt` = 1 [ RunTime:0.000388s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000951s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001057s ]
SELECT * FROM `db_seo` WHERE `url` = '/gs' LIMIT 1 [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001517s ]
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` = 1 [ RunTime:0.001545s ]
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` = 1 ORDER BY `m`.`vip` DESC,`m`.`is_recomment` DESC,`mm`.`userid` LIMIT 0,10 [ RunTime:0.012162s ]
SELECT p_userid AS userid,COUNT(*) AS num FROM db_member WHERE p_userid IN (50034,50219,50003,50204,50213,50262,50268,50280,50348,50352) AND status=3 GROUP BY p_userid [ RunTime:0.004729s ]
SELECT userid,COUNT(*) AS num FROM db_honor WHERE userid IN (50034,50219,50003,50204,50213,50262,50268,50280,50348,50352) AND status=3 GROUP BY userid [ RunTime:0.002024s ]
SELECT userid,COUNT(*) AS num FROM db_overman WHERE userid IN (50034,50219,50003,50204,50213,50262,50268,50280,50348,50352) AND status=3 GROUP BY userid [ RunTime:0.001215s ]
SELECT username as userid,COUNT(*) AS num FROM db_gongdi WHERE INSTR('50034,50219,50003,50204,50213,50262,50268,50280,50348,50352',username) AND status=3 GROUP BY username [ RunTime:0.006106s ]
SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE mid IN (50034,50219,50003,50204,50213,50262,50268,50280,50348,50352) AND status=3 GROUP BY mid [ RunTime:0.011222s ]
SELECT userid ,COUNT(*) AS num FROM db_comment WHERE userid IN (50034,50219,50003,50204,50213,50262,50268,50280,50348,50352) AND status=3 GROUP BY userid [ RunTime:0.002830s ]
SELECT userid ,COUNT(*) AS num FROM db_company_news WHERE userid IN (50034,50219,50003,50204,50213,50262,50268,50280,50348,50352) AND status=3 GROUP BY userid [ RunTime:0.006539s ]
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` = 50034 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005642s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001923s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000384s ]
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` = 50219 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005549s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000386s ]
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` = 50003 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005511s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000356s ]
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` = 50204 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005585s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000334s ]
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` = 50213 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005654s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000420s ]
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` = 50262 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005714s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ 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` = 50268 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005855s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000414s ]
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` = 50280 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005662s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000429s ]
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` = 50348 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005554s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000423s ]
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` = 50352 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 4 [ RunTime:0.005526s ]
SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000426s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001079s ]
SELECT areaname as name,areaid as code FROM `db_area` WHERE `parentid` = 1 [ RunTime:0.000409s ]
