Symfony Profiler

Query Metrics

544 Database Queries

8 Different statements

4769.18 ms Query time

0 Invalid entities

8884 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2458.42 ms
(51.55%)

269

SELECT a0_.id AS id_0, a0_.field_id AS field_id_1, a0_.value AS value_2, a0_.unit AS unit_3, a0_.advert_id AS sclr_4 FROM advert_attribute a0_ WHERE a0_.advert_id IN (?) ORDER BY a0_.id ASC

Parameters:

[
  2114970
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.field_id AS field_id_1,
  a0_.value AS value_2,
  a0_.unit AS unit_3,
  a0_.advert_id AS sclr_4
FROM
  advert_attribute a0_
WHERE
  a0_.advert_id IN (?)
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.field_id AS field_id_1, a0_.value AS value_2, a0_.unit AS unit_3, a0_.advert_id AS sclr_4 FROM advert_attribute a0_ WHERE a0_.advert_id IN (2114970) ORDER BY a0_.id 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->getArrayResult (line 700)
6	App\Helper\OfferInfoProvider->load (line 98)
7	App\Helper\OfferInfoProvider->prefetch (line 74)
8	App\Helper\OfferInfoProvider->get (line 42)
9	App\Twig\AppExtension->getAdvertTitle (line 279)
10	__TwigTemplate_53e5a6f61a95af2c132768a77cd94202->block_body (line 160)
11	Twig\Template->yieldBlock (line 493)
12	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
13	Twig\Template->yield (line 461)
14	__TwigTemplate_53e5a6f61a95af2c132768a77cd94202->doDisplay (line 59)
15	Twig\Template->yield (line 461)
16	Twig\Template->display (line 416)
17	Twig\Template->render (line 431)
18	Twig\TemplateWrapper->render (line 53)
19	Twig\Environment->render (line 343)
20	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
21	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
33	Symfony\Component\HttpKernel\Kernel->handle (line 143)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
35	require_once (line 32)
36	require_once (line 5)

2273.40 ms
(47.67%)

269

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.size AS size_4, t0.updated_at AS updated_at_5, t0.advert_id AS advert_id_6 FROM image t0 WHERE t0.advert_id = ? ORDER BY t0.position ASC

Parameters:

[
  2114970
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.position AS position_3,
  t0.size AS size_4,
  t0.updated_at AS updated_at_5,
  t0.advert_id AS advert_id_6
FROM
  image t0
WHERE
  t0.advert_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.size AS size_4, t0.updated_at AS updated_at_5, t0.advert_id AS advert_id_6 FROM image t0 WHERE t0.advert_id = 2114970 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 89)
7	Doctrine\ORM\PersistentCollection->containsKey (line 352)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1782)
10	__TwigTemplate_53e5a6f61a95af2c132768a77cd94202::block_body (line 141)
11	Twig\Template->yieldBlock (line 493)
12	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
13	Twig\Template->yield (line 461)
14	__TwigTemplate_53e5a6f61a95af2c132768a77cd94202->doDisplay (line 59)
15	Twig\Template->yield (line 461)
16	Twig\Template->display (line 416)
17	Twig\Template->render (line 431)
18	Twig\TemplateWrapper->render (line 53)
19	Twig\Environment->render (line 343)
20	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
21	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
33	Symfony\Component\HttpKernel\Kernel->handle (line 143)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
35	require_once (line 32)
36	require_once (line 5)

21.77 ms
(0.46%)

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.if_promo AS if_promo_2, a0_.active AS active_3, a0_.sold AS sold_4, a0_.expired_active AS expired_active_5, a0_.views AS views_6, a0_.deleted_at AS deleted_at_7, a0_.email AS email_8, a0_.title AS title_9, a0_.slug AS slug_10, a0_.currency AS currency_11, a0_.grossnet AS grossnet_12, a0_.price_negotiation AS price_negotiation_13, a0_.price AS price_14, a0_.price_pln AS price_pln_15, a0_.price_eur AS price_eur_16, a0_.price_usd AS price_usd_17, a0_.price_to AS price_to_18, a0_.price_to_pln AS price_to_pln_19, a0_.price_to_eur AS price_to_eur_20, a0_.price_to_usd AS price_to_usd_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.refreshed_at AS refreshed_at_24, a0_.expired_at AS expired_at_25, a0_.expire AS expire_26, a0_.expire_notify_at AS expire_notify_at_27, a0_.prices_updated_at AS prices_updated_at_28, a0_.category_id AS category_id_29, a0_.type_id AS type_id_30, a0_.subtype_id AS subtype_id_31, a0_.user_id AS user_id_32 FROM advert a0_ INNER JOIN promo_adverts p1_ ON a0_.id = p1_.advert_id WHERE (p1_.expired_at > ? AND p1_.promo_id = ?) AND (a0_.deleted_at IS NULL)

Parameters:

[
  "2026-10-28 18:20:59"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.number AS number_1,
  a0_.if_promo AS if_promo_2,
  a0_.active AS active_3,
  a0_.sold AS sold_4,
  a0_.expired_active AS expired_active_5,
  a0_.views AS views_6,
  a0_.deleted_at AS deleted_at_7,
  a0_.email AS email_8,
  a0_.title AS title_9,
  a0_.slug AS slug_10,
  a0_.currency AS currency_11,
  a0_.grossnet AS grossnet_12,
  a0_.price_negotiation AS price_negotiation_13,
  a0_.price AS price_14,
  a0_.price_pln AS price_pln_15,
  a0_.price_eur AS price_eur_16,
  a0_.price_usd AS price_usd_17,
  a0_.price_to AS price_to_18,
  a0_.price_to_pln AS price_to_pln_19,
  a0_.price_to_eur AS price_to_eur_20,
  a0_.price_to_usd AS price_to_usd_21,
  a0_.created_at AS created_at_22,
  a0_.updated_at AS updated_at_23,
  a0_.refreshed_at AS refreshed_at_24,
  a0_.expired_at AS expired_at_25,
  a0_.expire AS expire_26,
  a0_.expire_notify_at AS expire_notify_at_27,
  a0_.prices_updated_at AS prices_updated_at_28,
  a0_.category_id AS category_id_29,
  a0_.type_id AS type_id_30,
  a0_.subtype_id AS subtype_id_31,
  a0_.user_id AS user_id_32
FROM
  advert a0_
  INNER JOIN promo_adverts p1_ ON a0_.id = p1_.advert_id
WHERE
  (
    p1_.expired_at > ?
    AND p1_.promo_id = ?
  )
  AND (a0_.deleted_at IS NULL)

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.if_promo AS if_promo_2, a0_.active AS active_3, a0_.sold AS sold_4, a0_.expired_active AS expired_active_5, a0_.views AS views_6, a0_.deleted_at AS deleted_at_7, a0_.email AS email_8, a0_.title AS title_9, a0_.slug AS slug_10, a0_.currency AS currency_11, a0_.grossnet AS grossnet_12, a0_.price_negotiation AS price_negotiation_13, a0_.price AS price_14, a0_.price_pln AS price_pln_15, a0_.price_eur AS price_eur_16, a0_.price_usd AS price_usd_17, a0_.price_to AS price_to_18, a0_.price_to_pln AS price_to_pln_19, a0_.price_to_eur AS price_to_eur_20, a0_.price_to_usd AS price_to_usd_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.refreshed_at AS refreshed_at_24, a0_.expired_at AS expired_at_25, a0_.expire AS expire_26, a0_.expire_notify_at AS expire_notify_at_27, a0_.prices_updated_at AS prices_updated_at_28, a0_.category_id AS category_id_29, a0_.type_id AS type_id_30, a0_.subtype_id AS subtype_id_31, a0_.user_id AS user_id_32 FROM advert a0_ INNER JOIN promo_adverts p1_ ON a0_.id = p1_.advert_id WHERE (p1_.expired_at > '2026-10-28 18:20:59' AND p1_.promo_id = 1) AND (a0_.deleted_at IS NULL);

#	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\Handler\AdvertHandler->all (line 191)
7	App\Controller\DefaultController->getPromoAds (line 168)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

13.33 ms
(0.28%)

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.if_promo AS if_promo_2, a0_.active AS active_3, a0_.sold AS sold_4, a0_.expired_active AS expired_active_5, a0_.views AS views_6, a0_.deleted_at AS deleted_at_7, a0_.email AS email_8, a0_.title AS title_9, a0_.slug AS slug_10, a0_.currency AS currency_11, a0_.grossnet AS grossnet_12, a0_.price_negotiation AS price_negotiation_13, a0_.price AS price_14, a0_.price_pln AS price_pln_15, a0_.price_eur AS price_eur_16, a0_.price_usd AS price_usd_17, a0_.price_to AS price_to_18, a0_.price_to_pln AS price_to_pln_19, a0_.price_to_eur AS price_to_eur_20, a0_.price_to_usd AS price_to_usd_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.refreshed_at AS refreshed_at_24, a0_.expired_at AS expired_at_25, a0_.expire AS expire_26, a0_.expire_notify_at AS expire_notify_at_27, a0_.prices_updated_at AS prices_updated_at_28, a0_.category_id AS category_id_29, a0_.type_id AS type_id_30, a0_.subtype_id AS subtype_id_31, a0_.user_id AS user_id_32 FROM advert a0_ WHERE (a0_.deleted_at IS NULL) ORDER BY a0_.views DESC LIMIT 2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.number AS number_1,
  a0_.if_promo AS if_promo_2,
  a0_.active AS active_3,
  a0_.sold AS sold_4,
  a0_.expired_active AS expired_active_5,
  a0_.views AS views_6,
  a0_.deleted_at AS deleted_at_7,
  a0_.email AS email_8,
  a0_.title AS title_9,
  a0_.slug AS slug_10,
  a0_.currency AS currency_11,
  a0_.grossnet AS grossnet_12,
  a0_.price_negotiation AS price_negotiation_13,
  a0_.price AS price_14,
  a0_.price_pln AS price_pln_15,
  a0_.price_eur AS price_eur_16,
  a0_.price_usd AS price_usd_17,
  a0_.price_to AS price_to_18,
  a0_.price_to_pln AS price_to_pln_19,
  a0_.price_to_eur AS price_to_eur_20,
  a0_.price_to_usd AS price_to_usd_21,
  a0_.created_at AS created_at_22,
  a0_.updated_at AS updated_at_23,
  a0_.refreshed_at AS refreshed_at_24,
  a0_.expired_at AS expired_at_25,
  a0_.expire AS expire_26,
  a0_.expire_notify_at AS expire_notify_at_27,
  a0_.prices_updated_at AS prices_updated_at_28,
  a0_.category_id AS category_id_29,
  a0_.type_id AS type_id_30,
  a0_.subtype_id AS subtype_id_31,
  a0_.user_id AS user_id_32
FROM
  advert a0_
WHERE
  (a0_.deleted_at IS NULL)
ORDER BY
  a0_.views DESC
LIMIT
  2

SELECT a0_.id AS id_0, a0_.number AS number_1, a0_.if_promo AS if_promo_2, a0_.active AS active_3, a0_.sold AS sold_4, a0_.expired_active AS expired_active_5, a0_.views AS views_6, a0_.deleted_at AS deleted_at_7, a0_.email AS email_8, a0_.title AS title_9, a0_.slug AS slug_10, a0_.currency AS currency_11, a0_.grossnet AS grossnet_12, a0_.price_negotiation AS price_negotiation_13, a0_.price AS price_14, a0_.price_pln AS price_pln_15, a0_.price_eur AS price_eur_16, a0_.price_usd AS price_usd_17, a0_.price_to AS price_to_18, a0_.price_to_pln AS price_to_pln_19, a0_.price_to_eur AS price_to_eur_20, a0_.price_to_usd AS price_to_usd_21, a0_.created_at AS created_at_22, a0_.updated_at AS updated_at_23, a0_.refreshed_at AS refreshed_at_24, a0_.expired_at AS expired_at_25, a0_.expire AS expire_26, a0_.expire_notify_at AS expire_notify_at_27, a0_.prices_updated_at AS prices_updated_at_28, a0_.category_id AS category_id_29, a0_.type_id AS type_id_30, a0_.subtype_id AS subtype_id_31, a0_.user_id AS user_id_32 FROM advert a0_ WHERE (a0_.deleted_at IS NULL) ORDER BY a0_.views DESC LIMIT 2;

#	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\Handler\AdvertHandler->all (line 191)
7	App\EventListener\GlobalTwigVariablesListener->getGlobals (line 29)
8	Twig\ExtensionSet->getGlobals (line 362)
9	Twig\Environment->getGlobals (line 922)
10	Twig\Template->yield (line 456)
11	Twig\Template->display (line 416)
12	Twig\Template->render (line 431)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Environment->render (line 343)
15	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
16	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
28	Symfony\Component\HttpKernel\Kernel->handle (line 143)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

0.78 ms
(0.02%)

SELECT a0_.pay AS pay_0, a0_.only_logged AS only_logged_1, a0_.id AS id_2, a0_.name AS name_3, a0_.description AS description_4, a0_.slug AS slug_5, a0_.price_from_to AS price_from_to_6, a0_.hide_default_fields AS hide_default_fields_7, a0_.fields AS fields_8, a0_.package_group_id AS package_group_id_9 FROM advert_category a0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.pay AS pay_0,
  a0_.only_logged AS only_logged_1,
  a0_.id AS id_2,
  a0_.name AS name_3,
  a0_.description AS description_4,
  a0_.slug AS slug_5,
  a0_.price_from_to AS price_from_to_6,
  a0_.hide_default_fields AS hide_default_fields_7,
  a0_.fields AS fields_8,
  a0_.package_group_id AS package_group_id_9
FROM
  advert_category a0_

SELECT a0_.pay AS pay_0, a0_.only_logged AS only_logged_1, a0_.id AS id_2, a0_.name AS name_3, a0_.description AS description_4, a0_.slug AS slug_5, a0_.price_from_to AS price_from_to_6, a0_.hide_default_fields AS hide_default_fields_7, a0_.fields AS fields_8, a0_.package_group_id AS package_group_id_9 FROM advert_category a0_;

#	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\Handler\BaseHandler->all (line 41)
7	App\EventListener\GlobalTwigVariablesListener->getGlobals (line 28)
8	Twig\ExtensionSet->getGlobals (line 362)
9	Twig\Environment->getGlobals (line 922)
10	Twig\Template->yield (line 456)
11	Twig\Template->display (line 416)
12	Twig\Template->render (line 431)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Environment->render (line 343)
15	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
16	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
28	Symfony\Component\HttpKernel\Kernel->handle (line 143)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

0.57 ms
(0.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_category AS advert_category_3 FROM advert_type t0 WHERE t0.advert_category IN (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.advert_category AS advert_category_3
FROM
  advert_type t0
WHERE
  t0.advert_category IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_category AS advert_category_3 FROM advert_type t0 WHERE t0.advert_category IN (2, 3, 4, 6, 7, 8, 9, 10);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2876)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2852)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
7	Doctrine\ORM\AbstractQuery->execute (line 886)
8	Doctrine\ORM\AbstractQuery->getResult (line 688)
9	App\Handler\BaseHandler->all (line 41)
10	App\EventListener\GlobalTwigVariablesListener->getGlobals (line 28)
11	Twig\ExtensionSet->getGlobals (line 362)
12	Twig\Environment->getGlobals (line 922)
13	Twig\Template->yield (line 456)
14	Twig\Template->display (line 416)
15	Twig\Template->render (line 431)
16	Twig\TemplateWrapper->render (line 53)
17	Twig\Environment->render (line 343)
18	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
19	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
24	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
31	Symfony\Component\HttpKernel\Kernel->handle (line 143)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 5)

0.49 ms
(0.01%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_type AS advert_type_3 FROM advert_subtype t0 WHERE t0.advert_type IN (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.advert_type AS advert_type_3
FROM
  advert_subtype t0
WHERE
  t0.advert_type IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.advert_type AS advert_type_3 FROM advert_subtype t0 WHERE t0.advert_type IN (1, 2, 3, 4, 5, 6, 7, 8);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2876)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2852)
4	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 65)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 967)
7	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2876)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2852)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 178)
11	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
12	Doctrine\ORM\AbstractQuery->execute (line 886)
13	Doctrine\ORM\AbstractQuery->getResult (line 688)
14	App\Handler\BaseHandler->all (line 41)
15	App\EventListener\GlobalTwigVariablesListener->getGlobals (line 28)
16	Twig\ExtensionSet->getGlobals (line 362)
17	Twig\Environment->getGlobals (line 922)
18	Twig\Template->yield (line 456)
19	Twig\Template->display (line 416)
20	Twig\Template->render (line 431)
21	Twig\TemplateWrapper->render (line 53)
22	Twig\Environment->render (line 343)
23	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
24	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
29	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
36	Symfony\Component\HttpKernel\Kernel->handle (line 143)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
38	require_once (line 32)
39	require_once (line 5)

0.42 ms
(0.01%)

SELECT m0_.id AS id_0, m0_.name AS name_1 FROM make m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1
FROM
  make m0_

SELECT m0_.id AS id_0, m0_.name AS name_1 FROM make m0_;

#	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->getArrayResult (line 700)
6	App\Twig\AppExtension->getMake (line 102)
7	App\Twig\AppExtension->get_attribute_value (line 209)
8	App\Twig\AppExtension->getAdvertTitle (line 286)
9	__TwigTemplate_53e5a6f61a95af2c132768a77cd94202->block_body (line 160)
10	Twig\Template->yieldBlock (line 493)
11	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_53e5a6f61a95af2c132768a77cd94202->doDisplay (line 59)
14	Twig\Template->yield (line 461)
15	Twig\Template->display (line 416)
16	Twig\Template->render (line 431)
17	Twig\TemplateWrapper->render (line 53)
18	Twig\Environment->render (line 343)
19	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
20	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
25	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
32	Symfony\Component\HttpKernel\Kernel->handle (line 143)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
34	require_once (line 32)
35	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\Entity\Image	8549
App\Entity\Advert	271
App\Entity\User	42
App\Entity\AdvertCategory	8
App\Entity\AdvertType	8
App\Entity\PackageGroup	4
App\Entity\AdvertSubtype	2

Entities Mapping

Class	Mapping errors
App\Entity\Advert	No errors.
App\Entity\AdvertCategory	No errors.
App\Entity\PromoAdverts	No errors.
App\Entity\AdvertType	No errors.
App\Entity\AdvertSubtype	No errors.
App\Entity\User	No errors.
App\Entity\AdvertAttribute	No errors.
App\Entity\Image	No errors.
App\Entity\PackageGroup	No errors.
App\Entity\Make	No errors.

GET https://www.bushandel-sf8.pelp.pl/promowane?url=promowane

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping