Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.time_start AS time_start_3,
  t0.time_end AS time_end_4,
  t0.image_cover AS image_cover_5,
  t0.actif AS actif_6,
  t0.video_id AS video_id_7,
  t0.theme_id AS theme_id_8
FROM
  video_sequence t0
WHERE
  t0.video_id = ?
ORDER BY
  t0.time_start ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.time_start AS time_start_3, t0.time_end AS time_end_4, t0.image_cover AS image_cover_5, t0.actif AS actif_6, t0.video_id AS video_id_7, t0.theme_id AS theme_id_8 FROM video_sequence t0 WHERE t0.video_id = 302 ORDER BY t0.time_start ASC;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.views AS views_3,
  t0.actif AS actif_4,
  t0.likes AS likes_5,
  t0.quality AS quality_6,
  t0.main_video AS main_video_7,
  t0.image_cover AS image_cover_8,
  t0.title AS title_9,
  t0.duration AS duration_10,
  t0.produced_by_t4_m AS produced_by_t4_m_11,
  t0.secondary_video_id AS secondary_video_id_12,
  t0.video_quality_id AS video_quality_id_13
FROM
  video t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.views AS views_3, t0.actif AS actif_4, t0.likes AS likes_5, t0.quality AS quality_6, t0.main_video AS main_video_7, t0.image_cover AS image_cover_8, t0.title AS title_9, t0.duration AS duration_10, t0.produced_by_t4_m AS produced_by_t4_m_11, t0.secondary_video_id AS secondary_video_id_12, t0.video_quality_id AS video_quality_id_13 FROM video t0 WHERE t0.id = 302;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.actif AS actif_3,
  t0.user_id AS user_id_4,
  t0.sequence_id AS sequence_id_5,
  t0.post_id AS post_id_6
FROM
  user_list t0
WHERE
  t0.post_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.actif AS actif_3, t0.user_id AS user_id_4, t0.sequence_id AS sequence_id_5, t0.post_id AS post_id_6 FROM user_list t0 WHERE t0.post_id = 78;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.description_short AS description_short_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  post_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.description_short AS description_short_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM post_translation t0 WHERE t0.translatable_id = 75;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.actif AS actif_3,
  t0.image_cover AS image_cover_4,
  t0.is_molecule AS is_molecule_5,
  t0.date_last_modification AS date_last_modification_6,
  t0.tags AS tags_7,
  t0.carousel_image AS carousel_image_8,
  t0.carousel_only AS carousel_only_9,
  t0.treatment_id AS treatment_id_10,
  t0.video_id AS video_id_11,
  t0.partner_id AS partner_id_12,
  t0.category_id AS category_id_13
FROM
  post t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.actif AS actif_3, t0.image_cover AS image_cover_4, t0.is_molecule AS is_molecule_5, t0.date_last_modification AS date_last_modification_6, t0.tags AS tags_7, t0.carousel_image AS carousel_image_8, t0.carousel_only AS carousel_only_9, t0.treatment_id AS treatment_id_10, t0.video_id AS video_id_11, t0.partner_id AS partner_id_12, t0.category_id AS category_id_13 FROM post t0 WHERE t0.id = 77;

SELECT
  p0_.id AS id_0,
  p0_.date AS date_1,
  p0_.actif AS actif_2,
  p0_.image_cover AS image_cover_3,
  p0_.is_molecule AS is_molecule_4,
  p0_.date_last_modification AS date_last_modification_5,
  p0_.tags AS tags_6,
  p0_.carousel_image AS carousel_image_7,
  p0_.carousel_only AS carousel_only_8,
  p0_.treatment_id AS treatment_id_9,
  p0_.video_id AS video_id_10,
  p0_.partner_id AS partner_id_11,
  p0_.category_id AS category_id_12
FROM
  post p0_
WHERE
  p0_.id = ?
  AND p0_.actif = 1

SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.actif AS actif_2, p0_.image_cover AS image_cover_3, p0_.is_molecule AS is_molecule_4, p0_.date_last_modification AS date_last_modification_5, p0_.tags AS tags_6, p0_.carousel_image AS carousel_image_7, p0_.carousel_only AS carousel_only_8, p0_.treatment_id AS treatment_id_9, p0_.video_id AS video_id_10, p0_.partner_id AS partner_id_11, p0_.category_id AS category_id_12 FROM post p0_ WHERE p0_.id = '75' AND p0_.actif = 1;

SELECT
  p0_.id AS id_0,
  p0_.date AS date_1,
  p0_.actif AS actif_2,
  p0_.image_cover AS image_cover_3,
  p0_.is_molecule AS is_molecule_4,
  p0_.date_last_modification AS date_last_modification_5,
  p0_.tags AS tags_6,
  p0_.carousel_image AS carousel_image_7,
  p0_.carousel_only AS carousel_only_8,
  p0_.treatment_id AS treatment_id_9,
  p0_.video_id AS video_id_10,
  p0_.partner_id AS partner_id_11,
  p0_.category_id AS category_id_12
FROM
  post p0_
  INNER JOIN post_theme p2_ ON p0_.id = p2_.post_id
  INNER JOIN theme t1_ ON t1_.id = p2_.theme_id
  INNER JOIN post_translation p3_ ON p0_.id = p3_.translatable_id
  INNER JOIN category_post c4_ ON p0_.category_id = c4_.id
WHERE
  c4_.id = ?
  AND t1_.id IN (?)
  AND p0_.actif = 1
ORDER BY
  p3_.title ASC

SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.actif AS actif_2, p0_.image_cover AS image_cover_3, p0_.is_molecule AS is_molecule_4, p0_.date_last_modification AS date_last_modification_5, p0_.tags AS tags_6, p0_.carousel_image AS carousel_image_7, p0_.carousel_only AS carousel_only_8, p0_.treatment_id AS treatment_id_9, p0_.video_id AS video_id_10, p0_.partner_id AS partner_id_11, p0_.category_id AS category_id_12 FROM post p0_ INNER JOIN post_theme p2_ ON p0_.id = p2_.post_id INNER JOIN theme t1_ ON t1_.id = p2_.theme_id INNER JOIN post_translation p3_ ON p0_.id = p3_.translatable_id INNER JOIN category_post c4_ ON p0_.category_id = c4_.id WHERE c4_.id = 2 AND t1_.id IN (6) AND p0_.actif = 1 ORDER BY p3_.title ASC;

SELECT
  v0_.id AS id_0,
  v0_.url AS url_1,
  v0_.views AS views_2,
  v0_.actif AS actif_3,
  v0_.likes AS likes_4,
  v0_.quality AS quality_5,
  v0_.main_video AS main_video_6,
  v0_.image_cover AS image_cover_7,
  v0_.title AS title_8,
  v0_.duration AS duration_9,
  v0_.produced_by_t4_m AS produced_by_t4_m_10,
  v0_.secondary_video_id AS secondary_video_id_11,
  v0_.video_quality_id AS video_quality_id_12
FROM
  video v0_
  INNER JOIN post p1_ ON v0_.secondary_video_id = p1_.id
WHERE
  p1_.id = ?
  AND v0_.actif = 1

SELECT v0_.id AS id_0, v0_.url AS url_1, v0_.views AS views_2, v0_.actif AS actif_3, v0_.likes AS likes_4, v0_.quality AS quality_5, v0_.main_video AS main_video_6, v0_.image_cover AS image_cover_7, v0_.title AS title_8, v0_.duration AS duration_9, v0_.produced_by_t4_m AS produced_by_t4_m_10, v0_.secondary_video_id AS secondary_video_id_11, v0_.video_quality_id AS video_quality_id_12 FROM video v0_ INNER JOIN post p1_ ON v0_.secondary_video_id = p1_.id WHERE p1_.id = 75 AND v0_.actif = 1;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.image_cover AS image_cover_3,
  t0.image_cover_hover AS image_cover_hover_4,
  t0.is_coming_soon AS is_coming_soon_5
FROM
  topics t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.image_cover AS image_cover_3, t0.image_cover_hover AS image_cover_hover_4, t0.is_coming_soon AS is_coming_soon_5 FROM topics t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.display_order AS display_order_3,
  t0.topic_id AS topic_id_4
FROM
  theme t0
  INNER JOIN post_theme ON t0.id = post_theme.theme_id
WHERE
  post_theme.post_id = ?

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.display_order AS display_order_3, t0.topic_id AS topic_id_4 FROM theme t0 INNER JOIN post_theme ON t0.id = post_theme.theme_id WHERE post_theme.post_id = 75;

SELECT
  d0_.id AS id_0,
  d0_.display_order AS display_order_1,
  d0_.dossier_id AS dossier_id_2,
  d0_.post_id AS post_id_3,
  d0_.category_id AS category_id_4
FROM
  dossier_playlist_item d0_
  INNER JOIN dossier d1_ ON d0_.dossier_id = d1_.id
  INNER JOIN post p2_ ON d0_.post_id = p2_.id
WHERE
  d1_.id = ?
  AND p2_.id = ?

SELECT d0_.id AS id_0, d0_.display_order AS display_order_1, d0_.dossier_id AS dossier_id_2, d0_.post_id AS post_id_3, d0_.category_id AS category_id_4 FROM dossier_playlist_item d0_ INNER JOIN dossier d1_ ON d0_.dossier_id = d1_.id INNER JOIN post p2_ ON d0_.post_id = p2_.id WHERE d1_.id = 8 AND p2_.id = 75;

SELECT
  d0_.id AS id_0,
  d0_.display_order AS display_order_1,
  ABS(d0_.display_order) AS sclr_2,
  d0_.dossier_id AS dossier_id_3,
  d0_.post_id AS post_id_4,
  d0_.category_id AS category_id_5
FROM
  dossier_playlist_item d0_
  INNER JOIN dossier d1_ ON d0_.dossier_id = d1_.id
WHERE
  d1_.id = ?
ORDER BY
  sclr_2 ASC

SELECT d0_.id AS id_0, d0_.display_order AS display_order_1, ABS(d0_.display_order) AS sclr_2, d0_.dossier_id AS dossier_id_3, d0_.post_id AS post_id_4, d0_.category_id AS category_id_5 FROM dossier_playlist_item d0_ INNER JOIN dossier d1_ ON d0_.dossier_id = d1_.id WHERE d1_.id = 8 ORDER BY sclr_2 ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  topics_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM topics_translation t0 WHERE t0.translatable_id = 4;

SELECT
  d0_.id AS id_0,
  d0_.image_cover AS image_cover_1,
  d0_.logo AS logo_2,
  d0_.actif AS actif_3,
  d0_.date AS date_4,
  d0_.place AS place_5,
  d0_.category_id AS category_id_6,
  d0_.topic_id AS topic_id_7
FROM
  dossier d0_
  INNER JOIN dossier_playlist_item d1_ ON d0_.id = d1_.dossier_id
  INNER JOIN post p2_ ON d1_.post_id = p2_.id
WHERE
  p2_.id = ?

SELECT d0_.id AS id_0, d0_.image_cover AS image_cover_1, d0_.logo AS logo_2, d0_.actif AS actif_3, d0_.date AS date_4, d0_.place AS place_5, d0_.category_id AS category_id_6, d0_.topic_id AS topic_id_7 FROM dossier d0_ INNER JOIN dossier_playlist_item d1_ ON d0_.id = d1_.dossier_id INNER JOIN post p2_ ON d1_.post_id = p2_.id WHERE p2_.id = 75;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.actif AS actif_4
FROM
  lien_interet t0
  INNER JOIN post_lien_interet ON t0.id = post_lien_interet.lien_interet_id
WHERE
  post_lien_interet.post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.actif AS actif_4 FROM lien_interet t0 INNER JOIN post_lien_interet ON t0.id = post_lien_interet.lien_interet_id WHERE post_lien_interet.post_id = 75;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  dossier_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM dossier_translation t0 WHERE t0.translatable_id = 8;

SELECT
  d0_.id AS id_0,
  d0_.display_order AS display_order_1,
  d0_.dossier_id AS dossier_id_2,
  d0_.post_id AS post_id_3,
  d0_.category_id AS category_id_4
FROM
  dossier_playlist_item d0_
  INNER JOIN dossier d1_ ON d0_.dossier_id = d1_.id
WHERE
  d1_.id = ?
  AND d0_.display_order = ?

SELECT d0_.id AS id_0, d0_.display_order AS display_order_1, d0_.dossier_id AS dossier_id_2, d0_.post_id AS post_id_3, d0_.category_id AS category_id_4 FROM dossier_playlist_item d0_ INNER JOIN dossier d1_ ON d0_.dossier_id = d1_.id WHERE d1_.id = 8 AND d0_.display_order = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  theme_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM theme_translation t0 WHERE t0.translatable_id = 6;

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.display_order AS display_order_3,
  t0.parent_id AS parent_id_4
FROM
  category_post t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.display_order AS display_order_3, t0.parent_id AS parent_id_4 FROM category_post t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  category_post_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM category_post_translation t0 WHERE t0.translatable_id = 2;