［SQL语句］

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

SELECT catid FROM `xsuuc_cn` . `yzm_live` WHERE catid in (289,10,11,32,33,31,48,49,61,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265) and DATE_FORMAT(playing_time, '%Y-%m-%d 00:00:00') >= '2026-06-17 00:00:00' and DATE_FORMAT(playing_time, '%Y-%m-%d 23:59:59') <= '2026-07-17 23:59:59' GROUP BY catid; [ RunTime:0.039450s ]

SELECT * FROM `xsuuc_cn` . `yzm_category` WHERE catid in (33) ORDER BY listorder ASC, catid ASC LIMIT 12; [ RunTime:0.000151s ]

SELECT id,title,url,playing_time,keduifenshu,zhuduifenshu,keduilogo,zhuduilogo,kedui,zhudui,bisaileibie,bisaijianjie,catid FROM `xsuuc_cn` . `yzm_live` WHERE status=1 AND catid IN (8,10,11,31,32,33,48,49,61,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,289) AND DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') > '2026-06-17 14:40:43' and DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') <= '2026-06-17 23:59:59' ORDER BY playing_time asc,updatetime desc LIMIT 20; [ RunTime:0.049762s ]

SELECT id,title,url,playing_time,keduifenshu,zhuduifenshu,keduilogo,zhuduilogo,kedui,zhudui,bisaileibie,bisaijianjie,catid FROM `xsuuc_cn` . `yzm_live` WHERE status=1 AND catid IN (8,10,11,31,32,33,48,49,61,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,289) AND DATE_FORMAT(playing_time, '%Y-%m-%d') = '2026-06-18' ORDER BY playing_time asc,updatetime desc LIMIT 20; [ RunTime:0.049355s ]

SELECT id,title,url,playing_time,keduifenshu,zhuduifenshu,keduilogo,zhuduilogo,kedui,zhudui,bisaileibie,bisaijianjie,catid FROM `xsuuc_cn` . `yzm_live` WHERE status=1 AND catid IN (8,10,11,31,32,33,48,49,61,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,289) AND DATE_FORMAT(playing_time, '%Y-%m-%d') = '2026-06-19' ORDER BY playing_time asc,updatetime desc LIMIT 20; [ RunTime:0.052960s ]

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

SELECT id,title,thumb,url,color,click,description,inputtime FROM `xsuuc_cn` . `yzm_video` WHERE status=1 AND catid IN (12,13,21,55,56,59,278,280) ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.004145s ]

SELECT id,title,thumb,url,color,click,description,inputtime FROM `xsuuc_cn` . `yzm_jj` WHERE status=1 AND catid IN (65,67,68,69,279,281,282,283) ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.004847s ]

［其他信息］

WEB服务器：nginx/1.28.0

PHP版本：8.0.26

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

框架版本：2.9 查看新版