https://testing.huegli-foodservice.c-2248.maxcluster.net/admin/login?perspective=

Query Metrics

18 Database Queries
7 Different statements
5.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.43 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle"
  "scope" => "pimcore"
]
2 0.05 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubBundle\PimcoreDataHubBundle"
  "scope" => "pimcore"
]
3 0.10 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubSimpleRestBundle\PimcoreDataHubSimpleRestBundle"
  "scope" => "pimcore"
]
4 0.04 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Elements\Bundle\ProcessManagerBundle\ElementsProcessManagerBundle"
  "scope" => "pimcore"
]
5 0.13 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataImporterBundle\PimcoreDataImporterBundle"
  "scope" => "pimcore"
]
6 0.11 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubFileExportBundle\PimcoreDataHubFileExportBundle"
  "scope" => "pimcore"
]
7 0.09 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\DataHubCiHubBundle\PimcoreDataHubCiHubBundle"
  "scope" => "pimcore"
]
8 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\PortalEngineBundle\PimcorePortalEngineBundle"
  "scope" => "pimcore"
]
9 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\StatisticsExplorerBundle\PimcoreStatisticsExplorerBundle"
  "scope" => "pimcore"
]
10 0.08 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\AssetMetadataClassDefinitionsBundle\PimcoreAssetMetadataClassDefinitionsBundle"
  "scope" => "pimcore"
]
11 0.07 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__AdvancedObjectSearchBundle\AdvancedObjectSearchBundle"
  "scope" => "pimcore"
]
12 0.07 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "BUNDLE_INSTALLED__Pimcore\Bundle\WorkflowDesignerBundle\PimcoreWorkflowDesignerBundle"
  "scope" => "pimcore"
]
13 0.08 ms
SELECT * FROM users_permission_definitions WHERE `key`='pimcore_direct_edit'
Parameters:
[]
14 1.33 ms
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300)
Parameters:
[
  "97d7370ab6c17a683476599a7172fef92f29ff39d7e65c8d1b64158ef57da102"
  "cq1A/PrR2PaBpvceOqjiJyh0n1oFpputO8igaKr9Mbc="
]
15 0.64 ms
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP())
Parameters:
[
  7200.0
  "cq1A/PrR2PaBpvceOqjiJyh0n1oFpputO8igaKr9Mbc="
  "97d7370ab6c17a683476599a7172fef92f29ff39d7e65c8d1b64158ef57da102"
  "cq1A/PrR2PaBpvceOqjiJyh0n1oFpputO8igaKr9Mbc="
]
16 0.74 ms
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
Parameters:
[
  "97d7370ab6c17a683476599a7172fef92f29ff39d7e65c8d1b64158ef57da102"
  "cq1A/PrR2PaBpvceOqjiJyh0n1oFpputO8igaKr9Mbc="
]
17 1.16 ms
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
Parameters:
[
  "97d7370ab6c17a683476599a7172fef92f29ff39d7e65c8d1b64158ef57da102"
  "cq1A/PrR2PaBpvceOqjiJyh0n1oFpputO8igaKr9Mbc="
]
18 0.26 ms
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
pimcore_direct_edit doctrine.orm.pimcore_direct_edit_entity_manager
portal_engine doctrine.orm.portal_engine_entity_manager
statistics_explorer doctrine.orm.statistics_explorer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

pimcore_direct_edit entity manager

No loaded entities.

portal_engine entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.