Symfony Profiler

Query Metrics

11 Database Queries

11 Different statements

725.43 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

597.19 ms
(82.32%)

SELECT COUNT(*) FROM (SELECT `product_visibility`.`id` FROM `product_visibility` LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id` AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id` WHERE (`product_visibility`.`sales_channel_id` = ? AND (`product_visibility`.`visibility` >= ?) AND ((`product_visibility.product`.`created_at` >= ?) OR (`product_visibility.product`.`updated_at` >= ?) OR (`product_visibility`.`created_at` >= ?) OR (`product_visibility`.`updated_at` >= ?)))) total

Parameters:

[
  b"¤½mg\x16ÖA&½Ssª¾èÉ¯"
  0
  "2026-01-07"
  "2026-01-07"
  "2026-01-07"
  "2026-01-07"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  (
    SELECT
      `product_visibility`.`id`
    FROM
      `product_visibility`
      LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id`
      AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id`
    WHERE
      (
        `product_visibility`.`sales_channel_id` = ?
        AND (
          `product_visibility`.`visibility` >= ?
        )
        AND (
          (
            `product_visibility.product`.`created_at` >= ?
          )
          OR (
            `product_visibility.product`.`updated_at` >= ?
          )
          OR (
            `product_visibility`.`created_at` >= ?
          )
          OR (
            `product_visibility`.`updated_at` >= ?
          )
        )
      )
  ) total

SELECT COUNT(*) FROM (SELECT `product_visibility`.`id` FROM `product_visibility` LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id` AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id` WHERE (`product_visibility`.`sales_channel_id` = 0xA4BD6D6716D64126BD5373AABEE8C9AF AND (`product_visibility`.`visibility` >= 0) AND ((`product_visibility.product`.`created_at` >= '2026-01-07') OR (`product_visibility.product`.`updated_at` >= '2026-01-07') OR (`product_visibility`.`created_at` >= '2026-01-07') OR (`product_visibility`.`updated_at` >= '2026-01-07')))) total;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 175)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->getTotalCount (line 97)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 52)
5	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 301)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 83)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 240)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 264)
10	Shopware\Core\Framework\Api\Controller\ApiController->{closure:Shopware\Core\Framework\Api\Controller\ApiController::search():264} (line 201)
11	Shopware\Core\Framework\Context->scope (line 264)
12	Shopware\Core\Framework\Api\Controller\ApiController->search (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
15	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
22	Shopware\Core\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 10)

109.29 ms
(15.07%)

SELECT `product_visibility`.`id` FROM `product_visibility` LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id` AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id` WHERE (`product_visibility`.`sales_channel_id` = ? AND (`product_visibility`.`visibility` >= ?) AND ((`product_visibility.product`.`created_at` >= ?) OR (`product_visibility.product`.`updated_at` >= ?) OR (`product_visibility`.`created_at` >= ?) OR (`product_visibility`.`updated_at` >= ?))) LIMIT 500 OFFSET 19500

Parameters:

[
  b"¤½mg\x16ÖA&½Ssª¾èÉ¯"
  0
  "2026-01-07"
  "2026-01-07"
  "2026-01-07"
  "2026-01-07"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `product_visibility`.`id`
FROM
  `product_visibility`
  LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id`
  AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id`
WHERE
  (
    `product_visibility`.`sales_channel_id` = ?
    AND (
      `product_visibility`.`visibility` >= ?
    )
    AND (
      (
        `product_visibility.product`.`created_at` >= ?
      )
      OR (
        `product_visibility.product`.`updated_at` >= ?
      )
      OR (
        `product_visibility`.`created_at` >= ?
      )
      OR (
        `product_visibility`.`updated_at` >= ?
      )
    )
  )
LIMIT
  500
OFFSET
  19500

SELECT `product_visibility`.`id` FROM `product_visibility` LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id` AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id` WHERE (`product_visibility`.`sales_channel_id` = 0xA4BD6D6716D64126BD5373AABEE8C9AF AND (`product_visibility`.`visibility` >= 0) AND ((`product_visibility.product`.`created_at` >= '2026-01-07') OR (`product_visibility.product`.`updated_at` >= '2026-01-07') OR (`product_visibility`.`created_at` >= '2026-01-07') OR (`product_visibility`.`updated_at` >= '2026-01-07'))) LIMIT 500 OFFSET 19500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 52)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 301)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 83)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 264)
9	Shopware\Core\Framework\Api\Controller\ApiController->{closure:Shopware\Core\Framework\Api\Controller\ApiController::search():264} (line 201)
10	Shopware\Core\Framework\Context->scope (line 264)
11	Shopware\Core\Framework\Api\Controller\ApiController->search (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
14	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
21	Shopware\Core\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 10)

10.43 ms
(1.44%)

SELECT `product_visibility`.`id` as `product_visibility.id`, `product_visibility`.`product_id` as `product_visibility.productId`, `product_visibility`.`product_version_id` as `product_visibility.productVersionId`, `product_visibility`.`sales_channel_id` as `product_visibility.salesChannelId`, `product_visibility`.`visibility` as `product_visibility.visibility`, `product_visibility`.`created_at` as `product_visibility.createdAt`, `product_visibility`.`updated_at` as `product_visibility.updatedAt`, `product_visibility.product`.`id` as `product_visibility.product.id`, `product_visibility.product`.`version_id` as `product_visibility.product.versionId`, `product_visibility.product`.`parent_id` as `product_visibility.product.parentId`, `product_visibility.product`.`parent_version_id` as `product_visibility.product.parentVersionId`, `product_visibility.product`.`product_manufacturer_id` as `product_visibility.product.manufacturerId`, `product_visibility.product`.`product_manufacturer_version_id` as `product_visibility.product.productManufacturerVersionId`, `product_visibility.product`.`unit_id` as `product_visibility.product.unitId`, `product_visibility.product`.`tax_id` as `product_visibility.product.taxId`, `product_visibility.product`.`product_media_id` as `product_visibility.product.coverId`, `product_visibility.product`.`product_media_version_id` as `product_visibility.product.productMediaVersionId`, `product_visibility.product`.`delivery_time_id` as `product_visibility.product.deliveryTimeId`, `product_visibility.product`.`product_feature_set_id` as `product_visibility.product.featureSetId`, `product_visibility.product`.`canonical_product_id` as `product_visibility.product.canonicalProductId`, `product_visibility.product`.`canonical_product_version_id` as `product_visibility.product.canonicalProductVersionId`, `product_visibility.product`.`cms_page_id` as `product_visibility.product.cmsPageId`, `product_visibility.product`.`cms_page_version_id` as `product_visibility.product.cmsPageVersionId`, `product_visibility.product`.`price` as `product_visibility.product.price`, `product_visibility.product`.`product_number` as `product_visibility.product.productNumber`, `product_visibility.product`.`restock_time` as `product_visibility.product.restockTime`, `product_visibility.product`.`auto_increment` as `product_visibility.product.autoIncrement`, `product_visibility.product`.`active` as `product_visibility.product.active`, `product_visibility.product`.`available` as `product_visibility.product.available`, `product_visibility.product`.`is_closeout` as `product_visibility.product.isCloseout`, `product_visibility.product`.`available_stock` as `product_visibility.product.availableStock`, `product_visibility.product`.`stock` as `product_visibility.product.stock`, `product_visibility.product`.`display_group` as `product_visibility.product.displayGroup`, `product_visibility.product`.`variant_listing_config` as `product_visibility.product.variantListingConfig`, `product_visibility.product`.`variant_restrictions` as `product_visibility.product.variantRestrictions`, `product_visibility.product`.`manufacturer_number` as `product_visibility.product.manufacturerNumber`, `product_visibility.product`.`ean` as `product_visibility.product.ean`, `product_visibility.product`.`purchase_steps` as `product_visibility.product.purchaseSteps`, `product_visibility.product`.`max_purchase` as `product_visibility.product.maxPurchase`, `product_visibility.product`.`min_purchase` as `product_visibility.product.minPurchase`, `product_visibility.product`.`purchase_unit` as `product_visibility.product.purchaseUnit`, `product_visibility.product`.`reference_unit` as `product_visibility.product.referenceUnit`, `product_visibility.product`.`shipping_free` as `product_visibility.product.shippingFree`, `product_visibility.product`.`purchase_prices` as `product_visibility.product.purchasePrices`, `product_visibility.product`.`mark_as_topseller` as `product_visibility.product.markAsTopseller`, `product_visibility.product`.`weight` as `product_visibility.product.weight`, `product_visibility.product`.`width` as `product_visibility.product.width`, `product_visibility.product`.`height` as `product_visibility.product.height`, `product_visibility.product`.`length` as `product_visibility.product.length`, `product_visibility.product`.`release_date` as `product_visibility.product.releaseDate`, `product_visibility.product`.`rating_average` as `product_visibility.product.ratingAverage`, `product_visibility.product`.`category_tree` as `product_visibility.product.categoryTree`, `product_visibility.product`.`property_ids` as `product_visibility.product.propertyIds`, `product_visibility.product`.`option_ids` as `product_visibility.product.optionIds`, `product_visibility.product`.`stream_ids` as `product_visibility.product.streamIds`, `product_visibility.product`.`tag_ids` as `product_visibility.product.tagIds`, `product_visibility.product`.`category_ids` as `product_visibility.product.categoryIds`, `product_visibility.product`.`child_count` as `product_visibility.product.childCount`, `product_visibility.product`.`custom_field_set_selection_active` as `product_visibility.product.customFieldSetSelectionActive`, `product_visibility.product`.`sales` as `product_visibility.product.sales`, `product_visibility.product`.`states` as `product_visibility.product.states`, `product_visibility.product`.`created_at` as `product_visibility.product.createdAt`, `product_visibility.product`.`updated_at` as `product_visibility.product.updatedAt`, `product_visibility.product.translation.metaDescription`, `product_visibility.product.translation.metaDescription` as `product_visibility.product.metaDescription`, `product_visibility.product.translation.name`, `product_visibility.product.translation.name` as `product_visibility.product.name`, `product_visibility.product.translation.keywords`, `product_visibility.product.translation.keywords` as `product_visibility.product.keywords`, `product_visibility.product.translation.description`, `product_visibility.product.translation.description` as `product_visibility.product.description`, `product_visibility.product.translation.metaTitle`, `product_visibility.product.translation.metaTitle` as `product_visibility.product.metaTitle`, `product_visibility.product.translation.packUnit`, `product_visibility.product.translation.packUnit` as `product_visibility.product.packUnit`, `product_visibility.product.translation.packUnitPlural`, `product_visibility.product.translation.packUnitPlural` as `product_visibility.product.packUnitPlural`, `product_visibility.product.translation.customSearchKeywords`, `product_visibility.product.translation.customSearchKeywords` as `product_visibility.product.customSearchKeywords`, `product_visibility.product.translation.slotConfig`, `product_visibility.product.translation.slotConfig` as `product_visibility.product.slotConfig`, `product_visibility.product.translation.customFields`, `product_visibility.product.translation.customFields` as `product_visibility.product.customFields` FROM `product_visibility` LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id` AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id` LEFT JOIN (SELECT `product_visibility.product.translation`.`product_id`, `product_visibility.product.translation`.`product_version_id`, `product_visibility.product.translation`.`meta_description` as `product_visibility.product.translation.metaDescription`, `product_visibility.product.translation`.`name` as `product_visibility.product.translation.name`, `product_visibility.product.translation`.`keywords` as `product_visibility.product.translation.keywords`, `product_visibility.product.translation`.`description` as `product_visibility.product.translation.description`, `product_visibility.product.translation`.`meta_title` as `product_visibility.product.translation.metaTitle`, `product_visibility.product.translation`.`pack_unit` as `product_visibility.product.translation.packUnit`, `product_visibility.product.translation`.`pack_unit_plural` as `product_visibility.product.translation.packUnitPlural`, `product_visibility.product.translation`.`custom_fields` as `product_visibility.product.translation.customFields`, `product_visibility.product.translation`.`slot_config` as `product_visibility.product.translation.slotConfig`, `product_visibility.product.translation`.`custom_search_keywords` as `product_visibility.product.translation.customSearchKeywords` FROM `product_translation` `product_visibility.product.translation` WHERE `product_visibility.product.translation`.`language_id` = ?) `product_visibility.product.product_translation` ON `product_visibility.product.product_translation`.`product_id` = `product_visibility.product`.`id` AND `product_visibility.product.product_translation`.`product_version_id` = `product_visibility.product`.`version_id` WHERE `product_visibility`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "\x00\x00=*Z~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*]~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*_~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*a~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*b~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*c~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*d~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*g~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*h~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*i~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*m~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*s~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*t~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*v~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*x~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*{~~~~~~~~\x7F\x00\x03"
  "\x00\x00=*~~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*€~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*‚~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ƒ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*„~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*†~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*‡~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*‹~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Œ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*‘~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*›~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*œ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=* ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*¡~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*¥~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*¦~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*§~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ª~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*°~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*±~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*²~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*¶~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*·~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*º~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*»~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*½~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*¿~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Á~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Â~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ã~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Å~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ç~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*É~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ê~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Í~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ï~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ð~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ñ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ò~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ó~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ô~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ö~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*×~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ø~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ú~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Û~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ü~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*Ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*à~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*á~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*â~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ã~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ä~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*è~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*é~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ì~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*í~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*õ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ú~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ü~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=*þ~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x00~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x01~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x03~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x06~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x08~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\v~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\r~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x0E~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x0F~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x11~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x14~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x15~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\e~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x1D~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x1E~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+"~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+#~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+$~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+(~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+*~~~~~~~~\x7F\x00\x03"
  "\x00\x00=++~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+,~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+.~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+1~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+3~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+5~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+8~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+9~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+;~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+<~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+=~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+?~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+@~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+G~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+H~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+I~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+K~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+L~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+O~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+P~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+Q~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+R~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+T~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+U~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+V~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+W~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+X~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+Z~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+[~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+]~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+^~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+_~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+`~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+a~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+b~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+c~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+e~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+f~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+g~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+h~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+i~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+k~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+l~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+n~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+o~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+p~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+q~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+r~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+s~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+u~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+x~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+y~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+|~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+}~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+~~~~~~~~~\x7F\x00\x03"
  "\x00\x00=+\x7F~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+€~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+‚~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+ƒ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+„~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+…~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+†~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+‡~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+‰~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+Š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+‹~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+Œ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+Ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+‘~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+’~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+“~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+”~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+•~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+–~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+˜~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+™~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+ ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+¡~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+¢~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+¤~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+¦~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+§~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+ª~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+«~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+®~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+¯~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+°~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+Ã~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+Ó~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+ð~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+ñ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+ò~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+÷~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+ø~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=+ÿ~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,\x00~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,\x02~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,\x05~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,$~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,&~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,'~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,,~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,-~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,1~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,2~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,3~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,4~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,6~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,9~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,:~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,=~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,>~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,?~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,@~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,B~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,C~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,D~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,F~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,J~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,K~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,L~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,O~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,P~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,Q~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,S~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,T~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,U~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,V~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,W~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,X~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,Y~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,Z~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,[~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,\~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,z~~~~~~~~\x7F\x00\x03"
  "\x00\x00=,\x7F~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,’~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,”~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,–~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,—~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,™~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=, ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,¡~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,¢~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,£~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,¤~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,¥~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,¦~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,©~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ª~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,®~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,¯~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,±~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,²~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,¶~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,½~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,¾~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Á~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Å~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Æ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Ô~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Õ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Ö~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,×~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Ø~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Û~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,Þ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,â~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,æ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ç~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,è~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,é~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ê~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ë~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ì~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,í~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,î~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ï~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ð~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ñ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ò~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ó~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ô~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,õ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ö~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,÷~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ø~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ú~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,û~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ü~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,þ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=,ÿ~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x00~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x01~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x02~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x03~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x04~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x05~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x06~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x07~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x08~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\t~~~~~~~~\x7F\x00\x03"
  """
    \x00\x00=-\n
    ~~~~~~~~\x7F\x00\x03
    """
  "\x00\x00=-\v~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\f~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\r~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x0E~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x0F~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x10~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x11~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x12~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x13~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x14~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x15~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x16~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x17~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x18~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x19~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x1A~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\e~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x1C~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x1D~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x1E~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x1F~~~~~~~~\x7F\x00\x03"
  "\x00\x00=- ~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-!~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-"~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-#~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-$~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-%~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-&~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-'~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-(~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-)~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-*~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-+~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-0~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-4~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-5~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-6~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-7~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-8~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-9~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-:~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-=~~~~~~~~\x7F\x00\x03"
  "\x00\x00=->~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-?~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-@~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-A~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-F~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-G~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-M~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-P~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-Q~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-f~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-g~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-h~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-i~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-j~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-k~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-o~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-p~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-q~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-r~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-t~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-u~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-v~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-w~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-x~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-y~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-z~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-{~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-|~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-}~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-~~~~~~~~~\x7F\x00\x03"
  "\x00\x00=-\x7F~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-€~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-‚~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-ƒ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-„~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-…~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-†~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-‡~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-ˆ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-‰~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-‹~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Œ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-‘~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-’~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-“~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-”~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-•~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-–~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-—~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-˜~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-™~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-›~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-œ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ÿ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=- ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-¤~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-¥~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-¦~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-§~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-¬~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-±~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-´~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-µ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-·~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-¹~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-º~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-»~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-¼~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-½~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-¿~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-À~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ã~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Æ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ç~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ó~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ô~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Õ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ö~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-×~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ø~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ú~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Û~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ü~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-Þ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-ß~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-à~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-á~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-â~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-ã~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-ä~~~~~~~~\x7F\x00\x03"
  b"\x00\x00=-å~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.\x16~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.\x17~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.\x1E~~~~~~~~\x7F\x00\x03"
  "\x00\x00=. ~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.!~~~~~~~~\x7F\x00\x03"
  "\x00\x00=."~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.%~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.'~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.(~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.*~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.+~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.,~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.-~~~~~~~~\x7F\x00\x03"
  "\x00\x00=..~~~~~~~~\x7F\x00\x03"
  "\x00\x00=./~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.0~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.1~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.2~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.4~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.5~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.6~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.7~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.8~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.:~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.;~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.<~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.=~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.>~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.?~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.@~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.A~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.B~~~~~~~~\x7F\x00\x03"
  "\x00\x00=.C~~~~~~~~\x7F\x00\x03"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `product_visibility`.`id` as `product_visibility.id`,
  `product_visibility`.`product_id` as `product_visibility.productId`,
  `product_visibility`.`product_version_id` as `product_visibility.productVersionId`,
  `product_visibility`.`sales_channel_id` as `product_visibility.salesChannelId`,
  `product_visibility`.`visibility` as `product_visibility.visibility`,
  `product_visibility`.`created_at` as `product_visibility.createdAt`,
  `product_visibility`.`updated_at` as `product_visibility.updatedAt`,
  `product_visibility.product`.`id` as `product_visibility.product.id`,
  `product_visibility.product`.`version_id` as `product_visibility.product.versionId`,
  `product_visibility.product`.`parent_id` as `product_visibility.product.parentId`,
  `product_visibility.product`.`parent_version_id` as `product_visibility.product.parentVersionId`,
  `product_visibility.product`.`product_manufacturer_id` as `product_visibility.product.manufacturerId`,
  `product_visibility.product`.`product_manufacturer_version_id` as `product_visibility.product.productManufacturerVersionId`,
  `product_visibility.product`.`unit_id` as `product_visibility.product.unitId`,
  `product_visibility.product`.`tax_id` as `product_visibility.product.taxId`,
  `product_visibility.product`.`product_media_id` as `product_visibility.product.coverId`,
  `product_visibility.product`.`product_media_version_id` as `product_visibility.product.productMediaVersionId`,
  `product_visibility.product`.`delivery_time_id` as `product_visibility.product.deliveryTimeId`,
  `product_visibility.product`.`product_feature_set_id` as `product_visibility.product.featureSetId`,
  `product_visibility.product`.`canonical_product_id` as `product_visibility.product.canonicalProductId`,
  `product_visibility.product`.`canonical_product_version_id` as `product_visibility.product.canonicalProductVersionId`,
  `product_visibility.product`.`cms_page_id` as `product_visibility.product.cmsPageId`,
  `product_visibility.product`.`cms_page_version_id` as `product_visibility.product.cmsPageVersionId`,
  `product_visibility.product`.`price` as `product_visibility.product.price`,
  `product_visibility.product`.`product_number` as `product_visibility.product.productNumber`,
  `product_visibility.product`.`restock_time` as `product_visibility.product.restockTime`,
  `product_visibility.product`.`auto_increment` as `product_visibility.product.autoIncrement`,
  `product_visibility.product`.`active` as `product_visibility.product.active`,
  `product_visibility.product`.`available` as `product_visibility.product.available`,
  `product_visibility.product`.`is_closeout` as `product_visibility.product.isCloseout`,
  `product_visibility.product`.`available_stock` as `product_visibility.product.availableStock`,
  `product_visibility.product`.`stock` as `product_visibility.product.stock`,
  `product_visibility.product`.`display_group` as `product_visibility.product.displayGroup`,
  `product_visibility.product`.`variant_listing_config` as `product_visibility.product.variantListingConfig`,
  `product_visibility.product`.`variant_restrictions` as `product_visibility.product.variantRestrictions`,
  `product_visibility.product`.`manufacturer_number` as `product_visibility.product.manufacturerNumber`,
  `product_visibility.product`.`ean` as `product_visibility.product.ean`,
  `product_visibility.product`.`purchase_steps` as `product_visibility.product.purchaseSteps`,
  `product_visibility.product`.`max_purchase` as `product_visibility.product.maxPurchase`,
  `product_visibility.product`.`min_purchase` as `product_visibility.product.minPurchase`,
  `product_visibility.product`.`purchase_unit` as `product_visibility.product.purchaseUnit`,
  `product_visibility.product`.`reference_unit` as `product_visibility.product.referenceUnit`,
  `product_visibility.product`.`shipping_free` as `product_visibility.product.shippingFree`,
  `product_visibility.product`.`purchase_prices` as `product_visibility.product.purchasePrices`,
  `product_visibility.product`.`mark_as_topseller` as `product_visibility.product.markAsTopseller`,
  `product_visibility.product`.`weight` as `product_visibility.product.weight`,
  `product_visibility.product`.`width` as `product_visibility.product.width`,
  `product_visibility.product`.`height` as `product_visibility.product.height`,
  `product_visibility.product`.`length` as `product_visibility.product.length`,
  `product_visibility.product`.`release_date` as `product_visibility.product.releaseDate`,
  `product_visibility.product`.`rating_average` as `product_visibility.product.ratingAverage`,
  `product_visibility.product`.`category_tree` as `product_visibility.product.categoryTree`,
  `product_visibility.product`.`property_ids` as `product_visibility.product.propertyIds`,
  `product_visibility.product`.`option_ids` as `product_visibility.product.optionIds`,
  `product_visibility.product`.`stream_ids` as `product_visibility.product.streamIds`,
  `product_visibility.product`.`tag_ids` as `product_visibility.product.tagIds`,
  `product_visibility.product`.`category_ids` as `product_visibility.product.categoryIds`,
  `product_visibility.product`.`child_count` as `product_visibility.product.childCount`,
  `product_visibility.product`.`custom_field_set_selection_active` as `product_visibility.product.customFieldSetSelectionActive`,
  `product_visibility.product`.`sales` as `product_visibility.product.sales`,
  `product_visibility.product`.`states` as `product_visibility.product.states`,
  `product_visibility.product`.`created_at` as `product_visibility.product.createdAt`,
  `product_visibility.product`.`updated_at` as `product_visibility.product.updatedAt`,
  `product_visibility.product.translation.metaDescription`,
  `product_visibility.product.translation.metaDescription` as `product_visibility.product.metaDescription`,
  `product_visibility.product.translation.name`,
  `product_visibility.product.translation.name` as `product_visibility.product.name`,
  `product_visibility.product.translation.keywords`,
  `product_visibility.product.translation.keywords` as `product_visibility.product.keywords`,
  `product_visibility.product.translation.description`,
  `product_visibility.product.translation.description` as `product_visibility.product.description`,
  `product_visibility.product.translation.metaTitle`,
  `product_visibility.product.translation.metaTitle` as `product_visibility.product.metaTitle`,
  `product_visibility.product.translation.packUnit`,
  `product_visibility.product.translation.packUnit` as `product_visibility.product.packUnit`,
  `product_visibility.product.translation.packUnitPlural`,
  `product_visibility.product.translation.packUnitPlural` as `product_visibility.product.packUnitPlural`,
  `product_visibility.product.translation.customSearchKeywords`,
  `product_visibility.product.translation.customSearchKeywords` as `product_visibility.product.customSearchKeywords`,
  `product_visibility.product.translation.slotConfig`,
  `product_visibility.product.translation.slotConfig` as `product_visibility.product.slotConfig`,
  `product_visibility.product.translation.customFields`,
  `product_visibility.product.translation.customFields` as `product_visibility.product.customFields`
FROM
  `product_visibility`
  LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id`
  AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id`
  LEFT JOIN (
    SELECT
      `product_visibility.product.translation`.`product_id`,
      `product_visibility.product.translation`.`product_version_id`,
      `product_visibility.product.translation`.`meta_description` as `product_visibility.product.translation.metaDescription`,
      `product_visibility.product.translation`.`name` as `product_visibility.product.translation.name`,
      `product_visibility.product.translation`.`keywords` as `product_visibility.product.translation.keywords`,
      `product_visibility.product.translation`.`description` as `product_visibility.product.translation.description`,
      `product_visibility.product.translation`.`meta_title` as `product_visibility.product.translation.metaTitle`,
      `product_visibility.product.translation`.`pack_unit` as `product_visibility.product.translation.packUnit`,
      `product_visibility.product.translation`.`pack_unit_plural` as `product_visibility.product.translation.packUnitPlural`,
      `product_visibility.product.translation`.`custom_fields` as `product_visibility.product.translation.customFields`,
      `product_visibility.product.translation`.`slot_config` as `product_visibility.product.translation.slotConfig`,
      `product_visibility.product.translation`.`custom_search_keywords` as `product_visibility.product.translation.customSearchKeywords`
    FROM
      `product_translation` `product_visibility.product.translation`
    WHERE
      `product_visibility.product.translation`.`language_id` = ?
  ) `product_visibility.product.product_translation` ON `product_visibility.product.product_translation`.`product_id` = `product_visibility.product`.`id`
  AND `product_visibility.product.product_translation`.`product_version_id` = `product_visibility.product`.`version_id`
WHERE
  `product_visibility`.`id` IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

