Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

38.82 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

29.33 ms
(75.55%)

SELECT COUNT(*) FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=? LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=? WHERE mc.status = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  movie_clip mc
  LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id
  AND f.lang_id = ?
  LEFT JOIN film f1 ON mc.film_id = f1.film_id
  LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id
  AND r.lang_id = ?
WHERE
  mc.status = ?

SELECT COUNT(*) FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=1 LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=2 WHERE mc.status = 10;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 323)
2	App\Infrastructure\Pagination\Paginator->getTotal (line 51)
3	App\MovieClip\Presentation\Fetcher\ClipListFetcher->fetch (line 79)
4	App\MovieClip\Presentation\Controller\Public\AllClips\ActionController->__invoke (line 46)
5	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 52)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

9.17 ms
(23.63%)

SELECT mc.clip_id, mc.film_id, mc.public_key, mc.thumb_path, mc.preview_path, mc.duration, mc.quality, mc.is_vertical, mc.likes, mc.dislikes, mc.views, mc.status, mc.published_at, f1.title as film_title, f1.original_title as film_original_title, f1.poster_path as film_poster_path, f1.release_year as film_release_year, IFNULL(r.title, f.title) as title FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=? LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=? WHERE mc.status = ? ORDER BY views DESC LIMIT 24 OFFSET 24

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  mc.clip_id,
  mc.film_id,
  mc.public_key,
  mc.thumb_path,
  mc.preview_path,
  mc.duration,
  mc.quality,
  mc.is_vertical,
  mc.likes,
  mc.dislikes,
  mc.views,
  mc.status,
  mc.published_at,
  f1.title as film_title,
  f1.original_title as film_original_title,
  f1.poster_path as film_poster_path,
  f1.release_year as film_release_year,
  IFNULL(r.title, f.title) as title
FROM
  movie_clip mc
  LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id
  AND f.lang_id = ?
  LEFT JOIN film f1 ON mc.film_id = f1.film_id
  LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id
  AND r.lang_id = ?
WHERE
  mc.status = ?
ORDER BY
  views DESC
LIMIT
  24
OFFSET
  24

SELECT mc.clip_id, mc.film_id, mc.public_key, mc.thumb_path, mc.preview_path, mc.duration, mc.quality, mc.is_vertical, mc.likes, mc.dislikes, mc.views, mc.status, mc.published_at, f1.title as film_title, f1.original_title as film_original_title, f1.poster_path as film_poster_path, f1.release_year as film_release_year, IFNULL(r.title, f.title) as title FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=1 LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=2 WHERE mc.status = 10 ORDER BY views DESC LIMIT 24 OFFSET 24;

#	File/Call
1	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 323)
2	App\Infrastructure\Pagination\Paginator->getPage (line 34)
3	App\MovieClip\Presentation\Fetcher\ClipListFetcher->fetch (line 47)
4	App\MovieClip\Presentation\Controller\Public\AllClips\ActionController->__invoke (line 46)
5	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 52)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.32 ms
(0.81%)

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

#	File/Call
1	App\Language\Model\LanguageResolver->init (line 34)
2	App\Language\Model\LanguageResolver->__construct (line 25)
3	ContainerNbSs4vH\App_KernelDevDebugContainer->getLanguageResolverService (line 1116)
4	ContainerNbSs4vH\getClipListFetcherService::do (line 23)
5	ContainerNbSs4vH\App_KernelDevDebugContainer::load (line 568)
6	ContainerNbSs4vH\getActionController13Service->do (line 24)
7	ContainerNbSs4vH\App_KernelDevDebugContainer::load (line 568)
8	Symfony\Component\DependencyInjection\Container->make (line 221)
9	Symfony\Component\DependencyInjection\Container::get (line 203)
10	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
11	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
12	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 115)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
14	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	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

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://dev.muviki.cc/popular/2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping