[ DB ] CONNECT:[ UseTime:0.001122s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002892s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '5543353f5aa82832fb5fbb92eb9c0f31' LIMIT 1 [ RunTime:0.000831s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5007,`search_last_hit_time`=1774099579 WHERE `search_key` = '5543353f5aa82832fb5fbb92eb9c0f31' [ RunTime:0.007954s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.004124s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('M') AND `type_id` IN (22) AND ( vod_id IN (91,104,137,179,182,224,296,298,348,369,393,399,457,458,489,497,509,523,543,629,641,649,688,732,748,749,779,781,785,792,795,813,826,849,858,877,885,887,891,895,901,902,905,929,950,963,967,969,972,990,1004,1008,1014,1015,1096,1192,1217,1218,1317,1318,1327,1404,1405,1410,1412,1419,1430,1445,1470,1495,1512,1541,1564,1660,1698,1724,1793,1807,1809,1818,1826,1897,1914,1915,1932,2084,2161,2169,2172,2204,2232,2319,2417,2455,2579,2616,2753,2770,2797,2814,2890,2891,2898,2900,2975,3018,3054,3091,3110,3141,3190,3208,3235,3238,3241,3244,3255,3313,3330,3348,3391,3399,3437,3559,3586,3635,3638,3663,3749,3769,3829,3971,4084,4086,4098,4156,4164,4165,4195,4264,4289,4440,4687,4706,4765,4785,4821,4882,5015,5083,5103,5141,5147,5191,5192,5193,5194,5195,5196,5197,5198,5199,5200,5201,5202,5203,5204,5205,5207,5208,5209,5253,5254,5288,5296,6591,6592,6593,6607,12038,12622,12653,12682,12692,12732,12765,12773,12775,12896,12949,12996,13005,13015,13018,13044,13067,13106,13122,13132,13142,13171,13231,13250,13263,13277,13288,13294,13405,13409,13440,13459,13484,13489,13510,13519,13522,13538,13550,13602,13622,13702,13819,13831,13887,13936,14030,14044,14084,14170,14215,14216,14242,14264,14268,14290,14307,14352,14378,14380,14499,14514,14520,14550,14568,14773,15012,15101,15497,15519,15568,15625,15627,15670,15706,15711,15714,15850,15866,15870,15872,15951,15955,15971,16017,16092,16173,16175,16325,16395,16582,17306,17318,17323,17325,17326,17328,17477,17482,18153,18615,18654,18739,18838,18848,19016,19017,19035,19037,19050,19081,19383,19500,19763,19900,19949,19968,20003,20006) ) LIMIT 1 [ RunTime:0.004702s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('M') AND `type_id` IN (22) AND ( vod_id IN (91,104,137,179,182,224,296,298,348,369,393,399,457,458,489,497,509,523,543,629,641,649,688,732,748,749,779,781,785,792,795,813,826,849,858,877,885,887,891,895,901,902,905,929,950,963,967,969,972,990,1004,1008,1014,1015,1096,1192,1217,1218,1317,1318,1327,1404,1405,1410,1412,1419,1430,1445,1470,1495,1512,1541,1564,1660,1698,1724,1793,1807,1809,1818,1826,1897,1914,1915,1932,2084,2161,2169,2172,2204,2232,2319,2417,2455,2579,2616,2753,2770,2797,2814,2890,2891,2898,2900,2975,3018,3054,3091,3110,3141,3190,3208,3235,3238,3241,3244,3255,3313,3330,3348,3391,3399,3437,3559,3586,3635,3638,3663,3749,3769,3829,3971,4084,4086,4098,4156,4164,4165,4195,4264,4289,4440,4687,4706,4765,4785,4821,4882,5015,5083,5103,5141,5147,5191,5192,5193,5194,5195,5196,5197,5198,5199,5200,5201,5202,5203,5204,5205,5207,5208,5209,5253,5254,5288,5296,6591,6592,6593,6607,12038,12622,12653,12682,12692,12732,12765,12773,12775,12896,12949,12996,13005,13015,13018,13044,13067,13106,13122,13132,13142,13171,13231,13250,13263,13277,13288,13294,13405,13409,13440,13459,13484,13489,13510,13519,13522,13538,13550,13602,13622,13702,13819,13831,13887,13936,14030,14044,14084,14170,14215,14216,14242,14264,14268,14290,14307,14352,14378,14380,14499,14514,14520,14550,14568,14773,15012,15101,15497,15519,15568,15625,15627,15670,15706,15711,15714,15850,15866,15870,15872,15951,15955,15971,16017,16092,16173,16175,16325,16395,16582,17306,17318,17323,17325,17326,17328,17477,17482,18153,18615,18654,18739,18838,18848,19016,19017,19035,19037,19050,19081,19383,19500,19763,19900,19949,19968,20003,20006) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.004865s ]
