Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

6.70 ms Query time

0 Invalid entities

1 Managed entities

4 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

4.98 ms
(74.30%)

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name)

Parameters:

[
  "idarapro"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  quote_ident(table_name) AS table_name,
  table_schema AS schema_name
FROM
  information_schema.tables
WHERE
  table_catalog = ?
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name)

SELECT quote_ident(table_name) AS table_name,
       table_schema AS schema_name
FROM information_schema.tables
WHERE table_catalog = 'idarapro'
  AND table_schema NOT LIKE 'pg\_%'
  AND table_schema != 'information_schema'
  AND table_name != 'geometry_columns'
  AND table_name != 'spatial_ref_sys'
  AND table_type = 'BASE TABLE'
ORDER BY
  quote_ident(table_name);

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 44)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 1104)
3	Doctrine\DBAL\Connection->executeQuery (line 616)
4	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->selectTableNames (line 356)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 48)
6	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->listTableNames (line 325)
7	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 113)
8	App\Routing\DynamicTenantRouteLoader->getTenantSlugsFromDatabase (line 64)
9	App\Routing\DynamicTenantRouteLoader->load (line 141)
10	Symfony\Component\Config\Loader\FileLoader->doImport (line 93)
11	Symfony\Component\Config\Loader\FileLoader->import (line 184)
12	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 265)
13	Symfony\Component\Routing\Loader\YamlFileLoader->loadContent (line 77)
14	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 162)
15	Symfony\Component\Config\Loader\FileLoader->doImport (line 82)
16	Symfony\Component\Config\Loader\FileLoader->import (line 41)
17	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 83)
18	App\Kernel->configureRoutes (line 231)
19	App\Kernel->loadRoutes (line 51)
20	Symfony\Component\Routing\Loader\ObjectLoader->load (line 37)
21	Symfony\Component\Config\Loader\DelegatingLoader->load (line 65)
22	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 75)
23	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 127)
24	App\Service\TenantService->routeRequiresTenant (line 183)
25	App\Service\TenantService->getTenantParameters (line 61)
26	App\Twig\TenantRoutingExtension->generateTenantRoute (line 40)
27	App\Twig\TenantRoutingExtension->generateTenantPath (line 185)
28	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->block_content (line 446)
29	Twig\Template->yieldBlock (line 292)
30	__TwigTemplate_a08938b16501da3f36ec52faaf97d505->doDisplay (line 402)
31	Twig\Template->yield (line 57)
32	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->doDisplay (line 402)
33	Twig\Template->yield (line 358)
34	Twig\Template->display (line 373)
35	Twig\Template->render (line 51)
36	Twig\TemplateWrapper->render (line 333)
37	Twig\Environment->render (line 467)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 284)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
41	App\Controller\ResetPasswordController->request (line 183)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
44	Symfony\Component\HttpKernel\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
46	require_once (line 5)

0.57 ms
(8.49%)

SELECT tenant_id FROM instituts WHERE tenant_id IS NOT NULL ORDER BY name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  tenant_id
FROM
  instituts
WHERE
  tenant_id IS NOT NULL
ORDER BY
  name ASC

