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 (
    64617, 60736, 64615, 62252, 61336, 62253, 
    64614, 60731, 60726, 60750, 60734, 
    61388, 64622, 60741, 64623, 64626, 
    60747, 62254, 60730, 62260, 60740, 
    61387, 60742, 61171
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00515

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": 179,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64617,60736,64615,62252,61336,62253,64614,60731,60726,60750,60734,61388,64622,60741,64623,64626,60747,62254,60730,62260,60740,61387,60742,61171)"
        }
      }
    },
    "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
33590 60726 product 0 45823 A 0 D 0 0
33624 60742 product 0 45857 A 0 D 0 0
46467 61336 product 0 58700 A 0 D 0 0
53865 62260 product 0 66098 A 0 D 0 0
57273 60747 product 0 69506 A 0 D 0 0
61180 60740 product 0 73413 A 0 D 0 0
62298 60750 product 0 74531 A 0 D 0 0
62307 60731 product 0 74540 A 0 D 0 0
62310 61171 product 0 74543 A 0 D 0 0
62313 61388 product 0 74546 A 0 D 0 0
62314 61388 product 0 74547 A 0 D 0 0
62315 61388 product 0 74548 A 0 D 0 0
62316 61387 product 0 74549 A 0 D 0 0
62319 60734 product 0 74552 A 0 D 0 0
62331 60736 product 0 74564 A 0 D 0 0
62338 60730 product 0 74571 A 0 D 0 0
70446 64615 product 0 82679 A 0 D 0 0
70447 64614 product 0 82680 A 0 D 0 0
70449 64617 product 0 82682 A 0 D 0 0
70450 64622 product 0 82683 A 0 D 0 0
70451 64623 product 0 82684 A 0 D 0 0
70455 64626 product 0 82688 A 0 D 0 0
32576 64623 product 0 44809 A 1 D 0 0
32577 64622 product 0 44810 A 1 D 0 0
32578 64617 product 0 44811 A 1 D 0 0
33630 60747 product 0 45863 A 1 C 0 0
33653 60740 product 0 45886 A 1 D 0 0
46468 61336 product 0 58701 A 1 D 0 0
53866 62260 product 0 66099 A 1 D 0 0
56382 60726 product 0 68615 A 1 D 0 0
59014 64615 product 0 71247 A 1 C 0 0
59017 64614 product 0 71250 A 1 D 0 0
61182 60742 product 0 73415 A 1 D 0 0
62299 60750 product 0 74532 A 1 D 0 0
62308 60731 product 0 74541 A 1 D 0 0
62311 61171 product 0 74544 A 1 D 0 0
62317 61387 product 0 74550 A 1 D 0 0
62321 60734 product 0 74554 A 1 D 0 0
62332 60736 product 0 74565 A 1 D 0 0
62339 60730 product 0 74572 A 1 D 0 0
15656 61336 product 0 27123 A 2 D 0 0
56389 60726 product 0 68622 A 2 D 0 0
57238 60747 product 0 69471 A 2 C 0 0
57326 62260 product 0 69559 A 2 D 0 0
59015 64615 product 0 71248 A 2 C 0 0
59020 64617 product 0 71253 A 2 D 0 0
59021 64623 product 0 71254 A 2 D 0 0
61728 60740 product 0 73961 A 2 D 0 0
62300 60750 product 0 74533 A 2 D 0 0
62309 60731 product 0 74542 A 2 D 0 0
62312 61171 product 0 74545 A 2 D 0 0
62318 61387 product 0 74551 A 2 D 0 0
62320 60734 product 0 74553 A 2 D 0 0
62333 60736 product 0 74566 A 2 D 0 0
62340 60730 product 0 74573 A 2 D 0 0
64761 60742 product 0 76994 A 2 D 0 0
15727 61336 product 0 27206 A 3 D 0 0
33599 60750 product 0 45832 A 3 C 0 0
33692 60740 product 0 45925 A 3 D 0 0
33721 60742 product 0 45954 A 3 D 0 0
33740 60730 product 0 45973 A 3 C 0 0
36730 60734 product 0 48963 A 3 C 0 0
57055 62260 product 0 69288 A 3 C 0 0
57106 60731 product 0 69339 A 3 C 0 0
57234 60726 product 0 69467 A 3 C 0 0
58094 61388 product 0 70327 A 3 C 0 0
59016 64615 product 0 71249 A 3 C 0 0
59022 64617 product 0 71255 A 3 C 0 0
59026 64623 product 0 71259 A 3 D 0 0
64294 60736 product 0 76527 A 3 C 0 0
65718 61171 product 0 77951 A 3 C 0 0
68024 61387 product 0 80257 A 3 D 0 0
33594 61388 product 0 45827 A 4 C 0 0
33678 60747 product 0 45911 A 4 C 0 0
52283 61171 product 0 64516 A 4 C 0 0
53846 60750 product 0 66079 A 4 C 0 0
55619 60730 product 0 67852 A 4 C 0 0
56122 60734 product 0 68355 A 4 C 0 0
57056 62260 product 0 69289 A 4 C 0 0
57268 60740 product 0 69501 A 4 D 0 0
58542 60726 product 0 70775 A 4 C 0 0
59023 64617 product 0 71256 A 4 C 0 0
59030 64615 product 0 71263 A 4 D 0 0
62403 61336 product 0 74636 A 4 C 0 0
64124 60736 product 0 76357 A 4 C 0 0
67566 60742 product 0 79799 A 4 C 0 0
68022 61387 product 0 80255 A 4 D 0 0
33605 60736 product 0 45838 A 5 C 0 0
56118 61388 product 0 68351 A 5 C 0 0
56120 60750 product 0 68353 A 5 C 0 0
56121 60734 product 0 68354 A 5 C 0 0
56391 61171 product 0 68624 A 5 C 0 0
56444 60730 product 0 68677 A 5 C 0 0
57057 62260 product 0 69290 A 5 C 0 0
59032 64615 product 0 71265 A 5 D 0 0
59200 64617 product 0 71433 A 5 C 0 0
61221 60731 product 0 73454 A 5 C 0 0
61717 60726 product 0 73950 A 5 C 0 0
61729 60740 product 0 73962 A 5 D 0 0
62404 61336 product 0 74637 A 5 C 0 0
68023 61387 product 0 80256 A 5 D 0 0
33589 60726 product 0 45822 A 6 C 0 0
53829 60750 product 0 66062 A 6 C 0 0
56044 60734 product 0 68277 A 6 C 0 0
56133 60731 product 0 68366 A 6 C 0 0
56392 61171 product 0 68625 A 6 C 0 0
56393 60740 product 0 68626 A 6 D 0 0
57391 60736 product 0 69624 A 6 C 0 0
58093 61388 product 0 70326 A 6 C 0 0
59191 61336 product 0 71424 A 6 C 0 0
59547 62260 product 0 71780 A 6 C 0 0
62799 60730 product 0 75032 A 6 C 0 0
65620 60742 product 0 77853 A 6 C 0 0
68025 61387 product 0 80258 A 6 D 0 0
33629 61171 product 0 45862 A 7 C 0 0
33691 61388 product 0 45924 A 7 C 0 0
47578 60740 product 0 59811 A 7 C 0 0
55540 60750 product 0 67773 A 7 C 0 0
56059 60734 product 0 68292 A 7 C 0 0
56130 60731 product 0 68363 A 7 C 0 0
57058 62260 product 0 69291 A 7 C 0 0
57239 60747 product 0 69472 A 7 C 0 0
57245 60730 product 0 69478 A 7 C 0 0
57392 60736 product 0 69625 A 7 C 0 0
60373 60742 product 0 72606 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
68016 61387 product 0 80249 A 7 C 0 0
33677 60742 product 0 45910 A 8 C 0 0
37852 60736 product 0 50085 A 8 C 0 0
51992 60726 product 0 64225 A 8 C 0 0
53844 61388 product 0 66077 A 8 C 0 0
56049 60750 product 0 68282 A 8 C 0 0
56134 60740 product 0 68367 A 8 C 0 0
57107 60731 product 0 69340 A 8 C 0 0
57242 60747 product 0 69475 A 8 C 0 0
60111 61171 product 0 72344 A 8 C 0 0
62798 60730 product 0 75031 A 8 C 0 0
33600 60750 product 0 45833 A 9 C 0 0
56050 60726 product 0 68283 A 9 C 0 0
57105 60731 product 0 69338 A 9 C 0 0
57240 60747 product 0 69473 A 9 C 0 0
58282 60734 product 0 70515 A 9 C 0 0
58294 60742 product 0 70527 A 9 C 0 0
60112 61171 product 0 72345 A 9 C 0 0
61803 60740 product 0 74036 A 9 C 0 0
61809 61388 product 0 74042 A 9 C 0 0
62800 60730 product 0 75033 A 9 C 0 0
43055 60750 product 0 55288 A 10 C 0 0
56131 60731 product 0 68364 A 10 C 0 0
56385 60726 product 0 68618 A 10 C 0 0
57231 60740 product 0 69464 A 10 C 0 0
57393 60742 product 0 69626 A 10 C 0 0
60017 60747 product 0 72250 A 10 C 0 0
60110 61171 product 0 72343 A 10 C 0 0
61808 61388 product 0 74041 A 10 C 0 0
67216 61388 product 0 79449 A 10 C 0 0
56111 60726 product 0 68344 A 11 C 0 0
58933 60750 product 0 71166 A 11 D 0 0
58976 60740 product 0 71209 A 11 C 0 0
60113 61171 product 0 72346 A 11 C 0 0
61176 60747 product 0 73409 A 11 C 0 0
61883 60747 product 0 74116 A 11 C 0 0
61968 60731 product 0 74201 A 11 C 0 0
66750 60742 product 0 78983 A 11 C 0 0
33588 60726 product 0 45821 A 12 C 0 0
57108 60731 product 0 69341 A 12 C 0 0
58934 60750 product 0 71167 A 12 C 0 0
61802 60740 product 0 74035 A 12 C 0 0
56132 60731 product 0 68365 A 13 C 0 0
59977 60726 product 0 72210 A 13 C 0 0
58957 60731 product 0 71190 A 14 C 0 0
60031 60726 product 0 72264 A 14 C 0 0
59195 60731 product 0 71428 A 15 C 0 0
60032 60726 product 0 72265 A 15 C 0 0