POST https://devcrm.timesofisrael.com/fr/openweb/single-sign-on

Query Metrics

40 Database Queries
6 Different statements
78.44 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 10.91 ms
"START TRANSACTION"
Parameters:
[]
2 1.58 ms
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  "OPENWEB_REGISTER_USER-START"
  "{"userId":90,"codeA":"codea_o0rBcuZP5ALK4kuC8YJ8Cau0S4j911z3Mw4M0oFEJ3pI","isBlog":false}"
  null
  "6a60c565ce4d1"
  "2026-07-22 13:28:05"
  "2026-07-22 13:28:05"
  null
]
3 3.30 ms
"COMMIT"
Parameters:
[]
4 2.05 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.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90
]
5 3.36 ms
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
  "6a60c565ce4d1"
]
6 0.55 ms
"START TRANSACTION"
Parameters:
[]
7 0.81 ms
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[
  1
  "{"time":"0.000","output":""}"
  "2026-07-22 13:28:05"
  718555
]
8 2.33 ms
"COMMIT"
Parameters:
[]
9 1.10 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.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90
]
10 3.26 ms
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
  "6a60c565ce4d1"
]
11 0.78 ms
"START TRANSACTION"
Parameters:
[]
12 0.90 ms
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  "OPENWEB_REGISTER_USER-FIND_USER"
  "{"userId":90}"
  null
  "6a60c565ce4d1"
  "2026-07-22 13:28:05"
  "2026-07-22 13:28:05"
  null
]
13 2.74 ms
"COMMIT"
Parameters:
[]
14 0.99 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.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90
]
15 3.79 ms
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
  "6a60c565ce4d1"
]
16 0.72 ms
"START TRANSACTION"
Parameters:
[]
17 3.05 ms
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[
  1
  "{"time":"0.000","output":{"userId":90}}"
  "2026-07-22 13:28:05"
  718556
]
18 2.34 ms
"COMMIT"
Parameters:
[]
19 1.34 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.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90
]
20 2.77 ms
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
  "6a60c565ce4d1"
]
21 0.32 ms
"START TRANSACTION"
Parameters:
[]
22 0.58 ms
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  "OPENWEB_REGISTER_USER-CALL_API"
  "{"userId":90}"
  null
  "6a60c565ce4d1"
  "2026-07-22 13:28:05"
  "2026-07-22 13:28:05"
  null
]
23 2.12 ms
"COMMIT"
Parameters:
[]
24 0.77 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.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90
]
25 2.27 ms
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
  "6a60c565ce4d1"
]
26 0.65 ms
"START TRANSACTION"
Parameters:
[]
27 0.70 ms
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[
  1
  "{"time":"0.546","output":"[]"}"
  "2026-07-22 13:28:06"
  718557
]
28 2.40 ms
"COMMIT"
Parameters:
[]
29 0.92 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.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90
]
30 2.92 ms
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
  "6a60c565ce4d1"
]
31 0.30 ms
"START TRANSACTION"
Parameters:
[]
32 0.52 ms
INSERT INTO audit (result, action, input, output, flow_id, created_at, updated_at, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  "OPENWEB_REGISTER_USER-CALL_API"
  "{"userId":90}"
  null
  "6a60c565ce4d1"
  "2026-07-22 13:28:06"
  "2026-07-22 13:28:06"
  null
]
33 2.87 ms
"COMMIT"
Parameters:
[]
34 0.80 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.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90
]
35 3.44 ms
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
  "6a60c565ce4d1"
]
36 0.65 ms
"START TRANSACTION"
Parameters:
[]
37 0.66 ms
UPDATE audit SET result = ?, output = ?, updated_at = ? WHERE id = ?
Parameters:
[
  1
  "{"time":"0.132","output":""}"
  "2026-07-22 13:28:06"
  718558
]
38 3.23 ms
"COMMIT"
Parameters:
[]
39 1.18 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.registration_region AS registration_region_30, t0.utm_query AS utm_query_31, t0.subscription_changed_at AS subscription_changed_at_32 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  90
]
40 2.49 ms
UPDATE audit SET user_id = 90 WHERE flow_id = ?
Parameters:
[
  "6a60c565ce4d1"
]

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.