https://verwaltung.kunstschule-bederkesa.de/rest/cart/show

Query Metrics

4 Database Queries
4 Different statements
3.15 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.00 ms
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:
[
  "4f14e4f29dde20aaeabb7a476df7933355e645c6adcb6a8bcd0880f1f88099376b1eaa92352615e6"
]
2 0.55 ms
SELECT t0.identifier AS identifier_1, t0.user_identifier AS user_identifier_2, t0.expiry AS expiry_3, t0.client_id AS client_id_4, t0.user_id AS user_id_5 FROM oauth_access_token t0 WHERE t0.identifier = ?
Parameters:
[
  "4f14e4f29dde20aaeabb7a476df7933355e645c6adcb6a8bcd0880f1f88099376b1eaa92352615e6"
]
3 0.34 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.customer_id AS customer_id_4, t0.client_id AS client_id_5, t0.oauth_access_token_identifier AS oauth_access_token_identifier_6 FROM cart t0 WHERE t0.oauth_access_token_identifier = ? LIMIT 1
Parameters:
[
  "4f14e4f29dde20aaeabb7a476df7933355e645c6adcb6a8bcd0880f1f88099376b1eaa92352615e6"
]
4 1.26 ms
SELECT c0_.quantity AS quantity_0, c0_.id AS id_1, c0_.created AS created_2, c0_.modified AS modified_3, c1_.published AS published_4, c1_.start AS start_5, c1_.end AS end_6, c1_.slots AS slots_7, c1_.code AS code_8, c1_.reservation_allowed AS reservation_allowed_9, c1_.booked_slots AS booked_slots_10, c1_.id AS id_11, c1_.created AS created_12, c1_.modified AS modified_13, c2_.title AS title_14, c2_.subtitle AS subtitle_15, c2_.course_nature AS course_nature_16, c2_.description AS description_17, c2_.price AS price_18, c2_.tax_rate AS tax_rate_19, c2_.number AS number_20, c2_.material_cost AS material_cost_21, c2_.target_age_min AS target_age_min_22, c2_.target_age_max AS target_age_max_23, c2_.invoice_upper_comment AS invoice_upper_comment_24, c2_.invoice_lower_comment AS invoice_lower_comment_25, c2_.invoice_lower_comment_debit AS invoice_lower_comment_debit_26, c2_.id AS id_27, c2_.created AS created_28, c2_.modified AS modified_29, c0_.cart_id AS cart_id_30, c0_.course_occurrence_id AS course_occurrence_id_31, c0_.course_occurrence_time_id AS course_occurrence_time_id_32, c0_.course_item_id AS course_item_id_33, c1_.venueId AS venueId_34, c1_.venueRoomId AS venueRoomId_35, c1_.courseId AS courseId_36, c2_.clientId AS clientId_37, c2_.subscription_id AS subscription_id_38, c2_.category_id AS category_id_39, c2_.series_id AS series_id_40, c2_.type_id AS type_id_41 FROM cart_item c0_ LEFT JOIN course_occurrence c1_ ON c0_.course_occurrence_id = c1_.id LEFT JOIN course c2_ ON c1_.courseId = c2_.id LEFT JOIN cart c3_ ON c0_.cart_id = c3_.id WHERE c3_.id = ? AND c0_.course_item_id IS NULL ORDER BY c2_.title ASC LIMIT 100
Parameters:
[
  980
]

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\Cart No errors.
App\Entity\CartItem No errors.
App\Entity\Person No errors.
App\Entity\CourseOccurrence No errors.
App\Entity\CourseData No errors.
App\Entity\CourseField No errors.
App\Entity\ClientConfig No errors.
Menke\UserBundle\Entity\User No errors.
Menke\UserBundle\Entity\Client No errors.
App\Entity\Course No errors.
App\Entity\CourseOccurrenceTime No errors.
App\Entity\Venue No errors.
App\Entity\VenueRoom No errors.
App\Entity\CourseSubscription No errors.
App\Entity\Category No errors.
App\Entity\CourseSeries No errors.
App\Entity\CourseType No errors.