Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.70 ms Query time

0 Invalid entities

49 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.70 ms

SELECT p0_.id AS id_0, p0_.profesion AS profesion_1, p0_.siglas AS siglas_2, p0_.codigo_profesion AS codigo_profesion_3, p0_.horas_requeridas_total AS horas_requeridas_total_4, p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5, p0_.is_default AS is_default_6, p0_.is_featured AS is_featured_7, p0_.slug AS slug_8, p0_.is_public AS is_public_9, p0_.icon AS icon_10 FROM profesion p0_ WHERE p0_.id NOT IN (?, ?) ORDER BY p0_.profesion ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.profesion AS profesion_1,
  p0_.siglas AS siglas_2,
  p0_.codigo_profesion AS codigo_profesion_3,
  p0_.horas_requeridas_total AS horas_requeridas_total_4,
  p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5,
  p0_.is_default AS is_default_6,
  p0_.is_featured AS is_featured_7,
  p0_.slug AS slug_8,
  p0_.is_public AS is_public_9,
  p0_.icon AS icon_10
FROM
  profesion p0_
WHERE
  p0_.id NOT IN (?, ?)
ORDER BY
  p0_.profesion ASC

SELECT p0_.id AS id_0, p0_.profesion AS profesion_1, p0_.siglas AS siglas_2, p0_.codigo_profesion AS codigo_profesion_3, p0_.horas_requeridas_total AS horas_requeridas_total_4, p0_.horas_requeridas_presencial AS horas_requeridas_presencial_5, p0_.is_default AS is_default_6, p0_.is_featured AS is_featured_7, p0_.slug AS slug_8, p0_.is_public AS is_public_9, p0_.icon AS icon_10 FROM profesion p0_ WHERE p0_.id NOT IN (1, 55) ORDER BY p0_.profesion ASC;

#	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 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 455)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
23	App\Controller\front\HomeController->signup (line 166)
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 29)
29	require_once (line 15)

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\Profesion	49

Entities Mapping

Class	Mapping errors
App\Entity\Profesion	No errors.
App\Entity\UserProfesion	No errors.
App\Entity\Junta	No errors.

Symfony Profiler

GET https://previadmin.computechapps.com/signup

Configuration Settings

Theme

Page Width