Query Metrics
9
Database Queries
7
Different statements
4.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.01 ms (24.35%) |
2 |
"COMMIT"
Parameters:
[] |
|
0.76 ms (18.32%) |
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')
Parameters:
[
1
]
|
|
0.69 ms (16.59%) |
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
Parameters:
[ "koji@motorists.jp" 1 ] |
|
0.50 ms (12.08%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
|
0.47 ms (11.26%) |
1 |
UPDATE dtb_member SET login_date = ?, update_date = ? WHERE id = ?
Parameters:
[ "2025-12-26 12:38:55" "2025-12-26 12:38:55" 3 ] |
|
0.39 ms (9.33%) |
1 |
INSERT INTO dtb_login_history (user_name, client_ip, create_date, update_date, login_history_status_id, member_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "koji@motorists.jp" "119.83.229.64" "2025-12-26 12:38:55" "2025-12-26 12:38:55" 1 3 "loginhistory" ] |
|
0.33 ms (8.08%) |
2 |
"START TRANSACTION"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| Eccube\Entity\AbstractEntity | No errors. |
| Eccube\Entity\Member | No errors. |
| Eccube\Entity\Master\AbstractMasterEntity | No errors. |
| Eccube\Entity\Master\Work | No errors. |
| Eccube\Entity\Master\Authority | No errors. |
| Eccube\Entity\Master\LoginHistoryStatus | No errors. |
| Eccube\Entity\LoginHistory | No errors. |