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 (
    6780, 6944, 7608, 7279, 7285, 7620, 7619, 
    7618, 7617, 2649, 2650, 4654, 4653, 
    4652, 4651, 2828, 2830, 2831, 7615, 
    7281
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00192

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "48.01"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "20.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": 20,
            "rows_produced_per_join": 20,
            "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 (6780,6944,7608,7279,7285,7620,7619,7618,7617,2649,2650,4654,4653,4652,4651,2828,2830,2831,7615,7281)))",
            "cost_info": {
              "read_cost": "12.01",
              "eval_cost": "2.00",
              "prefix_cost": "14.01",
              "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": 20,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "5.00",
              "eval_cost": "2.00",
              "prefix_cost": "21.01",
              "data_read_per_join": "15K"
            },
            "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": 20,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "5.00",
              "eval_cost": "2.00",
              "prefix_cost": "28.01",
              "data_read_per_join": "11K"
            },
            "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 Delivard_Product_Images_-_2025-07-09T114934.856.jpg 600 600 N N Y 15840 2649 product 11920 M 0 11920
0 Delivard_Product_Images_-_2025-07-09T114934.856.jpg 600 600 N N Y 15847 2650 product 11920 M 0 11920
0 Untitled_design_-_2025-08-07T074708.580.jpg 600 600 N N Y 20013 2828 product 15222 M 0 15222
0 Untitled_design_-_2025-08-07T074736.908_mfsi-08.jpg 600 600 N N Y 20016 2830 product 15225 M 0 15225
0 Untitled_design_-_2025-08-07T074647.421_h83l-vd.jpg 600 600 N N Y 20019 2831 product 15228 M 0 15228
0 restaurant_kurdish_certificate.jpg 900 900 N N Y 23399 4651 product 17589 M 0 17589
0 GSP65__Black_.jpg 900 900 N N Y 31122 6780 product 22949 M 0 22949
0 43A6500N__4_.jpg 854 529 N N Y 33124 7620 product 24818 M 0 24818
0 50A6500N__5_.jpg 854 529 N N Y 33150 7617 product 24844 M 0 24844
0 65A6500N__2_.jpg 854 529 N N Y 33217 7619 product 24911 M 0 24911
0 75A6500N__5_.jpg 854 529 N N Y 33285 7285 product 24979 M 0 24979
0 kurdish_certificate_clean.jpg 900 900 N N Y 23403 4652 product 17590 M 1 17590
0 Delivard2.jpg 900 900 N N Y 23404 4653 product 17591 M 1 17591
0 Delivard_7au5-81.jpg 900 900 N N Y 23405 4654 product 17592 M 1 17592
0 4_317x-o6.jpg 600 600 N N Y 35794 7279 product 27411 M 1 27411
0 5_b50a-03.jpg 600 600 N N Y 35795 7608 product 27412 M 1 27412
0 6_fhul-dc.jpg 600 600 N N Y 35796 7281 product 27413 M 1 27413
0 7_4hg3-o0.jpg 600 600 N N Y 35797 7615 product 27414 M 1 27414
0 Kenwood-Garment-Steamer-1500-Watt-White-GSP65.jpg 800 800 N N Y 31475 6944 product 23297 M 2 23297
0 55A6500N__1_.jpg 854 529 N N Y 33181 7618 product 24875 M 2 24875