Query Metrics

5 Database Queries
4 Different statements
8.09 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.