Symfony Profiler

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

Query Metrics

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM video v0_ WHERE v0_.status = ?

[
  1
]

SELECT
  count(DISTINCT v0_.id) AS sclr_0
FROM
  video v0_
WHERE
  v0_.status = ?

SELECT count(DISTINCT v0_.id) AS sclr_0 FROM video v0_ WHERE v0_.status = 1;

SELECT DISTINCT v0_.id AS id_0, v0_.id AS id_1 FROM video v0_ WHERE v0_.status = ? ORDER BY v0_.id DESC LIMIT 18 OFFSET 72

[
  1
]

SELECT
  DISTINCT v0_.id AS id_0,
  v0_.id AS id_1
FROM
  video v0_
WHERE
  v0_.status = ?
ORDER BY
  v0_.id DESC
LIMIT
  18
OFFSET
  72

SELECT DISTINCT v0_.id AS id_0, v0_.id AS id_1 FROM video v0_ WHERE v0_.status = 1 ORDER BY v0_.id DESC LIMIT 18 OFFSET 72;

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.slug AS slug_3, v0_.status AS status_4, v0_.mime_type AS mime_type_5, v0_.file_name AS file_name_6, v0_.picture AS picture_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.duration AS duration_10, v0_.file_size AS file_size_11, v0_.total_view AS total_view_12, v0_.total_like AS total_like_13, v0_.total_dislike AS total_dislike_14, v0_.total_download AS total_download_15, v0_.lang_slug AS lang_slug_16, v0_.file_path AS file_path_17, v0_.user AS user_18, v0_.language AS language_19, v0_.festival AS festival_20, v0_.singer AS singer_21, v0_.category AS category_22, v0_.subCategory AS subCategory_23 FROM video v0_ WHERE v0_.status = ? AND v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.id DESC

[
  1
  1051
  1050
  1049
  1048
  1047
  1046
  1045
  1044
  1043
  1042
  1041
  1040
  1039
  1038
  1037
  1036
  1035
  1034
]

SELECT
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.description AS description_2,
  v0_.slug AS slug_3,
  v0_.status AS status_4,
  v0_.mime_type AS mime_type_5,
  v0_.file_name AS file_name_6,
  v0_.picture AS picture_7,
  v0_.created_at AS created_at_8,
  v0_.updated_at AS updated_at_9,
  v0_.duration AS duration_10,
  v0_.file_size AS file_size_11,
  v0_.total_view AS total_view_12,
  v0_.total_like AS total_like_13,
  v0_.total_dislike AS total_dislike_14,
  v0_.total_download AS total_download_15,
  v0_.lang_slug AS lang_slug_16,
  v0_.file_path AS file_path_17,
  v0_.user AS user_18,
  v0_.language AS language_19,
  v0_.festival AS festival_20,
  v0_.singer AS singer_21,
  v0_.category AS category_22,
  v0_.subCategory AS subCategory_23
FROM
  video v0_
WHERE
  v0_.status = ?
  AND v0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
ORDER BY
  v0_.id DESC

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.slug AS slug_3, v0_.status AS status_4, v0_.mime_type AS mime_type_5, v0_.file_name AS file_name_6, v0_.picture AS picture_7, v0_.created_at AS created_at_8, v0_.updated_at AS updated_at_9, v0_.duration AS duration_10, v0_.file_size AS file_size_11, v0_.total_view AS total_view_12, v0_.total_like AS total_like_13, v0_.total_dislike AS total_dislike_14, v0_.total_download AS total_download_15, v0_.lang_slug AS lang_slug_16, v0_.file_path AS file_path_17, v0_.user AS user_18, v0_.language AS language_19, v0_.festival AS festival_20, v0_.singer AS singer_21, v0_.category AS category_22, v0_.subCategory AS subCategory_23 FROM video v0_ WHERE v0_.status = 1 AND v0_.id IN (1051, 1050, 1049, 1048, 1047, 1046, 1045, 1044, 1043, 1042, 1041, 1040, 1039, 1038, 1037, 1036, 1035, 1034) ORDER BY v0_.id DESC;

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.display_name AS display_name_2, v0_.slug AS slug_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.image_name AS image_name_6, v0_.title AS title_7, v0_.cat_desc AS cat_desc_8, v0_.seo_desc AS seo_desc_9, v0_.seo_title AS seo_title_10, v0_.desc_title AS desc_title_11, v0_.keywords AS keywords_12, v0_.has_child AS has_child_13, v0_.video_count AS video_count_14 FROM vid_category v0_ WHERE v0_.parent_id IS NULL AND v0_.video_count > ? ORDER BY v0_.name ASC LIMIT 5

[
  0
]

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.display_name AS display_name_2,
  v0_.slug AS slug_3,
  v0_.created_at AS created_at_4,
  v0_.updated_at AS updated_at_5,
  v0_.image_name AS image_name_6,
  v0_.title AS title_7,
  v0_.cat_desc AS cat_desc_8,
  v0_.seo_desc AS seo_desc_9,
  v0_.seo_title AS seo_title_10,
  v0_.desc_title AS desc_title_11,
  v0_.keywords AS keywords_12,
  v0_.has_child AS has_child_13,
  v0_.video_count AS video_count_14
FROM
  vid_category v0_
WHERE
  v0_.parent_id IS NULL
  AND v0_.video_count > ?
ORDER BY
  v0_.name ASC
LIMIT
  5

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.display_name AS display_name_2, v0_.slug AS slug_3, v0_.created_at AS created_at_4, v0_.updated_at AS updated_at_5, v0_.image_name AS image_name_6, v0_.title AS title_7, v0_.cat_desc AS cat_desc_8, v0_.seo_desc AS seo_desc_9, v0_.seo_title AS seo_title_10, v0_.desc_title AS desc_title_11, v0_.keywords AS keywords_12, v0_.has_child AS has_child_13, v0_.video_count AS video_count_14 FROM vid_category v0_ WHERE v0_.parent_id IS NULL AND v0_.video_count > 0 ORDER BY v0_.name ASC LIMIT 5;

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.display_name AS display_name_3, f0_.image_name AS image_name_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.title AS title_7, f0_.cat_desc AS cat_desc_8, f0_.seo_title AS seo_title_9, f0_.keywords AS keywords_10, f0_.seo_desc AS seo_desc_11, f0_.desc_title AS desc_title_12, f0_.video_count AS video_count_13 FROM festival f0_ WHERE f0_.video_count > ? ORDER BY f0_.name ASC LIMIT 5

[
  0
]

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.slug AS slug_2,
  f0_.display_name AS display_name_3,
  f0_.image_name AS image_name_4,
  f0_.created_at AS created_at_5,
  f0_.updated_at AS updated_at_6,
  f0_.title AS title_7,
  f0_.cat_desc AS cat_desc_8,
  f0_.seo_title AS seo_title_9,
  f0_.keywords AS keywords_10,
  f0_.seo_desc AS seo_desc_11,
  f0_.desc_title AS desc_title_12,
  f0_.video_count AS video_count_13
FROM
  festival f0_
WHERE
  f0_.video_count > ?
ORDER BY
  f0_.name ASC
LIMIT
  5

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.display_name AS display_name_3, f0_.image_name AS image_name_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6, f0_.title AS title_7, f0_.cat_desc AS cat_desc_8, f0_.seo_title AS seo_title_9, f0_.keywords AS keywords_10, f0_.seo_desc AS seo_desc_11, f0_.desc_title AS desc_title_12, f0_.video_count AS video_count_13 FROM festival f0_ WHERE f0_.video_count > 0 ORDER BY f0_.name ASC LIMIT 5;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.display_name AS display_name_3, s0_.image_name AS image_name_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.title AS title_7, s0_.cat_desc AS cat_desc_8, s0_.seo_title AS seo_title_9, s0_.keywords AS keywords_10, s0_.seo_desc AS seo_desc_11, s0_.desc_title AS desc_title_12, s0_.video_count AS video_count_13 FROM singer s0_ WHERE s0_.video_count > ? ORDER BY s0_.name ASC LIMIT 5

[
  0
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.display_name AS display_name_3,
  s0_.image_name AS image_name_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6,
  s0_.title AS title_7,
  s0_.cat_desc AS cat_desc_8,
  s0_.seo_title AS seo_title_9,
  s0_.keywords AS keywords_10,
  s0_.seo_desc AS seo_desc_11,
  s0_.desc_title AS desc_title_12,
  s0_.video_count AS video_count_13
FROM
  singer s0_
WHERE
  s0_.video_count > ?
ORDER BY
  s0_.name ASC
LIMIT
  5

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.display_name AS display_name_3, s0_.image_name AS image_name_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.title AS title_7, s0_.cat_desc AS cat_desc_8, s0_.seo_title AS seo_title_9, s0_.keywords AS keywords_10, s0_.seo_desc AS seo_desc_11, s0_.desc_title AS desc_title_12, s0_.video_count AS video_count_13 FROM singer s0_ WHERE s0_.video_count > 0 ORDER BY s0_.name ASC LIMIT 5;

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.picture AS picture_2, v0_.slug AS slug_3, v0_.file_size AS file_size_4, v0_.total_view AS total_view_5, v0_.duration AS duration_6, v0_.slug AS slug_7, v1_.id AS id_8, v1_.name AS name_9, v1_.slug AS slug_10 FROM video v0_ LEFT JOIN vid_category v1_ ON v0_.category = v1_.id WHERE v0_.status = 1 ORDER BY v0_.id DESC LIMIT 5

[]

SELECT
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.picture AS picture_2,
  v0_.slug AS slug_3,
  v0_.file_size AS file_size_4,
  v0_.total_view AS total_view_5,
  v0_.duration AS duration_6,
  v0_.slug AS slug_7,
  v1_.id AS id_8,
  v1_.name AS name_9,
  v1_.slug AS slug_10
FROM
  video v0_
  LEFT JOIN vid_category v1_ ON v0_.category = v1_.id
WHERE
  v0_.status = 1
ORDER BY
  v0_.id DESC
LIMIT
  5

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.picture AS picture_2, v0_.slug AS slug_3, v0_.file_size AS file_size_4, v0_.total_view AS total_view_5, v0_.duration AS duration_6, v0_.slug AS slug_7, v1_.id AS id_8, v1_.name AS name_9, v1_.slug AS slug_10 FROM video v0_ LEFT JOIN vid_category v1_ ON v0_.category = v1_.id WHERE v0_.status = 1 ORDER BY v0_.id DESC LIMIT 5;