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

SELECT *
                FROM post as p
                WHERE p.status = 2 
                  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 p.slug = :slug AND p.kind = :kind ORDER BY p.id DESC

[
  "slug" => "サイトをリニューアルしました"
  "kind" => 9
]

SELECT
  *
FROM
  post as p
WHERE
  p.status = 2
  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 p.slug = :slug
  AND p.kind = :kind
ORDER BY
  p.id DESC

SELECT *
                FROM post as p
                WHERE p.status = 2 
                  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 p.slug = 'サイトをリニューアルしました' AND p.kind = 9 ORDER BY p.id DESC;

SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.last_updated_by AS last_updated_by_3, t0.slug AS slug_4, t0.status AS status_5, t0.note AS note_6, t0.kind AS kind_7, t0.publish_at AS publish_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.expire_at AS expire_at_11, t12.id AS id_13, t12.attr1 AS attr1_14, t12.attr2 AS attr2_15, t12.attr3 AS attr3_16, t12.attr4 AS attr4_17, t12.attr5 AS attr5_18, t12.attr6 AS attr6_19, t12.attr7 AS attr7_20, t12.attr8 AS attr8_21, t12.attr9 AS attr9_22, t12.attr10 AS attr10_23, t12.post_id AS post_id_24 FROM post t0 LEFT JOIN post_detail t12 ON t12.post_id = t0.id WHERE t0.id = ?

[
  10
]

SELECT
  t0.id AS id_1,
  t0.created_by AS created_by_2,
  t0.last_updated_by AS last_updated_by_3,
  t0.slug AS slug_4,
  t0.status AS status_5,
  t0.note AS note_6,
  t0.kind AS kind_7,
  t0.publish_at AS publish_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.expire_at AS expire_at_11,
  t12.id AS id_13,
  t12.attr1 AS attr1_14,
  t12.attr2 AS attr2_15,
  t12.attr3 AS attr3_16,
  t12.attr4 AS attr4_17,
  t12.attr5 AS attr5_18,
  t12.attr6 AS attr6_19,
  t12.attr7 AS attr7_20,
  t12.attr8 AS attr8_21,
  t12.attr9 AS attr9_22,
  t12.attr10 AS attr10_23,
  t12.post_id AS post_id_24
FROM
  post t0
  LEFT JOIN post_detail t12 ON t12.post_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_by AS created_by_2, t0.last_updated_by AS last_updated_by_3, t0.slug AS slug_4, t0.status AS status_5, t0.note AS note_6, t0.kind AS kind_7, t0.publish_at AS publish_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.expire_at AS expire_at_11, t12.id AS id_13, t12.attr1 AS attr1_14, t12.attr2 AS attr2_15, t12.attr3 AS attr3_16, t12.attr4 AS attr4_17, t12.attr5 AS attr5_18, t12.attr6 AS attr6_19, t12.attr7 AS attr7_20, t12.attr8 AS attr8_21, t12.attr9 AS attr9_22, t12.attr10 AS attr10_23, t12.post_id AS post_id_24 FROM post t0 LEFT JOIN post_detail t12 ON t12.post_id = t0.id WHERE t0.id = 10;

SELECT CONCAT('https://knowledgebeans-api.sooma.jp/uploads/post/',pci.file_name) as image_url
              FROM post_content_images as pci
              LEFT JOIN m_image_type as mit ON pci.type_id = mit.id
              WHERE pci.content_id = :content_id AND mit.type_name = :imageType 
              ORDER BY pci.position, pci.id

[
  "content_id" => 8
  "imageType" => "main-image"
]

SELECT
  CONCAT(
    'https://knowledgebeans-api.sooma.jp/uploads/post/',
    pci.file_name
  ) as image_url
FROM
  post_content_images as pci
  LEFT JOIN m_image_type as mit ON pci.type_id = mit.id
WHERE
  pci.content_id = :content_id
  AND mit.type_name = :imageType
ORDER BY
  pci.position,
  pci.id

SELECT CONCAT('https://knowledgebeans-api.sooma.jp/uploads/post/',pci.file_name) as image_url
              FROM post_content_images as pci
              LEFT JOIN m_image_type as mit ON pci.type_id = mit.id
              WHERE pci.content_id = 8 AND mit.type_name = 'main-image' 
              ORDER BY pci.position, pci.id;

SELECT t0.id AS id_1, t0.title AS title_2, t0.excerpt AS excerpt_3, t0.body AS body_4, t0.position AS position_5, t0.attribute1 AS attribute1_6, t0.status AS status_7, t0.locale_id AS locale_id_8, t0.post_id AS post_id_9 FROM post_content t0 WHERE t0.post_id = ?

[
  10
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.excerpt AS excerpt_3,
  t0.body AS body_4,
  t0.position AS position_5,
  t0.attribute1 AS attribute1_6,
  t0.status AS status_7,
  t0.locale_id AS locale_id_8,
  t0.post_id AS post_id_9
FROM
  post_content t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.excerpt AS excerpt_3, t0.body AS body_4, t0.position AS position_5, t0.attribute1 AS attribute1_6, t0.status AS status_7, t0.locale_id AS locale_id_8, t0.post_id AS post_id_9 FROM post_content t0 WHERE t0.post_id = 10;

SELECT t0.id AS id_1, t0.position AS position_2, t0.category_id AS category_id_3, t0.post_id AS post_id_4 FROM post_to_category t0 WHERE t0.post_id = ?

[
  10
]

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.category_id AS category_id_3,
  t0.post_id AS post_id_4
FROM
  post_to_category t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.category_id AS category_id_3, t0.post_id AS post_id_4 FROM post_to_category t0 WHERE t0.post_id = 10;