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

SELECT
  t0.published AS published_1,
  t0.start AS start_2,
  t0.end AS end_3,
  t0.slots AS slots_4,
  t0.reservation_allowed AS reservation_allowed_5,
  t0.booked_slots AS booked_slots_6,
  t0.id AS id_7,
  t0.created AS created_8,
  t0.modified AS modified_9,
  t0.venueId AS venueId_10,
  t0.venueRoomId AS venueRoomId_11,
  t0.courseId AS courseId_12
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.reservation_allowed AS reservation_allowed_5, t0.booked_slots AS booked_slots_6, t0.id AS id_7, t0.created AS created_8, t0.modified AS modified_9, t0.venueId AS venueId_10, t0.venueRoomId AS venueRoomId_11, t0.courseId AS courseId_12 FROM course_occurrence t0 WHERE t0.id = '49';

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

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

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 = 3 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 = 3 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 = 49 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 = 49;

SELECT
  t0.title AS title_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.date_of_birth AS date_of_birth_4,
  t0.comment AS comment_5,
  t0.is_main_contact AS is_main_contact_6,
  t0.is_speaker AS is_speaker_7,
  t0.is_customer AS is_customer_8,
  t0.street AS street_9,
  t0.street_number AS street_number_10,
  t0.postalcode AS postalcode_11,
  t0.city AS city_12,
  t0.contact_email AS contact_email_13,
  t0.web AS web_14,
  t0.country AS country_15,
  t0.phone AS phone_16,
  t0.mobile AS mobile_17,
  t0.delete_date AS delete_date_18,
  t0.iban AS iban_19,
  t0.bic AS bic_20,
  t0.bank AS bank_21,
  t0.debit_agree AS debit_agree_22,
  t0.debit_agree_source AS debit_agree_source_23,
  t0.debit_agree_date AS debit_agree_date_24,
  t0.email_invoice AS email_invoice_25,
  t0.privacy_policy_confirmed AS privacy_policy_confirmed_26,
  t0.receive_newsletter AS receive_newsletter_27,
  t0.debit_active AS debit_active_28,
  t0.is_invoice_recipient AS is_invoice_recipient_29,
  t0.company AS company_30,
  t0.id AS id_31,
  t0.created AS created_32,
  t0.modified AS modified_33,
  t0.user_id AS user_id_34,
  t0.family_member_of_id AS family_member_of_id_35,
  t36.image AS image_37,
  t36.id AS id_38,
  t36.created AS created_39,
  t36.modified AS modified_40,
  t36.person_id AS person_id_41
FROM
  person t0
  LEFT JOIN speaker t36 ON t36.person_id = t0.id
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.date_of_birth AS date_of_birth_4, t0.comment AS comment_5, t0.is_main_contact AS is_main_contact_6, t0.is_speaker AS is_speaker_7, t0.is_customer AS is_customer_8, t0.street AS street_9, t0.street_number AS street_number_10, t0.postalcode AS postalcode_11, t0.city AS city_12, t0.contact_email AS contact_email_13, t0.web AS web_14, t0.country AS country_15, t0.phone AS phone_16, t0.mobile AS mobile_17, t0.delete_date AS delete_date_18, t0.iban AS iban_19, t0.bic AS bic_20, t0.bank AS bank_21, t0.debit_agree AS debit_agree_22, t0.debit_agree_source AS debit_agree_source_23, t0.debit_agree_date AS debit_agree_date_24, t0.email_invoice AS email_invoice_25, t0.privacy_policy_confirmed AS privacy_policy_confirmed_26, t0.receive_newsletter AS receive_newsletter_27, t0.debit_active AS debit_active_28, t0.is_invoice_recipient AS is_invoice_recipient_29, t0.company AS company_30, t0.id AS id_31, t0.created AS created_32, t0.modified AS modified_33, t0.user_id AS user_id_34, t0.family_member_of_id AS family_member_of_id_35, t36.image AS image_37, t36.id AS id_38, t36.created AS created_39, t36.modified AS modified_40, t36.person_id AS person_id_41 FROM person t0 LEFT JOIN speaker t36 ON t36.person_id = t0.id WHERE t0.id = 1;

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.speaker_id AS speaker_id_6
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.speaker_id AS speaker_id_6 FROM speaker_image t0 WHERE t0.speaker_id = 1 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.speaker_id AS speaker_id_8
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.speaker_id AS speaker_id_8 FROM speaker_text t0 WHERE t0.speaker_id = 1 ORDER BY t0.order_id ASC;