SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000658s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-wenhuawenwu-lvyou-tongjinianjian' LIMIT 1 [ RunTime:0.001455s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.001134s ]
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` = '2001' LIMIT 1 [ RunTime:0.054337s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000640s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8040 AND `uid` = 0 LIMIT 1 [ RunTime:0.007668s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000748s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000477s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000260s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000480s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 8040 LIMIT 1 [ RunTime:0.003275s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8040 [ RunTime:0.008245s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` = 389 AND `year_id` <> 2001 [ RunTime:0.005331s ]
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.000712s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000547s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 608 [ RunTime:0.001529s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (12,113,21) [ RunTime:0.001654s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000486s ]
SELECT * FROM `cms_tags` WHERE `id` IN (12,113,21) [ RunTime:0.000244s ]
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.000401s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000486s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2001 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000357s ]
