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

Query Metrics

28 Database Queries
6 Different statements
15.40 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.66 ms
(23.77%)
7
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"
]
3.31 ms
(21.52%)
7
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
]
2.73 ms
(17.72%)
7
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"
]
2.52 ms
(16.37%)
1
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
]
1.99 ms
(12.92%)
1
SELECT t0_.subtitle AS subtitle_0 FROM transaction_history t0_ WHERE t0_.type = ? GROUP BY t0_.subtitle
Parameters:
[
  4
]
1.19 ms
(7.70%)
5
SELECT t0_.amount AS amount_0 FROM transaction_history t0_ WHERE t0_.type = ?
Parameters:
[
  1
]

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.