Query Metrics
5
Database Queries
4
Different statements
8.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.36 ms (29.22%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
2.09 ms (25.83%) |
1 |
SELECT DISTINCT d0_.id AS id_0, d0_.city_id AS sclr_1 FROM departement d0_ LEFT JOIN city c1_ ON d0_.city_id = c1_.id ORDER BY d0_.city_id DESC LIMIT 20 OFFSET 1320
Parameters:
[] |
|
1.82 ms (22.53%) |
1 |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d0_.city_id AS city_id_3 FROM departement d0_ LEFT JOIN city c1_ ON d0_.city_id = c1_.id WHERE d0_.id IN (?) ORDER BY d0_.city_id DESC
Parameters:
[
[
368
367
366
5
4
45
44
43
42
41
40
39
38
37
36
35
34
33
32
31
]
]
|
|
1.81 ms (22.42%) |
1 |
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM departement d0_ LEFT JOIN city c1_ ON d0_.city_id = c1_.id
Parameters:
[] |
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\Flexy\ShopBundle\Entity\Shipping\Departement | No errors. |
| App\Flexy\ShopBundle\Entity\Shipping\City | No errors. |
| App\Flexy\ShopBundle\Entity\Customer\CustomerAddress | No errors. |
| App\Flexy\ShopBundle\Entity\Shipping\CityRegion | No errors. |