Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.enabled AS enabled_3,
  t0.salt AS salt_4,
  t0.password AS password_5,
  t0.encoder_name AS encoder_name_6,
  t0.last_login AS last_login_7,
  t0.password_reset_token AS password_reset_token_8,
  t0.password_requested_at AS password_requested_at_9,
  t0.email_verification_token AS email_verification_token_10,
  t0.verified_at AS verified_at_11,
  t0.locked AS locked_12,
  t0.expires_at AS expires_at_13,
  t0.credentials_expire_at AS credentials_expire_at_14,
  t0.roles AS roles_15,
  t0.email AS email_16,
  t0.email_canonical AS email_canonical_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.id AS id_20,
  t0.customer_id AS customer_id_21
FROM
  sylius_shop_user t0
WHERE
  t0.email_verification_token = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.customer_id AS customer_id_21 FROM sylius_shop_user t0 WHERE t0.email_verification_token = 'zO4CbxRqoI1jaVzc' LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  t0.email AS email_1,
  t0.email_canonical AS email_canonical_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.birthday AS birthday_5,
  t0.gender AS gender_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.phone_number AS phone_number_9,
  t0.subscribed_to_newsletter AS subscribed_to_newsletter_10,
  t0.id AS id_11,
  t0.pseudo AS pseudo_12,
  t0.customer_group_id AS customer_group_id_13,
  t0.default_address_id AS default_address_id_14,
  t15.username AS username_16,
  t15.username_canonical AS username_canonical_17,
  t15.enabled AS enabled_18,
  t15.salt AS salt_19,
  t15.password AS password_20,
  t15.encoder_name AS encoder_name_21,
  t15.last_login AS last_login_22,
  t15.password_reset_token AS password_reset_token_23,
  t15.password_requested_at AS password_requested_at_24,
  t15.email_verification_token AS email_verification_token_25,
  t15.verified_at AS verified_at_26,
  t15.locked AS locked_27,
  t15.expires_at AS expires_at_28,
  t15.credentials_expire_at AS credentials_expire_at_29,
  t15.roles AS roles_30,
  t15.email AS email_31,
  t15.email_canonical AS email_canonical_32,
  t15.created_at AS created_at_33,
  t15.updated_at AS updated_at_34,
  t15.id AS id_35,
  t15.customer_id AS customer_id_36
FROM
  sylius_customer t0
  LEFT JOIN sylius_shop_user t15 ON t15.customer_id = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.pseudo AS pseudo_12, t0.customer_group_id AS customer_group_id_13, t0.default_address_id AS default_address_id_14, t15.username AS username_16, t15.username_canonical AS username_canonical_17, t15.enabled AS enabled_18, t15.salt AS salt_19, t15.password AS password_20, t15.encoder_name AS encoder_name_21, t15.last_login AS last_login_22, t15.password_reset_token AS password_reset_token_23, t15.password_requested_at AS password_requested_at_24, t15.email_verification_token AS email_verification_token_25, t15.verified_at AS verified_at_26, t15.locked AS locked_27, t15.expires_at AS expires_at_28, t15.credentials_expire_at AS credentials_expire_at_29, t15.roles AS roles_30, t15.email AS email_31, t15.email_canonical AS email_canonical_32, t15.created_at AS created_at_33, t15.updated_at AS updated_at_34, t15.id AS id_35, t15.customer_id AS customer_id_36 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t15 ON t15.customer_id = t0.id WHERE t0.email = 'erasluanda@gmail.com' LIMIT 1;

SELECT
  t0.email AS email_1,
  t0.email_canonical AS email_canonical_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.birthday AS birthday_5,
  t0.gender AS gender_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.phone_number AS phone_number_9,
  t0.subscribed_to_newsletter AS subscribed_to_newsletter_10,
  t0.id AS id_11,
  t0.pseudo AS pseudo_12,
  t0.customer_group_id AS customer_group_id_13,
  t0.default_address_id AS default_address_id_14,
  t15.username AS username_16,
  t15.username_canonical AS username_canonical_17,
  t15.enabled AS enabled_18,
  t15.salt AS salt_19,
  t15.password AS password_20,
  t15.encoder_name AS encoder_name_21,
  t15.last_login AS last_login_22,
  t15.password_reset_token AS password_reset_token_23,
  t15.password_requested_at AS password_requested_at_24,
  t15.email_verification_token AS email_verification_token_25,
  t15.verified_at AS verified_at_26,
  t15.locked AS locked_27,
  t15.expires_at AS expires_at_28,
  t15.credentials_expire_at AS credentials_expire_at_29,
  t15.roles AS roles_30,
  t15.email AS email_31,
  t15.email_canonical AS email_canonical_32,
  t15.created_at AS created_at_33,
  t15.updated_at AS updated_at_34,
  t15.id AS id_35,
  t15.customer_id AS customer_id_36
FROM
  sylius_customer t0
  LEFT JOIN sylius_shop_user t15 ON t15.customer_id = t0.id
WHERE
  t0.email_canonical = ?
LIMIT
  2

SELECT t0.email AS email_1, t0.email_canonical AS email_canonical_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.birthday AS birthday_5, t0.gender AS gender_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.phone_number AS phone_number_9, t0.subscribed_to_newsletter AS subscribed_to_newsletter_10, t0.id AS id_11, t0.pseudo AS pseudo_12, t0.customer_group_id AS customer_group_id_13, t0.default_address_id AS default_address_id_14, t15.username AS username_16, t15.username_canonical AS username_canonical_17, t15.enabled AS enabled_18, t15.salt AS salt_19, t15.password AS password_20, t15.encoder_name AS encoder_name_21, t15.last_login AS last_login_22, t15.password_reset_token AS password_reset_token_23, t15.password_requested_at AS password_requested_at_24, t15.email_verification_token AS email_verification_token_25, t15.verified_at AS verified_at_26, t15.locked AS locked_27, t15.expires_at AS expires_at_28, t15.credentials_expire_at AS credentials_expire_at_29, t15.roles AS roles_30, t15.email AS email_31, t15.email_canonical AS email_canonical_32, t15.created_at AS created_at_33, t15.updated_at AS updated_at_34, t15.id AS id_35, t15.customer_id AS customer_id_36 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t15 ON t15.customer_id = t0.id WHERE t0.email_canonical = 'erasluanda@gmail.com' LIMIT 2;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  sylius_currency t0
  INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id
WHERE
  sylius_channel_currencies.channel_id = ?
ORDER BY
  t0.id ASC

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = 1 ORDER BY t0.id ASC;

SELECT
  t0.code AS code_1,
  t0.enabled AS enabled_2,
  t0.id AS id_3
FROM
  sylius_country t0
  INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id
WHERE
  sylius_channel_countries.channel_id = ?

SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.default_locale_id AS default_locale_id_17,
  t18.code AS code_19,
  t18.created_at AS created_at_20,
  t18.updated_at AS updated_at_21,
  t18.id AS id_22,
  t0.base_currency_id AS base_currency_id_23,
  t24.code AS code_25,
  t24.created_at AS created_at_26,
  t24.updated_at AS updated_at_27,
  t24.id AS id_28,
  t0.default_tax_zone_id AS default_tax_zone_id_29,
  t0.menu_taxon_id AS menu_taxon_id_30,
  t0.shop_billing_data_id AS shop_billing_data_id_31
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id
  INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id;

INSERT INTO sylius_customer (
  email, email_canonical, first_name,
  last_name, birthday, gender, created_at,
  updated_at, phone_number, subscribed_to_newsletter,
  customer_group_id, pseudo, default_address_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO sylius_customer (email, email_canonical, first_name, last_name, birthday, gender, created_at, updated_at, phone_number, subscribed_to_newsletter, customer_group_id, pseudo, default_address_id) VALUES ('erasluanda@gmail.com', 'erasluanda@gmail.com', 'Deyvion', 'Cornelles', NULL, 'u', '2024-12-23 00:00:36', '2024-12-23 00:00:37', '+17302050230', 1, NULL, 'Pashka and Rolin and the radio kept shouting blood spilt in', NULL);

SELECT
  b0_.code AS code_0,
  b0_.enabled AS enabled_1,
  b0_.id AS id_2
FROM
  bitbag_cms_block b0_
  LEFT JOIN bitbag_cms_block_channels b2_ ON b0_.id = b2_.block_id
  LEFT JOIN sylius_channel s1_ ON s1_.id = b2_.channel_id
WHERE
  b0_.code = ?
  AND b0_.enabled = 1
  AND s1_.code = ?
ORDER BY
  b0_.id ASC

SELECT b0_.code AS code_0, b0_.enabled AS enabled_1, b0_.id AS id_2 FROM bitbag_cms_block b0_ LEFT JOIN bitbag_cms_block_channels b2_ ON b0_.id = b2_.block_id LEFT JOIN sylius_channel s1_ ON s1_.id = b2_.channel_id WHERE b0_.code = 'home_presentation_texte' AND b0_.enabled = 1 AND s1_.code = 'default' ORDER BY b0_.id ASC;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  sylius_locale t0
  INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id
WHERE
  sylius_channel_locales.channel_id = ?

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.default_locale_id AS default_locale_id_17,
  t18.code AS code_19,
  t18.created_at AS created_at_20,
  t18.updated_at AS updated_at_21,
  t18.id AS id_22,
  t0.base_currency_id AS base_currency_id_23,
  t24.code AS code_25,
  t24.created_at AS created_at_26,
  t24.updated_at AS updated_at_27,
  t24.id AS id_28,
  t0.default_tax_zone_id AS default_tax_zone_id_29,
  t0.menu_taxon_id AS menu_taxon_id_30,
  t0.shop_billing_data_id AS shop_billing_data_id_31
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id
  INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id
WHERE
  t0.hostname = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.default_locale_id AS default_locale_id_17, t18.code AS code_19, t18.created_at AS created_at_20, t18.updated_at AS updated_at_21, t18.id AS id_22, t0.base_currency_id AS base_currency_id_23, t24.code AS code_25, t24.created_at AS created_at_26, t24.updated_at AS updated_at_27, t24.id AS id_28, t0.default_tax_zone_id AS default_tax_zone_id_29, t0.menu_taxon_id AS menu_taxon_id_30, t0.shop_billing_data_id AS shop_billing_data_id_31 FROM sylius_channel t0 INNER JOIN sylius_locale t18 ON t0.default_locale_id = t18.id INNER JOIN sylius_currency t24 ON t0.base_currency_id = t24.id WHERE t0.hostname = 'hephaestos.net' AND t0.enabled = 1 LIMIT 1;

SELECT
  t0.name AS name_1,
  t0.content AS content_2,
  t0.link AS link_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  bitbag_cms_block_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.content AS content_2, t0.link AS link_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM bitbag_cms_block_translation t0 WHERE t0.translatable_id = 9 AND t0.locale = 'fr' LIMIT 1;

UPDATE
  sylius_shop_user
SET
  email_verification_token = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE sylius_shop_user SET email_verification_token = 'zO4CbxRqoI1jaVzc', updated_at = '2024-12-23 00:00:37' WHERE id = 10300;

INSERT INTO sylius_shop_user (
  username, username_canonical, enabled,
  salt, password, encoder_name, last_login,
  password_reset_token, password_requested_at,
  email_verification_token, verified_at,
  locked, expires_at, credentials_expire_at,
  roles, email, email_canonical, created_at,
  updated_at, customer_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO sylius_shop_user (username, username_canonical, enabled, salt, password, encoder_name, last_login, password_reset_token, password_requested_at, email_verification_token, verified_at, locked, expires_at, credentials_expire_at, roles, email, email_canonical, created_at, updated_at, customer_id) VALUES ('erasluanda@gmail.com', 'erasluanda@gmail.com', 0, 'ccoudcnwn9c0o0ooksg00sg84gcwcoo', 'cj/ncSx/LYvjkGcOElzNDNAp8B+yDun5oMXcMBGsRD/lYGOvmflONRq0Aiku4NgsEc+wZRSTLxzPgQ5sRItqXw==', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'a:1:{i:0;s:9:\"ROLE_USER\";}', NULL, NULL, '2024-12-23 00:00:36', '2024-12-23 00:00:37', 6007);

"START TRANSACTION"

"START TRANSACTION";