Query Metrics
3
Database Queries
3
Different statements
1.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.71 ms (51.57%) |
1 |
SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.is_admin = 0 AND u0_.is_parent = 0 AND u0_.is_profile_completed = 1 AND u0_.is_verified = 1 AND u0_.banned_at IS NULL AND u0_.delete_at IS NULL AND u0_.confirmation_token IS NULL
Parameters:
[] |
|
0.34 ms (25.17%) |
1 |
SELECT MIN(u0_.hour_rate) AS sclr_0, MAX(u0_.hour_rate) AS sclr_1 FROM user u0_ WHERE u0_.is_admin = 0 AND u0_.is_parent = 0 AND u0_.is_profile_completed = 1 AND u0_.is_verified = 1 AND u0_.banned_at IS NULL AND u0_.delete_at IS NULL AND u0_.confirmation_token IS NULL ORDER BY u0_.created_at DESC
Parameters:
[] |
|
0.32 ms (23.26%) |
1 |
SELECT DISTINCT u0_.id AS id_0, u0_.created_at AS created_at_1 FROM user u0_ WHERE u0_.is_admin = 0 AND u0_.is_parent = 0 AND u0_.is_profile_completed = 1 AND u0_.is_verified = 1 AND u0_.banned_at IS NULL AND u0_.delete_at IS NULL AND u0_.confirmation_token IS NULL ORDER BY u0_.created_at DESC LIMIT 6
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\Activities\Feedback | No errors. |
| App\Entity\Auth\User | No errors. |
| App\Entity\Activities\Booking | No errors. |