YzmCMS演示站
西甲新闻

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

YzmCMS演示站 1阅读

2026年9月12日22:15,西甲联赛将展开一场较量,奥萨苏纳坐镇纳瓦拉球场对阵西班牙人。比赛尚未开始,以下为基于公开数据的赛前分析。

积分排名与近期状态

奥萨苏纳本赛季前4轮取得2胜1平1负,进5球失6球,积7分排名第8。球队近期状态有所起伏,上一轮客场2比5不敌阿拉维斯,此前主场1比0小胜赫塔费,客场2比1击败塞尔塔,主场0比0战平莱万特。西班牙人前4轮取得1胜1平2负,进6球失5球,积4分排名第12。球队上一轮主场1比1战平塞维利亚,此前客场1比2不敌皇家社会,主场1比2负于皇家马德里,主场3比0大胜莱万特。

历史交锋

双方近5次西甲交锋中,西班牙人取得3胜2平保持不败。最近一次交手是在2026年5月,奥萨苏纳主场1比2不敌西班牙人。2025年9月,西班牙人主场1比0战胜奥萨苏纳。2025年5月,奥萨苏纳主场2比0击败西班牙人。2024年12月,双方0比0互交白卷。2023年2月,两队1比1战平。

伤停情况

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

进球分布

奥萨苏纳本赛季5个进球中,3个出现在下半场开场15分钟内,2个出现在下半场中段。西班牙人6个进球中,1个在上半场开场15分钟内,1个在上半场中段,2个在上半场结束前,2个在下半场最后15分钟。

未来赛程

奥萨苏纳接下来将客场挑战马德里竞技,随后主场迎战巴列卡诺。西班牙人则将客场对阵巴列卡诺,之后主场迎战埃尔切。

比赛环境

比赛将在纳瓦拉球场进行,当地天气晴朗,气温28°C,湿度32%。

更多比赛信息暂无公开数据。

今日热门比赛 未开赛场次
保利斯塔诺U22 63-56 帕图U22 直播中 预约
里奥卡拉罗U22 67-69 弗鲁米嫩塞U22 直播中 预约
弗雷塞罗斯 0-0 墨西卡利 未开赛 预约
希望之光大学 0-0 莱特 未开赛 预约
关闭 运行信息( 0.1328 秒):
[系统信息]
错误警告 [文件 /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.000301s ]
SELECT * FROM `yilantepeijian_c` . `yzm_article` WHERE (id = '4413') LIMIT 1; [ RunTime:0.000334s ]
UPDATE `yilantepeijian_c` . `yzm_article` SET `click` = `click`+1 WHERE (id = '4413'); [ RunTime:0.002991s ]
SELECT title,url FROM `yilantepeijian_c` . `yzm_article` WHERE (id< '4413' AND status = '1' AND catid = '1037') ORDER BY id DESC LIMIT 1; [ RunTime:0.000526s ]
SELECT title,url FROM `yilantepeijian_c` . `yzm_article` WHERE (id> '4413' AND status = '1' AND catid = '1037') ORDER BY id ASC LIMIT 1; [ RunTime:0.000453s ]
SELECT * FROM `yilantepeijian_c` . `yzm_zby_data` WHERE name = '' LIMIT 1; [ RunTime:0.000176s ]
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.000318s ]
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.002278s ]
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.091120s ]
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.000640s ]
SELECT arrparentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000154s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000142s ]
SELECT pclink FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000143s ]
SELECT catname FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000136s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000135s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000132s ]
SELECT pclink FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000132s ]
SELECT catname FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000133s ]
SELECT * FROM `yilantepeijian_c` . `yzm_zby_data` WHERE name = '' LIMIT 1; [ RunTime:0.000112s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1') LIMIT 1; [ RunTime:0.000171s ]
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:09:53' 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.009489s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000263s ]
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.004652s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1042') LIMIT 1; [ RunTime:0.000271s ]
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.000356s ]
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.000289s ]
[其他信息]
WEB服务器:nginx/1.30.4
PHP版本:8.0.26
路由信息:模块( index ),控制器( index ),方法( show ),参数( catid=1037&id=4413 )
框架版本:2.9 查看新版