Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

511.29 ms Query time

1 Invalid entities

Time▼	Count	Info
502.44 ms (98.27%)	1	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 (1.23%)	1	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_;
2.56 ms (0.50%)	1	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_;

Time▼

Count

Info

502.44 ms
(98.27%)

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
(1.23%)

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_;

2.56 ms
(0.50%)

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_;

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.