GET http://cryptointerface.io/demo-v1.12/user/dashboard

Query Metrics

18 Database Queries
8 Different statements
9.71 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.90 ms
(29.89%)
1
SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ ORDER BY t0_.date DESC, t0_.id DESC LIMIT 7
Parameters:
[]
1.90 ms
(19.61%)
10
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
  1
]
1.55 ms
(15.97%)
1
SELECT MAX(i0_.rate) AS sclr_0 FROM investment i0_ WHERE i0_.smart_contract IN (?, ?, ?)
Parameters:
[
  8642798
  2452345
  6345345
]
1.52 ms
(15.64%)
1
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.readed AS readed_3, n0_.add_date AS add_date_4, n0_.read_date AS read_date_5, n0_.image AS image_6, n0_.style AS style_7 FROM notification n0_ WHERE n0_.readed = ? ORDER BY n0_.add_date DESC
Parameters:
[
  0
]
0.85 ms
(8.77%)
2
SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
  3
]
0.44 ms
(4.48%)
1
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ? AND t0_.date >= ?
Parameters:
[
  4
  "2028-10-1"
]
0.33 ms
(3.42%)
1
SELECT t0_.id AS id_0, t0_.icon AS icon_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t0_.amount AS amount_4, t0_.unit AS unit_5, t0_.type AS type_6, t0_.amount_style AS amount_style_7, t0_.date AS date_8 FROM transaction_history t0_ ORDER BY t0_.date DESC LIMIT 1
Parameters:
[]
0.22 ms
(2.23%)
1
SELECT t0_.subtitle AS subtitle_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
  7
]

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.

Entities Mapping

Class Mapping errors
App\Entity\TransactionHistory No errors.
App\Entity\Notification No errors.
App\Entity\Investment No errors.