Query Metrics
18
Database Queries
8
Different statements
9.71 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.90 ms |
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:
[] |
| 2 | 1.52 ms |
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
]
|
| 3 | 0.50 ms |
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
]
|
| 4 | 0.35 ms |
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:
[
5
]
|
| 5 | 1.55 ms |
SELECT MAX(i0_.rate) AS sclr_0 FROM investment i0_ WHERE i0_.smart_contract IN (?, ?, ?)
Parameters:
[ 8642798 2452345 6345345 ] |
| 6 | 0.22 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
1
]
|
| 7 | 0.19 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
3
]
|
| 8 | 0.19 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
5
]
|
| 9 | 0.18 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
6
]
|
| 10 | 0.21 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
7
]
|
| 11 | 0.17 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
3
]
|
| 12 | 0.17 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
5
]
|
| 13 | 0.17 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
7
]
|
| 14 | 0.21 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
4
]
|
| 15 | 0.18 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
6
]
|
| 16 | 0.33 ms |
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:
[] |
| 17 | 0.44 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ? AND t0_.date >= ?
Parameters:
[ 4 "2028-10-1" ] |
| 18 | 0.22 ms |
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. |