[ DB ] CONNECT:[ UseTime:0.001110s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002460s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = 'ca10fedb2f1c4d2b100512887c5a7ab0' LIMIT 1 [ RunTime:0.000833s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5992,`search_last_hit_time`=1773782527 WHERE `search_key` = 'ca10fedb2f1c4d2b100512887c5a7ab0' [ RunTime:0.007600s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.003929s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('S') AND `type_id` IN (22) AND ( vod_id IN (143,173,288,289,398,586,651,690,699,702,703,896,998,1002,1048,1164,1165,1166,1270,1283,1329,1331,1370,1398,1406,1448,1453,1492,1528,1529,1576,1577,1578,1579,1602,1615,1637,1646,1668,1677,1726,1776,1803,1816,1849,1862,1864,1865,1872,1907,1974,2018,2041,2048,2049,2054,2065,2144,2191,2225,2236,2251,2278,2357,2411,2476,2483,2522,2571,2666,2667,2696,2732,2809,2851,2882,2951,2990,3031,3039,3067,3068,3243,3322,3431,3470,3599,3637,3639,3667,3754,3831,3889,4013,4015,4042,4051,4057,4060,4078,4109,4143,4185,4319,4417,4556,4745,4892,4893,4899,4910,5002,5003,5040,5051,5094,5133,5134,5231,6576,6585,6586,6614,6615,12020,12339,12618,12620,12700,12733,12744,12815,12850,12882,12947,13103,13111,13149,13226,13234,13293,13311,13360,13385,13427,13436,13505,13511,13554,13639,13670,13728,13800,13853,13854,13989,14010,14082,14145,14152,14176,14177,14178,14179,14184,14204,14224,14266,14315,14318,14337,14348,14398,14407,14454,14473,14493,14591,14619,14621,14798,14931,15000,15120,15204,15341,16146,16321,16367,16387,16528,16819,17440,17442,17443,17445,17873,18163,18165,18427,18461,18500,18540,18561,18649,18672,18674,18675,18676,18677,18707,19565,19607,19609,19635,19698,19868,19979) ) LIMIT 1 [ RunTime:0.004145s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('S') AND `type_id` IN (22) AND ( vod_id IN (143,173,288,289,398,586,651,690,699,702,703,896,998,1002,1048,1164,1165,1166,1270,1283,1329,1331,1370,1398,1406,1448,1453,1492,1528,1529,1576,1577,1578,1579,1602,1615,1637,1646,1668,1677,1726,1776,1803,1816,1849,1862,1864,1865,1872,1907,1974,2018,2041,2048,2049,2054,2065,2144,2191,2225,2236,2251,2278,2357,2411,2476,2483,2522,2571,2666,2667,2696,2732,2809,2851,2882,2951,2990,3031,3039,3067,3068,3243,3322,3431,3470,3599,3637,3639,3667,3754,3831,3889,4013,4015,4042,4051,4057,4060,4078,4109,4143,4185,4319,4417,4556,4745,4892,4893,4899,4910,5002,5003,5040,5051,5094,5133,5134,5231,6576,6585,6586,6614,6615,12020,12339,12618,12620,12700,12733,12744,12815,12850,12882,12947,13103,13111,13149,13226,13234,13293,13311,13360,13385,13427,13436,13505,13511,13554,13639,13670,13728,13800,13853,13854,13989,14010,14082,14145,14152,14176,14177,14178,14179,14184,14204,14224,14266,14315,14318,14337,14348,14398,14407,14454,14473,14493,14591,14619,14621,14798,14931,15000,15120,15204,15341,16146,16321,16367,16387,16528,16819,17440,17442,17443,17445,17873,18163,18165,18427,18461,18500,18540,18561,18649,18672,18674,18675,18676,18677,18707,19565,19607,19609,19635,19698,19868,19979) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.004362s ]
