SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000684s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-yuye-tongjinianjian' LIMIT 1 [ RunTime:0.000459s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000606s ]
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` = '2019' LIMIT 1 [ RunTime:0.061734s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000808s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 4 AND `uid` = 0 LIMIT 1 [ RunTime:0.007503s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.001727s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000582s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000468s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000226s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000541s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 4 LIMIT 1 [ RunTime:0.003575s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 4 [ RunTime:0.010056s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` IN (1315,1369,1394,965,1522,1707,1884,1897,2142,2285,2361,2768,3636,3274,3187,5079,1196,7354,7891,7293,7532,6842,8042,9576,9876,9476) AND `year_id` <> 2019 [ RunTime:0.007915s ]
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 ('19252','19327','629','1','3','4','91','5','92','93','94','95','96','97','98','99','100','102','101','103','104','12381','12382','12383','12384','12385','12386','12387','12388','12389','12390','9022','24892','29214','19317','30739','32615','34228','34531','39794','2522','2523','2524','2525','2526','2527','34158','36262','34882','38040','35260','26102','26101','496','1148','43419','242','248','249','250','251','243','43376','32618','20498','210','211','6539','35518','20279','44041','7062','6100','35594','44460','44300','44530','36086','44585','34471','35331','23057','16744','2190','44524','2192','2193','2194','2195','2196','2191','1672','16811','1689','1690','1691','1693','1694','1695','1696','1697','1698','1699','1700','1701','1686','1685','1682','1679','1678','1677','1675','1692','20315','34476','44525','4848','19316','36410','43135','34508','2163','2164','2165','2166','2167','2168','2169','19893','2170','2171','2172','2173','2174','2175','2176','2177','2178','2179','2180','2181','2182','2183','2184','2185','2186','2187','2188','2189','16903','19835','44546','43433','33411','45267','43210','333','43383','8025','8024','8023','8022','8021','8020','24881','24882','37044') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.001560s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.001207s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 3 [ RunTime:0.001955s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (23,142) [ RunTime:0.002243s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000742s ]
SELECT * FROM `cms_tags` WHERE `id` IN (23,142) [ RunTime:0.000355s ]
SELECT `id`,`name`,`letter` FROM `cms_books` WHERE `id` IN (1250,986,588,319,2307,2389,159,331,300) LIMIT 20 [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000637s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2019 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000650s ]
