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.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 = '254' LIMIT 1;

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.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 = 181;

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

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

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

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

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 = 181 ORDER BY j1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.training_information AS training_information_5,
  t0.certificate_information AS certificate_information_6,
  t0.url AS url_7,
  t0.click_count AS click_count_8,
  t0.is_visible AS is_visible_9,
  t0.logo_style AS logo_style_10,
  t0.school_id AS school_id_11,
  t0.communication_id AS communication_id_12,
  t0.gallery_id AS gallery_id_13,
  t14.id AS id_15,
  t14.context AS context_16,
  t14.name AS name_17,
  t14.default_format AS default_format_18,
  t14.enabled AS enabled_19,
  t14.updated_at AS updated_at_20,
  t14.created_at AS created_at_21,
  t14.owner_id AS owner_id_22,
  t14.media_gallery_category_id AS media_gallery_category_id_23,
  t0.video_gallery_id AS video_gallery_id_24,
  t25.id AS id_26,
  t25.context AS context_27,
  t25.name AS name_28,
  t25.default_format AS default_format_29,
  t25.enabled AS enabled_30,
  t25.updated_at AS updated_at_31,
  t25.created_at AS created_at_32,
  t25.owner_id AS owner_id_33,
  t25.media_gallery_category_id AS media_gallery_category_id_34,
  t0.document_gallery_id AS document_gallery_id_35,
  t36.id AS id_37,
  t36.context AS context_38,
  t36.name AS name_39,
  t36.default_format AS default_format_40,
  t36.enabled AS enabled_41,
  t36.updated_at AS updated_at_42,
  t36.created_at AS created_at_43,
  t36.owner_id AS owner_id_44,
  t36.media_gallery_category_id AS media_gallery_category_id_45,
  t0.contact_gallery_id AS contact_gallery_id_46,
  t47.id AS id_48,
  t47.is_visible AS is_visible_49,
  t0.profile_picture_id AS profile_picture_id_50,
  t51.id AS id_52,
  t51.name AS name_53,
  t51.alt_text AS alt_text_54,
  t51.copyright AS copyright_55,
  t51.provider_name AS provider_name_56,
  t51.provider_reference AS provider_reference_57,
  t51.provider_metadata AS provider_metadata_58,
  t51.content_type AS content_type_59,
  t51.context AS context_60,
  t51.updated_at AS updated_at_61,
  t51.created_at AS created_at_62,
  t51.owner_id AS owner_id_63,
  t51.document_type AS document_type_64,
  t0.header_picture_id AS header_picture_id_65,
  t66.id AS id_67,
  t66.name AS name_68,
  t66.alt_text AS alt_text_69,
  t66.copyright AS copyright_70,
  t66.provider_name AS provider_name_71,
  t66.provider_reference AS provider_reference_72,
  t66.provider_metadata AS provider_metadata_73,
  t66.content_type AS content_type_74,
  t66.context AS context_75,
  t66.updated_at AS updated_at_76,
  t66.created_at AS created_at_77,
  t66.owner_id AS owner_id_78,
  t66.document_type AS document_type_79,
  t0.profile_link_id AS profile_link_id_80
FROM
  school_profile t0
  LEFT JOIN media__gallery t14 ON t0.gallery_id = t14.id
  LEFT JOIN media__gallery t25 ON t0.video_gallery_id = t25.id
  LEFT JOIN media__gallery t36 ON t0.document_gallery_id = t36.id
  LEFT JOIN contact_gallery t47 ON t0.contact_gallery_id = t47.id
  LEFT JOIN media__media t51 ON t0.profile_picture_id = t51.id
  LEFT JOIN media__media t66 ON t0.header_picture_id = t66.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.description AS description_4, t0.training_information AS training_information_5, t0.certificate_information AS certificate_information_6, t0.url AS url_7, t0.click_count AS click_count_8, t0.is_visible AS is_visible_9, t0.logo_style AS logo_style_10, t0.school_id AS school_id_11, t0.communication_id AS communication_id_12, t0.gallery_id AS gallery_id_13, t14.id AS id_15, t14.context AS context_16, t14.name AS name_17, t14.default_format AS default_format_18, t14.enabled AS enabled_19, t14.updated_at AS updated_at_20, t14.created_at AS created_at_21, t14.owner_id AS owner_id_22, t14.media_gallery_category_id AS media_gallery_category_id_23, t0.video_gallery_id AS video_gallery_id_24, t25.id AS id_26, t25.context AS context_27, t25.name AS name_28, t25.default_format AS default_format_29, t25.enabled AS enabled_30, t25.updated_at AS updated_at_31, t25.created_at AS created_at_32, t25.owner_id AS owner_id_33, t25.media_gallery_category_id AS media_gallery_category_id_34, t0.document_gallery_id AS document_gallery_id_35, t36.id AS id_37, t36.context AS context_38, t36.name AS name_39, t36.default_format AS default_format_40, t36.enabled AS enabled_41, t36.updated_at AS updated_at_42, t36.created_at AS created_at_43, t36.owner_id AS owner_id_44, t36.media_gallery_category_id AS media_gallery_category_id_45, t0.contact_gallery_id AS contact_gallery_id_46, t47.id AS id_48, t47.is_visible AS is_visible_49, t0.profile_picture_id AS profile_picture_id_50, t51.id AS id_52, t51.name AS name_53, t51.alt_text AS alt_text_54, t51.copyright AS copyright_55, t51.provider_name AS provider_name_56, t51.provider_reference AS provider_reference_57, t51.provider_metadata AS provider_metadata_58, t51.content_type AS content_type_59, t51.context AS context_60, t51.updated_at AS updated_at_61, t51.created_at AS created_at_62, t51.owner_id AS owner_id_63, t51.document_type AS document_type_64, t0.header_picture_id AS header_picture_id_65, t66.id AS id_67, t66.name AS name_68, t66.alt_text AS alt_text_69, t66.copyright AS copyright_70, t66.provider_name AS provider_name_71, t66.provider_reference AS provider_reference_72, t66.provider_metadata AS provider_metadata_73, t66.content_type AS content_type_74, t66.context AS context_75, t66.updated_at AS updated_at_76, t66.created_at AS created_at_77, t66.owner_id AS owner_id_78, t66.document_type AS document_type_79, t0.profile_link_id AS profile_link_id_80 FROM school_profile t0 LEFT JOIN media__gallery t14 ON t0.gallery_id = t14.id LEFT JOIN media__gallery t25 ON t0.video_gallery_id = t25.id LEFT JOIN media__gallery t36 ON t0.document_gallery_id = t36.id LEFT JOIN contact_gallery t47 ON t0.contact_gallery_id = t47.id LEFT JOIN media__media t51 ON t0.profile_picture_id = t51.id LEFT JOIN media__media t66 ON t0.header_picture_id = t66.id WHERE t0.id = 19;

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

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

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.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
  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 = 112 ORDER BY t0.position ASC, t0.day_time ASC;

SELECT
  gqqpm.profile_id,
  count(*) num
FROM
  game_quiz_question as gqq
  LEFT JOIN game_quiz_question_profile_mapping as gqqpm ON gqqpm.game_quiz_question_id = gqq.id
WHERE
  gqqpm.profile_type_id = 3
  AND profile_id = :schoolprofileid
GROUP BY
  gqqpm.profile_id;

SELECT gqqpm.profile_id, count(*) num FROM game_quiz_question as gqq LEFT JOIN game_quiz_question_profile_mapping as gqqpm ON gqqpm.game_quiz_question_id=gqq.id WHERE gqqpm.profile_type_id=3 AND profile_id = 19 GROUP BY gqqpm.profile_id;;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.job_daily_routine_id AS job_daily_routine_id_3,
  t0.job_id AS job_id_4
FROM
  job_daily_routine_job_mapping t0
WHERE
  t0.job_daily_routine_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.job_daily_routine_id AS job_daily_routine_id_3, t0.job_id AS job_id_4 FROM job_daily_routine_job_mapping t0 WHERE t0.job_daily_routine_id = 112 ORDER BY t0.position ASC;

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

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

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

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

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

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

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

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

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

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