Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1304
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Migrations
• Debug
• Emails
• Workflow
• Configuration

Query Metrics

SET SESSION time_zone = '+00:00'

[]

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

[
  "koji@motorists.jp"
  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 = ?
  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 = 'koji@motorists.jp' 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')

[
  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"

"START TRANSACTION";

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

[
  "koji@motorists.jp"
  "119.83.229.64"
  "2025-12-26 12:38:55"
  "2025-12-26 12:38:55"
  1
  3
  "loginhistory"
]

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 ('koji@motorists.jp', '119.83.229.64', '2025-12-26 12:38:55', '2025-12-26 12:38:55', 1, 3, 'loginhistory');

"COMMIT"

[]

"COMMIT"

"COMMIT";

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

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

[
  "2025-12-26 12:38:55"
  "2025-12-26 12:38:55"
  3
]

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

UPDATE dtb_member SET login_date = '2025-12-26 12:38:55', update_date = '2025-12-26 12:38:55' WHERE id = 3;

"COMMIT"

[]

"COMMIT"

"COMMIT";