Symfony Profiler

Query Metrics

78 Database Queries

5 Different statements

299.72 ms Query time

0 Invalid entities

125 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

270.14 ms
(90.13%)

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = ? AND t0_.activo = ?

Parameters:

[
  "contact.page_title"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.llave AS llave_1,
  t0_.valor AS valor_2,
  t0_.descripcion AS descripcion_3,
  t0_.categoria AS categoria_4,
  t0_.orden AS orden_5,
  t0_.activo AS activo_6,
  t0_.created_at AS created_at_7,
  t0_.updated_at AS updated_at_8
FROM
  textos t0_
WHERE
  t0_.llave = ?
  AND t0_.activo = ?

SELECT t0_.id AS id_0, t0_.llave AS llave_1, t0_.valor AS valor_2, t0_.descripcion AS descripcion_3, t0_.categoria AS categoria_4, t0_.orden AS orden_5, t0_.activo AS activo_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM textos t0_ WHERE t0_.llave = 'contact.page_title' AND t0_.activo = 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\TextoRepository->findByLlave (line 48)
7	App\Service\TextoService->getTexto (line 27)
8	App\Service\QI->getTexto (line 82)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_86a2d609c892318084fd8699b7c95990::block_title (line 78)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_63cc729f47b309b6e0c3099850820b77->doDisplay (line 62)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_86a2d609c892318084fd8699b7c95990->doDisplay (line 56)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\ContactController->index (line 37)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

11.11 ms
(3.71%)

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.departamento AS departamento_2, c0_.orden AS orden_3, c0_.visible AS visible_4, c0_.created_at AS created_at_5 FROM ciudades c0_ WHERE c0_.visible = ? ORDER BY c0_.nombre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.departamento AS departamento_2,
  c0_.orden AS orden_3,
  c0_.visible AS visible_4,
  c0_.created_at AS created_at_5
FROM
  ciudades c0_
WHERE
  c0_.visible = ?
ORDER BY
  c0_.nombre ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.departamento AS departamento_2, c0_.orden AS orden_3, c0_.visible AS visible_4, c0_.created_at AS created_at_5 FROM ciudades c0_ WHERE c0_.visible = 1 ORDER BY c0_.nombre ASC;

#	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->getResult (line 688)
6	App\Repository\CiudadRepository->findVisibleOrdered (line 47)
7	App\Controller\ContactController->index (line 26)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

10.91 ms
(3.64%)

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.activo AS activo_2, m0_.orden AS orden_3, m0_.created_at AS created_at_4 FROM motivo_contacto m0_ WHERE m0_.activo = ? ORDER BY m0_.orden ASC, m0_.nombre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.activo AS activo_2,
  m0_.orden AS orden_3,
  m0_.created_at AS created_at_4
FROM
  motivo_contacto m0_
WHERE
  m0_.activo = ?
ORDER BY
  m0_.orden ASC,
  m0_.nombre ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.activo AS activo_2, m0_.orden AS orden_3, m0_.created_at AS created_at_4 FROM motivo_contacto m0_ WHERE m0_.activo = 1 ORDER BY m0_.orden ASC, m0_.nombre ASC;

#	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->getResult (line 688)
6	App\Repository\MotivoContactoRepository->findActiveOrdered (line 32)
7	App\Controller\ContactController->index (line 27)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

4.77 ms
(1.59%)

SELECT i0_.id AS id_0, i0_.filename AS filename_1, i0_.filename_mobile AS filename_mobile_2, i0_.path AS path_3, i0_.link AS link_4, i0_.size AS size_5, i0_.mime_type AS mime_type_6, i0_.size_mobile AS size_mobile_7, i0_.mime_type_mobile AS mime_type_mobile_8, i0_.alt AS alt_9, i0_.titulo AS titulo_10, i0_.descripcion AS descripcion_11, i0_.llave AS llave_12, i0_.seccion AS seccion_13, i0_.orden AS orden_14, i0_.visible AS visible_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.galeria_id AS galeria_id_18 FROM imagenes i0_ WHERE i0_.llave = ? AND i0_.visible = ?

Parameters:

[
  "img-favicon"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.filename AS filename_1,
  i0_.filename_mobile AS filename_mobile_2,
  i0_.path AS path_3,
  i0_.link AS link_4,
  i0_.size AS size_5,
  i0_.mime_type AS mime_type_6,
  i0_.size_mobile AS size_mobile_7,
  i0_.mime_type_mobile AS mime_type_mobile_8,
  i0_.alt AS alt_9,
  i0_.titulo AS titulo_10,
  i0_.descripcion AS descripcion_11,
  i0_.llave AS llave_12,
  i0_.seccion AS seccion_13,
  i0_.orden AS orden_14,
  i0_.visible AS visible_15,
  i0_.created_at AS created_at_16,
  i0_.updated_at AS updated_at_17,
  i0_.galeria_id AS galeria_id_18
FROM
  imagenes i0_
WHERE
  i0_.llave = ?
  AND i0_.visible = ?

SELECT i0_.id AS id_0, i0_.filename AS filename_1, i0_.filename_mobile AS filename_mobile_2, i0_.path AS path_3, i0_.link AS link_4, i0_.size AS size_5, i0_.mime_type AS mime_type_6, i0_.size_mobile AS size_mobile_7, i0_.mime_type_mobile AS mime_type_mobile_8, i0_.alt AS alt_9, i0_.titulo AS titulo_10, i0_.descripcion AS descripcion_11, i0_.llave AS llave_12, i0_.seccion AS seccion_13, i0_.orden AS orden_14, i0_.visible AS visible_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.galeria_id AS galeria_id_18 FROM imagenes i0_ WHERE i0_.llave = 'img-favicon' AND i0_.visible = 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\ImagenRepository->findByLlave (line 53)
7	App\Service\ImagenService->getImagenByLlave (line 22)
8	App\Service\QI->getImagen (line 64)
9	Twig\Extension\CoreExtension->getAttribute (line 1919)
10	__TwigTemplate_63cc729f47b309b6e0c3099850820b77::doDisplay (line 67)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_86a2d609c892318084fd8699b7c95990->doDisplay (line 56)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\ContactController->index (line 37)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

2.79 ms
(0.93%)

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.orden AS orden_3, t0_.visible AS visible_4, t0_.created_at AS created_at_5 FROM tipos_vehiculo t0_ WHERE t0_.visible = ? ORDER BY t0_.orden ASC, t0_.nombre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1,
  t0_.descripcion AS descripcion_2,
  t0_.orden AS orden_3,
  t0_.visible AS visible_4,
  t0_.created_at AS created_at_5
FROM
  tipos_vehiculo t0_
WHERE
  t0_.visible = ?
ORDER BY
  t0_.orden ASC,
  t0_.nombre ASC

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.descripcion AS descripcion_2, t0_.orden AS orden_3, t0_.visible AS visible_4, t0_.created_at AS created_at_5 FROM tipos_vehiculo t0_ WHERE t0_.visible = 1 ORDER BY t0_.orden ASC, t0_.nombre ASC;

#	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->getResult (line 688)
6	App\Repository\TipoVehiculoRepository->findVisibleOrdered (line 48)
7	App\Twig\TipoVehiculoExtension->getTiposVehiculo (line 25)
8	__TwigTemplate_fc6d1cfcf270acd0d5bc42ff69e783e8->doDisplay (line 116)
9	Twig\Template->yield (line 402)
10	__TwigTemplate_63cc729f47b309b6e0c3099850820b77->doDisplay (line 102)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_86a2d609c892318084fd8699b7c95990->doDisplay (line 56)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\ContactController->index (line 37)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	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\Texto	59
App\Entity\Ciudad	50
App\Entity\TipoVehiculo	9
App\Entity\Imagen	4
App\Entity\MotivoContacto	3

Entities Mapping

Class	Mapping errors
App\Entity\Ciudad	No errors.
App\Entity\MotivoContacto	No errors.
App\Entity\Texto	No errors.
App\Entity\Imagen	No errors.
App\Entity\Galeria	No errors.
App\Entity\TipoVehiculo	No errors.

Symfony Profiler

GET https://estrenauto.iridian.co/contacto

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping