GET http://diplanbau-dev-debug-docker.demos-europe.eu/connect/keycloak_ozg

Query Metrics

5 Database Queries
4 Different statements
2.72 ms Query time
0 Invalid entities

Queries

Group similar statements

dplan connection

# Time Info
1 0.51 ms
SELECT t0._c_id AS _c_id_1, t0.imprint AS imprint_2, t0.data_protection AS data_protection_3, t0.terms_of_use AS terms_of_use_4, t0.xplanning AS xplanning_5, t0.map_attribution AS map_attribution_6, t0.base_layer_url AS base_layer_url_7, t0.base_layer_layers AS base_layer_layers_8, t0.accessibility_explanation AS accessibility_explanation_9, t0.sign_language_overview_description AS sign_language_overview_description_10, t0.simple_language_overview_description AS simple_language_overview_description_11, t0._c_name AS _c_name_12, t0._c_subdomain AS _c_subdomain_13, t0._procedure AS _procedure_14, t0.branding_id AS branding_id_15 FROM customer t0 WHERE t0._c_subdomain = ? LIMIT 1
Parameters:
[
  "diplanbau-dev-debug-docker"
]
2 0.57 ms
SELECT t0_._r_id AS _r_id_0, t0_._r_code AS _r_code_1, t0_._r_group_code AS _r_group_code_2, t0_._r_group_name AS _r_group_name_3 FROM _role t0_ WHERE t0_._r_code IN (?)
Parameters:
[
  "RGUEST"
]
3 0.36 ms
SELECT t0.id AS id_1, t0.permission AS permission_2, t0.creation_date AS creation_date_3, t0.modification_date AS modification_date_4, t0.orga_id AS orga_id_5, t0.role_id AS role_id_6, t0.customer_id AS customer_id_7 FROM access_control t0 WHERE t0.role_id IN (?) AND t0.orga_id IN (?) AND t0.customer_id IN (?)
Parameters:
[
  "71a2ebbc-0968-11e1-9d8e-1c64a3042bca"
  "cdec5e4b-3f06-11e4-a6a8-005056ae0004"
  null
]
4 0.78 ms
SELECT t0._c_id AS _c_id_1, t0.imprint AS imprint_2, t0.data_protection AS data_protection_3, t0.terms_of_use AS terms_of_use_4, t0.xplanning AS xplanning_5, t0.map_attribution AS map_attribution_6, t0.base_layer_url AS base_layer_url_7, t0.base_layer_layers AS base_layer_layers_8, t0.accessibility_explanation AS accessibility_explanation_9, t0.sign_language_overview_description AS sign_language_overview_description_10, t0.simple_language_overview_description AS simple_language_overview_description_11, t0._c_name AS _c_name_12, t0._c_subdomain AS _c_subdomain_13, t0._procedure AS _procedure_14, t0.branding_id AS branding_id_15 FROM customer t0 WHERE t0._c_subdomain = ? LIMIT 1
Parameters:
[
  "sh"
]
5 0.49 ms
SELECT t0.id AS id_1, t0.keycloak_client_id AS keycloak_client_id_2, t0.keycloak_client_secret AS keycloak_client_secret_3, t0.keycloak_auth_server_url AS keycloak_auth_server_url_4, t0.keycloak_realm AS keycloak_realm_5, t0.keycloak_logout_route AS keycloak_logout_route_6, t0.customer_id AS customer_id_7, t0.default_organisation_id AS default_organisation_id_8 FROM customer_oauth_config t0 WHERE t0.customer_id = ? LIMIT 1
Parameters:
[
  "8e4172c6-ada2-3352-a3ec-f585a3969933"
]

Database Connections

Name Service
dplan doctrine.dbal.dplan_connection
dplan_install doctrine.dbal.dplan_install_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
install doctrine.orm.install_entity_manager

Second Level Cache

Second Level Cache is not enabled.