[ DB ] CONNECT:[ UseTime:0.001139s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002492s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '4326acceb9e26cbeb08dcd8ece1a8d4e' LIMIT 1 [ RunTime:0.000979s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=6775,`search_last_hit_time`=1773768361 WHERE `search_key` = '4326acceb9e26cbeb08dcd8ece1a8d4e' [ RunTime:0.007490s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.004177s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('S') AND `type_id` IN (20) AND ( vod_id IN (10,28,67,69,71,74,81,88,1209,1216,1629,1726,2026,2091,2092,2093,2095,2169,2181,2339,2432,2490,2581,2652,2654,2665,2688,2695,2703,2707,2708,2710,2717,2718,2723,2733,2789,3300,3302,3384,3385,3387,3492,3506,3526,3535,3642,3695,3844,3846,4302,4316,4317,4331,4332,4333,4338,4503,4519,4566,4576,4589,4604,4605,4606,4607,4610,4611,4613,4614,4615,4616,4617,4645,4824,5277,5279,5281,5284,5285,5293,5341,5342,5344,5350,5554,5555,5557,5558,5559,5560,6573,6579,6580,11979,11983,11986,12016,12068,12123,12204,12234,12253,12297,14689,14746,14849,14858,14891,14896,14962,14975,15011,15020,15061,15071,15089,15113,15129,15138,15182,15271,15323,15369,15372,15387,15396,15491,15503,15524,15546,15551,15588,15697,16055,16132,16156,16619,16620,16621,16622,16623,16624,16625,16627,16628,16629,16630,16631,16632,16633,16634,16636,16637,16638,16639,16640,17348,17466,18108,18318,18388,18507,18586,19014,19212,19213,19320,19321,19347,19366,19375,19415,19518,19547,19626,19803,19982) ) LIMIT 1 [ RunTime:0.004766s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('S') AND `type_id` IN (20) AND ( vod_id IN (10,28,67,69,71,74,81,88,1209,1216,1629,1726,2026,2091,2092,2093,2095,2169,2181,2339,2432,2490,2581,2652,2654,2665,2688,2695,2703,2707,2708,2710,2717,2718,2723,2733,2789,3300,3302,3384,3385,3387,3492,3506,3526,3535,3642,3695,3844,3846,4302,4316,4317,4331,4332,4333,4338,4503,4519,4566,4576,4589,4604,4605,4606,4607,4610,4611,4613,4614,4615,4616,4617,4645,4824,5277,5279,5281,5284,5285,5293,5341,5342,5344,5350,5554,5555,5557,5558,5559,5560,6573,6579,6580,11979,11983,11986,12016,12068,12123,12204,12234,12253,12297,14689,14746,14849,14858,14891,14896,14962,14975,15011,15020,15061,15071,15089,15113,15129,15138,15182,15271,15323,15369,15372,15387,15396,15491,15503,15524,15546,15551,15588,15697,16055,16132,16156,16619,16620,16621,16622,16623,16624,16625,16627,16628,16629,16630,16631,16632,16633,16634,16636,16637,16638,16639,16640,17348,17466,18108,18318,18388,18507,18586,19014,19212,19213,19320,19321,19347,19366,19375,19415,19518,19547,19626,19803,19982) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.007014s ]
