Symfony Profiler

Query Metrics

12 Database Queries

12 Different statements

193.96 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

148.80 ms
(76.71%)

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 (462573, 463662, 465051, 465194, 465527, 467760, 469207, 469210, 469211, 469213, 469542, 472949, 472952, 472954, 473062, 473300, 473539, 473746, 473771, 474767, 476154, 477399, 486614, 487609, 490139, 491195, 491354, 493852, 496887, 497382, 497425, 497444, 497448, 497454, 497467, 500570, 500594, 500600, 500686, 500691, 501564, 501597, 509979, 511249, 511260, 511268, 511270, 513140, 513193, 513786, 513798, 513802, 516291, 518398, 518929, 519171, 521122, 521177, 522188, 522263, 525099, 525106, 527756, 532264, 533313, 534985, 536970, 538028, 538223, 538547, 539858, 539860, 539943, 539947, 540175, 542944, 545539, 545608, 546274, 546864, 546865, 547089, 547530, 549091, 551089, 554079, 554337, 554340, 554343, 555532, 555547, 555549, 556371, 557265, 557266, 557361, 557579, 558410, 559159, 559160, 559161, 559162, 559164, 559926, 560136, 560198, 560213, 562808, 564066, 565211, 565215, 565943, 565945, 565946, 568613, 568614, 568617, 568618, 568621, 568625);

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

11.89 ms
(6.13%)

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, 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.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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.search_field,
  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.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, 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.post_id IN (568625, 568621, 568618, 568617, 568614, 568613, 565946, 565945, 565943, 565215, 565211, 564066, 562808, 560213, 560198, 560136, 559926, 559164, 559162, 559161, 559160, 559159, 558410, 557579, 557361, 557266, 557265, 556371, 555549, 555547, 555532, 554343, 554340, 554337, 554079, 551089, 549091, 547530, 547089, 546865, 546864, 546274, 545608, 545539, 542944, 540175, 539947, 539943, 539860, 539858, 538547, 538223, 538028, 536970, 534985, 533313, 532264, 527756, 525106, 525099, 522263, 522188, 521177, 521122, 519171, 518929, 518398, 516291, 513802, 513798, 513786, 513193, 513140, 511270, 511268, 511260, 511249, 509979, 501597, 501564, 500691, 500686, 500600, 500594, 500570, 497467, 497454, 497448, 497444, 497425, 497382, 496887, 493852, 491354, 491195, 490139, 487609, 486614, 477399, 476154, 474767, 473771, 473746, 473539, 473300, 473062, 472954, 472952, 472949, 469542, 469213, 469211, 469210, 469207, 467760, 465527, 465194, 465051, 463662, 462573);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 256)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllAssociative (line 36)
4	App\PostPublic\ReadModel\Embed\OverviewFetcher->fetchByIds (line 545)
5	App\PostPublic\ReadModel\Embed\ElasticSearch->getFromDatabase (line 365)
6	App\PostPublic\ReadModel\Embed\ElasticSearch->fetch (line 41)
7	App\PostPublic\Controller\Embed\Search\ActionController->__invoke (line 50)
8	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

9.43 ms
(4.86%)

SELECT COUNT(*) as `total_posts`
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = ? AND p.post_id = t0.post_id)
            WHERE p.type = ? AND `p`.`status` = ?

Parameters:

[
  b"""
    \x01’·ÿr\n
    s+¥¿X\x10ÉÏØÎ
    """
  0
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) as `total_posts`
FROM
  `trend_has_post` as `t0`
  INNER JOIN `post` as `p` ON (
    trend_id = ?
    AND p.post_id = t0.post_id
  )
WHERE
  p.type = ?
  AND `p`.`status` = ?

SELECT COUNT(*) as `total_posts`
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = 0x0192B7FF720A732BA5BF5810C9CFD8CE AND p.post_id = t0.post_id)
            WHERE p.type = 0 AND `p`.`status` = 10
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 187)
2	App\PostPublic\ReadModel\DataProvider\SearchRotatorProvider->countTotalPosts (line 44)
3	App\PostPublic\ReadModel\DataProvider\SearchRotatorProvider->getRecords (line 543)
4	App\PostPublic\ReadModel\Embed\ElasticSearch->getFromDatabase (line 365)
5	App\PostPublic\ReadModel\Embed\ElasticSearch->fetch (line 41)
6	App\PostPublic\Controller\Embed\Search\ActionController->__invoke (line 50)
7	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

5.87 ms
(3.03%)

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

Parameters:

[
  "thailand"
  "thailand"
  "thailand"
  20
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('thailand') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('thailand')
              AND `query` <> 'thailand'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 39)
2	App\SearchLog\ReadModel\RelatedQueryFetcher->get (line 22)
3	App\SearchLog\Controller\Fragments\RelatedQueryController->__invoke (line 50)
4	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 261)
16	__TwigTemplate_e20f60411874851359e25b6cd3733731->block_content (line 432)
17	Twig\Template->yieldBlock (line 124)
18	__TwigTemplate_c78b784e833d63a6d363a6ff26ead376->block_body (line 432)
19	Twig\Template->yieldBlock (line 120)
20	__TwigTemplate_622f2eb1a598b70df86ae3ef35b37753->doDisplay (line 388)
21	Twig\Template->yield (line 56)
22	__TwigTemplate_c78b784e833d63a6d363a6ff26ead376->doDisplay (line 388)
23	Twig\Template->yield (line 66)
24	__TwigTemplate_e20f60411874851359e25b6cd3733731->doDisplay (line 388)
25	Twig\Template->yield (line 344)
26	Twig\Template->display (line 359)
27	Twig\Template->render (line 51)
28	Twig\TemplateWrapper->render (line 334)
29	Twig\Environment->render (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
33	App\PostPublic\Controller\Embed\Search\ActionController->__invoke (line 50)
34	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
35	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
36	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
37	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
38	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

3.97 ms
(2.05%)

SELECT t0.post_id FROM trend_has_post t0 INNER JOIN post p ON trend_id = ? AND p.post_id = t0.post_id WHERE (p.type = ? AND p.status = ?) AND (t0.is_tested = 0) ORDER BY t0.ctr DESC LIMIT 120 OFFSET 240

Parameters:

[
  b"""
    \x01’·ÿr\n
    s+¥¿X\x10ÉÏØÎ
    """
  0
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.post_id
FROM
  trend_has_post t0
  INNER JOIN post p ON trend_id = ?
  AND p.post_id = t0.post_id
WHERE
  (
    p.type = ?
    AND p.status = ?
  )
  AND (t0.is_tested = 0)
ORDER BY
  t0.ctr DESC
LIMIT
  120
OFFSET
  240

SELECT t0.post_id FROM trend_has_post t0 INNER JOIN post p ON trend_id = 0x0192B7FF720A732BA5BF5810C9CFD8CE AND p.post_id = t0.post_id WHERE (p.type = 0 AND p.status = 10) AND (t0.is_tested = 0) ORDER BY t0.ctr DESC LIMIT 120 OFFSET 240;

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

2.50 ms
(1.29%)

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

Parameters:

[
  b"""
    \x01’·ÿr\n
    s+¥¿X\x10ÉÏØÎ
    """
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0192B7FF720A732BA5BF5810C9CFD8CE LIMIT 1;

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

2.49 ms
(1.28%)

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 (462573, 463662, 465051, 465194, 465527, 467760, 469207, 469210, 469211, 469213, 469542, 472949, 472952, 472954, 473062, 473300, 473539, 473746, 473771, 474767, 476154, 477399, 486614, 487609, 490139, 491195, 491354, 493852, 496887, 497382, 497425, 497444, 497448, 497454, 497467, 500570, 500594, 500600, 500686, 500691, 501564, 501597, 509979, 511249, 511260, 511268, 511270, 513140, 513193, 513786, 513798, 513802, 516291, 518398, 518929, 519171, 521122, 521177, 522188, 522263, 525099, 525106, 527756, 532264, 533313, 534985, 536970, 538028, 538223, 538547, 539858, 539860, 539943, 539947, 540175, 542944, 545539, 545608, 546274, 546864, 546865, 547089, 547530, 549091, 551089, 554079, 554337, 554340, 554343, 555532, 555547, 555549, 556371, 557265, 557266, 557361, 557579, 558410, 559159, 559160, 559161, 559162, 559164, 559926, 560136, 560198, 560213, 562808, 564066, 565211, 565215, 565943, 565945, 565946, 568613, 568614, 568617, 568618, 568621, 568625);

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

2.05 ms
(1.06%)

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

Parameters:

[
  "thailand"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'thailand' LIMIT 1;

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

1.83 ms
(0.94%)

SELECT COUNT(*)
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = ? AND p.post_id = t0.post_id)
            WHERE p.type = ? AND `p`.`status` = ? AND `t0`.`is_tested` = 1

Parameters:

[
  b"""
    \x01’·ÿr\n
    s+¥¿X\x10ÉÏØÎ
    """
  0
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  `trend_has_post` as `t0`
  INNER JOIN `post` as `p` ON (
    trend_id = ?
    AND p.post_id = t0.post_id
  )
WHERE
  p.type = ?
  AND `p`.`status` = ?
  AND `t0`.`is_tested` = 1

SELECT COUNT(*)
            FROM `trend_has_post` as `t0`
            INNER JOIN `post` as `p` ON (trend_id = 0x0192B7FF720A732BA5BF5810C9CFD8CE AND p.post_id = t0.post_id)
            WHERE p.type = 0 AND `p`.`status` = 10 AND `t0`.`is_tested` = 1
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 245)
2	App\PostPublic\ReadModel\DataProvider\SearchRotatorProvider->countTestedPosts (line 61)
3	App\PostPublic\ReadModel\DataProvider\SearchRotatorProvider->getRecords (line 543)
4	App\PostPublic\ReadModel\Embed\ElasticSearch->getFromDatabase (line 365)
5	App\PostPublic\ReadModel\Embed\ElasticSearch->fetch (line 41)
6	App\PostPublic\Controller\Embed\Search\ActionController->__invoke (line 50)
7	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.79 ms
(0.92%)

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)

1.76 ms
(0.91%)

SELECT `query_id` FROM `search_log` WHERE `query` = ?

Parameters:

[
  "тайк азиатк"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'тайк азиатк';

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

1.58 ms
(0.82%)

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

Parameters:

[
  "тайк азиатк"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'тайк азиатк';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 103)
2	App\PostPublic\Controller\Embed\Search\ActionController->getRotatedTrendId (line 44)
3	App\PostPublic\Controller\Embed\Search\ActionController->__invoke (line 50)
4	App\Infrastructure\EventSubscriber\ResponseCacheSubscriber->cache (line 115)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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/_fragment?_path=_format%3Dhtml%26_locale%3Dru%26_controller%3DApp%255CSearchLog%255CController%255CFragments%255CRelatedQueryController

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping