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 (
    61937, 62229, 64353, 64350, 62246, 64355, 
    62843, 63513, 63467, 63510, 63852, 
    62979, 63853, 63515, 63810, 63854, 
    63806, 64946, 64865, 64863, 64947
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00175

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": 232,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61937,62229,64353,64350,62246,64355,62843,63513,63467,63510,63852,62979,63853,63515,63810,63854,63806,64946,64865,64863,64947)"
        }
      }
    },
    "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
18798 61937 product 0 30477 A 0 D 0 0
20675 62229 product 0 32504 A 0 D 0 0
20957 62246 product 0 32793 A 0 D 0 0
23083 62843 product 0 34994 A 0 D 0 0
23683 62979 product 0 35611 A 0 D 0 0
26273 63467 product 0 38436 A 0 D 0 0
26495 63513 product 0 38662 A 0 D 0 0
27411 63810 product 0 39588 A 0 D 0 0
27413 63810 product 0 39590 A 0 D 0 0
27414 63810 product 0 39591 A 0 D 0 0
27851 63852 product 0 40030 A 0 D 0 0
27854 63853 product 0 40033 A 0 D 0 0
27855 63853 product 0 40034 A 0 D 0 0
27856 63853 product 0 40035 A 0 D 0 0
27857 63853 product 0 40036 A 0 D 0 0
27858 63853 product 0 40037 A 0 D 0 0
27860 63854 product 0 40039 A 0 D 0 0
27861 63854 product 0 40040 A 0 D 0 0
27862 63854 product 0 40041 A 0 D 0 0
30073 63806 product 0 42296 A 0 D 0 0
30074 63810 product 0 42297 A 0 D 0 0
30082 63515 product 0 42305 A 0 D 0 0
30086 63510 product 0 42309 A 0 D 0 0
30154 63810 product 0 42377 A 0 D 0 0
30458 64350 product 0 42690 A 0 D 0 0
30507 64353 product 0 42739 A 0 D 0 0
30513 64355 product 0 42745 A 0 D 0 0
30514 64355 product 0 42746 A 0 D 0 0
30515 64355 product 0 42747 A 0 D 0 0
30516 64355 product 0 42748 A 0 D 0 0
48972 64947 product 0 61205 A 0 D 0 0
48974 64947 product 0 61207 A 0 D 0 0
48975 64947 product 0 61208 A 0 D 0 0
48976 64947 product 0 61209 A 0 D 0 0
48982 64863 product 0 61215 A 0 D 0 0
49001 64946 product 0 61234 A 0 D 0 0
49005 64865 product 0 61238 A 0 D 0 0
49006 64865 product 0 61239 A 0 D 0 0
49007 64865 product 0 61240 A 0 D 0 0
49008 64865 product 0 61241 A 0 D 0 0
55508 64865 product 0 67741 A 0 C 0 0
55515 64865 product 0 67748 A 0 C 0 0
55516 64865 product 0 67749 A 0 C 0 0
57389 64355 product 0 69622 A 0 C 0 0
59049 64355 product 0 71282 A 0 C 0 0
59050 64355 product 0 71283 A 0 C 0 0
59051 64355 product 0 71284 A 0 C 0 0
59052 64355 product 0 71285 A 0 C 0 0
61845 64947 product 0 74078 A 0 C 0 0
61846 64947 product 0 74079 A 0 C 0 0
66340 64865 product 0 78573 A 0 C 0 0
66341 64865 product 0 78574 A 0 C 0 0
66342 64865 product 0 78575 A 0 C 0 0
67102 64865 product 0 79335 A 0 C 0 0
72613 62229 product 0 84846 A 0 C 0 0
20681 62229 product 0 32510 A 1 C 0 0
23082 62843 product 0 34993 A 1 D 0 0
23541 62246 product 0 35469 A 1 C 0 0
23681 62979 product 0 35609 A 1 D 0 0
26499 63513 product 0 38666 A 1 D 0 0
26503 63510 product 0 38670 A 1 D 0 0
27422 63806 product 0 39599 A 1 D 0 0
27850 63852 product 0 40029 A 1 D 0 0
29944 61937 product 0 42167 A 1 D 0 0
30266 63515 product 0 42489 A 1 C 0 0
30511 64353 product 0 42743 A 1 D 0 0
48983 64863 product 0 61216 A 1 D 0 0
49002 64946 product 0 61235 A 1 D 0 0
67661 63467 product 0 79894 A 1 C 0 0
71041 64350 product 0 83274 A 1 D 0 0
18796 61937 product 0 30475 A 2 D 0 0
20960 62246 product 0 32796 A 2 D 0 0
23036 62843 product 0 34947 A 2 D 0 0
23682 62979 product 0 35610 A 2 D 0 0
26492 63515 product 0 38659 A 2 D 0 0
27421 63806 product 0 39598 A 2 D 0 0
27852 63852 product 0 40031 A 2 D 0 0
30078 63467 product 0 42301 A 2 C 0 0
30080 63513 product 0 42303 A 2 D 0 0
30085 63510 product 0 42308 A 2 D 0 0
30459 64350 product 0 42691 A 2 D 0 0
30508 64353 product 0 42740 A 2 D 0 0
35911 62229 product 0 48144 A 2 C 0 0
48985 64863 product 0 61218 A 2 D 0 0
49003 64946 product 0 61236 A 2 D 0 0
23031 62843 product 0 34942 A 3 D 0 0
25607 61937 product 0 37744 A 3 D 0 0
26056 62246 product 0 38218 A 3 D 0 0
26493 63515 product 0 38660 A 3 D 0 0
26504 63510 product 0 38671 A 3 D 0 0
26590 63513 product 0 38759 A 3 D 0 0
27418 63806 product 0 39595 A 3 D 0 0
30075 63467 product 0 42298 A 3 D 0 0
30509 64353 product 0 42741 A 3 D 0 0
32532 63852 product 0 44765 A 3 C 0 0
32587 64350 product 0 44820 A 3 D 0 0
33282 62979 product 0 45515 A 3 C 0 0
49004 64946 product 0 61237 A 3 D 0 0
49273 64863 product 0 61506 A 3 D 0 0
58547 62229 product 0 70780 A 3 C 0 0
20958 62246 product 0 32794 A 4 D 0 0
22785 62229 product 0 34689 A 4 C 0 0
26501 63513 product 0 38668 A 4 D 0 0
26505 63510 product 0 38672 A 4 D 0 0
26506 63515 product 0 38673 A 4 D 0 0
27419 63806 product 0 39596 A 4 D 0 0
30461 64350 product 0 42693 A 4 D 0 0
30510 64353 product 0 42742 A 4 D 0 0
32585 61937 product 0 44818 A 4 D 0 0
48984 64863 product 0 61217 A 4 D 0 0
55501 64946 product 0 67734 A 4 C 0 0
62897 63467 product 0 75130 A 4 C 0 0
22441 62246 product 0 34339 A 5 C 0 0
25609 61937 product 0 37746 A 5 D 0 0
26279 63467 product 0 38442 A 5 D 0 0
26496 63513 product 0 38663 A 5 D 0 0
30084 63515 product 0 42307 A 5 C 0 0
30087 63510 product 0 42310 A 5 D 0 0
30460 64350 product 0 42692 A 5 D 0 0
32588 64353 product 0 44821 A 5 D 0 0
48986 64863 product 0 61219 A 5 D 0 0
53838 62229 product 0 66071 A 5 C 0 0
68536 63806 product 0 80769 A 5 C 0 0
68655 64946 product 0 80888 A 5 C 0 0
20959 62246 product 0 32795 A 6 D 0 0
21223 62229 product 0 33104 A 6 D 0 0
26280 63467 product 0 38443 A 6 D 0 0
26500 63513 product 0 38667 A 6 D 0 0
30083 63515 product 0 42306 A 6 D 0 0
30088 63510 product 0 42311 A 6 D 0 0
30457 64350 product 0 42689 A 6 D 0 0
32583 61937 product 0 44816 A 6 D 0 0
32603 64353 product 0 44836 A 6 D 0 0
32716 63806 product 0 44949 A 6 C 0 0
49278 64863 product 0 61511 A 6 D 0 0
59199 64946 product 0 71432 A 6 C 0 0
18821 61937 product 0 30500 A 7 D 0 0
20680 62229 product 0 32509 A 7 D 0 0
26057 62246 product 0 38219 A 7 D 0 0
26507 63515 product 0 38674 A 7 D 0 0
30517 64353 product 0 42749 A 7 C 0 0
32277 63806 product 0 44510 A 7 C 0 0
32482 63513 product 0 44715 A 7 C 0 0
32602 64350 product 0 44835 A 7 D 0 0
48988 64863 product 0 61221 A 7 D 0 0
58995 63467 product 0 71228 A 7 C 0 0
60082 64946 product 0 72315 A 7 C 0 0
61984 63510 product 0 74217 A 7 C 0 0
18800 61937 product 0 30479 A 8 D 0 0
21221 62229 product 0 33102 A 8 D 0 0
26508 63515 product 0 38675 A 8 D 0 0
30462 64350 product 0 42694 A 8 D 0 0
31855 63467 product 0 44088 A 8 C 0 0
32481 63513 product 0 44714 A 8 C 0 0
35847 63806 product 0 48080 A 8 C 0 0
48987 64863 product 0 61220 A 8 D 0 0
49907 64353 product 0 62140 A 8 C 0 0
59042 63510 product 0 71275 A 8 C 0 0
65535 64946 product 0 77768 A 8 C 0 0
67662 62246 product 0 79895 A 8 C 0 0
20673 62229 product 0 32502 A 9 D 0 0
30464 64350 product 0 42696 A 9 D 0 0
32584 61937 product 0 44817 A 9 D 0 0
35128 63467 product 0 47361 A 9 C 0 0
48405 64353 product 0 60638 A 9 C 0 0
51661 63513 product 0 63894 A 9 C 0 0
53624 63510 product 0 65857 A 9 C 0 0
55436 64863 product 0 67669 A 9 C 0 0
62353 63806 product 0 74586 A 9 C 0 0
65901 64946 product 0 78134 A 9 C 0 0
67663 62246 product 0 79896 A 9 C 0 0
20967 62246 product 0 32803 A 10 C 0 0
21222 62229 product 0 33103 A 10 D 0 0
30077 63467 product 0 42300 A 10 C 0 0
30463 64350 product 0 42695 A 10 D 0 0
32276 63806 product 0 44509 A 10 C 0 0
48406 64353 product 0 60639 A 10 C 0 0
53617 63510 product 0 65850 A 10 C 0 0
60776 63513 product 0 73009 A 10 C 0 0
61415 61937 product 0 73648 A 10 C 0 0
61844 64863 product 0 74077 A 10 C 0 0
66291 64946 product 0 78524 A 10 C 0 0
20676 62229 product 0 32505 A 11 D 0 0
20968 62246 product 0 32804 A 11 C 0 0
30277 63513 product 0 42500 A 11 C 0 0
49909 64353 product 0 62142 A 11 C 0 0
53623 63510 product 0 65856 A 11 C 0 0
58562 61937 product 0 70795 A 11 C 0 0
62133 64863 product 0 74366 A 11 C 0 0
62354 63806 product 0 74587 A 11 C 0 0
66292 64946 product 0 78525 A 11 C 0 0
20679 62229 product 0 32508 A 12 D 0 0
30207 62246 product 0 42430 A 12 D 0 0
32451 64353 product 0 44684 A 12 C 0 0
47962 61937 product 0 60195 A 12 C 0 0
59043 63510 product 0 71276 A 12 C 0 0
60773 63513 product 0 73006 A 12 C 0 0
66344 64946 product 0 78577 A 12 C 0 0
66838 63510 product 0 79071 A 12 C 0 0
20678 62229 product 0 32507 A 13 D 0 0
30276 63513 product 0 42499 A 13 C 0 0
47963 61937 product 0 60196 A 13 C 0 0
49908 64353 product 0 62141 A 13 C 0 0
20677 62229 product 0 32506 A 14 D 0 0
30081 63513 product 0 42304 A 14 C 0 0
31960 64353 product 0 44193 A 14 C 0 0
58561 61937 product 0 70794 A 14 C 0 0
20674 62229 product 0 32503 A 15 D 0 0
32615 61937 product 0 44848 A 15 C 0 0
33281 63513 product 0 45514 A 15 C 0 0
58532 64353 product 0 70765 A 15 C 0 0
19156 61937 product 0 30868 A 16 C 0 0
32586 62229 product 0 44819 A 16 D 0 0
51660 63513 product 0 63893 A 16 C 0 0
58533 64353 product 0 70766 A 16 C 0 0
21902 61937 product 0 33788 A 17 C 0 0
60774 63513 product 0 73007 A 17 C 0 0
25608 61937 product 0 37745 A 18 C 0 0
49912 62229 product 0 62145 A 18 C 0 0
60775 63513 product 0 73008 A 18 C 0 0
18803 61937 product 0 30482 A 19 C 0 0
38479 62229 product 0 50712 A 19 C 0 0
63842 63513 product 0 76075 A 19 D 0 0
49913 62229 product 0 62146 A 20 C 0 0
58549 61937 product 0 70782 A 20 C 0 0
61172 63513 product 0 73405 A 20 C 0 0
58548 62229 product 0 70781 A 21 C 0 0
58563 61937 product 0 70796 A 21 C 0 0
61171 63513 product 0 73404 A 21 C 0 0
18822 61937 product 0 30501 A 22 C 0 0
58985 62229 product 0 71218 A 22 C 0 0
18802 61937 product 0 30481 A 23 C 0 0