YzmCMS演示站
西甲新闻

奥萨苏纳vs西班牙人视频直播

YzmCMS演示站 2阅读

2026年9月12日22:15,西甲联赛第5轮,奥萨苏纳将在主场纳瓦拉球场迎战西班牙人。比赛当天天气晴朗,气温27°C,湿度34%,适宜足球比赛。

奥萨苏纳本赛季前4轮取得2胜1平1负,进5球失6球,积7分暂列积分榜第8位。球队近期表现有所起伏,上一轮客场2-5不敌阿拉维斯,此前主场1-0战胜赫塔费,客场2-1击败塞尔塔,主场0-0战平莱万特。在8月的一场友谊赛中,奥萨苏纳客场1-1与阿里纳斯握手言和。

西班牙人前4轮战绩为1胜1平2负,进6球失5球,积4分排名第12位。球队在首轮主场3-0大胜莱万特后,先后负于皇家马德里和皇家社会,上一轮主场1-1战平塞维利亚,近两轮未能取胜。友谊赛中,西班牙人曾客场1-3不敌考文垂。

历史交锋方面,双方近5次西甲相遇,奥萨苏纳取得1胜2平2负。最近一次交手是在2026年5月,奥萨苏纳主场1-2不敌西班牙人;2025年9月,西班牙人主场1-0小胜;2025年5月,奥萨苏纳主场2-0取胜;2024年12月,双方0-0互交白卷;2023年2月,西班牙人主场1-1战平。

伤停情况:奥萨苏纳方面,罗西耶(肌肉损伤)已恢复训练,埃兰多(肌肉损伤)、奥罗斯(腘绳肌损伤)和莫伊·戈麦斯(肌肉损伤)预计9月下旬回归。西班牙人方面,普阿多(交叉韧带损伤)预计9月下旬复出,基克(腘绳肌损伤)归期未知,戈罗萨贝尔(肌肉损伤)难以预测。

进球分布显示,奥萨苏纳的5个进球全部来自下半场,其中第61-75分钟打入3球,第76-90分钟打入2球。西班牙人的6个进球中,3个出现在上半场,2个出现在比赛最后15分钟。

未来赛程方面,奥萨苏纳下一轮将客场挑战马德里竞技,随后主场对阵巴列卡诺;西班牙人下一轮客场对阵巴列卡诺,之后主场迎战埃尔切。

本场比赛暂无更多公开数据,双方首发阵容和具体战术安排需等待赛前公布。

今日热门比赛 未开赛场次
保利斯塔诺U22 65-58 帕图U22 直播中 预约
里奥卡拉罗U22 67-71 弗鲁米嫩塞U22 直播中 预约
弗雷塞罗斯 0-0 墨西卡利 未开赛 预约
希望之光大学 0-0 莱特 未开赛 预约
关闭 运行信息( 0.1188 秒):
[系统信息]
错误警告 [文件 /www/wwwroot/yilantepeijian.com/cache/index/show_article_lanqiu_7cfd85b5d2888431aa99a35bf49ae758.tpl.php 中,第 10 行] :Undefined variable $seo_keywords
错误警告 [文件 /www/wwwroot/yilantepeijian.com/cache/index/show_article_lanqiu_7cfd85b5d2888431aa99a35bf49ae758.tpl.php 中,第 11 行] :Undefined variable $seo_description
[SQL语句]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000263s ]
SELECT * FROM `yilantepeijian_c` . `yzm_article` WHERE (id = '4367') LIMIT 1; [ RunTime:0.000256s ]
UPDATE `yilantepeijian_c` . `yzm_article` SET `click` = `click`+1 WHERE (id = '4367'); [ RunTime:0.003033s ]
SELECT title,url FROM `yilantepeijian_c` . `yzm_article` WHERE (id< '4367' AND status = '1' AND catid = '1037') ORDER BY id DESC LIMIT 1; [ RunTime:0.000502s ]
SELECT title,url FROM `yilantepeijian_c` . `yzm_article` WHERE (id> '4367' AND status = '1' AND catid = '1037') ORDER BY id ASC LIMIT 1; [ RunTime:0.000451s ]
SELECT * FROM `yilantepeijian_c` . `yzm_zby_data` WHERE name = '' LIMIT 1; [ RunTime:0.000174s ]
SELECT catid,catname,pclink FROM `yilantepeijian_c` . `yzm_category` WHERE catid in (13,15,125,431,163,156,148,114) ORDER BY listorder ASC, catid ASC LIMIT 10; [ RunTime:0.000322s ]
SELECT catid,catname,arrchildid,pclink FROM `yilantepeijian_c` . `yzm_category` WHERE siteid = 0 AND `display`=1 AND parentid=0 ORDER BY listorder ASC LIMIT 20; [ RunTime:0.002252s ]
SELECT catid FROM `yilantepeijian_c` . `yzm_live` WHERE DATE_FORMAT(playing_time, '%Y-%m-%d 00:00:00') >= '2026-09-15 00:00:00' and DATE_FORMAT(playing_time, '%Y-%m-%d 23:59:59') <= '2026-10-15 23:59:59' GROUP BY catid; [ RunTime:0.086223s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE catid in (125,156,148,172,215,178,947,200,606,224,142,126,191,375,115,360,948,32,54,53,134,157,237,221,250,245,344,192,274,179,268,201,317,300,314,301,320,321,371,372,376,409,403,408,401,483,467,505,507,420,410,595,533,896,336,335,543,139,249,203,292,406,541,568,736,623,618,577,555,840,894,907,902,909,650,917,965,930,583,578,950,604,84,682,254,269,307,273,305,264,469,493,225,625,472,593,342,465,309,519,140,787,257,668,564,769,949,864,726,619,611,818,656,718,591,879,205,579) ORDER BY listorder ASC, catid ASC LIMIT 12; [ RunTime:0.000642s ]
SELECT arrparentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000181s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000172s ]
SELECT pclink FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000162s ]
SELECT catname FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000160s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000141s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000141s ]
SELECT pclink FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000144s ]
SELECT catname FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000145s ]
SELECT * FROM `yilantepeijian_c` . `yzm_zby_data` WHERE name = '' LIMIT 1; [ RunTime:0.000119s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1') LIMIT 1; [ RunTime:0.000196s ]
SELECT id,title,url,playing_time,keduifenshu,zhuduifenshu,keduilogo,zhuduilogo,kedui,zhudui,bisaileibie,bisaijianjie,catid FROM `yilantepeijian_c` . `yzm_live` WHERE status=1 AND catid IN (1,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102) AND DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') > '2026-09-15 04:16:06' and DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') <= '2026-09-15 23:59:59' ORDER BY listorder asc,playing_time asc,updatetime desc LIMIT 4; [ RunTime:0.003429s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000199s ]
SELECT title,thumb,url,color,inputtime,click,description FROM `yilantepeijian_c` . `yzm_article` WHERE status=1 AND catid=1037 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.002897s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1042') LIMIT 1; [ RunTime:0.000221s ]
SELECT title,thumb,url,color,inputtime,click,description FROM `yilantepeijian_c` . `yzm_article` WHERE status=1 AND catid=1042 ORDER BY listorder ASC,id DESC LIMIT 12; [ RunTime:0.000262s ]
SELECT catid,catname,pclink FROM `yilantepeijian_c` . `yzm_category` WHERE catid in (13,15,125,431,163,156,148,114) ORDER BY listorder ASC, catid ASC LIMIT 4; [ RunTime:0.000217s ]
[其他信息]
WEB服务器:nginx/1.30.4
PHP版本:8.0.26
路由信息:模块( index ),控制器( index ),方法( show ),参数( catid=1037&id=4367 )
框架版本:2.9 查看新版