Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

3.53 ms Query time

0 Invalid entities

Time▼	Count	Info
2.50 ms (70.79%)	1	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"relaxm_17"`] 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 = 'relaxm_17' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
1.03 ms (29.21%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Time▼

Count

Info

2.50 ms
(70.79%)

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

Parameters:

[
  "relaxm_17"
]

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

1.03 ms
(29.21%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

Name	Service
default	doctrine.dbal.default_connection
ms5	doctrine.dbal.ms5_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\StockHistory	No errors.
App\Entity\Variant	No errors.
App\Entity\Product	No errors.
App\Entity\User	No errors.
App\Entity\OrderImport	No errors.
App\Entity\Parameter	No errors.
App\Entity\OrderAddress	No errors.
App\Entity\ProductImage	No errors.
App\Entity\Order	No errors.
App\Entity\Supplier	No errors.
App\Entity\AlzaTrade	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Stock	No errors.
App\Entity\AlzaPrice	No errors.
App\Entity\ImportLog	No errors.
App\Entity\OrderStatus	No errors.
App\Entity\OrderItem	No errors.
App\Entity\Test\Test	No errors.
App\Entity\Test\TestTranslation	No errors.
App\Entity\AlzaTradeLog	No errors.
Dukecity\CommandSchedulerBundle\Entity\ScheduledCommand	No errors.
Lexik\Bundle\TranslationBundle\Model\Translation	No errors.
Lexik\Bundle\TranslationBundle\Entity\Translation	No errors.
Lexik\Bundle\TranslationBundle\Model\File	No errors.
Lexik\Bundle\TranslationBundle\Entity\File	No errors.
Lexik\Bundle\TranslationBundle\Model\TransUnit	No errors.
Lexik\Bundle\TranslationBundle\Entity\TransUnit	No errors.
Vich\UploaderBundle\Entity\File	No errors.