Query Metrics
21
Database Queries
7
Different statements
15.27 ms
Query time
0
Invalid entities
Grouped Statements
dplan connection
| Time▼ | Count | Info |
|---|---|---|
|
9.68 ms (63.37%) |
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"
]
|
|
2.72 ms (17.83%) |
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.00 ms (6.57%) |
1 |
SELECT t0_._o_id AS sclr_0, t0_._o_name AS sclr_1, t0_.data_protection AS sclr_2 FROM _orga t0_ LEFT JOIN relation_customer_orga_orga_type r1_ ON t0_._o_id = r1_._o_id LEFT JOIN _orga_type t2_ ON r1_._ot_id = t2_._ot_id WHERE t2_._ot_name = ? AND t0_._o_deleted = ? AND r1_.status = ? AND r1_._c_id = ? AND t0_.data_protection <> ? ORDER BY t0_._o_name ASC
Parameters:
[ "OLAUTH" 0 "accepted" "8e4172c6-ada2-3352-a3ec-f585a3969933" "" ] |
|
0.55 ms (3.60%) |
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"
]
|
|
0.53 ms (3.49%) |
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.45 ms (2.94%) |
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.34 ms (2.21%) |
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
default entity manager
install entity manager
No loaded entities.