全站装修公司
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-03-25 02:26:22 HTTP/1.1 GET : http://fs.zx8.com/gs.html
- 运行时间 : 0.994164s [ 吞吐率:1.01req/s ] 内存消耗:1,901.16kb 文件加载:291
- 查询信息 : 66 queries
- 缓存信息 : 157 reads,7 writes
- 会话信息 : SESSION_ID=432b7a1f666b038c2f4dd435d068528f
- CONNECT:[ UseTime:0.005559s ] mysql:host=127.0.0.1;port=3306;dbname=sc_zx8_com;charset=utf8
- SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001440s ]
- SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000549s ]
- SELECT * FROM `db_city` WHERE `domain` = 'fs' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000564s ]
- SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001117s ]
- SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000386s ]
- SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.001545s ]
- SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 236 [ RunTime:0.000334s ]
- SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.001154s ]
- SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000277s ]
- SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.001332s ]
- SELECT * FROM `db_seo` WHERE `url` = '/gs' LIMIT 1 [ RunTime:0.000299s ]
- SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.001194s ]
- SELECT areaname as name,areaid as code FROM `db_area` WHERE `parentid` = 236 [ RunTime:0.000535s ]
- SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001434s ]
- 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` = 236 [ RunTime:0.006314s ]
- 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` = 236 ORDER BY `m`.`vip` DESC,`m`.`is_recomment` DESC,`mm`.`userid` LIMIT 0,15 [ RunTime:0.004047s ]
- SELECT p_userid AS userid,COUNT(*) AS num FROM db_member WHERE p_userid IN (51759,51770,51779,52301,52306,52317,52329,52331,52338,52344,52348,52362,52369,52376,52380) AND status=3 GROUP BY p_userid [ RunTime:0.004644s ]
- SELECT userid,COUNT(*) AS num FROM db_honor WHERE userid IN (51759,51770,51779,52301,52306,52317,52329,52331,52338,52344,52348,52362,52369,52376,52380) AND status=3 GROUP BY userid [ RunTime:0.005307s ]
- SELECT userid,COUNT(*) AS num FROM db_overman WHERE userid IN (51759,51770,51779,52301,52306,52317,52329,52331,52338,52344,52348,52362,52369,52376,52380) AND status=3 GROUP BY userid [ RunTime:0.007711s ]
- SELECT username as userid,COUNT(*) AS num FROM db_gongdi WHERE INSTR('51759,51770,51779,52301,52306,52317,52329,52331,52338,52344,52348,52362,52369,52376,52380',username) AND status=3 GROUP BY username [ RunTime:0.007397s ]
- SELECT mid as userid,COUNT(*) AS num FROM db_photo WHERE mid IN (51759,51770,51779,52301,52306,52317,52329,52331,52338,52344,52348,52362,52369,52376,52380) AND status=3 GROUP BY mid [ RunTime:0.011664s ]
- SELECT userid ,COUNT(*) AS num FROM db_comment WHERE userid IN (51759,51770,51779,52301,52306,52317,52329,52331,52338,52344,52348,52362,52369,52376,52380) AND status=3 GROUP BY userid [ RunTime:0.003020s ]
- SELECT userid ,COUNT(*) AS num FROM db_company_news WHERE userid IN (51759,51770,51779,52301,52306,52317,52329,52331,52338,52344,52348,52362,52369,52376,52380) AND status=3 GROUP BY userid [ RunTime:0.006802s ]
- SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001610s ]
- 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` = 51759 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005850s ]
- SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001607s ]
- SELECT `areaid` FROM `db_member` WHERE `userid` = 51759 LIMIT 1 [ RunTime:0.000550s ]
- 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` = 51770 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.006590s ]
- SELECT `areaid` FROM `db_member` WHERE `userid` = 51770 LIMIT 1 [ RunTime:0.000654s ]
- 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` = 51779 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005690s ]
- SELECT `areaid` FROM `db_member` WHERE `userid` = 51779 LIMIT 1 [ RunTime:0.000600s ]
- 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` = 52301 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005758s ]
- 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` = 52306 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005876s ]
- SELECT `areaid` FROM `db_member` WHERE `userid` = 52306 LIMIT 1 [ RunTime:0.000457s ]
- 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` = 52317 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005809s ]
- SELECT `areaid` FROM `db_member` WHERE `userid` = 52317 LIMIT 1 [ RunTime:0.000619s ]
- 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` = 52329 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005768s ]
- SELECT `areaid` FROM `db_member` WHERE `userid` = 52329 LIMIT 1 [ RunTime:0.000569s ]
- 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` = 52331 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005791s ]
- 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` = 52338 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005762s ]
- 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` = 52344 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005960s ]
- 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` = 52348 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005786s ]
- 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` = 52362 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` = 52369 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005563s ]
- 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` = 52376 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005556s ]
- 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` = 52380 AND `p`.`status` = 3 AND `m`.`groupid` = 1 ORDER BY `p`.`is_tj` DESC LIMIT 6 [ RunTime:0.005585s ]
- SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.002430s ]
- 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.000997s ]
- SHOW FULL COLUMNS FROM `db_news` [ RunTime:0.001982s ]
- SELECT `id`,`title` FROM `db_news` WHERE `status` = 3 AND ( `provinceid` = 236 OR `cityid` = 236 ) ORDER BY rand() LIMIT 8 [ RunTime:0.001312s ]
- SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.001972s ]
- 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.000325s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000465s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000353s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000300s ]
- 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.000314s ]
- 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.000280s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000282s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000276s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000279s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000281s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000281s ]
- SELECT `catid`,`catname`,`parentid` FROM `db_category` WHERE `parentid` = 1467 ORDER BY `listorder` ASC [ RunTime:0.000277s ]

1.004122s