Symfony Profiler

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '9' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Questionaire';

SELECT
  t0.id AS id_1,
  t0.answer AS answer_2,
  t0.points AS points_3,
  t0.time_answer AS time_answer_4,
  t0.is_locked AS is_locked_5,
  t0.locked_at AS locked_at_6,
  t0.question_id AS question_id_7,
  t0.certification_id AS certification_id_8,
  t0.locked_by_id AS locked_by_id_9
FROM
  user_answer t0
WHERE
  t0.certification_id = ?
  AND t0.question_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.answer AS answer_2, t0.points AS points_3, t0.time_answer AS time_answer_4, t0.is_locked AS is_locked_5, t0.locked_at AS locked_at_6, t0.question_id AS question_id_7, t0.certification_id AS certification_id_8, t0.locked_by_id AS locked_by_id_9 FROM user_answer t0 WHERE t0.certification_id = 1530 AND t0.question_id = 851 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.is_group_template AS is_group_template_1,
  c0_.time_requested AS time_requested_2,
  c0_.status AS status_3,
  c0_.ulid AS ulid_4,
  c0_.time_finished AS time_finished_5,
  c0_.time_certified AS time_certified_6,
  c0_.time_denied AS time_denied_7,
  c0_.custom_points1 AS custom_points1_8,
  c0_.green_sign_level AS green_sign_level_9,
  c0_.points_part1 AS points_part1_10,
  c0_.points_part2 AS points_part2_11,
  c0_.points_part3 AS points_part3_12,
  c0_.points_part4 AS points_part4_13,
  c0_.points_part5 AS points_part5_14,
  c0_.points_part6 AS points_part6_15,
  c0_.points_part7 AS points_part7_16,
  c0_.points_part8 AS points_part8_17,
  c0_.points_part9 AS points_part9_18,
  c0_.points_part10 AS points_part10_19,
  c0_.points_part11 AS points_part11_20,
  c0_.points_part12 AS points_part12_21,
  c0_.points_part13 AS points_part13_22,
  c0_.points_part14 AS points_part14_23,
  c0_.points_part15 AS points_part15_24,
  c0_.is_gstc AS is_gstc_25,
  c0_.co2_amount AS co2_amount_26,
  c0_.co2_certificate_file AS co2_certificate_file_27,
  c0_.co2_certificate_file_en AS co2_certificate_file_en_28,
  c0_.green_sign_conformity AS green_sign_conformity_29,
  c0_.time_certified_until AS time_certified_until_30,
  c0_.register_id AS register_id_31,
  c0_.rollout_notified_at AS rollout_notified_at_32,
  c0_.hotel_id AS hotel_id_33,
  c0_.group_id AS group_id_34,
  c0_.questionaire_id AS questionaire_id_35
FROM
  certification c0_
  INNER JOIN hotel h1_ ON c0_.hotel_id = h1_.id
  AND (
    h1_.tenant_id = '1'
    AND h1_.is_deleted = 0
  )
WHERE
  (
    h1_.user_id = ?
    OR (
      EXISTS (
        SELECT
          1 AS sclr_36
        FROM
          hotel h2_
          INNER JOIN hotel_user h4_ ON h2_.id = h4_.hotel_id
          INNER JOIN user u3_ ON u3_.id = h4_.user_id
          AND (u3_.tenant_id = '1')
        WHERE
          (
            h2_.id = h1_.id
            AND u3_.id = ?
          )
          AND (
            h2_.tenant_id = '1'
            AND h2_.is_deleted = 0
          )
      )
    )
    OR (
      EXISTS (
        SELECT
          1 AS sclr_37
        FROM
          hotel h5_
          INNER JOIN business_group b7_ ON h5_.id = b7_.business_id
          INNER JOIN `group` g6_ ON g6_.id = b7_.group_id
          AND (
            (
              g6_.tenant_id = '1'
              OR EXISTS (
                SELECT
                  1
                FROM
                  business_group tenant_scope_bg
                  INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_bg.business_id
                WHERE
                  tenant_scope_bg.group_id = g6_.id
                  AND tenant_scope_business.tenant_id = '1'
                  AND tenant_scope_business.is_deleted = 0
              )
            )
          )
          INNER JOIN group_user g9_ ON g6_.id = g9_.group_id
          INNER JOIN user u8_ ON u8_.id = g9_.user_id
          AND (u8_.tenant_id = '1')
        WHERE
          (
            h5_.id = h1_.id
            AND u8_.id = ?
          )
          AND (
            h5_.tenant_id = '1'
            AND h5_.is_deleted = 0
          )
      )
    )
  )
  AND (
    (
      EXISTS (
        SELECT
          1
        FROM
          hotel tenant_scope_business
        WHERE
          tenant_scope_business.id = c0_.hotel_id
          AND tenant_scope_business.tenant_id = '1'
          AND tenant_scope_business.is_deleted = 0
      )
      OR EXISTS (
        SELECT
          1
        FROM
          `group` tenant_scope_group
        WHERE
          tenant_scope_group.id = c0_.group_id
          AND tenant_scope_group.tenant_id = '1'
      )
    )
  )
ORDER BY
  c0_.time_requested DESC
LIMIT
  100

SELECT c0_.id AS id_0, c0_.is_group_template AS is_group_template_1, c0_.time_requested AS time_requested_2, c0_.status AS status_3, c0_.ulid AS ulid_4, c0_.time_finished AS time_finished_5, c0_.time_certified AS time_certified_6, c0_.time_denied AS time_denied_7, c0_.custom_points1 AS custom_points1_8, c0_.green_sign_level AS green_sign_level_9, c0_.points_part1 AS points_part1_10, c0_.points_part2 AS points_part2_11, c0_.points_part3 AS points_part3_12, c0_.points_part4 AS points_part4_13, c0_.points_part5 AS points_part5_14, c0_.points_part6 AS points_part6_15, c0_.points_part7 AS points_part7_16, c0_.points_part8 AS points_part8_17, c0_.points_part9 AS points_part9_18, c0_.points_part10 AS points_part10_19, c0_.points_part11 AS points_part11_20, c0_.points_part12 AS points_part12_21, c0_.points_part13 AS points_part13_22, c0_.points_part14 AS points_part14_23, c0_.points_part15 AS points_part15_24, c0_.is_gstc AS is_gstc_25, c0_.co2_amount AS co2_amount_26, c0_.co2_certificate_file AS co2_certificate_file_27, c0_.co2_certificate_file_en AS co2_certificate_file_en_28, c0_.green_sign_conformity AS green_sign_conformity_29, c0_.time_certified_until AS time_certified_until_30, c0_.register_id AS register_id_31, c0_.rollout_notified_at AS rollout_notified_at_32, c0_.hotel_id AS hotel_id_33, c0_.group_id AS group_id_34, c0_.questionaire_id AS questionaire_id_35 FROM certification c0_ INNER JOIN hotel h1_ ON c0_.hotel_id = h1_.id AND (h1_.tenant_id = '1' AND h1_.is_deleted = 0) WHERE (h1_.user_id = 680 OR (EXISTS (SELECT 1 AS sclr_36 FROM hotel h2_ INNER JOIN hotel_user h4_ ON h2_.id = h4_.hotel_id INNER JOIN user u3_ ON u3_.id = h4_.user_id AND (u3_.tenant_id = '1') WHERE (h2_.id = h1_.id AND u3_.id = 680) AND (h2_.tenant_id = '1' AND h2_.is_deleted = 0))) OR (EXISTS (SELECT 1 AS sclr_37 FROM hotel h5_ INNER JOIN business_group b7_ ON h5_.id = b7_.business_id INNER JOIN `group` g6_ ON g6_.id = b7_.group_id AND ((g6_.tenant_id = '1' OR EXISTS (SELECT 1 FROM business_group tenant_scope_bg INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_bg.business_id WHERE tenant_scope_bg.group_id = g6_.id AND tenant_scope_business.tenant_id = '1' AND tenant_scope_business.is_deleted = 0))) INNER JOIN group_user g9_ ON g6_.id = g9_.group_id INNER JOIN user u8_ ON u8_.id = g9_.user_id AND (u8_.tenant_id = '1') WHERE (h5_.id = h1_.id AND u8_.id = 680) AND (h5_.tenant_id = '1' AND h5_.is_deleted = 0)))) AND ((EXISTS (SELECT 1 FROM hotel tenant_scope_business WHERE tenant_scope_business.id = c0_.hotel_id AND tenant_scope_business.tenant_id = '1' AND tenant_scope_business.is_deleted = 0) OR EXISTS (SELECT 1 FROM `group` tenant_scope_group WHERE tenant_scope_group.id = c0_.group_id AND tenant_scope_group.tenant_id = '1'))) ORDER BY c0_.time_requested DESC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.max_points AS max_points_4,
  t0.is_required AS is_required_5,
  t0.sorting AS sorting_6,
  t0.finished_translations AS finished_translations_7,
  t0.external_id AS external_id_8,
  t0.part_id AS part_id_9,
  t0.question_help_text_id AS question_help_text_id_10
FROM
  element t0
WHERE
  t0.part_id = ?
  AND (
    (
      EXISTS (
        SELECT
          1
        FROM
          part tenant_scope_part
          INNER JOIN questionaire_tenant tenant_scope_qt ON tenant_scope_qt.questionaire_id = tenant_scope_part.questionaire_id
        WHERE
          tenant_scope_part.id = t0.part_id
          AND tenant_scope_qt.tenant_id = '1'
      )
    )
  )
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.max_points AS max_points_4, t0.is_required AS is_required_5, t0.sorting AS sorting_6, t0.finished_translations AS finished_translations_7, t0.external_id AS external_id_8, t0.part_id AS part_id_9, t0.question_help_text_id AS question_help_text_id_10 FROM element t0 WHERE t0.part_id = 65 AND ((EXISTS (SELECT 1 FROM part tenant_scope_part INNER JOIN questionaire_tenant tenant_scope_qt ON tenant_scope_qt.questionaire_id = tenant_scope_part.questionaire_id WHERE tenant_scope_part.id = t0.part_id AND tenant_scope_qt.tenant_id = '1'))) ORDER BY t0.sorting ASC;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  certification c0_
  INNER JOIN hotel h1_ ON c0_.hotel_id = h1_.id
  AND (
    h1_.tenant_id = '1'
    AND h1_.is_deleted = 0
  )
WHERE
  (
    h1_.user_id = ?
    OR (
      EXISTS (
        SELECT
          1 AS sclr_1
        FROM
          hotel h2_
          INNER JOIN hotel_user h4_ ON h2_.id = h4_.hotel_id
          INNER JOIN user u3_ ON u3_.id = h4_.user_id
          AND (u3_.tenant_id = '1')
        WHERE
          (
            h2_.id = h1_.id
            AND u3_.id = ?
          )
          AND (
            h2_.tenant_id = '1'
            AND h2_.is_deleted = 0
          )
      )
    )
    OR (
      EXISTS (
        SELECT
          1 AS sclr_2
        FROM
          hotel h5_
          INNER JOIN business_group b7_ ON h5_.id = b7_.business_id
          INNER JOIN `group` g6_ ON g6_.id = b7_.group_id
          AND (
            (
              g6_.tenant_id = '1'
              OR EXISTS (
                SELECT
                  1
                FROM
                  business_group tenant_scope_bg
                  INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_bg.business_id
                WHERE
                  tenant_scope_bg.group_id = g6_.id
                  AND tenant_scope_business.tenant_id = '1'
                  AND tenant_scope_business.is_deleted = 0
              )
            )
          )
          INNER JOIN group_user g9_ ON g6_.id = g9_.group_id
          INNER JOIN user u8_ ON u8_.id = g9_.user_id
          AND (u8_.tenant_id = '1')
        WHERE
          (
            h5_.id = h1_.id
            AND u8_.id = ?
          )
          AND (
            h5_.tenant_id = '1'
            AND h5_.is_deleted = 0
          )
      )
    )
  )
  AND (
    (
      EXISTS (
        SELECT
          1
        FROM
          hotel tenant_scope_business
        WHERE
          tenant_scope_business.id = c0_.hotel_id
          AND tenant_scope_business.tenant_id = '1'
          AND tenant_scope_business.is_deleted = 0
      )
      OR EXISTS (
        SELECT
          1
        FROM
          `group` tenant_scope_group
        WHERE
          tenant_scope_group.id = c0_.group_id
          AND tenant_scope_group.tenant_id = '1'
      )
    )
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM certification c0_ INNER JOIN hotel h1_ ON c0_.hotel_id = h1_.id AND (h1_.tenant_id = '1' AND h1_.is_deleted = 0) WHERE (h1_.user_id = 680 OR (EXISTS (SELECT 1 AS sclr_1 FROM hotel h2_ INNER JOIN hotel_user h4_ ON h2_.id = h4_.hotel_id INNER JOIN user u3_ ON u3_.id = h4_.user_id AND (u3_.tenant_id = '1') WHERE (h2_.id = h1_.id AND u3_.id = 680) AND (h2_.tenant_id = '1' AND h2_.is_deleted = 0))) OR (EXISTS (SELECT 1 AS sclr_2 FROM hotel h5_ INNER JOIN business_group b7_ ON h5_.id = b7_.business_id INNER JOIN `group` g6_ ON g6_.id = b7_.group_id AND ((g6_.tenant_id = '1' OR EXISTS (SELECT 1 FROM business_group tenant_scope_bg INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_bg.business_id WHERE tenant_scope_bg.group_id = g6_.id AND tenant_scope_business.tenant_id = '1' AND tenant_scope_business.is_deleted = 0))) INNER JOIN group_user g9_ ON g6_.id = g9_.group_id INNER JOIN user u8_ ON u8_.id = g9_.user_id AND (u8_.tenant_id = '1') WHERE (h5_.id = h1_.id AND u8_.id = 680) AND (h5_.tenant_id = '1' AND h5_.is_deleted = 0)))) AND ((EXISTS (SELECT 1 FROM hotel tenant_scope_business WHERE tenant_scope_business.id = c0_.hotel_id AND tenant_scope_business.tenant_id = '1' AND tenant_scope_business.is_deleted = 0) OR EXISTS (SELECT 1 FROM `group` tenant_scope_group WHERE tenant_scope_group.id = c0_.group_id AND tenant_scope_group.tenant_id = '1')));

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.placeholder AS placeholder_3,
  t0.points AS points_4,
  t0.title AS title_5,
  t0.show_title AS show_title_6,
  t0.sorting AS sorting_7,
  t0.finished_translations AS finished_translations_8,
  t0.external_id AS external_id_9,
  t0.element_id AS element_id_10,
  t0.help_text_id AS help_text_id_11
FROM
  answer t0
WHERE
  t0.element_id = ?
  AND (
    (
      EXISTS (
        SELECT
          1
        FROM
          element tenant_scope_element
          INNER JOIN part tenant_scope_part ON tenant_scope_part.id = tenant_scope_element.part_id
          INNER JOIN questionaire_tenant tenant_scope_qt ON tenant_scope_qt.questionaire_id = tenant_scope_part.questionaire_id
        WHERE
          tenant_scope_element.id = t0.element_id
          AND tenant_scope_qt.tenant_id = '1'
      )
    )
  )
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.placeholder AS placeholder_3, t0.points AS points_4, t0.title AS title_5, t0.show_title AS show_title_6, t0.sorting AS sorting_7, t0.finished_translations AS finished_translations_8, t0.external_id AS external_id_9, t0.element_id AS element_id_10, t0.help_text_id AS help_text_id_11 FROM answer t0 WHERE t0.element_id = 852 AND ((EXISTS (SELECT 1 FROM element tenant_scope_element INNER JOIN part tenant_scope_part ON tenant_scope_part.id = tenant_scope_element.part_id INNER JOIN questionaire_tenant tenant_scope_qt ON tenant_scope_qt.questionaire_id = tenant_scope_part.questionaire_id WHERE tenant_scope_element.id = t0.element_id AND tenant_scope_qt.tenant_id = '1'))) ORDER BY t0.sorting ASC;

SELECT
  c0_.id AS id_0,
  c0_.is_group_template AS is_group_template_1,
  c0_.time_requested AS time_requested_2,
  c0_.status AS status_3,
  c0_.ulid AS ulid_4,
  c0_.time_finished AS time_finished_5,
  c0_.time_certified AS time_certified_6,
  c0_.time_denied AS time_denied_7,
  c0_.custom_points1 AS custom_points1_8,
  c0_.green_sign_level AS green_sign_level_9,
  c0_.points_part1 AS points_part1_10,
  c0_.points_part2 AS points_part2_11,
  c0_.points_part3 AS points_part3_12,
  c0_.points_part4 AS points_part4_13,
  c0_.points_part5 AS points_part5_14,
  c0_.points_part6 AS points_part6_15,
  c0_.points_part7 AS points_part7_16,
  c0_.points_part8 AS points_part8_17,
  c0_.points_part9 AS points_part9_18,
  c0_.points_part10 AS points_part10_19,
  c0_.points_part11 AS points_part11_20,
  c0_.points_part12 AS points_part12_21,
  c0_.points_part13 AS points_part13_22,
  c0_.points_part14 AS points_part14_23,
  c0_.points_part15 AS points_part15_24,
  c0_.is_gstc AS is_gstc_25,
  c0_.co2_amount AS co2_amount_26,
  c0_.co2_certificate_file AS co2_certificate_file_27,
  c0_.co2_certificate_file_en AS co2_certificate_file_en_28,
  c0_.green_sign_conformity AS green_sign_conformity_29,
  c0_.time_certified_until AS time_certified_until_30,
  c0_.register_id AS register_id_31,
  c0_.rollout_notified_at AS rollout_notified_at_32,
  c0_.hotel_id AS hotel_id_33,
  c0_.group_id AS group_id_34,
  c0_.questionaire_id AS questionaire_id_35
FROM
  certification c0_
  INNER JOIN `group` g1_ ON c0_.group_id = g1_.id
  AND (
    (
      g1_.tenant_id = '1'
      OR EXISTS (
        SELECT
          1
        FROM
          business_group tenant_scope_bg
          INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_bg.business_id
        WHERE
          tenant_scope_bg.group_id = g1_.id
          AND tenant_scope_business.tenant_id = '1'
          AND tenant_scope_business.is_deleted = 0
      )
    )
  )
WHERE
  (
    g1_.id = ?
    AND c0_.is_group_template = 1
    AND c0_.questionaire_id = ?
  )
  AND (
    (
      EXISTS (
        SELECT
          1
        FROM
          hotel tenant_scope_business
        WHERE
          tenant_scope_business.id = c0_.hotel_id
          AND tenant_scope_business.tenant_id = '1'
          AND tenant_scope_business.is_deleted = 0
      )
      OR EXISTS (
        SELECT
          1
        FROM
          `group` tenant_scope_group
        WHERE
          tenant_scope_group.id = c0_.group_id
          AND tenant_scope_group.tenant_id = '1'
      )
    )
  )
ORDER BY
  c0_.id DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.is_group_template AS is_group_template_1, c0_.time_requested AS time_requested_2, c0_.status AS status_3, c0_.ulid AS ulid_4, c0_.time_finished AS time_finished_5, c0_.time_certified AS time_certified_6, c0_.time_denied AS time_denied_7, c0_.custom_points1 AS custom_points1_8, c0_.green_sign_level AS green_sign_level_9, c0_.points_part1 AS points_part1_10, c0_.points_part2 AS points_part2_11, c0_.points_part3 AS points_part3_12, c0_.points_part4 AS points_part4_13, c0_.points_part5 AS points_part5_14, c0_.points_part6 AS points_part6_15, c0_.points_part7 AS points_part7_16, c0_.points_part8 AS points_part8_17, c0_.points_part9 AS points_part9_18, c0_.points_part10 AS points_part10_19, c0_.points_part11 AS points_part11_20, c0_.points_part12 AS points_part12_21, c0_.points_part13 AS points_part13_22, c0_.points_part14 AS points_part14_23, c0_.points_part15 AS points_part15_24, c0_.is_gstc AS is_gstc_25, c0_.co2_amount AS co2_amount_26, c0_.co2_certificate_file AS co2_certificate_file_27, c0_.co2_certificate_file_en AS co2_certificate_file_en_28, c0_.green_sign_conformity AS green_sign_conformity_29, c0_.time_certified_until AS time_certified_until_30, c0_.register_id AS register_id_31, c0_.rollout_notified_at AS rollout_notified_at_32, c0_.hotel_id AS hotel_id_33, c0_.group_id AS group_id_34, c0_.questionaire_id AS questionaire_id_35 FROM certification c0_ INNER JOIN `group` g1_ ON c0_.group_id = g1_.id AND ((g1_.tenant_id = '1' OR EXISTS (SELECT 1 FROM business_group tenant_scope_bg INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_bg.business_id WHERE tenant_scope_bg.group_id = g1_.id AND tenant_scope_business.tenant_id = '1' AND tenant_scope_business.is_deleted = 0))) WHERE (g1_.id = 36 AND c0_.is_group_template = 1 AND c0_.questionaire_id = 9) AND ((EXISTS (SELECT 1 FROM hotel tenant_scope_business WHERE tenant_scope_business.id = c0_.hotel_id AND tenant_scope_business.tenant_id = '1' AND tenant_scope_business.is_deleted = 0) OR EXISTS (SELECT 1 FROM `group` tenant_scope_group WHERE tenant_scope_group.id = c0_.group_id AND tenant_scope_group.tenant_id = '1'))) ORDER BY c0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.answer AS answer_2,
  t0.points AS points_3,
  t0.time_answer AS time_answer_4,
  t0.is_locked AS is_locked_5,
  t0.locked_at AS locked_at_6,
  t0.question_id AS question_id_7,
  t0.certification_id AS certification_id_8,
  t0.locked_by_id AS locked_by_id_9
FROM
  user_answer t0
WHERE
  t0.certification_id = ?

SELECT t0.id AS id_1, t0.answer AS answer_2, t0.points AS points_3, t0.time_answer AS time_answer_4, t0.is_locked AS is_locked_5, t0.locked_at AS locked_at_6, t0.question_id AS question_id_7, t0.certification_id AS certification_id_8, t0.locked_by_id AS locked_by_id_9 FROM user_answer t0 WHERE t0.certification_id = 1530;

SELECT
  t0.id AS id_1,
  t0.audit_date AS audit_date_2,
  t0.start_date AS start_date_3,
  t0.end_date AS end_date_4,
  t0.status AS status_5,
  t0.locality AS locality_6,
  t0.audit_scope AS audit_scope_7,
  t0.annotations AS annotations_8,
  t0.display_points AS display_points_9,
  t0.hubspot_deal_id AS hubspot_deal_id_10,
  t0.central_audit AS central_audit_11,
  t0.auditor_id AS auditor_id_12,
  t0.secondary_auditor_id AS secondary_auditor_id_13,
  t0.certification_id AS certification_id_14,
  t0.type_id AS type_id_15
FROM
  audit t0
WHERE
  t0.certification_id = ?
  AND (
    (
      (
        EXISTS (
          SELECT
            1
          FROM
            certification tenant_scope_cert
            INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_cert.hotel_id
          WHERE
            tenant_scope_cert.id = t0.certification_id
            AND tenant_scope_business.tenant_id = '1'
            AND tenant_scope_business.is_deleted = 0
        )
        OR EXISTS (
          SELECT
            1
          FROM
            certification tenant_scope_cert
            INNER JOIN `group` tenant_scope_group ON tenant_scope_group.id = tenant_scope_cert.group_id
          WHERE
            tenant_scope_cert.id = t0.certification_id
            AND tenant_scope_group.tenant_id = '1'
        )
      )
    )
  )
ORDER BY
  t0.audit_date ASC

SELECT t0.id AS id_1, t0.audit_date AS audit_date_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.status AS status_5, t0.locality AS locality_6, t0.audit_scope AS audit_scope_7, t0.annotations AS annotations_8, t0.display_points AS display_points_9, t0.hubspot_deal_id AS hubspot_deal_id_10, t0.central_audit AS central_audit_11, t0.auditor_id AS auditor_id_12, t0.secondary_auditor_id AS secondary_auditor_id_13, t0.certification_id AS certification_id_14, t0.type_id AS type_id_15 FROM audit t0 WHERE t0.certification_id = 1530 AND (((EXISTS (SELECT 1 FROM certification tenant_scope_cert INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_cert.hotel_id WHERE tenant_scope_cert.id = t0.certification_id AND tenant_scope_business.tenant_id = '1' AND tenant_scope_business.is_deleted = 0) OR EXISTS (SELECT 1 FROM certification tenant_scope_cert INNER JOIN `group` tenant_scope_group ON tenant_scope_group.id = tenant_scope_cert.group_id WHERE tenant_scope_cert.id = t0.certification_id AND tenant_scope_group.tenant_id = '1')))) ORDER BY t0.audit_date ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.version AS version_3,
  t0.version_time AS version_time_4,
  t0.is_active AS is_active_5,
  t0.points_visible AS points_visible_6,
  t0.custom_points_title1 AS custom_points_title1_7,
  t0.custom_points_weight1 AS custom_points_weight1_8,
  t0.custom_points_max1 AS custom_points_max1_9,
  t0.slug AS slug_10,
  t0.logo AS logo_11,
  t0.report_text AS report_text_12,
  t0.min_conformity AS min_conformity_13,
  t0.audit_help_file AS audit_help_file_14,
  t0.audit_help_file_auditor AS audit_help_file_auditor_15,
  t0.custom_points_element_id1 AS custom_points_element_id1_16,
  t0.help_pdf_de AS help_pdf_de_17,
  t0.help_pdf_en AS help_pdf_en_18,
  t0.help_pdf_es AS help_pdf_es_19,
  t0.help_pdf_it AS help_pdf_it_20,
  t0.help_pdf_fr AS help_pdf_fr_21,
  t0.external_id AS external_id_22
FROM
  questionaire t0
WHERE
  t0.id = ?
  AND (
    (
      EXISTS (
        SELECT
          1
        FROM
          questionaire_tenant tenant_scope_qt
        WHERE
          tenant_scope_qt.questionaire_id = t0.id
          AND tenant_scope_qt.tenant_id = '1'
      )
    )
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.version AS version_3, t0.version_time AS version_time_4, t0.is_active AS is_active_5, t0.points_visible AS points_visible_6, t0.custom_points_title1 AS custom_points_title1_7, t0.custom_points_weight1 AS custom_points_weight1_8, t0.custom_points_max1 AS custom_points_max1_9, t0.slug AS slug_10, t0.logo AS logo_11, t0.report_text AS report_text_12, t0.min_conformity AS min_conformity_13, t0.audit_help_file AS audit_help_file_14, t0.audit_help_file_auditor AS audit_help_file_auditor_15, t0.custom_points_element_id1 AS custom_points_element_id1_16, t0.help_pdf_de AS help_pdf_de_17, t0.help_pdf_en AS help_pdf_en_18, t0.help_pdf_es AS help_pdf_es_19, t0.help_pdf_it AS help_pdf_it_20, t0.help_pdf_fr AS help_pdf_fr_21, t0.external_id AS external_id_22 FROM questionaire t0 WHERE t0.id = 9 AND ((EXISTS (SELECT 1 FROM questionaire_tenant tenant_scope_qt WHERE tenant_scope_qt.questionaire_id = t0.id AND tenant_scope_qt.tenant_id = '1')));

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.is_primary AS is_primary_3,
  t0.verified_at AS verified_at_4,
  t0.tenant_id AS tenant_id_5
FROM
  tenant_domain t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.is_primary AS is_primary_3, t0.verified_at AS verified_at_4, t0.tenant_id AS tenant_id_5 FROM tenant_domain t0 WHERE t0.domain = 'dev.cat.greensign.de' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.sorting AS sorting_3,
  t0.weight AS weight_4,
  t0.finished_translations AS finished_translations_5,
  t0.external_id AS external_id_6,
  t0.questionaire_id AS questionaire_id_7
FROM
  part t0
WHERE
  t0.questionaire_id = ?
  AND (
    (
      EXISTS (
        SELECT
          1
        FROM
          questionaire_tenant tenant_scope_qt
        WHERE
          tenant_scope_qt.questionaire_id = t0.questionaire_id
          AND tenant_scope_qt.tenant_id = '1'
      )
    )
  )
ORDER BY
  t0.sorting ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.sorting AS sorting_3, t0.weight AS weight_4, t0.finished_translations AS finished_translations_5, t0.external_id AS external_id_6, t0.questionaire_id AS questionaire_id_7 FROM part t0 WHERE t0.questionaire_id = 9 AND ((EXISTS (SELECT 1 FROM questionaire_tenant tenant_scope_qt WHERE tenant_scope_qt.questionaire_id = t0.questionaire_id AND tenant_scope_qt.tenant_id = '1'))) ORDER BY t0.sorting ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.street AS street_3,
  t0.zip AS zip_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone_hotel AS phone_hotel_7,
  t0.email_hotel AS email_hotel_8,
  t0.contact_title AS contact_title_9,
  t0.contact_first_name AS contact_first_name_10,
  t0.contact_last_name AS contact_last_name_11,
  t0.contact_position AS contact_position_12,
  t0.contact_phone AS contact_phone_13,
  t0.contact_email AS contact_email_14,
  t0.contact_mobile AS contact_mobile_15,
  t0.hotel_group AS hotel_group_16,
  t0.rooms AS rooms_17,
  t0.website AS website_18,
  t0.dehoga_stars AS dehoga_stars_19,
  t0.dehoga_superior AS dehoga_superior_20,
  t0.hotel_region AS hotel_region_21,
  t0.time_created AS time_created_22,
  t0.greensign_id AS greensign_id_23,
  t0.ehotel_id AS ehotel_id_24,
  t0.image AS image_25,
  t0.geo_location AS geo_location_26,
  t0.rule_of_law_index_value AS rule_of_law_index_value_27,
  t0.rule_of_law_index_type AS rule_of_law_index_type_28,
  t0.is_deleted AS is_deleted_29,
  t0.user_id AS user_id_30,
  t0.tenant_id AS tenant_id_31
FROM
  hotel t0
WHERE
  t0.id = ?
  AND (
    (
      t0.tenant_id = '1'
      AND t0.is_deleted = 0
    )
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.street AS street_3, t0.zip AS zip_4, t0.city AS city_5, t0.country AS country_6, t0.phone_hotel AS phone_hotel_7, t0.email_hotel AS email_hotel_8, t0.contact_title AS contact_title_9, t0.contact_first_name AS contact_first_name_10, t0.contact_last_name AS contact_last_name_11, t0.contact_position AS contact_position_12, t0.contact_phone AS contact_phone_13, t0.contact_email AS contact_email_14, t0.contact_mobile AS contact_mobile_15, t0.hotel_group AS hotel_group_16, t0.rooms AS rooms_17, t0.website AS website_18, t0.dehoga_stars AS dehoga_stars_19, t0.dehoga_superior AS dehoga_superior_20, t0.hotel_region AS hotel_region_21, t0.time_created AS time_created_22, t0.greensign_id AS greensign_id_23, t0.ehotel_id AS ehotel_id_24, t0.image AS image_25, t0.geo_location AS geo_location_26, t0.rule_of_law_index_value AS rule_of_law_index_value_27, t0.rule_of_law_index_type AS rule_of_law_index_type_28, t0.is_deleted AS is_deleted_29, t0.user_id AS user_id_30, t0.tenant_id AS tenant_id_31 FROM hotel t0 WHERE t0.id = 975 AND ((t0.tenant_id = '1' AND t0.is_deleted = 0));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.tenant_id AS tenant_id_4
FROM
  `group` t0
  INNER JOIN business_group ON t0.id = business_group.group_id
WHERE
  business_group.business_id = ?
  AND (
    (
      (
        t0.tenant_id = '1'
        OR EXISTS (
          SELECT
            1
          FROM
            business_group tenant_scope_bg
            INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_bg.business_id
          WHERE
            tenant_scope_bg.group_id = t0.id
            AND tenant_scope_business.tenant_id = '1'
            AND tenant_scope_business.is_deleted = 0
        )
      )
    )
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.tenant_id AS tenant_id_4 FROM `group` t0 INNER JOIN business_group ON t0.id = business_group.group_id WHERE business_group.business_id = 975 AND (((t0.tenant_id = '1' OR EXISTS (SELECT 1 FROM business_group tenant_scope_bg INNER JOIN hotel tenant_scope_business ON tenant_scope_business.id = tenant_scope_bg.business_id WHERE tenant_scope_bg.group_id = t0.id AND tenant_scope_business.tenant_id = '1' AND tenant_scope_business.is_deleted = 0))));