Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.dsn AS dsn_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  mail_transport t0
WHERE
  t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.dsn AS dsn_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM mail_transport t0 WHERE t0.enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.facebook_id AS facebook_id_6,
  t0.google_id AS google_id_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.gender AS gender_10,
  t0.phone AS phone_11,
  t0.landline_phone AS landline_phone_12,
  t0.image_url AS image_url_13,
  t0.deleted AS deleted_14,
  t0.deleted_at AS deleted_at_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.image_name AS image_name_18,
  t0.image_original_name AS image_original_name_19,
  t0.image_mime_type AS image_mime_type_20,
  t0.image_size AS image_size_21,
  t0.image_dimensions AS image_dimensions_22,
  t0.discr,
  t0.franchise_id AS franchise_id_23,
  t0.shop_id AS shop_id_24,
  t0.device_id AS device_id_25,
  t0.notification_email AS notification_email_26,
  t0.notification_sms AS notification_sms_27,
  t0.receive_qoodos_notification AS receive_qoodos_notification_28,
  t0.default_language AS default_language_29,
  t0.source AS source_30,
  t0.phone_verified AS phone_verified_31
FROM
  user t0
WHERE
  t0.email = ?
  AND t0.discr IN (
    'user', 'manager', 'shopmanager',
    'customer', 'administrator', 'support',
    'developer'
  )
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.facebook_id AS facebook_id_6, t0.google_id AS google_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.gender AS gender_10, t0.phone AS phone_11, t0.landline_phone AS landline_phone_12, t0.image_url AS image_url_13, t0.deleted AS deleted_14, t0.deleted_at AS deleted_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.image_original_name AS image_original_name_19, t0.image_mime_type AS image_mime_type_20, t0.image_size AS image_size_21, t0.image_dimensions AS image_dimensions_22, t0.discr, t0.franchise_id AS franchise_id_23, t0.shop_id AS shop_id_24, t0.device_id AS device_id_25, t0.notification_email AS notification_email_26, t0.notification_sms AS notification_sms_27, t0.receive_qoodos_notification AS receive_qoodos_notification_28, t0.default_language AS default_language_29, t0.source AS source_30, t0.phone_verified AS phone_verified_31 FROM user t0 WHERE t0.email = 'abatalib@gmail.com' AND t0.discr IN ('user', 'manager', 'shopmanager', 'customer', 'administrator', 'support', 'developer') AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.role AS role_3,
  t0.importance AS importance_4,
  t0.enabled AS enabled_5
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3, t0.importance AS importance_4, t0.enabled AS enabled_5 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 57356;

SELECT
  t0.id AS id_1,
  t0.qoodos_id AS qoodos_id_2,
  t0.multiple AS multiple_3,
  t0.name AS name_4,
  t0.status AS status_5,
  t0.qoodos_tokens AS qoodos_tokens_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.token AS token_9,
  t10.id AS id_11,
  t10.name AS name_12,
  t10.phone AS phone_13,
  t10.secondary_phone AS secondary_phone_14,
  t10.fax AS fax_15,
  t10.email AS email_16,
  t10.created_at AS created_at_17,
  t10.updated_at AS updated_at_18,
  t10.franchise_id AS franchise_id_19,
  t20.id AS id_21,
  t20.header AS header_22,
  t20.enable_header AS enable_header_23,
  t20.title AS title_24,
  t20.description AS description_25,
  t20.keywords AS keywords_26,
  t20.map AS map_27,
  t20.google_auth_enabled AS google_auth_enabled_28,
  t20.apple_auth_enabled AS apple_auth_enabled_29,
  t20.signup_text AS signup_text_30,
  t20.created_at AS created_at_31,
  t20.updated_at AS updated_at_32,
  t20.franchise_id AS franchise_id_33,
  t20.locale_id AS locale_id_34
FROM
  franchise t0
  LEFT JOIN company t10 ON t10.franchise_id = t0.id
  LEFT JOIN parameter t20 ON t20.franchise_id = t0.id
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.qoodos_id AS qoodos_id_2, t0.multiple AS multiple_3, t0.name AS name_4, t0.status AS status_5, t0.qoodos_tokens AS qoodos_tokens_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.token AS token_9, t10.id AS id_11, t10.name AS name_12, t10.phone AS phone_13, t10.secondary_phone AS secondary_phone_14, t10.fax AS fax_15, t10.email AS email_16, t10.created_at AS created_at_17, t10.updated_at AS updated_at_18, t10.franchise_id AS franchise_id_19, t20.id AS id_21, t20.header AS header_22, t20.enable_header AS enable_header_23, t20.title AS title_24, t20.description AS description_25, t20.keywords AS keywords_26, t20.map AS map_27, t20.google_auth_enabled AS google_auth_enabled_28, t20.apple_auth_enabled AS apple_auth_enabled_29, t20.signup_text AS signup_text_30, t20.created_at AS created_at_31, t20.updated_at AS updated_at_32, t20.franchise_id AS franchise_id_33, t20.locale_id AS locale_id_34 FROM franchise t0 LEFT JOIN company t10 ON t10.franchise_id = t0.id LEFT JOIN parameter t20 ON t20.franchise_id = t0.id WHERE t0.token = 'utgCTmhute' LIMIT 1;

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
  INNER JOIN customer_franchise c1_ ON u0_.id = c1_.customer_id
  AND (c1_.deleted_at IS NULL)
WHERE
  (
    (
      u0_.id = ?
      AND c1_.franchise_id = ?
    )
    AND (u0_.deleted_at IS NULL)
  )
  AND u0_.discr IN ('customer')

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ INNER JOIN customer_franchise c1_ ON u0_.id = c1_.customer_id AND (c1_.deleted_at IS NULL) WHERE ((u0_.id = 57356 AND c1_.franchise_id = 49) AND (u0_.deleted_at IS NULL)) AND u0_.discr IN ('customer');

SELECT
  c0_.ask_for_subscription_to_qoodos AS ask_for_subscription_to_qoodos_0
FROM
  customer_franchise c0_
WHERE
  (
    c0_.franchise_id = ?
    AND c0_.customer_id = ?
  )
  AND (c0_.deleted_at IS NULL)

SELECT c0_.ask_for_subscription_to_qoodos AS ask_for_subscription_to_qoodos_0 FROM customer_franchise c0_ WHERE (c0_.franchise_id = 49 AND c0_.customer_id = 57356) AND (c0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.qoodos_id AS qoodos_id_2,
  t0.name AS name_3,
  t0.licence AS licence_4,
  t0.device_id AS device_id_5,
  t0.qoodos_subscription_title AS qoodos_subscription_title_6,
  t0.qoodos_subscription_message AS qoodos_subscription_message_7,
  t0.qoodos_display_ask_again AS qoodos_display_ask_again_8,
  t0.time_zone AS time_zone_9,
  t0.siret AS siret_10,
  t0.enabled AS enabled_11,
  t0.address AS address_12,
  t0.latitude AS latitude_13,
  t0.longitude AS longitude_14,
  t0.phone AS phone_15,
  t0.email AS email_16,
  t0.deleted AS deleted_17,
  t0.deleted_at AS deleted_at_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.token AS token_21,
  t0.logo_name AS logo_name_22,
  t0.logo_original_name AS logo_original_name_23,
  t0.logo_mime_type AS logo_mime_type_24,
  t0.logo_size AS logo_size_25,
  t0.logo_dimensions AS logo_dimensions_26,
  t0.franchise_id AS franchise_id_27,
  t28.id AS id_29,
  t28.mac AS mac_30,
  t28.duplication AS duplication_31,
  t28.starcloud_attempts AS starcloud_attempts_32,
  t28.created_at AS created_at_33,
  t28.updated_at AS updated_at_34,
  t28.logo_name AS logo_name_35,
  t28.logo_original_name AS logo_original_name_36,
  t28.logo_mime_type AS logo_mime_type_37,
  t28.logo_size AS logo_size_38,
  t28.logo_dimensions AS logo_dimensions_39,
  t28.shop_id AS shop_id_40,
  t41.id AS id_42,
  t41.email_notification AS email_notification_43,
  t41.future_orders AS future_orders_44,
  t41.display_foxeat AS display_foxeat_45,
  t41.time_slot_blocking_type AS time_slot_blocking_type_46,
  t41.time_slot_max_product AS time_slot_max_product_47,
  t41.time_slot_max_order AS time_slot_max_order_48,
  t41.delivery_max_distance AS delivery_max_distance_49,
  t41.menu_preview AS menu_preview_50,
  t41.close_until AS close_until_51,
  t41.management_fees AS management_fees_52,
  t41.auto_translate AS auto_translate_53,
  t41.pickup_mode AS pickup_mode_54,
  t41.pickup_countdown AS pickup_countdown_55,
  t41.future_orders_max_days AS future_orders_max_days_56,
  t41.future_orders_min_days AS future_orders_min_days_57,
  t41.auto_accept_orders AS auto_accept_orders_58,
  t41.preparation_number_sequence AS preparation_number_sequence_59,
  t41.preparation_number_reset_hour AS preparation_number_reset_hour_60,
  t41.created_at AS created_at_61,
  t41.updated_at AS updated_at_62,
  t41.shop_id AS shop_id_63,
  t41.menu_preview_locale_id AS menu_preview_locale_id_64,
  t0.currency_id AS currency_id_65,
  t0.source_id AS source_id_66,
  t67.id AS id_68,
  t67.customer_identifier AS customer_identifier_69,
  t67.cutlery AS cutlery_70,
  t67.created_at AS created_at_71,
  t67.updated_at AS updated_at_72,
  t67.shop_id AS shop_id_73,
  t74.id AS id_75,
  t74.signup_message AS signup_message_76,
  t74.successful_signup_message AS successful_signup_message_77,
  t74.successful_signup_with_notification_message AS successful_signup_with_notification_message_78,
  t74.ask_for_notifications_message AS ask_for_notifications_message_79,
  t74.integration AS integration_80,
  t74.loyalty_api_token AS loyalty_api_token_81,
  t74.enabled AS enabled_82,
  t74.image_url AS image_url_83,
  t74.created_at AS created_at_84,
  t74.updated_at AS updated_at_85,
  t74.image_name AS image_name_86,
  t74.image_original_name AS image_original_name_87,
  t74.image_mime_type AS image_mime_type_88,
  t74.image_size AS image_size_89,
  t74.image_dimensions AS image_dimensions_90,
  t74.shop_id AS shop_id_91
FROM
  shop t0
  LEFT JOIN printer t28 ON t28.shop_id = t0.id
  LEFT JOIN shop_settings t41 ON t41.shop_id = t0.id
  LEFT JOIN order_setting t67 ON t67.shop_id = t0.id
  LEFT JOIN loyalty t74 ON t74.shop_id = t0.id
WHERE
  t0.franchise_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.qoodos_id AS qoodos_id_2, t0.name AS name_3, t0.licence AS licence_4, t0.device_id AS device_id_5, t0.qoodos_subscription_title AS qoodos_subscription_title_6, t0.qoodos_subscription_message AS qoodos_subscription_message_7, t0.qoodos_display_ask_again AS qoodos_display_ask_again_8, t0.time_zone AS time_zone_9, t0.siret AS siret_10, t0.enabled AS enabled_11, t0.address AS address_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.phone AS phone_15, t0.email AS email_16, t0.deleted AS deleted_17, t0.deleted_at AS deleted_at_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.token AS token_21, t0.logo_name AS logo_name_22, t0.logo_original_name AS logo_original_name_23, t0.logo_mime_type AS logo_mime_type_24, t0.logo_size AS logo_size_25, t0.logo_dimensions AS logo_dimensions_26, t0.franchise_id AS franchise_id_27, t28.id AS id_29, t28.mac AS mac_30, t28.duplication AS duplication_31, t28.starcloud_attempts AS starcloud_attempts_32, t28.created_at AS created_at_33, t28.updated_at AS updated_at_34, t28.logo_name AS logo_name_35, t28.logo_original_name AS logo_original_name_36, t28.logo_mime_type AS logo_mime_type_37, t28.logo_size AS logo_size_38, t28.logo_dimensions AS logo_dimensions_39, t28.shop_id AS shop_id_40, t41.id AS id_42, t41.email_notification AS email_notification_43, t41.future_orders AS future_orders_44, t41.display_foxeat AS display_foxeat_45, t41.time_slot_blocking_type AS time_slot_blocking_type_46, t41.time_slot_max_product AS time_slot_max_product_47, t41.time_slot_max_order AS time_slot_max_order_48, t41.delivery_max_distance AS delivery_max_distance_49, t41.menu_preview AS menu_preview_50, t41.close_until AS close_until_51, t41.management_fees AS management_fees_52, t41.auto_translate AS auto_translate_53, t41.pickup_mode AS pickup_mode_54, t41.pickup_countdown AS pickup_countdown_55, t41.future_orders_max_days AS future_orders_max_days_56, t41.future_orders_min_days AS future_orders_min_days_57, t41.auto_accept_orders AS auto_accept_orders_58, t41.preparation_number_sequence AS preparation_number_sequence_59, t41.preparation_number_reset_hour AS preparation_number_reset_hour_60, t41.created_at AS created_at_61, t41.updated_at AS updated_at_62, t41.shop_id AS shop_id_63, t41.menu_preview_locale_id AS menu_preview_locale_id_64, t0.currency_id AS currency_id_65, t0.source_id AS source_id_66, t67.id AS id_68, t67.customer_identifier AS customer_identifier_69, t67.cutlery AS cutlery_70, t67.created_at AS created_at_71, t67.updated_at AS updated_at_72, t67.shop_id AS shop_id_73, t74.id AS id_75, t74.signup_message AS signup_message_76, t74.successful_signup_message AS successful_signup_message_77, t74.successful_signup_with_notification_message AS successful_signup_with_notification_message_78, t74.ask_for_notifications_message AS ask_for_notifications_message_79, t74.integration AS integration_80, t74.loyalty_api_token AS loyalty_api_token_81, t74.enabled AS enabled_82, t74.image_url AS image_url_83, t74.created_at AS created_at_84, t74.updated_at AS updated_at_85, t74.image_name AS image_name_86, t74.image_original_name AS image_original_name_87, t74.image_mime_type AS image_mime_type_88, t74.image_size AS image_size_89, t74.image_dimensions AS image_dimensions_90, t74.shop_id AS shop_id_91 FROM shop t0 LEFT JOIN printer t28 ON t28.shop_id = t0.id LEFT JOIN shop_settings t41 ON t41.shop_id = t0.id LEFT JOIN order_setting t67 ON t67.shop_id = t0.id LEFT JOIN loyalty t74 ON t74.shop_id = t0.id WHERE t0.franchise_id = 49 AND ((t0.deleted_at IS NULL));

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  franchise
SET
  qoodos_tokens = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE franchise SET qoodos_tokens = 'a:0:{}', updated_at = '2026-03-09 15:00:57' WHERE id = 49;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  locale t0
  INNER JOIN franchise_locale ON t0.id = franchise_locale.locale_id
WHERE
  franchise_locale.franchise_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM locale t0 INNER JOIN franchise_locale ON t0.id = franchise_locale.locale_id WHERE franchise_locale.franchise_id = 49;

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2,
  l0_.created_at AS created_at_3,
  l0_.updated_at AS updated_at_4
FROM
  locale l0_
  LEFT JOIN shop_translation s1_ ON l0_.id = s1_.locale_id
  AND (s1_.shop_id = ?)
WHERE
  s1_.locale_id IS NULL

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4 FROM locale l0_ LEFT JOIN shop_translation s1_ ON l0_.id = s1_.locale_id AND (s1_.shop_id = 81) WHERE s1_.locale_id IS NULL;

SELECT
  l0_.id AS id_0,
  l0_.code AS code_1,
  l0_.name AS name_2,
  l0_.created_at AS created_at_3,
  l0_.updated_at AS updated_at_4
FROM
  locale l0_
  LEFT JOIN shop_translation s1_ ON l0_.id = s1_.locale_id
WHERE
  s1_.shop_id = ?

SELECT l0_.id AS id_0, l0_.code AS code_1, l0_.name AS name_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4 FROM locale l0_ LEFT JOIN shop_translation s1_ ON l0_.id = s1_.locale_id WHERE s1_.shop_id = 81;

"COMMIT"

"COMMIT";

SELECT
  t0.refresh_token AS refresh_token_1,
  t0.username AS username_2,
  t0.valid AS valid_3,
  t0.id AS id_4,
  t0.deleted AS deleted_5,
  t0.deleted_at AS deleted_at_6
FROM
  refresh_tokens t0
WHERE
  t0.refresh_token = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.refresh_token AS refresh_token_1, t0.username AS username_2, t0.valid AS valid_3, t0.id AS id_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6 FROM refresh_tokens t0 WHERE t0.refresh_token = 'd235c0a26faed5d07b7016c01408d2ff2920833b84f897c757ba40c9344f1082d8e892cd729327fc50c1a962e9ffcc0b24ebd9d79ea396ee8037f2a0397fc9d0' AND ((t0.deleted_at IS NULL)) LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO refresh_tokens (
  refresh_token, username, valid, deleted,
  deleted_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO refresh_tokens (refresh_token, username, valid, deleted, deleted_at) VALUES ('d235c0a26faed5d07b7016c01408d2ff2920833b84f897c757ba40c9344f1082d8e892cd729327fc50c1a962e9ffcc0b24ebd9d79ea396ee8037f2a0397fc9d0', 'abatalib@gmail.com', '2026-03-30 15:00:57', 0, NULL);

"COMMIT"

"COMMIT";