Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.recipient_email AS recipient_email_2,
  t0.open_token AS open_token_3,
  t0.opened AS opened_4,
  t0.first_opened_at AS first_opened_at_5,
  t0.last_opened_at AS last_opened_at_6,
  t0.open_count AS open_count_7,
  t0.last_opened_ip_hash AS last_opened_ip_hash_8,
  t0.last_opened_user_agent AS last_opened_user_agent_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.u_date AS u_date_14,
  t0.email_message_id AS email_message_id_15
FROM
  email_message_recipients t0
WHERE
  t0.open_token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.recipient_email AS recipient_email_2, t0.open_token AS open_token_3, t0.opened AS opened_4, t0.first_opened_at AS first_opened_at_5, t0.last_opened_at AS last_opened_at_6, t0.open_count AS open_count_7, t0.last_opened_ip_hash AS last_opened_ip_hash_8, t0.last_opened_user_agent AS last_opened_user_agent_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.u_date AS u_date_14, t0.email_message_id AS email_message_id_15 FROM email_message_recipients t0 WHERE t0.open_token = '434beccc9b2f7ae9f5dc7bd787f63b66' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.opened_at AS opened_at_2,
  t0.ip_hash AS ip_hash_3,
  t0.user_agent AS user_agent_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.u_date AS u_date_9,
  t0.recipient_id AS recipient_id_10
FROM
  email_open_events t0
WHERE
  t0.recipient_id = ?

SELECT t0.id AS id_1, t0.opened_at AS opened_at_2, t0.ip_hash AS ip_hash_3, t0.user_agent AS user_agent_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.u_date AS u_date_9, t0.recipient_id AS recipient_id_10 FROM email_open_events t0 WHERE t0.recipient_id = 319;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO email_open_events (
  opened_at, ip_hash, user_agent, created_at,
  updated_at, created_by, updated_by,
  u_date, recipient_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO email_open_events (opened_at, ip_hash, user_agent, created_at, updated_at, created_by, updated_by, u_date, recipient_id) VALUES ('2025-12-19 07:04:49', '2692aeffcc058dd945f943288291031d6b8b8c06b3ab1622cf82c52dbd787c68', 'Mozilla/4.0 (compatible; ms-office; MSOffice 16)', NULL, NULL, 'emre@decopierrenature.com', 'emre@decopierrenature.com', NULL, 319);

UPDATE
  email_message_recipients
SET
  last_opened_at = ?,
  open_count = ?
WHERE
  id = ?

UPDATE email_message_recipients SET last_opened_at = '2025-12-19 07:04:49', open_count = 16 WHERE id = 319;

"COMMIT"

"COMMIT";