Symfony Profiler

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

Query Metrics

SELECT COUNT(*) FROM posts p WHERE 1=1

[]

SELECT
  COUNT(*)
FROM
  posts p
WHERE
  1 = 1

SELECT COUNT(*) FROM posts p WHERE 1=1;

SELECT
                BIN_TO_UUID(p.id) as id,
                p.caption,
                p.tags,
                p.like_count,
                p.comment_count,
                p.created_at,
                BIN_TO_UUID(prof.id) as professional_id,
                prof.display_name as professional_name,
                prof.avatar_url as professional_avatar_url,
                prof.badge_level as professional_badge_level
            FROM posts p
            LEFT JOIN professional_profiles prof ON p.professional_id = prof.id
            WHERE 1=1
            ORDER BY p.created_at DESC
            LIMIT ? OFFSET ?

[
  12
  0
]

SELECT
  BIN_TO_UUID(p.id) as id,
  p.caption,
  p.tags,
  p.like_count,
  p.comment_count,
  p.created_at,
  BIN_TO_UUID(prof.id) as professional_id,
  prof.display_name as professional_name,
  prof.avatar_url as professional_avatar_url,
  prof.badge_level as professional_badge_level
FROM
  posts p
  LEFT JOIN professional_profiles prof ON p.professional_id = prof.id
WHERE
  1 = 1
ORDER BY
  p.created_at DESC
LIMIT
  ?
OFFSET
  ?

SELECT
                BIN_TO_UUID(p.id) as id,
                p.caption,
                p.tags,
                p.like_count,
                p.comment_count,
                p.created_at,
                BIN_TO_UUID(prof.id) as professional_id,
                prof.display_name as professional_name,
                prof.avatar_url as professional_avatar_url,
                prof.badge_level as professional_badge_level
            FROM posts p
            LEFT JOIN professional_profiles prof ON p.professional_id = prof.id
            WHERE 1=1
            ORDER BY p.created_at DESC
            LIMIT 12 OFFSET 0
        ;

SELECT
                BIN_TO_UUID(pm.post_id) as post_id,
                ma.url,
                ma.type
            FROM post_media_assets pm
            JOIN media_assets ma ON pm.media_asset_id = ma.id
            WHERE pm.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
            ORDER BY ma.id ASC

[
  b"\x01\x1As½`sЇÙ$í@•\rú"
  b"\x01œeˆö$zê¬\x0Fð\x05_"´X"
  b"\x01œeˆîHu\v–ÌÇpÕ)Tü"
  b"\x01œeˆðÞ|€\x06þ©Ñ£˜3"
  b"""
    \x01œeˆë£|D¼É\n
    tF†\eH
    """
  b"\x01œeˆðÞ{0\x06þ©Ï]SB"
  b"""
    \x01œeˆë£}¬¼É\n
    tI\x0F›#
    """
  b"\x01œeˆîHuË–ÌÇpÖ^y„"
  b"\x01œeˆó~zâ2b¤kŒÕ("
  b"""
    \x01œeˆë£{\x1C¼É\n
    tEŠ¯n
    """
  b"\x01œeˆðÞ{à\x06þ©ÐÄë^"
  b"\x01œeˆö${Ž¬\x0Fð\x05`/\x03<"
]

SELECT
  BIN_TO_UUID(pm.post_id) as post_id,
  ma.url,
  ma.type
FROM
  post_media_assets pm
  JOIN media_assets ma ON pm.media_asset_id = ma.id
WHERE
  pm.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  ma.id ASC

SELECT
                BIN_TO_UUID(pm.post_id) as post_id,
                ma.url,
                ma.type
            FROM post_media_assets pm
            JOIN media_assets ma ON pm.media_asset_id = ma.id
            WHERE pm.post_id IN (0x019D1A73BD6073D087D924ED40950DFA, 0x019C6588F6247AEAAC0FF0055F22B458, 0x019C6588EE48750B96CCC770D52954FC, 0x019C6588F0DE7C809006FEA9D1A39833, 0x019C6588EBA37C44BCC90A7446861B48, 0x019C6588F0DE7B309006FEA9CF5D5342, 0x019C6588EBA37DACBCC90A74490F9B23, 0x019C6588EE4875CB96CCC770D65E7984, 0x019C6588F37E7AC3A23262A46B8CD528, 0x019C6588EBA37B1CBCC90A74458AAF6E, 0x019C6588F0DE7BE09006FEA9D0C4EB5E, 0x019C6588F6247B8EAC0FF005602F033C)
            ORDER BY ma.id ASC
        ;