SELECT tenant_id FROM instituts WHERE tenant_id IS NOT NULL ORDER BY name ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->{closure:Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3::query():106} (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 106)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->query (line 49)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->query (line 1106)
5	Doctrine\DBAL\Connection->executeQuery (line 119)
6	App\Routing\DynamicTenantRouteLoader->getTenantSlugsFromDatabase (line 64)
7	App\Routing\DynamicTenantRouteLoader->load (line 141)
8	Symfony\Component\Config\Loader\FileLoader->doImport (line 93)
9	Symfony\Component\Config\Loader\FileLoader->import (line 184)
10	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 265)
11	Symfony\Component\Routing\Loader\YamlFileLoader->loadContent (line 77)
12	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 162)
13	Symfony\Component\Config\Loader\FileLoader->doImport (line 82)
14	Symfony\Component\Config\Loader\FileLoader->import (line 41)
15	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 83)
16	App\Kernel->configureRoutes (line 231)
17	App\Kernel->loadRoutes (line 51)
18	Symfony\Component\Routing\Loader\ObjectLoader->load (line 37)
19	Symfony\Component\Config\Loader\DelegatingLoader->load (line 65)
20	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 75)
21	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 127)
22	App\Service\TenantService->routeRequiresTenant (line 183)
23	App\Service\TenantService->getTenantParameters (line 61)
24	App\Twig\TenantRoutingExtension->generateTenantRoute (line 40)
25	App\Twig\TenantRoutingExtension->generateTenantPath (line 185)
26	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->block_content (line 446)
27	Twig\Template->yieldBlock (line 292)
28	__TwigTemplate_a08938b16501da3f36ec52faaf97d505->doDisplay (line 402)
29	Twig\Template->yield (line 57)
30	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->doDisplay (line 402)
31	Twig\Template->yield (line 358)
32	Twig\Template->display (line 373)
33	Twig\Template->render (line 51)
34	Twig\TemplateWrapper->render (line 333)
35	Twig\Environment->render (line 467)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 284)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
39	App\Controller\ResetPasswordController->request (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
44	require_once (line 5)

0.52 ms
(7.84%)

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  schema_name
FROM
  information_schema.schemata
WHERE
  schema_name NOT LIKE 'pg\_%'
  AND schema_name != 'information_schema'

SELECT schema_name
FROM   information_schema.schemata
WHERE  schema_name NOT LIKE 'pg\_%'
AND    schema_name != 'information_schema';

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->{closure:Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3::query():106} (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 106)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->query (line 49)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->query (line 1106)
5	Doctrine\DBAL\Connection->executeQuery (line 958)
6	Doctrine\DBAL\Connection->fetchFirstColumn (line 126)
7	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->listSchemaNames (line 212)
8	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->determineExistingSchemaSearchPaths (line 177)
9	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->getExistingSchemaSearchPaths (line 194)
10	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->getCurrentSchema (line 279)
11	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->_getPortableTableDefinition (line 1529)
12	Doctrine\DBAL\Schema\AbstractSchemaManager->_getPortableTablesList (line 355)
13	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 48)
14	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->listTableNames (line 325)
15	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 113)
16	App\Routing\DynamicTenantRouteLoader->getTenantSlugsFromDatabase (line 64)
17	App\Routing\DynamicTenantRouteLoader->load (line 141)
18	Symfony\Component\Config\Loader\FileLoader->doImport (line 93)
19	Symfony\Component\Config\Loader\FileLoader->import (line 184)
20	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 265)
21	Symfony\Component\Routing\Loader\YamlFileLoader->loadContent (line 77)
22	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 162)
23	Symfony\Component\Config\Loader\FileLoader->doImport (line 82)
24	Symfony\Component\Config\Loader\FileLoader->import (line 41)
25	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 83)
26	App\Kernel->configureRoutes (line 231)
27	App\Kernel->loadRoutes (line 51)
28	Symfony\Component\Routing\Loader\ObjectLoader->load (line 37)
29	Symfony\Component\Config\Loader\DelegatingLoader->load (line 65)
30	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 75)
31	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 127)
32	App\Service\TenantService->routeRequiresTenant (line 183)
33	App\Service\TenantService->getTenantParameters (line 61)
34	App\Twig\TenantRoutingExtension->generateTenantRoute (line 40)
35	App\Twig\TenantRoutingExtension->generateTenantPath (line 185)
36	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->block_content (line 446)
37	Twig\Template->yieldBlock (line 292)
38	__TwigTemplate_a08938b16501da3f36ec52faaf97d505->doDisplay (line 402)
39	Twig\Template->yield (line 57)
40	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->doDisplay (line 402)
41	Twig\Template->yield (line 358)
42	Twig\Template->display (line 373)
43	Twig\Template->render (line 51)
44	Twig\TemplateWrapper->render (line 333)
45	Twig\Environment->render (line 467)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 284)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
49	App\Controller\ResetPasswordController->request (line 183)
50	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
51	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
52	Symfony\Component\HttpKernel\Kernel->handle (line 35)
53	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
54	require_once (line 5)

0.46 ms
(6.89%)

SELECT CURRENT_DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  CURRENT_DATABASE()

SELECT CURRENT_DATABASE();

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->{closure:Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3::query():106} (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 106)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->query (line 49)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->query (line 1106)
5	Doctrine\DBAL\Connection->executeQuery (line 627)
6	Doctrine\DBAL\Connection->fetchOne (line 267)
7	Doctrine\DBAL\Connection->getDatabase (line 1778)
8	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 352)
9	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 48)
10	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->listTableNames (line 325)
11	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 113)
12	App\Routing\DynamicTenantRouteLoader->getTenantSlugsFromDatabase (line 64)
13	App\Routing\DynamicTenantRouteLoader->load (line 141)
14	Symfony\Component\Config\Loader\FileLoader->doImport (line 93)
15	Symfony\Component\Config\Loader\FileLoader->import (line 184)
16	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 265)
17	Symfony\Component\Routing\Loader\YamlFileLoader->loadContent (line 77)
18	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 162)
19	Symfony\Component\Config\Loader\FileLoader->doImport (line 82)
20	Symfony\Component\Config\Loader\FileLoader->import (line 41)
21	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 83)
22	App\Kernel->configureRoutes (line 231)
23	App\Kernel->loadRoutes (line 51)
24	Symfony\Component\Routing\Loader\ObjectLoader->load (line 37)
25	Symfony\Component\Config\Loader\DelegatingLoader->load (line 65)
26	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 75)
27	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 127)
28	App\Service\TenantService->routeRequiresTenant (line 183)
29	App\Service\TenantService->getTenantParameters (line 61)
30	App\Twig\TenantRoutingExtension->generateTenantRoute (line 40)
31	App\Twig\TenantRoutingExtension->generateTenantPath (line 185)
32	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->block_content (line 446)
33	Twig\Template->yieldBlock (line 292)
34	__TwigTemplate_a08938b16501da3f36ec52faaf97d505->doDisplay (line 402)
35	Twig\Template->yield (line 57)
36	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->doDisplay (line 402)
37	Twig\Template->yield (line 358)
38	Twig\Template->display (line 373)
39	Twig\Template->render (line 51)
40	Twig\TemplateWrapper->render (line 333)
41	Twig\Environment->render (line 467)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 284)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
45	App\Controller\ResetPasswordController->request (line 183)
46	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
47	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
48	Symfony\Component\HttpKernel\Kernel->handle (line 35)
49	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
50	require_once (line 5)

0.17 ms
(2.48%)

SHOW search_path

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SHOW search_path

SHOW search_path;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->{closure:Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3::query():106} (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 106)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->query (line 49)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->query (line 1106)
5	Doctrine\DBAL\Connection->executeQuery (line 627)
6	Doctrine\DBAL\Connection->fetchOne (line 151)
7	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->getSchemaSearchPaths (line 213)
8	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->determineExistingSchemaSearchPaths (line 177)
9	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->getExistingSchemaSearchPaths (line 194)
10	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->getCurrentSchema (line 279)
11	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->_getPortableTableDefinition (line 1529)
12	Doctrine\DBAL\Schema\AbstractSchemaManager->_getPortableTablesList (line 355)
13	Doctrine\DBAL\Schema\AbstractSchemaManager->doListTableNames (line 48)
14	Doctrine\DBAL\Schema\PostgreSQLSchemaManager->listTableNames (line 325)
15	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 113)
16	App\Routing\DynamicTenantRouteLoader->getTenantSlugsFromDatabase (line 64)
17	App\Routing\DynamicTenantRouteLoader->load (line 141)
18	Symfony\Component\Config\Loader\FileLoader->doImport (line 93)
19	Symfony\Component\Config\Loader\FileLoader->import (line 184)
20	Symfony\Component\Routing\Loader\YamlFileLoader->parseImport (line 265)
21	Symfony\Component\Routing\Loader\YamlFileLoader->loadContent (line 77)
22	Symfony\Component\Routing\Loader\YamlFileLoader->load (line 162)
23	Symfony\Component\Config\Loader\FileLoader->doImport (line 82)
24	Symfony\Component\Config\Loader\FileLoader->import (line 41)
25	Symfony\Component\Routing\Loader\Configurator\RoutingConfigurator->import (line 83)
26	App\Kernel->configureRoutes (line 231)
27	App\Kernel->loadRoutes (line 51)
28	Symfony\Component\Routing\Loader\ObjectLoader->load (line 37)
29	Symfony\Component\Config\Loader\DelegatingLoader->load (line 65)
30	Symfony\Bundle\FrameworkBundle\Routing\DelegatingLoader->load (line 75)
31	Symfony\Bundle\FrameworkBundle\Routing\Router->getRouteCollection (line 127)
32	App\Service\TenantService->routeRequiresTenant (line 183)
33	App\Service\TenantService->getTenantParameters (line 61)
34	App\Twig\TenantRoutingExtension->generateTenantRoute (line 40)
35	App\Twig\TenantRoutingExtension->generateTenantPath (line 185)
36	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->block_content (line 446)
37	Twig\Template->yieldBlock (line 292)
38	__TwigTemplate_a08938b16501da3f36ec52faaf97d505->doDisplay (line 402)
39	Twig\Template->yield (line 57)
40	__TwigTemplate_89bdf20a1c6167198667a550a31482fb->doDisplay (line 402)
41	Twig\Template->yield (line 358)
42	Twig\Template->display (line 373)
43	Twig\Template->render (line 51)
44	Twig\TemplateWrapper->render (line 333)
45	Twig\Environment->render (line 467)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 284)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 61)
49	App\Controller\ResetPasswordController->request (line 183)
50	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
51	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
52	Symfony\Component\HttpKernel\Kernel->handle (line 35)
53	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
54	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

4 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
app_entity_institut	4

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Institut	1

Entities Mapping

Class	Mapping errors
App\Entity\Institut	No errors.

Symfony Profiler

GET https://demo.idarapro.fr/moumtez/mot-de-passe-oublie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Managed Entities

default entity manager

Entities Mapping