Symfony Profiler

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

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

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;