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.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 = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    371848, 377768, 377769, 377770, 377771, 
    371936, 379177, 379178, 379179, 377755, 
    377808, 377809, 377810, 371912, 377798, 
    377799, 377800, 377801, 372021, 379711, 
    379712, 379713, 379714, 377735, 377804, 
    377805, 377806, 377807, 371917, 377802, 
    377803, 371984, 379707, 379708, 379709, 
    371905, 377794, 377795, 371843, 377765, 
    377766, 377767, 371945, 379703, 371941, 
    379701, 379702, 371988, 379710, 371909, 
    377796, 377797, 366701, 366702, 366703, 
    371947, 379704, 379705, 371929, 377811, 
    377812, 377813, 371933, 378262, 371949, 
    379706
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00287

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "382.81"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "66.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "cscart_images_links",
            "access_type": "range",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type",
              "type"
            ],
            "key_length": "81",
            "rows_examined_per_scan": 66,
            "rows_produced_per_join": 66,
            "filtered": "100.00",
            "index_condition": "((`webmarco`.`cscart_images_links`.`object_type` = 'product') and (`webmarco`.`cscart_images_links`.`type` = 'M') and (`webmarco`.`cscart_images_links`.`object_id` in (371848,377768,377769,377770,377771,371936,379177,379178,379179,377755,377808,377809,377810,371912,377798,377799,377800,377801,372021,379711,379712,379713,379714,377735,377804,377805,377806,377807,371917,377802,377803,371984,379707,379708,379709,371905,377794,377795,371843,377765,377766,377767,371945,379703,371941,379701,379702,371988,379710,371909,377796,377797,366701,366702,366703,371947,379704,379705,371929,377811,377812,377813,371933,378262,371949,379706)))",
            "cost_info": {
              "read_cost": "145.21",
              "eval_cost": "13.20",
              "prefix_cost": "158.41",
              "data_read_per_join": "6K"
            },
            "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": [
              "webmarco.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 66,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "66.00",
              "eval_cost": "13.20",
              "prefix_cost": "237.61",
              "data_read_per_join": "50K"
            },
            "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": "108",
            "ref": [
              "webmarco.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 66,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "66.00",
              "eval_cost": "13.20",
              "prefix_cost": "316.81",
              "data_read_per_join": "39K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}

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 produts_img_600__24__czik-ee.png 600 600 N 3016740 366701 product 963101 M 0 963101
0 produts_img_600__24__s82j-3y.png 600 600 N 3016744 366702 product 963105 M 0 963105
0 produts_img_600__24__bh4d-gj.png 600 600 N 3016748 366703 product 963109 M 0 963109
0 Untitled_design_-_2023-01-09T093128.577.png 600 600 N 3135217 371843 product 1018800 M 0 1018800
0 Untitled_design_-_2023-01-09T093204.198.png 600 600 N 3135224 371848 product 1018807 M 0 1018807
0 Untitled_design_-_2023-01-09T094102.062.png 600 600 N 3135300 371905 product 1018856 M 0 1018856
0 Untitled_design_-_2023-01-09T094115.234.png 600 600 N 3135304 371909 product 1018858 M 0 1018858
0 Untitled_design_-_2023-01-09T094134.087.png 600 600 N 3135307 371912 product 1018859 M 0 1018859
0 Untitled_design_-_2023-01-09T094150.844.png 600 600 N 3135312 371917 product 1018860 M 0 1018860
0 Untitled_design_-_2023-01-09T094238.598.png 600 600 N 3135324 371929 product 1018863 M 0 1018863
0 Untitled_design_-_2023-01-09T094333.745.png 600 600 N 3135328 371933 product 1018864 M 0 1018864
0 Untitled_design_-_2023-01-09T094503.189.png 600 600 N 3135331 371936 product 1018866 M 0 1018866
0 Untitled_design_-_2023-01-09T094552.035.png 600 600 N 3135336 371941 product 1018868 M 0 1018868
0 Untitled_design_-_2023-01-09T094645.193.png 600 600 N 3135340 371945 product 1018870 M 0 1018870
0 Untitled_design_-_2023-01-09T094817.720.png 600 600 N 3135342 371947 product 1018871 M 0 1018871
0 Untitled_design_-_2023-01-09T095007.870.png 600 600 N 3135344 371949 product 1018872 M 0 1018872
0 Untitled_design_-_2023-01-09T095036.456.png 600 600 N 3135541 371984 product 1018907 M 0 1018907
0 Untitled_design_-_2023-01-09T095107.092.png 600 600 N 3135611 371988 product 1018910 M 0 1018910
0 Untitled_design_-_2023-01-09T155947.780.png 600 600 N 3135809 372021 product 1018916 M 0 1018916
0 Untitled_design_-_2023-01-09T094204.627_qdyo-4w.png 600 600 N 3167857 377735 product 1042635 M 0 1042635
0 Untitled_design_-_2023-01-09T094220.402.png 600 600 N 3168044 377755 product 1018862 M 0 1018862
0 Untitled_design_-_2023-01-09T093128.577.png 600 600 N 3170610 377765 product 1018800 M 0 1018800
0 Untitled_design_-_2023-01-09T093128.577.png 600 600 N 3170611 377766 product 1018800 M 0 1018800
0 Untitled_design_-_2023-01-09T093128.577.png 600 600 N 3170612 377767 product 1018800 M 0 1018800
0 Untitled_design_-_2023-01-09T093204.198.png 600 600 N 3170613 377768 product 1018807 M 0 1018807
0 Untitled_design_-_2023-01-09T093204.198.png 600 600 N 3170614 377769 product 1018807 M 0 1018807
0 Untitled_design_-_2023-01-09T093204.198.png 600 600 N 3170615 377770 product 1018807 M 0 1018807
0 Untitled_design_-_2023-01-09T093204.198.png 600 600 N 3170616 377771 product 1018807 M 0 1018807
0 Untitled_design_-_2023-01-09T094102.062.png 600 600 N 3170639 377794 product 1018856 M 0 1018856
0 Untitled_design_-_2023-01-09T094102.062.png 600 600 N 3170640 377795 product 1018856 M 0 1018856
0 Untitled_design_-_2023-01-09T094115.234.png 600 600 N 3170641 377796 product 1018858 M 0 1018858
0 Untitled_design_-_2023-01-09T094115.234.png 600 600 N 3170642 377797 product 1018858 M 0 1018858
0 Untitled_design_-_2023-01-09T094134.087.png 600 600 N 3170643 377798 product 1018859 M 0 1018859
0 Untitled_design_-_2023-01-09T094134.087.png 600 600 N 3170644 377799 product 1018859 M 0 1018859
0 Untitled_design_-_2023-01-09T094134.087.png 600 600 N 3170645 377800 product 1018859 M 0 1018859
0 Untitled_design_-_2023-01-09T094134.087.png 600 600 N 3170646 377801 product 1018859 M 0 1018859
0 Untitled_design_-_2023-01-09T094150.844.png 600 600 N 3170647 377802 product 1018860 M 0 1018860
0 Untitled_design_-_2023-01-09T094150.844.png 600 600 N 3170648 377803 product 1018860 M 0 1018860
0 Untitled_design_-_2023-01-09T094204.627_qdyo-4w.png 600 600 N 3170651 377804 product 1042635 M 0 1042635
0 Untitled_design_-_2023-01-09T094204.627_qdyo-4w.png 600 600 N 3170652 377805 product 1042635 M 0 1042635
0 Untitled_design_-_2023-01-09T094204.627_qdyo-4w.png 600 600 N 3170653 377806 product 1042635 M 0 1042635
0 Untitled_design_-_2023-01-09T094204.627_qdyo-4w.png 600 600 N 3170654 377807 product 1042635 M 0 1042635
0 Untitled_design_-_2023-01-09T094220.402.png 600 600 N 3170657 377808 product 1018862 M 0 1018862
0 Untitled_design_-_2023-01-09T094220.402.png 600 600 N 3170658 377809 product 1018862 M 0 1018862
0 Untitled_design_-_2023-01-09T094220.402.png 600 600 N 3170659 377810 product 1018862 M 0 1018862
0 Untitled_design_-_2023-01-09T094238.598.png 600 600 N 3170660 377811 product 1018863 M 0 1018863
0 Untitled_design_-_2023-01-09T094238.598.png 600 600 N 3170661 377812 product 1018863 M 0 1018863
0 Untitled_design_-_2023-01-09T094238.598.png 600 600 N 3170662 377813 product 1018863 M 0 1018863
0 Untitled_design_-_2023-01-09T094333.745.png 600 600 N 3171111 378262 product 1018864 M 0 1018864
0 Untitled_design_-_2023-01-09T094503.189.png 600 600 N 3172025 379177 product 1018866 M 0 1018866
0 Untitled_design_-_2023-01-09T094503.189.png 600 600 N 3172026 379178 product 1018866 M 0 1018866
0 Untitled_design_-_2023-01-09T094503.189.png 600 600 N 3172027 379179 product 1018866 M 0 1018866
0 Untitled_design_-_2023-01-09T094552.035.png 600 600 N 3172550 379701 product 1018868 M 0 1018868
0 Untitled_design_-_2023-01-09T094552.035.png 600 600 N 3172551 379702 product 1018868 M 0 1018868
0 Untitled_design_-_2023-01-09T094645.193.png 600 600 N 3172552 379703 product 1018870 M 0 1018870
0 Untitled_design_-_2023-01-09T094817.720.png 600 600 N 3172553 379704 product 1018871 M 0 1018871
0 Untitled_design_-_2023-01-09T094817.720.png 600 600 N 3172554 379705 product 1018871 M 0 1018871
0 Untitled_design_-_2023-01-09T095007.870.png 600 600 N 3172555 379706 product 1018872 M 0 1018872
0 Untitled_design_-_2023-01-09T095036.456.png 600 600 N 3172556 379707 product 1018907 M 0 1018907
0 Untitled_design_-_2023-01-09T095036.456.png 600 600 N 3172557 379708 product 1018907 M 0 1018907
0 Untitled_design_-_2023-01-09T095036.456.png 600 600 N 3172558 379709 product 1018907 M 0 1018907
0 Untitled_design_-_2023-01-09T095107.092.png 600 600 N 3172559 379710 product 1018910 M 0 1018910
0 Untitled_design_-_2023-01-09T155947.780.png 600 600 N 3172584 379711 product 1018916 M 0 1018916
0 Untitled_design_-_2023-01-09T155947.780.png 600 600 N 3172585 379712 product 1018916 M 0 1018916
0 Untitled_design_-_2023-01-09T155947.780.png 600 600 N 3172586 379713 product 1018916 M 0 1018916
0 Untitled_design_-_2023-01-09T155947.780.png 600 600 N 3172587 379714 product 1018916 M 0 1018916