Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.created_at AS created_at_4,
  t0.email AS email_5,
  t0.description AS description_6,
  t0.is_valid AS is_valid_7,
  t0.full_name AS full_name_8,
  t0.tel AS tel_9,
  t0.address AS address_10,
  t0.city AS city_11,
  t0.ice AS ice_12,
  t0.rc AS rc_13,
  t0.simulate_username AS simulate_username_14,
  t0.simulate_password AS simulate_password_15,
  t0.cover_image AS cover_image_16,
  t0.path_rcimage AS path_rcimage_17,
  t0.path_ice_image AS path_ice_image_18,
  t0.path_ifimage AS path_ifimage_19,
  t0.identifiant_fiscale AS identifiant_fiscale_20,
  t0.user_id AS user_id_21
FROM
  vendor t0
WHERE
  t0.user_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_rcimage AS path_rcimage_17, t0.path_ice_image AS path_ice_image_18, t0.path_ifimage AS path_ifimage_19, t0.identifiant_fiscale AS identifiant_fiscale_20, t0.user_id AS user_id_21 FROM vendor t0 WHERE t0.user_id IS NULL LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.description AS description_1,
  c0_.email AS email_2,
  c0_.created_at AS created_at_3,
  c0_.first_name AS first_name_4,
  c0_.last_name AS last_name_5,
  c0_.address AS address_6,
  c0_.city AS city_7,
  c0_.phone AS phone_8,
  c0_.company_name AS company_name_9,
  c0_.address_indication AS address_indication_10,
  c0_.country AS country_11,
  c0_.post_code AS post_code_12,
  c0_.gender AS gender_13,
  c0_.date_of_birth AS date_of_birth_14,
  c0_.sponsorship_code AS sponsorship_code_15,
  c0_.image AS image_16,
  c0_.can_receive_mails AS can_receive_mails_17,
  c0_.can_receive_sms AS can_receive_sms_18,
  c0_.blind_password AS blind_password_19,
  c0_.deleted_at AS deleted_at_20,
  c0_.collect_address AS collect_address_21,
  c0_.shipping_address AS shipping_address_22,
  c0_.collect_lat AS collect_lat_23,
  c0_.collect_lng AS collect_lng_24,
  c0_.shipping_lng AS shipping_lng_25,
  c0_.code AS code_26,
  c0_.reference AS reference_27,
  c0_.identity_number AS identity_number_28,
  c0_.is_actif AS is_actif_29,
  c0_.customer_group_id AS customer_group_id_30,
  c0_.user_id AS user_id_31,
  c0_.vendor_id AS vendor_id_32,
  c0_.city_region_id AS city_region_id_33,
  c0_.store_id AS store_id_34
FROM
  customer c0_
WHERE
  (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.code AS code_26, c0_.reference AS reference_27, c0_.identity_number AS identity_number_28, c0_.is_actif AS is_actif_29, c0_.customer_group_id AS customer_group_id_30, c0_.user_id AS user_id_31, c0_.vendor_id AS vendor_id_32, c0_.city_region_id AS city_region_id_33, c0_.store_id AS store_id_34 FROM customer c0_ WHERE (c0_.deleted_at IS NULL);

SELECT
  a0_.id AS id_0,
  a0_.first_name AS first_name_1,
  a0_.last_name AS last_name_2,
  a0_.email AS email_3,
  a0_.phone AS phone_4,
  a0_.address AS address_5,
  a0_.photo_identity AS photo_identity_6,
  a0_.gender AS gender_7,
  a0_.identity_number AS identity_number_8,
  a0_.deleted_at AS deleted_at_9,
  a0_.user_id AS user_id_10,
  a0_.agent_type_id AS agent_type_id_11,
  a0_.store_id AS store_id_12,
  a0_.agent_objective_id AS agent_objective_id_13
FROM
  agent a0_
  LEFT JOIN user u1_ ON a0_.user_id = u1_.id
WHERE
  (u1_.roles LIKE ?)
  AND (a0_.deleted_at IS NULL)

SELECT a0_.id AS id_0, a0_.first_name AS first_name_1, a0_.last_name AS last_name_2, a0_.email AS email_3, a0_.phone AS phone_4, a0_.address AS address_5, a0_.photo_identity AS photo_identity_6, a0_.gender AS gender_7, a0_.identity_number AS identity_number_8, a0_.deleted_at AS deleted_at_9, a0_.user_id AS user_id_10, a0_.agent_type_id AS agent_type_id_11, a0_.store_id AS store_id_12, a0_.agent_objective_id AS agent_objective_id_13 FROM agent a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id WHERE (u1_.roles LIKE '%ROLE_COMMERCIAL_AGENT%') AND (a0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6405;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6406;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6408;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6410;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6411;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6412;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6413;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_valid AS is_valid_5,
  t0.is_verified AS is_verified_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_valid AS is_valid_5, t0.is_verified AS is_verified_6 FROM user t0 WHERE t0.id = 6414;

SELECT
  c0_.id AS id_0,
  c0_.start_at AS start_at_1,
  c0_.end_at AS end_at_2,
  c0_.deleted_at AS deleted_at_3,
  c0_.store_id AS store_id_4
FROM
  cash_box_order c0_

SELECT c0_.id AS id_0, c0_.start_at AS start_at_1, c0_.end_at AS end_at_2, c0_.deleted_at AS deleted_at_3, c0_.store_id AS store_id_4 FROM cash_box_order c0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.created_at AS created_at_2,
  s0_.description AS description_3,
  s0_.store_type AS store_type_4,
  s0_.city_id AS city_id_5,
  s0_.user_id AS user_id_6,
  s0_.city_region_id AS city_region_id_7
FROM
  store s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.created_at AS created_at_2, s0_.description AS description_3, s0_.store_type AS store_type_4, s0_.city_id AS city_id_5, s0_.user_id AS user_id_6, s0_.city_region_id AS city_region_id_7 FROM store s0_;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.image AS image_2,
  p0_.price AS price_3,
  p0_.description AS description_4,
  p0_.old_price AS old_price_5,
  p0_.quantity AS quantity_6,
  p0_.product_type AS product_type_7,
  p0_.meta_title AS meta_title_8,
  p0_.meta_description AS meta_description_9,
  p0_.meta_keywords AS meta_keywords_10,
  p0_.slug AS slug_11,
  p0_.created_at AS created_at_12,
  p0_.is_price_reduced_per_percent AS is_price_reduced_per_percent_13,
  p0_.percent_reduction AS percent_reduction_14,
  p0_.sku_code AS sku_code_15,
  p0_.short_description AS short_description_16,
  p0_.is_published AS is_published_17,
  p0_.sku_code_shop AS sku_code_shop_18,
  p0_.end_at AS end_at_19,
  p0_.type_reduction AS type_reduction_20,
  p0_.value_reduction AS value_reduction_21,
  p0_.subscription_monthly_price AS subscription_monthly_price_22,
  p0_.subscription_yearly_price AS subscription_yearly_price_23,
  p0_.deleted_at AS deleted_at_24,
  p0_.label_price_from AS label_price_from_25,
  p0_.subscription_duration AS subscription_duration_26,
  a1_.regular_price AS regular_price_27,
  p0_.dtype AS dtype_28,
  p0_.promotion_id AS promotion_id_29,
  p0_.vendor_id AS vendor_id_30,
  p0_.brand_id AS brand_id_31,
  p0_.parent_category_id AS parent_category_id_32,
  p0_.cloned_product_id AS cloned_product_id_33,
  p0_.store_id AS store_id_34
FROM
  product p0_
  LEFT JOIN article a1_ ON p0_.id = a1_.id
  LEFT JOIN shop_product s2_ ON p0_.id = s2_.id
WHERE
  (p0_.deleted_at IS NULL)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.price AS price_3, p0_.description AS description_4, p0_.old_price AS old_price_5, p0_.quantity AS quantity_6, p0_.product_type AS product_type_7, p0_.meta_title AS meta_title_8, p0_.meta_description AS meta_description_9, p0_.meta_keywords AS meta_keywords_10, p0_.slug AS slug_11, p0_.created_at AS created_at_12, p0_.is_price_reduced_per_percent AS is_price_reduced_per_percent_13, p0_.percent_reduction AS percent_reduction_14, p0_.sku_code AS sku_code_15, p0_.short_description AS short_description_16, p0_.is_published AS is_published_17, p0_.sku_code_shop AS sku_code_shop_18, p0_.end_at AS end_at_19, p0_.type_reduction AS type_reduction_20, p0_.value_reduction AS value_reduction_21, p0_.subscription_monthly_price AS subscription_monthly_price_22, p0_.subscription_yearly_price AS subscription_yearly_price_23, p0_.deleted_at AS deleted_at_24, p0_.label_price_from AS label_price_from_25, p0_.subscription_duration AS subscription_duration_26, a1_.regular_price AS regular_price_27, p0_.dtype AS dtype_28, p0_.promotion_id AS promotion_id_29, p0_.vendor_id AS vendor_id_30, p0_.brand_id AS brand_id_31, p0_.parent_category_id AS parent_category_id_32, p0_.cloned_product_id AS cloned_product_id_33, p0_.store_id AS store_id_34 FROM product p0_ LEFT JOIN article a1_ ON p0_.id = a1_.id LEFT JOIN shop_product s2_ ON p0_.id = s2_.id WHERE (p0_.deleted_at IS NULL);

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.image AS image_2,
  p0_.description AS description_3,
  p0_.code AS code_4,
  p0_.is_enabled AS is_enabled_5,
  p0_.created_at AS created_at_6,
  p0_.position AS position_7,
  p0_.type AS type_8,
  p0_.secret_key AS secret_key_9,
  p0_.public_key AS public_key_10,
  p0_.display_on AS display_on_11
FROM
  payment_method p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.description AS description_3, p0_.code AS code_4, p0_.is_enabled AS is_enabled_5, p0_.created_at AS created_at_6, p0_.position AS position_7, p0_.type AS type_8, p0_.secret_key AS secret_key_9, p0_.public_key AS public_key_10, p0_.display_on AS display_on_11 FROM payment_method p0_;

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.front_theme_id AS front_theme_id_30
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;