Query Metrics
81
Database Queries
5
Different statements
19.29 ms
Query time
0
Invalid entities
143
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.clone AS clone_4, t0.clone_name AS clone_name_5, t0.clone_note AS clone_note_6 FROM conference t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[] |
| 2 | 0.81 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.conference_id AS conference_id_3 FROM day t0 WHERE t0.conference_id = ? ORDER BY t0.id ASC
Parameters:
[
1
]
|
| 3 | 0.79 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.show_time AS show_time_4, t0.block AS block_5, t0.patron AS patron_6, t0.author AS author_7, t0.description AS description_8, t0.color AS color_9, t0.status AS status_10, t0.conference_id AS conference_id_11, t0.day_id AS day_id_12 FROM event t0 WHERE t0.conference_id = ? AND t0.day_id = ? ORDER BY t0.start ASC
Parameters:
[ 1 1 ] |
| 4 | 0.18 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.show_time AS show_time_4, t0.block AS block_5, t0.patron AS patron_6, t0.author AS author_7, t0.description AS description_8, t0.color AS color_9, t0.status AS status_10, t0.conference_id AS conference_id_11, t0.day_id AS day_id_12 FROM event t0 WHERE t0.conference_id = ? AND t0.day_id = ? ORDER BY t0.start ASC
Parameters:
[ 1 2 ] |
| 5 | 0.24 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.show_time AS show_time_4, t0.block AS block_5, t0.patron AS patron_6, t0.author AS author_7, t0.description AS description_8, t0.color AS color_9, t0.status AS status_10, t0.conference_id AS conference_id_11, t0.day_id AS day_id_12 FROM event t0 WHERE t0.conference_id = ? AND t0.day_id = ? ORDER BY t0.start ASC
Parameters:
[ 1 3 ] |
| 6 | 1.27 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.show_time AS show_time_4, t0.block AS block_5, t0.patron AS patron_6, t0.author AS author_7, t0.description AS description_8, t0.color AS color_9, t0.status AS status_10, t0.conference_id AS conference_id_11, t0.day_id AS day_id_12 FROM event t0 WHERE t0.conference_id = ? AND t0.day_id = ? ORDER BY t0.start ASC
Parameters:
[ 1 4 ] |
| 7 | 0.28 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.show_time AS show_time_4, t0.block AS block_5, t0.patron AS patron_6, t0.author AS author_7, t0.description AS description_8, t0.color AS color_9, t0.status AS status_10, t0.conference_id AS conference_id_11, t0.day_id AS day_id_12 FROM event t0 WHERE t0.conference_id = ? AND t0.day_id = ? ORDER BY t0.start ASC
Parameters:
[ 1 5 ] |
| 8 | 0.25 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.show_time AS show_time_4, t0.block AS block_5, t0.patron AS patron_6, t0.author AS author_7, t0.description AS description_8, t0.color AS color_9, t0.status AS status_10, t0.conference_id AS conference_id_11, t0.day_id AS day_id_12 FROM event t0 WHERE t0.conference_id = ? AND t0.day_id = ? ORDER BY t0.start ASC
Parameters:
[ 1 6 ] |
| 9 | 0.17 ms |
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.show_time AS show_time_4, t0.block AS block_5, t0.patron AS patron_6, t0.author AS author_7, t0.description AS description_8, t0.color AS color_9, t0.status AS status_10, t0.conference_id AS conference_id_11, t0.day_id AS day_id_12 FROM event t0 WHERE t0.conference_id = ? AND t0.day_id = ? ORDER BY t0.start ASC
Parameters:
[ 1 7 ] |
| 10 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0
Parameters:
[] |
| 11 | 0.67 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
2
]
|
| 12 | 0.45 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
5
]
|
| 13 | 0.20 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
98
]
|
| 14 | 0.34 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
83
]
|
| 15 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
7
]
|
| 16 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
85
]
|
| 17 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
86
]
|
| 18 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
87
]
|
| 19 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
11
]
|
| 20 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
88
]
|
| 21 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
95
]
|
| 22 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
118
]
|
| 23 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
122
]
|
| 24 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
93
]
|
| 25 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
20
]
|
| 26 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
99
]
|
| 27 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
10
]
|
| 28 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
92
]
|
| 29 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
17
]
|
| 30 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
4
]
|
| 31 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
18
]
|
| 32 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
100
]
|
| 33 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
12
]
|
| 34 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
14
]
|
| 35 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
101
]
|
| 36 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
21
]
|
| 37 | 0.44 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
107
]
|
| 38 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
24
]
|
| 39 | 0.15 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
26
]
|
| 40 | 0.18 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
103
]
|
| 41 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
32
]
|
| 42 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
52
]
|
| 43 | 0.32 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
123
]
|
| 44 | 0.15 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
31
]
|
| 45 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
104
]
|
| 46 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
33
]
|
| 47 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
34
]
|
| 48 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
54
]
|
| 49 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
102
]
|
| 50 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
27
]
|
| 51 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
96
]
|
| 52 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
97
]
|
| 53 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
42
]
|
| 54 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
106
]
|
| 55 | 0.15 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
39
]
|
| 56 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
40
]
|
| 57 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
50
]
|
| 58 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
51
]
|
| 59 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
36
]
|
| 60 | 0.15 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
45
]
|
| 61 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
23
]
|
| 62 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
124
]
|
| 63 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
37
]
|
| 64 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
35
]
|
| 65 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
116
]
|
| 66 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
58
]
|
| 67 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
59
]
|
| 68 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
117
]
|
| 69 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
94
]
|
| 70 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
44
]
|
| 71 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
89
]
|
| 72 | 0.14 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
109
]
|
| 73 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
90
]
|
| 74 | 0.17 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
78
]
|
| 75 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
69
]
|
| 76 | 0.19 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
91
]
|
| 77 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
111
]
|
| 78 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
112
]
|
| 79 | 0.13 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
110
]
|
| 80 | 0.12 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
113
]
|
| 81 | 0.12 ms |
SELECT t0.id AS id_1, t0.author AS author_2, t0.text AS text_3, t0.date_time AS date_time_4, t0.event_id AS event_id_5 FROM note t0 WHERE t0.event_id = ?
Parameters:
[
81
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Event | 71 |
| App\Entity\Note | 54 |
| App\Entity\Setting | 10 |
| App\Entity\Day | 7 |
| App\Entity\Conference | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Conference | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Day | No errors. |
| App\Entity\Note | No errors. |
| App\Entity\Setting | No errors. |