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_gallery_id AS job_gallery_id_23,
  t24.id AS id_25,
  t24.created_at AS created_at_26,
  t24.job_id AS job_id_27,
  t24.job_ams_mapping_id AS job_ams_mapping_id_28,
  t24.job_lehrlingseinkommen_mapping_id AS job_lehrlingseinkommen_mapping_id_29,
  t0.job_teaser_image_id AS job_teaser_image_id_30,
  t0.job_scholastic_duration_id AS job_scholastic_duration_id_31
FROM
  job t0
  LEFT JOIN job_pdf t18 ON t18.job_id = t0.id
  LEFT JOIN job_salary t24 ON t24.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_gallery_id AS job_gallery_id_23, t24.id AS id_25, t24.created_at AS created_at_26, t24.job_id AS job_id_27, t24.job_ams_mapping_id AS job_ams_mapping_id_28, t24.job_lehrlingseinkommen_mapping_id AS job_lehrlingseinkommen_mapping_id_29, t0.job_teaser_image_id AS job_teaser_image_id_30, t0.job_scholastic_duration_id AS job_scholastic_duration_id_31 FROM job t0 LEFT JOIN job_pdf t18 ON t18.job_id = t0.id LEFT JOIN job_salary t24 ON t24.job_id = t0.id WHERE t0.id = 1597;

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

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_
  INNER JOIN job_daily_routine_job_mapping j1_ ON j0_.id = j1_.job_daily_routine_id
  INNER JOIN job j2_ ON j1_.job_id = j2_.id
  INNER JOIN job_interest_field_mapping j4_ ON j2_.id = j4_.job_id
  INNER JOIN interest_field i3_ ON i3_.id = j4_.interest_field_id
  INNER JOIN job_daily_routine_category j5_ ON j0_.job_daily_routine_category_id = j5_.id
WHERE
  j5_.id = ?
  AND j0_.id <> ?
  AND i3_.id IN (1, 3, 4)
  AND (
    j0_.show_after_date IS NULL
    OR j0_.show_after_date < ?
  )

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_ INNER JOIN job_daily_routine_job_mapping j1_ ON j0_.id = j1_.job_daily_routine_id INNER JOIN job j2_ ON j1_.job_id = j2_.id INNER JOIN job_interest_field_mapping j4_ ON j2_.id = j4_.job_id INNER JOIN interest_field i3_ ON i3_.id = j4_.interest_field_id INNER JOIN job_daily_routine_category j5_ ON j0_.job_daily_routine_category_id = j5_.id WHERE j5_.id = 1 AND j0_.id <> 39 AND i3_.id IN (1, 3, 4) AND (j0_.show_after_date IS NULL OR j0_.show_after_date < '2026-07-17 09:54:26');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alt_text AS alt_text_3,
  t0.copyright AS copyright_4,
  t0.provider_name AS provider_name_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.content_type AS content_type_8,
  t0.context AS context_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.owner_id AS owner_id_12,
  t0.document_type AS document_type_13
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.alt_text AS alt_text_3, t0.copyright AS copyright_4, t0.provider_name AS provider_name_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.content_type AS content_type_8, t0.context AS context_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.owner_id AS owner_id_12, t0.document_type AS document_type_13 FROM media__media t0 WHERE t0.id = 19601;

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.number AS number_3,
  t0.floor AS floor_4,
  t0.stair AS stair_5,
  t6.id AS id_7,
  t6.lat AS lat_8,
  t6.lon AS lon_9,
  t6.address_id AS address_id_10,
  t0.address_type_id AS address_type_id_11,
  t0.address_city_id AS address_city_id_12
FROM
  address t0
  LEFT JOIN address_lat_lon t6 ON t6.address_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.number AS number_3, t0.floor AS floor_4, t0.stair AS stair_5, t6.id AS id_7, t6.lat AS lat_8, t6.lon AS lon_9, t6.address_id AS address_id_10, t0.address_type_id AS address_type_id_11, t0.address_city_id AS address_city_id_12 FROM address t0 LEFT JOIN address_lat_lon t6 ON t6.address_id = t0.id WHERE t0.id = 19502;

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_gallery_id AS job_gallery_id_23,
  t24.id AS id_25,
  t24.created_at AS created_at_26,
  t24.job_id AS job_id_27,
  t24.job_ams_mapping_id AS job_ams_mapping_id_28,
  t24.job_lehrlingseinkommen_mapping_id AS job_lehrlingseinkommen_mapping_id_29,
  t0.job_teaser_image_id AS job_teaser_image_id_30,
  t0.job_scholastic_duration_id AS job_scholastic_duration_id_31
FROM
  job t0
  LEFT JOIN job_pdf t18 ON t18.job_id = t0.id
  LEFT JOIN job_salary t24 ON t24.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_gallery_id AS job_gallery_id_23, t24.id AS id_25, t24.created_at AS created_at_26, t24.job_id AS job_id_27, t24.job_ams_mapping_id AS job_ams_mapping_id_28, t24.job_lehrlingseinkommen_mapping_id AS job_lehrlingseinkommen_mapping_id_29, t0.job_teaser_image_id AS job_teaser_image_id_30, t0.job_scholastic_duration_id AS job_scholastic_duration_id_31 FROM job t0 LEFT JOIN job_pdf t18 ON t18.job_id = t0.id LEFT JOIN job_salary t24 ON t24.job_id = t0.id WHERE t0.bic_id = '353' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.heading AS heading_2,
  t0.description AS description_3,
  t0.description_info AS description_info_4,
  t0.videourl AS videourl_5,
  t0.background_video AS background_video_6,
  t0.day_time AS day_time_7,
  t0.position AS position_8,
  t0.job_daily_routine_id AS job_daily_routine_id_9,
  t0.media_picture_id AS media_picture_id_10,
  t0.background_image_id AS background_image_id_11,
  t0.layout_id AS layout_id_12,
  t0.theme_id AS theme_id_13,
  t0.image_position_id AS image_position_id_14,
  t0.highlight_position_id AS highlight_position_id_15
FROM
  job_daily_routine_entry t0
WHERE
  t0.job_daily_routine_id = ?
ORDER BY
  t0.position ASC,
  t0.day_time ASC

SELECT t0.id AS id_1, t0.heading AS heading_2, t0.description AS description_3, t0.description_info AS description_info_4, t0.videourl AS videourl_5, t0.background_video AS background_video_6, t0.day_time AS day_time_7, t0.position AS position_8, t0.job_daily_routine_id AS job_daily_routine_id_9, t0.media_picture_id AS media_picture_id_10, t0.background_image_id AS background_image_id_11, t0.layout_id AS layout_id_12, t0.theme_id AS theme_id_13, t0.image_position_id AS image_position_id_14, t0.highlight_position_id AS highlight_position_id_15 FROM job_daily_routine_entry t0 WHERE t0.job_daily_routine_id = 39 ORDER BY t0.position ASC, t0.day_time ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.wknr AS wknr_3,
  t0.bnr AS bnr_4,
  t0.position AS position_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.address_id AS address_id_8,
  t0.company_profile_id AS company_profile_id_9
FROM
  company_location t0
WHERE
  t0.company_profile_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.wknr AS wknr_3, t0.bnr AS bnr_4, t0.position AS position_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.address_id AS address_id_8, t0.company_profile_id AS company_profile_id_9 FROM company_location t0 WHERE t0.company_profile_id = 8988 ORDER BY t0.position ASC;

SELECT
  job_id,
  count(*) num
FROM
  game_quiz_question as gqq
  LEFT JOIN game_quiz_question_job_mapping as gqqjm ON gqqjm.game_quiz_question_id = gqq.id
WHERE
  gqqjm.job_id = :jobid
GROUP BY
  job_id;

SELECT job_id, count(*) num FROM game_quiz_question as gqq LEFT JOIN game_quiz_question_job_mapping as gqqjm ON gqqjm.game_quiz_question_id=gqq.id WHERE gqqjm.job_id = 1080 GROUP BY job_id;;

SELECT
  t0.id AS id_1,
  t0.key_name AS key_name_2,
  t0.entry_value AS entry_value_3,
  t0.position AS position_4,
  t0.key_type_id AS key_type_id_5
FROM
  key_value t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.entry_value AS entry_value_3, t0.position AS position_4, t0.key_type_id AS key_type_id_5 FROM key_value t0 WHERE t0.id = 17;

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

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

SELECT
  t0.id AS id_1,
  t0.zip AS zip_2,
  t0.name AS name_3,
  t0.gkz AS gkz_4,
  t0.address_district_id AS address_district_id_5
FROM
  address_city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zip AS zip_2, t0.name AS name_3, t0.gkz AS gkz_4, t0.address_district_id AS address_district_id_5 FROM address_city t0 WHERE t0.id = 1801;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.bkz AS bkz_3,
  t0.address_state_id AS address_state_id_4
FROM
  address_district t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.bkz AS bkz_3, t0.address_state_id AS address_state_id_4 FROM address_district t0 WHERE t0.id = 83;

SELECT
  t0.id AS id_1,
  t0.abbreviation AS abbreviation_2,
  t0.subject_name AS subject_name_3
FROM
  job_school_subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.abbreviation AS abbreviation_2, t0.subject_name AS subject_name_3 FROM job_school_subject t0 WHERE t0.id = 1;

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

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

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

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

SELECT
  t0.id AS id_1,
  t0.tag_name AS tag_name_2,
  t0.tag_group_id AS tag_group_id_3
FROM
  tag t0
  INNER JOIN job_daily_routine_tag_mapping ON t0.id = job_daily_routine_tag_mapping.tag_id
WHERE
  job_daily_routine_tag_mapping.job_daily_routine_id = ?

SELECT t0.id AS id_1, t0.tag_name AS tag_name_2, t0.tag_group_id AS tag_group_id_3 FROM tag t0 INNER JOIN job_daily_routine_tag_mapping ON t0.id = job_daily_routine_tag_mapping.tag_id WHERE job_daily_routine_tag_mapping.job_daily_routine_id = 39;

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_.email AS email_12,
  j0_.additional_info AS additional_info_13,
  j0_.view_count AS view_count_14,
  j0_.application_count AS application_count_15,
  j0_.media_id AS media_id_16,
  j0_.custom_advertisment_media_id AS custom_advertisment_media_id_17,
  j0_.contact_id AS contact_id_18,
  j0_.job_market_position_type_id AS job_market_position_type_id_19,
  j0_.job_market_apply_type_id AS job_market_apply_type_id_20,
  j0_.job_market_start_type_id AS job_market_start_type_id_21,
  j0_.company_profile_id AS company_profile_id_22,
  j0_.user_id AS user_id_23,
  j0_.job_market_state_id AS job_market_state_id_24,
  j0_.job_market_view_type_id AS job_market_view_type_id_25
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_.email AS email_12, j0_.additional_info AS additional_info_13, j0_.view_count AS view_count_14, j0_.application_count AS application_count_15, j0_.media_id AS media_id_16, j0_.custom_advertisment_media_id AS custom_advertisment_media_id_17, j0_.contact_id AS contact_id_18, j0_.job_market_position_type_id AS job_market_position_type_id_19, j0_.job_market_apply_type_id AS job_market_apply_type_id_20, j0_.job_market_start_type_id AS job_market_start_type_id_21, j0_.company_profile_id AS company_profile_id_22, j0_.user_id AS user_id_23, j0_.job_market_state_id AS job_market_state_id_24, j0_.job_market_view_type_id AS job_market_view_type_id_25 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 = 1080 AND j3_.id = 1 AND j0_.closed_date >= CURRENT_TIMESTAMP;

SELECT
  t0.id AS id_1,
  t0.duration_name AS duration_name_2,
  t0.position AS position_3
FROM
  job_scholastic_duration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.duration_name AS duration_name_2, t0.position AS position_3 FROM job_scholastic_duration t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.color_name AS color_name_2,
  t0.color_group_id AS color_group_id_3
FROM
  color t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.color_name AS color_name_2, t0.color_group_id AS color_group_id_3 FROM color t0 WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.is_visible AS is_visible_2
FROM
  contact_gallery t0
WHERE
  t0.id IN (?, ?)

SELECT t0.id AS id_1, t0.is_visible AS is_visible_2 FROM contact_gallery t0 WHERE t0.id IN (394, 707);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alt_text AS alt_text_3,
  t0.copyright AS copyright_4,
  t0.provider_name AS provider_name_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.content_type AS content_type_8,
  t0.context AS context_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.owner_id AS owner_id_12,
  t0.document_type AS document_type_13
FROM
  media__media t0
WHERE
  t0.id IN (?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alt_text AS alt_text_3, t0.copyright AS copyright_4, t0.provider_name AS provider_name_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.content_type AS content_type_8, t0.context AS context_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.owner_id AS owner_id_12, t0.document_type AS document_type_13 FROM media__media t0 WHERE t0.id IN (10078, 14063);

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 = 1080 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