POST https://www.smartimmo-app.com/home/api/request/filter/communes

Query Metrics

2 Database Queries
2 Different statements
2.96 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.69 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.modified_at AS modified_at_4, t0.country_code AS country_code_5, t0.iso_code AS iso_code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.country_id AS country_id_9 FROM province t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Kinshasa"
]
2 1.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.province_id AS province_id_3 FROM commune t0 WHERE t0.province_id = ?
Parameters:
[
  1
]

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\Province No errors.
App\Entity\Country No errors.
App\Entity\Property No errors.
App\Entity\Commune No errors.
App\Entity\Preference
  • The association App\Entity\Preference#leadClaims refers to the owning side field App\Entity\LeadClaims#leadId which does not exist.
App\Entity\User
  • The association App\Entity\User#messengers refers to the owning side field App\Entity\Messenger#receiver which does not exist.
  • The association App\Entity\User#messengersSender refers to the owning side field App\Entity\Messenger#sender which does not exist.
App\Entity\AgentCoverages No errors.