[ DB ] CONNECT:[ UseTime:0.001150s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002573s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = 'da5e9afe678bd0d102271442741eadb9' LIMIT 1 [ RunTime:0.000780s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5820,`search_last_hit_time`=1773776669 WHERE `search_key` = 'da5e9afe678bd0d102271442741eadb9' [ RunTime:0.007432s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.003875s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('Q') AND `type_id` IN (21) AND ( vod_id IN (79,162,212,238,485,512,563,695,1040,1448,1934,2223,2248,2260,2268,2516,3052,3164,3433,3445,3456,3915,3939,4129,4470,4583,5324,5370,5371,12316,12875,12936,13003,13011,13069,13094,13166,13218,13228,13235,13251,13270,13282,13364,13367,13435,13658,13718,13755,13850,13954,14174,14188,14271,14288,14346,14359,14361,14396,14434,14469,14508,14669,14944,15830,18331,18358,18390,18428,18429,18434,18523,18524,18541,19534,19628,19709) ) LIMIT 1 [ RunTime:0.002348s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('Q') AND `type_id` IN (21) AND ( vod_id IN (79,162,212,238,485,512,563,695,1040,1448,1934,2223,2248,2260,2268,2516,3052,3164,3433,3445,3456,3915,3939,4129,4470,4583,5324,5370,5371,12316,12875,12936,13003,13011,13069,13094,13166,13218,13228,13235,13251,13270,13282,13364,13367,13435,13658,13718,13755,13850,13954,14174,14188,14271,14288,14346,14359,14361,14396,14434,14469,14508,14669,14944,15830,18331,18358,18390,18428,18429,18434,18523,18524,18541,19534,19628,19709) ) ORDER BY `vod_time` DESC LIMIT 0,72 [ RunTime:0.002753s ]
