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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.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:
[
  2024
  174
]
2 0.85 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
  174
]
3 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:
[
  2024
  173
]
4 0.86 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
  173
]
5 1.16 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
  172
]
6 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
  172
]
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:
[
  2024
  171
]
8 0.60 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
  171
]
9 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:
[
  2024
  170
]
10 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
  170
]
11 1.01 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
  169
]
12 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
  169
]
13 1.04 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
  168
]
14 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:
[
  2024
  168
]
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
  167
]
16 0.60 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
  167
]
17 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
  166
]
18 0.59 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
  166
]
19 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:
[
  2024
  165
]
20 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:
[
  2024
  165
]

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.