[ DB ] CONNECT:[ UseTime:0.001016s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002514s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = 'f71485ec4998668924d4ee352463bdf6' LIMIT 1 [ RunTime:0.000866s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=6951,`search_last_hit_time`=1773782501 WHERE `search_key` = 'f71485ec4998668924d4ee352463bdf6' [ RunTime:0.009597s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.003997s ]
[ 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 (125,526,585,1203,1204,1210,1795,2021,2520,2531,2536,2544,2612,2678,2681,3128,3279,3369,3417,3627,3853,4230,4232,5305,5386,5483,12796,12901,12971,13194,13574,13716,14014,14135,14197,14338,14586,17819,18209,18449,18450,18564,18565,19522,19548,19585) ) LIMIT 1 [ RunTime:0.001753s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('H') AND `type_id` IN (21) AND ( vod_id IN (125,526,585,1203,1204,1210,1795,2021,2520,2531,2536,2544,2612,2678,2681,3128,3279,3369,3417,3627,3853,4230,4232,5305,5386,5483,12796,12901,12971,13194,13574,13716,14014,14135,14197,14338,14586,17819,18209,18449,18450,18564,18565,19522,19548,19585) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.001983s ]