SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000680s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-yuye-tongjinianjian' LIMIT 1 [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000936s ]
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` = '2003' LIMIT 1 [ RunTime:0.066052s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000691s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 12381 AND `uid` = 0 LIMIT 1 [ RunTime:0.009704s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000740s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000398s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.001086s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000240s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000695s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 12381 LIMIT 1 [ RunTime:0.003779s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 12381 [ RunTime:0.010145s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` IN (1522,3636,3989,9576) AND `year_id` <> 2003 [ RunTime:0.008634s ]
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','629','1','3','4','5','91','92','93','94','95','96','97','98','99','100','102','101','103','104','12381','12382','12383','12384','12385','12386','12387','12388','12389','12390','19317','29214','34456','7666','35260','26102','26101','496','1148','43419','242','248','249','250','251','243','43376','32618','20498','210','211','6539','35518','20279','44041','7062','39794','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','43210','45267','43383') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.001644s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000614s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 3 [ RunTime:0.002259s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (23,142) [ RunTime:0.002612s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000558s ]
SELECT * FROM `cms_tags` WHERE `id` IN (23,142) [ RunTime:0.000246s ]
SELECT `id`,`name`,`letter` FROM `cms_books` WHERE `id` IN (1250,986,588,319,2307,2389,159,331,300) LIMIT 20 [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000387s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2003 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000459s ]
