4657
张冲别名：未知
外文名：未知
性别：男
国籍：中国
身高：未知
体重：未知
民族：未知
星座：未知
血型：未知
出生日期：2016年2月23日
出生地区：中国湖北
职业：演员
毕业院校：未知
经纪公司：未知
人气：49461°
扫一扫关注微信公众号
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2024-06-02 16:32:16 HTTP/2.0 GET : https://www.sterlingrisq.com.cn/mingxing/zhangchong-role.html
- 运行时间 : 0.163124s [ 吞吐率：6.13req/s ] 内存消耗：2,298.30kb 文件加载：163
- 查询信息 : 9 queries
- 缓存信息 : 10 reads,1 writes
- 会话信息 : SESSION_ID=dfaa29d57df256fd9e28b382e099ce0f
- CONNECT:[ UseTime:0.000905s ] mysql:host=127.0.0.1;port=3306;dbname=sterlingrisq_com;charset=utf8
- SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'zhangchong' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001071s ]
- SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '张冲' [ RunTime:0.001537s ]
- SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (10492,11253,14292,19212) [ RunTime:0.001093s ]
- SELECT `star_id`,`star_pid`,`star_cid`,`star_name`,`star_bm`,`star_mcid`,`star_wwm`,`star_pinyin`,`star_tag`,`star_label`,`star_color`,`star_pic`,`star_pic_thumb`,`star_pic_big`,`star_xb`,`star_sg`,`star_tz`,`star_mz`,`star_cstime`,`star_school`,`star_gs`,`star_weibo`,`star_work`,`star_guanxi`,`star_zy`,`star_xz`,`star_xx`,`star_area`,`star_gj`,`star_csd`,`star_hits`,`star_hits_day`,`star_hits_yesterday`,`star_hits_week`,`star_hits_month`,`star_hits_lasttime`,`star_addtime`,`star_stars`,`star_up`,`star_down`,`star_flower`,`star_jumpurl` FROM `zanpiancms_star` WHERE `star_name` IN ('苗可秀','唐菁','茅瑛','李昆','罗维','罗大维','程小东','Cheng','Mang-Ha','张天爱','刘松仁','徐少强','姚庆康','徐玉龙','潘迎紫','施思','马沙','王冠雄','谢贤','田俊','Paul','Chang','Chung','叶荣祖') AND `star_status` = 1 ORDER BY field(star_name,'苗可秀','唐菁','茅瑛','李昆','罗维','罗大维','程小东','Cheng','Mang-Ha','张天爱','刘松仁','徐少强','姚庆康','徐玉龙','潘迎紫','施思','马沙','王冠雄','谢贤','田俊','Paul','Chang','Chung','叶荣祖') LIMIT 0,6 [ RunTime:0.008682s ]
- 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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_pid` = '1' AND `actors_name` = '张冲' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_id` DESC LIMIT 0,1 [ RunTime:0.002073s ]
- 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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_pid` = '2' AND `actors_name` = '张冲' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_id` DESC LIMIT 0,1 [ RunTime:0.001630s ]
- 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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_pid` = '4' AND `actors_name` = '张冲' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_id` DESC LIMIT 0,1 [ RunTime:0.001515s ]
- SELECT COUNT(*) AS think_count FROM `zanpiancms_role` `role` LEFT JOIN `zanpiancms_vod` `v` ON `v`.`vod_id`=`role`.`role_vid` WHERE `role_star` = '张冲' AND `role_status` = 1 LIMIT 1 [ RunTime:0.002090s ]
- SELECT `role`.*,`star`.*,`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_role` `role` LEFT JOIN `zanpiancms_vod` `v` ON `v`.`vod_id`=`role`.`role_vid` LEFT JOIN `zanpiancms_star` `star` ON `star`.`star_name`=`role_star` WHERE `role_star` = '张冲' AND `role_status` = 1 ORDER BY `role_addtime` DESC LIMIT 0,12 [ RunTime:0.002802s ]
0.183192s
