Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

7 Database Queries

7 Different statements

8.36 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.88 ms
(58.44%)

"ROLLBACK"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"ROLLBACK"

"ROLLBACK";

#	File/Call
1	Doctrine\DBAL\Connection->rollBack (line 488)
2	Doctrine\ORM\UnitOfWork->commit (line 414)
3	Doctrine\ORM\EntityManager->flush (line 38)
4	App\FormProcessors\GuestTypeProcessor->processGuestFormNew (line 83)
5	App\Controller\HomeController->bookings (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.01 ms
(12.14%)

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:

[
  79
  "2025-04-03 07:18:17"
  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 = 79 AND e0_.date > '2025-04-03 07:18:17' 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.94 ms
(11.25%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.email AS email_4, t0.event_id AS event_id_5 FROM guest t0 WHERE t0.email = ? AND t0.event_id = ? LIMIT 1

Parameters:

[
  "[email protected]"
  876
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone AS phone_3,
  t0.email AS email_4,
  t0.event_id AS event_id_5
FROM
  guest t0
WHERE
  t0.email = ?
  AND t0.event_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.email AS email_4, t0.event_id AS event_id_5 FROM guest t0 WHERE t0.email = '[email protected]' AND t0.event_id = 876 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 20)
4	App\Service\Validators\GuestValidator->validateGuest (line 29)
5	App\FormProcessors\GuestTypeProcessor->processGuestFormNew (line 83)
6	App\Controller\HomeController->bookings (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.47 ms
(5.67%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 426)
2	Doctrine\ORM\UnitOfWork->commit (line 414)
3	Doctrine\ORM\EntityManager->flush (line 38)
4	App\FormProcessors\GuestTypeProcessor->processGuestFormNew (line 83)
5	App\Controller\HomeController->bookings (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.37 ms
(4.48%)

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:

[
  "Bath"
]

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 = 'Bath' 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.35 ms
(4.17%)

INSERT INTO guest (name, phone, email, event_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "* * * 🎁 Ваша награда ждёт вас! Для получения подарка перейдите по ссылке: https://amogszonalconference2024.com/?koxvl3 🎁 * * *"
  ""
  "[email protected]"
  876
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO guest (name, phone, email, event_id)
VALUES
  (?, ?, ?, ?)

INSERT INTO guest (name, phone, email, event_id) VALUES ('* * * 🎁 Ваша награда ждёт вас! Для получения подарка перейдите по ссылке: https://amogszonalconference2024.com/?koxvl3 🎁 * * *', '', '[email protected]', 876);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 285)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1185)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 38)
7	App\FormProcessors\GuestTypeProcessor->processGuestFormNew (line 83)
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.32 ms
(3.86%)

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:

[
  79
  "2025-04-03 07:18:17"
]

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 = 79 AND e0_.date > '2025-04-03 07:18:17' 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 25)
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.
App\Entity\Guest	The association App\Entity\Guest#event refers to the inverse side field App\Entity\Event#guests which does not exist.

Symfony Profiler

POST http://btgfootballbookings.com/bookings/Bath

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping