Query Metrics
31
Database Queries
10
Different statements
14.18 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.91 ms (20.55%) |
7 |
SELECT t0.id AS id_1, t0.message AS message_2, t0.number AS number_3, t0.created_at AS created_at_4, t0.sended_at AS sended_at_5, t0.ovh_id AS ovh_id_6, t0.ovh_state AS ovh_state_7, t0.customer_id AS customer_id_8, t0.workshop_id AS workshop_id_9, t0.rendez_vous_id AS rendez_vous_id_10, t0.intervention_id AS intervention_id_11, t0.user_id AS user_id_12 FROM sms_outbox t0 WHERE t0.intervention_id = ?
Parameters:
[
761
]
|
2.88 ms (20.32%) |
7 |
SELECT t0.id AS id_1, t0.lastname AS lastname_2, t0.is_company AS is_company_3, t0.firstname AS firstname_4, t0.address AS address_5, t0.post_code AS post_code_6, t0.city AS city_7, t0.email AS email_8, t0.home_phone AS home_phone_9, t0.mobile_phone AS mobile_phone_10 FROM customers t0 WHERE t0.id = ?
Parameters:
[
491
]
|
2.68 ms (18.92%) |
7 |
SELECT t0.quantity AS quantity_1, t0.intervention_id AS intervention_id_2, t0.material_id AS material_id_3 FROM intervention_material t0 WHERE t0.intervention_id = ?
Parameters:
[
761
]
|
1.37 ms (9.68%) |
2 |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.username AS username_4, t0.password AS password_5, t0.email AS email_6, t0.phone AS phone_7, t0.enabled AS enabled_8, t0.visible AS visible_9, t0.roles AS roles_10, t0.last_login AS last_login_11, t0.last_reset_password AS last_reset_password_12, t0.customer_id AS customer_id_13 FROM users t0 WHERE t0.id = ?
Parameters:
[
3
]
|
1.00 ms (7.07%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.deleted AS deleted_4 FROM material t0 WHERE t0.id = ?
Parameters:
[
"AR01358"
]
|
0.99 ms (6.97%) |
1 |
SELECT i0_.id AS id_0, i0_.date AS date_1, i0_.duration AS duration_2, i0_.comment AS comment_3, i0_.maintenance AS maintenance_4, i0_.payment AS payment_5, i0_.payment_mode AS payment_mode_6, i0_.billing AS billing_7, i0_.done AS done_8, i0_.user_id AS user_id_9, i0_.customer_id AS customer_id_10, i0_.zone_id AS zone_id_11, i0_.forfait_id AS forfait_id_12 FROM intervention i0_ WHERE i0_.done = ? ORDER BY i0_.date DESC LIMIT 25
Parameters:
[
0
]
|
0.76 ms (5.35%) |
1 |
SELECT COUNT(i0_.id) AS sclr_0 FROM intervention i0_
Parameters:
[] |
0.74 ms (5.19%) |
1 |
SELECT COUNT(i0_.id) AS sclr_0 FROM intervention i0_ WHERE i0_.done = ?
Parameters:
[
0
]
|
0.44 ms (3.09%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM zone t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.41 ms (2.86%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.deleted AS deleted_4 FROM forfait t0 WHERE t0.id = ?
Parameters:
[
"AR01250"
]
|
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\User | No errors. |
App\Entity\Customer | No errors. |
App\Entity\RendezVous |
|
App\Entity\Intervention |
|
App\Entity\Zone | No errors. |
App\Entity\Forfait | No errors. |
App\Entity\InterventionMaterial |
|
App\Entity\SmsOutbox |
|
App\Entity\WorkShop | No errors. |
App\Entity\Call | No errors. |
App\Entity\CustomerComputer | No errors. |
App\Entity\CustomerContact | No errors. |
App\Entity\Ticket | No errors. |
App\Entity\Material |
|