Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.06 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.06 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.description AS description_4, t0.remarks AS remarks_5, t0.country AS country_6, t0.status AS status_7, t0.head_hunter_status AS head_hunter_status_8, t0.hh_status AS hh_status_9, t0.head_hunter AS head_hunter_10, t0.anonymous AS anonymous_11, t0.published_by_admin AS published_by_admin_12, t0.published_by_client AS published_by_client_13, t0.contract_type AS contract_type_14, t0.work_time AS work_time_15, t0.applicant_experience AS applicant_experience_16, t0.applicant_studies AS applicant_studies_17, t0.remote AS remote_18, t0.salary AS salary_19, t0.start_publication AS start_publication_20, t0.end_publication AS end_publication_21, t0.photo AS photo_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.applicant_language AS applicant_language_25, t0.slug AS slug_26, t0.tier_id AS tier_id_27, t0.category_id AS category_id_28, t0.town_id AS town_id_29 FROM announce t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "robots.txt"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.remarks AS remarks_5,
  t0.country AS country_6,
  t0.status AS status_7,
  t0.head_hunter_status AS head_hunter_status_8,
  t0.hh_status AS hh_status_9,
  t0.head_hunter AS head_hunter_10,
  t0.anonymous AS anonymous_11,
  t0.published_by_admin AS published_by_admin_12,
  t0.published_by_client AS published_by_client_13,
  t0.contract_type AS contract_type_14,
  t0.work_time AS work_time_15,
  t0.applicant_experience AS applicant_experience_16,
  t0.applicant_studies AS applicant_studies_17,
  t0.remote AS remote_18,
  t0.salary AS salary_19,
  t0.start_publication AS start_publication_20,
  t0.end_publication AS end_publication_21,
  t0.photo AS photo_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.applicant_language AS applicant_language_25,
  t0.slug AS slug_26,
  t0.tier_id AS tier_id_27,
  t0.category_id AS category_id_28,
  t0.town_id AS town_id_29
FROM
  announce t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.description AS description_4, t0.remarks AS remarks_5, t0.country AS country_6, t0.status AS status_7, t0.head_hunter_status AS head_hunter_status_8, t0.hh_status AS hh_status_9, t0.head_hunter AS head_hunter_10, t0.anonymous AS anonymous_11, t0.published_by_admin AS published_by_admin_12, t0.published_by_client AS published_by_client_13, t0.contract_type AS contract_type_14, t0.work_time AS work_time_15, t0.applicant_experience AS applicant_experience_16, t0.applicant_studies AS applicant_studies_17, t0.remote AS remote_18, t0.salary AS salary_19, t0.start_publication AS start_publication_20, t0.end_publication AS end_publication_21, t0.photo AS photo_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.applicant_language AS applicant_language_25, t0.slug AS slug_26, t0.tier_id AS tier_id_27, t0.category_id AS category_id_28, t0.town_id AS town_id_29 FROM announce t0 WHERE t0.slug = 'robots.txt' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\TierAccess	No errors.
App\Entity\Langue	The mappings App\Entity\Langue#categoies and App\Entity\Category#langue are inconsistent with each other.
App\Entity\Tag	No errors.
App\Entity\Comment	No errors.
App\Entity\User	No errors.
App\Entity\Traduction	No errors.
App\Entity\WflowPhase	The association App\Entity\WflowPhase#phase refers to the inverse side field App\Entity\Phase#wflowPhases which does not exist. The association App\Entity\WflowPhase#candidate refers to the inverse side field App\Entity\Candidate#wflowPhases which does not exist.
App\Entity\MailModel	No errors.
App\Entity\TraductionContenu	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://taycir.jobs/robots.txt

Configuration Settings

Theme