Query Metrics
5
Database Queries
5
Different statements
16.84 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 12.63 ms |
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 | 0.35 ms |
SELECT MAX(r0_.d_no) AS sclr_0 FROM repeat_line_webhook r0_
Parameters:
[] |
3 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 0.93 ms |
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" ] |
5 | 2.81 ms |
"COMMIT"
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. |