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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.activity_area_more AS activity_area_more_4,
  t0.head_office_address AS head_office_address_5,
  t0.head_office_zipcode AS head_office_zipcode_6,
  t0.head_office_city AS head_office_city_7,
  t0.head_office_country AS head_office_country_8,
  t0.nb_employees AS nb_employees_9,
  t0.logo AS logo_10,
  t0.website_url AS website_url_11,
  t0.perimeter AS perimeter_12,
  t0.skills AS skills_13,
  t0.partner AS partner_14,
  t0.partner_itdlc AS partner_itdlc_15,
  t0.partner_pee AS partner_pee_16,
  t0.partner_foundation AS partner_foundation_17,
  t0.slug AS slug_18,
  t0.max_published_pee AS max_published_pee_19,
  t0.count_pee_subscription_came AS count_pee_subscription_came_20,
  t0.count_speaker AS count_speaker_21,
  t0.count_itdlc_archived AS count_itdlc_archived_22,
  t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23,
  t0.count_itdlc_archived_children AS count_itdlc_archived_children_24,
  t0.count_company_location AS count_company_location_25,
  t0.company_idv1 AS company_idv1_26,
  t0.other_activity_area AS other_activity_area_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.idv1 AS idv1_30,
  t0.comment AS comment_31,
  t0.activity_area_id AS activity_area_id_32,
  t0.academy_id AS academy_id_33,
  t0.corporation_id AS corporation_id_34,
  t0.created_by AS created_by_35,
  t0.updated_by AS updated_by_36
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.activity_area_more AS activity_area_more_4, t0.head_office_address AS head_office_address_5, t0.head_office_zipcode AS head_office_zipcode_6, t0.head_office_city AS head_office_city_7, t0.head_office_country AS head_office_country_8, t0.nb_employees AS nb_employees_9, t0.logo AS logo_10, t0.website_url AS website_url_11, t0.perimeter AS perimeter_12, t0.skills AS skills_13, t0.partner AS partner_14, t0.partner_itdlc AS partner_itdlc_15, t0.partner_pee AS partner_pee_16, t0.partner_foundation AS partner_foundation_17, t0.slug AS slug_18, t0.max_published_pee AS max_published_pee_19, t0.count_pee_subscription_came AS count_pee_subscription_came_20, t0.count_speaker AS count_speaker_21, t0.count_itdlc_archived AS count_itdlc_archived_22, t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23, t0.count_itdlc_archived_children AS count_itdlc_archived_children_24, t0.count_company_location AS count_company_location_25, t0.company_idv1 AS company_idv1_26, t0.other_activity_area AS other_activity_area_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.idv1 AS idv1_30, t0.comment AS comment_31, t0.activity_area_id AS activity_area_id_32, t0.academy_id AS academy_id_33, t0.corporation_id AS corporation_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM company t0 WHERE t0.id = 552;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.activity_area_more AS activity_area_more_4,
  t0.head_office_address AS head_office_address_5,
  t0.head_office_zipcode AS head_office_zipcode_6,
  t0.head_office_city AS head_office_city_7,
  t0.head_office_country AS head_office_country_8,
  t0.nb_employees AS nb_employees_9,
  t0.logo AS logo_10,
  t0.website_url AS website_url_11,
  t0.perimeter AS perimeter_12,
  t0.skills AS skills_13,
  t0.partner AS partner_14,
  t0.partner_itdlc AS partner_itdlc_15,
  t0.partner_pee AS partner_pee_16,
  t0.partner_foundation AS partner_foundation_17,
  t0.slug AS slug_18,
  t0.max_published_pee AS max_published_pee_19,
  t0.count_pee_subscription_came AS count_pee_subscription_came_20,
  t0.count_speaker AS count_speaker_21,
  t0.count_itdlc_archived AS count_itdlc_archived_22,
  t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23,
  t0.count_itdlc_archived_children AS count_itdlc_archived_children_24,
  t0.count_company_location AS count_company_location_25,
  t0.company_idv1 AS company_idv1_26,
  t0.other_activity_area AS other_activity_area_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.idv1 AS idv1_30,
  t0.comment AS comment_31,
  t0.activity_area_id AS activity_area_id_32,
  t0.academy_id AS academy_id_33,
  t0.corporation_id AS corporation_id_34,
  t0.created_by AS created_by_35,
  t0.updated_by AS updated_by_36
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.activity_area_more AS activity_area_more_4, t0.head_office_address AS head_office_address_5, t0.head_office_zipcode AS head_office_zipcode_6, t0.head_office_city AS head_office_city_7, t0.head_office_country AS head_office_country_8, t0.nb_employees AS nb_employees_9, t0.logo AS logo_10, t0.website_url AS website_url_11, t0.perimeter AS perimeter_12, t0.skills AS skills_13, t0.partner AS partner_14, t0.partner_itdlc AS partner_itdlc_15, t0.partner_pee AS partner_pee_16, t0.partner_foundation AS partner_foundation_17, t0.slug AS slug_18, t0.max_published_pee AS max_published_pee_19, t0.count_pee_subscription_came AS count_pee_subscription_came_20, t0.count_speaker AS count_speaker_21, t0.count_itdlc_archived AS count_itdlc_archived_22, t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23, t0.count_itdlc_archived_children AS count_itdlc_archived_children_24, t0.count_company_location AS count_company_location_25, t0.company_idv1 AS company_idv1_26, t0.other_activity_area AS other_activity_area_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.idv1 AS idv1_30, t0.comment AS comment_31, t0.activity_area_id AS activity_area_id_32, t0.academy_id AS academy_id_33, t0.corporation_id AS corporation_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM company t0 WHERE t0.id = 485;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.activity_area_more AS activity_area_more_4,
  t0.head_office_address AS head_office_address_5,
  t0.head_office_zipcode AS head_office_zipcode_6,
  t0.head_office_city AS head_office_city_7,
  t0.head_office_country AS head_office_country_8,
  t0.nb_employees AS nb_employees_9,
  t0.logo AS logo_10,
  t0.website_url AS website_url_11,
  t0.perimeter AS perimeter_12,
  t0.skills AS skills_13,
  t0.partner AS partner_14,
  t0.partner_itdlc AS partner_itdlc_15,
  t0.partner_pee AS partner_pee_16,
  t0.partner_foundation AS partner_foundation_17,
  t0.slug AS slug_18,
  t0.max_published_pee AS max_published_pee_19,
  t0.count_pee_subscription_came AS count_pee_subscription_came_20,
  t0.count_speaker AS count_speaker_21,
  t0.count_itdlc_archived AS count_itdlc_archived_22,
  t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23,
  t0.count_itdlc_archived_children AS count_itdlc_archived_children_24,
  t0.count_company_location AS count_company_location_25,
  t0.company_idv1 AS company_idv1_26,
  t0.other_activity_area AS other_activity_area_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.idv1 AS idv1_30,
  t0.comment AS comment_31,
  t0.activity_area_id AS activity_area_id_32,
  t0.academy_id AS academy_id_33,
  t0.corporation_id AS corporation_id_34,
  t0.created_by AS created_by_35,
  t0.updated_by AS updated_by_36
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.activity_area_more AS activity_area_more_4, t0.head_office_address AS head_office_address_5, t0.head_office_zipcode AS head_office_zipcode_6, t0.head_office_city AS head_office_city_7, t0.head_office_country AS head_office_country_8, t0.nb_employees AS nb_employees_9, t0.logo AS logo_10, t0.website_url AS website_url_11, t0.perimeter AS perimeter_12, t0.skills AS skills_13, t0.partner AS partner_14, t0.partner_itdlc AS partner_itdlc_15, t0.partner_pee AS partner_pee_16, t0.partner_foundation AS partner_foundation_17, t0.slug AS slug_18, t0.max_published_pee AS max_published_pee_19, t0.count_pee_subscription_came AS count_pee_subscription_came_20, t0.count_speaker AS count_speaker_21, t0.count_itdlc_archived AS count_itdlc_archived_22, t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23, t0.count_itdlc_archived_children AS count_itdlc_archived_children_24, t0.count_company_location AS count_company_location_25, t0.company_idv1 AS company_idv1_26, t0.other_activity_area AS other_activity_area_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.idv1 AS idv1_30, t0.comment AS comment_31, t0.activity_area_id AS activity_area_id_32, t0.academy_id AS academy_id_33, t0.corporation_id AS corporation_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM company t0 WHERE t0.id = 346;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.activity_area_more AS activity_area_more_4,
  t0.head_office_address AS head_office_address_5,
  t0.head_office_zipcode AS head_office_zipcode_6,
  t0.head_office_city AS head_office_city_7,
  t0.head_office_country AS head_office_country_8,
  t0.nb_employees AS nb_employees_9,
  t0.logo AS logo_10,
  t0.website_url AS website_url_11,
  t0.perimeter AS perimeter_12,
  t0.skills AS skills_13,
  t0.partner AS partner_14,
  t0.partner_itdlc AS partner_itdlc_15,
  t0.partner_pee AS partner_pee_16,
  t0.partner_foundation AS partner_foundation_17,
  t0.slug AS slug_18,
  t0.max_published_pee AS max_published_pee_19,
  t0.count_pee_subscription_came AS count_pee_subscription_came_20,
  t0.count_speaker AS count_speaker_21,
  t0.count_itdlc_archived AS count_itdlc_archived_22,
  t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23,
  t0.count_itdlc_archived_children AS count_itdlc_archived_children_24,
  t0.count_company_location AS count_company_location_25,
  t0.company_idv1 AS company_idv1_26,
  t0.other_activity_area AS other_activity_area_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.idv1 AS idv1_30,
  t0.comment AS comment_31,
  t0.activity_area_id AS activity_area_id_32,
  t0.academy_id AS academy_id_33,
  t0.corporation_id AS corporation_id_34,
  t0.created_by AS created_by_35,
  t0.updated_by AS updated_by_36
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.activity_area_more AS activity_area_more_4, t0.head_office_address AS head_office_address_5, t0.head_office_zipcode AS head_office_zipcode_6, t0.head_office_city AS head_office_city_7, t0.head_office_country AS head_office_country_8, t0.nb_employees AS nb_employees_9, t0.logo AS logo_10, t0.website_url AS website_url_11, t0.perimeter AS perimeter_12, t0.skills AS skills_13, t0.partner AS partner_14, t0.partner_itdlc AS partner_itdlc_15, t0.partner_pee AS partner_pee_16, t0.partner_foundation AS partner_foundation_17, t0.slug AS slug_18, t0.max_published_pee AS max_published_pee_19, t0.count_pee_subscription_came AS count_pee_subscription_came_20, t0.count_speaker AS count_speaker_21, t0.count_itdlc_archived AS count_itdlc_archived_22, t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23, t0.count_itdlc_archived_children AS count_itdlc_archived_children_24, t0.count_company_location AS count_company_location_25, t0.company_idv1 AS company_idv1_26, t0.other_activity_area AS other_activity_area_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.idv1 AS idv1_30, t0.comment AS comment_31, t0.activity_area_id AS activity_area_id_32, t0.academy_id AS academy_id_33, t0.corporation_id AS corporation_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM company t0 WHERE t0.id = 279;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.activity_area_more AS activity_area_more_4,
  t0.head_office_address AS head_office_address_5,
  t0.head_office_zipcode AS head_office_zipcode_6,
  t0.head_office_city AS head_office_city_7,
  t0.head_office_country AS head_office_country_8,
  t0.nb_employees AS nb_employees_9,
  t0.logo AS logo_10,
  t0.website_url AS website_url_11,
  t0.perimeter AS perimeter_12,
  t0.skills AS skills_13,
  t0.partner AS partner_14,
  t0.partner_itdlc AS partner_itdlc_15,
  t0.partner_pee AS partner_pee_16,
  t0.partner_foundation AS partner_foundation_17,
  t0.slug AS slug_18,
  t0.max_published_pee AS max_published_pee_19,
  t0.count_pee_subscription_came AS count_pee_subscription_came_20,
  t0.count_speaker AS count_speaker_21,
  t0.count_itdlc_archived AS count_itdlc_archived_22,
  t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23,
  t0.count_itdlc_archived_children AS count_itdlc_archived_children_24,
  t0.count_company_location AS count_company_location_25,
  t0.company_idv1 AS company_idv1_26,
  t0.other_activity_area AS other_activity_area_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.idv1 AS idv1_30,
  t0.comment AS comment_31,
  t0.activity_area_id AS activity_area_id_32,
  t0.academy_id AS academy_id_33,
  t0.corporation_id AS corporation_id_34,
  t0.created_by AS created_by_35,
  t0.updated_by AS updated_by_36
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.activity_area_more AS activity_area_more_4, t0.head_office_address AS head_office_address_5, t0.head_office_zipcode AS head_office_zipcode_6, t0.head_office_city AS head_office_city_7, t0.head_office_country AS head_office_country_8, t0.nb_employees AS nb_employees_9, t0.logo AS logo_10, t0.website_url AS website_url_11, t0.perimeter AS perimeter_12, t0.skills AS skills_13, t0.partner AS partner_14, t0.partner_itdlc AS partner_itdlc_15, t0.partner_pee AS partner_pee_16, t0.partner_foundation AS partner_foundation_17, t0.slug AS slug_18, t0.max_published_pee AS max_published_pee_19, t0.count_pee_subscription_came AS count_pee_subscription_came_20, t0.count_speaker AS count_speaker_21, t0.count_itdlc_archived AS count_itdlc_archived_22, t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23, t0.count_itdlc_archived_children AS count_itdlc_archived_children_24, t0.count_company_location AS count_company_location_25, t0.company_idv1 AS company_idv1_26, t0.other_activity_area AS other_activity_area_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.idv1 AS idv1_30, t0.comment AS comment_31, t0.activity_area_id AS activity_area_id_32, t0.academy_id AS academy_id_33, t0.corporation_id AS corporation_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM company t0 WHERE t0.id = 422;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.activity_area_more AS activity_area_more_4,
  t0.head_office_address AS head_office_address_5,
  t0.head_office_zipcode AS head_office_zipcode_6,
  t0.head_office_city AS head_office_city_7,
  t0.head_office_country AS head_office_country_8,
  t0.nb_employees AS nb_employees_9,
  t0.logo AS logo_10,
  t0.website_url AS website_url_11,
  t0.perimeter AS perimeter_12,
  t0.skills AS skills_13,
  t0.partner AS partner_14,
  t0.partner_itdlc AS partner_itdlc_15,
  t0.partner_pee AS partner_pee_16,
  t0.partner_foundation AS partner_foundation_17,
  t0.slug AS slug_18,
  t0.max_published_pee AS max_published_pee_19,
  t0.count_pee_subscription_came AS count_pee_subscription_came_20,
  t0.count_speaker AS count_speaker_21,
  t0.count_itdlc_archived AS count_itdlc_archived_22,
  t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23,
  t0.count_itdlc_archived_children AS count_itdlc_archived_children_24,
  t0.count_company_location AS count_company_location_25,
  t0.company_idv1 AS company_idv1_26,
  t0.other_activity_area AS other_activity_area_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.idv1 AS idv1_30,
  t0.comment AS comment_31,
  t0.activity_area_id AS activity_area_id_32,
  t0.academy_id AS academy_id_33,
  t0.corporation_id AS corporation_id_34,
  t0.created_by AS created_by_35,
  t0.updated_by AS updated_by_36
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.activity_area_more AS activity_area_more_4, t0.head_office_address AS head_office_address_5, t0.head_office_zipcode AS head_office_zipcode_6, t0.head_office_city AS head_office_city_7, t0.head_office_country AS head_office_country_8, t0.nb_employees AS nb_employees_9, t0.logo AS logo_10, t0.website_url AS website_url_11, t0.perimeter AS perimeter_12, t0.skills AS skills_13, t0.partner AS partner_14, t0.partner_itdlc AS partner_itdlc_15, t0.partner_pee AS partner_pee_16, t0.partner_foundation AS partner_foundation_17, t0.slug AS slug_18, t0.max_published_pee AS max_published_pee_19, t0.count_pee_subscription_came AS count_pee_subscription_came_20, t0.count_speaker AS count_speaker_21, t0.count_itdlc_archived AS count_itdlc_archived_22, t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23, t0.count_itdlc_archived_children AS count_itdlc_archived_children_24, t0.count_company_location AS count_company_location_25, t0.company_idv1 AS company_idv1_26, t0.other_activity_area AS other_activity_area_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.idv1 AS idv1_30, t0.comment AS comment_31, t0.activity_area_id AS activity_area_id_32, t0.academy_id AS academy_id_33, t0.corporation_id AS corporation_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM company t0 WHERE t0.id = 909;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.activity_area_more AS activity_area_more_4,
  t0.head_office_address AS head_office_address_5,
  t0.head_office_zipcode AS head_office_zipcode_6,
  t0.head_office_city AS head_office_city_7,
  t0.head_office_country AS head_office_country_8,
  t0.nb_employees AS nb_employees_9,
  t0.logo AS logo_10,
  t0.website_url AS website_url_11,
  t0.perimeter AS perimeter_12,
  t0.skills AS skills_13,
  t0.partner AS partner_14,
  t0.partner_itdlc AS partner_itdlc_15,
  t0.partner_pee AS partner_pee_16,
  t0.partner_foundation AS partner_foundation_17,
  t0.slug AS slug_18,
  t0.max_published_pee AS max_published_pee_19,
  t0.count_pee_subscription_came AS count_pee_subscription_came_20,
  t0.count_speaker AS count_speaker_21,
  t0.count_itdlc_archived AS count_itdlc_archived_22,
  t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23,
  t0.count_itdlc_archived_children AS count_itdlc_archived_children_24,
  t0.count_company_location AS count_company_location_25,
  t0.company_idv1 AS company_idv1_26,
  t0.other_activity_area AS other_activity_area_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.idv1 AS idv1_30,
  t0.comment AS comment_31,
  t0.activity_area_id AS activity_area_id_32,
  t0.academy_id AS academy_id_33,
  t0.corporation_id AS corporation_id_34,
  t0.created_by AS created_by_35,
  t0.updated_by AS updated_by_36
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.activity_area_more AS activity_area_more_4, t0.head_office_address AS head_office_address_5, t0.head_office_zipcode AS head_office_zipcode_6, t0.head_office_city AS head_office_city_7, t0.head_office_country AS head_office_country_8, t0.nb_employees AS nb_employees_9, t0.logo AS logo_10, t0.website_url AS website_url_11, t0.perimeter AS perimeter_12, t0.skills AS skills_13, t0.partner AS partner_14, t0.partner_itdlc AS partner_itdlc_15, t0.partner_pee AS partner_pee_16, t0.partner_foundation AS partner_foundation_17, t0.slug AS slug_18, t0.max_published_pee AS max_published_pee_19, t0.count_pee_subscription_came AS count_pee_subscription_came_20, t0.count_speaker AS count_speaker_21, t0.count_itdlc_archived AS count_itdlc_archived_22, t0.count_itdlc_aborted_by_speaker AS count_itdlc_aborted_by_speaker_23, t0.count_itdlc_archived_children AS count_itdlc_archived_children_24, t0.count_company_location AS count_company_location_25, t0.company_idv1 AS company_idv1_26, t0.other_activity_area AS other_activity_area_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.idv1 AS idv1_30, t0.comment AS comment_31, t0.activity_area_id AS activity_area_id_32, t0.academy_id AS academy_id_33, t0.corporation_id AS corporation_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36 FROM company t0 WHERE t0.id = 292;