视频测试

［SQL语句］

SELECT * FROM `xxyz_asia` . `yzm_video` WHERE (id = '29') LIMIT 1; [ RunTime:0.000259s ]

UPDATE `xxyz_asia` . `yzm_video` SET `click` = `click`+1 WHERE (id = '29'); [ RunTime:0.002989s ]

SELECT title,url FROM `xxyz_asia` . `yzm_video` WHERE (id< '29' AND status = '1' AND catid = '706') ORDER BY id DESC LIMIT 1; [ RunTime:0.000292s ]

SELECT title,url FROM `xxyz_asia` . `yzm_video` WHERE (id> '29' AND status = '1' AND catid = '706') ORDER BY id ASC LIMIT 1; [ RunTime:0.000314s ]

［其他信息］

WEB服务器：nginx/1.24.0

PHP版本：7.4.33

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

框架版本：2.9 查看新版