Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

511.29 ms Query time

1 Invalid entities

#▲	Time	Info
1	2.56 ms	SELECT COUNT(DISTINCT b0_.brand_id) AS sclr_0 FROM brands b0_ Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT b0_.brand_id) AS sclr_0 FROM brands b0_ SELECT COUNT(DISTINCT b0_.brand_id) AS sclr_0 FROM brands b0_;
2	502.44 ms	SELECT COUNT(DISTINCT s0_.shop_id) AS sclr_0 FROM shops s0_ Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.shop_id) AS sclr_0 FROM shops s0_ SELECT COUNT(DISTINCT s0_.shop_id) AS sclr_0 FROM shops s0_;
3	6.28 ms	SELECT COUNT(DISTINCT s0_.shoppingmall_id) AS sclr_0 FROM shoppingmalls s0_ Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT s0_.shoppingmall_id) AS sclr_0 FROM shoppingmalls s0_ SELECT COUNT(DISTINCT s0_.shoppingmall_id) AS sclr_0 FROM shoppingmalls s0_;

#▲

Time

Info

2.56 ms

SELECT COUNT(DISTINCT b0_.brand_id) AS sclr_0 FROM brands b0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  COUNT(DISTINCT b0_.brand_id) AS sclr_0
FROM
  brands b0_

SELECT COUNT(DISTINCT b0_.brand_id) AS sclr_0 FROM brands b0_;

502.44 ms

SELECT COUNT(DISTINCT s0_.shop_id) AS sclr_0 FROM shops s0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  COUNT(DISTINCT s0_.shop_id) AS sclr_0
FROM
  shops s0_

SELECT COUNT(DISTINCT s0_.shop_id) AS sclr_0 FROM shops s0_;

6.28 ms

SELECT COUNT(DISTINCT s0_.shoppingmall_id) AS sclr_0 FROM shoppingmalls s0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  COUNT(DISTINCT s0_.shoppingmall_id) AS sclr_0
FROM
  shoppingmalls s0_

SELECT COUNT(DISTINCT s0_.shoppingmall_id) AS sclr_0 FROM shoppingmalls s0_;

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\Brand	No errors.
App\Entity\Shop	No errors.
App\Entity\Shoppingmall	The field App\Entity\Shoppingmall#shops is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Shop#shoppingMall does not contain the required 'inversedBy="shops"' attribute.