Symfony Profiler

SELECT
  t0.identifier AS identifier_1,
  t0.expiry AS expiry_2,
  t0.user_identifier AS user_identifier_3,
  t0.scopes AS scopes_4,
  t0.revoked AS revoked_5,
  t0.client AS client_6
FROM
  oauth2_access_token t0
WHERE
  t0.identifier = ?

SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = '30a60a354d653abe8aa19809f3523fb1f5bb4c69df71e0899ca6ac8603563a781f6cc0e8716a48b1';

SELECT
  t0.name AS name_1,
  t0.secret AS secret_2,
  t0.redirect_uris AS redirect_uris_3,
  t0.grants AS grants_4,
  t0.scopes AS scopes_5,
  t0.active AS active_6,
  t0.allow_plain_text_pkce AS allow_plain_text_pkce_7,
  t0.identifier AS identifier_8,
  t0.activation_url AS activation_url_9,
  t0.confirm_email_url AS confirm_email_url_10,
  t0.reset_password_url AS reset_password_url_11,
  t0.google_client_id AS google_client_id_12,
  t0.application_client_id AS application_client_id_13
FROM
  oauth_client t0
WHERE
  t0.identifier = ?

SELECT t0.name AS name_1, t0.secret AS secret_2, t0.redirect_uris AS redirect_uris_3, t0.grants AS grants_4, t0.scopes AS scopes_5, t0.active AS active_6, t0.allow_plain_text_pkce AS allow_plain_text_pkce_7, t0.identifier AS identifier_8, t0.activation_url AS activation_url_9, t0.confirm_email_url AS confirm_email_url_10, t0.reset_password_url AS reset_password_url_11, t0.google_client_id AS google_client_id_12, t0.application_client_id AS application_client_id_13 FROM oauth_client t0 WHERE t0.identifier = '65f08798b207f';

SELECT
  p0_.title AS title_0,
  p0_.salutation AS salutation_1,
  p0_.member AS member_2,
  p0_.firstname AS firstname_3,
  p0_.lastname AS lastname_4,
  p0_.date_of_birth AS date_of_birth_5,
  p0_.city_of_birth AS city_of_birth_6,
  p0_.comment AS comment_7,
  p0_.is_main_contact AS is_main_contact_8,
  p0_.is_speaker AS is_speaker_9,
  p0_.is_customer AS is_customer_10,
  p0_.street AS street_11,
  p0_.street_number AS street_number_12,
  p0_.postalcode AS postalcode_13,
  p0_.city AS city_14,
  p0_.contact_email AS contact_email_15,
  p0_.web AS web_16,
  p0_.country AS country_17,
  p0_.phone AS phone_18,
  p0_.mobile AS mobile_19,
  p0_.delete_date AS delete_date_20,
  p0_.iban AS iban_21,
  p0_.bic AS bic_22,
  p0_.bank AS bank_23,
  p0_.debit_agree AS debit_agree_24,
  p0_.debit_agree_source AS debit_agree_source_25,
  p0_.debit_agree_date AS debit_agree_date_26,
  p0_.email_invoice AS email_invoice_27,
  p0_.privacy_policy_confirmed AS privacy_policy_confirmed_28,
  p0_.receive_newsletter AS receive_newsletter_29,
  p0_.debit_active AS debit_active_30,
  p0_.is_invoice_recipient AS is_invoice_recipient_31,
  p0_.company AS company_32,
  p0_.id AS id_33,
  p0_.created AS created_34,
  p0_.modified AS modified_35,
  p0_.user_id AS user_id_36,
  p0_.family_member_of_id AS family_member_of_id_37
FROM
  person p0_
  LEFT JOIN user u1_ ON p0_.user_id = u1_.id
WHERE
  u1_.clientId = ?
  AND u1_.username = ?

SELECT p0_.title AS title_0, p0_.salutation AS salutation_1, p0_.member AS member_2, p0_.firstname AS firstname_3, p0_.lastname AS lastname_4, p0_.date_of_birth AS date_of_birth_5, p0_.city_of_birth AS city_of_birth_6, p0_.comment AS comment_7, p0_.is_main_contact AS is_main_contact_8, p0_.is_speaker AS is_speaker_9, p0_.is_customer AS is_customer_10, p0_.street AS street_11, p0_.street_number AS street_number_12, p0_.postalcode AS postalcode_13, p0_.city AS city_14, p0_.contact_email AS contact_email_15, p0_.web AS web_16, p0_.country AS country_17, p0_.phone AS phone_18, p0_.mobile AS mobile_19, p0_.delete_date AS delete_date_20, p0_.iban AS iban_21, p0_.bic AS bic_22, p0_.bank AS bank_23, p0_.debit_agree AS debit_agree_24, p0_.debit_agree_source AS debit_agree_source_25, p0_.debit_agree_date AS debit_agree_date_26, p0_.email_invoice AS email_invoice_27, p0_.privacy_policy_confirmed AS privacy_policy_confirmed_28, p0_.receive_newsletter AS receive_newsletter_29, p0_.debit_active AS debit_active_30, p0_.is_invoice_recipient AS is_invoice_recipient_31, p0_.company AS company_32, p0_.id AS id_33, p0_.created AS created_34, p0_.modified AS modified_35, p0_.user_id AS user_id_36, p0_.family_member_of_id AS family_member_of_id_37 FROM person p0_ LEFT JOIN user u1_ ON p0_.user_id = u1_.id WHERE u1_.clientId = 1 AND u1_.username = 'ashrkhan31@gmail.com';

SELECT
  t0.image AS image_1,
  t0.id AS id_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.person_id AS person_id_5
FROM
  speaker t0
WHERE
  t0.person_id = ?

SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.person_id AS person_id_5 FROM speaker t0 WHERE t0.person_id = 794;

SELECT
  t0.username AS username_1,
  t0.password AS password_2,
  t0.role AS role_3,
  t0.password_reset_token AS password_reset_token_4,
  t0.password_requested_at AS password_requested_at_5,
  t0.password_reset_at AS password_reset_at_6,
  t0.activate_token AS activate_token_7,
  t0.activate_requested_at AS activate_requested_at_8,
  t0.activated_at AS activated_at_9,
  t0.email_confirm_token AS email_confirm_token_10,
  t0.email_confirm_requested_at AS email_confirm_requested_at_11,
  t0.email_confirmed_at AS email_confirmed_at_12,
  t0.facebook_id AS facebook_id_13,
  t0.google_id AS google_id_14,
  t0.id AS id_15,
  t0.created AS created_16,
  t0.modified AS modified_17,
  t0.clientId AS clientId_18,
  t19.name AS name_20,
  t19.street AS street_21,
  t19.street_number AS street_number_22,
  t19.addressAddition AS addressAddition_23,
  t19.postalcode AS postalcode_24,
  t19.city AS city_25,
  t19.country AS country_26,
  t19.email AS email_27,
  t19.web AS web_28,
  t19.phone AS phone_29,
  t19.fax AS fax_30,
  t19.from_email AS from_email_31,
  t19.id AS id_32,
  t19.created AS created_33,
  t19.modified AS modified_34
FROM
  user t0
  LEFT JOIN client t19 ON t0.clientId = t19.id
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.password AS password_2, t0.role AS role_3, t0.password_reset_token AS password_reset_token_4, t0.password_requested_at AS password_requested_at_5, t0.password_reset_at AS password_reset_at_6, t0.activate_token AS activate_token_7, t0.activate_requested_at AS activate_requested_at_8, t0.activated_at AS activated_at_9, t0.email_confirm_token AS email_confirm_token_10, t0.email_confirm_requested_at AS email_confirm_requested_at_11, t0.email_confirmed_at AS email_confirmed_at_12, t0.facebook_id AS facebook_id_13, t0.google_id AS google_id_14, t0.id AS id_15, t0.created AS created_16, t0.modified AS modified_17, t0.clientId AS clientId_18, t19.name AS name_20, t19.street AS street_21, t19.street_number AS street_number_22, t19.addressAddition AS addressAddition_23, t19.postalcode AS postalcode_24, t19.city AS city_25, t19.country AS country_26, t19.email AS email_27, t19.web AS web_28, t19.phone AS phone_29, t19.fax AS fax_30, t19.from_email AS from_email_31, t19.id AS id_32, t19.created AS created_33, t19.modified AS modified_34 FROM user t0 LEFT JOIN client t19 ON t0.clientId = t19.id WHERE t0.id = 430;

SELECT
  t0.name AS name_1,
  t0.secret AS secret_2,
  t0.redirect_uris AS redirect_uris_3,
  t0.grants AS grants_4,
  t0.scopes AS scopes_5,
  t0.active AS active_6,
  t0.allow_plain_text_pkce AS allow_plain_text_pkce_7,
  t0.identifier AS identifier_8,
  t0.activation_url AS activation_url_9,
  t0.confirm_email_url AS confirm_email_url_10,
  t0.reset_password_url AS reset_password_url_11,
  t0.google_client_id AS google_client_id_12,
  t0.application_client_id AS application_client_id_13
FROM
  oauth_client t0
WHERE
  t0.application_client_id = ?

SELECT t0.name AS name_1, t0.secret AS secret_2, t0.redirect_uris AS redirect_uris_3, t0.grants AS grants_4, t0.scopes AS scopes_5, t0.active AS active_6, t0.allow_plain_text_pkce AS allow_plain_text_pkce_7, t0.identifier AS identifier_8, t0.activation_url AS activation_url_9, t0.confirm_email_url AS confirm_email_url_10, t0.reset_password_url AS reset_password_url_11, t0.google_client_id AS google_client_id_12, t0.application_client_id AS application_client_id_13 FROM oauth_client t0 WHERE t0.application_client_id = 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO protocol_entry (
  created, entity_class, entity_id,
  action, entry, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO protocol_entry (created, entity_class, entity_id, action, entry, user_id) VALUES ('2025-07-03 17:19:15', 'User', 430, 'edit', '{\"passwordResetToken\":[null,\"ANWapkGyUfk_mhFihoZKd_n08Ah36tkk6B3gBF96Hro\"],\"passwordRequestedAt\":[{\"date\":\"2025-02-27 17:36:56.000000\",\"timezone_type\":3,\"timezone\":\"UTC\"},{\"date\":\"2025-07-03 17:19:15.124475\",\"timezone_type\":3,\"timezone\":\"UTC\"}]}', NULL);

UPDATE
  user
SET
  password_reset_token = ?,
  password_requested_at = ?
WHERE
  id = ?

UPDATE user SET password_reset_token = 'ANWapkGyUfk_mhFihoZKd_n08Ah36tkk6B3gBF96Hro', password_requested_at = '2025-07-03 17:19:15' WHERE id = 430;

"COMMIT"

"COMMIT";

SELECT
  t0.identifier AS identifier_1,
  t0.user_identifier AS user_identifier_2,
  t0.expiry AS expiry_3,
  t0.client_id AS client_id_4,
  t0.user_id AS user_id_5
FROM
  oauth_access_token t0
WHERE
  t0.identifier = ?

SELECT t0.identifier AS identifier_1, t0.user_identifier AS user_identifier_2, t0.expiry AS expiry_3, t0.client_id AS client_id_4, t0.user_id AS user_id_5 FROM oauth_access_token t0 WHERE t0.identifier = '30a60a354d653abe8aa19809f3523fb1f5bb4c69df71e0899ca6ac8603563a781f6cc0e8716a48b1';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.subject AS subject_3,
  t0.message AS message_4,
  t0.language AS language_5
FROM
  textblocks t0

SELECT t0.id AS id_1, t0.position AS position_2, t0.subject AS subject_3, t0.message AS message_4, t0.language AS language_5 FROM textblocks t0;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO email_history_entry (
  created, recipients, subject, content,
  attachment, attachment_name, sender,
  client_id, order_id, invoice_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO email_history_entry (created, recipients, subject, content, attachment, attachment_name, sender, client_id, order_id, invoice_id) VALUES ('2025-07-03 17:19:15', 'ashrkhan31@gmail.com', 'Passwort zurücksetzen', '<p>Hallo
	B2 kurs Mahnoor  Khan ,</p>
<p>Sie haben einen neues Passwort angefordert. Klicken Sie diesen Link um Ihr Passwort zurückzusetzen:</p>
<p>
	<a href=\"https://sphinx-lingua.kursimple.de/anmeldung?mode=set-password&amp;token=ANWapkGyUfk_mhFihoZKd_n08Ah36tkk6B3gBF96Hro\">https://sphinx-lingua.kursimple.de/anmeldung?mode=set-password&amp;token=ANWapkGyUfk_mhFihoZKd_n08Ah36tkk6B3gBF96Hro</a>
</p>', NULL, NULL, 'forgot_password', 1, NULL, NULL);

INSERT INTO customer_history_entry (
  entry, system_agent, date, type, admin_id,
  set_by_admin, customer_id, email_history_entry_id,
  manual_newsletter_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO customer_history_entry (entry, system_agent, date, type, admin_id, set_by_admin, customer_id, email_history_entry_id, manual_newsletter_id) VALUES ('Passwort vergessen E-Mail', 'forgot_password', '2025-07-03 17:19:15', 'email', NULL, NULL, 794, 2192, NULL);

"COMMIT"

"COMMIT";