开赛提醒NBA、CBA、五大联赛（英超、中超、德甲、西甲、意甲）、中超、欧冠重点赛程，实时比分、赛后回看 赛程总览
YzmCMS演示站
西甲新闻

皇家社会vs塞尔塔在线观看

YzmCMS演示站 1阅读
央视直播 爱奇艺直播

北京时间2026年9月4日03:00，西甲联赛第4轮将迎来一场焦点战，皇家社会坐镇主场迎战塞尔塔。两队在新赛季开局阶段的表现均不尽如人意，本场比赛对于双方而言都是一次抢分良机。

皇家社会近期状态堪忧，在最近5场各项赛事中全部告负。上轮联赛，他们主场5-6惜败于西班牙人，遭遇联赛三连败。此前两轮，他们先是在客场5-8不敌皇家马德里，随后又在客场3-4负于贝蒂斯。在季前友谊赛中，皇家社会也分别以2-4和3-4输给了切尔西和科隆。球队防守端漏洞明显，近5场比赛共失球24个，场均失球接近5个。

塞尔塔的近期表现同样起伏不定。上轮联赛，他们主场0-7惨败给毕尔巴鄂竞技，遭遇一场大比分失利。不过在此之前，他们曾在主场3-3战平奥萨苏纳，并在客场3-2击败瓦伦西亚。在季前友谊赛中，塞尔塔客场3-3战平那不勒斯，客场5-2大胜萨索洛。球队进攻端具备一定火力，但防守稳定性不足。

两队历史交锋中，最近两次碰面均打出高比分。2026年1月26日，皇家社会主场6-2大胜塞尔塔；2025年10月19日，塞尔塔主场6-4击败皇家社会。可见双方对决往往场面开放，进球数较多。

本场比赛，皇家社会坐拥主场之利，但近期连败的阴影尚未散去；塞尔塔客场作战，但上轮惨败后急需调整。两队均渴望一场胜利来扭转颓势，究竟谁能笑到最后，让我们拭目以待。关于双方的首发阵容、伤停情况以及盘口赔率等数据，目前暂无更多公开信息。

今日热门比赛 未开赛场次
皮涅鲁斯U22 42-40 南卡希亚斯U22 直播中 预约
维尔茨堡奥利弗 73-74 曼彻斯特篮球 直播中 预约
博塔弗戈U22 38-47 巴鲁U22 直播中 预约
保利斯塔诺U22 0-0 帕图U22 未开赛 预约
关闭— 运行信息( 0.1282 秒):
［系统信息］
错误警告 [文件 /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.000215s ]
SELECT * FROM `yilantepeijian_c` . `yzm_article` WHERE (id = '150') LIMIT 1; [ RunTime:0.000235s ]
UPDATE `yilantepeijian_c` . `yzm_article` SET `click` = `click`+1 WHERE (id = '150'); [ RunTime:0.003677s ]
SELECT title,url FROM `yilantepeijian_c` . `yzm_article` WHERE (id< '150' AND status = '1' AND catid = '1037') ORDER BY id DESC LIMIT 1; [ RunTime:0.000509s ]
SELECT title,url FROM `yilantepeijian_c` . `yzm_article` WHERE (id> '150' AND status = '1' AND catid = '1037') ORDER BY id ASC LIMIT 1; [ RunTime:0.000366s ]
SELECT * FROM `yilantepeijian_c` . `yzm_zby_data` WHERE name = '' LIMIT 1; [ RunTime:0.000146s ]
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.000259s ]
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.001645s ]
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.078166s ]
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.000657s ]
SELECT arrparentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000201s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000183s ]
SELECT pclink FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000145s ]
SELECT catname FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000158s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000147s ]
SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000147s ]
SELECT pclink FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000171s ]
SELECT catname FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000173s ]
SELECT * FROM `yilantepeijian_c` . `yzm_zby_data` WHERE name = '' LIMIT 1; [ RunTime:0.000129s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1') LIMIT 1; [ RunTime:0.000201s ]
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 01:21:26' 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.017847s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1037') LIMIT 1; [ RunTime:0.000269s ]
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.005247s ]
SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1042') LIMIT 1; [ RunTime:0.000257s ]
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.000335s ]
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.000268s ]
［其他信息］
WEB服务器：nginx/1.30.4
PHP版本：8.0.26
路由信息：模块( index )，控制器( index )，方法( show )，参数( catid=1037&id=150 )
框架版本：2.9 查看新版