SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000738s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-wenhuawenwu-lvyou-tongjinianjian' LIMIT 1 [ RunTime:0.001478s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000548s ]
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` = '2011' LIMIT 1 [ RunTime:0.059269s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000707s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8030 AND `uid` = 0 LIMIT 1 [ RunTime:0.008776s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000705s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000392s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000210s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000382s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 8030 LIMIT 1 [ RunTime:0.003047s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8030 [ RunTime:0.007430s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` = 8450 AND `year_id` <> 2011 [ RunTime:0.005298s ]
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 ('8030','8025','8020','8023') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.000455s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000432s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 608 [ RunTime:0.001278s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (12,113,21) [ RunTime:0.001410s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000530s ]
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.000431s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000441s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2011 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000405s ]
