猜你喜欢
影片评论
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-09-09 01:10:46 HTTP/1.1 GET : http://nwbook.com/video/909.html
- 运行时间 : 0.028258s [ 吞吐率：35.39req/s ] 内存消耗：561.59kb 文件加载：158
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=4e3861cd7300c40cdb33fccb8bda4be5
- CONNECT:[ UseTime:0.000479s ] mysql:host=127.0.0.1;port=3306;dbname=com_video;charset=utf8mb4
- SELECT * FROM `hao_domain` WHERE `host` = 'nwbook.com' LIMIT 1 [ RunTime:0.000374s ]
- SELECT `v`.*,c1.id as typeId,c1. name as typeName,c2.id as topId,c2. name as topName,`d`.`vod_content`,d. vod_play_url FROM `hao_video` `v` LEFT JOIN `hao_video_cate` `c1` ON `c1`.`id`=`v`.`type_id` LEFT JOIN `hao_video_cate` `c2` ON `c2`.`id`=`c1`.`pid` LEFT JOIN `hao_video_data` `d` ON `d`.`video_id`=`v`.`id` WHERE `v`.`id` = '908' LIMIT 1 [ RunTime:0.000850s ]
- SELECT * FROM `hao_video_watch1` WHERE `video_id` = 908 LIMIT 1 [ RunTime:0.000367s ]
- UPDATE `hao_video_watch1` SET `watch_view` = `watch_view` + 1 WHERE `video_id` = 908 AND `watch_id` = 2582 [ RunTime:0.001552s ]
- SELECT * FROM `hao_video_cate` WHERE `pid` = 0 AND `state` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000371s ]
- SELECT * FROM `hao_video_cate` WHERE `pid` = 1 AND `state` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000440s ]
- SELECT * FROM `hao_video_cate` WHERE `pid` = 2 AND `state` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000387s ]
- SELECT * FROM `hao_video_cate` WHERE `pid` = 3 AND `state` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000299s ]
- SELECT * FROM `hao_video_cate` WHERE `pid` = 4 AND `state` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000366s ]
- SELECT * FROM `hao_video_cate` WHERE `pid` = 5 AND `state` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000278s ]
- SELECT `w`.*,`v`.* FROM `hao_video_watch1` `w` LEFT JOIN `hao_video` `v` ON `v`.`id`=`w`.`video_id` WHERE `w`.`watch_id` < '2582' ORDER BY `w`.`watch_id` DESC LIMIT 6 [ RunTime:0.000568s ]
- SELECT `w`.*,`v`.* FROM `hao_video_watch1` `w` LEFT JOIN `hao_video` `v` ON `v`.`id`=`w`.`video_id` WHERE `w`.`watch_id` > '2582' ORDER BY `w`.`watch_id` ASC LIMIT 6 [ RunTime:0.000541s ]
- SELECT `v`.`douban_id`,v. user_id,v. vote_count,v. text,v. create_time,m.username as user_name,m. nickname as user_nick,m. img as user_img FROM `hao_video_comment` `v` LEFT JOIN `hao_member` `m` ON `m`.`id`=`v`.`user_id` WHERE `v`.`douban_id` = '0' ORDER BY `v`.`id` DESC [ RunTime:0.000435s ]
0.029668s
用户评论