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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.30 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
  67
]
2 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
  67
]
3 0.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:
[
  2021
  66
]
4 0.35 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
  66
]
5 0.60 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
  65
]
6 0.33 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
  65
]
7 0.66 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
  64
]
8 0.44 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
  64
]
9 0.57 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
  63
]
10 0.39 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
  63
]
11 0.99 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
  62
]
12 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
  62
]
13 0.71 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
  61
]
14 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
  61
]
15 0.75 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
  60
]
16 0.62 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
  60
]
17 0.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:
[
  2021
  59
]
18 0.46 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
  59
]
19 0.70 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
  58
]
20 0.44 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
  58
]

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.