Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.80 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.33 ms	SET SESSION time_zone = '+00:00' Parameters: [] View formatted query View runnable query Explain query SET SESSION time_zone = '+00:00' SET SESSION time_zone = '+00:00';
2	0.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_sale_type t0 WHERE t0.name = ? AND t0.discriminator_type IN ('saletype') LIMIT 1 Parameters: [`"すべての商品"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_sale_type t0 WHERE t0.name = ? AND t0.discriminator_type IN ('saletype') LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_sale_type t0 WHERE t0.name = 'すべての商品' AND t0.discriminator_type IN ('saletype') LIMIT 1;

#▲

Time

Info

0.33 ms

SET SESSION time_zone = '+00:00'

Parameters:

[]

View formatted query View runnable query Explain query

SET 
  SESSION time_zone = '+00:00'

SET SESSION time_zone = '+00:00';

0.47 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_sale_type t0 WHERE t0.name = ? AND t0.discriminator_type IN ('saletype') LIMIT 1

Parameters:

[
  "すべての商品"
]

View formatted query View runnable query Explain query

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.sort_no AS sort_no_3, 
  t0.discriminator_type 
FROM 
  mtb_sale_type t0 
WHERE 
  t0.name = ? 
  AND t0.discriminator_type IN ('saletype') 
LIMIT 
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_sale_type t0 WHERE t0.name = 'すべての商品' AND t0.discriminator_type IN ('saletype') LIMIT 1;

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
Plugin\ProductDisplayRank4\Entity\Config	No errors.
Eccube\Entity\Product	No errors.
Eccube\Entity\Master\SaleType	No errors.
Eccube\Entity\BaseInfo	No errors.
Eccube\Entity\Page	No errors.
Eccube\Entity\PageLayout	No errors.
Eccube\Entity\Block	No errors.
Eccube\Entity\BlockPosition	No errors.
Eccube\Entity\Master\DeviceType	No errors.
Eccube\Entity\AuthorityRole	No errors.
Eccube\Entity\Layout	No errors.
Eccube\Entity\Order	No errors.
Eccube\Entity\Customer	No errors.
Eccube\Entity\Member	No errors.
Eccube\Entity\Plugin	No errors.