扫一扫关注微信公众号
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-11-02 22:25:05 HTTP/2.0 GET : https://www.mildec.com/search/%E5%A5%A5%E7%91%9E%E6%AC%A7%C2%B7%E6%99%AE%E6%8B%89.html
- 运行时间 : 1.121306s [ 吞吐率：0.89req/s ] 内存消耗：2,397.41kb 文件加载：163
- 查询信息 : 4 queries
- 缓存信息 : 11 reads,1 writes
- 会话信息 : SESSION_ID=17f9b133d6d1c17126eca1c9d9d5bbe1
- CONNECT:[ UseTime:0.000589s ] mysql:host=127.0.0.1;port=3306;dbname=mildec_com;charset=utf8
- SELECT COUNT(*) AS think_count FROM `zanpiancms_vod` WHERE ( `vod_name` LIKE '%奥瑞欧·普拉%' OR `vod_aliases` LIKE '%奥瑞欧·普拉%' OR `vod_actor` LIKE '%奥瑞欧·普拉%' ) AND `vod_status` = 1 LIMIT 1 [ RunTime:0.349673s ]
- SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_tag`,`vod_title`,`vod_label`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_color`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_content`,`vod_addtime`,`vod_gold`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE ( `vod_name` LIKE '%奥瑞欧·普拉%' OR `vod_aliases` LIKE '%奥瑞欧·普拉%' OR `vod_actor` LIKE '%奥瑞欧·普拉%' ) AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,20 [ RunTime:0.676967s ]
- SELECT `story`.*,`part`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_isend`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_gold`,`vod_golder`,`vod_isfilm`,`vod_filmtime`,`vod_length`,`vod_weekday`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_story` `story` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`story`.`story_vid` LEFT JOIN `zanpiancms_part` `part` ON `part`.`part_oid`=story_page and part.part_vid = story_vid WHERE `story_status` = 1 ORDER BY `story_addtime` DESC LIMIT 0,8 [ RunTime:0.002236s ]
- SELECT `lines`.*,`role`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_isend`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_gold`,`vod_golder`,`vod_isfilm`,`vod_filmtime`,`vod_length`,`vod_weekday`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_lines` `lines` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`lines_vid` LEFT JOIN `zanpiancms_role` `role` ON `role`.`role_name`=lines_role and role.role_vid = lines_vid WHERE `lines_status` = 1 ORDER BY `lines_addtime` DESC LIMIT 0,8 [ RunTime:0.000867s ]
1.132111s
