Symfony Profiler

SELECT
  t0.id_cart AS id_cart_1,
  t0.delivery_option AS delivery_option_2,
  t0.id_currency AS id_currency_3,
  t0.secure_key AS secure_key_4,
  t0.recyclable AS recyclable_5,
  t0.date_upd AS date_upd_6,
  t0.date_add AS date_add_7,
  t0.is_virtual AS is_virtual_8,
  t0.is_sync AS is_sync_9,
  t0.is_mobile AS is_mobile_10,
  t0.dropshipping AS dropshipping_11,
  t0.total_products AS total_products_12,
  t0.total_envio AS total_envio_13,
  t0.logistic_weight AS logistic_weight_14,
  t0.ref_order_supplier AS ref_order_supplier_15,
  t0.is_system AS is_system_16,
  t0.selling_channel AS selling_channel_17,
  t0.additional_parameters AS additional_parameters_18,
  t0.date_amazon AS date_amazon_19,
  t0.fba AS fba_20,
  t0.max_delivery_datetime AS max_delivery_datetime_21,
  t0.max_expedition_datetime AS max_expedition_datetime_22,
  t0.shipment_choices AS shipment_choices_23,
  t0.ship_from_address_company_name AS ship_from_address_company_name_24,
  t25.id_order AS id_order_26,
  t25.reference AS reference_27,
  t25.id_carrier AS id_carrier_28,
  t25.id_currency AS id_currency_29,
  t25.conversion_rate AS conversion_rate_30,
  t25.module AS module_31,
  t25.dropshipping AS dropshipping_32,
  t25.total_discounts AS total_discounts_33,
  t25.total_discounts_tax_incl AS total_discounts_tax_incl_34,
  t25.total_discounts_tax_excl AS total_discounts_tax_excl_35,
  t25.total_paid AS total_paid_36,
  t25.total_paid_tax_incl AS total_paid_tax_incl_37,
  t25.total_paid_tax_excl AS total_paid_tax_excl_38,
  t25.total_paid_real AS total_paid_real_39,
  t25.total_products AS total_products_40,
  t25.total_products_wt AS total_products_wt_41,
  t25.total_shipping AS total_shipping_42,
  t25.total_shipping_tax_incl AS total_shipping_tax_incl_43,
  t25.total_shipping_tax_excl AS total_shipping_tax_excl_44,
  t25.carrier_tax_rate AS carrier_tax_rate_45,
  t25.total_wrapping AS total_wrapping_46,
  t25.total_wrapping_tax_incl AS total_wrapping_tax_incl_47,
  t25.total_wrapping_tax_excl AS total_wrapping_tax_excl_48,
  t25.invoice_date AS invoice_date_49,
  t25.delivery_date AS delivery_date_50,
  t25.valid AS valid_51,
  t25.validate_transfer AS validate_transfer_52,
  t25.ref_order_supplier AS ref_order_supplier_53,
  t25.date_add AS date_add_54,
  t25.date_upd AS date_upd_55,
  t25.purse AS purse_56,
  t25.dropshipping_qty AS dropshipping_qty_57,
  t25.payment_method_cost AS payment_method_cost_58,
  t25.dropshipping_cost AS dropshipping_cost_59,
  t25.re AS re_60,
  t25.transaction_id AS transaction_id_61,
  t25.refund AS refund_62,
  t25.full_refund AS full_refund_63,
  t25.intracomunitario AS intracomunitario_64,
  t25.is_tracking AS is_tracking_65,
  t25.state_dropshipping AS state_dropshipping_66,
  t25.vol_weight AS vol_weight_67,
  t25.id_carrier_master AS id_carrier_master_68,
  t25.quantity_stock_supplier AS quantity_stock_supplier_69,
  t25.quantity_stock_supplier_3_5 AS quantity_stock_supplier_3_5_70,
  t25.quantity_future_stock AS quantity_future_stock_71,
  t25.id_pack AS id_pack_72,
  t25.delivered_date AS delivered_date_73,
  t25.api AS api_74,
  t25.is_system AS is_system_75,
  t25.selling_channel AS selling_channel_76,
  t25.date_amazon AS date_amazon_77,
  t25.additional_parameters AS additional_parameters_78,
  t25.estimated_shipping_date AS estimated_shipping_date_79,
  t25.scheduled_confirmation_date AS scheduled_confirmation_date_80,
  t25.a4b_uuid AS a4b_uuid_81,
  t25.dispute AS dispute_82,
  t25.paypal_payer_id AS paypal_payer_id_83,
  t25.paypal_payer_email AS paypal_payer_email_84,
  t25.fba AS fba_85,
  t25.max_expedition_datetime AS max_expedition_datetime_86,
  t25.max_delivery_datetime AS max_delivery_datetime_87,
  t25.logistic_weight AS logistic_weight_88,
  t25.extra_discount_percentage AS extra_discount_percentage_89,
  t25.ship_from_address_company_name AS ship_from_address_company_name_90,
  t25.id_cart AS id_cart_91,
  t25.id_customer AS id_customer_92,
  t25.id_voucher AS id_voucher_93,
  t25.id_customer_order_fraud_rule AS id_customer_order_fraud_rule_94,
  t25.id_address_delivery AS id_address_delivery_95,
  t25.id_order_state AS id_order_state_96,
  t25.id_lang AS id_lang_97,
  t25.warehouse_id AS warehouse_id_98,
  t25.payment_method AS payment_method_99,
  t0.id_carrier AS id_carrier_100,
  t0.id_address_delivery AS id_address_delivery_101,
  t0.id_customer AS id_customer_102,
  t0.code_discount_id AS code_discount_id_103,
  t0.cart_parent_id AS cart_parent_id_104,
  t0.payment_method AS payment_method_105
FROM
  ps_cart t0
  LEFT JOIN ps_orders t25 ON t25.id_cart = t0.id_cart
WHERE
  t0.id_cart = ?

SELECT t0.id_cart AS id_cart_1, t0.delivery_option AS delivery_option_2, t0.id_currency AS id_currency_3, t0.secure_key AS secure_key_4, t0.recyclable AS recyclable_5, t0.date_upd AS date_upd_6, t0.date_add AS date_add_7, t0.is_virtual AS is_virtual_8, t0.is_sync AS is_sync_9, t0.is_mobile AS is_mobile_10, t0.dropshipping AS dropshipping_11, t0.total_products AS total_products_12, t0.total_envio AS total_envio_13, t0.logistic_weight AS logistic_weight_14, t0.ref_order_supplier AS ref_order_supplier_15, t0.is_system AS is_system_16, t0.selling_channel AS selling_channel_17, t0.additional_parameters AS additional_parameters_18, t0.date_amazon AS date_amazon_19, t0.fba AS fba_20, t0.max_delivery_datetime AS max_delivery_datetime_21, t0.max_expedition_datetime AS max_expedition_datetime_22, t0.shipment_choices AS shipment_choices_23, t0.ship_from_address_company_name AS ship_from_address_company_name_24, t25.id_order AS id_order_26, t25.reference AS reference_27, t25.id_carrier AS id_carrier_28, t25.id_currency AS id_currency_29, t25.conversion_rate AS conversion_rate_30, t25.module AS module_31, t25.dropshipping AS dropshipping_32, t25.total_discounts AS total_discounts_33, t25.total_discounts_tax_incl AS total_discounts_tax_incl_34, t25.total_discounts_tax_excl AS total_discounts_tax_excl_35, t25.total_paid AS total_paid_36, t25.total_paid_tax_incl AS total_paid_tax_incl_37, t25.total_paid_tax_excl AS total_paid_tax_excl_38, t25.total_paid_real AS total_paid_real_39, t25.total_products AS total_products_40, t25.total_products_wt AS total_products_wt_41, t25.total_shipping AS total_shipping_42, t25.total_shipping_tax_incl AS total_shipping_tax_incl_43, t25.total_shipping_tax_excl AS total_shipping_tax_excl_44, t25.carrier_tax_rate AS carrier_tax_rate_45, t25.total_wrapping AS total_wrapping_46, t25.total_wrapping_tax_incl AS total_wrapping_tax_incl_47, t25.total_wrapping_tax_excl AS total_wrapping_tax_excl_48, t25.invoice_date AS invoice_date_49, t25.delivery_date AS delivery_date_50, t25.valid AS valid_51, t25.validate_transfer AS validate_transfer_52, t25.ref_order_supplier AS ref_order_supplier_53, t25.date_add AS date_add_54, t25.date_upd AS date_upd_55, t25.purse AS purse_56, t25.dropshipping_qty AS dropshipping_qty_57, t25.payment_method_cost AS payment_method_cost_58, t25.dropshipping_cost AS dropshipping_cost_59, t25.re AS re_60, t25.transaction_id AS transaction_id_61, t25.refund AS refund_62, t25.full_refund AS full_refund_63, t25.intracomunitario AS intracomunitario_64, t25.is_tracking AS is_tracking_65, t25.state_dropshipping AS state_dropshipping_66, t25.vol_weight AS vol_weight_67, t25.id_carrier_master AS id_carrier_master_68, t25.quantity_stock_supplier AS quantity_stock_supplier_69, t25.quantity_stock_supplier_3_5 AS quantity_stock_supplier_3_5_70, t25.quantity_future_stock AS quantity_future_stock_71, t25.id_pack AS id_pack_72, t25.delivered_date AS delivered_date_73, t25.api AS api_74, t25.is_system AS is_system_75, t25.selling_channel AS selling_channel_76, t25.date_amazon AS date_amazon_77, t25.additional_parameters AS additional_parameters_78, t25.estimated_shipping_date AS estimated_shipping_date_79, t25.scheduled_confirmation_date AS scheduled_confirmation_date_80, t25.a4b_uuid AS a4b_uuid_81, t25.dispute AS dispute_82, t25.paypal_payer_id AS paypal_payer_id_83, t25.paypal_payer_email AS paypal_payer_email_84, t25.fba AS fba_85, t25.max_expedition_datetime AS max_expedition_datetime_86, t25.max_delivery_datetime AS max_delivery_datetime_87, t25.logistic_weight AS logistic_weight_88, t25.extra_discount_percentage AS extra_discount_percentage_89, t25.ship_from_address_company_name AS ship_from_address_company_name_90, t25.id_cart AS id_cart_91, t25.id_customer AS id_customer_92, t25.id_voucher AS id_voucher_93, t25.id_customer_order_fraud_rule AS id_customer_order_fraud_rule_94, t25.id_address_delivery AS id_address_delivery_95, t25.id_order_state AS id_order_state_96, t25.id_lang AS id_lang_97, t25.warehouse_id AS warehouse_id_98, t25.payment_method AS payment_method_99, t0.id_carrier AS id_carrier_100, t0.id_address_delivery AS id_address_delivery_101, t0.id_customer AS id_customer_102, t0.code_discount_id AS code_discount_id_103, t0.cart_parent_id AS cart_parent_id_104, t0.payment_method AS payment_method_105 FROM ps_cart t0 LEFT JOIN ps_orders t25 ON t25.id_cart = t0.id_cart WHERE t0.id_cart = 3876883;

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.purse AS purse_6,
  t0.last_passwd_gen AS last_passwd_gen_7,
  t0.multifactor_auth_enabled AS multifactor_auth_enabled_8,
  t0.order_confirmation_delay AS order_confirmation_delay_9,
  t0.active AS active_10,
  t0.dropshipping AS dropshipping_11,
  t0.date_add AS date_add_12,
  t0.date_upd AS date_upd_13,
  t0.comment AS comment_14,
  t0.date_basic_free AS date_basic_free_15,
  t0.paypal_billing_agreement AS paypal_billing_agreement_16,
  t0.stripe_reference AS stripe_reference_17,
  t0.date_pack AS date_pack_18,
  t0.csv_lang AS csv_lang_19,
  t0.dropshipping_name AS dropshipping_name_20,
  t0.email_paypal AS email_paypal_21,
  t0.moroso AS moroso_22,
  t0.fraudster AS fraudster_23,
  t0.payer_id_paypal AS payer_id_paypal_24,
  t0.excluir_vies AS excluir_vies_25,
  t0.date_excluir_iva AS date_excluir_iva_26,
  t0.force_password_update AS force_password_update_27,
  t0.read_policy_cookies AS read_policy_cookies_28,
  t0.pack_by_purse AS pack_by_purse_29,
  t0.partial_creation AS partial_creation_30,
  t0.purchase_not_allowed AS purchase_not_allowed_31,
  t0.pack_bankwire_payment AS pack_bankwire_payment_32,
  t0.adyen_payment_id AS adyen_payment_id_33,
  t0.google_account_id AS google_account_id_34,
  t0.linkedin_account_id AS linkedin_account_id_35,
  t0.hubspot_company_id AS hubspot_company_id_36,
  t0.hubspot_contact_id AS hubspot_contact_id_37,
  t0.last_access AS last_access_38,
  t0.stripe_default_payment_method_reference AS stripe_default_payment_method_reference_39,
  t0.id_group AS id_group_40,
  t0.id_lang AS id_lang_41,
  t0.id_pack AS id_pack_42,
  t43.id AS id_44,
  t43.state_name AS state_name_45,
  t43.company AS company_46,
  t43.name AS name_47,
  t43.email AS email_48,
  t43.surnames AS surnames_49,
  t43.address1 AS address1_50,
  t43.address2 AS address2_51,
  t43.postcode AS postcode_52,
  t43.city AS city_53,
  t43.phone AS phone_54,
  t43.phone_mobile AS phone_mobile_55,
  t43.vat_number AS vat_number_56,
  t43.date_add AS date_add_57,
  t43.date_upd AS date_upd_58,
  t43.vise AS vise_59,
  t43.re AS re_60,
  t43.comercial_name AS comercial_name_61,
  t43.type_customer AS type_customer_62,
  t43.contact_name AS contact_name_63,
  t43.url AS url_64,
  t43.phone_prefix AS phone_prefix_65,
  t43.phone_mobile_prefix AS phone_mobile_prefix_66,
  t43.company_name AS company_name_67,
  t43.iso_vat_number AS iso_vat_number_68,
  t43.company_verified AS company_verified_69,
  t43.eori AS eori_70,
  t43.voec AS voec_71,
  t43.country_id AS country_id_72,
  t43.state_id AS state_id_73,
  t43.customer_id AS customer_id_74,
  t43.old_address_id AS old_address_id_75
FROM
  ps_customer t0
  LEFT JOIN customer_invoice_address t43 ON t43.customer_id = t0.id_customer
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.purse AS purse_6, t0.last_passwd_gen AS last_passwd_gen_7, t0.multifactor_auth_enabled AS multifactor_auth_enabled_8, t0.order_confirmation_delay AS order_confirmation_delay_9, t0.active AS active_10, t0.dropshipping AS dropshipping_11, t0.date_add AS date_add_12, t0.date_upd AS date_upd_13, t0.comment AS comment_14, t0.date_basic_free AS date_basic_free_15, t0.paypal_billing_agreement AS paypal_billing_agreement_16, t0.stripe_reference AS stripe_reference_17, t0.date_pack AS date_pack_18, t0.csv_lang AS csv_lang_19, t0.dropshipping_name AS dropshipping_name_20, t0.email_paypal AS email_paypal_21, t0.moroso AS moroso_22, t0.fraudster AS fraudster_23, t0.payer_id_paypal AS payer_id_paypal_24, t0.excluir_vies AS excluir_vies_25, t0.date_excluir_iva AS date_excluir_iva_26, t0.force_password_update AS force_password_update_27, t0.read_policy_cookies AS read_policy_cookies_28, t0.pack_by_purse AS pack_by_purse_29, t0.partial_creation AS partial_creation_30, t0.purchase_not_allowed AS purchase_not_allowed_31, t0.pack_bankwire_payment AS pack_bankwire_payment_32, t0.adyen_payment_id AS adyen_payment_id_33, t0.google_account_id AS google_account_id_34, t0.linkedin_account_id AS linkedin_account_id_35, t0.hubspot_company_id AS hubspot_company_id_36, t0.hubspot_contact_id AS hubspot_contact_id_37, t0.last_access AS last_access_38, t0.stripe_default_payment_method_reference AS stripe_default_payment_method_reference_39, t0.id_group AS id_group_40, t0.id_lang AS id_lang_41, t0.id_pack AS id_pack_42, t43.id AS id_44, t43.state_name AS state_name_45, t43.company AS company_46, t43.name AS name_47, t43.email AS email_48, t43.surnames AS surnames_49, t43.address1 AS address1_50, t43.address2 AS address2_51, t43.postcode AS postcode_52, t43.city AS city_53, t43.phone AS phone_54, t43.phone_mobile AS phone_mobile_55, t43.vat_number AS vat_number_56, t43.date_add AS date_add_57, t43.date_upd AS date_upd_58, t43.vise AS vise_59, t43.re AS re_60, t43.comercial_name AS comercial_name_61, t43.type_customer AS type_customer_62, t43.contact_name AS contact_name_63, t43.url AS url_64, t43.phone_prefix AS phone_prefix_65, t43.phone_mobile_prefix AS phone_mobile_prefix_66, t43.company_name AS company_name_67, t43.iso_vat_number AS iso_vat_number_68, t43.company_verified AS company_verified_69, t43.eori AS eori_70, t43.voec AS voec_71, t43.country_id AS country_id_72, t43.state_id AS state_id_73, t43.customer_id AS customer_id_74, t43.old_address_id AS old_address_id_75 FROM ps_customer t0 LEFT JOIN customer_invoice_address t43 ON t43.customer_id = t0.id_customer 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;