Query Metrics
5
Database Queries
5
Different statements
30.45 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
22.49 ms (73.88%) |
1 |
SELECT t0.tenant_cd AS tenant_cd_1, t0.d_no AS d_no_2, t0.repeat_line_trigger AS repeat_line_trigger_3, t0.repeat_line_action AS repeat_line_action_4, t0.cart_link AS cart_link_5, t0.line_user_id AS line_user_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM repeat_line_webhook t0 WHERE t0.repeat_line_action = ? AND t0.line_user_id = ? ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[ "CART_LINK" "U9743fbeadbb282304cfb0de48a4fbead" ] |
3.87 ms (12.72%) |
1 |
"COMMIT"
Parameters:
[] |
2.30 ms (7.56%) |
1 |
INSERT INTO repeat_line_webhook (tenant_cd, d_no, repeat_line_trigger, repeat_line_action, cart_link, line_user_id, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 8758 "【本番】日本第一製薬" "CART_LINK" ""{\"customer_id\":\"4237229708\",\"channel_id\":\"3675339148\",\"line_user_id\":\"U9743fbeadbb282304cfb0de48a4fbead\",\"link_method\":null,\"crm_connection_id\":\"4824693527\",\"received_at\":\"2024-05-14T00:45:49.705Z\",\"name\":\"\\u77e2\\u6728\\u3000\\u6625\\u9999\",\"tel\":\"09039544736\",\"mail\":null,\"last_name\":null,\"first_name\":null,\"last_name_kana\":null,\"first_name_kana\":null}"" "U9743fbeadbb282304cfb0de48a4fbead" "2024-05-14 09:45:49" "2024-05-14 09:45:49" ] |
1.50 ms (4.94%) |
1 |
SELECT MAX(r0_.d_no) AS sclr_0 FROM repeat_line_webhook r0_
Parameters:
[] |
0.27 ms (0.90%) |
1 |
"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 |
---|---|
App\Entity\RepeatLineWebhook | No errors. |