SELECT id, classid, onclick, newspath, keyboard, userid, username, ztid, checked, istop, truetime, ismember, userfen, isgood, titlefont, titleurl, filename, groupid, plnum, firsttitle, isqf, totaldown, closepl, lastdotime, title, newstime, leixin, web, daxiao, xianshi, yeshu
FROM 123456
WHERE classid
IN ( 5, 6, 7, 8, 10, 11, 12, 13, 15, 17, 18, 19, 21, 22, 23, 24, 31, 32, 33, 34, 36, 37, 38, 39, 40, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 106, 107, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 123, 124, 125, 190 )
ORDER BY id DESC
LIMIT 0 , 62这个的执行时间是1.7SSELECT id, classid, onclick, newspath, keyboard, userid, username, ztid, checked, istop, truetime, ismember, userfen, isgood, titlefont, titleurl, filename, groupid, plnum, firsttitle, isqf, totaldown, closepl, lastdotime, title, newstime, leixin, web, daxiao, xianshi, yeshu
FROM 123456
WHERE classid
IN ( 5, 6, 7, 8, 10, 11, 12, 13, 15, 17, 18, 19, 21, 22, 23, 24, 31, 32, 33, 34, 36, 37, 38, 39, 40, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 106, 107, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 123, 124, 125, 190 )
LIMIT 0 , 62这个的执行时间是0.021S关键是第二个方法不能进行降序,而我又必须使用降序大家优化一下,我头都大了
FROM 123456
WHERE classid
IN ( 5, 6, 7, 8, 10, 11, 12, 13, 15, 17, 18, 19, 21, 22, 23, 24, 31, 32, 33, 34, 36, 37, 38, 39, 40, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 106, 107, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 123, 124, 125, 190 )
ORDER BY id DESC
LIMIT 0 , 62这个的执行时间是1.7SSELECT id, classid, onclick, newspath, keyboard, userid, username, ztid, checked, istop, truetime, ismember, userfen, isgood, titlefont, titleurl, filename, groupid, plnum, firsttitle, isqf, totaldown, closepl, lastdotime, title, newstime, leixin, web, daxiao, xianshi, yeshu
FROM 123456
WHERE classid
IN ( 5, 6, 7, 8, 10, 11, 12, 13, 15, 17, 18, 19, 21, 22, 23, 24, 31, 32, 33, 34, 36, 37, 38, 39, 40, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 106, 107, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 123, 124, 125, 190 )
LIMIT 0 , 62这个的执行时间是0.021S关键是第二个方法不能进行降序,而我又必须使用降序大家优化一下,我头都大了
贴一下你的索引情况以供分析。
PRIMARY PRIMARY 611744 id
checked INDEX 1 checked
newstime INDEX 152936 newstime
truetime INDEX 152936 truetime
classid INDEX 164 classid
ttid INDEX 1 ttid
title INDEX 611744 title
leixin INDEX 18 leixin
web INDEX 2 web
daxiao INDEX 9268 daxiao
onclick INDEX 941 onclick
newspath INDEX 3 newspath
userid INDEX 3 userid
username INDEX 3 username
keyboard INDEX 611744 keyboard
FROM 123456 force index(primary)
WHERE classid
IN ( 5, 6, 7, 8, 10, 11, 12, 13, 15, 17, 18, 19, 21, 22, 23, 24, 31, 32, 33, 34, 36, 37, 38, 39, 40, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 106, 107, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 123, 124, 125, 190 )
ORDER BY id DESC
LIMIT 0 , 62