Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

2.07 ms Query time

0 Invalid entities

Time▼	Count	Info
0.90 ms (43.36%)	1	SELECT count(f0_.id) AS sclr_0 FROM family f0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(f0_.id) AS sclr_0 FROM family f0_ SELECT count(f0_.id) AS sclr_0 FROM family f0_;
0.68 ms (33.07%)	1	SELECT DISTINCT f0_.id AS id_0 FROM family f0_ LIMIT 20 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT f0_.id AS id_0 FROM family f0_ LIMIT 20 SELECT DISTINCT f0_.id AS id_0 FROM family f0_ LIMIT 20;
0.49 ms (23.56%)	1	SELECT f0_.name AS name_0, f0_.id AS id_1 FROM family f0_ WHERE f0_.id IN (?, ?) Parameters: [`b"\x1EßK<JÇcâŽ¸{ÌþÝÆ©" b"\x1EßKeLrb\x0E©Ê{ÌþÝÆ©"`] View formatted query View runnable query Explain query SELECT f0_.name AS name_0, f0_.id AS id_1 FROM family f0_ WHERE f0_.id IN (?, ?) SELECT f0_.name AS name_0, f0_.id AS id_1 FROM family f0_ WHERE f0_.id IN (0x1EDF4B3C4AC763E28EB87BCCFEDDC6A9, 0x1EDF4B654C72620EA9CA7BCCFEDDC6A9);

Time▼

Count

Info

0.90 ms
(43.36%)

SELECT count(f0_.id) AS sclr_0 FROM family f0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(f0_.id) AS sclr_0
FROM
  family f0_

SELECT count(f0_.id) AS sclr_0 FROM family f0_;

0.68 ms
(33.07%)

SELECT DISTINCT f0_.id AS id_0 FROM family f0_ LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT f0_.id AS id_0
FROM
  family f0_
LIMIT
  20

SELECT DISTINCT f0_.id AS id_0 FROM family f0_ LIMIT 20;

0.49 ms
(23.56%)

SELECT f0_.name AS name_0, f0_.id AS id_1 FROM family f0_ WHERE f0_.id IN (?, ?)

Parameters:

[
  b"\x1EßK<JÇcâŽ¸{ÌþÝÆ©"
  b"\x1EßKeLrb\x0E©Ê{ÌþÝÆ©"
]

View formatted query View runnable query Explain query

SELECT
  f0_.name AS name_0,
  f0_.id AS id_1
FROM
  family f0_
WHERE
  f0_.id IN (?, ?)

SELECT f0_.name AS name_0, f0_.id AS id_1 FROM family f0_ WHERE f0_.id IN (0x1EDF4B3C4AC763E28EB87BCCFEDDC6A9, 0x1EDF4B654C72620EA9CA7BCCFEDDC6A9);

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.