Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

4.70 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.11 ms
(66.16%)

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 4

Parameters:

[
  "kind" => 9
]

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
  4

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 = 9
                    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 4;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 583)
3	App\Repository\PostRepository->findNews (line 61)
4	App\Api\Controller\KbPostController->kbNewsAction (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.67 ms
(14.20%)

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" => 9
]

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 = 9
                    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 706)
3	App\Repository\PostRepository->findNewsCountByYear (line 77)
4	App\Api\Controller\KbPostController->kbNewsAction (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.50 ms
(10.63%)

"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 586)
3	App\Repository\PostRepository->findNews (line 61)
4	App\Api\Controller\KbPostController->kbNewsAction (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.42 ms
(9.00%)

"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 582)
2	App\Repository\PostRepository->findNews (line 61)
3	App\Api\Controller\KbPostController->kbNewsAction (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/news?limit=4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping