GET https://miraculumaurich.de/frontend/course/9513?cal=2026-04-01&tid=2937

Response
200 OK
IP
216.73.217.130
Profiled on
Token
4ff476

Query Metrics

32 Database Queries
15 Different statements
101.36 ms Query time
0 Invalid entities
271 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.76 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.street AS street_5, t0.street_number AS street_number_6, t0.addressAddition AS addressAddition_7, t0.postalcode AS postalcode_8, t0.city AS city_9, t0.country AS country_10, t0.email AS email_11, t0.web AS web_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.from_email AS from_email_15, t0.logo_path AS logo_path_16, t0.subdomain AS subdomain_17, t0.custom_domain AS custom_domain_18, t0.keycloak_client_id AS keycloak_client_id_19, t0.keycloakGroupId AS keycloakGroupId_20 FROM client t0 WHERE t0.custom_domain = ? LIMIT 1
Parameters: 
[
  "miraculumaurich.de"
]
View formatted query    View runnable query    Explain query
2 0.48 ms 
SELECT t0.id AS id_1, t0.variableKey AS variableKey_2, t0.variableValue AS variableValue_3, t0.variableType AS variableType_4, t0.description AS description_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8 FROM client_config_variable t0 WHERE t0.client_id = ? AND t0.variableKey = ? LIMIT 1
Parameters: 
[
  91
  "MAINTENANCE_MODE"
]
View formatted query    View runnable query    Explain query
3 0.27 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.street AS street_5, t0.street_number AS street_number_6, t0.addressAddition AS addressAddition_7, t0.postalcode AS postalcode_8, t0.city AS city_9, t0.country AS country_10, t0.email AS email_11, t0.web AS web_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.from_email AS from_email_15, t0.logo_path AS logo_path_16, t0.subdomain AS subdomain_17, t0.custom_domain AS custom_domain_18, t0.keycloak_client_id AS keycloak_client_id_19, t0.keycloakGroupId AS keycloakGroupId_20 FROM client t0 WHERE t0.custom_domain = ? LIMIT 1
Parameters: 
[
  "miraculumaurich.de"
]
View formatted query    View runnable query    Explain query
4 0.21 ms 
SELECT t0.id AS id_1, t0.variableKey AS variableKey_2, t0.variableValue AS variableValue_3, t0.variableType AS variableType_4, t0.description AS description_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8 FROM client_config_variable t0 WHERE t0.client_id = ? AND t0.variableKey = ? LIMIT 1
Parameters: 
[
  91
  "THEME_NAME"
]
View formatted query    View runnable query    Explain query
5 0.36 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.session_id AS session_id_4, t0.customer_id AS customer_id_5, t0.client_id AS client_id_6 FROM cart t0 WHERE t0.session_id = ? LIMIT 1
Parameters: 
[
  ""
]
View formatted query    View runnable query    Explain query
6 0.34 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.course_nature AS course_nature_6, t0.description AS description_7, t0.searchwords AS searchwords_8, t0.price AS price_9, t0.rabatt AS rabatt_10, t0.tax_rate AS tax_rate_11, t0.number AS number_12, t0.material_cost AS material_cost_13, t0.quantity_material_per_participant_only AS quantity_material_per_participant_only_14, t0.target_age_min AS target_age_min_15, t0.target_age_max AS target_age_max_16, t0.invoice_upper_comment AS invoice_upper_comment_17, t0.invoice_lower_comment AS invoice_lower_comment_18, t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_19, t0.client_id AS client_id_20, t0.subscription_id AS subscription_id_21, t0.category_id AS category_id_22, t0.series_id AS series_id_23, t0.type_id AS type_id_24 FROM course t0 WHERE t0.id = ?
Parameters: 
[
  "9513"
]
View formatted query    View runnable query    Explain query
7 0.63 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.street AS street_5, t0.street_number AS street_number_6, t0.addressAddition AS addressAddition_7, t0.postalcode AS postalcode_8, t0.city AS city_9, t0.country AS country_10, t0.email AS email_11, t0.web AS web_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.from_email AS from_email_15, t0.logo_path AS logo_path_16, t0.subdomain AS subdomain_17, t0.custom_domain AS custom_domain_18, t0.keycloak_client_id AS keycloak_client_id_19, t0.keycloakGroupId AS keycloakGroupId_20 FROM client t0 WHERE t0.custom_domain = ? LIMIT 1
Parameters: 
[
  "miraculumaurich.de"
]
View formatted query    View runnable query    Explain query
8 0.27 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.published AS published_4, t0.start AS start_5, t0.end AS end_6, t0.slots AS slots_7, t0.code AS code_8, t0.reservation_allowed AS reservation_allowed_9, t0.booked_slots AS booked_slots_10, t0.price AS price_11, t0.tax_rate AS tax_rate_12, t0.material_cost AS material_cost_13, t0.number AS number_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.id = ?
Parameters: 
[
  "2937"
]
View formatted query    View runnable query    Explain query
9 4.76 ms 
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.published AS published_3, c0_.start AS start_4, c0_.end AS end_5, c0_.slots AS slots_6, c0_.code AS code_7, c0_.reservation_allowed AS reservation_allowed_8, c0_.booked_slots AS booked_slots_9, c0_.price AS price_10, c0_.tax_rate AS tax_rate_11, c0_.material_cost AS material_cost_12, c0_.number AS number_13, c0_.client_id AS client_id_14, c0_.venueId AS venueId_15, c0_.venueRoomId AS venueRoomId_16, c0_.courseId AS courseId_17 FROM course_occurrence c0_ LEFT JOIN course c1_ ON c0_.courseId = c1_.id LEFT JOIN client c2_ ON c1_.client_id = c2_.id LEFT JOIN course_occurrence_time c3_ ON c0_.id = c3_.occurrenceId LEFT JOIN course_text c4_ ON c1_.id = c4_.course_id WHERE c2_.id = ? AND c0_.published = ? AND (c3_.end > ? OR c3_.end IS NULL) AND c1_.category_id = ? GROUP BY c0_.id ORDER BY c3_.start ASC
Parameters: 
[
  91
  1
  "2026-05-20 03:06:48"
  1495
]
View formatted query    View runnable query    Explain query
10 3.44 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.published AS published_4, t0.start AS start_5, t0.end AS end_6, t0.slots AS slots_7, t0.code AS code_8, t0.reservation_allowed AS reservation_allowed_9, t0.booked_slots AS booked_slots_10, t0.price AS price_11, t0.tax_rate AS tax_rate_12, t0.material_cost AS material_cost_13, t0.number AS number_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: 
[
  9513
]
View formatted query    View runnable query    Explain query
11 1.65 ms 
SELECT t0.id AS id_1, t0.variableKey AS variableKey_2, t0.variableValue AS variableValue_3, t0.variableType AS variableType_4, t0.description AS description_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8 FROM client_config_variable t0 WHERE t0.client_id = ? AND t0.variableKey = ? LIMIT 1
Parameters: 
[
  91
  "GOOGLE_API_SERVER_KEY"
]
View formatted query    View runnable query    Explain query
12 5.02 ms 
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, title_17 FROM (SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.published AS published_3, c0_.start AS start_4, c0_.end AS end_5, c0_.slots AS slots_6, c0_.code AS code_7, c0_.reservation_allowed AS reservation_allowed_8, c0_.booked_slots AS booked_slots_9, c0_.price AS price_10, c0_.tax_rate AS tax_rate_11, c0_.material_cost AS material_cost_12, c0_.number AS number_13, c1_.id AS id_14, c1_.created AS created_15, c1_.modified AS modified_16, c1_.title AS title_17, c1_.subtitle AS subtitle_18, c1_.course_nature AS course_nature_19, c1_.description AS description_20, c1_.searchwords AS searchwords_21, c1_.price AS price_22, c1_.rabatt AS rabatt_23, c1_.tax_rate AS tax_rate_24, c1_.number AS number_25, c1_.material_cost AS material_cost_26, c1_.quantity_material_per_participant_only AS quantity_material_per_participant_only_27, c1_.target_age_min AS target_age_min_28, c1_.target_age_max AS target_age_max_29, c1_.invoice_upper_comment AS invoice_upper_comment_30, c1_.invoice_lower_comment AS invoice_lower_comment_31, c1_.invoice_lower_comment_debit AS invoice_lower_comment_debit_32, c2_.id AS id_33, s3_.id AS id_34, s3_.created AS created_35, s3_.modified AS modified_36, s3_.image AS image_37, c4_.id AS id_38, c4_.created AS created_39, c4_.modified AS modified_40, c4_.start AS start_41, c4_.end AS end_42, c4_.note AS note_43, c4_.availability AS availability_44, w5_.id AS id_45, w5_.created AS created_46, w5_.modified AS modified_47, w5_.quantity AS quantity_48, v6_.id AS id_49, v6_.created AS created_50, v6_.modified AS modified_51, v6_.name AS name_52, v6_.postalcode AS postalcode_53, v6_.city AS city_54, v6_.street AS street_55, v6_.street_number AS street_number_56, v6_.geo_latitude AS geo_latitude_57, v6_.geo_longitude AS geo_longitude_58, c7_.course_occurrence_id AS course_occurrence_id_59, c7_.speaker_id AS speaker_id_60 FROM course_occurrence c0_ LEFT JOIN course c1_ ON c0_.courseId = c1_.id LEFT JOIN course_provider c2_ ON c1_.id = c2_.course_id LEFT JOIN course_occurrence_speaker c7_ ON c0_.id = c7_.course_occurrence_id LEFT JOIN speaker s3_ ON c7_.speaker_id = s3_.id LEFT JOIN person p8_ ON s3_.person_id = p8_.id LEFT JOIN course_occurrence_time c4_ ON c0_.id = c4_.occurrenceId LEFT JOIN wait_item w5_ ON c0_.id = w5_.course_occurrence_id LEFT JOIN venue v6_ ON c0_.venueId = v6_.id WHERE c1_.id = ? ORDER BY c4_.start ASC) dctrn_result_inner ORDER BY title_17 DESC) dctrn_result LIMIT 1000
Parameters: 
[
  9513
]
View formatted query    View runnable query    Explain query
13 28.73 ms 
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.published AS published_3, c0_.start AS start_4, c0_.end AS end_5, c0_.slots AS slots_6, c0_.code AS code_7, c0_.reservation_allowed AS reservation_allowed_8, c0_.booked_slots AS booked_slots_9, c0_.price AS price_10, c0_.tax_rate AS tax_rate_11, c0_.material_cost AS material_cost_12, c0_.number AS number_13, c1_.id AS id_14, c1_.created AS created_15, c1_.modified AS modified_16, c1_.title AS title_17, c1_.subtitle AS subtitle_18, c1_.course_nature AS course_nature_19, c1_.description AS description_20, c1_.searchwords AS searchwords_21, c1_.price AS price_22, c1_.rabatt AS rabatt_23, c1_.tax_rate AS tax_rate_24, c1_.number AS number_25, c1_.material_cost AS material_cost_26, c1_.quantity_material_per_participant_only AS quantity_material_per_participant_only_27, c1_.target_age_min AS target_age_min_28, c1_.target_age_max AS target_age_max_29, c1_.invoice_upper_comment AS invoice_upper_comment_30, c1_.invoice_lower_comment AS invoice_lower_comment_31, c1_.invoice_lower_comment_debit AS invoice_lower_comment_debit_32, c2_.id AS id_33, s3_.id AS id_34, s3_.created AS created_35, s3_.modified AS modified_36, s3_.image AS image_37, c4_.id AS id_38, c4_.created AS created_39, c4_.modified AS modified_40, c4_.start AS start_41, c4_.end AS end_42, c4_.note AS note_43, c4_.availability AS availability_44, w5_.id AS id_45, w5_.created AS created_46, w5_.modified AS modified_47, w5_.quantity AS quantity_48, v6_.id AS id_49, v6_.created AS created_50, v6_.modified AS modified_51, v6_.name AS name_52, v6_.postalcode AS postalcode_53, v6_.city AS city_54, v6_.street AS street_55, v6_.street_number AS street_number_56, v6_.geo_latitude AS geo_latitude_57, v6_.geo_longitude AS geo_longitude_58, c0_.client_id AS client_id_59, c0_.venueId AS venueId_60, c0_.venueRoomId AS venueRoomId_61, c0_.courseId AS courseId_62, c1_.client_id AS client_id_63, c1_.subscription_id AS subscription_id_64, c1_.category_id AS category_id_65, c1_.series_id AS series_id_66, c1_.type_id AS type_id_67, c2_.client_id AS client_id_68, c2_.course_id AS course_id_69, c2_.provider_id AS provider_id_70, c7_.course_occurrence_id AS course_occurrence_id_71, c7_.speaker_id AS speaker_id_72, c7_.client_id AS client_id_73, s3_.client_id AS client_id_74, s3_.person_id AS person_id_75, c4_.client_id AS client_id_76, c4_.occurrenceId AS occurrenceId_77, w5_.client_id AS client_id_78, w5_.course_occurrence_id AS course_occurrence_id_79, w5_.course_occurrence_time_id AS course_occurrence_time_id_80, w5_._order_id AS _order_id_81, v6_.client_id AS client_id_82 FROM course_occurrence c0_ LEFT JOIN course c1_ ON c0_.courseId = c1_.id LEFT JOIN course_provider c2_ ON c1_.id = c2_.course_id LEFT JOIN course_occurrence_speaker c7_ ON c0_.id = c7_.course_occurrence_id LEFT JOIN speaker s3_ ON c7_.speaker_id = s3_.id LEFT JOIN person p8_ ON s3_.person_id = p8_.id LEFT JOIN course_occurrence_time c4_ ON c0_.id = c4_.occurrenceId LEFT JOIN wait_item w5_ ON c0_.id = w5_.course_occurrence_id LEFT JOIN venue v6_ ON c0_.venueId = v6_.id WHERE c1_.id = ? AND c0_.id IN (?, ?, ?, ?, ?) ORDER BY c1_.title DESC, c4_.start ASC
Parameters: 
[
  9513
  2713
  2714
  2937
  2940
  2965
]
View formatted query    View runnable query    Explain query
14 10.68 ms 
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.start AS start_3, c0_.end AS end_4, c0_.note AS note_5, c0_.availability AS availability_6, c0_.client_id AS client_id_7, c0_.occurrenceId AS occurrenceId_8 FROM course_occurrence_time c0_ LEFT JOIN course_occurrence c1_ ON c0_.occurrenceId = c1_.id WHERE c1_.id = ? AND c1_.published = ? AND DATE_FORMAT(c0_.start,'%Y-%m-%d') >= ? AND DATE_FORMAT(c0_.end,'%Y-%m-%d') <= ?
Parameters: 
[
  2714
  1
  "2026-04-01"
  "2026-04-30"
]
View formatted query    View runnable query    Explain query
15 0.47 ms 
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.start AS start_3, c0_.end AS end_4, c0_.note AS note_5, c0_.availability AS availability_6, c0_.client_id AS client_id_7, c0_.occurrenceId AS occurrenceId_8 FROM course_occurrence_time c0_ LEFT JOIN course_occurrence c1_ ON c0_.occurrenceId = c1_.id WHERE c1_.id = ? AND c1_.published = ? AND DATE_FORMAT(c0_.start,'%Y-%m-%d') >= ? AND DATE_FORMAT(c0_.end,'%Y-%m-%d') <= ?
Parameters: 
[
  2713
  1
  "2026-04-01"
  "2026-04-30"
]
View formatted query    View runnable query    Explain query
16 0.31 ms 
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.start AS start_3, c0_.end AS end_4, c0_.note AS note_5, c0_.availability AS availability_6, c0_.client_id AS client_id_7, c0_.occurrenceId AS occurrenceId_8 FROM course_occurrence_time c0_ LEFT JOIN course_occurrence c1_ ON c0_.occurrenceId = c1_.id WHERE c1_.id = ? AND c1_.published = ? AND DATE_FORMAT(c0_.start,'%Y-%m-%d') >= ? AND DATE_FORMAT(c0_.end,'%Y-%m-%d') <= ?
Parameters: 
[
  2937
  1
  "2026-04-01"
  "2026-04-30"
]
View formatted query    View runnable query    Explain query
17 0.29 ms 
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.start AS start_3, c0_.end AS end_4, c0_.note AS note_5, c0_.availability AS availability_6, c0_.client_id AS client_id_7, c0_.occurrenceId AS occurrenceId_8 FROM course_occurrence_time c0_ LEFT JOIN course_occurrence c1_ ON c0_.occurrenceId = c1_.id WHERE c1_.id = ? AND c1_.published = ? AND DATE_FORMAT(c0_.start,'%Y-%m-%d') >= ? AND DATE_FORMAT(c0_.end,'%Y-%m-%d') <= ?
Parameters: 
[
  2940
  1
  "2026-04-01"
  "2026-04-30"
]
View formatted query    View runnable query    Explain query
18 0.38 ms 
SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.start AS start_3, c0_.end AS end_4, c0_.note AS note_5, c0_.availability AS availability_6, c0_.client_id AS client_id_7, c0_.occurrenceId AS occurrenceId_8 FROM course_occurrence_time c0_ LEFT JOIN course_occurrence c1_ ON c0_.occurrenceId = c1_.id WHERE c1_.id = ? AND c1_.published = ? AND DATE_FORMAT(c0_.start,'%Y-%m-%d') >= ? AND DATE_FORMAT(c0_.end,'%Y-%m-%d') <= ?
Parameters: 
[
  2965
  1
  "2026-04-01"
  "2026-04-30"
]
View formatted query    View runnable query    Explain query
19 0.29 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.street AS street_5, t0.street_number AS street_number_6, t0.addressAddition AS addressAddition_7, t0.postalcode AS postalcode_8, t0.city AS city_9, t0.country AS country_10, t0.email AS email_11, t0.web AS web_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.from_email AS from_email_15, t0.logo_path AS logo_path_16, t0.subdomain AS subdomain_17, t0.custom_domain AS custom_domain_18, t0.keycloak_client_id AS keycloak_client_id_19, t0.keycloakGroupId AS keycloakGroupId_20 FROM client t0 WHERE t0.custom_domain = ? LIMIT 1
Parameters: 
[
  "miraculumaurich.de"
]
View formatted query    View runnable query    Explain query
20 0.20 ms 
SELECT t0.id AS id_1, t0.variableKey AS variableKey_2, t0.variableValue AS variableValue_3, t0.variableType AS variableType_4, t0.description AS description_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8 FROM client_config_variable t0 WHERE t0.client_id = ? AND t0.variableKey = ? LIMIT 1
Parameters: 
[
  91
  "THEME_NAME"
]
View formatted query    View runnable query    Explain query
21 0.16 ms 
SELECT t0.id AS id_1, t0.variableKey AS variableKey_2, t0.variableValue AS variableValue_3, t0.variableType AS variableType_4, t0.description AS description_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8 FROM client_config_variable t0 WHERE t0.client_id = ? AND t0.variableKey = ? LIMIT 1
Parameters: 
[
  91
  "THEME_NAME"
]
View formatted query    View runnable query    Explain query
22 15.73 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.client_id AS client_id_5 FROM category t0 WHERE t0.id = ?
Parameters: 
[
  1495
]
View formatted query    View runnable query    Explain query
23 0.26 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.number AS number_5, t0.floor AS floor_6, t0.building AS building_7, t0.client_id AS client_id_8, t0.venueId AS venueId_9 FROM venue_room t0 WHERE t0.id = ?
Parameters: 
[
  1316
]
View formatted query    View runnable query    Explain query
24 0.33 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.order_id AS order_id_4, t0.image AS image_5, t0.title AS title_6, t0.description AS description_7, t0.author AS author_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: 
[
  9513
]
View formatted query    View runnable query    Explain query
25 12.20 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.salutation AS salutation_5, t0.member AS member_6, t0.allow_member_vouchers AS allow_member_vouchers_7, t0.rabatt AS rabatt_8, t0.firstname AS firstname_9, t0.lastname AS lastname_10, t0.date_of_birth AS date_of_birth_11, t0.city_of_birth AS city_of_birth_12, t0.comment AS comment_13, t0.is_main_contact AS is_main_contact_14, t0.is_speaker AS is_speaker_15, t0.is_customer AS is_customer_16, t0.active AS active_17, t0.street AS street_18, t0.street_number AS street_number_19, t0.postalcode AS postalcode_20, t0.city AS city_21, t0.contact_email AS contact_email_22, t0.web AS web_23, t0.country AS country_24, t0.phone AS phone_25, t0.mobile AS mobile_26, t0.delete_date AS delete_date_27, t0.iban AS iban_28, t0.bic AS bic_29, t0.bank AS bank_30, t0.debit_agree AS debit_agree_31, t0.debit_agree_source AS debit_agree_source_32, t0.debit_agree_date AS debit_agree_date_33, t0.email_invoice AS email_invoice_34, t0.privacy_policy_confirmed AS privacy_policy_confirmed_35, t0.receive_newsletter AS receive_newsletter_36, t0.debit_active AS debit_active_37, t0.is_invoice_recipient AS is_invoice_recipient_38, t0.company AS company_39, t0.user_id AS user_id_40, t0.client_id AS client_id_41, t0.family_member_of_id AS family_member_of_id_42, t43.id AS id_44, t43.created AS created_45, t43.modified AS modified_46, t43.image AS image_47, t43.client_id AS client_id_48, t43.person_id AS person_id_49 FROM person t0 LEFT JOIN speaker t43 ON t43.person_id = t0.id WHERE t0.id = ?
Parameters: 
[
  15745
]
View formatted query    View runnable query    Explain query
26 0.65 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.content AS content_4, t0.order_id AS order_id_5, t0.title AS title_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: 
[
  9513
]
View formatted query    View runnable query    Explain query
27 0.28 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.course_nature AS course_nature_6, t0.description AS description_7, t0.searchwords AS searchwords_8, t0.price AS price_9, t0.rabatt AS rabatt_10, t0.tax_rate AS tax_rate_11, t0.number AS number_12, t0.material_cost AS material_cost_13, t0.quantity_material_per_participant_only AS quantity_material_per_participant_only_14, t0.target_age_min AS target_age_min_15, t0.target_age_max AS target_age_max_16, t0.invoice_upper_comment AS invoice_upper_comment_17, t0.invoice_lower_comment AS invoice_lower_comment_18, t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_19, t0.client_id AS client_id_20, t0.subscription_id AS subscription_id_21, t0.category_id AS category_id_22, t0.series_id AS series_id_23, t0.type_id AS type_id_24 FROM course t0 WHERE t0.id = ?
Parameters: 
[
  9514
]
View formatted query    View runnable query    Explain query
28 0.31 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.order_id AS order_id_4, t0.image AS image_5, t0.title AS title_6, t0.description AS description_7, t0.author AS author_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: 
[
  9514
]
View formatted query    View runnable query    Explain query
29 0.26 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.course_nature AS course_nature_6, t0.description AS description_7, t0.searchwords AS searchwords_8, t0.price AS price_9, t0.rabatt AS rabatt_10, t0.tax_rate AS tax_rate_11, t0.number AS number_12, t0.material_cost AS material_cost_13, t0.quantity_material_per_participant_only AS quantity_material_per_participant_only_14, t0.target_age_min AS target_age_min_15, t0.target_age_max AS target_age_max_16, t0.invoice_upper_comment AS invoice_upper_comment_17, t0.invoice_lower_comment AS invoice_lower_comment_18, t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_19, t0.client_id AS client_id_20, t0.subscription_id AS subscription_id_21, t0.category_id AS category_id_22, t0.series_id AS series_id_23, t0.type_id AS type_id_24 FROM course t0 WHERE t0.id = ?
Parameters: 
[
  9388
]
View formatted query    View runnable query    Explain query
30 0.32 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.order_id AS order_id_4, t0.image AS image_5, t0.title AS title_6, t0.description AS description_7, t0.author AS author_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: 
[
  9388
]
View formatted query    View runnable query    Explain query
31 0.24 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.subtitle AS subtitle_5, t0.course_nature AS course_nature_6, t0.description AS description_7, t0.searchwords AS searchwords_8, t0.price AS price_9, t0.rabatt AS rabatt_10, t0.tax_rate AS tax_rate_11, t0.number AS number_12, t0.material_cost AS material_cost_13, t0.quantity_material_per_participant_only AS quantity_material_per_participant_only_14, t0.target_age_min AS target_age_min_15, t0.target_age_max AS target_age_max_16, t0.invoice_upper_comment AS invoice_upper_comment_17, t0.invoice_lower_comment AS invoice_lower_comment_18, t0.invoice_lower_comment_debit AS invoice_lower_comment_debit_19, t0.client_id AS client_id_20, t0.subscription_id AS subscription_id_21, t0.category_id AS category_id_22, t0.series_id AS series_id_23, t0.type_id AS type_id_24 FROM course t0 WHERE t0.id = ?
Parameters: 
[
  9254
]
View formatted query    View runnable query    Explain query
32 11.06 ms 
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.order_id AS order_id_4, t0.image AS image_5, t0.title AS title_6, t0.description AS description_7, t0.author AS author_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: 
[
  9254
]
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CourseOccurrenceTime 221
App\Entity\CourseOccurrence 20
App\Entity\Course 8
App\Entity\CourseOccurrenceSpeaker 5
App\Entity\CourseImage 4
App\Entity\ClientConfigVariable 3
App\Entity\VenueRoom 2
App\User\Entity\Client 1
App\Entity\Category 1
App\Entity\CourseSeries 1
App\Entity\Venue 1
App\Entity\Speaker 1
App\Entity\Person 1
App\User\Entity\User 1
App\Entity\CourseText 1

Entities Mapping

Class Mapping errors
App\Commons\Entity\GenericEntity No errors.
App\User\Entity\Client No errors.
App\Entity\ClientConfigVariable No errors.
App\Entity\Cart No errors.
App\Entity\Person No errors.
App\Entity\Course 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\Voucher No errors.
App\Entity\Venue No errors.
App\Entity\VenueRoom No errors.
App\Entity\CourseOccurrenceTime No errors.
App\Entity\CourseOccurrenceSpeaker No errors.
App\Entity\WaitItem No errors.
App\Entity\OrderItem No errors.
App\Entity\OccurrenceProvider No errors.
App\Entity\Speaker No errors.
App\Entity\Provider No errors.
App\Entity\Order No errors.
App\Entity\SpeakerImage No errors.
App\Entity\SpeakerText No errors.
App\Entity\SpeakerProvider No errors.
App\Entity\VenueDocument No errors.
App\Entity\VenueImage No errors.
App\Entity\VenueProvider 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\Invoice No errors.
App\Entity\TagsPerson No errors.