[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.000573s ]
SELECT COUNT(*) AS total FROM `xxyz_asia` . `yzm_article` WHERE status=1 AND catid=236; [ RunTime:0.000182s ]
SELECT id,catid,title,nickname,userid,jiage,username,thumb,url,flag,color,click,description,updatetime,area,jiage,phone,shijan,is_hidden FROM `xxyz_asia` . `yzm_article` WHERE status=1 AND catid=236 ORDER BY listorder ASC,id DESC LIMIT 0,3; [ RunTime:0.000253s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '77') LIMIT 1; [ RunTime:0.000153s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '77') LIMIT 1; [ RunTime:0.000143s ]
SELECT username,regdate,lastdate,lastip,loginnum,email,groupid,amount,experience,point,status,vip,overduedate,email_status FROM `xxyz_asia` . `yzm_member` WHERE (userid = '77') LIMIT 1; [ RunTime:0.000133s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '77') 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 = '77') LIMIT 1; [ RunTime:0.000129s ]
SELECT * FROM `xxyz_asia` . `yzm_member_detail` WHERE (userid = '77') LIMIT 1; [ RunTime:0.000133s ]
SELECT id,catid,title,inputtime,color FROM `xxyz_asia` . `yzm_article` WHERE status=1 AND catid=236 ORDER BY `click` DESC LIMIT 10; [ RunTime:0.000178s ]
[其他信息]
WEB服务器:nginx/1.24.0
PHP版本:7.4.33
路由信息:模块( mobile ),控制器( index ),方法( lists ),参数( catid=236&page=1&AJ=Db6JMlsAfegGt6V6kCB%2BC9P7ADzkGINfAN6IeegQ8rgA78AKsGiLH4Bdh6KiDQFgiTuERqJoxAmMUtAN5KuMStAFYIt7gHoAYREvcClCC0PrRa0e2lNq6ZMHcuNeYA5haPVGAAGkNoLSTeAjB%2Bc92jERuamJEnSA0ngPDE9ALk3C6A8Nj2ADxqtcjEvPnJCmDp8xCEBcAinusOkzFrAB7xEMQjgIi4G6IEoBh16jNBdMikntjk4l0J4Ai8tky4vhRjiCfgyxrJtE8RSlnwLkg686EglDGVB82h1KkR317rgvjNxpMzwOQV%2BAM8QnIhRC5g4gAAAABJRU5ErkJggg%3D%3D )