Query Metrics

121 Database Queries
13 Different statements
13.79 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.30 ms
SELECT * FROM users WHERE `type` = ? AND id = ?
Parameters:
[
  "user"
  2
]
2 0.14 ms
SELECT * FROM users_workspaces_asset WHERE userId = ?
Parameters:
[
  2
]
3 0.10 ms
SELECT * FROM users_workspaces_document WHERE userId = ?
Parameters:
[
  2
]
4 0.10 ms
SELECT * FROM users_workspaces_object WHERE userId = ?
Parameters:
[
  2
]
5 0.16 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  1
]
6 0.16 ms
SELECT documents.id, documents.type FROM documents WHERE parentId =  '1' ORDER BY `index` ASC, `id` ASC   LIMIT 50
Parameters:
[]
7 0.19 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Tools/%"
]
8 0.10 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
9 0.11 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  8
]
10 0.09 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  8
]
11 0.10 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  8
]
12 0.07 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  8
]
13 0.16 ms
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[]
14 0.20 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  8
]
15 0.15 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Tools/%"
]
16 0.09 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
17 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Training/%"
]
18 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
19 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  14
]
20 0.08 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  14
]
21 0.08 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  14
]
22 0.07 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  14
]
23 0.17 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  14
]
24 0.16 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Training/%"
]
25 0.09 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
26 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Strategy-Expertise/%"
]
27 0.10 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
28 0.09 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  19
]
29 0.07 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  19
]
30 0.06 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  19
]
31 0.06 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  19
]
32 0.17 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  19
]
33 0.14 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Strategy-Expertise/%"
]
34 0.12 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
35 0.14 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Development-Impact/%"
]
36 0.09 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
37 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  25
]
38 0.07 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  25
]
39 0.06 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  25
]
40 0.06 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  25
]
41 0.18 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  25
]
42 0.14 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Development-Impact/%"
]
43 0.09 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
44 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/About/%"
]
45 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
46 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  30
]
47 0.07 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  30
]
48 0.07 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  30
]
49 0.07 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  30
]
50 0.17 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  30
]
51 0.14 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/About/%"
]
52 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
53 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/News-and-Events/%"
]
54 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
55 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  42
]
56 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  42
]
57 0.16 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  42
]
58 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/News-and-Events/%"
]
59 0.07 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
60 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Contact/%"
]
61 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
62 0.09 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  45
]
63 0.09 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  45
]
64 0.15 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  45
]
65 0.14 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Contact/%"
]
66 0.09 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
67 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Online-publications/%"
]
68 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
69 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  47
]
70 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  47
]
71 0.17 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  47
]
72 0.14 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Online-publications/%"
]
73 0.09 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
74 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Policies/%"
]
75 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
76 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  48
]
77 0.07 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  48
]
78 0.15 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  48
]
79 0.13 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Policies/%"
]
80 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
81 0.12 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Thematic/%"
]
82 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
83 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  69
]
84 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  69
]
85 0.15 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  69
]
86 0.12 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Thematic/%"
]
87 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
88 0.12 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/System/%"
]
89 0.10 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
90 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  132
]
91 0.07 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  132
]
92 0.17 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  132
]
93 0.16 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/System/%"
]
94 0.09 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
95 0.15 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Meta/%"
]
96 0.08 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
97 0.09 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  135
]
98 0.08 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  135
]
99 0.16 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  135
]
100 0.27 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Meta/%"
]
101 0.11 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
102 0.16 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Errorpage/%"
]
103 0.10 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
104 0.10 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  143
]
105 0.12 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  143
]
106 0.09 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  143
]
107 0.09 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  143
]
108 0.19 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  143
]
109 0.16 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Errorpage/%"
]
110 0.10 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
111 0.17 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Data-Citation/%"
]
112 0.10 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
113 0.10 ms
SELECT id FROM documents d WHERE parentId = ?  LIMIT 1
Parameters:
[
  160
]
114 0.09 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  160
]
115 0.10 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  160
]
116 0.12 ms
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[]
117 0.13 ms
SELECT * FROM sites WHERE rootId = ?
Parameters:
[
  160
]
118 0.17 ms
SELECT * FROM properties WHERE ((cid IN (1) AND inheritable = 1) OR cid = ? )  AND ctype='document'
Parameters:
[
  160
]
119 0.15 ms
SELECT tree_locks.id FROM tree_locks
            INNER JOIN documents ON tree_locks.id = documents.id
                WHERE documents.path LIKE ? AND tree_locks.type = 'document' AND tree_locks.locked IS NOT NULL AND tree_locks.locked != '' LIMIT 1
Parameters:
[
  "/Data-Citation/%"
]
120 0.10 ms
SELECT id FROM tree_locks WHERE id IN (1) AND type='document' AND locked = 'propagate' LIMIT 1
Parameters:
[]
121 0.16 ms
SELECT count(*) FROM documents d WHERE parentId = ?
Parameters:
[
  1
]

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.