Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

9.41 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.44 ms
(36.58%)

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.slug AS slug_3, v0_.status AS status_4, v0_.mime_type AS mime_type_5, v0_.file_name AS file_name_6, v0_.picture AS picture_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.duration AS duration_10, v0_.file_size AS file_size_11, v0_.total_view AS total_view_12, v0_.total_like AS total_like_13, v0_.total_dislike AS total_dislike_14, v0_.total_download AS total_download_15, v0_.lang_slug AS lang_slug_16, v0_.file_path AS file_path_17 FROM video v0_ LEFT JOIN language l1_ ON v0_.language = l1_.id WHERE l1_.slug = ? AND v0_.status = 1 ORDER BY v0_.id DESC

Parameters:

[
  "gujarati-status"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.description AS description_2,
  v0_.slug AS slug_3,
  v0_.status AS status_4,
  v0_.mime_type AS mime_type_5,
  v0_.file_name AS file_name_6,
  v0_.picture AS picture_7,
  v0_.created_at AS created_at_8,
  v0_.updated_at AS updated_at_9,
  v0_.duration AS duration_10,
  v0_.file_size AS file_size_11,
  v0_.total_view AS total_view_12,
  v0_.total_like AS total_like_13,
  v0_.total_dislike AS total_dislike_14,
  v0_.total_download AS total_download_15,
  v0_.lang_slug AS lang_slug_16,
  v0_.file_path AS file_path_17
FROM
  video v0_
  LEFT JOIN language l1_ ON v0_.language = l1_.id
WHERE
  l1_.slug = ?
  AND v0_.status = 1
ORDER BY
  v0_.id DESC

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.slug AS slug_3, v0_.status AS status_4, v0_.mime_type AS mime_type_5, v0_.file_name AS file_name_6, v0_.picture AS picture_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.duration AS duration_10, v0_.file_size AS file_size_11, v0_.total_view AS total_view_12, v0_.total_like AS total_like_13, v0_.total_dislike AS total_dislike_14, v0_.total_download AS total_download_15, v0_.lang_slug AS lang_slug_16, v0_.file_path AS file_path_17 FROM video v0_ LEFT JOIN language l1_ ON v0_.language = l1_.id WHERE l1_.slug = 'gujarati-status' AND v0_.status = 1 ORDER BY v0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Repository\VideoRepository->getLanguageWiseList (line 177)
7	App\Controller\DefaultController->languageListAction (line 286)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.91 ms
(20.30%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4 FROM language t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "gujarati-status"
]

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.display_name AS display_name_4
FROM
  language t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4 FROM language t0 WHERE t0.slug = 'gujarati-status' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 776)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\DefaultController->languageListAction (line 283)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

1.26 ms
(13.33%)

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.display_name AS display_name_2, v0_.slug AS slug_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.image_name AS image_name_6, v0_.title AS title_7, v0_.cat_desc AS cat_desc_8, v0_.seo_desc AS seo_desc_9, v0_.seo_title AS seo_title_10, v0_.desc_title AS desc_title_11, v0_.keywords AS keywords_12, v0_.has_child AS has_child_13, v0_.video_count AS video_count_14 FROM vid_category v0_ WHERE v0_.parent_id IS NULL AND v0_.video_count > ? ORDER BY v0_.name ASC LIMIT 5

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.display_name AS display_name_2,
  v0_.slug AS slug_3,
  v0_.created_at AS created_at_4,
  v0_.updated_at AS updated_at_5,
  v0_.image_name AS image_name_6,
  v0_.title AS title_7,
  v0_.cat_desc AS cat_desc_8,
  v0_.seo_desc AS seo_desc_9,
  v0_.seo_title AS seo_title_10,
  v0_.desc_title AS desc_title_11,
  v0_.keywords AS keywords_12,
  v0_.has_child AS has_child_13,
  v0_.video_count AS video_count_14
FROM
  vid_category v0_
WHERE
  v0_.parent_id IS NULL
  AND v0_.video_count > ?
ORDER BY
  v0_.name ASC
LIMIT
  5

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.display_name AS display_name_2, v0_.slug AS slug_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.image_name AS image_name_6, v0_.title AS title_7, v0_.cat_desc AS cat_desc_8, v0_.seo_desc AS seo_desc_9, v0_.seo_title AS seo_title_10, v0_.desc_title AS desc_title_11, v0_.keywords AS keywords_12, v0_.has_child AS has_child_13, v0_.video_count AS video_count_14 FROM vid_category v0_ WHERE v0_.parent_id IS NULL AND v0_.video_count > 0 ORDER BY v0_.name ASC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Twig\AppExtension->getCategory (line 88)
7	__TwigTemplate_facb248868d1b1b619d6eb6cfeba1caa->doDisplay (line 70)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_be2d577de38a3aa06cb7369a0efbaf1b->block_body (line 247)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4d76e9cd93a6cd1dc9fb00472e10c149->doDisplay (line 138)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_be2d577de38a3aa06cb7369a0efbaf1b->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\DefaultController->languageListAction (line 294)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

1.13 ms
(11.97%)

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.picture AS picture_2, v0_.slug AS slug_3, v0_.file_size AS file_size_4, v0_.total_view AS total_view_5, v0_.duration AS duration_6, v0_.slug AS slug_7, v1_.id AS id_8, v1_.name AS name_9, v1_.slug AS slug_10 FROM video v0_ LEFT JOIN vid_category v1_ ON v0_.category = v1_.id WHERE v0_.status = 1 ORDER BY v0_.id DESC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.picture AS picture_2,
  v0_.slug AS slug_3,
  v0_.file_size AS file_size_4,
  v0_.total_view AS total_view_5,
  v0_.duration AS duration_6,
  v0_.slug AS slug_7,
  v1_.id AS id_8,
  v1_.name AS name_9,
  v1_.slug AS slug_10
FROM
  video v0_
  LEFT JOIN vid_category v1_ ON v0_.category = v1_.id
WHERE
  v0_.status = 1
ORDER BY
  v0_.id DESC
LIMIT
  5

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.picture AS picture_2, v0_.slug AS slug_3, v0_.file_size AS file_size_4, v0_.total_view AS total_view_5, v0_.duration AS duration_6, v0_.slug AS slug_7, v1_.id AS id_8, v1_.name AS name_9, v1_.slug AS slug_10 FROM video v0_ LEFT JOIN vid_category v1_ ON v0_.category = v1_.id WHERE v0_.status = 1 ORDER BY v0_.id DESC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Twig\AppExtension->latestVideos (line 116)
7	__TwigTemplate_be2d577de38a3aa06cb7369a0efbaf1b->block_body (line 253)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_4d76e9cd93a6cd1dc9fb00472e10c149->doDisplay (line 138)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_be2d577de38a3aa06cb7369a0efbaf1b->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\DefaultController->languageListAction (line 294)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.94 ms
(10.03%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.display_name AS display_name_3, f0_.image_name AS image_name_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.title AS title_7, f0_.cat_desc AS cat_desc_8, f0_.seo_title AS seo_title_9, f0_.keywords AS keywords_10, f0_.seo_desc AS seo_desc_11, f0_.desc_title AS desc_title_12, f0_.video_count AS video_count_13 FROM festival f0_ WHERE f0_.video_count > ? ORDER BY f0_.name ASC LIMIT 5

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.slug AS slug_2,
  f0_.display_name AS display_name_3,
  f0_.image_name AS image_name_4,
  f0_.created_at AS created_at_5,
  f0_.updated_at AS updated_at_6,
  f0_.title AS title_7,
  f0_.cat_desc AS cat_desc_8,
  f0_.seo_title AS seo_title_9,
  f0_.keywords AS keywords_10,
  f0_.seo_desc AS seo_desc_11,
  f0_.desc_title AS desc_title_12,
  f0_.video_count AS video_count_13
FROM
  festival f0_
WHERE
  f0_.video_count > ?
ORDER BY
  f0_.name ASC
LIMIT
  5

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.display_name AS display_name_3, f0_.image_name AS image_name_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.title AS title_7, f0_.cat_desc AS cat_desc_8, f0_.seo_title AS seo_title_9, f0_.keywords AS keywords_10, f0_.seo_desc AS seo_desc_11, f0_.desc_title AS desc_title_12, f0_.video_count AS video_count_13 FROM festival f0_ WHERE f0_.video_count > 0 ORDER BY f0_.name ASC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Twig\AppExtension->getFestivals (line 146)
7	__TwigTemplate_facb248868d1b1b619d6eb6cfeba1caa->doDisplay (line 156)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_be2d577de38a3aa06cb7369a0efbaf1b->block_body (line 247)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4d76e9cd93a6cd1dc9fb00472e10c149->doDisplay (line 138)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_be2d577de38a3aa06cb7369a0efbaf1b->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\DefaultController->languageListAction (line 294)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.73 ms
(7.79%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.display_name AS display_name_3, s0_.image_name AS image_name_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.title AS title_7, s0_.cat_desc AS cat_desc_8, s0_.seo_title AS seo_title_9, s0_.keywords AS keywords_10, s0_.seo_desc AS seo_desc_11, s0_.desc_title AS desc_title_12, s0_.video_count AS video_count_13 FROM singer s0_ WHERE s0_.video_count > ? ORDER BY s0_.name ASC LIMIT 5

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.display_name AS display_name_3,
  s0_.image_name AS image_name_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.title AS title_7,
  s0_.cat_desc AS cat_desc_8,
  s0_.seo_title AS seo_title_9,
  s0_.keywords AS keywords_10,
  s0_.seo_desc AS seo_desc_11,
  s0_.desc_title AS desc_title_12,
  s0_.video_count AS video_count_13
FROM
  singer s0_
WHERE
  s0_.video_count > ?
ORDER BY
  s0_.name ASC
LIMIT
  5

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.display_name AS display_name_3, s0_.image_name AS image_name_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.title AS title_7, s0_.cat_desc AS cat_desc_8, s0_.seo_title AS seo_title_9, s0_.keywords AS keywords_10, s0_.seo_desc AS seo_desc_11, s0_.desc_title AS desc_title_12, s0_.video_count AS video_count_13 FROM singer s0_ WHERE s0_.video_count > 0 ORDER BY s0_.name ASC LIMIT 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1218)
4	Doctrine\ORM\AbstractQuery->execute (line 1172)
5	Doctrine\ORM\AbstractQuery->getResult (line 907)
6	App\Twig\AppExtension->getSingers (line 135)
7	__TwigTemplate_facb248868d1b1b619d6eb6cfeba1caa->doDisplay (line 218)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_be2d577de38a3aa06cb7369a0efbaf1b->block_body (line 247)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4d76e9cd93a6cd1dc9fb00472e10c149->doDisplay (line 138)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_be2d577de38a3aa06cb7369a0efbaf1b->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\DefaultController->languageListAction (line 294)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Language	1

Entities Mapping

Class	Mapping errors
App\Entity\Language	No errors.
App\Entity\Video	No errors.
App\Entity\Category	No errors.
App\Entity\Festival	No errors.
App\Entity\Singer	No errors.

Symfony Profiler

GET https://www.vidstatus.co.in/language/gujarati-status/?page=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping