Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

3 Different statements

9.18 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
5.48 ms (59.69%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"testSymfony"`] 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 = 'testSymfony' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
2.54 ms (27.72%)	1	SELECT t0.id AS id_1, t0.startNumber AS startNumber_2, t0.finalNumber AS finalNumber_3, t0.dateHour AS dateHour_4, t0.fizzBuzzText AS fizzBuzzText_5 FROM FizzBuzz t0 WHERE t0.id = ? Parameters: [`"robots.txt"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.startNumber AS startNumber_2, t0.finalNumber AS finalNumber_3, t0.dateHour AS dateHour_4, t0.fizzBuzzText AS fizzBuzzText_5 FROM FizzBuzz t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.startNumber AS startNumber_2, t0.finalNumber AS finalNumber_3, t0.dateHour AS dateHour_4, t0.fizzBuzzText AS fizzBuzzText_5 FROM FizzBuzz t0 WHERE t0.id = 'robots.txt';
1.16 ms (12.59%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Time▼

Count

Info

5.48 ms
(59.69%)

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

Parameters:

[
  "testSymfony"
]

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 = 'testSymfony'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

2.54 ms
(27.72%)

SELECT t0.id AS id_1, t0.startNumber AS startNumber_2, t0.finalNumber AS finalNumber_3, t0.dateHour AS dateHour_4, t0.fizzBuzzText AS fizzBuzzText_5 FROM FizzBuzz t0 WHERE t0.id = ?

Parameters:

[
  "robots.txt"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.startNumber AS startNumber_2,
  t0.finalNumber AS finalNumber_3,
  t0.dateHour AS dateHour_4,
  t0.fizzBuzzText AS fizzBuzzText_5
FROM
  FizzBuzz t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.startNumber AS startNumber_2, t0.finalNumber AS finalNumber_3, t0.dateHour AS dateHour_4, t0.fizzBuzzText AS fizzBuzzText_5 FROM FizzBuzz t0 WHERE t0.id = 'robots.txt';

1.16 ms
(12.59%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Fizzbuzz	No errors.

Symfony Profiler

https://test.robsul.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping