Query run fast from MySQL CLI but very slow on R2dbcTemplate Code

Question: Currently, I having a query SELECT al.category, IFNULL(jt.name, 'Ungrouped Devices') AS device_group_name, IFNULL(jt.id, '00000000-0000-0000-0000-000000000000') AS device_group_id, jt.color_code AS color_code, COUNT(*) AS total FR...