1
0.24 ms
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` ;
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` ; ;
Copy
2
0.10 ms
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
3
0.16 ms
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
; Copy
4
0.33 ms
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ? ) AND ((sales_channel_id = ? OR sales_channel_id IS NULL )) AND ((seo_path_info = ? OR seo_path_info = ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
"Hygienearmaturen/Reduzierstuecke "
"Hygienearmaturen/Reduzierstuecke/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D OR sales_channel_id IS NULL )) AND ((seo_path_info = 'Hygienearmaturen/Reduzierstuecke' OR seo_path_info = 'Hygienearmaturen/Reduzierstuecke/' ));
Copy
5
0.25 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
"qSPI9PlPHoK8zXegKUMx7nAhNbBwBEtV "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D ) AND (token = 'qSPI9PlPHoK8zXegKUMx7nAhNbBwBEtV' ) LIMIT 1 ; Copy
6
0.12 ms
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"qSPI9PlPHoK8zXegKUMx7nAhNbBwBEtV "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'qSPI9PlPHoK8zXegKUMx7nAhNbBwBEtV' ;
Copy
7
0.15 ms
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = ? AND `sales_channel_country` . `country_id` = ? )
Parameters :
[
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
b"Å\x08 ×PÉVKÿ»IQ\x1E øP\x08 r "
]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0xCD6592C636AE4BF38378B01A9B31E46D AND `sales_channel_country` . `country_id` = 0xC508D750C9564BFFBB49511EF8500872 ); Copy
8
0.52 ms
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.media` . `id` as `category.media.id` , `category.media` . `user_id` as `category.media.userId` , `category.media` . `media_folder_id` as `category.media.mediaFolderId` , `category.media` . `mime_type` as `category.media.mimeType` , `category.media` . `file_extension` as `category.media.fileExtension` , `category.media` . `uploaded_at` as `category.media.uploadedAt` , `category.media` . `file_name` as `category.media.fileName` , `category.media` . `file_size` as `category.media.fileSize` , `category.media` . `media_type` as `category.media.mediaTypeRaw` , `category.media` . `meta_data` as `category.media.metaData` , `category.media` . `config` as `category.media.config` , `category.media` . `path` as `category.media.path` , `category.media` . `private` as `category.media.private` , `category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` , `category.media` . `file_hash` as `category.media.fileHash` , `category.media` . `created_at` as `category.media.createdAt` , `category.media` . `updated_at` as `category.media.updatedAt` , `category.media.translation.title` , `category.media.translation.title` as `category.media.title` , `category.media.translation.alt` , `category.media.translation.alt` as `category.media.alt` , `category.media.translation.customFields` , `category.media.translation.customFields` as `category.media.customFields` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` LEFT JOIN (SELECT `category.media.translation` . `media_id` , `category.media.translation` . `alt` as `category.media.translation.alt` , `category.media.translation` . `title` as `category.media.translation.title` , `category.media.translation` . `custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation` . `language_id` = ? ) `category.media.media_translation` ON `category.media.media_translation` . `media_id` = `category.media` . `id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%;³'JWðKÉ—\f y_-ýÛå "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.media` . `id` as `category.media.id` ,
`category.media` . `user_id` as `category.media.userId` ,
`category.media` . `media_folder_id` as `category.media.mediaFolderId` ,
`category.media` . `mime_type` as `category.media.mimeType` ,
`category.media` . `file_extension` as `category.media.fileExtension` ,
`category.media` . `uploaded_at` as `category.media.uploadedAt` ,
`category.media` . `file_name` as `category.media.fileName` ,
`category.media` . `file_size` as `category.media.fileSize` ,
`category.media` . `media_type` as `category.media.mediaTypeRaw` ,
`category.media` . `meta_data` as `category.media.metaData` ,
`category.media` . `config` as `category.media.config` ,
`category.media` . `path` as `category.media.path` ,
`category.media` . `private` as `category.media.private` ,
`category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` ,
`category.media` . `file_hash` as `category.media.fileHash` ,
`category.media` . `created_at` as `category.media.createdAt` ,
`category.media` . `updated_at` as `category.media.updatedAt` ,
`category.media.translation.title` ,
`category.media.translation.title` as `category.media.title` ,
`category.media.translation.alt` ,
`category.media.translation.alt` as `category.media.alt` ,
`category.media.translation.customFields` ,
`category.media.translation.customFields` as `category.media.customFields` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
LEFT JOIN (
SELECT
`category.media.translation` . `media_id` ,
`category.media.translation` . `alt` as `category.media.translation.alt` ,
`category.media.translation` . `title` as `category.media.translation.title` ,
`category.media.translation` . `custom_fields` as `category.media.translation.customFields`
FROM
`media_translation` `category.media.translation`
WHERE
`category.media.translation` . `language_id` = ?
) `category.media.media_translation` ON `category.media.media_translation` . `media_id` = `category.media` . `id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.media` . `id` as `category.media.id` , `category.media` . `user_id` as `category.media.userId` , `category.media` . `media_folder_id` as `category.media.mediaFolderId` , `category.media` . `mime_type` as `category.media.mimeType` , `category.media` . `file_extension` as `category.media.fileExtension` , `category.media` . `uploaded_at` as `category.media.uploadedAt` , `category.media` . `file_name` as `category.media.fileName` , `category.media` . `file_size` as `category.media.fileSize` , `category.media` . `media_type` as `category.media.mediaTypeRaw` , `category.media` . `meta_data` as `category.media.metaData` , `category.media` . `config` as `category.media.config` , `category.media` . `path` as `category.media.path` , `category.media` . `private` as `category.media.private` , `category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` , `category.media` . `file_hash` as `category.media.fileHash` , `category.media` . `created_at` as `category.media.createdAt` , `category.media` . `updated_at` as `category.media.updatedAt` , `category.media.translation.title` , `category.media.translation.title` as `category.media.title` , `category.media.translation.alt` , `category.media.translation.alt` as `category.media.alt` , `category.media.translation.customFields` , `category.media.translation.customFields` as `category.media.customFields` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` LEFT JOIN (SELECT `category.media.translation` . `media_id` , `category.media.translation` . `alt` as `category.media.translation.alt` , `category.media.translation` . `title` as `category.media.translation.title` , `category.media.translation` . `custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.media.media_translation` ON `category.media.media_translation` . `media_id` = `category.media` . `id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x3BB3274A57F04BC9970C795F2DFDDBE5 ));
Copy
9
0.17 ms
SELECT `category_translation` . `name` as `category_translation.name` , `category_translation` . `breadcrumb` as `category_translation.breadcrumb` , `category_translation` . `slot_config` as `category_translation.slotConfig` , `category_translation` . `link_type` as `category_translation.linkType` , `category_translation` . `internal_link` as `category_translation.internalLink` , `category_translation` . `external_link` as `category_translation.externalLink` , `category_translation` . `link_new_tab` as `category_translation.linkNewTab` , `category_translation` . `description` as `category_translation.description` , `category_translation` . `meta_title` as `category_translation.metaTitle` , `category_translation` . `meta_description` as `category_translation.metaDescription` , `category_translation` . `keywords` as `category_translation.keywords` , `category_translation` . `custom_fields` as `category_translation.customFields` , `category_translation` . `created_at` as `category_translation.createdAt` , `category_translation` . `updated_at` as `category_translation.updatedAt` , `category_translation` . `category_id` as `category_translation.categoryId` , `category_translation` . `language_id` as `category_translation.languageId` , `category_translation` . `category_version_id` as `category_translation.categoryVersionId` FROM `category_translation` WHERE (`category_translation` . `category_version_id` = ? ) AND (((`category_translation` . `category_id` IN (? ))))
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%;³'JWðKÉ—\f y_-ýÛå "
]
SELECT `category_translation` . `name` as `category_translation.name` , `category_translation` . `breadcrumb` as `category_translation.breadcrumb` , `category_translation` . `slot_config` as `category_translation.slotConfig` , `category_translation` . `link_type` as `category_translation.linkType` , `category_translation` . `internal_link` as `category_translation.internalLink` , `category_translation` . `external_link` as `category_translation.externalLink` , `category_translation` . `link_new_tab` as `category_translation.linkNewTab` , `category_translation` . `description` as `category_translation.description` , `category_translation` . `meta_title` as `category_translation.metaTitle` , `category_translation` . `meta_description` as `category_translation.metaDescription` , `category_translation` . `keywords` as `category_translation.keywords` , `category_translation` . `custom_fields` as `category_translation.customFields` , `category_translation` . `created_at` as `category_translation.createdAt` , `category_translation` . `updated_at` as `category_translation.updatedAt` , `category_translation` . `category_id` as `category_translation.categoryId` , `category_translation` . `language_id` as `category_translation.languageId` , `category_translation` . `category_version_id` as `category_translation.categoryVersionId` FROM `category_translation` WHERE (`category_translation` . `category_version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`category_translation` . `category_id` IN (0x3BB3274A57F04BC9970C795F2DFDDBE5 ))));
Copy
10
0.21 ms
SELECT `cms_page` . `id` as `cms_page.id` , `cms_page` . `version_id` as `cms_page.versionId` , `cms_page` . `type` as `cms_page.type` , `cms_page` . `entity` as `cms_page.entity` , `cms_page` . `css_class` as `cms_page.cssClass` , `cms_page` . `config` as `cms_page.config` , `cms_page` . `preview_media_id` as `cms_page.previewMediaId` , `cms_page` . `locked` as `cms_page.locked` , `cms_page` . `created_at` as `cms_page.createdAt` , `cms_page` . `updated_at` as `cms_page.updatedAt` , `cms_page.translation.name` , `cms_page.translation.name` as `cms_page.name` , `cms_page.translation.customFields` , `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation` . `cms_page_id` , `cms_page.translation` . `cms_page_version_id` , `cms_page.translation` . `name` as `cms_page.translation.name` , `cms_page.translation` . `custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation` . `language_id` = ? ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation` . `cms_page_id` = `cms_page` . `id` AND `cms_page.cms_page_translation` . `cms_page_version_id` = `cms_page` . `version_id` WHERE (`cms_page` . `version_id` = ? ) AND (`cms_page` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%vˆT\x04 °{KC·ñ \x06 xµ\x05 œ "
]
SELECT `cms_page` . `id` as `cms_page.id` , `cms_page` . `version_id` as `cms_page.versionId` , `cms_page` . `type` as `cms_page.type` , `cms_page` . `entity` as `cms_page.entity` , `cms_page` . `css_class` as `cms_page.cssClass` , `cms_page` . `config` as `cms_page.config` , `cms_page` . `preview_media_id` as `cms_page.previewMediaId` , `cms_page` . `locked` as `cms_page.locked` , `cms_page` . `created_at` as `cms_page.createdAt` , `cms_page` . `updated_at` as `cms_page.updatedAt` , `cms_page.translation.name` , `cms_page.translation.name` as `cms_page.name` , `cms_page.translation.customFields` , `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation` . `cms_page_id` , `cms_page.translation` . `cms_page_version_id` , `cms_page.translation` . `name` as `cms_page.translation.name` , `cms_page.translation` . `custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation` . `cms_page_id` = `cms_page` . `id` AND `cms_page.cms_page_translation` . `cms_page_version_id` = `cms_page` . `version_id` WHERE (`cms_page` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`cms_page` . `id` IN (0x76885404B07B4B43B7F1A00678B5059C ));
Copy
11
0.27 ms
SELECT `cms_section` . `id` as `cms_section.id` , `cms_section` . `version_id` as `cms_section.versionId` , `cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` , `cms_section` . `position` as `cms_section.position` , `cms_section` . `type` as `cms_section.type` , `cms_section` . `locked` as `cms_section.locked` , `cms_section` . `name` as `cms_section.name` , `cms_section` . `sizing_mode` as `cms_section.sizingMode` , `cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` , `cms_section` . `background_color` as `cms_section.backgroundColor` , `cms_section` . `background_media_id` as `cms_section.backgroundMediaId` , `cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` , `cms_section` . `css_class` as `cms_section.cssClass` , `cms_section` . `cms_page_id` as `cms_section.pageId` , `cms_section` . `visibility` as `cms_section.visibility` , `cms_section` . `custom_fields` as `cms_section.customFields` , `cms_section` . `created_at` as `cms_section.createdAt` , `cms_section` . `updated_at` as `cms_section.updatedAt` , `cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` , `cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` , `cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` , `cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` , `cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` , `cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` , `cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` , `cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` , `cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` , `cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` , `cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` , `cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` , `cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` , `cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` , `cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` , `cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` , `cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` , `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` , `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` , `cms_section.backgroundMedia.translation.customFields` , `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation` . `media_id` , `cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation` . `language_id` = ? ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id` WHERE (`cms_section` . `version_id` = ? ) AND (((`cms_section` . `cms_page_id` IN (? ))))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%vˆT\x04 °{KC·ñ \x06 xµ\x05 œ "
]
SELECT
`cms_section` . `id` as `cms_section.id` ,
`cms_section` . `version_id` as `cms_section.versionId` ,
`cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` ,
`cms_section` . `position` as `cms_section.position` ,
`cms_section` . `type` as `cms_section.type` ,
`cms_section` . `locked` as `cms_section.locked` ,
`cms_section` . `name` as `cms_section.name` ,
`cms_section` . `sizing_mode` as `cms_section.sizingMode` ,
`cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` ,
`cms_section` . `background_color` as `cms_section.backgroundColor` ,
`cms_section` . `background_media_id` as `cms_section.backgroundMediaId` ,
`cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` ,
`cms_section` . `css_class` as `cms_section.cssClass` ,
`cms_section` . `cms_page_id` as `cms_section.pageId` ,
`cms_section` . `visibility` as `cms_section.visibility` ,
`cms_section` . `custom_fields` as `cms_section.customFields` ,
`cms_section` . `created_at` as `cms_section.createdAt` ,
`cms_section` . `updated_at` as `cms_section.updatedAt` ,
`cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` ,
`cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` ,
`cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` ,
`cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` ,
`cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` ,
`cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` ,
`cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` ,
`cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` ,
`cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` ,
`cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` ,
`cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` ,
`cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` ,
`cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` ,
`cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` ,
`cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` ,
`cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` ,
`cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` ,
`cms_section.backgroundMedia.translation.title` ,
`cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` ,
`cms_section.backgroundMedia.translation.alt` ,
`cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` ,
`cms_section.backgroundMedia.translation.customFields` ,
`cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields`
FROM
`cms_section`
LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id`
LEFT JOIN (
SELECT
`cms_section.backgroundMedia.translation` . `media_id` ,
`cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` ,
`cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` ,
`cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields`
FROM
`media_translation` `cms_section.backgroundMedia.translation`
WHERE
`cms_section.backgroundMedia.translation` . `language_id` = ?
) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id`
WHERE
(`cms_section` . `version_id` = ? )
AND (
(
(
`cms_section` . `cms_page_id` IN (? )
)
)
)
Copy
SELECT `cms_section` . `id` as `cms_section.id` , `cms_section` . `version_id` as `cms_section.versionId` , `cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` , `cms_section` . `position` as `cms_section.position` , `cms_section` . `type` as `cms_section.type` , `cms_section` . `locked` as `cms_section.locked` , `cms_section` . `name` as `cms_section.name` , `cms_section` . `sizing_mode` as `cms_section.sizingMode` , `cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` , `cms_section` . `background_color` as `cms_section.backgroundColor` , `cms_section` . `background_media_id` as `cms_section.backgroundMediaId` , `cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` , `cms_section` . `css_class` as `cms_section.cssClass` , `cms_section` . `cms_page_id` as `cms_section.pageId` , `cms_section` . `visibility` as `cms_section.visibility` , `cms_section` . `custom_fields` as `cms_section.customFields` , `cms_section` . `created_at` as `cms_section.createdAt` , `cms_section` . `updated_at` as `cms_section.updatedAt` , `cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` , `cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` , `cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` , `cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` , `cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` , `cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` , `cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` , `cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` , `cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` , `cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` , `cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` , `cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` , `cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` , `cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` , `cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` , `cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` , `cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` , `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` , `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` , `cms_section.backgroundMedia.translation.customFields` , `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation` . `media_id` , `cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id` WHERE (`cms_section` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`cms_section` . `cms_page_id` IN (0x76885404B07B4B43B7F1A00678B5059C ))));
Copy
12
0.30 ms
SELECT `cms_block` . `id` as `cms_block.id` , `cms_block` . `version_id` as `cms_block.versionId` , `cms_block` . `cms_section_version_id` as `cms_block.cmsSectionVersionId` , `cms_block` . `position` as `cms_block.position` , `cms_block` . `type` as `cms_block.type` , `cms_block` . `locked` as `cms_block.locked` , `cms_block` . `name` as `cms_block.name` , `cms_block` . `section_position` as `cms_block.sectionPosition` , `cms_block` . `margin_top` as `cms_block.marginTop` , `cms_block` . `margin_bottom` as `cms_block.marginBottom` , `cms_block` . `margin_left` as `cms_block.marginLeft` , `cms_block` . `margin_right` as `cms_block.marginRight` , `cms_block` . `background_color` as `cms_block.backgroundColor` , `cms_block` . `background_media_id` as `cms_block.backgroundMediaId` , `cms_block` . `background_media_mode` as `cms_block.backgroundMediaMode` , `cms_block` . `css_class` as `cms_block.cssClass` , `cms_block` . `visibility` as `cms_block.visibility` , `cms_block` . `cms_section_id` as `cms_block.sectionId` , `cms_block` . `custom_fields` as `cms_block.customFields` , `cms_block` . `created_at` as `cms_block.createdAt` , `cms_block` . `updated_at` as `cms_block.updatedAt` , `cms_block.backgroundMedia` . `id` as `cms_block.backgroundMedia.id` , `cms_block.backgroundMedia` . `user_id` as `cms_block.backgroundMedia.userId` , `cms_block.backgroundMedia` . `media_folder_id` as `cms_block.backgroundMedia.mediaFolderId` , `cms_block.backgroundMedia` . `mime_type` as `cms_block.backgroundMedia.mimeType` , `cms_block.backgroundMedia` . `file_extension` as `cms_block.backgroundMedia.fileExtension` , `cms_block.backgroundMedia` . `uploaded_at` as `cms_block.backgroundMedia.uploadedAt` , `cms_block.backgroundMedia` . `file_name` as `cms_block.backgroundMedia.fileName` , `cms_block.backgroundMedia` . `file_size` as `cms_block.backgroundMedia.fileSize` , `cms_block.backgroundMedia` . `media_type` as `cms_block.backgroundMedia.mediaTypeRaw` , `cms_block.backgroundMedia` . `meta_data` as `cms_block.backgroundMedia.metaData` , `cms_block.backgroundMedia` . `config` as `cms_block.backgroundMedia.config` , `cms_block.backgroundMedia` . `path` as `cms_block.backgroundMedia.path` , `cms_block.backgroundMedia` . `private` as `cms_block.backgroundMedia.private` , `cms_block.backgroundMedia` . `thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo` , `cms_block.backgroundMedia` . `file_hash` as `cms_block.backgroundMedia.fileHash` , `cms_block.backgroundMedia` . `created_at` as `cms_block.backgroundMedia.createdAt` , `cms_block.backgroundMedia` . `updated_at` as `cms_block.backgroundMedia.updatedAt` , `cms_block.backgroundMedia.translation.title` , `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title` , `cms_block.backgroundMedia.translation.alt` , `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt` , `cms_block.backgroundMedia.translation.customFields` , `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block` . `background_media_id` = `cms_block.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation` . `media_id` , `cms_block.backgroundMedia.translation` . `alt` as `cms_block.backgroundMedia.translation.alt` , `cms_block.backgroundMedia.translation` . `title` as `cms_block.backgroundMedia.translation.title` , `cms_block.backgroundMedia.translation` . `custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation` . `language_id` = ? ) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation` . `media_id` = `cms_block.backgroundMedia` . `id` WHERE (`cms_block` . `version_id` = ? ) AND (((`cms_block` . `cms_section_id` IN (? , ? ))))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%/š\x02 ûª=B)¾àÇ᤹Z\x1D "
b"/ó¶\x05 –ßA'Œç51˜)ûø "
]
SELECT
`cms_block` . `id` as `cms_block.id` ,
`cms_block` . `version_id` as `cms_block.versionId` ,
`cms_block` . `cms_section_version_id` as `cms_block.cmsSectionVersionId` ,
`cms_block` . `position` as `cms_block.position` ,
`cms_block` . `type` as `cms_block.type` ,
`cms_block` . `locked` as `cms_block.locked` ,
`cms_block` . `name` as `cms_block.name` ,
`cms_block` . `section_position` as `cms_block.sectionPosition` ,
`cms_block` . `margin_top` as `cms_block.marginTop` ,
`cms_block` . `margin_bottom` as `cms_block.marginBottom` ,
`cms_block` . `margin_left` as `cms_block.marginLeft` ,
`cms_block` . `margin_right` as `cms_block.marginRight` ,
`cms_block` . `background_color` as `cms_block.backgroundColor` ,
`cms_block` . `background_media_id` as `cms_block.backgroundMediaId` ,
`cms_block` . `background_media_mode` as `cms_block.backgroundMediaMode` ,
`cms_block` . `css_class` as `cms_block.cssClass` ,
`cms_block` . `visibility` as `cms_block.visibility` ,
`cms_block` . `cms_section_id` as `cms_block.sectionId` ,
`cms_block` . `custom_fields` as `cms_block.customFields` ,
`cms_block` . `created_at` as `cms_block.createdAt` ,
`cms_block` . `updated_at` as `cms_block.updatedAt` ,
`cms_block.backgroundMedia` . `id` as `cms_block.backgroundMedia.id` ,
`cms_block.backgroundMedia` . `user_id` as `cms_block.backgroundMedia.userId` ,
`cms_block.backgroundMedia` . `media_folder_id` as `cms_block.backgroundMedia.mediaFolderId` ,
`cms_block.backgroundMedia` . `mime_type` as `cms_block.backgroundMedia.mimeType` ,
`cms_block.backgroundMedia` . `file_extension` as `cms_block.backgroundMedia.fileExtension` ,
`cms_block.backgroundMedia` . `uploaded_at` as `cms_block.backgroundMedia.uploadedAt` ,
`cms_block.backgroundMedia` . `file_name` as `cms_block.backgroundMedia.fileName` ,
`cms_block.backgroundMedia` . `file_size` as `cms_block.backgroundMedia.fileSize` ,
`cms_block.backgroundMedia` . `media_type` as `cms_block.backgroundMedia.mediaTypeRaw` ,
`cms_block.backgroundMedia` . `meta_data` as `cms_block.backgroundMedia.metaData` ,
`cms_block.backgroundMedia` . `config` as `cms_block.backgroundMedia.config` ,
`cms_block.backgroundMedia` . `path` as `cms_block.backgroundMedia.path` ,
`cms_block.backgroundMedia` . `private` as `cms_block.backgroundMedia.private` ,
`cms_block.backgroundMedia` . `thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo` ,
`cms_block.backgroundMedia` . `file_hash` as `cms_block.backgroundMedia.fileHash` ,
`cms_block.backgroundMedia` . `created_at` as `cms_block.backgroundMedia.createdAt` ,
`cms_block.backgroundMedia` . `updated_at` as `cms_block.backgroundMedia.updatedAt` ,
`cms_block.backgroundMedia.translation.title` ,
`cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title` ,
`cms_block.backgroundMedia.translation.alt` ,
`cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt` ,
`cms_block.backgroundMedia.translation.customFields` ,
`cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields`
FROM
`cms_block`
LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block` . `background_media_id` = `cms_block.backgroundMedia` . `id`
LEFT JOIN (
SELECT
`cms_block.backgroundMedia.translation` . `media_id` ,
`cms_block.backgroundMedia.translation` . `alt` as `cms_block.backgroundMedia.translation.alt` ,
`cms_block.backgroundMedia.translation` . `title` as `cms_block.backgroundMedia.translation.title` ,
`cms_block.backgroundMedia.translation` . `custom_fields` as `cms_block.backgroundMedia.translation.customFields`
FROM
`media_translation` `cms_block.backgroundMedia.translation`
WHERE
`cms_block.backgroundMedia.translation` . `language_id` = ?
) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation` . `media_id` = `cms_block.backgroundMedia` . `id`
WHERE
(`cms_block` . `version_id` = ? )
AND (
(
(
`cms_block` . `cms_section_id` IN (? , ? )
)
)
)
Copy
SELECT `cms_block` . `id` as `cms_block.id` , `cms_block` . `version_id` as `cms_block.versionId` , `cms_block` . `cms_section_version_id` as `cms_block.cmsSectionVersionId` , `cms_block` . `position` as `cms_block.position` , `cms_block` . `type` as `cms_block.type` , `cms_block` . `locked` as `cms_block.locked` , `cms_block` . `name` as `cms_block.name` , `cms_block` . `section_position` as `cms_block.sectionPosition` , `cms_block` . `margin_top` as `cms_block.marginTop` , `cms_block` . `margin_bottom` as `cms_block.marginBottom` , `cms_block` . `margin_left` as `cms_block.marginLeft` , `cms_block` . `margin_right` as `cms_block.marginRight` , `cms_block` . `background_color` as `cms_block.backgroundColor` , `cms_block` . `background_media_id` as `cms_block.backgroundMediaId` , `cms_block` . `background_media_mode` as `cms_block.backgroundMediaMode` , `cms_block` . `css_class` as `cms_block.cssClass` , `cms_block` . `visibility` as `cms_block.visibility` , `cms_block` . `cms_section_id` as `cms_block.sectionId` , `cms_block` . `custom_fields` as `cms_block.customFields` , `cms_block` . `created_at` as `cms_block.createdAt` , `cms_block` . `updated_at` as `cms_block.updatedAt` , `cms_block.backgroundMedia` . `id` as `cms_block.backgroundMedia.id` , `cms_block.backgroundMedia` . `user_id` as `cms_block.backgroundMedia.userId` , `cms_block.backgroundMedia` . `media_folder_id` as `cms_block.backgroundMedia.mediaFolderId` , `cms_block.backgroundMedia` . `mime_type` as `cms_block.backgroundMedia.mimeType` , `cms_block.backgroundMedia` . `file_extension` as `cms_block.backgroundMedia.fileExtension` , `cms_block.backgroundMedia` . `uploaded_at` as `cms_block.backgroundMedia.uploadedAt` , `cms_block.backgroundMedia` . `file_name` as `cms_block.backgroundMedia.fileName` , `cms_block.backgroundMedia` . `file_size` as `cms_block.backgroundMedia.fileSize` , `cms_block.backgroundMedia` . `media_type` as `cms_block.backgroundMedia.mediaTypeRaw` , `cms_block.backgroundMedia` . `meta_data` as `cms_block.backgroundMedia.metaData` , `cms_block.backgroundMedia` . `config` as `cms_block.backgroundMedia.config` , `cms_block.backgroundMedia` . `path` as `cms_block.backgroundMedia.path` , `cms_block.backgroundMedia` . `private` as `cms_block.backgroundMedia.private` , `cms_block.backgroundMedia` . `thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo` , `cms_block.backgroundMedia` . `file_hash` as `cms_block.backgroundMedia.fileHash` , `cms_block.backgroundMedia` . `created_at` as `cms_block.backgroundMedia.createdAt` , `cms_block.backgroundMedia` . `updated_at` as `cms_block.backgroundMedia.updatedAt` , `cms_block.backgroundMedia.translation.title` , `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title` , `cms_block.backgroundMedia.translation.alt` , `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt` , `cms_block.backgroundMedia.translation.customFields` , `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block` . `background_media_id` = `cms_block.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation` . `media_id` , `cms_block.backgroundMedia.translation` . `alt` as `cms_block.backgroundMedia.translation.alt` , `cms_block.backgroundMedia.translation` . `title` as `cms_block.backgroundMedia.translation.title` , `cms_block.backgroundMedia.translation` . `custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation` . `media_id` = `cms_block.backgroundMedia` . `id` WHERE (`cms_block` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`cms_block` . `cms_section_id` IN (0x2F9A02FBAA3D4229BEE0C7E1A4B95A1D , 0x2FF3B60596DF41278CE735319829FBF8 ))));
Copy
13
0.23 ms
SELECT `cms_slot` . `id` as `cms_slot.id` , `cms_slot` . `version_id` as `cms_slot.versionId` , `cms_slot` . `cms_block_version_id` as `cms_slot.cmsBlockVersionId` , `cms_slot` . `type` as `cms_slot.type` , `cms_slot` . `slot` as `cms_slot.slot` , `cms_slot` . `locked` as `cms_slot.locked` , `cms_slot` . `cms_block_id` as `cms_slot.blockId` , `cms_slot` . `created_at` as `cms_slot.createdAt` , `cms_slot` . `updated_at` as `cms_slot.updatedAt` , `cms_slot.translation.config` , `cms_slot.translation.config` as `cms_slot.config` , `cms_slot.translation.customFields` , `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation` . `cms_slot_id` , `cms_slot.translation` . `cms_slot_version_id` , `cms_slot.translation` . `config` as `cms_slot.translation.config` , `cms_slot.translation` . `custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation` . `language_id` = ? ) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation` . `cms_slot_id` = `cms_slot` . `id` AND `cms_slot.cms_slot_translation` . `cms_slot_version_id` = `cms_slot` . `version_id` WHERE (`cms_slot` . `version_id` = ? ) AND (((`cms_slot` . `cms_block_id` IN (? , ? , ? , ? ))))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%‚Ä|°LžCl„ÌFI2¡4J "
b"ŽÇE\t ø\r IÚ–„Á¬Î\x10\x1D "
b"æôe‚ßhNÿ¦$oñ˶‡m "
b"™,ÉX}\x1C FÀº\x1F ¥p{J«< "
]
SELECT `cms_slot` . `id` as `cms_slot.id` , `cms_slot` . `version_id` as `cms_slot.versionId` , `cms_slot` . `cms_block_version_id` as `cms_slot.cmsBlockVersionId` , `cms_slot` . `type` as `cms_slot.type` , `cms_slot` . `slot` as `cms_slot.slot` , `cms_slot` . `locked` as `cms_slot.locked` , `cms_slot` . `cms_block_id` as `cms_slot.blockId` , `cms_slot` . `created_at` as `cms_slot.createdAt` , `cms_slot` . `updated_at` as `cms_slot.updatedAt` , `cms_slot.translation.config` , `cms_slot.translation.config` as `cms_slot.config` , `cms_slot.translation.customFields` , `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation` . `cms_slot_id` , `cms_slot.translation` . `cms_slot_version_id` , `cms_slot.translation` . `config` as `cms_slot.translation.config` , `cms_slot.translation` . `custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation` . `cms_slot_id` = `cms_slot` . `id` AND `cms_slot.cms_slot_translation` . `cms_slot_version_id` = `cms_slot` . `version_id` WHERE (`cms_slot` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`cms_slot` . `cms_block_id` IN (0x82C47CB04C9E436C84CC464932A1344A , 0x8EC74509F80D49DA9684C1AC9DCE101D , 0xE6F46582DF684EFFA6246FF1CBB6876D , 0x992CC9587D1C46C0BA1FA5707B4AAB3C ))));
Copy
14
0.20 ms
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = ? ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"´ \x18 ·vGÉ‹\t\x17 DV;ûÍ "
]
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (0xB4A018B7768147C98B091744563BFBCD ); Copy
15
0.11 ms
SELECT `product_sorting` . `id` FROM `product_sorting` WHERE (`product_sorting` . `active` = ? ) ORDER BY `product_sorting` . `priority` DESC
SELECT `product_sorting` . `id` FROM `product_sorting` WHERE (`product_sorting` . `active` = 1 ) ORDER BY `product_sorting` . `priority` DESC ;
Copy
16
0.20 ms
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = ? ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"´ \x18 ·vGÉ‹\t\x17 DV;ûÍ "
b"""
\Ú\x06 .~GΔ\x15 d¼¾\x05 \n
«
"""
b"ëbxQRjE-¸Ùc™#é!° "
b"X`\r üN$N ©\x1F P\x1A ‚}8ž "
b"~sÌ+¤ÝJá‘\t dA\\x16 vJ "
b"–7JüB½A’¥Š\x1F r«—Gà "
b"\x06 jkîü~Kn‰)ÖL(ˆ¥\x1A "?xÂbúL¿ŸÕ1œ1Q±& "
]
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (0xB4A018B7768147C98B091744563BFBCD , 0x5CDA06202E7E47CE941564BCBE050AAB , 0xEB627851526A452DB8D9639923E921B0 , 0x58600DFC4E244E20A91F501A827D389E , 0x7E73CC2BA4DD4AE1910964415C16764A , 0x96374AFC42BD4192A58A1F72AB9747C3 , 0x066A6BEEFC7E4B6E8929D64C2888A51A , 0x223F78C262FA4CBF9FD5319C3151B126 );
Copy
17
0.16 ms
SELECT `category` . `id` , `category` . `auto_increment` FROM `category` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? )) LIMIT 1
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%;³'JWðKÉ—\f y_-ýÛå "
]
SELECT `category` . `id` , `category` . `auto_increment` FROM `category` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x3BB3274A57F04BC9970C795F2DFDDBE5 )) LIMIT 1 ;
Copy
18
0.14 ms
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%;³'JWðKÉ—\f y_-ýÛå "
]
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x3BB3274A57F04BC9970C795F2DFDDBE5 ));
Copy
19
5.78 ms
SELECT `product` . `id` , `product` . `product_number` , `product` . `auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product` . `id` = `product.categoriesRo.mapping` . `product_id` AND `product` . `version_id` = `product.categoriesRo.mapping` . `product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping` . `category_id` = `product.categoriesRo` . `id` AND `product.categoriesRo` . `version_id` = `product.categoriesRo.mapping` . `category_version_id` WHERE (`product` . `version_id` = ? ) AND ((((`product.visibilities` . `visibility` > = ? ) AND `product.visibilities` . `sales_channel_id` = ? AND IFNULL (`product` . `active` , `product.parent` . `active` ) = ? ) AND `product.categoriesRo` . `id` = ? AND NOT (`product` . `display_group` < = > ? ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > ? AND `product` . `available` < = > ? ))) GROUP BY `product` . `display_group` ORDER BY MIN (`product` . `product_number` ) ASC , MIN (`product` . `id` ) ASC LIMIT 24 OFFSET 360
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%30
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
true
b";³'JWðKÉ—\f y_-ýÛå "
null
true
false
]
SELECT `product` . `id` , `product` . `product_number` , `product` . `auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product` . `id` = `product.categoriesRo.mapping` . `product_id` AND `product` . `version_id` = `product.categoriesRo.mapping` . `product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping` . `category_id` = `product.categoriesRo` . `id` AND `product.categoriesRo` . `version_id` = `product.categoriesRo.mapping` . `category_version_id` WHERE (`product` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((((`product.visibilities` . `visibility` > = 30 ) AND `product.visibilities` . `sales_channel_id` = 0xCD6592C636AE4BF38378B01A9B31E46D AND IFNULL (`product` . `active` , `product.parent` . `active` ) = 1 ) AND `product.categoriesRo` . `id` = 0x3BB3274A57F04BC9970C795F2DFDDBE5 AND NOT (`product` . `display_group` < = > NULL ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > 1 AND `product` . `available` < = > 0 ))) GROUP BY `product` . `display_group` ORDER BY MIN (`product` . `product_number` ) ASC , MIN (`product` . `id` ) ASC LIMIT 24 OFFSET 360 ;
Copy
20
3.38 ms
SELECT COUNT (* ) FROM (
SELECT `product` . `id` , `product` . `product_number` , `product` . `auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product` . `id` = `product.categoriesRo.mapping` . `product_id` AND `product` . `version_id` = `product.categoriesRo.mapping` . `product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping` . `category_id` = `product.categoriesRo` . `id` AND `product.categoriesRo` . `version_id` = `product.categoriesRo.mapping` . `category_version_id` WHERE (`product` . `version_id` = ? ) AND ((((`product.visibilities` . `visibility` > = ? ) AND `product.visibilities` . `sales_channel_id` = ? AND IFNULL (`product` . `active` , `product.parent` . `active` ) = ? ) AND `product.categoriesRo` . `id` = ? AND NOT (`product` . `display_group` < = > ? ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > ? AND `product` . `available` < = > ? ))) GROUP BY `product` . `display_group` ) total
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%30
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
true
b";³'JWðKÉ—\f y_-ýÛå "
null
true
false
]
SELECT COUNT (* ) FROM (
SELECT `product` . `id` , `product` . `product_number` , `product` . `auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product` . `id` = `product.categoriesRo.mapping` . `product_id` AND `product` . `version_id` = `product.categoriesRo.mapping` . `product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping` . `category_id` = `product.categoriesRo` . `id` AND `product.categoriesRo` . `version_id` = `product.categoriesRo.mapping` . `category_version_id` WHERE (`product` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((((`product.visibilities` . `visibility` > = 30 ) AND `product.visibilities` . `sales_channel_id` = 0xCD6592C636AE4BF38378B01A9B31E46D AND IFNULL (`product` . `active` , `product.parent` . `active` ) = 1 ) AND `product.categoriesRo` . `id` = 0x3BB3274A57F04BC9970C795F2DFDDBE5 AND NOT (`product` . `display_group` < = > NULL ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > 1 AND `product` . `available` < = > 0 ))) GROUP BY `product` . `display_group` ) total ; Copy
21
12.77 ms
SELECT LOWER (HEX (`product.properties` . `id` )) as `properties.key` , COUNT (`product` . `id` ) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product` . `id` = `product.categoriesRo.mapping` . `product_id` AND `product` . `version_id` = `product.categoriesRo.mapping` . `product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product` . `properties` = `product.properties.mapping` . `product_id` AND `product` . `version_id` = `product.properties.mapping` . `product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping` . `category_id` = `product.categoriesRo` . `id` AND `product.categoriesRo` . `version_id` = `product.categoriesRo.mapping` . `category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping` . `property_group_option_id` = `product.properties` . `id` WHERE (`product` . `version_id` = ? ) AND ((((`product.visibilities` . `visibility` > = ? ) AND `product.visibilities` . `sales_channel_id` = ? AND IFNULL (`product` . `active` , `product.parent` . `active` ) = ? ) AND `product.categoriesRo` . `id` = ? AND NOT (`product` . `display_group` < = > ? ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > ? AND `product` . `available` < = > ? ))) GROUP BY `product.properties` . `id`
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%30
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
true
b";³'JWðKÉ—\f y_-ýÛå "
null
true
false
]
SELECT LOWER (HEX (`product.properties` . `id` )) as `properties.key` , COUNT (`product` . `id` ) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product` . `id` = `product.categoriesRo.mapping` . `product_id` AND `product` . `version_id` = `product.categoriesRo.mapping` . `product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product` . `properties` = `product.properties.mapping` . `product_id` AND `product` . `version_id` = `product.properties.mapping` . `product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping` . `category_id` = `product.categoriesRo` . `id` AND `product.categoriesRo` . `version_id` = `product.categoriesRo.mapping` . `category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping` . `property_group_option_id` = `product.properties` . `id` WHERE (`product` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((((`product.visibilities` . `visibility` > = 30 ) AND `product.visibilities` . `sales_channel_id` = 0xCD6592C636AE4BF38378B01A9B31E46D AND IFNULL (`product` . `active` , `product.parent` . `active` ) = 1 ) AND `product.categoriesRo` . `id` = 0x3BB3274A57F04BC9970C795F2DFDDBE5 AND NOT (`product` . `display_group` < = > NULL ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > 1 AND `product` . `available` < = > 0 ))) GROUP BY `product.properties` . `id` ;
Copy
22
3.06 ms
SELECT LOWER (HEX (`product.options` . `id` )) as `options.key` , COUNT (`product` . `id` ) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product` . `id` = `product.categoriesRo.mapping` . `product_id` AND `product` . `version_id` = `product.categoriesRo.mapping` . `product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product` . `id` = `product.options.mapping` . `product_id` AND `product` . `version_id` = `product.options.mapping` . `product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping` . `category_id` = `product.categoriesRo` . `id` AND `product.categoriesRo` . `version_id` = `product.categoriesRo.mapping` . `category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping` . `property_group_option_id` = `product.options` . `id` WHERE (`product` . `version_id` = ? ) AND ((((`product.visibilities` . `visibility` > = ? ) AND `product.visibilities` . `sales_channel_id` = ? AND IFNULL (`product` . `active` , `product.parent` . `active` ) = ? ) AND `product.categoriesRo` . `id` = ? AND NOT (`product` . `display_group` < = > ? ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > ? AND `product` . `available` < = > ? ))) GROUP BY `product.options` . `id`
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%30
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
true
b";³'JWðKÉ—\f y_-ýÛå "
null
true
false
]
SELECT LOWER (HEX (`product.options` . `id` )) as `options.key` , COUNT (`product` . `id` ) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product` . `id` = `product.categoriesRo.mapping` . `product_id` AND `product` . `version_id` = `product.categoriesRo.mapping` . `product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product` . `id` = `product.options.mapping` . `product_id` AND `product` . `version_id` = `product.options.mapping` . `product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping` . `category_id` = `product.categoriesRo` . `id` AND `product.categoriesRo` . `version_id` = `product.categoriesRo.mapping` . `category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping` . `property_group_option_id` = `product.options` . `id` WHERE (`product` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((((`product.visibilities` . `visibility` > = 30 ) AND `product.visibilities` . `sales_channel_id` = 0xCD6592C636AE4BF38378B01A9B31E46D AND IFNULL (`product` . `active` , `product.parent` . `active` ) = 1 ) AND `product.categoriesRo` . `id` = 0x3BB3274A57F04BC9970C795F2DFDDBE5 AND NOT (`product` . `display_group` < = > NULL ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > 1 AND `product` . `available` < = > 0 ))) GROUP BY `product.options` . `id` ;
Copy
23
0.49 ms
SELECT
parent . variant_listing_config as variantListingConfig ,
LOWER (HEX (child . id )) as id ,
LOWER (HEX (parent . id )) as parentId
FROM product as child
INNER JOIN product as parent
ON parent . id = child . parent_id
AND parent . version_id = child . version_id
WHERE child . version_id = ?
AND child . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%Ø2\x7F ÛpI\x02 ”¦X\x11 Y\x11 º "
b"të·\x19 ݉Jöš{Õ°K‹ç "
b"Ë\t 7™ƒ^LÀ¯U¦<ÀH±\f "
b"\v Ý©t,žEÒ©#ÓuâÂôµ\x06 :Á_î=D\r ‚àÖ;¢0˜¼w.\x17 kCE_†±„iä]{\x7F "
b"Š¸´\x04\x12 ®NŽ˜·kÁu/ðz "
b"!©\r 7\t\x1F F”_ñtW}$ "
b"„¨ò¨I;E?¬m5¾Pƒò "
b"ø`\x12 “\x15 õC\x02 °\x05\x08 ‰Ñ|i¯ "
b"Ý2Ž!)ùA¤ŽøŠªþ,¤å "
b"‚g}\x0F öLG»‹ãÏéI—\x07 "
b",$X>†îN¶ž\x00\f ©;ÌÚ! "
b"šN\x1D ªfåAó‘ž\x00 ¬Ï÷%J "
b"N©¸l\x7F JI›\x01 1&y¢\x1A Ž "
b"p¯[|§\x15 N²‹ j®Hñ.~ "
b"ßÛ2úºXOm£\x1C S¬ÃhÄu "
b"˜SÙ9\x1C H}¡‰qÝ<©Î, "
b"]ÍÍS£¶G³‚'Í\x1A\t Êb5 "
b"{úøIF<K£§“õ\x1E i\e ôÄ "
b"†Ã:©›Mt¡okUb¤Lœ "
b"EÊ\r Ü@E^§ƒÊéd—t— "
b"¡U2gA4GN‰ûZw\x17 pŽ¡ "
b""Ï'“¡æMˆŠ‹\f „±"+ë "
]
SELECT
parent . variant_listing_config as variantListingConfig ,
LOWER (HEX (child . id )) as id ,
LOWER (HEX (parent . id )) as parentId
FROM product as child
INNER JOIN product as parent
ON parent . id = child . parent_id
AND parent . version_id = child . version_id
WHERE child . version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425
AND child . id IN (0xC398327FDB70490294A6581159118FBA , 0x74EBB719DD894AF69A7BC395B04B8BE7 , 0xCB093799835E4CC0AF55A63CC048B10C , 0x0BDDA9742C9E45D2A923D375E2C2F4B5 , 0x063AC15FEE3D440D82E0D69D3BA23098 , 0xBC772E176B43455F86B18469E45D7B7F , 0x8AB8B40412AE4E8E98B76BC1752FF07A , 0x21A90D37091F46948F5F81F174577D24 , 0x84A8F2A8493B453FAC6DAD35BE5083F2 , 0xF860129315F54302B0050889D17C69AF , 0xDD328E2129F941A48EF88AAAFE2CA4E5 , 0x82677D0FF64C47BB8F8BE3CFE9499707 , 0x2C24583E86EE4EB69E000CA93BCCDA21 , 0x9A4E1DAA66E541F3919E00ACCFF7254A , 0x4EA9B86C9D7F4A499B01312679A21A8E , 0x70AF5B7CA7154EB28BA06AAE48F12E7E , 0xDFDB32FABA584F6DA31C53ACC368C475 , 0x9853D9AD391C487DA18971DD3CA9CE2C , 0x5DCDCD53A3B647B38227CD1A09CA6235 , 0x7BFAF849463C4BA3A793F51E691BF4C4 , 0x86C33AA9909B4D74A16F6B5562A44C9C , 0xAD45CA0DDC40455EA783CAE964977497 , 0xA15532674134474E89FB5A7717708EA1 , 0x22CF2793A1E64D888A8B0C84B1222BEB );
Copy
24
0.66 ms
SELECT `product` . `id` , `product` . `product_number` , `product` . `auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id WHERE (`product` . `version_id` = ? ) AND ((((`product.visibilities` . `visibility` > = ? ) AND `product.visibilities` . `sales_channel_id` = ? AND IFNULL (`product` . `active` , `product.parent` . `active` ) = ? ))) AND (`product` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) GROUP BY `product` . `id`
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%10
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
true
b"Ø2\x7F ÛpI\x02 ”¦X\x11 Y\x11 º "
b"të·\x19 ݉Jöš{Õ°K‹ç "
b"Ë\t 7™ƒ^LÀ¯U¦<ÀH±\f "
b"\v Ý©t,žEÒ©#ÓuâÂôµ\x06 :Á_î=D\r ‚àÖ;¢0˜¼w.\x17 kCE_†±„iä]{\x7F "
b"Š¸´\x04\x12 ®NŽ˜·kÁu/ðz "
b"!©\r 7\t\x1F F”_ñtW}$ "
b"„¨ò¨I;E?¬m5¾Pƒò "
b"ø`\x12 “\x15 õC\x02 °\x05\x08 ‰Ñ|i¯ "
b"Ý2Ž!)ùA¤ŽøŠªþ,¤å "
b"‚g}\x0F öLG»‹ãÏéI—\x07 "
b",$X>†îN¶ž\x00\f ©;ÌÚ! "
b"šN\x1D ªfåAó‘ž\x00 ¬Ï÷%J "
b"N©¸l\x7F JI›\x01 1&y¢\x1A Ž "
b"p¯[|§\x15 N²‹ j®Hñ.~ "
b"ßÛ2úºXOm£\x1C S¬ÃhÄu "
b"˜SÙ9\x1C H}¡‰qÝ<©Î, "
b"]ÍÍS£¶G³‚'Í\x1A\t Êb5 "
b"{úøIF<K£§“õ\x1E i\e ôÄ "
b"†Ã:©›Mt¡okUb¤Lœ "
b"EÊ\r Ü@E^§ƒÊéd—t— "
b"¡U2gA4GN‰ûZw\x17 pŽ¡ "
b""Ï'“¡æMˆŠ‹\f „±"+ë "
]
SELECT `product` . `id` , `product` . `product_number` , `product` . `auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product` . `visibilities` = `product.visibilities` . `product_id` AND `product` . version_id = `product.visibilities` . product_version_id WHERE (`product` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((((`product.visibilities` . `visibility` > = 10 ) AND `product.visibilities` . `sales_channel_id` = 0xCD6592C636AE4BF38378B01A9B31E46D AND IFNULL (`product` . `active` , `product.parent` . `active` ) = 1 ))) AND (`product` . `id` IN (0xC398327FDB70490294A6581159118FBA , 0x74EBB719DD894AF69A7BC395B04B8BE7 , 0xCB093799835E4CC0AF55A63CC048B10C , 0x0BDDA9742C9E45D2A923D375E2C2F4B5 , 0x063AC15FEE3D440D82E0D69D3BA23098 , 0xBC772E176B43455F86B18469E45D7B7F , 0x8AB8B40412AE4E8E98B76BC1752FF07A , 0x21A90D37091F46948F5F81F174577D24 , 0x84A8F2A8493B453FAC6DAD35BE5083F2 , 0xF860129315F54302B0050889D17C69AF , 0xDD328E2129F941A48EF88AAAFE2CA4E5 , 0x82677D0FF64C47BB8F8BE3CFE9499707 , 0x2C24583E86EE4EB69E000CA93BCCDA21 , 0x9A4E1DAA66E541F3919E00ACCFF7254A , 0x4EA9B86C9D7F4A499B01312679A21A8E , 0x70AF5B7CA7154EB28BA06AAE48F12E7E , 0xDFDB32FABA584F6DA31C53ACC368C475 , 0x9853D9AD391C487DA18971DD3CA9CE2C , 0x5DCDCD53A3B647B38227CD1A09CA6235 , 0x7BFAF849463C4BA3A793F51E691BF4C4 , 0x86C33AA9909B4D74A16F6B5562A44C9C , 0xAD45CA0DDC40455EA783CAE964977497 , 0xA15532674134474E89FB5A7717708EA1 , 0x22CF2793A1E64D888A8B0C84B1222BEB )) GROUP BY `product` . `id` ;
Copy
25
86.24 ms
SELECT `product` . `id` as `product.id` , `product` . `version_id` as `product.versionId` , `product` . `parent_id` as `product.parentId` , `product` . `parent_version_id` as `product.parentVersionId` , COALESCE (`product` . `product_manufacturer_id` , `product.parent` . `product_manufacturer_id` ) as `product.manufacturerId` , COALESCE (`product` . `product_manufacturer_version_id` , `product.parent` . `product_manufacturer_version_id` ) as `product.productManufacturerVersionId` , COALESCE (`product` . `unit_id` , `product.parent` . `unit_id` ) as `product.unitId` , COALESCE (`product` . `tax_id` , `product.parent` . `tax_id` ) as `product.taxId` , COALESCE (`product` . `product_media_id` , `product.parent` . `product_media_id` ) as `product.coverId` , COALESCE (`product` . `product_media_version_id` , `product.parent` . `product_media_version_id` ) as `product.productMediaVersionId` , COALESCE (`product` . `delivery_time_id` , `product.parent` . `delivery_time_id` ) as `product.deliveryTimeId` , COALESCE (`product` . `product_feature_set_id` , `product.parent` . `product_feature_set_id` ) as `product.featureSetId` , COALESCE (`product` . `canonical_product_id` , `product.parent` . `canonical_product_id` ) as `product.canonicalProductId` , COALESCE (`product` . `canonical_product_version_id` , `product.parent` . `canonical_product_version_id` ) as `product.canonicalProductVersionId` , COALESCE (`product` . `cms_page_id` , `product.parent` . `cms_page_id` ) as `product.cmsPageId` , COALESCE (`product` . `cms_page_version_id` , `product.parent` . `cms_page_version_id` ) as `product.cmsPageVersionId` , `product.parent` . `price` as `product.price.inherited` , COALESCE (`product` . `price` , `product.parent` . `price` ) as `product.price` , `product` . `product_number` as `product.productNumber` , COALESCE (`product` . `restock_time` , `product.parent` . `restock_time` ) as `product.restockTime` , `product` . `auto_increment` as `product.autoIncrement` , COALESCE (`product` . `active` , `product.parent` . `active` ) as `product.active` , `product` . `available` as `product.available` , COALESCE (`product` . `is_closeout` , `product.parent` . `is_closeout` ) as `product.isCloseout` , `product` . `available_stock` as `product.availableStock` , `product` . `stock` as `product.stock` , `product` . `display_group` as `product.displayGroup` , `product.parent` . `variant_listing_config` as `product.variantListingConfig.inherited` , COALESCE (`product` . `variant_listing_config` , `product.parent` . `variant_listing_config` ) as `product.variantListingConfig` , `product` . `variant_restrictions` as `product.variantRestrictions` , COALESCE (`product` . `manufacturer_number` , `product.parent` . `manufacturer_number` ) as `product.manufacturerNumber` , COALESCE (`product` . `ean` , `product.parent` . `ean` ) as `product.ean` , COALESCE (`product` . `purchase_steps` , `product.parent` . `purchase_steps` ) as `product.purchaseSteps` , COALESCE (`product` . `max_purchase` , `product.parent` . `max_purchase` ) as `product.maxPurchase` , COALESCE (`product` . `min_purchase` , `product.parent` . `min_purchase` ) as `product.minPurchase` , COALESCE (`product` . `purchase_unit` , `product.parent` . `purchase_unit` ) as `product.purchaseUnit` , COALESCE (`product` . `reference_unit` , `product.parent` . `reference_unit` ) as `product.referenceUnit` , COALESCE (`product` . `shipping_free` , `product.parent` . `shipping_free` ) as `product.shippingFree` , `product.parent` . `purchase_prices` as `product.purchasePrices.inherited` , COALESCE (`product` . `purchase_prices` , `product.parent` . `purchase_prices` ) as `product.purchasePrices` , COALESCE (`product` . `mark_as_topseller` , `product.parent` . `mark_as_topseller` ) as `product.markAsTopseller` , COALESCE (`product` . `weight` , `product.parent` . `weight` ) as `product.weight` , COALESCE (`product` . `width` , `product.parent` . `width` ) as `product.width` , COALESCE (`product` . `height` , `product.parent` . `height` ) as `product.height` , COALESCE (`product` . `length` , `product.parent` . `length` ) as `product.length` , COALESCE (`product` . `release_date` , `product.parent` . `release_date` ) as `product.releaseDate` , COALESCE (`product` . `rating_average` , `product.parent` . `rating_average` ) as `product.ratingAverage` , `product.parent` . `category_tree` as `product.categoryTree.inherited` , COALESCE (`product` . `category_tree` , `product.parent` . `category_tree` ) as `product.categoryTree` , `product.parent` . `property_ids` as `product.propertyIds.inherited` , COALESCE (`product` . `property_ids` , `product.parent` . `property_ids` ) as `product.propertyIds` , `product.parent` . `option_ids` as `product.optionIds.inherited` , COALESCE (`product` . `option_ids` , `product.parent` . `option_ids` ) as `product.optionIds` , `product.parent` . `stream_ids` as `product.streamIds.inherited` , COALESCE (`product` . `stream_ids` , `product.parent` . `stream_ids` ) as `product.streamIds` , `product.parent` . `tag_ids` as `product.tagIds.inherited` , COALESCE (`product` . `tag_ids` , `product.parent` . `tag_ids` ) as `product.tagIds` , `product.parent` . `category_ids` as `product.categoryIds.inherited` , COALESCE (`product` . `category_ids` , `product.parent` . `category_ids` ) as `product.categoryIds` , `product` . `child_count` as `product.childCount` , COALESCE (`product` . `custom_field_set_selection_active` , `product.parent` . `custom_field_set_selection_active` ) as `product.customFieldSetSelectionActive` , `product` . `sales` as `product.sales` , `product` . `states` as `product.states` , `product.parent` . `cheapest_price` as `product.cheapestPrice.inherited` , COALESCE (`product` . `cheapest_price` , `product.parent` . `cheapest_price` ) as `product.cheapestPrice` , `product` . `created_at` as `product.createdAt` , `product` . `updated_at` as `product.updatedAt` , `product.manufacturer` . `id` as `product.manufacturer.id` , `product.manufacturer` . `version_id` as `product.manufacturer.versionId` , `product.manufacturer` . `media_id` as `product.manufacturer.mediaId` , `product.manufacturer` . `created_at` as `product.manufacturer.createdAt` , `product.manufacturer` . `updated_at` as `product.manufacturer.updatedAt` , `product.manufacturer.translation.name` , `product.manufacturer.translation.name` as `product.manufacturer.name` , `product.manufacturer.translation.link` , `product.manufacturer.translation.link` as `product.manufacturer.link` , `product.manufacturer.translation.description` , `product.manufacturer.translation.description` as `product.manufacturer.description` , `product.manufacturer.translation.customFields` , `product.manufacturer.translation.customFields` as `product.manufacturer.customFields` , (SELECT GROUP_CONCAT (HEX (`product.options.mapping` . `property_group_option_id` ) SEPARATOR '||' )
FROM `product_option` `product.options.mapping`
WHERE `product.options.mapping` . `product_id` = `product` . `id` ) as `product.options.id_mapping` , `product.unit` . `id` as `product.unit.id` , `product.unit` . `created_at` as `product.unit.createdAt` , `product.unit` . `updated_at` as `product.unit.updatedAt` , `product.unit.translation.shortCode` , `product.unit.translation.shortCode` as `product.unit.shortCode` , `product.unit.translation.name` , `product.unit.translation.name` as `product.unit.name` , `product.unit.translation.customFields` , `product.unit.translation.customFields` as `product.unit.customFields` , `product.deliveryTime` . `id` as `product.deliveryTime.id` , `product.deliveryTime` . `min` as `product.deliveryTime.min` , `product.deliveryTime` . `max` as `product.deliveryTime.max` , `product.deliveryTime` . `unit` as `product.deliveryTime.unit` , `product.deliveryTime` . `created_at` as `product.deliveryTime.createdAt` , `product.deliveryTime` . `updated_at` as `product.deliveryTime.updatedAt` , `product.deliveryTime.translation.name` , `product.deliveryTime.translation.name` as `product.deliveryTime.name` , `product.deliveryTime.translation.customFields` , `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields` , `product.cover` . `id` as `product.cover.id` , `product.cover` . `version_id` as `product.cover.versionId` , `product.cover` . `product_id` as `product.cover.productId` , `product.cover` . `product_version_id` as `product.cover.productVersionId` , `product.cover` . `media_id` as `product.cover.mediaId` , `product.cover` . `position` as `product.cover.position` , `product.cover` . `custom_fields` as `product.cover.customFields` , `product.cover` . `created_at` as `product.cover.createdAt` , `product.cover` . `updated_at` as `product.cover.updatedAt` , `product.cover.media` . `id` as `product.cover.media.id` , `product.cover.media` . `user_id` as `product.cover.media.userId` , `product.cover.media` . `media_folder_id` as `product.cover.media.mediaFolderId` , `product.cover.media` . `mime_type` as `product.cover.media.mimeType` , `product.cover.media` . `file_extension` as `product.cover.media.fileExtension` , `product.cover.media` . `uploaded_at` as `product.cover.media.uploadedAt` , `product.cover.media` . `file_name` as `product.cover.media.fileName` , `product.cover.media` . `file_size` as `product.cover.media.fileSize` , `product.cover.media` . `media_type` as `product.cover.media.mediaTypeRaw` , `product.cover.media` . `meta_data` as `product.cover.media.metaData` , `product.cover.media` . `config` as `product.cover.media.config` , `product.cover.media` . `path` as `product.cover.media.path` , `product.cover.media` . `private` as `product.cover.media.private` , `product.cover.media` . `thumbnails_ro` as `product.cover.media.thumbnailsRo` , `product.cover.media` . `file_hash` as `product.cover.media.fileHash` , `product.cover.media` . `created_at` as `product.cover.media.createdAt` , `product.cover.media` . `updated_at` as `product.cover.media.updatedAt` , `product.cover.media.translation.title` , `product.cover.media.translation.title` as `product.cover.media.title` , `product.cover.media.translation.alt` , `product.cover.media.translation.alt` as `product.cover.media.alt` , `product.cover.media.translation.customFields` , `product.cover.media.translation.customFields` as `product.cover.media.customFields` , `product.tax` . `id` as `product.tax.id` , `product.tax` . `tax_rate` as `product.tax.taxRate` , `product.tax` . `name` as `product.tax.name` , `product.tax` . `position` as `product.tax.position` , `product.tax` . `custom_fields` as `product.tax.customFields` , `product.tax` . `created_at` as `product.tax.createdAt` , `product.tax` . `updated_at` as `product.tax.updatedAt` , `product.translation.metaDescription` , `product.parent.translation.metaDescription` , COALESCE (`product.translation.metaDescription` , `product.parent.translation.metaDescription` ) as `product.metaDescription` , `product.translation.name` , `product.parent.translation.name` , COALESCE (`product.translation.name` , `product.parent.translation.name` ) as `product.name` , `product.translation.keywords` , `product.parent.translation.keywords` , COALESCE (`product.translation.keywords` , `product.parent.translation.keywords` ) as `product.keywords` , `product.translation.description` , `product.parent.translation.description` , COALESCE (`product.translation.description` , `product.parent.translation.description` ) as `product.description` , `product.translation.metaTitle` , `product.parent.translation.metaTitle` , COALESCE (`product.translation.metaTitle` , `product.parent.translation.metaTitle` ) as `product.metaTitle` , `product.translation.packUnit` , `product.parent.translation.packUnit` , COALESCE (`product.translation.packUnit` , `product.parent.translation.packUnit` ) as `product.packUnit` , `product.translation.packUnitPlural` , `product.parent.translation.packUnitPlural` , COALESCE (`product.translation.packUnitPlural` , `product.parent.translation.packUnitPlural` ) as `product.packUnitPlural` , `product.translation.customSearchKeywords` , `product.parent.translation.customSearchKeywords` , COALESCE (`product.translation.customSearchKeywords` , `product.parent.translation.customSearchKeywords` ) as `product.customSearchKeywords` , `product.translation.slotConfig` , `product.parent.translation.slotConfig` , COALESCE (`product.translation.slotConfig` , `product.parent.translation.slotConfig` ) as `product.slotConfig` , `product.translation.customFields` , `product.parent.translation.customFields` , COALESCE (`product.translation.customFields` , `product.parent.translation.customFields` ) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product` . `manufacturer` = `product.manufacturer` . `id` AND IFNULL (`product` . `product_manufacturer_version_id` , `product.parent` . `product_manufacturer_version_id` ) = `product.manufacturer` . `version_id` LEFT JOIN `unit` `product.unit` ON `product` . `unit` = `product.unit` . `id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product` . `deliveryTime` = `product.deliveryTime` . `id` LEFT JOIN `product_media` `product.cover` ON `product` . `cover` = `product.cover` . `id` AND IFNULL (`product` . `product_media_version_id` , `product.parent` . `product_media_version_id` ) = `product.cover` . `version_id` LEFT JOIN `tax` `product.tax` ON `product` . `tax` = `product.tax` . `id` LEFT JOIN (SELECT `product.translation` . `product_id` , `product.translation` . `product_version_id` , `product.translation` . `meta_description` as `product.translation.metaDescription` , `product.translation` . `name` as `product.translation.name` , `product.translation` . `keywords` as `product.translation.keywords` , `product.translation` . `description` as `product.translation.description` , `product.translation` . `meta_title` as `product.translation.metaTitle` , `product.translation` . `pack_unit` as `product.translation.packUnit` , `product.translation` . `pack_unit_plural` as `product.translation.packUnitPlural` , `product.translation` . `custom_fields` as `product.translation.customFields` , `product.translation` . `slot_config` as `product.translation.slotConfig` , `product.translation` . `custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation` . `language_id` = ? ) `product.product_translation` ON `product.product_translation` . `product_id` = `product` . `id` AND `product.product_translation` . `product_version_id` = `product` . `version_id` LEFT JOIN (SELECT `product.parent.translation` . `product_id` , `product.parent.translation` . `product_version_id` , `product.parent.translation` . `meta_description` as `product.parent.translation.metaDescription` , `product.parent.translation` . `name` as `product.parent.translation.name` , `product.parent.translation` . `keywords` as `product.parent.translation.keywords` , `product.parent.translation` . `description` as `product.parent.translation.description` , `product.parent.translation` . `meta_title` as `product.parent.translation.metaTitle` , `product.parent.translation` . `pack_unit` as `product.parent.translation.packUnit` , `product.parent.translation` . `pack_unit_plural` as `product.parent.translation.packUnitPlural` , `product.parent.translation` . `custom_fields` as `product.parent.translation.customFields` , `product.parent.translation` . `slot_config` as `product.parent.translation.slotConfig` , `product.parent.translation` . `custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation` . `language_id` = ? ) `product.parent.product_translation` ON `product.parent.product_translation` . `product_id` = `product.parent` . `id` AND `product.parent.product_translation` . `product_version_id` = `product.parent` . `version_id` LEFT JOIN (SELECT `product.manufacturer.translation` . `product_manufacturer_id` , `product.manufacturer.translation` . `product_manufacturer_version_id` , `product.manufacturer.translation` . `link` as `product.manufacturer.translation.link` , `product.manufacturer.translation` . `name` as `product.manufacturer.translation.name` , `product.manufacturer.translation` . `description` as `product.manufacturer.translation.description` , `product.manufacturer.translation` . `custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation` . `language_id` = ? ) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation` . `product_manufacturer_id` = `product.manufacturer` . `id` AND `product.manufacturer.product_manufacturer_translation` . `product_manufacturer_version_id` = `product.manufacturer` . `version_id` LEFT JOIN (SELECT `product.unit.translation` . `unit_id` , `product.unit.translation` . `short_code` as `product.unit.translation.shortCode` , `product.unit.translation` . `name` as `product.unit.translation.name` , `product.unit.translation` . `custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation` . `language_id` = ? ) `product.unit.unit_translation` ON `product.unit.unit_translation` . `unit_id` = `product.unit` . `id` LEFT JOIN (SELECT `product.deliveryTime.translation` . `delivery_time_id` , `product.deliveryTime.translation` . `name` as `product.deliveryTime.translation.name` , `product.deliveryTime.translation` . `custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation` . `language_id` = ? ) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation` . `delivery_time_id` = `product.deliveryTime` . `id` LEFT JOIN `media` `product.cover.media` ON `product.cover` . `media_id` = `product.cover.media` . `id` LEFT JOIN (SELECT `product.cover.media.translation` . `media_id` , `product.cover.media.translation` . `alt` as `product.cover.media.translation.alt` , `product.cover.media.translation` . `title` as `product.cover.media.translation.title` , `product.cover.media.translation` . `custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation` . `language_id` = ? ) `product.cover.media.media_translation` ON `product.cover.media.media_translation` . `media_id` = `product.cover.media` . `id` WHERE (`product` . `version_id` = ? ) AND (`product` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%Ø2\x7F ÛpI\x02 ”¦X\x11 Y\x11 º "
b"të·\x19 ݉Jöš{Õ°K‹ç "
b"Ë\t 7™ƒ^LÀ¯U¦<ÀH±\f "
b"\v Ý©t,žEÒ©#ÓuâÂôµ\x06 :Á_î=D\r ‚àÖ;¢0˜¼w.\x17 kCE_†±„iä]{\x7F "
b"Š¸´\x04\x12 ®NŽ˜·kÁu/ðz "
b"!©\r 7\t\x1F F”_ñtW}$ "
b"„¨ò¨I;E?¬m5¾Pƒò "
b"ø`\x12 “\x15 õC\x02 °\x05\x08 ‰Ñ|i¯ "
b"Ý2Ž!)ùA¤ŽøŠªþ,¤å "
b"‚g}\x0F öLG»‹ãÏéI—\x07 "
b",$X>†îN¶ž\x00\f ©;ÌÚ! "
b"šN\x1D ªfåAó‘ž\x00 ¬Ï÷%J "
b"N©¸l\x7F JI›\x01 1&y¢\x1A Ž "
b"p¯[|§\x15 N²‹ j®Hñ.~ "
b"ßÛ2úºXOm£\x1C S¬ÃhÄu "
b"˜SÙ9\x1C H}¡‰qÝ<©Î, "
b"]ÍÍS£¶G³‚'Í\x1A\t Êb5 "
b"{úøIF<K£§“õ\x1E i\e ôÄ "
b"†Ã:©›Mt¡okUb¤Lœ "
b"EÊ\r Ü@E^§ƒÊéd—t— "
b"¡U2gA4GN‰ûZw\x17 pŽ¡ "
b""Ï'“¡æMˆŠ‹\f „±"+ë "
]
SELECT
`product` . `id` as `product.id` ,
`product` . `version_id` as `product.versionId` ,
`product` . `parent_id` as `product.parentId` ,
`product` . `parent_version_id` as `product.parentVersionId` ,
COALESCE (
`product` . `product_manufacturer_id` ,
`product.parent` . `product_manufacturer_id`
) as `product.manufacturerId` ,
COALESCE (
`product` . `product_manufacturer_version_id` ,
`product.parent` . `product_manufacturer_version_id`
) as `product.productManufacturerVersionId` ,
COALESCE (
`product` . `unit_id` , `product.parent` . `unit_id`
) as `product.unitId` ,
COALESCE (
`product` . `tax_id` , `product.parent` . `tax_id`
) as `product.taxId` ,
COALESCE (
`product` . `product_media_id` , `product.parent` . `product_media_id`
) as `product.coverId` ,
COALESCE (
`product` . `product_media_version_id` ,
`product.parent` . `product_media_version_id`
) as `product.productMediaVersionId` ,
COALESCE (
`product` . `delivery_time_id` , `product.parent` . `delivery_time_id`
) as `product.deliveryTimeId` ,
COALESCE (
`product` . `product_feature_set_id` ,
`product.parent` . `product_feature_set_id`
) as `product.featureSetId` ,
COALESCE (
`product` . `canonical_product_id` ,
`product.parent` . `canonical_product_id`
) as `product.canonicalProductId` ,
COALESCE (
`product` . `canonical_product_version_id` ,
`product.parent` . `canonical_product_version_id`
) as `product.canonicalProductVersionId` ,
COALESCE (
`product` . `cms_page_id` , `product.parent` . `cms_page_id`
) as `product.cmsPageId` ,
COALESCE (
`product` . `cms_page_version_id` ,
`product.parent` . `cms_page_version_id`
) as `product.cmsPageVersionId` ,
`product.parent` . `price` as `product.price.inherited` ,
COALESCE (
`product` . `price` , `product.parent` . `price`
) as `product.price` ,
`product` . `product_number` as `product.productNumber` ,
COALESCE (
`product` . `restock_time` , `product.parent` . `restock_time`
) as `product.restockTime` ,
`product` . `auto_increment` as `product.autoIncrement` ,
COALESCE (
`product` . `active` , `product.parent` . `active`
) as `product.active` ,
`product` . `available` as `product.available` ,
COALESCE (
`product` . `is_closeout` , `product.parent` . `is_closeout`
) as `product.isCloseout` ,
`product` . `available_stock` as `product.availableStock` ,
`product` . `stock` as `product.stock` ,
`product` . `display_group` as `product.displayGroup` ,
`product.parent` . `variant_listing_config` as `product.variantListingConfig.inherited` ,
COALESCE (
`product` . `variant_listing_config` ,
`product.parent` . `variant_listing_config`
) as `product.variantListingConfig` ,
`product` . `variant_restrictions` as `product.variantRestrictions` ,
COALESCE (
`product` . `manufacturer_number` ,
`product.parent` . `manufacturer_number`
) as `product.manufacturerNumber` ,
COALESCE (
`product` . `ean` , `product.parent` . `ean`
) as `product.ean` ,
COALESCE (
`product` . `purchase_steps` , `product.parent` . `purchase_steps`
) as `product.purchaseSteps` ,
COALESCE (
`product` . `max_purchase` , `product.parent` . `max_purchase`
) as `product.maxPurchase` ,
COALESCE (
`product` . `min_purchase` , `product.parent` . `min_purchase`
) as `product.minPurchase` ,
COALESCE (
`product` . `purchase_unit` , `product.parent` . `purchase_unit`
) as `product.purchaseUnit` ,
COALESCE (
`product` . `reference_unit` , `product.parent` . `reference_unit`
) as `product.referenceUnit` ,
COALESCE (
`product` . `shipping_free` , `product.parent` . `shipping_free`
) as `product.shippingFree` ,
`product.parent` . `purchase_prices` as `product.purchasePrices.inherited` ,
COALESCE (
`product` . `purchase_prices` , `product.parent` . `purchase_prices`
) as `product.purchasePrices` ,
COALESCE (
`product` . `mark_as_topseller` , `product.parent` . `mark_as_topseller`
) as `product.markAsTopseller` ,
COALESCE (
`product` . `weight` , `product.parent` . `weight`
) as `product.weight` ,
COALESCE (
`product` . `width` , `product.parent` . `width`
) as `product.width` ,
COALESCE (
`product` . `height` , `product.parent` . `height`
) as `product.height` ,
COALESCE (
`product` . `length` , `product.parent` . `length`
) as `product.length` ,
COALESCE (
`product` . `release_date` , `product.parent` . `release_date`
) as `product.releaseDate` ,
COALESCE (
`product` . `rating_average` , `product.parent` . `rating_average`
) as `product.ratingAverage` ,
`product.parent` . `category_tree` as `product.categoryTree.inherited` ,
COALESCE (
`product` . `category_tree` , `product.parent` . `category_tree`
) as `product.categoryTree` ,
`product.parent` . `property_ids` as `product.propertyIds.inherited` ,
COALESCE (
`product` . `property_ids` , `product.parent` . `property_ids`
) as `product.propertyIds` ,
`product.parent` . `option_ids` as `product.optionIds.inherited` ,
COALESCE (
`product` . `option_ids` , `product.parent` . `option_ids`
) as `product.optionIds` ,
`product.parent` . `stream_ids` as `product.streamIds.inherited` ,
COALESCE (
`product` . `stream_ids` , `product.parent` . `stream_ids`
) as `product.streamIds` ,
`product.parent` . `tag_ids` as `product.tagIds.inherited` ,
COALESCE (
`product` . `tag_ids` , `product.parent` . `tag_ids`
) as `product.tagIds` ,
`product.parent` . `category_ids` as `product.categoryIds.inherited` ,
COALESCE (
`product` . `category_ids` , `product.parent` . `category_ids`
) as `product.categoryIds` ,
`product` . `child_count` as `product.childCount` ,
COALESCE (
`product` . `custom_field_set_selection_active` ,
`product.parent` . `custom_field_set_selection_active`
) as `product.customFieldSetSelectionActive` ,
`product` . `sales` as `product.sales` ,
`product` . `states` as `product.states` ,
`product.parent` . `cheapest_price` as `product.cheapestPrice.inherited` ,
COALESCE (
`product` . `cheapest_price` , `product.parent` . `cheapest_price`
) as `product.cheapestPrice` ,
`product` . `created_at` as `product.createdAt` ,
`product` . `updated_at` as `product.updatedAt` ,
`product.manufacturer` . `id` as `product.manufacturer.id` ,
`product.manufacturer` . `version_id` as `product.manufacturer.versionId` ,
`product.manufacturer` . `media_id` as `product.manufacturer.mediaId` ,
`product.manufacturer` . `created_at` as `product.manufacturer.createdAt` ,
`product.manufacturer` . `updated_at` as `product.manufacturer.updatedAt` ,
`product.manufacturer.translation.name` ,
`product.manufacturer.translation.name` as `product.manufacturer.name` ,
`product.manufacturer.translation.link` ,
`product.manufacturer.translation.link` as `product.manufacturer.link` ,
`product.manufacturer.translation.description` ,
`product.manufacturer.translation.description` as `product.manufacturer.description` ,
`product.manufacturer.translation.customFields` ,
`product.manufacturer.translation.customFields` as `product.manufacturer.customFields` ,
(
SELECT
GROUP_CONCAT (
HEX (
`product.options.mapping` . `property_group_option_id`
) SEPARATOR '||'
)
FROM
`product_option` `product.options.mapping`
WHERE
`product.options.mapping` . `product_id` = `product` . `id`
) as `product.options.id_mapping` ,
`product.unit` . `id` as `product.unit.id` ,
`product.unit` . `created_at` as `product.unit.createdAt` ,
`product.unit` . `updated_at` as `product.unit.updatedAt` ,
`product.unit.translation.shortCode` ,
`product.unit.translation.shortCode` as `product.unit.shortCode` ,
`product.unit.translation.name` ,
`product.unit.translation.name` as `product.unit.name` ,
`product.unit.translation.customFields` ,
`product.unit.translation.customFields` as `product.unit.customFields` ,
`product.deliveryTime` . `id` as `product.deliveryTime.id` ,
`product.deliveryTime` . `min` as `product.deliveryTime.min` ,
`product.deliveryTime` . `max` as `product.deliveryTime.max` ,
`product.deliveryTime` . `unit` as `product.deliveryTime.unit` ,
`product.deliveryTime` . `created_at` as `product.deliveryTime.createdAt` ,
`product.deliveryTime` . `updated_at` as `product.deliveryTime.updatedAt` ,
`product.deliveryTime.translation.name` ,
`product.deliveryTime.translation.name` as `product.deliveryTime.name` ,
`product.deliveryTime.translation.customFields` ,
`product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields` ,
`product.cover` . `id` as `product.cover.id` ,
`product.cover` . `version_id` as `product.cover.versionId` ,
`product.cover` . `product_id` as `product.cover.productId` ,
`product.cover` . `product_version_id` as `product.cover.productVersionId` ,
`product.cover` . `media_id` as `product.cover.mediaId` ,
`product.cover` . `position` as `product.cover.position` ,
`product.cover` . `custom_fields` as `product.cover.customFields` ,
`product.cover` . `created_at` as `product.cover.createdAt` ,
`product.cover` . `updated_at` as `product.cover.updatedAt` ,
`product.cover.media` . `id` as `product.cover.media.id` ,
`product.cover.media` . `user_id` as `product.cover.media.userId` ,
`product.cover.media` . `media_folder_id` as `product.cover.media.mediaFolderId` ,
`product.cover.media` . `mime_type` as `product.cover.media.mimeType` ,
`product.cover.media` . `file_extension` as `product.cover.media.fileExtension` ,
`product.cover.media` . `uploaded_at` as `product.cover.media.uploadedAt` ,
`product.cover.media` . `file_name` as `product.cover.media.fileName` ,
`product.cover.media` . `file_size` as `product.cover.media.fileSize` ,
`product.cover.media` . `media_type` as `product.cover.media.mediaTypeRaw` ,
`product.cover.media` . `meta_data` as `product.cover.media.metaData` ,
`product.cover.media` . `config` as `product.cover.media.config` ,
`product.cover.media` . `path` as `product.cover.media.path` ,
`product.cover.media` . `private` as `product.cover.media.private` ,
`product.cover.media` . `thumbnails_ro` as `product.cover.media.thumbnailsRo` ,
`product.cover.media` . `file_hash` as `product.cover.media.fileHash` ,
`product.cover.media` . `created_at` as `product.cover.media.createdAt` ,
`product.cover.media` . `updated_at` as `product.cover.media.updatedAt` ,
`product.cover.media.translation.title` ,
`product.cover.media.translation.title` as `product.cover.media.title` ,
`product.cover.media.translation.alt` ,
`product.cover.media.translation.alt` as `product.cover.media.alt` ,
`product.cover.media.translation.customFields` ,
`product.cover.media.translation.customFields` as `product.cover.media.customFields` ,
`product.tax` . `id` as `product.tax.id` ,
`product.tax` . `tax_rate` as `product.tax.taxRate` ,
`product.tax` . `name` as `product.tax.name` ,
`product.tax` . `position` as `product.tax.position` ,
`product.tax` . `custom_fields` as `product.tax.customFields` ,
`product.tax` . `created_at` as `product.tax.createdAt` ,
`product.tax` . `updated_at` as `product.tax.updatedAt` ,
`product.translation.metaDescription` ,
`product.parent.translation.metaDescription` ,
COALESCE (
`product.translation.metaDescription` ,
`product.parent.translation.metaDescription`
) as `product.metaDescription` ,
`product.translation.name` ,
`product.parent.translation.name` ,
COALESCE (
`product.translation.name` , `product.parent.translation.name`
) as `product.name` ,
`product.translation.keywords` ,
`product.parent.translation.keywords` ,
COALESCE (
`product.translation.keywords` ,
`product.parent.translation.keywords`
) as `product.keywords` ,
`product.translation.description` ,
`product.parent.translation.description` ,
COALESCE (
`product.translation.description` ,
`product.parent.translation.description`
) as `product.description` ,
`product.translation.metaTitle` ,
`product.parent.translation.metaTitle` ,
COALESCE (
`product.translation.metaTitle` ,
`product.parent.translation.metaTitle`
) as `product.metaTitle` ,
`product.translation.packUnit` ,
`product.parent.translation.packUnit` ,
COALESCE (
`product.translation.packUnit` ,
`product.parent.translation.packUnit`
) as `product.packUnit` ,
`product.translation.packUnitPlural` ,
`product.parent.translation.packUnitPlural` ,
COALESCE (
`product.translation.packUnitPlural` ,
`product.parent.translation.packUnitPlural`
) as `product.packUnitPlural` ,
`product.translation.customSearchKeywords` ,
`product.parent.translation.customSearchKeywords` ,
COALESCE (
`product.translation.customSearchKeywords` ,
`product.parent.translation.customSearchKeywords`
) as `product.customSearchKeywords` ,
`product.translation.slotConfig` ,
`product.parent.translation.slotConfig` ,
COALESCE (
`product.translation.slotConfig` ,
`product.parent.translation.slotConfig`
) as `product.slotConfig` ,
`product.translation.customFields` ,
`product.parent.translation.customFields` ,
COALESCE (
`product.translation.customFields` ,
`product.parent.translation.customFields`
) as `product.customFields`
FROM
`product`
LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id`
AND `product` . `parent_version_id` = `product.parent` . `version_id`
LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product` . `manufacturer` = `product.manufacturer` . `id`
AND IFNULL (
`product` . `product_manufacturer_version_id` ,
`product.parent` . `product_manufacturer_version_id`
) = `product.manufacturer` . `version_id`
LEFT JOIN `unit` `product.unit` ON `product` . `unit` = `product.unit` . `id`
LEFT JOIN `delivery_time` `product.deliveryTime` ON `product` . `deliveryTime` = `product.deliveryTime` . `id`
LEFT JOIN `product_media` `product.cover` ON `product` . `cover` = `product.cover` . `id`
AND IFNULL (
`product` . `product_media_version_id` ,
`product.parent` . `product_media_version_id`
) = `product.cover` . `version_id`
LEFT JOIN `tax` `product.tax` ON `product` . `tax` = `product.tax` . `id`
LEFT JOIN (
SELECT
`product.translation` . `product_id` ,
`product.translation` . `product_version_id` ,
`product.translation` . `meta_description` as `product.translation.metaDescription` ,
`product.translation` . `name` as `product.translation.name` ,
`product.translation` . `keywords` as `product.translation.keywords` ,
`product.translation` . `description` as `product.translation.description` ,
`product.translation` . `meta_title` as `product.translation.metaTitle` ,
`product.translation` . `pack_unit` as `product.translation.packUnit` ,
`product.translation` . `pack_unit_plural` as `product.translation.packUnitPlural` ,
`product.translation` . `custom_fields` as `product.translation.customFields` ,
`product.translation` . `slot_config` as `product.translation.slotConfig` ,
`product.translation` . `custom_search_keywords` as `product.translation.customSearchKeywords`
FROM
`product_translation` `product.translation`
WHERE
`product.translation` . `language_id` = ?
) `product.product_translation` ON `product.product_translation` . `product_id` = `product` . `id`
AND `product.product_translation` . `product_version_id` = `product` . `version_id`
LEFT JOIN (
SELECT
`product.parent.translation` . `product_id` ,
`product.parent.translation` . `product_version_id` ,
`product.parent.translation` . `meta_description` as `product.parent.translation.metaDescription` ,
`product.parent.translation` . `name` as `product.parent.translation.name` ,
`product.parent.translation` . `keywords` as `product.parent.translation.keywords` ,
`product.parent.translation` . `description` as `product.parent.translation.description` ,
`product.parent.translation` . `meta_title` as `product.parent.translation.metaTitle` ,
`product.parent.translation` . `pack_unit` as `product.parent.translation.packUnit` ,
`product.parent.translation` . `pack_unit_plural` as `product.parent.translation.packUnitPlural` ,
`product.parent.translation` . `custom_fields` as `product.parent.translation.customFields` ,
`product.parent.translation` . `slot_config` as `product.parent.translation.slotConfig` ,
`product.parent.translation` . `custom_search_keywords` as `product.parent.translation.customSearchKeywords`
FROM
`product_translation` `product.parent.translation`
WHERE
`product.parent.translation` . `language_id` = ?
) `product.parent.product_translation` ON `product.parent.product_translation` . `product_id` = `product.parent` . `id`
AND `product.parent.product_translation` . `product_version_id` = `product.parent` . `version_id`
LEFT JOIN (
SELECT
`product.manufacturer.translation` . `product_manufacturer_id` ,
`product.manufacturer.translation` . `product_manufacturer_version_id` ,
`product.manufacturer.translation` . `link` as `product.manufacturer.translation.link` ,
`product.manufacturer.translation` . `name` as `product.manufacturer.translation.name` ,
`product.manufacturer.translation` . `description` as `product.manufacturer.translation.description` ,
`product.manufacturer.translation` . `custom_fields` as `product.manufacturer.translation.customFields`
FROM
`product_manufacturer_translation` `product.manufacturer.translation`
WHERE
`product.manufacturer.translation` . `language_id` = ?
) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation` . `product_manufacturer_id` = `product.manufacturer` . `id`
AND `product.manufacturer.product_manufacturer_translation` . `product_manufacturer_version_id` = `product.manufacturer` . `version_id`
LEFT JOIN (
SELECT
`product.unit.translation` . `unit_id` ,
`product.unit.translation` . `short_code` as `product.unit.translation.shortCode` ,
`product.unit.translation` . `name` as `product.unit.translation.name` ,
`product.unit.translation` . `custom_fields` as `product.unit.translation.customFields`
FROM
`unit_translation` `product.unit.translation`
WHERE
`product.unit.translation` . `language_id` = ?
) `product.unit.unit_translation` ON `product.unit.unit_translation` . `unit_id` = `product.unit` . `id`
LEFT JOIN (
SELECT
`product.deliveryTime.translation` . `delivery_time_id` ,
`product.deliveryTime.translation` . `name` as `product.deliveryTime.translation.name` ,
`product.deliveryTime.translation` . `custom_fields` as `product.deliveryTime.translation.customFields`
FROM
`delivery_time_translation` `product.deliveryTime.translation`
WHERE
`product.deliveryTime.translation` . `language_id` = ?
) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation` . `delivery_time_id` = `product.deliveryTime` . `id`
LEFT JOIN `media` `product.cover.media` ON `product.cover` . `media_id` = `product.cover.media` . `id`
LEFT JOIN (
SELECT
`product.cover.media.translation` . `media_id` ,
`product.cover.media.translation` . `alt` as `product.cover.media.translation.alt` ,
`product.cover.media.translation` . `title` as `product.cover.media.translation.title` ,
`product.cover.media.translation` . `custom_fields` as `product.cover.media.translation.customFields`
FROM
`media_translation` `product.cover.media.translation`
WHERE
`product.cover.media.translation` . `language_id` = ?
) `product.cover.media.media_translation` ON `product.cover.media.media_translation` . `media_id` = `product.cover.media` . `id`
WHERE
(`product` . `version_id` = ? )
AND (
`product` . `id` IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ?
)
)
Copy
SELECT `product` . `id` as `product.id` , `product` . `version_id` as `product.versionId` , `product` . `parent_id` as `product.parentId` , `product` . `parent_version_id` as `product.parentVersionId` , COALESCE (`product` . `product_manufacturer_id` , `product.parent` . `product_manufacturer_id` ) as `product.manufacturerId` , COALESCE (`product` . `product_manufacturer_version_id` , `product.parent` . `product_manufacturer_version_id` ) as `product.productManufacturerVersionId` , COALESCE (`product` . `unit_id` , `product.parent` . `unit_id` ) as `product.unitId` , COALESCE (`product` . `tax_id` , `product.parent` . `tax_id` ) as `product.taxId` , COALESCE (`product` . `product_media_id` , `product.parent` . `product_media_id` ) as `product.coverId` , COALESCE (`product` . `product_media_version_id` , `product.parent` . `product_media_version_id` ) as `product.productMediaVersionId` , COALESCE (`product` . `delivery_time_id` , `product.parent` . `delivery_time_id` ) as `product.deliveryTimeId` , COALESCE (`product` . `product_feature_set_id` , `product.parent` . `product_feature_set_id` ) as `product.featureSetId` , COALESCE (`product` . `canonical_product_id` , `product.parent` . `canonical_product_id` ) as `product.canonicalProductId` , COALESCE (`product` . `canonical_product_version_id` , `product.parent` . `canonical_product_version_id` ) as `product.canonicalProductVersionId` , COALESCE (`product` . `cms_page_id` , `product.parent` . `cms_page_id` ) as `product.cmsPageId` , COALESCE (`product` . `cms_page_version_id` , `product.parent` . `cms_page_version_id` ) as `product.cmsPageVersionId` , `product.parent` . `price` as `product.price.inherited` , COALESCE (`product` . `price` , `product.parent` . `price` ) as `product.price` , `product` . `product_number` as `product.productNumber` , COALESCE (`product` . `restock_time` , `product.parent` . `restock_time` ) as `product.restockTime` , `product` . `auto_increment` as `product.autoIncrement` , COALESCE (`product` . `active` , `product.parent` . `active` ) as `product.active` , `product` . `available` as `product.available` , COALESCE (`product` . `is_closeout` , `product.parent` . `is_closeout` ) as `product.isCloseout` , `product` . `available_stock` as `product.availableStock` , `product` . `stock` as `product.stock` , `product` . `display_group` as `product.displayGroup` , `product.parent` . `variant_listing_config` as `product.variantListingConfig.inherited` , COALESCE (`product` . `variant_listing_config` , `product.parent` . `variant_listing_config` ) as `product.variantListingConfig` , `product` . `variant_restrictions` as `product.variantRestrictions` , COALESCE (`product` . `manufacturer_number` , `product.parent` . `manufacturer_number` ) as `product.manufacturerNumber` , COALESCE (`product` . `ean` , `product.parent` . `ean` ) as `product.ean` , COALESCE (`product` . `purchase_steps` , `product.parent` . `purchase_steps` ) as `product.purchaseSteps` , COALESCE (`product` . `max_purchase` , `product.parent` . `max_purchase` ) as `product.maxPurchase` , COALESCE (`product` . `min_purchase` , `product.parent` . `min_purchase` ) as `product.minPurchase` , COALESCE (`product` . `purchase_unit` , `product.parent` . `purchase_unit` ) as `product.purchaseUnit` , COALESCE (`product` . `reference_unit` , `product.parent` . `reference_unit` ) as `product.referenceUnit` , COALESCE (`product` . `shipping_free` , `product.parent` . `shipping_free` ) as `product.shippingFree` , `product.parent` . `purchase_prices` as `product.purchasePrices.inherited` , COALESCE (`product` . `purchase_prices` , `product.parent` . `purchase_prices` ) as `product.purchasePrices` , COALESCE (`product` . `mark_as_topseller` , `product.parent` . `mark_as_topseller` ) as `product.markAsTopseller` , COALESCE (`product` . `weight` , `product.parent` . `weight` ) as `product.weight` , COALESCE (`product` . `width` , `product.parent` . `width` ) as `product.width` , COALESCE (`product` . `height` , `product.parent` . `height` ) as `product.height` , COALESCE (`product` . `length` , `product.parent` . `length` ) as `product.length` , COALESCE (`product` . `release_date` , `product.parent` . `release_date` ) as `product.releaseDate` , COALESCE (`product` . `rating_average` , `product.parent` . `rating_average` ) as `product.ratingAverage` , `product.parent` . `category_tree` as `product.categoryTree.inherited` , COALESCE (`product` . `category_tree` , `product.parent` . `category_tree` ) as `product.categoryTree` , `product.parent` . `property_ids` as `product.propertyIds.inherited` , COALESCE (`product` . `property_ids` , `product.parent` . `property_ids` ) as `product.propertyIds` , `product.parent` . `option_ids` as `product.optionIds.inherited` , COALESCE (`product` . `option_ids` , `product.parent` . `option_ids` ) as `product.optionIds` , `product.parent` . `stream_ids` as `product.streamIds.inherited` , COALESCE (`product` . `stream_ids` , `product.parent` . `stream_ids` ) as `product.streamIds` , `product.parent` . `tag_ids` as `product.tagIds.inherited` , COALESCE (`product` . `tag_ids` , `product.parent` . `tag_ids` ) as `product.tagIds` , `product.parent` . `category_ids` as `product.categoryIds.inherited` , COALESCE (`product` . `category_ids` , `product.parent` . `category_ids` ) as `product.categoryIds` , `product` . `child_count` as `product.childCount` , COALESCE (`product` . `custom_field_set_selection_active` , `product.parent` . `custom_field_set_selection_active` ) as `product.customFieldSetSelectionActive` , `product` . `sales` as `product.sales` , `product` . `states` as `product.states` , `product.parent` . `cheapest_price` as `product.cheapestPrice.inherited` , COALESCE (`product` . `cheapest_price` , `product.parent` . `cheapest_price` ) as `product.cheapestPrice` , `product` . `created_at` as `product.createdAt` , `product` . `updated_at` as `product.updatedAt` , `product.manufacturer` . `id` as `product.manufacturer.id` , `product.manufacturer` . `version_id` as `product.manufacturer.versionId` , `product.manufacturer` . `media_id` as `product.manufacturer.mediaId` , `product.manufacturer` . `created_at` as `product.manufacturer.createdAt` , `product.manufacturer` . `updated_at` as `product.manufacturer.updatedAt` , `product.manufacturer.translation.name` , `product.manufacturer.translation.name` as `product.manufacturer.name` , `product.manufacturer.translation.link` , `product.manufacturer.translation.link` as `product.manufacturer.link` , `product.manufacturer.translation.description` , `product.manufacturer.translation.description` as `product.manufacturer.description` , `product.manufacturer.translation.customFields` , `product.manufacturer.translation.customFields` as `product.manufacturer.customFields` , (SELECT GROUP_CONCAT (HEX (`product.options.mapping` . `property_group_option_id` ) SEPARATOR '||' )
FROM `product_option` `product.options.mapping`
WHERE `product.options.mapping` . `product_id` = `product` . `id` ) as `product.options.id_mapping` , `product.unit` . `id` as `product.unit.id` , `product.unit` . `created_at` as `product.unit.createdAt` , `product.unit` . `updated_at` as `product.unit.updatedAt` , `product.unit.translation.shortCode` , `product.unit.translation.shortCode` as `product.unit.shortCode` , `product.unit.translation.name` , `product.unit.translation.name` as `product.unit.name` , `product.unit.translation.customFields` , `product.unit.translation.customFields` as `product.unit.customFields` , `product.deliveryTime` . `id` as `product.deliveryTime.id` , `product.deliveryTime` . `min` as `product.deliveryTime.min` , `product.deliveryTime` . `max` as `product.deliveryTime.max` , `product.deliveryTime` . `unit` as `product.deliveryTime.unit` , `product.deliveryTime` . `created_at` as `product.deliveryTime.createdAt` , `product.deliveryTime` . `updated_at` as `product.deliveryTime.updatedAt` , `product.deliveryTime.translation.name` , `product.deliveryTime.translation.name` as `product.deliveryTime.name` , `product.deliveryTime.translation.customFields` , `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields` , `product.cover` . `id` as `product.cover.id` , `product.cover` . `version_id` as `product.cover.versionId` , `product.cover` . `product_id` as `product.cover.productId` , `product.cover` . `product_version_id` as `product.cover.productVersionId` , `product.cover` . `media_id` as `product.cover.mediaId` , `product.cover` . `position` as `product.cover.position` , `product.cover` . `custom_fields` as `product.cover.customFields` , `product.cover` . `created_at` as `product.cover.createdAt` , `product.cover` . `updated_at` as `product.cover.updatedAt` , `product.cover.media` . `id` as `product.cover.media.id` , `product.cover.media` . `user_id` as `product.cover.media.userId` , `product.cover.media` . `media_folder_id` as `product.cover.media.mediaFolderId` , `product.cover.media` . `mime_type` as `product.cover.media.mimeType` , `product.cover.media` . `file_extension` as `product.cover.media.fileExtension` , `product.cover.media` . `uploaded_at` as `product.cover.media.uploadedAt` , `product.cover.media` . `file_name` as `product.cover.media.fileName` , `product.cover.media` . `file_size` as `product.cover.media.fileSize` , `product.cover.media` . `media_type` as `product.cover.media.mediaTypeRaw` , `product.cover.media` . `meta_data` as `product.cover.media.metaData` , `product.cover.media` . `config` as `product.cover.media.config` , `product.cover.media` . `path` as `product.cover.media.path` , `product.cover.media` . `private` as `product.cover.media.private` , `product.cover.media` . `thumbnails_ro` as `product.cover.media.thumbnailsRo` , `product.cover.media` . `file_hash` as `product.cover.media.fileHash` , `product.cover.media` . `created_at` as `product.cover.media.createdAt` , `product.cover.media` . `updated_at` as `product.cover.media.updatedAt` , `product.cover.media.translation.title` , `product.cover.media.translation.title` as `product.cover.media.title` , `product.cover.media.translation.alt` , `product.cover.media.translation.alt` as `product.cover.media.alt` , `product.cover.media.translation.customFields` , `product.cover.media.translation.customFields` as `product.cover.media.customFields` , `product.tax` . `id` as `product.tax.id` , `product.tax` . `tax_rate` as `product.tax.taxRate` , `product.tax` . `name` as `product.tax.name` , `product.tax` . `position` as `product.tax.position` , `product.tax` . `custom_fields` as `product.tax.customFields` , `product.tax` . `created_at` as `product.tax.createdAt` , `product.tax` . `updated_at` as `product.tax.updatedAt` , `product.translation.metaDescription` , `product.parent.translation.metaDescription` , COALESCE (`product.translation.metaDescription` , `product.parent.translation.metaDescription` ) as `product.metaDescription` , `product.translation.name` , `product.parent.translation.name` , COALESCE (`product.translation.name` , `product.parent.translation.name` ) as `product.name` , `product.translation.keywords` , `product.parent.translation.keywords` , COALESCE (`product.translation.keywords` , `product.parent.translation.keywords` ) as `product.keywords` , `product.translation.description` , `product.parent.translation.description` , COALESCE (`product.translation.description` , `product.parent.translation.description` ) as `product.description` , `product.translation.metaTitle` , `product.parent.translation.metaTitle` , COALESCE (`product.translation.metaTitle` , `product.parent.translation.metaTitle` ) as `product.metaTitle` , `product.translation.packUnit` , `product.parent.translation.packUnit` , COALESCE (`product.translation.packUnit` , `product.parent.translation.packUnit` ) as `product.packUnit` , `product.translation.packUnitPlural` , `product.parent.translation.packUnitPlural` , COALESCE (`product.translation.packUnitPlural` , `product.parent.translation.packUnitPlural` ) as `product.packUnitPlural` , `product.translation.customSearchKeywords` , `product.parent.translation.customSearchKeywords` , COALESCE (`product.translation.customSearchKeywords` , `product.parent.translation.customSearchKeywords` ) as `product.customSearchKeywords` , `product.translation.slotConfig` , `product.parent.translation.slotConfig` , COALESCE (`product.translation.slotConfig` , `product.parent.translation.slotConfig` ) as `product.slotConfig` , `product.translation.customFields` , `product.parent.translation.customFields` , COALESCE (`product.translation.customFields` , `product.parent.translation.customFields` ) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product` . `parent_id` = `product.parent` . `id` AND `product` . `parent_version_id` = `product.parent` . `version_id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product` . `manufacturer` = `product.manufacturer` . `id` AND IFNULL (`product` . `product_manufacturer_version_id` , `product.parent` . `product_manufacturer_version_id` ) = `product.manufacturer` . `version_id` LEFT JOIN `unit` `product.unit` ON `product` . `unit` = `product.unit` . `id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product` . `deliveryTime` = `product.deliveryTime` . `id` LEFT JOIN `product_media` `product.cover` ON `product` . `cover` = `product.cover` . `id` AND IFNULL (`product` . `product_media_version_id` , `product.parent` . `product_media_version_id` ) = `product.cover` . `version_id` LEFT JOIN `tax` `product.tax` ON `product` . `tax` = `product.tax` . `id` LEFT JOIN (SELECT `product.translation` . `product_id` , `product.translation` . `product_version_id` , `product.translation` . `meta_description` as `product.translation.metaDescription` , `product.translation` . `name` as `product.translation.name` , `product.translation` . `keywords` as `product.translation.keywords` , `product.translation` . `description` as `product.translation.description` , `product.translation` . `meta_title` as `product.translation.metaTitle` , `product.translation` . `pack_unit` as `product.translation.packUnit` , `product.translation` . `pack_unit_plural` as `product.translation.packUnitPlural` , `product.translation` . `custom_fields` as `product.translation.customFields` , `product.translation` . `slot_config` as `product.translation.slotConfig` , `product.translation` . `custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product.product_translation` ON `product.product_translation` . `product_id` = `product` . `id` AND `product.product_translation` . `product_version_id` = `product` . `version_id` LEFT JOIN (SELECT `product.parent.translation` . `product_id` , `product.parent.translation` . `product_version_id` , `product.parent.translation` . `meta_description` as `product.parent.translation.metaDescription` , `product.parent.translation` . `name` as `product.parent.translation.name` , `product.parent.translation` . `keywords` as `product.parent.translation.keywords` , `product.parent.translation` . `description` as `product.parent.translation.description` , `product.parent.translation` . `meta_title` as `product.parent.translation.metaTitle` , `product.parent.translation` . `pack_unit` as `product.parent.translation.packUnit` , `product.parent.translation` . `pack_unit_plural` as `product.parent.translation.packUnitPlural` , `product.parent.translation` . `custom_fields` as `product.parent.translation.customFields` , `product.parent.translation` . `slot_config` as `product.parent.translation.slotConfig` , `product.parent.translation` . `custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product.parent.product_translation` ON `product.parent.product_translation` . `product_id` = `product.parent` . `id` AND `product.parent.product_translation` . `product_version_id` = `product.parent` . `version_id` LEFT JOIN (SELECT `product.manufacturer.translation` . `product_manufacturer_id` , `product.manufacturer.translation` . `product_manufacturer_version_id` , `product.manufacturer.translation` . `link` as `product.manufacturer.translation.link` , `product.manufacturer.translation` . `name` as `product.manufacturer.translation.name` , `product.manufacturer.translation` . `description` as `product.manufacturer.translation.description` , `product.manufacturer.translation` . `custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation` . `product_manufacturer_id` = `product.manufacturer` . `id` AND `product.manufacturer.product_manufacturer_translation` . `product_manufacturer_version_id` = `product.manufacturer` . `version_id` LEFT JOIN (SELECT `product.unit.translation` . `unit_id` , `product.unit.translation` . `short_code` as `product.unit.translation.shortCode` , `product.unit.translation` . `name` as `product.unit.translation.name` , `product.unit.translation` . `custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product.unit.unit_translation` ON `product.unit.unit_translation` . `unit_id` = `product.unit` . `id` LEFT JOIN (SELECT `product.deliveryTime.translation` . `delivery_time_id` , `product.deliveryTime.translation` . `name` as `product.deliveryTime.translation.name` , `product.deliveryTime.translation` . `custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation` . `delivery_time_id` = `product.deliveryTime` . `id` LEFT JOIN `media` `product.cover.media` ON `product.cover` . `media_id` = `product.cover.media` . `id` LEFT JOIN (SELECT `product.cover.media.translation` . `media_id` , `product.cover.media.translation` . `alt` as `product.cover.media.translation.alt` , `product.cover.media.translation` . `title` as `product.cover.media.translation.title` , `product.cover.media.translation` . `custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product.cover.media.media_translation` ON `product.cover.media.media_translation` . `media_id` = `product.cover.media` . `id` WHERE (`product` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`product` . `id` IN (0xC398327FDB70490294A6581159118FBA , 0x74EBB719DD894AF69A7BC395B04B8BE7 , 0xCB093799835E4CC0AF55A63CC048B10C , 0x0BDDA9742C9E45D2A923D375E2C2F4B5 , 0x063AC15FEE3D440D82E0D69D3BA23098 , 0xBC772E176B43455F86B18469E45D7B7F , 0x8AB8B40412AE4E8E98B76BC1752FF07A , 0x21A90D37091F46948F5F81F174577D24 , 0x84A8F2A8493B453FAC6DAD35BE5083F2 , 0xF860129315F54302B0050889D17C69AF , 0xDD328E2129F941A48EF88AAAFE2CA4E5 , 0x82677D0FF64C47BB8F8BE3CFE9499707 , 0x2C24583E86EE4EB69E000CA93BCCDA21 , 0x9A4E1DAA66E541F3919E00ACCFF7254A , 0x4EA9B86C9D7F4A499B01312679A21A8E , 0x70AF5B7CA7154EB28BA06AAE48F12E7E , 0xDFDB32FABA584F6DA31C53ACC368C475 , 0x9853D9AD391C487DA18971DD3CA9CE2C , 0x5DCDCD53A3B647B38227CD1A09CA6235 , 0x7BFAF849463C4BA3A793F51E691BF4C4 , 0x86C33AA9909B4D74A16F6B5562A44C9C , 0xAD45CA0DDC40455EA783CAE964977497 , 0xA15532674134474E89FB5A7717708EA1 , 0x22CF2793A1E64D888A8B0C84B1222BEB ));
Copy
26
0.23 ms
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
27
181.98 ms
SELECT `product_price` . `id` as `product_price.id` , `product_price` . `version_id` as `product_price.versionId` , `product_price` . `product_id` as `product_price.productId` , `product_price` . `product_version_id` as `product_price.productVersionId` , `product_price` . `rule_id` as `product_price.ruleId` , `product_price` . `price` as `product_price.price` , `product_price` . `quantity_start` as `product_price.quantityStart` , `product_price` . `quantity_end` as `product_price.quantityEnd` , `product_price` . `custom_fields` as `product_price.customFields` , `product_price` . `created_at` as `product_price.createdAt` , `product_price` . `updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price` . `version_id` = ? ) AND (((`product_price` . `product_id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ))))
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%\x06 :Á_î=D\r ‚àÖ;¢0˜\v Ý©t,žEÒ©#ÓuâÂôµ!©\r 7\t\x1F F”_ñtW}$ "
b""Ï'“¡æMˆŠ‹\f „±"+ë "
b",$X>†îN¶ž\x00\f ©;ÌÚ! "
b"N©¸l\x7F JI›\x01 1&y¢\x1A Ž "
b"]ÍÍS£¶G³‚'Í\x1A\t Êb5 "
b"p¯[|§\x15 N²‹ j®Hñ.~ "
b"të·\x19 ݉Jöš{Õ°K‹ç "
b"{úøIF<K£§“õ\x1E i\e ôÄ "
b"‚g}\x0F öLG»‹ãÏéI—\x07 "
b"„¨ò¨I;E?¬m5¾Pƒò "
b"†Ã:©›Mt¡okUb¤Lœ "
b"Š¸´\x04\x12 ®NŽ˜·kÁu/ðz "
b"˜SÙ9\x1C H}¡‰qÝ<©Î, "
b"šN\x1D ªfåAó‘ž\x00 ¬Ï÷%J "
b"¡U2gA4GN‰ûZw\x17 pŽ¡ "
b"EÊ\r Ü@E^§ƒÊéd—t— "
b"¼w.\x17 kCE_†±„iä]{\x7F "
b"Ø2\x7F ÛpI\x02 ”¦X\x11 Y\x11 º "
b"Ë\t 7™ƒ^LÀ¯U¦<ÀH±\f "
b"Ý2Ž!)ùA¤ŽøŠªþ,¤å "
b"ßÛ2úºXOm£\x1C S¬ÃhÄu "
b"ø`\x12 “\x15 õC\x02 °\x05\x08 ‰Ñ|i¯ "
]
SELECT `product_price` . `id` as `product_price.id` , `product_price` . `version_id` as `product_price.versionId` , `product_price` . `product_id` as `product_price.productId` , `product_price` . `product_version_id` as `product_price.productVersionId` , `product_price` . `rule_id` as `product_price.ruleId` , `product_price` . `price` as `product_price.price` , `product_price` . `quantity_start` as `product_price.quantityStart` , `product_price` . `quantity_end` as `product_price.quantityEnd` , `product_price` . `custom_fields` as `product_price.customFields` , `product_price` . `created_at` as `product_price.createdAt` , `product_price` . `updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`product_price` . `product_id` IN (0x063AC15FEE3D440D82E0D69D3BA23098 , 0x0BDDA9742C9E45D2A923D375E2C2F4B5 , 0x21A90D37091F46948F5F81F174577D24 , 0x22CF2793A1E64D888A8B0C84B1222BEB , 0x2C24583E86EE4EB69E000CA93BCCDA21 , 0x4EA9B86C9D7F4A499B01312679A21A8E , 0x5DCDCD53A3B647B38227CD1A09CA6235 , 0x70AF5B7CA7154EB28BA06AAE48F12E7E , 0x74EBB719DD894AF69A7BC395B04B8BE7 , 0x7BFAF849463C4BA3A793F51E691BF4C4 , 0x82677D0FF64C47BB8F8BE3CFE9499707 , 0x84A8F2A8493B453FAC6DAD35BE5083F2 , 0x86C33AA9909B4D74A16F6B5562A44C9C , 0x8AB8B40412AE4E8E98B76BC1752FF07A , 0x9853D9AD391C487DA18971DD3CA9CE2C , 0x9A4E1DAA66E541F3919E00ACCFF7254A , 0xA15532674134474E89FB5A7717708EA1 , 0xAD45CA0DDC40455EA783CAE964977497 , 0xBC772E176B43455F86B18469E45D7B7F , 0xC398327FDB70490294A6581159118FBA , 0xCB093799835E4CC0AF55A63CC048B10C , 0xDD328E2129F941A48EF88AAAFE2CA4E5 , 0xDFDB32FABA584F6DA31C53ACC368C475 , 0xF860129315F54302B0050889D17C69AF ))));
Copy
28
0.46 ms
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = ? ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id` ;
Copy
29
2.76 ms
SELECT `property_group_option` . `id` as `property_group_option.id` , `property_group_option` . `property_group_id` as `property_group_option.groupId` , `property_group_option` . `color_hex_code` as `property_group_option.colorHexCode` , `property_group_option` . `media_id` as `property_group_option.mediaId` , `property_group_option` . `created_at` as `property_group_option.createdAt` , `property_group_option` . `updated_at` as `property_group_option.updatedAt` , `property_group_option.media` . `id` as `property_group_option.media.id` , `property_group_option.media` . `user_id` as `property_group_option.media.userId` , `property_group_option.media` . `media_folder_id` as `property_group_option.media.mediaFolderId` , `property_group_option.media` . `mime_type` as `property_group_option.media.mimeType` , `property_group_option.media` . `file_extension` as `property_group_option.media.fileExtension` , `property_group_option.media` . `uploaded_at` as `property_group_option.media.uploadedAt` , `property_group_option.media` . `file_name` as `property_group_option.media.fileName` , `property_group_option.media` . `file_size` as `property_group_option.media.fileSize` , `property_group_option.media` . `media_type` as `property_group_option.media.mediaTypeRaw` , `property_group_option.media` . `meta_data` as `property_group_option.media.metaData` , `property_group_option.media` . `config` as `property_group_option.media.config` , `property_group_option.media` . `path` as `property_group_option.media.path` , `property_group_option.media` . `private` as `property_group_option.media.private` , `property_group_option.media` . `thumbnails_ro` as `property_group_option.media.thumbnailsRo` , `property_group_option.media` . `file_hash` as `property_group_option.media.fileHash` , `property_group_option.media` . `created_at` as `property_group_option.media.createdAt` , `property_group_option.media` . `updated_at` as `property_group_option.media.updatedAt` , `property_group_option.media.translation.title` , `property_group_option.media.translation.title` as `property_group_option.media.title` , `property_group_option.media.translation.alt` , `property_group_option.media.translation.alt` as `property_group_option.media.alt` , `property_group_option.media.translation.customFields` , `property_group_option.media.translation.customFields` as `property_group_option.media.customFields` , `property_group_option.translation.name` , `property_group_option.translation.name` as `property_group_option.name` , `property_group_option.translation.position` , `property_group_option.translation.position` as `property_group_option.position` , `property_group_option.translation.customFields` , `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `media` `property_group_option.media` ON `property_group_option` . `media_id` = `property_group_option.media` . `id` LEFT JOIN (SELECT `property_group_option.translation` . `property_group_option_id` , `property_group_option.translation` . `name` as `property_group_option.translation.name` , `property_group_option.translation` . `position` as `property_group_option.translation.position` , `property_group_option.translation` . `custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation` . `language_id` = ? ) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation` . `property_group_option_id` = `property_group_option` . `id` LEFT JOIN (SELECT `property_group_option.media.translation` . `media_id` , `property_group_option.media.translation` . `alt` as `property_group_option.media.translation.alt` , `property_group_option.media.translation` . `title` as `property_group_option.media.translation.title` , `property_group_option.media.translation` . `custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation` . `language_id` = ? ) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation` . `media_id` = `property_group_option.media` . `id` WHERE `property_group_option` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 f÷ÉàïF\x1E ·Tœï¬³\x11 •\x01 óÅx*äDª¤sÞõ(\x05 0ð\x02\x11 Î\r ¥™HÆ©\x00 %\x1D 6F´\x02 CÔ¼\x11 #K³—†¨ÿZ.\x04 ¨\x02 ïŸÒ`öAkÒÅN\x03 ŸÈD\x03 e熑ymšîÞ\e F@š\x15\t \x03 \x0F H)|È‘ž¥ú}‘g\x0E /\x03 ¦¼\x03 òQ¼òáâÒà^Î\x02 \x03 å{'`\x00 F®º=²ÞR:0\x04\x1A\x05 T@yèßÁ<tw/FÜ,\x04 VtÓØÑ@rºúÚó»HÈ\x04 Ã&Œ=G\x0F –0nhú\x0E l\x1F \x06 2Exþ/E0®^f\x18 \r \t Ü¿\x06 °]fþøFλ\x04 y9N…50\x07 n4qÓÉIª‹\x08 qSýÌ\x00 ¦\x07 ³5‰8\x1F Ds¤0*.\f 2‰æ\x07 »äê‹õJդʶ¾aõ4)\x08 \n “éý\v Nü¢s³w\x1E µÙê
"""
b"\x08 A2ö\x14 ŸÔÓ²è4zÖ¢Œ&\x08 H¦>y\x16 H*ª„C\x13 î\x7F i‡\x08 ×6@‘\x16 @s“¼E[¥°î:\t "Ävï\x01 Nˆ¬\x11 &\x1E ]TÊç\n \x0E Q\x15\x07 ÕO’’g¥fW$3’\n }–-\x0F ²\x1A ¿\x0E Mx‰Pü6
"""
b"""
\n ý¿\x03 2þIˆŒ÷Ïß\x19 (&ô
"""
b"\v\x1C %!˜ØOªõ\x10 eåÿº&\v\x7F\t pSëM|¢[)ã\f Ó\x0E Ì\v \x11 *‹kLㆶdÊ—\x7F ,~\v ©›Šº6N\x0E ½]\e aþ\x00 ˜²\r Ø\x13 ±¢‰NÊŸÀŒY\x16 Ji"\x0E L~v\x18 Mo\x15 -<t¤Á\v »Ó\x0E kM¹\x1E \n M/A\f í°\x06 A@
"""
b"\x0E Žü$ÞTKS¾$]HǤÖÓ\x0E ¶ƒG¹*DüŽÉœ)NZ%þ\x0F\x15 Ê”ú~F¼Ž™ø®?pkæ\x0F\e Fe$\x1E I\x1C ŽÊÕãežù.\x0F (\r ¢³=C§ƒÅýáL†\x1E O\x0F ãØøò7O\x1F “Ifø¶¨&\x11 {»â\x04 \r G꤫ç\x08 I…½®\x12 Ú,±\x14 ÞOJ¦.W7ú\n É)
"""
b"""
\x13\f Øy"|@üŽ\x1C ǘ|\n !\x11
"""
b"\x13 &N:\x1C Ñg]E®®=*ƒÓ¿\x13 .\x07\x16 Òý°J™‰\x16 >Dâ×X\x13 ;TY`µKN¡¡€,OO\x08 \x13 ww²;o.9çÒ;ÀÙÕû\x15 Øh\x12\x10\x18 @\e ¤³ÜH"å¨Ù\x15 íƒ\x0F Ñ‚Oå©œ)\x06 p݇J\x16 @%OàÍDå¿iÇNÁU\x1A\x04 \x16 Vü„7\f .Ä÷\x18 ø‘°â\x16 ]\x16 xàGCù6¡Lš\x04 åñ‚Žô\x17 §›Žu\x02 C;¦ïvbyìË@\x19 mQóí€LÁ øô$„N¡\x19 ~Õ’*eNª„•°¯1‡D\e 2ó´\x04 ŸEg¼\x1F\v\x1E\x18 °°\x1C \x1C ,\f ©ŒVMà–K.\v :ëx\n \x1D §\x00 éÛá\x17 2[W\x04 »V\x05 «¦\x1E nüúÌFKV„Ægt ½ç\x1E q\r A*¡\x17\x03 ˆÃÛîí9#b\x1E Ÿü^d%7kjrùÎ#(|µ\x1E Ѷ|^ÿz«Cq¸ÎÎ B\r \x1F ¯à†=gK/›´ñÆÈ°¡H\x1F ±þ,\x02 \n O䌋Xß\x18 µh_
"""
b"!\x03 „PuöC–©ßyÎp¹ÒQ "
b"!Q羦\x11 M$°+ΘÈÕ"\x11 "
b"!nÒLÒ\x01 ¾¤Q\x1A Rßœ\x13\x05 y "
b"!Ÿ>™ÂMAdžó€\x06 –h³T "
b"#TCbÛ\r O´‹ØÊ’åj4\x0F "
b"$\x0E 2\x15 .6C.Žé¢9EÂ×Ý "
b"$’5\x05 Ó¨@Z\r [( ìÉÏ "
b"$µ2»lŽFÛŠ³zî*ª\x0E ² "
b"$åQl >¦Œ‡ïÃZ`\t u "
b"%\x08 mÿ–\x1D HŽŽ\f ñ/]¨Ý "
b"%g\f ýGGÞHp…€\x0F H¿ ï "
b"&\x00 0^9‘M\x12 —^\x07\x13 7Ôj\x0E "
b"&Sý€è\f Š[¦\x1C €ÖÀIÀv "
b"'\x01 öÉ4ÑM†š=\v Èau$ "
b"'ruÌnàA{„qœÀa˜™\x1D "
b"(‚Ö\x06\x15 éOÑ¥²PU\x05 ȼ\e "
b"(’zü¤ÝH4¬J붦F¿. "
b"*‚ú’žC+²ã8ùj›õ} "
b"*.3!„D&—jà'Q\¡8 "
b"*þ³¸üÝ@\x07 ™»W`±¤c\x11 "
b"+\e ´Ùåõ\x7F žÝâä\x16 ÌH\x10 "
b"""
+³ÍÁü\n
N)Œª¥ÎG‡YÛ
"""
b",\x12 )öREd¶iY“‚kN0Á "
b",¶-÷7ØDÀ·\x1D ¡%q¥‹J "
b",é\t ©[êAD¡òôˆ\x03 £¯Í "
b"-ÔOá\x16 AP»‘Tà@h¥ã "
b".#<ýܧR-Š\x11 ¤glƒBÅ "
b"0)\e …xM:šß;Yme+ "
b"0)ŠÝû¦öPQ;)åüÌÊ "
b"0l\x08\x06\x19 d+µ$q1Dn’îÇ "
b"0o]ÕL'ÚÍ=¡´l\v ·Ó€ "
b"1\x1A DŽÞ¯Iˆ•ÖW—.Û\x13 ˜ "
b"1{h·bsK\x18 ¶§ÅOÑ\x15 7 "
b"5S_Ê \x1F D4”¬Àª™„\x1E « "
b"5Ž|æ`\x04 Gæ”g´0\x1E ®DŽ "
b"5C]ZdN-ªNzm\x17 C»H "
b"67Ÿ\x08 I\x0E M߃ÕG#*CU` "
b"6¥š7uaë+_¦ls‰w„\x00 "
b"6Í¥C¬\e LH¡Ò8’Žßˆ‹ "
b"7«\x1C ÿ5\x04 e.k ,OEøË "
b"8\x01 öEš»=·fØ„òDÃ!è "
b"8"I¾:I\x04 ƒð«³×†\x15 œ "
b"8œéUŒCbC\x1E "1¹93 "
b"9+\x11\x0F\x14 ;`Mü\x18 …À\x05 Ð"Ú "
b"9H¬¼\x11 ®E—¦|1¼eQVL "
b"9b«†¿\x08\x03 ¢ÃUúŽó<×Ë "
b"9…]Y/jpn¶¼Ž9ÑíЧ "
b";š ”\v\x08 AÕœ\x12 ®qly "
b">“ªª\x19 Z) fÈÒÜøZƒ5 "
b"?8–CÆîE™µs±&\r Žè "
b"?b·ãJ¥Dœµü™·vD8\x05 "
b"?péŽå¤I5’fY\x13 µ¬±k "
b"?q>·Gñ…C†(\x1C Ù#œ "
b"?ªçæ\x08 ÞMÐ -™=}\x14 \´ "
b"?ú\x05 <€ÀOs¶€³ö'~ºï "
b"@¼O4\x18 ÷Iγ,φž4\x12 B "
b"BJŽÒ\x10 éCQ…=ŒÕ`F\x04 \r "
b"B“\x12 îâ¬GÊݥT=tìƒ "
b"C4\x07 ·:>™—e XíQEX\x06 "
b"""
Cn\n
ÞPñgûèìôËJR‚
"""
b"DX\x19 É\x15 UMn»(\x1F ¿ûé—C "
b"Di)û×ÙIY¿Y@‡µˆQ "
b"I\x1F “ÏÂÂMÌ¡µ1Hs‰ŒÙ "
b"I£Œ\x1E -˜Nl™\x06\t CJ\x1F XE "
b"Jßµ\x14 S GŒí¬¢R\x19 l; "
b"JüYq&wDô²‹oëì–@÷ "
b"KГ\e 5‚ÊÉ—Ó‘\x1F –.° "
b"Lzƒ.8]Jµœ·3Ù}6íã "
b"M\r ÞUþý@I…Jÿ\x12 íæqï "
b"M„A&í\x15 IY†d\x05 ê\v à\x02\x18 "
b"MÞï\x16 XÏ#÷Z\x07 B\x12 žèX "
b"Mò`Á‹ÓLSŒ]„Hl\x1E Í "
b"N-HñN€L+¸ƒ\x18 7,ÿÜŽ "
b"R©}^mýº°ÖµÈ6©\e\x10 ’ "
b"Rí‰ÑLUJŽ…k,Š¸'Èl "
b"S\x1C ¥w\x0E ‹NÇš\x05\x0F ï³™\f "
b"SØ8\f µªFU‚g\x02 ®Û¶eæ "
b"T¹’âyÙî2×2\x01 ˆÕ "
b"V0饕˜Kì’ꔚӉNÓ "
b"V‚šr•ôM†¸tg'•Ë\x08 ß "
b"""
V’Ø ó$B\n
° ô`«{¾I
"""
b"WPý‹]PD\x1D ŠŠ§mƒ\x08 o… "
b"W—Ýc@\x17\x11 Æ\x1C ªÔˆëAQ\x15 "
b"WƲgüÎNþ¸D\x17 -\x01 ú7§ "
b"Z\x06 :~—tJܼïïô7}º› "
b"Zn^È\x1D O¢»œ<¬\e <\x10 "
b"Z¿o`”TInª.º‘Kå, "
b"[;ñ<ÅjIñ±C\x06 •…\x7F (D "
b"[‘sï\\x10 OÞ˜S\x07\x01 ÜÝ)š "
b"\Ž\x11 ¼WB™\ï÷1É°ƒ ä "
b"\ïé uLF\x12 †º\x08 ¥…~\x12 Y "
b"\ó¡\x0F\x02\x07 C\x19 Ž\x06 j7!ÈÙT "
b"""
]n¼W¬6ƒ{âd \n
Ë)ín
"""
b"]Þg; 9Dø…pj\f ¢:“\x7F "
b"^Ã1{ýR\x10\x06 ¢V&Ç\v Y\v œ "
b"^âvnãjA\r ¢©>-é\r ,\x04 "
b"_&=W7îB@»ÍȺñp¸ù "
b"`“F$>¥š°\x0E í$}?{ ¶ "
b"at²Õ«˜Eˆ©\f\x04 x(\e Üå "
b"bsrÿª³†1=\x03\x17 Œ¡¡o- "
b"b¾ÇjÝÞOÛ®Í\t ÕÄ4,z "
b"bÅ2Ž)‹Hë¿\x03 á/ÏbÅ "
b"cYó5ß°D åØóÿ\x03 Í| "
b"cÙÒkœ‰LÙž„û-Ð\x1A ¬’ "
b"dmUª\x1C ë'çÖ;\x10\x1C s-\x7F × "
b"dý]Ü\x01 “N\x0E ¹ÁV\x13 ±ÝÐ "
b"eÎ…rûõK[·\x05 Qa\x16 8õ~ "
b"""
fEô8K-Iq¬\x02 ¦$\x15 †\n
d
"""
b"g°5¸ÑGHñ§mkœiÌ”½ "
b"g¶‰ÕÛ¥O`‹tb7ÑêÖ) "
b"gÔ¹U}ÐHï±³[¿“\v\x14 œ "
b"h;òÒ!ÚFЈm\x19\x17 ʬÁ "
b"hÔÞ¥\x10 O‘¬\f Tɧù\v ä "
b"i\x1D €Ž.˜¹á¹\x03 Œà+\x18 Ãþ "
b"iÌÀ4v\t [µ¸\x0E ”÷|PÈ\x12 "
b"jêT'i:éøµÉŽGAe£j "
b"kºé\x12 lI«°îÑ¿Ð4‘Ø "
b"l*\t +abBúüû¥¦Õ^ö "
b"m\x17 ×5#ÈNX«ÈšK-\x05 a\x08 "
b"m¼:\r ßwK‚šÊþ\x12 ùÅè "
b"mÃÕ!ŒƒC+©öòØhÙš\n "
b"nžÈ\x03 bœ:êÀúÀ¨Ñµ\x08 3 "
b"n²ªáÓuN7±9daiX\x03 "
b"oê\x13 Ûãý£‹É$õ½~KÀ£ "
b"p\x1F :?KtAD¡!vêMv©’ "
b"p3Ä\x1A b?J\x1C ºjO\x17\f ¸±º "
b"p½‘]\x08 íL„\x17\e †ë\x11\x13 Z "
b"qf‰2yÁM)²ÃU¬Õ\f €° "
b"q„âLçÏb‚wÿwô=`Â\x1F "
b"q”ïIå'D´£_hº”-\x04 P "
b"q»«ceÐCæ…ä,\x1C >',ß "
b"sw‰bäuD"‘ûÎOrü\x03 A "
b"t\x0E w¦\x0F F°”|Ñ1DƒŠ'ø "
b"t&¯ZT\v ¶\x05 Ù¾µoøHà "
b"u\x06 Þq.öOnŽMZí÷°’’ "
b"uF¸À((I>€ÂóEˆvfô "
b"u_È_ÿwK·'}¼¼:Ê3 "
b"u†j…yKñ”Ž•Uß\x11 m "
b"vsE~]\t Iß‹¯ía<$x] "
b"w\x0E µ\x1F ÿCFC°\x11 OωQ_\x03 "
b"xÇ\x1F ØÚ>Gyª±+ë|ƒ/ "
b"yðhX¹YEy¢/¬<0a8\x1D "
b"""
zˆå3t°JX‹ü°ãU»\n
q
"""
b"z¼?Æ$^K.\x7F E\x05\x1D {Ë@ "
b"{"Ù8‹\x19 KNŸA3.\x00\x12\x11 D "
b"{:ª„¹ÝAí¨ªµ!lÄU¡ "
b"{¦¢¡'ów=,ŠÓ®N»› "
b"}ä\x13 8RÍN¹–êÙÃWa\x0F è "
b"}ð4ÔTÉ›-ù‰¯õ°6Y "
b"}ó Ü™ÁOщœBJP¨Ge "
b"""
~¼û1Õ\n
J\x08 ¿\x1E fCž/Ë\x06
"""
b"~Ægõojî\x11 »\x00 @Å_Ýù# "
b"~öÜ_\x17 öJ…¦¨ÿˆÐ7ˆ "
b"\x7F\x1C òR¥‘EA½z\x04 µ_¡Òa\x7F %\x1F ©ˆm¿8WÒâptØÃþ\x7F /‰ð\x1D çG°ˆD3Ùä|w>€\x14 n\x04 ÚÇaf“q\x0E áÙ\x11 î\x11 "
b"\x0E ꨆãn€Þ•)\x13 Å;ò÷ "
b".4G*‘A-“\x15\x07 ;\x05 (\x12 j "
b"ƒl\x14 yw;H²¢ÑA¨L1J\x03 "
b"""
ƒ€©\n
\x1F J© H½\x06 ™êÅؼƒ°\r |Ü¿@¡ƒª7Ä¥2\x1A\x0F "
b"„9\x1D ¾&\x19 K\x1E ‡ûÿ\x7F Ö…¦\x10 "
b"„Bv„\e ÷_\x00\x0E ™Zkå'Jv "
b"„U~ߎcBÒÅÅ¡^\r K± "
b"„¤ÕVqhI ©YjÎzkš¿ "
b"…\x02 )\x1F sýH(Ž}»œ—‹~t "
b"…F#\x0E n‚FF²¶ÚGÖQ3M "
b"†\r ¬\r ¨GG`Èšð\x02 …v0 "
b"†\x13\x00 ÷/B|›`¸ø Î\x1C "
b"†ì’å6öI¦˜:ÒŽéO®ï "
b"ˆ@Hj&,2.DMüÎÅ\x06 "z "
b"‹²¬9ÖU⡽’=Fjí« "
b"Œï˾Ñ\x08 Jn‰\x07 Žj¼ˆö\x1A "
b"ŒönwS<F\v ¯AjÄ)JdÁ "
b"Ž,ÜQà†B¡¿SÆ:AÌ°Î "
b"ŽÍÂt’—AH‰É”Q=\x02 õ| "
b"Ž\x03 #LÁ?E\x01 °gbÛ^z\n "
b"Ž7ð´s\r ƒh»5ôQ\r b»Œ "
b"ŽèÝ\x0F †§IT²\x16 \x7F {MY¢ "
b"\x08 ƒ‚æÎÄÑ&U\x7F\t u«\x04 L "
b"T\x7F ë'žC ˆTQ8Œ²ž¡ "
b"è \¨\x7F KüŸ\x10 ©ñϯ¨ù "
b"’ž¶W5®Gþ˜WB\x11\x1A ,ž^ "
b"“llí-'CÛ´,\x14 –4l` "
b"“Â\t *p‹DŽ…_\x06 žøl\t ® "
b"""
”*«ló0F0@ô>Ã\x7F \n
º
"""
b"•+n›ÅèB|ŽMŒÍ#ðÿK "
b"•`·Î\x1D\x11 O}ºvÉ\x03 ^‰Ï¤ "
b"•´û¢ØŸEö‚\x04 K-¶·“\x1C "
b"–Ã\x07 ®ê\\x05 ŽÕÿÒÄR9Fµ "
b"–Ó¦ˆ\x01 Jâ\x1C\x05 Ì%v³\r µ” "
b"—\x1C Ï·uIµ¬ÿ48±×œ: "
b"—”ÇpFÔE½ҵ”ƒTË¥ "
b"—Á*\x18 ˜—G·‚Œ¤Vz‡Õb "
b"˜–ŽÃåNN€D¢ÚáªR8 "
b"˜ëÏèŽÜǸ•i8\x1C Ÿ¬!x "
b"›Wê`adz\x13 ¹Ìæ‘:í¬ "
b"ž5ž›\x7F\x16 Dé»ó×Óª\x10 bo "
b"ž¼óØH=As®b×d\x13 à\x08 [ "
b"""
Ÿ\n
í+ò\x05 G\n
§EK÷'\x07 ½Ý
"""
b"Ÿ\x12 OüÎkD¹¡\x1E\v æDª "
b" \x10 û<žèæÓíÌ„—\x16 Œ "
b" d=àdÞKȦ\e DØq\x01\x19 "
b"¡bvÏÇÍJñ¿†<æ`8Ô "
b"¡´pù\v ßÝ“\x00 Q;g\x01 \x05 Ï "
b"¡Ó¢TZ}HQ ¬ä|Ñ0}à "
b"¡ÿ?®ŽEú…¸Gá«|l "
b"¢ºÎ˜íIO\e Œù#¹\x1F *’É "
b"¢Ç\x05 á/z©9\x1F —\t #‡¹£° "
b"¢ñš(õ4¾ì*‘¾BÏÛ' "
b"£}ï6‹ÍOÜ–U)ã߈o= "
b"£†W40ÀO+˜ÎYÑœ\x03 Zi "
b"¤RD\x0E –\x15 E\x14 %ÏÀNþ¡! "
b"¥’C\x06 `\x18 Cw!\x0F\x02 vR^ò "
b"¥£(RÎ0O´Œ¨.¡•!-^ "
b"¦&i"^NHV€ð\x1D FNã8' "
b"§\x07 ¸\x05 (ycš]\x12 V×xû›û "
b"§\e \\x06 6\e EÞŽ°\x15 å'0P× "
b"§D“\f Ž?H¢††¹ÚÙ4ô\x1C "
b"ªµESÓKÙºï¹}°ÿà "
b"«3åÁ\x7F\x1A H\x06 †íf\x14 €±<ö "
b"«þâÊK\x14 D´³_ö:ßðD½ "
b"¬aXÀF\x19 In¶½¬\x1C Üw¶¬ "
b"¬ˆ/åÓºŸRYÈfÙiõ¿ "
b"\x02 .\r ¸OžŽhè>ù\x01 Ô: "
b"t\x15 ¢¹ûJü…×a†.¦ª\x1D "
b"áü@'Ÿ¦¹’¤¢µö "
b"®Z„\x11 ¨íK\x13 €DNN\x7F J4˜ "
b"®…6È~ë@Xž\x1E ×.î\x1D Ùó "
b"¯f\x03 “NÇHx‰Ï׋\x04 ~\x05 ÿ "
b"¯Ž_<\x03\x1F O€¡³¶ví\x1A ˜u "
b"°Zõ\ xGÚ±“>\x07 ˜BÀ‹ "
b"°nMü†L ï=A\x0E nøŽ "
b"²0iAduG6¡\r ßþ?øüº "
b"²nß²ÓH!¸{~\r ád0ˆ "
b"²¦P"™rN‰\x18 r\x18 ׶âÓ "
b"²µwu÷°M-„\x06 ‚5¨)bJ "
b"´ˆWÝ&‹E)‡ùd¡ø\x05 ÑO "
b"""
·\n
ªšÄ’LF“A\x19 >3$;n
"""
b"¸V¥\x11 ðþG\x03 ”Øé›]…Ã) "
b"¸•ú¢¾K\x17 UWÝ\x1E S•; "
b"¹\x7F +=8d†³à9¼:ó,* "
b"ºu\x1F Ôÿ\x08 €7ì–\x1D C\x10 0Â "
b"º¤q\x02\x0E vHx“%–ã’Rmš "
b"»\x10 €\x7F fBå£>Í\x1D Í•\x04 û "
b"""
»d[5¿cÜ\n
\f\v w\x06 R^—
"""
b"»•¶ã²9IIŠýP\e Îaú§ "
b"¼lPlçãCÙžÈòXçÂ|R "
b"¼æ¹æòßJi‹Yˆ\x1A ܇⎠"
b"½yÆß[¤KC‘BÿÚh\v OM "
b"¾8¹È\x7F\x1E ¦ZŽH¥ñ\x01 ö¥Í "
b"¾’\e /š¿Z\x12 ã,r0–EV~ "
b"""
¿K/\n
œ»C>†§\e î“J£ì
"""
b"¿“eè…\x0E L¹¤5žR¢\x05 GÐ "
b"Áñ.—k#F]€ï#\x13 ¾RÄ\x1E "
b"Ãqœ²¾MJX–XT\x06 "
b"Ä\x04\x17 ª{E"A²Ö†\x18 w²ç[ "
b"Ä"®“ØQLY6¬™^\x06 µì5 "
b"ÄÂ%\x18 ~\x01 N퓆ˆ$‘øêà "
b"Å\x1F ñS\x04\e {ÛI†–´x˜jx "
b"Æ0\x19 U¦×MÓŽ›ÓԖǾ\x0F "
b"Ç\v\x1A áçŠJ‡Ž¼d<ÀóËF "
b"Ç\x16 ‚Ä>½L!:aùÎ\x10 ßþ "
b"È2 æg6¿I\x04\v Ô…\x1D ã¡ "
b"È]ÓìßKӦ处Á¬S\x10 "
b"É\f CƬXBðLÁÞÙµ\x17 "
b"É\x1A\x14 âýÉóH]è;tgUÓÂ "
b"Éaž…bîKT¶YГÔI[\x1F "
b"ɺý\x0E ¾Öþœ5$“ÑåŒT„ "
b"ɼp†§a`,\x1E å\r =ò]\r Á "
b"ÊsŠßÕUY|‘ì_\x14 ¸@'¸ "
b"Ë)s\x16\x05 wå‹Þþ¯°¼Ùc" "
b"ËBw Ï\x13 BJ’aÝ'Û‡™± "
b"Ëéðî\x1A @\x00 ÁÈü=„˜ÿÓW "
b"Ì>ßàq–K\x08 B}L•#ªÆ "
b"ÌZë…^úD€qú\x01 (R35 "
b"Ì‹ÄŽê CB”Ç6"ÔücÉ "
b"Í~hC£èM\x00 ™¬\x0F H×\x07 ”Þ "
b"ÎOÿ’[óEq‰Š‚NvÍ¥› "
b"Îf\x10 Š\x07 ÿÐש5‹ÇzŽ÷ "
b"ÎÊUÙÔ8âÖ\x11 ‰zÂÜ—“ñ "
b"Ð\x02 –qQLM®ˆ3{mIñ'Y "
b"""
Ð\n
z\x1F \n
\f I+§¬É”\x05 „¾\x01 ÐA¨€2lCs“|å‰ÒÃ$Q "
b"Ñ\x05 é¼>XV"!ñ%¥bQ¸P "
b"Ñ Ýù’Ž@òŽO"HßTt… "
b"Ñʪº^—§ +Uc\x04 ,0ys "
b"Ò©\x12 Ÿ\x13 §FVŽÚu:AЗ¬ "
b"Ò°\x16\x1A ÇêIر\x18 tÛf±q "
b"Ó¨IåTÈB±ãî#\‘ž "
b"ÓÓYܨŸ3W}Ê^h”Ž‘ "
b"Ô\x19 |g<ÈIÛ¬½·\x18 \r °…\x17 "
b"Ô¤vbW¯\x1D\x00 {W–¤¨Y`· "
b"Ö&J峎Jðl$‹MÈ\x7F Ý "
b"×\x02 ‰³½\x1C GοÂ'*A "
b"×N#³\x04 ÖGf£C—cI·+ "
b"׉pÑqýM•«ê\x1F H}\x00\x1D ¾ "
b"Ø\x12 ÁdWîOÕ»ßÇD0™»Ú "
b"Ø^ÜGN÷G …\x1F ŒN)òx„ "
b"ت\x1D ƒŽ\f HŽ·EÈ%\x0F T4â "
b"ØË*ýç†K¢…\v BT\x01 ¹W‰ "
b"Øá•A9£EM¨™`À¶Å?z "
b"Ù\x14 ¾\x7F PLD\x13 ¯#ÆÜz\x1D\x00 A "
b"Ùáß"/â@Ð\t QûÇf\x07\v "
b"ÚEÜZw8‡MýÏËAH¤@\x05 "
b"ÚaD\x0F àôFÆ”ˆÔ+2¶ý\r "
b"Ú˜\x0F é°ïO#¯·Ê\x19 …ðÈ "
b"Ú¯\x15 Ò8\f K^ƒ,ëè×Ã\x02 N "
b"Úâ¿\x17 ãL!™ÔEÓq\x1C E® "
b"Ûæ}÷oƒK®¿ÉtU9)\x1E ± "
b"Ük\x10 ›áÉJ\x1D ªòH\x0E 92Þ… "
b"Ý••1\v PF*§cµÙ\x08 \x08 8 "
b"""
à\x14 ao:AϺl\n
¥p<ßÎ
"""
b"áŽ|ƒˆ}JÝ£\x1F t.ˆòÿµ "
b"áçòËA]J €þ½K݆…ý "
b"âO~cÕiJQ |YDîéa— "
b"âa¸\x00 ðZ:Ú1\r vS\x01 žE´ "
b"""
âkvj°óD>´\x16 ¤’$¼\n
9
"""
b"ã^ù“«3Mq€;yM!Q³Ó "
b"ãÌ\x1D †b±Eቬ\x10 XlÕDœ "
b"ä-ßèósAM®f®ï\x06 k ¬ "
b"ä^{2m<Ií£\x16 ìÏOø©" "
b"å_Ñ×m\x03 MÅ–- nö†#° "
b"åŸÊÁ@\x04 BæûŠ\x1A\x03 žÃ° "
b"æ,ÓGÂ[»-f0óQj÷>ß "
b"æ\x7F ³½©ØVd\x06 à\x12 ý²\\x00 ƒ "
b"æîÓŸTMDd€º;¯^êöu "
b"ènFAa®LEº¿\x01 ‡A´?° "
b"é\t JèÏ\x0E I¸‡¥|h¢ª”\x06 "
b"颕€iyD_¥BƆ{HóV "
b"ê`\x10 Ä\x02 E‘¢9©Þ\x1E îƒ, "
b"ì\x10 ±åãÃÏO²>Å.¾Å, "
b"ì¾!\x1C Õ@ÄÝÖ’\x06 ÐÜ1 "
b"ìðé±(<¾ð€ô\x0E\x18 +Èêú "
b"""
íaÇ&Ò\x07 BWaî§\n
n Ã
"""
b"""
íú×\n
¬ìå\x05 òyÙ\x1C {Žób
"""
b"ð™E˜¡ÜML€!kU¹1P "
b"òô÷FËÂOf¦”\x0E ÖPLxã "
b"óQœ\x11 ;œElƒl\x1E |ë¡^è "
b"óƒ@\x07 U4jz¡DøÎ ñ[• "
b"ó˜.IMÛ@ÍŽ»g?êƒ= "
b"ô\r Nh\x7F ºOæŒb\x17 2ˆ\x1D 'È "
b"ô\x1A Y,\x17 ÆFoŸ€/UÖËðd "
b"""
ô…\x08 ÿΑA¨ª\n
qú¯âG”
"""
b"ôŽÞJ3O7ƒêW?øEŽ\x02 "
b"ôÄ}ü]æJû£ÉÓŸæf÷? "
b"ôâÅxIZWZ–\x7F GêgüY "
b"÷\x1A õ\x17 RLŽŸD\x03\x1A T1½Ø "
b"÷\x7F <ÿ\x1A WK »¬q>\x06 ¶{6 "
b"÷«)Ñ^ÏHY«œ\TÔx\x07 3 "
b"ø\x10 \îÇ5BA«¦É³\x10\x18 §× "
b"ø\x16 <\x12 8,˜Õ=à \x14 =´¿ú "
b"øo¿k°Ö¯ö˜ùÌéƒ\x13\t n "
b"øÖ‡]<ÈM{½1ló×\e Ë– "
b"ùCÆ—‡=K\x06 ¡|\r Û7ÃI "
b"ù~\x11 ›ÿC˜Žå\x10\e ¬Öë "
b"úP¤›°§FDz§ü5Zœ©ë "
b"ú}«d™Î[Ä*½Íùý.~ "
b"ú¶ðãˆH䨨ŒMÙ8“` "
b"û\x15 é\x12 ÃS>|\x06 yÔ‹\x7F dœ "
b"û-¸íÿòF%Š€\e «¨<”B "
b"ý\x02 ó\v xÝA«Žh\e `ú• › "
b"ý\x12 /;\x1F ;G©‡´;7n-; "
b"ýÕÒK•¦D‘¤ô}¯ÙåÔÕ "
b"ýô\x14\x01 |_J:‰FËú\x16 ·±0 "
b"þ8\x1C øµIV¼LÐïç„ì\r ý "
b"þÌÙö\x07\x13 II¨;\x00\x1E êÆ%^ "
b"þáZÌ\8OD¡ŸŽj:—ÊŽ "
]
SELECT
`property_group_option` . `id` as `property_group_option.id` ,
`property_group_option` . `property_group_id` as `property_group_option.groupId` ,
`property_group_option` . `color_hex_code` as `property_group_option.colorHexCode` ,
`property_group_option` . `media_id` as `property_group_option.mediaId` ,
`property_group_option` . `created_at` as `property_group_option.createdAt` ,
`property_group_option` . `updated_at` as `property_group_option.updatedAt` ,
`property_group_option.media` . `id` as `property_group_option.media.id` ,
`property_group_option.media` . `user_id` as `property_group_option.media.userId` ,
`property_group_option.media` . `media_folder_id` as `property_group_option.media.mediaFolderId` ,
`property_group_option.media` . `mime_type` as `property_group_option.media.mimeType` ,
`property_group_option.media` . `file_extension` as `property_group_option.media.fileExtension` ,
`property_group_option.media` . `uploaded_at` as `property_group_option.media.uploadedAt` ,
`property_group_option.media` . `file_name` as `property_group_option.media.fileName` ,
`property_group_option.media` . `file_size` as `property_group_option.media.fileSize` ,
`property_group_option.media` . `media_type` as `property_group_option.media.mediaTypeRaw` ,
`property_group_option.media` . `meta_data` as `property_group_option.media.metaData` ,
`property_group_option.media` . `config` as `property_group_option.media.config` ,
`property_group_option.media` . `path` as `property_group_option.media.path` ,
`property_group_option.media` . `private` as `property_group_option.media.private` ,
`property_group_option.media` . `thumbnails_ro` as `property_group_option.media.thumbnailsRo` ,
`property_group_option.media` . `file_hash` as `property_group_option.media.fileHash` ,
`property_group_option.media` . `created_at` as `property_group_option.media.createdAt` ,
`property_group_option.media` . `updated_at` as `property_group_option.media.updatedAt` ,
`property_group_option.media.translation.title` ,
`property_group_option.media.translation.title` as `property_group_option.media.title` ,
`property_group_option.media.translation.alt` ,
`property_group_option.media.translation.alt` as `property_group_option.media.alt` ,
`property_group_option.media.translation.customFields` ,
`property_group_option.media.translation.customFields` as `property_group_option.media.customFields` ,
`property_group_option.translation.name` ,
`property_group_option.translation.name` as `property_group_option.name` ,
`property_group_option.translation.position` ,
`property_group_option.translation.position` as `property_group_option.position` ,
`property_group_option.translation.customFields` ,
`property_group_option.translation.customFields` as `property_group_option.customFields`
FROM
`property_group_option`
LEFT JOIN `media` `property_group_option.media` ON `property_group_option` . `media_id` = `property_group_option.media` . `id`
LEFT JOIN (
SELECT
`property_group_option.translation` . `property_group_option_id` ,
`property_group_option.translation` . `name` as `property_group_option.translation.name` ,
`property_group_option.translation` . `position` as `property_group_option.translation.position` ,
`property_group_option.translation` . `custom_fields` as `property_group_option.translation.customFields`
FROM
`property_group_option_translation` `property_group_option.translation`
WHERE
`property_group_option.translation` . `language_id` = ?
) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation` . `property_group_option_id` = `property_group_option` . `id`
LEFT JOIN (
SELECT
`property_group_option.media.translation` . `media_id` ,
`property_group_option.media.translation` . `alt` as `property_group_option.media.translation.alt` ,
`property_group_option.media.translation` . `title` as `property_group_option.media.translation.title` ,
`property_group_option.media.translation` . `custom_fields` as `property_group_option.media.translation.customFields`
FROM
`media_translation` `property_group_option.media.translation`
WHERE
`property_group_option.media.translation` . `language_id` = ?
) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation` . `media_id` = `property_group_option.media` . `id`
WHERE
`property_group_option` . `id` IN (
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
?
)
Copy
SELECT `property_group_option` . `id` as `property_group_option.id` , `property_group_option` . `property_group_id` as `property_group_option.groupId` , `property_group_option` . `color_hex_code` as `property_group_option.colorHexCode` , `property_group_option` . `media_id` as `property_group_option.mediaId` , `property_group_option` . `created_at` as `property_group_option.createdAt` , `property_group_option` . `updated_at` as `property_group_option.updatedAt` , `property_group_option.media` . `id` as `property_group_option.media.id` , `property_group_option.media` . `user_id` as `property_group_option.media.userId` , `property_group_option.media` . `media_folder_id` as `property_group_option.media.mediaFolderId` , `property_group_option.media` . `mime_type` as `property_group_option.media.mimeType` , `property_group_option.media` . `file_extension` as `property_group_option.media.fileExtension` , `property_group_option.media` . `uploaded_at` as `property_group_option.media.uploadedAt` , `property_group_option.media` . `file_name` as `property_group_option.media.fileName` , `property_group_option.media` . `file_size` as `property_group_option.media.fileSize` , `property_group_option.media` . `media_type` as `property_group_option.media.mediaTypeRaw` , `property_group_option.media` . `meta_data` as `property_group_option.media.metaData` , `property_group_option.media` . `config` as `property_group_option.media.config` , `property_group_option.media` . `path` as `property_group_option.media.path` , `property_group_option.media` . `private` as `property_group_option.media.private` , `property_group_option.media` . `thumbnails_ro` as `property_group_option.media.thumbnailsRo` , `property_group_option.media` . `file_hash` as `property_group_option.media.fileHash` , `property_group_option.media` . `created_at` as `property_group_option.media.createdAt` , `property_group_option.media` . `updated_at` as `property_group_option.media.updatedAt` , `property_group_option.media.translation.title` , `property_group_option.media.translation.title` as `property_group_option.media.title` , `property_group_option.media.translation.alt` , `property_group_option.media.translation.alt` as `property_group_option.media.alt` , `property_group_option.media.translation.customFields` , `property_group_option.media.translation.customFields` as `property_group_option.media.customFields` , `property_group_option.translation.name` , `property_group_option.translation.name` as `property_group_option.name` , `property_group_option.translation.position` , `property_group_option.translation.position` as `property_group_option.position` , `property_group_option.translation.customFields` , `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `media` `property_group_option.media` ON `property_group_option` . `media_id` = `property_group_option.media` . `id` LEFT JOIN (SELECT `property_group_option.translation` . `property_group_option_id` , `property_group_option.translation` . `name` as `property_group_option.translation.name` , `property_group_option.translation` . `position` as `property_group_option.translation.position` , `property_group_option.translation` . `custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation` . `property_group_option_id` = `property_group_option` . `id` LEFT JOIN (SELECT `property_group_option.media.translation` . `media_id` , `property_group_option.media.translation` . `alt` as `property_group_option.media.translation.alt` , `property_group_option.media.translation` . `title` as `property_group_option.media.translation.title` , `property_group_option.media.translation` . `custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation` . `media_id` = `property_group_option.media` . `id` WHERE `property_group_option` . `id` IN (0x0166F7C9E0EF461EB7549CEFACB31195 , 0x01F3C5782AE444AAA473DEF5280530F0 , 0x0211CE0DA59948C6A900251D9D3646B4 , 0x0243D4BC11234BB39786A8FF5A2E04A8 , 0x02EF9FD260F6416B90D2C54E039FC844 , 0x0365E78691796D9AEEDE1B46409A1509 , 0x038F0F48297CC8919EA5FA7D91670E2F , 0x03A6BC03F251BCF2E1E2D2E05ECE0220 , 0x03E57B2760004690AEBA3DB2DE523A30 , 0x041A05544079E8DFC13C74772F46DC2C , 0x045674D3D8D14072BAFADAF3BB48C881 , 0x04C383268C3D470F96306E68FA0E6C1F , 0x06324578FE2F4530AE5E66180D09DCBF , 0x06B05D66FEF846CEBB0479394E853530 , 0x076E3471D3C949AA8B087153FDCC00A6 , 0x07B33589381F4473A4302A2E0C3289E6 , 0x07BBE4EA8BF54AD5A4CAB6BE61F53429 , 0x080A93E9FD0B4EFCA273B3771EB5D9EA , 0x084132F6149FD4D3B2E8347AD6A28C26 , 0x0848A63E7916482AAA844313EE7F6987 , 0x08D736409116407393BC455BA5B0EE3A , 0x0922C476EF014E88AC11261E5D54CAE7 , 0x0A0E511507D54F929267A56657243392 , 0x0AAD7D962D0FB21ABF0E4D788950FC36 , 0x0AFDBF0332FE49888CF7CFDF192826F4 , 0x0B1C252198D84F90AAF51065E5FFBA26 , 0x0B7F097053EB4D7CA25B29E30CD30ECC , 0x0B81112A8B6B4CE386B664CA977F2C7E , 0x0BA99B8ABA364E0EBD5D1B61FE0098B2 , 0x0DD813B1A2894ECA9FC08C59164A6922 , 0x0E4C7E76184D6F152D3C74A4C10BBBD3 , 0x0E6B4D8FB91E0A4D2F410CEDB0064140 , 0x0E8DFC24DE544B53BE245D48C7A4D6D3 , 0x0EB68347B92A44FC8EC99C294E5A25FE , 0x0F15CA94FA7E46BC8E99F8AE3F706BE6 , 0x0F1B4665241E491C8DCAD5E3659EF92E , 0x0F280DA2B33D43A783C5FDE14C861E4F , 0x0FE3D8F8F2374F1F934966ADF8B6A826 , 0x117BBBE2040D47EAA4ABE7084985BDAE , 0x12DA2CB114DE4F4AA62E5737FA0AC929 , 0x130CD879227C40FC8D1CC7987C0A2111 , 0x13264E3A1CD1675D45AEAE3D2A83D3BF , 0x132E0716D2FDB04A9989163E44E2D758 , 0x133B545960B54B4EA1A1802C4F4FAD08 , 0x139D7777B23B6F2E39E7D23BC0D9D5FB , 0x15D868121018401BA4B3DC4822E5A8D9 , 0x15ED830FD1824FE5A99C290670DD874A , 0x1640254FE0CD44E5BF69C74EC1551A04 , 0x1656FC84370C2EC4F718F891B0E2165D , 0x1678E04743F936A14C9A04E5F1828EF4 , 0x17A79B8E7502433BA6EF766279ECCB40 , 0x196D51F3ED804CC1A09DF8F424844EA1 , 0x197ED5922A654EAA8495B0AF31874490 , 0x1B32F3B4049F4567BC1F0B1E18B0B01C , 0x1C2C0CA98C564DE0964B2E0B3AEB780A , 0x1DA700E9DBE117325B5704BB5605ABA6 , 0x1E6EFCFACC464B5684C667907420BDE7 , 0x1E710D412AA1170388C3DBEEED392362 , 0x1E9FFC5E6425376B6A72F9CE23287CB5 , 0x1ED1B67C5EFF7AAB4371B8CECE20420D , 0x1FAFE0863D674B2F9BB4F1C6C8B0A148 , 0x1FB1FE2C020A4FE48C8B58DF18B5685F , 0x2103845075F64396A9DF79CE70B9D251 , 0x2151E7BEA6114D24B02BCE98C8D52211 , 0x216ED24CD201BEA4511A52DF9C130579 , 0x219F3E99C24D41649EF380069668B354 , 0x23544362DB0D4FB48BD8CA92E56A340F , 0x240E32152E36432E8EE9A23945C2D7DD , 0x24923505D3A8405A900D5B28A0ECC9CF , 0x24B532BB6C8E46DB8AB37AEE2AAA0EB2 , 0x24E5516CA03EA68C87EFC35AAD600975 , 0x25086DFF961D488E8E0CF12F5DA8DDC2 , 0x25670CFD4747DE487085800F48BF20EF , 0x2600305E39914D12975E071337D46A0E , 0x2653FD80E80C8A5BA61C80D6C049C076 , 0x270190F6C934D14D869A3D0BC8617524 , 0x277275CC6EE0417B84719CC06198991D , 0x2882D60615E94FD1A5B2505505C8BC1B , 0x28927AFCA4DD4834AC4AEBB6A646BF2E , 0x2A82FA92819E432BB2E338F96A9BF57D , 0x2A8F2E3321844426976AE027515CA138 , 0x2AFEB3B8FCDD400799BB5760B1A46311 , 0x2B901BB4D9E5F57F9EDDE2E416CC4810 , 0x2BB3CDC1FC0A4E298CAAA5CE478759DB , 0x2C1229F6524564B6695993826B4E30C1 , 0x2CB62DF737D844C0B71DA12571A58B4A , 0x2CE909A95BEA4144A1F2F48803A3AFCD , 0x2DD44FC3A1164150BB9154E04068A5E3 , 0x2E233CFDDCA7522D8A11A4676C8342C5 , 0x30291BAD85784D3A909ADF3B596D652B , 0x30298ADDFBA6F650513B29E5FCCCCA8F , 0x306C080619642BB5247131446E92EEC7 , 0x306F5DD54C27DACD3DA1B46C0BB7D380 , 0x311A448DDEAF498895D657972EDB1398 , 0x317B68B762734B18B6A790C54FD11537 , 0x35535FCAA01F443494ACC0AA99841EAB , 0x358D7CE6600447E69467B4301EAE448E , 0x3590435D5A644E2DAA4E7A6D1743BB48 , 0x36379F08490E4DDF83D547232A435560 , 0x36A59A377561EB2B5FA66C7389778400 , 0x36CDA543AC1B4C48A1D238928DDF888B , 0x37ADAB1CFF3504652E6BA02C4F45F8CB , 0x3801F6459ABB3DB766D884F244C321E8 , 0x382249BE813A490483F0ABB3D786159C , 0x389CE98F558C4362AD431E2231B93933 , 0x392B110F143B604DFC1885C005D022DA , 0x3948ACBC11AE4597A67C31BC6551564C , 0x3962AB86BF0803A2C355FA8DF33CD7CB , 0x39855D592F6A706EB6BC8D39D1EDD0A7 , 0x3B9AA0940B0841D59C12AE716C792081 , 0x3E93AAAA195A292066C8D2DCF85A8335 , 0x3F389643C6EE4599B573B181260D8EE8 , 0x3F62B7E34AA5449CB5FC99B776443805 , 0x3F70E98EE5A4493592665913B5ACB16B , 0x3F713EB747F185439D86281CD99D239C , 0x3FAAE7E608DE4DD0A02D993D7D145CB4 , 0x3FFA053C80C04F73B680B3F6277EBAEF , 0x40BC4F3418F749CEB32CCF869E341242 , 0x424A8DD210E94351853D8CD56046040D , 0x429312EEE2AC47C38ADDA5543D74EC83 , 0x433407B73A3E999765A058ED51455806 , 0x436E0ADE50F167FB8FE8ECF4CB4A5282 , 0x445819C915554D6EBB281FBFFBE99743 , 0x446929FBD7D94959BF5940AD87B58851 , 0x491F93CFC2C24DCCA1B5314873898CD9 , 0x49A38C1E2D984E6C990609434A1F5845 , 0x4ADFB5145320478CEDACA252199D6C3B , 0x4AFC5971267744F4B28B6FEBEC9640F7 , 0x4BD0931B9D3582CAC997D3911F962EB0 , 0x4C7A832E385D4AB59CB733D97D36EDE3 , 0x4D0DDE55FEFD4049854AFF12EDE671EF , 0x4D844126ED154959866405EA0BE00218 , 0x4DDEEF1658CF23F7905A0742129EE858 , 0x4DF260C18BD34C538C5D84486C9D1ECD , 0x4E2D48F14E804C2BB88318372CFFDC8D , 0x52A97D5E6DFDBAB0D6B5C836A91B1092 , 0x52ED89D14C554A8D856B2C8AB827C86C , 0x531CA5770E8B4EC79A050FEFB399810C , 0x53D8380CB5AA4655826702AEDBB665E6 , 0x54B98F92E279D9EE32D7328FAD0188D5 , 0x5630E9A595984BEC92EA949AD3894ED3 , 0x56829A7295F44D86B874672795CB08DF , 0x5692D820F324420AB020F460AB7BBE49 , 0x5750FD8B5D50441D8A8AA76D83086F85 , 0x5797DD63401711C61CAAD488EB415115 , 0x57C6B267FCCE4EFEB844172D01FA37A7 , 0x5A063A7E97744ADCBCEFEFF4377DBA9B , 0x5A6E5EC81D904FA2BB9CAD3CAC1B3C10 , 0x5ABF6F609454496EAA2EBA914BE5902C , 0x5B3BF13CC56A49F1B1430695857F2844 , 0x5B9173EF5C104FDE98530701DCDD299A , 0x5C8D11BC5742995CEFF731C9B083A0E4 , 0x5CEFE9A0754C461286BA08A5857E1259 , 0x5CF3A10F020743198D066A3721C8D954 , 0x5D6EBC57AC36837BE264200ACB29ED6E , 0x5DDE673B203944F885706A0CA23A937F , 0x5EC3317BFD521006A25626C70B590B9C , 0x5EE2766EE36A410DA2A93E2DE90D2C04 , 0x5F263D5737EE4240BBCDC8BAF170B8F9 , 0x609346243EA59AB00EED247D3F7B20B6 , 0x6174B2D5AB984588A90C0478281BDCE5 , 0x627372FFAAB386313D03178CA1A16F2D , 0x62BEC76ADDDE4FDBAECD09D5C4342C7A , 0x62C5328D298B48EBBF03E12FCF62ADC5 , 0x6359F335DFADB04420E5D8F3FF03CD7C , 0x63D9D26B9C894CD99E84FB2DD01AAC92 , 0x646D55AA1CEB27E7D63B101C732D7FD7 , 0x64FD5DDC01934E0EB9C15613B1ADDDD0 , 0x65CE8572FBF54B5BB70551611638F57E , 0x6645F4384B2D4971AC02A62415860A64 , 0x67B035B8D14748F1A76D6B9C69CC94BD , 0x67B689D5DBA54F608B746237D1EAD629 , 0x67D4B9557DD048EFB1B35BBF930B149C , 0x683BF2D221DA46D0886D1917CAAC8FC1 , 0x6890D4DEA5104F91AC0C54C9A7F90BE4 , 0x691D808D2E98B9E1B9038CE02B18C3FE , 0x69CCC03476095BB5B80E94F77C50C812 , 0x6AEA5427693AE9F8B5C98D474165A36A , 0x6BC2BAE9126C49ABB0EED1BFD03491D8 , 0x6C2A092B616242C3BAFCFBA5A6D55EF6 , 0x6D17D73523C84E58ABC89A4B2D056108 , 0x6DBC3A0DDF774B829ACA9DFE12F9C5E8 , 0x6DC3D5218C83432BA9F6F2D868D99A0A , 0x6E9EC803629C3AEAC0FAC0A8D1B50833 , 0x6EB2AAE1D3754E37B19D396461695803 , 0x6FEA13DBE3FDA38BC924F5BD7E4BC0A3 , 0x701F3A3F4B744144A12176EA4D76A992 , 0x7033C41A623F4A1CBA6A4F170CB8B1BA , 0x70BD915D08ED4C9084171B86EB11135A , 0x7166893279C14D29B2C355ACD50C80B0 , 0x7184E24CE7CF628277FF77F43D60C21F , 0x7194EF49E52744B4A35F68BA942D0450 , 0x71BBAB6365D043E685E42C1C3E272CDF , 0x73778962E475442291FBCE4F72FC0341 , 0x740E77A60F46B0947CD13144838A27F8 , 0x7426AF5A540BB60581D9BEB56FF848E0 , 0x7506DE712EF64F6E8E4D5AEDF7B09292 , 0x7546B8C02828493E80C2F345887666F4 , 0x755FC85FFF774B90B7277DBCBC3ACA33 , 0x75866A8579AD4BF1948D9555DF9D116D , 0x7673457E5D0949DF8BAFED613C24785D , 0x770EB51FFF434643B0114FCF89515F03 , 0x78C71FD8DA3E4779AAB12BEB7CC2832F , 0x79F06858B9594579A22FAC3C3061381D , 0x7A88E53374B04A588BFCB0E355BB0A71 , 0x7ABC3FC6245E4B2EAD7F45051D7BCB40 , 0x7B22D9388B194B4E9F41332E00121144 , 0x7B3AAA84B9DD41EDA8AAB5216CC455A1 , 0x7BA6A2A127F3773D2C8AD3AE4EBB909B , 0x7DE4133852CD4EB996EAD9C357610FE8 , 0x7DF034D454C99B2DF989AFF5B0AD3659 , 0x7DF320DC99C14FD1899C424A50A84765 , 0x7EBCFB31D50A4A08BF1E66439E2FCB06 , 0x7EC667F56F6AEE11BB0040C55FDDF923 , 0x7EF6DC5F17F64A85A6A8FF8890D03788 , 0x7F1CF252A5914541BD7A04B55FA1D261 , 0x7F251FA9886DBF3857D2E27074D8C3FE , 0x7F2F89F01DE747B0884433D9E47C773E , 0x80146E04DAC7616693710EE1D911EE11 , 0x810EEAA886E36E80DE952913C53BF2F7 , 0x812E34472A91412D9315073B0528126A , 0x836C1479773B48B2A2D141A84C314A03 , 0x8380A90A1F4AA9A048BD0699EAC5D8BC , 0x83B00D7CDCBF40A183AA37C4A5321A0F , 0x84391DBE26194B1E87FBFF7FD685A610 , 0x844276841BF75F000E995A6BE5274A76 , 0x8455817EDF8E6342D2C5C5A15E0D4BB1 , 0x84A4D55671684920A9596ACE7A6B9ABF , 0x8502291F73FD48288D7DBB9C978B7E74 , 0x8546230E6E824646B2B6DA47D651334D , 0x860DAC0DA84747608FC89AF002857630 , 0x861300F72F90427C8F9B60B8F8A0CE1C , 0x86EC92E536F649A6983AD28DE94FAEEF , 0x8840486A262C322E444DFCCEC506227A , 0x8BB2AC39D655E2A1BD923D466AEDAB9D , 0x8CEFCBBED1084A6E89078E6ABC88F61A , 0x8CF66E77533C460BAF416AC4294A64C1 , 0x8D2CDC51E08642A1BF53C63A41CCB0CE , 0x8DCDC2749297414889C994513D02F57C , 0x8E03234CC13F4501B08F6762DB5E7A0A , 0x8E37F0B4730D8368BB35F4510D62BB8C , 0x8EE8DD0F86A74954B2169D7F7B4D59A2 , 0x8F088382E6CEC4D126557F0975AB044C , 0x8F547FEB279E43A0885451388CB29EA1 , 0x90E8A05CA87F4BFC9F10A9F1CFAFA8F9 , 0x929EB65735AE47FE985742111A2C9E5E , 0x936C6CED2D2743DBB42C1496346C9D60 , 0x93C2092A708B448D855F069EF86C09AE , 0x942AAB6CF3304630AD40F43EC37F0ABA , 0x952B6E9BC5E8427C8E4D8CCD23F0FF4B , 0x9560B7CE1D114F7DBA76C9035E89CFA4 , 0x95B4FBA2D89F45F682044B2DB6B7931C , 0x96C307AEEA5C058ED5FFD2C4523946B5 , 0x96D3A688014AE21C05CC2576B30DB594 , 0x971CCFB7758149B5ACFF3438B1D79C3A , 0x9794C77046D445C2BDD2B5948354CBA5 , 0x97C12A18989747B7828CA4567A87D562 , 0x98968D81C3E54E4E8044A2DAE1AA5238 , 0x98EBCFE88DDCC7B89569381C9FAC2178 , 0x9B57EA8F6061647A13B9CCE6913AEDAC , 0x9E359E9B7F1644E9BBF3D7D3AA10626F , 0x9EBCF3D8483D4173AE62D76413E0085B , 0x9F0AED2BF205470AA7454BF72707BDDD , 0x9F12AD4FFCCE6B44B9A1AD1E0BE644AA , 0xA0108FFB3C9EADE8E6D3EDCC8497168C , 0xA0643DE064DE4BC8A61B44D871011981 , 0xA16276CFC7CD4AF18FBF863CE66038D4 , 0xA1B470F90BDFDD9300513B6701A005CF , 0xA1D3A2545A7D4851A0ACE47CD1307DC3 , 0xA1FF9D3FAE8D45FA85B89047E1AB7C6C , 0xA2BACE98ED494F1B8CF923B91F2A92C9 , 0xA2C705E12F7AA9391F97092387B9A3B0 , 0xA2F19A28F534BEEC812A91BE42CFDB27 , 0xA37DEF368BCD4FDC965529E3DF886F3D , 0xA386573430C04F2B98CE59D19C035A69 , 0xA452440E961545148125CFC04EFEA121 , 0xA592430660184377AD210F0276525EF2 , 0xA5A32852CE304FB48CA82EA195212D5E , 0xA62669225E4E485680F01D464EE33827 , 0xA707B8052879639A5D1256D778FB9BFB , 0xA71B5C06361B45DE8EB015E5273050D7 , 0xA744930C8D3F48A28686B9DAD934F41C , 0xAAB5814553D34BD9BAEF8FB97DB0FFC3 , 0xAB33E5C17F1A480686ED661480B13CF6 , 0xABFEE2CA4B1444B4B35FF63ADFF044BD , 0xAC6158C04619496EB6BDAC1CDC77B6AC , 0xAC882FE5D3BA9F5259C86681D969F5BF , 0xAD02AD2E0DB84F9E8E68E83EF901D43A , 0xAD7415A2B9FB4AFC85D761862EA6AA1D , 0xADEEA8B0E1FC40279FA6B992A4A2B5F6 , 0xAE5A8411A8ED4B1380444E4E7F4A3498 , 0xAE8536C87EEB40589E1ED72EEE1DD9F3 , 0xAF6603934EC7487889CFD78B047E05FF , 0xAF8D5F3C031F4F80A1B3B676ED1A9875 , 0xB05AF55CA07847DAB1933E079842C08B , 0xB06E4DFC86904C2081EF3D410E6EF88E , 0xB230694164754736A10DDFFE3FF8FCBA , 0xB26E9DDFB2D34821B87B7E0DE1643088 , 0xB2A6502299724EC289187218D7B6E2D3 , 0xB2B57775F7B04D2D84068235A829624A , 0xB48857DD268B452987F964A1F805D14F , 0xB70AAA9AC4924C469341193E33243B6E , 0xB856A511F0FE470394D8E99B5D85C329 , 0xB895FAA2BE8F4B17815557DD1E53953B , 0xB97F2B3D386486B3E039BC3AF32C812A , 0xBA751FD4FF9D088037EC961D431030C2 , 0xBAA471020E764878932596E392526D9A , 0xBB10807F668F42E5A33ECD1DCD9504FB , 0xBB645B35BF63DC0A900C0B7706525E97 , 0xBB95B6E3B23949498AFD501BCE61FAA7 , 0xBC6C506CE7E343D99EC8F258E7C27C52 , 0xBCE6B9E6F2DF4A698B59881ADC87E28D , 0xBD79C6DF5BA44B439142FFDA680B4F4D , 0xBE38B9C87F1EA65A8D48A5F101F6A5CD , 0xBE921B2F9ABF5A12E32C72309645567E , 0xBF4B2F0A9CBB433E86A71BEE934AA3EC , 0xBF9365E8850E4CB9A4359E52A20547D0 , 0xC1F12E976B23465D80EF2313BE52C41E , 0xC3719CB2BE4D4AEE84B8589658549006 , 0xC40417AA7B452241B2D6861877B2E75B , 0xC422AE93D8514C5936AC995E06B5EC35 , 0xC4C225187E014EED9386882491F8EAE0 , 0xC51FF153041B7BDB498696B478986A78 , 0xC6301955A6D74DD38E9BD3D496C7BE0F , 0xC70B1AE1E78A4A878DBC643CC0F3CB46 , 0xC71682C43EBD4C218F3A61F9CE10DFFE , 0xC832A0E6679D36BF49040BD4851DE3A1 , 0xC85DD3ECDFAD4BD3A6E5A484C1AC5310 , 0xC90C43C6AC5842F0814C8FC1DED9B517 , 0xC91A14E2FDC9F3485DE83B746755D3C2 , 0xC9619E8562EE4B54B659D093D4495B1F , 0xC9BAFD0EBED6FE9C352493D1E58C5484 , 0xC9BC7086A761602C1EE50D3DF25D0DC1 , 0xCA738ADFD555597C91EC5F14B84027B8 , 0xCB2973160577E58BDEFEAFB0BCD96322 , 0xCB427720CF13424A9261DD27DB8799B1 , 0xCBE9F0EE1A4000C1C8FC3D8498FFD357 , 0xCC3EDFE071964B089D427D4C9523AAC6 , 0xCC5AEB855EFA44818071FA0128523335 , 0xCC8BC48DEA20434294C73622D4FC63C9 , 0xCD7E6843A3E84D0099AC0F48D70794DE , 0xCE4FFF925BF34571898A824E76CDA59B , 0xCE66108A07FFD0D7A9358B8FC77A8DF7 , 0xCECA55D9D438E2D611897AC2DC9793F1 , 0xD0029671514C4DAE88337B6D49F12759 , 0xD00A7A1F0A0C492BA7ACC9940584BE01 , 0xD041A880326C4373937CE589D2C32451 , 0xD105E9BC3E58562221F125A56251B850 , 0xD120DDF9928E40F28E4F2248DF547485 , 0xD1CAAABA5E97A7A02B5563042C307973 , 0xD2A9129F13A746568DDA753A41D097AC , 0xD2B0161AC7EA49C598B11874DB66B171 , 0xD3A849E554C842B19DE39DEE235C919E , 0xD3D359DCA89F33577DCA5E68C2948D91 , 0xD4197C673CC849DBACBDB7180DB08517 , 0xD4A4766257AF1D007B5796A4A85960B7 , 0xD6264AE5B38E4AC3B06C248B4DC87FDD , 0xD70289B3BD1C47CEBFEE8C8EC2272A41 , 0xD74E23B304D64766A343AD976349B72B , 0xD78970D171FD4D95ABEA1F487D001DBE , 0xD812C16457EE4FD5BBDFC7443099BBDA , 0xD85EDC474EF747A0851F8C4E29F27884 , 0xD8AA1D838D0C488EB745C8250F5434E2 , 0xD8CB2AFDE7864BA2850B425401B95789 , 0xD8E1954139A3454DA89960C0B6C53F7A , 0xD914BE7F504C4413AF23C6DC7A1D0041 , 0xD9E1DF222FE240D0900951FBC766070B , 0xDA45DC5A7738874DFDCFCB4148A44005 , 0xDA61440FE0F446C69488D42B32B6FD0D , 0xDA980FE9B0EF4F23AFADB7CA1985F0C8 , 0xDAAF15D2380C4B5E832CEBE8D7C3024E , 0xDAE2BF8F17E34C2199D445D3711C45AE , 0xDBE67DF76F834BAEBFC9745539291EB1 , 0xDC6B109BE1C94A1DAAF2480E3932DE85 , 0xDD9595310B50462AA763B5D908900838 , 0xE014AD616F3A41CFBA6C0AA5703CDFCE , 0xE18D7C83887D4ADDA31F742E88F2FFB5 , 0xE1E7F2CB415D4A2080FEBD4BDD8685FD , 0xE24F7E63D5694A51A07C5944EEE96197 , 0xE261B800F05A3ADA310D7653019E45B4 , 0xE26B766AB0F3443EB416A49224BC0A39 , 0xE35EF993AB334D71803B794D2151B3D3 , 0xE3CC1D8662B145E189AC10586CD5449C , 0xE42DDFE8F373414DAE66AEEF066BA0AC , 0xE45E7B326D3C49EDA316ECCF4FF8A922 , 0xE55FD1D76D034DC5962D206EF68623B0 , 0xE59FCAC1400442E6ADFB8A1A039EC3B0 , 0xE62CD347C25BBB2D6630F3516AF73EDF , 0xE67FB3BDA9D8566406E012FDB25C0083 , 0xE6EED39F544D446480BA3BAF5EEAF675 , 0xE86E464161AE4C45BABF018741B43FB0 , 0xE9094AE8CF0E49B887A57C68A2AA9406 , 0xE9A295806979445FA542C6867B48F356 , 0xEA608F10C4024591A239A9DE1EEE832C , 0xEC10B1E5E3C3CF4FB23EC52E9DBEC52C , 0xECBE211CD58140C490DDD69206D0DC31 , 0xECF0E9B1283CBEF080F40E182BC8EAFA , 0xED61C726D20742578F61EEA70A6EA0C3 , 0xEDFAD70AACECE505F279D91C7B8EF362 , 0xF0994598A1DC4D4C80216B55B931509D , 0xF2F4F746CBC24F66A6940ED6504C78E3 , 0xF3519C113B9C456C836C1E7CEBA15EE8 , 0xF383400755346A7AA144F8CEA0F15B95 , 0xF3982E494DDB40CD8EBB81673FEA833D , 0xF40D4E687FBA4FE68C621732881D27C8 , 0xF41A592C17C6466F9F802F55D6CBF064 , 0xF48508FFCE9141A8AA0A71FAAFE24794 , 0xF48EDE4A81334F3783EA573FF8458E02 , 0xF4C47DFC5DE64AFBA3C9D39FE666F73F , 0xF4E2C578495A575A967F47EA67FC59AD , 0xF71AA0F517524C8E9F44031A5431BDD8 , 0xF77F3CFF1A574B20BBAC713E06B67B36 , 0xF7AB29D15ECF4859AB9C5C54D4780733 , 0xF8105CEEC7354241ABA6C9B31018A7D7 , 0xF8163C12382C98D53DE0A0143DB4BFFA , 0xF86FBF6BB0D6AFF698F9CCE98313096E , 0xF8D6875D3CC84D7BBD316CF3D71BCB96 , 0xF943C697873D4B06A17C0DDB37C3498F , 0xF97E118F9BFF43988EE58F101BACD6EB , 0xFA50A49BB0A746C7B2A7FC355A9CA9EB , 0xFA7DAB6499CE5BC42ABD9DCDF9FD2E7E , 0xFA8FB6F0E38848E4A8A88C4DD9389360 , 0xFB15E912C3533E7C810679D48B7F649C , 0xFB2DB8EDFFF246258A801BABA83C9442 , 0xFD02F30B78DD41AB8E681B60FA95A09B , 0xFD122F3B1F3B47A99D87B43B376E2D3B , 0xFDD5D24B95A64491A4F47DAFD9E5D4D5 , 0xFDF414017C5F4A3A8946CBFA16B7B130 , 0xFE381CF8B54956BC4CD0EFE784EC0DFD , 0xFECCD9F607134949A83B001EEAC6255E , 0xFEE15ACC5C384F44A19F8E6A3A97CA8D );
Copy
30
0.32 ms
SELECT `property_group` . `id` as `property_group.id` , `property_group` . `display_type` as `property_group.displayType` , `property_group` . `sorting_type` as `property_group.sortingType` , `property_group` . `filterable` as `property_group.filterable` , `property_group` . `visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage` , `property_group` . `created_at` as `property_group.createdAt` , `property_group` . `updated_at` as `property_group.updatedAt` , `property_group.translation.name` , `property_group.translation.name` as `property_group.name` , `property_group.translation.description` , `property_group.translation.description` as `property_group.description` , `property_group.translation.position` , `property_group.translation.position` as `property_group.position` , `property_group.translation.customFields` , `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation` . `property_group_id` , `property_group.translation` . `name` as `property_group.translation.name` , `property_group.translation` . `description` as `property_group.translation.description` , `property_group.translation` . `position` as `property_group.translation.position` , `property_group.translation` . `custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation` . `language_id` = ? ) `property_group.property_group_translation` ON `property_group.property_group_translation` . `property_group_id` = `property_group` . `id` WHERE ((`property_group` . `filterable` = ? )) AND (`property_group` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
b"Î\x7F Œ\r "ÂFòŽ ª\f á\x0E ÷² "
b"‘éÚ\x1E ìŒEÙ€H÷‹\f Fb« "
b"Í\x0E `]m\x1F G…š•U}£/½ "
b"]ŽÃd0\x05 MaH-Ž2\x14 ¿÷ "
b"÷W\x15 €\x02 ¯@ŸŽÑaà(~ÆÁ "
b"A»I_\x16 KB)ŠT›"<3›W "
b"Á¸R´ñûO›ªÌV™›;94 "
b"År\x13 žG©HH¨˜ú\x01 i¥N® "
b"•Êð²\x14 4KU¤+ztl\³; "
b"\x15 'þÿFL¡,ÆÊ’\x0E 5m "
b"\x08 Eñ\t 8Eê·Ö,«ŽÉùŒ7¹“ñ\x1A ÂCj·Ž»(»]\ "
b"Bdé\r ¹O®²ƒ¼Õ\x10 ÖZó "
]
SELECT `property_group` . `id` as `property_group.id` , `property_group` . `display_type` as `property_group.displayType` , `property_group` . `sorting_type` as `property_group.sortingType` , `property_group` . `filterable` as `property_group.filterable` , `property_group` . `visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage` , `property_group` . `created_at` as `property_group.createdAt` , `property_group` . `updated_at` as `property_group.updatedAt` , `property_group.translation.name` , `property_group.translation.name` as `property_group.name` , `property_group.translation.description` , `property_group.translation.description` as `property_group.description` , `property_group.translation.position` , `property_group.translation.position` as `property_group.position` , `property_group.translation.customFields` , `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation` . `property_group_id` , `property_group.translation` . `name` as `property_group.translation.name` , `property_group.translation` . `description` as `property_group.translation.description` , `property_group.translation` . `position` as `property_group.translation.position` , `property_group.translation` . `custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `property_group.property_group_translation` ON `property_group.property_group_translation` . `property_group_id` = `property_group` . `id` WHERE ((`property_group` . `filterable` = 1 )) AND (`property_group` . `id` IN (0xCE7F8C0D22C246F28EA0AA0CE10EF7B2 , 0x91E9DA1EEC8C45D98048F78B0C4662AB , 0xCD0E605D6D1F47859A95559D7DA32FBD , 0x5D8DC36430054D6181482D8D3214BFF7 , 0xF757158002AF409F8DD161E0287EC6C1 , 0x41BB495F164B42298A549B223C339B57 , 0xC1B852B4F1FB4F9BAACC56999B3B3934 , 0xC572139E47A94848A898FA0169A54EAE , 0x95CAF0B214344B55A42B7A746C5CB33B , 0x81159D27FEFF464CA12CC6CA920E356D , 0x0845F1098F3845EAB7D62CAB8DC9F98C , 0x37B993F11AC2436AB78EBB28BB5D5C90 , 0x4264E90DB99D4FAEB283BCD510D65AF3 ));
Copy
31
0.16 ms
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = ? OR `id` = ?
Parameters :
[
b";³'JWðKÉ—\f y_-ýÛå "
b"w¹YÏfÞL\x15 Çù·Ú9‚ó "
]
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = 0x3BB3274A57F04BC9970C795F2DFDDBE5 OR `id` = 0x77B959CF66DE4C1590C7F9B7DA3982F3
;
Copy
32
0.14 ms
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
; Copy
33
0.14 ms
SELECT
`theme_id` ,
`technical_name` ,
`resolved_config` ,
`view_inheritance` ,
`script_files` ,
`icon_sets` ,
`updated_at`
FROM `theme_runtime_config`
WHERE `technical_name` = ?
Parameters :
[
"Storefront "
]
SELECT
`theme_id` ,
`technical_name` ,
`resolved_config` ,
`view_inheritance` ,
`script_files` ,
`icon_sets` ,
`updated_at`
FROM `theme_runtime_config`
WHERE `technical_name` = 'Storefront' ; Copy
34
0.15 ms
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
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 ; Copy
35
0.09 ms
SELECT DISTINCT `technical_name`
FROM `theme_runtime_config`
WHERE `technical_name` IS NOT NULL
SELECT DISTINCT `technical_name`
FROM `theme_runtime_config`
WHERE `technical_name` IS NOT NULL ; Copy
36
0.10 ms
SELECT path FROM category WHERE id = ?
Parameters :
[
b";³'JWðKÉ—\f y_-ýÛå "
]
SELECT path FROM category WHERE id = 0x3BB3274A57F04BC9970C795F2DFDDBE5 ; Copy
37
0.08 ms
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ; Copy
38
0.32 ms
SELECT `media` . `id` as `media.id` , `media` . `user_id` as `media.userId` , `media` . `media_folder_id` as `media.mediaFolderId` , `media` . `mime_type` as `media.mimeType` , `media` . `file_extension` as `media.fileExtension` , `media` . `uploaded_at` as `media.uploadedAt` , `media` . `file_name` as `media.fileName` , `media` . `file_size` as `media.fileSize` , `media` . `media_type` as `media.mediaTypeRaw` , `media` . `meta_data` as `media.metaData` , `media` . `config` as `media.config` , `media` . `path` as `media.path` , `media` . `private` as `media.private` , `media` . `thumbnails_ro` as `media.thumbnailsRo` , `media` . `file_hash` as `media.fileHash` , `media` . `created_at` as `media.createdAt` , `media` . `updated_at` as `media.updatedAt` , `media.translation.title` , `media.translation.title` as `media.title` , `media.translation.alt` , `media.translation.alt` as `media.alt` , `media.translation.customFields` , `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . `media_id` , `media.translation` . `alt` as `media.translation.alt` , `media.translation` . `title` as `media.translation.title` , `media.translation` . `custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation` . `language_id` = ? ) `media.media_translation` ON `media.media_translation` . `media_id` = `media` . `id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder` . `default_folder_id` = `media.mediaFolder.defaultFolder` . `id` WHERE (((`media` . `private` = ? OR (`media` . `private` = ? AND `media.mediaFolder.defaultFolder` . `entity` = ? )))) AND (`media` . `id` IN (? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
false
true
"product_download "
b"\x01 ›1{Aõpµ·ñ:C‹u\x10 È\x01 ›1{AüqU¢Ý}ìë(D} ]
SELECT `media` . `id` as `media.id` , `media` . `user_id` as `media.userId` , `media` . `media_folder_id` as `media.mediaFolderId` , `media` . `mime_type` as `media.mimeType` , `media` . `file_extension` as `media.fileExtension` , `media` . `uploaded_at` as `media.uploadedAt` , `media` . `file_name` as `media.fileName` , `media` . `file_size` as `media.fileSize` , `media` . `media_type` as `media.mediaTypeRaw` , `media` . `meta_data` as `media.metaData` , `media` . `config` as `media.config` , `media` . `path` as `media.path` , `media` . `private` as `media.private` , `media` . `thumbnails_ro` as `media.thumbnailsRo` , `media` . `file_hash` as `media.fileHash` , `media` . `created_at` as `media.createdAt` , `media` . `updated_at` as `media.updatedAt` , `media.translation.title` , `media.translation.title` as `media.title` , `media.translation.alt` , `media.translation.alt` as `media.alt` , `media.translation.customFields` , `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . `media_id` , `media.translation` . `alt` as `media.translation.alt` , `media.translation` . `title` as `media.translation.title` , `media.translation` . `custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 0 OR (`media` . `private` = 1 AND `media.mediaFolder.defaultFolder` . `entity` = 'product_download' )))) AND (`media` . `id` IN (0x019B317B41F570B5B7F13A438B7510C8 , 0x019B317B41FC7155A2DD7DECEB28447D ));
Copy
39
0.13 ms
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ; Copy
40
0.31 ms
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%;³'JWðKÉ—\f y_-ýÛå "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? )
)Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x3BB3274A57F04BC9970C795F2DFDDBE5 )); Copy
41
0.29 ms
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%ãyüÀ–óCVŽË\x1E )MEÉ1 "
b";³'JWðKÉ—\f y_-ýÛå "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? , ? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `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` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0xE379FCC096F343568DCB1E294D45C931 , 0x3BB3274A57F04BC9970C795F2DFDDBE5 ));
Copy
42
2.50 ms
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )) AND (seo_url . language_id = ? ) AND (seo_url . sales_channel_id = ? OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 )
Parameters :
[
"/navigation/3bb3274a57f04bc9970c795f2dfddbe5 "
"/navigation/e379fcc096f343568dcb1e294d45c931 "
"/navigation/19ca405790ff4f07aac8c599d4317868 "
"/navigation/48f97f432fd041388b2630184139cf0e "
"/navigation/bb22b05bff9140f3808b1cff975b75eb "
"/navigation/06f5dda360c04112937601574122c515 "
"/navigation/c3057bb031634c669cd6dfb0d4acbb15 "
"/navigation/5d6b1f54e92c42bf89b512baf3b79e08 "
"/navigation/d60d60f6a5e044adbca44cbb25c3125b "
"/navigation/bbc91f8512f3476697f0e9d4fd97483f "
"/navigation/7356bb41f6fc4b168cc34fc7d92d7110 "
"/navigation/4924c22225644deea3a54c3ba6396c85 "
"/navigation/9d89181620be42dcb7e440ce0cd27456 "
"/navigation/e5fbe1167d8443fa95804dd5bbc6ba2e "
"/detail/c398327fdb70490294a6581159118fba "
"/detail/74ebb719dd894af69a7bc395b04b8be7 "
"/detail/cb093799835e4cc0af55a63cc048b10c "
"/detail/0bdda9742c9e45d2a923d375e2c2f4b5 "
"/detail/063ac15fee3d440d82e0d69d3ba23098 "
"/detail/bc772e176b43455f86b18469e45d7b7f "
"/detail/8ab8b40412ae4e8e98b76bc1752ff07a "
"/detail/21a90d37091f46948f5f81f174577d24 "
"/detail/84a8f2a8493b453fac6dad35be5083f2 "
"/detail/f860129315f54302b0050889d17c69af "
"/detail/dd328e2129f941a48ef88aaafe2ca4e5 "
"/detail/82677d0ff64c47bb8f8be3cfe9499707 "
"/detail/2c24583e86ee4eb69e000ca93bccda21 "
"/detail/9a4e1daa66e541f3919e00accff7254a "
"/detail/4ea9b86c9d7f4a499b01312679a21a8e "
"/detail/70af5b7ca7154eb28ba06aae48f12e7e "
"/detail/dfdb32faba584f6da31c53acc368c475 "
"/detail/9853d9ad391c487da18971dd3ca9ce2c "
"/detail/5dcdcd53a3b647b38227cd1a09ca6235 "
"/detail/7bfaf849463c4ba3a793f51e691bf4c4 "
"/detail/86c33aa9909b4d74a16f6b5562a44c9c "
"/detail/ad45ca0ddc40455ea783cae964977497 "
"/detail/a15532674134474e89fb5a7717708ea1 "
"/detail/22cf2793a1e64d888a8b0c84b1222beb "
b"/»_ââšMpªXTÎ|ãâ\v "
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
]
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN ('/navigation/3bb3274a57f04bc9970c795f2dfddbe5' , '/navigation/e379fcc096f343568dcb1e294d45c931' , '/navigation/19ca405790ff4f07aac8c599d4317868' , '/navigation/48f97f432fd041388b2630184139cf0e' , '/navigation/bb22b05bff9140f3808b1cff975b75eb' , '/navigation/06f5dda360c04112937601574122c515' , '/navigation/c3057bb031634c669cd6dfb0d4acbb15' , '/navigation/5d6b1f54e92c42bf89b512baf3b79e08' , '/navigation/d60d60f6a5e044adbca44cbb25c3125b' , '/navigation/bbc91f8512f3476697f0e9d4fd97483f' , '/navigation/7356bb41f6fc4b168cc34fc7d92d7110' , '/navigation/4924c22225644deea3a54c3ba6396c85' , '/navigation/9d89181620be42dcb7e440ce0cd27456' , '/navigation/e5fbe1167d8443fa95804dd5bbc6ba2e' , '/detail/c398327fdb70490294a6581159118fba' , '/detail/74ebb719dd894af69a7bc395b04b8be7' , '/detail/cb093799835e4cc0af55a63cc048b10c' , '/detail/0bdda9742c9e45d2a923d375e2c2f4b5' , '/detail/063ac15fee3d440d82e0d69d3ba23098' , '/detail/bc772e176b43455f86b18469e45d7b7f' , '/detail/8ab8b40412ae4e8e98b76bc1752ff07a' , '/detail/21a90d37091f46948f5f81f174577d24' , '/detail/84a8f2a8493b453fac6dad35be5083f2' , '/detail/f860129315f54302b0050889d17c69af' , '/detail/dd328e2129f941a48ef88aaafe2ca4e5' , '/detail/82677d0ff64c47bb8f8be3cfe9499707' , '/detail/2c24583e86ee4eb69e000ca93bccda21' , '/detail/9a4e1daa66e541f3919e00accff7254a' , '/detail/4ea9b86c9d7f4a499b01312679a21a8e' , '/detail/70af5b7ca7154eb28ba06aae48f12e7e' , '/detail/dfdb32faba584f6da31c53acc368c475' , '/detail/9853d9ad391c487da18971dd3ca9ce2c' , '/detail/5dcdcd53a3b647b38227cd1a09ca6235' , '/detail/7bfaf849463c4ba3a793f51e691bf4c4' , '/detail/86c33aa9909b4d74a16f6b5562a44c9c' , '/detail/ad45ca0ddc40455ea783cae964977497' , '/detail/a15532674134474e89fb5a7717708ea1' , '/detail/22cf2793a1e64d888a8b0c84b1222beb' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
43
0.23 ms
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"""
\x17 \n C\x7F 6ø@²—-ûrøæ¿b
"""
b"\x1E ›mÉ\v RG|·'÷ïeÆ]Ö8X•p\x16 dMä®HÀP\v óÌÈ "
b"¸Rs=·eO;‚°T•Ë!ÚW "
b"Ð[4\ÛyIgƒ\x12\x17 [ÄLKL "
b"á7Ž·€ŠG‘ž\r t\r ]l\x1A "
b"ï\x7F Ù.®S@I’\x06 €\x12 ¨.’‹ "
]
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 (0x170A437F36F840B2972DFB72F8E6BF62 , 0x1E9B6DC90B52477CB727F7EF65C65DD6 , 0x3858957016644DE4AE48C0500BF3CCC8 , 0xB852733DB7654F3B82B05495CB21DA57 , 0xD05B345CDB7949678312175BC44C4B4C , 0xE1378DB7808A478F919E0D740D5D6C1A , 0xEF7FD92EAE53404992068012A82E928B ); Copy
44
0.11 ms
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"qSPI9PlPHoK8zXegKUMx7nAhNbBwBEtV "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'qSPI9PlPHoK8zXegKUMx7nAhNbBwBEtV' ;
Copy