[ DB ] CONNECT:[ UseTime:0.001264s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.003106s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '4667fff5beb469bdce5ca2ec23f57057' LIMIT 1 [ RunTime:0.000857s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5124,`search_last_hit_time`=1773776307 WHERE `search_key` = '4667fff5beb469bdce5ca2ec23f57057' [ RunTime:0.008153s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.003932s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('G') AND `type_id` IN (21) AND ( vod_id IN (24,218,225,226,227,228,229,230,231,243,273,274,714,716,717,946,1162,1163,1169,1272,1273,1614,1669,1670,1773,2044,2048,2049,2120,2151,2156,2157,2162,2164,2176,2182,2183,2193,2236,2242,2243,2244,2266,2338,2339,2365,2373,2378,2384,2386,2405,2406,2408,2410,2428,2483,2510,2512,2513,2529,2543,2547,2552,2554,2557,2584,2585,2597,2599,2600,2606,2607,2608,2619,2694,2696,2697,2712,2715,2716,2722,2728,2745,2794,2803,2825,2828,2839,2849,2908,2929,2930,2931,2933,2957,2970,2973,3020,3067,3068,3199,3201,3218,3225,3249,3260,3334,3353,3357,3375,3392,3404,3405,3422,3431,3434,3496,3503,3538,3540,3553,3562,3564,3580,3581,3599,3641,3667,3673,3674,3675,3682,3690,3698,3731,3742,3744,3748,3757,3784,3785,3786,3788,3789,3810,3819,3829,3831,3833,3836,3840,3842,3843,3844,3846,3918,3939,4202,4238,4277,4278,4295,4296,4350,4365,4368,4369,4374,4380,4390,4507,4511,4512,4513,4523,4524,4525,4526,4527,4528,4529,4530,4531,4532,4533,4534,4537,4538,4539,4540,4541,4542,4543,4548,4552,4564,4565,4570,4579,4581,4582,4587,4625,4661,4665,4681,4692,4695,4696,4702,4714,4730,4732,4751,4761,4766,4774,4804,4810,4816,4861,4868,4900,4901,4909,4913,4914,4916,4917,4918,4919,4920,4961,5013,5017,5019,5021,5033,5037,5121,5122,5123,5238,5299,5300,5301,5302,5307,5308,5309,5310,5317,5318,5319,5320,5321,5322,5323,5480,5481,5561,6577,6578,6596,6611,12021,12061,12087,12095,12122,12123,12180,12221,12222,12223,12312,12651,12737,12934,12963,13264,13284,13329,13601,13635,13663,13731,13789,13822,13830,13867,14024,14137,14184,14248,14548,14549,14619,14745,14763,14781,14804,14828,14837,14849,14850,14854,14868,14904,14952,14965,15000,15005,15007,15042,15059,15074,15106,15114,15120,15128,15140,15155,15160,15179,15181,15184,15209,15232,15255,15258,15261,15265,15279,15293,15295,15310,15312,15315,15317,15326,15337,15344,15348,15367,15379,15384,15392,15399,15428,15438,15442,15457,15461,15471,15481,15493,15519,15535,15560,15564,15569,15580,15602,15606,15623,15633,15653,15677,15678,15704,15716,15741,15748,15774,15780,15795,15829,15858,15866,15877,15920,16034,16069,16140,16142,16168,16172,16174,16201,16225,16228,16350,16372,16390,16449,16467,16474,16502,16596,16597,16618,16788,17184,17188,17189,17190,17191,17264,17287,17370,17396,17397,17398,17399,17401,17402,17403,17404,17415,17416,17417,17418,17419,17420,17421,17422,17440,17442,17443,17444,17445,17446,17467,17488,17504,17505,17827,17829,17870,17872,17878,17880,17881,17899,17901,17902,17915,17952,17967,17987,18021,18022,18023,18045,18046,18047,18048,18049,18050,18107,18125,18126,18161,18258,18303,18316,18328,18337,18339,18340,18342,18345,18350,18353,18354,18455,18600,18606,18607,18608,18609,18611,18612,18613,18614,18619,18620,18708,18710,18714,18715,18830,18834,18959,19030,19036,19075,19076,19112,19132,19138,19139,19140,19197,19200,19223,19225,19253,19254,19255,19257,19258,19289,19290,19291,19292,19293,19294,19296,19304,19305,19306,19307,19308,19338,19385,19390,19399,19484,19497,19591,19616,19621,19627,19635,19639,19640,19641,19642,19643,19644,19686,19687,19757,19760,19794,19855,19856,19858,19861,19904,19905,19906,19907,19908,19911,19927,19929,19953,19954,19972,19979,19981,19984,20000) ) LIMIT 1 [ RunTime:0.011112s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('G') AND `type_id` IN (21) AND ( vod_id IN (24,218,225,226,227,228,229,230,231,243,273,274,714,716,717,946,1162,1163,1169,1272,1273,1614,1669,1670,1773,2044,2048,2049,2120,2151,2156,2157,2162,2164,2176,2182,2183,2193,2236,2242,2243,2244,2266,2338,2339,2365,2373,2378,2384,2386,2405,2406,2408,2410,2428,2483,2510,2512,2513,2529,2543,2547,2552,2554,2557,2584,2585,2597,2599,2600,2606,2607,2608,2619,2694,2696,2697,2712,2715,2716,2722,2728,2745,2794,2803,2825,2828,2839,2849,2908,2929,2930,2931,2933,2957,2970,2973,3020,3067,3068,3199,3201,3218,3225,3249,3260,3334,3353,3357,3375,3392,3404,3405,3422,3431,3434,3496,3503,3538,3540,3553,3562,3564,3580,3581,3599,3641,3667,3673,3674,3675,3682,3690,3698,3731,3742,3744,3748,3757,3784,3785,3786,3788,3789,3810,3819,3829,3831,3833,3836,3840,3842,3843,3844,3846,3918,3939,4202,4238,4277,4278,4295,4296,4350,4365,4368,4369,4374,4380,4390,4507,4511,4512,4513,4523,4524,4525,4526,4527,4528,4529,4530,4531,4532,4533,4534,4537,4538,4539,4540,4541,4542,4543,4548,4552,4564,4565,4570,4579,4581,4582,4587,4625,4661,4665,4681,4692,4695,4696,4702,4714,4730,4732,4751,4761,4766,4774,4804,4810,4816,4861,4868,4900,4901,4909,4913,4914,4916,4917,4918,4919,4920,4961,5013,5017,5019,5021,5033,5037,5121,5122,5123,5238,5299,5300,5301,5302,5307,5308,5309,5310,5317,5318,5319,5320,5321,5322,5323,5480,5481,5561,6577,6578,6596,6611,12021,12061,12087,12095,12122,12123,12180,12221,12222,12223,12312,12651,12737,12934,12963,13264,13284,13329,13601,13635,13663,13731,13789,13822,13830,13867,14024,14137,14184,14248,14548,14549,14619,14745,14763,14781,14804,14828,14837,14849,14850,14854,14868,14904,14952,14965,15000,15005,15007,15042,15059,15074,15106,15114,15120,15128,15140,15155,15160,15179,15181,15184,15209,15232,15255,15258,15261,15265,15279,15293,15295,15310,15312,15315,15317,15326,15337,15344,15348,15367,15379,15384,15392,15399,15428,15438,15442,15457,15461,15471,15481,15493,15519,15535,15560,15564,15569,15580,15602,15606,15623,15633,15653,15677,15678,15704,15716,15741,15748,15774,15780,15795,15829,15858,15866,15877,15920,16034,16069,16140,16142,16168,16172,16174,16201,16225,16228,16350,16372,16390,16449,16467,16474,16502,16596,16597,16618,16788,17184,17188,17189,17190,17191,17264,17287,17370,17396,17397,17398,17399,17401,17402,17403,17404,17415,17416,17417,17418,17419,17420,17421,17422,17440,17442,17443,17444,17445,17446,17467,17488,17504,17505,17827,17829,17870,17872,17878,17880,17881,17899,17901,17902,17915,17952,17967,17987,18021,18022,18023,18045,18046,18047,18048,18049,18050,18107,18125,18126,18161,18258,18303,18316,18328,18337,18339,18340,18342,18345,18350,18353,18354,18455,18600,18606,18607,18608,18609,18611,18612,18613,18614,18619,18620,18708,18710,18714,18715,18830,18834,18959,19030,19036,19075,19076,19112,19132,19138,19139,19140,19197,19200,19223,19225,19253,19254,19255,19257,19258,19289,19290,19291,19292,19293,19294,19296,19304,19305,19306,19307,19308,19338,19385,19390,19399,19484,19497,19591,19616,19621,19627,19635,19639,19640,19641,19642,19643,19644,19686,19687,19757,19760,19794,19855,19856,19858,19861,19904,19905,19906,19907,19908,19911,19927,19929,19953,19954,19972,19979,19981,19984,20000) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.009517s ]
