Query Metrics
9
Database Queries
7
Different statements
7.83 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.27 ms (67.34%) |
1 |
UPDATE dtb_member SET login_date = ?, update_date = ? WHERE id = ?
Parameters:
[ "2024-11-15 06:47:54" "2024-11-15 06:47:54" 1 ] |
0.88 ms (11.20%) |
1 |
INSERT INTO dtb_login_history (user_name, client_ip, create_date, update_date, login_history_status_id, member_id, discriminator_type) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "motto" "60.62.213.247" "2024-11-15 06:47:54" "2024-11-15 06:47:54" 1 1 "loginhistory" ] |
0.85 ms (10.79%) |
2 |
"COMMIT"
Parameters:
[] |
0.31 ms (4.02%) |
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:
[ "motto" 1 ] |
0.21 ms (2.63%) |
1 |
SET SESSION time_zone = '+00:00'
Parameters:
[] |
0.20 ms (2.52%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.12 ms (1.50%) |
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
]
|
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\Product | No errors. |
Eccube\Entity\BaseInfo | No errors. |
Eccube\Entity\Page | No errors. |
Eccube\Entity\PageLayout | No errors. |
Eccube\Entity\Block | No errors. |
Eccube\Entity\BlockPosition | No errors. |
Eccube\Entity\Master\AbstractMasterEntity | No errors. |
Eccube\Entity\Master\DeviceType | No errors. |
Eccube\Entity\AuthorityRole | No errors. |
Eccube\Entity\Layout | No errors. |
Eccube\Entity\Member | 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. |
Eccube\Entity\Delivery | No errors. |