Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

10.97 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.71 ms

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_promoted AS is_promoted_3, t0.other_autors AS other_autors_4, t0.listen_number AS listen_number_5, t0.download_number AS download_number_6, t0.title AS title_7, t0.content AS content_8, t0.metadata AS metadata_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.enabled AS enabled_13, t0.link_name AS link_name_14, t0.link_original_name AS link_original_name_15, t0.link_mime_type AS link_mime_type_16, t0.link_size AS link_size_17, t0.link_dimensions AS link_dimensions_18, t0.categorie_fichier_id AS categorie_fichier_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM fichier t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "proceedings-of-the-second-conference-sustainable-energy-for-africa-se4a-2021"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_promoted AS is_promoted_3,
  t0.other_autors AS other_autors_4,
  t0.listen_number AS listen_number_5,
  t0.download_number AS download_number_6,
  t0.title AS title_7,
  t0.content AS content_8,
  t0.metadata AS metadata_9,
  t0.slug AS slug_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.enabled AS enabled_13,
  t0.link_name AS link_name_14,
  t0.link_original_name AS link_original_name_15,
  t0.link_mime_type AS link_mime_type_16,
  t0.link_size AS link_size_17,
  t0.link_dimensions AS link_dimensions_18,
  t0.categorie_fichier_id AS categorie_fichier_id_19,
  t0.created_by_id AS created_by_id_20,
  t0.updated_by_id AS updated_by_id_21
FROM
  fichier t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_promoted AS is_promoted_3, t0.other_autors AS other_autors_4, t0.listen_number AS listen_number_5, t0.download_number AS download_number_6, t0.title AS title_7, t0.content AS content_8, t0.metadata AS metadata_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.enabled AS enabled_13, t0.link_name AS link_name_14, t0.link_original_name AS link_original_name_15, t0.link_mime_type AS link_mime_type_16, t0.link_size AS link_size_17, t0.link_dimensions AS link_dimensions_18, t0.categorie_fichier_id AS categorie_fichier_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM fichier t0 WHERE t0.slug = 'proceedings-of-the-second-conference-sustainable-energy-for-africa-se4a-2021' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
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)

0.24 ms

"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 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 73)
4	App\Controller\DocumentController->telecharger (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.83 ms

UPDATE fichier SET download_number = ?, updated_at = ? WHERE id = ?

Parameters:

[
  2197
  "2026-10-22 16:39:11"
  8
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  fichier
SET
  download_number = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE fichier SET download_number = 2197, updated_at = '2026-10-22 16:39:11' WHERE id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 73)
7	App\Controller\DocumentController->telecharger (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

8.18 ms

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 73)
5	App\Controller\DocumentController->telecharger (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Fichier	No errors.
App\Entity\CategorieFichier	No errors.
App\Entity\User	The field App\Entity\User#pages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Page#created_by does not contain the required 'inversedBy="pages"' attribute.
App\Entity\Artiste	No errors.

Symfony Profiler

GET https://test.academie-sciences.bj/document/proceedings-of-the-second-conference-sustainable-energy-for-africa-se4a-2021/telecharger

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping