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.image_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 (
    224299, 224269, 224270, 224271, 224272, 
    224294, 224287, 237092, 237093, 224273, 
    242692, 224274, 224275, 224276, 224277, 
    224278, 242693, 224279, 224280, 224281, 
    224282, 224283, 224284, 224285, 224286, 
    242694, 224288, 242695, 224289, 224290, 
    224291, 224292, 224293, 242696, 224295, 
    224296, 224297, 224298, 224331, 224332, 
    224333, 224334, 224335, 224568, 224538, 
    224539, 224540, 224541, 224563, 224556, 
    237090, 237091, 224542, 242903, 224543, 
    224544, 224545, 224546, 224547, 242904, 
    224548, 224549, 224550, 224551, 224552, 
    224553, 224554, 224555, 242905, 224557, 
    242906, 224558, 224559, 224560, 224561, 
    224562, 242907, 224564, 224565, 224566, 
    224567, 224594, 224569, 224570, 224571, 
    242987, 224573, 224581, 224582, 224583, 
    224584, 224585, 224586, 224587, 224588, 
    224589, 224590, 224591
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00242

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": 98,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (224299,224269,224270,224271,224272,224294,224287,237092,237093,224273,242692,224274,224275,224276,224277,224278,242693,224279,224280,224281,224282,224283,224284,224285,224286,242694,224288,242695,224289,224290,224291,224292,224293,242696,224295,224296,224297,224298,224331,224332,224333,224334,224335,224568,224538,224539,224540,224541,224563,224556,237090,237091,224542,242903,224543,224544,224545,224546,224547,242904,224548,224549,224550,224551,224552,224553,224554,224555,242905,224557,242906,224558,224559,224560,224561,224562,242907,224564,224565,224566,224567,224594,224569,224570,224571,242987,224573,224581,224582,224583,224584,224585,224586,224587,224588,224589,224590,224591)"
        }
      }
    },
    "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.image_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.image_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
42578 224269 variant_image 54811 0 V 0 D 0 0 finish-pc-100-black_4cgx-j8_hseh-cb.jpg Black 300 300 54811
42579 224270 variant_image 54812 0 V 0 D 0 0 finish-pc-105-textured-black_3zmq-50.jpg Textured Black 300 300 54812
42580 224271 variant_image 54813 0 V 0 D 0 0 finish-pc-200-white_nn7z-sz_evwa-vr.jpg White 300 300 54813
42581 224272 variant_image 54814 0 V 0 D 0 0 finish-pc-300-dark-green_d4yt-hf_dhxt-nq.jpg Dark Green 300 300 54814
42582 224273 variant_image 54815 0 V 0 D 0 0 finish-pc-307-emerald-green_64qs-vw_a3zz-lj.jpg Emerald Green 300 300 54815
42583 224274 variant_image 54816 0 V 0 D 0 0 finish-pc-370-mint_wl02-qn.jpg Mint 300 300 54816
42584 224275 variant_image 54817 0 V 0 D 0 0 finish-pc-380-chartreuse_fhgq-e2.jpg Chartreuse 300 300 54817
42585 224276 variant_image 54818 0 V 0 D 0 0 finish-pc-390-teal_jlom-vi.jpg Teal 300 300 54818
42586 224277 variant_image 54819 0 V 0 D 0 0 finish-pc-400-barn-red_1p18-n2_y8es-ed.jpg Barn Red 300 300 54819
42587 224278 variant_image 54820 0 V 0 D 0 0 finish-pc-420-orange_zt7q-l2_q7ps-f3.jpg Orange 300 300 54820
42588 224279 variant_image 54821 0 V 0 D 0 0 finish-pc-470-watermelon_mdk6-d2_84rs-eg.jpg Watermelon 300 300 54821
42589 224280 variant_image 54822 0 V 0 D 0 0 finish-pc-480-blush-pink_icyy-an_dc3o-6p.jpg Blush Pink 300 300 54822
42590 224281 variant_image 54823 0 V 0 D 0 0 finish-pc-490-magenta_wndu-um_sazs-xf.jpg Magenta 300 300 54823
42591 224282 variant_image 54824 0 V 0 D 0 0 finish-pc-495-sherbet-orange_cdl3-i3.jpg Sherbet Orange 300 300 54824
42592 224283 variant_image 54825 0 V 0 D 0 0 finish-pc-500-buttery-yellow_pwq2-n6.jpg Buttery Yellow 300 300 54825
42593 224284 variant_image 54826 0 V 0 D 0 0 finish-pc-570-sunflower_5hrq-o4_0zia-da.jpg Sunflower 300 300 54826
42594 224285 variant_image 54827 0 V 0 D 0 0 finish-pc-600-bronze_t6hr-5s_pigx-re.jpg Bronze 300 300 54827
42595 224286 variant_image 54828 0 V 0 D 0 0 finish-pc-601-chocolate_zsm8-gz.jpg Chocolate 300 300 54828
42596 224287 variant_image 54829 0 V 0 D 0 0 finish-pc-605-textured-rust_k7tw-c2.jpg Textured Rust 300 300 54829
42597 224288 variant_image 54830 0 V 0 D 0 0 finish-pc-615-textured-bronze_0qwg-i0.jpg Oil-Rubbed Bronze 300 300 54830
42598 224289 variant_image 54831 0 V 0 D 0 0 finish-pc-700-royal-blue_fnad-0b_34k1-me.jpg Royal Blue 300 300 54831
42599 224290 variant_image 54832 0 V 0 D 0 0 finish-pc-705-navy-blue_21w7-vc_euu5-6c.jpg Navy 300 300 54832
42600 224291 variant_image 54833 0 V 0 D 0 0 finish-pc-790-lavender_w1nz-xy.jpg Lavender 300 300 54833
42601 224292 variant_image 54834 0 V 0 D 0 0 finish-pc-800-industrial-grey_h3co-aq.jpg Industrial Grey 300 300 54834
42602 224293 variant_image 54835 0 V 0 D 0 0 finish-pc-805-charcoal-granite_q7l9-88.jpg Charcoal Granite 300 300 54835
42603 224294 variant_image 54836 0 V 0 D 0 0 finish-pc-975-galvanized_1zuh-zu.jpg Galvanized 300 300 54836
42604 224295 variant_image 54837 0 V 0 D 0 0 finish-porcelain-355-jadite_uum5-8n_znfq-n4.jpg Jadite 300 300 54837
42605 224296 variant_image 54838 0 V 0 D 0 0 finish-porcelain-750-cobalt_gapc-ik_gslp-nz.jpg Cobalt Blue 300 300 54838
42606 224297 variant_image 54839 0 V 0 D 0 0 finish-porcelain-765-delphite_ogkv-p8_cgm2-li.jpg Delphite Blue 300 300 54839
42607 224298 variant_image 54840 0 V 0 D 0 0 finish-porcelain-850-graphite_xwbe-1x_o1st-75.jpg Graphite 300 300 54840
42638 224331 variant_image 54871 0 V 0 D 0 0 finish-995-raw-copper.jpg Raw Copper 300 300 54871
42639 224332 variant_image 54872 0 V 0 D 0 0 finish-996-copper-weathered.jpg Weathered Copper 300 300 54872
42640 224333 variant_image 54873 0 V 0 D 0 0 finish-999-copper-oil-rubbed.jpg Oil-Rubbed Copper 300 300 54873
42641 224334 variant_image 54874 0 V 0 D 0 0 finish-997-brass-raw.jpg Raw Brass 300 300 54874
42642 224335 variant_image 54875 0 V 0 D 0 0 finish-998-brass-weathered_79wd-n5.jpg Weathered Brass 300 300 54875
42832 224538 variant_image 55065 0 V 0 D 0 0 finish-pc-100-black_4cgx-j8.jpg Black 300 300 55065
42833 224539 variant_image 55066 0 V 0 D 0 0 finish-pc-105-textured-black_3zmq-50.jpg Textured Black 300 300 55066
42834 224540 variant_image 55067 0 V 0 D 0 0 finish-pc-200-white_nn7z-sz.jpg White 300 300 55067
42835 224541 variant_image 55068 0 V 0 D 0 0 finish-pc-300-dark-green_d4yt-hf.jpg Dark Green 300 300 55068
42836 224542 variant_image 55069 0 V 0 D 0 0 finish-pc-307-emerald-green_64qs-vw.jpg Emerald Green 300 300 55069
42837 224543 variant_image 55070 0 V 0 D 0 0 finish-pc-370-mint_3s36-pw.jpg Mint 300 300 55070
42838 224544 variant_image 55071 0 V 0 D 0 0 finish-pc-380-chartreuse_jgmi-lj.jpg Chartreuse 300 300 55071
42839 224545 variant_image 55072 0 V 0 D 0 0 finish-pc-390-teal_8a67-as.jpg Teal 300 300 55072
42840 224546 variant_image 55073 0 V 0 D 0 0 finish-pc-400-barn-red_1p18-n2.jpg Barn Red 300 300 55073
42841 224547 variant_image 55074 0 V 0 D 0 0 finish-pc-420-orange_zt7q-l2.jpg Orange 300 300 55074
42842 224548 variant_image 55075 0 V 0 D 0 0 finish-pc-470-watermelon_mdk6-d2.jpg Watermelon 300 300 55075
42843 224549 variant_image 55076 0 V 0 D 0 0 finish-pc-480-blush-pink_icyy-an.jpg Blush Pink 300 300 55076
42844 224550 variant_image 55077 0 V 0 D 0 0 finish-pc-490-magenta_wndu-um.jpg Magenta 300 300 55077
42845 224551 variant_image 55078 0 V 0 D 0 0 finish-pc-495-sherbet-orange_6wll-r7.jpg Sherbet Orange 300 300 55078
42846 224552 variant_image 55079 0 V 0 D 0 0 finish-pc-500-buttery-yellow_0vn5-5i.jpg Buttery Yellow 300 300 55079
42847 224553 variant_image 55080 0 V 0 D 0 0 finish-pc-570-sunflower_5hrq-o4.jpg Sunflower 300 300 55080
42848 224554 variant_image 55081 0 V 0 D 0 0 finish-pc-600-bronze_t6hr-5s.jpg Bronze 300 300 55081
42849 224555 variant_image 55082 0 V 0 D 0 0 finish-pc-601-chocolate_r3u2-1q.jpg Chocolate 300 300 55082
42850 224556 variant_image 55083 0 V 0 D 0 0 finish-pc-605-textured-rust_vown-l5.jpg Textured Rust 300 300 55083
42851 224557 variant_image 55084 0 V 0 D 0 0 finish-pc-615-textured-bronze_3lda-fy.jpg Oil-Rubbed Bronze 300 300 55084
42852 224558 variant_image 55085 0 V 0 D 0 0 finish-pc-700-royal-blue_fnad-0b.jpg Royal Blue 300 300 55085
42853 224559 variant_image 55086 0 V 0 D 0 0 finish-pc-705-navy-blue_21w7-vc.jpg Navy 300 300 55086
42854 224560 variant_image 55087 0 V 0 D 0 0 finish-pc-790-lavender_1cuv-xv.jpg Lavender 300 300 55087
42855 224561 variant_image 55088 0 V 0 D 0 0 finish-pc-800-industrial-grey_tkrz-7n.jpg Industrial Grey 300 300 55088
42856 224562 variant_image 55089 0 V 0 D 0 0 finish-pc-805-charcoal-granite_lf11-tg.jpg Charcoal Granite 300 300 55089
42857 224563 variant_image 55090 0 V 0 D 0 0 finish-pc-975-galvanized_1zuh-zu.jpg Galvanized 300 300 55090
42858 224564 variant_image 55091 0 V 0 D 0 0 finish-porcelain-355-jadite_uum5-8n.jpg Jadite 300 300 55091
42859 224565 variant_image 55092 0 V 0 D 0 0 finish-porcelain-750-cobalt_gapc-ik.jpg Cobalt Blue 300 300 55092
42860 224566 variant_image 55093 0 V 0 D 0 0 finish-porcelain-765-delphite_ogkv-p8.jpg Delphite Blue 300 300 55093
42861 224567 variant_image 55094 0 V 0 D 0 0 finish-porcelain-850-graphite_xwbe-1x.jpg Graphite 300 300 55094
42862 224569 variant_image 55095 0 V 0 D 0 0 bulb-edison-r1-1-small-none_4j2p-gv.jpg 300 300 55095
42863 224570 variant_image 55096 0 V 0 D 0 0 R2-2-Small-LED-bulbs-G25-Chrome-Edison-400-Lumens-2700K-on-GreenCreative.jpg LED Silver Bowl G25 300 300 55096
42864 224571 variant_image 55097 0 V 0 D 0 0 R1-2-Small-LED-bulbs-ST19-Clear-Spiral-250-Lumens-2100K-on-GreenCreative.jpg LED Clear ST19 300 300 55097
42866 224573 variant_image 55099 0 V 0 D 0 0 R1-4-Small-LED-bulbs-ST19-Smoky-Spiral-150-Lumens-4000K-on-GreenCreative.jpg LED Smoky ST19 300 300 55099
42874 224581 variant_image 55107 0 V 0 D 0 0 R2-1-Small-LED-bulbs-T12-Amber-XX-210-Lumens-2200K-on-Tala-last.jpg Lurra LED 300 300 55107
42875 224582 variant_image 55108 0 V 0 D 0 0 R1-1-Small-LED-bulbs-A19-Clear-Edison-600-Lumens-2700K-on-Tala.jpg Globe LED 300 300 55108
42876 224583 variant_image 55109 0 V 0 D 0 0 R2-3-Small-LED-bulbs-G25-Porcelain-II-540-Lumens-2700K-on-Tala.jpg Porcelain II LED 300 300 55109
42877 224584 variant_image 55110 0 V 0 D 0 0 R2-4-Small-LED-bulbs-G30-Elva-Amber-XX-420-Lumens-2200K-on-Tala.jpg Elva LED 300 300 55110
42878 224585 variant_image 55111 0 V 0 D 0 0 R4-2-Medium-LED-bulbs-Oval-Porcelain-540-Lumens-2700K-on-Tala.jpg Oval LED 300 300 55111
42879 224586 variant_image 55112 0 V 0 D 0 0 R4-1-Medium-LED-bulbs-Oblo-Porcelain-540-Lumens-2700K-on-Tala.jpg Oblo LED 300 300 55112
42880 224587 variant_image 55113 0 V 0 D 0 0 R3-1-Medium-LED-bulbs-G40-Porcelain-III-540-Lumens-2700K-on-Tala.jpg Porcelain III LED 300 300 55113
42881 224588 variant_image 55114 0 V 0 D 0 0 R3-3-Medium-LED-bulbs-Noma-Porcelain-540-Lumens-2700K-on-Tala.jpg Noma LED 300 300 55114
42882 224589 variant_image 55115 0 V 0 D 0 0 R3-2-Medium-LED-bulbs-Enno-Porcelain-540-Lumens-2700K-on-Tala.jpg Enno LED 300 300 55115
42883 224590 variant_image 55116 0 V 0 D 0 0 R4-3-Medium-LED-bulbs-Voroni-I-Amber-Spiral-100-Lumens-2200K-on-Tala.jpg Voronoi I LED 300 300 55116
42884 224591 variant_image 55117 0 V 0 D 0 0 R5-2-Large-LED-bulbs-Voroni-II-Amber-Spiral-150-Lumens-2200K-on-Tala.jpg Voronoi II LED 300 300 55117
59837 237090 variant_image 72070 0 V 0 D 0 0 finish-pc-106-Matte-Black_5r9h-o4.jpg Matte Black 300 300 72070
59838 237091 variant_image 72071 0 V 0 D 0 0 finish-pc-206-Matte-White_ryq5-ou.jpg Matte White 300 300 72071
59839 237092 variant_image 72072 0 V 0 D 0 0 finish-pc-106-Matte-Black_f0s0-ru.jpg Matte Black 300 300 72072
59840 237093 variant_image 72073 0 V 0 D 0 0 finish-pc-206-Matte-White_5ofw-zo.jpg Matte White 300 300 72073
72301 242692 variant_image 84534 0 V 0 D 0 0 finish-pc-320-Fern-Green_o34n-l0.jpg Fern Green 300 300 84534
72302 242693 variant_image 84535 0 V 0 D 0 0 finish-pc-430-Soft-Clay_u6n4-ii.jpg Soft Clay 300 300 84535
72303 242694 variant_image 84536 0 V 0 D 0 0 finish-pc-607-Taupe_o4s4-o6.jpg Taupe 300 300 84536
72304 242695 variant_image 84537 0 V 0 D 0 0 finish-pc-630-Beige_va4o-wn.jpg Beige 300 300 84537
72305 242696 variant_image 84538 0 V 0 D 0 0 finish-pc-815-Light-Grey_tx5j-qb.jpg Light Grey 300 300 84538
72512 242903 variant_image 84745 0 V 0 D 0 0 finish-pc-320-Fern-Green_bwdv-ei.jpg Fern Green 300 300 84745
72513 242904 variant_image 84746 0 V 0 D 0 0 finish-pc-430-Soft-Clay_4eni-jl.jpg Soft Clay 300 300 84746
72514 242905 variant_image 84747 0 V 0 D 0 0 finish-pc-607-Taupe_cp80-x4.jpg Taupe 300 300 84747
72515 242906 variant_image 84748 0 V 0 D 0 0 finish-pc-630-Beige_9xbi-fp.jpg Beige 300 300 84748
72516 242907 variant_image 84749 0 V 0 D 0 0 finish-pc-815-Light-Grey_su9i-t5.jpg Light Grey 300 300 84749
72631 242987 variant_image 84864 0 V 0 D 0 0 R1-3-Small-LED-bulbs-ST19-Amber-Spiral-250-Lumens-2000K-on-GreenCreative_si1d-y1.jpg LED Amber ST19 300 300 84864