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.image_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 = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    58884, 62123, 29986, 60914, 29983, 29992, 
    29989, 63034, 62012, 61430, 62240, 
    63755, 62259, 61340, 61337, 62252, 
    61336, 62253, 62254, 62260, 64941, 
    62258, 64942, 64943
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00165

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": 166,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (58884,62123,29986,60914,29983,29992,29989,63034,62012,61430,62240,63755,62259,61340,61337,62252,61336,62253,62254,62260,64941,62258,64942,64943)"
        }
      }
    },
    "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.image_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.image_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
13166 29992 product 0 23260 A 0 D 0 0
15670 61340 product 0 27140 A 0 C 0 0
15671 61340 product 0 27141 A 0 C 0 0
15788 60914 product 0 27275 A 0 D 0 0
16576 29986 product 0 28130 A 0 D 0 0
17852 61430 product 0 29481 A 0 D 0 0
18521 29989 product 0 30189 A 0 D 0 0
20588 61340 product 0 32415 A 0 D 0 0
20592 29989 product 0 32419 A 0 D 0 0
21035 62123 product 0 32876 A 0 D 0 0
21036 62123 product 0 32877 A 0 D 0 0
27185 63755 product 0 39362 A 0 D 0 0
32454 58884 product 0 44687 A 0 D 0 0
32455 58884 product 0 44688 A 0 D 0 0
32456 58884 product 0 44689 A 0 D 0 0
32625 63034 product 0 44858 A 0 D 0 0
39029 29986 product 0 51262 A 0 C 0 0
41732 29986 product 0 53965 A 0 D 0 0
41733 29986 product 0 53966 A 0 D 0 0
41734 29986 product 0 53967 A 0 D 0 0
41735 29986 product 0 53968 A 0 D 0 0
46053 63755 product 0 58286 A 0 D 0 0
46054 63755 product 0 58287 A 0 D 0 0
46450 61340 product 0 58683 A 0 D 0 0
46467 61336 product 0 58700 A 0 D 0 0
46901 62240 product 0 59134 A 0 D 0 0
48356 64943 product 0 60589 A 0 D 0 0
48358 64941 product 0 60591 A 0 D 0 0
48361 64942 product 0 60594 A 0 D 0 0
53862 62259 product 0 66095 A 0 D 0 0
53865 62260 product 0 66098 A 0 D 0 0
53868 62258 product 0 66101 A 0 D 0 0
53869 62258 product 0 66102 A 0 D 0 0
54187 29983 product 0 66420 A 0 D 0 0
57047 62258 product 0 69280 A 0 C 0 0
57048 62258 product 0 69281 A 0 C 0 0
57049 62258 product 0 69282 A 0 C 0 0
57050 62258 product 0 69283 A 0 C 0 0
57116 29989 product 0 69349 A 0 D 0 0
57117 29989 product 0 69350 A 0 C 0 0
57118 29989 product 0 69351 A 0 D 0 0
57119 29989 product 0 69352 A 0 D 0 0
57120 29989 product 0 69353 A 0 C 0 0
57121 29989 product 0 69354 A 0 D 0 0
57123 29989 product 0 69356 A 0 C 0 0
57124 29989 product 0 69357 A 0 C 0 0
57327 62258 product 0 69560 A 0 D 0 0
58778 29983 product 0 71011 A 0 D 0 0
58779 29983 product 0 71012 A 0 D 0 0
60872 63755 product 0 73105 A 0 D 0 0
60873 63755 product 0 73106 A 0 D 0 0
60874 63755 product 0 73107 A 0 D 0 0
60875 63755 product 0 73108 A 0 D 0 0
60880 64943 product 0 73113 A 0 D 0 0
60881 64943 product 0 73114 A 0 D 0 0
60882 64943 product 0 73115 A 0 D 0 0
60883 64943 product 0 73116 A 0 D 0 0
60884 64941 product 0 73117 A 0 D 0 0
60885 64941 product 0 73118 A 0 D 0 0
60886 64941 product 0 73119 A 0 D 0 0
60887 64941 product 0 73120 A 0 D 0 0
63132 62012 product 0 75365 A 0 D 0 0
65386 61337 product 0 77619 A 0 C 0 0
16153 61430 product 0 27673 A 1 D 0 0
20856 62240 product 0 32692 A 1 D 0 0
23835 63034 product 0 35766 A 1 D 0 0
39030 29986 product 0 51263 A 1 C 0 0
40983 60914 product 0 53216 A 1 D 0 0
46468 61336 product 0 58701 A 1 D 0 0
53863 62259 product 0 66096 A 1 D 0 0
53866 62260 product 0 66099 A 1 D 0 0
59586 62240 product 0 71819 A 1 D 0 0
60876 64942 product 0 73109 A 1 D 0 0
63133 62012 product 0 75366 A 1 D 0 0
63141 61337 product 0 75374 A 1 D 0 0
67558 29992 product 0 79791 A 1 D 0 0
13165 29992 product 0 23258 A 2 D 0 0
15656 61336 product 0 27123 A 2 D 0 0
21041 62123 product 0 32882 A 2 D 0 0
23836 63034 product 0 35767 A 2 D 0 0
32632 61430 product 0 44865 A 2 D 0 0
40984 60914 product 0 53217 A 2 D 0 0
57325 62259 product 0 69558 A 2 D 0 0
57326 62260 product 0 69559 A 2 D 0 0
60877 64942 product 0 73110 A 2 D 0 0
63134 62012 product 0 75367 A 2 D 0 0
63139 61337 product 0 75372 A 2 D 0 0
15727 61336 product 0 27206 A 3 D 0 0
16154 61430 product 0 27674 A 3 D 0 0
21037 62123 product 0 32878 A 3 D 0 0
23837 63034 product 0 35768 A 3 D 0 0
25579 58884 product 0 37716 A 3 D 0 0
41024 60914 product 0 53257 A 3 C 0 0
46418 62012 product 0 58651 A 3 D 0 0
46716 61337 product 0 58949 A 3 D 0 0
57051 62259 product 0 69284 A 3 C 0 0
57055 62260 product 0 69288 A 3 C 0 0
60879 64942 product 0 73112 A 3 D 0 0
67553 29992 product 0 79786 A 3 D 0 0
21038 62123 product 0 32879 A 4 D 0 0
25580 58884 product 0 37717 A 4 D 0 0
46419 62012 product 0 58652 A 4 D 0 0
53827 60914 product 0 66060 A 4 C 0 0
56058 63034 product 0 68291 A 4 C 0 0
57052 62259 product 0 69285 A 4 C 0 0
57056 62260 product 0 69289 A 4 C 0 0
60878 64942 product 0 73111 A 4 D 0 0
62403 61336 product 0 74636 A 4 C 0 0
63140 61337 product 0 75373 A 4 D 0 0
67554 29992 product 0 79787 A 4 D 0 0
15694 61337 product 0 27169 A 5 D 0 0
19150 62012 product 0 30862 A 5 D 0 0
21039 62123 product 0 32880 A 5 D 0 0
56056 63034 product 0 68289 A 5 C 0 0
57053 62259 product 0 69286 A 5 C 0 0
57057 62260 product 0 69290 A 5 C 0 0
58935 60914 product 0 71168 A 5 C 0 0
62404 61336 product 0 74637 A 5 C 0 0
67555 29992 product 0 79788 A 5 D 0 0
21040 62123 product 0 32881 A 6 D 0 0
21065 62123 product 0 32906 A 6 D 0 0
21066 62123 product 0 32907 A 6 D 0 0
46448 61337 product 0 58681 A 6 D 0 0
56057 63034 product 0 68290 A 6 C 0 0
57054 62259 product 0 69287 A 6 C 0 0
57102 60914 product 0 69335 A 6 C 0 0
59191 61336 product 0 71424 A 6 C 0 0
59193 62012 product 0 71426 A 6 C 0 0
59547 62260 product 0 71780 A 6 C 0 0
67559 29992 product 0 79792 A 6 D 0 0
40978 60914 product 0 53211 A 7 C 0 0
46449 61337 product 0 58682 A 7 D 0 0
57058 62260 product 0 69291 A 7 C 0 0
59545 62012 product 0 71778 A 7 C 0 0
63803 61336 product 0 76036 A 7 C 0 0
66069 61336 product 0 78302 A 7 C 0 0
67556 29992 product 0 79789 A 7 D 0 0
48369 60914 product 0 60602 A 8 C 0 0
56302 61337 product 0 68535 A 8 D 0 0
59194 62012 product 0 71427 A 8 C 0 0
67557 29992 product 0 79790 A 8 D 0 0
37759 62012 product 0 49992 A 9 C 0 0
45362 29992 product 0 57595 A 9 C 0 0
56237 60914 product 0 68470 A 9 C 0 0
56303 61337 product 0 68536 A 9 C 0 0
48990 60914 product 0 61223 A 10 C 0 0
56304 61337 product 0 68537 A 10 C 0 0
59546 62012 product 0 71779 A 10 C 0 0
63072 29992 product 0 75305 A 10 C 0 0
63720 60914 product 0 75953 A 10 C 0 0
65212 60914 product 0 77445 A 10 C 0 0
65702 60914 product 0 77935 A 10 C 0 0
37835 62012 product 0 50068 A 11 C 0 0
63071 29992 product 0 75304 A 11 C 0 0
66331 61337 product 0 78564 A 11 C 0 0
56307 61337 product 0 68540 A 12 C 0 0
60007 62012 product 0 72240 A 12 C 0 0
60008 29992 product 0 72241 A 12 C 0 0
56305 61337 product 0 68538 A 13 C 0 0
56308 61337 product 0 68541 A 14 C 0 0
56309 61337 product 0 68542 A 15 C 0 0
59587 61337 product 0 71820 A 16 C 0 0
62180 61337 product 0 74413 A 17 C 0 0