https://verwaltung.plattform-handwerk.kursimple.de/rest/course/165?showFields=1

Method
GET
HTTP Status
200
IP
92.205.190.77
Profiled on
Token
4d3473

Query Metrics

195 Database Queries
20 Different statements
100.16 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.02 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: 
[
  "3cd930b6d9e639cfe0337ee329834af18927619e8c9f50d3ef44f60438a2fe937d3ba289b2fc8c9a"
]
View formatted query    View runnable query    Explain query
2 0.71 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.identifier = ?
Parameters: 
[
  "65c6366c620f9"
]
View formatted query    View runnable query    Explain query
3 0.43 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.searchwords AS searchwords_5, t0.price AS price_6, t0.rabatt AS rabatt_7, t0.tax_rate AS tax_rate_8, t0.number AS number_9, t0.material_cost AS material_cost_10, t0.target_age_min AS target_age_min_11, t0.target_age_max AS target_age_max_12, t0.invoice_upper_comment AS invoice_upper_comment_13, t0.invoice_lower_comment AS invoice_lower_comment_14, t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_15, t0.id AS id_16, t0.created AS created_17, t0.modified AS modified_18, t0.client_id AS client_id_19, t0.subscription_id AS subscription_id_20, t0.category_id AS category_id_21, t0.series_id AS series_id_22, t0.type_id AS type_id_23 FROM course t0 WHERE t0.id = ? AND t0.client_id = ? LIMIT 1
Parameters: 
[
  165
  1
]
View formatted query    View runnable query    Explain query
4 0.74 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.price AS price_8, t0.tax_rate AS tax_rate_9, t0.material_cost AS material_cost_10, t0.number AS number_11, t0.id AS id_12, t0.created AS created_13, t0.modified AS modified_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.courseId = ?
Parameters: 
[
  165
]
View formatted query    View runnable query    Explain query
5 0.75 ms 
SELECT c0_.id AS id_0, c0_.name AS name_1, c1_.value_text AS value_text_2 FROM course_field c0_ LEFT JOIN course_data c1_ ON (c1_.field_id = c0_.id) WHERE c1_.course_id = ? AND c0_.certificate = 0 AND c1_.value_text IS NOT NULL
Parameters: 
[
  165
]
View formatted query    View runnable query    Explain query
6 0.74 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  309
]
View formatted query    View runnable query    Explain query
7 0.90 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1799
]
View formatted query    View runnable query    Explain query
8 1.05 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1800
]
View formatted query    View runnable query    Explain query
9 0.27 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1801
]
View formatted query    View runnable query    Explain query
10 0.27 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1802
]
View formatted query    View runnable query    Explain query
11 0.28 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1826
]
View formatted query    View runnable query    Explain query
12 0.37 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1827
]
View formatted query    View runnable query    Explain query
13 0.31 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1832
]
View formatted query    View runnable query    Explain query
14 0.28 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1831
]
View formatted query    View runnable query    Explain query
15 0.34 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1830
]
View formatted query    View runnable query    Explain query
16 0.28 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1829
]
View formatted query    View runnable query    Explain query
17 0.32 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1828
]
View formatted query    View runnable query    Explain query
18 0.34 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1809
]
View formatted query    View runnable query    Explain query
19 0.39 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1833
]
View formatted query    View runnable query    Explain query
20 0.25 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1822
]
View formatted query    View runnable query    Explain query
21 0.27 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1842
]
View formatted query    View runnable query    Explain query
22 0.23 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1843
]
View formatted query    View runnable query    Explain query
23 0.38 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1811
]
View formatted query    View runnable query    Explain query
24 0.28 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1954
]
View formatted query    View runnable query    Explain query
25 0.63 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1913
]
View formatted query    View runnable query    Explain query
26 0.24 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2589
]
View formatted query    View runnable query    Explain query
27 0.91 ms 
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.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
28 0.71 ms 
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.client_id AS client_id_8, t0.venueId AS venueId_9 FROM venue_room t0 WHERE t0.venueId = ? ORDER BY t0.name ASC
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
29 0.41 ms 
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.client_id AS client_id_9, t0.venue_id AS venue_id_10 FROM venue_image t0 WHERE t0.venue_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
30 0.39 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  309
]
View formatted query    View runnable query    Explain query
31 0.35 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  309
]
View formatted query    View runnable query    Explain query
32 0.78 ms 
SELECT t0.title AS title_1, t0.salutation AS salutation_2, t0.member AS member_3, t0.rabatt AS rabatt_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.date_of_birth AS date_of_birth_7, t0.city_of_birth AS city_of_birth_8, t0.comment AS comment_9, t0.is_main_contact AS is_main_contact_10, t0.is_speaker AS is_speaker_11, t0.is_customer AS is_customer_12, t0.active AS active_13, t0.street AS street_14, t0.street_number AS street_number_15, t0.postalcode AS postalcode_16, t0.city AS city_17, t0.contact_email AS contact_email_18, t0.web AS web_19, t0.country AS country_20, t0.phone AS phone_21, t0.mobile AS mobile_22, t0.delete_date AS delete_date_23, t0.iban AS iban_24, t0.bic AS bic_25, t0.bank AS bank_26, t0.debit_agree AS debit_agree_27, t0.debit_agree_source AS debit_agree_source_28, t0.debit_agree_date AS debit_agree_date_29, t0.email_invoice AS email_invoice_30, t0.privacy_policy_confirmed AS privacy_policy_confirmed_31, t0.receive_newsletter AS receive_newsletter_32, t0.debit_active AS debit_active_33, t0.is_invoice_recipient AS is_invoice_recipient_34, t0.company AS company_35, t0.id AS id_36, t0.created AS created_37, t0.modified AS modified_38, t0.user_id AS user_id_39, t0.client_id AS client_id_40, t0.family_member_of_id AS family_member_of_id_41, t42.image AS image_43, t42.id AS id_44, t42.created AS created_45, t42.modified AS modified_46, t42.client_id AS client_id_47, t42.person_id AS person_id_48 FROM person t0 LEFT JOIN speaker t42 ON t42.person_id = t0.id WHERE t0.id = ?
Parameters: 
[
  2147
]
View formatted query    View runnable query    Explain query
33 0.64 ms 
SELECT t0.order_id AS order_id_1, t0.image AS image_2, t0.id AS id_3, t0.created AS created_4, t0.modified AS modified_5, t0.client_id AS client_id_6, t0.speaker_id AS speaker_id_7 FROM speaker_image t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query
34 0.25 ms 
SELECT t0.content AS content_1, t0.order_id AS order_id_2, t0.title AS title_3, t0.short_content AS short_content_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.speaker_id AS speaker_id_9 FROM speaker_text t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  32
]
View formatted query    View runnable query    Explain query
35 0.41 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  316
]
View formatted query    View runnable query    Explain query
36 0.31 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1870
]
View formatted query    View runnable query    Explain query
37 0.34 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1804
]
View formatted query    View runnable query    Explain query
38 0.22 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1806
]
View formatted query    View runnable query    Explain query
39 0.23 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1807
]
View formatted query    View runnable query    Explain query
40 0.23 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1808
]
View formatted query    View runnable query    Explain query
41 0.20 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1813
]
View formatted query    View runnable query    Explain query
42 0.28 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1814
]
View formatted query    View runnable query    Explain query
43 0.21 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1816
]
View formatted query    View runnable query    Explain query
44 0.17 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1877
]
View formatted query    View runnable query    Explain query
45 0.32 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1889
]
View formatted query    View runnable query    Explain query
46 0.23 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1906
]
View formatted query    View runnable query    Explain query
47 0.51 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  316
]
View formatted query    View runnable query    Explain query
48 0.43 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  316
]
View formatted query    View runnable query    Explain query
49 0.58 ms 
SELECT t0.title AS title_1, t0.salutation AS salutation_2, t0.member AS member_3, t0.rabatt AS rabatt_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.date_of_birth AS date_of_birth_7, t0.city_of_birth AS city_of_birth_8, t0.comment AS comment_9, t0.is_main_contact AS is_main_contact_10, t0.is_speaker AS is_speaker_11, t0.is_customer AS is_customer_12, t0.active AS active_13, t0.street AS street_14, t0.street_number AS street_number_15, t0.postalcode AS postalcode_16, t0.city AS city_17, t0.contact_email AS contact_email_18, t0.web AS web_19, t0.country AS country_20, t0.phone AS phone_21, t0.mobile AS mobile_22, t0.delete_date AS delete_date_23, t0.iban AS iban_24, t0.bic AS bic_25, t0.bank AS bank_26, t0.debit_agree AS debit_agree_27, t0.debit_agree_source AS debit_agree_source_28, t0.debit_agree_date AS debit_agree_date_29, t0.email_invoice AS email_invoice_30, t0.privacy_policy_confirmed AS privacy_policy_confirmed_31, t0.receive_newsletter AS receive_newsletter_32, t0.debit_active AS debit_active_33, t0.is_invoice_recipient AS is_invoice_recipient_34, t0.company AS company_35, t0.id AS id_36, t0.created AS created_37, t0.modified AS modified_38, t0.user_id AS user_id_39, t0.client_id AS client_id_40, t0.family_member_of_id AS family_member_of_id_41, t42.image AS image_43, t42.id AS id_44, t42.created AS created_45, t42.modified AS modified_46, t42.client_id AS client_id_47, t42.person_id AS person_id_48 FROM person t0 LEFT JOIN speaker t42 ON t42.person_id = t0.id WHERE t0.id = ?
Parameters: 
[
  177
]
View formatted query    View runnable query    Explain query
50 0.24 ms 
SELECT t0.order_id AS order_id_1, t0.image AS image_2, t0.id AS id_3, t0.created AS created_4, t0.modified AS modified_5, t0.client_id AS client_id_6, t0.speaker_id AS speaker_id_7 FROM speaker_image t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
51 0.27 ms 
SELECT t0.content AS content_1, t0.order_id AS order_id_2, t0.title AS title_3, t0.short_content AS short_content_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.speaker_id AS speaker_id_9 FROM speaker_text t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query
52 0.64 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  317
]
View formatted query    View runnable query    Explain query
53 0.44 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1818
]
View formatted query    View runnable query    Explain query
54 0.39 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1821
]
View formatted query    View runnable query    Explain query
55 0.25 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1823
]
View formatted query    View runnable query    Explain query
56 0.43 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1824
]
View formatted query    View runnable query    Explain query
57 0.47 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1836
]
View formatted query    View runnable query    Explain query
58 0.33 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1839
]
View formatted query    View runnable query    Explain query
59 0.36 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1846
]
View formatted query    View runnable query    Explain query
60 0.22 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1872
]
View formatted query    View runnable query    Explain query
61 0.24 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1867
]
View formatted query    View runnable query    Explain query
62 0.40 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1876
]
View formatted query    View runnable query    Explain query
63 0.22 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1881
]
View formatted query    View runnable query    Explain query
64 0.61 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1891
]
View formatted query    View runnable query    Explain query
65 0.49 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2332
]
View formatted query    View runnable query    Explain query
66 0.23 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2734
]
View formatted query    View runnable query    Explain query
67 0.42 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2742
]
View formatted query    View runnable query    Explain query
68 0.34 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  317
]
View formatted query    View runnable query    Explain query
69 1.39 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  317
]
View formatted query    View runnable query    Explain query
70 1.12 ms 
SELECT t0.title AS title_1, t0.salutation AS salutation_2, t0.member AS member_3, t0.rabatt AS rabatt_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.date_of_birth AS date_of_birth_7, t0.city_of_birth AS city_of_birth_8, t0.comment AS comment_9, t0.is_main_contact AS is_main_contact_10, t0.is_speaker AS is_speaker_11, t0.is_customer AS is_customer_12, t0.active AS active_13, t0.street AS street_14, t0.street_number AS street_number_15, t0.postalcode AS postalcode_16, t0.city AS city_17, t0.contact_email AS contact_email_18, t0.web AS web_19, t0.country AS country_20, t0.phone AS phone_21, t0.mobile AS mobile_22, t0.delete_date AS delete_date_23, t0.iban AS iban_24, t0.bic AS bic_25, t0.bank AS bank_26, t0.debit_agree AS debit_agree_27, t0.debit_agree_source AS debit_agree_source_28, t0.debit_agree_date AS debit_agree_date_29, t0.email_invoice AS email_invoice_30, t0.privacy_policy_confirmed AS privacy_policy_confirmed_31, t0.receive_newsletter AS receive_newsletter_32, t0.debit_active AS debit_active_33, t0.is_invoice_recipient AS is_invoice_recipient_34, t0.company AS company_35, t0.id AS id_36, t0.created AS created_37, t0.modified AS modified_38, t0.user_id AS user_id_39, t0.client_id AS client_id_40, t0.family_member_of_id AS family_member_of_id_41, t42.image AS image_43, t42.id AS id_44, t42.created AS created_45, t42.modified AS modified_46, t42.client_id AS client_id_47, t42.person_id AS person_id_48 FROM person t0 LEFT JOIN speaker t42 ON t42.person_id = t0.id WHERE t0.id = ?
Parameters: 
[
  2215
]
View formatted query    View runnable query    Explain query
71 0.42 ms 
SELECT t0.order_id AS order_id_1, t0.image AS image_2, t0.id AS id_3, t0.created AS created_4, t0.modified AS modified_5, t0.client_id AS client_id_6, t0.speaker_id AS speaker_id_7 FROM speaker_image t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  36
]
View formatted query    View runnable query    Explain query
72 0.41 ms 
SELECT t0.content AS content_1, t0.order_id AS order_id_2, t0.title AS title_3, t0.short_content AS short_content_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.speaker_id AS speaker_id_9 FROM speaker_text t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  36
]
View formatted query    View runnable query    Explain query
73 1.03 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  318
]
View formatted query    View runnable query    Explain query
74 0.44 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1817
]
View formatted query    View runnable query    Explain query
75 0.47 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1879
]
View formatted query    View runnable query    Explain query
76 0.29 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1886
]
View formatted query    View runnable query    Explain query
77 0.43 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1890
]
View formatted query    View runnable query    Explain query
78 0.22 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1894
]
View formatted query    View runnable query    Explain query
79 0.28 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1895
]
View formatted query    View runnable query    Explain query
80 0.45 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1896
]
View formatted query    View runnable query    Explain query
81 0.36 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1897
]
View formatted query    View runnable query    Explain query
82 0.22 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1900
]
View formatted query    View runnable query    Explain query
83 0.26 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1901
]
View formatted query    View runnable query    Explain query
84 0.24 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3107
]
View formatted query    View runnable query    Explain query
85 0.65 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  318
]
View formatted query    View runnable query    Explain query
86 0.31 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  318
]
View formatted query    View runnable query    Explain query
87 1.55 ms 
SELECT t0.title AS title_1, t0.salutation AS salutation_2, t0.member AS member_3, t0.rabatt AS rabatt_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.date_of_birth AS date_of_birth_7, t0.city_of_birth AS city_of_birth_8, t0.comment AS comment_9, t0.is_main_contact AS is_main_contact_10, t0.is_speaker AS is_speaker_11, t0.is_customer AS is_customer_12, t0.active AS active_13, t0.street AS street_14, t0.street_number AS street_number_15, t0.postalcode AS postalcode_16, t0.city AS city_17, t0.contact_email AS contact_email_18, t0.web AS web_19, t0.country AS country_20, t0.phone AS phone_21, t0.mobile AS mobile_22, t0.delete_date AS delete_date_23, t0.iban AS iban_24, t0.bic AS bic_25, t0.bank AS bank_26, t0.debit_agree AS debit_agree_27, t0.debit_agree_source AS debit_agree_source_28, t0.debit_agree_date AS debit_agree_date_29, t0.email_invoice AS email_invoice_30, t0.privacy_policy_confirmed AS privacy_policy_confirmed_31, t0.receive_newsletter AS receive_newsletter_32, t0.debit_active AS debit_active_33, t0.is_invoice_recipient AS is_invoice_recipient_34, t0.company AS company_35, t0.id AS id_36, t0.created AS created_37, t0.modified AS modified_38, t0.user_id AS user_id_39, t0.client_id AS client_id_40, t0.family_member_of_id AS family_member_of_id_41, t42.image AS image_43, t42.id AS id_44, t42.created AS created_45, t42.modified AS modified_46, t42.client_id AS client_id_47, t42.person_id AS person_id_48 FROM person t0 LEFT JOIN speaker t42 ON t42.person_id = t0.id WHERE t0.id = ?
Parameters: 
[
  173
]
View formatted query    View runnable query    Explain query
88 0.68 ms 
SELECT t0.order_id AS order_id_1, t0.image AS image_2, t0.id AS id_3, t0.created AS created_4, t0.modified AS modified_5, t0.client_id AS client_id_6, t0.speaker_id AS speaker_id_7 FROM speaker_image t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
89 0.52 ms 
SELECT t0.content AS content_1, t0.order_id AS order_id_2, t0.title AS title_3, t0.short_content AS short_content_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.speaker_id AS speaker_id_9 FROM speaker_text t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query
90 0.95 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  319
]
View formatted query    View runnable query    Explain query
91 0.51 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1805
]
View formatted query    View runnable query    Explain query
92 0.27 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1880
]
View formatted query    View runnable query    Explain query
93 0.43 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1887
]
View formatted query    View runnable query    Explain query
94 0.42 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1912
]
View formatted query    View runnable query    Explain query
95 0.38 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1942
]
View formatted query    View runnable query    Explain query
96 0.46 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2029
]
View formatted query    View runnable query    Explain query
97 0.39 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2402
]
View formatted query    View runnable query    Explain query
98 0.34 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2419
]
View formatted query    View runnable query    Explain query
99 0.29 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3087
]
View formatted query    View runnable query    Explain query
100 0.43 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  319
]
View formatted query    View runnable query    Explain query
101 0.46 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  319
]
View formatted query    View runnable query    Explain query
102 0.63 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  320
]
View formatted query    View runnable query    Explain query
103 0.42 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1878
]
View formatted query    View runnable query    Explain query
104 0.36 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1899
]
View formatted query    View runnable query    Explain query
105 0.45 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1903
]
View formatted query    View runnable query    Explain query
106 0.29 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1904
]
View formatted query    View runnable query    Explain query
107 0.62 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1905
]
View formatted query    View runnable query    Explain query
108 0.43 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1909
]
View formatted query    View runnable query    Explain query
109 0.41 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1975
]
View formatted query    View runnable query    Explain query
110 0.25 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2020
]
View formatted query    View runnable query    Explain query
111 0.43 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2487
]
View formatted query    View runnable query    Explain query
112 0.75 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2488
]
View formatted query    View runnable query    Explain query
113 0.45 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2497
]
View formatted query    View runnable query    Explain query
114 0.68 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2619
]
View formatted query    View runnable query    Explain query
115 0.89 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2620
]
View formatted query    View runnable query    Explain query
116 0.26 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  2621
]
View formatted query    View runnable query    Explain query
117 0.33 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3052
]
View formatted query    View runnable query    Explain query
118 0.34 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3094
]
View formatted query    View runnable query    Explain query
119 0.40 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3277
]
View formatted query    View runnable query    Explain query
120 0.39 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3565
]
View formatted query    View runnable query    Explain query
121 0.53 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  320
]
View formatted query    View runnable query    Explain query
122 0.44 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  320
]
View formatted query    View runnable query    Explain query
123 0.81 ms 
SELECT t0.title AS title_1, t0.salutation AS salutation_2, t0.member AS member_3, t0.rabatt AS rabatt_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.date_of_birth AS date_of_birth_7, t0.city_of_birth AS city_of_birth_8, t0.comment AS comment_9, t0.is_main_contact AS is_main_contact_10, t0.is_speaker AS is_speaker_11, t0.is_customer AS is_customer_12, t0.active AS active_13, t0.street AS street_14, t0.street_number AS street_number_15, t0.postalcode AS postalcode_16, t0.city AS city_17, t0.contact_email AS contact_email_18, t0.web AS web_19, t0.country AS country_20, t0.phone AS phone_21, t0.mobile AS mobile_22, t0.delete_date AS delete_date_23, t0.iban AS iban_24, t0.bic AS bic_25, t0.bank AS bank_26, t0.debit_agree AS debit_agree_27, t0.debit_agree_source AS debit_agree_source_28, t0.debit_agree_date AS debit_agree_date_29, t0.email_invoice AS email_invoice_30, t0.privacy_policy_confirmed AS privacy_policy_confirmed_31, t0.receive_newsletter AS receive_newsletter_32, t0.debit_active AS debit_active_33, t0.is_invoice_recipient AS is_invoice_recipient_34, t0.company AS company_35, t0.id AS id_36, t0.created AS created_37, t0.modified AS modified_38, t0.user_id AS user_id_39, t0.client_id AS client_id_40, t0.family_member_of_id AS family_member_of_id_41, t42.image AS image_43, t42.id AS id_44, t42.created AS created_45, t42.modified AS modified_46, t42.client_id AS client_id_47, t42.person_id AS person_id_48 FROM person t0 LEFT JOIN speaker t42 ON t42.person_id = t0.id WHERE t0.id = ?
Parameters: 
[
  2216
]
View formatted query    View runnable query    Explain query
124 0.41 ms 
SELECT t0.order_id AS order_id_1, t0.image AS image_2, t0.id AS id_3, t0.created AS created_4, t0.modified AS modified_5, t0.client_id AS client_id_6, t0.speaker_id AS speaker_id_7 FROM speaker_image t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  37
]
View formatted query    View runnable query    Explain query
125 0.38 ms 
SELECT t0.content AS content_1, t0.order_id AS order_id_2, t0.title AS title_3, t0.short_content AS short_content_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.speaker_id AS speaker_id_9 FROM speaker_text t0 WHERE t0.speaker_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  37
]
View formatted query    View runnable query    Explain query
126 0.46 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  403
]
View formatted query    View runnable query    Explain query
127 0.45 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3093
]
View formatted query    View runnable query    Explain query
128 0.41 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3099
]
View formatted query    View runnable query    Explain query
129 0.23 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3113
]
View formatted query    View runnable query    Explain query
130 0.26 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3116
]
View formatted query    View runnable query    Explain query
131 0.61 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  403
]
View formatted query    View runnable query    Explain query
132 0.49 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  403
]
View formatted query    View runnable query    Explain query
133 0.51 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  404
]
View formatted query    View runnable query    Explain query
134 0.40 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3100
]
View formatted query    View runnable query    Explain query
135 0.59 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  404
]
View formatted query    View runnable query    Explain query
136 0.46 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  404
]
View formatted query    View runnable query    Explain query
137 0.59 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  405
]
View formatted query    View runnable query    Explain query
138 0.53 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  1885
]
View formatted query    View runnable query    Explain query
139 0.31 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3074
]
View formatted query    View runnable query    Explain query
140 0.28 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3075
]
View formatted query    View runnable query    Explain query
141 0.25 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3080
]
View formatted query    View runnable query    Explain query
142 0.30 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3085
]
View formatted query    View runnable query    Explain query
143 0.24 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3091
]
View formatted query    View runnable query    Explain query
144 0.60 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3095
]
View formatted query    View runnable query    Explain query
145 0.49 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3096
]
View formatted query    View runnable query    Explain query
146 0.52 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3097
]
View formatted query    View runnable query    Explain query
147 2.97 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3163
]
View formatted query    View runnable query    Explain query
148 0.65 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3417
]
View formatted query    View runnable query    Explain query
149 0.75 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3721
]
View formatted query    View runnable query    Explain query
150 0.81 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  405
]
View formatted query    View runnable query    Explain query
151 0.97 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  405
]
View formatted query    View runnable query    Explain query
152 0.96 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  406
]
View formatted query    View runnable query    Explain query
153 1.41 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3077
]
View formatted query    View runnable query    Explain query
154 0.44 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3105
]
View formatted query    View runnable query    Explain query
155 0.51 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3128
]
View formatted query    View runnable query    Explain query
156 1.06 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3153
]
View formatted query    View runnable query    Explain query
157 0.35 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3172
]
View formatted query    View runnable query    Explain query
158 0.34 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3218
]
View formatted query    View runnable query    Explain query
159 0.52 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3219
]
View formatted query    View runnable query    Explain query
160 0.53 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3270
]
View formatted query    View runnable query    Explain query
161 1.06 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3323
]
View formatted query    View runnable query    Explain query
162 0.42 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3520
]
View formatted query    View runnable query    Explain query
163 0.37 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3475
]
View formatted query    View runnable query    Explain query
164 0.77 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3840
]
View formatted query    View runnable query    Explain query
165 0.46 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  406
]
View formatted query    View runnable query    Explain query
166 0.65 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  406
]
View formatted query    View runnable query    Explain query
167 0.34 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  407
]
View formatted query    View runnable query    Explain query
168 0.62 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3088
]
View formatted query    View runnable query    Explain query
169 0.51 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3089
]
View formatted query    View runnable query    Explain query
170 0.62 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3103
]
View formatted query    View runnable query    Explain query
171 0.42 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3295
]
View formatted query    View runnable query    Explain query
172 0.39 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3455
]
View formatted query    View runnable query    Explain query
173 0.45 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3466
]
View formatted query    View runnable query    Explain query
174 0.40 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3573
]
View formatted query    View runnable query    Explain query
175 0.57 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3842
]
View formatted query    View runnable query    Explain query
176 0.62 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  407
]
View formatted query    View runnable query    Explain query
177 0.41 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  407
]
View formatted query    View runnable query    Explain query
178 0.59 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  408
]
View formatted query    View runnable query    Explain query
179 0.58 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3084
]
View formatted query    View runnable query    Explain query
180 0.45 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3108
]
View formatted query    View runnable query    Explain query
181 0.60 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3109
]
View formatted query    View runnable query    Explain query
182 0.46 ms 
SELECT t0.id AS id_1, t0.number AS number_2, t0.order_date AS order_date_3, t0.customer_title AS customer_title_4, t0.customer_salutation AS customer_salutation_5, t0.customer_member AS customer_member_6, t0.customer_company AS customer_company_7, t0.customer_firstname AS customer_firstname_8, t0.customer_lastname AS customer_lastname_9, t0.customer_street AS customer_street_10, t0.customer_street_number AS customer_street_number_11, t0.customer_postalcode AS customer_postalcode_12, t0.customer_city AS customer_city_13, t0.customer_contact_email AS customer_contact_email_14, t0.customer_country AS customer_country_15, t0.customer_phone AS customer_phone_16, t0.customer_age_group AS customer_age_group_17, t0.status AS status_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.payment_type AS payment_type_22, t0.customer_comment AS customer_comment_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: 
[
  3726
]
View formatted query    View runnable query    Explain query
183 1.05 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  408
]
View formatted query    View runnable query    Explain query
184 0.75 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  408
]
View formatted query    View runnable query    Explain query
185 0.75 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.client_id AS client_id_12, t0._order_id AS _order_id_13, t0.course_occurrence_id AS course_occurrence_id_14, t0.course_occurrence_time_id AS course_occurrence_time_id_15, t0.course_subscription_booking_id AS course_subscription_booking_id_16, t0.course_item_id AS course_item_id_17 FROM customer_order_item t0 WHERE t0.course_occurrence_id = ?
Parameters: 
[
  452
]
View formatted query    View runnable query    Explain query
186 0.57 ms 
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.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
187 0.87 ms 
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.client_id AS client_id_8, t0.venueId AS venueId_9 FROM venue_room t0 WHERE t0.venueId = ? ORDER BY t0.name ASC
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
188 0.56 ms 
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.client_id AS client_id_9, t0.venue_id AS venue_id_10 FROM venue_image t0 WHERE t0.venue_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  29
]
View formatted query    View runnable query    Explain query
189 2.07 ms 
SELECT t0.start AS start_1, t0.end AS end_2, t0.note AS note_3, t0.availability AS availability_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8, t0.occurrenceId AS occurrenceId_9 FROM course_occurrence_time t0 WHERE t0.occurrenceId = ? ORDER BY t0.start ASC
Parameters: 
[
  452
]
View formatted query    View runnable query    Explain query
190 0.76 ms 
SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5, t0.person_id AS person_id_6 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = ?
Parameters: 
[
  452
]
View formatted query    View runnable query    Explain query
191 0.79 ms 
SELECT t0.id AS id_1, t0.client_id AS client_id_2, t0.course_id AS course_id_3, t0.provider_id AS provider_id_4 FROM course_provider t0 WHERE t0.course_id = ?
Parameters: 
[
  165
]
View formatted query    View runnable query    Explain query
192 0.92 ms 
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.id AS id_3, t0.created AS created_4, t0.modified AS modified_5, t0.client_id AS client_id_6 FROM course_type t0 WHERE t0.id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
193 0.33 ms 
SELECT t0.name AS name_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.client_id AS client_id_5 FROM category t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query
194 0.54 ms 
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.client_id AS client_id_9, t0.course_id AS course_id_10 FROM course_image t0 WHERE t0.course_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  165
]
View formatted query    View runnable query    Explain query
195 0.62 ms 
SELECT t0.content AS content_1, t0.order_id AS order_id_2, t0.title AS title_3, t0.id AS id_4, t0.created AS created_5, t0.modified AS modified_6, t0.client_id AS client_id_7, t0.course_id AS course_id_8 FROM course_text t0 WHERE t0.course_id = ? ORDER BY t0.order_id ASC
Parameters: 
[
  165
]
View formatted query    View runnable query    Explain query

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\Commons\Entity\GenericEntity No errors.
App\Entity\Course No errors.
App\Entity\CourseField No errors.
App\User\Entity\Client No errors.
League\Bundle\OAuth2ServerBundle\Model\RefreshToken No errors.
App\Entity\OAuth\RefreshToken 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\Venue No errors.
App\Entity\VenueRoom 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\OccurrenceProvider No errors.
App\Entity\CourseData No errors.
App\Entity\Order No errors.
App\Entity\CourseSubscriptionBooking No errors.
App\Entity\OrderItemPerson No errors.
App\Entity\Invoice No errors.
App\Entity\VenueDocument No errors.
App\Entity\VenueImage No errors.
App\Entity\VenueProvider No errors.
App\Entity\SpeakerImage No errors.
App\Entity\SpeakerText No errors.
App\Entity\SpeakerProvider No errors.
App\User\Entity\User No errors.
App\Entity\CustomerHistoryEntry No errors.
App\Entity\CustomerDocument No errors.
App\Entity\ManualNewsletter No errors.
App\Entity\InvoiceItemAttendees No errors.
App\Entity\TagsPerson No errors.
App\Entity\Provider No errors.