Query Metrics
5
Database Queries
5
Different statements
14.20 ms
Query time
2
Invalid entities
76
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.81 ms |
SELECT t0.id AS id_1, t0.data_creazione AS data_creazione_2, t0.data_ultima_modifica AS data_ultima_modifica_3, t0.title AS title_4, t0.value AS value_5, t0.description AS description_6, t0.is_active AS is_active_7, t0.id_creatore AS id_creatore_8, t0.id_aggiornatore AS id_aggiornatore_9 FROM admin_config t0 WHERE t0.title = ?
Parameters:
[
"isMaintenance"
]
|
| 2 | 2.69 ms |
SELECT t0.data_creazione AS data_creazione_1, t0.data_ultima_modifica AS data_ultima_modifica_2, t0.nome AS nome_3, t0.module_name AS module_name_4, t0.slug AS slug_5, t0.note AS note_6, t0.is_active AS is_active_7, t0.id_servizio AS id_servizio_8, t0.id_creatore AS id_creatore_9, t0.id_aggiornatore AS id_aggiornatore_10 FROM servizio t0
Parameters:
[] |
| 3 | 1.80 ms |
SELECT c0_.data_creazione AS data_creazione_0, c0_.data_ultima_modifica AS data_ultima_modifica_1, c0_.titolo AS titolo_2, c0_.servizio AS servizio_3, c0_.chiave AS chiave_4, c0_.type AS type_5, c0_.options AS options_6, c0_.valore AS valore_7, c0_.descrizione AS descrizione_8, c0_.ordine AS ordine_9, c0_.id_configurazione AS id_configurazione_10, c0_.id_creatore AS id_creatore_11, c0_.id_aggiornatore AS id_aggiornatore_12, c0_.id_organizzazione AS id_organizzazione_13 FROM configurazione c0_ WHERE 1 = 1 AND c0_.id_organizzazione = ?
Parameters:
[
null
]
|
| 4 | 3.14 ms |
SELECT t0.data_creazione AS data_creazione_1, t0.data_ultima_modifica AS data_ultima_modifica_2, t0.nome AS nome_3, t0.note AS note_4, t0.org_params AS org_params_5, t0.max_users AS max_users_6, t0.historicize_days AS historicize_days_7, t0.language AS language_8, t0.org_prefix AS org_prefix_9, t0.org_slug AS org_slug_10, t0.secret AS secret_11, t0.is_active AS is_active_12, t0.id_organizzazione AS id_organizzazione_13, t0.id_creatore AS id_creatore_14, t0.id_aggiornatore AS id_aggiornatore_15, t0.id_avatar AS id_avatar_16 FROM organizzazione t0 WHERE t0.is_active = ? ORDER BY t0.nome ASC
Parameters:
[
1
]
|
| 5 | 4.78 ms |
SELECT t0.id AS id_1, t0.data_creazione AS data_creazione_2, t0.data_ultima_modifica AS data_ultima_modifica_3, t0.titolo AS titolo_4, t0.descrizione AS descrizione_5, t0.private_description AS private_description_6, t0.erp_cod AS erp_cod_7, t0.major_num AS major_num_8, t0.minor_num AS minor_num_9, t0.revision_num AS revision_num_10, t0.build_num AS build_num_11, t0.release_date AS release_date_12, t0.visible AS visible_13, t0.is_active AS is_active_14, t0.id_creatore AS id_creatore_15, t0.id_aggiornatore AS id_aggiornatore_16 FROM saas_release t0 WHERE t0.visible = ? ORDER BY t0.major_num DESC, t0.minor_num DESC, t0.revision_num DESC LIMIT 1
Parameters:
[
1
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Module | 41 |
| App\Entity\Organizzazione | 18 |
| App\Entity\Allegato | 9 |
| App\Entity\User | 6 |
| App\Entity\AdminConfig | 1 |
| App\Entity\Release | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\BaseEntity | No errors. |
| App\Entity\AdminConfig | No errors. |
| App\Entity\User |
|
| App\Entity\Module | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\Abilitazione | No errors. |
| App\Entity\ReleaseNote | No errors. |
| App\Entity\BaseOrgEntity | No errors. |
| App\Entity\Configurazione | No errors. |
| App\Entity\Organizzazione |
|
| App\Entity\Allegato | No errors. |
| App\Entity\RandomToken | No errors. |
| App\Entity\Appartenenza | No errors. |
| App\Entity\Agency | No errors. |
| App\Entity\PaymentTerm | No errors. |
| App\Entity\DeviceType | No errors. |
| App\Entity\Device | No errors. |
| App\Entity\TipoIva | No errors. |
| App\Entity\Contatto | No errors. |
| App\Entity\SmtpTransfer | No errors. |
| App\Entity\HomeNotification | No errors. |
| App\Entity\JsonCategory | No errors. |
| App\Entity\Release | No errors. |