Query Metrics
6
Database Queries
6
Different statements
5.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.00 ms (38.33%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.15 ms (21.96%) |
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:
[
2143
]
|
|
0.77 ms (14.67%) |
1 |
SELECT t0.title AS title_1, t0.salutation AS salutation_2, t0.member AS member_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.date_of_birth AS date_of_birth_6, t0.city_of_birth AS city_of_birth_7, t0.comment AS comment_8, t0.is_main_contact AS is_main_contact_9, t0.is_speaker AS is_speaker_10, t0.is_customer AS is_customer_11, t0.street AS street_12, t0.street_number AS street_number_13, t0.postalcode AS postalcode_14, t0.city AS city_15, t0.contact_email AS contact_email_16, t0.web AS web_17, t0.country AS country_18, t0.phone AS phone_19, t0.mobile AS mobile_20, t0.delete_date AS delete_date_21, t0.iban AS iban_22, t0.bic AS bic_23, t0.bank AS bank_24, t0.debit_agree AS debit_agree_25, t0.debit_agree_source AS debit_agree_source_26, t0.debit_agree_date AS debit_agree_date_27, t0.email_invoice AS email_invoice_28, t0.privacy_policy_confirmed AS privacy_policy_confirmed_29, t0.receive_newsletter AS receive_newsletter_30, t0.debit_active AS debit_active_31, t0.is_invoice_recipient AS is_invoice_recipient_32, t0.company AS company_33, t0.id AS id_34, t0.created AS created_35, t0.modified AS modified_36, t0.user_id AS user_id_37, t0.family_member_of_id AS family_member_of_id_38, t39.image AS image_40, t39.id AS id_41, t39.created AS created_42, t39.modified AS modified_43, t39.person_id AS person_id_44 FROM person t0 LEFT JOIN speaker t39 ON t39.person_id = t0.id WHERE t0.id = ?
Parameters:
[
"1274"
]
|
|
0.64 ms (12.21%) |
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:
[
2
]
|
|
0.44 ms (8.44%) |
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 => "Klaus ist angefragt für den 28.4.26 um 9 Uhr" 2 => "trebesch@stadt.aurich.de" 3 => "2026-03-09 14:25:56" 4 => "system_event" 5 => null 6 => null 7 => 1274 8 => null 9 => null ] |
|
0.23 ms (4.39%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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 |
|---|---|
| Menke\UserBundle\Entity\User | No errors. |
| Menke\UserBundle\Entity\Client | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AbstractClient | No errors. |
| App\Entity\OAuth\Client | No errors. |
| App\Entity\OAuth\AccessToken | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\RefreshToken | No errors. |
| App\Entity\OAuth\RefreshToken | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\Speaker | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\CourseOccurrence | No errors. |
| App\Entity\CustomerHistoryEntry | No errors. |
| App\Entity\CustomerDocument | No errors. |
| App\Entity\ManualNewsletter | No errors. |
| App\Entity\InvoiceItemAttendees | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\TagsPerson | No errors. |
| App\Entity\EmailHistoryEntry | No errors. |