Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

2.29 ms Query time

2 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.95 ms
(41.27%)

SELECT t0.id AS id_1, t0.fecha_convocatoria AS fecha_convocatoria_2, t0.fecha_documentacion AS fecha_documentacion_3, t0.referencia AS referencia_4, t0.estado AS estado_5, t0.visible AS visible_6, t0.solicitudes_max AS solicitudes_max_7, t0.texto_documentacion AS texto_documentacion_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.certificacion_id AS certificacion_id_11, t0.centro_id AS centro_id_12, t0.documento_id AS documento_id_13, t0.acta_id AS acta_id_14 FROM convocatoria t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fecha_convocatoria AS fecha_convocatoria_2,
  t0.fecha_documentacion AS fecha_documentacion_3,
  t0.referencia AS referencia_4,
  t0.estado AS estado_5,
  t0.visible AS visible_6,
  t0.solicitudes_max AS solicitudes_max_7,
  t0.texto_documentacion AS texto_documentacion_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.certificacion_id AS certificacion_id_11,
  t0.centro_id AS centro_id_12,
  t0.documento_id AS documento_id_13,
  t0.acta_id AS acta_id_14
FROM
  convocatoria t0

SELECT t0.id AS id_1, t0.fecha_convocatoria AS fecha_convocatoria_2, t0.fecha_documentacion AS fecha_documentacion_3, t0.referencia AS referencia_4, t0.estado AS estado_5, t0.visible AS visible_6, t0.solicitudes_max AS solicitudes_max_7, t0.texto_documentacion AS texto_documentacion_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.certificacion_id AS certificacion_id_11, t0.centro_id AS centro_id_12, t0.documento_id AS documento_id_13, t0.acta_id AS acta_id_14 FROM convocatoria t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 42)
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 5)

0.70 ms
(30.33%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.filename_original AS filename_original_3, t0.view_filename AS view_filename_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.certificacion_id AS certificacion_id_8, t9.id AS id_10, t9.fecha_convocatoria AS fecha_convocatoria_11, t9.fecha_documentacion AS fecha_documentacion_12, t9.referencia AS referencia_13, t9.estado AS estado_14, t9.visible AS visible_15, t9.solicitudes_max AS solicitudes_max_16, t9.texto_documentacion AS texto_documentacion_17, t9.created_at AS created_at_18, t9.updated_at AS updated_at_19, t9.certificacion_id AS certificacion_id_20, t9.centro_id AS centro_id_21, t9.documento_id AS documento_id_22, t9.acta_id AS acta_id_23, t0.categoria_id AS categoria_id_24, t25.id AS id_26, t25.numero_certificado AS numero_certificado_27, t25.fecha_expedicion AS fecha_expedicion_28, t25.fecha_renovacion AS fecha_renovacion_29, t25.fecha_caducidad AS fecha_caducidad_30, t25.created_at AS created_at_31, t25.updated_at AS updated_at_32, t25.certificacion_id AS certificacion_id_33, t25.profesional_id AS profesional_id_34, t25.documento_id AS documento_id_35 FROM documento t0 LEFT JOIN convocatoria t9 ON t9.documento_id = t0.id LEFT JOIN certificado t25 ON t25.documento_id = t0.id WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.filename_original AS filename_original_3,
  t0.view_filename AS view_filename_4,
  t0.path AS path_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.certificacion_id AS certificacion_id_8,
  t9.id AS id_10,
  t9.fecha_convocatoria AS fecha_convocatoria_11,
  t9.fecha_documentacion AS fecha_documentacion_12,
  t9.referencia AS referencia_13,
  t9.estado AS estado_14,
  t9.visible AS visible_15,
  t9.solicitudes_max AS solicitudes_max_16,
  t9.texto_documentacion AS texto_documentacion_17,
  t9.created_at AS created_at_18,
  t9.updated_at AS updated_at_19,
  t9.certificacion_id AS certificacion_id_20,
  t9.centro_id AS centro_id_21,
  t9.documento_id AS documento_id_22,
  t9.acta_id AS acta_id_23,
  t0.categoria_id AS categoria_id_24,
  t25.id AS id_26,
  t25.numero_certificado AS numero_certificado_27,
  t25.fecha_expedicion AS fecha_expedicion_28,
  t25.fecha_renovacion AS fecha_renovacion_29,
  t25.fecha_caducidad AS fecha_caducidad_30,
  t25.created_at AS created_at_31,
  t25.updated_at AS updated_at_32,
  t25.certificacion_id AS certificacion_id_33,
  t25.profesional_id AS profesional_id_34,
  t25.documento_id AS documento_id_35
FROM
  documento t0
  LEFT JOIN convocatoria t9 ON t9.documento_id = t0.id
  LEFT JOIN certificado t25 ON t25.documento_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.filename_original AS filename_original_3, t0.view_filename AS view_filename_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.certificacion_id AS certificacion_id_8, t9.id AS id_10, t9.fecha_convocatoria AS fecha_convocatoria_11, t9.fecha_documentacion AS fecha_documentacion_12, t9.referencia AS referencia_13, t9.estado AS estado_14, t9.visible AS visible_15, t9.solicitudes_max AS solicitudes_max_16, t9.texto_documentacion AS texto_documentacion_17, t9.created_at AS created_at_18, t9.updated_at AS updated_at_19, t9.certificacion_id AS certificacion_id_20, t9.centro_id AS centro_id_21, t9.documento_id AS documento_id_22, t9.acta_id AS acta_id_23, t0.categoria_id AS categoria_id_24, t25.id AS id_26, t25.numero_certificado AS numero_certificado_27, t25.fecha_expedicion AS fecha_expedicion_28, t25.fecha_renovacion AS fecha_renovacion_29, t25.fecha_caducidad AS fecha_caducidad_30, t25.created_at AS created_at_31, t25.updated_at AS updated_at_32, t25.certificacion_id AS certificacion_id_33, t25.profesional_id AS profesional_id_34, t25.documento_id AS documento_id_35 FROM documento t0 LEFT JOIN convocatoria t9 ON t9.documento_id = t0.id LEFT JOIN certificado t25 ON t25.documento_id = t0.id WHERE t0.id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Documento::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Documento->__get (line 135)
8	App\Entity\Documento->getPath (line 153)
9	App\Entity\Documento->getViewFilename (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 339)
11	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->block_page (line 432)
12	Twig\Template->yieldBlock (line 114)
13	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->block_body (line 432)
14	Twig\Template->yieldBlock (line 74)
15	__TwigTemplate_2c2d2c8c127dbcbd67e85e3583c29ca2->doDisplay (line 388)
16	Twig\Template->yield (line 59)
17	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 74)
26	App\Controller\DefaultController->index (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.42 ms
(18.41%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.referencia AS referencia_3, t0.texto AS texto_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM certificacion t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.referencia AS referencia_3,
  t0.texto AS texto_4,
  t0.deleted_at AS deleted_at_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  certificacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.referencia AS referencia_3, t0.texto AS texto_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM certificacion t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Certificacion::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Certificacion->__get (line 80)
8	App\Entity\Certificacion->getNombre (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 330)
10	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->block_page (line 432)
11	Twig\Template->yieldBlock (line 114)
12	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->block_body (line 432)
13	Twig\Template->yieldBlock (line 74)
14	__TwigTemplate_2c2d2c8c127dbcbd67e85e3583c29ca2->doDisplay (line 388)
15	Twig\Template->yield (line 59)
16	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 74)
25	App\Controller\DefaultController->index (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.23 ms
(9.99%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.referencia AS referencia_3, t0.domicilio AS domicilio_4, t0.poblacion AS poblacion_5, t0.usuario_id AS usuario_id_6 FROM centro t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.referencia AS referencia_3,
  t0.domicilio AS domicilio_4,
  t0.poblacion AS poblacion_5,
  t0.usuario_id AS usuario_id_6
FROM
  centro t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.referencia AS referencia_3, t0.domicilio AS domicilio_4, t0.poblacion AS poblacion_5, t0.usuario_id AS usuario_id_6 FROM centro t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Centro::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Centro->__get (line 187)
8	App\Entity\Centro->getPoblacion (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 334)
10	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->block_page (line 432)
11	Twig\Template->yieldBlock (line 114)
12	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->block_body (line 432)
13	Twig\Template->yieldBlock (line 74)
14	__TwigTemplate_2c2d2c8c127dbcbd67e85e3583c29ca2->doDisplay (line 388)
15	Twig\Template->yield (line 59)
16	__TwigTemplate_ff88eb44679d672c1f5c5d59f8041607->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 448)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 74)
25	App\Controller\DefaultController->index (line 181)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Convocatoria	6
App\Entity\Documento	6
App\Entity\Centro	3
App\Entity\Certificacion	2
App\Entity\Acta	1
App\Entity\Usuario	1
App\Entity\Categoria	1

Entities Mapping

Class	Mapping errors
App\Entity\Convocatoria	No errors.
App\Entity\Certificacion	No errors.
App\Entity\Centro	No errors.
App\Entity\Documento	The field App\Entity\Documento#convocatoria is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Convocatoria#documento does not contain the required 'inversedBy="convocatoria"' attribute. The field App\Entity\Documento#certificado is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Certificado#documento does not contain the required 'inversedBy="certificado"' attribute.
App\Entity\Acta	The field App\Entity\Acta#convocatoria is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Convocatoria#acta does not contain the required 'inversedBy="convocatoria"' attribute.
App\Entity\Plaza	No errors.
Sonata\UserBundle\Entity\BaseUser3	No errors.
App\Entity\Usuario	No errors.
App\Entity\EmailAvisoEnviado	No errors.
App\Entity\Interes	No errors.
App\Entity\Certificado	No errors.
App\Entity\Categoria	No errors.

Symfony Profiler

GET https://areaprivada.marlocertificaciones.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping