Query Metrics
51
Database Queries
29
Different statements
48.06 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
14.54 ms (30.25%) |
1 |
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300)
Parameters:
[ "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IdTvm9PF2+lZ2sSXwIkgvo6GjfmnfotYg7yaMH6nG1w=" ] |
14.28 ms (29.71%) |
1 |
SELECT * FROM translations_portal_engine_frontend WHERE language = ?
Parameters:
[
"en"
]
|
6.76 ms (14.06%) |
1 |
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
Parameters:
[ "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IdTvm9PF2+lZ2sSXwIkgvo6GjfmnfotYg7yaMH6nG1w=" ] |
1.07 ms (2.23%) |
4 |
SELECT documents.*, tree_locks.locked FROM documents LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
1
]
|
1.02 ms (2.13%) |
4 |
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
20
]
|
0.90 ms (1.87%) |
4 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
0.72 ms (1.50%) |
3 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/DAM Portal 1/auth/" "login" ] |
0.71 ms (1.48%) |
2 |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
14743
]
|
0.63 ms (1.31%) |
2 |
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
14743
]
|
0.55 ms (1.15%) |
1 |
SELECT * FROM translations_messages WHERE language = ?
Parameters:
[
"en"
]
|
0.54 ms (1.13%) |
2 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
14743
]
|
0.51 ms (1.07%) |
2 |
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
Parameters:
[ "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IdTvm9PF2+lZ2sSXwIkgvo6GjfmnfotYg7yaMH6nG1w=" ] |
0.46 ms (0.95%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
20
]
|
0.46 ms (0.95%) |
2 |
SELECT documents.*, documents_snippet.*, tree_locks.locked FROM documents LEFT JOIN documents_snippet ON documents.id = documents_snippet.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
26
]
|
0.45 ms (0.94%) |
2 |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/DAM Portal 1/%" "/auth/login" ] |
0.40 ms (0.83%) |
2 |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
3
]
|
0.39 ms (0.81%) |
1 |
SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = 5 AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/auth/login" "path" "auto_create" "/auth/login" "path_query" "https://uat-dam.dabur.com/auth/login" "entire_uri" ] |
0.38 ms (0.79%) |
2 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
3
]
|
0.38 ms (0.79%) |
2 |
SELECT * FROM translations_portal_engine_frontend LIMIT 1;
Parameters:
[] |
0.37 ms (0.76%) |
2 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
0.35 ms (0.73%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/DAM Portal 1/auth/login"
]
|
0.32 ms (0.66%) |
1 |
select documents.id, concat(documents.path, documents.`key`) as fullPath from documents, documents_page, sites where sites.rootId = documents_page.id and documents.id = documents_page.id and documents_page.controller = ?
Parameters:
[
"Pimcore\Bundle\PortalEngineBundle\Controller\PortalController::pageAction"
]
|
0.31 ms (0.65%) |
1 |
SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ?
Parameters:
[ "uat-dam.dabur.com" "%"uat-dam.dabur.com"%" ] |
0.31 ms (0.64%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
0.28 ms (0.59%) |
1 |
UPDATE lock_keys SET key_expiration = UNIX_TIMESTAMP() + ?, key_token = ? WHERE key_id = ? AND (key_token = ? OR key_expiration <= UNIX_TIMESTAMP())
Parameters:
[ 300.0 "IdTvm9PF2+lZ2sSXwIkgvo6GjfmnfotYg7yaMH6nG1w=" "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IdTvm9PF2+lZ2sSXwIkgvo6GjfmnfotYg7yaMH6nG1w=" ] |
0.27 ms (0.57%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
20
]
|
0.26 ms (0.54%) |
1 |
SELECT id FROM redirects WHERE active = 1 AND regex = 1 ORDER BY `priority` DESC
Parameters:
[] |
0.24 ms (0.49%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.19 ms (0.40%) |
1 |
SELECT * FROM sites WHERE id = ?
Parameters:
[
5
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
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.
Managed Entities
portal_engine entity manager
Class | Amount of managed objects |
---|
statistics_explorer entity manager
Class | Amount of managed objects |
---|
Entities Mapping
portal_engine entity manager
No loaded entities.
statistics_explorer entity manager
No loaded entities.