Query Metrics

8 Database Queries
8 Different statements
9.11 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 2.06 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.email AS email_6, t0.code AS code_7, t0.phone AS phone_8, t0.sexe AS sexe_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.role_id AS role_id_13, t0.admin_id AS admin_id_14 FROM admin t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 1.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3 FROM roles t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 1.03 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.adress AS adress_4, t0.email AS email_5, t0.phone AS phone_6, t0.pseudo AS pseudo_7, t0.description AS description_8, t0.rccm AS rccm_9, t0.icon AS icon_10, t0.status AS status_11, t0.smsservice AS smsservice_12, t0.invoiceservice AS invoiceservice_13, t0.idnat AS idnat_14, t0.numeroimpot AS numeroimpot_15, t0.city AS city_16, t0.province AS province_17, t0.nbrebiensimmobiliers AS nbrebiensimmobiliers_18, t0.free_trail AS free_trail_19, t0.period AS period_20, t0.recallpaymentnotification AS recallpaymentnotification_21, t0.smart_paykey AS smart_paykey_22, t0.make_journal AS make_journal_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.admin_id AS admin_id_26, t0.country_id AS country_id_27, t0.package_id AS package_id_28, t0.owner_id AS owner_id_29 FROM entreprise t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "703b8a1f4d4fac508457b0418ef4c729"
]
4 1.00 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.status AS status_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.marchand_id AS marchand_id_8 FROM role t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
5 1.30 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.code AS code_6, t0.status AS status_7, t0.reset AS reset_8, t0.sexe AS sexe_9, t0.phone AS phone_10, t0.picture AS picture_11, t0.notif AS notif_12, t0.email AS email_13, t0.profil AS profil_14, t0.level AS level_15, t0.adress AS adress_16, t0.city AS city_17, t0.province AS province_18, t0.mode AS mode_19, t0.last_action AS last_action_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.role_id AS role_id_23, t0.entreprise_id AS entreprise_id_24, t0.created_by_id AS created_by_id_25, t0.country_id AS country_id_26 FROM User t0 WHERE t0.role_id = ? AND t0.entreprise_id = ? LIMIT 1
Parameters:
[
  1
  56
]
6 0.72 ms
"START TRANSACTION"
Parameters:
[]
7 1.08 ms
UPDATE User SET password = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "$2y$13$mp0EhHBg0kWf.VFbfQhhf.bZ8upZXfxH/gwQ3.WLxLmL7LpryT2lK"
  "2026-06-10 10:52:39"
  66
]
8 0.87 ms
"COMMIT"
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\Admin
  • The association App\Entity\Admin#role refers to the inverse side field App\Entity\Roles#admins which does not exist.
App\Entity\Roles
  • The mappings App\Entity\Roles#users and App\Entity\Admin#role are inconsistent with each other.
App\Entity\Entreprise
  • The association App\Entity\Entreprise#admin refers to the inverse side field App\Entity\Admin#entreprises which does not exist.
App\Entity\Country No errors.
App\Entity\Package No errors.
App\Entity\User No errors.
App\Entity\Role No errors.
App\Entity\CategoryResidence
  • The association App\Entity\CategoryResidence#createdBy refers to the inverse side field App\Entity\User#categoryResidences which does not exist.
App\Entity\ResidenceImmeuble No errors.
App\Entity\PaymentGenerator No errors.
App\Entity\Prestataire No errors.
App\Entity\Incident No errors.
App\Entity\Template No errors.
App\Entity\PaymentGaranty
  • The association App\Entity\PaymentGaranty#modePayment refers to the inverse side field App\Entity\PaymentMode#paymentGaranties which does not exist.
  • The association App\Entity\PaymentGaranty#createdBy refers to the inverse side field App\Entity\User#paymentGaranties which does not exist.
App\Entity\IncidentUpdate No errors.
App\Entity\Service No errors.
App\Entity\Subscription No errors.
App\Entity\Announcement No errors.
App\Entity\CashJournal No errors.
App\Entity\CashJournalEntry No errors.
App\Entity\Charge No errors.
App\Entity\ChargeAllocation No errors.
App\Entity\Log No errors.
App\Entity\Reservation
  • The association App\Entity\Reservation#habitat refers to the inverse side field App\Entity\Habitat#reservations which does not exist.
App\Entity\UserEntreprise No errors.
App\Entity\Privilege No errors.
App\Entity\Location
  • The association App\Entity\Location#marchand refers to the inverse side field App\Entity\Entreprise#locations which does not exist.