北京顾好家装饰
装修案例
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2023-09-30 11:29:20 HTTP/1.1 GET : http://bj.zx8.com/50034/anli.html
- 运行时间 : 3.429738s [ 吞吐率：0.29req/s ] 内存消耗：1,682.93kb 文件加载：290
- 查询信息 : 27 queries
- 缓存信息 : 6 reads,1 writes
- 会话信息 : SESSION_ID=7f51a8b3007b41a87c1a02623d25d9e9
- CONNECT:[ UseTime:0.000835s ] mysql:host=127.0.0.1;port=3306;dbname=sc_zx8_com;charset=utf8
- SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.001291s ]
- SELECT `domain`,`cnzz` FROM `db_city` WHERE `is_open` = 1 [ RunTime:0.000415s ]
- SELECT * FROM `db_city` WHERE `domain` = 'bj' AND `is_open` = 1 LIMIT 1 [ RunTime:0.000400s ]
- SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.001119s ]
- SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000353s ]
- SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.000889s ]
- SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `coid` = 50034 [ RunTime:0.000294s ]
- SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000676s ]
- SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000226s ]
- SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.000730s ]
- SELECT * FROM `db_seo` WHERE `url` = '/50034/anli' LIMIT 1 [ RunTime:0.000251s ]
- SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.001012s ]
- SELECT `c`.`userid` FROM `db_company` `c` LEFT JOIN `db_company_data` `cd` ON `cd`.`userid`=`c`.`userid` WHERE `c`.`userid` = '50034' AND `c`.`status` = 3 LIMIT 1 [ RunTime:0.000276s ]
- SELECT `c`.`groupid`,`c`.`username`,`c`.`author`,`c`.`seotitle`,`c`.`areaid`,`c`.`company`,`c`.`company_jc`,`c`.`size`,`c`.`regyear`,`c`.`contacts`,`c`.`telephone`,`c`.`address`,`c`.`lng`,`c`.`lat`,`c`.`thumb`,`c`.`vip`,`c`.`thumb2`,`c`.`validated`,`cd`.`content`,`c`.`undertake_catids`,`c`.`roadwork_catids` FROM `db_company` `c` LEFT JOIN `db_company_data` `cd` ON `cd`.`userid`=`c`.`userid` WHERE `c`.`userid` = '50034' LIMIT 1 [ RunTime:0.000266s ]
- SHOW FULL COLUMNS FROM `db_company_tj` [ RunTime:0.000575s ]
- SELECT * FROM `db_company_tj` WHERE `userid` = 50034 AND `c_date` = '23-09-30' LIMIT 1 [ RunTime:0.259059s ]
- UPDATE `db_company_tj` SET `pv` = `pv` + 1 WHERE `userid` = 50034 AND `c_date` = '23-09-30' [ RunTime:0.537131s ]
- SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.001758s ]
- SELECT `userid` FROM `db_member` WHERE `p_userid` = 50034 AND `status` = 3 [ RunTime:0.000353s ]
- SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.001483s ]
- SELECT * FROM `db_photo` WHERE `status` = 3 AND `mid` IN (50035,50072,50225,50226,50227,50034) ORDER BY `itemid` DESC LIMIT 0,7 [ RunTime:0.038498s ]
- SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.001338s ]
- SELECT `thumb` FROM `db_photo_item` WHERE `item` = 1897248 ORDER BY `itemid` ASC [ RunTime:0.002210s ]
- SELECT `thumb` FROM `db_photo_item` WHERE `item` = 1897247 ORDER BY `itemid` ASC [ RunTime:0.000672s ]
- SELECT `thumb` FROM `db_photo_item` WHERE `item` = 1895616 ORDER BY `itemid` ASC [ RunTime:0.001181s ]
- SELECT `thumb` FROM `db_photo_item` WHERE `item` = 1895615 ORDER BY `itemid` ASC [ RunTime:0.000658s ]
- SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `status` = 3 AND `mid` IN (50035,50072,50225,50226,50227,50034) [ RunTime:0.007974s ]
3.436405s
高级会员
