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.detailed_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 (
    221146, 
    221147, 
    221148, 
    226174, 
    226139, 
    226140, 
    226141, 
    226142, 
    226143, 
    226144, 
    237236, 
    237237, 
    226145, 
    226165, 
    241161, 
    226146, 
    226147, 
    226148, 
    226149, 
    226150, 
    241162, 
    226151, 
    226152, 
    226153, 
    226154, 
    226155, 
    226156, 
    226157, 
    226158, 
    241163, 
    226159, 
    241164, 
    226160, 
    226161, 
    245154, 
    226167, 
    226162, 
    226163, 
    226164, 
    245155, 
    241165, 
    226169, 
    226170, 
    226171, 
    226172, 
    226173, 
    226175, 
    226176, 
    226177, 
    226178, 
    226210, 
    226179, 
    226180, 
    226181, 
    226182, 
    226183, 
    226184, 
    226204, 
    226185, 
    237230, 
    237231, 
    226186, 
    226211, 
    241166, 
    226187, 
    226188, 
    226189, 
    226190, 
    226191, 
    241167, 
    226192, 
    226193, 
    226194, 
    226195, 
    226196, 
    226197, 
    226198, 
    226199, 
    241168, 
    226200, 
    241169, 
    226201, 
    226202, 
    245156, 
    226213, 
    242125, 
    226203, 
    245157, 
    241170, 
    226208, 
    226209, 
    226215, 
    226216, 
    226217, 
    226229, 
    226227, 
    226228, 
    226260, 
    226230, 
    226231, 
    226232, 
    226233, 
    226234, 
    226235, 
    237232, 
    237233, 
    226236, 
    226256, 
    242014, 
    226237, 
    226238, 
    226239, 
    226240, 
    226241, 
    242015, 
    226242, 
    226243, 
    226244, 
    226245, 
    226246, 
    226247, 
    226248, 
    226249, 
    242016, 
    226250, 
    242017, 
    226251, 
    226252, 
    226253, 
    226254, 
    226255, 
    242018, 
    226258, 
    226270, 
    226266, 
    226267, 
    226268, 
    226269, 
    226275, 
    226271, 
    226274, 
    226272, 
    226273, 
    226280, 
    226276, 
    226279, 
    226277, 
    226278, 
    226316, 
    226286, 
    226287, 
    226288, 
    226289, 
    226290, 
    226310, 
    226291, 
    237228, 
    237229, 
    226292, 
    226317, 
    241176, 
    226293, 
    226294, 
    226295, 
    226296, 
    226297, 
    241177, 
    226298, 
    226299, 
    226300, 
    226301, 
    226302, 
    226303, 
    226304, 
    226305, 
    241178, 
    226306, 
    241179, 
    226307, 
    226308, 
    245158, 
    226319, 
    242126, 
    226309, 
    245159, 
    241180, 
    226314, 
    226315, 
    226321, 
    226323, 
    226324, 
    226325
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00256

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": 192,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (221146,221147,221148,226174,226139,226140,226141,226142,226143,226144,237236,237237,226145,226165,241161,226146,226147,226148,226149,226150,241162,226151,226152,226153,226154,226155,226156,226157,226158,241163,226159,241164,226160,226161,245154,226167,226162,226163,226164,245155,241165,226169,226170,226171,226172,226173,226175,226176,226177,226178,226210,226179,226180,226181,226182,226183,226184,226204,226185,237230,237231,226186,226211,241166,226187,226188,226189,226190,226191,241167,226192,226193,226194,226195,226196,226197,226198,226199,241168,226200,241169,226201,226202,245156,226213,242125,226203,245157,241170,226208,226209,226215,226216,226217,226229,226227,226228,226260,226230,226231,226232,226233,226234,226235,237232,237233,226236,226256,242014,226237,226238,226239,226240,226241,242015,226242,226243,226244,226245,226246,226247,226248,226249,242016,226250,242017,226251,226252,226253,226254,226255,242018,226258,226270,226266,226267,226268,226269,226275,226271,226274,226272,226273,226280,226276,226279,226277,226278,226316,226286,226287,226288,226289,226290,226310,226291,237228,237229,226292,226317,241176,226293,226294,226295,226296,226297,241177,226298,226299,226300,226301,226302,226303,226304,226305,241178,226306,241179,226307,226308,245158,226319,242126,226309,245159,241180,226314,226315,226321,226323,226324,226325)"
        }
      }
    },
    "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.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_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
39613 221147 variant_image 51846 0 V 0 D 0 0
39614 221148 variant_image 51847 0 V 0 D 0 0
44356 226139 variant_image 56589 0 V 0 D 0 0
44357 226140 variant_image 56590 0 V 0 D 0 0
44358 226141 variant_image 56591 0 V 0 D 0 0
44359 226142 variant_image 56592 0 V 0 D 0 0
44360 226143 variant_image 56593 0 V 0 D 0 0
44361 226144 variant_image 56594 0 V 0 D 0 0
44362 226145 variant_image 56595 0 V 0 D 0 0
44363 226146 variant_image 56596 0 V 0 D 0 0
44364 226147 variant_image 56597 0 V 0 D 0 0
44365 226148 variant_image 56598 0 V 0 D 0 0
44366 226149 variant_image 56599 0 V 0 D 0 0
44367 226150 variant_image 56600 0 V 0 D 0 0
44368 226151 variant_image 56601 0 V 0 D 0 0
44369 226152 variant_image 56602 0 V 0 D 0 0
44370 226153 variant_image 56603 0 V 0 D 0 0
44371 226154 variant_image 56604 0 V 0 D 0 0
44372 226155 variant_image 56605 0 V 0 D 0 0
44373 226156 variant_image 56606 0 V 0 D 0 0
44374 226157 variant_image 56607 0 V 0 D 0 0
44375 226158 variant_image 56608 0 V 0 D 0 0
44376 226159 variant_image 56609 0 V 0 D 0 0
44377 226160 variant_image 56610 0 V 0 D 0 0
44378 226161 variant_image 56611 0 V 0 D 0 0
44379 226162 variant_image 56612 0 V 0 D 0 0
44380 226163 variant_image 56613 0 V 0 D 0 0
44381 226164 variant_image 56614 0 V 0 D 0 0
44382 226165 variant_image 56615 0 V 0 D 0 0
44384 226167 variant_image 56617 0 V 0 D 0 0
44386 226169 variant_image 56619 0 V 0 D 0 0
44387 226170 variant_image 56620 0 V 0 D 0 0
44388 226171 variant_image 56621 0 V 0 D 0 0
44389 226172 variant_image 56622 0 V 0 D 0 0
44390 226173 variant_image 56623 0 V 0 D 0 0
44391 226180 variant_image 56624 0 V 0 D 0 0
44392 226181 variant_image 56625 0 V 0 D 0 0
44393 226182 variant_image 56626 0 V 0 D 0 0
44394 226183 variant_image 56627 0 V 0 D 0 0
44395 226184 variant_image 56628 0 V 0 D 0 0
44396 226185 variant_image 56629 0 V 0 D 0 0
44397 226186 variant_image 56630 0 V 0 D 0 0
44398 226187 variant_image 56631 0 V 0 D 0 0
44399 226188 variant_image 56632 0 V 0 D 0 0
44400 226189 variant_image 56633 0 V 0 D 0 0
44401 226190 variant_image 56634 0 V 0 D 0 0
44402 226191 variant_image 56635 0 V 0 D 0 0
44403 226192 variant_image 56636 0 V 0 D 0 0
44404 226193 variant_image 56637 0 V 0 D 0 0
44405 226194 variant_image 56638 0 V 0 D 0 0
44406 226195 variant_image 56639 0 V 0 D 0 0
44407 226196 variant_image 56640 0 V 0 D 0 0
44408 226197 variant_image 56641 0 V 0 D 0 0
44409 226198 variant_image 56642 0 V 0 D 0 0
44410 226199 variant_image 56643 0 V 0 D 0 0
44411 226200 variant_image 56644 0 V 0 D 0 0
44412 226201 variant_image 56645 0 V 0 D 0 0
44413 226202 variant_image 56646 0 V 0 D 0 0
44414 226203 variant_image 56647 0 V 0 D 0 0
44415 226204 variant_image 56648 0 V 0 D 0 0
44419 226208 variant_image 56652 0 V 0 D 0 0
44420 226209 variant_image 56653 0 V 0 D 0 0
44421 226211 variant_image 56654 0 V 0 D 0 0
44423 226213 variant_image 56656 0 V 0 D 0 0
44425 226216 variant_image 56658 0 V 0 D 0 0
44426 226217 variant_image 56659 0 V 0 D 0 0
44433 226227 variant_image 56666 0 V 0 D 0 0
44434 226228 variant_image 56667 0 V 0 D 0 0
44435 226230 variant_image 56668 0 V 0 D 0 0
44436 226231 variant_image 56669 0 V 0 D 0 0
44437 226232 variant_image 56670 0 V 0 D 0 0
44438 226233 variant_image 56671 0 V 0 D 0 0
44439 226234 variant_image 56672 0 V 0 D 0 0
44440 226235 variant_image 56673 0 V 0 D 0 0
44441 226236 variant_image 56674 0 V 0 D 0 0
44442 226237 variant_image 56675 0 V 0 D 0 0
44443 226238 variant_image 56676 0 V 0 D 0 0
44444 226239 variant_image 56677 0 V 0 D 0 0
44445 226240 variant_image 56678 0 V 0 D 0 0
44446 226241 variant_image 56679 0 V 0 D 0 0
44447 226242 variant_image 56680 0 V 0 D 0 0
44448 226243 variant_image 56681 0 V 0 D 0 0
44449 226244 variant_image 56682 0 V 0 D 0 0
44450 226245 variant_image 56683 0 V 0 D 0 0
44451 226246 variant_image 56684 0 V 0 D 0 0
44452 226247 variant_image 56685 0 V 0 D 0 0
44453 226248 variant_image 56686 0 V 0 D 0 0
44454 226249 variant_image 56687 0 V 0 D 0 0
44455 226250 variant_image 56688 0 V 0 D 0 0
44456 226251 variant_image 56689 0 V 0 D 0 0
44457 226252 variant_image 56690 0 V 0 D 0 0
44458 226253 variant_image 56691 0 V 0 D 0 0
44459 226254 variant_image 56692 0 V 0 D 0 0
44460 226255 variant_image 56693 0 V 0 D 0 0
44461 226256 variant_image 56694 0 V 0 D 0 0
44463 226258 variant_image 56696 0 V 0 D 0 0
44469 226266 variant_image 56702 0 V 0 D 0 0
44470 226267 variant_image 56703 0 V 0 D 0 0
44471 226268 variant_image 56704 0 V 0 D 0 0
44472 226269 variant_image 56705 0 V 0 D 0 0
44473 226271 variant_image 56706 0 V 0 D 0 0
44474 226272 variant_image 56707 0 V 0 D 0 0
44475 226273 variant_image 56708 0 V 0 D 0 0
44476 226274 variant_image 56709 0 V 0 D 0 0
44477 226276 variant_image 56710 0 V 0 D 0 0
44478 226277 variant_image 56711 0 V 0 D 0 0
44479 226278 variant_image 56712 0 V 0 D 0 0
44480 226279 variant_image 56713 0 V 0 D 0 0
44485 226286 variant_image 56718 0 V 0 D 0 0
44486 226287 variant_image 56719 0 V 0 D 0 0
44487 226288 variant_image 56720 0 V 0 D 0 0
44488 226289 variant_image 56721 0 V 0 D 0 0
44489 226290 variant_image 56722 0 V 0 D 0 0
44490 226291 variant_image 56723 0 V 0 D 0 0
44491 226292 variant_image 56724 0 V 0 D 0 0
44492 226293 variant_image 56725 0 V 0 D 0 0
44493 226294 variant_image 56726 0 V 0 D 0 0
44494 226295 variant_image 56727 0 V 0 D 0 0
44495 226296 variant_image 56728 0 V 0 D 0 0
44496 226297 variant_image 56729 0 V 0 D 0 0
44497 226298 variant_image 56730 0 V 0 D 0 0
44498 226299 variant_image 56731 0 V 0 D 0 0
44499 226300 variant_image 56732 0 V 0 D 0 0
44500 226301 variant_image 56733 0 V 0 D 0 0
44501 226302 variant_image 56734 0 V 0 D 0 0
44502 226303 variant_image 56735 0 V 0 D 0 0
44503 226304 variant_image 56736 0 V 0 D 0 0
44504 226305 variant_image 56737 0 V 0 D 0 0
44505 226306 variant_image 56738 0 V 0 D 0 0
44506 226307 variant_image 56739 0 V 0 D 0 0
44507 226308 variant_image 56740 0 V 0 D 0 0
44508 226309 variant_image 56741 0 V 0 D 0 0
44509 226310 variant_image 56742 0 V 0 D 0 0
44513 226314 variant_image 56746 0 V 0 D 0 0
44514 226315 variant_image 56747 0 V 0 D 0 0
44515 226317 variant_image 56748 0 V 0 D 0 0
44517 226319 variant_image 56750 0 V 0 D 0 0
44520 226323 variant_image 56753 0 V 0 D 0 0
44521 226324 variant_image 56754 0 V 0 D 0 0
44522 226325 variant_image 56755 0 V 0 D 0 0
59979 237228 variant_image 72212 0 V 0 D 0 0
59980 237229 variant_image 72213 0 V 0 D 0 0
59981 237230 variant_image 72214 0 V 0 D 0 0
59982 237231 variant_image 72215 0 V 0 D 0 0
59983 237232 variant_image 72216 0 V 0 D 0 0
59984 237233 variant_image 72217 0 V 0 D 0 0
59987 237236 variant_image 72220 0 V 0 D 0 0
59988 237237 variant_image 72221 0 V 0 D 0 0
70696 241161 variant_image 82929 0 V 0 D 0 0
70697 241162 variant_image 82930 0 V 0 D 0 0
70698 241163 variant_image 82931 0 V 0 D 0 0
70699 241164 variant_image 82932 0 V 0 D 0 0
70700 241165 variant_image 82933 0 V 0 D 0 0
70701 241166 variant_image 82934 0 V 0 D 0 0
70702 241167 variant_image 82935 0 V 0 D 0 0
70703 241168 variant_image 82936 0 V 0 D 0 0
70704 241169 variant_image 82937 0 V 0 D 0 0
70705 241170 variant_image 82938 0 V 0 D 0 0
70711 241176 variant_image 82944 0 V 0 D 0 0
70712 241177 variant_image 82945 0 V 0 D 0 0
70713 241178 variant_image 82946 0 V 0 D 0 0
70714 241179 variant_image 82947 0 V 0 D 0 0
70715 241180 variant_image 82948 0 V 0 D 0 0
71567 242014 variant_image 83800 0 V 0 D 0 0
71568 242015 variant_image 83801 0 V 0 D 0 0
71569 242016 variant_image 83802 0 V 0 D 0 0
71570 242017 variant_image 83803 0 V 0 D 0 0
71571 242018 variant_image 83804 0 V 0 D 0 0
71683 242125 variant_image 83916 0 V 0 D 0 0
71684 242126 variant_image 83917 0 V 0 D 0 0
74957 245154 variant_image 87190 0 V 0 D 0 0
74958 245155 variant_image 87191 0 V 0 D 0 0
74959 245156 variant_image 87192 0 V 0 D 0 0
74960 245157 variant_image 87193 0 V 0 D 0 0
74961 245158 variant_image 87194 0 V 0 D 0 0
74962 245159 variant_image 87195 0 V 0 D 0 0