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 (
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    230828, 
    230827, 
    232268, 
    232269, 
    232270, 
    232807, 
    244702, 
    244703, 
    244704, 
    244705, 
    244706, 
    244707, 
    244708, 
    244709, 
    232777, 
    232778, 
    232779, 
    232780, 
    232781, 
    232782, 
    237008, 
    237009, 
    232783, 
    245244, 
    241290, 
    232784, 
    232785, 
    232786, 
    232787, 
    232788, 
    241291, 
    232789, 
    232790, 
    232791, 
    232792, 
    232793, 
    232794, 
    232795, 
    232796, 
    241292, 
    232797, 
    241293, 
    232798, 
    232799, 
    245245, 
    245246, 
    232808, 
    232800, 
    232801, 
    245247, 
    241294, 
    232802, 
    232803, 
    232804, 
    232805, 
    232806, 
    232817, 
    232809, 
    232810, 
    232811, 
    232828, 
    232820, 
    232821, 
    232822, 
    232839, 
    232831, 
    232832, 
    232833, 
    232908, 
    232882, 
    232883, 
    232884, 
    232885, 
    232886, 
    232887, 
    237016, 
    237017, 
    232888, 
    245248, 
    241295, 
    232889, 
    232890, 
    232891, 
    232892, 
    232893, 
    241296, 
    232894, 
    232895, 
    232896, 
    232897, 
    232898, 
    232899, 
    232900, 
    232901, 
    241297, 
    232902, 
    241298, 
    232903, 
    232904, 
    245249, 
    245250, 
    232905, 
    232906, 
    232907, 
    245251, 
    241299, 
    232921, 
    244710, 
    244711, 
    244712, 
    244713, 
    244714, 
    244715, 
    244716, 
    244717, 
    232986, 
    232984, 
    232985, 
    234819, 
    234816, 
    234817, 
    234818, 
    236103, 
    236089, 
    244894, 
    244895, 
    244896, 
    244897, 
    244898, 
    244899, 
    244900, 
    244901, 
    236129, 
    236104, 
    236105, 
    236106, 
    236107, 
    236108, 
    236110, 
    237010, 
    237011, 
    236111, 
    241665, 
    236112, 
    236113, 
    236114, 
    236115, 
    236116, 
    241666, 
    236117, 
    236118, 
    236119, 
    236120, 
    236121, 
    236122, 
    236123, 
    236124, 
    241667, 
    236125, 
    241668, 
    236126, 
    236127, 
    241823, 
    236128, 
    241669, 
    236156, 
    236130, 
    236131, 
    236132, 
    236133, 
    236134, 
    236135, 
    236137, 
    237012, 
    237013, 
    236138, 
    241670, 
    236139, 
    236140, 
    236141, 
    236142, 
    236143, 
    241671, 
    236144, 
    236145, 
    236146, 
    236147, 
    236148, 
    236149, 
    236150, 
    236151, 
    241672, 
    236152, 
    241673, 
    236153, 
    236154, 
    241824, 
    236155, 
    241674, 
    236170, 
    244966, 
    244967, 
    244968, 
    244969, 
    244970, 
    244971, 
    244972, 
    244973, 
    236196, 
    236171, 
    236172, 
    236173, 
    236174, 
    236175, 
    236177, 
    237014, 
    237015, 
    236178, 
    241825, 
    236179, 
    236180, 
    236181, 
    236182, 
    236183, 
    241826, 
    236184, 
    236185, 
    236186, 
    236187, 
    236188, 
    236189, 
    236190, 
    236191, 
    241827, 
    236192, 
    241828, 
    236193, 
    236194, 
    241830, 
    236195, 
    241829
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00248

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": 246,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (223755,223756,223757,223758,223759,230828,230827,232268,232269,232270,232807,244702,244703,244704,244705,244706,244707,244708,244709,232777,232778,232779,232780,232781,232782,237008,237009,232783,245244,241290,232784,232785,232786,232787,232788,241291,232789,232790,232791,232792,232793,232794,232795,232796,241292,232797,241293,232798,232799,245245,245246,232808,232800,232801,245247,241294,232802,232803,232804,232805,232806,232817,232809,232810,232811,232828,232820,232821,232822,232839,232831,232832,232833,232908,232882,232883,232884,232885,232886,232887,237016,237017,232888,245248,241295,232889,232890,232891,232892,232893,241296,232894,232895,232896,232897,232898,232899,232900,232901,241297,232902,241298,232903,232904,245249,245250,232905,232906,232907,245251,241299,232921,244710,244711,244712,244713,244714,244715,244716,244717,232986,232984,232985,234819,234816,234817,234818,236103,236089,244894,244895,244896,244897,244898,244899,244900,244901,236129,236104,236105,236106,236107,236108,236110,237010,237011,236111,241665,236112,236113,236114,236115,236116,241666,236117,236118,236119,236120,236121,236122,236123,236124,241667,236125,241668,236126,236127,241823,236128,241669,236156,236130,236131,236132,236133,236134,236135,236137,237012,237013,236138,241670,236139,236140,236141,236142,236143,241671,236144,236145,236146,236147,236148,236149,236150,236151,241672,236152,241673,236153,236154,241824,236155,241674,236170,244966,244967,244968,244969,244970,244971,244972,244973,236196,236171,236172,236173,236174,236175,236177,237014,237015,236178,241825,236179,236180,236181,236182,236183,241826,236184,236185,236186,236187,236188,236189,236190,236191,241827,236192,241828,236193,236194,241830,236195,241829)"
        }
      }
    },
    "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
42039 223756 variant_image 54272 0 V 0 D 0 0
42040 223757 variant_image 54273 0 V 0 D 0 0
42041 223758 variant_image 54274 0 V 0 D 0 0
42042 223759 variant_image 54275 0 V 0 D 0 0
53168 232777 variant_image 65401 0 V 0 D 0 0
53169 232778 variant_image 65402 0 V 0 D 0 0
53170 232779 variant_image 65403 0 V 0 D 0 0
53171 232780 variant_image 65404 0 V 0 D 0 0
53172 232781 variant_image 65405 0 V 0 D 0 0
53173 232782 variant_image 65406 0 V 0 D 0 0
53174 232783 variant_image 65407 0 V 0 D 0 0
53175 232784 variant_image 65408 0 V 0 D 0 0
53176 232785 variant_image 65409 0 V 0 D 0 0
53177 232786 variant_image 65410 0 V 0 D 0 0
53178 232787 variant_image 65411 0 V 0 D 0 0
53179 232788 variant_image 65412 0 V 0 D 0 0
53180 232789 variant_image 65413 0 V 0 D 0 0
53181 232790 variant_image 65414 0 V 0 D 0 0
53182 232791 variant_image 65415 0 V 0 D 0 0
53183 232792 variant_image 65416 0 V 0 D 0 0
53184 232793 variant_image 65417 0 V 0 D 0 0
53185 232794 variant_image 65418 0 V 0 D 0 0
53186 232795 variant_image 65419 0 V 0 D 0 0
53187 232796 variant_image 65420 0 V 0 D 0 0
53188 232797 variant_image 65421 0 V 0 D 0 0
53189 232798 variant_image 65422 0 V 0 D 0 0
53190 232799 variant_image 65423 0 V 0 D 0 0
53191 232800 variant_image 65424 0 V 0 D 0 0
53192 232801 variant_image 65425 0 V 0 D 0 0
53193 232802 variant_image 65426 0 V 0 D 0 0
53194 232803 variant_image 65427 0 V 0 D 0 0
53195 232804 variant_image 65428 0 V 0 D 0 0
53196 232805 variant_image 65429 0 V 0 D 0 0
53197 232806 variant_image 65430 0 V 0 D 0 0
53198 232808 variant_image 65431 0 V 0 D 0 0
53199 232809 variant_image 65432 0 V 0 D 0 0
53200 232810 variant_image 65433 0 V 0 D 0 0
53201 232811 variant_image 65434 0 V 0 D 0 0
53209 232820 variant_image 65442 0 V 0 D 0 0
53210 232821 variant_image 65443 0 V 0 D 0 0
53211 232822 variant_image 65444 0 V 0 D 0 0
53219 232831 variant_image 65452 0 V 0 D 0 0
53220 232832 variant_image 65453 0 V 0 D 0 0
53221 232833 variant_image 65454 0 V 0 D 0 0
53267 232882 variant_image 65500 0 V 0 D 0 0
53268 232883 variant_image 65501 0 V 0 D 0 0
53269 232884 variant_image 65502 0 V 0 D 0 0
53270 232885 variant_image 65503 0 V 0 D 0 0
53271 232886 variant_image 65504 0 V 0 D 0 0
53272 232887 variant_image 65505 0 V 0 D 0 0
53273 232888 variant_image 65506 0 V 0 D 0 0
53274 232889 variant_image 65507 0 V 0 D 0 0
53275 232890 variant_image 65508 0 V 0 D 0 0
53276 232891 variant_image 65509 0 V 0 D 0 0
53277 232892 variant_image 65510 0 V 0 D 0 0
53278 232893 variant_image 65511 0 V 0 D 0 0
53279 232894 variant_image 65512 0 V 0 D 0 0
53280 232895 variant_image 65513 0 V 0 D 0 0
53281 232896 variant_image 65514 0 V 0 D 0 0
53282 232897 variant_image 65515 0 V 0 D 0 0
53283 232898 variant_image 65516 0 V 0 D 0 0
53284 232899 variant_image 65517 0 V 0 D 0 0
53285 232900 variant_image 65518 0 V 0 D 0 0
53286 232901 variant_image 65519 0 V 0 D 0 0
53287 232902 variant_image 65520 0 V 0 D 0 0
53288 232903 variant_image 65521 0 V 0 D 0 0
53289 232904 variant_image 65522 0 V 0 D 0 0
53290 232905 variant_image 65523 0 V 0 D 0 0
53291 232906 variant_image 65524 0 V 0 D 0 0
53292 232907 variant_image 65525 0 V 0 D 0 0
53370 232984 variant_image 65603 0 V 0 D 0 0
53371 232985 variant_image 65604 0 V 0 D 0 0
55827 234816 variant_image 68060 0 V 0 D 0 0
55828 234817 variant_image 68061 0 V 0 D 0 0
55829 234818 variant_image 68062 0 V 0 D 0 0
57974 236104 variant_image 70207 0 V 0 D 0 0
57975 236105 variant_image 70208 0 V 0 D 0 0
57976 236106 variant_image 70209 0 V 0 D 0 0
57977 236107 variant_image 70210 0 V 0 D 0 0
57978 236108 variant_image 70211 0 V 0 D 0 0
57980 236110 variant_image 70213 0 V 0 D 0 0
57981 236111 variant_image 70214 0 V 0 D 0 0
57982 236112 variant_image 70215 0 V 0 D 0 0
57983 236113 variant_image 70216 0 V 0 D 0 0
57984 236114 variant_image 70217 0 V 0 D 0 0
57985 236115 variant_image 70218 0 V 0 D 0 0
57986 236116 variant_image 70219 0 V 0 D 0 0
57987 236117 variant_image 70220 0 V 0 D 0 0
57988 236118 variant_image 70221 0 V 0 D 0 0
57989 236119 variant_image 70222 0 V 0 D 0 0
57990 236120 variant_image 70223 0 V 0 D 0 0
57991 236121 variant_image 70224 0 V 0 D 0 0
57992 236122 variant_image 70225 0 V 0 D 0 0
57993 236123 variant_image 70226 0 V 0 D 0 0
57994 236124 variant_image 70227 0 V 0 D 0 0
57995 236125 variant_image 70228 0 V 0 D 0 0
57996 236126 variant_image 70229 0 V 0 D 0 0
57997 236127 variant_image 70230 0 V 0 D 0 0
57998 236128 variant_image 70231 0 V 0 D 0 0
57999 236131 variant_image 70232 0 V 0 D 0 0
58000 236132 variant_image 70233 0 V 0 D 0 0
58001 236133 variant_image 70234 0 V 0 D 0 0
58002 236134 variant_image 70235 0 V 0 D 0 0
58003 236135 variant_image 70236 0 V 0 D 0 0
58005 236137 variant_image 70238 0 V 0 D 0 0
58006 236138 variant_image 70239 0 V 0 D 0 0
58007 236139 variant_image 70240 0 V 0 D 0 0
58008 236140 variant_image 70241 0 V 0 D 0 0
58009 236141 variant_image 70242 0 V 0 D 0 0
58010 236142 variant_image 70243 0 V 0 D 0 0
58011 236143 variant_image 70244 0 V 0 D 0 0
58012 236144 variant_image 70245 0 V 0 D 0 0
58013 236145 variant_image 70246 0 V 0 D 0 0
58014 236146 variant_image 70247 0 V 0 D 0 0
58015 236147 variant_image 70248 0 V 0 D 0 0
58016 236148 variant_image 70249 0 V 0 D 0 0
58017 236149 variant_image 70250 0 V 0 D 0 0
58018 236150 variant_image 70251 0 V 0 D 0 0
58019 236151 variant_image 70252 0 V 0 D 0 0
58020 236152 variant_image 70253 0 V 0 D 0 0
58021 236153 variant_image 70254 0 V 0 D 0 0
58022 236154 variant_image 70255 0 V 0 D 0 0
58023 236155 variant_image 70256 0 V 0 D 0 0
58037 236171 variant_image 70270 0 V 0 D 0 0
58038 236172 variant_image 70271 0 V 0 D 0 0
58039 236173 variant_image 70272 0 V 0 D 0 0
58040 236174 variant_image 70273 0 V 0 D 0 0
58041 236175 variant_image 70274 0 V 0 D 0 0
58043 236177 variant_image 70276 0 V 0 D 0 0
58044 236178 variant_image 70277 0 V 0 D 0 0
58045 236179 variant_image 70278 0 V 0 D 0 0
58046 236180 variant_image 70279 0 V 0 D 0 0
58047 236181 variant_image 70280 0 V 0 D 0 0
58048 236182 variant_image 70281 0 V 0 D 0 0
58049 236183 variant_image 70282 0 V 0 D 0 0
58050 236184 variant_image 70283 0 V 0 D 0 0
58051 236185 variant_image 70284 0 V 0 D 0 0
58052 236186 variant_image 70285 0 V 0 D 0 0
58053 236187 variant_image 70286 0 V 0 D 0 0
58054 236188 variant_image 70287 0 V 0 D 0 0
58055 236189 variant_image 70288 0 V 0 D 0 0
58056 236190 variant_image 70289 0 V 0 D 0 0
58057 236191 variant_image 70290 0 V 0 D 0 0
58058 236192 variant_image 70291 0 V 0 D 0 0
58059 236193 variant_image 70292 0 V 0 D 0 0
58060 236194 variant_image 70293 0 V 0 D 0 0
58061 236195 variant_image 70294 0 V 0 D 0 0
59752 237008 variant_image 71985 0 V 0 D 0 0
59753 237009 variant_image 71986 0 V 0 D 0 0
59754 237010 variant_image 71987 0 V 0 D 0 0
59755 237011 variant_image 71988 0 V 0 D 0 0
59756 237012 variant_image 71989 0 V 0 D 0 0
59757 237013 variant_image 71990 0 V 0 D 0 0
59758 237014 variant_image 71991 0 V 0 D 0 0
59759 237015 variant_image 71992 0 V 0 D 0 0
59760 237016 variant_image 71993 0 V 0 D 0 0
59761 237017 variant_image 71994 0 V 0 D 0 0
70825 241290 variant_image 83058 0 V 0 D 0 0
70826 241291 variant_image 83059 0 V 0 D 0 0
70827 241292 variant_image 83060 0 V 0 D 0 0
70828 241293 variant_image 83061 0 V 0 D 0 0
70829 241294 variant_image 83062 0 V 0 D 0 0
70830 241295 variant_image 83063 0 V 0 D 0 0
70831 241296 variant_image 83064 0 V 0 D 0 0
70832 241297 variant_image 83065 0 V 0 D 0 0
70833 241298 variant_image 83066 0 V 0 D 0 0
70834 241299 variant_image 83067 0 V 0 D 0 0
71219 241665 variant_image 83452 0 V 0 D 0 0
71220 241666 variant_image 83453 0 V 0 D 0 0
71221 241667 variant_image 83454 0 V 0 D 0 0
71222 241668 variant_image 83455 0 V 0 D 0 0
71223 241669 variant_image 83456 0 V 0 D 0 0
71224 241670 variant_image 83457 0 V 0 D 0 0
71225 241671 variant_image 83458 0 V 0 D 0 0
71226 241672 variant_image 83459 0 V 0 D 0 0
71227 241673 variant_image 83460 0 V 0 D 0 0
71228 241674 variant_image 83461 0 V 0 D 0 0
71376 241823 variant_image 83609 0 V 0 D 0 0
71377 241824 variant_image 83610 0 V 0 D 0 0
71378 241825 variant_image 83611 0 V 0 D 0 0
71379 241826 variant_image 83612 0 V 0 D 0 0
71380 241827 variant_image 83613 0 V 0 D 0 0
71381 241828 variant_image 83614 0 V 0 D 0 0
71382 241829 variant_image 83615 0 V 0 D 0 0
71383 241830 variant_image 83616 0 V 0 D 0 0
74494 244702 variant_image 86727 0 V 0 D 0 0
74495 244703 variant_image 86728 0 V 0 D 0 0
74496 244704 variant_image 86729 0 V 0 D 0 0
74497 244705 variant_image 86730 0 V 0 D 0 0
74498 244706 variant_image 86731 0 V 0 D 0 0
74499 244707 variant_image 86732 0 V 0 D 0 0
74500 244708 variant_image 86733 0 V 0 D 0 0
74501 244709 variant_image 86734 0 V 0 D 0 0
74502 244710 variant_image 86735 0 V 0 D 0 0
74503 244711 variant_image 86736 0 V 0 D 0 0
74504 244712 variant_image 86737 0 V 0 D 0 0
74505 244713 variant_image 86738 0 V 0 D 0 0
74506 244714 variant_image 86739 0 V 0 D 0 0
74507 244715 variant_image 86740 0 V 0 D 0 0
74508 244716 variant_image 86741 0 V 0 D 0 0
74509 244717 variant_image 86742 0 V 0 D 0 0
74686 244894 variant_image 86919 0 V 0 D 0 0
74687 244895 variant_image 86920 0 V 0 D 0 0
74688 244896 variant_image 86921 0 V 0 D 0 0
74689 244897 variant_image 86922 0 V 0 D 0 0
74690 244898 variant_image 86923 0 V 0 D 0 0
74691 244899 variant_image 86924 0 V 0 D 0 0
74692 244900 variant_image 86925 0 V 0 D 0 0
74693 244901 variant_image 86926 0 V 0 D 0 0
74758 244966 variant_image 86991 0 V 0 D 0 0
74759 244967 variant_image 86992 0 V 0 D 0 0
74760 244968 variant_image 86993 0 V 0 D 0 0
74761 244969 variant_image 86994 0 V 0 D 0 0
74762 244970 variant_image 86995 0 V 0 D 0 0
74763 244971 variant_image 86996 0 V 0 D 0 0
74764 244972 variant_image 86997 0 V 0 D 0 0
74765 244973 variant_image 86998 0 V 0 D 0 0
75047 245244 variant_image 87280 0 V 0 D 0 0
75048 245245 variant_image 87281 0 V 0 D 0 0
75049 245246 variant_image 87282 0 V 0 D 0 0
75050 245247 variant_image 87283 0 V 0 D 0 0
75051 245248 variant_image 87284 0 V 0 D 0 0
75052 245249 variant_image 87285 0 V 0 D 0 0
75053 245250 variant_image 87286 0 V 0 D 0 0
75054 245251 variant_image 87287 0 V 0 D 0 0