Query Metrics
4
Database Queries
4
Different statements
1.49 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.63 ms |
SELECT SUM(uot.`token_amount`) AS stagePurchase FROM `user_order_token` uot WHERE uot.`status` = "Completed"
Parameters:
[] |
| 2 | 0.28 ms |
SELECT COUNT(uot.`id`) AS orderCtr FROM `user_order_token` uot WHERE uot.`status` = "Completed" GROUP BY uot.`user_id`
Parameters:
[] |
| 3 | 0.32 ms |
SELECT COUNT(u.`id`) AS userCount FROM `user` u WHERE u.`status` = 'Active' AND u.`type` = 'Member'
Parameters:
[] |
| 4 | 0.26 ms |
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. |