Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.wknr AS wknr_4,
  t0.is_flexi_profile AS is_flexi_profile_5,
  t0.description AS description_6,
  t0.training_information AS training_information_7,
  t0.certificate_information AS certificate_information_8,
  t0.url AS url_9,
  t0.founded AS founded_10,
  t0.no_of_trainees AS no_of_trainees_11,
  t0.click_count AS click_count_12,
  t0.is_visible AS is_visible_13,
  t0.logo_style AS logo_style_14,
  t0.communication_id AS communication_id_15,
  t0.gallery_id AS gallery_id_16,
  t17.id AS id_18,
  t17.context AS context_19,
  t17.name AS name_20,
  t17.default_format AS default_format_21,
  t17.enabled AS enabled_22,
  t17.updated_at AS updated_at_23,
  t17.created_at AS created_at_24,
  t17.owner_id AS owner_id_25,
  t17.media_gallery_category_id AS media_gallery_category_id_26,
  t0.video_gallery_id AS video_gallery_id_27,
  t28.id AS id_29,
  t28.context AS context_30,
  t28.name AS name_31,
  t28.default_format AS default_format_32,
  t28.enabled AS enabled_33,
  t28.updated_at AS updated_at_34,
  t28.created_at AS created_at_35,
  t28.owner_id AS owner_id_36,
  t28.media_gallery_category_id AS media_gallery_category_id_37,
  t0.document_gallery_id AS document_gallery_id_38,
  t39.id AS id_40,
  t39.context AS context_41,
  t39.name AS name_42,
  t39.default_format AS default_format_43,
  t39.enabled AS enabled_44,
  t39.updated_at AS updated_at_45,
  t39.created_at AS created_at_46,
  t39.owner_id AS owner_id_47,
  t39.media_gallery_category_id AS media_gallery_category_id_48,
  t0.contact_gallery_id AS contact_gallery_id_49,
  t50.id AS id_51,
  t50.is_visible AS is_visible_52,
  t0.company_size_id AS company_size_id_53,
  t0.profile_picture_id AS profile_picture_id_54,
  t55.id AS id_56,
  t55.name AS name_57,
  t55.copyright AS copyright_58,
  t55.provider_name AS provider_name_59,
  t55.provider_reference AS provider_reference_60,
  t55.provider_metadata AS provider_metadata_61,
  t55.content_type AS content_type_62,
  t55.context AS context_63,
  t55.updated_at AS updated_at_64,
  t55.created_at AS created_at_65,
  t55.owner_id AS owner_id_66,
  t55.document_type AS document_type_67,
  t0.header_picture_id AS header_picture_id_68,
  t69.id AS id_70,
  t69.name AS name_71,
  t69.copyright AS copyright_72,
  t69.provider_name AS provider_name_73,
  t69.provider_reference AS provider_reference_74,
  t69.provider_metadata AS provider_metadata_75,
  t69.content_type AS content_type_76,
  t69.context AS context_77,
  t69.updated_at AS updated_at_78,
  t69.created_at AS created_at_79,
  t69.owner_id AS owner_id_80,
  t69.document_type AS document_type_81,
  t0.profile_link_id AS profile_link_id_82
FROM
  company_profile t0
  LEFT JOIN media__gallery t17 ON t0.gallery_id = t17.id
  LEFT JOIN media__gallery t28 ON t0.video_gallery_id = t28.id
  LEFT JOIN media__gallery t39 ON t0.document_gallery_id = t39.id
  LEFT JOIN contact_gallery t50 ON t0.contact_gallery_id = t50.id
  LEFT JOIN media__media t55 ON t0.profile_picture_id = t55.id
  LEFT JOIN media__media t69 ON t0.header_picture_id = t69.id
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.wknr AS wknr_4, t0.is_flexi_profile AS is_flexi_profile_5, t0.description AS description_6, t0.training_information AS training_information_7, t0.certificate_information AS certificate_information_8, t0.url AS url_9, t0.founded AS founded_10, t0.no_of_trainees AS no_of_trainees_11, t0.click_count AS click_count_12, t0.is_visible AS is_visible_13, t0.logo_style AS logo_style_14, t0.communication_id AS communication_id_15, t0.gallery_id AS gallery_id_16, t17.id AS id_18, t17.context AS context_19, t17.name AS name_20, t17.default_format AS default_format_21, t17.enabled AS enabled_22, t17.updated_at AS updated_at_23, t17.created_at AS created_at_24, t17.owner_id AS owner_id_25, t17.media_gallery_category_id AS media_gallery_category_id_26, t0.video_gallery_id AS video_gallery_id_27, t28.id AS id_29, t28.context AS context_30, t28.name AS name_31, t28.default_format AS default_format_32, t28.enabled AS enabled_33, t28.updated_at AS updated_at_34, t28.created_at AS created_at_35, t28.owner_id AS owner_id_36, t28.media_gallery_category_id AS media_gallery_category_id_37, t0.document_gallery_id AS document_gallery_id_38, t39.id AS id_40, t39.context AS context_41, t39.name AS name_42, t39.default_format AS default_format_43, t39.enabled AS enabled_44, t39.updated_at AS updated_at_45, t39.created_at AS created_at_46, t39.owner_id AS owner_id_47, t39.media_gallery_category_id AS media_gallery_category_id_48, t0.contact_gallery_id AS contact_gallery_id_49, t50.id AS id_51, t50.is_visible AS is_visible_52, t0.company_size_id AS company_size_id_53, t0.profile_picture_id AS profile_picture_id_54, t55.id AS id_56, t55.name AS name_57, t55.copyright AS copyright_58, t55.provider_name AS provider_name_59, t55.provider_reference AS provider_reference_60, t55.provider_metadata AS provider_metadata_61, t55.content_type AS content_type_62, t55.context AS context_63, t55.updated_at AS updated_at_64, t55.created_at AS created_at_65, t55.owner_id AS owner_id_66, t55.document_type AS document_type_67, t0.header_picture_id AS header_picture_id_68, t69.id AS id_70, t69.name AS name_71, t69.copyright AS copyright_72, t69.provider_name AS provider_name_73, t69.provider_reference AS provider_reference_74, t69.provider_metadata AS provider_metadata_75, t69.content_type AS content_type_76, t69.context AS context_77, t69.updated_at AS updated_at_78, t69.created_at AS created_at_79, t69.owner_id AS owner_id_80, t69.document_type AS document_type_81, t0.profile_link_id AS profile_link_id_82 FROM company_profile t0 LEFT JOIN media__gallery t17 ON t0.gallery_id = t17.id LEFT JOIN media__gallery t28 ON t0.video_gallery_id = t28.id LEFT JOIN media__gallery t39 ON t0.document_gallery_id = t39.id LEFT JOIN contact_gallery t50 ON t0.contact_gallery_id = t50.id LEFT JOIN media__media t55 ON t0.profile_picture_id = t55.id LEFT JOIN media__media t69 ON t0.header_picture_id = t69.id WHERE t0.uuid = 'bd913117-534d-471b-8874-de943aa668d8' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.picture_path AS picture_path_4
FROM
  company_certificate t0
  INNER JOIN company_profile_certificate_mapping ON t0.id = company_profile_certificate_mapping.company_certificate_id
WHERE
  company_profile_certificate_mapping.company_profile_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.picture_path AS picture_path_4 FROM company_certificate t0 INNER JOIN company_profile_certificate_mapping ON t0.id = company_profile_certificate_mapping.company_certificate_id WHERE company_profile_certificate_mapping.company_profile_id = 2418;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.text AS text_3,
  t0.min_employees AS min_employees_4,
  t0.max_employees AS max_employees_5
FROM
  company_size t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.min_employees AS min_employees_4, t0.max_employees AS max_employees_5 FROM company_size t0 WHERE t0.id = 2;

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
  INNER JOIN company_profile_job_mapping ON t0.id = company_profile_job_mapping.job_id
WHERE
  company_profile_job_mapping.company_profile_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 INNER JOIN company_profile_job_mapping ON t0.id = company_profile_job_mapping.job_id WHERE company_profile_job_mapping.company_profile_id = 2418;

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

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

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

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 (616, 615, 7962, 370, 371, 431, 406, 1217, 7804, 345, 1058, 7969, 3467, 3468, 3469, 4090, 4091, 4092, 3576, 3577, 3578, 4096, 4097, 4098, 7525, 7526, 7527, 775, 4105, 4106, 4107, 3717, 3718, 3719, 3910, 3911, 3912, 3289, 3290, 3291, 3609, 3610, 3611, 5850, 5851, 5852, 1557, 1558, 1559, 3313, 3314, 3315, 8232, 8233, 8234, 4213, 4214, 4215, 4102, 4103, 4104, 6315, 6316, 6317, 3045, 3046, 3047);

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 (2607, 2, 62, 191, 3179, 2964, 806, 1007, 841, 2737, 1881, 299, 1012, 888, 947, 755, 852, 1424, 607, 763, 439, 3401, 1048, 1011, 1951, 691);

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 (20395, 20397, 2799, 13652, 4167, 4197, 14829, 20875, 20429, 7785, 15157, 7928, 6425, 6925, 7643, 3710, 7801, 8861, 8034, 4386, 8026, 5225, 16437, 8180, 7578, 16173, 16337, 17200, 15719, 16185, 10377, 21484, 21485, 13633, 13690, 15463, 10632);

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

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

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 = 1061 ORDER BY j1_.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 = ?
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 = 1061 ORDER BY t0.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_
  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 = 1061 ORDER BY c0_.name 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 = 1469 ORDER BY t0.position ASC;

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

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

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