Symfony Profiler

Query Metrics

11 Database Queries

11 Different statements

935.93 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

744.29 ms
(79.52%)

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-22"
  "2026-01-22"
  "2026-01-22"
  "2026-01-22"
]

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-22') OR (`product_visibility.product`.`updated_at` >= '2026-01-22') OR (`product_visibility`.`created_at` >= '2026-01-22') OR (`product_visibility`.`updated_at` >= '2026-01-22')))) total;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
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)

167.40 ms
(17.89%)

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 32000

Parameters:

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

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
  32000

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-22') OR (`product_visibility.product`.`updated_at` >= '2026-01-22') OR (`product_visibility`.`created_at` >= '2026-01-22') OR (`product_visibility`.`updated_at` >= '2026-01-22'))) LIMIT 500 OFFSET 32000;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
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)

15.13 ms
(1.62%)

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"
  b"\x00\x00G.ø~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G.ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G.ú~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G.û~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G.ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G.þ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G.ÿ~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x00~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x01~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x02~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x03~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x04~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x05~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x06~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x07~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x08~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\t~~~~~~~~\x7F\x00\x03"
  """
    \x00\x00G/\n
    ~~~~~~~~\x7F\x00\x03
    """
  "\x00\x00G/\v~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\f~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x0F~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x10~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x12~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x14~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x1D~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x1E~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/\x1F~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/ ~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/#~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/%~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/'~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/)~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/*~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/+~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/,~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/-~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/.~~~~~~~~\x7F\x00\x03"
  "\x00\x00G//~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/0~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/1~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/2~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/3~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/4~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/5~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/6~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/7~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/8~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/9~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/:~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/<~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/=~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/?~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/@~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/C~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/D~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/E~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/F~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/G~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/H~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/J~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/L~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/M~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/N~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/P~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/Q~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/S~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/T~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/U~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/V~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/W~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/Z~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/]~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/^~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/_~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/`~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/a~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/c~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/d~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/e~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/g~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/i~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/j~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/k~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/l~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/m~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/n~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/o~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/q~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/r~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/s~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/u~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/v~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/w~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/x~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/y~~~~~~~~\x7F\x00\x03"
  "\x00\x00G/z~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/—~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/˜~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/™~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/œ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ÿ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¡~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/£~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¤~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/§~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¨~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/©~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ª~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/«~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¬~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/®~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/²~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/³~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/´~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/µ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¶~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¸~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¹~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/º~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/»~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¼~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/¾~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Â~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ã~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ä~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Å~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Æ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ç~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/È~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/É~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ê~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ë~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ñ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ó~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Õ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ú~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/Ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/à~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ä~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/å~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/æ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ç~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/è~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/é~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ê~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ë~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ì~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/í~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/î~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ï~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ð~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ñ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ò~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ó~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ô~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/õ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ö~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/÷~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ø~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ú~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/û~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ü~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/þ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G/ÿ~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x00~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x01~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x02~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x03~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x04~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x05~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x06~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x07~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x08~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\t~~~~~~~~\x7F\x00\x03"
  """
    \x00\x00G0\n
    ~~~~~~~~\x7F\x00\x03
    """
  "\x00\x00G0\v~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\r~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x0E~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x0F~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x10~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x11~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x12~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x13~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x14~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x15~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x19~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\e~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x1E~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\x1F~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0"~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0$~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0%~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0&~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0'~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0(~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0)~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0*~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0,~~~~~~~~\x7F\x00\x03"
  "\x00\x00G00~~~~~~~~\x7F\x00\x03"
  "\x00\x00G01~~~~~~~~\x7F\x00\x03"
  "\x00\x00G02~~~~~~~~\x7F\x00\x03"
  "\x00\x00G03~~~~~~~~\x7F\x00\x03"
  "\x00\x00G04~~~~~~~~\x7F\x00\x03"
  "\x00\x00G05~~~~~~~~\x7F\x00\x03"
  "\x00\x00G06~~~~~~~~\x7F\x00\x03"
  "\x00\x00G07~~~~~~~~\x7F\x00\x03"
  "\x00\x00G08~~~~~~~~\x7F\x00\x03"
  "\x00\x00G09~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0:~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0;~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0<~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0>~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0?~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0@~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0A~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0B~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0D~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0G~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0I~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0J~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0K~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0L~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0M~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0N~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0O~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0P~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0S~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0U~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0V~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0W~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0X~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0Y~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0Z~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0[~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0\~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0_~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0`~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0a~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0b~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0c~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0d~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0e~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0f~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0g~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0h~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0i~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0j~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0k~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0l~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0m~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0n~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0p~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0q~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0r~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0s~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0t~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0u~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0v~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0y~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0{~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0|~~~~~~~~\x7F\x00\x03"
  "\x00\x00G0}~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0€~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ƒ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0„~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0…~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0†~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0‡~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ˆ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0‘~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0’~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0“~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0”~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0•~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0–~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0—~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0˜~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0›~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0œ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0 ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¢~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¤~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¥~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¦~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0§~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0«~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¬~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0®~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¯~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0±~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0²~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0µ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¶~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0·~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¸~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¹~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0º~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0»~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¼~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0½~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¾~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0¿~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0À~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Á~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Â~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ã~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ä~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Æ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ç~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0È~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0É~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ê~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ë~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ì~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Í~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Î~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ï~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ð~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ñ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ò~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ó~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Õ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ö~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0×~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ø~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ú~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Û~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ü~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0Ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ß~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0á~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ã~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ä~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0å~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ç~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0è~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0é~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ê~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ë~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ì~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0í~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0î~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ï~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ð~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ñ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ò~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ó~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0õ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ö~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0÷~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ù~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0û~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ü~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0ý~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G0þ~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x00~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x01~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x02~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x03~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x04~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x05~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x06~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x07~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\t~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\v~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\f~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\r~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x12~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x13~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x14~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x15~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x16~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x17~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x18~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x19~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x1A~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\e~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x1C~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x1D~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x1E~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x1F~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1!~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1"~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1%~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1&~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1(~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1)~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1*~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1+~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1,~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1-~~~~~~~~\x7F\x00\x03"
  "\x00\x00G12~~~~~~~~\x7F\x00\x03"
  "\x00\x00G13~~~~~~~~\x7F\x00\x03"
  "\x00\x00G14~~~~~~~~\x7F\x00\x03"
  "\x00\x00G16~~~~~~~~\x7F\x00\x03"
  "\x00\x00G17~~~~~~~~\x7F\x00\x03"
  "\x00\x00G18~~~~~~~~\x7F\x00\x03"
  "\x00\x00G19~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1:~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1;~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1<~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1=~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1?~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1@~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1A~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1B~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1C~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1E~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1F~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1G~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1H~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1I~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1J~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1K~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1L~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1M~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1O~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1R~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1S~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1U~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1V~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1W~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1X~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1Y~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1Z~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1[~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1]~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1^~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1_~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1`~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1a~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1b~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1c~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1d~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1e~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1f~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1g~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1h~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1i~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1l~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1m~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1n~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1o~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1p~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1q~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1r~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1s~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1t~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1u~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1v~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1w~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1x~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1y~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1z~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1{~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1|~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1}~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1~~~~~~~~~\x7F\x00\x03"
  "\x00\x00G1\x7F~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1€~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1‚~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1ƒ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1„~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1…~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1†~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1ˆ~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1‰~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1Š~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1‹~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1Ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1Ž~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1‘~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1’~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1“~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1”~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1•~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1–~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1—~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1˜~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1™~~~~~~~~\x7F\x00\x03"
  b"\x00\x00G1š~~~~~~~~\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 (0x0000472EF87E7E7E7E7E7E7E7E7F0003, 0x0000472EF97E7E7E7E7E7E7E7E7F0003, 0x0000472EFA7E7E7E7E7E7E7E7E7F0003, 0x0000472EFB7E7E7E7E7E7E7E7E7F0003, 0x0000472EFD7E7E7E7E7E7E7E7E7F0003, 0x0000472EFE7E7E7E7E7E7E7E7E7F0003, 0x0000472EFF7E7E7E7E7E7E7E7E7F0003, '\0\0G/\0~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/	~~~~~~~~\0', '\0\0G/
~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/~~~~~~~~\0', '\0\0G/ ~~~~~~~~\0', '\0\0G/#~~~~~~~~\0', '\0\0G/%~~~~~~~~\0', '\0\0G/\'~~~~~~~~\0', '\0\0G/)~~~~~~~~\0', '\0\0G/*~~~~~~~~\0', '\0\0G/+~~~~~~~~\0', '\0\0G/,~~~~~~~~\0', '\0\0G/-~~~~~~~~\0', '\0\0G/.~~~~~~~~\0', '\0\0G//~~~~~~~~\0', '\0\0G/0~~~~~~~~\0', '\0\0G/1~~~~~~~~\0', '\0\0G/2~~~~~~~~\0', '\0\0G/3~~~~~~~~\0', '\0\0G/4~~~~~~~~\0', '\0\0G/5~~~~~~~~\0', '\0\0G/6~~~~~~~~\0', '\0\0G/7~~~~~~~~\0', '\0\0G/8~~~~~~~~\0', '\0\0G/9~~~~~~~~\0', '\0\0G/:~~~~~~~~\0', '\0\0G/<~~~~~~~~\0', '\0\0G/=~~~~~~~~\0', '\0\0G/?~~~~~~~~\0', '\0\0G/@~~~~~~~~\0', '\0\0G/C~~~~~~~~\0', '\0\0G/D~~~~~~~~\0', '\0\0G/E~~~~~~~~\0', '\0\0G/F~~~~~~~~\0', '\0\0G/G~~~~~~~~\0', '\0\0G/H~~~~~~~~\0', '\0\0G/J~~~~~~~~\0', '\0\0G/L~~~~~~~~\0', '\0\0G/M~~~~~~~~\0', '\0\0G/N~~~~~~~~\0', '\0\0G/P~~~~~~~~\0', '\0\0G/Q~~~~~~~~\0', '\0\0G/S~~~~~~~~\0', '\0\0G/T~~~~~~~~\0', '\0\0G/U~~~~~~~~\0', '\0\0G/V~~~~~~~~\0', '\0\0G/W~~~~~~~~\0', '\0\0G/Z~~~~~~~~\0', '\0\0G/]~~~~~~~~\0', '\0\0G/^~~~~~~~~\0', '\0\0G/_~~~~~~~~\0', '\0\0G/`~~~~~~~~\0', '\0\0G/a~~~~~~~~\0', '\0\0G/c~~~~~~~~\0', '\0\0G/d~~~~~~~~\0', '\0\0G/e~~~~~~~~\0', '\0\0G/g~~~~~~~~\0', '\0\0G/i~~~~~~~~\0', '\0\0G/j~~~~~~~~\0', '\0\0G/k~~~~~~~~\0', '\0\0G/l~~~~~~~~\0', '\0\0G/m~~~~~~~~\0', '\0\0G/n~~~~~~~~\0', '\0\0G/o~~~~~~~~\0', '\0\0G/q~~~~~~~~\0', '\0\0G/r~~~~~~~~\0', '\0\0G/s~~~~~~~~\0', '\0\0G/u~~~~~~~~\0', '\0\0G/v~~~~~~~~\0', '\0\0G/w~~~~~~~~\0', '\0\0G/x~~~~~~~~\0', '\0\0G/y~~~~~~~~\0', '\0\0G/z~~~~~~~~\0', 0x0000472F977E7E7E7E7E7E7E7E7F0003, 0x0000472F987E7E7E7E7E7E7E7E7F0003, 0x0000472F997E7E7E7E7E7E7E7E7F0003, 0x0000472F9C7E7E7E7E7E7E7E7E7F0003, 0x0000472F9E7E7E7E7E7E7E7E7E7F0003, 0x0000472F9F7E7E7E7E7E7E7E7E7F0003, 0x0000472FA07E7E7E7E7E7E7E7E7F0003, 0x0000472FA17E7E7E7E7E7E7E7E7F0003, 0x0000472FA37E7E7E7E7E7E7E7E7F0003, 0x0000472FA47E7E7E7E7E7E7E7E7F0003, 0x0000472FA77E7E7E7E7E7E7E7E7F0003, 0x0000472FA87E7E7E7E7E7E7E7E7F0003, 0x0000472FA97E7E7E7E7E7E7E7E7F0003, 0x0000472FAA7E7E7E7E7E7E7E7E7F0003, 0x0000472FAB7E7E7E7E7E7E7E7E7F0003, 0x0000472FAC7E7E7E7E7E7E7E7E7F0003, 0x0000472FAD7E7E7E7E7E7E7E7E7F0003, 0x0000472FAE7E7E7E7E7E7E7E7E7F0003, 0x0000472FB27E7E7E7E7E7E7E7E7F0003, 0x0000472FB37E7E7E7E7E7E7E7E7F0003, 0x0000472FB47E7E7E7E7E7E7E7E7F0003, 0x0000472FB57E7E7E7E7E7E7E7E7F0003, 0x0000472FB67E7E7E7E7E7E7E7E7F0003, 0x0000472FB87E7E7E7E7E7E7E7E7F0003, 0x0000472FB97E7E7E7E7E7E7E7E7F0003, 0x0000472FBA7E7E7E7E7E7E7E7E7F0003, 0x0000472FBB7E7E7E7E7E7E7E7E7F0003, 0x0000472FBC7E7E7E7E7E7E7E7E7F0003, 0x0000472FBE7E7E7E7E7E7E7E7E7F0003, 0x0000472FC27E7E7E7E7E7E7E7E7F0003, 0x0000472FC37E7E7E7E7E7E7E7E7F0003, 0x0000472FC47E7E7E7E7E7E7E7E7F0003, 0x0000472FC57E7E7E7E7E7E7E7E7F0003, 0x0000472FC67E7E7E7E7E7E7E7E7F0003, 0x0000472FC77E7E7E7E7E7E7E7E7F0003, 0x0000472FC87E7E7E7E7E7E7E7E7F0003, 0x0000472FC97E7E7E7E7E7E7E7E7F0003, 0x0000472FCA7E7E7E7E7E7E7E7E7F0003, 0x0000472FCB7E7E7E7E7E7E7E7E7F0003, 0x0000472FD17E7E7E7E7E7E7E7E7F0003, 0x0000472FD37E7E7E7E7E7E7E7E7F0003, 0x0000472FD57E7E7E7E7E7E7E7E7F0003, 0x0000472FD97E7E7E7E7E7E7E7E7F0003, 0x0000472FDA7E7E7E7E7E7E7E7E7F0003, 0x0000472FDD7E7E7E7E7E7E7E7E7F0003, 0x0000472FE07E7E7E7E7E7E7E7E7F0003, 0x0000472FE47E7E7E7E7E7E7E7E7F0003, 0x0000472FE57E7E7E7E7E7E7E7E7F0003, 0x0000472FE67E7E7E7E7E7E7E7E7F0003, 0x0000472FE77E7E7E7E7E7E7E7E7F0003, 0x0000472FE87E7E7E7E7E7E7E7E7F0003, 0x0000472FE97E7E7E7E7E7E7E7E7F0003, 0x0000472FEA7E7E7E7E7E7E7E7E7F0003, 0x0000472FEB7E7E7E7E7E7E7E7E7F0003, 0x0000472FEC7E7E7E7E7E7E7E7E7F0003, 0x0000472FED7E7E7E7E7E7E7E7E7F0003, 0x0000472FEE7E7E7E7E7E7E7E7E7F0003, 0x0000472FEF7E7E7E7E7E7E7E7E7F0003, 0x0000472FF07E7E7E7E7E7E7E7E7F0003, 0x0000472FF17E7E7E7E7E7E7E7E7F0003, 0x0000472FF27E7E7E7E7E7E7E7E7F0003, 0x0000472FF37E7E7E7E7E7E7E7E7F0003, 0x0000472FF47E7E7E7E7E7E7E7E7F0003, 0x0000472FF57E7E7E7E7E7E7E7E7F0003, 0x0000472FF67E7E7E7E7E7E7E7E7F0003, 0x0000472FF77E7E7E7E7E7E7E7E7F0003, 0x0000472FF87E7E7E7E7E7E7E7E7F0003, 0x0000472FF97E7E7E7E7E7E7E7E7F0003, 0x0000472FFA7E7E7E7E7E7E7E7E7F0003, 0x0000472FFB7E7E7E7E7E7E7E7E7F0003, 0x0000472FFC7E7E7E7E7E7E7E7E7F0003, 0x0000472FFD7E7E7E7E7E7E7E7E7F0003, 0x0000472FFE7E7E7E7E7E7E7E7E7F0003, 0x0000472FFF7E7E7E7E7E7E7E7E7F0003, '\0\0G0\0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0	~~~~~~~~\0', '\0\0G0
~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0
~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0~~~~~~~~\0', '\0\0G0\"~~~~~~~~\0', '\0\0G0$~~~~~~~~\0', '\0\0G0%~~~~~~~~\0', '\0\0G0&~~~~~~~~\0', '\0\0G0\'~~~~~~~~\0', '\0\0G0(~~~~~~~~\0', '\0\0G0)~~~~~~~~\0', '\0\0G0*~~~~~~~~\0', '\0\0G0,~~~~~~~~\0', '\0\0G00~~~~~~~~\0', '\0\0G01~~~~~~~~\0', '\0\0G02~~~~~~~~\0', '\0\0G03~~~~~~~~\0', '\0\0G04~~~~~~~~\0', '\0\0G05~~~~~~~~\0', '\0\0G06~~~~~~~~\0', '\0\0G07~~~~~~~~\0', '\0\0G08~~~~~~~~\0', '\0\0G09~~~~~~~~\0', '\0\0G0:~~~~~~~~\0', '\0\0G0;~~~~~~~~\0', '\0\0G0<~~~~~~~~\0', '\0\0G0>~~~~~~~~\0', '\0\0G0?~~~~~~~~\0', '\0\0G0@~~~~~~~~\0', '\0\0G0A~~~~~~~~\0', '\0\0G0B~~~~~~~~\0', '\0\0G0D~~~~~~~~\0', '\0\0G0G~~~~~~~~\0', '\0\0G0I~~~~~~~~\0', '\0\0G0J~~~~~~~~\0', '\0\0G0K~~~~~~~~\0', '\0\0G0L~~~~~~~~\0', '\0\0G0M~~~~~~~~\0', '\0\0G0N~~~~~~~~\0', '\0\0G0O~~~~~~~~\0', '\0\0G0P~~~~~~~~\0', '\0\0G0S~~~~~~~~\0', '\0\0G0U~~~~~~~~\0', '\0\0G0V~~~~~~~~\0', '\0\0G0W~~~~~~~~\0', '\0\0G0X~~~~~~~~\0', '\0\0G0Y~~~~~~~~\0', '\0\0G0Z~~~~~~~~\0', '\0\0G0[~~~~~~~~\0', '\0\0G0\\~~~~~~~~\0', '\0\0G0_~~~~~~~~\0', '\0\0G0`~~~~~~~~\0', '\0\0G0a~~~~~~~~\0', '\0\0G0b~~~~~~~~\0', '\0\0G0c~~~~~~~~\0', '\0\0G0d~~~~~~~~\0', '\0\0G0e~~~~~~~~\0', '\0\0G0f~~~~~~~~\0', '\0\0G0g~~~~~~~~\0', '\0\0G0h~~~~~~~~\0', '\0\0G0i~~~~~~~~\0', '\0\0G0j~~~~~~~~\0', '\0\0G0k~~~~~~~~\0', '\0\0G0l~~~~~~~~\0', '\0\0G0m~~~~~~~~\0', '\0\0G0n~~~~~~~~\0', '\0\0G0p~~~~~~~~\0', '\0\0G0q~~~~~~~~\0', '\0\0G0r~~~~~~~~\0', '\0\0G0s~~~~~~~~\0', '\0\0G0t~~~~~~~~\0', '\0\0G0u~~~~~~~~\0', '\0\0G0v~~~~~~~~\0', '\0\0G0y~~~~~~~~\0', '\0\0G0{~~~~~~~~\0', '\0\0G0|~~~~~~~~\0', '\0\0G0}~~~~~~~~\0', 0x00004730807E7E7E7E7E7E7E7E7F0003, 0x00004730817E7E7E7E7E7E7E7E7F0003, 0x00004730837E7E7E7E7E7E7E7E7F0003, 0x00004730847E7E7E7E7E7E7E7E7F0003, 0x00004730857E7E7E7E7E7E7E7E7F0003, 0x00004730867E7E7E7E7E7E7E7E7F0003, 0x00004730877E7E7E7E7E7E7E7E7F0003, 0x00004730887E7E7E7E7E7E7E7E7F0003, 0x000047308A7E7E7E7E7E7E7E7E7F0003, 0x000047308D7E7E7E7E7E7E7E7E7F0003, 0x000047308F7E7E7E7E7E7E7E7E7F0003, 0x00004730907E7E7E7E7E7E7E7E7F0003, 0x00004730917E7E7E7E7E7E7E7E7F0003, 0x00004730927E7E7E7E7E7E7E7E7F0003, 0x00004730937E7E7E7E7E7E7E7E7F0003, 0x00004730947E7E7E7E7E7E7E7E7F0003, 0x00004730957E7E7E7E7E7E7E7E7F0003, 0x00004730967E7E7E7E7E7E7E7E7F0003, 0x00004730977E7E7E7E7E7E7E7E7F0003, 0x00004730987E7E7E7E7E7E7E7E7F0003, 0x000047309A7E7E7E7E7E7E7E7E7F0003, 0x000047309B7E7E7E7E7E7E7E7E7F0003, 0x000047309C7E7E7E7E7E7E7E7E7F0003, 0x000047309D7E7E7E7E7E7E7E7E7F0003, 0x00004730A07E7E7E7E7E7E7E7E7F0003, 0x00004730A27E7E7E7E7E7E7E7E7F0003, 0x00004730A47E7E7E7E7E7E7E7E7F0003, 0x00004730A57E7E7E7E7E7E7E7E7F0003, 0x00004730A67E7E7E7E7E7E7E7E7F0003, 0x00004730A77E7E7E7E7E7E7E7E7F0003, 0x00004730AB7E7E7E7E7E7E7E7E7F0003, 0x00004730AC7E7E7E7E7E7E7E7E7F0003, 0x00004730AD7E7E7E7E7E7E7E7E7F0003, 0x00004730AE7E7E7E7E7E7E7E7E7F0003, 0x00004730AF7E7E7E7E7E7E7E7E7F0003, 0x00004730B17E7E7E7E7E7E7E7E7F0003, 0x00004730B27E7E7E7E7E7E7E7E7F0003, 0x00004730B57E7E7E7E7E7E7E7E7F0003, 0x00004730B67E7E7E7E7E7E7E7E7F0003, 0x00004730B77E7E7E7E7E7E7E7E7F0003, 0x00004730B87E7E7E7E7E7E7E7E7F0003, 0x00004730B97E7E7E7E7E7E7E7E7F0003, 0x00004730BA7E7E7E7E7E7E7E7E7F0003, 0x00004730BB7E7E7E7E7E7E7E7E7F0003, 0x00004730BC7E7E7E7E7E7E7E7E7F0003, 0x00004730BD7E7E7E7E7E7E7E7E7F0003, 0x00004730BE7E7E7E7E7E7E7E7E7F0003, 0x00004730BF7E7E7E7E7E7E7E7E7F0003, 0x00004730C07E7E7E7E7E7E7E7E7F0003, 0x00004730C17E7E7E7E7E7E7E7E7F0003, 0x00004730C27E7E7E7E7E7E7E7E7F0003, 0x00004730C37E7E7E7E7E7E7E7E7F0003, 0x00004730C47E7E7E7E7E7E7E7E7F0003, 0x00004730C67E7E7E7E7E7E7E7E7F0003, 0x00004730C77E7E7E7E7E7E7E7E7F0003, 0x00004730C87E7E7E7E7E7E7E7E7F0003, 0x00004730C97E7E7E7E7E7E7E7E7F0003, 0x00004730CA7E7E7E7E7E7E7E7E7F0003, 0x00004730CB7E7E7E7E7E7E7E7E7F0003, 0x00004730CC7E7E7E7E7E7E7E7E7F0003, 0x00004730CD7E7E7E7E7E7E7E7E7F0003, 0x00004730CE7E7E7E7E7E7E7E7E7F0003, 0x00004730CF7E7E7E7E7E7E7E7E7F0003, 0x00004730D07E7E7E7E7E7E7E7E7F0003, 0x00004730D17E7E7E7E7E7E7E7E7F0003, 0x00004730D27E7E7E7E7E7E7E7E7F0003, 0x00004730D37E7E7E7E7E7E7E7E7F0003, 0x00004730D57E7E7E7E7E7E7E7E7F0003, 0x00004730D67E7E7E7E7E7E7E7E7F0003, 0x00004730D77E7E7E7E7E7E7E7E7F0003, 0x00004730D87E7E7E7E7E7E7E7E7F0003, 0x00004730D97E7E7E7E7E7E7E7E7F0003, 0x00004730DA7E7E7E7E7E7E7E7E7F0003, 0x00004730DB7E7E7E7E7E7E7E7E7F0003, 0x00004730DC7E7E7E7E7E7E7E7E7F0003, 0x00004730DD7E7E7E7E7E7E7E7E7F0003, 0x00004730DF7E7E7E7E7E7E7E7E7F0003, 0x00004730E17E7E7E7E7E7E7E7E7F0003, 0x00004730E37E7E7E7E7E7E7E7E7F0003, 0x00004730E47E7E7E7E7E7E7E7E7F0003, 0x00004730E57E7E7E7E7E7E7E7E7F0003, 0x00004730E77E7E7E7E7E7E7E7E7F0003, 0x00004730E87E7E7E7E7E7E7E7E7F0003, 0x00004730E97E7E7E7E7E7E7E7E7F0003, 0x00004730EA7E7E7E7E7E7E7E7E7F0003, 0x00004730EB7E7E7E7E7E7E7E7E7F0003, 0x00004730EC7E7E7E7E7E7E7E7E7F0003, 0x00004730ED7E7E7E7E7E7E7E7E7F0003, 0x00004730EE7E7E7E7E7E7E7E7E7F0003, 0x00004730EF7E7E7E7E7E7E7E7E7F0003, 0x00004730F07E7E7E7E7E7E7E7E7F0003, 0x00004730F17E7E7E7E7E7E7E7E7F0003, 0x00004730F27E7E7E7E7E7E7E7E7F0003, 0x00004730F37E7E7E7E7E7E7E7E7F0003, 0x00004730F57E7E7E7E7E7E7E7E7F0003, 0x00004730F67E7E7E7E7E7E7E7E7F0003, 0x00004730F77E7E7E7E7E7E7E7E7F0003, 0x00004730F97E7E7E7E7E7E7E7E7F0003, 0x00004730FB7E7E7E7E7E7E7E7E7F0003, 0x00004730FC7E7E7E7E7E7E7E7E7F0003, 0x00004730FD7E7E7E7E7E7E7E7E7F0003, 0x00004730FE7E7E7E7E7E7E7E7E7F0003, '\0\0G1\0~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1	~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1
~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1~~~~~~~~\0', '\0\0G1!~~~~~~~~\0', '\0\0G1\"~~~~~~~~\0', '\0\0G1%~~~~~~~~\0', '\0\0G1&~~~~~~~~\0', '\0\0G1(~~~~~~~~\0', '\0\0G1)~~~~~~~~\0', '\0\0G1*~~~~~~~~\0', '\0\0G1+~~~~~~~~\0', '\0\0G1,~~~~~~~~\0', '\0\0G1-~~~~~~~~\0', '\0\0G12~~~~~~~~\0', '\0\0G13~~~~~~~~\0', '\0\0G14~~~~~~~~\0', '\0\0G16~~~~~~~~\0', '\0\0G17~~~~~~~~\0', '\0\0G18~~~~~~~~\0', '\0\0G19~~~~~~~~\0', '\0\0G1:~~~~~~~~\0', '\0\0G1;~~~~~~~~\0', '\0\0G1<~~~~~~~~\0', '\0\0G1=~~~~~~~~\0', '\0\0G1?~~~~~~~~\0', '\0\0G1@~~~~~~~~\0', '\0\0G1A~~~~~~~~\0', '\0\0G1B~~~~~~~~\0', '\0\0G1C~~~~~~~~\0', '\0\0G1E~~~~~~~~\0', '\0\0G1F~~~~~~~~\0', '\0\0G1G~~~~~~~~\0', '\0\0G1H~~~~~~~~\0', '\0\0G1I~~~~~~~~\0', '\0\0G1J~~~~~~~~\0', '\0\0G1K~~~~~~~~\0', '\0\0G1L~~~~~~~~\0', '\0\0G1M~~~~~~~~\0', '\0\0G1O~~~~~~~~\0', '\0\0G1R~~~~~~~~\0', '\0\0G1S~~~~~~~~\0', '\0\0G1U~~~~~~~~\0', '\0\0G1V~~~~~~~~\0', '\0\0G1W~~~~~~~~\0', '\0\0G1X~~~~~~~~\0', '\0\0G1Y~~~~~~~~\0', '\0\0G1Z~~~~~~~~\0', '\0\0G1[~~~~~~~~\0', '\0\0G1\\~~~~~~~~\0', '\0\0G1]~~~~~~~~\0', '\0\0G1^~~~~~~~~\0', '\0\0G1_~~~~~~~~\0', '\0\0G1`~~~~~~~~\0', '\0\0G1a~~~~~~~~\0', '\0\0G1b~~~~~~~~\0', '\0\0G1c~~~~~~~~\0', '\0\0G1d~~~~~~~~\0', '\0\0G1e~~~~~~~~\0', '\0\0G1f~~~~~~~~\0', '\0\0G1g~~~~~~~~\0', '\0\0G1h~~~~~~~~\0', '\0\0G1i~~~~~~~~\0', '\0\0G1l~~~~~~~~\0', '\0\0G1m~~~~~~~~\0', '\0\0G1n~~~~~~~~\0', '\0\0G1o~~~~~~~~\0', '\0\0G1p~~~~~~~~\0', '\0\0G1q~~~~~~~~\0', '\0\0G1r~~~~~~~~\0', '\0\0G1s~~~~~~~~\0', '\0\0G1t~~~~~~~~\0', '\0\0G1u~~~~~~~~\0', '\0\0G1v~~~~~~~~\0', '\0\0G1w~~~~~~~~\0', '\0\0G1x~~~~~~~~\0', '\0\0G1y~~~~~~~~\0', '\0\0G1z~~~~~~~~\0', '\0\0G1{~~~~~~~~\0', '\0\0G1|~~~~~~~~\0', '\0\0G1}~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~\0', 0x00004731807E7E7E7E7E7E7E7E7F0003, 0x00004731817E7E7E7E7E7E7E7E7F0003, 0x00004731827E7E7E7E7E7E7E7E7F0003, 0x00004731837E7E7E7E7E7E7E7E7F0003, 0x00004731847E7E7E7E7E7E7E7E7F0003, 0x00004731857E7E7E7E7E7E7E7E7F0003, 0x00004731867E7E7E7E7E7E7E7E7F0003, 0x00004731887E7E7E7E7E7E7E7E7F0003, 0x00004731897E7E7E7E7E7E7E7E7F0003, 0x000047318A7E7E7E7E7E7E7E7E7F0003, 0x000047318B7E7E7E7E7E7E7E7E7F0003, 0x000047318D7E7E7E7E7E7E7E7E7F0003, 0x000047318E7E7E7E7E7E7E7E7E7F0003, 0x000047318F7E7E7E7E7E7E7E7E7F0003, 0x00004731907E7E7E7E7E7E7E7E7F0003, 0x00004731917E7E7E7E7E7E7E7E7F0003, 0x00004731927E7E7E7E7E7E7E7E7F0003, 0x00004731937E7E7E7E7E7E7E7E7F0003, 0x00004731947E7E7E7E7E7E7E7E7F0003, 0x00004731957E7E7E7E7E7E7E7E7F0003, 0x00004731967E7E7E7E7E7E7E7E7F0003, 0x00004731977E7E7E7E7E7E7E7E7F0003, 0x00004731987E7E7E7E7E7E7E7E7F0003, 0x00004731997E7E7E7E7E7E7E7E7F0003, 0x000047319A7E7E7E7E7E7E7E7E7F0003);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
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)

6.06 ms
(0.65%)

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%"
  b"\x00\x00G.ø~~~~~~~~~\x00\x03"
  b"\x00\x00G.ù~~~~~~~~~\x00\x03"
  b"\x00\x00G.ú~~~~~~~~~\x00\x03"
  b"\x00\x00G.û~~~~~~~~~\x00\x03"
  b"\x00\x00G.ý~~~~~~~~~\x00\x03"
  b"\x00\x00G.þ~~~~~~~~~\x00\x03"
  b"\x00\x00G.ÿ~~~~~~~~~\x00\x03"
  "\x00\x00G/\x00~~~~~~~~~\x00\x03"
  "\x00\x00G/\x01~~~~~~~~~\x00\x03"
  "\x00\x00G/\x02~~~~~~~~~\x00\x03"
  "\x00\x00G/\x03~~~~~~~~~\x00\x03"
  "\x00\x00G/\x04~~~~~~~~~\x00\x03"
  "\x00\x00G/\x05~~~~~~~~~\x00\x03"
  "\x00\x00G/\x06~~~~~~~~~\x00\x03"
  "\x00\x00G/\x07~~~~~~~~~\x00\x03"
  "\x00\x00G/\x08~~~~~~~~~\x00\x03"
  "\x00\x00G/\t~~~~~~~~~\x00\x03"
  """
    \x00\x00G/\n
    ~~~~~~~~~\x00\x03
    """
  "\x00\x00G/\v~~~~~~~~~\x00\x03"
  "\x00\x00G/\f~~~~~~~~~\x00\x03"
  "\x00\x00G/\x0F~~~~~~~~~\x00\x03"
  "\x00\x00G/\x10~~~~~~~~~\x00\x03"
  "\x00\x00G/\x12~~~~~~~~~\x00\x03"
  "\x00\x00G/\x14~~~~~~~~~\x00\x03"
  "\x00\x00G/\x1D~~~~~~~~~\x00\x03"
  "\x00\x00G/\x1E~~~~~~~~~\x00\x03"
  "\x00\x00G/\x1F~~~~~~~~~\x00\x03"
  "\x00\x00G/ ~~~~~~~~~\x00\x03"
  "\x00\x00G/#~~~~~~~~~\x00\x03"
  "\x00\x00G/%~~~~~~~~~\x00\x03"
  "\x00\x00G/'~~~~~~~~~\x00\x03"
  "\x00\x00G/)~~~~~~~~~\x00\x03"
  "\x00\x00G/*~~~~~~~~~\x00\x03"
  "\x00\x00G/+~~~~~~~~~\x00\x03"
  "\x00\x00G/,~~~~~~~~~\x00\x03"
  "\x00\x00G/-~~~~~~~~~\x00\x03"
  "\x00\x00G/.~~~~~~~~~\x00\x03"
  "\x00\x00G//~~~~~~~~~\x00\x03"
  "\x00\x00G/0~~~~~~~~~\x00\x03"
  "\x00\x00G/1~~~~~~~~~\x00\x03"
  "\x00\x00G/2~~~~~~~~~\x00\x03"
  "\x00\x00G/3~~~~~~~~~\x00\x03"
  "\x00\x00G/4~~~~~~~~~\x00\x03"
  "\x00\x00G/5~~~~~~~~~\x00\x03"
  "\x00\x00G/6~~~~~~~~~\x00\x03"
  "\x00\x00G/7~~~~~~~~~\x00\x03"
  "\x00\x00G/8~~~~~~~~~\x00\x03"
  "\x00\x00G/9~~~~~~~~~\x00\x03"
  "\x00\x00G/:~~~~~~~~~\x00\x03"
  "\x00\x00G/<~~~~~~~~~\x00\x03"
  "\x00\x00G/=~~~~~~~~~\x00\x03"
  "\x00\x00G/?~~~~~~~~~\x00\x03"
  "\x00\x00G/@~~~~~~~~~\x00\x03"
  "\x00\x00G/C~~~~~~~~~\x00\x03"
  "\x00\x00G/D~~~~~~~~~\x00\x03"
  "\x00\x00G/E~~~~~~~~~\x00\x03"
  "\x00\x00G/F~~~~~~~~~\x00\x03"
  "\x00\x00G/G~~~~~~~~~\x00\x03"
  "\x00\x00G/H~~~~~~~~~\x00\x03"
  "\x00\x00G/J~~~~~~~~~\x00\x03"
  "\x00\x00G/L~~~~~~~~~\x00\x03"
  "\x00\x00G/M~~~~~~~~~\x00\x03"
  "\x00\x00G/N~~~~~~~~~\x00\x03"
  "\x00\x00G/P~~~~~~~~~\x00\x03"
  "\x00\x00G/Q~~~~~~~~~\x00\x03"
  "\x00\x00G/S~~~~~~~~~\x00\x03"
  "\x00\x00G/T~~~~~~~~~\x00\x03"
  "\x00\x00G/U~~~~~~~~~\x00\x03"
  "\x00\x00G/V~~~~~~~~~\x00\x03"
  "\x00\x00G/W~~~~~~~~~\x00\x03"
  "\x00\x00G/Z~~~~~~~~~\x00\x03"
  "\x00\x00G/]~~~~~~~~~\x00\x03"
  "\x00\x00G/^~~~~~~~~~\x00\x03"
  "\x00\x00G/_~~~~~~~~~\x00\x03"
  "\x00\x00G/`~~~~~~~~~\x00\x03"
  "\x00\x00G/a~~~~~~~~~\x00\x03"
  "\x00\x00G/c~~~~~~~~~\x00\x03"
  "\x00\x00G/d~~~~~~~~~\x00\x03"
  "\x00\x00G/e~~~~~~~~~\x00\x03"
  "\x00\x00G/g~~~~~~~~~\x00\x03"
  "\x00\x00G/i~~~~~~~~~\x00\x03"
  "\x00\x00G/j~~~~~~~~~\x00\x03"
  "\x00\x00G/k~~~~~~~~~\x00\x03"
  "\x00\x00G/l~~~~~~~~~\x00\x03"
  "\x00\x00G/m~~~~~~~~~\x00\x03"
  "\x00\x00G/n~~~~~~~~~\x00\x03"
  "\x00\x00G/o~~~~~~~~~\x00\x03"
  "\x00\x00G/q~~~~~~~~~\x00\x03"
  "\x00\x00G/r~~~~~~~~~\x00\x03"
  "\x00\x00G/s~~~~~~~~~\x00\x03"
  "\x00\x00G/u~~~~~~~~~\x00\x03"
  "\x00\x00G/v~~~~~~~~~\x00\x03"
  "\x00\x00G/w~~~~~~~~~\x00\x03"
  "\x00\x00G/x~~~~~~~~~\x00\x03"
  "\x00\x00G/y~~~~~~~~~\x00\x03"
  "\x00\x00G/z~~~~~~~~~\x00\x03"
  b"\x00\x00G/—~~~~~~~~~\x00\x03"
  b"\x00\x00G/˜~~~~~~~~~\x00\x03"
  b"\x00\x00G/™~~~~~~~~~\x00\x03"
  b"\x00\x00G/œ~~~~~~~~~\x00\x03"
  b"\x00\x00G/ž~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ÿ~~~~~~~~~\x00\x03"
  b"\x00\x00G/ ~~~~~~~~~\x00\x03"
  b"\x00\x00G/¡~~~~~~~~~\x00\x03"
  b"\x00\x00G/£~~~~~~~~~\x00\x03"
  b"\x00\x00G/¤~~~~~~~~~\x00\x03"
  b"\x00\x00G/§~~~~~~~~~\x00\x03"
  b"\x00\x00G/¨~~~~~~~~~\x00\x03"
  b"\x00\x00G/©~~~~~~~~~\x00\x03"
  b"\x00\x00G/ª~~~~~~~~~\x00\x03"
  b"\x00\x00G/«~~~~~~~~~\x00\x03"
  b"\x00\x00G/¬~~~~~~~~~\x00\x03"
  b"\x00\x00G/~~~~~~~~~\x00\x03"
  b"\x00\x00G/®~~~~~~~~~\x00\x03"
  b"\x00\x00G/²~~~~~~~~~\x00\x03"
  b"\x00\x00G/³~~~~~~~~~\x00\x03"
  b"\x00\x00G/´~~~~~~~~~\x00\x03"
  b"\x00\x00G/µ~~~~~~~~~\x00\x03"
  b"\x00\x00G/¶~~~~~~~~~\x00\x03"
  b"\x00\x00G/¸~~~~~~~~~\x00\x03"
  b"\x00\x00G/¹~~~~~~~~~\x00\x03"
  b"\x00\x00G/º~~~~~~~~~\x00\x03"
  b"\x00\x00G/»~~~~~~~~~\x00\x03"
  b"\x00\x00G/¼~~~~~~~~~\x00\x03"
  b"\x00\x00G/¾~~~~~~~~~\x00\x03"
  b"\x00\x00G/Â~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ã~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ä~~~~~~~~~\x00\x03"
  b"\x00\x00G/Å~~~~~~~~~\x00\x03"
  b"\x00\x00G/Æ~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ç~~~~~~~~~\x00\x03"
  b"\x00\x00G/È~~~~~~~~~\x00\x03"
  b"\x00\x00G/É~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ê~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ë~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ñ~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ó~~~~~~~~~\x00\x03"
  b"\x00\x00G/Õ~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ù~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ú~~~~~~~~~\x00\x03"
  b"\x00\x00G/Ý~~~~~~~~~\x00\x03"
  b"\x00\x00G/à~~~~~~~~~\x00\x03"
  b"\x00\x00G/ä~~~~~~~~~\x00\x03"
  b"\x00\x00G/å~~~~~~~~~\x00\x03"
  b"\x00\x00G/æ~~~~~~~~~\x00\x03"
  b"\x00\x00G/ç~~~~~~~~~\x00\x03"
  b"\x00\x00G/è~~~~~~~~~\x00\x03"
  b"\x00\x00G/é~~~~~~~~~\x00\x03"
  b"\x00\x00G/ê~~~~~~~~~\x00\x03"
  b"\x00\x00G/ë~~~~~~~~~\x00\x03"
  b"\x00\x00G/ì~~~~~~~~~\x00\x03"
  b"\x00\x00G/í~~~~~~~~~\x00\x03"
  b"\x00\x00G/î~~~~~~~~~\x00\x03"
  b"\x00\x00G/ï~~~~~~~~~\x00\x03"
  b"\x00\x00G/ð~~~~~~~~~\x00\x03"
  b"\x00\x00G/ñ~~~~~~~~~\x00\x03"
  b"\x00\x00G/ò~~~~~~~~~\x00\x03"
  b"\x00\x00G/ó~~~~~~~~~\x00\x03"
  b"\x00\x00G/ô~~~~~~~~~\x00\x03"
  b"\x00\x00G/õ~~~~~~~~~\x00\x03"
  b"\x00\x00G/ö~~~~~~~~~\x00\x03"
  b"\x00\x00G/÷~~~~~~~~~\x00\x03"
  b"\x00\x00G/ø~~~~~~~~~\x00\x03"
  b"\x00\x00G/ù~~~~~~~~~\x00\x03"
  b"\x00\x00G/ú~~~~~~~~~\x00\x03"
  b"\x00\x00G/û~~~~~~~~~\x00\x03"
  b"\x00\x00G/ü~~~~~~~~~\x00\x03"
  b"\x00\x00G/ý~~~~~~~~~\x00\x03"
  b"\x00\x00G/þ~~~~~~~~~\x00\x03"
  b"\x00\x00G/ÿ~~~~~~~~~\x00\x03"
  "\x00\x00G0\x00~~~~~~~~~\x00\x03"
  "\x00\x00G0\x01~~~~~~~~~\x00\x03"
  "\x00\x00G0\x02~~~~~~~~~\x00\x03"
  "\x00\x00G0\x03~~~~~~~~~\x00\x03"
  "\x00\x00G0\x04~~~~~~~~~\x00\x03"
  "\x00\x00G0\x05~~~~~~~~~\x00\x03"
  "\x00\x00G0\x06~~~~~~~~~\x00\x03"
  "\x00\x00G0\x07~~~~~~~~~\x00\x03"
  "\x00\x00G0\x08~~~~~~~~~\x00\x03"
  "\x00\x00G0\t~~~~~~~~~\x00\x03"
  """
    \x00\x00G0\n
    ~~~~~~~~~\x00\x03
    """
  "\x00\x00G0\v~~~~~~~~~\x00\x03"
  "\x00\x00G0\r~~~~~~~~~\x00\x03"
  "\x00\x00G0\x0E~~~~~~~~~\x00\x03"
  "\x00\x00G0\x0F~~~~~~~~~\x00\x03"
  "\x00\x00G0\x10~~~~~~~~~\x00\x03"
  "\x00\x00G0\x11~~~~~~~~~\x00\x03"
  "\x00\x00G0\x12~~~~~~~~~\x00\x03"
  "\x00\x00G0\x13~~~~~~~~~\x00\x03"
  "\x00\x00G0\x14~~~~~~~~~\x00\x03"
  "\x00\x00G0\x15~~~~~~~~~\x00\x03"
  "\x00\x00G0\x19~~~~~~~~~\x00\x03"
  "\x00\x00G0\e~~~~~~~~~\x00\x03"
  "\x00\x00G0\x1E~~~~~~~~~\x00\x03"
  "\x00\x00G0\x1F~~~~~~~~~\x00\x03"
  "\x00\x00G0"~~~~~~~~~\x00\x03"
  "\x00\x00G0$~~~~~~~~~\x00\x03"
  "\x00\x00G0%~~~~~~~~~\x00\x03"
  "\x00\x00G0&~~~~~~~~~\x00\x03"
  "\x00\x00G0'~~~~~~~~~\x00\x03"
  "\x00\x00G0(~~~~~~~~~\x00\x03"
  "\x00\x00G0)~~~~~~~~~\x00\x03"
  "\x00\x00G0*~~~~~~~~~\x00\x03"
  "\x00\x00G0,~~~~~~~~~\x00\x03"
  "\x00\x00G00~~~~~~~~~\x00\x03"
  "\x00\x00G01~~~~~~~~~\x00\x03"
  "\x00\x00G02~~~~~~~~~\x00\x03"
  "\x00\x00G03~~~~~~~~~\x00\x03"
  "\x00\x00G04~~~~~~~~~\x00\x03"
  "\x00\x00G05~~~~~~~~~\x00\x03"
  "\x00\x00G06~~~~~~~~~\x00\x03"
  "\x00\x00G07~~~~~~~~~\x00\x03"
  "\x00\x00G08~~~~~~~~~\x00\x03"
  "\x00\x00G09~~~~~~~~~\x00\x03"
  "\x00\x00G0:~~~~~~~~~\x00\x03"
  "\x00\x00G0;~~~~~~~~~\x00\x03"
  "\x00\x00G0<~~~~~~~~~\x00\x03"
  "\x00\x00G0>~~~~~~~~~\x00\x03"
  "\x00\x00G0?~~~~~~~~~\x00\x03"
  "\x00\x00G0@~~~~~~~~~\x00\x03"
  "\x00\x00G0A~~~~~~~~~\x00\x03"
  "\x00\x00G0B~~~~~~~~~\x00\x03"
  "\x00\x00G0D~~~~~~~~~\x00\x03"
  "\x00\x00G0G~~~~~~~~~\x00\x03"
  "\x00\x00G0I~~~~~~~~~\x00\x03"
  "\x00\x00G0J~~~~~~~~~\x00\x03"
  "\x00\x00G0K~~~~~~~~~\x00\x03"
  "\x00\x00G0L~~~~~~~~~\x00\x03"
  "\x00\x00G0M~~~~~~~~~\x00\x03"
  "\x00\x00G0N~~~~~~~~~\x00\x03"
  "\x00\x00G0O~~~~~~~~~\x00\x03"
  "\x00\x00G0P~~~~~~~~~\x00\x03"
  "\x00\x00G0S~~~~~~~~~\x00\x03"
  "\x00\x00G0U~~~~~~~~~\x00\x03"
  "\x00\x00G0V~~~~~~~~~\x00\x03"
  "\x00\x00G0W~~~~~~~~~\x00\x03"
  "\x00\x00G0X~~~~~~~~~\x00\x03"
  "\x00\x00G0Y~~~~~~~~~\x00\x03"
  "\x00\x00G0Z~~~~~~~~~\x00\x03"
  "\x00\x00G0[~~~~~~~~~\x00\x03"
  "\x00\x00G0\~~~~~~~~~\x00\x03"
  "\x00\x00G0_~~~~~~~~~\x00\x03"
  "\x00\x00G0`~~~~~~~~~\x00\x03"
  "\x00\x00G0a~~~~~~~~~\x00\x03"
  "\x00\x00G0b~~~~~~~~~\x00\x03"
  "\x00\x00G0c~~~~~~~~~\x00\x03"
  "\x00\x00G0d~~~~~~~~~\x00\x03"
  "\x00\x00G0e~~~~~~~~~\x00\x03"
  "\x00\x00G0f~~~~~~~~~\x00\x03"
  "\x00\x00G0g~~~~~~~~~\x00\x03"
  "\x00\x00G0h~~~~~~~~~\x00\x03"
  "\x00\x00G0i~~~~~~~~~\x00\x03"
  "\x00\x00G0j~~~~~~~~~\x00\x03"
  "\x00\x00G0k~~~~~~~~~\x00\x03"
  "\x00\x00G0l~~~~~~~~~\x00\x03"
  "\x00\x00G0m~~~~~~~~~\x00\x03"
  "\x00\x00G0n~~~~~~~~~\x00\x03"
  "\x00\x00G0p~~~~~~~~~\x00\x03"
  "\x00\x00G0q~~~~~~~~~\x00\x03"
  "\x00\x00G0r~~~~~~~~~\x00\x03"
  "\x00\x00G0s~~~~~~~~~\x00\x03"
  "\x00\x00G0t~~~~~~~~~\x00\x03"
  "\x00\x00G0u~~~~~~~~~\x00\x03"
  "\x00\x00G0v~~~~~~~~~\x00\x03"
  "\x00\x00G0y~~~~~~~~~\x00\x03"
  "\x00\x00G0{~~~~~~~~~\x00\x03"
  "\x00\x00G0|~~~~~~~~~\x00\x03"
  "\x00\x00G0}~~~~~~~~~\x00\x03"
  b"\x00\x00G0€~~~~~~~~~\x00\x03"
  b"\x00\x00G0~~~~~~~~~\x00\x03"
  b"\x00\x00G0ƒ~~~~~~~~~\x00\x03"
  b"\x00\x00G0„~~~~~~~~~\x00\x03"
  b"\x00\x00G0…~~~~~~~~~\x00\x03"
  b"\x00\x00G0†~~~~~~~~~\x00\x03"
  b"\x00\x00G0‡~~~~~~~~~\x00\x03"
  b"\x00\x00G0ˆ~~~~~~~~~\x00\x03"
  b"\x00\x00G0Š~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ž~~~~~~~~~\x00\x03"
  b"\x00\x00G0~~~~~~~~~\x00\x03"
  b"\x00\x00G0~~~~~~~~~\x00\x03"
  b"\x00\x00G0‘~~~~~~~~~\x00\x03"
  b"\x00\x00G0’~~~~~~~~~\x00\x03"
  b"\x00\x00G0“~~~~~~~~~\x00\x03"
  b"\x00\x00G0”~~~~~~~~~\x00\x03"
  b"\x00\x00G0•~~~~~~~~~\x00\x03"
  b"\x00\x00G0–~~~~~~~~~\x00\x03"
  b"\x00\x00G0—~~~~~~~~~\x00\x03"
  b"\x00\x00G0˜~~~~~~~~~\x00\x03"
  b"\x00\x00G0š~~~~~~~~~\x00\x03"
  b"\x00\x00G0›~~~~~~~~~\x00\x03"
  b"\x00\x00G0œ~~~~~~~~~\x00\x03"
  b"\x00\x00G0~~~~~~~~~\x00\x03"
  b"\x00\x00G0 ~~~~~~~~~\x00\x03"
  b"\x00\x00G0¢~~~~~~~~~\x00\x03"
  b"\x00\x00G0¤~~~~~~~~~\x00\x03"
  b"\x00\x00G0¥~~~~~~~~~\x00\x03"
  b"\x00\x00G0¦~~~~~~~~~\x00\x03"
  b"\x00\x00G0§~~~~~~~~~\x00\x03"
  b"\x00\x00G0«~~~~~~~~~\x00\x03"
  b"\x00\x00G0¬~~~~~~~~~\x00\x03"
  b"\x00\x00G0~~~~~~~~~\x00\x03"
  b"\x00\x00G0®~~~~~~~~~\x00\x03"
  b"\x00\x00G0¯~~~~~~~~~\x00\x03"
  b"\x00\x00G0±~~~~~~~~~\x00\x03"
  b"\x00\x00G0²~~~~~~~~~\x00\x03"
  b"\x00\x00G0µ~~~~~~~~~\x00\x03"
  b"\x00\x00G0¶~~~~~~~~~\x00\x03"
  b"\x00\x00G0·~~~~~~~~~\x00\x03"
  b"\x00\x00G0¸~~~~~~~~~\x00\x03"
  b"\x00\x00G0¹~~~~~~~~~\x00\x03"
  b"\x00\x00G0º~~~~~~~~~\x00\x03"
  b"\x00\x00G0»~~~~~~~~~\x00\x03"
  b"\x00\x00G0¼~~~~~~~~~\x00\x03"
  b"\x00\x00G0½~~~~~~~~~\x00\x03"
  b"\x00\x00G0¾~~~~~~~~~\x00\x03"
  b"\x00\x00G0¿~~~~~~~~~\x00\x03"
  b"\x00\x00G0À~~~~~~~~~\x00\x03"
  b"\x00\x00G0Á~~~~~~~~~\x00\x03"
  b"\x00\x00G0Â~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ã~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ä~~~~~~~~~\x00\x03"
  b"\x00\x00G0Æ~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ç~~~~~~~~~\x00\x03"
  b"\x00\x00G0È~~~~~~~~~\x00\x03"
  b"\x00\x00G0É~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ê~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ë~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ì~~~~~~~~~\x00\x03"
  b"\x00\x00G0Í~~~~~~~~~\x00\x03"
  b"\x00\x00G0Î~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ï~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ð~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ñ~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ò~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ó~~~~~~~~~\x00\x03"
  b"\x00\x00G0Õ~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ö~~~~~~~~~\x00\x03"
  b"\x00\x00G0×~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ø~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ù~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ú~~~~~~~~~\x00\x03"
  b"\x00\x00G0Û~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ü~~~~~~~~~\x00\x03"
  b"\x00\x00G0Ý~~~~~~~~~\x00\x03"
  b"\x00\x00G0ß~~~~~~~~~\x00\x03"
  b"\x00\x00G0á~~~~~~~~~\x00\x03"
  b"\x00\x00G0ã~~~~~~~~~\x00\x03"
  b"\x00\x00G0ä~~~~~~~~~\x00\x03"
  b"\x00\x00G0å~~~~~~~~~\x00\x03"
  b"\x00\x00G0ç~~~~~~~~~\x00\x03"
  b"\x00\x00G0è~~~~~~~~~\x00\x03"
  b"\x00\x00G0é~~~~~~~~~\x00\x03"
  b"\x00\x00G0ê~~~~~~~~~\x00\x03"
  b"\x00\x00G0ë~~~~~~~~~\x00\x03"
  b"\x00\x00G0ì~~~~~~~~~\x00\x03"
  b"\x00\x00G0í~~~~~~~~~\x00\x03"
  b"\x00\x00G0î~~~~~~~~~\x00\x03"
  b"\x00\x00G0ï~~~~~~~~~\x00\x03"
  b"\x00\x00G0ð~~~~~~~~~\x00\x03"
  b"\x00\x00G0ñ~~~~~~~~~\x00\x03"
  b"\x00\x00G0ò~~~~~~~~~\x00\x03"
  b"\x00\x00G0ó~~~~~~~~~\x00\x03"
  b"\x00\x00G0õ~~~~~~~~~\x00\x03"
  b"\x00\x00G0ö~~~~~~~~~\x00\x03"
  b"\x00\x00G0÷~~~~~~~~~\x00\x03"
  b"\x00\x00G0ù~~~~~~~~~\x00\x03"
  b"\x00\x00G0û~~~~~~~~~\x00\x03"
  b"\x00\x00G0ü~~~~~~~~~\x00\x03"
  b"\x00\x00G0ý~~~~~~~~~\x00\x03"
  b"\x00\x00G0þ~~~~~~~~~\x00\x03"
  "\x00\x00G1\x00~~~~~~~~~\x00\x03"
  "\x00\x00G1\x01~~~~~~~~~\x00\x03"
  "\x00\x00G1\x02~~~~~~~~~\x00\x03"
  "\x00\x00G1\x03~~~~~~~~~\x00\x03"
  "\x00\x00G1\x04~~~~~~~~~\x00\x03"
  "\x00\x00G1\x05~~~~~~~~~\x00\x03"
  "\x00\x00G1\x06~~~~~~~~~\x00\x03"
  "\x00\x00G1\x07~~~~~~~~~\x00\x03"
  "\x00\x00G1\t~~~~~~~~~\x00\x03"
  "\x00\x00G1\v~~~~~~~~~\x00\x03"
  "\x00\x00G1\f~~~~~~~~~\x00\x03"
  "\x00\x00G1\r~~~~~~~~~\x00\x03"
  "\x00\x00G1\x12~~~~~~~~~\x00\x03"
  "\x00\x00G1\x13~~~~~~~~~\x00\x03"
  "\x00\x00G1\x14~~~~~~~~~\x00\x03"
  "\x00\x00G1\x15~~~~~~~~~\x00\x03"
  "\x00\x00G1\x16~~~~~~~~~\x00\x03"
  "\x00\x00G1\x17~~~~~~~~~\x00\x03"
  "\x00\x00G1\x18~~~~~~~~~\x00\x03"
  "\x00\x00G1\x19~~~~~~~~~\x00\x03"
  "\x00\x00G1\x1A~~~~~~~~~\x00\x03"
  "\x00\x00G1\e~~~~~~~~~\x00\x03"
  "\x00\x00G1\x1C~~~~~~~~~\x00\x03"
  "\x00\x00G1\x1D~~~~~~~~~\x00\x03"
  "\x00\x00G1\x1E~~~~~~~~~\x00\x03"
  "\x00\x00G1\x1F~~~~~~~~~\x00\x03"
  "\x00\x00G1!~~~~~~~~~\x00\x03"
  "\x00\x00G1"~~~~~~~~~\x00\x03"
  "\x00\x00G1%~~~~~~~~~\x00\x03"
  "\x00\x00G1&~~~~~~~~~\x00\x03"
  "\x00\x00G1(~~~~~~~~~\x00\x03"
  "\x00\x00G1)~~~~~~~~~\x00\x03"
  "\x00\x00G1*~~~~~~~~~\x00\x03"
  "\x00\x00G1+~~~~~~~~~\x00\x03"
  "\x00\x00G1,~~~~~~~~~\x00\x03"
  "\x00\x00G1-~~~~~~~~~\x00\x03"
  "\x00\x00G12~~~~~~~~~\x00\x03"
  "\x00\x00G13~~~~~~~~~\x00\x03"
  "\x00\x00G14~~~~~~~~~\x00\x03"
  "\x00\x00G16~~~~~~~~~\x00\x03"
  "\x00\x00G17~~~~~~~~~\x00\x03"
  "\x00\x00G18~~~~~~~~~\x00\x03"
  "\x00\x00G19~~~~~~~~~\x00\x03"
  "\x00\x00G1:~~~~~~~~~\x00\x03"
  "\x00\x00G1;~~~~~~~~~\x00\x03"
  "\x00\x00G1<~~~~~~~~~\x00\x03"
  "\x00\x00G1=~~~~~~~~~\x00\x03"
  "\x00\x00G1?~~~~~~~~~\x00\x03"
  "\x00\x00G1@~~~~~~~~~\x00\x03"
  "\x00\x00G1A~~~~~~~~~\x00\x03"
  "\x00\x00G1B~~~~~~~~~\x00\x03"
  "\x00\x00G1C~~~~~~~~~\x00\x03"
  "\x00\x00G1E~~~~~~~~~\x00\x03"
  "\x00\x00G1F~~~~~~~~~\x00\x03"
  "\x00\x00G1G~~~~~~~~~\x00\x03"
  "\x00\x00G1H~~~~~~~~~\x00\x03"
  "\x00\x00G1I~~~~~~~~~\x00\x03"
  "\x00\x00G1J~~~~~~~~~\x00\x03"
  "\x00\x00G1K~~~~~~~~~\x00\x03"
  "\x00\x00G1L~~~~~~~~~\x00\x03"
  "\x00\x00G1M~~~~~~~~~\x00\x03"
  "\x00\x00G1O~~~~~~~~~\x00\x03"
  "\x00\x00G1R~~~~~~~~~\x00\x03"
  "\x00\x00G1S~~~~~~~~~\x00\x03"
  "\x00\x00G1U~~~~~~~~~\x00\x03"
  "\x00\x00G1V~~~~~~~~~\x00\x03"
  "\x00\x00G1W~~~~~~~~~\x00\x03"
  "\x00\x00G1X~~~~~~~~~\x00\x03"
  "\x00\x00G1Y~~~~~~~~~\x00\x03"
  "\x00\x00G1Z~~~~~~~~~\x00\x03"
  "\x00\x00G1[~~~~~~~~~\x00\x03"
  "\x00\x00G1\~~~~~~~~~\x00\x03"
  "\x00\x00G1]~~~~~~~~~\x00\x03"
  "\x00\x00G1^~~~~~~~~~\x00\x03"
  "\x00\x00G1_~~~~~~~~~\x00\x03"
  "\x00\x00G1`~~~~~~~~~\x00\x03"
  "\x00\x00G1a~~~~~~~~~\x00\x03"
  "\x00\x00G1b~~~~~~~~~\x00\x03"
  "\x00\x00G1c~~~~~~~~~\x00\x03"
  "\x00\x00G1d~~~~~~~~~\x00\x03"
  "\x00\x00G1e~~~~~~~~~\x00\x03"
  "\x00\x00G1f~~~~~~~~~\x00\x03"
  "\x00\x00G1g~~~~~~~~~\x00\x03"
  "\x00\x00G1h~~~~~~~~~\x00\x03"
  "\x00\x00G1i~~~~~~~~~\x00\x03"
  "\x00\x00G1l~~~~~~~~~\x00\x03"
  "\x00\x00G1m~~~~~~~~~\x00\x03"
  "\x00\x00G1n~~~~~~~~~\x00\x03"
  "\x00\x00G1o~~~~~~~~~\x00\x03"
  "\x00\x00G1p~~~~~~~~~\x00\x03"
  "\x00\x00G1q~~~~~~~~~\x00\x03"
  "\x00\x00G1r~~~~~~~~~\x00\x03"
  "\x00\x00G1s~~~~~~~~~\x00\x03"
  "\x00\x00G1t~~~~~~~~~\x00\x03"
  "\x00\x00G1u~~~~~~~~~\x00\x03"
  "\x00\x00G1v~~~~~~~~~\x00\x03"
  "\x00\x00G1w~~~~~~~~~\x00\x03"
  "\x00\x00G1x~~~~~~~~~\x00\x03"
  "\x00\x00G1y~~~~~~~~~\x00\x03"
  "\x00\x00G1z~~~~~~~~~\x00\x03"
  "\x00\x00G1{~~~~~~~~~\x00\x03"
  "\x00\x00G1|~~~~~~~~~\x00\x03"
  "\x00\x00G1}~~~~~~~~~\x00\x03"
  "\x00\x00G1~~~~~~~~~~\x00\x03"
  "\x00\x00G1\x7F~~~~~~~~~\x00\x03"
  b"\x00\x00G1€~~~~~~~~~\x00\x03"
  b"\x00\x00G1~~~~~~~~~\x00\x03"
  b"\x00\x00G1‚~~~~~~~~~\x00\x03"
  b"\x00\x00G1ƒ~~~~~~~~~\x00\x03"
  b"\x00\x00G1„~~~~~~~~~\x00\x03"
  b"\x00\x00G1…~~~~~~~~~\x00\x03"
  b"\x00\x00G1†~~~~~~~~~\x00\x03"
  b"\x00\x00G1ˆ~~~~~~~~~\x00\x03"
  b"\x00\x00G1‰~~~~~~~~~\x00\x03"
  b"\x00\x00G1Š~~~~~~~~~\x00\x03"
  b"\x00\x00G1‹~~~~~~~~~\x00\x03"
  b"\x00\x00G1Ž~~~~~~~~~\x00\x03"
  b"\x00\x00G1Ž~~~~~~~~~\x00\x03"
  b"\x00\x00G1~~~~~~~~~\x00\x03"
  b"\x00\x00G1~~~~~~~~~\x00\x03"
  b"\x00\x00G1‘~~~~~~~~~\x00\x03"
  b"\x00\x00G1’~~~~~~~~~\x00\x03"
  b"\x00\x00G1“~~~~~~~~~\x00\x03"
  b"\x00\x00G1”~~~~~~~~~\x00\x03"
  b"\x00\x00G1•~~~~~~~~~\x00\x03"
  b"\x00\x00G1–~~~~~~~~~\x00\x03"
  b"\x00\x00G1—~~~~~~~~~\x00\x03"
  b"\x00\x00G1˜~~~~~~~~~\x00\x03"
  b"\x00\x00G1™~~~~~~~~~\x00\x03"
  b"\x00\x00G1š~~~~~~~~~\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 (0x0000472EF87E7E7E7E7E7E7E7E7E0003, 0x0000472EF97E7E7E7E7E7E7E7E7E0003, 0x0000472EFA7E7E7E7E7E7E7E7E7E0003, 0x0000472EFB7E7E7E7E7E7E7E7E7E0003, 0x0000472EFD7E7E7E7E7E7E7E7E7E0003, 0x0000472EFE7E7E7E7E7E7E7E7E7E0003, 0x0000472EFF7E7E7E7E7E7E7E7E7E0003, '\0\0G/\0~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/	~~~~~~~~~\0', '\0\0G/
~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/~~~~~~~~~\0', '\0\0G/ ~~~~~~~~~\0', '\0\0G/#~~~~~~~~~\0', '\0\0G/%~~~~~~~~~\0', '\0\0G/\'~~~~~~~~~\0', '\0\0G/)~~~~~~~~~\0', '\0\0G/*~~~~~~~~~\0', '\0\0G/+~~~~~~~~~\0', '\0\0G/,~~~~~~~~~\0', '\0\0G/-~~~~~~~~~\0', '\0\0G/.~~~~~~~~~\0', '\0\0G//~~~~~~~~~\0', '\0\0G/0~~~~~~~~~\0', '\0\0G/1~~~~~~~~~\0', '\0\0G/2~~~~~~~~~\0', '\0\0G/3~~~~~~~~~\0', '\0\0G/4~~~~~~~~~\0', '\0\0G/5~~~~~~~~~\0', '\0\0G/6~~~~~~~~~\0', '\0\0G/7~~~~~~~~~\0', '\0\0G/8~~~~~~~~~\0', '\0\0G/9~~~~~~~~~\0', '\0\0G/:~~~~~~~~~\0', '\0\0G/<~~~~~~~~~\0', '\0\0G/=~~~~~~~~~\0', '\0\0G/?~~~~~~~~~\0', '\0\0G/@~~~~~~~~~\0', '\0\0G/C~~~~~~~~~\0', '\0\0G/D~~~~~~~~~\0', '\0\0G/E~~~~~~~~~\0', '\0\0G/F~~~~~~~~~\0', '\0\0G/G~~~~~~~~~\0', '\0\0G/H~~~~~~~~~\0', '\0\0G/J~~~~~~~~~\0', '\0\0G/L~~~~~~~~~\0', '\0\0G/M~~~~~~~~~\0', '\0\0G/N~~~~~~~~~\0', '\0\0G/P~~~~~~~~~\0', '\0\0G/Q~~~~~~~~~\0', '\0\0G/S~~~~~~~~~\0', '\0\0G/T~~~~~~~~~\0', '\0\0G/U~~~~~~~~~\0', '\0\0G/V~~~~~~~~~\0', '\0\0G/W~~~~~~~~~\0', '\0\0G/Z~~~~~~~~~\0', '\0\0G/]~~~~~~~~~\0', '\0\0G/^~~~~~~~~~\0', '\0\0G/_~~~~~~~~~\0', '\0\0G/`~~~~~~~~~\0', '\0\0G/a~~~~~~~~~\0', '\0\0G/c~~~~~~~~~\0', '\0\0G/d~~~~~~~~~\0', '\0\0G/e~~~~~~~~~\0', '\0\0G/g~~~~~~~~~\0', '\0\0G/i~~~~~~~~~\0', '\0\0G/j~~~~~~~~~\0', '\0\0G/k~~~~~~~~~\0', '\0\0G/l~~~~~~~~~\0', '\0\0G/m~~~~~~~~~\0', '\0\0G/n~~~~~~~~~\0', '\0\0G/o~~~~~~~~~\0', '\0\0G/q~~~~~~~~~\0', '\0\0G/r~~~~~~~~~\0', '\0\0G/s~~~~~~~~~\0', '\0\0G/u~~~~~~~~~\0', '\0\0G/v~~~~~~~~~\0', '\0\0G/w~~~~~~~~~\0', '\0\0G/x~~~~~~~~~\0', '\0\0G/y~~~~~~~~~\0', '\0\0G/z~~~~~~~~~\0', 0x0000472F977E7E7E7E7E7E7E7E7E0003, 0x0000472F987E7E7E7E7E7E7E7E7E0003, 0x0000472F997E7E7E7E7E7E7E7E7E0003, 0x0000472F9C7E7E7E7E7E7E7E7E7E0003, 0x0000472F9E7E7E7E7E7E7E7E7E7E0003, 0x0000472F9F7E7E7E7E7E7E7E7E7E0003, 0x0000472FA07E7E7E7E7E7E7E7E7E0003, 0x0000472FA17E7E7E7E7E7E7E7E7E0003, 0x0000472FA37E7E7E7E7E7E7E7E7E0003, 0x0000472FA47E7E7E7E7E7E7E7E7E0003, 0x0000472FA77E7E7E7E7E7E7E7E7E0003, 0x0000472FA87E7E7E7E7E7E7E7E7E0003, 0x0000472FA97E7E7E7E7E7E7E7E7E0003, 0x0000472FAA7E7E7E7E7E7E7E7E7E0003, 0x0000472FAB7E7E7E7E7E7E7E7E7E0003, 0x0000472FAC7E7E7E7E7E7E7E7E7E0003, 0x0000472FAD7E7E7E7E7E7E7E7E7E0003, 0x0000472FAE7E7E7E7E7E7E7E7E7E0003, 0x0000472FB27E7E7E7E7E7E7E7E7E0003, 0x0000472FB37E7E7E7E7E7E7E7E7E0003, 0x0000472FB47E7E7E7E7E7E7E7E7E0003, 0x0000472FB57E7E7E7E7E7E7E7E7E0003, 0x0000472FB67E7E7E7E7E7E7E7E7E0003, 0x0000472FB87E7E7E7E7E7E7E7E7E0003, 0x0000472FB97E7E7E7E7E7E7E7E7E0003, 0x0000472FBA7E7E7E7E7E7E7E7E7E0003, 0x0000472FBB7E7E7E7E7E7E7E7E7E0003, 0x0000472FBC7E7E7E7E7E7E7E7E7E0003, 0x0000472FBE7E7E7E7E7E7E7E7E7E0003, 0x0000472FC27E7E7E7E7E7E7E7E7E0003, 0x0000472FC37E7E7E7E7E7E7E7E7E0003, 0x0000472FC47E7E7E7E7E7E7E7E7E0003, 0x0000472FC57E7E7E7E7E7E7E7E7E0003, 0x0000472FC67E7E7E7E7E7E7E7E7E0003, 0x0000472FC77E7E7E7E7E7E7E7E7E0003, 0x0000472FC87E7E7E7E7E7E7E7E7E0003, 0x0000472FC97E7E7E7E7E7E7E7E7E0003, 0x0000472FCA7E7E7E7E7E7E7E7E7E0003, 0x0000472FCB7E7E7E7E7E7E7E7E7E0003, 0x0000472FD17E7E7E7E7E7E7E7E7E0003, 0x0000472FD37E7E7E7E7E7E7E7E7E0003, 0x0000472FD57E7E7E7E7E7E7E7E7E0003, 0x0000472FD97E7E7E7E7E7E7E7E7E0003, 0x0000472FDA7E7E7E7E7E7E7E7E7E0003, 0x0000472FDD7E7E7E7E7E7E7E7E7E0003, 0x0000472FE07E7E7E7E7E7E7E7E7E0003, 0x0000472FE47E7E7E7E7E7E7E7E7E0003, 0x0000472FE57E7E7E7E7E7E7E7E7E0003, 0x0000472FE67E7E7E7E7E7E7E7E7E0003, 0x0000472FE77E7E7E7E7E7E7E7E7E0003, 0x0000472FE87E7E7E7E7E7E7E7E7E0003, 0x0000472FE97E7E7E7E7E7E7E7E7E0003, 0x0000472FEA7E7E7E7E7E7E7E7E7E0003, 0x0000472FEB7E7E7E7E7E7E7E7E7E0003, 0x0000472FEC7E7E7E7E7E7E7E7E7E0003, 0x0000472FED7E7E7E7E7E7E7E7E7E0003, 0x0000472FEE7E7E7E7E7E7E7E7E7E0003, 0x0000472FEF7E7E7E7E7E7E7E7E7E0003, 0x0000472FF07E7E7E7E7E7E7E7E7E0003, 0x0000472FF17E7E7E7E7E7E7E7E7E0003, 0x0000472FF27E7E7E7E7E7E7E7E7E0003, 0x0000472FF37E7E7E7E7E7E7E7E7E0003, 0x0000472FF47E7E7E7E7E7E7E7E7E0003, 0x0000472FF57E7E7E7E7E7E7E7E7E0003, 0x0000472FF67E7E7E7E7E7E7E7E7E0003, 0x0000472FF77E7E7E7E7E7E7E7E7E0003, 0x0000472FF87E7E7E7E7E7E7E7E7E0003, 0x0000472FF97E7E7E7E7E7E7E7E7E0003, 0x0000472FFA7E7E7E7E7E7E7E7E7E0003, 0x0000472FFB7E7E7E7E7E7E7E7E7E0003, 0x0000472FFC7E7E7E7E7E7E7E7E7E0003, 0x0000472FFD7E7E7E7E7E7E7E7E7E0003, 0x0000472FFE7E7E7E7E7E7E7E7E7E0003, 0x0000472FFF7E7E7E7E7E7E7E7E7E0003, '\0\0G0\0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0	~~~~~~~~~\0', '\0\0G0
~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0
~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0~~~~~~~~~\0', '\0\0G0\"~~~~~~~~~\0', '\0\0G0$~~~~~~~~~\0', '\0\0G0%~~~~~~~~~\0', '\0\0G0&~~~~~~~~~\0', '\0\0G0\'~~~~~~~~~\0', '\0\0G0(~~~~~~~~~\0', '\0\0G0)~~~~~~~~~\0', '\0\0G0*~~~~~~~~~\0', '\0\0G0,~~~~~~~~~\0', '\0\0G00~~~~~~~~~\0', '\0\0G01~~~~~~~~~\0', '\0\0G02~~~~~~~~~\0', '\0\0G03~~~~~~~~~\0', '\0\0G04~~~~~~~~~\0', '\0\0G05~~~~~~~~~\0', '\0\0G06~~~~~~~~~\0', '\0\0G07~~~~~~~~~\0', '\0\0G08~~~~~~~~~\0', '\0\0G09~~~~~~~~~\0', '\0\0G0:~~~~~~~~~\0', '\0\0G0;~~~~~~~~~\0', '\0\0G0<~~~~~~~~~\0', '\0\0G0>~~~~~~~~~\0', '\0\0G0?~~~~~~~~~\0', '\0\0G0@~~~~~~~~~\0', '\0\0G0A~~~~~~~~~\0', '\0\0G0B~~~~~~~~~\0', '\0\0G0D~~~~~~~~~\0', '\0\0G0G~~~~~~~~~\0', '\0\0G0I~~~~~~~~~\0', '\0\0G0J~~~~~~~~~\0', '\0\0G0K~~~~~~~~~\0', '\0\0G0L~~~~~~~~~\0', '\0\0G0M~~~~~~~~~\0', '\0\0G0N~~~~~~~~~\0', '\0\0G0O~~~~~~~~~\0', '\0\0G0P~~~~~~~~~\0', '\0\0G0S~~~~~~~~~\0', '\0\0G0U~~~~~~~~~\0', '\0\0G0V~~~~~~~~~\0', '\0\0G0W~~~~~~~~~\0', '\0\0G0X~~~~~~~~~\0', '\0\0G0Y~~~~~~~~~\0', '\0\0G0Z~~~~~~~~~\0', '\0\0G0[~~~~~~~~~\0', '\0\0G0\\~~~~~~~~~\0', '\0\0G0_~~~~~~~~~\0', '\0\0G0`~~~~~~~~~\0', '\0\0G0a~~~~~~~~~\0', '\0\0G0b~~~~~~~~~\0', '\0\0G0c~~~~~~~~~\0', '\0\0G0d~~~~~~~~~\0', '\0\0G0e~~~~~~~~~\0', '\0\0G0f~~~~~~~~~\0', '\0\0G0g~~~~~~~~~\0', '\0\0G0h~~~~~~~~~\0', '\0\0G0i~~~~~~~~~\0', '\0\0G0j~~~~~~~~~\0', '\0\0G0k~~~~~~~~~\0', '\0\0G0l~~~~~~~~~\0', '\0\0G0m~~~~~~~~~\0', '\0\0G0n~~~~~~~~~\0', '\0\0G0p~~~~~~~~~\0', '\0\0G0q~~~~~~~~~\0', '\0\0G0r~~~~~~~~~\0', '\0\0G0s~~~~~~~~~\0', '\0\0G0t~~~~~~~~~\0', '\0\0G0u~~~~~~~~~\0', '\0\0G0v~~~~~~~~~\0', '\0\0G0y~~~~~~~~~\0', '\0\0G0{~~~~~~~~~\0', '\0\0G0|~~~~~~~~~\0', '\0\0G0}~~~~~~~~~\0', 0x00004730807E7E7E7E7E7E7E7E7E0003, 0x00004730817E7E7E7E7E7E7E7E7E0003, 0x00004730837E7E7E7E7E7E7E7E7E0003, 0x00004730847E7E7E7E7E7E7E7E7E0003, 0x00004730857E7E7E7E7E7E7E7E7E0003, 0x00004730867E7E7E7E7E7E7E7E7E0003, 0x00004730877E7E7E7E7E7E7E7E7E0003, 0x00004730887E7E7E7E7E7E7E7E7E0003, 0x000047308A7E7E7E7E7E7E7E7E7E0003, 0x000047308D7E7E7E7E7E7E7E7E7E0003, 0x000047308F7E7E7E7E7E7E7E7E7E0003, 0x00004730907E7E7E7E7E7E7E7E7E0003, 0x00004730917E7E7E7E7E7E7E7E7E0003, 0x00004730927E7E7E7E7E7E7E7E7E0003, 0x00004730937E7E7E7E7E7E7E7E7E0003, 0x00004730947E7E7E7E7E7E7E7E7E0003, 0x00004730957E7E7E7E7E7E7E7E7E0003, 0x00004730967E7E7E7E7E7E7E7E7E0003, 0x00004730977E7E7E7E7E7E7E7E7E0003, 0x00004730987E7E7E7E7E7E7E7E7E0003, 0x000047309A7E7E7E7E7E7E7E7E7E0003, 0x000047309B7E7E7E7E7E7E7E7E7E0003, 0x000047309C7E7E7E7E7E7E7E7E7E0003, 0x000047309D7E7E7E7E7E7E7E7E7E0003, 0x00004730A07E7E7E7E7E7E7E7E7E0003, 0x00004730A27E7E7E7E7E7E7E7E7E0003, 0x00004730A47E7E7E7E7E7E7E7E7E0003, 0x00004730A57E7E7E7E7E7E7E7E7E0003, 0x00004730A67E7E7E7E7E7E7E7E7E0003, 0x00004730A77E7E7E7E7E7E7E7E7E0003, 0x00004730AB7E7E7E7E7E7E7E7E7E0003, 0x00004730AC7E7E7E7E7E7E7E7E7E0003, 0x00004730AD7E7E7E7E7E7E7E7E7E0003, 0x00004730AE7E7E7E7E7E7E7E7E7E0003, 0x00004730AF7E7E7E7E7E7E7E7E7E0003, 0x00004730B17E7E7E7E7E7E7E7E7E0003, 0x00004730B27E7E7E7E7E7E7E7E7E0003, 0x00004730B57E7E7E7E7E7E7E7E7E0003, 0x00004730B67E7E7E7E7E7E7E7E7E0003, 0x00004730B77E7E7E7E7E7E7E7E7E0003, 0x00004730B87E7E7E7E7E7E7E7E7E0003, 0x00004730B97E7E7E7E7E7E7E7E7E0003, 0x00004730BA7E7E7E7E7E7E7E7E7E0003, 0x00004730BB7E7E7E7E7E7E7E7E7E0003, 0x00004730BC7E7E7E7E7E7E7E7E7E0003, 0x00004730BD7E7E7E7E7E7E7E7E7E0003, 0x00004730BE7E7E7E7E7E7E7E7E7E0003, 0x00004730BF7E7E7E7E7E7E7E7E7E0003, 0x00004730C07E7E7E7E7E7E7E7E7E0003, 0x00004730C17E7E7E7E7E7E7E7E7E0003, 0x00004730C27E7E7E7E7E7E7E7E7E0003, 0x00004730C37E7E7E7E7E7E7E7E7E0003, 0x00004730C47E7E7E7E7E7E7E7E7E0003, 0x00004730C67E7E7E7E7E7E7E7E7E0003, 0x00004730C77E7E7E7E7E7E7E7E7E0003, 0x00004730C87E7E7E7E7E7E7E7E7E0003, 0x00004730C97E7E7E7E7E7E7E7E7E0003, 0x00004730CA7E7E7E7E7E7E7E7E7E0003, 0x00004730CB7E7E7E7E7E7E7E7E7E0003, 0x00004730CC7E7E7E7E7E7E7E7E7E0003, 0x00004730CD7E7E7E7E7E7E7E7E7E0003, 0x00004730CE7E7E7E7E7E7E7E7E7E0003, 0x00004730CF7E7E7E7E7E7E7E7E7E0003, 0x00004730D07E7E7E7E7E7E7E7E7E0003, 0x00004730D17E7E7E7E7E7E7E7E7E0003, 0x00004730D27E7E7E7E7E7E7E7E7E0003, 0x00004730D37E7E7E7E7E7E7E7E7E0003, 0x00004730D57E7E7E7E7E7E7E7E7E0003, 0x00004730D67E7E7E7E7E7E7E7E7E0003, 0x00004730D77E7E7E7E7E7E7E7E7E0003, 0x00004730D87E7E7E7E7E7E7E7E7E0003, 0x00004730D97E7E7E7E7E7E7E7E7E0003, 0x00004730DA7E7E7E7E7E7E7E7E7E0003, 0x00004730DB7E7E7E7E7E7E7E7E7E0003, 0x00004730DC7E7E7E7E7E7E7E7E7E0003, 0x00004730DD7E7E7E7E7E7E7E7E7E0003, 0x00004730DF7E7E7E7E7E7E7E7E7E0003, 0x00004730E17E7E7E7E7E7E7E7E7E0003, 0x00004730E37E7E7E7E7E7E7E7E7E0003, 0x00004730E47E7E7E7E7E7E7E7E7E0003, 0x00004730E57E7E7E7E7E7E7E7E7E0003, 0x00004730E77E7E7E7E7E7E7E7E7E0003, 0x00004730E87E7E7E7E7E7E7E7E7E0003, 0x00004730E97E7E7E7E7E7E7E7E7E0003, 0x00004730EA7E7E7E7E7E7E7E7E7E0003, 0x00004730EB7E7E7E7E7E7E7E7E7E0003, 0x00004730EC7E7E7E7E7E7E7E7E7E0003, 0x00004730ED7E7E7E7E7E7E7E7E7E0003, 0x00004730EE7E7E7E7E7E7E7E7E7E0003, 0x00004730EF7E7E7E7E7E7E7E7E7E0003, 0x00004730F07E7E7E7E7E7E7E7E7E0003, 0x00004730F17E7E7E7E7E7E7E7E7E0003, 0x00004730F27E7E7E7E7E7E7E7E7E0003, 0x00004730F37E7E7E7E7E7E7E7E7E0003, 0x00004730F57E7E7E7E7E7E7E7E7E0003, 0x00004730F67E7E7E7E7E7E7E7E7E0003, 0x00004730F77E7E7E7E7E7E7E7E7E0003, 0x00004730F97E7E7E7E7E7E7E7E7E0003, 0x00004730FB7E7E7E7E7E7E7E7E7E0003, 0x00004730FC7E7E7E7E7E7E7E7E7E0003, 0x00004730FD7E7E7E7E7E7E7E7E7E0003, 0x00004730FE7E7E7E7E7E7E7E7E7E0003, '\0\0G1\0~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1	~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1
~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', '\0\0G1!~~~~~~~~~\0', '\0\0G1\"~~~~~~~~~\0', '\0\0G1%~~~~~~~~~\0', '\0\0G1&~~~~~~~~~\0', '\0\0G1(~~~~~~~~~\0', '\0\0G1)~~~~~~~~~\0', '\0\0G1*~~~~~~~~~\0', '\0\0G1+~~~~~~~~~\0', '\0\0G1,~~~~~~~~~\0', '\0\0G1-~~~~~~~~~\0', '\0\0G12~~~~~~~~~\0', '\0\0G13~~~~~~~~~\0', '\0\0G14~~~~~~~~~\0', '\0\0G16~~~~~~~~~\0', '\0\0G17~~~~~~~~~\0', '\0\0G18~~~~~~~~~\0', '\0\0G19~~~~~~~~~\0', '\0\0G1:~~~~~~~~~\0', '\0\0G1;~~~~~~~~~\0', '\0\0G1<~~~~~~~~~\0', '\0\0G1=~~~~~~~~~\0', '\0\0G1?~~~~~~~~~\0', '\0\0G1@~~~~~~~~~\0', '\0\0G1A~~~~~~~~~\0', '\0\0G1B~~~~~~~~~\0', '\0\0G1C~~~~~~~~~\0', '\0\0G1E~~~~~~~~~\0', '\0\0G1F~~~~~~~~~\0', '\0\0G1G~~~~~~~~~\0', '\0\0G1H~~~~~~~~~\0', '\0\0G1I~~~~~~~~~\0', '\0\0G1J~~~~~~~~~\0', '\0\0G1K~~~~~~~~~\0', '\0\0G1L~~~~~~~~~\0', '\0\0G1M~~~~~~~~~\0', '\0\0G1O~~~~~~~~~\0', '\0\0G1R~~~~~~~~~\0', '\0\0G1S~~~~~~~~~\0', '\0\0G1U~~~~~~~~~\0', '\0\0G1V~~~~~~~~~\0', '\0\0G1W~~~~~~~~~\0', '\0\0G1X~~~~~~~~~\0', '\0\0G1Y~~~~~~~~~\0', '\0\0G1Z~~~~~~~~~\0', '\0\0G1[~~~~~~~~~\0', '\0\0G1\\~~~~~~~~~\0', '\0\0G1]~~~~~~~~~\0', '\0\0G1^~~~~~~~~~\0', '\0\0G1_~~~~~~~~~\0', '\0\0G1`~~~~~~~~~\0', '\0\0G1a~~~~~~~~~\0', '\0\0G1b~~~~~~~~~\0', '\0\0G1c~~~~~~~~~\0', '\0\0G1d~~~~~~~~~\0', '\0\0G1e~~~~~~~~~\0', '\0\0G1f~~~~~~~~~\0', '\0\0G1g~~~~~~~~~\0', '\0\0G1h~~~~~~~~~\0', '\0\0G1i~~~~~~~~~\0', '\0\0G1l~~~~~~~~~\0', '\0\0G1m~~~~~~~~~\0', '\0\0G1n~~~~~~~~~\0', '\0\0G1o~~~~~~~~~\0', '\0\0G1p~~~~~~~~~\0', '\0\0G1q~~~~~~~~~\0', '\0\0G1r~~~~~~~~~\0', '\0\0G1s~~~~~~~~~\0', '\0\0G1t~~~~~~~~~\0', '\0\0G1u~~~~~~~~~\0', '\0\0G1v~~~~~~~~~\0', '\0\0G1w~~~~~~~~~\0', '\0\0G1x~~~~~~~~~\0', '\0\0G1y~~~~~~~~~\0', '\0\0G1z~~~~~~~~~\0', '\0\0G1{~~~~~~~~~\0', '\0\0G1|~~~~~~~~~\0', '\0\0G1}~~~~~~~~~\0', '\0\0G1~~~~~~~~~~\0', '\0\0G1~~~~~~~~~\0', 0x00004731807E7E7E7E7E7E7E7E7E0003, 0x00004731817E7E7E7E7E7E7E7E7E0003, 0x00004731827E7E7E7E7E7E7E7E7E0003, 0x00004731837E7E7E7E7E7E7E7E7E0003, 0x00004731847E7E7E7E7E7E7E7E7E0003, 0x00004731857E7E7E7E7E7E7E7E7E0003, 0x00004731867E7E7E7E7E7E7E7E7E0003, 0x00004731887E7E7E7E7E7E7E7E7E0003, 0x00004731897E7E7E7E7E7E7E7E7E0003, 0x000047318A7E7E7E7E7E7E7E7E7E0003, 0x000047318B7E7E7E7E7E7E7E7E7E0003, 0x000047318D7E7E7E7E7E7E7E7E7E0003, 0x000047318E7E7E7E7E7E7E7E7E7E0003, 0x000047318F7E7E7E7E7E7E7E7E7E0003, 0x00004731907E7E7E7E7E7E7E7E7E0003, 0x00004731917E7E7E7E7E7E7E7E7E0003, 0x00004731927E7E7E7E7E7E7E7E7E0003, 0x00004731937E7E7E7E7E7E7E7E7E0003, 0x00004731947E7E7E7E7E7E7E7E7E0003, 0x00004731957E7E7E7E7E7E7E7E7E0003, 0x00004731967E7E7E7E7E7E7E7E7E0003, 0x00004731977E7E7E7E7E7E7E7E7E0003, 0x00004731987E7E7E7E7E7E7E7E7E0003, 0x00004731997E7E7E7E7E7E7E7E7E0003, 0x000047319A7E7E7E7E7E7E7E7E7E0003) AND p.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 638)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 44)
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.62 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.06%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.48 ms
(0.05%)

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.46 ms
(0.05%)

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.44 ms
(0.05%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.28 ms
(0.03%)

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.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 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 250)
3	Shopware\Core\Framework\Routing\ApiRequestContextResolver->getIntegrationIdByAccessKey (line 161)
4	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolveContextSource (line 52)
5	Shopware\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 35)
6	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
7	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 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