Query Metrics
4
Database Queries
4
Different statements
1.35 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.56 ms (41.41%) |
1 |
SELECT SUM(uot.`token_amount`) AS stagePurchase FROM `user_order_token` uot WHERE uot.`status` = "Completed"
Parameters:
[] |
|
0.29 ms (21.82%) |
1 |
SELECT COUNT(u.`id`) AS userCount FROM `user` u WHERE u.`status` = 'Active' AND u.`type` = 'Member'
Parameters:
[] |
|
0.26 ms (19.08%) |
1 |
SELECT COUNT(uot.`id`) AS orderCtr FROM `user_order_token` uot WHERE uot.`status` = "Completed" GROUP BY uot.`user_id`
Parameters:
[] |
|
0.24 ms (17.69%) |
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. |