SELECT `product_visibility`.`id` as `product_visibility.id`, `product_visibility`.`product_id` as `product_visibility.productId`, `product_visibility`.`product_version_id` as `product_visibility.productVersionId`, `product_visibility`.`sales_channel_id` as `product_visibility.salesChannelId`, `product_visibility`.`visibility` as `product_visibility.visibility`, `product_visibility`.`created_at` as `product_visibility.createdAt`, `product_visibility`.`updated_at` as `product_visibility.updatedAt`, `product_visibility.product`.`id` as `product_visibility.product.id`, `product_visibility.product`.`version_id` as `product_visibility.product.versionId`, `product_visibility.product`.`parent_id` as `product_visibility.product.parentId`, `product_visibility.product`.`parent_version_id` as `product_visibility.product.parentVersionId`, `product_visibility.product`.`product_manufacturer_id` as `product_visibility.product.manufacturerId`, `product_visibility.product`.`product_manufacturer_version_id` as `product_visibility.product.productManufacturerVersionId`, `product_visibility.product`.`unit_id` as `product_visibility.product.unitId`, `product_visibility.product`.`tax_id` as `product_visibility.product.taxId`, `product_visibility.product`.`product_media_id` as `product_visibility.product.coverId`, `product_visibility.product`.`product_media_version_id` as `product_visibility.product.productMediaVersionId`, `product_visibility.product`.`delivery_time_id` as `product_visibility.product.deliveryTimeId`, `product_visibility.product`.`product_feature_set_id` as `product_visibility.product.featureSetId`, `product_visibility.product`.`canonical_product_id` as `product_visibility.product.canonicalProductId`, `product_visibility.product`.`canonical_product_version_id` as `product_visibility.product.canonicalProductVersionId`, `product_visibility.product`.`cms_page_id` as `product_visibility.product.cmsPageId`, `product_visibility.product`.`cms_page_version_id` as `product_visibility.product.cmsPageVersionId`, `product_visibility.product`.`price` as `product_visibility.product.price`, `product_visibility.product`.`product_number` as `product_visibility.product.productNumber`, `product_visibility.product`.`restock_time` as `product_visibility.product.restockTime`, `product_visibility.product`.`auto_increment` as `product_visibility.product.autoIncrement`, `product_visibility.product`.`active` as `product_visibility.product.active`, `product_visibility.product`.`available` as `product_visibility.product.available`, `product_visibility.product`.`is_closeout` as `product_visibility.product.isCloseout`, `product_visibility.product`.`available_stock` as `product_visibility.product.availableStock`, `product_visibility.product`.`stock` as `product_visibility.product.stock`, `product_visibility.product`.`display_group` as `product_visibility.product.displayGroup`, `product_visibility.product`.`variant_listing_config` as `product_visibility.product.variantListingConfig`, `product_visibility.product`.`variant_restrictions` as `product_visibility.product.variantRestrictions`, `product_visibility.product`.`manufacturer_number` as `product_visibility.product.manufacturerNumber`, `product_visibility.product`.`ean` as `product_visibility.product.ean`, `product_visibility.product`.`purchase_steps` as `product_visibility.product.purchaseSteps`, `product_visibility.product`.`max_purchase` as `product_visibility.product.maxPurchase`, `product_visibility.product`.`min_purchase` as `product_visibility.product.minPurchase`, `product_visibility.product`.`purchase_unit` as `product_visibility.product.purchaseUnit`, `product_visibility.product`.`reference_unit` as `product_visibility.product.referenceUnit`, `product_visibility.product`.`shipping_free` as `product_visibility.product.shippingFree`, `product_visibility.product`.`purchase_prices` as `product_visibility.product.purchasePrices`, `product_visibility.product`.`mark_as_topseller` as `product_visibility.product.markAsTopseller`, `product_visibility.product`.`weight` as `product_visibility.product.weight`, `product_visibility.product`.`width` as `product_visibility.product.width`, `product_visibility.product`.`height` as `product_visibility.product.height`, `product_visibility.product`.`length` as `product_visibility.product.length`, `product_visibility.product`.`release_date` as `product_visibility.product.releaseDate`, `product_visibility.product`.`rating_average` as `product_visibility.product.ratingAverage`, `product_visibility.product`.`category_tree` as `product_visibility.product.categoryTree`, `product_visibility.product`.`property_ids` as `product_visibility.product.propertyIds`, `product_visibility.product`.`option_ids` as `product_visibility.product.optionIds`, `product_visibility.product`.`stream_ids` as `product_visibility.product.streamIds`, `product_visibility.product`.`tag_ids` as `product_visibility.product.tagIds`, `product_visibility.product`.`category_ids` as `product_visibility.product.categoryIds`, `product_visibility.product`.`child_count` as `product_visibility.product.childCount`, `product_visibility.product`.`custom_field_set_selection_active` as `product_visibility.product.customFieldSetSelectionActive`, `product_visibility.product`.`sales` as `product_visibility.product.sales`, `product_visibility.product`.`states` as `product_visibility.product.states`, `product_visibility.product`.`created_at` as `product_visibility.product.createdAt`, `product_visibility.product`.`updated_at` as `product_visibility.product.updatedAt`, `product_visibility.product.translation.metaDescription`, `product_visibility.product.translation.metaDescription` as `product_visibility.product.metaDescription`, `product_visibility.product.translation.name`, `product_visibility.product.translation.name` as `product_visibility.product.name`, `product_visibility.product.translation.keywords`, `product_visibility.product.translation.keywords` as `product_visibility.product.keywords`, `product_visibility.product.translation.description`, `product_visibility.product.translation.description` as `product_visibility.product.description`, `product_visibility.product.translation.metaTitle`, `product_visibility.product.translation.metaTitle` as `product_visibility.product.metaTitle`, `product_visibility.product.translation.packUnit`, `product_visibility.product.translation.packUnit` as `product_visibility.product.packUnit`, `product_visibility.product.translation.packUnitPlural`, `product_visibility.product.translation.packUnitPlural` as `product_visibility.product.packUnitPlural`, `product_visibility.product.translation.customSearchKeywords`, `product_visibility.product.translation.customSearchKeywords` as `product_visibility.product.customSearchKeywords`, `product_visibility.product.translation.slotConfig`, `product_visibility.product.translation.slotConfig` as `product_visibility.product.slotConfig`, `product_visibility.product.translation.customFields`, `product_visibility.product.translation.customFields` as `product_visibility.product.customFields` FROM `product_visibility` LEFT JOIN `product` `product_visibility.product` ON `product_visibility`.`product_id` = `product_visibility.product`.`id` AND `product_visibility`.`product_version_id` = `product_visibility.product`.`version_id` LEFT JOIN (SELECT `product_visibility.product.translation`.`product_id`, `product_visibility.product.translation`.`product_version_id`, `product_visibility.product.translation`.`meta_description` as `product_visibility.product.translation.metaDescription`, `product_visibility.product.translation`.`name` as `product_visibility.product.translation.name`, `product_visibility.product.translation`.`keywords` as `product_visibility.product.translation.keywords`, `product_visibility.product.translation`.`description` as `product_visibility.product.translation.description`, `product_visibility.product.translation`.`meta_title` as `product_visibility.product.translation.metaTitle`, `product_visibility.product.translation`.`pack_unit` as `product_visibility.product.translation.packUnit`, `product_visibility.product.translation`.`pack_unit_plural` as `product_visibility.product.translation.packUnitPlural`, `product_visibility.product.translation`.`custom_fields` as `product_visibility.product.translation.customFields`, `product_visibility.product.translation`.`slot_config` as `product_visibility.product.translation.slotConfig`, `product_visibility.product.translation`.`custom_search_keywords` as `product_visibility.product.translation.customSearchKeywords` FROM `product_translation` `product_visibility.product.translation` WHERE `product_visibility.product.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_visibility.product.product_translation` ON `product_visibility.product.product_translation`.`product_id` = `product_visibility.product`.`id` AND `product_visibility.product.product_translation`.`product_version_id` = `product_visibility.product`.`version_id` WHERE `product_visibility`.`id` IN ('\0\0=*Z~~~~~~~~\0', '\0\0=*]~~~~~~~~\0', '\0\0=*_~~~~~~~~\0', '\0\0=*a~~~~~~~~\0', '\0\0=*b~~~~~~~~\0', '\0\0=*c~~~~~~~~\0', '\0\0=*d~~~~~~~~\0', '\0\0=*g~~~~~~~~\0', '\0\0=*h~~~~~~~~\0', '\0\0=*i~~~~~~~~\0', '\0\0=*m~~~~~~~~\0', '\0\0=*s~~~~~~~~\0', '\0\0=*t~~~~~~~~\0', '\0\0=*v~~~~~~~~\0', '\0\0=*x~~~~~~~~\0', '\0\0=*{~~~~~~~~\0', '\0\0=*~~~~~~~~~\0', 0x00003D2A807E7E7E7E7E7E7E7E7F0003, 0x00003D2A817E7E7E7E7E7E7E7E7F0003, 0x00003D2A827E7E7E7E7E7E7E7E7F0003, 0x00003D2A837E7E7E7E7E7E7E7E7F0003, 0x00003D2A847E7E7E7E7E7E7E7E7F0003, 0x00003D2A867E7E7E7E7E7E7E7E7F0003, 0x00003D2A877E7E7E7E7E7E7E7E7F0003, 0x00003D2A8A7E7E7E7E7E7E7E7E7F0003, 0x00003D2A8B7E7E7E7E7E7E7E7E7F0003, 0x00003D2A8C7E7E7E7E7E7E7E7E7F0003, 0x00003D2A917E7E7E7E7E7E7E7E7F0003, 0x00003D2A9A7E7E7E7E7E7E7E7E7F0003, 0x00003D2A9B7E7E7E7E7E7E7E7E7F0003, 0x00003D2A9C7E7E7E7E7E7E7E7E7F0003, 0x00003D2A9D7E7E7E7E7E7E7E7E7F0003, 0x00003D2A9E7E7E7E7E7E7E7E7E7F0003, 0x00003D2AA07E7E7E7E7E7E7E7E7F0003, 0x00003D2AA17E7E7E7E7E7E7E7E7F0003, 0x00003D2AA57E7E7E7E7E7E7E7E7F0003, 0x00003D2AA67E7E7E7E7E7E7E7E7F0003, 0x00003D2AA77E7E7E7E7E7E7E7E7F0003, 0x00003D2AAA7E7E7E7E7E7E7E7E7F0003, 0x00003D2AAD7E7E7E7E7E7E7E7E7F0003, 0x00003D2AB07E7E7E7E7E7E7E7E7F0003, 0x00003D2AB17E7E7E7E7E7E7E7E7F0003, 0x00003D2AB27E7E7E7E7E7E7E7E7F0003, 0x00003D2AB67E7E7E7E7E7E7E7E7F0003, 0x00003D2AB77E7E7E7E7E7E7E7E7F0003, 0x00003D2ABA7E7E7E7E7E7E7E7E7F0003, 0x00003D2ABB7E7E7E7E7E7E7E7E7F0003, 0x00003D2ABD7E7E7E7E7E7E7E7E7F0003, 0x00003D2ABF7E7E7E7E7E7E7E7E7F0003, 0x00003D2AC17E7E7E7E7E7E7E7E7F0003, 0x00003D2AC27E7E7E7E7E7E7E7E7F0003, 0x00003D2AC37E7E7E7E7E7E7E7E7F0003, 0x00003D2AC57E7E7E7E7E7E7E7E7F0003, 0x00003D2AC77E7E7E7E7E7E7E7E7F0003, 0x00003D2AC97E7E7E7E7E7E7E7E7F0003, 0x00003D2ACA7E7E7E7E7E7E7E7E7F0003, 0x00003D2ACD7E7E7E7E7E7E7E7E7F0003, 0x00003D2ACF7E7E7E7E7E7E7E7E7F0003, 0x00003D2AD07E7E7E7E7E7E7E7E7F0003, 0x00003D2AD17E7E7E7E7E7E7E7E7F0003, 0x00003D2AD27E7E7E7E7E7E7E7E7F0003, 0x00003D2AD37E7E7E7E7E7E7E7E7F0003, 0x00003D2AD47E7E7E7E7E7E7E7E7F0003, 0x00003D2AD67E7E7E7E7E7E7E7E7F0003, 0x00003D2AD77E7E7E7E7E7E7E7E7F0003, 0x00003D2AD87E7E7E7E7E7E7E7E7F0003, 0x00003D2AD97E7E7E7E7E7E7E7E7F0003, 0x00003D2ADA7E7E7E7E7E7E7E7E7F0003, 0x00003D2ADB7E7E7E7E7E7E7E7E7F0003, 0x00003D2ADC7E7E7E7E7E7E7E7E7F0003, 0x00003D2ADD7E7E7E7E7E7E7E7E7F0003, 0x00003D2AE07E7E7E7E7E7E7E7E7F0003, 0x00003D2AE17E7E7E7E7E7E7E7E7F0003, 0x00003D2AE27E7E7E7E7E7E7E7E7F0003, 0x00003D2AE37E7E7E7E7E7E7E7E7F0003, 0x00003D2AE47E7E7E7E7E7E7E7E7F0003, 0x00003D2AE87E7E7E7E7E7E7E7E7F0003, 0x00003D2AE97E7E7E7E7E7E7E7E7F0003, 0x00003D2AEC7E7E7E7E7E7E7E7E7F0003, 0x00003D2AED7E7E7E7E7E7E7E7E7F0003, 0x00003D2AF57E7E7E7E7E7E7E7E7F0003, 0x00003D2AFA7E7E7E7E7E7E7E7E7F0003, 0x00003D2AFC7E7E7E7E7E7E7E7E7F0003, 0x00003D2AFD7E7E7E7E7E7E7E7E7F0003, 0x00003D2AFE7E7E7E7E7E7E7E7E7F0003, '\0\0=+\0~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+
~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+~~~~~~~~\0', '\0\0=+\"~~~~~~~~\0', '\0\0=+#~~~~~~~~\0', '\0\0=+$~~~~~~~~\0', '\0\0=+(~~~~~~~~\0', '\0\0=+*~~~~~~~~\0', '\0\0=++~~~~~~~~\0', '\0\0=+,~~~~~~~~\0', '\0\0=+.~~~~~~~~\0', '\0\0=+1~~~~~~~~\0', '\0\0=+3~~~~~~~~\0', '\0\0=+5~~~~~~~~\0', '\0\0=+8~~~~~~~~\0', '\0\0=+9~~~~~~~~\0', '\0\0=+;~~~~~~~~\0', '\0\0=+<~~~~~~~~\0', '\0\0=+=~~~~~~~~\0', '\0\0=+?~~~~~~~~\0', '\0\0=+@~~~~~~~~\0', '\0\0=+G~~~~~~~~\0', '\0\0=+H~~~~~~~~\0', '\0\0=+I~~~~~~~~\0', '\0\0=+K~~~~~~~~\0', '\0\0=+L~~~~~~~~\0', '\0\0=+O~~~~~~~~\0', '\0\0=+P~~~~~~~~\0', '\0\0=+Q~~~~~~~~\0', '\0\0=+R~~~~~~~~\0', '\0\0=+T~~~~~~~~\0', '\0\0=+U~~~~~~~~\0', '\0\0=+V~~~~~~~~\0', '\0\0=+W~~~~~~~~\0', '\0\0=+X~~~~~~~~\0', '\0\0=+Z~~~~~~~~\0', '\0\0=+[~~~~~~~~\0', '\0\0=+\\~~~~~~~~\0', '\0\0=+]~~~~~~~~\0', '\0\0=+^~~~~~~~~\0', '\0\0=+_~~~~~~~~\0', '\0\0=+`~~~~~~~~\0', '\0\0=+a~~~~~~~~\0', '\0\0=+b~~~~~~~~\0', '\0\0=+c~~~~~~~~\0', '\0\0=+e~~~~~~~~\0', '\0\0=+f~~~~~~~~\0', '\0\0=+g~~~~~~~~\0', '\0\0=+h~~~~~~~~\0', '\0\0=+i~~~~~~~~\0', '\0\0=+k~~~~~~~~\0', '\0\0=+l~~~~~~~~\0', '\0\0=+n~~~~~~~~\0', '\0\0=+o~~~~~~~~\0', '\0\0=+p~~~~~~~~\0', '\0\0=+q~~~~~~~~\0', '\0\0=+r~~~~~~~~\0', '\0\0=+s~~~~~~~~\0', '\0\0=+u~~~~~~~~\0', '\0\0=+x~~~~~~~~\0', '\0\0=+y~~~~~~~~\0', '\0\0=+|~~~~~~~~\0', '\0\0=+}~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~\0', 0x00003D2B807E7E7E7E7E7E7E7E7F0003, 0x00003D2B817E7E7E7E7E7E7E7E7F0003, 0x00003D2B827E7E7E7E7E7E7E7E7F0003, 0x00003D2B837E7E7E7E7E7E7E7E7F0003, 0x00003D2B847E7E7E7E7E7E7E7E7F0003, 0x00003D2B857E7E7E7E7E7E7E7E7F0003, 0x00003D2B867E7E7E7E7E7E7E7E7F0003, 0x00003D2B877E7E7E7E7E7E7E7E7F0003, 0x00003D2B897E7E7E7E7E7E7E7E7F0003, 0x00003D2B8A7E7E7E7E7E7E7E7E7F0003, 0x00003D2B8B7E7E7E7E7E7E7E7E7F0003, 0x00003D2B8C7E7E7E7E7E7E7E7E7F0003, 0x00003D2B8E7E7E7E7E7E7E7E7E7F0003, 0x00003D2B8F7E7E7E7E7E7E7E7E7F0003, 0x00003D2B907E7E7E7E7E7E7E7E7F0003, 0x00003D2B917E7E7E7E7E7E7E7E7F0003, 0x00003D2B927E7E7E7E7E7E7E7E7F0003, 0x00003D2B937E7E7E7E7E7E7E7E7F0003, 0x00003D2B947E7E7E7E7E7E7E7E7F0003, 0x00003D2B957E7E7E7E7E7E7E7E7F0003, 0x00003D2B967E7E7E7E7E7E7E7E7F0003, 0x00003D2B987E7E7E7E7E7E7E7E7F0003, 0x00003D2B997E7E7E7E7E7E7E7E7F0003, 0x00003D2B9A7E7E7E7E7E7E7E7E7F0003, 0x00003D2BA07E7E7E7E7E7E7E7E7F0003, 0x00003D2BA17E7E7E7E7E7E7E7E7F0003, 0x00003D2BA27E7E7E7E7E7E7E7E7F0003, 0x00003D2BA47E7E7E7E7E7E7E7E7F0003, 0x00003D2BA67E7E7E7E7E7E7E7E7F0003, 0x00003D2BA77E7E7E7E7E7E7E7E7F0003, 0x00003D2BAA7E7E7E7E7E7E7E7E7F0003, 0x00003D2BAB7E7E7E7E7E7E7E7E7F0003, 0x00003D2BAE7E7E7E7E7E7E7E7E7F0003, 0x00003D2BAF7E7E7E7E7E7E7E7E7F0003, 0x00003D2BB07E7E7E7E7E7E7E7E7F0003, 0x00003D2BC37E7E7E7E7E7E7E7E7F0003, 0x00003D2BD37E7E7E7E7E7E7E7E7F0003, 0x00003D2BF07E7E7E7E7E7E7E7E7F0003, 0x00003D2BF17E7E7E7E7E7E7E7E7F0003, 0x00003D2BF27E7E7E7E7E7E7E7E7F0003, 0x00003D2BF77E7E7E7E7E7E7E7E7F0003, 0x00003D2BF87E7E7E7E7E7E7E7E7F0003, 0x00003D2BFF7E7E7E7E7E7E7E7E7F0003, '\0\0=,\0~~~~~~~~\0', '\0\0=,~~~~~~~~\0', '\0\0=,~~~~~~~~\0', '\0\0=,$~~~~~~~~\0', '\0\0=,&~~~~~~~~\0', '\0\0=,\'~~~~~~~~\0', '\0\0=,,~~~~~~~~\0', '\0\0=,-~~~~~~~~\0', '\0\0=,1~~~~~~~~\0', '\0\0=,2~~~~~~~~\0', '\0\0=,3~~~~~~~~\0', '\0\0=,4~~~~~~~~\0', '\0\0=,6~~~~~~~~\0', '\0\0=,9~~~~~~~~\0', '\0\0=,:~~~~~~~~\0', '\0\0=,=~~~~~~~~\0', '\0\0=,>~~~~~~~~\0', '\0\0=,?~~~~~~~~\0', '\0\0=,@~~~~~~~~\0', '\0\0=,B~~~~~~~~\0', '\0\0=,C~~~~~~~~\0', '\0\0=,D~~~~~~~~\0', '\0\0=,F~~~~~~~~\0', '\0\0=,J~~~~~~~~\0', '\0\0=,K~~~~~~~~\0', '\0\0=,L~~~~~~~~\0', '\0\0=,O~~~~~~~~\0', '\0\0=,P~~~~~~~~\0', '\0\0=,Q~~~~~~~~\0', '\0\0=,S~~~~~~~~\0', '\0\0=,T~~~~~~~~\0', '\0\0=,U~~~~~~~~\0', '\0\0=,V~~~~~~~~\0', '\0\0=,W~~~~~~~~\0', '\0\0=,X~~~~~~~~\0', '\0\0=,Y~~~~~~~~\0', '\0\0=,Z~~~~~~~~\0', '\0\0=,[~~~~~~~~\0', '\0\0=,\\~~~~~~~~\0', '\0\0=,z~~~~~~~~\0', '\0\0=,~~~~~~~~\0', 0x00003D2C8D7E7E7E7E7E7E7E7E7F0003, 0x00003D2C8E7E7E7E7E7E7E7E7E7F0003, 0x00003D2C8F7E7E7E7E7E7E7E7E7F0003, 0x00003D2C907E7E7E7E7E7E7E7E7F0003, 0x00003D2C927E7E7E7E7E7E7E7E7F0003, 0x00003D2C947E7E7E7E7E7E7E7E7F0003, 0x00003D2C967E7E7E7E7E7E7E7E7F0003, 0x00003D2C977E7E7E7E7E7E7E7E7F0003, 0x00003D2C997E7E7E7E7E7E7E7E7F0003, 0x00003D2C9A7E7E7E7E7E7E7E7E7F0003, 0x00003D2CA07E7E7E7E7E7E7E7E7F0003, 0x00003D2CA17E7E7E7E7E7E7E7E7F0003, 0x00003D2CA27E7E7E7E7E7E7E7E7F0003, 0x00003D2CA37E7E7E7E7E7E7E7E7F0003, 0x00003D2CA47E7E7E7E7E7E7E7E7F0003, 0x00003D2CA57E7E7E7E7E7E7E7E7F0003, 0x00003D2CA67E7E7E7E7E7E7E7E7F0003, 0x00003D2CA97E7E7E7E7E7E7E7E7F0003, 0x00003D2CAA7E7E7E7E7E7E7E7E7F0003, 0x00003D2CAD7E7E7E7E7E7E7E7E7F0003, 0x00003D2CAE7E7E7E7E7E7E7E7E7F0003, 0x00003D2CAF7E7E7E7E7E7E7E7E7F0003, 0x00003D2CB17E7E7E7E7E7E7E7E7F0003, 0x00003D2CB27E7E7E7E7E7E7E7E7F0003, 0x00003D2CB67E7E7E7E7E7E7E7E7F0003, 0x00003D2CBD7E7E7E7E7E7E7E7E7F0003, 0x00003D2CBE7E7E7E7E7E7E7E7E7F0003, 0x00003D2CC17E7E7E7E7E7E7E7E7F0003, 0x00003D2CC57E7E7E7E7E7E7E7E7F0003, 0x00003D2CC67E7E7E7E7E7E7E7E7F0003, 0x00003D2CD47E7E7E7E7E7E7E7E7F0003, 0x00003D2CD57E7E7E7E7E7E7E7E7F0003, 0x00003D2CD67E7E7E7E7E7E7E7E7F0003, 0x00003D2CD77E7E7E7E7E7E7E7E7F0003, 0x00003D2CD87E7E7E7E7E7E7E7E7F0003, 0x00003D2CD97E7E7E7E7E7E7E7E7F0003, 0x00003D2CDB7E7E7E7E7E7E7E7E7F0003, 0x00003D2CDD7E7E7E7E7E7E7E7E7F0003, 0x00003D2CDE7E7E7E7E7E7E7E7E7F0003, 0x00003D2CE27E7E7E7E7E7E7E7E7F0003, 0x00003D2CE67E7E7E7E7E7E7E7E7F0003, 0x00003D2CE77E7E7E7E7E7E7E7E7F0003, 0x00003D2CE87E7E7E7E7E7E7E7E7F0003, 0x00003D2CE97E7E7E7E7E7E7E7E7F0003, 0x00003D2CEA7E7E7E7E7E7E7E7E7F0003, 0x00003D2CEB7E7E7E7E7E7E7E7E7F0003, 0x00003D2CEC7E7E7E7E7E7E7E7E7F0003, 0x00003D2CED7E7E7E7E7E7E7E7E7F0003, 0x00003D2CEE7E7E7E7E7E7E7E7E7F0003, 0x00003D2CEF7E7E7E7E7E7E7E7E7F0003, 0x00003D2CF07E7E7E7E7E7E7E7E7F0003, 0x00003D2CF17E7E7E7E7E7E7E7E7F0003, 0x00003D2CF27E7E7E7E7E7E7E7E7F0003, 0x00003D2CF37E7E7E7E7E7E7E7E7F0003, 0x00003D2CF47E7E7E7E7E7E7E7E7F0003, 0x00003D2CF57E7E7E7E7E7E7E7E7F0003, 0x00003D2CF67E7E7E7E7E7E7E7E7F0003, 0x00003D2CF77E7E7E7E7E7E7E7E7F0003, 0x00003D2CF87E7E7E7E7E7E7E7E7F0003, 0x00003D2CF97E7E7E7E7E7E7E7E7F0003, 0x00003D2CFA7E7E7E7E7E7E7E7E7F0003, 0x00003D2CFB7E7E7E7E7E7E7E7E7F0003, 0x00003D2CFC7E7E7E7E7E7E7E7E7F0003, 0x00003D2CFD7E7E7E7E7E7E7E7E7F0003, 0x00003D2CFE7E7E7E7E7E7E7E7E7F0003, 0x00003D2CFF7E7E7E7E7E7E7E7E7F0003, '\0\0=-\0~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-	~~~~~~~~\0', '\0\0=-
~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-
~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=-~~~~~~~~\0', '\0\0=- ~~~~~~~~\0', '\0\0=-!~~~~~~~~\0', '\0\0=-\"~~~~~~~~\0', '\0\0=-#~~~~~~~~\0', '\0\0=-$~~~~~~~~\0', '\0\0=-%~~~~~~~~\0', '\0\0=-&~~~~~~~~\0', '\0\0=-\'~~~~~~~~\0', '\0\0=-(~~~~~~~~\0', '\0\0=-)~~~~~~~~\0', '\0\0=-*~~~~~~~~\0', '\0\0=-+~~~~~~~~\0', '\0\0=-0~~~~~~~~\0', '\0\0=-4~~~~~~~~\0', '\0\0=-5~~~~~~~~\0', '\0\0=-6~~~~~~~~\0', '\0\0=-7~~~~~~~~\0', '\0\0=-8~~~~~~~~\0', '\0\0=-9~~~~~~~~\0', '\0\0=-:~~~~~~~~\0', '\0\0=-=~~~~~~~~\0', '\0\0=->~~~~~~~~\0', '\0\0=-?~~~~~~~~\0', '\0\0=-@~~~~~~~~\0', '\0\0=-A~~~~~~~~\0', '\0\0=-F~~~~~~~~\0', '\0\0=-G~~~~~~~~\0', '\0\0=-M~~~~~~~~\0', '\0\0=-P~~~~~~~~\0', '\0\0=-Q~~~~~~~~\0', '\0\0=-f~~~~~~~~\0', '\0\0=-g~~~~~~~~\0', '\0\0=-h~~~~~~~~\0', '\0\0=-i~~~~~~~~\0', '\0\0=-j~~~~~~~~\0', '\0\0=-k~~~~~~~~\0', '\0\0=-o~~~~~~~~\0', '\0\0=-p~~~~~~~~\0', '\0\0=-q~~~~~~~~\0', '\0\0=-r~~~~~~~~\0', '\0\0=-t~~~~~~~~\0', '\0\0=-u~~~~~~~~\0', '\0\0=-v~~~~~~~~\0', '\0\0=-w~~~~~~~~\0', '\0\0=-x~~~~~~~~\0', '\0\0=-y~~~~~~~~\0', '\0\0=-z~~~~~~~~\0', '\0\0=-{~~~~~~~~\0', '\0\0=-|~~~~~~~~\0', '\0\0=-}~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~\0', 0x00003D2D807E7E7E7E7E7E7E7E7F0003, 0x00003D2D817E7E7E7E7E7E7E7E7F0003, 0x00003D2D827E7E7E7E7E7E7E7E7F0003, 0x00003D2D837E7E7E7E7E7E7E7E7F0003, 0x00003D2D847E7E7E7E7E7E7E7E7F0003, 0x00003D2D857E7E7E7E7E7E7E7E7F0003, 0x00003D2D867E7E7E7E7E7E7E7E7F0003, 0x00003D2D877E7E7E7E7E7E7E7E7F0003, 0x00003D2D887E7E7E7E7E7E7E7E7F0003, 0x00003D2D897E7E7E7E7E7E7E7E7F0003, 0x00003D2D8A7E7E7E7E7E7E7E7E7F0003, 0x00003D2D8B7E7E7E7E7E7E7E7E7F0003, 0x00003D2D8C7E7E7E7E7E7E7E7E7F0003, 0x00003D2D8D7E7E7E7E7E7E7E7E7F0003, 0x00003D2D8E7E7E7E7E7E7E7E7E7F0003, 0x00003D2D8F7E7E7E7E7E7E7E7E7F0003, 0x00003D2D907E7E7E7E7E7E7E7E7F0003, 0x00003D2D917E7E7E7E7E7E7E7E7F0003, 0x00003D2D927E7E7E7E7E7E7E7E7F0003, 0x00003D2D937E7E7E7E7E7E7E7E7F0003, 0x00003D2D947E7E7E7E7E7E7E7E7F0003, 0x00003D2D957E7E7E7E7E7E7E7E7F0003, 0x00003D2D967E7E7E7E7E7E7E7E7F0003, 0x00003D2D977E7E7E7E7E7E7E7E7F0003, 0x00003D2D987E7E7E7E7E7E7E7E7F0003, 0x00003D2D997E7E7E7E7E7E7E7E7F0003, 0x00003D2D9A7E7E7E7E7E7E7E7E7F0003, 0x00003D2D9B7E7E7E7E7E7E7E7E7F0003, 0x00003D2D9C7E7E7E7E7E7E7E7E7F0003, 0x00003D2D9D7E7E7E7E7E7E7E7E7F0003, 0x00003D2D9E7E7E7E7E7E7E7E7E7F0003, 0x00003D2D9F7E7E7E7E7E7E7E7E7F0003, 0x00003D2DA07E7E7E7E7E7E7E7E7F0003, 0x00003D2DA47E7E7E7E7E7E7E7E7F0003, 0x00003D2DA57E7E7E7E7E7E7E7E7F0003, 0x00003D2DA67E7E7E7E7E7E7E7E7F0003, 0x00003D2DA77E7E7E7E7E7E7E7E7F0003, 0x00003D2DAC7E7E7E7E7E7E7E7E7F0003, 0x00003D2DB17E7E7E7E7E7E7E7E7F0003, 0x00003D2DB47E7E7E7E7E7E7E7E7F0003, 0x00003D2DB57E7E7E7E7E7E7E7E7F0003, 0x00003D2DB77E7E7E7E7E7E7E7E7F0003, 0x00003D2DB97E7E7E7E7E7E7E7E7F0003, 0x00003D2DBA7E7E7E7E7E7E7E7E7F0003, 0x00003D2DBB7E7E7E7E7E7E7E7E7F0003, 0x00003D2DBC7E7E7E7E7E7E7E7E7F0003, 0x00003D2DBD7E7E7E7E7E7E7E7E7F0003, 0x00003D2DBF7E7E7E7E7E7E7E7E7F0003, 0x00003D2DC07E7E7E7E7E7E7E7E7F0003, 0x00003D2DC37E7E7E7E7E7E7E7E7F0003, 0x00003D2DC67E7E7E7E7E7E7E7E7F0003, 0x00003D2DC77E7E7E7E7E7E7E7E7F0003, 0x00003D2DD37E7E7E7E7E7E7E7E7F0003, 0x00003D2DD47E7E7E7E7E7E7E7E7F0003, 0x00003D2DD57E7E7E7E7E7E7E7E7F0003, 0x00003D2DD67E7E7E7E7E7E7E7E7F0003, 0x00003D2DD77E7E7E7E7E7E7E7E7F0003, 0x00003D2DD87E7E7E7E7E7E7E7E7F0003, 0x00003D2DD97E7E7E7E7E7E7E7E7F0003, 0x00003D2DDA7E7E7E7E7E7E7E7E7F0003, 0x00003D2DDB7E7E7E7E7E7E7E7E7F0003, 0x00003D2DDC7E7E7E7E7E7E7E7E7F0003, 0x00003D2DDD7E7E7E7E7E7E7E7E7F0003, 0x00003D2DDE7E7E7E7E7E7E7E7E7F0003, 0x00003D2DDF7E7E7E7E7E7E7E7E7F0003, 0x00003D2DE07E7E7E7E7E7E7E7E7F0003, 0x00003D2DE17E7E7E7E7E7E7E7E7F0003, 0x00003D2DE27E7E7E7E7E7E7E7E7F0003, 0x00003D2DE37E7E7E7E7E7E7E7E7F0003, 0x00003D2DE47E7E7E7E7E7E7E7E7F0003, 0x00003D2DE57E7E7E7E7E7E7E7E7F0003, '\0\0=.~~~~~~~~\0', '\0\0=.~~~~~~~~\0', '\0\0=.~~~~~~~~\0', '\0\0=. ~~~~~~~~\0', '\0\0=.!~~~~~~~~\0', '\0\0=.\"~~~~~~~~\0', '\0\0=.%~~~~~~~~\0', '\0\0=.\'~~~~~~~~\0', '\0\0=.(~~~~~~~~\0', '\0\0=.*~~~~~~~~\0', '\0\0=.+~~~~~~~~\0', '\0\0=.,~~~~~~~~\0', '\0\0=.-~~~~~~~~\0', '\0\0=..~~~~~~~~\0', '\0\0=./~~~~~~~~\0', '\0\0=.0~~~~~~~~\0', '\0\0=.1~~~~~~~~\0', '\0\0=.2~~~~~~~~\0', '\0\0=.4~~~~~~~~\0', '\0\0=.5~~~~~~~~\0', '\0\0=.6~~~~~~~~\0', '\0\0=.7~~~~~~~~\0', '\0\0=.8~~~~~~~~\0', '\0\0=.:~~~~~~~~\0', '\0\0=.;~~~~~~~~\0', '\0\0=.<~~~~~~~~\0', '\0\0=.=~~~~~~~~\0', '\0\0=.>~~~~~~~~\0', '\0\0=.?~~~~~~~~\0', '\0\0=.@~~~~~~~~\0', '\0\0=.A~~~~~~~~\0', '\0\0=.B~~~~~~~~\0', '\0\0=.C~~~~~~~~\0');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 251)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 264)
9	Shopware\Core\Framework\Api\Controller\ApiController->{closure:Shopware\Core\Framework\Api\Controller\ApiController::search():264} (line 201)
10	Shopware\Core\Framework\Context->scope (line 264)
11	Shopware\Core\Framework\Api\Controller\ApiController->search (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
14	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
21	Shopware\Core\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 10)

5.55 ms
(0.77%)

SELECT LOWER(HEX(p.id)), pt.name
                FROM product p
                INNER JOIN product pp ON pp.id = p.parent_id AND pp.version_id = ?
                INNER JOIN product_translation pt ON pp.id = pt.product_id
                WHERE p.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p.version_id = ?

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  "\x00\x00=*Z~~~~~~~~~\x00\x03"
  "\x00\x00=*]~~~~~~~~~\x00\x03"
  "\x00\x00=*_~~~~~~~~~\x00\x03"
  "\x00\x00=*a~~~~~~~~~\x00\x03"
  "\x00\x00=*b~~~~~~~~~\x00\x03"
  "\x00\x00=*c~~~~~~~~~\x00\x03"
  "\x00\x00=*d~~~~~~~~~\x00\x03"
  "\x00\x00=*g~~~~~~~~~\x00\x03"
  "\x00\x00=*h~~~~~~~~~\x00\x03"
  "\x00\x00=*i~~~~~~~~~\x00\x03"
  "\x00\x00=*m~~~~~~~~~\x00\x03"
  "\x00\x00=*s~~~~~~~~~\x00\x03"
  "\x00\x00=*t~~~~~~~~~\x00\x03"
  "\x00\x00=*v~~~~~~~~~\x00\x03"
  "\x00\x00=*x~~~~~~~~~\x00\x03"
  "\x00\x00=*{~~~~~~~~~\x00\x03"
  "\x00\x00=*~~~~~~~~~~\x00\x03"
  b"\x00\x00=*€~~~~~~~~~\x00\x03"
  b"\x00\x00=*~~~~~~~~~\x00\x03"
  b"\x00\x00=*‚~~~~~~~~~\x00\x03"
  b"\x00\x00=*ƒ~~~~~~~~~\x00\x03"
  b"\x00\x00=*„~~~~~~~~~\x00\x03"
  b"\x00\x00=*†~~~~~~~~~\x00\x03"
  b"\x00\x00=*‡~~~~~~~~~\x00\x03"
  b"\x00\x00=*Š~~~~~~~~~\x00\x03"
  b"\x00\x00=*‹~~~~~~~~~\x00\x03"
  b"\x00\x00=*Œ~~~~~~~~~\x00\x03"
  b"\x00\x00=*‘~~~~~~~~~\x00\x03"
  b"\x00\x00=*š~~~~~~~~~\x00\x03"
  b"\x00\x00=*›~~~~~~~~~\x00\x03"
  b"\x00\x00=*œ~~~~~~~~~\x00\x03"
  b"\x00\x00=*~~~~~~~~~\x00\x03"
  b"\x00\x00=*ž~~~~~~~~~\x00\x03"
  b"\x00\x00=* ~~~~~~~~~\x00\x03"
  b"\x00\x00=*¡~~~~~~~~~\x00\x03"
  b"\x00\x00=*¥~~~~~~~~~\x00\x03"
  b"\x00\x00=*¦~~~~~~~~~\x00\x03"
  b"\x00\x00=*§~~~~~~~~~\x00\x03"
  b"\x00\x00=*ª~~~~~~~~~\x00\x03"
  b"\x00\x00=*~~~~~~~~~\x00\x03"
  b"\x00\x00=*°~~~~~~~~~\x00\x03"
  b"\x00\x00=*±~~~~~~~~~\x00\x03"
  b"\x00\x00=*²~~~~~~~~~\x00\x03"
  b"\x00\x00=*¶~~~~~~~~~\x00\x03"
  b"\x00\x00=*·~~~~~~~~~\x00\x03"
  b"\x00\x00=*º~~~~~~~~~\x00\x03"
  b"\x00\x00=*»~~~~~~~~~\x00\x03"
  b"\x00\x00=*½~~~~~~~~~\x00\x03"
  b"\x00\x00=*¿~~~~~~~~~\x00\x03"
  b"\x00\x00=*Á~~~~~~~~~\x00\x03"
  b"\x00\x00=*Â~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ã~~~~~~~~~\x00\x03"
  b"\x00\x00=*Å~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ç~~~~~~~~~\x00\x03"
  b"\x00\x00=*É~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ê~~~~~~~~~\x00\x03"
  b"\x00\x00=*Í~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ï~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ð~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ñ~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ò~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ó~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ô~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ö~~~~~~~~~\x00\x03"
  b"\x00\x00=*×~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ø~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ù~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ú~~~~~~~~~\x00\x03"
  b"\x00\x00=*Û~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ü~~~~~~~~~\x00\x03"
  b"\x00\x00=*Ý~~~~~~~~~\x00\x03"
  b"\x00\x00=*à~~~~~~~~~\x00\x03"
  b"\x00\x00=*á~~~~~~~~~\x00\x03"
  b"\x00\x00=*â~~~~~~~~~\x00\x03"
  b"\x00\x00=*ã~~~~~~~~~\x00\x03"
  b"\x00\x00=*ä~~~~~~~~~\x00\x03"
  b"\x00\x00=*è~~~~~~~~~\x00\x03"
  b"\x00\x00=*é~~~~~~~~~\x00\x03"
  b"\x00\x00=*ì~~~~~~~~~\x00\x03"
  b"\x00\x00=*í~~~~~~~~~\x00\x03"
  b"\x00\x00=*õ~~~~~~~~~\x00\x03"
  b"\x00\x00=*ú~~~~~~~~~\x00\x03"
  b"\x00\x00=*ü~~~~~~~~~\x00\x03"
  b"\x00\x00=*ý~~~~~~~~~\x00\x03"
  b"\x00\x00=*þ~~~~~~~~~\x00\x03"
  "\x00\x00=+\x00~~~~~~~~~\x00\x03"
  "\x00\x00=+\x01~~~~~~~~~\x00\x03"
  "\x00\x00=+\x03~~~~~~~~~\x00\x03"
  "\x00\x00=+\x06~~~~~~~~~\x00\x03"
  "\x00\x00=+\x08~~~~~~~~~\x00\x03"
  "\x00\x00=+\v~~~~~~~~~\x00\x03"
  "\x00\x00=+\r~~~~~~~~~\x00\x03"
  "\x00\x00=+\x0E~~~~~~~~~\x00\x03"
  "\x00\x00=+\x0F~~~~~~~~~\x00\x03"
  "\x00\x00=+\x11~~~~~~~~~\x00\x03"
  "\x00\x00=+\x14~~~~~~~~~\x00\x03"
  "\x00\x00=+\x15~~~~~~~~~\x00\x03"
  "\x00\x00=+\e~~~~~~~~~\x00\x03"
  "\x00\x00=+\x1D~~~~~~~~~\x00\x03"
  "\x00\x00=+\x1E~~~~~~~~~\x00\x03"
  "\x00\x00=+"~~~~~~~~~\x00\x03"
  "\x00\x00=+#~~~~~~~~~\x00\x03"
  "\x00\x00=+$~~~~~~~~~\x00\x03"
  "\x00\x00=+(~~~~~~~~~\x00\x03"
  "\x00\x00=+*~~~~~~~~~\x00\x03"
  "\x00\x00=++~~~~~~~~~\x00\x03"
  "\x00\x00=+,~~~~~~~~~\x00\x03"
  "\x00\x00=+.~~~~~~~~~\x00\x03"
  "\x00\x00=+1~~~~~~~~~\x00\x03"
  "\x00\x00=+3~~~~~~~~~\x00\x03"
  "\x00\x00=+5~~~~~~~~~\x00\x03"
  "\x00\x00=+8~~~~~~~~~\x00\x03"
  "\x00\x00=+9~~~~~~~~~\x00\x03"
  "\x00\x00=+;~~~~~~~~~\x00\x03"
  "\x00\x00=+<~~~~~~~~~\x00\x03"
  "\x00\x00=+=~~~~~~~~~\x00\x03"
  "\x00\x00=+?~~~~~~~~~\x00\x03"
  "\x00\x00=+@~~~~~~~~~\x00\x03"
  "\x00\x00=+G~~~~~~~~~\x00\x03"
  "\x00\x00=+H~~~~~~~~~\x00\x03"
  "\x00\x00=+I~~~~~~~~~\x00\x03"
  "\x00\x00=+K~~~~~~~~~\x00\x03"
  "\x00\x00=+L~~~~~~~~~\x00\x03"
  "\x00\x00=+O~~~~~~~~~\x00\x03"
  "\x00\x00=+P~~~~~~~~~\x00\x03"
  "\x00\x00=+Q~~~~~~~~~\x00\x03"
  "\x00\x00=+R~~~~~~~~~\x00\x03"
  "\x00\x00=+T~~~~~~~~~\x00\x03"
  "\x00\x00=+U~~~~~~~~~\x00\x03"
  "\x00\x00=+V~~~~~~~~~\x00\x03"
  "\x00\x00=+W~~~~~~~~~\x00\x03"
  "\x00\x00=+X~~~~~~~~~\x00\x03"
  "\x00\x00=+Z~~~~~~~~~\x00\x03"
  "\x00\x00=+[~~~~~~~~~\x00\x03"
  "\x00\x00=+\~~~~~~~~~\x00\x03"
  "\x00\x00=+]~~~~~~~~~\x00\x03"
  "\x00\x00=+^~~~~~~~~~\x00\x03"
  "\x00\x00=+_~~~~~~~~~\x00\x03"
  "\x00\x00=+`~~~~~~~~~\x00\x03"
  "\x00\x00=+a~~~~~~~~~\x00\x03"
  "\x00\x00=+b~~~~~~~~~\x00\x03"
  "\x00\x00=+c~~~~~~~~~\x00\x03"
  "\x00\x00=+e~~~~~~~~~\x00\x03"
  "\x00\x00=+f~~~~~~~~~\x00\x03"
  "\x00\x00=+g~~~~~~~~~\x00\x03"
  "\x00\x00=+h~~~~~~~~~\x00\x03"
  "\x00\x00=+i~~~~~~~~~\x00\x03"
  "\x00\x00=+k~~~~~~~~~\x00\x03"
  "\x00\x00=+l~~~~~~~~~\x00\x03"
  "\x00\x00=+n~~~~~~~~~\x00\x03"
  "\x00\x00=+o~~~~~~~~~\x00\x03"
  "\x00\x00=+p~~~~~~~~~\x00\x03"
  "\x00\x00=+q~~~~~~~~~\x00\x03"
  "\x00\x00=+r~~~~~~~~~\x00\x03"
  "\x00\x00=+s~~~~~~~~~\x00\x03"
  "\x00\x00=+u~~~~~~~~~\x00\x03"
  "\x00\x00=+x~~~~~~~~~\x00\x03"
  "\x00\x00=+y~~~~~~~~~\x00\x03"
  "\x00\x00=+|~~~~~~~~~\x00\x03"
  "\x00\x00=+}~~~~~~~~~\x00\x03"
  "\x00\x00=+~~~~~~~~~~\x00\x03"
  "\x00\x00=+\x7F~~~~~~~~~\x00\x03"
  b"\x00\x00=+€~~~~~~~~~\x00\x03"
  b"\x00\x00=+~~~~~~~~~\x00\x03"
  b"\x00\x00=+‚~~~~~~~~~\x00\x03"
  b"\x00\x00=+ƒ~~~~~~~~~\x00\x03"
  b"\x00\x00=+„~~~~~~~~~\x00\x03"
  b"\x00\x00=+…~~~~~~~~~\x00\x03"
  b"\x00\x00=+†~~~~~~~~~\x00\x03"
  b"\x00\x00=+‡~~~~~~~~~\x00\x03"
  b"\x00\x00=+‰~~~~~~~~~\x00\x03"
  b"\x00\x00=+Š~~~~~~~~~\x00\x03"
  b"\x00\x00=+‹~~~~~~~~~\x00\x03"
  b"\x00\x00=+Œ~~~~~~~~~\x00\x03"
  b"\x00\x00=+Ž~~~~~~~~~\x00\x03"
  b"\x00\x00=+~~~~~~~~~\x00\x03"
  b"\x00\x00=+~~~~~~~~~\x00\x03"
  b"\x00\x00=+‘~~~~~~~~~\x00\x03"
  b"\x00\x00=+’~~~~~~~~~\x00\x03"
  b"\x00\x00=+“~~~~~~~~~\x00\x03"
  b"\x00\x00=+”~~~~~~~~~\x00\x03"
  b"\x00\x00=+•~~~~~~~~~\x00\x03"
  b"\x00\x00=+–~~~~~~~~~\x00\x03"
  b"\x00\x00=+˜~~~~~~~~~\x00\x03"
  b"\x00\x00=+™~~~~~~~~~\x00\x03"
  b"\x00\x00=+š~~~~~~~~~\x00\x03"
  b"\x00\x00=+ ~~~~~~~~~\x00\x03"
  b"\x00\x00=+¡~~~~~~~~~\x00\x03"
  b"\x00\x00=+¢~~~~~~~~~\x00\x03"
  b"\x00\x00=+¤~~~~~~~~~\x00\x03"
  b"\x00\x00=+¦~~~~~~~~~\x00\x03"
  b"\x00\x00=+§~~~~~~~~~\x00\x03"
  b"\x00\x00=+ª~~~~~~~~~\x00\x03"
  b"\x00\x00=+«~~~~~~~~~\x00\x03"
  b"\x00\x00=+®~~~~~~~~~\x00\x03"
  b"\x00\x00=+¯~~~~~~~~~\x00\x03"
  b"\x00\x00=+°~~~~~~~~~\x00\x03"
  b"\x00\x00=+Ã~~~~~~~~~\x00\x03"
  b"\x00\x00=+Ó~~~~~~~~~\x00\x03"
  b"\x00\x00=+ð~~~~~~~~~\x00\x03"
  b"\x00\x00=+ñ~~~~~~~~~\x00\x03"
  b"\x00\x00=+ò~~~~~~~~~\x00\x03"
  b"\x00\x00=+÷~~~~~~~~~\x00\x03"
  b"\x00\x00=+ø~~~~~~~~~\x00\x03"
  b"\x00\x00=+ÿ~~~~~~~~~\x00\x03"
  "\x00\x00=,\x00~~~~~~~~~\x00\x03"
  "\x00\x00=,\x02~~~~~~~~~\x00\x03"
  "\x00\x00=,\x05~~~~~~~~~\x00\x03"
  "\x00\x00=,$~~~~~~~~~\x00\x03"
  "\x00\x00=,&~~~~~~~~~\x00\x03"
  "\x00\x00=,'~~~~~~~~~\x00\x03"
  "\x00\x00=,,~~~~~~~~~\x00\x03"
  "\x00\x00=,-~~~~~~~~~\x00\x03"
  "\x00\x00=,1~~~~~~~~~\x00\x03"
  "\x00\x00=,2~~~~~~~~~\x00\x03"
  "\x00\x00=,3~~~~~~~~~\x00\x03"
  "\x00\x00=,4~~~~~~~~~\x00\x03"
  "\x00\x00=,6~~~~~~~~~\x00\x03"
  "\x00\x00=,9~~~~~~~~~\x00\x03"
  "\x00\x00=,:~~~~~~~~~\x00\x03"
  "\x00\x00=,=~~~~~~~~~\x00\x03"
  "\x00\x00=,>~~~~~~~~~\x00\x03"
  "\x00\x00=,?~~~~~~~~~\x00\x03"
  "\x00\x00=,@~~~~~~~~~\x00\x03"
  "\x00\x00=,B~~~~~~~~~\x00\x03"
  "\x00\x00=,C~~~~~~~~~\x00\x03"
  "\x00\x00=,D~~~~~~~~~\x00\x03"
  "\x00\x00=,F~~~~~~~~~\x00\x03"
  "\x00\x00=,J~~~~~~~~~\x00\x03"
  "\x00\x00=,K~~~~~~~~~\x00\x03"
  "\x00\x00=,L~~~~~~~~~\x00\x03"
  "\x00\x00=,O~~~~~~~~~\x00\x03"
  "\x00\x00=,P~~~~~~~~~\x00\x03"
  "\x00\x00=,Q~~~~~~~~~\x00\x03"
  "\x00\x00=,S~~~~~~~~~\x00\x03"
  "\x00\x00=,T~~~~~~~~~\x00\x03"
  "\x00\x00=,U~~~~~~~~~\x00\x03"
  "\x00\x00=,V~~~~~~~~~\x00\x03"
  "\x00\x00=,W~~~~~~~~~\x00\x03"
  "\x00\x00=,X~~~~~~~~~\x00\x03"
  "\x00\x00=,Y~~~~~~~~~\x00\x03"
  "\x00\x00=,Z~~~~~~~~~\x00\x03"
  "\x00\x00=,[~~~~~~~~~\x00\x03"
  "\x00\x00=,\~~~~~~~~~\x00\x03"
  "\x00\x00=,z~~~~~~~~~\x00\x03"
  "\x00\x00=,\x7F~~~~~~~~~\x00\x03"
  b"\x00\x00=,Ž~~~~~~~~~\x00\x03"
  b"\x00\x00=,Ž~~~~~~~~~\x00\x03"
  b"\x00\x00=,~~~~~~~~~\x00\x03"
  b"\x00\x00=,~~~~~~~~~\x00\x03"
  b"\x00\x00=,’~~~~~~~~~\x00\x03"
  b"\x00\x00=,”~~~~~~~~~\x00\x03"
  b"\x00\x00=,–~~~~~~~~~\x00\x03"
  b"\x00\x00=,—~~~~~~~~~\x00\x03"
  b"\x00\x00=,™~~~~~~~~~\x00\x03"
  b"\x00\x00=,š~~~~~~~~~\x00\x03"
  b"\x00\x00=, ~~~~~~~~~\x00\x03"
  b"\x00\x00=,¡~~~~~~~~~\x00\x03"
  b"\x00\x00=,¢~~~~~~~~~\x00\x03"
  b"\x00\x00=,£~~~~~~~~~\x00\x03"
  b"\x00\x00=,¤~~~~~~~~~\x00\x03"
  b"\x00\x00=,¥~~~~~~~~~\x00\x03"
  b"\x00\x00=,¦~~~~~~~~~\x00\x03"
  b"\x00\x00=,©~~~~~~~~~\x00\x03"
  b"\x00\x00=,ª~~~~~~~~~\x00\x03"
  b"\x00\x00=,~~~~~~~~~\x00\x03"
  b"\x00\x00=,®~~~~~~~~~\x00\x03"
  b"\x00\x00=,¯~~~~~~~~~\x00\x03"
  b"\x00\x00=,±~~~~~~~~~\x00\x03"
  b"\x00\x00=,²~~~~~~~~~\x00\x03"
  b"\x00\x00=,¶~~~~~~~~~\x00\x03"
  b"\x00\x00=,½~~~~~~~~~\x00\x03"
  b"\x00\x00=,¾~~~~~~~~~\x00\x03"
  b"\x00\x00=,Á~~~~~~~~~\x00\x03"
  b"\x00\x00=,Å~~~~~~~~~\x00\x03"
  b"\x00\x00=,Æ~~~~~~~~~\x00\x03"
  b"\x00\x00=,Ô~~~~~~~~~\x00\x03"
  b"\x00\x00=,Õ~~~~~~~~~\x00\x03"
  b"\x00\x00=,Ö~~~~~~~~~\x00\x03"
  b"\x00\x00=,×~~~~~~~~~\x00\x03"
  b"\x00\x00=,Ø~~~~~~~~~\x00\x03"
  b"\x00\x00=,Ù~~~~~~~~~\x00\x03"
  b"\x00\x00=,Û~~~~~~~~~\x00\x03"
  b"\x00\x00=,Ý~~~~~~~~~\x00\x03"
  b"\x00\x00=,Þ~~~~~~~~~\x00\x03"
  b"\x00\x00=,â~~~~~~~~~\x00\x03"
  b"\x00\x00=,æ~~~~~~~~~\x00\x03"
  b"\x00\x00=,ç~~~~~~~~~\x00\x03"
  b"\x00\x00=,è~~~~~~~~~\x00\x03"
  b"\x00\x00=,é~~~~~~~~~\x00\x03"
  b"\x00\x00=,ê~~~~~~~~~\x00\x03"
  b"\x00\x00=,ë~~~~~~~~~\x00\x03"
  b"\x00\x00=,ì~~~~~~~~~\x00\x03"
  b"\x00\x00=,í~~~~~~~~~\x00\x03"
  b"\x00\x00=,î~~~~~~~~~\x00\x03"
  b"\x00\x00=,ï~~~~~~~~~\x00\x03"
  b"\x00\x00=,ð~~~~~~~~~\x00\x03"
  b"\x00\x00=,ñ~~~~~~~~~\x00\x03"
  b"\x00\x00=,ò~~~~~~~~~\x00\x03"
  b"\x00\x00=,ó~~~~~~~~~\x00\x03"
  b"\x00\x00=,ô~~~~~~~~~\x00\x03"
  b"\x00\x00=,õ~~~~~~~~~\x00\x03"
  b"\x00\x00=,ö~~~~~~~~~\x00\x03"
  b"\x00\x00=,÷~~~~~~~~~\x00\x03"
  b"\x00\x00=,ø~~~~~~~~~\x00\x03"
  b"\x00\x00=,ù~~~~~~~~~\x00\x03"
  b"\x00\x00=,ú~~~~~~~~~\x00\x03"
  b"\x00\x00=,û~~~~~~~~~\x00\x03"
  b"\x00\x00=,ü~~~~~~~~~\x00\x03"
  b"\x00\x00=,ý~~~~~~~~~\x00\x03"
  b"\x00\x00=,þ~~~~~~~~~\x00\x03"
  b"\x00\x00=,ÿ~~~~~~~~~\x00\x03"
  "\x00\x00=-\x00~~~~~~~~~\x00\x03"
  "\x00\x00=-\x01~~~~~~~~~\x00\x03"
  "\x00\x00=-\x02~~~~~~~~~\x00\x03"
  "\x00\x00=-\x03~~~~~~~~~\x00\x03"
  "\x00\x00=-\x04~~~~~~~~~\x00\x03"
  "\x00\x00=-\x05~~~~~~~~~\x00\x03"
  "\x00\x00=-\x06~~~~~~~~~\x00\x03"
  "\x00\x00=-\x07~~~~~~~~~\x00\x03"
  "\x00\x00=-\x08~~~~~~~~~\x00\x03"
  "\x00\x00=-\t~~~~~~~~~\x00\x03"
  """
    \x00\x00=-\n
    ~~~~~~~~~\x00\x03
    """
  "\x00\x00=-\v~~~~~~~~~\x00\x03"
  "\x00\x00=-\f~~~~~~~~~\x00\x03"
  "\x00\x00=-\r~~~~~~~~~\x00\x03"
  "\x00\x00=-\x0E~~~~~~~~~\x00\x03"
  "\x00\x00=-\x0F~~~~~~~~~\x00\x03"
  "\x00\x00=-\x10~~~~~~~~~\x00\x03"
  "\x00\x00=-\x11~~~~~~~~~\x00\x03"
  "\x00\x00=-\x12~~~~~~~~~\x00\x03"
  "\x00\x00=-\x13~~~~~~~~~\x00\x03"
  "\x00\x00=-\x14~~~~~~~~~\x00\x03"
  "\x00\x00=-\x15~~~~~~~~~\x00\x03"
  "\x00\x00=-\x16~~~~~~~~~\x00\x03"
  "\x00\x00=-\x17~~~~~~~~~\x00\x03"
  "\x00\x00=-\x18~~~~~~~~~\x00\x03"
  "\x00\x00=-\x19~~~~~~~~~\x00\x03"
  "\x00\x00=-\x1A~~~~~~~~~\x00\x03"
  "\x00\x00=-\e~~~~~~~~~\x00\x03"
  "\x00\x00=-\x1C~~~~~~~~~\x00\x03"
  "\x00\x00=-\x1D~~~~~~~~~\x00\x03"
  "\x00\x00=-\x1E~~~~~~~~~\x00\x03"
  "\x00\x00=-\x1F~~~~~~~~~\x00\x03"
  "\x00\x00=- ~~~~~~~~~\x00\x03"
  "\x00\x00=-!~~~~~~~~~\x00\x03"
  "\x00\x00=-"~~~~~~~~~\x00\x03"
  "\x00\x00=-#~~~~~~~~~\x00\x03"
  "\x00\x00=-$~~~~~~~~~\x00\x03"
  "\x00\x00=-%~~~~~~~~~\x00\x03"
  "\x00\x00=-&~~~~~~~~~\x00\x03"
  "\x00\x00=-'~~~~~~~~~\x00\x03"
  "\x00\x00=-(~~~~~~~~~\x00\x03"
  "\x00\x00=-)~~~~~~~~~\x00\x03"
  "\x00\x00=-*~~~~~~~~~\x00\x03"
  "\x00\x00=-+~~~~~~~~~\x00\x03"
  "\x00\x00=-0~~~~~~~~~\x00\x03"
  "\x00\x00=-4~~~~~~~~~\x00\x03"
  "\x00\x00=-5~~~~~~~~~\x00\x03"
  "\x00\x00=-6~~~~~~~~~\x00\x03"
  "\x00\x00=-7~~~~~~~~~\x00\x03"
  "\x00\x00=-8~~~~~~~~~\x00\x03"
  "\x00\x00=-9~~~~~~~~~\x00\x03"
  "\x00\x00=-:~~~~~~~~~\x00\x03"
  "\x00\x00=-=~~~~~~~~~\x00\x03"
  "\x00\x00=->~~~~~~~~~\x00\x03"
  "\x00\x00=-?~~~~~~~~~\x00\x03"
  "\x00\x00=-@~~~~~~~~~\x00\x03"
  "\x00\x00=-A~~~~~~~~~\x00\x03"
  "\x00\x00=-F~~~~~~~~~\x00\x03"
  "\x00\x00=-G~~~~~~~~~\x00\x03"
  "\x00\x00=-M~~~~~~~~~\x00\x03"
  "\x00\x00=-P~~~~~~~~~\x00\x03"
  "\x00\x00=-Q~~~~~~~~~\x00\x03"
  "\x00\x00=-f~~~~~~~~~\x00\x03"
  "\x00\x00=-g~~~~~~~~~\x00\x03"
  "\x00\x00=-h~~~~~~~~~\x00\x03"
  "\x00\x00=-i~~~~~~~~~\x00\x03"
  "\x00\x00=-j~~~~~~~~~\x00\x03"
  "\x00\x00=-k~~~~~~~~~\x00\x03"
  "\x00\x00=-o~~~~~~~~~\x00\x03"
  "\x00\x00=-p~~~~~~~~~\x00\x03"
  "\x00\x00=-q~~~~~~~~~\x00\x03"
  "\x00\x00=-r~~~~~~~~~\x00\x03"
  "\x00\x00=-t~~~~~~~~~\x00\x03"
  "\x00\x00=-u~~~~~~~~~\x00\x03"
  "\x00\x00=-v~~~~~~~~~\x00\x03"
  "\x00\x00=-w~~~~~~~~~\x00\x03"
  "\x00\x00=-x~~~~~~~~~\x00\x03"
  "\x00\x00=-y~~~~~~~~~\x00\x03"
  "\x00\x00=-z~~~~~~~~~\x00\x03"
  "\x00\x00=-{~~~~~~~~~\x00\x03"
  "\x00\x00=-|~~~~~~~~~\x00\x03"
  "\x00\x00=-}~~~~~~~~~\x00\x03"
  "\x00\x00=-~~~~~~~~~~\x00\x03"
  "\x00\x00=-\x7F~~~~~~~~~\x00\x03"
  b"\x00\x00=-€~~~~~~~~~\x00\x03"
  b"\x00\x00=-~~~~~~~~~\x00\x03"
  b"\x00\x00=-‚~~~~~~~~~\x00\x03"
  b"\x00\x00=-ƒ~~~~~~~~~\x00\x03"
  b"\x00\x00=-„~~~~~~~~~\x00\x03"
  b"\x00\x00=-…~~~~~~~~~\x00\x03"
  b"\x00\x00=-†~~~~~~~~~\x00\x03"
  b"\x00\x00=-‡~~~~~~~~~\x00\x03"
  b"\x00\x00=-ˆ~~~~~~~~~\x00\x03"
  b"\x00\x00=-‰~~~~~~~~~\x00\x03"
  b"\x00\x00=-Š~~~~~~~~~\x00\x03"
  b"\x00\x00=-‹~~~~~~~~~\x00\x03"
  b"\x00\x00=-Œ~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ž~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ž~~~~~~~~~\x00\x03"
  b"\x00\x00=-~~~~~~~~~\x00\x03"
  b"\x00\x00=-~~~~~~~~~\x00\x03"
  b"\x00\x00=-‘~~~~~~~~~\x00\x03"
  b"\x00\x00=-’~~~~~~~~~\x00\x03"
  b"\x00\x00=-“~~~~~~~~~\x00\x03"
  b"\x00\x00=-”~~~~~~~~~\x00\x03"
  b"\x00\x00=-•~~~~~~~~~\x00\x03"
  b"\x00\x00=-–~~~~~~~~~\x00\x03"
  b"\x00\x00=-—~~~~~~~~~\x00\x03"
  b"\x00\x00=-˜~~~~~~~~~\x00\x03"
  b"\x00\x00=-™~~~~~~~~~\x00\x03"
  b"\x00\x00=-š~~~~~~~~~\x00\x03"
  b"\x00\x00=-›~~~~~~~~~\x00\x03"
  b"\x00\x00=-œ~~~~~~~~~\x00\x03"
  b"\x00\x00=-~~~~~~~~~\x00\x03"
  b"\x00\x00=-ž~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ÿ~~~~~~~~~\x00\x03"
  b"\x00\x00=- ~~~~~~~~~\x00\x03"
  b"\x00\x00=-¤~~~~~~~~~\x00\x03"
  b"\x00\x00=-¥~~~~~~~~~\x00\x03"
  b"\x00\x00=-¦~~~~~~~~~\x00\x03"
  b"\x00\x00=-§~~~~~~~~~\x00\x03"
  b"\x00\x00=-¬~~~~~~~~~\x00\x03"
  b"\x00\x00=-±~~~~~~~~~\x00\x03"
  b"\x00\x00=-´~~~~~~~~~\x00\x03"
  b"\x00\x00=-µ~~~~~~~~~\x00\x03"
  b"\x00\x00=-·~~~~~~~~~\x00\x03"
  b"\x00\x00=-¹~~~~~~~~~\x00\x03"
  b"\x00\x00=-º~~~~~~~~~\x00\x03"
  b"\x00\x00=-»~~~~~~~~~\x00\x03"
  b"\x00\x00=-¼~~~~~~~~~\x00\x03"
  b"\x00\x00=-½~~~~~~~~~\x00\x03"
  b"\x00\x00=-¿~~~~~~~~~\x00\x03"
  b"\x00\x00=-À~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ã~~~~~~~~~\x00\x03"
  b"\x00\x00=-Æ~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ç~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ó~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ô~~~~~~~~~\x00\x03"
  b"\x00\x00=-Õ~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ö~~~~~~~~~\x00\x03"
  b"\x00\x00=-×~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ø~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ù~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ú~~~~~~~~~\x00\x03"
  b"\x00\x00=-Û~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ü~~~~~~~~~\x00\x03"
  b"\x00\x00=-Ý~~~~~~~~~\x00\x03"
  b"\x00\x00=-Þ~~~~~~~~~\x00\x03"
  b"\x00\x00=-ß~~~~~~~~~\x00\x03"
  b"\x00\x00=-à~~~~~~~~~\x00\x03"
  b"\x00\x00=-á~~~~~~~~~\x00\x03"
  b"\x00\x00=-â~~~~~~~~~\x00\x03"
  b"\x00\x00=-ã~~~~~~~~~\x00\x03"
  b"\x00\x00=-ä~~~~~~~~~\x00\x03"
  b"\x00\x00=-å~~~~~~~~~\x00\x03"
  "\x00\x00=.\x16~~~~~~~~~\x00\x03"
  "\x00\x00=.\x17~~~~~~~~~\x00\x03"
  "\x00\x00=.\x1E~~~~~~~~~\x00\x03"
  "\x00\x00=. ~~~~~~~~~\x00\x03"
  "\x00\x00=.!~~~~~~~~~\x00\x03"
  "\x00\x00=."~~~~~~~~~\x00\x03"
  "\x00\x00=.%~~~~~~~~~\x00\x03"
  "\x00\x00=.'~~~~~~~~~\x00\x03"
  "\x00\x00=.(~~~~~~~~~\x00\x03"
  "\x00\x00=.*~~~~~~~~~\x00\x03"
  "\x00\x00=.+~~~~~~~~~\x00\x03"
  "\x00\x00=.,~~~~~~~~~\x00\x03"
  "\x00\x00=.-~~~~~~~~~\x00\x03"
  "\x00\x00=..~~~~~~~~~\x00\x03"
  "\x00\x00=./~~~~~~~~~\x00\x03"
  "\x00\x00=.0~~~~~~~~~\x00\x03"
  "\x00\x00=.1~~~~~~~~~\x00\x03"
  "\x00\x00=.2~~~~~~~~~\x00\x03"
  "\x00\x00=.4~~~~~~~~~\x00\x03"
  "\x00\x00=.5~~~~~~~~~\x00\x03"
  "\x00\x00=.6~~~~~~~~~\x00\x03"
  "\x00\x00=.7~~~~~~~~~\x00\x03"
  "\x00\x00=.8~~~~~~~~~\x00\x03"
  "\x00\x00=.:~~~~~~~~~\x00\x03"
  "\x00\x00=.;~~~~~~~~~\x00\x03"
  "\x00\x00=.<~~~~~~~~~\x00\x03"
  "\x00\x00=.=~~~~~~~~~\x00\x03"
  "\x00\x00=.>~~~~~~~~~\x00\x03"
  "\x00\x00=.?~~~~~~~~~\x00\x03"
  "\x00\x00=.@~~~~~~~~~\x00\x03"
  "\x00\x00=.A~~~~~~~~~\x00\x03"
  "\x00\x00=.B~~~~~~~~~\x00\x03"
  "\x00\x00=.C~~~~~~~~~\x00\x03"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(p.id)
  ),
  pt.name
FROM
  product p
  INNER JOIN product pp ON pp.id = p.parent_id
  AND pp.version_id = ?
  INNER JOIN product_translation pt ON pp.id = pt.product_id
WHERE
  p.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND p.version_id = ?

SELECT LOWER(HEX(p.id)), pt.name
                FROM product p
                INNER JOIN product pp ON pp.id = p.parent_id AND pp.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425
                INNER JOIN product_translation pt ON pp.id = pt.product_id
                WHERE p.id IN ('\0\0=*Z~~~~~~~~~\0', '\0\0=*]~~~~~~~~~\0', '\0\0=*_~~~~~~~~~\0', '\0\0=*a~~~~~~~~~\0', '\0\0=*b~~~~~~~~~\0', '\0\0=*c~~~~~~~~~\0', '\0\0=*d~~~~~~~~~\0', '\0\0=*g~~~~~~~~~\0', '\0\0=*h~~~~~~~~~\0', '\0\0=*i~~~~~~~~~\0', '\0\0=*m~~~~~~~~~\0', '\0\0=*s~~~~~~~~~\0', '\0\0=*t~~~~~~~~~\0', '\0\0=*v~~~~~~~~~\0', '\0\0=*x~~~~~~~~~\0', '\0\0=*{~~~~~~~~~\0', '\0\0=*~~~~~~~~~~\0', 0x00003D2A807E7E7E7E7E7E7E7E7E0003, 0x00003D2A817E7E7E7E7E7E7E7E7E0003, 0x00003D2A827E7E7E7E7E7E7E7E7E0003, 0x00003D2A837E7E7E7E7E7E7E7E7E0003, 0x00003D2A847E7E7E7E7E7E7E7E7E0003, 0x00003D2A867E7E7E7E7E7E7E7E7E0003, 0x00003D2A877E7E7E7E7E7E7E7E7E0003, 0x00003D2A8A7E7E7E7E7E7E7E7E7E0003, 0x00003D2A8B7E7E7E7E7E7E7E7E7E0003, 0x00003D2A8C7E7E7E7E7E7E7E7E7E0003, 0x00003D2A917E7E7E7E7E7E7E7E7E0003, 0x00003D2A9A7E7E7E7E7E7E7E7E7E0003, 0x00003D2A9B7E7E7E7E7E7E7E7E7E0003, 0x00003D2A9C7E7E7E7E7E7E7E7E7E0003, 0x00003D2A9D7E7E7E7E7E7E7E7E7E0003, 0x00003D2A9E7E7E7E7E7E7E7E7E7E0003, 0x00003D2AA07E7E7E7E7E7E7E7E7E0003, 0x00003D2AA17E7E7E7E7E7E7E7E7E0003, 0x00003D2AA57E7E7E7E7E7E7E7E7E0003, 0x00003D2AA67E7E7E7E7E7E7E7E7E0003, 0x00003D2AA77E7E7E7E7E7E7E7E7E0003, 0x00003D2AAA7E7E7E7E7E7E7E7E7E0003, 0x00003D2AAD7E7E7E7E7E7E7E7E7E0003, 0x00003D2AB07E7E7E7E7E7E7E7E7E0003, 0x00003D2AB17E7E7E7E7E7E7E7E7E0003, 0x00003D2AB27E7E7E7E7E7E7E7E7E0003, 0x00003D2AB67E7E7E7E7E7E7E7E7E0003, 0x00003D2AB77E7E7E7E7E7E7E7E7E0003, 0x00003D2ABA7E7E7E7E7E7E7E7E7E0003, 0x00003D2ABB7E7E7E7E7E7E7E7E7E0003, 0x00003D2ABD7E7E7E7E7E7E7E7E7E0003, 0x00003D2ABF7E7E7E7E7E7E7E7E7E0003, 0x00003D2AC17E7E7E7E7E7E7E7E7E0003, 0x00003D2AC27E7E7E7E7E7E7E7E7E0003, 0x00003D2AC37E7E7E7E7E7E7E7E7E0003, 0x00003D2AC57E7E7E7E7E7E7E7E7E0003, 0x00003D2AC77E7E7E7E7E7E7E7E7E0003, 0x00003D2AC97E7E7E7E7E7E7E7E7E0003, 0x00003D2ACA7E7E7E7E7E7E7E7E7E0003, 0x00003D2ACD7E7E7E7E7E7E7E7E7E0003, 0x00003D2ACF7E7E7E7E7E7E7E7E7E0003, 0x00003D2AD07E7E7E7E7E7E7E7E7E0003, 0x00003D2AD17E7E7E7E7E7E7E7E7E0003, 0x00003D2AD27E7E7E7E7E7E7E7E7E0003, 0x00003D2AD37E7E7E7E7E7E7E7E7E0003, 0x00003D2AD47E7E7E7E7E7E7E7E7E0003, 0x00003D2AD67E7E7E7E7E7E7E7E7E0003, 0x00003D2AD77E7E7E7E7E7E7E7E7E0003, 0x00003D2AD87E7E7E7E7E7E7E7E7E0003, 0x00003D2AD97E7E7E7E7E7E7E7E7E0003, 0x00003D2ADA7E7E7E7E7E7E7E7E7E0003, 0x00003D2ADB7E7E7E7E7E7E7E7E7E0003, 0x00003D2ADC7E7E7E7E7E7E7E7E7E0003, 0x00003D2ADD7E7E7E7E7E7E7E7E7E0003, 0x00003D2AE07E7E7E7E7E7E7E7E7E0003, 0x00003D2AE17E7E7E7E7E7E7E7E7E0003, 0x00003D2AE27E7E7E7E7E7E7E7E7E0003, 0x00003D2AE37E7E7E7E7E7E7E7E7E0003, 0x00003D2AE47E7E7E7E7E7E7E7E7E0003, 0x00003D2AE87E7E7E7E7E7E7E7E7E0003, 0x00003D2AE97E7E7E7E7E7E7E7E7E0003, 0x00003D2AEC7E7E7E7E7E7E7E7E7E0003, 0x00003D2AED7E7E7E7E7E7E7E7E7E0003, 0x00003D2AF57E7E7E7E7E7E7E7E7E0003, 0x00003D2AFA7E7E7E7E7E7E7E7E7E0003, 0x00003D2AFC7E7E7E7E7E7E7E7E7E0003, 0x00003D2AFD7E7E7E7E7E7E7E7E7E0003, 0x00003D2AFE7E7E7E7E7E7E7E7E7E0003, '\0\0=+\0~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+
~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', '\0\0=+\"~~~~~~~~~\0', '\0\0=+#~~~~~~~~~\0', '\0\0=+$~~~~~~~~~\0', '\0\0=+(~~~~~~~~~\0', '\0\0=+*~~~~~~~~~\0', '\0\0=++~~~~~~~~~\0', '\0\0=+,~~~~~~~~~\0', '\0\0=+.~~~~~~~~~\0', '\0\0=+1~~~~~~~~~\0', '\0\0=+3~~~~~~~~~\0', '\0\0=+5~~~~~~~~~\0', '\0\0=+8~~~~~~~~~\0', '\0\0=+9~~~~~~~~~\0', '\0\0=+;~~~~~~~~~\0', '\0\0=+<~~~~~~~~~\0', '\0\0=+=~~~~~~~~~\0', '\0\0=+?~~~~~~~~~\0', '\0\0=+@~~~~~~~~~\0', '\0\0=+G~~~~~~~~~\0', '\0\0=+H~~~~~~~~~\0', '\0\0=+I~~~~~~~~~\0', '\0\0=+K~~~~~~~~~\0', '\0\0=+L~~~~~~~~~\0', '\0\0=+O~~~~~~~~~\0', '\0\0=+P~~~~~~~~~\0', '\0\0=+Q~~~~~~~~~\0', '\0\0=+R~~~~~~~~~\0', '\0\0=+T~~~~~~~~~\0', '\0\0=+U~~~~~~~~~\0', '\0\0=+V~~~~~~~~~\0', '\0\0=+W~~~~~~~~~\0', '\0\0=+X~~~~~~~~~\0', '\0\0=+Z~~~~~~~~~\0', '\0\0=+[~~~~~~~~~\0', '\0\0=+\\~~~~~~~~~\0', '\0\0=+]~~~~~~~~~\0', '\0\0=+^~~~~~~~~~\0', '\0\0=+_~~~~~~~~~\0', '\0\0=+`~~~~~~~~~\0', '\0\0=+a~~~~~~~~~\0', '\0\0=+b~~~~~~~~~\0', '\0\0=+c~~~~~~~~~\0', '\0\0=+e~~~~~~~~~\0', '\0\0=+f~~~~~~~~~\0', '\0\0=+g~~~~~~~~~\0', '\0\0=+h~~~~~~~~~\0', '\0\0=+i~~~~~~~~~\0', '\0\0=+k~~~~~~~~~\0', '\0\0=+l~~~~~~~~~\0', '\0\0=+n~~~~~~~~~\0', '\0\0=+o~~~~~~~~~\0', '\0\0=+p~~~~~~~~~\0', '\0\0=+q~~~~~~~~~\0', '\0\0=+r~~~~~~~~~\0', '\0\0=+s~~~~~~~~~\0', '\0\0=+u~~~~~~~~~\0', '\0\0=+x~~~~~~~~~\0', '\0\0=+y~~~~~~~~~\0', '\0\0=+|~~~~~~~~~\0', '\0\0=+}~~~~~~~~~\0', '\0\0=+~~~~~~~~~~\0', '\0\0=+~~~~~~~~~\0', 0x00003D2B807E7E7E7E7E7E7E7E7E0003, 0x00003D2B817E7E7E7E7E7E7E7E7E0003, 0x00003D2B827E7E7E7E7E7E7E7E7E0003, 0x00003D2B837E7E7E7E7E7E7E7E7E0003, 0x00003D2B847E7E7E7E7E7E7E7E7E0003, 0x00003D2B857E7E7E7E7E7E7E7E7E0003, 0x00003D2B867E7E7E7E7E7E7E7E7E0003, 0x00003D2B877E7E7E7E7E7E7E7E7E0003, 0x00003D2B897E7E7E7E7E7E7E7E7E0003, 0x00003D2B8A7E7E7E7E7E7E7E7E7E0003, 0x00003D2B8B7E7E7E7E7E7E7E7E7E0003, 0x00003D2B8C7E7E7E7E7E7E7E7E7E0003, 0x00003D2B8E7E7E7E7E7E7E7E7E7E0003, 0x00003D2B8F7E7E7E7E7E7E7E7E7E0003, 0x00003D2B907E7E7E7E7E7E7E7E7E0003, 0x00003D2B917E7E7E7E7E7E7E7E7E0003, 0x00003D2B927E7E7E7E7E7E7E7E7E0003, 0x00003D2B937E7E7E7E7E7E7E7E7E0003, 0x00003D2B947E7E7E7E7E7E7E7E7E0003, 0x00003D2B957E7E7E7E7E7E7E7E7E0003, 0x00003D2B967E7E7E7E7E7E7E7E7E0003, 0x00003D2B987E7E7E7E7E7E7E7E7E0003, 0x00003D2B997E7E7E7E7E7E7E7E7E0003, 0x00003D2B9A7E7E7E7E7E7E7E7E7E0003, 0x00003D2BA07E7E7E7E7E7E7E7E7E0003, 0x00003D2BA17E7E7E7E7E7E7E7E7E0003, 0x00003D2BA27E7E7E7E7E7E7E7E7E0003, 0x00003D2BA47E7E7E7E7E7E7E7E7E0003, 0x00003D2BA67E7E7E7E7E7E7E7E7E0003, 0x00003D2BA77E7E7E7E7E7E7E7E7E0003, 0x00003D2BAA7E7E7E7E7E7E7E7E7E0003, 0x00003D2BAB7E7E7E7E7E7E7E7E7E0003, 0x00003D2BAE7E7E7E7E7E7E7E7E7E0003, 0x00003D2BAF7E7E7E7E7E7E7E7E7E0003, 0x00003D2BB07E7E7E7E7E7E7E7E7E0003, 0x00003D2BC37E7E7E7E7E7E7E7E7E0003, 0x00003D2BD37E7E7E7E7E7E7E7E7E0003, 0x00003D2BF07E7E7E7E7E7E7E7E7E0003, 0x00003D2BF17E7E7E7E7E7E7E7E7E0003, 0x00003D2BF27E7E7E7E7E7E7E7E7E0003, 0x00003D2BF77E7E7E7E7E7E7E7E7E0003, 0x00003D2BF87E7E7E7E7E7E7E7E7E0003, 0x00003D2BFF7E7E7E7E7E7E7E7E7E0003, '\0\0=,\0~~~~~~~~~\0', '\0\0=,~~~~~~~~~\0', '\0\0=,~~~~~~~~~\0', '\0\0=,$~~~~~~~~~\0', '\0\0=,&~~~~~~~~~\0', '\0\0=,\'~~~~~~~~~\0', '\0\0=,,~~~~~~~~~\0', '\0\0=,-~~~~~~~~~\0', '\0\0=,1~~~~~~~~~\0', '\0\0=,2~~~~~~~~~\0', '\0\0=,3~~~~~~~~~\0', '\0\0=,4~~~~~~~~~\0', '\0\0=,6~~~~~~~~~\0', '\0\0=,9~~~~~~~~~\0', '\0\0=,:~~~~~~~~~\0', '\0\0=,=~~~~~~~~~\0', '\0\0=,>~~~~~~~~~\0', '\0\0=,?~~~~~~~~~\0', '\0\0=,@~~~~~~~~~\0', '\0\0=,B~~~~~~~~~\0', '\0\0=,C~~~~~~~~~\0', '\0\0=,D~~~~~~~~~\0', '\0\0=,F~~~~~~~~~\0', '\0\0=,J~~~~~~~~~\0', '\0\0=,K~~~~~~~~~\0', '\0\0=,L~~~~~~~~~\0', '\0\0=,O~~~~~~~~~\0', '\0\0=,P~~~~~~~~~\0', '\0\0=,Q~~~~~~~~~\0', '\0\0=,S~~~~~~~~~\0', '\0\0=,T~~~~~~~~~\0', '\0\0=,U~~~~~~~~~\0', '\0\0=,V~~~~~~~~~\0', '\0\0=,W~~~~~~~~~\0', '\0\0=,X~~~~~~~~~\0', '\0\0=,Y~~~~~~~~~\0', '\0\0=,Z~~~~~~~~~\0', '\0\0=,[~~~~~~~~~\0', '\0\0=,\\~~~~~~~~~\0', '\0\0=,z~~~~~~~~~\0', '\0\0=,~~~~~~~~~\0', 0x00003D2C8D7E7E7E7E7E7E7E7E7E0003, 0x00003D2C8E7E7E7E7E7E7E7E7E7E0003, 0x00003D2C8F7E7E7E7E7E7E7E7E7E0003, 0x00003D2C907E7E7E7E7E7E7E7E7E0003, 0x00003D2C927E7E7E7E7E7E7E7E7E0003, 0x00003D2C947E7E7E7E7E7E7E7E7E0003, 0x00003D2C967E7E7E7E7E7E7E7E7E0003, 0x00003D2C977E7E7E7E7E7E7E7E7E0003, 0x00003D2C997E7E7E7E7E7E7E7E7E0003, 0x00003D2C9A7E7E7E7E7E7E7E7E7E0003, 0x00003D2CA07E7E7E7E7E7E7E7E7E0003, 0x00003D2CA17E7E7E7E7E7E7E7E7E0003, 0x00003D2CA27E7E7E7E7E7E7E7E7E0003, 0x00003D2CA37E7E7E7E7E7E7E7E7E0003, 0x00003D2CA47E7E7E7E7E7E7E7E7E0003, 0x00003D2CA57E7E7E7E7E7E7E7E7E0003, 0x00003D2CA67E7E7E7E7E7E7E7E7E0003, 0x00003D2CA97E7E7E7E7E7E7E7E7E0003, 0x00003D2CAA7E7E7E7E7E7E7E7E7E0003, 0x00003D2CAD7E7E7E7E7E7E7E7E7E0003, 0x00003D2CAE7E7E7E7E7E7E7E7E7E0003, 0x00003D2CAF7E7E7E7E7E7E7E7E7E0003, 0x00003D2CB17E7E7E7E7E7E7E7E7E0003, 0x00003D2CB27E7E7E7E7E7E7E7E7E0003, 0x00003D2CB67E7E7E7E7E7E7E7E7E0003, 0x00003D2CBD7E7E7E7E7E7E7E7E7E0003, 0x00003D2CBE7E7E7E7E7E7E7E7E7E0003, 0x00003D2CC17E7E7E7E7E7E7E7E7E0003, 0x00003D2CC57E7E7E7E7E7E7E7E7E0003, 0x00003D2CC67E7E7E7E7E7E7E7E7E0003, 0x00003D2CD47E7E7E7E7E7E7E7E7E0003, 0x00003D2CD57E7E7E7E7E7E7E7E7E0003, 0x00003D2CD67E7E7E7E7E7E7E7E7E0003, 0x00003D2CD77E7E7E7E7E7E7E7E7E0003, 0x00003D2CD87E7E7E7E7E7E7E7E7E0003, 0x00003D2CD97E7E7E7E7E7E7E7E7E0003, 0x00003D2CDB7E7E7E7E7E7E7E7E7E0003, 0x00003D2CDD7E7E7E7E7E7E7E7E7E0003, 0x00003D2CDE7E7E7E7E7E7E7E7E7E0003, 0x00003D2CE27E7E7E7E7E7E7E7E7E0003, 0x00003D2CE67E7E7E7E7E7E7E7E7E0003, 0x00003D2CE77E7E7E7E7E7E7E7E7E0003, 0x00003D2CE87E7E7E7E7E7E7E7E7E0003, 0x00003D2CE97E7E7E7E7E7E7E7E7E0003, 0x00003D2CEA7E7E7E7E7E7E7E7E7E0003, 0x00003D2CEB7E7E7E7E7E7E7E7E7E0003, 0x00003D2CEC7E7E7E7E7E7E7E7E7E0003, 0x00003D2CED7E7E7E7E7E7E7E7E7E0003, 0x00003D2CEE7E7E7E7E7E7E7E7E7E0003, 0x00003D2CEF7E7E7E7E7E7E7E7E7E0003, 0x00003D2CF07E7E7E7E7E7E7E7E7E0003, 0x00003D2CF17E7E7E7E7E7E7E7E7E0003, 0x00003D2CF27E7E7E7E7E7E7E7E7E0003, 0x00003D2CF37E7E7E7E7E7E7E7E7E0003, 0x00003D2CF47E7E7E7E7E7E7E7E7E0003, 0x00003D2CF57E7E7E7E7E7E7E7E7E0003, 0x00003D2CF67E7E7E7E7E7E7E7E7E0003, 0x00003D2CF77E7E7E7E7E7E7E7E7E0003, 0x00003D2CF87E7E7E7E7E7E7E7E7E0003, 0x00003D2CF97E7E7E7E7E7E7E7E7E0003, 0x00003D2CFA7E7E7E7E7E7E7E7E7E0003, 0x00003D2CFB7E7E7E7E7E7E7E7E7E0003, 0x00003D2CFC7E7E7E7E7E7E7E7E7E0003, 0x00003D2CFD7E7E7E7E7E7E7E7E7E0003, 0x00003D2CFE7E7E7E7E7E7E7E7E7E0003, 0x00003D2CFF7E7E7E7E7E7E7E7E7E0003, '\0\0=-\0~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-	~~~~~~~~~\0', '\0\0=-
~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-
~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', '\0\0=- ~~~~~~~~~\0', '\0\0=-!~~~~~~~~~\0', '\0\0=-\"~~~~~~~~~\0', '\0\0=-#~~~~~~~~~\0', '\0\0=-$~~~~~~~~~\0', '\0\0=-%~~~~~~~~~\0', '\0\0=-&~~~~~~~~~\0', '\0\0=-\'~~~~~~~~~\0', '\0\0=-(~~~~~~~~~\0', '\0\0=-)~~~~~~~~~\0', '\0\0=-*~~~~~~~~~\0', '\0\0=-+~~~~~~~~~\0', '\0\0=-0~~~~~~~~~\0', '\0\0=-4~~~~~~~~~\0', '\0\0=-5~~~~~~~~~\0', '\0\0=-6~~~~~~~~~\0', '\0\0=-7~~~~~~~~~\0', '\0\0=-8~~~~~~~~~\0', '\0\0=-9~~~~~~~~~\0', '\0\0=-:~~~~~~~~~\0', '\0\0=-=~~~~~~~~~\0', '\0\0=->~~~~~~~~~\0', '\0\0=-?~~~~~~~~~\0', '\0\0=-@~~~~~~~~~\0', '\0\0=-A~~~~~~~~~\0', '\0\0=-F~~~~~~~~~\0', '\0\0=-G~~~~~~~~~\0', '\0\0=-M~~~~~~~~~\0', '\0\0=-P~~~~~~~~~\0', '\0\0=-Q~~~~~~~~~\0', '\0\0=-f~~~~~~~~~\0', '\0\0=-g~~~~~~~~~\0', '\0\0=-h~~~~~~~~~\0', '\0\0=-i~~~~~~~~~\0', '\0\0=-j~~~~~~~~~\0', '\0\0=-k~~~~~~~~~\0', '\0\0=-o~~~~~~~~~\0', '\0\0=-p~~~~~~~~~\0', '\0\0=-q~~~~~~~~~\0', '\0\0=-r~~~~~~~~~\0', '\0\0=-t~~~~~~~~~\0', '\0\0=-u~~~~~~~~~\0', '\0\0=-v~~~~~~~~~\0', '\0\0=-w~~~~~~~~~\0', '\0\0=-x~~~~~~~~~\0', '\0\0=-y~~~~~~~~~\0', '\0\0=-z~~~~~~~~~\0', '\0\0=-{~~~~~~~~~\0', '\0\0=-|~~~~~~~~~\0', '\0\0=-}~~~~~~~~~\0', '\0\0=-~~~~~~~~~~\0', '\0\0=-~~~~~~~~~\0', 0x00003D2D807E7E7E7E7E7E7E7E7E0003, 0x00003D2D817E7E7E7E7E7E7E7E7E0003, 0x00003D2D827E7E7E7E7E7E7E7E7E0003, 0x00003D2D837E7E7E7E7E7E7E7E7E0003, 0x00003D2D847E7E7E7E7E7E7E7E7E0003, 0x00003D2D857E7E7E7E7E7E7E7E7E0003, 0x00003D2D867E7E7E7E7E7E7E7E7E0003, 0x00003D2D877E7E7E7E7E7E7E7E7E0003, 0x00003D2D887E7E7E7E7E7E7E7E7E0003, 0x00003D2D897E7E7E7E7E7E7E7E7E0003, 0x00003D2D8A7E7E7E7E7E7E7E7E7E0003, 0x00003D2D8B7E7E7E7E7E7E7E7E7E0003, 0x00003D2D8C7E7E7E7E7E7E7E7E7E0003, 0x00003D2D8D7E7E7E7E7E7E7E7E7E0003, 0x00003D2D8E7E7E7E7E7E7E7E7E7E0003, 0x00003D2D8F7E7E7E7E7E7E7E7E7E0003, 0x00003D2D907E7E7E7E7E7E7E7E7E0003, 0x00003D2D917E7E7E7E7E7E7E7E7E0003, 0x00003D2D927E7E7E7E7E7E7E7E7E0003, 0x00003D2D937E7E7E7E7E7E7E7E7E0003, 0x00003D2D947E7E7E7E7E7E7E7E7E0003, 0x00003D2D957E7E7E7E7E7E7E7E7E0003, 0x00003D2D967E7E7E7E7E7E7E7E7E0003, 0x00003D2D977E7E7E7E7E7E7E7E7E0003, 0x00003D2D987E7E7E7E7E7E7E7E7E0003, 0x00003D2D997E7E7E7E7E7E7E7E7E0003, 0x00003D2D9A7E7E7E7E7E7E7E7E7E0003, 0x00003D2D9B7E7E7E7E7E7E7E7E7E0003, 0x00003D2D9C7E7E7E7E7E7E7E7E7E0003, 0x00003D2D9D7E7E7E7E7E7E7E7E7E0003, 0x00003D2D9E7E7E7E7E7E7E7E7E7E0003, 0x00003D2D9F7E7E7E7E7E7E7E7E7E0003, 0x00003D2DA07E7E7E7E7E7E7E7E7E0003, 0x00003D2DA47E7E7E7E7E7E7E7E7E0003, 0x00003D2DA57E7E7E7E7E7E7E7E7E0003, 0x00003D2DA67E7E7E7E7E7E7E7E7E0003, 0x00003D2DA77E7E7E7E7E7E7E7E7E0003, 0x00003D2DAC7E7E7E7E7E7E7E7E7E0003, 0x00003D2DB17E7E7E7E7E7E7E7E7E0003, 0x00003D2DB47E7E7E7E7E7E7E7E7E0003, 0x00003D2DB57E7E7E7E7E7E7E7E7E0003, 0x00003D2DB77E7E7E7E7E7E7E7E7E0003, 0x00003D2DB97E7E7E7E7E7E7E7E7E0003, 0x00003D2DBA7E7E7E7E7E7E7E7E7E0003, 0x00003D2DBB7E7E7E7E7E7E7E7E7E0003, 0x00003D2DBC7E7E7E7E7E7E7E7E7E0003, 0x00003D2DBD7E7E7E7E7E7E7E7E7E0003, 0x00003D2DBF7E7E7E7E7E7E7E7E7E0003, 0x00003D2DC07E7E7E7E7E7E7E7E7E0003, 0x00003D2DC37E7E7E7E7E7E7E7E7E0003, 0x00003D2DC67E7E7E7E7E7E7E7E7E0003, 0x00003D2DC77E7E7E7E7E7E7E7E7E0003, 0x00003D2DD37E7E7E7E7E7E7E7E7E0003, 0x00003D2DD47E7E7E7E7E7E7E7E7E0003, 0x00003D2DD57E7E7E7E7E7E7E7E7E0003, 0x00003D2DD67E7E7E7E7E7E7E7E7E0003, 0x00003D2DD77E7E7E7E7E7E7E7E7E0003, 0x00003D2DD87E7E7E7E7E7E7E7E7E0003, 0x00003D2DD97E7E7E7E7E7E7E7E7E0003, 0x00003D2DDA7E7E7E7E7E7E7E7E7E0003, 0x00003D2DDB7E7E7E7E7E7E7E7E7E0003, 0x00003D2DDC7E7E7E7E7E7E7E7E7E0003, 0x00003D2DDD7E7E7E7E7E7E7E7E7E0003, 0x00003D2DDE7E7E7E7E7E7E7E7E7E0003, 0x00003D2DDF7E7E7E7E7E7E7E7E7E0003, 0x00003D2DE07E7E7E7E7E7E7E7E7E0003, 0x00003D2DE17E7E7E7E7E7E7E7E7E0003, 0x00003D2DE27E7E7E7E7E7E7E7E7E0003, 0x00003D2DE37E7E7E7E7E7E7E7E7E0003, 0x00003D2DE47E7E7E7E7E7E7E7E7E0003, 0x00003D2DE57E7E7E7E7E7E7E7E7E0003, '\0\0=.~~~~~~~~~\0', '\0\0=.~~~~~~~~~\0', '\0\0=.~~~~~~~~~\0', '\0\0=. ~~~~~~~~~\0', '\0\0=.!~~~~~~~~~\0', '\0\0=.\"~~~~~~~~~\0', '\0\0=.%~~~~~~~~~\0', '\0\0=.\'~~~~~~~~~\0', '\0\0=.(~~~~~~~~~\0', '\0\0=.*~~~~~~~~~\0', '\0\0=.+~~~~~~~~~\0', '\0\0=.,~~~~~~~~~\0', '\0\0=.-~~~~~~~~~\0', '\0\0=..~~~~~~~~~\0', '\0\0=./~~~~~~~~~\0', '\0\0=.0~~~~~~~~~\0', '\0\0=.1~~~~~~~~~\0', '\0\0=.2~~~~~~~~~\0', '\0\0=.4~~~~~~~~~\0', '\0\0=.5~~~~~~~~~\0', '\0\0=.6~~~~~~~~~\0', '\0\0=.7~~~~~~~~~\0', '\0\0=.8~~~~~~~~~\0', '\0\0=.:~~~~~~~~~\0', '\0\0=.;~~~~~~~~~\0', '\0\0=.<~~~~~~~~~\0', '\0\0=.=~~~~~~~~~\0', '\0\0=.>~~~~~~~~~\0', '\0\0=.?~~~~~~~~~\0', '\0\0=.@~~~~~~~~~\0', '\0\0=.A~~~~~~~~~\0', '\0\0=.B~~~~~~~~~\0', '\0\0=.C~~~~~~~~~\0') AND p.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 638)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 43)
3	NetInventors\NetiNextAdminTools\Subscriber\ProductSubscriber->onProductLoaded (line 246)
4	Symfony\Component\EventDispatcher\EventDispatcher::{closure:Symfony\Component\EventDispatcher\EventDispatcher::optimizeListeners():241} (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
7	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 27)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 215)
13	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 251)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
15	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 264)
16	Shopware\Core\Framework\Api\Controller\ApiController->{closure:Shopware\Core\Framework\Api\Controller\ApiController::search():264} (line 201)
17	Shopware\Core\Framework\Context->scope (line 264)
18	Shopware\Core\Framework\Api\Controller\ApiController->search (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 10)

0.54 ms
(0.07%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.54 ms
(0.07%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.50 ms
(0.07%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.48 ms
(0.07%)

SELECT item_rounding FROM currency WHERE id = ?

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

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

0.37 ms
(0.05%)

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

Parameters:

[
  b"\x0EÎ•;ûf@ãªa“VSèCé"
]

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

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

0.30 ms
(0.04%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 638)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 132)
3	Shopware\Core\System\CustomField\CustomFieldService->getCustomFields (line 54)
4	Shopware\Core\System\CustomField\CustomFieldService->getCustomField (line 101)
5	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->getFields (line 86)
6	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->decode (line 326)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->translate (line 187)
8	Shopware\Core\Content\Product\ProductHydrator->assign (line 37)
9	RhiemManufacturerCloseout\Core\Content\Product\ProductHydratorDecorator->assign (line 590)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateEntity (line 383)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->manyToOne (line 36)
12	Shopware\Core\Content\Product\Aggregate\ProductVisibility\ProductVisibilityHydrator->assign (line 590)
13	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateEntity (line 95)
14	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrate (line 135)
15	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
16	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
17	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 251)
18	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
19	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 264)
20	Shopware\Core\Framework\Api\Controller\ApiController->{closure:Shopware\Core\Framework\Api\Controller\ApiController::search():264} (line 201)
21	Shopware\Core\Framework\Context->scope (line 264)
22	Shopware\Core\Framework\Api\Controller\ApiController->search (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 268)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->pass (line 282)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate (line 202)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 10)

0.24 ms
(0.03%)

SELECT id FROM integration WHERE access_key = ?

Parameters:

[
  "SWIABE5TNKPHBXJ1UGVHNU1UZW"
]

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

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

Database Connections

Name	Service
0	default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

POST https://sw6staging.behr-labor.eu/api/search/product-visibility

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache