Symfony Profiler

Query Metrics

26 Database Queries

20 Different statements

51.65 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

8.43 ms
(16.32%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

4.84 ms
(9.38%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"’jûËüüOä‘·h»üŽdv"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, `product`.`product_manufacturer_id` as `product.manufacturerId`, `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, `product`.`unit_id` as `product.unitId`, `product`.`tax_id` as `product.taxId`, `product`.`product_media_id` as `product.coverId`, `product`.`product_media_version_id` as `product.productMediaVersionId`, `product`.`delivery_time_id` as `product.deliveryTimeId`, `product`.`product_feature_set_id` as `product.featureSetId`, `product`.`canonical_product_id` as `product.canonicalProductId`, `product`.`cms_page_id` as `product.cmsPageId`, `product`.`cms_page_version_id` as `product.cmsPageVersionId`, `product`.`price` as `product.price`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock`, `product`.`restock_time` as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, `product`.`active` as `product.active`, `product`.`available_stock` as `product.availableStock`, `product`.`available` as `product.available`, `product`.`is_closeout` as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product`.`variant_listing_config` as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, `product`.`manufacturer_number` as `product.manufacturerNumber`, `product`.`ean` as `product.ean`, `product`.`purchase_steps` as `product.purchaseSteps`, `product`.`max_purchase` as `product.maxPurchase`, `product`.`min_purchase` as `product.minPurchase`, `product`.`purchase_unit` as `product.purchaseUnit`, `product`.`reference_unit` as `product.referenceUnit`, `product`.`shipping_free` as `product.shippingFree`, `product`.`purchase_prices` as `product.purchasePrices`, `product`.`mark_as_topseller` as `product.markAsTopseller`, `product`.`weight` as `product.weight`, `product`.`width` as `product.width`, `product`.`height` as `product.height`, `product`.`length` as `product.length`, `product`.`release_date` as `product.releaseDate`, `product`.`rating_average` as `product.ratingAverage`, `product`.`category_tree` as `product.categoryTree`, `product`.`property_ids` as `product.propertyIds`, `product`.`option_ids` as `product.optionIds`, `product`.`stream_ids` as `product.streamIds`, `product`.`tag_ids` as `product.tagIds`, `product`.`category_ids` as `product.categoryIds`, `product`.`child_count` as `product.childCount`, `product`.`custom_field_set_selection_active` as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, COALESCE(`product.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, COALESCE(`product.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, COALESCE(`product.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, COALESCE(`product.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.translation.updatedAt`, `product.translation.productId`, `product.translation.languageId`, `product.translation.productVersionId` FROM `product` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product`.`id` IN (0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0xE4AAFA4378C54012A08F05C8E802C057, 0x0AF2FC5332354766850D5C35C119B449, 0x1B237060A48B433283318360F3A56168, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0x18DB38E837E449498F083BF883C14800, 0x6909CB17F21E477296DE453C10A30FE6, 0xB5270A6FF32C4D1789894092740CA3E6, 0xC3C049369E114C6588F0B69E93DB2F1C, 0x43B73071A8C44EBD972DC40764409F47, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xED7C813F314342C1926E84E7A3E47DA0, 0x0DC6AF353A28451999BB7AFCB47D1308, 0xE864DCE607694DABAD29879FE82CF714, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0xECB4D04F106B43ADA966B12218ECA399, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0x996F21C3391B40509408FE51CBF74476, 0xFB6A049B05734A3F901C698D90D030B6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x926AFBCBFCFC4FE491B768BBFC8E6476));

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

4.82 ms
(9.33%)

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

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  "EF0112-8010-01"
  "EF0110-5065-03"
  "EF0112-6293-01"
  "EF0112-3510-03"
  "EF0110-2535-01"
  "EF0110-4060-03"
  "EF0110-6080-01"
  "EF0110-6060-03"
  "EF0110-2028-03"
  "EF0111-5070-01"
  "EF0111-2030-03"
  "EF0110-5050-03"
  "EF0111-2130-03"
  "EF0110-4050-01"
  "EF0111-3550-01"
  "EF0111-3042-01"
  "EF0110-2030-01"
  "EF0110-4260-01"
  "EF0110-2370-03"
  "EF0110-2130-01"
  "EF0112-3510-01"
  "EF0110-1313-03"
  "EF0112-8010-03"
  "EF0112-7070-03"
  "EF0111-6060-03"
  "EF0111-1318-03"
  "EF0111-1313-03"
  "EF0110-2430-01"
  "EF0110-3042-01"
  "EF0111-5070-03"
  "EF0112-8080-01"
  "EF0111-1318-01"
  "EF0111-6084-01"
  "EF0110-5060-01"
  "EF0112-6090-01"
  "EF0111-3045-03"
  "EF0110-5060-03"
  "EF0111-3030-01"
  "EF0110-3030-01"
  "EF0111-2028-01"
  "EF0110-2025-01"
  "EF0112-8080-03"
  "EF0111-2570-03"
  "EF0111-4060-01"
  "EF0110-2028-01"
  "EF0112-F2-01"
  "EF0110-3042-03"
  "EF0111-F1-01"
  "EF0111-2025-03"
  "EF0111-5050-03"
  "EF0110-4040-03"
  "EF0110-3550-03"
  "EF0111-4040-03"
  "EF0110-2020-03"
  "EF0110-3040-01"
  "EF0112-6090-03"
  "EF0111-2535-01"
  "EF0110-3045-03"
  "EF0110-4040-01"
  "EF0110-2130-03"
  "EF0110-1824-01"
  "EF0110-3030-03"
  "EF0111-5065-01"
  "EF0110-4050-03"
  "EF0111-2550-03"
  "EF0110-6080-03"
  "EF0111-6084-03"
  "EF0111-2370-03"
  "EF0110-2430-03"
  "EF0110-2370-01"
  "EF0111-2430-01"
  "EF0110-2550-01"
  "EF0111-2560-01"
  "EF0110-2570-01"
  "EF0111-5060-03"
  "EF0111-F1-03"
  "EF0111-2370-01"
  "EF0110-5075-03"
  "EF0110-F1-01"
  "EF0112-7070-01"
  "EF0110-2580-03"
  "EF0110-1313-01"
  "EF0110-2535-03"
  "EF0110-4260-03"
  "EF0110-F1-03"
  "EF0111-5075-03"
  "EF0111-4040-01"
  "EF0111-3042-03"
  "EF0110-5065-01"
  "EF0111-1824-03"
  "EF0110-2560-01"
  "EF0110-2020-01"
  "EF0111-5075-01"
  "EF0111-3550-03"
  "EF0110-5070-01"
  "EF0112-7010-01"
  "EF0110-4060-01"
  "EF0110-6084-03"
  "EF0111-2835-01"
  "EF0110-2570-03"
  "EF0111-2030-01"
  "EF0111-2430-03"
  "EF0110-6060-01"
  "EF0110-3040-03"
  "EF0112-5010-01"
  "EF0111-5050-01"
  "EF0111-1824-01"
  "EF0110-3045-01"
  "EF0111-2835-03"
  "EF0111-2028-03"
  "EF0111-2580-01"
  "EF0110-2550-03"
  "EF0111-2535-03"
  "EF0112-8411-01"
  "EF0110-2580-01"
  "EF0112-5010-03"
  "EF0111-1520-01"
  "EF0111-2025-01"
  "EF0110-2025-03"
  "EF0111-4260-03"
  "EF0110-5075-01"
  "EF0110-6084-01"
  "EF0111-1313-01"
  "EF0110-2835-01"
  "EF0111-2130-01"
  "EF0111-2550-01"
  "EF0111-4060-03"
  "EF0110-2560-03"
  "EF0111-3045-01"
  "EF0111-4050-03"
  "EF0111-2570-01"
  "EF0111-2560-03"
  "EF0111-5060-01"
  "EF0110-2835-03"
  "EF0110-5050-01"
  "EF0111-3040-01"
  "EF0110-3550-01"
  "EF0111-6060-01"
  "EF0111-2020-01"
  "EF0110-1520-03"
  "EF0111-1520-03"
  "EF0111-4050-01"
  "EF0112-7010-03"
  "EF0111-3030-03"
  "EF0111-2020-03"
  "EF0110-1318-03"
  "EF0111-5065-03"
  "EF0111-6080-01"
  "EF0110-1824-03"
  "EF0110-1520-01"
  "EF0111-2580-03"
  "EF0110-5070-03"
  "EF0112-8411-03"
  "EF0110-2030-03"
  "EF0111-3040-03"
  "EF0110-1318-01"
  "EF0111-4260-01"
  "EF0112-6293-03"
  "EF0111-6080-03"
  "EF0112-F2-03"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT COUNT(*) FROM (SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`product_number` IN ('EF0112-8010-01', 'EF0110-5065-03', 'EF0112-6293-01', 'EF0112-3510-03', 'EF0110-2535-01', 'EF0110-4060-03', 'EF0110-6080-01', 'EF0110-6060-03', 'EF0110-2028-03', 'EF0111-5070-01', 'EF0111-2030-03', 'EF0110-5050-03', 'EF0111-2130-03', 'EF0110-4050-01', 'EF0111-3550-01', 'EF0111-3042-01', 'EF0110-2030-01', 'EF0110-4260-01', 'EF0110-2370-03', 'EF0110-2130-01', 'EF0112-3510-01', 'EF0110-1313-03', 'EF0112-8010-03', 'EF0112-7070-03', 'EF0111-6060-03', 'EF0111-1318-03', 'EF0111-1313-03', 'EF0110-2430-01', 'EF0110-3042-01', 'EF0111-5070-03', 'EF0112-8080-01', 'EF0111-1318-01', 'EF0111-6084-01', 'EF0110-5060-01', 'EF0112-6090-01', 'EF0111-3045-03', 'EF0110-5060-03', 'EF0111-3030-01', 'EF0110-3030-01', 'EF0111-2028-01', 'EF0110-2025-01', 'EF0112-8080-03', 'EF0111-2570-03', 'EF0111-4060-01', 'EF0110-2028-01', 'EF0112-F2-01', 'EF0110-3042-03', 'EF0111-F1-01', 'EF0111-2025-03', 'EF0111-5050-03', 'EF0110-4040-03', 'EF0110-3550-03', 'EF0111-4040-03', 'EF0110-2020-03', 'EF0110-3040-01', 'EF0112-6090-03', 'EF0111-2535-01', 'EF0110-3045-03', 'EF0110-4040-01', 'EF0110-2130-03', 'EF0110-1824-01', 'EF0110-3030-03', 'EF0111-5065-01', 'EF0110-4050-03', 'EF0111-2550-03', 'EF0110-6080-03', 'EF0111-6084-03', 'EF0111-2370-03', 'EF0110-2430-03', 'EF0110-2370-01', 'EF0111-2430-01', 'EF0110-2550-01', 'EF0111-2560-01', 'EF0110-2570-01', 'EF0111-5060-03', 'EF0111-F1-03', 'EF0111-2370-01', 'EF0110-5075-03', 'EF0110-F1-01', 'EF0112-7070-01', 'EF0110-2580-03', 'EF0110-1313-01', 'EF0110-2535-03', 'EF0110-4260-03', 'EF0110-F1-03', 'EF0111-5075-03', 'EF0111-4040-01', 'EF0111-3042-03', 'EF0110-5065-01', 'EF0111-1824-03', 'EF0110-2560-01', 'EF0110-2020-01', 'EF0111-5075-01', 'EF0111-3550-03', 'EF0110-5070-01', 'EF0112-7010-01', 'EF0110-4060-01', 'EF0110-6084-03', 'EF0111-2835-01', 'EF0110-2570-03', 'EF0111-2030-01', 'EF0111-2430-03', 'EF0110-6060-01', 'EF0110-3040-03', 'EF0112-5010-01', 'EF0111-5050-01', 'EF0111-1824-01', 'EF0110-3045-01', 'EF0111-2835-03', 'EF0111-2028-03', 'EF0111-2580-01', 'EF0110-2550-03', 'EF0111-2535-03', 'EF0112-8411-01', 'EF0110-2580-01', 'EF0112-5010-03', 'EF0111-1520-01', 'EF0111-2025-01', 'EF0110-2025-03', 'EF0111-4260-03', 'EF0110-5075-01', 'EF0110-6084-01', 'EF0111-1313-01', 'EF0110-2835-01', 'EF0111-2130-01', 'EF0111-2550-01', 'EF0111-4060-03', 'EF0110-2560-03', 'EF0111-3045-01', 'EF0111-4050-03', 'EF0111-2570-01', 'EF0111-2560-03', 'EF0111-5060-01', 'EF0110-2835-03', 'EF0110-5050-01', 'EF0111-3040-01', 'EF0110-3550-01', 'EF0111-6060-01', 'EF0111-2020-01', 'EF0110-1520-03', 'EF0111-1520-03', 'EF0111-4050-01', 'EF0112-7010-03', 'EF0111-3030-03', 'EF0111-2020-03', 'EF0110-1318-03', 'EF0111-5065-03', 'EF0111-6080-01', 'EF0110-1824-03', 'EF0110-1520-01', 'EF0111-2580-03', 'EF0110-5070-03', 'EF0112-8411-03', 'EF0110-2030-03', 'EF0111-3040-03', 'EF0110-1318-01', 'EF0111-4260-01', 'EF0112-6293-03', 'EF0111-6080-03', 'EF0112-F2-03')))) total;

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

4.08 ms
(7.91%)

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

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  "EF0112-8010-01"
  "EF0110-5065-03"
  "EF0112-6293-01"
  "EF0112-3510-03"
  "EF0110-2535-01"
  "EF0110-4060-03"
  "EF0110-6080-01"
  "EF0110-6060-03"
  "EF0110-2028-03"
  "EF0111-5070-01"
  "EF0111-2030-03"
  "EF0110-5050-03"
  "EF0111-2130-03"
  "EF0110-4050-01"
  "EF0111-3550-01"
  "EF0111-3042-01"
  "EF0110-2030-01"
  "EF0110-4260-01"
  "EF0110-2370-03"
  "EF0110-2130-01"
  "EF0112-3510-01"
  "EF0110-1313-03"
  "EF0112-8010-03"
  "EF0112-7070-03"
  "EF0111-6060-03"
  "EF0111-1318-03"
  "EF0111-1313-03"
  "EF0110-2430-01"
  "EF0110-3042-01"
  "EF0111-5070-03"
  "EF0112-8080-01"
  "EF0111-1318-01"
  "EF0111-6084-01"
  "EF0110-5060-01"
  "EF0112-6090-01"
  "EF0111-3045-03"
  "EF0110-5060-03"
  "EF0111-3030-01"
  "EF0110-3030-01"
  "EF0111-2028-01"
  "EF0110-2025-01"
  "EF0112-8080-03"
  "EF0111-2570-03"
  "EF0111-4060-01"
  "EF0110-2028-01"
  "EF0112-F2-01"
  "EF0110-3042-03"
  "EF0111-F1-01"
  "EF0111-2025-03"
  "EF0111-5050-03"
  "EF0110-4040-03"
  "EF0110-3550-03"
  "EF0111-4040-03"
  "EF0110-2020-03"
  "EF0110-3040-01"
  "EF0112-6090-03"
  "EF0111-2535-01"
  "EF0110-3045-03"
  "EF0110-4040-01"
  "EF0110-2130-03"
  "EF0110-1824-01"
  "EF0110-3030-03"
  "EF0111-5065-01"
  "EF0110-4050-03"
  "EF0111-2550-03"
  "EF0110-6080-03"
  "EF0111-6084-03"
  "EF0111-2370-03"
  "EF0110-2430-03"
  "EF0110-2370-01"
  "EF0111-2430-01"
  "EF0110-2550-01"
  "EF0111-2560-01"
  "EF0110-2570-01"
  "EF0111-5060-03"
  "EF0111-F1-03"
  "EF0111-2370-01"
  "EF0110-5075-03"
  "EF0110-F1-01"
  "EF0112-7070-01"
  "EF0110-2580-03"
  "EF0110-1313-01"
  "EF0110-2535-03"
  "EF0110-4260-03"
  "EF0110-F1-03"
  "EF0111-5075-03"
  "EF0111-4040-01"
  "EF0111-3042-03"
  "EF0110-5065-01"
  "EF0111-1824-03"
  "EF0110-2560-01"
  "EF0110-2020-01"
  "EF0111-5075-01"
  "EF0111-3550-03"
  "EF0110-5070-01"
  "EF0112-7010-01"
  "EF0110-4060-01"
  "EF0110-6084-03"
  "EF0111-2835-01"
  "EF0110-2570-03"
  "EF0111-2030-01"
  "EF0111-2430-03"
  "EF0110-6060-01"
  "EF0110-3040-03"
  "EF0112-5010-01"
  "EF0111-5050-01"
  "EF0111-1824-01"
  "EF0110-3045-01"
  "EF0111-2835-03"
  "EF0111-2028-03"
  "EF0111-2580-01"
  "EF0110-2550-03"
  "EF0111-2535-03"
  "EF0112-8411-01"
  "EF0110-2580-01"
  "EF0112-5010-03"
  "EF0111-1520-01"
  "EF0111-2025-01"
  "EF0110-2025-03"
  "EF0111-4260-03"
  "EF0110-5075-01"
  "EF0110-6084-01"
  "EF0111-1313-01"
  "EF0110-2835-01"
  "EF0111-2130-01"
  "EF0111-2550-01"
  "EF0111-4060-03"
  "EF0110-2560-03"
  "EF0111-3045-01"
  "EF0111-4050-03"
  "EF0111-2570-01"
  "EF0111-2560-03"
  "EF0111-5060-01"
  "EF0110-2835-03"
  "EF0110-5050-01"
  "EF0111-3040-01"
  "EF0110-3550-01"
  "EF0111-6060-01"
  "EF0111-2020-01"
  "EF0110-1520-03"
  "EF0111-1520-03"
  "EF0111-4050-01"
  "EF0112-7010-03"
  "EF0111-3030-03"
  "EF0111-2020-03"
  "EF0110-1318-03"
  "EF0111-5065-03"
  "EF0111-6080-01"
  "EF0110-1824-03"
  "EF0110-1520-01"
  "EF0111-2580-03"
  "EF0110-5070-03"
  "EF0112-8411-03"
  "EF0110-2030-03"
  "EF0111-3040-03"
  "EF0110-1318-01"
  "EF0111-4260-01"
  "EF0112-6293-03"
  "EF0111-6080-03"
  "EF0112-F2-03"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`product_number` IN ('EF0112-8010-01', 'EF0110-5065-03', 'EF0112-6293-01', 'EF0112-3510-03', 'EF0110-2535-01', 'EF0110-4060-03', 'EF0110-6080-01', 'EF0110-6060-03', 'EF0110-2028-03', 'EF0111-5070-01', 'EF0111-2030-03', 'EF0110-5050-03', 'EF0111-2130-03', 'EF0110-4050-01', 'EF0111-3550-01', 'EF0111-3042-01', 'EF0110-2030-01', 'EF0110-4260-01', 'EF0110-2370-03', 'EF0110-2130-01', 'EF0112-3510-01', 'EF0110-1313-03', 'EF0112-8010-03', 'EF0112-7070-03', 'EF0111-6060-03', 'EF0111-1318-03', 'EF0111-1313-03', 'EF0110-2430-01', 'EF0110-3042-01', 'EF0111-5070-03', 'EF0112-8080-01', 'EF0111-1318-01', 'EF0111-6084-01', 'EF0110-5060-01', 'EF0112-6090-01', 'EF0111-3045-03', 'EF0110-5060-03', 'EF0111-3030-01', 'EF0110-3030-01', 'EF0111-2028-01', 'EF0110-2025-01', 'EF0112-8080-03', 'EF0111-2570-03', 'EF0111-4060-01', 'EF0110-2028-01', 'EF0112-F2-01', 'EF0110-3042-03', 'EF0111-F1-01', 'EF0111-2025-03', 'EF0111-5050-03', 'EF0110-4040-03', 'EF0110-3550-03', 'EF0111-4040-03', 'EF0110-2020-03', 'EF0110-3040-01', 'EF0112-6090-03', 'EF0111-2535-01', 'EF0110-3045-03', 'EF0110-4040-01', 'EF0110-2130-03', 'EF0110-1824-01', 'EF0110-3030-03', 'EF0111-5065-01', 'EF0110-4050-03', 'EF0111-2550-03', 'EF0110-6080-03', 'EF0111-6084-03', 'EF0111-2370-03', 'EF0110-2430-03', 'EF0110-2370-01', 'EF0111-2430-01', 'EF0110-2550-01', 'EF0111-2560-01', 'EF0110-2570-01', 'EF0111-5060-03', 'EF0111-F1-03', 'EF0111-2370-01', 'EF0110-5075-03', 'EF0110-F1-01', 'EF0112-7070-01', 'EF0110-2580-03', 'EF0110-1313-01', 'EF0110-2535-03', 'EF0110-4260-03', 'EF0110-F1-03', 'EF0111-5075-03', 'EF0111-4040-01', 'EF0111-3042-03', 'EF0110-5065-01', 'EF0111-1824-03', 'EF0110-2560-01', 'EF0110-2020-01', 'EF0111-5075-01', 'EF0111-3550-03', 'EF0110-5070-01', 'EF0112-7010-01', 'EF0110-4060-01', 'EF0110-6084-03', 'EF0111-2835-01', 'EF0110-2570-03', 'EF0111-2030-01', 'EF0111-2430-03', 'EF0110-6060-01', 'EF0110-3040-03', 'EF0112-5010-01', 'EF0111-5050-01', 'EF0111-1824-01', 'EF0110-3045-01', 'EF0111-2835-03', 'EF0111-2028-03', 'EF0111-2580-01', 'EF0110-2550-03', 'EF0111-2535-03', 'EF0112-8411-01', 'EF0110-2580-01', 'EF0112-5010-03', 'EF0111-1520-01', 'EF0111-2025-01', 'EF0110-2025-03', 'EF0111-4260-03', 'EF0110-5075-01', 'EF0110-6084-01', 'EF0111-1313-01', 'EF0110-2835-01', 'EF0111-2130-01', 'EF0111-2550-01', 'EF0111-4060-03', 'EF0110-2560-03', 'EF0111-3045-01', 'EF0111-4050-03', 'EF0111-2570-01', 'EF0111-2560-03', 'EF0111-5060-01', 'EF0110-2835-03', 'EF0110-5050-01', 'EF0111-3040-01', 'EF0110-3550-01', 'EF0111-6060-01', 'EF0111-2020-01', 'EF0110-1520-03', 'EF0111-1520-03', 'EF0111-4050-01', 'EF0112-7010-03', 'EF0111-3030-03', 'EF0111-2020-03', 'EF0110-1318-03', 'EF0111-5065-03', 'EF0111-6080-01', 'EF0110-1824-03', 'EF0110-1520-01', 'EF0111-2580-03', 'EF0110-5070-03', 'EF0112-8411-03', 'EF0110-2030-03', 'EF0111-3040-03', 'EF0110-1318-01', 'EF0111-4260-01', 'EF0112-6293-03', 'EF0111-6080-03', 'EF0112-F2-03'))) LIMIT 25;

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

2.70 ms
(5.22%)

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

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
  1
  500
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_configurator_setting`.`product_id`, @n+1, IF(@c:=`product_configurator_setting`.`product_id`,1,1)) as id_count, `product_configurator_setting`.`product_id`, `product_configurator_setting`.id FROM `product_configurator_setting` WHERE (`product_configurator_setting`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_configurator_setting`.`product_id` IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6))) ORDER BY `product_configurator_setting`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6);

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

2.67 ms
(5.17%)

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

Parameters:

[
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
  1
  500
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_visibility`.`product_id`, @n+1, IF(@c:=`product_visibility`.`product_id`,1,1)) as id_count, `product_visibility`.`product_id`, `product_visibility`.id FROM `product_visibility` WHERE (`product_visibility`.`product_id` IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6)) ORDER BY `product_visibility`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6);

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

2.35 ms
(4.56%)

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

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
  1
  500
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_price`.`product_id`, @n+1, IF(@c:=`product_price`.`product_id`,1,1)) as id_count, `product_price`.`product_id`, `product_price`.id FROM `product_price` WHERE (`product_price`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_price`.`product_id` IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6))) ORDER BY `product_price`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6);

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

2.35 ms
(4.54%)

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

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
  1
  500
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product`.`parent_id`, @n+1, IF(@c:=`product`.`parent_id`,1,1)) as id_count, `product`.`parent_id`, `product`.id FROM `product` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product`.`parent_id` IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6))) ORDER BY `product`.`parent_id` ASC) child ON child.parent_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6);

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

2.11 ms
(4.08%)

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

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
  1
  500
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`product_media`.`product_id`, @n+1, IF(@c:=`product_media`.`product_id`,1,1)) as id_count, `product_media`.`product_id`, `product_media`.id FROM `product_media` WHERE (`product_media`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`product_media`.`product_id` IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6))) ORDER BY `product_media`.`product_id` ASC) child ON child.product_id = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6);

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

2.07 ms
(4.02%)

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

Parameters:

[
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
  1
  500
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT LOWER(HEX(`product`.id)) as id, LOWER(HEX(child.id)) as child_id FROM `product` `product` LEFT JOIN (SELECT @n:=IF(@c=`seo_url`.`foreign_key`, @n+1, IF(@c:=`seo_url`.`foreign_key`,1,1)) as id_count, `seo_url`.`foreign_key`, `seo_url`.id FROM `seo_url` WHERE (`seo_url`.`foreign_key` IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6)) ORDER BY `seo_url`.`foreign_key` ASC) child ON child.foreign_key = `product`.id AND id_count >= 1 AND id_count <= 500 WHERE `product`.id IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6);

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

1.88 ms
(3.64%)

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

Parameters:

[
  500
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT LOWER(HEX(`tag.products.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`tag.products.mapping`.`tag_id`)) ) as `value` FROM `tag` LEFT JOIN `product_tag` `tag.products.mapping` ON `tag`.`id` = `tag.products.mapping`.`tag_id`  LEFT JOIN `product` `tag.products` ON `tag.products.mapping`.`product_id` = `tag.products`.`id`  AND `tag.products`.`version_id` = `tag.products.mapping`.`product_version_id` INNER JOIN (SELECT @n:=IF(@c=`product_tag`.`product_id`, @n+1, IF(@c:=`product_tag`.`product_id`,1,1)) as id_count, `product_tag`.`tag_id`, `product_tag`.`product_id` FROM `product_tag` `product_tag` ORDER BY `product_tag`.`product_id` ASC) counter_table ON counter_table.`product_id` = `tag.products.mapping`.`product_id` AND
                     counter_table.`tag_id` = `tag.products.mapping`.`tag_id` AND
                     counter_table.id_count <= 500 WHERE (`tag.products`.`id` IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6)) GROUP BY `tag.products.mapping`.`product_id`;

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

1.87 ms
(3.63%)

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

Parameters:

[
  "cache-id"
]

View formatted query View runnable query Explain query View query backtrace

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

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

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

1.75 ms
(3.38%)

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

Parameters:

[
  b"""
    \n
    òüS25Gf…\r\5Á\x19´I
    """
  b"\rÆ¯5:(E\x19™»zü´}\x13\x08"
  b"\x14zu™3¯Go©°Ë\r(¬º«"
  b"\x18█8Þ7õIIÅ\x08;°â┴H\x00"
  b"\e#p`¤‹C2ƒ1ƒ`ó¥ah"
  b"$╠Îç½,Iì║¸\x0F\f¹ £1"
  b"C·0q¨ÄN½—-Ä\x07d@ŸG"
  b"i\tË\x17ò\x1EGr–ÞE<\x10£\x0Fæ"
  b"yZ¹ú4JH¢Õ80ìI\x04·"
  b"{Ú÷9BpJJ’Â¢¶Ÿž>"
  b"’jûËüüOä‘·h»üŽdv"
  b"—â¤½¾\x01OåŒâæ&M\x10º="
  b"™o!Ã9\e@P”\x08þQË÷Dv"
  b"ª¢\x1E\x1E[▓MÑà¨\x01ı\x07P┤Ø"
  b"""
    «#×Ã,øAÙ¶çm()\n
    ú-
    """
  b"""
    µ'\n
    oó,M\x17‰‰@’t\f£æ
    """
  b"¾\vÜœ‡hJ´”Æý«8ôC"
  b"ÃÀI6ž\x11Leˆð¶ž“Û/\x1C"
  b"┌\x19»¦BßKÕüìÍæ^Î"
  b"õ¬·Cx┼@\x12áÅ\x05╚Þ\x02└W"
  b"èdÜæ\x07iM«)‡Ÿè,÷\x14"
  b"ì´ÐO\x10kC©f±"\x18ì£™"
  b"Ý|ü?1CB┴Ænäþúõ}á"
  b"¸c\x1C½\x14|F©½#G╝A▄?ì"
  b"¹j\x04ø\x05sJ?É\x1CiìÉð0Â"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT `tag`.`id` as `tag.id`, `tag`.`name` as `tag.name`, `tag`.`created_at` as `tag.createdAt`, `tag`.`updated_at` as `tag.updatedAt` FROM `tag` LEFT JOIN `product_tag` `tag.products.mapping` ON `tag`.`id` = `tag.products.mapping`.`tag_id`  LEFT JOIN `product` `tag.products` ON `tag.products.mapping`.`product_id` = `tag.products`.`id`  AND `tag.products`.`version_id` = `tag.products.mapping`.`product_version_id` WHERE (`tag.products`.`id` IN (0x0AF2FC5332354766850D5C35C119B449, 0x0DC6AF353A28451999BB7AFCB47D1308, 0x147A759933AF476FA9B0CB0D28ACBAAB, 0x18DB38E837E449498F083BF883C14800, 0x1B237060A48B433283318360F3A56168, 0x24CCD787AB2C498DBAF70F0CFB209C31, 0x43B73071A8C44EBD972DC40764409F47, 0x6909CB17F21E477296DE453C10A30FE6, 0x795AB9FAAD344A48A2D53830EC4904B7, 0x7BDAF73942704A4A92C2A2B69FAD9E3E, 0x926AFBCBFCFC4FE491B768BBFC8E6476, 0x97E2A4BDBE014FE58CE2E6264D10BA3D, 0x996F21C3391B40509408FE51CBF74476, 0xA6BD1E1E5BB24DA585F901D50750B49D, 0xAB23D7C32CF841D9B6E76D28290AFA2D, 0xB5270A6FF32C4D1789894092740CA3E6, 0xBE0BDC9C87684AB494ADC6FDAB38F443, 0xC3C049369E114C6588F0B69E93DB2F1C, 0xDA19AFDD42E14BE5818DF0D691F05ED7, 0xE4AAFA4378C54012A08F05C8E802C057, 0xE864DCE607694DABAD29879FE82CF714, 0xECB4D04F106B43ADA966B12218ECA399, 0xED7C813F314342C1926E84E7A3E47DA0, 0xF7631CAB147C46B8AB2347BC41DC3F8D, 0xFB6A049B05734A3F901C698D90D030B6));

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

1.69 ms
(3.28%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

1.69 ms
(3.26%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

1.48 ms
(2.87%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 34)
2	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line 108)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 155)
4	Shopware\Core\Kernel->boot (line 112)
5	Shopware\Core\HttpKernel->doHandle (line 61)
6	Shopware\Core\HttpKernel->handle (line 78)
7	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/sw6/public/index.php:68$6b77->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 12)

1.40 ms
(2.70%)

SELECT item_rounding FROM currency WHERE id = ?

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

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

1.38 ms
(2.67%)

SELECT id FROM integration WHERE access_key = ?

Parameters:

[
  "SWIANMTXSXBJV2FTC1DBWE1KWG"
]

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

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

1.19 ms
(2.30%)

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

Parameters:

[
  b"xIž·D6DÌˆ¢xÂòƒ®½"
]

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

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

0.90 ms
(1.74%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

Database Connections

Name	Service
0	default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

POST https://sw65.test.firebearstudio.com/api/search/product?q=%2Fapi%2Fsearch%2Fproduct

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache