Replies: 3 comments 1 reply
-
Check the web profiler UI to see the query logged iby DBAL. And you can enable collecting the backtrace (if not already enabled) to see where those calls come from. |
Beta Was this translation helpful? Give feedback.
-
The query shown in the profiler UI is the first one But the user's name (from the join table users) is correctly assigned for each row and this element does not appear in the query ??? Thank |
Beta Was this translation helpful? Give feedback.
-
To see the query, dd() has been removed and the query shown is the one available when the page is displayed |
Beta Was this translation helpful? Give feedback.
-
Hi
I wrote a querrybuider to select devices base on its status (0 = enabled, 1 = not enabled)
In the controller
This returns all devices, regardless of status (0 or 1)
In the MySQL log : 2 queries are logged
The second one, executed in MyPhpMyadmin, provides the correct result !
The field status is :
type char(8), interclassement, utf8mt4_generalci
.This field is already used in the database for other purposes, so I can't change it to boolean
Thank for you help
Beta Was this translation helpful? Give feedback.
All reactions