Symfony Profiler

• Pimcore
• Request / Response
• Performance
• Validator
• Exception
• Logs 21
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Debug
• Messages
• Emails
• Configuration

Query Metrics

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 (?)

[
  1774815268
  "maintenance_mode"
]

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 > 1774815268 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('maintenance_mode');

SELECT object_2.id as id, object_2.type as `type` FROM object_2 WHERE (`path` = '/Categories' OR `path` like '/Categories/%') AND  object_2.type IN ('object','variant','folder') ORDER BY `id` ASC   LIMIT 25

[]

SELECT
  object_2.id as id,
  object_2.type as `type`
FROM
  object_2
WHERE
  (
    `path` = '/Categories'
    OR `path` like '/Categories/%'
  )
  AND object_2.type IN ('object', 'variant', 'folder')
ORDER BY
  `id` ASC
LIMIT
  25

SELECT object_2.id as id, object_2.type as `type` FROM object_2 WHERE (`path` = '/Categories' OR `path` like '/Categories/%') AND  object_2.type IN ('object','variant','folder') ORDER BY `id` ASC   LIMIT 25;

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

[
  "/Categories/electronics/%"
]

SELECT
  tree_locks.id
FROM
  tree_locks
  INNER JOIN objects ON tree_locks.id = objects.id
WHERE
  objects.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.id WHERE objects.path LIKE '/Categories/electronics/%' 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 (?, ?)

[
  1774815268
  "object_12\x01tags\x01"
  "class_2\x01tags\x01"
]

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 > 1774815268 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_12
tags
', 'class_2
tags
');

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

[]

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

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

SELECT COUNT(*) FROM object_2 WHERE (`path` = '/Categories' OR `path` like '/Categories/%') AND  object_2.type IN ('object','variant','folder')

[]

SELECT
  COUNT(*)
FROM
  object_2
WHERE
  (
    `path` = '/Categories'
    OR `path` like '/Categories/%'
  )
  AND object_2.type IN ('object', 'variant', 'folder')

SELECT COUNT(*) FROM object_2 WHERE (`path` = '/Categories' OR `path` like '/Categories/%') AND  object_2.type IN ('object','variant','folder');

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

[
  "user"
  2
]

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

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

SELECT * FROM users_workspaces_object WHERE userId = ?

[
  2
]

SELECT
  *
FROM
  users_workspaces_object
WHERE
  userId = ?

SELECT * FROM users_workspaces_object WHERE userId = 2;

SELECT * FROM users_workspaces_asset WHERE userId = ?

[
  2
]

SELECT
  *
FROM
  users_workspaces_asset
WHERE
  userId = ?

SELECT * FROM users_workspaces_asset WHERE userId = 2;

SELECT * FROM users_workspaces_document WHERE userId = ?

[
  2
]

SELECT
  *
FROM
  users_workspaces_document
WHERE
  userId = ?

SELECT * FROM users_workspaces_document WHERE userId = 2;

SELECT `id`, `name` FROM classes WHERE id = ?

[
  "2"
]

SELECT
  `id`,
  `name`
FROM
  classes
WHERE
  id = ?

SELECT `id`, `name` FROM classes WHERE id = '2' ;