Symfony Profiler

SELECT
  t0.id_customer AS id_customer_1,
  t0.name AS name_2,
  t0.surnames AS surnames_3,
  t0.email AS email_4,
  t0.passwd AS passwd_5,
  t0.id_pack AS id_pack_6,
  t0.purse AS purse_7,
  t0.last_passwd_gen AS last_passwd_gen_8,
  t0.multifactor_auth_enabled AS multifactor_auth_enabled_9,
  t0.order_confirmation_delay AS order_confirmation_delay_10,
  t0.active AS active_11,
  t0.dropshipping AS dropshipping_12,
  t0.date_add AS date_add_13,
  t0.date_upd AS date_upd_14,
  t0.comment AS comment_15,
  t0.date_csv AS date_csv_16,
  t0.date_basic_free AS date_basic_free_17,
  t0.paypal_billing_agreement AS paypal_billing_agreement_18,
  t0.stripe_reference AS stripe_reference_19,
  t0.date_pack AS date_pack_20,
  t0.csv_lang AS csv_lang_21,
  t0.dropshipping_name AS dropshipping_name_22,
  t0.email_paypal AS email_paypal_23,
  t0.moroso AS moroso_24,
  t0.payer_id_paypal AS payer_id_paypal_25,
  t0.order_csv AS order_csv_26,
  t0.excluir_vies AS excluir_vies_27,
  t0.date_excluir_iva AS date_excluir_iva_28,
  t0.force_password_update AS force_password_update_29,
  t0.read_policy_cookies AS read_policy_cookies_30,
  t0.pack_by_purse AS pack_by_purse_31,
  t0.partial_creation AS partial_creation_32,
  t0.purchase_not_allowed AS purchase_not_allowed_33,
  t0.pack_bankwire_payment AS pack_bankwire_payment_34,
  t0.adyen_payment_id AS adyen_payment_id_35,
  t0.the_power_mba_user_id AS the_power_mba_user_id_36,
  t0.google_account_id AS google_account_id_37,
  t0.linkedin_account_id AS linkedin_account_id_38,
  t0.hubspot_company_id AS hubspot_company_id_39,
  t0.hubspot_contact_id AS hubspot_contact_id_40,
  t0.last_access AS last_access_41,
  t0.stripe_default_payment_method_reference AS stripe_default_payment_method_reference_42,
  t0.id_group AS id_group_43,
  t0.id_lang AS id_lang_44
FROM
  ps_customer t0
WHERE
  t0.id_customer = ?

SELECT t0.id_customer AS id_customer_1, t0.name AS name_2, t0.surnames AS surnames_3, t0.email AS email_4, t0.passwd AS passwd_5, t0.id_pack AS id_pack_6, t0.purse AS purse_7, t0.last_passwd_gen AS last_passwd_gen_8, t0.multifactor_auth_enabled AS multifactor_auth_enabled_9, t0.order_confirmation_delay AS order_confirmation_delay_10, t0.active AS active_11, t0.dropshipping AS dropshipping_12, t0.date_add AS date_add_13, t0.date_upd AS date_upd_14, t0.comment AS comment_15, t0.date_csv AS date_csv_16, t0.date_basic_free AS date_basic_free_17, t0.paypal_billing_agreement AS paypal_billing_agreement_18, t0.stripe_reference AS stripe_reference_19, t0.date_pack AS date_pack_20, t0.csv_lang AS csv_lang_21, t0.dropshipping_name AS dropshipping_name_22, t0.email_paypal AS email_paypal_23, t0.moroso AS moroso_24, t0.payer_id_paypal AS payer_id_paypal_25, t0.order_csv AS order_csv_26, t0.excluir_vies AS excluir_vies_27, t0.date_excluir_iva AS date_excluir_iva_28, t0.force_password_update AS force_password_update_29, t0.read_policy_cookies AS read_policy_cookies_30, t0.pack_by_purse AS pack_by_purse_31, t0.partial_creation AS partial_creation_32, t0.purchase_not_allowed AS purchase_not_allowed_33, t0.pack_bankwire_payment AS pack_bankwire_payment_34, t0.adyen_payment_id AS adyen_payment_id_35, t0.the_power_mba_user_id AS the_power_mba_user_id_36, t0.google_account_id AS google_account_id_37, t0.linkedin_account_id AS linkedin_account_id_38, t0.hubspot_company_id AS hubspot_company_id_39, t0.hubspot_contact_id AS hubspot_contact_id_40, t0.last_access AS last_access_41, t0.stripe_default_payment_method_reference AS stripe_default_payment_method_reference_42, t0.id_group AS id_group_43, t0.id_lang AS id_lang_44 FROM ps_customer t0 WHERE t0.id_customer = 500006;

SELECT
  t0.id_role AS id_role_1,
  t0.name AS name_2,
  t0.employee AS employee_3
FROM
  ps_role t0
  INNER JOIN customer_role ON t0.id_role = customer_role.id_role
WHERE
  customer_role.id_customer = ?

SELECT t0.id_role AS id_role_1, t0.name AS name_2, t0.employee AS employee_3 FROM ps_role t0 INNER JOIN customer_role ON t0.id_role = customer_role.id_role WHERE customer_role.id_customer = 500006;

SELECT
  t0.id_lang AS id_lang_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso_code AS iso_code_4,
  t0.language_code AS language_code_5,
  t0.date_format_lite AS date_format_lite_6,
  t0.date_format_full AS date_format_full_7,
  t0.dictionary AS dictionary_8,
  t0.currency_format AS currency_format_9,
  t0.iso_code_real AS iso_code_real_10,
  t0.name_english AS name_english_11
FROM
  ps_lang t0
WHERE
  t0.iso_code = ?
LIMIT
  1

SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = 'es' LIMIT 1;

SELECT
  t0.id_lang AS id_lang_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso_code AS iso_code_4,
  t0.language_code AS language_code_5,
  t0.date_format_lite AS date_format_lite_6,
  t0.date_format_full AS date_format_full_7,
  t0.dictionary AS dictionary_8,
  t0.currency_format AS currency_format_9,
  t0.iso_code_real AS iso_code_real_10,
  t0.name_english AS name_english_11
FROM
  ps_lang t0
WHERE
  t0.iso_code = ?
LIMIT
  1

SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = 'es' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.`read` AS read_1,
  c0_.entity_id AS entity_id_2,
  n1_.id AS id_3,
  n1_.expiration_date AS expiration_date_4,
  n1_.creation_date AS creation_date_5,
  n1_.notification_date AS notification_date_6,
  n1_.deactivation_date AS deactivation_date_7,
  n1_.active AS active_8,
  n2_.title AS title_9,
  n2_.description AS description_10,
  n2_.link AS link_11,
  n2_.link_text AS link_text_12,
  c0_.customer_id AS customer_id_13,
  c0_.notification_id AS notification_id_14,
  n1_.creation_employee_id AS creation_employee_id_15,
  n1_.notification_employee_id AS notification_employee_id_16,
  n1_.deactivation_employee_id AS deactivation_employee_id_17,
  n1_.type_id AS type_id_18,
  n1_.notification_product_id AS notification_product_id_19,
  n1_.section_id AS section_id_20,
  n2_.notification_id AS notification_id_21,
  n2_.language_id AS language_id_22
FROM
  customer_notification c0_
  INNER JOIN notification n1_ ON c0_.notification_id = n1_.id
  INNER JOIN notification_lang n2_ ON n1_.id = n2_.notification_id
WHERE
  (
    c0_.customer_id = ?
    AND n1_.active = ?
  )
  AND n2_.language_id IN (?, ?)
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.`read` AS read_1, c0_.entity_id AS entity_id_2, n1_.id AS id_3, n1_.expiration_date AS expiration_date_4, n1_.creation_date AS creation_date_5, n1_.notification_date AS notification_date_6, n1_.deactivation_date AS deactivation_date_7, n1_.active AS active_8, n2_.title AS title_9, n2_.description AS description_10, n2_.link AS link_11, n2_.link_text AS link_text_12, c0_.customer_id AS customer_id_13, c0_.notification_id AS notification_id_14, n1_.creation_employee_id AS creation_employee_id_15, n1_.notification_employee_id AS notification_employee_id_16, n1_.deactivation_employee_id AS deactivation_employee_id_17, n1_.type_id AS type_id_18, n1_.notification_product_id AS notification_product_id_19, n1_.section_id AS section_id_20, n2_.notification_id AS notification_id_21, n2_.language_id AS language_id_22 FROM customer_notification c0_ INNER JOIN notification n1_ ON c0_.notification_id = n1_.id INNER JOIN notification_lang n2_ ON n1_.id = n2_.notification_id WHERE (c0_.customer_id = 500006 AND n1_.active = 1) AND n2_.language_id IN (4, 1) ORDER BY c0_.id DESC;