Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.logo AS logo_4,
  t0.email AS email_5,
  t0.email_password AS email_password_6,
  t0.email_smtp_host AS email_smtp_host_7,
  t0.email_smtp_port AS email_smtp_port_8,
  t0.invoice_number_counter AS invoice_number_counter_9,
  t0.is_maintenance_mode AS is_maintenance_mode_10,
  t0.currency AS currency_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.u_date AS u_date_16
FROM
  settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.logo AS logo_4, t0.email AS email_5, t0.email_password AS email_password_6, t0.email_smtp_host AS email_smtp_host_7, t0.email_smtp_port AS email_smtp_port_8, t0.invoice_number_counter AS invoice_number_counter_9, t0.is_maintenance_mode AS is_maintenance_mode_10, t0.currency AS currency_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.u_date AS u_date_16 FROM settings t0 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 = ?
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 = 'f68626df7d6e2a53597afeb9ef7ea620' 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 = 795;

"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 ('2026-03-21 12:56:56', 'eeaf89d331331a8894c00aff7cf216458872bc89d83f5e371cf9775a73536d46', '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, 795);

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

UPDATE email_message_recipients SET last_opened_at = '2026-03-21 12:56:56', open_count = 20, last_opened_user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' WHERE id = 795;

"COMMIT"

"COMMIT";