Query Metrics
28
Database Queries
6
Different statements
15.40 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.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
]
|
| 2 | 1.99 ms |
SELECT t0_.subtitle AS subtitle_0 FROM transaction_history t0_ WHERE t0_.type = ? GROUP BY t0_.subtitle
Parameters:
[
4
]
|
| 3 | 1.46 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.smart_contract = ? LIMIT 1
Parameters:
[
"1234235"
]
|
| 4 | 1.58 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_.subtitle = ? AND t0_.type = ?
Parameters:
[ "1234235" 4 ] |
| 5 | 0.48 ms |
SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.smart_contract = ?
Parameters:
[
"1234235"
]
|
| 6 | 0.46 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.smart_contract = ? LIMIT 1
Parameters:
[
"2452345"
]
|
| 7 | 0.27 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_.subtitle = ? AND t0_.type = ?
Parameters:
[ "2452345" 4 ] |
| 8 | 0.31 ms |
SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.smart_contract = ?
Parameters:
[
"2452345"
]
|
| 9 | 0.35 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.smart_contract = ? LIMIT 1
Parameters:
[
"265541"
]
|
| 10 | 0.27 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_.subtitle = ? AND t0_.type = ?
Parameters:
[ "265541" 4 ] |
| 11 | 0.41 ms |
SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.smart_contract = ?
Parameters:
[
"265541"
]
|
| 12 | 0.40 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.smart_contract = ? LIMIT 1
Parameters:
[
"113932"
]
|
| 13 | 0.30 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_.subtitle = ? AND t0_.type = ?
Parameters:
[ "113932" 4 ] |
| 14 | 0.33 ms |
SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.smart_contract = ?
Parameters:
[
"113932"
]
|
| 15 | 0.32 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.smart_contract = ? LIMIT 1
Parameters:
[
"1445456"
]
|
| 16 | 0.31 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_.subtitle = ? AND t0_.type = ?
Parameters:
[ "1445456" 4 ] |
| 17 | 0.48 ms |
SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.smart_contract = ?
Parameters:
[
"1445456"
]
|
| 18 | 0.35 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.smart_contract = ? LIMIT 1
Parameters:
[
"546333"
]
|
| 19 | 0.30 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_.subtitle = ? AND t0_.type = ?
Parameters:
[ "546333" 4 ] |
| 20 | 0.29 ms |
SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.smart_contract = ?
Parameters:
[
"546333"
]
|
| 21 | 0.31 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.smart_contract = ? LIMIT 1
Parameters:
[
"8642798"
]
|
| 22 | 0.28 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_.subtitle = ? AND t0_.type = ?
Parameters:
[ "8642798" 4 ] |
| 23 | 0.43 ms |
SELECT i0_.id AS id_0, i0_.smart_contract AS smart_contract_1, i0_.name AS name_2, i0_.company_name AS company_name_3, i0_.location AS location_4, i0_.country AS country_5, i0_.country_flag AS country_flag_6, i0_.description AS description_7, i0_.rate AS rate_8, i0_.category AS category_9, i0_.amount AS amount_10, i0_.amount_collected AS amount_collected_11, i0_.waiting_people AS waiting_people_12, i0_.people AS people_13, i0_.economic_rating AS economic_rating_14, i0_.legal_rating AS legal_rating_15, i0_.community_rating AS community_rating_16, i0_.favorite AS favorite_17, i0_.start_date AS start_date_18, i0_.end_date AS end_date_19 FROM investment i0_ WHERE i0_.smart_contract = ?
Parameters:
[
"8642798"
]
|
| 24 | 0.26 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
1
]
|
| 25 | 0.35 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
3
]
|
| 26 | 0.19 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
5
]
|
| 27 | 0.19 ms |
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
6
]
|
| 28 | 0.21 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\Notification | No errors. |
| App\Entity\TransactionHistory | No errors. |
| App\Entity\Investment | No errors. |
| App\Entity\WaitingLine | No errors. |
| App\Entity\Rating | No errors. |