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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    217617, 
    215622, 
    215623, 
    217723, 
    217724, 
    238254, 
    217844, 
    217845, 
    218023, 
    218024, 
    218831, 
    218832, 
    218833, 
    220125, 
    218837, 
    218838, 
    218839, 
    220130, 
    215658, 
    215659, 
    238245, 
    220143, 
    244558, 
    244559, 
    244560, 
    244561, 
    244562, 
    244563, 
    244564, 
    244565, 
    216947, 
    216948, 
    216949, 
    216950, 
    216951, 
    216952, 
    236882, 
    236883, 
    216953, 
    245122, 
    241590, 
    216954, 
    216955, 
    216956, 
    216957, 
    216958, 
    241591, 
    216959, 
    216960, 
    216961, 
    216962, 
    216963, 
    216964, 
    216965, 
    216966, 
    241592, 
    216967, 
    241593, 
    216968, 
    216969, 
    245123, 
    245124, 
    225920, 
    216970, 
    216971, 
    245125, 
    241594, 
    220231, 
    217630, 
    217631, 
    217632, 
    220239, 
    216977, 
    216978, 
    216979, 
    216980, 
    216981, 
    216982, 
    220240, 
    216999, 
    217000, 
    217001, 
    220241, 
    217009, 
    217010, 
    217011, 
    220264, 
    216983, 
    216984, 
    216985, 
    220265, 
    217019, 
    217020, 
    217021, 
    217022, 
    217023, 
    217024, 
    236888, 
    236889, 
    217025, 
    245126, 
    241595, 
    217026, 
    217027, 
    217028, 
    217029, 
    217030, 
    241596, 
    217031, 
    217032, 
    217033, 
    217034, 
    217035, 
    217036, 
    217037, 
    217038, 
    241597, 
    217039, 
    241598, 
    217040, 
    217041, 
    245127, 
    245128, 
    217042, 
    217043, 
    217044, 
    245129, 
    241599, 
    220266, 
    244566, 
    244567, 
    244568, 
    244569, 
    244570, 
    244571, 
    244572, 
    244573, 
    220267, 
    244574, 
    244575, 
    244576, 
    244577, 
    244578, 
    244579, 
    244580, 
    244581, 
    220268, 
    217069, 
    217070, 
    217071, 
    217072, 
    217073, 
    217074, 
    236884, 
    236885, 
    217075, 
    245130, 
    241600, 
    217076, 
    217077, 
    217078, 
    217079, 
    217080, 
    241601, 
    217081, 
    217082, 
    217083, 
    217084, 
    217085, 
    217086, 
    217087, 
    217088, 
    241602, 
    217089, 
    241603, 
    217090, 
    217091, 
    245131, 
    245132, 
    217092, 
    217093, 
    217094, 
    245133, 
    241604, 
    220269, 
    217095, 
    217096, 
    217097, 
    217098, 
    217099, 
    217100, 
    236886, 
    236887, 
    217101, 
    241605, 
    217102, 
    217103, 
    217104, 
    217105, 
    217106, 
    241606, 
    217107, 
    217108, 
    217109, 
    217110, 
    217111, 
    217112, 
    217113, 
    217114, 
    241607, 
    217115, 
    241608, 
    217116, 
    217117, 
    225921, 
    217118, 
    217119, 
    241609, 
    220270, 
    244582, 
    244583, 
    244584, 
    244585, 
    244586, 
    244587, 
    244588, 
    244589, 
    220300, 
    215616, 
    215617, 
    220307, 
    215660, 
    215661, 
    215662, 
    215663, 
    215664, 
    215665, 
    215666, 
    215667, 
    215668, 
    215669, 
    215670, 
    215671, 
    215672, 
    215673, 
    243095, 
    243096, 
    243097, 
    243098, 
    220308, 
    215618, 
    215619, 
    220317, 
    217132, 
    217133, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    228071, 
    228069, 
    228070, 
    230951, 
    230952, 
    230953, 
    230954, 
    238250, 
    238248, 
    238249
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00263

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": 273,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (217617,215622,215623,217723,217724,238254,217844,217845,218023,218024,218831,218832,218833,220125,218837,218838,218839,220130,215658,215659,238245,220143,244558,244559,244560,244561,244562,244563,244564,244565,216947,216948,216949,216950,216951,216952,236882,236883,216953,245122,241590,216954,216955,216956,216957,216958,241591,216959,216960,216961,216962,216963,216964,216965,216966,241592,216967,241593,216968,216969,245123,245124,225920,216970,216971,245125,241594,220231,217630,217631,217632,220239,216977,216978,216979,216980,216981,216982,220240,216999,217000,217001,220241,217009,217010,217011,220264,216983,216984,216985,220265,217019,217020,217021,217022,217023,217024,236888,236889,217025,245126,241595,217026,217027,217028,217029,217030,241596,217031,217032,217033,217034,217035,217036,217037,217038,241597,217039,241598,217040,217041,245127,245128,217042,217043,217044,245129,241599,220266,244566,244567,244568,244569,244570,244571,244572,244573,220267,244574,244575,244576,244577,244578,244579,244580,244581,220268,217069,217070,217071,217072,217073,217074,236884,236885,217075,245130,241600,217076,217077,217078,217079,217080,241601,217081,217082,217083,217084,217085,217086,217087,217088,241602,217089,241603,217090,217091,245131,245132,217092,217093,217094,245133,241604,220269,217095,217096,217097,217098,217099,217100,236886,236887,217101,241605,217102,217103,217104,217105,217106,241606,217107,217108,217109,217110,217111,217112,217113,217114,241607,217115,241608,217116,217117,225921,217118,217119,241609,220270,244582,244583,244584,244585,244586,244587,244588,244589,220300,215616,215617,220307,215660,215661,215662,215663,215664,215665,215666,215667,215668,215669,215670,215671,215672,215673,243095,243096,243097,243098,220308,215618,215619,220317,217132,217133,223755,223756,223757,223758,223759,223760,223761,223762,228071,228069,228070,230951,230952,230953,230954,238250,238248,238249)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["image_id"],
      "ref": ["cscart_migrate.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "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": ["cscart_migrate.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))"
    }
  }
}

Result

pair_id object_id object_type image_id detailed_id type position image_type show_gallery gallery_category_id image_path alt image_x image_y images_image_id
33769 215619 variant_image 46002 0 V 0 D 0 0
33805 215658 variant_image 46038 0 V 0 D 0 0
33806 215659 variant_image 46039 0 V 0 D 0 0
33807 215660 variant_image 46040 0 V 0 D 0 0
33808 215661 variant_image 46041 0 V 0 D 0 0
33809 215662 variant_image 46042 0 V 0 D 0 0
33810 215663 variant_image 46043 0 V 0 D 0 0
33811 215664 variant_image 46044 0 V 0 D 0 0
33812 215665 variant_image 46045 0 V 0 D 0 0
33813 215666 variant_image 46046 0 V 0 D 0 0
33814 215667 variant_image 46047 0 V 0 D 0 0
33815 215668 variant_image 46048 0 V 0 D 0 0
33816 215669 variant_image 46049 0 V 0 D 0 0
33817 215670 variant_image 46050 0 V 0 D 0 0
33818 215671 variant_image 46051 0 V 0 D 0 0
33819 215672 variant_image 46052 0 V 0 D 0 0
33820 215673 variant_image 46053 0 V 0 D 0 0
33840 215618 variant_image 46073 0 V 0 D 0 0
34161 215616 variant_image 46394 0 V 0 D 0 0
34162 215617 variant_image 46395 0 V 0 D 0 0
35143 216947 variant_image 47376 0 V 0 D 0 0
35144 216948 variant_image 47377 0 V 0 D 0 0
35145 216949 variant_image 47378 0 V 0 D 0 0
35146 216950 variant_image 47379 0 V 0 D 0 0
35147 216951 variant_image 47380 0 V 0 D 0 0
35148 216952 variant_image 47381 0 V 0 D 0 0
35149 216953 variant_image 47382 0 V 0 D 0 0
35150 216954 variant_image 47383 0 V 0 D 0 0
35151 216955 variant_image 47384 0 V 0 D 0 0
35152 216956 variant_image 47385 0 V 0 D 0 0
35153 216957 variant_image 47386 0 V 0 D 0 0
35154 216958 variant_image 47387 0 V 0 D 0 0
35155 216959 variant_image 47388 0 V 0 D 0 0
35156 216960 variant_image 47389 0 V 0 D 0 0
35157 216961 variant_image 47390 0 V 0 D 0 0
35158 216962 variant_image 47391 0 V 0 D 0 0
35159 216963 variant_image 47392 0 V 0 D 0 0
35160 216964 variant_image 47393 0 V 0 D 0 0
35161 216965 variant_image 47394 0 V 0 D 0 0
35162 216966 variant_image 47395 0 V 0 D 0 0
35163 216967 variant_image 47396 0 V 0 D 0 0
35164 216968 variant_image 47397 0 V 0 D 0 0
35165 216969 variant_image 47398 0 V 0 D 0 0
35166 216970 variant_image 47399 0 V 0 D 0 0
35167 216971 variant_image 47400 0 V 0 D 0 0
35172 216977 variant_image 47405 0 V 0 D 0 0
35173 216978 variant_image 47406 0 V 0 D 0 0
35174 216979 variant_image 47407 0 V 0 D 0 0
35175 216980 variant_image 47408 0 V 0 D 0 0
35176 216981 variant_image 47409 0 V 0 D 0 0
35177 216982 variant_image 47410 0 V 0 D 0 0
35178 216983 variant_image 47411 0 V 0 D 0 0
35179 216984 variant_image 47412 0 V 0 D 0 0
35180 216985 variant_image 47413 0 V 0 D 0 0
35195 216999 variant_image 47428 0 V 0 D 0 0
35196 217000 variant_image 47429 0 V 0 D 0 0
35197 217001 variant_image 47430 0 V 0 D 0 0
35205 217009 variant_image 47438 0 V 0 D 0 0
35206 217010 variant_image 47439 0 V 0 D 0 0
35207 217011 variant_image 47440 0 V 0 D 0 0
35215 217019 variant_image 47448 0 V 0 D 0 0
35216 217020 variant_image 47449 0 V 0 D 0 0
35217 217021 variant_image 47450 0 V 0 D 0 0
35218 217022 variant_image 47451 0 V 0 D 0 0
35219 217023 variant_image 47452 0 V 0 D 0 0
35220 217024 variant_image 47453 0 V 0 D 0 0
35221 217025 variant_image 47454 0 V 0 D 0 0
35222 217026 variant_image 47455 0 V 0 D 0 0
35223 217027 variant_image 47456 0 V 0 D 0 0
35224 217028 variant_image 47457 0 V 0 D 0 0
35225 217029 variant_image 47458 0 V 0 D 0 0
35226 217030 variant_image 47459 0 V 0 D 0 0
35227 217031 variant_image 47460 0 V 0 D 0 0
35228 217032 variant_image 47461 0 V 0 D 0 0
35229 217033 variant_image 47462 0 V 0 D 0 0
35230 217034 variant_image 47463 0 V 0 D 0 0
35231 217035 variant_image 47464 0 V 0 D 0 0
35232 217036 variant_image 47465 0 V 0 D 0 0
35233 217037 variant_image 47466 0 V 0 D 0 0
35234 217038 variant_image 47467 0 V 0 D 0 0
35235 217039 variant_image 47468 0 V 0 D 0 0
35236 217040 variant_image 47469 0 V 0 D 0 0
35237 217041 variant_image 47470 0 V 0 D 0 0
35238 217042 variant_image 47471 0 V 0 D 0 0
35239 217043 variant_image 47472 0 V 0 D 0 0
35240 217044 variant_image 47473 0 V 0 D 0 0
35264 217069 variant_image 47497 0 V 0 D 0 0
35265 217070 variant_image 47498 0 V 0 D 0 0
35266 217071 variant_image 47499 0 V 0 D 0 0
35267 217072 variant_image 47500 0 V 0 D 0 0
35268 217073 variant_image 47501 0 V 0 D 0 0
35269 217074 variant_image 47502 0 V 0 D 0 0
35270 217075 variant_image 47503 0 V 0 D 0 0
35271 217076 variant_image 47504 0 V 0 D 0 0
35272 217077 variant_image 47505 0 V 0 D 0 0
35273 217078 variant_image 47506 0 V 0 D 0 0
35274 217079 variant_image 47507 0 V 0 D 0 0
35275 217080 variant_image 47508 0 V 0 D 0 0
35276 217081 variant_image 47509 0 V 0 D 0 0
35277 217082 variant_image 47510 0 V 0 D 0 0
35278 217083 variant_image 47511 0 V 0 D 0 0
35279 217084 variant_image 47512 0 V 0 D 0 0
35280 217085 variant_image 47513 0 V 0 D 0 0
35281 217086 variant_image 47514 0 V 0 D 0 0
35282 217087 variant_image 47515 0 V 0 D 0 0
35283 217088 variant_image 47516 0 V 0 D 0 0
35284 217091 variant_image 47517 0 V 0 D 0 0
35285 217092 variant_image 47518 0 V 0 D 0 0
35286 217093 variant_image 47519 0 V 0 D 0 0
35287 217094 variant_image 47520 0 V 0 D 0 0
35288 217095 variant_image 47521 0 V 0 D 0 0
35289 217096 variant_image 47522 0 V 0 D 0 0
35290 217097 variant_image 47523 0 V 0 D 0 0
35291 217098 variant_image 47524 0 V 0 D 0 0
35292 217099 variant_image 47525 0 V 0 D 0 0
35293 217100 variant_image 47526 0 V 0 D 0 0
35294 217101 variant_image 47527 0 V 0 D 0 0
35295 217102 variant_image 47528 0 V 0 D 0 0
35296 217103 variant_image 47529 0 V 0 D 0 0
35297 217104 variant_image 47530 0 V 0 D 0 0
35298 217105 variant_image 47531 0 V 0 D 0 0
35299 217106 variant_image 47532 0 V 0 D 0 0
35300 217107 variant_image 47533 0 V 0 D 0 0
35301 217108 variant_image 47534 0 V 0 D 0 0
35302 217109 variant_image 47535 0 V 0 D 0 0
35303 217110 variant_image 47536 0 V 0 D 0 0
35304 217111 variant_image 47537 0 V 0 D 0 0
35305 217112 variant_image 47538 0 V 0 D 0 0
35306 217113 variant_image 47539 0 V 0 D 0 0
35307 217114 variant_image 47540 0 V 0 D 0 0
35308 217115 variant_image 47541 0 V 0 D 0 0
35309 217116 variant_image 47542 0 V 0 D 0 0
35310 217117 variant_image 47543 0 V 0 D 0 0
35311 217118 variant_image 47544 0 V 0 D 0 0
35312 217119 variant_image 47545 0 V 0 D 0 0
35325 217132 variant_image 47558 0 V 0 D 0 0
35326 217133 variant_image 47559 0 V 0 D 0 0
35328 217089 variant_image 47561 0 V 0 D 0 0
35329 217090 variant_image 47562 0 V 0 D 0 0
35957 217630 variant_image 48190 0 V 0 D 0 0
35958 217631 variant_image 48191 0 V 0 D 0 0
35959 217632 variant_image 48192 0 V 0 D 0 0
36217 217844 variant_image 48450 0 V 0 D 0 0
36218 217845 variant_image 48451 0 V 0 D 0 0
37303 218837 variant_image 49536 0 V 0 D 0 0
37304 218838 variant_image 49537 0 V 0 D 0 0
37305 218839 variant_image 49538 0 V 0 D 0 0
42039 223756 variant_image 54272 0 V 0 D 0 0
42040 223757 variant_image 54273 0 V 0 D 0 0
42041 223758 variant_image 54274 0 V 0 D 0 0
42042 223759 variant_image 54275 0 V 0 D 0 0
42043 223761 variant_image 54276 0 V 0 D 0 0
42044 223762 variant_image 54277 0 V 0 D 0 0
44137 225920 variant_image 56370 0 V 0 D 0 0
44138 225921 variant_image 56371 0 V 0 D 0 0
46126 228069 variant_image 58359 0 V 0 D 0 0
46127 228070 variant_image 58360 0 V 0 D 0 0
59624 236882 variant_image 71857 0 V 0 D 0 0
59625 236883 variant_image 71858 0 V 0 D 0 0
59626 236884 variant_image 71859 0 V 0 D 0 0
59627 236885 variant_image 71860 0 V 0 D 0 0
59628 236886 variant_image 71861 0 V 0 D 0 0
59629 236887 variant_image 71862 0 V 0 D 0 0
59630 236888 variant_image 71863 0 V 0 D 0 0
59631 236889 variant_image 71864 0 V 0 D 0 0
62035 238245 variant_image 74268 0 V 0 D 0 0
62038 238248 variant_image 74271 0 V 0 D 0 0
62039 238249 variant_image 74272 0 V 0 D 0 0
62051 217723 variant_image 74284 0 V 0 D 0 0
62052 217724 variant_image 74285 0 V 0 D 0 0
62053 238254 variant_image 74286 0 V 0 D 0 0
71144 241590 variant_image 83377 0 V 0 D 0 0
71145 241591 variant_image 83378 0 V 0 D 0 0
71146 241592 variant_image 83379 0 V 0 D 0 0
71147 241593 variant_image 83380 0 V 0 D 0 0
71148 241594 variant_image 83381 0 V 0 D 0 0
71149 241595 variant_image 83382 0 V 0 D 0 0
71150 241596 variant_image 83383 0 V 0 D 0 0
71151 241597 variant_image 83384 0 V 0 D 0 0
71152 241598 variant_image 83385 0 V 0 D 0 0
71153 241599 variant_image 83386 0 V 0 D 0 0
71154 241600 variant_image 83387 0 V 0 D 0 0
71155 241601 variant_image 83388 0 V 0 D 0 0
71156 241602 variant_image 83389 0 V 0 D 0 0
71157 241603 variant_image 83390 0 V 0 D 0 0
71158 241604 variant_image 83391 0 V 0 D 0 0
71159 241605 variant_image 83392 0 V 0 D 0 0
71160 241606 variant_image 83393 0 V 0 D 0 0
71161 241607 variant_image 83394 0 V 0 D 0 0
71162 241608 variant_image 83395 0 V 0 D 0 0
71163 241609 variant_image 83396 0 V 0 D 0 0
72811 243095 variant_image 85044 0 V 0 D 0 0
72812 243096 variant_image 85045 0 V 0 D 0 0
72813 243097 variant_image 85046 0 V 0 D 0 0
72814 243098 variant_image 85047 0 V 0 D 0 0
74350 244558 variant_image 86583 0 V 0 D 0 0
74351 244559 variant_image 86584 0 V 0 D 0 0
74352 244560 variant_image 86585 0 V 0 D 0 0
74353 244561 variant_image 86586 0 V 0 D 0 0
74354 244562 variant_image 86587 0 V 0 D 0 0
74355 244563 variant_image 86588 0 V 0 D 0 0
74356 244564 variant_image 86589 0 V 0 D 0 0
74357 244565 variant_image 86590 0 V 0 D 0 0
74358 244566 variant_image 86591 0 V 0 D 0 0
74359 244567 variant_image 86592 0 V 0 D 0 0
74360 244568 variant_image 86593 0 V 0 D 0 0
74361 244569 variant_image 86594 0 V 0 D 0 0
74362 244570 variant_image 86595 0 V 0 D 0 0
74363 244571 variant_image 86596 0 V 0 D 0 0
74364 244572 variant_image 86597 0 V 0 D 0 0
74365 244573 variant_image 86598 0 V 0 D 0 0
74366 244574 variant_image 86599 0 V 0 D 0 0
74367 244575 variant_image 86600 0 V 0 D 0 0
74368 244576 variant_image 86601 0 V 0 D 0 0
74369 244577 variant_image 86602 0 V 0 D 0 0
74370 244578 variant_image 86603 0 V 0 D 0 0
74371 244579 variant_image 86604 0 V 0 D 0 0
74372 244580 variant_image 86605 0 V 0 D 0 0
74373 244581 variant_image 86606 0 V 0 D 0 0
74374 244582 variant_image 86607 0 V 0 D 0 0
74375 244583 variant_image 86608 0 V 0 D 0 0
74376 244584 variant_image 86609 0 V 0 D 0 0
74377 244585 variant_image 86610 0 V 0 D 0 0
74378 244586 variant_image 86611 0 V 0 D 0 0
74379 244587 variant_image 86612 0 V 0 D 0 0
74380 244588 variant_image 86613 0 V 0 D 0 0
74381 244589 variant_image 86614 0 V 0 D 0 0
74917 245122 variant_image 87150 0 V 0 D 0 0
74918 245123 variant_image 87151 0 V 0 D 0 0
74919 245124 variant_image 87152 0 V 0 D 0 0
74920 245125 variant_image 87153 0 V 0 D 0 0
74921 245126 variant_image 87154 0 V 0 D 0 0
74922 245127 variant_image 87155 0 V 0 D 0 0
74923 245128 variant_image 87156 0 V 0 D 0 0
74924 245129 variant_image 87157 0 V 0 D 0 0
74925 245130 variant_image 87158 0 V 0 D 0 0
74926 245131 variant_image 87159 0 V 0 D 0 0
74927 245132 variant_image 87160 0 V 0 D 0 0
74928 245133 variant_image 87161 0 V 0 D 0 0