Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    908, 
    134, 
    919, 
    918, 
    924, 
    922, 
    921, 
    925, 
    525, 
    917, 
    916, 
    955, 
    942, 
    941, 
    446, 
    953, 
    952, 
    951, 
    949, 
    948, 
    947, 
    946, 
    945, 
    944, 
    982, 
    980, 
    979, 
    978, 
    981, 
    478, 
    977, 
    975, 
    974, 
    973, 
    972, 
    971, 
    970, 
    994, 
    996, 
    493, 
    985, 
    986, 
    988, 
    990, 
    991, 
    993, 
    1139, 
    1138, 
    1137, 
    1136, 
    1135, 
    1134, 
    1133, 
    1132, 
    1131, 
    1130, 
    1129, 
    827, 
    1254, 
    1253, 
    247, 
    1406, 
    1407, 
    1408, 
    1409, 
    1410, 
    1411, 
    1412, 
    1274, 
    1483, 
    1484, 
    1485, 
    1486, 
    1487, 
    2478, 
    2483, 
    2482, 
    2484, 
    2485, 
    2486, 
    2487, 
    2488, 
    2489, 
    2490, 
    2491, 
    2492, 
    2493, 
    2494, 
    2495, 
    2496, 
    2497, 
    2524, 
    2525, 
    2526, 
    2527, 
    2528, 
    2529, 
    2530, 
    2531, 
    8422, 
    2574, 
    2698, 
    3452, 
    3454, 
    3455, 
    3456, 
    3754, 
    3755, 
    3756, 
    3757, 
    3758, 
    3759, 
    3760, 
    3761, 
    3762, 
    3764, 
    3765, 
    1930, 
    3815, 
    3817, 
    3818, 
    4022, 
    4021, 
    4020, 
    4432, 
    4438, 
    4440, 
    4441, 
    4442, 
    4443, 
    4444, 
    4448, 
    4445, 
    4446, 
    4447, 
    6149, 
    5685, 
    6148, 
    6150, 
    6151, 
    5696, 
    5697, 
    5698, 
    5699, 
    5721, 
    5722, 
    5723, 
    5727, 
    5729, 
    5730, 
    5731, 
    5732, 
    5733, 
    5734, 
    5735, 
    5736, 
    5739, 
    5741, 
    5742, 
    5743, 
    5744, 
    5745, 
    5746, 
    5747, 
    5748, 
    5749, 
    5750, 
    5752, 
    5753, 
    5754, 
    5755, 
    5756, 
    5757, 
    5758, 
    5759, 
    5760, 
    5761, 
    5762, 
    7004, 
    7005, 
    7006, 
    7007, 
    7008, 
    7009, 
    7010, 
    7011, 
    7012, 
    7013, 
    7014, 
    7015, 
    10284, 
    10285, 
    10286, 
    10287, 
    10288, 
    10289, 
    10290, 
    10291, 
    10292, 
    10293
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00093

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.35"
    },
    "table": {
      "table_name": "cscart_ab__video_gallery",
      "access_type": "ref",
      "possible_keys": [
        "status",
        "product_id"
      ],
      "key": "status",
      "used_key_parts": [
        "status"
      ],
      "key_length": "3",
      "ref": [
        "const"
      ],
      "rows_examined_per_scan": 1,
      "rows_produced_per_join": 1,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.25",
        "eval_cost": "0.10",
        "prefix_cost": "0.35",
        "data_read_per_join": "96"
      },
      "used_columns": [
        "video_id",
        "product_id",
        "status",
        "storefront_id"
      ],
      "attached_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_ab__video_gallery`.`product_id` in (908,134,919,918,924,922,921,925,525,917,916,955,942,941,446,953,952,951,949,948,947,946,945,944,982,980,979,978,981,478,977,975,974,973,972,971,970,994,996,493,985,986,988,990,991,993,1139,1138,1137,1136,1135,1134,1133,1132,1131,1130,1129,827,1254,1253,247,1406,1407,1408,1409,1410,1411,1412,1274,1483,1484,1485,1486,1487,2478,2483,2482,2484,2485,2486,2487,2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2524,2525,2526,2527,2528,2529,2530,2531,8422,2574,2698,3452,3454,3455,3456,3754,3755,3756,3757,3758,3759,3760,3761,3762,3764,3765,1930,3815,3817,3818,4022,4021,4020,4432,4438,4440,4441,4442,4443,4444,4448,4445,4446,4447,6149,5685,6148,6150,6151,5696,5697,5698,5699,5721,5722,5723,5727,5729,5730,5731,5732,5733,5734,5735,5736,5739,5741,5742,5743,5744,5745,5746,5747,5748,5749,5750,5752,5753,5754,5755,5756,5757,5758,5759,5760,5761,5762,7004,7005,7006,7007,7008,7009,7010,7011,7012,7013,7014,7015,10284,10285,10286,10287,10288,10289,10290,10291,10292,10293)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_ab__video_gallery`.`storefront_id` in (1,0)))"
    }
  }
}