Symfony Profiler

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

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

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 15;

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 15;

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 15;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_11', 'object_11');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_11\0tags\0', 'class_PROD_TYPE\0tags\0');

SELECT
  name
FROM
  classes
WHERE
  id = ?

SELECT name FROM classes WHERE id = 'PROD_TYPE';

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

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

SELECT
  objects.o_id as o_id,
  objects.o_type as o_type
FROM
  objects
WHERE
  objects.o_parentId = '11'
  AND objects.o_type IN ('object', 'folder')
ORDER BY
  CAST(
    objects.o_key AS CHAR CHARACTER SET utf8
  ) COLLATE utf8_general_ci ASC
LIMIT
  50

SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE objects.o_parentId = '11' AND  objects.o_type IN ('object','folder') ORDER BY CAST(objects.o_key AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci ASC    LIMIT 50;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1428', 'object_1428');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1428\0tags\0', 'class_PROD_TYPE\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1429', 'object_1429');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1429\0tags\0', 'class_PROD_TYPE\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1430', 'object_1430');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1430\0tags\0', 'class_PROD_TYPE\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1431', 'object_1431');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1431\0tags\0', 'class_PROD_TYPE\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1432', 'object_1432');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1432\0tags\0', 'class_PROD_TYPE\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1433', 'object_1433');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1433\0tags\0', 'class_PROD_TYPE\0tags\0');

SELECT
  COUNT(*)
FROM
  objects
WHERE
  objects.o_parentId = '11'
  AND objects.o_type IN ('object', 'folder')

SELECT COUNT(*) FROM objects WHERE objects.o_parentId = '11' AND  objects.o_type IN ('object','folder');

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 '/productTypes/mixers/basinMixers/%' AND tree_locks.type = 'object' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1;

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_10', 'object_10');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_10\0tags\0');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1', 'object_1');

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1791369346 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');

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

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

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

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

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 '/productTypes/mixers/basinMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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 '/productTypes/mixers/bath-showerMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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

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

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 '/productTypes/mixers/bath-showerMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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 '/productTypes/mixers/bidetMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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

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

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 '/productTypes/mixers/bidetMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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 '/productTypes/mixers/concealedInstallation/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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

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

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 '/productTypes/mixers/concealedInstallation/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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 '/productTypes/mixers/kitchenMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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

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

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 '/productTypes/mixers/kitchenMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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 '/productTypes/mixers/showerMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

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

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

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 '/productTypes/mixers/showerMixers/%' 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, 11, 10)
  AND type = 'object'
  AND locked = 'propagate'
LIMIT
  1

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

SELECT
  COUNT(*) AS count
FROM
  objects o
WHERE
  o_parentId = ?

SELECT COUNT(*) AS count FROM objects o WHERE o_parentId = 11;