https://verwaltung.museum.miraculumaurich.de/rest/course-occurrence/2359

Query Metrics

14 Database Queries
9 Different statements
5.25 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.84 ms
(34.92%)
6
SELECT t0.number AS number_1, t0.order_date AS order_date_2, t0.customer_title AS customer_title_3, t0.customer_salutation AS customer_salutation_4, t0.customer_member AS customer_member_5, t0.customer_company AS customer_company_6, t0.customer_firstname AS customer_firstname_7, t0.customer_lastname AS customer_lastname_8, t0.customer_street AS customer_street_9, t0.customer_street_number AS customer_street_number_10, t0.customer_postalcode AS customer_postalcode_11, t0.customer_city AS customer_city_12, t0.customer_contact_email AS customer_contact_email_13, t0.customer_country AS customer_country_14, t0.customer_phone AS customer_phone_15, t0.customer_age_group AS customer_age_group_16, t0.status AS status_17, t0.iban AS iban_18, t0.bic AS bic_19, t0.bank AS bank_20, t0.payment_type AS payment_type_21, t0.customer_comment AS customer_comment_22, t0.id AS id_23, t0.created AS created_24, t0.modified AS modified_25, t0.customer_id AS customer_id_26, t0.client_id AS client_id_27, t0.person_id AS person_id_28, t0.invoice_recipient_id AS invoice_recipient_id_29 FROM customer_order t0 WHERE t0.id = ?
Parameters:
[
  2241
]
0.69 ms
(13.17%)
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:
[
  "390ac6f7e4eb9f8fe91e4bb67ac4e54caf119cb27409918ef48ff222ac742ac2c7ddefb7dc99fc40"
]
0.66 ms
(12.62%)
1
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_id = ?
Parameters:
[
  2359
]
0.53 ms
(10.09%)
1
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:
[
  "2359"
]
0.52 ms
(9.88%)
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 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters:
[
  2359
]
0.35 ms
(6.68%)
1
SELECT t0.name AS name_1, t0.number AS number_2, t0.floor AS floor_3, t0.building AS building_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.venueId AS venueId_8 FROM venue_room t0 WHERE t0.venueId = ? ORDER BY t0.name ASC
Parameters:
[
  1
]
0.30 ms
(5.69%)
1
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.occurrenceId = ? ORDER BY t0.start ASC
Parameters:
[
  2359
]
0.20 ms
(3.81%)
1
SELECT t0.title AS title_1, t0.description AS description_2, t0.author AS author_3, t0.order_id AS order_id_4, t0.image AS image_5, t0.id AS id_6, t0.created AS created_7, t0.modified AS modified_8, t0.venue_id AS venue_id_9 FROM venue_image t0 WHERE t0.venue_id = ? ORDER BY t0.order_id ASC
Parameters:
[
  1
]
0.17 ms
(3.16%)
1
SELECT t0.name AS name_1, t0.postalcode AS postalcode_2, t0.city AS city_3, t0.street AS street_4, t0.street_number AS street_number_5, t0.geo_latitude AS geo_latitude_6, t0.geo_longitude AS geo_longitude_7, t0.id AS id_8, t0.created AS created_9, t0.modified AS modified_10, t0.clientId AS clientId_11 FROM venue t0 WHERE t0.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\CourseOccurrence No errors.
App\Entity\Venue No errors.
App\Entity\VenueRoom No errors.
App\Entity\Course No errors.
App\Entity\CourseOccurrenceTime No errors.
App\Entity\Person No errors.
App\Entity\Speaker No errors.
App\Entity\WaitItem No errors.
App\Entity\OrderItem No errors.
App\Entity\Order No errors.
App\Entity\CourseSubscriptionBooking No errors.
App\Entity\OrderItemPerson No errors.
Menke\UserBundle\Entity\Client No errors.
App\Entity\Invoice No errors.
App\Entity\VenueDocument No errors.
App\Entity\Image No errors.
App\Entity\VenueImage No errors.