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 (
    224029, 
    224030, 
    224031, 
    224038, 
    224035, 
    224036, 
    224037, 
    224078, 
    224043, 
    224044, 
    224045, 
    224046, 
    224047, 
    224048, 
    237122, 
    237123, 
    224049, 
    242075, 
    224050, 
    224051, 
    224052, 
    224053, 
    224054, 
    242076, 
    224055, 
    224056, 
    224057, 
    224058, 
    224059, 
    224060, 
    224061, 
    224062, 
    242077, 
    224063, 
    242078, 
    224064, 
    224065, 
    224066, 
    224067, 
    224068, 
    242079, 
    224073, 
    224074, 
    242756, 
    242757, 
    242758, 
    242759, 
    224111, 
    224112, 
    224079, 
    224080, 
    224082, 
    224083, 
    224084, 
    237124, 
    237125, 
    224085, 
    242080, 
    224086, 
    224087, 
    224088, 
    224089, 
    224090, 
    242081, 
    224091, 
    224092, 
    224093, 
    224094, 
    224095, 
    224096, 
    224097, 
    224098, 
    242082, 
    224099, 
    242083, 
    224100, 
    224101, 
    224102, 
    224103, 
    224104, 
    242084, 
    242760, 
    242761, 
    242762, 
    242763, 
    224145, 
    224113, 
    224114, 
    224115, 
    224116, 
    224117, 
    224118, 
    224119, 
    237126, 
    237127, 
    224120, 
    242764, 
    224121, 
    224122, 
    224123, 
    224124, 
    224125, 
    242765, 
    224126, 
    224127, 
    224128, 
    224129, 
    224130, 
    224131, 
    224132, 
    224133, 
    242766, 
    224134, 
    242767, 
    224135, 
    224136, 
    224137, 
    224138, 
    224139, 
    242768, 
    224140, 
    224141, 
    224146, 
    224147, 
    224148, 
    224149, 
    240507, 
    240506, 
    240508, 
    240509, 
    240605, 
    240583, 
    240584, 
    240585, 
    240586, 
    240587, 
    240595, 
    240604, 
    240588, 
    240589, 
    240590, 
    240591, 
    240592, 
    240593, 
    240594, 
    243079, 
    243080, 
    243081, 
    243082, 
    240628, 
    240606, 
    240607, 
    240608, 
    240609, 
    240610, 
    240618, 
    240627, 
    240611, 
    240612, 
    240613, 
    240614, 
    240615, 
    240616, 
    240617, 
    243083, 
    243084, 
    243085, 
    243086, 
    240651, 
    240629, 
    240630, 
    240631, 
    240632, 
    240633, 
    240641, 
    240650, 
    240634, 
    240635, 
    240636, 
    240637, 
    240638, 
    240639, 
    240640, 
    243087, 
    243088, 
    243089, 
    243090
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00351

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": 187,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (224029,224030,224031,224038,224035,224036,224037,224078,224043,224044,224045,224046,224047,224048,237122,237123,224049,242075,224050,224051,224052,224053,224054,242076,224055,224056,224057,224058,224059,224060,224061,224062,242077,224063,242078,224064,224065,224066,224067,224068,242079,224073,224074,242756,242757,242758,242759,224111,224112,224079,224080,224082,224083,224084,237124,237125,224085,242080,224086,224087,224088,224089,224090,242081,224091,224092,224093,224094,224095,224096,224097,224098,242082,224099,242083,224100,224101,224102,224103,224104,242084,242760,242761,242762,242763,224145,224113,224114,224115,224116,224117,224118,224119,237126,237127,224120,242764,224121,224122,224123,224124,224125,242765,224126,224127,224128,224129,224130,224131,224132,224133,242766,224134,242767,224135,224136,224137,224138,224139,242768,224140,224141,224146,224147,224148,224149,240507,240506,240508,240509,240605,240583,240584,240585,240586,240587,240595,240604,240588,240589,240590,240591,240592,240593,240594,243079,243080,243081,243082,240628,240606,240607,240608,240609,240610,240618,240627,240611,240612,240613,240614,240615,240616,240617,243083,243084,243085,243086,240651,240629,240630,240631,240632,240633,240641,240650,240634,240635,240636,240637,240638,240639,240640,243087,243088,243089,243090)"
        }
      }
    },
    "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
42331 224035 variant_image 54564 0 V 0 D 0 0
42332 224036 variant_image 54565 0 V 0 D 0 0
42333 224037 variant_image 54566 0 V 0 D 0 0
42337 224043 variant_image 54570 0 V 0 D 0 0
42338 224044 variant_image 54571 0 V 0 D 0 0
42339 224045 variant_image 54572 0 V 0 D 0 0
42340 224046 variant_image 54573 0 V 0 D 0 0
42341 224047 variant_image 54574 0 V 0 D 0 0
42342 224048 variant_image 54575 0 V 0 D 0 0
42343 224049 variant_image 54576 0 V 0 D 0 0
42344 224050 variant_image 54577 0 V 0 D 0 0
42345 224051 variant_image 54578 0 V 0 D 0 0
42346 224052 variant_image 54579 0 V 0 D 0 0
42347 224053 variant_image 54580 0 V 0 D 0 0
42348 224054 variant_image 54581 0 V 0 D 0 0
42349 224055 variant_image 54582 0 V 0 D 0 0
42350 224056 variant_image 54583 0 V 0 D 0 0
42351 224057 variant_image 54584 0 V 0 D 0 0
42352 224058 variant_image 54585 0 V 0 D 0 0
42353 224059 variant_image 54586 0 V 0 D 0 0
42354 224060 variant_image 54587 0 V 0 D 0 0
42355 224061 variant_image 54588 0 V 0 D 0 0
42356 224062 variant_image 54589 0 V 0 D 0 0
42357 224063 variant_image 54590 0 V 0 D 0 0
42358 224064 variant_image 54591 0 V 0 D 0 0
42359 224065 variant_image 54592 0 V 0 D 0 0
42360 224066 variant_image 54593 0 V 0 D 0 0
42361 224067 variant_image 54594 0 V 0 D 0 0
42362 224068 variant_image 54595 0 V 0 D 0 0
42367 224073 variant_image 54600 0 V 0 D 0 0
42368 224074 variant_image 54601 0 V 0 D 0 0
42372 224079 variant_image 54605 0 V 0 D 0 0
42373 224080 variant_image 54606 0 V 0 D 0 0
42375 224082 variant_image 54608 0 V 0 D 0 0
42376 224083 variant_image 54609 0 V 0 D 0 0
42377 224084 variant_image 54610 0 V 0 D 0 0
42378 224085 variant_image 54611 0 V 0 D 0 0
42379 224086 variant_image 54612 0 V 0 D 0 0
42380 224087 variant_image 54613 0 V 0 D 0 0
42381 224088 variant_image 54614 0 V 0 D 0 0
42382 224089 variant_image 54615 0 V 0 D 0 0
42383 224090 variant_image 54616 0 V 0 D 0 0
42384 224091 variant_image 54617 0 V 0 D 0 0
42385 224092 variant_image 54618 0 V 0 D 0 0
42386 224093 variant_image 54619 0 V 0 D 0 0
42387 224094 variant_image 54620 0 V 0 D 0 0
42388 224095 variant_image 54621 0 V 0 D 0 0
42389 224096 variant_image 54622 0 V 0 D 0 0
42390 224097 variant_image 54623 0 V 0 D 0 0
42391 224098 variant_image 54624 0 V 0 D 0 0
42392 224099 variant_image 54625 0 V 0 D 0 0
42393 224100 variant_image 54626 0 V 0 D 0 0
42394 224101 variant_image 54627 0 V 0 D 0 0
42395 224102 variant_image 54628 0 V 0 D 0 0
42396 224103 variant_image 54629 0 V 0 D 0 0
42397 224104 variant_image 54630 0 V 0 D 0 0
42404 224114 variant_image 54637 0 V 0 D 0 0
42405 224115 variant_image 54638 0 V 0 D 0 0
42406 224116 variant_image 54639 0 V 0 D 0 0
42407 224117 variant_image 54640 0 V 0 D 0 0
42408 224118 variant_image 54641 0 V 0 D 0 0
42409 224119 variant_image 54642 0 V 0 D 0 0
42410 224120 variant_image 54643 0 V 0 D 0 0
42411 224121 variant_image 54644 0 V 0 D 0 0
42412 224122 variant_image 54645 0 V 0 D 0 0
42413 224123 variant_image 54646 0 V 0 D 0 0
42414 224124 variant_image 54647 0 V 0 D 0 0
42415 224125 variant_image 54648 0 V 0 D 0 0
42416 224126 variant_image 54649 0 V 0 D 0 0
42417 224127 variant_image 54650 0 V 0 D 0 0
42418 224128 variant_image 54651 0 V 0 D 0 0
42419 224129 variant_image 54652 0 V 0 D 0 0
42420 224130 variant_image 54653 0 V 0 D 0 0
42421 224131 variant_image 54654 0 V 0 D 0 0
42422 224132 variant_image 54655 0 V 0 D 0 0
42423 224133 variant_image 54656 0 V 0 D 0 0
42424 224134 variant_image 54657 0 V 0 D 0 0
42425 224135 variant_image 54658 0 V 0 D 0 0
42426 224136 variant_image 54659 0 V 0 D 0 0
42427 224137 variant_image 54660 0 V 0 D 0 0
42428 224138 variant_image 54661 0 V 0 D 0 0
42429 224139 variant_image 54662 0 V 0 D 0 0
42430 224140 variant_image 54663 0 V 0 D 0 0
42431 224141 variant_image 54664 0 V 0 D 0 0
42435 224146 variant_image 54668 0 V 0 D 0 0
42436 224147 variant_image 54669 0 V 0 D 0 0
42437 224148 variant_image 54670 0 V 0 D 0 0
42438 224149 variant_image 54671 0 V 0 D 0 0
42526 224112 variant_image 54759 0 V 0 D 0 0
59869 237122 variant_image 72102 0 V 0 D 0 0
59870 237123 variant_image 72103 0 V 0 D 0 0
59871 237124 variant_image 72104 0 V 0 D 0 0
59872 237125 variant_image 72105 0 V 0 D 0 0
59873 237126 variant_image 72106 0 V 0 D 0 0
59874 237127 variant_image 72107 0 V 0 D 0 0
69962 240583 variant_image 82195 0 V 0 D 0 0
69963 240584 variant_image 82196 0 V 0 D 0 0
69964 240585 variant_image 82197 0 V 0 D 0 0
69965 240586 variant_image 82198 0 V 0 D 0 0
69966 240587 variant_image 82199 0 V 0 D 0 0
69967 240588 variant_image 82200 0 V 0 D 0 0
69968 240589 variant_image 82201 0 V 0 D 0 0
69969 240590 variant_image 82202 0 V 0 D 0 0
69970 240591 variant_image 82203 0 V 0 D 0 0
69971 240592 variant_image 82204 0 V 0 D 0 0
69972 240593 variant_image 82205 0 V 0 D 0 0
69973 240594 variant_image 82206 0 V 0 D 0 0
69974 240595 variant_image 82207 0 V 0 D 0 0
69983 240604 variant_image 82216 0 V 0 D 0 0
69984 240606 variant_image 82217 0 V 0 D 0 0
69985 240607 variant_image 82218 0 V 0 D 0 0
69986 240608 variant_image 82219 0 V 0 D 0 0
69987 240609 variant_image 82220 0 V 0 D 0 0
69988 240610 variant_image 82221 0 V 0 D 0 0
69989 240611 variant_image 82222 0 V 0 D 0 0
69990 240612 variant_image 82223 0 V 0 D 0 0
69991 240613 variant_image 82224 0 V 0 D 0 0
69992 240614 variant_image 82225 0 V 0 D 0 0
69993 240615 variant_image 82226 0 V 0 D 0 0
69994 240616 variant_image 82227 0 V 0 D 0 0
69995 240617 variant_image 82228 0 V 0 D 0 0
69996 240618 variant_image 82229 0 V 0 D 0 0
70005 240627 variant_image 82238 0 V 0 D 0 0
70006 240629 variant_image 82239 0 V 0 D 0 0
70007 240630 variant_image 82240 0 V 0 D 0 0
70008 240631 variant_image 82241 0 V 0 D 0 0
70009 240632 variant_image 82242 0 V 0 D 0 0
70010 240633 variant_image 82243 0 V 0 D 0 0
70011 240634 variant_image 82244 0 V 0 D 0 0
70012 240635 variant_image 82245 0 V 0 D 0 0
70013 240636 variant_image 82246 0 V 0 D 0 0
70014 240637 variant_image 82247 0 V 0 D 0 0
70015 240638 variant_image 82248 0 V 0 D 0 0
70016 240639 variant_image 82249 0 V 0 D 0 0
70017 240640 variant_image 82250 0 V 0 D 0 0
70018 240641 variant_image 82251 0 V 0 D 0 0
70027 240650 variant_image 82260 0 V 0 D 0 0
71633 242075 variant_image 83866 0 V 0 D 0 0
71634 242076 variant_image 83867 0 V 0 D 0 0
71635 242077 variant_image 83868 0 V 0 D 0 0
71636 242078 variant_image 83869 0 V 0 D 0 0
71637 242079 variant_image 83870 0 V 0 D 0 0
71638 242080 variant_image 83871 0 V 0 D 0 0
71639 242081 variant_image 83872 0 V 0 D 0 0
71640 242082 variant_image 83873 0 V 0 D 0 0
71641 242083 variant_image 83874 0 V 0 D 0 0
71642 242084 variant_image 83875 0 V 0 D 0 0
72365 242756 variant_image 84598 0 V 0 D 0 0
72366 242757 variant_image 84599 0 V 0 D 0 0
72367 242758 variant_image 84600 0 V 0 D 0 0
72368 242760 variant_image 84601 0 V 0 D 0 0
72369 242761 variant_image 84602 0 V 0 D 0 0
72370 242762 variant_image 84603 0 V 0 D 0 0
72371 242763 variant_image 84604 0 V 0 D 0 0
72372 242764 variant_image 84605 0 V 0 D 0 0
72373 242765 variant_image 84606 0 V 0 D 0 0
72374 242766 variant_image 84607 0 V 0 D 0 0
72375 242767 variant_image 84608 0 V 0 D 0 0
72376 242768 variant_image 84609 0 V 0 D 0 0
72377 242759 variant_image 84610 0 V 0 D 0 0
72795 243079 variant_image 85028 0 V 0 D 0 0
72796 243080 variant_image 85029 0 V 0 D 0 0
72797 243081 variant_image 85030 0 V 0 D 0 0
72798 243082 variant_image 85031 0 V 0 D 0 0
72799 243083 variant_image 85032 0 V 0 D 0 0
72800 243084 variant_image 85033 0 V 0 D 0 0
72801 243085 variant_image 85034 0 V 0 D 0 0
72802 243086 variant_image 85035 0 V 0 D 0 0
72803 243087 variant_image 85036 0 V 0 D 0 0
72804 243088 variant_image 85037 0 V 0 D 0 0
72805 243089 variant_image 85038 0 V 0 D 0 0
72806 243090 variant_image 85039 0 V 0 D 0 0