Query Metrics
4
Database Queries
4
Different statements
1.48 ms
Query time
2
Invalid entities
Grouped Statements
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 |
|
App\Entity\UserEntity |
|
App\Entity\UserBonusTokenEntity | No errors. |