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 (
    220134, 
    244806, 
    244807, 
    244808, 
    244809, 
    244810, 
    244811, 
    244812, 
    244813, 
    217349, 
    217350, 
    217351, 
    217352, 
    217353, 
    217354, 
    236858, 
    236859, 
    217355, 
    245256, 
    241005, 
    217356, 
    217357, 
    217358, 
    217359, 
    217360, 
    241006, 
    217361, 
    217362, 
    217363, 
    217364, 
    217365, 
    217366, 
    217367, 
    217368, 
    241007, 
    217369, 
    241008, 
    217370, 
    217371, 
    245257, 
    245258, 
    225913, 
    217372, 
    217373, 
    245259, 
    241009, 
    217374, 
    217375, 
    217376, 
    217377, 
    217379, 
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    220233, 
    218155, 
    218156, 
    218157, 
    218158, 
    218159, 
    218160, 
    220248, 
    218161, 
    218162, 
    218163, 
    220249, 
    218171, 
    218172, 
    218173, 
    220250, 
    218181, 
    218182, 
    218183, 
    220273, 
    218191, 
    218192, 
    218193, 
    218194, 
    218195, 
    218196, 
    236862, 
    236863, 
    218197, 
    245264, 
    241021, 
    218198, 
    218199, 
    218200, 
    218201, 
    218202, 
    241022, 
    218203, 
    218204, 
    218205, 
    218206, 
    218207, 
    218208, 
    218209, 
    218210, 
    241023, 
    218211, 
    241024, 
    218212, 
    218213, 
    245265, 
    245266, 
    218214, 
    218215, 
    218216, 
    245267, 
    241025, 
    220274, 
    244822, 
    244823, 
    244824, 
    244825, 
    244826, 
    244827, 
    244828, 
    244829, 
    220275, 
    244830, 
    244831, 
    244832, 
    244833, 
    244834, 
    244835, 
    244836, 
    244837, 
    220276, 
    218271, 
    218272, 
    218273, 
    218274, 
    218275, 
    218276, 
    236864, 
    236865, 
    218277, 
    245268, 
    241026, 
    218278, 
    218279, 
    218280, 
    218281, 
    218282, 
    241027, 
    218283, 
    218284, 
    218285, 
    218286, 
    218287, 
    218288, 
    218289, 
    218290, 
    241028, 
    218291, 
    241029, 
    218292, 
    218293, 
    245269, 
    245270, 
    225924, 
    218294, 
    218295, 
    245271, 
    241030, 
    220277, 
    244838, 
    244839, 
    244840, 
    244841, 
    244842, 
    244843, 
    244844, 
    244845, 
    220279, 
    218308, 
    218309, 
    218310, 
    218311, 
    218312, 
    218313, 
    236866, 
    236867, 
    218314, 
    245272, 
    241031, 
    218315, 
    218316, 
    218317, 
    218318, 
    218319, 
    241032, 
    218320, 
    218321, 
    218322, 
    218323, 
    218324, 
    218325, 
    218326, 
    218327, 
    241033, 
    218328, 
    241034, 
    218329, 
    218330, 
    245273, 
    245274, 
    218331, 
    218332, 
    218333, 
    245275, 
    241035, 
    220318, 
    215376, 
    215377, 
    230564, 
    230565, 
    230566, 
    230567, 
    230568, 
    230569, 
    230576, 
    230571, 
    230572, 
    230573, 
    230574, 
    230575, 
    238140
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00259

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": 246,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220134,244806,244807,244808,244809,244810,244811,244812,244813,217349,217350,217351,217352,217353,217354,236858,236859,217355,245256,241005,217356,217357,217358,217359,217360,241006,217361,217362,217363,217364,217365,217366,217367,217368,241007,217369,241008,217370,217371,245257,245258,225913,217372,217373,245259,241009,217374,217375,217376,217377,217379,220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,220233,218155,218156,218157,218158,218159,218160,220248,218161,218162,218163,220249,218171,218172,218173,220250,218181,218182,218183,220273,218191,218192,218193,218194,218195,218196,236862,236863,218197,245264,241021,218198,218199,218200,218201,218202,241022,218203,218204,218205,218206,218207,218208,218209,218210,241023,218211,241024,218212,218213,245265,245266,218214,218215,218216,245267,241025,220274,244822,244823,244824,244825,244826,244827,244828,244829,220275,244830,244831,244832,244833,244834,244835,244836,244837,220276,218271,218272,218273,218274,218275,218276,236864,236865,218277,245268,241026,218278,218279,218280,218281,218282,241027,218283,218284,218285,218286,218287,218288,218289,218290,241028,218291,241029,218292,218293,245269,245270,225924,218294,218295,245271,241030,220277,244838,244839,244840,244841,244842,244843,244844,244845,220279,218308,218309,218310,218311,218312,218313,236866,236867,218314,245272,241031,218315,218316,218317,218318,218319,241032,218320,218321,218322,218323,218324,218325,218326,218327,241033,218328,241034,218329,218330,245273,245274,218331,218332,218333,245275,241035,220318,215376,215377,230564,230565,230566,230567,230568,230569,230576,230571,230572,230573,230574,230575,238140)"
        }
      }
    },
    "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
33513 215556 variant_image 45746 0 V 0 D 0 0
33514 215557 variant_image 45747 0 V 0 D 0 0
33515 215558 variant_image 45748 0 V 0 D 0 0
33516 215559 variant_image 45749 0 V 0 D 0 0
33517 215560 variant_image 45750 0 V 0 D 0 0
33518 215561 variant_image 45751 0 V 0 D 0 0
33519 215562 variant_image 45752 0 V 0 D 0 0
33520 215563 variant_image 45753 0 V 0 D 0 0
33521 215564 variant_image 45754 0 V 0 D 0 0
33522 215565 variant_image 45755 0 V 0 D 0 0
33523 215566 variant_image 45756 0 V 0 D 0 0
33524 215567 variant_image 45757 0 V 0 D 0 0
33525 215568 variant_image 45758 0 V 0 D 0 0
33526 215569 variant_image 45759 0 V 0 D 0 0
35563 217349 variant_image 47796 0 V 0 D 0 0
35564 217350 variant_image 47797 0 V 0 D 0 0
35565 217351 variant_image 47798 0 V 0 D 0 0
35566 217352 variant_image 47799 0 V 0 D 0 0
35567 217353 variant_image 47800 0 V 0 D 0 0
35568 217354 variant_image 47801 0 V 0 D 0 0
35569 217355 variant_image 47802 0 V 0 D 0 0
35570 217356 variant_image 47803 0 V 0 D 0 0
35571 217357 variant_image 47804 0 V 0 D 0 0
35572 217358 variant_image 47805 0 V 0 D 0 0
35573 217359 variant_image 47806 0 V 0 D 0 0
35574 217360 variant_image 47807 0 V 0 D 0 0
35575 217361 variant_image 47808 0 V 0 D 0 0
35576 217362 variant_image 47809 0 V 0 D 0 0
35577 217363 variant_image 47810 0 V 0 D 0 0
35578 217364 variant_image 47811 0 V 0 D 0 0
35579 217365 variant_image 47812 0 V 0 D 0 0
35580 217366 variant_image 47813 0 V 0 D 0 0
35581 217367 variant_image 47814 0 V 0 D 0 0
35582 217368 variant_image 47815 0 V 0 D 0 0
35583 217369 variant_image 47816 0 V 0 D 0 0
35584 217370 variant_image 47817 0 V 0 D 0 0
35585 217371 variant_image 47818 0 V 0 D 0 0
35586 217372 variant_image 47819 0 V 0 D 0 0
35587 217373 variant_image 47820 0 V 0 D 0 0
35588 217374 variant_image 47821 0 V 0 D 0 0
35589 217375 variant_image 47822 0 V 0 D 0 0
35590 217376 variant_image 47823 0 V 0 D 0 0
35591 217377 variant_image 47824 0 V 0 D 0 0
35592 217379 variant_image 47825 0 V 0 D 0 0
36653 218155 variant_image 48886 0 V 0 D 0 0
36654 218156 variant_image 48887 0 V 0 D 0 0
36655 218157 variant_image 48888 0 V 0 D 0 0
36656 218158 variant_image 48889 0 V 0 D 0 0
36657 218159 variant_image 48890 0 V 0 D 0 0
36658 218160 variant_image 48891 0 V 0 D 0 0
36659 218161 variant_image 48892 0 V 0 D 0 0
36660 218162 variant_image 48893 0 V 0 D 0 0
36661 218163 variant_image 48894 0 V 0 D 0 0
36669 218171 variant_image 48902 0 V 0 D 0 0
36670 218172 variant_image 48903 0 V 0 D 0 0
36671 218173 variant_image 48904 0 V 0 D 0 0
36679 218181 variant_image 48912 0 V 0 D 0 0
36680 218182 variant_image 48913 0 V 0 D 0 0
36681 218183 variant_image 48914 0 V 0 D 0 0
36689 218191 variant_image 48922 0 V 0 D 0 0
36690 218192 variant_image 48923 0 V 0 D 0 0
36691 218193 variant_image 48924 0 V 0 D 0 0
36692 218194 variant_image 48925 0 V 0 D 0 0
36693 218195 variant_image 48926 0 V 0 D 0 0
36694 218196 variant_image 48927 0 V 0 D 0 0
36695 218197 variant_image 48928 0 V 0 D 0 0
36696 218198 variant_image 48929 0 V 0 D 0 0
36697 218199 variant_image 48930 0 V 0 D 0 0
36698 218200 variant_image 48931 0 V 0 D 0 0
36699 218201 variant_image 48932 0 V 0 D 0 0
36700 218202 variant_image 48933 0 V 0 D 0 0
36701 218203 variant_image 48934 0 V 0 D 0 0
36702 218204 variant_image 48935 0 V 0 D 0 0
36703 218205 variant_image 48936 0 V 0 D 0 0
36704 218206 variant_image 48937 0 V 0 D 0 0
36705 218207 variant_image 48938 0 V 0 D 0 0
36706 218208 variant_image 48939 0 V 0 D 0 0
36707 218209 variant_image 48940 0 V 0 D 0 0
36708 218210 variant_image 48941 0 V 0 D 0 0
36709 218211 variant_image 48942 0 V 0 D 0 0
36710 218212 variant_image 48943 0 V 0 D 0 0
36711 218213 variant_image 48944 0 V 0 D 0 0
36712 218214 variant_image 48945 0 V 0 D 0 0
36713 218215 variant_image 48946 0 V 0 D 0 0
36714 218216 variant_image 48947 0 V 0 D 0 0
36744 218271 variant_image 48977 0 V 0 D 0 0
36745 218272 variant_image 48978 0 V 0 D 0 0
36746 218273 variant_image 48979 0 V 0 D 0 0
36747 218274 variant_image 48980 0 V 0 D 0 0
36748 218275 variant_image 48981 0 V 0 D 0 0
36749 218276 variant_image 48982 0 V 0 D 0 0
36750 218277 variant_image 48983 0 V 0 D 0 0
36751 218278 variant_image 48984 0 V 0 D 0 0
36752 218279 variant_image 48985 0 V 0 D 0 0
36753 218280 variant_image 48986 0 V 0 D 0 0
36754 218281 variant_image 48987 0 V 0 D 0 0
36755 218282 variant_image 48988 0 V 0 D 0 0
36756 218283 variant_image 48989 0 V 0 D 0 0
36757 218284 variant_image 48990 0 V 0 D 0 0
36758 218285 variant_image 48991 0 V 0 D 0 0
36759 218286 variant_image 48992 0 V 0 D 0 0
36760 218287 variant_image 48993 0 V 0 D 0 0
36761 218288 variant_image 48994 0 V 0 D 0 0
36762 218289 variant_image 48995 0 V 0 D 0 0
36763 218290 variant_image 48996 0 V 0 D 0 0
36776 218308 variant_image 49009 0 V 0 D 0 0
36777 218309 variant_image 49010 0 V 0 D 0 0
36778 218310 variant_image 49011 0 V 0 D 0 0
36779 218311 variant_image 49012 0 V 0 D 0 0
36780 218312 variant_image 49013 0 V 0 D 0 0
36781 218313 variant_image 49014 0 V 0 D 0 0
36782 218314 variant_image 49015 0 V 0 D 0 0
36783 218315 variant_image 49016 0 V 0 D 0 0
36784 218316 variant_image 49017 0 V 0 D 0 0
36785 218317 variant_image 49018 0 V 0 D 0 0
36786 218318 variant_image 49019 0 V 0 D 0 0
36787 218319 variant_image 49020 0 V 0 D 0 0
36788 218320 variant_image 49021 0 V 0 D 0 0
36789 218321 variant_image 49022 0 V 0 D 0 0
36790 218322 variant_image 49023 0 V 0 D 0 0
36791 218323 variant_image 49024 0 V 0 D 0 0
36792 218324 variant_image 49025 0 V 0 D 0 0
36793 218325 variant_image 49026 0 V 0 D 0 0
36794 218326 variant_image 49027 0 V 0 D 0 0
36795 218327 variant_image 49028 0 V 0 D 0 0
36944 218329 variant_image 49177 0 V 0 D 0 0
36945 218330 variant_image 49178 0 V 0 D 0 0
36946 218331 variant_image 49179 0 V 0 D 0 0
36947 218332 variant_image 49180 0 V 0 D 0 0
36948 218333 variant_image 49181 0 V 0 D 0 0
36949 218291 variant_image 49182 0 V 0 D 0 0
36950 218292 variant_image 49183 0 V 0 D 0 0
36951 218293 variant_image 49184 0 V 0 D 0 0
36952 218294 variant_image 49185 0 V 0 D 0 0
36953 218295 variant_image 49186 0 V 0 D 0 0
38389 218328 variant_image 50622 0 V 0 D 0 0
44123 225913 variant_image 56356 0 V 0 D 0 0
44141 225924 variant_image 56374 0 V 0 D 0 0
49304 230571 variant_image 61537 0 V 0 D 0 0
49305 230572 variant_image 61538 0 V 0 D 0 0
49306 230573 variant_image 61539 0 V 0 D 0 0
49307 230574 variant_image 61540 0 V 0 D 0 0
49308 230575 variant_image 61541 0 V 0 D 0 0
59600 236858 variant_image 71833 0 V 0 D 0 0
59601 236859 variant_image 71834 0 V 0 D 0 0
59604 236862 variant_image 71837 0 V 0 D 0 0
59605 236863 variant_image 71838 0 V 0 D 0 0
59606 236864 variant_image 71839 0 V 0 D 0 0
59607 236865 variant_image 71840 0 V 0 D 0 0
59608 236866 variant_image 71841 0 V 0 D 0 0
59609 236867 variant_image 71842 0 V 0 D 0 0
61549 238140 variant_image 73782 0 V 0 D 0 0
70540 241005 variant_image 82773 0 V 0 D 0 0
70541 241006 variant_image 82774 0 V 0 D 0 0
70542 241007 variant_image 82775 0 V 0 D 0 0
70543 241008 variant_image 82776 0 V 0 D 0 0
70544 241009 variant_image 82777 0 V 0 D 0 0
70556 241021 variant_image 82789 0 V 0 D 0 0
70557 241022 variant_image 82790 0 V 0 D 0 0
70558 241023 variant_image 82791 0 V 0 D 0 0
70559 241024 variant_image 82792 0 V 0 D 0 0
70560 241025 variant_image 82793 0 V 0 D 0 0
70561 241026 variant_image 82794 0 V 0 D 0 0
70562 241027 variant_image 82795 0 V 0 D 0 0
70563 241028 variant_image 82796 0 V 0 D 0 0
70564 241029 variant_image 82797 0 V 0 D 0 0
70565 241030 variant_image 82798 0 V 0 D 0 0
70566 241031 variant_image 82799 0 V 0 D 0 0
70567 241032 variant_image 82800 0 V 0 D 0 0
70568 241033 variant_image 82801 0 V 0 D 0 0
70569 241034 variant_image 82802 0 V 0 D 0 0
70570 241035 variant_image 82803 0 V 0 D 0 0
72819 243103 variant_image 85052 0 V 0 D 0 0
72820 243104 variant_image 85053 0 V 0 D 0 0
72821 243105 variant_image 85054 0 V 0 D 0 0
72822 243106 variant_image 85055 0 V 0 D 0 0
74598 244806 variant_image 86831 0 V 0 D 0 0
74599 244807 variant_image 86832 0 V 0 D 0 0
74600 244808 variant_image 86833 0 V 0 D 0 0
74601 244809 variant_image 86834 0 V 0 D 0 0
74602 244810 variant_image 86835 0 V 0 D 0 0
74603 244811 variant_image 86836 0 V 0 D 0 0
74604 244812 variant_image 86837 0 V 0 D 0 0
74605 244813 variant_image 86838 0 V 0 D 0 0
74614 244822 variant_image 86847 0 V 0 D 0 0
74615 244823 variant_image 86848 0 V 0 D 0 0
74616 244824 variant_image 86849 0 V 0 D 0 0
74617 244825 variant_image 86850 0 V 0 D 0 0
74618 244826 variant_image 86851 0 V 0 D 0 0
74619 244827 variant_image 86852 0 V 0 D 0 0
74620 244828 variant_image 86853 0 V 0 D 0 0
74621 244829 variant_image 86854 0 V 0 D 0 0
74622 244830 variant_image 86855 0 V 0 D 0 0
74623 244831 variant_image 86856 0 V 0 D 0 0
74624 244832 variant_image 86857 0 V 0 D 0 0
74625 244833 variant_image 86858 0 V 0 D 0 0
74626 244834 variant_image 86859 0 V 0 D 0 0
74627 244835 variant_image 86860 0 V 0 D 0 0
74628 244836 variant_image 86861 0 V 0 D 0 0
74629 244837 variant_image 86862 0 V 0 D 0 0
74630 244838 variant_image 86863 0 V 0 D 0 0
74631 244839 variant_image 86864 0 V 0 D 0 0
74632 244840 variant_image 86865 0 V 0 D 0 0
74633 244841 variant_image 86866 0 V 0 D 0 0
74634 244842 variant_image 86867 0 V 0 D 0 0
74635 244843 variant_image 86868 0 V 0 D 0 0
74636 244844 variant_image 86869 0 V 0 D 0 0
74637 244845 variant_image 86870 0 V 0 D 0 0
75059 245256 variant_image 87292 0 V 0 D 0 0
75060 245257 variant_image 87293 0 V 0 D 0 0
75061 245258 variant_image 87294 0 V 0 D 0 0
75062 245259 variant_image 87295 0 V 0 D 0 0
75067 245264 variant_image 87300 0 V 0 D 0 0
75068 245265 variant_image 87301 0 V 0 D 0 0
75069 245266 variant_image 87302 0 V 0 D 0 0
75070 245267 variant_image 87303 0 V 0 D 0 0
75071 245268 variant_image 87304 0 V 0 D 0 0
75072 245269 variant_image 87305 0 V 0 D 0 0
75073 245270 variant_image 87306 0 V 0 D 0 0
75074 245271 variant_image 87307 0 V 0 D 0 0
75075 245272 variant_image 87308 0 V 0 D 0 0
75076 245273 variant_image 87309 0 V 0 D 0 0
75077 245274 variant_image 87310 0 V 0 D 0 0
75078 245275 variant_image 87311 0 V 0 D 0 0