Symfony Profiler

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 = ?

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 = 3086;

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 = ?

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 = 250;

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 = ?

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 = 'c85ab6c58539719ff236fd1351583da7fa07c76e0f253fcb01d6daee3fce77c9b97a3e747c3cd280';

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

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 = 144 AND c0_.certificate = 0 AND c1_.value_text IS NOT NULL;

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

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 = 144 ORDER BY t0.order_id ASC;

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

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 = 19 ORDER BY t0.name ASC;

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 = ?

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 = 189;

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 = ?

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 = 144;

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

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 = 250 ORDER BY t0.start ASC;

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

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 = 23 ORDER BY t0.order_id ASC;

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

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 = 144 AND t0.client_id = 1 LIMIT 1;

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 = ?

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 = '65c6366c620f9';

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

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 = 19 ORDER BY t0.order_id ASC;

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 = ?

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 = 144;

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 = ?

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 = 19;

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 = ?

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 = 250;

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 = ?

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 = 6;

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

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 = 23 ORDER BY t0.order_id ASC;

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

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 = 144 ORDER BY t0.order_id ASC;

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 = ?

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 = 11;