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

Response
200 OK
IP
172.19.0.9
Profiled on
Token
640541

Query Metrics

28 Database Queries
9 Different statements
15.56 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.10 ms 
SELECT DISTINCT EXTRACT(YEAR FROM t.date) AS year FROM transaction_history t ORDER BY year ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 1.70 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 = ? AND t0_.date >= ? AND t0_.date <= ? ORDER BY t0_.date ASC
Parameters: 
[
  4
  "2025-01-01"
  "2025-12-31"
]
View formatted query    View runnable query    Explain query
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 = ? AND t0_.date >= ? AND t0_.date <= ? ORDER BY t0_.date ASC
Parameters: 
[
  1
  "2025-01-01"
  "2025-12-31"
]
View formatted query    View runnable query    Explain query
4 0.32 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 = ? AND t0_.date >= ? AND t0_.date <= ? ORDER BY t0_.date ASC
Parameters: 
[
  3
  "2025-01-01"
  "2025-12-31"
]
View formatted query    View runnable query    Explain query
5 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_.type = ? AND t0_.date >= ? AND t0_.date <= ? ORDER BY t0_.date ASC
Parameters: 
[
  6
  "2025-01-01"
  "2025-12-31"
]
View formatted query    View runnable query    Explain query
6 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_.type = ? AND t0_.date >= ? AND t0_.date <= ? ORDER BY t0_.date ASC
Parameters: 
[
  5
  "2025-01-01"
  "2025-12-31"
]
View formatted query    View runnable query    Explain query
7 1.65 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
]
View formatted query    View runnable query    Explain query
8 0.29 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
]
View formatted query    View runnable query    Explain query
9 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_.type = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
10 1.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
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 0.42 ms 
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.amount AS amount_5, t0.unit AS unit_6, t0.type AS type_7, t0.amount_style AS amount_style_8, t0.date AS date_9 FROM transaction_history t0 WHERE t0.type = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
12 0.25 ms 
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.amount AS amount_5, t0.unit AS unit_6, t0.type AS type_7, t0.amount_style AS amount_style_8, t0.date AS date_9 FROM transaction_history t0 WHERE t0.type = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
13 0.26 ms 
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.amount AS amount_5, t0.unit AS unit_6, t0.type AS type_7, t0.amount_style AS amount_style_8, t0.date AS date_9 FROM transaction_history t0 WHERE t0.type = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
14 0.45 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
Parameters: 
[]
View formatted query    View runnable query    Explain query
15 0.33 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
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 0.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_.type = ? AND t0_.date >= ? AND t0_.date <= ?
Parameters: 
[
  4
  "2025-01-01"
  "2025-12-31"
]
View formatted query    View runnable query    Explain query
17 0.56 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
]
View formatted query    View runnable query    Explain query
18 0.37 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
]
View formatted query    View runnable query    Explain query
19 0.33 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
]
View formatted query    View runnable query    Explain query
20 0.22 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
21 0.33 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
22 0.21 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
23 0.21 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
24 0.31 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
25 0.21 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
26 0.22 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
27 0.26 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
28 0.17 ms 
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query

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.
App\Entity\WaitingLine No errors.
App\Entity\Rating No errors.