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

YzmCMS演示站

首页 > 篮球直播 > 墨西哥联直播

排名第

墨西哥联

矿工对红魔鬼直播

0 : 0

已结束 2026-09-10 10:05

央视直播爱奇艺直播

排名第

历史交锋

日期	主队	比分	客队
2026-09-10	矿工	0 : 0	红魔鬼
2026-09-11	矿工	0 : 0	红魔鬼

矿工近期战绩

败拉巴斯竞技 5 : 4 矿工

败矿工 0 : 0 红魔鬼

败矿工 0 : 0 红魔鬼

红魔鬼近期战绩

败矿工 0 : 0 红魔鬼

败矿工 0 : 0 红魔鬼

比赛前瞻与观看指南

【赛事名称】矿工VS红魔鬼

【联赛名称】墨西哥联

【开赛时间】2026-09-10 10:05:00

说实话，墨西哥联这些年我基本没落下过几场重要比赛，而2026-09-10 10:05:00这场矿工VS红魔鬼，我给它的标签是"必看"。原因很直接：矿工比分0，红魔鬼比分0，两队咬得这么紧的对决一定不会平淡。再加上矿工在主场、红魔鬼是客场，变数就更多了，什么结果都有可能发生。我已经收藏好【矿工vs红魔鬼直播】页面了，免费看高清，设了提醒。如果你也关注这场，建议现在就收藏本页面，别等到临开赛手忙脚乱。另外补一句，这个站直播稳、回放快、墨西哥联的赛程和积分榜更新也及时，算是我常用的观赛入口了。

相关比赛

赛事延伸阅读

弗雷塞罗斯vs墨西卡利直播观看贾利斯科vs墨西卡利直播观看桑托斯圣路易斯vs富尔萨雷吉亚直播观看富尔萨雷吉亚直播桑托斯圣路易斯直播克雷卡米诺斯vs多拉多斯直播观看多拉多斯直播银色巨狼vs弗雷塞罗斯直播观看弗雷塞罗斯直播银色巨狼直播阿比查斯vs弗雷斯尼洛虾直播观看弗雷斯尼洛虾直播

— 运行信息( 0.476 秒):

［系统信息］

错误警告 [文件 /www/wwwroot/yilantepeijian.com/cache/index/show_live_lanqiu_b7308cbde66a14883d81223f2abe0a9d.tpl.php 中,第 10 行] ：Undefined variable $seo_keywords

错误警告 [文件 /www/wwwroot/yilantepeijian.com/cache/index/show_live_lanqiu_b7308cbde66a14883d81223f2abe0a9d.tpl.php 中,第 11 行] ：Undefined variable $seo_description

［SQL语句］

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

SELECT * FROM `yilantepeijian_c` . `yzm_live` WHERE (id = '4670') LIMIT 1; [ RunTime:0.000378s ]

UPDATE `yilantepeijian_c` . `yzm_live` SET `click` = `click`+1 WHERE (id = '4670'); [ RunTime:0.027889s ]

SELECT title,url FROM `yilantepeijian_c` . `yzm_live` WHERE (id< '4670' AND status = '1' AND catid = '32') ORDER BY id DESC LIMIT 1; [ RunTime:0.000496s ]

SELECT title,url FROM `yilantepeijian_c` . `yzm_live` WHERE (id> '4670' AND status = '1' AND catid = '32') ORDER BY id ASC LIMIT 1; [ RunTime:0.000465s ]

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

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

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

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

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 = '32') LIMIT 1; [ RunTime:0.000159s ]

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

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

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

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

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

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

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

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

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

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 (zhudui = '矿工' and kedui = '红魔鬼') or (zhudui = '红魔鬼' and kedui = '矿工') ORDER BY playing_time asc,updatetime desc LIMIT 5; [ RunTime:0.046567s ]

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

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 zhudui = '矿工' or kedui = '矿工' ORDER BY playing_time asc,updatetime desc LIMIT 5; [ RunTime:0.044659s ]

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

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 zhudui = '红魔鬼' or kedui = '红魔鬼' ORDER BY playing_time asc,updatetime desc LIMIT 5; [ RunTime:0.049000s ]

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

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=32 AND DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') > '2026-09-14 23:28:35' and DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') <= '2026-09-22 23:59:59' ORDER BY playing_time asc,updatetime desc LIMIT 12; [ RunTime:0.000355s ]

SELECT id,tag,total FROM `yilantepeijian_c` . `yzm_tag` WHERE siteid=0 AND catid=32 ORDER BY id DESC LIMIT 12; [ RunTime:0.000273s ]

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

SELECT id,title,thumb,url,color,click,description,inputtime FROM `yilantepeijian_c` . `yzm_qiudui` WHERE status=1 AND catid=9 AND title = '矿工' or title = '红魔鬼' ORDER BY listorder ASC,id DESC LIMIT 6; [ RunTime:0.086394s ]

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

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

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 zhudui = '矿工' or zhudui = '红魔鬼' or kedui = '红魔鬼' or kedui = '矿工' ORDER BY playing_time asc,updatetime desc LIMIT 12; [ RunTime:0.047184s ]

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

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

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

SELECT id,title,thumb,url,color,click,description,inputtime FROM `yilantepeijian_c` . `yzm_article` WHERE status=1 AND catid IN (5,1030,1031,1040) ORDER BY listorder ASC,id DESC LIMIT 6; [ RunTime:0.016932s ]

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

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

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

［其他信息］

WEB服务器：nginx/1.30.4

PHP版本：8.0.26

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

框架版本：2.9 查看新版