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 (
    220320, 219237, 219238, 219239, 242973, 
    219241, 219249, 219250, 219252, 219253, 
    219254, 219255, 219256, 219257, 219258, 
    219259, 226978, 226957, 226958, 226959, 
    226960, 227013, 230514, 230515, 230516, 
    230517, 226983, 233456, 226984, 226985, 
    226986, 226988, 242428, 242429, 226989, 
    241391, 226990, 226991, 226992, 226993, 
    226994, 241392, 226995, 226996, 226997, 
    226998, 226999, 227000, 227001, 227002, 
    241393, 227003, 241394, 227004, 227005, 
    227006, 227007, 227008, 241395, 242207, 
    242208, 242209, 242210, 240507, 240506, 
    240508, 240509, 240536, 240514, 240515, 
    240516, 240517, 240518, 240526, 240535, 
    240519, 240520, 240521, 240522, 240523, 
    240524, 240525, 240527, 240528, 240529, 
    240530, 240559, 240537, 240538, 240539, 
    240540, 240541, 240549, 240558, 240542, 
    240543, 240544, 240545, 240546, 240547, 
    240548, 240550, 240551, 240552, 240553, 
    240582, 240560, 240561, 240562, 240563, 
    240564, 240572, 240581, 240565, 240566, 
    240567, 240568, 240569, 240570, 240571, 
    240573, 240574, 240575, 240576
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00231

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": 124,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,226978,226957,226958,226959,226960,227013,230514,230515,230516,230517,226983,233456,226984,226985,226986,226988,242428,242429,226989,241391,226990,226991,226992,226993,226994,241392,226995,226996,226997,226998,226999,227000,227001,227002,241393,227003,241394,227004,227005,227006,227007,227008,241395,242207,242208,242209,242210,240507,240506,240508,240509,240536,240514,240515,240516,240517,240518,240526,240535,240519,240520,240521,240522,240523,240524,240525,240527,240528,240529,240530,240559,240537,240538,240539,240540,240541,240549,240558,240542,240543,240544,240545,240546,240547,240548,240550,240551,240552,240553,240582,240560,240561,240562,240563,240564,240572,240581,240565,240566,240567,240568,240569,240570,240571,240573,240574,240575,240576)"
        }
      }
    },
    "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
37901 219238 variant_image 50134 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 50134
37904 219241 variant_image 50137 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 50137
37912 219249 variant_image 50145 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 50145
37913 219250 variant_image 50146 0 V 0 D 0 0 R1-1-Small-LED-bulbs-A19-Clear-Edison-600-Lumens-2700K-on-Tala.jpg Globe LED 300 300 50146
37915 219252 variant_image 50148 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 50148
37916 219253 variant_image 50149 0 V 0 D 0 0 R4-2-Medium-LED-bulbs-Oval-Porcelain-540-Lumens-2700K-on-Tala.jpg Oval LED 300 300 50149
37917 219254 variant_image 50150 0 V 0 D 0 0 R4-1-Medium-LED-bulbs-Oblo-Porcelain-540-Lumens-2700K-on-Tala.jpg Oblo LED 300 300 50150
37918 219255 variant_image 50151 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 50151
37919 219256 variant_image 50152 0 V 0 D 0 0 R3-3-Medium-LED-bulbs-Noma-Porcelain-540-Lumens-2700K-on-Tala.jpg Noma LED 300 300 50152
37920 219257 variant_image 50153 0 V 0 D 0 0 R3-2-Medium-LED-bulbs-Enno-Porcelain-540-Lumens-2700K-on-Tala.jpg Enno LED 300 300 50153
37921 219258 variant_image 50154 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 50154
37922 219259 variant_image 50155 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 50155
38738 219237 variant_image 50971 0 V 0 D 0 0 bulb-edison-r1-1-small-none_4j2p-gv.jpg 300 300 50971
45082 226957 variant_image 57315 0 V 0 D 0 0 finish-wood-ash.jpg Ash Wood 300 300 57315
45083 226958 variant_image 57316 0 V 0 D 0 0 finish-wood-maple.jpg Maple Wood 300 300 57316
45084 226959 variant_image 57317 0 V 0 D 0 0 finish-wood-oak.jpg Oak Wood 300 300 57317
45085 226960 variant_image 57318 0 V 0 D 0 0 finish-wood-walnut.jpg Walnut Wood 300 300 57318
45125 226983 variant_image 57358 0 V 0 D 0 0 finish-pc-100-black_rwi5-w8.jpg Black 300 300 57358
45126 226984 variant_image 57359 0 V 0 D 0 0 finish-pc-200-white_cmt3-f4.jpg White 300 300 57359
45127 226985 variant_image 57360 0 V 0 D 0 0 finish-pc-300-dark-green_kjl6-ze.jpg Dark Green 300 300 57360
45128 226986 variant_image 57361 0 V 0 D 0 0 finish-pc-975-galvanized_zcx1-z6.jpg Galvanized 300 300 57361
45130 226988 variant_image 57363 0 V 0 D 0 0 finish-pc-605-textured-rust_rr1m-nc.jpg Textured Rust 300 300 57363
45131 226989 variant_image 57364 0 V 0 D 0 0 finish-pc-307-emerald-green_mppg-s4.jpg Emerald Green 300 300 57364
45132 226990 variant_image 57365 0 V 0 D 0 0 finish-pc-370-mint_lzk6-sr.jpg Mint 300 300 57365
45133 226991 variant_image 57366 0 V 0 D 0 0 finish-pc-380-chartreuse_n7x4-iq.jpg Chartreuse 300 300 57366
45134 226992 variant_image 57367 0 V 0 D 0 0 finish-pc-390-teal_zs7d-f5.jpg Teal 300 300 57367
45135 226993 variant_image 57368 0 V 0 D 0 0 finish-pc-400-barn-red_gnfm-1s.jpg Barn Red 300 300 57368
45136 226994 variant_image 57369 0 V 0 D 0 0 finish-pc-420-orange_ooid-5b.jpg Orange 300 300 57369
45137 226995 variant_image 57370 0 V 0 D 0 0 finish-pc-470-watermelon_iqp7-w8.jpg Watermelon 300 300 57370
45138 226996 variant_image 57371 0 V 0 D 0 0 finish-pc-480-blush-pink_vhsw-0d.jpg Blush Pink 300 300 57371
45139 226997 variant_image 57372 0 V 0 D 0 0 finish-pc-490-magenta_wp7n-xz.jpg Magenta 300 300 57372
45140 226998 variant_image 57373 0 V 0 D 0 0 finish-pc-495-sherbet-orange_r3ac-pt.jpg Sherbet Orange 300 300 57373
45141 226999 variant_image 57374 0 V 0 D 0 0 finish-pc-500-buttery-yellow_7dza-qe.jpg Buttery Yellow 300 300 57374
45142 227000 variant_image 57375 0 V 0 D 0 0 finish-pc-570-sunflower_yk9n-r5.jpg Sunflower 300 300 57375
45143 227001 variant_image 57376 0 V 0 D 0 0 finish-pc-600-bronze_vnno-jo.jpg Bronze 300 300 57376
45144 227002 variant_image 57377 0 V 0 D 0 0 finish-pc-601-chocolate_qu3y-ud.jpg Chocolate 300 300 57377
45145 227003 variant_image 57378 0 V 0 D 0 0 finish-pc-615-textured-bronze_enol-69.jpg Oil-Rubbed Bronze 300 300 57378
45146 227004 variant_image 57379 0 V 0 D 0 0 finish-pc-700-royal-blue_ilwz-10.jpg Royal Blue 300 300 57379
45147 227005 variant_image 57380 0 V 0 D 0 0 finish-pc-705-navy-blue_tycu-7a.jpg Navy 300 300 57380
45148 227006 variant_image 57381 0 V 0 D 0 0 finish-pc-790-lavender_cnp9-z1.jpg Lavender 300 300 57381
45149 227007 variant_image 57382 0 V 0 D 0 0 finish-pc-800-industrial-grey_n68l-bi.jpg Industrial Grey 300 300 57382
45150 227008 variant_image 57383 0 V 0 D 0 0 finish-pc-805-charcoal-granite_xkwl-b7.jpg Charcoal Granite 300 300 57383
49244 230514 variant_image 61477 0 V 0 D 0 0 finish-wood-ash.jpg 300 300 61477
49245 230515 variant_image 61478 0 V 0 D 0 0 finish-wood-maple.jpg 300 300 61478
49246 230516 variant_image 61479 0 V 0 D 0 0 finish-wood-oak.jpg 300 300 61479
49247 230517 variant_image 61480 0 V 0 D 0 0 finish-wood-walnut.jpg 300 300 61480
49791 219239 variant_image 62024 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 62024
53987 233456 variant_image 66220 0 V 0 D 0 0 finish-pc-105-textured-black_0dem-9m.jpg Textured Black 300 300 66220
69896 240514 variant_image 82129 0 V 0 D 0 0 cord-standard-black.jpg Standard Black 300 300 82129
69897 240515 variant_image 82130 0 V 0 D 0 0 cord-standard-white.jpg Standard White 300 300 82130
69898 240516 variant_image 82131 0 V 0 D 0 0 cord-black-cloth.jpg Black Cloth 300 300 82131
69899 240517 variant_image 82132 0 V 0 D 0 0 cord-silver-cloth.jpg Silver Cloth 300 300 82132
69900 240518 variant_image 82133 0 V 0 D 0 0 cord-creme-cloth.jpg Creme Cloth 300 300 82133
69901 240519 variant_image 82134 0 V 0 D 0 0 cord-rust-cloth.jpg Rust Cloth 300 300 82134
69902 240520 variant_image 82135 0 V 0 D 0 0 cord-barn-red-swirl.jpg Barn Red & Black Swirl Cloth 300 300 82135
69903 240521 variant_image 82136 0 V 0 D 0 0 cord-orange-cloth.jpg Orange Cloth 300 300 82136
69904 240522 variant_image 82137 0 V 0 D 0 0 cord-buttery-yellow-cloth.jpg Buttery Yellow Cloth 300 300 82137
69905 240523 variant_image 82138 0 V 0 D 0 0 cord-neon-green-cloth.jpg Neon Green Cloth 300 300 82138
69906 240524 variant_image 82139 0 V 0 D 0 0 cord-emerald-green-cloth.jpg Emerald Green Cloth 300 300 82139
69907 240525 variant_image 82140 0 V 0 D 0 0 cord-fern-green-chevron.jpg Fern Green Chevron Cloth 300 300 82140
69908 240526 variant_image 82141 0 V 0 D 0 0 cord-blush-pink-cloth.jpg Blush Pink Cloth 300 300 82141
69909 240527 variant_image 82142 0 V 0 D 0 0 cord-seafoam-cloth.jpg Seafoam Cloth 300 300 82142
69910 240528 variant_image 82143 0 V 0 D 0 0 cord-sky-blue-cloth.jpg Sky Blue Cloth 300 300 82143
69911 240529 variant_image 82144 0 V 0 D 0 0 cord-royal-blue-cloth.jpg Royal Blue Cloth 300 300 82144
69912 240530 variant_image 82145 0 V 0 D 0 0 cord-navy-cloth.jpg Navy Cloth 300 300 82145
69917 240535 variant_image 82150 0 V 0 D 0 0 cord-confetti-cloth.jpg Confetti Cloth 300 300 82150
69918 240537 variant_image 82151 0 V 0 D 0 0 cord-standard-black_nitj-1l.jpg Standard Black 300 300 82151
69919 240538 variant_image 82152 0 V 0 D 0 0 cord-standard-white_amvp-wo.jpg Standard White 300 300 82152
69920 240539 variant_image 82153 0 V 0 D 0 0 cord-black-cloth_lqzx-9p.jpg Black Cloth 300 300 82153
69921 240540 variant_image 82154 0 V 0 D 0 0 cord-silver-cloth_y3pn-2o.jpg Silver Cloth 300 300 82154
69922 240541 variant_image 82155 0 V 0 D 0 0 cord-creme-cloth_bkwa-y9.jpg Creme Cloth 300 300 82155
69923 240542 variant_image 82156 0 V 0 D 0 0 cord-rust-cloth_lybn-vt.jpg Rust Cloth 300 300 82156
69924 240543 variant_image 82157 0 V 0 D 0 0 cord-barn-red-swirl_y0io-7d.jpg Barn Red & Black Swirl Cloth 300 300 82157
69925 240544 variant_image 82158 0 V 0 D 0 0 cord-orange-cloth_udxh-z2.jpg Orange Cloth 300 300 82158
69926 240545 variant_image 82159 0 V 0 D 0 0 cord-buttery-yellow-cloth_g7yz-l1.jpg Buttery Yellow Cloth 300 300 82159
69927 240546 variant_image 82160 0 V 0 D 0 0 cord-neon-green-cloth_srze-yh.jpg Neon Green Cloth 300 300 82160
69928 240547 variant_image 82161 0 V 0 D 0 0 cord-emerald-green-cloth_mnk0-9m.jpg Emerald Green Cloth 300 300 82161
69929 240548 variant_image 82162 0 V 0 D 0 0 cord-fern-green-chevron_cgsj-35.jpg Fern Green Chevron Cloth 300 300 82162
69930 240549 variant_image 82163 0 V 0 D 0 0 cord-blush-pink-cloth_qitx-ov.jpg Blush Pink Cloth 300 300 82163
69931 240550 variant_image 82164 0 V 0 D 0 0 cord-seafoam-cloth_qy95-ym.jpg Seafoam Cloth 300 300 82164
69932 240551 variant_image 82165 0 V 0 D 0 0 cord-sky-blue-cloth_067l-l0.jpg Sky Blue Cloth 300 300 82165
69933 240552 variant_image 82166 0 V 0 D 0 0 cord-royal-blue-cloth_xmei-aj.jpg Royal Blue Cloth 300 300 82166
69934 240553 variant_image 82167 0 V 0 D 0 0 cord-navy-cloth_ni7u-u0.jpg Navy Cloth 300 300 82167
69939 240558 variant_image 82172 0 V 0 D 0 0 cord-confetti-cloth_gtsg-aq.jpg Confetti Cloth 300 300 82172
69940 240560 variant_image 82173 0 V 0 D 0 0 cord-standard-black_6exl-36.jpg Standard Black 300 300 82173
69941 240561 variant_image 82174 0 V 0 D 0 0 cord-standard-white_ffvk-mf.jpg Standard White 300 300 82174
69942 240562 variant_image 82175 0 V 0 D 0 0 cord-black-cloth_lpf2-y0.jpg Black Cloth Cord 300 300 82175
69943 240563 variant_image 82176 0 V 0 D 0 0 cord-silver-cloth_ojfa-qi.jpg Silver Cloth 300 300 82176
69944 240564 variant_image 82177 0 V 0 D 0 0 cord-creme-cloth_a2t3-p0.jpg Creme Cloth 300 300 82177
69945 240565 variant_image 82178 0 V 0 D 0 0 cord-rust-cloth_oakp-se.jpg Rust Cloth 300 300 82178
69946 240566 variant_image 82179 0 V 0 D 0 0 cord-barn-red-swirl_vtyl-0n.jpg Barn Red & Black Swirl Cloth 300 300 82179
69947 240567 variant_image 82180 0 V 0 D 0 0 cord-orange-cloth_zp7x-rd.jpg Orange Cloth 300 300 82180
69948 240568 variant_image 82181 0 V 0 D 0 0 cord-buttery-yellow-cloth_gvve-ci.jpg Buttery Yellow Cloth 300 300 82181
69949 240569 variant_image 82182 0 V 0 D 0 0 cord-neon-green-cloth_qg1s-oa.jpg Neon Green Cloth 300 300 82182
69950 240570 variant_image 82183 0 V 0 D 0 0 cord-emerald-green-cloth_gk17-9t.jpg Emerald Green Cloth 300 300 82183
69951 240571 variant_image 82184 0 V 0 D 0 0 cord-fern-green-chevron_wlmg-4b.jpg Fern Green Chevron Cloth 300 300 82184
69952 240572 variant_image 82185 0 V 0 D 0 0 cord-blush-pink-cloth_xspd-k8.jpg Blush Pink Cloth 300 300 82185
69953 240573 variant_image 82186 0 V 0 D 0 0 cord-seafoam-cloth_1600-j2.jpg Seafoam Cloth 300 300 82186
69954 240574 variant_image 82187 0 V 0 D 0 0 cord-sky-blue-cloth_qxof-p6.jpg Sky Blue Cloth 300 300 82187
69955 240575 variant_image 82188 0 V 0 D 0 0 cord-royal-blue-cloth_v75p-op.jpg Royal Blue Cloth 300 300 82188
69956 240576 variant_image 82189 0 V 0 D 0 0 cord-navy-cloth_qy6j-1p.jpg Navy Cloth 300 300 82189
69961 240581 variant_image 82194 0 V 0 D 0 0 cord-confetti-cloth_44wc-c1.jpg Confetti Cloth 300 300 82194
70926 241391 variant_image 83159 0 V 0 D 0 0 finish-pc-320-Fern-Green_uglo-wu.jpg Fern Green 300 300 83159
70927 241392 variant_image 83160 0 V 0 D 0 0 finish-pc-430-Soft-Clay_akv7-m7.jpg Soft Clay 300 300 83160
70928 241393 variant_image 83161 0 V 0 D 0 0 finish-pc-607-Taupe_0ypj-zz.jpg Taupe 300 300 83161
70929 241394 variant_image 83162 0 V 0 D 0 0 finish-pc-630-Beige_06k2-uq.jpg Beige 300 300 83162
70930 241395 variant_image 83163 0 V 0 D 0 0 finish-pc-815-Light-Grey_ersf-45.jpg Light Grey 300 300 83163
71770 242207 variant_image 84003 0 V 0 D 0 0 finish-porcelain-355-jadite.jpg Jadite 300 300 84003
71771 242208 variant_image 84004 0 V 0 D 0 0 finish-porcelain-750-cobalt_l0g7-rr.jpg Cobalt Blue 300 300 84004
71772 242209 variant_image 84005 0 V 0 D 0 0 finish-porcelain-765-delphite_unm3-25.jpg Delphite Blue 300 300 84005
71773 242210 variant_image 84006 0 V 0 D 0 0 finish-porcelain-850-graphite_mp2s-ts.jpg Graphite 300 300 84006
72020 242428 variant_image 84253 0 V 0 D 0 0 finish-pc-106-Matte-Black.jpg Matte Black 300 300 84253
72021 242429 variant_image 84254 0 V 0 D 0 0 finish-pc-206-Matte-White.jpg Matte White 300 300 84254
72617 242973 variant_image 84850 0 V 0 D 0 0 R1-3-Small-LED-bulbs-ST19-Amber-Spiral-250-Lumens-2000K-on-GreenCreative_anl8-sq.jpg LED Amber ST19 300 300 84850