Query Metrics
15
Database Queries
7
Different statements
56.70 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
27.64 ms (48.74%) |
5 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.street AS street_5, t0.street_number AS street_number_6, t0.addressAddition AS addressAddition_7, t0.postalcode AS postalcode_8, t0.city AS city_9, t0.country AS country_10, t0.email AS email_11, t0.web AS web_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.from_email AS from_email_15, t0.logo_path AS logo_path_16, t0.subdomain AS subdomain_17, t0.custom_domain AS custom_domain_18, t0.keycloak_client_id AS keycloak_client_id_19, t0.keycloakGroupId AS keycloakGroupId_20 FROM client t0 WHERE t0.custom_domain = ? LIMIT 1
Parameters:
[
"www.miraculumaurich.de"
]
|
|
13.24 ms (23.35%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.session_id AS session_id_4, t0.customer_id AS customer_id_5, t0.client_id AS client_id_6 FROM cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters:
[
"1h5grne83vgt7omr2lblmkpo9e"
]
|
|
12.74 ms (22.46%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.salutation AS salutation_5, t0.member AS member_6, t0.allow_member_vouchers AS allow_member_vouchers_7, t0.rabatt AS rabatt_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.date_of_birth AS date_of_birth_11, t0.city_of_birth AS city_of_birth_12, t0.comment AS comment_13, t0.is_main_contact AS is_main_contact_14, t0.is_speaker AS is_speaker_15, t0.is_customer AS is_customer_16, t0.active AS active_17, t0.street AS street_18, t0.street_number AS street_number_19, t0.postalcode AS postalcode_20, t0.city AS city_21, t0.contact_email AS contact_email_22, t0.web AS web_23, t0.country AS country_24, t0.phone AS phone_25, t0.mobile AS mobile_26, t0.delete_date AS delete_date_27, t0.iban AS iban_28, t0.bic AS bic_29, t0.bank AS bank_30, t0.debit_agree AS debit_agree_31, t0.debit_agree_source AS debit_agree_source_32, t0.debit_agree_date AS debit_agree_date_33, t0.email_invoice AS email_invoice_34, t0.privacy_policy_confirmed AS privacy_policy_confirmed_35, t0.receive_newsletter AS receive_newsletter_36, t0.debit_active AS debit_active_37, t0.is_invoice_recipient AS is_invoice_recipient_38, t0.company AS company_39, t0.user_id AS user_id_40, t0.client_id AS client_id_41, t0.family_member_of_id AS family_member_of_id_42, t43.id AS id_44, t43.created AS created_45, t43.modified AS modified_46, t43.image AS image_47, t43.client_id AS client_id_48, t43.person_id AS person_id_49 FROM person t0 LEFT JOIN speaker t43 ON t43.person_id = t0.id WHERE t0.id = ?
Parameters:
[
111259
]
|
|
1.78 ms (3.13%) |
5 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.street AS street_5, t0.street_number AS street_number_6, t0.addressAddition AS addressAddition_7, t0.postalcode AS postalcode_8, t0.city AS city_9, t0.country AS country_10, t0.email AS email_11, t0.web AS web_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.from_email AS from_email_15, t0.logo_path AS logo_path_16, t0.subdomain AS subdomain_17, t0.custom_domain AS custom_domain_18, t0.keycloak_client_id AS keycloak_client_id_19, t0.keycloakGroupId AS keycloakGroupId_20 FROM client t0 WHERE t0.subdomain = ? LIMIT 1
Parameters:
[
"www"
]
|
|
0.55 ms (0.97%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.content AS content_4, t0.order_id AS order_id_5, t0.title AS title_6, t0.short_content AS short_content_7, t0.client_id AS client_id_8, t0.speaker_id AS speaker_id_9 FROM speaker_text t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters:
[
9426
]
|
|
0.51 ms (0.90%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.image AS image_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 WHERE t0.id = ?
Parameters:
[
"9426"
]
|
|
0.24 ms (0.43%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.order_id AS order_id_4, t0.image AS image_5, t0.client_id AS client_id_6, t0.speaker_id AS speaker_id_7 FROM speaker_image t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters:
[
9426
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Speaker | 1 |
| App\User\Entity\Client | 1 |
| App\Entity\Person | 1 |
| App\Entity\SpeakerText | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Commons\Entity\GenericEntity | No errors. |
| App\User\Entity\Client | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Person | No errors. |
| App\Entity\Speaker | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\SpeakerImage | No errors. |
| App\Entity\SpeakerText | No errors. |
| App\Entity\SpeakerProvider | No errors. |
| App\User\Entity\User | No errors. |
| App\Entity\Order | 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. |