Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 3
• Debug
• Messages
• E-mails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT COUNT(*) AS num FROM (
            SELECT 
                   a.id, a.name, a.gender, 
                   i.id as image_id, i.filename as image_filename
            FROM actor AS a
            LEFT OUTER JOIN actor_image AS i
                ON a.front_image_id = i.id 
        ) AS count_query

[]

SELECT
  COUNT(*) AS num
FROM
  (
    SELECT
      a.id,
      a.name,
      a.gender,
      i.id as image_id,
      i.filename as image_filename
    FROM
      actor AS a
      LEFT OUTER JOIN actor_image AS i ON a.front_image_id = i.id
  ) AS count_query

SELECT COUNT(*) AS num FROM (
            SELECT 
                   a.id, a.name, a.gender, 
                   i.id as image_id, i.filename as image_filename
            FROM actor AS a
            LEFT OUTER JOIN actor_image AS i
                ON a.front_image_id = i.id 
        ) AS count_query;

SELECT 
                   a.id, a.name, a.gender, 
                   i.id as image_id, i.filename as image_filename
            FROM actor AS a
            LEFT OUTER JOIN actor_image AS i
                ON a.front_image_id = i.id 
         LIMIT 0, 9

[]

SELECT
  a.id,
  a.name,
  a.gender,
  i.id as image_id,
  i.filename as image_filename
FROM
  actor AS a
  LEFT OUTER JOIN actor_image AS i ON a.front_image_id = i.id
LIMIT
  0, 9

SELECT 
                   a.id, a.name, a.gender, 
                   i.id as image_id, i.filename as image_filename
            FROM actor AS a
            LEFT OUTER JOIN actor_image AS i
                ON a.front_image_id = i.id 
         LIMIT 0, 9;