内容列表

• 2025-04-23 09:07:33测试

［SQL语句］

SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '62') LIMIT 1; [ RunTime:0.048250s ]

SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '62') LIMIT 1; [ RunTime:0.004556s ]

UPDATE `xxyz_asia` . `yzm_member_detail` SET `guest`=`guest`+1 WHERE (userid = '62'); [ RunTime:0.004172s ]

SELECT COUNT(*) AS total FROM `xxyz_asia` . `yzm_all_content` WHERE (userid = '62' AND status = '1' AND issystem = '0'); [ RunTime:0.000333s ]

SELECT modelid,catid,id,thumb,title,url,inputtime FROM `xxyz_asia` . `yzm_all_content` WHERE (userid = '62' AND status = '1' AND issystem = '0') ORDER BY id DESC LIMIT 0,10; [ RunTime:0.007317s ]

SELECT guest_id FROM `xxyz_asia` . `yzm_member_guest` WHERE (space_id = '62') ORDER BY id DESC LIMIT 1; [ RunTime:0.000215s ]

SELECT guest_id,guest_name,guest_pic,inputtime FROM `xxyz_asia` . `yzm_member_guest` WHERE (space_id = '62') ORDER BY id DESC LIMIT 9; [ RunTime:0.000195s ]

SELECT id,title,url,inputtime,video,cover FROM `xxyz_asia` . `yzm_video` WHERE status=1 AND catid=706 AND userid=62 ORDER BY listorder ASC,id DESC LIMIT 12; [ RunTime:0.000284s ]

［其他信息］

WEB服务器：nginx/1.24.0

PHP版本：7.4.33

路由信息：模块( member )，控制器( myhome )，方法( init )，参数( userid=62 )

框架版本：2.9 查看新版