Query Metrics
9
Database Queries
7
Different statements
3.11 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.08 ms (34.79%) |
2 |
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:
[
"v25.test.kursimple.de"
]
|
|
0.47 ms (15.08%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.course_nature AS course_nature_6, t0.description AS description_7, t0.searchwords AS searchwords_8, t0.price AS price_9, t0.rabatt AS rabatt_10, t0.tax_rate AS tax_rate_11, t0.number AS number_12, t0.material_cost AS material_cost_13, t0.quantity_material_per_participant_only AS quantity_material_per_participant_only_14, t0.target_age_min AS target_age_min_15, t0.target_age_max AS target_age_max_16, t0.invoice_upper_comment AS invoice_upper_comment_17, t0.invoice_lower_comment AS invoice_lower_comment_18, t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_19, t0.client_id AS client_id_20, t0.subscription_id AS subscription_id_21, t0.category_id AS category_id_22, t0.series_id AS series_id_23, t0.type_id AS type_id_24 FROM course t0 WHERE t0.id = ?
Parameters:
[
"9143"
]
|
|
0.46 ms (14.85%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.published AS published_4, t0.start AS start_5, t0.end AS end_6, t0.slots AS slots_7, t0.code AS code_8, t0.reservation_allowed AS reservation_allowed_9, t0.booked_slots AS booked_slots_10, t0.price AS price_11, t0.tax_rate AS tax_rate_12, t0.material_cost AS material_cost_13, t0.number AS number_14, t0.client_id AS client_id_15, t0.venueId AS venueId_16, t0.venueRoomId AS venueRoomId_17, t0.courseId AS courseId_18 FROM course_occurrence t0 WHERE t0.id = ?
Parameters:
[
"2385"
]
|
|
0.42 ms (13.52%) |
2 |
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:
[
"v25"
]
|
|
0.26 ms (8.23%) |
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:
[
"selcvp5v43u1s2fe4ulcfiist5"
]
|
|
0.25 ms (7.87%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.id = ?
Parameters:
[
5578
]
|
|
0.18 ms (5.66%) |
1 |
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.postalcode AS postalcode_5, t0.city AS city_6, t0.street AS street_7, t0.street_number AS street_number_8, t0.geo_latitude AS geo_latitude_9, t0.geo_longitude AS geo_longitude_10, t0.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters:
[
1194
]
|
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\Course | 1 |
| App\User\Entity\Client | 1 |
| App\Entity\Category | 1 |
| App\Entity\CourseType | 1 |
| App\Entity\CourseOccurrence | 1 |
| App\Entity\Venue | 1 |
| App\Entity\CourseOccurrenceTime | 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\Course | No errors. |
| App\Entity\CourseSubscription | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\CourseSeries | No errors. |
| App\Entity\CourseType | No errors. |
| App\Entity\CourseOccurrence | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\CourseImage | No errors. |
| App\Entity\CourseText | No errors. |
| App\Entity\CourseProvider | No errors. |
| App\Entity\Voucher | No errors. |
| App\Entity\Venue | No errors. |
| App\Entity\VenueRoom | No errors. |
| App\Entity\CourseOccurrenceTime | No errors. |
| App\Entity\CourseOccurrenceSpeaker | No errors. |
| App\Entity\WaitItem | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\OccurrenceProvider | No errors. |
| App\Entity\VenueDocument | No errors. |
| App\Entity\VenueImage | No errors. |
| App\Entity\VenueProvider | No errors. |