Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

66.38 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

14.72 ms

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.booking_engine AS booking_engine_3, t0.booking_engine_id AS booking_engine_id_4, t0.naturism AS naturism_5, t0.caravaneige AS caravaneige_6, t0.number_of_bare_pitches AS number_of_bare_pitches_7, t0.number_of_rentals AS number_of_rentals_8, t0.number_of_rooms AS number_of_rooms_9, t0.number_of_stars AS number_of_stars_10, t0.country AS country_11, t0.city AS city_12, t0.postal_code AS postal_code_13, t0.address AS address_14, t0.camping_phone AS camping_phone_15, t0.camping_email AS camping_email_16, t0.region AS region_17, t0.department AS department_18, t0.gps_latitude AS gps_latitude_19, t0.gps_longitude AS gps_longitude_20, t0.archived AS archived_21, t0.highlighted AS highlighted_22, t0.lightning_label AS lightning_label_23, t0.show_ad_banner AS show_ad_banner_24, t0.url_redirect AS url_redirect_25, t0.siret_number AS siret_number_26, t0.selected AS selected_27, t0.contact_id AS contact_id_28, t0.registration_id AS registration_id_29, t0.general_id AS general_id_30, t0.activity_id AS activity_id_31, t0.infrastructure_id AS infrastructure_id_32, t0.service_id AS service_id_33, t0.place_id AS place_id_34, t0.camping_group_id AS camping_group_id_35 FROM camping t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.booking_engine AS booking_engine_3,
  t0.booking_engine_id AS booking_engine_id_4,
  t0.naturism AS naturism_5,
  t0.caravaneige AS caravaneige_6,
  t0.number_of_bare_pitches AS number_of_bare_pitches_7,
  t0.number_of_rentals AS number_of_rentals_8,
  t0.number_of_rooms AS number_of_rooms_9,
  t0.number_of_stars AS number_of_stars_10,
  t0.country AS country_11,
  t0.city AS city_12,
  t0.postal_code AS postal_code_13,
  t0.address AS address_14,
  t0.camping_phone AS camping_phone_15,
  t0.camping_email AS camping_email_16,
  t0.region AS region_17,
  t0.department AS department_18,
  t0.gps_latitude AS gps_latitude_19,
  t0.gps_longitude AS gps_longitude_20,
  t0.archived AS archived_21,
  t0.highlighted AS highlighted_22,
  t0.lightning_label AS lightning_label_23,
  t0.show_ad_banner AS show_ad_banner_24,
  t0.url_redirect AS url_redirect_25,
  t0.siret_number AS siret_number_26,
  t0.selected AS selected_27,
  t0.contact_id AS contact_id_28,
  t0.registration_id AS registration_id_29,
  t0.general_id AS general_id_30,
  t0.activity_id AS activity_id_31,
  t0.infrastructure_id AS infrastructure_id_32,
  t0.service_id AS service_id_33,
  t0.place_id AS place_id_34,
  t0.camping_group_id AS camping_group_id_35
FROM
  camping t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.booking_engine AS booking_engine_3, t0.booking_engine_id AS booking_engine_id_4, t0.naturism AS naturism_5, t0.caravaneige AS caravaneige_6, t0.number_of_bare_pitches AS number_of_bare_pitches_7, t0.number_of_rentals AS number_of_rentals_8, t0.number_of_rooms AS number_of_rooms_9, t0.number_of_stars AS number_of_stars_10, t0.country AS country_11, t0.city AS city_12, t0.postal_code AS postal_code_13, t0.address AS address_14, t0.camping_phone AS camping_phone_15, t0.camping_email AS camping_email_16, t0.region AS region_17, t0.department AS department_18, t0.gps_latitude AS gps_latitude_19, t0.gps_longitude AS gps_longitude_20, t0.archived AS archived_21, t0.highlighted AS highlighted_22, t0.lightning_label AS lightning_label_23, t0.show_ad_banner AS show_ad_banner_24, t0.url_redirect AS url_redirect_25, t0.siret_number AS siret_number_26, t0.selected AS selected_27, t0.contact_id AS contact_id_28, t0.registration_id AS registration_id_29, t0.general_id AS general_id_30, t0.activity_id AS activity_id_31, t0.infrastructure_id AS infrastructure_id_32, t0.service_id AS service_id_33, t0.place_id AS place_id_34, t0.camping_group_id AS camping_group_id_35 FROM camping t0 WHERE t0.id = 3;

#	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 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 298)
7	App\Controller\CampingTabsController->campingGeneralInfo (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

14.53 ms

SELECT t0.id AS id_1, t0.reception_info_id AS reception_info_id_2, t0.post_reservation_info_id AS post_reservation_info_id_3, t0.payment_information_id AS payment_information_id_4 FROM camping_general t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reception_info_id AS reception_info_id_2,
  t0.post_reservation_info_id AS post_reservation_info_id_3,
  t0.payment_information_id AS payment_information_id_4
FROM
  camping_general t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reception_info_id AS reception_info_id_2, t0.post_reservation_info_id AS post_reservation_info_id_3, t0.payment_information_id AS payment_information_id_4 FROM camping_general t0 WHERE t0.id = 3;

#	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\Camping\General\CampingGeneral::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Camping\General\CampingGeneral->__get (line 76)
8	App\Entity\Camping\General\CampingGeneral->getPostReservationInfo (line 308)
9	App\Controller\CampingTabsController->campingGeneralInfo (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)

15.38 ms

SELECT t0.id AS id_1, t0.rental_check_in_start AS rental_check_in_start_2, t0.rental_check_in_end AS rental_check_in_end_3, t0.pitch_check_in_start AS pitch_check_in_start_4, t0.pitch_check_in_end AS pitch_check_in_end_5, t0.room_check_in_start AS room_check_in_start_6, t0.room_check_in_end AS room_check_in_end_7, t0.check_in_at_reception AS check_in_at_reception_8, t0.alternative_check_in_location AS alternative_check_in_location_9, t0.late_check_in_limit AS late_check_in_limit_10, t0.gate_closing_time AS gate_closing_time_11, t0.swim_shorts_not_allowed AS swim_shorts_not_allowed_12, t0.pool_access_with_bracelet AS pool_access_with_bracelet_13, t0.access_advice AS access_advice_14, t0.deposit_id AS deposit_id_15 FROM post_reservation_info t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.rental_check_in_start AS rental_check_in_start_2,
  t0.rental_check_in_end AS rental_check_in_end_3,
  t0.pitch_check_in_start AS pitch_check_in_start_4,
  t0.pitch_check_in_end AS pitch_check_in_end_5,
  t0.room_check_in_start AS room_check_in_start_6,
  t0.room_check_in_end AS room_check_in_end_7,
  t0.check_in_at_reception AS check_in_at_reception_8,
  t0.alternative_check_in_location AS alternative_check_in_location_9,
  t0.late_check_in_limit AS late_check_in_limit_10,
  t0.gate_closing_time AS gate_closing_time_11,
  t0.swim_shorts_not_allowed AS swim_shorts_not_allowed_12,
  t0.pool_access_with_bracelet AS pool_access_with_bracelet_13,
  t0.access_advice AS access_advice_14,
  t0.deposit_id AS deposit_id_15
FROM
  post_reservation_info t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.rental_check_in_start AS rental_check_in_start_2, t0.rental_check_in_end AS rental_check_in_end_3, t0.pitch_check_in_start AS pitch_check_in_start_4, t0.pitch_check_in_end AS pitch_check_in_end_5, t0.room_check_in_start AS room_check_in_start_6, t0.room_check_in_end AS room_check_in_end_7, t0.check_in_at_reception AS check_in_at_reception_8, t0.alternative_check_in_location AS alternative_check_in_location_9, t0.late_check_in_limit AS late_check_in_limit_10, t0.gate_closing_time AS gate_closing_time_11, t0.swim_shorts_not_allowed AS swim_shorts_not_allowed_12, t0.pool_access_with_bracelet AS pool_access_with_bracelet_13, t0.access_advice AS access_advice_14, t0.deposit_id AS deposit_id_15 FROM post_reservation_info t0 WHERE t0.id = 3;

#	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\Camping\General\PostReservationInfo::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Camping\General\PostReservationInfo->__get (line 257)
8	App\Entity\Camping\General\PostReservationInfo->getReceptionHours (line 321)
9	App\Controller\CampingTabsController->campingGeneralInfo (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)

21.76 ms

SELECT t0.id AS id_1, t0.season AS season_2, t0.morning_open AS morning_open_3, t0.morning_close AS morning_close_4, t0.afternoon_open AS afternoon_open_5, t0.afternoon_close AS afternoon_close_6, t0.general_id AS general_id_7, t0.post_reservation_info_id AS post_reservation_info_id_8 FROM reception_hours t0 WHERE t0.post_reservation_info_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.season AS season_2,
  t0.morning_open AS morning_open_3,
  t0.morning_close AS morning_close_4,
  t0.afternoon_open AS afternoon_open_5,
  t0.afternoon_close AS afternoon_close_6,
  t0.general_id AS general_id_7,
  t0.post_reservation_info_id AS post_reservation_info_id_8
FROM
  reception_hours t0
WHERE
  t0.post_reservation_info_id = ?

SELECT t0.id AS id_1, t0.season AS season_2, t0.morning_open AS morning_open_3, t0.morning_close AS morning_close_4, t0.afternoon_open AS afternoon_open_5, t0.afternoon_close AS afternoon_close_6, t0.general_id AS general_id_7, t0.post_reservation_info_id AS post_reservation_info_id_8 FROM reception_hours t0 WHERE t0.post_reservation_info_id = 3;

#	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 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 321)
8	App\Controller\CampingTabsController->campingGeneralInfo (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)

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\Camping	No errors.
App\Entity\Contact	No errors.
App\Entity\Registration	No errors.
App\Entity\Camping\General\CampingGeneral	No errors.
App\Entity\Camping\Activity\Activity	No errors.
App\Entity\Camping\Infrastructure\Infrastructure	No errors.
App\Entity\Camping\Service\Service	No errors.
App\Entity\Camping\Situation\Place	No errors.
App\Entity\Group	No errors.
App\Entity\Accommodation	No errors.
App\Entity\ChargePoint	No errors.
App\Entity\Photo	No errors.
App\Entity\Review	No errors.
App\Entity\Description	No errors.
App\Entity\Camping\Situation\ThematicSegmentation	No errors.
App\Entity\Camping\General\ReceptionInfo	No errors.
App\Entity\Camping\General\PostReservationInfo	No errors.
App\Entity\Camping\General\PaymentInformation	No errors.
App\Entity\Camping\General\Guide	No errors.
App\Entity\Camping\General\Label	No errors.
App\Entity\Camping\General\ReceptionHours	No errors.
App\Entity\Camping\General\Deposit	No errors.
App\Entity\Camping\General\PostReservationTax	No errors.
App\Entity\Camping\General\PostReservationOption	No errors.
App\Entity\Camping\General\PostReservationCharge	No errors.

Symfony Profiler

GET https://campingvedev.vigimilia.com/crm/api/campings/3/general-info

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping