Symfony Profiler

Query Metrics

69 Database Queries

61 Different statements

50.64 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

4.55 ms
(8.99%)

UPDATE `product` SET `prices` = IFNULL(
                        (
                            SELECT `product_price`.`product_id`
                            FROM   `product_price`
                            WHERE  `product_price`.`product_id`         = `product`.id
                            AND `product_price`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `prices` = IFNULL(
    (
      SELECT
        `product_price`.`product_id`
      FROM
        `product_price`
      WHERE
        `product_price`.`product_id` = `product`.id
        AND `product_price`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `prices` = IFNULL(
                        (
                            SELECT `product_price`.`product_id`
                            FROM   `product_price`
                            WHERE  `product_price`.`product_id`         = `product`.id
                            AND `product_price`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

3.37 ms
(6.66%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 978)
2	Doctrine\DBAL\Connection->transactional (line 45)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
7	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
8	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
9	Shopware\Core\Framework\Context->scope (line 72)
10	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
13	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
19	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
20	Shopware\Core\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 10)

2.07 ms
(4.08%)

UPDATE `product` SET `categories` = IFNULL(
                        (
                            SELECT `product_category`.`product_id`
                            FROM   `product_category`
                            WHERE  `product_category`.`product_id`         = `product`.id
                            AND `product_category`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `categories` = IFNULL(
    (
      SELECT
        `product_category`.`product_id`
      FROM
        `product_category`
      WHERE
        `product_category`.`product_id` = `product`.id
        AND `product_category`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `categories` = IFNULL(
                        (
                            SELECT `product_category`.`product_id`
                            FROM   `product_category`
                            WHERE  `product_category`.`product_id`         = `product`.id
                            AND `product_category`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

1.78 ms
(3.52%)

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  custom_entity.name,
  custom_entity.fields,
  custom_entity.flags
FROM
  custom_entity
  LEFT JOIN app ON app.id = custom_entity.app_id
WHERE
  (
    custom_entity.app_id IS NULL
    OR app.active = 1
  )
  AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 34)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 63)
4	Shopware\Core\System\System->boot (line 127)
5	Symfony\Component\HttpKernel\Kernel->boot (line 150)
6	Shopware\Core\Kernel->boot (line 126)
7	Shopware\Core\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 10)

1.74 ms
(3.44%)

UPDATE `product` SET `customPrice` = IFNULL(
                        (
                            SELECT `custom_price`.`product_id`
                            FROM   `custom_price`
                            WHERE  `custom_price`.`product_id`         = `product`.id
                            AND `custom_price`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `customPrice` = IFNULL(
    (
      SELECT
        `custom_price`.`product_id`
      FROM
        `custom_price`
      WHERE
        `custom_price`.`product_id` = `product`.id
        AND `custom_price`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `customPrice` = IFNULL(
                        (
                            SELECT `custom_price`.`product_id`
                            FROM   `custom_price`
                            WHERE  `custom_price`.`product_id`         = `product`.id
                            AND `custom_price`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

1.66 ms
(3.28%)

UPDATE `product` AS `product`
                    SET `product`.`deliveryTime` = `product`.`delivery_time_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` AS `product`
SET
  `product`.`deliveryTime` = `product`.`delivery_time_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`deliveryTime` = `product`.`delivery_time_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 199)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():198} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

1.65 ms
(3.25%)

UPDATE `product_translation` SET custom_fields = JSON_SET(IFNULL(`custom_fields`, "{}"), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WHERE (`product_id` = ?) AND (`language_id` = ?) AND (`product_version_id` = ?)

Parameters:

[
  "$."custom_products_danger_symbol""
  null
  "$."custom_products_atdksp""
  null
  "$."custom_products_nml""
  null
  "$."custom_products_batterie_number""
  null
  "$."custom_products_cr_number""
  null
  "$."custom_products_export_rules""
  null
  "$."custom_products_eClass_4""
  null
  "$."custom_products_serial_number""
  null
  "$."custom_products_eClass_10""
  null
  "$."custom_products_ivd""
  null
  "$."custom_products_fi_number""
  null
  "$."custom_products_batch""
  null
  "$."custom_products_unspsc""
  "41122400"
  "$."custom_products_batterie""
  null
  "$."custom_products_vgk_number""
  null
  "$."custom_products_eClass_name""
  null
  "$."custom_products_breakable""
  null
  "$."custom_products_electro""
  null
  "$."custom_products_cas_number""
  null
  "$."custom_products_packing""
  null
  "$."custom_products_vwr_number""
  null
  "$."custom_products_original_box""
  null
  "$."custom_products_made_in""
  null
  "$."custom_llg_userref""
  null
  "$."custom_llg_gef_GHS""
  null
  "$."custom_llg_gef_SWort""
  null
  "$."custom_llg_gef_HSAETZE""
  null
  "$."custom_llg_gef_PSAETZE""
  null
  "$."custom_llg_adr_UNNR""
  null
  "$."custom_gef_WebLink""
  null
  "$."llg_lastSyncDate_fr""
  "2026-05-13 13:21:43"
  "$."llg_id""
  "prd_segment_825453"
  "$."smarthub_hashKey""
  "f78c7adce5a5baa37b003d7e68ee03e3706d8520f27c13a0969578a86cc7e12d"
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"ü¯™I#2NT£ÒO\x16ÿÝ0K"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product_translation`
SET
  custom_fields = JSON_SET(
    IFNULL(`custom_fields`, "{}"),
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
WHERE
  (`product_id` = ?)
  AND (`language_id` = ?)
  AND (`product_version_id` = ?)

UPDATE `product_translation` SET custom_fields = JSON_SET(IFNULL(`custom_fields`, "{}"), '$.\"custom_products_danger_symbol\"', NULL, '$.\"custom_products_atdksp\"', NULL, '$.\"custom_products_nml\"', NULL, '$.\"custom_products_batterie_number\"', NULL, '$.\"custom_products_cr_number\"', NULL, '$.\"custom_products_export_rules\"', NULL, '$.\"custom_products_eClass_4\"', NULL, '$.\"custom_products_serial_number\"', NULL, '$.\"custom_products_eClass_10\"', NULL, '$.\"custom_products_ivd\"', NULL, '$.\"custom_products_fi_number\"', NULL, '$.\"custom_products_batch\"', NULL, '$.\"custom_products_unspsc\"', '41122400', '$.\"custom_products_batterie\"', NULL, '$.\"custom_products_vgk_number\"', NULL, '$.\"custom_products_eClass_name\"', NULL, '$.\"custom_products_breakable\"', NULL, '$.\"custom_products_electro\"', NULL, '$.\"custom_products_cas_number\"', NULL, '$.\"custom_products_packing\"', NULL, '$.\"custom_products_vwr_number\"', NULL, '$.\"custom_products_original_box\"', NULL, '$.\"custom_products_made_in\"', NULL, '$.\"custom_llg_userref\"', NULL, '$.\"custom_llg_gef_GHS\"', NULL, '$.\"custom_llg_gef_SWort\"', NULL, '$.\"custom_llg_gef_HSAETZE\"', NULL, '$.\"custom_llg_gef_PSAETZE\"', NULL, '$.\"custom_llg_adr_UNNR\"', NULL, '$.\"custom_gef_WebLink\"', NULL, '$.\"llg_lastSyncDate_fr\"', '2026-05-13 13:21:43', '$.\"llg_id\"', 'prd_segment_825453', '$.\"smarthub_hashKey\"', 'f78c7adce5a5baa37b003d7e68ee03e3706d8520f27c13a0969578a86cc7e12d') WHERE (`product_id` = 0x00000C986D7E7E7E7E7E7E7E7E7E0002) AND (`language_id` = 0xFCAF994923324E54A3D24F16FFDD304B) AND (`product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 342)
2	Doctrine\DBAL\Query\QueryBuilder->executeStatement (line 462)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeJsonUpdate():461} (line 59)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 461)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeJsonUpdate (line 184)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
9	Doctrine\DBAL\Connection->transactional (line 45)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
11	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
13	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
14	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
15	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
16	Shopware\Core\Framework\Context->scope (line 72)
17	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 10)

1.49 ms
(2.95%)

UPDATE `product` SET `properties` = IFNULL(
                        (
                            SELECT `product_property`.`product_id`
                            FROM   `product_property`
                            WHERE  `product_property`.`product_id`         = `product`.id
                            AND `product_property`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `properties` = IFNULL(
    (
      SELECT
        `product_property`.`product_id`
      FROM
        `product_property`
      WHERE
        `product_property`.`product_id` = `product`.id
        AND `product_property`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `properties` = IFNULL(
                        (
                            SELECT `product_property`.`product_id`
                            FROM   `product_property`
                            WHERE  `product_property`.`product_id`         = `product`.id
                            AND `product_property`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

1.46 ms
(2.89%)

UPDATE `product` SET `version_id` = ?, `parent_version_id` = ?, `product_manufacturer_id` = ?, `product_manufacturer_version_id` = ?, `product_media_version_id` = ?, `canonical_product_version_id` = ?, `cms_page_version_id` = ?, `product_number` = ?, `active` = ?, `variant_listing_config` = ?, `updated_at` = ? WHERE id = ? AND version_id = ?

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00\x00”\x03\x08~~~~~~~~~\x00\x04"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  "825453"
  1
  "{"displayParent":1}"
  "2026-05-13 13:22:02.743"
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `version_id` = ?,
  `parent_version_id` = ?,
  `product_manufacturer_id` = ?,
  `product_manufacturer_version_id` = ?,
  `product_media_version_id` = ?,
  `canonical_product_version_id` = ?,
  `cms_page_version_id` = ?,
  `product_number` = ?,
  `active` = ?,
  `variant_listing_config` = ?,
  `updated_at` = ?
WHERE
  id = ?
  AND version_id = ?

UPDATE `product` SET `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `parent_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_manufacturer_id` = 0x00009403087E7E7E7E7E7E7E7E7E0004, `product_manufacturer_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_media_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `canonical_product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `cms_page_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_number` = '825453', `active` = 1, `variant_listing_config` = '{\"displayParent\":1}', `updated_at` = '2026-05-13 13:22:02.743' WHERE id = 0x00000C986D7E7E7E7E7E7E7E7E7E0002 AND version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 483)
2	Doctrine\DBAL\Connection->update (line 199)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():198} (line 59)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
8	Doctrine\DBAL\Connection->transactional (line 45)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
13	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
14	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
15	Shopware\Core\Framework\Context->scope (line 72)
16	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

1.27 ms
(2.52%)

UPDATE `product` SET `translations` = IFNULL(
                        (
                            SELECT `product_translation`.`product_id`
                            FROM   `product_translation`
                            WHERE  `product_translation`.`product_id`         = `product`.id
                            AND `product_translation`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `translations` = IFNULL(
    (
      SELECT
        `product_translation`.`product_id`
      FROM
        `product_translation`
      WHERE
        `product_translation`.`product_id` = `product`.id
        AND `product_translation`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `translations` = IFNULL(
                        (
                            SELECT `product_translation`.`product_id`
                            FROM   `product_translation`
                            WHERE  `product_translation`.`product_id`         = `product`.id
                            AND `product_translation`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

1.26 ms
(2.49%)

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`deliveryTime` = IFNULL(`product`.`delivery_time_id`, parent.`delivery_time_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`deliveryTime` = IFNULL(
    `product`.`delivery_time_id`, parent.`delivery_time_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`deliveryTime` = IFNULL(`product`.`delivery_time_id`, parent.`delivery_time_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 172)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():171} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 171)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

1.11 ms
(2.19%)

SELECT LOWER(HEX(product.id)) as id,
                   GROUP_CONCAT(DISTINCT translation.name SEPARATOR " ") as name,
                   CONCAT("[", GROUP_CONCAT(translation.custom_search_keywords), "]") as custom_search_keywords,
                   GROUP_CONCAT(DISTINCT tag.name SEPARATOR " ") as tags,
                   product.product_number,
                   product.ean,
                   product.manufacturer_number
            FROM product
                INNER JOIN product_translation AS translation
                    ON product.id = translation.product_id AND product.version_id = translation.product_version_id
                LEFT JOIN product_tag
                    ON product.id = product_tag.product_id AND product.version_id = product_tag.product_version_id
                LEFT JOIN tag
                    ON product_tag.tag_id = tag.id
            WHERE product.id IN (?, ?)
            AND product.version_id = ?
            GROUP BY product.id

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(product.id)
  ) as id,
  GROUP_CONCAT(
    DISTINCT translation.name SEPARATOR " "
  ) as name,
  CONCAT(
    "[",
    GROUP_CONCAT(
      translation.custom_search_keywords
    ),
    "]"
  ) as custom_search_keywords,
  GROUP_CONCAT(DISTINCT tag.name SEPARATOR " ") as tags,
  product.product_number,
  product.ean,
  product.manufacturer_number
FROM
  product
  INNER JOIN product_translation AS translation ON product.id = translation.product_id
  AND product.version_id = translation.product_version_id
  LEFT JOIN product_tag ON product.id = product_tag.product_id
  AND product.version_id = product_tag.product_version_id
  LEFT JOIN tag ON product_tag.tag_id = tag.id
WHERE
  product.id IN (?, ?)
  AND product.version_id = ?
GROUP BY
  product.id

SELECT LOWER(HEX(product.id)) as id,
                   GROUP_CONCAT(DISTINCT translation.name SEPARATOR " ") as name,
                   CONCAT("[", GROUP_CONCAT(translation.custom_search_keywords), "]") as custom_search_keywords,
                   GROUP_CONCAT(DISTINCT tag.name SEPARATOR " ") as tags,
                   product.product_number,
                   product.ean,
                   product.manufacturer_number
            FROM product
                INNER JOIN product_translation AS translation
                    ON product.id = translation.product_id AND product.version_id = translation.product_version_id
                LEFT JOIN product_tag
                    ON product.id = product_tag.product_id AND product.version_id = product_tag.product_version_id
                LEFT JOIN tag
                    ON product_tag.tag_id = tag.id
            WHERE product.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
            AND product.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425
            GROUP BY product.id
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 124)
3	Shopware\Elasticsearch\Admin\Indexer\ProductAdminSearchIndexer->fetch (line 239)
4	Shopware\Elasticsearch\Admin\AdminSearchRegistry->push (line 80)
5	Shopware\Elasticsearch\Admin\AdminSearchRegistry->__invoke (line 176)
6	Shopware\Elasticsearch\Admin\AdminSearchRegistry->refresh (line 246)
7	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
10	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
11	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
12	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
13	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
14	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
15	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
16	Shopware\Core\Framework\Context->scope (line 72)
17	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 10)

1.09 ms
(2.16%)

SELECT
        LOWER(HEX(w.id)) as webhookId,
        w.name as webhookName,
        w.event_name as eventName,
        w.url as webhookUrl,
        w.only_live_version as onlyLiveVersion,
        LOWER(HEX(a.id)) AS appId,
        a.name AS appName,
        a.active AS appActive,
        a.source_type AS appSourceType,
        a.version AS appVersion,
        a.app_secret AS appSecret,
        LOWER(HEX(a.acl_role_id)) as appAclRoleId
    FROM webhook w
    LEFT JOIN app a ON (a.id = w.app_id)
    WHERE w.active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(w.id)
  ) as webhookId,
  w.name as webhookName,
  w.event_name as eventName,
  w.url as webhookUrl,
  w.only_live_version as onlyLiveVersion,
  LOWER(
    HEX(a.id)
  ) AS appId,
  a.name AS appName,
  a.active AS appActive,
  a.source_type AS appSourceType,
  a.version AS appVersion,
  a.app_secret AS appSecret,
  LOWER(
    HEX(a.acl_role_id)
  ) as appAclRoleId
FROM
  webhook w
  LEFT JOIN app a ON (a.id = w.app_id)
WHERE
  w.active = 1

SELECT
        LOWER(HEX(w.id)) as webhookId,
        w.name as webhookName,
        w.event_name as eventName,
        w.url as webhookUrl,
        w.only_live_version as onlyLiveVersion,
        LOWER(HEX(a.id)) AS appId,
        a.name AS appName,
        a.active AS appActive,
        a.source_type AS appSourceType,
        a.version AS appVersion,
        a.app_secret AS appSecret,
        LOWER(HEX(a.acl_role_id)) as appAclRoleId
    FROM webhook w
    LEFT JOIN app a ON (a.id = w.app_id)
    WHERE w.active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 78)
3	Shopware\Core\Framework\Webhook\Service\WebhookLoader->getWebhooks (line 347)
4	Shopware\Core\Framework\Webhook\Service\WebhookManager->loadWebhooks (line 336)
5	Shopware\Core\Framework\Webhook\Service\WebhookManager->getWebhooks (line 97)
6	Shopware\Core\Framework\Webhook\Service\WebhookManager->callWebhooks (line 75)
7	Shopware\Core\Framework\Webhook\Service\WebhookManager->dispatch (line 34)
8	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
9	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
10	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
11	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
12	Shopware\Core\Framework\Context->scope (line 72)
13	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

0.97 ms
(1.91%)

UPDATE `product` SET `media` = IFNULL(
                        (
                            SELECT `product_media`.`product_id`
                            FROM   `product_media`
                            WHERE  `product_media`.`product_id`         = `product`.id
                            AND `product_media`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `media` = IFNULL(
    (
      SELECT
        `product_media`.`product_id`
      FROM
        `product_media`
      WHERE
        `product_media`.`product_id` = `product`.id
        AND `product_media`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `media` = IFNULL(
                        (
                            SELECT `product_media`.`product_id`
                            FROM   `product_media`
                            WHERE  `product_media`.`product_id`         = `product`.id
                            AND `product_media`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.95 ms
(1.87%)

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`canonicalProduct` = IFNULL(`product`.`canonical_product_id`, parent.`canonical_product_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`canonicalProduct` = IFNULL(
    `product`.`canonical_product_id`,
    parent.`canonical_product_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`canonicalProduct` = IFNULL(`product`.`canonical_product_id`, parent.`canonical_product_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 172)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():171} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 171)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.92 ms
(1.82%)

UPDATE `product` SET `warehouseGroups` = IFNULL(
                        (
                            SELECT `product_warehouse_group`.`product_id`
                            FROM   `product_warehouse_group`
                            WHERE  `product_warehouse_group`.`product_id`         = `product`.id
                            AND `product_warehouse_group`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `warehouseGroups` = IFNULL(
    (
      SELECT
        `product_warehouse_group`.`product_id`
      FROM
        `product_warehouse_group`
      WHERE
        `product_warehouse_group`.`product_id` = `product`.id
        AND `product_warehouse_group`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `warehouseGroups` = IFNULL(
                        (
                            SELECT `product_warehouse_group`.`product_id`
                            FROM   `product_warehouse_group`
                            WHERE  `product_warehouse_group`.`product_id`         = `product`.id
                            AND `product_warehouse_group`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.89 ms
(1.76%)

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

# dbal-plugin-loader
SELECT
  `name`,
  `base_class` AS baseClass,
  IF(
    `active` = 1
    AND `installed_at` IS NOT NULL,
    1,
    0
  ) AS active,
  `path`,
  `version`,
  `autoload`,
  `managed_by_composer` AS managedByComposer,
  composer_name as composerName
FROM
  `plugin`
ORDER BY
  `installed_at`;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 40)
2	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line 114)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 142)
4	Shopware\Core\Kernel->boot (line 126)
5	Shopware\Core\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 10)

0.84 ms
(1.65%)

UPDATE `product` SET `subscriptionPlans` = IFNULL(
                        (
                            SELECT `subscription_plan_product_mapping`.`product_id`
                            FROM   `subscription_plan_product_mapping`
                            WHERE  `subscription_plan_product_mapping`.`product_id`         = `product`.id
                            AND `subscription_plan_product_mapping`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `subscriptionPlans` = IFNULL(
    (
      SELECT
        `subscription_plan_product_mapping`.`product_id`
      FROM
        `subscription_plan_product_mapping`
      WHERE
        `subscription_plan_product_mapping`.`product_id` = `product`.id
        AND `subscription_plan_product_mapping`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `subscriptionPlans` = IFNULL(
                        (
                            SELECT `subscription_plan_product_mapping`.`product_id`
                            FROM   `subscription_plan_product_mapping`
                            WHERE  `subscription_plan_product_mapping`.`product_id`         = `product`.id
                            AND `subscription_plan_product_mapping`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.83 ms
(1.63%)

UPDATE `product` SET `tags` = IFNULL(
                        (
                            SELECT `product_tag`.`product_id`
                            FROM   `product_tag`
                            WHERE  `product_tag`.`product_id`         = `product`.id
                            AND `product_tag`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `tags` = IFNULL(
    (
      SELECT
        `product_tag`.`product_id`
      FROM
        `product_tag`
      WHERE
        `product_tag`.`product_id` = `product`.id
        AND `product_tag`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `tags` = IFNULL(
                        (
                            SELECT `product_tag`.`product_id`
                            FROM   `product_tag`
                            WHERE  `product_tag`.`product_id`         = `product`.id
                            AND `product_tag`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.83 ms
(1.63%)

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`featureSet` = IFNULL(`product`.`product_feature_set_id`, parent.`product_feature_set_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`featureSet` = IFNULL(
    `product`.`product_feature_set_id`,
    parent.`product_feature_set_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`featureSet` = IFNULL(`product`.`product_feature_set_id`, parent.`product_feature_set_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 172)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():171} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 171)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.82 ms
(1.62%)

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`unit` = IFNULL(`product`.`unit_id`, parent.`unit_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`unit` = IFNULL(
    `product`.`unit_id`, parent.`unit_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`unit` = IFNULL(`product`.`unit_id`, parent.`unit_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 172)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():171} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 171)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.80 ms
(1.59%)

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`manufacturer` = IFNULL(`product`.`product_manufacturer_id`, parent.`product_manufacturer_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`manufacturer` = IFNULL(
    `product`.`product_manufacturer_id`,
    parent.`product_manufacturer_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`manufacturer` = IFNULL(`product`.`product_manufacturer_id`, parent.`product_manufacturer_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 172)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():171} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 171)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.77 ms
(1.52%)

UPDATE `product_translation` SET `product_id` = ?, `language_id` = ?, `product_version_id` = ?, `name` = ?, `description` = ?, `custom_search_keywords` = ?, `updated_at` = ? WHERE product_id = ? AND language_id = ? AND product_version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"ü¯™I#2NT£ÒO\x16ÿÝ0K"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  "Lames de rechange pour coupe-tuyaux"
  "<div><br></div><div><table class="sw-text-editor-table"><tbody class="sw-text-editor-table__body"></tbody></table></div>"
  "["Outil(s)","Lames de rechange pour coupetuyaux"]"
  "2026-05-13 13:22:02.744"
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"ü¯™I#2NT£ÒO\x16ÿÝ0K"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product_translation`
SET
  `product_id` = ?,
  `language_id` = ?,
  `product_version_id` = ?,
  `name` = ?,
  `description` = ?,
  `custom_search_keywords` = ?,
  `updated_at` = ?
WHERE
  product_id = ?
  AND language_id = ?
  AND product_version_id = ?

UPDATE `product_translation` SET `product_id` = 0x00000C986D7E7E7E7E7E7E7E7E7E0002, `language_id` = 0xFCAF994923324E54A3D24F16FFDD304B, `product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `name` = 'Lames de rechange pour coupe-tuyaux', `description` = '<div><br></div><div><table class=\"sw-text-editor-table\"><tbody class=\"sw-text-editor-table__body\"></tbody></table></div>', `custom_search_keywords` = '[\"Outil(s)\",\"Lames de rechange pour coupetuyaux\"]', `updated_at` = '2026-05-13 13:22:02.744' WHERE product_id = 0x00000C986D7E7E7E7E7E7E7E7E7E0002 AND language_id = 0xFCAF994923324E54A3D24F16FFDD304B AND product_version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 483)
2	Doctrine\DBAL\Connection->update (line 199)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():198} (line 59)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
8	Doctrine\DBAL\Connection->transactional (line 45)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
13	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
14	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
15	Shopware\Core\Framework\Context->scope (line 72)
16	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.75 ms
(1.47%)

UPDATE `product` AS `product`
                    SET `product`.`tax` = `product`.`tax_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` AS `product`
SET
  `product`.`tax` = `product`.`tax_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`tax` = `product`.`tax_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 199)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():198} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.74 ms
(1.47%)

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`tax` = IFNULL(`product`.`tax_id`, parent.`tax_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`tax` = IFNULL(
    `product`.`tax_id`, parent.`tax_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`tax` = IFNULL(`product`.`tax_id`, parent.`tax_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 172)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():171} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 171)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.74 ms
(1.46%)

UPDATE `product` SET `crossSellings` = IFNULL(
                        (
                            SELECT `product_cross_selling`.`product_id`
                            FROM   `product_cross_selling`
                            WHERE  `product_cross_selling`.`product_id`         = `product`.id
                            AND `product_cross_selling`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `crossSellings` = IFNULL(
    (
      SELECT
        `product_cross_selling`.`product_id`
      FROM
        `product_cross_selling`
      WHERE
        `product_cross_selling`.`product_id` = `product`.id
        AND `product_cross_selling`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `crossSellings` = IFNULL(
                        (
                            SELECT `product_cross_selling`.`product_id`
                            FROM   `product_cross_selling`
                            WHERE  `product_cross_selling`.`product_id`         = `product`.id
                            AND `product_cross_selling`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.74 ms
(1.45%)

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`cmsPage` = IFNULL(`product`.`cms_page_id`, parent.`cms_page_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`cmsPage` = IFNULL(
    `product`.`cms_page_id`, parent.`cms_page_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`cmsPage` = IFNULL(`product`.`cms_page_id`, parent.`cms_page_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 172)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():171} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 171)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.73 ms
(1.45%)

UPDATE `product` SET `visibilities` = IFNULL(
                        (
                            SELECT `product_visibility`.`product_id`
                            FROM   `product_visibility`
                            WHERE  `product_visibility`.`product_id`         = `product`.id
                            AND `product_visibility`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `visibilities` = IFNULL(
    (
      SELECT
        `product_visibility`.`product_id`
      FROM
        `product_visibility`
      WHERE
        `product_visibility`.`product_id` = `product`.id
        AND `product_visibility`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `visibilities` = IFNULL(
                        (
                            SELECT `product_visibility`.`product_id`
                            FROM   `product_visibility`
                            WHERE  `product_visibility`.`product_id`         = `product`.id
                            AND `product_visibility`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.70 ms
(1.38%)

UPDATE `product` SET `customFieldSets` = IFNULL(
                        (
                            SELECT `product_custom_field_set`.`product_id`
                            FROM   `product_custom_field_set`
                            WHERE  `product_custom_field_set`.`product_id`         = `product`.id
                            AND `product_custom_field_set`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `customFieldSets` = IFNULL(
    (
      SELECT
        `product_custom_field_set`.`product_id`
      FROM
        `product_custom_field_set`
      WHERE
        `product_custom_field_set`.`product_id` = `product`.id
        AND `product_custom_field_set`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `customFieldSets` = IFNULL(
                        (
                            SELECT `product_custom_field_set`.`product_id`
                            FROM   `product_custom_field_set`
                            WHERE  `product_custom_field_set`.`product_id`         = `product`.id
                            AND `product_custom_field_set`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.68 ms
(1.35%)

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`cover` = IFNULL(`product`.`product_media_id`, parent.`product_media_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` as `product`,
  `product` as parent
SET
  `product`.`cover` = IFNULL(
    `product`.`product_media_id`, parent.`product_media_id`
  )
WHERE
  `product`.parent_id = parent.id
  AND `product`.parent_id IS NOT NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = parent.version_id
  AND `product`.version_id = ?

UPDATE `product` as `product`, `product` as parent
                    SET `product`.`cover` = IFNULL(`product`.`product_media_id`, parent.`product_media_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 172)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():171} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 171)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.66 ms
(1.31%)

UPDATE `product` SET `warehouses` = IFNULL(
                        (
                            SELECT `product_warehouse`.`product_id`
                            FROM   `product_warehouse`
                            WHERE  `product_warehouse`.`product_id`         = `product`.id
                            AND `product_warehouse`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?, ?)
                     AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `warehouses` = IFNULL(
    (
      SELECT
        `product_warehouse`.`product_id`
      FROM
        `product_warehouse`
      WHERE
        `product_warehouse`.`product_id` = `product`.id
        AND `product_warehouse`.`product_version_id` = `product`.version_id
      LIMIT
        1
    ), IFNULL(
      `product`.parent_id, `product`.id
    )
  )
WHERE
  `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` SET `warehouses` = IFNULL(
                        (
                            SELECT `product_warehouse`.`product_id`
                            FROM   `product_warehouse`
                            WHERE  `product_warehouse`.`product_id`         = `product`.id
                            AND `product_warehouse`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
                     AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 122)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToManyAssociations():121} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 121)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToManyAssociations (line 52)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.63 ms
(1.25%)

UPDATE `product` AS `product`
                    SET `product`.`canonicalProduct` = `product`.`canonical_product_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` AS `product`
SET
  `product`.`canonicalProduct` = `product`.`canonical_product_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`canonicalProduct` = `product`.`canonical_product_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 199)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():198} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.60 ms
(1.19%)

SELECT 1 as `exists` FROM `product_translation` WHERE (`product_id` = ?) AND (`language_id` = ?) AND (`product_version_id` = ?)

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"ü¯™I#2NT£ÒO\x16ÿÝ0K"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 as `exists`
FROM
  `product_translation`
WHERE
  (`product_id` = ?)
  AND (`language_id` = ?)
  AND (`product_version_id` = ?)

SELECT 1 as `exists` FROM `product_translation` WHERE (`product_id` = 0x00000C986D7E7E7E7E7E7E7E7E7E0002) AND (`language_id` = 0xFCAF994923324E54A3D24F16FFDD304B) AND (`product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 716)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->fetchFromDatabase (line 660)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->getCurrentState (line 85)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->getExistence (line 210)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 202)
7	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\TranslationsAssociationFieldSerializer->map (line 314)
8	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 224)
9	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 101)
10	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
11	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
12	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
13	Shopware\Core\Framework\Context->scope (line 72)
14	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.60 ms
(1.18%)

UPDATE `product` SET `version_id` = ?, `parent_id` = ?, `parent_version_id` = ?, `product_manufacturer_id` = ?, `product_manufacturer_version_id` = ?, `product_media_version_id` = ?, `canonical_product_version_id` = ?, `cms_page_version_id` = ?, `product_number` = ?, `active` = ?, `variant_listing_config` = ?, `updated_at` = ? WHERE id = ? AND version_id = ?

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00\x00”\x03\x08~~~~~~~~~\x00\x04"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  "9205899"
  1
  "{"displayParent":1}"
  "2026-05-13 13:22:02.747"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product`
SET
  `version_id` = ?,
  `parent_id` = ?,
  `parent_version_id` = ?,
  `product_manufacturer_id` = ?,
  `product_manufacturer_version_id` = ?,
  `product_media_version_id` = ?,
  `canonical_product_version_id` = ?,
  `cms_page_version_id` = ?,
  `product_number` = ?,
  `active` = ?,
  `variant_listing_config` = ?,
  `updated_at` = ?
WHERE
  id = ?
  AND version_id = ?

UPDATE `product` SET `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `parent_id` = 0x00000C986D7E7E7E7E7E7E7E7E7E0002, `parent_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_manufacturer_id` = 0x00009403087E7E7E7E7E7E7E7E7E0004, `product_manufacturer_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_media_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `canonical_product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `cms_page_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425, `product_number` = '9205899', `active` = 1, `variant_listing_config` = '{\"displayParent\":1}', `updated_at` = '2026-05-13 13:22:02.747' WHERE id = 0x00008C788B7E7E7E7E7E7E7E7E7E0003 AND version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 483)
2	Doctrine\DBAL\Connection->update (line 199)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():198} (line 59)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
8	Doctrine\DBAL\Connection->transactional (line 45)
9	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
13	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
14	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
15	Shopware\Core\Framework\Context->scope (line 72)
16	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.58 ms
(1.15%)

UPDATE `product` AS `product`
                    SET `product`.`manufacturer` = `product`.`product_manufacturer_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` AS `product`
SET
  `product`.`manufacturer` = `product`.`product_manufacturer_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`manufacturer` = `product`.`product_manufacturer_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 199)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():198} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.58 ms
(1.14%)

UPDATE `product` AS `product`
                    SET `product`.`featureSet` = `product`.`product_feature_set_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` AS `product`
SET
  `product`.`featureSet` = `product`.`product_feature_set_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`featureSet` = `product`.`product_feature_set_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 199)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():198} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.57 ms
(1.13%)

UPDATE `product` AS `product`
                    SET `product`.`cover` = `product`.`product_media_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` AS `product`
SET
  `product`.`cover` = `product`.`product_media_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`cover` = `product`.`product_media_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 199)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():198} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.57 ms
(1.13%)

UPDATE `product` AS `product`
                    SET `product`.`unit` = `product`.`unit_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` AS `product`
SET
  `product`.`unit` = `product`.`unit_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`unit` = `product`.`unit_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 199)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():198} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.56 ms
(1.11%)

UPDATE `product` AS `product`
                    SET `product`.`cmsPage` = `product`.`cms_page_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?, ?)AND `product`.version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `product` AS `product`
SET
  `product`.`cmsPage` = `product`.`cms_page_id`
WHERE
  `product`.parent_id IS NULL
  AND `product`.id IN (?, ?)
  AND `product`.version_id = ?

UPDATE `product` AS `product`
                    SET `product`.`cmsPage` = `product`.`cms_page_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)AND `product`.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 199)
2	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->{closure:Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater::updateToOneAssociations():198} (line 59)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 39)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 198)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->updateToOneAssociations (line 58)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\InheritanceUpdater->update (line 99)
7	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->{closure:Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer::update():98} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 98)
9	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
10	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
11	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
19	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
20	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
21	Shopware\Core\Framework\Context->scope (line 72)
22	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.56 ms
(1.10%)

SELECT 1 as `exists`, parent_id FROM `product` WHERE (`id` = ?) AND (`version_id` = ?)

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 as `exists`,
  parent_id
FROM
  `product`
WHERE
  (`id` = ?)
  AND (`version_id` = ?)

SELECT 1 as `exists`, parent_id FROM `product` WHERE (`id` = 0x00000C986D7E7E7E7E7E7E7E7E7E0002) AND (`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 716)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->fetchFromDatabase (line 660)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->getCurrentState (line 85)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->getExistence (line 210)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 101)
7	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
8	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
9	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
10	Shopware\Core\Framework\Context->scope (line 72)
11	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
14	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
21	Shopware\Core\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 10)

0.51 ms
(1.01%)

SELECT item_rounding FROM currency WHERE id = ?

Parameters:

[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 300)
2	Doctrine\DBAL\Connection->fetchAssociative (line 335)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getCashRounding (line 49)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
5	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
6	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
7	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
8	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
11	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.50 ms
(1.00%)

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `name`,
  `type`
FROM
  `custom_field`
WHERE
  `active` = 1

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 638)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 132)
3	Shopware\Core\System\CustomField\CustomFieldService->getCustomFields (line 54)
4	Shopware\Core\System\CustomField\CustomFieldService->getCustomField (line 101)
5	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->getFields (line 56)
6	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->encode (line 314)
7	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 218)
8	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 202)
9	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\TranslationsAssociationFieldSerializer->map (line 314)
10	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->map (line 224)
11	Shopware\Core\Framework\DataAbstractionLayer\Write\WriteCommandExtractor->extract (line 101)
12	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
13	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
14	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
15	Shopware\Core\Framework\Context->scope (line 72)
16	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.47 ms
(0.94%)

SELECT `key`, `value` FROM `app_config`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 638)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 70)
3	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->load (line 36)
4	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->get (line 47)
5	Shopware\Core\Framework\Feature\FeatureFlagRegistry->register (line 150)
6	Shopware\Core\Framework\Framework->boot (line 127)
7	Symfony\Component\HttpKernel\Kernel->boot (line 150)
8	Shopware\Core\Kernel->boot (line 126)
9	Shopware\Core\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 10)

0.45 ms
(0.88%)

REPLACE INTO `product_property` (`product_id`, `property_group_option_id`, `product_version_id`) VALUES (?,?,?), (?,?,?);

Parameters:

[
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"‡ã\x1AkW\x16ŽG¤Sré\x10*]è"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x16+gL]c¤Sá˜6g¨\x1C'Ð"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

REPLACE INTO `product_property` (
  `product_id`, `property_group_option_id`,
  `product_version_id`
)
VALUES
  (?, ?, ?),
  (?, ?, ?);

REPLACE INTO `product_property` (`product_id`, `property_group_option_id`, `product_version_id`) VALUES (0x00008C788B7E7E7E7E7E7E7E7E7E0003,0x87E31A6B57168D47A45372E9102A5DE8,0x0FA91CE3E96A4BC2BE4BD9CE752C3425), (0x00008C788B7E7E7E7E7E7E7E7E7E0003,0x162B674C5D63A453E1983667A81C27D0,0x0FA91CE3E96A4BC2BE4BD9CE752C3425);;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 76)
2	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\MultiInsertQueryQueue->{closure:Shopware\Core\Framework\DataAbstractionLayer\Doctrine\MultiInsertQueryQueue::execute():74} (line 964)
3	Doctrine\DBAL\Connection->transactional (line 45)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 74)
6	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\MultiInsertQueryQueue->execute (line 230)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
9	Doctrine\DBAL\Connection->transactional (line 45)
10	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
11	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
13	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
14	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
15	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
16	Shopware\Core\Framework\Context->scope (line 72)
17	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 10)

0.41 ms
(0.82%)

SELECT 1 as `exists`, `product_id`, `language_id`, `product_version_id` FROM `product_translation` WHERE (`product_id`,`language_id`,`product_version_id`) IN ((?,?,?),(?,?,?))

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"ü¯™I#2NT£ÒO\x16ÿÝ0K"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"ü¯™I#2NT£ÒO\x16ÿÝ0K"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 as `exists`,
  `product_id`,
  `language_id`,
  `product_version_id`
FROM
  `product_translation`
WHERE
  (
    `product_id`, `language_id`, `product_version_id`
  ) IN (
    (?, ?, ?),
    (?, ?, ?)
  )

SELECT 1 as `exists`, `product_id`, `language_id`, `product_version_id` FROM `product_translation` WHERE (`product_id`,`language_id`,`product_version_id`) IN ((0x00000C986D7E7E7E7E7E7E7E7E7E0002,0xFCAF994923324E54A3D24F16FFDD304B,0x0FA91CE3E96A4BC2BE4BD9CE752C3425),(0x00008C788B7E7E7E7E7E7E7E7E7E0003,0xFCAF994923324E54A3D24F16FFDD304B,0x0FA91CE3E96A4BC2BE4BD9CE752C3425));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 341)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetch (line 74)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetchExistences (line 94)
5	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
6	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
7	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
8	Shopware\Core\Framework\Context->scope (line 72)
9	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
19	Shopware\Core\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 10)

0.41 ms
(0.80%)

SELECT DISTINCT LOWER(HEX(product_stream_id))
             FROM product_stream_mapping
             WHERE product_stream_mapping.product_id IN (?, ?)
             AND product_stream_mapping.product_version_id = ?

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT LOWER(
    HEX(product_stream_id)
  )
FROM
  product_stream_mapping
WHERE
  product_stream_mapping.product_id IN (?, ?)
  AND product_stream_mapping.product_version_id = ?

SELECT DISTINCT LOWER(HEX(product_stream_id))
             FROM product_stream_mapping
             WHERE product_stream_mapping.product_id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003)
             AND product_stream_mapping.product_version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 402)
3	Shopware\Core\Framework\Adapter\Cache\CacheInvalidationSubscriber->invalidateStreamsBeforeIndexing (line 246)
4	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
7	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
11	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
12	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
13	Shopware\Core\Framework\Context->scope (line 72)
14	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.40 ms
(0.80%)

SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = ?

Parameters:

[
  b"\x01›ÛÛÿh}ÑŽ%š³ÐoWÌ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `acl_role`.`privileges`
FROM
  `acl_role`
  INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE
  `app`.`integration_id` = ?

SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = 0x019BDBDBFF687DD18D259AB3D06F57CC
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 365)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->fetchPermissionsIntegrationByApp (line 261)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 169)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
8	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.38 ms
(0.75%)

REPLACE INTO `product_category` (`product_id`, `product_version_id`, `category_id`, `category_version_id`) VALUES (?,?,?,?), (?,?,?,?);

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00\x00\x01Ž„~~~~~~~~~\x00\x01"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00\x00\x01Ž„zzzzzzzzz\x00\x01"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

REPLACE INTO `product_category` (
  `product_id`, `product_version_id`,
  `category_id`, `category_version_id`
)
VALUES
  (?, ?, ?, ?),
  (?, ?, ?, ?);

REPLACE INTO `product_category` (`product_id`, `product_version_id`, `category_id`, `category_version_id`) VALUES (0x00000C986D7E7E7E7E7E7E7E7E7E0002,0x0FA91CE3E96A4BC2BE4BD9CE752C3425,0x0000018E847E7E7E7E7E7E7E7E7E0001,0x0FA91CE3E96A4BC2BE4BD9CE752C3425), (0x00000C986D7E7E7E7E7E7E7E7E7E0002,0x0FA91CE3E96A4BC2BE4BD9CE752C3425,0x0000018E847A7A7A7A7A7A7A7A7A0001,0x0FA91CE3E96A4BC2BE4BD9CE752C3425);;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 76)
2	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\MultiInsertQueryQueue->{closure:Shopware\Core\Framework\DataAbstractionLayer\Doctrine\MultiInsertQueryQueue::execute():74} (line 964)
3	Doctrine\DBAL\Connection->transactional (line 45)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 74)
6	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\MultiInsertQueryQueue->execute (line 151)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():150} (line 164)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
10	Doctrine\DBAL\Connection->transactional (line 45)
11	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
12	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
13	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
14	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
15	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
16	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
17	Shopware\Core\Framework\Context->scope (line 72)
18	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 10)

0.31 ms
(0.61%)

DELETE FROM admin_elasticsearch_index_task WHERE `entity` IN (NULL)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  admin_elasticsearch_index_task
WHERE
  `entity` IN (NULL)

DELETE FROM admin_elasticsearch_index_task WHERE `entity` IN (NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 344)
2	Shopware\Elasticsearch\Admin\AdminSearchRegistry->refreshIndices (line 142)
3	Shopware\Elasticsearch\Admin\AdminSearchRegistry->refresh (line 246)
4	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
7	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
11	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
12	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
13	Shopware\Core\Framework\Context->scope (line 72)
14	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.30 ms
(0.59%)

SELECT DISTINCT LOWER(HEX(product.parent_id)) as id FROM product WHERE id IN (?, ?)

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT LOWER(
    HEX(product.parent_id)
  ) as id
FROM
  product
WHERE
  id IN (?, ?)

SELECT DISTINCT LOWER(HEX(product.parent_id)) as id FROM product WHERE id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 287)
3	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->getParentIds (line 108)
4	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
7	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
10	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
11	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
12	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
13	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
14	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
15	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
16	Shopware\Core\Framework\Context->scope (line 72)
17	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 10)

0.28 ms
(0.55%)

SELECT 1 as `exists`, parent_id, `id`, `version_id` FROM `product` WHERE (`id` IN (?,?)) AND (version_id = ?)

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1 as `exists`,
  parent_id,
  `id`,
  `version_id`
FROM
  `product`
WHERE
  (
    `id` IN (?, ?)
  )
  AND (version_id = ?)

SELECT 1 as `exists`, parent_id, `id`, `version_id` FROM `product` WHERE (`id` IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002,0x00008C788B7E7E7E7E7E7E7E7E7E0003)) AND (version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 341)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetch (line 74)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->prefetchExistences (line 94)
5	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
6	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
7	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
8	Shopware\Core\Framework\Context->scope (line 72)
9	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
19	Shopware\Core\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 10)

0.24 ms
(0.46%)

DELETE FROM b2b_order_number WHERE custom_ordernumber IN (?, ?)

Parameters:

[
  "825453"
  "9205899"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  b2b_order_number
WHERE
  custom_ordernumber IN (?, ?)

DELETE FROM b2b_order_number WHERE custom_ordernumber IN ('825453', '9205899');

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 342)
2	Doctrine\DBAL\Query\QueryBuilder->executeStatement (line 271)
3	Shopware\B2B\OrderNumber\BridgePlatform\OrderNumberRepository->{closure:Shopware\B2B\OrderNumber\BridgePlatform\OrderNumberRepository::removeMultipleOrderNumbersByCustomOrderNumber():266} (line 33)
4	Shopware\B2B\Common\Repository\DbalHelper->transact (line 265)
5	Shopware\B2B\OrderNumber\BridgePlatform\OrderNumberRepository->removeMultipleOrderNumbersByCustomOrderNumber (line 38)
6	Shopware\B2B\OrderNumber\BridgePlatform\OrderNumberSubscriber->deleteMatchingCustomOrderNumbers (line 246)
7	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
10	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
11	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
12	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
13	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 27)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
15	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
16	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
17	Shopware\Core\Framework\Context->scope (line 72)
18	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 10)

