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 (
    5750, 
    5752, 
    5755, 
    5758, 
    5761, 
    5762, 
    7013, 
    7005, 
    7009, 
    7004, 
    7014, 
    7015, 
    5739, 
    5741, 
    5742, 
    5743, 
    5744, 
    5747, 
    5727, 
    5730, 
    5733, 
    5735, 
    5736, 
    4432, 
    4440, 
    4443, 
    4446, 
    4438, 
    4439, 
    8422, 
    2574, 
    1254, 
    1253, 
    247, 
    952, 
    446, 
    948, 
    944, 
    947, 
    946, 
    945, 
    981, 
    978, 
    478, 
    975, 
    970, 
    973, 
    974, 
    996, 
    993, 
    493, 
    985, 
    990, 
    987, 
    986, 
    3754, 
    3758, 
    3762, 
    3755, 
    3756, 
    3757, 
    918, 
    924, 
    921, 
    525, 
    916, 
    917, 
    2478, 
    2486, 
    2489, 
    2483, 
    2482, 
    10284, 
    10286, 
    10288, 
    10290, 
    10292, 
    10285, 
    6149, 
    5685, 
    6148, 
    6150, 
    6151, 
    1274, 
    1485, 
    1483, 
    1484, 
    908, 
    134, 
    1930, 
    3815, 
    3817, 
    3814, 
    3452, 
    3454, 
    3455, 
    3456, 
    2524, 
    2527, 
    2525, 
    2526, 
    2528, 
    1134, 
    827, 
    1139, 
    1138, 
    1137, 
    1136, 
    1135, 
    5696, 
    5697, 
    5698, 
    5699, 
    4022, 
    4021, 
    4020, 
    2490, 
    2492, 
    2494, 
    2496, 
    2497, 
    2698, 
    1406, 
    1265, 
    1408, 
    1411, 
    1407, 
    5721, 
    5722, 
    5723
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00795

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "355.01"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "150.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": 150,
            "rows_produced_per_join": 150,
            "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 (5750,5752,5755,5758,5761,5762,7013,7005,7009,7004,7014,7015,5739,5741,5742,5743,5744,5747,5727,5730,5733,5735,5736,4432,4440,4443,4446,4438,4439,8422,2574,1254,1253,247,952,446,948,944,947,946,945,981,978,478,975,970,973,974,996,993,493,985,990,987,986,3754,3758,3762,3755,3756,3757,918,924,921,525,916,917,2478,2486,2489,2483,2482,10284,10286,10288,10290,10292,10285,6149,5685,6148,6150,6151,1274,1485,1483,1484,908,134,1930,3815,3817,3814,3452,3454,3455,3456,2524,2527,2525,2526,2528,1134,827,1139,1138,1137,1136,1135,5696,5697,5698,5699,4022,4021,4020,2490,2492,2494,2496,2497,2698,1406,1265,1408,1411,1407,5721,5722,5723)))",
            "cost_info": {
              "read_cost": "85.01",
              "eval_cost": "15.00",
              "prefix_cost": "100.01",
              "data_read_per_join": "14K"
            },
            "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": 150,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "37.50",
              "eval_cost": "15.00",
              "prefix_cost": "152.51",
              "data_read_per_join": "116K"
            },
            "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": 150,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "37.50",
              "eval_cost": "15.00",
              "prefix_cost": "205.01",
              "data_read_per_join": "89K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}