Query Metrics
2
Database Queries
2
Different statements
43.90 ms
Query time
4
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
42.14 ms (95.99%) |
1 |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.activity AS activity_2, w0_.contact AS contact_3, w0_.status AS status_4, w0_.location AS location_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7, w0_.city AS city_8, w0_.country AS country_9, (CASE WHEN w0_.updated_at IS NULL THEN w0_.created_at ELSE w0_.updated_at END) AS sclr_10 FROM workshop w0_ ORDER BY sclr_10 DESC, w0_.created_at DESC
Parameters:
[] |
|
1.76 ms (4.01%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.is_verified AS is_verified_8, t0.is_active AS is_active_9, t0.phone_number AS phone_number_10, t0.dialing_code AS dialing_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.siret AS siret_16, t0.company_name AS company_name_17, t0.addresses AS addresses_18, t0.avatar_path AS avatar_path_19, t0.type FROM jb_user t0 WHERE t0.email = ? AND t0.type IN ('user', 'customer', 'repairer', 'manager', 'fleet') LIMIT 1
Parameters:
[
"jb@manager.local"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Repairer | No errors. |
| App\Entity\Manager | No errors. |
| App\Entity\Fleet |
|
| App\Entity\ResetPassword | No errors. |
| App\Entity\Appointment |
|
| App\Entity\FleetCompany |
|
| App\Entity\Workshop |
|