SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000585s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-yuye-tongjinianjian' LIMIT 1 [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000486s ]
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` = 3 AND `year` = '1999' LIMIT 1 [ RunTime:0.051406s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000600s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 12385 AND `uid` = 0 LIMIT 1 [ RunTime:0.007447s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000718s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000427s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000467s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000275s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000372s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 12385 LIMIT 1 [ RunTime:0.003247s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 12385 [ RunTime:0.007279s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` IN (933,1522,1242) AND `year_id` <> 1999 [ RunTime:0.005190s ]
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 ('12405','12404','12403','12402','12401','12400','12399','12398','12397','12396','12395','12394','12393','12392','12391','12390','12389','12388','12387','12386','12385','12384','12383','12382','1','19252','101','629','3','4','5','91','92','93','94','95','96','97','98','99','100','102','103','104','12381','29214','39794') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.000932s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000675s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 3 [ RunTime:0.001766s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (23,142) [ RunTime:0.001918s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000546s ]
SELECT * FROM `cms_tags` WHERE `id` IN (23,142) [ RunTime:0.000324s ]
SELECT `id`,`name`,`letter` FROM `cms_books` WHERE `id` IN (1250,986,588,319,2307,2389,159,331,300) LIMIT 20 [ RunTime:0.000631s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000409s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 1999 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000417s ]
