Query Metrics
6
Database Queries
4
Different statements
22.73 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
12.50 ms (54.97%) |
1 |
SELECT c0_.id_contatto AS id_contatto_0, c0_.erp_cod AS erp_cod_1, c0_.auto_code AS auto_code_2, c0_.text_code AS text_code_3, c0_.supplier_code AS supplier_code_4, c0_.old_id_utente AS old_id_utente_5, c0_.priority AS priority_6, c0_.description AS description_7, c0_.cognome AS cognome_8, c0_.nome AS nome_9, c0_.search_label AS search_label_10, c0_.company AS company_11, c0_.partita_iva AS partita_iva_12, c0_.codice_fiscale AS codice_fiscale_13, c0_.rea AS rea_14, c0_.e_invoice_code AS e_invoice_code_15, c0_.note AS note_16, c0_.unpaid_note AS unpaid_note_17, c0_.documentation_note AS documentation_note_18, c0_.birth_date AS birth_date_19, c0_.birth_place AS birth_place_20, c0_.last_transfer_date AS last_transfer_date_21, c0_.last_transfer_check AS last_transfer_check_22, c0_.last_transfer_email_date AS last_transfer_email_date_23, c0_.last_sdd_date AS last_sdd_date_24, c0_.last_stats_email_date AS last_stats_email_date_25, c0_.last_recall_date AS last_recall_date_26, c0_.mandate_id AS mandate_id_27, c0_.mandate_date AS mandate_date_28, c0_.sdd_seq_tp AS sdd_seq_tp_29, c0_.iban AS iban_30, c0_.iban_owner AS iban_owner_31, c0_.iban_bic AS iban_bic_32, c0_.iban_currency_causal AS iban_currency_causal_33, c0_.gender_slug AS gender_slug_34, c0_.payment_supplier_note AS payment_supplier_note_35, c0_.payment_customer_note AS payment_customer_note_36, c0_.customer_order AS customer_order_37, c0_.supplier_order AS supplier_order_38, c0_.margin AS margin_39, c0_.slug AS slug_40, c0_.loyalty_category_slug AS loyalty_category_slug_41, c0_.periodicity AS periodicity_42, c0_.is_cliente AS is_cliente_43, c0_.is_supplier AS is_supplier_44, c0_.is_teacher AS is_teacher_45, c0_.is_student AS is_student_46, c0_.is_temporary AS is_temporary_47, c0_.is_standby AS is_standby_48, c0_.is_ceased_activity AS is_ceased_activity_49, c0_.is_persona AS is_persona_50, c0_.is_player AS is_player_51, c0_.is_privacy_accepted AS is_privacy_accepted_52, c0_.is_charged_cost AS is_charged_cost_53, c0_.is_vat_excluded AS is_vat_excluded_54, c0_.is_qualified AS is_qualified_55, c0_.is_multi_payment_supplier AS is_multi_payment_supplier_56, c0_.is_multi_payment_customer AS is_multi_payment_customer_57, c0_.is_stamp_applied AS is_stamp_applied_58, c0_.is_active AS is_active_59, c0_.charged_cost AS charged_cost_60, c0_.manual_balance AS manual_balance_61, c0_.external_logo_path AS external_logo_path_62, c0_.vat_nature AS vat_nature_63, c0_.vat_chargeability AS vat_chargeability_64, c0_.normative_reference AS normative_reference_65, c0_.doc_reference AS doc_reference_66, c0_.doc_reference_number AS doc_reference_number_67, c0_.doc_reference_date AS doc_reference_date_68, c0_.data_creazione AS data_creazione_69, c0_.data_ultima_modifica AS data_ultima_modifica_70, c0_.title AS title_71, c0_.indirizzo AS indirizzo_72, c0_.localita AS localita_73, c0_.regione AS regione_74, c0_.cap AS cap_75, u1_.id AS id_76, u1_.erp_cod AS erp_cod_77, u1_.username AS username_78, u1_.password AS password_79, u1_.nome AS nome_80, u1_.sigla AS sigla_81, u1_.email AS email_82, u1_.lingua AS lingua_83, u1_.color AS color_84, u1_.initial_page AS initial_page_85, u1_.login_token AS login_token_86, u1_.google_authenticator_secret AS google_authenticator_secret_87, u1_.planner_priority AS planner_priority_88, u1_.is_cliente AS is_cliente_89, u1_.is_sa AS is_sa_90, u1_.is_first_access AS is_first_access_91, u1_.is_google_authenticator_enable AS is_google_authenticator_enable_92, u1_.is_active AS is_active_93, u1_.is_operator AS is_operator_94, u1_.is_standby AS is_standby_95, u1_.is_maintenance_recipient AS is_maintenance_recipient_96, u1_.is_site_page_recipient AS is_site_page_recipient_97, u1_.is_accredia AS is_accredia_98, u1_.check_consistence AS check_consistence_99, u1_.planner_start_date AS planner_start_date_100, u1_.standby_start_date AS standby_start_date_101, u1_.standby_end_date AS standby_end_date_102, u1_.last_check_consistence AS last_check_consistence_103, u1_.last_access_date AS last_access_date_104, u1_.last_app_access_date AS last_app_access_date_105, u1_.data_creazione AS data_creazione_106, u1_.data_ultima_modifica AS data_ultima_modifica_107, c0_.id_birth_municipality AS id_birth_municipality_108, c0_.id_citizenship_municipality AS id_citizenship_municipality_109, c0_.id_vat_type AS id_vat_type_110, c0_.id_logo AS id_logo_111, c0_.id_iban_currency_causal_code AS id_iban_currency_causal_code_112, c0_.id_contact_source AS id_contact_source_113, c0_.id_contact_group AS id_contact_group_114, c0_.id_payment_method AS id_payment_method_115, c0_.id_termine_pagamento AS id_termine_pagamento_116, c0_.id_supplier_payment_method AS id_supplier_payment_method_117, c0_.id_supplier_payment_term AS id_supplier_payment_term_118, c0_.id_subscription AS id_subscription_119, c0_.id_reference AS id_reference_120, c0_.id_creatore AS id_creatore_121, c0_.id_aggiornatore AS id_aggiornatore_122, c0_.id_organizzazione AS id_organizzazione_123, c0_.id_provincia AS id_provincia_124, c0_.id_nazione AS id_nazione_125, u1_.id_avatar AS id_avatar_126, u1_.id_sign AS id_sign_127, u1_.id_contatto AS id_contatto_128, u1_.id_stage_model_category AS id_stage_model_category_129, u1_.id_creatore AS id_creatore_130, u1_.id_aggiornatore AS id_aggiornatore_131 FROM contatto c0_ LEFT JOIN user u1_ ON c0_.id_contatto = u1_.id_contatto WHERE (c0_.is_active = 1) AND (c0_.id_organizzazione = '' OR c0_.id_organizzazione is null) ORDER BY c0_.cognome ASC
Parameters:
[] |
|
4.47 ms (19.65%) |
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 = ?) AND (c0_.id_organizzazione = '' OR c0_.id_organizzazione is null)
Parameters:
[ "Project" "projectCodeFlag" ] |
|
3.93 ms (17.27%) |
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
]
|
|
1.84 ms (8.11%) |
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.