SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000775s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-wenhuawenwu-lvyou-tongjinianjian' LIMIT 1 [ RunTime:0.001469s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000533s ]
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` = '2014' LIMIT 1 [ RunTime:0.053777s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000502s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8027 AND `uid` = 0 LIMIT 1 [ RunTime:0.007971s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000643s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000597s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000386s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000182s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000481s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 8027 LIMIT 1 [ RunTime:0.003455s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8027 [ RunTime:0.008648s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` IN (389,442,459,1944,5125) AND `year_id` <> 2014 [ RunTime:0.006059s ]
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','667','664','306','34709','659','666','665','663','662','661','660','35154','303','20277','43434','43383','43211','42532','44620') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.000818s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000602s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 608 [ RunTime:0.001542s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (12,113,21) [ RunTime:0.001566s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000563s ]
SELECT * FROM `cms_tags` WHERE `id` IN (12,113,21) [ RunTime:0.000252s ]
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.000397s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000557s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2014 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000410s ]
