Symfony Profiler

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

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 WHERE t0.id = '14';

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_
          INNER JOIN training_place t2_ ON t0_.id = t2_.training_id
          INNER JOIN place p1_ ON p1_.id = t2_.place_id
          AND (
            p1_.id IN (?)
          )
        ORDER BY
          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_ INNER JOIN training_place t2_ ON t0_.id = t2_.training_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (14)) ORDER BY t0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      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,
          p1_.id AS id_34,
          p1_.slug AS slug_35,
          p1_.address AS address_36,
          p1_.zip_code AS zip_code_37,
          p1_.city AS city_38,
          p1_.image_name AS image_name_39,
          p1_.updated_at AS updated_at_40,
          p1_.phone_number AS phone_number_41,
          p1_.information AS information_42,
          p1_.amenities AS amenities_43,
          p1_.google_map_link AS google_map_link_44
        FROM
          training t0_
          INNER JOIN training_place t2_ ON t0_.id = t2_.training_id
          INNER JOIN place p1_ ON p1_.id = t2_.place_id
          AND (
            p1_.id IN (?)
          )
      ) dctrn_result_inner
    ORDER BY
      updated_at_5 DESC
  ) dctrn_result
LIMIT
  7

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, 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, p1_.id AS id_34, p1_.slug AS slug_35, p1_.address AS address_36, p1_.zip_code AS zip_code_37, p1_.city AS city_38, p1_.image_name AS image_name_39, p1_.updated_at AS updated_at_40, p1_.phone_number AS phone_number_41, p1_.information AS information_42, p1_.amenities AS amenities_43, p1_.google_map_link AS google_map_link_44 FROM training t0_ INNER JOIN training_place t2_ ON t0_.id = t2_.training_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (14))) dctrn_result_inner ORDER BY 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_
  INNER JOIN training_place t2_ ON t0_.id = t2_.training_id
  INNER JOIN place p1_ ON p1_.id = t2_.place_id
  AND (
    p1_.id IN (?)
  )
WHERE
  t0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  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_ INNER JOIN training_place t2_ ON t0_.id = t2_.training_id INNER JOIN place p1_ ON p1_.id = t2_.place_id AND (p1_.id IN (14)) WHERE t0_.id IN (38, 247, 226, 381, 70, 228, 376) ORDER BY t0_.updated_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 46;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 48;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 47;