[SQL语句]
SELECT catid,catname,arrchildid,pclink,target FROM `xxyz_asia` . `yzm_category` WHERE siteid = 0 AND `display`=1 AND parentid=0 ORDER BY listorder ASC LIMIT 20; [ RunTime:0.000575s ]
SELECT id,catid,title,nickname,userid,username,thumb,flag,url,color,click,inputtime,jiage,phone,shijan,is_hidden FROM `xxyz_asia` . `yzm_article` WHERE status=1 AND FIND_IN_SET('1',flag) ORDER BY listorder ASC,id DESC LIMIT 8; [ RunTime:0.002416s ]
SELECT modelid,catid,id FROM `xxyz_asia` . `yzm_all_content` WHERE modelid<>10 ORDER BY allid DESC LIMIT 10; [ RunTime:0.006637s ]
SELECT title,color,url,thumb,phone,nickname,userid,click,shijan,jiage,is_hidden FROM `xxyz_asia` . `yzm_putong` WHERE (id = '6' AND status = '1') LIMIT 1; [ RunTime:0.000975s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '1') LIMIT 1; [ RunTime:0.000142s ]
SELECT title,color,url,thumb,phone,nickname,userid,click,shijan,jiage,is_hidden FROM `xxyz_asia` . `yzm_putong` WHERE (id = '5' AND status = '1') LIMIT 1; [ RunTime:0.000883s ]
select userid,point,username,groupid from yzm_member where groupid=4 and status=1 order by userid desc LIMIT 8; [ RunTime:0.001725s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '58') LIMIT 1; [ RunTime:0.000252s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '58') LIMIT 1; [ RunTime:0.000863s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '58') LIMIT 1; [ RunTime:0.000145s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '57') LIMIT 1; [ RunTime:0.000195s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '57') LIMIT 1; [ RunTime:0.000162s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '57') LIMIT 1; [ RunTime:0.000163s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '35') LIMIT 1; [ RunTime:0.000255s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '35') LIMIT 1; [ RunTime:0.000181s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '35') LIMIT 1; [ RunTime:0.000142s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '30') LIMIT 1; [ RunTime:0.000226s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '30') LIMIT 1; [ RunTime:0.000162s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '30') LIMIT 1; [ RunTime:0.000157s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '29') LIMIT 1; [ RunTime:0.000165s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '29') LIMIT 1; [ RunTime:0.000163s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '29') LIMIT 1; [ RunTime:0.000141s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '28') LIMIT 1; [ RunTime:0.000163s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '28') LIMIT 1; [ RunTime:0.000162s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '28') LIMIT 1; [ RunTime:0.000131s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '27') LIMIT 1; [ RunTime:0.000187s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '27') LIMIT 1; [ RunTime:0.000161s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '27') LIMIT 1; [ RunTime:0.000179s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '26') LIMIT 1; [ RunTime:0.000164s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '26') LIMIT 1; [ RunTime:0.000160s ]
SELECT userpic FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '26') LIMIT 1; [ RunTime:0.000140s ]
SELECT id,title,url,thumb,catid,inputtime,nickname,username,userid,video,cover FROM `xxyz_asia` . `yzm_video` WHERE status=1 AND catid=706 ORDER BY RAND() LIMIT 8; [ RunTime:0.001074s ]
SELECT url,logo,name FROM `xxyz_asia` . `yzm_link` WHERE siteid = 0 AND status = 1 ORDER BY listorder ASC, id DESC LIMIT 20; [ RunTime:0.000182s ]
[其他信息]
WEB服务器:nginx/1.24.0
PHP版本:7.4.33
路由信息:模块( index ),控制器( index ),方法( init ),参数( 无 )