GET https://cortecostituzionale.strategiedigitali.net/eventi

Query Metrics

21 Database Queries
3 Different statements
18.27 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.85 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.link AS link_4, t0.date AS date_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.publishing_status AS publishing_status_8, t0.document_name AS document_name_9, t0.document_original_name AS document_original_name_10, t0.document_url AS document_url_11 FROM event t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = ? ORDER BY t0.date DESC LIMIT 999
Parameters:
[
  "published"
]
2 1.09 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "c47e4ab0-58a5-4e9f-8320-81692bfe5203"
]
3 0.84 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "c47e4ab0-58a5-4e9f-8320-81692bfe5203"
]
4 0.68 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "45707232-b9a3-4e3b-8969-ad7019541b77"
]
5 0.79 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "45707232-b9a3-4e3b-8969-ad7019541b77"
]
6 0.90 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "7969c139-8977-407d-a0ba-11cd6d3a5339"
]
7 0.59 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "7969c139-8977-407d-a0ba-11cd6d3a5339"
]
8 0.57 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "a6ef60d4-3123-410c-a90b-d15fab21ef3a"
]
9 0.53 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "a6ef60d4-3123-410c-a90b-d15fab21ef3a"
]
10 0.56 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "a1196a95-b74a-40fd-80a2-c70525792593"
]
11 0.63 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "a1196a95-b74a-40fd-80a2-c70525792593"
]
12 0.59 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "eb8692f3-3e59-4b78-958a-05e97417b428"
]
13 0.47 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "eb8692f3-3e59-4b78-958a-05e97417b428"
]
14 0.53 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "40de6ff8-bc09-453a-98cf-4a42f4b4db3a"
]
15 0.52 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "40de6ff8-bc09-453a-98cf-4a42f4b4db3a"
]
16 0.56 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "47998db6-615e-47cf-81fd-87a07f7ae8c5"
]
17 0.50 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "47998db6-615e-47cf-81fd-87a07f7ae8c5"
]
18 0.65 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "e432c7dc-5755-4469-bc9e-e9dd326431fb"
]
19 0.50 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "e432c7dc-5755-4469-bc9e-e9dd326431fb"
]
20 0.46 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.event_id AS event_id_4 FROM event_image t0 WHERE t0.event_id = ?
Parameters:
[
  "58252cef-3c5a-43b9-bcb9-678d627389d2"
]
21 0.45 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.event_id AS event_id_4 FROM event_video t0 WHERE t0.event_id = ?
Parameters:
[
  "58252cef-3c5a-43b9-bcb9-678d627389d2"
]

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.