SHOW FULL COLUMNS FROM `tp_download_log` [ RunTime:0.000784s ]
SELECT book_id, COUNT(*) as download_count, tp_book.title, tp_book.cate_id, tp_book.id, tp_book.uuid, tp_book.thumb FROM `tp_download_log` LEFT JOIN `tp_book` ON `tp_book`.`id`=`tp_download_log`.`book_id` WHERE `timestamp` > 1767149464 AND `tp_book`.`status` = '1' GROUP BY `book_id` ORDER BY `download_count` DESC LIMIT 12 [ RunTime:0.000755s ]
