Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

14.91 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.91 ms
(100.00%)

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:

[
  94
]

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 = 94;

#	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 26)
7	App\Controller\CampingHebergementsController->campingHebergementsStructure (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)

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.

Symfony Profiler

GET https://campingvedev.vigimilia.com/crm/api/campings/94/hebergements-structure

Configuration Settings

Theme