Symfony Profiler

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.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.hostname = ?
  AND t0.enabled = ?
ORDER BY
  t0.id ASC
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.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = 'tekko.ltd' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

SELECT
  COUNT(*)
FROM
  sylius_channel t0

SELECT COUNT(*) FROM sylius_channel t0;

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.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
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.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id LIMIT 1;

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 = 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.customer_group_id AS customer_group_id_12,
  t0.default_address_id AS default_address_id_13,
  t14.username AS username_15,
  t14.username_canonical AS username_canonical_16,
  t14.enabled AS enabled_17,
  t14.password AS password_18,
  t14.last_login AS last_login_19,
  t14.password_reset_token AS password_reset_token_20,
  t14.password_requested_at AS password_requested_at_21,
  t14.email_verification_token AS email_verification_token_22,
  t14.verified_at AS verified_at_23,
  t14.roles AS roles_24,
  t14.email AS email_25,
  t14.email_canonical AS email_canonical_26,
  t14.created_at AS created_at_27,
  t14.updated_at AS updated_at_28,
  t14.id AS id_29,
  t14.customer_id AS customer_id_30
FROM
  sylius_customer t0
  LEFT JOIN sylius_shop_user t14 ON t14.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.customer_group_id AS customer_group_id_12, t0.default_address_id AS default_address_id_13, t14.username AS username_15, t14.username_canonical AS username_canonical_16, t14.enabled AS enabled_17, t14.password AS password_18, t14.last_login AS last_login_19, t14.password_reset_token AS password_reset_token_20, t14.password_requested_at AS password_requested_at_21, t14.email_verification_token AS email_verification_token_22, t14.verified_at AS verified_at_23, t14.roles AS roles_24, t14.email AS email_25, t14.email_canonical AS email_canonical_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.id AS id_29, t14.customer_id AS customer_id_30 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t14 ON t14.customer_id = t0.id WHERE t0.email = 'zifadzfl@dont-reply.me' 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.customer_group_id AS customer_group_id_12,
  t0.default_address_id AS default_address_id_13,
  t14.username AS username_15,
  t14.username_canonical AS username_canonical_16,
  t14.enabled AS enabled_17,
  t14.password AS password_18,
  t14.last_login AS last_login_19,
  t14.password_reset_token AS password_reset_token_20,
  t14.password_requested_at AS password_requested_at_21,
  t14.email_verification_token AS email_verification_token_22,
  t14.verified_at AS verified_at_23,
  t14.roles AS roles_24,
  t14.email AS email_25,
  t14.email_canonical AS email_canonical_26,
  t14.created_at AS created_at_27,
  t14.updated_at AS updated_at_28,
  t14.id AS id_29,
  t14.customer_id AS customer_id_30
FROM
  sylius_customer t0
  LEFT JOIN sylius_shop_user t14 ON t14.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.customer_group_id AS customer_group_id_12, t0.default_address_id AS default_address_id_13, t14.username AS username_15, t14.username_canonical AS username_canonical_16, t14.enabled AS enabled_17, t14.password AS password_18, t14.last_login AS last_login_19, t14.password_reset_token AS password_reset_token_20, t14.password_requested_at AS password_requested_at_21, t14.email_verification_token AS email_verification_token_22, t14.verified_at AS verified_at_23, t14.roles AS roles_24, t14.email AS email_25, t14.email_canonical AS email_canonical_26, t14.created_at AS created_at_27, t14.updated_at AS updated_at_28, t14.id AS id_29, t14.customer_id AS customer_id_30 FROM sylius_customer t0 LEFT JOIN sylius_shop_user t14 ON t14.customer_id = t0.id WHERE t0.email_canonical = 'zifadzfl@dont-reply.me' LIMIT 2;

"START TRANSACTION"

"START TRANSACTION";

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, 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, default_address_id) VALUES ('zifadzfl@dont-reply.me', 'zifadzfl@dont-reply.me', 'MyName', 'John', NULL, 'u', '2025-05-09 23:14:19', '2025-05-09 23:14:19', 'Hello', 1, NULL, NULL);

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

INSERT INTO sylius_shop_user (username, username_canonical, enabled, password, last_login, password_reset_token, password_requested_at, email_verification_token, verified_at, roles, email, email_canonical, created_at, updated_at, customer_id) VALUES ('zifadzfl@dont-reply.me', 'zifadzfl@dont-reply.me', 0, '$argon2i$v=19$m=65536,t=4,p=1$UXplUHROalNoT2w4eG8xZQ$KQqDyuzDVl2v8BYGm1dH/xCQl1FXmBhm+JSEh9km0ew', NULL, NULL, NULL, NULL, NULL, '[\"ROLE_USER\"]', NULL, NULL, '2025-05-09 23:14:19', '2025-05-09 23:14:19', 53);

"COMMIT"

"COMMIT";

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.enabled AS enabled_3,
  t0.password AS password_4,
  t0.last_login AS last_login_5,
  t0.password_reset_token AS password_reset_token_6,
  t0.password_requested_at AS password_requested_at_7,
  t0.email_verification_token AS email_verification_token_8,
  t0.verified_at AS verified_at_9,
  t0.roles AS roles_10,
  t0.email AS email_11,
  t0.email_canonical AS email_canonical_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.id AS id_15,
  t0.customer_id AS customer_id_16
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.password AS password_4, t0.last_login AS last_login_5, t0.password_reset_token AS password_reset_token_6, t0.password_requested_at AS password_requested_at_7, t0.email_verification_token AS email_verification_token_8, t0.verified_at AS verified_at_9, t0.roles AS roles_10, t0.email AS email_11, t0.email_canonical AS email_canonical_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.id AS id_15, t0.customer_id AS customer_id_16 FROM sylius_shop_user t0 WHERE t0.email_verification_token = 'Lijn4lXeE0~xvYw6_~EyTpwDloDtrYNxy~O0aUweU06l6Fuj_t90NJa-VOQit9bJ' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE sylius_shop_user SET email_verification_token = 'Lijn4lXeE0~xvYw6_~EyTpwDloDtrYNxy~O0aUweU06l6Fuj_t90NJa-VOQit9bJ', updated_at = '2025-05-09 23:14:19' WHERE id = 53;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";