Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
47.92 ms
(76.56%)
1
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:
[
  171
  91
  130
  90
  172
  39
  38
  41
  51
  64
  134
  54
  47
  13
  36
  11
  40
  52
  55
  48
]
14.39 ms
(23.00%)
1
SELECT DISTINCT g0_.id AS id_0 FROM gnreview_address g0_ LIMIT 20 OFFSET 440
Parameters:
[]
0.28 ms
(0.44%)
1
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.