Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.slug AS slug_4,
  t0.status AS status_5,
  t0.mime_type AS mime_type_6,
  t0.file_name AS file_name_7,
  t0.picture AS picture_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.duration AS duration_11,
  t0.file_size AS file_size_12,
  t0.total_view AS total_view_13,
  t0.total_like AS total_like_14,
  t0.total_dislike AS total_dislike_15,
  t0.total_download AS total_download_16,
  t0.lang_slug AS lang_slug_17,
  t0.file_path AS file_path_18,
  t0.user AS user_19,
  t0.language AS language_20,
  t0.festival AS festival_21,
  t0.singer AS singer_22,
  t0.category AS category_23,
  t0.subCategory AS subCategory_24
FROM
  video t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.slug AS slug_4, t0.status AS status_5, t0.mime_type AS mime_type_6, t0.file_name AS file_name_7, t0.picture AS picture_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.duration AS duration_11, t0.file_size AS file_size_12, t0.total_view AS total_view_13, t0.total_like AS total_like_14, t0.total_dislike AS total_dislike_15, t0.total_download AS total_download_16, t0.lang_slug AS lang_slug_17, t0.file_path AS file_path_18, t0.user AS user_19, t0.language AS language_20, t0.festival AS festival_21, t0.singer AS singer_22, t0.category AS category_23, t0.subCategory AS subCategory_24 FROM video t0 WHERE t0.slug = 'first-night-romantic-status-video' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  video
SET
  total_view = ?
WHERE
  id = ?

UPDATE video SET total_view = 35 WHERE id = 259;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.display_name AS display_name_4
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.display_name AS display_name_4 FROM language t0 WHERE t0.id = 2;

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.id = ?

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.id = 34;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  vid_tag t0
  INNER JOIN video_tags ON t0.id = video_tags.tag_id
WHERE
  video_tags.video_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM vid_tag t0 INNER JOIN video_tags ON t0.id = video_tags.tag_id WHERE video_tags.video_id = 259;

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
  v1_.id IN (?)
  AND v0_.id <> ?
  AND v0_.status = 1
ORDER BY
  v0_.title ASC
LIMIT
  6

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 v1_.id IN (34) AND v0_.id <> 259 AND v0_.status = 1 ORDER BY v0_.title ASC LIMIT 6;

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 = 259 AND c0_.type = 'video' 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
  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

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_.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;