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 (
    220231, 
    217630, 
    217631, 
    217632, 
    220272, 
    217308, 
    217309, 
    217310, 
    217311, 
    217312, 
    217313, 
    237062, 
    237063, 
    217314, 
    242263, 
    241171, 
    217315, 
    217316, 
    217317, 
    217318, 
    217319, 
    241172, 
    217320, 
    217321, 
    217322, 
    217323, 
    217324, 
    217325, 
    217326, 
    217327, 
    241173, 
    217328, 
    241174, 
    217329, 
    217330, 
    242264, 
    242265, 
    217331, 
    217332, 
    217333, 
    242266, 
    241175, 
    227061, 
    227058, 
    227059, 
    227060, 
    236651, 
    227092, 
    227062, 
    227063, 
    227064, 
    227065, 
    227087, 
    227080, 
    238348, 
    238349, 
    227066, 
    242255, 
    241463, 
    227067, 
    227068, 
    227069, 
    227070, 
    227071, 
    241464, 
    227072, 
    227073, 
    227074, 
    227075, 
    227076, 
    227077, 
    227078, 
    227079, 
    241465, 
    227081, 
    241466, 
    227082, 
    227083, 
    242256, 
    242257, 
    227084, 
    227085, 
    227086, 
    242258, 
    241467, 
    227098, 
    227095, 
    227097, 
    229485, 
    233738, 
    233740, 
    233742, 
    233741, 
    233709, 
    233743, 
    233710, 
    233711, 
    233712, 
    233713, 
    237118, 
    237119, 
    233714, 
    242259, 
    241468, 
    233715, 
    233716, 
    233717, 
    233718, 
    233719, 
    241469, 
    233720, 
    233721, 
    233722, 
    233723, 
    233724, 
    233725, 
    233726, 
    233727, 
    241470, 
    233728, 
    241471, 
    233729, 
    233730, 
    242260, 
    242261, 
    233731, 
    233732, 
    233733, 
    242262, 
    241472, 
    238137, 
    238107, 
    238108, 
    238109, 
    238110, 
    238111, 
    238112, 
    238138, 
    238139, 
    238113, 
    242267, 
    241181, 
    238114, 
    238115, 
    238116, 
    238117, 
    238118, 
    241182, 
    238119, 
    238120, 
    238121, 
    238122, 
    238123, 
    238124, 
    238125, 
    238126, 
    241183, 
    238127, 
    241184, 
    238128, 
    238129, 
    242268, 
    242269, 
    238130, 
    238131, 
    238132, 
    242270, 
    241185, 
    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.00383

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": 229,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220231,217630,217631,217632,220272,217308,217309,217310,217311,217312,217313,237062,237063,217314,242263,241171,217315,217316,217317,217318,217319,241172,217320,217321,217322,217323,217324,217325,217326,217327,241173,217328,241174,217329,217330,242264,242265,217331,217332,217333,242266,241175,227061,227058,227059,227060,236651,227092,227062,227063,227064,227065,227087,227080,238348,238349,227066,242255,241463,227067,227068,227069,227070,227071,241464,227072,227073,227074,227075,227076,227077,227078,227079,241465,227081,241466,227082,227083,242256,242257,227084,227085,227086,242258,241467,227098,227095,227097,229485,233738,233740,233742,233741,233709,233743,233710,233711,233712,233713,237118,237119,233714,242259,241468,233715,233716,233717,233718,233719,241469,233720,233721,233722,233723,233724,233725,233726,233727,241470,233728,241471,233729,233730,242260,242261,233731,233732,233733,242262,241472,238137,238107,238108,238109,238110,238111,238112,238138,238139,238113,242267,241181,238114,238115,238116,238117,238118,241182,238119,238120,238121,238122,238123,238124,238125,238126,241183,238127,241184,238128,238129,242268,242269,238130,238131,238132,242270,241185,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
35516 217308 variant_image 47749 0 V 0 D 0 0
35517 217309 variant_image 47750 0 V 0 D 0 0
35518 217310 variant_image 47751 0 V 0 D 0 0
35519 217311 variant_image 47752 0 V 0 D 0 0
35520 217312 variant_image 47753 0 V 0 D 0 0
35521 217313 variant_image 47754 0 V 0 D 0 0
35522 217314 variant_image 47755 0 V 0 D 0 0
35523 217315 variant_image 47756 0 V 0 D 0 0
35524 217316 variant_image 47757 0 V 0 D 0 0
35525 217317 variant_image 47758 0 V 0 D 0 0
35526 217318 variant_image 47759 0 V 0 D 0 0
35527 217319 variant_image 47760 0 V 0 D 0 0
35528 217320 variant_image 47761 0 V 0 D 0 0
35529 217321 variant_image 47762 0 V 0 D 0 0
35530 217322 variant_image 47763 0 V 0 D 0 0
35531 217323 variant_image 47764 0 V 0 D 0 0
35532 217324 variant_image 47765 0 V 0 D 0 0
35533 217325 variant_image 47766 0 V 0 D 0 0
35534 217326 variant_image 47767 0 V 0 D 0 0
35535 217327 variant_image 47768 0 V 0 D 0 0
35536 217328 variant_image 47769 0 V 0 D 0 0
35537 217329 variant_image 47770 0 V 0 D 0 0
35538 217330 variant_image 47771 0 V 0 D 0 0
35539 217331 variant_image 47772 0 V 0 D 0 0
35540 217332 variant_image 47773 0 V 0 D 0 0
35541 217333 variant_image 47774 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
45219 227062 variant_image 57452 0 V 0 D 0 0
45220 227063 variant_image 57453 0 V 0 D 0 0
45221 227064 variant_image 57454 0 V 0 D 0 0
45222 227065 variant_image 57455 0 V 0 D 0 0
45223 227066 variant_image 57456 0 V 0 D 0 0
45224 227067 variant_image 57457 0 V 0 D 0 0
45225 227068 variant_image 57458 0 V 0 D 0 0
45226 227069 variant_image 57459 0 V 0 D 0 0
45227 227070 variant_image 57460 0 V 0 D 0 0
45228 227071 variant_image 57461 0 V 0 D 0 0
45229 227072 variant_image 57462 0 V 0 D 0 0
45230 227073 variant_image 57463 0 V 0 D 0 0
45231 227074 variant_image 57464 0 V 0 D 0 0
45232 227075 variant_image 57465 0 V 0 D 0 0
45233 227076 variant_image 57466 0 V 0 D 0 0
45234 227077 variant_image 57467 0 V 0 D 0 0
45235 227078 variant_image 57468 0 V 0 D 0 0
45236 227079 variant_image 57469 0 V 0 D 0 0
45237 227080 variant_image 57470 0 V 0 D 0 0
45238 227081 variant_image 57471 0 V 0 D 0 0
45239 227082 variant_image 57472 0 V 0 D 0 0
45240 227083 variant_image 57473 0 V 0 D 0 0
45241 227084 variant_image 57474 0 V 0 D 0 0
45242 227085 variant_image 57475 0 V 0 D 0 0
45243 227086 variant_image 57476 0 V 0 D 0 0
45244 227087 variant_image 57477 0 V 0 D 0 0
45251 227095 variant_image 57484 0 V 0 D 0 0
45253 227097 variant_image 57486 0 V 0 D 0 0
47720 229485 variant_image 59953 0 V 0 D 0 0
48398 227058 variant_image 60631 0 V 0 D 0 0
48399 227059 variant_image 60632 0 V 0 D 0 0
48400 227060 variant_image 60633 0 V 0 D 0 0
54336 233709 variant_image 66569 0 V 0 D 0 0
54337 233710 variant_image 66570 0 V 0 D 0 0
54338 233711 variant_image 66571 0 V 0 D 0 0
54339 233712 variant_image 66572 0 V 0 D 0 0
54340 233713 variant_image 66573 0 V 0 D 0 0
54341 233714 variant_image 66574 0 V 0 D 0 0
54342 233715 variant_image 66575 0 V 0 D 0 0
54343 233716 variant_image 66576 0 V 0 D 0 0
54344 233717 variant_image 66577 0 V 0 D 0 0
54345 233718 variant_image 66578 0 V 0 D 0 0
54346 233719 variant_image 66579 0 V 0 D 0 0
54347 233720 variant_image 66580 0 V 0 D 0 0
54348 233721 variant_image 66581 0 V 0 D 0 0
54349 233722 variant_image 66582 0 V 0 D 0 0
54350 233723 variant_image 66583 0 V 0 D 0 0
54351 233724 variant_image 66584 0 V 0 D 0 0
54352 233725 variant_image 66585 0 V 0 D 0 0
54353 233726 variant_image 66586 0 V 0 D 0 0
54354 233727 variant_image 66587 0 V 0 D 0 0
54355 233728 variant_image 66588 0 V 0 D 0 0
54356 233729 variant_image 66589 0 V 0 D 0 0
54357 233730 variant_image 66590 0 V 0 D 0 0
54358 233731 variant_image 66591 0 V 0 D 0 0
54359 233732 variant_image 66592 0 V 0 D 0 0
54360 233733 variant_image 66593 0 V 0 D 0 0
54366 233740 variant_image 66599 0 V 0 D 0 0
54367 233741 variant_image 66600 0 V 0 D 0 0
54368 233742 variant_image 66601 0 V 0 D 0 0
54369 233743 variant_image 66602 0 V 0 D 0 0
59087 236651 variant_image 71320 0 V 0 D 0 0
59809 237062 variant_image 72042 0 V 0 D 0 0
59810 237063 variant_image 72043 0 V 0 D 0 0
59865 237118 variant_image 72098 0 V 0 D 0 0
59866 237119 variant_image 72099 0 V 0 D 0 0
61510 238107 variant_image 73743 0 V 0 D 0 0
61511 238108 variant_image 73744 0 V 0 D 0 0
61512 238109 variant_image 73745 0 V 0 D 0 0
61513 238110 variant_image 73746 0 V 0 D 0 0
61514 238111 variant_image 73747 0 V 0 D 0 0
61515 238112 variant_image 73748 0 V 0 D 0 0
61516 238113 variant_image 73749 0 V 0 D 0 0
61517 238114 variant_image 73750 0 V 0 D 0 0
61518 238115 variant_image 73751 0 V 0 D 0 0
61519 238116 variant_image 73752 0 V 0 D 0 0
61520 238117 variant_image 73753 0 V 0 D 0 0
61521 238118 variant_image 73754 0 V 0 D 0 0
61522 238119 variant_image 73755 0 V 0 D 0 0
61523 238120 variant_image 73756 0 V 0 D 0 0
61524 238121 variant_image 73757 0 V 0 D 0 0
61525 238122 variant_image 73758 0 V 0 D 0 0
61526 238123 variant_image 73759 0 V 0 D 0 0
61527 238124 variant_image 73760 0 V 0 D 0 0
61528 238125 variant_image 73761 0 V 0 D 0 0
61529 238126 variant_image 73762 0 V 0 D 0 0
61530 238127 variant_image 73763 0 V 0 D 0 0
61531 238128 variant_image 73764 0 V 0 D 0 0
61532 238129 variant_image 73765 0 V 0 D 0 0
61533 238130 variant_image 73766 0 V 0 D 0 0
61534 238131 variant_image 73767 0 V 0 D 0 0
61535 238132 variant_image 73768 0 V 0 D 0 0
61540 238138 variant_image 73773 0 V 0 D 0 0
61541 238139 variant_image 73774 0 V 0 D 0 0
62420 238348 variant_image 74653 0 V 0 D 0 0
62421 238349 variant_image 74654 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
70706 241171 variant_image 82939 0 V 0 D 0 0
70707 241172 variant_image 82940 0 V 0 D 0 0
70708 241173 variant_image 82941 0 V 0 D 0 0
70709 241174 variant_image 82942 0 V 0 D 0 0
70710 241175 variant_image 82943 0 V 0 D 0 0
70716 241181 variant_image 82949 0 V 0 D 0 0
70717 241182 variant_image 82950 0 V 0 D 0 0
70718 241183 variant_image 82951 0 V 0 D 0 0
70719 241184 variant_image 82952 0 V 0 D 0 0
70720 241185 variant_image 82953 0 V 0 D 0 0
70998 241463 variant_image 83231 0 V 0 D 0 0
70999 241464 variant_image 83232 0 V 0 D 0 0
71000 241465 variant_image 83233 0 V 0 D 0 0
71001 241466 variant_image 83234 0 V 0 D 0 0
71002 241467 variant_image 83235 0 V 0 D 0 0
71003 241468 variant_image 83236 0 V 0 D 0 0
71004 241469 variant_image 83237 0 V 0 D 0 0
71005 241470 variant_image 83238 0 V 0 D 0 0
71006 241471 variant_image 83239 0 V 0 D 0 0
71007 241472 variant_image 83240 0 V 0 D 0 0
71818 242255 variant_image 84051 0 V 0 D 0 0
71819 242256 variant_image 84052 0 V 0 D 0 0
71820 242258 variant_image 84053 0 V 0 D 0 0
71821 242259 variant_image 84054 0 V 0 D 0 0
71822 242260 variant_image 84055 0 V 0 D 0 0
71823 242261 variant_image 84056 0 V 0 D 0 0
71824 242262 variant_image 84057 0 V 0 D 0 0
71825 242263 variant_image 84058 0 V 0 D 0 0
71826 242264 variant_image 84059 0 V 0 D 0 0
71827 242265 variant_image 84060 0 V 0 D 0 0
71828 242266 variant_image 84061 0 V 0 D 0 0
71829 242267 variant_image 84062 0 V 0 D 0 0
71830 242268 variant_image 84063 0 V 0 D 0 0
71831 242269 variant_image 84064 0 V 0 D 0 0
71832 242270 variant_image 84065 0 V 0 D 0 0
71833 242257 variant_image 84066 0 V 0 D 0 0