Symfony Profiler

Query Metrics

37 Database Queries

28 Different statements

177.53 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

51.88 ms
(29.23%)

SET @n = 0; SET @c = null;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  @n = 0;
SET
  @c = null;

SET @n = 0; SET @c = null;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 797)
2	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
10	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
11	Shopware\Core\Framework\Context->scope (line 265)
12	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
15	Symfony\Component\HttpKernel\Kernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
21	Shopware\Core\HttpKernel->doHandle (line 61)
22	Shopware\Core\HttpKernel->handle (line 78)
23	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 12)

15.09 ms
(8.50%)

SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE `seo_url`.`id` IN (?, ?, ?)

Parameters:

[
  b"\x15-´Ú´6O¿½+\x11WLDRò"
  b"¤s$Û`ØH.´÷ÏíåKóB"
  b"&¤ŒS±¨G¢¢'‘•QR¹º"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `seo_url`.`id` as `seo_url.id`,
  `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`,
  `seo_url`.`language_id` as `seo_url.languageId`,
  `seo_url`.`foreign_key` as `seo_url.foreignKey`,
  `seo_url`.`route_name` as `seo_url.routeName`,
  `seo_url`.`path_info` as `seo_url.pathInfo`,
  `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`,
  `seo_url`.`is_canonical` as `seo_url.isCanonical`,
  `seo_url`.`is_modified` as `seo_url.isModified`,
  `seo_url`.`is_deleted` as `seo_url.isDeleted`,
  `seo_url`.`custom_fields` as `seo_url.customFields`,
  `seo_url`.`created_at` as `seo_url.createdAt`,
  `seo_url`.`updated_at` as `seo_url.updatedAt`
FROM
  `seo_url`
WHERE
  `seo_url`.`id` IN (?, ?, ?)

SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE `seo_url`.`id` IN (0x152DB4DAB4364FBFBD2B11574C4452F2, 0xA47324DB60D8482EB4F7CFEDE54BF342, 0x26A48C53B1A847A2A22791955152B9BA);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 601)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithPagination (line 439)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1207)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
14	Shopware\Core\Framework\Context->scope (line 265)
15	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
18	Symfony\Component\HttpKernel\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
24	Shopware\Core\HttpKernel->doHandle (line 61)
25	Shopware\Core\HttpKernel->handle (line 78)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

11.73 ms
(6.61%)

# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = ?

Parameters:

[
  "cache-id"
]

View formatted query View runnable query Explain query View query backtrace

# cache-id-loader
SELECT
  `value`
FROM
  app_config
WHERE
  `key` = ?

# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = 'cache-id';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 619)
2	Doctrine\DBAL\Connection->fetchOne (line 30)
3	Shopware\Core\Framework\Adapter\Cache\CacheIdLoader->load (line 171)
4	Shopware\Core\HttpKernel->createKernel (line 111)
5	Shopware\Core\HttpKernel->doHandle (line 61)
6	Shopware\Core\HttpKernel->handle (line 78)
7	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 12)

11.61 ms
(6.54%)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_configurator_setting`.`product_id`, @n+1, IF(@c:=`product_configurator_setting`.`product_id`,1,1)) as id_count, `product_configurator_setting`.`product_id`, `product_configurator_setting`.id FROM `product_configurator_setting` WHERE (`product_configurator_setting`.`version_id` = ?) AND ((`product_configurator_setting`.`product_id` IN (?))) ORDER BY `product_configurator_setting`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?)

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
  1
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`product`.id)
  ) as id,
  LOWER(
    HEX(child.id)
  ) as child_id
FROM
  `product` `product`
  LEFT JOIN (
    SELECT
      @n := IF(
        @c = `product_configurator_setting`.`product_id`,
        @n + 1,
        IF(
          @c := `product_configurator_setting`.`product_id`,
          1, 1
        )
      ) as id_count,
      `product_configurator_setting`.`product_id`,
      `product_configurator_setting`.id
    FROM
      `product_configurator_setting`
    WHERE
      (
        `product_configurator_setting`.`version_id` = ?
      )
      AND (
        (
          `product_configurator_setting`.`product_id` IN (?)
        )
      )
    ORDER BY
      `product_configurator_setting`.`product_id` ASC
  ) child ON child.product_id = `product`.id
  AND id_count >= ?
  AND id_count <= ?
WHERE
  `product`.id IN (?)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_configurator_setting`.`product_id`, @n+1, IF(@c:=`product_configurator_setting`.`product_id`,1,1)) as id_count, `product_configurator_setting`.`product_id`, `product_configurator_setting`.id FROM `product_configurator_setting` WHERE (`product_configurator_setting`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_configurator_setting`.`product_id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7))) ORDER BY `product_configurator_setting`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0xC8F8771DFBB34312AD2AF64DE832E9B7);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 979)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchPaginatedOneToManyMapping (line 583)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithPagination (line 439)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1207)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
12	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
13	Shopware\Core\Framework\Context->scope (line 265)
14	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
17	Symfony\Component\HttpKernel\Kernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
23	Shopware\Core\HttpKernel->doHandle (line 61)
24	Shopware\Core\HttpKernel->handle (line 78)
25	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 12)

11.41 ms
(6.43%)

SELECT LOWER(HEX(`property_group_option.productOptions.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`property_group_option.productOptions.mapping`.`property_group_option_id`)) ) as `value` FROM `property_group_option` LEFT JOIN `product_option` `property_group_option.productOptions.mapping` ON `property_group_option`.`id` = `property_group_option.productOptions.mapping`.`property_group_option_id`  LEFT JOIN `product` `property_group_option.productOptions` ON `property_group_option.productOptions.mapping`.`product_id` = `property_group_option.productOptions`.`id`  INNER JOIN (SELECT @n:=IF(@c=`product_option`.`product_id`, @n+1, IF(@c:=`product_option`.`product_id`,1,1)) as id_count, `product_option`.`property_group_option_id`, `product_option`.`product_id` FROM `product_option` `product_option` ORDER BY `product_option`.`product_id` ASC) counter_table ON counter_table.`product_id` = `property_group_option.productOptions.mapping`.`product_id` AND
                     counter_table.`property_group_option_id` = `property_group_option.productOptions.mapping`.`property_group_option_id` AND
                     counter_table.id_count <= ? WHERE (`property_group_option.productOptions`.`id` IN (?)) GROUP BY `property_group_option.productOptions.mapping`.`product_id`

Parameters:

[
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(
      `property_group_option.productOptions.mapping`.`product_id`
    )
  ) as `key`,
  GROUP_CONCAT(
    LOWER(
      HEX(
        `property_group_option.productOptions.mapping`.`property_group_option_id`
      )
    )
  ) as `value`
FROM
  `property_group_option`
  LEFT JOIN `product_option` `property_group_option.productOptions.mapping` ON `property_group_option`.`id` = `property_group_option.productOptions.mapping`.`property_group_option_id`
  LEFT JOIN `product` `property_group_option.productOptions` ON `property_group_option.productOptions.mapping`.`product_id` = `property_group_option.productOptions`.`id`
  INNER JOIN (
    SELECT
      @n := IF(
        @c = `product_option`.`product_id`,
        @n + 1,
        IF(
          @c := `product_option`.`product_id`,
          1, 1
        )
      ) as id_count,
      `product_option`.`property_group_option_id`,
      `product_option`.`product_id`
    FROM
      `product_option` `product_option`
    ORDER BY
      `product_option`.`product_id` ASC
  ) counter_table ON counter_table.`product_id` = `property_group_option.productOptions.mapping`.`product_id`
  AND counter_table.`property_group_option_id` = `property_group_option.productOptions.mapping`.`property_group_option_id`
  AND counter_table.id_count <= ?
WHERE
  (
    `property_group_option.productOptions`.`id` IN (?)
  )
GROUP BY
  `property_group_option.productOptions.mapping`.`product_id`

SELECT LOWER(HEX(`property_group_option.productOptions.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`property_group_option.productOptions.mapping`.`property_group_option_id`)) ) as `value` FROM `property_group_option` LEFT JOIN `product_option` `property_group_option.productOptions.mapping` ON `property_group_option`.`id` = `property_group_option.productOptions.mapping`.`property_group_option_id`  LEFT JOIN `product` `property_group_option.productOptions` ON `property_group_option.productOptions.mapping`.`product_id` = `property_group_option.productOptions`.`id`  INNER JOIN (SELECT @n:=IF(@c=`product_option`.`product_id`, @n+1, IF(@c:=`product_option`.`product_id`,1,1)) as id_count, `product_option`.`property_group_option_id`, `product_option`.`product_id` FROM `product_option` `product_option` ORDER BY `product_option`.`product_id` ASC) counter_table ON counter_table.`product_id` = `property_group_option.productOptions.mapping`.`product_id` AND
                     counter_table.`property_group_option_id` = `property_group_option.productOptions.mapping`.`property_group_option_id` AND
                     counter_table.id_count <= 500 WHERE (`property_group_option.productOptions`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7)) GROUP BY `property_group_option.productOptions.mapping`.`product_id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 800)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
11	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
12	Shopware\Core\Framework\Context->scope (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
16	Symfony\Component\HttpKernel\Kernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
22	Shopware\Core\HttpKernel->doHandle (line 61)
23	Shopware\Core\HttpKernel->handle (line 78)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 12)

8.28 ms
(4.66%)

# 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 34)
2	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line 108)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 155)
4	Shopware\Core\Kernel->boot (line 112)
5	Shopware\Core\HttpKernel->doHandle (line 61)
6	Shopware\Core\HttpKernel->handle (line 78)
7	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 12)

6.21 ms
(3.50%)

SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN `product_property` `property_group_option.productProperties.mapping` ON `property_group_option`.`id` = `property_group_option.productProperties.mapping`.`property_group_option_id`  LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `product` `property_group_option.productProperties` ON `property_group_option.productProperties.mapping`.`product_id` = `property_group_option.productProperties`.`id`  AND `property_group_option.productProperties`.`version_id` = `property_group_option.productProperties.mapping`.`product_version_id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE (`property_group_option.productProperties`.`id` IN (?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `property_group_option`.`id` as `property_group_option.id`,
  `property_group_option`.`property_group_id` as `property_group_option.groupId`,
  `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`,
  `property_group_option`.`media_id` as `property_group_option.mediaId`,
  `property_group_option`.`created_at` as `property_group_option.createdAt`,
  `property_group_option`.`updated_at` as `property_group_option.updatedAt`,
  `property_group_option.group`.`id` as `property_group_option.group.id`,
  `property_group_option.group`.`display_type` as `property_group_option.group.displayType`,
  `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`,
  `property_group_option.group`.`filterable` as `property_group_option.group.filterable`,
  `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`,
  `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`,
  `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`,
  `property_group_option.group.translation.name`,
  COALESCE(
    `property_group_option.group.translation.name`,
    `property_group_option.group.translation.name`
  ) as `property_group_option.group.name`,
  `property_group_option.group.translation.description`,
  COALESCE(
    `property_group_option.group.translation.description`,
    `property_group_option.group.translation.description`
  ) as `property_group_option.group.description`,
  `property_group_option.group.translation.position`,
  COALESCE(
    `property_group_option.group.translation.position`,
    `property_group_option.group.translation.position`
  ) as `property_group_option.group.position`,
  `property_group_option.group.translation.customFields`,
  COALESCE(
    `property_group_option.group.translation.customFields`,
    `property_group_option.group.translation.customFields`
  ) as `property_group_option.group.customFields`,
  `property_group_option.group.translation.createdAt`,
  `property_group_option.group.translation.updatedAt`,
  `property_group_option.group.translation.propertyGroupId`,
  `property_group_option.group.translation.languageId`,
  `property_group_option.translation.name`,
  COALESCE(
    `property_group_option.translation.name`,
    `property_group_option.translation.name`
  ) as `property_group_option.name`,
  `property_group_option.translation.position`,
  COALESCE(
    `property_group_option.translation.position`,
    `property_group_option.translation.position`
  ) as `property_group_option.position`,
  `property_group_option.translation.customFields`,
  COALESCE(
    `property_group_option.translation.customFields`,
    `property_group_option.translation.customFields`
  ) as `property_group_option.customFields`,
  `property_group_option.translation.createdAt`,
  `property_group_option.translation.updatedAt`,
  `property_group_option.translation.propertyGroupOptionId`,
  `property_group_option.translation.languageId`
FROM
  `property_group_option`
  LEFT JOIN `product_property` `property_group_option.productProperties.mapping` ON `property_group_option`.`id` = `property_group_option.productProperties.mapping`.`property_group_option_id`
  LEFT JOIN (
    SELECT
      `property_group_option.translation`.property_group_option_id,
      `property_group_option.translation`.name as `property_group_option.translation.name`,
      `property_group_option.translation`.position as `property_group_option.translation.position`,
      `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`,
      `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`,
      `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`,
      `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`,
      `property_group_option.translation`.language_id as `property_group_option.translation.languageId`
    FROM
      `property_group_option_translation` `property_group_option.translation`
    WHERE
      `property_group_option.translation`.language_id = ?
  ) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id`
  LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id`
  LEFT JOIN `product` `property_group_option.productProperties` ON `property_group_option.productProperties.mapping`.`product_id` = `property_group_option.productProperties`.`id`
  AND `property_group_option.productProperties`.`version_id` = `property_group_option.productProperties.mapping`.`product_version_id`
  LEFT JOIN (
    SELECT
      `property_group_option.group.translation`.property_group_id,
      `property_group_option.group.translation`.name as `property_group_option.group.translation.name`,
      `property_group_option.group.translation`.description as `property_group_option.group.translation.description`,
      `property_group_option.group.translation`.position as `property_group_option.group.translation.position`,
      `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`,
      `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`,
      `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`,
      `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`,
      `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId`
    FROM
      `property_group_translation` `property_group_option.group.translation`
    WHERE
      `property_group_option.group.translation`.language_id = ?
  ) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id`
WHERE
  (
    `property_group_option.productProperties`.`id` IN (?)
  )

SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN `product_property` `property_group_option.productProperties.mapping` ON `property_group_option`.`id` = `property_group_option.productProperties.mapping`.`property_group_option_id`  LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `product` `property_group_option.productProperties` ON `property_group_option.productProperties.mapping`.`product_id` = `property_group_option.productProperties`.`id`  AND `property_group_option.productProperties`.`version_id` = `property_group_option.productProperties.mapping`.`product_version_id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE (`property_group_option.productProperties`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 816)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
14	Shopware\Core\Framework\Context->scope (line 265)
15	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
18	Symfony\Component\HttpKernel\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
24	Shopware\Core\HttpKernel->doHandle (line 61)
25	Shopware\Core\HttpKernel->handle (line 78)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

6.16 ms
(3.47%)

SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN `product_option` `property_group_option.productOptions.mapping` ON `property_group_option`.`id` = `property_group_option.productOptions.mapping`.`property_group_option_id`  LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `product` `property_group_option.productOptions` ON `property_group_option.productOptions.mapping`.`product_id` = `property_group_option.productOptions`.`id`  LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.productOptions`.`id` IN (?))) AND (`property_group_option`.`id` IN (?, ?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Èøw\x1Dû³C\x12*öMè2é·"
  b""näUZ¯B}®ˆê\x04Ø\x12î"
  b"J,\x1Cµ?žNK¥½S\x1EoÑ&6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `property_group_option`.`id` as `property_group_option.id`,
  `property_group_option`.`property_group_id` as `property_group_option.groupId`,
  `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`,
  `property_group_option`.`media_id` as `property_group_option.mediaId`,
  `property_group_option`.`created_at` as `property_group_option.createdAt`,
  `property_group_option`.`updated_at` as `property_group_option.updatedAt`,
  `property_group_option.group`.`id` as `property_group_option.group.id`,
  `property_group_option.group`.`display_type` as `property_group_option.group.displayType`,
  `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`,
  `property_group_option.group`.`filterable` as `property_group_option.group.filterable`,
  `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`,
  `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`,
  `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`,
  `property_group_option.group.translation.name`,
  COALESCE(
    `property_group_option.group.translation.name`,
    `property_group_option.group.translation.name`
  ) as `property_group_option.group.name`,
  `property_group_option.group.translation.description`,
  COALESCE(
    `property_group_option.group.translation.description`,
    `property_group_option.group.translation.description`
  ) as `property_group_option.group.description`,
  `property_group_option.group.translation.position`,
  COALESCE(
    `property_group_option.group.translation.position`,
    `property_group_option.group.translation.position`
  ) as `property_group_option.group.position`,
  `property_group_option.group.translation.customFields`,
  COALESCE(
    `property_group_option.group.translation.customFields`,
    `property_group_option.group.translation.customFields`
  ) as `property_group_option.group.customFields`,
  `property_group_option.group.translation.createdAt`,
  `property_group_option.group.translation.updatedAt`,
  `property_group_option.group.translation.propertyGroupId`,
  `property_group_option.group.translation.languageId`,
  `property_group_option.translation.name`,
  COALESCE(
    `property_group_option.translation.name`,
    `property_group_option.translation.name`
  ) as `property_group_option.name`,
  `property_group_option.translation.position`,
  COALESCE(
    `property_group_option.translation.position`,
    `property_group_option.translation.position`
  ) as `property_group_option.position`,
  `property_group_option.translation.customFields`,
  COALESCE(
    `property_group_option.translation.customFields`,
    `property_group_option.translation.customFields`
  ) as `property_group_option.customFields`,
  `property_group_option.translation.createdAt`,
  `property_group_option.translation.updatedAt`,
  `property_group_option.translation.propertyGroupOptionId`,
  `property_group_option.translation.languageId`
FROM
  `property_group_option`
  LEFT JOIN `product_option` `property_group_option.productOptions.mapping` ON `property_group_option`.`id` = `property_group_option.productOptions.mapping`.`property_group_option_id`
  LEFT JOIN (
    SELECT
      `property_group_option.translation`.property_group_option_id,
      `property_group_option.translation`.name as `property_group_option.translation.name`,
      `property_group_option.translation`.position as `property_group_option.translation.position`,
      `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`,
      `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`,
      `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`,
      `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`,
      `property_group_option.translation`.language_id as `property_group_option.translation.languageId`
    FROM
      `property_group_option_translation` `property_group_option.translation`
    WHERE
      `property_group_option.translation`.language_id = ?
  ) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id`
  LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id`
  LEFT JOIN `product` `property_group_option.productOptions` ON `property_group_option.productOptions.mapping`.`product_id` = `property_group_option.productOptions`.`id`
  LEFT JOIN (
    SELECT
      `property_group_option.group.translation`.property_group_id,
      `property_group_option.group.translation`.name as `property_group_option.group.translation.name`,
      `property_group_option.group.translation`.description as `property_group_option.group.translation.description`,
      `property_group_option.group.translation`.position as `property_group_option.group.translation.position`,
      `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`,
      `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`,
      `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`,
      `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`,
      `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId`
    FROM
      `property_group_translation` `property_group_option.group.translation`
    WHERE
      `property_group_option.group.translation`.language_id = ?
  ) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id`
WHERE
  (
    (
      `property_group_option.productOptions`.`id` IN (?)
    )
  )
  AND (
    `property_group_option`.`id` IN (?, ?)
  )

SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN `product_option` `property_group_option.productOptions.mapping` ON `property_group_option`.`id` = `property_group_option.productOptions.mapping`.`property_group_option_id`  LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `product` `property_group_option.productOptions` ON `property_group_option.productOptions.mapping`.`product_id` = `property_group_option.productOptions`.`id`  LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.productOptions`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7))) AND (`property_group_option`.`id` IN (0x226EE4555AAF427DAE88EA04ADD812EE, 0x4A2C1CB53F9E4E4BA5BD531E6FD12636));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 816)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
14	Shopware\Core\Framework\Context->scope (line 265)
15	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
18	Symfony\Component\HttpKernel\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
24	Shopware\Core\HttpKernel->doHandle (line 61)
25	Shopware\Core\HttpKernel->handle (line 78)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

5.65 ms
(3.18%)

SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, `product`.`product_manufacturer_id` as `product.manufacturerId`, `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, `product`.`unit_id` as `product.unitId`, `product`.`tax_id` as `product.taxId`, `product`.`product_media_id` as `product.coverId`, `product`.`product_media_version_id` as `product.productMediaVersionId`, `product`.`delivery_time_id` as `product.deliveryTimeId`, `product`.`product_feature_set_id` as `product.featureSetId`, `product`.`canonical_product_id` as `product.canonicalProductId`, `product`.`cms_page_id` as `product.cmsPageId`, `product`.`cms_page_version_id` as `product.cmsPageVersionId`, `product`.`price` as `product.price`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock`, `product`.`restock_time` as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, `product`.`active` as `product.active`, `product`.`available_stock` as `product.availableStock`, `product`.`available` as `product.available`, `product`.`is_closeout` as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product`.`variant_listing_config` as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, `product`.`manufacturer_number` as `product.manufacturerNumber`, `product`.`ean` as `product.ean`, `product`.`purchase_steps` as `product.purchaseSteps`, `product`.`max_purchase` as `product.maxPurchase`, `product`.`min_purchase` as `product.minPurchase`, `product`.`purchase_unit` as `product.purchaseUnit`, `product`.`reference_unit` as `product.referenceUnit`, `product`.`shipping_free` as `product.shippingFree`, `product`.`purchase_prices` as `product.purchasePrices`, `product`.`mark_as_topseller` as `product.markAsTopseller`, `product`.`weight` as `product.weight`, `product`.`width` as `product.width`, `product`.`height` as `product.height`, `product`.`length` as `product.length`, `product`.`release_date` as `product.releaseDate`, `product`.`rating_average` as `product.ratingAverage`, `product`.`category_tree` as `product.categoryTree`, `product`.`property_ids` as `product.propertyIds`, `product`.`option_ids` as `product.optionIds`, `product`.`stream_ids` as `product.streamIds`, `product`.`tag_ids` as `product.tagIds`, `product`.`category_ids` as `product.categoryIds`, `product`.`child_count` as `product.childCount`, `product`.`custom_field_set_selection_active` as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.productManufacturerVersionId`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) as `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, COALESCE(`product.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, COALESCE(`product.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, COALESCE(`product.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, COALESCE(`product.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.translation.updatedAt`, `product.translation.productId`, `product.translation.languageId`, `product.translation.productVersionId` FROM `product` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product`.`version_id` = `product.manufacturer`.`version_id` LEFT JOIN `product_media` `product.cover` ON `product`.`product_media_id` = `product.cover`.`id` AND `product`.`version_id` = `product.cover`.`version_id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `unit` `product.unit` ON `product`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name as `product.manufacturer.translation.name`, `product.manufacturer.translation`.description as `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields as `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at as `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at as `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id as `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id as `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id as `product.manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.language_id = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title as `product.cover.media.translation.title`, `product.cover.media.translation`.alt as `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields as `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at as `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at as `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id as `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id as `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at as `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at as `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id as `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id as `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code as `product.unit.translation.shortCode`, `product.unit.translation`.name as `product.unit.translation.name`, `product.unit.translation`.custom_fields as `product.unit.translation.customFields`, `product.unit.translation`.created_at as `product.unit.translation.createdAt`, `product.unit.translation`.updated_at as `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id as `product.unit.translation.unitId`, `product.unit.translation`.language_id as `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `product`.`id` as `product.id`,
  `product`.`version_id` as `product.versionId`,
  `product`.`parent_id` as `product.parentId`,
  `product`.`parent_version_id` as `product.parentVersionId`,
  `product`.`product_manufacturer_id` as `product.manufacturerId`,
  `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`,
  `product`.`unit_id` as `product.unitId`,
  `product`.`tax_id` as `product.taxId`,
  `product`.`product_media_id` as `product.coverId`,
  `product`.`product_media_version_id` as `product.productMediaVersionId`,
  `product`.`delivery_time_id` as `product.deliveryTimeId`,
  `product`.`product_feature_set_id` as `product.featureSetId`,
  `product`.`canonical_product_id` as `product.canonicalProductId`,
  `product`.`cms_page_id` as `product.cmsPageId`,
  `product`.`cms_page_version_id` as `product.cmsPageVersionId`,
  `product`.`price` as `product.price`,
  `product`.`product_number` as `product.productNumber`,
  `product`.`stock` as `product.stock`,
  `product`.`restock_time` as `product.restockTime`,
  `product`.`auto_increment` as `product.autoIncrement`,
  `product`.`active` as `product.active`,
  `product`.`available_stock` as `product.availableStock`,
  `product`.`available` as `product.available`,
  `product`.`is_closeout` as `product.isCloseout`,
  `product`.`display_group` as `product.displayGroup`,
  `product`.`variant_listing_config` as `product.variantListingConfig`,
  `product`.`variant_restrictions` as `product.variantRestrictions`,
  `product`.`manufacturer_number` as `product.manufacturerNumber`,
  `product`.`ean` as `product.ean`,
  `product`.`purchase_steps` as `product.purchaseSteps`,
  `product`.`max_purchase` as `product.maxPurchase`,
  `product`.`min_purchase` as `product.minPurchase`,
  `product`.`purchase_unit` as `product.purchaseUnit`,
  `product`.`reference_unit` as `product.referenceUnit`,
  `product`.`shipping_free` as `product.shippingFree`,
  `product`.`purchase_prices` as `product.purchasePrices`,
  `product`.`mark_as_topseller` as `product.markAsTopseller`,
  `product`.`weight` as `product.weight`,
  `product`.`width` as `product.width`,
  `product`.`height` as `product.height`,
  `product`.`length` as `product.length`,
  `product`.`release_date` as `product.releaseDate`,
  `product`.`rating_average` as `product.ratingAverage`,
  `product`.`category_tree` as `product.categoryTree`,
  `product`.`property_ids` as `product.propertyIds`,
  `product`.`option_ids` as `product.optionIds`,
  `product`.`stream_ids` as `product.streamIds`,
  `product`.`tag_ids` as `product.tagIds`,
  `product`.`category_ids` as `product.categoryIds`,
  `product`.`child_count` as `product.childCount`,
  `product`.`custom_field_set_selection_active` as `product.customFieldSetSelectionActive`,
  `product`.`sales` as `product.sales`,
  `product`.`states` as `product.states`,
  `product.tax`.`id` as `product.tax.id`,
  `product.tax`.`tax_rate` as `product.tax.taxRate`,
  `product.tax`.`name` as `product.tax.name`,
  `product.tax`.`position` as `product.tax.position`,
  `product.tax`.`custom_fields` as `product.tax.customFields`,
  `product.tax`.`created_at` as `product.tax.createdAt`,
  `product.tax`.`updated_at` as `product.tax.updatedAt`,
  `product`.`created_at` as `product.createdAt`,
  `product`.`updated_at` as `product.updatedAt`,
  `product.manufacturer`.`id` as `product.manufacturer.id`,
  `product.manufacturer`.`version_id` as `product.manufacturer.versionId`,
  `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`,
  `product.manufacturer`.`link` as `product.manufacturer.link`,
  `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`,
  `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`,
  `product.manufacturer.translation.name`,
  COALESCE(
    `product.manufacturer.translation.name`,
    `product.manufacturer.translation.name`
  ) as `product.manufacturer.name`,
  `product.manufacturer.translation.description`,
  COALESCE(
    `product.manufacturer.translation.description`,
    `product.manufacturer.translation.description`
  ) as `product.manufacturer.description`,
  `product.manufacturer.translation.customFields`,
  COALESCE(
    `product.manufacturer.translation.customFields`,
    `product.manufacturer.translation.customFields`
  ) as `product.manufacturer.customFields`,
  `product.manufacturer.translation.createdAt`,
  `product.manufacturer.translation.updatedAt`,
  `product.manufacturer.translation.productManufacturerId`,
  `product.manufacturer.translation.languageId`,
  `product.manufacturer.translation.productManufacturerVersionId`,
  `product.cover`.`id` as `product.cover.id`,
  `product.cover`.`version_id` as `product.cover.versionId`,
  `product.cover`.`product_id` as `product.cover.productId`,
  `product.cover`.`product_version_id` as `product.cover.productVersionId`,
  `product.cover`.`media_id` as `product.cover.mediaId`,
  `product.cover`.`position` as `product.cover.position`,
  `product.cover.media`.`id` as `product.cover.media.id`,
  `product.cover.media`.`user_id` as `product.cover.media.userId`,
  `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`,
  `product.cover.media`.`mime_type` as `product.cover.media.mimeType`,
  `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`,
  `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`,
  `product.cover.media`.`file_name` as `product.cover.media.fileName`,
  `product.cover.media`.`file_size` as `product.cover.media.fileSize`,
  `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`,
  `product.cover.media`.`meta_data` as `product.cover.media.metaData`,
  `product.cover.media`.`private` as `product.cover.media.private`,
  `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`,
  `product.cover.media`.`created_at` as `product.cover.media.createdAt`,
  `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`,
  `product.cover.media.translation.title`,
  COALESCE(
    `product.cover.media.translation.title`,
    `product.cover.media.translation.title`
  ) as `product.cover.media.title`,
  `product.cover.media.translation.alt`,
  COALESCE(
    `product.cover.media.translation.alt`,
    `product.cover.media.translation.alt`
  ) as `product.cover.media.alt`,
  `product.cover.media.translation.customFields`,
  COALESCE(
    `product.cover.media.translation.customFields`,
    `product.cover.media.translation.customFields`
  ) as `product.cover.media.customFields`,
  `product.cover.media.translation.createdAt`,
  `product.cover.media.translation.updatedAt`,
  `product.cover.media.translation.mediaId`,
  `product.cover.media.translation.languageId`,
  `product.cover`.`custom_fields` as `product.cover.customFields`,
  `product.cover`.`created_at` as `product.cover.createdAt`,
  `product.cover`.`updated_at` as `product.cover.updatedAt`,
  `product.deliveryTime`.`id` as `product.deliveryTime.id`,
  `product.deliveryTime`.`min` as `product.deliveryTime.min`,
  `product.deliveryTime`.`max` as `product.deliveryTime.max`,
  `product.deliveryTime`.`unit` as `product.deliveryTime.unit`,
  `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`,
  `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`,
  `product.deliveryTime.translation.name`,
  COALESCE(
    `product.deliveryTime.translation.name`,
    `product.deliveryTime.translation.name`
  ) as `product.deliveryTime.name`,
  `product.deliveryTime.translation.customFields`,
  COALESCE(
    `product.deliveryTime.translation.customFields`,
    `product.deliveryTime.translation.customFields`
  ) as `product.deliveryTime.customFields`,
  `product.deliveryTime.translation.createdAt`,
  `product.deliveryTime.translation.updatedAt`,
  `product.deliveryTime.translation.deliveryTimeId`,
  `product.deliveryTime.translation.languageId`,
  `product.unit`.`id` as `product.unit.id`,
  `product.unit`.`created_at` as `product.unit.createdAt`,
  `product.unit`.`updated_at` as `product.unit.updatedAt`,
  `product.unit.translation.shortCode`,
  COALESCE(
    `product.unit.translation.shortCode`,
    `product.unit.translation.shortCode`
  ) as `product.unit.shortCode`,
  `product.unit.translation.name`,
  COALESCE(
    `product.unit.translation.name`,
    `product.unit.translation.name`
  ) as `product.unit.name`,
  `product.unit.translation.customFields`,
  COALESCE(
    `product.unit.translation.customFields`,
    `product.unit.translation.customFields`
  ) as `product.unit.customFields`,
  `product.unit.translation.createdAt`,
  `product.unit.translation.updatedAt`,
  `product.unit.translation.unitId`,
  `product.unit.translation.languageId`,
  `product.translation.metaDescription`,
  COALESCE(
    `product.translation.metaDescription`,
    `product.translation.metaDescription`
  ) as `product.metaDescription`,
  `product.translation.name`,
  COALESCE(
    `product.translation.name`, `product.translation.name`
  ) as `product.name`,
  `product.translation.keywords`,
  COALESCE(
    `product.translation.keywords`,
    `product.translation.keywords`
  ) as `product.keywords`,
  `product.translation.description`,
  COALESCE(
    `product.translation.description`,
    `product.translation.description`
  ) as `product.description`,
  `product.translation.metaTitle`,
  COALESCE(
    `product.translation.metaTitle`,
    `product.translation.metaTitle`
  ) as `product.metaTitle`,
  `product.translation.packUnit`,
  COALESCE(
    `product.translation.packUnit`,
    `product.translation.packUnit`
  ) as `product.packUnit`,
  `product.translation.packUnitPlural`,
  COALESCE(
    `product.translation.packUnitPlural`,
    `product.translation.packUnitPlural`
  ) as `product.packUnitPlural`,
  `product.translation.customSearchKeywords`,
  COALESCE(
    `product.translation.customSearchKeywords`,
    `product.translation.customSearchKeywords`
  ) as `product.customSearchKeywords`,
  `product.translation.slotConfig`,
  COALESCE(
    `product.translation.slotConfig`,
    `product.translation.slotConfig`
  ) as `product.slotConfig`,
  `product.translation.customFields`,
  COALESCE(
    `product.translation.customFields`,
    `product.translation.customFields`
  ) as `product.customFields`,
  `product.translation.createdAt`,
  `product.translation.updatedAt`,
  `product.translation.productId`,
  `product.translation.languageId`,
  `product.translation.productVersionId`
FROM
  `product`
  LEFT JOIN (
    SELECT
      `product.translation`.product_id,
      `product.translation`.product_version_id,
      `product.translation`.meta_description as `product.translation.metaDescription`,
      `product.translation`.name as `product.translation.name`,
      `product.translation`.keywords as `product.translation.keywords`,
      `product.translation`.description as `product.translation.description`,
      `product.translation`.meta_title as `product.translation.metaTitle`,
      `product.translation`.pack_unit as `product.translation.packUnit`,
      `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`,
      `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`,
      `product.translation`.slot_config as `product.translation.slotConfig`,
      `product.translation`.custom_fields as `product.translation.customFields`,
      `product.translation`.created_at as `product.translation.createdAt`,
      `product.translation`.updated_at as `product.translation.updatedAt`,
      `product.translation`.product_id as `product.translation.productId`,
      `product.translation`.language_id as `product.translation.languageId`,
      `product.translation`.product_version_id as `product.translation.productVersionId`
    FROM
      `product_translation` `product.translation`
    WHERE
      `product.translation`.language_id = ?
  ) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id`
  AND `product.product_translation`.product_version_id = `product`.version_id
  LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id`
  LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`product_manufacturer_id` = `product.manufacturer`.`id`
  AND `product`.`version_id` = `product.manufacturer`.`version_id`
  LEFT JOIN `product_media` `product.cover` ON `product`.`product_media_id` = `product.cover`.`id`
  AND `product`.`version_id` = `product.cover`.`version_id`
  LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`delivery_time_id` = `product.deliveryTime`.`id`
  LEFT JOIN `unit` `product.unit` ON `product`.`unit_id` = `product.unit`.`id`
  LEFT JOIN (
    SELECT
      `product.manufacturer.translation`.product_manufacturer_id,
      `product.manufacturer.translation`.product_manufacturer_version_id,
      `product.manufacturer.translation`.name as `product.manufacturer.translation.name`,
      `product.manufacturer.translation`.description as `product.manufacturer.translation.description`,
      `product.manufacturer.translation`.custom_fields as `product.manufacturer.translation.customFields`,
      `product.manufacturer.translation`.created_at as `product.manufacturer.translation.createdAt`,
      `product.manufacturer.translation`.updated_at as `product.manufacturer.translation.updatedAt`,
      `product.manufacturer.translation`.product_manufacturer_id as `product.manufacturer.translation.productManufacturerId`,
      `product.manufacturer.translation`.language_id as `product.manufacturer.translation.languageId`,
      `product.manufacturer.translation`.product_manufacturer_version_id as `product.manufacturer.translation.productManufacturerVersionId`
    FROM
      `product_manufacturer_translation` `product.manufacturer.translation`
    WHERE
      `product.manufacturer.translation`.language_id = ?
  ) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id`
  AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id
  LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id`
  LEFT JOIN (
    SELECT
      `product.cover.media.translation`.media_id,
      `product.cover.media.translation`.title as `product.cover.media.translation.title`,
      `product.cover.media.translation`.alt as `product.cover.media.translation.alt`,
      `product.cover.media.translation`.custom_fields as `product.cover.media.translation.customFields`,
      `product.cover.media.translation`.created_at as `product.cover.media.translation.createdAt`,
      `product.cover.media.translation`.updated_at as `product.cover.media.translation.updatedAt`,
      `product.cover.media.translation`.media_id as `product.cover.media.translation.mediaId`,
      `product.cover.media.translation`.language_id as `product.cover.media.translation.languageId`
    FROM
      `media_translation` `product.cover.media.translation`
    WHERE
      `product.cover.media.translation`.language_id = ?
  ) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id`
  LEFT JOIN (
    SELECT
      `product.deliveryTime.translation`.delivery_time_id,
      `product.deliveryTime.translation`.name as `product.deliveryTime.translation.name`,
      `product.deliveryTime.translation`.custom_fields as `product.deliveryTime.translation.customFields`,
      `product.deliveryTime.translation`.created_at as `product.deliveryTime.translation.createdAt`,
      `product.deliveryTime.translation`.updated_at as `product.deliveryTime.translation.updatedAt`,
      `product.deliveryTime.translation`.delivery_time_id as `product.deliveryTime.translation.deliveryTimeId`,
      `product.deliveryTime.translation`.language_id as `product.deliveryTime.translation.languageId`
    FROM
      `delivery_time_translation` `product.deliveryTime.translation`
    WHERE
      `product.deliveryTime.translation`.language_id = ?
  ) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id`
  LEFT JOIN (
    SELECT
      `product.unit.translation`.unit_id,
      `product.unit.translation`.short_code as `product.unit.translation.shortCode`,
      `product.unit.translation`.name as `product.unit.translation.name`,
      `product.unit.translation`.custom_fields as `product.unit.translation.customFields`,
      `product.unit.translation`.created_at as `product.unit.translation.createdAt`,
      `product.unit.translation`.updated_at as `product.unit.translation.updatedAt`,
      `product.unit.translation`.unit_id as `product.unit.translation.unitId`,
      `product.unit.translation`.language_id as `product.unit.translation.languageId`
    FROM
      `unit_translation` `product.unit.translation`
    WHERE
      `product.unit.translation`.language_id = ?
  ) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    `product`.`id` IN (?)
  )

SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, `product`.`product_manufacturer_id` as `product.manufacturerId`, `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, `product`.`unit_id` as `product.unitId`, `product`.`tax_id` as `product.taxId`, `product`.`product_media_id` as `product.coverId`, `product`.`product_media_version_id` as `product.productMediaVersionId`, `product`.`delivery_time_id` as `product.deliveryTimeId`, `product`.`product_feature_set_id` as `product.featureSetId`, `product`.`canonical_product_id` as `product.canonicalProductId`, `product`.`cms_page_id` as `product.cmsPageId`, `product`.`cms_page_version_id` as `product.cmsPageVersionId`, `product`.`price` as `product.price`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock`, `product`.`restock_time` as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, `product`.`active` as `product.active`, `product`.`available_stock` as `product.availableStock`, `product`.`available` as `product.available`, `product`.`is_closeout` as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product`.`variant_listing_config` as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, `product`.`manufacturer_number` as `product.manufacturerNumber`, `product`.`ean` as `product.ean`, `product`.`purchase_steps` as `product.purchaseSteps`, `product`.`max_purchase` as `product.maxPurchase`, `product`.`min_purchase` as `product.minPurchase`, `product`.`purchase_unit` as `product.purchaseUnit`, `product`.`reference_unit` as `product.referenceUnit`, `product`.`shipping_free` as `product.shippingFree`, `product`.`purchase_prices` as `product.purchasePrices`, `product`.`mark_as_topseller` as `product.markAsTopseller`, `product`.`weight` as `product.weight`, `product`.`width` as `product.width`, `product`.`height` as `product.height`, `product`.`length` as `product.length`, `product`.`release_date` as `product.releaseDate`, `product`.`rating_average` as `product.ratingAverage`, `product`.`category_tree` as `product.categoryTree`, `product`.`property_ids` as `product.propertyIds`, `product`.`option_ids` as `product.optionIds`, `product`.`stream_ids` as `product.streamIds`, `product`.`tag_ids` as `product.tagIds`, `product`.`category_ids` as `product.categoryIds`, `product`.`child_count` as `product.childCount`, `product`.`custom_field_set_selection_active` as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.productManufacturerVersionId`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) as `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, COALESCE(`product.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, COALESCE(`product.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, COALESCE(`product.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, COALESCE(`product.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.translation.updatedAt`, `product.translation.productId`, `product.translation.languageId`, `product.translation.productVersionId` FROM `product` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product`.`version_id` = `product.manufacturer`.`version_id` LEFT JOIN `product_media` `product.cover` ON `product`.`product_media_id` = `product.cover`.`id` AND `product`.`version_id` = `product.cover`.`version_id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `unit` `product.unit` ON `product`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name as `product.manufacturer.translation.name`, `product.manufacturer.translation`.description as `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields as `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at as `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at as `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id as `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id as `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id as `product.manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title as `product.cover.media.translation.title`, `product.cover.media.translation`.alt as `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields as `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at as `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at as `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id as `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id as `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at as `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at as `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id as `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id as `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code as `product.unit.translation.shortCode`, `product.unit.translation`.name as `product.unit.translation.name`, `product.unit.translation`.custom_fields as `product.unit.translation.customFields`, `product.unit.translation`.created_at as `product.unit.translation.createdAt`, `product.unit.translation`.updated_at as `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id as `product.unit.translation.unitId`, `product.unit.translation`.language_id as `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
9	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
10	Shopware\Core\Framework\Context->scope (line 265)
11	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
14	Symfony\Component\HttpKernel\Kernel->handle (line 86)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
20	Shopware\Core\HttpKernel->doHandle (line 61)
21	Shopware\Core\HttpKernel->handle (line 78)
22	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 12)

5.00 ms
(2.82%)

SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN `product_category` `category.products.mapping` ON `category`.`id` = `category.products.mapping`.`category_id`  AND `category`.`version_id` = `category.products.mapping`.`category_version_id` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `product` `category.products` ON `category.products.mapping`.`product_id` = `category.products`.`id`  AND `category.products`.`version_id` = `category.products.mapping`.`product_version_id` WHERE (`category`.`version_id` = ?) AND ((`category.products`.`id` IN (?)))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.translation.name`,
  COALESCE(
    `category.translation.name`, `category.translation.name`
  ) as `category.name`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.breadcrumb`,
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.slotConfig`,
    `category.translation.slotConfig`
  ) as `category.slotConfig`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.linkType`,
    `category.translation.linkType`
  ) as `category.linkType`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.internalLink`,
    `category.translation.internalLink`
  ) as `category.internalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.externalLink`,
    `category.translation.externalLink`
  ) as `category.externalLink`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.linkNewTab`,
    `category.translation.linkNewTab`
  ) as `category.linkNewTab`,
  `category.translation.description`,
  COALESCE(
    `category.translation.description`,
    `category.translation.description`
  ) as `category.description`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.metaTitle`,
    `category.translation.metaTitle`
  ) as `category.metaTitle`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.metaDescription`,
    `category.translation.metaDescription`
  ) as `category.metaDescription`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.keywords`,
    `category.translation.keywords`
  ) as `category.keywords`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.customFields`,
    `category.translation.customFields`
  ) as `category.customFields`,
  `category.translation.createdAt`,
  `category.translation.updatedAt`,
  `category.translation.categoryId`,
  `category.translation.languageId`,
  `category.translation.categoryVersionId`
FROM
  `category`
  LEFT JOIN `product_category` `category.products.mapping` ON `category`.`id` = `category.products.mapping`.`category_id`
  AND `category`.`version_id` = `category.products.mapping`.`category_version_id`
  LEFT JOIN (
    SELECT
      `category.translation`.category_id,
      `category.translation`.category_version_id,
      `category.translation`.name as `category.translation.name`,
      `category.translation`.breadcrumb as `category.translation.breadcrumb`,
      `category.translation`.slot_config as `category.translation.slotConfig`,
      `category.translation`.link_type as `category.translation.linkType`,
      `category.translation`.internal_link as `category.translation.internalLink`,
      `category.translation`.external_link as `category.translation.externalLink`,
      `category.translation`.link_new_tab as `category.translation.linkNewTab`,
      `category.translation`.description as `category.translation.description`,
      `category.translation`.meta_title as `category.translation.metaTitle`,
      `category.translation`.meta_description as `category.translation.metaDescription`,
      `category.translation`.keywords as `category.translation.keywords`,
      `category.translation`.custom_fields as `category.translation.customFields`,
      `category.translation`.created_at as `category.translation.createdAt`,
      `category.translation`.updated_at as `category.translation.updatedAt`,
      `category.translation`.category_id as `category.translation.categoryId`,
      `category.translation`.language_id as `category.translation.languageId`,
      `category.translation`.category_version_id as `category.translation.categoryVersionId`
    FROM
      `category_translation` `category.translation`
    WHERE
      `category.translation`.language_id = ?
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id`
  AND `category.category_translation`.category_version_id = `category`.version_id
  LEFT JOIN `product` `category.products` ON `category.products.mapping`.`product_id` = `category.products`.`id`
  AND `category.products`.`version_id` = `category.products.mapping`.`product_version_id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      `category.products`.`id` IN (?)
    )
  )

SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN `product_category` `category.products.mapping` ON `category`.`id` = `category.products.mapping`.`category_id`  AND `category`.`version_id` = `category.products.mapping`.`category_version_id` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `product` `category.products` ON `category.products.mapping`.`product_id` = `category.products`.`id`  AND `category.products`.`version_id` = `category.products.mapping`.`product_version_id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category.products`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7)));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 816)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
14	Shopware\Core\Framework\Context->scope (line 265)
15	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
18	Symfony\Component\HttpKernel\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
24	Shopware\Core\HttpKernel->doHandle (line 61)
25	Shopware\Core\HttpKernel->handle (line 78)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

4.66 ms
(2.63%)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`seo_url`.`foreign_key`, @n+1, IF(@c:=`seo_url`.`foreign_key`,1,1)) as id_count, `seo_url`.`foreign_key`, `seo_url`.id FROM `seo_url` WHERE (`seo_url`.`foreign_key` IN (?)) ORDER BY `seo_url`.`foreign_key` ASC) child ON child.foreign_key = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?)

Parameters:

[
  b"Èøw\x1Dû³C\x12*öMè2é·"
  1
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`product`.id)
  ) as id,
  LOWER(
    HEX(child.id)
  ) as child_id
FROM
  `product` `product`
  LEFT JOIN (
    SELECT
      @n := IF(
        @c = `seo_url`.`foreign_key`,
        @n + 1,
        IF(
          @c := `seo_url`.`foreign_key`, 1, 1
        )
      ) as id_count,
      `seo_url`.`foreign_key`,
      `seo_url`.id
    FROM
      `seo_url`
    WHERE
      (
        `seo_url`.`foreign_key` IN (?)
      )
    ORDER BY
      `seo_url`.`foreign_key` ASC
  ) child ON child.foreign_key = `product`.id
  AND id_count >= ?
  AND id_count <= ?
WHERE
  `product`.id IN (?)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`seo_url`.`foreign_key`, @n+1, IF(@c:=`seo_url`.`foreign_key`,1,1)) as id_count, `seo_url`.`foreign_key`, `seo_url`.id FROM `seo_url` WHERE (`seo_url`.`foreign_key` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7)) ORDER BY `seo_url`.`foreign_key` ASC) child ON child.foreign_key = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0xC8F8771DFBB34312AD2AF64DE832E9B7);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 979)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchPaginatedOneToManyMapping (line 583)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithPagination (line 439)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1207)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
12	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
13	Shopware\Core\Framework\Context->scope (line 265)
14	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
17	Symfony\Component\HttpKernel\Kernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
23	Shopware\Core\HttpKernel->doHandle (line 61)
24	Shopware\Core\HttpKernel->handle (line 78)
25	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 12)

3.88 ms
(2.19%)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_visibility`.`product_id`, @n+1, IF(@c:=`product_visibility`.`product_id`,1,1)) as id_count, `product_visibility`.`product_id`, `product_visibility`.id FROM `product_visibility` WHERE (`product_visibility`.`product_id` IN (?)) ORDER BY `product_visibility`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?)

Parameters:

[
  b"Èøw\x1Dû³C\x12*öMè2é·"
  1
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`product`.id)
  ) as id,
  LOWER(
    HEX(child.id)
  ) as child_id
FROM
  `product` `product`
  LEFT JOIN (
    SELECT
      @n := IF(
        @c = `product_visibility`.`product_id`,
        @n + 1,
        IF(
          @c := `product_visibility`.`product_id`,
          1, 1
        )
      ) as id_count,
      `product_visibility`.`product_id`,
      `product_visibility`.id
    FROM
      `product_visibility`
    WHERE
      (
        `product_visibility`.`product_id` IN (?)
      )
    ORDER BY
      `product_visibility`.`product_id` ASC
  ) child ON child.product_id = `product`.id
  AND id_count >= ?
  AND id_count <= ?
WHERE
  `product`.id IN (?)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_visibility`.`product_id`, @n+1, IF(@c:=`product_visibility`.`product_id`,1,1)) as id_count, `product_visibility`.`product_id`, `product_visibility`.id FROM `product_visibility` WHERE (`product_visibility`.`product_id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7)) ORDER BY `product_visibility`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0xC8F8771DFBB34312AD2AF64DE832E9B7);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 979)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchPaginatedOneToManyMapping (line 583)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithPagination (line 439)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1207)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
12	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
13	Shopware\Core\Framework\Context->scope (line 265)
14	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
17	Symfony\Component\HttpKernel\Kernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
23	Shopware\Core\HttpKernel->doHandle (line 61)
24	Shopware\Core\HttpKernel->handle (line 78)
25	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 12)

3.58 ms
(2.02%)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_media`.`product_id`, @n+1, IF(@c:=`product_media`.`product_id`,1,1)) as id_count, `product_media`.`product_id`, `product_media`.id FROM `product_media` WHERE (`product_media`.`version_id` = ?) AND ((`product_media`.`product_id` IN (?))) ORDER BY `product_media`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?)

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
  1
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`product`.id)
  ) as id,
  LOWER(
    HEX(child.id)
  ) as child_id
FROM
  `product` `product`
  LEFT JOIN (
    SELECT
      @n := IF(
        @c = `product_media`.`product_id`,
        @n + 1,
        IF(
          @c := `product_media`.`product_id`,
          1, 1
        )
      ) as id_count,
      `product_media`.`product_id`,
      `product_media`.id
    FROM
      `product_media`
    WHERE
      (`product_media`.`version_id` = ?)
      AND (
        (
          `product_media`.`product_id` IN (?)
        )
      )
    ORDER BY
      `product_media`.`product_id` ASC
  ) child ON child.product_id = `product`.id
  AND id_count >= ?
  AND id_count <= ?
WHERE
  `product`.id IN (?)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_media`.`product_id`, @n+1, IF(@c:=`product_media`.`product_id`,1,1)) as id_count, `product_media`.`product_id`, `product_media`.id FROM `product_media` WHERE (`product_media`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_media`.`product_id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7))) ORDER BY `product_media`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0xC8F8771DFBB34312AD2AF64DE832E9B7);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 979)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchPaginatedOneToManyMapping (line 583)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithPagination (line 439)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1207)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
12	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
13	Shopware\Core\Framework\Context->scope (line 265)
14	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
17	Symfony\Component\HttpKernel\Kernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
23	Shopware\Core\HttpKernel->doHandle (line 61)
24	Shopware\Core\HttpKernel->handle (line 78)
25	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 12)

3.43 ms
(1.93%)

SELECT LOWER(HEX(`property_group_option.productProperties.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`property_group_option.productProperties.mapping`.`property_group_option_id`)) ) as `value` FROM `property_group_option` LEFT JOIN `product_property` `property_group_option.productProperties.mapping` ON `property_group_option`.`id` = `property_group_option.productProperties.mapping`.`property_group_option_id`  LEFT JOIN `product` `property_group_option.productProperties` ON `property_group_option.productProperties.mapping`.`product_id` = `property_group_option.productProperties`.`id`  AND `property_group_option.productProperties`.`version_id` = `property_group_option.productProperties.mapping`.`product_version_id` INNER JOIN (SELECT @n:=IF(@c=`product_property`.`product_id`, @n+1, IF(@c:=`product_property`.`product_id`,1,1)) as id_count, `product_property`.`property_group_option_id`, `product_property`.`product_id` FROM `product_property` `product_property` ORDER BY `product_property`.`product_id` ASC) counter_table ON counter_table.`product_id` = `property_group_option.productProperties.mapping`.`product_id` AND
                     counter_table.`property_group_option_id` = `property_group_option.productProperties.mapping`.`property_group_option_id` AND
                     counter_table.id_count <= ? WHERE (`property_group_option.productProperties`.`id` IN (?)) GROUP BY `property_group_option.productProperties.mapping`.`product_id`

Parameters:

[
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(
      `property_group_option.productProperties.mapping`.`product_id`
    )
  ) as `key`,
  GROUP_CONCAT(
    LOWER(
      HEX(
        `property_group_option.productProperties.mapping`.`property_group_option_id`
      )
    )
  ) as `value`
FROM
  `property_group_option`
  LEFT JOIN `product_property` `property_group_option.productProperties.mapping` ON `property_group_option`.`id` = `property_group_option.productProperties.mapping`.`property_group_option_id`
  LEFT JOIN `product` `property_group_option.productProperties` ON `property_group_option.productProperties.mapping`.`product_id` = `property_group_option.productProperties`.`id`
  AND `property_group_option.productProperties`.`version_id` = `property_group_option.productProperties.mapping`.`product_version_id`
  INNER JOIN (
    SELECT
      @n := IF(
        @c = `product_property`.`product_id`,
        @n + 1,
        IF(
          @c := `product_property`.`product_id`,
          1, 1
        )
      ) as id_count,
      `product_property`.`property_group_option_id`,
      `product_property`.`product_id`
    FROM
      `product_property` `product_property`
    ORDER BY
      `product_property`.`product_id` ASC
  ) counter_table ON counter_table.`product_id` = `property_group_option.productProperties.mapping`.`product_id`
  AND counter_table.`property_group_option_id` = `property_group_option.productProperties.mapping`.`property_group_option_id`
  AND counter_table.id_count <= ?
WHERE
  (
    `property_group_option.productProperties`.`id` IN (?)
  )
GROUP BY
  `property_group_option.productProperties.mapping`.`product_id`

SELECT LOWER(HEX(`property_group_option.productProperties.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`property_group_option.productProperties.mapping`.`property_group_option_id`)) ) as `value` FROM `property_group_option` LEFT JOIN `product_property` `property_group_option.productProperties.mapping` ON `property_group_option`.`id` = `property_group_option.productProperties.mapping`.`property_group_option_id`  LEFT JOIN `product` `property_group_option.productProperties` ON `property_group_option.productProperties.mapping`.`product_id` = `property_group_option.productProperties`.`id`  AND `property_group_option.productProperties`.`version_id` = `property_group_option.productProperties.mapping`.`product_version_id` INNER JOIN (SELECT @n:=IF(@c=`product_property`.`product_id`, @n+1, IF(@c:=`product_property`.`product_id`,1,1)) as id_count, `product_property`.`property_group_option_id`, `product_property`.`product_id` FROM `product_property` `product_property` ORDER BY `product_property`.`product_id` ASC) counter_table ON counter_table.`product_id` = `property_group_option.productProperties.mapping`.`product_id` AND
                     counter_table.`property_group_option_id` = `property_group_option.productProperties.mapping`.`property_group_option_id` AND
                     counter_table.id_count <= 500 WHERE (`property_group_option.productProperties`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7)) GROUP BY `property_group_option.productProperties.mapping`.`product_id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 800)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
11	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
12	Shopware\Core\Framework\Context->scope (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
16	Symfony\Component\HttpKernel\Kernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
22	Shopware\Core\HttpKernel->doHandle (line 61)
23	Shopware\Core\HttpKernel->handle (line 78)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 12)

3.39 ms
(1.91%)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_price`.`product_id`, @n+1, IF(@c:=`product_price`.`product_id`,1,1)) as id_count, `product_price`.`product_id`, `product_price`.id FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?))) ORDER BY `product_price`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?)

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
  1
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`product`.id)
  ) as id,
  LOWER(
    HEX(child.id)
  ) as child_id
FROM
  `product` `product`
  LEFT JOIN (
    SELECT
      @n := IF(
        @c = `product_price`.`product_id`,
        @n + 1,
        IF(
          @c := `product_price`.`product_id`,
          1, 1
        )
      ) as id_count,
      `product_price`.`product_id`,
      `product_price`.id
    FROM
      `product_price`
    WHERE
      (`product_price`.`version_id` = ?)
      AND (
        (
          `product_price`.`product_id` IN (?)
        )
      )
    ORDER BY
      `product_price`.`product_id` ASC
  ) child ON child.product_id = `product`.id
  AND id_count >= ?
  AND id_count <= ?
WHERE
  `product`.id IN (?)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_price`.`product_id`, @n+1, IF(@c:=`product_price`.`product_id`,1,1)) as id_count, `product_price`.`product_id`, `product_price`.id FROM `product_price` WHERE (`product_price`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7))) ORDER BY `product_price`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0xC8F8771DFBB34312AD2AF64DE832E9B7);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 979)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchPaginatedOneToManyMapping (line 583)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithPagination (line 439)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1207)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
12	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
13	Shopware\Core\Framework\Context->scope (line 265)
14	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
17	Symfony\Component\HttpKernel\Kernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
23	Shopware\Core\HttpKernel->doHandle (line 61)
24	Shopware\Core\HttpKernel->handle (line 78)
25	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 12)

3.35 ms
(1.89%)

SELECT LOWER(HEX(`category.products.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`category.products.mapping`.`category_id`)) ) as `value` FROM `category` LEFT JOIN `product_category` `category.products.mapping` ON `category`.`id` = `category.products.mapping`.`category_id`  AND `category`.`version_id` = `category.products.mapping`.`category_version_id` LEFT JOIN `product` `category.products` ON `category.products.mapping`.`product_id` = `category.products`.`id`  AND `category.products`.`version_id` = `category.products.mapping`.`product_version_id` INNER JOIN (SELECT @n:=IF(@c=`product_category`.`product_id`, @n+1, IF(@c:=`product_category`.`product_id`,1,1)) as id_count, `product_category`.`category_id`, `product_category`.`product_id` FROM `product_category` `product_category` ORDER BY `product_category`.`product_id` ASC) counter_table ON counter_table.`product_id` = `category.products.mapping`.`product_id` AND
                     counter_table.`category_id` = `category.products.mapping`.`category_id` AND
                     counter_table.id_count <= ? WHERE (`category`.`version_id` = ?) AND ((`category.products`.`id` IN (?))) GROUP BY `category.products.mapping`.`product_id`

Parameters:

[
  500
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(
      `category.products.mapping`.`product_id`
    )
  ) as `key`,
  GROUP_CONCAT(
    LOWER(
      HEX(
        `category.products.mapping`.`category_id`
      )
    )
  ) as `value`
