Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.63 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

No database queries were performed.

database_akn_dump connection

No database queries were performed.

database_akn connection

No database queries were performed.

database_akn_old connection

No database queries were performed.

database_akn_live connection

No database queries were performed.

database_akn_dump_live connection

No database queries were performed.

database_akn_live_ionos connection

Time▼	Count	Info
0.86 ms (0.00%)	1	SELECT LOWER(HEX(id)) AS category_id, category_translation.name, LOWER(HEX(after_category_id)) AS after_category_id FROM category INNER JOIN category_translation ON (category.id = category_translation.category_id) WHERE LOWER(HEX(parent_id)) = 'a613e4bc3e7d4a0694305ebb70ddb6ba' -- WHERE LOWER(HEX(parent_id)) = '91bb5a08283d40a3bf1ec0a4759660b1' AND LOWER(HEX(language_id)) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b' ; Parameters: [] View formatted query View runnable query Explain query SELECT LOWER( HEX(id) ) AS category_id, category_translation.name, LOWER( HEX(after_category_id) ) AS after_category_id FROM category INNER JOIN category_translation ON ( category.id = category_translation.category_id ) WHERE LOWER( HEX(parent_id) ) = 'a613e4bc3e7d4a0694305ebb70ddb6ba' -- WHERE LOWER(HEX(parent_id)) = '91bb5a08283d40a3bf1ec0a4759660b1' AND LOWER( HEX(language_id) ) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b'; SELECT LOWER(HEX(id)) AS category_id, category_translation.name, LOWER(HEX(after_category_id)) AS after_category_id FROM category INNER JOIN category_translation ON (category.id = category_translation.category_id) WHERE LOWER(HEX(parent_id)) = 'a613e4bc3e7d4a0694305ebb70ddb6ba' -- WHERE LOWER(HEX(parent_id)) = '91bb5a08283d40a3bf1ec0a4759660b1' AND LOWER(HEX(language_id)) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b' ;;
0.77 ms (0.00%)	1	SELECT LOWER(HEX(id)) AS category_id, category_translation.name, LOWER(HEX(after_category_id)) AS after_category_id FROM category INNER JOIN category_translation ON (category.id = category_translation.category_id) WHERE LOWER(HEX(parent_id)) = '8bed4848de4d42d682625c9e3af914d9' AND LOWER(HEX(language_id)) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b' ; Parameters: [] View formatted query View runnable query Explain query SELECT LOWER( HEX(id) ) AS category_id, category_translation.name, LOWER( HEX(after_category_id) ) AS after_category_id FROM category INNER JOIN category_translation ON ( category.id = category_translation.category_id ) WHERE LOWER( HEX(parent_id) ) = '8bed4848de4d42d682625c9e3af914d9' AND LOWER( HEX(language_id) ) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b'; SELECT LOWER(HEX(id)) AS category_id, category_translation.name, LOWER(HEX(after_category_id)) AS after_category_id FROM category INNER JOIN category_translation ON (category.id = category_translation.category_id) WHERE LOWER(HEX(parent_id)) = '8bed4848de4d42d682625c9e3af914d9' AND LOWER(HEX(language_id)) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b' ;;

Time▼

Count

Info

0.86 ms
(0.00%)

SELECT LOWER(HEX(id)) AS category_id, category_translation.name, LOWER(HEX(after_category_id)) AS after_category_id
                    FROM category
                    INNER JOIN category_translation ON (category.id = category_translation.category_id)
                    WHERE LOWER(HEX(parent_id)) = 'a613e4bc3e7d4a0694305ebb70ddb6ba'
                    -- WHERE LOWER(HEX(parent_id)) = '91bb5a08283d40a3bf1ec0a4759660b1'
                    AND LOWER(HEX(language_id)) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b'
                    ;

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  LOWER(
    HEX(id)
  ) AS category_id,
  category_translation.name,
  LOWER(
    HEX(after_category_id)
  ) AS after_category_id
FROM
  category
  INNER JOIN category_translation ON (
    category.id = category_translation.category_id
  )
WHERE
  LOWER(
    HEX(parent_id)
  ) = 'a613e4bc3e7d4a0694305ebb70ddb6ba' -- WHERE LOWER(HEX(parent_id)) = '91bb5a08283d40a3bf1ec0a4759660b1'
  AND LOWER(
    HEX(language_id)
  ) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b';

SELECT LOWER(HEX(id)) AS category_id, category_translation.name, LOWER(HEX(after_category_id)) AS after_category_id
                    FROM category
                    INNER JOIN category_translation ON (category.id = category_translation.category_id)
                    WHERE LOWER(HEX(parent_id)) = 'a613e4bc3e7d4a0694305ebb70ddb6ba'
                    -- WHERE LOWER(HEX(parent_id)) = '91bb5a08283d40a3bf1ec0a4759660b1'
                    AND LOWER(HEX(language_id)) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b'
                    ;;

0.77 ms
(0.00%)

SELECT LOWER(HEX(id)) AS category_id, category_translation.name, LOWER(HEX(after_category_id)) AS after_category_id
            FROM category
            INNER JOIN category_translation ON (category.id = category_translation.category_id)
            WHERE LOWER(HEX(parent_id)) = '8bed4848de4d42d682625c9e3af914d9'
            AND LOWER(HEX(language_id)) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b'
            ;

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  LOWER(
    HEX(id)
  ) AS category_id,
  category_translation.name,
  LOWER(
    HEX(after_category_id)
  ) AS after_category_id
FROM
  category
  INNER JOIN category_translation ON (
    category.id = category_translation.category_id
  )
WHERE
  LOWER(
    HEX(parent_id)
  ) = '8bed4848de4d42d682625c9e3af914d9'
  AND LOWER(
    HEX(language_id)
  ) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b';

SELECT LOWER(HEX(id)) AS category_id, category_translation.name, LOWER(HEX(after_category_id)) AS after_category_id
            FROM category
            INNER JOIN category_translation ON (category.id = category_translation.category_id)
            WHERE LOWER(HEX(parent_id)) = '8bed4848de4d42d682625c9e3af914d9'
            AND LOWER(HEX(language_id)) = '2fbb5fe2e29a4d70aa5854ce7ce3e20b'
            ;;

database_akn_dump_live_ionos connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
database_akn_dump	doctrine.dbal.database_akn_dump_connection
database_akn	doctrine.dbal.database_akn_connection
database_akn_old	doctrine.dbal.database_akn_old_connection
database_akn_live	doctrine.dbal.database_akn_live_connection
database_akn_dump_live	doctrine.dbal.database_akn_dump_live_connection
database_akn_live_ionos	doctrine.dbal.database_akn_live_ionos_connection
database_akn_dump_live_ionos	doctrine.dbal.database_akn_dump_live_ionos_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.

Symfony Profiler

https://swconnect.akn.pixelproductions.de/sort/categories/10

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

database_akn_dump connection

database_akn connection

database_akn_old connection

database_akn_live connection

database_akn_dump_live connection

database_akn_live_ionos connection

database_akn_dump_live_ionos connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping