mysql优化sql查询语句_如何优化MySQL中查询慢的SQL语句啊？

#Time:15091414:07:27#User@Host:bjcongnadaonacom[bjcongnadaonacom]@localhost[::1]Id:10916#Query_time:3.119261Lock_time:0.000000Rows_sent:21Rows_examined:468600SETtimestamp...

# 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

展开