[ DB ] CONNECT:[ UseTime:0.001071s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002758s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '3b1c5a47b39137dacf9c349badde87cf' LIMIT 1 [ RunTime:0.000856s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=8437,`search_last_hit_time`=1773788820 WHERE `search_key` = '3b1c5a47b39137dacf9c349badde87cf' [ RunTime:0.009589s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.004186s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('F') AND `type_id` IN (21) AND ( vod_id IN (31,50,88,105,145,168,238,239,240,249,286,303,340,370,374,378,379,389,390,392,415,425,477,484,485,490,492,497,501,512,517,519,520,535,536,540,544,550,555,561,564,565,570,577,655,670,673,695,729,753,763,775,783,784,786,787,798,801,805,806,814,824,828,829,838,846,849,850,854,868,889,921,935,953,965,974,985,989,1010,1037,1039,1040,1053,1064,1066,1070,1071,1074,1078,1092,1101,1102,1103,1107,1137,1148,1149,1186,1189,1192,1200,1207,1208,1217,1218,1221,1226,1238,1254,1258,1263,1267,1268,1286,1288,1293,1321,1336,1353,1362,1365,1424,1428,1442,1443,1477,1493,1507,1508,1513,1520,1547,1548,1571,1579,1598,1607,1625,1675,1680,1684,1686,1690,1691,1710,1714,1750,1756,1760,1771,1797,1798,1847,1857,1881,1888,1890,1901,1908,1920,1934,1946,1981,2012,2035,2053,2057,2058,2068,2084,2146,2172,2223,2224,2230,2233,2248,2258,2260,2269,2272,2282,2326,2337,2448,2449,2458,2475,2496,2498,2501,2516,2637,2782,2853,2860,2862,2869,2878,2937,2938,2989,2991,3017,3022,3046,3049,3074,3076,3104,3109,3114,3161,3167,3168,3188,3195,3201,3217,3230,3280,3292,3293,3341,3344,3367,3390,3411,3412,3432,3465,3499,3507,3514,3515,3531,3543,3568,3603,3677,3688,3756,3889,3924,3927,3929,3938,3944,3965,3966,3973,3978,3986,3987,3995,4001,4011,4014,4021,4023,4035,4057,4063,4068,4081,4095,4102,4105,4109,4110,4115,4117,4122,4157,4161,4167,4172,4174,4199,4200,4219,4269,4283,4288,4290,4291,4294,4300,4314,4315,4322,4325,4328,4330,4398,4405,4412,4438,4460,4466,4484,4486,4488,4517,4580,4583,4630,4634,4640,4664,4673,4712,4754,4772,4774,4807,4811,4823,4838,4839,4840,4885,4932,4933,4946,5052,5060,5105,5108,5129,5144,5167,5211,5216,5221,5222,5224,5232,5233,5240,5242,5246,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5273,5276,5356,5358,5370,5377,5380,5392,6576,6616,12023,12065,12202,12245,12314,12316,12635,12671,12677,12694,12720,12734,12769,12771,12781,12787,12796,12839,12859,12883,12885,12915,12929,12971,12976,12981,12983,12991,12999,13002,13029,13037,13044,13058,13061,13062,13069,13081,13087,13099,13104,13105,13129,13148,13169,13192,13197,13205,13212,13227,13228,13241,13242,13261,13270,13274,13275,13282,13293,13296,13297,13327,13330,13334,13345,13353,13365,13367,13370,13389,13391,13392,13397,13417,13446,13450,13471,13483,13492,13568,13569,13574,13585,13597,13612,13620,13630,13633,13684,13701,13705,13721,13726,13732,13765,13775,13795,13825,13830,13840,13847,13849,13866,13884,13896,13940,13950,13954,13965,13966,13980,14006,14007,14011,14014,14023,14027,14033,14048,14054,14055,14064,14071,14074,14077,14081,14096,14103,14118,14122,14133,14155,14167,14170,14188,14196,14206,14228,14238,14247,14257,14270,14275,14309,14311,14333,14343,14354,14368,14396,14405,14411,14418,14466,14469,14485,14510,14512,14515,14539,14562,14601,14610,14635,14654,14667,14669,14691,14694,14698,14711,14739,14791,14801,14813,14851,14871,14906,14966,14987,14989,14997,15035,15067,15104,15117,15122,15123,15146,15147,15148,15150,15154,15186,15194,15202,15248,15254,15305,15320,15380,15418,15444,15573,15592,15656,15660,15661,15867,15894,15956,15984,16003,16036,16043,16075,16175,16253,16271,16337,16339,16364,16418,16439,16476,16515,16516,16543,16551,16641,17477,18095,18102,18103,18107,18123,18148,18154,18155,18156,18157,18161,18208,18286,18300,18308,18309,18324,18325,18327,18329,18332,18362,18367,18371,18383,18424,18425,18426,18430,18472,18485,18508,18523,18538,18539,18540,18578,18618,18665,18667,18689,18700,18737,18742,18758,18785,18801,18804,18999,19000,19102,19115,19272,19314,19315,19316,19317,19319,19344,19485,19503,19561,19564,19577,19605,19608,19626,19628,19709,19801,19837,19896) ) LIMIT 1 [ RunTime:0.012957s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('F') AND `type_id` IN (21) AND ( vod_id IN (31,50,88,105,145,168,238,239,240,249,286,303,340,370,374,378,379,389,390,392,415,425,477,484,485,490,492,497,501,512,517,519,520,535,536,540,544,550,555,561,564,565,570,577,655,670,673,695,729,753,763,775,783,784,786,787,798,801,805,806,814,824,828,829,838,846,849,850,854,868,889,921,935,953,965,974,985,989,1010,1037,1039,1040,1053,1064,1066,1070,1071,1074,1078,1092,1101,1102,1103,1107,1137,1148,1149,1186,1189,1192,1200,1207,1208,1217,1218,1221,1226,1238,1254,1258,1263,1267,1268,1286,1288,1293,1321,1336,1353,1362,1365,1424,1428,1442,1443,1477,1493,1507,1508,1513,1520,1547,1548,1571,1579,1598,1607,1625,1675,1680,1684,1686,1690,1691,1710,1714,1750,1756,1760,1771,1797,1798,1847,1857,1881,1888,1890,1901,1908,1920,1934,1946,1981,2012,2035,2053,2057,2058,2068,2084,2146,2172,2223,2224,2230,2233,2248,2258,2260,2269,2272,2282,2326,2337,2448,2449,2458,2475,2496,2498,2501,2516,2637,2782,2853,2860,2862,2869,2878,2937,2938,2989,2991,3017,3022,3046,3049,3074,3076,3104,3109,3114,3161,3167,3168,3188,3195,3201,3217,3230,3280,3292,3293,3341,3344,3367,3390,3411,3412,3432,3465,3499,3507,3514,3515,3531,3543,3568,3603,3677,3688,3756,3889,3924,3927,3929,3938,3944,3965,3966,3973,3978,3986,3987,3995,4001,4011,4014,4021,4023,4035,4057,4063,4068,4081,4095,4102,4105,4109,4110,4115,4117,4122,4157,4161,4167,4172,4174,4199,4200,4219,4269,4283,4288,4290,4291,4294,4300,4314,4315,4322,4325,4328,4330,4398,4405,4412,4438,4460,4466,4484,4486,4488,4517,4580,4583,4630,4634,4640,4664,4673,4712,4754,4772,4774,4807,4811,4823,4838,4839,4840,4885,4932,4933,4946,5052,5060,5105,5108,5129,5144,5167,5211,5216,5221,5222,5224,5232,5233,5240,5242,5246,5259,5260,5261,5262,5263,5264,5265,5266,5267,5268,5273,5276,5356,5358,5370,5377,5380,5392,6576,6616,12023,12065,12202,12245,12314,12316,12635,12671,12677,12694,12720,12734,12769,12771,12781,12787,12796,12839,12859,12883,12885,12915,12929,12971,12976,12981,12983,12991,12999,13002,13029,13037,13044,13058,13061,13062,13069,13081,13087,13099,13104,13105,13129,13148,13169,13192,13197,13205,13212,13227,13228,13241,13242,13261,13270,13274,13275,13282,13293,13296,13297,13327,13330,13334,13345,13353,13365,13367,13370,13389,13391,13392,13397,13417,13446,13450,13471,13483,13492,13568,13569,13574,13585,13597,13612,13620,13630,13633,13684,13701,13705,13721,13726,13732,13765,13775,13795,13825,13830,13840,13847,13849,13866,13884,13896,13940,13950,13954,13965,13966,13980,14006,14007,14011,14014,14023,14027,14033,14048,14054,14055,14064,14071,14074,14077,14081,14096,14103,14118,14122,14133,14155,14167,14170,14188,14196,14206,14228,14238,14247,14257,14270,14275,14309,14311,14333,14343,14354,14368,14396,14405,14411,14418,14466,14469,14485,14510,14512,14515,14539,14562,14601,14610,14635,14654,14667,14669,14691,14694,14698,14711,14739,14791,14801,14813,14851,14871,14906,14966,14987,14989,14997,15035,15067,15104,15117,15122,15123,15146,15147,15148,15150,15154,15186,15194,15202,15248,15254,15305,15320,15380,15418,15444,15573,15592,15656,15660,15661,15867,15894,15956,15984,16003,16036,16043,16075,16175,16253,16271,16337,16339,16364,16418,16439,16476,16515,16516,16543,16551,16641,17477,18095,18102,18103,18107,18123,18148,18154,18155,18156,18157,18161,18208,18286,18300,18308,18309,18324,18325,18327,18329,18332,18362,18367,18371,18383,18424,18425,18426,18430,18472,18485,18508,18523,18538,18539,18540,18578,18618,18665,18667,18689,18700,18737,18742,18758,18785,18801,18804,18999,19000,19102,19115,19272,19314,19315,19316,19317,19319,19344,19485,19503,19561,19564,19577,19605,19608,19626,19628,19709,19801,19837,19896) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.008202s ]
