Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

3.44 ms Query time

0 Invalid entities

18 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.36 ms

SELECT t0.id AS id_1, t0.modelo AS modelo_2, t0.area_construida AS area_construida_3, t0.descripcion AS descripcion_4, t0.area_total AS area_total_5, t0.nro_pisos AS nro_pisos_6, t0.nro_dormitorios AS nro_dormitorios_7, t0.nro_banos AS nro_banos_8, t0.nro_terrazas AS nro_terrazas_9, t0.nro_balcones AS nro_balcones_10, t0.titulo AS titulo_11, t0.descripcion_cool AS descripcion_cool_12, t0.codigo_modelo AS codigo_modelo_13, t0.views AS views_14, t0.condominio_principal_id AS condominio_principal_id_15 FROM proyecto_casa_modelo t0 ORDER BY t0.condominio_principal_id ASC, t0.area_total DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.modelo AS modelo_2,
  t0.area_construida AS area_construida_3,
  t0.descripcion AS descripcion_4,
  t0.area_total AS area_total_5,
  t0.nro_pisos AS nro_pisos_6,
  t0.nro_dormitorios AS nro_dormitorios_7,
  t0.nro_banos AS nro_banos_8,
  t0.nro_terrazas AS nro_terrazas_9,
  t0.nro_balcones AS nro_balcones_10,
  t0.titulo AS titulo_11,
  t0.descripcion_cool AS descripcion_cool_12,
  t0.codigo_modelo AS codigo_modelo_13,
  t0.views AS views_14,
  t0.condominio_principal_id AS condominio_principal_id_15
FROM
  proyecto_casa_modelo t0
ORDER BY
  t0.condominio_principal_id ASC,
  t0.area_total DESC

SELECT t0.id AS id_1, t0.modelo AS modelo_2, t0.area_construida AS area_construida_3, t0.descripcion AS descripcion_4, t0.area_total AS area_total_5, t0.nro_pisos AS nro_pisos_6, t0.nro_dormitorios AS nro_dormitorios_7, t0.nro_banos AS nro_banos_8, t0.nro_terrazas AS nro_terrazas_9, t0.nro_balcones AS nro_balcones_10, t0.titulo AS titulo_11, t0.descripcion_cool AS descripcion_cool_12, t0.codigo_modelo AS codigo_modelo_13, t0.views AS views_14, t0.condominio_principal_id AS condominio_principal_id_15 FROM proyecto_casa_modelo t0 ORDER BY t0.condominio_principal_id ASC, t0.area_total DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 39)
5	App\Controller\PublicController->menuCasasModelo (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 103)
13	__TwigTemplate_624557d81065e357beac657d3a463ed4->doDisplay (line 402)
14	Twig\Template->yield (line 358)
15	Twig\Template->display (line 373)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 1520)
18	Twig\Extension\CoreExtension::include (line 124)
19	__TwigTemplate_819c9ee4e62d77406ef24e4373d0df18->doDisplay (line 402)
20	Twig\Template->yield (line 56)
21	__TwigTemplate_a95b794d6c960c61dd3d86b5218c2fd0->doDisplay (line 402)
22	Twig\Template->yield (line 358)
23	Twig\Template->display (line 373)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 333)
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 347)
30	App\Controller\PublicController->about (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.15 ms

SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.condominio AS condominio_2,
  t0.nro_lotes AS nro_lotes_3,
  t0.direccion_google AS direccion_google_4,
  t0.long_lat_google AS long_lat_google_5,
  t0.codigo_condominio AS codigo_condominio_6,
  t0.desarrollador_id AS desarrollador_id_7
FROM
  proyecto_condominio t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\ProyectoCondominio::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ProyectoCondominio->__get (line 159)
8	App\Entity\ProyectoCondominio->__toString (line 58)
9	__TwigTemplate_ef69adeaf71bc7111b3898e87bafeaf2->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 42)
18	App\Controller\PublicController->menuCasasModelo (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 103)
26	__TwigTemplate_624557d81065e357beac657d3a463ed4->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 1520)
31	Twig\Extension\CoreExtension::include (line 124)
32	__TwigTemplate_819c9ee4e62d77406ef24e4373d0df18->doDisplay (line 402)
33	Twig\Template->yield (line 56)
34	__TwigTemplate_a95b794d6c960c61dd3d86b5218c2fd0->doDisplay (line 402)
35	Twig\Template->yield (line 358)
36	Twig\Template->display (line 373)
37	Twig\Template->render (line 51)
38	Twig\TemplateWrapper->render (line 333)
39	Twig\Environment->render (line 448)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 347)
43	App\Controller\PublicController->about (line 181)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
46	Symfony\Component\HttpKernel\Kernel->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 7)

0.40 ms

SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.condominio AS condominio_2,
  t0.nro_lotes AS nro_lotes_3,
  t0.direccion_google AS direccion_google_4,
  t0.long_lat_google AS long_lat_google_5,
  t0.codigo_condominio AS codigo_condominio_6,
  t0.desarrollador_id AS desarrollador_id_7
FROM
  proyecto_condominio t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\ProyectoCondominio::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ProyectoCondominio->__get (line 159)
8	App\Entity\ProyectoCondominio->__toString (line 58)
9	__TwigTemplate_ef69adeaf71bc7111b3898e87bafeaf2->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 42)
18	App\Controller\PublicController->menuCasasModelo (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 103)
26	__TwigTemplate_624557d81065e357beac657d3a463ed4->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 1520)
31	Twig\Extension\CoreExtension::include (line 124)
32	__TwigTemplate_819c9ee4e62d77406ef24e4373d0df18->doDisplay (line 402)
33	Twig\Template->yield (line 56)
34	__TwigTemplate_a95b794d6c960c61dd3d86b5218c2fd0->doDisplay (line 402)
35	Twig\Template->yield (line 358)
36	Twig\Template->display (line 373)
37	Twig\Template->render (line 51)
38	Twig\TemplateWrapper->render (line 333)
39	Twig\Environment->render (line 448)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 347)
43	App\Controller\PublicController->about (line 181)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
46	Symfony\Component\HttpKernel\Kernel->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 7)

0.54 ms

SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.condominio AS condominio_2,
  t0.nro_lotes AS nro_lotes_3,
  t0.direccion_google AS direccion_google_4,
  t0.long_lat_google AS long_lat_google_5,
  t0.codigo_condominio AS codigo_condominio_6,
  t0.desarrollador_id AS desarrollador_id_7
FROM
  proyecto_condominio t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.condominio AS condominio_2, t0.nro_lotes AS nro_lotes_3, t0.direccion_google AS direccion_google_4, t0.long_lat_google AS long_lat_google_5, t0.codigo_condominio AS codigo_condominio_6, t0.desarrollador_id AS desarrollador_id_7 FROM proyecto_condominio t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\ProyectoCondominio::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\ProyectoCondominio->__get (line 159)
8	App\Entity\ProyectoCondominio->__toString (line 58)
9	__TwigTemplate_ef69adeaf71bc7111b3898e87bafeaf2->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 42)
18	App\Controller\PublicController->menuCasasModelo (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
22	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
23	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
24	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
25	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 103)
26	__TwigTemplate_624557d81065e357beac657d3a463ed4->doDisplay (line 402)
27	Twig\Template->yield (line 358)
28	Twig\Template->display (line 373)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 1520)
31	Twig\Extension\CoreExtension::include (line 124)
32	__TwigTemplate_819c9ee4e62d77406ef24e4373d0df18->doDisplay (line 402)
33	Twig\Template->yield (line 56)
34	__TwigTemplate_a95b794d6c960c61dd3d86b5218c2fd0->doDisplay (line 402)
35	Twig\Template->yield (line 358)
36	Twig\Template->display (line 373)
37	Twig\Template->render (line 51)
38	Twig\TemplateWrapper->render (line 333)
39	Twig\Environment->render (line 448)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 347)
43	App\Controller\PublicController->about (line 181)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
46	Symfony\Component\HttpKernel\Kernel->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\ProyectoCasaModelo	14
App\Entity\ProyectoCondominio	3
App\Entity\ProyectoCondominioDesarrollador	1

Entities Mapping

Class	Mapping errors
App\Entity\ProyectoCasaModelo	No errors.
App\Entity\ProyectoCondominio	No errors.
App\Entity\Proyecto	No errors.
App\Entity\ProyectoCasaModeloPiso	No errors.
App\Entity\ProyectoCasaModeloArchivo	No errors.
App\Entity\ProyectoCondominioDesarrollador	No errors.

Symfony Profiler

GET http://dev.novaespacio.com/menuCasasModelo

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping