Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

1.83 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.95 ms	SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0 SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0;
2	0.26 ms	SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0 SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0;
3	0.25 ms	SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0 SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0;

#▲

Time

Info

0.95 ms

SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.identity_server_url AS identity_server_url_2,
  t0.identity_server_url_internal AS identity_server_url_internal_3,
  t0.global_module_url AS global_module_url_4,
  t0.identity_server_app_key AS identity_server_app_key_5,
  t0.license_level1 AS license_level1_6,
  t0.license_level2 AS license_level2_7,
  t0.license_level3 AS license_level3_8,
  t0.app_key AS app_key_9,
  t0.event_hub_url AS event_hub_url_10,
  t0.event_hub_external_url AS event_hub_external_url_11,
  t0.translation_module_url AS translation_module_url_12
FROM
  config t0

SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0;

0.26 ms

SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.identity_server_url AS identity_server_url_2,
  t0.identity_server_url_internal AS identity_server_url_internal_3,
  t0.global_module_url AS global_module_url_4,
  t0.identity_server_app_key AS identity_server_app_key_5,
  t0.license_level1 AS license_level1_6,
  t0.license_level2 AS license_level2_7,
  t0.license_level3 AS license_level3_8,
  t0.app_key AS app_key_9,
  t0.event_hub_url AS event_hub_url_10,
  t0.event_hub_external_url AS event_hub_external_url_11,
  t0.translation_module_url AS translation_module_url_12
FROM
  config t0

SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0;

0.25 ms

SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.identity_server_url AS identity_server_url_2,
  t0.identity_server_url_internal AS identity_server_url_internal_3,
  t0.global_module_url AS global_module_url_4,
  t0.identity_server_app_key AS identity_server_app_key_5,
  t0.license_level1 AS license_level1_6,
  t0.license_level2 AS license_level2_7,
  t0.license_level3 AS license_level3_8,
  t0.app_key AS app_key_9,
  t0.event_hub_url AS event_hub_url_10,
  t0.event_hub_external_url AS event_hub_external_url_11,
  t0.translation_module_url AS translation_module_url_12
FROM
  config t0

SELECT t0.id AS id_1, t0.identity_server_url AS identity_server_url_2, t0.identity_server_url_internal AS identity_server_url_internal_3, t0.global_module_url AS global_module_url_4, t0.identity_server_app_key AS identity_server_app_key_5, t0.license_level1 AS license_level1_6, t0.license_level2 AS license_level2_7, t0.license_level3 AS license_level3_8, t0.app_key AS app_key_9, t0.event_hub_url AS event_hub_url_10, t0.event_hub_external_url AS event_hub_external_url_11, t0.translation_module_url AS translation_module_url_12 FROM config t0;

user connection

#▲	Time	Info
1	0.36 ms	SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.roles AS roles_2, s0_.password AS password_3, s0_.active AS active_4, s0_.last_authentication AS last_authentication_5, s0_.logged_out_at AS logged_out_at_6, s0_.encrypted_password AS encrypted_password_7 FROM system_user s0_ WHERE s0_.active = ? AND s0_.username = ? Parameters: [`1 "admin"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.roles AS roles_2, s0_.password AS password_3, s0_.active AS active_4, s0_.last_authentication AS last_authentication_5, s0_.logged_out_at AS logged_out_at_6, s0_.encrypted_password AS encrypted_password_7 FROM system_user s0_ WHERE s0_.active = ? AND s0_.username = ? SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.roles AS roles_2, s0_.password AS password_3, s0_.active AS active_4, s0_.last_authentication AS last_authentication_5, s0_.logged_out_at AS logged_out_at_6, s0_.encrypted_password AS encrypted_password_7 FROM system_user s0_ WHERE s0_.active = 1 AND s0_.username = 'admin';

#▲

Time

Info

0.36 ms

SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.roles AS roles_2, s0_.password AS password_3, s0_.active AS active_4, s0_.last_authentication AS last_authentication_5, s0_.logged_out_at AS logged_out_at_6, s0_.encrypted_password AS encrypted_password_7 FROM system_user s0_ WHERE s0_.active = ? AND s0_.username = ?

Parameters:

[
  1
  "admin"
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.username AS username_1,
  s0_.roles AS roles_2,
  s0_.password AS password_3,
  s0_.active AS active_4,
  s0_.last_authentication AS last_authentication_5,
  s0_.logged_out_at AS logged_out_at_6,
  s0_.encrypted_password AS encrypted_password_7
FROM
  system_user s0_
WHERE
  s0_.active = ?
  AND s0_.username = ?

SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.roles AS roles_2, s0_.password AS password_3, s0_.active AS active_4, s0_.last_authentication AS last_authentication_5, s0_.logged_out_at AS logged_out_at_6, s0_.encrypted_password AS encrypted_password_7 FROM system_user s0_ WHERE s0_.active = 1 AND s0_.username = 'admin';

Database Connections

Name	Service
translation_cache	doctrine.dbal.translation_cache_connection
default	doctrine.dbal.default_connection
user	doctrine.dbal.user_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
user	doctrine.orm.user_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Main\Config	No errors.

user entity manager

Class	Mapping errors
Tss\IdentityServerBundle\Entity\SystemUser\SystemUser	No errors.

Symfony Profiler

POST http://identity-server.test.softplus.tsszo.eu/api/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

user connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

user entity manager