POST https://oeo2026.wedoit-group.com/ajax/exchangerate/1/3/4000/to/B2C/cart_allowedexceedlimit

Query Metrics

10 Database Queries
8 Different statements
11.02 ms Query time
0 Invalid entities
118 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.system AS system_4 FROM settings t0
Parameters:
[]
2 1.02 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.system AS system_4 FROM settings t0
Parameters:
[]
3 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.system AS system_4 FROM settings t0
Parameters:
[]
4 1.27 ms
SELECT t0.id AS id_1, t0.currency AS currency_2, t0.code AS code_3, t0.symbol AS symbol_4, t0.exchange_from AS exchange_from_5, t0.exchange_from_public AS exchange_from_public_6, t0.exchange_from_default AS exchange_from_default_7, t0.exchange_from_public_default AS exchange_from_public_default_8, t0.exchange_to AS exchange_to_9, t0.exchange_to_public AS exchange_to_public_10, t0.exchange_to_default AS exchange_to_default_11, t0.exchange_to_public_default AS exchange_to_public_default_12, t0.status AS status_13 FROM currencies t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "CHF"
]
5 1.05 ms
SELECT t0.id AS id_1, t0.currency AS currency_2, t0.code AS code_3, t0.symbol AS symbol_4, t0.exchange_from AS exchange_from_5, t0.exchange_from_public AS exchange_from_public_6, t0.exchange_from_default AS exchange_from_default_7, t0.exchange_from_public_default AS exchange_from_public_default_8, t0.exchange_to AS exchange_to_9, t0.exchange_to_public AS exchange_to_public_10, t0.exchange_to_default AS exchange_to_default_11, t0.exchange_to_public_default AS exchange_to_public_default_12, t0.status AS status_13 FROM currencies t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
6 1.82 ms
SELECT e0_.id AS id_0, e0_.update_date AS update_date_1, e0_.rate AS rate_2, e0_.rate_b2c AS rate_b2c_3, e0_.rate_b2c_branch AS rate_b2c_branch_4, e0_.rate_b2b AS rate_b2b_5, e0_.rate_b2b_branch AS rate_b2b_branch_6, c1_.id AS id_7, c1_.currency AS currency_8, c1_.code AS code_9, c1_.symbol AS symbol_10, c1_.exchange_from AS exchange_from_11, c1_.exchange_from_public AS exchange_from_public_12, c1_.exchange_from_default AS exchange_from_default_13, c1_.exchange_from_public_default AS exchange_from_public_default_14, c1_.exchange_to AS exchange_to_15, c1_.exchange_to_public AS exchange_to_public_16, c1_.exchange_to_default AS exchange_to_default_17, c1_.exchange_to_public_default AS exchange_to_public_default_18, c1_.status AS status_19, c2_.id AS id_20, c2_.currency AS currency_21, c2_.code AS code_22, c2_.symbol AS symbol_23, c2_.exchange_from AS exchange_from_24, c2_.exchange_from_public AS exchange_from_public_25, c2_.exchange_from_default AS exchange_from_default_26, c2_.exchange_from_public_default AS exchange_from_public_default_27, c2_.exchange_to AS exchange_to_28, c2_.exchange_to_public AS exchange_to_public_29, c2_.exchange_to_default AS exchange_to_default_30, c2_.exchange_to_public_default AS exchange_to_public_default_31, c2_.status AS status_32, e0_.currency_to_id AS currency_to_id_33, e0_.currency_from_id AS currency_from_id_34 FROM exchange_rates e0_ INNER JOIN currencies c1_ ON e0_.currency_to_id = c1_.id INNER JOIN currencies c2_ ON e0_.currency_from_id = c2_.id WHERE c1_.id = ? AND c2_.id = ? ORDER BY e0_.update_date DESC LIMIT 1
Parameters:
[
  1
  3
]
7 0.91 ms
SELECT t0.id AS id_1, t0.registration_date AS registration_date_2, t0.email AS email_3, t0.genre AS genre_4, t0.company AS company_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone_number AS phone_number_8, t0.forgot_password_id AS forgot_password_id_9, t0.forgot_password_datetime AS forgot_password_datetime_10, t0.roles AS roles_11, t0.password AS password_12, t0.newsletter AS newsletter_13, t0.allowed_exceed_limit AS allowed_exceed_limit_14, t0.orders_amount_for_coupon_code AS orders_amount_for_coupon_code_15, t0.status AS status_16, t0.activation_code AS activation_code_17, t0.language_id AS language_id_18 FROM users t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.97 ms
"START TRANSACTION"
Parameters:
[]
9 0.86 ms
INSERT INTO logs (object_id, datetime, ipaddress, entity, email, action, message, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  "2026-10-19 16:08:17"
  3280830846
  "cart"
  "tech@wedoit-group.com"
  "loadExchangeRate"
  "From currency: CHF to USD - amount: 4'836.40 - echange rate: 1.20910"
  null
]
10 0.41 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Setting 112
App\Entity\Currency 2
App\Entity\ExchangeRate 1
App\Entity\User 1
App\Entity\Language 1
App\Entity\Log 1

Entities Mapping

Class Mapping errors
App\Entity\Setting No errors.
App\Entity\Currency No errors.
App\Entity\ExchangeRate No errors.
App\Entity\BankAccount No errors.
App\Entity\CompanyBankAccount No errors.
App\Entity\User No errors.
App\Entity\Language No errors.
App\Entity\IdentityCard No errors.
App\Entity\Order No errors.
App\Entity\Address No errors.
App\Entity\Email No errors.
App\Entity\Log No errors.