Query Metrics

14 Database Queries
7 Different statements
6.52 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenance_mode"
]
2 0.54 ms
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  9
]
3 0.52 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  9
]
4 0.49 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  9
]
5 0.51 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  9
]
6 0.49 ms
SELECT * FROM users WHERE `id` = ?
Parameters:
[
  7
]
7 0.44 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  7
]
8 0.43 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  7
]
9 0.43 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  7
]
10 0.45 ms
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "role"
  7
]
11 0.47 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  7
]
12 0.41 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  7
]
13 0.43 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  7
]
14 0.46 ms
SELECT count(*) FROM bundle_advancedobjectsearch_update_queue WHERE in_queue = 1
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
pimcore_generic_data_index doctrine.orm.pimcore_generic_data_index_entity_manager
pimcore doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

pimcore_generic_data_index entity manager

Class Amount of managed objects

pimcore entity manager

Class Amount of managed objects

Entities Mapping

pimcore_generic_data_index entity manager

No loaded entities.

pimcore entity manager

No loaded entities.