Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

1.19 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.41 ms

SELECT a0_.id_agence AS id_agence_0, a0_.mail AS mail_1, a0_.telephone AS telephone_2, a0_.adresse_1 AS adresse_1_3, a0_.adresse_2 AS adresse_2_4, a0_.code_postal AS code_postal_5, a0_.ville AS ville_6, a0_.img_logo AS img_logo_7, a0_.site_web AS site_web_8, a0_.siret AS siret_9, a0_.date_creation AS date_creation_10, a0_.raison_sociale AS raison_sociale_11, a0_.uuid AS uuid_12, a0_.password AS password_13, a0_.stylesheet AS stylesheet_14, a0_.gestion_reglement AS gestion_reglement_15, a0_.traitement_journalier AS traitement_journalier_16, a0_.traitement_horaire AS traitement_horaire_17, a0_.url_bestt_net AS url_bestt_net_18, a0_.message_client AS message_client_19, a0_.message_salarie AS message_salarie_20, a0_.b_acomptes AS b_acomptes_21, a0_.b_paies AS b_paies_22, a0_.b_contrats_salarie AS b_contrats_salarie_23, a0_.b_contrats_client AS b_contrats_client_24, a0_.b_factures AS b_factures_25, a0_.b_rh_client AS b_rh_client_26, a0_.b_rh_salarie AS b_rh_salarie_27, a0_.b_sl_docs AS b_sl_docs_28, a0_.b_cl_docs AS b_cl_docs_29, a0_.b_dpae AS b_dpae_30, a0_.msa AS msa_31, a0_.mail_client_releves AS mail_client_releves_32, a0_.b_commande_salaire AS b_commande_salaire_33, a0_.b_planning_client AS b_planning_client_34, a0_.b_etat_facture_client AS b_etat_facture_client_35, a0_.b_offres_salaries AS b_offres_salaries_36, a0_.id_groupe AS id_groupe_37, a0_.mail_agence_id AS mail_agence_id_38 FROM agence a0_ WHERE a0_.url_bestt_net LIKE ?

Parameters:

[
  "https://sullivan.bestt.fr%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id_agence AS id_agence_0,
  a0_.mail AS mail_1,
  a0_.telephone AS telephone_2,
  a0_.adresse_1 AS adresse_1_3,
  a0_.adresse_2 AS adresse_2_4,
  a0_.code_postal AS code_postal_5,
  a0_.ville AS ville_6,
  a0_.img_logo AS img_logo_7,
  a0_.site_web AS site_web_8,
  a0_.siret AS siret_9,
  a0_.date_creation AS date_creation_10,
  a0_.raison_sociale AS raison_sociale_11,
  a0_.uuid AS uuid_12,
  a0_.password AS password_13,
  a0_.stylesheet AS stylesheet_14,
  a0_.gestion_reglement AS gestion_reglement_15,
  a0_.traitement_journalier AS traitement_journalier_16,
  a0_.traitement_horaire AS traitement_horaire_17,
  a0_.url_bestt_net AS url_bestt_net_18,
  a0_.message_client AS message_client_19,
  a0_.message_salarie AS message_salarie_20,
  a0_.b_acomptes AS b_acomptes_21,
  a0_.b_paies AS b_paies_22,
  a0_.b_contrats_salarie AS b_contrats_salarie_23,
  a0_.b_contrats_client AS b_contrats_client_24,
  a0_.b_factures AS b_factures_25,
  a0_.b_rh_client AS b_rh_client_26,
  a0_.b_rh_salarie AS b_rh_salarie_27,
  a0_.b_sl_docs AS b_sl_docs_28,
  a0_.b_cl_docs AS b_cl_docs_29,
  a0_.b_dpae AS b_dpae_30,
  a0_.msa AS msa_31,
  a0_.mail_client_releves AS mail_client_releves_32,
  a0_.b_commande_salaire AS b_commande_salaire_33,
  a0_.b_planning_client AS b_planning_client_34,
  a0_.b_etat_facture_client AS b_etat_facture_client_35,
  a0_.b_offres_salaries AS b_offres_salaries_36,
  a0_.id_groupe AS id_groupe_37,
  a0_.mail_agence_id AS mail_agence_id_38
FROM
  agence a0_
WHERE
  a0_.url_bestt_net LIKE ?

SELECT a0_.id_agence AS id_agence_0, a0_.mail AS mail_1, a0_.telephone AS telephone_2, a0_.adresse_1 AS adresse_1_3, a0_.adresse_2 AS adresse_2_4, a0_.code_postal AS code_postal_5, a0_.ville AS ville_6, a0_.img_logo AS img_logo_7, a0_.site_web AS site_web_8, a0_.siret AS siret_9, a0_.date_creation AS date_creation_10, a0_.raison_sociale AS raison_sociale_11, a0_.uuid AS uuid_12, a0_.password AS password_13, a0_.stylesheet AS stylesheet_14, a0_.gestion_reglement AS gestion_reglement_15, a0_.traitement_journalier AS traitement_journalier_16, a0_.traitement_horaire AS traitement_horaire_17, a0_.url_bestt_net AS url_bestt_net_18, a0_.message_client AS message_client_19, a0_.message_salarie AS message_salarie_20, a0_.b_acomptes AS b_acomptes_21, a0_.b_paies AS b_paies_22, a0_.b_contrats_salarie AS b_contrats_salarie_23, a0_.b_contrats_client AS b_contrats_client_24, a0_.b_factures AS b_factures_25, a0_.b_rh_client AS b_rh_client_26, a0_.b_rh_salarie AS b_rh_salarie_27, a0_.b_sl_docs AS b_sl_docs_28, a0_.b_cl_docs AS b_cl_docs_29, a0_.b_dpae AS b_dpae_30, a0_.msa AS msa_31, a0_.mail_client_releves AS mail_client_releves_32, a0_.b_commande_salaire AS b_commande_salaire_33, a0_.b_planning_client AS b_planning_client_34, a0_.b_etat_facture_client AS b_etat_facture_client_35, a0_.b_offres_salaries AS b_offres_salaries_36, a0_.id_groupe AS id_groupe_37, a0_.mail_agence_id AS mail_agence_id_38 FROM agence a0_ WHERE a0_.url_bestt_net LIKE 'https://sullivan.bestt.fr%';

#	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	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\AgenceRepository->findOneByURL (line 146)
7	App\Controller\ReactController->resolveLoginAgence (line 256)
8	App\Controller\ReactController->loginPage (line 48)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.34 ms

SELECT t0.id AS id_1, t0.logo_url AS logo_url_2, t0.primary_color AS primary_color_3, t0.secondary_color AS secondary_color_4, t0.accent_color AS accent_color_5, t0.font_family AS font_family_6, t0.background_image_url AS background_image_url_7, t0.theme_overrides AS theme_overrides_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.agency_id AS agency_id_11 FROM agency_customization t0 WHERE t0.agency_id = ? LIMIT 1

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo_url AS logo_url_2,
  t0.primary_color AS primary_color_3,
  t0.secondary_color AS secondary_color_4,
  t0.accent_color AS accent_color_5,
  t0.font_family AS font_family_6,
  t0.background_image_url AS background_image_url_7,
  t0.theme_overrides AS theme_overrides_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.agency_id AS agency_id_11
FROM
  agency_customization t0
WHERE
  t0.agency_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.logo_url AS logo_url_2, t0.primary_color AS primary_color_3, t0.secondary_color AS secondary_color_4, t0.accent_color AS accent_color_5, t0.font_family AS font_family_6, t0.background_image_url AS background_image_url_7, t0.theme_overrides AS theme_overrides_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.agency_id AS agency_id_11 FROM agency_customization t0 WHERE t0.agency_id = 10 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Modules\Core\Service\CustomizationService->buildCustomization (line 26)
5	App\Controller\ReactController->buildAgencyViewData (line 285)
6	App\Controller\ReactController->loginPage (line 50)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.24 ms

SELECT a0_.raison_sociale AS raison_sociale_0 FROM agence a0_ WHERE a0_.url_bestt_net LIKE ?

Parameters:

[
  "https://sullivan.bestt.fr%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.raison_sociale AS raison_sociale_0
FROM
  agence a0_
WHERE
  a0_.url_bestt_net LIKE ?

SELECT a0_.raison_sociale AS raison_sociale_0 FROM agence a0_ WHERE a0_.url_bestt_net LIKE 'https://sullivan.bestt.fr%';

#	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	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\TwigToolBox->getAgenceRaisonSociale (line 247)
7	__TwigTemplate_5c25695232375133794c48172fb7345f->doDisplay (line 55)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
16	App\Controller\ReactController->loginPage (line 50)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 208)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

0.20 ms

SELECT a0_.raison_sociale AS raison_sociale_0 FROM agence a0_ WHERE a0_.url_bestt_net LIKE ?

Parameters:

[
  "https://sullivan.bestt.fr%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.raison_sociale AS raison_sociale_0
FROM
  agence a0_
WHERE
  a0_.url_bestt_net LIKE ?

SELECT a0_.raison_sociale AS raison_sociale_0 FROM agence a0_ WHERE a0_.url_bestt_net LIKE 'https://sullivan.bestt.fr%';

#	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	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Service\TwigToolBox->getAgenceRaisonSociale (line 247)
7	__TwigTemplate_062daa2cb3fa7aa8eb2fa2301728faa7->doDisplay (line 75)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_5c25695232375133794c48172fb7345f->doDisplay (line 66)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
18	App\Controller\ReactController->loginPage (line 50)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 208)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 29)
24	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Agence	1
App\Entity\MailAgence	1

Entities Mapping

Class	Mapping errors
App\Entity\Agence	No errors.
App\Entity\Groupe	No errors.
App\Entity\MailAgence	No errors.
App\Entity\AgenceClient	No errors.
App\Entity\AgenceContact	No errors.
App\Entity\AgenceSalarie	No errors.
App\Entity\AgencePermanent	No errors.
App\Entity\Qualification	No errors.
App\Entity\Commande	No errors.
App\Entity\Indisponibilite	No errors.
App\Entity\SalaireSynthese	No errors.
App\Entity\FactureSynthese	No errors.
App\Entity\DocumentDemande	No errors.
App\Entity\Contrat	No errors.
App\Entity\Acompte	No errors.
App\Entity\LieuMission	No errors.
App\Entity\Document	No errors.
App\Entity\Notification	No errors.
App\Entity\Candidat	No errors.
App\Entity\ClientSalarieInfo	No errors.
App\Entity\Prospect	No errors.
App\Entity\DocumentWebType	No errors.
App\Entity\AgencyCustomization	No errors.

Symfony Profiler

GET https://sullivan.bestt.fr/v2/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping