Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    11173, 
    11178, 
    11184, 
    11177, 
    11183, 
    11175, 
    11182, 
    11174, 
    11181, 
    11176, 
    11180, 
    11179, 
    11229, 
    11242, 
    11241, 
    11240, 
    11239, 
    11238, 
    11237, 
    11236, 
    11235, 
    11234, 
    11233, 
    11232, 
    11231, 
    11230, 
    11256, 
    11255, 
    11254, 
    11253, 
    11252, 
    11251, 
    11250, 
    11249, 
    11248, 
    11247, 
    11246, 
    11245, 
    11244, 
    11243, 
    11270, 
    11269, 
    11268, 
    11267, 
    11266, 
    11265, 
    11264, 
    11263, 
    11262, 
    11261, 
    11260, 
    11259, 
    11258, 
    11257, 
    11280, 
    11279, 
    11278, 
    11277, 
    11276, 
    11275, 
    11274, 
    11273, 
    11272, 
    11271, 
    11290, 
    11289, 
    11288, 
    11287, 
    11286, 
    11285, 
    11284, 
    11283, 
    11282, 
    11281, 
    11304, 
    11303, 
    11302, 
    11301, 
    11300, 
    11299, 
    11298, 
    11297, 
    11296, 
    11295, 
    11294, 
    11293, 
    11292, 
    11291, 
    11318, 
    11317, 
    11316, 
    11315, 
    11314, 
    11313, 
    11312, 
    11311, 
    11310, 
    11309, 
    11308, 
    11307, 
    11306, 
    11305, 
    11328, 
    11327, 
    11326, 
    11325, 
    11324, 
    11323, 
    11322, 
    11321, 
    11320, 
    11319, 
    11338, 
    11337, 
    11336, 
    11335, 
    11334, 
    11333, 
    11332, 
    11331, 
    11330, 
    11329, 
    11344, 
    11343, 
    11342, 
    11341, 
    11340, 
    11339, 
    11217, 
    11218, 
    11219, 
    11220, 
    11221, 
    11222, 
    11223, 
    11224, 
    11225, 
    11226, 
    11227, 
    11228
  ) 
  AND status = "A"

Query time 0.00086

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": "80"
      },
      "used_columns": [
        "video_id",
        "product_id",
        "status"
      ],
      "attached_condition": "(`dev_yourmart_co_bw`.`cscart_ab__video_gallery`.`product_id` in (11173,11178,11184,11177,11183,11175,11182,11174,11181,11176,11180,11179,11229,11242,11241,11240,11239,11238,11237,11236,11235,11234,11233,11232,11231,11230,11256,11255,11254,11253,11252,11251,11250,11249,11248,11247,11246,11245,11244,11243,11270,11269,11268,11267,11266,11265,11264,11263,11262,11261,11260,11259,11258,11257,11280,11279,11278,11277,11276,11275,11274,11273,11272,11271,11290,11289,11288,11287,11286,11285,11284,11283,11282,11281,11304,11303,11302,11301,11300,11299,11298,11297,11296,11295,11294,11293,11292,11291,11318,11317,11316,11315,11314,11313,11312,11311,11310,11309,11308,11307,11306,11305,11328,11327,11326,11325,11324,11323,11322,11321,11320,11319,11338,11337,11336,11335,11334,11333,11332,11331,11330,11329,11344,11343,11342,11341,11340,11339,11217,11218,11219,11220,11221,11222,11223,11224,11225,11226,11227,11228))"
    }
  }
}