Symfony Profiler

Query Metrics

9 Database Queries

6 Different statements

3.54 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.17 ms
(33.09%)

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.56 ms
(15.89%)

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, b0_.categoria_id AS categoria_id_11, b0_.created_by AS created_by_12 FROM blog_entrada b0_ WHERE b0_.created_by = ? AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY b0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

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,
  b0_.categoria_id AS categoria_id_11,
  b0_.created_by AS created_by_12
FROM
  blog_entrada b0_
WHERE
  b0_.created_by = ?
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  b0_.created_at DESC

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, b0_.categoria_id AS categoria_id_11, b0_.created_by AS created_by_12 FROM blog_entrada b0_ WHERE b0_.created_by = '83533' AND b0_.id IN (31, 30, 29, 28, 27, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12, 11) ORDER BY b0_.created_at DESC;

#	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 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
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.56 ms
(15.67%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  "83533"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.enabled AS enabled_3,
  t0.id_openpay AS id_openpay_4,
  t0.id_conecta AS id_conecta_5,
  t0.id_stripe AS id_stripe_6,
  t0.id_stripe_setup_intent AS id_stripe_setup_intent_7,
  t0.has_to_validate_bureau AS has_to_validate_bureau_8,
  t0.image AS image_9,
  t0.image_size AS image_size_10,
  t0.updated_at AS updated_at_11,
  t0.created_at AS created_at_12,
  t0.last_login AS last_login_13,
  t0.pass_expiration_date AS pass_expiration_date_14,
  t0.dark_mode AS dark_mode_15,
  t0.nombres AS nombres_16,
  t0.apellidos AS apellidos_17,
  t0.telefono AS telefono_18,
  t0.cod_postal AS cod_postal_19,
  t0.estado AS estado_20,
  t0.ciudad AS ciudad_21,
  t0.direccion AS direccion_22,
  t0.roles AS roles_23,
  t0.2fa_enabled AS 2fa_enabled_24,
  t0.password AS password_25,
  t0.fetch_id AS fetch_id_26,
  t27.id AS id_28,
  t27.user_id AS user_id_29,
  t27.secret AS secret_30,
  t27.created_at AS created_at_31,
  t27.user_id AS user_id_32
FROM
  usuario t0
  LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = '83533';

#	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 109)
6	App\Controller\BlogController->search (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)

0.54 ms
(15.11%)

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 b0_.created_by = ?) dctrn_result_inner ORDER BY created_at_1 DESC) dctrn_result LIMIT 20

Parameters:

[
  "83533"
]

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
          b0_.created_by = ?
      ) dctrn_result_inner
    ORDER BY
      created_at_1 DESC
  ) dctrn_result
LIMIT
  20

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 b0_.created_by = '83533') dctrn_result_inner ORDER BY created_at_1 DESC) dctrn_result LIMIT 20;

#	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.45 ms
(12.73%)

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 b0_.created_by = ? ORDER BY b0_.created_at DESC) dctrn_result) dctrn_table

Parameters:

[
  "83533"
]

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
          b0_.created_by = ?
        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 b0_.created_by = '83533' 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.27 ms
(7.51%)

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\User	No errors.
App\Entity\Auth\UserAuthentication	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\BlogCategory	No errors.

Symfony Profiler

GET https://efectivate.zentro.com.mx/blog/buscar?autor=83533&pag=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping