Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.19 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.91 ms
(28.52%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM announce a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  announce a0_

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM announce a0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerJj8x3d1\PaginatorProxyBa079e5->paginate (line 37)
16	App\Controller\Front\AnnounceController->announces (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.88 ms
(27.52%)

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.title AS title_2, a0_.description AS description_3, a0_.remarks AS remarks_4, a0_.country AS country_5, a0_.status AS status_6, a0_.head_hunter_status AS head_hunter_status_7, a0_.hh_status AS hh_status_8, a0_.head_hunter AS head_hunter_9, a0_.anonymous AS anonymous_10, a0_.published_by_admin AS published_by_admin_11, a0_.published_by_client AS published_by_client_12, a0_.contract_type AS contract_type_13, a0_.work_time AS work_time_14, a0_.applicant_experience AS applicant_experience_15, a0_.applicant_studies AS applicant_studies_16, a0_.remote AS remote_17, a0_.salary AS salary_18, a0_.start_publication AS start_publication_19, a0_.end_publication AS end_publication_20, a0_.photo AS photo_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.applicant_language AS applicant_language_24, a0_.slug AS slug_25, a0_.tier_id AS tier_id_26, a0_.category_id AS category_id_27, a0_.town_id AS town_id_28 FROM announce a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.code AS code_1,
  a0_.title AS title_2,
  a0_.description AS description_3,
  a0_.remarks AS remarks_4,
  a0_.country AS country_5,
  a0_.status AS status_6,
  a0_.head_hunter_status AS head_hunter_status_7,
  a0_.hh_status AS hh_status_8,
  a0_.head_hunter AS head_hunter_9,
  a0_.anonymous AS anonymous_10,
  a0_.published_by_admin AS published_by_admin_11,
  a0_.published_by_client AS published_by_client_12,
  a0_.contract_type AS contract_type_13,
  a0_.work_time AS work_time_14,
  a0_.applicant_experience AS applicant_experience_15,
  a0_.applicant_studies AS applicant_studies_16,
  a0_.remote AS remote_17,
  a0_.salary AS salary_18,
  a0_.start_publication AS start_publication_19,
  a0_.end_publication AS end_publication_20,
  a0_.photo AS photo_21,
  a0_.created_at AS created_at_22,
  a0_.updated_at AS updated_at_23,
  a0_.applicant_language AS applicant_language_24,
  a0_.slug AS slug_25,
  a0_.tier_id AS tier_id_26,
  a0_.category_id AS category_id_27,
  a0_.town_id AS town_id_28
FROM
  announce a0_
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.title AS title_2, a0_.description AS description_3, a0_.remarks AS remarks_4, a0_.country AS country_5, a0_.status AS status_6, a0_.head_hunter_status AS head_hunter_status_7, a0_.hh_status AS hh_status_8, a0_.head_hunter AS head_hunter_9, a0_.anonymous AS anonymous_10, a0_.published_by_admin AS published_by_admin_11, a0_.published_by_client AS published_by_client_12, a0_.contract_type AS contract_type_13, a0_.work_time AS work_time_14, a0_.applicant_experience AS applicant_experience_15, a0_.applicant_studies AS applicant_studies_16, a0_.remote AS remote_17, a0_.salary AS salary_18, a0_.start_publication AS start_publication_19, a0_.end_publication AS end_publication_20, a0_.photo AS photo_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.applicant_language AS applicant_language_24, a0_.slug AS slug_25, a0_.tier_id AS tier_id_26, a0_.category_id AS category_id_27, a0_.town_id AS town_id_28 FROM announce a0_ WHERE a0_.id IN (4, 18, 20, 22, 26, 27, 28, 29, 51, 52);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerJj8x3d1\PaginatorProxyBa079e5->paginate (line 37)
16	App\Controller\Front\AnnounceController->announces (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.55 ms
(17.26%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.langue_id AS langue_id_5 FROM category t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.langue_id AS langue_id_5
FROM
  category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.langue_id AS langue_id_5 FROM category t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 48)
6	App\Controller\Front\AnnounceController->announces (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.52 ms
(16.29%)

SELECT DISTINCT a0_.id AS id_0 FROM announce a0_ LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0
FROM
  announce a0_
LIMIT
  10

SELECT DISTINCT a0_.id AS id_0 FROM announce a0_ LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerJj8x3d1\PaginatorProxyBa079e5->paginate (line 37)
16	App\Controller\Front\AnnounceController->announces (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.33 ms
(10.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM town t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4
FROM
  town t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM town t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 49)
6	App\Controller\Front\AnnounceController->announces (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\Announce	No errors.
App\Entity\Tier	No errors.
App\Entity\Category	The association App\Entity\Category#langue refers to the inverse side field App\Entity\Langue#categories which does not exist.
App\Entity\Town	The mappings App\Entity\Town#tiers and App\Entity\Tier#town are inconsistent with each other.
App\Entity\Candidate	No errors.
App\Entity\Phase	No errors.
App\Entity\Criteria	No errors.
App\Entity\AnnounceAccess	No errors.
App\Entity\Skill	No errors.
App\Entity\Langue	The mappings App\Entity\Langue#categoies and App\Entity\Category#langue are inconsistent with each other.

Symfony Profiler

GET https://taycir.jobs/offres-emploi

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping