Query Metrics
5
Database Queries
4
Different statements
8.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.09 ms |
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:
[] |
| 2 | 1.82 ms |
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
]
]
|
| 3 | 1.81 ms |
SELECT count(DISTINCT d0_.id) AS sclr_0 FROM departement d0_ LEFT JOIN city c1_ ON d0_.city_id = c1_.id
Parameters:
[] |
| 4 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 5 | 1.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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. |