09月21日康涅狄格太阳vs明尼苏达山猫全场集锦

［SQL语句］

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 (6,13,14,15,16,17,18,19,20,21,22,23,24,25,30,31,32,34,38,42,53,56,57,65,72,83,108,111,116,119,123,126,127,136,138,148,151,159,161,162,165,166,167,174,179,188,202,206,208,218,254,263,265,266,272,276,318,335,425,427,443,460,461,479,548,588,669,739,817,859,860,876,881,891,895,925,940,942,943,944,964) AND DATE_FORMAT(playing_time, '%Y-%m-%d %H:%i:%s') > '2026-09-22 10:13:16' 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.002278s ]

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

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

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

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

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

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

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

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

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

SELECT * FROM `23_csbrsm_com` . `yzm_category` WHERE parentid = 6 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.000850s ]

SELECT title,updatetime,url,color,thumb FROM `23_csbrsm_com` . `yzm_video` WHERE status=1 AND catid IN (8,3394,3395,3396,3397,3398) ORDER BY listorder ASC,id DESC LIMIT 12; [ RunTime:0.000682s ]

［其他信息］

WEB服务器：nginx/1.30.4

PHP版本：8.0.26

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

框架版本：2.9 查看新版