Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

6.97 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

6.34 ms

SELECT j0_.id AS id_0, j0_.start_at AS start_at_1, j0_.end_at AS end_at_2, j0_.name AS name_3, j0_.description AS description_4, j0_.job_offer_call_pdf_description AS job_offer_call_pdf_description_5 FROM job_offer_call j0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.start_at AS start_at_1,
  j0_.end_at AS end_at_2,
  j0_.name AS name_3,
  j0_.description AS description_4,
  j0_.job_offer_call_pdf_description AS job_offer_call_pdf_description_5
FROM
  job_offer_call j0_

SELECT j0_.id AS id_0, j0_.start_at AS start_at_1, j0_.end_at AS end_at_2, j0_.name AS name_3, j0_.description AS description_4, j0_.job_offer_call_pdf_description AS job_offer_call_pdf_description_5 FROM job_offer_call j0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 453)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 110)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 81)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 108)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 81)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 896)
19	Symfony\Component\Form\Form->createView (line 899)
20	Symfony\Component\Form\Form->createView (line 136)
21	App\Controller\IndexController->freeJobSubmission (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.63 ms

SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.name AS name_4, t0.description AS description_5, t0.job_offer_call_pdf_description AS job_offer_call_pdf_description_6 FROM job_offer_call t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start_at AS start_at_2,
  t0.end_at AS end_at_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.job_offer_call_pdf_description AS job_offer_call_pdf_description_6
FROM
  job_offer_call t0

SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.name AS name_4, t0.description AS description_5, t0.job_offer_call_pdf_description AS job_offer_call_pdf_description_6 FROM job_offer_call t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 137)
6	App\Controller\IndexController->freeJobSubmission (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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.

Entities Mapping

Class	Mapping errors
App\Entity\FreeJobSubmission	No errors.
App\Entity\JobOfferCallSubmission	No errors.
App\Entity\JobOfferCall	No errors.

Symfony Profiler

GET https://www.ingenierie-architecture.com/offercalls

Configuration Settings

Theme