Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

12.80 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.06 ms
(47.36%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Core\Service\ContactService->upsert (line 93)
5	App\Sejour\Controller\ApiController->getFicheTechnique (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

1.65 ms
(12.91%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.resume AS resume_4, t0.accroche AS accroche_5, t0.code_sejour AS code_sejour_6, t0.nb_jours AS nb_jours_7, t0.nb_nuits AS nb_nuits_8, t0.nb_jours_activite AS nb_jours_activite_9, t0.vignette AS vignette_10, t0.img_principale AS img_principale_11, t0.fiche_technique_pdf AS fiche_technique_pdf_12, t0.mise_en_avant AS mise_en_avant_13, t0.publie AS publie_14, t0.prix_default AS prix_default_15, t0.montant_acompte AS montant_acompte_16, t0.pourcentage_acompte AS pourcentage_acompte_17, t0.stock_default AS stock_default_18, t0.coord_depart AS coord_depart_19, t0.coord_arrivee AS coord_arrivee_20, t0.niveau_id AS niveau_id_21 FROM sejour__sejour t0 WHERE t0.id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.resume AS resume_4,
  t0.accroche AS accroche_5,
  t0.code_sejour AS code_sejour_6,
  t0.nb_jours AS nb_jours_7,
  t0.nb_nuits AS nb_nuits_8,
  t0.nb_jours_activite AS nb_jours_activite_9,
  t0.vignette AS vignette_10,
  t0.img_principale AS img_principale_11,
  t0.fiche_technique_pdf AS fiche_technique_pdf_12,
  t0.mise_en_avant AS mise_en_avant_13,
  t0.publie AS publie_14,
  t0.prix_default AS prix_default_15,
  t0.montant_acompte AS montant_acompte_16,
  t0.pourcentage_acompte AS pourcentage_acompte_17,
  t0.stock_default AS stock_default_18,
  t0.coord_depart AS coord_depart_19,
  t0.coord_arrivee AS coord_arrivee_20,
  t0.niveau_id AS niveau_id_21
FROM
  sejour__sejour t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.resume AS resume_4, t0.accroche AS accroche_5, t0.code_sejour AS code_sejour_6, t0.nb_jours AS nb_jours_7, t0.nb_nuits AS nb_nuits_8, t0.nb_jours_activite AS nb_jours_activite_9, t0.vignette AS vignette_10, t0.img_principale AS img_principale_11, t0.fiche_technique_pdf AS fiche_technique_pdf_12, t0.mise_en_avant AS mise_en_avant_13, t0.publie AS publie_14, t0.prix_default AS prix_default_15, t0.montant_acompte AS montant_acompte_16, t0.pourcentage_acompte AS pourcentage_acompte_17, t0.stock_default AS stock_default_18, t0.coord_depart AS coord_depart_19, t0.coord_arrivee AS coord_arrivee_20, t0.niveau_id AS niveau_id_21 FROM sejour__sejour t0 WHERE t0.id = 14;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Sejour\Controller\ApiController->getFicheTechnique (line 215)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.14 ms
(8.87%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.status AS status_6, t0.source AS source_7, t0.newsletter_consent AS newsletter_consent_8, t0.newsletter_consent_at AS newsletter_consent_at_9, t0.newsletter_consent_source AS newsletter_consent_source_10, t0.created_at AS created_at_11, t0.update_at AS update_at_12 FROM contact t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "gilles.trochard@wanadoo.fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.status AS status_6,
  t0.source AS source_7,
  t0.newsletter_consent AS newsletter_consent_8,
  t0.newsletter_consent_at AS newsletter_consent_at_9,
  t0.newsletter_consent_source AS newsletter_consent_source_10,
  t0.created_at AS created_at_11,
  t0.update_at AS update_at_12
FROM
  contact t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.status AS status_6, t0.source AS source_7, t0.newsletter_consent AS newsletter_consent_8, t0.newsletter_consent_at AS newsletter_consent_at_9, t0.newsletter_consent_source AS newsletter_consent_source_10, t0.created_at AS created_at_11, t0.update_at AS update_at_12 FROM contact t0 WHERE t0.email = 'gilles.trochard@wanadoo.fr' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Core\Service\ContactService->upsert (line 31)
5	App\Sejour\Controller\ApiController->getFicheTechnique (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

1.10 ms
(8.61%)

INSERT INTO evenement (type, data, source, ip, user_agent, occured_at, created_at, contact_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "Telechargement fiche technique"
  "{"sejour":{"id":14,"code":null,"titre":"LESBOS : Le spot ornitho en M\u00e9diteran\u00e9e"},"site":"https:\/\/yuhina.fr"}"
  "website"
  "86.202.25.120"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:149.0) Gecko/20100101 Firefox/149.0"
  "2026-04-17 12:24:06"
  "2026-04-17 12:24:06"
  3
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO evenement (
  type, data, source, ip, user_agent,
  occured_at, created_at, contact_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO evenement (type, data, source, ip, user_agent, occured_at, created_at, contact_id) VALUES ('Telechargement fiche technique', '{\"sejour\":{\"id\":14,\"code\":null,\"titre\":\"LESBOS : Le spot ornitho en M\\u00e9diteran\\u00e9e\"},\"site\":\"https:\\/\\/yuhina.fr\"}', 'website', '86.202.25.120', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:149.0) Gecko/20100101 Firefox/149.0', '2026-04-17 12:24:06', '2026-04-17 12:24:06', 3);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Core\Service\EvenementService->create (line 79)
7	App\Sejour\Controller\ApiController->getFicheTechnique (line 251)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.09 ms
(8.51%)

UPDATE contact SET phone = ?, nom = ?, prenom = ?, newsletter_consent_at = ?, update_at = ? WHERE id = ?

Parameters:

[
  "+33681354405"
  "GILLES TROCHARD"
  "GILLES"
  "2026-04-17 12:24:06"
  "2026-04-17 12:24:06"
  3
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  contact
SET
  phone = ?,
  nom = ?,
  prenom = ?,
  newsletter_consent_at = ?,
  update_at = ?
WHERE
  id = ?

UPDATE contact SET phone = '+33681354405', nom = 'GILLES TROCHARD', prenom = 'GILLES', newsletter_consent_at = '2026-04-17 12:24:06', update_at = '2026-04-17 12:24:06' WHERE id = 3;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Core\Service\ContactService->upsert (line 93)
7	App\Sejour\Controller\ApiController->getFicheTechnique (line 190)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.98 ms
(7.65%)

SELECT a0_.id AS id_0, a0_.data AS data_1, a0_.updated_at AS updated_at_2 FROM app_settings a0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.data AS data_1,
  a0_.updated_at AS updated_at_2
FROM
  app_settings a0_
LIMIT
  1

SELECT a0_.id AS id_0, a0_.data AS data_1, a0_.updated_at AS updated_at_2 FROM app_settings a0_ LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Core\Repository\AppSettingsRepository->getSingleton (line 18)
7	App\Core\Settings\Settings->App\Core\Settings\{closure} (line 92)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 111)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Core\Settings\Settings->all (line 90)
16	App\Core\Settings\Settings->get (line 22)
17	App\Sejour\Service\SejourMailService->send (line 23)
18	App\Sejour\Service\SejourMailService->sendFicheTechniqueRequest (line 84)
19	App\Sejour\Controller\ApiController->getFicheTechnique (line 271)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	require_once (line 5)

0.78 ms
(6.09%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Core\Service\ContactService->upsert (line 93)
4	App\Sejour\Controller\ApiController->getFicheTechnique (line 190)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Core\Entity\Contact	1
App\Sejour\Entity\Sejour	1
App\Core\Entity\Evenement	1
App\Core\Entity\AppSettings	1

Entities Mapping

Class	Mapping errors
App\Core\Entity\Contact	No errors.
App\Core\Entity\Evenement	No errors.
App\Sejour\Entity\Sejour	No errors.
App\Sejour\Entity\Niveau	No errors.
App\Sejour\Entity\Categorie	No errors.
App\Sejour\Entity\Activite	No errors.
App\Sejour\Entity\Destination	No errors.
App\Sejour\Entity\Media	No errors.
App\Sejour\Entity\Session	No errors.
App\Sejour\Entity\ChampValeur	No errors.
App\Core\Entity\AppSettings	No errors.

Symfony Profiler

POST https://deltavia.yuhina.fr/sejour/api/get-fiche-technique

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping