Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

4.84 ms Query time

0 Invalid entities

44 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.82 ms
(16.98%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = ? AND c1_.id = ? ORDER BY v0_.release_date DESC, v0_.id DESC) dctrn_result) dctrn_table

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          v0_.id AS id_0,
          v0_.name AS name_1,
          v0_.slug AS slug_2,
          v0_.out_slug AS out_slug_3,
          v0_.active AS active_4,
          v0_.release_date AS release_date_5,
          v0_.duration AS duration_6,
          v0_.fps AS fps_7,
          v0_.angle AS angle_8,
          v0_.resolution AS resolution_9,
          v0_.sound AS sound_10,
          v0_.description AS description_11
        FROM
          video v0_
          INNER JOIN video_category v2_ ON v0_.id = v2_.video_id
          INNER JOIN category c1_ ON c1_.id = v2_.category_id
        WHERE
          v0_.active = ?
          AND c1_.id = ?
        ORDER BY
          v0_.release_date DESC,
          v0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = 1 AND c1_.id = 2 ORDER BY v0_.release_date DESC, v0_.id DESC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 42)
8	Pagerfanta\Pagerfanta->getNbResults (line 292)
9	Pagerfanta\Pagerfanta->count (line 405)
10	Twig\Extension\CoreExtension->length (line 1278)
11	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5::block_body (line 180)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_9697733083cb519069d71de4755f7265->doDisplay (line 105)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->doDisplay (line 54)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
24	App\Controller\CategoriesController->category (line 52)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.79 ms
(16.33%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 INNER JOIN video_category ON t0.id = video_category.category_id WHERE video_category.video_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.sort_order AS sort_order_6,
  t0.featured AS featured_7,
  t0.short_description AS short_description_8,
  t0.description AS description_9
FROM
  category t0
  INNER JOIN video_category ON t0.id = video_category.category_id
WHERE
  video_category.video_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 INNER JOIN video_category ON t0.id = video_category.category_id WHERE video_category.video_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	iterator_to_array (line 1398)
8	Twig\Extension\CoreExtension::toArray (line 1398)
9	Twig\Extension\CoreExtension::join (line 840)
10	__TwigTemplate_41908b4607a7985f36d5cbbab3bc13ec::doDisplay (line 155)
11	Twig\Template->yield (line 411)
12	__TwigTemplate_ee3549af11d9a3be5fe4c08354254783->doDisplay (line 78)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->block_body (line 196)
15	Twig\Template->yieldBlock (line 456)
16	__TwigTemplate_9697733083cb519069d71de4755f7265->doDisplay (line 105)
17	Twig\Template->yield (line 411)
18	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->doDisplay (line 54)
19	Twig\Template->yield (line 411)
20	Twig\Template->display (line 366)
21	Twig\Template->render (line 381)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
27	App\Controller\CategoriesController->category (line 52)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 191)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.69 ms
(14.35%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5::block_body (line 132)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_9697733083cb519069d71de4755f7265->doDisplay (line 105)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
22	App\Controller\CategoriesController->category (line 52)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 191)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.68 ms
(14.10%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, release_date_5 FROM (SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, c1_.out_slug AS out_slug_15, c1_.active AS active_16, c1_.sort_order AS sort_order_17, c1_.featured AS featured_18, c1_.short_description AS short_description_19, c1_.description AS description_20 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = ? AND c1_.id = ?) dctrn_result_inner ORDER BY release_date_5 DESC, id_0 DESC) dctrn_result LIMIT 24

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      release_date_5
    FROM
      (
        SELECT
          v0_.id AS id_0,
          v0_.name AS name_1,
          v0_.slug AS slug_2,
          v0_.out_slug AS out_slug_3,
          v0_.active AS active_4,
          v0_.release_date AS release_date_5,
          v0_.duration AS duration_6,
          v0_.fps AS fps_7,
          v0_.angle AS angle_8,
          v0_.resolution AS resolution_9,
          v0_.sound AS sound_10,
          v0_.description AS description_11,
          c1_.id AS id_12,
          c1_.name AS name_13,
          c1_.slug AS slug_14,
          c1_.out_slug AS out_slug_15,
          c1_.active AS active_16,
          c1_.sort_order AS sort_order_17,
          c1_.featured AS featured_18,
          c1_.short_description AS short_description_19,
          c1_.description AS description_20
        FROM
          video v0_
          INNER JOIN video_category v2_ ON v0_.id = v2_.video_id
          INNER JOIN category c1_ ON c1_.id = v2_.category_id
        WHERE
          v0_.active = ?
          AND c1_.id = ?
      ) dctrn_result_inner
    ORDER BY
      release_date_5 DESC,
      id_0 DESC
  ) dctrn_result
LIMIT
  24

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, release_date_5 FROM (SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11, c1_.id AS id_12, c1_.name AS name_13, c1_.slug AS slug_14, c1_.out_slug AS out_slug_15, c1_.active AS active_16, c1_.sort_order AS sort_order_17, c1_.featured AS featured_18, c1_.short_description AS short_description_19, c1_.description AS description_20 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = 1 AND c1_.id = 2) dctrn_result_inner ORDER BY release_date_5 DESC, id_0 DESC) dctrn_result LIMIT 24;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	Pagerfanta\Pagerfanta->getIterator (line 415)
11	__TwigTemplate_ee3549af11d9a3be5fe4c08354254783->doDisplay (line 75)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->block_body (line 196)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_9697733083cb519069d71de4755f7265->doDisplay (line 105)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->doDisplay (line 54)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
26	App\Controller\CategoriesController->category (line 52)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.52 ms
(10.75%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "180"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.sort_order AS sort_order_6,
  t0.featured AS featured_7,
  t0.short_description AS short_description_8,
  t0.description AS description_9
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.featured AS featured_7, t0.short_description AS short_description_8, t0.description AS description_9 FROM category t0 WHERE t0.slug = '180' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\CategoriesController->category (line 41)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.50 ms
(10.34%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.ethnicity AS ethnicity_10, t0.hair_color AS hair_color_11, t0.eye_color AS eye_color_12, t0.height AS height_13, t0.weight AS weight_14, t0.measurements_hip AS measurements_hip_15, t0.measurements_waist AS measurements_waist_16, t0.measurements_bust AS measurements_bust_17, t0.shoe_size AS shoe_size_18, t0.description AS description_19, t0.views AS views_20 FROM model t0 INNER JOIN video_model ON t0.id = video_model.model_id WHERE video_model.video_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.sort_order AS sort_order_6,
  t0.date_of_birth AS date_of_birth_7,
  t0.nationality AS nationality_8,
  t0.gender AS gender_9,
  t0.ethnicity AS ethnicity_10,
  t0.hair_color AS hair_color_11,
  t0.eye_color AS eye_color_12,
  t0.height AS height_13,
  t0.weight AS weight_14,
  t0.measurements_hip AS measurements_hip_15,
  t0.measurements_waist AS measurements_waist_16,
  t0.measurements_bust AS measurements_bust_17,
  t0.shoe_size AS shoe_size_18,
  t0.description AS description_19,
  t0.views AS views_20
FROM
  model t0
  INNER JOIN video_model ON t0.id = video_model.model_id
WHERE
  video_model.video_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.date_of_birth AS date_of_birth_7, t0.nationality AS nationality_8, t0.gender AS gender_9, t0.ethnicity AS ethnicity_10, t0.hair_color AS hair_color_11, t0.eye_color AS eye_color_12, t0.height AS height_13, t0.weight AS weight_14, t0.measurements_hip AS measurements_hip_15, t0.measurements_waist AS measurements_waist_16, t0.measurements_bust AS measurements_bust_17, t0.shoe_size AS shoe_size_18, t0.description AS description_19, t0.views AS views_20 FROM model t0 INNER JOIN video_model ON t0.id = video_model.model_id WHERE video_model.video_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_41908b4607a7985f36d5cbbab3bc13ec::doDisplay (line 136)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_ee3549af11d9a3be5fe4c08354254783->doDisplay (line 78)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->block_body (line 196)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_9697733083cb519069d71de4755f7265->doDisplay (line 105)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->doDisplay (line 54)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
26	App\Controller\CategoriesController->category (line 52)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.45 ms
(9.33%)

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11, v0_.studio_id AS studio_id_12 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = ? AND c1_.id = ? AND v0_.id IN (?) ORDER BY v0_.release_date DESC, v0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.slug AS slug_2,
  v0_.out_slug AS out_slug_3,
  v0_.active AS active_4,
  v0_.release_date AS release_date_5,
  v0_.duration AS duration_6,
  v0_.fps AS fps_7,
  v0_.angle AS angle_8,
  v0_.resolution AS resolution_9,
  v0_.sound AS sound_10,
  v0_.description AS description_11,
  v0_.studio_id AS studio_id_12
FROM
  video v0_
  INNER JOIN video_category v2_ ON v0_.id = v2_.video_id
  INNER JOIN category c1_ ON c1_.id = v2_.category_id
WHERE
  v0_.active = ?
  AND c1_.id = ?
  AND v0_.id IN (?)
ORDER BY
  v0_.release_date DESC,
  v0_.id DESC

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.out_slug AS out_slug_3, v0_.active AS active_4, v0_.release_date AS release_date_5, v0_.duration AS duration_6, v0_.fps AS fps_7, v0_.angle AS angle_8, v0_.resolution AS resolution_9, v0_.sound AS sound_10, v0_.description AS description_11, v0_.studio_id AS studio_id_12 FROM video v0_ INNER JOIN video_category v2_ ON v0_.id = v2_.video_id INNER JOIN category c1_ ON c1_.id = v2_.category_id WHERE v0_.active = 1 AND c1_.id = 2 AND v0_.id IN (1) ORDER BY v0_.release_date DESC, v0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 260)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 249)
10	Pagerfanta\Pagerfanta->getIterator (line 415)
11	__TwigTemplate_ee3549af11d9a3be5fe4c08354254783->doDisplay (line 75)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->block_body (line 196)
14	Twig\Template->yieldBlock (line 456)
15	__TwigTemplate_9697733083cb519069d71de4755f7265->doDisplay (line 105)
16	Twig\Template->yield (line 411)
17	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->doDisplay (line 54)
18	Twig\Template->yield (line 411)
19	Twig\Template->display (line 366)
20	Twig\Template->render (line 381)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
26	App\Controller\CategoriesController->category (line 52)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.38 ms
(7.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.sort_order AS sort_order_6,
  t0.description AS description_7,
  t0.cos_address AS cos_address_8,
  t0.country AS country_9,
  t0.founded AS founded_10
FROM
  studio t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.sort_order AS sort_order_6, t0.description AS description_7, t0.cos_address AS cos_address_8, t0.country AS country_9, t0.founded AS founded_10 FROM studio t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Studio::getName (line 70)
5	App\Entity\Studio->__toString (line 208)
6	Twig\Runtime\EscaperRuntime->escape (line 126)
7	__TwigTemplate_41908b4607a7985f36d5cbbab3bc13ec->doDisplay (line 128)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_ee3549af11d9a3be5fe4c08354254783->doDisplay (line 78)
10	Twig\Template->yield (line 411)
11	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->block_body (line 196)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_9697733083cb519069d71de4755f7265->doDisplay (line 105)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_1910b20aeb0b4a92695e623f72531ec5->doDisplay (line 54)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
24	App\Controller\CategoriesController->category (line 52)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 191)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	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\Category	41
App\Entity\Video	1
App\Entity\Studio	1
App\Entity\Model	1

Entities Mapping

Class	Mapping errors
App\Entity\Category	No errors.
App\Entity\Video	No errors.
App\Entity\Studio	No errors.
App\Entity\Model	No errors.

Symfony Profiler

GET https://newvirtualrealityporn.com/tags/180

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping