Query Metrics
10
Database Queries
8
Different statements
11.02 ms
Query time
0
Invalid entities
118
Managed entities
Queries
| #▲ | 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. |