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

YzmCMS演示站

德甲新闻

斯图加特vs科隆免费观看

2026-09-04 05:22 YzmCMS演示站 1阅读

央视直播爱奇艺直播

北京时间2026年9月5日02:30，德甲第3轮将迎来一场焦点战，斯图加特坐镇主场迎战科隆。两队在新赛季开局表现迥异，本场比赛的走势值得关注。

斯图加特近期状态

斯图加特在上一轮德甲客场挑战拜仁，双方上演进球大战，最终以4比7落败，虽然输球但进攻端展现出不俗的火力。此前在德国杯首轮，斯图加特客场7比1大胜罗斯托克，显示出强大的攻击力。在季前友谊赛中，斯图加特曾0比1不敌富勒姆，但随后4比1击败埃弗顿，3比2战胜巴黎FC，整体状态较为出色。

科隆近期状态

科隆在上一轮德甲主场迎战霍芬海姆，以3比5告负，防守端问题突出。在德国杯首轮，科隆客场与维尔茨堡踢球者战成3比3平，最终通过点球大战晋级，但常规时间内未能取胜。季前友谊赛中，科隆4比3战胜皇家社会，3比2击败柏林赫塔，但对手实力一般。值得注意的是，科隆在5月16日客场对阵拜仁时以3比9惨败，暴露出与强队对抗时的差距。

历史交锋

双方最近一次交手是在2026年2月15日的德甲联赛中，斯图加特主场8比2大胜科隆，心理优势明显。

比赛展望

斯图加特坐拥主场之利，且进攻火力强劲，但防守端在近期比赛中失球较多；科隆客场作战能力有限，且历史交锋处于劣势。本场比赛，斯图加特有望借助主场优势全取三分，但科隆也可能给主队制造麻烦。更多球员伤停、首发等数据暂无公开信息，请以官方公布为准。

今日热门比赛 未开赛场次

09-1502:15 维尔茨堡奥利弗 73-74 曼彻斯特篮球 直播中 预约

09-1502:15 皮涅鲁斯U22 65-60 南卡希亚斯U22 直播中 预约

09-1503:15 博塔弗戈U22 60-64 巴鲁U22 直播中 预约

09-1504:30 保利斯塔诺U22 0-0 帕图U22 直播中 预约

— 运行信息( 0.1174 秒):

［系统信息］

错误警告 [文件 /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 = '1036') LIMIT 1; [ RunTime:0.000208s ]

SELECT * FROM `yilantepeijian_c` . `yzm_article` WHERE (id = '1135') LIMIT 1; [ RunTime:0.000213s ]

UPDATE `yilantepeijian_c` . `yzm_article` SET `click` = `click`+1 WHERE (id = '1135'); [ RunTime:0.003685s ]

SELECT title,url FROM `yilantepeijian_c` . `yzm_article` WHERE (id< '1135' AND status = '1' AND catid = '1036') ORDER BY id DESC LIMIT 1; [ RunTime:0.001207s ]

SELECT title,url FROM `yilantepeijian_c` . `yzm_article` WHERE (id> '1135' AND status = '1' AND catid = '1036') ORDER BY id ASC LIMIT 1; [ RunTime:0.000471s ]

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.002247s ]

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.085895s ]

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.000654s ]

SELECT arrparentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1036') LIMIT 1; [ RunTime:0.000159s ]

SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000146s ]

SELECT pclink FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000139s ]

SELECT catname FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '6') LIMIT 1; [ RunTime:0.000135s ]

SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1036') LIMIT 1; [ RunTime:0.000134s ]

SELECT parentid FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1036') LIMIT 1; [ RunTime:0.000133s ]

SELECT pclink FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1036') LIMIT 1; [ RunTime:0.000132s ]

SELECT catname FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1036') LIMIT 1; [ RunTime:0.000132s ]

SELECT * FROM `yilantepeijian_c` . `yzm_zby_data` WHERE name = '' LIMIT 1; [ RunTime:0.000111s ]

SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1') LIMIT 1; [ RunTime:0.000170s ]

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 02:01:49' 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.002910s ]

SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1036') LIMIT 1; [ RunTime:0.000182s ]

SELECT title,thumb,url,color,inputtime,click,description FROM `yilantepeijian_c` . `yzm_article` WHERE status=1 AND catid=1036 ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.001272s ]

SELECT * FROM `yilantepeijian_c` . `yzm_category` WHERE (siteid = '0' AND catid = '1042') LIMIT 1; [ RunTime:0.000179s ]

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.000226s ]

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.000186s ]

［其他信息］

WEB服务器：nginx/1.30.4

PHP版本：8.0.26

路由信息：模块( index )，控制器( index )，方法( show )，参数( catid=1036&id=1135 )

框架版本：2.9 查看新版