Symfony Profiler

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

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

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
  t0.id AS id_1,
  t0.event_id AS event_id_2,
  t0.event_type AS event_type_3,
  t0.site_uid AS site_uid_4,
  t0.occurred_at AS occurred_at_5,
  t0.raw_json AS raw_json_6,
  t0.signature_alg AS signature_alg_7,
  t0.correlation_id AS correlation_id_8,
  t0.status AS status_9,
  t0.app_id AS app_id_10,
  t0.link_type AS link_type_11,
  t0.received_at AS received_at_12,
  t0.processed_at AS processed_at_13,
  t0.note AS note_14
FROM
  energy_bridge_event t0
WHERE
  t0.event_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.event_id AS event_id_2, t0.event_type AS event_type_3, t0.site_uid AS site_uid_4, t0.occurred_at AS occurred_at_5, t0.raw_json AS raw_json_6, t0.signature_alg AS signature_alg_7, t0.correlation_id AS correlation_id_8, t0.status AS status_9, t0.app_id AS app_id_10, t0.link_type AS link_type_11, t0.received_at AS received_at_12, t0.processed_at AS processed_at_13, t0.note AS note_14 FROM energy_bridge_event t0 WHERE t0.event_id = 'b54788d77b8754612efb16d961d69377328789698ff188ed7e3a4a45c7204bb6' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.site_uid AS site_uid_2,
  t0.app_id AS app_id_3,
  t0.link_type AS link_type_4,
  t0.customer_id AS customer_id_5,
  t0.project_id AS project_id_6,
  t0.note AS note_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  energy_bridge_site_link t0
WHERE
  t0.site_uid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_uid AS site_uid_2, t0.app_id AS app_id_3, t0.link_type AS link_type_4, t0.customer_id AS customer_id_5, t0.project_id AS project_id_6, t0.note AS note_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM energy_bridge_site_link t0 WHERE t0.site_uid = '321' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO energy_bridge_event (
  event_id, event_type, site_uid, occurred_at,
  raw_json, signature_alg, correlation_id,
  STATUS, app_id, link_type, received_at,
  processed_at, note
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO energy_bridge_event (event_id, event_type, site_uid, occurred_at, raw_json, signature_alg, correlation_id, STATUS, app_id, link_type, received_at, processed_at, note) VALUES ('b54788d77b8754612efb16d961d69377328789698ff188ed7e3a4a45c7204bb6', 'ems.kpi.finalized', '321', '2026-07-29 00:00:00', '{\"schema_version\":\"1.0\",\"event_type\":\"ems.kpi.finalized\",\"event_id\":\"b54788d77b8754612efb16d961d69377328789698ff188ed7e3a4a45c7204bb6\",\"occurred_at\":\"2026-07-29\",\"source\":{\"system\":\"honeycore-cloud\",\"site_uid\":\"321\"},\"data\":{\"marker\":20260729,\"period\":\"day\",\"generation_kwh\":182.52,\"peak_pv_kw\":182.15,\"uptime_pct\":20.8,\"grid_import_kwh\":0,\"grid_export_kwh\":0,\"performance_ratio\":null,\"savings_amount\":2190.23,\"currency\":\"BDT\",\"co2_avoided_kg\":127.76}}', 'hmac-sha256', 'eb_6a6a98b1b60005.34000366', 'unlinked', NULL, NULL, '2026-07-30 06:22:03', NULL, 'no site-link for site_uid=321 — landed, no business action');

"COMMIT"

"COMMIT";