Symfony Profiler

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

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT film_id,
           original_title,
           title,
           description,
           poster_path,
           release_year,
           kp_rating,
           imdb_rating
    FROM film
    WHERE film_id = ?
      AND status = ?

[
  b"\x01–\x05\f¡Tqó¬\x04ð\fC¹Xp"
  10
]

SELECT
  film_id,
  original_title,
  title,
  description,
  poster_path,
  release_year,
  kp_rating,
  imdb_rating
FROM
  film
WHERE
  film_id = ?
  AND status = ?

SELECT film_id,
           original_title,
           title,
           description,
           poster_path,
           release_year,
           kp_rating,
           imdb_rating
    FROM film
    WHERE film_id = 0x0196050CA15471F3AC04F00C43B95870
      AND status = 10;

SELECT mc.clip_id, mc.film_id, mc.public_key, mc.thumb_path, mc.preview_path, mc.duration, mc.quality, mc.is_vertical, mc.likes, mc.dislikes, mc.views, mc.status, mc.published_at, f1.title as film_title, f1.original_title as film_original_title, f1.poster_path as film_poster_path, f1.release_year as film_release_year, IFNULL(r.title, f.title) as title FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=? LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=? WHERE (mc.film_id =?) AND (mc.status = ?) ORDER BY published_at DESC LIMIT 24

[
  1
  2
  b"\x01–\x05\f¡Tqó¬\x04ð\fC¹Xp"
  10
]

SELECT
  mc.clip_id,
  mc.film_id,
  mc.public_key,
  mc.thumb_path,
  mc.preview_path,
  mc.duration,
  mc.quality,
  mc.is_vertical,
  mc.likes,
  mc.dislikes,
  mc.views,
  mc.status,
  mc.published_at,
  f1.title as film_title,
  f1.original_title as film_original_title,
  f1.poster_path as film_poster_path,
  f1.release_year as film_release_year,
  IFNULL(r.title, f.title) as title
FROM
  movie_clip mc
  LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id
  AND f.lang_id = ?
  LEFT JOIN film f1 ON mc.film_id = f1.film_id
  LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id
  AND r.lang_id = ?
WHERE
  (mc.film_id = ?)
  AND (mc.status = ?)
ORDER BY
  published_at DESC
LIMIT
  24

SELECT mc.clip_id, mc.film_id, mc.public_key, mc.thumb_path, mc.preview_path, mc.duration, mc.quality, mc.is_vertical, mc.likes, mc.dislikes, mc.views, mc.status, mc.published_at, f1.title as film_title, f1.original_title as film_original_title, f1.poster_path as film_poster_path, f1.release_year as film_release_year, IFNULL(r.title, f.title) as title FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=1 LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=2 WHERE (mc.film_id =0x0196050CA15471F3AC04F00C43B95870) AND (mc.status = 10) ORDER BY published_at DESC LIMIT 24;

SELECT COUNT(*) FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=? LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=? WHERE (mc.film_id =?) AND (mc.status = ?)

[
  1
  2
  b"\x01–\x05\f¡Tqó¬\x04ð\fC¹Xp"
  10
]

SELECT
  COUNT(*)
FROM
  movie_clip mc
  LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id
  AND f.lang_id = ?
  LEFT JOIN film f1 ON mc.film_id = f1.film_id
  LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id
  AND r.lang_id = ?
WHERE
  (mc.film_id = ?)
  AND (mc.status = ?)

SELECT COUNT(*) FROM movie_clip mc LEFT JOIN movie_clip_translation f ON mc.clip_id = f.clip_id AND f.lang_id=1 LEFT JOIN film f1 ON mc.film_id = f1.film_id LEFT JOIN movie_clip_translation r ON mc.clip_id = r.clip_id  AND r.lang_id=2 WHERE (mc.film_id =0x0196050CA15471F3AC04F00C43B95870) AND (mc.status = 10);