GET https://devlex.stoffbeistoff.de/detail/f84943d1d1a54f7d8d021fb9b97803af

Response
200 OK
IP
18.188.99.196
Profiled on
Token
e86377

Query Metrics

52 Database Queries
51 Different statements
50.27 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
10.78 ms
(21.45%) 		1 
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`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`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.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` 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_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` 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 (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ž\fìÙVÈJ\x06¿Ñ#\x02¬3_¶"
  b"¥Ó£éŽ„OEˆïþÄ\•\x0Eƒ"
  b"\x01îÝy¼>r╦¼Â\x1CØ\x12╝\e)"
  b"\x01Œí“\x01ssŽŠØ\x07g\rÑ^k"
  b"\x01îÝÜ9yqbÁ¾Ø´ßıs3"
  b"\x01Œí \x10×sØŠ«e\x17r3Ñþ"
  b"\x01ì\f^▒|s±│lÎlÑÎ▀X"
  b"\x01ì\fü\t3sÓ┐þ\x12.­ÅË░"
  b"\x01ì\f╔14r\x01ñ¦uBè\x15MØ"
  b"\x01ì\f═2KqZ╝Ø®l*zo;"
  b"\x01ì\fÈ÷kr;ÖL?â{\x16¸¿"
  b"\x01ì\fαur(ÂÚ:{è\r¶^"
  b"\x01ì\f÷¯@pi╣ô\x16Öu║┐i"
  b"\x01ì\r\x01¿0r{ï<}\x1DÅO\x14\e"
  b"\x01ì\r\f*©sÌè!88╩\x17\x04N"
  b"\x01ì\r\x12nÎrÚ®*CJ¼Flz"
  b"\x01ì\r\x16\t¯qFÿ\x01ÄÙ¤\ej×"
  b"\x01ì\r\x19ü\x1Dr\Àd\x06ì█N\x12╝"
  b"\x01ì\r\x1C9ƒrc║Q\fm9Ô\x13■"
  b"\x01ì\r"\x0F\esÊú*®Â²òíâ"
  b"\x01ì\r$┼ìrZ╝\x1AçQ\x15┼J¤"
  b"\x01ì\r(─vs\x00Ø¿╠#\t­ÙÍ"
  b"\x01ì\r+\x15\q¤ûÌÄ═\x03!Ï|"
  b"\x01ì\x11_eòr\x0Fûß╚┼═ã■F"
  b"\x01ì\x11·Ñ├r┘£º×ïèÚãU"
  b"\x01ì\x12OP┤q±ƒ$ðÌ öyÀ"
  b"\x01ì\x12RA%q\x17ümÆre°Éä"
  b"\x01ì ¶ÌÉp\x19ëñ&²O>*D"
  b"\x01ì!\x00Ê─q;æÔ\x1DýoPgè"
  b"\x01ì!'dQrµøƒ╚ ╚Ä\x1C¯"
  b"\x01ì!>t¤s^ø╝¬ÿ@>═O"
  b"\x01ì!B³\x17p\x05ï_¶QÑ\x06Åd"
  b"\x01ì!G▄\x01p¤»r5\x00Å╩çâ"
  b"\x01ì!a=\x1Ds1ºç╔└\x04ç5\x1C"
  b"""
    \x01ì!hAÐr-òÑ×┴\n
    Pм
    """
  b"\x01ì!r4lp,í×(î:tı║"
  b"\x01ì!y┬Þqßô#5┘/ßïO"
  b"\x01ì!ÇP░q\x12×═®\x19¹òeU"
  b"\x01ì0"+'qe®­µ┼¦Ö\x11"
  b"\x01ì0'┐vp├«5▒└\v"^à"
  b"\x01ì0-\x0F\x15qöÅDq\v┐äU\x1E"
  b"\x01ì0èÕepÀç¶ı.ã*×╔"
  b"\x01ì0ÉåXs\x03í╠cÛÉßð|"
  b"\x01ì1\x05+ÆsÃ┐╣;\x16╠ã#T"
  b"\x01ì1\x0Eèƒq‗ºÎ\x10/¢þ©┐"
  b"\x01ì1\x1CRLqмi~É\ré¢├"
  b"\x01ì1*º\x15p(ô!Ïı(wL-"
  b"\x01ì5<Ý»pÖÄ 5¡£╩L\x12"
  b"\x01ì5~\x17Os\føDÆ╬fÛæ "
  b"\x01ì5Æp¡sz®RòàÆ/¥Ó"
  b"\x01ì5Ø╩©p└éBíxä³\x05v"
  b"\x01ì5í┘╦rjæ\x0F˧#Ý\x01v"
  b"\x01ì5Ñ‗¢r¼╝­╗ü¡&░¦"
  b"\x01ì5»ÞÝqî╣H\x06┌█£HX"
  b"\x01ì5µÔ\x18q\x12Æo«úÞ\tÏ\x04"
  b"\x01ì5■\x14\vrõ©\f┼êÀò»Ø"
  b"\x01ì6\x07v┘p1«{¹_\f*êÙ"
  b"\x01ì6\x10«]rn¥┤7│¾L\x14y"
  b"\x01ì:ii\x1Cs\x1Dößù'e\x17e "
  b"\x01ì:r;ýss╝\x15ÛVyÌ¿¤"
  b"\x01ì:w±Ts┐çØ+╦\x1A\x15]×"
  b"\x01ì:{º╣s¬ûcóoª\x1An─"
  b"\x01ì:ås\x19qݼÏß▄«\x15r\x0E"
  b"\x01ì:îä\x15qq¬'─)6Ú=\x16"
  b"\x01ìê]gÚpþ░;\x06\x1E:V¤G"
  b"\x01ìêòp¨p×│ð╚îô╝±Ô"
  b"\x01ìê╚╝ªq³øJ;*­¾&\x0E"
  b"\x01ìê┘¡\epƒå\x1E÷\x0FËv:ê"
  b"\x01ìêÛ└®s(á¾{áÉÀÛä"
  b"\x01ìì\x13\x00$p²év└$ÑV2\x01"
  b"\x01ìì\x18\vÖq\x13▒ï\t&vàí7"
  b"\x01ìì$ÆËrâîÚ\x05"ö~\x05┐"
  b"\x01ìì/×\x06püö\x16\x06}z¯9ü"
  b"\x01ììF"©pyæO╬.y¹│¹"
  b"\x01ìì]f║re«Éuê└}╦\x11"
  b"\x01ììfA╦qþíØ╦\x18á,ªT"
  b"\x01ììh\x16Õs\x1Dê▀`ÌN§\x08·"
  b"\x01쪯~┌q`╝(WÖ‗r╚╚"
  b"\x01ì└Ã┴zs%çÏXÒwÓÎÍ"
  b"\x01ì└ÎW%r▒ú┌Ø▒╗1uÒ"
  b"\x01Ž\x13_OSq”­ ,жÓeÍ"
  b"\x01Ž\x13jþ>røˆ\x1C\x12\x14J¾€\x17"
  b"""
    \x01Ž\x13l®ãpí—d¼/š—\n
    .
    """
  b"\x01Ž\x13ª,¯q^‘êG$ãÌ\x7Fø"
  b"\x01Ž\x13¸õ|qó†2Z\x12ÝMóh"
  b"\x01Ž\x13È<|qÄ£óþ–À­Õ­"
  b"\x01Ž\x17ù/ùsº‘?…\ÌÓøÃ"
  b"\x01Ž\x18L¢Hp\x04•W2Ók sØ"
  b"\x01Ž\x18TñôqT¾Qÿ\x1AH¡\x01Ž"
  b"\x01ŽuRu¸rØ­÷H”}Ãʳ"
  b"\x01Žu_‚\x01sZ ?‹Zp\x1F\x00<"
  b"\x01Äulµ\x00rüÉã\x1CDÙ\x07t\v"
  b"""
    \x01Žy«\n
    bq¨¸ðí\x05\e\e¡é
    """
  b"\x01ŽyÓ<\x10r¦¿\x1CÒæI6ÇM"
  b"\x01Žz¡I¿q\x02º_\x1C)Q?Ÿ,"
  b"\x01Äz┐É█qöè\t\x1C`\x16┬fX"
  b"\x01Ä÷\x07}Øsú¿ù~`═J¦»"
  b"\x01Žö\và\vp{»”\x1C¼ä`9h"
  b"\x01Žö(Ç)q®“ý2\x04\rr_ "
  b"\x01Å\x04Åw[q§░¯ê\x11├¤▒¤"
  b"\x01Å\x04ÿùËsB¡├l&¬§Ù\x10"
  b"\x01Å\x04ø®ür\x1Eí[\x00¶0Ú¿├"
  b"\x01Å\x05ì\x123rÉìQs¹ÀÞ\x163"
  b"\x01Å\x05ú\x7F\vp*èºñ\v\x0EU▄¦"
  b"\x01Å\x05ñ¼*p─ä\x13¿ecjþ6"
  b"""
    \x01Å\x05ÑÔ~p'Ép¼0\n
    \x08\x15õ
    """
  b"\x01Å\x05ª·erÚúc¡╗(─ð\x1F"
  b"\x01Å\x05¿#.pdéù┼\rhQ╠?"
  b"""
    \x01Å\n
    lpòp┘ÄCó\x1A½VB\x7F
    """
  b"""
    \x01Å\n
    s¶+s*î[bg\r¹Ñ|
    """
  b"""
    \x01Å\n
    wcEp¨╝;+x*­_ï
    """
  b"""
    \x01Å\n
    yiÆp]ó¹sHFı­u
    """
  b"""
    \x01Å\n
    zÝeq\eÉUºT\x08\x01nf
    """
  b"""
    \x01Å\n
    Á╬Ss/Å´ÛÑ\x13Ò{x
    """
  b"\x01Å╬n\e═p?½²é■§®h8"
  b"\x01ÅÔƒ┼│p[▒Ïo\x16J\x07dÚ"
  b"\x01ÅÔ¿┴:pHÁ²╠\x05\x0Fvôµ"
  b"\x01ÅÔ¬RïpªÜQ\x04Qý\x1F]╬"
  b"\x01É*Ǿþp╬ù╩Ë║┐R7^"
  b"\x01É*ï═;p|ëï▄\x13╣\x0F\x16O"
  b"\x01‘˜Apìs÷–lÐ\tˆ’\fÃ"
  b"\x01‘ê¡È©sÓ¶Q\x007GG0‘"
  b"\x01æÛÐYypì¡Õ2░╚\t³¢"
  b"\x01æÛÌÆEp\x19ì┘ƒ\x08hh╣ñ"
  b"\x01æÛÓòurÙØ_ò.ù\x10ƒ▄"
  b"\x01ÆLë.\x7FrmÅ@­@ñÏÿ\x06"
  b"\x01ÆLÅ&tq╔òÏ[Åpsµý"
  b"\x01ÆLô┼Æp\x1E┐àÒìÔ‗¸\x11"
  b"\x01’Lš†Usë–ë./'L_\e"
  b"\x01’LŸ_ws¶«¨…\x12ƒ÷¦‡"
  b"\x01“Ù‹çvsR«\x17<‘ΘìŸ"
  b"\x01”_°Æ\x14r±º\x04)»<Aõê"
  b"\x01”_´£Gr™´àèíŠu¦ "
  b"\x01ö_║8ÕpªÅH¬7Ëv½è"
  b"\x01”_¿U5q¡›¶\x07\x08WúÖ¢"
  b"\x01”_õrs±‚û&Ü0O&G"
  b"\x01”_È\e(sÞ½FʈäQõ]"
  b"\x01”_Ï\vþsó‹Äi¿ì“t\x01"
  b"\x01ödáÌ\ts\x0Fà┼2pñåì¿"
  b"\x01”d¨þ€qP®ýd7ñØ&Ž"
  b"\x01”d¬1€pk•8B\x08^àc*"
  b"\x01”d±™Ep˜¿\¾<:­lÚ"
  b"\x01”d´«\x0Fpʱ\x071N’É·X"
  b"\x01”dĦœs:‚÷‹9Dk\x19="
  b"\x01ödÃ┌╚p\x7FÉ£ÖN\x181ì³"
  b"""
    \x01öd╠1¢q\n
    É╬Ð=═¢\x16î
    """
  b"\x01”dÚßèqûŸïMEÖáxa"
  b"\x01”dâ÷äqÏ‹½>Ž¾+‚á"
  b"\x01”dêê»q\x02‚¢Òö\x14ê[~"
  b"\x01”dóá˜rŸŽÿ«‘Õ@ÝÇ"
  b"\x01”ßÿ”•pÞ¡ñök’\x00æ”"
  b"Žd2$d\x02@­–¦\x08\x10OmX/"
  b"\x01ÅÔwÓbqæê▀rí©\x0F▒ê"
  b"\x01ÅÔçZas■ø\x01▓S▄¥£w"
  b"Xì\x01›\x07ÆHC”\x1A:Ûê•=©"
  b"èü─\x1FomA/ô(┐:õW7\f"
  b"X\x05Å«ÙsHA¡Ey¤\x0EŸ•\x00"
]
View formatted query    View runnable query    Explain query    View query backtrace
7.90 ms
(15.72%) 		1 
# product-detail-route::read
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`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`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.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.title` as `product.manufacturer.media.title`, `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.alt` as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.customFields` as `product.manufacturer.media.customFields`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.description`, `product.manufacturer.translation.description` as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_property` `product.properties.mapping`
                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` 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_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` 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 (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` LEFT JOIN `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields` FROM `media_translation` `product.manufacturer.media.translation` WHERE `product.manufacturer.media.translation`.`language_id` = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.32 ms
(8.60%) 		1 
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
  true
  b"Ž\fìÙVÈJ\x06¿Ñ#\x02¬3_¶"
  b"Ã\x13\f?\x07\x12Gçü}v ò┬Õ\n"
  b"¥Ó£éŽ„OEˆïþÄ\•\x0Eƒ"
  b"\x01îÝy¼>r╦¼Â\x1CØ\x12╝\e)"
  b"\x01Œí“\x01ssŽŠØ\x07g\rÑ^k"
  b"\x01îÝÜ9yqbÁ¾Ø´ßıs3"
  b"\x01Œí \x10×sØŠ«e\x17r3Ñþ"
  b"\x01ŒíøµDsò˜ú\x064$\x1A-\e"
  b"\x01ì\fF/QqPù*òG¤×!3"
  b"\x01ì\f^▒|s±│lÎlÑÎ▀X"
  b"\x01ì\fü\t3sÓ┐þ\x12.­ÅË░"
  b"\x01ì\fÉJ2qaé‗Ö%EëÔÏ"
  b"\x01ì\f╔14r\x01ñ¦uBè\x15MØ"
  b"\x01ì\f═2KqZ╝Ø®l*zo;"
  b"\x01ì\fÈ÷kr;ÖL?â{\x16¸¿"
  b"\x01ì\fαur(ÂÚ:{è\r¶^"
  b"\x01ì\f÷¯@pi╣ô\x16Öu║┐i"
  b"\x01ì\r\x01¿0r{ï<}\x1DÅO\x14\e"
  b"\x01ì\r\f*©sÌè!88╩\x17\x04N"
  b"\x01ì\r\x12nÎrÚ®*CJ¼Flz"
  b"\x01ì\r\x16\t¯qFÿ\x01ÄÙ¤\ej×"
  b"\x01ì\r\x19ü\x1Dr\Àd\x06ì█N\x12╝"
  b"\x01ì\r\x1C9ƒrc║Q\fm9Ô\x13■"
  b"\x01ì\r"\x0F\esÊú*®Â²òíâ"
  b"\x01ì\r$┼ìrZ╝\x1AçQ\x15┼J¤"
  b"\x01ì\r(─vs\x00Ø¿╠#\t­ÙÍ"
  b"\x01ì\r+\x15\q¤ûÌÄ═\x03!Ï|"
  b"\x01ì\x11_eòr\x0Fûß╚┼═ã■F"
  b"\x01ì\x11·Ñ├r┘£º×ïèÚãU"
  b"\x01ì\x12OP┤q±ƒ$ðÌ öyÀ"
  b"\x01ì\x12RA%q\x17ümÆre°Éä"
  b"\x01ì ¶ÌÉp\x19ëñ&²O>*D"
  b"\x01ì!\x00Ê─q;æÔ\x1DýoPgè"
  b"\x01ì!'dQrµøƒ╚ ╚Ä\x1C¯"
  b"\x01ì!>t¤s^ø╝¬ÿ@>═O"
  b"\x01ì!B³\x17p\x05ï_¶QÑ\x06Åd"
  b"\x01ì!G▄\x01p¤»r5\x00Å╩çâ"
  b"\x01ì!a=\x1Ds1ºç╔└\x04ç5\x1C"
  b"""
    \x01ì!hAÐr-òÑ×┴\n
    Pм
    """
  b"\x01ì!r4lp,í×(î:tı║"
  b"\x01ì!y┬Þqßô#5┘/ßïO"
  b"\x01ì!ÇP░q\x12×═®\x19¹òeU"
  b"\x01ì!û8\x02pâé\x1A«Ë\x04■ײ"
  b"\x01ì0\x18"»q2ä¨>óÛÁlÖ"
  b"\x01ì0"+'qe®­µ┼¦Ö\x11"
  b"\x01ì0'┐vp├«5▒└\v"^à"
  b"\x01ì0-\x0F\x15qöÅDq\v┐äU\x1E"
  b"\x01ì0GÐkp¦ÜÇ\x1C\x17§°è║"
  b"\x01ì0èÕepÀç¶ı.ã*×╔"
  b"\x01ì0ÉåXs\x03í╠cÛÉßð|"
  b"\x01ì1\x05+ÆsÃ┐╣;\x16╠ã#T"
  b"\x01ì1\x0Eèƒq‗ºÎ\x10/¢þ©┐"
  b"\x01ì1\x1CRLqмi~É\ré¢├"
  b"\x01ì1*º\x15p(ô!Ïı(wL-"
  b"\x01ì5<Ý»pÖÄ 5¡£╩L\x12"
  b"\x01ì5~\x17Os\føDÆ╬fÛæ "
  b"\x01ì5Æp¡sz®RòàÆ/¥Ó"
  b"\x01ì5Ø╩©p└éBíxä³\x05v"
  b"\x01ì5í┘╦rjæ\x0F˧#Ý\x01v"
  b"\x01ì5Ñ‗¢r¼╝­╗ü¡&░¦"
  b"\x01ì5»ÞÝqî╣H\x06┌█£HX"
  b"\x01ì5µÔ\x18q\x12Æo«úÞ\tÏ\x04"
  b"\x01ì5■\x14\vrõ©\f┼êÀò»Ø"
  b"\x01ì6\x07v┘p1«{¹_\f*êÙ"
  b"\x01ì6\x10«]rn¥┤7│¾L\x14y"
  b"\x01ì:ii\x1Cs\x1Dößù'e\x17e "
  b"\x01ì:r;ýss╝\x15ÛVyÌ¿¤"
  b"\x01ì:w±Ts┐çØ+╦\x1A\x15]×"
  b"\x01ì:{º╣s¬ûcóoª\x1An─"
  b"\x01ì:Ç®*p«Ø▒\x19ã§ÁWà"
  b"\x01ì:ås\x19qݼÏß▄«\x15r\x0E"
  b"\x01ì:îä\x15qq¬'─)6Ú=\x16"
  b"\x01ìê]gÚpþ░;\x06\x1E:V¤G"
  b"\x01ìêòp¨p×│ð╚îô╝±Ô"
  b"\x01ìê╚╝ªq³øJ;*­¾&\x0E"
  b"\x01ìê┘¡\epƒå\x1E÷\x0FËv:ê"
  b"\x01ìêÛ└®s(á¾{áÉÀÛä"
  b"\x01ìì\x13\x00$p²év└$ÑV2\x01"
  b"\x01ìì\x18\vÖq\x13▒ï\t&vàí7"
  b"\x01ìì$ÆËrâîÚ\x05"ö~\x05┐"
  b"\x01ìì/×\x06püö\x16\x06}z¯9ü"
  b"\x01ììF"©pyæO╬.y¹│¹"
  b"\x01ìì]f║re«Éuê└}╦\x11"
  b"\x01ììfA╦qþíØ╦\x18á,ªT"
  b"\x01ììh\x16Õs\x1Dê▀`ÌN§\x08·"
  b"\x01쪯~┌q`╝(WÖ‗r╚╚"
  b"\x01ì└Ã┴zs%çÏXÒwÓÎÍ"
  b"\x01ì└ÈXCq\x7FƒNtMSHm|"
  b"\x01ì└ÎW%r▒ú┌Ø▒╗1uÒ"
  b"\x01Ž\x13_OSq”­ ,жÓeÍ"
  b"\x01Ž\x13jþ>røˆ\x1C\x12\x14J¾€\x17"
  b"""
    \x01Ž\x13l®ãpí—d¼/š—\n
    .
    """
  b"\x01Ž\x13ª,¯q^‘êG$ãÌ\x7Fø"
  b"\x01Ž\x13¸õ|qó†2Z\x12ÝMóh"
  b"\x01Ž\x13È<|qÄ£óþ–À­Õ­"
  b"\x01Ž\x17ê-FsN¥ß\x14¯ªÄ:\x14"
  b"\x01Ž\x17ó\vïp£…ç4$ÕÆÝØ"
  b"\x01Ž\x17ù/ùsº‘?…\ÌÓøÃ"
  b"\x01Ž\x18L¢Hp\x04•W2Ók sØ"
  b"\x01Ž\x18TñôqT¾Qÿ\x1AH¡\x01Ž"
  b"\x01ŽuRu¸rØ­÷H”}Ãʳ"
  b"\x01Žu_‚\x01sZ ?‹Zp\x1F\x00<"
  b"\x01Äulµ\x00rüÉã\x1CDÙ\x07t\v"
  b"""
    \x01Žy«\n
    bq¨¸ðí\x05\e\e¡é
    """
  b"\x01Žyµ\v!qü–Ö%\x08òÝJÊ"
  b"\x01ŽyÂ)òs€¹Ã¶h ºU'"
  b"\x01ŽyÓ<\x10r¦¿\x1CÒæI6ÇM"
  b"\x01ŽyÖHÝpd‰¡ÌóÓæÐû"
  b"\x01Žyå¦prhŠ8\x02¸,—çÝ"
  b"\x01Žz¡I¿q\x02º_\x1C)Q?Ÿ,"
  b"\x01Žz¯ä\x1CpJ§\x08S2Àðc|"
  b"\x01Äz┐É█qöè\t\x1C`\x16┬fX"
  b"\x01Ä÷\x07}Øsú¿ù~`═J¦»"
  b"\x01Žö\và\vp{»”\x1C¼ä`9h"
  b"\x01Žö(Ç)q®“ý2\x04\rr_ "
  b"\x01Å\x04Åw[q§░¯ê\x11├¤▒¤"
  b"\x01Å\x04ÿùËsB¡├l&¬§Ù\x10"
  b"\x01Å\x04ø®ür\x1Eí[\x00¶0Ú¿├"
  b"\x01Å\x05ì\x123rÉìQs¹ÀÞ\x163"
  b"\x01Å\x05ú\x7F\vp*èºñ\v\x0EU▄¦"
  b"\x01Å\x05ñ¼*p─ä\x13¿ecjþ6"
  b"""
    \x01Å\x05ÑÔ~p'Ép¼0\n
    \x08\x15õ
    """
  b"\x01Å\x05ª·erÚúc¡╗(─ð\x1F"
  b"\x01Å\x05¿#.pdéù┼\rhQ╠?"
  b"""
    \x01Å\n
    lpòp┘ÄCó\x1A½VB\x7F
    """
  b"""
    \x01Å\n
    s¶+s*î[bg\r¹Ñ|
    """
  b"""
    \x01Å\n
    wcEp¨╝;+x*­_ï
    """
  b"""
    \x01Å\n
    yiÆp]ó¹sHFı­u
    """
  b"""
    \x01Å\n
    zÝeq\eÉUºT\x08\x01nf
    """
  b"""
    \x01Å\n
    Á╬Ss/Å´ÛÑ\x13Ò{x
    """
  b"\x01Å.\x12òër└î\x04#\x1Ak»Y£"
  b"\x01Å╬n\e═p?½²é■§®h8"
  b"\x01ÅÔƒ┼│p[▒Ïo\x16J\x07dÚ"
  b"\x01ÅÔ¿┴:pHÁ²╠\x05\x0Fvôµ"
  b"\x01ÅÔ¬RïpªÜQ\x04Qý\x1F]╬"
  b"\x01É*Ǿþp╬ù╩Ë║┐R7^"
  b"\x01É*ï═;p|ëï▄\x13╣\x0F\x16O"
  b"\x01‘˜Apìs÷–lÐ\tˆ’\fÃ"
  b"\x01‘ê¡È©sÓ¶Q\x007GG0‘"
  b"\x01æÛÐYypì¡Õ2░╚\t³¢"
  b"\x01æÛÌÆEp\x19ì┘ƒ\x08hh╣ñ"
  b"\x01æÛÓòurÙØ_ò.ù\x10ƒ▄"
  b"\x01ÆLë.\x7FrmÅ@­@ñÏÿ\x06"
  b"\x01ÆLÅ&tq╔òÏ[Åpsµý"
  b"\x01ÆLô┼Æp\x1E┐àÒìÔ‗¸\x11"
  b"\x01’L–Ì1r\x1E´tý7Á\x7F‡C"
  b"\x01’Lš†Usë–ë./'L_\e"
  b"\x01’LŸ_ws¶«¨…\x12ƒ÷¦‡"
  b"\x01“‘§\tIs¹·a\x14¾lIÜ\x1C"
  b"\x01“‘ðÝØssºü™Ê°‡\x1D9"
  b"\x01“’\x1CqÍr\x18¢x²ýC\x1C­i"
  b"\x01“–Í[\x19p³¾þ\x11i\x17K®Ÿ"
  b"\x01“–éSòs\x19¨Ï:låeCÍ"
  b"\x01ôûÛFürµñEFEü╦\x13£"
  b"\x01ôûÙ\vgrwÀÛ\x1D\x19Ø┤Xı"
  b"\x01“Ù‹çvsR«\x17<‘ΘìŸ"
  b"\x01”_°Æ\x14r±º\x04)»<Aõê"
  b"\x01”_´£Gr™´àèíŠu¦ "
  b"\x01ö_║8ÕpªÅH¬7Ëv½è"
  b"\x01”_¿U5q¡›¶\x07\x08WúÖ¢"
  b"\x01”_õrs±‚û&Ü0O&G"
  b"\x01”_È\e(sÞ½FʈäQõ]"
  b"\x01”_Ï\vþsó‹Äi¿ì“t\x01"
  b"\x01ödáÌ\ts\x0Fà┼2pñåì¿"
  b"\x01”d¨þ€qP®ýd7ñØ&Ž"
  b"\x01”d¬1€pk•8B\x08^àc*"
  b"\x01”d±™Ep˜¿\¾<:­lÚ"
  b"\x01”d´«\x0Fpʱ\x071N’É·X"
  b"\x01”dĦœs:‚÷‹9Dk\x19="
  b"\x01ödÃ┌╚p\x7FÉ£ÖN\x181ì³"
  b"""
    \x01öd╠1¢q\n
    É╬Ð=═¢\x16î
    """
  b"\x01”dÚßèqûŸïMEÖáxa"
  b"\x01”dâ÷äqÏ‹½>Ž¾+‚á"
  b"\x01”dêê»q\x02‚¢Òö\x14ê[~"
  b"\x01”dóá˜rŸŽÿ«‘Õ@ÝÇ"
  b"\x01”ßÿ”•pÞ¡ñök’\x00æ”"
  b"Žd2$d\x02@­–¦\x08\x10OmX/"
  b"´IöiúÓH¯ª»Œã{l¶¥"
  b"]SÄK6áDX’‘¼cu:÷Þ"
  b"\x01ÅÔwÓbqæê▀rí©\x0F▒ê"
  b"\x01ÅÔçZas■ø\x01▓S▄¥£w"
  b"\x01ÅÔè_█s¤ù1Yƒ+èê"
  b"\x01ÅÔܱ)rôÉïX╝ðÓ8S"
  b"\x01“‘\x13#9q>€÷P³Ú\x14èÎ"
  b"\x01“’\x11Ñ\x13pA¨m9ˆÐ·ük"
  b"""
    \x01“–Ï\n
    ›r¥£üÀq²§\x1D\x15
    """
  b"Xì\x01›\x07ÆHC”\x1A:Ûê•=©"
  b"èü─\x1FomA/ô(┐:õW7\f"
  b"X\x05Å«ÙsHA¡Ey¤\x0EŸ•\x00"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.07 ms
(8.10%) 		1 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/detail/f84943d1d1a54f7d8d021fb9b97803af"
  "/navigation/018a8e05871277b3a98578efc759b2ae"
  "/navigation/018b0514daa07661a240c4784f1607fb"
  "/navigation/7a87c3a0613e473aa36bc385ecc48ba5"
  "/navigation/de55ac55c8744b3ba91b40943e39df3c"
  "/navigation/4d22bc54ff254743b336c146b3123ccc"
  "/navigation/018bfb93368a704e8af377e7aee49656"
  "/navigation/018eeb03f4c578b99eb910e577d32e50"
  "/navigation/00e4c01624c947fc844677be6041823b"
  "/navigation/0c5b4ddfaf954f009425d95b676966c4"
  "/navigation/f97a7bd4acb04faeba5a712260189f31"
  "/navigation/b402cab0b2c14e149544f53befcfed9f"
  "/navigation/2321866ea02f445f8fe99ab86154ab39"
  "/navigation/523e1fc48edb4fa49f4646cbdfc363f3"
  "/navigation/480c057d500b42bb93f2637f023ab85e"
  "/navigation/54e6efb5b26f4b7a9820940f4ec66b23"
  "/navigation/9f2d5ccf1e1b4e5a936541e0075c042b"
  "/navigation/018a466213977684a147cad54481e914"
  "/navigation/018b27df7b6b779b945a4d9f32a586ed"
  "/navigation/018bb31e02ff7f75813589fcc073faab"
  "/navigation/018c5d3a0dd37a90ae96d8f612981f17"
  "/navigation/018de54cf1e37130a702d8f14411136f"
  "/navigation/018fa009510f7950bc30514f13f17150"
  "/navigation/01900b15d11376e0975bf5b0c59759e2"
  "/navigation/1be10bc161df4d8fb4b2d7d794d7d70b"
  "/navigation/0192c3a069f579aa843a9cf369328e13"
  "/navigation/8aac33a98cd2432e8e5bc815ea190b8c"
  "/navigation/1de51695f23c4c4cb18945804a6be7c9"
  "/navigation/dc894dac99af4299814040fdf7f8f8de"
  "/navigation/5b93b0d06b634346af8bbd4a86478f0f"
  "/navigation/b819de59af684d9c97629478c63c43f0"
  "/navigation/018c19eefe757082a2b5543639d38b94"
  "/navigation/b9c63eb740be4bc4806693973a0417a5"
  "/navigation/99ec5149ab9e4588bdd9b8c93f7757f7"
  "/navigation/cf56d9e7a1d740569f14aa63a194d160"
  "/navigation/93f676700eed4a489d7ed42dc728f2e0"
  "/navigation/018b03e09e4871b29a575f75dbc07380"
  "/navigation/b3e8b65b967f4cd5a876a323039ebf6d"
  "/navigation/294ff0a0d4684cdb8a7afb02bf601d5d"
  "/navigation/47a458bf51fb4c21a9b0e361ee2fccad"
  "/navigation/b689a161eb1841c28b82f64d1acf2322"
  "/navigation/f479edb2a8754436893e6f9495ad5eae"
  "/navigation/018bc7ae2c9a7209b27a5ce880f4e621"
  "/navigation/f1243af5c0ae4a548d85a8e9944de228"
  "/navigation/0cf9d7e6a92343feaf2143d68e4fa2f3"
  "/navigation/018b23b3be28720881be1be7d85aaf22"
  "/navigation/018c90807d7a7ee4a491f8e0922bfd68"
  "/navigation/018dc68486f974c0823096bcc9863fc1"
  "/navigation/018de54c816376b194f2233fc6dfce7e"
  "/navigation/59209182e0c94b91b420c670c4662d14"
  "/navigation/5c3bc1e7533b47ca93637a785d855444"
  "/navigation/b2a3dd3856c348a099065eae1aaf3bca"
  "/navigation/4c41b51b942c4844998aee954bbeae8b"
  "/navigation/f34bfee8839e418abc3529e5f5153312"
  "/navigation/898edb7ebeae4ad8ad662ae3c33f7864"
  "/navigation/0504d971c57f4831b805453304d92dba"
  "/navigation/3b5cc999670243b29c2803580a42b805"
  "/navigation/018e13080490792fb97c0872296cc5a5"
  "/navigation/018f5742b7be786da8ed9d1c12ab3254"
  "/navigation/018f61629cbb70d0aa40be7a29061ca9"
  "/navigation/4f8cbc189ffc451b83501f047cd03b87"
  "/navigation/e11deed955854b88bb433f3960039144"
  "/navigation/a40362dba93a4cf08738785207dc712e"
  "/navigation/383ac47a208b4902995ac1d8501a6508"
  "/navigation/804520db365f4281ad819ab97670a467"
  "/navigation/f8198bf6f56542208e1e5d633f176bf8"
  "/navigation/018bfb951ffb74ee887375f65eeab002"
  "/navigation/018bfb9538e871bd86a4533b16a9642e"
  "/detail/8e0cecd956c84a06bfd12302ac335fb6"
  "/detail/a5d3a3e98e844f4588effec45c950e83"
  "/detail/018ced79ac3e72cbacb61c9d12bc1b29"
  "/detail/018ced930173738e8ad807670dd15e6b"
  "/detail/018ced9a39797162b5f39defe1d57333"
  "/detail/018ceda010d773d88aab65177233d1fe"
  "/detail/018d0c5eb17c73f1b36cd76ca5d7df58"
  "/detail/018d0c81093373e0bfe7122ef08fd3b0"
  "/detail/018d0cc931347201a4dd75428a154d9d"
  "/detail/018d0ccd324b715abc9da96c2a7a6f3b"
  "/detail/018d0cd4f66b723b994c3f837b16f7a8"
  "/detail/018d0cd7f1757228b6e93a7b8a0df45e"
  "/detail/018d0cf6ee407069b993169975babf69"
  "/detail/018d0d01a830727b8b3c7d1d8f4f141b"
  "/detail/018d0d0c2ab873de8a213838ca17044e"
  "/detail/018d0d126ed772e9a92a434aac466c7a"
  "/detail/018d0d1609ee714698018eebcf1b6a9e"
  "/detail/018d0d19811d725cb764068ddb4e12bc"
  "/detail/018d0d1c399f7263ba510c6d39e213fe"
  "/detail/018d0d220f1b73d2a32aa9b6fd95a183"
  "/detail/018d0d24c58d725abc1a875115c54acf"
  "/detail/018d0d28c47673009da8cc2309f0ebd6"
  "/detail/018d0d2b155c71cf96de8ecd0321d87c"
  "/detail/018d115f6595720f96e1c8c5cdc6fe46"
  "/detail/018d11faa5c372d99ca79e8b8ae9c655"
  "/detail/018d124f50b471f19f24d0deff9479b7"
  "/detail/018d125241257117816d927265f89084"
  "/detail/018d20f4de90701989a426fd4f3e2a44"
  "/detail/018d2100d2c4713b91e21dec6f50678a"
  "/detail/018d2127645172e69b9fc820c88e1cee"
  "/detail/018d213e74cf735e9bbcaa98403ecd4f"
  "/detail/018d2142fc1770058b5ff451a5068f64"
  "/detail/018d2147dc0170cfaf7235008fca8783"
  "/detail/018d21613d1d7331a787c9c00487351c"
  "/detail/018d216841d1722d95a59ec10a50d1ac"
  "/detail/018d2172346c702ca19e288c3a74d5ba"
  "/detail/018d2179c2e871e1932335d92fe18b4f"
  "/detail/018d218050b071129ecda919fb956555"
  "/detail/018d30222b277165a9f0e6c5b6dd9911"
  "/detail/018d3027bf7670c3ae35b1c00b225e85"
  "/detail/018d302d0f1571948f44710bbf84551e"
  "/detail/018d308ae56570b787f4d52ec62a9ec9"
  "/detail/018d309086587303a1cc63ea90e1d07c"
  "/detail/018d31052b9273c7bfb93b16ccc62354"
  "/detail/018d310e8a9f71f2a7d7102fbde7b8bf"
  "/detail/018d311c524c71d1ac697e900d82bdc3"
  "/detail/018d312aa71570289321d8d528774c2d"
  "/detail/018d353cedaf70998eff35ad9cca4c12"
  "/detail/018d357e174f730c9b4492ce66ea91ff"
  "/detail/018d359270ad737aa9529585922fbee0"
  "/detail/018d359dcab870c08242a17884fc0576"
  "/detail/018d35a1d9cb726a910fd3f523ed0176"
  "/detail/018d35a5f2bd72acbcf0bb81ad26b0dd"
  "/detail/018d35afe8ed718cb94806dadb9c4858"
  "/detail/018d35e6e2187112926faea3e809d804"
  "/detail/018d35fe140b72e4b80cc588b795af9d"
  "/detail/018d360776d97031ae7bfb5f0c2a88eb"
  "/detail/018d3610ae5d726ebeb437b3f34c1479"
  "/detail/018d3a69691c731d94e1972765176520"
  "/detail/018d3a723bec7373bc15ea5679dea8cf"
  "/detail/018d3a77f15473bf879d2bcb1a155d9e"
  "/detail/018d3a7ba7b973aa9663a26fa61a6ec4"
  "/detail/018d3a86731971edacd8e1dcae15720e"
  "/detail/018d3a8c84157171aa27c42936e93d16"
  "/detail/018d885d67e970e7b03b061e3a56cf47"
  "/detail/018d889570f9709eb3d0c88c93bcf1e2"
  "/detail/018d88c8bca671fc9b4a3b2af0f3260e"
  "/detail/018d88d9ad1b709f861ef60fd3763a88"
  "/detail/018d88eac0a97328a0f37ba090b7ea84"
  "/detail/018d8d13002470fd8276c024a5563201"
  "/detail/018d8d180b997113b18b09267685a137"
  "/detail/018d8d2492d372838ce90522947e05bf"
  "/detail/018d8d2f9e0670819416067d7aee3981"
  "/detail/018d8d4622b87079914fce2e79fbb3fb"
  "/detail/018d8d5d66ba7265ae907588c07dcb11"
  "/detail/018d8d6641cb71e7a19dcb18a02ca654"
  "/detail/018d8d6816e5731d88df60de4ef508fa"
  "/detail/018da6ee7eda7160bc285799f272c8c8"
  "/detail/018dc0c7c17a732587d858e377e0d7d6"
  "/detail/018dc0d7572572b1a3da9db1bb3175e3"
  "/detail/018e135f4f537194ada02cd0b6d365cd"
  "/detail/018e136afe3e72f8881c12144abe8017"
  "/detail/018e136caee370ed9764bc2f9a970a2e"
  "/detail/018e13aa2caf715e91ea4724e3cc7ff8"
  "/detail/018e13b8f57c71f386325a12dd4df368"
  "/detail/018e13c83c7c71c4a3f3fe96c0add5ad"
  "/detail/018e17f92ff973ba913f855cccd3f8c3"
  "/detail/018e184ca2487004955732d36ba073d8"
  "/detail/018e1854f1f47154be51ff1a48a1018e"
  "/detail/018e755275b872d8adf748947dc3cab3"
  "/detail/018e755f8201735aa03f8b5a701f003c"
  "/detail/018e756ce600728190c61c44eb07740b"
  "/detail/018e79ab0a6271a8b8f0ed051b1ba1e9"
  "/detail/018e79d33c1072a6bf1cd2e64936c74d"
  "/detail/018e7aa149bf7102ba5f1c29513f9f2c"
  "/detail/018e7abf90db71948a091c6016c26658"
  "/detail/018ef6077d9d73a3a8977e60cd4addaf"
  "/detail/018ef60be00b707bbb941cbce4603968"
  "/detail/018ef628c72971ae93fd32040d725fa0"
  "/detail/018f048f775b71f5b0ee8811c3cfb1cf"
  "/detail/018f049897d37342adc36c26aaf5eb10"
  "/detail/018f049ba981721ea15b00f430e9a8c3"
  "/detail/018f058d123372908d5173fbb7e81633"
  "/detail/018f05a37f0b702a8aa7a40b0e55dcdd"
  "/detail/018f05a4ac2a70c48413a865636ae736"
  "/detail/018f05a5e27e70279070ac300a0815e4"
  "/detail/018f05a6fa6572e9a363adbb28c4d01f"
  "/detail/018f05a8232e70648297c50d6851cc3f"
  "/detail/018f0a6c709570d98e43a21aab56427f"
  "/detail/018f0a73f42b732a8c5b62670dfba57c"
  "/detail/018f0a77634570f9bc3b2b782af05f8b"
  "/detail/018f0a796992705da2fb734846d5f075"
  "/detail/018f0a7aed65711b9055a75408016e66"
  "/detail/018f0ab5ce53732f8fefeaa513e37b78"
  "/detail/018fce6e1bcd703fabfd82fef5a96838"
  "/detail/018fe29fc5b3705bb1d86f164a0764e9"
  "/detail/018fe2a8c13a7048b5fdcc050f7693e6"
  "/detail/018fe2aa528b70a69a510451ec1f5dce"
  "/detail/01902a80f3e770ce97cad3babf52375e"
  "/detail/01902a8bcd3b707c898bdc13b90f164f"
  "/detail/0191984170ec73f7966cd00988920cc3"
  "/detail/0191eaa1c8a973d3b651003747473091"
  "/detail/0191ead15979708dade532b0c809fcbd"
  "/detail/0191eade924570198dd99f086868b9a4"
  "/detail/0191eae0957572eb9d5f952e97109fdc"
  "/detail/01924c892e7f726d8f40f040a4d89806"
  "/detail/01924c8f267471c995d85b8f7073e6ec"
  "/detail/01924c93c592701ebf85e38de2f2f711"
  "/detail/01924c9a865573eb96eb2e2f274c5f1b"
  "/detail/01924c9f5f7773b6aba8851283f7a687"
  "/detail/0193d98be7767352ab173c91ce98ec9f"
  "/detail/01945fb0c61472b1ba0429bb3c41f5ea"
  "/detail/01945fb4a3477299b4e0e8ed8a75a620"
  "/detail/01945fba38e570a68f48aa37d376ab8a"
  "/detail/01945fbf553571a19bb6070857fad6a2"
  "/detail/01945fc3b57273b182fb26dc304f2647"
  "/detail/01945fc81b2873debd46ca88e451f55d"
  "/detail/01945fcf0bfe73f38bc469bfec937401"
  "/detail/019464a0de09730f85c53270a4868da8"
  "/detail/019464a8fe807150aefd6437f1d8268e"
  "/detail/019464ac3180706b953842085ee0632a"
  "/detail/019464b199457098bf5cbe3c3aad6cda"
  "/detail/019464b4ab0f70cab107314e92c9b758"
  "/detail/019464c4a69c733a82f78b39446b193d"
  "/detail/019464c7dac8707f909c994e18318dfc"
  "/detail/019464cc31bd710a90ced13dcdbd168c"
  "/detail/019464dadfe871fb9fef4d45d6e17861"
  "/detail/019464e2f7e471cf8bbd3e8ebe2b82e1"
  "/detail/019464eaeabb710282a2d2f614ea5b7e"
  "/detail/019464f3e198729f8effab91d540ddc7"
  "/detail/0194dfff949570dea1f1f66b9200e694"
  "/detail/8e643224640240ad96a608104f6d582f"
  "/detail/018fe277e062719188df72a1b80fb188"
  "/detail/018fe2875a6173fe9b01b253dcbe9c77"
  "/detail/58ec019b07c64843941a3adbea953da9"
  "/detail/8a81c41f6f6d412f9328bf3ae457370c"
  "/detail/5805c5abd9734841a14579a40e9f9500"
  "/navigation/44d0c741f1c04c008728f1d3ab7ec5bf"
  "/navigation/591c1da6b3dd4940bf3872ac851abd04"
  "/navigation/484a749a1a2345f396c30b6078e4bbb2"
  "/navigation/805f99bd458c4176ae973f800e3c6f48"
  "/navigation/a89173a67c3341f998a1efb8b101547d"
  "/navigation/74c703ceae8c4d1e91ea8edfd9c7b233"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.04 ms
(8.05%) 		1 
# product-detail-route::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
  true
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.21 ms
(2.42%) 		1 
# product-detail-route::check-variant-listing-config
            SELECT
                variant_listing_config as variantListingConfig,
                parent_id as parentId
            FROM product
            WHERE id = ?
            AND version_id = ?
Parameters: 
[
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.94 ms
(1.87%) 		1 
# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"z‡Ã a>G:£kÃ…ìÄ‹¥"
  b"\x1Då\x16•ò<LL±‰E€JkçÉ"
  b"▄ëM¼Ö»BÖü@@²¸°°Ì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(1.83%) 		1 
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01îÝy¼>r╦¼Â\x1CØ\x12╝\e)"
  b"\x01Œí“\x01ssŽŠØ\x07g\rÑ^k"
  b"\x01îÝÜ9yqbÁ¾Ø´ßıs3"
  b"\x01Œí \x10×sØŠ«e\x17r3Ñþ"
  b"\x01ì\f^▒|s±│lÎlÑÎ▀X"
  b"\x01ì\fü\t3sÓ┐þ\x12.­ÅË░"
  b"\x01ì\f╔14r\x01ñ¦uBè\x15MØ"
  b"\x01ì\f═2KqZ╝Ø®l*zo;"
  b"\x01ì\fÈ÷kr;ÖL?â{\x16¸¿"
  b"\x01ì\fαur(ÂÚ:{è\r¶^"
  b"\x01ì\f÷¯@pi╣ô\x16Öu║┐i"
  b"\x01ì\r\x01¿0r{ï<}\x1DÅO\x14\e"
  b"\x01ì\r\f*©sÌè!88╩\x17\x04N"
  b"\x01ì\r\x12nÎrÚ®*CJ¼Flz"
  b"\x01ì\r\x16\t¯qFÿ\x01ÄÙ¤\ej×"
  b"\x01ì\r\x19ü\x1Dr\Àd\x06ì█N\x12╝"
  b"\x01ì\r\x1C9ƒrc║Q\fm9Ô\x13■"
  b"\x01ì\r"\x0F\esÊú*®Â²òíâ"
  b"\x01ì\r$┼ìrZ╝\x1AçQ\x15┼J¤"
  b"\x01ì\r(─vs\x00Ø¿╠#\t­ÙÍ"
  b"\x01ì\r+\x15\q¤ûÌÄ═\x03!Ï|"
  b"\x01ì\x11_eòr\x0Fûß╚┼═ã■F"
  b"\x01ì\x11·Ñ├r┘£º×ïèÚãU"
  b"\x01ì\x12OP┤q±ƒ$ðÌ öyÀ"
  b"\x01ì\x12RA%q\x17ümÆre°Éä"
  b"\x01ì ¶ÌÉp\x19ëñ&²O>*D"
  b"\x01ì!\x00Ê─q;æÔ\x1DýoPgè"
  b"\x01ì!'dQrµøƒ╚ ╚Ä\x1C¯"
  b"\x01ì!>t¤s^ø╝¬ÿ@>═O"
  b"\x01ì!B³\x17p\x05ï_¶QÑ\x06Åd"
  b"\x01ì!G▄\x01p¤»r5\x00Å╩çâ"
  b"\x01ì!a=\x1Ds1ºç╔└\x04ç5\x1C"
  b"""
    \x01ì!hAÐr-òÑ×┴\n
    Pм
    """
  b"\x01ì!r4lp,í×(î:tı║"
  b"\x01ì!y┬Þqßô#5┘/ßïO"
  b"\x01ì!ÇP░q\x12×═®\x19¹òeU"
  b"\x01ì0"+'qe®­µ┼¦Ö\x11"
  b"\x01ì0'┐vp├«5▒└\v"^à"
  b"\x01ì0-\x0F\x15qöÅDq\v┐äU\x1E"
  b"\x01ì0èÕepÀç¶ı.ã*×╔"
  b"\x01ì0ÉåXs\x03í╠cÛÉßð|"
  b"\x01ì1\x05+ÆsÃ┐╣;\x16╠ã#T"
  b"\x01ì1\x0Eèƒq‗ºÎ\x10/¢þ©┐"
  b"\x01ì1\x1CRLqмi~É\ré¢├"
  b"\x01ì1*º\x15p(ô!Ïı(wL-"
  b"\x01ì5<Ý»pÖÄ 5¡£╩L\x12"
  b"\x01ì5~\x17Os\føDÆ╬fÛæ "
  b"\x01ì5Æp¡sz®RòàÆ/¥Ó"
  b"\x01ì5Ø╩©p└éBíxä³\x05v"
  b"\x01ì5í┘╦rjæ\x0F˧#Ý\x01v"
  b"\x01ì5Ñ‗¢r¼╝­╗ü¡&░¦"
  b"\x01ì5»ÞÝqî╣H\x06┌█£HX"
  b"\x01ì5µÔ\x18q\x12Æo«úÞ\tÏ\x04"
  b"\x01ì5■\x14\vrõ©\f┼êÀò»Ø"
  b"\x01ì6\x07v┘p1«{¹_\f*êÙ"
  b"\x01ì6\x10«]rn¥┤7│¾L\x14y"
  b"\x01ì:ii\x1Cs\x1Dößù'e\x17e "
  b"\x01ì:r;ýss╝\x15ÛVyÌ¿¤"
  b"\x01ì:w±Ts┐çØ+╦\x1A\x15]×"
  b"\x01ì:{º╣s¬ûcóoª\x1An─"
  b"\x01ì:ås\x19qݼÏß▄«\x15r\x0E"
  b"\x01ì:îä\x15qq¬'─)6Ú=\x16"
  b"\x01ìê]gÚpþ░;\x06\x1E:V¤G"
  b"\x01ìêòp¨p×│ð╚îô╝±Ô"
  b"\x01ìê╚╝ªq³øJ;*­¾&\x0E"
  b"\x01ìê┘¡\epƒå\x1E÷\x0FËv:ê"
  b"\x01ìêÛ└®s(á¾{áÉÀÛä"
  b"\x01ìì\x13\x00$p²év└$ÑV2\x01"
  b"\x01ìì\x18\vÖq\x13▒ï\t&vàí7"
  b"\x01ìì$ÆËrâîÚ\x05"ö~\x05┐"
  b"\x01ìì/×\x06püö\x16\x06}z¯9ü"
  b"\x01ììF"©pyæO╬.y¹│¹"
  b"\x01ìì]f║re«Éuê└}╦\x11"
  b"\x01ììfA╦qþíØ╦\x18á,ªT"
  b"\x01ììh\x16Õs\x1Dê▀`ÌN§\x08·"
  b"\x01쪯~┌q`╝(WÖ‗r╚╚"
  b"\x01ì└Ã┴zs%çÏXÒwÓÎÍ"
  b"\x01ì└ÎW%r▒ú┌Ø▒╗1uÒ"
  b"\x01Ž\x13_OSq”­ ,жÓeÍ"
  b"\x01Ž\x13jþ>røˆ\x1C\x12\x14J¾€\x17"
  b"""
    \x01Ž\x13l®ãpí—d¼/š—\n
    .
    """
  b"\x01Ž\x13ª,¯q^‘êG$ãÌ\x7Fø"
  b"\x01Ž\x13¸õ|qó†2Z\x12ÝMóh"
  b"\x01Ž\x13È<|qÄ£óþ–À­Õ­"
  b"\x01Ž\x17ù/ùsº‘?…\ÌÓøÃ"
  b"\x01Ž\x18L¢Hp\x04•W2Ók sØ"
  b"\x01Ž\x18TñôqT¾Qÿ\x1AH¡\x01Ž"
  b"\x01ŽuRu¸rØ­÷H”}Ãʳ"
  b"\x01Žu_‚\x01sZ ?‹Zp\x1F\x00<"
  b"\x01Äulµ\x00rüÉã\x1CDÙ\x07t\v"
  b"""
    \x01Žy«\n
    bq¨¸ðí\x05\e\e¡é
    """
  b"\x01ŽyÓ<\x10r¦¿\x1CÒæI6ÇM"
  b"\x01Žz¡I¿q\x02º_\x1C)Q?Ÿ,"
  b"\x01Äz┐É█qöè\t\x1C`\x16┬fX"
  b"\x01Ä÷\x07}Øsú¿ù~`═J¦»"
  b"\x01Žö\và\vp{»”\x1C¼ä`9h"
  b"\x01Žö(Ç)q®“ý2\x04\rr_ "
  b"\x01Å\x04Åw[q§░¯ê\x11├¤▒¤"
  b"\x01Å\x04ÿùËsB¡├l&¬§Ù\x10"
  b"\x01Å\x04ø®ür\x1Eí[\x00¶0Ú¿├"
  b"\x01Å\x05ì\x123rÉìQs¹ÀÞ\x163"
  b"\x01Å\x05ú\x7F\vp*èºñ\v\x0EU▄¦"
  b"\x01Å\x05ñ¼*p─ä\x13¿ecjþ6"
  b"""
    \x01Å\x05ÑÔ~p'Ép¼0\n
    \x08\x15õ
    """
  b"\x01Å\x05ª·erÚúc¡╗(─ð\x1F"
  b"\x01Å\x05¿#.pdéù┼\rhQ╠?"
  b"""
    \x01Å\n
    lpòp┘ÄCó\x1A½VB\x7F
    """
  b"""
    \x01Å\n
    s¶+s*î[bg\r¹Ñ|
    """
  b"""
    \x01Å\n
    wcEp¨╝;+x*­_ï
    """
  b"""
    \x01Å\n
    yiÆp]ó¹sHFı­u
    """
  b"""
    \x01Å\n
    zÝeq\eÉUºT\x08\x01nf
    """
  b"""
    \x01Å\n
    Á╬Ss/Å´ÛÑ\x13Ò{x
    """
  b"\x01Å╬n\e═p?½²é■§®h8"
  b"\x01ÅÔwÓbqæê▀rí©\x0F▒ê"
  b"\x01ÅÔçZas■ø\x01▓S▄¥£w"
  b"\x01ÅÔƒ┼│p[▒Ïo\x16J\x07dÚ"
  b"\x01ÅÔ¿┴:pHÁ²╠\x05\x0Fvôµ"
  b"\x01ÅÔ¬RïpªÜQ\x04Qý\x1F]╬"
  b"\x01É*Ǿþp╬ù╩Ë║┐R7^"
  b"\x01É*ï═;p|ëï▄\x13╣\x0F\x16O"
  b"\x01‘˜Apìs÷–lÐ\tˆ’\fÃ"
  b"\x01‘ê¡È©sÓ¶Q\x007GG0‘"
  b"\x01æÛÐYypì¡Õ2░╚\t³¢"
  b"\x01æÛÌÆEp\x19ì┘ƒ\x08hh╣ñ"
  b"\x01æÛÓòurÙØ_ò.ù\x10ƒ▄"
  b"\x01ÆLë.\x7FrmÅ@­@ñÏÿ\x06"
  b"\x01ÆLÅ&tq╔òÏ[Åpsµý"
  b"\x01ÆLô┼Æp\x1E┐àÒìÔ‗¸\x11"
  b"\x01’Lš†Usë–ë./'L_\e"
  b"\x01’LŸ_ws¶«¨…\x12ƒ÷¦‡"
  b"\x01“Ù‹çvsR«\x17<‘ΘìŸ"
  b"\x01”_°Æ\x14r±º\x04)»<Aõê"
  b"\x01”_´£Gr™´àèíŠu¦ "
  b"\x01ö_║8ÕpªÅH¬7Ëv½è"
  b"\x01”_¿U5q¡›¶\x07\x08WúÖ¢"
  b"\x01”_õrs±‚û&Ü0O&G"
  b"\x01”_È\e(sÞ½FʈäQõ]"
  b"\x01”_Ï\vþsó‹Äi¿ì“t\x01"
  b"\x01ödáÌ\ts\x0Fà┼2pñåì¿"
  b"\x01”d¨þ€qP®ýd7ñØ&Ž"
  b"\x01”d¬1€pk•8B\x08^àc*"
  b"\x01”d±™Ep˜¿\¾<:­lÚ"
  b"\x01”d´«\x0Fpʱ\x071N’É·X"
  b"\x01”dĦœs:‚÷‹9Dk\x19="
  b"\x01ödÃ┌╚p\x7FÉ£ÖN\x181ì³"
  b"""
    \x01öd╠1¢q\n
    É╬Ð=═¢\x16î
    """
  b"\x01”dÚßèqûŸïMEÖáxa"
  b"\x01”dâ÷äqÏ‹½>Ž¾+‚á"
  b"\x01”dêê»q\x02‚¢Òö\x14ê[~"
  b"\x01”dóá˜rŸŽÿ«‘Õ@ÝÇ"
  b"\x01”ßÿ”•pÞ¡ñök’\x00æ”"
  b"X\x05Å«ÙsHA¡Ey¤\x0EŸ•\x00"
  b"Xì\x01›\x07ÆHC”\x1A:Ûê•=©"
  b"èü─\x1FomA/ô(┐:õW7\f"
  b"Ž\fìÙVÈJ\x06¿Ñ#\x02¬3_¶"
  b"Žd2$d\x02@­–¦\x08\x10OmX/"
  b"¥Ó£éŽ„OEˆïþÄ\•\x0Eƒ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(1.72%) 		1 
# product-detail-route::association::mainCategories::read
SELECT `main_category`.`id` as `main_category.id`, `main_category`.`product_id` as `main_category.productId`, `main_category`.`product_version_id` as `main_category.productVersionId`, `main_category`.`category_id` as `main_category.categoryId`, `main_category`.`category_version_id` as `main_category.categoryVersionId`, `main_category`.`sales_channel_id` as `main_category.salesChannelId`, `main_category`.`created_at` as `main_category.createdAt`, `main_category`.`updated_at` as `main_category.updatedAt`, `main_category.category`.`id` as `main_category.category.id`, `main_category.category`.`version_id` as `main_category.category.versionId`, `main_category.category`.`parent_id` as `main_category.category.parentId`, `main_category.category`.`parent_version_id` as `main_category.category.parentVersionId`, `main_category.category`.`after_category_id` as `main_category.category.afterCategoryId`, `main_category.category`.`after_category_version_id` as `main_category.category.afterCategoryVersionId`, `main_category.category`.`media_id` as `main_category.category.mediaId`, `main_category.category`.`display_nested_products` as `main_category.category.displayNestedProducts`, `main_category.category`.`auto_increment` as `main_category.category.autoIncrement`, `main_category.category`.`level` as `main_category.category.level`, `main_category.category`.`path` as `main_category.category.path`, `main_category.category`.`child_count` as `main_category.category.childCount`, `main_category.category`.`type` as `main_category.category.type`, `main_category.category`.`product_assignment_type` as `main_category.category.productAssignmentType`, `main_category.category`.`visible` as `main_category.category.visible`, `main_category.category`.`active` as `main_category.category.active`, `main_category.category`.`cms_page_id` as `main_category.category.cmsPageId`, `main_category.category`.`cms_page_version_id` as `main_category.category.cmsPageVersionId`, `main_category.category`.`product_stream_id` as `main_category.category.productStreamId`, `main_category.category`.`custom_entity_type_id` as `main_category.category.customEntityTypeId`, `main_category.category`.`created_at` as `main_category.category.createdAt`, `main_category.category`.`updated_at` as `main_category.category.updatedAt`, `main_category.category.translation.name`, `main_category.category.translation.name` as `main_category.category.name`, `main_category.category.translation.breadcrumb`, `main_category.category.translation.breadcrumb` as `main_category.category.breadcrumb`, `main_category.category.translation.slotConfig`, `main_category.category.translation.slotConfig` as `main_category.category.slotConfig`, `main_category.category.translation.linkType`, `main_category.category.translation.linkType` as `main_category.category.linkType`, `main_category.category.translation.internalLink`, `main_category.category.translation.internalLink` as `main_category.category.internalLink`, `main_category.category.translation.externalLink`, `main_category.category.translation.externalLink` as `main_category.category.externalLink`, `main_category.category.translation.linkNewTab`, `main_category.category.translation.linkNewTab` as `main_category.category.linkNewTab`, `main_category.category.translation.description`, `main_category.category.translation.description` as `main_category.category.description`, `main_category.category.translation.metaTitle`, `main_category.category.translation.metaTitle` as `main_category.category.metaTitle`, `main_category.category.translation.metaDescription`, `main_category.category.translation.metaDescription` as `main_category.category.metaDescription`, `main_category.category.translation.keywords`, `main_category.category.translation.keywords` as `main_category.category.keywords`, `main_category.category.translation.customFields`, `main_category.category.translation.customFields` as `main_category.category.customFields` FROM `main_category` LEFT JOIN `category` `main_category.category` ON `main_category`.`category_id` = `main_category.category`.`id` AND `main_category`.`category_version_id` = `main_category.category`.`version_id` LEFT JOIN (SELECT `main_category.category.translation`.`category_id`, `main_category.category.translation`.`category_version_id`, `main_category.category.translation`.`breadcrumb` as `main_category.category.translation.breadcrumb`, `main_category.category.translation`.`name` as `main_category.category.translation.name`, `main_category.category.translation`.`custom_fields` as `main_category.category.translation.customFields`, `main_category.category.translation`.`slot_config` as `main_category.category.translation.slotConfig`, `main_category.category.translation`.`link_type` as `main_category.category.translation.linkType`, `main_category.category.translation`.`internal_link` as `main_category.category.translation.internalLink`, `main_category.category.translation`.`external_link` as `main_category.category.translation.externalLink`, `main_category.category.translation`.`link_new_tab` as `main_category.category.translation.linkNewTab`, `main_category.category.translation`.`description` as `main_category.category.translation.description`, `main_category.category.translation`.`meta_title` as `main_category.category.translation.metaTitle`, `main_category.category.translation`.`meta_description` as `main_category.category.translation.metaDescription`, `main_category.category.translation`.`keywords` as `main_category.category.translation.keywords` FROM `category_translation` `main_category.category.translation` WHERE `main_category.category.translation`.`language_id` = ?) `main_category.category.category_translation` ON `main_category.category.category_translation`.`category_id` = `main_category.category`.`id` AND `main_category.category.category_translation`.`category_version_id` = `main_category.category`.`version_id` WHERE (`main_category`.`sales_channel_id` = ? AND `main_category`.`product_id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.82 ms
(1.63%) 		1 
# product-detail-route::association::properties::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"bï“Z'tDå¶Û[¨®5sÚ"
  b"kft║îÅO┬æü%█Ý*╚Í"
  b"kêF›ŠºC9¡|\x0EÆZÄ\x03%"
  b"t{È\x14Ø\eM\x10¼\x1C×‗ä‗┬8"
  b"ˆ\x0F\r¼(ßG¨›š†saqb\"
  b"“\e§\x12;íG±´¬â\x1Ab\x7F>N"
  b"ØôÚl6oM\x15║┌|ÔMæ]("
  b"¨£Ä\x10|,Cþ›\x10m‘\x1CÅ\x175"
  b"­?\x16c‡RLN¡¼å¾¥™hN"
  b"ÓÃ>!OµCÙµg/Ë8$å8"
  b"ÏÖ▄º╩ÍONØs+B#»╝æ"
  b"ÏÃ3¯wÈN■ñ╔¼PñE4É"
  b"ß@~Iu.K\v¸¿>\x08?0)m"
  b"ã”\x008á\x16IË—Ó}ó)U\x16P"
  b"äÄ\x1EËO\x03Gä–š´[åú,C"
  b"ç ©Õ·ZHÑ€òhE’'í‚"
  b"ýfIï̹BÛÅ$,ãÎ`óN"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.73 ms
(1.46%) 		1 
# product-cross-selling-route::association::assignedProducts::read
SELECT `product_cross_selling_assigned_products`.`id` as `product_cross_selling_assigned_products.id`, `product_cross_selling_assigned_products`.`cross_selling_id` as `product_cross_selling_assigned_products.crossSellingId`, `product_cross_selling_assigned_products`.`product_id` as `product_cross_selling_assigned_products.productId`, `product_cross_selling_assigned_products`.`product_version_id` as `product_cross_selling_assigned_products.productVersionId`, `product_cross_selling_assigned_products`.`position` as `product_cross_selling_assigned_products.position`, `product_cross_selling_assigned_products`.`created_at` as `product_cross_selling_assigned_products.createdAt`, `product_cross_selling_assigned_products`.`updated_at` as `product_cross_selling_assigned_products.updatedAt` FROM `product_cross_selling_assigned_products` WHERE (`product_cross_selling_assigned_products`.`cross_selling_id` IN (?))
Parameters: 
[
  b"7“Ø×\x06{Ef°Vcºá½"ø"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(1.37%) 		1 
# product-detail-route::find-best-variant::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((`product`.`parent_id` = ? AND ((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) ORDER BY `product`.`available` DESC, IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) ASC LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  10
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(1.20%) 		1 
# product-detail-route::association::media::read
SELECT `product_media`.`id` as `product_media.id`, `product_media`.`version_id` as `product_media.versionId`, `product_media`.`product_id` as `product_media.productId`, `product_media`.`product_version_id` as `product_media.productVersionId`, `product_media`.`media_id` as `product_media.mediaId`, `product_media`.`position` as `product_media.position`, `product_media.media`.`id` as `product_media.media.id`, `product_media.media`.`user_id` as `product_media.media.userId`, `product_media.media`.`media_folder_id` as `product_media.media.mediaFolderId`, `product_media.media`.`mime_type` as `product_media.media.mimeType`, `product_media.media`.`file_extension` as `product_media.media.fileExtension`, `product_media.media`.`uploaded_at` as `product_media.media.uploadedAt`, `product_media.media`.`file_name` as `product_media.media.fileName`, `product_media.media`.`file_size` as `product_media.media.fileSize`, `product_media.media`.`media_type` as `product_media.media.mediaTypeRaw`, `product_media.media`.`meta_data` as `product_media.media.metaData`, `product_media.media`.`config` as `product_media.media.config`, `product_media.media`.`path` as `product_media.media.path`, `product_media.media`.`private` as `product_media.media.private`, `product_media.media`.`thumbnails_ro` as `product_media.media.thumbnailsRo`, `product_media.media`.`created_at` as `product_media.media.createdAt`, `product_media.media`.`updated_at` as `product_media.media.updatedAt`, `product_media.media.translation.title`, `product_media.media.translation.title` as `product_media.media.title`, `product_media.media.translation.alt`, `product_media.media.translation.alt` as `product_media.media.alt`, `product_media.media.translation.customFields`, `product_media.media.translation.customFields` as `product_media.media.customFields`, `product_media`.`custom_fields` as `product_media.customFields`, `product_media`.`created_at` as `product_media.createdAt`, `product_media`.`updated_at` as `product_media.updatedAt` FROM `product_media` LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id` LEFT JOIN (SELECT `product_media.media.translation`.`media_id`, `product_media.media.translation`.`alt` as `product_media.media.translation.alt`, `product_media.media.translation`.`title` as `product_media.media.translation.title`, `product_media.media.translation`.`custom_fields` as `product_media.media.translation.customFields` FROM `media_translation` `product_media.media.translation` WHERE `product_media.media.translation`.`language_id` = ?) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id` WHERE (`product_media`.`version_id` = ?) AND ((`product_media`.`product_id` IN (?))) ORDER BY `product_media`.`position` ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(1.16%) 		1 
# product::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Å8.\x1Fìq\tá\x12\x07º\tJKÔ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.56 ms
(1.12%) 		1 
# product::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Å8.\x1Fòqhì‗±^\v┘ÞL"
  b"\x01Å8.Èıqv▓3Ð╠▒§JQ"
  b"\x01ôÉÑÖ.yrø(»$å);+"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(1.09%) 		1 
# breadcrumb-builder::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"▄ëM¼Ö»BÖü@@²¸°°Ì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(1.05%) 		1 
# product::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Å8.\x1Fòqhì‗±^\fO└Ý"
  b"\x01Å8.\x1Fòqhì‗±^\rng\e"
  b"\x01Å8.\x1Fòqhì‗±^\x0E3┴ì"
  b"\x01Å8.\x1Fòqhì‗±^\x10\x16©y"
  b"\x01Å8.°\x04v/ùñ┐ü/=ÅA"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.97%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
  "Baumwoll-Jersey-Trecker-SBS10279/SBS10279"
  "Baumwoll-Jersey-Trecker-SBS10279/SBS10279/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(0.90%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(0.86%) 		1 
SELECT COUNT(DISTINCT `product_review`.`id`) as `review-count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))
Parameters: 
[
  true
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(0.80%) 		1 
# product::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01Å8.\x1Fìq\tá\x12\x07º\tJKÔ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.77%) 		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) AND custom_entity.deleted_at IS NULL;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.74%) 		1 
# product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.73%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.73%) 		1 
# product-review-route::aggregation::customer-login-filter
SELECT `product_review`.`points` as `ratingMatrix.key`, COUNT(`product_review`.`id`) as `ratingMatrix.count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE ((((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) AND (((`product_review`.`status` = ?))) GROUP BY `product_review`.`points`
Parameters: 
[
  true
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.73%) 		1 
# product-cross-selling-route::read
SELECT `product_cross_selling`.`id` as `product_cross_selling.id`, `product_cross_selling`.`position` as `product_cross_selling.position`, `product_cross_selling`.`sort_by` as `product_cross_selling.sortBy`, `product_cross_selling`.`sort_direction` as `product_cross_selling.sortDirection`, `product_cross_selling`.`type` as `product_cross_selling.type`, `product_cross_selling`.`active` as `product_cross_selling.active`, `product_cross_selling`.`limit` as `product_cross_selling.limit`, `product_cross_selling`.`product_id` as `product_cross_selling.productId`, `product_cross_selling`.`product_version_id` as `product_cross_selling.productVersionId`, `product_cross_selling`.`product_stream_id` as `product_cross_selling.productStreamId`, `product_cross_selling`.`created_at` as `product_cross_selling.createdAt`, `product_cross_selling`.`updated_at` as `product_cross_selling.updatedAt`, `product_cross_selling.translation.name`, `product_cross_selling.translation.name` as `product_cross_selling.name` FROM `product_cross_selling` LEFT JOIN (SELECT `product_cross_selling.translation`.`product_cross_selling_id`, `product_cross_selling.translation`.`name` as `product_cross_selling.translation.name` FROM `product_cross_selling_translation` `product_cross_selling.translation` WHERE `product_cross_selling.translation`.`language_id` = ?) `product_cross_selling.product_cross_selling_translation` ON `product_cross_selling.product_cross_selling_translation`.`product_cross_selling_id` = `product_cross_selling`.`id` WHERE `product_cross_selling`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"7“Ø×\x06{Ef°Vcºá½"ø"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.37 ms
(0.73%) 		1 
# product-review-route::aggregation::language-filter
SELECT LOWER(HEX(`product_review`.`language_id`)) as `languageMatrix.key`, COUNT(`product_review`.`id`) as `languageMatrix.count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE ((((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) AND ((`product_review`.`language_id` = ? AND (`product_review`.`status` = ?))) GROUP BY `product_review`.`language_id`
Parameters: 
[
  true
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.66%) 		1 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.66%) 		1 
# product-cross-selling-route::search-ids
SELECT `product_cross_selling`.`id` FROM `product_cross_selling` LEFT JOIN `product` `product_cross_selling.product` ON `product_cross_selling`.`product_id` = `product_cross_selling.product`.`crossSellings` AND `product_cross_selling`.`product_version_id` = `product_cross_selling.product`.`version_id` LEFT JOIN `product` `product_cross_selling.product.parent` ON `product_cross_selling.product`.`parent_id` = `product_cross_selling.product.parent`.`id` AND `product_cross_selling.product`.`parent_version_id` = `product_cross_selling.product.parent`.`version_id` WHERE (`product_cross_selling.product`.`id` = ? AND `product_cross_selling`.`active` = ?) ORDER BY `product_cross_selling`.`position` ASC
Parameters: 
[
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.65%) 		1 
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"J¶\x11%A3C\x1C†\t\x00Ã\x10j\x0E\x04"
  b"""
    õƒÕJ ìE*ù┤"\x06R\n
    óÕ
    """
  b"íe…ä\x16AO&°»œï?Äx~"
  b"\x01Å\x05öÞ╝t2ç▄┐ûS╠±È"
  b"""
    \x01Å\x14M\n
     zÍ▓¾\x1AÖtÛ▄G
    """
  b"\x16¡i4\x17\x03D\x10³¨à(\x16Àh\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.63%) 		1 
# product-review-route::search-ids
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?))) ORDER BY `product_review`.`created_at` DESC LIMIT 10
Parameters: 
[
  true
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.63%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
  "SeZM3TTXRs8ofGiPEVFz837UXocijsSN"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.61%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.60%) 		1 
SELECT COUNT(*) FROM (# product-review-route::search-ids
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) total
Parameters: 
[
  true
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.59%) 		1 
# breadcrumb-builder::main-category::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `main_category` `category.mainCategories` ON `category`.`id` = `category.mainCategories`.`category_id` AND `category`.version_id = `category.mainCategories`.category_version_id WHERE (`category`.`version_id` = ?) AND (((`category.mainCategories`.`product_id` = ? AND `category.mainCategories`.`sales_channel_id` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ? OR `category`.`path` LIKE ?)))) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
  "%|c2cadeb85bd949f9b7b54d0b054993cd|%"
  "%|cb82c32776414286bd17859dbebdb13e|%"
  "%|ba7a5be199e742e8a986626df4a0cc00|%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.57%) 		1 
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters: 
[
  b"ä}!╠\tSO»ÑØ=└ò\x00\x7F²"
  b"Þ¨1M\x07mKB 1ß$ÿ¸\x11ï"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.57%) 		1 
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.55%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.55%) 		1 
# 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
0.28 ms
(0.55%) 		1 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.55%) 		1 
SELECT *
            FROM shipping_method_price
            WHERE HEX(shipping_method_id) = ?
              AND calculation = ?
            ORDER BY quantity_start ASC
Parameters: 
[
  "720a7b07ab6f44e4b333ac107344c5af"
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.51%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"▄ëM¼Ö»BÖü@@²¸°°Ì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.48%) 		1 
# product-detail-route::association::prices::read
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"°ICÐÐÑO}ì\x02\x1F╣╣x\x03»"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.46%) 		1 
SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = ? AND
                    pm.`active` = 1
Parameters: 
[
  b"1ýF—U’BK•[7\x08=`Ÿ\x16"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.39%) 		1 
SELECT `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` as `pickware_shipping_sales_channel_api_context.salesChannelContextToken`, `pickware_shipping_sales_channel_api_context`.`payload` as `pickware_shipping_sales_channel_api_context.payload`, `pickware_shipping_sales_channel_api_context`.`created_at` as `pickware_shipping_sales_channel_api_context.createdAt`, `pickware_shipping_sales_channel_api_context`.`updated_at` as `pickware_shipping_sales_channel_api_context.updatedAt` FROM `pickware_shipping_sales_channel_api_context` WHERE `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` IN (?)
Parameters: 
[
  "SeZM3TTXRs8ofGiPEVFz837UXocijsSN"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.38%) 		1 
# breadcrumb-builder::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`active` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ? OR `category`.`path` LIKE ?))) AND (`category`.`id` IN (?)) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  "%|c2cadeb85bd949f9b7b54d0b054993cd|%"
  "%|cb82c32776414286bd17859dbebdb13e|%"
  "%|ba7a5be199e742e8a986626df4a0cc00|%"
  b"▄ëM¼Ö»BÖü@@²¸°°Ì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.34%) 		1 
# sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters: 
[
  b"\x01‹\x1Dëþe{?¦vš.Á\x13± "
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.33%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "SeZM3TTXRs8ofGiPEVFz837UXocijsSN"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.32%) 		1 
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.31%) 		1 
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
0.15 ms
(0.29%) 		1 
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.