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, 
    222805, 
    222764, 
    222765, 
    222766, 
    222767, 
    222770, 
    222768, 
    222769, 
    222771, 
    222772, 
    222773, 
    222774, 
    222775, 
    222776, 
    222777, 
    222778, 
    222779, 
    222780, 
    222781, 
    241746, 
    222804, 
    222782, 
    222783, 
    222784, 
    222785, 
    241747, 
    222786, 
    222787, 
    222788, 
    222789, 
    222790, 
    222791, 
    222792, 
    222793, 
    241748, 
    222794, 
    241749, 
    222795, 
    222796, 
    222797, 
    222798, 
    241750, 
    222799, 
    222800, 
    222801, 
    222802, 
    222803, 
    222806, 
    222807, 
    222808, 
    222809, 
    222810, 
    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, 
    238873, 
    238874, 
    238889, 
    238875, 
    238876, 
    238877, 
    238878, 
    238879, 
    238880, 
    238881, 
    238882, 
    238883, 
    238884, 
    238885, 
    238886, 
    238887, 
    238888
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00229

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": 133,
          "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,222805,222764,222765,222766,222767,222770,222768,222769,222771,222772,222773,222774,222775,222776,222777,222778,222779,222780,222781,241746,222804,222782,222783,222784,222785,241747,222786,222787,222788,222789,222790,222791,222792,222793,241748,222794,241749,222795,222796,222797,222798,241750,222799,222800,222801,222802,222803,222806,222807,222808,222809,222810,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,238873,238874,238889,238875,238876,238877,238878,238879,238880,238881,238882,238883,238884,238885,238886,238887,238888)"
        }
      }
    },
    "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
41088 222764 variant_image 53321 0 V 0 D 0 0 finish-porcelain-150-black_b0mu-r0.jpg Black 300 300 53321
41089 222765 variant_image 53322 0 V 0 D 0 0 finish-porcelain-250-white_rwc3-kt.jpg White 300 300 53322
41090 222766 variant_image 53323 0 V 0 D 0 0 finish-porcelain-350-vintage-green_9snw-ps.jpg Vintage Green 300 300 53323
41091 222767 variant_image 53324 0 V 0 D 0 0 finish-porcelain-355-jadite_7i0g-6m.jpg Jadite 300 300 53324
41092 222768 variant_image 53325 0 V 0 D 0 0 finish-porcelain-455-cherry-red_75mb-67.jpg Cherry Red 300 300 53325
41093 222769 variant_image 53326 0 V 0 D 0 0 finish-porcelain-550-yellow_0h7m-bz.jpg Yellow 300 300 53326
41094 222770 variant_image 53327 0 V 0 D 0 0 finish-porcelain-650-bronze_n2v0-6g.jpg Bronze 300 300 53327
41095 222771 variant_image 53328 0 V 0 D 0 0 finish-porcelain-750-cobalt_tg9g-cz.jpg Cobalt Blue 300 300 53328
41096 222772 variant_image 53329 0 V 0 D 0 0 finish-porcelain-765-delphite_8kh9-0n.jpg Delphite Blue 300 300 53329
41097 222773 variant_image 53330 0 V 0 D 0 0 finish-porcelain-850-graphite_v8ti-jz.jpg Graphite 300 300 53330
41098 222774 variant_image 53331 0 V 0 D 0 0 finish-porcelain-950-metallic-chrome_pjgx-6s.jpg Metallic Chrome 300 300 53331
41099 222775 variant_image 53332 0 V 0 D 0 0 finish-pc-100-black_xtvt-u2.jpg Black 300 300 53332
41100 222776 variant_image 53333 0 V 0 D 0 0 finish-pc-105-textured-black_9nij-3v.jpg Textured Black 300 300 53333
41101 222777 variant_image 53334 0 V 0 D 0 0 finish-pc-200-white_jcf0-mg.jpg White 300 300 53334
41102 222778 variant_image 53335 0 V 0 D 0 0 finish-pc-300-dark-green_oioi-07.jpg Dark Green 300 300 53335
41103 222779 variant_image 53336 0 V 0 D 0 0 finish-pc-975-galvanized_hqry-ny.jpg Galvanized 300 300 53336
41104 222780 variant_image 53337 0 V 0 D 0 0 finish-pc-605-textured-rust_51tj-es.jpg Textured Rust 300 300 53337
41105 222781 variant_image 53338 0 V 0 D 0 0 finish-pc-307-emerald-green_no96-7d.jpg Emerald Green 300 300 53338
41106 222782 variant_image 53339 0 V 0 D 0 0 finish-pc-380-chartreuse_2g0s-ar.jpg Chartreuse 300 300 53339
41107 222783 variant_image 53340 0 V 0 D 0 0 finish-pc-390-teal_rysu-og.jpg Teal 300 300 53340
41108 222784 variant_image 53341 0 V 0 D 0 0 finish-pc-400-barn-red_f2gv-n6.jpg Barn Red 300 300 53341
41109 222785 variant_image 53342 0 V 0 D 0 0 finish-pc-420-orange_3mks-16.jpg Orange 300 300 53342
41110 222786 variant_image 53343 0 V 0 D 0 0 finish-pc-470-watermelon_dlti-t7.jpg Watermelon 300 300 53343
41111 222787 variant_image 53344 0 V 0 D 0 0 finish-pc-480-blush-pink_du4x-go.jpg Blush Pink 300 300 53344
41112 222788 variant_image 53345 0 V 0 D 0 0 finish-pc-490-magenta_i9no-xj.jpg Magenta 300 300 53345
41113 222789 variant_image 53346 0 V 0 D 0 0 finish-pc-495-sherbet-orange_444i-5y.jpg Sherbet Orange 300 300 53346
41114 222790 variant_image 53347 0 V 0 D 0 0 finish-pc-500-buttery-yellow_mehy-8v.jpg Buttery Yellow 300 300 53347
41115 222791 variant_image 53348 0 V 0 D 0 0 finish-pc-570-sunflower_qmij-5c.jpg Sunflower 300 300 53348
41116 222792 variant_image 53349 0 V 0 D 0 0 finish-pc-600-bronze_rj7v-gn.jpg Bronze 300 300 53349
41117 222793 variant_image 53350 0 V 0 D 0 0 finish-pc-601-chocolate_lylc-26.jpg Chocolate 300 300 53350
41118 222794 variant_image 53351 0 V 0 D 0 0 finish-pc-615-textured-bronze_7opx-eh.jpg Oil-Rubbed Bronze 300 300 53351
41119 222795 variant_image 53352 0 V 0 D 0 0 finish-pc-700-royal-blue_1dww-w5.jpg Royal Blue 300 300 53352
41120 222796 variant_image 53353 0 V 0 D 0 0 finish-pc-705-navy-blue_unsd-6x.jpg Navy 300 300 53353
41121 222797 variant_image 53354 0 V 0 D 0 0 finish-pc-800-industrial-grey_9fvr-lu.jpg Industrial Grey 300 300 53354
41122 222798 variant_image 53355 0 V 0 D 0 0 finish-pc-805-charcoal-granite_0gmd-gx.jpg Charcoal Granite 300 300 53355
41123 222799 variant_image 53356 0 V 0 D 0 0 finish-995-raw-copper_9dea-6s.jpg Raw Copper 300 300 53356
41124 222800 variant_image 53357 0 V 0 D 0 0 finish-996-copper-weathered_p75l-42.jpg Weathered Copper 300 300 53357
41125 222801 variant_image 53358 0 V 0 D 0 0 finish-999-copper-oil-rubbed-alt2_kshz-ou.jpg Oil-Rubbed Copper 300 300 53358
41126 222802 variant_image 53359 0 V 0 D 0 0 finish-997-brass-raw_g1ux-xo.jpg Raw Brass 300 300 53359
41127 222803 variant_image 53360 0 V 0 D 0 0 finish-998-brass-weathered_vg3s-wp.jpg Weathered Brass 300 300 53360
41128 222804 variant_image 53361 0 V 0 D 0 0 finish-pc-370-mint_odwx-qb.jpg Mint 300 300 53361
41129 222807 variant_image 53362 0 V 0 D 0 0 finish-pc-975-galvanized_4vef-ha.jpg Galvanized 300 300 53362
41130 222808 variant_image 53363 0 V 0 D 0 0 finish-pc-100-black_pb2p-bn.jpg Black 300 300 53363
41131 222809 variant_image 53364 0 V 0 D 0 0 finish-997-brass-raw_cczf-cl.jpg Raw Brass 300 300 53364
41132 222810 variant_image 53365 0 V 0 D 0 0 finish-998-brass-weathered.jpg Weathered Brass 300 300 53365
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
64250 238875 variant_image 76483 0 V 0 D 0 0 cord-style-SBK-standard-black_6812-d6.jpg SBK 300 300 76483
64251 238876 variant_image 76484 0 V 0 D 0 0 cord-style-SWH-standard-white_1fvv-h2.jpg SWH 300 300 76484
64252 238877 variant_image 76485 0 V 0 D 0 0 cord-style-CSB-black-cloth_a1s5-qz.jpg CSB 300 300 76485
64253 238878 variant_image 76486 0 V 0 D 0 0 cord-style-CSW-white-cloth_9avu-d1.jpg CSW 300 300 76486
64254 238879 variant_image 76487 0 V 0 D 0 0 cord-style-CSR-red-cloth_fxhv-zl.jpg CSR 300 300 76487
64255 238880 variant_image 76488 0 V 0 D 0 0 cord-style-CSBW-black-white-cloth_36u5-87.jpg CSBW 300 300 76488
64256 238881 variant_image 76489 0 V 0 D 0 0 cord-style-CSRW-red-white-cloth_bam7-63.jpg CSRW 300 300 76489
64257 238882 variant_image 76490 0 V 0 D 0 0 cord-style-CSBG-black-gold-cloth_9h42-mv.jpg CSBG 300 300 76490
64258 238883 variant_image 76491 0 V 0 D 0 0 cord-style-CSBP-black-pink-cloth_1v6x-qj.jpg CSBP 300 300 76491
64259 238884 variant_image 76492 0 V 0 D 0 0 cord-style-CSGW-gold-white-cloth_y5hg-0h.jpg CSGW 300 300 76492
64260 238885 variant_image 76493 0 V 0 D 0 0 cord-style-CSUW-blue-white-cloth_24nw-9w.jpg CSUW 300 300 76493
64261 238886 variant_image 76494 0 V 0 D 0 0 cord-style-CSBB-black-brown-chevron-cloth_4l6r-sc.jpg CSBB 300 300 76494
64262 238887 variant_image 76495 0 V 0 D 0 0 cord-style-CRZ-red-chevron.jpg CRZ 300 300 76495
64263 238888 variant_image 76496 0 V 0 D 0 0 cord-style-CMG-grey-cotton_u2uz-5g.jpg CMG 300 300 76496
71300 241746 variant_image 83533 0 V 0 D 0 0 finish-pc-320-Fern-Green_yz8l-jc.jpg Fern Green 300 300 83533
71301 241747 variant_image 83534 0 V 0 D 0 0 finish-pc-430-Soft-Clay_1jw9-71.jpg Soft Clay 300 300 83534
71302 241748 variant_image 83535 0 V 0 D 0 0 finish-pc-607-Taupe_waf8-h8.jpg Taupe 300 300 83535
71303 241749 variant_image 83536 0 V 0 D 0 0 finish-pc-630-Beige_5yqq-7o.jpg Beige 300 300 83536
71304 241750 variant_image 83537 0 V 0 D 0 0 finish-pc-815-Light-Grey_12gv-ul.jpg Light Grey 300 300 83537
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