Symfony Profiler

SELECT 
  id, 
  (
    CASE WHEN expire IS NULL 
    OR expire > ? THEN data ELSE NULL END
  ) as data 
FROM 
  cache 
WHERE 
  id IN (?)

SELECT id, 
          (CASE WHEN expire IS NULL OR expire > 1760532890 THEN data ELSE NULL END) as data
            FROM cache WHERE id IN ('site_domain_66c6e164d13a7dbcbd791892bd94ce55');

SELECT 
  id 
FROM 
  documents 
WHERE 
  path = : path 
  AND `key` = : key

SELECT id FROM documents WHERE path = '/restful/' AND `key` = 'getContentKiosByContainer';

SELECT 
  id 
FROM 
  documents_page 
WHERE 
  prettyUrl = : prettyUrl

SELECT id FROM documents_page WHERE prettyUrl = '/restful/getContentKiosByContainer';

SELECT 
  id 
FROM 
  redirects 
WHERE 
  active = 1 
ORDER BY 
  `priority` DESC

SELECT id FROM redirects WHERE active = 1  ORDER BY `priority` DESC;

SELECT 
  object_localized_9_en.o_id as o_id, 
  `object_localized_9_en`.`o_type` 
FROM 
  `object_localized_9_en` 
WHERE 
  (
    (
      container IN ('dt_home_page', 'dt_scan_input') 
      AND o_className = ? 
      AND object_localized_9_en.o_type IN ('object', 'folder')
    ) 
    AND object_localized_9_en.o_published = 1
  )

SELECT object_localized_9_en.o_id as o_id, `object_localized_9_en`.`o_type` FROM `object_localized_9_en` WHERE ((container IN ('dt_home_page', 'dt_scan_input') AND o_className = 'KiosCMS'  AND  object_localized_9_en.o_type IN ('object','folder')) AND object_localized_9_en.o_published = 1);

SELECT 
  * 
FROM 
  users_workspaces_document 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 10;

SELECT 
  id 
FROM 
  targeting_target_groups 
UNION 
SELECT 
  id 
FROM 
  targeting_rules 
LIMIT 
  1

SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;

SELECT 
  * 
FROM 
  users_workspaces_object 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 10;

SELECT 
  id, 
  type 
FROM 
  users 
WHERE 
  apiKey = ? 
  AND type = ? 
  AND active = 1 
  AND id > 0 
  AND `type` IN ('user', 'userfolder')

SELECT id,type FROM users WHERE apiKey = 'bc0d05c9643464f6b5f49ec8d949b262dd51eb1bdfa238250d16c0c9dd8ec438' AND type = 'user' AND active = 1  AND id > 0 AND `type` IN ('user','userfolder');

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

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

SELECT 
  * 
FROM 
  users_workspaces_asset 
WHERE 
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 10;