Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.mobile AS mobile_7,
  t0.phone AS phone_8,
  t0.welcome_email AS welcome_email_9,
  t0.available_point AS available_point_10,
  t0.potential_point AS potential_point_11,
  t0.locale AS locale_12,
  t0.job AS job_13,
  t0.company AS company_14,
  t0.company_siret AS company_siret_15,
  t0.company_legal_status AS company_legal_status_16,
  t0.user_token AS user_token_17,
  t0.user_token_validity AS user_token_validity_18,
  t0.user_token_attempts AS user_token_attempts_19,
  t0.civility AS civility_20,
  t0.address1 AS address1_21,
  t0.address2 AS address2_22,
  t0.postcode AS postcode_23,
  t0.city AS city_24,
  t0.can_order AS can_order_25,
  t0.deleted_at AS deleted_at_26,
  t0.birth_date AS birth_date_27,
  t0.birth_place AS birth_place_28,
  t0.internal_code AS internal_code_29,
  t0.cgu_at AS cgu_at_30,
  t0.register_at AS register_at_31,
  t0.imported_at AS imported_at_32,
  t0.can_be_contacted AS can_be_contacted_33,
  t0.capacity AS capacity_34,
  t0.address3 AS address3_35,
  t0.optin_mail AS optin_mail_36,
  t0.optin_sms AS optin_sms_37,
  t0.optin_postal AS optin_postal_38,
  t0.optin_postal_address AS optin_postal_address_39,
  t0.source AS source_40,
  t0.level AS level_41,
  t0.level0_updated_at AS level0_updated_at_42,
  t0.level1_updated_at AS level1_updated_at_43,
  t0.level2_updated_at AS level2_updated_at_44,
  t0.level3_updated_at AS level3_updated_at_45,
  t0.level_update_seen_at AS level_update_seen_at_46,
  t0.is_email_ok AS is_email_ok_47,
  t0.last_email_check AS last_email_check_48,
  t0.api_token AS api_token_49,
  t0.sap_account AS sap_account_50,
  t0.sap_distributor AS sap_distributor_51,
  t0.distributor AS distributor_52,
  t0.distributor2 AS distributor2_53,
  t0.aggreement AS aggreement_54,
  t0.unsubscribed_at AS unsubscribed_at_55,
  t0.chauffage AS chauffage_56,
  t0.username AS username_57,
  t0.username_canonical AS username_canonical_58,
  t0.email_canonical AS email_canonical_59,
  t0.salt AS salt_60,
  t0.last_login AS last_login_61,
  t0.confirmation_token AS confirmation_token_62,
  t0.password_requested_at AS password_requested_at_63,
  t0.credential_expired AS credential_expired_64,
  t0.credential_expired_at AS credential_expired_at_65,
  t0.donnees_personnelles AS donnees_personnelles_66,
  t0.archived_at AS archived_at_67,
  t0.newsletter AS newsletter_68,
  t0.extension1 AS extension1_69,
  t0.extension2 AS extension2_70,
  t0.wdg AS wdg_71,
  t0.glady_uuid AS glady_uuid_72,
  t0.transactional_email AS transactional_email_73,
  t0.status AS status_74,
  t0.calculated_points AS calculated_points_75,
  t0.avatar AS avatar_76,
  t0.logo AS logo_77,
  t0.fonction AS fonction_78,
  t0.registration_document AS registration_document_79,
  t0.old_status AS old_status_80,
  t0.disabled_at AS disabled_at_81,
  t0.archive_reason AS archive_reason_82,
  t0.unsubscribe_reason AS unsubscribe_reason_83,
  t0.failed_attempts AS failed_attempts_84,
  t0.last_failed_attempt AS last_failed_attempt_85,
  t0.password_updated_at AS password_updated_at_86,
  t0.last_activity AS last_activity_87,
  t0.account_id AS account_id_88,
  t0.unique_slug_constraint AS unique_slug_constraint_89,
  t0.azure_id AS azure_id_90,
  t0.email_unsubscribe_reason AS email_unsubscribe_reason_91,
  t0.email_unsubscribed_at AS email_unsubscribed_at_92,
  t0.created_at AS created_at_93,
  t0.updated_at AS updated_at_94,
  t0.country_id AS country_id_95,
  t0.main_account_user_id AS main_account_user_id_96,
  t0.godfather_id AS godfather_id_97,
  t0.regate_id AS regate_id_98,
  t0.commercial_id AS commercial_id_99,
  t0.heating_commercial_id AS heating_commercial_id_100,
  t0.agency_id AS agency_id_101,
  t102.id AS id_103,
  t102.code AS code_104,
  t102.name AS name_105,
  t102.region AS region_106,
  t102.manager_last_name AS manager_last_name_107,
  t102.manager_first_name AS manager_first_name_108,
  t102.address1 AS address1_109,
  t102.address2 AS address2_110,
  t102.post_code AS post_code_111,
  t102.city AS city_112,
  t102.phone AS phone_113,
  t0.programme_id AS programme_id_114,
  t0.sale_order_validation_id AS sale_order_validation_id_115,
  t0.billing_point_id AS billing_point_id_116,
  t0.request_registration_id AS request_registration_id_117,
  t0.subscription_id AS subscription_id_118,
  t0.point_of_sale_id AS point_of_sale_id_119,
  t120.id AS id_121,
  t120.code AS code_122,
  t120.name AS name_123,
  t120.city AS city_124,
  t120.enabled AS enabled_125,
  t120.created_by_id AS created_by_id_126,
  t120.address_id AS address_id_127,
  t0.point_conversion_rate_id AS point_conversion_rate_id_128,
  t0.responsable_regate_id AS responsable_regate_id_129,
  t0.coverage_area_id AS coverage_area_id_130,
  t0.activated_by_id AS activated_by_id_131
FROM
  user t0
  LEFT JOIN agence t102 ON t0.agency_id = t102.id
  LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.phone AS phone_8, t0.welcome_email AS welcome_email_9, t0.available_point AS available_point_10, t0.potential_point AS potential_point_11, t0.locale AS locale_12, t0.job AS job_13, t0.company AS company_14, t0.company_siret AS company_siret_15, t0.company_legal_status AS company_legal_status_16, t0.user_token AS user_token_17, t0.user_token_validity AS user_token_validity_18, t0.user_token_attempts AS user_token_attempts_19, t0.civility AS civility_20, t0.address1 AS address1_21, t0.address2 AS address2_22, t0.postcode AS postcode_23, t0.city AS city_24, t0.can_order AS can_order_25, t0.deleted_at AS deleted_at_26, t0.birth_date AS birth_date_27, t0.birth_place AS birth_place_28, t0.internal_code AS internal_code_29, t0.cgu_at AS cgu_at_30, t0.register_at AS register_at_31, t0.imported_at AS imported_at_32, t0.can_be_contacted AS can_be_contacted_33, t0.capacity AS capacity_34, t0.address3 AS address3_35, t0.optin_mail AS optin_mail_36, t0.optin_sms AS optin_sms_37, t0.optin_postal AS optin_postal_38, t0.optin_postal_address AS optin_postal_address_39, t0.source AS source_40, t0.level AS level_41, t0.level0_updated_at AS level0_updated_at_42, t0.level1_updated_at AS level1_updated_at_43, t0.level2_updated_at AS level2_updated_at_44, t0.level3_updated_at AS level3_updated_at_45, t0.level_update_seen_at AS level_update_seen_at_46, t0.is_email_ok AS is_email_ok_47, t0.last_email_check AS last_email_check_48, t0.api_token AS api_token_49, t0.sap_account AS sap_account_50, t0.sap_distributor AS sap_distributor_51, t0.distributor AS distributor_52, t0.distributor2 AS distributor2_53, t0.aggreement AS aggreement_54, t0.unsubscribed_at AS unsubscribed_at_55, t0.chauffage AS chauffage_56, t0.username AS username_57, t0.username_canonical AS username_canonical_58, t0.email_canonical AS email_canonical_59, t0.salt AS salt_60, t0.last_login AS last_login_61, t0.confirmation_token AS confirmation_token_62, t0.password_requested_at AS password_requested_at_63, t0.credential_expired AS credential_expired_64, t0.credential_expired_at AS credential_expired_at_65, t0.donnees_personnelles AS donnees_personnelles_66, t0.archived_at AS archived_at_67, t0.newsletter AS newsletter_68, t0.extension1 AS extension1_69, t0.extension2 AS extension2_70, t0.wdg AS wdg_71, t0.glady_uuid AS glady_uuid_72, t0.transactional_email AS transactional_email_73, t0.status AS status_74, t0.calculated_points AS calculated_points_75, t0.avatar AS avatar_76, t0.logo AS logo_77, t0.fonction AS fonction_78, t0.registration_document AS registration_document_79, t0.old_status AS old_status_80, t0.disabled_at AS disabled_at_81, t0.archive_reason AS archive_reason_82, t0.unsubscribe_reason AS unsubscribe_reason_83, t0.failed_attempts AS failed_attempts_84, t0.last_failed_attempt AS last_failed_attempt_85, t0.password_updated_at AS password_updated_at_86, t0.last_activity AS last_activity_87, t0.account_id AS account_id_88, t0.unique_slug_constraint AS unique_slug_constraint_89, t0.azure_id AS azure_id_90, t0.email_unsubscribe_reason AS email_unsubscribe_reason_91, t0.email_unsubscribed_at AS email_unsubscribed_at_92, t0.created_at AS created_at_93, t0.updated_at AS updated_at_94, t0.country_id AS country_id_95, t0.main_account_user_id AS main_account_user_id_96, t0.godfather_id AS godfather_id_97, t0.regate_id AS regate_id_98, t0.commercial_id AS commercial_id_99, t0.heating_commercial_id AS heating_commercial_id_100, t0.agency_id AS agency_id_101, t102.id AS id_103, t102.code AS code_104, t102.name AS name_105, t102.region AS region_106, t102.manager_last_name AS manager_last_name_107, t102.manager_first_name AS manager_first_name_108, t102.address1 AS address1_109, t102.address2 AS address2_110, t102.post_code AS post_code_111, t102.city AS city_112, t102.phone AS phone_113, t0.programme_id AS programme_id_114, t0.sale_order_validation_id AS sale_order_validation_id_115, t0.billing_point_id AS billing_point_id_116, t0.request_registration_id AS request_registration_id_117, t0.subscription_id AS subscription_id_118, t0.point_of_sale_id AS point_of_sale_id_119, t120.id AS id_121, t120.code AS code_122, t120.name AS name_123, t120.city AS city_124, t120.enabled AS enabled_125, t120.created_by_id AS created_by_id_126, t120.address_id AS address_id_127, t0.point_conversion_rate_id AS point_conversion_rate_id_128, t0.responsable_regate_id AS responsable_regate_id_129, t0.coverage_area_id AS coverage_area_id_130, t0.activated_by_id AS activated_by_id_131 FROM user t0 LEFT JOIN agence t102 ON t0.agency_id = t102.id LEFT JOIN point_of_sale t120 ON t0.point_of_sale_id = t120.id WHERE t0.id = 15;

SELECT
  a0_.id AS id_0,
  a0_.concat_key AS concat_key_1,
  a0_.value AS value_2,
  a0_.env AS env_3,
  a0_.route AS route_4,
  a0_.params AS params_5,
  a0_.component AS component_6,
  a0_.slug AS slug_7,
  a0_.role AS role_8,
  a0_.action AS action_9,
  a0_.job AS job_10
FROM
  acl_setting a0_
WHERE
  a0_.concat_key LIKE ?

SELECT a0_.id AS id_0, a0_.concat_key AS concat_key_1, a0_.value AS value_2, a0_.env AS env_3, a0_.route AS route_4, a0_.params AS params_5, a0_.component AS component_6, a0_.slug AS slug_7, a0_.role AS role_8, a0_.action AS action_9, a0_.job AS job_10 FROM acl_setting a0_ WHERE a0_.concat_key LIKE '%global_common_platform_version.no-component.no-slug.%.ROLE_DEVELOPER.NaN';

SELECT
  t0.id AS id_1,
  t0.total AS total_2,
  t0.shipping_method AS shipping_method_3,
  t0.status AS status_4,
  t0.waiting_status AS waiting_status_5,
  t0.cancel_motif AS cancel_motif_6,
  t0.shipping_price AS shipping_price_7,
  t0.internal_reference AS internal_reference_8,
  t0.comment AS comment_9,
  t0.is_managed_by_customer AS is_managed_by_customer_10,
  t0.fees_order AS fees_order_11,
  t0.extra_cb_payment AS extra_cb_payment_12,
  t0.total_bonus_used AS total_bonus_used_13,
  t0.not_billable AS not_billable_14,
  t0.otherinformations AS otherinformations_15,
  t0.old_id AS old_id_16,
  t0.category_values AS category_values_17,
  t0.fees_category_values AS fees_category_values_18,
  t0.custom_question AS custom_question_19,
  t0.order_rate AS order_rate_20,
  t0.is_trip AS is_trip_21,
  t0.order_extra_data AS order_extra_data_22,
  t0.is_express_delivery AS is_express_delivery_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.bank_return_id AS bank_return_id_26,
  t0.user_id AS user_id_27,
  t0.saleorder_grouped_id AS saleorder_grouped_id_28,
  t0.shipping_address_id AS shipping_address_id_29,
  t0.billing_address_id AS billing_address_id_30,
  t0.cart_id AS cart_id_31,
  t0.invoice_id AS invoice_id_32
FROM
  sale_order t0
WHERE
  t0.status IN (?, ?, ?, ?)
  AND t0.is_managed_by_customer = ?

SELECT t0.id AS id_1, t0.total AS total_2, t0.shipping_method AS shipping_method_3, t0.status AS status_4, t0.waiting_status AS waiting_status_5, t0.cancel_motif AS cancel_motif_6, t0.shipping_price AS shipping_price_7, t0.internal_reference AS internal_reference_8, t0.comment AS comment_9, t0.is_managed_by_customer AS is_managed_by_customer_10, t0.fees_order AS fees_order_11, t0.extra_cb_payment AS extra_cb_payment_12, t0.total_bonus_used AS total_bonus_used_13, t0.not_billable AS not_billable_14, t0.otherinformations AS otherinformations_15, t0.old_id AS old_id_16, t0.category_values AS category_values_17, t0.fees_category_values AS fees_category_values_18, t0.custom_question AS custom_question_19, t0.order_rate AS order_rate_20, t0.is_trip AS is_trip_21, t0.order_extra_data AS order_extra_data_22, t0.is_express_delivery AS is_express_delivery_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.bank_return_id AS bank_return_id_26, t0.user_id AS user_id_27, t0.saleorder_grouped_id AS saleorder_grouped_id_28, t0.shipping_address_id AS shipping_address_id_29, t0.billing_address_id AS billing_address_id_30, t0.cart_id AS cart_id_31, t0.invoice_id AS invoice_id_32 FROM sale_order t0 WHERE t0.status IN ('pending_not_confirmed', 'pending_canceled', 'pending_processing', 'pending_group') AND t0.is_managed_by_customer = 0;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.quantity AS quantity_3,
  t0.quantity_no_batch AS quantity_no_batch_4,
  t0.status AS status_5,
  t0.reference AS reference_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.gamme AS gamme_9,
  t0.price_ht AS price_ht_10,
  t0.price_ttc AS price_ttc_11,
  t0.unit_point AS unit_point_12,
  t0.image_url AS image_url_13,
  t0.image_thumbnail_url AS image_thumbnail_url_14,
  t0.taxable_amount AS taxable_amount_15,
  t0.category_values AS category_values_16,
  t0.total_chosen_category_values AS total_chosen_category_values_17,
  t0.wish_date_evasion AS wish_date_evasion_18,
  t0.weight AS weight_19,
  t0.is_refundable AS is_refundable_20,
  t0.is_replaced AS is_replaced_21,
  t0.bo_id AS bo_id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.order_id AS order_id_25,
  t26.id AS id_27,
  t26.bo_id AS bo_id_28,
  t26.sale_order_shipment_id AS sale_order_shipment_id_29,
  t26.sale_order_item_id AS sale_order_item_id_30,
  t0.replace_item_id AS replace_item_id_31
FROM
  sale_order_item t0
  LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id
WHERE
  t0.order_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.quantity AS quantity_3, t0.quantity_no_batch AS quantity_no_batch_4, t0.status AS status_5, t0.reference AS reference_6, t0.name AS name_7, t0.description AS description_8, t0.gamme AS gamme_9, t0.price_ht AS price_ht_10, t0.price_ttc AS price_ttc_11, t0.unit_point AS unit_point_12, t0.image_url AS image_url_13, t0.image_thumbnail_url AS image_thumbnail_url_14, t0.taxable_amount AS taxable_amount_15, t0.category_values AS category_values_16, t0.total_chosen_category_values AS total_chosen_category_values_17, t0.wish_date_evasion AS wish_date_evasion_18, t0.weight AS weight_19, t0.is_refundable AS is_refundable_20, t0.is_replaced AS is_replaced_21, t0.bo_id AS bo_id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.order_id AS order_id_25, t26.id AS id_27, t26.bo_id AS bo_id_28, t26.sale_order_shipment_id AS sale_order_shipment_id_29, t26.sale_order_item_id AS sale_order_item_id_30, t0.replace_item_id AS replace_item_id_31 FROM sale_order_item t0 LEFT JOIN sale_order_shipment_item t26 ON t26.sale_order_item_id = t0.id WHERE t0.order_id = 56;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.description AS description_4,
  t0.field_type AS field_type_5,
  t0.title AS title_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4, t0.field_type AS field_type_5, t0.title AS title_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = 'SHOP_ORDER_VALIDATION' LIMIT 1;