Symfony Profiler

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
  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
ORDER BY
  t0.name ASC

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 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.description AS description_4,
  t0.image_name AS image_name_5,
  t0.updated_at AS updated_at_6
FROM
  financing t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6 FROM financing t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.address AS address_3,
  t0.zip_code AS zip_code_4,
  t0.city AS city_5,
  t0.image_name AS image_name_6,
  t0.updated_at AS updated_at_7,
  t0.phone_number AS phone_number_8,
  t0.information AS information_9,
  t0.amenities AS amenities_10,
  t0.google_map_link AS google_map_link_11
FROM
  place t0
ORDER BY
  t0.city ASC

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.address AS address_3, t0.zip_code AS zip_code_4, t0.city AS city_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.phone_number AS phone_number_8, t0.information AS information_9, t0.amenities AS amenities_10, t0.google_map_link AS google_map_link_11 FROM place t0 ORDER BY t0.city ASC;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.label AS label_1,
          t0_.slug AS slug_2,
          t0_.pdf_name AS pdf_name_3,
          t0_.pdf_mime_type AS pdf_mime_type_4,
          t0_.updated_at AS updated_at_5,
          t0_.show_on_home_page AS show_on_home_page_6,
          t0_.featured_on_search AS featured_on_search_7,
          t0_.price AS price_8,
          t0_.cpf AS cpf_9,
          t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10,
          t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11,
          t0_.individual_videoconference_hours AS individual_videoconference_hours_12,
          t0_.collective_videoconference_hours AS collective_videoconference_hours_13,
          t0_.elearning_hours AS elearning_hours_14,
          t0_.format AS format_15,
          t0_.description AS description_16,
          t0_.min_period AS min_period_17,
          t0_.max_period AS max_period_18,
          t0_.public AS public_19,
          t0_.prerequisites AS prerequisites_20,
          t0_.code AS code_21,
          t0_.face_to_face_hours_text AS face_to_face_hours_text_22,
          t0_.satisfaction_rate AS satisfaction_rate_23,
          t0_.cpf_link AS cpf_link_24,
          t0_.completion_rate AS completion_rate_25,
          t0_.slug_history AS slug_history_26,
          t0_.sub_title AS sub_title_27,
          t0_.pixels AS pixels_28,
          t0_.status AS status_29,
          t0_.seo_title AS seo_title_30,
          t0_.seo_description AS seo_description_31,
          t0_.seo_canonical AS seo_canonical_32,
          t0_.seo_indexed AS seo_indexed_33
        FROM
          training t0_
        WHERE
          t0_.category_id IN (?)
        ORDER BY
          t0_.featured_on_search DESC,
          t0_.updated_at 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_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33 FROM training t0_ WHERE t0_.category_id IN ('24') ORDER BY t0_.featured_on_search DESC, t0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      featured_on_search_7,
      updated_at_5
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.label AS label_1,
          t0_.slug AS slug_2,
          t0_.pdf_name AS pdf_name_3,
          t0_.pdf_mime_type AS pdf_mime_type_4,
          t0_.updated_at AS updated_at_5,
          t0_.show_on_home_page AS show_on_home_page_6,
          t0_.featured_on_search AS featured_on_search_7,
          t0_.price AS price_8,
          t0_.cpf AS cpf_9,
          t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10,
          t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11,
          t0_.individual_videoconference_hours AS individual_videoconference_hours_12,
          t0_.collective_videoconference_hours AS collective_videoconference_hours_13,
          t0_.elearning_hours AS elearning_hours_14,
          t0_.format AS format_15,
          t0_.description AS description_16,
          t0_.min_period AS min_period_17,
          t0_.max_period AS max_period_18,
          t0_.public AS public_19,
          t0_.prerequisites AS prerequisites_20,
          t0_.code AS code_21,
          t0_.face_to_face_hours_text AS face_to_face_hours_text_22,
          t0_.satisfaction_rate AS satisfaction_rate_23,
          t0_.cpf_link AS cpf_link_24,
          t0_.completion_rate AS completion_rate_25,
          t0_.slug_history AS slug_history_26,
          t0_.sub_title AS sub_title_27,
          t0_.pixels AS pixels_28,
          t0_.status AS status_29,
          t0_.seo_title AS seo_title_30,
          t0_.seo_description AS seo_description_31,
          t0_.seo_canonical AS seo_canonical_32,
          t0_.seo_indexed AS seo_indexed_33
        FROM
          training t0_
        WHERE
          t0_.category_id IN (?)
      ) dctrn_result_inner
    ORDER BY
      featured_on_search_7 DESC,
      updated_at_5 DESC
  ) dctrn_result
LIMIT
  7

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, featured_on_search_7, updated_at_5 FROM (SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33 FROM training t0_ WHERE t0_.category_id IN ('24')) dctrn_result_inner ORDER BY featured_on_search_7 DESC, updated_at_5 DESC) dctrn_result LIMIT 7;

SELECT
  t0_.id AS id_0,
  t0_.label AS label_1,
  t0_.slug AS slug_2,
  t0_.pdf_name AS pdf_name_3,
  t0_.pdf_mime_type AS pdf_mime_type_4,
  t0_.updated_at AS updated_at_5,
  t0_.show_on_home_page AS show_on_home_page_6,
  t0_.featured_on_search AS featured_on_search_7,
  t0_.price AS price_8,
  t0_.cpf AS cpf_9,
  t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10,
  t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11,
  t0_.individual_videoconference_hours AS individual_videoconference_hours_12,
  t0_.collective_videoconference_hours AS collective_videoconference_hours_13,
  t0_.elearning_hours AS elearning_hours_14,
  t0_.format AS format_15,
  t0_.description AS description_16,
  t0_.min_period AS min_period_17,
  t0_.max_period AS max_period_18,
  t0_.public AS public_19,
  t0_.prerequisites AS prerequisites_20,
  t0_.code AS code_21,
  t0_.face_to_face_hours_text AS face_to_face_hours_text_22,
  t0_.satisfaction_rate AS satisfaction_rate_23,
  t0_.cpf_link AS cpf_link_24,
  t0_.completion_rate AS completion_rate_25,
  t0_.slug_history AS slug_history_26,
  t0_.sub_title AS sub_title_27,
  t0_.pixels AS pixels_28,
  t0_.status AS status_29,
  t0_.seo_title AS seo_title_30,
  t0_.seo_description AS seo_description_31,
  t0_.seo_canonical AS seo_canonical_32,
  t0_.seo_indexed AS seo_indexed_33,
  t0_.certification_id AS certification_id_34,
  t0_.category_id AS category_id_35,
  t0_.created_by_id AS created_by_id_36
FROM
  training t0_
WHERE
  t0_.category_id IN (?)
  AND t0_.id IN (?, ?)
ORDER BY
  t0_.featured_on_search DESC,
  t0_.updated_at DESC

SELECT t0_.id AS id_0, t0_.label AS label_1, t0_.slug AS slug_2, t0_.pdf_name AS pdf_name_3, t0_.pdf_mime_type AS pdf_mime_type_4, t0_.updated_at AS updated_at_5, t0_.show_on_home_page AS show_on_home_page_6, t0_.featured_on_search AS featured_on_search_7, t0_.price AS price_8, t0_.cpf AS cpf_9, t0_.collective_face_to_face_hours AS collective_face_to_face_hours_10, t0_.individual_face_to_face_hours AS individual_face_to_face_hours_11, t0_.individual_videoconference_hours AS individual_videoconference_hours_12, t0_.collective_videoconference_hours AS collective_videoconference_hours_13, t0_.elearning_hours AS elearning_hours_14, t0_.format AS format_15, t0_.description AS description_16, t0_.min_period AS min_period_17, t0_.max_period AS max_period_18, t0_.public AS public_19, t0_.prerequisites AS prerequisites_20, t0_.code AS code_21, t0_.face_to_face_hours_text AS face_to_face_hours_text_22, t0_.satisfaction_rate AS satisfaction_rate_23, t0_.cpf_link AS cpf_link_24, t0_.completion_rate AS completion_rate_25, t0_.slug_history AS slug_history_26, t0_.sub_title AS sub_title_27, t0_.pixels AS pixels_28, t0_.status AS status_29, t0_.seo_title AS seo_title_30, t0_.seo_description AS seo_description_31, t0_.seo_canonical AS seo_canonical_32, t0_.seo_indexed AS seo_indexed_33, t0_.certification_id AS certification_id_34, t0_.category_id AS category_id_35, t0_.created_by_id AS created_by_id_36 FROM training t0_ WHERE t0_.category_id IN ('24') AND t0_.id IN (366, 209) ORDER BY t0_.featured_on_search DESC, t0_.updated_at DESC;