Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

11.37 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

6.35 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.titulo AS titulo_1, o0_.descripcion AS descripcion_2, o0_.estado AS estado_3, o0_.fecha_creacion AS fecha_creacion_4, o0_.fecha_publicacion AS fecha_publicacion_5 FROM oferta_socio o0_ WHERE o0_.estado = ? ORDER BY o0_.id DESC) dctrn_result) dctrn_table

Parameters:

[
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          o0_.id AS id_0,
          o0_.titulo AS titulo_1,
          o0_.descripcion AS descripcion_2,
          o0_.estado AS estado_3,
          o0_.fecha_creacion AS fecha_creacion_4,
          o0_.fecha_publicacion AS fecha_publicacion_5
        FROM
          oferta_socio o0_
        WHERE
          o0_.estado = ?
        ORDER BY
          o0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.titulo AS titulo_1, o0_.descripcion AS descripcion_2, o0_.estado AS estado_3, o0_.fecha_creacion AS fecha_creacion_4, o0_.fecha_publicacion AS fecha_publicacion_5 FROM oferta_socio o0_ WHERE o0_.estado = 'published' ORDER BY o0_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 42)
8	Pagerfanta\Pagerfanta->getNbResults (line 292)
9	Pagerfanta\Pagerfanta->calculateNbPages (line 318)
10	Pagerfanta\Pagerfanta->getNbPages (line 300)
11	App\Repository\OfertaSocioRepository->search (line 82)
12	App\Service\OfertaSocioService->searchPublic (line 27)
13	App\Controller\Public\OfertaController->app_ofertas (line 27)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 193)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

1.52 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.titulo AS titulo_1, o0_.descripcion AS descripcion_2, o0_.estado AS estado_3, o0_.fecha_creacion AS fecha_creacion_4, o0_.fecha_publicacion AS fecha_publicacion_5 FROM oferta_socio o0_ WHERE o0_.estado = ?) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 10

Parameters:

[
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          o0_.id AS id_0,
          o0_.titulo AS titulo_1,
          o0_.descripcion AS descripcion_2,
          o0_.estado AS estado_3,
          o0_.fecha_creacion AS fecha_creacion_4,
          o0_.fecha_publicacion AS fecha_publicacion_5
        FROM
          oferta_socio o0_
        WHERE
          o0_.estado = ?
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.titulo AS titulo_1, o0_.descripcion AS descripcion_2, o0_.estado AS estado_3, o0_.fecha_creacion AS fecha_creacion_4, o0_.fecha_publicacion AS fecha_publicacion_5 FROM oferta_socio o0_ WHERE o0_.estado = 'published') dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	Pagerfanta\Pagerfanta->getIterator (line 415)
11	__TwigTemplate_61e7ea0b59201e29ad35f6704f9deffa->block_content (line 90)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_930cb1ead9b9f16e7090a8ef5d4f2a27->doDisplay (line 136)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_61e7ea0b59201e29ad35f6704f9deffa->doDisplay (line 52)
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 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Public\OfertaController->app_ofertas (line 29)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

1.89 ms

SELECT o0_.id AS id_0, o0_.titulo AS titulo_1, o0_.descripcion AS descripcion_2, o0_.estado AS estado_3, o0_.fecha_creacion AS fecha_creacion_4, o0_.fecha_publicacion AS fecha_publicacion_5, o0_.autor_id AS autor_id_6, o0_.empresa_id AS empresa_id_7 FROM oferta_socio o0_ WHERE o0_.estado = ? AND o0_.id IN (?, ?) ORDER BY o0_.id DESC

Parameters:

[
  "published"
  3
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.titulo AS titulo_1,
  o0_.descripcion AS descripcion_2,
  o0_.estado AS estado_3,
  o0_.fecha_creacion AS fecha_creacion_4,
  o0_.fecha_publicacion AS fecha_publicacion_5,
  o0_.autor_id AS autor_id_6,
  o0_.empresa_id AS empresa_id_7
FROM
  oferta_socio o0_
WHERE
  o0_.estado = ?
  AND o0_.id IN (?, ?)
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.titulo AS titulo_1, o0_.descripcion AS descripcion_2, o0_.estado AS estado_3, o0_.fecha_creacion AS fecha_creacion_4, o0_.fecha_publicacion AS fecha_publicacion_5, o0_.autor_id AS autor_id_6, o0_.empresa_id AS empresa_id_7 FROM oferta_socio o0_ WHERE o0_.estado = 'published' AND o0_.id IN (3, 1) ORDER BY o0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	Pagerfanta\Pagerfanta->getIterator (line 415)
11	__TwigTemplate_61e7ea0b59201e29ad35f6704f9deffa->block_content (line 90)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_930cb1ead9b9f16e7090a8ef5d4f2a27->doDisplay (line 136)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_61e7ea0b59201e29ad35f6704f9deffa->doDisplay (line 52)
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 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\Public\OfertaController->app_ofertas (line 29)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

1.61 ms

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.archivada AS archivada_31, t0.archivada_at AS archivada_at_32, t0.tipo_empresa_id AS tipo_empresa_id_33, t0.archivada_por_id AS archivada_por_id_34 FROM empresa t0 WHERE t0.id = ?

Parameters:

[
  47
]

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.archivada AS archivada_31,
  t0.archivada_at AS archivada_at_32,
  t0.tipo_empresa_id AS tipo_empresa_id_33,
  t0.archivada_por_id AS archivada_por_id_34
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.archivada AS archivada_31, t0.archivada_at AS archivada_at_32, t0.tipo_empresa_id AS tipo_empresa_id_33, t0.archivada_por_id AS archivada_por_id_34 FROM empresa t0 WHERE t0.id = 47;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Empresa::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Empresa->__isset (line 258)
7	App\Entity\Empresa->getName (line 1069)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_61e7ea0b59201e29ad35f6704f9deffa::block_content (line 123)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_930cb1ead9b9f16e7090a8ef5d4f2a27->doDisplay (line 136)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_61e7ea0b59201e29ad35f6704f9deffa->doDisplay (line 52)
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 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\Public\OfertaController->app_ofertas (line 29)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
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\OfertaSocio	2
App\Entity\User	1
App\Entity\Empresa	1
App\Entity\TipoEmpresa	1

Entities Mapping

Class	Mapping errors
App\Entity\OfertaSocio	No errors.
App\Entity\User	No 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\CertificacionEmpresa	No errors.
App\Entity\ContactoEmpresa	No errors.
App\Entity\EtiquetaEmpresa	No errors.
App\Entity\CnaeEmpresa	No errors.
App\Entity\DocumentoInterno	No errors.

Symfony Profiler

GET https://cluster.pytlab.com/ofertas

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping