Query Metrics

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

Queries

Group similar statements

# Time Info
1 36.09 ms
SELECT DISTINCT g0_.id AS id_0 FROM gnreview_address g0_ LIMIT 20 OFFSET 80
Parameters:
[]
2 35.79 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:
[
  160
  315
  337
  335
  333
  191
  344
  345
  260
  311
  312
  313
  314
  308
  309
  310
  128
  267
  364
  359
]
3 0.46 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.