SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    370, 3844, 3854, 3853, 3852, 3851, 3850, 
    3849, 3848, 3847, 3846, 3845, 3843, 
    3856, 3785, 3841, 3840, 3839, 3838, 
    3837, 3836, 3835, 3834, 3833, 3832, 
    3855, 3857, 3830, 3801, 3882, 3881, 
    3880, 3806, 3805, 3877, 3808, 3807, 
    3874, 3873, 3812, 3870, 3815, 3814, 
    3813, 3867, 3866, 3865, 3864, 3863, 
    3862, 3861, 3824, 3859, 3831, 3829, 
    3773, 3786, 3797, 3796, 3795, 3794, 
    3793, 3792, 3791, 3790, 3789, 3788, 
    3787, 3842, 3799, 3782, 3781, 3780, 
    3779, 3778, 3777, 3776, 3775, 3774, 
    3798, 3800, 3828, 3860, 3827, 3858, 
    3823, 3822, 3821, 3820, 3819, 3818, 
    3817, 3816, 3869, 3868, 3872, 3871, 
    3811, 3810, 3809, 3876, 3875, 3879, 
    3878, 3804, 3803, 3802, 3883, 3884
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00049

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ab__video_gallery",
      "access_type": "ref",
      "possible_keys": ["status", "product_id"],
      "key": "status",
      "key_length": "3",
      "used_key_parts": ["status"],
      "ref": ["const"],
      "rows": 1,
      "filtered": 100,
      "index_condition": "cscart_ab__video_gallery.`status` = 'A'",
      "attached_condition": "cscart_ab__video_gallery.product_id in (370,3844,3854,3853,3852,3851,3850,3849,3848,3847,3846,3845,3843,3856,3785,3841,3840,3839,3838,3837,3836,3835,3834,3833,3832,3855,3857,3830,3801,3882,3881,3880,3806,3805,3877,3808,3807,3874,3873,3812,3870,3815,3814,3813,3867,3866,3865,3864,3863,3862,3861,3824,3859,3831,3829,3773,3786,3797,3796,3795,3794,3793,3792,3791,3790,3789,3788,3787,3842,3799,3782,3781,3780,3779,3778,3777,3776,3775,3774,3798,3800,3828,3860,3827,3858,3823,3822,3821,3820,3819,3818,3817,3816,3869,3868,3872,3871,3811,3810,3809,3876,3875,3879,3878,3804,3803,3802,3883,3884) and cscart_ab__video_gallery.storefront_id in (1,0)"
    }
  }
}