Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

3.18 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.86 ms
(27.03%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.telephone AS telephone_8, t0.organisation AS organisation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.description AS description_12, t0.avatar AS avatar_13, t0.logo AS logo_14, t0.age AS age_15, t0.date_naissance AS date_naissance_16, t0.is_approuved AS is_approuved_17, t0.titre_emploie AS titre_emploie_18, t0.other_metier AS other_metier_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.linkedin AS linkedin_22, t0.etat AS etat_23, t0.code_postal AS code_postal_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.zoom AS zoom_27, t0.image_couverture AS image_couverture_28, t0.slug AS slug_29, t0.website AS website_30, t0.date_creation AS date_creation_31, t0.adresse AS adresse_32, t0.tags AS tags_33, t0.is_valid AS is_valid_34, t0.is_urgent AS is_urgent_35, t0.google_id AS google_id_36, t0.is_notification AS is_notification_37, t0.is_hidden_email AS is_hidden_email_38, t0.metier_id AS metier_id_39, t0.expertise_id AS expertise_id_40, t0.niveau_id AS niveau_id_41, t0.secteur_id AS secteur_id_42, t0.genre_id AS genre_id_43 FROM user t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "rikolto"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.username AS username_7,
  t0.telephone AS telephone_8,
  t0.organisation AS organisation_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.description AS description_12,
  t0.avatar AS avatar_13,
  t0.logo AS logo_14,
  t0.age AS age_15,
  t0.date_naissance AS date_naissance_16,
  t0.is_approuved AS is_approuved_17,
  t0.titre_emploie AS titre_emploie_18,
  t0.other_metier AS other_metier_19,
  t0.facebook AS facebook_20,
  t0.twitter AS twitter_21,
  t0.linkedin AS linkedin_22,
  t0.etat AS etat_23,
  t0.code_postal AS code_postal_24,
  t0.latitude AS latitude_25,
  t0.longitude AS longitude_26,
  t0.zoom AS zoom_27,
  t0.image_couverture AS image_couverture_28,
  t0.slug AS slug_29,
  t0.website AS website_30,
  t0.date_creation AS date_creation_31,
  t0.adresse AS adresse_32,
  t0.tags AS tags_33,
  t0.is_valid AS is_valid_34,
  t0.is_urgent AS is_urgent_35,
  t0.google_id AS google_id_36,
  t0.is_notification AS is_notification_37,
  t0.is_hidden_email AS is_hidden_email_38,
  t0.metier_id AS metier_id_39,
  t0.expertise_id AS expertise_id_40,
  t0.niveau_id AS niveau_id_41,
  t0.secteur_id AS secteur_id_42,
  t0.genre_id AS genre_id_43
FROM
  user t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.telephone AS telephone_8, t0.organisation AS organisation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.description AS description_12, t0.avatar AS avatar_13, t0.logo AS logo_14, t0.age AS age_15, t0.date_naissance AS date_naissance_16, t0.is_approuved AS is_approuved_17, t0.titre_emploie AS titre_emploie_18, t0.other_metier AS other_metier_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.linkedin AS linkedin_22, t0.etat AS etat_23, t0.code_postal AS code_postal_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.zoom AS zoom_27, t0.image_couverture AS image_couverture_28, t0.slug AS slug_29, t0.website AS website_30, t0.date_creation AS date_creation_31, t0.adresse AS adresse_32, t0.tags AS tags_33, t0.is_valid AS is_valid_34, t0.is_urgent AS is_urgent_35, t0.google_id AS google_id_36, t0.is_notification AS is_notification_37, t0.is_hidden_email AS is_hidden_email_38, t0.metier_id AS metier_id_39, t0.expertise_id AS expertise_id_40, t0.niveau_id AS niveau_id_41, t0.secteur_id AS secteur_id_42, t0.genre_id AS genre_id_43 FROM user t0 WHERE t0.slug = 'rikolto' 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 319)
5	App\Controller\HomeController->detail_recruteur (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.48 ms
(15.19%)

SELECT r0_.id AS id_0, r0_.commentaire AS commentaire_1, r0_.rate AS rate_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, u1_.id AS id_5, u1_.email AS email_6, u1_.roles AS roles_7, u1_.password AS password_8, u1_.nom AS nom_9, u1_.prenom AS prenom_10, u1_.username AS username_11, u1_.telephone AS telephone_12, u1_.organisation AS organisation_13, u1_.created_at AS created_at_14, u1_.updated_at AS updated_at_15, u1_.description AS description_16, u1_.avatar AS avatar_17, u1_.logo AS logo_18, u1_.age AS age_19, u1_.date_naissance AS date_naissance_20, u1_.is_approuved AS is_approuved_21, u1_.titre_emploie AS titre_emploie_22, u1_.other_metier AS other_metier_23, u1_.facebook AS facebook_24, u1_.twitter AS twitter_25, u1_.linkedin AS linkedin_26, u1_.etat AS etat_27, u1_.code_postal AS code_postal_28, u1_.latitude AS latitude_29, u1_.longitude AS longitude_30, u1_.zoom AS zoom_31, u1_.image_couverture AS image_couverture_32, u1_.slug AS slug_33, u1_.website AS website_34, u1_.date_creation AS date_creation_35, u1_.adresse AS adresse_36, u1_.tags AS tags_37, u1_.is_valid AS is_valid_38, u1_.is_urgent AS is_urgent_39, u1_.google_id AS google_id_40, u1_.is_notification AS is_notification_41, u1_.is_hidden_email AS is_hidden_email_42, r0_.candidat_id AS candidat_id_43, r0_.employeur_id AS employeur_id_44, u1_.metier_id AS metier_id_45, u1_.expertise_id AS expertise_id_46, u1_.niveau_id AS niveau_id_47, u1_.secteur_id AS secteur_id_48, u1_.genre_id AS genre_id_49 FROM reviews r0_ INNER JOIN user u1_ ON r0_.candidat_id = u1_.id WHERE r0_.employeur_id = ?

Parameters:

[
  184
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.commentaire AS commentaire_1,
  r0_.rate AS rate_2,
  r0_.created_at AS created_at_3,
  r0_.updated_at AS updated_at_4,
  u1_.id AS id_5,
  u1_.email AS email_6,
  u1_.roles AS roles_7,
  u1_.password AS password_8,
  u1_.nom AS nom_9,
  u1_.prenom AS prenom_10,
  u1_.username AS username_11,
  u1_.telephone AS telephone_12,
  u1_.organisation AS organisation_13,
  u1_.created_at AS created_at_14,
  u1_.updated_at AS updated_at_15,
  u1_.description AS description_16,
  u1_.avatar AS avatar_17,
  u1_.logo AS logo_18,
  u1_.age AS age_19,
  u1_.date_naissance AS date_naissance_20,
  u1_.is_approuved AS is_approuved_21,
  u1_.titre_emploie AS titre_emploie_22,
  u1_.other_metier AS other_metier_23,
  u1_.facebook AS facebook_24,
  u1_.twitter AS twitter_25,
  u1_.linkedin AS linkedin_26,
  u1_.etat AS etat_27,
  u1_.code_postal AS code_postal_28,
  u1_.latitude AS latitude_29,
  u1_.longitude AS longitude_30,
  u1_.zoom AS zoom_31,
  u1_.image_couverture AS image_couverture_32,
  u1_.slug AS slug_33,
  u1_.website AS website_34,
  u1_.date_creation AS date_creation_35,
  u1_.adresse AS adresse_36,
  u1_.tags AS tags_37,
  u1_.is_valid AS is_valid_38,
  u1_.is_urgent AS is_urgent_39,
  u1_.google_id AS google_id_40,
  u1_.is_notification AS is_notification_41,
  u1_.is_hidden_email AS is_hidden_email_42,
  r0_.candidat_id AS candidat_id_43,
  r0_.employeur_id AS employeur_id_44,
  u1_.metier_id AS metier_id_45,
  u1_.expertise_id AS expertise_id_46,
  u1_.niveau_id AS niveau_id_47,
  u1_.secteur_id AS secteur_id_48,
  u1_.genre_id AS genre_id_49
FROM
  reviews r0_
  INNER JOIN user u1_ ON r0_.candidat_id = u1_.id
WHERE
  r0_.employeur_id = ?

SELECT r0_.id AS id_0, r0_.commentaire AS commentaire_1, r0_.rate AS rate_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, u1_.id AS id_5, u1_.email AS email_6, u1_.roles AS roles_7, u1_.password AS password_8, u1_.nom AS nom_9, u1_.prenom AS prenom_10, u1_.username AS username_11, u1_.telephone AS telephone_12, u1_.organisation AS organisation_13, u1_.created_at AS created_at_14, u1_.updated_at AS updated_at_15, u1_.description AS description_16, u1_.avatar AS avatar_17, u1_.logo AS logo_18, u1_.age AS age_19, u1_.date_naissance AS date_naissance_20, u1_.is_approuved AS is_approuved_21, u1_.titre_emploie AS titre_emploie_22, u1_.other_metier AS other_metier_23, u1_.facebook AS facebook_24, u1_.twitter AS twitter_25, u1_.linkedin AS linkedin_26, u1_.etat AS etat_27, u1_.code_postal AS code_postal_28, u1_.latitude AS latitude_29, u1_.longitude AS longitude_30, u1_.zoom AS zoom_31, u1_.image_couverture AS image_couverture_32, u1_.slug AS slug_33, u1_.website AS website_34, u1_.date_creation AS date_creation_35, u1_.adresse AS adresse_36, u1_.tags AS tags_37, u1_.is_valid AS is_valid_38, u1_.is_urgent AS is_urgent_39, u1_.google_id AS google_id_40, u1_.is_notification AS is_notification_41, u1_.is_hidden_email AS is_hidden_email_42, r0_.candidat_id AS candidat_id_43, r0_.employeur_id AS employeur_id_44, u1_.metier_id AS metier_id_45, u1_.expertise_id AS expertise_id_46, u1_.niveau_id AS niveau_id_47, u1_.secteur_id AS secteur_id_48, u1_.genre_id AS genre_id_49 FROM reviews r0_ INNER JOIN user u1_ ON r0_.candidat_id = u1_.id WHERE r0_.employeur_id = 184;

#	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 27)
7	App\Repository\ReviewsRepository->findReviewsForEmployeur (line 321)
8	App\Controller\HomeController->detail_recruteur (line 183)
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)

0.45 ms
(14.11%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date_limite_candidature AS date_limite_candidature_4, t0.voie_application AS voie_application_5, t0.type_voie_application AS type_voie_application_6, t0.genre AS genre_7, t0.fichier AS fichier_8, t0.etat AS etat_9, t0.code_postal AS code_postal_10, t0.adresse AS adresse_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.zoom AS zoom_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.reference AS reference_18, t0.competence AS competence_19, t0.is_valid AS is_valid_20, t0.is_urgent AS is_urgent_21, t0.is_vedette AS is_vedette_22, t0.type_emploie_id AS type_emploie_id_23, t0.experience_id AS experience_id_24, t0.metier_id AS metier_id_25, t0.niveau_id AS niveau_id_26, t0.secteur_id AS secteur_id_27, t0.expertise_id AS expertise_id_28, t0.user_id AS user_id_29 FROM emploie t0 WHERE t0.user_id = ?

Parameters:

[
  184
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.date_limite_candidature AS date_limite_candidature_4,
  t0.voie_application AS voie_application_5,
  t0.type_voie_application AS type_voie_application_6,
  t0.genre AS genre_7,
  t0.fichier AS fichier_8,
  t0.etat AS etat_9,
  t0.code_postal AS code_postal_10,
  t0.adresse AS adresse_11,
  t0.latitude AS latitude_12,
  t0.longitude AS longitude_13,
  t0.zoom AS zoom_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.slug AS slug_17,
  t0.reference AS reference_18,
  t0.competence AS competence_19,
  t0.is_valid AS is_valid_20,
  t0.is_urgent AS is_urgent_21,
  t0.is_vedette AS is_vedette_22,
  t0.type_emploie_id AS type_emploie_id_23,
  t0.experience_id AS experience_id_24,
  t0.metier_id AS metier_id_25,
  t0.niveau_id AS niveau_id_26,
  t0.secteur_id AS secteur_id_27,
  t0.expertise_id AS expertise_id_28,
  t0.user_id AS user_id_29
FROM
  emploie t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date_limite_candidature AS date_limite_candidature_4, t0.voie_application AS voie_application_5, t0.type_voie_application AS type_voie_application_6, t0.genre AS genre_7, t0.fichier AS fichier_8, t0.etat AS etat_9, t0.code_postal AS code_postal_10, t0.adresse AS adresse_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.zoom AS zoom_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.reference AS reference_18, t0.competence AS competence_19, t0.is_valid AS is_valid_20, t0.is_urgent AS is_urgent_21, t0.is_vedette AS is_vedette_22, t0.type_emploie_id AS type_emploie_id_23, t0.experience_id AS experience_id_24, t0.metier_id AS metier_id_25, t0.niveau_id AS niveau_id_26, t0.secteur_id AS secteur_id_27, t0.expertise_id AS expertise_id_28, t0.user_id AS user_id_29 FROM emploie t0 WHERE t0.user_id = 184;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1834)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1779)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1230)
9	Twig\Extension\CoreExtension::length (line 6494)
10	__TwigTemplate_25c40fab29bd2d7d2c6cdfa06c41a804->block_body (line 431)
11	Twig\Template->yieldBlock (line 653)
12	__TwigTemplate_e3250f31f3c24d7b18a6c2b55a127dd5->doDisplay (line 387)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_25c40fab29bd2d7d2c6cdfa06c41a804->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
23	App\Controller\HomeController->detail_recruteur (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.39 ms
(12.36%)

SELECT m0_.id AS id_0, m0_.description AS description_1 FROM metier m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.description AS description_1
FROM
  metier m0_

SELECT m0_.id AS id_0, m0_.description AS description_1 FROM metier m0_;

#	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 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 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
24	App\Controller\HomeController->detail_recruteur (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.37 ms
(11.48%)

SELECT s0_.id AS id_0, s0_.descripption AS descripption_1 FROM secteur_entreprise s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.descripption AS descripption_1
FROM
  secteur_entreprise s0_

SELECT s0_.id AS id_0, s0_.descripption AS descripption_1 FROM secteur_entreprise s0_;

#	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 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 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 477)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
24	App\Controller\HomeController->detail_recruteur (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.33 ms
(10.53%)

SELECT t0.id AS id_1, t0.descripption AS descripption_2 FROM secteur_entreprise t0 INNER JOIN secteur_entreprise_user ON t0.id = secteur_entreprise_user.secteur_entreprise_id WHERE secteur_entreprise_user.user_id = ?

Parameters:

[
  184
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.descripption AS descripption_2
FROM
  secteur_entreprise t0
  INNER JOIN secteur_entreprise_user ON t0.id = secteur_entreprise_user.secteur_entreprise_id
WHERE
  secteur_entreprise_user.user_id = ?

SELECT t0.id AS id_1, t0.descripption AS descripption_2 FROM secteur_entreprise t0 INNER JOIN secteur_entreprise_user ON t0.id = secteur_entreprise_user.secteur_entreprise_id WHERE secteur_entreprise_user.user_id = 184;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 6511)
8	__TwigTemplate_25c40fab29bd2d7d2c6cdfa06c41a804->block_body (line 431)
9	Twig\Template->yieldBlock (line 653)
10	__TwigTemplate_e3250f31f3c24d7b18a6c2b55a127dd5->doDisplay (line 387)
11	Twig\Template->yield (line 55)
12	__TwigTemplate_25c40fab29bd2d7d2c6cdfa06c41a804->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
21	App\Controller\HomeController->detail_recruteur (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.30 ms
(9.30%)

SELECT t0.id AS id_1, t0.description AS description_2 FROM type_emploie t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2
FROM
  type_emploie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2 FROM type_emploie t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\TypeEmploie::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\TypeEmploie->__get (line 39)
8	App\Entity\TypeEmploie->getDescription (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 7154)
10	__TwigTemplate_25c40fab29bd2d7d2c6cdfa06c41a804->block_body (line 431)
11	Twig\Template->yieldBlock (line 653)
12	__TwigTemplate_e3250f31f3c24d7b18a6c2b55a127dd5->doDisplay (line 387)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_25c40fab29bd2d7d2c6cdfa06c41a804->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 357)
23	App\Controller\HomeController->detail_recruteur (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\User	No errors.
App\Entity\Metier	No errors.
App\Entity\Expertise	No errors.
App\Entity\Niveau	No errors.
App\Entity\Secteur	No errors.
App\Entity\Genre	No errors.
App\Entity\Education	No errors.
App\Entity\Experience	No errors.
App\Entity\Portofolio	No errors.
App\Entity\Competence	No errors.
App\Entity\Langue	No errors.
App\Entity\Formation	No errors.
App\Entity\LettreMotivation	No errors.
App\Entity\ManageCv	No errors.
App\Entity\SecteurEntreprise	No errors.
App\Entity\Emploie	The association App\Entity\Emploie#users refers to the owning side field App\Entity\User#emploie which does not exist.
App\Entity\Candidature	No errors.
App\Entity\Reviews	No errors.
App\Entity\Contact	No errors.
App\Entity\TypeEmploie	No errors.

Symfony Profiler

GET https://dev.manalti.com/liste-des-recruteur/detail-recruteur/rikolto

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping