Symfony Profiler

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 = '390ac6f7e4eb9f8fe91e4bb67ac4e54caf119cb27409918ef48ff222ac742ac2c7ddefb7dc99fc40';

SELECT
  t0.published AS published_1,
  t0.start AS start_2,
  t0.end AS end_3,
  t0.slots AS slots_4,
  t0.code AS code_5,
  t0.reservation_allowed AS reservation_allowed_6,
  t0.booked_slots AS booked_slots_7,
  t0.id AS id_8,
  t0.created AS created_9,
  t0.modified AS modified_10,
  t0.venueId AS venueId_11,
  t0.venueRoomId AS venueRoomId_12,
  t0.courseId AS courseId_13
FROM
  course_occurrence t0
WHERE
  t0.id = ?

SELECT t0.published AS published_1, t0.start AS start_2, t0.end AS end_3, t0.slots AS slots_4, t0.code AS code_5, t0.reservation_allowed AS reservation_allowed_6, t0.booked_slots AS booked_slots_7, t0.id AS id_8, t0.created AS created_9, t0.modified AS modified_10, t0.venueId AS venueId_11, t0.venueRoomId AS venueRoomId_12, t0.courseId AS courseId_13 FROM course_occurrence t0 WHERE t0.id = '2359';

SELECT
  t0.price AS price_1,
  t0.tax_rate AS tax_rate_2,
  t0.quantity AS quantity_3,
  t0.cancelled_quantity AS cancelled_quantity_4,
  t0.is_free AS is_free_5,
  t0.name AS name_6,
  t0.description AS description_7,
  t0.status AS status_8,
  t0.id AS id_9,
  t0.created AS created_10,
  t0.modified AS modified_11,
  t0._order_id AS _order_id_12,
  t0.course_occurrence_id AS course_occurrence_id_13,
  t0.course_occurrence_time_id AS course_occurrence_time_id_14,
  t0.course_subscription_booking_id AS course_subscription_booking_id_15,
  t0.course_item_id AS course_item_id_16
FROM
  customer_order_item t0
WHERE
  t0.course_occurrence_id = ?

SELECT t0.price AS price_1, t0.tax_rate AS tax_rate_2, t0.quantity AS quantity_3, t0.cancelled_quantity AS cancelled_quantity_4, t0.is_free AS is_free_5, t0.name AS name_6, t0.description AS description_7, t0.status AS status_8, t0.id AS id_9, t0.created AS created_10, t0.modified AS modified_11, t0._order_id AS _order_id_12, t0.course_occurrence_id AS course_occurrence_id_13, t0.course_occurrence_time_id AS course_occurrence_time_id_14, t0.course_subscription_booking_id AS course_subscription_booking_id_15, t0.course_item_id AS course_item_id_16 FROM customer_order_item t0 WHERE t0.course_occurrence_id = 2359;

SELECT
  t0.number AS number_1,
  t0.order_date AS order_date_2,
  t0.customer_title AS customer_title_3,
  t0.customer_salutation AS customer_salutation_4,
  t0.customer_member AS customer_member_5,
  t0.customer_company AS customer_company_6,
  t0.customer_firstname AS customer_firstname_7,
  t0.customer_lastname AS customer_lastname_8,
  t0.customer_street AS customer_street_9,
  t0.customer_street_number AS customer_street_number_10,
  t0.customer_postalcode AS customer_postalcode_11,
  t0.customer_city AS customer_city_12,
  t0.customer_contact_email AS customer_contact_email_13,
  t0.customer_country AS customer_country_14,
  t0.customer_phone AS customer_phone_15,
  t0.customer_age_group AS customer_age_group_16,
  t0.status AS status_17,
  t0.iban AS iban_18,
  t0.bic AS bic_19,
  t0.bank AS bank_20,
  t0.payment_type AS payment_type_21,
  t0.customer_comment AS customer_comment_22,
  t0.id AS id_23,
  t0.created AS created_24,
  t0.modified AS modified_25,
  t0.customer_id AS customer_id_26,
  t0.client_id AS client_id_27,
  t0.person_id AS person_id_28,
  t0.invoice_recipient_id AS invoice_recipient_id_29
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.number AS number_1, t0.order_date AS order_date_2, t0.customer_title AS customer_title_3, t0.customer_salutation AS customer_salutation_4, t0.customer_member AS customer_member_5, t0.customer_company AS customer_company_6, t0.customer_firstname AS customer_firstname_7, t0.customer_lastname AS customer_lastname_8, t0.customer_street AS customer_street_9, t0.customer_street_number AS customer_street_number_10, t0.customer_postalcode AS customer_postalcode_11, t0.customer_city AS customer_city_12, t0.customer_contact_email AS customer_contact_email_13, t0.customer_country AS customer_country_14, t0.customer_phone AS customer_phone_15, t0.customer_age_group AS customer_age_group_16, t0.status AS status_17, t0.iban AS iban_18, t0.bic AS bic_19, t0.bank AS bank_20, t0.payment_type AS payment_type_21, t0.customer_comment AS customer_comment_22, t0.id AS id_23, t0.created AS created_24, t0.modified AS modified_25, t0.customer_id AS customer_id_26, t0.client_id AS client_id_27, t0.person_id AS person_id_28, t0.invoice_recipient_id AS invoice_recipient_id_29 FROM customer_order t0 WHERE t0.id = 2241;

SELECT
  t0.number AS number_1,
  t0.order_date AS order_date_2,
  t0.customer_title AS customer_title_3,
  t0.customer_salutation AS customer_salutation_4,
  t0.customer_member AS customer_member_5,
  t0.customer_company AS customer_company_6,
  t0.customer_firstname AS customer_firstname_7,
  t0.customer_lastname AS customer_lastname_8,
  t0.customer_street AS customer_street_9,
  t0.customer_street_number AS customer_street_number_10,
  t0.customer_postalcode AS customer_postalcode_11,
  t0.customer_city AS customer_city_12,
  t0.customer_contact_email AS customer_contact_email_13,
  t0.customer_country AS customer_country_14,
  t0.customer_phone AS customer_phone_15,
  t0.customer_age_group AS customer_age_group_16,
  t0.status AS status_17,
  t0.iban AS iban_18,
  t0.bic AS bic_19,
  t0.bank AS bank_20,
  t0.payment_type AS payment_type_21,
  t0.customer_comment AS customer_comment_22,
  t0.id AS id_23,
  t0.created AS created_24,
  t0.modified AS modified_25,
  t0.customer_id AS customer_id_26,
  t0.client_id AS client_id_27,
  t0.person_id AS person_id_28,
  t0.invoice_recipient_id AS invoice_recipient_id_29
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.number AS number_1, t0.order_date AS order_date_2, t0.customer_title AS customer_title_3, t0.customer_salutation AS customer_salutation_4, t0.customer_member AS customer_member_5, t0.customer_company AS customer_company_6, t0.customer_firstname AS customer_firstname_7, t0.customer_lastname AS customer_lastname_8, t0.customer_street AS customer_street_9, t0.customer_street_number AS customer_street_number_10, t0.customer_postalcode AS customer_postalcode_11, t0.customer_city AS customer_city_12, t0.customer_contact_email AS customer_contact_email_13, t0.customer_country AS customer_country_14, t0.customer_phone AS customer_phone_15, t0.customer_age_group AS customer_age_group_16, t0.status AS status_17, t0.iban AS iban_18, t0.bic AS bic_19, t0.bank AS bank_20, t0.payment_type AS payment_type_21, t0.customer_comment AS customer_comment_22, t0.id AS id_23, t0.created AS created_24, t0.modified AS modified_25, t0.customer_id AS customer_id_26, t0.client_id AS client_id_27, t0.person_id AS person_id_28, t0.invoice_recipient_id AS invoice_recipient_id_29 FROM customer_order t0 WHERE t0.id = 2250;

SELECT
  t0.number AS number_1,
  t0.order_date AS order_date_2,
  t0.customer_title AS customer_title_3,
  t0.customer_salutation AS customer_salutation_4,
  t0.customer_member AS customer_member_5,
  t0.customer_company AS customer_company_6,
  t0.customer_firstname AS customer_firstname_7,
  t0.customer_lastname AS customer_lastname_8,
  t0.customer_street AS customer_street_9,
  t0.customer_street_number AS customer_street_number_10,
  t0.customer_postalcode AS customer_postalcode_11,
  t0.customer_city AS customer_city_12,
  t0.customer_contact_email AS customer_contact_email_13,
  t0.customer_country AS customer_country_14,
  t0.customer_phone AS customer_phone_15,
  t0.customer_age_group AS customer_age_group_16,
  t0.status AS status_17,
  t0.iban AS iban_18,
  t0.bic AS bic_19,
  t0.bank AS bank_20,
  t0.payment_type AS payment_type_21,
  t0.customer_comment AS customer_comment_22,
  t0.id AS id_23,
  t0.created AS created_24,
  t0.modified AS modified_25,
  t0.customer_id AS customer_id_26,
  t0.client_id AS client_id_27,
  t0.person_id AS person_id_28,
  t0.invoice_recipient_id AS invoice_recipient_id_29
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.number AS number_1, t0.order_date AS order_date_2, t0.customer_title AS customer_title_3, t0.customer_salutation AS customer_salutation_4, t0.customer_member AS customer_member_5, t0.customer_company AS customer_company_6, t0.customer_firstname AS customer_firstname_7, t0.customer_lastname AS customer_lastname_8, t0.customer_street AS customer_street_9, t0.customer_street_number AS customer_street_number_10, t0.customer_postalcode AS customer_postalcode_11, t0.customer_city AS customer_city_12, t0.customer_contact_email AS customer_contact_email_13, t0.customer_country AS customer_country_14, t0.customer_phone AS customer_phone_15, t0.customer_age_group AS customer_age_group_16, t0.status AS status_17, t0.iban AS iban_18, t0.bic AS bic_19, t0.bank AS bank_20, t0.payment_type AS payment_type_21, t0.customer_comment AS customer_comment_22, t0.id AS id_23, t0.created AS created_24, t0.modified AS modified_25, t0.customer_id AS customer_id_26, t0.client_id AS client_id_27, t0.person_id AS person_id_28, t0.invoice_recipient_id AS invoice_recipient_id_29 FROM customer_order t0 WHERE t0.id = 2256;

SELECT
  t0.number AS number_1,
  t0.order_date AS order_date_2,
  t0.customer_title AS customer_title_3,
  t0.customer_salutation AS customer_salutation_4,
  t0.customer_member AS customer_member_5,
  t0.customer_company AS customer_company_6,
  t0.customer_firstname AS customer_firstname_7,
  t0.customer_lastname AS customer_lastname_8,
  t0.customer_street AS customer_street_9,
  t0.customer_street_number AS customer_street_number_10,
  t0.customer_postalcode AS customer_postalcode_11,
  t0.customer_city AS customer_city_12,
  t0.customer_contact_email AS customer_contact_email_13,
  t0.customer_country AS customer_country_14,
  t0.customer_phone AS customer_phone_15,
  t0.customer_age_group AS customer_age_group_16,
  t0.status AS status_17,
  t0.iban AS iban_18,
  t0.bic AS bic_19,
  t0.bank AS bank_20,
  t0.payment_type AS payment_type_21,
  t0.customer_comment AS customer_comment_22,
  t0.id AS id_23,
  t0.created AS created_24,
  t0.modified AS modified_25,
  t0.customer_id AS customer_id_26,
  t0.client_id AS client_id_27,
  t0.person_id AS person_id_28,
  t0.invoice_recipient_id AS invoice_recipient_id_29
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.number AS number_1, t0.order_date AS order_date_2, t0.customer_title AS customer_title_3, t0.customer_salutation AS customer_salutation_4, t0.customer_member AS customer_member_5, t0.customer_company AS customer_company_6, t0.customer_firstname AS customer_firstname_7, t0.customer_lastname AS customer_lastname_8, t0.customer_street AS customer_street_9, t0.customer_street_number AS customer_street_number_10, t0.customer_postalcode AS customer_postalcode_11, t0.customer_city AS customer_city_12, t0.customer_contact_email AS customer_contact_email_13, t0.customer_country AS customer_country_14, t0.customer_phone AS customer_phone_15, t0.customer_age_group AS customer_age_group_16, t0.status AS status_17, t0.iban AS iban_18, t0.bic AS bic_19, t0.bank AS bank_20, t0.payment_type AS payment_type_21, t0.customer_comment AS customer_comment_22, t0.id AS id_23, t0.created AS created_24, t0.modified AS modified_25, t0.customer_id AS customer_id_26, t0.client_id AS client_id_27, t0.person_id AS person_id_28, t0.invoice_recipient_id AS invoice_recipient_id_29 FROM customer_order t0 WHERE t0.id = 2273;

SELECT
  t0.number AS number_1,
  t0.order_date AS order_date_2,
  t0.customer_title AS customer_title_3,
  t0.customer_salutation AS customer_salutation_4,
  t0.customer_member AS customer_member_5,
  t0.customer_company AS customer_company_6,
  t0.customer_firstname AS customer_firstname_7,
  t0.customer_lastname AS customer_lastname_8,
  t0.customer_street AS customer_street_9,
  t0.customer_street_number AS customer_street_number_10,
  t0.customer_postalcode AS customer_postalcode_11,
  t0.customer_city AS customer_city_12,
  t0.customer_contact_email AS customer_contact_email_13,
  t0.customer_country AS customer_country_14,
  t0.customer_phone AS customer_phone_15,
  t0.customer_age_group AS customer_age_group_16,
  t0.status AS status_17,
  t0.iban AS iban_18,
  t0.bic AS bic_19,
  t0.bank AS bank_20,
  t0.payment_type AS payment_type_21,
  t0.customer_comment AS customer_comment_22,
  t0.id AS id_23,
  t0.created AS created_24,
  t0.modified AS modified_25,
  t0.customer_id AS customer_id_26,
  t0.client_id AS client_id_27,
  t0.person_id AS person_id_28,
  t0.invoice_recipient_id AS invoice_recipient_id_29
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.number AS number_1, t0.order_date AS order_date_2, t0.customer_title AS customer_title_3, t0.customer_salutation AS customer_salutation_4, t0.customer_member AS customer_member_5, t0.customer_company AS customer_company_6, t0.customer_firstname AS customer_firstname_7, t0.customer_lastname AS customer_lastname_8, t0.customer_street AS customer_street_9, t0.customer_street_number AS customer_street_number_10, t0.customer_postalcode AS customer_postalcode_11, t0.customer_city AS customer_city_12, t0.customer_contact_email AS customer_contact_email_13, t0.customer_country AS customer_country_14, t0.customer_phone AS customer_phone_15, t0.customer_age_group AS customer_age_group_16, t0.status AS status_17, t0.iban AS iban_18, t0.bic AS bic_19, t0.bank AS bank_20, t0.payment_type AS payment_type_21, t0.customer_comment AS customer_comment_22, t0.id AS id_23, t0.created AS created_24, t0.modified AS modified_25, t0.customer_id AS customer_id_26, t0.client_id AS client_id_27, t0.person_id AS person_id_28, t0.invoice_recipient_id AS invoice_recipient_id_29 FROM customer_order t0 WHERE t0.id = 2282;

SELECT
  t0.number AS number_1,
  t0.order_date AS order_date_2,
  t0.customer_title AS customer_title_3,
  t0.customer_salutation AS customer_salutation_4,
  t0.customer_member AS customer_member_5,
  t0.customer_company AS customer_company_6,
  t0.customer_firstname AS customer_firstname_7,
  t0.customer_lastname AS customer_lastname_8,
  t0.customer_street AS customer_street_9,
  t0.customer_street_number AS customer_street_number_10,
  t0.customer_postalcode AS customer_postalcode_11,
  t0.customer_city AS customer_city_12,
  t0.customer_contact_email AS customer_contact_email_13,
  t0.customer_country AS customer_country_14,
  t0.customer_phone AS customer_phone_15,
  t0.customer_age_group AS customer_age_group_16,
  t0.status AS status_17,
  t0.iban AS iban_18,
  t0.bic AS bic_19,
  t0.bank AS bank_20,
  t0.payment_type AS payment_type_21,
  t0.customer_comment AS customer_comment_22,
  t0.id AS id_23,
  t0.created AS created_24,
  t0.modified AS modified_25,
  t0.customer_id AS customer_id_26,
  t0.client_id AS client_id_27,
  t0.person_id AS person_id_28,
  t0.invoice_recipient_id AS invoice_recipient_id_29
FROM
  customer_order t0
WHERE
  t0.id = ?

SELECT t0.number AS number_1, t0.order_date AS order_date_2, t0.customer_title AS customer_title_3, t0.customer_salutation AS customer_salutation_4, t0.customer_member AS customer_member_5, t0.customer_company AS customer_company_6, t0.customer_firstname AS customer_firstname_7, t0.customer_lastname AS customer_lastname_8, t0.customer_street AS customer_street_9, t0.customer_street_number AS customer_street_number_10, t0.customer_postalcode AS customer_postalcode_11, t0.customer_city AS customer_city_12, t0.customer_contact_email AS customer_contact_email_13, t0.customer_country AS customer_country_14, t0.customer_phone AS customer_phone_15, t0.customer_age_group AS customer_age_group_16, t0.status AS status_17, t0.iban AS iban_18, t0.bic AS bic_19, t0.bank AS bank_20, t0.payment_type AS payment_type_21, t0.customer_comment AS customer_comment_22, t0.id AS id_23, t0.created AS created_24, t0.modified AS modified_25, t0.customer_id AS customer_id_26, t0.client_id AS client_id_27, t0.person_id AS person_id_28, t0.invoice_recipient_id AS invoice_recipient_id_29 FROM customer_order t0 WHERE t0.id = 2284;

SELECT
  t0.name AS name_1,
  t0.postalcode AS postalcode_2,
  t0.city AS city_3,
  t0.street AS street_4,
  t0.street_number AS street_number_5,
  t0.geo_latitude AS geo_latitude_6,
  t0.geo_longitude AS geo_longitude_7,
  t0.id AS id_8,
  t0.created AS created_9,
  t0.modified AS modified_10,
  t0.clientId AS clientId_11
FROM
  venue t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.postalcode AS postalcode_2, t0.city AS city_3, t0.street AS street_4, t0.street_number AS street_number_5, t0.geo_latitude AS geo_latitude_6, t0.geo_longitude AS geo_longitude_7, t0.id AS id_8, t0.created AS created_9, t0.modified AS modified_10, t0.clientId AS clientId_11 FROM venue t0 WHERE t0.id = 1;

SELECT
  t0.name AS name_1,
  t0.number AS number_2,
  t0.floor AS floor_3,
  t0.building AS building_4,
  t0.id AS id_5,
  t0.created AS created_6,
  t0.modified AS modified_7,
  t0.venueId AS venueId_8
FROM
  venue_room t0
WHERE
  t0.venueId = ?
ORDER BY
  t0.name ASC

SELECT t0.name AS name_1, t0.number AS number_2, t0.floor AS floor_3, t0.building AS building_4, t0.id AS id_5, t0.created AS created_6, t0.modified AS modified_7, t0.venueId AS venueId_8 FROM venue_room t0 WHERE t0.venueId = 1 ORDER BY t0.name 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.venue_id AS venue_id_9
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.venue_id AS venue_id_9 FROM venue_image t0 WHERE t0.venue_id = 1 ORDER BY t0.order_id ASC;

SELECT
  t0.id AS id_1,
  t0.start AS start_2,
  t0.end AS end_3,
  t0.note AS note_4,
  t0.availability AS availability_5,
  t0.created AS created_6,
  t0.modified AS modified_7,
  t0.occurrenceId AS occurrenceId_8
FROM
  course_occurrence_time t0
WHERE
  t0.occurrenceId = ?
ORDER BY
  t0.start ASC

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.note AS note_4, t0.availability AS availability_5, t0.created AS created_6, t0.modified AS modified_7, t0.occurrenceId AS occurrenceId_8 FROM course_occurrence_time t0 WHERE t0.occurrenceId = 2359 ORDER BY t0.start ASC;

SELECT
  t0.image AS image_1,
  t0.id AS id_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.person_id AS person_id_5
FROM
  speaker t0
  INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id
WHERE
  course_occurrence_speaker.course_occurrence_id = ?

SELECT t0.image AS image_1, t0.id AS id_2, t0.created AS created_3, t0.modified AS modified_4, t0.person_id AS person_id_5 FROM speaker t0 INNER JOIN course_occurrence_speaker ON t0.id = course_occurrence_speaker.speaker_id WHERE course_occurrence_speaker.course_occurrence_id = 2359;