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 = 'ar' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    6208, 6209, 6210, 6242, 6540, 6541, 6542, 
    6205, 6527, 6528, 6529, 6530, 6214, 
    6216, 6217
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00164

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "36.01"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "15.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": 15,
            "rows_produced_per_join": 15,
            "filtered": "100.00",
            "index_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`object_type` = 'product') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`type` = 'M') and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_images_links`.`object_id` in (6208,6209,6210,6242,6540,6541,6542,6205,6527,6528,6529,6530,6214,6216,6217)))",
            "cost_info": {
              "read_cost": "9.01",
              "eval_cost": "1.50",
              "prefix_cost": "10.51",
              "data_read_per_join": "1K"
            },
            "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": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 15,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "3.75",
              "eval_cost": "1.50",
              "prefix_cost": "15.76",
              "data_read_per_join": "11K"
            },
            "used_columns": [
              "image_id",
              "image_path",
              "image_x",
              "image_y",
              "is_high_res",
              "transparent",
              "cp_in_opt_list"
            ]
          }
        },
        {
          "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": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_images.image_id",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 15,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "3.75",
              "eval_cost": "1.50",
              "prefix_cost": "21.01",
              "data_read_per_join": "8K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}

Result

image_id image_path image_x image_y is_high_res transparent cp_in_opt_list pair_id object_id object_type detailed_id type position alt images_image_id
0 cc_-_2025-10-05T204118.036.jpg 600 600 N N Y 29330 6205 product 21527 M 0 21527
0 cc_-_2025-10-05T212443.264.jpg 600 600 N N Y 29338 6208 product 21535 M 0 21535
0 cc_-_2025-10-05T220714.191.jpg 600 600 N N Y 29341 6209 product 21536 M 0 21536
0 cc_-_2025-10-05T220807.246.jpg 600 600 N N Y 29344 6210 product 21537 M 0 21537
0 cc_-_2025-10-05T225729.395.jpg 600 600 N N Y 29376 6214 product 21551 M 0 21551
0 cc_-_2025-10-05T225742.505.jpg 600 600 N N Y 29399 6216 product 21553 M 0 21553
0 cc_-_2025-10-05T230604.028.jpg 600 600 N N Y 29404 6217 product 21555 M 0 21555
0 cc_-_2025-10-18T125031.824.jpg 600 600 N N Y 30473 6529 product 22397 M 0 22397
0 cc_-_2025-10-18T130336.035.jpg 600 600 N N Y 30484 6528 product 22400 M 0 22400
0 cc_-_2025-10-18T130600.735.jpg 600 600 N N Y 30495 6527 product 22407 M 0 22407
0 cc_-_2025-10-18T131222.523.jpg 600 600 N N Y 30510 6530 product 22410 M 0 22410
0 cc_-_2025-10-18T140230.902.jpg 600 600 N N Y 30547 6242 product 22439 M 0 22439
0 cc_-_2025-10-18T135411.121.jpg 600 600 N N Y 30559 6541 product 22441 M 0 22441
0 cc_-_2025-10-18T135344.843.jpg 600 600 N N Y 30566 6542 product 22443 M 0 22443
0 cc_-_2025-10-18T140601.505_8bm1-s0.jpg 600 600 N N Y 30570 6540 product 22445 M 0 22445