https://activityme.sf9.io/search?sport=open_water

Query Metrics

5 Database Queries
4 Different statements
91.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
73.28 ms
(80.34%)
1
SELECT t0.currency AS currency_1, t0.amount AS amount_2, t0.date AS date_3, t0.base AS base_4, t0.id AS id_5, t0.rate_id AS rate_id_6 FROM symbol t0 WHERE t0.currency = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "USD"
]
8.56 ms
(9.38%)
1
SELECT t0.date AS date_1, t0.id AS id_2 FROM rate t0 ORDER BY t0.id DESC LIMIT 1
Parameters:
[]
6.58 ms
(7.22%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.colorCode AS colorCode_4, t0.nameAr AS nameAr_5, t0.position AS position_6, t0.parent_category_id AS parent_category_id_7 FROM category t0
Parameters:
[]
2.79 ms
(3.06%)
1
SELECT t0.currency AS currency_1, t0.amount AS amount_2, t0.date AS date_3, t0.base AS base_4, t0.id AS id_5, t0.rate_id AS rate_id_6 FROM symbol t0 WHERE t0.rate_id = ?
Parameters:
[
  2
]

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.