POST https://devcrm.timesofisrael.com/webhook

Query Metrics

41 Database Queries
10 Different statements
59.68 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
23.06 ms
(38.64%)
5
UPDATE audit SET user_id = 326 WHERE flow_id = ?
Parameters:
[
  "6b00127587852"
]
17.95 ms
(30.08%)
8
"COMMIT"
Parameters:
[]
5.50 ms
(9.22%)
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.one_time_authorization_expires_at AS one_time_authorization_expires_at_8, t0.ota_request_count AS ota_request_count_9, t0.ota_request_window_started_at AS ota_request_window_started_at_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.display_name_open_web AS display_name_open_web_13, t0.blue_snap_shopper_id AS blue_snap_shopper_id_14, t0.subscription_cancelled_at AS subscription_cancelled_at_15, t0.registration_ip AS registration_ip_16, t0.notified_at AS notified_at_17, t0.timestamp AS timestamp_18, t0.is_created_as_non_paying AS is_created_as_non_paying_19, t0.package_amount AS package_amount_20, t0.package_frequency AS package_frequency_21, t0.subscription_date AS subscription_date_22, t0.type_before_cancel AS type_before_cancel_23, t0.last_cancel_reason AS last_cancel_reason_24, t0.lang AS lang_25, t0.package_currency AS package_currency_26, t0.is_created_as_commenter AS is_created_as_commenter_27, t0.is_created_as_reader AS is_created_as_reader_28, t0.is_created_as_follower AS is_created_as_follower_29, t0.payment_source AS payment_source_30, t0.totp_secret AS totp_secret_31, t0.registration_country AS registration_country_32, t0.registration_region AS registration_region_33, t0.utm_query AS utm_query_34, t0.subscription_changed_at AS subscription_changed_at_35 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  0
]
3.25 ms
(5.45%)
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":{"connection":["Keep-Alive"],"accept-encoding":["gzip, br"],"host":["devcrm.timesofisrael.com"],"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"],"content-length":["2335"],"content-type":["application\/x-www-form-urlencoded"],"cf-device-type":["desktop"],"cf-ray":["a5d66afd4b37eded-FRA"],"user-agent":["BlueSnap"],"cache-control":["no-cache"],"pragma":["no-cache"],"accept":["text\/html, image\/gif, image\/jpeg, *; q=.2, *\/*; q=.2"],"x-forwarded-for":["141.226.143.200"],"x-php-ob-level":["1"]},"cookies":[],"query":[],"body":{"lastName":"","country":"","zipCode":"","extension":"","personalId":"","address2":"","city":"","address1":"","homePhone":"","brazilianId":"","title":"","accountId":"46275635","firstName":"lapidusalex","mobilePhone":"","faxNumber":"","company":"","workPhone":"","state":"","email":"lapidusalex@gmail.com","username":"169071411205419628549851383559316","shippingCity":"","shippingLastName":"","shippingCountry":"","shippingZipCode":"","shippingMethod":"","shippingFirstName":"lapidusalex","shippingState":"","shippingAddress2":"","shippingAddress1":"","invoiceCountry":"","invoiceZipCode":"","invoiceFirstName":"lapidusalex","invoiceFaxNumber":"","invoiceState":"","invoiceAddress2":"","invoiceEmail":"lapidusalex@gmail.com","invoiceLastName":"","invoiceAddress1":"","invoiceCompany":"","invoiceCity":"","invoiceExtension":"","invoiceMobilePhone":"","invoiceWorkPhone":"","invoiceTitle":"","dpanLastFourDigits":"","cardCategory":"CLASSIC","invoiceAmount":"6.00","language":"ENGLISH","creditCardType":"VISA","invoiceAmountUSD":"6.00","productName":"TOI Plan: $6","invoiceLocalCurrency":"USD","paymentType":"CC","creditCardExpDate":"01\/2034","contractOwner":"719125","referenceNumber":"1094310414","binCategory":"CONSUMER","contractName":"TOI Plan: $6","currency":"USD","invoiceInfoURL":"https:\/\/sandbox.bluesnap.com\/jsp\/order_locator_info.jsp?refId=CE308E660C663C747EBAB5B8D22A6187&acd=5CF9155310A1C22A","remoteAddress":"","quantity":"1","contractChargePrice":"6.00","productId":"495833","invoiceChargeCurrency":"USD","cardSubType":"CREDIT","shopperOrderUrl":"https:\/\/sandbox.bluesnap.com\/jsp\/order_locator_info.jsp?refId=CE308E660C663C747EBAB5B8D22A6187&acd=5CF9155310A1C22A","invoiceChargeAmount":"6.00","originalRefNum":"1076602940","regulatedCard":"N","transactionType":"RECURRING","referrer":"","contractPrice":"6.00","dpanExpDate":"","creditCardLastFourDigits":"4242","originalReferenceNumber":"1076602940","testMode":"N","contractId":"2492855","paymentMethod":"CC","subscriptionId":"44515448","addCD":"N","untilDate":"12\/20\/2026 01:54 AM","invoiceURL":"https:\/\/sandbox.bluesnap.com\/jsp\/show_invoice.jsp?ref=CE308E660C663C747EBAB5B8D22A6187","templateId":"0","promoteContractsNum":"0","targetBalance":"BLUESNAP_ACCOUNT","authKey":"","vatId":"","taxAmountUSD":"0.00","taxRate":"","taxChargeAmount":"0.00","bluesnapNode":"99","plimusNode":"99","couponCode":"","licenseKey":"","transactionDate":"11\/20\/2026 01:27 AM","merchantTransactionId":"","vendorId":"","vendorName":"","sepaMandateId":"","sepaIban":"","sepaMandateDate":"","cardIssuingOrg":"STRIPE PAYMENTS UK LIMITED","binNumber":"424242","cardIssuingCountry":"gb","ipnId":"45db2392-a046-4863-8089-82f723388868"}}}"
  null
  "6b00127587852"
  "2026-11-20 09:27:17"
  "2026-11-20 09:27:17"
  null
]
2.48 ms
(4.16%)
8
"START TRANSACTION"
Parameters:
[]
2.06 ms
(3.44%)
4
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[
  1
  "{"time":"0.001","output":{"userId":326}}"
  "2026-11-20 09:27:17"
  728680
]
1.79 ms
(3.00%)
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_.one_time_authorization_expires_at AS one_time_authorization_expires_at_7, u0_.ota_request_count AS ota_request_count_8, u0_.ota_request_window_started_at AS ota_request_window_started_at_9, u0_.first_name AS first_name_10, u0_.last_name AS last_name_11, u0_.display_name_open_web AS display_name_open_web_12, u0_.blue_snap_shopper_id AS blue_snap_shopper_id_13, u0_.subscription_cancelled_at AS subscription_cancelled_at_14, u0_.registration_ip AS registration_ip_15, u0_.notified_at AS notified_at_16, u0_.timestamp AS timestamp_17, u0_.is_created_as_non_paying AS is_created_as_non_paying_18, u0_.package_amount AS package_amount_19, u0_.package_frequency AS package_frequency_20, u0_.subscription_date AS subscription_date_21, u0_.type_before_cancel AS type_before_cancel_22, u0_.last_cancel_reason AS last_cancel_reason_23, u0_.lang AS lang_24, u0_.package_currency AS package_currency_25, u0_.is_created_as_commenter AS is_created_as_commenter_26, u0_.is_created_as_reader AS is_created_as_reader_27, u0_.is_created_as_follower AS is_created_as_follower_28, u0_.payment_source AS payment_source_29, u0_.totp_secret AS totp_secret_30, u0_.registration_country AS registration_country_31, u0_.registration_region AS registration_region_32, u0_.utm_query AS utm_query_33, u0_.subscription_changed_at AS subscription_changed_at_34 FROM user u0_ WHERE u0_.blue_snap_shopper_id = ? LIMIT 1
Parameters:
[
  46275635
]
1.76 ms
(2.94%)
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_.one_time_authorization_expires_at AS one_time_authorization_expires_at_15, u1_.ota_request_count AS ota_request_count_16, u1_.ota_request_window_started_at AS ota_request_window_started_at_17, u1_.first_name AS first_name_18, u1_.last_name AS last_name_19, u1_.display_name_open_web AS display_name_open_web_20, u1_.blue_snap_shopper_id AS blue_snap_shopper_id_21, u1_.subscription_cancelled_at AS subscription_cancelled_at_22, u1_.registration_ip AS registration_ip_23, u1_.notified_at AS notified_at_24, u1_.timestamp AS timestamp_25, u1_.is_created_as_non_paying AS is_created_as_non_paying_26, u1_.package_amount AS package_amount_27, u1_.package_frequency AS package_frequency_28, u1_.subscription_date AS subscription_date_29, u1_.type_before_cancel AS type_before_cancel_30, u1_.last_cancel_reason AS last_cancel_reason_31, u1_.lang AS lang_32, u1_.package_currency AS package_currency_33, u1_.is_created_as_commenter AS is_created_as_commenter_34, u1_.is_created_as_reader AS is_created_as_reader_35, u1_.is_created_as_follower AS is_created_as_follower_36, u1_.payment_source AS payment_source_37, u1_.totp_secret AS totp_secret_38, u1_.registration_country AS registration_country_39, u1_.registration_region AS registration_region_40, u1_.utm_query AS utm_query_41, u1_.subscription_changed_at AS subscription_changed_at_42, a0_.user_id AS user_id_43 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:
[
  "6b00127587852"
]
1.03 ms
(1.73%)
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.one_time_authorization_expires_at AS one_time_authorization_expires_at_8, t0.ota_request_count AS ota_request_count_9, t0.ota_request_window_started_at AS ota_request_window_started_at_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.display_name_open_web AS display_name_open_web_13, t0.blue_snap_shopper_id AS blue_snap_shopper_id_14, t0.subscription_cancelled_at AS subscription_cancelled_at_15, t0.registration_ip AS registration_ip_16, t0.notified_at AS notified_at_17, t0.timestamp AS timestamp_18, t0.is_created_as_non_paying AS is_created_as_non_paying_19, t0.package_amount AS package_amount_20, t0.package_frequency AS package_frequency_21, t0.subscription_date AS subscription_date_22, t0.type_before_cancel AS type_before_cancel_23, t0.last_cancel_reason AS last_cancel_reason_24, t0.lang AS lang_25, t0.package_currency AS package_currency_26, t0.is_created_as_commenter AS is_created_as_commenter_27, t0.is_created_as_reader AS is_created_as_reader_28, t0.is_created_as_follower AS is_created_as_follower_29, t0.payment_source AS payment_source_30, t0.totp_secret AS totp_secret_31, t0.registration_country AS registration_country_32, t0.registration_region AS registration_region_33, t0.utm_query AS utm_query_34, t0.subscription_changed_at AS subscription_changed_at_35 FROM user t0 WHERE t0.blue_snap_shopper_id = ? LIMIT 1
Parameters:
[
  46275635
]
0.79 ms
(1.32%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_resolved AS is_resolved_3, t0.payment_failure_notice_acknowledged_at AS payment_failure_notice_acknowledged_at_4, t0.last_day_in_community AS last_day_in_community_5, t0.suspended_membership_at AS suspended_membership_at_6, t0.blue_snap_subscription_id AS blue_snap_subscription_id_7, t0.origin AS origin_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM subscriptions_issue t0 WHERE t0.user_id = ?
Parameters:
[
  326
]

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.