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.created_at AS created_at_91,
  t0.updated_at AS updated_at_92,
  t0.country_id AS country_id_93,
  t0.main_account_user_id AS main_account_user_id_94,
  t0.godfather_id AS godfather_id_95,
  t0.regate_id AS regate_id_96,
  t0.commercial_id AS commercial_id_97,
  t0.heating_commercial_id AS heating_commercial_id_98,
  t0.agency_id AS agency_id_99,
  t100.id AS id_101,
  t100.code AS code_102,
  t100.name AS name_103,
  t100.region AS region_104,
  t100.manager_last_name AS manager_last_name_105,
  t100.manager_first_name AS manager_first_name_106,
  t100.address1 AS address1_107,
  t100.address2 AS address2_108,
  t100.post_code AS post_code_109,
  t100.city AS city_110,
  t100.phone AS phone_111,
  t0.programme_id AS programme_id_112,
  t0.sale_order_validation_id AS sale_order_validation_id_113,
  t0.billing_point_id AS billing_point_id_114,
  t0.request_registration_id AS request_registration_id_115,
  t0.subscription_id AS subscription_id_116,
  t0.point_of_sale_id AS point_of_sale_id_117,
  t118.id AS id_119,
  t118.code AS code_120,
  t118.name AS name_121,
  t118.city AS city_122,
  t118.enabled AS enabled_123,
  t118.created_by_id AS created_by_id_124,
  t118.address_id AS address_id_125,
  t0.point_conversion_rate_id AS point_conversion_rate_id_126,
  t0.responsable_regate_id AS responsable_regate_id_127,
  t0.coverage_area_id AS coverage_area_id_128,
  t0.activated_by_id AS activated_by_id_129
FROM
  user t0
  LEFT JOIN agence t100 ON t0.agency_id = t100.id
  LEFT JOIN point_of_sale t118 ON t0.point_of_sale_id = t118.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.created_at AS created_at_91, t0.updated_at AS updated_at_92, t0.country_id AS country_id_93, t0.main_account_user_id AS main_account_user_id_94, t0.godfather_id AS godfather_id_95, t0.regate_id AS regate_id_96, t0.commercial_id AS commercial_id_97, t0.heating_commercial_id AS heating_commercial_id_98, t0.agency_id AS agency_id_99, t100.id AS id_101, t100.code AS code_102, t100.name AS name_103, t100.region AS region_104, t100.manager_last_name AS manager_last_name_105, t100.manager_first_name AS manager_first_name_106, t100.address1 AS address1_107, t100.address2 AS address2_108, t100.post_code AS post_code_109, t100.city AS city_110, t100.phone AS phone_111, t0.programme_id AS programme_id_112, t0.sale_order_validation_id AS sale_order_validation_id_113, t0.billing_point_id AS billing_point_id_114, t0.request_registration_id AS request_registration_id_115, t0.subscription_id AS subscription_id_116, t0.point_of_sale_id AS point_of_sale_id_117, t118.id AS id_119, t118.code AS code_120, t118.name AS name_121, t118.city AS city_122, t118.enabled AS enabled_123, t118.created_by_id AS created_by_id_124, t118.address_id AS address_id_125, t0.point_conversion_rate_id AS point_conversion_rate_id_126, t0.responsable_regate_id AS responsable_regate_id_127, t0.coverage_area_id AS coverage_area_id_128, t0.activated_by_id AS activated_by_id_129 FROM user t0 LEFT JOIN agence t100 ON t0.agency_id = t100.id LEFT JOIN point_of_sale t118 ON t0.point_of_sale_id = t118.id WHERE t0.id = 2;

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 '%check_favorites.no-component.no-slug.%.ROLE_ADMIN.NaN';

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 = 'GENERAL_START_DATE' LIMIT 1;

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_.env = ?
  AND a0_.route = ?
  AND a0_.params = ?
  AND a0_.component = ?
  AND a0_.slug = ?
  AND a0_.action = ?
  AND a0_.role = ?
  AND a0_.job = ?

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_.env = 'front' AND a0_.route = 'check_favorites' AND a0_.params = '[]' AND a0_.component = 'no-component' AND a0_.slug = 'no-slug' AND a0_.action = 'read' AND a0_.role = 'ROLE_ADMIN' AND a0_.job = 'no-job';

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 = ?
  AND t0.value = ?
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 = 'GENERAL_ENABLED' AND t0.value = '0' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.sku AS sku_2,
  t0.added_date AS added_date_3,
  t0.type AS type_4,
  t0.user_id AS user_id_5
FROM
  user_favorites t0
WHERE
  t0.sku IN (?, ?, ?, ?)
  AND t0.user_id = ?

SELECT t0.id AS id_1, t0.sku AS sku_2, t0.added_date AS added_date_3, t0.type AS type_4, t0.user_id AS user_id_5 FROM user_favorites t0 WHERE t0.sku IN ('000003673F', '000003674C', '000003674D', '0000036751') AND t0.user_id = 2;