[ DB ] CONNECT:[ UseTime:0.001105s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002545s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '8c3d883af554128741cf5c5e41ed624f' LIMIT 1 [ RunTime:0.000819s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5754,`search_last_hit_time`=1773782743 WHERE `search_key` = '8c3d883af554128741cf5c5e41ed624f' [ RunTime:0.007155s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.003841s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('H') AND `type_id` IN (21) AND ( vod_id IN (15,16,22,28,135,138,139,184,357,365,380,414,652,712,758,760,807,915,950,971,972,1145,1791,1952,2038,2117,2148,2150,2155,2173,2175,2181,2200,2344,2424,2580,2593,2625,2739,2763,2977,2978,3169,3170,3232,3263,3281,3285,3407,3616,3619,6568,12674,12709,12765,12772,12797,12827,12834,12843,12873,12878,12924,12996,12997,13004,13113,13134,13144,13171,13216,13288,13358,13379,13442,13444,13481,13482,13536,13558,13594,13617,13721,13813,13891,13915,13937,13956,13981,14053,14096,14115,14353,14370,14373,14389,14390,14436,14603,14697,15009,16246,17506,18153,18248,18249,18271,18298,18360,18361,18393,18394,18395,18396,18398,18402,18417,18440,18579,18598,18599,18819,19166,19464,19480,19483,19582,19685,19762,19832,19933) ) LIMIT 1 [ RunTime:0.003187s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('H') AND `type_id` IN (21) AND ( vod_id IN (15,16,22,28,135,138,139,184,357,365,380,414,652,712,758,760,807,915,950,971,972,1145,1791,1952,2038,2117,2148,2150,2155,2173,2175,2181,2200,2344,2424,2580,2593,2625,2739,2763,2977,2978,3169,3170,3232,3263,3281,3285,3407,3616,3619,6568,12674,12709,12765,12772,12797,12827,12834,12843,12873,12878,12924,12996,12997,13004,13113,13134,13144,13171,13216,13288,13358,13379,13442,13444,13481,13482,13536,13558,13594,13617,13721,13813,13891,13915,13937,13956,13981,14053,14096,14115,14353,14370,14373,14389,14390,14436,14603,14697,15009,16246,17506,18153,18248,18249,18271,18298,18360,18361,18393,18394,18395,18396,18398,18402,18417,18440,18579,18598,18599,18819,19166,19464,19480,19483,19582,19685,19762,19832,19933) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.003649s ]
