Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

1.95 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.60 ms
(30.68%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.body AS body_4, p0_.price_type AS price_type_5, p0_.price_note AS price_note_6, p0_.booking AS booking_7, p0_.hours_note AS hours_note_8, p0_.structured_hours AS structured_hours_9, p0_.metro_station AS metro_station_10, p0_.duration_minutes AS duration_minutes_11, p0_.address AS address_12, p0_.lat AS lat_13, p0_.lng AS lng_14, p0_.highlights AS highlights_15, p0_.kids_tips AS kids_tips_16, p0_.source_url AS source_url_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.meta_title AS meta_title_20, p0_.meta_description AS meta_description_21, p0_.og_image AS og_image_22, p0_.canonical_override AS canonical_override_23, p0_.indexable AS indexable_24, p0_.status AS status_25, p0_.published_at AS published_at_26, p0_.checked_at AS checked_at_27, p0_.demo AS demo_28, p0_.city_id AS city_id_29, p0_.district_id AS district_id_30, p0_.cover_image_id AS cover_image_id_31, p0_.ticket_link_id AS ticket_link_id_32, p0_.tour_link_id AS tour_link_id_33 FROM place p0_ INNER JOIN place_tag p2_ ON p0_.id = p2_.place_id INNER JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.city_id = ? AND p0_.status = ? AND t1_.id = ? ORDER BY p0_.name ASC

Parameters:

[
  2
  "published"
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.short_description AS short_description_3,
  p0_.body AS body_4,
  p0_.price_type AS price_type_5,
  p0_.price_note AS price_note_6,
  p0_.booking AS booking_7,
  p0_.hours_note AS hours_note_8,
  p0_.structured_hours AS structured_hours_9,
  p0_.metro_station AS metro_station_10,
  p0_.duration_minutes AS duration_minutes_11,
  p0_.address AS address_12,
  p0_.lat AS lat_13,
  p0_.lng AS lng_14,
  p0_.highlights AS highlights_15,
  p0_.kids_tips AS kids_tips_16,
  p0_.source_url AS source_url_17,
  p0_.created_at AS created_at_18,
  p0_.updated_at AS updated_at_19,
  p0_.meta_title AS meta_title_20,
  p0_.meta_description AS meta_description_21,
  p0_.og_image AS og_image_22,
  p0_.canonical_override AS canonical_override_23,
  p0_.indexable AS indexable_24,
  p0_.status AS status_25,
  p0_.published_at AS published_at_26,
  p0_.checked_at AS checked_at_27,
  p0_.demo AS demo_28,
  p0_.city_id AS city_id_29,
  p0_.district_id AS district_id_30,
  p0_.cover_image_id AS cover_image_id_31,
  p0_.ticket_link_id AS ticket_link_id_32,
  p0_.tour_link_id AS tour_link_id_33
FROM
  place p0_
  INNER JOIN place_tag p2_ ON p0_.id = p2_.place_id
  INNER JOIN tag t1_ ON t1_.id = p2_.tag_id
WHERE
  p0_.city_id = ?
  AND p0_.status = ?
  AND t1_.id = ?
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.short_description AS short_description_3, p0_.body AS body_4, p0_.price_type AS price_type_5, p0_.price_note AS price_note_6, p0_.booking AS booking_7, p0_.hours_note AS hours_note_8, p0_.structured_hours AS structured_hours_9, p0_.metro_station AS metro_station_10, p0_.duration_minutes AS duration_minutes_11, p0_.address AS address_12, p0_.lat AS lat_13, p0_.lng AS lng_14, p0_.highlights AS highlights_15, p0_.kids_tips AS kids_tips_16, p0_.source_url AS source_url_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.meta_title AS meta_title_20, p0_.meta_description AS meta_description_21, p0_.og_image AS og_image_22, p0_.canonical_override AS canonical_override_23, p0_.indexable AS indexable_24, p0_.status AS status_25, p0_.published_at AS published_at_26, p0_.checked_at AS checked_at_27, p0_.demo AS demo_28, p0_.city_id AS city_id_29, p0_.district_id AS district_id_30, p0_.cover_image_id AS cover_image_id_31, p0_.ticket_link_id AS ticket_link_id_32, p0_.tour_link_id AS tour_link_id_33 FROM place p0_ INNER JOIN place_tag p2_ ON p0_.id = p2_.place_id INNER JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE p0_.city_id = 2 AND p0_.status = 'published' AND t1_.id = 8 ORDER BY p0_.name 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\Repository\PlaceRepository->findByFilters (line 109)
7	App\Service\Programmatic\ProgrammaticPageResolver->resolve (line 83)
8	App\Controller\TagHubController->hub (line 35)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
11	Symfony\Component\HttpKernel\Kernel->handle (line 205)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 7)

0.57 ms
(29.12%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM tag t0 INNER JOIN place_tag ON t0.id = place_tag.tag_id WHERE place_tag.place_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.city_id AS city_id_7
FROM
  tag t0
  INNER JOIN place_tag ON t0.id = place_tag.tag_id
WHERE
  place_tag.place_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM tag t0 INNER JOIN place_tag ON t0.id = place_tag.tag_id WHERE place_tag.place_id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2932)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->length (line 1299)
9	__TwigTemplate_652a974eec4c36d742566a407fec3b84::doDisplay (line 66)
10	Twig\Template->yield (line 461)
11	Twig\Template->display (line 416)
12	Twig\Template->render (line 431)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_ec082814bbd2c784f0643428b603255f->block_body (line 108)
17	Twig\Template->yieldBlock (line 493)
18	__TwigTemplate_bc05ddcba0fa03b1666b775c77b76848->doDisplay (line 141)
19	Twig\Template->yield (line 461)
20	__TwigTemplate_ec082814bbd2c784f0643428b603255f->doDisplay (line 58)
21	Twig\Template->yield (line 461)
22	Twig\Template->display (line 416)
23	Twig\Template->render (line 431)
24	Twig\TemplateWrapper->render (line 53)
25	Twig\Environment->render (line 343)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\TagHubController->hub (line 45)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
32	Symfony\Component\HttpKernel\Kernel->handle (line 205)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
34	require_once (line 32)
35	require_once (line 7)

0.35 ms
(17.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.domain AS domain_4, t0.accent_color AS accent_color_5, t0.pip_accessory AS pip_accessory_6, t0.hero_asset AS hero_asset_7, t0.hero_winter_asset AS hero_winter_asset_8, t0.intro AS intro_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM city t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.domain AS domain_4,
  t0.accent_color AS accent_color_5,
  t0.pip_accessory AS pip_accessory_6,
  t0.hero_asset AS hero_asset_7,
  t0.hero_winter_asset AS hero_winter_asset_8,
  t0.intro AS intro_9,
  t0.active AS active_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.domain AS domain_4, t0.accent_color AS accent_color_5, t0.pip_accessory AS pip_accessory_6, t0.hero_asset AS hero_asset_7, t0.hero_winter_asset AS hero_winter_asset_8, t0.intro AS intro_9, t0.active AS active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM city t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 65)
6	App\Service\City\CityResolver->resolveFromHost (line 41)
7	App\EventSubscriber\CityRequestSubscriber->onKernelRequest (line 53)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
14	Symfony\Component\HttpKernel\Kernel->handle (line 205)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
16	require_once (line 32)
17	require_once (line 7)

0.26 ms
(13.13%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.type AS type_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.city_id AS city_id_6 FROM tag t0_ WHERE t0_.slug = ? AND (t0_.city_id = ? OR t0_.city_id IS NULL) LIMIT 1

Parameters:

[
  "bij-regen"
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.type AS type_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5,
  t0_.city_id AS city_id_6
FROM
  tag t0_
WHERE
  t0_.slug = ?
  AND (
    t0_.city_id = ?
    OR t0_.city_id IS NULL
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.type AS type_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.city_id AS city_id_6 FROM tag t0_ WHERE t0_.slug = 'bij-regen' AND (t0_.city_id = 2 OR t0_.city_id IS NULL) LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\TagRepository->findOneByCityOrGlobal (line 29)
7	App\Service\Programmatic\ProgrammaticPageResolver->resolve (line 58)
8	App\Controller\TagHubController->hub (line 35)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
11	Symfony\Component\HttpKernel\Kernel->handle (line 205)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 7)

0.18 ms
(9.37%)

SELECT t0.id AS id_1, t0.path AS path_2, t0.intro AS intro_3, t0.title_override AS title_override_4, t0.meta_override AS meta_override_5, t0.force_index AS force_index_6, t0.force_noindex AS force_noindex_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.city_id AS city_id_10, t0.category_id AS category_id_11, t0.district_id AS district_id_12 FROM programmatic_page t0 WHERE t0.city_id = ? AND t0.path = ? LIMIT 1

Parameters:

[
  2
  "/bij-regen"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.intro AS intro_3,
  t0.title_override AS title_override_4,
  t0.meta_override AS meta_override_5,
  t0.force_index AS force_index_6,
  t0.force_noindex AS force_noindex_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.city_id AS city_id_10,
  t0.category_id AS category_id_11,
  t0.district_id AS district_id_12
FROM
  programmatic_page t0
WHERE
  t0.city_id = ?
  AND t0.path = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.path AS path_2, t0.intro AS intro_3, t0.title_override AS title_override_4, t0.meta_override AS meta_override_5, t0.force_index AS force_index_6, t0.force_noindex AS force_noindex_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.city_id AS city_id_10, t0.category_id AS category_id_11, t0.district_id AS district_id_12 FROM programmatic_page t0 WHERE t0.city_id = 2 AND t0.path = '/bij-regen' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 89)
4	App\Service\Programmatic\ProgrammaticPageResolver->resolve (line 90)
5	App\Controller\TagHubController->hub (line 35)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
8	Symfony\Component\HttpKernel\Kernel->handle (line 205)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 7)

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\Entity\Tag	4
App\Entity\Place	3
App\Entity\AffiliateLink	2
App\Entity\City	1
App\Entity\District	1

Entities Mapping

Class	Mapping errors
App\Entity\City	No errors.
App\Entity\Tag	No errors.
App\Entity\Place	No errors.
App\Entity\District	No errors.
App\Entity\MediaAsset	No errors.
App\Entity\AffiliateLink	No errors.
App\Entity\Category	No errors.
App\Entity\ProgrammaticPage	No errors.

Symfony Profiler

GET https://zininlonden.nl/bij-regen

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping