Symfony Profiler

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = DATABASE()
  AND table_name = 'platform_setting'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = 'platform_setting';

SELECT
  setting_value
FROM
  platform_setting
WHERE
  name = ?
  AND app_id IS NULL
LIMIT
  1

SELECT setting_value FROM platform_setting WHERE name = 'subscription_enforcement_enabled' AND app_id IS NULL LIMIT 1;

SELECT
  n0_.id AS id_0,
  n0_.app_id AS app_id_1,
  n0_.company_id AS company_id_2,
  n0_.title AS title_3,
  n0_.body AS body_4,
  n0_.type AS type_5,
  n0_.audience AS audience_6,
  n0_.audience_ref_id AS audience_ref_id_7,
  n0_.priority AS priority_8,
  n0_.pinned AS pinned_9,
  n0_.require_ack AS require_ack_10,
  n0_.effective_from AS effective_from_11,
  n0_.effective_to AS effective_to_12,
  n0_.source AS source_13,
  n0_.status AS status_14,
  n0_.created_by AS created_by_15,
  n0_.created_at AS created_at_16,
  n0_.updated_at AS updated_at_17,
  n0_.delete_flag AS delete_flag_18
FROM
  notice n0_
WHERE
  n0_.app_id = ?
  AND (
    (
      n0_.delete_flag IS NULL
      OR n0_.delete_flag = 0
    )
  )
  AND n0_.status = 'published'
  AND (
    (
      n0_.effective_from IS NULL
      OR n0_.effective_from <= ?
    )
  )
  AND (
    (
      n0_.effective_to IS NULL
      OR n0_.effective_to >= ?
    )
  )
  AND (
    n0_.audience = 'all'
    OR (
      n0_.audience = 'employee'
      AND n0_.audience_ref_id = ?
    )
    OR (
      n0_.audience = 'department'
      AND n0_.audience_ref_id = ?
    )
    OR (
      n0_.audience = 'designation'
      AND n0_.audience_ref_id = ?
    )
  )
ORDER BY
  n0_.pinned DESC,
  n0_.created_at DESC
LIMIT
  100

SELECT n0_.id AS id_0, n0_.app_id AS app_id_1, n0_.company_id AS company_id_2, n0_.title AS title_3, n0_.body AS body_4, n0_.type AS type_5, n0_.audience AS audience_6, n0_.audience_ref_id AS audience_ref_id_7, n0_.priority AS priority_8, n0_.pinned AS pinned_9, n0_.require_ack AS require_ack_10, n0_.effective_from AS effective_from_11, n0_.effective_to AS effective_to_12, n0_.source AS source_13, n0_.status AS status_14, n0_.created_by AS created_by_15, n0_.created_at AS created_at_16, n0_.updated_at AS updated_at_17, n0_.delete_flag AS delete_flag_18 FROM notice n0_ WHERE n0_.app_id = 0 AND ((n0_.delete_flag IS NULL OR n0_.delete_flag = 0)) AND n0_.status = 'published' AND ((n0_.effective_from IS NULL OR n0_.effective_from <= '2026-09-08 22:18:34')) AND ((n0_.effective_to IS NULL OR n0_.effective_to >= '2026-09-08 00:00:00')) AND (n0_.audience = 'all' OR (n0_.audience = 'employee' AND n0_.audience_ref_id = 0) OR (n0_.audience = 'department' AND n0_.audience_ref_id = 0) OR (n0_.audience = 'designation' AND n0_.audience_ref_id = 0)) ORDER BY n0_.pinned DESC, n0_.created_at DESC LIMIT 100;

SELECT
  data
FROM
  acc_setting
WHERE
  name = 'cors_extra_origins'
ORDER BY
  id DESC
LIMIT
  1

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;

SELECT
  n0_.notice_id AS notice_id_0
FROM
  notice_acknowledgement n0_
WHERE
  n0_.app_id = ?
  AND n0_.user_id = ?
  AND n0_.seen_at IS NOT NULL

SELECT n0_.notice_id AS notice_id_0 FROM notice_acknowledgement n0_ WHERE n0_.app_id = 0 AND n0_.user_id = 52 AND n0_.seen_at IS NOT NULL;

SELECT
  n0_.notice_id AS notice_id_0
FROM
  notice_acknowledgement n0_
WHERE
  n0_.app_id = ?
  AND n0_.user_id = ?
  AND n0_.acknowledged_at IS NOT NULL

SELECT n0_.notice_id AS notice_id_0 FROM notice_acknowledgement n0_ WHERE n0_.app_id = 0 AND n0_.user_id = 52 AND n0_.acknowledged_at IS NOT NULL;