Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.57 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.64 ms

SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.nom_p AS nom_p_5, t0.prenom_p AS prenom_p_6, t0.date_naissance_p AS date_naissance_p_7, t0.est_active AS est_active_8, t0.email AS email_9, t0.google_id AS google_id_10, t0.google_refresh_token AS google_refresh_token_11, t0.google_sync_token AS google_sync_token_12, t0.device_ip AS device_ip_13, t0.device_token AS device_token_14, t0.pays_id AS pays_id_15, t0.departement_id AS departement_id_16, t0.localite_id AS localite_id_17, t0.abonnement_actuel_id AS abonnement_actuel_id_18 FROM entreprise t0 WHERE t0.device_token = ? LIMIT 1

Parameters:

[
  "1b545b145b0e7abd864f603950d86bc6a510cefeb650e2ca"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.raison_sociale AS raison_sociale_2,
  t0.logo AS logo_3,
  t0.telephone AS telephone_4,
  t0.nom_p AS nom_p_5,
  t0.prenom_p AS prenom_p_6,
  t0.date_naissance_p AS date_naissance_p_7,
  t0.est_active AS est_active_8,
  t0.email AS email_9,
  t0.google_id AS google_id_10,
  t0.google_refresh_token AS google_refresh_token_11,
  t0.google_sync_token AS google_sync_token_12,
  t0.device_ip AS device_ip_13,
  t0.device_token AS device_token_14,
  t0.pays_id AS pays_id_15,
  t0.departement_id AS departement_id_16,
  t0.localite_id AS localite_id_17,
  t0.abonnement_actuel_id AS abonnement_actuel_id_18
FROM
  entreprise t0
WHERE
  t0.device_token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.nom_p AS nom_p_5, t0.prenom_p AS prenom_p_6, t0.date_naissance_p AS date_naissance_p_7, t0.est_active AS est_active_8, t0.email AS email_9, t0.google_id AS google_id_10, t0.google_refresh_token AS google_refresh_token_11, t0.google_sync_token AS google_sync_token_12, t0.device_ip AS device_ip_13, t0.device_token AS device_token_14, t0.pays_id AS pays_id_15, t0.departement_id AS departement_id_16, t0.localite_id AS localite_id_17, t0.abonnement_actuel_id AS abonnement_actuel_id_18 FROM entreprise t0 WHERE t0.device_token = '1b545b145b0e7abd864f603950d86bc6a510cefeb650e2ca' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 34)
5	App\Controller\DeviceStatController->apiIngest (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.93 ms

SELECT t0.id AS id_1, t0.nombre_clients_total AS nombre_clients_total_2, t0.nombre_clients_servis AS nombre_clients_servis_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.created_at AS created_at_6, t0.entrees AS entrees_7, t0.sorties AS sorties_8, t0.satisfait AS satisfait_9, t0.pas_satisfait AS pas_satisfait_10, t0.source AS source_11, t0.entreprise_id AS entreprise_id_12 FROM patient_stat t0 WHERE t0.entreprise_id = ? AND t0.date_debut = ? AND t0.source = ? LIMIT 1

Parameters:

[
  1
  "2026-08-22"
  "automatique"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre_clients_total AS nombre_clients_total_2,
  t0.nombre_clients_servis AS nombre_clients_servis_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.created_at AS created_at_6,
  t0.entrees AS entrees_7,
  t0.sorties AS sorties_8,
  t0.satisfait AS satisfait_9,
  t0.pas_satisfait AS pas_satisfait_10,
  t0.source AS source_11,
  t0.entreprise_id AS entreprise_id_12
FROM
  patient_stat t0
WHERE
  t0.entreprise_id = ?
  AND t0.date_debut = ?
  AND t0.source = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre_clients_total AS nombre_clients_total_2, t0.nombre_clients_servis AS nombre_clients_servis_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.created_at AS created_at_6, t0.entrees AS entrees_7, t0.sorties AS sorties_8, t0.satisfait AS satisfait_9, t0.pas_satisfait AS pas_satisfait_10, t0.source AS source_11, t0.entreprise_id AS entreprise_id_12 FROM patient_stat t0 WHERE t0.entreprise_id = 1 AND t0.date_debut = '2026-08-22' AND t0.source = 'automatique' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 48)
5	App\Controller\DeviceStatController->apiIngest (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)

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\Entreprise	No errors.
App\Entity\Pays	No errors.
App\Entity\Departement	No errors.
App\Entity\Localite	No errors.
App\Entity\Abonnement	No errors.
App\Entity\User	No errors.
App\Entity\Personnel	No errors.
App\Entity\Plainte	No errors.
App\Entity\PatientStat	No errors.
App\Entity\Achat	No errors.
App\Entity\Finance	No errors.
App\Entity\Depense	No errors.
App\Entity\Vente	No errors.
App\Entity\BordereauLivraison	No errors.
App\Entity\Tache	No errors.
App\Entity\DeclarationFiscaleEntreprise	No errors.
App\Entity\Prestataire	No errors.
App\Entity\Versement	No errors.
App\Entity\Piece	No errors.
App\Entity\Reclamation	No errors.
App\Entity\Ticket	No errors.
App\Entity\Enquete	No errors.
App\Entity\Fiscalite	No errors.
App\Entity\Evaluation	No errors.
App\Entity\Absence	No errors.
App\Entity\MiseAPied	No errors.
App\Entity\DemandeExplication	No errors.
App\Entity\PlainteDepot	No errors.
App\Entity\RisqueProfessionnel	No errors.
App\Entity\Client	No errors.
App\Entity\BusinessPlan	The mappings App\Entity\BusinessPlan#honoraires and App\Entity\HonairePrestataire#businessPlan are inconsistent with each other.

Symfony Profiler

POST https://app.themanagercontrol.com/api/device/satisfaction-stats

Configuration Settings

Theme