Symfony Profiler

Query Metrics

21 Database Queries

7 Different statements

6.94 ms Query time

2 Invalid entities

46 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.01 ms
(28.92%)

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.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = ?

Parameters:

[
  15
]

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.description AS description_9,
  t0.ifu AS ifu_10,
  t0.rccm AS rccm_11,
  t0.dgi_token AS dgi_token_12,
  t0.bpay_account AS bpay_account_13,
  t0.careconcept_account AS careconcept_account_14,
  t0.businesspay_account AS businesspay_account_15,
  t0.cashline_account AS cashline_account_16,
  t0.instantmark_account AS instantmark_account_17,
  t0.user_id AS user_id_18,
  t0.pays_id AS pays_id_19
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.description AS description_9, t0.ifu AS ifu_10, t0.rccm AS rccm_11, t0.dgi_token AS dgi_token_12, t0.bpay_account AS bpay_account_13, t0.careconcept_account AS careconcept_account_14, t0.businesspay_account AS businesspay_account_15, t0.cashline_account AS cashline_account_16, t0.instantmark_account AS instantmark_account_17, t0.user_id AS user_id_18, t0.pays_id AS pays_id_19 FROM entreprise t0 WHERE t0.id = 15;

#	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::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Entreprise::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Entreprise->__get (line 148)
8	App\Entity\Entreprise->getLibelle (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 829)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 170)
22	Symfony\Component\Serializer\Serializer->normalize (line 131)
23	Symfony\Component\Serializer\Serializer->serialize (line 44)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 41)
26	App\Controller\Api\EnseignesApiController->getPublicEnseignes (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.21 ms
(17.46%)

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 INNER JOIN pack_plateformes ON t0.id = pack_plateformes.plateforme_id WHERE pack_plateformes.pack_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
  INNER JOIN pack_plateformes ON t0.id = pack_plateformes.plateforme_id
WHERE
  pack_plateformes.pack_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 INNER JOIN pack_plateformes ON t0.id = pack_plateformes.plateforme_id WHERE pack_plateformes.pack_id = 1;

#	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 257)
7	Doctrine\Common\Collections\AbstractLazyCollection->map (line 242)
8	App\Entity\Enseigne->getPlateformesNoms (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 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 41)
20	App\Controller\Api\EnseignesApiController->getPublicEnseignes (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.94 ms
(13.52%)

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

Parameters:

[]

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

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;

#	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 96)
5	Doctrine\ORM\EntityRepository->findAll (line 39)
6	App\Controller\Api\EnseignesApiController->getPublicEnseignes (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.76 ms
(11.02%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.logo AS logo_4, t0.banniere AS banniere_5, t0.description AS description_6, t0.prix AS prix_7, t0.updated_at AS updated_at_8, t0.frais_mise_en_service AS frais_mise_en_service_9, t0.mensualite AS mensualite_10, t0.frais_entretien_annuel AS frais_entretien_annuel_11 FROM pack 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.logo AS logo_4,
  t0.banniere AS banniere_5,
  t0.description AS description_6,
  t0.prix AS prix_7,
  t0.updated_at AS updated_at_8,
  t0.frais_mise_en_service AS frais_mise_en_service_9,
  t0.mensualite AS mensualite_10,
  t0.frais_entretien_annuel AS frais_entretien_annuel_11
FROM
  pack t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.logo AS logo_4, t0.banniere AS banniere_5, t0.description AS description_6, t0.prix AS prix_7, t0.updated_at AS updated_at_8, t0.frais_mise_en_service AS frais_mise_en_service_9, t0.mensualite AS mensualite_10, t0.frais_entretien_annuel AS frais_entretien_annuel_11 FROM pack 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::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Pack::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Pack->__get (line 90)
8	App\Entity\Pack->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 829)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 170)
22	Symfony\Component\Serializer\Serializer->normalize (line 131)
23	Symfony\Component\Serializer\Serializer->serialize (line 44)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 41)
26	App\Controller\Api\EnseignesApiController->getPublicEnseignes (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.71 ms
(10.20%)

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:

[
  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
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 = 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::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\ModeIntegration::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (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 829)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 170)
22	Symfony\Component\Serializer\Serializer->normalize (line 131)
23	Symfony\Component\Serializer\Serializer->serialize (line 44)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 41)
26	App\Controller\Api\EnseignesApiController->getPublicEnseignes (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.70 ms
(10.15%)

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM secteur_activite t0 WHERE t0.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.code AS code_3
FROM
  secteur_activite t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM secteur_activite 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::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\SecteurActivite::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\SecteurActivite->__get (line 46)
8	App\Entity\SecteurActivite->getLibelle (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 829)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 170)
22	Symfony\Component\Serializer\Serializer->normalize (line 131)
23	Symfony\Component\Serializer\Serializer->serialize (line 44)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 41)
26	App\Controller\Api\EnseignesApiController->getPublicEnseignes (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.61 ms
(8.73%)

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::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Pays::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (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 829)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalizeRelation (line 729)
17	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 197)
18	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 154)
19	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 50)
20	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 152)
21	Symfony\Component\Serializer\Serializer->normalize (line 170)
22	Symfony\Component\Serializer\Serializer->normalize (line 131)
23	Symfony\Component\Serializer\Serializer->serialize (line 44)
24	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 41)
26	App\Controller\Api\EnseignesApiController->getPublicEnseignes (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\Enseigne	16
App\Entity\Entreprise	7
App\Entity\Plateforme	7
App\Entity\Users	5
App\Entity\SecteurActivite	3
App\Entity\Pack	3
App\Entity\ModeIntegration	3
App\Entity\Pays	1
App\Entity\ZoneEconomique	1

Entities Mapping

Class	Mapping 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\Pays	No errors.
App\Entity\Entreprise	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.
App\Entity\Users	No errors.
App\Entity\Plateforme	No errors.

Symfony Profiler

GET https://business-n2a.myn2a.online/public/enseignes

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping