Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

14.40 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.68 ms
(81.10%)

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.amount AS amount_3, t0.commission AS commission_4, t0.tube AS tube_5, t0.dealer AS dealer_6, t0.context AS context_7, t0.timestamp AS timestamp_8, t0.article_id AS article_id_9, t0.user_id AS user_id_10 FROM cart t0 WHERE t0.session_id = ?

Parameters:

[
  "sio9ku645no1paf5e0at5dbbr3"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.amount AS amount_3,
  t0.commission AS commission_4,
  t0.tube AS tube_5,
  t0.dealer AS dealer_6,
  t0.context AS context_7,
  t0.timestamp AS timestamp_8,
  t0.article_id AS article_id_9,
  t0.user_id AS user_id_10
FROM
  cart t0
WHERE
  t0.session_id = ?

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.amount AS amount_3, t0.commission AS commission_4, t0.tube AS tube_5, t0.dealer AS dealer_6, t0.context AS context_7, t0.timestamp AS timestamp_8, t0.article_id AS article_id_9, t0.user_id AS user_id_10 FROM cart t0 WHERE t0.session_id = 'sio9ku645no1paf5e0at5dbbr3';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	App\Service\CartStorage->getOrCreateCart (line 73)
4	App\Controller\AppShowController->appShowRimtapes (line 447)
5	HBG\Controller\ShowController->showRimtapes (line 119)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 3)

1.13 ms
(7.84%)

SELECT DISTINCT d0_.id AS id_0, d1_.cl_delivery_status AS cl_delivery_status_1, d0_.size AS size_2, t2_.name AS name_3, d0_.tread_longtext AS tread_longtext_4 FROM data_tires_master d0_ INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id LEFT JOIN cart c3_ ON d0_.id = c3_.article_id INNER JOIN tire_manufacturer t2_ ON d0_.manufacturer_id = t2_.id WHERE d1_.cl_state <> 'X' AND d1_.cl_active_flag_consumer = 1 AND d0_.product_group_id IN (31) ORDER BY d1_.cl_delivery_status ASC, d0_.size ASC, t2_.name ASC, d0_.tread_longtext ASC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT d0_.id AS id_0,
  d1_.cl_delivery_status AS cl_delivery_status_1,
  d0_.size AS size_2,
  t2_.name AS name_3,
  d0_.tread_longtext AS tread_longtext_4
FROM
  data_tires_master d0_
  INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id
  LEFT JOIN cart c3_ ON d0_.id = c3_.article_id
  INNER JOIN tire_manufacturer t2_ ON d0_.manufacturer_id = t2_.id
WHERE
  d1_.cl_state <> 'X'
  AND d1_.cl_active_flag_consumer = 1
  AND d0_.product_group_id IN (31)
ORDER BY
  d1_.cl_delivery_status ASC,
  d0_.size ASC,
  t2_.name ASC,
  d0_.tread_longtext ASC
LIMIT
  20

SELECT DISTINCT d0_.id AS id_0, d1_.cl_delivery_status AS cl_delivery_status_1, d0_.size AS size_2, t2_.name AS name_3, d0_.tread_longtext AS tread_longtext_4 FROM data_tires_master d0_ INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id LEFT JOIN cart c3_ ON d0_.id = c3_.article_id INNER JOIN tire_manufacturer t2_ ON d0_.manufacturer_id = t2_.id WHERE d1_.cl_state <> 'X' AND d1_.cl_active_flag_consumer = 1 AND d0_.product_group_id IN (31) ORDER BY d1_.cl_delivery_status ASC, d0_.size ASC, t2_.name ASC, d0_.tread_longtext ASC LIMIT 20;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 153)
7	App\Pagination\Paginator->paginate (line 70)
8	HBG\Repository\DataTiresMasterRepository->findPaginatorCommon (line 552)
9	App\Service\Searches->getPaginatorCommon (line 166)
10	App\Controller\AppShowController->appShowRimtapes (line 437)
11	HBG\Controller\ShowController->showRimtapes (line 119)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 3)

0.81 ms
(5.64%)

SELECT p0_.id AS id_0, p0_.key_app AS key_app_1, p0_.name AS name_2, p0_.active_flag AS active_flag_3 FROM product_groups p0_ WHERE p0_.key_app LIKE ?

Parameters:

[
  "%rimtapes%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.key_app AS key_app_1,
  p0_.name AS name_2,
  p0_.active_flag AS active_flag_3
FROM
  product_groups p0_
WHERE
  p0_.key_app LIKE ?

SELECT p0_.id AS id_0, p0_.key_app AS key_app_1, p0_.name AS name_2, p0_.active_flag AS active_flag_3 FROM product_groups p0_ WHERE p0_.key_app LIKE '%rimtapes%';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	HBG\Repository\ProductGroupsRepository->findByKey (line 167)
7	App\Service\Searches->getProductGroupIds (line 43)
8	App\Service\Searches->getPaginatorCommon (line 106)
9	App\Controller\AppShowController->appShowRimtapes (line 437)
10	HBG\Controller\ShowController->showRimtapes (line 119)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 197)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 29)
16	require_once (line 3)

0.78 ms
(5.42%)

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM data_tires_master d0_ INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id LEFT JOIN cart c2_ ON d0_.id = c2_.article_id INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id WHERE d1_.cl_state <> 'X' AND d1_.cl_active_flag_consumer = 1 AND d0_.product_group_id IN (31)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  data_tires_master d0_
  INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id
  LEFT JOIN cart c2_ ON d0_.id = c2_.article_id
  INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id
WHERE
  d1_.cl_state <> 'X'
  AND d1_.cl_active_flag_consumer = 1
  AND d0_.product_group_id IN (31)

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM data_tires_master d0_ INNER JOIN data_tires_client d1_ ON d0_.data_tires_client_id = d1_.id LEFT JOIN cart c2_ ON d0_.id = c2_.article_id INNER JOIN tire_manufacturer t3_ ON d0_.manufacturer_id = t3_.id WHERE d1_.cl_state <> 'X' AND d1_.cl_active_flag_consumer = 1 AND d0_.product_group_id IN (31);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 120)
7	App\Pagination\Paginator->paginate (line 71)
8	HBG\Repository\DataTiresMasterRepository->findPaginatorCommon (line 552)
9	App\Service\Searches->getPaginatorCommon (line 166)
10	App\Controller\AppShowController->appShowRimtapes (line 437)
11	HBG\Controller\ShowController->showRimtapes (line 119)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 197)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 3)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
HBG\Entity\ProductGroups	1

Entities Mapping

Class	Mapping errors
HBG\Entity\ShippingPaymentMatrix	No errors.
HBG\Entity\Cart	No errors.
HBG\Entity\TireManufacturer	No errors.
HBG\Entity\TireManufacturerTmp	No errors.
HBG\Entity\McManufacturer	No errors.
HBG\Entity\McManufacturerTmp	No errors.
HBG\Entity\McTypes	No errors.
HBG\Entity\McTypesTmp	No errors.
HBG\Entity\Pointer	No errors.
HBG\Entity\PointerTmp	No errors.
HBG\Entity\Footnotes	No errors.
HBG\Entity\FootnotesTmp	No errors.
HBG\Entity\DataTiresMaster	No errors.
HBG\Entity\DataTiresMasterTmp	No errors.
HBG\Entity\DataTiresClient	No errors.
HBG\Entity\ProductGroups	No errors.
HBG\Entity\ProductGroupsTmp	No errors.
HBG\Entity\DiscountLevel	No errors.
HBG\Entity\DiscountsUser	No errors.
HBG\Entity\User	No errors.

Symfony Profiler

GET https://consumer.motorradreifen.shop/zeige/felgenbaender

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping