Query Metrics
41
Database Queries
10
Different statements
248.05 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
87.62 ms (35.32%) |
1 |
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
]
|
|
53.93 ms (21.74%) |
4 |
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 ] |
|
43.88 ms (17.69%) |
1 |
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"
]
|
|
29.19 ms (11.77%) |
8 |
"COMMIT"
Parameters:
[] |
|
15.42 ms (6.22%) |
5 |
UPDATE audit SET user_id = 171 WHERE flow_id = ?
Parameters:
[
"6a25000b554b4"
]
|
|
5.30 ms (2.14%) |
8 |
"START TRANSACTION"
Parameters:
[] |
|
5.27 ms (2.13%) |
1 |
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
]
|
|
4.77 ms (1.92%) |
8 |
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
]
|
|
2.11 ms (0.85%) |
4 |
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "{"time":"0.001","output":{"userId":171}}" "2026-06-07 05:22:19" 713201 ] |
|
0.57 ms (0.23%) |
1 |
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
]
|
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.