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 = '594254e7363f4287a7fc9' AND u0_.token_expiry_date > '2024-03-28 11:28:43') 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 = 5 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 = 5 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 = 5 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-28 11:28:43' WHERE id = 10359;

"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-28 11:28:43', '2024-03-28 11:28:43', 1, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36', '91.143.218.42', NULL, 5, 15);

"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-28 11:28:43', '2024-03-28 11:28:43', 'transaction.getPaymentTransactionList', 'API call', '91.143.218.42', 1, 'auto', NULL, 5, 10707);

"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-28 11:48:43', modified = '2024-03-28 11:28:43' WHERE id = 15;

"COMMIT"

"COMMIT";

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_2
    FROM
      (
        SELECT
          t0_.created AS created_0,
          t0_.modified AS modified_1,
          t0_.id AS id_2,
          t0_.title AS title_3,
          t0_.note AS note_4,
          t0_.merchant_name AS merchant_name_5,
          t0_.merchant_street AS merchant_street_6,
          t0_.merchant_city AS merchant_city_7,
          t0_.merchant_region AS merchant_region_8,
          t0_.merchant_postcode AS merchant_postcode_9,
          t0_.merchant_country AS merchant_country_10,
          t0_.country_code AS country_code_11,
          t0_.amount AS amount_12,
          t0_.amount_currency AS amount_currency_13,
          t0_.original_amount AS original_amount_14,
          t0_.original_amount_currency AS original_amount_currency_15,
          t0_.fee AS fee_16,
          t0_.fee_currency AS fee_currency_17,
          t0_.card_token AS card_token_18,
          t0_.mcc AS mcc_19,
          t0_.transaction_date AS transaction_date_20,
          t0_.post_date AS post_date_21,
          t0_.external_reference AS external_reference_22,
          t0_.transaction_group AS transaction_group_23,
          t0_.status AS status_24,
          t0_.type AS type_25,
          t0_.gps_latitude AS gps_latitude_26,
          t0_.gps_longitude AS gps_longitude_27,
          t0_.running_balance AS running_balance_28,
          t0_.auth_id AS auth_id_29,
          t0_.fin_id AS fin_id_30,
          t0_.load_id AS load_id_31,
          t0_.load_source AS load_source_32,
          t0_.is_fx AS is_fx_33,
          t0_.deleted AS deleted_34
        FROM
          transaction t0_
        WHERE
          (
            t0_.title LIKE ?
            OR t0_.note LIKE ?
            OR t0_.merchant_name LIKE ?
            OR t0_.merchant_street LIKE ?
            OR t0_.merchant_city LIKE ?
            OR t0_.merchant_region LIKE ?
            OR t0_.merchant_postcode LIKE ?
            OR t0_.merchant_country LIKE ?
            OR t0_.country_code LIKE ?
            OR t0_.amount_currency LIKE ?
            OR t0_.original_amount_currency LIKE ?
            OR t0_.fee_currency LIKE ?
            OR t0_.card_token LIKE ?
            OR t0_.mcc LIKE ?
            OR t0_.external_reference LIKE ?
            OR t0_.transaction_group LIKE ?
            OR t0_.status LIKE ?
            OR t0_.type LIKE ?
            OR t0_.gps_latitude LIKE ?
            OR t0_.gps_longitude LIKE ?
            OR t0_.auth_id LIKE ?
            OR t0_.fin_id LIKE ?
            OR t0_.load_id LIKE ?
            OR t0_.load_source LIKE ?
          )
          AND (t0_.deleted IS NULL)
        ORDER BY
          t0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT t0_.created AS created_0, t0_.modified AS modified_1, t0_.id AS id_2, t0_.title AS title_3, t0_.note AS note_4, t0_.merchant_name AS merchant_name_5, t0_.merchant_street AS merchant_street_6, t0_.merchant_city AS merchant_city_7, t0_.merchant_region AS merchant_region_8, t0_.merchant_postcode AS merchant_postcode_9, t0_.merchant_country AS merchant_country_10, t0_.country_code AS country_code_11, t0_.amount AS amount_12, t0_.amount_currency AS amount_currency_13, t0_.original_amount AS original_amount_14, t0_.original_amount_currency AS original_amount_currency_15, t0_.fee AS fee_16, t0_.fee_currency AS fee_currency_17, t0_.card_token AS card_token_18, t0_.mcc AS mcc_19, t0_.transaction_date AS transaction_date_20, t0_.post_date AS post_date_21, t0_.external_reference AS external_reference_22, t0_.transaction_group AS transaction_group_23, t0_.status AS status_24, t0_.type AS type_25, t0_.gps_latitude AS gps_latitude_26, t0_.gps_longitude AS gps_longitude_27, t0_.running_balance AS running_balance_28, t0_.auth_id AS auth_id_29, t0_.fin_id AS fin_id_30, t0_.load_id AS load_id_31, t0_.load_source AS load_source_32, t0_.is_fx AS is_fx_33, t0_.deleted AS deleted_34 FROM transaction t0_ WHERE (t0_.title LIKE '%%' OR t0_.note LIKE '%%' OR t0_.merchant_name LIKE '%%' OR t0_.merchant_street LIKE '%%' OR t0_.merchant_city LIKE '%%' OR t0_.merchant_region LIKE '%%' OR t0_.merchant_postcode LIKE '%%' OR t0_.merchant_country LIKE '%%' OR t0_.country_code LIKE '%%' OR t0_.amount_currency LIKE '%%' OR t0_.original_amount_currency LIKE '%%' OR t0_.fee_currency LIKE '%%' OR t0_.card_token LIKE '%%' OR t0_.mcc LIKE '%%' OR t0_.external_reference LIKE '%%' OR t0_.transaction_group LIKE '%%' OR t0_.status LIKE '%%' OR t0_.type LIKE '%%' OR t0_.gps_latitude LIKE '%%' OR t0_.gps_longitude LIKE '%%' OR t0_.auth_id LIKE '%%' OR t0_.fin_id LIKE '%%' OR t0_.load_id LIKE '%%' OR t0_.load_source LIKE '%%') AND (t0_.deleted IS NULL) ORDER BY t0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_2
FROM
  (
    SELECT
      DISTINCT id_2
    FROM
      (
        SELECT
          t0_.created AS created_0,
          t0_.modified AS modified_1,
          t0_.id AS id_2,
          t0_.title AS title_3,
          t0_.note AS note_4,
          t0_.merchant_name AS merchant_name_5,
          t0_.merchant_street AS merchant_street_6,
          t0_.merchant_city AS merchant_city_7,
          t0_.merchant_region AS merchant_region_8,
          t0_.merchant_postcode AS merchant_postcode_9,
          t0_.merchant_country AS merchant_country_10,
          t0_.country_code AS country_code_11,
          t0_.amount AS amount_12,
          t0_.amount_currency AS amount_currency_13,
          t0_.original_amount AS original_amount_14,
          t0_.original_amount_currency AS original_amount_currency_15,
          t0_.fee AS fee_16,
          t0_.fee_currency AS fee_currency_17,
          t0_.card_token AS card_token_18,
          t0_.mcc AS mcc_19,
          t0_.transaction_date AS transaction_date_20,
          t0_.post_date AS post_date_21,
          t0_.external_reference AS external_reference_22,
          t0_.transaction_group AS transaction_group_23,
          t0_.status AS status_24,
          t0_.type AS type_25,
          t0_.gps_latitude AS gps_latitude_26,
          t0_.gps_longitude AS gps_longitude_27,
          t0_.running_balance AS running_balance_28,
          t0_.auth_id AS auth_id_29,
          t0_.fin_id AS fin_id_30,
          t0_.load_id AS load_id_31,
          t0_.load_source AS load_source_32,
          t0_.is_fx AS is_fx_33,
          t0_.deleted AS deleted_34
        FROM
          transaction t0_
        WHERE
          (
            t0_.title LIKE ?
            OR t0_.note LIKE ?
            OR t0_.merchant_name LIKE ?
            OR t0_.merchant_street LIKE ?
            OR t0_.merchant_city LIKE ?
            OR t0_.merchant_region LIKE ?
            OR t0_.merchant_postcode LIKE ?
            OR t0_.merchant_country LIKE ?
            OR t0_.country_code LIKE ?
            OR t0_.amount_currency LIKE ?
            OR t0_.original_amount_currency LIKE ?
            OR t0_.fee_currency LIKE ?
            OR t0_.card_token LIKE ?
            OR t0_.mcc LIKE ?
            OR t0_.external_reference LIKE ?
            OR t0_.transaction_group LIKE ?
            OR t0_.status LIKE ?
            OR t0_.type LIKE ?
            OR t0_.gps_latitude LIKE ?
            OR t0_.gps_longitude LIKE ?
            OR t0_.auth_id LIKE ?
            OR t0_.fin_id LIKE ?
            OR t0_.load_id LIKE ?
            OR t0_.load_source LIKE ?
          )
          AND (t0_.deleted IS NULL)
      ) dctrn_result_inner
    ORDER BY
      id_2 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_2 FROM (SELECT DISTINCT id_2 FROM (SELECT t0_.created AS created_0, t0_.modified AS modified_1, t0_.id AS id_2, t0_.title AS title_3, t0_.note AS note_4, t0_.merchant_name AS merchant_name_5, t0_.merchant_street AS merchant_street_6, t0_.merchant_city AS merchant_city_7, t0_.merchant_region AS merchant_region_8, t0_.merchant_postcode AS merchant_postcode_9, t0_.merchant_country AS merchant_country_10, t0_.country_code AS country_code_11, t0_.amount AS amount_12, t0_.amount_currency AS amount_currency_13, t0_.original_amount AS original_amount_14, t0_.original_amount_currency AS original_amount_currency_15, t0_.fee AS fee_16, t0_.fee_currency AS fee_currency_17, t0_.card_token AS card_token_18, t0_.mcc AS mcc_19, t0_.transaction_date AS transaction_date_20, t0_.post_date AS post_date_21, t0_.external_reference AS external_reference_22, t0_.transaction_group AS transaction_group_23, t0_.status AS status_24, t0_.type AS type_25, t0_.gps_latitude AS gps_latitude_26, t0_.gps_longitude AS gps_longitude_27, t0_.running_balance AS running_balance_28, t0_.auth_id AS auth_id_29, t0_.fin_id AS fin_id_30, t0_.load_id AS load_id_31, t0_.load_source AS load_source_32, t0_.is_fx AS is_fx_33, t0_.deleted AS deleted_34 FROM transaction t0_ WHERE (t0_.title LIKE '%%' OR t0_.note LIKE '%%' OR t0_.merchant_name LIKE '%%' OR t0_.merchant_street LIKE '%%' OR t0_.merchant_city LIKE '%%' OR t0_.merchant_region LIKE '%%' OR t0_.merchant_postcode LIKE '%%' OR t0_.merchant_country LIKE '%%' OR t0_.country_code LIKE '%%' OR t0_.amount_currency LIKE '%%' OR t0_.original_amount_currency LIKE '%%' OR t0_.fee_currency LIKE '%%' OR t0_.card_token LIKE '%%' OR t0_.mcc LIKE '%%' OR t0_.external_reference LIKE '%%' OR t0_.transaction_group LIKE '%%' OR t0_.status LIKE '%%' OR t0_.type LIKE '%%' OR t0_.gps_latitude LIKE '%%' OR t0_.gps_longitude LIKE '%%' OR t0_.auth_id LIKE '%%' OR t0_.fin_id LIKE '%%' OR t0_.load_id LIKE '%%' OR t0_.load_source LIKE '%%') AND (t0_.deleted IS NULL)) dctrn_result_inner ORDER BY id_2 DESC) dctrn_result LIMIT 20;

SELECT
  t0_.created AS created_0,
  t0_.modified AS modified_1,
  t0_.id AS id_2,
  t0_.title AS title_3,
  t0_.note AS note_4,
  t0_.merchant_name AS merchant_name_5,
  t0_.merchant_street AS merchant_street_6,
  t0_.merchant_city AS merchant_city_7,
  t0_.merchant_region AS merchant_region_8,
  t0_.merchant_postcode AS merchant_postcode_9,
  t0_.merchant_country AS merchant_country_10,
  t0_.country_code AS country_code_11,
  t0_.amount AS amount_12,
  t0_.amount_currency AS amount_currency_13,
  t0_.original_amount AS original_amount_14,
  t0_.original_amount_currency AS original_amount_currency_15,
  t0_.fee AS fee_16,
  t0_.fee_currency AS fee_currency_17,
  t0_.card_token AS card_token_18,
  t0_.mcc AS mcc_19,
  t0_.transaction_date AS transaction_date_20,
  t0_.post_date AS post_date_21,
  t0_.external_reference AS external_reference_22,
  t0_.transaction_group AS transaction_group_23,
  t0_.status AS status_24,
  t0_.type AS type_25,
  t0_.gps_latitude AS gps_latitude_26,
  t0_.gps_longitude AS gps_longitude_27,
  t0_.running_balance AS running_balance_28,
  t0_.auth_id AS auth_id_29,
  t0_.fin_id AS fin_id_30,
  t0_.load_id AS load_id_31,
  t0_.load_source AS load_source_32,
  t0_.is_fx AS is_fx_33,
  t0_.deleted AS deleted_34,
  t0_.user_id AS user_id_35,
  t0_.account_id AS account_id_36,
  t0_.payment_device_id AS payment_device_id_37,
  t0_.category_id AS category_id_38,
  t0_.merchant_id AS merchant_id_39,
  t0_.country_id AS country_id_40,
  t0_.payment_card_id AS payment_card_id_41,
  t0_.fx_fee_id AS fx_fee_id_42
FROM
  transaction t0_
WHERE
  (
    (
      t0_.title LIKE ?
      OR t0_.note LIKE ?
      OR t0_.merchant_name LIKE ?
      OR t0_.merchant_street LIKE ?
      OR t0_.merchant_city LIKE ?
      OR t0_.merchant_region LIKE ?
      OR t0_.merchant_postcode LIKE ?
      OR t0_.merchant_country LIKE ?
      OR t0_.country_code LIKE ?
      OR t0_.amount_currency LIKE ?
      OR t0_.original_amount_currency LIKE ?
      OR t0_.fee_currency LIKE ?
      OR t0_.card_token LIKE ?
      OR t0_.mcc LIKE ?
      OR t0_.external_reference LIKE ?
      OR t0_.transaction_group LIKE ?
      OR t0_.status LIKE ?
      OR t0_.type LIKE ?
      OR t0_.gps_latitude LIKE ?
      OR t0_.gps_longitude LIKE ?
      OR t0_.auth_id LIKE ?
      OR t0_.fin_id LIKE ?
      OR t0_.load_id LIKE ?
      OR t0_.load_source LIKE ?
    )
    AND t0_.id IN (?)
  )
  AND (t0_.deleted IS NULL)
ORDER BY
  t0_.id DESC

SELECT t0_.created AS created_0, t0_.modified AS modified_1, t0_.id AS id_2, t0_.title AS title_3, t0_.note AS note_4, t0_.merchant_name AS merchant_name_5, t0_.merchant_street AS merchant_street_6, t0_.merchant_city AS merchant_city_7, t0_.merchant_region AS merchant_region_8, t0_.merchant_postcode AS merchant_postcode_9, t0_.merchant_country AS merchant_country_10, t0_.country_code AS country_code_11, t0_.amount AS amount_12, t0_.amount_currency AS amount_currency_13, t0_.original_amount AS original_amount_14, t0_.original_amount_currency AS original_amount_currency_15, t0_.fee AS fee_16, t0_.fee_currency AS fee_currency_17, t0_.card_token AS card_token_18, t0_.mcc AS mcc_19, t0_.transaction_date AS transaction_date_20, t0_.post_date AS post_date_21, t0_.external_reference AS external_reference_22, t0_.transaction_group AS transaction_group_23, t0_.status AS status_24, t0_.type AS type_25, t0_.gps_latitude AS gps_latitude_26, t0_.gps_longitude AS gps_longitude_27, t0_.running_balance AS running_balance_28, t0_.auth_id AS auth_id_29, t0_.fin_id AS fin_id_30, t0_.load_id AS load_id_31, t0_.load_source AS load_source_32, t0_.is_fx AS is_fx_33, t0_.deleted AS deleted_34, t0_.user_id AS user_id_35, t0_.account_id AS account_id_36, t0_.payment_device_id AS payment_device_id_37, t0_.category_id AS category_id_38, t0_.merchant_id AS merchant_id_39, t0_.country_id AS country_id_40, t0_.payment_card_id AS payment_card_id_41, t0_.fx_fee_id AS fx_fee_id_42 FROM transaction t0_ WHERE ((t0_.title LIKE '%%' OR t0_.note LIKE '%%' OR t0_.merchant_name LIKE '%%' OR t0_.merchant_street LIKE '%%' OR t0_.merchant_city LIKE '%%' OR t0_.merchant_region LIKE '%%' OR t0_.merchant_postcode LIKE '%%' OR t0_.merchant_country LIKE '%%' OR t0_.country_code LIKE '%%' OR t0_.amount_currency LIKE '%%' OR t0_.original_amount_currency LIKE '%%' OR t0_.fee_currency LIKE '%%' OR t0_.card_token LIKE '%%' OR t0_.mcc LIKE '%%' OR t0_.external_reference LIKE '%%' OR t0_.transaction_group LIKE '%%' OR t0_.status LIKE '%%' OR t0_.type LIKE '%%' OR t0_.gps_latitude LIKE '%%' OR t0_.gps_longitude LIKE '%%' OR t0_.auth_id LIKE '%%' OR t0_.fin_id LIKE '%%' OR t0_.load_id LIKE '%%' OR t0_.load_source LIKE '%%') AND t0_.id IN (40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 24, 23, 22, 21)) AND (t0_.deleted IS NULL) ORDER BY t0_.id DESC;

SELECT
  t0.created AS created_1,
  t0.modified AS modified_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.icon AS icon_5,
  t0.is_default AS is_default_6,
  t0.deleted AS deleted_7
FROM
  transaction_category 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.name AS name_4, t0.icon AS icon_5, t0.is_default AS is_default_6, t0.deleted AS deleted_7 FROM transaction_category t0 WHERE t0.id = 1 AND ((t0.deleted IS NULL));

SELECT
  t0.created AS created_1,
  t0.modified AS modified_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.icon AS icon_5,
  t0.is_default AS is_default_6,
  t0.deleted AS deleted_7
FROM
  transaction_category 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.name AS name_4, t0.icon AS icon_5, t0.is_default AS is_default_6, t0.deleted AS deleted_7 FROM transaction_category t0 WHERE t0.id = 12 AND ((t0.deleted IS NULL));

SELECT
  t0.created AS created_1,
  t0.modified AS modified_2,
  t0.id AS id_3,
  t0.name AS name_4,
  t0.unique_token AS unique_token_5,
  t0.pan AS pan_6,
  t0.emboss AS emboss_7,
  t0.expires AS expires_8,
  t0.is_primary AS is_primary_9,
  t0.is_live AS is_live_10,
  t0.currency AS currency_11,
  t0.balance AS balance_12,
  t0.last_max_balance AS last_max_balance_13,
  t0.balance_blocked AS balance_blocked_14,
  t0.balance_final AS balance_final_15,
  t0.status AS status_16,
  t0.locked AS locked_17,
  t0.activated AS activated_18,
  t0.deactivated AS deactivated_19,
  t0.type AS type_20,
  t0.category AS category_21,
  t0.times_loaded AS times_loaded_22,
  t0.limit_group AS limit_group_23,
  t0.perms_group AS perms_group_24,
  t0.contactless AS contactless_25,
  t0.overseas AS overseas_26,
  t0.ecommerce AS ecommerce_27,
  t0.is_wallet AS is_wallet_28,
  t0.three_ds_number AS three_ds_number_29,
  t0.image AS image_30,
  t0.back_image AS back_image_31,
  t0.deleted AS deleted_32,
  t0.account_id AS account_id_33,
  t0.user_id AS user_id_34,
  t0.payment_device_product_id AS payment_device_product_id_35,
  t0.parent_id AS parent_id_36
FROM
  payment_device 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.name AS name_4, t0.unique_token AS unique_token_5, t0.pan AS pan_6, t0.emboss AS emboss_7, t0.expires AS expires_8, t0.is_primary AS is_primary_9, t0.is_live AS is_live_10, t0.currency AS currency_11, t0.balance AS balance_12, t0.last_max_balance AS last_max_balance_13, t0.balance_blocked AS balance_blocked_14, t0.balance_final AS balance_final_15, t0.status AS status_16, t0.locked AS locked_17, t0.activated AS activated_18, t0.deactivated AS deactivated_19, t0.type AS type_20, t0.category AS category_21, t0.times_loaded AS times_loaded_22, t0.limit_group AS limit_group_23, t0.perms_group AS perms_group_24, t0.contactless AS contactless_25, t0.overseas AS overseas_26, t0.ecommerce AS ecommerce_27, t0.is_wallet AS is_wallet_28, t0.three_ds_number AS three_ds_number_29, t0.image AS image_30, t0.back_image AS back_image_31, t0.deleted AS deleted_32, t0.account_id AS account_id_33, t0.user_id AS user_id_34, t0.payment_device_product_id AS payment_device_product_id_35, t0.parent_id AS parent_id_36 FROM payment_device t0 WHERE t0.id = 2 AND ((t0.deleted IS NULL));