[SQL语句]
SELECT data FROM `askend` . `askend_common_session` WHERE (sessionid = '207gob1a0n15cov9aqqr7rekjv') LIMIT 1; [ RunTime:0.000138s ]
SELECT a.*,b.nickname,b.avatar,c.name catname FROM `askend` . `askend_wenda_question` a INNER JOIN askend_member b on a.userid=b.userid INNER JOIN askend_wenda_category c on a.catid=c.catid WHERE (a.status=1 OR a.status=2) AND a.id=1 LIMIT 1; [ RunTime:0.000160s ]
SELECT a.*,b.userid,b.nickname,b.avatar FROM `askend` . `askend_wenda_answer` a LEFT JOIN askend_member b ON a.userid=b.userid WHERE a.questionid=1 AND a.status=2 LIMIT 1; [ RunTime:0.000122s ]
SELECT COUNT(*) AS total FROM `askend` . `askend_wenda_answer` a LEFT JOIN askend_member b ON a.userid=b.userid WHERE a.questionid=1 AND a.status>0; [ RunTime:0.000096s ]
SELECT a.*,b.userid,b.nickname,b.avatar FROM `askend` . `askend_wenda_answer` a LEFT JOIN askend_member b ON a.userid=b.userid WHERE a.questionid=1 AND a.status>0 ORDER BY a.id ASC LIMIT 0,10; [ RunTime:0.000102s ]
SELECT id,name,pinyin FROM `askend` . `askend_common_tag_content` a INNER JOIN askend_common_tag b ON a.tagid=b.id WHERE a.model=2 AND a.aid=1 ORDER BY b.id ASC LIMIT 5; [ RunTime:0.000210s ]
SELECT id,name,initial,pinyin,total FROM `askend` . `askend_common_tag` WHERE model=2 ORDER BY total DESC LIMIT 20; [ RunTime:0.000449s ]
[其他信息]
服务器信息:nginx/1.20.2
会话ID:207gob1a0n15cov9aqqr7rekjv
凯哥2024-06-20 10:48
来自问止网的热心网友
请大家给出个意见