Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.11 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.66 ms
(59.53%)

SELECT DISTINCT s0_.subdomain AS subdomain_0 FROM site s0_ WHERE s0_.is_active = ? AND s0_.subdomain IS NOT NULL AND s0_.subdomain <> ?

Parameters:

[
  1
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.subdomain AS subdomain_0
FROM
  site s0_
WHERE
  s0_.is_active = ?
  AND s0_.subdomain IS NOT NULL
  AND s0_.subdomain <> ?

SELECT DISTINCT s0_.subdomain AS subdomain_0 FROM site s0_ WHERE s0_.is_active = 1 AND s0_.subdomain IS NOT NULL AND s0_.subdomain <> '';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Repository\SiteRepository->findAllActiveSubdomains (line 58)
7	App\Service\SiteContext->initializeSite (line 160)
8	App\Service\SiteContext->isUnknownSubdomainRequested (line 40)
9	App\Controller\FrontendController->show (line 60)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.45 ms
(40.47%)

SELECT a0_.id AS id_0, a0_.blog_prefix AS blog_prefix_1, a0_.custom_head_code AS custom_head_code_2, a0_.custom_footer_code AS custom_footer_code_3 FROM app_configuration a0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.blog_prefix AS blog_prefix_1,
  a0_.custom_head_code AS custom_head_code_2,
  a0_.custom_footer_code AS custom_footer_code_3
FROM
  app_configuration a0_
LIMIT
  1

SELECT a0_.id AS id_0, a0_.blog_prefix AS blog_prefix_1, a0_.custom_head_code AS custom_head_code_2, a0_.custom_footer_code AS custom_footer_code_3 FROM app_configuration a0_ LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\AppConfigurationRepository->getConfig (line 24)
7	App\Twig\AppConfigExtension->getGlobals (line 20)
8	Twig\ExtensionSet->getGlobals (line 365)
9	Twig\Environment->getGlobals (line 908)
10	Twig\Template->yield (line 398)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\FrontendController->show (line 61)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	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

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\AppConfiguration	1

Entities Mapping

Class	Mapping errors
App\Entity\Site	No errors.
App\Entity\AppConfiguration	No errors.

Symfony Profiler

GET https://sub2.test2md.b--w.pl/config.production.json

Configuration Settings

Theme

Page Width