Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.21 ms Query time

1 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.41 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.telephone AS telephone_7, t0.email_verified AS email_verified_8, t0.is_active AS is_active_9, t0.departement AS departement_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.stripe_customer_id AS stripe_customer_id_13, t0.reset_password_token AS reset_password_token_14, t0.reset_password_token_expires_at AS reset_password_token_expires_at_15, t0.new_email AS new_email_16, t0.email_change_token AS email_change_token_17, t0.email_change_token_expires_at AS email_change_token_expires_at_18, t0.last_login_at AS last_login_at_19, t0.inactivity_reminder_shown_at AS inactivity_reminder_shown_at_20, t0.email_verification_token AS email_verification_token_21, t0.email_verification_token_expires_at AS email_verification_token_expires_at_22, t0.double_auth_token AS double_auth_token_23, t0.double_auth_token_expires_at AS double_auth_token_expires_at_24, t0.double_auth_verified_at AS double_auth_verified_at_25 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "pverdiere@homasante.com"
]

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.prenom AS prenom_5,
  t0.nom AS nom_6,
  t0.telephone AS telephone_7,
  t0.email_verified AS email_verified_8,
  t0.is_active AS is_active_9,
  t0.departement AS departement_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.stripe_customer_id AS stripe_customer_id_13,
  t0.reset_password_token AS reset_password_token_14,
  t0.reset_password_token_expires_at AS reset_password_token_expires_at_15,
  t0.new_email AS new_email_16,
  t0.email_change_token AS email_change_token_17,
  t0.email_change_token_expires_at AS email_change_token_expires_at_18,
  t0.last_login_at AS last_login_at_19,
  t0.inactivity_reminder_shown_at AS inactivity_reminder_shown_at_20,
  t0.email_verification_token AS email_verification_token_21,
  t0.email_verification_token_expires_at AS email_verification_token_expires_at_22,
  t0.double_auth_token AS double_auth_token_23,
  t0.double_auth_token_expires_at AS double_auth_token_expires_at_24,
  t0.double_auth_verified_at AS double_auth_verified_at_25
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.telephone AS telephone_7, t0.email_verified AS email_verified_8, t0.is_active AS is_active_9, t0.departement AS departement_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.stripe_customer_id AS stripe_customer_id_13, t0.reset_password_token AS reset_password_token_14, t0.reset_password_token_expires_at AS reset_password_token_expires_at_15, t0.new_email AS new_email_16, t0.email_change_token AS email_change_token_17, t0.email_change_token_expires_at AS email_change_token_expires_at_18, t0.last_login_at AS last_login_at_19, t0.inactivity_reminder_shown_at AS inactivity_reminder_shown_at_20, t0.email_verification_token AS email_verification_token_21, t0.email_verification_token_expires_at AS email_verification_token_expires_at_22, t0.double_auth_token AS double_auth_token_23, t0.double_auth_token_expires_at AS double_auth_token_expires_at_24, t0.double_auth_verified_at AS double_auth_verified_at_25 FROM user t0 WHERE t0.email = 'pverdiere@homasante.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
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 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 105)
7	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.38 ms

SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.nom_commercial AS nom_commercial_3, t0.denomination AS denomination_4, t0.siren AS siren_5, t0.siret AS siret_6, t0.agrement AS agrement_7, t0.numero_finess AS numero_finess_8, t0.finess_agrement_alerte AS finess_agrement_alerte_9, t0.forme_juridique AS forme_juridique_10, t0.libelle_forme_juridique AS libelle_forme_juridique_11, t0.sous_traitance AS sous_traitance_12, t0.adresse AS adresse_13, t0.adresse2 AS adresse2_14, t0.ville AS ville_15, t0.code_postal AS code_postal_16, t0.nombre_vehicules_type_b AS nombre_vehicules_type_b_17, t0.nombre_vehicules_type_a AS nombre_vehicules_type_a_18, t0.annee_cotisation AS annee_cotisation_19, t0.telephone_principal AS telephone_principal_20, t0.email_principal AS email_principal_21, t0.numero_client_rassur AS numero_client_rassur_22, t0.numero_rpps AS numero_rpps_23, t0.convention_participation AS convention_participation_24, t0.gsm_sira AS gsm_sira_25, t0.date_adhesion AS date_adhesion_26, t0.code_ape AS code_ape_27, t0.libelle_ape AS libelle_ape_28, t0.tranche_effectifs AS tranche_effectifs_29, t0.libelle_tranche_effectifs AS libelle_tranche_effectifs_30, t0.date_creation AS date_creation_31, t0.date_cloture AS date_cloture_32, t0.numero_tva_intracommunautaire AS numero_tva_intracommunautaire_33, t0.statut_sirene AS statut_sirene_34, t0.statut_adhesion AS statut_adhesion_35, t0.is_active AS is_active_36, t0.validation_admin_status AS validation_admin_status_37, t0.date_validation_admin AS date_validation_admin_38, t0.syndicats AS syndicats_39, t0.syndicats_autres AS syndicats_autres_40, t0.reseaux AS reseaux_41, t0.reseaux_autres AS reseaux_autres_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.validated_by_id AS validated_by_id_45, t0.departement_id AS departement_id_46, t0.created_by_id AS created_by_id_47, t0.entreprise_parente_id AS entreprise_parente_id_48 FROM entreprise t0 WHERE t0.id = ?

Parameters:

[
  200
]

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.nom_commercial AS nom_commercial_3,
  t0.denomination AS denomination_4,
  t0.siren AS siren_5,
  t0.siret AS siret_6,
  t0.agrement AS agrement_7,
  t0.numero_finess AS numero_finess_8,
  t0.finess_agrement_alerte AS finess_agrement_alerte_9,
  t0.forme_juridique AS forme_juridique_10,
  t0.libelle_forme_juridique AS libelle_forme_juridique_11,
  t0.sous_traitance AS sous_traitance_12,
  t0.adresse AS adresse_13,
  t0.adresse2 AS adresse2_14,
  t0.ville AS ville_15,
  t0.code_postal AS code_postal_16,
  t0.nombre_vehicules_type_b AS nombre_vehicules_type_b_17,
  t0.nombre_vehicules_type_a AS nombre_vehicules_type_a_18,
  t0.annee_cotisation AS annee_cotisation_19,
  t0.telephone_principal AS telephone_principal_20,
  t0.email_principal AS email_principal_21,
  t0.numero_client_rassur AS numero_client_rassur_22,
  t0.numero_rpps AS numero_rpps_23,
  t0.convention_participation AS convention_participation_24,
  t0.gsm_sira AS gsm_sira_25,
  t0.date_adhesion AS date_adhesion_26,
  t0.code_ape AS code_ape_27,
  t0.libelle_ape AS libelle_ape_28,
  t0.tranche_effectifs AS tranche_effectifs_29,
  t0.libelle_tranche_effectifs AS libelle_tranche_effectifs_30,
  t0.date_creation AS date_creation_31,
  t0.date_cloture AS date_cloture_32,
  t0.numero_tva_intracommunautaire AS numero_tva_intracommunautaire_33,
  t0.statut_sirene AS statut_sirene_34,
  t0.statut_adhesion AS statut_adhesion_35,
  t0.is_active AS is_active_36,
  t0.validation_admin_status AS validation_admin_status_37,
  t0.date_validation_admin AS date_validation_admin_38,
  t0.syndicats AS syndicats_39,
  t0.syndicats_autres AS syndicats_autres_40,
  t0.reseaux AS reseaux_41,
  t0.reseaux_autres AS reseaux_autres_42,
  t0.created_at AS created_at_43,
  t0.updated_at AS updated_at_44,
  t0.validated_by_id AS validated_by_id_45,
  t0.departement_id AS departement_id_46,
  t0.created_by_id AS created_by_id_47,
  t0.entreprise_parente_id AS entreprise_parente_id_48
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.nom_commercial AS nom_commercial_3, t0.denomination AS denomination_4, t0.siren AS siren_5, t0.siret AS siret_6, t0.agrement AS agrement_7, t0.numero_finess AS numero_finess_8, t0.finess_agrement_alerte AS finess_agrement_alerte_9, t0.forme_juridique AS forme_juridique_10, t0.libelle_forme_juridique AS libelle_forme_juridique_11, t0.sous_traitance AS sous_traitance_12, t0.adresse AS adresse_13, t0.adresse2 AS adresse2_14, t0.ville AS ville_15, t0.code_postal AS code_postal_16, t0.nombre_vehicules_type_b AS nombre_vehicules_type_b_17, t0.nombre_vehicules_type_a AS nombre_vehicules_type_a_18, t0.annee_cotisation AS annee_cotisation_19, t0.telephone_principal AS telephone_principal_20, t0.email_principal AS email_principal_21, t0.numero_client_rassur AS numero_client_rassur_22, t0.numero_rpps AS numero_rpps_23, t0.convention_participation AS convention_participation_24, t0.gsm_sira AS gsm_sira_25, t0.date_adhesion AS date_adhesion_26, t0.code_ape AS code_ape_27, t0.libelle_ape AS libelle_ape_28, t0.tranche_effectifs AS tranche_effectifs_29, t0.libelle_tranche_effectifs AS libelle_tranche_effectifs_30, t0.date_creation AS date_creation_31, t0.date_cloture AS date_cloture_32, t0.numero_tva_intracommunautaire AS numero_tva_intracommunautaire_33, t0.statut_sirene AS statut_sirene_34, t0.statut_adhesion AS statut_adhesion_35, t0.is_active AS is_active_36, t0.validation_admin_status AS validation_admin_status_37, t0.date_validation_admin AS date_validation_admin_38, t0.syndicats AS syndicats_39, t0.syndicats_autres AS syndicats_autres_40, t0.reseaux AS reseaux_41, t0.reseaux_autres AS reseaux_autres_42, t0.created_at AS created_at_43, t0.updated_at AS updated_at_44, t0.validated_by_id AS validated_by_id_45, t0.departement_id AS departement_id_46, t0.created_by_id AS created_by_id_47, t0.entreprise_parente_id AS entreprise_parente_id_48 FROM entreprise t0 WHERE t0.id = 200;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 68)
7	App\Controller\Api\CotisationStatusController->show (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.43 ms

SELECT t0.role AS role_1, t0.validation_status AS validation_status_2, t0.entreprise_id AS entreprise_id_3, t0.user_id AS user_id_4 FROM entreprise_user t0 WHERE t0.entreprise_id = ?

Parameters:

[
  200
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.role AS role_1,
  t0.validation_status AS validation_status_2,
  t0.entreprise_id AS entreprise_id_3,
  t0.user_id AS user_id_4
FROM
  entreprise_user t0
WHERE
  t0.entreprise_id = ?

SELECT t0.role AS role_1, t0.validation_status AS validation_status_2, t0.entreprise_id AS entreprise_id_3, t0.user_id AS user_id_4 FROM entreprise_user t0 WHERE t0.entreprise_id = 200;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
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 270)
8	App\Entity\Enterprise\Entreprise->getUsers (line 77)
9	App\Controller\Api\CotisationStatusController->show (line 181)
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)

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\Enterprise\Entreprise	2
App\Entity\User	1
App\Entity\Geography\Departement	1
App\Entity\Enterprise\EntrepriseUser	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Enterprise\EntrepriseUser	No errors.
App\Entity\Enterprise\Entreprise	No errors.
App\Entity\Geography\Departement	No errors.
App\Entity\Vehicle\Vehicule	No errors.
App\Entity\Enterprise\Cotisation	No errors.
App\Entity\Commerce\Abonnement	No errors.
App\Entity\Content\Document	No errors.
App\Entity\Event\Inscription	The mappings App\Entity\Event\Inscription#transactions and App\Entity\Commerce\Transaction#inscription are inconsistent with each other.
App\Entity\Incident\FEI	No errors.
App\Entity\Enterprise\Contact	No errors.
App\Entity\Enterprise\SecteurDeGarde	No errors.

Symfony Profiler

GET https://backend.atsuhdf.fr/api/cotisations/status/200

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping