GET https://cortecostituzionale.strategiedigitali.net/

Query Metrics

49 Database Queries
8 Different statements
29.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.08 ms
SELECT t0.id AS id_1, t0.posizione_ultimo_deposito AS posizione_ultimo_deposito_2, t0.numero_comunicati_homepage AS numero_comunicati_homepage_3, t0.dimensione_pagina_podcast AS dimensione_pagina_podcast_4, t0.homepage_video AS homepage_video_5, t0.second_homepage_video AS second_homepage_video_6 FROM configuration t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
2 1.00 ms
SELECT t0.id AS id_1, t0.posizione_ultimo_deposito AS posizione_ultimo_deposito_2, t0.numero_comunicati_homepage AS numero_comunicati_homepage_3, t0.dimensione_pagina_podcast AS dimensione_pagina_podcast_4, t0.homepage_video AS homepage_video_5, t0.second_homepage_video AS second_homepage_video_6 FROM configuration t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]
3 2.13 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.section AS section_3, t0.year AS year_4, t0.number AS number_5, t0.title AS title_6, t0.description AS description_7, t0.headline AS headline_8, t0.in_home AS in_home_9, t0.to_send AS to_send_10, t0.sent_at AS sent_at_11, t0.remote_id AS remote_id_12, t0.button_label AS button_label_13, t0.button_decree_label AS button_decree_label_14, t0.created_at AS created_at_15, t0.deleted_at AS deleted_at_16, t0.publishing_status AS publishing_status_17, t0.ordering AS ordering_18, t0.document_name AS document_name_19, t0.document_original_name AS document_original_name_20, t0.document_url AS document_url_21, t0.decree_name AS decree_name_22, t0.decree_original_name AS decree_original_name_23, t0.decree_url AS decree_url_24 FROM releases t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = ? AND t0.in_home = ? ORDER BY t0.date DESC LIMIT 20
Parameters:
[
  "published"
  1
]
4 0.91 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.link AS link_3, t0.ordering AS ordering_4, t0.release_id AS release_id_5 FROM release_link t0 WHERE t0.release_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "f5facce5-97cb-4d5d-a43d-1a8dfa5c4ca4"
  "889d7efe-2957-4d21-bf2e-be783acfdcb7"
  "aad88efb-b516-42a2-bc8a-3f71c7c28812"
  "c8dd8276-b3de-41e0-a116-ba5c928a17ca"
  "ab9e634a-ae68-41ae-bbfb-c922592a9667"
  "76619dfc-6f95-47f4-84f2-b04f80d4460f"
  "dd13a19a-f082-4e22-a549-010da3f96017"
  "05767d61-8512-4cb7-b5ad-1517811aa6b6"
  "d85cd8ec-1375-4a51-8d08-294108d53804"
  "c2c316cf-53fd-4ff0-983d-a9100addf29b"
  "f957a47d-2c76-42ed-8b64-6549a03e8494"
  "5a551ea7-04f6-4b5f-b944-13af49df0a28"
  "7157fa74-ec22-4654-bcf9-9e78308bc3b5"
  "8b85f5c2-1123-4c6b-9757-9e7fccf4f1a4"
  "19e5315a-a5a0-41a7-b336-d3fadbd3a887"
  "128e2276-5bbb-400f-b3a8-448df37efb08"
  "45eafe7f-1220-41d6-a389-7a6f25739941"
  "9ce5a968-fff6-46c2-9d69-a7e4ba99456f"
  "5fc6a059-1855-4d57-a6fe-8eaf8db4968b"
  "908c3f40-8e7c-4676-bcd5-588575075ff9"
]
5 0.48 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "f5facce5-97cb-4d5d-a43d-1a8dfa5c4ca4"
]
6 0.41 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "f5facce5-97cb-4d5d-a43d-1a8dfa5c4ca4"
]
7 0.46 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "c8dd8276-b3de-41e0-a116-ba5c928a17ca"
]
8 0.37 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "c8dd8276-b3de-41e0-a116-ba5c928a17ca"
]
9 1.15 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "889d7efe-2957-4d21-bf2e-be783acfdcb7"
]
10 0.63 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "889d7efe-2957-4d21-bf2e-be783acfdcb7"
]
11 0.86 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "aad88efb-b516-42a2-bc8a-3f71c7c28812"
]
12 0.69 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "aad88efb-b516-42a2-bc8a-3f71c7c28812"
]
13 0.64 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "ab9e634a-ae68-41ae-bbfb-c922592a9667"
]
14 0.57 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "ab9e634a-ae68-41ae-bbfb-c922592a9667"
]
15 0.48 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "76619dfc-6f95-47f4-84f2-b04f80d4460f"
]
16 0.47 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "76619dfc-6f95-47f4-84f2-b04f80d4460f"
]
17 0.47 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "dd13a19a-f082-4e22-a549-010da3f96017"
]
18 0.49 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "dd13a19a-f082-4e22-a549-010da3f96017"
]
19 0.53 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "05767d61-8512-4cb7-b5ad-1517811aa6b6"
]
20 0.59 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "05767d61-8512-4cb7-b5ad-1517811aa6b6"
]
21 0.86 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "d85cd8ec-1375-4a51-8d08-294108d53804"
]
22 0.60 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "d85cd8ec-1375-4a51-8d08-294108d53804"
]
23 0.67 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "c2c316cf-53fd-4ff0-983d-a9100addf29b"
]
24 0.49 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "c2c316cf-53fd-4ff0-983d-a9100addf29b"
]
25 0.68 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "f957a47d-2c76-42ed-8b64-6549a03e8494"
]
26 0.53 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "f957a47d-2c76-42ed-8b64-6549a03e8494"
]
27 0.43 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "7157fa74-ec22-4654-bcf9-9e78308bc3b5"
]
28 0.40 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "7157fa74-ec22-4654-bcf9-9e78308bc3b5"
]
29 0.45 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "5a551ea7-04f6-4b5f-b944-13af49df0a28"
]
30 0.45 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "5a551ea7-04f6-4b5f-b944-13af49df0a28"
]
31 0.45 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "8b85f5c2-1123-4c6b-9757-9e7fccf4f1a4"
]
32 0.47 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "8b85f5c2-1123-4c6b-9757-9e7fccf4f1a4"
]
33 0.57 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "19e5315a-a5a0-41a7-b336-d3fadbd3a887"
]
34 0.41 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "19e5315a-a5a0-41a7-b336-d3fadbd3a887"
]
35 0.52 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "45eafe7f-1220-41d6-a389-7a6f25739941"
]
36 0.42 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "45eafe7f-1220-41d6-a389-7a6f25739941"
]
37 0.45 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "128e2276-5bbb-400f-b3a8-448df37efb08"
]
38 0.40 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "128e2276-5bbb-400f-b3a8-448df37efb08"
]
39 0.40 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "908c3f40-8e7c-4676-bcd5-588575075ff9"
]
40 0.39 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "908c3f40-8e7c-4676-bcd5-588575075ff9"
]
41 0.43 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "9ce5a968-fff6-46c2-9d69-a7e4ba99456f"
]
42 0.44 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "9ce5a968-fff6-46c2-9d69-a7e4ba99456f"
]
43 0.45 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.image AS image_3, t0.release_id AS release_id_4 FROM release_image t0 WHERE t0.release_id = ?
Parameters:
[
  "5fc6a059-1855-4d57-a6fe-8eaf8db4968b"
]
44 0.42 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.embed AS embed_3, t0.release_id AS release_id_4 FROM release_video t0 WHERE t0.release_id = ?
Parameters:
[
  "5fc6a059-1855-4d57-a6fe-8eaf8db4968b"
]
45 1.37 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 2
Parameters:
[
  "published"
]
46 0.66 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"
]
47 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:
[
  "c47e4ab0-58a5-4e9f-8320-81692bfe5203"
]
48 0.49 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"
]
49 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:
[
  "45707232-b9a3-4e3b-8969-ad7019541b77"
]

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.