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 (
    220318, 
    215376, 
    215377, 
    227161, 
    227152, 
    227153, 
    227154, 
    227191, 
    227193, 
    227192, 
    227194, 
    227195, 
    227196, 
    227197, 
    227233, 
    227198, 
    227199, 
    227200, 
    227201, 
    227202, 
    227203, 
    237054, 
    237055, 
    227204, 
    242736, 
    241974, 
    227205, 
    227206, 
    227207, 
    227208, 
    227209, 
    241975, 
    227210, 
    227211, 
    227212, 
    227213, 
    227214, 
    227215, 
    227216, 
    227217, 
    241976, 
    227218, 
    241977, 
    227219, 
    227220, 
    242737, 
    242738, 
    227221, 
    227222, 
    227223, 
    242739, 
    241978, 
    227228, 
    227229, 
    227230, 
    227231, 
    227232, 
    227263, 
    227234, 
    227235, 
    227236, 
    227237, 
    227238, 
    227239, 
    227240, 
    227241, 
    227242, 
    227243, 
    227244, 
    227245, 
    227246, 
    227247, 
    227248, 
    227249, 
    227250, 
    227251, 
    227252, 
    227253, 
    227254, 
    227255, 
    227256, 
    227257, 
    227258, 
    227259, 
    227260, 
    227261, 
    227262, 
    227295, 
    227264, 
    227265, 
    227266, 
    227267, 
    227268, 
    227269, 
    227289, 
    227270, 
    237056, 
    237057, 
    227271, 
    241999, 
    227272, 
    227273, 
    227274, 
    227275, 
    227276, 
    242000, 
    227277, 
    227278, 
    227279, 
    227280, 
    227281, 
    227282, 
    227283, 
    227284, 
    242001, 
    227285, 
    242002, 
    227286, 
    227287, 
    239946, 
    227288, 
    242003, 
    242839, 
    242840, 
    242841, 
    242842, 
    227293, 
    227294, 
    227330, 
    245559, 
    245560, 
    245561, 
    245562, 
    245563, 
    245564, 
    245565, 
    245566, 
    227300, 
    227301, 
    227302, 
    227303, 
    227304, 
    227324, 
    227305, 
    237058, 
    237059, 
    227306, 
    242004, 
    227307, 
    227308, 
    227309, 
    227310, 
    227311, 
    242005, 
    227312, 
    227313, 
    227314, 
    227315, 
    227316, 
    227317, 
    227318, 
    227319, 
    242006, 
    227320, 
    242007, 
    227321, 
    227322, 
    239947, 
    227323, 
    242008, 
    242843, 
    242844, 
    242845, 
    242846, 
    227328, 
    227329, 
    227335, 
    227336, 
    227337, 
    227338, 
    227339, 
    227340, 
    227341, 
    227342, 
    227343, 
    227392, 
    227362, 
    227363, 
    227364, 
    227365, 
    227366, 
    227367, 
    237060, 
    237061, 
    227368, 
    242744, 
    242009, 
    227369, 
    227370, 
    227371, 
    227372, 
    227373, 
    242010, 
    227374, 
    227375, 
    227376, 
    227377, 
    227378, 
    227379, 
    227380, 
    227381, 
    242011, 
    227382, 
    242012, 
    227383, 
    227384, 
    242745, 
    242746, 
    227385, 
    227386, 
    227387, 
    242747, 
    242013, 
    227397, 
    227393, 
    227394, 
    227395, 
    227396, 
    227402, 
    227398, 
    227399, 
    227400, 
    227401, 
    227407, 
    227403, 
    227404, 
    227405, 
    227406
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00346

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": 238,
          "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,227161,227152,227153,227154,227191,227193,227192,227194,227195,227196,227197,227233,227198,227199,227200,227201,227202,227203,237054,237055,227204,242736,241974,227205,227206,227207,227208,227209,241975,227210,227211,227212,227213,227214,227215,227216,227217,241976,227218,241977,227219,227220,242737,242738,227221,227222,227223,242739,241978,227228,227229,227230,227231,227232,227263,227234,227235,227236,227237,227238,227239,227240,227241,227242,227243,227244,227245,227246,227247,227248,227249,227250,227251,227252,227253,227254,227255,227256,227257,227258,227259,227260,227261,227262,227295,227264,227265,227266,227267,227268,227269,227289,227270,237056,237057,227271,241999,227272,227273,227274,227275,227276,242000,227277,227278,227279,227280,227281,227282,227283,227284,242001,227285,242002,227286,227287,239946,227288,242003,242839,242840,242841,242842,227293,227294,227330,245559,245560,245561,245562,245563,245564,245565,245566,227300,227301,227302,227303,227304,227324,227305,237058,237059,227306,242004,227307,227308,227309,227310,227311,242005,227312,227313,227314,227315,227316,227317,227318,227319,242006,227320,242007,227321,227322,239947,227323,242008,242843,242844,242845,242846,227328,227329,227335,227336,227337,227338,227339,227340,227341,227342,227343,227392,227362,227363,227364,227365,227366,227367,237060,237061,227368,242744,242009,227369,227370,227371,227372,227373,242010,227374,227375,227376,227377,227378,227379,227380,227381,242011,227382,242012,227383,227384,242745,242746,227385,227386,227387,242747,242013,227397,227393,227394,227395,227396,227402,227398,227399,227400,227401,227407,227403,227404,227405,227406)"
        }
      }
    },
    "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
33339 215376 variant_image 45572 0 V 0 D 0 0
33340 215377 variant_image 45573 0 V 0 D 0 0
45339 227152 variant_image 57572 0 V 0 D 0 0
45340 227153 variant_image 57573 0 V 0 D 0 0
45341 227154 variant_image 57574 0 V 0 D 0 0
45365 227195 variant_image 57598 0 V 0 D 0 0
45366 227196 variant_image 57599 0 V 0 D 0 0
45367 227197 variant_image 57600 0 V 0 D 0 0
45368 227198 variant_image 57601 0 V 0 D 0 0
45369 227199 variant_image 57602 0 V 0 D 0 0
45370 227200 variant_image 57603 0 V 0 D 0 0
45371 227201 variant_image 57604 0 V 0 D 0 0
45372 227202 variant_image 57605 0 V 0 D 0 0
45373 227203 variant_image 57606 0 V 0 D 0 0
45374 227204 variant_image 57607 0 V 0 D 0 0
45375 227205 variant_image 57608 0 V 0 D 0 0
45376 227206 variant_image 57609 0 V 0 D 0 0
45377 227207 variant_image 57610 0 V 0 D 0 0
45378 227208 variant_image 57611 0 V 0 D 0 0
45379 227209 variant_image 57612 0 V 0 D 0 0
45380 227210 variant_image 57613 0 V 0 D 0 0
45381 227211 variant_image 57614 0 V 0 D 0 0
45382 227212 variant_image 57615 0 V 0 D 0 0
45383 227213 variant_image 57616 0 V 0 D 0 0
45384 227214 variant_image 57617 0 V 0 D 0 0
45385 227215 variant_image 57618 0 V 0 D 0 0
45386 227216 variant_image 57619 0 V 0 D 0 0
45387 227217 variant_image 57620 0 V 0 D 0 0
45388 227218 variant_image 57621 0 V 0 D 0 0
45389 227219 variant_image 57622 0 V 0 D 0 0
45390 227220 variant_image 57623 0 V 0 D 0 0
45391 227221 variant_image 57624 0 V 0 D 0 0
45392 227222 variant_image 57625 0 V 0 D 0 0
45393 227223 variant_image 57626 0 V 0 D 0 0
45398 227228 variant_image 57631 0 V 0 D 0 0
45399 227229 variant_image 57632 0 V 0 D 0 0
45400 227230 variant_image 57633 0 V 0 D 0 0
45401 227231 variant_image 57634 0 V 0 D 0 0
45402 227232 variant_image 57635 0 V 0 D 0 0
45403 227234 variant_image 57636 0 V 0 D 0 0
45404 227235 variant_image 57637 0 V 0 D 0 0
45405 227236 variant_image 57638 0 V 0 D 0 0
45406 227237 variant_image 57639 0 V 0 D 0 0
45407 227238 variant_image 57640 0 V 0 D 0 0
45408 227239 variant_image 57641 0 V 0 D 0 0
45409 227240 variant_image 57642 0 V 0 D 0 0
45410 227241 variant_image 57643 0 V 0 D 0 0
45411 227242 variant_image 57644 0 V 0 D 0 0
45412 227243 variant_image 57645 0 V 0 D 0 0
45413 227244 variant_image 57646 0 V 0 D 0 0
45414 227245 variant_image 57647 0 V 0 D 0 0
45415 227246 variant_image 57648 0 V 0 D 0 0
45416 227247 variant_image 57649 0 V 0 D 0 0
45417 227248 variant_image 57650 0 V 0 D 0 0
45418 227249 variant_image 57651 0 V 0 D 0 0
45419 227250 variant_image 57652 0 V 0 D 0 0
45420 227251 variant_image 57653 0 V 0 D 0 0
45421 227252 variant_image 57654 0 V 0 D 0 0
45422 227253 variant_image 57655 0 V 0 D 0 0
45423 227254 variant_image 57656 0 V 0 D 0 0
45424 227255 variant_image 57657 0 V 0 D 0 0
45425 227256 variant_image 57658 0 V 0 D 0 0
45426 227257 variant_image 57659 0 V 0 D 0 0
45427 227258 variant_image 57660 0 V 0 D 0 0
45428 227259 variant_image 57661 0 V 0 D 0 0
45429 227260 variant_image 57662 0 V 0 D 0 0
45430 227261 variant_image 57663 0 V 0 D 0 0
45431 227262 variant_image 57664 0 V 0 D 0 0
45432 227265 variant_image 57665 0 V 0 D 0 0
45433 227266 variant_image 57666 0 V 0 D 0 0
45434 227267 variant_image 57667 0 V 0 D 0 0
45435 227268 variant_image 57668 0 V 0 D 0 0
45436 227269 variant_image 57669 0 V 0 D 0 0
45437 227270 variant_image 57670 0 V 0 D 0 0
45438 227271 variant_image 57671 0 V 0 D 0 0
45439 227272 variant_image 57672 0 V 0 D 0 0
45440 227273 variant_image 57673 0 V 0 D 0 0
45441 227274 variant_image 57674 0 V 0 D 0 0
45442 227275 variant_image 57675 0 V 0 D 0 0
45443 227276 variant_image 57676 0 V 0 D 0 0
45444 227277 variant_image 57677 0 V 0 D 0 0
45445 227278 variant_image 57678 0 V 0 D 0 0
45446 227279 variant_image 57679 0 V 0 D 0 0
45447 227280 variant_image 57680 0 V 0 D 0 0
45448 227281 variant_image 57681 0 V 0 D 0 0
45449 227282 variant_image 57682 0 V 0 D 0 0
45450 227283 variant_image 57683 0 V 0 D 0 0
45451 227284 variant_image 57684 0 V 0 D 0 0
45452 227285 variant_image 57685 0 V 0 D 0 0
45453 227286 variant_image 57686 0 V 0 D 0 0
45454 227287 variant_image 57687 0 V 0 D 0 0
45455 227288 variant_image 57688 0 V 0 D 0 0
45456 227289 variant_image 57689 0 V 0 D 0 0
45460 227293 variant_image 57693 0 V 0 D 0 0
45461 227294 variant_image 57694 0 V 0 D 0 0
45466 227300 variant_image 57699 0 V 0 D 0 0
45467 227301 variant_image 57700 0 V 0 D 0 0
45468 227302 variant_image 57701 0 V 0 D 0 0
45469 227303 variant_image 57702 0 V 0 D 0 0
45470 227304 variant_image 57703 0 V 0 D 0 0
45471 227305 variant_image 57704 0 V 0 D 0 0
45472 227306 variant_image 57705 0 V 0 D 0 0
45473 227307 variant_image 57706 0 V 0 D 0 0
45474 227308 variant_image 57707 0 V 0 D 0 0
45475 227309 variant_image 57708 0 V 0 D 0 0
45476 227310 variant_image 57709 0 V 0 D 0 0
45477 227311 variant_image 57710 0 V 0 D 0 0
45478 227312 variant_image 57711 0 V 0 D 0 0
45479 227313 variant_image 57712 0 V 0 D 0 0
45480 227314 variant_image 57713 0 V 0 D 0 0
45481 227315 variant_image 57714 0 V 0 D 0 0
45482 227316 variant_image 57715 0 V 0 D 0 0
45483 227317 variant_image 57716 0 V 0 D 0 0
45484 227318 variant_image 57717 0 V 0 D 0 0
45485 227319 variant_image 57718 0 V 0 D 0 0
45486 227320 variant_image 57719 0 V 0 D 0 0
45487 227321 variant_image 57720 0 V 0 D 0 0
45488 227322 variant_image 57721 0 V 0 D 0 0
45489 227323 variant_image 57722 0 V 0 D 0 0
45490 227324 variant_image 57723 0 V 0 D 0 0
45494 227328 variant_image 57727 0 V 0 D 0 0
45495 227329 variant_image 57728 0 V 0 D 0 0
45500 227336 variant_image 57733 0 V 0 D 0 0
45501 227337 variant_image 57734 0 V 0 D 0 0
45502 227339 variant_image 57735 0 V 0 D 0 0
45503 227340 variant_image 57736 0 V 0 D 0 0
45504 227342 variant_image 57737 0 V 0 D 0 0
45505 227343 variant_image 57738 0 V 0 D 0 0
45518 227362 variant_image 57751 0 V 0 D 0 0
45519 227363 variant_image 57752 0 V 0 D 0 0
45520 227364 variant_image 57753 0 V 0 D 0 0
45521 227365 variant_image 57754 0 V 0 D 0 0
45522 227366 variant_image 57755 0 V 0 D 0 0
45523 227367 variant_image 57756 0 V 0 D 0 0
45524 227368 variant_image 57757 0 V 0 D 0 0
45525 227369 variant_image 57758 0 V 0 D 0 0
45526 227370 variant_image 57759 0 V 0 D 0 0
45527 227371 variant_image 57760 0 V 0 D 0 0
45528 227372 variant_image 57761 0 V 0 D 0 0
45529 227373 variant_image 57762 0 V 0 D 0 0
45530 227374 variant_image 57763 0 V 0 D 0 0
45531 227375 variant_image 57764 0 V 0 D 0 0
45532 227376 variant_image 57765 0 V 0 D 0 0
45533 227377 variant_image 57766 0 V 0 D 0 0
45534 227378 variant_image 57767 0 V 0 D 0 0
45535 227379 variant_image 57768 0 V 0 D 0 0
45536 227380 variant_image 57769 0 V 0 D 0 0
45537 227381 variant_image 57770 0 V 0 D 0 0
45538 227382 variant_image 57771 0 V 0 D 0 0
45539 227383 variant_image 57772 0 V 0 D 0 0
45540 227384 variant_image 57773 0 V 0 D 0 0
45541 227385 variant_image 57774 0 V 0 D 0 0
45542 227386 variant_image 57775 0 V 0 D 0 0
45543 227387 variant_image 57776 0 V 0 D 0 0
45548 227393 variant_image 57781 0 V 0 D 0 0
45549 227394 variant_image 57782 0 V 0 D 0 0
45550 227395 variant_image 57783 0 V 0 D 0 0
45551 227396 variant_image 57784 0 V 0 D 0 0
45552 227398 variant_image 57785 0 V 0 D 0 0
45553 227399 variant_image 57786 0 V 0 D 0 0
45554 227400 variant_image 57787 0 V 0 D 0 0
45555 227401 variant_image 57788 0 V 0 D 0 0
45556 227403 variant_image 57789 0 V 0 D 0 0
45557 227404 variant_image 57790 0 V 0 D 0 0
45558 227405 variant_image 57791 0 V 0 D 0 0
45559 227406 variant_image 57792 0 V 0 D 0 0
59801 237054 variant_image 72034 0 V 0 D 0 0
59802 237055 variant_image 72035 0 V 0 D 0 0
59803 237056 variant_image 72036 0 V 0 D 0 0
59804 237057 variant_image 72037 0 V 0 D 0 0
59805 237058 variant_image 72038 0 V 0 D 0 0
59806 237059 variant_image 72039 0 V 0 D 0 0
59807 237060 variant_image 72040 0 V 0 D 0 0
59808 237061 variant_image 72041 0 V 0 D 0 0
68283 239946 variant_image 80516 0 V 0 D 0 0
68284 239947 variant_image 80517 0 V 0 D 0 0
71527 241974 variant_image 83760 0 V 0 D 0 0
71528 241975 variant_image 83761 0 V 0 D 0 0
71529 241976 variant_image 83762 0 V 0 D 0 0
71530 241977 variant_image 83763 0 V 0 D 0 0
71531 241978 variant_image 83764 0 V 0 D 0 0
71552 241999 variant_image 83785 0 V 0 D 0 0
71553 242000 variant_image 83786 0 V 0 D 0 0
71554 242001 variant_image 83787 0 V 0 D 0 0
71555 242002 variant_image 83788 0 V 0 D 0 0
71556 242003 variant_image 83789 0 V 0 D 0 0
71557 242004 variant_image 83790 0 V 0 D 0 0
71558 242005 variant_image 83791 0 V 0 D 0 0
71559 242006 variant_image 83792 0 V 0 D 0 0
71560 242007 variant_image 83793 0 V 0 D 0 0
71561 242008 variant_image 83794 0 V 0 D 0 0
71562 242009 variant_image 83795 0 V 0 D 0 0
71563 242010 variant_image 83796 0 V 0 D 0 0
71564 242011 variant_image 83797 0 V 0 D 0 0
71565 242012 variant_image 83798 0 V 0 D 0 0
71566 242013 variant_image 83799 0 V 0 D 0 0
72345 242736 variant_image 84578 0 V 0 D 0 0
72346 242737 variant_image 84579 0 V 0 D 0 0
72347 242738 variant_image 84580 0 V 0 D 0 0
72348 242739 variant_image 84581 0 V 0 D 0 0
72353 242744 variant_image 84586 0 V 0 D 0 0
72354 242745 variant_image 84587 0 V 0 D 0 0
72355 242746 variant_image 84588 0 V 0 D 0 0
72356 242747 variant_image 84589 0 V 0 D 0 0
72448 242839 variant_image 84681 0 V 0 D 0 0
72449 242840 variant_image 84682 0 V 0 D 0 0
72450 242841 variant_image 84683 0 V 0 D 0 0
72451 242842 variant_image 84684 0 V 0 D 0 0
72452 242843 variant_image 84685 0 V 0 D 0 0
72453 242844 variant_image 84686 0 V 0 D 0 0
72454 242845 variant_image 84687 0 V 0 D 0 0
72455 242846 variant_image 84688 0 V 0 D 0 0
75656 245559 variant_image 87889 0 V 0 D 0 0
75657 245560 variant_image 87890 0 V 0 D 0 0
75658 245561 variant_image 87891 0 V 0 D 0 0
75659 245562 variant_image 87892 0 V 0 D 0 0
75660 245563 variant_image 87893 0 V 0 D 0 0
75661 245564 variant_image 87894 0 V 0 D 0 0
75662 245565 variant_image 87895 0 V 0 D 0 0
75663 245566 variant_image 87896 0 V 0 D 0 0