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
                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œ.B\x1F}~בÂÇø$¡IŸ"
  b"\x01›ä²Í'~p‡ê÷µMk\x03"
  b"\x01›ä²Ý~q\x14³Ùg¦Â5‘…"
  b"\x01›ä²Ø\x1Fu\x03¥’±ðsº"&"
  b"\x01›ä²Ò‚}îƒ\x1CÌÐ\x0FJ2Ð"
  b"\x01›ä²Ý}~ô´´µrÙ>\x16"
  b"\x01›ä²Í(roŠ×c+­=”¥"
  b"\x01›ä²Ò‚|Žƒ\x1CÌÐ\x0F\x01B´"
  b"\x01›ä²Ø\x1Fq«¥’±ðsT"
  b"\x01›ä²Òƒq*•±u]B%\x0F'"
  b"\x01›ä²Çýt#¿ë\x14)G1´Ö"
  b"\x01›ä²Ø\x1Fs§¥’±ðs¥œÑ"
]

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 (0x019C2E421F7D7ED791C2C7F824A1499F, 0x019BE4B2CD277E7087EA90F7B54D6B03, 0x019BE4B2DD7E7114B3D967A6C2359185, 0x019BE4B2D81F7503A592B1F073BA2226, 0x019BE4B2D2827DEE831CCCD00F4A32D0, 0x019BE4B2DD7D7EF4B4B4B572D93E9D16, 0x019BE4B2CD28726F8AD7632BAD3D94A5, 0x019BE4B2D2827C8E831CCCD00F0142B4, 0x019BE4B2D81F71ABA592B1F07381549D, 0x019BE4B2D283712A95B1755D42250F27, 0x019BE4B2C7FD7423BFEB14294731B4D6, 0x019BE4B2D81F73A7A592B1F073A59CD1)
            ORDER BY ma.id ASC
        ;

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

[]

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

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