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, 
    232387, 
    244590, 
    244591, 
    244592, 
    244593, 
    244594, 
    244595, 
    244596, 
    244597, 
    232357, 
    232358, 
    232359, 
    232360, 
    232361, 
    232362, 
    237026, 
    237027, 
    232363, 
    245142, 
    241146, 
    232364, 
    232365, 
    232366, 
    232367, 
    232368, 
    241147, 
    232369, 
    232370, 
    232371, 
    232372, 
    232373, 
    232374, 
    232375, 
    232376, 
    241148, 
    232377, 
    241149, 
    232378, 
    232379, 
    245143, 
    245144, 
    232388, 
    232380, 
    232381, 
    245145, 
    241150, 
    232382, 
    232383, 
    232384, 
    232385, 
    232386, 
    232408, 
    232400, 
    232401, 
    232402, 
    232419, 
    232411, 
    232412, 
    232413, 
    232430, 
    232422, 
    232423, 
    232424, 
    232459, 
    232433, 
    232434, 
    232435, 
    232436, 
    232437, 
    232438, 
    240467, 
    240468, 
    232439, 
    245146, 
    241151, 
    232440, 
    232441, 
    232442, 
    232443, 
    232444, 
    241152, 
    232445, 
    232446, 
    232447, 
    232448, 
    232449, 
    232450, 
    232451, 
    232452, 
    241153, 
    232453, 
    241154, 
    232454, 
    232455, 
    245147, 
    245148, 
    232456, 
    232457, 
    232458, 
    245149, 
    241155, 
    232472, 
    244606, 
    244607, 
    244608, 
    244609, 
    244610, 
    244611, 
    244612, 
    244613, 
    232987, 
    232988, 
    232989, 
    232997, 
    232994, 
    232995, 
    232998, 
    232999, 
    233000, 
    233007, 
    233005, 
    233006, 
    233053, 
    233051, 
    233052, 
    233054, 
    233055, 
    233056, 
    233060, 
    233061, 
    233062, 
    234804, 
    234801, 
    234802, 
    234803, 
    235845, 
    235831, 
    244598, 
    244599, 
    244600, 
    244601, 
    244602, 
    244603, 
    244604, 
    244605, 
    235876, 
    235846, 
    235847, 
    235848, 
    235849, 
    235850, 
    235852, 
    237028, 
    237029, 
    235853, 
    241802, 
    235854, 
    235855, 
    235856, 
    235857, 
    235858, 
    241803, 
    235859, 
    235860, 
    235861, 
    235862, 
    235863, 
    235864, 
    235865, 
    235866, 
    241804, 
    235867, 
    241805, 
    235868, 
    235869, 
    240510, 
    235870, 
    241806, 
    235939, 
    235908, 
    235909, 
    235910, 
    235911, 
    235912, 
    235913, 
    235915, 
    237030, 
    237031, 
    235916, 
    241797, 
    235917, 
    235918, 
    235919, 
    235920, 
    235921, 
    241798, 
    235922, 
    235923, 
    235924, 
    235925, 
    235926, 
    235927, 
    235928, 
    235929, 
    241799, 
    235930, 
    241800, 
    235931, 
    235932, 
    240511, 
    235933, 
    241801, 
    235954, 
    244622, 
    244623, 
    244624, 
    244625, 
    244626, 
    244627, 
    244628, 
    244629, 
    235980, 
    235955, 
    235956, 
    235957, 
    235958, 
    235959, 
    235961, 
    237034, 
    237035, 
    235962, 
    241807, 
    235963, 
    235964, 
    235965, 
    235966, 
    235967, 
    241808, 
    235968, 
    235969, 
    235970, 
    235971, 
    235972, 
    235973, 
    235974, 
    235975, 
    241809, 
    235976, 
    241810, 
    235977, 
    235978, 
    240512, 
    235979, 
    241811, 
    237344, 
    237342, 
    237343
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00355

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": 267,
          "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,232387,244590,244591,244592,244593,244594,244595,244596,244597,232357,232358,232359,232360,232361,232362,237026,237027,232363,245142,241146,232364,232365,232366,232367,232368,241147,232369,232370,232371,232372,232373,232374,232375,232376,241148,232377,241149,232378,232379,245143,245144,232388,232380,232381,245145,241150,232382,232383,232384,232385,232386,232408,232400,232401,232402,232419,232411,232412,232413,232430,232422,232423,232424,232459,232433,232434,232435,232436,232437,232438,240467,240468,232439,245146,241151,232440,232441,232442,232443,232444,241152,232445,232446,232447,232448,232449,232450,232451,232452,241153,232453,241154,232454,232455,245147,245148,232456,232457,232458,245149,241155,232472,244606,244607,244608,244609,244610,244611,244612,244613,232987,232988,232989,232997,232994,232995,232998,232999,233000,233007,233005,233006,233053,233051,233052,233054,233055,233056,233060,233061,233062,234804,234801,234802,234803,235845,235831,244598,244599,244600,244601,244602,244603,244604,244605,235876,235846,235847,235848,235849,235850,235852,237028,237029,235853,241802,235854,235855,235856,235857,235858,241803,235859,235860,235861,235862,235863,235864,235865,235866,241804,235867,241805,235868,235869,240510,235870,241806,235939,235908,235909,235910,235911,235912,235913,235915,237030,237031,235916,241797,235917,235918,235919,235920,235921,241798,235922,235923,235924,235925,235926,235927,235928,235929,241799,235930,241800,235931,235932,240511,235933,241801,235954,244622,244623,244624,244625,244626,244627,244628,244629,235980,235955,235956,235957,235958,235959,235961,237034,237035,235962,241807,235963,235964,235965,235966,235967,241808,235968,235969,235970,235971,235972,235973,235974,235975,241809,235976,241810,235977,235978,240512,235979,241811,237344,237342,237343)"
        }
      }
    },
    "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
52749 232357 variant_image 64982 0 V 0 D 0 0
52750 232358 variant_image 64983 0 V 0 D 0 0
52751 232359 variant_image 64984 0 V 0 D 0 0
52752 232360 variant_image 64985 0 V 0 D 0 0
52753 232361 variant_image 64986 0 V 0 D 0 0
52754 232362 variant_image 64987 0 V 0 D 0 0
52755 232363 variant_image 64988 0 V 0 D 0 0
52756 232364 variant_image 64989 0 V 0 D 0 0
52757 232365 variant_image 64990 0 V 0 D 0 0
52758 232366 variant_image 64991 0 V 0 D 0 0
52759 232367 variant_image 64992 0 V 0 D 0 0
52760 232368 variant_image 64993 0 V 0 D 0 0
52761 232369 variant_image 64994 0 V 0 D 0 0
52762 232370 variant_image 64995 0 V 0 D 0 0
52763 232371 variant_image 64996 0 V 0 D 0 0
52764 232372 variant_image 64997 0 V 0 D 0 0
52765 232373 variant_image 64998 0 V 0 D 0 0
52766 232374 variant_image 64999 0 V 0 D 0 0
52767 232375 variant_image 65000 0 V 0 D 0 0
52768 232376 variant_image 65001 0 V 0 D 0 0
52769 232377 variant_image 65002 0 V 0 D 0 0
52770 232378 variant_image 65003 0 V 0 D 0 0
52771 232379 variant_image 65004 0 V 0 D 0 0
52772 232380 variant_image 65005 0 V 0 D 0 0
52773 232381 variant_image 65006 0 V 0 D 0 0
52774 232382 variant_image 65007 0 V 0 D 0 0
52775 232383 variant_image 65008 0 V 0 D 0 0
52776 232384 variant_image 65009 0 V 0 D 0 0
52777 232385 variant_image 65010 0 V 0 D 0 0
52778 232386 variant_image 65011 0 V 0 D 0 0
52779 232388 variant_image 65012 0 V 0 D 0 0
52789 232400 variant_image 65022 0 V 0 D 0 0
52790 232401 variant_image 65023 0 V 0 D 0 0
52791 232402 variant_image 65024 0 V 0 D 0 0
52799 232411 variant_image 65032 0 V 0 D 0 0
52800 232412 variant_image 65033 0 V 0 D 0 0
52801 232413 variant_image 65034 0 V 0 D 0 0
52809 232422 variant_image 65042 0 V 0 D 0 0
52810 232423 variant_image 65043 0 V 0 D 0 0
52811 232424 variant_image 65044 0 V 0 D 0 0
52819 232433 variant_image 65052 0 V 0 D 0 0
52820 232434 variant_image 65053 0 V 0 D 0 0
52821 232435 variant_image 65054 0 V 0 D 0 0
52822 232436 variant_image 65055 0 V 0 D 0 0
52823 232437 variant_image 65056 0 V 0 D 0 0
52824 232438 variant_image 65057 0 V 0 D 0 0
52825 232439 variant_image 65058 0 V 0 D 0 0
52826 232440 variant_image 65059 0 V 0 D 0 0
52827 232441 variant_image 65060 0 V 0 D 0 0
52828 232442 variant_image 65061 0 V 0 D 0 0
52829 232443 variant_image 65062 0 V 0 D 0 0
52830 232444 variant_image 65063 0 V 0 D 0 0
52831 232445 variant_image 65064 0 V 0 D 0 0
52832 232446 variant_image 65065 0 V 0 D 0 0
52833 232447 variant_image 65066 0 V 0 D 0 0
52834 232448 variant_image 65067 0 V 0 D 0 0
52835 232449 variant_image 65068 0 V 0 D 0 0
52836 232450 variant_image 65069 0 V 0 D 0 0
52837 232451 variant_image 65070 0 V 0 D 0 0
52838 232452 variant_image 65071 0 V 0 D 0 0
52839 232453 variant_image 65072 0 V 0 D 0 0
52840 232454 variant_image 65073 0 V 0 D 0 0
52841 232455 variant_image 65074 0 V 0 D 0 0
52842 232456 variant_image 65075 0 V 0 D 0 0
52843 232457 variant_image 65076 0 V 0 D 0 0
52844 232458 variant_image 65077 0 V 0 D 0 0
53375 232988 variant_image 65608 0 V 0 D 0 0
53376 232989 variant_image 65609 0 V 0 D 0 0
53380 232994 variant_image 65613 0 V 0 D 0 0
53381 232995 variant_image 65614 0 V 0 D 0 0
53383 232999 variant_image 65616 0 V 0 D 0 0
53384 233000 variant_image 65617 0 V 0 D 0 0
53388 233005 variant_image 65621 0 V 0 D 0 0
53389 233006 variant_image 65622 0 V 0 D 0 0
53434 233051 variant_image 65667 0 V 0 D 0 0
53435 233052 variant_image 65668 0 V 0 D 0 0
53436 233055 variant_image 65669 0 V 0 D 0 0
53437 233056 variant_image 65670 0 V 0 D 0 0
53440 233061 variant_image 65673 0 V 0 D 0 0
53441 233062 variant_image 65674 0 V 0 D 0 0
55815 234801 variant_image 68048 0 V 0 D 0 0
55816 234802 variant_image 68049 0 V 0 D 0 0
55817 234803 variant_image 68050 0 V 0 D 0 0
57732 235846 variant_image 69965 0 V 0 D 0 0
57733 235847 variant_image 69966 0 V 0 D 0 0
57734 235848 variant_image 69967 0 V 0 D 0 0
57735 235849 variant_image 69968 0 V 0 D 0 0
57736 235850 variant_image 69969 0 V 0 D 0 0
57738 235852 variant_image 69971 0 V 0 D 0 0
57739 235853 variant_image 69972 0 V 0 D 0 0
57740 235854 variant_image 69973 0 V 0 D 0 0
57741 235855 variant_image 69974 0 V 0 D 0 0
57742 235856 variant_image 69975 0 V 0 D 0 0
57743 235857 variant_image 69976 0 V 0 D 0 0
57744 235858 variant_image 69977 0 V 0 D 0 0
57745 235859 variant_image 69978 0 V 0 D 0 0
57746 235860 variant_image 69979 0 V 0 D 0 0
57747 235861 variant_image 69980 0 V 0 D 0 0
57748 235862 variant_image 69981 0 V 0 D 0 0
57749 235863 variant_image 69982 0 V 0 D 0 0
57750 235864 variant_image 69983 0 V 0 D 0 0
57751 235865 variant_image 69984 0 V 0 D 0 0
57752 235866 variant_image 69985 0 V 0 D 0 0
57753 235867 variant_image 69986 0 V 0 D 0 0
57754 235868 variant_image 69987 0 V 0 D 0 0
57755 235869 variant_image 69988 0 V 0 D 0 0
57756 235870 variant_image 69989 0 V 0 D 0 0
57835 235955 variant_image 70068 0 V 0 D 0 0
57836 235956 variant_image 70069 0 V 0 D 0 0
57837 235957 variant_image 70070 0 V 0 D 0 0
57838 235958 variant_image 70071 0 V 0 D 0 0
57839 235959 variant_image 70072 0 V 0 D 0 0
57841 235961 variant_image 70074 0 V 0 D 0 0
57842 235962 variant_image 70075 0 V 0 D 0 0
57843 235963 variant_image 70076 0 V 0 D 0 0
57844 235964 variant_image 70077 0 V 0 D 0 0
57845 235965 variant_image 70078 0 V 0 D 0 0
57846 235966 variant_image 70079 0 V 0 D 0 0
57847 235967 variant_image 70080 0 V 0 D 0 0
57848 235968 variant_image 70081 0 V 0 D 0 0
57849 235969 variant_image 70082 0 V 0 D 0 0
57850 235970 variant_image 70083 0 V 0 D 0 0
57851 235971 variant_image 70084 0 V 0 D 0 0
57852 235972 variant_image 70085 0 V 0 D 0 0
57853 235973 variant_image 70086 0 V 0 D 0 0
57854 235974 variant_image 70087 0 V 0 D 0 0
57855 235975 variant_image 70088 0 V 0 D 0 0
57856 235976 variant_image 70089 0 V 0 D 0 0
57857 235977 variant_image 70090 0 V 0 D 0 0
57858 235978 variant_image 70091 0 V 0 D 0 0
57859 235979 variant_image 70092 0 V 0 D 0 0
59770 237026 variant_image 72003 0 V 0 D 0 0
59771 237027 variant_image 72004 0 V 0 D 0 0
59772 237028 variant_image 72005 0 V 0 D 0 0
59773 237029 variant_image 72006 0 V 0 D 0 0
59780 237034 variant_image 72013 0 V 0 D 0 0
59781 237035 variant_image 72014 0 V 0 D 0 0
60376 237342 variant_image 72609 0 V 0 D 0 0
60377 237343 variant_image 72610 0 V 0 D 0 0
69489 240467 variant_image 81722 0 V 0 D 0 0
69490 240468 variant_image 81723 0 V 0 D 0 0
69591 240510 variant_image 81824 0 V 0 D 0 0
69593 240512 variant_image 81826 0 V 0 D 0 0
70681 241146 variant_image 82914 0 V 0 D 0 0
70682 241147 variant_image 82915 0 V 0 D 0 0
70683 241148 variant_image 82916 0 V 0 D 0 0
70684 241149 variant_image 82917 0 V 0 D 0 0
70685 241150 variant_image 82918 0 V 0 D 0 0
70686 241151 variant_image 82919 0 V 0 D 0 0
70687 241152 variant_image 82920 0 V 0 D 0 0
70688 241153 variant_image 82921 0 V 0 D 0 0
70689 241154 variant_image 82922 0 V 0 D 0 0
70690 241155 variant_image 82923 0 V 0 D 0 0
71355 241802 variant_image 83588 0 V 0 D 0 0
71356 241803 variant_image 83589 0 V 0 D 0 0
71357 241804 variant_image 83590 0 V 0 D 0 0
71358 241805 variant_image 83591 0 V 0 D 0 0
71359 241806 variant_image 83592 0 V 0 D 0 0
71360 241807 variant_image 83593 0 V 0 D 0 0
71361 241808 variant_image 83594 0 V 0 D 0 0
71362 241809 variant_image 83595 0 V 0 D 0 0
71363 241810 variant_image 83596 0 V 0 D 0 0
71364 241811 variant_image 83597 0 V 0 D 0 0
74382 244590 variant_image 86615 0 V 0 D 0 0
74383 244591 variant_image 86616 0 V 0 D 0 0
74384 244592 variant_image 86617 0 V 0 D 0 0
74385 244593 variant_image 86618 0 V 0 D 0 0
74386 244594 variant_image 86619 0 V 0 D 0 0
74387 244595 variant_image 86620 0 V 0 D 0 0
74388 244596 variant_image 86621 0 V 0 D 0 0
74389 244597 variant_image 86622 0 V 0 D 0 0
74390 244598 variant_image 86623 0 V 0 D 0 0
74391 244599 variant_image 86624 0 V 0 D 0 0
74392 244600 variant_image 86625 0 V 0 D 0 0
74393 244601 variant_image 86626 0 V 0 D 0 0
74394 244602 variant_image 86627 0 V 0 D 0 0
74395 244603 variant_image 86628 0 V 0 D 0 0
74396 244604 variant_image 86629 0 V 0 D 0 0
74397 244605 variant_image 86630 0 V 0 D 0 0
74398 244606 variant_image 86631 0 V 0 D 0 0
74399 244607 variant_image 86632 0 V 0 D 0 0
74400 244608 variant_image 86633 0 V 0 D 0 0
74401 244609 variant_image 86634 0 V 0 D 0 0
74402 244610 variant_image 86635 0 V 0 D 0 0
74403 244611 variant_image 86636 0 V 0 D 0 0
74404 244612 variant_image 86637 0 V 0 D 0 0
74405 244613 variant_image 86638 0 V 0 D 0 0
74414 244622 variant_image 86647 0 V 0 D 0 0
74415 244623 variant_image 86648 0 V 0 D 0 0
74416 244624 variant_image 86649 0 V 0 D 0 0
74417 244625 variant_image 86650 0 V 0 D 0 0
74418 244626 variant_image 86651 0 V 0 D 0 0
74419 244627 variant_image 86652 0 V 0 D 0 0
74420 244628 variant_image 86653 0 V 0 D 0 0
74421 244629 variant_image 86654 0 V 0 D 0 0
74945 245142 variant_image 87178 0 V 0 D 0 0
74946 245143 variant_image 87179 0 V 0 D 0 0
74947 245144 variant_image 87180 0 V 0 D 0 0
74948 245145 variant_image 87181 0 V 0 D 0 0
74949 245146 variant_image 87182 0 V 0 D 0 0
74950 245147 variant_image 87183 0 V 0 D 0 0
74951 245148 variant_image 87184 0 V 0 D 0 0
74952 245149 variant_image 87185 0 V 0 D 0 0