0.23 ms
(0.46%)

SELECT id FROM integration WHERE access_key = ?

Parameters:

[
  "SWIAAVYYDXPOT09WCLDDBZFNQW"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  integration
WHERE
  access_key = ?

SELECT id FROM integration WHERE access_key = 'SWIAAVYYDXPOT09WCLDDBZFNQW';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 250)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getIntegrationIdByAccessKey (line 161)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
6	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
7	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
9	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
12	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

0.23 ms
(0.46%)

SELECT `alias`, `index` FROM admin_elasticsearch_index_task

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `alias`,
  `index`
FROM
  admin_elasticsearch_index_task

SELECT `alias`, `index` FROM admin_elasticsearch_index_task;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 638)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 151)
3	Shopware\Elasticsearch\Admin\AdminSearchRegistry->refresh (line 246)
4	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
7	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
11	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
12	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
13	Shopware\Core\Framework\Context->scope (line 72)
14	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.23 ms
(0.45%)

RELEASE SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 1195)
2	Doctrine\DBAL\Connection->releaseSavepoint (line 1088)
3	Doctrine\DBAL\Connection->commit (line 978)
4	Doctrine\DBAL\Connection->transactional (line 45)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
6	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 74)
7	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\MultiInsertQueryQueue->execute (line 151)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():150} (line 164)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
11	Doctrine\DBAL\Connection->transactional (line 45)
12	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
13	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
14	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
15	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
16	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
17	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
18	Shopware\Core\Framework\Context->scope (line 72)
19	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 10)

0.22 ms
(0.44%)

SELECT DISTINCT LOWER(HEX(id)) as id FROM product WHERE parent_id IN (?, ?)

Parameters:

[
  b"\x00\x00\f˜m~~~~~~~~~\x00\x02"
  b"\x00\x00Œx‹~~~~~~~~~\x00\x03"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT LOWER(
    HEX(id)
  ) as id
FROM
  product
WHERE
  parent_id IN (?, ?)

SELECT DISTINCT LOWER(HEX(id)) as id FROM product WHERE parent_id IN (0x00000C986D7E7E7E7E7E7E7E7E7E0002, 0x00008C788B7E7E7E7E7E7E7E7E7E0003);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 271)
3	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->getChildrenIds (line 109)
4	Shopware\Core\Content\Product\DataAbstractionLayer\ProductIndexer->update (line 140)
5	Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry->refresh (line 27)
6	Shopware\Core\Framework\DataAbstractionLayer\Indexing\Subscriber\EntityIndexingSubscriber->refreshIndex (line 246)
7	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
10	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
11	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
12	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
13	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
14	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
15	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
16	Shopware\Core\Framework\Context->scope (line 72)
17	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 10)

0.21 ms
(0.42%)

SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = ?

Parameters:

[
  b"\x01›ÛÛÿh}ÑŽ%š³ÐoWÌ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  role.privileges
FROM
  integration_role mapping
  INNER JOIN acl_role role ON mapping.acl_role_id = role.id
WHERE
  mapping.integration_id = ?

SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = 0x019BDBDBFF687DD18D259AB3D06F57CC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 390)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->fetchIntegrationPermissions (line 286)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 169)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
8	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.20 ms
(0.39%)

SELECT `id`, `privileges`
    FROM `acl_role`
    WHERE `id` IN (?)

Parameters:

[
  b"\x01œ×¶\x0EDq2N$NïD\x15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `id`,
  `privileges`
FROM
  `acl_role`
WHERE
  `id` IN (?)

SELECT `id`, `privileges`
    FROM `acl_role`
    WHERE `id` IN (0x019CD7B60E44718181324E244EEF4415);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 31)
3	Shopware\Core\Framework\Webhook\Service\WebhookLoader->getPrivilegesForRoles (line 328)
4	Shopware\Core\Framework\Webhook\Service\WebhookManager->loadPrivileges (line 110)
5	Shopware\Core\Framework\Webhook\Service\WebhookManager->callWebhooks (line 75)
6	Shopware\Core\Framework\Webhook\Service\WebhookManager->dispatch (line 34)
7	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
8	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 67)
9	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
10	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
11	Shopware\Core\Framework\Context->scope (line 72)
12	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
15	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
22	Shopware\Core\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 10)

0.19 ms
(0.37%)

SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 1173)
2	Doctrine\DBAL\Connection->createSavepoint (line 1063)
3	Doctrine\DBAL\Connection->beginTransaction (line 959)
4	Doctrine\DBAL\Connection->transactional (line 45)
5	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
6	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 74)
7	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\MultiInsertQueryQueue->execute (line 151)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands():150} (line 164)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->executeCommands (line 113)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->{closure:Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute():112} (line 964)
11	Doctrine\DBAL\Connection->transactional (line 45)
12	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
13	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
14	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
15	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
16	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
17	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
18	Shopware\Core\Framework\Context->scope (line 72)
19	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 10)

0.18 ms
(0.36%)

SELECT admin FROM `integration` WHERE id = ?

Parameters:

[
  b"\x01›ÛÛÿh}ÑŽ%š³ÐoWÌ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  admin
FROM
  `integration`
WHERE
  id = ?

SELECT admin FROM `integration` WHERE id = 0x019BDBDBFF687DD18D259AB3D06F57CC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 304)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->isAdminIntegration (line 285)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 169)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
8	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.17 ms
(0.34%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 959)
2	Doctrine\DBAL\Connection->transactional (line 45)
3	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 31)
4	Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 112)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway->execute (line 110)
6	Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter->sync (line 58)
7	Shopware\Core\Framework\Api\Sync\SyncService->sync (line 72)
8	Shopware\Core\Framework\Api\Controller\SyncController->{closure:Shopware\Core\Framework\Api\Controller\SyncController::sync():72} (line 201)
9	Shopware\Core\Framework\Context->scope (line 72)
10	Shopware\Core\Framework\Api\Controller\SyncController->sync (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
13	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
19	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
20	Shopware\Core\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 10)

Database Connections

Name	Service
0	default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

POST https://sw6staging.behr-labor.eu/api/_action/sync

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache