Query Metrics
1949
Database Queries
96
Different statements
301.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
86.35 ms (28.66%) |
706 |
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:
[
1227
]
|
|
44.25 ms (14.69%) |
314 |
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:
[
1283
]
|
|
40.28 ms (13.37%) |
281 |
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:
[
1229
]
|
|
29.89 ms (9.92%) |
189 |
SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1
Parameters:
[
1229
]
|
|
10.45 ms (3.47%) |
1 |
SELECT name FROM properties WHERE ctype = "document" AND name LIKE "json-ld-%" GROUP BY name
Parameters:
[] |
|
10.03 ms (3.33%) |
65 |
SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC
Parameters:
[
1227
]
|
|
4.39 ms (1.46%) |
1 |
SELECT * FROM translations_messages WHERE language = ?
Parameters:
[
"en"
]
|
|
3.58 ms (1.19%) |
26 |
SELECT * FROM properties WHERE cid = ? AND ctype='document'
Parameters:
[
1232
]
|
|
3.55 ms (1.18%) |
27 |
SELECT documents.*, documents_hardlink.*, tree_locks.locked FROM documents LEFT JOIN documents_hardlink ON documents.id = documents_hardlink.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
1227
]
|
|
3.49 ms (1.16%) |
14 |
SELECT * FROM properties WHERE ((cid IN (1,1231,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1232
]
|
|
3.34 ms (1.11%) |
13 |
SELECT * FROM properties WHERE ((cid IN (1,1331,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1360
]
|
|
3.06 ms (1.02%) |
13 |
SELECT * FROM properties WHERE ((cid IN (1,1230,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1258
]
|
|
2.78 ms (0.92%) |
12 |
SELECT * FROM properties WHERE ((cid IN (1,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1273
]
|
|
2.55 ms (0.85%) |
9 |
SELECT * FROM properties WHERE ((cid IN (1,1276,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1344
]
|
|
2.32 ms (0.77%) |
9 |
SELECT * FROM properties WHERE ((cid IN (1,1333,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1388
]
|
|
2.12 ms (0.70%) |
10 |
SELECT * FROM object_relations_SiteConfig WHERE src_id = ?
Parameters:
[
170
]
|
|
2.07 ms (0.69%) |
8 |
SELECT * FROM properties WHERE ((cid IN (1,1258,1230,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1301
]
|
|
2.04 ms (0.68%) |
8 |
SELECT * FROM properties WHERE ((cid IN (1,1334,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1403
]
|
|
1.92 ms (0.64%) |
8 |
SELECT * FROM properties WHERE ((cid IN (1,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1331
]
|
|
1.60 ms (0.53%) |
12 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
1267
]
|
|
1.57 ms (0.52%) |
7 |
SELECT * FROM properties WHERE ((cid IN (1,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1229
]
|
|
1.57 ms (0.52%) |
6 |
SELECT * FROM properties WHERE ((cid IN (1,1268,1230,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1319
]
|
|
1.55 ms (0.52%) |
6 |
SELECT * FROM properties WHERE ((cid IN (1,1270,1230,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1320
]
|
|
1.50 ms (0.50%) |
6 |
SELECT * FROM properties WHERE ((cid IN (1,1396,1297,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1467
]
|
|
1.42 ms (0.47%) |
6 |
SELECT * FROM properties WHERE ((cid IN (1,1274,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1338
]
|
|
1.37 ms (0.45%) |
5 |
SELECT * FROM properties WHERE ((cid IN (1,1350,1276,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1510
]
|
|
1.27 ms (0.42%) |
5 |
SELECT * FROM properties WHERE ((cid IN (1,1271,1230,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1326
]
|
|
1.21 ms (0.40%) |
4 |
SELECT * FROM properties WHERE ((cid IN (1,1349,1276,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1413
]
|
|
1.19 ms (0.40%) |
5 |
SELECT * FROM properties WHERE ((cid IN (1,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1297
]
|
|
1.18 ms (0.39%) |
10 |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
170
]
|
|
1.18 ms (0.39%) |
8 |
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:
[
2700
]
|
|
1.12 ms (0.37%) |
5 |
SELECT * FROM properties WHERE ((cid IN (1,1228,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1241
]
|
|
1.07 ms (0.36%) |
7 |
SELECT documents.*, documents_email.*, tree_locks.locked FROM documents LEFT JOIN documents_email ON documents.id = documents_email.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
1284
]
|
|
1.03 ms (0.34%) |
4 |
SELECT * FROM properties WHERE ((cid IN (1,1335,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1354
]
|
|
0.96 ms (0.32%) |
6 |
SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 15766 15766 ] |
|
0.92 ms (0.30%) |
3 |
SELECT * FROM properties WHERE ((cid IN (1,1348,1276,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1440
]
|
|
0.91 ms (0.30%) |
10 |
SELECT * FROM object_store_SiteConfig WHERE oo_id = ?
Parameters:
[
170
]
|
|
0.91 ms (0.30%) |
4 |
SELECT * FROM properties WHERE ((cid IN (1,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1248
]
|
|
0.89 ms (0.30%) |
10 |
SELECT * FROM object_localized_data_SiteConfig WHERE ooo_id = ? AND language IN ('en')
Parameters:
[
170
]
|
|
0.85 ms (0.28%) |
10 |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
170
]
|
|
0.80 ms (0.27%) |
1 |
SELECT object_localized_SiteConfig_en.o_id as o_id, object_localized_SiteConfig_en.o_type as o_type FROM object_localized_SiteConfig_en WHERE ((country IS NOT NULL) AND (rootDocument__id IS NOT NULL) AND object_localized_SiteConfig_en.o_type IN ('object','folder')) AND object_localized_SiteConfig_en.o_published = 1
Parameters:
[] |
|
0.79 ms (0.26%) |
3 |
SELECT * FROM properties WHERE ((cid IN (1,1250,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1295
]
|
|
0.77 ms (0.25%) |
7 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "whistleblower" "path" => "/oesterreich/en/kuhn-world/" ] |
|
0.76 ms (0.25%) |
3 |
SELECT * FROM properties WHERE ((cid IN (1,1254,1231,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1375
]
|
|
0.74 ms (0.25%) |
3 |
SELECT * FROM properties WHERE ((cid IN (1,1418,1298,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1493
]
|
|
0.73 ms (0.24%) |
5 |
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:
[
1301
]
|
|
0.72 ms (0.24%) |
3 |
SELECT * FROM properties WHERE ((cid IN (1,1297,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1396
]
|
|
0.71 ms (0.24%) |
3 |
SELECT * FROM properties WHERE ((cid IN (1,1298,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1418
]
|
|
0.64 ms (0.21%) |
4 |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/oesterreich/%" "/en/kuhn-world/whistleblower" ] |
|
0.62 ms (0.21%) |
3 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 15764 15766 15766 ] |
|
0.53 ms (0.18%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,1397,1297,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1458
]
|
|
0.52 ms (0.17%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,1233,1231,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1252
]
|
|
0.51 ms (0.17%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,1495,1418,1298,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1563
]
|
|
0.51 ms (0.17%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/en/kuhn-world/whistleblower" ] |
|
0.49 ms (0.16%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,1419,1298,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1476
]
|
|
0.48 ms (0.16%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,1246,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1267
]
|
|
0.47 ms (0.16%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,1300,1249,1240,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1432
]
|
|
0.34 ms (0.11%) |
3 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
15766
]
|
|
0.31 ms (0.10%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1352,1276,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1434
]
|
|
0.30 ms (0.10%) |
1 |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = '2' AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/en/kuhn-world/whistleblower" "sourcePathQuery" => "/en/kuhn-world/whistleblower" "sourceEntireUri" => "https://kuhn-at.roromedia.at/en/kuhn-world/whistleblower" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
0.29 ms (0.10%) |
2 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.28 ms (0.09%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,7,2,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
15764
]
|
|
0.27 ms (0.09%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1234,1231,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1247
]
|
|
0.26 ms (0.09%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1336,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1377
]
|
|
0.26 ms (0.09%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1332,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1359
]
|
|
0.26 ms (0.09%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,16905,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
16906
]
|
|
0.25 ms (0.08%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1353,1273,1229,1227,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1358
]
|
|
0.22 ms (0.07%) |
2 |
SELECT * FROM object_url_slugs WHERE slug = '/oesterreich//en/kuhn-world/whistleblower' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.21 ms (0.07%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1966) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
2451
]
|
|
0.20 ms (0.07%) |
2 |
SELECT * FROM object_url_slugs WHERE slug = '/en/kuhn-world/whistleblower' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.19 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1965) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
2
]
|
|
0.19 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1964) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
6599
]
|
|
0.19 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1970) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
14060
]
|
|
0.19 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1969) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
12022
]
|
|
0.19 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1968) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
11025
]
|
|
0.19 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1972) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
10035
]
|
|
0.19 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1971) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
4721
]
|
|
0.19 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1967) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
12710
]
|
|
0.18 ms (0.06%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
|
0.18 ms (0.06%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,1973) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
13676
]
|
|
0.14 ms (0.05%) |
1 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
0.14 ms (0.05%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/en/kuhn-world/whistleblower' AND (siteId = 2 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
0.12 ms (0.04%) |
1 |
SELECT * FROM elements_json_ld_bundle_templates WHERE id = ?
Parameters:
[
8
]
|
|
0.11 ms (0.04%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
0.11 ms (0.04%) |
1 |
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
"pimcore_staticroutes"
]
|
|
0.10 ms (0.03%) |
1 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"SiteConfig"
]
|
|
0.09 ms (0.03%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 170
Parameters:
[] |
|
0.07 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 538
Parameters:
[] |
|
0.07 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 500
Parameters:
[] |
|
0.07 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 2515
Parameters:
[] |
|
0.07 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 1522
Parameters:
[] |
|
0.06 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 553
Parameters:
[] |
|
0.06 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 2512
Parameters:
[] |
|
0.06 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 3190
Parameters:
[] |
|
0.06 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 1622
Parameters:
[] |
|
0.06 ms (0.02%) |
1 |
select `sharingServices` from object_store_SiteConfig where oo_id = 2520
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.