SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 (
    36470, 36823, 36354, 69202, 69204, 69205, 
    13478, 36824, 11185, 35874, 35897, 
    36353, 36825, 36826, 66445, 69208, 
    69209, 69212, 11191, 11193, 11195, 
    11196, 24605, 35858, 35873, 35888, 
    35893, 35912, 66443, 66444, 69203, 
    69206, 69207, 69210, 69211
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00275

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "569.18"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "197.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_images_links",
            "access_type": "range",
            "possible_keys": [
              "object_id",
              "idx_object_type_type_position"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type",
              "type"
            ],
            "key_length": "81",
            "rows_examined_per_scan": 197,
            "rows_produced_per_join": 197,
            "filtered": "100.00",
            "index_condition": "((`cscart_db`.`cscart_images_links`.`object_type` = 'product') and (`cscart_db`.`cscart_images_links`.`type` = 'A') and (`cscart_db`.`cscart_images_links`.`object_id` in (36470,36823,36354,69202,69204,69205,13478,36824,11185,35874,35897,36353,36825,36826,66445,69208,69209,69212,11191,11193,11195,11196,24605,35858,35873,35888,35893,35912,66443,66444,69203,69206,69207,69210,69211)))",
            "cost_info": {
              "read_cost": "127.24",
              "eval_cost": "19.70",
              "prefix_cost": "146.94",
              "data_read_per_join": "18K"
            },
            "used_columns": [
              "pair_id",
              "object_id",
              "object_type",
              "image_id",
              "detailed_id",
              "type",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_images",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "image_id"
            ],
            "key_length": "4",
            "ref": [
              "cscart_db.cscart_images_links.image_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 197,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "104.38",
              "eval_cost": "19.70",
              "prefix_cost": "271.02",
              "data_read_per_join": "150K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res"
            ]
          }
        },
        {
          "table": {
            "table_name": "cscart_common_descriptions",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "lang_code",
              "object_holder"
            ],
            "key_length": "107",
            "ref": [
              "cscart_db.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 197,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "81.45",
              "eval_cost": "19.70",
              "prefix_cost": "372.18",
              "data_read_per_join": "116K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ],
            "attached_condition": "<if>(is_not_null_compl(cscart_common_descriptions), (`cscart_db`.`cscart_common_descriptions`.`object_id` = `cscart_db`.`cscart_images`.`image_id`), true)"
          }
        }
      ]
    }
  }
}

Result

image_id image_path image_x image_y is_high_res pair_id object_id object_type detailed_id type position alt images_image_id
0 125496 11191 product 126848 A 1
0 126093 11193 product 127445 A 1
0 126101 11196 product 127453 A 1
0 126123 11195 product 127475 A 1
0 149044 35858 product 150396 A 1
0 149154 35873 product 150506 A 1
0 149160 35874 product 150512 A 1
0 149288 35893 product 150640 A 1
0 149345 35897 product 150697 A 1
0 149393 35912 product 150745 A 1
0 161435 36823 product 162787 A 1
0 161442 36824 product 162794 A 1
0 161446 36825 product 162798 A 1
0 161450 36826 product 162802 A 1
0 176294 36353 product 177640 A 1
0 176304 36354 product 177650 A 1
0 182553 66443 product 183899 A 1
0 182559 66444 product 183905 A 1
0 182565 66445 product 183911 A 1
0 206254 35888 product 207538 A 1
0 126094 11193 product 127446 A 2
0 126102 11196 product 127454 A 2
0 126124 11195 product 127476 A 2
0 149045 35858 product 150397 A 2
0 149155 35873 product 150507 A 2
0 149161 35874 product 150513 A 2
0 149289 35893 product 150641 A 2
0 149346 35897 product 150698 A 2
0 149394 35912 product 150746 A 2
0 161438 36823 product 162790 A 2
0 161441 36824 product 162793 A 2
0 161445 36825 product 162797 A 2
0 161449 36826 product 162801 A 2
0 176295 36353 product 177641 A 2
0 176305 36354 product 177651 A 2
0 182554 66443 product 183900 A 2
0 182560 66444 product 183906 A 2
0 182566 66445 product 183912 A 2
0 206255 35888 product 207539 A 2
0 126095 11193 product 127447 A 3
0 126103 11196 product 127455 A 3
0 126125 11195 product 127477 A 3
0 149046 35858 product 150398 A 3
0 149156 35873 product 150508 A 3
0 149162 35874 product 150514 A 3
0 149290 35893 product 150642 A 3
0 149347 35897 product 150699 A 3
0 149395 35912 product 150747 A 3
0 161436 36823 product 162788 A 3
0 161440 36824 product 162792 A 3
0 161444 36825 product 162796 A 3
0 161448 36826 product 162800 A 3
0 176296 36353 product 177642 A 3
0 176306 36354 product 177652 A 3
0 182555 66443 product 183901 A 3
0 182561 66444 product 183907 A 3
0 182567 66445 product 183913 A 3
0 206256 35888 product 207540 A 3
0 126096 11193 product 127448 A 4
0 126104 11196 product 127456 A 4
0 126126 11195 product 127478 A 4
0 149047 35858 product 150399 A 4
0 149157 35873 product 150509 A 4
0 149163 35874 product 150515 A 4
0 149291 35893 product 150643 A 4
0 149348 35897 product 150700 A 4
0 149396 35912 product 150748 A 4
0 161437 36823 product 162789 A 4
0 176297 36353 product 177643 A 4
0 176307 36354 product 177653 A 4
0 182556 66443 product 183902 A 4
0 182562 66444 product 183908 A 4
0 182568 66445 product 183914 A 4
0 206257 35888 product 207541 A 4
0 126097 11193 product 127449 A 5
0 126105 11196 product 127457 A 5
0 126127 11195 product 127479 A 5
0 149048 35858 product 150400 A 5
0 149158 35873 product 150510 A 5
0 149164 35874 product 150516 A 5
0 149292 35893 product 150644 A 5
0 149349 35897 product 150701 A 5
0 149397 35912 product 150749 A 5
0 176298 36353 product 177644 A 5
0 176308 36354 product 177654 A 5
0 182557 66443 product 183903 A 5
0 182563 66444 product 183909 A 5
0 182569 66445 product 183915 A 5
0 206258 35888 product 207542 A 5
0 126098 11193 product 127450 A 6
0 126106 11196 product 127458 A 6
0 126128 11195 product 127480 A 6
0 149049 35858 product 150401 A 6
0 149165 35874 product 150517 A 6
0 149293 35893 product 150645 A 6
0 149350 35897 product 150702 A 6
0 176299 36353 product 177645 A 6
0 176309 36354 product 177655 A 6
0 206259 35888 product 207543 A 6
0 126099 11193 product 127451 A 7
0 126107 11196 product 127459 A 7
0 126129 11195 product 127481 A 7
0 149294 35893 product 150646 A 7
0 149351 35897 product 150703 A 7
0 176300 36353 product 177646 A 7
0 176310 36354 product 177656 A 7
0 206260 35888 product 207544 A 7
0 149295 35893 product 150647 A 8
0 149352 35897 product 150704 A 8
0 176301 36353 product 177647 A 8
0 176311 36354 product 177657 A 8
0 206261 35888 product 207545 A 8
0 149353 35897 product 150705 A 9
0 176302 36353 product 177648 A 9
0 176312 36354 product 177658 A 9
0 204622 69202 product 205906 A 10
0 204631 69203 product 205915 A 10
0 204640 69204 product 205924 A 10
0 204649 69205 product 205933 A 10
0 204655 69206 product 205939 A 10
0 204661 69207 product 205945 A 10
0 204667 69208 product 205951 A 10
0 204673 69209 product 205957 A 10
0 204679 69210 product 205963 A 10
0 204685 69211 product 205969 A 10
0 204691 69212 product 205975 A 10
0 211996 13478 product 213271 A 10
0 212127 24605 product 213402 A 10
0 125640 11185 product 126992 A 16
0 125641 11185 product 126993 A 17
0 125642 11185 product 126994 A 18
0 125643 11185 product 126995 A 19
0 125644 11185 product 126996 A 20
0 204623 69202 product 205907 A 20
0 204632 69203 product 205916 A 20
0 204641 69204 product 205925 A 20
0 204650 69205 product 205934 A 20
0 204656 69206 product 205940 A 20
0 204662 69207 product 205946 A 20
0 204668 69208 product 205952 A 20
0 204674 69209 product 205958 A 20
0 204680 69210 product 205964 A 20
0 204686 69211 product 205970 A 20
0 204692 69212 product 205976 A 20
0 211997 13478 product 213272 A 20
0 212128 24605 product 213403 A 20
0 125645 11185 product 126997 A 21
0 125646 11185 product 126998 A 22
0 204624 69202 product 205908 A 30
0 204633 69203 product 205917 A 30
0 204642 69204 product 205926 A 30
0 204651 69205 product 205935 A 30
0 204657 69206 product 205941 A 30
0 204663 69207 product 205947 A 30
0 204669 69208 product 205953 A 30
0 204675 69209 product 205959 A 30
0 204681 69210 product 205965 A 30
0 204687 69211 product 205971 A 30
0 204693 69212 product 205977 A 30
0 211998 13478 product 213273 A 30
0 212129 24605 product 213404 A 30
0 204625 69202 product 205909 A 40
0 204634 69203 product 205918 A 40
0 204643 69204 product 205927 A 40
0 204652 69205 product 205936 A 40
0 204658 69206 product 205942 A 40
0 204664 69207 product 205948 A 40
0 204670 69208 product 205954 A 40
0 204676 69209 product 205960 A 40
0 204682 69210 product 205966 A 40
0 204688 69211 product 205972 A 40
0 204694 69212 product 205978 A 40
0 211999 13478 product 213274 A 40
0 212130 24605 product 213405 A 40
0 204626 69202 product 205910 A 50
0 204635 69203 product 205919 A 50
0 204644 69204 product 205928 A 50
0 204653 69205 product 205937 A 50
0 204659 69206 product 205943 A 50
0 204665 69207 product 205949 A 50
0 204671 69208 product 205955 A 50
0 204677 69209 product 205961 A 50
0 204683 69210 product 205967 A 50
0 204689 69211 product 205973 A 50
0 212000 13478 product 213275 A 50
0 212131 24605 product 213406 A 50
0 204627 69202 product 205911 A 60
0 204636 69203 product 205920 A 60
0 204645 69204 product 205929 A 60
0 204695 69212 product 205979 A 60
0 204628 69202 product 205912 A 70
0 204637 69203 product 205921 A 70
0 204646 69204 product 205930 A 70
0 204629 69202 product 205913 A 80
0 204638 69203 product 205922 A 80
0 204647 69204 product 205931 A 80