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 (
    13126, 13127, 13128, 13129, 13130, 13131, 
    13132, 13133, 13098, 13099, 13100, 
    13101, 13102, 13103, 13104, 13105, 
    13106, 13107, 13108, 13109, 13110, 
    13111, 13112, 13113, 13114, 13115, 
    13116, 13117, 13118, 13119, 13120, 
    13121, 13122, 13123, 13064, 13065, 
    13066, 13067, 13068, 13069, 13070, 
    13071, 13072, 13073, 13074, 13075, 
    13076, 13077, 13078, 13079, 13080, 
    13081, 13082, 13083, 13084, 13085, 
    13086, 13087, 13088, 13089, 13090, 
    13091, 13092, 13093, 13094, 13095, 
    13096, 13097
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00230

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "266.41"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "116.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": 116,
            "rows_produced_per_join": 116,
            "filtered": "100.00",
            "index_condition": "((`gaseus`.`cscart_images_links`.`object_type` = 'product') and (`gaseus`.`cscart_images_links`.`type` = 'M') and (`gaseus`.`cscart_images_links`.`object_id` in (13126,13127,13128,13129,13130,13131,13132,13133,13098,13099,13100,13101,13102,13103,13104,13105,13106,13107,13108,13109,13110,13111,13112,13113,13114,13115,13116,13117,13118,13119,13120,13121,13122,13123,13064,13065,13066,13067,13068,13069,13070,13071,13072,13073,13074,13075,13076,13077,13078,13079,13080,13081,13082,13083,13084,13085,13086,13087,13088,13089,13090,13091,13092,13093,13094,13095,13096,13097)))",
            "cost_info": {
              "read_cost": "57.61",
              "eval_cost": "11.60",
              "prefix_cost": "69.21",
              "data_read_per_join": "10K"
            },
            "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": [
              "gaseus.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 116,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "29.00",
              "eval_cost": "11.60",
              "prefix_cost": "109.81",
              "data_read_per_join": "88K"
            },
            "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": [
              "gaseus.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 116,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "29.00",
              "eval_cost": "11.60",
              "prefix_cost": "150.41",
              "data_read_per_join": "68K"
            },
            "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 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
0 Seite-17-BS100-300_600x600.jpg 600 400 N 18811 13098 product 22292 M 0 22292
0 Seite-17-BS100-3008ZVTCsvtFi0Fk_600x600.jpg 600 400 N 18812 13099 product 22293 M 0 22293
0 Seite-17-BS100-300iTleWaE9519D9_600x600.jpg 600 400 N 18813 13100 product 22294 M 0 22294
0 Seite-17-BS100-300RqxMC4mCIJWry_600x600.jpg 600 400 N 18814 13101 product 22295 M 0 22295
0 Seite-17-BS100-300EZoXamPd5rIqQ_600x600.jpg 600 400 N 18815 13102 product 22296 M 0 22296
0 Seite-17-BS100-300nID9u0XVsw3S7_600x600.jpg 600 400 N 18816 13103 product 22297 M 0 22297
0 Seite-17-BS100-300xxH2swgRzfxLa_600x600.jpg 600 400 N 18817 13104 product 22298 M 0 22298
0 Seite-17-BS120-300_600x600.jpg 600 400 N 18818 13105 product 22299 M 0 22299
0 Seite-17-BS120-300H1nf8bFTLXYg7_600x600.jpg 600 400 N 18819 13106 product 22300 M 0 22300
0 Seite-17-BS120-300buSlinsWwtu3I_600x600.jpg 600 400 N 18820 13107 product 22301 M 0 22301
0 Seite-17-BS120-300t8WPmykGzLL0k_600x600.jpg 600 400 N 18821 13108 product 22302 M 0 22302
0 Seite-17-BS120-3002z5QRrVBaNI96_600x600.jpg 600 400 N 18822 13109 product 22303 M 0 22303
0 Seite-17-BS120-300sSAR30ClyRiYf_600x600.jpg 600 400 N 18823 13110 product 22304 M 0 22304
0 Seite-17-BS120-300ZYpkp2h94QXaO_600x600.jpg 600 400 N 18824 13111 product 22305 M 0 22305
0 414-380-neu-BS-200-300_600x600.jpg 600 400 N 18825 13112 product 22306 M 0 22306
0 414-380-neu-BS-200-3002PgghGeKZzfeB_600x600.jpg 600 400 N 18826 13113 product 22307 M 0 22307
0 414-380-neu-BS-200-300Mp6p22siJIxKV_600x600.jpg 600 400 N 18827 13114 product 22308 M 0 22308
0 414-380-neu-BS-200-300VOSMcQeNFLpgR_600x600.jpg 600 400 N 18828 13115 product 22309 M 0 22309
0 414-380-neu-BS-200-300WCRA9ZFrP5Fxm_600x600.jpg 600 400 N 18829 13116 product 22310 M 0 22310
0 414-380-neu-BS-200-300ovvI92RRY8Fcu_600x600.jpg 600 400 N 18830 13117 product 22311 M 0 22311
0 414-381-BS-300-270_600x600.jpg 600 400 N 18831 13118 product 22312 M 0 22312
0 414-381-BS-300-270szFcxo8wcWIYX_600x600.jpg 600 400 N 18832 13119 product 22313 M 0 22313
0 414-381-BS-300-270CT4Vr6IhM7YDd_600x600.jpg 600 400 N 18833 13120 product 22314 M 0 22314
0 414-381-BS-300-270ivjKg7G73gHT6_600x600.jpg 600 400 N 18834 13121 product 22315 M 0 22315
0 414-381-BS-300-270jNFwuixuIGdxY_600x600.jpg 600 400 N 18835 13122 product 22316 M 0 22316
0 414-381-BS-300-270uLUT3V46Q7i4B_600x600.jpg 600 400 N 18836 13123 product 22317 M 0 22317
0 414-940-BSA-40B-Acetylen_600x600.jpg 600 400 N 18839 13126 product 22320 M 0 22320
0 Seite-63-474-310-BS-50-300-LabLine_600x600.jpg 600 400 N 18840 13127 product 22321 M 0 22321
0 Seite-63-474-310-BS-50-300-LabLinepB4avxtQSV3da_600x600.jpg 600 400 N 18841 13128 product 22322 M 0 22322
0 Seite-63-474-310-BS-50-300-LabLineJwpphJcukclTh_600x600.jpg 600 400 N 18842 13129 product 22323 M 0 22323
0 Seite-63-474-310-BS-50-300-LabLinev6trbPfjN5C8I_600x600.jpg 600 400 N 18843 13130 product 22324 M 0 22324
0 Seite-63-474-310-BS-50-300-LabLinerjkWUnF3lxOhu_600x600.jpg 600 400 N 18844 13131 product 22325 M 0 22325
0 Seite-63-474-310-BS-50-300-LabLinelsAAWOot1HEfG_600x600.jpg 600 400 N 18845 13132 product 22326 M 0 22326
0 Seite-63-474-310-BS-50-300-LabLineB7L85hw9QqMTW_600x600.jpg 600 400 N 18846 13133 product 22327 M 0 22327