Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

3.13 ms Query time

0 Invalid entities

Queries

default connection


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
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
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()

#▲	Time	Info
1	0.90 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.23 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.19 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;
4	0.30 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;
5	0.20 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
6	0.44 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"identity_server"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'identity_server' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
7	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

translation_cache connection

#▲	Time	Info
1	0.26 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1751725978 "tss-translation-key:\x01tags\x01locale" "tss-translation-key:locale"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1751725978 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tss-translation-key:tagslocale', 'tss-translation-key:locale');
2	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1751725978 "tss-translation-key:tss_translation\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1751725978 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tss-translation-key:tss_translationtags');
3	0.30 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1751725978 "tss-translation-key:\x01tags\x01locale" "tss-translation-key:locale"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1751725978 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tss-translation-key:tagslocale', 'tss-translation-key:locale');

#▲

Time

Info

0.26 ms

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)

Parameters:

[
  1751725978
  "tss-translation-key:\x01tags\x01locale"
  "tss-translation-key:locale"
]

View formatted query View runnable query Explain query

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1751725978 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tss-translation-key:tagslocale', 'tss-translation-key:locale');

0.18 ms

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)

Parameters:

[
  1751725978
  "tss-translation-key:tss_translation\x01tags\x01"
]

View formatted query View runnable query Explain query

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1751725978 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tss-translation-key:tss_translationtags');

0.30 ms

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)

Parameters:

[
  1751725978
  "tss-translation-key:\x01tags\x01locale"
  "tss-translation-key:locale"
]

View formatted query View runnable query Explain query

SELECT
  item_id,
  CASE WHEN item_lifetime IS NULL
  OR item_lifetime + item_time > ? THEN
    item_data
  ELSE
    NULL
  END
FROM
  cache_items
WHERE
  item_id IN (?, ?)

SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1751725978 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tss-translation-key:tagslocale', 'tss-translation-key:locale');

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

No loaded entities.

Symfony Profiler

GET http://lock-acs-module.test.softplus.tsszo.eu/logged-in-check

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

translation_cache connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

user entity manager