---
title: "Discussion on \"Query run fast from MySQL CLI but very slow on R2dbcTemplate Code\" | Hashnode"
description: "Discussion on \"Query run fast from MySQL CLI but very slow on R2dbcTemplate Code\". Question:\nCurrently, I having a query\nSELECT\n  al.category,\n  IFNULL(jt.name, 'Ungrouped Devices') AS device_group_name,\n  IFNULL(jt.id, '00000000-0000-0000-0000-000000000000') AS device_group_id,\n  jt.color_code AS color_code,\n  COUNT(*) AS total\nFR..."
url: "https://hashnode.com/posts/query-run-fast-from-mysql-cli-but-very-slow-on-r2dbctemplate-code/686fbb9e2c7602aed7687aaa"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Query run fast from MySQL CLI but very slow on R2dbcTemplate Code](https://databasedev.hashnode.dev/query-run-fast-from-mysql-cli-but-very-slow-on-r2dbctemplate-code?utm_source=hashnode&utm_medium=feed)

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...

Jul 10, 2025 · 3 min read · databasedev.hashnode.dev  
Read the article

-   [#mysql-cli](https://hashnode.com/tag/mysql-cli)
-   [#sql](https://hashnode.com/tag/sql)
-   [#mysql](https://hashnode.com/tag/mysql)
-   [#mysql-ide](https://hashnode.com/tag/mysql-ide)
-   [#qanda](https://hashnode.com/tag/qanda)

## Written by

[Gabriella Barajas](https://hashnode.com/@gabbbybar)

@gabbbybar · USA

  
[View profile](https://hashnode.com/@gabbbybar)

Real Questions. Clean Answers. All About Databases.

A database Q&A blog for those who’d rather debug queries than read documentation. Practical answers to real questions — mostly SQL Server and MySQL, with a pinch of sarcasm and a love for clean code.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.