Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.bic_id AS bic_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.is_scholastic_professsion AS is_scholastic_professsion_5,
  t0.lbrnr AS lbrnr_6,
  t0.mlbrnr AS mlbrnr_7,
  t0.operations_and_tasks AS operations_and_tasks_8,
  t0.self_employed AS self_employed_9,
  t0.bic_anforderungen AS bic_anforderungen_10,
  t0.bic_alternativen AS bic_alternativen_11,
  t0.bic_lehre_matura AS bic_lehre_matura_12,
  t0.bic_ausbildung_berufschule AS bic_ausbildung_berufschule_13,
  t0.bic_moeglichkeiten AS bic_moeglichkeiten_14,
  t0.update_at AS update_at_15,
  t0.show_school_subjects AS show_school_subjects_16,
  t0.job_image_id AS job_image_id_17,
  t18.id AS id_19,
  t18.filename AS filename_20,
  t18.job_id AS job_id_21,
  t18.file_path_id AS file_path_id_22,
  t0.job_teaser_image_id AS job_teaser_image_id_23,
  t0.job_gallery_id AS job_gallery_id_24,
  t25.id AS id_26,
  t25.ams_id AS ams_id_27,
  t25.created_at AS created_at_28,
  t25.job_id AS job_id_29,
  t0.job_scholastic_duration_id AS job_scholastic_duration_id_30
FROM
  job t0
  LEFT JOIN job_pdf t18 ON t18.job_id = t0.id
  LEFT JOIN job_salary t25 ON t25.job_id = t0.id
WHERE
  t0.bic_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.name AS name_3, t0.description AS description_4, t0.is_scholastic_professsion AS is_scholastic_professsion_5, t0.lbrnr AS lbrnr_6, t0.mlbrnr AS mlbrnr_7, t0.operations_and_tasks AS operations_and_tasks_8, t0.self_employed AS self_employed_9, t0.bic_anforderungen AS bic_anforderungen_10, t0.bic_alternativen AS bic_alternativen_11, t0.bic_lehre_matura AS bic_lehre_matura_12, t0.bic_ausbildung_berufschule AS bic_ausbildung_berufschule_13, t0.bic_moeglichkeiten AS bic_moeglichkeiten_14, t0.update_at AS update_at_15, t0.show_school_subjects AS show_school_subjects_16, t0.job_image_id AS job_image_id_17, t18.id AS id_19, t18.filename AS filename_20, t18.job_id AS job_id_21, t18.file_path_id AS file_path_id_22, t0.job_teaser_image_id AS job_teaser_image_id_23, t0.job_gallery_id AS job_gallery_id_24, t25.id AS id_26, t25.ams_id AS ams_id_27, t25.created_at AS created_at_28, t25.job_id AS job_id_29, t0.job_scholastic_duration_id AS job_scholastic_duration_id_30 FROM job t0 LEFT JOIN job_pdf t18 ON t18.job_id = t0.id LEFT JOIN job_salary t25 ON t25.job_id = t0.id WHERE t0.bic_id = '606' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.bic_id AS bic_id_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.is_scholastic_professsion AS is_scholastic_professsion_5,
  t0.lbrnr AS lbrnr_6,
  t0.mlbrnr AS mlbrnr_7,
  t0.operations_and_tasks AS operations_and_tasks_8,
  t0.self_employed AS self_employed_9,
  t0.bic_anforderungen AS bic_anforderungen_10,
  t0.bic_alternativen AS bic_alternativen_11,
  t0.bic_lehre_matura AS bic_lehre_matura_12,
  t0.bic_ausbildung_berufschule AS bic_ausbildung_berufschule_13,
  t0.bic_moeglichkeiten AS bic_moeglichkeiten_14,
  t0.update_at AS update_at_15,
  t0.show_school_subjects AS show_school_subjects_16,
  t0.job_image_id AS job_image_id_17,
  t18.id AS id_19,
  t18.filename AS filename_20,
  t18.job_id AS job_id_21,
  t18.file_path_id AS file_path_id_22,
  t0.job_teaser_image_id AS job_teaser_image_id_23,
  t0.job_gallery_id AS job_gallery_id_24,
  t25.id AS id_26,
  t25.ams_id AS ams_id_27,
  t25.created_at AS created_at_28,
  t25.job_id AS job_id_29,
  t0.job_scholastic_duration_id AS job_scholastic_duration_id_30
FROM
  job t0
  LEFT JOIN job_pdf t18 ON t18.job_id = t0.id
  LEFT JOIN job_salary t25 ON t25.job_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.name AS name_3, t0.description AS description_4, t0.is_scholastic_professsion AS is_scholastic_professsion_5, t0.lbrnr AS lbrnr_6, t0.mlbrnr AS mlbrnr_7, t0.operations_and_tasks AS operations_and_tasks_8, t0.self_employed AS self_employed_9, t0.bic_anforderungen AS bic_anforderungen_10, t0.bic_alternativen AS bic_alternativen_11, t0.bic_lehre_matura AS bic_lehre_matura_12, t0.bic_ausbildung_berufschule AS bic_ausbildung_berufschule_13, t0.bic_moeglichkeiten AS bic_moeglichkeiten_14, t0.update_at AS update_at_15, t0.show_school_subjects AS show_school_subjects_16, t0.job_image_id AS job_image_id_17, t18.id AS id_19, t18.filename AS filename_20, t18.job_id AS job_id_21, t18.file_path_id AS file_path_id_22, t0.job_teaser_image_id AS job_teaser_image_id_23, t0.job_gallery_id AS job_gallery_id_24, t25.id AS id_26, t25.ams_id AS ams_id_27, t25.created_at AS created_at_28, t25.job_id AS job_id_29, t0.job_scholastic_duration_id AS job_scholastic_duration_id_30 FROM job t0 LEFT JOIN job_pdf t18 ON t18.job_id = t0.id LEFT JOIN job_salary t25 ON t25.job_id = t0.id WHERE t0.id = 2042;

SELECT
  t0.id AS id_1,
  t0.bic_id AS bic_id_2,
  t0.requirement_name AS requirement_name_3,
  t0.description AS description_4,
  t0.modified_name AS modified_name_5,
  t0.modified_description AS modified_description_6,
  t0.job_requirement_type_id AS job_requirement_type_id_7
FROM
  job_requirement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.requirement_name AS requirement_name_3, t0.description AS description_4, t0.modified_name AS modified_name_5, t0.modified_description AS modified_description_6, t0.job_requirement_type_id AS job_requirement_type_id_7 FROM job_requirement t0 WHERE t0.id = 99;

SELECT
  t0.id AS id_1,
  t0.interest_name AS interest_name_2,
  t0.sub_heading AS sub_heading_3
FROM
  interest_field t0
  INNER JOIN job_interest_field_mapping ON t0.id = job_interest_field_mapping.interest_field_id
WHERE
  job_interest_field_mapping.job_id = ?

SELECT t0.id AS id_1, t0.interest_name AS interest_name_2, t0.sub_heading AS sub_heading_3 FROM interest_field t0 INNER JOIN job_interest_field_mapping ON t0.id = job_interest_field_mapping.interest_field_id WHERE job_interest_field_mapping.job_id = 463;

SELECT
  t0.id AS id_1,
  t0.bic_id AS bic_id_2,
  t0.term_name AS term_name_3,
  t0.description AS description_4
FROM
  job_expert_term t0
  INNER JOIN job_expert_term_mapping ON t0.id = job_expert_term_mapping.job_expert_term_id
WHERE
  job_expert_term_mapping.job_id = ?

SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.term_name AS term_name_3, t0.description AS description_4 FROM job_expert_term t0 INNER JOIN job_expert_term_mapping ON t0.id = job_expert_term_mapping.job_expert_term_id WHERE job_expert_term_mapping.job_id = 463;

SELECT
  t0.id AS id_1,
  t0.bic_id AS bic_id_2,
  t0.name AS name_3,
  t0.name_long AS name_long_4
FROM
  job_educational_path t0
  INNER JOIN job_educational_path_mapping ON t0.id = job_educational_path_mapping.job_educational_path_id
WHERE
  job_educational_path_mapping.job_id = ?

SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.name AS name_3, t0.name_long AS name_long_4 FROM job_educational_path t0 INNER JOIN job_educational_path_mapping ON t0.id = job_educational_path_mapping.job_educational_path_id WHERE job_educational_path_mapping.job_id = 463;

SELECT
  t0.id AS id_1,
  t0.bic_id AS bic_id_2,
  t0.name AS name_3,
  t0.default_image_name AS default_image_name_4,
  t0.description AS description_5,
  t0.sector_image_id AS sector_image_id_6
FROM
  job_sector t0
  INNER JOIN job_sector_mapping ON t0.id = job_sector_mapping.sector_id
WHERE
  job_sector_mapping.job_id = ?

SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.name AS name_3, t0.default_image_name AS default_image_name_4, t0.description AS description_5, t0.sector_image_id AS sector_image_id_6 FROM job_sector t0 INNER JOIN job_sector_mapping ON t0.id = job_sector_mapping.sector_id WHERE job_sector_mapping.job_id = 463;

SELECT
  t0.id AS id_1,
  t0.salary_from AS salary_from_2,
  t0.salary_to AS salary_to_3,
  t0.url_ext AS url_ext_4,
  t0.created_at AS created_at_5,
  t0.job_salary_id AS job_salary_id_6,
  t0.job_salary_type_id AS job_salary_type_id_7
FROM
  job_salary_entry t0
WHERE
  t0.job_salary_id = ?

SELECT t0.id AS id_1, t0.salary_from AS salary_from_2, t0.salary_to AS salary_to_3, t0.url_ext AS url_ext_4, t0.created_at AS created_at_5, t0.job_salary_id AS job_salary_id_6, t0.job_salary_type_id AS job_salary_type_id_7 FROM job_salary_entry t0 WHERE t0.job_salary_id = 1262;

SELECT
  j0_.id AS id_0,
  j0_.name AS name_1,
  j0_.number_of_positions AS number_of_positions_2,
  j0_.start_date AS start_date_3,
  j0_.apply_until AS apply_until_4,
  j0_.description AS description_5,
  j0_.requirements AS requirements_6,
  j0_.salary AS salary_7,
  j0_.details AS details_8,
  j0_.open_date AS open_date_9,
  j0_.closed_date AS closed_date_10,
  j0_.url AS url_11,
  j0_.additional_info AS additional_info_12,
  j0_.media_id AS media_id_13,
  j0_.custom_advertisment_media_id AS custom_advertisment_media_id_14,
  j0_.contact_id AS contact_id_15,
  j0_.job_market_position_type_id AS job_market_position_type_id_16,
  j0_.job_market_apply_type_id AS job_market_apply_type_id_17,
  j0_.job_market_start_type_id AS job_market_start_type_id_18,
  j0_.company_profile_id AS company_profile_id_19,
  j0_.user_id AS user_id_20,
  j0_.job_market_state_id AS job_market_state_id_21
FROM
  job_market j0_
  INNER JOIN job_market_job_mapping j2_ ON j0_.id = j2_.job_market_id
  INNER JOIN job j1_ ON j1_.id = j2_.job_id
  INNER JOIN job_market_state j3_ ON j0_.job_market_state_id = j3_.id
WHERE
  j1_.id = ?
  AND j3_.id = 1
  AND j0_.closed_date >= CURRENT_TIMESTAMP

SELECT j0_.id AS id_0, j0_.name AS name_1, j0_.number_of_positions AS number_of_positions_2, j0_.start_date AS start_date_3, j0_.apply_until AS apply_until_4, j0_.description AS description_5, j0_.requirements AS requirements_6, j0_.salary AS salary_7, j0_.details AS details_8, j0_.open_date AS open_date_9, j0_.closed_date AS closed_date_10, j0_.url AS url_11, j0_.additional_info AS additional_info_12, j0_.media_id AS media_id_13, j0_.custom_advertisment_media_id AS custom_advertisment_media_id_14, j0_.contact_id AS contact_id_15, j0_.job_market_position_type_id AS job_market_position_type_id_16, j0_.job_market_apply_type_id AS job_market_apply_type_id_17, j0_.job_market_start_type_id AS job_market_start_type_id_18, j0_.company_profile_id AS company_profile_id_19, j0_.user_id AS user_id_20, j0_.job_market_state_id AS job_market_state_id_21 FROM job_market j0_ INNER JOIN job_market_job_mapping j2_ ON j0_.id = j2_.job_market_id INNER JOIN job j1_ ON j1_.id = j2_.job_id INNER JOIN job_market_state j3_ ON j0_.job_market_state_id = j3_.id WHERE j1_.id = 463 AND j3_.id = 1 AND j0_.closed_date >= CURRENT_TIMESTAMP;

