［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.000991s ]

SELECT catid FROM `xsuuc_cn` . `yzm_live` WHERE catid in (285,286,287,288,52,22,23,24,25,26,28,90,27,29,30,50,51,53,84,85,86,87,89,91,92,93,94,95,96,97,98,100,101,102,103,105,106,107,108,109,110,111,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,88,99,104,112) 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.059382s ]

SELECT * FROM `xsuuc_cn` . `yzm_category` WHERE catid in (101,149,157,148,181,205,112,167,109,286) ORDER BY listorder ASC, catid ASC LIMIT 12; [ RunTime:0.000717s ]

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 (9,22,23,24,25,26,27,28,29,30,50,51,52,53,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,285,286,287,288) 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.075498s ]

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 (9,22,23,24,25,26,27,28,29,30,50,51,52,53,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,285,286,287,288) AND DATE_FORMAT(playing_time, '%Y-%m-%d') = '2026-06-18' ORDER BY playing_time asc,updatetime desc LIMIT 20; [ RunTime:0.064964s ]

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 (9,22,23,24,25,26,27,28,29,30,50,51,52,53,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,285,286,287,288) AND DATE_FORMAT(playing_time, '%Y-%m-%d') = '2026-06-19' ORDER BY playing_time asc,updatetime desc LIMIT 20; [ RunTime:0.043628s ]

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

SELECT id,title,thumb,url,color,click,description,inputtime FROM `xsuuc_cn` . `yzm_video` WHERE status=1 AND catid IN (54,35,36,37,38,39,40,41,42,43,62,63,64,266,268,270,272,274) ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.004760s ]

SELECT id,title,thumb,url,color,click,description,inputtime FROM `xsuuc_cn` . `yzm_jj` WHERE status=1 AND catid IN (66,70,71,72,73,74,75,76,77,78,79,80,81,267,269,271,273,275) ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.007406s ]

［其他信息］

WEB服务器：nginx/1.28.0

PHP版本：8.0.26

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

框架版本：2.9 查看新版