http://beta.shopingy.com/

Method
GET
HTTP Status
200
IP
172.22.0.3
Profiled on
Token
b92967

Query Metrics

3 Database Queries
3 Different statements
661.37 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
646.11 ms
(97.69%) 		1 
SELECT COUNT(DISTINCT s0_.shop_id) AS sclr_0 FROM shops s0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
8.96 ms
(1.36%) 		1 
SELECT COUNT(DISTINCT b0_.brand_id) AS sclr_0 FROM brands b0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
6.30 ms
(0.95%) 		1 
SELECT COUNT(DISTINCT s0_.shoppingmall_id) AS sclr_0 FROM shoppingmalls s0_
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

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.