Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

19.97 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.29 ms
(91.59%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.volume AS volume_3, t0.title AS title_4, t0.local_path AS local_path_5, t0.external_id AS external_id_6, t0.cbz_path AS cbz_path_7, t0.visible AS visible_8, t0.manga_id AS manga_id_9 FROM chapter t0 WHERE t0.manga_id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.volume AS volume_3,
  t0.title AS title_4,
  t0.local_path AS local_path_5,
  t0.external_id AS external_id_6,
  t0.cbz_path AS cbz_path_7,
  t0.visible AS visible_8,
  t0.manga_id AS manga_id_9
FROM
  chapter t0
WHERE
  t0.manga_id IN (?, ?, ?, ?)

SELECT t0.id AS id_1, t0.number AS number_2, t0.volume AS volume_3, t0.title AS title_4, t0.local_path AS local_path_5, t0.external_id AS external_id_6, t0.cbz_path AS cbz_path_7, t0.visible AS visible_8, t0.manga_id AS manga_id_9 FROM chapter t0 WHERE t0.manga_id IN (4, 1, 3, 2);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3247)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3221)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
8	Doctrine\ORM\AbstractQuery->execute (line 901)
9	Doctrine\ORM\AbstractQuery->getResult (line 116)
10	App\Repository\MangaRepository->findAllSortedAndFiltered (line 65)
11	App\Controller\MangaController->index (line 178)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.93 ms
(4.68%)

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.slug AS slug_2, m0_.image_url AS image_url_3, m0_.publication_year AS publication_year_4, m0_.description AS description_5, m0_.genres AS genres_6, m0_.created_at AS created_at_7, m0_.rating AS rating_8, m0_.author AS author_9, m0_.external_id AS external_id_10, m0_.status AS status_11, m0_.thumbnail_url AS thumbnail_url_12, m0_.monitored AS monitored_13, m0_.alternative_slugs AS alternative_slugs_14 FROM manga m0_ ORDER BY m0_.title ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.slug AS slug_2,
  m0_.image_url AS image_url_3,
  m0_.publication_year AS publication_year_4,
  m0_.description AS description_5,
  m0_.genres AS genres_6,
  m0_.created_at AS created_at_7,
  m0_.rating AS rating_8,
  m0_.author AS author_9,
  m0_.external_id AS external_id_10,
  m0_.status AS status_11,
  m0_.thumbnail_url AS thumbnail_url_12,
  m0_.monitored AS monitored_13,
  m0_.alternative_slugs AS alternative_slugs_14
FROM
  manga m0_
ORDER BY
  m0_.title ASC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.slug AS slug_2, m0_.image_url AS image_url_3, m0_.publication_year AS publication_year_4, m0_.description AS description_5, m0_.genres AS genres_6, m0_.created_at AS created_at_7, m0_.rating AS rating_8, m0_.author AS author_9, m0_.external_id AS external_id_10, m0_.status AS status_11, m0_.thumbnail_url AS thumbnail_url_12, m0_.monitored AS monitored_13, m0_.alternative_slugs AS alternative_slugs_14 FROM manga m0_ ORDER BY m0_.title ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 116)
7	App\Repository\MangaRepository->findAllSortedAndFiltered (line 65)
8	App\Controller\MangaController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.75 ms
(3.73%)

SELECT t0.id AS id_1, t0.manga_directory AS manga_directory_2, t0.image_directory AS image_directory_3 FROM app_settings t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.manga_directory AS manga_directory_2,
  t0.image_directory AS image_directory_3
FROM
  app_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.manga_directory AS manga_directory_2, t0.image_directory AS image_directory_3 FROM app_settings t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 19)
4	App\Manager\AppSettingsManager->getSettings (line 28)
5	App\Manager\FileSystemManager->loadSettings (line 23)
6	App\Manager\FileSystemManager->__construct (line 33)
7	ContainerOS3GRx8\getFileSystemManagerService::do (line 658)
8	ContainerOS3GRx8\App_KernelDevDebugContainer->load (line 25)
9	ContainerOS3GRx8\getMangaControllerService::do (line 658)
10	ContainerOS3GRx8\App_KernelDevDebugContainer->load (line 220)
11	Symfony\Component\DependencyInjection\Container::make (line 202)
12	Symfony\Component\DependencyInjection\Container->get (line 40)
13	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 25)
14	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 161)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\AppSettings	No errors.
App\Entity\Manga	No errors.
App\Entity\Chapter	No errors.
App\Entity\ContentSource	No errors.

Symfony Profiler

GET https://mangarr.test.nestor-server.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping