Symfony Profiler

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

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
  )

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 = 'Project' AND c0_.chiave = 'projectCodeFlag') AND (c0_.id_organizzazione = '' OR c0_.id_organizzazione is null);

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
  )

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 = 'Contract' AND c0_.chiave = 'contractCodeFlag') AND (c0_.id_organizzazione = '' OR c0_.id_organizzazione is null);

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
  )

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 = 'Contact' AND c0_.chiave = 'contactCodeFlag') AND (c0_.id_organizzazione = '' OR c0_.id_organizzazione is null);

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

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 = 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
  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_owner_fiscal_code AS iban_owner_fiscal_code_32,
  c0_.iban_bic AS iban_bic_33,
  c0_.iban_currency_causal AS iban_currency_causal_34,
  c0_.gender_slug AS gender_slug_35,
  c0_.payment_supplier_note AS payment_supplier_note_36,
  c0_.payment_customer_note AS payment_customer_note_37,
  c0_.deploy_org_prefix AS deploy_org_prefix_38,
  c0_.customer_order AS customer_order_39,
  c0_.supplier_order AS supplier_order_40,
  c0_.margin AS margin_41,
  c0_.slug AS slug_42,
  c0_.loyalty_category_slug AS loyalty_category_slug_43,
  c0_.periodicity AS periodicity_44,
  c0_.is_cliente AS is_cliente_45,
  c0_.is_supplier AS is_supplier_46,
  c0_.is_teacher AS is_teacher_47,
  c0_.is_student AS is_student_48,
  c0_.is_temporary AS is_temporary_49,
  c0_.is_standby AS is_standby_50,
  c0_.is_ceased_activity AS is_ceased_activity_51,
  c0_.is_persona AS is_persona_52,
  c0_.is_player AS is_player_53,
  c0_.is_privacy_accepted AS is_privacy_accepted_54,
  c0_.is_charged_cost AS is_charged_cost_55,
  c0_.is_vat_excluded AS is_vat_excluded_56,
  c0_.is_qualified AS is_qualified_57,
  c0_.is_multi_payment_supplier AS is_multi_payment_supplier_58,
  c0_.is_multi_payment_customer AS is_multi_payment_customer_59,
  c0_.is_stamp_applied AS is_stamp_applied_60,
  c0_.is_active AS is_active_61,
  c0_.charged_cost AS charged_cost_62,
  c0_.manual_balance AS manual_balance_63,
  c0_.external_logo_path AS external_logo_path_64,
  c0_.vat_nature AS vat_nature_65,
  c0_.vat_chargeability AS vat_chargeability_66,
  c0_.saved_data AS saved_data_67,
  c0_.normative_reference AS normative_reference_68,
  c0_.doc_reference AS doc_reference_69,
  c0_.doc_reference_number AS doc_reference_number_70,
  c0_.doc_reference_date AS doc_reference_date_71,
  c0_.data_creazione AS data_creazione_72,
  c0_.data_ultima_modifica AS data_ultima_modifica_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,
  u1_.id AS id_79,
  u1_.erp_cod AS erp_cod_80,
  u1_.username AS username_81,
  u1_.password AS password_82,
  u1_.nome AS nome_83,
  u1_.sigla AS sigla_84,
  u1_.email AS email_85,
  u1_.lingua AS lingua_86,
  u1_.color AS color_87,
  u1_.initial_page AS initial_page_88,
  u1_.login_token AS login_token_89,
  u1_.google_authenticator_secret AS google_authenticator_secret_90,
  u1_.planner_priority AS planner_priority_91,
  u1_.is_cliente AS is_cliente_92,
  u1_.is_tester AS is_tester_93,
  u1_.is_sa AS is_sa_94,
  u1_.is_first_access AS is_first_access_95,
  u1_.is_google_authenticator_enable AS is_google_authenticator_enable_96,
  u1_.is2fa_email_enable AS is2fa_email_enable_97,
  u1_.is_active AS is_active_98,
  u1_.is_operator AS is_operator_99,
  u1_.is_standby AS is_standby_100,
  u1_.is_produced_product_recipient AS is_produced_product_recipient_101,
  u1_.is_production_batch_update AS is_production_batch_update_102,
  u1_.is_maintenance_recipient AS is_maintenance_recipient_103,
  u1_.is_maintenance_recipient_device AS is_maintenance_recipient_device_104,
  u1_.is_site_page_recipient AS is_site_page_recipient_105,
  u1_.is_accredia AS is_accredia_106,
  u1_.check_consistence AS check_consistence_107,
  u1_.planner_start_date AS planner_start_date_108,
  u1_.standby_start_date AS standby_start_date_109,
  u1_.standby_end_date AS standby_end_date_110,
  u1_.last_check_consistence AS last_check_consistence_111,
  u1_.last_access_date AS last_access_date_112,
  u1_.last_app_access_date AS last_app_access_date_113,
  u1_.data_creazione AS data_creazione_114,
  u1_.data_ultima_modifica AS data_ultima_modifica_115,
  c0_.id_chart_account AS id_chart_account_116,
  c0_.id_birth_municipality AS id_birth_municipality_117,
  c0_.id_citizenship_municipality AS id_citizenship_municipality_118,
  c0_.id_vat_type AS id_vat_type_119,
  c0_.id_logo AS id_logo_120,
  c0_.id_agency AS id_agency_121,
  c0_.id_iban_currency_causal_code AS id_iban_currency_causal_code_122,
  c0_.id_contact_source AS id_contact_source_123,
  c0_.id_contact_group AS id_contact_group_124,
  c0_.id_payment_method AS id_payment_method_125,
  c0_.id_termine_pagamento AS id_termine_pagamento_126,
  c0_.id_supplier_payment_method AS id_supplier_payment_method_127,
  c0_.id_supplier_payment_term AS id_supplier_payment_term_128,
  c0_.id_subscription AS id_subscription_129,
  c0_.id_reference AS id_reference_130,
  c0_.id_creatore AS id_creatore_131,
  c0_.id_aggiornatore AS id_aggiornatore_132,
  c0_.id_organizzazione AS id_organizzazione_133,
  c0_.id_provincia AS id_provincia_134,
  c0_.id_nazione AS id_nazione_135,
  u1_.id_avatar AS id_avatar_136,
  u1_.id_sign AS id_sign_137,
  u1_.id_contatto AS id_contatto_138,
  u1_.id_stage_model_category AS id_stage_model_category_139,
  u1_.id_creatore AS id_creatore_140,
  u1_.id_aggiornatore AS id_aggiornatore_141
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

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_owner_fiscal_code AS iban_owner_fiscal_code_32, c0_.iban_bic AS iban_bic_33, c0_.iban_currency_causal AS iban_currency_causal_34, c0_.gender_slug AS gender_slug_35, c0_.payment_supplier_note AS payment_supplier_note_36, c0_.payment_customer_note AS payment_customer_note_37, c0_.deploy_org_prefix AS deploy_org_prefix_38, c0_.customer_order AS customer_order_39, c0_.supplier_order AS supplier_order_40, c0_.margin AS margin_41, c0_.slug AS slug_42, c0_.loyalty_category_slug AS loyalty_category_slug_43, c0_.periodicity AS periodicity_44, c0_.is_cliente AS is_cliente_45, c0_.is_supplier AS is_supplier_46, c0_.is_teacher AS is_teacher_47, c0_.is_student AS is_student_48, c0_.is_temporary AS is_temporary_49, c0_.is_standby AS is_standby_50, c0_.is_ceased_activity AS is_ceased_activity_51, c0_.is_persona AS is_persona_52, c0_.is_player AS is_player_53, c0_.is_privacy_accepted AS is_privacy_accepted_54, c0_.is_charged_cost AS is_charged_cost_55, c0_.is_vat_excluded AS is_vat_excluded_56, c0_.is_qualified AS is_qualified_57, c0_.is_multi_payment_supplier AS is_multi_payment_supplier_58, c0_.is_multi_payment_customer AS is_multi_payment_customer_59, c0_.is_stamp_applied AS is_stamp_applied_60, c0_.is_active AS is_active_61, c0_.charged_cost AS charged_cost_62, c0_.manual_balance AS manual_balance_63, c0_.external_logo_path AS external_logo_path_64, c0_.vat_nature AS vat_nature_65, c0_.vat_chargeability AS vat_chargeability_66, c0_.saved_data AS saved_data_67, c0_.normative_reference AS normative_reference_68, c0_.doc_reference AS doc_reference_69, c0_.doc_reference_number AS doc_reference_number_70, c0_.doc_reference_date AS doc_reference_date_71, c0_.data_creazione AS data_creazione_72, c0_.data_ultima_modifica AS data_ultima_modifica_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, u1_.id AS id_79, u1_.erp_cod AS erp_cod_80, u1_.username AS username_81, u1_.password AS password_82, u1_.nome AS nome_83, u1_.sigla AS sigla_84, u1_.email AS email_85, u1_.lingua AS lingua_86, u1_.color AS color_87, u1_.initial_page AS initial_page_88, u1_.login_token AS login_token_89, u1_.google_authenticator_secret AS google_authenticator_secret_90, u1_.planner_priority AS planner_priority_91, u1_.is_cliente AS is_cliente_92, u1_.is_tester AS is_tester_93, u1_.is_sa AS is_sa_94, u1_.is_first_access AS is_first_access_95, u1_.is_google_authenticator_enable AS is_google_authenticator_enable_96, u1_.is2fa_email_enable AS is2fa_email_enable_97, u1_.is_active AS is_active_98, u1_.is_operator AS is_operator_99, u1_.is_standby AS is_standby_100, u1_.is_produced_product_recipient AS is_produced_product_recipient_101, u1_.is_production_batch_update AS is_production_batch_update_102, u1_.is_maintenance_recipient AS is_maintenance_recipient_103, u1_.is_maintenance_recipient_device AS is_maintenance_recipient_device_104, u1_.is_site_page_recipient AS is_site_page_recipient_105, u1_.is_accredia AS is_accredia_106, u1_.check_consistence AS check_consistence_107, u1_.planner_start_date AS planner_start_date_108, u1_.standby_start_date AS standby_start_date_109, u1_.standby_end_date AS standby_end_date_110, u1_.last_check_consistence AS last_check_consistence_111, u1_.last_access_date AS last_access_date_112, u1_.last_app_access_date AS last_app_access_date_113, u1_.data_creazione AS data_creazione_114, u1_.data_ultima_modifica AS data_ultima_modifica_115, c0_.id_chart_account AS id_chart_account_116, c0_.id_birth_municipality AS id_birth_municipality_117, c0_.id_citizenship_municipality AS id_citizenship_municipality_118, c0_.id_vat_type AS id_vat_type_119, c0_.id_logo AS id_logo_120, c0_.id_agency AS id_agency_121, c0_.id_iban_currency_causal_code AS id_iban_currency_causal_code_122, c0_.id_contact_source AS id_contact_source_123, c0_.id_contact_group AS id_contact_group_124, c0_.id_payment_method AS id_payment_method_125, c0_.id_termine_pagamento AS id_termine_pagamento_126, c0_.id_supplier_payment_method AS id_supplier_payment_method_127, c0_.id_supplier_payment_term AS id_supplier_payment_term_128, c0_.id_subscription AS id_subscription_129, c0_.id_reference AS id_reference_130, c0_.id_creatore AS id_creatore_131, c0_.id_aggiornatore AS id_aggiornatore_132, c0_.id_organizzazione AS id_organizzazione_133, c0_.id_provincia AS id_provincia_134, c0_.id_nazione AS id_nazione_135, u1_.id_avatar AS id_avatar_136, u1_.id_sign AS id_sign_137, u1_.id_contatto AS id_contatto_138, u1_.id_stage_model_category AS id_stage_model_category_139, u1_.id_creatore AS id_creatore_140, u1_.id_aggiornatore AS id_aggiornatore_141 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;