Symfony Profiler

SELECT 
  * 
FROM 
  users 
WHERE 
  `type` = ? 
  AND id = ?

SELECT * FROM users WHERE `type` = 'user' AND id = 2;

SELECT 
  * 
FROM 
  users_workspaces_asset 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 2;

SELECT 
  * 
FROM 
  users_workspaces_document 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 2;

SELECT 
  * 
FROM 
  users_workspaces_object 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 2;

"START TRANSACTION"

"START TRANSACTION";

SELECT 
  COUNT(*) AS num 
FROM 
  `notifications` 
WHERE 
  recipient = ? 
  AND `read` = 0 
  AND creationDate >= ?

SELECT COUNT(*) AS num FROM `notifications` WHERE recipient = 2 AND `read` = 0 AND creationDate >= '2025-08-22 15:33:02' ;

SELECT 
  id 
FROM 
  `notifications` 
WHERE 
  recipient = ? 
  AND `read` = 0 
  AND creationDate >= ? 
ORDER BY 
  `creationDate` DESC 
LIMIT 
  1

SELECT id FROM `notifications` WHERE recipient = 2 AND `read` = 0 AND creationDate >= '2025-08-22 15:33:02'  ORDER BY `creationDate` DESC LIMIT 1;

"COMMIT"

"COMMIT";

SELECT 
  COUNT(*) AS num 
FROM 
  `notifications` 
WHERE 
  recipient = ? 
  AND `read` = 0

SELECT COUNT(*) AS num FROM `notifications` WHERE recipient = 2 AND `read` = 0 ;