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, 
    230951, 230952, 230953, 230954, 231948, 
    231946, 231947, 233544, 236498, 236468, 
    236469, 236470, 236471, 236493, 236486, 
    239867, 239868, 236472, 241640, 236473, 
    236474, 236475, 236476, 236477, 241641, 
    236478, 236479, 236480, 236481, 236482, 
    236483, 236484, 236485, 241642, 236487, 
    241643, 236488, 236489, 236490, 236491, 
    236492, 241644, 242852, 242853, 242854, 
    242855, 236530, 236499, 236500, 236501, 
    236502, 236503, 236504, 236505, 236506, 
    239869, 239870, 236507, 241645, 236508, 
    236509, 236510, 236511, 236512, 241646, 
    236513, 236514, 236515, 236516, 236517, 
    236518, 236519, 236520, 241647, 236521, 
    241648, 236522, 236523, 236524, 236525, 
    241649, 242856, 242857, 242858, 242859, 
    240709, 240707, 240708, 243078, 243049, 
    243050, 243051, 243052, 243072, 243053, 
    243054, 243055, 243056, 243057, 243058, 
    243059, 243060, 243061, 243062, 243063, 
    243064, 243065, 243067, 243068, 243069, 
    243070, 243071, 243073, 243074, 243075, 
    243076
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00161

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": 121,
          "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,230951,230952,230953,230954,231948,231946,231947,233544,236498,236468,236469,236470,236471,236493,236486,239867,239868,236472,241640,236473,236474,236475,236476,236477,241641,236478,236479,236480,236481,236482,236483,236484,236485,241642,236487,241643,236488,236489,236490,236491,236492,241644,242852,242853,242854,242855,236530,236499,236500,236501,236502,236503,236504,236505,236506,239869,239870,236507,241645,236508,236509,236510,236511,236512,241646,236513,236514,236515,236516,236517,236518,236519,236520,241647,236521,241648,236522,236523,236524,236525,241649,242856,242857,242858,242859,240709,240707,240708,243078,243049,243050,243051,243052,243072,243053,243054,243055,243056,243057,243058,243059,243060,243061,243062,243063,243064,243065,243067,243068,243069,243070,243071,243073,243074,243075,243076)"
        }
      }
    },
    "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
52239 231946 variant_image 64472 0 V 0 D 0 0
52240 231947 variant_image 64473 0 V 0 D 0 0
54102 233544 variant_image 66335 0 V 0 D 0 0
58573 236468 variant_image 70806 0 V 0 D 0 0
58574 236469 variant_image 70807 0 V 0 D 0 0
58575 236470 variant_image 70808 0 V 0 D 0 0
58576 236471 variant_image 70809 0 V 0 D 0 0
58577 236472 variant_image 70810 0 V 0 D 0 0
58578 236473 variant_image 70811 0 V 0 D 0 0
58579 236474 variant_image 70812 0 V 0 D 0 0
58580 236475 variant_image 70813 0 V 0 D 0 0
58581 236476 variant_image 70814 0 V 0 D 0 0
58582 236477 variant_image 70815 0 V 0 D 0 0
58583 236478 variant_image 70816 0 V 0 D 0 0
58584 236479 variant_image 70817 0 V 0 D 0 0
58585 236480 variant_image 70818 0 V 0 D 0 0
58586 236481 variant_image 70819 0 V 0 D 0 0
58587 236482 variant_image 70820 0 V 0 D 0 0
58588 236483 variant_image 70821 0 V 0 D 0 0
58589 236484 variant_image 70822 0 V 0 D 0 0
58590 236485 variant_image 70823 0 V 0 D 0 0
58591 236486 variant_image 70824 0 V 0 D 0 0
58592 236487 variant_image 70825 0 V 0 D 0 0
58593 236488 variant_image 70826 0 V 0 D 0 0
58594 236489 variant_image 70827 0 V 0 D 0 0
58595 236490 variant_image 70828 0 V 0 D 0 0
58596 236491 variant_image 70829 0 V 0 D 0 0
58597 236492 variant_image 70830 0 V 0 D 0 0
58598 236493 variant_image 70831 0 V 0 D 0 0
58603 236500 variant_image 70836 0 V 0 D 0 0
58604 236501 variant_image 70837 0 V 0 D 0 0
58605 236502 variant_image 70838 0 V 0 D 0 0
58606 236503 variant_image 70839 0 V 0 D 0 0
58607 236504 variant_image 70840 0 V 0 D 0 0
58608 236505 variant_image 70841 0 V 0 D 0 0
58609 236506 variant_image 70842 0 V 0 D 0 0
58610 236507 variant_image 70843 0 V 0 D 0 0
58611 236508 variant_image 70844 0 V 0 D 0 0
58612 236509 variant_image 70845 0 V 0 D 0 0
58613 236510 variant_image 70846 0 V 0 D 0 0
58614 236511 variant_image 70847 0 V 0 D 0 0
58615 236512 variant_image 70848 0 V 0 D 0 0
58616 236513 variant_image 70849 0 V 0 D 0 0
58617 236514 variant_image 70850 0 V 0 D 0 0
58618 236515 variant_image 70851 0 V 0 D 0 0
58619 236516 variant_image 70852 0 V 0 D 0 0
58620 236517 variant_image 70853 0 V 0 D 0 0
58621 236518 variant_image 70854 0 V 0 D 0 0
58622 236519 variant_image 70855 0 V 0 D 0 0
58623 236520 variant_image 70856 0 V 0 D 0 0
58624 236521 variant_image 70857 0 V 0 D 0 0
58625 236522 variant_image 70858 0 V 0 D 0 0
58626 236523 variant_image 70859 0 V 0 D 0 0
58627 236524 variant_image 70860 0 V 0 D 0 0
58628 236525 variant_image 70861 0 V 0 D 0 0
67865 239867 variant_image 80098 0 V 0 D 0 0
67866 239868 variant_image 80099 0 V 0 D 0 0
67867 239869 variant_image 80100 0 V 0 D 0 0
67868 239870 variant_image 80101 0 V 0 D 0 0
71194 241640 variant_image 83427 0 V 0 D 0 0
71195 241641 variant_image 83428 0 V 0 D 0 0
71196 241642 variant_image 83429 0 V 0 D 0 0
71197 241643 variant_image 83430 0 V 0 D 0 0
71198 241644 variant_image 83431 0 V 0 D 0 0
71199 241645 variant_image 83432 0 V 0 D 0 0
71200 241646 variant_image 83433 0 V 0 D 0 0
71201 241647 variant_image 83434 0 V 0 D 0 0
71202 241648 variant_image 83435 0 V 0 D 0 0
71203 241649 variant_image 83436 0 V 0 D 0 0
72461 242852 variant_image 84694 0 V 0 D 0 0
72462 242853 variant_image 84695 0 V 0 D 0 0
72463 242854 variant_image 84696 0 V 0 D 0 0
72464 242855 variant_image 84697 0 V 0 D 0 0
72465 242856 variant_image 84698 0 V 0 D 0 0
72466 242857 variant_image 84699 0 V 0 D 0 0
72467 242858 variant_image 84700 0 V 0 D 0 0
72468 242859 variant_image 84701 0 V 0 D 0 0
72751 243049 variant_image 84984 0 V 0 D 0 0
72752 243050 variant_image 84985 0 V 0 D 0 0
72753 243051 variant_image 84986 0 V 0 D 0 0
72754 243052 variant_image 84987 0 V 0 D 0 0
72755 243053 variant_image 84988 0 V 0 D 0 0
72756 243054 variant_image 84989 0 V 0 D 0 0
72757 243055 variant_image 84990 0 V 0 D 0 0
72758 243056 variant_image 84991 0 V 0 D 0 0
72759 243057 variant_image 84992 0 V 0 D 0 0
72760 243058 variant_image 84993 0 V 0 D 0 0
72761 243059 variant_image 84994 0 V 0 D 0 0
72762 243060 variant_image 84995 0 V 0 D 0 0
72763 243061 variant_image 84996 0 V 0 D 0 0
72764 243062 variant_image 84997 0 V 0 D 0 0
72765 243063 variant_image 84998 0 V 0 D 0 0
72766 243064 variant_image 84999 0 V 0 D 0 0
72767 243065 variant_image 85000 0 V 0 D 0 0
72769 243067 variant_image 85002 0 V 0 D 0 0
72770 243068 variant_image 85003 0 V 0 D 0 0
72771 243069 variant_image 85004 0 V 0 D 0 0
72772 243070 variant_image 85005 0 V 0 D 0 0
72773 243071 variant_image 85006 0 V 0 D 0 0
72774 243072 variant_image 85007 0 V 0 D 0 0
72775 243073 variant_image 85008 0 V 0 D 0 0
72776 243074 variant_image 85009 0 V 0 D 0 0
72777 243075 variant_image 85010 0 V 0 D 0 0
72778 243076 variant_image 85011 0 V 0 D 0 0