Symfony Profiler

Query Metrics

3 Database Queries

1 Different statements

1.03 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.46 ms

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.validado AS validado_6 FROM entidades e0_ WHERE e0_.dominio = ? AND e0_.validado = ?

Parameters:

[
  "46.101.246"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.nombre AS nombre_1,
  e0_.dominio AS dominio_2,
  e0_.email AS email_3,
  e0_.created_at AS created_at_4,
  e0_.updated_at AS updated_at_5,
  e0_.validado AS validado_6
FROM
  entidades e0_
WHERE
  e0_.dominio = ?
  AND e0_.validado = ?

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.validado AS validado_6 FROM entidades e0_ WHERE e0_.dominio = '46.101.246' AND e0_.validado = 1;

#	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 89)
7	App\Repository\EntidadRepository->findByDomain (line 29)
8	App\Services\Entidad\EntidadService->getByDomain (line 35)
9	App\Services\Configuration\ConfigurationService->getByDomain (line 64)
10	App\Twig\ConfigurationExtension->getColorPrincipal (line 81)
11	__TwigTemplate_bab01ee7530c2ab326db40a6544280e7->doDisplay (line 393)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_f45ca3f47389c93ffcd17e9fb909d839->doDisplay (line 393)
14	Twig\Template->yield (line 349)
15	Twig\Template->display (line 364)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 22)
22	App\Controller\Auth\AuthController->login (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.32 ms

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.validado AS validado_6 FROM entidades e0_ WHERE e0_.dominio = ? AND e0_.validado = ?

Parameters:

[
  "46.101.246"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.nombre AS nombre_1,
  e0_.dominio AS dominio_2,
  e0_.email AS email_3,
  e0_.created_at AS created_at_4,
  e0_.updated_at AS updated_at_5,
  e0_.validado AS validado_6
FROM
  entidades e0_
WHERE
  e0_.dominio = ?
  AND e0_.validado = ?

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.validado AS validado_6 FROM entidades e0_ WHERE e0_.dominio = '46.101.246' AND e0_.validado = 1;

#	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 89)
7	App\Repository\EntidadRepository->findByDomain (line 29)
8	App\Services\Entidad\EntidadService->getByDomain (line 35)
9	App\Services\Configuration\ConfigurationService->getByDomain (line 81)
10	App\Twig\ConfigurationExtension->getColorSecundario (line 85)
11	__TwigTemplate_bab01ee7530c2ab326db40a6544280e7->doDisplay (line 393)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_f45ca3f47389c93ffcd17e9fb909d839->doDisplay (line 393)
14	Twig\Template->yield (line 349)
15	Twig\Template->display (line 364)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 22)
22	App\Controller\Auth\AuthController->login (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.25 ms

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.validado AS validado_6 FROM entidades e0_ WHERE e0_.dominio = ? AND e0_.validado = ?

Parameters:

[
  "46.101.246"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.nombre AS nombre_1,
  e0_.dominio AS dominio_2,
  e0_.email AS email_3,
  e0_.created_at AS created_at_4,
  e0_.updated_at AS updated_at_5,
  e0_.validado AS validado_6
FROM
  entidades e0_
WHERE
  e0_.dominio = ?
  AND e0_.validado = ?

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.dominio AS dominio_2, e0_.email AS email_3, e0_.created_at AS created_at_4, e0_.updated_at AS updated_at_5, e0_.validado AS validado_6 FROM entidades e0_ WHERE e0_.dominio = '46.101.246' AND e0_.validado = 1;

#	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 89)
7	App\Repository\EntidadRepository->findByDomain (line 29)
8	App\Services\Entidad\EntidadService->getByDomain (line 35)
9	App\Services\Configuration\ConfigurationService->getByDomain (line 44)
10	App\Twig\ConfigurationExtension->getLogoPath (line 136)
11	__TwigTemplate_f45ca3f47389c93ffcd17e9fb909d839->block_content (line 437)
12	Twig\Template->yieldBlock (line 124)
13	__TwigTemplate_bab01ee7530c2ab326db40a6544280e7->doDisplay (line 393)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_f45ca3f47389c93ffcd17e9fb909d839->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 22)
24	App\Controller\Auth\AuthController->login (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\Entidad	The field App\Entity\Entidad#usuarios is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#entidad does not contain the required 'inversedBy="usuarios"' attribute.

Symfony Profiler

GET http://46.101.246.11/?__wpdmxp=%27%5D%5B%2Fwpdm_package%5D%5Bwpdm_all_packages%5D%5Bwpdm_package%20id%3D%27

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping