Query Metrics
3
Database Queries
3
Different statements
2.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.17 ms (40.68%) |
1 |
SELECT t0.id AS id_1, t0.data_inizio_programmata AS data_inizio_programmata_2, t0.data_fine_programmata AS data_fine_programmata_3, t0.data_inizio_reale AS data_inizio_reale_4, t0.data_fine_reale AS data_fine_reale_5, t0.tipologia AS tipologia_6, t0.chiuso AS chiuso_7, t0.note AS note_8, t0.ore_per_operatore AS ore_per_operatore_9, t0.link_maps AS link_maps_10, t0.cliente_id AS cliente_id_11 FROM appuntamento t0 WHERE t0.id = ?
Parameters:
[
"20366"
]
|
|
0.98 ms (34.06%) |
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:
[
44
]
|
|
0.72 ms (25.26%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.nome AS nome_4, u0_.cognome AS cognome_5, u0_.indirizzo AS indirizzo_6, u0_.localita AS localita_7, u0_.cap AS cap_8, u0_.provincia AS provincia_9, u0_.codice_fiscale AS codice_fiscale_10, u0_.email AS email_11, u0_.cellulare AS cellulare_12, u0_.data_assunzione AS data_assunzione_13, u0_.colore AS colore_14, u0_.costo_orario AS costo_orario_15, u0_.data_nascita AS data_nascita_16, u0_.ore_settimanali AS ore_settimanali_17, u0_.disabilitato AS disabilitato_18, u0_.deleted_at AS deleted_at_19 FROM utente u0_ WHERE (u0_.disabilitato = false) AND (u0_.deleted_at IS NULL OR u0_.deleted_at >= CURRENT_TIMESTAMP)
Parameters:
[] |
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\Appuntamento | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\Utente | No errors. |
| App\Entity\Report | No errors. |