GET https://prod-api.callme4d.com/v1/city/getcities

Query Metrics

1 Database Queries
1 Different statements
0.51 ms Query time
3 Invalid entities
33 Managed entities

Queries

Group similar statements

# Time Info
1 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.city_code AS city_code_5, t0.lat_lng_bounds AS lat_lng_bounds_6, t0.status AS status_7 FROM city_entity t0 WHERE t0.status = ?
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CityEntity 33

Entities Mapping

Class Mapping errors
App\Entity\CityEntity
  • The association App\Entity\CityEntity#captains refers to the owning side field App\Entity\CaptainEntity#cityEntity which does not exist.
  • The association App\Entity\CityEntity#stores refers to the owning side field App\Entity\StoreOwnerProfileEntity#cityEntity which does not exist.
App\Entity\CaptainEntity
  • The mappings App\Entity\CaptainEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#captainProfile are inconsistent with each other.
  • The association App\Entity\CaptainEntity#deletedBy refers to the inverse side field App\Entity\AdminProfileEntity#deletedCaptainsProfiles which does not exist.
  • The mappings App\Entity\CaptainEntity#cityId and App\Entity\CityEntity#captains are inconsistent with each other.
App\Entity\StoreOwnerProfileEntity
  • The mappings App\Entity\StoreOwnerProfileEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#storeOwnerProfile are inconsistent with each other.
App\Entity\AdminProfileEntity No errors.
App\Entity\OrderVisibilityCriteriaEntity No errors.