Query Metrics
5
Database Queries
5
Different statements
16.84 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
12.63 ms (74.98%) |
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" "U811de33280f21bcc55ccd94ef4bbaf34" ] |
2.81 ms (16.69%) |
1 |
"COMMIT"
Parameters:
[] |
0.93 ms (5.49%) |
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 10902 "【本番】日本第一製薬" "CART_LINK" ""{\"customer_id\":\"4512206693\",\"channel_id\":\"3675339148\",\"line_user_id\":\"U811de33280f21bcc55ccd94ef4bbaf34\",\"link_method\":null,\"crm_connection_id\":\"4824693527\",\"received_at\":\"2025-01-18T07:39:33.694Z\",\"name\":\"\\u5c71\\u53e3\\u6075\",\"tel\":\"08062068400\",\"mail\":null,\"last_name\":null,\"first_name\":null,\"last_name_kana\":null,\"first_name_kana\":null}"" "U811de33280f21bcc55ccd94ef4bbaf34" "2025-01-18 16:39:33" "2025-01-18 16:39:33" ] |
0.35 ms (2.08%) |
1 |
SELECT MAX(r0_.d_no) AS sclr_0 FROM repeat_line_webhook r0_
Parameters:
[] |
0.13 ms (0.75%) |
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. |