Symfony Profiler

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,
  t17.id AS id_16,
  t17.id_token AS id_token_18,
  t17.member_id AS member_id_19,
  t0.discriminator_type
FROM
  dtb_member t0
  LEFT JOIN plg_site_kit_id_token t17 ON t17.member_id = t0.id
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, t17.id AS id_16, t17.id_token AS id_token_18, t17.member_id AS member_id_19, t0.discriminator_type FROM dtb_member t0 LEFT JOIN plg_site_kit_id_token t17 ON t17.member_id = t0.id WHERE t0.login_id = 'adminpro' AND t0.work_id = 1 AND t0.discriminator_type IN ('member') LIMIT 1;

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 ('adminpro', '124.110.230.167', '2024-11-22 00:49:35', '2024-11-22 00:49:35', 1, 2, 'loginhistory');

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');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE dtb_member SET login_date = '2024-11-22 00:49:35', update_date = '2024-11-22 00:49:35' WHERE id = 2;

SET
  SESSION time_zone = '+00:00'

SET SESSION time_zone = '+00:00';