Query Metrics
40
Database Queries
6
Different statements
78.44 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 10.91 ms |
"START TRANSACTION"
Parameters:
[] |
| 2 | 1.58 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "OPENWEB_REGISTER_USER-START" "{"userId":90,"codeA":"codea_o0rBcuZP5ALK4kuC8YJ8Cau0S4j911z3Mw4M0oFEJ3pI","isBlog":false}" null "6a60c565ce4d1" "2026-07-22 13:28:05" "2026-07-22 13:28:05" null ] |
| 3 | 3.30 ms |
"COMMIT"
Parameters:
[] |
| 4 | 2.05 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.one_time_authorization_code AS one_time_authorization_code_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.display_name_open_web AS display_name_open_web_10, t0.blue_snap_shopper_id AS blue_snap_shopper_id_11, t0.subscription_cancelled_at AS subscription_cancelled_at_12, t0.registration_ip AS registration_ip_13, t0.notified_at AS notified_at_14, t0.timestamp AS timestamp_15, t0.is_created_as_non_paying AS is_created_as_non_paying_16, t0.package_amount AS package_amount_17, t0.package_frequency AS package_frequency_18, t0.subscription_date AS subscription_date_19, t0.type_before_cancel AS type_before_cancel_20, t0.last_cancel_reason AS last_cancel_reason_21, t0.lang AS lang_22, t0.package_currency AS package_currency_23, t0.is_created_as_commenter AS is_created_as_commenter_24, t0.is_created_as_reader AS is_created_as_reader_25, t0.is_created_as_follower AS is_created_as_follower_26, t0.payment_source AS payment_source_27, t0.totp_secret AS totp_secret_28, t0.registration_country AS registration_country_29, t0.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
90
]
|
| 5 | 3.36 ms |
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
"6a60c565ce4d1"
]
|
| 6 | 0.55 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 0.81 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.000","output":""}" "2026-07-22 13:28:05" 718555 ] |
| 8 | 2.33 ms |
"COMMIT"
Parameters:
[] |
| 9 | 1.10 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.one_time_authorization_code AS one_time_authorization_code_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.display_name_open_web AS display_name_open_web_10, t0.blue_snap_shopper_id AS blue_snap_shopper_id_11, t0.subscription_cancelled_at AS subscription_cancelled_at_12, t0.registration_ip AS registration_ip_13, t0.notified_at AS notified_at_14, t0.timestamp AS timestamp_15, t0.is_created_as_non_paying AS is_created_as_non_paying_16, t0.package_amount AS package_amount_17, t0.package_frequency AS package_frequency_18, t0.subscription_date AS subscription_date_19, t0.type_before_cancel AS type_before_cancel_20, t0.last_cancel_reason AS last_cancel_reason_21, t0.lang AS lang_22, t0.package_currency AS package_currency_23, t0.is_created_as_commenter AS is_created_as_commenter_24, t0.is_created_as_reader AS is_created_as_reader_25, t0.is_created_as_follower AS is_created_as_follower_26, t0.payment_source AS payment_source_27, t0.totp_secret AS totp_secret_28, t0.registration_country AS registration_country_29, t0.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
90
]
|
| 10 | 3.26 ms |
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
"6a60c565ce4d1"
]
|
| 11 | 0.78 ms |
"START TRANSACTION"
Parameters:
[] |
| 12 | 0.90 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "OPENWEB_REGISTER_USER-FIND_USER" "{"userId":90}" null "6a60c565ce4d1" "2026-07-22 13:28:05" "2026-07-22 13:28:05" null ] |
| 13 | 2.74 ms |
"COMMIT"
Parameters:
[] |
| 14 | 0.99 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.one_time_authorization_code AS one_time_authorization_code_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.display_name_open_web AS display_name_open_web_10, t0.blue_snap_shopper_id AS blue_snap_shopper_id_11, t0.subscription_cancelled_at AS subscription_cancelled_at_12, t0.registration_ip AS registration_ip_13, t0.notified_at AS notified_at_14, t0.timestamp AS timestamp_15, t0.is_created_as_non_paying AS is_created_as_non_paying_16, t0.package_amount AS package_amount_17, t0.package_frequency AS package_frequency_18, t0.subscription_date AS subscription_date_19, t0.type_before_cancel AS type_before_cancel_20, t0.last_cancel_reason AS last_cancel_reason_21, t0.lang AS lang_22, t0.package_currency AS package_currency_23, t0.is_created_as_commenter AS is_created_as_commenter_24, t0.is_created_as_reader AS is_created_as_reader_25, t0.is_created_as_follower AS is_created_as_follower_26, t0.payment_source AS payment_source_27, t0.totp_secret AS totp_secret_28, t0.registration_country AS registration_country_29, t0.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
90
]
|
| 15 | 3.79 ms |
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
"6a60c565ce4d1"
]
|
| 16 | 0.72 ms |
"START TRANSACTION"
Parameters:
[] |
| 17 | 3.05 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.000","output":{"userId":90}}" "2026-07-22 13:28:05" 718556 ] |
| 18 | 2.34 ms |
"COMMIT"
Parameters:
[] |
| 19 | 1.34 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.one_time_authorization_code AS one_time_authorization_code_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.display_name_open_web AS display_name_open_web_10, t0.blue_snap_shopper_id AS blue_snap_shopper_id_11, t0.subscription_cancelled_at AS subscription_cancelled_at_12, t0.registration_ip AS registration_ip_13, t0.notified_at AS notified_at_14, t0.timestamp AS timestamp_15, t0.is_created_as_non_paying AS is_created_as_non_paying_16, t0.package_amount AS package_amount_17, t0.package_frequency AS package_frequency_18, t0.subscription_date AS subscription_date_19, t0.type_before_cancel AS type_before_cancel_20, t0.last_cancel_reason AS last_cancel_reason_21, t0.lang AS lang_22, t0.package_currency AS package_currency_23, t0.is_created_as_commenter AS is_created_as_commenter_24, t0.is_created_as_reader AS is_created_as_reader_25, t0.is_created_as_follower AS is_created_as_follower_26, t0.payment_source AS payment_source_27, t0.totp_secret AS totp_secret_28, t0.registration_country AS registration_country_29, t0.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
90
]
|
| 20 | 2.77 ms |
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
"6a60c565ce4d1"
]
|
| 21 | 0.32 ms |
"START TRANSACTION"
Parameters:
[] |
| 22 | 0.58 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "OPENWEB_REGISTER_USER-CALL_API" "{"userId":90}" null "6a60c565ce4d1" "2026-07-22 13:28:05" "2026-07-22 13:28:05" null ] |
| 23 | 2.12 ms |
"COMMIT"
Parameters:
[] |
| 24 | 0.77 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.one_time_authorization_code AS one_time_authorization_code_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.display_name_open_web AS display_name_open_web_10, t0.blue_snap_shopper_id AS blue_snap_shopper_id_11, t0.subscription_cancelled_at AS subscription_cancelled_at_12, t0.registration_ip AS registration_ip_13, t0.notified_at AS notified_at_14, t0.timestamp AS timestamp_15, t0.is_created_as_non_paying AS is_created_as_non_paying_16, t0.package_amount AS package_amount_17, t0.package_frequency AS package_frequency_18, t0.subscription_date AS subscription_date_19, t0.type_before_cancel AS type_before_cancel_20, t0.last_cancel_reason AS last_cancel_reason_21, t0.lang AS lang_22, t0.package_currency AS package_currency_23, t0.is_created_as_commenter AS is_created_as_commenter_24, t0.is_created_as_reader AS is_created_as_reader_25, t0.is_created_as_follower AS is_created_as_follower_26, t0.payment_source AS payment_source_27, t0.totp_secret AS totp_secret_28, t0.registration_country AS registration_country_29, t0.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
90
]
|
| 25 | 2.27 ms |
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
"6a60c565ce4d1"
]
|
| 26 | 0.65 ms |
"START TRANSACTION"
Parameters:
[] |
| 27 | 0.70 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.546","output":"[]"}" "2026-07-22 13:28:06" 718557 ] |
| 28 | 2.40 ms |
"COMMIT"
Parameters:
[] |
| 29 | 0.92 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.one_time_authorization_code AS one_time_authorization_code_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.display_name_open_web AS display_name_open_web_10, t0.blue_snap_shopper_id AS blue_snap_shopper_id_11, t0.subscription_cancelled_at AS subscription_cancelled_at_12, t0.registration_ip AS registration_ip_13, t0.notified_at AS notified_at_14, t0.timestamp AS timestamp_15, t0.is_created_as_non_paying AS is_created_as_non_paying_16, t0.package_amount AS package_amount_17, t0.package_frequency AS package_frequency_18, t0.subscription_date AS subscription_date_19, t0.type_before_cancel AS type_before_cancel_20, t0.last_cancel_reason AS last_cancel_reason_21, t0.lang AS lang_22, t0.package_currency AS package_currency_23, t0.is_created_as_commenter AS is_created_as_commenter_24, t0.is_created_as_reader AS is_created_as_reader_25, t0.is_created_as_follower AS is_created_as_follower_26, t0.payment_source AS payment_source_27, t0.totp_secret AS totp_secret_28, t0.registration_country AS registration_country_29, t0.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
90
]
|
| 30 | 2.92 ms |
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
"6a60c565ce4d1"
]
|
| 31 | 0.30 ms |
"START TRANSACTION"
Parameters:
[] |
| 32 | 0.52 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "OPENWEB_REGISTER_USER-CALL_API" "{"userId":90}" null "6a60c565ce4d1" "2026-07-22 13:28:06" "2026-07-22 13:28:06" null ] |
| 33 | 2.87 ms |
"COMMIT"
Parameters:
[] |
| 34 | 0.80 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.one_time_authorization_code AS one_time_authorization_code_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.display_name_open_web AS display_name_open_web_10, t0.blue_snap_shopper_id AS blue_snap_shopper_id_11, t0.subscription_cancelled_at AS subscription_cancelled_at_12, t0.registration_ip AS registration_ip_13, t0.notified_at AS notified_at_14, t0.timestamp AS timestamp_15, t0.is_created_as_non_paying AS is_created_as_non_paying_16, t0.package_amount AS package_amount_17, t0.package_frequency AS package_frequency_18, t0.subscription_date AS subscription_date_19, t0.type_before_cancel AS type_before_cancel_20, t0.last_cancel_reason AS last_cancel_reason_21, t0.lang AS lang_22, t0.package_currency AS package_currency_23, t0.is_created_as_commenter AS is_created_as_commenter_24, t0.is_created_as_reader AS is_created_as_reader_25, t0.is_created_as_follower AS is_created_as_follower_26, t0.payment_source AS payment_source_27, t0.totp_secret AS totp_secret_28, t0.registration_country AS registration_country_29, t0.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
90
]
|
| 35 | 3.44 ms |
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
"6a60c565ce4d1"
]
|
| 36 | 0.65 ms |
"START TRANSACTION"
Parameters:
[] |
| 37 | 0.66 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.132","output":""}" "2026-07-22 13:28:06" 718558 ] |
| 38 | 3.23 ms |
"COMMIT"
Parameters:
[] |
| 39 | 1.18 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.one_time_authorization_code AS one_time_authorization_code_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.display_name_open_web AS display_name_open_web_10, t0.blue_snap_shopper_id AS blue_snap_shopper_id_11, t0.subscription_cancelled_at AS subscription_cancelled_at_12, t0.registration_ip AS registration_ip_13, t0.notified_at AS notified_at_14, t0.timestamp AS timestamp_15, t0.is_created_as_non_paying AS is_created_as_non_paying_16, t0.package_amount AS package_amount_17, t0.package_frequency AS package_frequency_18, t0.subscription_date AS subscription_date_19, t0.type_before_cancel AS type_before_cancel_20, t0.last_cancel_reason AS last_cancel_reason_21, t0.lang AS lang_22, t0.package_currency AS package_currency_23, t0.is_created_as_commenter AS is_created_as_commenter_24, t0.is_created_as_reader AS is_created_as_reader_25, t0.is_created_as_follower AS is_created_as_follower_26, t0.payment_source AS payment_source_27, t0.totp_secret AS totp_secret_28, t0.registration_country AS registration_country_29, t0.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
90
]
|
| 40 | 2.49 ms |
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
"6a60c565ce4d1"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| audit | doctrine.dbal.audit_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| audit | doctrine.orm.audit_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Audit | No errors. |
| App\Entity\SubscriptionsIssue | No errors. |
| App\Entity\UserPromotion | No errors. |
| App\Entity\Gift | No errors. |
| App\Entity\AppEventLog | No errors. |
| App\Entity\RelationUserAuthor | No errors. |
audit entity manager
No loaded entities.