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 (
    220172, 
    238867, 
    215452, 
    238868, 
    215454, 
    238869, 
    215456, 
    238870, 
    215458, 
    238871, 
    215460, 
    238872, 
    215462, 
    220318, 
    215376, 
    215377, 
    220543, 
    245134, 
    245135, 
    245136, 
    245137, 
    245138, 
    245139, 
    245140, 
    245141, 
    220555, 
    220556, 
    220557, 
    220558, 
    220559, 
    220560, 
    236876, 
    236877, 
    220561, 
    245439, 
    242034, 
    220562, 
    220563, 
    220564, 
    220565, 
    220566, 
    242035, 
    220567, 
    220568, 
    220569, 
    220570, 
    220571, 
    220572, 
    220573, 
    220574, 
    242036, 
    220575, 
    242037, 
    220576, 
    220577, 
    245440, 
    245441, 
    220578, 
    220579, 
    245442, 
    242038, 
    220580, 
    220581, 
    220582, 
    220583, 
    220584, 
    220585, 
    220586, 
    220587, 
    220588, 
    236878, 
    236879, 
    220589, 
    245459, 
    242044, 
    220590, 
    220591, 
    220592, 
    220593, 
    220594, 
    242045, 
    220595, 
    220596, 
    220597, 
    220598, 
    220599, 
    220600, 
    220601, 
    220602, 
    242046, 
    220603, 
    242047, 
    220604, 
    220605, 
    245460, 
    245461, 
    233243, 
    220606, 
    245462, 
    242048, 
    220607, 
    220608, 
    245451, 
    245452, 
    245453, 
    245454, 
    245455, 
    245456, 
    245457, 
    245458, 
    220665, 
    220666, 
    220668, 
    220667, 
    220677, 
    220678, 
    220679, 
    220680, 
    220681, 
    220682, 
    220683, 
    236880, 
    236881, 
    220684, 
    245447, 
    242039, 
    220685, 
    220686, 
    220687, 
    220688, 
    220689, 
    242040, 
    220690, 
    220691, 
    220692, 
    220693, 
    220694, 
    220695, 
    220696, 
    220697, 
    242041, 
    220698, 
    242042, 
    220699, 
    220700, 
    245448, 
    245449, 
    220701, 
    220702, 
    220703, 
    245450, 
    242043, 
    220704, 
    245431, 
    245432, 
    245433, 
    245434, 
    245435, 
    245436, 
    245437, 
    245438, 
    220760, 
    220761, 
    220762, 
    220763, 
    220764, 
    220765, 
    220766, 
    220767, 
    220768, 
    220776, 
    220777, 
    220778, 
    220779, 
    220787, 
    220788, 
    220789, 
    220790, 
    220798, 
    220799, 
    220800, 
    220801, 
    220814, 
    220815, 
    220816, 
    220817, 
    220818, 
    220819, 
    220996, 
    220997, 
    220998
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00225

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": 191,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220172,238867,215452,238868,215454,238869,215456,238870,215458,238871,215460,238872,215462,220318,215376,215377,220543,245134,245135,245136,245137,245138,245139,245140,245141,220555,220556,220557,220558,220559,220560,236876,236877,220561,245439,242034,220562,220563,220564,220565,220566,242035,220567,220568,220569,220570,220571,220572,220573,220574,242036,220575,242037,220576,220577,245440,245441,220578,220579,245442,242038,220580,220581,220582,220583,220584,220585,220586,220587,220588,236878,236879,220589,245459,242044,220590,220591,220592,220593,220594,242045,220595,220596,220597,220598,220599,220600,220601,220602,242046,220603,242047,220604,220605,245460,245461,233243,220606,245462,242048,220607,220608,245451,245452,245453,245454,245455,245456,245457,245458,220665,220666,220668,220667,220677,220678,220679,220680,220681,220682,220683,236880,236881,220684,245447,242039,220685,220686,220687,220688,220689,242040,220690,220691,220692,220693,220694,220695,220696,220697,242041,220698,242042,220699,220700,245448,245449,220701,220702,220703,245450,242043,220704,245431,245432,245433,245434,245435,245436,245437,245438,220760,220761,220762,220763,220764,220765,220766,220767,220768,220776,220777,220778,220779,220787,220788,220789,220790,220798,220799,220800,220801,220814,220815,220816,220817,220818,220819,220996,220997,220998)"
        }
      }
    },
    "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
33339 215376 variant_image 45572 0 V 0 D 0 0
33340 215377 variant_image 45573 0 V 0 D 0 0
39046 220555 variant_image 51279 0 V 0 D 0 0
39047 220556 variant_image 51280 0 V 0 D 0 0
39048 220557 variant_image 51281 0 V 0 D 0 0
39049 220558 variant_image 51282 0 V 0 D 0 0
39050 220559 variant_image 51283 0 V 0 D 0 0
39051 220560 variant_image 51284 0 V 0 D 0 0
39052 220561 variant_image 51285 0 V 0 D 0 0
39053 220562 variant_image 51286 0 V 0 D 0 0
39054 220563 variant_image 51287 0 V 0 D 0 0
39055 220564 variant_image 51288 0 V 0 D 0 0
39056 220565 variant_image 51289 0 V 0 D 0 0
39057 220566 variant_image 51290 0 V 0 D 0 0
39058 220567 variant_image 51291 0 V 0 D 0 0
39059 220568 variant_image 51292 0 V 0 D 0 0
39060 220569 variant_image 51293 0 V 0 D 0 0
39061 220570 variant_image 51294 0 V 0 D 0 0
39062 220571 variant_image 51295 0 V 0 D 0 0
39063 220572 variant_image 51296 0 V 0 D 0 0
39064 220573 variant_image 51297 0 V 0 D 0 0
39065 220574 variant_image 51298 0 V 0 D 0 0
39066 220575 variant_image 51299 0 V 0 D 0 0
39067 220576 variant_image 51300 0 V 0 D 0 0
39068 220577 variant_image 51301 0 V 0 D 0 0
39069 220578 variant_image 51302 0 V 0 D 0 0
39070 220579 variant_image 51303 0 V 0 D 0 0
39074 220582 variant_image 51307 0 V 0 D 0 0
39075 220583 variant_image 51308 0 V 0 D 0 0
39076 220584 variant_image 51309 0 V 0 D 0 0
39077 220585 variant_image 51310 0 V 0 D 0 0
39078 220586 variant_image 51311 0 V 0 D 0 0
39079 220587 variant_image 51312 0 V 0 D 0 0
39080 220588 variant_image 51313 0 V 0 D 0 0
39081 220589 variant_image 51314 0 V 0 D 0 0
39082 220590 variant_image 51315 0 V 0 D 0 0
39083 220591 variant_image 51316 0 V 0 D 0 0
39084 220592 variant_image 51317 0 V 0 D 0 0
39085 220593 variant_image 51318 0 V 0 D 0 0
39086 220594 variant_image 51319 0 V 0 D 0 0
39087 220595 variant_image 51320 0 V 0 D 0 0
39088 220596 variant_image 51321 0 V 0 D 0 0
39089 220597 variant_image 51322 0 V 0 D 0 0
39090 220598 variant_image 51323 0 V 0 D 0 0
39091 220599 variant_image 51324 0 V 0 D 0 0
39092 220600 variant_image 51325 0 V 0 D 0 0
39093 220601 variant_image 51326 0 V 0 D 0 0
39094 220602 variant_image 51327 0 V 0 D 0 0
39095 220603 variant_image 51328 0 V 0 D 0 0
39096 220604 variant_image 51329 0 V 0 D 0 0
39097 220605 variant_image 51330 0 V 0 D 0 0
39098 220606 variant_image 51331 0 V 0 D 0 0
39151 220666 variant_image 51384 0 V 0 D 0 0
39152 220667 variant_image 51385 0 V 0 D 0 0
39153 220668 variant_image 51386 0 V 0 D 0 0
39159 220678 variant_image 51392 0 V 0 D 0 0
39160 220679 variant_image 51393 0 V 0 D 0 0
39161 220680 variant_image 51394 0 V 0 D 0 0
39162 220681 variant_image 51395 0 V 0 D 0 0
39163 220682 variant_image 51396 0 V 0 D 0 0
39164 220683 variant_image 51397 0 V 0 D 0 0
39165 220684 variant_image 51398 0 V 0 D 0 0
39166 220685 variant_image 51399 0 V 0 D 0 0
39167 220686 variant_image 51400 0 V 0 D 0 0
39168 220687 variant_image 51401 0 V 0 D 0 0
39169 220688 variant_image 51402 0 V 0 D 0 0
39170 220689 variant_image 51403 0 V 0 D 0 0
39171 220690 variant_image 51404 0 V 0 D 0 0
39172 220691 variant_image 51405 0 V 0 D 0 0
39173 220692 variant_image 51406 0 V 0 D 0 0
39174 220693 variant_image 51407 0 V 0 D 0 0
39175 220694 variant_image 51408 0 V 0 D 0 0
39176 220695 variant_image 51409 0 V 0 D 0 0
39177 220696 variant_image 51410 0 V 0 D 0 0
39178 220697 variant_image 51411 0 V 0 D 0 0
39179 220698 variant_image 51412 0 V 0 D 0 0
39180 220699 variant_image 51413 0 V 0 D 0 0
39181 220700 variant_image 51414 0 V 0 D 0 0
39182 220701 variant_image 51415 0 V 0 D 0 0
39183 220702 variant_image 51416 0 V 0 D 0 0
39184 220703 variant_image 51417 0 V 0 D 0 0
39257 220761 variant_image 51490 0 V 0 D 0 0
39258 220762 variant_image 51491 0 V 0 D 0 0
39259 220763 variant_image 51492 0 V 0 D 0 0
39260 220764 variant_image 51493 0 V 0 D 0 0
39261 220766 variant_image 51494 0 V 0 D 0 0
39262 220767 variant_image 51495 0 V 0 D 0 0
39263 220768 variant_image 51496 0 V 0 D 0 0
39271 220777 variant_image 51504 0 V 0 D 0 0
39272 220778 variant_image 51505 0 V 0 D 0 0
39280 220788 variant_image 51513 0 V 0 D 0 0
39281 220789 variant_image 51514 0 V 0 D 0 0
39282 220790 variant_image 51515 0 V 0 D 0 0
39290 220779 variant_image 51523 0 V 0 D 0 0
39291 220799 variant_image 51524 0 V 0 D 0 0
39292 220800 variant_image 51525 0 V 0 D 0 0
39293 220801 variant_image 51526 0 V 0 D 0 0
39305 220815 variant_image 51538 0 V 0 D 0 0
39306 220816 variant_image 51539 0 V 0 D 0 0
39307 220817 variant_image 51540 0 V 0 D 0 0
39308 220818 variant_image 51541 0 V 0 D 0 0
39309 220819 variant_image 51542 0 V 0 D 0 0
53710 233243 variant_image 65943 0 V 0 D 0 0
59618 236876 variant_image 71851 0 V 0 D 0 0
59619 236877 variant_image 71852 0 V 0 D 0 0
59620 236878 variant_image 71853 0 V 0 D 0 0
59621 236879 variant_image 71854 0 V 0 D 0 0
59622 236880 variant_image 71855 0 V 0 D 0 0
59623 236881 variant_image 71856 0 V 0 D 0 0
71587 242034 variant_image 83820 0 V 0 D 0 0
71588 242035 variant_image 83821 0 V 0 D 0 0
71589 242036 variant_image 83822 0 V 0 D 0 0
71590 242037 variant_image 83823 0 V 0 D 0 0
71591 242038 variant_image 83824 0 V 0 D 0 0
71592 242039 variant_image 83825 0 V 0 D 0 0
71593 242040 variant_image 83826 0 V 0 D 0 0
71594 242041 variant_image 83827 0 V 0 D 0 0
71595 242042 variant_image 83828 0 V 0 D 0 0
71596 242043 variant_image 83829 0 V 0 D 0 0
71597 242044 variant_image 83830 0 V 0 D 0 0
71598 242045 variant_image 83831 0 V 0 D 0 0
71599 242046 variant_image 83832 0 V 0 D 0 0
71600 242047 variant_image 83833 0 V 0 D 0 0
71601 242048 variant_image 83834 0 V 0 D 0 0
74937 245134 variant_image 87170 0 V 0 D 0 0
74938 245135 variant_image 87171 0 V 0 D 0 0
74939 245136 variant_image 87172 0 V 0 D 0 0
74940 245137 variant_image 87173 0 V 0 D 0 0
74941 245138 variant_image 87174 0 V 0 D 0 0
74942 245139 variant_image 87175 0 V 0 D 0 0
74943 245140 variant_image 87176 0 V 0 D 0 0
74944 245141 variant_image 87177 0 V 0 D 0 0
75418 245431 variant_image 87651 0 V 0 D 0 0
75419 245432 variant_image 87652 0 V 0 D 0 0
75420 245433 variant_image 87653 0 V 0 D 0 0
75421 245434 variant_image 87654 0 V 0 D 0 0
75422 245435 variant_image 87655 0 V 0 D 0 0
75423 245436 variant_image 87656 0 V 0 D 0 0
75424 245437 variant_image 87657 0 V 0 D 0 0
75425 245438 variant_image 87658 0 V 0 D 0 0
75426 245439 variant_image 87659 0 V 0 D 0 0
75427 245440 variant_image 87660 0 V 0 D 0 0
75428 245441 variant_image 87661 0 V 0 D 0 0
75429 245442 variant_image 87662 0 V 0 D 0 0
75465 245447 variant_image 87698 0 V 0 D 0 0
75466 245448 variant_image 87699 0 V 0 D 0 0
75467 245449 variant_image 87700 0 V 0 D 0 0
75468 245450 variant_image 87701 0 V 0 D 0 0
75469 245451 variant_image 87702 0 V 0 D 0 0
75470 245452 variant_image 87703 0 V 0 D 0 0
75471 245453 variant_image 87704 0 V 0 D 0 0
75472 245454 variant_image 87705 0 V 0 D 0 0
75473 245455 variant_image 87706 0 V 0 D 0 0
75474 245456 variant_image 87707 0 V 0 D 0 0
75475 245457 variant_image 87708 0 V 0 D 0 0
75476 245458 variant_image 87709 0 V 0 D 0 0
75477 245459 variant_image 87710 0 V 0 D 0 0
75478 245460 variant_image 87711 0 V 0 D 0 0
75479 245461 variant_image 87712 0 V 0 D 0 0
75480 245462 variant_image 87713 0 V 0 D 0 0