[SQL语句]
SELECT data FROM `askend` . `askend_common_session` WHERE (sessionid = '2avs70p4fl0iuqeb2inbmh6mf8') LIMIT 1; [ RunTime:0.000119s ]
SELECT * FROM `askend` . `askend_common_search_filterword` ORDER BY id; [ RunTime:0.000076s ]
SELECT id FROM `askend` . `askend_common_search_keyword` WHERE (name = '科技活动周') LIMIT 1; [ RunTime:0.000104s ]
UPDATE `askend` . `askend_common_search_keyword` SET `num` = `num`+1 WHERE (id = '1407'); [ RunTime:0.002224s ]
SELECT COUNT(*) AS total FROM `askend` . `askend_wenku_content` WHERE status=1 and convert_status=3 AND catid IN (5,6,8,3) AND CONCAT(`title`,`keyword`,`description`) LIKE "%科技%活动周%" AND price>0; [ RunTime:0.000323s ]
SELECT contentid,catid,title,url,pic,isvip,istui,vipfree,description,updatetime,views,filesize,download,keyword,fileext,price,pagenum FROM `askend` . `askend_wenku_content` WHERE status=1 and convert_status=3 AND catid IN (5,6,8,3) AND CONCAT(`title`,`keyword`,`description`) LIKE "%科技%活动周%" AND price>0 ORDER BY views DESC LIMIT 0,10; [ RunTime:0.000536s ]
SELECT COUNT(*) AS total FROM `askend` . `askend_wenku_content` WHERE status=1 and convert_status=3 AND catid IN (5,6,8,3) AND CONCAT(`title`,`keyword`,`description`) LIKE "%科技%活动周%" AND price>0; [ RunTime:0.000268s ]
SELECT contentid,catid,title,url,pic,isvip,istui,vipfree,description,updatetime,views,filesize,download,keyword,fileext,price,pagenum FROM `askend` . `askend_wenku_content` WHERE status=1 and convert_status=3 AND catid IN (5,6,8,3) AND CONCAT(`title`,`keyword`,`description`) LIKE "%科技%活动周%" AND price>0 ORDER BY views DESC LIMIT 0,40; [ RunTime:0.000323s ]
[其他信息]
服务器信息:nginx/1.20.2
会话ID:2avs70p4fl0iuqeb2inbmh6mf8