Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

9.73 ms Query time

0 Invalid entities

Time▼	Count	Info
6.04 ms (62.06%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"greenfield_stage"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'greenfield_stage' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
2.12 ms (21.81%)	1	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
1.57 ms (16.13%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated AS updated_4 FROM setting t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated AS updated_4 FROM setting t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated AS updated_4 FROM setting t0;

Time▼

Count

Info

6.04 ms
(62.06%)

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "greenfield_stage"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'greenfield_stage'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

2.12 ms
(21.81%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

1.57 ms
(16.13%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated AS updated_4 FROM setting t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.updated AS updated_4
FROM
  setting t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.updated AS updated_4 FROM setting t0;

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