Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.34 ms Query time

0 Invalid entities

12 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.88 ms

SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.booking_type AS booking_type_3, s0_.status AS status_4, s0_.currency AS currency_5, s0_.short_description AS short_description_6, s0_.duration_minutes AS duration_minutes_7, s0_.place_label AS place_label_8, s0_.duration_label AS duration_label_9, s0_.badge AS badge_10, s0_.search_text AS search_text_11, s0_.search_place AS search_place_12, s0_.position AS position_13, s0_.rating_average AS rating_average_14, s0_.reviews_count AS reviews_count_15, s0_.capacity AS capacity_16, s0_.level AS level_17, s0_.languages AS languages_18, s0_.included AS included_19, s0_.subtitle AS subtitle_20, s0_.activity_type AS activity_type_21, s0_.minimum_age AS minimum_age_22, s0_.programme AS programme_23, s0_.meeting_point AS meeting_point_24, s0_.opening_period AS opening_period_25, s0_.audience AS audience_26, s0_.cancellation_policy AS cancellation_policy_27, s0_.address AS address_28, s0_.city AS city_29, s0_.postal_code AS postal_code_30, s0_.country AS country_31, s0_.latitude AS latitude_32, s0_.longitude AS longitude_33, s0_.id AS id_34, s0_.created_at AS created_at_35, s0_.updated_at AS updated_at_36, s0_.deleted_at AS deleted_at_37, c1_.name AS name_38, c1_.slug AS slug_39, c1_.position AS position_40, c1_.id AS id_41, c1_.created_at AS created_at_42, c1_.updated_at AS updated_at_43, s2_.name AS name_44, s2_.description AS description_45, s2_.price AS price_46, s2_.currency AS currency_47, s2_.pricing_unit AS pricing_unit_48, s2_.delivery_days AS delivery_days_49, s2_.id AS id_50, s2_.created_at AS created_at_51, s2_.updated_at AS updated_at_52, m3_.path AS path_53, m3_.type AS type_54, m3_.position AS position_55, m3_.id AS id_56, m3_.created_at AS created_at_57, m3_.updated_at AS updated_at_58, s0_.provider_id AS provider_id_59, s0_.category_id AS category_id_60, s0_.destination_id AS destination_id_61, c1_.parent_id AS parent_id_62, s2_.service_id AS service_id_63, m3_.service_id AS service_id_64 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id LEFT JOIN service_package s2_ ON s0_.id = s2_.service_id LEFT JOIN media m3_ ON s0_.id = m3_.service_id WHERE s0_.status = ? AND s0_.deleted_at IS NULL ORDER BY s0_.position ASC, s0_.created_at ASC

Parameters:

[
  "published"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.title AS title_0,
  s0_.slug AS slug_1,
  s0_.description AS description_2,
  s0_.booking_type AS booking_type_3,
  s0_.status AS status_4,
  s0_.currency AS currency_5,
  s0_.short_description AS short_description_6,
  s0_.duration_minutes AS duration_minutes_7,
  s0_.place_label AS place_label_8,
  s0_.duration_label AS duration_label_9,
  s0_.badge AS badge_10,
  s0_.search_text AS search_text_11,
  s0_.search_place AS search_place_12,
  s0_.position AS position_13,
  s0_.rating_average AS rating_average_14,
  s0_.reviews_count AS reviews_count_15,
  s0_.capacity AS capacity_16,
  s0_.level AS level_17,
  s0_.languages AS languages_18,
  s0_.included AS included_19,
  s0_.subtitle AS subtitle_20,
  s0_.activity_type AS activity_type_21,
  s0_.minimum_age AS minimum_age_22,
  s0_.programme AS programme_23,
  s0_.meeting_point AS meeting_point_24,
  s0_.opening_period AS opening_period_25,
  s0_.audience AS audience_26,
  s0_.cancellation_policy AS cancellation_policy_27,
  s0_.address AS address_28,
  s0_.city AS city_29,
  s0_.postal_code AS postal_code_30,
  s0_.country AS country_31,
  s0_.latitude AS latitude_32,
  s0_.longitude AS longitude_33,
  s0_.id AS id_34,
  s0_.created_at AS created_at_35,
  s0_.updated_at AS updated_at_36,
  s0_.deleted_at AS deleted_at_37,
  c1_.name AS name_38,
  c1_.slug AS slug_39,
  c1_.position AS position_40,
  c1_.id AS id_41,
  c1_.created_at AS created_at_42,
  c1_.updated_at AS updated_at_43,
  s2_.name AS name_44,
  s2_.description AS description_45,
  s2_.price AS price_46,
  s2_.currency AS currency_47,
  s2_.pricing_unit AS pricing_unit_48,
  s2_.delivery_days AS delivery_days_49,
  s2_.id AS id_50,
  s2_.created_at AS created_at_51,
  s2_.updated_at AS updated_at_52,
  m3_.path AS path_53,
  m3_.type AS type_54,
  m3_.position AS position_55,
  m3_.id AS id_56,
  m3_.created_at AS created_at_57,
  m3_.updated_at AS updated_at_58,
  s0_.provider_id AS provider_id_59,
  s0_.category_id AS category_id_60,
  s0_.destination_id AS destination_id_61,
  c1_.parent_id AS parent_id_62,
  s2_.service_id AS service_id_63,
  m3_.service_id AS service_id_64
FROM
  service s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id
  LEFT JOIN service_package s2_ ON s0_.id = s2_.service_id
  LEFT JOIN media m3_ ON s0_.id = m3_.service_id
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL
ORDER BY
  s0_.position ASC,
  s0_.created_at ASC

SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.booking_type AS booking_type_3, s0_.status AS status_4, s0_.currency AS currency_5, s0_.short_description AS short_description_6, s0_.duration_minutes AS duration_minutes_7, s0_.place_label AS place_label_8, s0_.duration_label AS duration_label_9, s0_.badge AS badge_10, s0_.search_text AS search_text_11, s0_.search_place AS search_place_12, s0_.position AS position_13, s0_.rating_average AS rating_average_14, s0_.reviews_count AS reviews_count_15, s0_.capacity AS capacity_16, s0_.level AS level_17, s0_.languages AS languages_18, s0_.included AS included_19, s0_.subtitle AS subtitle_20, s0_.activity_type AS activity_type_21, s0_.minimum_age AS minimum_age_22, s0_.programme AS programme_23, s0_.meeting_point AS meeting_point_24, s0_.opening_period AS opening_period_25, s0_.audience AS audience_26, s0_.cancellation_policy AS cancellation_policy_27, s0_.address AS address_28, s0_.city AS city_29, s0_.postal_code AS postal_code_30, s0_.country AS country_31, s0_.latitude AS latitude_32, s0_.longitude AS longitude_33, s0_.id AS id_34, s0_.created_at AS created_at_35, s0_.updated_at AS updated_at_36, s0_.deleted_at AS deleted_at_37, c1_.name AS name_38, c1_.slug AS slug_39, c1_.position AS position_40, c1_.id AS id_41, c1_.created_at AS created_at_42, c1_.updated_at AS updated_at_43, s2_.name AS name_44, s2_.description AS description_45, s2_.price AS price_46, s2_.currency AS currency_47, s2_.pricing_unit AS pricing_unit_48, s2_.delivery_days AS delivery_days_49, s2_.id AS id_50, s2_.created_at AS created_at_51, s2_.updated_at AS updated_at_52, m3_.path AS path_53, m3_.type AS type_54, m3_.position AS position_55, m3_.id AS id_56, m3_.created_at AS created_at_57, m3_.updated_at AS updated_at_58, s0_.provider_id AS provider_id_59, s0_.category_id AS category_id_60, s0_.destination_id AS destination_id_61, c1_.parent_id AS parent_id_62, s2_.service_id AS service_id_63, m3_.service_id AS service_id_64 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id LEFT JOIN service_package s2_ ON s0_.id = s2_.service_id LEFT JOIN media m3_ ON s0_.id = m3_.service_id WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL ORDER BY s0_.position ASC, s0_.created_at ASC;

#	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->getResult (line 688)
6	App\Catalog\Repository\ServiceRepository->findPublishedForListing (line 78)
7	App\Catalog\Controller\DestinationController->cityActivities (line 150)
8	App\Catalog\Controller\DestinationController->city (line 99)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
11	Symfony\Component\HttpKernel\Kernel->handle (line 143)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

0.29 ms

SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?

Parameters:

[
  "019f9f89-3813-1a16-1a80-f22f1ca530ee"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.breadcrumb AS breadcrumb_1,
  t0.organizer AS organizer_2,
  t0.presentation_subtitle AS presentation_subtitle_3,
  t0.presentation_text AS presentation_text_4,
  t0.highlights_title AS highlights_title_5,
  t0.highlights AS highlights_6,
  t0.included AS included_7,
  t0.excluded AS excluded_8,
  t0.cannot_participate AS cannot_participate_9,
  t0.to_bring AS to_bring_10,
  t0.key_facts AS key_facts_11,
  t0.map_image AS map_image_12,
  t0.meeting_points AS meeting_points_13,
  t0.guarantees AS guarantees_14,
  t0.price AS price_15,
  t0.reviews_score AS reviews_score_16,
  t0.reviews_out_of AS reviews_out_of_17,
  t0.reviews_total AS reviews_total_18,
  t0.modal_title AS modal_title_19,
  t0.id AS id_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.service_id AS service_id_23
FROM
  service_detail t0
WHERE
  t0.service_id = ?

SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = '019f9f89-3813-1a16-1a80-f22f1ca530ee';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Catalog\Repository\ServiceRepository->findPublishedForListing (line 78)
12	App\Catalog\Controller\DestinationController->cityActivities (line 150)
13	App\Catalog\Controller\DestinationController->city (line 99)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
16	Symfony\Component\HttpKernel\Kernel->handle (line 143)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
18	require_once (line 32)
19	require_once (line 5)

0.16 ms

SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = ?

Parameters:

[
  "019f9f89-3813-1a16-1a80-f22f1ca530f1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.breadcrumb AS breadcrumb_1,
  t0.organizer AS organizer_2,
  t0.presentation_subtitle AS presentation_subtitle_3,
  t0.presentation_text AS presentation_text_4,
  t0.highlights_title AS highlights_title_5,
  t0.highlights AS highlights_6,
  t0.included AS included_7,
  t0.excluded AS excluded_8,
  t0.cannot_participate AS cannot_participate_9,
  t0.to_bring AS to_bring_10,
  t0.key_facts AS key_facts_11,
  t0.map_image AS map_image_12,
  t0.meeting_points AS meeting_points_13,
  t0.guarantees AS guarantees_14,
  t0.price AS price_15,
  t0.reviews_score AS reviews_score_16,
  t0.reviews_out_of AS reviews_out_of_17,
  t0.reviews_total AS reviews_total_18,
  t0.modal_title AS modal_title_19,
  t0.id AS id_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.service_id AS service_id_23
FROM
  service_detail t0
WHERE
  t0.service_id = ?

SELECT t0.breadcrumb AS breadcrumb_1, t0.organizer AS organizer_2, t0.presentation_subtitle AS presentation_subtitle_3, t0.presentation_text AS presentation_text_4, t0.highlights_title AS highlights_title_5, t0.highlights AS highlights_6, t0.included AS included_7, t0.excluded AS excluded_8, t0.cannot_participate AS cannot_participate_9, t0.to_bring AS to_bring_10, t0.key_facts AS key_facts_11, t0.map_image AS map_image_12, t0.meeting_points AS meeting_points_13, t0.guarantees AS guarantees_14, t0.price AS price_15, t0.reviews_score AS reviews_score_16, t0.reviews_out_of AS reviews_out_of_17, t0.reviews_total AS reviews_total_18, t0.modal_title AS modal_title_19, t0.id AS id_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.service_id AS service_id_23 FROM service_detail t0 WHERE t0.service_id = '019f9f89-3813-1a16-1a80-f22f1ca530f1';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Catalog\Repository\ServiceRepository->findPublishedForListing (line 78)
12	App\Catalog\Controller\DestinationController->cityActivities (line 150)
13	App\Catalog\Controller\DestinationController->city (line 99)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
16	Symfony\Component\HttpKernel\Kernel->handle (line 143)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
18	require_once (line 32)
19	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\Catalog\Entity\Category	3
App\Catalog\Entity\Service	2
App\Catalog\Entity\ServiceDetail	2
App\Catalog\Entity\ServicePackage	2
App\Provider\Entity\ProviderProfile	1
App\Catalog\Entity\Destination	1
App\Catalog\Entity\Media	1

Entities Mapping

Class	Mapping errors
App\Catalog\Entity\Service	No errors.
App\Catalog\Entity\Category	No errors.
App\Catalog\Entity\ServicePackage	No errors.
App\Catalog\Entity\Media	No errors.
App\Provider\Entity\ProviderProfile	No errors.
App\Catalog\Entity\Destination	No errors.
App\Catalog\Entity\ServiceDetail	No errors.
App\Catalog\Entity\ServiceOption	No errors.

GET https://trouvemoi.eu/en/destinations/lille

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping