Symfony Profiler

SELECT
  c0_.data_creazione AS data_creazione_0,
  c0_.data_ultima_modifica AS data_ultima_modifica_1,
  c0_.erp_cod AS erp_cod_2,
  c0_.auto_code AS auto_code_3,
  c0_.text_code AS text_code_4,
  c0_.supplier_code AS supplier_code_5,
  c0_.old_id_utente AS old_id_utente_6,
  c0_.priority AS priority_7,
  c0_.description AS description_8,
  c0_.cognome AS cognome_9,
  c0_.nome AS nome_10,
  c0_.search_label AS search_label_11,
  c0_.company AS company_12,
  c0_.partita_iva AS partita_iva_13,
  c0_.codice_fiscale AS codice_fiscale_14,
  c0_.rea AS rea_15,
  c0_.e_invoice_code AS e_invoice_code_16,
  c0_.note AS note_17,
  c0_.unpaid_note AS unpaid_note_18,
  c0_.documentation_note AS documentation_note_19,
  c0_.birth_date AS birth_date_20,
  c0_.birth_place AS birth_place_21,
  c0_.last_transfer_date AS last_transfer_date_22,
  c0_.last_transfer_check AS last_transfer_check_23,
  c0_.last_transfer_email_date AS last_transfer_email_date_24,
  c0_.last_sdd_date AS last_sdd_date_25,
  c0_.last_stats_email_date AS last_stats_email_date_26,
  c0_.last_recall_date AS last_recall_date_27,
  c0_.mandate_id AS mandate_id_28,
  c0_.mandate_date AS mandate_date_29,
  c0_.sdd_seq_tp AS sdd_seq_tp_30,
  c0_.iban AS iban_31,
  c0_.iban_owner AS iban_owner_32,
  c0_.iban_owner_fiscal_code AS iban_owner_fiscal_code_33,
  c0_.iban_bic AS iban_bic_34,
  c0_.iban_currency_causal AS iban_currency_causal_35,
  c0_.gender_slug AS gender_slug_36,
  c0_.payment_supplier_note AS payment_supplier_note_37,
  c0_.payment_customer_note AS payment_customer_note_38,
  c0_.deploy_org_prefix AS deploy_org_prefix_39,
  c0_.customer_order AS customer_order_40,
  c0_.supplier_order AS supplier_order_41,
  c0_.margin AS margin_42,
  c0_.slug AS slug_43,
  c0_.loyalty_category_slug AS loyalty_category_slug_44,
  c0_.periodicity AS periodicity_45,
  c0_.is_cliente AS is_cliente_46,
  c0_.is_supplier AS is_supplier_47,
  c0_.is_teacher AS is_teacher_48,
  c0_.is_student AS is_student_49,
  c0_.is_temporary AS is_temporary_50,
  c0_.is_standby AS is_standby_51,
  c0_.is_ceased_activity AS is_ceased_activity_52,
  c0_.is_persona AS is_persona_53,
  c0_.is_player AS is_player_54,
  c0_.is_privacy_accepted AS is_privacy_accepted_55,
  c0_.is_charged_cost AS is_charged_cost_56,
  c0_.is_vat_excluded AS is_vat_excluded_57,
  c0_.is_qualified AS is_qualified_58,
  c0_.is_multi_payment_supplier AS is_multi_payment_supplier_59,
  c0_.is_multi_payment_customer AS is_multi_payment_customer_60,
  c0_.is_stamp_applied AS is_stamp_applied_61,
  c0_.is_active AS is_active_62,
  c0_.charged_cost AS charged_cost_63,
  c0_.is_charged_cost_excluded AS is_charged_cost_excluded_64,
  c0_.manual_balance AS manual_balance_65,
  c0_.external_logo_path AS external_logo_path_66,
  c0_.vat_nature AS vat_nature_67,
  c0_.vat_chargeability AS vat_chargeability_68,
  c0_.saved_data AS saved_data_69,
  c0_.normative_reference AS normative_reference_70,
  c0_.doc_reference AS doc_reference_71,
  c0_.doc_reference_number AS doc_reference_number_72,
  c0_.doc_reference_date AS doc_reference_date_73,
  c0_.title AS title_74,
  c0_.indirizzo AS indirizzo_75,
  c0_.localita AS localita_76,
  c0_.regione AS regione_77,
  c0_.cap AS cap_78,
  c0_.historicized AS historicized_79,
  c0_.id_contatto AS id_contatto_80,
  u1_.id AS id_81,
  u1_.erp_cod AS erp_cod_82,
  u1_.username AS username_83,
  u1_.password AS password_84,
  u1_.nome AS nome_85,
  u1_.sigla AS sigla_86,
  u1_.email AS email_87,
  u1_.lingua AS lingua_88,
  u1_.color AS color_89,
  u1_.initial_page AS initial_page_90,
  u1_.login_token AS login_token_91,
  u1_.google_authenticator_secret AS google_authenticator_secret_92,
  u1_.planner_priority AS planner_priority_93,
  u1_.is_cliente AS is_cliente_94,
  u1_.is_tester AS is_tester_95,
  u1_.is_sa AS is_sa_96,
  u1_.is_first_access AS is_first_access_97,
  u1_.is_google_authenticator_enable AS is_google_authenticator_enable_98,
  u1_.is2fa_email_enable AS is2fa_email_enable_99,
  u1_.is_active AS is_active_100,
  u1_.is_operator AS is_operator_101,
  u1_.is_standby AS is_standby_102,
  u1_.is_produced_product_recipient AS is_produced_product_recipient_103,
  u1_.is_production_batch_update AS is_production_batch_update_104,
  u1_.is_maintenance_recipient AS is_maintenance_recipient_105,
  u1_.is_maintenance_recipient_device AS is_maintenance_recipient_device_106,
  u1_.is_external_maintenance_recipient_device AS is_external_maintenance_recipient_device_107,
  u1_.is_internal_maintenance_recipient_device AS is_internal_maintenance_recipient_device_108,
  u1_.is_site_page_recipient AS is_site_page_recipient_109,
  u1_.is_accredia AS is_accredia_110,
  u1_.check_consistence AS check_consistence_111,
  u1_.planner_start_date AS planner_start_date_112,
  u1_.standby_start_date AS standby_start_date_113,
  u1_.standby_end_date AS standby_end_date_114,
  u1_.last_check_consistence AS last_check_consistence_115,
  u1_.last_access_date AS last_access_date_116,
  u1_.last_app_access_date AS last_app_access_date_117,
  u1_.data_creazione AS data_creazione_118,
  u1_.data_ultima_modifica AS data_ultima_modifica_119,
  c0_.id_creatore AS id_creatore_120,
  c0_.id_aggiornatore AS id_aggiornatore_121,
  c0_.id_organizzazione AS id_organizzazione_122,
  c0_.id_chart_account AS id_chart_account_123,
  c0_.id_customer_category AS id_customer_category_124,
  c0_.id_agent AS id_agent_125,
  c0_.id_birth_municipality AS id_birth_municipality_126,
  c0_.id_citizenship_municipality AS id_citizenship_municipality_127,
  c0_.id_vat_type AS id_vat_type_128,
  c0_.id_logo AS id_logo_129,
  c0_.id_agency AS id_agency_130,
  c0_.id_iban_currency_causal_code AS id_iban_currency_causal_code_131,
  c0_.id_contact_source AS id_contact_source_132,
  c0_.id_contact_group AS id_contact_group_133,
  c0_.id_payment_method AS id_payment_method_134,
  c0_.id_termine_pagamento AS id_termine_pagamento_135,
  c0_.id_supplier_payment_method AS id_supplier_payment_method_136,
  c0_.id_supplier_payment_term AS id_supplier_payment_term_137,
  c0_.id_subscription AS id_subscription_138,
  c0_.id_reference AS id_reference_139,
  c0_.id_provincia AS id_provincia_140,
  c0_.id_nazione AS id_nazione_141,
  u1_.id_avatar AS id_avatar_142,
  u1_.id_sign AS id_sign_143,
  u1_.id_contatto AS id_contatto_144,
  u1_.id_stage_model_category AS id_stage_model_category_145,
  u1_.id_creatore AS id_creatore_146,
  u1_.id_aggiornatore AS id_aggiornatore_147
FROM
  contatto c0_
  LEFT JOIN user u1_ ON c0_.id_contatto = u1_.id_contatto
WHERE
  c0_.is_active = 1
ORDER BY
  c0_.cognome ASC

SELECT c0_.data_creazione AS data_creazione_0, c0_.data_ultima_modifica AS data_ultima_modifica_1, c0_.erp_cod AS erp_cod_2, c0_.auto_code AS auto_code_3, c0_.text_code AS text_code_4, c0_.supplier_code AS supplier_code_5, c0_.old_id_utente AS old_id_utente_6, c0_.priority AS priority_7, c0_.description AS description_8, c0_.cognome AS cognome_9, c0_.nome AS nome_10, c0_.search_label AS search_label_11, c0_.company AS company_12, c0_.partita_iva AS partita_iva_13, c0_.codice_fiscale AS codice_fiscale_14, c0_.rea AS rea_15, c0_.e_invoice_code AS e_invoice_code_16, c0_.note AS note_17, c0_.unpaid_note AS unpaid_note_18, c0_.documentation_note AS documentation_note_19, c0_.birth_date AS birth_date_20, c0_.birth_place AS birth_place_21, c0_.last_transfer_date AS last_transfer_date_22, c0_.last_transfer_check AS last_transfer_check_23, c0_.last_transfer_email_date AS last_transfer_email_date_24, c0_.last_sdd_date AS last_sdd_date_25, c0_.last_stats_email_date AS last_stats_email_date_26, c0_.last_recall_date AS last_recall_date_27, c0_.mandate_id AS mandate_id_28, c0_.mandate_date AS mandate_date_29, c0_.sdd_seq_tp AS sdd_seq_tp_30, c0_.iban AS iban_31, c0_.iban_owner AS iban_owner_32, c0_.iban_owner_fiscal_code AS iban_owner_fiscal_code_33, c0_.iban_bic AS iban_bic_34, c0_.iban_currency_causal AS iban_currency_causal_35, c0_.gender_slug AS gender_slug_36, c0_.payment_supplier_note AS payment_supplier_note_37, c0_.payment_customer_note AS payment_customer_note_38, c0_.deploy_org_prefix AS deploy_org_prefix_39, c0_.customer_order AS customer_order_40, c0_.supplier_order AS supplier_order_41, c0_.margin AS margin_42, c0_.slug AS slug_43, c0_.loyalty_category_slug AS loyalty_category_slug_44, c0_.periodicity AS periodicity_45, c0_.is_cliente AS is_cliente_46, c0_.is_supplier AS is_supplier_47, c0_.is_teacher AS is_teacher_48, c0_.is_student AS is_student_49, c0_.is_temporary AS is_temporary_50, c0_.is_standby AS is_standby_51, c0_.is_ceased_activity AS is_ceased_activity_52, c0_.is_persona AS is_persona_53, c0_.is_player AS is_player_54, c0_.is_privacy_accepted AS is_privacy_accepted_55, c0_.is_charged_cost AS is_charged_cost_56, c0_.is_vat_excluded AS is_vat_excluded_57, c0_.is_qualified AS is_qualified_58, c0_.is_multi_payment_supplier AS is_multi_payment_supplier_59, c0_.is_multi_payment_customer AS is_multi_payment_customer_60, c0_.is_stamp_applied AS is_stamp_applied_61, c0_.is_active AS is_active_62, c0_.charged_cost AS charged_cost_63, c0_.is_charged_cost_excluded AS is_charged_cost_excluded_64, c0_.manual_balance AS manual_balance_65, c0_.external_logo_path AS external_logo_path_66, c0_.vat_nature AS vat_nature_67, c0_.vat_chargeability AS vat_chargeability_68, c0_.saved_data AS saved_data_69, c0_.normative_reference AS normative_reference_70, c0_.doc_reference AS doc_reference_71, c0_.doc_reference_number AS doc_reference_number_72, c0_.doc_reference_date AS doc_reference_date_73, c0_.title AS title_74, c0_.indirizzo AS indirizzo_75, c0_.localita AS localita_76, c0_.regione AS regione_77, c0_.cap AS cap_78, c0_.historicized AS historicized_79, c0_.id_contatto AS id_contatto_80, u1_.id AS id_81, u1_.erp_cod AS erp_cod_82, u1_.username AS username_83, u1_.password AS password_84, u1_.nome AS nome_85, u1_.sigla AS sigla_86, u1_.email AS email_87, u1_.lingua AS lingua_88, u1_.color AS color_89, u1_.initial_page AS initial_page_90, u1_.login_token AS login_token_91, u1_.google_authenticator_secret AS google_authenticator_secret_92, u1_.planner_priority AS planner_priority_93, u1_.is_cliente AS is_cliente_94, u1_.is_tester AS is_tester_95, u1_.is_sa AS is_sa_96, u1_.is_first_access AS is_first_access_97, u1_.is_google_authenticator_enable AS is_google_authenticator_enable_98, u1_.is2fa_email_enable AS is2fa_email_enable_99, u1_.is_active AS is_active_100, u1_.is_operator AS is_operator_101, u1_.is_standby AS is_standby_102, u1_.is_produced_product_recipient AS is_produced_product_recipient_103, u1_.is_production_batch_update AS is_production_batch_update_104, u1_.is_maintenance_recipient AS is_maintenance_recipient_105, u1_.is_maintenance_recipient_device AS is_maintenance_recipient_device_106, u1_.is_external_maintenance_recipient_device AS is_external_maintenance_recipient_device_107, u1_.is_internal_maintenance_recipient_device AS is_internal_maintenance_recipient_device_108, u1_.is_site_page_recipient AS is_site_page_recipient_109, u1_.is_accredia AS is_accredia_110, u1_.check_consistence AS check_consistence_111, u1_.planner_start_date AS planner_start_date_112, u1_.standby_start_date AS standby_start_date_113, u1_.standby_end_date AS standby_end_date_114, u1_.last_check_consistence AS last_check_consistence_115, u1_.last_access_date AS last_access_date_116, u1_.last_app_access_date AS last_app_access_date_117, u1_.data_creazione AS data_creazione_118, u1_.data_ultima_modifica AS data_ultima_modifica_119, c0_.id_creatore AS id_creatore_120, c0_.id_aggiornatore AS id_aggiornatore_121, c0_.id_organizzazione AS id_organizzazione_122, c0_.id_chart_account AS id_chart_account_123, c0_.id_customer_category AS id_customer_category_124, c0_.id_agent AS id_agent_125, c0_.id_birth_municipality AS id_birth_municipality_126, c0_.id_citizenship_municipality AS id_citizenship_municipality_127, c0_.id_vat_type AS id_vat_type_128, c0_.id_logo AS id_logo_129, c0_.id_agency AS id_agency_130, c0_.id_iban_currency_causal_code AS id_iban_currency_causal_code_131, c0_.id_contact_source AS id_contact_source_132, c0_.id_contact_group AS id_contact_group_133, c0_.id_payment_method AS id_payment_method_134, c0_.id_termine_pagamento AS id_termine_pagamento_135, c0_.id_supplier_payment_method AS id_supplier_payment_method_136, c0_.id_supplier_payment_term AS id_supplier_payment_term_137, c0_.id_subscription AS id_subscription_138, c0_.id_reference AS id_reference_139, c0_.id_provincia AS id_provincia_140, c0_.id_nazione AS id_nazione_141, u1_.id_avatar AS id_avatar_142, u1_.id_sign AS id_sign_143, u1_.id_contatto AS id_contatto_144, u1_.id_stage_model_category AS id_stage_model_category_145, u1_.id_creatore AS id_creatore_146, u1_.id_aggiornatore AS id_aggiornatore_147 FROM contatto c0_ LEFT JOIN user u1_ ON c0_.id_contatto = u1_.id_contatto WHERE c0_.is_active = 1 ORDER BY c0_.cognome ASC;

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

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 = 1 ORDER BY t0.nome ASC;

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

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 = 1 ORDER BY t0.major_num DESC, t0.minor_num DESC, t0.revision_num DESC LIMIT 1;

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

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;

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 = ?

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 = NULL;

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 = ?

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 = 'isMaintenance';