Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

34.66 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

19.54 ms
(56.36%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.attachment AS attachment_2, f0_.created_at AS created_at_3, f0_.updated_at AS updated_at_4 FROM frameworks f0_ LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.attachment AS attachment_2,
  f0_.created_at AS created_at_3,
  f0_.updated_at AS updated_at_4
FROM
  frameworks f0_
LIMIT
  4

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.attachment AS attachment_2, f0_.created_at AS created_at_3, f0_.updated_at AS updated_at_4 FROM frameworks f0_ LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\LogicielsRepository->findLogicielsPaginated (line 29)
8	App\Controller\TechnoController->Techno (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

6.79 ms
(19.58%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.attachment AS attachment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM frameworks t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.attachment AS attachment_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  frameworks t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.attachment AS attachment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM frameworks t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 49)
6	App\Controller\TechnoController->App\Controller\{closure} (line 48)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 47)
14	App\Controller\TechnoController->Techno (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

3.02 ms
(8.70%)

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.attachment AS attachment_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4 FROM langages l0_ LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.attachment AS attachment_2,
  l0_.created_at AS created_at_3,
  l0_.updated_at AS updated_at_4
FROM
  langages l0_
LIMIT
  4

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.attachment AS attachment_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4 FROM langages l0_ LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 35)
7	App\Repository\LangagesRepository->findLangagesPaginated (line 37)
8	App\Controller\TechnoController->Techno (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.76 ms
(7.97%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.attachment AS attachment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM logiciels t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.attachment AS attachment_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  logiciels t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.attachment AS attachment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM logiciels t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 33)
6	App\Controller\TechnoController->App\Controller\{closure} (line 48)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 31)
14	App\Controller\TechnoController->Techno (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

1.35 ms
(3.90%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.attachment AS attachment_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4 FROM langages l0_) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          l0_.id AS id_0,
          l0_.name AS name_1,
          l0_.attachment AS attachment_2,
          l0_.created_at AS created_at_3,
          l0_.updated_at AS updated_at_4
        FROM
          langages l0_
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.attachment AS attachment_2, l0_.created_at AS created_at_3, l0_.updated_at AS updated_at_4 FROM langages l0_) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 43)
8	App\Repository\LangagesRepository->findLangagesPaginated (line 37)
9	App\Controller\TechnoController->Techno (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.21 ms
(3.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.attachment AS attachment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM langages t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.attachment AS attachment_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  langages t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.attachment AS attachment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM langages t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 41)
6	App\Controller\TechnoController->App\Controller\{closure} (line 48)
7	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 111)
8	Symfony\Component\Cache\LockRegistry::compute (line 102)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->Symfony\Component\Cache\Traits\{closure} (line 64)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
13	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 39)
14	App\Controller\TechnoController->Techno (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\Logiciels	No errors.
App\Entity\Frameworks	No errors.
App\Entity\Langages	No errors.

Symfony Profiler

GET http://www.dev-vianney.com/technos

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping