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 (
    392179, 392180, 392181, 392182, 392183, 
    392184, 392185, 392186, 392187, 392188, 
    392189, 392190, 392191, 392192, 392193, 
    392194, 392195, 392196, 392197, 392198, 
    392199, 392200, 392201, 392202, 392203, 
    392204, 392205, 392206, 392163, 392164, 
    392165, 392159, 392160, 392161, 392162, 
    392172, 392173, 392174, 392175, 392176, 
    392177, 392178, 392169, 392170, 392171
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00179

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "261.01"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "45.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": 45,
            "rows_produced_per_join": 45,
            "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 (392179,392180,392181,392182,392183,392184,392185,392186,392187,392188,392189,392190,392191,392192,392193,392194,392195,392196,392197,392198,392199,392200,392201,392202,392203,392204,392205,392206,392163,392164,392165,392159,392160,392161,392162,392172,392173,392174,392175,392176,392177,392178,392169,392170,392171)))",
            "cost_info": {
              "read_cost": "99.01",
              "eval_cost": "9.00",
              "prefix_cost": "108.01",
              "data_read_per_join": "4K"
            },
            "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": 45,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "45.00",
              "eval_cost": "9.00",
              "prefix_cost": "162.01",
              "data_read_per_join": "34K"
            },
            "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": 45,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "45.00",
              "eval_cost": "9.00",
              "prefix_cost": "216.01",
              "data_read_per_join": "26K"
            },
            "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 Untitled_design_-_2023-03-27T111156.365.png 600 600 N 3365952 392159 product 1123192 M 0 1123192
0 Untitled_design_-_2023-03-27T111156.365.png 600 600 N 3365953 392160 product 1123192 M 0 1123192
0 Untitled_design_-_2023-03-27T111156.365.png 600 600 N 3365954 392161 product 1123192 M 0 1123192
0 Untitled_design_-_2023-03-27T111156.365.png 600 600 N 3365955 392162 product 1123192 M 0 1123192
0 Untitled_design_-_2023-03-27T111156.365_hor0-xt.png 600 600 N 3365956 392163 product 1123193 M 0 1123193
0 Untitled_design_-_2023-03-27T111156.365_hor0-xt.png 600 600 N 3365957 392164 product 1123193 M 0 1123193
0 Untitled_design_-_2023-03-27T111156.365_hor0-xt.png 600 600 N 3365958 392165 product 1123193 M 0 1123193
0 Untitled_design_-_2023-03-27T120932.154.png 600 600 N 3365962 392169 product 1123197 M 0 1123197
0 Untitled_design_-_2023-03-27T120932.154.png 600 600 N 3365963 392170 product 1123197 M 0 1123197
0 Untitled_design_-_2023-03-27T120932.154.png 600 600 N 3365964 392171 product 1123197 M 0 1123197
0 Untitled_design_-_2023-03-27T122108.775.png 600 600 N 3365965 392172 product 1123198 M 0 1123198
0 Untitled_design_-_2023-03-27T122108.775.png 600 600 N 3365966 392173 product 1123198 M 0 1123198
0 Untitled_design_-_2023-03-27T122108.775.png 600 600 N 3365967 392174 product 1123198 M 0 1123198
0 Untitled_design_-_2023-03-27T123012.096.png 600 600 N 3365968 392175 product 1123199 M 0 1123199
0 Untitled_design_-_2023-03-27T123012.096.png 600 600 N 3365969 392176 product 1123199 M 0 1123199
0 Untitled_design_-_2023-03-27T123012.096.png 600 600 N 3365970 392177 product 1123199 M 0 1123199
0 Untitled_design_-_2023-03-27T123012.096.png 600 600 N 3365971 392178 product 1123199 M 0 1123199
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365972 392179 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365973 392180 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365974 392181 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365975 392182 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365976 392183 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365977 392184 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365978 392185 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365979 392186 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365980 392187 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365981 392188 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365982 392189 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365983 392190 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365984 392191 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365985 392192 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365986 392193 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365987 392194 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365988 392195 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365989 392196 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365990 392197 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365991 392198 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365992 392199 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365993 392200 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365994 392201 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365995 392202 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365996 392203 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365997 392204 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365998 392205 product 1123200 M 0 1123200
0 Untitled_design_-_2023-03-27T123605.449.png 600 600 N 3365999 392206 product 1123200 M 0 1123200