Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

4.37 ms Query time

0 Invalid entities

#▲	Time	Info
1	2.02 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.city_id AS city_id_4 FROM departement t0 WHERE t0.id = ? Parameters: [`"945"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.city_id AS city_id_4 FROM departement t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.city_id AS city_id_4 FROM departement t0 WHERE t0.id = '945';
2	1.40 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id = 9;
3	0.95 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2 FROM city c0_ Parameters: [] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2 FROM city c0_ SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2 FROM city c0_;

#▲

Time

Info

2.02 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.city_id AS city_id_4 FROM departement t0 WHERE t0.id = ?

Parameters:

[
  "945"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.city_id AS city_id_4
FROM
  departement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.city_id AS city_id_4 FROM departement t0 WHERE t0.id = '945';

1.40 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM city t0 WHERE t0.id = 9;

0.95 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2 FROM city c0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2
FROM
  city c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2 FROM city c0_;

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