Query Metrics
97
Database Queries
4
Different statements
72.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
58.19 ms (79.77%) |
77 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nome AS nome_5, t0.cognome AS cognome_6, t0.indirizzo AS indirizzo_7, t0.localita AS localita_8, t0.cap AS cap_9, t0.provincia AS provincia_10, t0.codice_fiscale AS codice_fiscale_11, t0.email AS email_12, t0.cellulare AS cellulare_13, t0.data_assunzione AS data_assunzione_14, t0.colore AS colore_15, t0.costo_orario AS costo_orario_16, t0.data_nascita AS data_nascita_17, t0.ore_settimanali AS ore_settimanali_18, t0.disabilitato AS disabilitato_19, t0.deleted_at AS deleted_at_20 FROM utente t0 INNER JOIN appuntamento_utente ON t0.id = appuntamento_utente.utente_id WHERE appuntamento_utente.appuntamento_id = ? AND ((t0.deleted_at IS NULL OR t0.deleted_at >= CURRENT_TIMESTAMP))
Parameters:
[
20329
]
|
|
9.68 ms (13.27%) |
18 |
SELECT t0.id AS id_1, t0.codice_cliente AS codice_cliente_2, t0.ragione_sociale AS ragione_sociale_3, t0.indirizzo AS indirizzo_4, t0.localita AS localita_5, t0.cap AS cap_6, t0.provincia AS provincia_7, t0.partita_iva AS partita_iva_8, t0.codice_fiscale AS codice_fiscale_9, t0.email AS email_10, t0.pec AS pec_11, t0.codice_sdi AS codice_sdi_12, t0.iban AS iban_13, t0.telefono AS telefono_14, t0.referente AS referente_15, t0.descrizione_contratto AS descrizione_contratto_16, t0.contratto_attivo AS contratto_attivo_17, t0.costo_orario_contratto AS costo_orario_contratto_18, t0.ore_settimanali_contratto AS ore_settimanali_contratto_19, t0.data_inizio_contratto AS data_inizio_contratto_20, t0.ricavo_fisso_mensile AS ricavo_fisso_mensile_21, t0.link_maps AS link_maps_22, t0.documento_to_do AS documento_to_do_23, t0.minimo_ore_appuntamento AS minimo_ore_appuntamento_24, t0.deleted_at AS deleted_at_25, t0.condizione_pagamento_id AS condizione_pagamento_id_26 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
125
]
|
|
3.01 ms (4.13%) |
1 |
SELECT a0_.id AS id_0, a0_.data_inizio_programmata AS data_inizio_programmata_1, a0_.data_fine_programmata AS data_fine_programmata_2, a0_.data_inizio_reale AS data_inizio_reale_3, a0_.data_fine_reale AS data_fine_reale_4, a0_.tipologia AS tipologia_5, a0_.chiuso AS chiuso_6, a0_.note AS note_7, a0_.ore_per_operatore AS ore_per_operatore_8, a0_.link_maps AS link_maps_9, a0_.cliente_id AS cliente_id_10 FROM appuntamento a0_ WHERE EXISTS (SELECT 1 FROM appuntamento_utente a1_ WHERE a1_.appuntamento_id = a0_.id AND a1_.utente_id IN (?)) AND a0_.data_inizio_programmata >= ? AND a0_.data_inizio_programmata <= ?
Parameters:
[ 39 "2026-01-25 00:00" "2026-03-08 00:00" ] |
|
2.06 ms (2.83%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nome AS nome_5, t0.cognome AS cognome_6, t0.indirizzo AS indirizzo_7, t0.localita AS localita_8, t0.cap AS cap_9, t0.provincia AS provincia_10, t0.codice_fiscale AS codice_fiscale_11, t0.email AS email_12, t0.cellulare AS cellulare_13, t0.data_assunzione AS data_assunzione_14, t0.colore AS colore_15, t0.costo_orario AS costo_orario_16, t0.data_nascita AS data_nascita_17, t0.ore_settimanali AS ore_settimanali_18, t0.disabilitato AS disabilitato_19, t0.deleted_at AS deleted_at_20 FROM utente t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL OR t0.deleted_at >= CURRENT_TIMESTAMP))
Parameters:
[
39
]
|
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
| Class | Mapping errors |
|---|---|
| App\Entity\Utente | No errors. |
| App\Entity\Appuntamento | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\Report | No errors. |
| App\Entity\Pagamento | No errors. |
| App\Entity\ContattoCliente | No errors. |