Symfony Profiler

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

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.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.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
  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_interest_field_mapping c2_ ON c0_.id = c2_.company_profile_id
  LEFT JOIN interest_field i1_ ON i1_.id = c2_.interest_field_id
WHERE
  i1_.id IN (4)

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_interest_field_mapping c2_ ON c0_.id = c2_.company_profile_id LEFT JOIN interest_field i1_ ON i1_.id = c2_.interest_field_id WHERE i1_.id IN (4);

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, 4116, 3186, 3516, 1087, 1498, 20007, 5507, 12293, 1246, 21701, 4148, 806, 19699, 16971, 4114, 1935, 7784, 2932, 4106, 16192, 21654, 15794, 17392, 4139, 20333, 16819, 4190, 5271, 4138, 19688, 10100, 8723, 2662, 3006, 15960, 17784, 4199, 4155, 2690, 2703, 15665, 2668, 5895, 7795, 5769, 7866, 5374, 17078, 8787, 13650, 9047, 8091, 6918, 7235, 16440, 4360, 6924, 8244, 8258, 21660, 8093, 7765, 5690, 14702, 7902, 8098, 5319, 8830, 8100, 10000, 9013, 8241, 8267, 7584, 7453, 9009, 7334, 8949, 4261, 8030, 8550, 7638, 7948, 17502, 20345, 13015, 15154, 8150, 7930, 7737, 16126, 20876, 16378, 7159, 7478, 3225, 7946, 8823, 6769);

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
  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 (3136, 3137, 3138, 5490, 5491, 5492, 197, 468, 143, 6204, 6205, 6206, 97, 2875, 2876, 2877, 7212, 7213, 7214, 7095, 7096, 7097, 6300, 6301, 6302, 6334, 6335, 6336, 267, 268, 3533, 3534, 3535, 400, 246, 1060, 340, 8278, 8279, 8280, 6337, 6338, 6339, 390, 7450, 831, 4875, 4876, 4877, 360, 362, 7922, 573, 579, 6538, 6539, 6540, 757, 7534, 7535, 7536, 4818, 4819, 4820, 6192, 6193, 6194, 7393, 7394, 7395, 416, 3573, 3574, 3575, 621, 622, 642, 7728, 7729, 7730, 614, 619, 7368, 7369, 7370, 766, 3549, 3550, 3551, 747, 750, 7383, 3913, 3914, 3915, 3982, 3983, 3984, 7631, 7632);

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

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

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;