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 (
    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, 
    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, 
    220825, 
    220826, 
    220827, 
    220828, 
    221002, 
    221003, 
    221004, 
    221058, 
    221059, 
    245423, 
    245424, 
    245425, 
    245426, 
    245427, 
    245428, 
    245429, 
    245430, 
    221103, 
    221072, 
    221073, 
    221074, 
    221075, 
    221076, 
    221077, 
    221078, 
    221079, 
    245443, 
    242110, 
    221080, 
    221081, 
    221082, 
    221083, 
    221084, 
    242111, 
    221085, 
    221086, 
    221087, 
    221088, 
    221089, 
    221090, 
    221091, 
    221092, 
    242112, 
    221093, 
    242113, 
    221094, 
    221095, 
    245444, 
    245445, 
    221096, 
    221097, 
    221098, 
    245446, 
    242114, 
    240507, 
    240506, 
    240508, 
    240509, 
    240536, 
    240514, 
    240515, 
    240516, 
    240517, 
    240518, 
    240526, 
    240535, 
    240519, 
    240520, 
    240521, 
    240522, 
    240523, 
    240524, 
    240525, 
    240527, 
    240528, 
    240529, 
    240530, 
    240559, 
    240537, 
    240538, 
    240539, 
    240540, 
    240541, 
    240549, 
    240558, 
    240542, 
    240543, 
    240544, 
    240545, 
    240546, 
    240547, 
    240548, 
    240550, 
    240551, 
    240552, 
    240553, 
    240582, 
    240560, 
    240561, 
    240562, 
    240563, 
    240564, 
    240572, 
    240581, 
    240565, 
    240566, 
    240567, 
    240568, 
    240569, 
    240570, 
    240571, 
    240573, 
    240574, 
    240575, 
    240576
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00246

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": 231,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (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,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,220825,220826,220827,220828,221002,221003,221004,221058,221059,245423,245424,245425,245426,245427,245428,245429,245430,221103,221072,221073,221074,221075,221076,221077,221078,221079,245443,242110,221080,221081,221082,221083,221084,242111,221085,221086,221087,221088,221089,221090,221091,221092,242112,221093,242113,221094,221095,245444,245445,221096,221097,221098,245446,242114,240507,240506,240508,240509,240536,240514,240515,240516,240517,240518,240526,240535,240519,240520,240521,240522,240523,240524,240525,240527,240528,240529,240530,240559,240537,240538,240539,240540,240541,240549,240558,240542,240543,240544,240545,240546,240547,240548,240550,240551,240552,240553,240582,240560,240561,240562,240563,240564,240572,240581,240565,240566,240567,240568,240569,240570,240571,240573,240574,240575,240576)"
        }
      }
    },
    "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
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
39314 220826 variant_image 51547 0 V 0 D 0 0
39315 220827 variant_image 51548 0 V 0 D 0 0
39316 220828 variant_image 51549 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
59622 236880 variant_image 71855 0 V 0 D 0 0
59623 236881 variant_image 71856 0 V 0 D 0 0
69896 240514 variant_image 82129 0 V 0 D 0 0
69897 240515 variant_image 82130 0 V 0 D 0 0
69898 240516 variant_image 82131 0 V 0 D 0 0
69899 240517 variant_image 82132 0 V 0 D 0 0
69900 240518 variant_image 82133 0 V 0 D 0 0
69901 240519 variant_image 82134 0 V 0 D 0 0
69902 240520 variant_image 82135 0 V 0 D 0 0
69903 240521 variant_image 82136 0 V 0 D 0 0
69904 240522 variant_image 82137 0 V 0 D 0 0
69905 240523 variant_image 82138 0 V 0 D 0 0
69906 240524 variant_image 82139 0 V 0 D 0 0
69907 240525 variant_image 82140 0 V 0 D 0 0
69908 240526 variant_image 82141 0 V 0 D 0 0
69909 240527 variant_image 82142 0 V 0 D 0 0
69910 240528 variant_image 82143 0 V 0 D 0 0
69911 240529 variant_image 82144 0 V 0 D 0 0
69912 240530 variant_image 82145 0 V 0 D 0 0
69917 240535 variant_image 82150 0 V 0 D 0 0
69918 240537 variant_image 82151 0 V 0 D 0 0
69919 240538 variant_image 82152 0 V 0 D 0 0
69920 240539 variant_image 82153 0 V 0 D 0 0
69921 240540 variant_image 82154 0 V 0 D 0 0
69922 240541 variant_image 82155 0 V 0 D 0 0
69923 240542 variant_image 82156 0 V 0 D 0 0
69924 240543 variant_image 82157 0 V 0 D 0 0
69925 240544 variant_image 82158 0 V 0 D 0 0
69926 240545 variant_image 82159 0 V 0 D 0 0
69927 240546 variant_image 82160 0 V 0 D 0 0
69928 240547 variant_image 82161 0 V 0 D 0 0
69929 240548 variant_image 82162 0 V 0 D 0 0
69930 240549 variant_image 82163 0 V 0 D 0 0
69931 240550 variant_image 82164 0 V 0 D 0 0
69932 240551 variant_image 82165 0 V 0 D 0 0
69933 240552 variant_image 82166 0 V 0 D 0 0
69934 240553 variant_image 82167 0 V 0 D 0 0
69939 240558 variant_image 82172 0 V 0 D 0 0
69940 240560 variant_image 82173 0 V 0 D 0 0
69941 240561 variant_image 82174 0 V 0 D 0 0
69942 240562 variant_image 82175 0 V 0 D 0 0
69943 240563 variant_image 82176 0 V 0 D 0 0
69944 240564 variant_image 82177 0 V 0 D 0 0
69945 240565 variant_image 82178 0 V 0 D 0 0
69946 240566 variant_image 82179 0 V 0 D 0 0
69947 240567 variant_image 82180 0 V 0 D 0 0
69948 240568 variant_image 82181 0 V 0 D 0 0
69949 240569 variant_image 82182 0 V 0 D 0 0
69950 240570 variant_image 82183 0 V 0 D 0 0
69951 240571 variant_image 82184 0 V 0 D 0 0
69952 240572 variant_image 82185 0 V 0 D 0 0
69953 240573 variant_image 82186 0 V 0 D 0 0
69954 240574 variant_image 82187 0 V 0 D 0 0
69955 240575 variant_image 82188 0 V 0 D 0 0
69956 240576 variant_image 82189 0 V 0 D 0 0
69961 240581 variant_image 82194 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
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
75410 245423 variant_image 87643 0 V 0 D 0 0
75411 245424 variant_image 87644 0 V 0 D 0 0
75412 245425 variant_image 87645 0 V 0 D 0 0
75413 245426 variant_image 87646 0 V 0 D 0 0
75414 245427 variant_image 87647 0 V 0 D 0 0
75415 245428 variant_image 87648 0 V 0 D 0 0
75416 245429 variant_image 87649 0 V 0 D 0 0
75417 245430 variant_image 87650 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
75430 245443 variant_image 87663 0 V 0 D 0 0
75431 245444 variant_image 87664 0 V 0 D 0 0
75432 245445 variant_image 87665 0 V 0 D 0 0
75433 245446 variant_image 87666 0 V 0 D 0 0
75434 221073 variant_image 87667 0 V 0 D 0 0
75435 221074 variant_image 87668 0 V 0 D 0 0
75436 221077 variant_image 87669 0 V 0 D 0 0
75437 221078 variant_image 87670 0 V 0 D 0 0
75438 221079 variant_image 87671 0 V 0 D 0 0
75439 221075 variant_image 87672 0 V 0 D 0 0
75440 221076 variant_image 87673 0 V 0 D 0 0
75441 242110 variant_image 87674 0 V 0 D 0 0
75442 221080 variant_image 87675 0 V 0 D 0 0
75443 221081 variant_image 87676 0 V 0 D 0 0
75444 221082 variant_image 87677 0 V 0 D 0 0
75445 221083 variant_image 87678 0 V 0 D 0 0
75446 221084 variant_image 87679 0 V 0 D 0 0
75447 242111 variant_image 87680 0 V 0 D 0 0
75448 221085 variant_image 87681 0 V 0 D 0 0
75449 221086 variant_image 87682 0 V 0 D 0 0
75450 221087 variant_image 87683 0 V 0 D 0 0
75451 221088 variant_image 87684 0 V 0 D 0 0
75452 221089 variant_image 87685 0 V 0 D 0 0
75453 221090 variant_image 87686 0 V 0 D 0 0
75454 221091 variant_image 87687 0 V 0 D 0 0
75455 221092 variant_image 87688 0 V 0 D 0 0
75456 242112 variant_image 87689 0 V 0 D 0 0
75457 221093 variant_image 87690 0 V 0 D 0 0
75458 242113 variant_image 87691 0 V 0 D 0 0
75459 221094 variant_image 87692 0 V 0 D 0 0
75460 221095 variant_image 87693 0 V 0 D 0 0
75461 221096 variant_image 87694 0 V 0 D 0 0
75462 221097 variant_image 87695 0 V 0 D 0 0
75463 221098 variant_image 87696 0 V 0 D 0 0
75464 242114 variant_image 87697 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