Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.64 ms Query time

1 Invalid entities

Time▼	Count	Info
1.31 ms (79.72%)	1	SELECT count(d0_.id) AS sclr_0 FROM device d0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(d0_.id) AS sclr_0 FROM device d0_ SELECT count(d0_.id) AS sclr_0 FROM device d0_;
0.33 ms (20.28%)	1	SELECT count(a0_.id) AS sclr_0 FROM alarm a0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(a0_.id) AS sclr_0 FROM alarm a0_ SELECT count(a0_.id) AS sclr_0 FROM alarm a0_;

Time▼

Count

Info

1.31 ms
(79.72%)

SELECT count(d0_.id) AS sclr_0 FROM device d0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(d0_.id) AS sclr_0
FROM
  device d0_

SELECT count(d0_.id) AS sclr_0 FROM device d0_;

0.33 ms
(20.28%)

SELECT count(a0_.id) AS sclr_0 FROM alarm a0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(a0_.id) AS sclr_0
FROM
  alarm a0_

SELECT count(a0_.id) AS sclr_0 FROM alarm a0_;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\Device	The mappings App\Entity\Device#deviceSettingBackup and App\Entity\DeviceSetting#device are inconsistent with each other.
App\Entity\Alarm	No errors.