Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

6.87 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.51 ms
(65.75%)

SELECT NEXTVAL('bestellung_id_seq')

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  NEXTVAL('bestellung_id_seq')

SELECT NEXTVAL('bestellung_id_seq');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 621)
2	Doctrine\DBAL\Connection->fetchOne (line 65)
3	Doctrine\ORM\Id\SequenceGenerator->generateId (line 1039)
4	Doctrine\ORM\UnitOfWork->persistNew (line 1999)
5	Doctrine\ORM\UnitOfWork->doPersist (line 1956)
6	Doctrine\ORM\UnitOfWork->persist (line 665)
7	Doctrine\ORM\EntityManager->persist (line 40)
8	App\Controller\BestellungController->bestellen (line 182)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.12 ms
(16.28%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1422)
2	Doctrine\DBAL\Connection->commit (line 472)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 41)
5	App\Controller\BestellungController->bestellen (line 182)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.67 ms
(9.80%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.bild AS bild_3, t0.beschreibung AS beschreibung_4, t0.preis AS preis_5, t0.kategorie_id AS kategorie_id_6 FROM gericht t0 WHERE t0.id = ?

Parameters:

[
  "40"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.bild AS bild_3,
  t0.beschreibung AS beschreibung_4,
  t0.preis AS preis_5,
  t0.kategorie_id AS kategorie_id_6
FROM
  gericht t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.bild AS bild_3, t0.beschreibung AS beschreibung_4, t0.preis AS preis_5, t0.kategorie_id AS kategorie_id_6 FROM gericht t0 WHERE t0.id = '40';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 142)
6	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->find (line 91)
7	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
8	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
9	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
10	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 170)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.44 ms
(6.40%)

INSERT INTO bestellung (id, tisch, bnummer, name, preis, status) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  685
  "tisch1"
  "40"
  "Wein"
  6.8
  "offen"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO bestellung (
  id, tisch, bnummer, name, preis, status
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO bestellung (id, tisch, bnummer, name, preis, status) VALUES (685, 'tisch1', '40', 'Wein', 6.8, 'offen');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 280)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1179)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 443)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 41)
7	App\Controller\BestellungController->bestellen (line 182)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.12 ms
(1.77%)

"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 424)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 41)
4	App\Controller\BestellungController->bestellen (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\Gericht	No errors.
App\Entity\Kategorie	No errors.
App\Entity\Bestellung	No errors.

Symfony Profiler

GET https://schuth.schola.inthepro.de/bestellen40

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping