Symfony Profiler

Query Metrics

43 Database Queries

17 Different statements

33.50 ms Query time

0 Invalid entities

37 Managed entities

Queries


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
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
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
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
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
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
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
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
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, c0_.id ASC LIMIT 100
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, c0_.id ASC
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 = ?
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 = ?
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 = ?
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
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
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
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
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
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
SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC
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
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.slug AS slug_5, t0.region_name AS region_name_6, t0.is_active AS is_active_7, t0.show_in_navigation AS show_in_navigation_8, t0.sort_order AS sort_order_9, t0.client_id AS client_id_10 FROM dynamic_page t0 WHERE t0.client_id = ? AND t0.is_active = ? AND t0.show_in_navigation = ? ORDER BY t0.sort_order ASC
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'test_back' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'test_back'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT * FROM doctrine_migration_versions
SELECT DATABASE()
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
SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC
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
SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC
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
SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC
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
SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC

#▲	Time	Info
1	0.99 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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
2	0.72 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: [`95 "MAINTENANCE_MODE"`] View formatted query View runnable query Explain query 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 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 = 95 AND t0.variableKey = 'MAINTENANCE_MODE' LIMIT 1;
3	0.27 ms	SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.street AS street_5, t0.street_number AS street_number_6, t0.addressAddition AS addressAddition_7, t0.postalcode AS postalcode_8, t0.city AS city_9, t0.country AS country_10, t0.email AS email_11, t0.web AS web_12, t0.phone AS phone_13, t0.fax AS fax_14, t0.from_email AS from_email_15, t0.logo_path AS logo_path_16, t0.subdomain AS subdomain_17, t0.custom_domain AS custom_domain_18, t0.keycloak_client_id AS keycloak_client_id_19, t0.keycloakGroupId AS keycloakGroupId_20 FROM client t0 WHERE t0.custom_domain = ? LIMIT 1 Parameters: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
4	0.20 ms	SELECT t0.id AS id_1, t0.variableKey AS variableKey_2, t0.variableValue AS variableValue_3, t0.variableType AS variableType_4, t0.description AS description_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8 FROM client_config_variable t0 WHERE t0.client_id = ? AND t0.variableKey = ? LIMIT 1 Parameters: [`95 "THEME_NAME"`] View formatted query View runnable query Explain query 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 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 = 95 AND t0.variableKey = 'THEME_NAME' LIMIT 1;
5	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.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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
6	0.20 ms	SELECT t0.id AS id_1, t0.variableKey AS variableKey_2, t0.variableValue AS variableValue_3, t0.variableType AS variableType_4, t0.description AS description_5, t0.created AS created_6, t0.modified AS modified_7, t0.client_id AS client_id_8 FROM client_config_variable t0 WHERE t0.client_id = ? AND t0.variableKey = ? LIMIT 1 Parameters: [`95 "THEME_NAME"`] View formatted query View runnable query Explain query 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 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 = 95 AND t0.variableKey = 'THEME_NAME' LIMIT 1;
7	0.61 ms	SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.session_id AS session_id_4, t0.customer_id AS customer_id_5, t0.client_id AS client_id_6 FROM cart t0 WHERE t0.session_id = ? LIMIT 1 Parameters: [`""`] View formatted query View runnable query Explain query 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 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;
8	0.39 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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
9	7.76 ms	SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.modified AS modified_2, c0_.published AS published_3, c0_.start AS start_4, c0_.end AS end_5, c0_.slots AS slots_6, c0_.code AS code_7, c0_.reservation_allowed AS reservation_allowed_8, c0_.booked_slots AS booked_slots_9, c0_.price AS price_10, c0_.tax_rate AS tax_rate_11, c0_.material_cost AS material_cost_12, c0_.number AS number_13, c0_.client_id AS client_id_14, c0_.venueId AS venueId_15, c0_.venueRoomId AS venueRoomId_16, c0_.courseId AS courseId_17 FROM course_occurrence c0_ LEFT JOIN course c1_ ON c0_.courseId = c1_.id LEFT JOIN client c2_ ON c1_.client_id = c2_.id LEFT JOIN course_occurrence_time c3_ ON c0_.id = c3_.occurrenceId LEFT JOIN course_text c4_ ON c1_.id = c4_.course_id WHERE c2_.id = ? AND c0_.published = ? AND (c3_.end > ? OR c3_.end IS NULL) GROUP BY c0_.id ORDER BY c3_.start ASC, c0_.id ASC LIMIT 100 Parameters: [`95 1 "2026-08-07 22:17:24"`] View formatted query View runnable query Explain query 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, c0_.id ASC LIMIT 100 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 = 95 AND c0_.published = 1 AND (c3_.end > '2026-08-07 22:17:24' OR c3_.end IS NULL) GROUP BY c0_.id ORDER BY c3_.start ASC, c0_.id ASC LIMIT 100;
10	1.57 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, c0_.id ASC Parameters: [`95 1 "2026-08-07 22:17:24"`] View formatted query View runnable query Explain query 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, c0_.id ASC 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 = 95 AND c0_.published = 1 AND (c3_.end > '2026-08-07 22:17:24' OR c3_.end IS NULL) GROUP BY c0_.id ORDER BY c3_.start ASC, c0_.id ASC;
11	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.client_id AS client_id_5 FROM category t0 WHERE t0.client_id = ? Parameters: [`95`] View formatted query View runnable query Explain query 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 = ? 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 = 95;
12	0.28 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: [`95`] View formatted query View runnable query Explain query 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 = ? 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 = 95;
13	0.32 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: [`95`] View formatted query View runnable query Explain query 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 = ? 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 = 95;
14	0.38 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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
15	0.34 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: [`95 "THEME_NAME"`] View formatted query View runnable query Explain query 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 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 = 95 AND t0.variableKey = 'THEME_NAME' LIMIT 1;
16	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: [`95 "THEME_NAME"`] View formatted query View runnable query Explain query 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 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 = 95 AND t0.variableKey = 'THEME_NAME' LIMIT 1;
17	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: [`95 "MENUE_FRONTEND_VENUE"`] View formatted query View runnable query Explain query 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 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 = 95 AND t0.variableKey = 'MENUE_FRONTEND_VENUE' LIMIT 1;
18	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: [`95 "MENUE_FRONTEND_SPEAKER"`] View formatted query View runnable query Explain query 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 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 = 95 AND t0.variableKey = 'MENUE_FRONTEND_SPEAKER' LIMIT 1;
19	0.40 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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
20	2.76 ms	SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC Parameters: [`95 "kad-oase" "header_logo_area"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = 95 AND t0_.theme_name = 'kad-oase' AND t0_.region = 'header_logo_area' ORDER BY t0_.sort_order ASC;
21	0.55 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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
22	2.74 ms	SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.slug AS slug_5, t0.region_name AS region_name_6, t0.is_active AS is_active_7, t0.show_in_navigation AS show_in_navigation_8, t0.sort_order AS sort_order_9, t0.client_id AS client_id_10 FROM dynamic_page t0 WHERE t0.client_id = ? AND t0.is_active = ? AND t0.show_in_navigation = ? ORDER BY t0.sort_order ASC Parameters: [`95 1 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.slug AS slug_5, t0.region_name AS region_name_6, t0.is_active AS is_active_7, t0.show_in_navigation AS show_in_navigation_8, t0.sort_order AS sort_order_9, t0.client_id AS client_id_10 FROM dynamic_page t0 WHERE t0.client_id = ? AND t0.is_active = ? AND t0.show_in_navigation = ? ORDER BY t0.sort_order ASC SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.title AS title_4, t0.slug AS slug_5, t0.region_name AS region_name_6, t0.is_active AS is_active_7, t0.show_in_navigation AS show_in_navigation_8, t0.sort_order AS sort_order_9, t0.client_id AS client_id_10 FROM dynamic_page t0 WHERE t0.client_id = 95 AND t0.is_active = 1 AND t0.show_in_navigation = 1 ORDER BY t0.sort_order ASC;
23	0.40 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
24	1.38 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"test_back"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'test_back' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
25	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
26	0.89 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"test_back"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'test_back' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
27	0.31 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
28	1.38 ms	SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"test_back" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'test_back' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
29	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
30	1.50 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'test_back' / ORDER BY k.ORDINAL_POSITION Parameters: [`"test_back" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'test_back' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'test_back' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'test_back' / ORDER BY k.ORDINAL_POSITION;
31	2.14 ms	SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'test_back' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"test_back" "test_back" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'test_back' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'test_back' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'test_back' AND t.TABLE_SCHEMA = 'test_back' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
32	0.22 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
33	0.31 ms	SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"test_back" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'test_back' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
34	0.21 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
35	0.32 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
36	0.69 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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
37	0.37 ms	SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC Parameters: [`95 "kad-oase" "content_before_main"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = 95 AND t0_.theme_name = 'kad-oase' AND t0_.region = 'content_before_main' ORDER BY t0_.sort_order ASC;
38	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.custom_domain = ? LIMIT 1 Parameters: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
39	0.28 ms	SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC Parameters: [`95 "kad-oase" "hero_section"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = 95 AND t0_.theme_name = 'kad-oase' AND t0_.region = 'hero_section' ORDER BY t0_.sort_order ASC;
40	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.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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
41	0.27 ms	SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC Parameters: [`95 "kad-oase" "content_after_main"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = 95 AND t0_.theme_name = 'kad-oase' AND t0_.region = 'content_after_main' ORDER BY t0_.sort_order ASC;
42	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.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: [`"kad-oase.de"`] View formatted query View runnable query Explain query 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 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 = 'kad-oase.de' LIMIT 1;
43	0.27 ms	SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC Parameters: [`95 "kad-oase" "footer_contact_area"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = ? AND t0_.theme_name = ? AND t0_.region = ? ORDER BY t0_.sort_order ASC SELECT t0_.id AS id_0, t0_.theme_name AS theme_name_1, t0_.region AS region_2, t0_.type AS type_3, t0_.content AS content_4, t0_.sort_order AS sort_order_5, t0_.client_id AS client_id_6 FROM theme_block t0_ WHERE t0_.client_id = 95 AND t0_.theme_name = 'kad-oase' AND t0_.region = 'footer_contact_area' ORDER BY t0_.sort_order ASC;

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\Category	15
App\Entity\Venue	8
App\Entity\CourseType	5
App\Entity\ClientConfigVariable	4
App\Entity\DynamicPage	2
App\Entity\ThemeBlock	2
App\User\Entity\Client	1

Entities Mapping

Class	Mapping errors
App\Commons\Entity\GenericEntity	No errors.
App\User\Entity\Client	No errors.
App\Entity\ClientConfigVariable	No errors.
App\Entity\Cart	No errors.
App\Entity\Person	No errors.
App\Entity\CourseOccurrence	No errors.
App\Entity\Course	No errors.
App\Entity\CourseOccurrenceTime	No errors.
App\Entity\CourseText	No errors.
App\Entity\Venue	No errors.
App\Entity\VenueRoom	No errors.
App\Entity\Category	No errors.
App\Entity\VenueDocument	No errors.
App\Entity\Image	No errors.
App\Entity\VenueImage	No errors.
App\Entity\VenueProvider	No errors.
App\Entity\CourseType	No errors.
App\Entity\ThemeBlock	No errors.
App\Entity\DynamicPage	No errors.
App\Entity\CartItem	No errors.
App\User\Entity\User	No errors.
App\Entity\Order	No errors.
App\Entity\CustomerHistoryEntry	No errors.
App\Entity\CustomerDocument	No errors.
App\Entity\Speaker	No errors.
App\Entity\ManualNewsletter	No errors.
App\Entity\InvoiceItemAttendees	No errors.
App\Entity\Invoice	No errors.
App\Entity\TagsPerson	No errors.
App\Entity\CourseOccurrenceSpeaker	No errors.
App\Entity\WaitItem	No errors.
App\Entity\OrderItem	No errors.
App\Entity\OccurrenceProvider	No errors.
App\Entity\CourseSubscription	No errors.
App\Entity\CourseImage	No errors.
App\Entity\CourseSeries	No errors.
App\Entity\CourseProvider	No errors.
App\Entity\Voucher	No errors.
App\Entity\CustomForm	No errors.
App\Entity\Provider	No errors.
App\Entity\Withdrawal	No errors.
App\Entity\EmailHistoryEntry	No errors.
App\Entity\SpeakerImage	No errors.
App\Entity\SpeakerText	No errors.
App\Entity\SpeakerProvider	No errors.
App\Entity\InvoiceItem	No errors.
App\Entity\InvoicePayment	No errors.
App\Entity\InvoiceReminder	No errors.
App\Entity\Tags	No errors.
App\Entity\OrderItemPerson	No errors.
App\Entity\CourseSubscriptionBooking	No errors.
App\Entity\CustomFormSubmission	No errors.
App\Entity\VoucherUsage	No errors.
App\Entity\HelpContentMedia	No errors.
App\Entity\MailTemplateAttachment	No errors.
App\Entity\Newsletter	No errors.
App\Entity\CourseData	No errors.
App\Entity\SystemAnnouncement	No errors.
App\Entity\DemoRequest	No errors.
App\Entity\PresenceReason	No errors.
App\Entity\MailTemplate	No errors.
App\Entity\CKImage	No errors.
App\Entity\HelpContent	No errors.
App\Entity\Textblocks	No errors.
App\Entity\CourseField	No errors.
App\Entity\SearchIndexEntry	No errors.
App\Entity\ClientConfig	No errors.
App\Entity\Attachment	No errors.
App\Entity\ProtocolEntry	No errors.
App\Entity\StartEnd	No errors.
App\Entity\Presence	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://kad-oase.de/frontend/course/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping