Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

21.40 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

17.16 ms
(80.15%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 476)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Controller\DefaultController->videoDetailAction (line 48)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

1.77 ms
(8.26%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.status AS status_5, t0.mime_type AS mime_type_6, t0.file_name AS file_name_7, t0.picture AS picture_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.duration AS duration_11, t0.file_size AS file_size_12, t0.total_view AS total_view_13, t0.total_like AS total_like_14, t0.total_dislike AS total_dislike_15, t0.total_download AS total_download_16, t0.lang_slug AS lang_slug_17, t0.file_path AS file_path_18, t0.user AS user_19, t0.language AS language_20, t0.festival AS festival_21, t0.singer AS singer_22, t0.category AS category_23, t0.subCategory AS subCategory_24 FROM video t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "kirtidan-gadhvi-kirtidan-gadhvi-pushpraj-new-funny-video-song"
]

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.slug AS slug_4,
  t0.status AS status_5,
  t0.mime_type AS mime_type_6,
  t0.file_name AS file_name_7,
  t0.picture AS picture_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.duration AS duration_11,
  t0.file_size AS file_size_12,
  t0.total_view AS total_view_13,
  t0.total_like AS total_like_14,
  t0.total_dislike AS total_dislike_15,
  t0.total_download AS total_download_16,
  t0.lang_slug AS lang_slug_17,
  t0.file_path AS file_path_18,
  t0.user AS user_19,
  t0.language AS language_20,
  t0.festival AS festival_21,
  t0.singer AS singer_22,
  t0.category AS category_23,
  t0.subCategory AS subCategory_24
FROM
  video t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.status AS status_5, t0.mime_type AS mime_type_6, t0.file_name AS file_name_7, t0.picture AS picture_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.duration AS duration_11, t0.file_size AS file_size_12, t0.total_view AS total_view_13, t0.total_like AS total_like_14, t0.total_dislike AS total_dislike_15, t0.total_download AS total_download_16, t0.lang_slug AS lang_slug_17, t0.file_path AS file_path_18, t0.user AS user_19, t0.language AS language_20, t0.festival AS festival_21, t0.singer AS singer_22, t0.category AS category_23, t0.subCategory AS subCategory_24 FROM video t0 WHERE t0.slug = 'kirtidan-gadhvi-kirtidan-gadhvi-pushpraj-new-funny-video-song' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 776)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\DefaultController->videoDetailAction (line 44)
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.02 ms
(4.77%)

UPDATE video SET total_view = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  video
SET
  total_view = ?
WHERE
  id = ?

UPDATE video SET total_view = 56 WHERE id = 1095;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 419)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1277)
4	Doctrine\ORM\UnitOfWork->commit (line 452)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Controller\DefaultController->videoDetailAction (line 48)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.85 ms
(3.97%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 426)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Controller\DefaultController->videoDetailAction (line 48)
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)

0.61 ms
(2.85%)

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

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.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 794)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 365)
4	Proxies\__CG__\App\Entity\Language::Doctrine\ORM\Proxy\{closure} (line 472)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Language->__get (line 153)
7	App\Entity\Language->getDisplayName (line 144)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_0a681d6e3dbfb497d3247ef0c5da899d::block_title (line 80)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_4d76e9cd93a6cd1dc9fb00472e10c149->doDisplay (line 59)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_0a681d6e3dbfb497d3247ef0c5da899d->doDisplay (line 55)
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->videoDetailAction (line 49)
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\Video	1
App\Entity\User	1
App\Entity\Language	1
App\Entity\Singer	1

Entities Mapping

Class	Mapping errors
App\Entity\Video	No errors.
App\Entity\User	No errors.
App\Entity\Language	No errors.
App\Entity\Festival	No errors.
App\Entity\Singer	No errors.
App\Entity\Category	No errors.
App\Entity\Tags	No errors.
App\Entity\Likes	No errors.
App\Entity\Tokens	No errors.
App\Entity\BlogTags	No errors.
App\Entity\QuoteLanguage	No errors.
App\Entity\Quotes	No errors.
App\Entity\QuoteCategory	No errors.
App\Entity\HighLights	No errors.
App\Entity\Days	No errors.
App\Entity\Sample	No errors.
App\Entity\Blog	No errors.
App\Entity\QuoteFestival	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\Mail	No errors.
App\Entity\Comments	No errors.
App\Entity\QuoteTags	No errors.
App\Entity\Banner	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.vidstatus.co.in/video/kirtidan-gadhvi-kirtidan-gadhvi-pushpraj-new-funny-video-song/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping