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 (
    1542, 1543, 1540, 1541, 8495, 1538, 8496, 
    8500, 1532, 8502, 8501, 8499, 8504, 
    1528, 8505, 8503, 1517, 8498, 8497, 
    1428, 1261, 1426, 1430, 1429, 1406, 
    1265, 1408, 1411, 1407, 1323, 1319, 
    1318, 1262, 1317, 1284, 1477, 1475, 
    1274, 1485, 1483, 1484, 1273, 1421, 
    1423, 1420, 1266, 1439, 1442, 1447, 
    1445, 1446, 1263, 1454, 1456, 1458, 
    1453, 1256, 1397, 1395, 1396, 1146, 
    1145, 1144, 1143, 856, 1134, 827, 1139, 
    1138, 1137, 1136, 1135, 1126, 1123, 
    1128, 1127, 996, 993, 493, 985, 990, 
    987, 986, 952, 446, 948, 944, 947, 946, 
    945, 908, 134, 1142, 853
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00445

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "251.41"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "106.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": 106,
            "rows_produced_per_join": 106,
            "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 (1542,1543,1540,1541,8495,1538,8496,8500,1532,8502,8501,8499,8504,1528,8505,8503,1517,8498,8497,1428,1261,1426,1430,1429,1406,1265,1408,1411,1407,1323,1319,1318,1262,1317,1284,1477,1475,1274,1485,1483,1484,1273,1421,1423,1420,1266,1439,1442,1447,1445,1446,1263,1454,1456,1458,1453,1256,1397,1395,1396,1146,1145,1144,1143,856,1134,827,1139,1138,1137,1136,1135,1126,1123,1128,1127,996,993,493,985,990,987,986,952,446,948,944,947,946,945,908,134,1142,853)))",
            "cost_info": {
              "read_cost": "60.61",
              "eval_cost": "10.60",
              "prefix_cost": "71.21",
              "data_read_per_join": "9K"
            },
            "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": 106,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "26.50",
              "eval_cost": "10.60",
              "prefix_cost": "108.31",
              "data_read_per_join": "81K"
            },
            "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": 106,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "26.50",
              "eval_cost": "10.60",
              "prefix_cost": "145.41",
              "data_read_per_join": "62K"
            },
            "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 Jet_Black.jpg 600 600 N N Y 9054 827 product 9423 M 0 9423
0 Black_0cz2-5o.jpg 800 800 N N Y 9219 856 product 9486 M 0 9486
0 Desert_Titanium_pm5s-n1.jpg 600 600 N N Y 9263 446 product 9510 M 0 9510
0 Ultramarine.jpg 600 600 N N Y 9269 493 product 9516 M 0 9516
0 5_iydv-yb.jpg 600 600 N N Y 9578 908 product 9640 M 0 9640
0 White_Titanium_chpz-ig.jpg 600 600 N N Y 9708 948 product 9512 M 0 9512
0 Black_Titanium_ft32-2i.jpg 600 600 N N Y 9727 952 product 9513 M 0 9513
0 Natural_Titanium_ruz8-dh.jpg 600 600 N N Y 9734 944 product 9511 M 0 9511
0 Natural_Titanium_ruz8-dh.jpg 600 600 N N Y 9735 945 product 9511 M 0 9511
0 Natural_Titanium_ruz8-dh.jpg 600 600 N N Y 9736 946 product 9511 M 0 9511
0 Natural_Titanium_ruz8-dh.jpg 600 600 N N Y 9737 947 product 9511 M 0 9511
0 Pink_73jt-z0.jpg 600 600 N N Y 9901 993 product 9514 M 0 9514
0 Teal.jpg 600 600 N N Y 9912 990 product 9515 M 0 9515
0 White_sbj5-2g.jpg 600 600 N N Y 9932 996 product 9517 M 0 9517
0 Black_t5e8-5f.jpg 600 600 N N Y 9935 985 product 9518 M 0 9518
0 Black_t5e8-5f.jpg 600 600 N N Y 9936 986 product 9518 M 0 9518
0 Black_t5e8-5f.jpg 600 600 N N Y 9937 987 product 9518 M 0 9518
0 Midnight_k4ww-ea.jpg 600 600 N N Y 10434 1123 product 9689 M 0 9689
0 Silver_7nrx-20.jpg 600 600 N N Y 10441 1128 product 9691 M 0 9691
0 Starlight_v5ip-pe.jpg 600 600 N N Y 10445 1127 product 9690 M 0 9690
0 Midnight_k4ww-ea.jpg 600 600 N N Y 10449 1126 product 9689 M 0 9689
0 Jet_Black.jpg 600 600 N N Y 10457 1134 product 9423 M 0 9423
0 Rose_Gold.jpg 600 600 N N Y 10469 1135 product 9422 M 0 9422
0 Gold.jpg 600 600 N N Y 10482 1137 product 9424 M 0 9424
0 Natural.jpg 600 600 N N Y 10494 1138 product 9425 M 0 9425
0 Slate.jpg 600 600 N N Y 10503 1136 product 9426 M 0 9426
0 Silver_tdhu-1r.jpg 600 600 N N Y 10517 1139 product 9421 M 0 9421
0 Airpods_4-Cancellations.jpg 600 600 N N Y 10522 1142 product 9547 M 0 9547
0 Purple_iwo7-td.jpg 800 800 N N Y 10525 1144 product 9485 M 0 9485
0 Starlight_6fdc-h3.jpg 800 800 N N Y 10534 1145 product 9487 M 0 9487
0 Orange.jpg 800 800 N N Y 10539 1146 product 9488 M 0 9488
0 Blue_z0co-tp.jpg 800 800 N N Y 10540 1143 product 9484 M 0 9484
0 Black_czso-u6.jpg 600 600 N N Y 11128 1256 product 9992 M 0 9992
0 Goegeous_Ice_Blue.jpg 600 600 N N Y 11145 1261 product 10009 M 0 10009
0 Delivard_Product_Images_-_2025-04-09T161942.131.jpg 600 600 N N Y 11150 1262 product 10014 M 0 10014
0 Amber_Yellow_pjew-6x.jpg 600 600 N N Y 11153 1263 product 10017 M 0 10017
0 Black_Gray.jpg 600 600 N N Y 11163 1265 product 10027 M 0 10027
0 Black_Titanium.jpg 600 600 N N Y 11166 1266 product 10030 M 0 10030
0 Shiny_Silver_hmtp-eq.jpg 600 600 N N Y 11194 1273 product 10058 M 0 10058
0 Graphite.jpg 600 600 N N Y 11200 1274 product 10064 M 0 10064
0 Silver_8pzk-4i.jpg 600 600 N N Y 11227 1284 product 10091 M 0 10091
0 Delivard_Product_Images_-_2025-04-09T161902.586.jpg 600 600 N N Y 11452 1317 product 10015 M 0 10015
0 Delivard_Product_Images_-_2025-04-09T161752.003.jpg 600 600 N N Y 11461 1319 product 10016 M 0 10016
0 Delivard_Product_Images_-_2025-04-09T161752.003.jpg 600 600 N N Y 11465 1323 product 10016 M 0 10016
0 Delivard_Product_Images_-_2025-04-09T161825.475.jpg 600 600 N N Y 11467 1318 product 10013 M 0 10013
0 Light_Blue.jpg 600 600 N N Y 11726 1396 product 9993 M 0 9993
0 Golden.jpg 600 600 N N Y 11731 1395 product 9994 M 0 9994
0 Black_czso-u6.jpg 600 600 N N Y 11739 1397 product 9992 M 0 9992
0 Sky_Blue.jpg 600 600 N N Y 11777 1408 product 10026 M 0 10026
0 Marble_Gray_seyz-xm.jpg 600 600 N N Y 11787 1411 product 10028 M 0 10028
0 Mint_cgju-pq.jpg 600 600 N N Y 11796 1406 product 10025 M 0 10025
0 Mint_cgju-pq.jpg 600 600 N N Y 11797 1407 product 10025 M 0 10025
0 Shiny_Silver_hmtp-eq.jpg 600 600 N N Y 11831 1420 product 10058 M 0 10058
0 Pink.jpg 600 600 N N Y 11839 1423 product 10057 M 0 10057
0 Navy_Blue_z0z9-sx.jpg 600 600 N N Y 11842 1421 product 10056 M 0 10056
0 Wonderfull_lilac.jpg 600 600 N N Y 11851 1430 product 10011 M 0 10011
0 Gorgeos_lemoun.jpg 600 600 N N Y 11854 1426 product 10010 M 0 10010
0 Wanderfull_Navy.jpg 600 600 N N Y 11863 1428 product 10012 M 0 10012
0 Wanderfull_Navy.jpg 600 600 N N Y 11864 1429 product 10012 M 0 10012
0 Yellow_Titanium.jpg 600 600 N N Y 11905 1442 product 10032 M 0 10032
0 Gray_Titanium.jpg 600 600 N N Y 11921 1447 product 10031 M 0 10031
0 Black_Titanium.jpg 600 600 N N Y 11930 1445 product 10030 M 0 10030
0 Black_Titanium.jpg 600 600 N N Y 11931 1446 product 10030 M 0 10030
0 Purple_Titanium.jpg 600 600 N N Y 11935 1439 product 10029 M 0 10029
0 Marble_Gray_0ieq-xe.jpg 600 600 N N Y 11963 1458 product 10019 M 0 10019
0 Onyx_Black_cxhz-yi.jpg 600 600 N N Y 11968 1456 product 10020 M 0 10020
0 Cobalt_Purple_2w2z-cu.jpg 600 600 N N Y 11973 1454 product 10018 M 0 10018
0 Amber_Yellow_pjew-6x.jpg 600 600 N N Y 11979 1453 product 10017 M 0 10017
0 Black_g05v-0t.jpg 600 600 N N Y 12035 1475 product 10092 M 0 10092
0 Silver_8pzk-4i.jpg 600 600 N N Y 12040 1477 product 10091 M 0 10091
0 Silver.jpg 600 600 N N Y 12058 1483 product 10065 M 0 10065
0 Silver.jpg 600 600 N N Y 12060 1485 product 10065 M 0 10065
0 Navy.jpg 600 600 N N Y 12064 1484 product 10066 M 0 10066
0 1_pckf-a1.jpg 600 600 N N Y 12152 1517 product 10267 M 0 10267
0 1_x4br-7v.jpg 600 600 N N Y 12213 1528 product 10262 M 0 10262
0 1_9f1w-pk.jpg 600 600 N N Y 12237 1532 product 10282 M 0 10282
0 1_prgj-wi.jpg 600 600 N N Y 12260 1538 product 10277 M 0 10277
0 Graphite_bcz3-ny.jpg 600 600 N N Y 12262 1540 product 10297 M 0 10297
0 White_ziu7-tb.jpg 600 600 N N Y 12264 1541 product 10298 M 0 10298
0 White_wfsk-mv.jpg 600 600 N N Y 12266 1542 product 10299 M 0 10299
0 Silver_weiv-9w.jpg 600 600 N N Y 12268 1543 product 10300 M 0 10300
0 1_prgj-wi.jpg 600 600 N N Y 36003 8495 product 10277 M 0 10277
0 1_prgj-wi.jpg 600 600 N N Y 36004 8496 product 10277 M 0 10277
0 1_pckf-a1.jpg 600 600 N N Y 36013 8497 product 10267 M 0 10267
0 1_pckf-a1.jpg 600 600 N N Y 36014 8498 product 10267 M 0 10267
0 1_9f1w-pk.jpg 600 600 N N Y 36031 8499 product 10282 M 0 10282
0 1_9f1w-pk.jpg 600 600 N N Y 36032 8500 product 10282 M 0 10282
0 1_9f1w-pk.jpg 600 600 N N Y 36033 8501 product 10282 M 0 10282
0 1_9f1w-pk.jpg 600 600 N N Y 36034 8502 product 10282 M 0 10282
0 1_x4br-7v.jpg 600 600 N N Y 36047 8503 product 10262 M 0 10262
0 1_x4br-7v.jpg 600 600 N N Y 36048 8504 product 10262 M 0 10262
0 1_x4br-7v.jpg 600 600 N N Y 36049 8505 product 10262 M 0 10262
0 4_544t-2l.jpg 600 600 N N Y 9436 134 product 9639 M 1 9639
0 Airpods_4.jpg 600 600 N N Y 9299 853 product 9546 M 2 9546