[ DB ] CONNECT:[ UseTime:0.001041s ] mysql:host=172.18.0.2;port=3306;dbname=hcan;charset=utf8
[ SQL ] SHOW COLUMNS FROM `can_vod_search` [ RunTime:0.003692s ]
[ SQL ] SELECT `search_result_ids`,`search_hit_count` FROM `can_vod_search` WHERE `search_key` = '93360d24dd4e8d0f1e7a316a55ed1148' LIMIT 1 [ RunTime:0.000954s ]
[ SQL ] UPDATE `can_vod_search` SET `search_hit_count`=5315,`search_last_hit_time`=1773803185 WHERE `search_key` = '93360d24dd4e8d0f1e7a316a55ed1148' [ RunTime:0.011763s ]
[ SQL ] SHOW COLUMNS FROM `can_vod` [ RunTime:0.004188s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('B') AND `type_id` IN (21) AND ( vod_id IN (273,274,750,752,819,1162,1163,1173,1183,1279,1280,1390,1722,1772,2243,2244,2371,2597,2646,2647,2648,2649,2650,2651,2746,2794,2849,2860,2865,2968,2985,3079,3080,3225,3312,3398,3449,3457,3562,3580,3581,3666,3668,3669,3670,3671,3672,3753,3830,3875,3889,3906,3941,3952,3966,3978,4025,4054,4126,4140,4176,4219,4225,4246,4247,4248,4249,4277,4278,4284,4349,4350,4351,4354,4359,4360,4375,4379,4381,4385,4386,4387,4389,4390,4399,4437,4440,4441,4444,4445,4446,4447,4507,4511,4512,4513,4523,4524,4525,4526,4527,4528,4529,4532,4533,4535,4536,4537,4541,4542,4543,4548,4549,4628,4658,4664,4677,4749,4757,4764,4779,4787,4789,4843,4850,4878,4901,4902,4903,4905,4907,4918,4976,4991,4993,4994,5011,5033,5036,5037,5043,5074,5084,5119,5138,5148,5150,5151,5155,5180,5226,5297,5306,5308,5309,5310,5487,5488,5561,6577,12104,12105,12106,12107,12108,12109,12110,12111,12112,12113,12221,12222,12223,12318,12671,12699,12931,13061,13114,13157,13217,13245,13280,13303,13350,13448,13607,13685,13705,13905,13945,14075,14132,14137,14316,14850,15280,15324,15337,15354,15371,15373,15385,15386,15419,15479,15496,15573,15692,15715,15752,15760,15766,15772,15783,15786,15790,15793,15794,15800,15839,15850,15858,15872,15877,15887,15889,15893,15895,15896,15898,15899,15920,15922,15945,15950,15953,15955,15958,15988,15999,16025,16034,16068,16070,16078,16084,16095,16110,16111,16142,16145,16161,16167,16168,16173,16175,16176,16184,16196,16201,16209,16213,16232,16245,16252,16274,16276,16284,16289,16291,16327,16332,16335,16339,16342,16349,16358,16364,16368,16372,16387,16389,16414,16422,16425,16427,16442,16445,16453,16475,16478,16487,16496,16500,16509,16512,16513,16528,16532,16543,16544,16555,16559,16562,16566,16572,16573,16584,16598,16602,16610,16615,16797,16817,17184,17189,17190,17191,17285,17368,17478,17868,17899,17900,17953,17967,18056,18148,18211,18212,18213,18214,18303,18316,18353,18385,18387,18461,18480,18481,18506,18511,18512,18513,18514,18515,18549,18550,18590,18608,18609,18649,18651,18665,18686,18695,18697,18705,18708,18721,18724,18726,18730,18742,18766,18779,18792,18794,18795,18839,18840,18843,18845,18854,18856,18920,18922,18923,18924,18925,18927,18928,18930,18932,18934,18938,18939,18943,18944,18947,18959,18960,18964,18969,18973,19033,19034,19037,19054,19059,19060,19065,19076,19083,19101,19110,19113,19115,19125,19126,19127,19129,19176,19231,19232,19303,19399,19484,19492,19538,19567,19569,19591,19606,19628,19686,19687,19723,19724,19736,19755,19779,19805,19836,19840,19841,19857,19858,19859,19860,19904,19905,19906,19907,19908,19920,19928,19935,19959,19962,19994,19998,19999,20009) ) LIMIT 1 [ RunTime:0.010445s ]
[ SQL ] SELECT * FROM `can_vod` WHERE `vod_status` = 1 AND `vod_letter` IN ('B') AND `type_id` IN (21) AND ( vod_id IN (273,274,750,752,819,1162,1163,1173,1183,1279,1280,1390,1722,1772,2243,2244,2371,2597,2646,2647,2648,2649,2650,2651,2746,2794,2849,2860,2865,2968,2985,3079,3080,3225,3312,3398,3449,3457,3562,3580,3581,3666,3668,3669,3670,3671,3672,3753,3830,3875,3889,3906,3941,3952,3966,3978,4025,4054,4126,4140,4176,4219,4225,4246,4247,4248,4249,4277,4278,4284,4349,4350,4351,4354,4359,4360,4375,4379,4381,4385,4386,4387,4389,4390,4399,4437,4440,4441,4444,4445,4446,4447,4507,4511,4512,4513,4523,4524,4525,4526,4527,4528,4529,4532,4533,4535,4536,4537,4541,4542,4543,4548,4549,4628,4658,4664,4677,4749,4757,4764,4779,4787,4789,4843,4850,4878,4901,4902,4903,4905,4907,4918,4976,4991,4993,4994,5011,5033,5036,5037,5043,5074,5084,5119,5138,5148,5150,5151,5155,5180,5226,5297,5306,5308,5309,5310,5487,5488,5561,6577,12104,12105,12106,12107,12108,12109,12110,12111,12112,12113,12221,12222,12223,12318,12671,12699,12931,13061,13114,13157,13217,13245,13280,13303,13350,13448,13607,13685,13705,13905,13945,14075,14132,14137,14316,14850,15280,15324,15337,15354,15371,15373,15385,15386,15419,15479,15496,15573,15692,15715,15752,15760,15766,15772,15783,15786,15790,15793,15794,15800,15839,15850,15858,15872,15877,15887,15889,15893,15895,15896,15898,15899,15920,15922,15945,15950,15953,15955,15958,15988,15999,16025,16034,16068,16070,16078,16084,16095,16110,16111,16142,16145,16161,16167,16168,16173,16175,16176,16184,16196,16201,16209,16213,16232,16245,16252,16274,16276,16284,16289,16291,16327,16332,16335,16339,16342,16349,16358,16364,16368,16372,16387,16389,16414,16422,16425,16427,16442,16445,16453,16475,16478,16487,16496,16500,16509,16512,16513,16528,16532,16543,16544,16555,16559,16562,16566,16572,16573,16584,16598,16602,16610,16615,16797,16817,17184,17189,17190,17191,17285,17368,17478,17868,17899,17900,17953,17967,18056,18148,18211,18212,18213,18214,18303,18316,18353,18385,18387,18461,18480,18481,18506,18511,18512,18513,18514,18515,18549,18550,18590,18608,18609,18649,18651,18665,18686,18695,18697,18705,18708,18721,18724,18726,18730,18742,18766,18779,18792,18794,18795,18839,18840,18843,18845,18854,18856,18920,18922,18923,18924,18925,18927,18928,18930,18932,18934,18938,18939,18943,18944,18947,18959,18960,18964,18969,18973,19033,19034,19037,19054,19059,19060,19065,19076,19083,19101,19110,19113,19115,19125,19126,19127,19129,19176,19231,19232,19303,19399,19484,19492,19538,19567,19569,19591,19606,19628,19686,19687,19723,19724,19736,19755,19779,19805,19836,19840,19841,19857,19858,19859,19860,19904,19905,19906,19907,19908,19920,19928,19935,19959,19962,19994,19998,19999,20009) ) ORDER BY `vod_score` DESC LIMIT 0,72 [ RunTime:0.009068s ]
