SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  cscart_images.image_id AS images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.image_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 = 'category' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    '2958', '2959', '2960', '2961', '2962', 
    '2963', '2964', '2965', '3211', '3213', 
    '3214', '3212', '3210', '3655', '3656', 
    '2476', '2477', '3555', '3547', '2478', 
    '2479', '2480', '2481', '2482', '2483', 
    '2365', '308', '2304', '2403', '3557', 
    '3477', '3474', '3644', '3645', '3215', 
    '3344', '3345', '2485', '300', '304', 
    '302', '305', '2321', '307', '303', 
    '301', '309', '306', '2298', '189', 
    '203', '204', '206', '205', '207', 
    '2780', '2781', '2966', '2967', '2968', 
    '2969', '2970', '2971', '2972', '2973', 
    '2974', '3464', '3465', '3467', '3468', 
    '3666', '3752', '3788', '3885', '3901', 
    '3908'
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00149

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 89,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'category' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in ('2958','2959','2960','2961','2962','2963','2964','2965','3211','3213','3214','3212','3210','3655','3656','2476','2477','3555','3547','2478','2479','2480','2481','2482','2483','2365','308','2304','2403','3557','3477','3474','3644','3645','3215','3344','3345','2485','300','304','302','305','2321','307','303','301','309','306','2298','189','203','204','206','205','207','2780','2781','2966','2967','2968','2969','2970','2971','2972','2973','2974','3464','3465','3467','3468','3666','3752','3788','3885','3901','3908')"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["image_id"],
      "ref": ["rfswire_cart.cscart_images_links.image_id"],
      "rows": 1,
      "filtered": 100
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["rfswire_cart.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'en' and trigcond(cscart_images.image_id is not null))"
    }
  }
}