Query Metrics
4
Database Queries
4
Different statements
3.15 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.26 ms (40.12%) |
1 |
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
]
|
1.00 ms (31.80%) |
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:
[
"4f14e4f29dde20aaeabb7a476df7933355e645c6adcb6a8bcd0880f1f88099376b1eaa92352615e6"
]
|
0.55 ms (17.37%) |
1 |
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"
]
|
0.34 ms (10.70%) |
1 |
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"
]
|
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. |