Query Metrics

8 Database Queries
5 Different statements
6.82 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"
]

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.