Symfony Profiler

Query Metrics

7 Database Queries

4 Different statements

1.90 ms Query time

5 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.86 ms
(45.11%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tiempo_lectura AS tiempo_lectura_3, t0.visitas AS visitas_4, t0.titulo AS titulo_5, t0.resumen AS resumen_6, t0.contenido AS contenido_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.categoria_id AS categoria_id_12, t0.created_by AS created_by_13 FROM blog_entrada t0 WHERE t0.categoria_id = ? ORDER BY t0.created_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.tiempo_lectura AS tiempo_lectura_3,
  t0.visitas AS visitas_4,
  t0.titulo AS titulo_5,
  t0.resumen AS resumen_6,
  t0.contenido AS contenido_7,
  t0.keywords AS keywords_8,
  t0.image AS image_9,
  t0.image_size AS image_size_10,
  t0.updated_at AS updated_at_11,
  t0.categoria_id AS categoria_id_12,
  t0.created_by AS created_by_13
FROM
  blog_entrada t0
WHERE
  t0.categoria_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tiempo_lectura AS tiempo_lectura_3, t0.visitas AS visitas_4, t0.titulo AS titulo_5, t0.resumen AS resumen_6, t0.contenido AS contenido_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.categoria_id AS categoria_id_12, t0.created_by AS created_by_13 FROM blog_entrada t0 WHERE t0.categoria_id = 1 ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 117)
10	__TwigTemplate_9bbd6f594902d14ecc0deefa95cfdc46->{closure} (line 1)
11	array_filter (line 1939)
12	Twig\Extension\CoreExtension::filter (line 117)
13	__TwigTemplate_9bbd6f594902d14ecc0deefa95cfdc46->doDisplay (line 388)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_14ed0b129a7a2d7278acdd40996f4a28->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 129)
24	App\Controller\BlogController->search (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 7)

0.47 ms
(24.68%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.tiempo_lectura AS tiempo_lectura_2, b0_.visitas AS visitas_3, b0_.titulo AS titulo_4, b0_.resumen AS resumen_5, b0_.contenido AS contenido_6, b0_.keywords AS keywords_7, b0_.image AS image_8, b0_.image_size AS image_size_9, b0_.updated_at AS updated_at_10 FROM blog_entrada b0_ WHERE LOWER(b0_.keywords) LIKE ? ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table

Parameters:

[
  "%préstamo%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.created_at AS created_at_1,
          b0_.tiempo_lectura AS tiempo_lectura_2,
          b0_.visitas AS visitas_3,
          b0_.titulo AS titulo_4,
          b0_.resumen AS resumen_5,
          b0_.contenido AS contenido_6,
          b0_.keywords AS keywords_7,
          b0_.image AS image_8,
          b0_.image_size AS image_size_9,
          b0_.updated_at AS updated_at_10
        FROM
          blog_entrada b0_
        WHERE
          LOWER(b0_.keywords) LIKE ?
        ORDER BY
          b0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.tiempo_lectura AS tiempo_lectura_2, b0_.visitas AS visitas_3, b0_.titulo AS titulo_4, b0_.resumen AS resumen_5, b0_.contenido AS contenido_6, b0_.keywords AS keywords_7, b0_.image AS image_8, b0_.image_size AS image_size_9, b0_.updated_at AS updated_at_10 FROM blog_entrada b0_ WHERE LOWER(b0_.keywords) LIKE '%préstamo%' ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 126)
8	App\Controller\BlogController->search (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 7)

0.32 ms
(16.77%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_1 FROM (SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.tiempo_lectura AS tiempo_lectura_2, b0_.visitas AS visitas_3, b0_.titulo AS titulo_4, b0_.resumen AS resumen_5, b0_.contenido AS contenido_6, b0_.keywords AS keywords_7, b0_.image AS image_8, b0_.image_size AS image_size_9, b0_.updated_at AS updated_at_10 FROM blog_entrada b0_ WHERE LOWER(b0_.keywords) LIKE ?) dctrn_result_inner ORDER BY created_at_1 DESC) dctrn_result LIMIT 20 OFFSET 1573200

Parameters:

[
  "%préstamo%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_1
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.created_at AS created_at_1,
          b0_.tiempo_lectura AS tiempo_lectura_2,
          b0_.visitas AS visitas_3,
          b0_.titulo AS titulo_4,
          b0_.resumen AS resumen_5,
          b0_.contenido AS contenido_6,
          b0_.keywords AS keywords_7,
          b0_.image AS image_8,
          b0_.image_size AS image_size_9,
          b0_.updated_at AS updated_at_10
        FROM
          blog_entrada b0_
        WHERE
          LOWER(b0_.keywords) LIKE ?
      ) dctrn_result_inner
    ORDER BY
      created_at_1 DESC
  ) dctrn_result
LIMIT
  20
OFFSET
  1573200

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_1 FROM (SELECT b0_.id AS id_0, b0_.created_at AS created_at_1, b0_.tiempo_lectura AS tiempo_lectura_2, b0_.visitas AS visitas_3, b0_.titulo AS titulo_4, b0_.resumen AS resumen_5, b0_.contenido AS contenido_6, b0_.keywords AS keywords_7, b0_.image AS image_8, b0_.image_size AS image_size_9, b0_.updated_at AS updated_at_10 FROM blog_entrada b0_ WHERE LOWER(b0_.keywords) LIKE '%préstamo%') dctrn_result_inner ORDER BY created_at_1 DESC) dctrn_result LIMIT 20 OFFSET 1573200;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 396)
8	__TwigTemplate_14ed0b129a7a2d7278acdd40996f4a28->block_body (line 432)
9	Twig\Template->yieldBlock (line 186)
10	__TwigTemplate_9bbd6f594902d14ecc0deefa95cfdc46->doDisplay (line 388)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_14ed0b129a7a2d7278acdd40996f4a28->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 334)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 129)
21	App\Controller\BlogController->search (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 7)

0.25 ms
(13.44%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.parent AS parent_4 FROM blog_categoria t0 WHERE t0.parent IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.parent AS parent_4
FROM
  blog_categoria t0
WHERE
  t0.parent IS NULL

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.parent AS parent_4 FROM blog_categoria t0 WHERE t0.parent IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 61)
4	App\Controller\BlogController->category (line 1882)
5	Twig\Extension\CoreExtension::getAttribute (line 117)
6	__TwigTemplate_9bbd6f594902d14ecc0deefa95cfdc46->doDisplay (line 388)
7	Twig\Template->yield (line 55)
8	__TwigTemplate_14ed0b129a7a2d7278acdd40996f4a28->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 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 129)
17	App\Controller\BlogController->search (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\BlogEntry	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\User	No errors.
App\Entity\Loan	No errors.
App\Entity\OpenPay\OpenPayInstrumentos	No errors.
App\Entity\Conecta\ConectaInstrumentos	No errors.
App\Entity\Stripe\StripeInstrumentos	No errors.
App\Entity\Unlimit\UnlimitInstrumentos	No errors.
App\Entity\Log\LoginRegister	No errors.
App\Entity\Auth\UserAuthentication	No errors.
App\Entity\Producto	No errors.
App\Entity\FrecuenciaPago	No errors.
App\Entity\LoanAmortization	No errors.
App\Entity\LoanFee	No errors.
App\Entity\LoanPayment	No errors.
App\Entity\LoanDocument	No errors.
App\Entity\LoanComment	No errors.
App\Entity\LoanBureau	No errors.
App\Entity\LoanForm	No errors.
App\Entity\LoanDeposit	No errors.
App\Entity\LoanPaymentExcess	No errors.
App\Entity\Unlimit\UnlimitErrores	No errors.
App\Entity\Stripe\StripeErrores	No errors.
App\Entity\Amortization	The field 'App\Entity\Amortization#primer_prestamo' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\PeriodQuantity	No errors.
App\Entity\TipoSector	No errors.
App\Entity\SocialNetworkProspectus	No errors.
App\Entity\LoanAmortizationDetail	The field App\Entity\LoanAmortizationDetail#payments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LoanAmortizationDetailPayments#amortizationDetail does not contain the required 'inversedBy="payments"' attribute.
App\Entity\ProductoCategoria	No errors.
App\Entity\Task\TaskQueue	No errors.
App\Entity\Rate	The field 'App\Entity\Rate#tipo_plazo' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type. The field 'App\Entity\Rate#no_plazo' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Stp\StpTransaction	No errors.
App\Entity\LoanAmortizationDetailPayments	No errors.
App\Entity\OpenPay\OpenPayErrores	No errors.
App\Entity\AmortizationDetail	The field 'App\Entity\AmortizationDetail#no_pago' has the property type 'float' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Formularios\Tipo	No errors.
App\Entity\Formularios\Campo	No errors.
App\Entity\Formularios\EmpresasFiliales	No errors.
App\Entity\Formularios\Amortizaciones	The field 'App\Entity\Formularios\Amortizaciones#periodos' uses a non-existent type 'int'.
App\Entity\Formularios\Ciudad	No errors.
App\Entity\Formularios\DocumentoRequerido	No errors.
App\Entity\Formularios\Bancos	No errors.
App\Entity\Formularios\Estado	No errors.
App\Entity\Formularios\Seccion	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://efectivate.zentro.com.mx/blog/buscar?clave=Pr%C3%A9stamo&pag=78661

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping