SHOW FULL COLUMNS FROM `cms_books` [ RunTime:0.000676s ]
SELECT * FROM `cms_books` WHERE `letter` = 'zhongguo-wenhuawenwu-lvyou-tongjinianjian' LIMIT 1 [ RunTime:0.001607s ]
SHOW FULL COLUMNS FROM `cms_years` [ RunTime:0.000480s ]
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` = '2010' LIMIT 1 [ RunTime:0.049724s ]
SHOW FULL COLUMNS FROM `cms_buy_log` [ RunTime:0.000643s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8031 AND `uid` = 0 LIMIT 1 [ RunTime:0.007172s ]
SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.000788s ]
SELECT * FROM `cms_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000363s ]
SHOW FULL COLUMNS FROM `cms_file_type` [ RunTime:0.000389s ]
SELECT * FROM `cms_file_type` [ RunTime:0.000199s ]
SHOW FULL COLUMNS FROM `cms_book_directory` [ RunTime:0.000406s ]
SELECT * FROM `cms_book_directory` WHERE `year_id` = 8031 LIMIT 1 [ RunTime:0.003099s ]
SELECT * FROM `cms_buy_log` WHERE `year_id` = 8031 [ RunTime:0.007153s ]
SELECT `year_id` FROM `cms_buy_log` WHERE `uid` IN (389,691,334) AND `year_id` <> 2010 [ RunTime:0.005180s ]
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 ('8023','8022','8024','8021','8026','8031','8034','8033','8036','8039','8029','8032','8035','8037','8038','8040','1669','8025','8027','8028','593','14863','8020','6947','13994','8778','2585','6922','11879','4881','9696','14015','10709','6013','6014','6015','6016','16995','10286','16740','13375','13382','13381','13380','13374','13373','13372','13371','13370','13369','13368','13367','13366','13365','13364','13363','16854','8540','8267','15484','15488','19211','14835','13843','1008','19871','4058','17866','19413','5804','8259','8260','8261','8262','8263','8264','8265','8266','19727','615','9085','2521','21034','7062','19171','3339','3333','3334','19236','20437','17477','6067','6066','6065','21138','6061','15492','15489','12224','16526','16525','11303','11302','11301','18523','1218','1217','15977','5594','5595','5596','16858','21151','16048','4530','4531','4532','4533','4534','21152','19252','1222','20277','20371','680','19201','3369','3368','18293','20498','19921','3119','1125','3366','5732','16860','20505','8629','13706','20279','4678','20778','18226','23059','19325','20360','12251','1581','2772','23015','20324','6923','6924','6925','19922','2496','2495','2519','16718','2497','2498','2499','2501','2502','23335','19147','14537','741','742','743','16720','1219','1220','1221','1226','18294','8777','8770','16989','2841','2842','2843','6607','8775','8774','8773','8772','22371','10132','13405','9456','10128','8764','16158','23881','18286','11704','8292','6177','15384','23997','13402','23520','23521','17550','14176','13623','23996','15947','20248','11825','11826','11827','11828','11829','11830','11831','11832','11833','11834','11835','11836','23463','23862','9730','5204','20813','5203','23995','8573','8572','8571','8570','8568','8567','13523','8569','9445','9444','9443','9442','9441','20177','10865','24166','23165','15109','19342','23518','8628','1084','20453','24262','20314','23448','16721','17801','17800','17799','17859','17858','17857','2092','2091','2090','2089','2088','2087','2081','2086','19328','13463','13462','19475','20516','12252','215','19180','9752','19971','13558','9438','2886','2894','23423','6634','24394','6691','8539','15125','15124','24416','19216','15423','19293','4024','4025','4026','19835','23086','11657','15759','15758','15757','15756','11659','6153','13927','14413','6143','6152','24694','19401','19327','24897','18342','6942','2774','13997','13998','14000','14001','14002','6941','20166','13564','2080','2082','2083','2084','2085','24910','12215','5985','10940','14672','14541','14184','18476','1229','1228','23288','744','745','746','19335','2778','2779','2787','2782','25888','1163','1164','1166','1165','15795','9439','9728','26287','1216','1223','1224','1227','15242','15232','26869','2789','2790','2792','19222','2795','2797','2798','2800','2801','2803','2804','2805','2785','2786','2794','2793','2806','24892','2775','27434','552','551','3335','26873','25463','25872','8524','19326','8851','27148','27147','26721','19237','19318','688','689','690','691','692','7433','28366','14182','11529','11530','11531','11532','11533','11534','11535','11536','11537','11538','1063','24280','26720','19972','16033','9201','9202','9203','9204','9205','9206','9207','9208','16576','26102','20837','15948','28287','28013','252','253','254','25256','24899','29016','8657','20631','6161','6157','29015','27983','543','542','541','540','539','25653','8636','8520','25060','24261','16398','14277','13189','9084','26540','29692','27146','16726','5986','5987','17005','6059','6060','10941','10942','25464','18947','6928','23058','28129','6023','6022','6021','6020','6019','6018','6017','5603','5609','12857','19214','9656','29214','16992','6024','5731','5733','5730','5729','20085','14077','26539','14066','14073','33584','1730','19948','887','859','950','977','21547','21548','21549','21550','21551','21552','21553','21554','9041','22123','17470','17471','17472','34168','34242','19780','15952','7885','7886','8521','8522','8523','24145','17002','5838','5839','5840','19501','2432','10227','24905','4272','4273','11174','8536','14074','14075','14076','31034','23417','13448','2393','2390','2391','2392','33758','3391','21545','34525','33166','6196','6197','6198','6199','25253','19390','16912','21544','21543','21542','21541','21540','16913','21539','16914','16915','16916','16917','16918','16919','16920','16921','16922','16988','27144','14186','14251','14252','14253','31055','31054','31053','31052','31051','20092','15023','12521','21515','13193','13194','8268','8269','15031','15122','35307','31935','29198','14185','14187','20684','20685','20686','20687','20688','20689','20690','5556','30756','16911','34882','5001','22842','35279','35362','34470','35178','24922','2546','35250','35249','36292','36457','33355','37708','34712','33297','35593','38043','1238','35278','24693','35156','35519','34361','35734','34857','20598','36478','42531','2503','43797','44310','35680','43151','43459','36813','42505','10371','10372','10373','10374','10375','10376','10377','36807','44308','42601','44120','30812','41228','21332','39886','35050','11116','34586','42973','34511','19235','10829','34636','43110','34455','35207','17465','17466','12314','12315','43279','11317','37679','44825','5841','5842','5843','42689','34239','8311','37217','19498','35184','24908','44531','12235','12236','12237','12238','11021') ORDER BY `y`.`read_count` DESC LIMIT 12 [ RunTime:0.005390s ]
SHOW FULL COLUMNS FROM `cms_books_tags` [ RunTime:0.000614s ]
SELECT * FROM `cms_books_tags` WHERE `aid` = 608 [ RunTime:0.001308s ]
SELECT * FROM `cms_books_tags` WHERE `tags_id` IN (12,113,21) [ RunTime:0.001350s ]
SHOW FULL COLUMNS FROM `cms_tags` [ RunTime:0.000479s ]
SELECT * FROM `cms_tags` WHERE `id` IN (12,113,21) [ RunTime:0.000355s ]
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.000483s ]
SHOW FULL COLUMNS FROM `cms_free_download_log` [ RunTime:0.000453s ]
SELECT * FROM `cms_free_download_log` WHERE `year_id` = 2010 AND `user_id` = 0 LIMIT 1 [ RunTime:0.000594s ]
