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 = '625324ab42703ec640186ca5fca6b594' 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 = 314;

"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:44:59', 'f12c451f5ed3b26e01a6d1c3fd6e0429a370c0fe48128873746578d6af563e55', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', NULL, NULL, 'emre@decopierrenature.com', 'emre@decopierrenature.com', NULL, 314);

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

UPDATE email_message_recipients SET last_opened_at = '2025-12-19 07:44:59', open_count = 10, last_opened_user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' WHERE id = 314;

"COMMIT"

"COMMIT";