Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

2 Database Queries

2 Different statements

0.50 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.34 ms
(67.35%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.primary_color AS primary_color_2, c0_.primary_color_rgb AS primary_color_rgb_3, c0_.logo AS logo_4, c0_.legal_notices AS legal_notices_5, c0_.background_color AS background_color_6 FROM company c0_ INNER JOIN ip_address i1_ ON c0_.id = i1_.company_id WHERE i1_.address = ?

Parameters:

[
  "77.156.227.251"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.primary_color AS primary_color_2,
  c0_.primary_color_rgb AS primary_color_rgb_3,
  c0_.logo AS logo_4,
  c0_.legal_notices AS legal_notices_5,
  c0_.background_color AS background_color_6
FROM
  company c0_
  INNER JOIN ip_address i1_ ON c0_.id = i1_.company_id
WHERE
  i1_.address = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.primary_color AS primary_color_2, c0_.primary_color_rgb AS primary_color_rgb_3, c0_.logo AS logo_4, c0_.legal_notices AS legal_notices_5, c0_.background_color AS background_color_6 FROM company c0_ INNER JOIN ip_address i1_ ON c0_.id = i1_.company_id WHERE i1_.address = '77.156.227.251';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 32)
7	App\Repository\CompanyRepository->findCompanyFromIpAdresses (line 59)
8	App\Twig\AppExtension->getCompanyFromClientIp (line 64)
9	__TwigTemplate_86d13dcf8f3803c85558fec7c59041d3->doDisplay (line 388)
10	Twig\Template->yield (line 55)
11	__TwigTemplate_550f9ca8c92f36b94cb4e30eebc87ad7->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
20	App\Controller\SecurityController->login (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.16 ms
(32.65%)

SELECT t0.id AS id_1, t0.email_expeditor AS email_expeditor_2, t0.background_color AS background_color_3, t0.primary_color AS primary_color_4, t0.primary_color_rgb AS primary_color_rgb_5, t0.logo AS logo_6 FROM global_parameters t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email_expeditor AS email_expeditor_2,
  t0.background_color AS background_color_3,
  t0.primary_color AS primary_color_4,
  t0.primary_color_rgb AS primary_color_rgb_5,
  t0.logo AS logo_6
FROM
  global_parameters t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email_expeditor AS email_expeditor_2, t0.background_color AS background_color_3, t0.primary_color AS primary_color_4, t0.primary_color_rgb AS primary_color_rgb_5, t0.logo AS logo_6 FROM global_parameters t0 WHERE t0.id = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 39)
5	App\Twig\AppExtension->getGlobalParameters (line 70)
6	__TwigTemplate_86d13dcf8f3803c85558fec7c59041d3->doDisplay (line 388)
7	Twig\Template->yield (line 55)
8	__TwigTemplate_550f9ca8c92f36b94cb4e30eebc87ad7->doDisplay (line 388)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 71)
17	App\Controller\SecurityController->login (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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.

Entities Mapping

Class	Mapping errors
App\Entity\Company	No errors.
App\Entity\IpAddress	No errors.
App\Entity\GlobalParameters	No errors.

Symfony Profiler

GET https://registredev.olihost.com/login

Configuration Settings

Theme