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

Query Metrics

9 Database Queries
8 Different statements
9.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.