GET https://test.kursimple.de/frontend/course/

Query Metrics

154 Database Queries
14 Different statements
37.09 ms Query time
0 Invalid entities
394 Managed entities

Queries

Group similar statements

# Time Info
1 0.93 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:
[
  "test.kursimple.de"
]
2 0.25 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.subdomain = ? LIMIT 1
Parameters:
[
  "test"
]
3 0.29 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:
[
  1
  "MAINTENANCE_MODE"
]
4 0.19 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:
[
  "test.kursimple.de"
]
5 0.19 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.subdomain = ? LIMIT 1
Parameters:
[
  "test"
]
6 0.18 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:
[
  1
  "THEME_NAME"
]
7 0.51 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:
[
  ""
]
8 0.24 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:
[
  "test.kursimple.de"
]
9 0.21 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.subdomain = ? LIMIT 1
Parameters:
[
  "test"
]
10 1.92 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) GROUP BY c0_.id ORDER BY c3_.start ASC LIMIT 100
Parameters:
[
  1
  1
  "2026-05-20 10:57:06"
]
11 0.55 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:
[
  5
]
12 0.44 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:
[
  6
]
13 0.22 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:
[
  9
]
14 0.15 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:
[
  3
]
15 0.19 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:
[
  11
]
16 0.13 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:
[
  4
]
17 0.20 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:
[
  8
]
18 0.15 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:
[
  1
]
19 0.17 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:
[
  12
]
20 0.13 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:
[
  2
]
21 0.23 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:
[
  10
]
22 0.19 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:
[
  3
]
23 0.36 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:
[
  7
]
24 0.17 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:
[
  30
]
25 0.12 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:
[
  16
]
26 0.15 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:
[
  26
]
27 0.12 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:
[
  12
]
28 0.38 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:
[
  27
]
29 0.13 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:
[
  13
]
30 0.16 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:
[
  29
]
31 0.14 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:
[
  15
]
32 0.19 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:
[
  28
]
33 0.15 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:
[
  14
]
34 0.16 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:
[
  2
]
35 1.50 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) GROUP BY c0_.id ORDER BY c3_.start ASC
Parameters:
[
  1
  1
  "2026-05-20 10:57:06"
]
36 3.78 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  23
]
37 0.18 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  27
]
38 0.17 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  24
]
39 0.16 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  31
]
40 0.12 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  25
]
41 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  26
]
42 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  29
]
43 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  30
]
44 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  118
]
45 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  112
]
46 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  106
]
47 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  130
]
48 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  124
]
49 0.13 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  131
]
50 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  125
]
51 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  119
]
52 0.09 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  113
]
53 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  107
]
54 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  132
]
55 0.12 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  126
]
56 0.11 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  120
]
57 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  114
]
58 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  108
]
59 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  42
]
60 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  115
]
61 0.13 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  109
]
62 0.14 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  133
]
63 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  127
]
64 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  121
]
65 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  45
]
66 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  134
]
67 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  128
]
68 0.13 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  122
]
69 0.11 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  116
]
70 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  110
]
71 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  135
]
72 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  129
]
73 0.09 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  123
]
74 0.11 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  117
]
75 0.12 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  111
]
76 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  43
]
77 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  44
]
78 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  40
]
79 0.10 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  37
]
80 0.31 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  53
]
81 0.17 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  41
]
82 0.13 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  51
]
83 0.11 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  57
]
84 0.14 ms
SELECT t0.course_occurrence_id AS course_occurrence_id_1, t0.speaker_id AS speaker_id_2, t0.client_id AS client_id_3 FROM course_occurrence_speaker t0 WHERE t0.course_occurrence_id = ?
Parameters:
[
  55
]
85 0.23 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.client_id = ?
Parameters:
[
  1
]
86 0.30 ms
SELECT v0_.id AS id_0, v0_.created AS created_1, v0_.modified AS modified_2, v0_.name AS name_3, v0_.postalcode AS postalcode_4, v0_.city AS city_5, v0_.street AS street_6, v0_.street_number AS street_number_7, v0_.geo_latitude AS geo_latitude_8, v0_.geo_longitude AS geo_longitude_9, v0_.client_id AS client_id_10 FROM venue v0_ LEFT JOIN client c1_ ON v0_.client_id = c1_.id WHERE c1_.id = ?
Parameters:
[
  1
]
87 0.31 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.slug AS slug_4, t0.name AS name_5, t0.client_id AS client_id_6 FROM course_type t0 WHERE t0.client_id = ?
Parameters:
[
  1
]
88 0.53 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:
[
  "test.kursimple.de"
]
89 0.19 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.subdomain = ? LIMIT 1
Parameters:
[
  "test"
]
90 0.28 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:
[
  1
  "THEME_NAME"
]
91 0.54 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:
[
  1
  "THEME_NAME"
]
92 0.51 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:
[
  5
]
93 0.48 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  23
]
94 1.19 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:
[
  9
]
95 0.35 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  27
]
96 0.20 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:
[
  11
]
97 0.24 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  24
]
98 0.18 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:
[
  8
]
99 0.26 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  31
]
100 0.17 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:
[
  12
]
101 0.26 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  25
]
102 0.17 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:
[
  10
]
103 0.24 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  26
]
104 0.18 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:
[
  3
]
105 0.23 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  29
]
106 0.20 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:
[
  7
]
107 0.15 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  30
]
108 0.14 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:
[
  30
]
109 0.15 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  130
]
110 0.13 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:
[
  26
]
111 0.14 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  106
]
112 0.15 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:
[
  27
]
113 0.13 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  112
]
114 0.13 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:
[
  29
]
115 0.31 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  124
]
116 0.16 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:
[
  28
]
117 0.17 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  118
]
118 0.15 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  113
]
119 0.17 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  107
]
120 0.18 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  119
]
121 0.18 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  131
]
122 0.18 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  125
]
123 0.18 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  108
]
124 0.17 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  114
]
125 0.15 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  120
]
126 0.14 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  126
]
127 0.19 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  132
]
128 0.19 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  42
]
129 0.16 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  127
]
130 0.15 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  133
]
131 0.15 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  109
]
132 0.13 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  121
]
133 0.13 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  115
]
134 0.53 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  45
]
135 0.22 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  110
]
136 0.20 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  116
]
137 0.16 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  122
]
138 0.17 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  128
]
139 0.19 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  134
]
140 0.21 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  117
]
141 0.18 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  123
]
142 0.18 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  129
]
143 0.23 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  135
]
144 0.16 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  111
]
145 0.23 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  43
]
146 0.27 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  44
]
147 0.19 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  40
]
148 0.23 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  37
]
149 0.26 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  53
]
150 0.24 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  51
]
151 0.25 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  41
]
152 0.20 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  57
]
153 0.21 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:
[
  2
]
154 0.26 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.start AS start_4, t0.end AS end_5, t0.note AS note_6, t0.availability AS availability_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:
[
  55
]

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 298
App\Entity\CourseOccurrence 49
App\Entity\Course 14
App\Entity\Category 12
App\Entity\CourseImage 8
App\Entity\Venue 7
App\Entity\CourseType 4
App\User\Entity\Client 1
App\Entity\ClientConfigVariable 1