Query Metrics
80
Database Queries
56
Different statements
24.30 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.43 ms (14.13%) |
4 |
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`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` 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`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` 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ï\x1E/ÔÚsQ╗ÚØËÙYòÙ" ] |
||||||||||||||||||||||||||||||
|
2.40 ms (9.88%) |
1 |
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.productManufacturerVersionId`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` 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 (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (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_search_keywords as `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config as `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, `product.parent.translation`.created_at as `product.parent.translation.createdAt`, `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, `product.parent.translation`.product_id as `product.parent.translation.productId`, `product.parent.translation`.language_id as `product.parent.translation.languageId`, `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name as `product.manufacturer.translation.name`, `product.manufacturer.translation`.description as `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields as `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at as `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at as `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id as `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id as `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id as `product.manufacturer.translation.productManufacturerVersionId` 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 WHERE (`product`.`version_id` = ?) AND ((`product`.`id` = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"ªÎIÇØ\x07gÏþÀå\x13®ˆmð" ] |
||||||||||||||||||||||||||||||
|
2.18 ms (8.98%) |
1 |
# Manufacturer getManufacturerByChar manufacturer::read SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.media`.`id` as `product_manufacturer.media.id`, `product_manufacturer.media`.`user_id` as `product_manufacturer.media.userId`, `product_manufacturer.media`.`media_folder_id` as `product_manufacturer.media.mediaFolderId`, `product_manufacturer.media`.`mime_type` as `product_manufacturer.media.mimeType`, `product_manufacturer.media`.`file_extension` as `product_manufacturer.media.fileExtension`, `product_manufacturer.media`.`uploaded_at` as `product_manufacturer.media.uploadedAt`, `product_manufacturer.media`.`file_name` as `product_manufacturer.media.fileName`, `product_manufacturer.media`.`file_size` as `product_manufacturer.media.fileSize`, `product_manufacturer.media`.`media_type` as `product_manufacturer.media.mediaTypeRaw`, `product_manufacturer.media`.`meta_data` as `product_manufacturer.media.metaData`, `product_manufacturer.media`.`config` as `product_manufacturer.media.config`, `product_manufacturer.media`.`path` as `product_manufacturer.media.path`, `product_manufacturer.media`.`private` as `product_manufacturer.media.private`, `product_manufacturer.media`.`thumbnails_ro` as `product_manufacturer.media.thumbnailsRo`, `product_manufacturer.media`.`created_at` as `product_manufacturer.media.createdAt`, `product_manufacturer.media`.`updated_at` as `product_manufacturer.media.updatedAt`, `product_manufacturer.media.translation.title`, COALESCE(`product_manufacturer.media.translation.title`,`product_manufacturer.media.translation.title`) as `product_manufacturer.media.title`, `product_manufacturer.media.translation.alt`, COALESCE(`product_manufacturer.media.translation.alt`,`product_manufacturer.media.translation.alt`) as `product_manufacturer.media.alt`, `product_manufacturer.media.translation.customFields`, COALESCE(`product_manufacturer.media.translation.customFields`,`product_manufacturer.media.translation.customFields`) as `product_manufacturer.media.customFields`, `product_manufacturer.media.translation.createdAt`, `product_manufacturer.media.translation.updatedAt`, `product_manufacturer.media.translation.mediaId`, `product_manufacturer.media.translation.languageId`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` 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 `media` `product_manufacturer.media` ON `product_manufacturer`.`media_id` = `product_manufacturer.media`.`id` LEFT JOIN (SELECT `product_manufacturer.media.translation`.media_id, `product_manufacturer.media.translation`.title as `product_manufacturer.media.translation.title`, `product_manufacturer.media.translation`.alt as `product_manufacturer.media.translation.alt`, `product_manufacturer.media.translation`.custom_fields as `product_manufacturer.media.translation.customFields`, `product_manufacturer.media.translation`.created_at as `product_manufacturer.media.translation.createdAt`, `product_manufacturer.media.translation`.updated_at as `product_manufacturer.media.translation.updatedAt`, `product_manufacturer.media.translation`.media_id as `product_manufacturer.media.translation.mediaId`, `product_manufacturer.media.translation`.language_id as `product_manufacturer.media.translation.languageId` FROM `media_translation` `product_manufacturer.media.translation` WHERE `product_manufacturer.media.translation`.language_id = ?) `product_manufacturer.media.media_translation` ON `product_manufacturer.media.media_translation`.`media_id` = `product_manufacturer.media`.`id` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"Ø"Úðµô1a╦ã/;\x1A7n█" b"9\x0Föê\x18„…ˆ\x18\x13¨ätåÅŽ" b""" K½œ#è\x10¡\n )“WêL+”ÿ """ b"¿ëì49█fÔªp)@gÝ´┐" b"D½Îã‚ DÂK§G{3±b\e" b"…~¨ª'cÞ\x1C2öÄÓ·èµ" b"£å:\x18wí\x03¾åÚÛê•k\x00þ" b"q©$tµÄ\x1A@#0ùÜÖ6²ü" b"«ùÍA,¦xêë\f"<Q\x06Æ«" b"ÏŠ?Y«éP"\x11oZflƒgÿ" b"÷ˆ3´\Fó-Y" 6°`b " b"ëä¬!%\x06\x10PêoOaÐÿÁÝ" b"O\x0Eh´\x7FDYl\x1Dl&‚}g³&" b"oøº¶Ö®\x1CÈî,\r\x16°V \e" b"¶6´P\x06ôìõÂ$\fEYý╝½" b"ó,"ÊÂó\x05ÄCÒúÉ\x03V\x08Ì" b"¥ì¹°]─1ÎÛ┐Èx\x1EʽÞ" b"┘\x084Mü╚0\x101E─ƒÇ\x03:Ã" b"Û\x1C‡@-þµÝ\x00¯E˜Ð¢Wº" b"äÚ;\x7F»Î#E×w+\x06t£\x18Õ" b"db3\x1AiÍÇ·mÈ\x116Ê'\x13Ý" b"\x10Ð0|\x11QCëä!&9qu\x1A " b"jÞe•+>†Þu†]1tž;u" b"åL¢\n\x00¸.‘ãÁõq\x06¼‡Î" b"Æ╚\x7FÆë'ü/\x15ê¡Å\x1FÝÍË" b"AY"\x16ÿÎ]vXÞÚ\e~¡I©" b"–È4\x17‘Y›×\x05¥\x16–² \x05" b"åÚ\x13hPúÆN§ùd~atR7" b"ÞL\x01iæ”Oý\g$^Ò|(U" b"Ø\x08E»\x7FË_½”×\x02‹òãE\t" b""" 6$\n └╝'ìí\x10:>§.¾°A """ b"ÁÌ$öâf¡18©ÅSÉ¿ªH" b"–Ž\x12äË°\x08#¥Vû^ñZÛs" b"©S─Ã\x1A©3²NØ┼Y1Øu\x15" b"ä\x10\x0EŽ¹È\tÝN¸ÐT^˜ÞH" b"─uFü=¨Süñ@\x1D¾I Õ|" b"¦y8ž¹—ž\x15òõåÆHTèJ" b"'6\x11\x01§O\x1E߈$ñPÐ;Vž" b"#¶Þwh\x16^ù¦‡˜‡±ç\t´" b"L■>í\x07±iü├åÒ&ù\x7FÚ~" b"9^"â\x16Áv–¸—<Â,ßÿ\x01" b"^─Åc░║#¨,Å·îé\x12s¨" b"4║╩@ì*\x10ÊhÑÉ[ú&aG" b"'HY[\x07‡Í"žÕ)v“nÌS" b"™\x14´¡dSK|Õ©8^£k°ù" b";$°\x05põa<Èpnã—°À" b"Ål©&sÏ~\x7Fñ\x11{×q┌█Y" b"¢”È\f>íåñL–éu6ï\x08\x0E" b""ðÑÛŠKÿáʤQm9\x15ˆ¥" b""" è{*Ùs\x02ŽU\n Ó\ezAÓ-ñ """ b"ˆö\x01…P$7Ö\edʤÈàRÀ" b"ÝÙ<¹ÀN…XÀ¤Û{ÅHíL" b"\vr$ÿ°çk`(\x12âx™Æß\x7F" b"øŸ…i(Qö|¥úþ¼"S[ö" b"¿ya/8û‡#‚Ý‚tŸï\\x07" b"myé\eý\tvv™\x05\x1E¤£€QÃ" b"\x0Fߎæñ˜\x17d\x1Dý¹\x18Åí\r§" b"▒ää\x03iiÅ|7ÓÆ\tC×åã" b"\ewf:Õ}hüe#í¶…\x18G\x19" b"\x01ÅÖ ╣Ûwøä¦(\x1E\x04\x16ïI" b"ÊÉ‘ÌGõÈs\x04d\x7Fm†ºM‹" b"‘H#„Ñ\x12ð¼PÿŠ‚W\x06×\x0F" b"┬wØþ\x1E╣ æüÛ(æÚ;╬" b""" ÜÕõ\r"\n ú²¯Ÿ·2Ý›¿ """ b"Í•nt,Wöô1„ßÌ/e«Î" b"`ˆ\x18$•\x143l\x0Eë\x06t{´>" b"~æq\x00ï\v\rX:P9^¯?2…" b">ï¹èļ\x10ªwú`Hg-\x03ª" b"=7\x06'\v¸V±Á·\x11ïÓ^\x08*" b"ËÃ\x1F\x02 0ÍK©Í#hÌzÌÝ" b"ûYJY¥)ìP†\x05gèë[_é" b"ÙxãSðßO$\x04Sáór|˜§" b"¢Â\x1D\x10–XáY\x1Dã‘\x03Ô{¯" b"@ùSafç*ØäAYÇûuW\e" b"\x01m\x08]¥áaG¢°Û…µZß" b"╦│Û~ú├─"\\x13Êà¨NüÈ" b"j´(³\x16±Å\fjÚïÝQŠý\x00" b"\x06S>‡Œ\x07ïÕ\e#Ï4RÛle" b"\x08†Ž¢˜~ü)V«„.\x01ÅÒú" b"~÷\x02†ÏkéÎ\x1Džþÿ®¿ºG" b"…Ÿðzó]@¤é63]b¼²" b"ÄÊB8 ¹#‚\rÌPšou„›" b""" _QfÁñ7WÇ.\n ¶\x05ÊC p """ b"Âø\vÑ\x13¨‚žén·E|dI;" b"J¤\x7FÎ%Åt‰31´5ýÝì×" b"uk>*ïö‘·ÖtÚb•)•\x18" b"EÄŒÎ.-\x7F½ê\x1AüQÇÆ&" b"\x02q[&Kæ2\r\t ú*„\x1EeQ" b"VÙ¹┘Åƨ\x07\x04¾è\x00¥@B\x0E" b"\x14Jò¹j4ÿB´x65ûâci" b"t\x07¨§Ód?\x03Ò:}_\e\x1F\x0E\x00" b"Éí¾§BÓÚ^B¨\x10X\rÞ╗[" b"äÎ"˜[þ\f¨\vÔ\tçî ý" b"…\x02\x01<èE˜J\r#\x0F\æÜWl" b"È\x1Dî┘Å\x00▓\x04ÚÇ\tÿý°B~" b"\x00~\x03µ\f¢Ý\x06Ïî\Š*»ü•" b"ïâ>&U\x0EW«\x1A2;ÞÆ~\x0E÷" b"š)Å'saæ»–žÅÛ¼aû¢" b"ü\x17ºy‹çq¦]¤P€ô†Ã‡" b"Ò‰SÜX;ÛÈì€:Ò9Bi¼" b""" u\e├¬Õ¡¸▓É%×\n ¢õV """ b"ú$m\x02bÃ’V\x17°Ç+²\x0Eë\x1D" b"^Š\x19¹ó[4 ”¢5¾s\x031Ý" b"\x17ÙÏò¬¡KVQþlq\x19Kî" b"│U\x06Ȥ*ì│üX╚├\º2v" b"Áé\x16£_¬‹80ò-èëØðÙ" b"ªØ®ráÇ┬\f«¯èc!ä<Ë" b"\e³S¡ÏÒ¯álÚF;\x07\x1F-ƒ" b"\x16\x04ÜÒUM║&n³╔ø╠<Pü" b"Ôsµ\t\t\x0FÔã\x1E_¦snþ½ï" b"Ѐ‹\x1C7°Ìó:"øȯÃÅ¢" b"骾\rwÕbº\x12+6'#•ng" b"\x11ú0\x16Îö{2暨1’œÊ" b"hj\x08ÐûرGü>ª\x18╦╬v¥" b"\x15ÕÖÔ ïÝá¿:QîÆœ—J" b"\fE©\x01C\x0E-UOS:6ÞR´Ê" b"\x11:€%žê-«ì´ñÓ_Z¯¸" b"2¸Ø?A\x1EÏ\r6 …\rÑÔDª" b"ÈÕ4Ô0§Ä\x14°Y“d¾ØíQ" b""" ¯þßµÅ╚ÕÓ\x1CÆ8òßW\n ¤ """ b"¢òõ`è\x19Ÿ!5ò À\x1AøtJ" b"oÈijDXüÜA%1M║Ø╩Ê" b"ËNù®\x00±‰@d^Iª[–‰Ä" b"\r†K\x0E÷ö o\x14j»Î³Òø\x1A" b"░ÕÈ?ô│U²\x0E¢Å:KåÑ" b"ª\x00³hg`ýñõ@¾l3fb–" b"\x1Ea=Í\x06±û˜.mq^¨ßW" b"ú?Ë›~â\x1DaBiB¹j®3é" b"áøÕé¯}¶ª¶\x157P\x11\x119ü" ] |
||||||||||||||||||||||||||||||
|
1.80 ms (7.42%) |
8 |
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`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `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` `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"üƒFÕ,%v:U╠d$"dC\x17" ] |
||||||||||||||||||||||||||||||
|
0.98 ms (4.02%) |
1 |
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`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` 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`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` 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ï\x1Ed╗¼yÅûO¹\x0E\x07E\x04ï" b"\x01‹\x1E„¥ðqï¿Ùÿ.‘~&ñ" b"\x01‹\x1E…F'}@§\x13kßeíI½" b"\x01‹\x1E…¸àr©œ8ßDsMŽ" ] |
||||||||||||||||||||||||||||||
|
0.68 ms (2.81%) |
1 |
SELECT `product_highlight`.`id` FROM `product_highlight` WHERE ((`product_highlight`.`product_stream_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND `product_highlight`.`active` = ?)) ORDER BY `product_highlight`.`position` ASC LIMIT 5
Parameters:
[ b"\x00=å’\x17*PX&\ft— qƒì" b"\x00D\taŠ\x02\x17˜ÃTÂM$Ï\x16#" b"\x00F,\x7F8˜\\x16m+\vŸ-Ôª`" b"\x00f?ô¯=Éô\v\vZ‡0\x15Bó" b"\x00hU:4sÎ¥¶ãÚ¨rõªW" b"\x00±±i="@…“\x0EÑ\n|/ST" b"\x00¿~\x19\x08ÔÉ6i•&\x14Ï2êf" b"\x00Ø\x16ø6õ/³\x10P‡»eû…ä" b"\x01ŠJÈ´?{\x17½çReé‘\x175" b"\x01‹C\x13‚PyX²åêÄ\x1F\x15\x18\f" b"\x01ïF¹[Éxñ¬\x10ëe®\x13`\x11" b"\x01ïýÉ\e¶tÛبSq\r┴\n" b"\x01Œ9§n'}ùª$_å\x02ìŃ" b"\x01ÅdIÂY²VÔÙoX¯Ëa>" b"\x01Ö\x1F?\x19UF´Ø®¾▓òîBô" b"\x01¡šPÅ7v\x0E<\x15\x1Ea|‚ó•" b"\x01¬2╦ƒWjgÅþ-²▄¥\x01Ó" b"\x01\x01qw*̲ç³\e6á«}’" b"\x01½æŒÝq¦¢\x04(r”]¹NU" b"\x01ÀAeÍ`x\x1F\x10Ôү߾‹ÿ" b"\x02H{ÍÙÖõOI?"Ã\x1Eº¥ö" b"\x02zŸ×ÂGì0Ök0ºJ\x01{S" b"\x02‚´±Þ¹Í=EÄæ\eU¨K\x08" b"\x02Á\x06ÂdÌ›Ó\x15/2âã9P\x1A" b""" \x02ЊԖî\n 90\x0F=¨£\x04\x19Ò """ b"\x02Ô·i\r\x06ÛöSP¸Éàí‗3" b""" \x03C5\n å¯WFçÙ;dD\vÝÄ """ b"\x03ñüÀ/Z\x19úhn\x13ÔÜóà└" b"\x03ÓyâXòÂ6-\x04vwØæ\x10_" b"\x03ä\x00»<ôhŠš\x1A‡\x13=#ñK" b"\x04\x19ry6£1|RsFÞ·" b"\x04k}ÔµQ²)taµ K#Г" b"\x04¤oô±vÇWÀÙ¸òo0ü†" b"\x04² ˆRrîè\x00…Î\tQ\x10Jã" b"\x05\x05â$\x1C®¢¦è‘"Km¦>‘" b"\x05\x13LÒ¨\x06YJM¸NN\x1AL\x00¦" b"\x05Q”Ì_v\x06˜ËÈ\x1AÒ³l‹W" b"\x05c2·È©ˆ9kPC\x1E\x16‰ìÍ" b"\x05ûÅ~\x00Jýâã_ÛîH3©2" b"\x06Gù╚Ø\x16qh.èv█JæY¸" b"\x06H–§hqGA£*\x19\x12FÒMC" b"\x06mr¡\e%.d\x16\x16¾kð$ñÂ" b"\x07Z½\,U#|à;']ê´ ¯" b"\x07ha\x18Ÿ¸#h4èæorºxr" b"\x07ö§¥ô\x04ëÊù╩╝\x05ì`Ñ`" b"\x07Ó𘤳^] ýŸž©¥}0" b"\x07Ú▀‗oË\eÁ)ì\└ƒ▒+¥" b"\x08mðĹÿV³\x07JÓ¤\x02B†P" b"\x08ïj╗┘▀dLò╠~í¹¤ïØ" b"\x08Ü|Õ¹ÓØhGí┴ır$jF" b"\t1óO\x1C?\x01pD|ÏÄGÑ4Ø" b"\tt\x11\x08Ô\x13\x11ü#\x1CÄÈ-m" b"\tÕLi9¬«‡\x1D3i‰=*Ü3" b"\tÛÚÊy¨%S’’\x19\x19À4\x04Ô" b"\t V@Kñ«ºØ\x03e6▄Ìí5" b""" \n ^íƒ\x18ô\x13Ic1dGAO’q """ b""" \n }Uq\x0F^ëiï™|\x146l(ú """ b""" \n žÅïJIÖþ¶I\x18Ð@ø\x12 """ b"\nÌU\x1F3f¢„¤4‚K\x00ŽWô" b""" \n Ù\x17.æ$(!¦±rµ%\x1C¹b """ b"\v$¾rªÅ\x17¤„§=xê”>¸" b"\vHÐØž\x1EÞäèv‘‘¦)®ñ" b"\vô±\x134B\f¿ j5-d½~0" b""" \f34\r\n ®ı\x18\x18üÇ¢╦\x13B\x12 """ b"\fs>ÂLiÁû\f¢▀Å╗┤ƒC" b"\fçÄÛ=udŠvF;ƒBjh–" b"\r\x00utŽ\n\x11—û!QÓ©<r\x00" b"\r\x0E×·\x1Ev┌á1UìôúZª═" b"\rJv9QÊ;²íB0cŸi•\x18" b"\rKÜY;Ð\x01apè´®\x0E\x10ûÛ" b"\rMÔÚ§ÍæE\x16q\x08y7³ƒ‹" b""" \x0E\n NƒÃ\x17\ržu\fŸ1’aü """ b"\x0E%3—ú\x1Aµ´\x06âc\x08_F`ª" b"\x0EhÚ%\x00›yÑ\x02\x17Ñà*ßët" b"\x0E‘æ_K\x16cB{!᎑TT‡" b"\x0E╠ü▒\x08éÐ─P╬¿Í(\f" b"\x0Eèõ¼¿\x15\x02å¡éégÜ" b""" \x0FH‡Ä\x11¤ZZ¿\n $W|·@à """ b"\x0FPÞˆÿ1õu•§a/Ç%‹\x12" b"\x0F„¢Ø"H\x10\x1F’¤‘ürý‰=" b""" \x0FëÅ÷é▓®&_A\n \x1DDÆ┌╝ """ b"\x0Fæ+\v├§╠ØUÜKÀ¹┌u╣" b"\x0FÆïØ░ÌË«─F1J$1╗£" b"\x0FýËЄ\x1Dý\x05\x02˧è>žwj" b"\x10\x07C\x05#–ê{彧ãp1KÏ" b"\x10"+¥DýÒ‡üÆ\x05±tJqæ" b"\x10*ƒù┘±SÂÅ*½¾ËÁÁÅ" b"\x10n‡\x07À3<‚¼ö±¯šcc\t" b"\x10€Î7ü23¨Í9£L\x15c7:" b"\x11ƒ'|Ì\x17\x1Cgø]Zå\eï˜ï" b"\x11Œq6Ø*'\x00ù@³\x0EñK\x00©" b"\x11ð■¼³;*ÿüx¤Õ▓å ┌" b"\x12\x01VJDÏ\x1CK¤÷é:9G=\x16" b"\x12M§½ûHs_¼ü!‹\x10S¼Z" b"\x12NíuU>\x01ÀÞ±u\x08±X4É" b"\x12•]õ)«\x10¬yÔ»Éð}$ " b"\x12˜¨" gå\¸\x03—zÅÌ•¶" b"\x12°\x19Ì•\x00ĵÜÄF,UÅV" b"\x12 Ñ\x15ëD©q#É[│WNMK" b"\x13@ý╣^k)5Q║çþÅ\x12E`" b"\x14\x02¶ˆk;3©…å\x18þU*ž " b"\x14•×\x12\x1A¿\x08<[Ì&j\x07/x’" b"\x14ôQxœn‰\x02M¥‘\x06ì‰(\x12" b"\x15\x03ŽÈ’\x1C`4$¼©R\x1AjÌi" b"\x15»ÌÐDoµ\x10╬Øø1▄░a┐" b"\x16\x01÷Õ=XÐÊžj5YÅåv\x00" b"\x16\x1D·ÖQGÕs\x19*ˆåä%X·" b"\x161Ïé_^Ìû\x0E÷óÌ$n«U" b"\x16D@•\x08¼±tAqd`éßœ" b"\x16░\x0EìéM¥\@÷gdóÌ\x03ô" b"\x16ÄøÎîìªÜ“&I¼?á\x1Dó" b"\x16Æž¥”Ÿ°oÑjÞâJý\x07\x18" b"\x16ó\t)h¾äÙµp]»ÿb¦!" b"\x17\t\x12;©*Æ|°®r.+uŸ–" b"\x17.\x04Ó´qìí<Ð\x16Âë¶ÙÎ" b"\x17A^‡6™a\x16yÏ8{£[\x04a" b"\x17d\x06eÒLî‘Ö\x08\x1C—\x16¸òù" b"\x17eúXr’®–3¬^Üs—Å" b"\x18\x07Ôáßë±i·7zÓŒÿ8f" b"\x18\eÉþ!\x0EÀÒeHÀÍ<Í2Ž" b"\x18e]¿ê³o\x06\eÐQœùÔ_ˆ" b"\x18ºåT0\x13ê2"Áü\x07Nua" b"\x18òF¶\x12tŒR\x07Å6uÿRëÛ" b"\x18õõ˜óì}_UÎeÀ\t\rWÄ" b""" \x19/‹u\x03=ô\n °\x08dÄ´ÇÑ+ """ b"\x19=ô\x07É>Vüëz‚"‹méU" b"\x19CîfØ#òã:\x04Ð Ó\x02╗Q" b"\x19T\x03É«1(¿k\r‹J\x10ë.i" b"\x19î´&íW0\r¬¨ìA(\x07\x11º" b"\x19¥¯mô\x11À\x1Cax³cW£V™" b"\x19¬¢Œ„mJ°e8{‚\x1D÷øì" b"\x19®^\f7\¢›~\f\x1D;\x07'¸"" b"\x19Ìú:Ôåª ö_QI÷\rÂf" b"\x19æ=B{Á¬Bµ\x03Ø\x06š£Ë_" b"\x1A5¤Ûý|q\x03AØ1ÜzÕ©" b"\x1A®“`á\x0F\ef™wîüܲk" b"\x1A┌Sƒgk:`?\x0F╠:|ÅÀg" b"\es\x1EƒMÀ¹Ã\x1AÉd┴ý\x07\x18¾" b"\x1C \x04?7¦ËÙ(Á\f%\v\x00\x1A?" b"\x1C-Q…ˆú¡„î{\x17O\Oíž" b"\x1C?\x1D\x13º·ZÉ[eí\x15£2¿©" b"\x1CWßöfDìð\x1A7Ï'ËÎe¢" b"\x1CÂí|râ9›Ht&„\x12\x12.\" b"\x1CË\x1C▄DÎ\vÉ\x04ÍóÄý:a!" b"\x1Cî1(\x7FÁ”°1Ì£zñ[»ß" b"\x1D]ð¥=m\x1E\x0EÃóÒ+CÖ>)" b"\x1DÇJÒ╠Ø\t\x05i█┌¦\x1F+|" b"\x1D»”Bùq*³›Â‰IÊ „(" b"\x1DÂk»£®Œ+1 ðw;kLm" b"\x1Dȹ\x00\f\x0E°>AR\x0EŠH\nÈø" b"\x1E'\x11o]└zü?╣:Üõgº^" b"\x1Ek\x13\\x06ø$<^_Â_YOx]" b"\x1Eè\x11«gÅ\x1AV½\x04lÃ▒Ûy\x08" b"\x1EÀŠ¶\x11eQ[Gî\x10ý)Y¡/" b"\x1EÂz·\x16EN¯µtä/ï&–" b"\x1F\fV«h\x00i7┴\x08$;edÀÅ" b""" \x1F ÷´\n \x05S‡ÊqY¥ùá1Ì """ b"\x1Fð tðPÛì1<€\x12(³\rU" b""" \n ºP‘\x0Eωæ²ÔâtÑ\x1EZ """ b" )"É´‚™þ\fb‘~qL¾…" b" >»°éüæú█┐╩5Yı5X" b"!\x10ä:þ\x19ê¸$óS¾”¢vs" b"!<ƳAã%À·„»ag²[\x05" b""*6\x0Eo\x1E–©ÄµÜ¦ß<¼ó" b""úq¬A\t$I2³ÆØ├uý╗" b""" "╩³=▀Í╔ü,\n zÿ\x1F\N─ """ b"#4\x04t½9³V\x16Õ¦IÞBɬ" b"#„ó\x7FÇ)ÅÍlî\x02¶ÕëÒc" b"#Î×ÂËÙ¢—d\x11w«¤íŸ" b"#¦É\x13sq4î<╝6\tÔ■Þ\x1E" b"$(n~\x186X"‹žáüüX»\x14" b"$¼U‹]\x0Eï¡ÐgSŽÁ\x12K¦" b"$¢Ç,\x1FE\x1Fe%é|à═Ø\x14Ì" b"$▄aXÏ░ßØg$ñKÒ\x12Æd" b"$÷0ö\x05\f\x06§ºèYÁäIþf" b"%"´>™yÝvÚ(Ú\x02\x14n\x19ç" b"%úab¹†\x08ù‰ýøªìý\x05~" b"%þì\x1F§£%§•µ`-q\x04\x045" b"&¡áŒ$1ÛaMÜ4F\x1EéOŸ" b"&°CcÝÿŠMb‰Ô9}nµ\x16" b"'X§\tuJ?¢\x1D!\x19¢{‹\x00¯" b"'mÞ\x03\x17“ÙÔ\x0F\x1CÃ,PÌ`?" b"'–N@‡5:,ßHòéµò—3" b"'¢×Zö\x15Q\x7F0`xS\x14ú¾‚" b"'½ƒ•|ØÖƒö»q¸vÓ°±" b""" (\n â\e\x17ôu‡É‰0wFÕþ """ b"(ža¼"kæŒr$éŠV8—ö" b"(¯zJ\x0EÛºå█´ü▄|CE£" b"(õëÖ¦³î=~Ôs\x17¹U>±" b"(ýF$–†{çs§\x17Œ5TèÇ" b")+)§\x1EÕzòY\x1F}ÜÊļW" b")‡\x02ñ»ÓÕj/]˜U‹ßVx" b"*\x00├\x02®¦Ó¤▄\x16üåG,╔O" b"*\x07ÖdÖi¤f]PK¹›½\eÀ" b"*/\x11€L^ìrJÍ\x1A\x7FŸ%[ì" b"*BU\x03ålz"Ö\x14§\x04\x1Ax„Þ" b"*»#oÈàk\x15ê§\x1F—g\t\x7F±" b"+ \x7FÂÍ\x19ÚîÍ\x13D÷édÛ×" b"+-l–åŠ\x1Cªµ=/›‹;oi" b"+]Né>ç²\x0Eº\x10J6ë" b"+f\x1AÏz·\x08‰]Uƒ¡U¡iû" b"+Æ┐¬;p6[§┴¸ÇØ░ɦ" b"+žm\x06zÍ›óßÎôâ5Ñܤ" b"+²’ZÙŸ\x18\x14¢á\x108LÉ_k" b"+À\x1Eb»ô▀~K!%▓áü`a" b"+Ë:Ž\x19\x00ƒ“ W\x12ƒ²GöÂ" b"+ßD”&„`Õä\x12\x1F¸¨\x11\x1Ad" b"+ç°Éª£Ô\âdz4C>\f´" b",¸âcâˆuúWQçzÿopØ" b",º\x14r¨-îJ\x003\äpĘ\x10" b",Û/\x1D\x1E\x10\x11\x03€œˆGjâ\x01¼" b",Þ°òÒ1╬ɧ┐sFå┤>[" b"-\x05ì§ì└\x03´Å\=▄┘▒■*" b"-\x1F¥e\x14u\x07\x12\x02ú›TÎ\x04Þ=" b"-ØfùÚr{gãZÓ\x17Ç…š\t" b".š\x07HtczæàØÄ–L5ƒ\x07" b".ãCÄÈç¦à,¹¨¦¦Ð;I" b".ú\e\t|·½±’\x15¶>Ux\r{" b"/\x18,«ÊGêIú\x1AqgÑÐZ~" b"/O:\x01ýÁºë~XŒp/\\x0Eö" b"/k\x1Dˆ\x17…Ÿ:ö=t\x11Â…½ˆ" b"/~T\*ÁX®”é˜APìùÈ" b"/æV¶U&û2pÉTîÙê\x18ö" b"/ô\tX\x07™!d\x04“©\tÞ7µE" b"0\x03çz; yàÚHO¼;°é=" b"0"RÍ•çÒIfÛ8Ú(žYú" b"0<΢ÿnDØ*Ø¢Tƒ\vE\x18" b"0b²æâ\x01ššˆ+žôo?ÿ\n" b"0Ø£\t²÷L¯À\x11çÚùÁñg" b"0úIbu\x00ôð?7#‡[IgG" b"1T\x06;Ša78ûÉÕ9â\x1E\x0E*" b"1lyS8\x17·\¨íßÈ·\x01o\n" b"1uw\tþ\tý~‰€ða[ìƒ\x07" b"1ŽÑ¹!Èøœ\x1DôäÔÐŒl!" b"1ø÷ì\x01pN __╔ÃíÚ├Ð" b"1ÖÎ2Zlã\x14èŸB®ót“R" b"1×gê¬ÃËûíˆ:Q\x1AH\x1E„" b"2\x03ÑÍq~³³µ\x10‹.œó\x018" b"2>I_õ@Pò\x00jô¢“_V]" b"2Mt!q┌â!R\x03÷O\x05pØ\x1C" b"2q§•YH\f0÷M»\x17WÛ\x11˜" b"2‘J*\x03ñ_ö@ˆ53\x16`‘B" b"2┼ı5CÒÌ\x1EäSÁÁ\x17ìÑÄ" b"2Ö•’ÒÖt\x1F\x1FÑ9¯[ò\x1D»" b"2ÜÄT\x0E<5ˆÝê—?,\x10¨'" b"3-èK\n̸Ž6–·)ë–\x00\x1E" b"32¹¬\x148\v©┘\fK£\ru¾ì" b"3~ï_hÏi?Ï"oÎ\x14+«" b"3‹ªÝ¬w\x00ÜtC.¼F™6\x19" b"4\x00X2üwÏ´u\x1A╗<íh■â" b"4=Ñ,¿¤jW¬Ç¤\fÎðÅ!" b""" 4ßrÿÜíf!ÒÉ\x11\n │VF& """ b"5\x11IkOubðAb¡\x13®ç\x10A" b"55\x14CÒv\x06\x03kØ\x7FÅ,[{u" b"5l{ ›…”fN\r+[°ùC›" b"5å\x1F\tƒ*ÃÚQ.═«■íÎØ" b"5î\t2¾¼(c7\x18g°wfŠç" b"6&ü8À&*¢ƒ‘\x0Fµü4ê€" b"6y3`\favѲø¿\x0F¡\x00Ï\x0F" b"6ÆÉî“Ò\x11”RÓ2ä4Öó«" b"7\x10g═\x19[H9L }È■Ë É" b"7GÅ\x1Co³`‘I7ëcP”\v\r" b"7s@T®pÚ9/\x0F[—w‡ú‹" b"7xJ\x14ó\x15Ãu;\x08\x075B2Ù" b"7‚AÏÎ.NIØ™_©á\þ/" b"7––°?v–\x16ùøƒV~ã¡\x05" b"7Ù6ËÏb¦\x1C¥í\x07²ÕÛU" b"7ò"è]\x17 ?OÜÍ\x1A‹F|š" b"8\v"9DÔ:½î\x07eR)£‚z" b"8\x1D\x0F\x01\x16$þJ▒\x1EK┬ÅÀ}|" b"8üiµQñ╔ûú┤ùâBî╝:" b"8Âà?Qãpü+ÈGÛ«e÷c" b"8ç†)‘QÒ¿N{\x00ÝK[G-" b"9\rþƒ‰(ßÚ¯õÿ¨v&\t¸" b"979saœÔ¥!òtù(£0À" b"9\QpÕ -›vé\r8Xó\e§" b"9™¸\e\r×ó\x16TÎ\x18ìʈÎ" b"9šyˆ\rU,Y̸”ë8E³\x1A" b":&DèçŸKü¾\x08\x05Õ%¡8Ü" b":cÎ\x19\x19Å#UÙ¿2P“\x04¼ê" b":n\x0EHî¿ö”\x05¦¢'¯em’" b":nb%B═èÔÖ³\x197üíxÒ" b":s\x12×V\r`>AÑ\r8ýºÀZ" b":Æ\x1C§\x1C▄«T½É#F¦ì┘" b";\x0F1\x04¡ª~yËcù\x14¡‹“o" b";th“<…¦¢@\x0F$\rÅ\x14‘—" b";xÅ\x10b.\vÝd╦¶4sƒë" b";zC}8¤7팸\x08©\vWÄš" b";Å·ôáÙ¡Ø<§BÕª╚└S" b";žHF»çqï)‹ØëåÏ™Þ" b";Œ´U*Ìf\x04pn‰ûݼ" b""" ;Öa)BpGí\n ä\x08ÇÀxvÕ """ b"<-rÑbJºýZu\x11+1ñß\x03" b"<2hg.┬]Åö©cC)u─ò" b"<T \x7F\x1F±PõÃJvUB¥Æß" b"<▓\x15Õ┼ÉÔr\r▒)ñ\x10Ïàï" b"<º£ySr@ˆÎCCµšáäÝ" b"<ÚUYxW¬+òR\x07:_F(²" b"=\t›qÒ;/ðãüG…~,\x08A" b"=\x0F\fTÚyÌ4¡\tYÂ}ļo" b"=-cósÈÿ\x12\x10ÛoÑ\x1A¿Hv" b"=U:¾,éK\x19\x18ï\ù¡!Ot" b"=zlblî²þ3┴KØ┌ªÆÕ" b"=~\x1E@7\x15Bô\x13ah aW\x02÷" b"=¯}'ô^§`µê~¯(ÿs" b"=ÛýHN2lÄì–¨\x02ð胆" b"=ì=pÚ{}J]|õ†AÈ\r\x15" b""" >8å\x14Þª×\n Ò^ŸÛ–û‰ú """ b""" >ÑIªóE@PÈð,®\n yß\x14 """ b"?4'\x01Éñ\x17u0Èy!ÒÇÉ÷" b""" ?^\n ýSð\x121º%ŸÄI(&\x0E """ b"?ÍDõÑ\x11\rk\tË\x11ŽNG{Ÿ" b"?×íœNqÅtÏ\v\x00®Ð\eyÄ" b"@\x0Eò™\x1CŠ\x01brìíû?\e²—" b"@?“ŒÀo£†ú·ô2›§7_" b"@b╔\x0E¯K&q\x17ü9\x04Ï▄}\x07" b"@h«ë¤„\x17e7S\x05\x15vr0›" b"@‡†\x19ó€©\x0F£ÒL´)O¶µ" b"@ž_³®ØåŠÖS+Ù[êŠÖ" b"@×pù╔Zûıº@¦ÅUÉ Z" b"@ÈbÚß%¶Ñǯ!·»\x1F\x1C\x15" b"@ö0E\x02ôÜ*¢ágÕ´A‘Ð" b"A\x1C┐\f]\x00╣×\x10▓ðÉ\x19▀O;" b"AC·kOÌQØ:͵ÑÞ²y°" b"A³è¿#»úçF©Y\e—r\x01Ñ" b"Aı▒\x08Õ\x03?\x161Åè\x01IÄ8X" b"Bb¸-\x19¶ÑëÅA¤ÄOz(÷" b"Br¾\x02\x19\x14:bêí‚×:Á-\x00" b"B¼D\x05BjÌÚ©’ªøpƒ¿Ö" b"Bð[ IÄü׺à.çqM“ò" b"C║Ì.\x00ı\x07╠╚É\x07Õf\x190" b"CÈF`■8Ø3÷|)\x14╝zåÅ" b"D"SÃ\x05…ÍÂDýgRq\x05\x1Aò" b"D'åƒ{ .æØ\x12 A╣\x04R6" b"D)Ôô€2Ž?1t4Þ\x04ñ)ñ" b""" D6¯EÝ\x03Å`+╝ýN\n \x01ᣠ""" b"DKŠ8?(„\ž·´jn8å¦" b"DTl1åëU\x0F\x00š‰}Å\x08§E" b"Dj\x03±îX\x00¤\x10;ó9¶U€ð" b"E;\x10.ž$®´ôv™Ö\x1C„:ú" b"EBdþ)¯Ô‘ëµÞ[ÚŠÀK" b"EZ~\x16òŠ’·wU\x16 \x19Ê“" b"Eg0Û¤fži?‡(\x01Ãéüí" b"E¯ñIÒ\x031þ#ã•\x1D:ÏÝõ" b"F\x02ä\eÛ°\x05ÓWïoyÔGðÀ" b"F\f¾\x06É.¾\x1E\tŠ®\x1FÀŠ'¬" b"F›ì¿L\x14Ÿ\t\x1E\x12\x02²\x08#\x05W" b"Fª×q¹½üºdìS▓Â\x12Ö\x1F" b"FÄ…÷ÏÕbZˆ3´+Òö6´" b"FÍ\vë\x18┘ıØ$y.▀\x15û C" b"FÚ\x10ØöX6[))â┬\rNò¶" b"GZ³;\x19ð˜\x08Oä©úÏ nŒ" b"Go¾ö!†W±À—òBt2Š=" b"G‹dÑI!$Ñ\x13\x07Q¹÷\x1CÝ:" b"H\†\x01T%.[¦Ö|̺ª\x02P" b""" HkÒÉvÈ/I\n ¹ Ö¤Êl▒ """ b"Huõˆ›ˆÚ™Ž|î]‘qõ}" b"H‹\x1D$¹¢\x16î¨×AeÃu\x1DÄ" b"HÈ\x11m-´Î\x1D³Rýݲ¯›ç" b"Hʈ¼–À\x00Ô| Æ\x15ÝŸm±" b"Hòfv@è\x7FqCÈD2ÙV3\x1C" b"Hô`’.\x1A\x19\x01ï©v^!…\x00œ" b"I\x1EW_Eˆ`>Û5ÈjƯ ã" b"I5hùï\x05)NQ\x7F?ùwj=¯" b"InwŸ«Z¶»H\x17ÊÝÎÓRé" b"I¾»mÿıY┼Öú£É\x05HA9" b"Js–Ê4ÌN\x07ŸÈ6\x14¾’\tÑ" b"J±\x10Egšc§£3ÒÆ:Ý(å" b"J┐n╩ì}\x14ú\x17V\tv̼|Á" b"K\x17]¯▄¨░╚╬üÃJ¡]\x12¶" b"K\e0fpeÌq¦ƒ¨Œ¯Q\x10Í" b"KTõÊz\x1Aøàî0dü╦\x1A\eü" b"Kz¤¼LœcGÆœgFra'Ô" b"K‹Ë÷¼‘ÎCS\v\e…Š\x1Eì<" b"Kìó7ÖAÎ\x1F\x1Fu…<[3æÌ" b"L\x10À6«Î‘_;‹¹4÷4€y" b"L)ûͽ\x17IêTHˆ=aP.i" b"L÷\x05\x04\x7FrY\x04Î\x7F\eQõÕË4" b"M)¢É£/'òp═a\x08\x7F1U«" b"M4\x17žæ\x18ê“K[Úû]ÎbL" b"M}\x11ªÈ\x7FRbãf®/Åd‚!" b"M}aôPÍì©ÞäÊ┐╩r¬┬" b"M•¸<\x08YY=ñZÞ—\x19\)ê" b"MŸò\x0F®Ð¥ç-\x13®Ù·INs" b"MµJ±.4▀Ã\x11E(ØÔÞǦ" b"Mõݽ\x0E‰Ò”FE!¸øï )" b"N,\x1C\x00={µGÉ\?È\x14P»p" b"N?±Çn\x06\x14§BÚQ…\tlgR" b"NX8ó`EþËø\x1037ñ«ÒT" b"N\\t¡pBŒ²XŸýäœG–â" b"N_-*òNT»]ìƹWÞU\x10" b"N›\x11Á":ì\x10‚\x02\x15õÕãã" b"OZЪ§w–\tEÙ£üinôó" b"Onk<\x1DÓ£˜’}xT´ô\x12Ë" b"Oƒ.ÿä\x0E║\x19ø·\x1C\x1F¬]╩É" b"OªØ5÷\x17Y+Žîåz\r1\x14Õ" b"O┤#m▓Ç\f¹ FÈ7¤MxÅ" b"O¸g±\x1D\fÀh†á¶»˜’\x02P" b"P\x04b╔ù\x14}¤ü¡\x1CCôvgë" b""" Pk\x08cü)\x10g¥-‰\n ¦jÎ """ b"PmÁy!\x04ûÙäïPm›]\x01Õ" b"Pº\x1C´\x00\x05mı§7ü#vÕëÞ" b"P«ä×£Õù5÷(6ȱ |¯" b"Q•ß`9×A%¶lbuÓ:òÈ" b"QÇqž¿`º2\x02›îŠ*\rÎ\t" b"Q╚m\x1A║2W╚¹\x12v╬Kü┌3" b"Q╦Ì®\x08┬▒\tùì▄Ý hªý" b"R‹Î\x14žâáCcÓ'×n²Þë" b"RòD3¹K\tçx¨»i§\e|ø" b"Sˆ”ûn’Ù\x7F“—WÊqæ™ò" b"S \x06ìX\x15þÃ\x7FÍu\x0Fî\•\x11" b"S°╬9¢ì:}©╗▀¥¢ÓZK" b"T-ù‡ÿI\x16lGD7MxKŒ€" b"Tcc%°èëÇæÛ\Me22¨" b"Tú© n·%!¹ýô%\x1DâÁD" b"UvèÃ,m{OŒTøB5àà\x0E" b"UÀ<ŸO\x159Øs\«’M\›Œ" b"V\x1E¥³Á░Ê\x1EµØ\f\ftmµä" b"V.@WÈØß\x0F┼ǥ̸i]å" b"VWê\x1D{Ð\x19³£ƒ—ö‰°Ð\x12" b"Vô©\tüýW²O\x1D»«NÓr." b""" Vß\n “ÿrˆ¶‹iøÔ$\Rž """ b"VâEDqùrœ \tݺD\v×õ" b"Vþ>Ë.Ïš…\x01\tq¥_Ó\x03\x7F" b"W\x08$¡\e òÃ*\x1FAzld#ç" b"WRÐȦ¤tîÓ8Z\x15üh3" b"Wv’äJ¤\vÁêX/ƒ—Oã\x13" b"W£ o¹\x18çGðl&’ܥѷ" b"W▒\x13{¢\x17{h$î\x10E╬\x05\x1Eü" b"WÐÈ\x1Dô╗f¶/ŸÌj'╔9" b"WÞÔ\x088┼ßN\x1Cq3ıÉ┌╠ò" b"XAòÄHº!•ã<ˆïÕ´ìÒ" b"XN]╚\x01kfxÉ/\x14Ö\´Nõ" b"XÁœ9\x05.?\x1Eâ~3_C€\x08ä" b"XÙ«\x05û\x02¾»XÐé\x04Ë${\x14" b"XäQêjÁ\tûÞq#ÈóÓó\r" b"Xåà\x00Vû\x1E£\x00h·ntÄ>\x17" b"YTi#%¡DŠÞ¹9\x06nväQ" b"Y¯ý\x14_}¹LLUÊ\x1DSõ:h" b"YÃ9;Uk½X\x16ðÍ\x0FûÀ.\x00" b"YÝþ‡(\x1E^Äyªs\f»Gyu" b"Z\x15hÚ~ž\x7FÛ‰\r–PÂTÊç" b"ZU ‘–ð;¸´i4·V\x05‘ð" b"Z_‚Êh-â5Xò% \x10\x7Ft«" b"Zu°Û<êñÝõ9\x04§´ê&”" b"Z‡¹à\x08\x15!*Åô$(\x00Öze" b"Zù\x05\x08ÖVÔg¨Òh°3k§" b"[ƒ#=È\x0EW\x07û\x19-Œ?‡8\x7F" b"[ÃD@\x15Z&¶ÖóLÙ6üaß" b"[ç”ÕÊÏ\x1E\x02Lª&Î,\x1Cú˜" b"\Wp7é\x14\x02±fšš¬˜\vk‡" b"\ıA\x07uÎj\tÆ╬)§ì┤ÞJ" b"]\x19~N%ߨ\x1EÕ¬\x16~é,\x13š" b"]]cørØ®vÿ▒¡ë \x17\x13E" b"]½¡Ü§&Ãb9Úmåöm›™" b"^˜›.˜\x04\x19``Òá\x03î\x009µ" b"^░;ü▄Ê\x11¸ë5VLi\x169z" b"^ÉwÁKk\eùþnÍlÿ«Á˜" b"^±ÉÑ÷╝¦(\x00VaıK@\x1F\x14" b"^ö\x04v=¾Yâ£Ã‹Æêü\x16V" b"_\x0Fïz▓`ü\x051[,â¶@±Ñ" b"_&\x1FÂëÞj‗ü1\x14ñ\x15s&Ç" b"_R¨2<\fʀݮæ\x08`èNW" b"_Ž\x15ú™ÔÏ\x16[°rCܛߗ" b"_¢‡5\x1C{w•ç“°¦ËöJ-" b"_¢îGÌ“\x1C\eTró—ŒcVÄ" b"_┌\x7F‗\x02D¤!uVìo)`³\x01" b"`)þ¼\x07│@ûü=e»=xY\x03" b"`h■\x0F\x0FÉ\x14(3┐)\x06·Gñ█" b"`iªð¢qˆe8=Üì\x04Õ—½" b"a\x1A\x1AÑ>GKµ3]>;\x17Ò®¤" b"av\x1EVåÇyé#FvC«ò‰Ž" b"a àv ÅžíÿVD1k'p" b"a—Ê\x11À½]°\x02)î,w®\x18" b"aÝü\x1D\x13Î/ižÿK ÏÏ‹ù" b"b\x1D•\x19éóÄ—še¥»³’¸½" b"b¯%\x7F\x08\6Ýo\x1C¨═ô\x7Füç" b""" c\x06€ùM\n Ù´¾ÏîÜvþº, """ b"c\x15GW Èÿ×Ý\x18ÁlzD(D" b"c%\x06\x0E▒B\x07\x16>Xç'~\x1Dì " b"cȈHÃ\x13?ZÆî’ø{+ü\x1A" b"c°w!UiEW°gØz £M┼" b"d6Ëi¥²yí^Jöbâ+S\" b"dZnÞO-Ï╗\x174þà.┼ÐÅ" b"dy\x16)æ■Ñ·Ó0\x18╬░ɲ▒" b"dèhà3X\x03{9ØL■ì1\v█" b"d¹ÂháÛT\x04CÇ@2˜ÚÒ•" b"ePü¸Ìô3▄TD┘\vo÷ré" b"es9 ÓËòT\x069\f>izŸI" b"eôYhxå ?6Z\x1A¹\x1CÔgø" b"eøËpõqóÿKc§ãPò€Þ" b"f¢‡ßÁÆŽ\x00ð=ÞòY2¥‡" b"fê/E³’ås Ër;\x07\ri" b"fþ\x0E;Ú±¨í¸!¡ˆ_Îó¾" b"gAyç]\x1E›\fdÀ3*eA`â" b"gOæîÚéÚ\x11\x10Ô+Ì#=ñ\x1A" b"gžCÓ4ŽÀõ˹ÙÒ2¯ŒË" b"gäÙ\x05Å\x12ˆ\x06ÀÍ”$_ªœÈ" b"h\x13\x12<ˆ\x02\x03ÿÖ\x08dÆ\x15-—Ä" b"hZàâþå`»5¡²;N¥E¾" b"hlD¸Û<Á°hŸž½÷†½" b"iQ\x0Eª”\x06z¨ƒËŸ DÒÎñ" b"ix¼|»~qBæ¯T5IKƒ6" b"i¼mÛm¥\x137\x01-ëL\x154]l" b"j\x150»╝■'øQ\x07ìZö\x1E¥º" b"j\x19ÓÀ±‚mÔâ#¯RFF\x04Ý" b"j7\edvP©H±ƒÇ¤à\x12iá" b"j½˜*€æü\x14"}p]äÖ_\x1F" b"j┴tRrpÃ╔Í┌TÉ\f" b"jâÃ|BL` Á|~¹\x11ndØ" b"jÛ@¼Zù`\x01Xï÷\f¤ìÎc" b"k\x15]6Ô\x15\x19«¿Ÿ\e5/DÁã" b"k\x15»øáP┤OÝtýÈ¢³ØX" b"k*ÔŽÌüÂ\x08ÊÏÿµC\e\x10á" b"k3Ä^È…(äê \x11ºåÃøý" b"kI"ÄoñQ1ÝY^õ„yƒ" b"kU’ÅúF ÷ú¡ý©¨§\x18°" b"k_Ù\f;ãæÙۈɹ|ñ:Ð" b"ko²d;&\x12Rç¡G´\x19ê³c" b"k|`Ù╝qNÇı\rÔÅ╗÷í\x12" b"k├\x02 Mò!6ɸ±À*`\x11^" b""" kÚ\n \x0EùA\x02¥\x03æzjD\r>N """ b"kÛÚó7Ã\eqùÓ€Ð*„ëÈ" b"l\x1E¶ã¤\x04ù0\x17ê║pØ3+¶" b"ls\x0E¸y€¦Hö‡žÈ—Š#†" b"luæü7í¾\x12Ãø┘úl§\x05n" b"lˆ\x02¬<ˆì+Úø!Ì\x01êtc" b"løéÍy\fG£§\x7FØÆHNH»" b"m\x08\x173\x16×®+▄XÜ┤\x1FìX" b"mV_Ùš{“ÉŽñÿQ+?\x1A¢" b"mšÓº5MŠ25÷™ÍŸBoq" b"mØ‗\rûg\x1Fª6\x11î\f%╬╬8" b"mÀ\x1D5 BW\v█Øö[ï├ú╚" b"m·\x1Eèæ0©ð¯Òä웇" b"mß2Øèþ\x18Åȯ\x04÷þ±Ñ¾" b"n`Æ<‡ÅA\x14)¡W<\x10ʆð" b"nzK}\x08œ"àOm‚×^Ìb" b"nèzßiì²\x03Ü\x1D\x0FÈ\x1A\rý\x06" b"nÌ&¶├¸!═╝(\t×\x11%\fØ" b"o\x07>¾¹Ã9Â\x13\x04Ý«’ˆ7ÿ" b"o\fSkò¢þ£x‡\x11Àê\x17=\x0E" b""" o\rÑRFÑmi¤\n ÈÃ!ŠÚî """ b"oh¥Ž›\x16pzìO\x1FZxÒ%Ë" b"p\tŽ›Mu.—ÃØ[8\x13Üâô" b"p9ì.NðÔÕm·ã°©"ë" b"pEª×@¢,BUeb_›6Ðë" b"p«¥MßùÖ€¤`+\x01¶»ë‚" b"p©Ùü9fü*i|K®l\x19|ç" b""" pÌ?üì┤\x04ùi G\n Ô\v¤ """ b"pð¦RBâª\e\x0E„•þ\x10Üë€" b"p¾½¸\x1DP╝z'░├ü■h¿─" b"pÿ#€7ÔR³n.§îE9»s" b""" q\x10\n zjÙ¢k¿É┼4\x7FO\n ½ """ b"q-|Ç-\x1AQ;XÂX¸…ßüF" b""" q‚ìcÿ\n ¼e³Ð³hVs$‚ """ b"qÿD~t┼½┌ì2\x00╩├kM" b"qÅRQkœIH¨sï\x05Óhp<" b"qå)ý ^6ñoGÚ…ó]²M" b""" r\x07\n %|Ÿ0 …‰\x15Y}\n 50 """ b"r\x1C”ï¹;ȸâ9Í@Æ ¦\t" b"rLiu‹‡k-f"Þï\x0F©˜Ë" b"r‰™ç¥à’ö¸\x06\r¨ŸÅ†\x08" b"rÖ\x1F█mÞ║ÿÎ>╔É\x08\v┼a" b"rœàÿî%ñ™|`\x16ó¿ò\x1F9" b"r¿\x07\x19üÙP©n\x17ý4╔'ÝÝ" b"rê¯õ¡‡çº\x1D8Þª\x07–ÝÏ" b"s>1¡C\x18½1Ë2<Ÿ\eFåÓ" b"sHÂ+ÌÞ4 ò`ß¾ı?Ø}" b"sz_æv]‡¶<ÝÇ£‚\x15‰Œ" b""" s¤\x07d˜4$m\x17\n 0O;T¨ü """ b"s¥ýJûîŽVeü¢º®ÿ\x17!" b"s±áH|(³•%n)6«Il„" b"s¶ÐéY±þü¹RÌ#A8ÑS" b"s╬Q¡¯ÅùÏñº<ÔÓ¾Þ¥" b"síYèç}r&‘O*Ôñ]A" b"t\x08¦\x14æ†\x0Eø$\¹e\x02\x0EѪ" b"t\e=¤¦ ËP¸Ä ›*ô\x16½" b"taÒÿæ5Cm¡&†\v²OmB" b"t|W×P¢cÛób\x06`ìàw\x1E" b"t²¦¿Ø\x11\x1AÐü\x0E\x1Awá\x06]\x00" b"u\x07I\x04¦ÀtaÜ\eµ;<ÈGÙ" b"u‹™¸Ðc¾n\x03\x17QÒoC$ø" b"u╔▒¹mÉ\x14╝E‗─Ri┘‗²" b"uÙ&Àöœý»Ì1öPŒ¼\x03L" b"v\vÍìÎðy█C;\x17IV6Põ" b"v¦y¸L¤³õòr|Xû[Ò°" b""" w0y/ø2\x01Š.\x1Fª\n °ÉyC """ b"wÒì©┐Cufÿ×7\x0F\x13T▓▒" b"w‗Ñ5,9XÂü7╣»Î>e5" b"x\x13PcúÀ‚ãᆸìKÉ“×" b"x\x1C\x0F\x13©™Á×GÔ!˜ÿ\x16øÙ" b"x“®iÍ=¾E‹%óøؾׅ" b"xåGnõUd«|çü\x05é„" b"y¢¬\x1D‡TÝJl4ÁN>\x12~\x18" b"yýÖ×ç\x1AAÖ6ƒwšra\x12\x07" b"y■Ø╬Ohãå■j? ╔Og¹" b""" zR:íÿ£Â”^\n KAÐÎN½ """ b"zÎq‡,™(ƒfžþÒ¥ƒþ÷" b"zæ˜\f\x1D²õÑ\x04\x029¼£ëæ•" b"zè\x01ʸjkÛ\x19JO7{\ÀŠ" b""" zë^x°×áLš¯\n ˜Ð¿}Å """ b""" zûýãÙà\n Ð\x16®÷¿\x02kÕ2 """ b"{çµÝš}\x06HûÙ$ÿ\x16ø[s" b"{°ÿF%┐£\x00╗Ü\n├\x08\x1DÅU" b"|\v@î-\x06Þ╔╣)èrì2¤v" b"}\x11•’˳síÁ\x03L»ÿå÷5" b"}f…-f¥p\x11)™Ü\x11·T\x1D›" b"}ÇMºÓî\x04šFý¥bSjñ²" b"~b\ta\x15¼²ŽC\feìóþhê" b"~—m¡\x1C\x01šã2=)\x1F\x02hY\x01" b"~Á\x0E³Éû”œ¥t|\t\x0FHsŽ" b"\x7F\x03\x12?¶\x1A\x05š¢½s)²Ï¸ç" b"\x7F'UI¶é¶9NÙ†×t'Ü•" b"\x7FVÑ\x00Zñ®¶UhÛ.ò\x10á‡" b"\x7F`í\x0E|õ\x19´2¬~Ff½Su" b"\x7Fùß\\x10;Sù/ 4\x1D¶Á¨%" b"Ç\x06\x0E‗}pæ«\x1A[Ü╦Éö\x16╗" b"Ç\x19$²Éf ³\x1FcØ7/─éÁ" b"€¸ò.è\x06Í\e\x15\x04X‹¶(*û" b"€Ò}N\x00íØ\x10©\x02+“½ºxì" b"ü\x15┼(Z■Ûoí;Ý&æ\x146D" b"ü]¬vOMÛÞ\x0EÔÈU»2¹ê" b"ürdÓ\x07Bp\x04\x11═ƒh$æ÷" b""" ü½Ù\n ▄´»┐ÔÝò┐N├s¢ """ b"üßÔ═¶b│~â,┴¼ªÚ\x13" b"ü÷õÿ!]\x07\x00L¸╔È\Ì┘P" b"‚0íàäHˆ\x7FQ*Ô`\x03é˜ì" b"‚¯äG-ÌûhXRj2\x13õ‡·" b"‚²l4:vNÅ&6DÚ)q·–" b"‚ÀÐs\rp,ïñ×ïWûIº—" b"‚Ò’R\x1Aô‡lü Ú’J,;´" b"ƒ\rk\x14d+ÀÖê\x15 ŒÞŸ2í" b"âFèù▒ã\x1EÆK=\x0Fì÷hí\" b"âmM├═Ã1ÌÅ┘7┤Zû¶\x06" b"ƒzŸÊC}õI‡¡]2[‰”ÿ" b"ƒÅ\x0E\fÂ4üç\x1A\x02Ô×R†‹Û" b"ƒË\f\x18\x03ÆB\v¾CøÅúÍ$" b"„+ú\x00Ò»ø»Ð_6> ŒÓ\x17" b"„”e\x03až\x11-¿¥Ì\x13ŸÇ—¦" b"„ì¯\x0Fê\x13#ž5ºî{Ø=4k" b"…\vûÿr>§\x07™ó×Â.èG\x12" b"…K«%‡k0ì÷*y—\x03_£" b"…Lf÷M§¿Ãzí1\x1E"PÈO" b"…tVì?cÆLqŸL†NÚÄ'" b"àÉ¡Ñ╔ÿ┬2/}▓ \x13¿i░" b"åâ5i*╝u+è╚D\x1EÉW®`" b"å¬~╬ôL¾╗É5y§┼>Â>" b"†ßéªLÀi‚\x14üÍ"[\x18\x1C/" b"‡Zâ\x00ìICªÁ\x12Óà\tQ»Ž" b"‡yz.‘>°†\x19–\x13±<ü+7" b"çƒ(S*\x1A±ÇÀ»ØwrÊ7\" b"‡¬qÈ×½\x1A½\x1CáútÙÔ)'" b""" ‡ï$\n Â7‹›bx\x1Ar¡K\x17c """ b"‡ñõ\x02ð\x0FwúhE‘vþ- \x1E" b"ˆ\x0E!öå]mÒuaUrXºdï" b"‰,ü\x01ç¤\x16˜Á¤´áTZA·" b"ëYo╣bâºÙ╗o\x04_Øú░\x14" b"ëi\x12\x14▓Î│wÞxÄü·Éb¹" b"‰¢–žg©YÒÚk¥µµÿ'V" b"‰ø®¼ö¯*\fS\x08\x04ð“!¸k" b"ë³$È\x15Ë‗4Å░g\x1F╗É/" b"è\eÿ5Íé║Ó\x14ì&┐Ún»4" b"Š\x1E h\x18\x02±Žë&ŠùÑ\x1CSÂ" b"è%ò%ݽ©QfØ{±├\x00ë:" b"‹8Wü\x15͹”.eí¼@zHÛ" b"ï@©r~|█ƒ-ùüj╣¹CJ" b"‹I„)Z´#ŠŠÿ£Go\rL›" b""" ïfKöshƒy"5\x11e\n ;JØ """ b"ïü▒8«]ïÅ\x7F█ À\x16\x1Aƒ5" b"‹‡g2–Òz\x05W,å^õ\x166" b"Œ\x03\x1Cgf9o=ð¦\t+ô\x00eº" b"ŒM”òz¬†ýÎ\v”V%2\x02+" b"ŒY\x18X\x10E{¹X§ýÜ–…«ô" b"Œo†jÓäcÞïaT+ÂV-g" b"Œt!\5Xj\x0Fö…¼Y‚TÄ\x00" b"Œ†i\t4hxyÚz¤yÅãÀD" b"ŒÃå4¨ïï_\x7FrS«P~…E" b"ŒÊöÂb¯Lç\x14V•Ñõ\x02~U" b"ŒØц.Àæ¼\x06’z[/û¿>" b"î¦├\x16╔\x7FÅú║g´\x08\x1A\v¾À" b"ìÀ╝Õ╣$█×õa~ _Ó─‗" b""" ìãÞ&ç9‗u¹*j=╬\n cÑ """ b"ì╠µúQâAm\fà»!╔Fl«" b"ìÍñvx[²ã"dÇL%Ú6Á" b"ì±|\f"ß8}É1Uvçp░\x04" b"Ž\n\x10íïôzC¯QÊ‚°\x00»»" b"Ž!š–\x07„GHr¡r3âjm\n" b"ÄbìQõ)NÜ#Ô÷\x02B\x02BJ" b"Ž–~\x19Dc\x03P&h|\t»¼ùl" b"Ž—µ“†÷\x13YÈï\x17¢öâ/Î" b"Ž©\x0Fbyš–ZÁ\x1EPñ\fÄXÈ" b"ÄÙü#Á╚¹▓KÏ{+ü┐òP" b"ÅRjª╚+¿å°f\föÄ┘fQ" b"ÅUÑÒ©gÈ\tk»├Í®├^5" b"Å░#?å\x06»\x00\x04├O╗~í3Õ" b"Åý|ñ¿.B!ø+mÆ\x07p¼ã" b"É═\x0F│ ÑýQSO┬,uY" b"‘\x10ö¬þÄ\x16YUE}ë‡bÿE" b"æ<¢IÒçÍü2ü\x11?Îï\x1E" b"‘dóïq?—Õùø\x1F\võ\x17Ê\x1A" b"æy\x07«¶Ã^§:Ô\x1F┌ì╩k" b"’\x1F\x02Gè]¨\x1E±ó\x18DMÝ|Û" b"Æ'ü$»:‗9#M\x076¼,÷¬" b"ÆMîå;®±w,kb-ê²░Ø" b"ÆwÌß5Ú®gD©\x1EØ0─\f║" b"’zæÄw’GenA{J¨²,¹" b"“\x1CÉ\x7F=Jk…‰i\x0Fš@™6µ" b"”\x12ô†P\x03ã®.ºÑb\x1AŸ®¦" b"”\x1E\x1Dç£ézÔ\x1E«²‚ý]oÀ" b"öïhµÉ┘7Ê╬)\x16 \x1C─h:" b"”œN\x02²yàÃþ‘ýŸ¬]•I" b"ò$ï░ɬ*á┌ii%cÅF┬" b"•Q/áIQûï=>ú\x04äcÝæ" b"òUpWÄ\e%┐\x1Cı"4╬\x1Fkü" b"òyüÖûº\f\x1F▓«\x08¸╠sú©" b""" •‰Ï6Ì\n ½ \x1DSÒ2çôÏÿ """ b"•©\x13O%–§½¬µa½©k¯z" b"ò©u©VÇÕ@íá\réI~ü0" b"–;^³ES¢Ã<¤`Á²¬!Ó" b"û<£ô\x01ü┼òæ└│iÂ\fkW" b"–X{¸ÄOO¥u}O\x1AZêŸå" b"–wTÑ\x1D‹‹¤K+£…\v?Y=" b"ûò¶\x04▓½Ø█\x02S*\x1AjÔX\x16" b"û»ü\x7FÝÍ╠R5@█┤=ƒ\x1De" b"–î1Œû¸á\x7F.–˜ù‰áR¤" b"ù$\x16WQï\x17rìG`\x04\x05\t╝¼" b"—^Ήkv kK=\x13—ÿ%X|" b"—d>àÅ*ü”:½ Ñú2ðh" b"—¿Ãh¾i3`”ѲóCèGï" b"—ÐcZj=NACšºx`Û˜Æ" b"ÿ;8¬Û4²3╣õÅ{c╩Ó1" b"˜QXl\x11õܸÚ))}±L&3" b"˜Áa\x12\x0Fo°NV.C\x01I\fU]" b"˜Ñº-\x064GòÌT}ýŒ@f>" b"™p\x00Ò˜¯û—9yØ{)¸\x01œ" b"™…˜•Vý–w/\t³é\vÊ\x080" b"Öïüà³)+»\x16\x06▀ä_É£Ï" b"™´5ÑH›\x17jûUKP-Ã\x15ò" b"™º\x10bá\x08ä‡B©w$Qòâj" b"Üz¬\v@S¡ýH8\v╦±;(Å" b"š´CšÙ© \x03¡^b,Û\x12ª„" b"Ü└\t\x14¼╗|\x1AÁ(£ðgØ▄é" b"šÀÆ\e©&H`Ó\x002dz£\x1F " b""" šÄƒd\n ó4CQíoSÛ©- """ b"ø)▒Å▒DE¨z£┬ 3¾═t" b"øG┐XsYØ\tTÚÖ[Ø\r×ı" b"›_/·ƒ(\f\ݱT<\eèÆ›" b"›Ð«…~ Õ’æ\x18,\x03Ê\x1Dã" b"œ$2K\x05û\x10²cÃ`\x1A\x7F\x07»Ë" b"œeñg‰\x14bçFÃâmtL‚Ä" b"œxß"öáÐÙ\x07\x7FÔ·í4«\x15" b"œÆ\x11b\x1E™ý_<úxÇ»¡”Ô" b"œËþ=‡ªé\x13ïÏõæ©ÀA" b"Ø\x15çÔ■|BÉ\x02S)É\x04\x07l&" b"Ø\x1AõCàc£¤\x05K\x1DÌ\x1D┬¿K" b"Ø4\x16╔1ô╗\x0E\Aî\x19+©═" b"Ø├%^ëD#_)Æ■╚4]æE" b"Ø─o\x01z<ÎKïıS┬iHón" b"Ø▄1Å\x7FKËæ@>®ï\x0F|\x11a" b"žƒJ:]ÿk1\x17ElWZ¶9{" b"×à<tÈÙ├c`\x12ÎÉ»└ÁÂ" b"ž“fµø±šòŽ+\x01¶×J\x19„" b"Ÿ¸'ÔCÞ\x01{,N\e(³ÑO-" b"ƒ╣dô\x1E£W¯ïƒ-ìò4\x00Ð" b" …½E¨ÊO×Çx\x12ä\x07óÊ‘" b"á└ÏP3òü²\x19)~\x0FöÜ|ð" b" ÙãH4ÎzO½ò{>K<)a" b"í{@FRáR\x06B└\x1Aüå\x1C╔Î" b"¡‘@á§\x01ô\x15Á\f:ÒÓÊáç" b"¢\x166ñ|\x02’gV\x1C:Ž<áAÙ" b"ó\ey@┌»¤k ═º\vþúÉ\" b"¢OJŠÁÀ\x16uöU\x03j?Tö~" b"¢fø|‹ò¬7þ#.¶û½d£" b"ó×\raÉX\x10"u┬eYPqî'" b"£qS2\x04\x10•±\x0F^/ÎB|¨n" b"£Ä!{á\x1C\x18Õº•D/`Sàt" b"ñ8┼ð\f!ÉY*\x0E#! x┴m" b"¤@Ñé§õ2\x1DÂõF-•Ñƒy" b"¤sŒàÂ_µ×›:?/¸™½ú" b"¤|Ö"Þ•†ƒ-4ïôqÎŒÀ" b"¤’µª\x08ê\x07¤žÖÚɦÊaó" b"¤˜›U´\x07z)Íá&;„‰•â" b"¥¤W,q}ŽÁ¿*Üí¥þOß" b"ª\x15█┐ð®Ó{U¶▓F3Å×┐" b"¦\eqÛ\x13d«²\x13¯v2\x15SR“" b"¦OÝ\x07Q;¶ÄVØÜÌiÜ\x08p" b"¦t\x03\x12AtW\x04¯H}~°ùÚà" b"ªêNXìTW6\x04ƒÖOA#G>" b"ªë\x06@kL\x10GÙ\x06ü¸ra\x17┌" b"¦˜”'ë¤ï\x03^¿jƒ&]Á " b"ª┴¿¡®oh┴^ì?¨\x12.`" b"§\x08u˜A+:¤Œ•ÿz\x19¬p\x0F" b"º(XõGäì┐f²²¶-8Ø╩" b"§T*è’J‡Ä<ÏoÙ\}8{" b"§cÞ\r.\x03rQ\x1D€–’SRQÐ" b"§})Ù\x15*@bänÓ{œú\r¤" b"§}Ês\x1D\v¦ãCÆþÛÔ6" b"º«/©ß]À║▀ ─ØÜk#¾" b"§ÍñëÜ–\x06EÜ‘ŽÐr|Ãü" b"§äÄãÝÐ7Ç0é¸<Šó”b" b"¨\x02\x1Cz\nrÀ\x12\x16ê&;\x00\x077O" b"¨\f8“3¤Œl\x1CÄ8’ñè\x16Ë" b"¿½É╣g+ZÉýwþrèm\x04┌" b"¨Íù/p$¸3R³ßQ³èH" b"©\x0E6ZËö\x01\tº>áF?î‚ñ" b"©Rk£\t-K0x0k)…\x06ë/" b"©]<(σú\tä²ÄïË3\x1Dû" b"ª\x02«î\x7F¤·R\r’jò̽úÓ" b"ª\x08¡PÖKNÏì\x18Å’»¨Ëë" b"¬\x10nÉ╔ \x1E\x0F<hƸjûÚM" b"ªKø祔Í~îHGÑ ¸l¨" b"¬a¬ fƒî¯nwlÔT└ɧ" b""" ªª\x04\n ¥ÊÐ¥½\x1EŒ·Ògr† """ b"«GŒ‚sï¨Ã\x05Râ€Èß[\e" b"«[m\x1F\x0E\x05éó=Å0Ç:Ð\x03Ú" b"«`e8^\x05è?—Úgœ5´§„" b"«’ôzÅîyù—7lÍÐH\x08¢" b"«ô“\x1DdÝþè\x10ÑM\x10\x03“å" b""" ¼\n Ý█\v\x16×\x11▒Ò═ä.╚Ø7 """ b"¼\x16Ä╚┤N┐ØB╝[┬ÿF2r" b"¼\x17ìC4û`¹R╦┼║A\rÔl" b"¼=W§Z╚\x03¤Ç)YÒÉk█¢" b"¬s°AKH\x0Eà§\x11¤Ò}Ç´f" b""" ¬|5–G“…\n °%\n \x02H\x02"0 """ b"¼╣Å`I.à╗Ù═4°`.ï\f" b"¬ÅR\x1C\x08ÿ\x1E/ÂÎ\t4_\x7Fpÿ" b"¡)÷ç\x03┐░N<VJ║ìë─▒" b"/ÍßS{Ü8\x1F7ð¬Ä{¹Õ" b"c–µu\Ós6Åm1šQ9\x19" b"¡É \x18M|X╠$å╬zɧ_\x04" b"ÞxÅÜý¯Ü1ÚÂ\x00m”U\x03" b"âÐÅ(>\-3ÕnÝßYn³" b"«BÈÁHû‗6üB³`$ƒ\t╗" b"®`û†3K&¬\x17/í\x1DƒÍÈ\x1F" b"®ré\x17s#ö:°\x16]d¿<§Ÿ" b"®ö©ÞyÉ>û†Ø¡¨^˪¬" b"»5o1×\ruÛ)\x13╬\x07ɦX\x1D" b"»YØ\x11\x1C\x03┬╠#\x7FÝ-¥ÑRl" b"»¨ì-ã└[│7´*\x02˺╠E" b"°\x16Œ’b«¿mÍ\x12cnÑ3DÜ" b"°\e•fs\x01\x18>U\x19{ü¥cõ»" b"░D»ÿ£æÓ¢+═¾ki\x01Øç" b"°d J\x1DP\x1Dâ4»†+ÍÄÕ," b"°l“!ÿx8\f\x08ZZô3xÕ%" b"°Åì!5Ñ?Â\x1DŠýÈþéä&" b"±\x15ͨ»\x12;\x06\x15iëáy‰hQ" b"±ZX\x17±\x00RE\x1AØYÂÔs\x1D\x0E" b"±ˆ÷Ч\fZªœ~+£øS7" b"²"f¬êßHé£\r’œÁ\f\x17 " b"▓c.¬Û┐\x14ï\x13:Öì▄l(\x19" b"▓┴Eº¡ÃØéÓݹé\x1F»C\x1F" b"²û7ïƒ\x15š&ÓUÅ\x17R»áI" b"³bB9™Ë¾lˆ5½J`ÞPþ" b"³‡…»µý&E5½—”\x1FD![" b"│£ §█2┬Ø®¸┌\x12iv\x00K" b"³Ð3«`Ê\x00|T£?ÅøÚ\x16Ø" b"³÷\x00 ü¡K\x1A‡P“öëG„Ë" b"´Y\x1FW¬ÔwŽ‚¤\x1EñÖÕóÒ" b"┤y\x16-Ïk|Ð9#ÿæÎ╚ɸ" b"┤Ù8\x0Ei9¬ \x1C¶ÔAù\x7F\É" b"Á'¾õ5Ý\x12Uv\x7Fiıìh7q" b"µ8~W9¤Óï¡)‚òã$B³" b"µ—ÇŒ•"\v"½pOê̹[\f" b"Á┬uÀuª|║2y£tÀÅMo" b"µï\x1E\x18·†\t\x15\f•\x0EþÅlÕ‡" b"¶*\x19(\f£5õz\x08Vr(\x10%à" b"¶0pF¥èŒcðdïºÑÖI—" b"¶5¡\x16Å…ò¿™ª’{Ð\vu0" b"¶:ö\x19…n©nsôªMé\x07.\x01" b"¶eM‹ó\x113+"4ûa\f¤†Ÿ" b"¶•¢üöc¸\r]Ý‘Î\x15vÅ6" b"ÂÍ\x10\x03▀ıýî\x10¸ì╗«;Ëê" b"ÂݺyUÉ\x08\x12]/´Â└eÿÿ" b"·;„gÚ/‡u©\x08CXÏsÜ\x08" b"·<Cnw\x1Ciúìý\x18uÏ-NØ" b"·am>vÍüi’¿\x03\x063gâ¦" b"·“¯`úåíl+»\x19¹øy¼ß" b"À«=╚å&40Ø0Lê®├▓%" b"·Æ#ÂÃD¯úx\x05\x19]„tøè" b"·ê\x1AL{Ö;0Nl\x1A0êþ\x0EF" b"¸)(`¤#[`Æ\fß³Œ\x1A1Ï" b"©m´L`┼\x15\tÒf■[%ì+ñ" b"¸ñþꌵD\x7F'Ó™\x1Cegç" b"©·¿q¬É©\r╣\x1Dfgb)þ\n" b"╣\x08©UIØÕjµ)OL\x14\┘ã" b"¹\x14õ|$è›FÆrtß²¢›\x18" b"¹2¢×È÷G-š\rŸc\x7F¦48" b"¹F{¬£þ\x16&ç\x003à\x0E°š\f" b""" ╣UÐç│\t\n ┘«■Ø┴AF┌Ï """ b"¹‚”þ,tú.Å\e]w½¥\x14ì" b"╣îÓ\x1Få?Åû'}àx\x18îý>" b"¹ªšÖ#bñ»ÕxÛÕ·Ê™J" b"º<Z\x13h¨Ué4\t^!\x17\x11.^" b"ºe6Ú–]}5o`Ô\x12¨év·" b"ºq\x01e€Z-\x07_Öü~\x14Uy\x1D" b"º¤W«"\x18õ{@\x0EXÕE’°Ò" b"║ÏAßý69Ø:Pd¸yºp" b"ºò\x12ù©]¿D_d\x01\x01̆¹Ï" b"»\fb\e;'<.â9‹N/\x15–r" b"»-f”µÝý\x05;\x079þ!û&û" b"╗3M#┼Åãÿ\x16iñÑ┐gÞ." b"╗LÉ║|ÊÒƲ+³\x1D┤\x15s▀" b"»S\x17'ï]ûŸ¬Š>JPý×l" b"»no©é\x1D¯\x15\x1AŠ¸>tÒž×" b"»—a\eiÉ2V5K\x06eÈ\x154D" b"»˜ç;˜Žý\x03©˜h\x13¹ºïö" b"»¼á\x00F\x11G5·¯¢ßÜ\n\x11Ø" b"»Ë7]"\x02\x19aôî©™ú©°" b"»óH@e\x10¡h\v\x18`§lš:z" b"¼\x14”Ž\x16\x7FТ\x19¼åtª\x1CËL" b"╝;x'\x1A$¾░5®‗DÆWèü" b"¼_m\x1AÝçk¿\x1DïC>d¢¼Õ" b"¼À;ëÅn²6Ê'yŒÊ©Lx" b"¢\x10É\e31ª#ä\x1E¤þ\x1E¯\x7FÐ" b"¢ìD└V\x1DíºØ\x13S3 Í┌" b"½³W20ÛCùÐ=\x11\x19“ùGM" b"½Î\x18YJj·\x0Foû×\x12b…¦E" b"½êå0Ç.mHr\x1DBT\x08`vƒ" b"¥\x18\x05üÌDOP╝\x00eı.\x1C÷"" b"¾\x1CkQYn¯]\x16\x07‘ï¢\x7FHñ" b"¾5 \x10À\x0FW\x1ED\x18¤Â³ét" b"¾yZ8“R\e\x00›l\eªo&\rÌ" b"¾ÈK6OA#àÓC”‹6qGø" b"¿!yú óâi(jF(ŠãFŒ" b"¿)\x03ŠªCVL:ÛKf“E5." b"¿‘i\x04UÅï^\¹è‹³¦ª>" b"¿¯¬-i±W¸ÝSÌp Qï×" b"¿±Ä¤DÕ–äéÌã'a3Ø7" b"À\x06œ‹\x14™g‡ˆ±ü÷y\x15c»" b"À\x18Xƒ ¡šó$×Nšé}‘" b"À1Ý2"á'=-¦Øf“sÞ$" b""" └GmáUƒÐµ:└┤¤§\n ÉW """ b"À^4=à´Zåy6-~\x18Ï#p" b"└¬zÉÜÏÓ╚WïÏÛèb\x0Fb" b"Àâ’¸\x1A‘öÉ`ô3dY\rHˆ" b""" Á\x08UuÒ‡¯ku\t\n Ð h?ã """ b"┴$$c[ ¼ÞÅ║¨ä╔]µ║" b"Á‡2\x1Dx‹àxï§iÊ ¶+Ÿ" b"ÁÃXŸõ\f\x14é&#ø‹<Ɇ›" b"┴ı╚ËæÿðÅÏÅ\x7FÊ "ıT" b"Áú\x1Aà<Ä.y'#qèæ-îw" b"Â"v÷’\x124\x07•…Â#†|Ô" b"┬eâñ1Ø`\t\x06Ð\x18×■ N¹" b""" ┬¼\n *M\x13Æ┼\x03¾a;âÅ╔Ò """ b"ÂËž¦\f e™P8\x07¡^IÐ\r" b"Ãeüèý\x07Ʀ1\vD\x05\x1E>|#" b"ÃÏB8\f\x00\eÞÈ7^\n*›ý\x16" b""" ─'÷Å‗?¬NÞÈ\n SÚ6e■ """ b"Äjæ\x05LÈã:\x06\x02“Ù”‘-ï" b"Ävæ›crS>%¼œ\x14—Mš\n" b"ÄÖDÝ\x013’-\t\x0Fz‰ýJæ4" b"─ÔÁüè\r;Ã(ÛÌ£■C\x07û" b"Äêÿé‘çL\x1Ax€êí:]\x1FÔ" b"ÅWy\x16Æ\x00&Ê=\x16n|.smÄ" b"Åh6QºÌ"òOånQ\x15°jÕ" b"Æ\x03÷wÃN/Tæ„;4Ô÷(í" b"ÆãþŒ¾Q½gænO'˜\x1FþÑ" b"Ãy\x16?0Ñ©\x7F`\x08Ú`sì¶" b"LJ\x0EüF«£\x00cfã\x13Â6¸3" b"Ç¿t!m¶=§ƒ\r\¢=šB8" b"ùƒ\x02ùs/·èX=Ȳ\v\x13Ø" b"È\x0E\x14oX–åÑ!\x1CÒç´a\rO" b"ÈœHV0çŽ$\x072_Ž»Æ%È" b"╚█¸ı\x18┼`l6â\tlGü█³" b"╚Ì═3Ó-Ûs=fPüUüyc" b"É\x02,IÅŠ\x12ŽgÏEê“0,\x1D" b""" ╔\n ¿2ý>ü&¿ñìêO/C¹ """ b"Éf%}þFX\x14Ñà°2ä2\x17z" b"╔é"+fÎF¦\x1FSÊÓ╦Éâ¨" b"É’‰…¸l˜©ødØnæ\x05½†" b"ÉÖ‚'Äs\x19\x04—.‹ëœ…\v\x0E" b"Ê\x7F˜¡ÍV¬C£\tžøþcMk" b"ÊŒ¶i\x06Z.(4T\r¶\vS‰" b"ʨ$r\x06Ò–\x1FêkWgzù/l" b"Ê´\x11ÂÜa«bbË÷£ýyDf" b"╩Ój_k\f\x7FüøS7Yn?ó©" b"Êô}£m1(>cÓZŸðô\x02ä" b"╦\x00▀Ùu▀?\x16Éü~ËÜj\x14å" b"Ë!Iã8/Ž‚\x1D\x0F¥\x08õEÒ\x13" b"Ë"`uR\x13]“€“Û!UÚûR" b"Ë@(g+]\x10\x1DeG2ªòÇÃó" b"ËŸ³,JÀúýC±« ü¾ä¨" b"Ëé·Ÿ\x02\x13÷\x0F’YáÐp$™Ó" b"Ëê[½-¬R2!äµþ;e¨à" b"Ì\x02z\x17 fDìnf%¼Á¹qß" b"Ì\x08â×¼§ù%/X”Þ\ÊóX" b"╠\x0F\x14à\x1A7cëØ\x06YÆiÍw╔" b"Ì\x1C\x02\x10>7ÙÇ"n~\x11E¡jæ" b"ÌBnð2l\x15¾ÏiÎÉØ\x0FyX" b"╠─·¢ëêÀ×»ì\x10R_ìòä" b"╠·À>v─o‗Aù%┼\eôüƒ" b"Ìþ\x08Áä\x03¸$ ÿåp\x07Z)\x01" b"ÍAgA1t\x1A~q#ØØe±«–" b"ÍJì.‹]|hèv®Ù½µŸ" b"ÍM\x13éØàL\x0FPã\x1FBº²‡ú" b"═¶cF\x19رUkm\x03ê¸┼w┌" b"ÎN—ˆCï4lã_nÉ\x00÷)µ" b"ÎO ˜óë)[‚ªt¢@™5f" b"ÎX±vO\x07q¬—òFîkaó÷" b"╬ü\x05{Ù£ú\x19&yÎ2o╬ºN" b"╬▄@Ç▓gzMØü{î┴'ÌÞ" b"Ϭ‡_¶Ð1\x1F«\x1AþÓ`×Øÿ" b"Ï¿w1\x12l§ Æä·¯Á¶)…" b"ðÉM\x0F:Sa▄\x1DÅ┤Ò■öã\x17" b"й|V¿\x08m5;\x0FQò\x12\x052Ñ" b"ðÕb.î£\eoQ▓U\tì|ı\x17" b"Ñ\ve¤pßÚ¾Bå©\rã:I," b"Ñ)?´L3¬•3ÔÊEú«£\x05" b"Ñ3‰Üà½y±B9úVPFnT" b"ÐI$ËÙ«Å\x144[\x04_(ÂÄv" b"ÐT8k\x02G░\x19·"\e_Rɺõ" b"Ñ\¢h2ãÕÀP\x11Ž¤\x08~êc" b"Ñ^UÝSä\vîngf5¦\x02êæ" b"ÑÒEq«ªmã\x1CjñµÊÚê©" b"Ò\x12·¶\x07X\e9q‰åù\x19ÔŠ|" b"Ò=зhŽ‘9´’ëÈå |L" b"ÒH+˜!ÔÁ•„~ÖØ}U0*" b"Ê┼╩¨┘ûÅ\x07Æ┼º<W\x02\vÉ" b"ÒÆí\f¨Ê1€\e˜\x00\x7FBøF(" b""" ÒÏz\x12\r\n Ï\x03¯\x17à\x14©k\x02§ """ b"Òà[£œ\fÓ¥]BEÄn&©t" b"ÓFt‰ñ_8DÀFa……•©A" b"ÓpŸlN\x07G·ñ2î™\x03lèX" b"Óñò\x17ôHѪ\tî<œM%¨" b"Ônƒ6¨œ¸žž"ø½‡9¿ì" b"Ôª¶\x17\x13šï›x[\x055\x0EŠ\x1E¢" b"Ⱦ_Å\x12U¸█\e\x1E\x18\x13`%@Ç" b"Ôÿ&¯*W¹H}Dþ\x05BT1\x14" b"ÕHÒåÝ.ļâ3+ËÚåÍo" b"Õy‰Çà8±hE\x12»¾[ÓU\x01" b""" Õš\n ‘ÆAÇ8\x04/ cDcÀ\f """ b"ÖDb3Ô\x1Aõºð˜\vóò|iu" b"ÖNßC\x1C¿{\x1EwÝ\x12®©¾õ$" b"ÍÃ┤\x06\x13ÅZ©■]²¶\r\x1DX@" b"Öû2×Ô,î¬èKÛw2.³Â" b"×\x129³ðAt-\x13à“\f[ª“÷" b"×\x14Ö),eÄÆ«c\x168/ho›" b"Ø\x00æ\x1D»‰g§\x19è(\x04ÔºÆñ" b"Ø\v_PDõ—\x0EHO뉧\x04dö" b"Ø{p·\x1AL°Cj\x04WDn檶" b"Ïòæ-Òì;ôí\x7Fiê\x18P(Á" b"Ïã\x08\x19╬ú\x07\SÎ÷┌"╣É" b"϶\x19,V=sÆ\x12Èøïì\x02DK" b"Ù"qÎŽä*e/óµ)oFG" b"ÙB´¹ôhO¢\x06äê~\x19´lÊ" b"ÙL6Ëv\x1D~ÕË=Õø|‚\x04ú" b"Ùb€þéƒå‚Ò\x087¸˜þ€¶" b"ÙÀ–P¤¾ry\x1C”\x19\x18 "ÀÈ" b"┘µnr±Ç\x0Efƒóý±¤3Ø" b"┘²▀´ª®\rÔÅ4>³Û ▄K" b"Ú7Ë[Ù%*¬Q«Y»œ\x18†ß" b"Ú\ÊŸÜ`hÍ¿\x08癢\x06˜´" b"Úd‹Ê`\x17Žì‚\x16ŠœS>œË" b"ÚˆTÄÓ\x06UÊmâ]ÁÂHª~" b"ÚµŽ<¶ºøø$•ñ-\x0E[\x00y" b"ÚÉ(\x01ž\x19\_\x05u°\x14}ÈÑ›" b"Úî©È‡æâ+ƒ\x10\x12\x13þ³!›" b"█4ýÕ\x03ı\x03\x02êßÉk═zh|" b"ÛFËEù×ý³ùS^¬\r\x16\x07\x10" b"܉߶.õ\x7FÝ\x04Ôå3<¾oB" b"▄▒N║Õ½\x12ƒsûõ┐C\x11±ì" b"ܸ¿š2Ò.mÂ1‰\x1C3ñØ"" b"Ü͘ÞØô”Âò“HM‡êPÆ" b"¦\x03\x08É]s&╦▄§▒Üáæ┌╠" b"¦\r\x12çuý®b=\x1Eê2cu▒Ø" b"Ý\x11¿XÍùf„XDbÁ\x19\x1E™X" b"Ý\x1E\x18WÆs\x7FŸ à\Ý®Øn\e" b"ÝRž2X\x12’Wž·U\x07\e\f¸G" b"Ýxó)”ÜÚÎøó’šuÄrÒ" b"Þ\x12qqË™\v~nÎ`ºû\x0F'A" b"Ì7`qÓ² üÆ░╬±╔0îÿ" b""" ÞNã3p;\x06øà€[\n ƒê¯' """ b"Þj`&'T)Ò\x1EcÜr\x19\x18Ξ" b"▀è\x7F³xüB-³\x04\x1EÎ\x0Ej\x07" b"ßÁ4E\x15À®õ³sß0\x00V÷\" b"ßóŠ*¿\x1C¿—ÙæïÌõ›¡" b"Ó\x03øºc²o┐çÉ\t├J'Ø░" b"ÓeöâõÜı²ÉtRmº┬\x12t" b"à~ÔOÄN–5ç.DG§¿§×" b"ÓÅì╚▓┼3È\x00║[U╚}\¯" b"ß4ûróneZê¨r\x0E7Èì╝" b"á:íɯH9\x05©s‡\x15@æ[…" b"áNb7\x06Ÿ\x18¯îNíªñPÓQ" b"ážäíƒF85\x7F\vïÛ\x0F\x01y¯" b"áàe!³(K„<'‡J\x15× " b"â2‘Kî»áÆÄ£›JÑ\x12õ@" b"â=qÙË«!²š#©Oê.ç\x01" b"â~ÂÖã\x15\x15í$“\x10"Ú┥" b"ÔûÑÊÆ\x01Å¢└ð│\x03└ñdï" b""" âÞ<ÎË_0b;·MRòH\n U """ b"âé·ðȪ3`\x0E\x03Œ\x08\x1C\x13Ww" b"âú\x15\x1A\x01Ñ$\x0Eþõ¹òŠ,ËS" b"ã-Ž>«È\x14Ð’\x0EËóQnqÙ" b"ãJ\eZ5ž§p\x1E8¾\fLdúÄ" b"ãf-ÓÌ’Å`îÌΟ±f\x12À" b""" ão¹\n 3ª¦ˆçD:\x13»“Ž\x1A """ b"Òú│üÁ߬ú\x15·=íî╣-\x7F" b"ãÆü\x03$\eæ7\x0F?]TŸ©\x15ë" b"ãÜ8òI9\x13 Üò¶DPÉXV" b"ãù&»\t Ò@£~mñoφG" b"õt▒É├\x1C■ï«Ê\x03$¹G" b"ä–\x1DÏÍë8\x05Iic’÷\x0EÎj" b"äº\x0E4…•têŸÇGÈ馈9" b"äßYñXšð+Ñ•>Î\x18" b"õ¶á╗ŹN\vÚ?\x07\x19³¿O" b"Õ\x02¯Ø\x03┐\x11gîñ4_«¨Î'" b"Õ\x1A┼\x18tv¯┘ÉqNÚ \x1D#U" b"Õ*E║¨▀;heoÏÃåÅÒÿ" b"å@\e|qvd\x02\x0E7Ã8i'Ë\x01" b"Õâ\x01¾uDÅ#┌£ûsÝ■Ì " b"实,"o\x1C¼\x11`Êt3û\x17\n" b""" åºP_\x1Cjî\n ¥Öå_yyäM """ b"åöï\œ‚FYý#¶ÀÐ\rŒA" b"æ\x08\x10¸\x02G™ô¬m}¨÷F:$" b"æ\x12a4Ÿ\x04”O!&åçß\x1F\x0E¿" b"µ\x1Aü7\riq\x19¸øü?ª┘8\x04" b"æ@µŠ ׇÀ×þ \x13ƒ0QÇ" b"æøXm\x13ûÁ´!\x14\x7F\n\x00²ƒ" b"çS×Åæù\x13¯XMX_û^Û•" b"ç¶K\x0E±ó¥þžàÌHC“®Ò" b"çË¡j€6™Ù“´À|‹±Cï" b"è\x02j9‡\x7F“Ñ7Î~EÈ\x03)\x1A" b"èK÷\x03òø³¨W14(dX\x12A" b"Þ\Ù&\x1F╣n┬\x00+bÅ©¯\x0F¿" b"è¯÷ó¨ãŽÅ‰{T½lO(G" b"èÜÌ쳬=×ÉåÏÝáz¾Š" b"é›\x1F²)·ñbe’â!Ž¢Kÿ" b"ÚÀÉp\x08j%H\x1C╠║~å¨╩a" b"Ú²▀\x14Å\x1Dø´\x1C°°À\x00ë\f└" b"êaè-µ:a1\x7FüXÞqôƱ" b"ê µºç<¡»¿\x17ìæÎÔ\fÑ" b"êâ“Ø„<{{\x1FUÙ\x03\f˜\x1F]" b"Û¯\x1AÒV\x035\x1FhcÉ\x1D\x13║\x06*" b"ë*,\v…<;áJ2\v±ßýcÚ" b"ë/ˆ¶\x1EJrÝ‘à6,+{8\x1C" b"ÙI&d®Âñe4ÛDë▓█gÉ" b"ëjPýøÀ_\x1D˜Æ\x00Kœ\x10ùù" b"ÙØÆy±¿░ïIãë\x16\x03S¹▓" b""" ëÔ€;\x111\x01‘\n :¥\8Å# """ b"ì?£ƒ™dXX0\vÆ;:–v0" b"ýq{ê89ü¡)¸Ù'êÁ¬\r" b"í\x13h’ÿ\x17ù(˜\x0EŽàŸ–c\x16" b"í×\x1D\x02ÞèVÿ™îÏ[Y†MÞ" b"îž½þCËc\x13+\x1F'4[\x0EúZ" b"¯ÕÞü╣\x0E\rUá)FYèƒçÈ" b"ï7´`Ôâ¤\x13†WZC¨´úA" b"ï½e¼ÅR 2Xp“K:)+|" b"ïáûD:m*POnÆÑ\x16i\ve" b"ð6’™wRq€\x1Fò]Û€\x04 v" b"ðK\x1A½\x0F*þŸä\x01™hWkzæ" b"ñ5Wjó÷~4ÅÜ·ÿrm\x10\x04" b"±{\x00éÀüÝÐmðƒú·Ô6 " b""" ñÄæÜG\n 0\x18ú\x0FÚqÄî¼\t """ b"±ã¡╠└ü╚■sÔ\x16¦Û\v(\x7F" b"ò\x17¨Q"\x0Eæ=ýÜx\x1CÛ}JZ" b"òD\x1FJ/\x04?@"dWpþWÿÛ" b"òJü7m\x10€È^®ns,¿Ï&" b"òR¥e\x1Dó^Â\x03½\foÎu)¡" b"òn¡†g¶¢½u\x00N¨îô\x04ð" b""" ‗©ì╝&Ú\n ¸#ÖMø*ª─¡ """ b"¾Å~R\x12\e©ßóâ¶-(qª╩" b"óÔuuŠùÀ\x06\fÖºÞÎ\>\" b"ó÷?Þ{ çxÏuí»ì›1Ž" b"ô+-^|\f‚\x03Š`Ç$\x18Ÿo" b"ôA\x03\x04±xoë2\f"I;dò†" b"ôn]WKÃ<\‘\v\x00V\x01ã“," b"ô»å\x7Fîµ!çp\x7F\x1AÒÏXœ£" b"ôùߧ\t;m\x14íd /\x17tý\x7F" b"õ\x05ô½Æ\x1E¡.Ç´B//†÷Ï" b"§]\t|Ï\eÉVI£u╬³ƒ╗«" b"õ‚ï2’èõŠr–Ý<½hÙ~" b"õÇ" r‘/E\t²ŽA>—dÝ" b"õÏ<eno]ÃEh¶\x1Do†™j" b"õê.FZ\x04¨Ò¼Ñ5Þ\r\x04Ñ\x00" b"õú=Õ2ÂH0\x07n–k¶ûW¶" b"ö\x01FªÏ\x7F/³ˆ…õ)5ï:{" b"ö8UrڹɰÈ<ýš\x10…™\x14" b"ö“k“ñ\x10FèÍdæùø;\x1F<" b"öÎÚd}/}\x12Ô/01\x1EÁyf" b"öÝÏtǘ$Ü€D&bã|Û" b"öÞ´3\x18Y³‚¶åêe\x1CÅ}"" b"öíÌÒ\x173»à¥L\x1498“\rF" b"÷Jò@¢tZèü@÷x4åM:" b"÷M%\x19 Í0\x11R\x01á÷*5üz" b"÷S8ýÚúŸÛÙù(vÅÒ(:" b"¸g╝¾|þW/╦ìdY \x08JÃ" b""" ÷nˆ©\x15Ä\n vHÛQˆ\x0F’‡’ """ b"÷‡\¦Ø®…\x18œçpØÀ秱" b"÷° n3£Ëø\r\x1Ch…x\x14›s" b"÷¹eL¨Lk¼§m\tni:œ2" b"¸╣ªÉ½ãuf╠S0¿çÊ®─" b"÷ñ}\x16Í]÷º\x11ö./K/%Ñ" b""" ø®^!\x0E’\x10Š\n \x0EÃzRÔJ? """ b"ø´”¾ÏP’söuK,Ò6æ\x7F" b"ù,›e\x19âXìÞ-ÛoAú¶" b"ù“’6¬^F°×Ü\x02GJ‹è¡" b"¨Ø┤<×÷ƒ3<-£é\e═\x1D" b"ù¯:>‡Z©»»n‹QMv%«" b"új\x16>Ôß\x1F\x06.[]suÀDÊ" b"·©E.ìë4ÚrÞA╔O\x0F▄r" b"ú¼V¢ý%éú\x18\x02J«vû¡Ò" b"ûOƒ”Šè;Ä"\x18¾¹í¯·š" b"ûæ$º£.{;¢[_Ð¥\x1E\x02_" b"üUªä,Ë\x04g\x03S¥ûr=0ê" b"ü~ž5låf%ÓÑÃÝ=xºØ" b"ü÷’Ú\x04Iùš±\x1C0û\x02\x006ñ" b"ý\x02\0?xA‡÷3¯ÇË@‚¯" b"²\x03\rø¼)òµ\x01çÙá║╔Ø‗" b"ý\x1F!\x01Hë0\x11Õ\x1Dà†ÉÐ\x10e" b"ý3™#½¥É\x00ÓìZÇ0\x04fz" b"ý¤oô¿à\x17-«V\x0F5\x10c3ç" b"þ©\x02GW½FûÛw¬Å\x13Û/ç" b"ÿ\x01\x12V"e€ëzwõGâòu#" b"ÿLG\x1EÖ†T\x16þ#ëoR\f\x04\x14" b"ÿ“\x00€Wy '\x05ÄD\x1Eݼ¸n" b"ÿñ>ÚHXCP>²±´“Ý<" true ] |
||||||||||||||||||||||||||||||
|
0.65 ms (2.69%) |
2 |
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` 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 (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description as `product.translation.metaDescription`, `product.translation`.name as `product.translation.name`, `product.translation`.keywords as `product.translation.keywords`, `product.translation`.description as `product.translation.description`, `product.translation`.meta_title as `product.translation.metaTitle`, `product.translation`.pack_unit as `product.translation.packUnit`, `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, `product.translation`.slot_config as `product.translation.slotConfig`, `product.translation`.custom_fields as `product.translation.customFields`, `product.translation`.created_at as `product.translation.createdAt`, `product.translation`.updated_at as `product.translation.updatedAt`, `product.translation`.product_id as `product.translation.productId`, `product.translation`.language_id as `product.translation.languageId`, `product.translation`.product_version_id as `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (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_search_keywords as `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config as `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, `product.parent.translation`.created_at as `product.parent.translation.createdAt`, `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, `product.parent.translation`.product_id as `product.parent.translation.productId`, `product.parent.translation`.language_id as `product.parent.translation.languageId`, `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` WHERE (`product`.`version_id` = ?) AND ((`product`.`parent_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"ªÎIÇØ\x07gÏþÀå\x13®ˆmð" true ] |
||||||||||||||||||||||||||||||
|
0.57 ms (2.35%) |
4 |
# app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters:
[
true
]
|
||||||||||||||||||||||||||||||
|
0.56 ms (2.30%) |
1 |
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.plugin`.`id` as `payment_method.plugin.id`, `payment_method.plugin`.`base_class` as `payment_method.plugin.baseClass`, `payment_method.plugin`.`name` as `payment_method.plugin.name`, `payment_method.plugin`.`composer_name` as `payment_method.plugin.composerName`, `payment_method.plugin`.`autoload` as `payment_method.plugin.autoload`, `payment_method.plugin`.`active` as `payment_method.plugin.active`, `payment_method.plugin`.`managed_by_composer` as `payment_method.plugin.managedByComposer`, `payment_method.plugin`.`path` as `payment_method.plugin.path`, `payment_method.plugin`.`author` as `payment_method.plugin.author`, `payment_method.plugin`.`copyright` as `payment_method.plugin.copyright`, `payment_method.plugin`.`license` as `payment_method.plugin.license`, `payment_method.plugin`.`version` as `payment_method.plugin.version`, `payment_method.plugin`.`upgrade_version` as `payment_method.plugin.upgradeVersion`, `payment_method.plugin`.`installed_at` as `payment_method.plugin.installedAt`, `payment_method.plugin`.`upgraded_at` as `payment_method.plugin.upgradedAt`, `payment_method.plugin`.`icon` as `payment_method.plugin.iconRaw`, `payment_method.plugin`.`created_at` as `payment_method.plugin.createdAt`, `payment_method.plugin`.`updated_at` as `payment_method.plugin.updatedAt`, `payment_method.plugin.translation.label`, COALESCE(`payment_method.plugin.translation.label`,`payment_method.plugin.translation.label`) as `payment_method.plugin.label`, `payment_method.plugin.translation.description`, COALESCE(`payment_method.plugin.translation.description`,`payment_method.plugin.translation.description`) as `payment_method.plugin.description`, `payment_method.plugin.translation.manufacturerLink`, COALESCE(`payment_method.plugin.translation.manufacturerLink`,`payment_method.plugin.translation.manufacturerLink`) as `payment_method.plugin.manufacturerLink`, `payment_method.plugin.translation.supportLink`, COALESCE(`payment_method.plugin.translation.supportLink`,`payment_method.plugin.translation.supportLink`) as `payment_method.plugin.supportLink`, `payment_method.plugin.translation.customFields`, COALESCE(`payment_method.plugin.translation.customFields`,`payment_method.plugin.translation.customFields`) as `payment_method.plugin.customFields`, `payment_method.plugin.translation.createdAt`, `payment_method.plugin.translation.updatedAt`, `payment_method.plugin.translation.pluginId`, `payment_method.plugin.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `plugin` `payment_method.plugin` ON `payment_method`.`plugin_id` = `payment_method.plugin`.`id` LEFT JOIN (SELECT `payment_method.plugin.translation`.plugin_id, `payment_method.plugin.translation`.label as `payment_method.plugin.translation.label`, `payment_method.plugin.translation`.description as `payment_method.plugin.translation.description`, `payment_method.plugin.translation`.manufacturer_link as `payment_method.plugin.translation.manufacturerLink`, `payment_method.plugin.translation`.support_link as `payment_method.plugin.translation.supportLink`, `payment_method.plugin.translation`.custom_fields as `payment_method.plugin.translation.customFields`, `payment_method.plugin.translation`.created_at as `payment_method.plugin.translation.createdAt`, `payment_method.plugin.translation`.updated_at as `payment_method.plugin.translation.updatedAt`, `payment_method.plugin.translation`.plugin_id as `payment_method.plugin.translation.pluginId`, `payment_method.plugin.translation`.language_id as `payment_method.plugin.translation.languageId` FROM `plugin_translation` `payment_method.plugin.translation` WHERE `payment_method.plugin.translation`.language_id = ?) `payment_method.plugin.plugin_translation` ON `payment_method.plugin.plugin_translation`.`plugin_id` = `payment_method.plugin`.`id` WHERE (`payment_method`.`id` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"¸©Å╔└\x10G\x02®ofM½■&V" ] |
||||||||||||||||||||||||||||||
|
0.53 ms (2.18%) |
1 |
# seo_url::replacement SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters:
[ "/detail/aace49c7d80767cffec0e513ae886df0" "/navigation/df41b8ba15674e349cacdfff2f86650c" "/navigation/018b227d792f7f719cdcbe4a61f4cdf8" "/navigation/10026ccddbed4da3b2057bf7aac9f4a5" "/navigation/f79fd420473142efbbd7c3bc4aa2f070" "/navigation/fc490ca45c00b1249bbe3554a4fdf6fb" "/navigation/33e75ff09dd601bbe69f351039152189" "/navigation/28dd2c7955ce926456240b2ff0100bde" "/navigation/f033ab37c30201f73f142449d037028d" "/navigation/3295c76acbf4caaed33c36b1b5fc2cb1" "/navigation/9dfcd5e558dfa04aaf37f137a1d9d3e5" "/navigation/950a4152c2b4aa3ad78bdd6b366cc179" "/navigation/3fe94a002317b5f9259f82690aeea4cd" "/navigation/bbf94b34eb32268ada57a3be5062fe7d" "/navigation/4f4adcbf8c6f66dcfc8a3282ac2bf10a" "/navigation/8d3bba7425e7c98c50f52ca1b52d3735" "/navigation/bbcbff5c1f1ded46c25d28119a85c6c2" "/navigation/8cb22bdd0b7ba1ab13d742e22eed8da2" "/navigation/5737c6ec2e0716f3d8a7a5c4e0de0d9a" "/navigation/352fe25daf686bdb4edca223c921acea" "/navigation/d1f255a373a3cef72e03aa9d980c7eca" "/navigation/735b90b4568125ed6c3f678819b6e058" "/navigation/ad13a2a07ca4b7642959dc0c4c740ab6" "/navigation/a3f390d88e4c41f2747bfa2f1b5f87db" "/navigation/a666587afda6e89aec274a3657558a27" "/navigation/40008b9a5380fcacce3976bf7c08af5b" "/navigation/310dcbbf4cce62f762a2aaa148d556bd" "/navigation/018e603168d27b5ba5dfa4eded2b9143" "/navigation/34173cb38f07f89ddbebc2ac9128303f" "/navigation/c16a5320fa475530d9583c34fd356ef5" "/navigation/6364d3f0f495b6ab9dcf8d3b5c6e0b01" "/navigation/182be0c5cdcd5072bb1864cdee4d3d6e" "/navigation/a5771bce93e200c36f7cd9dfd0e5deaa" "/navigation/d67d8ab4f4c10bf22aa353e27879133c" "/navigation/d645920e395fedad7bbbed0eca3fe2e0" "/navigation/3416a75f4cea9109507cacd8e2f2aefc" "/navigation/a1d0c6e83f027327d8461063f4ac58a6" "/navigation/17e62166fc8586dfa4d1bc0e1742c08b" "/navigation/f7177163c833dff4b38fc8d2872f1ec6" "/navigation/6c8349cc7260ae62e3b1396831a8398f" "/navigation/d9d4f495e875a2e075a1a4a6e1b9770f" "/navigation/e369853df766fa44e1ed0ff613f563bd" "/navigation/0deb1c54814305ca9ad266f53bc82511" "/navigation/66808e327dc79d135ba18e051673d906" "/navigation/19ca14e7ea6328a42e0eb13d585e4c22" "/navigation/1c383cd30b7c298ab50293adfecb7b18" "/navigation/a5bfc9e07964f8dddeb95fc584cd965d" "/navigation/67c6a1e7ce56d3d6fa748ab6d9af3fd7" "/navigation/642e92efb79421734881b53e1e1b18b6" "/navigation/f457c545a9ded88f18ecee47145a72c0" "/navigation/72b32a1f754ba1c09b3695e0cb6cde7f" "/navigation/cf004fdc76fa1a4f25f62e0eb5261ca3" "/navigation/66f041e16a60928b05a7e228a89c3799" "/navigation/093f65e080a295f8076b1c5722a46aa2" "/navigation/072b030ba126b2f4b2374f342be9ed44" "/navigation/c0c7c76d30bd3dcaefc96f40275bdc0a" "/navigation/2838023a778dfaecdc212708f721b788" "/navigation/9a1158154dfa42caddbd0694a4e9bdc8" "/navigation/14bfa6bb14875e45bba028a21ed38046" "/navigation/7cbbc409ec990f19c78c75bd1e06f215" "/navigation/fbd7939d674997cdb4692d34de8633c4" "/navigation/6855456e2fe46a9d49d3d3af4f57443d" "/navigation/41ae36ecb9b3eee609d05b90c14222fb" "/navigation/bd686fd640be98efaae0091fa301e613" "/navigation/289dff07669d7a23de0ef88d2f7129e7" "/navigation/a4f23670e1833f3fdb077ca70bbd5d66" "/navigation/577ef1154f3240ad5b9b413aa7346a1e" "/navigation/c5ff2543b53f4cc0ad3819a36752467b" "/navigation/0bb4aec1710521c12ee76289d9440817" "/navigation/854d6fae5ee42911677c739ee1734486" "/navigation/01386bd6d8e091c2ab4c7c7de644d37b" "/navigation/35f4a8d465e6e1edc05f3d8ab658c551" "/navigation/f7664060cc52bc6f3d620bcedc94a4b6" "/navigation/13f9896df61279c928f19721878fac41" "/navigation/8f121ce07d74717e0b1f21d122e04521" "/navigation/7f100b7b36092fb9b06dfb4fac360931" "/navigation/9872ed9fc22fc182d371c3e9ed316094" "/navigation/31fefc0e570cb3860f2a6d4b38c6490d" "/navigation/0aa1883c6411f7873cb83dacb17b0afc" "/navigation/fb7b9ffa5462084c5f4e7e85a093e6d7" "/navigation/9dcb88e0137649590b755372b040afad" "/navigation/a2557a7b2e94197ff767970b67041697" "/navigation/58a2fc6ed39fd083f55d4182bf88826d" "/navigation/9fc3d7152ba9336a670e36d0ed79bc43" "/navigation/3988c7f88ebcb58c6ce932b957b6f332" "/navigation/1385974ed5904a438616ff7bdb3f7439" "/navigation/9de6d14fff9806d4bcd1ef555be766cd" "/navigation/903ce9225fca3e988c2af215d4e544d3" "/navigation/0a09c8844ba8f0936c20bd791130d6b6" "/navigation/02522a2b2726fb0a03bb19f2d8d9524d" "/navigation/8d5e957f297893487bd98fa830fa6413" "/navigation/357a6fdf7642bf815a88822c447d9dc4" "/navigation/a49e9411d64ff53eccfdd09ad10a15b3" "/navigation/e2ef524fbf3d9fe611d5a8e90fefdc9c" "/navigation/140f6969d5213fd0ece03148e62e461e" "/navigation/36660e59856b4de58a219bcf4e27eba3" "/navigation/e96ed478dab8595a7dbda4cbcbee168f" "/navigation/f340f1b1f65b6df5b5e3f94d95b11daf" "/navigation/d1fe173d08e959397adf34b1d77e88d7" "/navigation/43ec517d68b6edd3015b3edc9a11367b" "/navigation/9778d5d219c5080b9a6a17bef029331c" "/navigation/c7e1249ffc03eb9ded908c236bd1996d" "/navigation/fe9fc289c3ff0af142b6d3bead98a923" "/navigation/26657d5ff9020d2abefe558796b99584" "/navigation/82cec96096d4281b7c95cd7e74623496" "/navigation/d1f491a404d6854880943e5c3cd9ca25" "/navigation/819f46e52c25763a55cc642422644317" "/navigation/13fe9d84310e77f13a6d184dbf1232f3" "/navigation/eddea82ad2755b24c4e168c5fc2ebd40" "/navigation/cb70ab375662576bd1ac5aaf16b3fca4" "/navigation/1d7f7abc18fcb43975065399b0d1e48e" "/navigation/e4a6222cdb5b34375400904f03d8e6a5" "/navigation/37bc2f75bf1bcfe8450a1a41c200364c" "/navigation/496e05e1aea0a9c4655800e8a7b9ea28" "/navigation/6faa8040da20ef399b63a72d0e4ab575" "/navigation/b83aac23b9528732c23cc7352950e880" "/navigation/d947bf06a885db0d477d707121934ff8" "/navigation/63923f49e5241343aa7acb6a06a751e7" "/navigation/0f49c89d1e7298bb9930789c8ed59d48" "/navigation/16a5cdae362b8d27a1d8f8c7b78b4330" "/navigation/a01a0380ca3c61428c26a231f0e49a09" "/navigation/d395771085aab05244a4fb8fd91bf4ee" "/navigation/18d8042386b79e2c279fd162df0205c8" "/navigation/69cb3ea317a32c4e6143e665fdb20b14" "/cbax/manufacturer/index" "/cbax/manufacturer/detail/4bbd9c23e810a10a299357ea4c2b94ff" "/cbax/manufacturer/detail/a8898d3439db66e2a670294067edefbf" "/cbax/manufacturer/detail/44bdcee382a044c24ba7477b33b1621b" "/cbax/manufacturer/detail/857ea8aa2763de1c32f6adc4d3b7e8b5" "/cbax/manufacturer/detail/a3e53a1877ed03bee5dadbea956b00fe" "/cbax/manufacturer/detail/71b82474e68e1a402330979a9936fd81" "/cbax/manufacturer/detail/abf9cd412ca678eaeb0c223c5106c6ab" "/cbax/manufacturer/detail/cf8a3f59abe95022116f5a666c8367ff" "/cbax/manufacturer/detail/f78833b45c46f32d5922a036b06062a0" "/cbax/manufacturer/detail/ebe4ac2125061050ea6f4f61d0ffc1dd" "/cbax/manufacturer/detail/2748595b0787cd229ed52976936ecc53" "/cbax/manufacturer/detail/9914b4a164534b7cd5a9385ea36bb0f9" "/cbax/manufacturer/detail/3b24adb00570f5613cc8706ee397b0c0" "/cbax/manufacturer/detail/8f6cb82673d87e7fa4117b9e71dadb59" "/cbax/manufacturer/detail/a294c80c3eede5f14c96e97536ef080e" "/cbax/manufacturer/detail/22f0d1db8a4bffe1caa4516d391588a5" "/cbax/manufacturer/detail/e87b2ad973028e550ad31b7a41d32df1" "/cbax/manufacturer/detail/88f60185502437d61b64caa4c8e052c0" "/cbax/manufacturer/detail/ddd93cb9c04e8558c0a4db7bc548ed4c" "/cbax/manufacturer/detail/0b7224ffb0e76b602812e27899c6df7f" "/cbax/manufacturer/detail/859ff07af35d40a4e936ad335d62bcb2" "/cbax/manufacturer/detail/c4ca4238a0b923820dcc509a6f75849b" "/cbax/manufacturer/detail/5f5166c1f13757c72e0ab605ca43a070" "/cbax/manufacturer/detail/c2f80bd113a8829ee96eb7457c64493b" "/cbax/manufacturer/detail/4aa47fce25c574893331b435fdddecd7" "/cbax/manufacturer/detail/756b3e2aeff691b7d674da6295299518" "/cbax/manufacturer/detail/45c48cce2e2d7fbdea1afc51c7c6ad26" "/cbax/manufacturer/detail/02715b264be6320d09a0fa2a841e6551" "/cbax/manufacturer/detail/56ebfbd98f92f90704f38a00be40420e" "/cbax/manufacturer/detail/144af2b96a34ff42b4783635fbe26369" "/cbax/manufacturer/detail/11fa3016cef67b32c3a69aa831929cca" "/cbax/manufacturer/detail/686a08d1969df147813ea618cbce76be" "/cbax/manufacturer/detail/15d5d6d420efdde1bf3a51eec69c974a" "/cbax/manufacturer/detail/0c45a901430e2d554f533a36de52b4ca" "/cbax/manufacturer/detail/113a80259eea2dabecb4f1d35f5aafb8" "/cbax/manufacturer/detail/32b8d83f411ecf0d3620850dd1d444aa" "/cbax/manufacturer/detail/c8d534d430a7c414b0599364bed8ed51" "/cbax/manufacturer/detail/eee7e1e68fc8e5e01c923895e1570acf" "/cbax/manufacturer/detail/a2f2f560e8199f2135f220c01af8744a" "/cbax/manufacturer/detail/6fd4696a4458819a4125314dba9dcad2" "/navigation/76d6a1a64bf74ee4a9a5c7a9ea81ff74" "/navigation/6ac18b0184b3472081d23c6cd0d3be6c" "/navigation/b5cd3fd52922492086dd9e6ecd2bdd08" "/navigation/376550aa4fad477d83174e95f685ad1f" "/navigation/cdbbb71db836462f817b5d5a17b396e9" "/navigation/6fa6434adc0e4725bf4dc803abea1d07" "/navigation/0e99b11ddff84bb5a3c3f03ba80c4652" "/navigation/481dcdf7f3a54443987980964e9a1ca3" "/navigation/1aa59333e7a04ba2ba93897cc60f8554" "/navigation/32179757e8974da692a79af3f6b969f5" "/landingPage/018a4565d4d7781396db135e242125ff" "/navigation/2f500e3e758341aa9b9d7595d40828fd" "/navigation/6ffaa09bc4534c6cb5761cbd54e16519" "/navigation/514eeeca73964ea2a6a289046ec7b626" "/navigation/b70da7099682416db74698c21feb6794" "/navigation/f9cb4618268d4a76b8085a5ea63ada80" "/navigation/f3da3ade5d2a4072b3ff8ebf04258029" "/navigation/018a685be96f7db891bcc2c1b5624790" "/navigation/018a685c4d6a727eb8c8b0607c5fdc34" "/navigation/018a685d6f887ddd96b1fc32f074fc45" "/navigation/018a685dd5117b59a78e507c94b046c3" "/navigation/174e6ad734ab403abbccba761868f03a" "/navigation/7698c7806a2b4c93b4beac1cccc5431e" "/navigation/6e355d018d19491a92c3c7628185932c" "/navigation/d2375b3fb5ed4247a58ddcc97aad1a44" "/navigation/3df26b12819d4725995e5a930a2de526" "/navigation/bc41d588c9f54f70b76cd1a6d52023b6" "/navigation/6e5293e04f2f414cb4ec33c894df6948" "/navigation/434b6b89aaef4df9a574c26253117bfd" "/navigation/3fde9c65ad334285a4783d0c642c5cba" "/navigation/4b3cc5d817784bde9846b23b574406a2" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.47 ms (1.92%) |
1 |
SELECT `product_media`.`id` as `product_media.id`, `product_media`.`version_id` as `product_media.versionId`, `product_media`.`product_id` as `product_media.productId`, `product_media`.`product_version_id` as `product_media.productVersionId`, `product_media`.`media_id` as `product_media.mediaId`, `product_media`.`position` as `product_media.position`, `product_media.media`.`id` as `product_media.media.id`, `product_media.media`.`user_id` as `product_media.media.userId`, `product_media.media`.`media_folder_id` as `product_media.media.mediaFolderId`, `product_media.media`.`mime_type` as `product_media.media.mimeType`, `product_media.media`.`file_extension` as `product_media.media.fileExtension`, `product_media.media`.`uploaded_at` as `product_media.media.uploadedAt`, `product_media.media`.`file_name` as `product_media.media.fileName`, `product_media.media`.`file_size` as `product_media.media.fileSize`, `product_media.media`.`media_type` as `product_media.media.mediaTypeRaw`, `product_media.media`.`meta_data` as `product_media.media.metaData`, `product_media.media`.`config` as `product_media.media.config`, `product_media.media`.`path` as `product_media.media.path`, `product_media.media`.`private` as `product_media.media.private`, `product_media.media`.`thumbnails_ro` as `product_media.media.thumbnailsRo`, `product_media.media`.`created_at` as `product_media.media.createdAt`, `product_media.media`.`updated_at` as `product_media.media.updatedAt`, `product_media.media.translation.title`, COALESCE(`product_media.media.translation.title`,`product_media.media.translation.title`) as `product_media.media.title`, `product_media.media.translation.alt`, COALESCE(`product_media.media.translation.alt`,`product_media.media.translation.alt`) as `product_media.media.alt`, `product_media.media.translation.customFields`, COALESCE(`product_media.media.translation.customFields`,`product_media.media.translation.customFields`) as `product_media.media.customFields`, `product_media.media.translation.createdAt`, `product_media.media.translation.updatedAt`, `product_media.media.translation.mediaId`, `product_media.media.translation.languageId`, `product_media`.`custom_fields` as `product_media.customFields`, `product_media`.`created_at` as `product_media.createdAt`, `product_media`.`updated_at` as `product_media.updatedAt` FROM `product_media` LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id` LEFT JOIN (SELECT `product_media.media.translation`.media_id, `product_media.media.translation`.title as `product_media.media.translation.title`, `product_media.media.translation`.alt as `product_media.media.translation.alt`, `product_media.media.translation`.custom_fields as `product_media.media.translation.customFields`, `product_media.media.translation`.created_at as `product_media.media.translation.createdAt`, `product_media.media.translation`.updated_at as `product_media.media.translation.updatedAt`, `product_media.media.translation`.media_id as `product_media.media.translation.mediaId`, `product_media.media.translation`.language_id as `product_media.media.translation.languageId` FROM `media_translation` `product_media.media.translation` WHERE `product_media.media.translation`.language_id = ?) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id` WHERE (`product_media`.`version_id` = ?) AND (`product_media`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"ò¨\x10/j\x06ÇfßèP..VÔ–" ] |
||||||||||||||||||||||||||||||
|
0.43 ms (1.76%) |
1 |
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE `payment_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰NÒÃûsú´¶½\x03Dh{â" b""" \x01‰NÓ\n ¸q豬ÿJÎ%\x03: """ b""" \x01‰NÓ\n ºr\x17•j\z€úƒ> """ b""" \x01‰NÓ\n »r\x06 Ù½¿UÀå\x19 """ b""" \x01ëNË\n ╝rØÜ0.BÞçR█ """ b""" \x01ëNË\n ╝rØÜ0.BÚ+\t╠ """ b"\x01ëdch?p\x06ÅÁôòjÈh®" b"\x01‰dg§Ðq?¼÷7„\x01l9¾" b"\x01‰dg§Ðq?¼÷7„\x027€" b"\x01‰dg§Ðq?¼÷7„\x02æ\x16\x03" b"\x01‰dg§Ðq?¼÷7„\x03=‹u" b"\x01‰dg§Ðq?¼÷7„\x04ŸµÛ" b"\x01‰dg§Ðq?¼÷7„\x04´\x17" b"\x01‰dg§Ðq?¼÷7„\x05ÆÏç" b"\x01‰dg§Ðq?¼÷7„\x06YRõ" b"\x01‰dg§Ðq?¼÷7„\x07:ײ" b"\x01‰dg§Ðq?¼÷7„\x08\x01\x03ß" b"\x01Œ «\x1DŠ\x7F®‡Ì¤@œ\x1D•\x12" b"\x01Ä\x07ø[¢q ØÊk<┤\x06ÝZ" b"\x01Ä\x18eÒËs7ÿ=IØ\x02\x1688" b"\x01Ž1Ë‘Tq˜Ÿ—D „„Ûö" b"\x01–ç\x16Ÿ\x17qG•\x1F£ç\x1FÍ0#" b"\x01˜1 éYy9¬ í{8`w\x0E" b"\UùŠ9my!eE^\x07Š<_" b"¸©Å╔└\x10G\x02®ofM½■&V" ] |
||||||||||||||||||||||||||||||
|
0.40 ms (1.63%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "MNpEFRgdh9s9G8gIJ8WnfXI1WPaHFH3x" ] |
||||||||||||||||||||||||||||||
|
0.38 ms (1.57%) |
1 |
SELECT `easycredit_payment_state`.`token` as `easycredit_payment_state.token`, `easycredit_payment_state`.`payload` as `easycredit_payment_state.payload`, `easycredit_payment_state`.`created_at` as `easycredit_payment_state.createdAt`, `easycredit_payment_state`.`updated_at` as `easycredit_payment_state.updatedAt` FROM `easycredit_payment_state` WHERE `easycredit_payment_state`.`token` IN (?)
Parameters:
[
"MNpEFRgdh9s9G8gIJ8WnfXI1WPaHFH3x"
]
|
||||||||||||||||||||||||||||||
|
0.37 ms (1.52%) |
1 |
# seo_url::replacement SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters:
[ "/detail/aace49c7d80767cffec0e513ae886df0" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.37 ms (1.51%) |
2 |
SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel`.`id` = `sales_channel.paymentMethods.mapping`.`sales_channel_id` LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping`.`payment_method_id` = `sales_channel.paymentMethods`.`id` WHERE ((`sales_channel`.`id` = ? AND `sales_channel.paymentMethods`.`id` = ? AND `sales_channel.paymentMethods`.`active` = ?)) LIMIT 1
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" b"¸©Å╔└\x10G\x02®ofM½■&V" true ] |
||||||||||||||||||||||||||||||
|
0.35 ms (1.43%) |
4 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.34 ms (1.40%) |
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"\x01—ô*Yžr4´qxkØ%›¡" b"\x01—ô*ZSq\f‘q\x04!\x18´)×" ] |
||||||||||||||||||||||||||||||
|
0.33 ms (1.34%) |
4 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.31 ms (1.28%) |
1 |
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` WHERE (`payment_method`.`handler_identifier` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" "Netzkollektiv\EasyCredit\Payment\Handler\InstallmentPaymentHandler" "Netzkollektiv\EasyCredit\Payment\Handler\BillPaymentHandler" ] |
||||||||||||||||||||||||||||||
|
0.30 ms (1.23%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.28 ms (1.17%) |
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`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `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` `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"(Ý,yUÎ’dV$\v/ð\x10\vÞ" b"üƒFÕ,%v:U╠d$"dC\x17" b"õª",█[47T\x00ÉO\x03ϵÑ" ] |
||||||||||||||||||||||||||||||
|
0.28 ms (1.16%) |
1 |
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, (SELECT GROUP_CONCAT(HEX(`sales_channel.paymentMethods.mapping`.`payment_method_id`) SEPARATOR '||') FROM `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` WHERE `sales_channel.paymentMethods.mapping`.`sales_channel_id` = `sales_channel`.`id` ) as `sales_channel.paymentMethods.id_mapping`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.28 ms (1.16%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"MNpEFRgdh9s9G8gIJ8WnfXI1WPaHFH3x"
]
|
||||||||||||||||||||||||||||||
|
0.28 ms (1.15%) |
3 |
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id = ?) AND (property.module = ?)
Parameters:
[ b"1ýOf\,L\x0EÉ\x16mo╚▄êÑ" "frontend.detail.page" ] |
||||||||||||||||||||||||||||||
|
0.27 ms (1.13%) |
2 |
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ? AND `payment_method`.`active` = ?)
Parameters:
[ "Kiener\MolliePayments\Handler\Method\ApplePayPayment" true ] |
||||||||||||||||||||||||||||||
|
0.23 ms (0.95%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||||||||
|
0.22 ms (0.92%) |
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"""
\x01‰NÒÃùrXƒý>,˜\n
Úª
"""
b"\x01ëNÊ├■r>×~gÉ╗b¡┴"
b"\x01‰NÒÆ1psŠÁû\x06âù£Ï"
b"\x01‰NÒÄ\vsç¢y%ý±g\x01«"
b"\x01‹)\x15Ü\x11uošã3\x1D‹#½å"
b"\x01‹4Lˆ0q¼€£P›Ä\x041@"
b"\x01‹4MV1|B¿D»s6—2D"
b"\x01‹4O[ }š˜¸l[ÇÑA\n"
b"\x01‹4P\x0E…zã«\x1CÿÏ\x15”×{"
b"\x01‹8ܱ9rm§çö/¯ñ`ú"
b"\x01‹8áNw~8š8ŒÙ\x17\@Ì"
b"\x01‹®\x1Di¼u±ª‚\x03\x16«â\x11ò"
b"\x01‹×?\t×pU•ºÿ,Œù"\x03"
b"\x01Œ\x15¸Þœp•™ßvŒ¶¢$¾"
b"\x01î\x19¨ê¬|±║Åöc╦9\x04è"
b"\x01—^óŒÅs4Œp)õ\x03¼Õ"
b"äNg‚ÆBG·–¸‘Ï%®8÷"
]
|
||||||||||||||||||||||||||||||
|
0.22 ms (0.91%) |
1 |
# finsearch-config::load::read SELECT `finsearch_config`.`id` as `finsearch_config.id`, `finsearch_config`.`configuration_key` as `finsearch_config.configurationKey`, `finsearch_config`.`configuration_value` as `finsearch_config.configurationValue`, `finsearch_config`.`sales_channel_id` as `finsearch_config.salesChannelId`, `finsearch_config`.`language_id` as `finsearch_config.languageId`, `finsearch_config`.`created_at` as `finsearch_config.createdAt`, `finsearch_config`.`updated_at` as `finsearch_config.updatedAt` FROM `finsearch_config` WHERE `finsearch_config`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x01‹\x04—pÄr¿¦\t¢šR²E·" b"\x01ï\x04ùp╠rÂáôârÅB§Ä" b"\x01‹\x04—pÏs„VD´\x06\x11›O" b"\x01ï\x04ùpËq~ú2¬rÌþ\x05Ø" b"\x01‹\x04—pÕp˜…þæ;"öI€" b"\x01‹\x04—p×p\x0FŽ8¥ø0_í¸" b"\x01ï\x04ùp┘rÔüt\x02┐-/á╝" b"\x01ï\x04ùu!s$ü¤<×■^~4" b"\x01‹\x04—u(qÔ½¬TQ\x061¹2" b"\x01‹A\x05¾ÜqU®,/\x18êf>“" b"\x01‹A\x05¾ÝsE‘£µ\v®#4W" b"\x01‹KDÃ-r<•ž\x00L\nÑR\x13" ] |
||||||||||||||||||||||||||||||
|
0.22 ms (0.91%) |
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`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `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` `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`.`product_assignment_type` = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" "product_stream" ] |
||||||||||||||||||||||||||||||
|
0.20 ms (0.84%) |
1 |
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.20 ms (0.83%) |
1 |
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‰NÒâq囩±â4Rú¤" b"\x01ëNÊ├®s󪶽┤═\x7F?Å" b"\x01ëNÊ├Óp<½¦_VìB\x02V" b"\x01ëNÊ├ßq\x07½ËÃÉ▀ù,ƒ" b"\x01‰NÒÃâp¹†lŠ\x1D\x1AŽÍc" b"\x01‰NÒÃãpÓ¿QS6\x07ðï½" b"\x01‰NÒÃãpÓ¿QS6\x08d'5" b"\x01ëNÊ├õp»øE©}ü\x16Þe" b"\x01ëNÊ├õp»øE©}üEÀÑ" b"\x01ëNÊ├õp»øE©}üÅ_W" b"\x01‰NÒÃårÕ´³\x18/DB {" b"\x01‰NÒÃårÕ´³\x18/Dt\x1Fê" b"\x01‰NÒÃòqÿ‹Ü…–Ó|¼\x08" b"\x01‰NÒÃóq··Ë,\x00ÂíbW" b"\x01‰NÒÃóq··Ë,\x00Ä\x06$Ÿ" b"\x01‰NÒÃôr¶¬Û|Qixa\x19" b"\x01‰NÒÃôr¶¬Û|Qjs5E" b""" \x01‰NÒÃösw•\n ;\x01@\x10\x05% """ b""" \x01‰NÒÃösw•\n ;\x01@–ÎÏ """ b""" \x01‰NÒÃösw•\n ;\x01@¬÷Y """ b"\x01‰NÒÃ÷s뱊\x04ãø,A" b"\x01ëNÊãÓqSüê(zÆ<n█" b"\x01‰NÒÆâpH–×%óáÎ\x1Dp" b"\x01‰NÒÆâpH–×%óâÇ-N" b"\x01‰NÒÆãsÖ¾zŽ‰’O²\x1A" b"\x01‰NÒÆäslŸ\x1E®M¡eS)" ] |
||||||||||||||||||||||||||||||
|
0.20 ms (0.81%) |
1 |
# Manufacturer getManufacturerByChar manufacturer::search-ids SELECT `product_manufacturer`.`id` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` 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 WHERE `product_manufacturer`.`version_id` = ? ORDER BY COALESCE(`product_manufacturer.translation.name`) ASC
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" ] |
||||||||||||||||||||||||||||||
|
0.20 ms (0.81%) |
1 |
SELECT `product_stream`.`id` as `product_stream.id`, `product_stream`.`api_filter` as `product_stream.apiFilter`, `product_stream`.`invalid` as `product_stream.invalid`, `product_stream`.`created_at` as `product_stream.createdAt`, `product_stream`.`updated_at` as `product_stream.updatedAt`, `product_stream.translation.name`, COALESCE(`product_stream.translation.name`,`product_stream.translation.name`) as `product_stream.name`, `product_stream.translation.description`, COALESCE(`product_stream.translation.description`,`product_stream.translation.description`) as `product_stream.description`, `product_stream.translation.customFields`, COALESCE(`product_stream.translation.customFields`,`product_stream.translation.customFields`) as `product_stream.customFields`, `product_stream.translation.createdAt`, `product_stream.translation.updatedAt`, `product_stream.translation.productStreamId`, `product_stream.translation.languageId` FROM `product_stream` LEFT JOIN (SELECT `product_stream.translation`.product_stream_id, `product_stream.translation`.name as `product_stream.translation.name`, `product_stream.translation`.description as `product_stream.translation.description`, `product_stream.translation`.custom_fields as `product_stream.translation.customFields`, `product_stream.translation`.created_at as `product_stream.translation.createdAt`, `product_stream.translation`.updated_at as `product_stream.translation.updatedAt`, `product_stream.translation`.product_stream_id as `product_stream.translation.productStreamId`, `product_stream.translation`.language_id as `product_stream.translation.languageId` FROM `product_stream_translation` `product_stream.translation` WHERE `product_stream.translation`.language_id = ?) `product_stream.product_stream_translation` ON `product_stream.product_stream_translation`.`product_stream_id` = `product_stream`.`id` WHERE `product_stream`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‹#\x08x§|pƒJÄÕÅ3\x1FÔ" ] |
||||||||||||||||||||||||||||||
|
0.19 ms (0.79%) |
1 |
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.locale_id, `language.locale.translation`.name as `language.locale.translation.name`, `language.locale.translation`.territory as `language.locale.translation.territory`, `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.language_id = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||||||||
|
0.19 ms (0.77%) |
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"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "SKS-Werkzeug-Multitool-TOM-18/1103" "SKS-Werkzeug-Multitool-TOM-18/1103/" ] |
||||||||||||||||||||||||||||||
|
0.19 ms (0.77%) |
1 |
# finsearch-config::load::search-ids SELECT `finsearch_config`.`id` FROM `finsearch_config` WHERE ((`finsearch_config`.`sales_channel_id` = ? AND `finsearch_config`.`language_id` = ?)) ORDER BY `finsearch_config`.`sales_channel_id` ASC, `finsearch_config`.`id` ASC LIMIT 500
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||||||||
|
0.18 ms (0.74%) |
1 |
SELECT `acris_snippets_product`.`id` as `acris_snippets_product.id`, `acris_snippets_product`.`assignment_active` as `acris_snippets_product.assignmentActive`, `acris_snippets_product`.`priority` as `acris_snippets_product.priority`, `acris_snippets_product`.`created_at` as `acris_snippets_product.createdAt`, `acris_snippets_product`.`updated_at` as `acris_snippets_product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_snippets_product.productStreams.mapping`.`product_stream_id`) SEPARATOR '||') FROM `acris_product_stream` `acris_snippets_product.productStreams.mapping` WHERE `acris_snippets_product.productStreams.mapping`.`product_snippet_id` = `acris_snippets_product`.`id` ) as `acris_snippets_product.productStreams.id_mapping`, (SELECT GROUP_CONCAT(HEX(`acris_snippets_product.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||') FROM `acris_product_sales_channel` `acris_snippets_product.salesChannels.mapping` WHERE `acris_snippets_product.salesChannels.mapping`.`product_snippet_id` = `acris_snippets_product`.`id` ) as `acris_snippets_product.salesChannels.id_mapping`, `acris_snippets_product.translation.title`, COALESCE(`acris_snippets_product.translation.title`,`acris_snippets_product.translation.title`) as `acris_snippets_product.title`, `acris_snippets_product.translation.description`, COALESCE(`acris_snippets_product.translation.description`,`acris_snippets_product.translation.description`) as `acris_snippets_product.description`, `acris_snippets_product.translation.title_separator`, COALESCE(`acris_snippets_product.translation.title_separator`,`acris_snippets_product.translation.title_separator`) as `acris_snippets_product.title_separator`, `acris_snippets_product.translation.description_separator`, COALESCE(`acris_snippets_product.translation.description_separator`,`acris_snippets_product.translation.description_separator`) as `acris_snippets_product.description_separator`, `acris_snippets_product.translation.createdAt`, `acris_snippets_product.translation.updatedAt`, `acris_snippets_product.translation.acrisSnippetsProductId`, `acris_snippets_product.translation.languageId` FROM `acris_snippets_product` LEFT JOIN (SELECT `acris_snippets_product.translation`.acris_snippets_product_id, `acris_snippets_product.translation`.title as `acris_snippets_product.translation.title`, `acris_snippets_product.translation`.description as `acris_snippets_product.translation.description`, `acris_snippets_product.translation`.title_separator as `acris_snippets_product.translation.title_separator`, `acris_snippets_product.translation`.description_separator as `acris_snippets_product.translation.description_separator`, `acris_snippets_product.translation`.created_at as `acris_snippets_product.translation.createdAt`, `acris_snippets_product.translation`.updated_at as `acris_snippets_product.translation.updatedAt`, `acris_snippets_product.translation`.acris_snippets_product_id as `acris_snippets_product.translation.acrisSnippetsProductId`, `acris_snippets_product.translation`.language_id as `acris_snippets_product.translation.languageId` FROM `acris_snippets_product_translation` `acris_snippets_product.translation` WHERE `acris_snippets_product.translation`.language_id = ?) `acris_snippets_product.acris_snippets_product_translation` ON `acris_snippets_product.acris_snippets_product_translation`.`acris_snippets_product_id` = `acris_snippets_product`.`id` WHERE `acris_snippets_product`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01ŠÛû.˜p\e°YØ—Á€$x" ] |
||||||||||||||||||||||||||||||
|
0.18 ms (0.74%) |
1 |
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id` WHERE (`country`.`shipping_available` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters:
[ true b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.18 ms (0.73%) |
1 |
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||||||||||||
|
0.17 ms (0.71%) |
1 |
SELECT `product_review`.`points` as `ratingMatrix.key`, COUNT(`product_review`.`id`) as `ratingMatrix.count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE ((`product_review`.`status` = ? AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?))) AND ((`product_review`.`status` = ?)) GROUP BY `product_review`.`points`
Parameters:
[ 1 b"ªÎIÇØ\x07gÏþÀå\x13®ˆmð" b"ªÎIÇØ\x07gÏþÀå\x13®ˆmð" 1 ] |
||||||||||||||||||||||||||||||
|
0.17 ms (0.70%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" "EasyCreditRatenkauf.config.%" ] |
||||||||||||||||||||||||||||||
|
0.17 ms (0.69%) |
1 |
SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, ? REGEXP `old_url_regex` as regex0, ? REGEXP `old_url_regex` as regex2, ? REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = ? AND ((NOT (`search_url_by` = ?) AND ((`old_url` = ? OR `old_url` = ? OR `old_url` = ?))) OR (`search_url_by` = ? AND ((? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex`)))) LIMIT 6;
Parameters:
[ "/SKS-Werkzeug-Multitool-TOM-18/1103" "https://stage-sw6.radwelt-shop.de/SKS-Werkzeug-Multitool-TOM-18/1103" "stage-sw6.radwelt-shop.de/SKS-Werkzeug-Multitool-TOM-18/1103" 1 "regex" "/SKS-Werkzeug-Multitool-TOM-18/1103" "https://stage-sw6.radwelt-shop.de/SKS-Werkzeug-Multitool-TOM-18/1103" "stage-sw6.radwelt-shop.de/SKS-Werkzeug-Multitool-TOM-18/1103" "regex" "/SKS-Werkzeug-Multitool-TOM-18/1103" "https://stage-sw6.radwelt-shop.de/SKS-Werkzeug-Multitool-TOM-18/1103" "stage-sw6.radwelt-shop.de/SKS-Werkzeug-Multitool-TOM-18/1103" ]
|
||||||||||||||||||||||||||||||
|
0.16 ms (0.67%) |
1 |
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters:
[]
|
||||||||||||||||||||||||||||||
|
0.16 ms (0.66%) |
1 |
# sales-channel::load-analytics::read SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters:
[
b"\x01Æ2:«ðt═®®»½ø\x13ÄÉ"
]
|
||||||||||||||||||||||||||||||
|
0.15 ms (0.64%) |
1 |
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (`product_review`.`status` = ? AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)) ORDER BY `product_review`.`points` DESC LIMIT 10
Parameters:
[ 1 b"ªÎIÇØ\x07gÏþÀå\x13®ˆmð" b"ªÎIÇØ\x07gÏþÀå\x13®ˆmð" ] |
||||||||||||||||||||||||||||||
|
0.15 ms (0.60%) |
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.14 ms (0.60%) |
1 |
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.14 ms (0.59%) |
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.14 ms (0.58%) |
1 |
SELECT option_translation.name FROM product product INNER JOIN product_option product_group ON product_group.product_id = product.id INNER JOIN property_group_option product_option ON product_group.property_group_option_id = product_option.id INNER JOIN property_group_option_translation option_translation ON option_translation.property_group_option_id = product_option.id WHERE (product.id = ?) AND (product.parent_id IS NOT NULL) AND (product.option_ids IS NOT NULL) AND (option_translation.language_id = ?)
Parameters:
[ b"ªÎIÇØ\x07gÏþÀå\x13®ˆmð" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||||||||||||
|
0.13 ms (0.55%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.13 ms (0.54%) |
1 |
SELECT `acris_snippets_product`.`id` FROM `acris_snippets_product` LEFT JOIN `acris_product_sales_channel` `acris_snippets_product.salesChannels.mapping` ON `acris_snippets_product`.`id` = `acris_snippets_product.salesChannels.mapping`.`product_snippet_id` LEFT JOIN `sales_channel` `acris_snippets_product.salesChannels` ON `acris_snippets_product.salesChannels.mapping`.`sales_channel_id` = `acris_snippets_product.salesChannels`.`id` WHERE ((`acris_snippets_product`.`assignment_active` = ? AND `acris_snippets_product.salesChannels`.`id` = ?)) GROUP BY `acris_snippets_product`.`id` ORDER BY LENGTH(`acris_snippets_product`.`priority`) DESC, MAX(`acris_snippets_product`.`priority`) DESC
Parameters:
[ true b"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" ] |
||||||||||||||||||||||||||||||
|
0.13 ms (0.52%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||||||||
|
0.11 ms (0.46%) |
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"\x01‰R&g\x0Er¤¡_7\x1AÜâ—" b"\x01‰NÒâq囩±â4Rú¤" ] |
||||||||||||||||||||||||||||||
|
0.11 ms (0.44%) |
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.10 ms (0.40%) |
1 |
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id IS NULL) AND (property.module = ?)
Parameters:
[
"frontend.detail.page"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.