GET https://cortecostituzionale.strategiedigitali.net/elenco-pronunce/42

Query Metrics

20 Database Queries
2 Different statements
22.05 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.69 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  24
]
2 0.72 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  24
]
3 1.48 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  23
]
4 3.24 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  23
]
5 1.61 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  22
]
6 0.82 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  22
]
7 1.63 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  21
]
8 0.69 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  21
]
9 1.02 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  20
]
10 0.57 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  20
]
11 1.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  19
]
12 0.70 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  19
]
13 1.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  18
]
14 0.74 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  18
]
15 1.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  17
]
16 0.63 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  17
]
17 0.95 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  16
]
18 0.54 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  16
]
19 0.96 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.document AS document_4, t0.year AS year_5, t0.number AS number_6, t0.abstract AS abstract_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.publishing_status AS publishing_status_10 FROM english t0 WHERE t0.year = ? AND t0.number = ? LIMIT 1
Parameters:
[
  2024
  15
]
20 0.56 ms
SELECT t0.id AS id_1, t0.numero_sentenza AS numero_sentenza_2, t0.anno_sentenza AS anno_sentenza_3, t0.titolo AS titolo_4, t0.contenuto AS contenuto_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 legal_summary t0 WHERE t0.anno_sentenza = ? AND t0.numero_sentenza = ? LIMIT 1
Parameters:
[
  2024
  15
]

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.