24直播网

［SQL语句］

SELECT catid FROM `299399_cn` . `yzm_live` WHERE DATE_FORMAT(playing_time, '%Y-%m-%d 00:00:00') >= '2026-08-06 00:00:00' and DATE_FORMAT(playing_time, '%Y-%m-%d 23:59:59') <= '2026-09-05 23:59:59' GROUP BY catid; [ RunTime:0.037844s ]

SELECT * FROM `299399_cn` . `yzm_category` WHERE catid in (507,61,2962,2748,14,1357,1355,115,137,1388,1444,1422,80,1435,1395,2442,1011,1053,2441,663,1130,105,114,1195,645,414,263,1054,48,1055,694,1182,1668,623,1156,2737,675,1095,724,668,3055,1147,1178,3053,1229,1012,1159,1606,2738,1150,989,1216,671,1568,1898,2282,1434,1993,1437,2217,1421,1389,2046,158,1429,1943,1428,471,1243,1114,1239,1242,1318,930,2844,1063,672,1276,1230,16,1291,1965,1132,1694,2131,418,1342,301,544,1115,132,135,1164,1207,1292,1146,1170,1253,1199,1260,1321,1261,1322,2337,1214,1257,1236,1330,1629,1329,1967,1418,1445,1440,1448,1442,1447,1394,1963,1417,1430,2850,2123,2120,1413,1078,1289,2143,1206,1977,1304,1332,1390,1620,1094,1208,1268,1163,1137,1235,1340,1311,1326,1180,3185,1240,1189,1958,1148,1320,1200,1157,1256,1209,1296,1269,1183,2044,1349,1219,1221,1121,1131,1185,1210,1149,1194,1315,1254,2526,2280,1165,1160,1215,1344,1187,2177,1171,1989,3078,1152,2176,1500,1158,3368,3259,1093,1501,1502,1203,3268,2294,1172,1526,1525,1530,1181,3382,2189,2838,2360,2103,1553,1547,1557,2118,3173,2150,2059,2111,2149,1425,2507,1645,3221,1966,1908,1416,3143,2089,1106,2128,1992,1345,1295,1303,2095,1323,1220,1224,1327,1628,2573,1270,1050,1052,1153,2001,1124,1125,3182,2270,1123,1051,1122,1456,2356,3356,2635,3218,3202,3362,1540,1539,1543,1556,1554,1231,2094,2096,1685,1552,1551,3177,2751,1690,2148,2151,2125,1107,1263,1190,1186,1241,2132,1202,1316,2428,1609,2587,2117,2239,1409,1438,2354,2702,2704,1924,1660,2209,1983,2165,2007,1312,999,2421,2486,2086,1361,1423,2502,1436,2340,3210,2631,1383,1432,3224,2252,2906,1020,1664,1981,1211,1204,1324,2548,2601,402,2948,2065,2465) ORDER BY listorder ASC, catid ASC LIMIT 15; [ RunTime:0.003987s ]

SELECT catid FROM `299399_cn` . `yzm_live` WHERE DATE_FORMAT(playing_time, '%Y-%m-%d 00:00:00') >= '2026-08-06 00:00:00' and DATE_FORMAT(playing_time, '%Y-%m-%d 23:59:59') <= '2026-09-05 23:59:59' GROUP BY catid; [ RunTime:0.034428s ]

SELECT * FROM `299399_cn` . `yzm_category` WHERE catid in (507,61,2962,2748,14,1357,1355,115,137,1388,1444,1422,80,1435,1395,2442,1011,1053,2441,663,1130,105,114,1195,645,414,263,1054,48,1055,694,1182,1668,623,1156,2737,675,1095,724,668,3055,1147,1178,3053,1229,1012,1159,1606,2738,1150,989,1216,671,1568,1898,2282,1434,1993,1437,2217,1421,1389,2046,158,1429,1943,1428,471,1243,1114,1239,1242,1318,930,2844,1063,672,1276,1230,16,1291,1965,1132,1694,2131,418,1342,301,544,1115,132,135,1164,1207,1292,1146,1170,1253,1199,1260,1321,1261,1322,2337,1214,1257,1236,1330,1629,1329,1967,1418,1445,1440,1448,1442,1447,1394,1963,1417,1430,2850,2123,2120,1413,1078,1289,2143,1206,1977,1304,1332,1390,1620,1094,1208,1268,1163,1137,1235,1340,1311,1326,1180,3185,1240,1189,1958,1148,1320,1200,1157,1256,1209,1296,1269,1183,2044,1349,1219,1221,1121,1131,1185,1210,1149,1194,1315,1254,2526,2280,1165,1160,1215,1344,1187,2177,1171,1989,3078,1152,2176,1500,1158,3368,3259,1093,1501,1502,1203,3268,2294,1172,1526,1525,1530,1181,3382,2189,2838,2360,2103,1553,1547,1557,2118,3173,2150,2059,2111,2149,1425,2507,1645,3221,1966,1908,1416,3143,2089,1106,2128,1992,1345,1295,1303,2095,1323,1220,1224,1327,1628,2573,1270,1050,1052,1153,2001,1124,1125,3182,2270,1123,1051,1122,1456,2356,3356,2635,3218,3202,3362,1540,1539,1543,1556,1554,1231,2094,2096,1685,1552,1551,3177,2751,1690,2148,2151,2125,1107,1263,1190,1186,1241,2132,1202,1316,2428,1609,2587,2117,2239,1409,1438,2354,2702,2704,1924,1660,2209,1983,2165,2007,1312,999,2421,2486,2086,1361,1423,2502,1436,2340,3210,2631,1383,1432,3224,2252,2906,1020,1664,1981,1211,1204,1324,2548,2601,402,2948,2065,2465) ORDER BY listorder ASC, catid ASC LIMIT 10; [ RunTime:0.003166s ]

SELECT id,title,url,playing_time,keduifenshu,zhuduifenshu,keduilogo,zhuduilogo,kedui,zhudui,bisaileibie,bisaijianjie,catid FROM `299399_cn` . `yzm_live` WHERE status=1 AND catid=1977 AND DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') > '2026-08-06 00:00:00' and DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') <= '2026-08-06 23:59:59' ORDER BY playing_time asc,updatetime desc LIMIT 20; [ RunTime:0.000572s ]

SELECT id,title,url,playing_time,keduifenshu,zhuduifenshu,keduilogo,zhuduilogo,kedui,zhudui,bisaileibie,bisaijianjie,catid FROM `299399_cn` . `yzm_live` WHERE status=1 AND catid=1977 AND DATE_FORMAT(playing_time, '%Y-%m-%d') = '2026-08-07' ORDER BY playing_time asc,updatetime desc LIMIT 20; [ RunTime:0.000576s ]

SELECT id,title,url,playing_time,keduifenshu,zhuduifenshu,keduilogo,zhuduilogo,kedui,zhudui,bisaileibie,bisaijianjie,catid FROM `299399_cn` . `yzm_live` WHERE status=1 AND catid=1977 AND DATE_FORMAT(playing_time, '%Y-%m-%d') = '2026-08-08' ORDER BY playing_time asc,updatetime desc LIMIT 20; [ RunTime:0.000590s ]

SELECT title,inputtime,url,color,thumb FROM `299399_cn` . `yzm_live` WHERE status=1 AND catid=18 ORDER BY listorder ASC,id DESC LIMIT 10; [ RunTime:0.000524s ]

SELECT title,inputtime,url,color,thumb FROM `299399_cn` . `yzm_live` WHERE status=1 AND catid=54 ORDER BY listorder ASC,id DESC LIMIT 10; [ RunTime:0.000490s ]

［其他信息］

WEB服务器：nginx/1.30.4

PHP版本：8.0.26

路由信息：模块( index )，控制器( index )，方法( lists )，参数( catid=1977 )

框架版本：2.9 查看新版