Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

76.82 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

61.86 ms
(80.53%)

SELECT p0_.id AS id_0, p0_.filename AS filename_1, p0_.external_url AS external_url_2, p0_.caption AS caption_3, p0_.camping_id AS camping_id_4, p0_.accommodation_id AS accommodation_id_5, p0_.charge_point_id AS charge_point_id_6, p0_.activity_id AS activity_id_7, p0_.service_id AS service_id_8, p0_.swimming_pool_id AS swimming_pool_id_9 FROM photo p0_ LEFT JOIN camping c1_ ON p0_.camping_id = c1_.id LEFT JOIN accommodation a2_ ON p0_.accommodation_id = a2_.id LEFT JOIN charge_point c3_ ON p0_.charge_point_id = c3_.id LEFT JOIN camping c4_ ON a2_.camping_id = c4_.id LEFT JOIN camping c5_ ON c3_.camping_id = c5_.id WHERE p0_.camping_id = ? OR c4_.id = ? OR c5_.id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.filename AS filename_1,
  p0_.external_url AS external_url_2,
  p0_.caption AS caption_3,
  p0_.camping_id AS camping_id_4,
  p0_.accommodation_id AS accommodation_id_5,
  p0_.charge_point_id AS charge_point_id_6,
  p0_.activity_id AS activity_id_7,
  p0_.service_id AS service_id_8,
  p0_.swimming_pool_id AS swimming_pool_id_9
FROM
  photo p0_
  LEFT JOIN camping c1_ ON p0_.camping_id = c1_.id
  LEFT JOIN accommodation a2_ ON p0_.accommodation_id = a2_.id
  LEFT JOIN charge_point c3_ ON p0_.charge_point_id = c3_.id
  LEFT JOIN camping c4_ ON a2_.camping_id = c4_.id
  LEFT JOIN camping c5_ ON c3_.camping_id = c5_.id
WHERE
  p0_.camping_id = ?
  OR c4_.id = ?
  OR c5_.id = ?

SELECT p0_.id AS id_0, p0_.filename AS filename_1, p0_.external_url AS external_url_2, p0_.caption AS caption_3, p0_.camping_id AS camping_id_4, p0_.accommodation_id AS accommodation_id_5, p0_.charge_point_id AS charge_point_id_6, p0_.activity_id AS activity_id_7, p0_.service_id AS service_id_8, p0_.swimming_pool_id AS swimming_pool_id_9 FROM photo p0_ LEFT JOIN camping c1_ ON p0_.camping_id = c1_.id LEFT JOIN accommodation a2_ ON p0_.accommodation_id = a2_.id LEFT JOIN charge_point c3_ ON p0_.charge_point_id = c3_.id LEFT JOIN camping c4_ ON a2_.camping_id = c4_.id LEFT JOIN camping c5_ ON c3_.camping_id = c5_.id WHERE p0_.camping_id = 1 OR c4_.id = 1 OR c5_.id = 1;

#	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 33)
7	App\Repository\PhotoRepository->findAllByCamping (line 218)
8	App\Controller\CampingEditorialController->App\Controller\{closure} (line 1)
9	array_map (line 215)
10	App\Controller\CampingEditorialController->campingsSelections (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

14.96 ms
(19.47%)

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.selected = ? AND t0.archived = ?

Parameters:

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.selected = ?
  AND t0.archived = ?

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.selected = 1 AND t0.archived = 0;

#	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 208)
5	App\Controller\CampingEditorialController->campingsSelections (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\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\Infrastructure\SwimmingPool	No errors.

Symfony Profiler

GET https://campingvedev.vigimilia.com/crm/api/campings-selections

Configuration Settings

Theme