Symfony Profiler

Query Metrics

19 Database Queries

5 Different statements

2.67 ms Query time

0 Invalid entities

62 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.12 ms
(41.93%)

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:

[
  73
]

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

#	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 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 50)
8	App\Controller\TintasController->getTinta (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.69 ms
(25.96%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.descripcion AS descripcion_4, t0.cabezal AS cabezal_5, t0.resolucion AS resolucion_6, t0.tinta AS tinta_7, t0.url AS url_8, t0.meta_titulo AS meta_titulo_9, t0.meta_descripcion AS meta_descripcion_10, t0.meta_keywords AS meta_keywords_11, t0.activo AS activo_12, t0.categorias AS categorias_13, t0.sub_titulo AS sub_titulo_14, t0.velocidades AS velocidades_15, t0.materiales AS materiales_16, t0.configuracion_cabezales AS configuracion_cabezales_17, t0.h_estandard AS h_estandard_18, t0.h_opcionales AS h_opcionales_19, t0.area_corte AS area_corte_20, t0.espesor AS espesor_21, t0.min_hoja AS min_hoja_22, t0.max_hoja AS max_hoja_23, t0.min_caja AS min_caja_24, t0.max_caja AS max_caja_25, t0.categoria_id AS categoria_id_26 FROM productos t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "eco-solvente-1y"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.resumen AS resumen_3,
  t0.descripcion AS descripcion_4,
  t0.cabezal AS cabezal_5,
  t0.resolucion AS resolucion_6,
  t0.tinta AS tinta_7,
  t0.url AS url_8,
  t0.meta_titulo AS meta_titulo_9,
  t0.meta_descripcion AS meta_descripcion_10,
  t0.meta_keywords AS meta_keywords_11,
  t0.activo AS activo_12,
  t0.categorias AS categorias_13,
  t0.sub_titulo AS sub_titulo_14,
  t0.velocidades AS velocidades_15,
  t0.materiales AS materiales_16,
  t0.configuracion_cabezales AS configuracion_cabezales_17,
  t0.h_estandard AS h_estandard_18,
  t0.h_opcionales AS h_opcionales_19,
  t0.area_corte AS area_corte_20,
  t0.espesor AS espesor_21,
  t0.min_hoja AS min_hoja_22,
  t0.max_hoja AS max_hoja_23,
  t0.min_caja AS min_caja_24,
  t0.max_caja AS max_caja_25,
  t0.categoria_id AS categoria_id_26
FROM
  productos t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.descripcion AS descripcion_4, t0.cabezal AS cabezal_5, t0.resolucion AS resolucion_6, t0.tinta AS tinta_7, t0.url AS url_8, t0.meta_titulo AS meta_titulo_9, t0.meta_descripcion AS meta_descripcion_10, t0.meta_keywords AS meta_keywords_11, t0.activo AS activo_12, t0.categorias AS categorias_13, t0.sub_titulo AS sub_titulo_14, t0.velocidades AS velocidades_15, t0.materiales AS materiales_16, t0.configuracion_cabezales AS configuracion_cabezales_17, t0.h_estandard AS h_estandard_18, t0.h_opcionales AS h_opcionales_19, t0.area_corte AS area_corte_20, t0.espesor AS espesor_21, t0.min_hoja AS min_hoja_22, t0.max_hoja AS max_hoja_23, t0.min_caja AS min_caja_24, t0.max_caja AS max_caja_25, t0.categoria_id AS categoria_id_26 FROM productos t0 WHERE t0.url = 'eco-solvente-1y' 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 49)
5	App\Controller\TintasController->getTinta (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.42 ms
(15.85%)

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 80)
6	App\Controller\TintasController->getTinta (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.22 ms
(8.42%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.archivo AS archivo_3, t0.orden AS orden_4, t0.idioma AS idioma_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM archivos t0 WHERE t0.producto_id = ? ORDER BY t0.idioma ASC, t0.orden ASC

Parameters:

[
  73
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.archivo AS archivo_3,
  t0.orden AS orden_4,
  t0.idioma AS idioma_5,
  t0.activo AS activo_6,
  t0.producto_id AS producto_id_7
FROM
  archivos t0
WHERE
  t0.producto_id = ?
ORDER BY
  t0.idioma ASC,
  t0.orden ASC

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.archivo AS archivo_3, t0.orden AS orden_4, t0.idioma AS idioma_5, t0.activo AS activo_6, t0.producto_id AS producto_id_7 FROM archivos t0 WHERE t0.producto_id = 73 ORDER BY t0.idioma ASC, t0.orden ASC;

#	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 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 51)
8	App\Controller\TintasController->getTinta (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.21 ms
(7.83%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.descripcion AS descripcion_4, t0.cabezal AS cabezal_5, t0.resolucion AS resolucion_6, t0.tinta AS tinta_7, t0.url AS url_8, t0.meta_titulo AS meta_titulo_9, t0.meta_descripcion AS meta_descripcion_10, t0.meta_keywords AS meta_keywords_11, t0.activo AS activo_12, t0.categorias AS categorias_13, t0.sub_titulo AS sub_titulo_14, t0.velocidades AS velocidades_15, t0.materiales AS materiales_16, t0.configuracion_cabezales AS configuracion_cabezales_17, t0.h_estandard AS h_estandard_18, t0.h_opcionales AS h_opcionales_19, t0.area_corte AS area_corte_20, t0.espesor AS espesor_21, t0.min_hoja AS min_hoja_22, t0.max_hoja AS max_hoja_23, t0.min_caja AS min_caja_24, t0.max_caja AS max_caja_25, t0.categoria_id AS categoria_id_26 FROM productos t0 WHERE t0.categoria_id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.resumen AS resumen_3,
  t0.descripcion AS descripcion_4,
  t0.cabezal AS cabezal_5,
  t0.resolucion AS resolucion_6,
  t0.tinta AS tinta_7,
  t0.url AS url_8,
  t0.meta_titulo AS meta_titulo_9,
  t0.meta_descripcion AS meta_descripcion_10,
  t0.meta_keywords AS meta_keywords_11,
  t0.activo AS activo_12,
  t0.categorias AS categorias_13,
  t0.sub_titulo AS sub_titulo_14,
  t0.velocidades AS velocidades_15,
  t0.materiales AS materiales_16,
  t0.configuracion_cabezales AS configuracion_cabezales_17,
  t0.h_estandard AS h_estandard_18,
  t0.h_opcionales AS h_opcionales_19,
  t0.area_corte AS area_corte_20,
  t0.espesor AS espesor_21,
  t0.min_hoja AS min_hoja_22,
  t0.max_hoja AS max_hoja_23,
  t0.min_caja AS min_caja_24,
  t0.max_caja AS max_caja_25,
  t0.categoria_id AS categoria_id_26
FROM
  productos t0
WHERE
  t0.categoria_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.resumen AS resumen_3, t0.descripcion AS descripcion_4, t0.cabezal AS cabezal_5, t0.resolucion AS resolucion_6, t0.tinta AS tinta_7, t0.url AS url_8, t0.meta_titulo AS meta_titulo_9, t0.meta_descripcion AS meta_descripcion_10, t0.meta_keywords AS meta_keywords_11, t0.activo AS activo_12, t0.categorias AS categorias_13, t0.sub_titulo AS sub_titulo_14, t0.velocidades AS velocidades_15, t0.materiales AS materiales_16, t0.configuracion_cabezales AS configuracion_cabezales_17, t0.h_estandard AS h_estandard_18, t0.h_opcionales AS h_opcionales_19, t0.area_corte AS area_corte_20, t0.espesor AS espesor_21, t0.min_hoja AS min_hoja_22, t0.max_hoja AS max_hoja_23, t0.min_caja AS min_caja_24, t0.max_caja AS max_caja_25, t0.categoria_id AS categoria_id_26 FROM productos t0 WHERE t0.categoria_id = 19;

#	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 72)
5	App\Controller\TintasController->getTinta (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	28
App\Entity\Categorias	22
App\Entity\Productos	12

Entities Mapping

Class	Mapping errors
App\Entity\Productos	No errors.
App\Entity\Categorias	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/tinta/eco-solvente-1y

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping