Query Metrics
564
Database Queries
54
Different statements
228.74 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
22.17 ms (9.69%) |
60 |
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:
[
21
]
|
18.13 ms (7.92%) |
46 |
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:
[
9
]
|
17.28 ms (7.55%) |
60 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
21
]
|
16.04 ms (7.01%) |
39 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
9
]
|
12.90 ms (5.64%) |
42 |
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
9
]
|
11.88 ms (5.19%) |
28 |
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
]
|
11.82 ms (5.17%) |
32 |
SELECT * FROM object_localized_data_dish WHERE ooo_id = ? AND language IN ('it','en','de','es')
Parameters:
[
32
]
|
9.69 ms (4.24%) |
32 |
SELECT * FROM object_relations_dish WHERE src_id = ?
Parameters:
[
32
]
|
8.22 ms (3.59%) |
32 |
SELECT * FROM object_store_dish WHERE oo_id = ?
Parameters:
[
32
]
|
7.26 ms (3.17%) |
12 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
"/"
""
]
|
6.75 ms (2.95%) |
17 |
SELECT * FROM object_localized_data_navigationmenunode WHERE ooo_id = ? AND language IN ('it','en','de','es')
Parameters:
[
22
]
|
6.33 ms (2.77%) |
8 |
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 IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/" "path" "auto_create" "/" "path_query" "https://213.32.72.75:8444/" "entire_uri" ] |
5.78 ms (2.53%) |
12 |
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:
[
1
]
|
5.73 ms (2.51%) |
8 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
27
]
|
5.72 ms (2.50%) |
17 |
SELECT * FROM object_relations_navigationmenunode WHERE src_id = ?
Parameters:
[
22
]
|
5.09 ms (2.23%) |
1 |
DELETE FROM lock_keys WHERE key_id = ? AND key_token = ?
Parameters:
[ "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IAET4deBNYgfFLTD/fL1ZWH7Dn8Qa5XLg+NZcTW5Y2M=" ] |
4.82 ms (2.11%) |
17 |
SELECT * FROM object_store_navigationmenunode WHERE oo_id = ?
Parameters:
[
22
]
|
4.27 ms (1.87%) |
8 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
4.15 ms (1.81%) |
1 |
INSERT INTO lock_keys (key_id, key_token, key_expiration) VALUES (?, ?, UNIX_TIMESTAMP() + 300)
Parameters:
[ "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IAET4deBNYgfFLTD/fL1ZWH7Dn8Qa5XLg+NZcTW5Y2M=" ] |
3.63 ms (1.59%) |
8 |
SELECT * FROM properties WHERE ( (cid IN (1,11) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
14
]
|
3.61 ms (1.58%) |
8 |
SELECT * FROM object_relations_dish WHERE dest_id = ? AND fieldname = ? AND ownertype = 'object'
Parameters:
[ 29 "menus" ] |
3.07 ms (1.34%) |
8 |
SELECT * FROM object_localized_data_menu WHERE ooo_id = ? AND language IN ('it','en','de','es')
Parameters:
[
29
]
|
3.04 ms (1.33%) |
7 |
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:
[
27
]
|
2.48 ms (1.08%) |
8 |
SELECT * FROM object_relations_menu WHERE src_id = ?
Parameters:
[
29
]
|
2.33 ms (1.02%) |
1 |
SELECT * FROM sites WHERE mainDomain = ? OR domains LIKE ?
Parameters:
[ "213.32.72.75" "%"213.32.72.75"%" ] |
2.28 ms (1.00%) |
8 |
SELECT * FROM object_store_menu WHERE oo_id = ?
Parameters:
[
29
]
|
1.94 ms (0.85%) |
4 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"navigationmenu"
]
|
1.63 ms (0.71%) |
3 |
SELECT * FROM properties WHERE ( (cid IN (1,4,3,11) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
5
]
|
1.29 ms (0.56%) |
1 |
SELECT COUNT(*) FROM object_localized_menu_it WHERE ( object_localized_menu_it.type IN ('object','variant','folder')) AND object_localized_menu_it.published = 1
Parameters:
[] |
1.19 ms (0.52%) |
3 |
SELECT * FROM object_localized_data_navigationmenu WHERE ooo_id = ? AND language IN ('it','en','de','es')
Parameters:
[
21
]
|
1.15 ms (0.50%) |
3 |
SELECT * FROM object_relations_navigationmenu WHERE src_id = ?
Parameters:
[
21
]
|
1.04 ms (0.46%) |
2 |
SELECT 1 FROM lock_keys WHERE key_id = ? AND key_token = ? AND key_expiration > UNIX_TIMESTAMP()
Parameters:
[ "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IAET4deBNYgfFLTD/fL1ZWH7Dn8Qa5XLg+NZcTW5Y2M=" ] |
1.04 ms (0.45%) |
2 |
SELECT * FROM properties WHERE ( (cid IN (1,26,3,11) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
27
]
|
1.03 ms (0.45%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
1.03 ms (0.45%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
0.99 ms (0.43%) |
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 "IAET4deBNYgfFLTD/fL1ZWH7Dn8Qa5XLg+NZcTW5Y2M=" "56077d86c930853c3d6d19af78a9d93e0618bf805082ea53d76a848b5f59d071" "IAET4deBNYgfFLTD/fL1ZWH7Dn8Qa5XLg+NZcTW5Y2M=" ] |
0.99 ms (0.43%) |
1 |
SELECT t0.id AS id_1, t0.element_type AS element_type_2, t0.element_id AS element_id_3, t0.integrator AS integrator_4, t0.data AS data_5, t0.release_type AS release_type_6 FROM seo_element_meta_data t0 WHERE t0.element_type = ? AND t0.element_id = ? AND t0.release_type = ?
Parameters:
[ "document" 1 "public" ] |
0.93 ms (0.41%) |
1 |
SELECT id FROM website_settings
Parameters:
[] |
0.92 ms (0.40%) |
1 |
SELECT object_localized_menu_it.id as id, object_localized_menu_it.type as `type` FROM object_localized_menu_it WHERE ( object_localized_menu_it.type IN ('object','variant','folder')) AND object_localized_menu_it.published = 1 ORDER BY RAND()
Parameters:
[] |
0.91 ms (0.40%) |
2 |
SELECT * FROM properties WHERE ( (cid IN (1,9,3,11) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
10
]
|
0.88 ms (0.39%) |
3 |
SELECT * FROM object_store_navigationmenu WHERE oo_id = ?
Parameters:
[
21
]
|
0.80 ms (0.35%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 1 1 1 ] |
0.73 ms (0.32%) |
2 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
0.71 ms (0.31%) |
1 |
SELECT id FROM redirects WHERE active = 1 AND regex = 1 ORDER BY `priority` DESC
Parameters:
[] |
0.67 ms (0.29%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.63 ms (0.27%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
0.62 ms (0.27%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/de"
]
|
0.58 ms (0.25%) |
1 |
SELECT * FROM translations_messages WHERE language = ?
Parameters:
[
"it"
]
|
0.50 ms (0.22%) |
1 |
SELECT documents.*, documents_link.*, tree_locks.locked FROM documents LEFT JOIN documents_link ON documents.id = documents_link.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
11
]
|
0.49 ms (0.22%) |
1 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
0.46 ms (0.20%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
1
]
|
0.43 ms (0.19%) |
1 |
SELECT id,domains FROM sites
Parameters:
[] |
0.40 ms (0.17%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 13 13 ] |
0.29 ms (0.13%) |
1 |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Dish"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
SeoBundle\Model\ElementMetaData | No errors. |