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 (
    13064, 13065, 13066, 13067, 13068, 13069, 
    13070, 13073, 13074, 13075, 13076, 
    13077, 13071, 13072, 13078, 13079, 
    13080, 13081, 13082, 13083, 13084, 
    13085, 13086, 13087, 13088, 13089, 
    13090, 13093, 13094, 13095, 13096, 
    13097, 13091, 13092, 12956, 12957, 
    12958, 12959
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00198

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "99.81"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "42.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": 42,
            "rows_produced_per_join": 42,
            "filtered": "100.00",
            "index_condition": "((`test2_gaseus`.`cscart_images_links`.`object_type` = 'product') and (`test2_gaseus`.`cscart_images_links`.`type` = 'M') and (`test2_gaseus`.`cscart_images_links`.`object_id` in (13064,13065,13066,13067,13068,13069,13070,13073,13074,13075,13076,13077,13071,13072,13078,13079,13080,13081,13082,13083,13084,13085,13086,13087,13088,13089,13090,13093,13094,13095,13096,13097,13091,13092,12956,12957,12958,12959)))",
            "cost_info": {
              "read_cost": "24.21",
              "eval_cost": "4.20",
              "prefix_cost": "28.41",
              "data_read_per_join": "3K"
            },
            "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": [
              "test2_gaseus.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 42,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "10.50",
              "eval_cost": "4.20",
              "prefix_cost": "43.11",
              "data_read_per_join": "32K"
            },
            "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": [
              "test2_gaseus.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 42,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "10.50",
              "eval_cost": "4.20",
              "prefix_cost": "57.81",
              "data_read_per_join": "24K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}

Result

image_id image_path image_x image_y is_high_res pair_id object_id object_type detailed_id type position alt images_image_id
0 410-908-EB10-AcetylenxvFBUFZW1oTPD_600x600.jpg 600 400 N 18669 12956 product 22150 M 0 22150
0 410-908-EB10-Acetylen_600x600.jpg 600 400 N 18670 12957 product 22151 M 0 22151
0 410-909-EB20H10XGfdigVsz8_600x600.jpg 600 400 N 18671 12958 product 22152 M 0 22152
0 410-909-EB20_600x600.jpg 600 400 N 18672 12959 product 22153 M 0 22153
0 1390990147-13800_600x600.jpg 500 230 N 18777 13064 product 22258 M 0 22258
0 1406103606-21428_600x600.jpg 500 230 N 18778 13065 product 22259 M 0 22259
0 1390989077-22610_600x600.jpg 500 230 N 18779 13066 product 22260 M 0 22260
0 1390989405-30666_600x600.jpg 500 230 N 18780 13067 product 22261 M 0 22261
0 1390989688-4340_600x600.jpg 500 230 N 18781 13068 product 22262 M 0 22262
0 BS-50_600x600.jpg 500 230 N 18782 13069 product 22263 M 0 22263
0 1390989900-8067_600x600.jpg 500 230 N 18783 13070 product 22264 M 0 22264
0 414-820-BS60-300_600x600.jpg 600 400 N 18784 13071 product 22265 M 0 22265
0 414-820-BS60-300APaPlWwlqWEv4_600x600.jpg 600 400 N 18785 13072 product 22266 M 0 22266
0 414-820-BS60-300DEriYc88esQwY_600x600.jpg 600 400 N 18786 13073 product 22267 M 0 22267
0 414-820-BS60-300cGOlXsf0CmUId_600x600.jpg 600 400 N 18787 13074 product 22268 M 0 22268
0 414-820-BS60-300XJXQ0MyIeMnCX_600x600.jpg 600 400 N 18788 13075 product 22269 M 0 22269
0 414-820-BS60-300jHjv2KHp0SV6F_600x600.jpg 600 400 N 18789 13076 product 22270 M 0 22270
0 414-820-BS60-300oM75SRIWkZlYE_600x600.jpg 600 400 N 18790 13077 product 22271 M 0 22271
0 414822-Basisstation-BS70-300-Effect-Seite-16_600x600.jpg 600 267 N 18791 13078 product 22272 M 0 22272
0 414822-Basisstation-BS70-300-Effect-Seite-161bo2YEDZz80RI_600x600.jpg 600 267 N 18792 13079 product 22273 M 0 22273
0 414822-Basisstation-BS70-300-Effect-Seite-16J0elFdYc1tnqW_600x600.jpg 600 267 N 18793 13080 product 22274 M 0 22274
0 414822-Basisstation-BS70-300-Effect-Seite-16l3NrEcXdCQvdO_600x600.jpg 600 267 N 18794 13081 product 22275 M 0 22275
0 414822-Basisstation-BS70-300-Effect-Seite-16O3OiP3pKwSfv8_600x600.jpg 600 267 N 18795 13082 product 22276 M 0 22276
0 414822-Basisstation-BS70-300-Effect-Seite-16Mc1NW6vhpueFI_600x600.jpg 600 267 N 18796 13083 product 22277 M 0 22277
0 414822-Basisstation-BS70-300-Effect-Seite-167tl7JAcPAyMrO_600x600.jpg 600 267 N 18797 13084 product 22278 M 0 22278
0 414823-Basisstation-BS75-300-Effect-Seite-17_600x600.jpg 600 277 N 18798 13085 product 22279 M 0 22279
0 414823-Basisstation-BS75-300-Effect-Seite-17WQwHazALmARga_600x600.jpg 600 277 N 18799 13086 product 22280 M 0 22280
0 414823-Basisstation-BS75-300-Effect-Seite-17EuaV3Cp0XgIHs_600x600.jpg 600 277 N 18800 13087 product 22281 M 0 22281
0 414823-Basisstation-BS75-300-Effect-Seite-17oZwfoluXCbuhS_600x600.jpg 600 277 N 18801 13088 product 22282 M 0 22282
0 414823-Basisstation-BS75-300-Effect-Seite-17q7bhR1NXMNlLN_600x600.jpg 600 277 N 18802 13089 product 22283 M 0 22283
0 414823-Basisstation-BS75-300-Effect-Seite-17u3QMSTb3XPTxv_600x600.jpg 600 277 N 18803 13090 product 22284 M 0 22284
0 Seite-17-BS-80-300-Effect_600x600.jpg 600 309 N 18804 13091 product 22285 M 0 22285
0 Seite-17-BS-80-300-EffectAcSfXnPhQvxGm_600x600.jpg 600 309 N 18805 13092 product 22286 M 0 22286
0 Seite-17-BS-80-300-EffecteoOUTfJXxApO0_600x600.jpg 600 309 N 18806 13093 product 22287 M 0 22287
0 Seite-17-BS-80-300-EffecterorIypxjXOWN_600x600.jpg 600 309 N 18807 13094 product 22288 M 0 22288
0 Seite-17-BS-80-300-EffectkhDf2nb5ksZag_600x600.jpg 600 309 N 18808 13095 product 22289 M 0 22289
0 Seite-17-BS-80-300-EffectaWyqIDT9ij6A2_600x600.jpg 600 309 N 18809 13096 product 22290 M 0 22290
0 Seite-17-BS-80-300-EffectkYRpcpmDw1WEB_600x600.jpg 600 309 N 18810 13097 product 22291 M 0 22291