Symfony Profiler

Query Metrics

49 Database Queries

4 Different statements

32.36 ms Query time

0 Invalid entities

47 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

26.59 ms
(82.17%)

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:

[
  "home.title_suffix"
  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 = 'home.title_suffix' 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\Twig\TextoExtension->getTexto (line 31)
9	__TwigTemplate_6134b5916f6144ee4c02a06997b82b00->block_title (line 78)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_63cc729f47b309b6e0c3099850820b77->doDisplay (line 62)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_6134b5916f6144ee4c02a06997b82b00->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
22	App\Controller\LegalController->cookies (line 55)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

2.83 ms
(8.75%)

SELECT t0.id AS id_1, t0.llave AS llave_2, t0.tipo AS tipo_3, t0.contenido AS contenido_4, t0.descripcion AS descripcion_5, t0.categoria AS categoria_6, t0.orden AS orden_7, t0.activo AS activo_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM textos_big t0 WHERE t0.llave = ? AND t0.activo = ? LIMIT 1

Parameters:

[
  "legal.cookies.contenido"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.llave AS llave_2,
  t0.tipo AS tipo_3,
  t0.contenido AS contenido_4,
  t0.descripcion AS descripcion_5,
  t0.categoria AS categoria_6,
  t0.orden AS orden_7,
  t0.activo AS activo_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  textos_big t0
WHERE
  t0.llave = ?
  AND t0.activo = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.llave AS llave_2, t0.tipo AS tipo_3, t0.contenido AS contenido_4, t0.descripcion AS descripcion_5, t0.categoria AS categoria_6, t0.orden AS orden_7, t0.activo AS activo_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM textos_big t0 WHERE t0.llave = 'legal.cookies.contenido' AND t0.activo = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\TextoBigRepository->findByLlave (line 47)
5	App\Repository\TextoBigRepository->getContenidoByLlave (line 55)
6	App\Controller\LegalController->cookies (line 50)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

2.06 ms
(6.38%)

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_6134b5916f6144ee4c02a06997b82b00->doDisplay (line 54)
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\LegalController->cookies (line 55)
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)

0.87 ms
(2.70%)

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_6134b5916f6144ee4c02a06997b82b00->doDisplay (line 54)
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\LegalController->cookies (line 55)
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	36
App\Entity\TipoVehiculo	9
App\Entity\TextoBig	1
App\Entity\Imagen	1

Entities Mapping

Class	Mapping errors
App\Entity\TextoBig	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/cookies

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping