Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

3 Different statements

23.50 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
18.90 ms (80.43%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
3.48 ms (14.82%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.image AS image_4, t0.ordre AS ordre_5, t0.color AS color_6, t0.description AS description_7 FROM country t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.image AS image_4, t0.ordre AS ordre_5, t0.color AS color_6, t0.description AS description_7 FROM country t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.image AS image_4, t0.ordre AS ordre_5, t0.color AS color_6, t0.description AS description_7 FROM country t0;
1.12 ms (4.75%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"bookoachroot_db1_24"`] 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 = 'bookoachroot_db1_24' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;

Time▼

Count

Info

18.90 ms
(80.43%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

3.48 ms
(14.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.image AS image_4, t0.ordre AS ordre_5, t0.color AS color_6, t0.description AS description_7 FROM country t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.published AS published_3,
  t0.image AS image_4,
  t0.ordre AS ordre_5,
  t0.color AS color_6,
  t0.description AS description_7
FROM
  country t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.published AS published_3, t0.image AS image_4, t0.ordre AS ordre_5, t0.color AS color_6, t0.description AS description_7 FROM country t0;

1.12 ms
(4.75%)

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

Parameters:

[
  "bookoachroot_db1_24"
]

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

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\Country	No errors.
App\Entity\Destination	No errors.
App\Entity\Experience	The mappings App\Entity\Experience#programs and App\Entity\Program#experience are inconsistent with each other.

Symfony Profiler

http://www.bookoach.com/en/admin/country/add-destination

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping