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.29 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 "
"Rohrverbindungen/Schlauchverbindungen "
"Rohrverbindungen/Schlauchverbindungen/ "
]
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 = 'Rohrverbindungen/Schlauchverbindungen' OR seo_path_info = 'Rohrverbindungen/Schlauchverbindungen/' ));
Copy
5
0.14 ms
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
"Ow0mf2EJ02sMsd3xtZT3Hp68TpI7Y4ME "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D ) AND (token = 'Ow0mf2EJ02sMsd3xtZT3Hp68TpI7Y4ME' ) LIMIT 1 ; Copy
6
0.11 ms
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"Ow0mf2EJ02sMsd3xtZT3Hp68TpI7Y4ME "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'Ow0mf2EJ02sMsd3xtZT3Hp68TpI7Y4ME' ;
Copy
7
0.15 ms
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = ? AND `sales_channel_country` . `country_id` = ? )
Parameters :
[
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
b"Å\x08 ×PÉVKÿ»IQ\x1E øP\x08 r "
]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0xCD6592C636AE4BF38378B01A9B31E46D AND `sales_channel_country` . `country_id` = 0xC508D750C9564BFFBB49511EF8500872 ); Copy
8
0.50 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%*\x10 ݱ\x17 Oh›ÁÑF—Àl "
]
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 (0x2A10DDB190174F688F9BC1D14697C06C ));
Copy
9
0.16 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%*\x10 ݱ\x17 Oh›ÁÑF—Àl "
]
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 (0x2A10DDB190174F688F9BC1D14697C06C ))));
Copy
10
0.25 ms
SELECT `cms_page` . `id` as `cms_page.id` , `cms_page` . `version_id` as `cms_page.versionId` , `cms_page` . `type` as `cms_page.type` , `cms_page` . `entity` as `cms_page.entity` , `cms_page` . `css_class` as `cms_page.cssClass` , `cms_page` . `config` as `cms_page.config` , `cms_page` . `preview_media_id` as `cms_page.previewMediaId` , `cms_page` . `locked` as `cms_page.locked` , `cms_page` . `created_at` as `cms_page.createdAt` , `cms_page` . `updated_at` as `cms_page.updatedAt` , `cms_page.translation.name` , `cms_page.translation.name` as `cms_page.name` , `cms_page.translation.customFields` , `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation` . `cms_page_id` , `cms_page.translation` . `cms_page_version_id` , `cms_page.translation` . `name` as `cms_page.translation.name` , `cms_page.translation` . `custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation` . `language_id` = ? ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation` . `cms_page_id` = `cms_page` . `id` AND `cms_page.cms_page_translation` . `cms_page_version_id` = `cms_page` . `version_id` WHERE (`cms_page` . `version_id` = ? ) AND (`cms_page` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%vˆT\x04 °{KC·ñ \x06 xµ\x05 œ "
]
SELECT `cms_page` . `id` as `cms_page.id` , `cms_page` . `version_id` as `cms_page.versionId` , `cms_page` . `type` as `cms_page.type` , `cms_page` . `entity` as `cms_page.entity` , `cms_page` . `css_class` as `cms_page.cssClass` , `cms_page` . `config` as `cms_page.config` , `cms_page` . `preview_media_id` as `cms_page.previewMediaId` , `cms_page` . `locked` as `cms_page.locked` , `cms_page` . `created_at` as `cms_page.createdAt` , `cms_page` . `updated_at` as `cms_page.updatedAt` , `cms_page.translation.name` , `cms_page.translation.name` as `cms_page.name` , `cms_page.translation.customFields` , `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation` . `cms_page_id` , `cms_page.translation` . `cms_page_version_id` , `cms_page.translation` . `name` as `cms_page.translation.name` , `cms_page.translation` . `custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation` . `cms_page_id` = `cms_page` . `id` AND `cms_page.cms_page_translation` . `cms_page_version_id` = `cms_page` . `version_id` WHERE (`cms_page` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`cms_page` . `id` IN (0x76885404B07B4B43B7F1A00678B5059C ));
Copy
11
0.30 ms
SELECT `cms_section` . `id` as `cms_section.id` , `cms_section` . `version_id` as `cms_section.versionId` , `cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` , `cms_section` . `position` as `cms_section.position` , `cms_section` . `type` as `cms_section.type` , `cms_section` . `locked` as `cms_section.locked` , `cms_section` . `name` as `cms_section.name` , `cms_section` . `sizing_mode` as `cms_section.sizingMode` , `cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` , `cms_section` . `background_color` as `cms_section.backgroundColor` , `cms_section` . `background_media_id` as `cms_section.backgroundMediaId` , `cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` , `cms_section` . `css_class` as `cms_section.cssClass` , `cms_section` . `cms_page_id` as `cms_section.pageId` , `cms_section` . `visibility` as `cms_section.visibility` , `cms_section` . `custom_fields` as `cms_section.customFields` , `cms_section` . `created_at` as `cms_section.createdAt` , `cms_section` . `updated_at` as `cms_section.updatedAt` , `cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` , `cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` , `cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` , `cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` , `cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` , `cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` , `cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` , `cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` , `cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` , `cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` , `cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` , `cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` , `cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` , `cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` , `cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` , `cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` , `cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` , `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` , `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` , `cms_section.backgroundMedia.translation.customFields` , `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation` . `media_id` , `cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation` . `language_id` = ? ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id` WHERE (`cms_section` . `version_id` = ? ) AND (((`cms_section` . `cms_page_id` IN (? ))))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%vˆT\x04 °{KC·ñ \x06 xµ\x05 œ "
]
SELECT
`cms_section` . `id` as `cms_section.id` ,
`cms_section` . `version_id` as `cms_section.versionId` ,
`cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` ,
`cms_section` . `position` as `cms_section.position` ,
`cms_section` . `type` as `cms_section.type` ,
`cms_section` . `locked` as `cms_section.locked` ,
`cms_section` . `name` as `cms_section.name` ,
`cms_section` . `sizing_mode` as `cms_section.sizingMode` ,
`cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` ,
`cms_section` . `background_color` as `cms_section.backgroundColor` ,
`cms_section` . `background_media_id` as `cms_section.backgroundMediaId` ,
`cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` ,
`cms_section` . `css_class` as `cms_section.cssClass` ,
`cms_section` . `cms_page_id` as `cms_section.pageId` ,
`cms_section` . `visibility` as `cms_section.visibility` ,
`cms_section` . `custom_fields` as `cms_section.customFields` ,
`cms_section` . `created_at` as `cms_section.createdAt` ,
`cms_section` . `updated_at` as `cms_section.updatedAt` ,
`cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` ,
`cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` ,
`cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` ,
`cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` ,
`cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` ,
`cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` ,
`cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` ,
`cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` ,
`cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` ,
`cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` ,
`cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` ,
`cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` ,
`cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` ,
`cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` ,
`cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` ,
`cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` ,
`cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` ,
`cms_section.backgroundMedia.translation.title` ,
`cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` ,
`cms_section.backgroundMedia.translation.alt` ,
`cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` ,
`cms_section.backgroundMedia.translation.customFields` ,
`cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields`
FROM
`cms_section`
LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id`
LEFT JOIN (
SELECT
`cms_section.backgroundMedia.translation` . `media_id` ,
`cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` ,
`cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` ,
`cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields`
FROM
`media_translation` `cms_section.backgroundMedia.translation`
WHERE
`cms_section.backgroundMedia.translation` . `language_id` = ?
) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id`
WHERE
(`cms_section` . `version_id` = ? )
AND (
(
(
`cms_section` . `cms_page_id` IN (? )
)
)
)
Copy
SELECT `cms_section` . `id` as `cms_section.id` , `cms_section` . `version_id` as `cms_section.versionId` , `cms_section` . `cms_page_version_id` as `cms_section.cmsPageVersionId` , `cms_section` . `position` as `cms_section.position` , `cms_section` . `type` as `cms_section.type` , `cms_section` . `locked` as `cms_section.locked` , `cms_section` . `name` as `cms_section.name` , `cms_section` . `sizing_mode` as `cms_section.sizingMode` , `cms_section` . `mobile_behavior` as `cms_section.mobileBehavior` , `cms_section` . `background_color` as `cms_section.backgroundColor` , `cms_section` . `background_media_id` as `cms_section.backgroundMediaId` , `cms_section` . `background_media_mode` as `cms_section.backgroundMediaMode` , `cms_section` . `css_class` as `cms_section.cssClass` , `cms_section` . `cms_page_id` as `cms_section.pageId` , `cms_section` . `visibility` as `cms_section.visibility` , `cms_section` . `custom_fields` as `cms_section.customFields` , `cms_section` . `created_at` as `cms_section.createdAt` , `cms_section` . `updated_at` as `cms_section.updatedAt` , `cms_section.backgroundMedia` . `id` as `cms_section.backgroundMedia.id` , `cms_section.backgroundMedia` . `user_id` as `cms_section.backgroundMedia.userId` , `cms_section.backgroundMedia` . `media_folder_id` as `cms_section.backgroundMedia.mediaFolderId` , `cms_section.backgroundMedia` . `mime_type` as `cms_section.backgroundMedia.mimeType` , `cms_section.backgroundMedia` . `file_extension` as `cms_section.backgroundMedia.fileExtension` , `cms_section.backgroundMedia` . `uploaded_at` as `cms_section.backgroundMedia.uploadedAt` , `cms_section.backgroundMedia` . `file_name` as `cms_section.backgroundMedia.fileName` , `cms_section.backgroundMedia` . `file_size` as `cms_section.backgroundMedia.fileSize` , `cms_section.backgroundMedia` . `media_type` as `cms_section.backgroundMedia.mediaTypeRaw` , `cms_section.backgroundMedia` . `meta_data` as `cms_section.backgroundMedia.metaData` , `cms_section.backgroundMedia` . `config` as `cms_section.backgroundMedia.config` , `cms_section.backgroundMedia` . `path` as `cms_section.backgroundMedia.path` , `cms_section.backgroundMedia` . `private` as `cms_section.backgroundMedia.private` , `cms_section.backgroundMedia` . `thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo` , `cms_section.backgroundMedia` . `file_hash` as `cms_section.backgroundMedia.fileHash` , `cms_section.backgroundMedia` . `created_at` as `cms_section.backgroundMedia.createdAt` , `cms_section.backgroundMedia` . `updated_at` as `cms_section.backgroundMedia.updatedAt` , `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title` , `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt` , `cms_section.backgroundMedia.translation.customFields` , `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section` . `background_media_id` = `cms_section.backgroundMedia` . `id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation` . `media_id` , `cms_section.backgroundMedia.translation` . `alt` as `cms_section.backgroundMedia.translation.alt` , `cms_section.backgroundMedia.translation` . `title` as `cms_section.backgroundMedia.translation.title` , `cms_section.backgroundMedia.translation` . `custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation` . `media_id` = `cms_section.backgroundMedia` . `id` WHERE (`cms_section` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`cms_section` . `cms_page_id` IN (0x76885404B07B4B43B7F1A00678B5059C ))));
Copy
12
0.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
13
0.24 ms
SELECT `cms_slot` . `id` as `cms_slot.id` , `cms_slot` . `version_id` as `cms_slot.versionId` , `cms_slot` . `cms_block_version_id` as `cms_slot.cmsBlockVersionId` , `cms_slot` . `type` as `cms_slot.type` , `cms_slot` . `slot` as `cms_slot.slot` , `cms_slot` . `locked` as `cms_slot.locked` , `cms_slot` . `cms_block_id` as `cms_slot.blockId` , `cms_slot` . `created_at` as `cms_slot.createdAt` , `cms_slot` . `updated_at` as `cms_slot.updatedAt` , `cms_slot.translation.config` , `cms_slot.translation.config` as `cms_slot.config` , `cms_slot.translation.customFields` , `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation` . `cms_slot_id` , `cms_slot.translation` . `cms_slot_version_id` , `cms_slot.translation` . `config` as `cms_slot.translation.config` , `cms_slot.translation` . `custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation` . `language_id` = ? ) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation` . `cms_slot_id` = `cms_slot` . `id` AND `cms_slot.cms_slot_translation` . `cms_slot_version_id` = `cms_slot` . `version_id` WHERE (`cms_slot` . `version_id` = ? ) AND (((`cms_slot` . `cms_block_id` IN (? , ? , ? , ? ))))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%‚Ä|°LžCl„ÌFI2¡4J "
b"ŽÇE\t ø\r IÚ–„Á¬Î\x10\x1D "
b"æôe‚ßhNÿ¦$oñ˶‡m "
b"™,ÉX}\x1C FÀº\x1F ¥p{J«< "
]
SELECT `cms_slot` . `id` as `cms_slot.id` , `cms_slot` . `version_id` as `cms_slot.versionId` , `cms_slot` . `cms_block_version_id` as `cms_slot.cmsBlockVersionId` , `cms_slot` . `type` as `cms_slot.type` , `cms_slot` . `slot` as `cms_slot.slot` , `cms_slot` . `locked` as `cms_slot.locked` , `cms_slot` . `cms_block_id` as `cms_slot.blockId` , `cms_slot` . `created_at` as `cms_slot.createdAt` , `cms_slot` . `updated_at` as `cms_slot.updatedAt` , `cms_slot.translation.config` , `cms_slot.translation.config` as `cms_slot.config` , `cms_slot.translation.customFields` , `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation` . `cms_slot_id` , `cms_slot.translation` . `cms_slot_version_id` , `cms_slot.translation` . `config` as `cms_slot.translation.config` , `cms_slot.translation` . `custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation` . `cms_slot_id` = `cms_slot` . `id` AND `cms_slot.cms_slot_translation` . `cms_slot_version_id` = `cms_slot` . `version_id` WHERE (`cms_slot` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (((`cms_slot` . `cms_block_id` IN (0x82C47CB04C9E436C84CC464932A1344A , 0x8EC74509F80D49DA9684C1AC9DCE101D , 0xE6F46582DF684EFFA6246FF1CBB6876D , 0x992CC9587D1C46C0BA1FA5707B4AAB3C ))));
Copy
14
0.20 ms
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = ? ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"´ \x18 ·vGÉ‹\t\x17 DV;ûÍ "
]
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (0xB4A018B7768147C98B091744563BFBCD ); Copy
15
0.11 ms
SELECT `product_sorting` . `id` FROM `product_sorting` WHERE (`product_sorting` . `active` = ? ) ORDER BY `product_sorting` . `priority` DESC
SELECT `product_sorting` . `id` FROM `product_sorting` WHERE (`product_sorting` . `active` = 1 ) ORDER BY `product_sorting` . `priority` DESC ;
Copy
16
0.19 ms
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = ? ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"´ \x18 ·vGÉ‹\t\x17 DV;ûÍ "
b"""
\Ú\x06 .~GΔ\x15 d¼¾\x05 \n
«
"""
b"ëbxQRjE-¸Ùc™#é!° "
b"X`\r üN$N ©\x1F P\x1A ‚}8ž "
b"~sÌ+¤ÝJá‘\t dA\\x16 vJ "
b"–7JüB½A’¥Š\x1F r«—Gà "
b"\x06 jkîü~Kn‰)ÖL(ˆ¥\x1A "?xÂbúL¿ŸÕ1œ1Q±& "
]
SELECT `product_sorting` . `id` as `product_sorting.id` , `product_sorting` . `locked` as `product_sorting.locked` , `product_sorting` . `url_key` as `product_sorting.key` , `product_sorting` . `priority` as `product_sorting.priority` , `product_sorting` . `active` as `product_sorting.active` , `product_sorting` . `fields` as `product_sorting.fields` , `product_sorting` . `created_at` as `product_sorting.createdAt` , `product_sorting` . `updated_at` as `product_sorting.updatedAt` , `product_sorting.translation.label` , `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation` . `product_sorting_id` , `product_sorting.translation` . `label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation` . `product_sorting_id` = `product_sorting` . `id` WHERE `product_sorting` . `id` IN (0xB4A018B7768147C98B091744563BFBCD , 0x5CDA06202E7E47CE941564BCBE050AAB , 0xEB627851526A452DB8D9639923E921B0 , 0x58600DFC4E244E20A91F501A827D389E , 0x7E73CC2BA4DD4AE1910964415C16764A , 0x96374AFC42BD4192A58A1F72AB9747C3 , 0x066A6BEEFC7E4B6E8929D64C2888A51A , 0x223F78C262FA4CBF9FD5319C3151B126 );
Copy
17
0.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%*\x10 ݱ\x17 Oh›ÁÑF—Àl "
]
SELECT `category` . `id` , `category` . `auto_increment` FROM `category` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x2A10DDB190174F688F9BC1D14697C06C )) LIMIT 1 ;
Copy
18
0.09 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%*\x10 ݱ\x17 Oh›ÁÑF—Àl "
]
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 (0x2A10DDB190174F688F9BC1D14697C06C ));
Copy
19
2.56 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 144
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%30
b"Íe’Æ6®Kóƒx°\x1A ›1äm "
true
b"*\x10 ݱ\x17 Oh›ÁÑF—Àl "
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` = 0x2A10DDB190174F688F9BC1D14697C06C 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 144 ;
Copy
20
1.48 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"*\x10 ݱ\x17 Oh›ÁÑF—Àl "
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` = 0x2A10DDB190174F688F9BC1D14697C06C AND NOT (`product` . `display_group` < = > NULL ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > 1 AND `product` . `available` < = > 0 ))) GROUP BY `product` . `display_group` ) total ; Copy
21
5.04 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"*\x10 ݱ\x17 Oh›ÁÑF—Àl "
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` = 0x2A10DDB190174F688F9BC1D14697C06C AND NOT (`product` . `display_group` < = > NULL ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > 1 AND `product` . `available` < = > 0 ))) GROUP BY `product.properties` . `id` ;
Copy
22
1.32 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"*\x10 ݱ\x17 Oh›ÁÑF—Àl "
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` = 0x2A10DDB190174F688F9BC1D14697C06C AND NOT (`product` . `display_group` < = > NULL ) AND NOT (IFNULL (`product` . `is_closeout` , `product.parent` . `is_closeout` ) < = > 1 AND `product` . `available` < = > 0 ))) GROUP BY `product.options` . `id` ;
Copy
23
0.42 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%ÎâÚ\x19 4F˼•7ãŠbÏØ "
b"¯ý¾»)ùM\x19 _y\x12 À½Ýì "
b"ñæª^\x0F ·LÔ•]~ýU·‚´ "
b"\x01 ~ò—@$IQ„m÷³ó^ò¼Ù\x03 %ÇD‹ªib?’[\x04 Ç "
b"\x1F "—\x03 8\x11 A²‡%¹\f aÜ\f ½)&©‹B\x13 K<ª¿Î`–\x16 Ï "
b"˜œ€H¨AAh”¤){'\x00 ¡5 "
b"""
\n ¨ÄnPaI\n
cÖ…]g‚M
"""
b"\x14 éÙ0Ç©I&\x1D Z‚“‡\x06 »fuÒ3xL¡<O¼ëžÀ* "
b"\x04 Æ 1\x00 ?OhŽ\t ¥l®œHp…\r þ8h¨B:—‰\x04 oG\x1C |Ì "
b"\x04 m&bò»N_‚ßäv„šÒ\v º\x1A ÇK?Mm¶\x05 ìï4ý\x06 ô "
b"TºTµ†NÅ‘å·„Aü“ù "
b"C„\x01 m\x18 ªM<›6¾ëÚËšq "
b"<\e\x10 ×5NJ½±\x11 .ÀÉ›\f é "
b"/\x01 T ‹»M…€Í\x06 mKÌR¡ "
b"ãýZ9ÿ\x15 CÈ™f6»~nh³ "
b"\x1F\x10 ÚK\x02 ˆDŒ¹_/j\x1A mÆW·¥î)$‚Bù†|ÃèÊ\x01 $\x08 "
b"Ç„¶Q¢`H\x00 ‡ØlØï’©Å "
b"\x0E ,ê¿X\x06 F΃xC“\x12 ]Gä ]
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 (0xCEC3A2DA193446CBBC9537E38A62CFD8 , 0xAFFDBEBB29F94D198F5F7912C0BDDDEC , 0xF1E6AA5E0FB74CD4955D7EFD55B782B4 , 0x017EF29740244951846D9DF7B3F3905E , 0xF2BCD90325C7448BAA69623F925B04C7 , 0x1F229703381141B28725B90C61DC0CBD , 0x2926A98B42134B3C9DAABFCE609616CF , 0x989C8048A841416894A4297B2700A135 , 0x0AA8C46E5061490A8163D6855D67824D , 0x14E9D930C7A9492681AD1D5A82938706 , 0xBB6675D233784CC2A13C4FBCEB9EC02A , 0x04C6A031003F4F688D09A56CAE9C4870 , 0x850DFE3868A8423A9789046F471C7CCC , 0x046D2662F2BB4E5F82DFE476849AD20B , 0xBA1AC74B9D3F4D6DB605ECEF34FD06F4 , 0x54BA8154B5864EC591E5B78441FC93F9 , 0x4384016D18AA4D3C9B36BEEBDACB9A71 , 0x3C1B10D7354E4ABDB1112EC0C99B0CE9 , 0x2F0154208BBB4D8580CD066D4BCC52A1 , 0xE3FD5A39FF1543C8996636BB7E6E68B3 , 0x1F10DA4B0288448CB95F2F6A1A6DC657 , 0xB7A5EE29248242F9867CC3E8CA012408 , 0xC784B651A260480087D86CD8EF92A9C5 , 0x0E2CEABF580646CE83784393125D47E4 );
Copy
24
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"ÎâÚ\x19 4F˼•7ãŠbÏØ "
b"¯ý¾»)ùM\x19 _y\x12 À½Ýì "
b"ñæª^\x0F ·LÔ•]~ýU·‚´ "
b"\x01 ~ò—@$IQ„m÷³ó^ò¼Ù\x03 %ÇD‹ªib?’[\x04 Ç "
b"\x1F "—\x03 8\x11 A²‡%¹\f aÜ\f ½)&©‹B\x13 K<ª¿Î`–\x16 Ï "
b"˜œ€H¨AAh”¤){'\x00 ¡5 "
b"""
\n ¨ÄnPaI\n
cÖ…]g‚M
"""
b"\x14 éÙ0Ç©I&\x1D Z‚“‡\x06 »fuÒ3xL¡<O¼ëžÀ* "
b"\x04 Æ 1\x00 ?OhŽ\t ¥l®œHp…\r þ8h¨B:—‰\x04 oG\x1C |Ì "
b"\x04 m&bò»N_‚ßäv„šÒ\v º\x1A ÇK?Mm¶\x05 ìï4ý\x06 ô "
b"TºTµ†NÅ‘å·„Aü“ù "
b"C„\x01 m\x18 ªM<›6¾ëÚËšq "
b"<\e\x10 ×5NJ½±\x11 .ÀÉ›\f é "
b"/\x01 T ‹»M…€Í\x06 mKÌR¡ "
b"ãýZ9ÿ\x15 CÈ™f6»~nh³ "
b"\x1F\x10 ÚK\x02 ˆDŒ¹_/j\x1A mÆW·¥î)$‚Bù†|ÃèÊ\x01 $\x08 "
b"Ç„¶Q¢`H\x00 ‡ØlØï’©Å "
b"\x0E ,ê¿X\x06 F΃xC“\x12 ]Gä ]
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 (0xCEC3A2DA193446CBBC9537E38A62CFD8 , 0xAFFDBEBB29F94D198F5F7912C0BDDDEC , 0xF1E6AA5E0FB74CD4955D7EFD55B782B4 , 0x017EF29740244951846D9DF7B3F3905E , 0xF2BCD90325C7448BAA69623F925B04C7 , 0x1F229703381141B28725B90C61DC0CBD , 0x2926A98B42134B3C9DAABFCE609616CF , 0x989C8048A841416894A4297B2700A135 , 0x0AA8C46E5061490A8163D6855D67824D , 0x14E9D930C7A9492681AD1D5A82938706 , 0xBB6675D233784CC2A13C4FBCEB9EC02A , 0x04C6A031003F4F688D09A56CAE9C4870 , 0x850DFE3868A8423A9789046F471C7CCC , 0x046D2662F2BB4E5F82DFE476849AD20B , 0xBA1AC74B9D3F4D6DB605ECEF34FD06F4 , 0x54BA8154B5864EC591E5B78441FC93F9 , 0x4384016D18AA4D3C9B36BEEBDACB9A71 , 0x3C1B10D7354E4ABDB1112EC0C99B0CE9 , 0x2F0154208BBB4D8580CD066D4BCC52A1 , 0xE3FD5A39FF1543C8996636BB7E6E68B3 , 0x1F10DA4B0288448CB95F2F6A1A6DC657 , 0xB7A5EE29248242F9867CC3E8CA012408 , 0xC784B651A260480087D86CD8EF92A9C5 , 0x0E2CEABF580646CE83784393125D47E4 )) GROUP BY `product` . `id` ;
Copy
25
95.42 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%ÎâÚ\x19 4F˼•7ãŠbÏØ "
b"¯ý¾»)ùM\x19 _y\x12 À½Ýì "
b"ñæª^\x0F ·LÔ•]~ýU·‚´ "
b"\x01 ~ò—@$IQ„m÷³ó^ò¼Ù\x03 %ÇD‹ªib?’[\x04 Ç "
b"\x1F "—\x03 8\x11 A²‡%¹\f aÜ\f ½)&©‹B\x13 K<ª¿Î`–\x16 Ï "
b"˜œ€H¨AAh”¤){'\x00 ¡5 "
b"""
\n ¨ÄnPaI\n
cÖ…]g‚M
"""
b"\x14 éÙ0Ç©I&\x1D Z‚“‡\x06 »fuÒ3xL¡<O¼ëžÀ* "
b"\x04 Æ 1\x00 ?OhŽ\t ¥l®œHp…\r þ8h¨B:—‰\x04 oG\x1C |Ì "
b"\x04 m&bò»N_‚ßäv„šÒ\v º\x1A ÇK?Mm¶\x05 ìï4ý\x06 ô "
b"TºTµ†NÅ‘å·„Aü“ù "
b"C„\x01 m\x18 ªM<›6¾ëÚËšq "
b"<\e\x10 ×5NJ½±\x11 .ÀÉ›\f é "
b"/\x01 T ‹»M…€Í\x06 mKÌR¡ "
b"ãýZ9ÿ\x15 CÈ™f6»~nh³ "
b"\x1F\x10 ÚK\x02 ˆDŒ¹_/j\x1A mÆW·¥î)$‚Bù†|ÃèÊ\x01 $\x08 "
b"Ç„¶Q¢`H\x00 ‡ØlØï’©Å "
b"\x0E ,ê¿X\x06 F΃xC“\x12 ]Gä ]
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 (0xCEC3A2DA193446CBBC9537E38A62CFD8 , 0xAFFDBEBB29F94D198F5F7912C0BDDDEC , 0xF1E6AA5E0FB74CD4955D7EFD55B782B4 , 0x017EF29740244951846D9DF7B3F3905E , 0xF2BCD90325C7448BAA69623F925B04C7 , 0x1F229703381141B28725B90C61DC0CBD , 0x2926A98B42134B3C9DAABFCE609616CF , 0x989C8048A841416894A4297B2700A135 , 0x0AA8C46E5061490A8163D6855D67824D , 0x14E9D930C7A9492681AD1D5A82938706 , 0xBB6675D233784CC2A13C4FBCEB9EC02A , 0x04C6A031003F4F688D09A56CAE9C4870 , 0x850DFE3868A8423A9789046F471C7CCC , 0x046D2662F2BB4E5F82DFE476849AD20B , 0xBA1AC74B9D3F4D6DB605ECEF34FD06F4 , 0x54BA8154B5864EC591E5B78441FC93F9 , 0x4384016D18AA4D3C9B36BEEBDACB9A71 , 0x3C1B10D7354E4ABDB1112EC0C99B0CE9 , 0x2F0154208BBB4D8580CD066D4BCC52A1 , 0xE3FD5A39FF1543C8996636BB7E6E68B3 , 0x1F10DA4B0288448CB95F2F6A1A6DC657 , 0xB7A5EE29248242F9867CC3E8CA012408 , 0xC784B651A260480087D86CD8EF92A9C5 , 0x0E2CEABF580646CE83784393125D47E4 ));
Copy
26
0.23 ms
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
27
191.14 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%\x01 ~ò—@$IQ„m÷³ó^\x04 m&bò»N_‚ßäv„šÒ\v \x04 Æ 1\x00 ?OhŽ\t ¥l®œHp\n ¨ÄnPaI\n
cÖ…]g‚M
"""
b"\x0E ,ê¿X\x06 F΃xC“\x12 ]Gä\x14 éÙ0Ç©I&\x1D Z‚“‡\x06 \x1F\x10 ÚK\x02 ˆDŒ¹_/j\x1A mÆW\x1F "—\x03 8\x11 A²‡%¹\f aÜ\f ½)&©‹B\x13 K<ª¿Î`–\x16 Ï "
b"/\x01 T ‹»M…€Í\x06 mKÌR¡ "
b"<\e\x10 ×5NJ½±\x11 .ÀÉ›\f é "
b"C„\x01 m\x18 ªM<›6¾ëÚËšq "
b"TºTµ†NÅ‘å·„Aü“ù "
b"…\r þ8h¨B:—‰\x04 oG\x1C |Ì "
b"˜œ€H¨AAh”¤){'\x00 ¡5 "
b"¯ý¾»)ùM\x19 _y\x12 À½Ýì "
b"·¥î)$‚Bù†|ÃèÊ\x01 $\x08 "
b"º\x1A ÇK?Mm¶\x05 ìï4ý\x06 ô "
b"»fuÒ3xL¡<O¼ëžÀ* "
b"Ç„¶Q¢`H\x00 ‡ØlØï’©Å "
b"ÎâÚ\x19 4F˼•7ãŠbÏØ "
b"ãýZ9ÿ\x15 CÈ™f6»~nh³ "
b"ñæª^\x0F ·LÔ•]~ýU·‚´ "
b"ò¼Ù\x03 %ÇD‹ªib?’[\x04 Ç "
]
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 (0x017EF29740244951846D9DF7B3F3905E , 0x046D2662F2BB4E5F82DFE476849AD20B , 0x04C6A031003F4F688D09A56CAE9C4870 , 0x0AA8C46E5061490A8163D6855D67824D , 0x0E2CEABF580646CE83784393125D47E4 , 0x14E9D930C7A9492681AD1D5A82938706 , 0x1F10DA4B0288448CB95F2F6A1A6DC657 , 0x1F229703381141B28725B90C61DC0CBD , 0x2926A98B42134B3C9DAABFCE609616CF , 0x2F0154208BBB4D8580CD066D4BCC52A1 , 0x3C1B10D7354E4ABDB1112EC0C99B0CE9 , 0x4384016D18AA4D3C9B36BEEBDACB9A71 , 0x54BA8154B5864EC591E5B78441FC93F9 , 0x850DFE3868A8423A9789046F471C7CCC , 0x989C8048A841416894A4297B2700A135 , 0xAFFDBEBB29F94D198F5F7912C0BDDDEC , 0xB7A5EE29248242F9867CC3E8CA012408 , 0xBA1AC74B9D3F4D6DB605ECEF34FD06F4 , 0xBB6675D233784CC2A13C4FBCEB9EC02A , 0xC784B651A260480087D86CD8EF92A9C5 , 0xCEC3A2DA193446CBBC9537E38A62CFD8 , 0xE3FD5A39FF1543C8996636BB7E6E68B3 , 0xF1E6AA5E0FB74CD4955D7EFD55B782B4 , 0xF2BCD90325C7448BAA69623F925B04C7 ))));
Copy
28
0.44 ms
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = ? ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `unit` . `id` as `unit.id` , `unit` . `created_at` as `unit.createdAt` , `unit` . `updated_at` as `unit.updatedAt` , `unit.translation.shortCode` , `unit.translation.shortCode` as `unit.shortCode` , `unit.translation.name` , `unit.translation.name` as `unit.name` , `unit.translation.customFields` , `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation` . `unit_id` , `unit.translation` . `short_code` as `unit.translation.shortCode` , `unit.translation` . `name` as `unit.translation.name` , `unit.translation` . `custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `unit.unit_translation` ON `unit.unit_translation` . `unit_id` = `unit` . `id` ;
Copy
29
2.67 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 y]í\f\x00 I¸·[/ô2íc\\x00 ²\r O™sI\x06 €[Þ~mÔ3a\x00 ß[\x10 ç’C\n ·kk²lÛ\f Ó\x01 l<¥ºˆEk™›\x01 7†©ç\f \x01 m#k\x1F\x17 /¨kí 3J*O\x02 szþÓ|O÷—Ȭ¬á¡Ù\x02 ‘çxP¼\x16 ÅeÔ«E‘>\r \x02 ´Rÿ-7\x05 $cUÀ/\x15 (Pø\x03 -=Á¿Ê$|slN\x0E ÞT§i\x03 W«\x1C ø(O\x13 „\x13\x13 Y£a\x18 å\x03 wðqs\x1D 4ƒ×xMñuA\x06 -\x04\x1A\x05 T@yèßÁ<tw/FÜ,\x04\x1C 8íyf\x11 (ÁF¨$Ê \x06 \x06 4Ò•EÒï$\x15 í½4ö§y’\x06 ƒ;øˆÂÁ¥t,q²ÿ–ù \x06 þàƒG±›ÂAÇAïÔ=.œ\x07 hôF(\e eUùš¯ñ^ÎRÚ\x07 çrAJº•ß :›ôdÏÁý\x08\x07 /Óât@ó‡Ãw˜žb\x1F +\x08 ¡ÇlÒ1Fƒ“,Ѭ8¹Õ\v ‹ˆ¿ñáCŸ¾\x11 ÙrÌ:ëà\v Ìš\e\x14 A'Áí\x13 ž†›ƒm\f 9\e\x01 ü*J\x03 ¨º\x13 §¥•Ø·\f ¹0\x1C ‹BÜõâxj%ß¼.Ã\r ɧoˆ«\x15\x0F êO¥ÎPÌBH\r ×êN5ÎL¥“tÂPš\x1C\x1D 6\r Ú\x02 ©<ÿ$$•\r ñ{\x1E SÛ\x0E\x18 ±ù‰[M÷ˆüÈ\x1E Ž˜²Ä\x0E ´kõÂà~xrI\n øÃœó
"""
b"""
\x0F ÖÑÒ+l›ª\f g¬\x07 x\n ê2
"""
b"\x0F ïÎ~\x0F vG…EèÆÁ/\x1E å\x10 ØÃò)\e Bµ¥)|Wj©Ý\x15 \x13 ww²;o.9çÒ;ÀÙÕû\x13 ¿1¯„\x0E \r —!d\x08 sͶf\x14 'Ћ$QDŽ®RŽ†±3o¦\x14 ˜Œ\x18 oÑG7¥\x07 ÅŽÑ#ú"\x14 µ¼D\x07 Y¢Ôš\x00 Šáâl_ç\x15 Ë\x0F P¹äÍ”×Iæ‚¿›öš\x16 l+(ÜšºÎÄÃu~•\x1A K)\x16 xàGCù6¡Lš\x04 åñ‚Žô\x16 ¨™¼U\x01 @H mè*=Ú0@\x16 ®‡\x19\x02 æ@p“Lð¦?b˜Æ\x16 ëï\x0F\x7F 4¿ÇØjÜÐÔ#&\x17 RŸòëK0‚"ËÒÐ \x08\x10 \x17 Ƽv…ôò \x19 ¯ðP\x0E ŸŒ'\x17 ïƒer\x08 ¶‰¤Bq¦Ç˜Ï‹\x17 õ\x05 ´38ÓŸwì\x01 ãš‹\x06 ƒ\x19 ¡º;¤ký\x08 &ãðäé’Ñ\x1C ÏŽ\n ¬ñAzˆú~ôP™öÉ
"""
b"\x1D §q<ŒâX³“\x08 ±¢`Õ\x11\x0F \x1E 3Ô¨ªJÿ¸žÎ¤ó‹™q\x1F §(\f 1†JŸ¿CV0\x0F à®s!F3:_\x16\x13 ÊÜId\r ÕŽ3< "
b"!nÒLÒ\x01 ¾¤Q\x1A Rßœ\x13\x05 y "
b"!•¤uàÈz|¬¹\v Åù," "
b"!Ë&|3ÄY\x12 ,¦\x1E Éø‹XS "
b""<«¤ÛGMᘆ…¨î.°\x1A "
b""=d<÷\v Ef›‘Êbl{È) "
b"#q<oîÆNîê¶0$ÝΔ9 "
b"$\x03 †'Œö_ÑOxYˆ(ZbŒ "
b"&\x01 Ÿ“ÈÞ%I¬`¾ãŒàn® "
b"&ØÖ,\x02 ŒE»:i|ÉRMÍ "
b"'=¨ÃF'Eꑼª¦\x13 ÇÎà "
b"'~\x14 àÄLEp›-\r \x04\x7F ùq— "
b"'»Œ!t§Êdi\x02 ¾¤f\x17 W¾ "
b"'ÙÆþ²gIs€(£éÓŽÿS "
b"((K.Lj\x13 ?‚Oó!SàBÉ "
b"(ÿÐ\x17 *‘L\x0F ²f\x1D Ù¤ãªÂ "
b")¾Jf¿\x10 J\x00 ˆù\x06 q;\x03 cJ "
b",\x12 )öREd¶iY“‚kN0Á "
b",\x1C rîåÝ0\x06 ‘§ÈÂcØ\t — "
b",˜ôÊ\x04 )\x07 ý¬ÖÇ\B\x13 Jñ "
b"-\x17 LlÒ\x1A @Óæ qZÏœÞ "
b"-ê®"ÖÀM\x0F ‰\õ\x05 ¶V¾ "
b".©e\x10 eùH¦»\x01 ¨Á\x19 ©Ÿ\x13 "
b".É-³\x17 äK¢†;„-\x12 ¹n¬ "
b"/F+]\x1F\t ó\x17 ИÉåËÂx "
b"0\x16 æã妬±ÝqÓ*–P«\v "
b"0¹UJý(JE¨¹|üK\x04 \r Å "
b"1š?Ë_ËE¹ G®b>g\x17 § "
b"1¥«”‘3B2Œ,”- €£N "
b"1©–(+•K˽.\x00\x1C æ\x16\x05 O "
b"2X\x06 ò‹S[¥©¹áAYK_Ë "
b"2¶.ÏA’‰«a›\x18 N+œ›Œ "
b"4\x1A ¹-õ½Cü¤<ŸKBý˜â "
b"6R\x12\x10 °uM2–a^‡\x05 P¹’ "
b"6XLçuw°úX†óíÁÍ»- "
b"6fá3l7I\x16 ¾6~³TÆ/€ "
b"79Jšš\x04 K„ª,߬í0‹8 "
b"7—J'û\x18 CêˆZokç‚uÄ "
b"7«\x1C ÿ5\x04 e.k ,OEøË "
b"8U1>„\x06 Ië¯ë\v\x10\x10 @ø, "
b"8XAš¾R5š {H‰O·ìï "
b"9\x05 “'g*UÍ\x11 vÒ\x07\x1F Ù\x03 ¢ "
b"9&·S\x12\x02 M©¹“‚ù‡rÚN "
b"9¹Ó²2\x1E J[‰\x05 ¥\e »6ã+ "
b":¯žŒ\x0F üIhšE#\x11 ÿ&# "
b":Ï~V\x08\x12 m›\x1C UuF:\x14 ¾¯ "
b":죑\x11 ûºÙK’UEËË³Æ "
b";\x07 ˜¸Ï(J\e ’mº½kµþ˜ "
b";(º2ñ\x14 ‰š§N„û‰\x19 B~ "
b";fÂ\x02\x17 M‹!DšÂµ\x02 £²\x10 "
b"<LB爵Í&Cú[÷M/U• "
b"<s>\x07 ¼úDH½\x17 e9ž\x1D\x07 Ù "
b"<Ÿ\x10 îÇ\x1E p5AL\x7F ¬‹ö±â "
b"<Ÿ˜\ðþFœ¤ÏKÏð\x17 Ó, "
b"<wÐPxn\x1C Zh‘ƒ€ès "
b"=\x08 Bj\x1D ©Iö¡$¢®ÏÜg` "
b"""
=\n
/OÀjK»“jõ\Ø |]
"""
b"=h…H8¶û}€wA!™¾Té "
b">´\x14\x1F ’JÒ‚¥ì@\x18 –“}& "
b">ï\x12 8ËeKŒ•è\x04\x1C ‚à7¿ "
b"?ŽEÇQè\x1C «Ð’JEºü8ì "
b"?ñ5\x16 HúH|˜~ öä:O— "
b"?ý’´Ã”E‹µ&›ÌÐRˆ\f "
b"@3»Z$óE³žkm72«,¸ "
b"@‡ƒ\f ï*Æq²ÊM\x17 ¡Ø\x1A Ù "
b"B\x06 9MføOu?A g-s "
b"B\x0E ÏÜÎHÔF_É5\x12 §\e "
b"BHØ\x11 b\x0F ET¢XoøÞ ˜´ "
b"CN7\x15\x13 0à`ålµP0+Ue "
b"CYJ¢õïÐ7-nëß?‹þ~ "
b"DM]î“6^ŽR¨¤\t\x10 S”= "
b"Dq\x11 Çâ±Mƒ‘:?¢\f ¢\x13 g "
b"Dóf*{J·kcä@1º\x14\x06 m "
b"E.$R?¦Dùºsá\¼\x1F bè "
b"ER]E\x08 ÈMÄ®F´ˆ\x17 Š_r "
b"E³L¤-¢K\x0E » +N\x03 B$ "
b"EÀ¸VÈ®“w…\x15 q6¯[‡¼ "
b"FKQ\x14 ÎÖË‘¿o2‹“x®/ "
b"F_§þ$íA&´bíkû\x01 <¯ "
b"G\x1C\x07 P'<u½«ü˜õJq> "
b"Gm"X\x1C ¶^C]f¥6¯4‰d "
b"IÇ\x16 µ%E=ŽËXsRî\) "
b"J\x04 ]ÜoCS†È2tÂRÈ× "
b"J\f 0Øa †d½D%Ý\x12 M‹ "
b"L \v eÞegÚ6\x1A P¨Þ°Þ¡ "
b"MÖ¾Yg>OÁ]\x03 ?o·5\x1E "
b"N¹øeŸ\x07 ºÉE3‰\x16 ‹fiŸ "
b"Pj²\x1D „A+y×G®XÝÉÊ• "
b"""
Q+\f \n
F§©'q\x13 €³r½^
"""
b"Q:éÕ\x1C ¿®Zž±½\x07 ëeW "
b"QFÚé/„@§»úO™sQJý "
b"Qð\x0E P\x07 WFÖœd\x0E _\x16 Æ+õ "
b"SW/2ÃÝG\x04 •¨š\jaó¡ "
b"T"Tê&GÞ®\x13 BC\x1C g‡ "
b"TH=\x03 ëèL\x10 ŒGpÌiE> "
b"TÙ8sÆ‹Â\x13 .àÁ±\x08 ?Î "
b"UsCè(iÅ#æåÃ'B\x17 Ö= "
b"UÀ¦\م郸”o• ýÄû "
b"VÀ\f ÷s\t -\x03\x1E ÷ÙÞ\x15 Q "
b"W®0\x1C "ô½ôòBNØ:\x1E Ô "
b"X2“7»ïF;¸Ç_á{ŽÒ "
b"XÓmŽÿÃÙ'—HÄ¥¹…§n "
b"YÔûg¼Ê\x1F J‚\x00 {—Ô%aŠ "
b"Y݇ï\e ×O©Ÿ'b\x15 úny! "
b"Zk\x7F ±ë\x14 Gñ‹µ\f –ѳCÄ "
b"ZžsÀ%3Jò¹ÙT\x03\x08 ÿ¥Ñ "
b"[Ç|Ë\f ý)t\x02 àíZ*²é "
b"\?î\e šÔEÒ€–]u\x10 l© "
b"]|\x15 “\x01 E¡¡\x19\x11 ÄRŽ:ž "
b"] bm\r ž\f 7rUÿ·_°“0 "
b"]ݨ´ÿØ\x1F ÿš«µx ñ\ "
b"^\x04 S\x1F “\e\v 7ZY.@Eé\x05 ± "
b"_.Õ1×FAλuÝcüa\x18 b "
b"_ILU½qO\x1D “Íšn>ˆœS "
b"_…"rà‡ð\x19\x1C 2U\x01 ½ùËw "
b"`e\x15 ÞØÜ ?ªÑ4\t\x07 é½M "
b"`z¶¨\x03\x17 n }¤£ß\x19 ³ "
b"`™¢NædN§°Giá`'¶. "
b"af>'g¬F„‘\x05 Ž}²˜\x14 "
b"aÚÒ<\x08\t LT›—d©¿‡¸ù "
b"añ/@KëçÒ\x14 KT\x1E ¬\å\x04 "
b"bñþ!ËÅLŽøaùžÂîç "
b"c?ì»C\f -PÍü«û¦µ¬© "
b"cBg"a¦Fõ‹X,sŸGÆJ "
b"d\x02\x08 ·e›A0ª×3\x14 Æ\x13\x17\x16 "
b"d\t Bb`~5ØR\x19 k"³ßß "
b"dmUª\x1C ë'çÖ;\x10\x1C s-\x7F × "
b"g¿”§0âA\x07 –ë\x17 ˆˆÅ}; "
b"hÔ\x12 «¨ÐBRS4±vº‡’N "
b"i\x1D €Ž.˜¹á¹\x03 Œà+\x18 Ãþ "
b"iïüî\ÃC¢‰Yá\t ±Îî "
b"jêT'i:éøµÉŽGAe£j "
b"k\x1A V]êoN,®CòÚ˜ÇõW "
b"kKn\x13 šSM·²ä.¬jæ2* "
b"m:+·Z\x07 Er•\r \x18\x10 /è!¤ "
b"m:yíÒ4G»¾\x01 ¹Æ¾wÉ\x01 "
b"m„¨–ü)LE´ˆºSIcYh "
b"mîL.ÏÚHßÚò.”¤\x16 Å "
b"nV\x19 JÓ®C1—d/‰²&oW "
b"nžÈ\x03 bœ:êÀúÀ¨Ñµ\x08 3 "
b"oÞÇ\x02 ÀÓß’MòOúLž´Õ "
b"p\f x¢ÝÄ°s‰ÉjPo›y‡ "
b"p\x14 SHÓÑF^”ÅÇ‹\x19 Ï.Z "
b"p_\x13 ;ÏGEŽ„ŽåØ\x1A ;LÓ "
b"pdæϸü\x00 lœ`’̇Ë_E "
b"pš ™Å4Hž«Ñÿ\x03 `\x12 —— "
b"qŠ\x16 )Ð\e †\r ¦¨´ó\r X¾ò "
b"r4¤ÉñÏJ©°G\e .\x02 U“L "
b"rŸêÐ*‘ì`«Z'¿\\x04 mp "
b"s\x1D ò\x1A •ôNÔ´„‰\x00 ·A¡’ "
b"s7¼VFPŠ,wxí”cñ "
b"t5Ò*l6•ý`¨OV¿\t ”¾ "
b"tÅŒ¥§<e«:\Zã Æiò "
b"tê˜_¼¸@Ö“Œøâ\v l±\v "
b"tóå1h¸K²€ž´Cñ\x13 ¨„ "
b"u\v\x07 ÎÑ(åï\x05 eM\x08 I³’ "
b"u¼dùôU@\x14 Kì§7·Ýø5 "
b"vsE~]\t Iß‹¯ía<$x] "
b"vË\x10 G†eG§´ \x13 Ïù|\x01 / "
b"x +\v p\e ˆU•¬\x14 ]]øm "
b"xb8m¼>¾…ô]$¶mÄ" "
b"y½\x15 xäÐA!”~‡~f`Áö "
b"zV½3Äã@ñ‚þq©óRy\x16 "
b"z“i³s#Mz„\x16 “Á…Í5æ "
b"zòÂœ×pa(.R\x02 î\x13 ¤¸û "
b"{Lø®Fµ¹%\e ÞòÇ„M "
b"{¡¿Š‚£å=\x00 vÍê-ã¬1 "
b"""
{×\x0F Ãp AïŒ×c\x12 \n
uÓx
"""
b"""
|\x01 ü.·¹~ºi\x06\x05 \n
\x01 ü«™|s\x1A ™øÎN\x06 µ¨A¯sž˜ý "
b"|„IþzÓÿµo\x1D IÖ\x10 sç" "
b"~üœ\x07 FÐI~»'\x10 ×#¶# "
b"\x7F K@\x16\x1E yB˸})†Fí¾„\x7F ]¥þ¤\x07 NŽrÙµCßëy€mÙñ$>OŽXcs\f òžÜ "
b"‚¤\x1A LéÿÑ:1`}\x08 L\x13 Õ "
b"ƒ\x11\x07 #Á¥Gbt<ÿ®~"žp "
b"ƒXmpúeývô)ÀóŠ3ö” "
b"„\x04 Æ63ðG÷ƒµˆ®ÃX™r "
b"„\r eÄ9ô‹ÃbÛX9Âs<¢ "
b"„K&\x02 ‡‘J®«½Í³:!š\x02 "
b"""
„N[-\x16 a\x12 \n
Ð$¯G%9\x7F ³
"""
b"„U~ߎcBÒÅÅ¡^\r K± "
b"…8äÁÉ×Ã8û¬tÁûj‚º "
b"†\x13\x00 ÷/B|›`¸ø Î\x1C "
b"†=\x1D "’æTj¯Òž’þÊTw "
b"ˆ¶¬\x07 ¡M!6\x13 µO¶ÃL%\r "
b"‰%›ú<Íà9ØY4S—ŸmŠ "
b"‰‘QN›çmî\x0F Ò¤`'zôÖ "
b"‰™2NË 6=—3wï~NÕ1 "
b"Šòî\x04 &¹^ý\x19 “‘?nƒ$Õ "
b"‹²¬9ÖU⡽’=Fjí« "
b"Œ\x06 ’ã†;þ^\x00 ‚¬Âûêñ[ "
b"""
Œ@O¯åŽE¡Ô\n
Óa,Æ\t
"""
b"Œqéó\x00 03¯"®W \t ¦Êi "
b"Œ„\v«\x04 Hö·ÒúNÎG"® "
b"Œí5Ú5úC9†õÎ\x01\x07 2/h "
b"Žr\v ÿ_cKò¯\x05 æ?t+» "
b"Ž\x16 Fíqv‡á¢¬Ùl¹zû "
b"Ž[\x0E ï\v\x15 ͉Ô3IÊ{ðä "
b"Ž]±š¦\x0F N¾†9¬\Ë}æ\x1D "
b"Žh`ù\v hl¹Z³á\x06 †¬@ "
b"\x07 ü,›.\x12 ‰û\x11 rPïer "
b"\x08 ƒ‚æÎÄÑ&U\x7F\t u«\x04 L "
b"pKF{HMþ´ŽJ!0\x0F\x12 "
b"à*L¹Ö‹\#Hxí*\x16 ì) "
b"èÏá(J\x19 œ!\v ùÁmƒS "
b"‘à\x1C Àœ'@\x13 òQÇqêÊŒ "
b"""
“ÖC\n
ëí\n
ŒTÈfň\t —\x1E
"""
b"•¡\v Ÿÿ]íÔ•ëö²ÁŽ=Ñ "
b"–×õrÖlO‘Œð”<R-Ú "
b"—9»-\t …Š6dóÆ)u궫 "
b"—ö?CÔs.\x11 ÛMyÃñ·5\x08 "
b"˜m‹´»:M궔Ræn˜ä™ "
b"""
˜Œ=7“qJ.‡ÚÝ\n
«&™
"""
b"›@½Ž%\x07 @¨ŽŽÌþ\r Da3 "
b"›vj»£\e »)\x1A îò\x18 bEõ¯ "
b"›‘\x1F z{K«–Fd°†¦„í "
b"›˜po\x1E ·O¾~‚\x06 {\x01 âsH "
b"›ü\Z)ª\x13 Ø"\x1E\t Žu¤ \x0E "
b"›üÈè\x16 ŒÉˆBÂ/eUV>X "
b"œFj;JàCR„õ\x03 ±¶Œ©¯ "
b":CÎÕ0Il„±\x12 \x12 ý´ "
b"Ž\x02 ÆH¡\x08 #ä5æÃ2k¸ "
b"žDZ³Ò´WõºG£l\x01 ãÓK "
b"Ÿ„\f …Æv\x15 Ó!UÈónž£ "
b"Ÿ”>:åJCQ¼¢ŒWNvÏ0 "
b" \x10 û<žèæÓíÌ„—\x16 Œ "
b" {\r ;†_P¸<û5\v ©Ÿ¦˜ "
b" šƒU\x7F Ÿ—\x10 ‡ì`è”Ø\f 0 "
b" ö\x06 óØýGì€\x18 õé¯Äë€ "
b"¢ÃÉ\x0E .+@‰¹ˆèY\x1F ¡Y "
b"£\x10 T]¤£\e F¤"Ø~\x02 "
b"£[552W\x1A _y\f Øð:ˆ! "
b"£ÅL*\v ä“ÒáwCM)Ûm± "
b"¤tÚ‹\x12 äÓ\e |Ÿù\x1C :j®\x1D "
b"¤pMã3…ax^¬\x07 ^7ž "
b"¥&sK8ŸBL³t\x14 G7Œö\x07 "
b"¥=\x11 !ˆËDb¹K¯–Ñ;ƒ "
b"¥‹wLcxÂŽ\x08\x12 ¥‹=p\x11\x0F "
b"¥ªæðËÿi:\x02 ãç¼Tß\x1A "
b"§uç\e KV@V”“h°Ã…\x11 N "
b"§Í±ê×&\x1C\x08 ÌÏé\x0E\x1E 厩 "
b"¨Ø5ø\x15 Ÿúëòð=zÕÔW "
b"©,’\x06 1I-©J–¡@é¶\x13 "
b"©x¬§éAþø0†Å,±à\x08 é "
b"«3obèLiºõç\x1F çÙ²Õ "
b"®¡wp®Àñ“7‘æ\x15 —6ç, "
b"¯=~ò 7©L`ó_žÎgµq "
b"¯¾Ã¯ùˆ.x\e 3{ëž\x18 ¾¢ "
b"¯È%¸à¬H{£\x13\x15 ¡¬^ÃX "
b"²K\x03 ‹„Üä.üSªnž\x18\x11 Þ "
b"²|në3l\x0F ê¼JYTZ{ºr "
b"²–[ÿ×I× \x13 ‹~Å´¤¥ "
b"³zj˜Có§ûÑ-éï½\x1E\v "
b"³Ç’@C5½\x15 ÃC\x0E ÏÏ&E "
b"´'\x0E ï^(\x1D 4Õœ&²n1\x18 "
b"µMð1¡{G8Ž°ž)Äö,b "
b"¶#:‡ÂËJž©5d2Nm\x11 ç "
b"·Ç¦äiÞ;•%q\x11 ¡~o² "
b"¸É&ír¶\x16 ;íW¾ \x08 yBÑ "
b"º\t ñƒ·tK\x03 ¶£Ð\x15 «m'ï "
b"ºc¤\x18\x07\x08 :\x18 2\x06 £=l¢i÷ "
b"º~z±÷\x14 O9‹\x06 Äû\t ‘H· "
b"º¸ÙZ.—àüÃô̲”…\x19 % "
b"»ŽÁPµ.JòDR\x00 æùº\r "
b"»Ÿàÿ²Úâ8ä1\x14\x02\f FÎb "
b"¾'øLP\x04 m8Ã\x00 æêýGÔ\ "
b"¾}÷>m‘\x1E Ø’_ŠÒ\t W¹Ì "
b"Àç\X™¬\v ‹éø\x07 W>HUì "
b"Ág¯rÉðÌ\x04\x1E ÏÄÉbI©L "
b"Á{\x0E Çôß¹âÞ#*Ð;_\x1D "
b"Á•F`”PCN²W\x16 Ñ}2½ "
b"ø9Ÿ¾\x16 K—’µ¬ö[È’U "
b"Ä\x14 Ie²\x19\f 0®Û@*u)ë" "
b"Ä"®“ØQLY6¬™^\x06 µì5 "
b"ÅX¾}\x01 #Iì‹%¤Ò=C£ù "
b"ÇKÏÉ¡˜ês<ðe\x16 iò½4 "
b"Çkšä³O7l\x1E\x04 5(¶üxx "
b"È\x04\x14 BàV›B˜\x1D\x1E\x1A\x01 Bª¡ "
b"È[\x1E \r \x04 ›L曎óÐr\x19 Äg "
b"ÈæðQáãø‹¸øÞ«8Ö« "
b"É)\x02 Ì\x08 ³þ"©œoýó›€÷ "
b"ɺý\x0E ¾Öþœ5$“ÑåŒT„ "
b"Éè´¼¼†kÌϸž,ÏÓe¶ "
b"Ê2…\x16 ‹€L«¦w±Q_‡ª˜ "
b"ÊsŠßÕUY|‘ì_\x14 ¸@'¸ "
b"ËŽqK\x02 ˜ÖfÐêÒ0ú¨nÞ "
b"Ëâi¾í\Mʪg“¨a\x04 …> "
b"Ëéðî\x1A @\x00 ÁÈü=„˜ÿÓW "
b"ÍvU ‡JT‡ùf\x15 O›§í "
b"Ï\x05 üùC£…(ѦÕÍoLÆ "
b"Ï\e u7†Q×'¬èØ…è4\x10 – "
b"Ï~9\x17 ,þCzŽ(+Z¯³vS "
b"Ð5jŒWSá-}áiCŸy€Y "
b"Ж©qÎÝ’Ð’¶A)pj\r w "
b"о1•t;F7ûqµ\x16 A\x06 "
b"ÑV–ò\e ÖIÕød”Yh\x05 ¤ "
b"""
ѱ4¹†ÌE\x13 „ñ\\x19 É\n
o
"""
b"Ó\x14 -=Y%.\v =ËëU¨ô "
b"ÓjmlžÆM[½z¨ƒ–ŠÈ "
b"Ôòê_>¦C8¦:P¿g\x04 õr "
b"Ôû ZTK<\x01 望aÒkÚ\x1C "
b"Õ5ÔµNgJϲ¬š\e 4{\x07 "
b"ÖO\x12 ˆ,šcÖœ'£§œ e¥ "
b"Ø$\x18 ‘6Iÿ½¤pŒBŒÍÏ "
b"ØÐU\x19 ˜(Cl¦\¢\x1E û™Ö+ "
b"""
Øü\n
»\x10 ãÇ\x1D ÷%Ûê‡Ñú_
"""
b"""
Ùû8ÆÛ\x1D ‹\n
$1ȱîÁêý
"""
b"ÚýúU\x17 îI£¢\x1A dígm=û "
b"Û„¹fjBדvß\x16 Ôì\x14 Ù "
b"Ü0Î\v a´MËŽDœ\x1F ÏÁ€Q "
b"Ý\v Qq\x14\f OX™Œº¯É\x1E ÌC "
b"Þ`Z©uæŽëD6»\x0E ªÕPú "
b"ÞšÅë_à>T?MÍ;B>\x11 ˆ "
b"ßo\x7F ƒpŒ@#¤òE2Ü™ªà "
b"ßø¼?\x0F iL\x11 ¬¨Rß¡ºNÉ "
b"ßþ¦C\x02 \r ܈5$ÑFx¢ã@ "
b"à\x18 röÛÄKx\x01 ö X\x1A r\x7F "
b"àÛ¨@\x13 Õ”£•pDyðm° "
b"àôÚýåR@\x04 œŽ\x00 §'ú$ª "
b"áQ¥,\x12 ^Hº“MA‚Öò‘¬ "
b"âsù‰·ôþ™C\x18 {—c\x07 |– "
b"âî#\x1A ÙÁ€NÏ:PŠ6‹ÓJ "
b"âÿí\x02 ¦ü×G\x0E 8\x08 µY\x06 ìU "
b"""
ã"J»b\n
L\x1D ´¦¿\f\x0E A $
"""
b"ãmy•løMS‚Û\x05 ºÓ‡? "
b"ãí,j\x1F ŒS¶tì‚Ñ~lj- "
b"ä\r Úl1—CÜ¿SP[ÖØZ[ "
b"äX_:ƒGCF‚ëV1Wó\x18\x1C "
b"åÖ|•Ý7Ðÿë“á½ë”q÷ "
b"æ\x7F\x19 ?ÑôFÃ ©\x16 ;†NU. "
b"æÏVí55ÛÀät\x17 y¯Ê\t\x1D "
b"æõf>¹\x11\x14 ù…\x05 $½QŸ\x1D ç "
b"çNˆmªÊ"¸ÎR6ÉT~Š\x16 "
b"èy\x0F\x13 ÙùHw–ÍVV…OÇ\x14 "
b"èŒîúá[c"œöïŠ_#Û¤ "
b"ê¬g¸2\t EJ¡øÏ°(\e Õ "
b"ë\t áF|\x1D ›0ß@D:~exA "
b"ë\v l\x06 ·vCS³‹êPP\f ÒÎ "
b"ìé1©¦ŽKlŒê)~†9\x19 "
b"í*§±dODx‡‘\x1D +‹Ú[¾ "
b"í^Wà}G¸£\x16 x«µËæ\t "
b"îãÇ!R$Ž§Ñ\v àd› ùÛ "
b"ï¹Ï\x14\x07 t³Â¹qäÖGŠ\x05 / "
b"ðk\x03 ¨/KëžztYUøE "
b"òéþÌtE˜Œ:¤¾Á‚\x07\x13 "
b"óƒ@\x07 U4jz¡DøÎ ñ[• "
b"óãÇÉmÓKg“¾7,šB\x04 ð "
b"óåö ¼ï@V¼Ô»¾\v Òím "
b"ô€;KòPp«—.ŽR½V¹ü "
b"õöäþ\x03 ”GŽ¼|a³;\f ø< "
b"ö:\x0F £Â3G”…D\x1E %qm| "
b"ö<þU€¥-V\x03 ÿ)ŽË5\x12 o "
b"öO¾¦ŠR`#È_žð“\x12\x07 ! "
b"ö£l”uIC㺅\x01 +sm4 "
b"÷èÐcLãÜy!\x1E L@I\x13 ø "
b"ø,\t è?vLýŸÿ\v ‡¤¡®o "
b"øb¥ã£Ð*Å\x1F FÙ)bTó± "
b"ùi(«yÌO\x10 €|\x19 ¤ˆæ\t ã "
b"ùœÅJ¼¨C3žŽ;«7¶µ "
b"ù°ŸšeÄK•¨%º]Û\x0E \r ¤ "
b"ú#\e +—-E~\x07 5zT¦\x03 * "
b"ú}«d™Î[Ä*½Íùý.~ "
b"úÎA<&!Ó?X_\x03 \1v˜– "
b"ûoH¶„ÄN”È¢Š¥[\x18 B "
b"ü\x1A 8DÂÖÃÀ\x1E\x03 ‹:^µã? "
b"üB×£qðã¾\x03 @ÞýëÜÑ "
b"ÿ\x18\x7F IΦzô–ªcuÖŒ.& "
]
SELECT
`property_group_option` . `id` as `property_group_option.id` ,
`property_group_option` . `property_group_id` as `property_group_option.groupId` ,
`property_group_option` . `color_hex_code` as `property_group_option.colorHexCode` ,
`property_group_option` . `media_id` as `property_group_option.mediaId` ,
`property_group_option` . `created_at` as `property_group_option.createdAt` ,
`property_group_option` . `updated_at` as `property_group_option.updatedAt` ,
`property_group_option.media` . `id` as `property_group_option.media.id` ,
`property_group_option.media` . `user_id` as `property_group_option.media.userId` ,
`property_group_option.media` . `media_folder_id` as `property_group_option.media.mediaFolderId` ,
`property_group_option.media` . `mime_type` as `property_group_option.media.mimeType` ,
`property_group_option.media` . `file_extension` as `property_group_option.media.fileExtension` ,
`property_group_option.media` . `uploaded_at` as `property_group_option.media.uploadedAt` ,
`property_group_option.media` . `file_name` as `property_group_option.media.fileName` ,
`property_group_option.media` . `file_size` as `property_group_option.media.fileSize` ,
`property_group_option.media` . `media_type` as `property_group_option.media.mediaTypeRaw` ,
`property_group_option.media` . `meta_data` as `property_group_option.media.metaData` ,
`property_group_option.media` . `config` as `property_group_option.media.config` ,
`property_group_option.media` . `path` as `property_group_option.media.path` ,
`property_group_option.media` . `private` as `property_group_option.media.private` ,
`property_group_option.media` . `thumbnails_ro` as `property_group_option.media.thumbnailsRo` ,
`property_group_option.media` . `file_hash` as `property_group_option.media.fileHash` ,
`property_group_option.media` . `created_at` as `property_group_option.media.createdAt` ,
`property_group_option.media` . `updated_at` as `property_group_option.media.updatedAt` ,
`property_group_option.media.translation.title` ,
`property_group_option.media.translation.title` as `property_group_option.media.title` ,
`property_group_option.media.translation.alt` ,
`property_group_option.media.translation.alt` as `property_group_option.media.alt` ,
`property_group_option.media.translation.customFields` ,
`property_group_option.media.translation.customFields` as `property_group_option.media.customFields` ,
`property_group_option.translation.name` ,
`property_group_option.translation.name` as `property_group_option.name` ,
`property_group_option.translation.position` ,
`property_group_option.translation.position` as `property_group_option.position` ,
`property_group_option.translation.customFields` ,
`property_group_option.translation.customFields` as `property_group_option.customFields`
FROM
`property_group_option`
LEFT JOIN `media` `property_group_option.media` ON `property_group_option` . `media_id` = `property_group_option.media` . `id`
LEFT JOIN (
SELECT
`property_group_option.translation` . `property_group_option_id` ,
`property_group_option.translation` . `name` as `property_group_option.translation.name` ,
`property_group_option.translation` . `position` as `property_group_option.translation.position` ,
`property_group_option.translation` . `custom_fields` as `property_group_option.translation.customFields`
FROM
`property_group_option_translation` `property_group_option.translation`
WHERE
`property_group_option.translation` . `language_id` = ?
) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation` . `property_group_option_id` = `property_group_option` . `id`
LEFT JOIN (
SELECT
`property_group_option.media.translation` . `media_id` ,
`property_group_option.media.translation` . `alt` as `property_group_option.media.translation.alt` ,
`property_group_option.media.translation` . `title` as `property_group_option.media.translation.title` ,
`property_group_option.media.translation` . `custom_fields` as `property_group_option.media.translation.customFields`
FROM
`media_translation` `property_group_option.media.translation`
WHERE
`property_group_option.media.translation` . `language_id` = ?
) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation` . `media_id` = `property_group_option.media` . `id`
WHERE
`property_group_option` . `id` IN (
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
? ,
?
)
Copy
SELECT `property_group_option` . `id` as `property_group_option.id` , `property_group_option` . `property_group_id` as `property_group_option.groupId` , `property_group_option` . `color_hex_code` as `property_group_option.colorHexCode` , `property_group_option` . `media_id` as `property_group_option.mediaId` , `property_group_option` . `created_at` as `property_group_option.createdAt` , `property_group_option` . `updated_at` as `property_group_option.updatedAt` , `property_group_option.media` . `id` as `property_group_option.media.id` , `property_group_option.media` . `user_id` as `property_group_option.media.userId` , `property_group_option.media` . `media_folder_id` as `property_group_option.media.mediaFolderId` , `property_group_option.media` . `mime_type` as `property_group_option.media.mimeType` , `property_group_option.media` . `file_extension` as `property_group_option.media.fileExtension` , `property_group_option.media` . `uploaded_at` as `property_group_option.media.uploadedAt` , `property_group_option.media` . `file_name` as `property_group_option.media.fileName` , `property_group_option.media` . `file_size` as `property_group_option.media.fileSize` , `property_group_option.media` . `media_type` as `property_group_option.media.mediaTypeRaw` , `property_group_option.media` . `meta_data` as `property_group_option.media.metaData` , `property_group_option.media` . `config` as `property_group_option.media.config` , `property_group_option.media` . `path` as `property_group_option.media.path` , `property_group_option.media` . `private` as `property_group_option.media.private` , `property_group_option.media` . `thumbnails_ro` as `property_group_option.media.thumbnailsRo` , `property_group_option.media` . `file_hash` as `property_group_option.media.fileHash` , `property_group_option.media` . `created_at` as `property_group_option.media.createdAt` , `property_group_option.media` . `updated_at` as `property_group_option.media.updatedAt` , `property_group_option.media.translation.title` , `property_group_option.media.translation.title` as `property_group_option.media.title` , `property_group_option.media.translation.alt` , `property_group_option.media.translation.alt` as `property_group_option.media.alt` , `property_group_option.media.translation.customFields` , `property_group_option.media.translation.customFields` as `property_group_option.media.customFields` , `property_group_option.translation.name` , `property_group_option.translation.name` as `property_group_option.name` , `property_group_option.translation.position` , `property_group_option.translation.position` as `property_group_option.position` , `property_group_option.translation.customFields` , `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `media` `property_group_option.media` ON `property_group_option` . `media_id` = `property_group_option.media` . `id` LEFT JOIN (SELECT `property_group_option.translation` . `property_group_option_id` , `property_group_option.translation` . `name` as `property_group_option.translation.name` , `property_group_option.translation` . `position` as `property_group_option.translation.position` , `property_group_option.translation` . `custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation` . `property_group_option_id` = `property_group_option` . `id` LEFT JOIN (SELECT `property_group_option.media.translation` . `media_id` , `property_group_option.media.translation` . `alt` as `property_group_option.media.translation.alt` , `property_group_option.media.translation` . `title` as `property_group_option.media.translation.title` , `property_group_option.media.translation` . `custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation` . `media_id` = `property_group_option.media` . `id` WHERE `property_group_option` . `id` IN (0x00795DED0C0049B8B75B2FF432ED635C , 0x00B20D4F99734906805BDE7E6DD43361 , 0x00DF5B10E792430AB76B6BB26CDB0CD3 , 0x016C3CA5BA88456B999B013786A9E70C , 0x016D236B1F172FA86BED2033814A2A4F , 0x02737AFED37C4FF79790C8ACACE1A1D9 , 0x0291E77850BC16C565D4AB9045913E0D , 0x02B452FF2D3705246355C02F152850F8 , 0x032D3DC1BFCA247C736C4E0EDE54A769 , 0x0357AB1CF8284F1384131359A36118E5 , 0x0377F071731D3483D7784DF17541062D , 0x041A05544079E8DFC13C74772F46DC2C , 0x041C38ED79661128C146A824CAA0068F , 0x0634D29545D2EF2415EDBD34F6A77992 , 0x06833BF888C2C1A5742C71B2FF96F920 , 0x06FEE08347B19BC241C741EFD43D2E9C , 0x0768F446281B6555F99AAFF15ECE52DA , 0x07E772414ABA95DF203A9BF464CFC1FD , 0x08072FD3E27440F387C377989E621F2B , 0x08A1C76CD231468390932CD1AC38B9D5 , 0x0B8B88BFF1E1439FBE11D972CC3AEBE0 , 0x0BCCC29A1B144127C1ED139E869B836D , 0x0C391B01FC2A4A03A8BA13A7A595D8B7 , 0x0CB9301C8B42DCF5E2786A25DFBC2EC3 , 0x0DC9A76F88AB150FEA4FA5CE50CC4248 , 0x0DD7EA4E35CE4CA59374C2509A1C1D36 , 0x0DDA0290A93CFF2424950DF17B1E53DB , 0x0E18B1F9895B4DF788FCC81E8D98B2C4 , 0x0EB46BF5C2E07E7872490AF8C3839CF3 , 0x0FD6D1D22B6C9BAA0C67AC07780AEA32 , 0x0FEFCE7E0F7647AD8545E8C6C12F1EE5 , 0x10D8C3F2291B42B5A5297C576AA9DD15 , 0x139D7777B23B6F2E39E7D23BC0D9D5FB , 0x13BF31AF840E0D9721640873CD9DB666 , 0x1427D08B2451448EAE528D86B1336FA6 , 0x14988C186FD14737A507C58ED123FA22 , 0x14B5BC440759A2D49A008AE1E26C5FE7 , 0x15CB0F50B9E4CD94D749E682BF9BF69A , 0x166C2B28DC9ABACEC4C3757E951A4B29 , 0x1678E04743F936A14C9A04E5F1828EF4 , 0x16A899BC55014048A06DE82A3DDA3040 , 0x16AE871902E64070934CF0A63F6298C6 , 0x16EBEF810F7F34BFC7D86ADCD0D42326 , 0x17529F81F2EB4B308222CBD2D0A00810 , 0x17C6BC7685F4F22019AFF0500E9F8C27 , 0x17EF83657208B689A44271A6C798CF8B , 0x17F505B43338D39F77EC01E39A8B0683 , 0x19A1BA3BA46BFD9D0826E3F0E4E992D1 , 0x1CCF8E0AACF1417A88FA7EF45099F6C9 , 0x1DA7713C8CE258B39308B1A260D5110F , 0x1E33D4A8AA814AFFB89ECEA4F38B9971 , 0x1FA7280C31864A9FBF4356300FE0AE73 , 0x2146333A5F1613CADC49640DD58D333C , 0x216ED24CD201BEA4511A52DF9C130579 , 0x2195A475E0C87A7CACB90BC5F92C229D , 0x21CB267C33C459122CA61EC9F88B5853 , 0x223CABA4DB474DE1988685A8EE2EB01A , 0x223D643CF70B45669B91CA626C7BC829 , 0x23713C6FEEC64EEEEAB63024DDCE9439 , 0x240386278CF65FD14F785988285A628C , 0x26019F93C8DE2549AC60BEE38CE06EAE , 0x26D8D62C028C45BB813A697CC9524DCD , 0x273DA8C3462745EA91BCAAA613C7CEE0 , 0x277E14E0C44C45709B2D0D047FF97197 , 0x27BB8C2174A7CA646902BEA4661757BE , 0x27D9C6FEB26749738028A3E9D38DFF53 , 0x28284B2E4C6A133F824FF32153E042C9 , 0x28FFD0172A914C0FB2661DD9A4E3AAC2 , 0x29BE4A66BF104A0088F906713B03634A , 0x2C1229F6524564B6695993826B4E30C1 , 0x2C1C72EEE5DD300691A7C8C263D80997 , 0x2C98F4CA042907FDACD6C75C42134AF1 , 0x2D174C6CD21A40D38FE620715ACF9CDE , 0x2DEAAE22D6C04D0F895CF505B69056BE , 0x2EA9651065F948A6BB01A8C119A99F13 , 0x2EC92DB317E44BA2863B842D12B96EAC , 0x2F462B5D1F09A0F317D098C9E5CBC278 , 0x3016E6E3E5A6ACB1DD71D32A9650AB0B , 0x30B9554AFD284A45A8B97CFC4B040DC5 , 0x319A3FCB5FCB45B9A047AE623E6717A7 , 0x31A5AB94913342328C2C942DA080A34E , 0x31A996282B954BCBBD2E001CE616054F , 0x325806F28B535BA5A9B9E141594B5FCB , 0x32B62ECF419289AB619B184E2B9C9B8C , 0x341AB92DF5BD43FCA43C9F4B42FD98E2 , 0x36521210B0754D3296615E870550B992 , 0x36584CE77577B0FA5886F3EDC1CDBB2D , 0x3666E1336C374916BE367EB354C62F80 , 0x37394A9A9A044B84AA2CDFACED308B38 , 0x37974A27FB1843EA885A6F6BE78275C4 , 0x37ADAB1CFF3504652E6BA02C4F45F8CB , 0x3855313E840649EBAFEB0B101040F82C , 0x3858419ABE52359AA07B48894FB7ECEF , 0x39059327672A55CD1176D2071FD903A2 , 0x3926B75312024DA9B99382F98772DA4E , 0x39B9D3B2321E4A5B8905A51BBB36E32B , 0x3AAF9E8C0FFC49689A452311FF8F2623 , 0x3ACF7E5608126D9B1C5575463A14BEAF , 0x3AECA39111FBBAD94B925545CBCBB3C6 , 0x3B0798B8CF284A1B926DBABD6BB5FE98 , 0x3B28BA32F114899AA74E84FB8919427E , 0x3B66C202174D8B21449AC2B502A3B210 , 0x3C4C42EFAA9ECD2643FA5BF74D2F5595 , 0x3C733E07BCFA4448BD1765399E1D07D9 , 0x3C9F10EEC71E7035414C7FAC8BF6B1E2 , 0x3C9F985CF0FE469CA4CF4BCFF017D32C , 0x3CAD77D05078AD6E1C5A68918380E873 , 0x3D08426A1DA949F6A124A2AECFDC6760 , 0x3D0A2F4FC06A4BBB936AF55CD8A07C5D , 0x3D68854838B6FB7D8077412199BE54E9 , 0x3EB4141F924AD282A5EC401896937D26 , 0x3EEF1238CB654B8C95E8041C82E037BF , 0x3F8D45C751E81CABD0924A45BAFC38EC , 0x3FF1351648FA487C987E20F6E43A4F97 , 0x3FFD92B4C394458BB5269BCCD052880C , 0x4033BB5A24F345B39E6B6D3732AB2CB8 , 0x4087830CEF2AC671B2CA4D17A1D81AD9 , 0x4206394D66F84F75903F8F41A0672D73 , 0x420ECF8FDCCE9048D4465FC93512A71B , 0x4248D811620F4554A2586FF8DEA098B4 , 0x434E37151330E060E56CB550302B5565 , 0x43594AA2F5EFD0372D6EEBDF3F8BFE7E , 0x444D5DEE93365E8E52A8A4091053943D , 0x447111C7E2B14D83913A3FA20CA21367 , 0x44F3662A7B4AB76B63E44031BA14066D , 0x452E24523FA644F9BA73E15CBC1F62E8 , 0x45525D4508C84DC4AE46B488178A5F72 , 0x45B34CA42DA24B0EBBA0A02B4E034224 , 0x45C0B856C8AE937785157136AF5B87BC , 0x464B5114CED6CB91BF6F328B9378AE2F , 0x465FA7FE24ED4126B462ED6BFB013CAF , 0x471C0750273C8F75BDABFC98F54A713E , 0x476D22581CB65E435D66A536AF348964 , 0x49C716B59D25453D8ECB587352EE5C29 , 0x4A045D8FDC6F435386C83274C252C8D7 , 0x4A0C308FD861208664BD4425DD124D8B , 0x4C200B65DE6567DA361A50A8DEB0DEA1 , 0x4DD6BE59673E4FC18F5D033F6FB7351E , 0x4EB9F8659F07BAC9453389168B66699F , 0x506AB21D84412B79D747AE58DDC9CA95 , 0x512B0C0A46A7A92771139080B372BD5E , 0x513AE9D51CBFAE9D5A9EB1BD07EB6557 , 0x5146DAE92F8440A7BBFA4F9973514AFD , 0x51F00E50075746D69C640E5F16C62BF5 , 0x53572F32C3DD470495A89A5C6A61F3A1 , 0x542254EA269D47DEAE1342431C9D6787 , 0x54483D03EBE84C108CAD4770CC69453E , 0x54D93873C68BC2132EE0C1B1083FCE9D , 0x557343E82869C523E6E5C3274217D63D , 0x55C0A65CD985E983B8946F9520FDC4FB , 0x56C00CF79D73092D031EF790D9DE1551 , 0x57AE8F301C22F4BDF4F2424ED83A1ED4 , 0x58329337BBEF463B90B8C75FE17B8DD2 , 0x58D36D8EFFC3D9279748C4A5B985A76E , 0x59D4FB67BCCA1F4A82007B97D425618A , 0x59DD87EF1BD74FA99F276215FA6E7921 , 0x5A6B7FB1EB1447F18BB50C96D1B343C4 , 0x5A9E73C025334AF2B9D9540308FFA5D1 , 0x5BC77CCB0CFD297402E09DED5A2AB2E9 , 0x5C3FEE1B9AD445D280965D9075106CA9 , 0x5D7C1593AD0145A1A11911C4528D3A9E , 0x5DA0626D0D9E0C377255FFB75FB09330 , 0x5DDDA8B4FFD81FFFAD9AABB57820F15C , 0x5E04531F931B0B375A592E4045E905B1 , 0x5F2ED531D74641CEBB75DD63FC611862 , 0x5F494C55BD714F1D93CD9A6E3E889C53 , 0x5F852272E087F0191C325501BDF9CB77 , 0x606515DED8DCA03FAAD1340907E9BD4D , 0x607A90B6A803176EA07DA4A3DF19B3AD , 0x6099A24EE6644EA7B04769E16027B62E , 0x61663E2767AC468491058D7DB2981490 , 0x61DAD23C08094C549B9764A9BF87B8F9 , 0x61F12F404BEBE7D2144B541EAC5CE504 , 0x62F1FE21CBC54C8E9DF861F99EC2EEE7 , 0x633FECBB430C2D50CDFCABFBA6B5ACA9 , 0x6342672261A646F58B582C739F47C64A , 0x640208B7659B4130AAD73314C6131716 , 0x64094262607E35D852196B8F22B3DFDF , 0x646D55AA1CEB27E7D63B101C732D7FD7 , 0x67BF94A730E2410796EB178888C57D3B , 0x68D412ABA8D042525334B176BA87924E , 0x691D808D2E98B9E1B9038CE02B18C3FE , 0x69EFFCEE5CC343A289599DE109B1CEEE , 0x6AEA5427693AE9F8B5C98D474165A36A , 0x6B1A565DEA6F4E2CAE43F2DA98C7F557 , 0x6B4B6E139A534DB7B2E42EAC6AE6322A , 0x6D3A2BB75A074572950D18102FE821A4 , 0x6D3A79EDD23447BBBE01B9C6BE77C901 , 0x6D84A896FC294C45B488BA5349635968 , 0x6DEE4C2ECFDA48DF81DAF22E94A416C5 , 0x6E56194AD3AE433197642F89B2266F57 , 0x6E9EC803629C3AEAC0FAC0A8D1B50833 , 0x6FDEC702C0D3DF924DF24FFA4C9EB4D5 , 0x700C78A2DDC4B07389C96A506F9B7987 , 0x70145348D3D1465E94C5C78B19CF2E5A , 0x705F133BCF47458E848DE5D81A3B4CD3 , 0x7064E6CFB8FC006C9C6092CC87CB5F45 , 0x709AA099C534489EABD1FF0360129797 , 0x718A1629D01B860DA6A8B4F30D58BEF2 , 0x7234A4C9F1CF4AA9B0471B2E0255934C , 0x729FEAD02A91EC60AB5A27BF5C046D70 , 0x731DF21A95F44ED4B4848900B741A192 , 0x73378181BC5646508A2C7778ED9463F1 , 0x7435D22A6C3695FD60A84F56BF0994BE , 0x74C58CA5A73C65AB3A5C5AE320C669F2 , 0x74EA985FBCB840D6938CF8E20B6CB10B , 0x74F3E53168B84BB2809EB443F113A884 , 0x750B07CED128E5EFAD05654D0849B392 , 0x75BC64F9F45540144BECA737B7DDF835 , 0x7673457E5D0949DF8BAFED613C24785D , 0x76CB1047866547A7B4A013CFF97C012F , 0x78202B0B20701B885595AC145D5DF86D , 0x7862386DBC813EBE85F45D24B66DC422 , 0x79BD1578E4D04121947E877E6660C1F6 , 0x7A56BD33C4E340F182FE71A9F3527916 , 0x7A9369B373234D7A841693C185CD35E6 , 0x7AF2C29CD77061282E5202EE13A4B8FB , 0x7B9D4CF8AEAD46B5B9251BDEF2C7844D , 0x7BA1BF8A82A3E53D0076CDEA2DE3AC31 , 0x7BD70FC3702041EF8CD763120A75D378 , 0x7C01FC2EB7B97EBA6906050A01FCAB99 , 0x7C731A99F8CE4E06B5A841AF739E98FD , 0x7C8449FE7AD3FFB56F1D49D61073E722 , 0x7EFC9C0746D0497E8FBB2710D723B623 , 0x7F4B40161E7942CBB87D298646EDBE84 , 0x7F5DA5FEA4074E8E9D72D9B543DFEB79 , 0x806DD9F1243E4F8EAD5863730CF29EDC , 0x82A41A4CE9FFD13A9D31607D084C13D5 , 0x83110723C1A54762743CFFAE7E229E70 , 0x83586D70FA65FD76F429C0F38A33F694 , 0x8404C63633F047F783B588AEC3589972 , 0x840D65C439F48BC362DB5839C2733CA2 , 0x844B260287914AAEABBDCDB33A219A02 , 0x844E5B2D1661120AD024AF4725397FB3 , 0x8455817EDF8E6342D2C5C5A15E0D4BB1 , 0x8538E4C1C9D7C338FBAC74C1FB6A82BA , 0x861300F72F90427C8F9B60B8F8A0CE1C , 0x863D1D2292E6546AAFD29E92FECA5477 , 0x88B6AC07A14D213613B54FB6C34C250D , 0x89259BFA3CCDE039D8593453979F6D8A , 0x8991514E9BE76DEE0FD2A460277AF4D6 , 0x8999324ECBA0363D973377EF7E4ED531 , 0x8AF2EE0426B95EFD1993913F6E8324D5 , 0x8BB2AC39D655E2A1BD923D466AEDAB9D , 0x8C0692E3863BFE5E0082ACC2FBEAF15B , 0x8C404FAFE58D45C2A1D40AD3612CC609 , 0x8C71E9F3003033AF22AE572009A6CA69 , 0x8C845C76AB0448F6B7D2FA4ECE4722AE , 0x8CED35DA35FA433986F5CE0107322F68 , 0x8D720BFF5F634BF2AF05E6AD3F742BBB , 0x8E1646ED717687E19DA2ACD96CB97AFB , 0x8E5B0EEFAD0B15CD89D43349CA7BF0E4 , 0x8E5DB19AA60F4EBE8639AC5CCB7DE61D , 0x8E6860F90B686CB95A81B3E10686AC40 , 0x8F07FC2C9B2E1289FB1172509DEF6572 , 0x8F088382E6CEC4D126557F0975AB044C , 0x8F704B467B484DFEB48D4A21309D0F12 , 0x8FE02A4CB9D68B5C234878ED2A16EC29 , 0x8FE8CFE1AD284A199C210BF9C16D8353 , 0x91E01CC09C274013ADF251C771EACA8C , 0x93D6430AEBED0A8C54C866C58809971E , 0x95A10B9FFF5DEDD495EBF6B2C18D3DD1 , 0x96D7F572D66C4F918CF0943C522DDAAD , 0x9739BB2D09858A3664F3C62975EAB6AB , 0x97F63F43D4732E11DB4D79C3F1B73508 , 0x986D8BB4BB3A4DEAB69452E66E98E499 , 0x988C3D3793714A2E87DADD0AAB2699A0 , 0x9B40BD8D250740A88D8ECCFE0D446133 , 0x9B766ABBA31BBB291AEEF2186245F5AF , 0x9B911F7A9D7B4BAB964664B086A684ED , 0x9B98706F1EB74FBE7E82067B01E27348 , 0x9BFC5C5A29AA13D8221E098D75A4200E , 0x9BFCC8E8168CC98842C22F6555563E58 , 0x9C466A3B4AE0435284F503B1B68CA9AF , 0x9D3A43CED530496C84B181128F12FDB4 , 0x9D8F8D02C648A10823E435E6C3326BB8 , 0x9E445AB3D2B457F5BA47A36C01E3D34B , 0x9F840C85C67615D3215590C8F36E9EA3 , 0x9F943E3AE54A4351BCA28C574E76CF30 , 0xA0108FFB3C9EADE8E6D3EDCC8497168C , 0xA07B0D3B865F50B83CFB350BA99FA698 , 0xA09A83557F9F971087EC60E894D80C30 , 0xA0F606F3D8FD47EC8018F5E9AFC4EB80 , 0xA2C3C90E2E2B4089B988E8591FA159A0 , 0xA31081545DA4A31B46A4229DD87E0220 , 0xA35B353532571A5F790CD8F03A882120 , 0xA3C54C2A0BE493D2E177434D29DB6DB1 , 0xA474DA8B12E4D31B7C9FF91C3A6AAE1D , 0xA49D704DE3338561785EAC075E378F9E , 0xA526734B389F424CB3741447378CF607 , 0xA53D112188CB4462B94BAF8F96D13B83 , 0xA58B774C6378C28D0812A58B3D70110F , 0xA58FAAE6F0CBFF693A02E3E7BC54DF1A , 0xA775E71B4B564056949368B0C385114E , 0xA7CDB1EAD7261C08CCCFE90E1EE58DA9 , 0xA8D835F8159FFAEBF2F03D7AD590D457 , 0xA92C920631492DA94A96A18140E9B613 , 0xA978ACA7E941FEF83086C52CB1E008E9 , 0xAB336F62C3A84C69BAF5E71FE7D9B2D5 , 0xAEA17770AEC0F1933791E6159736E72C , 0xAF3D7EF2A037A94C60F35F9ECE67B571 , 0xAFBEC3AFF9882E781B337BEB9E18BEA2 , 0xAFC825B8E0AC487BA31315A1AC5EC358 , 0xB24B038B84DCE42EFC53AA6E9E1811DE , 0xB27C6EEB336C0FEABC4A59545A7BBA72 , 0xB2965BFF90D749D7A0138B7EC5B4A4A5 , 0xB37AAD6A9843F3A7FBD12DE9EFBD1E0B , 0xB3C792404335BD15C3430ECFCF269045 , 0xB490270EEF5E281D34D59C26B26E3118 , 0xB54DF031A17B47388DB09E29C4F62C62 , 0xB6233A87C2CB4A9EA93564324E6D11E7 , 0xB7C7A6E4699DDE3B95257111A17E6FB2 , 0xB8C926ED72B6163BED57BE20087942D1 , 0xBA09F183B7744B03B6A3D015AB6D27EF , 0xBA63A41807083A183206A33D6CA269F7 , 0xBA7E7AB1F7144F398B06C4FB099148B7 , 0xBAB8D95A2E97E0FCC3F4CCB294851925 , 0xBB8EC150B52E4AF2AD445200E6F9BA0D , 0xBB9FE0FFB2DAE238E43114020C46CE62 , 0xBE27F84C50046D38C300E6EAFD47D45C , 0xBE7DF73E6D911ED8925F8AD20957B9CC , 0xC0E75C5899AC0B8BE9F807573E4855EC , 0xC167AF72C9F0CC041ECFC4C96249A94C , 0xC17B0EC7F4DF8FB9E2DE232AD03B5F1D , 0xC19546609450434EB28F5716D17D32BD , 0xC3B8399FBE164B9792B5ACF65BC89255 , 0xC4144965B2190C30AEDB402A7529EB22 , 0xC422AE93D8514C5936AC995E06B5EC35 , 0xC558BE7D012349EC8B25A4D23D43A3F9 , 0xC74BCFC9A198EA733CF0651669F2BD34 , 0xC76B9AE4B34F376C1E043528B6FC7878 , 0xC8041442E0569B42981D1E1A0142AAA1 , 0xC85B1E0D049B4CE69B8DF3D07219C467 , 0xC8ADE6F051E1E3F88BB8F8DEAB38D6AB , 0xC92902CC08B3FE22A99C6FFDF39B80F7 , 0xC9BAFD0EBED6FE9C352493D1E58C5484 , 0xC9E8B4BCBC866BCCCFB89E2CCFD365B6 , 0xCA3285168B804CABA677B1515F87AA98 , 0xCA738ADFD555597C91EC5F14B84027B8 , 0xCB8E714B0298D666D0EAD230FAA86EDE , 0xCBE269BEED5C4DCAAA6793A86104853E , 0xCBE9F0EE1A4000C1C8FC3D8498FFD357 , 0xCD765520874A5487F96615814F9BA7ED , 0xCF05FCF943A38528D1A6D5CD6FAD4CC6 , 0xCF1B75378651D727ACE8D885E8341096 , 0xCF7E39172CFE437A8D282B5AAFB37653 , 0xD0356A8C5753E12D7DE169439F798059 , 0xD096A971CEDD92D092B64129706A0D77 , 0xD0BE3195743B4637FB71B59DAD164106 , 0xD15696F21BD649D59DF86494596805A4 , 0xD1B134B986CC4513848FF15C19C90A6F , 0xD31420812D3D59252E0B3DCBEB55A8F4 , 0xD36A6D6C9EC64D5BBD7AA88390968AC8 , 0xD4F2EA5F3EA64338A63A50BF6704F572 , 0xD4FBA05A544B3C01E69C9B61D26BDA1C , 0xD535D4B54E674ACFB2AC9A1B348F7B07 , 0xD64F12882C9A63D69C27A3A79CA065A5 , 0xD8902418913649FFBDA4708C428CCDCF , 0xD8D055199828436CA65CA21EFB99D62B , 0xD8FC0ABB10E3C71DF725DBEA87D1FA5F , 0xD9FB38C6DB1D8B0A2431C8B1EEC1EAFD , 0xDAFDFA5517EE49A3A21A64ED676D3DFB , 0xDB84B9666A8F42D79376DF16D4EC14D9 , 0xDC30CE0B61B44DCB8E449C1FCFC18051 , 0xDD0B5171140C4F58998CBAAFC91ECC43 , 0xDE605AA975E68DEB4436BB0EAAD550FA , 0xDE9AC5EB5FE03E543F4DCD3B423E1188 , 0xDF6F7F83708C4023A4F24532DC99AAE0 , 0xDFF8BC3F0F694C11ACA852DFA1BA4EC9 , 0xDFFEA643020DDC883524D14678A2E340 , 0xE01872F6DBC44B788F01F620581A727F , 0xE0DBA840139DD594A395704479F06DB0 , 0xE0F4DAFDE55240049C8D00A727FA24AA , 0xE151A52C125E48BA934D4182D6F291AC , 0xE273F989B7F4FE9943187B9763077C96 , 0xE2EE231AD9C1804ECF3A508A368BD34A , 0xE2FFED02A6FCD7470E3808B55906EC55 , 0xE3224ABB620A4C1DB4A6BF0C0E412024 , 0xE36D79956CF84D5382DB8105BAD3873F , 0xE3ED2C6A1F8C53B674EC82D17E6C6A2D , 0xE40DDA6C319743DCBF53505BD6D85A5B , 0xE4585F3A8347434682EB563157F3181C , 0xE5D67C95DD37D0FFEB93E1BDEB9471F7 , 0xE67F193FD1F446C3A0A9163B864E552E , 0xE6CF56ED3535DBC0E4741779AFCA091D , 0xE6F5663EB91114F9850524BD519F1DE7 , 0xE74E886DAACA22B8CE5236C9547E8A16 , 0xE8790F13D9F9487796CD5656854FC714 , 0xE88CEEFAE15B63229CF6EF8A5F23DBA4 , 0xEAAC67B83209454AA1F8CFB0281BD590 , 0xEB09E1467C1D9B30DF40443A7E657841 , 0xEB0B6C06B7764353B38BEA50500CD2CE , 0xECE931A9A68D4B6C8CEA297E9D863919 , 0xED2AA7B1644F447887911D2B8BDA5BBE , 0xED5E57E0AD7D47B8A31678ABB5CBE609 , 0xEEE3C72152248EA7D10BE0649BA0F9DB , 0xEFB9CF140774B3C2B971E4D6478A052F , 0xF06B03A82F814BEB9E7A7459AD55F845 , 0xF2E9FE8FCC7445988C3AA4BEC1820713 , 0xF383400755346A7AA144F8CEA0F15B95 , 0xF3E3C7C96DD34B6793BE372C9A4204F0 , 0xF3E5F620BCEF4056BCD4BBBE0BD2ED6D , 0xF4803B4BF25070AB972E8D52BD56B9FC , 0xF5F6E4FE0394478DBC7C61B33B0CF83C , 0xF63A0FA3C233479485441E259D716D7C , 0xF63CFE5580A52D5603FF298DCB35126F , 0xF64FBEA68A526023C85F9EF093120721 , 0xF6A36C94754943E3BA8581012B736D34 , 0xF7E8D0639D4CE3DC79211E4C404913F8 , 0xF82C09E83F764CFD9FFF0B87A4A1AE6F , 0xF862A5E3A3D02AC51F46D9296254F3B1 , 0xF96928AB79CC4F10807C19A488E609E3 , 0xF99CC54ABCA843339E8E3BAB37B69DB5 , 0xF9B09F9A65C44B95A825BA5DDB0E0DA4 , 0xFA231B2B972D457E8F07357A54A6032A , 0xFA7DAB6499CE5BC42ABD9DCDF9FD2E7E , 0xFACE413C2621D33F585F035C31769896 , 0xFB6F48B684C44E948FC8A28AA55B1842 , 0xFC1A3844C2D6C3C01E038B3A5EB5E33F , 0xFC4290D7A371F0E3BE0340DEFDEBDCD1 , 0xFF187F49CEA67AF496AA6375D68C2E26 );
Copy
30
0.36 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"Á¸R´ñûO›ªÌV™›;94 "
b"Î\x7F Œ\r "ÂFòŽ ª\f á\x0E ÷² "
b"År\x13 žG©HH¨˜ú\x01 i¥N® "
b"]ŽÃd0\x05 MaH-Ž2\x14 ¿÷ "
b"A»I_\x16 KB)ŠT›"<3›W "
b"÷W\x15 €\x02 ¯@ŸŽÑaà(~ÆÁ "
b"Í\x0E `]m\x1F G…š•U}£/½ "
b"\x15 'þÿFL¡,ÆÊ’\x0E 5m "
b"Bdé\r ¹O®²ƒ¼Õ\x10 ÖZó "
b"\x08 Eñ\t 8Eê·Ö,«ŽÉùŒO÷Ô(ï®H_»»ùŸ\x16 ˆér "
b"7¹“ñ\x1A ÂCj·Ž»(»]\ "
]
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 , 0xC1B852B4F1FB4F9BAACC56999B3B3934 , 0xCE7F8C0D22C246F28EA0AA0CE10EF7B2 , 0xC572139E47A94848A898FA0169A54EAE , 0x5D8DC36430054D6181482D8D3214BFF7 , 0x41BB495F164B42298A549B223C339B57 , 0xF757158002AF409F8DD161E0287EC6C1 , 0xCD0E605D6D1F47859A95559D7DA32FBD , 0x81159D27FEFF464CA12CC6CA920E356D , 0x4264E90DB99D4FAEB283BCD510D65AF3 , 0x0845F1098F3845EAB7D62CAB8DC9F98C , 0x4FF7D428EFAE485FBBBBF99F1688E972 , 0x37B993F11AC2436AB78EBB28BB5D5C90 ));
Copy
31
0.16 ms
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = ? OR `id` = ?
Parameters :
[
b"*\x10 ݱ\x17 Oh›ÁÑF—Àl "
b"w¹YÏfÞL\x15 Çù·Ú9‚ó "
]
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = 0x2A10DDB190174F688F9BC1D14697C06C OR `id` = 0x77B959CF66DE4C1590C7F9B7DA3982F3
;
Copy
32
0.13 ms
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
; Copy
33
0.12 ms
SELECT
`theme_id` ,
`technical_name` ,
`resolved_config` ,
`view_inheritance` ,
`script_files` ,
`icon_sets` ,
`updated_at`
FROM `theme_runtime_config`
WHERE `technical_name` = ?
Parameters :
[
"Storefront "
]
SELECT
`theme_id` ,
`technical_name` ,
`resolved_config` ,
`view_inheritance` ,
`script_files` ,
`icon_sets` ,
`updated_at`
FROM `theme_runtime_config`
WHERE `technical_name` = 'Storefront' ; Copy
34
0.13 ms
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1
SELECT `app` . `name` , `app` . `version` , `app` . `template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template` . `app_id` = `app` . `id`
WHERE `app` . `active` = 1 AND `app_template` . `active` = 1 ; Copy
35
0.09 ms
SELECT DISTINCT `technical_name`
FROM `theme_runtime_config`
WHERE `technical_name` IS NOT NULL
SELECT DISTINCT `technical_name`
FROM `theme_runtime_config`
WHERE `technical_name` IS NOT NULL ; Copy
36
0.10 ms
SELECT path FROM category WHERE id = ?
Parameters :
[
b"*\x10 ݱ\x17 Oh›ÁÑF—Àl "
]
SELECT path FROM category WHERE id = 0x2A10DDB190174F688F9BC1D14697C06C ; Copy
37
0.08 ms
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ; Copy
38
0.29 ms
SELECT `media` . `id` as `media.id` , `media` . `user_id` as `media.userId` , `media` . `media_folder_id` as `media.mediaFolderId` , `media` . `mime_type` as `media.mimeType` , `media` . `file_extension` as `media.fileExtension` , `media` . `uploaded_at` as `media.uploadedAt` , `media` . `file_name` as `media.fileName` , `media` . `file_size` as `media.fileSize` , `media` . `media_type` as `media.mediaTypeRaw` , `media` . `meta_data` as `media.metaData` , `media` . `config` as `media.config` , `media` . `path` as `media.path` , `media` . `private` as `media.private` , `media` . `thumbnails_ro` as `media.thumbnailsRo` , `media` . `file_hash` as `media.fileHash` , `media` . `created_at` as `media.createdAt` , `media` . `updated_at` as `media.updatedAt` , `media.translation.title` , `media.translation.title` as `media.title` , `media.translation.alt` , `media.translation.alt` as `media.alt` , `media.translation.customFields` , `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . `media_id` , `media.translation` . `alt` as `media.translation.alt` , `media.translation` . `title` as `media.translation.title` , `media.translation` . `custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation` . `language_id` = ? ) `media.media_translation` ON `media.media_translation` . `media_id` = `media` . `id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder` . `default_folder_id` = `media.mediaFolder.defaultFolder` . `id` WHERE (((`media` . `private` = ? OR (`media` . `private` = ? AND `media.mediaFolder.defaultFolder` . `entity` = ? )))) AND (`media` . `id` IN (? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
false
true
"product_download "
b"\x01 ›1{Aõpµ·ñ:C‹u\x10 È\x01 ›1{AüqU¢Ý}ìë(D} ]
SELECT `media` . `id` as `media.id` , `media` . `user_id` as `media.userId` , `media` . `media_folder_id` as `media.mediaFolderId` , `media` . `mime_type` as `media.mimeType` , `media` . `file_extension` as `media.fileExtension` , `media` . `uploaded_at` as `media.uploadedAt` , `media` . `file_name` as `media.fileName` , `media` . `file_size` as `media.fileSize` , `media` . `media_type` as `media.mediaTypeRaw` , `media` . `meta_data` as `media.metaData` , `media` . `config` as `media.config` , `media` . `path` as `media.path` , `media` . `private` as `media.private` , `media` . `thumbnails_ro` as `media.thumbnailsRo` , `media` . `file_hash` as `media.fileHash` , `media` . `created_at` as `media.createdAt` , `media` . `updated_at` as `media.updatedAt` , `media.translation.title` , `media.translation.title` as `media.title` , `media.translation.alt` , `media.translation.alt` as `media.alt` , `media.translation.customFields` , `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . `media_id` , `media.translation` . `alt` as `media.translation.alt` , `media.translation` . `title` as `media.translation.title` , `media.translation` . `custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `media.media_translation` ON `media.media_translation` . `media_id` = `media` . `id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder` . `default_folder_id` = `media.mediaFolder.defaultFolder` . `id` WHERE (((`media` . `private` = 0 OR (`media` . `private` = 1 AND `media.mediaFolder.defaultFolder` . `entity` = 'product_download' )))) AND (`media` . `id` IN (0x019B317B41F570B5B7F13A438B7510C8 , 0x019B317B41FC7155A2DD7DECEB28447D ));
Copy
39
0.11 ms
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ; Copy
40
0.34 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%*\x10 ݱ\x17 Oh›ÁÑF—Àl "
]
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 (0x2A10DDB190174F688F9BC1D14697C06C )); Copy
41
0.29 ms
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%\x19 Ê@WÿO\x07 ªÈÅ™Ô1xh*\x10 ݱ\x17 Oh›ÁÑF—Àl "
]
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 (0x19CA405790FF4F07AAC8C599D4317868 , 0x2A10DDB190174F688F9BC1D14697C06C ));
Copy
42
2.10 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/2a10ddb190174f688f9bc1d14697c06c "
"/navigation/19ca405790ff4f07aac8c599d4317868 "
"/navigation/e8a8269008a540938b0fe5c9f5ddda80 "
"/navigation/44cf99695e964def895a2f2938c049e9 "
"/navigation/656bf6338d194c4c86f26735fb442233 "
"/navigation/6db7ddbb1c764ed38b1b8718f1e4c6db "
"/navigation/48f97f432fd041388b2630184139cf0e "
"/navigation/bb22b05bff9140f3808b1cff975b75eb "
"/navigation/06f5dda360c04112937601574122c515 "
"/navigation/c3057bb031634c669cd6dfb0d4acbb15 "
"/navigation/e379fcc096f343568dcb1e294d45c931 "
"/detail/cec3a2da193446cbbc9537e38a62cfd8 "
"/detail/affdbebb29f94d198f5f7912c0bdddec "
"/detail/f1e6aa5e0fb74cd4955d7efd55b782b4 "
"/detail/017ef29740244951846d9df7b3f3905e "
"/detail/f2bcd90325c7448baa69623f925b04c7 "
"/detail/1f229703381141b28725b90c61dc0cbd "
"/detail/2926a98b42134b3c9daabfce609616cf "
"/detail/989c8048a841416894a4297b2700a135 "
"/detail/0aa8c46e5061490a8163d6855d67824d "
"/detail/14e9d930c7a9492681ad1d5a82938706 "
"/detail/bb6675d233784cc2a13c4fbceb9ec02a "
"/detail/04c6a031003f4f688d09a56cae9c4870 "
"/detail/850dfe3868a8423a9789046f471c7ccc "
"/detail/046d2662f2bb4e5f82dfe476849ad20b "
"/detail/ba1ac74b9d3f4d6db605ecef34fd06f4 "
"/detail/54ba8154b5864ec591e5b78441fc93f9 "
"/detail/4384016d18aa4d3c9b36beebdacb9a71 "
"/detail/3c1b10d7354e4abdb1112ec0c99b0ce9 "
"/detail/2f0154208bbb4d8580cd066d4bcc52a1 "
"/detail/e3fd5a39ff1543c8996636bb7e6e68b3 "
"/detail/1f10da4b0288448cb95f2f6a1a6dc657 "
"/detail/b7a5ee29248242f9867cc3e8ca012408 "
"/detail/c784b651a260480087d86cd8ef92a9c5 "
"/detail/0e2ceabf580646ce83784393125d47e4 "
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/2a10ddb190174f688f9bc1d14697c06c' , '/navigation/19ca405790ff4f07aac8c599d4317868' , '/navigation/e8a8269008a540938b0fe5c9f5ddda80' , '/navigation/44cf99695e964def895a2f2938c049e9' , '/navigation/656bf6338d194c4c86f26735fb442233' , '/navigation/6db7ddbb1c764ed38b1b8718f1e4c6db' , '/navigation/48f97f432fd041388b2630184139cf0e' , '/navigation/bb22b05bff9140f3808b1cff975b75eb' , '/navigation/06f5dda360c04112937601574122c515' , '/navigation/c3057bb031634c669cd6dfb0d4acbb15' , '/navigation/e379fcc096f343568dcb1e294d45c931' , '/detail/cec3a2da193446cbbc9537e38a62cfd8' , '/detail/affdbebb29f94d198f5f7912c0bdddec' , '/detail/f1e6aa5e0fb74cd4955d7efd55b782b4' , '/detail/017ef29740244951846d9df7b3f3905e' , '/detail/f2bcd90325c7448baa69623f925b04c7' , '/detail/1f229703381141b28725b90c61dc0cbd' , '/detail/2926a98b42134b3c9daabfce609616cf' , '/detail/989c8048a841416894a4297b2700a135' , '/detail/0aa8c46e5061490a8163d6855d67824d' , '/detail/14e9d930c7a9492681ad1d5a82938706' , '/detail/bb6675d233784cc2a13c4fbceb9ec02a' , '/detail/04c6a031003f4f688d09a56cae9c4870' , '/detail/850dfe3868a8423a9789046f471c7ccc' , '/detail/046d2662f2bb4e5f82dfe476849ad20b' , '/detail/ba1ac74b9d3f4d6db605ecef34fd06f4' , '/detail/54ba8154b5864ec591e5b78441fc93f9' , '/detail/4384016d18aa4d3c9b36beebdacb9a71' , '/detail/3c1b10d7354e4abdb1112ec0c99b0ce9' , '/detail/2f0154208bbb4d8580cd066d4bcc52a1' , '/detail/e3fd5a39ff1543c8996636bb7e6e68b3' , '/detail/1f10da4b0288448cb95f2f6a1a6dc657' , '/detail/b7a5ee29248242f9867cc3e8ca012408' , '/detail/c784b651a260480087d86cd8ef92a9c5' , '/detail/0e2ceabf580646ce83784393125d47e4' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0xCD6592C636AE4BF38378B01A9B31E46D OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
43
0.34 ms
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"""
\x17 \n C\x7F 6ø@²—-ûrøæ¿b
"""
b"\x1E ›mÉ\v RG|·'÷ïeÆ]Ö8X•p\x16 dMä®HÀP\v óÌÈ "
b"¸Rs=·eO;‚°T•Ë!ÚW "
b"Ð[4\ÛyIgƒ\x12\x17 [ÄLKL "
b"á7Ž·€ŠG‘ž\r t\r ]l\x1A "
b"ï\x7F Ù.®S@I’\x06 €\x12 ¨.’‹ "
]
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (0x170A437F36F840B2972DFB72F8E6BF62 , 0x1E9B6DC90B52477CB727F7EF65C65DD6 , 0x3858957016644DE4AE48C0500BF3CCC8 , 0xB852733DB7654F3B82B05495CB21DA57 , 0xD05B345CDB7949678312175BC44C4B4C , 0xE1378DB7808A478F919E0D740D5D6C1A , 0xEF7FD92EAE53404992068012A82E928B ); Copy
44
0.12 ms
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"Ow0mf2EJ02sMsd3xtZT3Hp68TpI7Y4ME "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = 'Ow0mf2EJ02sMsd3xtZT3Hp68TpI7Y4ME' ;
Copy