Symfony Profiler

Query Metrics

22 Database Queries

22 Different statements

1048.71 ms Query time

0 Invalid entities

94 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

679.23 ms
(64.77%)

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_.category_id = ? AND a0_.id <> ?) AND (a0_.deleted_at IS NULL) ORDER BY a0_.refreshed_at DESC, a0_.refreshed_at DESC LIMIT 3

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_.category_id = ?
    AND a0_.id <> ?
  )
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.refreshed_at DESC,
  a0_.refreshed_at DESC
LIMIT
  3

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_.category_id = 2 AND a0_.id <> 2145786) AND (a0_.deleted_at IS NULL) ORDER BY a0_.refreshed_at DESC, a0_.refreshed_at DESC LIMIT 3;

#	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->getSimilar (line 560)
7	App\Controller\AdvertController->getAdvertAction (line 122)
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)

128.40 ms
(12.24%)

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)

70.54 ms
(6.73%)

SELECT t0.id AS id_1, t0.field_id AS field_id_2, t0.value AS value_3, t0.unit AS unit_4, t0.advert_id AS advert_id_5 FROM advert_attribute t0 WHERE t0.advert_id = ?

Parameters:

[
  2145786
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.field_id AS field_id_2,
  t0.value AS value_3,
  t0.unit AS unit_4,
  t0.advert_id AS advert_id_5
FROM
  advert_attribute t0
WHERE
  t0.advert_id = ?

SELECT t0.id AS id_1, t0.field_id AS field_id_2, t0.value AS value_3, t0.unit AS unit_4, t0.advert_id AS advert_id_5 FROM advert_attribute t0 WHERE t0.advert_id = 2145786;

#	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->getIterator (line 253)
7	App\Twig\AppExtension->get_attribute_value (line 199)
8	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 60)
9	Twig\Template->yield (line 461)
10	Twig\Template->display (line 416)
11	Twig\Template->render (line 431)
12	Twig\TemplateWrapper->render (line 53)
13	Twig\Environment->render (line 343)
14	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
15	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
20	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
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\HttpKernel->handleRaw (line 195)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
27	Symfony\Component\HttpKernel\Kernel->handle (line 143)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
29	require_once (line 32)
30	require_once (line 5)

33.76 ms
(3.22%)

SELECT p0_.id AS id_0, p1_.advert_id AS sclr_1 FROM promo p0_ INNER JOIN promo_adverts p1_ ON p0_.id = p1_.promo_id WHERE p1_.advert_id IN (?) AND p1_.started_at <= ? AND p1_.expired_at >= ? ORDER BY p1_.id ASC

Parameters:

[
  2145786
  "2026-10-28 20:22:05"
  "2026-10-28 20:22:05"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p1_.advert_id AS sclr_1
FROM
  promo p0_
  INNER JOIN promo_adverts p1_ ON p0_.id = p1_.promo_id
WHERE
  p1_.advert_id IN (?)
  AND p1_.started_at <= ?
  AND p1_.expired_at >= ?
ORDER BY
  p1_.id ASC

SELECT p0_.id AS id_0, p1_.advert_id AS sclr_1 FROM promo p0_ INNER JOIN promo_adverts p1_ ON p0_.id = p1_.promo_id WHERE p1_.advert_id IN (2145786) AND p1_.started_at <= '2026-10-28 20:22:05' AND p1_.expired_at >= '2026-10-28 20:22:05' ORDER BY p1_.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 121)
7	App\Helper\OfferInfoProvider->prefetch (line 74)
8	App\Helper\OfferInfoProvider->get (line 42)
9	App\Twig\AppExtension->getOfferInfo (line 122)
10	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->doDisplay (line 64)
11	Twig\Template->yield (line 461)
12	Twig\Template->display (line 416)
13	Twig\Template->render (line 431)
14	Twig\TemplateWrapper->render (line 53)
15	Twig\Extension\CoreExtension->include (line 1575)
16	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5::block_body (line 140)
17	Twig\Template->yieldBlock (line 493)
18	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
19	Twig\Template->yield (line 461)
20	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 68)
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\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
27	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
32	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
33	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
34	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
35	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
36	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
39	Symfony\Component\HttpKernel\Kernel->handle (line 143)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	require_once (line 5)

27.33 ms
(2.61%)

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	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 64)
8	Twig\Template->yield (line 461)
9	Twig\Template->display (line 416)
10	Twig\Template->render (line 431)
11	Twig\TemplateWrapper->render (line 53)
12	Twig\Environment->render (line 343)
13	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
14	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
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\HttpKernel->handleRaw (line 195)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
26	Symfony\Component\HttpKernel\Kernel->handle (line 143)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
28	require_once (line 32)
29	require_once (line 5)

23.99 ms
(2.29%)

SELECT i0_.id AS id_0, i0_.image AS image_1, i0_.position AS position_2, i0_.size AS size_3, i0_.updated_at AS updated_at_4, i0_.advert_id AS sclr_5 FROM image i0_ WHERE i0_.advert_id IN (?) ORDER BY i0_.position ASC, i0_.id ASC

Parameters:

[
  2145786
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.image AS image_1,
  i0_.position AS position_2,
  i0_.size AS size_3,
  i0_.updated_at AS updated_at_4,
  i0_.advert_id AS sclr_5
FROM
  image i0_
WHERE
  i0_.advert_id IN (?)
ORDER BY
  i0_.position ASC,
  i0_.id ASC

SELECT i0_.id AS id_0, i0_.image AS image_1, i0_.position AS position_2, i0_.size AS size_3, i0_.updated_at AS updated_at_4, i0_.advert_id AS sclr_5 FROM image i0_ WHERE i0_.advert_id IN (2145786) ORDER BY i0_.position ASC, i0_.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 108)
7	App\Helper\OfferInfoProvider->prefetch (line 74)
8	App\Helper\OfferInfoProvider->get (line 42)
9	App\Twig\AppExtension->getOfferInfo (line 122)
10	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->doDisplay (line 64)
11	Twig\Template->yield (line 461)
12	Twig\Template->display (line 416)
13	Twig\Template->render (line 431)
14	Twig\TemplateWrapper->render (line 53)
15	Twig\Extension\CoreExtension->include (line 1575)
16	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5::block_body (line 140)
17	Twig\Template->yieldBlock (line 493)
18	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
19	Twig\Template->yield (line 461)
20	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 68)
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\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
27	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
32	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
33	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
34	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
35	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
36	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
39	Symfony\Component\HttpKernel\Kernel->handle (line 143)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	require_once (line 5)

22.29 ms
(2.13%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_pln AS price_pln_2, p0_.price_eur AS price_eur_3, p0_.duration AS duration_4 FROM promo p0_ WHERE p0_.id IN (?)

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price_pln AS price_pln_2,
  p0_.price_eur AS price_eur_3,
  p0_.duration AS duration_4
FROM
  promo p0_
WHERE
  p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_pln AS price_pln_2, p0_.price_eur AS price_eur_3, p0_.duration AS duration_4 FROM promo p0_ WHERE p0_.id IN (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->getArrayResult (line 700)
6	App\Helper\OfferInfoProvider->loadPromos (line 145)
7	App\Helper\OfferInfoProvider->load (line 123)
8	App\Helper\OfferInfoProvider->prefetch (line 74)
9	App\Helper\OfferInfoProvider->get (line 42)
10	App\Twig\AppExtension->getOfferInfo (line 122)
11	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->doDisplay (line 64)
12	Twig\Template->yield (line 461)
13	Twig\Template->display (line 416)
14	Twig\Template->render (line 431)
15	Twig\TemplateWrapper->render (line 53)
16	Twig\Extension\CoreExtension->include (line 1575)
17	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5::block_body (line 140)
18	Twig\Template->yieldBlock (line 493)
19	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
20	Twig\Template->yield (line 461)
21	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 68)
22	Twig\Template->yield (line 461)
23	Twig\Template->display (line 416)
24	Twig\Template->render (line 431)
25	Twig\TemplateWrapper->render (line 53)
26	Twig\Environment->render (line 343)
27	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
28	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
33	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
34	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
35	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
36	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
37	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
40	Symfony\Component\HttpKernel\Kernel->handle (line 143)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
42	require_once (line 32)
43	require_once (line 5)

16.44 ms
(1.57%)

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone AS phone_3, t0.phone_mobile AS phone_mobile_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.street AS street_7, t0.geocode AS geocode_8, t0.www AS www_9, t0.comment AS comment_10, t0.pdo AS pdo_11, t0.invoice_nip AS invoice_nip_12, t0.invoice_company_name AS invoice_company_name_13, t0.invoice_name AS invoice_name_14, t0.invoice_postal_code AS invoice_postal_code_15, t0.invoice_city AS invoice_city_16, t0.invoice_street AS invoice_street_17, t0.invoice_phone AS invoice_phone_18, t0.invoice_delivery AS invoice_delivery_19, t0.invoice_delivery_name AS invoice_delivery_name_20, t0.invoice_delivery_postal_code AS invoice_delivery_postal_code_21, t0.invoice_delivery_city AS invoice_delivery_city_22, t0.invoice_delivery_street AS invoice_delivery_street_23, t0.profile_title_top AS profile_title_top_24, t0.profile_title_bottom AS profile_title_bottom_25, t0.deleted_at AS deleted_at_26, t0.userpage_home AS userpage_home_27, t0.lang AS lang_28, t0.last_activity AS last_activity_29, t0.profile_url AS profile_url_30, t0.expire_notify_at AS expire_notify_at_31, t0.expired_at AS expired_at_32, t0.test AS test_33, t0.powiat AS powiat_34, t0.about AS about_35, t0.views AS views_36, t0.name AS name_37, t0.username AS username_38, t0.username_canonical AS username_canonical_39, t0.email AS email_40, t0.email_canonical AS email_canonical_41, t0.enabled AS enabled_42, t0.salt AS salt_43, t0.password AS password_44, t0.last_login AS last_login_45, t0.confirmation_token AS confirmation_token_46, t0.password_requested_at AS password_requested_at_47, t0.roles AS roles_48, t0.country_id AS country_id_49, t0.region_id AS region_id_50, t0.invoice_region_id AS invoice_region_id_51, t0.invoice_region_id AS invoice_region_id_52, t0.image_id AS image_id_53, t0.profile_image_id AS profile_image_id_54, t0.profile_advert AS profile_advert_55 FROM fos_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  7487
]

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.phone AS phone_3,
  t0.phone_mobile AS phone_mobile_4,
  t0.postal_code AS postal_code_5,
  t0.city AS city_6,
  t0.street AS street_7,
  t0.geocode AS geocode_8,
  t0.www AS www_9,
  t0.comment AS comment_10,
  t0.pdo AS pdo_11,
  t0.invoice_nip AS invoice_nip_12,
  t0.invoice_company_name AS invoice_company_name_13,
  t0.invoice_name AS invoice_name_14,
  t0.invoice_postal_code AS invoice_postal_code_15,
  t0.invoice_city AS invoice_city_16,
  t0.invoice_street AS invoice_street_17,
  t0.invoice_phone AS invoice_phone_18,
  t0.invoice_delivery AS invoice_delivery_19,
  t0.invoice_delivery_name AS invoice_delivery_name_20,
  t0.invoice_delivery_postal_code AS invoice_delivery_postal_code_21,
  t0.invoice_delivery_city AS invoice_delivery_city_22,
  t0.invoice_delivery_street AS invoice_delivery_street_23,
  t0.profile_title_top AS profile_title_top_24,
  t0.profile_title_bottom AS profile_title_bottom_25,
  t0.deleted_at AS deleted_at_26,
  t0.userpage_home AS userpage_home_27,
  t0.lang AS lang_28,
  t0.last_activity AS last_activity_29,
  t0.profile_url AS profile_url_30,
  t0.expire_notify_at AS expire_notify_at_31,
  t0.expired_at AS expired_at_32,
  t0.test AS test_33,
  t0.powiat AS powiat_34,
  t0.about AS about_35,
  t0.views AS views_36,
  t0.name AS name_37,
  t0.username AS username_38,
  t0.username_canonical AS username_canonical_39,
  t0.email AS email_40,
  t0.email_canonical AS email_canonical_41,
  t0.enabled AS enabled_42,
  t0.salt AS salt_43,
  t0.password AS password_44,
  t0.last_login AS last_login_45,
  t0.confirmation_token AS confirmation_token_46,
  t0.password_requested_at AS password_requested_at_47,
  t0.roles AS roles_48,
  t0.country_id AS country_id_49,
  t0.region_id AS region_id_50,
  t0.invoice_region_id AS invoice_region_id_51,
  t0.invoice_region_id AS invoice_region_id_52,
  t0.image_id AS image_id_53,
  t0.profile_image_id AS profile_image_id_54,
  t0.profile_advert AS profile_advert_55
FROM
  fos_user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.phone AS phone_3, t0.phone_mobile AS phone_mobile_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.street AS street_7, t0.geocode AS geocode_8, t0.www AS www_9, t0.comment AS comment_10, t0.pdo AS pdo_11, t0.invoice_nip AS invoice_nip_12, t0.invoice_company_name AS invoice_company_name_13, t0.invoice_name AS invoice_name_14, t0.invoice_postal_code AS invoice_postal_code_15, t0.invoice_city AS invoice_city_16, t0.invoice_street AS invoice_street_17, t0.invoice_phone AS invoice_phone_18, t0.invoice_delivery AS invoice_delivery_19, t0.invoice_delivery_name AS invoice_delivery_name_20, t0.invoice_delivery_postal_code AS invoice_delivery_postal_code_21, t0.invoice_delivery_city AS invoice_delivery_city_22, t0.invoice_delivery_street AS invoice_delivery_street_23, t0.profile_title_top AS profile_title_top_24, t0.profile_title_bottom AS profile_title_bottom_25, t0.deleted_at AS deleted_at_26, t0.userpage_home AS userpage_home_27, t0.lang AS lang_28, t0.last_activity AS last_activity_29, t0.profile_url AS profile_url_30, t0.expire_notify_at AS expire_notify_at_31, t0.expired_at AS expired_at_32, t0.test AS test_33, t0.powiat AS powiat_34, t0.about AS about_35, t0.views AS views_36, t0.name AS name_37, t0.username AS username_38, t0.username_canonical AS username_canonical_39, t0.email AS email_40, t0.email_canonical AS email_canonical_41, t0.enabled AS enabled_42, t0.salt AS salt_43, t0.password AS password_44, t0.last_login AS last_login_45, t0.confirmation_token AS confirmation_token_46, t0.password_requested_at AS password_requested_at_47, t0.roles AS roles_48, t0.country_id AS country_id_49, t0.region_id AS region_id_50, t0.invoice_region_id AS invoice_region_id_51, t0.invoice_region_id AS invoice_region_id_52, t0.image_id AS image_id_53, t0.profile_image_id AS profile_image_id_54, t0.profile_advert AS profile_advert_55 FROM fos_user t0 WHERE t0.id = 7487 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	Twig\Extension\CoreExtension::getAttribute (line 1869)
5	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8::block_content (line 569)
6	Twig\Template->yieldBlock (line 493)
7	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->doDisplay (line 74)
8	Twig\Template->yield (line 461)
9	Twig\Template->display (line 416)
10	Twig\Template->render (line 431)
11	Twig\TemplateWrapper->render (line 53)
12	Twig\Extension\CoreExtension->include (line 1575)
13	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5::block_body (line 140)
14	Twig\Template->yieldBlock (line 493)
15	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
16	Twig\Template->yield (line 461)
17	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 68)
18	Twig\Template->yield (line 461)
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)

9.42 ms
(0.90%)

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 (3, 4, 5, 6, 7);

#	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\SimpleObjectHydrator->hydrateAllData (line 65)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 748)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
13	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
14	App\Entity\AdvertCategory::__toString (line 142)
15	App\ORM\EntityRepository->findByQueryBuilder (line 20)
16	App\Handler\AdvertHandler->getSimilar (line 554)
17	App\Controller\AdvertController->getAdvertAction (line 122)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

7.81 ms
(0.74%)

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 (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)

7.45 ms
(0.71%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.currency AS currency_4, t0.phone_prefix AS phone_prefix_5, t0.code AS code_6 FROM country t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.currency AS currency_4,
  t0.phone_prefix AS phone_prefix_5,
  t0.code AS code_6
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.currency AS currency_4, t0.phone_prefix AS phone_prefix_5, t0.code AS code_6 FROM country t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Entity\Country::getName (line 92)
5	App\Twig\AppExtension->country (line 112)
6	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->block_content (line 686)
7	Twig\Template->yieldBlock (line 493)
8	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->doDisplay (line 74)
9	Twig\Template->yield (line 461)
10	Twig\Template->display (line 416)
11	Twig\Template->render (line 431)
12	Twig\TemplateWrapper->render (line 53)
13	Twig\Extension\CoreExtension->include (line 1575)
14	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5::block_body (line 140)
15	Twig\Template->yieldBlock (line 493)
16	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
17	Twig\Template->yield (line 461)
18	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 68)
19	Twig\Template->yield (line 461)
20	Twig\Template->display (line 416)
21	Twig\Template->render (line 431)
22	Twig\TemplateWrapper->render (line 53)
23	Twig\Environment->render (line 343)
24	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
25	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
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\EventListener\ControllerAttributesListener->afterController (line 87)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
37	Symfony\Component\HttpKernel\Kernel->handle (line 143)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
39	require_once (line 32)
40	require_once (line 5)

5.96 ms
(0.57%)

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:

[
  2145786
]

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 (2145786) 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->getOfferInfo (line 122)
10	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->doDisplay (line 64)
11	Twig\Template->yield (line 461)
12	Twig\Template->display (line 416)
13	Twig\Template->render (line 431)
14	Twig\TemplateWrapper->render (line 53)
15	Twig\Extension\CoreExtension->include (line 1575)
16	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5::block_body (line 140)
17	Twig\Template->yieldBlock (line 493)
18	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
19	Twig\Template->yield (line 461)
20	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 68)
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\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
27	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
28	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
29	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
31	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
32	Symfony\Component\HttpKernel\EventListener\ControllerAttributesListener->afterController (line 87)
33	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
34	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
35	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
36	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
39	Symfony\Component\HttpKernel\Kernel->handle (line 143)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
41	require_once (line 32)
42	require_once (line 5)

3.59 ms
(0.34%)

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:

[
  2
]

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);

#	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->load (line 748)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
8	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
9	App\Entity\AdvertCategory::__toString (line 142)
10	App\ORM\EntityRepository->findByQueryBuilder (line 20)
11	App\Handler\AdvertHandler->getSimilar (line 554)
12	App\Controller\AdvertController->getAdvertAction (line 122)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
15	Symfony\Component\HttpKernel\Kernel->handle (line 143)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

3.35 ms
(0.32%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.country_id AS country_id_3 FROM region t0 WHERE t0.id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country_id AS country_id_3
FROM
  region t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country_id AS country_id_3 FROM region t0 WHERE t0.id = 22;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Entity\Region::__toString (line 33)
5	Twig\Runtime\EscaperRuntime->escape (line 120)
6	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->block_content (line 2191)
7	Twig\Template->yieldBlock (line 493)
8	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->doDisplay (line 74)
9	Twig\Template->yield (line 461)
10	Twig\Template->display (line 416)
11	Twig\Template->render (line 431)
12	Twig\TemplateWrapper->render (line 53)
13	Twig\Extension\CoreExtension->include (line 1575)
14	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5::block_body (line 140)
15	Twig\Template->yieldBlock (line 493)
16	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
17	Twig\Template->yield (line 461)
18	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 68)
19	Twig\Template->yield (line 461)
20	Twig\Template->display (line 416)
21	Twig\Template->render (line 431)
22	Twig\TemplateWrapper->render (line 53)
23	Twig\Environment->render (line 343)
24	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
25	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
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\EventListener\ControllerAttributesListener->afterController (line 87)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
37	Symfony\Component\HttpKernel\Kernel->handle (line 143)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
39	require_once (line 32)
40	require_once (line 5)

1.72 ms
(0.16%)

SELECT t0.pay AS pay_1, t0.only_logged AS only_logged_2, t0.id AS id_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.price_from_to AS price_from_to_7, t0.hide_default_fields AS hide_default_fields_8, t0.fields AS fields_9, t0.package_group_id AS package_group_id_10 FROM advert_category t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.pay AS pay_1,
  t0.only_logged AS only_logged_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.price_from_to AS price_from_to_7,
  t0.hide_default_fields AS hide_default_fields_8,
  t0.fields AS fields_9,
  t0.package_group_id AS package_group_id_10
FROM
  advert_category t0
WHERE
  t0.id = ?

SELECT t0.pay AS pay_1, t0.only_logged AS only_logged_2, t0.id AS id_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.price_from_to AS price_from_to_7, t0.hide_default_fields AS hide_default_fields_8, t0.fields AS fields_9, t0.package_group_id AS package_group_id_10 FROM advert_category 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\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Entity\AdvertCategory::__toString (line 142)
5	App\ORM\EntityRepository->findByQueryBuilder (line 20)
6	App\Handler\AdvertHandler->getSimilar (line 554)
7	App\Controller\AdvertController->getAdvertAction (line 122)
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)

1.51 ms
(0.14%)

SELECT t0.id AS id_1, t0.added_at AS added_at_2, t0.advert_id AS advert_id_3, t0.user_id AS user_id_4 FROM advert_parking t0 WHERE t0.user_id IS NULL AND t0.advert_id = ? LIMIT 1

Parameters:

[
  2145786
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.added_at AS added_at_2,
  t0.advert_id AS advert_id_3,
  t0.user_id AS user_id_4
FROM
  advert_parking t0
WHERE
  t0.user_id IS NULL
  AND t0.advert_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.added_at AS added_at_2, t0.advert_id AS advert_id_3, t0.user_id AS user_id_4 FROM advert_parking t0 WHERE t0.user_id IS NULL AND t0.advert_id = 2145786 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	App\Controller\AdvertController->getAdvertAction (line 123)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
6	Symfony\Component\HttpKernel\Kernel->handle (line 143)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
8	require_once (line 32)
9	require_once (line 5)

1.49 ms
(0.14%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.price_pln AS price_pln_3, t0.price_eur AS price_eur_4, t0.duration AS duration_5 FROM promo t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price_pln AS price_pln_3,
  t0.price_eur AS price_eur_4,
  t0.duration AS duration_5
FROM
  promo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price_pln AS price_pln_3, t0.price_eur AS price_eur_4, t0.duration AS duration_5 FROM promo t0 WHERE t0.id = 1;

#	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	App\Controller\AdvertController->getAdvertAction (line 100)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
8	Symfony\Component\HttpKernel\Kernel->handle (line 143)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

1.24 ms
(0.12%)

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.98 ms
(0.09%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.if_promo AS if_promo_3, t0.active AS active_4, t0.sold AS sold_5, t0.expired_active AS expired_active_6, t0.views AS views_7, t0.deleted_at AS deleted_at_8, t0.email AS email_9, t0.title AS title_10, t0.slug AS slug_11, t0.currency AS currency_12, t0.grossnet AS grossnet_13, t0.price_negotiation AS price_negotiation_14, t0.price AS price_15, t0.price_pln AS price_pln_16, t0.price_eur AS price_eur_17, t0.price_usd AS price_usd_18, t0.price_to AS price_to_19, t0.price_to_pln AS price_to_pln_20, t0.price_to_eur AS price_to_eur_21, t0.price_to_usd AS price_to_usd_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.refreshed_at AS refreshed_at_25, t0.expired_at AS expired_at_26, t0.expire AS expire_27, t0.expire_notify_at AS expire_notify_at_28, t0.prices_updated_at AS prices_updated_at_29, t0.category_id AS category_id_30, t0.type_id AS type_id_31, t0.subtype_id AS subtype_id_32, t0.user_id AS user_id_33 FROM advert t0 WHERE t0.number = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "2145786"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.if_promo AS if_promo_3,
  t0.active AS active_4,
  t0.sold AS sold_5,
  t0.expired_active AS expired_active_6,
  t0.views AS views_7,
  t0.deleted_at AS deleted_at_8,
  t0.email AS email_9,
  t0.title AS title_10,
  t0.slug AS slug_11,
  t0.currency AS currency_12,
  t0.grossnet AS grossnet_13,
  t0.price_negotiation AS price_negotiation_14,
  t0.price AS price_15,
  t0.price_pln AS price_pln_16,
  t0.price_eur AS price_eur_17,
  t0.price_usd AS price_usd_18,
  t0.price_to AS price_to_19,
  t0.price_to_pln AS price_to_pln_20,
  t0.price_to_eur AS price_to_eur_21,
  t0.price_to_usd AS price_to_usd_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.refreshed_at AS refreshed_at_25,
  t0.expired_at AS expired_at_26,
  t0.expire AS expire_27,
  t0.expire_notify_at AS expire_notify_at_28,
  t0.prices_updated_at AS prices_updated_at_29,
  t0.category_id AS category_id_30,
  t0.type_id AS type_id_31,
  t0.subtype_id AS subtype_id_32,
  t0.user_id AS user_id_33
FROM
  advert t0
WHERE
  t0.number = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.number AS number_2, t0.if_promo AS if_promo_3, t0.active AS active_4, t0.sold AS sold_5, t0.expired_active AS expired_active_6, t0.views AS views_7, t0.deleted_at AS deleted_at_8, t0.email AS email_9, t0.title AS title_10, t0.slug AS slug_11, t0.currency AS currency_12, t0.grossnet AS grossnet_13, t0.price_negotiation AS price_negotiation_14, t0.price AS price_15, t0.price_pln AS price_pln_16, t0.price_eur AS price_eur_17, t0.price_usd AS price_usd_18, t0.price_to AS price_to_19, t0.price_to_pln AS price_to_pln_20, t0.price_to_eur AS price_to_eur_21, t0.price_to_usd AS price_to_usd_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.refreshed_at AS refreshed_at_25, t0.expired_at AS expired_at_26, t0.expire AS expire_27, t0.expire_notify_at AS expire_notify_at_28, t0.prices_updated_at AS prices_updated_at_29, t0.category_id AS category_id_30, t0.type_id AS type_id_31, t0.subtype_id AS subtype_id_32, t0.user_id AS user_id_33 FROM advert t0 WHERE t0.number = '2145786' AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	App\Handler\BaseHandler->get (line 25)
4	App\Controller\AdvertController->getAdvertAction (line 92)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.89 ms
(0.09%)

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:

[
  2145786
]

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 = 2145786 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->getIterator (line 253)
7	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->block_content (line 242)
8	Twig\Template->yieldBlock (line 493)
9	__TwigTemplate_8b13f2789e34bc9a4dc7a92ad181dfc8->doDisplay (line 74)
10	Twig\Template->yield (line 461)
11	Twig\Template->display (line 416)
12	Twig\Template->render (line 431)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Extension\CoreExtension->include (line 1575)
15	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5::block_body (line 140)
16	Twig\Template->yieldBlock (line 493)
17	__TwigTemplate_290825317f6a662bd6ee8bce4e335ac3->doDisplay (line 160)
18	Twig\Template->yield (line 461)
19	__TwigTemplate_29cefc3331f5c9c36fd593573e563ac5->doDisplay (line 68)
20	Twig\Template->yield (line 461)
21	Twig\Template->display (line 416)
22	Twig\Template->render (line 431)
23	Twig\TemplateWrapper->render (line 53)
24	Twig\Environment->render (line 343)
25	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 85)
26	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelControllerAttribute (line 44)
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\EventListener\ControllerAttributesListener->afterController (line 87)
32	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
33	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
34	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
35	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
38	Symfony\Component\HttpKernel\Kernel->handle (line 143)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
40	require_once (line 32)
41	require_once (line 5)

0.68 ms
(0.07%)

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, 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.64 ms
(0.06%)

SELECT t0.id AS id_1, t0.started_at AS started_at_2, t0.expired_at AS expired_at_3, t0.is_active AS is_active_4, t0.session_id AS session_id_5, t0.promo_id AS promo_id_6, t0.advert_id AS advert_id_7 FROM promo_adverts t0 WHERE t0.advert_id = ?

Parameters:

[
  2145786
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.started_at AS started_at_2,
  t0.expired_at AS expired_at_3,
  t0.is_active AS is_active_4,
  t0.session_id AS session_id_5,
  t0.promo_id AS promo_id_6,
  t0.advert_id AS advert_id_7
FROM
  promo_adverts t0
WHERE
  t0.advert_id = ?

SELECT t0.id AS id_1, t0.started_at AS started_at_2, t0.expired_at AS expired_at_3, t0.is_active AS is_active_4, t0.session_id AS session_id_5, t0.promo_id AS promo_id_6, t0.advert_id AS advert_id_7 FROM promo_adverts t0 WHERE t0.advert_id = 2145786;

#	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->filter (line 192)
7	App\Entity\Advert->getPromosByPromo (line 803)
8	App\Controller\AdvertController->getAdvertAction (line 100)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
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)

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	38
App\Entity\AdvertAttribute	17
App\Entity\AdvertCategory	8
App\Entity\AdvertType	8
App\Entity\Advert	6
App\Entity\User	5
App\Entity\PackageGroup	4
App\Entity\Promo	2
App\Entity\PromoAdverts	2
App\Entity\AdvertSubtype	2
App\Entity\Country	1
App\Entity\Region	1

Entities Mapping

Class	Mapping errors
App\Entity\Advert	No errors.
App\Entity\AdvertCategory	No errors.
App\Entity\AdvertType	No errors.
App\Entity\AdvertSubtype	No errors.
App\Entity\User	No errors.
App\Entity\PromoAdverts	No errors.
App\Entity\AdvertAttribute	No errors.
App\Entity\Image	No errors.
App\Entity\Promo	No errors.
App\Entity\PackageGroup	No errors.
App\Entity\Parking	No errors.
App\Entity\Make	No errors.
App\Entity\Country	No errors.
App\Entity\Region	No errors.
App\Entity\Payment	No errors.
App\Entity\UserPackage	No errors.
App\Entity\UserCommercial	No errors.

GET https://www.bushandel-sf8.pelp.pl/ogloszenia/autobusy/2145786/mercedes-benz-tourismo-17rhdl?url=ogloszenia%2Fautobusy%2F2145786%2Fmercedes-benz-tourismo-17rhdl

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping