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 (
    2603, 2609, 2610, 2611, 2587, 2588, 2589, 
    2590, 2761, 2762, 2763, 2764, 2696, 
    2697, 2695, 2694, 2723, 2724, 2725, 
    2726, 2742, 2743, 2744, 2745, 2593, 
    2594, 2595, 2617, 2618, 2613, 2614, 
    2872, 2873, 2874, 2875, 2704, 2705, 
    2706, 3423, 3422, 2739, 2740, 2741, 
    2865, 2866, 2867
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00284

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "110.41"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "46.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": 46,
            "rows_produced_per_join": 46,
            "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 (2603,2609,2610,2611,2587,2588,2589,2590,2761,2762,2763,2764,2696,2697,2695,2694,2723,2724,2725,2726,2742,2743,2744,2745,2593,2594,2595,2617,2618,2613,2614,2872,2873,2874,2875,2704,2705,2706,3423,3422,2739,2740,2741,2865,2866,2867)))",
            "cost_info": {
              "read_cost": "27.61",
              "eval_cost": "4.60",
              "prefix_cost": "32.21",
              "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": 46,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "11.50",
              "eval_cost": "4.60",
              "prefix_cost": "48.31",
              "data_read_per_join": "35K"
            },
            "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": 46,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "11.50",
              "eval_cost": "4.60",
              "prefix_cost": "64.41",
              "data_read_per_join": "27K"
            },
            "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_aaun-s3.jpg 600 600 N N Y 15675 2587 product 11846 M 0 11846
0 8bYSfQZpkjreDQz8QH3ifbaDz1tIMXs5qjdOinAp.webp 800 800 N N Y 15678 2588 product 11845 M 0 11845
0 2qgjA0eDdxKAJbukZ5Tkdt3DZgwxqFgaKKnyjtv3.webp 800 800 N N Y 15683 2590 product 11848 M 0 11848
0 s25AKOZZQZMJ2tMd1f4YBSL81qn2seMMoepEuBnu.webp 800 800 N N Y 15685 2589 product 11847 M 0 11847
0 Delivard_Product_Images__2__30gx-d3.jpg 600 600 N N Y 15693 2593 product 11850 M 0 11850
0 q6HyasVb214SC4nNDQA2ByEywdT355xoHvSrWKEQ_dubs-pn.jpg 800 800 N N Y 15697 2594 product 11854 M 0 11854
0 xjr3fkx1FVgLZuqoJR1n3Uksrcwj3VJKs3AIvzDM_uwe1-cv.jpg 800 800 N N Y 15700 2595 product 11857 M 0 11857
0 Delivard_Product_Images__3__bb08-gw.jpg 600 600 N N Y 15714 2603 product 11866 M 0 11866
0 O6yAHpckPl1J3y0AqsfKrLJCfpN9KoVBFLuDwSRT.jpg 800 800 N N Y 15726 2610 product 11869 M 0 11869
0 Jv0wArPpwsS12706XPyL2ezEE3o8eA68RhiSPJeL.jpg 800 800 N N Y 15728 2609 product 11868 M 0 11868
0 cLOSVJLib9Dslj89yJqbSOkrgWIs38bo68CW7Sw3.jpg 800 800 N N Y 15733 2611 product 11867 M 0 11867
0 Delivard_Product_Images__4__p6hr-h3.jpg 600 600 N N Y 15742 2614 product 11874 M 0 11874
0 Delivard_Product_Images__5_.jpg 600 600 N N Y 15744 2613 product 11877 M 0 11877
0 Delivard_Product_Images__5__b00i-x4.jpg 600 600 N N Y 15745 2617 product 11878 M 0 11878
0 KcaOmHtbCrMgAgV9k2JAwmfIFr3bi8n1DJyrPsz1.jpg 800 800 N N Y 15747 2618 product 11879 M 0 11879
0 Delivard_Product_Images__6_.jpg 600 600 N N Y 16163 2694 product 12166 M 0 12166
0 fNkQ9J5W009ClLw4pANVQdcsL2PoPlBdMCSlDmkj__1_.jpg 800 800 N N Y 16168 2696 product 12167 M 0 12167
0 ra5O1kzyPp8jv38jEXw72rUnBuinC05apnIBPzzg.jpg 800 800 N N Y 16172 2697 product 12168 M 0 12168
0 6E2h3u4FLfZa9cpGPNRacSeVsYS7oUDwAmBXqQEP.jpg 800 800 N N Y 16173 2695 product 12169 M 0 12169
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__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__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__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__53_.jpg 600 600 N N Y 16754 2865 product 12531 M 0 12531
0 uB6lmUhfNHniglB6DllX9sftUDpl4hJWAoXU3lgB.jpg 800 800 N N Y 16757 2866 product 12532 M 0 12532
0 2h31e03TK6O92dgKMY3HxzuJa56eTgBuqpcAYtNX.jpg 800 800 N N Y 16760 2867 product 12533 M 0 12533
0 Delivard_Product_Images__56_.jpg 600 600 N N Y 16773 2872 product 12538 M 0 12538
0 j1bhXeP6V4ALQKUi7oBrFJgJdKlUKbzCGm1X10ei.jpg 800 800 N N Y 16778 2874 product 12539 M 0 12539
0 QX2XSelsp5JM0es9FAqr6XaTN8nuHUlGdBavktI7.jpg 800 800 N N Y 16782 2875 product 12540 M 0 12540
0 8WXg6lw7IfvSHAmJbZNFviI4DP5DIDRylfXm9pCi.jpg 800 800 N N Y 16783 2873 product 12541 M 0 12541
0 77XhA1mvMVAfSrFufD2lV67gIOxyDOIor7fhugWX_0q53-7l.jpg 800 800 N N Y 18415 3422 product 13929 M 0 13929
0 Delivard_Product_Images__5__1bbx-4g.jpg 600 600 N N Y 18417 3423 product 13928 M 0 13928
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