https://www.xrpverse.app/

Query Metrics

4 Database Queries
4 Different statements
1.48 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.63 ms
(42.55%)
1
SELECT 
                SUM(uot.`token_amount`) AS stagePurchase
            FROM `user_order_token` uot
             WHERE uot.`status` = "Completed"
Parameters:
[]
0.30 ms
(20.38%)
1
SELECT 
                COUNT(uot.`id`) AS orderCtr
            FROM `user_order_token` uot
             WHERE uot.`status` = "Completed"
            GROUP BY uot.`user_id`
Parameters:
[]
0.29 ms
(19.92%)
1
SELECT 
                COUNT(u.`id`) AS userCount
            FROM `user` u
            WHERE u.`status` = 'Active'
            AND u.`type` = 'Member'
Parameters:
[]
0.25 ms
(17.15%)
1
SELECT 
                SUM(uob.`amount`) AS amt
            FROM `user_bonus_token` uob
Parameters:
[]

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\UserOrderTokenEntity
  • The association App\Entity\UserOrderTokenEntity#user refers to the inverse side field App\Entity\UserEntity#userAccessTokens which does not exist.
App\Entity\UserEntity
  • The field App\Entity\UserEntity#referral is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\ReferralEntity#referrent does not contain the required 'mappedBy="referral"' attribute.
  • The mappings App\Entity\UserEntity#userOrderTokens and App\Entity\UserOrderTokenEntity#user are inconsistent with each other.
App\Entity\UserBonusTokenEntity No errors.