FROM
  `category`
  LEFT JOIN `product_category` `category.products.mapping` ON `category`.`id` = `category.products.mapping`.`category_id`
  AND `category`.`version_id` = `category.products.mapping`.`category_version_id`
  LEFT JOIN `product` `category.products` ON `category.products.mapping`.`product_id` = `category.products`.`id`
  AND `category.products`.`version_id` = `category.products.mapping`.`product_version_id`
  INNER JOIN (
    SELECT
      @n := IF(
        @c = `product_category`.`product_id`,
        @n + 1,
        IF(
          @c := `product_category`.`product_id`,
          1, 1
        )
      ) as id_count,
      `product_category`.`category_id`,
      `product_category`.`product_id`
    FROM
      `product_category` `product_category`
    ORDER BY
      `product_category`.`product_id` ASC
  ) counter_table ON counter_table.`product_id` = `category.products.mapping`.`product_id`
  AND counter_table.`category_id` = `category.products.mapping`.`category_id`
  AND counter_table.id_count <= ?
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      `category.products`.`id` IN (?)
    )
  )
GROUP BY
  `category.products.mapping`.`product_id`

SELECT LOWER(HEX(`category.products.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`category.products.mapping`.`category_id`)) ) as `value` FROM `category` LEFT JOIN `product_category` `category.products.mapping` ON `category`.`id` = `category.products.mapping`.`category_id`  AND `category`.`version_id` = `category.products.mapping`.`category_version_id` LEFT JOIN `product` `category.products` ON `category.products.mapping`.`product_id` = `category.products`.`id`  AND `category.products`.`version_id` = `category.products.mapping`.`product_version_id` INNER JOIN (SELECT @n:=IF(@c=`product_category`.`product_id`, @n+1, IF(@c:=`product_category`.`product_id`,1,1)) as id_count, `product_category`.`category_id`, `product_category`.`product_id` FROM `product_category` `product_category` ORDER BY `product_category`.`product_id` ASC) counter_table ON counter_table.`product_id` = `category.products.mapping`.`product_id` AND
                     counter_table.`category_id` = `category.products.mapping`.`category_id` AND
                     counter_table.id_count <= 500 WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category.products`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7))) GROUP BY `category.products.mapping`.`product_id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 800)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
11	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
12	Shopware\Core\Framework\Context->scope (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
16	Symfony\Component\HttpKernel\Kernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
22	Shopware\Core\HttpKernel->doHandle (line 61)
23	Shopware\Core\HttpKernel->handle (line 78)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 12)

2.95 ms
(1.66%)

SELECT `product_translation`.`meta_description` as `product_translation.metaDescription`, `product_translation`.`name` as `product_translation.name`, `product_translation`.`keywords` as `product_translation.keywords`, `product_translation`.`description` as `product_translation.description`, `product_translation`.`meta_title` as `product_translation.metaTitle`, `product_translation`.`pack_unit` as `product_translation.packUnit`, `product_translation`.`pack_unit_plural` as `product_translation.packUnitPlural`, `product_translation`.`custom_search_keywords` as `product_translation.customSearchKeywords`, `product_translation`.`slot_config` as `product_translation.slotConfig`, `product_translation`.`custom_fields` as `product_translation.customFields`, `product_translation`.`created_at` as `product_translation.createdAt`, `product_translation`.`updated_at` as `product_translation.updatedAt`, `product_translation`.`product_id` as `product_translation.productId`, `product_translation`.`language_id` as `product_translation.languageId`, `product_translation`.`product_version_id` as `product_translation.productVersionId` FROM `product_translation` WHERE (`product_translation`.`product_version_id` = ?) AND ((`product_translation`.`product_id` IN (?)))

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `product_translation`.`meta_description` as `product_translation.metaDescription`,
  `product_translation`.`name` as `product_translation.name`,
  `product_translation`.`keywords` as `product_translation.keywords`,
  `product_translation`.`description` as `product_translation.description`,
  `product_translation`.`meta_title` as `product_translation.metaTitle`,
  `product_translation`.`pack_unit` as `product_translation.packUnit`,
  `product_translation`.`pack_unit_plural` as `product_translation.packUnitPlural`,
  `product_translation`.`custom_search_keywords` as `product_translation.customSearchKeywords`,
  `product_translation`.`slot_config` as `product_translation.slotConfig`,
  `product_translation`.`custom_fields` as `product_translation.customFields`,
  `product_translation`.`created_at` as `product_translation.createdAt`,
  `product_translation`.`updated_at` as `product_translation.updatedAt`,
  `product_translation`.`product_id` as `product_translation.productId`,
  `product_translation`.`language_id` as `product_translation.languageId`,
  `product_translation`.`product_version_id` as `product_translation.productVersionId`
FROM
  `product_translation`
WHERE
  (
    `product_translation`.`product_version_id` = ?
  )
  AND (
    (
      `product_translation`.`product_id` IN (?)
    )
  )

SELECT `product_translation`.`meta_description` as `product_translation.metaDescription`, `product_translation`.`name` as `product_translation.name`, `product_translation`.`keywords` as `product_translation.keywords`, `product_translation`.`description` as `product_translation.description`, `product_translation`.`meta_title` as `product_translation.metaTitle`, `product_translation`.`pack_unit` as `product_translation.packUnit`, `product_translation`.`pack_unit_plural` as `product_translation.packUnitPlural`, `product_translation`.`custom_search_keywords` as `product_translation.customSearchKeywords`, `product_translation`.`slot_config` as `product_translation.slotConfig`, `product_translation`.`custom_fields` as `product_translation.customFields`, `product_translation`.`created_at` as `product_translation.createdAt`, `product_translation`.`updated_at` as `product_translation.updatedAt`, `product_translation`.`product_id` as `product_translation.productId`, `product_translation`.`language_id` as `product_translation.languageId`, `product_translation`.`product_version_id` as `product_translation.productVersionId` FROM `product_translation` WHERE (`product_translation`.`product_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_translation`.`product_id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7)));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 490)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 433)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1207)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
14	Shopware\Core\Framework\Context->scope (line 265)
15	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
18	Symfony\Component\HttpKernel\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
24	Shopware\Core\HttpKernel->doHandle (line 61)
25	Shopware\Core\HttpKernel->handle (line 78)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

2.23 ms
(1.26%)

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  configuration_key,
  configuration_value
FROM
  system_config
WHERE
  sales_channel_id IS NULL
ORDER BY
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 48)
3	Shopware\Core\System\SystemConfig\SystemConfigLoader->load (line 32)
4	Shopware\Core\System\SystemConfig\CachedSystemConfigLoader->Shopware\Core\System\SystemConfig\{closure} (line 70)
5	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
6	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 31)
7	Shopware\Core\System\SystemConfig\CachedSystemConfigLoader->load (line 31)
8	Shopware\Core\System\SystemConfig\MemoizedSystemConfigLoader->load (line 62)
9	Shopware\Core\System\SystemConfig\SystemConfigService->get (line 32)
10	Shopware\Core\Framework\Routing\CanonicalRedirectService->getRedirect (line 123)
11	Shopware\Core\HttpKernel->doHandle (line 61)
12	Shopware\Core\HttpKernel->handle (line 78)
13	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 12)

2.19 ms
(1.23%)

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` WHERE (`product`.`version_id` = ?) AND ((`product`.`id` = ?)) LIMIT 25

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `product`.`id`,
  `product`.`product_number`,
  `product`.`auto_increment`
FROM
  `product`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (`product`.`id` = ?)
  )
LIMIT
  25

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`id` = 0xC8F8771DFBB34312AD2AF64DE832E9B7)) LIMIT 25;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 96)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 38)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 74)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 229)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
8	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
9	Shopware\Core\Framework\Context->scope (line 265)
10	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
13	Symfony\Component\HttpKernel\Kernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
19	Shopware\Core\HttpKernel->doHandle (line 61)
20	Shopware\Core\HttpKernel->handle (line 78)
21	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 12)

2.14 ms
(1.21%)

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

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

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
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 899)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 35)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 59)
4	Shopware\Core\System\System->boot (line 170)
5	Shopware\Core\Kernel->boot (line 112)
6	Shopware\Core\HttpKernel->doHandle (line 61)
7	Shopware\Core\HttpKernel->handle (line 78)
8	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 12)

1.94 ms
(1.09%)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product`.`parent_id`, @n+1, IF(@c:=`product`.`parent_id`,1,1)) as id_count, `product`.`parent_id`, `product`.id FROM `product` WHERE (`product`.`version_id` = ?) AND ((`product`.`parent_id` IN (?))) ORDER BY `product`.`parent_id` ASC) child ON child.parent_id = `product`.id AND id_count >= ? AND id_count <= ? WHERE `product`.id IN (?)

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
  1
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`product`.id)
  ) as id,
  LOWER(
    HEX(child.id)
  ) as child_id
FROM
  `product` `product`
  LEFT JOIN (
    SELECT
      @n := IF(
        @c = `product`.`parent_id`,
        @n + 1,
        IF(@c := `product`.`parent_id`, 1, 1)
      ) as id_count,
      `product`.`parent_id`,
      `product`.id
    FROM
      `product`
    WHERE
      (`product`.`version_id` = ?)
      AND (
        (
          `product`.`parent_id` IN (?)
        )
      )
    ORDER BY
      `product`.`parent_id` ASC
  ) child ON child.parent_id = `product`.id
  AND id_count >= ?
  AND id_count <= ?
WHERE
  `product`.id IN (?)

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product`.`parent_id`, @n+1, IF(@c:=`product`.`parent_id`,1,1)) as id_count, `product`.`parent_id`, `product`.id FROM `product` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`parent_id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7))) ORDER BY `product`.`parent_id` ASC) child ON child.parent_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0xC8F8771DFBB34312AD2AF64DE832E9B7);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 979)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchPaginatedOneToManyMapping (line 583)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithPagination (line 439)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1207)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
12	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
13	Shopware\Core\Framework\Context->scope (line 265)
14	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
17	Symfony\Component\HttpKernel\Kernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
23	Shopware\Core\HttpKernel->doHandle (line 61)
24	Shopware\Core\HttpKernel->handle (line 78)
25	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 12)

1.89 ms
(1.07%)

SELECT LOWER(HEX(`tag.products.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`tag.products.mapping`.`tag_id`)) ) as `value` FROM `tag` LEFT JOIN `product_tag` `tag.products.mapping` ON `tag`.`id` = `tag.products.mapping`.`tag_id`  LEFT JOIN `product` `tag.products` ON `tag.products.mapping`.`product_id` = `tag.products`.`id`  AND `tag.products`.`version_id` = `tag.products.mapping`.`product_version_id` INNER JOIN (SELECT @n:=IF(@c=`product_tag`.`product_id`, @n+1, IF(@c:=`product_tag`.`product_id`,1,1)) as id_count, `product_tag`.`tag_id`, `product_tag`.`product_id` FROM `product_tag` `product_tag` ORDER BY `product_tag`.`product_id` ASC) counter_table ON counter_table.`product_id` = `tag.products.mapping`.`product_id` AND
                     counter_table.`tag_id` = `tag.products.mapping`.`tag_id` AND
                     counter_table.id_count <= ? WHERE (`tag.products`.`id` IN (?)) GROUP BY `tag.products.mapping`.`product_id`

Parameters:

[
  500
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(
      `tag.products.mapping`.`product_id`
    )
  ) as `key`,
  GROUP_CONCAT(
    LOWER(
      HEX(
        `tag.products.mapping`.`tag_id`
      )
    )
  ) as `value`
FROM
  `tag`
  LEFT JOIN `product_tag` `tag.products.mapping` ON `tag`.`id` = `tag.products.mapping`.`tag_id`
  LEFT JOIN `product` `tag.products` ON `tag.products.mapping`.`product_id` = `tag.products`.`id`
  AND `tag.products`.`version_id` = `tag.products.mapping`.`product_version_id`
  INNER JOIN (
    SELECT
      @n := IF(
        @c = `product_tag`.`product_id`,
        @n + 1,
        IF(
          @c := `product_tag`.`product_id`,
          1, 1
        )
      ) as id_count,
      `product_tag`.`tag_id`,
      `product_tag`.`product_id`
    FROM
      `product_tag` `product_tag`
    ORDER BY
      `product_tag`.`product_id` ASC
  ) counter_table ON counter_table.`product_id` = `tag.products.mapping`.`product_id`
  AND counter_table.`tag_id` = `tag.products.mapping`.`tag_id`
  AND counter_table.id_count <= ?
WHERE
  (
    `tag.products`.`id` IN (?)
  )
GROUP BY
  `tag.products.mapping`.`product_id`

SELECT LOWER(HEX(`tag.products.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`tag.products.mapping`.`tag_id`)) ) as `value` FROM `tag` LEFT JOIN `product_tag` `tag.products.mapping` ON `tag`.`id` = `tag.products.mapping`.`tag_id`  LEFT JOIN `product` `tag.products` ON `tag.products.mapping`.`product_id` = `tag.products`.`id`  AND `tag.products`.`version_id` = `tag.products.mapping`.`product_version_id` INNER JOIN (SELECT @n:=IF(@c=`product_tag`.`product_id`, @n+1, IF(@c:=`product_tag`.`product_id`,1,1)) as id_count, `product_tag`.`tag_id`, `product_tag`.`product_id` FROM `product_tag` `product_tag` ORDER BY `product_tag`.`product_id` ASC) counter_table ON counter_table.`product_id` = `tag.products.mapping`.`product_id` AND
                     counter_table.`tag_id` = `tag.products.mapping`.`tag_id` AND
                     counter_table.id_count <= 500 WHERE (`tag.products`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7)) GROUP BY `tag.products.mapping`.`product_id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 800)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
11	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
12	Shopware\Core\Framework\Context->scope (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
16	Symfony\Component\HttpKernel\Kernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
22	Shopware\Core\HttpKernel->doHandle (line 61)
23	Shopware\Core\HttpKernel->handle (line 78)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 12)

1.88 ms
(1.06%)

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 585)
2	Doctrine\DBAL\Connection->fetchAssociative (line 319)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getCashRounding (line 48)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 43)
5	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
6	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 44)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 54)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 151)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
16	Symfony\Component\HttpKernel\Kernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
22	Shopware\Core\HttpKernel->doHandle (line 61)
23	Shopware\Core\HttpKernel->handle (line 78)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 12)

1.76 ms
(0.99%)

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

Parameters:

[
  b"\x07╠e┤<±K4¿YJ\v+ü\t■"
]

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` = 0x07CC65B43CF14B34A8594A0B2B8109FE
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 619)
2	Doctrine\DBAL\Connection->fetchOne (line 342)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->fetchPermissionsIntegrationByApp (line 256)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getAdminApiSource (line 159)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 51)
6	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 43)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 44)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 54)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 127)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 151)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
18	Symfony\Component\HttpKernel\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
24	Shopware\Core\HttpKernel->doHandle (line 61)
25	Shopware\Core\HttpKernel->handle (line 78)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

1.50 ms
(0.84%)

SELECT id FROM integration WHERE access_key = ?

Parameters:

[
  "SWIAVXF4BWPBTEHTC0N2NWNCNA"
]

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 = 'SWIAVXF4BWPBTEHTC0N2NWNCNA';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 245)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getIntegrationIdByAccessKey (line 157)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 51)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 43)
6	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
7	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 44)
11	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 54)
12	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
13	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 127)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 151)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
17	Symfony\Component\HttpKernel\Kernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
23	Shopware\Core\HttpKernel->doHandle (line 61)
24	Shopware\Core\HttpKernel->handle (line 78)
25	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 12)

1.46 ms
(0.82%)

SELECT `tag`.`id` as `tag.id`, `tag`.`name` as `tag.name`, `tag`.`created_at` as `tag.createdAt`, `tag`.`updated_at` as `tag.updatedAt` FROM `tag` LEFT JOIN `product_tag` `tag.products.mapping` ON `tag`.`id` = `tag.products.mapping`.`tag_id`  LEFT JOIN `product` `tag.products` ON `tag.products.mapping`.`product_id` = `tag.products`.`id`  AND `tag.products`.`version_id` = `tag.products.mapping`.`product_version_id` WHERE (`tag.products`.`id` IN (?))

Parameters:

[
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `tag`.`id` as `tag.id`,
  `tag`.`name` as `tag.name`,
  `tag`.`created_at` as `tag.createdAt`,
  `tag`.`updated_at` as `tag.updatedAt`
FROM
  `tag`
  LEFT JOIN `product_tag` `tag.products.mapping` ON `tag`.`id` = `tag.products.mapping`.`tag_id`
  LEFT JOIN `product` `tag.products` ON `tag.products.mapping`.`product_id` = `tag.products`.`id`
  AND `tag.products`.`version_id` = `tag.products.mapping`.`product_version_id`
WHERE
  (
    `tag.products`.`id` IN (?)
  )

SELECT `tag`.`id` as `tag.id`, `tag`.`name` as `tag.name`, `tag`.`created_at` as `tag.createdAt`, `tag`.`updated_at` as `tag.updatedAt` FROM `tag` LEFT JOIN `product_tag` `tag.products.mapping` ON `tag`.`id` = `tag.products.mapping`.`tag_id`  LEFT JOIN `product` `tag.products` ON `tag.products.mapping`.`product_id` = `tag.products`.`id`  AND `tag.products`.`version_id` = `tag.products.mapping`.`product_version_id` WHERE (`tag.products`.`id` IN (0xC8F8771DFBB34312AD2AF64DE832E9B7));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 307)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 131)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 816)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToManyWithCriteria (line 332)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadManyToMany (line 1213)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 135)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 74)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 199)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
13	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
14	Shopware\Core\Framework\Context->scope (line 265)
15	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
18	Symfony\Component\HttpKernel\Kernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
24	Shopware\Core\HttpKernel->doHandle (line 61)
25	Shopware\Core\HttpKernel->handle (line 78)
26	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 12)

1.42 ms
(0.80%)

SELECT COUNT(*) FROM (SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` WHERE (`product`.`version_id` = ?) AND ((`product`.`id` = ?))) total

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"Èøw\x1Dû³C\x12*öMè2é·"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  (
    SELECT
      `product`.`id`,
      `product`.`product_number`,
      `product`.`auto_increment`
    FROM
      `product`
    WHERE
      (`product`.`version_id` = ?)
      AND (
        (`product`.`id` = ?)
      )
  ) total

SELECT COUNT(*) FROM (SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`id` = 0xC8F8771DFBB34312AD2AF64DE832E9B7))) total;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 173)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->getTotalCount (line 98)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 38)
5	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 74)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 229)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 50)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 265)
9	Shopware\Core\Framework\Api\Controller\ApiController->Shopware\Core\Framework\Api\Controller\{closure} (line 149)
10	Shopware\Core\Framework\Context->scope (line 265)
11	Shopware\Core\Framework\Api\Controller\ApiController->search (line 163)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
14	Symfony\Component\HttpKernel\Kernel->handle (line 86)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 464)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 264)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 278)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 204)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 139)
20	Shopware\Core\HttpKernel->doHandle (line 61)
21	Shopware\Core\HttpKernel->handle (line 78)
22	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 12)

0.84 ms
(0.47%)

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  @@group_concat_max_len = CAST(
    IF(
      @@group_concat_max_len > 320000, @@group_concat_max_len,
      320000
    ) AS UNSIGNED
  );
SET
  sql_mode =(
    SELECT
      REPLACE(
        @@sql_mode, 'ONLY_FULL_GROUP_BY',
        ''
      )
  )

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 353)
2	Shopware\Core\Kernel->initializeDatabaseConnectionVariables (line 173)
3	Shopware\Core\Kernel->boot (line 112)
4	Shopware\Core\HttpKernel->doHandle (line 61)
5	Shopware\Core\HttpKernel->handle (line 78)
6	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$62c7->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 12)

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://sw65.test.firebearstudio.com/api/search/product?q=%2Fapi%2Fsearch%2Fproduct

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache