Symfony Profiler

Query Metrics

28 Database Queries

17 Different statements

53.99 ms Query time

0 Invalid entities

30 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.11 ms
(20.57%)

SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.empresa_id AS empresa_id_5 FROM imagen_empresa t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nombre AS nombre_1,
  t0.original AS original_2,
  t0.peso AS peso_3,
  t0.id AS id_4,
  t0.empresa_id AS empresa_id_5
FROM
  imagen_empresa t0
WHERE
  t0.empresa_id = ?

SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.empresa_id AS empresa_id_5 FROM imagen_empresa t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_18f08c88928027d2dd89752269c55f6b::block_content (line 194)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

9.80 ms
(18.15%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.crpo AS crpo_3, t0.comunidad_autonoma_id AS comunidad_autonoma_id_4 FROM provincia t0 WHERE t0.id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.crpo AS crpo_3,
  t0.comunidad_autonoma_id AS comunidad_autonoma_id_4
FROM
  provincia t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.crpo AS crpo_3, t0.comunidad_autonoma_id AS comunidad_autonoma_id_4 FROM provincia t0 WHERE t0.id = 14;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Provincia::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Provincia->__get (line 153)
7	App\Entity\Provincia->getNombre (line 46)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_18f08c88928027d2dd89752269c55f6b::block_content (line 492)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

8.81 ms
(16.32%)

SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.empresa_id AS empresa_id_5 FROM documento_empresa t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nombre AS nombre_1,
  t0.original AS original_2,
  t0.peso AS peso_3,
  t0.id AS id_4,
  t0.empresa_id AS empresa_id_5
FROM
  documento_empresa t0
WHERE
  t0.empresa_id = ?

SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.empresa_id AS empresa_id_5 FROM documento_empresa t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_18f08c88928027d2dd89752269c55f6b::block_content (line 383)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

8.37 ms
(15.50%)

SELECT e0_.id AS id_0, e0_.nombre_fiscal AS nombre_fiscal_1, e0_.nombre_comercial AS nombre_comercial_2, e0_.nif AS nif_3, e0_.actividad_empresarial AS actividad_empresarial_4, e0_.nombre_representante_legal AS nombre_representante_legal_5, e0_.cargo_representante_legal AS cargo_representante_legal_6, e0_.telefono_representante_legal AS telefono_representante_legal_7, e0_.fecha_creacion AS fecha_creacion_8, e0_.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_9, e0_.email AS email_10, e0_.email_comercial AS email_comercial_11, e0_.pagina_web AS pagina_web_12, e0_.video_promocional AS video_promocional_13, e0_.logo AS logo_14, e0_.personal_laboral AS personal_laboral_15, e0_.personal_laboral_mujeres AS personal_laboral_mujeres_16, e0_.personal_laboral_hombres AS personal_laboral_hombres_17, e0_.volumen_facturacion_anual AS volumen_facturacion_anual_18, e0_.sello_pyme_innovadora AS sello_pyme_innovadora_19, e0_.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_20, e0_.deducciones_fiscales AS deducciones_fiscales_21, e0_.proveedor_homologado AS proveedor_homologado_22, e0_.dispone_certificacion AS dispone_certificacion_23, e0_.visible AS visible_24, e0_.facebook AS facebook_25, e0_.linkedin AS linkedin_26, e0_.instagram AS instagram_27, e0_.twitter AS twitter_28, e0_.deshabilitar AS deshabilitar_29, e0_.tipo_empresa_id AS tipo_empresa_id_30 FROM empresa e0_ WHERE e0_.visible = 1 AND (e0_.deshabilitar = 0 OR e0_.deshabilitar IS NULL) ORDER BY e0_.id DESC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.nombre_fiscal AS nombre_fiscal_1,
  e0_.nombre_comercial AS nombre_comercial_2,
  e0_.nif AS nif_3,
  e0_.actividad_empresarial AS actividad_empresarial_4,
  e0_.nombre_representante_legal AS nombre_representante_legal_5,
  e0_.cargo_representante_legal AS cargo_representante_legal_6,
  e0_.telefono_representante_legal AS telefono_representante_legal_7,
  e0_.fecha_creacion AS fecha_creacion_8,
  e0_.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_9,
  e0_.email AS email_10,
  e0_.email_comercial AS email_comercial_11,
  e0_.pagina_web AS pagina_web_12,
  e0_.video_promocional AS video_promocional_13,
  e0_.logo AS logo_14,
  e0_.personal_laboral AS personal_laboral_15,
  e0_.personal_laboral_mujeres AS personal_laboral_mujeres_16,
  e0_.personal_laboral_hombres AS personal_laboral_hombres_17,
  e0_.volumen_facturacion_anual AS volumen_facturacion_anual_18,
  e0_.sello_pyme_innovadora AS sello_pyme_innovadora_19,
  e0_.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_20,
  e0_.deducciones_fiscales AS deducciones_fiscales_21,
  e0_.proveedor_homologado AS proveedor_homologado_22,
  e0_.dispone_certificacion AS dispone_certificacion_23,
  e0_.visible AS visible_24,
  e0_.facebook AS facebook_25,
  e0_.linkedin AS linkedin_26,
  e0_.instagram AS instagram_27,
  e0_.twitter AS twitter_28,
  e0_.deshabilitar AS deshabilitar_29,
  e0_.tipo_empresa_id AS tipo_empresa_id_30
FROM
  empresa e0_
WHERE
  e0_.visible = 1
  AND (
    e0_.deshabilitar = 0
    OR e0_.deshabilitar IS NULL
  )
ORDER BY
  e0_.id DESC
LIMIT
  4

SELECT e0_.id AS id_0, e0_.nombre_fiscal AS nombre_fiscal_1, e0_.nombre_comercial AS nombre_comercial_2, e0_.nif AS nif_3, e0_.actividad_empresarial AS actividad_empresarial_4, e0_.nombre_representante_legal AS nombre_representante_legal_5, e0_.cargo_representante_legal AS cargo_representante_legal_6, e0_.telefono_representante_legal AS telefono_representante_legal_7, e0_.fecha_creacion AS fecha_creacion_8, e0_.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_9, e0_.email AS email_10, e0_.email_comercial AS email_comercial_11, e0_.pagina_web AS pagina_web_12, e0_.video_promocional AS video_promocional_13, e0_.logo AS logo_14, e0_.personal_laboral AS personal_laboral_15, e0_.personal_laboral_mujeres AS personal_laboral_mujeres_16, e0_.personal_laboral_hombres AS personal_laboral_hombres_17, e0_.volumen_facturacion_anual AS volumen_facturacion_anual_18, e0_.sello_pyme_innovadora AS sello_pyme_innovadora_19, e0_.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_20, e0_.deducciones_fiscales AS deducciones_fiscales_21, e0_.proveedor_homologado AS proveedor_homologado_22, e0_.dispone_certificacion AS dispone_certificacion_23, e0_.visible AS visible_24, e0_.facebook AS facebook_25, e0_.linkedin AS linkedin_26, e0_.instagram AS instagram_27, e0_.twitter AS twitter_28, e0_.deshabilitar AS deshabilitar_29, e0_.tipo_empresa_id AS tipo_empresa_id_30 FROM empresa e0_ WHERE e0_.visible = 1 AND (e0_.deshabilitar = 0 OR e0_.deshabilitar IS NULL) ORDER BY e0_.id DESC LIMIT 4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\EmpresaRepository->getLastNews (line 96)
7	App\Service\CatalogoService->obtenerUltimasNovedades (line 65)
8	App\Controller\CatalogoController->app_catalogo_empresa (line 110)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

3.83 ms
(7.09%)

SELECT t0.id AS id_1, t0.direccion AS direccion_2, t0.codigo_postal AS codigo_postal_3, t0.telefono AS telefono_4, t0.principal AS principal_5, t0.empresa_id AS empresa_id_6, t0.pais_id AS pais_id_7, t0.comunidad_autonoma_id AS comunidad_autonoma_id_8, t0.provincia_id AS provincia_id_9, t0.municipio_id AS municipio_id_10, t0.isla_id AS isla_id_11 FROM direccion t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.direccion AS direccion_2,
  t0.codigo_postal AS codigo_postal_3,
  t0.telefono AS telefono_4,
  t0.principal AS principal_5,
  t0.empresa_id AS empresa_id_6,
  t0.pais_id AS pais_id_7,
  t0.comunidad_autonoma_id AS comunidad_autonoma_id_8,
  t0.provincia_id AS provincia_id_9,
  t0.municipio_id AS municipio_id_10,
  t0.isla_id AS isla_id_11
FROM
  direccion t0
WHERE
  t0.empresa_id = ?

SELECT t0.id AS id_1, t0.direccion AS direccion_2, t0.codigo_postal AS codigo_postal_3, t0.telefono AS telefono_4, t0.principal AS principal_5, t0.empresa_id AS empresa_id_6, t0.pais_id AS pais_id_7, t0.comunidad_autonoma_id AS comunidad_autonoma_id_8, t0.provincia_id AS provincia_id_9, t0.municipio_id AS municipio_id_10, t0.isla_id AS isla_id_11 FROM direccion t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->block_content (line 446)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

2.52 ms
(4.66%)

SELECT t0.id AS id_1, t0.nombre_fiscal AS nombre_fiscal_2, t0.nombre_comercial AS nombre_comercial_3, t0.nif AS nif_4, t0.actividad_empresarial AS actividad_empresarial_5, t0.nombre_representante_legal AS nombre_representante_legal_6, t0.cargo_representante_legal AS cargo_representante_legal_7, t0.telefono_representante_legal AS telefono_representante_legal_8, t0.fecha_creacion AS fecha_creacion_9, t0.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_10, t0.email AS email_11, t0.email_comercial AS email_comercial_12, t0.pagina_web AS pagina_web_13, t0.video_promocional AS video_promocional_14, t0.logo AS logo_15, t0.personal_laboral AS personal_laboral_16, t0.personal_laboral_mujeres AS personal_laboral_mujeres_17, t0.personal_laboral_hombres AS personal_laboral_hombres_18, t0.volumen_facturacion_anual AS volumen_facturacion_anual_19, t0.sello_pyme_innovadora AS sello_pyme_innovadora_20, t0.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_21, t0.deducciones_fiscales AS deducciones_fiscales_22, t0.proveedor_homologado AS proveedor_homologado_23, t0.dispone_certificacion AS dispone_certificacion_24, t0.visible AS visible_25, t0.facebook AS facebook_26, t0.linkedin AS linkedin_27, t0.instagram AS instagram_28, t0.twitter AS twitter_29, t0.deshabilitar AS deshabilitar_30, t0.tipo_empresa_id AS tipo_empresa_id_31 FROM empresa t0 WHERE t0.id = ?

Parameters:

[
  "39"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre_fiscal AS nombre_fiscal_2,
  t0.nombre_comercial AS nombre_comercial_3,
  t0.nif AS nif_4,
  t0.actividad_empresarial AS actividad_empresarial_5,
  t0.nombre_representante_legal AS nombre_representante_legal_6,
  t0.cargo_representante_legal AS cargo_representante_legal_7,
  t0.telefono_representante_legal AS telefono_representante_legal_8,
  t0.fecha_creacion AS fecha_creacion_9,
  t0.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_10,
  t0.email AS email_11,
  t0.email_comercial AS email_comercial_12,
  t0.pagina_web AS pagina_web_13,
  t0.video_promocional AS video_promocional_14,
  t0.logo AS logo_15,
  t0.personal_laboral AS personal_laboral_16,
  t0.personal_laboral_mujeres AS personal_laboral_mujeres_17,
  t0.personal_laboral_hombres AS personal_laboral_hombres_18,
  t0.volumen_facturacion_anual AS volumen_facturacion_anual_19,
  t0.sello_pyme_innovadora AS sello_pyme_innovadora_20,
  t0.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_21,
  t0.deducciones_fiscales AS deducciones_fiscales_22,
  t0.proveedor_homologado AS proveedor_homologado_23,
  t0.dispone_certificacion AS dispone_certificacion_24,
  t0.visible AS visible_25,
  t0.facebook AS facebook_26,
  t0.linkedin AS linkedin_27,
  t0.instagram AS instagram_28,
  t0.twitter AS twitter_29,
  t0.deshabilitar AS deshabilitar_30,
  t0.tipo_empresa_id AS tipo_empresa_id_31
FROM
  empresa t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre_fiscal AS nombre_fiscal_2, t0.nombre_comercial AS nombre_comercial_3, t0.nif AS nif_4, t0.actividad_empresarial AS actividad_empresarial_5, t0.nombre_representante_legal AS nombre_representante_legal_6, t0.cargo_representante_legal AS cargo_representante_legal_7, t0.telefono_representante_legal AS telefono_representante_legal_8, t0.fecha_creacion AS fecha_creacion_9, t0.fecha_incorporacion_cluster AS fecha_incorporacion_cluster_10, t0.email AS email_11, t0.email_comercial AS email_comercial_12, t0.pagina_web AS pagina_web_13, t0.video_promocional AS video_promocional_14, t0.logo AS logo_15, t0.personal_laboral AS personal_laboral_16, t0.personal_laboral_mujeres AS personal_laboral_mujeres_17, t0.personal_laboral_hombres AS personal_laboral_hombres_18, t0.volumen_facturacion_anual AS volumen_facturacion_anual_19, t0.sello_pyme_innovadora AS sello_pyme_innovadora_20, t0.caducidad_sello_pyme_innovadora AS caducidad_sello_pyme_innovadora_21, t0.deducciones_fiscales AS deducciones_fiscales_22, t0.proveedor_homologado AS proveedor_homologado_23, t0.dispone_certificacion AS dispone_certificacion_24, t0.visible AS visible_25, t0.facebook AS facebook_26, t0.linkedin AS linkedin_27, t0.instagram AS instagram_28, t0.twitter AS twitter_29, t0.deshabilitar AS deshabilitar_30, t0.tipo_empresa_id AS tipo_empresa_id_31 FROM empresa t0 WHERE t0.id = '39';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 182)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 5)

1.97 ms
(3.65%)

SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.servicio_id AS servicio_id_5 FROM imagen_servicio t0 WHERE t0.servicio_id = ?

Parameters:

[
  73
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nombre AS nombre_1,
  t0.original AS original_2,
  t0.peso AS peso_3,
  t0.id AS id_4,
  t0.servicio_id AS servicio_id_5
FROM
  imagen_servicio t0
WHERE
  t0.servicio_id = ?

SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.servicio_id AS servicio_id_5 FROM imagen_servicio t0 WHERE t0.servicio_id = 73;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_7e66475737f54295d7c6457b8617f8d0::doDisplay (line 111)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->block_content (line 768)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
24	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.69 ms
(3.13%)

SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.servicio_id AS servicio_id_5 FROM documento_servicio t0 WHERE t0.servicio_id = ?

Parameters:

[
  73
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.nombre AS nombre_1,
  t0.original AS original_2,
  t0.peso AS peso_3,
  t0.id AS id_4,
  t0.servicio_id AS servicio_id_5
FROM
  documento_servicio t0
WHERE
  t0.servicio_id = ?

SELECT t0.nombre AS nombre_1, t0.original AS original_2, t0.peso AS peso_3, t0.id AS id_4, t0.servicio_id AS servicio_id_5 FROM documento_servicio t0 WHERE t0.servicio_id = 73;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1272)
9	__TwigTemplate_7e66475737f54295d7c6457b8617f8d0::doDisplay (line 156)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->block_content (line 768)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
24	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 182)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

1.06 ms
(1.97%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.crpo AS crpo_3 FROM municipio t0 WHERE t0.id = ?

Parameters:

[
  5252
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.crpo AS crpo_3
FROM
  municipio t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.crpo AS crpo_3 FROM municipio t0 WHERE t0.id = 5252;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Municipio::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Municipio->__get (line 153)
7	App\Entity\Municipio->getNombre (line 42)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_18f08c88928027d2dd89752269c55f6b::block_content (line 486)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.98 ms
(1.81%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.subvencionado AS subvencionado_4, t0.url AS url_5, t0.observaciones AS observaciones_6, t0.visible AS visible_7, t0.colaboracion AS colaboracion_8, t0.empresa_id AS empresa_id_9, t0.convocatoria_id AS convocatoria_id_10 FROM servicio t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

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.subvencionado AS subvencionado_4,
  t0.url AS url_5,
  t0.observaciones AS observaciones_6,
  t0.visible AS visible_7,
  t0.colaboracion AS colaboracion_8,
  t0.empresa_id AS empresa_id_9,
  t0.convocatoria_id AS convocatoria_id_10
FROM
  servicio t0
WHERE
  t0.empresa_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.subvencionado AS subvencionado_4, t0.url AS url_5, t0.observaciones AS observaciones_6, t0.visible AS visible_7, t0.colaboracion AS colaboracion_8, t0.empresa_id AS empresa_id_9, t0.convocatoria_id AS convocatoria_id_10 FROM servicio t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->block_content (line 665)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.92 ms
(1.70%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3 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.imagen AS imagen_3
FROM
  certificacion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3 FROM certificacion t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Certificacion::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Certificacion->__get (line 153)
7	App\Entity\Certificacion->getImagen (line 54)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_18f08c88928027d2dd89752269c55f6b::block_content (line 1107)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.77 ms
(1.42%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cargo AS cargo_3, t0.telefono AS telefono_4, t0.email AS email_5, t0.telefono_telegram AS telefono_telegram_6, t0.publico AS publico_7, t0.empresa_id AS empresa_id_8 FROM persona_contacto t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.cargo AS cargo_3,
  t0.telefono AS telefono_4,
  t0.email AS email_5,
  t0.telefono_telegram AS telefono_telegram_6,
  t0.publico AS publico_7,
  t0.empresa_id AS empresa_id_8
FROM
  persona_contacto t0
WHERE
  t0.empresa_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cargo AS cargo_3, t0.telefono AS telefono_4, t0.email AS email_5, t0.telefono_telegram AS telefono_telegram_6, t0.publico AS publico_7, t0.empresa_id AS empresa_id_8 FROM persona_contacto t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->block_content (line 529)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.64 ms
(1.19%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.imagen AS imagen_4 FROM programa_digital 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.descripcion AS descripcion_3,
  t0.imagen AS imagen_4
FROM
  programa_digital t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.imagen AS imagen_4 FROM programa_digital t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\ProgramaDigital::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\ProgramaDigital->__get (line 153)
7	App\Entity\ProgramaDigital->getImagen (line 100)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_18f08c88928027d2dd89752269c55f6b::block_content (line 1156)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.44 ms
(0.81%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.subvencionado AS subvencionado_5, t0.url AS url_6, t0.observaciones AS observaciones_7, t0.colaboracion AS colaboracion_8, t0.fecha_publica AS fecha_publica_9, t0.visible AS visible_10, t0.empresa_id AS empresa_id_11, t0.trl_id AS trl_id_12, t0.convocatoria_id AS convocatoria_id_13 FROM proyecto t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

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.fecha AS fecha_4,
  t0.subvencionado AS subvencionado_5,
  t0.url AS url_6,
  t0.observaciones AS observaciones_7,
  t0.colaboracion AS colaboracion_8,
  t0.fecha_publica AS fecha_publica_9,
  t0.visible AS visible_10,
  t0.empresa_id AS empresa_id_11,
  t0.trl_id AS trl_id_12,
  t0.convocatoria_id AS convocatoria_id_13
FROM
  proyecto t0
WHERE
  t0.empresa_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.fecha AS fecha_4, t0.subvencionado AS subvencionado_5, t0.url AS url_6, t0.observaciones AS observaciones_7, t0.colaboracion AS colaboracion_8, t0.fecha_publica AS fecha_publica_9, t0.visible AS visible_10, t0.empresa_id AS empresa_id_11, t0.trl_id AS trl_id_12, t0.convocatoria_id AS convocatoria_id_13 FROM proyecto t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->block_content (line 939)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.40 ms
(0.74%)

SELECT t0.id AS id_1, t0.empresa_id AS empresa_id_2, t0.certificacion_id AS certificacion_id_3 FROM certificacion_empresa t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.empresa_id AS empresa_id_2,
  t0.certificacion_id AS certificacion_id_3
FROM
  certificacion_empresa t0
WHERE
  t0.empresa_id = ?

SELECT t0.id AS id_1, t0.empresa_id AS empresa_id_2, t0.certificacion_id AS certificacion_id_3 FROM certificacion_empresa t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_18f08c88928027d2dd89752269c55f6b::block_content (line 1049)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

0.35 ms
(0.65%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.url AS url_4, t0.observaciones AS observaciones_5, t0.subvencionado AS subvencionado_6, t0.colaboracion AS colaboracion_7, t0.visible AS visible_8, t0.empresa_id AS empresa_id_9, t0.convocatoria_id AS convocatoria_id_10 FROM producto t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

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.url AS url_4,
  t0.observaciones AS observaciones_5,
  t0.subvencionado AS subvencionado_6,
  t0.colaboracion AS colaboracion_7,
  t0.visible AS visible_8,
  t0.empresa_id AS empresa_id_9,
  t0.convocatoria_id AS convocatoria_id_10
FROM
  producto t0
WHERE
  t0.empresa_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.url AS url_4, t0.observaciones AS observaciones_5, t0.subvencionado AS subvencionado_6, t0.colaboracion AS colaboracion_7, t0.visible AS visible_8, t0.empresa_id AS empresa_id_9, t0.convocatoria_id AS convocatoria_id_10 FROM producto t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->block_content (line 802)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.34 ms
(0.63%)

SELECT t0.id AS id_1, t0.empresa_id AS empresa_id_2, t0.programa_digital_id AS programa_digital_id_3 FROM empresa_proveedor_programa t0 WHERE t0.empresa_id = ?

Parameters:

[
  39
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.empresa_id AS empresa_id_2,
  t0.programa_digital_id AS programa_digital_id_3
FROM
  empresa_proveedor_programa t0
WHERE
  t0.empresa_id = ?

SELECT t0.id AS id_1, t0.empresa_id AS empresa_id_2, t0.programa_digital_id AS programa_digital_id_3 FROM empresa_proveedor_programa t0 WHERE t0.empresa_id = 39;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->testEmpty (line 1417)
9	__TwigTemplate_18f08c88928027d2dd89752269c55f6b::block_content (line 1049)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_cf6503b9808e9ed231d46ebecf4033d1->doDisplay (line 231)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_18f08c88928027d2dd89752269c55f6b->doDisplay (line 64)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
22	App\Controller\CatalogoController->app_catalogo_empresa (line 113)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	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\Empresa	5
App\Entity\Servicio	5
App\Entity\TipoEmpresa	3
App\Entity\CertificacionEmpresa	3
App\Entity\Certificacion	3
App\Entity\EmpresaProveedorPrograma	2
App\Entity\ProgramaDigital	2
App\Entity\Direccion	1
App\Entity\Pais	1
App\Entity\Provincia	1
App\Entity\Municipio	1
App\Entity\Isla	1
App\Entity\ComunidadAutonoma	1
App\Entity\PersonaContacto	1

Entities Mapping

Class	Mapping errors
App\Entity\Empresa	No errors.
App\Entity\TipoEmpresa	No errors.
App\Entity\Direccion	No errors.
App\Entity\EmpresaProveedorPrograma	No errors.
App\Entity\PersonaContacto	No errors.
App\Entity\Servicio	No errors.
App\Entity\Producto	No errors.
App\Entity\Proyecto	No errors.
App\Entity\Imagen	No errors.
App\Entity\ImagenEmpresa	No errors.
App\Entity\Documento	No errors.
App\Entity\DocumentoEmpresa	No errors.
App\Entity\PresenciaEmpresa	No errors.
App\Entity\User	No errors.
App\Entity\CertificacionEmpresa	No errors.
App\Entity\ContactoEmpresa	No errors.
App\Entity\EtiquetaEmpresa	No errors.
App\Entity\CnaeEmpresa	No errors.
App\Entity\Pais	No errors.
App\Entity\ComunidadAutonoma	No errors.
App\Entity\Provincia	No errors.
App\Entity\Municipio	No errors.
App\Entity\Isla	No errors.
App\Entity\PersonaViaComunicacion	No errors.
App\Entity\Convocatoria	No errors.
App\Entity\EntidadPublicaServicio	No errors.
App\Entity\SectorEmpresarialServicio	No errors.
App\Entity\SolucionTecnologicaServicio	No errors.
App\Entity\EntidadServicio	No errors.
App\Entity\DocumentoServicio	No errors.
App\Entity\ImagenServicio	No errors.
App\Entity\EtiquetaServicio	No errors.
App\Entity\Trl	No errors.
App\Entity\Certificacion	No errors.
App\Entity\ProgramaDigital	No errors.

Symfony Profiler

GET https://cluster.pytlab.com/catalogo/empresa/39

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping