Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.29 ms Query time

0 Invalid entities

Time▼	Count	Info
0.88 ms (68.33%)	1	SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' Parameters: [] View formatted query View runnable query Explain query SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';
0.41 ms (31.67%)	1	SELECT DISTINCT p0_.id AS id_0 FROM posts p0_ WHERE p0_.status IN (0) ORDER BY p0_.publish_date DESC Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT p0_.id AS id_0 FROM posts p0_ WHERE p0_.status IN (0) ORDER BY p0_.publish_date DESC SELECT DISTINCT p0_.id AS id_0 FROM posts p0_ WHERE p0_.status IN (0) ORDER BY p0_.publish_date DESC;

Time▼

Count

Info

0.88 ms
(68.33%)

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'

Parameters:

[]

View formatted query View runnable query Explain query

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

0.41 ms
(31.67%)

SELECT DISTINCT p0_.id AS id_0 FROM posts p0_ WHERE p0_.status IN (0) ORDER BY p0_.publish_date DESC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT p0_.id AS id_0
FROM
  posts p0_
WHERE
  p0_.status IN (0)
ORDER BY
  p0_.publish_date DESC

SELECT DISTINCT p0_.id AS id_0 FROM posts p0_ WHERE p0_.status IN (0) ORDER BY p0_.publish_date DESC;

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\Entity\Post	No errors.