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 (
    222726, 222712, 222713, 222714, 222715, 
    222716, 222717, 222718, 222719, 222720, 
    222721, 222722, 222723, 222724, 222725, 
    243091, 243092, 243093, 243094, 222727, 
    222728, 222729, 223891, 223861, 223862, 
    223863, 223864, 223865, 223866, 236890, 
    236891, 223867, 246057, 223890, 223868, 
    223869, 223870, 223871, 223872, 223873, 
    223874, 223875, 223876, 223877, 223878, 
    223879, 223880, 223881, 223882, 246058, 
    246059, 223883, 223884, 246060, 223885, 
    223886, 223887, 223888, 223889, 223892, 
    223893, 223894, 223895, 223896
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00139

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": 64,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (222726,222712,222713,222714,222715,222716,222717,222718,222719,222720,222721,222722,222723,222724,222725,243091,243092,243093,243094,222727,222728,222729,223891,223861,223862,223863,223864,223865,223866,236890,236891,223867,246057,223890,223868,223869,223870,223871,223872,223873,223874,223875,223876,223877,223878,223879,223880,223881,223882,246058,246059,223883,223884,246060,223885,223886,223887,223888,223889,223892,223893,223894,223895,223896)"
        }
      }
    },
    "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
41037 222712 variant_image 53270 0 V 0 D 0 0 cord-standard-black.jpg Standard Black 300 300 53270
41038 222713 variant_image 53271 0 V 0 D 0 0 cord-standard-white.jpg Standard White 300 300 53271
41039 222714 variant_image 53272 0 V 0 D 0 0 cord-black-cloth.jpg Black Cloth 300 300 53272
41040 222715 variant_image 53273 0 V 0 D 0 0 cord-silver-cloth.jpg Silver Cloth 300 300 53273
41041 222716 variant_image 53274 0 V 0 D 0 0 cord-creme-cloth.jpg Creme Cloth 300 300 53274
41042 222717 variant_image 53275 0 V 0 D 0 0 cord-blush-pink-cloth.jpg Blush Pink Cloth 300 300 53275
41043 222718 variant_image 53276 0 V 0 D 0 0 cord-confetti-cloth.jpg Confetti Cloth 300 300 53276
41044 222719 variant_image 53277 0 V 0 D 0 0 cord-rust-cloth.jpg Rust Cloth 300 300 53277
41045 222720 variant_image 53278 0 V 0 D 0 0 cord-barn-red-swirl.jpg Barn Red & Black Swirl Cloth 300 300 53278
41046 222721 variant_image 53279 0 V 0 D 0 0 cord-orange-cloth.jpg Orange Cloth 300 300 53279
41047 222722 variant_image 53280 0 V 0 D 0 0 cord-buttery-yellow-cloth.jpg Buttery Yellow Cloth 300 300 53280
41048 222723 variant_image 53281 0 V 0 D 0 0 cord-neon-green-cloth.jpg Neon Green Cloth 300 300 53281
41049 222724 variant_image 53282 0 V 0 D 0 0 cord-emerald-green-cloth.jpg Emerald Green Cloth 300 300 53282
41050 222725 variant_image 53283 0 V 0 D 0 0 cord-fern-green-chevron.jpg Fern Green Chevron Cloth 300 300 53283
41051 222728 variant_image 53284 0 V 0 D 0 0 mounting-accessory-plug-in-black-alt.jpg Black 300 300 53284
41052 222729 variant_image 53285 0 V 0 D 0 0 mounting-accessory-plug-in-white-alt.jpg White 300 300 53285
42174 223861 variant_image 54407 0 V 0 D 0 0 finish-pc-100-black_xtvt-u2.jpg Black 300 300 54407
42175 223862 variant_image 54408 0 V 0 D 0 0 finish-pc-105-textured-black_9nij-3v.jpg Textured Black 300 300 54408
42176 223863 variant_image 54409 0 V 0 D 0 0 finish-pc-200-white_jcf0-mg.jpg White 300 300 54409
42177 223864 variant_image 54410 0 V 0 D 0 0 finish-pc-300-dark-green_oioi-07.jpg Dark Green 300 300 54410
42178 223865 variant_image 54411 0 V 0 D 0 0 finish-pc-975-galvanized_hqry-ny.jpg Galvanized 300 300 54411
42179 223866 variant_image 54412 0 V 0 D 0 0 finish-pc-605-textured-rust_qlsl-em.jpg Rust 300 300 54412
42180 223867 variant_image 54413 0 V 0 D 0 0 finish-pc-307-emerald-green_no96-7d.jpg Emerald Green 300 300 54413
42181 223868 variant_image 54414 0 V 0 D 0 0 finish-pc-380-chartreuse_1rqg-rc.jpg Chartreuse 300 300 54414
42182 223869 variant_image 54415 0 V 0 D 0 0 finish-pc-390-teal_wgul-yu.jpg Teal 300 300 54415
42183 223870 variant_image 54416 0 V 0 D 0 0 finish-pc-400-barn-red_f2gv-n6.jpg Barn Red 300 300 54416
42184 223871 variant_image 54417 0 V 0 D 0 0 finish-pc-420-orange_3mks-16.jpg Orange 300 300 54417
42185 223872 variant_image 54418 0 V 0 D 0 0 finish-pc-470-watermelon_dlti-t7.jpg Watermelon 300 300 54418
42186 223873 variant_image 54419 0 V 0 D 0 0 finish-pc-480-blush-pink_du4x-go.jpg Blush Pink 300 300 54419
42187 223874 variant_image 54420 0 V 0 D 0 0 finish-pc-490-magenta_i9no-xj.jpg Magenta 300 300 54420
42188 223875 variant_image 54421 0 V 0 D 0 0 finish-pc-495-sherbet-orange_570k-d8.jpg Sherbet Orange 300 300 54421
42189 223876 variant_image 54422 0 V 0 D 0 0 finish-pc-500-buttery-yellow_zhvj-9x.jpg Buttery Yellow 300 300 54422
42190 223877 variant_image 54423 0 V 0 D 0 0 finish-pc-570-sunflower_qmij-5c.jpg Sunflower 300 300 54423
42191 223878 variant_image 54424 0 V 0 D 0 0 finish-pc-600-bronze_rj7v-gn.jpg Bronze 300 300 54424
42192 223879 variant_image 54425 0 V 0 D 0 0 finish-pc-601-chocolate_kzw7-nt.jpg Chocolate 300 300 54425
42193 223880 variant_image 54426 0 V 0 D 0 0 finish-pc-615-textured-oil-rubbed-bronze_rt0s-de.jpg Oil-Rubbed Bronze 300 300 54426
42194 223881 variant_image 54427 0 V 0 D 0 0 finish-pc-700-royal-blue_1dww-w5.jpg Royal Blue 300 300 54427
42195 223882 variant_image 54428 0 V 0 D 0 0 finish-pc-705-navy-blue_unsd-6x.jpg Navy 300 300 54428
42196 223883 variant_image 54429 0 V 0 D 0 0 finish-pc-800-industrial-grey_pygw-ux.jpg Industrial Grey 300 300 54429
42197 223884 variant_image 54430 0 V 0 D 0 0 finish-pc-805-charcoal-granite_jexg-ml.jpg Charcoal Granite 300 300 54430
42198 223885 variant_image 54431 0 V 0 D 0 0 finish-995-raw-copper_9dea-6s.jpg Raw Copper 300 300 54431
42199 223886 variant_image 54432 0 V 0 D 0 0 finish-996-copper-weathered_p75l-42.jpg Weathered Copper 300 300 54432
42200 223887 variant_image 54433 0 V 0 D 0 0 finish-999-copper-oil-rubbed-alt2.jpg Oil-Rubbed Copper 300 300 54433
42201 223888 variant_image 54434 0 V 0 D 0 0 finish-997-brass-raw_g1ux-xo.jpg Raw Brass 300 300 54434
42202 223889 variant_image 54435 0 V 0 D 0 0 finish-998-brass-weathered_vg3s-wp.jpg Weathered Brass 300 300 54435
42203 223890 variant_image 54436 0 V 0 D 0 0 finish-pc-370-mint_8mxf-hu.jpg Mint 300 300 54436
42204 223893 variant_image 54437 0 V 0 D 0 0 finish-pc-975-galvanized_4vef-ha.jpg Galvanized 300 300 54437
42205 223894 variant_image 54438 0 V 0 D 0 0 finish-pc-100-black_pb2p-bn.jpg Black 300 300 54438
42206 223895 variant_image 54439 0 V 0 D 0 0 finish-997-brass-raw_cczf-cl.jpg Raw Brass 300 300 54439
42207 223896 variant_image 54440 0 V 0 D 0 0 finish-998-brass-weathered.jpg Weathered Brass 300 300 54440
59632 236890 variant_image 71865 0 V 0 D 0 0 finish-pc-100-black_lunc-ll_69f5-vs.jpg Matte Black 300 300 71865
59633 236891 variant_image 71866 0 V 0 D 0 0 finish-pc-200-white_0zwq-b6_1ayy-bj.jpg Matte White 300 300 71866
72807 243091 variant_image 85040 0 V 0 D 0 0 cord-seafoam-cloth_fyy8-73.jpg Seafoam Cloth 300 300 85040
72808 243092 variant_image 85041 0 V 0 D 0 0 cord-sky-blue-cloth_02rw-56.jpg Sky Blue Cloth 300 300 85041
72809 243093 variant_image 85042 0 V 0 D 0 0 cord-royal-blue-cloth_kbeg-cn.jpg Royal Blue Cloth 300 300 85042
72810 243094 variant_image 85043 0 V 0 D 0 0 cord-navy-cloth_qhn5-ub.jpg Navy Cloth 300 300 85043
76260 246057 variant_image 88493 0 V 0 D 0 0 finish-pc-311-jadite_jkdm-8j.jpg Jadite 300 300 88493
76261 246058 variant_image 88494 0 V 0 D 0 0 finish-pc-710-cobalt-blue_nsn5-bp.jpg Cobalt Blue 300 300 88494
76262 246059 variant_image 88495 0 V 0 D 0 0 finish-pc-715-delphite_uhmz-co.jpg Delphite Blue 300 300 88495
76263 246060 variant_image 88496 0 V 0 D 0 0 finish-pc-810-graphite_vbkw-aw.jpg Graphite 300 300 88496