Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

15 Database Queries

11 Different statements

15.74 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.69 ms
(74.30%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 414)
4	Doctrine\ORM\EntityManager->flush (line 38)
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.70 ms
(4.48%)

SELECT t0.id AS id_1, t0.type_name AS type_name_2, t0.type_level AS type_level_3 FROM log_type t0 WHERE t0.type_name = ? LIMIT 1

Parameters:

[
  "INFO"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type_name AS type_name_2,
  t0.type_level AS type_level_3
FROM
  log_type t0
WHERE
  t0.type_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type_name AS type_name_2, t0.type_level AS type_level_3 FROM log_type t0 WHERE t0.type_name = 'INFO' 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 43)
4	App\Utilities\DBHandler->saveLog (line 29)
5	App\Utilities\DBHandler->write (line 44)
6	Monolog\Handler\AbstractProcessingHandler->handle (line 390)
7	Monolog\Logger->addRecord (line 606)
8	Monolog\Logger->info (line 48)
9	App\Mailer\Mailer->sendBookingConfirmationEmail (line 50)
10	App\EventListener\AddGuestListener->postPersist (line 93)
11	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
12	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
13	Doctrine\ORM\UnitOfWork->commit (line 414)
14	Doctrine\ORM\EntityManager->flush (line 38)
15	App\FormProcessors\GuestTypeProcessor->processGuestFormNew (line 83)
16	App\Controller\HomeController->bookings (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.69 ms
(4.38%)

INSERT INTO log (created, message, context, extra, tags, details, log_type_id) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2024-12-03 17:46:55"
  "Successfully sent email to Max Hamilton at [email protected] for event BTG Brighton - 06 Dec 20:00"
  "[]"
  "[]"
  null
  null
  2
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO log (
  created, message, context, extra, tags,
  details, log_type_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (created, message, context, extra, tags, details, log_type_id) VALUES ('2024-12-03 17:46:55', 'Successfully sent email to Max Hamilton at [email protected] for event BTG Brighton - 06 Dec 20:00', '[]', '[]', NULL, NULL, 2);

#	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 58)
7	App\Utilities\DBHandler->saveLog (line 29)
8	App\Utilities\DBHandler->write (line 44)
9	Monolog\Handler\AbstractProcessingHandler->handle (line 390)
10	Monolog\Logger->addRecord (line 606)
11	Monolog\Logger->info (line 48)
12	App\Mailer\Mailer->sendBookingConfirmationEmail (line 50)
13	App\EventListener\AddGuestListener->postPersist (line 93)
14	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
15	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
16	Doctrine\ORM\UnitOfWork->commit (line 414)
17	Doctrine\ORM\EntityManager->flush (line 38)
18	App\FormProcessors\GuestTypeProcessor->processGuestFormNew (line 83)
19	App\Controller\HomeController->bookings (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.48 ms
(3.02%)

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:

[
  "Brighton"
]

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 = 'Brighton' 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.40 ms
(2.51%)

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:

[
  57
  "2024-12-03 17:46:53"
  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 = 57 AND e0_.date > '2024-12-03 17:46:53' 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.36 ms
(2.26%)

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:

[
  57
  "2024-12-03 17:46:53"
]

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 = 57 AND e0_.date > '2024-12-03 17:46:53' 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)

0.33 ms
(2.08%)

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]"
  378
]

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 = 378 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.31 ms
(1.95%)

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

Parameters:

[
  "Max Hamilton"
  ""
  "[email protected]"
  378
]

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 ('Max Hamilton', '', '[email protected]', 378);

#	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.27 ms
(1.73%)

UPDATE event SET guest_count = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  event
SET
  guest_count = ?
WHERE
  id = ?

UPDATE event SET guest_count = 4 WHERE id = 378;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1277)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 43)
7	App\EventListener\AddGuestListener->postPersist (line 93)
8	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
9	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
10	Doctrine\ORM\UnitOfWork->commit (line 414)
11	Doctrine\ORM\EntityManager->flush (line 38)
12	App\FormProcessors\GuestTypeProcessor->processGuestFormNew (line 83)
13	App\Controller\HomeController->bookings (line 178)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.27 ms
(1.70%)

"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.25 ms
(1.59%)

INSERT INTO booking_removal_code (code, guest_id) VALUES (?, ?)

Parameters:

[
  "90a675a81f"
  6423
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO booking_removal_code (code, guest_id)
VALUES
  (?, ?)

INSERT INTO booking_removal_code (code, guest_id) VALUES ('90a675a81f', 6423);

#	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 34)
7	App\Service\BookingRemovals->createRemovalCode (line 46)
8	App\EventListener\AddGuestListener->postPersist (line 93)
9	Doctrine\ORM\Event\ListenersInvoker->invoke (line 1216)
10	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
11	Doctrine\ORM\UnitOfWork->commit (line 414)
12	Doctrine\ORM\EntityManager->flush (line 38)
13	App\FormProcessors\GuestTypeProcessor->processGuestFormNew (line 83)
14	App\Controller\HomeController->bookings (line 178)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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.
App\Entity\BookingRemovalCode	No errors.
App\Entity\LogType	No errors.
App\Entity\Log	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping