Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.50 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.88 ms

SELECT l.id, l.name as name, l.dbs_id as dbs_id, l.api_url as api_url, l.logo_url, l.short_name,
                   l.city, la.name as auth_display_name
            FROM libraries l
            LEFT JOIN library_auth la ON l.id = la.library_id
            WHERE l.active = 1
            ORDER BY COALESCE(la.name, l.name)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l.id,
  l.name as name,
  l.dbs_id as dbs_id,
  l.api_url as api_url,
  l.logo_url,
  l.short_name,
  l.city,
  la.name as auth_display_name
FROM
  libraries l
  LEFT JOIN library_auth la ON l.id = la.library_id
WHERE
  l.active = 1
ORDER BY
  COALESCE(la.name, l.name)

SELECT l.id, l.name as name, l.dbs_id as dbs_id, l.api_url as api_url, l.logo_url, l.short_name,
                   l.city, la.name as auth_display_name
            FROM libraries l
            LEFT JOIN library_auth la ON l.id = la.library_id
            WHERE l.active = 1
            ORDER BY COALESCE(la.name, l.name)
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	App\Controller\LibraryLoginController->login (line 96)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
5	Symfony\Component\HttpKernel\Kernel->handle (line 182)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
7	require_once (line 32)
8	require_once (line 8)

0.32 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 627)
2	Doctrine\DBAL\Connection->getDatabase (line 267)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 1778)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 352)
5	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableNames (line 58)
6	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 325)
7	App\Service\SettingsService->ensureSettingsTable (line 113)
8	App\Service\SettingsService->getSetting (line 30)
9	App\Controller\LibraryLoginController->login (line 287)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 8)

0.98 ms

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "lizenzmanager2025"
]

View formatted query View runnable query Explain query View query backtrace

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 = 'lizenzmanager2025'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableNames (line 435)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 356)
3	Doctrine\DBAL\Schema\MySQLSchemaManager->listTableNames (line 58)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 325)
5	App\Service\SettingsService->ensureSettingsTable (line 113)
6	App\Service\SettingsService->getSetting (line 30)
7	App\Controller\LibraryLoginController->login (line 287)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 8)

0.32 ms

SELECT setting_value FROM system_settings WHERE setting_key = ?

Parameters:

[
  "support_email"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  setting_value
FROM
  system_settings
WHERE
  setting_key = ?

SELECT setting_value FROM system_settings WHERE setting_key = 'support_email';

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 627)
2	App\Service\SettingsService->getSetting (line 32)
3	App\Controller\LibraryLoginController->login (line 287)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 8)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://login.ebibliotheken-hessen.de/library/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping