GET https://www.danielecutilli.it/gestionale_adm/picklist

Query Metrics

3 Database Queries
3 Different statements
18.39 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.14 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nome_completo AS nome_completo_5, t0.username AS username_6, t0.account_id AS account_id_7 FROM admuser t0 WHERE t0.id = ?
Parameters:
[
  7
]
2 15.29 ms
SELECT a0_.codice AS codice_0, a1_.denominazione AS denominazione_1, a0_.nome_sito AS nome_sito_2, SUM(a0_.scarico) AS sclr_3, a1_.capacita AS capacita_4, a1_.taglio AS taglio_5, a2_.data_bolla AS data_bolla_6 FROM adm_elenco_movimenti a0_ INNER JOIN adm_bolle a2_ ON a0_.bolla_id = a2_.id, adm_db_nomi a1_ WHERE a2_.data_bolla = ? AND a0_.scarico > 0 AND a0_.nome_id = a1_.id AND a0_.tipo_cliente = ? GROUP BY a0_.codice, a0_.nome_sito
Parameters:
[
  "2024-12-23"
  "privato"
]
3 0.96 ms
SELECT t0.id AS id_1, t0.codice AS codice_2, t0.ragione_sociale AS ragione_sociale_3, t0.partita_iva AS partita_iva_4, t0.registration_date AS registration_date_5, t0.last_modify AS last_modify_6, t0.status AS status_7, t0.indirizzo AS indirizzo_8, t0.localita AS localita_9, t0.altri_dati AS altri_dati_10, t0.logo AS logo_11 FROM adm_account t0 WHERE t0.id = ?
Parameters:
[
  2
]

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.

Entities Mapping