Symfony Profiler

Query Metrics

13 Database Queries

6 Different statements

10.98 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.02 ms
(27.50%)

SELECT id FROM blog_entrada ORDER BY created_at DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  blog_entrada
ORDER BY
  created_at DESC
LIMIT
  10

SELECT id FROM blog_entrada ORDER BY created_at DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 50)
3	App\Controller\BlogController->index (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 7)

2.30 ms
(20.94%)

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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\User->__get (line 341)
8	App\Entity\User->getNombreCompleto (line 315)
9	App\Entity\User->__toString (line 126)
10	Twig\Runtime\EscaperRuntime->escape (line 100)
11	__TwigTemplate_5794140a402b5298440445c0e0a6911c->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 1493)
16	Twig\Extension\CoreExtension::include (line 314)
17	__TwigTemplate_4fcbc74bb3e4e8c760f5f3957f93a8f4->block_body (line 432)
18	Twig\Template->yieldBlock (line 186)
19	__TwigTemplate_9bbd6f594902d14ecc0deefa95cfdc46->doDisplay (line 388)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_4fcbc74bb3e4e8c760f5f3957f93a8f4->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 53)
30	App\Controller\BlogController->index (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 7)

1.91 ms
(17.40%)

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_4fcbc74bb3e4e8c760f5f3957f93a8f4->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 53)
24	App\Controller\BlogController->index (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)

1.75 ms
(15.93%)

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.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

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.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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.id IN (33, 31, 30, 29, 28, 27, 25, 24, 23, 22);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 54)
4	App\Controller\BlogController->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 7)

1.71 ms
(15.57%)

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_4fcbc74bb3e4e8c760f5f3957f93a8f4->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 53)
17	App\Controller\BlogController->index (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)

0.29 ms
(2.66%)

SELECT id FROM blog_entrada ORDER BY visitas DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  blog_entrada
ORDER BY
  visitas DESC
LIMIT
  10

SELECT id FROM blog_entrada ORDER BY visitas DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 51)
3	App\Controller\BlogController->index (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	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\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.

Symfony Profiler

GET https://efectivate.zentro.com.mx/blog/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping