Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.63 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.48 ms

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.primer_prestamo AS primer_prestamo_12, t0.id_categoria_producto AS id_categoria_producto_13 FROM producto t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

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.primer_prestamo AS primer_prestamo_12,
  t0.id_categoria_producto AS id_categoria_producto_13
FROM
  producto t0
WHERE
  t0.id = ?

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.primer_prestamo AS primer_prestamo_12, t0.id_categoria_producto AS id_categoria_producto_13 FROM producto t0 WHERE t0.id = '2';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 59)
6	App\Controller\DefaultController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 7)

1.15 ms

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.numero_dias AS numero_dias_3 FROM frecuencia_pago t0 INNER JOIN producto_frecuencia_pago ON t0.id = producto_frecuencia_pago.frecuencia_pago_id WHERE producto_frecuencia_pago.producto_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.numero_dias AS numero_dias_3
FROM
  frecuencia_pago t0
  INNER JOIN producto_frecuencia_pago ON t0.id = producto_frecuencia_pago.frecuencia_pago_id
WHERE
  producto_frecuencia_pago.producto_id = ?

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.numero_dias AS numero_dias_3 FROM frecuencia_pago t0 INNER JOIN producto_frecuencia_pago ON t0.id = producto_frecuencia_pago.frecuencia_pago_id WHERE producto_frecuencia_pago.producto_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1120)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1042)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
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 59)
8	__TwigTemplate_984f4ae8384b73947cc1afcf851d4893->doDisplay (line 388)
9	Twig\Template->yield (line 344)
10	Twig\Template->display (line 359)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 334)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 232)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 58)
16	App\Controller\DefaultController->index (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 7)

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.

Symfony Profiler

GET https://efectivate.zentro.com.mx/?product=2

Configuration Settings

Theme