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, 
    227161, 
    227152, 
    227153, 
    227154, 
    227191, 
    227193, 
    227192, 
    227233, 
    227198, 
    227199, 
    227200, 
    227201, 
    227202, 
    227203, 
    237054, 
    237055, 
    227204, 
    242736, 
    241974, 
    227205, 
    227206, 
    227207, 
    227208, 
    227209, 
    241975, 
    227210, 
    227211, 
    227212, 
    227213, 
    227214, 
    227215, 
    227216, 
    227217, 
    241976, 
    227218, 
    241977, 
    227219, 
    227220, 
    242737, 
    242738, 
    227221, 
    227222, 
    227223, 
    242739, 
    241978, 
    227228, 
    227229, 
    227230, 
    227231, 
    227232, 
    227335, 
    227336, 
    227337, 
    227338, 
    227339, 
    227340, 
    227341, 
    227342, 
    227343, 
    227392, 
    227362, 
    227363, 
    227364, 
    227365, 
    227366, 
    227367, 
    237060, 
    237061, 
    227368, 
    242744, 
    242009, 
    227369, 
    227370, 
    227371, 
    227372, 
    227373, 
    242010, 
    227374, 
    227375, 
    227376, 
    227377, 
    227378, 
    227379, 
    227380, 
    227381, 
    242011, 
    227382, 
    242012, 
    227383, 
    227384, 
    242745, 
    242746, 
    227385, 
    227386, 
    227387, 
    242747, 
    242013, 
    227550, 
    227519, 
    227520, 
    227521, 
    227522, 
    227523, 
    227524, 
    227544, 
    227525, 
    237166, 
    237167, 
    227526, 
    242019, 
    227527, 
    227528, 
    227529, 
    227530, 
    227531, 
    242020, 
    227532, 
    227533, 
    227534, 
    227535, 
    227536, 
    227537, 
    227538, 
    227539, 
    242021, 
    227540, 
    242022, 
    227541, 
    227542, 
    239065, 
    227543, 
    242023, 
    242803, 
    242804, 
    242805, 
    242806, 
    227548, 
    227549, 
    227585, 
    227555, 
    227556, 
    227557, 
    227558, 
    227559, 
    227579, 
    227560, 
    237168, 
    237169, 
    227561, 
    242024, 
    227562, 
    227563, 
    227564, 
    227565, 
    227566, 
    242025, 
    227567, 
    227568, 
    227569, 
    227570, 
    227571, 
    227572, 
    227573, 
    227574, 
    242026, 
    227575, 
    242027, 
    227576, 
    227577, 
    239066, 
    227578, 
    242028, 
    242807, 
    242808, 
    242809, 
    242810, 
    227583, 
    227584, 
    227593, 
    227590, 
    227591, 
    227592, 
    227597, 
    227594, 
    227595, 
    227596, 
    227601, 
    227598, 
    227599, 
    227600, 
    227604, 
    227602, 
    227603, 
    227607, 
    227605, 
    227606, 
    227857, 
    227858, 
    227859, 
    227860, 
    227861
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00245

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": 217,
          "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,227161,227152,227153,227154,227191,227193,227192,227233,227198,227199,227200,227201,227202,227203,237054,237055,227204,242736,241974,227205,227206,227207,227208,227209,241975,227210,227211,227212,227213,227214,227215,227216,227217,241976,227218,241977,227219,227220,242737,242738,227221,227222,227223,242739,241978,227228,227229,227230,227231,227232,227335,227336,227337,227338,227339,227340,227341,227342,227343,227392,227362,227363,227364,227365,227366,227367,237060,237061,227368,242744,242009,227369,227370,227371,227372,227373,242010,227374,227375,227376,227377,227378,227379,227380,227381,242011,227382,242012,227383,227384,242745,242746,227385,227386,227387,242747,242013,227550,227519,227520,227521,227522,227523,227524,227544,227525,237166,237167,227526,242019,227527,227528,227529,227530,227531,242020,227532,227533,227534,227535,227536,227537,227538,227539,242021,227540,242022,227541,227542,239065,227543,242023,242803,242804,242805,242806,227548,227549,227585,227555,227556,227557,227558,227559,227579,227560,237168,237169,227561,242024,227562,227563,227564,227565,227566,242025,227567,227568,227569,227570,227571,227572,227573,227574,242026,227575,242027,227576,227577,239066,227578,242028,242807,242808,242809,242810,227583,227584,227593,227590,227591,227592,227597,227594,227595,227596,227601,227598,227599,227600,227604,227602,227603,227607,227605,227606,227857,227858,227859,227860,227861)"
        }
      }
    },
    "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
