Query Metrics
8
Database Queries
8
Different statements
6.90 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.73 ms (54.09%) |
1 |
"ROLLBACK"
Parameters:
[] |
0.79 ms (11.42%) |
1 |
DELETE FROM client WHERE id = ?
Parameters:
[
5320
]
|
0.52 ms (7.59%) |
1 |
SELECT t0.id AS id_1, t0.number AS number_2, t0.link AS link_3, t0.sms AS sms_4, t0.email AS email_5, t0.client_id AS client_id_6 FROM client_contact t0 WHERE t0.client_id = ?
Parameters:
[
5320
]
|
0.47 ms (6.75%) |
1 |
SELECT t0.fullname AS fullname_1, t0.telfixe AS telfixe_2, t0.telmobile AS telmobile_3, t0.email AS email_4, t0.deleted AS deleted_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM client t0 WHERE t0.id = ?
Parameters:
[
"5320"
]
|
0.45 ms (6.49%) |
1 |
SELECT t0.keysettings AS keysettings_1, t0.valuesettings AS valuesettings_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM setting t0
Parameters:
[] |
0.42 ms (6.16%) |
1 |
DELETE FROM client_contact WHERE id = ?
Parameters:
[
6352
]
|
0.29 ms (4.17%) |
1 |
DELETE FROM user_client WHERE client_id = ?
Parameters:
[
5320
]
|
0.23 ms (3.33%) |
1 |
"START TRANSACTION"
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\Setting | No errors. |
App\Entity\Client | No errors. |
App\Entity\Chantier | No errors. |
App\Entity\ClientContact | No errors. |
App\Entity\ClientMessage | No errors. |
App\Entity\User | No errors. |