如何优化MySQL中查询慢的SQL语句啊？ 50

#Time:15091414:07:27#User@Host:bjcongnadaonacom[bjcongnadaonacom]@localhost[::1]Id:10... # Time: 150914 14:07:27
# User@Host: bjcongnadaonacom[bjcongnadaonacom] @ localhost [::1] Id: 10916
# Query_time: 3.119261 Lock_time: 0.000000 Rows_sent: 21 Rows_examined: 468600
SET timestamp=1442210847;
SELECT id FROM `bj_arctiny` arc WHERE arc.arcrank > -1 AND ( arc.typeid = '55' OR CONCAT(',', arc.typeid2, ',') like '%,55,%' ) ORDER BY arc.sortrank desc LIMIT 0,30;

# Time: 150914 11:57:42
# User@Host: bjcongnadaonacom[bjcongnadaonacom] @ localhost [::1] Id: 10591
# Query_time: 2.220561 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 312589
SET timestamp=1442203062;
SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,
tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath

FROM `bj_archives` arc LEFT JOIN `bj_arctype` tp on arc.typeid=tp.id

WHERE FIND_IN_SET('p', arc.flag)>0 And arc.typeid IN (35) And arc.arcrank > -1 ORDER BY arc.sortrank desc LIMIT 0,1;

我用的是dedecms系统，有五十万数据，整站动态，应该怎么优化啊？可以加下qq吗？
请 1
加 5
右 0
侧 1
我 6
的 3
在 0
线 1
qq 5
qq 0 展开

 我来答