GET https://test.kursimple.de/frontend/course/?groupBy=venue

Query Metrics

160 Database Queries
15 Different statements
31.66 ms Query time
0 Invalid entities
394 Managed entities

Queries

Group similar statements

# Time Info
1 0.75 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.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.subdomain = ? LIMIT 1
Parameters:
[
  "test"
]
3 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:
[
  1
  "MAINTENANCE_MODE"
]
4 0.17 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.17 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.17 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.22 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.20 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.34 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.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, 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 12:27:06"
]
11 0.43 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.19 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.18 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.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:
[
  3
]
15 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:
[
  11
]
16 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:
[
  4
]
17 0.18 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.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:
[
  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.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:
[
  10
]
22 0.18 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.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:
[
  7
]
24 0.18 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
]
25 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
]
26 0.18 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
]
27 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:
[
  14
]
28 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
]
29 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
]
30 0.18 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
]
31 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
]
32 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
]
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:
[
  16
]
34 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:
[
  2
]
35 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.postalcode AS postalcode_5, t0.city AS city_6, t0.street AS street_7, t0.street_number AS street_number_8, t0.geo_latitude AS geo_latitude_9, t0.geo_longitude AS geo_longitude_10, t0.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters:
[
  3
]
36 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.postalcode AS postalcode_5, t0.city AS city_6, t0.street AS street_7, t0.street_number AS street_number_8, t0.geo_latitude AS geo_latitude_9, t0.geo_longitude AS geo_longitude_10, t0.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters:
[
  2
]
37 0.16 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.postalcode AS postalcode_5, t0.city AS city_6, t0.street AS street_7, t0.street_number AS street_number_8, t0.geo_latitude AS geo_latitude_9, t0.geo_longitude AS geo_longitude_10, t0.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters:
[
  5
]
38 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.postalcode AS postalcode_5, t0.city AS city_6, t0.street AS street_7, t0.street_number AS street_number_8, t0.geo_latitude AS geo_latitude_9, t0.geo_longitude AS geo_longitude_10, t0.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters:
[
  4
]
39 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.postalcode AS postalcode_5, t0.city AS city_6, t0.street AS street_7, t0.street_number AS street_number_8, t0.geo_latitude AS geo_latitude_9, t0.geo_longitude AS geo_longitude_10, t0.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters:
[
  1
]
40 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.postalcode AS postalcode_5, t0.city AS city_6, t0.street AS street_7, t0.street_number AS street_number_8, t0.geo_latitude AS geo_latitude_9, t0.geo_longitude AS geo_longitude_10, t0.client_id AS client_id_11 FROM venue t0 WHERE t0.id = ?
Parameters:
[
  6
]
41 1.46 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 12:27:06"
]
42 0.19 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
]
43 0.15 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
]
44 0.15 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
]
45 0.19 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
]
46 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:
[
  25
]
47 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:
[
  26
]
48 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:
[
  29
]
49 0.15 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
]
50 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:
[
  130
]
51 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:
[
  124
]
52 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:
[
  118
]
53 0.15 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
]
54 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:
[
  106
]
55 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:
[
  131
]
56 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:
[
  125
]
57 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:
[
  119
]
58 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:
[
  113
]
59 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:
[
  107
]
60 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:
[
  132
]
61 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:
[
  126
]
62 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:
[
  120
]
63 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:
[
  114
]
64 0.20 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
]
65 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:
[
  42
]
66 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:
[
  127
]
67 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:
[
  121
]
68 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:
[
  115
]
69 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:
[
  109
]
70 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
]
71 0.15 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
]
72 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:
[
  134
]
73 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:
[
  128
]
74 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:
[
  122
]
75 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:
[
  116
]
76 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:
[
  110
]
77 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:
[
  135
]
78 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:
[
  129
]
79 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:
[
  123
]
80 0.15 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
]
81 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:
[
  111
]
82 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:
[
  43
]
83 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:
[
  44
]
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:
[
  40
]
85 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:
[
  37
]
86 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:
[
  53
]
87 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:
[
  41
]
88 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:
[
  51
]
89 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:
[
  57
]
90 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
]
91 0.17 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
]
92 0.23 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
]
93 0.16 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
]
94 0.31 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"
]
95 0.18 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"
]
96 0.19 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"
]
97 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:
[
  1
  "THEME_NAME"
]
98 0.30 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
]
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:
[
  112
]
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:
[
  28
]
101 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
]
102 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:
[
  29
]
103 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:
[
  124
]
104 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:
[
  26
]
105 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:
[
  106
]
106 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:
[
  30
]
107 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:
[
  130
]
108 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:
[
  113
]
109 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:
[
  107
]
110 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:
[
  119
]
111 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
]
112 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:
[
  125
]
113 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:
[
  108
]
114 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
]
115 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:
[
  120
]
116 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:
[
  126
]
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:
[
  132
]
118 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:
[
  109
]
119 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:
[
  115
]
120 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:
[
  121
]
121 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:
[
  133
]
122 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:
[
  127
]
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:
[
  110
]
124 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:
[
  116
]
125 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:
[
  122
]
126 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:
[
  128
]
127 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:
[
  134
]
128 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:
[
  117
]
129 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
]
130 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:
[
  129
]
131 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:
[
  135
]
132 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:
[
  111
]
133 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:
[
  12
]
134 0.29 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
]
135 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:
[
  43
]
136 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:
[
  53
]
137 0.22 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
]
138 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:
[
  27
]
139 0.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:
[
  10
]
140 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:
[
  26
]
141 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:
[
  44
]
142 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
]
143 0.24 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
]
144 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:
[
  55
]
145 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:
[
  11
]
146 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:
[
  24
]
147 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:
[
  7
]
148 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:
[
  30
]
149 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:
[
  45
]
150 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:
[
  40
]
151 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:
[
  57
]
152 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:
[
  5
]
153 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:
[
  23
]
154 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:
[
  8
]
155 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:
[
  31
]
156 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:
[
  3
]
157 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:
[
  29
]
158 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:
[
  42
]
159 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:
[
  37
]
160 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:
[
  51
]

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