1
0.22 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.09 ms
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
3
0.15 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.30 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/9350ecd5bd6e4f85b7a14c85c0c3b31e "
"navigation/9350ecd5bd6e4f85b7a14c85c0c3b31e/ "
]
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/9350ecd5bd6e4f85b7a14c85c0c3b31e' OR seo_path_info = 'navigation/9350ecd5bd6e4f85b7a14c85c0c3b31e/' ));
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/9350ecd5bd6e4f85b7a14c85c0c3b31e "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D ) AND (path_info = '/navigation/9350ecd5bd6e4f85b7a14c85c0c3b31e' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
6
0.12 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
"iefUwdT0f5xvjtVwLogw72mdNu2TcIma "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D ) AND (token = 'iefUwdT0f5xvjtVwLogw72mdNu2TcIma' ) LIMIT 1 ; Copy
7
0.09 ms
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"iefUwdT0f5xvjtVwLogw72mdNu2TcIma "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'iefUwdT0f5xvjtVwLogw72mdNu2TcIma' ;
Copy
8
0.16 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.49 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%“PìÕ½nO…·¡L…Àó\x1E "
]
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 (0x9350ECD5BD6E4F85B7A14C85C0C3B31E ));
Copy
10
0.17 ms
SELECT `category_translation` . `name` as `category_translation.name` , `category_translation` . `breadcrumb` as `category_translation.breadcrumb` , `category_translation` . `slot_config` as `category_translation.slotConfig` , `category_translation` . `link_type` as `category_translation.linkType` , `category_translation` . `internal_link` as `category_translation.internalLink` , `category_translation` . `external_link` as `category_translation.externalLink` , `category_translation` . `link_new_tab` as `category_translation.linkNewTab` , `category_translation` . `description` as `category_translation.description` , `category_translation` . `meta_title` as `category_translation.metaTitle` , `category_translation` . `meta_description` as `category_translation.metaDescription` , `category_translation` . `keywords` as `category_translation.keywords` , `category_translation` . `custom_fields` as `category_translation.customFields` , `category_translation` . `created_at` as `category_translation.createdAt` , `category_translation` . `updated_at` as `category_translation.updatedAt` , `category_translation` . `category_id` as `category_translation.categoryId` , `category_translation` . `language_id` as `category_translation.languageId` , `category_translation` . `category_version_id` as `category_translation.categoryVersionId` FROM `category_translation` WHERE (`category_translation` . `category_version_id` = ? ) AND (((`category_translation` . `category_id` IN (? ))))
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%“PìÕ½nO…·¡L…Àó\x1E "
]
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 (0x9350ECD5BD6E4F85B7A14C85C0C3B31E ))));
Copy
11
0.23 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.28 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.29 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.25 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.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;ûÍ "
]
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.11 ms
SELECT `product_sorting` . `id` FROM `product_sorting` WHERE (`product_sorting` . `active` = ? ) ORDER BY `product_sorting` . `priority` DESC
SELECT `product_sorting` . `id` FROM `product_sorting` WHERE (`product_sorting` . `active` = 1 ) ORDER BY `product_sorting` . `priority` DESC ;
Copy
17
0.20 ms
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = ? ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"´ \x18 ·vGÉ‹\t\x17 DV;ûÍ "
b"""
\Ú\x06 .~GΔ\x15 d¼¾\x05 \n
«
"""
b"ëbxQRjE-¸Ùc™#é!° "
b"X`\r üN$N ©\x1F P\x1A ‚}8ž "
b"~sÌ+¤ÝJá‘\t dA\\x16 vJ "
b"–7JüB½A’¥Š\x1F r«—Gà "
b"\x06 jkîü~Kn‰)ÖL(ˆ¥\x1A "?xÂbúL¿ŸÕ1œ1Q±& "
]
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (0xB4A018B7768147C98B091744563BFBCD , 0x5CDA06202E7E47CE941564BCBE050AAB , 0xEB627851526A452DB8D9639923E921B0 , 0x58600DFC4E244E20A91F501A827D389E , 0x7E73CC2BA4DD4AE1910964415C16764A , 0x96374AFC42BD4192A58A1F72AB9747C3 , 0x066A6BEEFC7E4B6E8929D64C2888A51A , 0x223F78C262FA4CBF9FD5319C3151B126 );
Copy
18
0.11 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%“PìÕ½nO…·¡L…Àó\x1E "
]
SELECT `category` . `id` , `category` . `auto_increment` FROM `category` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x9350ECD5BD6E4F85B7A14C85C0C3B31E )) LIMIT 1 ;
Copy
19
0.10 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%“PìÕ½nO…·¡L…Àó\x1E "
]
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 (0x9350ECD5BD6E4F85B7A14C85C0C3B31E ));
Copy
20
7.59 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 768
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%30
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
true
b"“PìÕ½nO…·¡L…Àó\x1E "
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` = 0x9350ECD5BD6E4F85B7A14C85C0C3B31E 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 768 ;
Copy
21
4.44 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"“PìÕ½nO…·¡L…Àó\x1E "
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` = 0x9350ECD5BD6E4F85B7A14C85C0C3B31E 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
15.66 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"“PìÕ½nO…·¡L…Àó\x1E "
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` = 0x9350ECD5BD6E4F85B7A14C85C0C3B31E 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
3.94 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"“PìÕ½nO…·¡L…Àó\x1E "
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` = 0x9350ECD5BD6E4F85B7A14C85C0C3B31E 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%_ÇQ¯ä\x0F @‹’šA¡BŽÒ9 "
b"Ž„e?œ\x16 Dñ›Owu[4çà "
b"x\x1C âZáÆB_»\x10 Уòê¹ "
b"%\x0F “u|¶CB½\x07 .¾X‚Nî "
b"b|%ekEO‚‡ôvaüJê„ "
b"™&rmäL\x07 ±r‰\x19 *ûÉ "
b"P\x05 kõ)YF\x06 ˆ\x08 AÝp?Fd "
b"²C€u™cI¹ôÂâ%Æën "
b"qWž¥(i@?\x02 |¥f<ª™ "
b"…\x19 ð™H¿D‹£4Á°ä\x12 °E "
b"9\x18 õíÅzBÏŽ“\ú\x16 ¸” "
b"\¯Ž\x1E HI¼OÕfL4¢Ö "
b"Ps6W\x06 bAOºÞÇ!3ñ$S "
b"TŽ¡|+\e LJ²•¹\x06 Ón«¼ "
b"€rž\x1E Ÿ)KÌ‚‡\x1A aõbO\x05 "
b"\x08 ^„ï_IHr“8*~¾\x10 âµ\x0E ãÅ‘øTAĘí\r <9\v ß-:+?¦öàO\x10 ·îe/2ur¡ "
b"DÈ•¸• BŠ²ò+¾þ\x0E rê "
b" \x7F /’†HAĺDqZRÎ0\x15 "
b"e4°ŠÄE\r ‘º!H½—]` "
b"‚r;´D†H\x16 ¨Qfâe¤\r "
b"üêºé7œK–¨¶ Í”´\x05 "
b"o™-j2?HûқÌüJ\x06 Ö "
]
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 (0x5FC751AFE40F408B929A41A1428ED239 , 0x8E84653F9C1644F19B4F77755B34E7C3 , 0x781CE25AE1C6425FBB10D0A3F28FEAB9 , 0x250F93757CB64342BD072EBE58824EEE , 0x627C25656B454F8287F47661FC4AEA84 , 0x999D26726DE44C07ADB17289192AFBC9 , 0x50056BF529594606880841DD703F4664 , 0xB2438075996349C2B9F4C2E225C6EB6E , 0x71579EA52869403FAD027CA5663CAA99 , 0x8519F09948BF448BA334C1B0E412B045 , 0x3918F5EDC57A42CF8D935CFA8116B894 , 0x5CAFAD8D1E4849BCAD4FD5664C34A2D6 , 0x507336570662414FBADEC72133F12453 , 0x548DA17C2B1B4C4AB295B906D36EABBC , 0x80729E1E9F294BCC82871A61F5624F05 , 0x085E84EF5F49487293382A7EBE10E2B5 , 0x0EE3C591F85441C498ED0D3C390BDF2D , 0x3A2B3FA6F6E04F10B7EE652F327572A1 , 0x44C895B89520428AB2F22BBEFE0E72EA , 0xA07F2F92864841C4BA44715A52CE3015 , 0x6534B08AADC4450D91BA2148BD975D60 , 0x82723BB444864816A89D5166E265A40D , 0xFCEABAE9379C4B96A8B62081CD94B405 , 0x6F992D6A323F48C3BBD29BCCFC4A06D6 );
Copy
25
0.61 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"_ÇQ¯ä\x0F @‹’šA¡BŽÒ9 "
b"Ž„e?œ\x16 Dñ›Owu[4çà "
b"x\x1C âZáÆB_»\x10 Уòê¹ "
b"%\x0F “u|¶CB½\x07 .¾X‚Nî "
b"b|%ekEO‚‡ôvaüJê„ "
b"™&rmäL\x07 ±r‰\x19 *ûÉ "
b"P\x05 kõ)YF\x06 ˆ\x08 AÝp?Fd "
b"²C€u™cI¹ôÂâ%Æën "
b"qWž¥(i@?\x02 |¥f<ª™ "
b"…\x19 ð™H¿D‹£4Á°ä\x12 °E "
b"9\x18 õíÅzBÏŽ“\ú\x16 ¸” "
b"\¯Ž\x1E HI¼OÕfL4¢Ö "
b"Ps6W\x06 bAOºÞÇ!3ñ$S "
b"TŽ¡|+\e LJ²•¹\x06 Ón«¼ "
b"€rž\x1E Ÿ)KÌ‚‡\x1A aõbO\x05 "
b"\x08 ^„ï_IHr“8*~¾\x10 âµ\x0E ãÅ‘øTAĘí\r <9\v ß-:+?¦öàO\x10 ·îe/2ur¡ "
b"DÈ•¸• BŠ²ò+¾þ\x0E rê "
b" \x7F /’†HAĺDqZRÎ0\x15 "
b"e4°ŠÄE\r ‘º!H½—]` "
b"‚r;´D†H\x16 ¨Qfâe¤\r "
b"üêºé7œK–¨¶ Í”´\x05 "
b"o™-j2?HûқÌüJ\x06 Ö "
]
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 (0x5FC751AFE40F408B929A41A1428ED239 , 0x8E84653F9C1644F19B4F77755B34E7C3 , 0x781CE25AE1C6425FBB10D0A3F28FEAB9 , 0x250F93757CB64342BD072EBE58824EEE , 0x627C25656B454F8287F47661FC4AEA84 , 0x999D26726DE44C07ADB17289192AFBC9 , 0x50056BF529594606880841DD703F4664 , 0xB2438075996349C2B9F4C2E225C6EB6E , 0x71579EA52869403FAD027CA5663CAA99 , 0x8519F09948BF448BA334C1B0E412B045 , 0x3918F5EDC57A42CF8D935CFA8116B894 , 0x5CAFAD8D1E4849BCAD4FD5664C34A2D6 , 0x507336570662414FBADEC72133F12453 , 0x548DA17C2B1B4C4AB295B906D36EABBC , 0x80729E1E9F294BCC82871A61F5624F05 , 0x085E84EF5F49487293382A7EBE10E2B5 , 0x0EE3C591F85441C498ED0D3C390BDF2D , 0x3A2B3FA6F6E04F10B7EE652F327572A1 , 0x44C895B89520428AB2F22BBEFE0E72EA , 0xA07F2F92864841C4BA44715A52CE3015 , 0x6534B08AADC4450D91BA2148BD975D60 , 0x82723BB444864816A89D5166E265A40D , 0xFCEABAE9379C4B96A8B62081CD94B405 , 0x6F992D6A323F48C3BBD29BCCFC4A06D6 )) GROUP BY `product` . `id` ;
Copy
26
67.43 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%_ÇQ¯ä\x0F @‹’šA¡BŽÒ9 "
b"Ž„e?œ\x16 Dñ›Owu[4çà "
b"x\x1C âZáÆB_»\x10 Уòê¹ "
b"%\x0F “u|¶CB½\x07 .¾X‚Nî "
b"b|%ekEO‚‡ôvaüJê„ "
b"™&rmäL\x07 ±r‰\x19 *ûÉ "
b"P\x05 kõ)YF\x06 ˆ\x08 AÝp?Fd "
b"²C€u™cI¹ôÂâ%Æën "
b"qWž¥(i@?\x02 |¥f<ª™ "
b"…\x19 ð™H¿D‹£4Á°ä\x12 °E "
b"9\x18 õíÅzBÏŽ“\ú\x16 ¸” "
b"\¯Ž\x1E HI¼OÕfL4¢Ö "
b"Ps6W\x06 bAOºÞÇ!3ñ$S "
b"TŽ¡|+\e LJ²•¹\x06 Ón«¼ "
b"€rž\x1E Ÿ)KÌ‚‡\x1A aõbO\x05 "
b"\x08 ^„ï_IHr“8*~¾\x10 âµ\x0E ãÅ‘øTAĘí\r <9\v ß-:+?¦öàO\x10 ·îe/2ur¡ "
b"DÈ•¸• BŠ²ò+¾þ\x0E rê "
b" \x7F /’†HAĺDqZRÎ0\x15 "
b"e4°ŠÄE\r ‘º!H½—]` "
b"‚r;´D†H\x16 ¨Qfâe¤\r "
b"üêºé7œK–¨¶ Í”´\x05 "
b"o™-j2?HûқÌüJ\x06 Ö "
]
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 (0x5FC751AFE40F408B929A41A1428ED239 , 0x8E84653F9C1644F19B4F77755B34E7C3 , 0x781CE25AE1C6425FBB10D0A3F28FEAB9 , 0x250F93757CB64342BD072EBE58824EEE , 0x627C25656B454F8287F47661FC4AEA84 , 0x999D26726DE44C07ADB17289192AFBC9 , 0x50056BF529594606880841DD703F4664 , 0xB2438075996349C2B9F4C2E225C6EB6E , 0x71579EA52869403FAD027CA5663CAA99 , 0x8519F09948BF448BA334C1B0E412B045 , 0x3918F5EDC57A42CF8D935CFA8116B894 , 0x5CAFAD8D1E4849BCAD4FD5664C34A2D6 , 0x507336570662414FBADEC72133F12453 , 0x548DA17C2B1B4C4AB295B906D36EABBC , 0x80729E1E9F294BCC82871A61F5624F05 , 0x085E84EF5F49487293382A7EBE10E2B5 , 0x0EE3C591F85441C498ED0D3C390BDF2D , 0x3A2B3FA6F6E04F10B7EE652F327572A1 , 0x44C895B89520428AB2F22BBEFE0E72EA , 0xA07F2F92864841C4BA44715A52CE3015 , 0x6534B08AADC4450D91BA2148BD975D60 , 0x82723BB444864816A89D5166E265A40D , 0xFCEABAE9379C4B96A8B62081CD94B405 , 0x6F992D6A323F48C3BBD29BCCFC4A06D6 ));
Copy
27
0.21 ms
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
28
120.60 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%\x08 ^„ï_IHr“8*~¾\x10 âµ\x0E ãÅ‘øTAĘí\r <9\v ß-%\x0F “u|¶CB½\x07 .¾X‚Nî "
b"9\x18 õíÅzBÏŽ“\ú\x16 ¸” "
b":+?¦öàO\x10 ·îe/2ur¡ "
b"DÈ•¸• BŠ²ò+¾þ\x0E rê "
b"P\x05 kõ)YF\x06 ˆ\x08 AÝp?Fd "
b"Ps6W\x06 bAOºÞÇ!3ñ$S "
b"TŽ¡|+\e LJ²•¹\x06 Ón«¼ "
b"\¯Ž\x1E HI¼OÕfL4¢Ö "
b"_ÇQ¯ä\x0F @‹’šA¡BŽÒ9 "
b"b|%ekEO‚‡ôvaüJê„ "
b"e4°ŠÄE\r ‘º!H½—]` "
b"o™-j2?HûқÌüJ\x06 Ö "
b"qWž¥(i@?\x02 |¥f<ª™ "
b"x\x1C âZáÆB_»\x10 Уòê¹ "
b"€rž\x1E Ÿ)KÌ‚‡\x1A aõbO\x05 "
b"‚r;´D†H\x16 ¨Qfâe¤\r "
b"…\x19 ð™H¿D‹£4Á°ä\x12 °E "
b"Ž„e?œ\x16 Dñ›Owu[4çà "
b"™&rmäL\x07 ±r‰\x19 *ûÉ "
b" \x7F /’†HAĺDqZRÎ0\x15 "
b"²C€u™cI¹ôÂâ%Æën "
b"üêºé7œK–¨¶ Í”´\x05 "
]
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 (0x085E84EF5F49487293382A7EBE10E2B5 , 0x0EE3C591F85441C498ED0D3C390BDF2D , 0x250F93757CB64342BD072EBE58824EEE , 0x3918F5EDC57A42CF8D935CFA8116B894 , 0x3A2B3FA6F6E04F10B7EE652F327572A1 , 0x44C895B89520428AB2F22BBEFE0E72EA , 0x50056BF529594606880841DD703F4664 , 0x507336570662414FBADEC72133F12453 , 0x548DA17C2B1B4C4AB295B906D36EABBC , 0x5CAFAD8D1E4849BCAD4FD5664C34A2D6 , 0x5FC751AFE40F408B929A41A1428ED239 , 0x627C25656B454F8287F47661FC4AEA84 , 0x6534B08AADC4450D91BA2148BD975D60 , 0x6F992D6A323F48C3BBD29BCCFC4A06D6 , 0x71579EA52869403FAD027CA5663CAA99 , 0x781CE25AE1C6425FBB10D0A3F28FEAB9 , 0x80729E1E9F294BCC82871A61F5624F05 , 0x82723BB444864816A89D5166E265A40D , 0x8519F09948BF448BA334C1B0E412B045 , 0x8E84653F9C1644F19B4F77755B34E7C3 , 0x999D26726DE44C07ADB17289192AFBC9 , 0xA07F2F92864841C4BA44715A52CE3015 , 0xB2438075996349C2B9F4C2E225C6EB6E , 0xFCEABAE9379C4B96A8B62081CD94B405 ))));
Copy
29
0.48 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.48 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"\x00\x00 [Ñ.ÞH˜²ŠÈ€²þ‹¤\x00\x15 f>ô¾E±”DÆb8ÉÁu\x00 0`þæ=D‚³‘fzrlè \x00 <{5¥ûJO£›üE(9rÅ\x00 CVÚ³¸H\x15 ¿AA·ƒRï\x16 \x00 H\x03 ©½$"ôè\n €|Øšw¡\x00 M»³\x10\x15 C,¼¬ø5œÝ\x10 º\x00 h›hÙ\x1E K¬‰y×Δ\x03 žM\x00 k‚Tö\x0F E}²©õ‹´u\n \x00 ~úJ¢áIv¼L—A \x10\x03 ¶\x00 ‚\x03 ›¨\x05 Eù°‘·\x1E ¹‹Ý§\x00 Ž”âGÏO¬‚B•”8•\x1E\x04 \x00 Âg\x10 §jN•¿%VJ½”öe\x00 ίž!?Cr³úû“´oQ\x00 Þðîè×C•«R\r \x1D æn¹T\x00 ð\x11 å¿mI'–£K\e Í+4\x00 þ]\x07 {ñGeœ@^jDH‘4\x01 0ó$+\x1D M‘†Ø‘i¢Æ,´\x01 CÁ\x00 i€»\x15 ˆ†éqJ,wF\x01 ˆÊ×5\x1D A"›Ä鑶·Ï\x01 ”õìˆSLÛ˜äUî\x08 ~\‹\x01 §í³¿I@ ¹p>ÉeR/Ä\x01 ϼ»ML\x11 Ž»MÙ²Gm±\x01 ãj}5‚D‹¶ð£o©ã\x02 0É·RPKr¡Õ#áK¶\x04 \x02 6Q•T‘A»²\v\e EQ\x12 åç\x02 8{\x1A F\x1A Hž½*Î<Ð\t º\x18 \x02 ŽÂ#ÙïJT¾‡Ž¬½×Yÿ\x02 ´Rÿ-7\x05 $cUÀ/\x15 (Pø\x02 ½b”\x12 çN\x1C ‚¸%\x1E Ó$Žs\x02 ij5—Ö@®¿\x07 sçà*(A\x03 \r OÌŠ”L³#CÏž•ùý\x03\x11 T\x01 ú8DÀƒ*\x1E ßçÉ\x14 »\x03 -=Á¿Ê$|slN\x0E ÞT§i\x03 -CÚƽDüƒáý9Ý5£\x05 \x03 S×KÊ'@œŽ±*7R¤Ø”\x03 wðqs\x1D 4ƒ×xMñuA\x06 -\x03 G³4\x17 Bñ¦}à£%ʇ…\x03 õF\x0F •SD²€ÔÇ\x1E &˜»Ë\x04\x1A\x05 T@yèßÁ<tw/FÜ,\x04 H–œíI@½£~̙ɯ\x10 ‘\x04 Ž\x1C í\x1E «N‡£\v ‹AX„ç\x1C \x04 ø¾1ÒCñœ‰úz^WßN\x04 ÕZlo2Ló»ž\x03 hZü·»\x04 ü±\x07 =´N\x1C Ž¢ãïPºb\x07 \x05 Ô·\x1F ~€H} óäq¦P"¿\x06 \HB‚\n Fů\x14\x15 ¡°\x1E 15
"""
b"\x06 bü˜<䶃%€h{Áb$\x06 yÀD$”JŒ ÈO*\x1C ‰ÀÙ\x06 “Æw[#OX‘¹u\x1A ‡\x03 £«\x06 Ä03é(Aî¹9ONN…«K\x06 æd•ƒxF\x1D ±\f i\x11\x1E W\x1A !\x07 /8±&ù@t€tɶØÄv¦\x07 hôF(\e eUùš¯ñ^ÎRÚ\x07 ¥ïüÙ\x00 KV¼¯Å=C—ˆ;\x07 à´\x0E œ\x0F @U©\x07 jƒ\f –æÒ\x07 âPÊΚI\x1E ²ñ?\x10 F%Ùã\x08\x13 =ÝÝ¢3\ê^ß~òšüv\x08 z$AÊHGR³GŸc$ñÏu\x08 Áˆ†´M$¤kCÕ÷ \x7F \t\x15 îo)<Lö¨å¯…!þïk\t\x18 sdïÓI?¨^\x1E D¢.øä\t 2à\x04 »MP€L\x03\x10 ÷}pM\t \x1D ð\x1A €´Ë\x07 ¿zíè\x0F c\n Y\x0E 2ô\x0F HÀ›\n
Ùvh˜p
"""
b"""
\n —\x07 J“ß@?€\x10 .\e N˜\x17 ^
"""
b"""
\n ™Y¤†[£Pá×\v P‰ù§(
"""
b"""
\n }–-\x0F ²\x1A ¿\x0E Mx‰Pü6
"""
b"""
\n Ü—&\e Xɽ\x01 ‰èúþßî
"""
b"\v\x1C %!˜ØOªõ\x10 eåÿº&\v h"Ò™ø•„@‘Ùõö¾~\v Ìš\e\x14 A'Áí\x13 ž†›ƒm\v ñ,—À\x05 ˜\x13 $U Zï¿2é\f 9\e\x01 ü*J\x03 ¨º\x13 §¥•Ø·\f uÈ;ª\x01 @‡€‹®'£½úq\r ɧoˆ«\x15\x0F êO¥ÎPÌBH\r Ú\x02 ©<ÿ$$•\r ñ{\x1E SÛ\x0E .eB’¶B\x02 ‰zn\x05 `~ü/\x0E WïT\x1C\x17 C,¬Nµ\x19 Þ9òÇ\x0F A¿@aù\r p£¾3„óWä’\x0F N\x11 ØÊÑO>¤\x1A Î?\x13 ëP\\x11\x01 èEA$Ä]^¬\x18 ½€ƒ\f\x18 \x11\x04 £\x1A šüET=ï4v\x19 ¶ë\x11 –\v ŠApLT¹³±\x1E\f ÂAó\x11 –¯OÐ\x1D ©×TmÛšnŒ8ß\x11 æ€4z½Ot„Eêî\x1D ìLõ\x12\x12 ¢è5ù2‡ÂÀH3KØ\x1E \x13 \r ±]ÞéGÏŸ\x13 ª\v ÉW´´\x13 VqÍ‹š§Îñl(Ce\x1D T/\x13 ww²;o.9çÒ;ÀÙÕû\x15 p\x17\x0E YƒV\e ½WÑY¯\x1F ä`\x15 …\x18\x18\x13 &Ь”\x04 ^zEÝï<\x16 xàGCù6¡Lš\x04 åñ‚Žô\x16 Žw<&(®’äå)ÿ…G†Õ\x16 óµi8X@Ïžoc8\x02 zÓÑ\x17 2ü…!”Dôž›¨*¶ºÁ™\x17 a\x1C ¹7\x1C @v³™\x15 ›á8!«\x17 lGòŸ^ ¶¬\x08 …É-]×Þ\x17 †Íöï¸CÔŒè\t ÑÖ¨MÙ\x17 õ\x05 ´38ÓŸwì\x01 ãš‹\x06 ƒ\x18 è4÷ÙRŠ\x0F ´Q—ƒ\v w\x14 a\e 'Œ†³éHŠ¸ë$\x07\x11 “ò¼\x1C Ž\x08 œPzB\x03\x01 Þ½è˜õ\x7F Q\x1D P*èN ~\x18 ¥V\x04 ,㯒\x1D §q<ŒâX³“\x08 ±¢`Õ\x11\x0F \x1D ÀÇ\x05 ÖIG\x1E €‘C\x07 ªþ£\x0E \x1E 1‡¶|0XùJ×(×\x7F 1'á\x1E ?ße3É\n ø\x0E ΋§‘¿fÎ
"""
b"\x1F §(\f 1†JŸ¿CV0\x0F à®s!•¹;\x08 E׳ݻ\x11 X išÊ "
b""•!Ï„íH¡ºFÎ_\x17 ôìÉ "
b"#T?á&|0ZkD“%SGL "
b"#ŠNñ%\x10 H#¼}{tQ|Nv "
b"#Ëð\x0F aÓNc¸X„\x11 °³g\n "
b"$\x03 †'Œö_ÑOxYˆ(ZbŒ "
b"$^v\x1F ' M\x19 ¼È¤š¨ÐßL "
b"%læy£cO†‹hë¨ !~ "
b"&\x01 Ÿ“ÈÞ%I¬`¾ãŒàn® "
b"&\x18\x12 _ Ž\x12 ¤Ðdv.ßÖt» "
b"&\x7F w¢Y…Jc—q\x07 %\e þ§ó "
b"((K.Lj\x13 ?‚Oó!SàBÉ "
b"()ž±òjK\x00 ƒ\x7F\x0E ð‘J\x13\x06 "
b")4¦ã–#Nr˜%pøèÊ>á "
b"*m\x05 Y–õxzxC"WÒa“ "
b"-\x17 LlÒ\x1A @Óæ qZÏœÞ "
b"-H¯q©‘D̺\e }P¢OøF "
b"""
-ŽûoýûLÒ‹ÔwÖi\n
AŠ
"""
b"-•(\\x1A õHø¥4‚ÝŽš\x07 ¯ "
b".ˆL±¶\x13 HŽÝ?-Y\x1C Gíþ "
b"/sˆ",\x11 N®–8H³AUè8 "
b"0/Xï¥_àß\x02 ”Gv+¡K³ "
b"0H€cÎRNE¼[Üœ\x01 ´èä "
b"""
1\x14\x1A ‚\n
‘@…¢\r @\v “\x01 :L
"""
b"1Þ¾¡þƒºß,ˆ·JÍQGj "
b"2¬AóNó„«Ö\v |q¡´}b "
b"4¤^5‘\f Jä\e œ69z¾Ž "
b"7x”Ô5\x16 @Œ ‹Oü•q\r = "
b"8Q0[dû§é8+¾zdpüz "
b"9Þÿϳ"K7„+|ôs©4† "
b":Ï~V\x08\x12 m›\x1C UuF:\x14 ¾¯ "
b":죑\x11 ûºÙK’UEËË³Æ "
b";´\x00 ^ã¾Nò¡\r =‘~ð Ê "
b"<1ÿ\x00 PîJ\x10 „/¡\n \x06 ”L "
b"<Ÿ\x10 îÇ\x1E p5AL\x7F ¬‹ö±â "
b"<Ìz;1©@Ê¿]\x1A »”\x00\x1D Ý "
b"=\x1D )Ô\x15 µ§É5ŒÉ“}JÈ‘ "
b"=>{\x18 E.¿¼\x0F i>1C\x07 •h "
b">:3ìfõr>Îݶv\x1A _R "
b">gç\x03 ÷ïFê»UþÛniÐ\x0E "
b">\x11 1¢{Mï«rrßÕ7^\x03 "
b">¥ ?™ÕL’žNÛ\e %jì\x01 "
b">Ã\x17 *pk\x16 jöDÓ\x19 Ý‚Cï "
b"?ŽEÇQè\x1C «Ð’JEºü8ì "
b"?ý’´Ã”E‹µ&›ÌÐRˆ\f "
b"AŠ\x06 \r ]‡I¢¶3ªÖiP@Å "
b"B\x0E ÏÜÎHÔF_É5\x12 §\e "
b"CYJ¢õïÐ7-nëß?‹þ~ "
b"CÌ5è\x06 >H\x19 œ81Qj\x1F ¿— "
b"D#S]JZI‹\86¼-\x04 »o "
b"DAÿ’cSIÄ•Uþ\r §\x0F Z@ "
b"DˆË)IÃJˆž4Qÿ›¦\v b "
b"Dóf*{J·kcä@1º\x14\x06 m "
b"Dú¬¾\x0F ª›\t lÚf—bJ\x06 "
b"E³L¤-¢K\x0E » +N\x03 B$ "
b"F\e [¨¸t]{£\x04 ¤ì0!A} "
b"G&v\x0F ’º@\|†n“˜P "
b"HžŒ@áA …æl¦Åô\x01 u\x11 "
b"IœuºŒ±¶©ÿ\x19 ŽØåÝÔ "
b"JÆ\x07 8ß.Að«M ~ø¡Cè "
b"LEiw\x0F ÅA©QCã°,\e\x05 "
b"N\x05 í#`ô•\x15 nË\x02 Q\x16 é "
b"N™ë·\x0E PDoŸ#Ò@RgiÙ "
b"Nè\x1D ìP\x13 (@Æ`Ò¤ÎD÷ "
b"Os¥J\x16 ã¸y<Çâ\x0E\x08\x05 /H "
b"Pd£Ì&½§·ˆ>‚Ð!¡ØË "
b"Pj²\x1D „A+y×G®XÝÉÊ• "
b"P¤^z¼wb{ñò&UüÉ# "
b"""
Q+\f \n
F§©'q\x13 €³r½^
"""
b"Q:éÕ\x1C ¿®Zž±½\x07 ëeW "
b"Q`+Ý\f AHî…åûŽR ? "
b"Søf\x7F \ëKŽ¢U7b«˜]™ "
b"T|\x0E £_‡Ož³ƒÿ}\e ë "
b"U\x18\t {1o\x04 ]ËÌŸSP.Vù "
b"UsCè(iÅ#æåÃ'B\x17 Ö= "
b"V\x08 rTŒ“Ns\x18\x07 ¢å\x1D d« "
b"W®0\x1C "ô½ôòBNØ:\x1E Ô "
b"XÓmŽÿÃÙ'—HÄ¥¹…§n "
b"Y\f F®SE\x05 ¥9W0ç7ô "
b"Yö;„–²`Øö³™þ5\x1A û9 "
b"\Ž\x11 ¼WB™\ï÷1É°ƒ ä "
b"]Ctìê©vþØ*íÄ•½£ "
b"] bm\r ž\f 7rUÿ·_°“0 "
b"^\x19\x18 íÿý\x7F ’y’¶¯\x10\x1F »· "
b"^Êvl]É\x11 ñ\x11 ìüc[Ã(Ž "
b"_®É1Ò¥@ðŽ{ÖéO+\x00 Ú "
b"`|\x1F èäkG§ŠëÔV#›È\x14 "
b"`™¢NædN§°Giá`'¶. "
b"`ùÅ’8DC¹Ëª\x1C (Üiî "
b"`˱ң7\x04 ƒÿHU\x1C ¾c« "
b"af>'g¬F„‘\x05 Ž}²˜\x14 "
b"bwt†¡[È\x07\x12 oûTà`§\x19 "
b"d\t Bb`~5ØR\x19 k"³ßß "
b"fŒ¶ÏYðJ\x1A ˜#vGà\x18 ‰) "
b"g\x10 =ÍTkFó‰\Dª\x00 “xÕ "
b"g¿”§0âA\x07 –ë\x17 ˆˆÅ}; "
b"göi%ãI\x00 ”\x13 Ur5ãÇô "
b"i\x1D €Ž.˜¹á¹\x03 Œà+\x18 Ãþ "
b"jž\x1C ¯ÿöJq‘u§J“²Ê\x12 "
b"jêT'i:éøµÉŽGAe£j "
b"l2\v B†ƒü\ˆ[u’Á©¹ "
b"m\x0F\x18 ,é\x10 Ï:“ˆ’/¸z¶ "
b"m:+·Z\x07 Er•\r \x18\x10 /è!¤ "
b"m<ì 9&Geš’\x01 “·{÷˜ "
b"m„¨–ü)LE´ˆºSIcYh "
b"n^\x03 Pã/@ŸŸ\x00 ê'|\x13 þ( "
b"p9u¾&!\x02 :\x00 Dh¨\v C: "
b"""
r7fCïW\x7F \n
=ðbèq{¨Ä
"""
b"r;»Æn AãÒD\x1E —)‰Òf "
b"rXá\r >XKj R÷Ã¥¤\x0F > "
b"su¹í•·Heƒu\x18\x01 >\x19 œ† "
b"s¯7 Ò\x16 ªE²ÿ‹Ž¿×y• "
b"uÞÿ\x03 íäK\x06 ¨‰lacJÏ" "
b"vsE~]\t Iß‹¯ía<$x] "
b"v½«œ\x05 †A\x18 §0×Û[€_` "
b"vË\x10 G†eG§´ \x13 Ïù|\x01 / "
b"wcƒŠ?\x12 Zê½¼–Ébˆ è "
b"z\x05 ¦o=jŠ‚ÆÖz"\x10 `ýr "
b"zòÂœ×pa(.R\x02 î\x13 ¤¸û "
b"{$‚K'u[QE’\r sç”È\x15 "
b"|[ðÅ)6ª\x01 ¸¾\x04 T\x18 :0› "
b"D•¯šëDûŒæŠé\f 1® "
b"ƒXmpúeývô)ÀóŠ3ö” "
b"„K\x07 \óõŠŒ&ñ—òÁ£Àö "
b"„U~ߎcBÒÅÅ¡^\r K± "
b"„Û—¤‘yAS™kv\•ƒñ "
b"…RA&ºUj¹ƒôðA© ´¼ "
b"…Ï\x05\x7F\x10 J! pìñ¤ñnæ "
b"†\x13\x00 ÷/B|›`¸ø Î\x1C "
b"†’;ÒÕ\x06 –‚áë/0šWþÓ "
b"ˆ¶¬\x07 ¡M!6\x13 µO¶ÃL%\r "
b"‰™2NË 6=—3wï~NÕ1 "
b"ŠÚÊÜisïÂÁÖüH…M "
b"‹²¬9ÖU⡽’=Fjí« "
b"Œ\x06 ’ã†;þ^\x00 ‚¬Âûêñ[ "
b"""
Œ@O¯åŽE¡Ô\n
Óa,Æ\t
"""
b"Œqéó\x00 03¯"®W \t ¦Êi "
b"Œí5Ú5úC9†õÎ\x01\x07 2/h "
b"Žkbǵ\r _ºO\f 'ï»\x1F ¦R "
b"Ž\x16 Fíqv‡á¢¬Ùl¹zû "
b"\x07 ü,›.\x12 ‰û\x11 rPïer "
b"\x08 ƒ‚æÎÄÑ&U\x7F\t u«\x04 L "
b"""
Ò\x05\x1A þž& \n
1´QžÒ\x16
"""
b"èÏá(J\x19 œ!\v ùÁmƒS "
b"’zÜöm!J[›\x04 ´¸\x11 KŽ] "
b"""
“ÖC\n
ëí\n
ŒTÈfň\t —\x1E
"""
b"•¡\v Ÿÿ]íÔ•ëö²ÁŽ=Ñ "
b"•¤«ôÝôO)°°\x08 Ž“«(\e "
b"—VÆ4ÖjM”¦Öúñá\x11 Ñè "
b"""
—>ç\x10 \n
Fš™tS7\x10 SœA
"""
b"™üØ:g\x00 é4\x0E 3®ˆÆ<Y "
b"š”¤˜©\f ¥öFÓÚö\x13\x12 ã\x01 "
b"›@½Ž%\x07 @¨ŽŽÌþ\r Da3 "
b"›vj»£\e »)\x1A îò\x18 bEõ¯ "
b"›üÈè\x16 ŒÉˆBÂ/eUV>X "
b"Ž\x02 ÆH¡\x08 #ä5æÃ2k¸ "
b"žDZ³Ò´WõºG£l\x01 ãÓK "
b" \x10 û<žèæÓíÌ„—\x16 Œ "
b"¡#\x11 Y¯›9ð*,Œ3Ã(+m "
b"¡`Áõ®^Hh\x1C (G¦Yfv "
b"¡µ@ôú\x16 rð•cîma´\x12 , "
b"£$\x03 µ\x04 ¤hì\x08\x11 Lîu¢Ðý "
b"¤pMã3…ax^¬\x07 ^7ž "
b"¥\Šœ\x1A âÙ_=ƒ$aL\x0F "
b"¦+Ã\x7F uM‹º½\x14 ÄçãÚ "
b"¦=-d0\x17 @\x00 ±\n U5Û\x04 »b "
b"¨wæáß‚ÑBEƒ4Ÿ¸Mû… "
b"©,’\x06 1I-©J–¡@é¶\x13 "
b"©x¬§éAþø0†Å,±à\x08 é "
b"©Â[ËÙ·1 >ÀÂR\x03 ¢*‡ "
b"ªŸ‰\r MÞJ«’\f\x14 iÂœœ\x1D "
b"«\x16 ñOSðK8‡\ÅÇNâ\x11 "
b"\f 2TŒšÂ:b³(Á_Þ#Í "
b"""
úë\x1D IðK\x7F ªÈ\x04 5j>\n
®
"""
b"®¡wp®Àñ“7‘æ\x15 —6ç, "
b"""
°Wý6‡ŽEs–ÿ¯äþ\v \n
¢
"""
b"±N\x1A N85¡¤\e ävÓC ‹æ "
b"³zÄŸîaM…¿ÁJ/P^\t † "
b"µÉi\r @ä\x07\x7F £ï†xrTÈ\e "
b"·J\x1A *Xm\f DÃn\x19 GÈH+\x03 "
b"º0‘”\x03\v Bƒ¨XÅÞÈÞ\x7F N "
b"º7Ù_\x03\x15 è„dr'–þÈâ "
b"ºþE!èg‡{q…I†(Dð— "
b"»ŽYèäG\x1C ’™)\x10 £nÆl "
b"¼\n ÷“»\x00 HâÓ\x00 V˜!óZ "
b"¾\x1E ÂÖ‚/G…v±cVùJ\x0F o "
b"¾}÷>m‘\x1E Ø’_ŠÒ\t W¹Ì "
b"¾©ð\x1F\x19 %Eÿ»D\v áy¢Ûm "
b"À=1/C|\x19 ¥\x02 ó´[\x0E ,}C "
b"Àç\X™¬\v ‹éø\x07 W>HUì "
b"ÁJ@ÊT¤CΈ\x07 €—Hz\Ï "
b"Ãe•4—•Mô»ðv\x0E xöç’ "
b"ø9Ÿ¾\x16 K—’µ¬ö[È’U "
b"øR\x18 ö\x10 K\x07 ¤\x0E\x0E ³©É]¯ "
b"Ä"®“ØQLY6¬™^\x06 µì5 "
b"Ä™÷\v ÕW Hí£E¡:«9\x00 "
b"Ç\x0E\x7F\x00 èçKv—(\r ô\x17 @Ÿ\x10 "
b"ÇåÌ€·KÑ›e\x13 óFð}\x10 "
b"ÈæðQáãø‹¸øÞ«8Ö« "
b"Ȳb'ÓM\x1D ›2\x12 ]¨B1 "
b"ɺý\x0E ¾Öþœ5$“ÑåŒT„ "
b"Ê$³n«—S—‚v=`Îòí$ "
b"Ë@¦Û¼þéÙòÁ\v è\x07\x12 âô "
b"Ëâi¾í\Mʪg“¨a\x04 …> "
b"Ëéðî\x1A @\x00 ÁÈü=„˜ÿÓW "
b"Ìm«`i’e\x11 ùÕ]ÆgÆ\v\x1A "
b"Í_\x07 ‚Qf›P^³¢%"Åщ "
b"Î9dö¨¨ŽUP+,´š{6 "
b"ε\e ±‚£A/âêWâ(Ô\x08 "
b"Ï\x05 üùC£…(ѦÕÍoLÆ "
b"Ð5jŒWSá-}áiCŸy€Y "
b"ÐÐD\’\x18 g¯Ä9PGœ\x10 ÿ“ "
b"Ò\v . \Œ™ó\x11 O\x07 "’.Ý\x0E "
b"Òfùvµ\x11 ɤñuã™Æ‰Ç "
b"Ò´\x1E „ǘ.¢èÔÞ¦æ•\x0F æ "
b"ÓV\x06\x14 UlNš¥óûdiÂòá "
b"Ó·¤¶ë\x05 Ö\e ¦Œ\x08 Þ¨AA– "
b"Ôû ZTK<\x01 望aÒkÚ\x1C "
b"Õ(!ÓhæDï†vgY~¡ß "
b"Öe\x18 ü9Ëh\x05 vÑ\x18 õ\f ðð "
b"Ø›\x11 ¾š2 ÁF¿( ìl™~ "
b"ØÐU\x19 ˜(Cl¦\¢\x1E û™Ö+ "
b"""
ØäÔ#B™O²~æÍŠFK\n
0
"""
b"ÜVƒ(\x11 bAj™M’\x1A €‡ÒV "
b"Ý\r x0\x19 5(\x15 A®ærõŒ\x03\t "
b"Þ) ¸žfC\x16 ½¸T\x1D èò€ "
b"ÞšÅë_à>T?MÍ;B>\x11 ˆ "
b"ßo\x7F ƒpŒ@#¤òE2Ü™ªà "
b"à\x18 röÛÄKx\x01 ö X\x1A r\x7F "
b"àÛ¬: ÀL¦†tJOÐA\r Ä "
b"á+•ëȸ@ÇúÃÙd\x12 ™Ï "
b"á`‰äp\r EÆš$„2\t ùE§ "
b"âSùü‡\v Cò¬ÑŸÕ`/\x17 ñ "
b"âî#\x1A ÙÁ€NÏ:PŠ6‹ÓJ "
b"äX_:ƒGCF‚ëV1Wó\x18\x1C "
b"äÖ¶ˆHY¨;=Tv7ìL\x11 I "
b"æ\x7F\x19 ?ÑôFÃ ©\x16 ;†NU. "
b"è¶ÆÔ|\Gw¼Ò\x00 ^?‚8\x0F "
b"ë\t áF|\x1D ›0ß@D:~exA "
b"ìðé±(<¾ð€ô\x0E\x18 +Èêú "
b"í\x15 Æ;\x13 ÄM¢‡\x10 »¼zµ\x13 z "
b"í*§±dODx‡‘\x1D +‹Ú[¾ "
b"íÛ¡ê\x7F ÐM¡»\f —\x1A {\x1A ]” "
b"îîƬÎ,ïÂ[²UÖ"H "
b"ïÈc´™’\ß+5gê\x08 ¦|> "
b"ð·<ºyŸ\x1C "}Ñ’O|6h) "
b"ñB9j\x1E )Û ›:&h\x1D Ú" "
b"ñQ £\x11 íÛ¾F\x0F âg©á³3 "
b"ó\Ïô\x03 V\x11 ¾Æ(иýöÛL "
b"óŒo\x06 ~÷@Ê\v •yÊæ?' "
b"ö\x0F gXØÅNÛ\x08 R\x11 Æ(щþ "
b"ö:\x0F £Â3G”…D\x1E %qm| "
b"ö¥ûíC\x07 4\x0E C“© \t Gë% "
b"öä•\x15 êßMè„jdÔBÞ; "
b"÷£[\r\r û류´”ˆ\x1E ‚«ï "
b"÷èÐcLãÜy!\x1E L@I\x13 ø "
b"øN\e ݵ\t Lq„wÝâЊ¼’ "
b"øó‘³å\x06 ì~!\v yWr\x10 (¢ "
b"ùë…¾5ÝK(¦ñ÷ýmDÞd "
b"ú#\e +—-E~\x07 5zT¦\x03 * "
b"ú}«d™Î[Ä*½Íùý.~ "
b"ú¢\x03 ¼ÃpK`’ìh„4Ï^ˆ "
b"""
úÇAÍK¯êÄ\n
@\x1D ‰ä£‰õ
"""
b"""
üD\x08 û¤Á˜M\n
1«±0Û ö
"""
b"ÿ\x00 ‹Šú\f U*h\x01 &—òØ\x14 ¬ "
b"ÿ\x18\x7F IΦzô–ªcuÖŒ.& "
b"ÿÏ\r ³&¬E6šj×âô·Ði "
b"ÿרf[ˆž'(_‚ÙÎý¾û "
b"ÿßÓœ«°Kc¨\x01 Ãq¯^£é "
]
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 (0x00005BD12EDE4898B28AC880B2FE8BA4 , 0x0015663EF4BE45B19444C66238C9C175 , 0x003060FEE63D4482B391667A726CE820 , 0x003C7B35A5FB4A4FA39BFC45283972C5 , 0x004356DAB3B84815BF4141B78352EF16 , 0x004803A9BD2422F4E80A807CD89A77A1 , 0x004DBBB31015432CBCACF8359CDD10BA , 0x00689B68D91E4BAC8979D7CE94039E4D , 0x006B8254F60F457DB2A9F58BB4750AA0 , 0x007EFA4AA2E14976BC4C9741A01003B6 , 0x0082039BA80545F9B091B71EB98BDDA7 , 0x008E94E247CF4FAC8242959438951E04 , 0x00C26710A76A4E95BF25564ABD94F665 , 0x00CEAF9E213F4372B3FAFBAD93B46F51 , 0x00DEF0EEE8D74395AB520D1DE66EB954 , 0x00F011E5BF6D492796A34B1BCD2B348F , 0x00FE5D077BF147659C405E6A44489134 , 0x0130F3242B1D4D9186D89169A2C62CB4 , 0x0143C1006980BB158886E9714A2C7746 , 0x0188CAD7351D4122909BC4E991B6B7CF , 0x0194F5EC88534CDB98E455EE087E5C8B , 0x01A7EDB3BF4940A0B9703EC965522FC4 , 0x01CF9DBCBB4D4C118DBB4DD9B2476DB1 , 0x01E36A7D3582448BB6F0A36FA99D90E3 , 0x0230C9B752504B72A1D5AD23E14BB604 , 0x02365195549141BBB20B1B455112E5E7 , 0x02387B1A461A489EBD2ACE3CD009BA18 , 0x028DC223D9EF4A54BE878DACBDD759FF , 0x02B452FF2D3705246355C02F152850F8 , 0x02BD629412E74E1C82B8251ED3248E73 , 0x02C4B33597D640AEBF0773E7E02A2841 , 0x030D4FCC8A944C9DB32343CF9E95F9FD , 0x03115401FA3844C0832A1EDFE7C914BB , 0x032D3DC1BFCA247C736C4E0EDE54A769 , 0x032D43DAC6BD44FC83E1FD39DD35A305 , 0x0353D74BCA27409C8DB12A3752A4D894 , 0x0377F071731D3483D7784DF17541062D , 0x038F47B3341742F1A67DE0A325CA8785 , 0x03F5460F955344B280D4C71E2698BBCB , 0x041A05544079E8DFC13C74772F46DC2C , 0x0448969CED4940BDA37ECC99C9AF1091 , 0x048D1CED1EAB4E87A30B8B415884E71C , 0x04C3B8BE31D243F19C89FA7A5E57DF4E , 0x04D55A6C6F324CF3BB9E03685AFCB7BB , 0x04FCB1073DB44E1C8DA2E3EF50BA6207 , 0x05D4B71F7E80487DA0F3E471A65022BF , 0x065C4842820A46C5AF1415A1B01E3135 , 0x0662FC98903CE4B6832580687BC16224 , 0x0679C04424944A8CA0C84F2A1C89C0D9 , 0x0693C6775B234F5891B9751A8703A3AB , 0x06C43033E92841EEB9394F4E4E85AB4B , 0x06E664958378461DB10C69111E571A21 , 0x072F38B126F940748074C9B6D8C476A6 , 0x0768F446281B6555F99AAFF15ECE52DA , 0x07A5EFFCD9004B56BCAFC53D4397883B , 0x07E0B40E9C0F4055A9076A830C96E6D2 , 0x07E250CACE9A491EB2F13F104625D9E3 , 0x08133DDDDDA2335CEA5EDF7EF29AFC76 , 0x087A2441CA484752B3479F6324F1CF75 , 0x08C18886B48F4D24A4816B43D5F7A07F , 0x0915EE6F293C4CF6A8E5AF8521FEEF6B , 0x09187364EFD3493FA85E1E44A22EF8E4 , 0x098132E004BB4D50804C0310F77D704D , 0x09AD1DF01A8180B4CB07BF7AEDE80F63 , 0x0A590E32F40F48C0909B0AD976689870 , 0x0A97074A93DF403F80102E1B4E98175E , 0x0A9959A4865BA350E1D70B5089F9A728 , 0x0AAD7D962D0FB21ABF0E4D788950FC36 , 0x0ADC97261B58C9BD0189E8FAFEDFC3AE , 0x0B1C252198D84F90AAF51065E5FFBA26 , 0x0B6822D29099F895844091D9F5F6BE7E , 0x0BCCC29A1B144127C1ED139E869B836D , 0x0BF12C97C00598132455205AEFBF32E9 , 0x0C391B01FC2A4A03A8BA13A7A595D8B7 , 0x0C75C83BAA014087808BAE27A3BDFA71 , 0x0DC9A76F88AB150FEA4FA5CE50CC4248 , 0x0DDA0290A93CFF2424950DF17B1E53DB , 0x0E2E654292B64202897A6E05607EFC2F , 0x0E57EF541C17432CAC4EB519DE39F2C7 , 0x0F41BF4061F90D70A3BE3384F357E492 , 0x0F4E11D8CAD14F3EA41ACE3F13EB505C , 0x1101E8454124C45D5EAC18BD80830C18 , 0x1104A31A9AFC45543DEF34768119B6EB , 0x11960B8A41704C54B9B3B11E0CC241F3 , 0x1196AF4FD01DA9D7546DDB9A6E8C38DF , 0x11E680347ABD4F748445EAEE1DEC4CF5 , 0x1212A2E835F93287C2C38048334BD81E , 0x130DB15DDEE947CF9F13AA0BC957B4B4 , 0x135671CD8B9AA7CEF16C2843651D542F , 0x139D7777B23B6F2E39E7D23BC0D9D5FB , 0x1570170E5983561BBD57D159AF1FE460 , 0x158518181326D0AC94045E7A45DDEF3C , 0x1678E04743F936A14C9A04E5F1828EF4 , 0x168D773C2628AE92E4E529FF854786D5 , 0x16F3B569385840CF9E6F6338027AD3D1 , 0x1732FC85219444F49E9BA82AB6BAC199 , 0x17611CB9371C4076B399159BE13821AB , 0x176C47F29F5E20B6AC0885C92D5DD7DE , 0x1786CDF6EFB843D48CE809D1D6A84DD9 , 0x17F505B43338D39F77EC01E39A8B0683 , 0x18E834F7D9528A0FB45197830B771461 , 0x1B278C86B3E9488AB8EB24071193F2BC , 0x1C8D089C507A420301DEBDE898F57F51 , 0x1D502AE84E207E18A556042CE3AF9290 , 0x1DA7713C8CE258B39308B1A260D5110F , 0x1DC0C705D649471E80914307AAFEA30E , 0x1E3187B67C3058F94AD728D77F3127E1 , 0x1E3FDF6533C90AF80ECE8BA791BF66CE , 0x1FA7280C31864A9FBF4356300FE0AE73 , 0x2195B93B0845D7B3DDBB1158A0699ACA , 0x229521CF84ED48A1BA46CE5F17F4ECC9 , 0x23543FE1267C308F5A6B44932553474C , 0x238A4EF125104823BC7D7B74517C4E76 , 0x23CBF00F61D34E63B8588411B0B3670A , 0x240386278CF65FD14F785988285A628C , 0x245E761F27A04D19BCC8A49AA8D0DF4C , 0x256CE679A3634F86AD8B68EBA8A0217E , 0x26019F93C8DE2549AC60BEE38CE06EAE , 0x2618125F208D12A4D064762EDFD674BB , 0x267F77A259854A63977107251BFEA7F3 , 0x28284B2E4C6A133F824FF32153E042C9 , 0x28299EB1F26A4B00837F0EF0914A1306 , 0x2934A6E396234E72982570F8E8CA3EE1 , 0x2A6D055996F5787A788F432257D26193 , 0x2D174C6CD21A40D38FE620715ACF9CDE , 0x2D48AF71A99144CCBA1B7D50A24FF846 , 0x2D8EFB6FFDFB4CD28BD477D6690A418A , 0x2D95285C1AF548F8A53482DD8D9A07AF , 0x2E884CB1B613488EDD3F2D591C47EDFE , 0x2F7388222C114EAE963848B34155E838 , 0x302F58EFA55FE0DF029447762BA14BB3 , 0x30488063CE524E45BC5BDC9C01B4E8E4 , 0x31141A820A914085A20D400B93013A4C , 0x31DEBEA1FE83BADF2C88B74ACD51476A , 0x32AC41F34EF384ABD60B7C71A1B47D62 , 0x34A45E35910C4AE4901B9C36397ABE8D , 0x377894D43516408CA08B4FFC95710D3D , 0x3851305B64FBA7E9382BBE7A6470FC7A , 0x39DEFFCFB3224B37842B7CF473A93486 , 0x3ACF7E5608126D9B1C5575463A14BEAF , 0x3AECA39111FBBAD94B925545CBCBB3C6 , 0x3BB4005EE3BE4EF2A10D3D917EF020CA , 0x3C31FF0050EE4A10842FA10A0681944C , 0x3C9F10EEC71E7035414C7FAC8BF6B1E2 , 0x3CCC7A3B31A940CABF5D1ABB94001DDD , 0x3D1D29D415B5A7C9358CC9937D4AC891 , 0x3D3E7B18452EBFBC0F693E3143079568 , 0x3E3A33EC66F5723ECEDDC2B6761A5F52 , 0x3E67E703F7EF46EABB55FEDB6E69D00E , 0x3E901131A27B4DEFAB7272DFD5375E03 , 0x3EA5A03F99D54C929E4EDB1B256AEC01 , 0x3EC3172A706B166AF644D319DD8243EF , 0x3F8D45C751E81CABD0924A45BAFC38EC , 0x3FFD92B4C394458BB5269BCCD052880C , 0x418A060D5D8749A2B633AAD6695040C5 , 0x420ECF8FDCCE9048D4465FC93512A71B , 0x43594AA2F5EFD0372D6EEBDF3F8BFE7E , 0x43CC35E8063E48199C3831516A1FBF97 , 0x4423535D4A5A498B5C3836BC2D04BB6F , 0x4441FF92635349C49555FE0DA70F5A40 , 0x4488CB2949C34A889E3451FF9BA60B62 , 0x44F3662A7B4AB76B63E44031BA14066D , 0x44FAACBE0FAA9BAD096CDA6697624A06 , 0x45B34CA42DA24B0EBBA0A02B4E034224 , 0x461B5BA8B8745D7BA304A4EC3021417D , 0x4726760F92BA405C9D7C866E9398508F , 0x489E8C40E141A085E66CA6C5F4017511 , 0x499C75BA8CADB1B6A9FF198DD8E5DDD4 , 0x4AC60738DF2E41F0AB4DA07EF8A143E8 , 0x4C4569770FC5418FA95143E3B02C1B05 , 0x4E05A0EDAD2360F495156ECB025116E9 , 0x4E99EBB70E50446F9F23D240526769D9 , 0x4EE81DEC9D50132840C660D2A4CE44F7 , 0x4F73A54A16E3B8793CC7E20E08052F48 , 0x5064A3CC26BDA7B7883E82D021A1D8CB , 0x506AB21D84412B79D747AE58DDC9CA95 , 0x50A4905E7ABC77627BF1F22655FCC923 , 0x512B0C0A46A7A92771139080B372BD5E , 0x513AE9D51CBFAE9D5A9EB1BD07EB6557 , 0x51602BDD0C4148EE85E5C3BB8E52A03F , 0x53F8667F5CEB4B8EA2553762AB985D99 , 0x547C0EA35F874F9EB383ADFF7D1BADEB , 0x5518097B316F045DCBCC9F53502E56F9 , 0x557343E82869C523E6E5C3274217D63D , 0x560872548C934E738F1807A2E51D64AB , 0x57AE8F301C22F4BDF4F2424ED83A1ED4 , 0x58D36D8EFFC3D9279748C4A5B985A76E , 0x590C9D46AE5345058FA5395730E737F4 , 0x59F63B8496B260D8F6B399FE351AFB39 , 0x5C8D11BC5742995CEFF731C9B083A0E4 , 0x5D4374ECEAA976FED82AEDC495BD90A3 , 0x5DA0626D0D9E0C377255FFB75FB09330 , 0x5E1918EDFFFD7F927992B6AF101FBBB7 , 0x5ECA766C5DC911F111ECFC635BC3288E , 0x5FAEC931D2A540F08E7BD6E94F2B00DA , 0x607C1FE8E46B47A78AEBD456239BC814 , 0x6099A24EE6644EA7B04769E16027B62E , 0x609DF9C592384443B9CBAA1C28DC69EE , 0x60CBB1D2A3370483FF48551C9DBE63AB , 0x61663E2767AC468491058D7DB2981490 , 0x62777486A15BC807126FFB54E060A719 , 0x64094262607E35D852196B8F22B3DFDF , 0x668CB6CF59F04A1A98237647E0188929 , 0x67103DCD546B46F3895C44AA009378D5 , 0x67BF94A730E2410796EB178888C57D3B , 0x67F6698125E349009413557235E3C7F4 , 0x691D808D2E98B9E1B9038CE02B18C3FE , 0x6A9E1CAFFFF64A719175A74A93B2CA12 , 0x6AEA5427693AE9F8B5C98D474165A36A , 0x6C320B428683FC5C885B7592C1A9B9A0 , 0x6D0F182CE910CF9D3A9388922FB87AB6 , 0x6D3A2BB75A074572950D18102FE821A4 , 0x6D3CECA0392647659A920193B77BF798 , 0x6D84A896FC294C45B488BA5349635968 , 0x6E5E0350E32F409F9F00EA277C13FE28 , 0x70397581BE2621023A004468A80B433A , 0x72376643EF577F0A3DF062E8717BA8C4 , 0x723BBBC66EA041E3D2441E972989D266 , 0x7258E10D3E584B6AA052F7C3A5A40F3E , 0x7375B9ED95B74865837518013E199C86 , 0x73AF3720D216AA45B2FF8B8DBFD77995 , 0x75DEFF03EDE44B06A8896C61634ACF22 , 0x7673457E5D0949DF8BAFED613C24785D , 0x76BDAB9C05864118A730D7DB5B805F60 , 0x76CB1047866547A7B4A013CFF97C012F , 0x7763838A3F125AEABDBC96C9628820E8 , 0x7A05A66F3D6A8A82C6D67A221060FD72 , 0x7AF2C29CD77061282E5202EE13A4B8FB , 0x7B24824B27755B5145920D73E794C815 , 0x7C5BF0C52936AA01B8BE0454183A309B , 0x814495AF9AEB44FB8CE68AE90C31AE8F , 0x83586D70FA65FD76F429C0F38A33F694 , 0x844B075CF3F58A8C26F197F2C1A3C0F6 , 0x8455817EDF8E6342D2C5C5A15E0D4BB1 , 0x84DB97A491794153996B765C959D83F1 , 0x85524126BA556AB983F4F041A9A0B4BC , 0x858FCF057F104A21A070ECF1A4F16EE6 , 0x861300F72F90427C8F9B60B8F8A0CE1C , 0x86923BD2D5069682E1EB2F309A57FED3 , 0x88B6AC07A14D213613B54FB6C34C250D , 0x8999324ECBA0363D973377EF7E4ED531 , 0x8ADAADCADC6973EFC2C1D6FC48854D8F , 0x8BB2AC39D655E2A1BD923D466AEDAB9D , 0x8C0692E3863BFE5E0082ACC2FBEAF15B , 0x8C404FAFE58D45C2A1D40AD3612CC609 , 0x8C71E9F3003033AF22AE572009A6CA69 , 0x8CED35DA35FA433986F5CE0107322F68 , 0x8D6B62C7B50D5FBA4F0C27EFBB1FA652 , 0x8E1646ED717687E19DA2ACD96CB97AFB , 0x8F07FC2C9B2E1289FB1172509DEF6572 , 0x8F088382E6CEC4D126557F0975AB044C , 0x8FD2051AFE9E26A00A31C2B4519ED216 , 0x8FE8CFE1AD284A199C210BF9C16D8353 , 0x927ADCF66D214A5B9B04B4B8114B8D5D , 0x93D6430AEBED0A8C54C866C58809971E , 0x95A10B9FFF5DEDD495EBF6B2C18D3DD1 , 0x95A4ABF4DDF44F29B0B0088D93AB281B , 0x9756C634D66A4D94A6D6FAF1E111D1E8 , 0x97903EE7100A469A9974533710539C41 , 0x99FCD83A6700E9340E33AE88C63C8F59 , 0x9A94A498A90CA5F646D3DAF61312E301 , 0x9B40BD8D250740A88D8ECCFE0D446133 , 0x9B766ABBA31BBB291AEEF2186245F5AF , 0x9BFCC8E8168CC98842C22F6555563E58 , 0x9D8F8D02C648A10823E435E6C3326BB8 , 0x9E445AB3D2B457F5BA47A36C01E3D34B , 0xA0108FFB3C9EADE8E6D3EDCC8497168C , 0xA1231159AF9B39F02A2C8C33C3282B6D , 0xA160C1F5AE5E48681C2847A69D596676 , 0xA1B540F4FA1672F09563EE6D61B4122C , 0xA32403B504A468EC08114CEE75A2D0FD , 0xA49D704DE3338561785EAC075E378F9E , 0xA55C8A819C1AE2D95F9D3D8324614C0F , 0xA62BC3837F754D8BBABDAD14C4E7E3DA , 0xA63D2D6430174000B10A5535DB04BB62 , 0xA877E6E1DF82D1424583349FB84DFB85 , 0xA92C920631492DA94A96A18140E9B613 , 0xA978ACA7E941FEF83086C52CB1E008E9 , 0xA9C25BCBD9B731203EC0C25203A22A87 , 0xAA9F890D4DDE4AAB920C1469C29C9C1D , 0xAB16F14F53F04B38875CC5C74EC3A211 , 0xAD0C32548C9AC23A62B328C15FDE23CD , 0xADFAEB1D49F04B7FAAC804356A3E0AAE , 0xAEA17770AEC0F1933791E6159736E72C , 0xB057FD36878E457396FFAFE4FE0B0AA2 , 0xB14E1A4E3835A1A41BE476D343A08BE6 , 0xB37AC49FEE614D85BFC14A2F505E0986 , 0xB5C9690D40E4077FA3EF86787254C81B , 0xB74A1A2A586D0C44C36E1947C8482B03 , 0xBA309194030B4283A858C5DEC8DE7F4E , 0xBA37D95F0315E88464722796FEADC8E2 , 0xBAFE4521E867877B718549862844F097 , 0xBB8E59ADE8E4471C92992910A36EC66C , 0xBC0AF793BB0048E290D300569821F35A , 0xBE1EC2D6822F478576B16356F94A0F6F , 0xBE7DF73E6D911ED8925F8AD20957B9CC , 0xBEA9F01F192545FFBB440BE179A2DB6D , 0xC03D312F437C19A502F3B45B0E2C7D43 , 0xC0E75C5899AC0B8BE9F807573E4855EC , 0xC14A40CA54A443CE88078097487A5CCF , 0xC365953497954DF4BBF0760E78F6E792 , 0xC3B8399FBE164B9792B5ACF65BC89255 , 0xC3B85218F6104B07A40E0EB3A9C95DAF , 0xC422AE93D8514C5936AC995E06B5EC35 , 0xC499F70BD557A048EDA345A13AAB3900 , 0xC70E7F00E8E74B7697280DF417409F10 , 0xC7E59DCC80B74BD19B6513F346F07D10 , 0xC8ADE6F051E1E3F88BB8F8DEAB38D6AB , 0xC8B26227D34D1D9D209B32125DA84231 , 0xC9BAFD0EBED6FE9C352493D1E58C5484 , 0xCA24B36EAB97539782763D60CEF2ED24 , 0xCB40A6DBBCFEE9D9F2C10BE80712E2F4 , 0xCBE269BEED5C4DCAAA6793A86104853E , 0xCBE9F0EE1A4000C1C8FC3D8498FFD357 , 0xCC6DAB6069926511F9D55DC667C60B1A , 0xCD5F078251669B505EB3A22522C5D189 , 0xCE3964F6A8A88D55502B2CB49A7B3620 , 0xCEB51BB182A3412F90E2EA57E228D408 , 0xCF05FCF943A38528D1A6D5CD6FAD4CC6 , 0xD0356A8C5753E12D7DE169439F798059 , 0xD0D0445C921867AFC43950479C10FF93 , 0xD20B2EA05C8C99F3114F0722922EDD0E , 0xD266F976B511C9A4F175E399C68189C7 , 0xD2B41E84C7982EA2E8D4DEA6E6950FE6 , 0xD3560614556C4E9AA5F3FB6469C2F2E1 , 0xD3B7A4B6EB05D61BA68C08DEA8414196 , 0xD4FBA05A544B3C01E69C9B61D26BDA1C , 0xD52821D368E644EF867667597EA1DF81 , 0xD6659D18FC39CB680576D118F50CF0F0 , 0xD89B11BE9A3220C146BF2820EC6C997E , 0xD8D055199828436CA65CA21EFB99D62B , 0xD8E4D42342994FB27EE6CD8A464B0A30 , 0xDC5683281162416A994D921A8087D256 , 0xDD0D78301935281541AEE672F58C0309 , 0xDE29A0B89E664316BDB8549D1DE8F280 , 0xDE9AC5EB5FE03E543F4DCD3B423E1188 , 0xDF6F7F83708C4023A4F24532DC99AAE0 , 0xE01872F6DBC44B788F01F620581A727F , 0xE0DBAC3A20C04CA686744A4FD0410DC4 , 0xE12B95EB9DC8B840C7FAC3D9641299CF , 0xE16089E4700D45C69A24843209F945A7 , 0xE253F9FC870B43F2ACD19FD5602F17F1 , 0xE2EE231AD9C1804ECF3A508A368BD34A , 0xE4585F3A8347434682EB563157F3181C , 0xE4D6B6884859A83B3D547637EC4C1149 , 0xE67F193FD1F446C3A0A9163B864E552E , 0xE8B6C6D47C5C4777BCD2005E3F82380F , 0xEB09E1467C1D9B30DF40443A7E657841 , 0xECF0E9B1283CBEF080F40E182BC8EAFA , 0xED15C63B13C44DA28710BBBC7AB5137A , 0xED2AA7B1644F447887911D2B8BDA5BBE , 0xEDDBA1EA7FD04DA1BB0C971A7B1A5D94 , 0xEE81EEC6ACCE2CEFC25B9DB255D62248 , 0xEFC863B499925CDF2B3567EA08A67C3E , 0xF0B73CBA799F1C227DD1924F7C366829 , 0xF142396A1E29DBA09B3A269D681DDA22 , 0xF15120A311EDDBBE460FE267A9E1B333 , 0xF35CCFF4035611BEC628D0B8FDF6DB4C , 0xF38C6F067EF740CA810B9579CAE63F27 , 0xF60F6758D8C54EDB085211C628D189FE , 0xF63A0FA3C233479485441E259D716D7C , 0xF6A5FBED4307340E4393A9A00947EB25 , 0xF6E49515EADF4DE89D846A64D442DE3B , 0xF7A35B0D0DFBEBA598B494881E82ABEF , 0xF7E8D0639D4CE3DC79211E4C404913F8 , 0xF84E1BDDB5094C718477DDE2D08ABC92 , 0xF8F391B3E506EC7E210B7957721028A2 , 0xF9EB85BE35DD4B28A6F1F7FD6D44DE64 , 0xFA231B2B972D457E8F07357A54A6032A , 0xFA7DAB6499CE5BC42ABD9DCDF9FD2E7E , 0xFAA203BCC3704B6092EC688434CF5E88 , 0xFAC741CD4BAFEAC40A401D89E4A389F5 , 0xFC4408FBA4C1984D0A31ABB130DBA0F6 , 0xFF008B8AFA0C552A68012697F2D814AC , 0xFF187F49CEA67AF496AA6375D68C2E26 , 0xFFCF0DB326AC45369A6AD7E2F4B7D069 , 0xFFD7A8665B889E27285F82D9CEFDBEFB , 0xFFDFD39CABB04B63A801C371AF5EA3E9 );
Copy
31
0.33 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"‘éÚ\x1E ìŒEÙ€H÷‹\f Fb« "
b"A»I_\x16 KB)ŠT›"<3›W "
b"År\x13 žG©HH¨˜ú\x01 i¥N® "
b"Á¸R´ñûO›ªÌV™›;94 "
b"Î\x7F Œ\r "ÂFòŽ ª\f á\x0E ÷² "
b"Í\x0E `]m\x1F G…š•U}£/½ "
b"÷W\x15 €\x02 ¯@ŸŽÑaà(~ÆÁ "
b"\x15 'þÿFL¡,ÆÊ’\x0E 5m "
b"]ŽÃd0\x05 MaH-Ž2\x14 ¿÷ "
b"Bdé\r ¹O®²ƒ¼Õ\x10 ÖZó "
b"ø¯³šY,BŽœ\x1E Õ‹Îb\x04 z "
b"³\e\x18 üÕI‡¹m\x0E j\x1C Ú "
b"\r ÒPü8•EÖ…Ôi“Ø’Ÿl\x08 Eñ\t 8Eê·Ö,«ŽÉùŒO÷Ô(ï®H_»»ùŸ\x16 ˆér "
b"7¹“ñ\x1A ÂCj·Ž»(»]\ "
b"H´Ä$"ÖAø¤~°äÆüñ "
]
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 (0x91E9DA1EEC8C45D98048F78B0C4662AB , 0x41BB495F164B42298A549B223C339B57 , 0xC572139E47A94848A898FA0169A54EAE , 0xC1B852B4F1FB4F9BAACC56999B3B3934 , 0xCE7F8C0D22C246F28EA0AA0CE10EF7B2 , 0xCD0E605D6D1F47859A95559D7DA32FBD , 0xF757158002AF409F8DD161E0287EC6C1 , 0x81159D27FEFF464CA12CC6CA920E356D , 0x5D8DC36430054D6181482D8D3214BFF7 , 0x4264E90DB99D4FAEB283BCD510D65AF3 , 0xF8AFB39A592C428E9C1ED58BCE62047A , 0xB31B18ADFCD54987B96D0EAD6A1C9DDA , 0x0DD250FC389545D685D46993D8929F6C , 0x0845F1098F3845EAB7D62CAB8DC9F98C , 0x4FF7D428EFAE485FBBBBF99F1688E972 , 0x37B993F11AC2436AB78EBB28BB5D5C90 , 0x48B4C42422D641F8A47EADB0E4C6FCF1 ));
Copy
32
0.15 ms
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = ? OR `id` = ?
Parameters :
[
b"“PìÕ½nO…·¡L…Àó\x1E "
b"w¹YÏfÞL\x15 Çù·Ú9‚ó "
]
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = 0x9350ECD5BD6E4F85B7A14C85C0C3B31E 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.13 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.14 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.10 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.10 ms
SELECT path FROM category WHERE id = ?
Parameters :
[
b"“PìÕ½nO…·¡L…Àó\x1E "
]
SELECT path FROM category WHERE id = 0x9350ECD5BD6E4F85B7A14C85C0C3B31E ; Copy
38
0.08 ms
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ; Copy
39
0.33 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.32 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%“PìÕ½nO…·¡L…Àó\x1E "
]
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 (0x9350ECD5BD6E4F85B7A14C85C0C3B31E )); Copy
42
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%Ã\x05 {°1cLfœÖß°Ô¬»\x15 "
b"“PìÕ½nO…·¡L…Àó\x1E "
]
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 (0xC3057BB031634C669CD6DFB0D4ACBB15 , 0x9350ECD5BD6E4F85B7A14C85C0C3B31E ));
Copy
43
1.35 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/9350ecd5bd6e4f85b7a14c85c0c3b31e "
"/navigation/c3057bb031634c669cd6dfb0d4acbb15 "
"/navigation/19ca405790ff4f07aac8c599d4317868 "
"/navigation/48f97f432fd041388b2630184139cf0e "
"/navigation/bb22b05bff9140f3808b1cff975b75eb "
"/navigation/06f5dda360c04112937601574122c515 "
"/navigation/9d2b0fec9ebf49feb299f3060de6a174 "
"/navigation/4aafda73311b49f5b9d06888f2608c18 "
"/navigation/7f29e74723ac457ea8c30ae0c3b2f598 "
"/navigation/e379fcc096f343568dcb1e294d45c931 "
"/detail/5fc751afe40f408b929a41a1428ed239 "
"/detail/8e84653f9c1644f19b4f77755b34e7c3 "
"/detail/781ce25ae1c6425fbb10d0a3f28feab9 "
"/detail/250f93757cb64342bd072ebe58824eee "
"/detail/627c25656b454f8287f47661fc4aea84 "
"/detail/999d26726de44c07adb17289192afbc9 "
"/detail/50056bf529594606880841dd703f4664 "
"/detail/b2438075996349c2b9f4c2e225c6eb6e "
"/detail/71579ea52869403fad027ca5663caa99 "
"/detail/8519f09948bf448ba334c1b0e412b045 "
"/detail/3918f5edc57a42cf8d935cfa8116b894 "
"/detail/5cafad8d1e4849bcad4fd5664c34a2d6 "
"/detail/507336570662414fbadec72133f12453 "
"/detail/548da17c2b1b4c4ab295b906d36eabbc "
"/detail/80729e1e9f294bcc82871a61f5624f05 "
"/detail/085e84ef5f49487293382a7ebe10e2b5 "
"/detail/0ee3c591f85441c498ed0d3c390bdf2d "
"/detail/3a2b3fa6f6e04f10b7ee652f327572a1 "
"/detail/44c895b89520428ab2f22bbefe0e72ea "
"/detail/a07f2f92864841c4ba44715a52ce3015 "
"/detail/6534b08aadc4450d91ba2148bd975d60 "
"/detail/82723bb444864816a89d5166e265a40d "
"/detail/fceabae9379c4b96a8b62081cd94b405 "
"/detail/6f992d6a323f48c3bbd29bccfc4a06d6 "
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/9350ecd5bd6e4f85b7a14c85c0c3b31e' , '/navigation/c3057bb031634c669cd6dfb0d4acbb15' , '/navigation/19ca405790ff4f07aac8c599d4317868' , '/navigation/48f97f432fd041388b2630184139cf0e' , '/navigation/bb22b05bff9140f3808b1cff975b75eb' , '/navigation/06f5dda360c04112937601574122c515' , '/navigation/9d2b0fec9ebf49feb299f3060de6a174' , '/navigation/4aafda73311b49f5b9d06888f2608c18' , '/navigation/7f29e74723ac457ea8c30ae0c3b2f598' , '/navigation/e379fcc096f343568dcb1e294d45c931' , '/detail/5fc751afe40f408b929a41a1428ed239' , '/detail/8e84653f9c1644f19b4f77755b34e7c3' , '/detail/781ce25ae1c6425fbb10d0a3f28feab9' , '/detail/250f93757cb64342bd072ebe58824eee' , '/detail/627c25656b454f8287f47661fc4aea84' , '/detail/999d26726de44c07adb17289192afbc9' , '/detail/50056bf529594606880841dd703f4664' , '/detail/b2438075996349c2b9f4c2e225c6eb6e' , '/detail/71579ea52869403fad027ca5663caa99' , '/detail/8519f09948bf448ba334c1b0e412b045' , '/detail/3918f5edc57a42cf8d935cfa8116b894' , '/detail/5cafad8d1e4849bcad4fd5664c34a2d6' , '/detail/507336570662414fbadec72133f12453' , '/detail/548da17c2b1b4c4ab295b906d36eabbc' , '/detail/80729e1e9f294bcc82871a61f5624f05' , '/detail/085e84ef5f49487293382a7ebe10e2b5' , '/detail/0ee3c591f85441c498ed0d3c390bdf2d' , '/detail/3a2b3fa6f6e04f10b7ee652f327572a1' , '/detail/44c895b89520428ab2f22bbefe0e72ea' , '/detail/a07f2f92864841c4ba44715a52ce3015' , '/detail/6534b08aadc4450d91ba2148bd975d60' , '/detail/82723bb444864816a89d5166e265a40d' , '/detail/fceabae9379c4b96a8b62081cd94b405' , '/detail/6f992d6a323f48c3bbd29bccfc4a06d6' )) 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.24 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 :
[
"iefUwdT0f5xvjtVwLogw72mdNu2TcIma "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'iefUwdT0f5xvjtVwLogw72mdNu2TcIma' ;
Copy