Query Metrics
9
Database Queries
8
Different statements
9.11 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.64 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.id = ?
Parameters:
[
6
]
|
| 2 | 1.43 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:
[
9
]
|
| 3 | 0.74 ms |
SELECT NEXTVAL('transaction_history_id_seq')
Parameters:
[] |
| 4 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.71 ms |
INSERT INTO transaction_history (id, icon, title, subtitle, amount, unit, type, amount_style, date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 171 "ri-share-forward-2-line" "waiting line" "8642798" "2500000" "ic" 7 "color:#c13f41" "2028-01-12" ] |
| 6 | 0.49 ms |
DELETE FROM waiting_line WHERE id = ?
Parameters:
[
6
]
|
| 7 | 0.52 ms |
"COMMIT"
Parameters:
[] |
| 8 | 2.08 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
]
|
| 9 | 0.37 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
]
|
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\WaitingLine | No errors. |
| App\Entity\Investment | No errors. |
| App\Entity\Rating | No errors. |
| App\Entity\TransactionHistory | No errors. |
| App\Entity\Notification | No errors. |