Slowly in MySQL query

[嘟嘟代言人]

use explain
{{{
SELECT
S.id,S.volume,S.book_id,S.book_cover_s,S.home_recomm,M.bookname_cn,S.book_introduce
FROM cartoon_sub_book_info S,cartoon_main_book_info M, （SELECT
book_id, count(1) AS volume FROM cartoon_sub_book_info GROUP BY
book_id) B WHERE S.book_id=M.book_id AND S.book_id=B.book_id AND
S.volume=B.volume AND S.book_id <> '123' AND S.book_id <> '123' ORDER
BY S.complete_date DESC LIMIT 0,21
}}}