Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.75 ms Query time

0 Invalid entities

Time▼	Count	Info
0.79 ms (45.10%)	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.58 ms (33.13%)	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.38 ms (21.78%)	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.79 ms
(45.10%)

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.58 ms
(33.13%)

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.38 ms
(21.78%)

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.