Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.59 ms Query time

0 Invalid entities

#▲	Time	Info
1	1.20 ms	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;
2	0.39 ms	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

Info

1.20 ms

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.39 ms

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.