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

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

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

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

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 (22, 1333, 2907, 1359, 3476, 2428, 3480, 3278, 1007, 2666, 2131, 1954, 969, 1994, 2582, 534, 535, 347, 2473, 802, 2693, 1885, 2797, 3406, 1529, 2338, 587, 3427, 2668, 2586);

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 IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

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 IN (2665, 16958, 4116, 3186, 1246, 21701, 19699, 18028, 20003, 15283, 7797, 6425, 15247, 20469, 12241, 8043, 8704, 5939, 15899, 6024, 14599, 14600, 14598, 17473, 16274, 20490, 17356, 20621, 17235, 21592, 9091, 15994, 15398, 20461, 20460, 20417, 20418, 20385);

SELECT
  t0.id AS id_1,
  t0.context AS context_2,
  t0.name AS name_3,
  t0.default_format AS default_format_4,
  t0.enabled AS enabled_5,
  t0.updated_at AS updated_at_6,
  t0.created_at AS created_at_7,
  t0.owner_id AS owner_id_8,
  t0.media_gallery_category_id AS media_gallery_category_id_9
FROM
  media__gallery t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

SELECT t0.id AS id_1, t0.context AS context_2, t0.name AS name_3, t0.default_format AS default_format_4, t0.enabled AS enabled_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.owner_id AS owner_id_8, t0.media_gallery_category_id AS media_gallery_category_id_9 FROM media__gallery t0 WHERE t0.id IN (5388, 5389, 5390, 3136, 3137, 3138, 5490, 5491, 5492, 7212, 7213, 7214, 6300, 6301, 6302, 6081, 6082, 6083, 3097, 3098, 3099, 4090, 4091, 4092, 6908, 6909, 6910, 653, 7802, 654, 3973, 3974, 3975, 3976, 3977, 3978, 625, 7702, 7703, 2512, 2513, 2514, 1205, 1082, 6574, 6575, 6576, 3430, 3431, 3432, 7986, 7987, 7988, 6261, 6262, 6263, 1025, 8036, 8037, 5940, 5941, 5942, 6249, 6250, 6251, 6026, 6027, 6028, 7475, 7476, 7477, 7966, 7967, 7968, 7950, 7951, 7952);

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

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

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 = 1839 ORDER BY j1_.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 = 18822;

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

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

SELECT
  t0.id AS id_1,
  t0.icon_value AS icon_value_2,
  t0.icon_category_id AS icon_category_id_3
FROM
  icon t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icon_value AS icon_value_2, t0.icon_category_id AS icon_category_id_3 FROM icon t0 WHERE t0.id = 161;

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

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

SELECT
  job_id,
  count(*) num
FROM
  game_quiz_question
WHERE
  job_id is not null
  AND job_id = :jobid
GROUP BY
  job_id;

SELECT job_id, count(*) num FROM game_quiz_question WHERE job_id is not null AND job_id = 1841 GROUP BY job_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 = ?

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

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

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

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

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

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