Symfony Profiler

SELECT
  ST_AsText(a0_.position) AS position_0,
  c1_.name AS name_1,
  p2_.id AS id_2,
  p2_.type AS type_3,
  p2_.occure_at AS occure_at_4,
  p2_.start_at AS start_at_5,
  p2_.finish_at AS finish_at_6,
  p2_.subscription_finish_at AS subscription_finish_at_7,
  p2_.subscription_finish_at_time AS subscription_finish_at_time_8,
  p2_.subscribers_min AS subscribers_min_9,
  p2_.subscribers_max AS subscribers_max_10,
  p2_.validation_type AS validation_type_11,
  p2_.speaker_profil_fields AS speaker_profil_fields_12,
  p2_.subscriber_profil_fields AS subscriber_profil_fields_13,
  p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14,
  p2_.visit_name AS visit_name_15,
  p2_.webinar_name AS webinar_name_16,
  p2_.download_file_mimes AS download_file_mimes_17,
  p2_.steps AS steps_18,
  p2_.company_location_steps AS company_location_steps_19,
  p2_.technical_work_shop_step AS technical_work_shop_step_20,
  p2_.commitment AS commitment_21,
  p2_.instructions AS instructions_22,
  p2_.accessibility AS accessibility_23,
  p2_.accessibility_more AS accessibility_more_24,
  p2_.more_informations AS more_informations_25,
  p2_.has_public_transport AS has_public_transport_26,
  p2_.public_transport_information AS public_transport_information_27,
  p2_.access_information AS access_information_28,
  p2_.access_map AS access_map_29,
  p2_.parking_informations AS parking_informations_30,
  p2_.required_documents AS required_documents_31,
  p2_.delay_before_starting AS delay_before_starting_32,
  p2_.cefpep_available AS cefpep_available_33,
  p2_.cefpep_name AS cefpep_name_34,
  p2_.cefpep_uid AS cefpep_uid_35,
  p2_.module_name AS module_name_36,
  p2_.module_number AS module_number_37,
  p2_.paf_name AS paf_name_38,
  p2_.paf_uid AS paf_uid_39,
  p2_.paf_available AS paf_available_40,
  p2_.paf_information AS paf_information_41,
  p2_.paf_limit_date AS paf_limit_date_42,
  p2_.paf_url AS paf_url_43,
  p2_.visio_platform AS visio_platform_44,
  p2_.visio_platform_other AS visio_platform_other_45,
  p2_.visio_link AS visio_link_46,
  p2_.visio_instruction AS visio_instruction_47,
  p2_.contact_title AS contact_title_48,
  p2_.contact_firstname AS contact_firstname_49,
  p2_.contact_lastname AS contact_lastname_50,
  p2_.contact_email AS contact_email_51,
  p2_.contact_phone AS contact_phone_52,
  p2_.event_hidden AS event_hidden_53,
  p2_.review_status AS review_status_54,
  p2_.abort_reason AS abort_reason_55,
  p2_.created_at AS created_at_56,
  p2_.updated_at AS updated_at_57,
  p2_.status AS status_58,
  p2_.comment AS comment_59,
  c1_.id AS id_60,
  c1_.name AS name_61,
  c1_.status AS status_62,
  c1_.activity_area_more AS activity_area_more_63,
  c1_.information AS information_64,
  c1_.count_active_speaker AS count_active_speaker_65,
  c1_.count_speaker AS count_speaker_66,
  c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67,
  c1_.count_itdlc_archived AS count_itdlc_archived_68,
  c1_.count_itdlc_students AS count_itdlc_students_69,
  c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70,
  c1_.other_activity_area AS other_activity_area_71,
  c1_.created_at AS created_at_72,
  c1_.updated_at AS updated_at_73,
  c1_.comment AS comment_74,
  c1_.idv1 AS idv1_75,
  a0_.id AS id_76,
  a0_.address AS address_77,
  a0_.address_more AS address_more_78,
  a0_.zipcode AS zipcode_79,
  a0_.zipcode_cleaned AS zipcode_cleaned_80,
  a0_.city AS city_81,
  a0_.country AS country_82,
  ST_AsText(a0_.position) AS position_83,
  a0_.name AS name_84,
  a0_.type AS type_85,
  a0_.code_insee AS code_insee_86,
  r3_.id AS id_87,
  r3_.filename AS filename_88,
  r3_.title AS title_89,
  r3_.copyright AS copyright_90,
  r3_.description AS description_91,
  r3_.created_at AS created_at_92,
  r3_.updated_at AS updated_at_93,
  p2_.company_location_id AS company_location_id_94,
  p2_.activity_area_id AS activity_area_id_95,
  p2_.brand_label_id AS brand_label_id_96,
  p2_.created_by AS created_by_97,
  p2_.updated_by AS updated_by_98,
  c1_.company_id AS company_id_99,
  c1_.activity_area_id AS activity_area_id_100,
  c1_.address_id AS address_id_101,
  c1_.organisation AS organisation_102,
  c1_.created_by AS created_by_103,
  c1_.updated_by AS updated_by_104,
  a0_.academy_id AS academy_id_105,
  r3_.type AS type_106
FROM
  pee p2_
  INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id
  INNER JOIN address a0_ ON c1_.address_id = a0_.id
  LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id
  LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id
  AND r3_.type IN ('image')
WHERE
  p2_.status = ?
  AND p2_.event_hidden = ?
  AND p2_.finish_at - p2_.start_at <= MAKETIME(?, ?, 0)
ORDER BY
  p2_.occure_at ASC

SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') WHERE p2_.status = 'published' AND p2_.event_hidden = 0 AND p2_.finish_at - p2_.start_at <= MAKETIME(9,0,0) ORDER BY p2_.occure_at ASC;

SELECT
  w0_.id AS id_0,
  w0_.day AS day_1,
  w0_.half_day AS half_day_2
FROM
  week_item w0_

SELECT w0_.id AS id_0, w0_.day AS day_1, w0_.half_day AS half_day_2 FROM week_item w0_;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.region_code AS region_code_2,
  a0_.region_name AS region_name_3,
  a0_.departements AS departements_4,
  a0_.available AS available_5
FROM
  academy a0_
WHERE
  a0_.available = ?
  AND a0_.id IN (?)
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = 1 AND a0_.id IN ('') ORDER BY a0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.status AS status_2,
  c0_.activity_area_more AS activity_area_more_3,
  c0_.head_office_address AS head_office_address_4,
  c0_.head_office_zipcode AS head_office_zipcode_5,
  c0_.head_office_city AS head_office_city_6,
  c0_.head_office_country AS head_office_country_7,
  c0_.nb_employees AS nb_employees_8,
  c0_.logo AS logo_9,
  c0_.website_url AS website_url_10,
  c0_.perimeter AS perimeter_11,
  c0_.skills AS skills_12,
  c0_.partner AS partner_13,
  c0_.partner_itdlc AS partner_itdlc_14,
  c0_.partner_pee AS partner_pee_15,
  c0_.partner_foundation AS partner_foundation_16,
  c0_.slug AS slug_17,
  c0_.max_published_pee AS max_published_pee_18,
  c0_.count_pee_subscription_came AS count_pee_subscription_came_19,
  c0_.count_speaker AS count_speaker_20,
  c0_.count_itdlc_archived AS count_itdlc_archived_21,
  c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22,
  c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23,
  c0_.count_company_location AS count_company_location_24,
  c0_.company_idv1 AS company_idv1_25,
  c0_.other_activity_area AS other_activity_area_26,
  c0_.created_at AS created_at_27,
  c0_.updated_at AS updated_at_28,
  c0_.idv1 AS idv1_29,
  c0_.comment AS comment_30,
  c0_.activity_area_id AS activity_area_id_31,
  c0_.academy_id AS academy_id_32,
  c0_.corporation_id AS corporation_id_33,
  c0_.created_by AS created_by_34,
  c0_.updated_by AS updated_by_35
FROM
  company c0_
  INNER JOIN company_location c1_ ON c0_.id = c1_.company_id
  INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id
WHERE
  c0_.status = ?
  AND p2_.status = ?
  AND p2_.event_hidden = 0
  AND p2_.id IS NOT NULL
  AND c0_.id IN (?)
GROUP BY
  c0_.id
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = 'published' AND p2_.status = 'published' AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL AND c0_.id IN ('27') GROUP BY c0_.id ORDER BY c0_.name ASC;

SELECT
  ST_AsText(a0_.position) AS position_0,
  c1_.name AS name_1,
  p2_.id AS id_2,
  p2_.type AS type_3,
  p2_.occure_at AS occure_at_4,
  p2_.start_at AS start_at_5,
  p2_.finish_at AS finish_at_6,
  p2_.subscription_finish_at AS subscription_finish_at_7,
  p2_.subscription_finish_at_time AS subscription_finish_at_time_8,
  p2_.subscribers_min AS subscribers_min_9,
  p2_.subscribers_max AS subscribers_max_10,
  p2_.validation_type AS validation_type_11,
  p2_.speaker_profil_fields AS speaker_profil_fields_12,
  p2_.subscriber_profil_fields AS subscriber_profil_fields_13,
  p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14,
  p2_.visit_name AS visit_name_15,
  p2_.webinar_name AS webinar_name_16,
  p2_.download_file_mimes AS download_file_mimes_17,
  p2_.steps AS steps_18,
  p2_.company_location_steps AS company_location_steps_19,
  p2_.technical_work_shop_step AS technical_work_shop_step_20,
  p2_.commitment AS commitment_21,
  p2_.instructions AS instructions_22,
  p2_.accessibility AS accessibility_23,
  p2_.accessibility_more AS accessibility_more_24,
  p2_.more_informations AS more_informations_25,
  p2_.has_public_transport AS has_public_transport_26,
  p2_.public_transport_information AS public_transport_information_27,
  p2_.access_information AS access_information_28,
  p2_.access_map AS access_map_29,
  p2_.parking_informations AS parking_informations_30,
  p2_.required_documents AS required_documents_31,
  p2_.delay_before_starting AS delay_before_starting_32,
  p2_.cefpep_available AS cefpep_available_33,
  p2_.cefpep_name AS cefpep_name_34,
  p2_.cefpep_uid AS cefpep_uid_35,
  p2_.module_name AS module_name_36,
  p2_.module_number AS module_number_37,
  p2_.paf_name AS paf_name_38,
  p2_.paf_uid AS paf_uid_39,
  p2_.paf_available AS paf_available_40,
  p2_.paf_information AS paf_information_41,
  p2_.paf_limit_date AS paf_limit_date_42,
  p2_.paf_url AS paf_url_43,
  p2_.visio_platform AS visio_platform_44,
  p2_.visio_platform_other AS visio_platform_other_45,
  p2_.visio_link AS visio_link_46,
  p2_.visio_instruction AS visio_instruction_47,
  p2_.contact_title AS contact_title_48,
  p2_.contact_firstname AS contact_firstname_49,
  p2_.contact_lastname AS contact_lastname_50,
  p2_.contact_email AS contact_email_51,
  p2_.contact_phone AS contact_phone_52,
  p2_.event_hidden AS event_hidden_53,
  p2_.review_status AS review_status_54,
  p2_.abort_reason AS abort_reason_55,
  p2_.created_at AS created_at_56,
  p2_.updated_at AS updated_at_57,
  p2_.status AS status_58,
  p2_.comment AS comment_59,
  c1_.id AS id_60,
  c1_.name AS name_61,
  c1_.status AS status_62,
  c1_.activity_area_more AS activity_area_more_63,
  c1_.information AS information_64,
  c1_.count_active_speaker AS count_active_speaker_65,
  c1_.count_speaker AS count_speaker_66,
  c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67,
  c1_.count_itdlc_archived AS count_itdlc_archived_68,
  c1_.count_itdlc_students AS count_itdlc_students_69,
  c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70,
  c1_.other_activity_area AS other_activity_area_71,
  c1_.created_at AS created_at_72,
  c1_.updated_at AS updated_at_73,
  c1_.comment AS comment_74,
  c1_.idv1 AS idv1_75,
  a0_.id AS id_76,
  a0_.address AS address_77,
  a0_.address_more AS address_more_78,
  a0_.zipcode AS zipcode_79,
  a0_.zipcode_cleaned AS zipcode_cleaned_80,
  a0_.city AS city_81,
  a0_.country AS country_82,
  ST_AsText(a0_.position) AS position_83,
  a0_.name AS name_84,
  a0_.type AS type_85,
  a0_.code_insee AS code_insee_86,
  r3_.id AS id_87,
  r3_.filename AS filename_88,
  r3_.title AS title_89,
  r3_.copyright AS copyright_90,
  r3_.description AS description_91,
  r3_.created_at AS created_at_92,
  r3_.updated_at AS updated_at_93,
  p2_.company_location_id AS company_location_id_94,
  p2_.activity_area_id AS activity_area_id_95,
  p2_.brand_label_id AS brand_label_id_96,
  p2_.created_by AS created_by_97,
  p2_.updated_by AS updated_by_98,
  c1_.company_id AS company_id_99,
  c1_.activity_area_id AS activity_area_id_100,
  c1_.address_id AS address_id_101,
  c1_.organisation AS organisation_102,
  c1_.created_by AS created_by_103,
  c1_.updated_by AS updated_by_104,
  a0_.academy_id AS academy_id_105,
  r3_.type AS type_106
FROM
  pee p2_
  INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id
  INNER JOIN address a0_ ON c1_.address_id = a0_.id
  LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id
  LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id
  AND r3_.type IN ('image')
  INNER JOIN company c5_ ON c1_.company_id = c5_.id
WHERE
  p2_.status = ?
  AND p2_.event_hidden = ?
  AND c5_.id = ?
ORDER BY
  p2_.occure_at ASC

SELECT ST_AsText(a0_.position) AS position_0, c1_.name AS name_1, p2_.id AS id_2, p2_.type AS type_3, p2_.occure_at AS occure_at_4, p2_.start_at AS start_at_5, p2_.finish_at AS finish_at_6, p2_.subscription_finish_at AS subscription_finish_at_7, p2_.subscription_finish_at_time AS subscription_finish_at_time_8, p2_.subscribers_min AS subscribers_min_9, p2_.subscribers_max AS subscribers_max_10, p2_.validation_type AS validation_type_11, p2_.speaker_profil_fields AS speaker_profil_fields_12, p2_.subscriber_profil_fields AS subscriber_profil_fields_13, p2_.subscriber_profil_more_field_label AS subscriber_profil_more_field_label_14, p2_.visit_name AS visit_name_15, p2_.webinar_name AS webinar_name_16, p2_.download_file_mimes AS download_file_mimes_17, p2_.steps AS steps_18, p2_.company_location_steps AS company_location_steps_19, p2_.technical_work_shop_step AS technical_work_shop_step_20, p2_.commitment AS commitment_21, p2_.instructions AS instructions_22, p2_.accessibility AS accessibility_23, p2_.accessibility_more AS accessibility_more_24, p2_.more_informations AS more_informations_25, p2_.has_public_transport AS has_public_transport_26, p2_.public_transport_information AS public_transport_information_27, p2_.access_information AS access_information_28, p2_.access_map AS access_map_29, p2_.parking_informations AS parking_informations_30, p2_.required_documents AS required_documents_31, p2_.delay_before_starting AS delay_before_starting_32, p2_.cefpep_available AS cefpep_available_33, p2_.cefpep_name AS cefpep_name_34, p2_.cefpep_uid AS cefpep_uid_35, p2_.module_name AS module_name_36, p2_.module_number AS module_number_37, p2_.paf_name AS paf_name_38, p2_.paf_uid AS paf_uid_39, p2_.paf_available AS paf_available_40, p2_.paf_information AS paf_information_41, p2_.paf_limit_date AS paf_limit_date_42, p2_.paf_url AS paf_url_43, p2_.visio_platform AS visio_platform_44, p2_.visio_platform_other AS visio_platform_other_45, p2_.visio_link AS visio_link_46, p2_.visio_instruction AS visio_instruction_47, p2_.contact_title AS contact_title_48, p2_.contact_firstname AS contact_firstname_49, p2_.contact_lastname AS contact_lastname_50, p2_.contact_email AS contact_email_51, p2_.contact_phone AS contact_phone_52, p2_.event_hidden AS event_hidden_53, p2_.review_status AS review_status_54, p2_.abort_reason AS abort_reason_55, p2_.created_at AS created_at_56, p2_.updated_at AS updated_at_57, p2_.status AS status_58, p2_.comment AS comment_59, c1_.id AS id_60, c1_.name AS name_61, c1_.status AS status_62, c1_.activity_area_more AS activity_area_more_63, c1_.information AS information_64, c1_.count_active_speaker AS count_active_speaker_65, c1_.count_speaker AS count_speaker_66, c1_.count_itdlc_scheduled AS count_itdlc_scheduled_67, c1_.count_itdlc_archived AS count_itdlc_archived_68, c1_.count_itdlc_students AS count_itdlc_students_69, c1_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_70, c1_.other_activity_area AS other_activity_area_71, c1_.created_at AS created_at_72, c1_.updated_at AS updated_at_73, c1_.comment AS comment_74, c1_.idv1 AS idv1_75, a0_.id AS id_76, a0_.address AS address_77, a0_.address_more AS address_more_78, a0_.zipcode AS zipcode_79, a0_.zipcode_cleaned AS zipcode_cleaned_80, a0_.city AS city_81, a0_.country AS country_82, ST_AsText(a0_.position) AS position_83, a0_.name AS name_84, a0_.type AS type_85, a0_.code_insee AS code_insee_86, r3_.id AS id_87, r3_.filename AS filename_88, r3_.title AS title_89, r3_.copyright AS copyright_90, r3_.description AS description_91, r3_.created_at AS created_at_92, r3_.updated_at AS updated_at_93, p2_.company_location_id AS company_location_id_94, p2_.activity_area_id AS activity_area_id_95, p2_.brand_label_id AS brand_label_id_96, p2_.created_by AS created_by_97, p2_.updated_by AS updated_by_98, c1_.company_id AS company_id_99, c1_.activity_area_id AS activity_area_id_100, c1_.address_id AS address_id_101, c1_.organisation AS organisation_102, c1_.created_by AS created_by_103, c1_.updated_by AS updated_by_104, a0_.academy_id AS academy_id_105, r3_.type AS type_106 FROM pee p2_ INNER JOIN company_location c1_ ON p2_.company_location_id = c1_.id INNER JOIN address a0_ ON c1_.address_id = a0_.id LEFT JOIN company_location_image c4_ ON c1_.id = c4_.company_location_id LEFT JOIN resource_file r3_ ON r3_.id = c4_.image_id AND r3_.type IN ('image') INNER JOIN company c5_ ON c1_.company_id = c5_.id WHERE p2_.status = 'published' AND p2_.event_hidden = 0 AND c5_.id = 27 ORDER BY p2_.occure_at ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  activity_area t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM activity_area t0 WHERE t0.id = 29;

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1
FROM
  activity_area a0_

SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.region_code AS region_code_2,
  a0_.region_name AS region_name_3,
  a0_.departements AS departements_4,
  a0_.available AS available_5
FROM
  academy a0_
WHERE
  a0_.available = ?
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.region_code AS region_code_2, a0_.region_name AS region_name_3, a0_.departements AS departements_4, a0_.available AS available_5 FROM academy a0_ WHERE a0_.available = 1 ORDER BY a0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.status AS status_2,
  c0_.activity_area_more AS activity_area_more_3,
  c0_.head_office_address AS head_office_address_4,
  c0_.head_office_zipcode AS head_office_zipcode_5,
  c0_.head_office_city AS head_office_city_6,
  c0_.head_office_country AS head_office_country_7,
  c0_.nb_employees AS nb_employees_8,
  c0_.logo AS logo_9,
  c0_.website_url AS website_url_10,
  c0_.perimeter AS perimeter_11,
  c0_.skills AS skills_12,
  c0_.partner AS partner_13,
  c0_.partner_itdlc AS partner_itdlc_14,
  c0_.partner_pee AS partner_pee_15,
  c0_.partner_foundation AS partner_foundation_16,
  c0_.slug AS slug_17,
  c0_.max_published_pee AS max_published_pee_18,
  c0_.count_pee_subscription_came AS count_pee_subscription_came_19,
  c0_.count_speaker AS count_speaker_20,
  c0_.count_itdlc_archived AS count_itdlc_archived_21,
  c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22,
  c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23,
  c0_.count_company_location AS count_company_location_24,
  c0_.company_idv1 AS company_idv1_25,
  c0_.other_activity_area AS other_activity_area_26,
  c0_.created_at AS created_at_27,
  c0_.updated_at AS updated_at_28,
  c0_.idv1 AS idv1_29,
  c0_.comment AS comment_30,
  c0_.activity_area_id AS activity_area_id_31,
  c0_.academy_id AS academy_id_32,
  c0_.corporation_id AS corporation_id_33,
  c0_.created_by AS created_by_34,
  c0_.updated_by AS updated_by_35
FROM
  company c0_
  INNER JOIN company_location c1_ ON c0_.id = c1_.company_id
  INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id
WHERE
  c0_.status = ?
  AND p2_.status = ?
  AND p2_.event_hidden = 0
  AND p2_.id IS NOT NULL
GROUP BY
  c0_.id
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.status AS status_2, c0_.activity_area_more AS activity_area_more_3, c0_.head_office_address AS head_office_address_4, c0_.head_office_zipcode AS head_office_zipcode_5, c0_.head_office_city AS head_office_city_6, c0_.head_office_country AS head_office_country_7, c0_.nb_employees AS nb_employees_8, c0_.logo AS logo_9, c0_.website_url AS website_url_10, c0_.perimeter AS perimeter_11, c0_.skills AS skills_12, c0_.partner AS partner_13, c0_.partner_itdlc AS partner_itdlc_14, c0_.partner_pee AS partner_pee_15, c0_.partner_foundation AS partner_foundation_16, c0_.slug AS slug_17, c0_.max_published_pee AS max_published_pee_18, c0_.count_pee_subscription_came AS count_pee_subscription_came_19, c0_.count_speaker AS count_speaker_20, c0_.count_itdlc_archived AS count_itdlc_archived_21, c0_.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_22, c0_.count_itdlc_archived_children AS count_itdlc_archived_children_23, c0_.count_company_location AS count_company_location_24, c0_.company_idv1 AS company_idv1_25, c0_.other_activity_area AS other_activity_area_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c0_.idv1 AS idv1_29, c0_.comment AS comment_30, c0_.activity_area_id AS activity_area_id_31, c0_.academy_id AS academy_id_32, c0_.corporation_id AS corporation_id_33, c0_.created_by AS created_by_34, c0_.updated_by AS updated_by_35 FROM company c0_ INNER JOIN company_location c1_ ON c0_.id = c1_.company_id INNER JOIN pee p2_ ON c1_.id = p2_.company_location_id WHERE c0_.status = 'published' AND p2_.status = 'published' AND p2_.event_hidden = 0 AND p2_.id IS NOT NULL GROUP BY c0_.id ORDER BY c0_.name ASC;