Symfony Profiler

Query Metrics

9 Database Queries

5 Different statements

51.53 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

45.35 ms
(88.01%)

SELECT 
                    article.id, 
                    article.slug,
                    article.category_id, 
                    article.category_name,
                    pc.title,
                    CASE 
                        WHEN pc.body IS NULL THEN false
                        WHEN pc.body = '' THEN false
                        ELSE true END as bodyFlg,
                    CONCAT('https://knowledgebeans-api.sooma.jp/uploads/post/',pci.file_name) as image_url,
                    UNIX_TIMESTAMP(article.publish_at) as public_datetime
                FROM (
                    SELECT p.*, p2c.category_id, cn.name as category_name
                    FROM post as p 
                    LEFT JOIN post_to_category as p2c on p2c.post_id = p.id 
                    LEFT JOIN category as c on p2c.category_id = c.id 
                    LEFT JOIN category_name as cn on p2c.category_id = cn.category_id 
                    WHERE p.status = 2 
                    AND kind = :kind
                    AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(now(), '%Y-%m-%d')
                    AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(now(), '%Y-%m-%d') GROUP BY p.id) as article 
                LEFT JOIN post_content as pc on pc.post_id = article.id AND pc.locale_id = 1
                LEFT JOIN post_content_images as pci on pci.content_id = pc.id AND pci.type_id = 1  ORDER BY article.publish_at DESC, article.id DESC LIMIT 12

Parameters:

[
  "kind" => 10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  article.id,
  article.slug,
  article.category_id,
  article.category_name,
  pc.title,
  CASE WHEN pc.body IS NULL THEN
    false
  WHEN pc.body = '' THEN
    false
  ELSE
    true
  END as bodyFlg,
  CONCAT(
    'https://knowledgebeans-api.sooma.jp/uploads/post/',
    pci.file_name
  ) as image_url,
  UNIX_TIMESTAMP(article.publish_at) as public_datetime
FROM
  (
    SELECT
      p.*,
      p2c.category_id,
      cn.name as category_name
    FROM
      post as p
      LEFT JOIN post_to_category as p2c on p2c.post_id = p.id
      LEFT JOIN category as c on p2c.category_id = c.id
      LEFT JOIN category_name as cn on p2c.category_id = cn.category_id
    WHERE
      p.status = 2
      AND kind = :kind
      AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(
        now(),
        '%Y-%m-%d'
      )
      AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(
        now(),
        '%Y-%m-%d'
      )
    GROUP BY
      p.id
  ) as article
  LEFT JOIN post_content as pc on pc.post_id = article.id
  AND pc.locale_id = 1
  LEFT JOIN post_content_images as pci on pci.content_id = pc.id
  AND pci.type_id = 1
ORDER BY
  article.publish_at DESC,
  article.id DESC
LIMIT
  12

SELECT 
                    article.id, 
                    article.slug,
                    article.category_id, 
                    article.category_name,
                    pc.title,
                    CASE 
                        WHEN pc.body IS NULL THEN false
                        WHEN pc.body = '' THEN false
                        ELSE true END as bodyFlg,
                    CONCAT('https://knowledgebeans-api.sooma.jp/uploads/post/',pci.file_name) as image_url,
                    UNIX_TIMESTAMP(article.publish_at) as public_datetime
                FROM (
                    SELECT p.*, p2c.category_id, cn.name as category_name
                    FROM post as p 
                    LEFT JOIN post_to_category as p2c on p2c.post_id = p.id 
                    LEFT JOIN category as c on p2c.category_id = c.id 
                    LEFT JOIN category_name as cn on p2c.category_id = cn.category_id 
                    WHERE p.status = 2 
                    AND kind = 10
                    AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(now(), '%Y-%m-%d')
                    AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(now(), '%Y-%m-%d') GROUP BY p.id) as article 
                LEFT JOIN post_content as pc on pc.post_id = article.id AND pc.locale_id = 1
                LEFT JOIN post_content_images as pci on pci.content_id = pc.id AND pci.type_id = 1  ORDER BY article.publish_at DESC, article.id DESC LIMIT 12;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 586)
3	App\Repository\PostRepository->findNews (line 185)
4	App\Api\Controller\KbPostController->kbBlogAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

3.96 ms
(7.69%)

SELECT 
                        count(*) as count,
                        category_id
                    FROM (
                        SELECT 
                            p.*, 
                            p2c.category_id
                        FROM post as p 
                        LEFT JOIN post_to_category as p2c on p2c.post_id = p.id 
                        LEFT JOIN category as c on p2c.category_id = c.id 
                        WHERE p.status = 2 
                        AND kind = :kind
                        AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(now(), '%Y-%m-%d')
                        AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(now(), '%Y-%m-%d')
                        AND c.lft > (select lft from category where slug = :parent_cat_slug)
                        AND c.rgt < (select rgt from category where slug = :parent_cat_slug)
                         ) as article GROUP BY category_id

Parameters:

[
  "kind" => 10
  "parent_cat_slug" => "kb_blog"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) as count,
  category_id
FROM
  (
    SELECT
      p.*,
      p2c.category_id
    FROM
      post as p
      LEFT JOIN post_to_category as p2c on p2c.post_id = p.id
      LEFT JOIN category as c on p2c.category_id = c.id
    WHERE
      p.status = 2
      AND kind = :kind
      AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(
        now(),
        '%Y-%m-%d'
      )
      AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(
        now(),
        '%Y-%m-%d'
      )
      AND c.lft > (
        select
          lft
        from
          category
        where
          slug = :parent_cat_slug
      )
      AND c.rgt < (
        select
          rgt
        from
          category
        where
          slug = :parent_cat_slug
      )
  ) as article
GROUP BY
  category_id

SELECT 
                        count(*) as count,
                        category_id
                    FROM (
                        SELECT 
                            p.*, 
                            p2c.category_id
                        FROM post as p 
                        LEFT JOIN post_to_category as p2c on p2c.post_id = p.id 
                        LEFT JOIN category as c on p2c.category_id = c.id 
                        WHERE p.status = 2 
                        AND kind = 10
                        AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(now(), '%Y-%m-%d')
                        AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(now(), '%Y-%m-%d')
                        AND c.lft > (select lft from category where slug = 'kb_blog')
                        AND c.rgt < (select rgt from category where slug = 'kb_blog')
                         ) as article GROUP BY category_id;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 767)
3	App\Repository\PostRepository->findNewsCountByYear (line 201)
4	App\Api\Controller\KbPostController->kbBlogAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.79 ms
(1.53%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 589)
3	App\Repository\PostRepository->findNews (line 185)
4	App\Api\Controller\KbPostController->kbBlogAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.74 ms
(1.44%)

SELECT 
                    count(*) as count,
                    publish_year
                FROM (
                    SELECT 
                        p.*, 
                        p2c.category_id,
                        DATE_FORMAT(publish_at, '%Y') as publish_year
                    FROM post as p 
                    LEFT JOIN post_to_category as p2c on p2c.post_id = p.id 
                    LEFT JOIN category as c on p2c.category_id = c.id 
                    WHERE p.status = 2 
                    AND kind = :kind
                    AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(now(), '%Y-%m-%d')
                    AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(now(), '%Y-%m-%d')) as article GROUP BY article.publish_year

Parameters:

[
  "kind" => 10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) as count,
  publish_year
FROM
  (
    SELECT
      p.*,
      p2c.category_id,
      DATE_FORMAT(publish_at, '%Y') as publish_year
    FROM
      post as p
      LEFT JOIN post_to_category as p2c on p2c.post_id = p.id
      LEFT JOIN category as c on p2c.category_id = c.id
    WHERE
      p.status = 2
      AND kind = :kind
      AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(
        now(),
        '%Y-%m-%d'
      )
      AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(
        now(),
        '%Y-%m-%d'
      )
  ) as article
GROUP BY
  article.publish_year

SELECT 
                    count(*) as count,
                    publish_year
                FROM (
                    SELECT 
                        p.*, 
                        p2c.category_id,
                        DATE_FORMAT(publish_at, '%Y') as publish_year
                    FROM post as p 
                    LEFT JOIN post_to_category as p2c on p2c.post_id = p.id 
                    LEFT JOIN category as c on p2c.category_id = c.id 
                    WHERE p.status = 2 
                    AND kind = 10
                    AND DATE_FORMAT(publish_at, '%Y-%m-%d') <= DATE_FORMAT(now(), '%Y-%m-%d')
                    AND DATE_FORMAT(expire_at, '%Y-%m-%d') >= DATE_FORMAT(now(), '%Y-%m-%d')) as article GROUP BY article.publish_year;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 709)
3	App\Repository\PostRepository->findNewsCountByYear (line 201)
4	App\Api\Controller\KbPostController->kbBlogAction (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.68 ms
(1.33%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 585)
2	App\Repository\PostRepository->findNews (line 185)
3	App\Api\Controller\KbPostController->kbBlogAction (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	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

Class	Mapping errors
App\Entity\Post	No errors.

Symfony Profiler

GET http://knowledgebeans-api.sooma.jp/v1/kb/blog?limit=12&offset=0&slug=&year=

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping