Symfony Profiler

Query Metrics

61 Database Queries

19 Different statements

860.70 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

312.01 ms
(36.25%)

SELECT t0.id AS id_1, t0.adults AS adults_2, t0.teens AS teens_3, t0.children AS children_4, t0.babies AS babies_5, t0.is_default_config AS is_default_config_6, t0.room_id AS room_id_7 FROM room_capacities t0 WHERE t0.room_id = ?

Parameters:

[
  22
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.adults AS adults_2,
  t0.teens AS teens_3,
  t0.children AS children_4,
  t0.babies AS babies_5,
  t0.is_default_config AS is_default_config_6,
  t0.room_id AS room_id_7
FROM
  room_capacities t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.adults AS adults_2, t0.teens AS teens_3, t0.children AS children_4, t0.babies AS babies_5, t0.is_default_config AS is_default_config_6, t0.room_id AS room_id_7 FROM room_capacities t0 WHERE t0.room_id = 22;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1828)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1773)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 167)
8	App\DTO\SearchChambersDTO->hasMatchingRoomCapacity (line 587)
9	App\DTO\SearchToolsDTO->updateStayRooms (line 154)
10	App\Controller\HomeController->renderBesOffersCarousel (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
18	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
19	Twig\Template->yieldBlock (line 146)
20	Twig\Template->displayBlock (line 207)
21	Twig\Template->renderBlock (line 57)
22	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
25	Twig\Template->yield (line 354)
26	Twig\Template->display (line 369)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 306)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
33	App\Controller\BlogController->categoryList (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

69.76 ms
(8.10%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 INNER JOIN offers_extras_discounted ON t0.id = offers_extras_discounted.extra_charges_id WHERE offers_extras_discounted.offers_id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.adult_extra AS adult_extra_4,
  t0.baby_extra AS baby_extra_5,
  t0.child_extra AS child_extra_6,
  t0.teen_extra AS teen_extra_7,
  t0.stay_started_at AS stay_started_at_8,
  t0.stay_ended_at AS stay_ended_at_9,
  t0.is_active AS is_active_10,
  t0.is_mandatory AS is_mandatory_11,
  t0.min_nights AS min_nights_12,
  t0.hotel_id AS hotel_id_13
FROM
  extra_charges t0
  INNER JOIN offers_extras_discounted ON t0.id = offers_extras_discounted.extra_charges_id
WHERE
  offers_extras_discounted.offers_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 INNER JOIN offers_extras_discounted ON t0.id = offers_extras_discounted.extra_charges_id WHERE offers_extras_discounted.offers_id = 28;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1076)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1005)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1)
9	count (line 629)
10	App\DTO\PromotionDTO->isOfferValidForCurrentStay (line 1404)
11	App\DTO\SearchToolsDTO->getValidOffers (line 770)
12	App\DTO\SearchToolsDTO->applyOffers (line 752)
13	App\DTO\SearchToolsDTO->updateStayRooms (line 154)
14	App\Controller\HomeController->renderBesOffersCarousel (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
18	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
19	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
20	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
21	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
22	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
23	Twig\Template->yieldBlock (line 146)
24	Twig\Template->displayBlock (line 207)
25	Twig\Template->renderBlock (line 57)
26	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
29	Twig\Template->yield (line 354)
30	Twig\Template->display (line 369)
31	Twig\Template->render (line 38)
32	Twig\TemplateWrapper->render (line 306)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
37	App\Controller\BlogController->categoryList (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

69.56 ms
(8.08%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 INNER JOIN offers_extra_charges ON t0.id = offers_extra_charges.extra_charges_id WHERE offers_extra_charges.offers_id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.adult_extra AS adult_extra_4,
  t0.baby_extra AS baby_extra_5,
  t0.child_extra AS child_extra_6,
  t0.teen_extra AS teen_extra_7,
  t0.stay_started_at AS stay_started_at_8,
  t0.stay_ended_at AS stay_ended_at_9,
  t0.is_active AS is_active_10,
  t0.is_mandatory AS is_mandatory_11,
  t0.min_nights AS min_nights_12,
  t0.hotel_id AS hotel_id_13
FROM
  extra_charges t0
  INNER JOIN offers_extra_charges ON t0.id = offers_extra_charges.extra_charges_id
WHERE
  offers_extra_charges.offers_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 INNER JOIN offers_extra_charges ON t0.id = offers_extra_charges.extra_charges_id WHERE offers_extra_charges.offers_id = 28;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1076)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1005)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1)
9	count (line 619)
10	App\DTO\PromotionDTO->isOfferValidForCurrentStay (line 1404)
11	App\DTO\SearchToolsDTO->getValidOffers (line 770)
12	App\DTO\SearchToolsDTO->applyOffers (line 752)
13	App\DTO\SearchToolsDTO->updateStayRooms (line 154)
14	App\Controller\HomeController->renderBesOffersCarousel (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
18	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
19	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
20	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
21	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
22	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
23	Twig\Template->yieldBlock (line 146)
24	Twig\Template->displayBlock (line 207)
25	Twig\Template->renderBlock (line 57)
26	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
29	Twig\Template->yield (line 354)
30	Twig\Template->display (line 369)
31	Twig\Template->render (line 38)
32	Twig\TemplateWrapper->render (line 306)
33	Twig\Environment->render (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
37	App\Controller\BlogController->categoryList (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
40	Symfony\Component\HttpKernel\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 5)

56.20 ms
(6.53%)

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, r1_.id AS id_3, r1_.name AS name_4, r1_.description AS description_5, r1_.active AS active_6, r1_.created_at AS created_at_7, r1_.updated_at AS updated_at_8, r1_.featured_image AS featured_image_9, r1_.services AS services_10, r1_.slug AS slug_11, s0_.room_id AS room_id_12, r1_.hotel_id AS hotel_id_13 FROM stop_sales s0_ LEFT JOIN rooms r1_ ON s0_.room_id = r1_.id WHERE (s0_.start_at <= ? AND s0_.end_at >= ?) ORDER BY s0_.id ASC

Parameters:

[
  "2024-12-08 23:59:00"
  "2024-12-01 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.start_at AS start_at_1,
  s0_.end_at AS end_at_2,
  r1_.id AS id_3,
  r1_.name AS name_4,
  r1_.description AS description_5,
  r1_.active AS active_6,
  r1_.created_at AS created_at_7,
  r1_.updated_at AS updated_at_8,
  r1_.featured_image AS featured_image_9,
  r1_.services AS services_10,
  r1_.slug AS slug_11,
  s0_.room_id AS room_id_12,
  r1_.hotel_id AS hotel_id_13
FROM
  stop_sales s0_
  LEFT JOIN rooms r1_ ON s0_.room_id = r1_.id
WHERE
  (
    s0_.start_at <= ?
    AND s0_.end_at >= ?
  )
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, r1_.id AS id_3, r1_.name AS name_4, r1_.description AS description_5, r1_.active AS active_6, r1_.created_at AS created_at_7, r1_.updated_at AS updated_at_8, r1_.featured_image AS featured_image_9, r1_.services AS services_10, r1_.slug AS slug_11, s0_.room_id AS room_id_12, r1_.hotel_id AS hotel_id_13 FROM stop_sales s0_ LEFT JOIN rooms r1_ ON s0_.room_id = r1_.id WHERE (s0_.start_at <= '2024-12-08 23:59:00' AND s0_.end_at >= '2024-12-01 00:00:00') ORDER BY s0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 43)
7	App\Repository\StopSalesRepository->findStopSalesByStayDates (line 107)
8	App\Repository\HotelsRepository->findAvailableHotelRoomsBySearch (line 148)
9	App\Controller\HomeController->renderBesOffersCarousel (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
17	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
18	Twig\Template->yieldBlock (line 146)
19	Twig\Template->displayBlock (line 207)
20	Twig\Template->renderBlock (line 57)
21	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
22	Twig\Template->yield (line 54)
23	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
24	Twig\Template->yield (line 354)
25	Twig\Template->display (line 369)
26	Twig\Template->render (line 38)
27	Twig\TemplateWrapper->render (line 306)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
32	App\Controller\BlogController->categoryList (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

55.62 ms
(6.46%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.description AS description_4, t0.stay_start_at AS stay_start_at_5, t0.stay_end_at AS stay_end_at_6, t0.booking_start_at AS booking_start_at_7, t0.booking_end_at AS booking_end_at_8, t0.reference AS reference_9, t0.min_nights AS min_nights_10, t0.max_nights AS max_nights_11, t0.early_booking_days AS early_booking_days_12, t0.apply_to_all_rooms AS apply_to_all_rooms_13, t0.discount AS discount_14, t0.combinable AS combinable_15, t0.combinable_discount AS combinable_discount_16, t0.active AS active_17, t0.extras_discount AS extras_discount_18, t0.priority AS priority_19, t0.discount_kids1 AS discount_kids1_20, t0.discount_kids2 AS discount_kids2_21, t0.discount_kids3 AS discount_kids3_22, t0.hotel_id AS hotel_id_23 FROM offers t0 WHERE t0.hotel_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.description AS description_4,
  t0.stay_start_at AS stay_start_at_5,
  t0.stay_end_at AS stay_end_at_6,
  t0.booking_start_at AS booking_start_at_7,
  t0.booking_end_at AS booking_end_at_8,
  t0.reference AS reference_9,
  t0.min_nights AS min_nights_10,
  t0.max_nights AS max_nights_11,
  t0.early_booking_days AS early_booking_days_12,
  t0.apply_to_all_rooms AS apply_to_all_rooms_13,
  t0.discount AS discount_14,
  t0.combinable AS combinable_15,
  t0.combinable_discount AS combinable_discount_16,
  t0.active AS active_17,
  t0.extras_discount AS extras_discount_18,
  t0.priority AS priority_19,
  t0.discount_kids1 AS discount_kids1_20,
  t0.discount_kids2 AS discount_kids2_21,
  t0.discount_kids3 AS discount_kids3_22,
  t0.hotel_id AS hotel_id_23
FROM
  offers t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.description AS description_4, t0.stay_start_at AS stay_start_at_5, t0.stay_end_at AS stay_end_at_6, t0.booking_start_at AS booking_start_at_7, t0.booking_end_at AS booking_end_at_8, t0.reference AS reference_9, t0.min_nights AS min_nights_10, t0.max_nights AS max_nights_11, t0.early_booking_days AS early_booking_days_12, t0.apply_to_all_rooms AS apply_to_all_rooms_13, t0.discount AS discount_14, t0.combinable AS combinable_15, t0.combinable_discount AS combinable_discount_16, t0.active AS active_17, t0.extras_discount AS extras_discount_18, t0.priority AS priority_19, t0.discount_kids1 AS discount_kids1_20, t0.discount_kids2 AS discount_kids2_21, t0.discount_kids3 AS discount_kids3_22, t0.hotel_id AS hotel_id_23 FROM offers t0 WHERE t0.hotel_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1828)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1773)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 751)
9	App\DTO\SearchToolsDTO->updateStayRooms (line 154)
10	App\Controller\HomeController->renderBesOffersCarousel (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
18	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
19	Twig\Template->yieldBlock (line 146)
20	Twig\Template->displayBlock (line 207)
21	Twig\Template->renderBlock (line 57)
22	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
25	Twig\Template->yield (line 354)
26	Twig\Template->display (line 369)
27	Twig\Template->render (line 38)
28	Twig\TemplateWrapper->render (line 306)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
33	App\Controller\BlogController->categoryList (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

55.47 ms
(6.44%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 WHERE t0.hotel_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.adult_extra AS adult_extra_4,
  t0.baby_extra AS baby_extra_5,
  t0.child_extra AS child_extra_6,
  t0.teen_extra AS teen_extra_7,
  t0.stay_started_at AS stay_started_at_8,
  t0.stay_ended_at AS stay_ended_at_9,
  t0.is_active AS is_active_10,
  t0.is_mandatory AS is_mandatory_11,
  t0.min_nights AS min_nights_12,
  t0.hotel_id AS hotel_id_13
FROM
  extra_charges t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 WHERE t0.hotel_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1828)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1773)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1)
9	sizeof (line 1027)
10	App\DTO\SearchToolsDTO->calculateStayExtras (line 711)
11	App\DTO\SearchToolsDTO->updateStayRooms (line 154)
12	App\Controller\HomeController->renderBesOffersCarousel (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
16	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
17	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
18	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
19	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
20	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
21	Twig\Template->yieldBlock (line 146)
22	Twig\Template->displayBlock (line 207)
23	Twig\Template->renderBlock (line 57)
24	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
27	Twig\Template->yield (line 354)
28	Twig\Template->display (line 369)
29	Twig\Template->render (line 38)
30	Twig\TemplateWrapper->render (line 306)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
35	App\Controller\BlogController->categoryList (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 5)

53.84 ms
(6.26%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.hotel_id AS hotel_id_3, t0.room_id AS room_id_4 FROM galleries t0 WHERE t0.hotel_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.hotel_id AS hotel_id_3,
  t0.room_id AS room_id_4
FROM
  galleries t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.hotel_id AS hotel_id_3, t0.room_id AS room_id_4 FROM galleries t0 WHERE t0.hotel_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 833)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2440)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 491)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 168)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
10	Doctrine\ORM\AbstractQuery->execute (line 689)
11	Doctrine\ORM\AbstractQuery->getResult (line 394)
12	App\Repository\HotelsRepository->findHighlightActiveHotels (line 115)
13	App\Controller\HomeController->renderBesOffersCarousel (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
17	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
18	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
19	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
20	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
21	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
22	Twig\Template->yieldBlock (line 146)
23	Twig\Template->displayBlock (line 207)
24	Twig\Template->renderBlock (line 57)
25	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
26	Twig\Template->yield (line 54)
27	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
28	Twig\Template->yield (line 354)
29	Twig\Template->display (line 369)
30	Twig\Template->render (line 38)
31	Twig\TemplateWrapper->render (line 306)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
36	App\Controller\BlogController->categoryList (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

28.49 ms
(3.31%)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 13 AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500

Parameters:

[
  "2024-12-06 23:59:00"
  "2024-11-29 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.website AS website_3,
  h0_.stars AS stars_4,
  h0_.youtube_video_id AS youtube_video_id_5,
  h0_.phone AS phone_6,
  h0_.email AS email_7,
  h0_.active AS active_8,
  h0_.gmap_url AS gmap_url_9,
  h0_.zone AS zone_10,
  h0_.created_at AS created_at_11,
  h0_.updated_at AS updated_at_12,
  h0_.address AS address_13,
  h0_.check_in_time AS check_in_time_14,
  h0_.check_out_time AS check_out_time_15,
  h0_.baby_age_max AS baby_age_max_16,
  h0_.child_age_max AS child_age_max_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.featured_image AS featured_image_19,
  h0_.highlighted AS highlighted_20,
  h0_.services AS services_21,
  h0_.hl_start_at AS hl_start_at_22,
  h0_.hl_end_at AS hl_end_at_23,
  h0_.slug AS slug_24,
  r1_.id AS id_25,
  r1_.name AS name_26,
  r1_.description AS description_27,
  r1_.active AS active_28,
  r1_.created_at AS created_at_29,
  r1_.updated_at AS updated_at_30,
  r1_.featured_image AS featured_image_31,
  r1_.services AS services_32,
  r1_.slug AS slug_33,
  r2_.id AS id_34,
  r2_.title AS title_35,
  r2_.quantity AS quantity_36,
  r2_.stay_started_at AS stay_started_at_37,
  r2_.stay_ended_at AS stay_ended_at_38,
  r2_.sale_started_at AS sale_started_at_39,
  r2_.sale_ended_at AS sale_ended_at_40,
  r2_.min_nights AS min_nights_41,
  r2_.double_occupancy AS double_occupancy_42,
  r2_.single_occupancy AS single_occupancy_43,
  r2_.triple_occupancy AS triple_occupancy_44,
  r2_.active AS active_45,
  r2_.extra_baby AS extra_baby_46,
  r2_.extra_child AS extra_child_47,
  r2_.extra_teen AS extra_teen_48,
  r2_.default_extra_label AS default_extra_label_49,
  g3_.id AS id_50,
  g3_.title AS title_51,
  g4_.id AS id_52,
  g4_.title AS title_53,
  r1_.hotel_id AS hotel_id_54,
  r2_.room_id AS room_id_55,
  g3_.hotel_id AS hotel_id_56,
  g3_.room_id AS room_id_57,
  g4_.hotel_id AS hotel_id_58,
  g4_.room_id AS room_id_59
FROM
  hotels h0_
  LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id
  LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id
  LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id
  LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id
WHERE
  h0_.active = 1
  AND r1_.active = 1
  AND r2_.active = 1
  AND h0_.id = 13
  AND (
    r2_.stay_started_at <= ?
    AND r2_.stay_ended_at >= ?
  )
ORDER BY
  h0_.name ASC,
  r2_.stay_started_at ASC
LIMIT
  500

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 13 AND (r2_.stay_started_at <= '2024-12-06 23:59:00' AND r2_.stay_ended_at >= '2024-11-29 00:00:00') ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 133)
7	App\Repository\HotelsRepository->findAvailableHotelRoomsBySearch (line 148)
8	App\Controller\HomeController->renderBesOffersCarousel (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
16	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
17	Twig\Template->yieldBlock (line 146)
18	Twig\Template->displayBlock (line 207)
19	Twig\Template->renderBlock (line 57)
20	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
23	Twig\Template->yield (line 354)
24	Twig\Template->display (line 369)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 306)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
31	App\Controller\BlogController->categoryList (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

17.56 ms
(2.04%)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 17 AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500

Parameters:

[
  "2024-11-06 23:59:00"
  "2024-10-30 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.website AS website_3,
  h0_.stars AS stars_4,
  h0_.youtube_video_id AS youtube_video_id_5,
  h0_.phone AS phone_6,
  h0_.email AS email_7,
  h0_.active AS active_8,
  h0_.gmap_url AS gmap_url_9,
  h0_.zone AS zone_10,
  h0_.created_at AS created_at_11,
  h0_.updated_at AS updated_at_12,
  h0_.address AS address_13,
  h0_.check_in_time AS check_in_time_14,
  h0_.check_out_time AS check_out_time_15,
  h0_.baby_age_max AS baby_age_max_16,
  h0_.child_age_max AS child_age_max_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.featured_image AS featured_image_19,
  h0_.highlighted AS highlighted_20,
  h0_.services AS services_21,
  h0_.hl_start_at AS hl_start_at_22,
  h0_.hl_end_at AS hl_end_at_23,
  h0_.slug AS slug_24,
  r1_.id AS id_25,
  r1_.name AS name_26,
  r1_.description AS description_27,
  r1_.active AS active_28,
  r1_.created_at AS created_at_29,
  r1_.updated_at AS updated_at_30,
  r1_.featured_image AS featured_image_31,
  r1_.services AS services_32,
  r1_.slug AS slug_33,
  r2_.id AS id_34,
  r2_.title AS title_35,
  r2_.quantity AS quantity_36,
  r2_.stay_started_at AS stay_started_at_37,
  r2_.stay_ended_at AS stay_ended_at_38,
  r2_.sale_started_at AS sale_started_at_39,
  r2_.sale_ended_at AS sale_ended_at_40,
  r2_.min_nights AS min_nights_41,
  r2_.double_occupancy AS double_occupancy_42,
  r2_.single_occupancy AS single_occupancy_43,
  r2_.triple_occupancy AS triple_occupancy_44,
  r2_.active AS active_45,
  r2_.extra_baby AS extra_baby_46,
  r2_.extra_child AS extra_child_47,
  r2_.extra_teen AS extra_teen_48,
  r2_.default_extra_label AS default_extra_label_49,
  g3_.id AS id_50,
  g3_.title AS title_51,
  g4_.id AS id_52,
  g4_.title AS title_53,
  r1_.hotel_id AS hotel_id_54,
  r2_.room_id AS room_id_55,
  g3_.hotel_id AS hotel_id_56,
  g3_.room_id AS room_id_57,
  g4_.hotel_id AS hotel_id_58,
  g4_.room_id AS room_id_59
FROM
  hotels h0_
  LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id
  LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id
  LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id
  LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id
WHERE
  h0_.active = 1
  AND r1_.active = 1
  AND r2_.active = 1
  AND h0_.id = 17
  AND (
    r2_.stay_started_at <= ?
    AND r2_.stay_ended_at >= ?
  )
ORDER BY
  h0_.name ASC,
  r2_.stay_started_at ASC
LIMIT
  500

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 17 AND (r2_.stay_started_at <= '2024-11-06 23:59:00' AND r2_.stay_ended_at >= '2024-10-30 00:00:00') ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 133)
7	App\Repository\HotelsRepository->findAvailableHotelRoomsBySearch (line 148)
8	App\Controller\HomeController->renderBesOffersCarousel (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
16	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
17	Twig\Template->yieldBlock (line 146)
18	Twig\Template->displayBlock (line 207)
19	Twig\Template->renderBlock (line 57)
20	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
23	Twig\Template->yield (line 354)
24	Twig\Template->display (line 369)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 306)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
31	App\Controller\BlogController->categoryList (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

16.14 ms
(1.88%)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 4 AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500

Parameters:

[
  "2024-12-08 23:59:00"
  "2024-12-01 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.website AS website_3,
  h0_.stars AS stars_4,
  h0_.youtube_video_id AS youtube_video_id_5,
  h0_.phone AS phone_6,
  h0_.email AS email_7,
  h0_.active AS active_8,
  h0_.gmap_url AS gmap_url_9,
  h0_.zone AS zone_10,
  h0_.created_at AS created_at_11,
  h0_.updated_at AS updated_at_12,
  h0_.address AS address_13,
  h0_.check_in_time AS check_in_time_14,
  h0_.check_out_time AS check_out_time_15,
  h0_.baby_age_max AS baby_age_max_16,
  h0_.child_age_max AS child_age_max_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.featured_image AS featured_image_19,
  h0_.highlighted AS highlighted_20,
  h0_.services AS services_21,
  h0_.hl_start_at AS hl_start_at_22,
  h0_.hl_end_at AS hl_end_at_23,
  h0_.slug AS slug_24,
  r1_.id AS id_25,
  r1_.name AS name_26,
  r1_.description AS description_27,
  r1_.active AS active_28,
  r1_.created_at AS created_at_29,
  r1_.updated_at AS updated_at_30,
  r1_.featured_image AS featured_image_31,
  r1_.services AS services_32,
  r1_.slug AS slug_33,
  r2_.id AS id_34,
  r2_.title AS title_35,
  r2_.quantity AS quantity_36,
  r2_.stay_started_at AS stay_started_at_37,
  r2_.stay_ended_at AS stay_ended_at_38,
  r2_.sale_started_at AS sale_started_at_39,
  r2_.sale_ended_at AS sale_ended_at_40,
  r2_.min_nights AS min_nights_41,
  r2_.double_occupancy AS double_occupancy_42,
  r2_.single_occupancy AS single_occupancy_43,
  r2_.triple_occupancy AS triple_occupancy_44,
  r2_.active AS active_45,
  r2_.extra_baby AS extra_baby_46,
  r2_.extra_child AS extra_child_47,
  r2_.extra_teen AS extra_teen_48,
  r2_.default_extra_label AS default_extra_label_49,
  g3_.id AS id_50,
  g3_.title AS title_51,
  g4_.id AS id_52,
  g4_.title AS title_53,
  r1_.hotel_id AS hotel_id_54,
  r2_.room_id AS room_id_55,
  g3_.hotel_id AS hotel_id_56,
  g3_.room_id AS room_id_57,
  g4_.hotel_id AS hotel_id_58,
  g4_.room_id AS room_id_59
FROM
  hotels h0_
  LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id
  LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id
  LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id
  LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id
WHERE
  h0_.active = 1
  AND r1_.active = 1
  AND r2_.active = 1
  AND h0_.id = 4
  AND (
    r2_.stay_started_at <= ?
    AND r2_.stay_ended_at >= ?
  )
ORDER BY
  h0_.name ASC,
  r2_.stay_started_at ASC
LIMIT
  500

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 4 AND (r2_.stay_started_at <= '2024-12-08 23:59:00' AND r2_.stay_ended_at >= '2024-12-01 00:00:00') ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 133)
7	App\Repository\HotelsRepository->findAvailableHotelRoomsBySearch (line 148)
8	App\Controller\HomeController->renderBesOffersCarousel (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
16	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
17	Twig\Template->yieldBlock (line 146)
18	Twig\Template->displayBlock (line 207)
19	Twig\Template->renderBlock (line 57)
20	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
23	Twig\Template->yield (line 354)
24	Twig\Template->display (line 369)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 306)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
31	App\Controller\BlogController->categoryList (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

15.86 ms
(1.84%)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 26 AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500

Parameters:

[
  "2024-11-24 23:59:00"
  "2024-11-20 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.website AS website_3,
  h0_.stars AS stars_4,
  h0_.youtube_video_id AS youtube_video_id_5,
  h0_.phone AS phone_6,
  h0_.email AS email_7,
  h0_.active AS active_8,
  h0_.gmap_url AS gmap_url_9,
  h0_.zone AS zone_10,
  h0_.created_at AS created_at_11,
  h0_.updated_at AS updated_at_12,
  h0_.address AS address_13,
  h0_.check_in_time AS check_in_time_14,
  h0_.check_out_time AS check_out_time_15,
  h0_.baby_age_max AS baby_age_max_16,
  h0_.child_age_max AS child_age_max_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.featured_image AS featured_image_19,
  h0_.highlighted AS highlighted_20,
  h0_.services AS services_21,
  h0_.hl_start_at AS hl_start_at_22,
  h0_.hl_end_at AS hl_end_at_23,
  h0_.slug AS slug_24,
  r1_.id AS id_25,
  r1_.name AS name_26,
  r1_.description AS description_27,
  r1_.active AS active_28,
  r1_.created_at AS created_at_29,
  r1_.updated_at AS updated_at_30,
  r1_.featured_image AS featured_image_31,
  r1_.services AS services_32,
  r1_.slug AS slug_33,
  r2_.id AS id_34,
  r2_.title AS title_35,
  r2_.quantity AS quantity_36,
  r2_.stay_started_at AS stay_started_at_37,
  r2_.stay_ended_at AS stay_ended_at_38,
  r2_.sale_started_at AS sale_started_at_39,
  r2_.sale_ended_at AS sale_ended_at_40,
  r2_.min_nights AS min_nights_41,
  r2_.double_occupancy AS double_occupancy_42,
  r2_.single_occupancy AS single_occupancy_43,
  r2_.triple_occupancy AS triple_occupancy_44,
  r2_.active AS active_45,
  r2_.extra_baby AS extra_baby_46,
  r2_.extra_child AS extra_child_47,
  r2_.extra_teen AS extra_teen_48,
  r2_.default_extra_label AS default_extra_label_49,
  g3_.id AS id_50,
  g3_.title AS title_51,
  g4_.id AS id_52,
  g4_.title AS title_53,
  r1_.hotel_id AS hotel_id_54,
  r2_.room_id AS room_id_55,
  g3_.hotel_id AS hotel_id_56,
  g3_.room_id AS room_id_57,
  g4_.hotel_id AS hotel_id_58,
  g4_.room_id AS room_id_59
FROM
  hotels h0_
  LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id
  LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id
  LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id
  LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id
WHERE
  h0_.active = 1
  AND r1_.active = 1
  AND r2_.active = 1
  AND h0_.id = 26
  AND (
    r2_.stay_started_at <= ?
    AND r2_.stay_ended_at >= ?
  )
ORDER BY
  h0_.name ASC,
  r2_.stay_started_at ASC
LIMIT
  500

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id = 26 AND (r2_.stay_started_at <= '2024-11-24 23:59:00' AND r2_.stay_ended_at >= '2024-11-20 00:00:00') ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 133)
7	App\Repository\HotelsRepository->findAvailableHotelRoomsBySearch (line 148)
8	App\Controller\HomeController->renderBesOffersCarousel (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
16	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
17	Twig\Template->yieldBlock (line 146)
18	Twig\Template->displayBlock (line 207)
19	Twig\Template->renderBlock (line 57)
20	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
23	Twig\Template->yield (line 354)
24	Twig\Template->display (line 369)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 306)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
31	App\Controller\BlogController->categoryList (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

14.32 ms
(1.66%)

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.btn_label AS btn_label_3, s0_.btn_link AS btn_link_4, s0_.bg_image AS bg_image_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.active AS active_8, s0_.hook AS hook_9 FROM slides s0_ WHERE s0_.active = 1 AND s0_.hook IS NULL ORDER BY s0_.id ASC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.description AS description_2,
  s0_.btn_label AS btn_label_3,
  s0_.btn_link AS btn_link_4,
  s0_.bg_image AS bg_image_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s0_.active AS active_8,
  s0_.hook AS hook_9
FROM
  slides s0_
WHERE
  s0_.active = 1
  AND s0_.hook IS NULL
ORDER BY
  s0_.id ASC
LIMIT
  10

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.btn_label AS btn_label_3, s0_.btn_link AS btn_link_4, s0_.bg_image AS bg_image_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.active AS active_8, s0_.hook AS hook_9 FROM slides s0_ WHERE s0_.active = 1 AND s0_.hook IS NULL ORDER BY s0_.id ASC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 32)
7	App\Repository\SlidesRepository->getActiveSlides (line 100)
8	App\Controller\HomeController->renderHeadingSlider (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 176)
16	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
19	Twig\Template->yield (line 354)
20	Twig\Template->display (line 369)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 306)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
27	App\Controller\BlogController->categoryList (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

14.05 ms
(1.63%)

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24 FROM hotels h0_ WHERE h0_.active = 1 AND h0_.highlighted = 1 LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.website AS website_3,
  h0_.stars AS stars_4,
  h0_.youtube_video_id AS youtube_video_id_5,
  h0_.phone AS phone_6,
  h0_.email AS email_7,
  h0_.active AS active_8,
  h0_.gmap_url AS gmap_url_9,
  h0_.zone AS zone_10,
  h0_.created_at AS created_at_11,
  h0_.updated_at AS updated_at_12,
  h0_.address AS address_13,
  h0_.check_in_time AS check_in_time_14,
  h0_.check_out_time AS check_out_time_15,
  h0_.baby_age_max AS baby_age_max_16,
  h0_.child_age_max AS child_age_max_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.featured_image AS featured_image_19,
  h0_.highlighted AS highlighted_20,
  h0_.services AS services_21,
  h0_.hl_start_at AS hl_start_at_22,
  h0_.hl_end_at AS hl_end_at_23,
  h0_.slug AS slug_24
FROM
  hotels h0_
WHERE
  h0_.active = 1
  AND h0_.highlighted = 1
LIMIT
  10

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24 FROM hotels h0_ WHERE h0_.active = 1 AND h0_.highlighted = 1 LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 394)
7	App\Repository\HotelsRepository->findHighlightActiveHotels (line 115)
8	App\Controller\HomeController->renderBesOffersCarousel (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 232)
16	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->block_body (line 442)
17	Twig\Template->yieldBlock (line 146)
18	Twig\Template->displayBlock (line 207)
19	Twig\Template->renderBlock (line 57)
20	__TwigTemplate_36be5274681fda43634aa9a2bee47968->doDisplay (line 398)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_1b1901b2dfeb8314a30adec4754da881->doDisplay (line 398)
23	Twig\Template->yield (line 354)
24	Twig\Template->display (line 369)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 306)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
31	App\Controller\BlogController->categoryList (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

13.96 ms
(1.62%)

SELECT count(p0_.id) AS sclr_0 FROM posts p0_ LEFT JOIN categories c1_ ON p0_.categories_id = c1_.id WHERE p0_.is_active = 1 AND c1_.id LIKE ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(p0_.id) AS sclr_0
FROM
  posts p0_
  LEFT JOIN categories c1_ ON p0_.categories_id = c1_.id
WHERE
  p0_.is_active = 1
  AND c1_.id LIKE ?

SELECT count(p0_.id) AS sclr_0 FROM posts p0_ LEFT JOIN categories c1_ ON p0_.categories_id = c1_.id WHERE p0_.is_active = 1 AND c1_.id LIKE 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container3wbxnxo\PaginatorProxyBa079e5->paginate (line 156)
16	App\Repository\PostsRepository->paginationPostsByCategoryId (line 126)
17	App\Controller\BlogController->categoryList (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

13.83 ms
(1.61%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.featured_image AS featured_image_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.uploaded_at AS uploaded_at_8, p0_.is_highlighted AS is_highlighted_9, p0_.is_active AS is_active_10, p0_.popular AS popular_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, p0_.users_id AS users_id_15, p0_.categories_id AS categories_id_16 FROM posts p0_ LEFT JOIN categories c1_ ON p0_.categories_id = c1_.id WHERE p0_.is_active = 1 AND c1_.id LIKE ? ORDER BY p0_.id DESC LIMIT 12

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.keywords AS keywords_3,
  p0_.content AS content_4,
  p0_.featured_image AS featured_image_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.uploaded_at AS uploaded_at_8,
  p0_.is_highlighted AS is_highlighted_9,
  p0_.is_active AS is_active_10,
  p0_.popular AS popular_11,
  c1_.id AS id_12,
  c1_.name AS name_13,
  c1_.slug AS slug_14,
  p0_.users_id AS users_id_15,
  p0_.categories_id AS categories_id_16
FROM
  posts p0_
  LEFT JOIN categories c1_ ON p0_.categories_id = c1_.id
WHERE
  p0_.is_active = 1
  AND c1_.id LIKE ?
ORDER BY
  p0_.id DESC
LIMIT
  12

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.featured_image AS featured_image_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.uploaded_at AS uploaded_at_8, p0_.is_highlighted AS is_highlighted_9, p0_.is_active AS is_active_10, p0_.popular AS popular_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, p0_.users_id AS users_id_15, p0_.categories_id AS categories_id_16 FROM posts p0_ LEFT JOIN categories c1_ ON p0_.categories_id = c1_.id WHERE p0_.is_active = 1 AND c1_.id LIKE 1 ORDER BY p0_.id DESC LIMIT 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 151)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 98)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	Container3wbxnxo\PaginatorProxyBa079e5->paginate (line 156)
16	App\Repository\PostsRepository->paginationPostsByCategoryId (line 126)
17	App\Controller\BlogController->categoryList (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

13.70 ms
(1.59%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.featured_image AS featured_image_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.uploaded_at AS uploaded_at_8, p0_.is_highlighted AS is_highlighted_9, p0_.is_active AS is_active_10, p0_.popular AS popular_11, p0_.users_id AS users_id_12, p0_.categories_id AS categories_id_13 FROM posts p0_ WHERE p0_.popular = 1 AND p0_.is_active = 1 ORDER BY p0_.id DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.keywords AS keywords_3,
  p0_.content AS content_4,
  p0_.featured_image AS featured_image_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.uploaded_at AS uploaded_at_8,
  p0_.is_highlighted AS is_highlighted_9,
  p0_.is_active AS is_active_10,
  p0_.popular AS popular_11,
  p0_.users_id AS users_id_12,
  p0_.categories_id AS categories_id_13
FROM
  posts p0_
WHERE
  p0_.popular = 1
  AND p0_.is_active = 1
ORDER BY
  p0_.id DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.keywords AS keywords_3, p0_.content AS content_4, p0_.featured_image AS featured_image_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.uploaded_at AS uploaded_at_8, p0_.is_highlighted AS is_highlighted_9, p0_.is_active AS is_active_10, p0_.popular AS popular_11, p0_.users_id AS users_id_12, p0_.categories_id AS categories_id_13 FROM posts p0_ WHERE p0_.popular = 1 AND p0_.is_active = 1 ORDER BY p0_.id DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 79)
7	App\Repository\PostsRepository->getPopulars (line 134)
8	App\Controller\BlogController->categoryList (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

13.69 ms
(1.59%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM categories t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "hotels"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  categories t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM categories t0 WHERE t0.slug = 'hotels' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 116)
5	App\Controller\BlogController->categoryList (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

13.33 ms
(1.55%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.keywords AS keywords_4, t0.content AS content_5, t0.featured_image AS featured_image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.uploaded_at AS uploaded_at_9, t0.is_highlighted AS is_highlighted_10, t0.is_active AS is_active_11, t0.popular AS popular_12, t0.users_id AS users_id_13, t0.categories_id AS categories_id_14 FROM posts t0 WHERE t0.is_highlighted = ? ORDER BY t0.id DESC LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.keywords AS keywords_4,
  t0.content AS content_5,
  t0.featured_image AS featured_image_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.uploaded_at AS uploaded_at_9,
  t0.is_highlighted AS is_highlighted_10,
  t0.is_active AS is_active_11,
  t0.popular AS popular_12,
  t0.users_id AS users_id_13,
  t0.categories_id AS categories_id_14
FROM
  posts t0
WHERE
  t0.is_highlighted = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.keywords AS keywords_4, t0.content AS content_5, t0.featured_image AS featured_image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.uploaded_at AS uploaded_at_9, t0.is_highlighted AS is_highlighted_10, t0.is_active AS is_active_11, t0.popular AS popular_12, t0.users_id AS users_id_13, t0.categories_id AS categories_id_14 FROM posts t0 WHERE t0.is_highlighted = 1 ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 132)
5	App\Controller\BlogController->categoryList (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

13.32 ms
(1.55%)

SELECT p0_.keywords AS keywords_0 FROM posts p0_ WHERE p0_.is_active = 1 ORDER BY p0_.id DESC LIMIT 100

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.keywords AS keywords_0
FROM
  posts p0_
WHERE
  p0_.is_active = 1
ORDER BY
  p0_.id DESC
LIMIT
  100

SELECT p0_.keywords AS keywords_0 FROM posts p0_ WHERE p0_.is_active = 1 ORDER BY p0_.id DESC LIMIT 100;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 92)
7	App\Repository\PostsRepository->getOnlyTags (line 135)
8	App\Controller\BlogController->categoryList (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Categories	No errors.
App\Entity\Posts	No errors.
App\Entity\Users	No errors.
App\Entity\Hotels	No errors.
App\Entity\Rooms	No errors.
App\Entity\ExtraCharges	No errors.
App\Entity\Galleries	No errors.
App\Entity\Images	No errors.
App\Entity\Offers	No errors.
App\Entity\StopSales	No errors.
App\Entity\RoomPrices	No errors.
App\Entity\RoomCapacities	No errors.
App\Entity\Insurances	No errors.
App\Entity\Orders	No errors.
App\Entity\Transfers	No errors.
App\Entity\Slides	No errors.
App\Entity\Faq	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET http://vps-b29a5976.vps.ovh.net/_partial?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CHomeController%253A%253ArenderBookingFormOnl…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping