Query Metrics

3 Database Queries
3 Different statements
13.37 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT DISTINCT g0_.id AS id_0 FROM gnreview_address g0_ LIMIT 20
Parameters:
[]
2 12.73 ms
SELECT g0_.id AS id_0, g0_.description AS description_1, g0_.is_sealed AS is_sealed_2, g0_.created_at AS created_at_3, g0_.updated_at AS updated_at_4, g0_.is_twisted AS is_twisted_5, g0_.is_welded AS is_welded_6, g0_.is_pressed AS is_pressed_7, g0_.is_copper AS is_copper_8, g0_.verticals_cnt AS verticals_cnt_9, g0_.is_gas_meter_outside AS is_gas_meter_outside_10, g0_.is_gas_meter_in_basement AS is_gas_meter_in_basement_11, g0_.is_gas_meter_in_staircase AS is_gas_meter_in_staircase_12, g0_.is_gas_meter_in_local AS is_gas_meter_in_local_13, g0_.is_gas_cabinet_missing AS is_gas_cabinet_missing_14, g0_.is_gas_cabinet_painted AS is_gas_cabinet_painted_15, g0_.is_gas_cabinet_destroyed AS is_gas_cabinet_destroyed_16, g0_.is_gas_cabinet_ok AS is_gas_cabinet_ok_17, g0_.issued_at AS issued_at_18, g0_.installation_status_id AS installation_status_id_19, g0_.gnaddress_id AS gnaddress_id_20, g0_.gas_cabinet_status_id AS gas_cabinet_status_id_21 FROM gnreview_address g0_ WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  349
  355
  346
  125
  385
  183
  182
  287
  151
  288
  290
  291
  289
  152
  293
  325
  188
  328
  329
  258
]
3 0.29 ms
SELECT count(g0_.id) AS sclr_0 FROM gnreview_address g0_
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\GNReviewAddress
  • The association App\Entity\GNReviewAddress#GNAddress refers to the inverse side field App\Entity\GNaddress#gNReviews which does not exist.
App\Entity\GNInstallationStatus No errors.
App\Entity\GNaddress
  • The mappings App\Entity\GNaddress#gNReviewsAddress and App\Entity\GNReviewAddress#GNAddress are inconsistent with each other.
App\Entity\GNGasCabinetStatus
  • The association App\Entity\GNGasCabinetStatus#gNReviews refers to the owning side field App\Entity\GNReview#gasCabinetStatus which does not exist.