Symfony Profiler

Query Metrics

10 Database Queries

9 Different statements

3.92 ms Query time

2 Invalid entities

23 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.91 ms
(23.15%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.ifu AS ifu_7, t0.password AS password_8, t0.roles AS roles_9, t0.photo_profil AS photo_profil_10, t0.type_compte AS type_compte_11, t0.confirmation_token AS confirmation_token_12, t0.reset_password_token AS reset_password_token_13, t0.reset_password_requested_at AS reset_password_requested_at_14, t0.is_verified AS is_verified_15, t0.confirmed_at AS confirmed_at_16, t0.last_confirmation_email_sent_at AS last_confirmation_email_sent_at_17, t0.bpay_account AS bpay_account_18, t0.careconcept_account AS careconcept_account_19, t0.businesspay_account AS businesspay_account_20, t0.cashline_account AS cashline_account_21, t0.instantmark_account AS instantmark_account_22 FROM users t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "temitope.akinyele@danone.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.email AS email_5,
  t0.telephone AS telephone_6,
  t0.ifu AS ifu_7,
  t0.password AS password_8,
  t0.roles AS roles_9,
  t0.photo_profil AS photo_profil_10,
  t0.type_compte AS type_compte_11,
  t0.confirmation_token AS confirmation_token_12,
  t0.reset_password_token AS reset_password_token_13,
  t0.reset_password_requested_at AS reset_password_requested_at_14,
  t0.is_verified AS is_verified_15,
  t0.confirmed_at AS confirmed_at_16,
  t0.last_confirmation_email_sent_at AS last_confirmation_email_sent_at_17,
  t0.bpay_account AS bpay_account_18,
  t0.careconcept_account AS careconcept_account_19,
  t0.businesspay_account AS businesspay_account_20,
  t0.cashline_account AS cashline_account_21,
  t0.instantmark_account AS instantmark_account_22
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.email AS email_5, t0.telephone AS telephone_6, t0.ifu AS ifu_7, t0.password AS password_8, t0.roles AS roles_9, t0.photo_profil AS photo_profil_10, t0.type_compte AS type_compte_11, t0.confirmation_token AS confirmation_token_12, t0.reset_password_token AS reset_password_token_13, t0.reset_password_requested_at AS reset_password_requested_at_14, t0.is_verified AS is_verified_15, t0.confirmed_at AS confirmed_at_16, t0.last_confirmation_email_sent_at AS last_confirmation_email_sent_at_17, t0.bpay_account AS bpay_account_18, t0.careconcept_account AS careconcept_account_19, t0.businesspay_account AS businesspay_account_20, t0.cashline_account AS cashline_account_21, t0.instantmark_account AS instantmark_account_22 FROM users t0 WHERE t0.email = 'temitope.akinyele@danone.com' 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 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 91)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
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 91)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.60 ms
(15.21%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.prix AS prix_5, t0.logo AS logo_6, t0.banniere AS banniere_7, t0.presentation AS presentation_8, t0.site_officiel AS site_officiel_9, t0.lien_plateforme AS lien_plateforme_10, t0.base_prefix AS base_prefix_11, t0.base_suffix AS base_suffix_12, t0.api_service AS api_service_13, t0.api_provisionning AS api_provisionning_14, t0.db_host AS db_host_15, t0.db_name AS db_name_16, t0.db_user AS db_user_17, t0.db_pass AS db_pass_18, t0.base_url AS base_url_19, t0.api_key AS api_key_20, t0.numero_bpay AS numero_bpay_21, t0.portail AS portail_22, t0.ordre_portail AS ordre_portail_23, t0.sous_compte_bpay AS sous_compte_bpay_24, t0.updated_at AS updated_at_25 FROM plateforme t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.prix AS prix_5,
  t0.logo AS logo_6,
  t0.banniere AS banniere_7,
  t0.presentation AS presentation_8,
  t0.site_officiel AS site_officiel_9,
  t0.lien_plateforme AS lien_plateforme_10,
  t0.base_prefix AS base_prefix_11,
  t0.base_suffix AS base_suffix_12,
  t0.api_service AS api_service_13,
  t0.api_provisionning AS api_provisionning_14,
  t0.db_host AS db_host_15,
  t0.db_name AS db_name_16,
  t0.db_user AS db_user_17,
  t0.db_pass AS db_pass_18,
  t0.base_url AS base_url_19,
  t0.api_key AS api_key_20,
  t0.numero_bpay AS numero_bpay_21,
  t0.portail AS portail_22,
  t0.ordre_portail AS ordre_portail_23,
  t0.sous_compte_bpay AS sous_compte_bpay_24,
  t0.updated_at AS updated_at_25
FROM
  plateforme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.prix AS prix_5, t0.logo AS logo_6, t0.banniere AS banniere_7, t0.presentation AS presentation_8, t0.site_officiel AS site_officiel_9, t0.lien_plateforme AS lien_plateforme_10, t0.base_prefix AS base_prefix_11, t0.base_suffix AS base_suffix_12, t0.api_service AS api_service_13, t0.api_provisionning AS api_provisionning_14, t0.db_host AS db_host_15, t0.db_name AS db_name_16, t0.db_user AS db_user_17, t0.db_pass AS db_pass_18, t0.base_url AS base_url_19, t0.api_key AS api_key_20, t0.numero_bpay AS numero_bpay_21, t0.portail AS portail_22, t0.ordre_portail AS ordre_portail_23, t0.sous_compte_bpay AS sous_compte_bpay_24, t0.updated_at AS updated_at_25 FROM plateforme t0 WHERE t0.id = 1;

#	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\Plateforme::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Plateforme->__get (line 137)
8	App\Entity\Plateforme->getNom (line 1010)
9	App\Controller\Api\CollaborationApiController->App\Controller\Api\{closure} (line 1)
10	array_map (line 977)
11	App\Controller\Api\CollaborationApiController->getAllCollaborationsByUser (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.43 ms
(11.08%)

SELECT t0.code AS code_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.code = user_role.role_code WHERE user_role.user_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2
FROM
  role t0
  INNER JOIN user_role ON t0.code = user_role.role_code
WHERE
  user_role.user_id = ?

SELECT t0.code AS code_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.code = user_role.role_code WHERE user_role.user_id = 31;

#	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 162)
8	App\Entity\Users->getRoles (line 213)
9	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->createToken (line 84)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->createToken (line 196)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
17	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 91)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
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.42 ms
(10.60%)

SELECT t0.id AS id_1, t0.role_code AS role_code_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.user_id AS user_id_5, t0.entreprise_id AS entreprise_id_6, t0.enseigne_id AS enseigne_id_7, t0.plateforme_id AS plateforme_id_8 FROM collaboration t0 WHERE t0.user_id = ?

Parameters:

[
  31
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.role_code AS role_code_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.user_id AS user_id_5,
  t0.entreprise_id AS entreprise_id_6,
  t0.enseigne_id AS enseigne_id_7,
  t0.plateforme_id AS plateforme_id_8
FROM
  collaboration t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.role_code AS role_code_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.user_id AS user_id_5, t0.entreprise_id AS entreprise_id_6, t0.enseigne_id AS enseigne_id_7, t0.plateforme_id AS plateforme_id_8 FROM collaboration t0 WHERE t0.user_id = 31;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 964)
5	App\Controller\Api\CollaborationApiController->getAllCollaborationsByUser (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.37 ms
(9.54%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.indicatif AS indicatif_4, t0.flag AS flag_5, t0.phone_length AS phone_length_6, t0.phone_regex AS phone_regex_7, t0.phone_example AS phone_example_8, t0.is_active AS is_active_9, t0.zone_economique_id AS zone_economique_id_10 FROM pays t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.indicatif AS indicatif_4,
  t0.flag AS flag_5,
  t0.phone_length AS phone_length_6,
  t0.phone_regex AS phone_regex_7,
  t0.phone_example AS phone_example_8,
  t0.is_active AS is_active_9,
  t0.zone_economique_id AS zone_economique_id_10
FROM
  pays t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.indicatif AS indicatif_4, t0.flag AS flag_5, t0.phone_length AS phone_length_6, t0.phone_regex AS phone_regex_7, t0.phone_example AS phone_example_8, t0.is_active AS is_active_9, t0.zone_economique_id AS zone_economique_id_10 FROM pays t0 WHERE t0.id = 2;

#	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\Pays::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Pays->__get (line 85)
8	App\Entity\Pays->getNom (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 784)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 170)
16	Symfony\Component\Serializer\Serializer->normalize (line 170)
17	Symfony\Component\Serializer\Serializer->normalize (line 170)
18	Symfony\Component\Serializer\Serializer->normalize (line 131)
19	Symfony\Component\Serializer\Serializer->serialize (line 44)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 1015)
22	App\Controller\Api\CollaborationApiController->getAllCollaborationsByUser (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.34 ms
(8.63%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.libelle AS libelle_3, t0.logo AS logo_4, t0.telephone AS telephone_5, t0.email AS email_6, t0.dgi_token AS dgi_token_7, t0.site_web AS site_web_8, t0.slogan AS slogan_9, t0.gps AS gps_10, t0.address AS address_11, t0.code AS code_12, t0.livrado AS livrado_13, t0.businesspay AS businesspay_14, t0.bpay_account AS bpay_account_15, t0.businesspay_account AS businesspay_account_16, t0.cashline_account AS cashline_account_17, t0.careconcept_account AS careconcept_account_18, t0.instantmark_account AS instantmark_account_19, t0.pays_id AS pays_id_20, t0.entreprise_id AS entreprise_id_21, t0.secteur_activite_id AS secteur_activite_id_22, t0.pack_id AS pack_id_23, t0.mode_integration_id AS mode_integration_id_24 FROM enseigne t0 WHERE t0.id = ?

Parameters:

[
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.libelle AS libelle_3,
  t0.logo AS logo_4,
  t0.telephone AS telephone_5,
  t0.email AS email_6,
  t0.dgi_token AS dgi_token_7,
  t0.site_web AS site_web_8,
  t0.slogan AS slogan_9,
  t0.gps AS gps_10,
  t0.address AS address_11,
  t0.code AS code_12,
  t0.livrado AS livrado_13,
  t0.businesspay AS businesspay_14,
  t0.bpay_account AS bpay_account_15,
  t0.businesspay_account AS businesspay_account_16,
  t0.cashline_account AS cashline_account_17,
  t0.careconcept_account AS careconcept_account_18,
  t0.instantmark_account AS instantmark_account_19,
  t0.pays_id AS pays_id_20,
  t0.entreprise_id AS entreprise_id_21,
  t0.secteur_activite_id AS secteur_activite_id_22,
  t0.pack_id AS pack_id_23,
  t0.mode_integration_id AS mode_integration_id_24
FROM
  enseigne t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.libelle AS libelle_3, t0.logo AS logo_4, t0.telephone AS telephone_5, t0.email AS email_6, t0.dgi_token AS dgi_token_7, t0.site_web AS site_web_8, t0.slogan AS slogan_9, t0.gps AS gps_10, t0.address AS address_11, t0.code AS code_12, t0.livrado AS livrado_13, t0.businesspay AS businesspay_14, t0.bpay_account AS bpay_account_15, t0.businesspay_account AS businesspay_account_16, t0.cashline_account AS cashline_account_17, t0.careconcept_account AS careconcept_account_18, t0.instantmark_account AS instantmark_account_19, t0.pays_id AS pays_id_20, t0.entreprise_id AS entreprise_id_21, t0.secteur_activite_id AS secteur_activite_id_22, t0.pack_id AS pack_id_23, t0.mode_integration_id AS mode_integration_id_24 FROM enseigne t0 WHERE t0.id = 20;

#	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\Enseigne::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Enseigne->__get (line 164)
8	App\Entity\Enseigne->getNom (line 988)
9	App\Controller\Api\CollaborationApiController->App\Controller\Api\{closure} (line 1)
10	array_map (line 977)
11	App\Controller\Api\CollaborationApiController->getAllCollaborationsByUser (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.32 ms
(8.17%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.ifu AS ifu_9, t0.rccm AS rccm_10, t0.dgi_token AS dgi_token_11, t0.bpay_account AS bpay_account_12, t0.careconcept_account AS careconcept_account_13, t0.businesspay_account AS businesspay_account_14, t0.cashline_account AS cashline_account_15, t0.instantmark_account AS instantmark_account_16, t0.user_id AS user_id_17, t0.pays_id AS pays_id_18 FROM entreprise t0 WHERE t0.pays_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.logo AS logo_3,
  t0.telephone AS telephone_4,
  t0.email AS email_5,
  t0.site_web AS site_web_6,
  t0.gps AS gps_7,
  t0.address AS address_8,
  t0.ifu AS ifu_9,
  t0.rccm AS rccm_10,
  t0.dgi_token AS dgi_token_11,
  t0.bpay_account AS bpay_account_12,
  t0.careconcept_account AS careconcept_account_13,
  t0.businesspay_account AS businesspay_account_14,
  t0.cashline_account AS cashline_account_15,
  t0.instantmark_account AS instantmark_account_16,
  t0.user_id AS user_id_17,
  t0.pays_id AS pays_id_18
FROM
  entreprise t0
WHERE
  t0.pays_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.ifu AS ifu_9, t0.rccm AS rccm_10, t0.dgi_token AS dgi_token_11, t0.bpay_account AS bpay_account_12, t0.careconcept_account AS careconcept_account_13, t0.businesspay_account AS businesspay_account_14, t0.cashline_account AS cashline_account_15, t0.instantmark_account AS instantmark_account_16, t0.user_id AS user_id_17, t0.pays_id AS pays_id_18 FROM entreprise t0 WHERE t0.pays_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 797)
8	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeCollectionOfRelations (line 695)
9	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
10	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
11	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
13	Symfony\Component\Serializer\Serializer->normalize (line 170)
14	Symfony\Component\Serializer\Serializer->normalize (line 170)
15	Symfony\Component\Serializer\Serializer->normalize (line 170)
16	Symfony\Component\Serializer\Serializer->normalize (line 131)
17	Symfony\Component\Serializer\Serializer->serialize (line 44)
18	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 1015)
20	App\Controller\Api\CollaborationApiController->getAllCollaborationsByUser (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.32 ms
(8.07%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.ifu AS ifu_9, t0.rccm AS rccm_10, t0.dgi_token AS dgi_token_11, t0.bpay_account AS bpay_account_12, t0.careconcept_account AS careconcept_account_13, t0.businesspay_account AS businesspay_account_14, t0.cashline_account AS cashline_account_15, t0.instantmark_account AS instantmark_account_16, t0.user_id AS user_id_17, t0.pays_id AS pays_id_18 FROM entreprise t0 WHERE t0.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.logo AS logo_3,
  t0.telephone AS telephone_4,
  t0.email AS email_5,
  t0.site_web AS site_web_6,
  t0.gps AS gps_7,
  t0.address AS address_8,
  t0.ifu AS ifu_9,
  t0.rccm AS rccm_10,
  t0.dgi_token AS dgi_token_11,
  t0.bpay_account AS bpay_account_12,
  t0.careconcept_account AS careconcept_account_13,
  t0.businesspay_account AS businesspay_account_14,
  t0.cashline_account AS cashline_account_15,
  t0.instantmark_account AS instantmark_account_16,
  t0.user_id AS user_id_17,
  t0.pays_id AS pays_id_18
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.logo AS logo_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.gps AS gps_7, t0.address AS address_8, t0.ifu AS ifu_9, t0.rccm AS rccm_10, t0.dgi_token AS dgi_token_11, t0.bpay_account AS bpay_account_12, t0.careconcept_account AS careconcept_account_13, t0.businesspay_account AS businesspay_account_14, t0.cashline_account AS cashline_account_15, t0.instantmark_account AS instantmark_account_16, t0.user_id AS user_id_17, t0.pays_id AS pays_id_18 FROM entreprise t0 WHERE t0.id = 16;

#	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\Entreprise::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Entreprise->__get (line 138)
8	App\Entity\Entreprise->getLibelle (line 1000)
9	App\Controller\Api\CollaborationApiController->App\Controller\Api\{closure} (line 1)
10	array_map (line 977)
11	App\Controller\Api\CollaborationApiController->getAllCollaborationsByUser (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.22 ms
(5.56%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4 FROM mode_integration t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.description AS description_4
FROM
  mode_integration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4 FROM mode_integration t0 WHERE t0.id = 2;

#	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\ModeIntegration::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\ModeIntegration->__get (line 36)
8	App\Entity\ModeIntegration->getCode (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 784)
11	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
12	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
13	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->normalize (line 170)
16	Symfony\Component\Serializer\Serializer->normalize (line 170)
17	Symfony\Component\Serializer\Serializer->normalize (line 170)
18	Symfony\Component\Serializer\Serializer->normalize (line 131)
19	Symfony\Component\Serializer\Serializer->serialize (line 44)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 1015)
22	App\Controller\Api\CollaborationApiController->getAllCollaborationsByUser (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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\Entreprise	7
App\Entity\Users	6
App\Entity\Collaboration	2
App\Entity\Plateforme	2
App\Entity\Enseigne	1
App\Entity\Pays	1
App\Entity\SecteurActivite	1
App\Entity\Pack	1
App\Entity\ModeIntegration	1
App\Entity\ZoneEconomique	1

Entities Mapping

Class	Mapping errors
App\Entity\Users	No errors.
App\Entity\Entreprise	No errors.
App\Entity\Role	No errors.
App\Entity\Collaboration	No errors.
App\Entity\Enseigne	The field App\Entity\Enseigne#packAbonnements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PackAbonnement#enseigne does not contain the required 'inversedBy="packAbonnements"' attribute.
App\Entity\Plateforme	No errors.
App\Entity\Pays	No errors.
App\Entity\SecteurActivite	The association App\Entity\SecteurActivite#entreprises refers to the owning side field App\Entity\Entreprise#secteurActivite which does not exist.
App\Entity\Pack	No errors.
App\Entity\ModeIntegration	No errors.
App\Entity\PackAbonnement	No errors.
App\Entity\ZoneEconomique	No errors.

Symfony Profiler

GET https://business-n2a.myn2a.online/api/user/31/collaborations/all

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping