Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT DISTINCT g0_.id AS id_0 FROM gnreview_address g0_ LIMIT 20 OFFSET 220
Parameters:
[]
2 0.65 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:
[
  461
  393
  465
  441
  497
  437
  397
  396
  395
  463
  464
  428
  424
  429
  443
  398
  457
  422
  484
  483
]
3 0.18 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.