GET http://blp-dev-debug.demos-europe.eu/user/register

Response
200 OK
IP
172.24.116.3
Profiled on
Token
ad1f80

Query Metrics

15 Database Queries
5 Different statements
11.86 ms Query time
0 Invalid entities

Queries

Group similar statements

dplan connection

#▲ Time Info
1 0.95 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: 
[
  "blp-dev-debug"
]
View formatted query    View runnable query    Explain query
2 0.63 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"
]
View formatted query    View runnable query    Explain query
3 0.61 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
]
View formatted query    View runnable query    Explain query
4 0.88 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
5 0.79 ms 
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: 
[
  "fe47e7f0-4cde-345d-b358-0d9d9b5cfc4c"
]
View formatted query    View runnable query    Explain query
6 0.83 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
7 0.85 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
8 0.85 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
9 0.84 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
10 0.83 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
11 0.83 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
12 0.84 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
13 0.44 ms 
SELECT t0.id AS id_1, t0.cssvars AS cssvars_2, t0.logo AS logo_3 FROM branding t0 WHERE t0.id = ?
Parameters: 
[
  "e9af459e-7486-11ec-92ee-b026282c0641"
]
View formatted query    View runnable query    Explain query
14 0.85 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query
15 0.83 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: 
[
  "mv"
]
View formatted query    View runnable query    Explain query

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
DemosEurope\DemosplanAddon\DemosPipes\Entity\PdfImport\AnnotatedStatementPdf No errors.
demosplan\DemosPlanCoreBundle\Entity\SluggedEntity No 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\User No errors.
demosplan\DemosPlanCoreBundle\Entity\Branding No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Role No errors.
demosplan\DemosPlanCoreBundle\Entity\User\UserRoleInCustomer No errors.
demosplan\DemosPlanCoreBundle\Entity\User\Orga No errors.
demosplan\DemosPlanCoreBundle\Entity\User\CustomerCounty No errors.
demosplan\DemosPlanCoreBundle\Entity\User\OrgaStatusInCustomer No errors.
demosplan\DemosPlanCoreBundle\Entity\Video No errors.
demosplan\DemosPlanCoreBundle\Entity\User\SupportContact No errors.
demosplan\DemosPlanCoreBundle\Entity\User\InstitutionTagCategory No errors.
demosplan\DemosPlanCoreBundle\Entity\File No errors.
demosplan\DemosPlanCoreBundle\Entity\Flood No errors.
demosplan\DemosPlanCoreBundle\Entity\Statement\Statement No errors.

install entity manager

No loaded entities.