45339 227152 variant_image 57572 0 V 0 D 0 0
45340 227153 variant_image 57573 0 V 0 D 0 0
45341 227154 variant_image 57574 0 V 0 D 0 0
45368 227198 variant_image 57601 0 V 0 D 0 0
45369 227199 variant_image 57602 0 V 0 D 0 0
45370 227200 variant_image 57603 0 V 0 D 0 0
45371 227201 variant_image 57604 0 V 0 D 0 0
45372 227202 variant_image 57605 0 V 0 D 0 0
45373 227203 variant_image 57606 0 V 0 D 0 0
45374 227204 variant_image 57607 0 V 0 D 0 0
45375 227205 variant_image 57608 0 V 0 D 0 0
45376 227206 variant_image 57609 0 V 0 D 0 0
45377 227207 variant_image 57610 0 V 0 D 0 0
45378 227208 variant_image 57611 0 V 0 D 0 0
45379 227209 variant_image 57612 0 V 0 D 0 0
45380 227210 variant_image 57613 0 V 0 D 0 0
45381 227211 variant_image 57614 0 V 0 D 0 0
45382 227212 variant_image 57615 0 V 0 D 0 0
45383 227213 variant_image 57616 0 V 0 D 0 0
45384 227214 variant_image 57617 0 V 0 D 0 0
45385 227215 variant_image 57618 0 V 0 D 0 0
45386 227216 variant_image 57619 0 V 0 D 0 0
45387 227217 variant_image 57620 0 V 0 D 0 0
45388 227218 variant_image 57621 0 V 0 D 0 0
45389 227219 variant_image 57622 0 V 0 D 0 0
45390 227220 variant_image 57623 0 V 0 D 0 0
45391 227221 variant_image 57624 0 V 0 D 0 0
45392 227222 variant_image 57625 0 V 0 D 0 0
45393 227223 variant_image 57626 0 V 0 D 0 0
45398 227228 variant_image 57631 0 V 0 D 0 0
45399 227229 variant_image 57632 0 V 0 D 0 0
45400 227230 variant_image 57633 0 V 0 D 0 0
45401 227231 variant_image 57634 0 V 0 D 0 0
45402 227232 variant_image 57635 0 V 0 D 0 0
45500 227336 variant_image 57733 0 V 0 D 0 0
45501 227337 variant_image 57734 0 V 0 D 0 0
45502 227339 variant_image 57735 0 V 0 D 0 0
45503 227340 variant_image 57736 0 V 0 D 0 0
45504 227342 variant_image 57737 0 V 0 D 0 0
45505 227343 variant_image 57738 0 V 0 D 0 0
45518 227362 variant_image 57751 0 V 0 D 0 0
45519 227363 variant_image 57752 0 V 0 D 0 0
45520 227364 variant_image 57753 0 V 0 D 0 0
45521 227365 variant_image 57754 0 V 0 D 0 0
45522 227366 variant_image 57755 0 V 0 D 0 0
45523 227367 variant_image 57756 0 V 0 D 0 0
45524 227368 variant_image 57757 0 V 0 D 0 0
45525 227369 variant_image 57758 0 V 0 D 0 0
45526 227370 variant_image 57759 0 V 0 D 0 0
45527 227371 variant_image 57760 0 V 0 D 0 0
45528 227372 variant_image 57761 0 V 0 D 0 0
45529 227373 variant_image 57762 0 V 0 D 0 0
45530 227374 variant_image 57763 0 V 0 D 0 0
45531 227375 variant_image 57764 0 V 0 D 0 0
45532 227376 variant_image 57765 0 V 0 D 0 0
45533 227377 variant_image 57766 0 V 0 D 0 0
45534 227378 variant_image 57767 0 V 0 D 0 0
45535 227379 variant_image 57768 0 V 0 D 0 0
45536 227380 variant_image 57769 0 V 0 D 0 0
45537 227381 variant_image 57770 0 V 0 D 0 0
45538 227382 variant_image 57771 0 V 0 D 0 0
45539 227383 variant_image 57772 0 V 0 D 0 0
45540 227384 variant_image 57773 0 V 0 D 0 0
45541 227385 variant_image 57774 0 V 0 D 0 0
45542 227386 variant_image 57775 0 V 0 D 0 0
45543 227387 variant_image 57776 0 V 0 D 0 0
45627 227520 variant_image 57860 0 V 0 D 0 0
45628 227521 variant_image 57861 0 V 0 D 0 0
45629 227522 variant_image 57862 0 V 0 D 0 0
45630 227523 variant_image 57863 0 V 0 D 0 0
45631 227524 variant_image 57864 0 V 0 D 0 0
45632 227525 variant_image 57865 0 V 0 D 0 0
45633 227526 variant_image 57866 0 V 0 D 0 0
45634 227527 variant_image 57867 0 V 0 D 0 0
45635 227528 variant_image 57868 0 V 0 D 0 0
45636 227529 variant_image 57869 0 V 0 D 0 0
45637 227530 variant_image 57870 0 V 0 D 0 0
45638 227531 variant_image 57871 0 V 0 D 0 0
45639 227532 variant_image 57872 0 V 0 D 0 0
45640 227533 variant_image 57873 0 V 0 D 0 0
45641 227534 variant_image 57874 0 V 0 D 0 0
45642 227535 variant_image 57875 0 V 0 D 0 0
45643 227536 variant_image 57876 0 V 0 D 0 0
45644 227537 variant_image 57877 0 V 0 D 0 0
45645 227538 variant_image 57878 0 V 0 D 0 0
45646 227539 variant_image 57879 0 V 0 D 0 0
45647 227540 variant_image 57880 0 V 0 D 0 0
45648 227541 variant_image 57881 0 V 0 D 0 0
45649 227542 variant_image 57882 0 V 0 D 0 0
45650 227543 variant_image 57883 0 V 0 D 0 0
45651 227544 variant_image 57884 0 V 0 D 0 0
45655 227548 variant_image 57888 0 V 0 D 0 0
45656 227549 variant_image 57889 0 V 0 D 0 0
45661 227555 variant_image 57894 0 V 0 D 0 0
45662 227556 variant_image 57895 0 V 0 D 0 0
45663 227557 variant_image 57896 0 V 0 D 0 0
45664 227558 variant_image 57897 0 V 0 D 0 0
45665 227559 variant_image 57898 0 V 0 D 0 0
45666 227560 variant_image 57899 0 V 0 D 0 0
45667 227561 variant_image 57900 0 V 0 D 0 0
45668 227562 variant_image 57901 0 V 0 D 0 0
45669 227563 variant_image 57902 0 V 0 D 0 0
45670 227564 variant_image 57903 0 V 0 D 0 0
45671 227565 variant_image 57904 0 V 0 D 0 0
45672 227566 variant_image 57905 0 V 0 D 0 0
45673 227567 variant_image 57906 0 V 0 D 0 0
45674 227568 variant_image 57907 0 V 0 D 0 0
45675 227569 variant_image 57908 0 V 0 D 0 0
45676 227570 variant_image 57909 0 V 0 D 0 0
45677 227571 variant_image 57910 0 V 0 D 0 0
45678 227572 variant_image 57911 0 V 0 D 0 0
45679 227573 variant_image 57912 0 V 0 D 0 0
45680 227574 variant_image 57913 0 V 0 D 0 0
45681 227575 variant_image 57914 0 V 0 D 0 0
45682 227576 variant_image 57915 0 V 0 D 0 0
45683 227577 variant_image 57916 0 V 0 D 0 0
45684 227578 variant_image 57917 0 V 0 D 0 0
45685 227579 variant_image 57918 0 V 0 D 0 0
45689 227583 variant_image 57922 0 V 0 D 0 0
45690 227584 variant_image 57923 0 V 0 D 0 0
45695 227590 variant_image 57928 0 V 0 D 0 0
45696 227591 variant_image 57929 0 V 0 D 0 0
45697 227592 variant_image 57930 0 V 0 D 0 0
45698 227594 variant_image 57931 0 V 0 D 0 0
45699 227595 variant_image 57932 0 V 0 D 0 0
45700 227596 variant_image 57933 0 V 0 D 0 0
45701 227598 variant_image 57934 0 V 0 D 0 0
45702 227599 variant_image 57935 0 V 0 D 0 0
45703 227600 variant_image 57936 0 V 0 D 0 0
45704 227602 variant_image 57937 0 V 0 D 0 0
45705 227603 variant_image 57938 0 V 0 D 0 0
45706 227605 variant_image 57939 0 V 0 D 0 0
45707 227606 variant_image 57940 0 V 0 D 0 0
45971 227858 variant_image 58204 0 V 0 D 0 0
45972 227859 variant_image 58205 0 V 0 D 0 0
45973 227860 variant_image 58206 0 V 0 D 0 0
45974 227861 variant_image 58207 0 V 0 D 0 0
59801 237054 variant_image 72034 0 V 0 D 0 0
59802 237055 variant_image 72035 0 V 0 D 0 0
59807 237060 variant_image 72040 0 V 0 D 0 0
59808 237061 variant_image 72041 0 V 0 D 0 0
59913 237166 variant_image 72146 0 V 0 D 0 0
59914 237167 variant_image 72147 0 V 0 D 0 0
59915 237168 variant_image 72148 0 V 0 D 0 0
59916 237169 variant_image 72149 0 V 0 D 0 0
64692 239065 variant_image 76925 0 V 0 D 0 0
64693 239066 variant_image 76926 0 V 0 D 0 0
71527 241974 variant_image 83760 0 V 0 D 0 0
71528 241975 variant_image 83761 0 V 0 D 0 0
71529 241976 variant_image 83762 0 V 0 D 0 0
71530 241977 variant_image 83763 0 V 0 D 0 0
71531 241978 variant_image 83764 0 V 0 D 0 0
71562 242009 variant_image 83795 0 V 0 D 0 0
71563 242010 variant_image 83796 0 V 0 D 0 0
71564 242011 variant_image 83797 0 V 0 D 0 0
71565 242012 variant_image 83798 0 V 0 D 0 0
71566 242013 variant_image 83799 0 V 0 D 0 0
71572 242019 variant_image 83805 0 V 0 D 0 0
71573 242020 variant_image 83806 0 V 0 D 0 0
71574 242021 variant_image 83807 0 V 0 D 0 0
71575 242022 variant_image 83808 0 V 0 D 0 0
71576 242023 variant_image 83809 0 V 0 D 0 0
71577 242024 variant_image 83810 0 V 0 D 0 0
71578 242025 variant_image 83811 0 V 0 D 0 0
71579 242026 variant_image 83812 0 V 0 D 0 0
71580 242027 variant_image 83813 0 V 0 D 0 0
71581 242028 variant_image 83814 0 V 0 D 0 0
72345 242736 variant_image 84578 0 V 0 D 0 0
72346 242737 variant_image 84579 0 V 0 D 0 0
72347 242738 variant_image 84580 0 V 0 D 0 0
72348 242739 variant_image 84581 0 V 0 D 0 0
72353 242744 variant_image 84586 0 V 0 D 0 0
72354 242745 variant_image 84587 0 V 0 D 0 0
72355 242746 variant_image 84588 0 V 0 D 0 0
72356 242747 variant_image 84589 0 V 0 D 0 0
72412 242803 variant_image 84645 0 V 0 D 0 0
72413 242804 variant_image 84646 0 V 0 D 0 0
72414 242805 variant_image 84647 0 V 0 D 0 0
72415 242806 variant_image 84648 0 V 0 D 0 0
72416 242807 variant_image 84649 0 V 0 D 0 0
72417 242808 variant_image 84650 0 V 0 D 0 0
72418 242809 variant_image 84651 0 V 0 D 0 0
72419 242810 variant_image 84652 0 V 0 D 0 0