Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.privacy_statement AS privacy_statement_3,
  t0.privacy_statement_is_required AS privacy_statement_is_required_4,
  t0.privacy_statement_text AS privacy_statement_text_5,
  t0.`default` AS default_6,
  t0.fields AS fields_7,
  t0.open_form AS open_form_8,
  t0.captcha AS captcha_9,
  t0.external_vacancy_id AS external_vacancy_id_10,
  t0.external_id AS external_id_11,
  t0.external_reference AS external_reference_12,
  t0.external_hash AS external_hash_13
FROM
  applicant_form t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.privacy_statement AS privacy_statement_3, t0.privacy_statement_is_required AS privacy_statement_is_required_4, t0.privacy_statement_text AS privacy_statement_text_5, t0.`default` AS default_6, t0.fields AS fields_7, t0.open_form AS open_form_8, t0.captcha AS captcha_9, t0.external_vacancy_id AS external_vacancy_id_10, t0.external_id AS external_id_11, t0.external_reference AS external_reference_12, t0.external_hash AS external_hash_13 FROM applicant_form t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.insertion AS insertion_3,
  t0.last_name AS last_name_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.intl_phone AS intl_phone_7,
  t0.email AS email_8,
  t0.created_at AS created_at_9,
  t0.file_name AS file_name_10,
  t0.file_size AS file_size_11,
  t0.file_name_motivation AS file_name_motivation_12,
  t0.file_size_motivation AS file_size_motivation_13,
  t0.motivation AS motivation_14,
  t0.description AS description_15,
  t0.data AS data_16,
  t0.question_answer_data AS question_answer_data_17,
  t0.privacy_policy AS privacy_policy_18,
  t0.applicant_send_to_applicant_mail AS applicant_send_to_applicant_mail_19,
  t0.linkedin_profile_url AS linkedin_profile_url_20,
  t0.deleted_at AS deleted_at_21,
  t0.clone AS clone_22,
  t0.manual AS manual_23,
  t0.sent_at AS sent_at_24,
  t0.external_id AS external_id_25,
  t0.external_candidate_id AS external_candidate_id_26,
  t0.updated_at AS updated_at_27,
  t0.utm AS utm_28,
  t0.knockout_question_answers AS knockout_question_answers_29,
  t0.rejected_by_knockout AS rejected_by_knockout_30,
  t0.locale AS locale_31,
  t0.external_resume_id AS external_resume_id_32,
  t0.apply_url AS apply_url_33,
  t0.anonymized AS anonymized_34,
  t0.vacancy_id AS vacancy_id_35,
  t36.id AS id_37,
  t36.active AS active_38,
  t36.created AS created_39,
  t36.updated AS updated_40,
  t36.sort_date AS sort_date_41,
  t36.contact_person AS contact_person_42,
  t36.contact_person_phone AS contact_person_phone_43,
  t36.slug AS slug_44,
  t36.title AS title_45,
  t36.company_name AS company_name_46,
  t36.city AS city_47,
  t36.zipcode AS zipcode_48,
  t36.external_url AS external_url_49,
  t36.intro AS intro_50,
  t36.description AS description_51,
  t36.featured AS featured_52,
  t36.internal_vacancy AS internal_vacancy_53,
  t36.start_date AS start_date_54,
  t36.end_date AS end_date_55,
  t36.job_start_date AS job_start_date_56,
  t36.applicant_form_custom AS applicant_form_custom_57,
  t36.applicant_email AS applicant_email_58,
  t36.deleted AS deleted_59,
  t36.external_reference AS external_reference_60,
  t36.synced AS synced_61,
  t36.youtube AS youtube_62,
  t36.external_id AS external_id_63,
  t36.displayable_external_id AS displayable_external_id_64,
  t36.master_vacancy AS master_vacancy_65,
  t36.country AS country_66,
  t36.salary_amount AS salary_amount_67,
  t36.salary_currency AS salary_currency_68,
  t36.min_salary_amount AS min_salary_amount_69,
  t36.min_salary_currency AS min_salary_currency_70,
  t36.max_salary_amount AS max_salary_amount_71,
  t36.max_salary_currency AS max_salary_currency_72,
  t36.custom_salary AS custom_salary_73,
  t36.redirect_count AS redirect_count_74,
  t36.province AS province_75,
  t36.company_information AS company_information_76,
  t36.has_more_info_button AS has_more_info_button_77,
  t36.owner_notified AS owner_notified_78,
  t36.`function` AS function_79,
  t36.external_detail_url AS external_detail_url_80,
  t36.google_for_job_mapping AS google_for_job_mapping_81,
  t36.salary_unit AS salary_unit_82,
  t36.department AS department_83,
  t36.google_cloud_name AS google_cloud_name_84,
  t36.address AS address_85,
  t36.latitude AS latitude_86,
  t36.longitude AS longitude_87,
  t36.external_hash AS external_hash_88,
  t36.meta_title AS meta_title_89,
  t36.meta_description AS meta_description_90,
  t36.utm_medium AS utm_medium_91,
  t36.utm_campaign AS utm_campaign_92,
  t36.detail_image_asset_id AS detail_image_asset_id_93,
  t36.overview_image_asset_id AS overview_image_asset_id_94,
  t36.hero_image_asset_id AS hero_image_asset_id_95,
  t36.company_id AS company_id_96,
  t36.recruiter_id AS recruiter_id_97,
  t36.main_icon_id AS main_icon_id_98,
  t36.usp_sub_title_id AS usp_sub_title_id_99,
  t36.description_form_id AS description_form_id_100,
  t36.applicant_form_id AS applicant_form_id_101,
  t36.custom_applicant_form_id AS custom_applicant_form_id_102,
  t36.invoice_id AS invoice_id_103,
  t36.template_id AS template_id_104,
  t36.company_logo_asset_id AS company_logo_asset_id_105,
  t36.multi_poster_id AS multi_poster_id_106,
  t36.primary_discipline_id AS primary_discipline_id_107,
  t36.secundary_discipline_id AS secundary_discipline_id_108,
  t36.harver_experience_id AS harver_experience_id_109,
  t36.application_process_id AS application_process_id_110,
  t36.domain_id AS domain_id_111,
  t36.calendar_id AS calendar_id_112,
  t36.gallery_id AS gallery_id_113,
  t36.og_image_id AS og_image_id_114,
  t36.site_id AS site_id_115,
  t0.status_id AS status_id_116,
  t0.manual_mail_id AS manual_mail_id_117,
  t0.gdpr_id AS gdpr_id_118,
  t0.company_id AS company_id_119,
  t0.applicant_form_id AS applicant_form_id_120
FROM
  applicant t0
  LEFT JOIN vacancy t36 ON t0.vacancy_id = t36.id
  AND (
    (t36.deleted IS NULL)
  )
WHERE
  t0.applicant_form_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.insertion AS insertion_3, t0.last_name AS last_name_4, t0.city AS city_5, t0.phone AS phone_6, t0.intl_phone AS intl_phone_7, t0.email AS email_8, t0.created_at AS created_at_9, t0.file_name AS file_name_10, t0.file_size AS file_size_11, t0.file_name_motivation AS file_name_motivation_12, t0.file_size_motivation AS file_size_motivation_13, t0.motivation AS motivation_14, t0.description AS description_15, t0.data AS data_16, t0.question_answer_data AS question_answer_data_17, t0.privacy_policy AS privacy_policy_18, t0.applicant_send_to_applicant_mail AS applicant_send_to_applicant_mail_19, t0.linkedin_profile_url AS linkedin_profile_url_20, t0.deleted_at AS deleted_at_21, t0.clone AS clone_22, t0.manual AS manual_23, t0.sent_at AS sent_at_24, t0.external_id AS external_id_25, t0.external_candidate_id AS external_candidate_id_26, t0.updated_at AS updated_at_27, t0.utm AS utm_28, t0.knockout_question_answers AS knockout_question_answers_29, t0.rejected_by_knockout AS rejected_by_knockout_30, t0.locale AS locale_31, t0.external_resume_id AS external_resume_id_32, t0.apply_url AS apply_url_33, t0.anonymized AS anonymized_34, t0.vacancy_id AS vacancy_id_35, t36.id AS id_37, t36.active AS active_38, t36.created AS created_39, t36.updated AS updated_40, t36.sort_date AS sort_date_41, t36.contact_person AS contact_person_42, t36.contact_person_phone AS contact_person_phone_43, t36.slug AS slug_44, t36.title AS title_45, t36.company_name AS company_name_46, t36.city AS city_47, t36.zipcode AS zipcode_48, t36.external_url AS external_url_49, t36.intro AS intro_50, t36.description AS description_51, t36.featured AS featured_52, t36.internal_vacancy AS internal_vacancy_53, t36.start_date AS start_date_54, t36.end_date AS end_date_55, t36.job_start_date AS job_start_date_56, t36.applicant_form_custom AS applicant_form_custom_57, t36.applicant_email AS applicant_email_58, t36.deleted AS deleted_59, t36.external_reference AS external_reference_60, t36.synced AS synced_61, t36.youtube AS youtube_62, t36.external_id AS external_id_63, t36.displayable_external_id AS displayable_external_id_64, t36.master_vacancy AS master_vacancy_65, t36.country AS country_66, t36.salary_amount AS salary_amount_67, t36.salary_currency AS salary_currency_68, t36.min_salary_amount AS min_salary_amount_69, t36.min_salary_currency AS min_salary_currency_70, t36.max_salary_amount AS max_salary_amount_71, t36.max_salary_currency AS max_salary_currency_72, t36.custom_salary AS custom_salary_73, t36.redirect_count AS redirect_count_74, t36.province AS province_75, t36.company_information AS company_information_76, t36.has_more_info_button AS has_more_info_button_77, t36.owner_notified AS owner_notified_78, t36.`function` AS function_79, t36.external_detail_url AS external_detail_url_80, t36.google_for_job_mapping AS google_for_job_mapping_81, t36.salary_unit AS salary_unit_82, t36.department AS department_83, t36.google_cloud_name AS google_cloud_name_84, t36.address AS address_85, t36.latitude AS latitude_86, t36.longitude AS longitude_87, t36.external_hash AS external_hash_88, t36.meta_title AS meta_title_89, t36.meta_description AS meta_description_90, t36.utm_medium AS utm_medium_91, t36.utm_campaign AS utm_campaign_92, t36.detail_image_asset_id AS detail_image_asset_id_93, t36.overview_image_asset_id AS overview_image_asset_id_94, t36.hero_image_asset_id AS hero_image_asset_id_95, t36.company_id AS company_id_96, t36.recruiter_id AS recruiter_id_97, t36.main_icon_id AS main_icon_id_98, t36.usp_sub_title_id AS usp_sub_title_id_99, t36.description_form_id AS description_form_id_100, t36.applicant_form_id AS applicant_form_id_101, t36.custom_applicant_form_id AS custom_applicant_form_id_102, t36.invoice_id AS invoice_id_103, t36.template_id AS template_id_104, t36.company_logo_asset_id AS company_logo_asset_id_105, t36.multi_poster_id AS multi_poster_id_106, t36.primary_discipline_id AS primary_discipline_id_107, t36.secundary_discipline_id AS secundary_discipline_id_108, t36.harver_experience_id AS harver_experience_id_109, t36.application_process_id AS application_process_id_110, t36.domain_id AS domain_id_111, t36.calendar_id AS calendar_id_112, t36.gallery_id AS gallery_id_113, t36.og_image_id AS og_image_id_114, t36.site_id AS site_id_115, t0.status_id AS status_id_116, t0.manual_mail_id AS manual_mail_id_117, t0.gdpr_id AS gdpr_id_118, t0.company_id AS company_id_119, t0.applicant_form_id AS applicant_form_id_120 FROM applicant t0 LEFT JOIN vacancy t36 ON t0.vacancy_id = t36.id AND ((t36.deleted IS NULL)) WHERE t0.applicant_form_id = 2 AND ((t0.deleted_at IS NULL));

SELECT
  t0.name AS name_1,
  t0.section AS section_2,
  t0.value AS value_3,
  t0.type AS type_4
FROM
  configuration_setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.section AS section_2, t0.value AS value_3, t0.type AS type_4 FROM configuration_setting t0 WHERE t0.name = 'site_vacancy_mobile_open_application_form' LIMIT 1;

SELECT
  f0_.name AS name_0,
  f0_.active AS active_1
FROM
  feature f0_

SELECT f0_.name AS name_0, f0_.active AS active_1 FROM feature f0_;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.privacy_statement AS privacy_statement_3,
  t0.privacy_statement_is_required AS privacy_statement_is_required_4,
  t0.privacy_statement_text AS privacy_statement_text_5,
  t0.`default` AS default_6,
  t0.fields AS fields_7,
  t0.open_form AS open_form_8,
  t0.captcha AS captcha_9,
  t0.external_vacancy_id AS external_vacancy_id_10,
  t0.external_id AS external_id_11,
  t0.external_reference AS external_reference_12,
  t0.external_hash AS external_hash_13
FROM
  applicant_form t0
WHERE
  t0.open_form = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.privacy_statement AS privacy_statement_3, t0.privacy_statement_is_required AS privacy_statement_is_required_4, t0.privacy_statement_text AS privacy_statement_text_5, t0.`default` AS default_6, t0.fields AS fields_7, t0.open_form AS open_form_8, t0.captcha AS captcha_9, t0.external_vacancy_id AS external_vacancy_id_10, t0.external_id AS external_id_11, t0.external_reference AS external_reference_12, t0.external_hash AS external_hash_13 FROM applicant_form t0 WHERE t0.open_form = 1 LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  g0_.id AS id_0,
  g0_.title AS title_1,
  g0_.location AS location_2,
  g0_.script AS script_3,
  g0_.type AS type_4
FROM
  google_tag_manager g0_
WHERE
  g0_.type = ?

SELECT g0_.id AS id_0, g0_.title AS title_1, g0_.location AS location_2, g0_.script AS script_3, g0_.type AS type_4 FROM google_tag_manager g0_ WHERE g0_.type = 'script';