Symfony Profiler

Query Metrics

13 Database Queries

8 Different statements

5.67 ms Query time

2 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.43 ms
(42.92%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\Admin\TourCrudController->managesteps (line 264)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.15 ms
(20.22%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.id = ? AND t0.tour_id = ? LIMIT 1

Parameters:

[
  "36"
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.time AS time_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.selectable AS selectable_6,
  t0.tour_id AS tour_id_7,
  t0.pier_id AS pier_id_8
FROM
  step t0
WHERE
  t0.id = ?
  AND t0.tour_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.id = '36' AND t0.tour_id = 8 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\Admin\TourCrudController->managesteps (line 228)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

0.54 ms
(9.47%)

DELETE FROM step WHERE id = ?

Parameters:

[
  36
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  step
WHERE
  id = ?

DELETE FROM step WHERE id = 36;

#	File/Call
1	Doctrine\DBAL\Connection->delete (line 703)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->delete (line 567)
3	Doctrine\ORM\UnitOfWork->executeDeletions (line 1167)
4	Doctrine\ORM\UnitOfWork->commit (line 428)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\Admin\TourCrudController->managesteps (line 264)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.45 ms
(8.03%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.phone AS phone_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone AS phone_7 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 91)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 92)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.37 ms
(6.57%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.publicurl AS publicurl_3, t0.adminurl AS adminurl_4, t0.address AS address_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.logofilename AS logofilename_9, t0.faviconfilename AS faviconfilename_10, t0.email AS email_11, t0.updated_at AS updated_at_12, t0.siret AS siret_13, t0.naf AS naf_14, t0.vatnumber AS vatnumber_15, t0.companyname AS companyname_16, t0.rcs AS rcs_17, t0.theme AS theme_18, t0.paymentsolution AS paymentsolution_19 FROM company t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.publicurl AS publicurl_3,
  t0.adminurl AS adminurl_4,
  t0.address AS address_5,
  t0.zipcode AS zipcode_6,
  t0.city AS city_7,
  t0.phone AS phone_8,
  t0.logofilename AS logofilename_9,
  t0.faviconfilename AS faviconfilename_10,
  t0.email AS email_11,
  t0.updated_at AS updated_at_12,
  t0.siret AS siret_13,
  t0.naf AS naf_14,
  t0.vatnumber AS vatnumber_15,
  t0.companyname AS companyname_16,
  t0.rcs AS rcs_17,
  t0.theme AS theme_18,
  t0.paymentsolution AS paymentsolution_19
FROM
  company t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.publicurl AS publicurl_3, t0.adminurl AS adminurl_4, t0.address AS address_5, t0.zipcode AS zipcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.logofilename AS logofilename_9, t0.faviconfilename AS faviconfilename_10, t0.email AS email_11, t0.updated_at AS updated_at_12, t0.siret AS siret_13, t0.naf AS naf_14, t0.vatnumber AS vatnumber_15, t0.companyname AS companyname_16, t0.rcs AS rcs_17, t0.theme AS theme_18, t0.paymentsolution AS paymentsolution_19 FROM company t0 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\CompanyManager->getCurrentCompany (line 20)
5	App\Controller\Admin\DashboardController->configureDashboard (line 49)
6	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getDashboardDto (line 126)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 58)
8	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequestPrettyUrls (line 132)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

0.31 ms
(5.42%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.tour_id = ? ORDER BY t0.time ASC

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.time AS time_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.selectable AS selectable_6,
  t0.tour_id AS tour_id_7,
  t0.pier_id AS pier_id_8
FROM
  step t0
WHERE
  t0.tour_id = ?
ORDER BY
  t0.time ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.time AS time_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.selectable AS selectable_6, t0.tour_id AS tour_id_7, t0.pier_id AS pier_id_8 FROM step t0 WHERE t0.tour_id = 8 ORDER BY t0.time ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 208)
9	App\Controller\Admin\TourCrudController::managesteps (line 208)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.24 ms
(4.30%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.id = ?

Parameters:

[
  "8"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.firstday AS firstday_4,
  t0.lastday AS lastday_5,
  t0.status AS status_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.position AS position_9,
  t0.disabledseats AS disabledseats_10,
  t0.disclaimer AS disclaimer_11,
  t0.service_id AS service_id_12,
  t0.boat_id AS boat_id_13
FROM
  tour t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.firstday AS firstday_4, t0.lastday AS lastday_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.position AS position_9, t0.disabledseats AS disabledseats_10, t0.disclaimer AS disclaimer_11, t0.service_id AS service_id_12, t0.boat_id AS boat_id_13 FROM tour t0 WHERE t0.id = '8';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 193)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 152)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 86)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 271)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 66)
11	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequestPrettyUrls (line 132)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.17 ms
(3.07%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\Admin\TourCrudController->managesteps (line 264)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Step	3
App\Entity\Pier	3
App\Entity\User	1
App\Entity\Company	1
App\Entity\Tour	1
App\Entity\Service	1
App\Entity\Boat	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Userparam	No errors.
App\Entity\Booking	The mappings App\Entity\Booking#retailer and App\Entity\User#bookings are inconsistent with each other.
App\Entity\Order	The mappings App\Entity\Order#retailer and App\Entity\User#orders are inconsistent with each other.
App\Entity\Company	No errors.
App\Entity\Tour	No errors.
App\Entity\Service	No errors.
App\Entity\Boat	No errors.
App\Entity\Pricetype	No errors.
App\Entity\Step	No errors.
App\Entity\Tourday	No errors.
App\Entity\Option	No errors.
App\Entity\Pier	No errors.

Symfony Profiler

POST https://admin.escal-hatoup.klerthis.net/tour/8/managesteps

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping