Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

1073.19 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

825.21 ms
(76.89%)

SELECT COUNT(*) FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.type = ? AND p.status = ? AND p.sexual_orientation = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  post p
  LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`
  AND `f`.`lang_id` = ?
  LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`
  AND `r`.`lang_id` = ?
WHERE
  p.type = ?
  AND p.status = ?
  AND p.sexual_orientation = ?

SELECT COUNT(*) FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.type = 0 AND p.status = 10 AND p.sexual_orientation = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 51)
3	App\Infrastructure\Pagination\Paginator->getTotal (line 102)
4	App\PostPublic\ReadModel\Embed\AllEmbedsFetch->fetch (line 28)
5	App\PostPublic\Controller\Embed\Overview\ActionController->__invoke (line 50)
6	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

228.20 ms
(21.26%)

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  phc.post_id,
  phc.category_id,
  c.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_category phc
  INNER JOIN category c ON phc.category_id = c.category_id
  AND c.enabled = 1
  LEFT JOIN category_translation f ON c.category_id = f.category_id
  AND f.lang_id = ?
  LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`
  AND `r`.`lang_id` = ?
WHERE
  phc.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (432762, 412989, 780704, 729835, 550334, 478254, 118359, 512094, 455319, 415594, 385386, 757078, 711899, 613167, 399318, 763914, 518919, 513837, 448356, 777244, 763399, 758785, 758676, 756568, 716591, 662653, 628058, 606711, 603193, 589592, 581203, 573308, 562000, 557978, 536084, 529419, 436047, 417075, 413708, 409241, 405472, 390857, 786637, 775880, 692453, 661496, 660068, 607993, 565167, 554506, 519268, 467081, 459802, 448646, 385582, 603277, 651603, 552346, 756956, 727431, 726744, 667246, 650539, 512136, 481343, 450656, 420431, 382724, 766481, 697169, 552023, 548565, 759377, 724329, 663391, 631166, 618272, 516979, 512556, 511418, 506283, 415635, 383211, 768851, 740790, 710222, 687532, 554780, 506348, 461923, 384291, 384133, 702456, 484111, 758395, 701275, 680588, 679863, 651646, 521439, 415488, 682351, 746222, 747295, 768709, 743322, 720534, 696065, 570970, 555263, 524423, 500043, 495892, 475069, 188266, 384258, 688071, 751021, 608497, 566786);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 53)
3	App\PostPublic\ReadModel\Embed\AllEmbedsFetch->fetchCategories (line 59)
4	App\PostPublic\ReadModel\Embed\AllEmbedsFetch->fetch (line 28)
5	App\PostPublic\Controller\Embed\Overview\ActionController->__invoke (line 50)
6	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

14.21 ms
(1.32%)

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.type = ? AND p.status = ? AND p.sexual_orientation = ? ORDER BY max_ctr DESC LIMIT 120 OFFSET 600

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.post_id,
  p.user_id,
  p.content_id,
  p.public_key,
  p.cover,
  p.type,
  p.sexual_orientation,
  p.orientation,
  p.quality,
  p.noindex,
  p.nofollow,
  p.contents_num,
  p.duration,
  p.likes,
  p.dislikes,
  p.views,
  p.vote_rating,
  p.params,
  p.published_at,
  IFNULL(`r`.`title`, `f`.`title`) as `title`,
  IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`,
  IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2`
FROM
  post p
  LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`
  AND `f`.`lang_id` = ?
  LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`
  AND `r`.`lang_id` = ?
WHERE
  p.type = ?
  AND p.status = ?
  AND p.sexual_orientation = ?
ORDER BY
  max_ctr DESC
LIMIT
  120
OFFSET
  600

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id` AND `f`.`lang_id`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.type = 0 AND p.status = 10 AND p.sexual_orientation = 0 ORDER BY max_ctr DESC LIMIT 120 OFFSET 600;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 34)
3	App\Infrastructure\Pagination\Paginator->getPage (line 54)
4	App\PostPublic\ReadModel\Embed\AllEmbedsFetch->fetch (line 28)
5	App\PostPublic\Controller\Embed\Overview\ActionController->__invoke (line 50)
6	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

3.70 ms
(0.34%)

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  pht.post_id,
  pht.tag_id,
  t.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_tag pht
  INNER JOIN tag t ON pht.tag_id = t.tag_id
  AND t.enabled = 1
  LEFT JOIN tag_translation f ON t.tag_id = f.tag_id
  AND f.lang_id = ?
  LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id`
  AND `r`.`lang_id` = ?
WHERE
  pht.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (432762, 412989, 780704, 729835, 550334, 478254, 118359, 512094, 455319, 415594, 385386, 757078, 711899, 613167, 399318, 763914, 518919, 513837, 448356, 777244, 763399, 758785, 758676, 756568, 716591, 662653, 628058, 606711, 603193, 589592, 581203, 573308, 562000, 557978, 536084, 529419, 436047, 417075, 413708, 409241, 405472, 390857, 786637, 775880, 692453, 661496, 660068, 607993, 565167, 554506, 519268, 467081, 459802, 448646, 385582, 603277, 651603, 552346, 756956, 727431, 726744, 667246, 650539, 512136, 481343, 450656, 420431, 382724, 766481, 697169, 552023, 548565, 759377, 724329, 663391, 631166, 618272, 516979, 512556, 511418, 506283, 415635, 383211, 768851, 740790, 710222, 687532, 554780, 506348, 461923, 384291, 384133, 702456, 484111, 758395, 701275, 680588, 679863, 651646, 521439, 415488, 682351, 746222, 747295, 768709, 743322, 720534, 696065, 570970, 555263, 524423, 500043, 495892, 475069, 188266, 384258, 688071, 751021, 608497, 566786);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 56)
3	App\PostPublic\ReadModel\Embed\AllEmbedsFetch->fetchTags (line 58)
4	App\PostPublic\ReadModel\Embed\AllEmbedsFetch->fetch (line 28)
5	App\PostPublic\Controller\Embed\Overview\ActionController->__invoke (line 50)
6	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.88 ms
(0.17%)

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	Doctrine\DBAL\Connection->executeQuery (line 34)
2	App\Language\Model\LanguageResolver->init (line 25)
3	App\Language\Model\LanguageResolver->__construct (line 1198)
4	ContainerZpBicIx\App_KernelDevDebugContainer::getLanguageResolverService (line 1188)
5	ContainerZpBicIx\App_KernelDevDebugContainer::getCookieLangSwitcherService (line 896)
6	ContainerZpBicIx\App_KernelDevDebugContainer::ContainerZpBicIx\{closure} (line 221)
7	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
8	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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

No loaded entities.

Symfony Profiler

GET https://search.jues.net/videos/popular/6

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping