Symfony Profiler

Query Metrics

353 Database Queries

8 Different statements

134.94 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

121.54 ms
(90.07%)

344

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.tel_number AS tel_number_5, t0.confirmation_email AS confirmation_email_6, t0.information_email AS information_email_7, t0.created_at AS created_at_8, t0.clear_data AS clear_data_9, t0.reservation_id AS reservation_id_10 FROM customer_account t0 WHERE t0.reservation_id = ?

Parameters:

[
  344
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.tel_number AS tel_number_5,
  t0.confirmation_email AS confirmation_email_6,
  t0.information_email AS information_email_7,
  t0.created_at AS created_at_8,
  t0.clear_data AS clear_data_9,
  t0.reservation_id AS reservation_id_10
FROM
  customer_account t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.tel_number AS tel_number_5, t0.confirmation_email AS confirmation_email_6, t0.information_email AS information_email_7, t0.created_at AS created_at_8, t0.clear_data AS clear_data_9, t0.reservation_id AS reservation_id_10 FROM customer_account t0 WHERE t0.reservation_id = 344;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2441)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 35)
12	App\Repository\ReservationRepository->findFutureReservations (line 109)
13	App\Service\CalendarAirbnb->saveInDatabase (line 81)
14	App\Controller\Gite\Cocuere\CocuereController->booking (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

5.42 ms
(4.02%)

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.dtstart AS dtstart_2, r0_.dtend AS dtend_3, r0_.reservation_url AS reservation_url_4, r0_.phone_number AS phone_number_5, r0_.summary AS summary_6, r0_.nbr_adults AS nbr_adults_7, r0_.nbr_children AS nbr_children_8, r0_.nbr_animals AS nbr_animals_9, r0_.dtreservation AS dtreservation_10, r0_.gain AS gain_11, r0_.service_fees AS service_fees_12, r0_.period AS period_13, r0_.cancellation_condition AS cancellation_condition_14, r0_.treated AS treated_15, r0_.platform AS platform_16, r0_.status AS status_17, r0_.comment AS comment_18, r0_.nbr_baby AS nbr_baby_19, r0_.gite_id AS gite_id_20 FROM reservation r0_ WHERE r0_.dtstart >= ? ORDER BY r0_.id ASC

Parameters:

[
  "2025-07-11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.uid AS uid_1,
  r0_.dtstart AS dtstart_2,
  r0_.dtend AS dtend_3,
  r0_.reservation_url AS reservation_url_4,
  r0_.phone_number AS phone_number_5,
  r0_.summary AS summary_6,
  r0_.nbr_adults AS nbr_adults_7,
  r0_.nbr_children AS nbr_children_8,
  r0_.nbr_animals AS nbr_animals_9,
  r0_.dtreservation AS dtreservation_10,
  r0_.gain AS gain_11,
  r0_.service_fees AS service_fees_12,
  r0_.period AS period_13,
  r0_.cancellation_condition AS cancellation_condition_14,
  r0_.treated AS treated_15,
  r0_.platform AS platform_16,
  r0_.status AS status_17,
  r0_.comment AS comment_18,
  r0_.nbr_baby AS nbr_baby_19,
  r0_.gite_id AS gite_id_20
FROM
  reservation r0_
WHERE
  r0_.dtstart >= ?
ORDER BY
  r0_.id ASC

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.dtstart AS dtstart_2, r0_.dtend AS dtend_3, r0_.reservation_url AS reservation_url_4, r0_.phone_number AS phone_number_5, r0_.summary AS summary_6, r0_.nbr_adults AS nbr_adults_7, r0_.nbr_children AS nbr_children_8, r0_.nbr_animals AS nbr_animals_9, r0_.dtreservation AS dtreservation_10, r0_.gain AS gain_11, r0_.service_fees AS service_fees_12, r0_.period AS period_13, r0_.cancellation_condition AS cancellation_condition_14, r0_.treated AS treated_15, r0_.platform AS platform_16, r0_.status AS status_17, r0_.comment AS comment_18, r0_.nbr_baby AS nbr_baby_19, r0_.gite_id AS gite_id_20 FROM reservation r0_ WHERE r0_.dtstart >= '2025-07-11' ORDER BY r0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\ReservationRepository->findFutureReservations (line 109)
8	App\Service\CalendarAirbnb->saveInDatabase (line 81)
9	App\Controller\Gite\Cocuere\CocuereController->booking (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

3.64 ms
(2.70%)

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.dtstart AS dtstart_2, r0_.dtend AS dtend_3, r0_.reservation_url AS reservation_url_4, r0_.phone_number AS phone_number_5, r0_.summary AS summary_6, r0_.nbr_adults AS nbr_adults_7, r0_.nbr_children AS nbr_children_8, r0_.nbr_animals AS nbr_animals_9, r0_.dtreservation AS dtreservation_10, r0_.gain AS gain_11, r0_.service_fees AS service_fees_12, r0_.period AS period_13, r0_.cancellation_condition AS cancellation_condition_14, r0_.treated AS treated_15, r0_.platform AS platform_16, r0_.status AS status_17, r0_.comment AS comment_18, r0_.nbr_baby AS nbr_baby_19, r0_.gite_id AS gite_id_20 FROM reservation r0_ WHERE r0_.dtend <= ? AND r0_.summary = ? ORDER BY r0_.dtstart DESC

Parameters:

[
  "2025-07-14 01:26:03"
  "Reserved"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.uid AS uid_1,
  r0_.dtstart AS dtstart_2,
  r0_.dtend AS dtend_3,
  r0_.reservation_url AS reservation_url_4,
  r0_.phone_number AS phone_number_5,
  r0_.summary AS summary_6,
  r0_.nbr_adults AS nbr_adults_7,
  r0_.nbr_children AS nbr_children_8,
  r0_.nbr_animals AS nbr_animals_9,
  r0_.dtreservation AS dtreservation_10,
  r0_.gain AS gain_11,
  r0_.service_fees AS service_fees_12,
  r0_.period AS period_13,
  r0_.cancellation_condition AS cancellation_condition_14,
  r0_.treated AS treated_15,
  r0_.platform AS platform_16,
  r0_.status AS status_17,
  r0_.comment AS comment_18,
  r0_.nbr_baby AS nbr_baby_19,
  r0_.gite_id AS gite_id_20
FROM
  reservation r0_
WHERE
  r0_.dtend <= ?
  AND r0_.summary = ?
ORDER BY
  r0_.dtstart DESC

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.dtstart AS dtstart_2, r0_.dtend AS dtend_3, r0_.reservation_url AS reservation_url_4, r0_.phone_number AS phone_number_5, r0_.summary AS summary_6, r0_.nbr_adults AS nbr_adults_7, r0_.nbr_children AS nbr_children_8, r0_.nbr_animals AS nbr_animals_9, r0_.dtreservation AS dtreservation_10, r0_.gain AS gain_11, r0_.service_fees AS service_fees_12, r0_.period AS period_13, r0_.cancellation_condition AS cancellation_condition_14, r0_.treated AS treated_15, r0_.platform AS platform_16, r0_.status AS status_17, r0_.comment AS comment_18, r0_.nbr_baby AS nbr_baby_19, r0_.gite_id AS gite_id_20 FROM reservation r0_ WHERE r0_.dtend <= '2025-07-14 01:26:03' AND r0_.summary = 'Reserved' ORDER BY r0_.dtstart DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 51)
7	App\Repository\ReservationRepository->findPastReservations (line 204)
8	App\Service\CalendarAirbnb->saveInDatabase (line 81)
9	App\Controller\Gite\Cocuere\CocuereController->booking (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.44 ms
(1.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.on_line AS on_line_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.short_description AS short_description_7, t0.picture AS picture_8, t0.key_code AS key_code_9, t0.arrival_time AS arrival_time_10, t0.departure_time AS departure_time_11, t0.user_id AS user_id_12 FROM gite t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "La Cocuère"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.on_line AS on_line_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.short_description AS short_description_7,
  t0.picture AS picture_8,
  t0.key_code AS key_code_9,
  t0.arrival_time AS arrival_time_10,
  t0.departure_time AS departure_time_11,
  t0.user_id AS user_id_12
FROM
  gite t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.on_line AS on_line_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.short_description AS short_description_7, t0.picture AS picture_8, t0.key_code AS key_code_9, t0.arrival_time AS arrival_time_10, t0.departure_time AS departure_time_11, t0.user_id AS user_id_12 FROM gite t0 WHERE t0.name = 'La Cocuère' 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 83)
5	App\Controller\Gite\Cocuere\CocuereController->booking (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)

1.25 ms
(0.93%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 224)
5	App\Service\CalendarAirbnb->saveInDatabase (line 81)
6	App\Controller\Gite\Cocuere\CocuereController->booking (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.82 ms
(0.61%)

UPDATE reservation SET status = ? WHERE id = ?

Parameters:

[
  "closed"
  472
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  reservation
SET
  status = ?
WHERE
  id = ?

UPDATE reservation SET status = 'closed' WHERE id = 472;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 224)
7	App\Service\CalendarAirbnb->saveInDatabase (line 81)
8	App\Controller\Gite\Cocuere\CocuereController->booking (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.55 ms
(0.41%)

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.dtstart AS dtstart_2, r0_.dtend AS dtend_3, r0_.reservation_url AS reservation_url_4, r0_.phone_number AS phone_number_5, r0_.summary AS summary_6, r0_.nbr_adults AS nbr_adults_7, r0_.nbr_children AS nbr_children_8, r0_.nbr_animals AS nbr_animals_9, r0_.dtreservation AS dtreservation_10, r0_.gain AS gain_11, r0_.service_fees AS service_fees_12, r0_.period AS period_13, r0_.cancellation_condition AS cancellation_condition_14, r0_.treated AS treated_15, r0_.platform AS platform_16, r0_.status AS status_17, r0_.comment AS comment_18, r0_.nbr_baby AS nbr_baby_19, r0_.gite_id AS gite_id_20 FROM reservation r0_ WHERE r0_.dtstart <= ? AND r0_.dtend >= ? AND r0_.summary = ?

Parameters:

[
  "2025-07-14 01:26:03"
  "2025-07-14 01:26:03"
  "Reserved"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.uid AS uid_1,
  r0_.dtstart AS dtstart_2,
  r0_.dtend AS dtend_3,
  r0_.reservation_url AS reservation_url_4,
  r0_.phone_number AS phone_number_5,
  r0_.summary AS summary_6,
  r0_.nbr_adults AS nbr_adults_7,
  r0_.nbr_children AS nbr_children_8,
  r0_.nbr_animals AS nbr_animals_9,
  r0_.dtreservation AS dtreservation_10,
  r0_.gain AS gain_11,
  r0_.service_fees AS service_fees_12,
  r0_.period AS period_13,
  r0_.cancellation_condition AS cancellation_condition_14,
  r0_.treated AS treated_15,
  r0_.platform AS platform_16,
  r0_.status AS status_17,
  r0_.comment AS comment_18,
  r0_.nbr_baby AS nbr_baby_19,
  r0_.gite_id AS gite_id_20
FROM
  reservation r0_
WHERE
  r0_.dtstart <= ?
  AND r0_.dtend >= ?
  AND r0_.summary = ?

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.dtstart AS dtstart_2, r0_.dtend AS dtend_3, r0_.reservation_url AS reservation_url_4, r0_.phone_number AS phone_number_5, r0_.summary AS summary_6, r0_.nbr_adults AS nbr_adults_7, r0_.nbr_children AS nbr_children_8, r0_.nbr_animals AS nbr_animals_9, r0_.dtreservation AS dtreservation_10, r0_.gain AS gain_11, r0_.service_fees AS service_fees_12, r0_.period AS period_13, r0_.cancellation_condition AS cancellation_condition_14, r0_.treated AS treated_15, r0_.platform AS platform_16, r0_.status AS status_17, r0_.comment AS comment_18, r0_.nbr_baby AS nbr_baby_19, r0_.gite_id AS gite_id_20 FROM reservation r0_ WHERE r0_.dtstart <= '2025-07-14 01:26:03' AND r0_.dtend >= '2025-07-14 01:26:03' AND r0_.summary = 'Reserved';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 66)
7	App\Repository\ReservationRepository->findCurrentStay (line 218)
8	App\Service\CalendarAirbnb->saveInDatabase (line 81)
9	App\Controller\Gite\Cocuere\CocuereController->booking (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.27 ms
(0.20%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 224)
4	App\Service\CalendarAirbnb->saveInDatabase (line 81)
5	App\Controller\Gite\Cocuere\CocuereController->booking (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\Reservation	No errors.
App\Entity\Gite	No errors.
App\Entity\Transactions	No errors.
App\Entity\CustomerAccount	No errors.
App\Entity\User	No errors.
App\Entity\Room	No errors.
App\Entity\PricingRule	No errors.
App\Entity\Booking	No errors.

Symfony Profiler

GET http://www.chezbandjo.fr/booking

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping