Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

4.79 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.96 ms
(40.93%)

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.landing_show AS landing_show_3, t0.landing_name AS landing_name_4, t0.image AS image_5, t0.image_size AS image_size_6, t0.updated_at AS updated_at_7 FROM formulario_empresas_filiales t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.landing_show AS landing_show_3,
  t0.landing_name AS landing_name_4,
  t0.image AS image_5,
  t0.image_size AS image_size_6,
  t0.updated_at AS updated_at_7
FROM
  formulario_empresas_filiales t0

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.landing_show AS landing_show_3, t0.landing_name AS landing_name_4, t0.image AS image_5, t0.image_size AS image_size_6, t0.updated_at AS updated_at_7 FROM formulario_empresas_filiales t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 102)
5	App\Controller\FormController->company (line 1754)
6	Twig\Extension\CoreExtension::getAttribute (line 583)
7	__TwigTemplate_a13070fa22435b6c539afdddd8b2673b->block_body (line 437)
8	Twig\Template->yieldBlock (line 198)
9	__TwigTemplate_562b878b802215977443e8ff54505c22->doDisplay (line 393)
10	Twig\Template->yield (line 56)
11	__TwigTemplate_a13070fa22435b6c539afdddd8b2673b->doDisplay (line 393)
12	Twig\Template->yield (line 349)
13	Twig\Template->display (line 364)
14	Twig\Template->render (line 35)
15	Twig\TemplateWrapper->render (line 306)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
20	App\Controller\DefaultController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

1.58 ms
(32.98%)

SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.id_categoria_producto AS id_categoria_producto_12 FROM producto t0 WHERE t0.id_categoria_producto = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.activo AS activo_2,
  t0.descripcion AS descripcion_3,
  t0.mto_minimo AS mto_minimo_4,
  t0.mto_maximo AS mto_maximo_5,
  t0.cat_promedio AS cat_promedio_6,
  t0.interes_anual AS interes_anual_7,
  t0.tasa_interes AS tasa_interes_8,
  t0.plazo_minimo AS plazo_minimo_9,
  t0.plazo_maximo AS plazo_maximo_10,
  t0.interes_mora AS interes_mora_11,
  t0.id_categoria_producto AS id_categoria_producto_12
FROM
  producto t0
WHERE
  t0.id_categoria_producto = ?

SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.id_categoria_producto AS id_categoria_producto_12 FROM producto t0 WHERE t0.id_categoria_producto = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1)
8	IteratorIterator->__construct (line 1811)
9	Twig\Extension\CoreExtension::filter (line 125)
10	__TwigTemplate_a13070fa22435b6c539afdddd8b2673b->block_bannerLeft (line 437)
11	Twig\Template->yieldBlock (line 178)
12	__TwigTemplate_562b878b802215977443e8ff54505c22->doDisplay (line 393)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_a13070fa22435b6c539afdddd8b2673b->doDisplay (line 393)
15	Twig\Template->yield (line 349)
16	Twig\Template->display (line 364)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 51)
23	App\Controller\DefaultController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.72 ms
(15.07%)

SELECT p0_.id AS id_0, p0_.descripcion AS descripcion_1, p0_.resena AS resena_2 FROM producto_categoria p0_ INNER JOIN producto p1_ WHERE p1_.id_categoria_producto = p0_.id AND p1_.activo = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.descripcion AS descripcion_1,
  p0_.resena AS resena_2
FROM
  producto_categoria p0_
  INNER JOIN producto p1_
WHERE
  p1_.id_categoria_producto = p0_.id
  AND p1_.activo = 1

SELECT p0_.id AS id_0, p0_.descripcion AS descripcion_1, p0_.resena AS resena_2 FROM producto_categoria p0_ INNER JOIN producto p1_ WHERE p1_.id_categoria_producto = p0_.id AND p1_.activo = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 33)
7	App\Repository\ProductoRepository->getEnabledCategory (line 52)
8	App\Controller\DefaultController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.53 ms
(11.02%)

SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.id_categoria_producto AS id_categoria_producto_12 FROM producto t0 WHERE t0.activo = ? ORDER BY t0.id_categoria_producto ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.activo AS activo_2,
  t0.descripcion AS descripcion_3,
  t0.mto_minimo AS mto_minimo_4,
  t0.mto_maximo AS mto_maximo_5,
  t0.cat_promedio AS cat_promedio_6,
  t0.interes_anual AS interes_anual_7,
  t0.tasa_interes AS tasa_interes_8,
  t0.plazo_minimo AS plazo_minimo_9,
  t0.plazo_maximo AS plazo_maximo_10,
  t0.interes_mora AS interes_mora_11,
  t0.id_categoria_producto AS id_categoria_producto_12
FROM
  producto t0
WHERE
  t0.activo = ?
ORDER BY
  t0.id_categoria_producto ASC

SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.id_categoria_producto AS id_categoria_producto_12 FROM producto t0 WHERE t0.activo = 1 ORDER BY t0.id_categoria_producto ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 53)
4	App\Controller\DefaultController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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.

Entities Mapping

Class	Mapping errors
App\Entity\Producto	No errors.
App\Entity\ProductoCategoria	No errors.
App\Entity\FrecuenciaPago	No errors.
App\Entity\Formularios\DocumentoRequerido	No errors.
App\Entity\Formularios\Seccion	No errors.
App\Entity\Formularios\EmpresasFiliales	No errors.

Symfony Profiler

GET https://dev.efectivate.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping