Symfony Profiler

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 = 93;

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 = 95 ORDER BY t0.time_start ASC;

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 = 10;

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 = 96;

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.sequence_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.sequence_id = 83;

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.video_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.video_id = 159;

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
  INNER JOIN post_theme ON t0.id = post_theme.post_id
WHERE
  post_theme.theme_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 INNER JOIN post_theme ON t0.id = post_theme.post_id WHERE post_theme.theme_id = 6;

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.type AS type_2,
  t0.programme_pfo AS programme_pfo_3,
  t0.guideline_esmo AS guideline_esmo_4,
  t0.tncd AS tncd_5,
  t0.theme_id AS theme_id_6
FROM
  treatment t0
WHERE
  t0.theme_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.programme_pfo AS programme_pfo_3, t0.guideline_esmo AS guideline_esmo_4, t0.tncd AS tncd_5, t0.theme_id AS theme_id_6 FROM treatment t0 WHERE t0.theme_id = 6;

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,
  ABS(v0_.views) AS sclr_11,
  v0_.secondary_video_id AS secondary_video_id_12,
  v0_.video_quality_id AS video_quality_id_13
FROM
  video v0_
  INNER JOIN post p1_ ON v0_.id = p1_.video_id
WHERE
  v0_.actif = 1
  AND p1_.actif = 1
ORDER BY
  sclr_11 DESC
LIMIT
  12

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, ABS(v0_.views) AS sclr_11, v0_.secondary_video_id AS secondary_video_id_12, v0_.video_quality_id AS video_quality_id_13 FROM video v0_ INNER JOIN post p1_ ON v0_.id = p1_.video_id WHERE v0_.actif = 1 AND p1_.actif = 1 ORDER BY sclr_11 DESC LIMIT 12;

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 = 9;

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 = 9;

SELECT
  t0_.id AS id_0,
  t0_.actif AS actif_1,
  t0_.image_cover AS image_cover_2,
  t0_.image_cover_hover AS image_cover_hover_3,
  t0_.is_coming_soon AS is_coming_soon_4
FROM
  topics t0_
  INNER JOIN topics_translation t1_ ON t0_.id = t1_.translatable_id
WHERE
  t0_.actif = 1
  AND t0_.is_coming_soon = 0
ORDER BY
  t1_.name ASC

SELECT t0_.id AS id_0, t0_.actif AS actif_1, t0_.image_cover AS image_cover_2, t0_.image_cover_hover AS image_cover_hover_3, t0_.is_coming_soon AS is_coming_soon_4 FROM topics t0_ INNER JOIN topics_translation t1_ ON t0_.id = t1_.translatable_id WHERE t0_.actif = 1 AND t0_.is_coming_soon = 0 ORDER BY t1_.name ASC;

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 = 9;

SELECT
  t0_.id AS id_0,
  t0_.actif AS actif_1,
  t0_.display_order AS display_order_2,
  t0_.topic_id AS topic_id_3
FROM
  theme t0_
  INNER JOIN theme_translation t1_ ON t0_.id = t1_.translatable_id
  INNER JOIN topics t2_ ON t0_.topic_id = t2_.id
WHERE
  t2_.id IN (?, ?, ?)
  AND t2_.actif = 1
  AND t0_.actif = 1
ORDER BY
  t0_.display_order ASC

SELECT t0_.id AS id_0, t0_.actif AS actif_1, t0_.display_order AS display_order_2, t0_.topic_id AS topic_id_3 FROM theme t0_ INNER JOIN theme_translation t1_ ON t0_.id = t1_.translatable_id INNER JOIN topics t2_ ON t0_.topic_id = t2_.id WHERE t2_.id IN (9, 4, 5) AND t2_.actif = 1 AND t0_.actif = 1 ORDER BY t0_.display_order 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 topics t3_ ON t1_.topic_id = t3_.id
  INNER JOIN category_post c4_ ON p0_.category_id = c4_.id
WHERE
  t3_.id IN (?, ?, ?)
  AND c4_.id IN (?)
  AND p0_.actif = 1
ORDER BY
  p0_.date DESC

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 topics t3_ ON t1_.topic_id = t3_.id INNER JOIN category_post c4_ ON p0_.category_id = c4_.id WHERE t3_.id IN (9, 4, 5) AND c4_.id IN (6) AND p0_.actif = 1 ORDER BY p0_.date DESC;

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_.id = p1_.video_id
WHERE
  v0_.actif = 1
  AND p1_.actif = 1
ORDER BY
  p1_.date DESC
LIMIT
  12

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_.id = p1_.video_id WHERE v0_.actif = 1 AND p1_.actif = 1 ORDER BY p1_.date DESC LIMIT 12;

SELECT
  u0_.id AS id_0,
  u0_.last_name AS last_name_1,
  u0_.first_name AS first_name_2,
  u0_.civility AS civility_3,
  u0_.title AS title_4,
  u0_.phone AS phone_5,
  u0_.country AS country_6,
  u0_.facility_name AS facility_name_7,
  u0_.facility_address AS facility_address_8,
  u0_.facility_city AS facility_city_9,
  u0_.facility_post_code AS facility_post_code_10,
  u0_.rppsnumber AS rppsnumber_11,
  u0_.supporting_document AS supporting_document_12,
  u0_.is_student AS is_student_13,
  u0_.is_confirm_pro AS is_confirm_pro_14,
  u0_.is_confirm_receive_alerts AS is_confirm_receive_alerts_15,
  u0_.practice_id AS practice_id_16,
  u0_.formation_id AS formation_id_17,
  u0_.facility_id AS facility_id_18,
  u0_.domain_id AS domain_id_19,
  u0_.user_id AS user_id_20
FROM
  user_info u0_
  INNER JOIN user u1_ ON u0_.user_id = u1_.id
WHERE
  u1_.id = ?
  AND u1_.account_validated = 1
  AND u1_.actif = 1

SELECT u0_.id AS id_0, u0_.last_name AS last_name_1, u0_.first_name AS first_name_2, u0_.civility AS civility_3, u0_.title AS title_4, u0_.phone AS phone_5, u0_.country AS country_6, u0_.facility_name AS facility_name_7, u0_.facility_address AS facility_address_8, u0_.facility_city AS facility_city_9, u0_.facility_post_code AS facility_post_code_10, u0_.rppsnumber AS rppsnumber_11, u0_.supporting_document AS supporting_document_12, u0_.is_student AS is_student_13, u0_.is_confirm_pro AS is_confirm_pro_14, u0_.is_confirm_receive_alerts AS is_confirm_receive_alerts_15, u0_.practice_id AS practice_id_16, u0_.formation_id AS formation_id_17, u0_.facility_id AS facility_id_18, u0_.domain_id AS domain_id_19, u0_.user_id AS user_id_20 FROM user_info u0_ INNER JOIN user u1_ ON u0_.user_id = u1_.id WHERE u1_.id = NULL AND u1_.account_validated = 1 AND u1_.actif = 1;

SELECT
  p0_.id AS id_0,
  p0_.partner_type AS partner_type_1,
  p0_.name AS name_2,
  p0_.description AS description_3,
  p0_.logo AS logo_4,
  p0_.address AS address_5,
  p0_.city AS city_6,
  p0_.post_code AS post_code_7,
  p0_.country AS country_8,
  p0_.phone AS phone_9,
  p0_.actif AS actif_10,
  p0_.email AS email_11,
  p0_.website AS website_12,
  p0_.email_declare_pv AS email_declare_pv_13,
  p0_.email_contact_scientific AS email_contact_scientific_14
FROM
  partner p0_
WHERE
  p0_.actif = 1
  AND p0_.partner_type = ?
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.partner_type AS partner_type_1, p0_.name AS name_2, p0_.description AS description_3, p0_.logo AS logo_4, p0_.address AS address_5, p0_.city AS city_6, p0_.post_code AS post_code_7, p0_.country AS country_8, p0_.phone AS phone_9, p0_.actif AS actif_10, p0_.email AS email_11, p0_.website AS website_12, p0_.email_declare_pv AS email_declare_pv_13, p0_.email_contact_scientific AS email_contact_scientific_14 FROM partner p0_ WHERE p0_.actif = 1 AND p0_.partner_type = 'laboratoire' ORDER BY p0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.content AS content_2,
  b0_.date AS date_3,
  b0_.actif AS actif_4,
  b0_.author AS author_5,
  b0_.introduction AS introduction_6,
  b0_.slug AS slug_7,
  b0_.topics_id AS topics_id_8
FROM
  blog_article b0_
WHERE
  b0_.actif = 1
ORDER BY
  b0_.date DESC
LIMIT
  2

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.date AS date_3, b0_.actif AS actif_4, b0_.author AS author_5, b0_.introduction AS introduction_6, b0_.slug AS slug_7, b0_.topics_id AS topics_id_8 FROM blog_article b0_ WHERE b0_.actif = 1 ORDER BY b0_.date DESC LIMIT 2;

SELECT
  c0_.id AS id_0,
  c0_.slide_order AS slide_order_1,
  ABS(c0_.slide_order) AS sclr_2,
  c0_.post_id AS post_id_3
FROM
  carousel_home c0_
ORDER BY
  sclr_2 ASC

SELECT c0_.id AS id_0, c0_.slide_order AS slide_order_1, ABS(c0_.slide_order) AS sclr_2, c0_.post_id AS post_id_3 FROM carousel_home c0_ ORDER BY sclr_2 ASC;