SELECT
  j0_.id AS id_0,
  j0_.avatar_position AS avatar_position_1,
  j0_.routine_title AS routine_title_2,
  j0_.video_url AS video_url_3,
  j0_.show_after_date AS show_after_date_4,
  j0_.pre_selected AS pre_selected_5,
  j0_.created_at AS created_at_6,
  j0_.media_id AS media_id_7,
  j0_.media_2_id AS media_2_id_8,
  j0_.avatar_picture_id AS avatar_picture_id_9,
  j0_.color_id AS color_id_10,
  j0_.gradient_id AS gradient_id_11,
  j0_.icon_id AS icon_id_12,
  j0_.icon_color_id AS icon_color_id_13,
  j0_.job_daily_routine_category_id AS job_daily_routine_category_id_14,
  j0_.school_profile_id AS school_profile_id_15
FROM
  job_daily_routine j0_
  LEFT JOIN job_daily_routine_category j1_ ON j0_.job_daily_routine_category_id = j1_.id
  LEFT JOIN job_daily_routine_job_mapping j2_ ON j0_.id = j2_.job_daily_routine_id
  LEFT JOIN job j3_ ON j2_.job_id = j3_.id
WHERE
  (
    j0_.show_after_date IS NULL
    OR CURRENT_TIMESTAMP >= j0_.show_after_date
  )
  AND j3_.id = ?
ORDER BY
  j1_.position ASC

SELECT j0_.id AS id_0, j0_.avatar_position AS avatar_position_1, j0_.routine_title AS routine_title_2, j0_.video_url AS video_url_3, j0_.show_after_date AS show_after_date_4, j0_.pre_selected AS pre_selected_5, j0_.created_at AS created_at_6, j0_.media_id AS media_id_7, j0_.media_2_id AS media_2_id_8, j0_.avatar_picture_id AS avatar_picture_id_9, j0_.color_id AS color_id_10, j0_.gradient_id AS gradient_id_11, j0_.icon_id AS icon_id_12, j0_.icon_color_id AS icon_color_id_13, j0_.job_daily_routine_category_id AS job_daily_routine_category_id_14, j0_.school_profile_id AS school_profile_id_15 FROM job_daily_routine j0_ LEFT JOIN job_daily_routine_category j1_ ON j0_.job_daily_routine_category_id = j1_.id LEFT JOIN job_daily_routine_job_mapping j2_ ON j0_.id = j2_.job_daily_routine_id LEFT JOIN job j3_ ON j2_.job_id = j3_.id WHERE (j0_.show_after_date IS NULL OR CURRENT_TIMESTAMP >= j0_.show_after_date) AND j3_.id = 463 ORDER BY j1_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.name AS name_2,
  c0_.wknr AS wknr_3,
  c0_.is_flexi_profile AS is_flexi_profile_4,
  c0_.description AS description_5,
  c0_.training_information AS training_information_6,
  c0_.certificate_information AS certificate_information_7,
  c0_.url AS url_8,
  c0_.founded AS founded_9,
  c0_.no_of_trainees AS no_of_trainees_10,
  c0_.click_count AS click_count_11,
  c0_.is_visible AS is_visible_12,
  c0_.logo_style AS logo_style_13,
  c0_.communication_id AS communication_id_14,
  c0_.gallery_id AS gallery_id_15,
  c0_.video_gallery_id AS video_gallery_id_16,
  c0_.document_gallery_id AS document_gallery_id_17,
  c0_.contact_gallery_id AS contact_gallery_id_18,
  c0_.company_size_id AS company_size_id_19,
  c0_.profile_picture_id AS profile_picture_id_20,
  c0_.header_picture_id AS header_picture_id_21,
  c0_.profile_link_id AS profile_link_id_22
FROM
  company_profile c0_
  INNER JOIN company_profile_job_mapping c2_ ON c0_.id = c2_.company_profile_id
  INNER JOIN job j1_ ON j1_.id = c2_.job_id
WHERE
  j1_.id = ?

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.wknr AS wknr_3, c0_.is_flexi_profile AS is_flexi_profile_4, c0_.description AS description_5, c0_.training_information AS training_information_6, c0_.certificate_information AS certificate_information_7, c0_.url AS url_8, c0_.founded AS founded_9, c0_.no_of_trainees AS no_of_trainees_10, c0_.click_count AS click_count_11, c0_.is_visible AS is_visible_12, c0_.logo_style AS logo_style_13, c0_.communication_id AS communication_id_14, c0_.gallery_id AS gallery_id_15, c0_.video_gallery_id AS video_gallery_id_16, c0_.document_gallery_id AS document_gallery_id_17, c0_.contact_gallery_id AS contact_gallery_id_18, c0_.company_size_id AS company_size_id_19, c0_.profile_picture_id AS profile_picture_id_20, c0_.header_picture_id AS header_picture_id_21, c0_.profile_link_id AS profile_link_id_22 FROM company_profile c0_ INNER JOIN company_profile_job_mapping c2_ ON c0_.id = c2_.company_profile_id INNER JOIN job j1_ ON j1_.id = c2_.job_id WHERE j1_.id = 463;

SELECT
  t0.id AS id_1,
  t0.bic_id AS bic_id_2,
  t0.type_name AS type_name_3,
  t0.short_name AS short_name_4,
  t0.modified_name AS modified_name_5
FROM
  job_requirement_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.type_name AS type_name_3, t0.short_name AS short_name_4, t0.modified_name AS modified_name_5 FROM job_requirement_type t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.bic_id AS bic_id_2,
  t0.name AS name_3,
  t0.default_image_name AS default_image_name_4,
  t0.description AS description_5,
  t0.job_workfield_image_id AS job_workfield_image_id_6
FROM
  job_workfield t0
  INNER JOIN job_workfield_mapping ON t0.id = job_workfield_mapping.job_workfield_id
WHERE
  job_workfield_mapping.job_id = ?

SELECT t0.id AS id_1, t0.bic_id AS bic_id_2, t0.name AS name_3, t0.default_image_name AS default_image_name_4, t0.description AS description_5, t0.job_workfield_image_id AS job_workfield_image_id_6 FROM job_workfield t0 INNER JOIN job_workfield_mapping ON t0.id = job_workfield_mapping.job_workfield_id WHERE job_workfield_mapping.job_id = 463;

SELECT
  t0.id AS id_1,
  t0.keep_mapping AS keep_mapping_2,
  t0.job_id AS job_id_3,
  t0.job_requirement_id AS job_requirement_id_4
FROM
  job_requirement_mapping t0
WHERE
  t0.job_id = ?

SELECT t0.id AS id_1, t0.keep_mapping AS keep_mapping_2, t0.job_id AS job_id_3, t0.job_requirement_id AS job_requirement_id_4 FROM job_requirement_mapping t0 WHERE t0.job_id = 463;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  search_tag t0
  INNER JOIN job_search_tag_mapping ON t0.id = job_search_tag_mapping.search_tag_id
WHERE
  job_search_tag_mapping.job_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM search_tag t0 INNER JOIN job_search_tag_mapping ON t0.id = job_search_tag_mapping.search_tag_id WHERE job_search_tag_mapping.job_id = 463;

SELECT
  t0.id AS id_1,
  t0.job_id AS job_id_2,
  t0.job_school_subject_id AS job_school_subject_id_3
FROM
  job_school_subject_mapping t0
WHERE
  t0.job_id = ?

SELECT t0.id AS id_1, t0.job_id AS job_id_2, t0.job_school_subject_id AS job_school_subject_id_3 FROM job_school_subject_mapping t0 WHERE t0.job_id = 463;

SELECT
  t0.id AS id_1,
  t0.job_src_id AS job_src_id_2,
  t0.job_dest_id AS job_dest_id_3,
  t0.job_redirect_type_id AS job_redirect_type_id_4
FROM
  job_redirect t0
WHERE
  t0.job_src_id = ?

SELECT t0.id AS id_1, t0.job_src_id AS job_src_id_2, t0.job_dest_id AS job_dest_id_3, t0.job_redirect_type_id AS job_redirect_type_id_4 FROM job_redirect t0 WHERE t0.job_src_id = 463;

SELECT
  t0.id AS id_1,
  t0.type_name AS type_name_2
FROM
  job_redirect_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type_name AS type_name_2 FROM job_redirect_type t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.is_active AS is_active_2,
  t0.school_id AS school_id_3,
  t0.job_id AS job_id_4
FROM
  job_school t0
WHERE
  t0.job_id = ?

SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.school_id AS school_id_3, t0.job_id AS job_id_4 FROM job_school t0 WHERE t0.job_id = 463;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.name AS name_2,
  c0_.wknr AS wknr_3,
  c0_.is_flexi_profile AS is_flexi_profile_4,
  c0_.description AS description_5,
  c0_.training_information AS training_information_6,
  c0_.certificate_information AS certificate_information_7,
  c0_.url AS url_8,
  c0_.founded AS founded_9,
  c0_.no_of_trainees AS no_of_trainees_10,
  c0_.click_count AS click_count_11,
  c0_.is_visible AS is_visible_12,
  c0_.logo_style AS logo_style_13,
  c0_.communication_id AS communication_id_14,
  c0_.gallery_id AS gallery_id_15,
  c0_.video_gallery_id AS video_gallery_id_16,
  c0_.document_gallery_id AS document_gallery_id_17,
  c0_.contact_gallery_id AS contact_gallery_id_18,
  c0_.company_size_id AS company_size_id_19,
  c0_.profile_picture_id AS profile_picture_id_20,
  c0_.header_picture_id AS header_picture_id_21,
  c0_.profile_link_id AS profile_link_id_22
FROM
  company_profile c0_
  LEFT JOIN company_profile_job_mapping c2_ ON c0_.id = c2_.company_profile_id
  LEFT JOIN job j1_ ON j1_.id = c2_.job_id
WHERE
  c0_.is_visible = 1
  AND j1_.id = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.name AS name_2, c0_.wknr AS wknr_3, c0_.is_flexi_profile AS is_flexi_profile_4, c0_.description AS description_5, c0_.training_information AS training_information_6, c0_.certificate_information AS certificate_information_7, c0_.url AS url_8, c0_.founded AS founded_9, c0_.no_of_trainees AS no_of_trainees_10, c0_.click_count AS click_count_11, c0_.is_visible AS is_visible_12, c0_.logo_style AS logo_style_13, c0_.communication_id AS communication_id_14, c0_.gallery_id AS gallery_id_15, c0_.video_gallery_id AS video_gallery_id_16, c0_.document_gallery_id AS document_gallery_id_17, c0_.contact_gallery_id AS contact_gallery_id_18, c0_.company_size_id AS company_size_id_19, c0_.profile_picture_id AS profile_picture_id_20, c0_.header_picture_id AS header_picture_id_21, c0_.profile_link_id AS profile_link_id_22 FROM company_profile c0_ LEFT JOIN company_profile_job_mapping c2_ ON c0_.id = c2_.company_profile_id LEFT JOIN job j1_ ON j1_.id = c2_.job_id WHERE c0_.is_visible = 1 AND j1_.id = 463 ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.start_date AS start_date_3,
  t0.created_at AS created_at_4,
  t0.job_id AS job_id_5,
  t0.job_link_id AS job_link_id_6,
  t0.job_link_mapping_category_id AS job_link_mapping_category_id_7,
  t0.job_link_mapping_type_id AS job_link_mapping_type_id_8
FROM
  job_link_mapping t0
WHERE
  t0.job_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.start_date AS start_date_3, t0.created_at AS created_at_4, t0.job_id AS job_id_5, t0.job_link_id AS job_link_id_6, t0.job_link_mapping_category_id AS job_link_mapping_category_id_7, t0.job_link_mapping_type_id AS job_link_mapping_type_id_8 FROM job_link_mapping t0 WHERE t0.job_id = 463 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.copyright AS copyright_3,
  t0.provider_name AS provider_name_4,
  t0.provider_reference AS provider_reference_5,
  t0.provider_metadata AS provider_metadata_6,
  t0.content_type AS content_type_7,
  t0.context AS context_8,
  t0.updated_at AS updated_at_9,
  t0.created_at AS created_at_10,
  t0.owner_id AS owner_id_11,
  t0.document_type AS document_type_12
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.copyright AS copyright_3, t0.provider_name AS provider_name_4, t0.provider_reference AS provider_reference_5, t0.provider_metadata AS provider_metadata_6, t0.content_type AS content_type_7, t0.context AS context_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.owner_id AS owner_id_11, t0.document_type AS document_type_12 FROM media__media t0 WHERE t0.id = 21036;