Symfony Profiler

Query Metrics

8 Database Queries

5 Different statements

6.61 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.78 ms
(42.00%)

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 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 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1202)
9	Twig\Extension\CoreExtension::length (line 117)
10	__TwigTemplate_8c2d65e343f4fd2612602584523b5980->{closure} (line 1)
11	array_filter (line 1807)
12	Twig\Extension\CoreExtension::filter (line 117)
13	__TwigTemplate_8c2d65e343f4fd2612602584523b5980->doDisplay (line 393)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_20023926120cbc689c7a4215fba7099c->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
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 5)

1.26 ms
(19.09%)

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 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 937)
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 5)

1.01 ms
(15.32%)

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.dark_mode AS dark_mode_14, t0.nombres AS nombres_15, t0.apellidos AS apellidos_16, t0.telefono AS telefono_17, t0.cod_postal AS cod_postal_18, t0.estado AS estado_19, t0.ciudad AS ciudad_20, t0.direccion AS direccion_21, t0.roles AS roles_22, t0.password AS password_23, t0.fetch_id AS fetch_id_24 FROM usuario t0 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.dark_mode AS dark_mode_14,
  t0.nombres AS nombres_15,
  t0.apellidos AS apellidos_16,
  t0.telefono AS telefono_17,
  t0.cod_postal AS cod_postal_18,
  t0.estado AS estado_19,
  t0.ciudad AS ciudad_20,
  t0.direccion AS direccion_21,
  t0.roles AS roles_22,
  t0.password AS password_23,
  t0.fetch_id AS fetch_id_24
FROM
  usuario t0
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.dark_mode AS dark_mode_14, t0.nombres AS nombres_15, t0.apellidos AS apellidos_16, t0.telefono AS telefono_17, t0.cod_postal AS cod_postal_18, t0.estado AS estado_19, t0.ciudad AS ciudad_20, t0.direccion AS direccion_21, t0.roles AS roles_22, t0.password AS password_23, t0.fetch_id AS fetch_id_24 FROM usuario t0 WHERE t0.id = '83533';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
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 5)

0.93 ms
(14.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 OFFSET 4420

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 OFFSET 4420

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 OFFSET 4420;

#	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 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 396)
8	__TwigTemplate_20023926120cbc689c7a4215fba7099c->block_body (line 437)
9	Twig\Template->yieldBlock (line 186)
10	__TwigTemplate_8c2d65e343f4fd2612602584523b5980->doDisplay (line 393)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_20023926120cbc689c7a4215fba7099c->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
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 5)

0.63 ms
(9.48%)

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 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 61)
4	App\Controller\BlogController->category (line 1754)
5	Twig\Extension\CoreExtension::getAttribute (line 117)
6	__TwigTemplate_8c2d65e343f4fd2612602584523b5980->doDisplay (line 393)
7	Twig\Template->yield (line 55)
8	__TwigTemplate_20023926120cbc689c7a4215fba7099c->doDisplay (line 393)
9	Twig\Template->yield (line 349)
10	Twig\Template->display (line 364)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 306)
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 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\BlogEntry	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\BlogCategory	No errors.

Symfony Profiler

GET https://dev.efectivate.com/blog/buscar?autor=83533&pag=222

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping