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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 5.45 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 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:
[
  "56f95673-925a-4b4a-993d-55903d8e1c36"
]
3 0.51 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:
[
  "56f95673-925a-4b4a-993d-55903d8e1c36"
]
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:
[
  "84fda44c-936e-43b4-9b10-b8a758904387"
]
5 0.46 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:
[
  "84fda44c-936e-43b4-9b10-b8a758904387"
]
6 0.62 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:
[
  "ef836630-e5fe-44ad-b57b-5a21da90f32c"
]
7 0.70 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:
[
  "ef836630-e5fe-44ad-b57b-5a21da90f32c"
]
8 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:
[
  "1dfc6135-1f6b-423c-94e6-dc60530fb9a4"
]
9 0.61 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:
[
  "1dfc6135-1f6b-423c-94e6-dc60530fb9a4"
]
10 0.67 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:
[
  "37e19e84-7220-4f39-9fd8-904a583b6000"
]
11 0.55 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:
[
  "37e19e84-7220-4f39-9fd8-904a583b6000"
]
12 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:
[
  "dc8fdd22-7b76-45e5-88e4-bb13ea2b4640"
]
13 0.46 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:
[
  "dc8fdd22-7b76-45e5-88e4-bb13ea2b4640"
]
14 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:
[
  "90499e3d-8078-4872-8e02-955aea239eaf"
]
15 0.40 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:
[
  "90499e3d-8078-4872-8e02-955aea239eaf"
]
16 0.44 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:
[
  "94e66836-69b3-4248-aea2-b939f0d7408e"
]
17 0.39 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:
[
  "94e66836-69b3-4248-aea2-b939f0d7408e"
]
18 1.13 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:
[
  "edd70c5b-3367-43f0-bfe9-056bf809123a"
]
19 0.37 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:
[
  "edd70c5b-3367-43f0-bfe9-056bf809123a"
]
20 0.38 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:
[
  "67fa7f48-4e84-4851-8998-c7e19cde39cc"
]
21 0.42 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:
[
  "67fa7f48-4e84-4851-8998-c7e19cde39cc"
]

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.