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 (
    3921, 3413, 3516, 3515, 3749, 3748, 3220, 
    3221, 3668, 4102, 4106, 3684, 4103, 
    3682, 7838, 7839, 7826, 7827, 7829, 
    7830, 7809, 7811, 7866, 7867, 7841, 
    7842, 7856, 8209, 7863, 7865
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00260

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "72.01"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "30.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": 30,
            "rows_produced_per_join": 30,
            "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 (3921,3413,3516,3515,3749,3748,3220,3221,3668,4102,4106,3684,4103,3682,7838,7839,7826,7827,7829,7830,7809,7811,7866,7867,7841,7842,7856,8209,7863,7865)))",
            "cost_info": {
              "read_cost": "18.01",
              "eval_cost": "3.00",
              "prefix_cost": "21.01",
              "data_read_per_join": "2K"
            },
            "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": 30,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "7.50",
              "eval_cost": "3.00",
              "prefix_cost": "31.51",
              "data_read_per_join": "23K"
            },
            "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": 30,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "7.50",
              "eval_cost": "3.00",
              "prefix_cost": "42.01",
              "data_read_per_join": "17K"
            },
            "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__64_.jpg 600 600 N N Y 17736 3220 product 13323 M 0 13323
0 Untitled_design__41__7mv2-uc.jpg 600 600 N N Y 18362 3413 product 13888 M 0 13888
0 Untitled_design__42__vfrd-1e.jpg 600 600 N N Y 18760 3515 product 14228 M 0 14228
0 dn6DhkkIPrp83znVRDvwx7FLf5B1EIcwyLxGdkB4.jpg 800 800 N N Y 18762 3516 product 14229 M 0 14229
0 Delivard_dweh-x4.jpg 900 900 N N Y 19440 3668 product 14840 M 0 14840
0 Delivard_mrta-ja.jpg 900 900 N N Y 19462 3682 product 14851 M 0 14851
0 Delivard_b2qs-fd.jpg 900 900 N N Y 19482 3684 product 14871 M 0 14871
0 Untitled_design__87_.jpg 600 600 N N Y 19653 3748 product 15009 M 0 15009
0 ec462b6b5fb7e62_WIZ010-BLK_MagSafe_BoostChargePro_2in1WirlessChargeDock_Back_WEB.jpg 700 700 N N Y 19655 3749 product 15010 M 0 15010
0 Untitled_design_-_2025-08-08T152913.751.jpg 600 600 N N Y 20249 3921 product 15399 M 0 15399
0 Delivard_dweh-x4.jpg 900 900 N N Y 20827 4102 product 14840 M 0 14840
0 Delivard_mrta-ja.jpg 900 900 N N Y 20850 4103 product 14851 M 0 14851
0 Delivard_b2qs-fd.jpg 900 900 N N Y 20856 4106 product 14871 M 0 14871
0 593d40331582eea1_CAB015-BLK_100W_USB-CtoUSB-C-Braided_Angled_WEB.jpg 700 700 N N Y 20922 3221 product 15928 M 0 15928
0 Untitled_design_n3xn-gc.jpg 900 900 N N Y 33852 7809 product 25544 M 0 25544
0 Untitled_design_pakn-vl.jpg 900 900 N N Y 33881 7826 product 25571 M 0 25571
0 Untitled_design_8qlt-xj.jpg 900 900 N N Y 33887 7829 product 25576 M 0 25576
0 Untitled_design_d4zn-8h.jpg 900 900 N N Y 33911 7838 product 25599 M 0 25599
0 b.jpg 900 900 N N Y 33915 7841 product 25602 M 0 25602
0 BLM91_tn1v-6h.jpg 900 900 N N Y 33931 7856 product 25617 M 0 25617
0 Untitled_design_8awa-m8.jpg 900 900 N N Y 33938 7863 product 25624 M 0 25624
0 Untitled_design_brui-oq.jpg 900 900 N N Y 33942 7866 product 25627 M 0 25627
0 Untitled_design_3x5b-tw.jpg 900 900 N N Y 33856 7811 product 25546 M 1 25546
0 Untitled_design_zo8a-df.jpg 900 900 N N Y 33883 7827 product 25572 M 1 25572
0 Untitled_design_pmwk-jg.jpg 900 900 N N Y 33889 7830 product 25577 M 1 25577
0 Untitled_design_bf8a-u7.jpg 900 900 N N Y 33913 7839 product 25600 M 1 25600
0 w.jpg 900 900 N N Y 33917 7842 product 25603 M 1 25603
0 Untitled_design_7lgy-hj.jpg 900 900 N N Y 33941 7865 product 25626 M 1 25626
0 Untitled_design_7uje-56.jpg 900 900 N N Y 33944 7867 product 25628 M 1 25628
0 BLM91_qqcx-ow_1g0c-rq.jpg 900 900 N N Y 34794 8209 product 26460 M 1 26460