Subquery mysql with where clause, MySQL

Language: Layout:

DROP TABLE IF EXISTS detail_order;
DROP TABLE IF EXISTS ket_detail;
DROP TABLE IF EXISTS t_size;
DROP TABLE IF EXISTS t_color;

CREATE TABLE detail_order
    (`id_detail` int, `id_order` int, `id_toko` int)
;
    
INSERT INTO detail_order
    (`id_detail`, `id_order`, `id_toko`)
VALUES
    (1, 1, 1),
    (2, 1, 2),
    (3, 1, 3),
    (4, 1, 4)
;

CREATE TABLE ket_detail
    (`id_ket` int, `id_detail` int, `id_size` int, `qty` int)
;
    
INSERT INTO ket_detail
    (`id_ket`, `id_detail`, `id_size`, `qty`)
VALUES
    (1, 1, 7, 3),
    (2, 1, 9, 1),
    (3, 1, 5, 2),
    (4, 2, 7, 8)
;

CREATE TABLE t_size
    (`id_size` int, `size` int, `id_color` int, `stock` int)
;
    
INSERT INTO t_size
    (`id_size`, `size`, `id_color`, `stock`)
VALUES
    (7, 40, 6, 30),
    (9, 42, 6, 20),
    (5, 39, 5, 30)
;

CREATE TABLE t_color
    (`id_color` int, `color` varchar(5))
;
    
INSERT INTO t_color
    (`id_color`, `color`)
VALUES
    (6, 'green'),
    (5, 'red')
;

SELECT dt.id_detail, 
       SUM(tk.qty) AS tot_order, 
       COUNT(dm.color) AS tot_color,
       SUM(CASE 
              WHEN u.size = 39 THEN tk.qty
              ELSE 0
		   END)  AS size_39,       
       SUM(CASE 
              WHEN u.size = 40 THEN tk.qty
              ELSE 0
		   END)  AS size_40        
FROM detail_order AS dt 
LEFT JOIN ket_detail AS tk ON tk.id_detail=dt.id_detail
LEFT JOIN t_size AS u ON u.id_size = tk.id_size
LEFT JOIN t_color AS dm ON dm.id_color=u.id_color
WHERE dt.id_order = 1
GROUP BY dt.id_detail;

DROP TABLE IF EXISTS detail_order;
DROP TABLE IF EXISTS ket_detail;
DROP TABLE IF EXISTS t_size;
DROP TABLE IF EXISTS t_color;


absolute service time: 0,41 sec