GET https://planer.warsztatyonkologiczne.pl/program

Query Metrics

81 Database Queries
5 Different statements
19.29 ms Query time
0 Invalid entities
143 Managed entities

Queries

Group similar statements

# 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.