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.12 ms
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
3
0.17 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.32 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 "
"navigation/4924c22225644deea3a54c3ba6396c85 "
"navigation/4924c22225644deea3a54c3ba6396c85/ "
]
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 = 'navigation/4924c22225644deea3a54c3ba6396c85' OR seo_path_info = 'navigation/4924c22225644deea3a54c3ba6396c85/' ));
Copy
5
0.20 ms
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ? ) AND (sales_channel_id = ? ) AND (path_info = ? ) AND (is_canonical = 1 ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
"/navigation/4924c22225644deea3a54c3ba6396c85 "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D ) AND (path_info = '/navigation/4924c22225644deea3a54c3ba6396c85' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
6
0.15 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
"uO4HKf32WpfAR7mk3cKsnmdlcySJZL7K "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D ) AND (token = 'uO4HKf32WpfAR7mk3cKsnmdlcySJZL7K' ) LIMIT 1 ; Copy
7
0.12 ms
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"uO4HKf32WpfAR7mk3cKsnmdlcySJZL7K "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'uO4HKf32WpfAR7mk3cKsnmdlcySJZL7K' ;
Copy
8
0.18 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
9
0.53 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%I$Â"%dML;¦9l… "
]
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 (0x4924C22225644DEEA3A54C3BA6396C85 ));
Copy
10
0.18 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%I$Â"%dML;¦9l… "
]
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 (0x4924C22225644DEEA3A54C3BA6396C85 ))));
Copy
11
0.25 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
12
0.31 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
13
0.34 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
14
0.26 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
15
0.24 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
16
0.13 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
17
0.21 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
18
0.13 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%I$Â"%dML;¦9l… "
]
SELECT `category` . `id` , `category` . `auto_increment` FROM `category` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x4924C22225644DEEA3A54C3BA6396C85 )) LIMIT 1 ;
Copy
19
0.12 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%I$Â"%dML;¦9l… "
]
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 (0x4924C22225644DEEA3A54C3BA6396C85 ));
Copy
20
1.94 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 96
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%30
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
true
b"I$Â"%dML;¦9l… "
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` = 0x4924C22225644DEEA3A54C3BA6396C85 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 96 ;
Copy
21
1.18 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"I$Â"%dML;¦9l… "
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` = 0x4924C22225644DEEA3A54C3BA6396C85 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
22
3.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"I$Â"%dML;¦9l… "
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` = 0x4924C22225644DEEA3A54C3BA6396C85 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
23
1.05 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"I$Â"%dML;¦9l… "
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` = 0x4924C22225644DEEA3A54C3BA6396C85 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
24
0.43 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%\x17 D§ïuÃM|µþ\f iøˆ OÞ¸vMæG\x03 …67†CÏ\x00 é "
b"3J…\e\x00 &HŽ˜¿Åô×R@£ "
b"\e\f OfûæLд÷Ì\v ©\x06 u}e\x06 ÛW\x04 J-±¢Aë€\x1F ³³ "
b"%\x02 1u€\x17 Iä¨z†'^à@Ø "
b"ª\e 误¸@p•&\x13 Ðo…ül "
b"¶"\x1F ÷G÷B\x1A ”*w\x16 úi|\v "
b"é¾’ÿ\x0E -@\x04 «}ÒöX®RM "
b"Ž÷\x1F .\x13 ÌKد\x13 k\x1E\x1F ¿zW "
b"³y\x06 ÷…šB´¾£ùPìÀê\x1D "
b"¿: I9dB/§\x02 j\x0E ñ\x19 ©a "
b"tâ1\t Æ…M_š¶cÉ\x0F X|h "
b"\x19\x13 ôË\x1C ¾Me¬W¿–¾( qL™åŠbªODzcœMN\x14 sü "
b"åoVT\x0F HQ¸ž³<ÉÐv7 "
b"(ÑÚ\x16 š´NÁ¥D\x17 ðÞ\x1E % "
b"‹l Ø’ËF\r ‹4I!Z»\x1F "
b"éÃÈDù"Aà„hôeÍn\x17 › "
b"y±\x12 T‰ãG—›ââcÉ–—> "
b")\f –—Ö…CW‚lWMí+“+ "
b"ˆs;=\x05 eK\x1A Ž\x0F ǽ…É7Œ "
b"ú7>óxÜA£º—Ť\f z›ã "
b"¥$ë‘M?MפŠëT{m5\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 (0x1744A7EF75C34D7CB5FE0C69F888204F , 0xDEB890764DE647038536378643CF00E9 , 0x334A851B0026488E98BFC5F4D75240A3 , 0x1B0C4F66FBE64CD081B4F7CC0BA90675 , 0x7D6506DB57044A2DB1A241EB801FB3B3 , 0x25023175801749E4A87A86275EE040D8 , 0xAA1BE8AFAFB84070952613D06F85FC6C , 0xB6221FF747F7421A942A7716FA697C0B , 0xE9BE92FF0E2D4004AB7DD2F658AE524D , 0x8DF71F2E13CC4BD8AF136B1E1FBF7A57 , 0xB37906F7859A42B4BEA3F950ECC0EA1D , 0xBF3AA0493964422FA7026A0EF119A961 , 0x74E23109C6854D5F9AB663C90F587C68 , 0x1913F4CB1CBE4D65AC57BF96BE28A071 , 0x4C99E58A62AA4FC7B2639C4D4E1473FC , 0x9DE56F56540F4851B89EB33CC9D07637 , 0x28D1DA169AB44EC190A54417F0DE1E25 , 0x8B6CA0D892CB460D8B34498F215ABB1F , 0xE9C3C844F92241E08468F465CD6E179B , 0x79B1125489E347979BE2E263C996973E , 0x290C9697D6854357826C574DED2B932B , 0x88733B3D05654B1A8E0FC7BD85C9378C , 0xFA373EF378DC41A3BA97C5A40C7A9BE3 , 0xA524EB914D3F4DD7A48AEB547B6D350C );
Copy
25
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"\x17 D§ïuÃM|µþ\f iøˆ OÞ¸vMæG\x03 …67†CÏ\x00 é "
b"3J…\e\x00 &HŽ˜¿Åô×R@£ "
b"\e\f OfûæLд÷Ì\v ©\x06 u}e\x06 ÛW\x04 J-±¢Aë€\x1F ³³ "
b"%\x02 1u€\x17 Iä¨z†'^à@Ø "
b"ª\e 误¸@p•&\x13 Ðo…ül "
b"¶"\x1F ÷G÷B\x1A ”*w\x16 úi|\v "
b"é¾’ÿ\x0E -@\x04 «}ÒöX®RM "
b"Ž÷\x1F .\x13 ÌKد\x13 k\x1E\x1F ¿zW "
b"³y\x06 ÷…šB´¾£ùPìÀê\x1D "
b"¿: I9dB/§\x02 j\x0E ñ\x19 ©a "
b"tâ1\t Æ…M_š¶cÉ\x0F X|h "
b"\x19\x13 ôË\x1C ¾Me¬W¿–¾( qL™åŠbªODzcœMN\x14 sü "
b"åoVT\x0F HQ¸ž³<ÉÐv7 "
b"(ÑÚ\x16 š´NÁ¥D\x17 ðÞ\x1E % "
b"‹l Ø’ËF\r ‹4I!Z»\x1F "
b"éÃÈDù"Aà„hôeÍn\x17 › "
b"y±\x12 T‰ãG—›ââcÉ–—> "
b")\f –—Ö…CW‚lWMí+“+ "
b"ˆs;=\x05 eK\x1A Ž\x0F ǽ…É7Œ "
b"ú7>óxÜA£º—Ť\f z›ã "
b"¥$ë‘M?MפŠëT{m5\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 (0x1744A7EF75C34D7CB5FE0C69F888204F , 0xDEB890764DE647038536378643CF00E9 , 0x334A851B0026488E98BFC5F4D75240A3 , 0x1B0C4F66FBE64CD081B4F7CC0BA90675 , 0x7D6506DB57044A2DB1A241EB801FB3B3 , 0x25023175801749E4A87A86275EE040D8 , 0xAA1BE8AFAFB84070952613D06F85FC6C , 0xB6221FF747F7421A942A7716FA697C0B , 0xE9BE92FF0E2D4004AB7DD2F658AE524D , 0x8DF71F2E13CC4BD8AF136B1E1FBF7A57 , 0xB37906F7859A42B4BEA3F950ECC0EA1D , 0xBF3AA0493964422FA7026A0EF119A961 , 0x74E23109C6854D5F9AB663C90F587C68 , 0x1913F4CB1CBE4D65AC57BF96BE28A071 , 0x4C99E58A62AA4FC7B2639C4D4E1473FC , 0x9DE56F56540F4851B89EB33CC9D07637 , 0x28D1DA169AB44EC190A54417F0DE1E25 , 0x8B6CA0D892CB460D8B34498F215ABB1F , 0xE9C3C844F92241E08468F465CD6E179B , 0x79B1125489E347979BE2E263C996973E , 0x290C9697D6854357826C574DED2B932B , 0x88733B3D05654B1A8E0FC7BD85C9378C , 0xFA373EF378DC41A3BA97C5A40C7A9BE3 , 0xA524EB914D3F4DD7A48AEB547B6D350C )) GROUP BY `product` . `id` ;
Copy
26
4.32 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%\x17 D§ïuÃM|µþ\f iøˆ OÞ¸vMæG\x03 …67†CÏ\x00 é "
b"3J…\e\x00 &HŽ˜¿Åô×R@£ "
b"\e\f OfûæLд÷Ì\v ©\x06 u}e\x06 ÛW\x04 J-±¢Aë€\x1F ³³ "
b"%\x02 1u€\x17 Iä¨z†'^à@Ø "
b"ª\e 误¸@p•&\x13 Ðo…ül "
b"¶"\x1F ÷G÷B\x1A ”*w\x16 úi|\v "
b"é¾’ÿ\x0E -@\x04 «}ÒöX®RM "
b"Ž÷\x1F .\x13 ÌKد\x13 k\x1E\x1F ¿zW "
b"³y\x06 ÷…šB´¾£ùPìÀê\x1D "
b"¿: I9dB/§\x02 j\x0E ñ\x19 ©a "
b"tâ1\t Æ…M_š¶cÉ\x0F X|h "
b"\x19\x13 ôË\x1C ¾Me¬W¿–¾( qL™åŠbªODzcœMN\x14 sü "
b"åoVT\x0F HQ¸ž³<ÉÐv7 "
b"(ÑÚ\x16 š´NÁ¥D\x17 ðÞ\x1E % "
b"‹l Ø’ËF\r ‹4I!Z»\x1F "
b"éÃÈDù"Aà„hôeÍn\x17 › "
b"y±\x12 T‰ãG—›ââcÉ–—> "
b")\f –—Ö…CW‚lWMí+“+ "
b"ˆs;=\x05 eK\x1A Ž\x0F ǽ…É7Œ "
b"ú7>óxÜA£º—Ť\f z›ã "
b"¥$ë‘M?MפŠëT{m5\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 (0x1744A7EF75C34D7CB5FE0C69F888204F , 0xDEB890764DE647038536378643CF00E9 , 0x334A851B0026488E98BFC5F4D75240A3 , 0x1B0C4F66FBE64CD081B4F7CC0BA90675 , 0x7D6506DB57044A2DB1A241EB801FB3B3 , 0x25023175801749E4A87A86275EE040D8 , 0xAA1BE8AFAFB84070952613D06F85FC6C , 0xB6221FF747F7421A942A7716FA697C0B , 0xE9BE92FF0E2D4004AB7DD2F658AE524D , 0x8DF71F2E13CC4BD8AF136B1E1FBF7A57 , 0xB37906F7859A42B4BEA3F950ECC0EA1D , 0xBF3AA0493964422FA7026A0EF119A961 , 0x74E23109C6854D5F9AB663C90F587C68 , 0x1913F4CB1CBE4D65AC57BF96BE28A071 , 0x4C99E58A62AA4FC7B2639C4D4E1473FC , 0x9DE56F56540F4851B89EB33CC9D07637 , 0x28D1DA169AB44EC190A54417F0DE1E25 , 0x8B6CA0D892CB460D8B34498F215ABB1F , 0xE9C3C844F92241E08468F465CD6E179B , 0x79B1125489E347979BE2E263C996973E , 0x290C9697D6854357826C574DED2B932B , 0x88733B3D05654B1A8E0FC7BD85C9378C , 0xFA373EF378DC41A3BA97C5A40C7A9BE3 , 0xA524EB914D3F4DD7A48AEB547B6D350C ));
Copy
27
0.19 ms
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
28
53.24 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%\x17 D§ïuÃM|µþ\f iøˆ O\x19\x13 ôË\x1C ¾Me¬W¿–¾( q\e\f OfûæLд÷Ì\v ©\x06 u%\x02 1u€\x17 Iä¨z†'^à@Ø "
b"(ÑÚ\x16 š´NÁ¥D\x17 ðÞ\x1E % "
b")\f –—Ö…CW‚lWMí+“+ "
b"3J…\e\x00 &HŽ˜¿Åô×R@£ "
b"L™åŠbªODzcœMN\x14 sü "
b"tâ1\t Æ…M_š¶cÉ\x0F X|h "
b"y±\x12 T‰ãG—›ââcÉ–—> "
b"}e\x06 ÛW\x04 J-±¢Aë€\x1F ³³ "
b"ˆs;=\x05 eK\x1A Ž\x0F ǽ…É7Œ "
b"‹l Ø’ËF\r ‹4I!Z»\x1F "
b"Ž÷\x1F .\x13 ÌKد\x13 k\x1E\x1F ¿zW "
b"åoVT\x0F HQ¸ž³<ÉÐv7 "
b"¥$ë‘M?MפŠëT{m5\f "
b"ª\e 误¸@p•&\x13 Ðo…ül "
b"³y\x06 ÷…šB´¾£ùPìÀê\x1D "
b"¶"\x1F ÷G÷B\x1A ”*w\x16 úi|\v "
b"¿: I9dB/§\x02 j\x0E ñ\x19 ©a "
b"Þ¸vMæG\x03 …67†CÏ\x00 é "
b"é¾’ÿ\x0E -@\x04 «}ÒöX®RM "
b"éÃÈDù"Aà„hôeÍn\x17 › "
b"ú7>óxÜA£º—Ť\f z›ã "
]
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 (0x1744A7EF75C34D7CB5FE0C69F888204F , 0x1913F4CB1CBE4D65AC57BF96BE28A071 , 0x1B0C4F66FBE64CD081B4F7CC0BA90675 , 0x25023175801749E4A87A86275EE040D8 , 0x28D1DA169AB44EC190A54417F0DE1E25 , 0x290C9697D6854357826C574DED2B932B , 0x334A851B0026488E98BFC5F4D75240A3 , 0x4C99E58A62AA4FC7B2639C4D4E1473FC , 0x74E23109C6854D5F9AB663C90F587C68 , 0x79B1125489E347979BE2E263C996973E , 0x7D6506DB57044A2DB1A241EB801FB3B3 , 0x88733B3D05654B1A8E0FC7BD85C9378C , 0x8B6CA0D892CB460D8B34498F215ABB1F , 0x8DF71F2E13CC4BD8AF136B1E1FBF7A57 , 0x9DE56F56540F4851B89EB33CC9D07637 , 0xA524EB914D3F4DD7A48AEB547B6D350C , 0xAA1BE8AFAFB84070952613D06F85FC6C , 0xB37906F7859A42B4BEA3F950ECC0EA1D , 0xB6221FF747F7421A942A7716FA697C0B , 0xBF3AA0493964422FA7026A0EF119A961 , 0xDEB890764DE647038536378643CF00E9 , 0xE9BE92FF0E2D4004AB7DD2F658AE524D , 0xE9C3C844F92241E08468F465CD6E179B , 0xFA373EF378DC41A3BA97C5A40C7A9BE3 ))));
Copy
29
0.42 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
30
2.00 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"\x02 ‘çxP¼\x16 ÅeÔ«E‘>\r \x02 ´Rÿ-7\x05 $cUÀ/\x15 (Pø\x02 ðçæŽrDÖž±|’9PÖ\x03 -=Á¿Ê$|slN\x0E ÞT§i\x03 e熑ymšîÞ\e F@š\x15\t \x03 wðqs\x1D 4ƒ×xMñuA\x06 -\x03 yyçX¤Kk³\x19\x10 ²îÙ?‹\x03 \x0F H)|È‘ž¥ú}‘g\x0E /\x04\x02 G…JTLÞ°¢n PM\x05 æ\x05 YzJ„eJ–°)½¤ˆ\x04\x0F M\x06 ƒ;øˆÂÁ¥t,q²ÿ–ù \x07 hôF(\e eUùš¯ñ^ÎRÚ\t ŸôÜÿ–ÛaÜØØ\t ßA÷\v\x1E 0 }…IÈ·\x18 ì¾Ef«î\f 9\e\x01 ü*J\x03 ¨º\x13 §¥•Ø·\r Ø\x13 ±¢‰NÊŸÀŒY\x16 Ji"\x0E kM¹\x1E \n M/A\f í°\x06 A@
"""
b"\x0E €¤fÌ,C’¢LQ\x13 ²ºŸ—\x0F Ÿ\n ö†r5‚ð¤V /p
"""
b"\x0F ®¦1žA•£i+\x03 !xÿ´\x11\x04 £\x1A šüET=ï4v\x19 ¶ë\x11 –¯OÐ\x1D ©×TmÛšnŒ8ß\x12\x12 ¢è5ù2‡ÂÀH3KØ\x1E \x13 &N:\x1C Ñg]E®®=*ƒÓ¿\x13 .\x07\x16 Òý°J™‰\x16 >Dâ×X\x13 ww²;o.9çÒ;ÀÙÕû\x13 ¿1¯„\x0E \r —!d\x08 sͶf\x13 ö¤AËsE\x08 —Pú\x04 õ¯’5\x14 ¾å™\x08 ÒqUYˆˆ“Äà´r\x16\x1F ¯€“úI¯¦‡¥1#X;\x7F \x16 Vü„7\f .Ä÷\x18 ø‘°â\x16 ]\x16 xàGCù6¡Lš\x04 åñ‚Žô\x16 žžØÆ´½¢ñ™³%Ë\x01 —`\x17 õ\x05 ´38ÓŸwì\x01 ãš‹\x06 ƒ\x19 x\x15 ÜeNÝ€o¸.9\e ¨î\x19 §–àoKH[£úÀÉSh)\x1A e\x03 &°\x17 M‹»\x0E h˜àôåŒ\x1C •½·rÏD\x05 ŒÛ\x02\x11 üõ’\x1D §\x00 éÛá\x17 2[W\x04 »V\x05 «¦\x1E ¼1\x19 Í£ÔO\x03 ª²;¤d¬\x1F\x14\x13 2«¾£ç´ë50q^'\x1F §(\f 1†JŸ¿CV0\x0F à®s *–’UT\r ©2y çfQÑž "
b"!nÒLÒ\x01 ¾¤Q\x1A Rßœ\x13\x05 y "
b"!£è\x17 qv\x1C ¬ž\x0F\x0F •Zl\x06 ! "
b""áÎòeõ7>`ŽÕŽ\x0F \x1F A "
b"$\x01 JôˆšO\r ¨Þv\x0F ¿Ë\x11 ì "
b"$\x03 †'Œö_ÑOxYˆ(ZbŒ "
b"%\x1A õáfkKp¾¸1\x1E ™ã\x7F á "
b"%IB;nØF¾ƒ³n\x00 \x14 hæ "
b"%g\f ýGGÞHp…€\x0F H¿ ï "
b"&\x01 Ÿ“ÈÞ%I¬`¾ãŒàn® "
b"&™]îæPKF\x18\x1C 8Hp\x18 x) "
b"((K.Lj\x13 ?‚Oó!SàBÉ "
b")ïÍ\x1E ÉÈîséªW*’\x13\x17 "
b"* \x02 ƒz‚O\x1F ¡3U\x1C Z5\ "
b"*‚ú’žC+²ã8ùj›õ} "
b"*èøPÝ^Cܦ\x02 ú:uc‡ "
b"+\e ´Ùåõ\x7F žÝâä\x16 ÌH\x10 "
b"-\x17 LlÒ\x1A @Óæ qZÏœÞ "
b"-V›ZáDá´ÇªEŒƒ´T "
b"-ÍŠÅð$þ¯Û\r Þ3J<\x01\x01 "
b".Â^fRVéöšaÊb©\x01 Rè "
b"0)ŠÝû¦öPQ;)åüÌÊ "
b"4\x04\x19 XÃÁŠ—\x11 Æ\x0F U´1ý¾ "
b"4«7Ù"Ò¥/516xM\x0E D± "
b"6žchôèD\x18 Ž\x02 É\x17 ·\x03\x01 "
b"7>«5ŽÌÄ‘\x04 0¼¼Ù1n\x11 "
b"7_é›\t ƒ#?köHººƒëÇ "
b"7«\x1C ÿ5\x04 e.k ,OEøË "
b"8\x01 öEš»=·fØ„òDÃ!è "
b":\x07 voý#G\x10 €7è:÷áIê "
b"<LB爵Í&Cú[÷M/U• "
b">“ªª\x19 Z) fÈÒÜøZƒ5 "
b"""
>¯øÒ&3BI®]oPiŽ\n
Ô
"""
b"""
>Æ\x07 \n
0\e —Äaà\r à{Æ…,
"""
b"?q>·Gñ…C†(\x1C Ù#œ "
b"A(\x05 MŽ£r뀱Ǽg\x1E 8h "
b"A(GîW‚ë¼é\x17 (ö ýâ "
b"B¤\x19\e §z\e „…\x0F\x07 f7\x04 n? "
b"Dú¬¾\x0F ª›\t lÚf—bJ\x06 "
b"E³L¤-¢K\x0E » +N\x03 B$ "
b"GÁ²¶ÂwIa•C>\x05\x01 ììÇ "
b"Iãue\x1A #z3hŽ ÓÆ8\x12 ê "
b"J1\x12 ða ŒëÒU<8•«ó± "
b"J>~Ù\x04 ÞÉ’\x1C têSO÷œŽ "
b"Jrfëè.GŽ¹&Ž\x0F rƒ» "
b"Jßµ\x14 S GŒí¬¢R\x19 l; "
b"KГ\e 5‚ÊÉ—Ó‘\x1F –.° "
b"KÖ'èðÉe¡‰Y\x18 )SâyD "
b"KÛ?Ä5ÙC\x1C “ÑÈ€Q\x07 §¾ "
b"Lß{Sr*E\x11 ½\r Õ+د–X "
b"Oþ.rùÉJ!²\x05\t dŽ¥%¾ "
b"""
R9ák{×8\n
,\x1C 9ÁU¯v\x02
"""
b"S\x01 G+‹~J[žÉ³—\e Çê• "
b"U\x06 qç(Û@\v –Ãy\x1A 9\x00 ó¢ "
b"W—Ýc@\x17\x11 Æ\x1C ªÔˆëAQ\x15 "
b"Y݇ï\e ×O©Ÿ'b\x15 úny! "
b"Y÷OÛE}J\x1E ™•Ð\x1C §Î\x08 @ "
b"[I9\x1C\x1F B\x1E ‚ã‚\x16 väa~ "
b"\Ž\x11 ¼WB™\ï÷1É°ƒ ä "
b"\ã8iÅ»Ž¯+%ë‹Ç±Fl "
b"\ùEB\x00 Ã2…Dz\x05 슶3¥ "
b"] bm\r ž\f 7rUÿ·_°“0 "
b"^ädIM±\x19 l;eÄR_N™û "
b"`™¢NædN§°Giá`'¶. "
b"d\t Bb`~5ØR\x19 k"³ßß "
b"dmUª\x1C ë'çÖ;\x10\x1C s-\x7F × "
b"d¼ršèXš-Ŗ¨K G\x0E "
b"""
e\n
˜û€AN 'XÀ›†"¥
"""
b"eÛJþ¾æJ—\x05\x05 6QǦ”. "
b"i\x1D €Ž.˜¹á¹\x03 Œà+\x18 Ãþ "
b"isSR‹ìE\x02 ¦¢\x1D\x05 W\f Sˆ "
b"i{åßÏ鳶\¶Oølu\x1E "
b"j0þÖJSI…€4çûϱ«p "
b"j\x04 Ò=r¢îP\x17 Ç@Ž’=i "
b"jêT'i:éøµÉŽGAe£j "
b"nžÈ\x03 bœ:êÀúÀ¨Ñµ\x08 3 "
b"nä`\x12\x01\v £G™J-Çd½> "
b"oÞÇ\x02 ÀÓß’MòOúLž´Õ "
b"q”ïIå'D´£_hº”-\x04 P "
b"rŸêÐ*‘ì`«Z'¿\\x04 mp "
b"t&¯ZT\v ¶\x05 Ù¾µoøHà "
b"vsE~]\t Iß‹¯ía<$x] "
b"vË\x10 G†eG§´ \x13 Ïù|\x01 / "
b"xLq¬xÇB€Š…€çªsf "
b"x’ú¿\x18 ì¿E\x13 F– ëªg\x7F "
b"{\x0E €\v 64û^{\x10\v 4;•µÙ "
b"{$‚K'u[QE’\r sç”È\x15 "
b"{¦¢¡'ów=,ŠÓ®N»› "
b"{ãVËQ\x14 Ko¬Âð‡\x00 §\x19 ò "
b"}ó Ü™ÁOщœBJP¨Ge "
b"€\x14 n\x04 ÚÇaf“q\x0E áÙ\x11 î\x11 "
b"€ÞœŸénÅÙ1˜ÿpö¼— "
b"\x0E ꨆãn€Þ•)\x13 Å;ò÷ "
b"ƒ\x11\x07 #Á¥Gbt<ÿ®~"žp "
b"""
ƒ€©\n
\x1F J© H½\x06 ™êÅؼƒÒÖžÿBߤR5øJ·» "
b"„U~ߎcBÒÅÅ¡^\r K± "
b"„†;ªŸ4ëxC¦wâÊÉáž "
b"†\x13\x00 ÷/B|›`¸ø Î\x1C "
b"ˆ@Hj&,2.DMüÎÅ\x06 "z "
b"‹H‘§\x17 Æƹ\x07\x10 PÔ¸4\x10 "
b"‹²¬9ÖU⡽’=Fjí« "
b"‹´Ä\t ë£IŽŸérɹzö "
b"‹ím\x1F\x11 J\x18 ˜CŒ÷Žé7f} "
b"Œ\x06 ’ã†;þ^\x00 ‚¬Âûêñ[ "
b"""
Œ@O¯åŽE¡Ô\n
Óa,Æ\t
"""
b"Œí5Ú5úC9†õÎ\x01\x07 2/h "
b"Œï˾Ñ\x08 Jn‰\x07 Žj¼ˆö\x1A "
b"Ž\x16 Fíqv‡á¢¬Ùl¹zû "
b"\x08 ƒ‚æÎÄÑ&U\x7F\t u«\x04 L "
b"èÏá(J\x19 œ!\v ùÁmƒS "
b"”R\x19 z@u/¹gÞ\x0E\x1C a@l_ "
b"”‚Ú»’àJ\x7F ¢²ÄbŽ\x7F s† "
b"•„s2šI)º\x08 ·‚ŒG-[ "
b"•¡\v Ÿÿ]íÔ•ëö²ÁŽ=Ñ "
b"–Ó¦ˆ\x01 Jâ\x1C\x05 Ì%v³\r µ” "
b"›@½Ž%\x07 @¨ŽŽÌþ\r Da3 "
b"›˜po\x1E ·O¾~‚\x06 {\x01 âsH "
b"Ž\x02 ÆH¡\x08 #ä5æÃ2k¸ "
b"žîJ\x03 ‘ñM`ˆÀá´¿›ˆ\x18 "
b" 5\x7F òû“àNˆoú$4µ²\x1D "
b" H1\e ±™•õÑõŸ™w†Õ¢ "
b" šzkХ݈¬…"vajl™ "
b" ÞFø°G맯ômû8bñ\x02 "
b" á\x06 Âá½€#\x01 ØTaÐÁZù "
b"¡®\x02 À\x1D ¶D\x1E Sü‚,²ŠÑÌ "
b"¢Ç\x05 á/z©9\x1F —\t #‡¹£° "
b"£Q\x11 ñ}ŸMá‰WÉþÜ·×> "
b"£Éx @ÚC¼‡>L\x19 ¤ØÔ˜ "
b"£Ö|\f E[N•®\x16 /\x19 î{M "
b"¤ä;]¯¯Ãë]/ =¥ÔÄ "
b"¦\x7F !ÌþSHЫ\x11 ùR†y~d "
b"§U\x13 T‹[ÍõAØs©ê‚j "
b"""
¨\n
©o©›K“®2Ó“Uqkã
"""
b"¨\x14 nTušLu¯³yz3eoü "
b"¨\x02 c§¤·ü0mz5ÈK\x02 < "
b"¨¡íGaÿI#£_ksŽéU\x17 "
b"¨L\"WJ™Ž¶©¯#\x06 Y "
b"©\x05 ®õ™êÉ\x1F °Yý措³\x10 "
b"©x¬§éAþø0†Å,±à\x08 é "
b"«È\x02 f/ï\x00 àZA‚sjšKù "
b"¬ˆ/åÓºŸRYÈfÙiõ¿ "
b"""
\v )»Ë\x17 F&£‡\x18 H5\n
H#
"""
b"\x19 ÅðPŠIáµiÊßÔ%IÈ "
b"¯=~ò 7©L`ó_žÎgµq "
b"°séØÄoBã¡V€\x1D !\8` "
b"²µwu÷°M-„\x06 ‚5¨)bJ "
b"³'\x05 •C1K,st\x02 ù²”{ "
b"¶½/¹\x19 E¸Ê_|\.ÿuÿ\x04 "
b"¹\x7F +=8d†³à9¼:ó,* "
b"¹ÏÚUíEEž²Y1§\e\x04 ·‘ "
b"ºL\x13\x11 XðM[œŽ†ÀÆÃNž "
b"ºu\x1F Ôÿ\x08 €7ì–\x1D C\x10 0Â "
b"""
º¦(M\n
¨¤©Ó;Ÿ\x01 ¯yÁk
"""
b"""
»d[5¿cÜ\n
\f\v w\x06 R^—
"""
b"¼\x7F As.à@%µƒCc\x00 %(… "
b"¾8¹È\x7F\x1E ¦ZŽH¥ñ\x01 ö¥Í "
b"À] ŽÃŽ…\x12 K°¡M‘¬Þ€ "
b"Àš=…fÓ†µªá¨Ò•ù·¾ "
b"ÀžŒ…8ºMäž!Ò\x15 +¾\z "
b"Á{\x0E Çôß¹âÞ#*Ð;_\x1D "
b"Âê<„Õìê\x18 A\r Q_ž½Ô} "
b"Ã"«¤DCNyºöê@\e R'7 "
b"Ã’9\x02 Zù.«Šppýáþ§Q "
b"ø9Ÿ¾\x16 K—’µ¬ö[È’U "
b"ÃÚÌOãÓL\v ¿¡ü"Ï!Z; "
b"ÃàÏ[œP<1sÛÞ°YÑ "
b"Ä\x04\x17 ª{E"A²Ö†\x18 w²ç[ "
b"Ä"®“ØQLY6¬™^\x06 µì5 "
b"Ä5ýµ†&J\x02 £‡\x1E ^oä®Ò "
b"ÄäpLf\x1A l?öŒüL«š× "
b"Å\x1F ñS\x04\e {ÛI†–´x˜jx "
b"ÆÖƒ¢\x1E GNã«Ì\x05 ã“\x15 T& "
b"È„p†ã8H_•¢QJœ9ü2 "
b"É\x1A\x14 âýÉóH]è;tgUÓÂ "
b"ɺý\x0E ¾Öþœ5$“ÑåŒT„ "
b"ɼp†§a`,\x1E å\r =ò]\r Á "
b"ÊsŠßÕUY|‘ì_\x14 ¸@'¸ "
b"""
ÊèYߤ\x1C ’\x14 %oˆ\x17 Ú\n
NŸ
"""
b"Ëâi¾í\Mʪg“¨a\x04 …> "
b"Î*,jwH\e ¿•\x15 ºÄ\x02 "
b"Îf\x10 Š\x07 ÿÐש5‹ÇzŽ÷ "
b"ÎÊUÙÔ8âÖ\x11 ‰zÂÜ—“ñ "
b"ÎËjki£4ßvAϲÀ¦o÷ "
b"Ðú0“riO¸¢»×¿\x05 Ií@ "
b"Ñ\x05 é¼>XV"!ñ%¥bQ¸P "
b"Ñ€\x02\x17 BêH–¤‘ïrŒqÂ| "
b"ÓÓYܨŸ3W}Ê^h”Ž‘ "
b"Ô£I\f Ë—@ܤð'\x14\x12 ¸_¡ "
b"Õ”RèÁRV¨\x12 ÝIÊ.¤Z† "
b"֪̖“üE´«"ÁÒ\x0F 8\x10 « "
b"×x|*#’@Ò™+\x18\x05 ¶hDð "
b"×óvVDtI\x00 ³8]¿Á®B "
b"ØÐU\x19 ˜(Cl¦\¢\x1E û™Ö+ "
b"Øá•A9£EM¨™`À¶Å?z "
b"ÞšÅë_à>T?MÍ;B>\x11 ˆ "
b"ÞúÞÇ‹F¾«æÑÍÚ»dY "
b"ß\x13\x02 à\x10 *|åF8UB²/@ "
b"ßo\x7F ƒpŒ@#¤òE2Ü™ªà "
b"à\x18 röÛÄKx\x01 ö X\x1A r\x7F "
b"á^Ê€\x7F ‚\x10 3GÛ¾„ŸC‹V "
b"âa¸\x00 ðZ:Ú1\r vS\x01 žE´ "
b"âÙS²µãN««\e ü²&Ä\e b "
b"âî#\x1A ÙÁ€NÏ:PŠ6‹ÓJ "
b"ã\x10 …!Æ°Ý\x06 j\x06 l½ù&v\x02 "
b"ã×µâ\x05 \kk\f Ec»(W¡Z "
b"äX_:ƒGCF‚ëV1Wó\x18\x1C "
b"""
ä}·õ¿¢%r\x06 \n
›xþ¥=ä
"""
b"幺Gà0EP…:CŽ«\x08 =E "
b"æA땉oMÆɦu\x02 ôì® "
b"æ\x7F\x19 ?ÑôFÃ ©\x16 ;†NU. "
b"æ\x7F ³½©ØVd\x06 à\x12 ý²\\x00 ƒ "
b"çºJÚY(H\n Š,¨\x00\x04 $gð "
b"é‹\f §ÁO\x1D •l¥ù·\t\x11 ¢ "
b"ì\x10 ±åãÃÏO²>Å.¾Å, "
b"ìðé±(<¾ð€ô\x0E\x18 +Èêú "
b"í/µéÇâGvš\x0E KSTŠ.± "
b"""
íú×\n
¬ìå\x05 òyÙ\x1C {Žób
"""
b"î‘+DÀ-ág\f ¢2¼¸\x07 Û\x1E "
b"ïÈc´™’\ß+5gê\x08 ¦|> "
b"ðp3 \x13 ÉETÕmjÞkœð "
b"ño\x04\x18 éŽ\x0F -‹Çz\x00 O|,¸ "
b"óƒ@\x07 U4jz¡DøÎ ñ[• "
b"""
ô†4\x02 \n
\x1D IÎЋ•Ïð;\x08 ô×_“]9]ý¡«ØÎ\x13\x16 ÍA "
b"õNÄ:º“A“›.Tò\x13 Bj "
b"÷uzXŒÊK\x13 ¥o\x1D ùtÓLË "
b"øo¿k°Ö¯ö˜ùÌéƒ\x13\t n "
b"ù*˜}ÖJɵí(´»Å~þ "
b"ùG·6v{I\x12 »OžúÙVžÑ "
b"ú}«d™Î[Ä*½Íùý.~ "
b"û\x15 é\x12 ÃS>|\x06 yÔ‹\x7F dœ "
b"üB×£qðã¾\x03 @ÞýëÜÑ "
b"ý\x12 /;\x1F ;G©‡´;7n-; "
b"""
ý—)…u«uÉJ\x14 x'\x7F \n
aÂ
"""
b"þ8\x1C øµIV¼LÐïç„ì\r ý "
b"þ•¥çÓ…¯ðp\x0E LþÀ}SÖ "
b"ÿ\x18\x7F IΦzô–ªcuÖŒ.& "
]
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 (0x0291E77850BC16C565D4AB9045913E0D , 0x02B452FF2D3705246355C02F152850F8 , 0x02F0E7E68E7244D69EB17C92399050D6 , 0x032D3DC1BFCA247C736C4E0EDE54A769 , 0x0365E78691796D9AEEDE1B46409A1509 , 0x0377F071731D3483D7784DF17541062D , 0x037979E758A44B6BB31910B2EED93F8B , 0x038F0F48297CC8919EA5FA7D91670E2F , 0x040247854A544CDEB0A26EA0504D05E6 , 0x05597A4A84654A96B029BDA488040F4D , 0x06833BF888C2C1A5742C71B2FF96F920 , 0x0768F446281B6555F99AAFF15ECE52DA , 0x099FF4DCFF969DDB61DCD8D809DF41F7 , 0x0B1E30A07D8549C8B718ECBE4566ABEE , 0x0C391B01FC2A4A03A8BA13A7A595D8B7 , 0x0DD813B1A2894ECA9FC08C59164A6922 , 0x0E6B4D8FB91E0A4D2F410CEDB0064140 , 0x0E80A466CC2C4392A24C5113B2BA9F97 , 0x0F9F0AF6867235C282F0A48F56A02F70 , 0x0FAEA6319E8F4195A3692B032178FFB4 , 0x1104A31A9AFC45543DEF34768119B6EB , 0x1196AF4FD01DA9D7546DDB9A6E8C38DF , 0x1212A2E835F93287C2C38048334BD81E , 0x13264E3A1CD1675D45AEAE3D2A83D3BF , 0x132E0716D2FDB04A9989163E44E2D758 , 0x139D7777B23B6F2E39E7D23BC0D9D5FB , 0x13BF31AF840E0D9721640873CD9DB666 , 0x13F6A441CB7345089750FA04F5AF9235 , 0x14BEE59908D2715559888893C4E0B472 , 0x161FAF8093FA49AFA687A53123583B7F , 0x1656FC84370C2EC4F718F891B0E2165D , 0x1678E04743F936A14C9A04E5F1828EF4 , 0x169E9ED8C6B4BDA2F199B325CB019760 , 0x17F505B43338D39F77EC01E39A8B0683 , 0x19789015DC654EDD806FB82E391BA8EE , 0x19A796E06F4B485BA3FAC0C953689D29 , 0x1A650326B0174D8BBB0E6898E0F4E58C , 0x1C95BDB772CF44058CDB9D0211FCF592 , 0x1DA700E9DBE117325B5704BB5605ABA6 , 0x1EA0BC3119CDA3D44F03AAB23BA464AC , 0x1F14133281ABBEA3E7B4EB3530715E27 , 0x1FA7280C31864A9FBF4356300FE0AE73 , 0x202A969255540DA93279A0E76651D19E , 0x216ED24CD201BEA4511A52DF9C130579 , 0x21A3E81771761CAC9E0F0F955A6C0621 , 0x22E1CEF265F5373E608DD58D0F811F41 , 0x24014AF4889A4F0DA8DE760FBFCB11EC , 0x240386278CF65FD14F785988285A628C , 0x251AF5E1666B4B70BEB8311E99E37FE1 , 0x2549423B6ED846BE83B36E009D1468E6 , 0x25670CFD4747DE487085800F48BF20EF , 0x26019F93C8DE2549AC60BEE38CE06EAE , 0x26995DEEE6504B46181C384870187829 , 0x28284B2E4C6A133F824FF32153E042C9 , 0x29EFCD1EC981C8EE73E9AA572A921317 , 0x2A2002837A824F1FA1339D551C5A355C , 0x2A82FA92819E432BB2E338F96A9BF57D , 0x2AE8F850DD5E43DC81A602FA3A756387 , 0x2B901BB4D9E5F57F9EDDE2E416CC4810 , 0x2D174C6CD21A40D38FE620715ACF9CDE , 0x2D56819B5AE144E1B4C7AA458C83B454 , 0x2DCD8AC5F024FEAFDB0DDE334A3C0101 , 0x2EC25E665256E9F69A61CA62A90152E8 , 0x30298ADDFBA6F650513B29E5FCCCCA8F , 0x34041958C3C18A9711C60F55B431FDBE , 0x34AB37D922D2A52F353136784D0E44B1 , 0x369E6368F4E844188E028FC917B70301 , 0x373EAB358DCCC4910430BCBCD9316E11 , 0x375FE99B0983233F6BF648BABA83EBC7 , 0x37ADAB1CFF3504652E6BA02C4F45F8CB , 0x3801F6459ABB3DB766D884F244C321E8 , 0x3A07766FFD2347108037E83AF7E149EA , 0x3C4C42EFAA9ECD2643FA5BF74D2F5595 , 0x3E93AAAA195A292066C8D2DCF85A8335 , 0x3EAFF8D226334249AE5D6F50698E0AD4 , 0x3EC6070A301B97C461E00DE07BC6852C , 0x3F713EB747F185439D86281CD99D239C , 0x4128054D8DA372EB80B1C7BC671E3868 , 0x412847EE5782EBBCE91728F620FD8FE2 , 0x42A4191BA77A1B84850F076637046E3F , 0x44FAACBE0FAA9BAD096CDA6697624A06 , 0x45B34CA42DA24B0EBBA0A02B4E034224 , 0x47C1B2B6C277496195433E0501ECECC7 , 0x49E375651A237A33688E20D3C63812EA , 0x4A3112F061A08CEBD2553C3895ABF3B1 , 0x4A3E7ED904DEC9921C74EA534FF79C8D , 0x4A7266EBE82E478DB98F268E0F7283BB , 0x4ADFB5145320478CEDACA252199D6C3B , 0x4BD0931B9D3582CAC997D3911F962EB0 , 0x4BD627E8F0C965A18959182953E27944 , 0x4BDB3FC435D9431C93D1C8805107A7BE , 0x4CDF7B53722A4511BD0DD52BD8AF9658 , 0x4FFE2E72F9C94A21B20509648EA525BE , 0x5239E16B7BD7380A2C1C39C155AF7602 , 0x5301472B8B7E4A5B9EC9B3971BC7EA95 , 0x550671E728DB400B96C3791A3900F3A2 , 0x5797DD63401711C61CAAD488EB415115 , 0x59DD87EF1BD74FA99F276215FA6E7921 , 0x59F74FDB457D4A1E9995D01CA7CE0840 , 0x5B8F49391C1F421E82E3821676E4617E , 0x5C8D11BC5742995CEFF731C9B083A0E4 , 0x5CE33869C5BB8EAF2B25EB8BC7B1466C , 0x5CF9454200C33285447A05EC8AB633A5 , 0x5DA0626D0D9E0C377255FFB75FB09330 , 0x5EE464494DB1196C3B65C4525F4E99FB , 0x6099A24EE6644EA7B04769E16027B62E , 0x64094262607E35D852196B8F22B3DFDF , 0x646D55AA1CEB27E7D63B101C732D7FD7 , 0x64BC729AE8589A2DC596C2A84BA0470E , 0x650A98FB80414EC2A02758C09B8622A5 , 0x65DB4AFEBEE64A9705053651C7A6942E , 0x691D808D2E98B9E1B9038CE02B18C3FE , 0x697353528BEC4502A6A21D05570C5388 , 0x697BE590DFCFE9B3B65CB64FF86C751E , 0x6A30FED64A5349858034E7FBCFB1AB70 , 0x6A9004D23D72A2EE5017C7408E923D69 , 0x6AEA5427693AE9F8B5C98D474165A36A , 0x6E9EC803629C3AEAC0FAC0A8D1B50833 , 0x6EE4AD6012010BA347994A2DC764BD3E , 0x6FDEC702C0D3DF924DF24FFA4C9EB4D5 , 0x7194EF49E52744B4A35F68BA942D0450 , 0x729FEAD02A91EC60AB5A27BF5C046D70 , 0x7426AF5A540BB60581D9BEB56FF848E0 , 0x7673457E5D0949DF8BAFED613C24785D , 0x76CB1047866547A7B4A013CFF97C012F , 0x784C71AC78C742808A8580E7AA739D66 , 0x7892FABF18ECBF45134696A0EBAA677F , 0x7B0E800B3634FB5E7B100B343B95B5D9 , 0x7B24824B27755B5145920D73E794C815 , 0x7BA6A2A127F3773D2C8AD3AE4EBB909B , 0x7BE356CB51144B6FACC2F08700A719F2 , 0x7DF320DC99C14FD1899C424A50A84765 , 0x80146E04DAC7616693710EE1D911EE11 , 0x80DE9C9FE96EC5D93198FF70F6BC979D , 0x810EEAA886E36E80DE952913C53BF2F7 , 0x83110723C1A54762743CFFAE7E229E70 , 0x8380A90A1F4AA9A048BD0699EAC5D8BC , 0x83D2D69EFF9D42DFA45235F84AB7BB90 , 0x8455817EDF8E6342D2C5C5A15E0D4BB1 , 0x84863BAA9F34EB7843A677E2CAC9E19E , 0x861300F72F90427C8F9B60B8F8A0CE1C , 0x8840486A262C322E444DFCCEC506227A , 0x8B4891A717ADC6C6B9071050D4B83410 , 0x8BB2AC39D655E2A1BD923D466AEDAB9D , 0x8BB4C409EBA3498D819FE972C9B97AF6 , 0x8BED6D1F114A1898438CF78EE937667D , 0x8C0692E3863BFE5E0082ACC2FBEAF15B , 0x8C404FAFE58D45C2A1D40AD3612CC609 , 0x8CED35DA35FA433986F5CE0107322F68 , 0x8CEFCBBED1084A6E89078E6ABC88F61A , 0x8E1646ED717687E19DA2ACD96CB97AFB , 0x8F088382E6CEC4D126557F0975AB044C , 0x8FE8CFE1AD284A199C210BF9C16D8353 , 0x9452197A40752FB967DE0E1C61406C5F , 0x9482DABB92E04A7FA2B2C4628D7F7386 , 0x95847390329A4929BA08B7828C472D5B , 0x95A10B9FFF5DEDD495EBF6B2C18D3DD1 , 0x96D3A688014AE21C05CC2576B30DB594 , 0x9B40BD8D250740A88D8ECCFE0D446133 , 0x9B98706F1EB74FBE7E82067B01E27348 , 0x9D8F8D02C648A10823E435E6C3326BB8 , 0x9EEE4A0391F14D6088C0E1B4BF9B8818 , 0xA0357FF2FB93E04E886FFA2434B5B21D , 0xA048311BB19995F5D1F59F997786D5A2 , 0xA09A7A6BD0A5DD88AC852276616A6C99 , 0xA0DE46F8B047EBA7AFF46DFB3862F102 , 0xA0E106C2E1BD802301D85461D0C15AF9 , 0xA1AE02C01DB6441E53FC822CB28AD1CC , 0xA2C705E12F7AA9391F97092387B9A3B0 , 0xA35111F17D9F4DE18957C9FEDCB7D73E , 0xA3C9782040DA43BC873E4C19A4D8D498 , 0xA3D67C0C455B4E95AE169D2F19EE7B4D , 0xA4E43B5DAFAFC3EB5DAD2FA03DA5D4C4 , 0xA67F21CCFE5348D0AB11F95286797E64 , 0xA75513548B5B8FCDF541D873A9EA826A , 0xA80AA96FA99B4B93AE32D39355716BE3 , 0xA8146E54759A4C75AFB3797A33656FFC , 0xA89D0263A7A4B7FC306D7A35C84B023C , 0xA8A1ED4761FF4923A35F6B738DE95517 , 0xA8AD4C5C22574A998DB6A9AF81230659 , 0xA905AEF599EAC91FB059FDE68EAAB310 , 0xA978ACA7E941FEF83086C52CB1E008E9 , 0xABC802662FEF00E05A4182736A9A4BF9 , 0xAC882FE5D3BA9F5259C86681D969F5BF , 0xAD0B29BBCB174626A3871848350A4823 , 0xAD19C5F0508A49E1B569CADFD42549C8 , 0xAF3D7EF2A037A94C60F35F9ECE67B571 , 0xB073E9D8C46F42E3A156801D215C3860 , 0xB2B57775F7B04D2D84068235A829624A , 0xB327059543314B2C81737402F9B2947B , 0xB6BD2FB91945B8CA5F7C5C2EFF75FF04 , 0xB97F2B3D386486B3E039BC3AF32C812A , 0xB9CFDA55ED45459EB25931A71B04B791 , 0xBA4C131158F04D5B9C8E86C0C6C34E9E , 0xBA751FD4FF9D088037EC961D431030C2 , 0xBAA6284D0AA8A4A9D33B9F01AF79C16B , 0xBB645B35BF63DC0A900C0B7706525E97 , 0xBC7F41732EE04025B583436300252885 , 0xBE38B9C87F1EA65A8D48A5F101F6A5CD , 0xC05D208DC38E85124BB0A14D91ACDE80 , 0xC09A3D8566D386B5AAE1A8D295F9B7BE , 0xC09E8C8538BA4DE49E21D2152BBE5C7A , 0xC17B0EC7F4DF8FB9E2DE232AD03B5F1D , 0xC2EA3C84D5ECEA18410D515F9EBDD47D , 0xC322ABA444434E79BAF6EA401B522737 , 0xC39239025AF92EAB8A7070FDE1FEA751 , 0xC3B8399FBE164B9792B5ACF65BC89255 , 0xC3DACC4FE3D34C0BBFA1FC22CF215A3B , 0xC3E0CF5B9C503C3173DBDEADB059D19D , 0xC40417AA7B452241B2D6861877B2E75B , 0xC422AE93D8514C5936AC995E06B5EC35 , 0xC435FDB586264A02A3871E5E6FE4AED2 , 0xC4E4704C661A6C3FF6818CFC4CAB9AD7 , 0xC51FF153041B7BDB498696B478986A78 , 0xC6D683A21E474EE3ABCC05E393155426 , 0xC8847086E338485F95A2514A9C39FC32 , 0xC91A14E2FDC9F3485DE83B746755D3C2 , 0xC9BAFD0EBED6FE9C352493D1E58C5484 , 0xC9BC7086A761602C1EE50D3DF25D0DC1 , 0xCA738ADFD555597C91EC5F14B84027B8 , 0xCAE859DFA41C9214256F8817DA0A4E9F , 0xCBE269BEED5C4DCAAA6793A86104853E , 0xCE2A902C6A77481BBF951581BA90C402 , 0xCE66108A07FFD0D7A9358B8FC77A8DF7 , 0xCECA55D9D438E2D611897AC2DC9793F1 , 0xCECB6A6B69A334DF7641CFB2C0A66FF7 , 0xD0FA309372694FB8A2BBD7BF0549ED40 , 0xD105E9BC3E58562221F125A56251B850 , 0xD180021742EA4896A491EF728C71C27C , 0xD3D359DCA89F33577DCA5E68C2948D91 , 0xD4A3490CCB9740DCA4F0271412B85FA1 , 0xD59452E8C15256A812DD49CA2EA45A86 , 0xD6AACC9693FC45B4AB22C1D20F3810AB , 0xD7787C2A239240D2992B1805B66844F0 , 0xD7F3765644744900B390385DBFC1AE42 , 0xD8D055199828436CA65CA21EFB99D62B , 0xD8E1954139A3454DA89960C0B6C53F7A , 0xDE9AC5EB5FE03E543F4DCD3B423E1188 , 0xDEFADEC7C28B46BEABE6D1CDDABB6459 , 0xDF1302E0102A7CE546389D5542B22F40 , 0xDF6F7F83708C4023A4F24532DC99AAE0 , 0xE01872F6DBC44B788F01F620581A727F , 0xE15ECA807F82103347DBBE849F438B56 , 0xE261B800F05A3ADA310D7653019E45B4 , 0xE2D953B2B5E34EABAB1BFCB226C41B62 , 0xE2EE231AD9C1804ECF3A508A368BD34A , 0xE3108521C6B0DD066A066CBDF9267602 , 0xE3D7B5E2055C6B6B0C4563BB2857A15A , 0xE4585F3A8347434682EB563157F3181C , 0xE47DB7F5BFA22572060A9B78FEA53DE4 , 0xE5B9BA47E0304550853A438DAB083D45 , 0xE641EB95896F4DC690C9A67502F4ECAE , 0xE67F193FD1F446C3A0A9163B864E552E , 0xE67FB3BDA9D8566406E012FDB25C0083 , 0xE7BA4ADA5928480A8A2CA800042467F0 , 0xE98B0CA7C19D4F1D956CA5F9B70911A2 , 0xEC10B1E5E3C3CF4FB23EC52E9DBEC52C , 0xECF0E9B1283CBEF080F40E182BC8EAFA , 0xED2FB5E9C7E247769A0E4B53548A2EB1 , 0xEDFAD70AACECE505F279D91C7B8EF362 , 0xEE912B44C02DE1670CA232BCB807DB1E , 0xEFC863B499925CDF2B3567EA08A67C3E , 0xF07033A013C9455481D56D6ADE6B9CF0 , 0xF16F0418E98E0F2D8BC77A004F7C2CB8 , 0xF383400755346A7AA144F8CEA0F15B95 , 0xF48634020A1D49C38ED08B95CFF03B08 , 0xF4D75F935D395DFDA1ABD8CE1316CD41 , 0xF54EC43ABA934193909B2E54F213426A , 0xF7757A588CCA4B13A56F1DF974D34CCB , 0xF86FBF6BB0D6AFF698F9CCE98313096E , 0xF92A987D9DD64AC9B5ED28B4BBC57EFE , 0xF947B736767B4912BB4F9EFAD9569ED1 , 0xFA7DAB6499CE5BC42ABD9DCDF9FD2E7E , 0xFB15E912C3533E7C810679D48B7F649C , 0xFC4290D7A371F0E3BE0340DEFDEBDCD1 , 0xFD122F3B1F3B47A99D87B43B376E2D3B , 0xFD97298575AB75C94A1478277F0A61C2 , 0xFE381CF8B54956BC4CD0EFE784EC0DFD , 0xFE95A5E7D385AFF0700E4CFEC07D53D6 , 0xFF187F49CEA67AF496AA6375D68C2E26 );
Copy
31
0.31 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"Á¸R´ñûO›ªÌV™›;94 "
b"Î\x7F Œ\r "ÂFòŽ ª\f á\x0E ÷² "
b"‘éÚ\x1E ìŒEÙ€H÷‹\f Fb« "
b"]ŽÃd0\x05 MaH-Ž2\x14 ¿÷ "
b"Í\x0E `]m\x1F G…š•U}£/½ "
b"÷W\x15 €\x02 ¯@ŸŽÑaà(~ÆÁ "
b"A»I_\x16 KB)ŠT›"<3›W "
b"•Êð²\x14 4KU¤+ztl\³; "
b"År\x13 žG©HH¨˜ú\x01 i¥N® "
b"\x15 'þÿFL¡,ÆÊ’\x0E 5m "
b"7¹“ñ\x1A ÂCj·Ž»(»]\ "
b"Bdé\r ¹O®²ƒ¼Õ\x10 ÖZó "
b"\x08 Eñ\t 8Eê·Ö,«ŽÉùŒ ]
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 (0xC1B852B4F1FB4F9BAACC56999B3B3934 , 0xCE7F8C0D22C246F28EA0AA0CE10EF7B2 , 0x91E9DA1EEC8C45D98048F78B0C4662AB , 0x5D8DC36430054D6181482D8D3214BFF7 , 0xCD0E605D6D1F47859A95559D7DA32FBD , 0xF757158002AF409F8DD161E0287EC6C1 , 0x41BB495F164B42298A549B223C339B57 , 0x95CAF0B214344B55A42B7A746C5CB33B , 0xC572139E47A94848A898FA0169A54EAE , 0x81159D27FEFF464CA12CC6CA920E356D , 0x37B993F11AC2436AB78EBB28BB5D5C90 , 0x4264E90DB99D4FAEB283BCD510D65AF3 , 0x0845F1098F3845EAB7D62CAB8DC9F98C ));
Copy
32
0.15 ms
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = ? OR `id` = ?
Parameters :
[
b"I$Â"%dML;¦9l… "
b"w¹YÏfÞL\x15 Çù·Ú9‚ó "
]
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = 0x4924C22225644DEEA3A54C3BA6396C85 OR `id` = 0x77B959CF66DE4C1590C7F9B7DA3982F3
;
Copy
33
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
34
0.11 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
35
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
36
0.08 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
37
0.09 ms
SELECT path FROM category WHERE id = ?
Parameters :
[
b"I$Â"%dML;¦9l… "
]
SELECT path FROM category WHERE id = 0x4924C22225644DEEA3A54C3BA6396C85 ; Copy
38
0.07 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
39
0.29 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
40
0.11 ms
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ; 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%I$Â"%dML;¦9l… "
]
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 (0x4924C22225644DEEA3A54C3BA6396C85 )); Copy
42
0.27 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"I$Â"%dML;¦9l… "
]
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 , 0x4924C22225644DEEA3A54C3BA6396C85 ));
Copy
43
1.05 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/4924c22225644deea3a54c3ba6396c85 "
"/navigation/e379fcc096f343568dcb1e294d45c931 "
"/navigation/19ca405790ff4f07aac8c599d4317868 "
"/navigation/48f97f432fd041388b2630184139cf0e "
"/navigation/bb22b05bff9140f3808b1cff975b75eb "
"/navigation/06f5dda360c04112937601574122c515 "
"/navigation/c3057bb031634c669cd6dfb0d4acbb15 "
"/navigation/5d6b1f54e92c42bf89b512baf3b79e08 "
"/navigation/d60d60f6a5e044adbca44cbb25c3125b "
"/navigation/bbc91f8512f3476697f0e9d4fd97483f "
"/navigation/7356bb41f6fc4b168cc34fc7d92d7110 "
"/navigation/3bb3274a57f04bc9970c795f2dfddbe5 "
"/navigation/9d89181620be42dcb7e440ce0cd27456 "
"/navigation/e5fbe1167d8443fa95804dd5bbc6ba2e "
"/detail/1744a7ef75c34d7cb5fe0c69f888204f "
"/detail/deb890764de647038536378643cf00e9 "
"/detail/334a851b0026488e98bfc5f4d75240a3 "
"/detail/1b0c4f66fbe64cd081b4f7cc0ba90675 "
"/detail/7d6506db57044a2db1a241eb801fb3b3 "
"/detail/25023175801749e4a87a86275ee040d8 "
"/detail/aa1be8afafb84070952613d06f85fc6c "
"/detail/b6221ff747f7421a942a7716fa697c0b "
"/detail/e9be92ff0e2d4004ab7dd2f658ae524d "
"/detail/8df71f2e13cc4bd8af136b1e1fbf7a57 "
"/detail/b37906f7859a42b4bea3f950ecc0ea1d "
"/detail/bf3aa0493964422fa7026a0ef119a961 "
"/detail/74e23109c6854d5f9ab663c90f587c68 "
"/detail/1913f4cb1cbe4d65ac57bf96be28a071 "
"/detail/4c99e58a62aa4fc7b2639c4d4e1473fc "
"/detail/9de56f56540f4851b89eb33cc9d07637 "
"/detail/28d1da169ab44ec190a54417f0de1e25 "
"/detail/8b6ca0d892cb460d8b34498f215abb1f "
"/detail/e9c3c844f92241e08468f465cd6e179b "
"/detail/79b1125489e347979be2e263c996973e "
"/detail/290c9697d6854357826c574ded2b932b "
"/detail/88733b3d05654b1a8e0fc7bd85c9378c "
"/detail/fa373ef378dc41a3ba97c5a40c7a9be3 "
"/detail/a524eb914d3f4dd7a48aeb547b6d350c "
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/4924c22225644deea3a54c3ba6396c85' , '/navigation/e379fcc096f343568dcb1e294d45c931' , '/navigation/19ca405790ff4f07aac8c599d4317868' , '/navigation/48f97f432fd041388b2630184139cf0e' , '/navigation/bb22b05bff9140f3808b1cff975b75eb' , '/navigation/06f5dda360c04112937601574122c515' , '/navigation/c3057bb031634c669cd6dfb0d4acbb15' , '/navigation/5d6b1f54e92c42bf89b512baf3b79e08' , '/navigation/d60d60f6a5e044adbca44cbb25c3125b' , '/navigation/bbc91f8512f3476697f0e9d4fd97483f' , '/navigation/7356bb41f6fc4b168cc34fc7d92d7110' , '/navigation/3bb3274a57f04bc9970c795f2dfddbe5' , '/navigation/9d89181620be42dcb7e440ce0cd27456' , '/navigation/e5fbe1167d8443fa95804dd5bbc6ba2e' , '/detail/1744a7ef75c34d7cb5fe0c69f888204f' , '/detail/deb890764de647038536378643cf00e9' , '/detail/334a851b0026488e98bfc5f4d75240a3' , '/detail/1b0c4f66fbe64cd081b4f7cc0ba90675' , '/detail/7d6506db57044a2db1a241eb801fb3b3' , '/detail/25023175801749e4a87a86275ee040d8' , '/detail/aa1be8afafb84070952613d06f85fc6c' , '/detail/b6221ff747f7421a942a7716fa697c0b' , '/detail/e9be92ff0e2d4004ab7dd2f658ae524d' , '/detail/8df71f2e13cc4bd8af136b1e1fbf7a57' , '/detail/b37906f7859a42b4bea3f950ecc0ea1d' , '/detail/bf3aa0493964422fa7026a0ef119a961' , '/detail/74e23109c6854d5f9ab663c90f587c68' , '/detail/1913f4cb1cbe4d65ac57bf96be28a071' , '/detail/4c99e58a62aa4fc7b2639c4d4e1473fc' , '/detail/9de56f56540f4851b89eb33cc9d07637' , '/detail/28d1da169ab44ec190a54417f0de1e25' , '/detail/8b6ca0d892cb460d8b34498f215abb1f' , '/detail/e9c3c844f92241e08468f465cd6e179b' , '/detail/79b1125489e347979be2e263c996973e' , '/detail/290c9697d6854357826c574ded2b932b' , '/detail/88733b3d05654b1a8e0fc7bd85c9378c' , '/detail/fa373ef378dc41a3ba97c5a40c7a9be3' , '/detail/a524eb914d3f4dd7a48aeb547b6d350c' )) 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
44
0.36 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
45
0.10 ms
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"uO4HKf32WpfAR7mk3cKsnmdlcySJZL7K "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'uO4HKf32WpfAR7mk3cKsnmdlcySJZL7K' ;
Copy