Query Metrics
11
Database Queries
7
Different statements
11.04 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.61 ms |
SELECT t0.id AS id_1, t0.smart_contract AS smart_contract_2, t0.name AS name_3, t0.company_name AS company_name_4, t0.location AS location_5, t0.country AS country_6, t0.country_flag AS country_flag_7, t0.description AS description_8, t0.rate AS rate_9, t0.category AS category_10, t0.amount AS amount_11, t0.amount_collected AS amount_collected_12, t0.waiting_people AS waiting_people_13, t0.people AS people_14, t0.economic_rating AS economic_rating_15, t0.legal_rating AS legal_rating_16, t0.community_rating AS community_rating_17, t0.favorite AS favorite_18, t0.start_date AS start_date_19, t0.end_date AS end_date_20 FROM investment t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 2 | 1.93 ms |
SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.investment_id = ? AND r0_.data <= ?
Parameters:
[ 6 "2026-11-15 08:00:00" ] |
| 3 | 1.54 ms |
SELECT t0.id AS id_1, t0.amound AS amound_2, t0.data AS data_3, t0.is_user AS is_user_4, t0.investment_id AS investment_id_5 FROM waiting_line t0 WHERE t0.investment_id = ? ORDER BY t0.data ASC
Parameters:
[
6
]
|
| 4 | 1.61 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:
[] |
| 5 | 1.31 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
]
|
| 6 | 0.71 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.data AS data_3, t0.is_user AS is_user_4, t0.investment_id AS investment_id_5 FROM rating t0 WHERE t0.investment_id = ? AND t0.is_user = ? LIMIT 1
Parameters:
[ 6 1 ] |
| 7 | 0.29 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
1
]
|
| 8 | 0.27 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
3
]
|
| 9 | 0.27 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
5
]
|
| 10 | 0.20 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
6
]
|
| 11 | 0.31 ms |
SELECT t0_.amount AS amount_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\Investment | No errors. |
| App\Entity\WaitingLine | No errors. |
| App\Entity\Rating | No errors. |
| App\Entity\TransactionHistory | No errors. |
| App\Entity\Notification | No errors. |