Query Metrics
48
Database Queries
45
Different statements
350.56 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.42 ms (41.77%) |
1 |
-- product-listing-route::loading::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"\x11×Y9ÇôEbƒ¹ˆ¤‚ÈÛ " b"\x1A¤3Á\x1FDL¢—¥L\x10&±\x05Â" b"BìÿñŸbL ´T×\x17\x15æ" b"IQ$l«+Jù¦qÎ÷¯Lº_" b"Jß”%©’Nˆp\x01½i" b"pô¸iB˜C\x01¼šƒTOÃíP" b"{q.¨«Nª†yU4sUÙ%" b"ˆ}õôùÅH:»Ë;ÍArÁ" b"‹\x03è3y™DFÎìø»aèÙ" b"›<îvYhO\e“ÒûìÓ¡\vº" b"§GÆ,‰NÍ‹l\x15ƒßÒà\x11" b"¨È\rüEDzâ\x0FÃÅ\x1Eçq" b"ªËYÀèÛA\x02š&‡Qð/Tõ" b"®ô#s®E¬¤ÀtɈ4"ð" b"±\x05¹\x19yÛJ‡¯âœ¼\x079ÁU" b"´Ÿ?q‹hD\f·\x18\\x04ŽQ\x10y" b"µðÿ\x154SMò°G\x00’ÏÁ“¼" b"º\v5x\vëDݲúïZ\vZí" b"Îu—þÒ\tI-®\x1Fi€·Eþ«" b"ÛæF–bÚKE”ÅùÅ8\x08¶," b"Þ=*Ñ6jKóšÎާ܌ý”" b""" ñ¨Cú\x03÷E\n •bw‡Jçû """ b"ù«îÒØžE_“Ž.V±T\x033" b"ú\vC—63D0‡\x16\x1Cí\x04ålb" ] |
||||||||||||||||||||||||
|
62.86 ms (17.93%) |
1 |
-- product-listing-route::loading::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.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`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.link`, `product.manufacturer.translation.link` as `product.manufacturer.link`, `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`, `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`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `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`.`file_hash` as `product.cover.media.fileHash`, `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.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.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 `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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`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.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`link` as `product.manufacturer.translation.link`, `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.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"\x0F©\x1CãéjK¾KÙÎu,4%" b"®ô#s®E¬¤ÀtɈ4"ð" b"BìÿñŸbL ´T×\x17\x15æ" b"ù«îÒØžE_“Ž.V±T\x033" b"›<îvYhO\e“ÒûìÓ¡\vº" b"Jß”%©’Nˆp\x01½i" b"´Ÿ?q‹hD\f·\x18\\x04ŽQ\x10y" b"µðÿ\x154SMò°G\x00’ÏÁ“¼" b"IQ$l«+Jù¦qÎ÷¯Lº_" b"Þ=*Ñ6jKóšÎާ܌ý”" b"pô¸iB˜C\x01¼šƒTOÃíP" b"º\v5x\vëDݲúïZ\vZí" b"§GÆ,‰NÍ‹l\x15ƒßÒà\x11" b""" ñ¨Cú\x03÷E\n •bw‡Jçû """ b"±\x05¹\x19yÛJ‡¯âœ¼\x079ÁU" b"‹\x03è3y™DFÎìø»aèÙ" b"Îu—þÒ\tI-®\x1Fi€·Eþ«" b"ªËYÀèÛA\x02š&‡Qð/Tõ" b"ú\vC—63D0‡\x16\x1Cí\x04ålb" b"\x11×Y9ÇôEbƒ¹ˆ¤‚ÈÛ " b"¨È\rüEDzâ\x0FÃÅ\x1Eçq" b"{q.¨«Nª†yU4sUÙ%" b"ˆ}õôùÅH:»Ë;ÍArÁ" b"ÛæF–bÚKE”ÅùÅ8\x08¶," b"\x1A¤3Á\x1FDL¢—¥L\x10&±\x05Â" ] |
||||||||||||||||||||||||
|
60.19 ms (17.17%) |
1 |
-- product-listing-route::loading::aggregation::properties SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` 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 LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id` AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.properties`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"Íe’Æ6®Kóƒx°\x1A›1äm" true b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" null true false ] |
||||||||||||||||||||||||
|
23.41 ms (6.68%) |
1 |
-- product-listing-route::loading::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 LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_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.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product`.`display_group` ORDER BY MIN(`product`.`product_number`) ASC, MIN(`product`.`id`) ASC LIMIT 24 OFFSET 96
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"Íe’Æ6®Kóƒx°\x1A›1äm" true b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" null true false ] |
||||||||||||||||||||||||
|
16.20 ms (4.62%) |
1 |
SELECT COUNT(*) FROM (-- product-listing-route::loading::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 LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_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.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product`.`display_group`) total
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"Íe’Æ6®Kóƒx°\x1A›1äm" true b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" null true false ] |
||||||||||||||||||||||||
|
15.31 ms (4.37%) |
1 |
-- product-listing-route::loading::aggregation::options SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` 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 LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id` AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id` AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id` AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.options`.`id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" 30 b"Íe’Æ6®Kóƒx°\x1A›1äm" true b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" null true false ] |
||||||||||||||||||||||||
|
14.34 ms (4.09%) |
3 |
-- product-listing::property-filter::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.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`file_hash` as `property_group_option.media.fileHash`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.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 `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`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.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x00h^ûß\x07ع\x17¯9œ\x1A =" b"\x00n˜S\x1AÆMº³c®[~\\x15" b"\x00v…\x02yÊN+þWíÆ\x19²×\x08" b"\x00y]í\f\x00I¸·[/ô2íc\" b"\x00~\x16ÉÞ6O†…fúbÅ\x13œv" b"\x00ÔËêRK2«"[Ŭ\x0Fõ\x1E" b"\x00Ÿ½ûAѧ\x10Åe^:\x18\x15Ð" b"\x00¦÷ 6…I×¢žÎ\fæÐXU" b"\x00²\rO™sI\x06€[Þ~mÔ3a" b"\x00Ó\x04 »0M:½Ä‘†S¨Ëv" b"\x00Úîj\x07œAl©)Û\x08\x07G\x02>" b"\x00ß[\x10ç’C\n·kk²lÛ\fÓ" b"\x00ã{öùJH!`ˆ*ôܾÁ" b"\x00äUþKøIþŠ\x06ùSx’nï" b"\x00çÃÓáFIQ¡\½õóÞeÒ" b"\x01\x1D9*ñ¿J'€;¤øÖé\x10Z" b"\x01(À@7ÐAó„9½\e¡¸sh" b"\x01CÁ\x00i€»\x15ˆ†éqJ,wF" b""" \x01G\n Ý\x1DýLJªw\x10\x1E1rMÎ """ b"\x01NÎÛ‡ãKÒöb\x1A=ý±Ö" b"\x01S\x17FO\x06IÂ\v´-btDM" b"\x01V<zXCH{§½æÍf‰ª¦" b"\x01Y&\x1EЮC\x05©\x14\e¸ÆÔŽ—" b"\x01cäðž@3¤\x03*×Ü :" b"\x01déß XE\x10†ÆÿÀ\x06T)”" b"\x01l<¥ºˆEk™›\x017†©ç\f" b"\x01m W¼\fOL¦êòŠ:_\x16‚" b"\x01m#k\x1F\x17/¨kí 3J*O" b"\x01‹\x1D-|x@R½\7\fFÊ—," b"\x01—\x01\e\x15¡Eóž+œ\x1A)¦q" b"\x01Å´y\eC(Š›ú^²ZuÇ" b"\x01Æé-Fú1oÏ3žw+\x03\x04\x16" b"\x01ȱýCIN6šM¯È»mï3" b"\x01ÉZ¢›×IG 6\x17ÅÛÊÔ" b"\x01Ìvæúù¹Ö\x10f7H㱉" b"\x01ÍdRI®]ž4n½$[¸\x11Æ" b"\x01ÓATÙ(HÑž…²|\x10\x7FV/" b"\x01Õi\f©&Gœ¤\x1F)Ûdë\x05" b"\x01ß\\x14>eë@‚#\x18j¶ëR" b"\x02\x06Õ\x01\x13èä-}Œ)¦ô½\x16@" b""" \x02\n ï.¨iOA‰µÁõt\x03m """ b"\x02\föèg\x18Ch†ÉAnÖNû‹" b"\x02\x0FÒ¨‹\x1EB+²Þ¸y~‹›m" b"\x02\x16ÏTÓÂN¦Ê8ÌV±nð" b"\x02'L’\rbH¥ª\vß!€\fâã" b"\x02)Àw#|FW¿Ñ\x14\x00Ô;\x0F¢" b"\x02-/Ö\x06<HR±\x01\x12‡%¹Õ“" b"\x023I\x0E:,Ek¿\x1A\x05#yc^" b"\x02<æ ‘\tî+ÈÕ&Wë¤.;" b"\x02G\x03¯«aE·¤øA§dÌæÌ" b"\x02szþÓ|O÷—Ȭ¬á¡Ù" b"\x02‘çxP¼\x16ÅeÔ«E‘>\r" b"\x02¢—›U™I,©î\t\v_\x03òæ" b"\x02´Rÿ-7\x05$cUÀ/\x15(Pø" b"\x02µÀø'JÝ‹k«3ûó=" b"\x02ÄH@ý%E¦Œd÷z™ýY›" b"\x02͹l÷\fF%”\x0F\f§\x04§ù›" b""" \x02ýÑH{eèÃÝ\vx¸\n nâM """ b"\x03\t\x07ô+€ÞUbìy–\x07ðë" b"\x03*q±\x04—J¹»ÖÛ\x03Zq\x16>" b"\x03-=Á¿Ê$|slN\x0EÞT§i" b"\x03EþÇî\tMĪ6Ù\x02µÀ–" b"\x03W«\x1Cø(O\x13„\x13\x13Y£a\x18å" b"\x03e熑ymšîÞ\eF@š\x15\t" b"\x03rǽxûGµ¸\x04̧”7o" b""" \x03uI\x0E+ÿq\n ™Ž7\x7F¼¡DÎ """ b"\x03wðqs\x1D4ƒ×xMñuA\x06-" b"\x03yyçX¤Kk³\x19\x10²îÙ?‹" b"\x03€’¾k N£¡\x0EáTìÏú" b"\x03Œn%§pDx¼„ÿ\x12äslÄ" b"\x03¦¼\x03òQ¼òáâÒà^Î\x02 " b"\x03Ò\VÝ°L pÀAZÆ" b"\x03ÒŒ\x05Ž^ûáå‚Ô6ˆÒ>A" b"\x03õF\x0F•SD²€ÔÇ\x1E&˜»Ë" b"\x03ûq\x12\x1F¡<w'¯Ÿ\x7F8\fÆ‚" b"\x04\x02G…JTLÞ°¢n PM\x05æ" b"\x04\x13›ÀAÿM“‹\x06YRìÂjØ" b"\x04\x1A\x05T@yèßÁ<tw/FÜ," b"\x04\x1C8íyf\x11(ÁF¨$Ê \x06" b"\x04\x1DHe…UAB†Ç@û5Ž£¼" b"\x04KZÅ\x15˜òMáì\x12`c\x1DXÝ" b"\x04L6à\x1EÉK\x00Ó<ô’£GÕ" b"\x04ivßäxD„ˆ(áûþxO€" b""" \x04k™z\n cA\t¢ÞQýÀ)8ˆ """ b"\x04“„ÿw«Cý†Û8óWC(ñ" b"\x04«ýãb²D2$Làœöv8" b"\x04³ºKóAy‘qì‹Xî#¸" b"\x04Ú!qWJ\f‚ß\x7F´ûB\x14–" b"\x04á=\x06\x0FõO1‚Fõý\x00Kì”" b"\x04㱞ОAքЦ”›Õ\f" b"\x04ó=”6\tzX\x1E\x06«”®³ˆ" b"\x04û&‚\x15Óu\ò/ò[ƒ]Št" b"\x05\x07Ç3[ÎEŸ‡GŸúÐ_–!" b"\x05,; 5Z%%Éýy\x1EoË" b"\x057%\x1C:ñGU¹û\x14p®gõ\r" b"\x05J°rþ‰BE¦\x19ð¾ZÃxq" b"\x05MHw†xMæ“\x06v…¹†»\r" b"\x05V³"~ÊK|³›6\r'<pÔ" b"\x05YzJ„eJ–°)½¤ˆ\x04\x0FM" b"\x05a\x066›nþ\x05ßnl´Zç~\n" b"\x05uü.ßüCä†wOQ¦-S" b"\x05€@ZCˆD<ªOó\x10XW\t”" b"\x05…ÄX8¢EpŠÎâ ò£‹8" b"\x05š˜òعD²¼ƒ\x16¾{\th´" b"\x05œ¡ýíÇOXŽäq‡*Aø" b"\x05¯»æ\x11DÃÕ»à (öˆ*õ" b"\x05Ìaˆ\vã ,žgƒ&Ò™ge" b"\x05Øâböã@0»[™;‡(\x01¶" b"\x06#|ƒŽYBÉ¥X¶Ñª\x05Ýò" b"\x064Ò•EÒï$\x15í½4ö§y’" b"\x06:v\x13àO÷\x01öDÑ\v°Ê’ò" b"\x06k€\x10FMøäzÏø«w" b"\x06ƒ;øˆÂÁ¥t,q²ÿ–ù " b"\x06š\\x04)@-”ÏßDW\x06ÈJ" b"\x06¹Ðô€Ñ€>G¶\x18Dœ\x1Fxª" b"\x06À×>ð.NE¹WZ4Ä\x1F÷" b"\x06Ñé¼H+ñæ¸ÊGÇj‘ºN" b"\x06áà\x01™:F\x19…æí˜B¶\x0EO" b"\x06éS8ŽðO‘©R\rÛRÛ“" b"\x06ìªP8µH\x12£$îU‡s\x1F–" b"\x06í^¾qŒCÓ¾)\x13õ©\x1AüÆ" b"\x06óÖRò\x16J½Üü¦þ¨8Ä" b"\x06þàƒG±›ÂAÇAïÔ=.œ" b""" \x07>ûñ™ø`NgdÝ\x17\x01\n /Ž """ b"\x07G,\x16©'IùœÍžüì(òÓ" b"\x07IZH\x06C…¿Ë1íWv\x1EË" b"\x07U’ \e"IЂžJš²\x1E\x7F\x15" b"\x07hôF(\eeUùš¯ñ^ÎRÚ" b"\x07lìÂQçC`ÖÒ\x18D\Â\x1F" b"\x07‰{Ù±I¼Œ\x0FÍk¾mæY" b"\x07†\x1F¯)\x00L”'ì©?ä;W" b"\x07šæ¯€ôN3Æp\x139˜&s" b"\x07ÐÓâÉKD洛¯\v”5íL" b"\x07ÖË.•¯Gÿ®ÂÈ\x13.ž8d" b"\x07ákCnŽ¦ö–Z\x02¯u\x1Cº" b"\x07çrAJº•ß :›ôdÏÁý" b"\x08\x07/Óât@ó‡Ãw˜žb\x1F+" b"\x08\x13=ÝÝ¢3\ê^ß~òšüv" b"\x08/¿gÀÅqâùs4Z-\x07›9" b"\x089\x02ɶvC‡˜\x07M\x16¾ø\x0Fv" b"\x08K‰\x10‘éDû´¥˜™OmfX" b"\x08U„\x00ãNGñ¢ÙE…³d%à" b"\x08¡ÇlÒ1Fƒ“,Ѭ8¹Õ" b"\x08®F\x13˜¹FDŽƒÝ0ªÑÏÙ" b"\x08åC€êŠEš Ô€Õwî\x11\x1C" b"\t\x07Ç? (G¶»\vu\røˆ¦\x18" b"\t\tG\t`„1Ç\x1A\x07šZLhE\x07" b"\t\v\x1F£ú\eJ\r˜¿‰©6\x1Aö…" b"\t\rÌõÍùæ½ù“ä\x1FL“-®" b"\t+ÝEðÿ#íœ\x1DRk0vK" b"\tEœq)\x16Gw|\x16\x1Fœ"ÕD—" b"\ts äNMA\t±d¬m-vÏ" b"\t‚Ñ›ý„IA¹þÖ\x03\x03›ó" b"\tˆ$œœ.M°œ7C!,(\x15Y" b"\t\x1Dð\x1A€´Ë\x07¿zíè\x0Fc" b"\t×O±\eJ\x1D3JƒóQµ^" b"\tß»y,ÓLᆉA»j9wâ" b"\tãïÄu›—iq™gº MϪ" b""" \n \x03ßèFßL–œŒÚ‹V£ª """ b""" \n \x04׎ÛtAL‡ÓLH\x1F\x12êÐ """ b""" \n \x0EQ\x15\x07ÕO’’g¥fW$3’ """ b""" \n \e©c1¶\x03ÎuR/(»\x16ÓD """ b""" \n ?\x1CE4cCó™…|(v'Øþ """ b""" \n YFÀ±D.ž\x01ºC9† """ b""" \n n|©faA9¥_ß\e\x1A“PÕ """ b""" \n qõ6NŒ\x11ék\x15\\vjJä* """ b""" \n u)¤\x04\rBÉ”€tÌ^P—Þ """ b""" \n ƒK¨n÷B–ŒcCòÂ>65 """ b""" \n Œl–‰L\x13“Ar§†²Ù¹ """ b""" \n ™Y¤†[£Pá×\vP‰ù§( """ b""" \n ÓõÃD\t\x12<ê½´\0aáØ """ b""" \n ÙQn“&\r{D«é\x11›nò¦ """ b""" \n Ü—&\eXɽ\x01‰èúþßî """ b""" \n åîebÜIsŠŽ\x18d\x10ýê¼ """ b""" \n õ\x1CU³½@”²Ï\x10“Ä‘W¥ """ b"\v\x04À¾\x0EXMH€Û=\ð\x02ü¯" b"\v\x17õ\x08\x06±Oø“ÆÏ1\x1C!Ãc" b"\v\x19Œ”\x13P7•y=°“È4W÷" b"\v\x1C%!˜ØOªõ\x10eåÿº&" b"\v\x1EüÆä–MD«¿â\vÒ,>%" b"\v)⢠Aä»\e,.p-ÿ\x1F" b"\v0íÆn\fKº›\x14¨‚0mm2" b"\v7}Bè’M=™Œ!«—ºkà" b"\v?ȘŸ‘BÒ…\x11é<ààZ²" b"\v@`´\x17WM(Šÿé\fh\x14Žì" b"\vh"Ò™ø•„@‘Ùõö¾~" b"\v‹ˆ¿ñáCŸ¾\x11ÙrÌ:ëà" b"\vC\x7F\x03…Bå”eGí—D\x05\x16" b"\v´\x1Fž2öDê\x1A\x06É\x1F\x01Ç" b"\vÀ\x1C\rbSL.¹ÊsDÃò+Ó" b"\vÇdÖ4\x1F£\x1D\r:îrœþµx" b"\vÌš\e\x14A'Áí\x13ž†›ƒm" b"\vÏÚÛ¢âÍÄ‚àÁ0ê?ûÔ" b"\vÙZÙç\x1ALÓ¿‘!à\x1Dípw" b"\váM—Ò.O<…\x11„}\eç\r÷" b"\vñ,—À\x05˜\x13$U Zï¿2é" b"\f\x02u\x17ˆõK𒤧ü\x06ý4Š" b"\f\x13XV¡£Oœ¹1Œ`“ê]\x7F" b""" \f/ìCt\x10Iå¨ï\n k/ÂÖÿ """ b"\f9\e\x01ü*J\x03¨º\x13§¥•Ø·" b"\f_ç½b\x02¬¬Ü˜.\x04†\x16\x1Eè" b"\fb6Æ #CÖ¾ú袃W[»" b"\fkܲgÐbž\x07xÈWíºìÖ" b"\fž\x04\x02\x04ËLO’X#‘»Ð¯&" b"\f®{¦ÜÕFQŽækª\x05§}ß" b"\f¹0\x1C‹BÜõâxj%ß¼.Ã" b"\fÁ¿Ê\x105l&Œ,\x06©K×õ\x19" b"\få‘q˜ÌA.‹‚wðƪ…\x12" b"\fæäüó;Mè»›²¨UÐa—" b""" \r-%W™çC]‹z\n ]K”ݹ """ b"\r2àÔžÅM»…²ï\x00â\x10d¥" b"\rNå\x1A\vZK=¿OøëÆ«;ú" b"\rZîÿ\x10 l\vjbO\fÔíR" b"\r`•—×òH“œžg¡<Ðð¯" b"\r¯Âé÷†CˆœÇXH—O3÷" b"\r±Ø!-@YšzyF:|JÀ" b"\r²QÏâ\x1DB½¦AˆÏwèq…" b"\rÁ]\x04n·Da·ö?ŸD%z=" b"\rɧoˆ«\x15\x0FêO¥ÎPÌBH" b"\rÑsT=Yûéö\x06Åqv\x07/ó" b"\r×êN5ÎL¥“tÂPš\x1C\x1D6" b"\rÚ\x02©<ÿ$$•\rñ{\x1ESÛ" b"\rÝêayV\x132ü\x0F–4Ô•¼" b"\x0E\x01ªMbÅDý–9Àõ}\x17^\x0E" b"\x0E\x07\e˜l!Ij©LêÈ\x12â¹" b"\x0E\x0E„½‹\x19Jh¡Æ‘k÷±Xd" b"\x0E\x0Fþ–i2Ié®úo2\x02:\rR" b"\x0E\x18±ù‰[M÷ˆüÈ\x1EŽ˜²Ä" b"\x0E\x18¸5Š4BBŽ\ªt#é<¬" b"\x0E6®q±¶K\x0F—[¸ò\x15 ˆ" b"\x0E>˜€ŽâÖÔŒ‘Î\x00çØv*" b"\x0EL~v\x18Mo\x15-<t¤Á\v»Ó" b""" \x0ENCf°U\x08ºÑ¡\x11á\n #Ó """ b"\x0Ef\td?õÞ¹E qô\x08ÿêƒ" b"\x0Eg—]³ÖD;»Øé\x18ñÇzŒ" b""" \x0EkM¹\x1E\n M/A\fí°\x06A@ """ b"\x0Ew»ßŸŸI\x07¿˜þaSD+Ò" b"\x0E~\x0E;©ß¸\x04z\x03F}¹ÈŸA" b"\x0E€¤fÌ,C’¢LQ\x13²ºŸ—" b"\x0EŽº}NôLœ£@:ôÛØp%" b""" \x0E´kõÂà~xrI\n øÃœó """ b"\x0EßÄ%Øí‘Þ£‡pÏ®\x069Œ" b"\x0F\x02Ç—1¡Ac‘Ö–EOöèö" b"\x0F\x08\x08„S=B…¼—©W‘\x19ð¿" b"\x0F\eFe$\x1EI\x1CŽÊÕãežù." b"\x0F6yïpý:g\x06\x18v¬U\r0Î" b"\x0F8\x11AùM\f…Çc\t‹t\x17ˆ" b"\x0F8aåxɶU\x00Æ‚\x04OÉ\x1E" b"\x0FA¿@aù\rp£¾3„óWä’" b"\x0FSëJŸ+X*3eG¨gÿcE" b"\x0F\"`£ðOs¤Öl‚í!\x17œ" b"\x0FeuêD\rEo¶t*eè\rdñ" b"\x0F‘²D)ÜH7Ž,\x18\e\x04«Â" b"\x0F¸S\x06éÄM\x12nKѺm’ß" b""" \x0FÖÑÒ+l›ª\fg¬\x07x\n ê2 """ b"\x0FØS8A/Jë¬nD¢.JŠ»" b"\x0FÙˆ>©þGö«º´_´9ã¡" b"\x0FïÎ~\x0FvG…EèÆÁ/\x1Eå" b"\x0F÷Q7îþMP¯Jýç_Ž‰K" b""" \x10\x18Ï$@øM\x0Fù\n 9¿—ºæ """ b"\x10$¶‹òß³¿#å«\rh¥à" b"\x101‡¹š„I8©Ž\x1D$¥SÂF" b"\x10_óEORJü¸‰B+ÙóÕ\x13" b"\x10{Õðy/Cd…4J\x10Ù\x02f¡" b"\x10}…•Ê4x‚"û‚\x162ÑÍ\x03" b"\x10µ|uƒC~âôÍJz;Á" b"\x10²ü¦¼©_èJip©Ù\x15Wu" b"\x10¸\x1F@:_Mï»\x15#ݱã" b"\x10¾{\x11íE[‰iî\x06\x11\fz‰" b"\x10Ö+\eb‚Ï\’¹FÊ@Ë" b"\x10ØV•6sJb–V†\x1Aظú¶" b"\x10ØÃò)\eBµ¥)|Wj©Ý\x15" b"\x10Ý*À‘ñ§šQ[ì!/_ªò" b"\x10à}5&\x048Ó§\x08DãG\x06äí" b"\x11\x00\x05\x07!ÍNÿ³™;ªÊ\x05Pš" b"\x11\x04£\x1AšüET=ï4v\x19¶ë" b"\x11\x06XóåIpþ\t¨6óñ|‚" b"\x11\tô‹\fzD\x1F–ã¨\x17.›8l" b"\x11\x14œâ\x15¢Mr•ã³@\x1A_ï¹" b"\x11\x1A;»+sÂ\x1FÖYàVaósé" b"\x11y¢UuõO¹ÿªY\x19™\x07" b"\x11–¯OÐ\x1D©×TmÛšnŒ8ß" b"\x11žŽŽ;JÔ›OsW\x06·SB“" b"\x11«?Çm·Hï¸%4¨\»&³" b"\x11ÂãÃ\x0FäßÖ)ê2ñöŒ\x08U" b"\x11ú›ÄÕ¦O3±‚ƒ»íx)" b"\x12&À\x03èÏ”\x00¡ \x01[W‡\x1F”" b"\x12'àïNÏN#²)Ð\x1EIš¦Ã" b"\x12(ÓÈ1\x10D‰·Q}®\v3M" b"\x12*ï7\ráM!ƒ³0¨aSL" b"\x12D½iˆ¥=Ùí˜k\x1FÂØƯ" b"\x12O\x10Üp+\x00\x7FØç&üSÃ$A" b"\x12÷ý\x12XB\x05¶C5ZÚ" b"\x12‡Ó\t\x14\rÌÌ¡n"L¦¼YÔ" b"\x12Ž\x0F¸Q¡G_ˆ\x0E9\t(~Å" b"\x12 ¨Ú\fÏAÄ«\x16®Ý/èËX" b"\x12¢™Å—Ü\x1E*j\x12\x00ûù‚´‚" b"\x12Ü@•"p\x071D›\x08ðneÉ" b"\x13\x18\x01ÓUOH‰³¯áïÂŽ®{" b"\x13%ï\x1Ft†,\x18\x13_¡bÛ°ú\x16" b"\x13&N:\x1CÑg]E®®=*ƒÓ¿" b"\x13R!äìtLg…†¦ÙÚ"ÖL" b"\x13’¤¯·¼B”äÕ’¦#Py" b"\x13ww²;o.9çÒ;ÀÙÕû" b"\x13´½žV¥K½Žt1iÊ!ëÎ" b"\x13¼0\x00\x00\x1EOZ¨RÂÙoÛ–¢" b"\x13¿1¯„\x0E\r—!d\x08sͶf" b"\x13æ‚“"êèz‰¸ñ\x1E»ÂÈ" b"\x14\x03\x19ÅNÍ@|©Gx`\x18ñx{" b"\x14\x07ÊW´ƒN\x08ˆ²\x1D³¼qyÍ" b"\x14\x10ÜÏ0jE'šXN7!L»b" b"\x14\x12#\x1E®\x12EhškQèÜ€A\x1E" b"\x14\ef}VNЕ—\x15\x14$îEò" b"\x14!fx÷\x00FHªˆ÷·"&\x02i" b"\x14'\x06€7äDõš·×=uçŽÑ" b"\x14'Ћ$QDŽ®RŽ†±3o¦" b"\x14gŽ\x00Êxا(§Î©\x19…\x13B" b"\x14k\x01KD-@L\OÍøý:\x1A" b"\x14˜Œ\x18oÑG7¥\x07ÅŽÑ#ú"" b"\x14¥¯'œO;5¢º{?bUç" b"\x14¦TÊ\tÃ÷§D¯ç½Wm±A" b"\x14³Z©\x154D¿‰5V\x03fg—Œ" b"\x14µ¼D\x07Y¢Ôš\x00Šáâl_ç" b"\x14¶àWƒ@ã’”Ìs§\x1A/{" b"\x14¾å™\x08ÒqUYˆˆ“Äà´r" b"\x14ÔôUŒLFæ±tÂ]0{«³" b"\x14ú\x00HÛ!N\x15º2hz1\x04<u" b"\x15\x0F\x07Œ;¿CÔ¡¼Ù6ñ\x1CÀX" b"\x15\x13Á{ÞsW@\x1E\x04þv¹¨3Ø" b"\x15\x13âe\x10+N„¶\x1EÜœø3\x08™" b"\x15\x16S/±¨M‰Ÿ´yµLxß¼" b"\x15\x18r“ÏÿC½«‹\x13ˆ¯\x17>Ý" b"\x15$󰈨uD\x00†…¿\x04ªµ" b"\x15P™Ž\x14gF\x03o÷Æ××Ìd\x16" b"\x15Q'‰†ŽGô‡*ûÖ€}iÅ" b"\x15`Å‘ý2BâŒ\fÜë\x0F€'è" b"\x15…\x18\x18\x13&Ь”\x04^zEÝï<" b"\x15Š\£0lD\x17ƒ\x05Lhdî\x0FÉ" b"\x15–¯ë‡\x15B\x00žÉÏŽˆ\x1F/†" b"\x15¦ÝÒ`/H\x15†K£ªÜùŽ" b"\x15©;e\x0EÆJóœ„2ËÙ\r…Ò" b"\x15´¸òŽ½E‘—%\x13»D É\x02" b"\x15¶d1äTŒqNß‘+wËQØ" b"\x15¹¡‰ åG>¤ªšÓ±Kí" b"\x15Ë\x0FP¹äÍ”×Iæ‚¿›öš" b"\x15Øh\x12\x10\x18@\e¤³ÜH"å¨Ù" b"\x15ë‡ÛñG;¸È¡¢{€³\x19" b"\x15ò¹\x03EL†Œou¾ûƹÉ" b"\x16\r¬f1¿C\x19ºáÄ\x183—Hp" b"\x16\x13ó§ÃAk±Z’§ŽDœ" b"\x16\x1Dñªw„CS®“èÀÇ\eD" b"\x16@%OàÍDå¿iÇNÁU\x1A\x04" b"\x16CW\x16½NªŸ\x19ê¤C¡êH^" b"\x16l+(ÜšºÎÄÃu~•\x1AK)" b"\x16q™<‹u~ðùã¬Kí1ø" b"\x16rÅ"\x17ÇG~€\x15\–s„¤" b"\x16xàGCù6¡Lš\x04åñ‚Žô" b"\x16|9Í\x11S\x04\x1Fm“ñ\x13£]®H" b"\x16˜Rg\råC~¾\x1EX\x17 h–1" b"\x16¨™¼U\x01@H mè*=Ú0@" b"\x16®‡\x19\x02æ@p“Lð¦?b˜Æ" b"\x16º’¾dAD\x03½Tg\x06Ë\x1E\x04\x7F" b"\x16ÇGªz6Á‚²xêÑ\x18ã6r" b"\x16Ì›4Â1À\x00éb{ŸPJ'õ" b"\x16цˆ‰ÅBA¹‘$o=¦óû" b"\x16ß |\x1F¢F‰¦û‹8\x18¥lÎ" b"\x16ëï\x0F\x7F4¿ÇØjÜÐÔ#&" b"\x17\x11Ü\x16øÚLv®Â\x18pJ¿Mþ" b"\x17$ÈøʺEuŽÌ?P¿œ’(" b"\x170»>úÚwJ|×»TÀßrR" b"\x17RŸòëK0‚"ËÒÐ \x08\x10" b"\x17bß?Ž}á:\x08_\&\x1Cc\x17ˆ" b"\x17e\x18â\x02ƒLå\x01J˸¼|Ø" b"\x17lGòŸ^ ¶¬\x08…É-]×Þ" b"\x17sT\e´\x16E‰˜Í[©?[äÚ" b"\x17”¡²ÅŽH!²>‰~—ä\x1F" b"\x17ž\x04›½¤E"ŽØÅ\x1Ac\x05oó" b"\x17¹}ïGŒGžþE9Z\ÍN" b"\x17Ƽv…ôò \x19¯ðP\x0EŸŒ'" b"\x17æÜc&\x17A³™2‚"„ÐP›" b"\x17çÙÙ¨üGÉ›Égå¨5ˆŸ" b"\x17ïƒer\x08¶‰¤Bq¦Ç˜Ï‹" b"\x17õ\x05´38ÓŸwì\x01ãš‹\x06ƒ" b""" \x17ü|ä5”J(¡\x04\n &À#Ï? """ b"\x18\x11Ó\x16\x17øNŸ¢Ö%AÀà]…" b"\x18&Ù÷\x12¥H<§\r\x7F¹Ùx1|" b"\x182¦YP¦C*\e\x03b‡_&" b"\x185.ËkI@ú„‡ÕÊW1øª" b"\x18Fu\x01Î:K´šíÛ¶·*\x03³" b"\x18^Ž|•ñJŠ«%µ³Tœ8È" b"\x18dÕü°ÁJ¯ŠI1µzú]S" b"\x18q\r°\t\x14AÖ‹dŠ9€åw" b"\x18}xfíõNŽ¿ôÁú ë\e‡" b"\x18~¦ ÀÀ sÖÁ\x06˜\x1Fõs" b"\x18Š%úæ\x06Eì¥â·xQƒ_=" b"\x18”\x00ÅT£E&›§Q1HS+\x16" b"\x18]5)ŽMš–Ó‹\x10¯”€\x13" b"\x18¬‡²I<"SèÏlBwèZÍ" b"\x18ÐU\x12ÚÐJ¨¸Äýۯ߬’" b"\x18ÑŽŒ\x12r–v4#\x19¸ÆªÜ†" b"\x18Û\x1FAÍËA†‡™½\x00P½ÊÏ" b"\x18è4÷ÙRŠ\x0F´Q—ƒ\vw\x14a" b"\x19\x02qj\x17\x06JQ¡2bÉ\x1A$m!" b"\x19\x02Ëœ\x1F\x1CM\x19ŽU:\x039èC" b"\x19:¿è¢ë@«°w7ßЋ{<" b"\x19PûaM¨¾æô³º/$\x12" b"\x19{#\füLI\x16¯^¿ùP\x7F\x05b" b"\x19u«¦¡26I<\x16ŒÑ—Ö}" b"\x19žLÈd\x07I;©\x199Ö¢Ñò½" b"\x19¡º;¤ký\x08&ãðäé’Ñ" b"\x19©äUW\x12\£\x13a’\x15‘\x14+û" b"\x19³×¾Ö)N—\x05'd‹xÓ¹" b"\x19ů„@PMU±h„§$ù}ï" b"\x19ÖïGÆËY”bLF®¤‘ Í" b"\x19ïŠÑK³\J¸\x05Eì=’\x7F*" b"\x1ACY-äEôù5Œ0^@±" b"\x1AZŽ4‡MM\›K\x13Ñ\x18½i§" b"\x1A†iyå`O4¸´ê\x02NÚ™ " b"\x1A¼”Îø›Iw‹ :'dt5" b"\e\x19¯í¶ºŽƒü8î\x16‚Ué" b"\e0×\x08Ý\x14H¨‡U[ƒ±\x13" b"\e1;|Š›F©¤©pæ>â×Y" b"\eDdˆ•ÀC%©¹q®sº\vC" b"\eJ\x13\x1F*\x15K÷¡í\x07²ƒ±‹Û" b"\eUÃ\rÎ/AH¦Eq±F†" b"\ew›µ?CÎ\x12LÅ{U½ö~ã" b"\e€]€L~M`ŽLZôÝÙM´" b"\e‰CŽ\x1CÑLƬšHô‹Ó£®" b"\e§\x0FgÈN"Ž×&Ù訪™" b"\x1C\x01ê\vü\x06¬ôžöEÛþ¿P" b"\x1C3ßîx)A8¬ UASNMd" b"\x1C3ã»”‹¬\x01\x19nÿ\x10#ör>" b"\x1Ct:Ó``CxªC«‚¥?Ç÷" b"\x1C„uÍfí»¤=Ú`\x0Fðë\x03" b"\x1CŽ\x08œPzB\x03\x01Þ½è˜õ\x7FQ" b"\x1C¸R[o0IÒ³\x10˜ò@¢ª¯" b"\x1C¿Öb¡IJ?‰¯â‘˜\x00T" b""" \x1CÏŽ\n ¬ñAzˆú~ôP™öÉ """ b"\x1CÜ(õjUKÄEß\v@ÀÓh" b"\x1CèüÓÄ/%\x15z\x7FN'\x06ì5©" b"\x1CþwXÛ¨H“—Œ)\r\x13“\e" b"\x1D\x15Ÿå\x15V4K…†›˜=ÃIÎ" b"\x1DA@/\x1A½F™¯\r¶\x19a§2ç" b"\x1DIÓâ¯ÄL£¦C‘\x05©ú׋" b"\x1DP*èN ~\x18¥V\x04,㯒" b"\x1DU)+\x19ÄHÙlJ?ç«\x0F\x01" b"\x1DZÀ³–Œt3*|Žòíò\x1C" b"\x1Do/\nïjH\x18‘«\x00§Øw—b" b""" \x1Dp<ZM×O\n ¨¨t€Ö\x16y\x07 """ b"\x1D‡¢l`UK\x11”7ëŒÆ\x1C_ñ" b"\x1D§q<ŒâX³“\x08±¢`Õ\x11\x0F" b"\x1Dª¬Mâ:Mfˆ§\fj¨V\x07¹" b"\x1DÔŽz+4G|‚}°\x0E_ã\x12" b"\x1Dë¾\f»SqêdŸì{$FDä" b"\x1Dö»¥ó(AǾɚ\x1Ep…\x01 " b"\x1E\føu?‹v}ˆ€\v]j È\x15" b"\x1E3Ô¨ªJÿ¸žÎ¤ó‹™q" b"\x1EQD»iIB\x12šñ\x00¹9\x15&" b"\x1EmBœ\x7FžYƒÉ\x1D BN‰ùÔ" b"\x1Eo,ŒCn@ —‘ð\x08Í\x1EÈ„" b"\x1Eq\rA*¡\x17\x03ˆÃÛîí9#b" b"\x1E†Üri½\rÉ\x1ER@ýŽ.\t¹" b"\x1Eˆ8¾f§E>†\x08Cïtß”H" b"\x1EŽ\x06´ö\x05KY†_Ä\x0F|¼\x18Í" b"\x1Eš'\x03\v\x0FM®‘B—Ml\eê" b"\x1E¦F·3\x1F}\x14áfˆŸ\x14\x1A—Ü" b"\x1E©&\x1F¼,IQ“ýϵB…W" b"\x1EÀÀè(º@ú€·|7\x12aT©" b"\x1F\x01–Í]\x0FEµ™\r\x06½¿e¨ß" b"\x1F\x01ºQð,HѲÇ7……ýïw" b"\x1F\x05ß[kb}zèìhkŠVø" b"\x1F\x08ȦǞH7¡c‹õp©\r" b"\x1F\r£\x00»\x0EJ/ÑDü|Q\x7FQ" b"\x1F\x134L̤E–›6¢Ÿ\x1A”ˆ" b"\x1F"J\x1E_Lõ\x1F†A1å\e³\tâ" b"\x1F"Ü\x05»½F~²ÑªW••lŸ" b"\x1F1Ú1ðÿ\x01C\x11\x18ÙèPc"" b"\x1F4ßÈ{\x19H0‰ ËD¦uøA" b"\x1Fj45ÿˆD…Ž2"\x1C÷'Þ" b"\x1F‚kxâ6GÛ¹\x06Àd¼Ð¹\x7F" b"\x1F™ÁÌݾ\x0F^%ŸÒC¹$ž" b"\x1F£xv\x7FH˾\x10Y\x10\x02«WÞ" b"\x1F§(\f1†JŸ¿CV0\x0Fà®s" b"\x1F©ÞšžéOFài\x16S-mx" b"\x1F¯\x133_hÚr\fÞ´S¦£þë" b""" \n ²\x15ŽP²©Ù\v¶ÕÔÐ|\x7F """ b" \x14"Ë\x19‹Gš¤!Úe\Zt" b" \x1Ax\x0FFVBä¥\x15S{z¦X¿" b" #\x11Ò\e\eBï‡Û$è²@š" b" (ùÛþ]Dp±Ú;`ibÉY" b" 9§ "\x1CŽ‘sK^\x0EíU`û" b" J\x1F<ö`Ck¿\x052®'‰Yi" b" T%\x1F\x01íGè«×ÇÄO9WÅ" b" {0…>ª|Ú\x00ÛBù‚%" b" ~ä:\x04$@)·=«óõr]ï" b" Û©òhDÐqf~Y\x0E¸˜„Y" b" åäc;g@$§\x13uÀY˜é\x1E" b" î5¯Õ$C˜²üœ}~ÖÉ" b" þb|¼®IhŒðh&Ò0|¼" b"!\x07aÿ\r_*‚ŸYÈ>©Qâù" b"!\f¬pslLH‰RN¬Èj’í" b"!\x123,Ò(BÁ0x˜üƒF2" b"!F3:_\x16\x13ÊÜId\rÕŽ3<" b"!]À\x07ý1\x0E‚ª\x07m\x18i×" b"!nÒLÒ\x01¾¤Q\x1ARßœ\x13\x05y" b"!\x0E©†nLæŒ\fNy÷\x10€Ë" b"!•¤uàÈz|¬¹\vÅù,"" b"!•¹;\x08E׳ݻ\x11X išÊ" b"!£è\x17qv\x1C¬ž\x0F\x0F•Zl\x06!" b"!¿¨\x01\x06M0“b(}–ü'ù" b"!Ë&|3ÄY\x12,¦\x1EÉø‹XS" b"!Ô®Hã*J&¯5nÛ\x0Fˆ \x12" b"!ׂĬ\x10HQ’4q×Tf„Ü" b"!è•P¾‹Fó®‹`úݲ›" b"!ë~\vçG5¼Á\x7F3¥wGü" b"!øY·\x17\x16Ið´9iÈZ’\’" b""\x03|·£\x03N\t±\x00³,ÔŽŠ" b""\raH\x0FÿLé\\x11\x7Fƒ“¾" b"")v\x19ójG\¯oqC\tÙš²" b""1—æ4\x16²Ã}ÌÄ`\x06uj»" b""<«¤ÛGMᘆ…¨î.°\x1A" b""=d<÷\vEf›‘Êbl{È)" b""" "g÷YVÉLl‹\n ´7\x07ºä] """ b""†)\x1E]@C¨®nÖ§N,º\t" b""* ÚùN¢ƒÝ« 2¿õ" b""¡í$S3H)¾\x14\x02!Œyá\v" b""§5£þ\x05OǶîÿbÊäZ" b""«âü½ªH‹’z!(’Îç0" b""ÙÔñ°TM¹¦\x02:Ëlí6'" b""ÛÝç~~D»ˆ\x19øT¬\t^g" b""Þñ.£N¥¡ÇxL\x04¦"ª" b""" "ô8\n ¿vFFÞtú%–ù¥ """ b"#\x0F 9\x16ûK°¬Ê\x05œy\r¥" b"#9C/øéE¹¦ÂPŸIï»n" b"#@\x0ECd\x05TƒHnª\x17\r\x17…e" b"#T?á&|0ZkD“%SGL" b"#q<oîÆNîê¶0$ÝΔ9" b"#¯È–ÔäDN³D:¯2åm." b"#³Rk¼þHy¼9ÚŽgÞ=\x06" b"#ÉZøx@F†Ïõ\x08\x009¡ƒ" b"#ÐŽv†{A·€U‰Uþ\x15‡«" b"#åÒÆò²DmŽ~õ10[¯Ú" b"#í.X»ÄLm\x1Csh€1õc" b"$\x03†'Œö_ÑOxYˆ(ZbŒ" b"$/™NÐ\x19ûç\x00r7þ¥À¨" b""" $6\x01‚â›Nñ”\n UÐc|vN """ b"$BÂÇÕõ\x0F\x15\x0F \x1Cœ’qBe" b"$XHœ›TI°\x14ÖØpn×," b"$fªûç[H„–§\x02Ð-'âf" b"$mgƒÕ—Nþ¹X(‡PÉá\x11" b"$|‡>×`A´ˆõ¸”+#ì‹" b"$Žà|„ÒMIˆó› \t¾\x02å" b"$—ÕMÑOK€—2Ó\x0Eô\x16R\f" b"$œÄ7_ÌKå‰\x1FöEÞèOf" b"$ºÎäŠèAœšBì\x04\x19%\x1E" b"$Þ¡Ý›qH¬¤K†â¤\x0Eù…" b"$ß“üÈÆB\x07¤£\f?S\x14çw" b"$åQl >¦Œ‡ïÃZ`\tu" b"$õ>\t¨\tJb•~¼ÒÄ”ÁC" b"%\x03Ng\x7F„Eb‰Çpî³#~U" b"%\x05Žá\x03µLWª\eêªÂz’Ö" b"%AQ\x11ºÛNLµ‰×Ÿ\x17„”F" b"%MzXPbB\x08䎙òÏ—-" b"%g\fýGGÞHp…€\x0FH¿ ï" b"%“bGþxEsŽüõ\x16¶x\\v" b"%ʦ°ÇæI_¾¿ñŽ»}ó–" b"%âNèŸ2LÆòÓÏ:™Þ¶" b"&\x01Ÿ“ÈÞ%I¬`¾ãŒàn®" b"&\x12\eU\x03CJr¯#Šh “"Y" b"&\x18\x12_ Ž\x12¤Ðdv.ßÖt»" b"&\x1C%›¿MÊj\x16\x02ÚM…•Jù" b"& ùÅÓÌA°¾{bÌ„H÷#" b"&OÎw]vGXªË> Þ„è*" b"&Sý€è\fŠ[¦\x1C€ÖÀIÀv" b"&xÄv §ºcýUõÂú\x16³Ô" b"&\x7Fw¢Y…Jc—q\x07%\eþ§ó" b"&•\x1Dâžè‘|+kxð¦ì¿„" b"&™]îæPKF\x18\x1C8Hp\x18x)" b"&›?\fµÉ\x1CØÉ-æUvÒ±\x06" b"&±\x00´\x19ÕH,Ž9ûwŽ"àæ" b"&ºãÿ¤ZY¯6®+°j\x0F|©" b"&Ñ]0ù0I#¨\x02¹ŒŒFã×" b"&ØÖ,\x02ŒE»:i|ÉRMÍ" b"&ó·=k•¬\x00~ã»\n iÓ„" b"'\x01öÉ4ÑM†š=\vÈau$" b"'\x0F|§…øF@†½?Êï¶Z×" b"'$\x18‡£½Å€\x16\x1F‘_\vO¹“" b"'-—Œ¨çEÇ‹RŠÏÚ|fv" b"':GQ2\x11Dž³Ñpq•U=" b"'=¨ÃF'Eꑼª¦\x13ÇÎà" b"'GMl\x15¡K«©\v2ýõxÆÀ" b"'hîï”\fAÝ›,[¾9üš-" b"'r\x18|ù—N9š„OŸ\x1ETî§" b"'v>\x03q®Jj¸ÿ””j-´" b"'z\x1C\x08AA@Á‰|íÜ\x18–\x14X" b"'~\x14àÄLEp›-\r\x04\x7Fùq—" b"'°7ƒØý'Ð\x11ŽFžéu¨\x03" b"'¶7§\x14—êL\x0Eߣ\r\e:\x01\x13" b"'»Œ!t§Êdi\x02¾¤f\x17W¾" b"'ÄëŸ.L\x1A«ìvL¨ƒë" b"'ÙÆþ²gIs€(£éÓŽÿS" b"'ëä–°\x10Bu”c‹Ä(š_{" b"((K.Lj\x13?‚Oó!SàBÉ" b"(*@Ò&>Cr¬òÞZ5[À=" b"(1t¸vaIÝ¢pʺ•Rõ" b"(9o§Ô˜\x0Fl7 ¥±Ö}¨²" b"(Cíø†ãGü¯½\x13[\x15)¢ô" b"(M‰Ë\¯Cd©ÅIjq_N$" b"(V\x13\x04ŠðD¡¹º¤*\x02“\x05Ä" b""" (…\n Ÿ†@M„\ý2œÂý\ """ b"(˜¸e-\x00@\x1F”Øqßt׬]" b"(²1ôåÍF\t·H\x17DyßÉO" b"(̘©Ü°HYO\x0F\x0E,œ¤\x01" b"(ÜîM.…I¢",;ª_\x04'" b"(ÿÐ\x17*‘L\x0F²f\x1DÙ¤ãªÂ" b")7\x1C\x1A,rNB¿6£Ù/–\vH" b")U<ù\x03|N“«EW™O_:" b")eBN¼µAi¿õÕw\x0E…¦ª" b")iu\x04P‹\x08Ͼ‚Hø…êƒ" b")›Ã\x12jNA¹™\x04ó)Ay¢k" b")µê\x1C˜ŒIVŽÿý(]ûv\x10" b")¶\x13áêMV€ºs˜<Æ\x12" b")¾Jf¿\x10J\x00ˆù\x06q;\x03cJ" b")À9™9æC\x04¤-ouµÈƒh" b")ÀÒNØD–·J—::†/ÿ" b")ÎZøJWDCŽÊ&í±ƒGÏ" b"*\x0F½jÄGJ\vÑy‡€4Tø" b"*\x12þ£EÈAA°Ú‡Èð\x19c" b"*G¿è\x079G˜cò9\vµJ(" b"*L‚\x1C\x03-@–ŽXË\eG\x1E\x7F\x11" b"*Y\x1E©»¬OéIç\x15» " b"*d”ý\x1CáBL·³-yf\x02í†" b"*m\x05Y–õxzxC"WÒa“" b"*p/ù˜zI#Ž\x08±-\x02\x0Eƒv" b"*…\x19ÀÓN6ž Ü…¯\x1D<ú" b"*ÌWcþ A?—먲 \x18…É" b"*ãöm\x00ƒÌ.¾}+Äi±\x10" b"*è\tb<«…L¥\x06‹¦pJ:j" b"+\x07mÒ¹kL\x14Õ¨z\x05(N#" b"+"úD€ÐAï›fw¨’¤TZ" b"+'Ýd’<Jæ‘ßMsRK\x08" b"+aÅ·ÛíL\r’ÆÛÜl ñ" b"+e¿×T$@Ù®ï\x08ó¨[]+" b"+h\x18jEjOª«8¤:LË_" b"+}y6/B™»Û5:ó€¹#‹" b"+\e´Ùåõ\x7FžÝâä\x16ÌH\x10" b"+˜šû=ˆLðšÂ\x0EÒ\e\vÂ" b"+Äîßû8Jl†Ê\v ]WhÕ" b"+Ì~\x7FæþAάFïm\x17Z" b"+ÏPÜè®N\x11§%é\x12ª yV" b"+Þ¹\x11ê¶O:”}~‡\vk/\r" b"+þŽ…î_N¨å=ü1¾\x7F\" b",\x12)öREd¶iY“‚kN0Á" b",\x1CrîåÝ0\x06‘§ÈÂcØ\t—" b",i85A\x1C‹ùÆ•¨DØ7" b",}|.f1N5¡²©zÛ¯\x14" b",~\x18/T\x1EG\x13—£TŸÿ÷pÚ" b",˜ôÊ\x04)\x07ý¬ÖÇ\B\x13Jñ" b",è¬\t§•@ ©\x00XÈTWÕÛ" b",ü\x05t\v²Bù©ÿT©©U\x07”" b",ýK-ç2O\x1A³”)\x1El\x10üƒ" b"-\x07â¦öUN”¹„>pävt\x07" b"-\x17LlÒ\x1A@Óæ qZÏœÞ" b"-\e¬èJÚIZ‘/}•Õï¶<" b"-0G1£@CÞ¯ÿ•$\x13¡Ä@" b"-3 øü©I™§œ\x18û“\x7FÛ±" b"-9\x04;g\x02Kų¢ƒ™\x11ÛÏ‚" b"-<\x16*HþO$…Ίƒ\x03\r\eÒ" b"-H¯q©‘D̺\e}P¢OøF" b"-S\f˜s¾FN‰^\x16EIòº" b"-y2\Y)D¦¤æ»5üA\x12)" b"-ˆæ`ÐìKØ–(èÛ€\x02á\x01" b"-•(\\x1AõHø¥4‚ÝŽš\x07¯" b"-˜|\¦|þtì!¥=" b"-ÃéöÎvõPÀÈûÄb\x00:X" b"-ÕVi”\x08¢‚J¦V”ïQ“" b"-ê®"ÖÀM\x0F‰\õ\x05¶V¾" b"-òS\x01øaC@¦\x04+-Z½x\x7F" b".n‡÷sBôG`+\x1EF‘6Ð~" b".oŽ\x07ŵ@Lº>´P’áƒÌ" b""" .på–\x1F\t$ù&g†ý\n \x07Å+ """ b".©e\x10eùH¦»\x01¨Á\x19©Ÿ\x13" b".¸Âmù‘{3ì½x‹•Í7\r" b".¹ñ¯"ðG?¯ÖÞÞžÜûŽ" b".É-³\x17äK¢†;„-\x12¹n¬" b"/\x07="^bG@—±€Û"%Ž–" b""" /\t\x10\x1C…áL\e•\x0EôA\x19\x0E\n ™ """ b"/\t±1O0M¡œÁ¶Í\x16P`Ž" b"/\f·¸\x109Ý–k\x10\x19Ÿ°u#E" b"/8]\x16~»I-±AÕ}iV˜ø" b"/F+]\x1F\t ó\x17ИÉåËÂx" b"/Jô G\x00N!°D•èOLI*" b"/†ÂÄWßD+¨#;hSr†W" b"/™q²m\x17FŽ¦1à1£Žë" b"/¹}™\txL·²‡\x14>Ù\rè»" b"/Ç}ë\x0ECL\v¬BŒÊþ¿-T" b"/Õ4’}Ƀ§\x12)êûˆá8³" b"0\x16æã妬±ÝqÓ*–P«\v" b"0\e\f q@Dj•Åb\x1Dg¬N\x07" b"0O]\x07îÁEö¨&iÒ¤D6<" b"0P9>’D¹Ð–}\eK¾)á™" b"0o]ÕL'ÚÍ=¡´l\v·Ó€" b"0ƒÉu^îO‘”øZô¤Š?Ý" b"0ŽS*\x16\x1EDs“ãšl¨P\v\x01" b"0©?\x19ždLÆ·½›¨Z_Œ_" b"0¹UJý(JE¨¹|üK\x04\rÅ" b"0ì\x1EKPND´™ß‡ör {m" b"1&ž¨·]Lv˜ï5˼êú€" b"1j\x17;ýƒ\x1DõÛ\x16°bŲ‡á" b"1Š\x02Dù\x02EŒ¦È:IŸÁnF" b"1—o\t¼ßKaä\x01\x11[ž¯" b"1š?Ë_ËE¹ G®b>g\x17§" b"1¥\x13ø$\x04\x1Aµ\x05Cÿ\f÷\x1F8" b"1¥«”‘3B2Œ,”- €£N" b"1©–(+•K˽.\x00\x1Cæ\x16\x05O" b"1¯z3Íؼ\x11÷"k-ô‚g†" b"1³Ú¸ß‚Jªœi™¦.Fb\x18" b"1Ħ!<ªB¸ºÙ÷À!µºD" b"2\x066cû•Nxˆ¸ pŽÒº—" b"27¢\x7FY‚NÛ™\x1D˜¦×ãG-" b"2C„/maÄò¨\x11Ö£\x04Ì“å" b"2X\x06ò‹S[¥©¹áAYK_Ë" b"2bŽ«e,C˜¿-««Ñ\x1C]" b"2i\x1D_\ePLJ’,¡[§¢ðû" b"2t\x05sHZO¢Ÿ“nQVpß‚" b"2…ªëº\x01AÌšŽˆ—\x06í!d" b"2¶.ÏA’‰«a›\x18N+œ›Œ" b"2ï\x17×I‡BPŠ‡Ûg@ï|Æ" b"2ø\x18¶*pLï•3Tƒ#anÆ" b"2û)ß ï…W=~!\x14 W·ñ" b"3\x16\x17¤+_b³Y\x15{¦\x11ï ç" b"3,xôáŸLNƒ\x0E‘\x15ìCVã" b"3=³,&<J¶–L\x06àt»“\x13" b"3sâo!¬5ÁÈuâñ\x10òúº" b"3•Ô [/F⸖Ê%²îZb" b"3¥LÀå2Hç¨îþJQ¹;t" b"3Åb•bäE;¾#oâúm¹9" b"3Éï®l¡B†±Ee™\v\x11»»" b"3ÓÜ(-ð@8¢ùoŽ_‘³7" b"4\x1A¹-õ½Cü¤<ŸKBý˜â" b"4&IÁoÀB)¯\x1E¦%\x0E\v0" b"4mà\x07hÆI‘€8›½¤ÑfB" b"4«7Ù"Ò¥/516xM\x0ED±" b"4' á\fBö1[å\x07Ú—+{" b"4Ì|ó8\rI»‡E¸éÕ˜\x049" b"5\x1FJ§Ï§C´4\x16IZ)s”" b"5>àmÑÝDð²gQo¥™;¢" b"5[ìÇÃ=A'¹AërK“ê\x19" b"5…¸èÄy\x020/¥‰î=Ã7W" b"5Ž|æ`\x04Gæ”g´0\x1E®DŽ" b"5C]ZdN-ªNzm\x17C»H" b"5›\x1AÙ\x07Ó\x16l‚NjR(F\x1Dî" b"5ß{Qk\x18M4¿€YŽƒÆ"i" b"5ë#&¨SLç±÷\vé\x1E\r¨Í" b"5ìdZLþGë½! \x17=¬Fb" b"5þíH\x0F\x18H\x11¾Fµâ6\v²l" b"6Má.m°Žš\tƒa\x19WÒG" b"6R\x12\x10°uM2–a^‡\x05P¹’" b"6SOot¢OÁ®ú\x13k,”#Â" b"6W\rž§v6/rÇIù†Á$d" b"6XLçuw°úX†óíÁÍ»-" b"6fá3l7I\x16¾6~³TÆ/€" b"6…·qøÁIÉšd*Õ8”j¸" b"6ŠIdÇzFû–Xݾ¤·U" b"6šU¡ÂÇM;\x1Fî«o:Ñv" b"6žchôèD\x18Ž\x02É\x17·\x03\x01" b"6®½W\x7FI7‡`¥§ùœ¹=" b"6´j¸\x13yB‘„ÂÛ*PQÌI" b"6奺}Ñeñ\en=ïP\x06‡Ù" b"7\x02`ÝUF;—‚fΓ\x0EÓ=Ö" b"7\e€u|¥NöZâ\x02L‹83" b"7)çQ×\x1AiTt ÂcŽÊ;\x1D" b"79Jšš\x04K„ª,߬í0‹8" b"7=D\x08d\rE^•£šá\x11M¶Ý" b"7>«5ŽÌÄ‘\x040¼¼Ù1n\x11" b"7A¬j_?B>˜<2\x12ëc\x13ø" b"7u_¦w_BtŸäæÀ¶.Yo" b"7„?ut©A¢§\x10\x18*ZÉÅ;" b"7—J'û\x18CêˆZokç‚uÄ" b"7¦^\ec~LUªø5€/\x11þÓ" b"7«\x1Cÿ5\x04e.k ,OEøË" b"7ÃUšk2»¶y@Ãö\x13lÑ'" b"7Ìw"ÈÑoN~h¦¾\x1FüP·" b"7Ï&0#˜I£¢Ö¶Þ\x11~\x00." b"7Ò„\x12\v\vM\x17šbÅbw,‚ð" b""" 7ãþ\x01\eÎ\n \x07S½½3™ÚÍ© """ b"7çtÄDD›¤«¦Fq¼9X" b"8\r¹Ã~\x1FOÙ‚e\x04®ª\x13ñk" b"8U1>„\x06Ië¯ë\v\x10\x10@ø," b"8XAš¾R5š {H‰O·ìï" b"8\\r|ë\x13Oj¯q'ÏOcx" b"8kÏmµÚL>¯1¯ö8Øe›" b"8‰!\x11Õ×Aý¤\x00B¦\x03ô+—" b"8Žÿ?8cB)—ÓéRæ€w¨" b"8±\eC9‘B®”auHÃäËß" b"8±#ì'\x12Fe¬¿\x02HŒ\x02Zý" b"8ÌÊìi’Dܸ¾Á\x14GV¾" b"8Ùü¤ KÕ‹»È\x12¹\fÃÓ" b"8ßðô¼oF¢¦© ´îIb«" b"8戗\x1A\fM\x1F¾a~\x06r›Æ" b"9\x05“'g*UÍ\x11vÒ\x07\x1FÙ\x03¢" b"9&·S\x12\x02M©¹“‚ù‡rÚN" b"9V¡V\x19¢K]ïîJhñí\x05" b"9`€'\x12_D倶#w¬EÐV" b"9‡ú¼AãAN²Õ$ß÷èΉ" b"9‘\x0FÌu.KZ Á{µ)¿~\x1E" b"9ŸÐcÌnOÕ“Êžì\x14éø" b"9µ¤¬?\x00Kcˆj\vð_VÈ~" b"9¹Ó²2\x1EJ[‰\x05¥\e»6ã+" b"9ÌË(üÆDzûÚÔ&ˆ\x1Dó" b"9ä{•©D†ª\f:\fXu!d" b"9ù®\x17®\x18@JŽÒo\x00\x07!\va" b"9üs™È\x10F—µCRF´\x12¥\x14" b":\x06l˜L[@T©çyÁÊæû¦" b":\x12Aä\x17|O\x19€jv…ûÅ„a" b":\eŽ=›ÜDОÍ\x00ÇëÙ›K" b":3s«#>ã\x15¿4\x05(\x020i\t" b":7\e”X•L“¯ôÅ—\x7FÑ’µ" b":`®sX ô¯D\x1Fæ^"àÙ‘" b":…‘Jz\x04@¨¾O`\x16_+\x04ž" b":£vÄÓIi‚M'ÂUm\ï" b":¯žŒ\x0FüIhšE#\x11ÿ&#" b":³ ZãÓKP{\x07ÎìY’" b":À‡cCJN\x0F§ì(#™÷Yl" b":Ä7…^¹@ˆ…nån’g\x10r" b":Ï~V\x08\x12m›\x1CUuF:\x14¾¯" b":죑\x11ûºÙK’UEË˳Æ" b";\x07˜¸Ï(J\e’mº½kµþ˜" b";\x07÷_LJË—<Ͳ~Zÿ˜" b";\vµN¼\x15Z?·-\x04\x06^î\x1At" b""" ;\r\ed\x01úK;¶\n ã¥ô÷\rà """ b";\x0E—¸+f\x04ñ8h\x1Añ¤\x18,·" b";(º2ñ\x14‰š§N„û‰\x19B~" b";7\rÏ\x05ÊÉq<€”H[$Y" b";AŽ\x04¼œ‚\x17pKÿ’Oêex" b";J\x1EÄløOH‘Ã.¬Íµ:Ð" b";L,/\eJ”\þQ\x132}©" b""" ;dí\n \x16]Eª™³¥Ê\x08\x18ÆD """ b";eµ¡×\fu΋\x15˜{§}U"" b";fÂ\x02\x17M‹!DšÂµ\x02£²\x10" b";g\x08¸Ü\x19é\fi÷\x10ûá?N¼" b";i\x1Eì|@BäžBå_Ï›Áë" b";|2Ž\x07\x16LS Uù\x00Ä€£" b";§·ó³úD‚”÷jžã\rÜ" b";º¦÷¾J™šæ\x069ígcV" b""" ;Ī½Ä‘ý³7Z·•\n ›Õˆ """ b";éÑmA Rü\x14s>•çk\x14" b"<\t4:\x7F…Ka›;x\x7F<V‡„" b"<&ê©\x0E!Lë’?aþ(\x01\x1E¿" b"<("\x7FkìT;p ¥ÔxŠcß" b"<2Qè\fõCî«JFš~t†•" b"<7SÐO\r\ÐËœ\x14bÃ@\x15è" b"<LB爵Í&Cú[÷M/U•" b"<otìþÉBÔ±ÊáBWÕq>" b"<s>\x07¼úDH½\x17e9ž\x1D\x07Ù" b"<ŽZŒ¼êA–\x1Fë\x1EHH" b"<Ÿ\x10îÇ\x1Ep5AL\x7F¬‹ö±â" b"<Ÿ˜\ðþFœ¤ÏKÏð\x17Ó," b"<¤£ÇÿiGƒ¤CUF¼Iî\x05" b"<wÐPxn\x1CZh‘ƒ€ès" b"<·§Í†ùH…\x17iŸ^i\x1FQ" b"<¿î[úaBõžê;Lè%Ïœ" b"<Õ\x00=\x192I¤·à¤Þ\x18ín™" b"<êH#2±E\x08–. ´ÅÙ\x0E]" b"<íoZ\x05\x15C¨½DQ8ü&›‰" b""" =\x08\x04g`út\x14þ\x0EÏϧÞ\n \x05 """ b"=\x08Bj\x1D©Iö¡$¢®ÏÜg`" b""" =\n /OÀjK»“jõ\Ø |] """ b"=\x1D)Ô\x15µ§É5ŒÉ“}JÈ‘" b"=&\x1FϼQAvªµkdž d" b"=>{\x18E.¿¼\x0Fi>1C\x07•h" b"=_ô0™fJb··…_T|š[" b"=h…H8¶û}€wA!™¾Té" b"=‚~RXÓM磢qÕ$Gä“" b"=•”A#Þy* èÎ\x02\x18yï„" b"=ÍÕÉ\x18\x08HÊ—\x04fþ[`²k" b"=êÝÛ>\x12ÛQ¨‡BŸˆÉ„y" b">\x03\x03³ÚMOð¢EfÑÕ©ÃN" b">\rì},™-&_2\x06oV‘ùÌ" b">#BÑ¿`F²‚jS×…À”ÿ" b">.÷¬åFF¬›`œïìz%b" b">:3ìfõr>Îݶv\x1A_R" b">„z 1ËI¢ª¯\x1FŸÇ±·Í" b">‹˜]“:M¶“ˆ2œBAˆ·" b">“ªª\x19Z) fÈÒÜøZƒ5" b">*8×eAR±ÄþFŽ^\x1D;" b">´\x14\x1F’JÒ‚¥ì@\x18–“}&" b">Àú\r5×@\x1E˜\x08d]äë}»" b">ÜäÓH£3ùÔé³T*ÁÈn" b">ï\x128ËeKŒ•è\x04\x1C‚à7¿" b">÷\x1Eli\x10IDÖÉ•®+Mæ" b"?\x0FnpdúBÓ‹‚IW¥wXÕ" b"?\x18Ñ\e¶“Á\x00°@ŠhÕ[Ä}" b"?#@£éUAiµ\x10Ð\x08+½BY" b"?N“\x07\x00\x11M½˜˜½{ËÐ\x01" b"?~óúÞë°å7ß³?{¦´" b""" ?ƒ-;¹5CŸ§o–\n òŸùò """ b"?ŽEÇQè\x1C«Ð’JEºü8ì" b"?Ÿ'vo"û¼×Ïž¥G\x05[Š" b"? `O»,C”´\x18¯†¥’X\x0E" b"?³ÌÝŽ¥õDm,©„z^FÅ" b"?¸œk–fGi´\fg‘ÇTý" b"?»_ê1Î@ú14Æ<”ºO" b"?ñ5\x16HúH|˜~ öä:O—" b"?ý’´Ã”E‹µ&›ÌÐRˆ\f" b"@\x07&~0H\x12µd?ŽÅfT&" b"@&\x07[ÏëHù©´$©¾À?\x18" b"@3»Z$óE³žkm72«,¸" b"@z—\vÓS@øº%á³´BlÍ" b""" @|\n †ìÂ\x07…nDÍ7\r\x12èÉ """ b"@‡ƒ\fï*Æq²ÊM\x17¡Ø\x1AÙ" b"@‰9\x1E‡y_ëc,§Ú&b¶8" b"@Œ\x17vÛ+JãE\x17dÀÄU9" b"@m\x1FOLJ\x08“\x14ŸLôøj" b"@tî\x19¨àÎ\e\x0FQûV" b"@ÀZ•\f¹N\x03¨B8b—@tC" b"@éåGÆ,K ³Š\x1AuŽ”q\r" b"@ö¡…\x07SLY¤úŒ?\x03áèt" b"A\x0EÒ(aÒOÎŽ›Þ¸²¸ˆ½" b"A\x14w—nFa¢ª4€2\v‰”" b"A\x1DB()*L2ŸL·êÅì4%" b"A(\x05MŽ£r뀱Ǽg\x1E8h" b"AKĹ\x07×FZ¤\x04žÓ/OÑ" b"AtÒ¹³B<¤h]ûÒÄÜÉ" b"A”Äï5#rŽ:L\x08\x0F¤â" b"Aï͵JL… Ùï™14‘Þ" b"A¦Íõv3K‚¿âý1<yzD" b"A¹\x1D™ùœn1Ÿgg•§ "" b"AЉGµ€F±Ž\x1C!\x7F\x07SG¹" b"B\x069MføOu?A g-s" b""" B\v3A±jJ0‡\n »…ln§¹ """ b"B\x0EÏÜÎHÔF_É5\x12§\e" b"B\x15B#»9Df i\x01·šŒ}©" b"B\x1Eí7Ÿ;A™šñÀ\rî\ßã" b"B\x1F\x0ET_Aìèø \x12}èæ\x10" b"BHØ\x11b\x0FET¢XoøÞ ˜´" b"BU\x18I\x11VIÀ™Í\x07'ßýqœ" b"B[ O8#\x1F„pú\eÔÏ\e\x11O" b"BfB–H%V\x1EÿÅ!HoÜv" b"Bfk5°ÅG€&¢Í“u¢—" b""" B{NY\x1DðNï¢É¹\x10n\n Ø """ b""" B’ñÃ1|JO™'jÛ¦Ð\n Æ """ b"B“\x12îâ¬GÊݥT=tìƒ" b"B©¤œ\x1AÆEÏ® #ÃŽ\x1Aq" b""" B,aKA½p\n 9½ """ b"BÓ‚\x00ðFV„É<TÆS»é" b"BÃ\f»’lE+ŒÐ$<8t{" b"BÔo\x05F¢_îï\x1C1’\x1CŽUp" b"C>ªÕPc2–8ù\x06eqôv:" b"CN7\x15\x130à`ålµP0+Ue" b"CYJ¢õïÐ7-nëß?‹þ~" b""" Cn\n ÞPñgûèìôËJR‚ """ b"CnOVÄ?^4&3JAô¸ù\x1F" b"Cz%™WvŸ«éƒÇXi¸EŠ" b"C?G\x10®BWž¬Ü…ƒ$i" b"C³f•’EG\ˆ!Ž`½Áü‰" b"CÌ5è\x06>H\x19œ81Qj\x1F¿—" b"Cá\x031\x1F<$ÀDÇUuñ7•" b"Cö.ë\x1F³\tëL~¹–—’ȧ" b"CþYéDŽAS5Š‚kç§\f" b"D\x08ïGøuI· ¡æHÓ¿›" b"D\x15~AmMHj¿Ò©sâCø\x1E" b"D#S]JZI‹\86¼-\x04»o" b"D@µwþIK2‰í\x12\x14éTz\r" b"DM]î“6^ŽR¨¤\t\x10S”=" b"D_þFd—Lö‰ðÒåc]\x0F " b"Dfÿà]Ò1÷¥íp+ŽÛäï" b"Dq\x11Çâ±Mƒ‘:?¢\f¢\x13g" b"D·“ÕÝAEõ½`…Æ\x16qFZ" b"Dï#n¼Fº\x03$Íw¸5½" b"Dóf*{J·kcä@1º\x14\x06m" b"Dõ5MâdOy²\x05ä9à÷|:" b"Dú¬¾\x0Fª›\tlÚf—bJ\x06" b"E\x06ÉÀ}Î@ž Èϋćá" b"E\x19ÝÉyúDêªùÈvñóâ¹" b"E «øX$DÓÐr©ï\t”`" b"E.$R?¦Dùºsá\¼\x1Fbè" b"EF¼5¢.Bͤ(Ó7•ã+A" b"ER]E\x08ÈMÄ®F´ˆ\x17Š_r" b""" EU\n ²£ËN*©áöúé…\x0F """ b"E]用’Gкø\f{:Ê!Î" b"E‚/d\x0FÿKϲ:.Mˆò\x0E•" b"E”"\x1DÃ\x05]‰äs7êJ“„í" b"E™‡°ÍØJt©j1ø<rQØ" b"E³L¤-¢K\x0E» +N\x03B$" b"EÀ¸VÈ®“w…\x15q6¯[‡¼" b"EÉ\x7Fÿ>EB\x05™¿áÄ\x05K&" b"EÎQ\v×\x18F¹›ë‘_‘ø\x0Ff" b"EÒæ8P/µ·\x04¼˜Ó݉" b"EÞ\x00"-\x1FMS¢=¿§À\x11øa" b"F\x07‚ë\x04ÍDŽ‹©\x7F\x13âì®Z" b""" F\n ¼¾šËM{jÂçh|Šê """ b"F\e[¨¸t]{£\x04¤ì0!A}" b""" F:y%q\x10•2{\n v–“¬K """ b"FHW¦³$p:Ú4\eDF%\x10=" b"FKQ\x14ÎÖË‘¿o2‹“x®/" b"F_§þ$íA&´bíkû\x01<¯" b"Fx[5T»N"ªŒfÐ\x1D'Œ@" b"F|:ÔúFS’\0/Ê\x18£*" b"F€Ø¥Z÷Ž]íØœZ+J#x" ] |
||||||||||||||||||||||||
|
2.20 ms (0.63%) |
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:
[ "/navigation/19ca405790ff4f07aac8c599d4317868" "/navigation/e8a8269008a540938b0fe5c9f5ddda80" "/navigation/44cf99695e964def895a2f2938c049e9" "/navigation/656bf6338d194c4c86f26735fb442233" "/navigation/2a10ddb190174f688f9bc1d14697c06c" "/navigation/6db7ddbb1c764ed38b1b8718f1e4c6db" "/navigation/48f97f432fd041388b2630184139cf0e" "/navigation/bb22b05bff9140f3808b1cff975b75eb" "/navigation/06f5dda360c04112937601574122c515" "/navigation/c3057bb031634c669cd6dfb0d4acbb15" "/navigation/e379fcc096f343568dcb1e294d45c931" "/detail/aef4237381ae45aca4c074c9883422f0" "/detail/42ecfff19f624ca0a0a0b454d71715e6" "/detail/f9abeed2d89e455f938d2e56b1540333" "/detail/9b3cee7659684f1b93d2fbecd3a10bba" "/detail/4adf9425a9924eee899688708101bd69" "/detail/b49f3f718b68440cb7185c048d511079" "/detail/b5f0ff1534534df2b0470092cfc193bc" "/detail/4951246cab2b4af9a671cef7af4cba5f" "/detail/de3d2ad1366a4bf39acedea7dc8cfd94" "/detail/70f4b86942984301bc9a83544fc3ed50" "/detail/ba0b35780beb44ddb2faef5a810b5aed" "/detail/9da747c62c894ecd8b6c1583dfd2e011" "/detail/f1a843fa03f7450a9562ad77874ae7fb" "/detail/b105b91979db4a87afe29cbc0739c155" "/detail/8b03e83379994446adceecf8bb61e8d9" "/detail/ce7597fed209492dae1f6980b745feab" "/detail/aacb59c0e8db41029a268751f02f54f5" "/detail/fa0b43973633443087161ced04e56c62" "/detail/11d75939c7f4456283b988a482c8db20" "/detail/a8adc80dfc9045c7b2e20fc3c51ee771" "/detail/7b71902ea8ab4eaa867955347355d925" "/detail/887df5f4f9c5483abbcb3bcd41ad72c1" "/detail/dbe6469662da4b4594c5f9c53808b62c" "/detail/1aa433c11f444ca297a54c1026b105c2" b"/»_ââšMpªXTÎ|ãâ\v" b"Íe’Æ6®Kóƒx°\x1A›1äm" ] |
||||||||||||||||||||||||
|
1.32 ms (0.38%) |
1 |
-- product-listing::property-filter::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.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`file_hash` as `property_group_option.media.fileHash`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.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 `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`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.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"ï=4„ؽI¹º\x10’9°í©n" b"ïOY ß Cyˆ;@¬\Ù‡\" b"ï_^z\x19uN¥Žs\x05¾M¼£N" b"ïd¼ÆÉW@a»e\f9®\x12†Ç" b"ð¢wOÚ¨[擈\x10ã" b"‚5…F¥®â¹ª©ì©\x7F" b""" ï¥\x0Epå«)\x1A\x10™<6\n *\x04J """ b"ï¬qš‡´C¡¾ÜïõüGb\" b"ï°\tWÉO.wP\vÍ~Lv!" b"ï¹Ï\x14\x07t³Â¹qäÖGŠ\x05/" b"ïÈc´™’\ß+5gê\x08¦|>" b"ïÙ\x16ðO\x04Nw½\x15Ù…Å`Ài" b"ðJ\v÷É×Ió˜%€_XTÆQ" b"ðk\x03¨/KëžztYUøE" b"ðn–hn\x05J\x1C—’èëw\x08\x07Ä" b"ðpØÅèôAÒɆ²\x04Ôw«" b"ð·<ºyŸ\x1C"}Ñ’O|6h)" b"ðÇNv|^LF˜ç\x19ã!(…º" b"ðÚmôœëLu†jƒ$\x04Äó\x10" b"ðê>\x06«ÛL㈘Îÿåj‚î" b"ñ\v\fÀžZü·Ì”\x13YøÛ,d" b"ñ\x11H\x0F¯¢NSÝÚYi\e´R" b"ñ\e\x19\vÙ Hþ®«\x10Hó.à”" b"ñB9j\x1E)Û ›:&h\x1DÚ"" b"ñJ\x04\vgsK\tœ¨»î»hÛU" b"ñQ £\x11íÛ¾F\x0Fâg©á³3" b"ñaÈùFŒK\x16’Ù½\x19³…ñU" b"ñj½¹ÂaO¥›q2TZ¡Àû" b"ñ™8N\x1DÎ1Þ\f+ c˜ÿ42" b"ñ«.?ïä·Zê\x19KìV->û" b"ñÅ]¦Ž1M<§]O8äŠÎ" b"ñäñ;\tqN}¸\x1D ÓéûÐu" b"ñò€¹ÇeA#»ZûòÆxH¤" b"ò\x00l–W@E\v£Lè}?b§©" b"ò\x04£ÈZpJÒ›ú\x1C\x08ÿ¦/+" b"ò^¶$ÏgEë•\x08¹©\ez~<" b"òrõÞ©'\x15ûKdÐ\x04úÝ®ì" b"òƒu›õäE\x11‡}\x02)Ø\e0P" b"òŽåÿYœC9…Ž`±Æa®Þ" b"ò½öÓK©L¨€LâN¨\x16\t{" b"òçÁgzŽrÿ\x07ëQÔáW£" b"òéþÌtE˜Œ:¤¾Á‚\x07\x13" b"òê\\x1Fdt(§/sä<Dtl…" b"ó\x03I<T'CÇͯ¿ZȨû" b"ó\e¢ú®\x03Lh¸'\v\e\x01U\x08ò" b"óW¸¦9 Ú"Þ98é!\x02{ì" b"óZ\f\vA\x18í(ûtËëN›|Ö" b"ó^xŽ9©O\ŸÉ-IÎ\x02\x02" b"ón£7\x1FéG\x17¤Í0%Hé\x08\x05" b""" ópaÐ\x06ºA\n ¡+Ù\n G:)· """ b"óƒ\v@¸‡KlŸ[ÌÝ'\x15\x00" b"óƒ@\x07U4jz¡DøÎ ñ[•" b"óŽµ\x03¤± zÑ°£Þ¢ß6:" b"óT\fX_I÷µUÝ9«/-M" b"óãÇÉmÓKg“¾7,šB\x04ð" b"óåö ¼ï@V¼Ô»¾\vÒím" b"óý”\x04\x1Fù@T‡µÆ\x18ýÌZ" b"ô\x07*€dªp\x14Ê~cy¸Î#^" b"ô\x15Û‘˜-J÷³CÖqkX\e;" b"ô'dU2\x08Ozî,’Œ’Ž" b"ô+\x05Ï^\x14O¨‰ì±oÑ1<©" b"ô6ûnÑýCã´Ý²aý¾¯B" b"ô6þÃø\x19–ü׺³äŠÔ¯" b"ôK3²ÉŽDí€Ë\x19Ž[¢a," b"ô\Ÿý\e4@mµOÈMFHw+" b"ô`2¯äIJš”,¨Æ\x03jw\x0F" b"ôuã¼1‡vQ²Þ\x15èÞš\x17¶" b"ô€;KòPp«—.ŽR½V¹ü" b"ôŠ *)\x15D$ŸáxÂÜ\x11Î " b"ôŽÞJ3O7ƒêW?øEŽ\x02" b"ô«‰>ô\vHd«äd1¨‰\x06˜" b"ôÀwšLäB8˜£hY@djÄ" b"ôèÃ\x00è\fOÑZÁ\x01Á\x0FÉ„" b"õ(\rù¸ÊM5‘òÈ—D\x05ŠA" b"õA9y¸¥LB¿\x16z\x1A\x1APvc" b"õdõ\¡îO¦¢ŒZï4\f>" b"õÖ\x10çw\x12\x192×·û»ip|3" b"õðCó˜\x1C.6DÈ,¯¦-o_" b"õöäþ\x03”GŽ¼|a³;\fø<" b"õ÷\fÞWJ\x1AÆ"4(Êšþ\x10›" b"ö5p\f¨(Jñ…FIAG¤Õ6" b"ö:\x0F£Â3G”…D\x1E%qm|" b"ö<þU€¥-V\x03ÿ)ŽË5\x12o" b"öO¾¦ŠR`#È_žð“\x12\x07!" b"ö‘\vž+ß\x16¸{¡*ê’öwd" b"öž„p_U‡ÏäïW·+é¹F" b"ö£l”uIC㺅\x01+sm4" b"öª*”ðO!\x1EsuŠ\x0FÃýÆ" b"öªVú™\x1E‡<w\x022Jü#s¶" b"ö¾†Ú`ÄH”§°iGS»sH" b"öÃfÚ\x08ÖãE(tÔ´\x0FääQ" b"öä•\x15êßMè„jdÔBÞ;" b"öñ\x0F¬ú,O)\x11¡ÀéÕ†n" b"÷Ô$tÛ¿O]‡\x18þ”\x03ÓN\n" b"÷èÐcLãÜy!\x1EL@I\x13ø" b"÷ý·˜á\x16O\x02š‡\x17\x0E\r\x1EŽ" b"ø\x16<\x128,˜Õ=à \x14=´¿ú" b"ø\x1Aë\x15—íB~‰„Ëôà€Ò." b"ø# å}/J6©ƒmÑ@\x04áb" b"ø(>c\t°˜?\x16N|:y2Š›" b"ø,\tè?vLýŸÿ\v‡¤¡®o" b"ø0k3¹€ÆRµÔA„¶”Ê…" b"ø7\x16\x16bÏC¥±õë_&ïp" b"øW8<þ’E»±Ñ“ïÒµ“\x1F" b"øb¥ã£Ð*Å\x1FFÙ)bTó±" b"øƒ+'+7A[®\x0E,\vŸŸ³@" b"øˆO{õàB¢£|u“”ÒLA" b"ø¤<\x19É„B[-rµP¦)\r" b"ø¼ÔKÃ5Iù—¿¡.㺯" b"øÖ‡]<ÈM{½1ló×\eË–" b"øñ’…BèEí—çk"<…Ïk" b"ù\x06àŽñÒDç\x12(„.5¶¦" b"ù\rB3\x1CE‚µ—·bæ»'\f" b"ù&›#É€\x07EzhŽÈ" b"ù)Kòµ»M7…F}˜*|" b"ù-ŽÙQÂ7…ÉŽ~$dûíˆ" b"ùGǧ\x18ÉÁÝãŠ_¹öcL˜" b"ùe\x1F+ÝWJC¹î\¼Ÿ9€t" b"ùi(«yÌO\x10€|\x19¤ˆæ\tã" b"ùrgäá½AC¸–+Û¼\x02Àx" b"ùw`\r.ðñp¾M› ]îú*" b"ùzz!Q°O,\x10ÉÅòú\x1A\x00" b"ù<`V‚Aà¡€\x12}㟨ú" b"ùœÅJ¼¨C3žŽ;«7¶µ" b"ù¦²Uh"B¥·Ý=ˆŽ\x18©" b"ù¬„\x06ð‰DpŽhâY°ïá\x16" b"ù°ŸšeÄK•¨%º]Û\x0E\r¤" b"ù³ÿ©)àcqDÞ\x01›\f}«" b"ùæC4ÒúD™«Må\x13DW~ñ" b"ùó"\x05€\ræ\x16äì2¤\x1E\x07é—" b"ùú¯—\x07n@`ší—õˇ¡:" b"ú\r隷"I[¸¥ºRÒ\x15Œð" b"ú\x16G\x04R|Mn¨ä<ÒÀb²}" b"ú#\e+—-E~\x075zT¦\x03*" b"úXå*(º@ô¹³ªò^\ry\x14" b"ú}«d™Î[Ä*½Íùý.~" b"ú•ÓB'RêÈ8¹ÝxÞn&Ù" b"ú·Hlù}Jò±ÉQtDfª\x16" b"úÎA<&!Ó?X_\x03\1v˜–" b"úÐÀ+\x1EÜM£±Y¢t \x14˜7" b"úÓå\x14\x1CVC\x18›È\x0F\x05‰ØL[" b"úÛe:Oyyû"2Þ\x1FïÿÀY" b"û\x1C\x7FX—À5wû4C=\v\x17is" b"û*Ê•\vHC˜“À;›kx\x00™" b"û@Ý+†uFA´\x1A`+\÷>€" b"ûVOö\x03íb\x15«m¹²–\x1FÕÿ" b"ûk£Ìª\EŒ—¦BR)wx¥" b"ûoH¶„ÄN”È¢Š¥[\x18B" b"ûy(<Q|B±žÜ½&!EKý" b"ûšÕ…—!\x16¾\x1F\x1Aµ·m²í\x13" b"û²Œ˜Ù\x01G¡¡°ä\x14ŽÇ¥¨" b"û²œ\x1E¤"›ÿu;¡×þù\x10‰" b"û¶1ñ³ÅGi½êàù\r×Ô9" b"ûÂXùg¬%¸ÿ*\x13Iµ;\x02ì" b"ûÏ}\x00'ÅFd†Ä¢rsm`‘" b"ûÞ<Ôâ\x03™âýr‰Ð\x05Ùª" b"ûÞ½så„¥¸†i0wn²í" b"ûæ‘A4±\x06¨\x03vÉçS˜ö" b""" ûö%™Ú¦8òði \n \x10m\x02¦ """ b"ü\x1A8DÂÖÃÀ\x1E\x03‹:^µã?" b"ü1c\x04\x06¦_õ&\x13\t¾c0‚¡" b"ü4a\x17=ýDš½¿G\x16Ä\x05÷ø" b"ü: \t²óD1«¸{ö\x19·D" b"ü>¯Vh¸CXˆ8X¡}ºó" b"üB×£qðã¾\x03@ÞýëÜÑ" b""" üD\x08û¤Á˜M\n 1«±0Û ö """ b"üMû îÁAP‰<ãpTÛâ" b"ü^X=‡JL‰”–.Ù…ƒèM" b"üfi\NÙ;¢M›ôRÍT\î" b"üxîàê˜Ã*|·üJ¦Ñ¹" b"ü£\x0Evþ\x18I3¥Îø+(hß5" b"ü®ªõEËM·êrº¡U\x18¹" b"üÎÙø™èN-•öZŽ©¾ö–" b"üû’à†—I_¼€oË'õ‰;" b"ý\x03\x1F\f\x1F\x03B1–œ\x1C> ;´–" b"ý\x12/;\x1F;G©‡´;7n-;" b"ý8'’ÏŸø\x08\x12¥ª~`v\x1AÐ" b"ýL›"(ˆÊ€¶N‹\x150ßs<" b"ýyMõŽsM™¯\x04@#û\x04ê‘" b"ý}?Ùä‹KŠ˜„h‘äqÑ\x0E" b""" ý—)…u«uÉJ\x14x'\x7F\n a """ b"ýRGAßD¬µh<üXu+ô" b"ýý\x1DŽ¼öFBðŽÏö\x18\x15Ó" b"þ\x08(Ý»AƒÃÒ¡¯ÃîBì‚" b"þ)B€N¢I\x7Fœt\x11¡²êÂ$" b"þ^ôŸs,_a!R_bX>vB" b"þhjÏœQMa’yéÎë!r" b"þŽ•uåé‡\x12‡G«U£à¿¢" b"þU‹®\x00I>¡N \x1A] /" b"þªŠZ¡\r¡!ØpoËÔ\x00”j" b"þ¬t\x01\eØ\x17tB—¬R\x0F t" b"þlðÿ²C\e¤#•oƒA—¨" b"þÀ˜€m$@8Š\x1Dø…jÊœ‰" b"þÄb\x1EŸMTŠ,Ô/Œ£As" b"þß \x01§\x0EAk¡Ï¦V"\x07K" b"ÿ\x18\x7FIΦzô–ªcuÖŒ.&" b"ÿ\x1EòÔ/pFv¢ê\x15 S—ò¥" b"ÿ4肘CÆœ£Å‘±\x0Eƒþ" b"ÿ;å\x13÷O+ŠåLù½S¶ÞF" b"ÿ<EŠÈ\x02v›/Ž.—\e$·à" b"ÿVîk!\x19D&šî_V4aúÿ" b"ÿhÏ\x19\fYFZ©Q\vË,Щ(" b"ÿlRjm\x12uÇm\x17\x1AÜôÉ^" b"ÿ†\x07ëà˜Jã¬W0._î¢\x17" b"ÿŽ"mK>]\x1F8Ý\x03ºû^\x07‘" b"ÿ’á'„çF\e†X€j«l±“" b"ÿ \e±¼ÊF…TŒ™‚^æ\x15ç" b"ÿ¬†lRý”e(\x1CpvõþöÄ" b"ÿ¼*Çåöà?Uõͤ½\t•{" b"ÿÈ'©\x13NÒ¦|Õ o\x0ELŽ" b"ÿÏ\r³&¬E6šj×âô·Ði" b"ÿçjZ•\x01NÅ•¿è\x19¿g…^" b"ÿçÚ„…ÛJgªª!Zá\x15Ù”" b"ÿ뎃¸sOˆ”è µxú\x7F\x1E" b"ÿÿE\x12\x02c‚ÕÐ\x1DÆÖ(å±j" ] |
||||||||||||||||||||||||
|
0.67 ms (0.19%) |
1 |
-- product-listing-route::loading::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"Íe’Æ6®Kóƒx°\x1A›1äm" true b"®ô#s®E¬¤ÀtɈ4"ð" b"BìÿñŸbL ´T×\x17\x15æ" b"ù«îÒØžE_“Ž.V±T\x033" b"›<îvYhO\e“ÒûìÓ¡\vº" b"Jß”%©’Nˆp\x01½i" b"´Ÿ?q‹hD\f·\x18\\x04ŽQ\x10y" b"µðÿ\x154SMò°G\x00’ÏÁ“¼" b"IQ$l«+Jù¦qÎ÷¯Lº_" b"Þ=*Ñ6jKóšÎާ܌ý”" b"pô¸iB˜C\x01¼šƒTOÃíP" b"º\v5x\vëDݲúïZ\vZí" b"§GÆ,‰NÍ‹l\x15ƒßÒà\x11" b""" ñ¨Cú\x03÷E\n •bw‡Jçû """ b"±\x05¹\x19yÛJ‡¯âœ¼\x079ÁU" b"‹\x03è3y™DFÎìø»aèÙ" b"Îu—þÒ\tI-®\x1Fi€·Eþ«" b"ªËYÀèÛA\x02š&‡Qð/Tõ" b"ú\vC—63D0‡\x16\x1Cí\x04ålb" b"\x11×Y9ÇôEbƒ¹ˆ¤‚ÈÛ " b"¨È\rüEDzâ\x0FÃÅ\x1Eçq" b"{q.¨«Nª†yU4sUÙ%" b"ˆ}õôùÅH:»Ë;ÍArÁ" b"ÛæF–bÚKE”ÅùÅ8\x08¶," b"\x1A¤3Á\x1FDL¢—¥L\x10&±\x05Â" ] |
||||||||||||||||||||||||
|
0.54 ms (0.15%) |
1 |
-- category::data::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.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` 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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" ] |
||||||||||||||||||||||||
|
0.53 ms (0.15%) |
1 |
# product-listing-loader::resolve-previews SELECT parent.variant_listing_config as variantListingConfig, LOWER(HEX(child.id)) as id, LOWER(HEX(parent.id)) as parentId FROM product as child INNER JOIN product as parent ON parent.id = child.parent_id AND parent.version_id = child.version_id WHERE child.version_id = ? AND child.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"®ô#s®E¬¤ÀtɈ4"ð" b"BìÿñŸbL ´T×\x17\x15æ" b"ù«îÒØžE_“Ž.V±T\x033" b"›<îvYhO\e“ÒûìÓ¡\vº" b"Jß”%©’Nˆp\x01½i" b"´Ÿ?q‹hD\f·\x18\\x04ŽQ\x10y" b"µðÿ\x154SMò°G\x00’ÏÁ“¼" b"IQ$l«+Jù¦qÎ÷¯Lº_" b"Þ=*Ñ6jKóšÎާ܌ý”" b"pô¸iB˜C\x01¼šƒTOÃíP" b"º\v5x\vëDݲúïZ\vZí" b"§GÆ,‰NÍ‹l\x15ƒßÒà\x11" b""" ñ¨Cú\x03÷E\n •bw‡Jçû """ b"±\x05¹\x19yÛJ‡¯âœ¼\x079ÁU" b"‹\x03è3y™DFÎìø»aèÙ" b"Îu—þÒ\tI-®\x1Fi€·Eþ«" b"ªËYÀèÛA\x02š&‡Qð/Tõ" b"ú\vC—63D0‡\x16\x1Cí\x04ålb" b"\x11×Y9ÇôEbƒ¹ˆ¤‚ÈÛ " b"¨È\rüEDzâ\x0FÃÅ\x1Eçq" b"{q.¨«Nª†yU4sUÙ%" b"ˆ}õôùÅH:»Ë;ÍArÁ" b"ÛæF–bÚKE”ÅùÅ8\x08¶," b"\x1A¤3Á\x1FDL¢—¥L\x10&±\x05Â" ] |
||||||||||||||||||||||||
|
0.42 ms (0.12%) |
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"
]
|
||||||||||||||||||||||||
|
0.34 ms (0.10%) |
1 |
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"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" ] |
||||||||||||||||||||||||
|
0.33 ms (0.09%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"Íe’Æ6®Kóƒx°\x1A›1äm" "qSPI9PlPHoK8zXegKUMx7nAhNbBwBEtV" ] |
||||||||||||||||||||||||
|
0.30 ms (0.08%) |
1 |
-- category::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `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`.`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`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `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"/š\x02ûª=B)¾àÇ᤹Z\x1D" b"/ó¶\x05–ßA'Œç51˜)ûø" ] |
||||||||||||||||||||||||
|
0.29 ms (0.08%) |
1 |
-- theme-service::resolve-media::read SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"\x01›1{Aõpµ·ñ:C‹u\x10È" b"\x01›1{AüqU¢Ý}ìë(D}" ] |
||||||||||||||||||||||||
|
0.29 ms (0.08%) |
1 |
-- product-listing::property-group-filter::read SELECT `property_group`.`id` as `property_group.id`, `property_group`.`display_type` as `property_group.displayType`, `property_group`.`sorting_type` as `property_group.sortingType`, `property_group`.`filterable` as `property_group.filterable`, `property_group`.`visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage`, `property_group`.`created_at` as `property_group.createdAt`, `property_group`.`updated_at` as `property_group.updatedAt`, `property_group.translation.name`, `property_group.translation.name` as `property_group.name`, `property_group.translation.description`, `property_group.translation.description` as `property_group.description`, `property_group.translation.position`, `property_group.translation.position` as `property_group.position`, `property_group.translation.customFields`, `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id` WHERE ((`property_group`.`filterable` = ?)) AND (`property_group`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true b"]ŽÃd0\x05MaH-Ž2\x14¿÷" b"\x08Eñ\t8Eê·Ö,«ŽÉùŒ" b"A»I_\x16KB)ŠT›"<3›W" b"‘éÚ\x1EìŒEÙ€H÷‹\fFb«" b"÷W\x15€\x02¯@ŸŽÑaà(~ÆÁ" b"Î\x7FŒ\r"ÂFòŽ ª\fá\x0E÷²" b"Á¸R´ñûO›ªÌV™›;94" b"År\x13žG©HH¨˜ú\x01i¥N®" b"Í\x0E`]m\x1FG…š•U}£/½" b"Bdé\r¹O®²ƒ¼Õ\x10ÖZó" b"O÷Ô(ï®H_»»ùŸ\x16ˆér" b"\x15'þÿFL¡,ÆÊ’\x0E5m" b"7¹“ñ\x1AÂCj·Ž»(»]\" b"\rÒPü8•EÖ…Ôi“Ø’Ÿl" ] |
||||||||||||||||||||||||
|
0.29 ms (0.08%) |
1 |
-- category::cms-page::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `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`.`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`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `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"vˆT\x04°{KC·ñ \x06xµ\x05œ" ] |
||||||||||||||||||||||||
|
0.28 ms (0.08%) |
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"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" ] |
||||||||||||||||||||||||
|
0.25 ms (0.07%) |
1 |
-- category::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`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `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`.`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"‚Ä|°LžCl„ÌFI2¡4J" b"ŽÇE\tø\rIÚ–„Á¬Î\x10\x1D" b"æôe‚ßhNÿ¦$oñ˶‡m" b"™,ÉX}\x1CFÀº\x1F¥p{J«<" ] |
||||||||||||||||||||||||
|
0.24 ms (0.07%) |
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"""
\x17\n
C\x7F6ø@²—-ûrøæ¿b
"""
b"\x1E›mÉ\vRG|·'÷ïeÆ]Ö"
b"8X•p\x16dMä®HÀP\vóÌÈ"
b"¸Rs=·eO;‚°T•Ë!ÚW"
b"Ð[4\ÛyIgƒ\x12\x17[ÄLKL"
b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
b"ï\x7FÙ.®S@I’\x06€\x12¨.’‹"
]
|
||||||||||||||||||||||||
|
0.23 ms (0.07%) |
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:
[]
|
||||||||||||||||||||||||
|
0.23 ms (0.07%) |
1 |
-- category::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"vˆT\x04°{KC·ñ \x06xµ\x05œ" ] |
||||||||||||||||||||||||
|
0.23 ms (0.06%) |
1 |
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"´ \x18·vGÉ‹\t\x17DV;ûÍ" ] |
||||||||||||||||||||||||
|
0.22 ms (0.06%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.22 ms (0.06%) |
2 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"qSPI9PlPHoK8zXegKUMx7nAhNbBwBEtV"
]
|
||||||||||||||||||||||||
|
0.21 ms (0.06%) |
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"Íe’Æ6®Kóƒx°\x1A›1äm" "navigation/19ca405790ff4f07aac8c599d4317868" "navigation/19ca405790ff4f07aac8c599d4317868/" ] |
||||||||||||||||||||||||
|
0.19 ms (0.06%) |
1 |
-- product-listing::load-sortings::read SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"´ \x18·vGÉ‹\t\x17DV;ûÍ" b""" \Ú\x06 .~GΔ\x15d¼¾\x05\n « """ b"ëbxQRjE-¸Ùc™#é!°" b"X`\rüN$N ©\x1FP\x1A‚}8ž" b"~sÌ+¤ÝJá‘\tdA\\x16vJ" b"–7JüB½A’¥Š\x1Fr«—GÃ" b"\x06jkîü~Kn‰)ÖL(ˆ¥\x1A" b""?xÂbúL¿ŸÕ1œ1Q±&" ] |
||||||||||||||||||||||||
|
0.18 ms (0.05%) |
1 |
-- category::data::association::translations::read SELECT `category_translation`.`name` as `category_translation.name`, `category_translation`.`breadcrumb` as `category_translation.breadcrumb`, `category_translation`.`slot_config` as `category_translation.slotConfig`, `category_translation`.`link_type` as `category_translation.linkType`, `category_translation`.`internal_link` as `category_translation.internalLink`, `category_translation`.`external_link` as `category_translation.externalLink`, `category_translation`.`link_new_tab` as `category_translation.linkNewTab`, `category_translation`.`description` as `category_translation.description`, `category_translation`.`meta_title` as `category_translation.metaTitle`, `category_translation`.`meta_description` as `category_translation.metaDescription`, `category_translation`.`keywords` as `category_translation.keywords`, `category_translation`.`custom_fields` as `category_translation.customFields`, `category_translation`.`created_at` as `category_translation.createdAt`, `category_translation`.`updated_at` as `category_translation.updatedAt`, `category_translation`.`category_id` as `category_translation.categoryId`, `category_translation`.`language_id` as `category_translation.languageId`, `category_translation`.`category_version_id` as `category_translation.categoryVersionId` FROM `category_translation` WHERE (`category_translation`.`category_version_id` = ?) AND (((`category_translation`.`category_id` IN (?))))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" ] |
||||||||||||||||||||||||
|
0.16 ms (0.05%) |
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"Íe’Æ6®Kóƒx°\x1A›1äm" b"Å\x08×PÉVKÿ»IQ\x1EøP\x08r" ] |
||||||||||||||||||||||||
|
0.16 ms (0.05%) |
1 |
-- seo-url::resolve-fallback SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"Íe’Æ6®Kóƒx°\x1A›1äm" "/navigation/19ca405790ff4f07aac8c599d4317868" ] |
||||||||||||||||||||||||
|
0.15 ms (0.04%) |
1 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `id` = ?
Parameters:
[ b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" b"w¹YÏfÞL\x15Çù·Ú9‚ó" ] |
||||||||||||||||||||||||
|
0.14 ms (0.04%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.14 ms (0.04%) |
1 |
SELECT `theme_id`, `technical_name`, `resolved_config`, `view_inheritance`, `script_files`, `icon_sets`, `updated_at` FROM `theme_runtime_config` WHERE `technical_name` = ?
Parameters:
[
"Storefront"
]
|
||||||||||||||||||||||||
|
0.13 ms (0.04%) |
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:
[] |
||||||||||||||||||||||||
|
0.13 ms (0.04%) |
1 |
-- product-listing::load-sortings::search-ids SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters:
[
true
]
|
||||||||||||||||||||||||
|
0.12 ms (0.04%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||
|
0.12 ms (0.03%) |
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:
[]
|
||||||||||||||||||||||||
|
0.11 ms (0.03%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||
|
0.11 ms (0.03%) |
1 |
-- product-listing-route::category-loading::search-ids SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" ] |
||||||||||||||||||||||||
|
0.10 ms (0.03%) |
1 |
SELECT path FROM category WHERE id = ?
Parameters:
[
b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh"
]
|
||||||||||||||||||||||||
|
0.09 ms (0.03%) |
1 |
SELECT DISTINCT `technical_name` FROM `theme_runtime_config` WHERE `technical_name` IS NOT NULL
Parameters:
[] |
||||||||||||||||||||||||
|
0.09 ms (0.03%) |
1 |
-- product-listing-route::category-loading::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x19Ê@WÿO\x07ªÈÅ™Ô1xh" ] |
||||||||||||||||||||||||
|
0.08 ms (0.02%) |
1 |
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.