Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

1.39 ms Query time

0 Invalid entities

24 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.47 ms
(33.73%)

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:

[
  ""37""
]

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, '\"37\"', '$') = 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 27)
8	App\Controller\TintasController->index (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.34 ms
(24.52%)

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:

[
  "37"
]

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 = '37' 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 21)
5	App\Controller\TintasController->index (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)

0.31 ms
(22.27%)

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 90)
5	App\Controller\TintasController->getCats (line 33)
6	App\Controller\TintasController->index (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.27 ms
(19.48%)

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:

[
  61
]

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 = 61;

#	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 145)
11	__TwigTemplate_61be0c02e41cbbf4f52336a047005c7e->block_body (line 446)
12	Twig\Template->yieldBlock (line 574)
13	__TwigTemplate_b9c395266d9700eccd05f9e8adc5ed1a->doDisplay (line 402)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_61be0c02e41cbbf4f52336a047005c7e->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 31)
24	App\Controller\TintasController->index (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)

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\Categorias	22
App\Entity\Productos	1
App\Entity\Imagenes	1

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/tintas/37

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping