SQL多表查询语句,速度奇慢无比

select 
novel_booklist.ID AS aID,
 novel_chapter.ID AS bID,
 novel_category.ID AS cID,
 novel_booklist.Author,
 novel_booklist.Category,
 novel_chapter.BookName,
 novel_chapter.ChapterName,
 novel_chapter.ID,
 novel_chapter.UpTime
FROM
novel_chapter,
novel_booklist,
novel_category
WHERE
novel_chapter.BookName = novel_booklist.BookName
AND novel_booklist.Category = novel_category.CategoryName
ORDER BY
novel_chapter.UpTime DESC
LIMIT 13

这速度太慢了,也不能分开写,因为分开写就要select 100次以上,应该如何优化,各位有何良策

贴出建表语句，特别是索引