Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

19.60 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.82 ms
(75.63%)

SELECT t0.id AS id_1, t0.base_url AS base_url_2, t0.image_selector AS image_selector_3, t0.next_page_selector AS next_page_selector_4, t0.chapter_url_format AS chapter_url_format_5, t0.scraping_type AS scraping_type_6, t0.chapter_selector AS chapter_selector_7 FROM content_source t0 INNER JOIN manga_content_source ON t0.id = manga_content_source.content_source_id WHERE manga_content_source.manga_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.base_url AS base_url_2,
  t0.image_selector AS image_selector_3,
  t0.next_page_selector AS next_page_selector_4,
  t0.chapter_url_format AS chapter_url_format_5,
  t0.scraping_type AS scraping_type_6,
  t0.chapter_selector AS chapter_selector_7
FROM
  content_source t0
  INNER JOIN manga_content_source ON t0.id = manga_content_source.content_source_id
WHERE
  manga_content_source.manga_id = ?

SELECT t0.id AS id_1, t0.base_url AS base_url_2, t0.image_selector AS image_selector_3, t0.next_page_selector AS next_page_selector_4, t0.chapter_url_format AS chapter_url_format_5, t0.scraping_type AS scraping_type_6, t0.chapter_selector AS chapter_selector_7 FROM content_source t0 INNER JOIN manga_content_source ON t0.id = manga_content_source.content_source_id WHERE manga_content_source.manga_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1695)
8	twig_array_map (line 1449)
9	__TwigTemplate_825c32167618225ff639838a4c87ca28___3327017201->block_content (line 171)
10	Twig\Template->displayBlock (line 97)
11	__TwigTemplate_6966a7795f3ad20d08e871d17254591c->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 1410)
14	__TwigTemplate_825c32167618225ff639838a4c87ca28___3327017201->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 230)
17	__TwigTemplate_825c32167618225ff639838a4c87ca28->block_body (line 171)
18	Twig\Template->displayBlock (line 44)
19	__TwigTemplate_825c32167618225ff639838a4c87ca28->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 97)
22	__TwigTemplate_004f22a80e02fa0fc2aa24aa6c219bdd->block_body (line 171)
23	Twig\Template->displayBlock (line 161)
24	__TwigTemplate_00b6d86d347431b78ace3dabee8b5c60->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 49)
27	__TwigTemplate_004f22a80e02fa0fc2aa24aa6c219bdd->doDisplay (line 394)
28	Twig\Template->displayWithErrorHandling (line 367)
29	Twig\Template->display (line 379)
30	Twig\Template->render (line 38)
31	Twig\TemplateWrapper->render (line 280)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 88)
36	App\Controller\MangaController->showChapters (line 178)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

1.64 ms
(8.38%)

SELECT t0.id AS id_1, t0.base_url AS base_url_2, t0.image_selector AS image_selector_3, t0.next_page_selector AS next_page_selector_4, t0.chapter_url_format AS chapter_url_format_5, t0.scraping_type AS scraping_type_6, t0.chapter_selector AS chapter_selector_7 FROM content_source t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.base_url AS base_url_2,
  t0.image_selector AS image_selector_3,
  t0.next_page_selector AS next_page_selector_4,
  t0.chapter_url_format AS chapter_url_format_5,
  t0.scraping_type AS scraping_type_6,
  t0.chapter_selector AS chapter_selector_7
FROM
  content_source t0

SELECT t0.id AS id_1, t0.base_url AS base_url_2, t0.image_selector AS image_selector_3, t0.next_page_selector AS next_page_selector_4, t0.chapter_url_format AS chapter_url_format_5, t0.scraping_type AS scraping_type_6, t0.chapter_selector AS chapter_selector_7 FROM content_source t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 86)
5	App\Controller\MangaController->showChapters (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.31 ms
(6.70%)

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:

[
  3
]

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 (3);

#	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 68)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 270)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
8	Doctrine\ORM\EntityRepository->findOneBy (line 79)
9	App\Controller\MangaController->showChapters (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.06 ms
(5.39%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image_url AS image_url_4, t0.publication_year AS publication_year_5, t0.description AS description_6, t0.genres AS genres_7, t0.created_at AS created_at_8, t0.rating AS rating_9, t0.author AS author_10, t0.external_id AS external_id_11, t0.status AS status_12, t0.thumbnail_url AS thumbnail_url_13, t0.monitored AS monitored_14, t0.alternative_slugs AS alternative_slugs_15 FROM manga t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "one-piece"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.image_url AS image_url_4,
  t0.publication_year AS publication_year_5,
  t0.description AS description_6,
  t0.genres AS genres_7,
  t0.created_at AS created_at_8,
  t0.rating AS rating_9,
  t0.author AS author_10,
  t0.external_id AS external_id_11,
  t0.status AS status_12,
  t0.thumbnail_url AS thumbnail_url_13,
  t0.monitored AS monitored_14,
  t0.alternative_slugs AS alternative_slugs_15
FROM
  manga t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image_url AS image_url_4, t0.publication_year AS publication_year_5, t0.description AS description_6, t0.genres AS genres_7, t0.created_at AS created_at_8, t0.rating AS rating_9, t0.author AS author_10, t0.external_id AS external_id_11, t0.status AS status_12, t0.thumbnail_url AS thumbnail_url_13, t0.monitored AS monitored_14, t0.alternative_slugs AS alternative_slugs_15 FROM manga t0 WHERE t0.slug = 'one-piece' 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 79)
4	App\Controller\MangaController->showChapters (line 178)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.76 ms
(3.90%)

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/manga/chapters/one-piece

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping