Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

3 Database Queries

3 Different statements

1.19 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.46 ms
(38.12%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_line_one AS address_line_one_3, t0.address_line_two AS address_line_two_4, t0.address_line_three AS address_line_three_5, t0.city AS city_6, t0.county AS county_7, t0.post_code AS post_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.default_event_description AS default_event_description_11, t0.region_id AS region_id_12 FROM site t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "Sheffield"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address_line_one AS address_line_one_3,
  t0.address_line_two AS address_line_two_4,
  t0.address_line_three AS address_line_three_5,
  t0.city AS city_6,
  t0.county AS county_7,
  t0.post_code AS post_code_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.default_event_description AS default_event_description_11,
  t0.region_id AS region_id_12
FROM
  site t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address_line_one AS address_line_one_3, t0.address_line_two AS address_line_two_4, t0.address_line_three AS address_line_three_5, t0.city AS city_6, t0.county AS county_7, t0.post_code AS post_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.default_event_description AS default_event_description_11, t0.region_id AS region_id_12 FROM site t0 WHERE t0.name = 'Sheffield' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 45)
4	App\Controller\HomeController->bookings (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.41 ms
(34.25%)

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.recurring AS recurring_3, e0_.bookable AS bookable_4, e0_.max_guests AS max_guests_5, e0_.guest_count AS guest_count_6, e0_.show_phone_on_form AS show_phone_on_form_7, e0_.site_id AS site_id_8 FROM event e0_ WHERE e0_.site_id = ? AND e0_.date > ? AND e0_.bookable = ? ORDER BY e0_.date ASC

Parameters:

[
  54
  "2024-11-21 06:37:52"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.date AS date_2,
  e0_.recurring AS recurring_3,
  e0_.bookable AS bookable_4,
  e0_.max_guests AS max_guests_5,
  e0_.guest_count AS guest_count_6,
  e0_.show_phone_on_form AS show_phone_on_form_7,
  e0_.site_id AS site_id_8
FROM
  event e0_
WHERE
  e0_.site_id = ?
  AND e0_.date > ?
  AND e0_.bookable = ?
ORDER BY
  e0_.date ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.recurring AS recurring_3, e0_.bookable AS bookable_4, e0_.max_guests AS max_guests_5, e0_.guest_count AS guest_count_6, e0_.show_phone_on_form AS show_phone_on_form_7, e0_.site_id AS site_id_8 FROM event e0_ WHERE e0_.site_id = 54 AND e0_.date > '2024-11-21 06:37:52' AND e0_.bookable = 1 ORDER BY e0_.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 131)
7	App\Repository\EventRepository->findUpcomingEventsBookable (line 53)
8	App\Controller\HomeController->bookings (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.33 ms
(27.64%)

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.recurring AS recurring_3, e0_.bookable AS bookable_4, e0_.max_guests AS max_guests_5, e0_.guest_count AS guest_count_6, e0_.show_phone_on_form AS show_phone_on_form_7, e0_.site_id AS site_id_8 FROM event e0_ WHERE e0_.site_id = ? AND e0_.date > ? ORDER BY e0_.date ASC

Parameters:

[
  54
  "2024-11-21 06:37:52"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.date AS date_2,
  e0_.recurring AS recurring_3,
  e0_.bookable AS bookable_4,
  e0_.max_guests AS max_guests_5,
  e0_.guest_count AS guest_count_6,
  e0_.show_phone_on_form AS show_phone_on_form_7,
  e0_.site_id AS site_id_8
FROM
  event e0_
WHERE
  e0_.site_id = ?
  AND e0_.date > ?
ORDER BY
  e0_.date ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date AS date_2, e0_.recurring AS recurring_3, e0_.bookable AS bookable_4, e0_.max_guests AS max_guests_5, e0_.guest_count AS guest_count_6, e0_.show_phone_on_form AS show_phone_on_form_7, e0_.site_id AS site_id_8 FROM event e0_ WHERE e0_.site_id = 54 AND e0_.date > '2024-11-21 06:37:52' ORDER BY e0_.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 92)
7	App\Repository\EventRepository->findUpcomingEvents (line 27)
8	App\Form\GuestForms\GuestTypeByEventLocation->buildForm (line 99)
9	Symfony\Component\Form\ResolvedFormType->buildForm (line 76)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
12	Symfony\Component\Form\FormFactory->createBuilder (line 28)
13	Symfony\Component\Form\FormFactory->create (line 323)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 64)
15	App\Controller\HomeController->bookings (line 178)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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\Site	No errors.
App\Entity\Region	No errors.
App\Entity\Event	No errors.

Symfony Profiler

GET http://btgfootballbookings.com/bookings/Sheffield

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping