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 = 'ar' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    6149, 5685, 6148, 6150, 6151, 5721, 5722, 
    5723, 5724, 5725, 5726, 5944, 5945, 
    5946, 5947, 6119, 6120, 6121, 6122, 
    6123, 6124, 6125, 6026, 6025, 6027, 
    6028, 6029, 6030, 5683, 6152, 6153, 
    6154, 6155, 6054, 6055, 6056, 6057, 
    6058, 6059, 6041, 6042, 6043, 6044, 
    6045, 6046, 6047, 5948, 6128, 6127, 
    6126, 6129, 6130, 6131, 6132, 6133, 
    6134, 6135, 6048, 6049, 6050, 6051, 
    6052, 6053, 5952, 6138, 6137, 6136, 
    6139, 6140, 6141, 6142, 6143, 6171, 
    6172, 6173, 6174, 6175, 6176, 6177, 
    6031, 6032, 6033, 6034, 6035, 6164, 
    6165, 6166, 6167, 6168, 6169, 6170, 
    6156, 6157, 6158, 6159, 6110, 6111, 
    6069, 6070, 6071, 6036, 6037, 6038, 
    6039, 6040, 6178, 6179, 6180, 6181, 
    6182, 6183, 6184, 6094, 6095
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00861

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "273.61"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "114.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": 114,
            "rows_produced_per_join": 114,
            "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 (6149,5685,6148,6150,6151,5721,5722,5723,5724,5725,5726,5944,5945,5946,5947,6119,6120,6121,6122,6123,6124,6125,6026,6025,6027,6028,6029,6030,5683,6152,6153,6154,6155,6054,6055,6056,6057,6058,6059,6041,6042,6043,6044,6045,6046,6047,5948,6128,6127,6126,6129,6130,6131,6132,6133,6134,6135,6048,6049,6050,6051,6052,6053,5952,6138,6137,6136,6139,6140,6141,6142,6143,6171,6172,6173,6174,6175,6176,6177,6031,6032,6033,6034,6035,6164,6165,6166,6167,6168,6169,6170,6156,6157,6158,6159,6110,6111,6069,6070,6071,6036,6037,6038,6039,6040,6178,6179,6180,6181,6182,6183,6184,6094,6095)))",
            "cost_info": {
              "read_cost": "68.41",
              "eval_cost": "11.40",
              "prefix_cost": "79.81",
              "data_read_per_join": "10K"
            },
            "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": 114,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "28.50",
              "eval_cost": "11.40",
              "prefix_cost": "119.71",
              "data_read_per_join": "88K"
            },
            "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": 114,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "28.50",
              "eval_cost": "11.40",
              "prefix_cost": "159.61",
              "data_read_per_join": "67K"
            },
            "used_columns": [
              "object_id",
              "description",
              "lang_code",
              "object_holder"
            ]
          }
        }
      ]
    }
  }
}