Symfony Profiler

SELECT
  t0.order_approval_threshold AS order_approval_threshold_1,
  t0.id AS id_2,
  t0.path AS path_3,
  t0.level AS level_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.roles AS roles_7,
  t0.password AS password_8,
  t0.fullname AS fullname_9,
  t0.vocative_name AS vocative_name_10,
  t0.last_login AS last_login_11,
  t0.past_login AS past_login_12,
  t0.last_api_activity AS last_api_activity_13,
  t0.client_version AS client_version_14,
  t0.client_ip_address AS client_ip_address_15,
  t0.client_hostname AS client_hostname_16,
  t0.active AS active_17,
  t0.chat_enabled AS chat_enabled_18,
  t0.employee AS employee_19,
  t0.working_hours AS working_hours_20,
  t0.attendance_notifications AS attendance_notifications_21,
  t0.webauthn_user_handle AS webauthn_user_handle_22,
  t0.force_password_change AS force_password_change_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.created_by AS created_by_26,
  t0.updated_by AS updated_by_27,
  t0.parent_id AS parent_id_28
FROM
  users t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.order_approval_threshold AS order_approval_threshold_1, t0.id AS id_2, t0.path AS path_3, t0.level AS level_4, t0.email AS email_5, t0.phone AS phone_6, t0.roles AS roles_7, t0.password AS password_8, t0.fullname AS fullname_9, t0.vocative_name AS vocative_name_10, t0.last_login AS last_login_11, t0.past_login AS past_login_12, t0.last_api_activity AS last_api_activity_13, t0.client_version AS client_version_14, t0.client_ip_address AS client_ip_address_15, t0.client_hostname AS client_hostname_16, t0.active AS active_17, t0.chat_enabled AS chat_enabled_18, t0.employee AS employee_19, t0.working_hours AS working_hours_20, t0.attendance_notifications AS attendance_notifications_21, t0.webauthn_user_handle AS webauthn_user_handle_22, t0.force_password_change AS force_password_change_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.created_by AS created_by_26, t0.updated_by AS updated_by_27, t0.parent_id AS parent_id_28 FROM users t0 WHERE t0.email = 'krasova@rebis.cz' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.device_token AS device_token_2,
  t0.device_name AS device_name_3,
  t0.device_type AS device_type_4,
  t0.operating_system AS operating_system_5,
  t0.client_version AS client_version_6,
  t0.hostname AS hostname_7,
  t0.ip_address AS ip_address_8,
  t0.user_agent AS user_agent_9,
  t0.created_at AS created_at_10,
  t0.last_active_at AS last_active_at_11,
  t0.last_user_activity_at AS last_user_activity_at_12,
  t0.last_login_at AS last_login_at_13,
  t0.is_active AS is_active_14,
  t0.push_enabled AS push_enabled_15,
  t0.push_token AS push_token_16,
  t0.apns_sandbox AS apns_sandbox_17,
  t0.login_count AS login_count_18,
  t0.user_id AS user_id_19
FROM
  user_device t0
WHERE
  t0.user_id = ?
  AND t0.ip_address = ?
  AND t0.is_active = ?
ORDER BY
  t0.last_active_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.device_token AS device_token_2, t0.device_name AS device_name_3, t0.device_type AS device_type_4, t0.operating_system AS operating_system_5, t0.client_version AS client_version_6, t0.hostname AS hostname_7, t0.ip_address AS ip_address_8, t0.user_agent AS user_agent_9, t0.created_at AS created_at_10, t0.last_active_at AS last_active_at_11, t0.last_user_activity_at AS last_user_activity_at_12, t0.last_login_at AS last_login_at_13, t0.is_active AS is_active_14, t0.push_enabled AS push_enabled_15, t0.push_token AS push_token_16, t0.apns_sandbox AS apns_sandbox_17, t0.login_count AS login_count_18, t0.user_id AS user_id_19 FROM user_device t0 WHERE t0.user_id = 15 AND t0.ip_address = '88.100.55.54' AND t0.is_active = 1 ORDER BY t0.last_active_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.device_token AS device_token_2,
  t0.device_name AS device_name_3,
  t0.device_type AS device_type_4,
  t0.operating_system AS operating_system_5,
  t0.client_version AS client_version_6,
  t0.hostname AS hostname_7,
  t0.ip_address AS ip_address_8,
  t0.user_agent AS user_agent_9,
  t0.created_at AS created_at_10,
  t0.last_active_at AS last_active_at_11,
  t0.last_user_activity_at AS last_user_activity_at_12,
  t0.last_login_at AS last_login_at_13,
  t0.is_active AS is_active_14,
  t0.push_enabled AS push_enabled_15,
  t0.push_token AS push_token_16,
  t0.apns_sandbox AS apns_sandbox_17,
  t0.login_count AS login_count_18,
  t0.user_id AS user_id_19
FROM
  user_device t0
WHERE
  t0.user_id = ?
  AND t0.is_active = ?
ORDER BY
  t0.last_active_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.device_token AS device_token_2, t0.device_name AS device_name_3, t0.device_type AS device_type_4, t0.operating_system AS operating_system_5, t0.client_version AS client_version_6, t0.hostname AS hostname_7, t0.ip_address AS ip_address_8, t0.user_agent AS user_agent_9, t0.created_at AS created_at_10, t0.last_active_at AS last_active_at_11, t0.last_user_activity_at AS last_user_activity_at_12, t0.last_login_at AS last_login_at_13, t0.is_active AS is_active_14, t0.push_enabled AS push_enabled_15, t0.push_token AS push_token_16, t0.apns_sandbox AS apns_sandbox_17, t0.login_count AS login_count_18, t0.user_id AS user_id_19 FROM user_device t0 WHERE t0.user_id = 15 AND t0.is_active = 1 ORDER BY t0.last_active_at DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO entity_audit (
  entity_class, entity_id, action, old_values,
  new_values, changed_fields, created_at,
  user_id, ip_address, user_agent,
  comment
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO entity_audit (entity_class, entity_id, action, old_values, new_values, changed_fields, created_at, user_id, ip_address, user_agent, comment) VALUES ('App\\Entity\\User', 15, 'UPDATE', '{\"lastApiActivity\":\"2026-01-18 12:25:45\"}', '{\"lastApiActivity\":\"2026-01-18 12:26:17\"}', '[\"lastApiActivity\"]', '2026-01-18 12:26:17', 15, '88.100.55.54', 'ourApp/1.2.0 (Mac OS X 26.2; desktop)', NULL);

UPDATE
  users
SET
  last_api_activity = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE users SET last_api_activity = '2026-01-18 12:26:17', updated_at = '2026-01-18 12:26:17' WHERE id = 15;

"COMMIT"

"COMMIT";