Symfony Profiler

SET
  SESSION time_zone = '+00:00'

SET SESSION time_zone = '+00:00';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.department AS department_3,
  t0.login_id AS login_id_4,
  t0.password AS password_5,
  t0.salt AS salt_6,
  t0.sort_no AS sort_no_7,
  t0.two_factor_auth_key AS two_factor_auth_key_8,
  t0.two_factor_auth_enabled AS two_factor_auth_enabled_9,
  t0.create_date AS create_date_10,
  t0.update_date AS update_date_11,
  t0.login_date AS login_date_12,
  t0.work_id AS work_id_13,
  t0.authority_id AS authority_id_14,
  t0.creator_id AS creator_id_15,
  t0.discriminator_type
FROM
  dtb_member t0
WHERE
  t0.login_id = ?
  AND t0.work_id = ?
  AND t0.discriminator_type IN ('member')
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.department AS department_3, t0.login_id AS login_id_4, t0.password AS password_5, t0.salt AS salt_6, t0.sort_no AS sort_no_7, t0.two_factor_auth_key AS two_factor_auth_key_8, t0.two_factor_auth_enabled AS two_factor_auth_enabled_9, t0.create_date AS create_date_10, t0.update_date AS update_date_11, t0.login_date AS login_date_12, t0.work_id AS work_id_13, t0.authority_id AS authority_id_14, t0.creator_id AS creator_id_15, t0.discriminator_type FROM dtb_member t0 WHERE t0.login_id = 'Atelier' AND t0.work_id = 1 AND t0.discriminator_type IN ('member') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sort_no AS sort_no_3,
  t0.discriminator_type
FROM
  mtb_login_history_status t0
WHERE
  t0.id = ?
  AND t0.discriminator_type IN ('loginhistorystatus')

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_login_history_status t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('loginhistorystatus');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO dtb_login_history (
  user_name, client_ip, create_date,
  update_date, login_history_status_id,
  member_id, discriminator_type
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO dtb_login_history (user_name, client_ip, create_date, update_date, login_history_status_id, member_id, discriminator_type) VALUES ('Atelier', '153.209.56.34', '2025-07-02 04:08:56', '2025-07-02 04:08:56', 1, 10, 'loginhistory');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  dtb_member
SET
  login_date = ?,
  update_date = ?
WHERE
  id = ?

UPDATE dtb_member SET login_date = '2025-07-02 04:08:56', update_date = '2025-07-02 04:08:56' WHERE id = 10;

"COMMIT"

"COMMIT";