Symfony Profiler

Query Metrics

42 Database Queries

9 Different statements

25.61 ms Query time

0 Invalid entities

351 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.98 ms
(46.78%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.apellido AS apellido_3, t0.nombre AS nombre_4, t0.genero AS genero_5, t0.f_nac AS f_nac_6, t0.domicilio AS domicilio_7, t0.celular AS celular_8, t0.email AS email_9, t0.agregado AS agregado_10, t0.modificado AS modificado_11, t0.cuit AS cuit_12, t0.tipo AS tipo_13, t0.nacionalidad AS nacionalidad_14, t0.estado_civil AS estado_civil_15, t0.profesion_ocupacion AS profesion_ocupacion_16, t0.titulo AS titulo_17 FROM persona t0 WHERE t0.id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.apellido AS apellido_3,
  t0.nombre AS nombre_4,
  t0.genero AS genero_5,
  t0.f_nac AS f_nac_6,
  t0.domicilio AS domicilio_7,
  t0.celular AS celular_8,
  t0.email AS email_9,
  t0.agregado AS agregado_10,
  t0.modificado AS modificado_11,
  t0.cuit AS cuit_12,
  t0.tipo AS tipo_13,
  t0.nacionalidad AS nacionalidad_14,
  t0.estado_civil AS estado_civil_15,
  t0.profesion_ocupacion AS profesion_ocupacion_16,
  t0.titulo AS titulo_17
FROM
  persona t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.apellido AS apellido_3, t0.nombre AS nombre_4, t0.genero AS genero_5, t0.f_nac AS f_nac_6, t0.domicilio AS domicilio_7, t0.celular AS celular_8, t0.email AS email_9, t0.agregado AS agregado_10, t0.modificado AS modificado_11, t0.cuit AS cuit_12, t0.tipo AS tipo_13, t0.nacionalidad AS nacionalidad_14, t0.estado_civil AS estado_civil_15, t0.profesion_ocupacion AS profesion_ocupacion_16, t0.titulo AS titulo_17 FROM persona t0 WHERE t0.id = 19;

#	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\Persona::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Persona->__get (line 153)
7	App\Entity\Persona->getNombre (line 176)
8	App\Entity\Propietario->__toString (line 122)
9	Symfony\Bridge\Doctrine\Form\Type\DoctrineType->createChoiceLabel (line 54)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceView (line 158)
11	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 233)
12	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::createView (line 123)
13	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
14	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
15	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
16	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
19	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
20	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
21	Symfony\Component\Form\Form->createView (line 892)
22	Symfony\Component\Form\Form->createView (line 895)
23	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 81)
24	XpotronixUtilsBundle\Table\ComponentFactory->mainTable (line 27)
25	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 60)
26	App\Controller\InformeEmbarcacionesController->index (line 34)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

6.72 ms
(26.25%)

SELECT IS_UPDATABLE
            FROM information_schema.views
            WHERE TABLE_NAME = ?

Parameters:

[
  "InformeEmbarcaciones"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  IS_UPDATABLE
FROM
  information_schema.views
WHERE
  TABLE_NAME = ?

SELECT IS_UPDATABLE
            FROM information_schema.views
            WHERE TABLE_NAME = 'InformeEmbarcaciones'
        ;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 300)
2	App\Repository\InformeEmbarcacionesRepository->isUpdatable (line 368)
3	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 73)
4	XpotronixUtilsBundle\Table\ComponentFactory->mainTable (line 27)
5	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 60)
6	App\Controller\InformeEmbarcacionesController->index (line 34)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

1.32 ms
(5.14%)

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.RUT AS RUT_2, c0_.objeto AS objeto_3, c0_.contacto AS contacto_4, c0_.domicilio AS domicilio_5, c0_.localidad AS localidad_6, c0_.provincia AS provincia_7, c0_.sigla AS sigla_8 FROM club c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1,
  c0_.RUT AS RUT_2,
  c0_.objeto AS objeto_3,
  c0_.contacto AS contacto_4,
  c0_.domicilio AS domicilio_5,
  c0_.localidad AS localidad_6,
  c0_.provincia AS provincia_7,
  c0_.sigla AS sigla_8
FROM
  club c0_

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.RUT AS RUT_2, c0_.objeto AS objeto_3, c0_.contacto AS contacto_4, c0_.domicilio AS domicilio_5, c0_.localidad AS localidad_6, c0_.provincia AS provincia_7, c0_.sigla AS sigla_8 FROM club c0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 81)
21	XpotronixUtilsBundle\Table\ComponentFactory->secondaryTable (line 41)
22	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 64)
23	App\Controller\InformeEmbarcacionesController->index (line 34)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

1.12 ms
(4.36%)

SELECT p0_.id AS id_0, p0_.persona_id AS persona_id_1 FROM propietario p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.persona_id AS persona_id_1
FROM
  propietario p0_

SELECT p0_.id AS id_0, p0_.persona_id AS persona_id_1 FROM propietario p0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 81)
21	XpotronixUtilsBundle\Table\ComponentFactory->mainTable (line 27)
22	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 60)
23	App\Controller\InformeEmbarcacionesController->index (line 34)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

1.06 ms
(4.15%)

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1 FROM t_lugar t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1
FROM
  t_lugar t0_

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1 FROM t_lugar t0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 81)
21	XpotronixUtilsBundle\Table\ComponentFactory->secondaryTable (line 41)
22	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 64)
23	App\Controller\InformeEmbarcacionesController->index (line 34)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.89 ms
(3.46%)

SELECT s0_.id AS id_0, s0_.descripcion AS descripcion_1, s0_.periodicidad AS periodicidad_2, s0_.tarifa_base AS tarifa_base_3, s0_.indice AS indice_4, s0_.agregado AS agregado_5, s0_.modificado AS modificado_6 FROM servicio s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.descripcion AS descripcion_1,
  s0_.periodicidad AS periodicidad_2,
  s0_.tarifa_base AS tarifa_base_3,
  s0_.indice AS indice_4,
  s0_.agregado AS agregado_5,
  s0_.modificado AS modificado_6
FROM
  servicio s0_

SELECT s0_.id AS id_0, s0_.descripcion AS descripcion_1, s0_.periodicidad AS periodicidad_2, s0_.tarifa_base AS tarifa_base_3, s0_.indice AS indice_4, s0_.agregado AS agregado_5, s0_.modificado AS modificado_6 FROM servicio s0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 81)
21	XpotronixUtilsBundle\Table\ComponentFactory->secondaryTable (line 41)
22	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 64)
23	App\Controller\InformeEmbarcacionesController->index (line 34)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.88 ms
(3.42%)

SELECT p0_.id AS id_0, p0_.f_caduca AS f_caduca_1, p0_.documento AS documento_2, p0_.monto_poliza AS monto_poliza_3, p0_.compania_seguros_id AS compania_seguros_id_4 FROM poliza p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.f_caduca AS f_caduca_1,
  p0_.documento AS documento_2,
  p0_.monto_poliza AS monto_poliza_3,
  p0_.compania_seguros_id AS compania_seguros_id_4
FROM
  poliza p0_

SELECT p0_.id AS id_0, p0_.f_caduca AS f_caduca_1, p0_.documento AS documento_2, p0_.monto_poliza AS monto_poliza_3, p0_.compania_seguros_id AS compania_seguros_id_4 FROM poliza p0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 81)
21	XpotronixUtilsBundle\Table\ComponentFactory->secondaryTable (line 41)
22	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 64)
23	App\Controller\InformeEmbarcacionesController->index (line 34)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.84 ms
(3.28%)

SELECT l0_.id AS id_0, l0_.nombre AS nombre_1, l0_.t_lugar_id AS t_lugar_id_2, l0_.club_id AS club_id_3, l0_.poliza_id AS poliza_id_4, l0_.servicio_id AS servicio_id_5 FROM lugar l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.nombre AS nombre_1,
  l0_.t_lugar_id AS t_lugar_id_2,
  l0_.club_id AS club_id_3,
  l0_.poliza_id AS poliza_id_4,
  l0_.servicio_id AS servicio_id_5
FROM
  lugar l0_

SELECT l0_.id AS id_0, l0_.nombre AS nombre_1, l0_.t_lugar_id AS t_lugar_id_2, l0_.club_id AS club_id_3, l0_.poliza_id AS poliza_id_4, l0_.servicio_id AS servicio_id_5 FROM lugar l0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 81)
21	XpotronixUtilsBundle\Table\ComponentFactory->mainTable (line 27)
22	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 60)
23	App\Controller\InformeEmbarcacionesController->index (line 34)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.81 ms
(3.15%)

SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.apellido AS apellido_2, p0_.nombre AS nombre_3, p0_.genero AS genero_4, p0_.f_nac AS f_nac_5, p0_.domicilio AS domicilio_6, p0_.celular AS celular_7, p0_.email AS email_8, p0_.agregado AS agregado_9, p0_.modificado AS modificado_10, p0_.cuit AS cuit_11, p0_.tipo AS tipo_12, p0_.nacionalidad AS nacionalidad_13, p0_.estado_civil AS estado_civil_14, p0_.profesion_ocupacion AS profesion_ocupacion_15, p0_.titulo AS titulo_16 FROM persona p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.uuid AS uuid_1,
  p0_.apellido AS apellido_2,
  p0_.nombre AS nombre_3,
  p0_.genero AS genero_4,
  p0_.f_nac AS f_nac_5,
  p0_.domicilio AS domicilio_6,
  p0_.celular AS celular_7,
  p0_.email AS email_8,
  p0_.agregado AS agregado_9,
  p0_.modificado AS modificado_10,
  p0_.cuit AS cuit_11,
  p0_.tipo AS tipo_12,
  p0_.nacionalidad AS nacionalidad_13,
  p0_.estado_civil AS estado_civil_14,
  p0_.profesion_ocupacion AS profesion_ocupacion_15,
  p0_.titulo AS titulo_16
FROM
  persona p0_

SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.apellido AS apellido_2, p0_.nombre AS nombre_3, p0_.genero AS genero_4, p0_.f_nac AS f_nac_5, p0_.domicilio AS domicilio_6, p0_.celular AS celular_7, p0_.email AS email_8, p0_.agregado AS agregado_9, p0_.modificado AS modificado_10, p0_.cuit AS cuit_11, p0_.tipo AS tipo_12, p0_.nacionalidad AS nacionalidad_13, p0_.estado_civil AS estado_civil_14, p0_.profesion_ocupacion AS profesion_ocupacion_15, p0_.titulo AS titulo_16 FROM persona p0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 202)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
20	Symfony\Component\Form\Form->createView (line 892)
21	Symfony\Component\Form\Form->createView (line 895)
22	XpotronixUtilsBundle\Table\TableBuilder->addForms (line 81)
23	XpotronixUtilsBundle\Table\ComponentFactory->secondaryTable (line 41)
24	XpotronixUtilsBundle\Controller\App->renderTablesIndex (line 64)
25	App\Controller\InformeEmbarcacionesController->index (line 34)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	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\Club	198
App\Entity\Persona	91
App\Entity\Propietario	29
App\Entity\Servicio	23
App\Entity\TLugar	6
App\Entity\Lugar	2
App\Entity\Poliza	1
App\Entity\CompaniaSeguros	1

Entities Mapping

Class	Mapping errors
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\InformeEmbarcaciones	No errors.
App\Entity\Propietario	No errors.
App\Entity\Lugar	No errors.
App\Entity\Persona	No errors.
App\Entity\Embarcacion	No errors.
App\Entity\RolPersona	No errors.
App\Entity\Comprobante	No errors.
App\Entity\Institucion	No errors.
App\Entity\EventoRolPersona	No errors.
App\Entity\ServicioPersona	No errors.
App\Entity\Liquidacion	No errors.
App\Entity\Notificacion	No errors.
App\Entity\TLugar	No errors.
App\Entity\Club	No errors.
App\Entity\Poliza	No errors.
App\Entity\Servicio	No errors.
App\Entity\Evento	No errors.
App\Entity\Socio	No errors.
App\Entity\CompaniaSeguros	No errors.

Symfony Profiler

GET https://tsc.justamente.net/informe_embarcaciones/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping