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 (
    220319, 
    219225, 
    219227, 
    242997, 
    219229, 
    228071, 
    228069, 
    228070, 
    229196, 
    229193, 
    229194, 
    229195, 
    229197, 
    229198, 
    229199, 
    229204, 
    229200, 
    229201, 
    229205, 
    229202, 
    229203, 
    229206, 
    229248, 
    229207, 
    229208, 
    229209, 
    229210, 
    229213, 
    229211, 
    229212, 
    229214, 
    229215, 
    229216, 
    229217, 
    229218, 
    229219, 
    229220, 
    229221, 
    229222, 
    229223, 
    237325, 
    237326, 
    229224, 
    242893, 
    229225, 
    229226, 
    229227, 
    229228, 
    229229, 
    242894, 
    229230, 
    229231, 
    229232, 
    229233, 
    229234, 
    229235, 
    229236, 
    229237, 
    242895, 
    229238, 
    242896, 
    229239, 
    229240, 
    229241, 
    229242, 
    242897, 
    229269, 
    229268, 
    229256, 
    229257, 
    229258, 
    229259, 
    229262, 
    229260, 
    229261, 
    229263, 
    229264, 
    229265, 
    229266, 
    229267, 
    229302, 
    229270, 
    229271, 
    229272, 
    229273, 
    229274, 
    229276, 
    240722, 
    240723, 
    229277, 
    241448, 
    229278, 
    229279, 
    229280, 
    229281, 
    229282, 
    241449, 
    229283, 
    229284, 
    229285, 
    229286, 
    229287, 
    229288, 
    229289, 
    229290, 
    241450, 
    229291, 
    241451, 
    229292, 
    229293, 
    229294, 
    229295, 
    229296, 
    241452, 
    229315, 
    229303, 
    229304, 
    229305, 
    229306, 
    229309, 
    229307, 
    229308, 
    229310, 
    229341, 
    229316, 
    229317, 
    229318, 
    229319, 
    229320, 
    229321, 
    237158, 
    237159, 
    229322, 
    245349, 
    242898, 
    229323, 
    229324, 
    229325, 
    229326, 
    229327, 
    242899, 
    229328, 
    229329, 
    229330, 
    229331, 
    229332, 
    229333, 
    229334, 
    229335, 
    242900, 
    229336, 
    242901, 
    229337, 
    229338, 
    245350, 
    245351, 
    229342, 
    229339, 
    229340, 
    245352, 
    242902, 
    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.00241

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": 222,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220319,219225,219227,242997,219229,228071,228069,228070,229196,229193,229194,229195,229197,229198,229199,229204,229200,229201,229205,229202,229203,229206,229248,229207,229208,229209,229210,229213,229211,229212,229214,229215,229216,229217,229218,229219,229220,229221,229222,229223,237325,237326,229224,242893,229225,229226,229227,229228,229229,242894,229230,229231,229232,229233,229234,229235,229236,229237,242895,229238,242896,229239,229240,229241,229242,242897,229269,229268,229256,229257,229258,229259,229262,229260,229261,229263,229264,229265,229266,229267,229302,229270,229271,229272,229273,229274,229276,240722,240723,229277,241448,229278,229279,229280,229281,229282,241449,229283,229284,229285,229286,229287,229288,229289,229290,241450,229291,241451,229292,229293,229294,229295,229296,241452,229315,229303,229304,229305,229306,229309,229307,229308,229310,229341,229316,229317,229318,229319,229320,229321,237158,237159,229322,245349,242898,229323,229324,229325,229326,229327,242899,229328,229329,229330,229331,229332,229333,229334,229335,242900,229336,242901,229337,229338,245350,245351,229342,229339,229340,245352,242902,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.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
37889 219227 variant_image 50122 0 V 0 D 0 0
37891 219229 variant_image 50124 0 V 0 D 0 0
38008 219225 variant_image 50241 0 V 0 D 0 0
46126 228069 variant_image 58359 0 V 0 D 0 0
46127 228070 variant_image 58360 0 V 0 D 0 0
47384 229193 variant_image 59617 0 V 0 D 0 0
47385 229194 variant_image 59618 0 V 0 D 0 0
47386 229195 variant_image 59619 0 V 0 D 0 0
47387 229198 variant_image 59620 0 V 0 D 0 0
47388 229199 variant_image 59621 0 V 0 D 0 0
47389 229200 variant_image 59622 0 V 0 D 0 0
47390 229201 variant_image 59623 0 V 0 D 0 0
47391 229202 variant_image 59624 0 V 0 D 0 0
47392 229203 variant_image 59625 0 V 0 D 0 0
47393 229204 variant_image 59626 0 V 0 D 0 0
47394 229205 variant_image 59627 0 V 0 D 0 0
47395 229206 variant_image 59628 0 V 0 D 0 0
47396 229207 variant_image 59629 0 V 0 D 0 0
47397 229208 variant_image 59630 0 V 0 D 0 0
47398 229209 variant_image 59631 0 V 0 D 0 0
47399 229210 variant_image 59632 0 V 0 D 0 0
47400 229211 variant_image 59633 0 V 0 D 0 0
47401 229212 variant_image 59634 0 V 0 D 0 0
47402 229213 variant_image 59635 0 V 0 D 0 0
47403 229214 variant_image 59636 0 V 0 D 0 0
47404 229215 variant_image 59637 0 V 0 D 0 0
47405 229216 variant_image 59638 0 V 0 D 0 0
47406 229217 variant_image 59639 0 V 0 D 0 0
47407 229218 variant_image 59640 0 V 0 D 0 0
47408 229219 variant_image 59641 0 V 0 D 0 0
47409 229220 variant_image 59642 0 V 0 D 0 0
47410 229221 variant_image 59643 0 V 0 D 0 0
47411 229222 variant_image 59644 0 V 0 D 0 0
47412 229223 variant_image 59645 0 V 0 D 0 0
47413 229224 variant_image 59646 0 V 0 D 0 0
47414 229225 variant_image 59647 0 V 0 D 0 0
47415 229226 variant_image 59648 0 V 0 D 0 0
47416 229227 variant_image 59649 0 V 0 D 0 0
47417 229228 variant_image 59650 0 V 0 D 0 0
47418 229229 variant_image 59651 0 V 0 D 0 0
47419 229230 variant_image 59652 0 V 0 D 0 0
47420 229231 variant_image 59653 0 V 0 D 0 0
47421 229232 variant_image 59654 0 V 0 D 0 0
47422 229233 variant_image 59655 0 V 0 D 0 0
47423 229234 variant_image 59656 0 V 0 D 0 0
47424 229235 variant_image 59657 0 V 0 D 0 0
47425 229236 variant_image 59658 0 V 0 D 0 0
47426 229237 variant_image 59659 0 V 0 D 0 0
47427 229238 variant_image 59660 0 V 0 D 0 0
47428 229239 variant_image 59661 0 V 0 D 0 0
47429 229240 variant_image 59662 0 V 0 D 0 0
47430 229241 variant_image 59663 0 V 0 D 0 0
47431 229242 variant_image 59664 0 V 0 D 0 0
47444 229256 variant_image 59677 0 V 0 D 0 0
47445 229257 variant_image 59678 0 V 0 D 0 0
47446 229258 variant_image 59679 0 V 0 D 0 0
47447 229259 variant_image 59680 0 V 0 D 0 0
47448 229260 variant_image 59681 0 V 0 D 0 0
47449 229261 variant_image 59682 0 V 0 D 0 0
47450 229262 variant_image 59683 0 V 0 D 0 0
47451 229263 variant_image 59684 0 V 0 D 0 0
47452 229264 variant_image 59685 0 V 0 D 0 0
47453 229265 variant_image 59686 0 V 0 D 0 0
47454 229266 variant_image 59687 0 V 0 D 0 0
47455 229267 variant_image 59688 0 V 0 D 0 0
47456 229271 variant_image 59689 0 V 0 D 0 0
47457 229272 variant_image 59690 0 V 0 D 0 0
47458 229273 variant_image 59691 0 V 0 D 0 0
47459 229274 variant_image 59692 0 V 0 D 0 0
47461 229276 variant_image 59694 0 V 0 D 0 0
47462 229277 variant_image 59695 0 V 0 D 0 0
47463 229278 variant_image 59696 0 V 0 D 0 0
47464 229279 variant_image 59697 0 V 0 D 0 0
47465 229280 variant_image 59698 0 V 0 D 0 0
47466 229281 variant_image 59699 0 V 0 D 0 0
47467 229282 variant_image 59700 0 V 0 D 0 0
47468 229283 variant_image 59701 0 V 0 D 0 0
47469 229284 variant_image 59702 0 V 0 D 0 0
47470 229285 variant_image 59703 0 V 0 D 0 0
47471 229286 variant_image 59704 0 V 0 D 0 0
47472 229287 variant_image 59705 0 V 0 D 0 0
47473 229288 variant_image 59706 0 V 0 D 0 0
47474 229289 variant_image 59707 0 V 0 D 0 0
47475 229290 variant_image 59708 0 V 0 D 0 0
47476 229291 variant_image 59709 0 V 0 D 0 0
47477 229292 variant_image 59710 0 V 0 D 0 0
47478 229293 variant_image 59711 0 V 0 D 0 0
47479 229294 variant_image 59712 0 V 0 D 0 0
47480 229295 variant_image 59713 0 V 0 D 0 0
47481 229296 variant_image 59714 0 V 0 D 0 0
47487 229303 variant_image 59720 0 V 0 D 0 0
47488 229304 variant_image 59721 0 V 0 D 0 0
47489 229305 variant_image 59722 0 V 0 D 0 0
47490 229306 variant_image 59723 0 V 0 D 0 0
47491 229307 variant_image 59724 0 V 0 D 0 0
47492 229308 variant_image 59725 0 V 0 D 0 0
47493 229309 variant_image 59726 0 V 0 D 0 0
47494 229310 variant_image 59727 0 V 0 D 0 0
47499 229316 variant_image 59732 0 V 0 D 0 0
47500 229317 variant_image 59733 0 V 0 D 0 0
47501 229318 variant_image 59734 0 V 0 D 0 0
47502 229319 variant_image 59735 0 V 0 D 0 0
47503 229320 variant_image 59736 0 V 0 D 0 0
47504 229321 variant_image 59737 0 V 0 D 0 0
47505 229322 variant_image 59738 0 V 0 D 0 0
47506 229323 variant_image 59739 0 V 0 D 0 0
47507 229324 variant_image 59740 0 V 0 D 0 0
47508 229325 variant_image 59741 0 V 0 D 0 0
47509 229326 variant_image 59742 0 V 0 D 0 0
47510 229327 variant_image 59743 0 V 0 D 0 0
47511 229328 variant_image 59744 0 V 0 D 0 0
47512 229329 variant_image 59745 0 V 0 D 0 0
47513 229330 variant_image 59746 0 V 0 D 0 0
47514 229331 variant_image 59747 0 V 0 D 0 0
47515 229332 variant_image 59748 0 V 0 D 0 0
47516 229333 variant_image 59749 0 V 0 D 0 0
47517 229334 variant_image 59750 0 V 0 D 0 0
47518 229335 variant_image 59751 0 V 0 D 0 0
47519 229336 variant_image 59752 0 V 0 D 0 0
47520 229337 variant_image 59753 0 V 0 D 0 0
47521 229338 variant_image 59754 0 V 0 D 0 0
47522 229339 variant_image 59755 0 V 0 D 0 0
47523 229340 variant_image 59756 0 V 0 D 0 0
47524 229342 variant_image 59757 0 V 0 D 0 0
59905 237158 variant_image 72138 0 V 0 D 0 0
59906 237159 variant_image 72139 0 V 0 D 0 0
60326 237325 variant_image 72559 0 V 0 D 0 0
60327 237326 variant_image 72560 0 V 0 D 0 0
69896 240514 variant_image 82129 0 V 0 D 0 0
69897 240515 variant_image 82130 0 V 0 D 0 0
69898 240516 variant_image 82131 0 V 0 D 0 0
69899 240517 variant_image 82132 0 V 0 D 0 0
69900 240518 variant_image 82133 0 V 0 D 0 0
69901 240519 variant_image 82134 0 V 0 D 0 0
69902 240520 variant_image 82135 0 V 0 D 0 0
69903 240521 variant_image 82136 0 V 0 D 0 0
69904 240522 variant_image 82137 0 V 0 D 0 0
69905 240523 variant_image 82138 0 V 0 D 0 0
69906 240524 variant_image 82139 0 V 0 D 0 0
69907 240525 variant_image 82140 0 V 0 D 0 0
69908 240526 variant_image 82141 0 V 0 D 0 0
69909 240527 variant_image 82142 0 V 0 D 0 0
69910 240528 variant_image 82143 0 V 0 D 0 0
69911 240529 variant_image 82144 0 V 0 D 0 0
69912 240530 variant_image 82145 0 V 0 D 0 0
69917 240535 variant_image 82150 0 V 0 D 0 0
69918 240537 variant_image 82151 0 V 0 D 0 0
69919 240538 variant_image 82152 0 V 0 D 0 0
69920 240539 variant_image 82153 0 V 0 D 0 0
69921 240540 variant_image 82154 0 V 0 D 0 0
69922 240541 variant_image 82155 0 V 0 D 0 0
69923 240542 variant_image 82156 0 V 0 D 0 0
69924 240543 variant_image 82157 0 V 0 D 0 0
69925 240544 variant_image 82158 0 V 0 D 0 0
69926 240545 variant_image 82159 0 V 0 D 0 0
69927 240546 variant_image 82160 0 V 0 D 0 0
69928 240547 variant_image 82161 0 V 0 D 0 0
69929 240548 variant_image 82162 0 V 0 D 0 0
69930 240549 variant_image 82163 0 V 0 D 0 0
69931 240550 variant_image 82164 0 V 0 D 0 0
69932 240551 variant_image 82165 0 V 0 D 0 0
69933 240552 variant_image 82166 0 V 0 D 0 0
69934 240553 variant_image 82167 0 V 0 D 0 0
69939 240558 variant_image 82172 0 V 0 D 0 0
69940 240560 variant_image 82173 0 V 0 D 0 0
69941 240561 variant_image 82174 0 V 0 D 0 0
69942 240562 variant_image 82175 0 V 0 D 0 0
69943 240563 variant_image 82176 0 V 0 D 0 0
69944 240564 variant_image 82177 0 V 0 D 0 0
69945 240565 variant_image 82178 0 V 0 D 0 0
69946 240566 variant_image 82179 0 V 0 D 0 0
69947 240567 variant_image 82180 0 V 0 D 0 0
69948 240568 variant_image 82181 0 V 0 D 0 0
69949 240569 variant_image 82182 0 V 0 D 0 0
69950 240570 variant_image 82183 0 V 0 D 0 0
69951 240571 variant_image 82184 0 V 0 D 0 0
69952 240572 variant_image 82185 0 V 0 D 0 0
69953 240573 variant_image 82186 0 V 0 D 0 0
69954 240574 variant_image 82187 0 V 0 D 0 0
69955 240575 variant_image 82188 0 V 0 D 0 0
69956 240576 variant_image 82189 0 V 0 D 0 0
69961 240581 variant_image 82194 0 V 0 D 0 0
70189 240722 variant_image 82422 0 V 0 D 0 0
70190 240723 variant_image 82423 0 V 0 D 0 0
70983 241448 variant_image 83216 0 V 0 D 0 0
70984 241449 variant_image 83217 0 V 0 D 0 0
70985 241450 variant_image 83218 0 V 0 D 0 0
70986 241451 variant_image 83219 0 V 0 D 0 0
70987 241452 variant_image 83220 0 V 0 D 0 0
72502 242893 variant_image 84735 0 V 0 D 0 0
72503 242894 variant_image 84736 0 V 0 D 0 0
72504 242895 variant_image 84737 0 V 0 D 0 0
72505 242896 variant_image 84738 0 V 0 D 0 0
72506 242897 variant_image 84739 0 V 0 D 0 0
72507 242898 variant_image 84740 0 V 0 D 0 0
72508 242899 variant_image 84741 0 V 0 D 0 0
72509 242900 variant_image 84742 0 V 0 D 0 0
72510 242901 variant_image 84743 0 V 0 D 0 0
72511 242902 variant_image 84744 0 V 0 D 0 0
72641 242997 variant_image 84874 0 V 0 D 0 0
75265 245349 variant_image 87498 0 V 0 D 0 0
75266 245350 variant_image 87499 0 V 0 D 0 0
75267 245351 variant_image 87500 0 V 0 D 0 0
75268 245352 variant_image 87501 0 V 0 D 0 0