GET http://diplanbau-dev-debug-docker.demos-europe.eu/news/6170625d-58eb-4c4a-8f3a-591e4ad0995f

Query Metrics

23 Database Queries
9 Different statements
21.08 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

dplan connection

Time Count Info
11.50 ms
(54.55%)
12
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"
]
3.76 ms
(17.82%)
4
SELECT c0_._c_id AS _c_id_0, c0_.imprint AS imprint_1, c0_.data_protection AS data_protection_2, c0_.terms_of_use AS terms_of_use_3, c0_.xplanning AS xplanning_4, c0_.map_attribution AS map_attribution_5, c0_.base_layer_url AS base_layer_url_6, c0_.base_layer_layers AS base_layer_layers_7, c0_.accessibility_explanation AS accessibility_explanation_8, c0_.sign_language_overview_description AS sign_language_overview_description_9, c0_.simple_language_overview_description AS simple_language_overview_description_10, c0_._c_name AS _c_name_11, c0_._c_subdomain AS _c_subdomain_12, c0_._procedure AS _procedure_13, c0_.branding_id AS branding_id_14 FROM customer c0_ WHERE c0_._c_id = ? LIMIT 1
Parameters:
[
  "8e4172c6-ada2-3352-a3ec-f585a3969933"
]
1.08 ms
(5.14%)
1
SELECT t0._c_id AS _c_id_1, t0._c_name AS _c_name_2, t0._c_title AS _c_title_3, t0._c_description AS _c_description_4, t0._c_picture AS _c_picture_5, t0._c_picture_title AS _c_picture_title_6, t0._c_enabled AS _c_enabled_7, t0._c_deleted AS _c_deleted_8, t0._c_create_date AS _c_create_date_9, t0._c_modify_date AS _c_modify_date_10, t0._c_delete_date AS _c_delete_date_11, t0.custom AS custom_12 FROM _category t0 INNER JOIN _platform_content_categories ON t0._c_id = _platform_content_categories._c_id WHERE _platform_content_categories._pc_id = ?
Parameters:
[
  "6170625d-58eb-4c4a-8f3a-591e4ad0995f"
]
1.08 ms
(5.12%)
1
SELECT t0._f_id AS _f_id_1, t0._f_ident AS _f_ident_2, t0._f_hash AS _f_hash_3, t0._f_name AS _f_name_4, t0._f_description AS _f_description_5, t0._f_path AS _f_path_6, t0._f_filename AS _f_filename_7, t0._f_tags AS _f_tags_8, t0._f_author AS _f_author_9, t0._f_application AS _f_application_10, t0._f_mimetype AS _f_mimetype_11, t0._f_created AS _f_created_12, t0._f_modified AS _f_modified_13, t0._f_valid_until AS _f_valid_until_14, t0._f_deleted AS _f_deleted_15, t0._f_stat_down AS _f_stat_down_16, t0._f_infected AS _f_infected_17, t0._f_last_v_scan AS _f_last_v_scan_18, t0._f_blocked AS _f_blocked_19, t0.size AS size_20, t0.procedure_id AS procedure_id_21 FROM _files t0 WHERE t0._f_ident = ?
Parameters:
[
  "d5badb1f-4690-4ac9-a8f6-de016909ef8b"
]
1.04 ms
(4.93%)
1
SELECT t0._r_id AS _r_id_1, t0._r_code AS _r_code_2, t0._r_group_code AS _r_group_code_3, t0._r_group_name AS _r_group_name_4 FROM _role t0 INNER JOIN _platform_content_roles ON t0._r_id = _platform_content_roles._r_id WHERE _platform_content_roles._pc_id = ?
Parameters:
[
  "6170625d-58eb-4c4a-8f3a-591e4ad0995f"
]
0.94 ms
(4.47%)
1
SELECT t0_._pc_id AS _pc_id_0, t0_._pc_type AS _pc_type_1, t0_._pc_title AS _pc_title_2, t0_._pc_description AS _pc_description_3, t0_._pc_text AS _pc_text_4, t0_._pc_picture AS _pc_picture_5, t0_._pc_picture_title AS _pc_picture_title_6, t0_._pc_pdf AS _pc_pdf_7, t0_._pc_pdf_title AS _pc_pdf_title_8, t0_._pc_enabled AS _pc_enabled_9, t0_._pc_deleted AS _pc_deleted_10, t0_._pc_create_date AS _pc_create_date_11, t0_._pc_modify_date AS _pc_modify_date_12, t0_._pc_delete_date AS _pc_delete_date_13, t0_.customer_id AS customer_id_14 FROM _platform_content t0_ WHERE t0_._pc_id = ? LIMIT 1
Parameters:
[
  "6170625d-58eb-4c4a-8f3a-591e4ad0995f"
]
0.62 ms
(2.95%)
1
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
]
0.62 ms
(2.95%)
1
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"
]
0.44 ms
(2.07%)
1
SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = ?
Parameters:
[
  "c2c5ce48-8af4-4887-aaea-bd5702496a9f"
]

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.

Entities Mapping