Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  COUNT(t1_.id) AS sclr_2
FROM
  training t1_
  INNER JOIN training_category t0_ ON t1_.category_id = t0_.id
WHERE
  t1_.type IN ('elearning')
GROUP BY
  t0_.id
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, COUNT(t1_.id) AS sclr_2 FROM training t1_ INNER JOIN training_category t0_ ON t1_.category_id = t0_.id WHERE t1_.type IN ('elearning') GROUP BY t0_.id ORDER BY t0_.name ASC;

SELECT
  DISTINCT t0_.level AS level_0
FROM
  training t0_
WHERE
  (t0_.level IS NOT NULL)
  AND t0_.type IN ('elearning')

SELECT DISTINCT t0_.level AS level_0 FROM training t0_ WHERE (t0_.level IS NOT NULL) AND t0_.type IN ('elearning');

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.firstname || ' ' || t0_.lastname AS sclr_1
FROM
  training t1_
  INNER JOIN training_trainer t2_ ON t1_.id = t2_.training_id
  INNER JOIN trainer t0_ ON t0_.id = t2_.trainer_id
WHERE
  t1_.type IN ('elearning')
ORDER BY
  t0_.lastname ASC

SELECT DISTINCT t0_.id AS id_0, t0_.firstname || ' ' || t0_.lastname AS sclr_1 FROM training t1_ INNER JOIN training_trainer t2_ ON t1_.id = t2_.training_id INNER JOIN trainer t0_ ON t0_.id = t2_.trainer_id WHERE t1_.type IN ('elearning') ORDER BY t0_.lastname ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      featured_on_search_9
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.label AS label_1,
          t0_.code AS code_2,
          t0_.slug_history AS slug_history_3,
          t0_.description AS description_4,
          t0_.price AS price_5,
          t0_.status AS status_6,
          t0_.satisfaction_rate AS satisfaction_rate_7,
          t0_.completion_rate AS completion_rate_8,
          t0_.featured_on_search AS featured_on_search_9,
          t0_.pixels AS pixels_10,
          t0_.updated_at AS updated_at_11,
          t0_.seo_title AS seo_title_12,
          t0_.seo_description AS seo_description_13,
          t0_.seo_canonical AS seo_canonical_14,
          t0_.seo_indexed AS seo_indexed_15,
          t0_.slug AS slug_16,
          t0_.level AS level_17,
          t0_.language AS language_18,
          t0_.hours AS hours_19,
          t0_.additional_students AS additional_students_20,
          t0_.listing_image_name AS listing_image_name_21,
          t0_.show_image_name AS show_image_name_22,
          t0_.type AS type_23
        FROM
          training t0_
        WHERE
          (
            t0_.category_id IN (?)
          )
          AND t0_.type IN ('elearning')
      ) dctrn_result_inner
    ORDER BY
      featured_on_search_9 DESC,
      id_0 DESC
  ) dctrn_result
LIMIT
  7

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, featured_on_search_9 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.level AS level_17, t0_.language AS language_18, t0_.hours AS hours_19, t0_.additional_students AS additional_students_20, t0_.listing_image_name AS listing_image_name_21, t0_.show_image_name AS show_image_name_22, t0_.type AS type_23 FROM training t0_ WHERE (t0_.category_id IN ('18')) AND t0_.type IN ('elearning')) dctrn_result_inner ORDER BY featured_on_search_9 DESC, id_0 DESC) dctrn_result LIMIT 7;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.label AS label_1,
          t0_.code AS code_2,
          t0_.slug_history AS slug_history_3,
          t0_.description AS description_4,
          t0_.price AS price_5,
          t0_.status AS status_6,
          t0_.satisfaction_rate AS satisfaction_rate_7,
          t0_.completion_rate AS completion_rate_8,
          t0_.featured_on_search AS featured_on_search_9,
          t0_.pixels AS pixels_10,
          t0_.updated_at AS updated_at_11,
          t0_.seo_title AS seo_title_12,
          t0_.seo_description AS seo_description_13,
          t0_.seo_canonical AS seo_canonical_14,
          t0_.seo_indexed AS seo_indexed_15,
          t0_.slug AS slug_16,
          t0_.level AS level_17,
          t0_.language AS language_18,
          t0_.hours AS hours_19,
          t0_.additional_students AS additional_students_20,
          t0_.listing_image_name AS listing_image_name_21,
          t0_.show_image_name AS show_image_name_22,
          t0_.type AS type_23
        FROM
          training t0_
        WHERE
          (
            t0_.category_id IN (?)
          )
          AND t0_.type IN ('elearning')
        ORDER BY
          t0_.featured_on_search DESC,
          t0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.level AS level_17, t0_.language AS language_18, t0_.hours AS hours_19, t0_.additional_students AS additional_students_20, t0_.listing_image_name AS listing_image_name_21, t0_.show_image_name AS show_image_name_22, t0_.type AS type_23 FROM training t0_ WHERE (t0_.category_id IN ('18')) AND t0_.type IN ('elearning') ORDER BY t0_.featured_on_search DESC, t0_.id DESC) dctrn_result) dctrn_table;

SELECT
  t0_.id AS id_0,
  t0_.label AS label_1,
  t0_.code AS code_2,
  t0_.slug_history AS slug_history_3,
  t0_.description AS description_4,
  t0_.price AS price_5,
  t0_.status AS status_6,
  t0_.satisfaction_rate AS satisfaction_rate_7,
  t0_.completion_rate AS completion_rate_8,
  t0_.featured_on_search AS featured_on_search_9,
  t0_.pixels AS pixels_10,
  t0_.updated_at AS updated_at_11,
  t0_.seo_title AS seo_title_12,
  t0_.seo_description AS seo_description_13,
  t0_.seo_canonical AS seo_canonical_14,
  t0_.seo_indexed AS seo_indexed_15,
  t0_.slug AS slug_16,
  t0_.level AS level_17,
  t0_.language AS language_18,
  t0_.hours AS hours_19,
  t0_.additional_students AS additional_students_20,
  t0_.listing_image_name AS listing_image_name_21,
  t0_.show_image_name AS show_image_name_22,
  t0_.type AS type_23,
  t0_.created_by_id AS created_by_id_24,
  t0_.category_id AS category_id_25
FROM
  training t0_
WHERE
  (
    t0_.category_id IN (?)
    AND t0_.id IN (?)
  )
  AND t0_.type IN ('elearning')
ORDER BY
  t0_.featured_on_search DESC,
  t0_.id DESC

SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.code AS code_2, t0_.slug_history AS slug_history_3, t0_.description AS description_4, t0_.price AS price_5, t0_.status AS status_6, t0_.satisfaction_rate AS satisfaction_rate_7, t0_.completion_rate AS completion_rate_8, t0_.featured_on_search AS featured_on_search_9, t0_.pixels AS pixels_10, t0_.updated_at AS updated_at_11, t0_.seo_title AS seo_title_12, t0_.seo_description AS seo_description_13, t0_.seo_canonical AS seo_canonical_14, t0_.seo_indexed AS seo_indexed_15, t0_.slug AS slug_16, t0_.level AS level_17, t0_.language AS language_18, t0_.hours AS hours_19, t0_.additional_students AS additional_students_20, t0_.listing_image_name AS listing_image_name_21, t0_.show_image_name AS show_image_name_22, t0_.type AS type_23, t0_.created_by_id AS created_by_id_24, t0_.category_id AS category_id_25 FROM training t0_ WHERE (t0_.category_id IN ('18') AND t0_.id IN (383)) AND t0_.type IN ('elearning') ORDER BY t0_.featured_on_search DESC, t0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enable AS enable_4,
  t0.updated_at AS updated_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_canonical AS seo_canonical_8,
  t0.seo_indexed AS seo_indexed_9
FROM
  cms_page t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = 1;

SELECT
  DISTINCT t0_.language AS language_0
FROM
  training t0_
WHERE
  (t0_.language IS NOT NULL)
  AND t0_.type IN ('elearning')

SELECT DISTINCT t0_.language AS language_0 FROM training t0_ WHERE (t0_.language IS NOT NULL) AND t0_.type IN ('elearning');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 WHERE t0.id = 18;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.certifications AS certifications_6,
  t0.status AS status_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9,
  t0.available AS available_10,
  t0.nda_status AS nda_status_11,
  t0.joined_at AS joined_at_12,
  t0.is_senza_trainer AS is_senza_trainer_13,
  t0.data_gouv_link AS data_gouv_link_14,
  t0.level AS level_15,
  t0.languages AS languages_16,
  t0.total_trainings AS total_trainings_17,
  t0.quality_chart_signed AS quality_chart_signed_18,
  t0.senza_training_validated AS senza_training_validated_19,
  t0.expert AS expert_20,
  t0.siret AS siret_21,
  t0.nda_number AS nda_number_22,
  t0.email_hash AS email_hash_23,
  t0.user_id AS user_id_24
FROM
  trainer t0
  INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id
WHERE
  training_trainer.training_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.slug AS slug_4, t0.description AS description_5, t0.certifications AS certifications_6, t0.status AS status_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.available AS available_10, t0.nda_status AS nda_status_11, t0.joined_at AS joined_at_12, t0.is_senza_trainer AS is_senza_trainer_13, t0.data_gouv_link AS data_gouv_link_14, t0.level AS level_15, t0.languages AS languages_16, t0.total_trainings AS total_trainings_17, t0.quality_chart_signed AS quality_chart_signed_18, t0.senza_training_validated AS senza_training_validated_19, t0.expert AS expert_20, t0.siret AS siret_21, t0.nda_number AS nda_number_22, t0.email_hash AS email_hash_23, t0.user_id AS user_id_24 FROM trainer t0 INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id WHERE training_trainer.training_id = 383;