Symfony Profiler

Query Metrics

40 Database Queries

18 Different statements

23.53 ms Query time

0 Invalid entities

14 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.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 t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.price AS price_4, t0.tax_rate AS tax_rate_5, t0.quantity AS quantity_6, t0.cancelled_quantity AS cancelled_quantity_7, t0.is_free AS is_free_8, t0.name AS name_9, t0.description AS description_10, t0.status AS status_11, t0.voucher_discount AS voucher_discount_12, t0.form_token AS form_token_13, t0.client_id AS client_id_14, t0._order_id AS _order_id_15, t0.course_occurrence_id AS course_occurrence_id_16, t0.course_occurrence_time_id AS course_occurrence_time_id_17, t0.course_subscription_booking_id AS course_subscription_booking_id_18, t0.course_item_id AS course_item_id_19, t0.voucher_id AS voucher_id_20 FROM customer_order_item t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.number AS number_4, t0.order_date AS order_date_5, t0.customer_title AS customer_title_6, t0.customer_salutation AS customer_salutation_7, t0.customer_member AS customer_member_8, t0.customer_company AS customer_company_9, t0.customer_firstname AS customer_firstname_10, t0.customer_lastname AS customer_lastname_11, t0.customer_street AS customer_street_12, t0.customer_street_number AS customer_street_number_13, t0.customer_postalcode AS customer_postalcode_14, t0.customer_city AS customer_city_15, t0.customer_contact_email AS customer_contact_email_16, t0.customer_country AS customer_country_17, t0.customer_phone AS customer_phone_18, t0.customer_age_group AS customer_age_group_19, t0.status AS status_20, t0.iban AS iban_21, t0.bic AS bic_22, t0.bank AS bank_23, t0.payment_type AS payment_type_24, t0.customer_comment AS customer_comment_25, t0.voucher_code AS voucher_code_26, t0.voucher_discount AS voucher_discount_27, t0.customer_id AS customer_id_28, t0.client_id AS client_id_29, t0.person_id AS person_id_30, t0.invoice_recipient_id AS invoice_recipient_id_31 FROM customer_order t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.published AS published_4, t0.start AS start_5, t0.end AS end_6, t0.slots AS slots_7, t0.code AS code_8, t0.reservation_allowed AS reservation_allowed_9, t0.booked_slots AS booked_slots_10, t0.price AS price_11, t0.tax_rate AS tax_rate_12, t0.material_cost AS material_cost_13, t0.number AS number_14, t0.client_id AS client_id_15, t0.venueId AS venueId_16, t0.venueRoomId AS venueRoomId_17, t0.courseId AS courseId_18 FROM course_occurrence t0 WHERE t0.id = ?
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, t0.custom_form_id AS custom_form_id_25 FROM course t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.email_text AS email_text_5, t0.email_item_link_text AS email_item_link_text_6, t0.form_schema AS form_schema_7, t0.is_active AS is_active_8, t0.client_id AS client_id_9 FROM custom_form t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.data AS data_4, t0.submitted_at AS submitted_at_5, t0.client_id AS client_id_6, t0.custom_form_id AS custom_form_id_7, t0.order_item_id AS order_item_id_8 FROM custom_form_submission t0 WHERE t0.order_item_id = ? AND t0.custom_form_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 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

#▲	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.38 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;
3	0.58 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.22 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.52 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: [`"ad221102d2ea5d2df7a5754063e84d5b"`] 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 = 'ad221102d2ea5d2df7a5754063e84d5b' LIMIT 1;
6	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;
7	0.36 ms	SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.price AS price_4, t0.tax_rate AS tax_rate_5, t0.quantity AS quantity_6, t0.cancelled_quantity AS cancelled_quantity_7, t0.is_free AS is_free_8, t0.name AS name_9, t0.description AS description_10, t0.status AS status_11, t0.voucher_discount AS voucher_discount_12, t0.form_token AS form_token_13, t0.client_id AS client_id_14, t0._order_id AS _order_id_15, t0.course_occurrence_id AS course_occurrence_id_16, t0.course_occurrence_time_id AS course_occurrence_time_id_17, t0.course_subscription_booking_id AS course_subscription_booking_id_18, t0.course_item_id AS course_item_id_19, t0.voucher_id AS voucher_id_20 FROM customer_order_item t0 WHERE t0.id = ? Parameters: [`100031808`] 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.price AS price_4, t0.tax_rate AS tax_rate_5, t0.quantity AS quantity_6, t0.cancelled_quantity AS cancelled_quantity_7, t0.is_free AS is_free_8, t0.name AS name_9, t0.description AS description_10, t0.status AS status_11, t0.voucher_discount AS voucher_discount_12, t0.form_token AS form_token_13, t0.client_id AS client_id_14, t0._order_id AS _order_id_15, t0.course_occurrence_id AS course_occurrence_id_16, t0.course_occurrence_time_id AS course_occurrence_time_id_17, t0.course_subscription_booking_id AS course_subscription_booking_id_18, t0.course_item_id AS course_item_id_19, t0.voucher_id AS voucher_id_20 FROM customer_order_item t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.price AS price_4, t0.tax_rate AS tax_rate_5, t0.quantity AS quantity_6, t0.cancelled_quantity AS cancelled_quantity_7, t0.is_free AS is_free_8, t0.name AS name_9, t0.description AS description_10, t0.status AS status_11, t0.voucher_discount AS voucher_discount_12, t0.form_token AS form_token_13, t0.client_id AS client_id_14, t0._order_id AS _order_id_15, t0.course_occurrence_id AS course_occurrence_id_16, t0.course_occurrence_time_id AS course_occurrence_time_id_17, t0.course_subscription_booking_id AS course_subscription_booking_id_18, t0.course_item_id AS course_item_id_19, t0.voucher_id AS voucher_id_20 FROM customer_order_item t0 WHERE t0.id = 100031808;
8	0.37 ms	SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.number AS number_4, t0.order_date AS order_date_5, t0.customer_title AS customer_title_6, t0.customer_salutation AS customer_salutation_7, t0.customer_member AS customer_member_8, t0.customer_company AS customer_company_9, t0.customer_firstname AS customer_firstname_10, t0.customer_lastname AS customer_lastname_11, t0.customer_street AS customer_street_12, t0.customer_street_number AS customer_street_number_13, t0.customer_postalcode AS customer_postalcode_14, t0.customer_city AS customer_city_15, t0.customer_contact_email AS customer_contact_email_16, t0.customer_country AS customer_country_17, t0.customer_phone AS customer_phone_18, t0.customer_age_group AS customer_age_group_19, t0.status AS status_20, t0.iban AS iban_21, t0.bic AS bic_22, t0.bank AS bank_23, t0.payment_type AS payment_type_24, t0.customer_comment AS customer_comment_25, t0.voucher_code AS voucher_code_26, t0.voucher_discount AS voucher_discount_27, t0.customer_id AS customer_id_28, t0.client_id AS client_id_29, t0.person_id AS person_id_30, t0.invoice_recipient_id AS invoice_recipient_id_31 FROM customer_order t0 WHERE t0.id = ? Parameters: [`100014863`] 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.number AS number_4, t0.order_date AS order_date_5, t0.customer_title AS customer_title_6, t0.customer_salutation AS customer_salutation_7, t0.customer_member AS customer_member_8, t0.customer_company AS customer_company_9, t0.customer_firstname AS customer_firstname_10, t0.customer_lastname AS customer_lastname_11, t0.customer_street AS customer_street_12, t0.customer_street_number AS customer_street_number_13, t0.customer_postalcode AS customer_postalcode_14, t0.customer_city AS customer_city_15, t0.customer_contact_email AS customer_contact_email_16, t0.customer_country AS customer_country_17, t0.customer_phone AS customer_phone_18, t0.customer_age_group AS customer_age_group_19, t0.status AS status_20, t0.iban AS iban_21, t0.bic AS bic_22, t0.bank AS bank_23, t0.payment_type AS payment_type_24, t0.customer_comment AS customer_comment_25, t0.voucher_code AS voucher_code_26, t0.voucher_discount AS voucher_discount_27, t0.customer_id AS customer_id_28, t0.client_id AS client_id_29, t0.person_id AS person_id_30, t0.invoice_recipient_id AS invoice_recipient_id_31 FROM customer_order t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.number AS number_4, t0.order_date AS order_date_5, t0.customer_title AS customer_title_6, t0.customer_salutation AS customer_salutation_7, t0.customer_member AS customer_member_8, t0.customer_company AS customer_company_9, t0.customer_firstname AS customer_firstname_10, t0.customer_lastname AS customer_lastname_11, t0.customer_street AS customer_street_12, t0.customer_street_number AS customer_street_number_13, t0.customer_postalcode AS customer_postalcode_14, t0.customer_city AS customer_city_15, t0.customer_contact_email AS customer_contact_email_16, t0.customer_country AS customer_country_17, t0.customer_phone AS customer_phone_18, t0.customer_age_group AS customer_age_group_19, t0.status AS status_20, t0.iban AS iban_21, t0.bic AS bic_22, t0.bank AS bank_23, t0.payment_type AS payment_type_24, t0.customer_comment AS customer_comment_25, t0.voucher_code AS voucher_code_26, t0.voucher_discount AS voucher_discount_27, t0.customer_id AS customer_id_28, t0.client_id AS client_id_29, t0.person_id AS person_id_30, t0.invoice_recipient_id AS invoice_recipient_id_31 FROM customer_order t0 WHERE t0.id = 100014863;
9	0.38 ms	SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.published AS published_4, t0.start AS start_5, t0.end AS end_6, t0.slots AS slots_7, t0.code AS code_8, t0.reservation_allowed AS reservation_allowed_9, t0.booked_slots AS booked_slots_10, t0.price AS price_11, t0.tax_rate AS tax_rate_12, t0.material_cost AS material_cost_13, t0.number AS number_14, t0.client_id AS client_id_15, t0.venueId AS venueId_16, t0.venueRoomId AS venueRoomId_17, t0.courseId AS courseId_18 FROM course_occurrence t0 WHERE t0.id = ? Parameters: [`100002370`] 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.published AS published_4, t0.start AS start_5, t0.end AS end_6, t0.slots AS slots_7, t0.code AS code_8, t0.reservation_allowed AS reservation_allowed_9, t0.booked_slots AS booked_slots_10, t0.price AS price_11, t0.tax_rate AS tax_rate_12, t0.material_cost AS material_cost_13, t0.number AS number_14, t0.client_id AS client_id_15, t0.venueId AS venueId_16, t0.venueRoomId AS venueRoomId_17, t0.courseId AS courseId_18 FROM course_occurrence t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.published AS published_4, t0.start AS start_5, t0.end AS end_6, t0.slots AS slots_7, t0.code AS code_8, t0.reservation_allowed AS reservation_allowed_9, t0.booked_slots AS booked_slots_10, t0.price AS price_11, t0.tax_rate AS tax_rate_12, t0.material_cost AS material_cost_13, t0.number AS number_14, t0.client_id AS client_id_15, t0.venueId AS venueId_16, t0.venueRoomId AS venueRoomId_17, t0.courseId AS courseId_18 FROM course_occurrence t0 WHERE t0.id = 100002370;
10	0.32 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, t0.custom_form_id AS custom_form_id_25 FROM course t0 WHERE t0.id = ? Parameters: [`100001536`] 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.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, t0.custom_form_id AS custom_form_id_25 FROM course t0 WHERE t0.id = ? 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, t0.custom_form_id AS custom_form_id_25 FROM course t0 WHERE t0.id = 100001536;
11	1.65 ms	SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.email_text AS email_text_5, t0.email_item_link_text AS email_item_link_text_6, t0.form_schema AS form_schema_7, t0.is_active AS is_active_8, t0.client_id AS client_id_9 FROM custom_form t0 WHERE t0.id = ? Parameters: [`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.name AS name_4, t0.email_text AS email_text_5, t0.email_item_link_text AS email_item_link_text_6, t0.form_schema AS form_schema_7, t0.is_active AS is_active_8, t0.client_id AS client_id_9 FROM custom_form t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.name AS name_4, t0.email_text AS email_text_5, t0.email_item_link_text AS email_item_link_text_6, t0.form_schema AS form_schema_7, t0.is_active AS is_active_8, t0.client_id AS client_id_9 FROM custom_form t0 WHERE t0.id = 1;
12	2.19 ms	SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.data AS data_4, t0.submitted_at AS submitted_at_5, t0.client_id AS client_id_6, t0.custom_form_id AS custom_form_id_7, t0.order_item_id AS order_item_id_8 FROM custom_form_submission t0 WHERE t0.order_item_id = ? AND t0.custom_form_id = ? LIMIT 1 Parameters: [`100031808 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.data AS data_4, t0.submitted_at AS submitted_at_5, t0.client_id AS client_id_6, t0.custom_form_id AS custom_form_id_7, t0.order_item_id AS order_item_id_8 FROM custom_form_submission t0 WHERE t0.order_item_id = ? AND t0.custom_form_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.created AS created_2, t0.modified AS modified_3, t0.data AS data_4, t0.submitted_at AS submitted_at_5, t0.client_id AS client_id_6, t0.custom_form_id AS custom_form_id_7, t0.order_item_id AS order_item_id_8 FROM custom_form_submission t0 WHERE t0.order_item_id = 100031808 AND t0.custom_form_id = 1 LIMIT 1;
13	0.41 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;
14	0.23 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;
15	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;
16	0.15 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;
17	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: [`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;
18	0.65 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;
19	1.70 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;
20	0.51 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;
21	1.88 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;
22	0.38 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
23	1.12 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;
24	0.13 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
25	0.55 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;
26	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
27	1.22 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';
28	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
29	1.20 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;
30	1.87 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;
31	0.15 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
32	0.36 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;
33	0.26 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;
34	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
35	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;
36	0.30 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;
37	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.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;
38	0.22 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;
39	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.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;
40	0.17 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\ClientConfigVariable	3
App\Entity\DynamicPage	2
App\User\Entity\Client	1
App\Entity\OrderItem	1
App\Entity\Order	1
App\Entity\CourseOccurrence	1
App\Entity\Person	1
App\Entity\Course	1
App\Entity\CourseType	1
App\Entity\CustomForm	1
App\Entity\CustomFormSubmission	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\OrderItem	No errors.
App\Entity\Order	No errors.
App\Entity\CourseOccurrence	No errors.
App\Entity\CourseOccurrenceTime	No errors.
App\Entity\CourseSubscriptionBooking	No errors.
App\Entity\Voucher	No errors.
App\Entity\OrderItemPerson	No errors.
App\Entity\CustomFormSubmission	No errors.
App\Entity\Invoice	No errors.
App\Entity\Withdrawal	No errors.
App\Entity\WaitItem	No errors.
App\Entity\Venue	No errors.
App\Entity\VenueRoom	No errors.
App\Entity\Course	No errors.
App\Entity\CourseOccurrenceSpeaker	No errors.
App\Entity\OccurrenceProvider	No errors.
App\Entity\CourseSubscription	No errors.
App\Entity\Category	No errors.
App\Entity\CourseSeries	No errors.
App\Entity\CourseType	No errors.
App\Entity\CustomForm	No errors.
App\Entity\Image	No errors.
App\Entity\CourseImage	No errors.
App\Entity\CourseText	No errors.
App\Entity\CourseProvider	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\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\TagsPerson	No errors.
App\Entity\VoucherUsage	No errors.
App\Entity\InvoicePayment	No errors.
App\Entity\InvoiceReminder	No errors.
App\Entity\InvoiceItem	No errors.
App\Entity\EmailHistoryEntry	No errors.
App\Entity\VenueDocument	No errors.
App\Entity\VenueImage	No errors.
App\Entity\VenueProvider	No errors.
App\Entity\Provider	No errors.
App\Entity\SpeakerImage	No errors.
App\Entity\SpeakerText	No errors.
App\Entity\SpeakerProvider	No errors.
App\Entity\Tags	No errors.
App\Entity\Attachment	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\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/formular/100031808/f44bc09c6c484e364abc266dcf27616ebce627ed6a961da0c68000fdff2e2ace

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping