Symfony Profiler

SELECT
  u0_.created AS created_0,
  u0_.modified AS modified_1,
  u0_.id AS id_2,
  u0_.device_id AS device_id_3,
  u0_.device_os AS device_os_4,
  u0_.token AS token_5,
  u0_.token_expiry_date AS token_expiry_date_6,
  u0_.push_token AS push_token_7,
  u0_.last_used_ip AS last_used_ip_8,
  u0_.is_active AS is_active_9,
  u0_.is_web AS is_web_10,
  u0_.remember_me AS remember_me_11,
  u0_.status AS status_12,
  u0_.logout_trigger AS logout_trigger_13,
  u0_.logout_date AS logout_date_14,
  u0_.logout_ip AS logout_ip_15,
  u0_.deleted AS deleted_16,
  u0_.user_id AS user_id_17
FROM
  user_device u0_
WHERE
  (
    u0_.is_active = ?
    AND u0_.token = ?
    AND u0_.token_expiry_date > ?
  )
  AND (u0_.deleted IS NULL)
ORDER BY
  u0_.id DESC
LIMIT
  1

SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.device_id AS device_id_3, u0_.device_os AS device_os_4, u0_.token AS token_5, u0_.token_expiry_date AS token_expiry_date_6, u0_.push_token AS push_token_7, u0_.last_used_ip AS last_used_ip_8, u0_.is_active AS is_active_9, u0_.is_web AS is_web_10, u0_.remember_me AS remember_me_11, u0_.status AS status_12, u0_.logout_trigger AS logout_trigger_13, u0_.logout_date AS logout_date_14, u0_.logout_ip AS logout_ip_15, u0_.deleted AS deleted_16, u0_.user_id AS user_id_17 FROM user_device u0_ WHERE (u0_.is_active = 1 AND u0_.token = '120e62f5a26fb56b639d7' AND u0_.token_expiry_date > '2024-03-27 13:00:31') AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1;

SELECT
  t0.created AS created_1,
  t0.modified AS modified_2,
  t0.id AS id_3,
  t0.unique_id AS unique_id_4,
  t0.enabled AS enabled_5,
  t0.roles AS roles_6,
  t0.additional_permissions AS additional_permissions_7,
  t0.customer_reference AS customer_reference_8,
  t0.customer_email AS customer_email_9,
  t0.title AS title_10,
  t0.first_name AS first_name_11,
  t0.last_name AS last_name_12,
  t0.username AS username_13,
  t0.email AS email_14,
  t0.password AS password_15,
  t0.birth_date AS birth_date_16,
  t0.address_one AS address_one_17,
  t0.address_two AS address_two_18,
  t0.flat_number AS flat_number_19,
  t0.house_name_number AS house_name_number_20,
  t0.city AS city_21,
  t0.state AS state_22,
  t0.post_code AS post_code_23,
  t0.mobile_country_code AS mobile_country_code_24,
  t0.mobile_short AS mobile_short_25,
  t0.mobile AS mobile_26,
  t0.about AS about_27,
  t0.currency AS currency_28,
  t0.last_logout AS last_logout_29,
  t0.status AS status_30,
  t0.is_vip AS is_vip_31,
  t0.kyc_status AS kyc_status_32,
  t0.kyc_state AS kyc_state_33,
  t0.address_reference AS address_reference_34,
  t0.push_notifications AS push_notifications_35,
  t0.email_notifications AS email_notifications_36,
  t0.one_time_password AS one_time_password_37,
  t0.total_balance AS total_balance_38,
  t0.image AS image_39,
  t0.unread_notifications AS unread_notifications_40,
  t0.accepted_marketing_consent AS accepted_marketing_consent_41,
  t0.confirmation_token AS confirmation_token_42,
  t0.last_login AS last_login_43,
  t0.login_lock_expiration AS login_lock_expiration_44,
  t0.password_requested_at AS password_requested_at_45,
  t0.is_superadmin AS is_superadmin_46,
  t0.funds_source AS funds_source_47,
  t0.admin_mfa_enabled AS admin_mfa_enabled_48,
  t0.deleted AS deleted_49,
  t0.customer_id AS customer_id_50,
  t0.country_id AS country_id_51,
  t0.delivery_country_id AS delivery_country_id_52,
  t0.change_request_id AS change_request_id_53,
  t0.accepted_terms_id AS accepted_terms_id_54,
  t0.accepted_privacy_id AS accepted_privacy_id_55,
  t0.personal_manager_id AS personal_manager_id_56
FROM
  user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted IS NULL)
  )

SELECT t0.created AS created_1, t0.modified AS modified_2, t0.id AS id_3, t0.unique_id AS unique_id_4, t0.enabled AS enabled_5, t0.roles AS roles_6, t0.additional_permissions AS additional_permissions_7, t0.customer_reference AS customer_reference_8, t0.customer_email AS customer_email_9, t0.title AS title_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.username AS username_13, t0.email AS email_14, t0.password AS password_15, t0.birth_date AS birth_date_16, t0.address_one AS address_one_17, t0.address_two AS address_two_18, t0.flat_number AS flat_number_19, t0.house_name_number AS house_name_number_20, t0.city AS city_21, t0.state AS state_22, t0.post_code AS post_code_23, t0.mobile_country_code AS mobile_country_code_24, t0.mobile_short AS mobile_short_25, t0.mobile AS mobile_26, t0.about AS about_27, t0.currency AS currency_28, t0.last_logout AS last_logout_29, t0.status AS status_30, t0.is_vip AS is_vip_31, t0.kyc_status AS kyc_status_32, t0.kyc_state AS kyc_state_33, t0.address_reference AS address_reference_34, t0.push_notifications AS push_notifications_35, t0.email_notifications AS email_notifications_36, t0.one_time_password AS one_time_password_37, t0.total_balance AS total_balance_38, t0.image AS image_39, t0.unread_notifications AS unread_notifications_40, t0.accepted_marketing_consent AS accepted_marketing_consent_41, t0.confirmation_token AS confirmation_token_42, t0.last_login AS last_login_43, t0.login_lock_expiration AS login_lock_expiration_44, t0.password_requested_at AS password_requested_at_45, t0.is_superadmin AS is_superadmin_46, t0.funds_source AS funds_source_47, t0.admin_mfa_enabled AS admin_mfa_enabled_48, t0.deleted AS deleted_49, t0.customer_id AS customer_id_50, t0.country_id AS country_id_51, t0.delivery_country_id AS delivery_country_id_52, t0.change_request_id AS change_request_id_53, t0.accepted_terms_id AS accepted_terms_id_54, t0.accepted_privacy_id AS accepted_privacy_id_55, t0.personal_manager_id AS personal_manager_id_56 FROM user t0 WHERE t0.id = 1 AND ((t0.deleted IS NULL));

SELECT
  u0_.created AS created_0,
  u0_.modified AS modified_1,
  u0_.id AS id_2,
  u0_.is_active AS is_active_3,
  u0_.user_agent AS user_agent_4,
  u0_.ip_address AS ip_address_5,
  u0_.deleted AS deleted_6,
  u0_.user_id AS user_id_7,
  u0_.device_id AS device_id_8
FROM
  user_session u0_
WHERE
  (
    u0_.user_id = ?
    AND u0_.is_active = ?
  )
  AND (u0_.deleted IS NULL)
LIMIT
  1

SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.is_active AS is_active_3, u0_.user_agent AS user_agent_4, u0_.ip_address AS ip_address_5, u0_.deleted AS deleted_6, u0_.user_id AS user_id_7, u0_.device_id AS device_id_8 FROM user_session u0_ WHERE (u0_.user_id = 1 AND u0_.is_active = 1) AND (u0_.deleted IS NULL) LIMIT 1;

SELECT
  t0.created AS created_1,
  t0.modified AS modified_2,
  t0.id AS id_3,
  t0.device_id AS device_id_4,
  t0.device_os AS device_os_5,
  t0.token AS token_6,
  t0.token_expiry_date AS token_expiry_date_7,
  t0.push_token AS push_token_8,
  t0.last_used_ip AS last_used_ip_9,
  t0.is_active AS is_active_10,
  t0.is_web AS is_web_11,
  t0.remember_me AS remember_me_12,
  t0.status AS status_13,
  t0.logout_trigger AS logout_trigger_14,
  t0.logout_date AS logout_date_15,
  t0.logout_ip AS logout_ip_16,
  t0.deleted AS deleted_17,
  t0.user_id AS user_id_18
FROM
  user_device t0
WHERE
  t0.is_active = ?
  AND t0.user_id = ?
  AND t0.device_id IS NULL
  AND (
    (t0.deleted IS NULL)
  )
LIMIT
  1

SELECT t0.created AS created_1, t0.modified AS modified_2, t0.id AS id_3, t0.device_id AS device_id_4, t0.device_os AS device_os_5, t0.token AS token_6, t0.token_expiry_date AS token_expiry_date_7, t0.push_token AS push_token_8, t0.last_used_ip AS last_used_ip_9, t0.is_active AS is_active_10, t0.is_web AS is_web_11, t0.remember_me AS remember_me_12, t0.status AS status_13, t0.logout_trigger AS logout_trigger_14, t0.logout_date AS logout_date_15, t0.logout_ip AS logout_ip_16, t0.deleted AS deleted_17, t0.user_id AS user_id_18 FROM user_device t0 WHERE t0.is_active = 1 AND t0.user_id = 1 AND t0.device_id IS NULL AND ((t0.deleted IS NULL)) LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user_session
SET
  is_active = ?,
  modified = ?
WHERE
  id = ?

UPDATE user_session SET is_active = 0, modified = '2024-03-27 13:00:31' WHERE id = 9958;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_session (
  created, modified, is_active, user_agent,
  ip_address, deleted, user_id, device_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_session (created, modified, is_active, user_agent, ip_address, deleted, user_id, device_id) VALUES ('2024-03-27 13:00:31', '2024-03-27 13:00:31', 1, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2.1 Safari/605.1.15', '91.143.218.42', NULL, 1, 11);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_action (
  created, modified, action, description,
  ip_address, is_successful, type,
  deleted, user_id, session_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_action (created, modified, action, description, ip_address, is_successful, type, deleted, user_id, session_id) VALUES ('2024-03-27 13:00:31', '2024-03-27 13:00:31', 'stats.getUsersStats', 'API call', '91.143.218.42', 1, 'auto', NULL, 1, 10601);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user_device
SET
  token_expiry_date = ?,
  modified = ?
WHERE
  id = ?

UPDATE user_device SET token_expiry_date = '2024-03-27 13:20:31', modified = '2024-03-27 13:00:31' WHERE id = 11;

"COMMIT"

"COMMIT";

SELECT
  count(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  (u0_.deleted IS NULL)

SELECT count(u0_.id) AS sclr_0 FROM user u0_ WHERE (u0_.deleted IS NULL);

SELECT
  count(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  (u0_.created >= ?)
  AND (u0_.deleted IS NULL)

SELECT count(u0_.id) AS sclr_0 FROM user u0_ WHERE (u0_.created >= '2024-03-20 13:00:31') AND (u0_.deleted IS NULL);

SELECT
  count(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  (u0_.created >= ?)
  AND (u0_.deleted IS NULL)

SELECT count(u0_.id) AS sclr_0 FROM user u0_ WHERE (u0_.created >= '2024-02-27 13:00:31') AND (u0_.deleted IS NULL);

SELECT
  count(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  (u0_.created >= ?)
  AND (u0_.deleted IS NULL)

SELECT count(u0_.id) AS sclr_0 FROM user u0_ WHERE (u0_.created >= '2023-03-27 13:00:31') AND (u0_.deleted IS NULL);

SELECT
  u0_.created AS created_0,
  u0_.modified AS modified_1,
  u0_.id AS id_2,
  u0_.action AS action_3,
  u0_.description AS description_4,
  u0_.ip_address AS ip_address_5,
  u0_.is_successful AS is_successful_6,
  u0_.type AS type_7,
  u0_.deleted AS deleted_8,
  u0_.user_id AS user_id_9,
  u0_.session_id AS session_id_10
FROM
  user_action u0_
WHERE
  (u0_.action = ?)
  AND (u0_.deleted IS NULL)
ORDER BY
  u0_.id DESC
LIMIT
  1

SELECT u0_.created AS created_0, u0_.modified AS modified_1, u0_.id AS id_2, u0_.action AS action_3, u0_.description AS description_4, u0_.ip_address AS ip_address_5, u0_.is_successful AS is_successful_6, u0_.type AS type_7, u0_.deleted AS deleted_8, u0_.user_id AS user_id_9, u0_.session_id AS session_id_10 FROM user_action u0_ WHERE (u0_.action = 'stats.getUsersStats') AND (u0_.deleted IS NULL) ORDER BY u0_.id DESC LIMIT 1;