Symfony Profiler

Query Metrics

14 Database Queries

7 Different statements

9.77 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.47 ms
(45.69%)

SELECT t1.id AS id_2, t1.target AS target_3, t1.pages AS pages_4, t1.downloads AS downloads_5, t1.reading AS reading_6, t1.name AS name_7, t1.dir AS dir_8, t1.source AS source_9, t1.size AS size_10, t1.is_enabled AS is_enabled_11, t1.is_deleted AS is_deleted_12, t1.last_update AS last_update_13, t1.created_at AS created_at_14, t1.format_size AS format_size_15, t1.mimetype AS mimetype_16, t1.uuid AS uuid_17, t1.view_strategy AS view_strategy_18, t0.thumbnail_dir AS thumbnail_dir_19, t0.has_thumbnail AS has_thumbnail_20, t1.created_by_id AS created_by_id_21, t1.type FROM picture t0 INNER JOIN FILE t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  65
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.target AS target_3,
  t1.pages AS pages_4,
  t1.downloads AS downloads_5,
  t1.reading AS reading_6,
  t1.name AS name_7,
  t1.dir AS dir_8,
  t1.source AS source_9,
  t1.size AS size_10,
  t1.is_enabled AS is_enabled_11,
  t1.is_deleted AS is_deleted_12,
  t1.last_update AS last_update_13,
  t1.created_at AS created_at_14,
  t1.format_size AS format_size_15,
  t1.mimetype AS mimetype_16,
  t1.uuid AS uuid_17,
  t1.view_strategy AS view_strategy_18,
  t0.thumbnail_dir AS thumbnail_dir_19,
  t0.has_thumbnail AS has_thumbnail_20,
  t1.created_by_id AS created_by_id_21,
  t1.type
FROM
  picture t0
  INNER JOIN FILE t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.target AS target_3, t1.pages AS pages_4, t1.downloads AS downloads_5, t1.reading AS reading_6, t1.name AS name_7, t1.dir AS dir_8, t1.source AS source_9, t1.size AS size_10, t1.is_enabled AS is_enabled_11, t1.is_deleted AS is_deleted_12, t1.last_update AS last_update_13, t1.created_at AS created_at_14, t1.format_size AS format_size_15, t1.mimetype AS mimetype_16, t1.uuid AS uuid_17, t1.view_strategy AS view_strategy_18, t0.thumbnail_dir AS thumbnail_dir_19, t0.has_thumbnail AS has_thumbnail_20, t1.created_by_id AS created_by_id_21, t1.type FROM picture t0 INNER JOIN FILE t1 ON t0.id = t1.id WHERE t1.id = 65;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\File\Picture->__get (line 199)
7	App\Entity\File\File->getDir (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 113)
9	__TwigTemplate_238c4ec603dc3aa51a6dffb4b421823c->block_content (line 430)
10	Twig\Template->yieldBlock (line 1200)
11	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_body (line 430)
12	Twig\Template->yieldBlock (line 1058)
13	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_container (line 430)
14	Twig\Template->yieldBlock (line 197)
15	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_html (line 430)
16	Twig\Template->yieldBlock (line 96)
17	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->{closure} (line 1775)
18	Twig\Extension\CoreExtension::captureOutput (line 98)
19	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->doDisplay (line 360)
20	Twig\Template->yield (line 56)
21	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->doDisplay (line 360)
22	Twig\Template->yield (line 60)
23	__TwigTemplate_238c4ec603dc3aa51a6dffb4b421823c->doDisplay (line 360)
24	Twig\Template->yield (line 335)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 307)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 654)
31	App\Controller\DefaultController->getDetailsArticle (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

1.59 ms
(16.30%)

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_enabled AS is_enabled_8, t0.banner_id AS banner_id_9 FROM articles_categories t0 WHERE t0.is_enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.id AS id_4,
  t0.uuid AS uuid_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.is_enabled AS is_enabled_8,
  t0.banner_id AS banner_id_9
FROM
  articles_categories t0
WHERE
  t0.is_enabled = ?

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.uuid AS uuid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.is_enabled AS is_enabled_8, t0.banner_id AS banner_id_9 FROM articles_categories t0 WHERE t0.is_enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 30)
5	App\EventSubscriber\HandleMenu->onKernelRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.96 ms
(9.80%)

SELECT a0_.title AS title_0, a0_.description AS description_1, a0_.content AS content_2, a0_.slug AS slug_3, a0_.date AS date_4, a0_.is_on_front_page AS is_on_front_page_5, a0_.is_visible AS is_visible_6, a0_.is_deleted AS is_deleted_7, a0_.flickr AS flickr_8, a0_.url AS url_9, a0_.soundcloud AS soundcloud_10, a0_.tags AS tags_11, a0_.is_enabled AS is_enabled_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.id AS id_15, a0_.uuid AS uuid_16, a0_.type_id AS type_id_17, a0_.album_id AS album_id_18, a0_.biblio_id AS biblio_id_19, a0_.user_id AS user_id_20, a0_.updated_by_id AS updated_by_id_21, a0_.category_id AS category_id_22, a0_.specialites_id AS specialites_id_23, a0_.banner_id AS banner_id_24, a0_.video_id AS video_id_25 FROM articles a0_ WHERE a0_.id <> ? ORDER BY a0_.date ASC LIMIT 6

Parameters:

[
  "5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.title AS title_0,
  a0_.description AS description_1,
  a0_.content AS content_2,
  a0_.slug AS slug_3,
  a0_.date AS date_4,
  a0_.is_on_front_page AS is_on_front_page_5,
  a0_.is_visible AS is_visible_6,
  a0_.is_deleted AS is_deleted_7,
  a0_.flickr AS flickr_8,
  a0_.url AS url_9,
  a0_.soundcloud AS soundcloud_10,
  a0_.tags AS tags_11,
  a0_.is_enabled AS is_enabled_12,
  a0_.created_at AS created_at_13,
  a0_.updated_at AS updated_at_14,
  a0_.id AS id_15,
  a0_.uuid AS uuid_16,
  a0_.type_id AS type_id_17,
  a0_.album_id AS album_id_18,
  a0_.biblio_id AS biblio_id_19,
  a0_.user_id AS user_id_20,
  a0_.updated_by_id AS updated_by_id_21,
  a0_.category_id AS category_id_22,
  a0_.specialites_id AS specialites_id_23,
  a0_.banner_id AS banner_id_24,
  a0_.video_id AS video_id_25
FROM
  articles a0_
WHERE
  a0_.id <> ?
ORDER BY
  a0_.date ASC
LIMIT
  6

SELECT a0_.title AS title_0, a0_.description AS description_1, a0_.content AS content_2, a0_.slug AS slug_3, a0_.date AS date_4, a0_.is_on_front_page AS is_on_front_page_5, a0_.is_visible AS is_visible_6, a0_.is_deleted AS is_deleted_7, a0_.flickr AS flickr_8, a0_.url AS url_9, a0_.soundcloud AS soundcloud_10, a0_.tags AS tags_11, a0_.is_enabled AS is_enabled_12, a0_.created_at AS created_at_13, a0_.updated_at AS updated_at_14, a0_.id AS id_15, a0_.uuid AS uuid_16, a0_.type_id AS type_id_17, a0_.album_id AS album_id_18, a0_.biblio_id AS biblio_id_19, a0_.user_id AS user_id_20, a0_.updated_by_id AS updated_by_id_21, a0_.category_id AS category_id_22, a0_.specialites_id AS specialites_id_23, a0_.banner_id AS banner_id_24, a0_.video_id AS video_id_25 FROM articles a0_ WHERE a0_.id <> '5' ORDER BY a0_.date ASC LIMIT 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 112)
7	App\Repository\Article\ArticlesRepository->getOthersArticles (line 643)
8	App\Controller\DefaultController->getDetailsArticle (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.85 ms
(8.73%)

SELECT t0.title AS title_1, t0.description AS description_2, t0.content AS content_3, t0.slug AS slug_4, t0.date AS date_5, t0.is_on_front_page AS is_on_front_page_6, t0.is_visible AS is_visible_7, t0.is_deleted AS is_deleted_8, t0.flickr AS flickr_9, t0.url AS url_10, t0.soundcloud AS soundcloud_11, t0.tags AS tags_12, t0.is_enabled AS is_enabled_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.type_id AS type_id_18, t0.album_id AS album_id_19, t0.biblio_id AS biblio_id_20, t0.user_id AS user_id_21, t0.updated_by_id AS updated_by_id_22, t0.category_id AS category_id_23, t0.specialites_id AS specialites_id_24, t0.banner_id AS banner_id_25, t0.video_id AS video_id_26 FROM articles t0 WHERE t0.id = ? AND t0.is_enabled = ? LIMIT 1

Parameters:

[
  "5"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.content AS content_3,
  t0.slug AS slug_4,
  t0.date AS date_5,
  t0.is_on_front_page AS is_on_front_page_6,
  t0.is_visible AS is_visible_7,
  t0.is_deleted AS is_deleted_8,
  t0.flickr AS flickr_9,
  t0.url AS url_10,
  t0.soundcloud AS soundcloud_11,
  t0.tags AS tags_12,
  t0.is_enabled AS is_enabled_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.id AS id_16,
  t0.uuid AS uuid_17,
  t0.type_id AS type_id_18,
  t0.album_id AS album_id_19,
  t0.biblio_id AS biblio_id_20,
  t0.user_id AS user_id_21,
  t0.updated_by_id AS updated_by_id_22,
  t0.category_id AS category_id_23,
  t0.specialites_id AS specialites_id_24,
  t0.banner_id AS banner_id_25,
  t0.video_id AS video_id_26
FROM
  articles t0
WHERE
  t0.id = ?
  AND t0.is_enabled = ?
LIMIT
  1

SELECT t0.title AS title_1, t0.description AS description_2, t0.content AS content_3, t0.slug AS slug_4, t0.date AS date_5, t0.is_on_front_page AS is_on_front_page_6, t0.is_visible AS is_visible_7, t0.is_deleted AS is_deleted_8, t0.flickr AS flickr_9, t0.url AS url_10, t0.soundcloud AS soundcloud_11, t0.tags AS tags_12, t0.is_enabled AS is_enabled_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.id AS id_16, t0.uuid AS uuid_17, t0.type_id AS type_id_18, t0.album_id AS album_id_19, t0.biblio_id AS biblio_id_20, t0.user_id AS user_id_21, t0.updated_by_id AS updated_by_id_22, t0.category_id AS category_id_23, t0.specialites_id AS specialites_id_24, t0.banner_id AS banner_id_25, t0.video_id AS video_id_26 FROM articles t0 WHERE t0.id = '5' AND t0.is_enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 635)
5	App\Controller\DefaultController->getDetailsArticle (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.76 ms
(7.79%)

SELECT t1.id AS id_2, t1.target AS target_3, t1.pages AS pages_4, t1.downloads AS downloads_5, t1.reading AS reading_6, t1.name AS name_7, t1.dir AS dir_8, t1.source AS source_9, t1.size AS size_10, t1.is_enabled AS is_enabled_11, t1.is_deleted AS is_deleted_12, t1.last_update AS last_update_13, t1.created_at AS created_at_14, t1.format_size AS format_size_15, t1.mimetype AS mimetype_16, t1.uuid AS uuid_17, t1.view_strategy AS view_strategy_18, t0.thumbnail_dir AS thumbnail_dir_19, t0.has_thumbnail AS has_thumbnail_20, t1.created_by_id AS created_by_id_21, t1.type FROM picture t0 INNER JOIN FILE t1 ON t0.id = t1.id INNER JOIN albums_picture ON t0.id = albums_picture.picture_id WHERE albums_picture.albums_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.target AS target_3,
  t1.pages AS pages_4,
  t1.downloads AS downloads_5,
  t1.reading AS reading_6,
  t1.name AS name_7,
  t1.dir AS dir_8,
  t1.source AS source_9,
  t1.size AS size_10,
  t1.is_enabled AS is_enabled_11,
  t1.is_deleted AS is_deleted_12,
  t1.last_update AS last_update_13,
  t1.created_at AS created_at_14,
  t1.format_size AS format_size_15,
  t1.mimetype AS mimetype_16,
  t1.uuid AS uuid_17,
  t1.view_strategy AS view_strategy_18,
  t0.thumbnail_dir AS thumbnail_dir_19,
  t0.has_thumbnail AS has_thumbnail_20,
  t1.created_by_id AS created_by_id_21,
  t1.type
FROM
  picture t0
  INNER JOIN FILE t1 ON t0.id = t1.id
  INNER JOIN albums_picture ON t0.id = albums_picture.picture_id
WHERE
  albums_picture.albums_id = ?

SELECT t1.id AS id_2, t1.target AS target_3, t1.pages AS pages_4, t1.downloads AS downloads_5, t1.reading AS reading_6, t1.name AS name_7, t1.dir AS dir_8, t1.source AS source_9, t1.size AS size_10, t1.is_enabled AS is_enabled_11, t1.is_deleted AS is_deleted_12, t1.last_update AS last_update_13, t1.created_at AS created_at_14, t1.format_size AS format_size_15, t1.mimetype AS mimetype_16, t1.uuid AS uuid_17, t1.view_strategy AS view_strategy_18, t0.thumbnail_dir AS thumbnail_dir_19, t0.has_thumbnail AS has_thumbnail_20, t1.created_by_id AS created_by_id_21, t1.type FROM picture t0 INNER JOIN FILE t1 ON t0.id = t1.id INNER JOIN albums_picture ON t0.id = albums_picture.picture_id WHERE albums_picture.albums_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 1444)
8	__TwigTemplate_cafd0170a410135da0368521428c1065->{closure} (line 1775)
9	Twig\Extension\CoreExtension::captureOutput (line 1537)
10	__TwigTemplate_cafd0170a410135da0368521428c1065->macro_albums (line 1228)
11	Twig\Extension\CoreExtension::callMacro (line 192)
12	__TwigTemplate_238c4ec603dc3aa51a6dffb4b421823c->block_content (line 430)
13	Twig\Template->yieldBlock (line 1200)
14	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_body (line 430)
15	Twig\Template->yieldBlock (line 1058)
16	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_container (line 430)
17	Twig\Template->yieldBlock (line 197)
18	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_html (line 430)
19	Twig\Template->yieldBlock (line 96)
20	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->{closure} (line 1775)
21	Twig\Extension\CoreExtension::captureOutput (line 98)
22	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->doDisplay (line 360)
23	Twig\Template->yield (line 56)
24	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->doDisplay (line 360)
25	Twig\Template->yield (line 60)
26	__TwigTemplate_238c4ec603dc3aa51a6dffb4b421823c->doDisplay (line 360)
27	Twig\Template->yield (line 335)
28	Twig\Template->render (line 38)
29	Twig\TemplateWrapper->render (line 307)
30	Twig\Environment->render (line 448)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 654)
34	App\Controller\DefaultController->getDetailsArticle (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

0.62 ms
(6.30%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type_video AS type_video_4, t0.content AS content_5, t0.slug AS slug_6, t0.youtube AS youtube_7, t0.tags AS tags_8, t0.date AS date_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.banner_id AS banner_id_13, t0.file_id AS file_id_14, t0.biblio_id AS biblio_id_15, t0.category_id AS category_id_16, t17.id AS id_18, t17.label AS label_19, t17.description AS description_20, t17.slug AS slug_21, t17.created_at AS created_at_22, t17.updated_at AS updated_at_23, t17.is_enabled AS is_enabled_24 FROM videos t0 LEFT JOIN videos_categories t17 ON t0.category_id = t17.id WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.type_video AS type_video_4,
  t0.content AS content_5,
  t0.slug AS slug_6,
  t0.youtube AS youtube_7,
  t0.tags AS tags_8,
  t0.date AS date_9,
  t0.is_enabled AS is_enabled_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.banner_id AS banner_id_13,
  t0.file_id AS file_id_14,
  t0.biblio_id AS biblio_id_15,
  t0.category_id AS category_id_16,
  t17.id AS id_18,
  t17.label AS label_19,
  t17.description AS description_20,
  t17.slug AS slug_21,
  t17.created_at AS created_at_22,
  t17.updated_at AS updated_at_23,
  t17.is_enabled AS is_enabled_24
FROM
  videos t0
  LEFT JOIN videos_categories t17 ON t0.category_id = t17.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type_video AS type_video_4, t0.content AS content_5, t0.slug AS slug_6, t0.youtube AS youtube_7, t0.tags AS tags_8, t0.date AS date_9, t0.is_enabled AS is_enabled_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.banner_id AS banner_id_13, t0.file_id AS file_id_14, t0.biblio_id AS biblio_id_15, t0.category_id AS category_id_16, t17.id AS id_18, t17.label AS label_19, t17.description AS description_20, t17.slug AS slug_21, t17.created_at AS created_at_22, t17.updated_at AS updated_at_23, t17.is_enabled AS is_enabled_24 FROM videos t0 LEFT JOIN videos_categories t17 ON t0.category_id = t17.id WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\Videos->__get (line 147)
7	App\Entity\Videos->getTypeVideo (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 231)
9	__TwigTemplate_238c4ec603dc3aa51a6dffb4b421823c->block_content (line 430)
10	Twig\Template->yieldBlock (line 1200)
11	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_body (line 430)
12	Twig\Template->yieldBlock (line 1058)
13	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_container (line 430)
14	Twig\Template->yieldBlock (line 197)
15	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_html (line 430)
16	Twig\Template->yieldBlock (line 96)
17	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->{closure} (line 1775)
18	Twig\Extension\CoreExtension::captureOutput (line 98)
19	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->doDisplay (line 360)
20	Twig\Template->yield (line 56)
21	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->doDisplay (line 360)
22	Twig\Template->yield (line 60)
23	__TwigTemplate_238c4ec603dc3aa51a6dffb4b421823c->doDisplay (line 360)
24	Twig\Template->yield (line 335)
25	Twig\Template->render (line 38)
26	Twig\TemplateWrapper->render (line 307)
27	Twig\Environment->render (line 448)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 654)
31	App\Controller\DefaultController->getDetailsArticle (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

0.53 ms
(5.38%)

SELECT t0.title AS title_1, t0.is_enabled AS is_enabled_2, t0.id AS id_3, t0.uuid AS uuid_4 FROM albums t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.title AS title_1,
  t0.is_enabled AS is_enabled_2,
  t0.id AS id_3,
  t0.uuid AS uuid_4
FROM
  albums t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.is_enabled AS is_enabled_2, t0.id AS id_3, t0.uuid AS uuid_4 FROM albums t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
6	Proxies\__CG__\App\Entity\Article\Albums->__get (line 80)
7	App\Entity\Article\Albums->getPictures (line 1629)
8	Twig\Extension\CoreExtension::getAttribute (line 1443)
9	__TwigTemplate_cafd0170a410135da0368521428c1065->{closure} (line 1775)
10	Twig\Extension\CoreExtension::captureOutput (line 1537)
11	__TwigTemplate_cafd0170a410135da0368521428c1065->macro_albums (line 1228)
12	Twig\Extension\CoreExtension::callMacro (line 192)
13	__TwigTemplate_238c4ec603dc3aa51a6dffb4b421823c->block_content (line 430)
14	Twig\Template->yieldBlock (line 1200)
15	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_body (line 430)
16	Twig\Template->yieldBlock (line 1058)
17	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_container (line 430)
18	Twig\Template->yieldBlock (line 197)
19	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->block_html (line 430)
20	Twig\Template->yieldBlock (line 96)
21	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->{closure} (line 1775)
22	Twig\Extension\CoreExtension::captureOutput (line 98)
23	__TwigTemplate_22a9c4f495aeb58c1d49cecb7389cdb5->doDisplay (line 360)
24	Twig\Template->yield (line 56)
25	__TwigTemplate_9d1d01f5fe3a2c83d9588d877ea3f205->doDisplay (line 360)
26	Twig\Template->yield (line 60)
27	__TwigTemplate_238c4ec603dc3aa51a6dffb4b421823c->doDisplay (line 360)
28	Twig\Template->yield (line 335)
29	Twig\Template->render (line 38)
30	Twig\TemplateWrapper->render (line 307)
31	Twig\Environment->render (line 448)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 654)
35	App\Controller\DefaultController->getDetailsArticle (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
38	Symfony\Component\HttpKernel\Kernel->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	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\Article\ArticlesCategories	No errors.
App\Entity\File\File	No errors.
App\Entity\File\Picture	No errors.
App\Entity\Article\Articles	No errors.
App\Entity\Article\ArticlesTypes	No errors.
App\Entity\Article\Albums	No errors.
App\Entity\File\Biblios	No errors.
App\Entity\Users	No errors.
App\Entity\Specialite	No errors.
App\Entity\Videos	No errors.
App\Entity\VideosCategories	No errors.

Symfony Profiler

GET https://cliniqueserena.com/article/5/ramadan-moubarak-toute-communaute-musulmane

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping