Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.41 ms Query time

0 Invalid entities

Time▼	Count	Info
1.04 ms (73.91%)	1	SELECT a0_.id AS id_0, a0_.AreaName AS AreaName_1 FROM AreaTable a0_ WHERE a0_.deleted = 0 Parameters: [] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.AreaName AS AreaName_1 FROM AreaTable a0_ WHERE a0_.deleted = 0 SELECT a0_.id AS id_0, a0_.AreaName AS AreaName_1 FROM AreaTable a0_ WHERE a0_.deleted = 0;
0.37 ms (26.09%)	1	SELECT s0_.id AS id_0, s0_.AreaId AS AreaId_1, s0_.StoreName AS StoreName_2 FROM StoreTable s0_ WHERE s0_.deleted = 0 Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.AreaId AS AreaId_1, s0_.StoreName AS StoreName_2 FROM StoreTable s0_ WHERE s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.AreaId AS AreaId_1, s0_.StoreName AS StoreName_2 FROM StoreTable s0_ WHERE s0_.deleted = 0;

Time▼

Count

Info

1.04 ms
(73.91%)

SELECT a0_.id AS id_0, a0_.AreaName AS AreaName_1 FROM AreaTable a0_ WHERE a0_.deleted = 0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT 
  a0_.id AS id_0, 
  a0_.AreaName AS AreaName_1 
FROM 
  AreaTable a0_ 
WHERE 
  a0_.deleted = 0

SELECT a0_.id AS id_0, a0_.AreaName AS AreaName_1 FROM AreaTable a0_ WHERE a0_.deleted = 0;

0.37 ms
(26.09%)

SELECT s0_.id AS id_0, s0_.AreaId AS AreaId_1, s0_.StoreName AS StoreName_2 FROM StoreTable s0_ WHERE s0_.deleted = 0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT 
  s0_.id AS id_0, 
  s0_.AreaId AS AreaId_1, 
  s0_.StoreName AS StoreName_2 
FROM 
  StoreTable s0_ 
WHERE 
  s0_.deleted = 0

SELECT s0_.id AS id_0, s0_.AreaId AS AreaId_1, s0_.StoreName AS StoreName_2 FROM StoreTable s0_ WHERE s0_.deleted = 0;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
AppBundle\Entity\Areatable	No errors.
AppBundle\Entity\Storetable	No errors.