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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.64 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:
[
  2023
  193
]
2 0.77 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:
[
  2023
  193
]
3 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:
[
  2023
  192
]
4 0.55 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:
[
  2023
  192
]
5 1.33 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:
[
  2023
  191
]
6 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:
[
  2023
  191
]
7 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:
[
  2023
  190
]
8 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:
[
  2023
  190
]
9 0.88 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:
[
  2023
  189
]
10 0.53 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:
[
  2023
  189
]
11 0.91 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:
[
  2023
  188
]
12 0.55 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:
[
  2023
  188
]
13 0.93 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:
[
  2023
  187
]
14 0.49 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:
[
  2023
  187
]
15 0.83 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:
[
  2023
  186
]
16 0.49 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:
[
  2023
  186
]
17 0.87 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:
[
  2023
  185
]
18 0.45 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:
[
  2023
  185
]
19 1.05 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:
[
  2023
  184
]
20 0.52 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:
[
  2023
  184
]

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.