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;

SELECT 
  tree_locks.id 
FROM 
  tree_locks 
  INNER JOIN objects ON tree_locks.id = objects.o_id 
WHERE 
  objects.o_path LIKE ? 
  AND tree_locks.type = 'object' 
  AND tree_locks.locked IS NOT NULL 
  AND tree_locks.locked != '' 
LIMIT 
  1

SELECT tree_locks.id FROM tree_locks INNER JOIN objects ON tree_locks.id = objects.o_id WHERE objects.o_path LIKE '/Min Booking Amount/1CSISUKIFKY0A0D4/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT 
  id 
FROM 
  tree_locks 
WHERE 
  id IN (1, 604) 
  AND type = 'object' 
  AND locked = 'propagate' 
LIMIT 
  1

SELECT id FROM tree_locks WHERE id IN (1,604) AND type='object' AND locked = 'propagate' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT 
  id 
FROM 
  versions 
WHERE 
  cid = ? 
  AND ctype = 'object' 
ORDER BY 
  `id` ASC

SELECT id FROM versions WHERE cid = 52932 AND ctype='object' ORDER BY `id` ASC;

SELECT 
  * 
FROM 
  versions 
WHERE 
  id = ?

SELECT * FROM versions WHERE id = '250106';

SELECT 
  * 
FROM 
  versions 
WHERE 
  id = ?

SELECT * FROM versions WHERE id = '250107';

DELETE FROM 
  versions 
WHERE 
  id = ?

DELETE FROM versions WHERE id = 250106;

DELETE FROM 
  versions 
WHERE 
  id = ?

DELETE FROM versions WHERE id = 250107;

DELETE FROM 
  schedule_tasks 
WHERE 
  cid = ? 
  AND ctype = ?

DELETE FROM schedule_tasks WHERE cid = 52932 AND ctype = 'object';

SELECT 
  * 
FROM 
  search_backend_data 
WHERE 
  id = ? 
  AND maintype = ?

SELECT * FROM search_backend_data WHERE id= 52932 AND maintype = 'object' ;

DELETE FROM 
  search_backend_data 
WHERE 
  id = ? 
  AND maintype = ?

DELETE FROM search_backend_data WHERE id = 52932 AND maintype = 'object';

SELECT 
  1 
FROM 
  objects 
WHERE 
  o_parentId = ? 
  AND o_type IN ('object', 'folder', 'variant') 
LIMIT 
  1

SELECT 1 FROM objects WHERE o_parentId = 52932 AND o_type IN ('object','folder','variant') LIMIT 1;

SELECT 
  `targetid`, 
  `targettype` 
FROM 
  dependencies 
WHERE 
  sourceid = ? 
  AND sourcetype = ?

SELECT `targetid`,`targettype`  FROM dependencies WHERE sourceid = 52932 AND sourcetype = 'object';

SELECT 
  `sourceid`, 
  `sourcetype` 
FROM 
  dependencies 
WHERE 
  targetid = ? 
  AND targettype = ?

SELECT `sourceid`, `sourcetype` FROM dependencies WHERE targetid = 52932 AND targettype = 'object';

SELECT 
  `id` 
FROM 
  dependencies 
WHERE 
  sourceid = '52932' 
  AND sourcetype = 'object'

SELECT `id`  FROM dependencies WHERE sourceid = '52932' AND  sourcetype = 'object';

DELETE FROM 
  dependencies 
WHERE 
  id IN ('99959')

DELETE FROM dependencies WHERE id IN ('99959');

DELETE FROM 
  properties 
WHERE 
  cid = ? 
  AND ctype = ?

DELETE FROM properties WHERE cid = 52932 AND ctype = 'object';

DELETE FROM 
  users_workspaces_object 
WHERE 
  cid = ?

DELETE FROM users_workspaces_object WHERE cid = 52932;

DELETE FROM 
  object_query_10 
WHERE 
  oo_id = ?

DELETE FROM object_query_10 WHERE oo_id = 52932;

DELETE FROM 
  object_store_10 
WHERE 
  oo_id = ?

DELETE FROM object_store_10 WHERE oo_id = 52932;

DELETE FROM 
  object_relations_10 
WHERE 
  src_id = ?

DELETE FROM object_relations_10 WHERE src_id = 52932;

SELECT 
  name 
FROM 
  classes 
WHERE 
  id = ?

SELECT name FROM classes WHERE id = '10';

DELETE FROM 
  objects 
WHERE 
  o_id = ?

DELETE FROM objects WHERE o_id = 52932;

SELECT 
  cid, 
  ctype, 
  workflow 
FROM 
  element_workflow_state 
WHERE 
  cid = ? 
  and ctype = ?

SELECT cid, ctype, workflow FROM element_workflow_state WHERE cid = 52932 and ctype = 'object' ;

DELETE FROM 
  gridconfig_favourites 
where 
  objectId = 52932

DELETE FROM gridconfig_favourites where objectId = 52932;

"COMMIT"

"COMMIT";