SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000722s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-wenhuawenwu-lvyou-tongjinianjian' LIMIT 1 [ RunTime:0.001456s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000496s ]
SELECT `y`.*,`b`.`name`,`b`.`desc`,`b`.`letter`,b.id book_id,`b`.`type`,`b`.`province_code`,`r`.`region_name`,s.region_name sname,`c`.`pic_url` FROM `cms_years` `y` INNER JOIN `cms_books` `b` ON `b`.`id`=`y`.`book_id` LEFT JOIN `cms_region` `s` ON `s`.`region_code`=`b`.`province_code` LEFT JOIN `cms_region` `r` ON `r`.`region_code`=`b`.`city_code` LEFT JOIN `cms_year_cover` `c` ON `y`.`id`=`c`.`year_id` WHERE `book_id` = 608 AND `year` = '2009' LIMIT 1 [ RunTime:0.061043s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000793s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8032 AND `uid` = 0 LIMIT 1 [ RunTime:0.007501s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000665s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000460s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000686s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000554s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 8032 LIMIT 1 [ RunTime:0.003152s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8032 [ RunTime:0.007485s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` IN (389,334) AND `year_id` <> 2009 [ RunTime:0.005140s ]
SELECT `y`.`year`,y.id as yid,`y`.`history_name`,`bo`.`name`,`bo`.`letter` FROM `cms_years` `y` INNER JOIN `cms_books` `bo` ON `bo`.`id`=`y`.`book_id` WHERE `y`.`id` IN ('8023','8022','8024','8021','8026','8031','8034','8033','8036','8039','8029','8032','8035','8037','8038','8040','1669','8025','8027','8028','593','14863','8020','6947','13994','8778','11879','13843','8259','8260','8261','8262','8263','8264','8265','8266','615','9085','7062','16048','4530','4531','4532','4533','4534','2496','2495','2519','16718','2497','2498','2499','2501','2502','20314','19328','19971','27148','27147','8636','8520','16398','6020','6024','6023','6022','6021','5731','5733','5732','5730','5729','26102','23521','20085','2546','35362','35250','35249','1216','1217','1218','1219','1227','24394','36292','36457','33355','37708','34712','33297','35593','38043','1238','35278','24694','24693','35156','34882','1220','35519','34361','35734','34857','20598','36478','42531','2503','43797','44310','35680','43151','43459','36813','42505','10371','10372','10373','10374','10375','10376','10377','36807','44308','42601','44120','16860','30812','41228','21332','39886','35050','11116','34586','42973','34511','19235','10829','34636','43110','34455','35207','17465','17466','12314','12315','43279','11317','37679','44825','5839','5841','5842','5843','42689','34239','8311','37217','19498','35184','24908','44531','12235','12236','12237','12238','11021') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.001256s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000475s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 608 [ RunTime:0.001492s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (12,113,21) [ RunTime:0.001626s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000423s ]
SELECT * FROM `cms_tags` WHERE `id` IN (12,113,21) [ RunTime:0.000225s ]
SELECT `id`,`name`,`letter` FROM `cms_books` WHERE `id` IN (2,18,230,424,530,563,565,828,929,561,1047,1138,1196,1199,1207,1210,1225,1233,1272,1287,1288,1304,1409,981,1440,1461,564,893,1673,1758,1753,1812,1921,2002,2072,2074,422,2124,1408,540,2251,1175,4,41,312,2367,2388,2646,267,10,313,245) LIMIT 20 [ RunTime:0.000427s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000406s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2009 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000356s ]
