Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

0.72 ms Query time

0 Invalid entities

Time▼	Count	Info
0.52 ms (72.36%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.store_area_id AS store_area_id_4 FROM product t0 WHERE t0.id = ? Parameters: [`"18"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.store_area_id AS store_area_id_4 FROM product t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.store_area_id AS store_area_id_4 FROM product t0 WHERE t0.id = '18';
0.10 ms (14.65%)	1	SELECT t0.id AS id_1, t0.name AS name_2 FROM store_area t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM store_area t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM store_area t0 WHERE t0.id = 3;
0.09 ms (12.99%)	1	SELECT s0_.id AS id_0, s0_.name AS name_1 FROM store_area s0_ Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1 FROM store_area s0_ SELECT s0_.id AS id_0, s0_.name AS name_1 FROM store_area s0_;

Time▼

Count

Info

0.52 ms
(72.36%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.store_area_id AS store_area_id_4 FROM product t0 WHERE t0.id = ?

Parameters:

[
  "18"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.store_area_id AS store_area_id_4
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.store_area_id AS store_area_id_4 FROM product t0 WHERE t0.id = '18';

0.10 ms
(14.65%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM store_area t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  store_area t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM store_area t0 WHERE t0.id = 3;

0.09 ms
(12.99%)

SELECT s0_.id AS id_0, s0_.name AS name_1 FROM store_area s0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1
FROM
  store_area s0_

SELECT s0_.id AS id_0, s0_.name AS name_1 FROM store_area s0_;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.