[ DB ] CONNECT:[ UseTime:0.001275s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002923s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '083a18eafa4f7cd5862df5a2266c75dc' LIMIT 1 [ RunTime:0.000835s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5440,`search_last_hit_time`=1773767731 WHERE `search_key` = '083a18eafa4f7cd5862df5a2266c75dc' [ RunTime:0.008150s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.004157s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `type_id` IN (20) AND ( vod_id IN (1,2,12,22,107,108,136,361,480,556,712,757,776,805,1090,1203,1210,1794,1795,1799,1800,1801,1856,1952,2021,2119,2154,2169,2174,2181,2343,2354,2403,2423,2424,2435,2456,2503,2520,2521,2531,2533,2536,2537,2546,2612,2633,2678,2706,2735,2742,2792,2807,2827,2855,3127,3128,3133,3166,3263,3283,3328,3443,3546,3561,3563,3566,3569,3619,3626,3627,3628,3795,3804,4250,4426,4427,4428,5376,5389,5485,12656,12664,12720,12734,12873,12878,12924,12971,13194,13207,13318,13363,13403,13442,13445,13488,13605,13621,13636,13881,13938,13959,13989,14056,14118,14135,14197,14270,14294,14338,14391,14456,14571,14586,14991,15003,15233,15797,16193,16262,17389,18122,18271,18327,18395,18402,18415,18417,18449,18450,18469,18584,18703,19000,19162,19163,19164,19165,19221,19322,19332,19333,19337,19348,19391,19396,19418,19432,19466,19479,19480,19483,19485,19505,19520,19530,19544,19589,19594,19621,19650,19688,19689,19690,19691,19762,19893,19916,19917,19918,19919,19947,19948) ) LIMIT 1 [ RunTime:0.003898s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `type_id` IN (20) AND ( vod_id IN (1,2,12,22,107,108,136,361,480,556,712,757,776,805,1090,1203,1210,1794,1795,1799,1800,1801,1856,1952,2021,2119,2154,2169,2174,2181,2343,2354,2403,2423,2424,2435,2456,2503,2520,2521,2531,2533,2536,2537,2546,2612,2633,2678,2706,2735,2742,2792,2807,2827,2855,3127,3128,3133,3166,3263,3283,3328,3443,3546,3561,3563,3566,3569,3619,3626,3627,3628,3795,3804,4250,4426,4427,4428,5376,5389,5485,12656,12664,12720,12734,12873,12878,12924,12971,13194,13207,13318,13363,13403,13442,13445,13488,13605,13621,13636,13881,13938,13959,13989,14056,14118,14135,14197,14270,14294,14338,14391,14456,14571,14586,14991,15003,15233,15797,16193,16262,17389,18122,18271,18327,18395,18402,18415,18417,18449,18450,18469,18584,18703,19000,19162,19163,19164,19165,19221,19322,19332,19333,19337,19348,19391,19396,19418,19432,19466,19479,19480,19483,19485,19505,19520,19530,19544,19589,19594,19621,19650,19688,19689,19690,19691,19762,19893,19916,19917,19918,19919,19947,19948) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.005816s ]
