[ DB ] CONNECT:[ UseTime:0.001114s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002677s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '62c2e34b4b19fa541bc61977d369e6b9' LIMIT 1 [ RunTime:0.000932s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=2830,`search_last_hit_time`=1774053611 WHERE `search_key` = '62c2e34b4b19fa541bc61977d369e6b9' [ RunTime:0.010008s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.004323s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('Z') AND `type_id` IN (21) AND ( vod_id IN (13,75,121,203,204,216,272,300,301,302,394,450,451,452,454,455,477,577,598,614,814,884,930,964,977,1017,1108,1124,1162,1163,1170,1197,1236,1389,1427,1550,1558,1560,1561,1562,1618,1718,1840,2012,2161,2172,2186,2187,2240,2287,2290,2338,2341,2353,2368,2369,2376,2402,2408,2412,2417,2426,2430,2438,2486,2524,2577,2578,2597,2786,2794,2796,2811,2819,2821,2831,2993,2994,3000,3076,3165,3243,3256,3282,3310,3333,3336,3337,3339,3340,3341,3431,3490,3503,3538,3540,3562,3574,3577,3601,3629,3633,3634,3645,3646,3647,3648,3692,3792,3805,3817,3837,3838,3840,3847,3861,3862,3865,3867,3961,3962,4027,4240,4241,4242,4243,4244,4245,4246,4247,4258,4314,4315,4504,4520,4537,4546,4601,4602,4623,4626,4636,4639,4659,4660,4661,4665,4667,4670,4674,4690,4694,4698,4702,4711,4712,4718,4726,4731,4733,4735,4736,4737,4744,4753,4761,4762,4763,4771,4774,4776,4788,4792,4793,4797,4800,4802,4803,4804,4815,4836,4840,4841,4842,4847,4849,4853,4856,4861,4865,4868,4872,4873,4874,4877,4879,4888,4889,4896,4901,4906,4911,4915,4931,4944,5034,5035,5038,5059,5062,5063,5084,5093,5132,5309,5310,5356,6589,6591,6612,6613,12614,12792,12832,12904,12960,12977,12981,13032,13040,13071,13075,13116,13151,13172,13206,13214,13233,13234,13263,13286,13287,13305,13320,13338,13357,13390,13393,13461,13462,13515,13516,13519,13529,13542,13562,13655,13682,13727,13754,13760,13796,13809,13817,13882,13918,13933,14040,14048,14123,14143,14166,14227,14289,14374,14441,14508,14524,14576,14600,14609,14620,14631,14644,14666,14676,14696,14749,14859,14872,14973,14976,15007,15024,15027,15077,15185,15271,15302,15322,15338,15426,15443,15445,15532,15655,15737,15739,15844,15860,15890,15893,15969,15987,16051,16053,16109,16111,16134,16145,16158,16200,16215,16222,16249,16292,16293,16298,16303,16304,16314,16321,16327,16329,16338,16371,16454,16483,16490,16513,16789,17477,18046,18047,18099,18100,18208,18262,18371,18372,18437,18501,18623,18628,18633,18698,18700,18701,18712,18713,18725,18729,18749,18777,18778,18779,18781,18782,18783,18793,18829,18921,18922,18923,18924,18925,18926,18927,18928,18929,18930,18931,18934,18936,18937,18938,18940,18954,18968,18970,18996,18997,18998,19076,19103,19105,19111,19116,19132,19138,19139,19140,19143,19196,19197,19198,19199,19200,19201,19222,19223,19224,19225,19227,19229,19230,19247,19248,19249,19250,19251,19253,19345,19351,19356,19386,19393,19395,19401,19493,19499,19528,19595,19614,19615,19616,19617,19618,19619,19645,19646,19647,19648,19649,19742,19857,19858,19864,19941) ) LIMIT 1 [ RunTime:0.008891s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('Z') AND `type_id` IN (21) AND ( vod_id IN (13,75,121,203,204,216,272,300,301,302,394,450,451,452,454,455,477,577,598,614,814,884,930,964,977,1017,1108,1124,1162,1163,1170,1197,1236,1389,1427,1550,1558,1560,1561,1562,1618,1718,1840,2012,2161,2172,2186,2187,2240,2287,2290,2338,2341,2353,2368,2369,2376,2402,2408,2412,2417,2426,2430,2438,2486,2524,2577,2578,2597,2786,2794,2796,2811,2819,2821,2831,2993,2994,3000,3076,3165,3243,3256,3282,3310,3333,3336,3337,3339,3340,3341,3431,3490,3503,3538,3540,3562,3574,3577,3601,3629,3633,3634,3645,3646,3647,3648,3692,3792,3805,3817,3837,3838,3840,3847,3861,3862,3865,3867,3961,3962,4027,4240,4241,4242,4243,4244,4245,4246,4247,4258,4314,4315,4504,4520,4537,4546,4601,4602,4623,4626,4636,4639,4659,4660,4661,4665,4667,4670,4674,4690,4694,4698,4702,4711,4712,4718,4726,4731,4733,4735,4736,4737,4744,4753,4761,4762,4763,4771,4774,4776,4788,4792,4793,4797,4800,4802,4803,4804,4815,4836,4840,4841,4842,4847,4849,4853,4856,4861,4865,4868,4872,4873,4874,4877,4879,4888,4889,4896,4901,4906,4911,4915,4931,4944,5034,5035,5038,5059,5062,5063,5084,5093,5132,5309,5310,5356,6589,6591,6612,6613,12614,12792,12832,12904,12960,12977,12981,13032,13040,13071,13075,13116,13151,13172,13206,13214,13233,13234,13263,13286,13287,13305,13320,13338,13357,13390,13393,13461,13462,13515,13516,13519,13529,13542,13562,13655,13682,13727,13754,13760,13796,13809,13817,13882,13918,13933,14040,14048,14123,14143,14166,14227,14289,14374,14441,14508,14524,14576,14600,14609,14620,14631,14644,14666,14676,14696,14749,14859,14872,14973,14976,15007,15024,15027,15077,15185,15271,15302,15322,15338,15426,15443,15445,15532,15655,15737,15739,15844,15860,15890,15893,15969,15987,16051,16053,16109,16111,16134,16145,16158,16200,16215,16222,16249,16292,16293,16298,16303,16304,16314,16321,16327,16329,16338,16371,16454,16483,16490,16513,16789,17477,18046,18047,18099,18100,18208,18262,18371,18372,18437,18501,18623,18628,18633,18698,18700,18701,18712,18713,18725,18729,18749,18777,18778,18779,18781,18782,18783,18793,18829,18921,18922,18923,18924,18925,18926,18927,18928,18929,18930,18931,18934,18936,18937,18938,18940,18954,18968,18970,18996,18997,18998,19076,19103,19105,19111,19116,19132,19138,19139,19140,19143,19196,19197,19198,19199,19200,19201,19222,19223,19224,19225,19227,19229,19230,19247,19248,19249,19250,19251,19253,19345,19351,19356,19386,19393,19395,19401,19493,19499,19528,19595,19614,19615,19616,19617,19618,19619,19645,19646,19647,19648,19649,19742,19857,19858,19864,19941) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.009757s ]
