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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.77 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:
[
  2021
  97
]
2 0.61 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:
[
  2021
  97
]
3 1.06 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:
[
  2021
  96
]
4 0.58 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:
[
  2021
  96
]
5 0.97 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:
[
  2021
  95
]
6 0.50 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:
[
  2021
  95
]
7 1.00 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:
[
  2021
  94
]
8 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:
[
  2021
  94
]
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:
[
  2021
  93
]
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:
[
  2021
  93
]
11 1.10 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:
[
  2021
  92
]
12 0.48 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:
[
  2021
  92
]
13 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:
[
  2021
  91
]
14 0.36 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:
[
  2021
  91
]
15 0.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:
[
  2021
  90
]
16 0.64 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:
[
  2021
  90
]
17 0.81 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:
[
  2021
  89
]
18 0.47 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:
[
  2021
  89
]
19 1.59 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:
[
  2021
  88
]
20 0.51 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:
[
  2021
  88
]

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.