[ DB ] CONNECT:[ UseTime:0.001103s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.002649s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = 'e2ea6437376a3993a8b6b3f623aff78e' LIMIT 1 [ RunTime:0.000837s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5385,`search_last_hit_time`=1773783724 WHERE `search_key` = 'e2ea6437376a3993a8b6b3f623aff78e' [ RunTime:0.008350s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.003991s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('B') AND `type_id` IN (22) AND ( vod_id IN (179,182,296,333,381,382,383,384,391,399,457,458,489,627,647,732,775,785,849,886,887,889,891,901,905,959,963,967,1004,1008,1015,1022,1023,1024,1047,1122,1189,1327,1429,1464,1467,1554,1564,1649,1747,1960,1981,2042,2053,2327,2778,2898,2900,2983,3028,3044,3091,3143,3185,3244,3749,3769,4072,4086,4098,4156,4176,4252,4253,4256,4257,4282,4319,4393,4478,4603,4646,4738,5083,5162,5196,5332,6576,6593,11859,12038,12057,12319,12622,12645,12680,12725,12732,12759,12908,12993,13045,13097,13146,13181,13184,13263,13277,13373,13383,13425,13522,13550,13597,13615,13666,13676,13702,13780,13845,13971,13982,14030,14084,14111,14160,14195,14290,14307,14349,14367,14449,14499,14509,14526,14587,14604,14638,14664,14773,15497,15532,15625,15627,15682,15740,15776,15840,15853,15934,16165,16195,16230,16325,16601,16613,17193,17306,17326,17328,18003,18471,18483,18542,18582,18583,18693,18773,18821,18846,18906,18933,19016,19017,19035,19045,19050,19081,19471) ) LIMIT 1 [ RunTime:0.003979s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('B') AND `type_id` IN (22) AND ( vod_id IN (179,182,296,333,381,382,383,384,391,399,457,458,489,627,647,732,775,785,849,886,887,889,891,901,905,959,963,967,1004,1008,1015,1022,1023,1024,1047,1122,1189,1327,1429,1464,1467,1554,1564,1649,1747,1960,1981,2042,2053,2327,2778,2898,2900,2983,3028,3044,3091,3143,3185,3244,3749,3769,4072,4086,4098,4156,4176,4252,4253,4256,4257,4282,4319,4393,4478,4603,4646,4738,5083,5162,5196,5332,6576,6593,11859,12038,12057,12319,12622,12645,12680,12725,12732,12759,12908,12993,13045,13097,13146,13181,13184,13263,13277,13373,13383,13425,13522,13550,13597,13615,13666,13676,13702,13780,13845,13971,13982,14030,14084,14111,14160,14195,14290,14307,14349,14367,14449,14499,14509,14526,14587,14604,14638,14664,14773,15497,15532,15625,15627,15682,15740,15776,15840,15853,15934,16165,16195,16230,16325,16601,16613,17193,17306,17326,17328,18003,18471,18483,18542,18582,18583,18693,18773,18821,18846,18906,18933,19016,19017,19035,19045,19050,19081,19471) ) ORDER BY `vod_hits` DESC LIMIT 0,72 [ RunTime:0.004233s ]
