SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000875s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-wenhuawenwu-lvyou-tongjinianjian' LIMIT 1 [ RunTime:0.001544s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000673s ]
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` = '2006' LIMIT 1 [ RunTime:0.062155s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000583s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8035 AND `uid` = 0 LIMIT 1 [ RunTime:0.008760s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000710s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000401s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000185s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000843s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 8035 LIMIT 1 [ RunTime:0.003124s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8035 [ RunTime:0.007853s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` = 389 AND `year_id` <> 2006 [ RunTime:0.005046s ]
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') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000441s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 608 [ RunTime:0.001277s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (12,113,21) [ RunTime:0.001635s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000467s ]
SELECT * FROM `cms_tags` WHERE `id` IN (12,113,21) [ RunTime:0.000285s ]
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.000384s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.010703s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2006 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000549s ]
