Query Metrics
41
Database Queries
10
Different statements
82.01 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.02 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:
[
42707768
]
|
| 2 | 0.97 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 1.10 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":["a07e488c7a68dc72-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":["2385"],"x-php-ob-level":["1"]},"cookies":[],"query":[],"body":{"lastName":"iframesignup","country":"","zipCode":"","extension":"","personalId":"","address2":"","city":"","address1":"","homePhone":"","brazilianId":"","title":"","accountId":"42707768","firstName":"romanf","mobilePhone":"","faxNumber":"","company":"","workPhone":"","state":"","email":"romanf+x07042508@appscloud.io","username":"174401585695113521024721320774596","shippingCity":"","shippingLastName":"iframesignup","shippingCountry":"","shippingZipCode":"","shippingMethod":"","shippingFirstName":"romanf","shippingState":"","shippingAddress2":"","shippingAddress1":"","invoiceCountry":"","invoiceZipCode":"","invoiceFirstName":"romanf","invoiceFaxNumber":"","invoiceState":"","invoiceAddress2":"","invoiceEmail":"romanf+x07042508@appscloud.io","invoiceLastName":"iframesignup","invoiceAddress1":"","invoiceCompany":"","invoiceCity":"","invoiceExtension":"","invoiceMobilePhone":"","invoiceWorkPhone":"","invoiceTitle":"","dpanLastFourDigits":"","cardCategory":"CLASSIC","invoiceAmount":"10.00","language":"ENGLISH","creditCardType":"VISA","invoiceAmountUSD":"10.00","productName":"TOI Plan: $10","invoiceLocalCurrency":"USD","paymentType":"CC","creditCardExpDate":"09\/2027","contractOwner":"719125","referenceNumber":"1090192288","binCategory":"CONSUMER","contractName":"TOI Plan: $10","currency":"USD","invoiceInfoURL":"https:\/\/sandbox.bluesnap.com\/jsp\/order_locator_info.jsp?refId=B23F85D676B3F950F2AF027ABD8F5E31&acd=28835829157410AB","remoteAddress":"","quantity":"1","contractChargePrice":"10.00","productId":"495833","invoiceChargeCurrency":"USD","cardSubType":"CREDIT","shopperOrderUrl":"https:\/\/sandbox.bluesnap.com\/jsp\/order_locator_info.jsp?refId=B23F85D676B3F950F2AF027ABD8F5E31&acd=28835829157410AB","invoiceChargeAmount":"10.00","originalRefNum":"1076019232","regulatedCard":"N","transactionType":"RECURRING","referrer":"","contractPrice":"10.00","dpanExpDate":"","creditCardLastFourDigits":"4242","originalReferenceNumber":"1076019232","testMode":"N","contractId":"2491817","paymentMethod":"CC","subscriptionId":"44255596","addCD":"N","untilDate":"07\/07\/2026 01:50 AM","invoiceURL":"https:\/\/sandbox.bluesnap.com\/jsp\/show_invoice.jsp?ref=B23F85D676B3F950F2AF027ABD8F5E31","templateId":"-99","promoteContractsNum":"0","targetBalance":"BLUESNAP_ACCOUNT","authKey":"","vatId":"","taxAmountUSD":"0.00","taxRate":"","taxChargeAmount":"0.00","bluesnapNode":"99","plimusNode":"99","couponCode":"","licenseKey":"","transactionDate":"06\/07\/2026 01:28 AM","merchantTransactionId":"","vendorId":"","vendorName":"","sepaMandateId":"","sepaIban":"","sepaMandateDate":"","cardIssuingOrg":"STRIPE PAYMENTS UK LIMITED","binNumber":"424242","cardIssuingCountry":"gb","ipnId":"123479f7-9451-4b56-8b8a-5fb9f8020540"}}}" null "6a252bab47b66" "2026-06-07 08:28:27" "2026-06-07 08:28:27" null ] |
| 4 | 2.45 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.76 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.28 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 0.34 ms |
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "WEBHOOK_CHARGE-FIND_USER" "{"BlueSnapShopperId":42707768}" null "6a252bab47b66" "2026-06-07 08:28:27" "2026-06-07 08:28:27" null ] |
| 8 | 1.78 ms |
"COMMIT"
Parameters:
[] |
| 9 | 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:
[
0
]
|
| 10 | 1.02 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:
[
42707768
]
|
| 11 | 0.18 ms |
"START TRANSACTION"
Parameters:
[] |
| 12 | 0.39 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.001","output":{"userId":682}}" "2026-06-07 08:28:27" 713215 ] |
| 13 | 2.33 ms |
"COMMIT"
Parameters:
[] |
| 14 | 0.88 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:
[
682
]
|
| 15 | 3.20 ms |
UPDATE audit SET user_id = 682 WHERE flow_id = ?
Parameters:
[
"6a252bab47b66"
]
|
| 16 | 2.67 ms |
"START TRANSACTION"
Parameters:
[] |
| 17 | 1.77 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":682}" null "6a252bab47b66" "2026-06-07 08:28:27" "2026-06-07 08:28:27" null ] |
| 18 | 3.97 ms |
"COMMIT"
Parameters:
[] |
| 19 | 1.84 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:
[
682
]
|
| 20 | 3.53 ms |
UPDATE audit SET user_id = 682 WHERE flow_id = ?
Parameters:
[
"6a252bab47b66"
]
|
| 21 | 1.65 ms |
"START TRANSACTION"
Parameters:
[] |
| 22 | 0.88 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.000","output":""}" "2026-06-07 08:28:27" 713216 ] |
| 23 | 2.03 ms |
"COMMIT"
Parameters:
[] |
| 24 | 8.82 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:
[
682
]
|
| 25 | 3.68 ms |
UPDATE audit SET user_id = 682 WHERE flow_id = ?
Parameters:
[
"6a252bab47b66"
]
|
| 26 | 0.85 ms |
"START TRANSACTION"
Parameters:
[] |
| 27 | 5.58 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":682}" null "6a252bab47b66" "2026-06-07 08:28:27" "2026-06-07 08:28:27" null ] |
| 28 | 2.95 ms |
"COMMIT"
Parameters:
[] |
| 29 | 0.85 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:
[
682
]
|
| 30 | 6.47 ms |
UPDATE audit SET user_id = 682 WHERE flow_id = ?
Parameters:
[
"6a252bab47b66"
]
|
| 31 | 0.84 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:
[
682
]
|
| 32 | 0.61 ms |
"START TRANSACTION"
Parameters:
[] |
| 33 | 0.88 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.001","output":{"numberOfRemovedSubscriptionsIssues":0}}" "2026-06-07 08:28:27" 713217 ] |
| 34 | 2.96 ms |
"COMMIT"
Parameters:
[] |
| 35 | 1.84 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:
[
682
]
|
| 36 | 4.60 ms |
UPDATE audit SET user_id = 682 WHERE flow_id = ?
Parameters:
[
"6a252bab47b66"
]
|
| 37 | 0.89 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:
[
"6a252bab47b66"
]
|
| 38 | 0.21 ms |
"START TRANSACTION"
Parameters:
[] |
| 39 | 0.45 ms |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.081","output":""}" "2026-06-07 08:28:27" 713214 ] |
| 40 | 1.49 ms |
"COMMIT"
Parameters:
[] |
| 41 | 0.51 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.