[ DB ] CONNECT:[ UseTime:0.000921s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002315s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '1168f23a97e2b0ad11b96343e53b3f77' LIMIT 1 [ RunTime:0.000649s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=6145,`search_last_hit_time`=1773810543 WHERE `search_key` = '1168f23a97e2b0ad11b96343e53b3f77' [ RunTime:0.008193s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.003701s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('S') AND `type_id` IN (20) AND ( vod_id IN (39,215,234,253,307,317,356,503,729,731,757,784,824,945,1031,1337,1343,1372,1388,1792,1931,1943,1955,1962,1970,2066,2202,2316,2779,2782,2813,2894,2959,2961,3000,3027,3107,3123,3307,3505,3741,3742,3744,3751,3836,3864,3891,3910,3911,3924,4141,4189,4199,4307,4418,4545,4668,4886,5030,5164,5333,12622,12651,12829,12834,12858,12883,12893,12926,13052,13058,13123,13131,13156,13285,13323,13327,13333,13401,13493,13507,13512,13563,13579,13589,13720,13753,13793,14046,14078,14134,14213,14295,14611,14635,14640,14763,14809,14856,15046,15119,15149,15183,15249,15257,15357,15503,15580,15769,15994,15998,16064,16493,17286,17340,17447,17448,18403,18610,18731,18801,19034,19056,19084,19252,19370,19378,19568,19625,19926,19927,19929,19976) ) LIMIT 1 [ RunTime:0.003640s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('S') AND `type_id` IN (20) AND ( vod_id IN (39,215,234,253,307,317,356,503,729,731,757,784,824,945,1031,1337,1343,1372,1388,1792,1931,1943,1955,1962,1970,2066,2202,2316,2779,2782,2813,2894,2959,2961,3000,3027,3107,3123,3307,3505,3741,3742,3744,3751,3836,3864,3891,3910,3911,3924,4141,4189,4199,4307,4418,4545,4668,4886,5030,5164,5333,12622,12651,12829,12834,12858,12883,12893,12926,13052,13058,13123,13131,13156,13285,13323,13327,13333,13401,13493,13507,13512,13563,13579,13589,13720,13753,13793,14046,14078,14134,14213,14295,14611,14635,14640,14763,14809,14856,15046,15119,15149,15183,15249,15257,15357,15503,15580,15769,15994,15998,16064,16493,17286,17340,17447,17448,18403,18610,18731,18801,19034,19056,19084,19252,19370,19378,19568,19625,19926,19927,19929,19976) ) ORDER BY `vod_hits` DESC LIMIT 0,72 [ RunTime:0.006547s ]
