Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 44
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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

[
  "kind" => 9
]

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;

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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

[
  "kind" => 9
]

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;

"COMMIT"

[]

"COMMIT"

"COMMIT";