Important Performance Problem

SELECT a.*, t.mesid, t.message AS messagetext, m.mesid AS attachmesid, (f.thread>0) AS myfavorite, u.avatar, MAX(b.time) AS lastpost FROM jos_fb_messages AS a JOIN jos_fb_messages_text AS t ON a.thread = t.mesid LEFT JOIN jos_fb_messages AS b ON b.thread = a.thread LEFT JOIN jos_fb_attachments AS m ON m.mesid = a.id LEFT JOIN jos_fb_favorites AS f ON f.thread = a.id && f.userid='331' LEFT JOIN jos_comprofiler AS u ON u.user_id = a.userid WHERE a.parent = '0' AND a.catid = '8' AND a.hold = '0' GROUP BY id ORDER BY ordering DESC, lastpost DESC LIMIT 0, 20;

Status Dauer starting 0.000017 checking query cache for query 0.000139 Opening tables 0.000025 System lock 0.000008 Table lock 0.000061 init 0.000055 optimizing 0.000021 statistics 0.000138 preparing 0.000030 Creating tmp table 0.000259 executing 0.000004 [b]Copying to tmp table 54.548688[/b] Sorting result 0.001145 Sending data 0.000623 end 0.000004 removing tmp table 0.000517 end 0.000007 query end 0.000009 freeing items 0.000058 storing result in query cache 0.000011 logging slow query 0.000002 logging slow query 0.000058 cleaning up 0.000029