Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
12.81 ms
(58.23%)
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:
[
  196
  118
  102
  197
  198
  103
  199
  200
  201
  249
  124
  121
  104
  202
  155
  113
  203
  100
  204
  82
]
8.96 ms
(40.71%)
1
SELECT DISTINCT g0_.id AS id_0 FROM gnreview_address g0_ LIMIT 20 OFFSET 280
Parameters:
[]
0.23 ms
(1.06%)
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.