SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000614s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-yuye-tongjinianjian' LIMIT 1 [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000601s ]
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` = '2009' LIMIT 1 [ RunTime:0.050956s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000611s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 99 AND `uid` = 0 LIMIT 1 [ RunTime:0.007552s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000669s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000384s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000419s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000180s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000352s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 99 LIMIT 1 [ RunTime:0.002907s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 99 [ RunTime:0.007310s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` IN (1522,1630,2285,2768,3187,3636,4216,6890) AND `year_id` <> 2009 [ RunTime:0.005327s ]
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','12401','9022','24892','29214','19317','38286','12265','12266','12264','34238','34237','38256','12262','12263','8277','8276','8275','8274','8273','8272','8271','8270','34206','34187','34188','19512','4402','4401','4400','36812','36814','4398','4396','34113','35099','12261','12260','12259','12258','12257','12256','12255','12254','34470','36262','33470','33471','7510','32566','23193','35680','12267','12268','12269','15748','21308','33689','33678','33679','33680','33681','33682','33683','33684','33685','33686','33687','33688','24903','370','29937','19780','19059','23015','21009','37178','20369','8629','8630','39067','20310','7919','10549','10576','14386','14387','39373','35674','14385','14390','35675','28586','35269','32453','15000','36811','39350','24906','36092','8460','21191','10461','10460','10459','34120','10458','10457','10456','10451','34858','38634','11842','39127','15749','15750','15760','38201','12332','35052','16730','16732','16733','16734','34242','8576','37214','10498','10497','10496','10495','10494','5898','38317','39496','38747','37671','35585','36633','38697','39792','24895','34160','33144','11659','11545','15757','14409','10966','14081','14073','14077','14066','31049','14067','31047','14082','36736','36738','21155','25158','15389','38105','38109','8127','6200','33206','38472','38254','12010','38284','14413','35586','34952','36602','38807','8627','8626','8625','8623','12277','12276','8632','10376','10375','10374','11782','34593','34594','34595','34632','34627','20683','8235','17895','8234','8232','16669','10154','10061','31048','33988','31045','32708','35616','17705','36371','16527','9882','30401','21052','13121','13122','34530','28220','11481','11482','34239','19714','8335','8336','8337','34782','36090','25277','17668','9837','9838','35218','35236','35244','9767','9768','9769','34895','19099','19100','19101','35255','24905','7788','4268','4269','34458','20115','13942','13943','13944','37988','34852','37673','34900','35735','35231','36366','35803','38636','11305','14245','33584','30808','16546','7514','7512','38851','33981','33982','33983','12242','38118','34868','8581','8580','8579','8578','18552','11441','38202','38203','39898','35421','34636','35207','19328','17464','15751','14074','14075','14076','31034','28976','7511','12172','12173','12174','12175','12176','12177','15582','31060','31059','33603','33931','10036','10035','33207','10856','9770','9771','28496','28495','28494','38038','10396','10397','39950','40155','10714','10135','10134','10133','20441','36782','24415','36367','40170','40169','40168','7875','17818','17817','26458','16013','14238','15563','21160','21158','21159','15969','15970','15971','15972','40113','17791','17792','10039','10038','10037','10050','10048','34141','34288','34287','34286','34285','36737','36739','36740','17561','17560','34645','34646','21156','11978','5862','16644','16645','12178','12179','12180','12181','12182','12233','12232','36478','37179','36288','34536','31030','31031','31032','31033','11227','9841','13947','13125','10344','5900','41177','9871','9870','11998','38378','38379','38406','34055','38383','33999','37114','21129','5984','21128','21130','14247','14246','14248','34537','10343','16633','34874','40171','16581','16580','16579','16578','16583','24976','34855','12335','12334','14088','33989','33990','34117','34572','16610','11421','17699','15475','8184','15575','15574','15578','41221','33582','17805','33703','17806','17807','41353','26536','10506','39789','12296','12106','6431','6433','6442','6443','19804','11152','38561','41220','13946','12416','14192','33217','15852','15853','37177','12592','40651','37672','4395','10340','10909','10910','10911','38318','41449','15564','15565','15566','34566','34567','34569','34570','34571','34573','34574','34568','38638','35520','24166','35519','5501','15568','39951','33202','33203','12415','12414','41246','42532','42136','28126','11426','11425','11424','11423','11422','11420','11419','11417','42134','41976','42504','42846','42506','41384','42531','42753','42539','4271','4270','4273','4274','4275','4276','4277','8339','36636','34590','42052','43105','41501','43107','42924','42704','42505','43100','43007','42481','42983','42994','43120','43111','42971','42628','42045','43106','42749','34812','43102','41956','43109','42973','43121','43099','42970','43110','42036','42599','42596','43108','42593','42803','36970','42785','42685','42881','42482','41680','34501','42664','19170','19169','19168','43023','41176','43210','43211','5526','43383','43387','43434','43389','43138','43433','43212','11118','11119','11120','11121','11122','11123','11124','11125','18259','11126','11127','11128','43463','43587','43462','43586','5503','20012','42667','43716','5952','43137','43894','43797','42847','43152','43189','43435','42693','43430','43913','43906','10721','43499','43134','43269','43691','43182','43216','43904','43830','43918','43151','42943','43371','43481','43437','43564','43798','43218','43847','43413','43169','43743','13937','43279','43431','43367','43659','43700','43698','43418','44040','43565','44039','43274','44122','44106','42926','44110','43183','44099','41403','43136','44133','12042','12044','12045','44140','8267','44091','9792','43185','15116','20681','34618','43349','44042','44301','44343','44332','44316','44331','44030','44315','44092','43038','44361','44388','42042','12303','11568','8937','9124','9847','44341','34125','44310','44308','43411','44546','9844','43920','43896','44300','44531','44336','20694','9196','4849','44517','44783','44585','44530','44518','44768','44516','44529','20697','20698','38115','44460','38464','38466','38465','38467','15759','44108','11997','44658','44142','44751','44752','44536','11159','44769','44342','44825','44817','37678','44824','44522','44521','44488','44523','44121','44962','44606','44674','44495','44309','44328','44461','44767','44672','44753','44830','44607','44090','43272','35424','44334','44525','44547','44610','7989','4848','44141','44490','44836','44673','44675','44089','44511','44094','44958','44534','44109','44302','44815','44544','44664','17522','17521','17520','44543','44494','44136','44137','44608','19201','15483') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.004883s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000917s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 3 [ RunTime:0.002307s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (23,142) [ RunTime:0.002251s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000606s ]
SELECT * FROM `cms_tags` WHERE `id` IN (23,142) [ RunTime:0.000430s ]
SELECT `id`,`name`,`letter` FROM `cms_books` WHERE `id` IN (1250,986,588,319,2307,2389,159,331,300) LIMIT 20 [ RunTime:0.000390s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000533s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2009 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000550s ]
