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 (
    220318, 215376, 215377, 226373, 226338, 
    226339, 226340, 226341, 226342, 226343, 
    237048, 237049, 226344, 241325, 226345, 
    226346, 226347, 226348, 226349, 241326, 
    226350, 226351, 226352, 226353, 226354, 
    226355, 226356, 226357, 241327, 226358, 
    241328, 226359, 226360, 226361, 226362, 
    226363, 241329, 242533, 242534, 242535, 
    242536, 226368, 226369, 226370, 226371, 
    226372, 226485, 226455, 226457, 226462, 
    226481, 244281, 226465, 226466, 244282, 
    239948, 226470, 226472, 226474, 226477, 
    226478, 226483, 226490, 226486, 226487, 
    233539, 226488, 226489, 226495, 226491, 
    226492, 226493, 226494, 226500, 226496, 
    226497, 226498, 226499, 228262, 228263, 
    228264, 228294, 228265, 228266, 228267, 
    228268, 228288, 228269, 228270, 228271, 
    228272, 228273, 228274, 228275, 228276, 
    228277, 228278, 228279, 228280, 228281, 
    228282, 228283, 228284, 228285, 228286, 
    228287, 228289, 228290, 228291, 228292, 
    228293, 228295, 228299, 228296, 228297, 
    228298, 228300, 228304, 228301, 228302, 
    228303
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00217

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": 121,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220318,215376,215377,226373,226338,226339,226340,226341,226342,226343,237048,237049,226344,241325,226345,226346,226347,226348,226349,241326,226350,226351,226352,226353,226354,226355,226356,226357,241327,226358,241328,226359,226360,226361,226362,226363,241329,242533,242534,242535,242536,226368,226369,226370,226371,226372,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,226490,226486,226487,233539,226488,226489,226495,226491,226492,226493,226494,226500,226496,226497,226498,226499,228262,228263,228264,228294,228265,228266,228267,228268,228288,228269,228270,228271,228272,228273,228274,228275,228276,228277,228278,228279,228280,228281,228282,228283,228284,228285,228286,228287,228289,228290,228291,228292,228293,228295,228299,228296,228297,228298,228300,228304,228301,228302,228303)"
        }
      }
    },
    "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
33339 215376 variant_image 45572 0 V 0 D 0 0 socket-standard-e26.jpg Standard Bulb/E26 300 300 45572
33340 215377 variant_image 45573 0 V 0 D 0 0 socket-bi-pin-gu24.jpg GU24 Bi-Pin Socket 300 300 45573
44529 226338 variant_image 56762 0 V 0 D 0 0 finish-pc-100-black_h4rz-l8_hhkd-n3.jpg Black 300 300 56762
44530 226339 variant_image 56763 0 V 0 D 0 0 finish-pc-105-textured-black_gbqg-bx.jpg Textured Black 300 300 56763
44531 226340 variant_image 56764 0 V 0 D 0 0 finish-pc-200-white_bgqm-wg.jpg White 300 300 56764
44532 226341 variant_image 56765 0 V 0 D 0 0 finish-pc-300-dark-green_wl7g-51.jpg Dark Green 300 300 56765
44533 226342 variant_image 56766 0 V 0 D 0 0 finish-pc-975-galvanized_v064-hd.jpg Galvanized 300 300 56766
44534 226343 variant_image 56767 0 V 0 D 0 0 finish-pc-605-textured-rust_fue5-jm.jpg Textured Rust 300 300 56767
44535 226344 variant_image 56768 0 V 0 D 0 0 finish-pc-307-emerald-green_j8cc-x4.jpg Emerald Green 300 300 56768
44536 226345 variant_image 56769 0 V 0 D 0 0 finish-pc-370-mint_dyob-m8.jpg Mint 300 300 56769
44537 226346 variant_image 56770 0 V 0 D 0 0 finish-pc-380-chartreuse_tgni-gj.jpg Chartreuse 300 300 56770
44538 226347 variant_image 56771 0 V 0 D 0 0 finish-pc-390-teal_x27w-na.jpg Teal 300 300 56771
44539 226348 variant_image 56772 0 V 0 D 0 0 finish-pc-400-barn-red_rxrf-he.jpg Barn Red 300 300 56772
44540 226349 variant_image 56773 0 V 0 D 0 0 finish-pc-420-orange_2z1c-69.jpg Orange 300 300 56773
44541 226350 variant_image 56774 0 V 0 D 0 0 finish-pc-470-watermelon_s1ij-2e.jpg Watermelon 300 300 56774
44542 226351 variant_image 56775 0 V 0 D 0 0 finish-pc-480-blush-pink_o994-rk.jpg Blush Pink 300 300 56775
44543 226352 variant_image 56776 0 V 0 D 0 0 finish-pc-490-magenta_axq3-vo.jpg Magenta 300 300 56776
44544 226353 variant_image 56777 0 V 0 D 0 0 finish-pc-495-sherbet-orange_31pl-kh.jpg Sherbet Orange 300 300 56777
44545 226354 variant_image 56778 0 V 0 D 0 0 finish-pc-500-buttery-yellow_4rsu-ru.jpg Buttery Yellow 300 300 56778
44546 226355 variant_image 56779 0 V 0 D 0 0 finish-pc-570-sunflower_kch2-ze.jpg Sunflower 300 300 56779
44547 226356 variant_image 56780 0 V 0 D 0 0 finish-pc-600-bronze_r0zd-nt.jpg Bronze 300 300 56780
44548 226357 variant_image 56781 0 V 0 D 0 0 finish-pc-601-chocolate_jc7n-oj.jpg Chocolate 300 300 56781
44549 226358 variant_image 56782 0 V 0 D 0 0 finish-pc-615-textured-bronze_atkf-rl.jpg Textured Bronze 300 300 56782
44550 226359 variant_image 56783 0 V 0 D 0 0 finish-pc-700-royal-blue_kkxh-q5.jpg Royal Blue 300 300 56783
44551 226360 variant_image 56784 0 V 0 D 0 0 finish-pc-705-navy-blue_potc-2z.jpg Navy 300 300 56784
44552 226361 variant_image 56785 0 V 0 D 0 0 finish-pc-790-lavender_8pkj-lb.jpg Lavender 300 300 56785
44553 226362 variant_image 56786 0 V 0 D 0 0 finish-pc-800-industrial-grey_kzhh-qp.jpg Industrial Grey 300 300 56786
44554 226363 variant_image 56787 0 V 0 D 0 0 finish-pc-805-charcoal-granite_fhzu-n0.jpg Charcoal Granite 300 300 56787
44559 226368 variant_image 56792 0 V 0 D 0 0 finish-995-raw-copper_x0hf-df.jpg Raw Copper 300 300 56792
44560 226369 variant_image 56793 0 V 0 D 0 0 finish-996-copper-weathered_y9k1-84.jpg Weathered Copper 300 300 56793
44561 226370 variant_image 56794 0 V 0 D 0 0 finish-999-copper-oil-rubbed-alt2.jpg Oil-Rubbed Copper 300 300 56794
44562 226371 variant_image 56795 0 V 0 D 0 0 finish-997-brass-raw_ngxa-1z_o3gr-0i.jpg Raw Brass 300 300 56795
44563 226372 variant_image 56796 0 V 0 D 0 0 finish-998-brass-weathered_nu8h-of_u400-xt.jpg Weathered Brass 300 300 56796
44638 226455 variant_image 56871 0 V 0 D 0 0 finish-pc-100-black_f47g-h7.jpg Black 300 300 56871
44640 226457 variant_image 56873 0 V 0 D 0 0 finish-pc-200-white_zaxz-xi.jpg White 300 300 56873
44645 226462 variant_image 56878 0 V 0 D 0 0 finish-pc-307-emerald-green_6pq3-po.jpg Emerald Green 300 300 56878
44648 226465 variant_image 56881 0 V 0 D 0 0 finish-pc-390-teal_kg4i-os.jpg Teal 300 300 56881
44649 226466 variant_image 56882 0 V 0 D 0 0 finish-pc-400-barn-red_i41i-br.jpg Barn Red 300 300 56882
44653 226470 variant_image 56886 0 V 0 D 0 0 finish-pc-490-magenta_1kft-dq.jpg Magenta 300 300 56886
44655 226472 variant_image 56888 0 V 0 D 0 0 finish-pc-500-buttery-yellow_cawv-er.jpg Buttery Yellow 300 300 56888
44657 226474 variant_image 56890 0 V 0 D 0 0 finish-pc-600-bronze_vypg-sp.jpg Bronze 300 300 56890
44660 226477 variant_image 56893 0 V 0 D 0 0 finish-pc-700-royal-blue_qoui-6d.jpg Royal Blue 300 300 56893
44661 226478 variant_image 56894 0 V 0 D 0 0 finish-pc-705-navy-blue_o3vo-q0.jpg Navy 300 300 56894
44664 226481 variant_image 56897 0 V 0 D 0 0 finish-pc-311-seafoam_d4wb-0m.jpg Jadite 300 300 56897
44666 226483 variant_image 56899 0 V 0 D 0 0 finish-pc-715-sky-blue_rv8u-ub.jpg Delphite 300 300 56899
44668 226486 variant_image 56901 0 V 0 D 0 0 mounting-accessory-gooseneck-bp-none_v53b-f4.jpg 300 300 56901
44669 226487 variant_image 56902 0 V 0 D 0 0 mounting-accessory-decorative-backing-plate.jpg 300 300 56902
44670 226488 variant_image 56903 0 V 0 D 0 0 mounting-accessory-dusk-to-dawn.jpg 300 300 56903
44671 226489 variant_image 56904 0 V 0 D 0 0 mounting-accessory-canopy-heavy-duty.jpg 300 300 56904
44672 226491 variant_image 56905 0 V 0 D 0 0 mounting-accessory-gooseneck-hex-cover-copper-none_p3cd-rl.jpg 300 300 56905
44673 226492 variant_image 56906 0 V 0 D 0 0 mounting-accessory-gooseneck-hex-cover-copper_ziyu-1q.jpg 300 300 56906
44674 226493 variant_image 56907 0 V 0 D 0 0 mounting-accessory-gooseneck-bp-dusk-to-dawn-copper_5nxe-8a.jpg 300 300 56907
44675 226494 variant_image 56908 0 V 0 D 0 0 mounting-accessory-gooseneck-bp-heavy-duty-copper_1naq-p2.jpg 300 300 56908
44676 226496 variant_image 56909 0 V 0 D 0 0 mounting-accessory-gooseneck-hex-cover-brass-none_rgvp-tl.jpg 300 300 56909
44677 226497 variant_image 56910 0 V 0 D 0 0 mounting-accessory-gooseneck-hex-cover-brass_7qk4-an.jpg 300 300 56910
44678 226498 variant_image 56911 0 V 0 D 0 0 mounting-accessory-gooseneck-bp-dusk-to-dawn-brass_p53j-me.jpg 300 300 56911
44679 226499 variant_image 56912 0 V 0 D 0 0 mounting-accessory-gooseneck-bp-heavy-duty-brass_y4w0-zl.jpg 300 300 56912
48213 228265 variant_image 60446 0 V 0 D 0 0 arm-small-9-G26.jpg G26 300 300 60446
48214 228266 variant_image 60447 0 V 0 D 0 0 arm-small-10-G11.jpg G11 300 300 60447
48215 228267 variant_image 60448 0 V 0 D 0 0 arm-small-11-G15.jpg G15 300 300 60448
48216 228268 variant_image 60449 0 V 0 D 0 0 arm-small-12-G22.jpg G22 300 300 60449
48217 228288 variant_image 60450 0 V 0 D 0 0 arm-medium-12-G8.jpg G8 300 300 60450
48218 228269 variant_image 60451 0 V 0 D 0 0 arm-medium-1-G24.jpg G24 300 300 60451
48219 228270 variant_image 60452 0 V 0 D 0 0 arm-medium-2-G6.jpg G6 300 300 60452
48220 228271 variant_image 60453 0 V 0 D 0 0 arm-small-1-G3.jpg G3 300 300 60453
48221 228272 variant_image 60454 0 V 0 D 0 0 arm-small-2-G4.jpg G4 300 300 60454
48222 228273 variant_image 60455 0 V 0 D 0 0 arm-small-3-G1.jpg G1 300 300 60455
48223 228274 variant_image 60456 0 V 0 D 0 0 arm-small-4-G14.jpg G14 300 300 60456
48224 228275 variant_image 60457 0 V 0 D 0 0 arm-small-5-G16.jpg G16 300 300 60457
48225 228276 variant_image 60458 0 V 0 D 0 0 arm-small-6-G17.jpg G17 300 300 60458
48226 228277 variant_image 60459 0 V 0 D 0 0 arm-small-7-G35.jpg G35 300 300 60459
48227 228278 variant_image 60460 0 V 0 D 0 0 arm-small-8-G34.jpg G34 300 300 60460
48228 228279 variant_image 60461 0 V 0 D 0 0 arm-medium-4-G5.jpg G5 300 300 60461
48229 228280 variant_image 60462 0 V 0 D 0 0 arm-medium-5-G25.jpg G25 300 300 60462
48230 228281 variant_image 60463 0 V 0 D 0 0 arm-medium-6-G10.jpg G10 300 300 60463
48231 228282 variant_image 60464 0 V 0 D 0 0 arm-medium-7-G19.jpg G19 300 300 60464
48232 228283 variant_image 60465 0 V 0 D 0 0 arm-medium-8-G65.jpg G65 300 300 60465
48233 228284 variant_image 60466 0 V 0 D 0 0 arm-medium-9-G64.jpg G64 300 300 60466
48234 228285 variant_image 60467 0 V 0 D 0 0 arm-medium-10-G12.jpg G12 300 300 60467
48235 228286 variant_image 60468 0 V 0 D 0 0 arm-medium-11-G13.jpg G13 300 300 60468
48236 228287 variant_image 60469 0 V 0 D 0 0 arm-medium-3-G32.jpg G32 300 300 60469
48237 228289 variant_image 60470 0 V 0 D 0 0 arm-large-1-G2.jpg G2 300 300 60470
48238 228290 variant_image 60471 0 V 0 D 0 0 arm-large-2-G36.jpg G36 300 300 60471
48239 228291 variant_image 60472 0 V 0 D 0 0 arm-large-3-G9_xzsg-ua.jpg G7 300 300 60472
48240 228292 variant_image 60473 0 V 0 D 0 0 arm-large-4-G7.jpg G9 300 300 60473
48241 228293 variant_image 60474 0 V 0 D 0 0 arm-large-5-G40.jpg G40 300 300 60474
48310 228263 variant_image 60543 0 V 0 D 0 0 glass-style-schoolhouse-opaque-0_we2u-ih.jpg 300 300 60543
48311 228264 variant_image 60544 0 V 0 D 0 0 glass-style-schoolhouse-clear-0_0tec-83.jpg 300 300 60544
48312 228299 variant_image 60545 0 V 0 D 0 0 glass-style-schoolhouse-opaque-0_6nru-xj.jpg 300 300 60545
48313 228296 variant_image 60546 0 V 0 D 0 0 glass-style-schoolhouse-opaque-1-PB4.jpg Three Painted Band 300 300 60546
48314 228297 variant_image 60547 0 V 0 D 0 0 glass-style-schoolhouse-opaque-2-PB5.jpg Three Painted Band 300 300 60547
48315 228298 variant_image 60548 0 V 0 D 0 0 glass-style-schoolhouse-opaque-3-PB6.jpg Five Painted Band 300 300 60548
48316 228304 variant_image 60549 0 V 0 D 0 0 glass-style-schoolhouse-clear-0_lc60-mw.jpg 300 300 60549
48317 228301 variant_image 60550 0 V 0 D 0 0 glass-style-schoolhouse-clear-1-PB4.jpg Three Painted Band 300 300 60550
48318 228302 variant_image 60551 0 V 0 D 0 0 glass-style-schoolhouse-clear-2-PB5.jpg Three Painted Band 300 300 60551
48319 228303 variant_image 60552 0 V 0 D 0 0 glass-style-schoolhouse-clear-3-PB6.jpg Five Painted Band 300 300 60552
54097 233539 variant_image 66330 0 V 0 D 0 0 mounting-accessory-gooseneck-hex-cover-galvanized_yg4k-ef.jpg 300 300 66330
59795 237048 variant_image 72028 0 V 0 D 0 0 finish-pc-106-Matte-Black_xcag-zt.jpg Matte Black 300 300 72028
59796 237049 variant_image 72029 0 V 0 D 0 0 finish-pc-206-Matte-White_ti5z-s3.jpg Matte White 300 300 72029
68285 239948 variant_image 80518 0 V 0 D 0 0 finish-pc-480-blush-pink_cxp8-s7.jpg Blush Pink 300 300 80518
70860 241325 variant_image 83093 0 V 0 D 0 0 finish-pc-320-Fern-Green_rnc4-9t.jpg Fern Green 300 300 83093
70861 241326 variant_image 83094 0 V 0 D 0 0 finish-pc-430-Soft-Clay_mr9v-nv.jpg Soft Clay 300 300 83094
70862 241327 variant_image 83095 0 V 0 D 0 0 finish-pc-607-Taupe_03li-2v.jpg Taupe 300 300 83095
70863 241328 variant_image 83096 0 V 0 D 0 0 finish-pc-630-Beige_2s52-bd.jpg Beige 300 300 83096
70864 241329 variant_image 83097 0 V 0 D 0 0 finish-pc-815-Light-Grey_wmel-0l.jpg Light Grey 300 300 83097
72128 242533 variant_image 84361 0 V 0 D 0 0 finish-porcelain-355-jadite_sj2c-hs.jpg Jadite 300 300 84361
72129 242534 variant_image 84362 0 V 0 D 0 0 finish-porcelain-750-cobalt_4blm-o8.jpg Cobalt Blue 300 300 84362
72130 242535 variant_image 84363 0 V 0 D 0 0 finish-porcelain-765-delphite_ejey-dd.jpg Delphite Blue 300 300 84363
72131 242536 variant_image 84364 0 V 0 D 0 0 finish-porcelain-850-graphite_js9m-xl.jpg Graphite 300 300 84364
74008 244281 variant_image 86241 0 V 0 D 0 0 finish-pc-320-Fern-Green_zzox-kr.jpg Fern Green 300 300 86241
74009 244282 variant_image 86242 0 V 0 D 0 0 finish-pc-430-Soft-Clay_bk2w-ji.jpg Soft Clay 300 300 86242