Symfony Profiler

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
FROM
  video v0_
  LEFT JOIN vid_category v1_ ON v0_.category = v1_.id
  LEFT JOIN vid_category v2_ ON v0_.subCategory = v2_.id
WHERE
  (
    v1_.slug = ?
    OR v2_.slug = ?
  )
  AND v0_.status = 1
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 FROM video v0_ LEFT JOIN vid_category v1_ ON v0_.category = v1_.id LEFT JOIN vid_category v2_ ON v0_.subCategory = v2_.id WHERE (v1_.slug = 'love-status' OR v2_.slug = 'love-status') AND v0_.status = 1 ORDER BY v0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.slug AS slug_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.image_name AS image_name_7,
  t0.title AS title_8,
  t0.cat_desc AS cat_desc_9,
  t0.seo_desc AS seo_desc_10,
  t0.seo_title AS seo_title_11,
  t0.desc_title AS desc_title_12,
  t0.keywords AS keywords_13,
  t0.has_child AS has_child_14,
  t0.video_count AS video_count_15,
  t0.parent_id AS parent_id_16
FROM
  vid_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.image_name AS image_name_7, t0.title AS title_8, t0.cat_desc AS cat_desc_9, t0.seo_desc AS seo_desc_10, t0.seo_title AS seo_title_11, t0.desc_title AS desc_title_12, t0.keywords AS keywords_13, t0.has_child AS has_child_14, t0.video_count AS video_count_15, t0.parent_id AS parent_id_16 FROM vid_category t0 WHERE t0.slug = 'love-status' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.comment_at AS comment_at_1,
  c0_.obj_id AS obj_id_2,
  c0_.type AS type_3,
  c0_.website AS website_4,
  c0_.name AS name_5,
  c0_.email AS email_6,
  c0_.comment AS comment_7,
  c0_.ip_address AS ip_address_8,
  c0_.bg_color AS bg_color_9,
  c0_.status AS status_10,
  c0_.parent_id AS parent_id_11
FROM
  comments c0_
WHERE
  c0_.obj_id = ?
  AND c0_.type = ?
  AND c0_.parent_id IS NULL
  AND (
    c0_.status = ?
    OR c0_.ip_address = ?
  )
ORDER BY
  c0_.comment_at DESC

SELECT c0_.id AS id_0, c0_.comment_at AS comment_at_1, c0_.obj_id AS obj_id_2, c0_.type AS type_3, c0_.website AS website_4, c0_.name AS name_5, c0_.email AS email_6, c0_.comment AS comment_7, c0_.ip_address AS ip_address_8, c0_.bg_color AS bg_color_9, c0_.status AS status_10, c0_.parent_id AS parent_id_11 FROM comments c0_ WHERE c0_.obj_id = 34 AND c0_.type = 'cat' AND c0_.parent_id IS NULL AND (c0_.status = 1 OR c0_.ip_address = '216.73.216.148') ORDER BY c0_.comment_at DESC;

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

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_.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
  t0.id AS id_1,
  t0.comment_at AS comment_at_2,
  t0.obj_id AS obj_id_3,
  t0.type AS type_4,
  t0.website AS website_5,
  t0.name AS name_6,
  t0.email AS email_7,
  t0.comment AS comment_8,
  t0.ip_address AS ip_address_9,
  t0.bg_color AS bg_color_10,
  t0.status AS status_11,
  t0.parent_id AS parent_id_12
FROM
  comments t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.comment_at AS comment_at_2, t0.obj_id AS obj_id_3, t0.type AS type_4, t0.website AS website_5, t0.name AS name_6, t0.email AS email_7, t0.comment AS comment_8, t0.ip_address AS ip_address_9, t0.bg_color AS bg_color_10, t0.status AS status_11, t0.parent_id AS parent_id_12 FROM comments t0 WHERE t0.parent_id = 75;

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;