Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

12.61 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

12.61 ms

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, g2_.id AS id_34, g2_.title AS title_35, r1_.hotel_id AS hotel_id_36, g2_.hotel_id AS hotel_id_37, g2_.room_id AS room_id_38 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN galleries g2_ ON r1_.id = g2_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND h0_.slug = ?

Parameters:

[
  "5-maradiva-villas-resort-spa"
]

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,
  g2_.id AS id_34,
  g2_.title AS title_35,
  r1_.hotel_id AS hotel_id_36,
  g2_.hotel_id AS hotel_id_37,
  g2_.room_id AS room_id_38
FROM
  hotels h0_
  LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id
  LEFT JOIN galleries g2_ ON r1_.id = g2_.room_id
WHERE
  h0_.active = 1
  AND r1_.active = 1
  AND h0_.slug = ?

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, g2_.id AS id_34, g2_.title AS title_35, r1_.hotel_id AS hotel_id_36, g2_.hotel_id AS hotel_id_37, g2_.room_id AS room_id_38 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN galleries g2_ ON r1_.id = g2_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND h0_.slug = '5-maradiva-villas-resort-spa';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 341)
7	App\Repository\HotelsRepository->findActiveHotelBySlugs (line 133)
8	App\Controller\HotelController->show (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\Hotels	No errors.
App\Entity\Rooms	No errors.
App\Entity\Galleries	No errors.

Symfony Profiler

GET http://allons-maurice.babouklab.com/hotels/5-maradiva-villas-resort-spa

Configuration Settings

Theme