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 (
    2768, 2767, 2761, 2762, 2763, 2764, 2760, 
    3164, 3165, 2752, 2753, 2754, 2755, 
    2756, 2757, 2746, 2747, 2749, 2750, 
    2751, 2742, 2743, 2744, 2745, 2739, 
    2740, 2741, 2737, 3255, 2729, 2730, 
    2731, 2732, 2723, 2724, 2725, 2726, 
    2719, 2728, 2714, 2715, 2716, 2717, 
    2708, 2709, 2710, 2704, 2705, 2706, 
    2702, 2703
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00319

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "122.41"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "51.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": 51,
            "rows_produced_per_join": 51,
            "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 (2768,2767,2761,2762,2763,2764,2760,3164,3165,2752,2753,2754,2755,2756,2757,2746,2747,2749,2750,2751,2742,2743,2744,2745,2739,2740,2741,2737,3255,2729,2730,2731,2732,2723,2724,2725,2726,2719,2728,2714,2715,2716,2717,2708,2709,2710,2704,2705,2706,2702,2703)))",
            "cost_info": {
              "read_cost": "30.61",
              "eval_cost": "5.10",
              "prefix_cost": "35.71",
              "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": [
              "softwarepirmam_hewadelivard_cscart_4.cscart_images_links.detailed_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 51,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "12.75",
              "eval_cost": "5.10",
              "prefix_cost": "53.56",
              "data_read_per_join": "39K"
            },
            "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": 51,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "12.75",
              "eval_cost": "5.10",
              "prefix_cost": "71.41",
              "data_read_per_join": "30K"
            },
            "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__9_.jpg 600 600 N N Y 16181 2704 product 12172 M 0 12172
0 FS5IM9zRBKDngQ27qNoXZntNxarX6QzkdrBMKQbG.jpg 800 800 N N Y 16185 2706 product 12173 M 0 12173
0 Y1VcaNkx2XLe8wHgw9j36itBf3bpdrvMIKNG3ByJ.jpg 800 800 N N Y 16186 2705 product 12174 M 0 12174
0 Delivard_Product_Images__10_.jpg 600 600 N N Y 16190 2708 product 12175 M 0 12175
0 79Fin2iUha8p2PgV25LNTjLbbGtObCIrJK0qYPk6.jpg 800 800 N N Y 16194 2710 product 12176 M 0 12176
0 RahprXlMdlHooKClkXapCKx7kgY26Ccig7M5hfMA.jpg 800 800 N N Y 16195 2709 product 12177 M 0 12177
0 Delivard_Product_Images__11_.jpg 600 600 N N Y 16199 2714 product 12178 M 0 12178
0 6YSFVf11k4XOVbP13xBfDYxy1QoHpb8ZFYabWD0L.jpg 800 800 N N Y 16205 2717 product 12179 M 0 12179
0 HFTOiTcUeuVH6TRRPE3i27gkcUjtTxcgtlJP04wz.jpg 800 800 N N Y 16207 2716 product 12180 M 0 12180
0 B0BVaglCi5oA7IcOdtV3VLOG5IiTHjaDIy1e5EAO.jpg 800 800 N N Y 16209 2715 product 12181 M 0 12181
0 Delivard_Product_Images__13_.jpg 600 600 N N Y 16220 2723 product 12187 M 0 12187
0 sjKYZw1j6xFrCpO99vve4vnEm1qgPqZ7KBHGnf1D.jpg 800 800 N N Y 16226 2726 product 12188 M 0 12188
0 tBOfnLihduuJvH46bs8aPfyOpLm7JHZu2R9jc5HX.jpg 800 800 N N Y 16228 2725 product 12189 M 0 12189
0 VOhiW3brHSGyaGvs4fKFSv0cMjCwcBTGkK7ZNNzf.jpg 800 800 N N Y 16230 2724 product 12190 M 0 12190
0 Delivard_Product_Images__14_.jpg 600 600 N N Y 16236 2729 product 12191 M 0 12191
0 w2abR0ZyRnzZm564vxiKFd2b01TMCu9JVekilJ8G.webp 800 800 N N Y 16241 2731 product 12192 M 0 12192
0 qUwo97QJVUOMvZk04pYB6KWy8kivmuqogiWLlXhq.webp 800 800 N N Y 16245 2732 product 12193 M 0 12193
0 OVK803Ho2030GBcknPnc9JgxlTuTamgW1YN8VA4m.webp 800 800 N N Y 16246 2730 product 12194 M 0 12194
0 Delivard_Product_Images__18_.jpg 600 600 N N Y 16380 2739 product 12323 M 0 12323
0 eF1iGCjcudOKJxzrZc4LjKpjQohdDJcjC0GZGem6.jpg 800 800 N N Y 16384 2741 product 12324 M 0 12324
0 vcx9eWF7ElrlVsg0bhL8JHsCjqOV2pKApvIUGmWO.jpg 800 800 N N Y 16385 2740 product 12325 M 0 12325
0 Delivard_Product_Images__19_.jpg 600 600 N N Y 16401 2742 product 12338 M 0 12338
0 93NRDe12jbwjvhnuzRMFHnOfgepXFUAXkJxdM4Ev.jpg 800 800 N N Y 16406 2743 product 12339 M 0 12339
0 Delivard_Product_Images__22_.jpg 600 600 N N Y 16481 2746 product 12398 M 0 12398
0 Delivard_Product_Images__21__w0dv-6r.jpg 600 600 N N Y 16490 2749 product 12407 M 0 12407
0 Dn9Yif52TUNZhoObY1eXDLPzBwlrT1kMjFIteDdU_flq3-om.webp 800 800 N N Y 16491 2750 product 12408 M 0 12408
0 qEdVufaKIitBLEgHRJN4m2yCX8MlQjeHVCmP7vbF_kdsy-4n.webp 800 800 N N Y 16492 2751 product 12409 M 0 12409
0 Delivard_Product_Images__23_.jpg 600 600 N N Y 16505 2752 product 12422 M 0 12422
0 13HTySTBuBzrAJmplpSDUwhD6br3Er9xMYleSCQW.webp 800 800 N N Y 16515 2756 product 12423 M 0 12423
0 A8jgQZjQ8PJojtPZjO4pdfUwLTL2ZJtI9DVqYsSp.webp 800 800 N N Y 16517 2753 product 12424 M 0 12424
0 DRPuSilWTQg0Jq2fzyr8IUUW5UatxZDQhBimix1g.webp 800 800 N N Y 16523 2754 product 12425 M 0 12425
0 fzEPD7fvMTA6VuHJ7FZNJRV5aLYtIXYJTlOHWiRX.webp 800 800 N N Y 16529 2755 product 12426 M 0 12426
0 Pmw6gsqmFsbN1Bc7vQlvZGBQP2xOPJ69KwTHCZ92.webp 800 800 N N Y 16536 2757 product 12427 M 0 12427
0 Delivard_Product_Images__25_.jpg 600 600 N N Y 16543 2761 product 12430 M 0 12430
0 02.JBL_Live_670NC_Product_Image_Front_Black.png 1605 1605 N N Y 16548 2763 product 12431 M 0 12431
0 02.JBL_Live_670NC_Product_Image_Front_Blue.png 680 680 N N Y 16552 2764 product 12432 M 0 12432
0 02.JBL_Live_670NC_Product_Image_Front_White.png 680 680 N N Y 16553 2762 product 12433 M 0 12433
0 Delivard_Product_Images__28_.jpg 600 600 N N Y 16561 2767 product 12436 M 0 12436
0 4xsZLObBF9r87xr0oitpr9wYQMrkHNNsRA4MLZrp.jpg 800 800 N N Y 16563 2768 product 12437 M 0 12437
0 Untitled_design_-_2025-07-20T115237.340.jpg 600 600 N N Y 17662 2760 product 13253 M 0 13253
0 Untitled_design_-_2025-07-20T115325.037_4pv5-im.jpg 600 600 N N Y 17665 3164 product 13256 M 0 13256
0 Untitled_design_-_2025-07-20T115417.730_svia-s6.jpg 600 600 N N Y 17668 3165 product 13259 M 0 13259
0 Untitled_design_-_2025-07-20T144309.388_df29-q1.jpg 600 600 N N Y 17804 2728 product 13379 M 0 13379
0 Untitled_design__79__y520-pa.jpg 600 600 N N Y 19176 2744 product 14615 M 0 14615
0 Untitled_design__80__o4dj-1w.jpg 600 600 N N Y 19178 2745 product 14617 M 0 14617
0 01__1_.webp 680 680 N N Y 19185 2747 product 14624 M 0 14624
0 Untitled_design_-_2025-08-04T184925.896.jpg 600 600 N N Y 19428 2702 product 14828 M 0 14828
0 Untitled_design_-_2025-08-04T184949.041_fgwm-xt.jpg 600 600 N N Y 19430 2703 product 14830 M 0 14830
0 Untitled_design_-_2025-08-07T095645.052.jpg 600 600 N N Y 20052 2737 product 15260 M 0 15260
0 Untitled_design_-_2025-08-07T095712.032_1gyx-so.jpg 600 600 N N Y 20054 3255 product 15262 M 0 15262
0 Untitled_design_-_2025-07-20T144006.058.jpg 600 600 N N Y 17794 2719 product 13369 M 2 13369