Symfony Profiler

Query Metrics

85 Database Queries

7 Different statements

19.80 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.39 ms
(52.46%)

SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = ?

Parameters:

[
  766
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.decription AS decription_2,
  t0.term_id AS term_id_3
FROM
  term_case t0
WHERE
  t0.term_id = ?

SELECT t0.id AS id_1, t0.decription AS decription_2, t0.term_id AS term_id_3 FROM term_case t0 WHERE t0.term_id = 766;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1799)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1744)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2699)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 620)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 184)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 49)
8	App\Controller\HomeController->pack (line 181)
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)

5.77 ms
(29.15%)

INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  null
  null
  "The research explores the relationship between temperature and bacterial growth;  __________ , higher temperatures lead to faster bacterial reproduction."
  766
  1613
  684
  397
  192
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO quiz_item (
  is_correct, date_time, ask, term_id,
  quiz_id, wrong_a_id, wrong_b_id,
  wrong_c_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO quiz_item (is_correct, date_time, ask, term_id, quiz_id, wrong_a_id, wrong_b_id, wrong_c_id) VALUES (NULL, NULL, 'The research explores the relationship between temperature and bacterial growth;  __________ , higher temperatures lead to faster bacterial reproduction.', 766, 1613, 684, 397, 192);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 248)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 260)
6	Doctrine\ORM\EntityManager->flush (line 111)
7	App\Controller\HomeController->pack (line 181)
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)

1.44 ms
(7.28%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 260)
4	Doctrine\ORM\EntityManager->flush (line 34)
5	App\Controller\HomeController->pack (line 181)
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.97 ms
(4.92%)

"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 380)
2	Doctrine\ORM\UnitOfWork->commit (line 260)
3	Doctrine\ORM\EntityManager->flush (line 34)
4	App\Controller\HomeController->pack (line 181)
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)

0.68 ms
(3.42%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.category AS category_4, t0.pack_id AS pack_id_5 FROM term t0 WHERE t0.pack_id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.category AS category_4,
  t0.pack_id AS pack_id_5
FROM
  term t0
WHERE
  t0.pack_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.category AS category_4, t0.pack_id AS pack_id_5 FROM term t0 WHERE t0.pack_id = 28;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1799)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1744)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2699)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 620)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 184)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 37)
8	App\Controller\HomeController->pack (line 181)
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)

0.33 ms
(1.68%)

SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = ?

Parameters:

[
  "28"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1
FROM
  pack t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM pack t0 WHERE t0.id = '28';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 358)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.22 ms
(1.10%)

INSERT INTO quiz (pack_id) VALUES (?)

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO quiz (pack_id)
VALUES
  (?)

INSERT INTO quiz (pack_id) VALUES (28);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 248)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 260)
6	Doctrine\ORM\EntityManager->flush (line 34)
7	App\Controller\HomeController->pack (line 181)
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)

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\Pack	No errors.
App\Entity\Term	No errors.
App\Entity\Quiz	No errors.
App\Entity\QuizItem	No errors.
App\Entity\TermCase	No errors.

Symfony Profiler

GET https://teap.wab.com.br/newQuizWithPack/28

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping