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

Query Metrics

100 Database Queries
11 Different statements
169.96 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

dplan connection

Time Count Info
92.75 ms
(54.57%)
39
SELECT t0._mls_id AS _mls_id_1, t0._p_id AS _p_id_2, t0._mls_context AS _mls_context_3, t0._mls_namespace AS _mls_namespace_4, t0._mls_idents AS _mls_idents_5, t0.customer_id AS customer_id_6 FROM _manual_list_sort t0 WHERE t0._mls_context = ? AND t0._p_id = ? AND t0._mls_namespace = ? AND t0.customer_id IS NULL LIMIT 1
Parameters:
[
  "faq:category:0c836d1e-934f-4d28-9c05-e7d3f7605544"
  "global"
  "faq"
]
41.55 ms
(24.45%)
29
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.text AS text_2, f0_.enabled AS enabled_3, f0_.create_date AS create_date_4, f0_.modify_date AS modify_date_5, f0_.faq_category_id AS faq_category_id_6 FROM faq f0_ LEFT JOIN faq_category f1_ ON f0_.faq_category_id = f1_.id LEFT JOIN faq_role f3_ ON f0_.id = f3_.faq_id LEFT JOIN _role t2_ ON t2_._r_id = f3_.role_id WHERE f0_.enabled = ? AND f1_.id = ? AND t2_._r_code IN (?) ORDER BY f0_.title ASC
Parameters:
[
  1
  "0c836d1e-934f-4d28-9c05-e7d3f7605544"
  "RGUEST"
]
16.78 ms
(9.87%)
10
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.text AS text_2, p0_.enabled AS enabled_3, p0_.create_date AS create_date_4, p0_.modify_date AS modify_date_5, p0_.platform_faq_category_id AS platform_faq_category_id_6 FROM platform_faq p0_ LEFT JOIN platform_faq_category p1_ ON p0_.platform_faq_category_id = p1_.id LEFT JOIN platform_faq_role p3_ ON p0_.id = p3_.platformFaq_id LEFT JOIN _role t2_ ON t2_._r_id = p3_.role_id WHERE p0_.enabled = ? AND p1_.id = ? AND t2_._r_code IN (?) ORDER BY p0_.title ASC
Parameters:
[
  1
  "91dc923c-0b84-3689-be1a-e6c7a761c3af"
  "RGUEST"
]
9.86 ms
(5.80%)
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.35 ms
(1.97%)
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"
]
2.33 ms
(1.37%)
1
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.type AS type_2, f0_.create_date AS create_date_3, f0_.modify_date AS modify_date_4, f0_.customer_id AS customer_id_5 FROM faq_category f0_ WHERE f0_.customer_id = ? ORDER BY f0_.title ASC
Parameters:
[
  "8e4172c6-ada2-3352-a3ec-f585a3969933"
]
0.97 ms
(0.57%)
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.79 ms
(0.46%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.create_date AS create_date_3, t0.modify_date AS modify_date_4 FROM platform_faq_category t0 ORDER BY t0.title ASC
Parameters:
[]
0.64 ms
(0.38%)
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.60 ms
(0.35%)
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
(0.20%)
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

Class Mapping errors
demosplan\DemosPlanCoreBundle\Entity\Procedure\Procedure No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Customer No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\AccessControl No errors.
demosplan\DemosPlanCoreBundle\Entity\Permission\UserAccessControl No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Orga No errors.
demosplan\DemosPlanCoreBundle\Entity\User\User No errors.
demosplan\DemosPlanCoreBundle\Entity\Branding No errors.
demosplan\DemosPlanCoreBundle\Entity\User\CustomerOAuthConfig No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Department No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaType No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Role No errors.
demosplan\DemosPlanCoreBundle\Entity\User\UserRoleInCustomer No errors.
demosplan\DemosPlanCoreBundle\Entity\CustomFields\CustomFieldConfiguration No errors.
demosplan\DemosPlanCoreBundle\Entity\EmailAddress No errors.
demosplan\DemosPlanCoreBundle\Entity\User\SupportContact No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Statement No errors.
demosplan\DemosPlanCoreBundle\Entity\ManualListSort No errors.
demosplan\DemosPlanCoreBundle\Entity\User\InstitutionTag No errors.
demosplan\DemosPlanCoreBundle\Entity\FileContainer No errors.
demosplan\DemosPlanCoreBundle\Entity\Workflow\Place No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\SegmentComment No errors.
demosplan\DemosPlanCoreBundle\Entity\Video No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\ConsultationToken No errors.
demosplan\DemosPlanCoreBundle\Entity\StatementAttachment No errors.
demosplan\DemosPlanCoreBundle\Entity\EntitySyncLink No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\ParagraphVersion No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\SingleDocumentVersion No errors.
demosplan\DemosPlanCoreBundle\Entity\Document\Paragraph No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Tag No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\TagTopic No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\StatementVote No errors.
demosplan\DemosPlanCoreBundle\Entity\FaqCategory No errors.
demosplan\DemosPlanCoreBundle\Entity\Faq No errors.
demosplan\DemosPlanCoreBundle\Entity\PlatformFaq No errors.
demosplan\DemosPlanCoreBundle\Entity\PlatformFaqCategory No errors.
demosplan\DemosPlanCoreBundle\Entity\User\CustomerCounty No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaStatusInCustomer No errors.
demosplan\DemosPlanCoreBundle\Entity\User\InstitutionTagCategory No errors.
demosplan\DemosPlanCoreBundle\Entity\File No errors.

install entity manager

No loaded entities.