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.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 = 'ro' 
WHERE 
  cscart_images_links.object_type = 'category' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    6706, 
    3142, 
    11870, 
    8520, 
    7348, 
    3139, 
    8448, 
    8341, 
    3204, 
    1035, 
    3130, 
    1879, 
    1722, 
    2799, 
    21682, 
    8425, 
    23891, 
    28395, 
    6342, 
    43883, 
    1098, 
    37433, 
    8441, 
    11594, 
    11596, 
    11582, 
    8170, 
    11653, 
    8172, 
    11583, 
    11581, 
    8256, 
    11600, 
    8252, 
    37512, 
    6634, 
    37432, 
    37435, 
    37448, 
    8210, 
    8213, 
    8180, 
    1409, 
    8195, 
    8242, 
    8229, 
    29877, 
    11605, 
    8212, 
    8217, 
    8220, 
    8222, 
    8233, 
    23498, 
    27987, 
    8669, 
    3168, 
    8182, 
    3121, 
    37516, 
    37517, 
    8296, 
    30134, 
    5286, 
    37498, 
    32577, 
    16871, 
    8174, 
    8190, 
    16578, 
    8351, 
    8424, 
    23187, 
    37450, 
    8359, 
    37479, 
    8255, 
    8235, 
    14566, 
    15690, 
    8377, 
    37552, 
    8385, 
    8388, 
    37493, 
    8390, 
    8394, 
    8100, 
    37480, 
    37481, 
    3118, 
    8413, 
    8192, 
    14541, 
    8185, 
    8176, 
    8156, 
    8189, 
    8436, 
    8443, 
    8498, 
    8135, 
    8302, 
    3127, 
    8404, 
    3157, 
    8378, 
    8365, 
    8183, 
    8440, 
    8254, 
    29879, 
    5257, 
    8490, 
    8379, 
    8491, 
    37454, 
    11580, 
    37590, 
    3380, 
    8512, 
    11599, 
    13453, 
    37513, 
    11615, 
    37518, 
    14644, 
    37594, 
    37569, 
    37570, 
    3259, 
    19342, 
    8266, 
    8197, 
    19451, 
    30514, 
    8238, 
    8272, 
    30404, 
    8414, 
    8187, 
    8246, 
    8286, 
    19381, 
    8399, 
    8549, 
    7391, 
    8361, 
    8305, 
    7896, 
    8555, 
    37508, 
    8298, 
    8556, 
    16591, 
    16970, 
    8460, 
    37556, 
    19435, 
    8370, 
    37525, 
    14936, 
    14486, 
    8257, 
    8218, 
    8326, 
    14864, 
    8193, 
    8426, 
    11590, 
    8572, 
    37507, 
    8313, 
    8352, 
    8149, 
    8592, 
    7911, 
    37595, 
    16837, 
    11603, 
    14480, 
    37429, 
    11611, 
    37499, 
    37504, 
    37578, 
    8204, 
    8315, 
    8231, 
    8317, 
    16853, 
    37437, 
    11587, 
    37431, 
    37496, 
    11586, 
    37567, 
    8660, 
    8661, 
    8659, 
    8662, 
    21117, 
    3178, 
    37439, 
    8666, 
    5157, 
    8196, 
    8593, 
    21226, 
    23455, 
    29880
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.02224

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1070.41"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "211.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": 211,
            "rows_produced_per_join": 211,
            "filtered": "100.00",
            "index_condition": "((`maniamall_cscart`.`cscart_images_links`.`object_type` = 'category') and (`maniamall_cscart`.`cscart_images_links`.`type` = 'M') and (`maniamall_cscart`.`cscart_images_links`.`object_id` in (6706,3142,11870,8520,7348,3139,8448,8341,3204,1035,3130,1879,1722,2799,21682,8425,23891,28395,6342,43883,1098,37433,8441,11594,11596,11582,8170,11653,8172,11583,11581,8256,11600,8252,37512,6634,37432,37435,37448,8210,8213,8180,1409,8195,8242,8229,29877,11605,8212,8217,8220,8222,8233,23498,27987,8669,3168,8182,3121,37516,37517,8296,30134,5286,37498,32577,16871,8174,8190,16578,8351,8424,23187,37450,8359,37479,8255,8235,14566,15690,8377,37552,8385,8388,37493,8390,8394,8100,37480,37481,3118,8413,8192,14541,8185,8176,8156,8189,8436,8443,8498,8135,8302,3127,8404,3157,8378,8365,8183,8440,8254,29879,5257,8490,8379,8491,37454,11580,37590,3380,8512,11599,13453,37513,11615,37518,14644,37594,37569,37570,3259,19342,8266,8197,19451,30514,8238,8272,30404,8414,8187,8246,8286,19381,8399,8549,7391,8361,8305,7896,8555,37508,8298,8556,16591,16970,8460,37556,19435,8370,37525,14936,14486,8257,8218,8326,14864,8193,8426,11590,8572,37507,8313,8352,8149,8592,7911,37595,16837,11603,14480,37429,11611,37499,37504,37578,8204,8315,8231,8317,16853,37437,11587,37431,37496,11586,37567,8660,8661,8659,8662,21117,3178,37439,8666,5157,8196,8593,21226,23455,29880)))",
            "cost_info": {
              "read_cost": "404.22",
              "eval_cost": "21.10",
              "prefix_cost": "425.32",
              "data_read_per_join": "19K"
            },
            "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": "3",
            "ref": [
              "maniamall_cscart.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 211,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "199.88",
              "eval_cost": "21.10",
              "prefix_cost": "646.30",
              "data_read_per_join": "161K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_images), (`maniamall_cscart`.`cscart_images_links`.`detailed_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
          }
        },
        {
          "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": "107",
            "ref": [
              "maniamall_cscart.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 211,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "192.01",
              "eval_cost": "21.10",
              "prefix_cost": "859.41",
              "data_read_per_join": "125K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_common_descriptions), (`maniamall_cscart`.`cscart_common_descriptions`.`object_id` = `maniamall_cscart`.`cscart_images`.`image_id`), true)"
          }
        }
      ]
    }
  }
}

Result