POST https://gestinter.a2dfinformatique.com/interventions/list

Query Metrics

31 Database Queries
10 Different statements
14.18 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

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
  • The mappings App\Entity\RendezVous#rendezVousContacts and App\Entity\RendezVousContact#rendezVous are inconsistent with each other.
App\Entity\Intervention
  • The association App\Entity\Intervention#user refers to the inverse side field App\Entity\User#interventions which does not exist.
  • The association App\Entity\Intervention#zone refers to the inverse side field App\Entity\Zone#interventions which does not exist.
  • The association App\Entity\Intervention#forfait refers to the inverse side field App\Entity\Forfait#interventions which does not exist.
App\Entity\Zone No errors.
App\Entity\Forfait No errors.
App\Entity\InterventionMaterial
  • The association App\Entity\InterventionMaterial#material refers to the inverse side field App\Entity\Material#intervention which does not exist.
App\Entity\SmsOutbox
  • The association App\Entity\SmsOutbox#customer refers to the inverse side field App\Entity\Customer#smsOutbox which does not exist.
  • The association App\Entity\SmsOutbox#user refers to the inverse side field App\Entity\User#smsOutbox which does not exist.
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
  • The mappings App\Entity\Material#interventions and App\Entity\InterventionMaterial#material are inconsistent with each other.