https://verwaltung.museum.miraculumaurich.de/course/templates/2/proposals/modal/time/8944/edit

Query Metrics

6 Database Queries
6 Different statements
4.90 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 ms
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
]
2 0.53 ms
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
]
3 0.67 ms
SELECT t0.title AS title_1, t0.subtitle AS subtitle_2, t0.course_nature AS course_nature_3, t0.description AS description_4, t0.price AS price_5, t0.tax_rate AS tax_rate_6, t0.number AS number_7, t0.material_cost AS material_cost_8, t0.target_age_min AS target_age_min_9, t0.target_age_max AS target_age_max_10, t0.invoice_upper_comment AS invoice_upper_comment_11, t0.invoice_lower_comment AS invoice_lower_comment_12, t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_13, t0.id AS id_14, t0.created AS created_15, t0.modified AS modified_16, t0.clientId AS clientId_17, t0.subscription_id AS subscription_id_18, t0.category_id AS category_id_19, t0.series_id AS series_id_20, t0.type_id AS type_id_21 FROM course t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
4 0.57 ms
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.note AS note_4, t0.availability AS availability_5, t0.created AS created_6, t0.modified AS modified_7, t0.occurrenceId AS occurrenceId_8 FROM course_occurrence_time t0 WHERE t0.id = ?
Parameters:
[
  "8944"
]
5 2.16 ms
SELECT t0.price AS price_1, t0.tax_rate AS tax_rate_2, t0.quantity AS quantity_3, t0.cancelled_quantity AS cancelled_quantity_4, t0.is_free AS is_free_5, t0.name AS name_6, t0.description AS description_7, t0.status AS status_8, t0.id AS id_9, t0.created AS created_10, t0.modified AS modified_11, t0._order_id AS _order_id_12, t0.course_occurrence_id AS course_occurrence_id_13, t0.course_occurrence_time_id AS course_occurrence_time_id_14, t0.course_subscription_booking_id AS course_subscription_booking_id_15, t0.course_item_id AS course_item_id_16 FROM customer_order_item t0 WHERE t0.course_occurrence_time_id = ?
Parameters:
[
  8944
]
6 0.25 ms
SELECT t0.published AS published_1, t0.start AS start_2, t0.end AS end_3, t0.slots AS slots_4, t0.code AS code_5, t0.reservation_allowed AS reservation_allowed_6, t0.booked_slots AS booked_slots_7, t0.id AS id_8, t0.created AS created_9, t0.modified AS modified_10, t0.venueId AS venueId_11, t0.venueRoomId AS venueRoomId_12, t0.courseId AS courseId_13 FROM course_occurrence t0 WHERE t0.id = ?
Parameters:
[
  2363
]

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\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\CourseOccurrenceTime No errors.
App\Entity\OrderItem No errors.
App\Entity\WaitItem No errors.
App\Entity\Order No errors.
App\Entity\CourseSubscriptionBooking No errors.
App\Entity\OrderItemPerson No errors.
App\Entity\Venue No errors.
App\Entity\VenueRoom No errors.
App\Entity\Person No errors.
App\Entity\Speaker No errors.