Symfony Profiler

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.logo_url AS logo_url_4,
  t0.favicon_url AS favicon_url_5,
  t0.primary_color AS primary_color_6,
  t0.secondary_color AS secondary_color_7,
  t0.tertiary_color AS tertiary_color_8,
  t0.email_from_address AS email_from_address_9,
  t0.email_from_name AS email_from_name_10,
  t0.email_notificationddress AS email_notificationddress_11,
  t0.features AS features_12,
  t0.gsid_prefix AS gsid_prefix_13,
  t0.is_active AS is_active_14,
  t0.created_at AS created_at_15
FROM
  tenant t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo_url AS logo_url_4, t0.favicon_url AS favicon_url_5, t0.primary_color AS primary_color_6, t0.secondary_color AS secondary_color_7, t0.tertiary_color AS tertiary_color_8, t0.email_from_address AS email_from_address_9, t0.email_from_name AS email_from_name_10, t0.email_notificationddress AS email_notificationddress_11, t0.features AS features_12, t0.gsid_prefix AS gsid_prefix_13, t0.is_active AS is_active_14, t0.created_at AS created_at_15 FROM tenant t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.locale AS locale_7,
  t0.api_token AS api_token_8,
  t0.signature AS signature_9,
  t0.position_description AS position_description_10,
  t0.is_active AS is_active_11,
  t0.first_logged_in_at AS first_logged_in_at_12,
  t0.tenant_id AS tenant_id_13
FROM
  user t0
WHERE
  t0.email = ?
  AND (
    (t0.tenant_id = '1')
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.locale AS locale_7, t0.api_token AS api_token_8, t0.signature AS signature_9, t0.position_description AS position_description_10, t0.is_active AS is_active_11, t0.first_logged_in_at AS first_logged_in_at_12, t0.tenant_id AS tenant_id_13 FROM user t0 WHERE t0.email = 'florian@greensign.de' AND ((t0.tenant_id = '1')) 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
  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.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.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))));

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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user_answer
SET
  locked_at = ?
WHERE
  id = ?

UPDATE user_answer SET locked_at = '2026-07-22 14:25:03' WHERE id = 182274;

"COMMIT"

"COMMIT";

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
  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.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
  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 = '65' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Part';

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 = '66' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Part';

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 = '67' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Part';

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 = '68' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Part';

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 = '69' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Part';

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 = '70' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Part';

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 = '71' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Part';

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 = '72' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Questionaire\\Part';

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