Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

5 Database Queries

3 Different statements

4.61 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
2.23 ms (48.30%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"domb_dom"`] 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 = 'domb_dom' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
1.44 ms (31.19%)	2	SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC Parameters: [`0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = 0 ORDER BY t0.id DESC;
0.95 ms (20.51%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Time▼

Count

Info

2.23 ms
(48.30%)

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

Parameters:

[
  "domb_dom"
]

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

1.44 ms
(31.19%)

SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = ? ORDER BY t0.id DESC

Parameters:

[
  0
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.user AS user_2,
  t0.prod AS prod_3,
  t0.var AS var_4,
  t0.num AS num_5,
  t0.tstamp AS tstamp_6
FROM
  wishlist t0
WHERE
  t0.user = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.user AS user_2, t0.prod AS prod_3, t0.var AS var_4, t0.num AS num_5, t0.tstamp AS tstamp_6 FROM wishlist t0 WHERE t0.user = 0 ORDER BY t0.id DESC;

0.95 ms
(20.51%)

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\User	No errors.
App\Entity\Discount	No errors.
App\Entity\Wishlist	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Entity\Translation\DiscountTranslation	No errors.

Symfony Profiler

https://test.dombusin.com/redirect

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping