Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.97 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.80 ms
(40.76%)

INSERT INTO log_api (agence, url, method, http_code, data, resultat, date_reception) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  10
  "https://remy.bestt.fr/api/client_salarie_infos?changementEtat=1&page=1"
  "GET"
  200
  ""
  "[]"
  "2025-12-22 08:54:54"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO log_api (
  agence, url, method, http_code, data,
  resultat, date_reception
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO log_api (agence, url, method, http_code, data, resultat, date_reception) VALUES (10, 'https://remy.bestt.fr/api/client_salarie_infos?changementEtat=1&page=1', 'GET', 200, '', '[]', '2025-12-22 08:54:54');

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 518)
2	Doctrine\DBAL\Connection->insert (line 257)
3	App\Service\ToolBox->log (line 93)
4	App\EventSubscriber\ApiResponseEventSubscriber->logApi (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
9	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.42 ms
(21.42%)

SELECT t0.id_agence AS id_agence_1, t0.mail AS mail_2, t0.telephone AS telephone_3, t0.adresse_1 AS adresse_1_4, t0.adresse_2 AS adresse_2_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.img_logo AS img_logo_8, t0.site_web AS site_web_9, t0.siret AS siret_10, t0.date_creation AS date_creation_11, t0.raison_sociale AS raison_sociale_12, t0.uuid AS uuid_13, t0.password AS password_14, t0.stylesheet AS stylesheet_15, t0.gestion_reglement AS gestion_reglement_16, t0.traitement_journalier AS traitement_journalier_17, t0.traitement_horaire AS traitement_horaire_18, t0.url_bestt_net AS url_bestt_net_19, t0.message_client AS message_client_20, t0.message_salarie AS message_salarie_21, t0.b_acomptes AS b_acomptes_22, t0.b_paies AS b_paies_23, t0.b_contrats_salarie AS b_contrats_salarie_24, t0.b_contrats_client AS b_contrats_client_25, t0.b_factures AS b_factures_26, t0.b_rh_client AS b_rh_client_27, t0.b_rh_salarie AS b_rh_salarie_28, t0.b_sl_docs AS b_sl_docs_29, t0.b_cl_docs AS b_cl_docs_30, t0.b_dpae AS b_dpae_31, t0.msa AS msa_32, t0.mail_client_releves AS mail_client_releves_33, t0.b_commande_salaire AS b_commande_salaire_34, t0.b_planning_client AS b_planning_client_35, t0.b_etat_facture_client AS b_etat_facture_client_36, t0.b_offres_salaries AS b_offres_salaries_37, t0.id_groupe AS id_groupe_38, t0.mail_agence_id AS mail_agence_id_39 FROM agence t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "1234-8572afc2c42a4019bd4826e8383bb635"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_agence AS id_agence_1,
  t0.mail AS mail_2,
  t0.telephone AS telephone_3,
  t0.adresse_1 AS adresse_1_4,
  t0.adresse_2 AS adresse_2_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.img_logo AS img_logo_8,
  t0.site_web AS site_web_9,
  t0.siret AS siret_10,
  t0.date_creation AS date_creation_11,
  t0.raison_sociale AS raison_sociale_12,
  t0.uuid AS uuid_13,
  t0.password AS password_14,
  t0.stylesheet AS stylesheet_15,
  t0.gestion_reglement AS gestion_reglement_16,
  t0.traitement_journalier AS traitement_journalier_17,
  t0.traitement_horaire AS traitement_horaire_18,
  t0.url_bestt_net AS url_bestt_net_19,
  t0.message_client AS message_client_20,
  t0.message_salarie AS message_salarie_21,
  t0.b_acomptes AS b_acomptes_22,
  t0.b_paies AS b_paies_23,
  t0.b_contrats_salarie AS b_contrats_salarie_24,
  t0.b_contrats_client AS b_contrats_client_25,
  t0.b_factures AS b_factures_26,
  t0.b_rh_client AS b_rh_client_27,
  t0.b_rh_salarie AS b_rh_salarie_28,
  t0.b_sl_docs AS b_sl_docs_29,
  t0.b_cl_docs AS b_cl_docs_30,
  t0.b_dpae AS b_dpae_31,
  t0.msa AS msa_32,
  t0.mail_client_releves AS mail_client_releves_33,
  t0.b_commande_salaire AS b_commande_salaire_34,
  t0.b_planning_client AS b_planning_client_35,
  t0.b_etat_facture_client AS b_etat_facture_client_36,
  t0.b_offres_salaries AS b_offres_salaries_37,
  t0.id_groupe AS id_groupe_38,
  t0.mail_agence_id AS mail_agence_id_39
FROM
  agence t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id_agence AS id_agence_1, t0.mail AS mail_2, t0.telephone AS telephone_3, t0.adresse_1 AS adresse_1_4, t0.adresse_2 AS adresse_2_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.img_logo AS img_logo_8, t0.site_web AS site_web_9, t0.siret AS siret_10, t0.date_creation AS date_creation_11, t0.raison_sociale AS raison_sociale_12, t0.uuid AS uuid_13, t0.password AS password_14, t0.stylesheet AS stylesheet_15, t0.gestion_reglement AS gestion_reglement_16, t0.traitement_journalier AS traitement_journalier_17, t0.traitement_horaire AS traitement_horaire_18, t0.url_bestt_net AS url_bestt_net_19, t0.message_client AS message_client_20, t0.message_salarie AS message_salarie_21, t0.b_acomptes AS b_acomptes_22, t0.b_paies AS b_paies_23, t0.b_contrats_salarie AS b_contrats_salarie_24, t0.b_contrats_client AS b_contrats_client_25, t0.b_factures AS b_factures_26, t0.b_rh_client AS b_rh_client_27, t0.b_rh_salarie AS b_rh_salarie_28, t0.b_sl_docs AS b_sl_docs_29, t0.b_cl_docs AS b_cl_docs_30, t0.b_dpae AS b_dpae_31, t0.msa AS msa_32, t0.mail_client_releves AS mail_client_releves_33, t0.b_commande_salaire AS b_commande_salaire_34, t0.b_planning_client AS b_planning_client_35, t0.b_etat_facture_client AS b_etat_facture_client_36, t0.b_offres_salaries AS b_offres_salaries_37, t0.id_groupe AS id_groupe_38, t0.mail_agence_id AS mail_agence_id_39 FROM agence t0 WHERE t0.uuid = '1234-8572afc2c42a4019bd4826e8383bb635' 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 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 63)
6	Symfony\Component\Security\Core\User\ChainUserProvider->loadUserByIdentifier (line 87)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.41 ms
(20.91%)

SELECT c0_.id AS id_0, c0_.commentaire_client AS commentaire_client_1, c0_.etat AS etat_2, c0_.changement_etat AS changement_etat_3, c0_.id_client AS id_client_4, c0_.id_salarie AS id_salarie_5, c0_.id_agence AS id_agence_6 FROM client_salarie_info c0_ WHERE c0_.id_agence = ? AND c0_.changement_etat = ? ORDER BY c0_.id ASC LIMIT 30

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.commentaire_client AS commentaire_client_1,
  c0_.etat AS etat_2,
  c0_.changement_etat AS changement_etat_3,
  c0_.id_client AS id_client_4,
  c0_.id_salarie AS id_salarie_5,
  c0_.id_agence AS id_agence_6
FROM
  client_salarie_info c0_
WHERE
  c0_.id_agence = ?
  AND c0_.changement_etat = ?
ORDER BY
  c0_.id ASC
LIMIT
  30

SELECT c0_.id AS id_0, c0_.commentaire_client AS commentaire_client_1, c0_.etat AS etat_2, c0_.changement_etat AS changement_etat_3, c0_.id_client AS id_client_4, c0_.id_salarie AS id_salarie_5, c0_.id_agence AS id_agence_6 FROM client_salarie_info c0_ WHERE c0_.id_agence = 10 AND c0_.changement_etat = 1 ORDER BY c0_.id ASC LIMIT 30;

#	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 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 178)
9	Symfony\Component\Serializer\Serializer->normalize (line 140)
10	Symfony\Component\Serializer\Serializer->serialize (line 74)
11	ApiPlatform\State\Processor\SerializeProcessor->process (line 65)
12	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 186)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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
(16.91%)

SELECT t0.id_user AS id_user_1, t0.user_name AS user_name_2, t0.mail AS mail_3, t0.roles AS roles_4, t0.password AS password_5, t0.actif AS actif_6, t0.date_creation AS date_creation_7, t0.date_desactivation AS date_desactivation_8, t0.photo_profil AS photo_profil_9, t0.reset_token AS reset_token_10, t0.actif_token AS actif_token_11, t0.recent AS recent_12, t0.last_login AS last_login_13, t0.nombre_connexions AS nombre_connexions_14, t0.modified_push_subscription AS modified_push_subscription_15, t0.is_allowed_to_switch AS is_allowed_to_switch_16, t0.cree_dans_bestt AS cree_dans_bestt_17, t0.id_salarie AS id_salarie_18, t0.id_permanent AS id_permanent_19, t0.id_contact AS id_contact_20 FROM user t0 WHERE t0.user_name = ? LIMIT 1

Parameters:

[
  "1234-8572afc2c42a4019bd4826e8383bb635"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_user AS id_user_1,
  t0.user_name AS user_name_2,
  t0.mail AS mail_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.actif AS actif_6,
  t0.date_creation AS date_creation_7,
  t0.date_desactivation AS date_desactivation_8,
  t0.photo_profil AS photo_profil_9,
  t0.reset_token AS reset_token_10,
  t0.actif_token AS actif_token_11,
  t0.recent AS recent_12,
  t0.last_login AS last_login_13,
  t0.nombre_connexions AS nombre_connexions_14,
  t0.modified_push_subscription AS modified_push_subscription_15,
  t0.is_allowed_to_switch AS is_allowed_to_switch_16,
  t0.cree_dans_bestt AS cree_dans_bestt_17,
  t0.id_salarie AS id_salarie_18,
  t0.id_permanent AS id_permanent_19,
  t0.id_contact AS id_contact_20
FROM
  user t0
WHERE
  t0.user_name = ?
LIMIT
  1

SELECT t0.id_user AS id_user_1, t0.user_name AS user_name_2, t0.mail AS mail_3, t0.roles AS roles_4, t0.password AS password_5, t0.actif AS actif_6, t0.date_creation AS date_creation_7, t0.date_desactivation AS date_desactivation_8, t0.photo_profil AS photo_profil_9, t0.reset_token AS reset_token_10, t0.actif_token AS actif_token_11, t0.recent AS recent_12, t0.last_login AS last_login_13, t0.nombre_connexions AS nombre_connexions_14, t0.modified_push_subscription AS modified_push_subscription_15, t0.is_allowed_to_switch AS is_allowed_to_switch_16, t0.cree_dans_bestt AS cree_dans_bestt_17, t0.id_salarie AS id_salarie_18, t0.id_permanent AS id_permanent_19, t0.id_contact AS id_contact_20 FROM user t0 WHERE t0.user_name = '1234-8572afc2c42a4019bd4826e8383bb635' 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 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 63)
6	Symfony\Component\Security\Core\User\ChainUserProvider->loadUserByIdentifier (line 87)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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\User	No errors.
App\Entity\Salarie	No errors.
App\Entity\Permanent	No errors.
App\Entity\Contact	No 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\Client	No errors.
App\Entity\MotifRecours	No errors.
App\Entity\Releve	No errors.
App\Entity\PushSubscription	No errors.
App\Entity\NotificationUser	No errors.
App\Entity\OffreMission	No errors.

Symfony Profiler

GET https://remy.bestt.fr/api/client_salarie_infos?changementEtat=1&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping