Symfony Profiler

"COMMIT"

"COMMIT";

UPDATE
  audit
SET
  user_id = 683
WHERE
  flow_id = ?

UPDATE audit SET user_id = 683 WHERE flow_id = '6a2562670a013';

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

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 = 0 LIMIT 1;

INSERT INTO audit (
  result, action, input, output, flow_id,
  created_at, updated_at, user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (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\":[\"a07f9ea0ccc555cd-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\":[\"2336\"],\"x-php-ob-level\":[\"1\"]},\"cookies\":[],\"query\":[],\"body\":{\"lastName\":\"\",\"country\":\"\",\"zipCode\":\"\",\"extension\":\"\",\"personalId\":\"\",\"address2\":\"\",\"city\":\"\",\"address1\":\"\",\"homePhone\":\"\",\"brazilianId\":\"\",\"title\":\"\",\"accountId\":\"42709648\",\"firstName\":\"Visatest\",\"mobilePhone\":\"\",\"faxNumber\":\"\",\"company\":\"\",\"workPhone\":\"\",\"state\":\"\",\"email\":\"alex+crm332@rgbmedia.org\",\"username\":\"174402833360011032357221813109623\",\"shippingCity\":\"\",\"shippingLastName\":\"\",\"shippingCountry\":\"\",\"shippingZipCode\":\"\",\"shippingMethod\":\"\",\"shippingFirstName\":\"Visatest\",\"shippingState\":\"\",\"shippingAddress2\":\"\",\"shippingAddress1\":\"\",\"invoiceCountry\":\"\",\"invoiceZipCode\":\"\",\"invoiceFirstName\":\"Visatest\",\"invoiceFaxNumber\":\"\",\"invoiceState\":\"\",\"invoiceAddress2\":\"\",\"invoiceEmail\":\"alex+crm332@rgbmedia.org\",\"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\":\"1090195738\",\"binCategory\":\"CONSUMER\",\"contractName\":\"TOI Plan: $6\",\"currency\":\"USD\",\"invoiceInfoURL\":\"https:\\/\\/sandbox.bluesnap.com\\/jsp\\/order_locator_info.jsp?refId=B31144F36D56575E90BE9C878786D549&acd=F7B0515DF71E9CB4\",\"remoteAddress\":\"\",\"quantity\":\"1\",\"contractChargePrice\":\"6.00\",\"productId\":\"495833\",\"invoiceChargeCurrency\":\"USD\",\"cardSubType\":\"CREDIT\",\"shopperOrderUrl\":\"https:\\/\\/sandbox.bluesnap.com\\/jsp\\/order_locator_info.jsp?refId=B31144F36D56575E90BE9C878786D549&acd=F7B0515DF71E9CB4\",\"invoiceChargeAmount\":\"6.00\",\"originalRefNum\":\"1076029764\",\"regulatedCard\":\"N\",\"transactionType\":\"RECURRING\",\"referrer\":\"\",\"contractPrice\":\"6.00\",\"dpanExpDate\":\"\",\"creditCardLastFourDigits\":\"4242\",\"originalReferenceNumber\":\"1076029764\",\"testMode\":\"N\",\"contractId\":\"2492855\",\"paymentMethod\":\"CC\",\"subscriptionId\":\"44259144\",\"addCD\":\"N\",\"untilDate\":\"07\\/07\\/2026 05:18 AM\",\"invoiceURL\":\"https:\\/\\/sandbox.bluesnap.com\\/jsp\\/show_invoice.jsp?ref=B31144F36D56575E90BE9C878786D549\",\"templateId\":\"0\",\"promoteContractsNum\":\"0\",\"targetBalance\":\"BLUESNAP_ACCOUNT\",\"authKey\":\"\",\"vatId\":\"\",\"taxAmountUSD\":\"0.00\",\"taxRate\":\"\",\"taxChargeAmount\":\"0.00\",\"bluesnapNode\":\"99\",\"plimusNode\":\"99\",\"couponCode\":\"\",\"licenseKey\":\"\",\"transactionDate\":\"06\\/07\\/2026 05:21 AM\",\"merchantTransactionId\":\"\",\"vendorId\":\"\",\"vendorName\":\"\",\"sepaMandateId\":\"\",\"sepaIban\":\"\",\"sepaMandateDate\":\"\",\"cardIssuingOrg\":\"STRIPE PAYMENTS UK LIMITED\",\"binNumber\":\"424242\",\"cardIssuingCountry\":\"gb\",\"ipnId\":\"95c81b68-f689-4e87-9057-fe3564f5e973\"}}}', NULL, '6a2562670a013', '2026-06-07 12:21:59', '2026-06-07 12:21:59', NULL);

"START TRANSACTION"

"START TRANSACTION";

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

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 = 42709648 LIMIT 1;

UPDATE
  audit
SET
  result = ?,
  output = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE audit SET result = 1, output = '{\"time\":\"0.002\",\"output\":{\"userId\":683}}', updated_at = '2026-06-07 12:21:59' WHERE id = 713227;

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

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 = '6a2562670a013' AND a0_.user_id IS NOT NULL LIMIT 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

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 = 42709648 LIMIT 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 = ?

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 = 683;