Symfony Profiler

Query Metrics

24 Database Queries

4 Different statements

2.01 ms Query time

0 Invalid entities

74 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.00 ms
(49.79%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = ?

Parameters:

[
  56
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.imagen AS imagen_3,
  t0.link AS link_4,
  t0.texto AS texto_5,
  t0.activo AS activo_6,
  t0.producto_id AS producto_id_7
FROM
  imagenes t0
WHERE
  t0.producto_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.link AS link_4, t0.texto AS texto_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM imagenes t0 WHERE t0.producto_id = 56;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 420)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1698)
10	Twig\Extension\CoreExtension::getAttribute (line 167)
11	__TwigTemplate_5cc704e682f652388e6caa85947643fa->block_body (line 446)
12	Twig\Template->yieldBlock (line 574)
13	__TwigTemplate_b9c395266d9700eccd05f9e8adc5ed1a->doDisplay (line 402)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_5cc704e682f652388e6caa85947643fa->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 45)
24	App\Controller\HomeController->maquinas (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.42 ms
(21.03%)

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.resumen AS resumen_2, p0_.descripcion AS descripcion_3, p0_.cabezal AS cabezal_4, p0_.resolucion AS resolucion_5, p0_.tinta AS tinta_6, p0_.url AS url_7, p0_.meta_titulo AS meta_titulo_8, p0_.meta_descripcion AS meta_descripcion_9, p0_.meta_keywords AS meta_keywords_10, p0_.activo AS activo_11, p0_.categorias AS categorias_12, p0_.sub_titulo AS sub_titulo_13, p0_.velocidades AS velocidades_14, p0_.materiales AS materiales_15, p0_.configuracion_cabezales AS configuracion_cabezales_16, p0_.h_estandard AS h_estandard_17, p0_.h_opcionales AS h_opcionales_18, p0_.area_corte AS area_corte_19, p0_.espesor AS espesor_20, p0_.min_hoja AS min_hoja_21, p0_.max_hoja AS max_hoja_22, p0_.min_caja AS min_caja_23, p0_.max_caja AS max_caja_24, p0_.categoria_id AS categoria_id_25 FROM productos p0_ WHERE JSON_CONTAINS(p0_.categorias, ?, '$') = 1 ORDER BY p0_.nombre DESC LIMIT 20

Parameters:

[
  ""12""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.resumen AS resumen_2,
  p0_.descripcion AS descripcion_3,
  p0_.cabezal AS cabezal_4,
  p0_.resolucion AS resolucion_5,
  p0_.tinta AS tinta_6,
  p0_.url AS url_7,
  p0_.meta_titulo AS meta_titulo_8,
  p0_.meta_descripcion AS meta_descripcion_9,
  p0_.meta_keywords AS meta_keywords_10,
  p0_.activo AS activo_11,
  p0_.categorias AS categorias_12,
  p0_.sub_titulo AS sub_titulo_13,
  p0_.velocidades AS velocidades_14,
  p0_.materiales AS materiales_15,
  p0_.configuracion_cabezales AS configuracion_cabezales_16,
  p0_.h_estandard AS h_estandard_17,
  p0_.h_opcionales AS h_opcionales_18,
  p0_.area_corte AS area_corte_19,
  p0_.espesor AS espesor_20,
  p0_.min_hoja AS min_hoja_21,
  p0_.max_hoja AS max_hoja_22,
  p0_.min_caja AS min_caja_23,
  p0_.max_caja AS max_caja_24,
  p0_.categoria_id AS categoria_id_25
FROM
  productos p0_
WHERE
  JSON_CONTAINS(p0_.categorias, ?, '$') = 1
ORDER BY
  p0_.nombre DESC
LIMIT
  20

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.resumen AS resumen_2, p0_.descripcion AS descripcion_3, p0_.cabezal AS cabezal_4, p0_.resolucion AS resolucion_5, p0_.tinta AS tinta_6, p0_.url AS url_7, p0_.meta_titulo AS meta_titulo_8, p0_.meta_descripcion AS meta_descripcion_9, p0_.meta_keywords AS meta_keywords_10, p0_.activo AS activo_11, p0_.categorias AS categorias_12, p0_.sub_titulo AS sub_titulo_13, p0_.velocidades AS velocidades_14, p0_.materiales AS materiales_15, p0_.configuracion_cabezales AS configuracion_cabezales_16, p0_.h_estandard AS h_estandard_17, p0_.h_opcionales AS h_opcionales_18, p0_.area_corte AS area_corte_19, p0_.espesor AS espesor_20, p0_.min_hoja AS min_hoja_21, p0_.max_hoja AS max_hoja_22, p0_.min_caja AS min_caja_23, p0_.max_caja AS max_caja_24, p0_.categoria_id AS categoria_id_25 FROM productos p0_ WHERE JSON_CONTAINS(p0_.categorias, '\"12\"', '$') = 1 ORDER BY p0_.nombre DESC LIMIT 20;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 27)
7	App\Repository\ProductosRepository->findCats (line 41)
8	App\Controller\HomeController->maquinas (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.38 ms
(19.09%)

SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.padre = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.categoria AS categoria_2,
  t0.padre AS padre_3,
  t0.texto AS texto_4,
  t0.logo AS logo_5,
  t0.icono AS icono_6,
  t0.activo AS activo_7
FROM
  categorias t0
WHERE
  t0.padre = ?

SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.padre = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 60)
5	App\Controller\HomeController->getCats (line 48)
6	App\Controller\HomeController->maquinas (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.20 ms
(10.09%)

SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "12"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.categoria AS categoria_2,
  t0.padre AS padre_3,
  t0.texto AS texto_4,
  t0.logo AS logo_5,
  t0.icono AS icono_6,
  t0.activo AS activo_7
FROM
  categorias t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.padre AS padre_3, t0.texto AS texto_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.activo AS activo_7 FROM categorias t0 WHERE t0.id = '12' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 35)
5	App\Controller\HomeController->maquinas (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Imagenes	35
App\Entity\Categorias	21
App\Entity\Productos	18

Entities Mapping

Class	Mapping errors
App\Entity\Categorias	No errors.
App\Entity\Productos	No errors.
App\Entity\Videos	No errors.
App\Entity\Imagenes	No errors.
App\Entity\Archivos	No errors.
App\Entity\Cabezales	No errors.

Symfony Profiler

GET https://largeformatsupplies.store/maquinas/12

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping