[ DB ] CONNECT:[ UseTime:0.001123s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002663s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '1fb69e04e64e95a1cfb05c835c533db4' LIMIT 1 [ RunTime:0.000919s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5775,`search_last_hit_time`=1773782738 WHERE `search_key` = '1fb69e04e64e95a1cfb05c835c533db4' [ RunTime:0.007868s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.003956s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('U') AND `type_id` IN (21) AND ( vod_id IN (60,132,165,210,213,272,292,306,351,387,513,534,606,834,894,906,1088,1284,1295,1368,1420,1426,1776,1781,1789,1827,1830,1900,1940,1942,1953,1983,1984,1987,1991,2008,2013,2016,2076,2122,2123,2124,2126,2127,2128,2176,2255,2308,2326,2418,2468,2471,2549,2598,2860,2870,2880,2949,3045,3089,3173,3174,3175,3212,3271,3410,3486,3747,3773,3864,4014,4073,4283,4290,4291,4416,4444,4483,4510,4511,4541,4789,4844,4919,4920,4930,5042,5131,5484,12004,12018,12113,12624,12654,12753,12774,12798,12927,12988,13233,13253,13262,13331,13457,13643,13700,13725,13752,13764,13795,13834,13909,13925,13953,13993,13996,13998,14020,14024,14171,14203,14263,14299,14334,14354,14403,14452,14580,16003,16196,16302,16349,16418,16488,16497,16604,16793,16795,17285,18111,18438,18439,18523,18524,18685,18697,18711,18744,19058,19060,19082,19085,19169,19524,19529,19558,19571,19573,19646,19647,19840,19841,19922,19974) ) LIMIT 1 [ RunTime:0.001668s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('U') AND `type_id` IN (21) AND ( vod_id IN (60,132,165,210,213,272,292,306,351,387,513,534,606,834,894,906,1088,1284,1295,1368,1420,1426,1776,1781,1789,1827,1830,1900,1940,1942,1953,1983,1984,1987,1991,2008,2013,2016,2076,2122,2123,2124,2126,2127,2128,2176,2255,2308,2326,2418,2468,2471,2549,2598,2860,2870,2880,2949,3045,3089,3173,3174,3175,3212,3271,3410,3486,3747,3773,3864,4014,4073,4283,4290,4291,4416,4444,4483,4510,4511,4541,4789,4844,4919,4920,4930,5042,5131,5484,12004,12018,12113,12624,12654,12753,12774,12798,12927,12988,13233,13253,13262,13331,13457,13643,13700,13725,13752,13764,13795,13834,13909,13925,13953,13993,13996,13998,14020,14024,14171,14203,14263,14299,14334,14354,14403,14452,14580,16003,16196,16302,16349,16418,16488,16497,16604,16793,16795,17285,18111,18438,18439,18523,18524,18685,18697,18711,18744,19058,19060,19082,19085,19169,19524,19529,19558,19571,19573,19646,19647,19840,19841,19922,19974) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.002073s ]
