Query Metrics
119
Database Queries
8
Different statements
61.38 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
50.32 ms (81.98%) |
107 |
SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.descrizione AS descrizione_3, t0.is_preferito AS is_preferito_4, t0.data_creazione AS data_creazione_5, t0.data_ultima_modifica AS data_ultima_modifica_6, t0.is_active AS is_active_7, t0.id_creatore AS id_creatore_8, t0.id_aggiornatore AS id_aggiornatore_9, t0.id_organizzazione AS id_organizzazione_10 FROM articolo t0 WHERE t0.id = ? AND ((t0.id_organizzazione = '4' OR t0.id_organizzazione is null))
Parameters:
[
"215"
]
|
|
3.60 ms (5.87%) |
4 |
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 = ?) AND (c0_.id_organizzazione = '4' OR c0_.id_organizzazione is null)
Parameters:
[ "Globale" "twoFactorAuthentication" ] |
|
2.43 ms (3.95%) |
3 |
SELECT t0.id AS id_1, t0.erp_cod AS erp_cod_2, t0.username AS username_3, t0.password AS password_4, t0.nome AS nome_5, t0.sigla AS sigla_6, t0.email AS email_7, t0.lingua AS lingua_8, t0.color AS color_9, t0.initial_page AS initial_page_10, t0.login_token AS login_token_11, t0.google_authenticator_secret AS google_authenticator_secret_12, t0.planner_priority AS planner_priority_13, t0.is_cliente AS is_cliente_14, t0.is_sa AS is_sa_15, t0.is_first_access AS is_first_access_16, t0.is_google_authenticator_enable AS is_google_authenticator_enable_17, t0.is_active AS is_active_18, t0.is_operator AS is_operator_19, t0.is_standby AS is_standby_20, t0.is_maintenance_recipient AS is_maintenance_recipient_21, t0.is_site_page_recipient AS is_site_page_recipient_22, t0.is_accredia AS is_accredia_23, t0.check_consistence AS check_consistence_24, t0.planner_start_date AS planner_start_date_25, t0.standby_start_date AS standby_start_date_26, t0.standby_end_date AS standby_end_date_27, t0.last_check_consistence AS last_check_consistence_28, t0.last_access_date AS last_access_date_29, t0.last_app_access_date AS last_app_access_date_30, t0.data_creazione AS data_creazione_31, t0.data_ultima_modifica AS data_ultima_modifica_32, t0.id_avatar AS id_avatar_33, t0.id_sign AS id_sign_34, t0.id_contatto AS id_contatto_35, t0.id_stage_model_category AS id_stage_model_category_36, t0.id_creatore AS id_creatore_37, t0.id_aggiornatore AS id_aggiornatore_38 FROM user t0 WHERE t0.id = ?
Parameters:
[
55
]
|
|
2.03 ms (3.30%) |
1 |
SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.descrizione AS descrizione_3, t0.is_comprato AS is_comprato_4, t0.quantita AS quantita_5, t0.data_creazione AS data_creazione_6, t0.data_ultima_modifica AS data_ultima_modifica_7, t0.is_active AS is_active_8, t0.id_spesa AS id_spesa_9, t0.id_articolo AS id_articolo_10, t0.id_creatore AS id_creatore_11, t0.id_aggiornatore AS id_aggiornatore_12, t0.id_organizzazione AS id_organizzazione_13 FROM lista_spesa t0 WHERE t0.id_spesa = ? AND ((t0.id_organizzazione = '4' OR t0.id_organizzazione is null)) ORDER BY t0.is_comprato ASC
Parameters:
[
"336"
]
|
|
1.05 ms (1.71%) |
1 |
SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.descrizione AS descrizione_3, t0.is_archiviato AS is_archiviato_4, t0.data_creazione AS data_creazione_5, t0.data_ultima_modifica AS data_ultima_modifica_6, t0.is_active AS is_active_7, t0.id_creatore AS id_creatore_8, t0.id_aggiornatore AS id_aggiornatore_9, t0.id_organizzazione AS id_organizzazione_10 FROM spesa t0 WHERE t0.is_active = ? AND t0.id = ? AND ((t0.id_organizzazione = '4' OR t0.id_organizzazione is null)) LIMIT 1
Parameters:
[ 1 "336" ] |
|
0.69 ms (1.13%) |
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
]
|
|
0.67 ms (1.08%) |
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.id_organizzazione = ?
Parameters:
[
"4"
]
|
|
0.60 ms (0.99%) |
1 |
SELECT t0.title AS title_1, t0.value AS value_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.id AS id_5, t0.data_creazione AS data_creazione_6, t0.data_ultima_modifica AS data_ultima_modifica_7, t0.id_creatore AS id_creatore_8, t0.id_aggiornatore AS id_aggiornatore_9 FROM admin_config t0 WHERE t0.title = ?
Parameters:
[
"isMaintenance"
]
|
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.