[ DB ] CONNECT:[ UseTime:0.001094s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002533s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '7872d146e4ff1fba55c382fafdd25874' LIMIT 1 [ RunTime:0.000793s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=4002,`search_last_hit_time`=1773768335 WHERE `search_key` = '7872d146e4ff1fba55c382fafdd25874' [ RunTime:0.008575s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.004165s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('W') AND `type_id` IN (22) AND ( vod_id IN (1179,1420,1776,1827,2949,3212,3258,3271,3345,3747,3900,4314,4315,4350,4399,4445,4511,4541,4543,4544,4635,4754,4904,5005,5006,5064,5166,5180,5311,11989,12795,13154,13189,13458,13532,13544,13571,13743,13869,14203,14403,14452,15766,15786,15794,15799,15800,15910,16168,16178,16220,16290,16326,16329,16337,16358,16414,16419,16452,16515,16516,16551,16583,16585,17390,17391,18148,18457,18608,18609,18665,18667,18708,18737,18755,18794,18947,19060,19110,19113,19344,19365,19470,19542,19569,19573,19583,19737,19844,19864,19921,19943,19998) ) LIMIT 1 [ RunTime:0.003368s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('W') AND `type_id` IN (22) AND ( vod_id IN (1179,1420,1776,1827,2949,3212,3258,3271,3345,3747,3900,4314,4315,4350,4399,4445,4511,4541,4543,4544,4635,4754,4904,5005,5006,5064,5166,5180,5311,11989,12795,13154,13189,13458,13532,13544,13571,13743,13869,14203,14403,14452,15766,15786,15794,15799,15800,15910,16168,16178,16220,16290,16326,16329,16337,16358,16414,16419,16452,16515,16516,16551,16583,16585,17390,17391,18148,18457,18608,18609,18665,18667,18708,18737,18755,18794,18947,19060,19110,19113,19344,19365,19470,19542,19569,19573,19583,19737,19844,19864,19921,19943,19998) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.003385s ]
