09月20日马德里竞技vs皇家马德里全场集锦

［SQL语句］

SELECT * FROM `23_csbrsm_com` . `yzm_jj` WHERE (id = '20') LIMIT 1; [ RunTime:0.000441s ]

UPDATE `23_csbrsm_com` . `yzm_jj` SET `click` = `click`+1 WHERE (id = '20'); [ RunTime:0.001371s ]

SELECT title,url FROM `23_csbrsm_com` . `yzm_jj` WHERE (id< '20' AND status = '1' AND catid = '3419') ORDER BY id DESC LIMIT 1; [ RunTime:0.000540s ]

SELECT title,url FROM `23_csbrsm_com` . `yzm_jj` WHERE (id> '20' AND status = '1' AND catid = '3419') ORDER BY id ASC LIMIT 1; [ RunTime:0.000584s ]

SELECT * FROM `23_csbrsm_com` . `yzm_zby_data` WHERE name = 'wx' LIMIT 1; [ RunTime:0.000263s ]

SELECT catid,catname,catdir,arrchildid,pclink,target FROM `23_csbrsm_com` . `yzm_category` WHERE siteid = 0 AND `display`=1 AND parentid=0 ORDER BY listorder ASC LIMIT 20; [ RunTime:0.000730s ]

SELECT arrparentid FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '3419') LIMIT 1; [ RunTime:0.000279s ]

SELECT parentid FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '12') LIMIT 1; [ RunTime:0.000321s ]

SELECT pclink FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '12') LIMIT 1; [ RunTime:0.000335s ]

SELECT catname FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '12') LIMIT 1; [ RunTime:0.000290s ]

SELECT parentid FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '3419') LIMIT 1; [ RunTime:0.000282s ]

SELECT parentid FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '3419') LIMIT 1; [ RunTime:0.000300s ]

SELECT pclink FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '3419') LIMIT 1; [ RunTime:0.000257s ]

SELECT catname FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '3419') LIMIT 1; [ RunTime:0.000261s ]

SELECT id,title,url,playing_time,keduifenshu,zhuduifenshu,keduilogo,zhuduilogo,kedui,zhudui,bisaileibie,bisaijianjie,catid FROM `23_csbrsm_com` . `yzm_live` WHERE status=1 AND catid IN (7,966,967,968,969,970,974,975,976,977,978,979,983,984,986,1003,1005,1010,1011,1012,1015,1046,1047,1048,1049,1050,1051,1052,1062,1063,1072,1073,1074,1078,1084,1085,1089,1092,1093,1099,1105,1106,1111,1114,1115,1118,1121,1130,1131,1132,1135,1137,1138,1146,1147,1148,1154,1163,1164,1165,1167,1170,1171,1172,1178,1180,1181,1185,1187,1188,1199,1200,1204,1206,1207,1211,1214,1215,1217,1219,1220,1225,1227,1229,1230,1231,1232,1268,1269,1272,1275,1276,1277,1289,1290,1291,1303,1304,1306,1307,1308,1354,1355,1356,1357,1373,1376,1385,1388,1389,1390,1394,1395,1416,1417,1418,1421,1422,1424,1425,1428,1429,1430,1432,1434,1435,1437,1449,1450,1465,1466,1475,1484,1485,1492,1500,1501,1502,1509,1510,1511,1514,1515,1525,1526,1527,1535,1539,1540,1569,1570,1579,1582,1653,1654,1655,1660,1668,1669,1676,1679,1680,1682,1851,1867,1876,1892,1908,1961,1977,2266,2270,2273,2282,2534,2549,2561,2737,2749,2789,2882,2900,2928,2986,3054,3085,3109,3128,3159,3173,3198) AND DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') > '2026-09-22 10:56:57' 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 10; [ RunTime:0.004983s ]

SELECT pclink FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '1465') LIMIT 1; [ RunTime:0.000292s ]

SELECT pclink FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '1465') LIMIT 1; [ RunTime:0.000295s ]

SELECT pclink FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '1465') LIMIT 1; [ RunTime:0.000269s ]

SELECT pclink FROM `23_csbrsm_com` . `yzm_category` WHERE (siteid = '0' AND catid = '1231') LIMIT 1; [ RunTime:0.000345s ]

SELECT title,updatetime,url,color,thumb FROM `23_csbrsm_com` . `yzm_article` WHERE status=1 AND catid=3411 ORDER BY listorder ASC,id DESC LIMIT 9; [ RunTime:0.004568s ]

SELECT catid FROM `23_csbrsm_com` . `yzm_live` WHERE DATE_FORMAT(playing_time, '%Y-%m-%d 00:00:00') >= '2026-09-22 00:00:00' and DATE_FORMAT(playing_time, '%Y-%m-%d 23:59:59') <= '2026-10-22 23:59:59' GROUP BY catid; [ RunTime:0.005578s ]

SELECT * FROM `23_csbrsm_com` . `yzm_category` WHERE parentid = 7 and catid in (14,16,166,876,1230,1388,1389,1437,1416,1432,1465,1435,1148,1074,1429,2282,38,188,548,1231,2789,1062,1135,1130,1434,1535,1679,1961) ORDER BY listorder ASC, catid ASC LIMIT 12; [ RunTime:0.001168s ]

SELECT title,updatetime,url,color,thumb FROM `23_csbrsm_com` . `yzm_video` WHERE status=1 AND catid IN (9,3399,3400,3401,3402,3403,3404,3405,3406,3407,3408,3409) ORDER BY listorder ASC,id DESC LIMIT 12; [ RunTime:0.001012s ]

［其他信息］

WEB服务器：nginx/1.30.4

PHP版本：8.0.26

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

框架版本：2.9 查看新版