https://verwaltung.sphinx-lingua.kursimple.de/rest/forgot-password

Query Metrics

16 Database Queries
14 Different statements
42.10 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.52 ms
(22.61%)
1
INSERT INTO email_history_entry (created, recipients, subject, content, attachment, attachment_name, sender, client_id, order_id, invoice_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-07-03 17:19:15"
  2 => "ashrkhan31@gmail.com"
  3 => "Passwort zurücksetzen"
  4 => """
    <p>Hallo\n
    \tB2 kurs Mahnoor  Khan ,</p>\n
    <p>Sie haben einen neues Passwort angefordert. Klicken Sie diesen Link um Ihr Passwort zurückzusetzen:</p>\n
    <p>\n
    \t<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>\n
    </p>
    """
  5 => null
  6 => null
  7 => "forgot_password"
  8 => 1
  9 => null
  10 => null
]
5.83 ms
(13.85%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "Passwort vergessen E-Mail"
  2 => "forgot_password"
  3 => "2025-07-03 17:19:15"
  4 => "email"
  5 => null
  6 => null
  7 => 794
  8 => 2192
  9 => null
]
5.68 ms
(13.49%)
1
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 = ?
Parameters:
[
  1
  "ashrkhan31@gmail.com"
]
5.48 ms
(13.02%)
1
INSERT INTO protocol_entry (created, entity_class, entity_id, action, entry, user_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-07-03 17:19:15"
  2 => "User"
  3 => 430
  4 => "edit"
  5 => "{"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"}]}"
  6 => null
]
4.01 ms
(9.53%)
1
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
Parameters:
[]
3.47 ms
(8.24%)
2
"COMMIT"
Parameters:
[]
2.69 ms
(6.39%)
1
UPDATE user SET password_reset_token = ?, password_requested_at = ? WHERE id = ?
Parameters:
[
  "ANWapkGyUfk_mhFihoZKd_n08Ah36tkk6B3gBF96Hro"
  "2025-07-03 17:19:15"
  430
]
1.25 ms
(2.96%)
1
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 = ?
Parameters:
[
  794
]
0.94 ms
(2.24%)
1
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 = ?
Parameters:
[
  "30a60a354d653abe8aa19809f3523fb1f5bb4c69df71e0899ca6ac8603563a781f6cc0e8716a48b1"
]
0.92 ms
(2.18%)
1
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 = ?
Parameters:
[
  "65f08798b207f"
]
0.83 ms
(1.98%)
1
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 = ?
Parameters:
[
  430
]
0.63 ms
(1.49%)
2
"START TRANSACTION"
Parameters:
[]
0.50 ms
(1.18%)
1
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 = ?
Parameters:
[
  "30a60a354d653abe8aa19809f3523fb1f5bb4c69df71e0899ca6ac8603563a781f6cc0e8716a48b1"
]
0.35 ms
(0.84%)
1
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 = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
League\Bundle\OAuth2ServerBundle\Model\AccessToken No errors.
League\Bundle\OAuth2ServerBundle\Model\AbstractClient No errors.
App\Entity\OAuth\Client No errors.
App\Entity\OAuth\AccessToken No errors.
App\Entity\Person No errors.
App\Entity\ClientConfig No errors.
Menke\UserBundle\Entity\Client No errors.
League\Bundle\OAuth2ServerBundle\Model\RefreshToken No errors.
App\Entity\OAuth\RefreshToken No errors.
Menke\UserBundle\Entity\User No errors.
App\Entity\Order No errors.
App\Entity\CourseOccurrence No errors.
App\Entity\CustomerHistoryEntry No errors.
App\Entity\CustomerDocument No errors.
App\Entity\Speaker No errors.
App\Entity\ManualNewsletter No errors.
App\Entity\InvoiceItemAttendees No errors.
App\Entity\Invoice No errors.
App\Entity\TagsPerson No errors.
App\Entity\ProtocolEntry No errors.
App\Entity\Textblocks No errors.
App\Entity\EmailHistoryEntry No errors.
App\Entity\Attachment No errors.