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 
                   v.id, v.status, v.title, v.description, v.year, v.length, 
                   i.id as image_id, i.filename as image_filename
            FROM video AS v
            LEFT OUTER JOIN video_image AS i
                ON v.front_image_id = i.id 
         INNER JOIN video_actor as a ON v.id = a.video_id WHERE a.actor_id = ? ORDER BY v.title) AS count_query

[
  "6"
]

SELECT
  COUNT(*) AS num
FROM
  (
    SELECT
      v.id,
      v.status,
      v.title,
      v.description,
      v.year,
      v.length,
      i.id as image_id,
      i.filename as image_filename
    FROM
      video AS v
      LEFT OUTER JOIN video_image AS i ON v.front_image_id = i.id
      INNER JOIN video_actor as a ON v.id = a.video_id
    WHERE
      a.actor_id = ?
    ORDER BY
      v.title
  ) AS count_query

SELECT COUNT(*) AS num FROM (
            SELECT 
                   v.id, v.status, v.title, v.description, v.year, v.length, 
                   i.id as image_id, i.filename as image_filename
            FROM video AS v
            LEFT OUTER JOIN video_image AS i
                ON v.front_image_id = i.id 
         INNER JOIN video_actor as a ON v.id = a.video_id WHERE a.actor_id = '6' ORDER BY v.title) AS count_query;

SELECT 
                   v.id, v.status, v.title, v.description, v.year, v.length, 
                   i.id as image_id, i.filename as image_filename
            FROM video AS v
            LEFT OUTER JOIN video_image AS i
                ON v.front_image_id = i.id 
         INNER JOIN video_actor as a ON v.id = a.video_id WHERE a.actor_id = ? ORDER BY v.title LIMIT 0, 9

[
  "6"
]

SELECT
  v.id,
  v.status,
  v.title,
  v.description,
  v.year,
  v.length,
  i.id as image_id,
  i.filename as image_filename
FROM
  video AS v
  LEFT OUTER JOIN video_image AS i ON v.front_image_id = i.id
  INNER JOIN video_actor as a ON v.id = a.video_id
WHERE
  a.actor_id = ?
ORDER BY
  v.title
LIMIT
  0, 9

SELECT 
                   v.id, v.status, v.title, v.description, v.year, v.length, 
                   i.id as image_id, i.filename as image_filename
            FROM video AS v
            LEFT OUTER JOIN video_image AS i
                ON v.front_image_id = i.id 
         INNER JOIN video_actor as a ON v.id = a.video_id WHERE a.actor_id = '6' ORDER BY v.title LIMIT 0, 9;

SELECT a0_.id AS id_0, a0_.name AS name_1 FROM actor a0_ WHERE a0_.id IN ('6') ORDER BY a0_.name ASC

[]

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1
FROM
  actor a0_
WHERE
  a0_.id IN ('6')
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1 FROM actor a0_ WHERE a0_.id IN ('6') ORDER BY a0_.name ASC;

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.multiple_select AS multiple_select_2 FROM tag_category t0_ ORDER BY t0_.name ASC

[]

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.multiple_select AS multiple_select_2
FROM
  tag_category t0_
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.multiple_select AS multiple_select_2 FROM tag_category t0_ ORDER BY t0_.name ASC;

SELECT 
                   t.id, t.name, 
                   c.id as cat_id, c.name as cat_name
            FROM tag AS t
            JOIN tag_category AS c
                ON t.category_id = c.id

[]

SELECT
  t.id,
  t.name,
  c.id as cat_id,
  c.name as cat_name
FROM
  tag AS t
  JOIN tag_category AS c ON t.category_id = c.id

SELECT 
                   t.id, t.name, 
                   c.id as cat_id, c.name as cat_name
            FROM tag AS t
            JOIN tag_category AS c
                ON t.category_id = c.id 
        ;