SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_id AS images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id 
  LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id 
  AND cscart_common_descriptions.object_holder = 'images' 
  AND cscart_common_descriptions.lang_code = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    11173, 11177, 11181, 11174, 11176, 11175, 
    11324, 11319, 11323, 11322, 11321, 
    11320, 11334, 11329, 11333, 11332, 
    11331, 11330, 11276, 11271, 11275, 
    11274, 11273, 11272, 11286, 11281, 
    11285, 11284, 11283, 11282, 11300, 
    11296, 11291, 11295, 11294, 11293, 
    11292, 11314, 11310, 11305, 11309, 
    11308, 11307, 11306, 11252, 11248, 
    11243, 11247, 11246, 11245, 11244, 
    11266, 11262, 11257, 11261, 11260, 
    11259, 11258, 11342, 11339, 11341, 
    11340, 11229, 11238, 11234, 11233, 
    11232, 11231, 11230, 11217, 11221, 
    11225, 11218, 11219, 11220
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00582

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "180.01"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "75.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_images_links",
            "access_type": "range",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type",
              "type"
            ],
            "key_length": "81",
            "rows_examined_per_scan": 75,
            "rows_produced_per_join": 75,
            "filtered": "100.00",
            "index_condition": "((`dev_yourmart_co_bw`.`cscart_images_links`.`object_type` = 'product') and (`dev_yourmart_co_bw`.`cscart_images_links`.`type` = 'M') and (`dev_yourmart_co_bw`.`cscart_images_links`.`object_id` in (11173,11177,11181,11174,11176,11175,11324,11319,11323,11322,11321,11320,11334,11329,11333,11332,11331,11330,11276,11271,11275,11274,11273,11272,11286,11281,11285,11284,11283,11282,11300,11296,11291,11295,11294,11293,11292,11314,11310,11305,11309,11308,11307,11306,11252,11248,11243,11247,11246,11245,11244,11266,11262,11257,11261,11260,11259,11258,11342,11339,11341,11340,11229,11238,11234,11233,11232,11231,11230,11217,11221,11225,11218,11219,11220)))",
            "cost_info": {
              "read_cost": "45.01",
              "eval_cost": "7.50",
              "prefix_cost": "52.51",
              "data_read_per_join": "7K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "dev_yourmart_co_bw.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 75,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "18.75",
              "eval_cost": "7.50",
              "prefix_cost": "78.76",
              "data_read_per_join": "57K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_common_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "lang_code",
              "object_holder"
            ],
            "key_length": "108",
            "ref": [
              "dev_yourmart_co_bw.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 75,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "18.75",
              "eval_cost": "7.50",
              "prefix_cost": "105.01",
              "data_read_per_join": "44K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}