Query Metrics
41
Database Queries
10
Different statements
248.05 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.27 ms |
SELECT u0_.created_at AS created_at_0, u0_.updated_at AS updated_at_1, u0_.id AS id_2, u0_.email AS email_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.one_time_authorization_code AS one_time_authorization_code_6, u0_.first_name AS first_name_7, u0_.last_name AS last_name_8, u0_.display_name_open_web AS display_name_open_web_9, u0_.blue_snap_shopper_id AS blue_snap_shopper_id_10, u0_.subscription_cancelled_at AS subscription_cancelled_at_11, u0_.registration_ip AS registration_ip_12, u0_.notified_at AS notified_at_13, u0_.timestamp AS timestamp_14, u0_.is_created_as_non_paying AS is_created_as_non_paying_15, u0_.package_amount AS package_amount_16, u0_.package_frequency AS package_frequency_17, u0_.subscription_date AS subscription_date_18, u0_.type_before_cancel AS type_before_cancel_19, u0_.last_cancel_reason AS last_cancel_reason_20, u0_.lang AS lang_21, u0_.package_currency AS package_currency_22, u0_.is_created_as_commenter AS is_created_as_commenter_23, u0_.is_created_as_reader AS is_created_as_reader_24, u0_.is_created_as_follower AS is_created_as_follower_25, u0_.payment_source AS payment_source_26, u0_.totp_secret AS totp_secret_27, u0_.registration_country AS registration_country_28, u0_.utm_query AS utm_query_29, u0_.subscription_changed_at AS subscription_changed_at_30 FROM user u0_ WHERE u0_.blue_snap_shopper_id = ? LIMIT 1
Parameters:
[
36632355
]
|
| 2 | 0.54 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 52.18 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "WEBHOOK_CHARGE-START_END" "{"RequestDump":{"headers":{"host":["devcrm.timesofisrael.com"],"cf-device-type":["desktop"],"accept-encoding":["gzip, br"],"x-forwarded-proto":["https"],"cf-visitor":["{\"scheme\":\"https\"}"],"cf-ipcountry":["DE"],"true-client-ip":["141.226.143.200"],"cf-connecting-ip":["141.226.143.200"],"cdn-loop":["cloudflare; loops=1"],"x-forwarded-for":["141.226.143.200"],"cache-control":["no-cache"],"connection":["Keep-Alive"],"cf-ray":["a07d37e2eaa92608-FRA"],"pragma":["no-cache"],"accept":["text\/html, image\/gif, image\/jpeg, *; q=.2, *\/*; q=.2"],"user-agent":["BlueSnap"],"content-type":["application\/x-www-form-urlencoded"],"content-length":["2298"],"x-php-ob-level":["1"]},"cookies":[],"query":[],"body":{"lastName":"sdf ","country":"","zipCode":"","extension":"","personalId":"","address2":"","city":"","address1":"","homePhone":"","brazilianId":"","title":"","accountId":"36632355","firstName":"sdf","mobilePhone":"","faxNumber":"","company":"","workPhone":"","state":"","email":"roman+asdqwesdf@appscloud.io","username":"16545798838384090749962113310821","shippingCity":"","shippingLastName":"sdf ","shippingCountry":"","shippingZipCode":"","shippingMethod":"","shippingFirstName":"sdf","shippingState":"","shippingAddress2":"","shippingAddress1":"","invoiceCountry":"","invoiceZipCode":"","invoiceFirstName":"sdf","invoiceFaxNumber":"","invoiceState":"","invoiceAddress2":"","invoiceEmail":"roman+asdqwesdf@appscloud.io","invoiceLastName":"sdf ","invoiceAddress1":"","invoiceCompany":"","invoiceCity":"","invoiceExtension":"","invoiceMobilePhone":"","invoiceWorkPhone":"","invoiceTitle":"","dpanLastFourDigits":"","cardCategory":"","invoiceAmount":"10.00","language":"ENGLISH","creditCardType":"VISA","invoiceAmountUSD":"10.00","productName":"TOI Plan: $10","invoiceLocalCurrency":"USD","paymentType":"CC","creditCardExpDate":"02\/2024","contractOwner":"719125","referenceNumber":"1090189172","binCategory":"CONSUMER","contractName":"TOI Plan: $10","currency":"USD","invoiceInfoURL":"https:\/\/sandbox.bluesnap.com\/jsp\/order_locator_info.jsp?refId=AF80BDAF738C4828AB325F1D0A59F942&acd=10E16AB573942C97","remoteAddress":"","quantity":"1","contractChargePrice":"10.00","productId":"495833","invoiceChargeCurrency":"USD","cardSubType":"CREDIT","shopperOrderUrl":"https:\/\/sandbox.bluesnap.com\/jsp\/order_locator_info.jsp?refId=AF80BDAF738C4828AB325F1D0A59F942&acd=10E16AB573942C97","invoiceChargeAmount":"10.00","originalRefNum":"1063275799","regulatedCard":"N","transactionType":"RECURRING","referrer":"","contractPrice":"10.00","dpanExpDate":"","creditCardLastFourDigits":"0002","originalReferenceNumber":"1063275799","testMode":"N","contractId":"2491817","paymentMethod":"CC","subscriptionId":"36005097","addCD":"N","untilDate":"07\/06\/2026 10:31 PM","invoiceURL":"https:\/\/sandbox.bluesnap.com\/jsp\/show_invoice.jsp?ref=AF80BDAF738C4828AB325F1D0A59F942","templateId":"0","promoteContractsNum":"0","targetBalance":"BLUESNAP_ACCOUNT","authKey":"","vatId":"","taxAmountUSD":"0.00","taxRate":"","taxChargeAmount":"0.00","bluesnapNode":"99","plimusNode":"99","couponCode":"","licenseKey":"","transactionDate":"06\/06\/2026 10:22 PM","merchantTransactionId":"","vendorId":"","vendorName":"","sepaMandateId":"","sepaIban":"","sepaMandateDate":"","binNumber":"400000","cardIssuingCountry":"us","ipnId":"1ac6c6ed-01d5-44b0-93d3-3d2276b4c40e"}}}" null "6a25000b554b4" "2026-06-07 05:22:19" "2026-06-07 05:22:19" null ] |
| 4 | 4.00 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.96 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
0
]
|
| 6 | 0.48 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 0.71 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "WEBHOOK_CHARGE-FIND_USER" "{"BlueSnapShopperId":36632355}" null "6a25000b554b4" "2026-06-07 05:22:19" "2026-06-07 05:22:19" null ] |
| 8 | 3.01 ms |
"COMMIT"
Parameters:
[] |
| 9 | 0.44 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
0
]
|
| 10 | 0.57 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.blue_snap_shopper_id = ? LIMIT 1
Parameters:
[
36632355
]
|
| 11 | 0.22 ms |
"START TRANSACTION"
Parameters:
[] |
| 12 | 0.34 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.001","output":{"userId":171}}" "2026-06-07 05:22:19" 713201 ] |
| 13 | 1.99 ms |
"COMMIT"
Parameters:
[] |
| 14 | 0.45 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
171
]
|
| 15 | 5.87 ms |
UPDATE audit SET user_id = 171 WHERE flow_id = ?
Parameters:
[
"6a25000b554b4"
]
|
| 16 | 0.31 ms |
"START TRANSACTION"
Parameters:
[] |
| 17 | 0.67 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "WEBHOOK_CHARGE-GET_OR_FIND_SUBSCRIPTION" "{"userId":171}" null "6a25000b554b4" "2026-06-07 05:22:19" "2026-06-07 05:22:19" null ] |
| 18 | 11.53 ms |
"COMMIT"
Parameters:
[] |
| 19 | 0.68 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
171
]
|
| 20 | 4.46 ms |
UPDATE audit SET user_id = 171 WHERE flow_id = ?
Parameters:
[
"6a25000b554b4"
]
|
| 21 | 0.26 ms |
"START TRANSACTION"
Parameters:
[] |
| 22 | 0.40 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.000","output":""}" "2026-06-07 05:22:19" 713202 ] |
| 23 | 2.80 ms |
"COMMIT"
Parameters:
[] |
| 24 | 0.53 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
171
]
|
| 25 | 0.97 ms |
UPDATE audit SET user_id = 171 WHERE flow_id = ?
Parameters:
[
"6a25000b554b4"
]
|
| 26 | 0.18 ms |
"START TRANSACTION"
Parameters:
[] |
| 27 | 0.37 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "WEBHOOK_CHARGE-REMOVE_SUBSCRIPTION_ISSUE" "{"userId":171}" null "6a25000b554b4" "2026-06-07 05:22:19" "2026-06-07 05:22:19" null ] |
| 28 | 2.08 ms |
"COMMIT"
Parameters:
[] |
| 29 | 0.50 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
171
]
|
| 30 | 2.46 ms |
UPDATE audit SET user_id = 171 WHERE flow_id = ?
Parameters:
[
"6a25000b554b4"
]
|
| 31 | 87.62 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_resolved AS is_resolved_3, t0.last_day_in_community AS last_day_in_community_4, t0.suspended_membership_at AS suspended_membership_at_5, t0.blue_snap_subscription_id AS blue_snap_subscription_id_6, t0.origin AS origin_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM subscriptions_issue t0 WHERE t0.user_id = ?
Parameters:
[
171
]
|
| 32 | 3.00 ms |
"START TRANSACTION"
Parameters:
[] |
| 33 | 0.74 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.088","output":{"numberOfRemovedSubscriptionsIssues":0}}" "2026-06-07 05:22:19" 713204 ] |
| 34 | 2.26 ms |
"COMMIT"
Parameters:
[] |
| 35 | 0.53 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
171
]
|
| 36 | 1.66 ms |
UPDATE audit SET user_id = 171 WHERE flow_id = ?
Parameters:
[
"6a25000b554b4"
]
|
| 37 | 43.88 ms |
SELECT a0_.id AS id_0, a0_.result AS result_1, a0_.action AS action_2, a0_.input AS input_3, a0_.output AS output_4, a0_.flow_id AS flow_id_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, u1_.created_at AS created_at_8, u1_.updated_at AS updated_at_9, u1_.id AS id_10, u1_.email AS email_11, u1_.roles AS roles_12, u1_.password AS password_13, u1_.one_time_authorization_code AS one_time_authorization_code_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.display_name_open_web AS display_name_open_web_17, u1_.blue_snap_shopper_id AS blue_snap_shopper_id_18, u1_.subscription_cancelled_at AS subscription_cancelled_at_19, u1_.registration_ip AS registration_ip_20, u1_.notified_at AS notified_at_21, u1_.timestamp AS timestamp_22, u1_.is_created_as_non_paying AS is_created_as_non_paying_23, u1_.package_amount AS package_amount_24, u1_.package_frequency AS package_frequency_25, u1_.subscription_date AS subscription_date_26, u1_.type_before_cancel AS type_before_cancel_27, u1_.last_cancel_reason AS last_cancel_reason_28, u1_.lang AS lang_29, u1_.package_currency AS package_currency_30, u1_.is_created_as_commenter AS is_created_as_commenter_31, u1_.is_created_as_reader AS is_created_as_reader_32, u1_.is_created_as_follower AS is_created_as_follower_33, u1_.payment_source AS payment_source_34, u1_.totp_secret AS totp_secret_35, u1_.registration_country AS registration_country_36, u1_.utm_query AS utm_query_37, u1_.subscription_changed_at AS subscription_changed_at_38, a0_.user_id AS user_id_39 FROM audit a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id WHERE a0_.flow_id = ? AND a0_.user_id IS NOT NULL LIMIT 1
Parameters:
[
"6a25000b554b4"
]
|
| 38 | 0.30 ms |
"START TRANSACTION"
Parameters:
[] |
| 39 | 0.63 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.220","output":""}" "2026-06-07 05:22:19" 713198 ] |
| 40 | 1.54 ms |
"COMMIT"
Parameters:
[] |
| 41 | 0.69 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.utm_query AS utm_query_30, t0.subscription_changed_at AS subscription_changed_at_31 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
0
]
|
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.