Query Metrics
6
Database Queries
4
Different statements
21.60 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.40 ms (29.61%) |
1 |
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"
]
|
|
5.43 ms (25.14%) |
3 |
SELECT c0_.id_configurazione AS id_configurazione_0, c0_.titolo AS titolo_1, c0_.servizio AS servizio_2, c0_.chiave AS chiave_3, c0_.type AS type_4, c0_.options AS options_5, c0_.valore AS valore_6, c0_.descrizione AS descrizione_7, c0_.ordine AS ordine_8, c0_.data_creazione AS data_creazione_9, c0_.data_ultima_modifica AS data_ultima_modifica_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 c0_.servizio = ? AND c0_.chiave = ?
Parameters:
[ "Project" "projectCodeFlag" ] |
|
5.28 ms (24.42%) |
1 |
SELECT t0.id_organizzazione AS id_organizzazione_1, t0.nome AS nome_2, t0.note AS note_3, t0.org_params AS org_params_4, t0.max_users AS max_users_5, t0.language AS language_6, t0.org_prefix AS org_prefix_7, t0.org_slug AS org_slug_8, t0.secret AS secret_9, t0.data_creazione AS data_creazione_10, t0.data_ultima_modifica AS data_ultima_modifica_11, t0.is_active AS is_active_12, t0.id_avatar AS id_avatar_13, t0.id_creatore AS id_creatore_14, t0.id_aggiornatore AS id_aggiornatore_15 FROM organizzazione t0 WHERE t0.is_active = ? ORDER BY t0.nome ASC
Parameters:
[
1
]
|
|
4.50 ms (20.83%) |
1 |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\BaseEntity | No errors. |
| App\Entity\AdminConfig | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Configurazione | No errors. |
| App\Entity\Organizzazione |
|
| App\Entity\Allegato | No errors. |
| App\Entity\Abilitazione | No errors. |
| App\Entity\RandomToken | No errors. |
| App\Entity\Appartenenza | No errors. |
| App\Entity\BaseOrgEntity | 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\HomeNotification | No errors. |
| App\Entity\JsonCategory | No errors. |
| App\Entity\Release | No errors. |
| App\Entity\ReleaseNote | No errors. |