Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.12 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.40 ms
(35.24%)

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "fabos_symfony"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'fabos_symfony'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

#	File/Call
1	Doctrine\DBAL\Schema\MySQLSchemaManager->selectTableNames (line 360)
2	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 207)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
4	App\Repository\MachineFavoriteRepository->isStorageReady (line 24)
5	App\Controller\SiteController->machines (line 187)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
8	Symfony\Component\HttpKernel\Kernel->handle (line 143)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.31 ms
(27.94%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.localisation AS localisation_4, t0.photo AS photo_5, t0.statut AS statut_6, t0.granularite AS granularite_7, t0.categorySlug AS categorySlug_8, t0.categoryLabel AS categoryLabel_9, t0.levelSlug AS levelSlug_10, t0.levelLabel AS levelLabel_11, t0.iconSlug AS iconSlug_12, t0.materials AS materials_13, t0.features AS features_14, t0.requirementTitle AS requirementTitle_15, t0.requirementDescription AS requirementDescription_16, t0.popularity AS popularity_17, t0.limiteReservations AS limiteReservations_18, t0.machineToken AS machineToken_19, t0.createdAt AS createdAt_20, t0.updated AS updated_21, t0.lastAuthorizationTime AS lastAuthorizationTime_22 FROM MACHINE t0 ORDER BY t0.createdAt DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.localisation AS localisation_4,
  t0.photo AS photo_5,
  t0.statut AS statut_6,
  t0.granularite AS granularite_7,
  t0.categorySlug AS categorySlug_8,
  t0.categoryLabel AS categoryLabel_9,
  t0.levelSlug AS levelSlug_10,
  t0.levelLabel AS levelLabel_11,
  t0.iconSlug AS iconSlug_12,
  t0.materials AS materials_13,
  t0.features AS features_14,
  t0.requirementTitle AS requirementTitle_15,
  t0.requirementDescription AS requirementDescription_16,
  t0.popularity AS popularity_17,
  t0.limiteReservations AS limiteReservations_18,
  t0.machineToken AS machineToken_19,
  t0.createdAt AS createdAt_20,
  t0.updated AS updated_21,
  t0.lastAuthorizationTime AS lastAuthorizationTime_22
FROM
  MACHINE t0
ORDER BY
  t0.createdAt DESC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.localisation AS localisation_4, t0.photo AS photo_5, t0.statut AS statut_6, t0.granularite AS granularite_7, t0.categorySlug AS categorySlug_8, t0.categoryLabel AS categoryLabel_9, t0.levelSlug AS levelSlug_10, t0.levelLabel AS levelLabel_11, t0.iconSlug AS iconSlug_12, t0.materials AS materials_13, t0.features AS features_14, t0.requirementTitle AS requirementTitle_15, t0.requirementDescription AS requirementDescription_16, t0.popularity AS popularity_17, t0.limiteReservations AS limiteReservations_18, t0.machineToken AS machineToken_19, t0.createdAt AS createdAt_20, t0.updated AS updated_21, t0.lastAuthorizationTime AS lastAuthorizationTime_22 FROM MACHINE t0 ORDER BY t0.createdAt DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\SiteController->machines (line 173)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.27 ms
(24.29%)

SELECT t0.id AS id_1, t0.requiredForAccess AS requiredForAccess_2, t0.createdAt AS createdAt_3, t0.machineId AS machineId_4, t0.badgeId AS badgeId_5 FROM MACHINE_BADGE t0 WHERE t0.machineId = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.requiredForAccess AS requiredForAccess_2,
  t0.createdAt AS createdAt_3,
  t0.machineId AS machineId_4,
  t0.badgeId AS badgeId_5
FROM
  MACHINE_BADGE t0
WHERE
  t0.machineId = ?

SELECT t0.id AS id_1, t0.requiredForAccess AS requiredForAccess_2, t0.createdAt AS createdAt_3, t0.machineId AS machineId_4, t0.badgeId AS badgeId_5 FROM MACHINE_BADGE t0 WHERE t0.machineId = 1;

#	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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 239)
7	App\Entity\Machine->getRequiredMachineBadges (line 145)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_28e6646b2f44b41c14178ee2a78faded::doDisplay (line 489)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
18	App\Controller\SiteController->machines (line 184)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
21	Symfony\Component\HttpKernel\Kernel->handle (line 143)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.14 ms
(12.54%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 332)
2	Doctrine\DBAL\Connection->getDatabase (line 161)
3	Doctrine\DBAL\Schema\AbstractSchemaManager->getDatabase (line 1458)
4	Doctrine\DBAL\Schema\AbstractSchemaManager->listTableNames (line 208)
5	Doctrine\DBAL\Schema\AbstractSchemaManager->tablesExist (line 184)
6	App\Repository\MachineFavoriteRepository->isStorageReady (line 24)
7	App\Controller\SiteController->machines (line 187)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	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\Machine	1

Entities Mapping

Class	Mapping errors
App\Entity\Machine	No errors.
App\Entity\MachineBadge	No errors.
App\Entity\MachineFavorite	No errors.
App\Entity\Badge	No errors.

GET http://fabos.dstei.fr/machines

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping