Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

21.96 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.51 ms
(97.96%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.address AS address_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.instagram AS instagram_7, t0.hours AS hours_8, t0.facebook AS facebook_9, t0.user_id AS user_id_10 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.instagram AS instagram_7,
  t0.hours AS hours_8,
  t0.facebook AS facebook_9,
  t0.user_id AS user_id_10
FROM
  setting t0

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.address AS address_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.instagram AS instagram_7, t0.hours AS hours_8, t0.facebook AS facebook_9, t0.user_id AS user_id_10 FROM setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 16)
5	App\Service\SettingService->__construct (line 2153)
6	ContainerJVY7xMu\App_KernelDevDebugContainer::getTwigService (line 660)
7	ContainerJVY7xMu\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1272)
8	ContainerJVY7xMu\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 939)
9	ContainerJVY7xMu\App_KernelDevDebugContainer::ContainerJVY7xMu\{closure} (line 221)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 257)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 121)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
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.45 ms
(2.04%)

SELECT t0.id AS id_1, t0.time AS time_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM booking_time t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.time AS time_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.user_id AS user_id_5
FROM
  booking_time t0

SELECT t0.id AS id_1, t0.time AS time_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM booking_time t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 39)
5	App\Controller\Visitor\Booking\BookingController->create (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)

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\Setting	No errors.
App\Entity\User	No errors.
App\Entity\BookingTime	No errors.

Symfony Profiler

GET https://goldrogerpizzeria.com/booking

Configuration Settings

Theme