3.48 ms
3
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` . `path` as `category.media.path` , `category.media` . `private` as `category.media.private` , `category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` , `category.media` . `created_at` as `category.media.createdAt` , `category.media` . `updated_at` as `category.media.updatedAt` , `category.media.translation.title` , COALESCE (`category.media.translation.title` , `category.media.translation.title` ) as `category.media.title` , `category.media.translation.alt` , COALESCE (`category.media.translation.alt` , `category.media.translation.alt` ) as `category.media.alt` , `category.media.translation.customFields` , COALESCE (`category.media.translation.customFields` , `category.media.translation.customFields` ) as `category.media.customFields` , `category.media.translation.createdAt` , `category.media.translation.updatedAt` , `category.media.translation.mediaId` , `category.media.translation.languageId` , `category.translation.name` , COALESCE (`category.translation.name` , `category.translation.name` ) as `category.name` , `category.translation.breadcrumb` , COALESCE (`category.translation.breadcrumb` , `category.translation.breadcrumb` ) as `category.breadcrumb` , `category.translation.slotConfig` , COALESCE (`category.translation.slotConfig` , `category.translation.slotConfig` ) as `category.slotConfig` , `category.translation.linkType` , COALESCE (`category.translation.linkType` , `category.translation.linkType` ) as `category.linkType` , `category.translation.internalLink` , COALESCE (`category.translation.internalLink` , `category.translation.internalLink` ) as `category.internalLink` , `category.translation.externalLink` , COALESCE (`category.translation.externalLink` , `category.translation.externalLink` ) as `category.externalLink` , `category.translation.linkNewTab` , COALESCE (`category.translation.linkNewTab` , `category.translation.linkNewTab` ) as `category.linkNewTab` , `category.translation.description` , COALESCE (`category.translation.description` , `category.translation.description` ) as `category.description` , `category.translation.metaTitle` , COALESCE (`category.translation.metaTitle` , `category.translation.metaTitle` ) as `category.metaTitle` , `category.translation.metaDescription` , COALESCE (`category.translation.metaDescription` , `category.translation.metaDescription` ) as `category.metaDescription` , `category.translation.keywords` , COALESCE (`category.translation.keywords` , `category.translation.keywords` ) as `category.keywords` , `category.translation.customFields` , COALESCE (`category.translation.customFields` , `category.translation.customFields` ) as `category.customFields` , `category.translation.createdAt` , `category.translation.updatedAt` , `category.translation.categoryId` , `category.translation.languageId` , `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation` . category_id , `category.translation` . category_version_id , `category.translation` . name as `category.translation.name` , `category.translation` . breadcrumb as `category.translation.breadcrumb` , `category.translation` . slot_config as `category.translation.slotConfig` , `category.translation` . link_type as `category.translation.linkType` , `category.translation` . internal_link as `category.translation.internalLink` , `category.translation` . external_link as `category.translation.externalLink` , `category.translation` . link_new_tab as `category.translation.linkNewTab` , `category.translation` . description as `category.translation.description` , `category.translation` . meta_title as `category.translation.metaTitle` , `category.translation` . meta_description as `category.translation.metaDescription` , `category.translation` . keywords as `category.translation.keywords` , `category.translation` . custom_fields as `category.translation.customFields` , `category.translation` . created_at as `category.translation.createdAt` , `category.translation` . updated_at as `category.translation.updatedAt` , `category.translation` . category_id as `category.translation.categoryId` , `category.translation` . language_id as `category.translation.languageId` , `category.translation` . category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation` . language_id = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . category_version_id = `category` . version_id LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id` LEFT JOIN (SELECT `category.media.translation` . media_id , `category.media.translation` . title as `category.media.translation.title` , `category.media.translation` . alt as `category.media.translation.alt` , `category.media.translation` . custom_fields as `category.media.translation.customFields` , `category.media.translation` . created_at as `category.media.translation.createdAt` , `category.media.translation` . updated_at as `category.media.translation.updatedAt` , `category.media.translation` . media_id as `category.media.translation.mediaId` , `category.media.translation` . language_id as `category.media.translation.languageId` 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` . `path` LIKE ? AND (`category` . `level` > ? AND `category` . `level` < = ? )))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%%|65ffa692fa5948d38e860a5d0b9ca616|% "
1
4
]
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` . `path` as `category.media.path` ,
`category.media` . `private` as `category.media.private` ,
`category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` ,
`category.media` . `created_at` as `category.media.createdAt` ,
`category.media` . `updated_at` as `category.media.updatedAt` ,
`category.media.translation.title` ,
COALESCE (
`category.media.translation.title` ,
`category.media.translation.title`
) as `category.media.title` ,
`category.media.translation.alt` ,
COALESCE (
`category.media.translation.alt` ,
`category.media.translation.alt`
) as `category.media.alt` ,
`category.media.translation.customFields` ,
COALESCE (
`category.media.translation.customFields` ,
`category.media.translation.customFields`
) as `category.media.customFields` ,
`category.media.translation.createdAt` ,
`category.media.translation.updatedAt` ,
`category.media.translation.mediaId` ,
`category.media.translation.languageId` ,
`category.translation.name` ,
COALESCE (
`category.translation.name` , `category.translation.name`
) as `category.name` ,
`category.translation.breadcrumb` ,
COALESCE (
`category.translation.breadcrumb` ,
`category.translation.breadcrumb`
) as `category.breadcrumb` ,
`category.translation.slotConfig` ,
COALESCE (
`category.translation.slotConfig` ,
`category.translation.slotConfig`
) as `category.slotConfig` ,
`category.translation.linkType` ,
COALESCE (
`category.translation.linkType` ,
`category.translation.linkType`
) as `category.linkType` ,
`category.translation.internalLink` ,
COALESCE (
`category.translation.internalLink` ,
`category.translation.internalLink`
) as `category.internalLink` ,
`category.translation.externalLink` ,
COALESCE (
`category.translation.externalLink` ,
`category.translation.externalLink`
) as `category.externalLink` ,
`category.translation.linkNewTab` ,
COALESCE (
`category.translation.linkNewTab` ,
`category.translation.linkNewTab`
) as `category.linkNewTab` ,
`category.translation.description` ,
COALESCE (
`category.translation.description` ,
`category.translation.description`
) as `category.description` ,
`category.translation.metaTitle` ,
COALESCE (
`category.translation.metaTitle` ,
`category.translation.metaTitle`
) as `category.metaTitle` ,
`category.translation.metaDescription` ,
COALESCE (
`category.translation.metaDescription` ,
`category.translation.metaDescription`
) as `category.metaDescription` ,
`category.translation.keywords` ,
COALESCE (
`category.translation.keywords` ,
`category.translation.keywords`
) as `category.keywords` ,
`category.translation.customFields` ,
COALESCE (
`category.translation.customFields` ,
`category.translation.customFields`
) as `category.customFields` ,
`category.translation.createdAt` ,
`category.translation.updatedAt` ,
`category.translation.categoryId` ,
`category.translation.languageId` ,
`category.translation.categoryVersionId`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . category_id ,
`category.translation` . category_version_id ,
`category.translation` . name as `category.translation.name` ,
`category.translation` . breadcrumb as `category.translation.breadcrumb` ,
`category.translation` . slot_config as `category.translation.slotConfig` ,
`category.translation` . link_type as `category.translation.linkType` ,
`category.translation` . internal_link as `category.translation.internalLink` ,
`category.translation` . external_link as `category.translation.externalLink` ,
`category.translation` . link_new_tab as `category.translation.linkNewTab` ,
`category.translation` . description as `category.translation.description` ,
`category.translation` . meta_title as `category.translation.metaTitle` ,
`category.translation` . meta_description as `category.translation.metaDescription` ,
`category.translation` . keywords as `category.translation.keywords` ,
`category.translation` . custom_fields as `category.translation.customFields` ,
`category.translation` . created_at as `category.translation.createdAt` ,
`category.translation` . updated_at as `category.translation.updatedAt` ,
`category.translation` . category_id as `category.translation.categoryId` ,
`category.translation` . language_id as `category.translation.languageId` ,
`category.translation` . category_version_id as `category.translation.categoryVersionId`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . language_id = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . category_version_id = `category` . version_id
LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id`
LEFT JOIN (
SELECT
`category.media.translation` . media_id ,
`category.media.translation` . title as `category.media.translation.title` ,
`category.media.translation` . alt as `category.media.translation.alt` ,
`category.media.translation` . custom_fields as `category.media.translation.customFields` ,
`category.media.translation` . created_at as `category.media.translation.createdAt` ,
`category.media.translation` . updated_at as `category.media.translation.updatedAt` ,
`category.media.translation` . media_id as `category.media.translation.mediaId` ,
`category.media.translation` . language_id as `category.media.translation.languageId`
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` . `path` LIKE ?
AND (
`category` . `level` > ?
AND `category` . `level` < = ?
)
)
)
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` . `path` as `category.media.path` , `category.media` . `private` as `category.media.private` , `category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` , `category.media` . `created_at` as `category.media.createdAt` , `category.media` . `updated_at` as `category.media.updatedAt` , `category.media.translation.title` , COALESCE (`category.media.translation.title` , `category.media.translation.title` ) as `category.media.title` , `category.media.translation.alt` , COALESCE (`category.media.translation.alt` , `category.media.translation.alt` ) as `category.media.alt` , `category.media.translation.customFields` , COALESCE (`category.media.translation.customFields` , `category.media.translation.customFields` ) as `category.media.customFields` , `category.media.translation.createdAt` , `category.media.translation.updatedAt` , `category.media.translation.mediaId` , `category.media.translation.languageId` , `category.translation.name` , COALESCE (`category.translation.name` , `category.translation.name` ) as `category.name` , `category.translation.breadcrumb` , COALESCE (`category.translation.breadcrumb` , `category.translation.breadcrumb` ) as `category.breadcrumb` , `category.translation.slotConfig` , COALESCE (`category.translation.slotConfig` , `category.translation.slotConfig` ) as `category.slotConfig` , `category.translation.linkType` , COALESCE (`category.translation.linkType` , `category.translation.linkType` ) as `category.linkType` , `category.translation.internalLink` , COALESCE (`category.translation.internalLink` , `category.translation.internalLink` ) as `category.internalLink` , `category.translation.externalLink` , COALESCE (`category.translation.externalLink` , `category.translation.externalLink` ) as `category.externalLink` , `category.translation.linkNewTab` , COALESCE (`category.translation.linkNewTab` , `category.translation.linkNewTab` ) as `category.linkNewTab` , `category.translation.description` , COALESCE (`category.translation.description` , `category.translation.description` ) as `category.description` , `category.translation.metaTitle` , COALESCE (`category.translation.metaTitle` , `category.translation.metaTitle` ) as `category.metaTitle` , `category.translation.metaDescription` , COALESCE (`category.translation.metaDescription` , `category.translation.metaDescription` ) as `category.metaDescription` , `category.translation.keywords` , COALESCE (`category.translation.keywords` , `category.translation.keywords` ) as `category.keywords` , `category.translation.customFields` , COALESCE (`category.translation.customFields` , `category.translation.customFields` ) as `category.customFields` , `category.translation.createdAt` , `category.translation.updatedAt` , `category.translation.categoryId` , `category.translation.languageId` , `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation` . category_id , `category.translation` . category_version_id , `category.translation` . name as `category.translation.name` , `category.translation` . breadcrumb as `category.translation.breadcrumb` , `category.translation` . slot_config as `category.translation.slotConfig` , `category.translation` . link_type as `category.translation.linkType` , `category.translation` . internal_link as `category.translation.internalLink` , `category.translation` . external_link as `category.translation.externalLink` , `category.translation` . link_new_tab as `category.translation.linkNewTab` , `category.translation` . description as `category.translation.description` , `category.translation` . meta_title as `category.translation.metaTitle` , `category.translation` . meta_description as `category.translation.metaDescription` , `category.translation` . keywords as `category.translation.keywords` , `category.translation` . custom_fields as `category.translation.customFields` , `category.translation` . created_at as `category.translation.createdAt` , `category.translation` . updated_at as `category.translation.updatedAt` , `category.translation` . category_id as `category.translation.categoryId` , `category.translation` . language_id as `category.translation.languageId` , `category.translation` . category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . category_version_id = `category` . version_id LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id` LEFT JOIN (SELECT `category.media.translation` . media_id , `category.media.translation` . title as `category.media.translation.title` , `category.media.translation` . alt as `category.media.translation.alt` , `category.media.translation` . custom_fields as `category.media.translation.customFields` , `category.media.translation` . created_at as `category.media.translation.createdAt` , `category.media.translation` . updated_at as `category.media.translation.updatedAt` , `category.media.translation` . media_id as `category.media.translation.mediaId` , `category.media.translation` . language_id as `category.media.translation.languageId` 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` . `path` LIKE '%|65ffa692fa5948d38e860a5d0b9ca616|%' AND (`category` . `level` > 1 AND `category` . `level` < = 4 )));
Copy
3.09 ms
1
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/87a3ec3256eb41f9ace249547dfcef3b "
"/navigation/1dfed3c6cf7447c3b2fbbb727233ec42 "
"/navigation/99b4ab4663514a2fa107185212c6be6d "
"/navigation/9b89b1125a414ed185e8446446fe62f0 "
"/navigation/f17c1e6c4f294892a48232e276684bcc "
"/navigation/fc758d60541c4a2fa842bfcef189afdb "
"/navigation/20706be2e6564209a5f96dfdfefe3c41 "
"/navigation/e71499b1e3ba48698fd9655d73f21d82 "
"/navigation/9efa9bc920a94ff4b7d4b68ff7d73924 "
"/navigation/05439f3884b14a279764203298089eb9 "
"/navigation/66072ba9d6b3457e96995316da3e54e6 "
"/navigation/eeae15f7f3474280b0947c73a142be54 "
"/navigation/ae6165470c544a228afd16c5030e0dc5 "
"/navigation/cd3f5925c0a14f8593ded202f5e2a5a2 "
"/navigation/6116ebee1bbc4542993f458c80174469 "
"/navigation/515e1bf91c6a4818ba53f6b5827cfd65 "
"/navigation/36de3a4961a24211800df974d5ff72a6 "
"/navigation/e1f6b322018e4e9d84f9ed2f85767896 "
"/navigation/e5213e9371774235ae06c93c22a000ae "
"/navigation/c51c7ef9c59645d8bbc3d3aa4e3eef34 "
"/navigation/0333d3adc6074d778dbfa42c2b723169 "
"/navigation/4bb1b32859b541d3b381733a65f50980 "
"/navigation/8a0c152a4f7f4e608162fa56a97a8342 "
"/navigation/3973b1fb4bf7475aa31ba3c62b729009 "
"/navigation/57f7743d2a9e4ca1b11b3660d6c7c8e7 "
"/navigation/cf903bac24d946b99b4e3c6a159c8993 "
"/navigation/276943771ade48c3a67a18207bd09120 "
"/navigation/08e950a7758948319714a98717a0e007 "
"/navigation/2385082b7f8a4485925a67789dcf9b45 "
"/navigation/e1086d4b386a4f9fa1f7cdd21476e537 "
"/navigation/104be0736d774811a00efa505e7e9911 "
"/navigation/18aed17be1cf45da9e66fe80775f02ad "
"/navigation/d20579476ca349d6afcc19b3aa7b4f5f "
"/navigation/faf838071a6b4266b210b261810feb8a "
"/navigation/cf7d5bccca23460c9c20d56fc0e19bdf "
"/navigation/8acd406b0530487d908cca4369d581dc "
"/navigation/5e021b1c7d194666a58c477c94242515 "
"/navigation/66240e168d35432b881544a6db408430 "
"/navigation/8a24986c0c074e089f36614a89122cb9 "
"/navigation/2c7138dabd4e47cd93b9386eba5de33c "
"/navigation/6cc4f1f2c8e645e5afbac8e9590f9928 "
"/navigation/f37e224f77c648adac7fd6af01504f2d "
"/navigation/010e18491ce74e9786e61a0899a1be27 "
"/navigation/8e8a4a2e754c4e6f874ffedb228e6b32 "
"/navigation/c06db403d2b04640abbc0e5ec95353c8 "
"/navigation/1921c6b504914df4925b6fbfc231a070 "
"/navigation/77200ecc0c0c4290841b311c311882cd "
"/navigation/32868793c48747cc88e70344707f8d53 "
"/navigation/5cba10f5367d488687b7b69c62220105 "
"/navigation/a2b7ce270aa24e5793165a43be5a166c "
"/navigation/d1a63accb74241e09b312d6a6e48e412 "
"/navigation/94352f8de2a44e9d98d880cfe1cb7602 "
"/navigation/e186f15804e04848b51d02b48dddbcfe "
"/navigation/86b360a63c3a4d34a386421620b3445c "
"/navigation/b7f37e8da93641be97d1e2e6da766fa3 "
"/navigation/66e112fbcb9f447a9cad68ef3411f5ec "
"/navigation/184173e9f71341d7b30849c08422107a "
"/navigation/ac06a46b04694ac4bfde9175d8e4b902 "
"/navigation/5c069abb486744f8a207400992e4fd30 "
"/navigation/261cc411a2bf44b79e354c2959b8fd2f "
"/navigation/f2844e1605cf48d4b15cc9a9d130adc4 "
"/navigation/a6744346d54541ec8d311f01820b674e "
"/navigation/2ba53f37600a46fe89dc2bc8e5e2f53f "
"/navigation/cde8c061297a4e7086a435b7fabfbf5e "
"/navigation/5b38a8e7922e47878a7098c9f61e4e56 "
"/navigation/7ee1a3f9e34545ad98a0dccde9ef4675 "
"/account/recover "
"/navigation/421f8eb4e2164a888fb8600ad3b0f3fd "
"/navigation/b4161334350c4caca51e0027a402c259 "
"/navigation/9409d49c881942268970334f2be6c88e "
"/navigation/6a1a533691b642459404af2ee33a6fc5 "
"/navigation/f4342aa3dcca44988f786f96cd46a2e1 "
"/navigation/07b412891de9469394071951890b35e4 "
"/navigation/6c75952f25b7409684b1fb2ede5c2cf2 "
"/navigation/cff0ab2034f24b289295a72ae3e2cb63 "
"/navigation/702224a30beb4257b51b0790c9df61bb "
"/navigation/cca5f3eb30754b7fb29f53c426835c33 "
"/navigation/953b8f48e02a4685b9c030d37759f894 "
"/navigation/34a54000706f4c829c4c54d43e41db4b "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
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 )
Copy
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/87a3ec3256eb41f9ace249547dfcef3b' , '/navigation/1dfed3c6cf7447c3b2fbbb727233ec42' , '/navigation/99b4ab4663514a2fa107185212c6be6d' , '/navigation/9b89b1125a414ed185e8446446fe62f0' , '/navigation/f17c1e6c4f294892a48232e276684bcc' , '/navigation/fc758d60541c4a2fa842bfcef189afdb' , '/navigation/20706be2e6564209a5f96dfdfefe3c41' , '/navigation/e71499b1e3ba48698fd9655d73f21d82' , '/navigation/9efa9bc920a94ff4b7d4b68ff7d73924' , '/navigation/05439f3884b14a279764203298089eb9' , '/navigation/66072ba9d6b3457e96995316da3e54e6' , '/navigation/eeae15f7f3474280b0947c73a142be54' , '/navigation/ae6165470c544a228afd16c5030e0dc5' , '/navigation/cd3f5925c0a14f8593ded202f5e2a5a2' , '/navigation/6116ebee1bbc4542993f458c80174469' , '/navigation/515e1bf91c6a4818ba53f6b5827cfd65' , '/navigation/36de3a4961a24211800df974d5ff72a6' , '/navigation/e1f6b322018e4e9d84f9ed2f85767896' , '/navigation/e5213e9371774235ae06c93c22a000ae' , '/navigation/c51c7ef9c59645d8bbc3d3aa4e3eef34' , '/navigation/0333d3adc6074d778dbfa42c2b723169' , '/navigation/4bb1b32859b541d3b381733a65f50980' , '/navigation/8a0c152a4f7f4e608162fa56a97a8342' , '/navigation/3973b1fb4bf7475aa31ba3c62b729009' , '/navigation/57f7743d2a9e4ca1b11b3660d6c7c8e7' , '/navigation/cf903bac24d946b99b4e3c6a159c8993' , '/navigation/276943771ade48c3a67a18207bd09120' , '/navigation/08e950a7758948319714a98717a0e007' , '/navigation/2385082b7f8a4485925a67789dcf9b45' , '/navigation/e1086d4b386a4f9fa1f7cdd21476e537' , '/navigation/104be0736d774811a00efa505e7e9911' , '/navigation/18aed17be1cf45da9e66fe80775f02ad' , '/navigation/d20579476ca349d6afcc19b3aa7b4f5f' , '/navigation/faf838071a6b4266b210b261810feb8a' , '/navigation/cf7d5bccca23460c9c20d56fc0e19bdf' , '/navigation/8acd406b0530487d908cca4369d581dc' , '/navigation/5e021b1c7d194666a58c477c94242515' , '/navigation/66240e168d35432b881544a6db408430' , '/navigation/8a24986c0c074e089f36614a89122cb9' , '/navigation/2c7138dabd4e47cd93b9386eba5de33c' , '/navigation/6cc4f1f2c8e645e5afbac8e9590f9928' , '/navigation/f37e224f77c648adac7fd6af01504f2d' , '/navigation/010e18491ce74e9786e61a0899a1be27' , '/navigation/8e8a4a2e754c4e6f874ffedb228e6b32' , '/navigation/c06db403d2b04640abbc0e5ec95353c8' , '/navigation/1921c6b504914df4925b6fbfc231a070' , '/navigation/77200ecc0c0c4290841b311c311882cd' , '/navigation/32868793c48747cc88e70344707f8d53' , '/navigation/5cba10f5367d488687b7b69c62220105' , '/navigation/a2b7ce270aa24e5793165a43be5a166c' , '/navigation/d1a63accb74241e09b312d6a6e48e412' , '/navigation/94352f8de2a44e9d98d880cfe1cb7602' , '/navigation/e186f15804e04848b51d02b48dddbcfe' , '/navigation/86b360a63c3a4d34a386421620b3445c' , '/navigation/b7f37e8da93641be97d1e2e6da766fa3' , '/navigation/66e112fbcb9f447a9cad68ef3411f5ec' , '/navigation/184173e9f71341d7b30849c08422107a' , '/navigation/ac06a46b04694ac4bfde9175d8e4b902' , '/navigation/5c069abb486744f8a207400992e4fd30' , '/navigation/261cc411a2bf44b79e354c2959b8fd2f' , '/navigation/f2844e1605cf48d4b15cc9a9d130adc4' , '/navigation/a6744346d54541ec8d311f01820b674e' , '/navigation/2ba53f37600a46fe89dc2bc8e5e2f53f' , '/navigation/cde8c061297a4e7086a435b7fabfbf5e' , '/navigation/5b38a8e7922e47878a7098c9f61e4e56' , '/navigation/7ee1a3f9e34545ad98a0dccde9ef4675' , '/account/recover' , '/navigation/421f8eb4e2164a888fb8600ad3b0f3fd' , '/navigation/b4161334350c4caca51e0027a402c259' , '/navigation/9409d49c881942268970334f2be6c88e' , '/navigation/6a1a533691b642459404af2ee33a6fc5' , '/navigation/f4342aa3dcca44988f786f96cd46a2e1' , '/navigation/07b412891de9469394071951890b35e4' , '/navigation/6c75952f25b7409684b1fb2ede5c2cf2' , '/navigation/cff0ab2034f24b289295a72ae3e2cb63' , '/navigation/702224a30beb4257b51b0790c9df61bb' , '/navigation/cca5f3eb30754b7fb29f53c426835c33' , '/navigation/953b8f48e02a4685b9c030d37759f894' , '/navigation/34a54000706f4c829c4c54d43e41db4b' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0x2F9B056E1C484931A120DFE36BF5AA13 OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
2.69 ms
5
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS scriptName ,
`script` . `script` AS script ,
`script` . `hook` AS hook ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
`app` . `version` AS appVersion ,
`script` . `active` AS active
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` ! = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS scriptName ,
`script` . `script` AS script ,
`script` . `hook` AS hook ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
`app` . `version` AS appVersion ,
`script` . `active` AS active
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` ! = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
; Copy
2.43 ms
5
SELECT `app` . `id` as `app.id` , `app` . `name` as `app.name` , `app` . `path` as `app.path` , `app` . `author` as `app.author` , `app` . `copyright` as `app.copyright` , `app` . `license` as `app.license` , `app` . `active` as `app.active` , `app` . `configurable` as `app.configurable` , `app` . `privacy` as `app.privacy` , `app` . `version` as `app.version` , `app` . `icon` as `app.iconRaw` , `app` . `app_secret` as `app.appSecret` , `app` . `modules` as `app.modules` , `app` . `main_module` as `app.mainModule` , `app` . `cookies` as `app.cookies` , `app` . `allow_disable` as `app.allowDisable` , `app` . `base_app_url` as `app.baseAppUrl` , `app` . `allowed_hosts` as `app.allowedHosts` , `app` . `template_load_priority` as `app.templateLoadPriority` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `write_access` as `app.integration.writeAccess` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = ? ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE (`app` . `active` = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
]
SELECT
`app` . `id` as `app.id` ,
`app` . `name` as `app.name` ,
`app` . `path` as `app.path` ,
`app` . `author` as `app.author` ,
`app` . `copyright` as `app.copyright` ,
`app` . `license` as `app.license` ,
`app` . `active` as `app.active` ,
`app` . `configurable` as `app.configurable` ,
`app` . `privacy` as `app.privacy` ,
`app` . `version` as `app.version` ,
`app` . `icon` as `app.iconRaw` ,
`app` . `app_secret` as `app.appSecret` ,
`app` . `modules` as `app.modules` ,
`app` . `main_module` as `app.mainModule` ,
`app` . `cookies` as `app.cookies` ,
`app` . `allow_disable` as `app.allowDisable` ,
`app` . `base_app_url` as `app.baseAppUrl` ,
`app` . `allowed_hosts` as `app.allowedHosts` ,
`app` . `template_load_priority` as `app.templateLoadPriority` ,
`app` . `integration_id` as `app.integrationId` ,
`app.integration` . `id` as `app.integration.id` ,
`app.integration` . `label` as `app.integration.label` ,
`app.integration` . `access_key` as `app.integration.accessKey` ,
`app.integration` . `secret_access_key` as `app.integration.secretAccessKey` ,
`app.integration` . `last_usage_at` as `app.integration.lastUsageAt` ,
`app.integration` . `admin` as `app.integration.admin` ,
`app.integration` . `custom_fields` as `app.integration.customFields` ,
`app.integration` . `deleted_at` as `app.integration.deletedAt` ,
`app.integration` . `write_access` as `app.integration.writeAccess` ,
`app.integration` . `created_at` as `app.integration.createdAt` ,
`app.integration` . `updated_at` as `app.integration.updatedAt` ,
`app` . `acl_role_id` as `app.aclRoleId` ,
`app.aclRole` . `id` as `app.aclRole.id` ,
`app.aclRole` . `name` as `app.aclRole.name` ,
`app.aclRole` . `description` as `app.aclRole.description` ,
`app.aclRole` . `privileges` as `app.aclRole.privileges` ,
`app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` ,
`app.aclRole` . `created_at` as `app.aclRole.createdAt` ,
`app.aclRole` . `updated_at` as `app.aclRole.updatedAt` ,
`app` . `created_at` as `app.createdAt` ,
`app` . `updated_at` as `app.updatedAt` ,
`app.translation.label` ,
COALESCE (
`app.translation.label` , `app.translation.label`
) as `app.label` ,
`app.translation.description` ,
COALESCE (
`app.translation.description` , `app.translation.description`
) as `app.description` ,
`app.translation.privacyPolicyExtensions` ,
COALESCE (
`app.translation.privacyPolicyExtensions` ,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions` ,
`app.translation.customFields` ,
COALESCE (
`app.translation.customFields` ,
`app.translation.customFields`
) as `app.customFields` ,
`app.translation.createdAt` ,
`app.translation.updatedAt` ,
`app.translation.appId` ,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation` . app_id ,
`app.translation` . label as `app.translation.label` ,
`app.translation` . description as `app.translation.description` ,
`app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` ,
`app.translation` . custom_fields as `app.translation.customFields` ,
`app.translation` . created_at as `app.translation.createdAt` ,
`app.translation` . updated_at as `app.translation.updatedAt` ,
`app.translation` . app_id as `app.translation.appId` ,
`app.translation` . language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation` . language_id = ?
) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id`
LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id`
LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id`
WHERE
(`app` . `active` = ? )
Copy
SELECT `app` . `id` as `app.id` , `app` . `name` as `app.name` , `app` . `path` as `app.path` , `app` . `author` as `app.author` , `app` . `copyright` as `app.copyright` , `app` . `license` as `app.license` , `app` . `active` as `app.active` , `app` . `configurable` as `app.configurable` , `app` . `privacy` as `app.privacy` , `app` . `version` as `app.version` , `app` . `icon` as `app.iconRaw` , `app` . `app_secret` as `app.appSecret` , `app` . `modules` as `app.modules` , `app` . `main_module` as `app.mainModule` , `app` . `cookies` as `app.cookies` , `app` . `allow_disable` as `app.allowDisable` , `app` . `base_app_url` as `app.baseAppUrl` , `app` . `allowed_hosts` as `app.allowedHosts` , `app` . `template_load_priority` as `app.templateLoadPriority` , `app` . `integration_id` as `app.integrationId` , `app.integration` . `id` as `app.integration.id` , `app.integration` . `label` as `app.integration.label` , `app.integration` . `access_key` as `app.integration.accessKey` , `app.integration` . `secret_access_key` as `app.integration.secretAccessKey` , `app.integration` . `last_usage_at` as `app.integration.lastUsageAt` , `app.integration` . `admin` as `app.integration.admin` , `app.integration` . `custom_fields` as `app.integration.customFields` , `app.integration` . `deleted_at` as `app.integration.deletedAt` , `app.integration` . `write_access` as `app.integration.writeAccess` , `app.integration` . `created_at` as `app.integration.createdAt` , `app.integration` . `updated_at` as `app.integration.updatedAt` , `app` . `acl_role_id` as `app.aclRoleId` , `app.aclRole` . `id` as `app.aclRole.id` , `app.aclRole` . `name` as `app.aclRole.name` , `app.aclRole` . `description` as `app.aclRole.description` , `app.aclRole` . `privileges` as `app.aclRole.privileges` , `app.aclRole` . `deleted_at` as `app.aclRole.deletedAt` , `app.aclRole` . `created_at` as `app.aclRole.createdAt` , `app.aclRole` . `updated_at` as `app.aclRole.updatedAt` , `app` . `created_at` as `app.createdAt` , `app` . `updated_at` as `app.updatedAt` , `app.translation.label` , COALESCE (`app.translation.label` , `app.translation.label` ) as `app.label` , `app.translation.description` , COALESCE (`app.translation.description` , `app.translation.description` ) as `app.description` , `app.translation.privacyPolicyExtensions` , COALESCE (`app.translation.privacyPolicyExtensions` , `app.translation.privacyPolicyExtensions` ) as `app.privacyPolicyExtensions` , `app.translation.customFields` , COALESCE (`app.translation.customFields` , `app.translation.customFields` ) as `app.customFields` , `app.translation.createdAt` , `app.translation.updatedAt` , `app.translation.appId` , `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation` . app_id , `app.translation` . label as `app.translation.label` , `app.translation` . description as `app.translation.description` , `app.translation` . privacy_policy_extensions as `app.translation.privacyPolicyExtensions` , `app.translation` . custom_fields as `app.translation.customFields` , `app.translation` . created_at as `app.translation.createdAt` , `app.translation` . updated_at as `app.translation.updatedAt` , `app.translation` . app_id as `app.translation.appId` , `app.translation` . language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `app.app_translation` ON `app.app_translation` . `app_id` = `app` . `id` LEFT JOIN `integration` `app.integration` ON `app` . `integration_id` = `app.integration` . `id` LEFT JOIN `acl_role` `app.aclRole` ON `app` . `acl_role_id` = `app.aclRole` . `id` WHERE (`app` . `active` = 1 );
Copy
2.24 ms
3
SELECT LOWER (HEX (`category` . `parent_id` )) as `category-ids.key` , COUNT (`category` . `id` ) as `category-ids.count` , COUNT (DISTINCT `category` . `id` ) as `visible-children-count` FROM `category` WHERE (`category` . `version_id` = ? ) AND ((`category` . `path` LIKE ? AND `category` . `level` = ? AND `category` . `active` = ? AND `category` . `visible` = ? )) GROUP BY `category` . `parent_id`
Parameters :
[
b"\x0F ©\x1C ãéjK¾KÙÎu,4%%|65ffa692fa5948d38e860a5d0b9ca616|% "
4
true
true
]
SELECT LOWER (HEX (`category` . `parent_id` )) as `category-ids.key` , COUNT (`category` . `id` ) as `category-ids.count` , COUNT (DISTINCT `category` . `id` ) as `visible-children-count` FROM `category` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND ((`category` . `path` LIKE '%|65ffa692fa5948d38e860a5d0b9ca616|%' AND `category` . `level` = 4 AND `category` . `active` = 1 AND `category` . `visible` = 1 )) GROUP BY `category` . `parent_id` ; Copy
2.19 ms
5
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS name ,
`script` . `script` AS script ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
SELECT LOWER (HEX (`script` . `app_id` )) as `app_id` ,
`script` . `name` AS name ,
`script` . `script` AS script ,
`app` . `name` AS appName ,
LOWER (HEX (`app` . `integration_id` )) AS integrationId ,
IFNULL (`script` . `updated_at` , `script` . `created_at` ) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script` . `app_id` = `app` . `id`
WHERE `script` . `hook` = 'include'
ORDER BY `app` . `created_at` , `app` . `id` , `script` . `name`
; Copy
1.77 ms
3
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` . `path` as `category.media.path` , `category.media` . `private` as `category.media.private` , `category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` , `category.media` . `created_at` as `category.media.createdAt` , `category.media` . `updated_at` as `category.media.updatedAt` , `category.media.translation.title` , COALESCE (`category.media.translation.title` , `category.media.translation.title` ) as `category.media.title` , `category.media.translation.alt` , COALESCE (`category.media.translation.alt` , `category.media.translation.alt` ) as `category.media.alt` , `category.media.translation.customFields` , COALESCE (`category.media.translation.customFields` , `category.media.translation.customFields` ) as `category.media.customFields` , `category.media.translation.createdAt` , `category.media.translation.updatedAt` , `category.media.translation.mediaId` , `category.media.translation.languageId` , `category.translation.name` , COALESCE (`category.translation.name` , `category.translation.name` ) as `category.name` , `category.translation.breadcrumb` , COALESCE (`category.translation.breadcrumb` , `category.translation.breadcrumb` ) as `category.breadcrumb` , `category.translation.slotConfig` , COALESCE (`category.translation.slotConfig` , `category.translation.slotConfig` ) as `category.slotConfig` , `category.translation.linkType` , COALESCE (`category.translation.linkType` , `category.translation.linkType` ) as `category.linkType` , `category.translation.internalLink` , COALESCE (`category.translation.internalLink` , `category.translation.internalLink` ) as `category.internalLink` , `category.translation.externalLink` , COALESCE (`category.translation.externalLink` , `category.translation.externalLink` ) as `category.externalLink` , `category.translation.linkNewTab` , COALESCE (`category.translation.linkNewTab` , `category.translation.linkNewTab` ) as `category.linkNewTab` , `category.translation.description` , COALESCE (`category.translation.description` , `category.translation.description` ) as `category.description` , `category.translation.metaTitle` , COALESCE (`category.translation.metaTitle` , `category.translation.metaTitle` ) as `category.metaTitle` , `category.translation.metaDescription` , COALESCE (`category.translation.metaDescription` , `category.translation.metaDescription` ) as `category.metaDescription` , `category.translation.keywords` , COALESCE (`category.translation.keywords` , `category.translation.keywords` ) as `category.keywords` , `category.translation.customFields` , COALESCE (`category.translation.customFields` , `category.translation.customFields` ) as `category.customFields` , `category.translation.createdAt` , `category.translation.updatedAt` , `category.translation.categoryId` , `category.translation.languageId` , `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation` . category_id , `category.translation` . category_version_id , `category.translation` . name as `category.translation.name` , `category.translation` . breadcrumb as `category.translation.breadcrumb` , `category.translation` . slot_config as `category.translation.slotConfig` , `category.translation` . link_type as `category.translation.linkType` , `category.translation` . internal_link as `category.translation.internalLink` , `category.translation` . external_link as `category.translation.externalLink` , `category.translation` . link_new_tab as `category.translation.linkNewTab` , `category.translation` . description as `category.translation.description` , `category.translation` . meta_title as `category.translation.metaTitle` , `category.translation` . meta_description as `category.translation.metaDescription` , `category.translation` . keywords as `category.translation.keywords` , `category.translation` . custom_fields as `category.translation.customFields` , `category.translation` . created_at as `category.translation.createdAt` , `category.translation` . updated_at as `category.translation.updatedAt` , `category.translation` . category_id as `category.translation.categoryId` , `category.translation` . language_id as `category.translation.languageId` , `category.translation` . category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation` . language_id = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . category_version_id = `category` . version_id LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id` LEFT JOIN (SELECT `category.media.translation` . media_id , `category.media.translation` . title as `category.media.translation.title` , `category.media.translation` . alt as `category.media.translation.alt` , `category.media.translation` . custom_fields as `category.media.translation.customFields` , `category.media.translation` . created_at as `category.media.translation.createdAt` , `category.media.translation` . updated_at as `category.media.translation.updatedAt` , `category.media.translation` . media_id as `category.media.translation.mediaId` , `category.media.translation` . language_id as `category.media.translation.languageId` 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%eÿ¦’úYHÓŽ†\n
]\v œ¦\x16
"""
]
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` . `path` as `category.media.path` ,
`category.media` . `private` as `category.media.private` ,
`category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` ,
`category.media` . `created_at` as `category.media.createdAt` ,
`category.media` . `updated_at` as `category.media.updatedAt` ,
`category.media.translation.title` ,
COALESCE (
`category.media.translation.title` ,
`category.media.translation.title`
) as `category.media.title` ,
`category.media.translation.alt` ,
COALESCE (
`category.media.translation.alt` ,
`category.media.translation.alt`
) as `category.media.alt` ,
`category.media.translation.customFields` ,
COALESCE (
`category.media.translation.customFields` ,
`category.media.translation.customFields`
) as `category.media.customFields` ,
`category.media.translation.createdAt` ,
`category.media.translation.updatedAt` ,
`category.media.translation.mediaId` ,
`category.media.translation.languageId` ,
`category.translation.name` ,
COALESCE (
`category.translation.name` , `category.translation.name`
) as `category.name` ,
`category.translation.breadcrumb` ,
COALESCE (
`category.translation.breadcrumb` ,
`category.translation.breadcrumb`
) as `category.breadcrumb` ,
`category.translation.slotConfig` ,
COALESCE (
`category.translation.slotConfig` ,
`category.translation.slotConfig`
) as `category.slotConfig` ,
`category.translation.linkType` ,
COALESCE (
`category.translation.linkType` ,
`category.translation.linkType`
) as `category.linkType` ,
`category.translation.internalLink` ,
COALESCE (
`category.translation.internalLink` ,
`category.translation.internalLink`
) as `category.internalLink` ,
`category.translation.externalLink` ,
COALESCE (
`category.translation.externalLink` ,
`category.translation.externalLink`
) as `category.externalLink` ,
`category.translation.linkNewTab` ,
COALESCE (
`category.translation.linkNewTab` ,
`category.translation.linkNewTab`
) as `category.linkNewTab` ,
`category.translation.description` ,
COALESCE (
`category.translation.description` ,
`category.translation.description`
) as `category.description` ,
`category.translation.metaTitle` ,
COALESCE (
`category.translation.metaTitle` ,
`category.translation.metaTitle`
) as `category.metaTitle` ,
`category.translation.metaDescription` ,
COALESCE (
`category.translation.metaDescription` ,
`category.translation.metaDescription`
) as `category.metaDescription` ,
`category.translation.keywords` ,
COALESCE (
`category.translation.keywords` ,
`category.translation.keywords`
) as `category.keywords` ,
`category.translation.customFields` ,
COALESCE (
`category.translation.customFields` ,
`category.translation.customFields`
) as `category.customFields` ,
`category.translation.createdAt` ,
`category.translation.updatedAt` ,
`category.translation.categoryId` ,
`category.translation.languageId` ,
`category.translation.categoryVersionId`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . category_id ,
`category.translation` . category_version_id ,
`category.translation` . name as `category.translation.name` ,
`category.translation` . breadcrumb as `category.translation.breadcrumb` ,
`category.translation` . slot_config as `category.translation.slotConfig` ,
`category.translation` . link_type as `category.translation.linkType` ,
`category.translation` . internal_link as `category.translation.internalLink` ,
`category.translation` . external_link as `category.translation.externalLink` ,
`category.translation` . link_new_tab as `category.translation.linkNewTab` ,
`category.translation` . description as `category.translation.description` ,
`category.translation` . meta_title as `category.translation.metaTitle` ,
`category.translation` . meta_description as `category.translation.metaDescription` ,
`category.translation` . keywords as `category.translation.keywords` ,
`category.translation` . custom_fields as `category.translation.customFields` ,
`category.translation` . created_at as `category.translation.createdAt` ,
`category.translation` . updated_at as `category.translation.updatedAt` ,
`category.translation` . category_id as `category.translation.categoryId` ,
`category.translation` . language_id as `category.translation.languageId` ,
`category.translation` . category_version_id as `category.translation.categoryVersionId`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . language_id = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . category_version_id = `category` . version_id
LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id`
LEFT JOIN (
SELECT
`category.media.translation` . media_id ,
`category.media.translation` . title as `category.media.translation.title` ,
`category.media.translation` . alt as `category.media.translation.alt` ,
`category.media.translation` . custom_fields as `category.media.translation.customFields` ,
`category.media.translation` . created_at as `category.media.translation.createdAt` ,
`category.media.translation` . updated_at as `category.media.translation.updatedAt` ,
`category.media.translation` . media_id as `category.media.translation.mediaId` ,
`category.media.translation` . language_id as `category.media.translation.languageId`
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` . `path` as `category.media.path` , `category.media` . `private` as `category.media.private` , `category.media` . `thumbnails_ro` as `category.media.thumbnailsRo` , `category.media` . `created_at` as `category.media.createdAt` , `category.media` . `updated_at` as `category.media.updatedAt` , `category.media.translation.title` , COALESCE (`category.media.translation.title` , `category.media.translation.title` ) as `category.media.title` , `category.media.translation.alt` , COALESCE (`category.media.translation.alt` , `category.media.translation.alt` ) as `category.media.alt` , `category.media.translation.customFields` , COALESCE (`category.media.translation.customFields` , `category.media.translation.customFields` ) as `category.media.customFields` , `category.media.translation.createdAt` , `category.media.translation.updatedAt` , `category.media.translation.mediaId` , `category.media.translation.languageId` , `category.translation.name` , COALESCE (`category.translation.name` , `category.translation.name` ) as `category.name` , `category.translation.breadcrumb` , COALESCE (`category.translation.breadcrumb` , `category.translation.breadcrumb` ) as `category.breadcrumb` , `category.translation.slotConfig` , COALESCE (`category.translation.slotConfig` , `category.translation.slotConfig` ) as `category.slotConfig` , `category.translation.linkType` , COALESCE (`category.translation.linkType` , `category.translation.linkType` ) as `category.linkType` , `category.translation.internalLink` , COALESCE (`category.translation.internalLink` , `category.translation.internalLink` ) as `category.internalLink` , `category.translation.externalLink` , COALESCE (`category.translation.externalLink` , `category.translation.externalLink` ) as `category.externalLink` , `category.translation.linkNewTab` , COALESCE (`category.translation.linkNewTab` , `category.translation.linkNewTab` ) as `category.linkNewTab` , `category.translation.description` , COALESCE (`category.translation.description` , `category.translation.description` ) as `category.description` , `category.translation.metaTitle` , COALESCE (`category.translation.metaTitle` , `category.translation.metaTitle` ) as `category.metaTitle` , `category.translation.metaDescription` , COALESCE (`category.translation.metaDescription` , `category.translation.metaDescription` ) as `category.metaDescription` , `category.translation.keywords` , COALESCE (`category.translation.keywords` , `category.translation.keywords` ) as `category.keywords` , `category.translation.customFields` , COALESCE (`category.translation.customFields` , `category.translation.customFields` ) as `category.customFields` , `category.translation.createdAt` , `category.translation.updatedAt` , `category.translation.categoryId` , `category.translation.languageId` , `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation` . category_id , `category.translation` . category_version_id , `category.translation` . name as `category.translation.name` , `category.translation` . breadcrumb as `category.translation.breadcrumb` , `category.translation` . slot_config as `category.translation.slotConfig` , `category.translation` . link_type as `category.translation.linkType` , `category.translation` . internal_link as `category.translation.internalLink` , `category.translation` . external_link as `category.translation.externalLink` , `category.translation` . link_new_tab as `category.translation.linkNewTab` , `category.translation` . description as `category.translation.description` , `category.translation` . meta_title as `category.translation.metaTitle` , `category.translation` . meta_description as `category.translation.metaDescription` , `category.translation` . keywords as `category.translation.keywords` , `category.translation` . custom_fields as `category.translation.customFields` , `category.translation` . created_at as `category.translation.createdAt` , `category.translation` . updated_at as `category.translation.updatedAt` , `category.translation` . category_id as `category.translation.categoryId` , `category.translation` . language_id as `category.translation.languageId` , `category.translation` . category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . category_version_id = `category` . version_id LEFT JOIN `media` `category.media` ON `category` . `media_id` = `category.media` . `id` LEFT JOIN (SELECT `category.media.translation` . media_id , `category.media.translation` . title as `category.media.translation.title` , `category.media.translation` . alt as `category.media.translation.alt` , `category.media.translation` . custom_fields as `category.media.translation.customFields` , `category.media.translation` . created_at as `category.media.translation.createdAt` , `category.media.translation` . updated_at as `category.media.translation.updatedAt` , `category.media.translation` . media_id as `category.media.translation.mediaId` , `category.media.translation` . language_id as `category.media.translation.languageId` 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 (0x65FFA692FA5948D38E860A5D0B9CA616 ));
Copy
1.03 ms
1
SELECT `country_state` . `id` as `country_state.id` , `country_state` . `country_id` as `country_state.countryId` , `country_state` . `short_code` as `country_state.shortCode` , `country_state` . `position` as `country_state.position` , `country_state` . `active` as `country_state.active` , `country_state` . `created_at` as `country_state.createdAt` , `country_state` . `updated_at` as `country_state.updatedAt` , `country_state.translation.name` , COALESCE (`country_state.translation.name` , `country_state.translation.name` ) as `country_state.name` , `country_state.translation.customFields` , COALESCE (`country_state.translation.customFields` , `country_state.translation.customFields` ) as `country_state.customFields` , `country_state.translation.createdAt` , `country_state.translation.updatedAt` , `country_state.translation.countryStateId` , `country_state.translation.languageId` FROM `country_state` LEFT JOIN `country` `country_state.country` ON `country_state` . `country_id` = `country_state.country` . `id` LEFT JOIN (SELECT `country_state.translation` . country_state_id , `country_state.translation` . name as `country_state.translation.name` , `country_state.translation` . custom_fields as `country_state.translation.customFields` , `country_state.translation` . created_at as `country_state.translation.createdAt` , `country_state.translation` . updated_at as `country_state.translation.updatedAt` , `country_state.translation` . country_state_id as `country_state.translation.countryStateId` , `country_state.translation` . language_id as `country_state.translation.languageId` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation` . language_id = ? ) `country_state.country_state_translation` ON `country_state.country_state_translation` . `country_state_id` = `country_state` . `id` LEFT JOIN `sales_channel_country` `country_state.country.salesChannels.mapping` ON `country_state.country` . `id` = `country_state.country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country_state.country.salesChannels` ON `country_state.country.salesChannels.mapping` . `sales_channel_id` = `country_state.country.salesChannels` . `id` WHERE (`country_state.country.salesChannels` . `id` = ? AND `country_state` . `country_id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
b"\x06 I\x11 IñTJ`ì `\x1C ¼Õ$\x0E \x07 ÓfxIV@¹§RÙ¸‰áHª\x12 c╠+Ë7C4┐·½└}╠°Ø\x18 %²╚hí@ØÜ<9m└í?\x18 \x1A …»Üš·KY¯wª¿\e ÒÓQ\e ~uú&ñKö„T9Øy\t M±\x1E Øàb?░N\f øú'[zFéó&ej\x17 É\x04 IPº‡oêÄpÓ» "
b"+┤À²µYD\x18 æ═¢█\x02 Sì& "
b"/\x03\x07\x7F rPJ‘£šh9\x13 Göf "
b"7]ÆZ‚rOn£º1\x07 ÃgY\x06 "
b"Bk\x08 G®ÌB%´›%K1 ž\x02 "
b"""
R\n
ø▒MLEËÅÖø┌>Égf
"""
b"uÔ\x19 ┐╝LIJüª\x1A ág┬w; "
b"y\x01 +µ0†HV„©LP±à•G "
b"|ÙEN÷\x13 E‚ŸRaûÈاà "
b"üVÚÞkîCÓÁ\x03 ╣.ê@ÄÛ "
b"ü■Ö^Ð\x12 Nwå¸zM÷\x04 áÕ "
b"‚túÿ*gMŒ¨\x01 ¹Û"Ã\r + "
b"ꤥ▄õÙH▒╝\x15 ]\x1E ²Åýo "
b"žéƒ(‘\x14 M9€ïã&Xèù "
b"""
¥,\x1A T4•@\¥\n
\e B\x17 üÞðª=óÏÅâHðê█!4ûìÞ└ "
b"0\x14 ,\x19 OKr˜ÜN—ÿfù\x00 "
b"Ý\x0E «Ý¨L\x7F ™WF\x14 s#Ä® "
b"¢\x04 ®K3ñN$Ø╠Gs=ê2\r "
b"ÎÄÂ8ÕsMP“nɽ¼{4Û "
b"ÔQÚs€ÛB\v ƒan¶Q6‡ "
b"ôK\”ÉZL¹’Î}f¯keé "
]
SELECT
`country_state` . `id` as `country_state.id` ,
`country_state` . `country_id` as `country_state.countryId` ,
`country_state` . `short_code` as `country_state.shortCode` ,
`country_state` . `position` as `country_state.position` ,
`country_state` . `active` as `country_state.active` ,
`country_state` . `created_at` as `country_state.createdAt` ,
`country_state` . `updated_at` as `country_state.updatedAt` ,
`country_state.translation.name` ,
COALESCE (
`country_state.translation.name` ,
`country_state.translation.name`
) as `country_state.name` ,
`country_state.translation.customFields` ,
COALESCE (
`country_state.translation.customFields` ,
`country_state.translation.customFields`
) as `country_state.customFields` ,
`country_state.translation.createdAt` ,
`country_state.translation.updatedAt` ,
`country_state.translation.countryStateId` ,
`country_state.translation.languageId`
FROM
`country_state`
LEFT JOIN `country` `country_state.country` ON `country_state` . `country_id` = `country_state.country` . `id`
LEFT JOIN (
SELECT
`country_state.translation` . country_state_id ,
`country_state.translation` . name as `country_state.translation.name` ,
`country_state.translation` . custom_fields as `country_state.translation.customFields` ,
`country_state.translation` . created_at as `country_state.translation.createdAt` ,
`country_state.translation` . updated_at as `country_state.translation.updatedAt` ,
`country_state.translation` . country_state_id as `country_state.translation.countryStateId` ,
`country_state.translation` . language_id as `country_state.translation.languageId`
FROM
`country_state_translation` `country_state.translation`
WHERE
`country_state.translation` . language_id = ?
) `country_state.country_state_translation` ON `country_state.country_state_translation` . `country_state_id` = `country_state` . `id`
LEFT JOIN `sales_channel_country` `country_state.country.salesChannels.mapping` ON `country_state.country` . `id` = `country_state.country.salesChannels.mapping` . `country_id`
LEFT JOIN `sales_channel` `country_state.country.salesChannels` ON `country_state.country.salesChannels.mapping` . `sales_channel_id` = `country_state.country.salesChannels` . `id`
WHERE
(
`country_state.country.salesChannels` . `id` = ?
AND `country_state` . `country_id` IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
)
)Copy
SELECT `country_state` . `id` as `country_state.id` , `country_state` . `country_id` as `country_state.countryId` , `country_state` . `short_code` as `country_state.shortCode` , `country_state` . `position` as `country_state.position` , `country_state` . `active` as `country_state.active` , `country_state` . `created_at` as `country_state.createdAt` , `country_state` . `updated_at` as `country_state.updatedAt` , `country_state.translation.name` , COALESCE (`country_state.translation.name` , `country_state.translation.name` ) as `country_state.name` , `country_state.translation.customFields` , COALESCE (`country_state.translation.customFields` , `country_state.translation.customFields` ) as `country_state.customFields` , `country_state.translation.createdAt` , `country_state.translation.updatedAt` , `country_state.translation.countryStateId` , `country_state.translation.languageId` FROM `country_state` LEFT JOIN `country` `country_state.country` ON `country_state` . `country_id` = `country_state.country` . `id` LEFT JOIN (SELECT `country_state.translation` . country_state_id , `country_state.translation` . name as `country_state.translation.name` , `country_state.translation` . custom_fields as `country_state.translation.customFields` , `country_state.translation` . created_at as `country_state.translation.createdAt` , `country_state.translation` . updated_at as `country_state.translation.updatedAt` , `country_state.translation` . country_state_id as `country_state.translation.countryStateId` , `country_state.translation` . language_id as `country_state.translation.languageId` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country_state.country_state_translation` ON `country_state.country_state_translation` . `country_state_id` = `country_state` . `id` LEFT JOIN `sales_channel_country` `country_state.country.salesChannels.mapping` ON `country_state.country` . `id` = `country_state.country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country_state.country.salesChannels` ON `country_state.country.salesChannels.mapping` . `sales_channel_id` = `country_state.country.salesChannels` . `id` WHERE (`country_state.country.salesChannels` . `id` = 0x2F9B056E1C484931A120DFE36BF5AA13 AND `country_state` . `country_id` IN (0x06491149A4544A608D20601CACE5240E , 0x07D36678495640B9A752D9B889E148AA , 0x1263CC2BD3374334BFFAABC07DCCF89D , 0x1825FDC868A1409D9A3C396DC0A13F18 , 0x1A85BBDC9AB74B59AF77AABF1BD2D351 , 0x1B7E75FA26F14BF6845439D879094DB1 , 0x1E9D85623FB04E0C9BA3275B7A4682A2 , 0x26656A17C9044950BA876FEAC470D3BB , 0x2BB4B7FDE659441891CDBDDB02538D26 , 0x2F03077F72504A91A39A68391347F666 , 0x375DC65A82724F6EA3BA3107C3675906 , 0x426B0847AECC4225B49B254B31209E02 , 0x520A9BB14D4C45D38F999BDA3E906766 , 0x75E219BFBC4C494A81A61AA067C2773B , 0x79012BB53086485684A94C50B1E09547 , 0x7CD9454EF71345829F5261FBC8D8A7E0 , 0x8156E9E86B8C43E0B503B92E88408EEA , 0x81FE995ED1124E7786F77A4DF604A0E5 , 0x8274FAFF2A674D8CA801B9DB22C30D2B , 0x88CFBEDCE4EB48B1BC155D1EFD8FEC6F , 0x9EE9832891144D3980EFE32658E8C3B9 , 0xA52C1A543495405CA50A1B4217FCDEF0 , 0xA63DA2D88F8348D088DB2134968DE8C0 , 0xAD30142C194F4B7298DC4E97FF66F900 , 0xADDD0EABDDA84C7F995746147323C4AE , 0xBD04A94B33A44E249DCC47733D88320D , 0xCEC4C238D5734D50936EC9BDBC7B34DB , 0xD451DA7380DB420B83616EB6AD513687 , 0xF44B5C94C95A4CB992CE7D66AF6B65E9 )); Copy
0.91 ms
1
SELECT `shipping_method` . `id` as `shipping_method.id` , `shipping_method` . `active` as `shipping_method.active` , `shipping_method` . `position` as `shipping_method.position` , `shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` as `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` as `shipping_method.taxType` , `shipping_method` . `tax_id` as `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.name` , COALESCE (`shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` ) as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` ) as `shipping_method.deliveryTime.customFields` , `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation.languageId` , `shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` as `shipping_method.technicalName` , `shipping_method` . `created_at` as `shipping_method.createdAt` , `shipping_method` . `updated_at` as `shipping_method.updatedAt` , `shipping_method.media` . `id` as `shipping_method.media.id` , `shipping_method.media` . `user_id` as `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` as `shipping_method.media.fileName` , `shipping_method.media` . `file_size` as `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` as `shipping_method.media.metaData` , `shipping_method.media` . `path` as `shipping_method.media.path` , `shipping_method.media` . `private` as `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` as `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` , `shipping_method.media.translation.title` , COALESCE (`shipping_method.media.translation.title` , `shipping_method.media.translation.title` ) as `shipping_method.media.title` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` ) as `shipping_method.media.alt` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` ) as `shipping_method.media.customFields` , `shipping_method.media.translation.createdAt` , `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation.mediaId` , `shipping_method.media.translation.languageId` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.name` , `shipping_method.translation.name` ) as `shipping_method.name` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.description` , `shipping_method.translation.description` ) as `shipping_method.description` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` ) as `shipping_method.trackingUrl` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.customFields` , `shipping_method.translation.customFields` ) as `shipping_method.customFields` , `shipping_method.translation.createdAt` , `shipping_method.translation.updatedAt` , `shipping_method.translation.shippingMethodId` , `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation` . shipping_method_id , `shipping_method.translation` . name as `shipping_method.translation.name` , `shipping_method.translation` . description as `shipping_method.translation.description` , `shipping_method.translation` . tracking_url as `shipping_method.translation.trackingUrl` , `shipping_method.translation` . custom_fields as `shipping_method.translation.customFields` , `shipping_method.translation` . created_at as `shipping_method.translation.createdAt` , `shipping_method.translation` . updated_at as `shipping_method.translation.updatedAt` , `shipping_method.translation` . shipping_method_id as `shipping_method.translation.shippingMethodId` , `shipping_method.translation` . language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation` . language_id = ? ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . delivery_time_id , `shipping_method.deliveryTime.translation` . name as `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation` . custom_fields as `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation` . created_at as `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation` . updated_at as `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation` . delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation` . language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation` . language_id = ? ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . media_id , `shipping_method.media.translation` . title as `shipping_method.media.translation.title` , `shipping_method.media.translation` . alt as `shipping_method.media.translation.alt` , `shipping_method.media.translation` . custom_fields as `shipping_method.media.translation.customFields` , `shipping_method.media.translation` . created_at as `shipping_method.media.translation.createdAt` , `shipping_method.media.translation` . updated_at as `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation` . media_id as `shipping_method.media.translation.mediaId` , `shipping_method.media.translation` . language_id as `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation` . language_id = ? ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x04 ´È\x13 ø€Cß‘ó\x7F àúÒ¨* ]
SELECT
`shipping_method` . `id` as `shipping_method.id` ,
`shipping_method` . `active` as `shipping_method.active` ,
`shipping_method` . `position` as `shipping_method.position` ,
`shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` ,
`shipping_method` . `media_id` as `shipping_method.mediaId` ,
`shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` ,
`shipping_method` . `tax_type` as `shipping_method.taxType` ,
`shipping_method` . `tax_id` as `shipping_method.taxId` ,
`shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` ,
`shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` ,
`shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` ,
`shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` ,
`shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` ,
`shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` ,
`shipping_method.deliveryTime.translation.name` ,
COALESCE (
`shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation.name`
) as `shipping_method.deliveryTime.name` ,
`shipping_method.deliveryTime.translation.customFields` ,
COALESCE (
`shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation.customFields`
) as `shipping_method.deliveryTime.customFields` ,
`shipping_method.deliveryTime.translation.createdAt` ,
`shipping_method.deliveryTime.translation.updatedAt` ,
`shipping_method.deliveryTime.translation.deliveryTimeId` ,
`shipping_method.deliveryTime.translation.languageId` ,
`shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` ,
`shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` ,
`shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` ,
`shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` ,
`shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` ,
`shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` ,
`shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` ,
`shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` ,
`shipping_method` . `technical_name` as `shipping_method.technicalName` ,
`shipping_method` . `created_at` as `shipping_method.createdAt` ,
`shipping_method` . `updated_at` as `shipping_method.updatedAt` ,
`shipping_method.media` . `id` as `shipping_method.media.id` ,
`shipping_method.media` . `user_id` as `shipping_method.media.userId` ,
`shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` ,
`shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` ,
`shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` ,
`shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` ,
`shipping_method.media` . `file_name` as `shipping_method.media.fileName` ,
`shipping_method.media` . `file_size` as `shipping_method.media.fileSize` ,
`shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` ,
`shipping_method.media` . `meta_data` as `shipping_method.media.metaData` ,
`shipping_method.media` . `path` as `shipping_method.media.path` ,
`shipping_method.media` . `private` as `shipping_method.media.private` ,
`shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` ,
`shipping_method.media` . `created_at` as `shipping_method.media.createdAt` ,
`shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` ,
`shipping_method.media.translation.title` ,
COALESCE (
`shipping_method.media.translation.title` ,
`shipping_method.media.translation.title`
) as `shipping_method.media.title` ,
`shipping_method.media.translation.alt` ,
COALESCE (
`shipping_method.media.translation.alt` ,
`shipping_method.media.translation.alt`
) as `shipping_method.media.alt` ,
`shipping_method.media.translation.customFields` ,
COALESCE (
`shipping_method.media.translation.customFields` ,
`shipping_method.media.translation.customFields`
) as `shipping_method.media.customFields` ,
`shipping_method.media.translation.createdAt` ,
`shipping_method.media.translation.updatedAt` ,
`shipping_method.media.translation.mediaId` ,
`shipping_method.media.translation.languageId` ,
`shipping_method.translation.name` ,
COALESCE (
`shipping_method.translation.name` ,
`shipping_method.translation.name`
) as `shipping_method.name` ,
`shipping_method.translation.description` ,
COALESCE (
`shipping_method.translation.description` ,
`shipping_method.translation.description`
) as `shipping_method.description` ,
`shipping_method.translation.trackingUrl` ,
COALESCE (
`shipping_method.translation.trackingUrl` ,
`shipping_method.translation.trackingUrl`
) as `shipping_method.trackingUrl` ,
`shipping_method.translation.customFields` ,
COALESCE (
`shipping_method.translation.customFields` ,
`shipping_method.translation.customFields`
) as `shipping_method.customFields` ,
`shipping_method.translation.createdAt` ,
`shipping_method.translation.updatedAt` ,
`shipping_method.translation.shippingMethodId` ,
`shipping_method.translation.languageId`
FROM
`shipping_method`
LEFT JOIN (
SELECT
`shipping_method.translation` . shipping_method_id ,
`shipping_method.translation` . name as `shipping_method.translation.name` ,
`shipping_method.translation` . description as `shipping_method.translation.description` ,
`shipping_method.translation` . tracking_url as `shipping_method.translation.trackingUrl` ,
`shipping_method.translation` . custom_fields as `shipping_method.translation.customFields` ,
`shipping_method.translation` . created_at as `shipping_method.translation.createdAt` ,
`shipping_method.translation` . updated_at as `shipping_method.translation.updatedAt` ,
`shipping_method.translation` . shipping_method_id as `shipping_method.translation.shippingMethodId` ,
`shipping_method.translation` . language_id as `shipping_method.translation.languageId`
FROM
`shipping_method_translation` `shipping_method.translation`
WHERE
`shipping_method.translation` . language_id = ?
) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id`
LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id`
LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id`
LEFT JOIN (
SELECT
`shipping_method.deliveryTime.translation` . delivery_time_id ,
`shipping_method.deliveryTime.translation` . name as `shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation` . custom_fields as `shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation` . created_at as `shipping_method.deliveryTime.translation.createdAt` ,
`shipping_method.deliveryTime.translation` . updated_at as `shipping_method.deliveryTime.translation.updatedAt` ,
`shipping_method.deliveryTime.translation` . delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId` ,
`shipping_method.deliveryTime.translation` . language_id as `shipping_method.deliveryTime.translation.languageId`
FROM
`delivery_time_translation` `shipping_method.deliveryTime.translation`
WHERE
`shipping_method.deliveryTime.translation` . language_id = ?
) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN (
SELECT
`shipping_method.media.translation` . media_id ,
`shipping_method.media.translation` . title as `shipping_method.media.translation.title` ,
`shipping_method.media.translation` . alt as `shipping_method.media.translation.alt` ,
`shipping_method.media.translation` . custom_fields as `shipping_method.media.translation.customFields` ,
`shipping_method.media.translation` . created_at as `shipping_method.media.translation.createdAt` ,
`shipping_method.media.translation` . updated_at as `shipping_method.media.translation.updatedAt` ,
`shipping_method.media.translation` . media_id as `shipping_method.media.translation.mediaId` ,
`shipping_method.media.translation` . language_id as `shipping_method.media.translation.languageId`
FROM
`media_translation` `shipping_method.media.translation`
WHERE
`shipping_method.media.translation` . language_id = ?
) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id`
WHERE
`shipping_method` . `id` IN (? )
Copy
SELECT `shipping_method` . `id` as `shipping_method.id` , `shipping_method` . `active` as `shipping_method.active` , `shipping_method` . `position` as `shipping_method.position` , `shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` as `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` as `shipping_method.taxType` , `shipping_method` . `tax_id` as `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.name` , COALESCE (`shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` ) as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` ) as `shipping_method.deliveryTime.customFields` , `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation.languageId` , `shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` as `shipping_method.technicalName` , `shipping_method` . `created_at` as `shipping_method.createdAt` , `shipping_method` . `updated_at` as `shipping_method.updatedAt` , `shipping_method.media` . `id` as `shipping_method.media.id` , `shipping_method.media` . `user_id` as `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` as `shipping_method.media.fileName` , `shipping_method.media` . `file_size` as `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` as `shipping_method.media.metaData` , `shipping_method.media` . `path` as `shipping_method.media.path` , `shipping_method.media` . `private` as `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` as `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` , `shipping_method.media.translation.title` , COALESCE (`shipping_method.media.translation.title` , `shipping_method.media.translation.title` ) as `shipping_method.media.title` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` ) as `shipping_method.media.alt` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` ) as `shipping_method.media.customFields` , `shipping_method.media.translation.createdAt` , `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation.mediaId` , `shipping_method.media.translation.languageId` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.name` , `shipping_method.translation.name` ) as `shipping_method.name` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.description` , `shipping_method.translation.description` ) as `shipping_method.description` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` ) as `shipping_method.trackingUrl` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.customFields` , `shipping_method.translation.customFields` ) as `shipping_method.customFields` , `shipping_method.translation.createdAt` , `shipping_method.translation.updatedAt` , `shipping_method.translation.shippingMethodId` , `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation` . shipping_method_id , `shipping_method.translation` . name as `shipping_method.translation.name` , `shipping_method.translation` . description as `shipping_method.translation.description` , `shipping_method.translation` . tracking_url as `shipping_method.translation.trackingUrl` , `shipping_method.translation` . custom_fields as `shipping_method.translation.customFields` , `shipping_method.translation` . created_at as `shipping_method.translation.createdAt` , `shipping_method.translation` . updated_at as `shipping_method.translation.updatedAt` , `shipping_method.translation` . shipping_method_id as `shipping_method.translation.shippingMethodId` , `shipping_method.translation` . language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . delivery_time_id , `shipping_method.deliveryTime.translation` . name as `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation` . custom_fields as `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation` . created_at as `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation` . updated_at as `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation` . delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation` . language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . media_id , `shipping_method.media.translation` . title as `shipping_method.media.translation.title` , `shipping_method.media.translation` . alt as `shipping_method.media.translation.alt` , `shipping_method.media.translation` . custom_fields as `shipping_method.media.translation.customFields` , `shipping_method.media.translation` . created_at as `shipping_method.media.translation.createdAt` , `shipping_method.media.translation` . updated_at as `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation` . media_id as `shipping_method.media.translation.mediaId` , `shipping_method.media.translation` . language_id as `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (0x04B4C813F88043DF91F37FE0FAD2A82A );
Copy
0.91 ms
1
SELECT `shipping_method` . `id` as `shipping_method.id` , `shipping_method` . `active` as `shipping_method.active` , `shipping_method` . `position` as `shipping_method.position` , `shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` as `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` as `shipping_method.taxType` , `shipping_method` . `tax_id` as `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.name` , COALESCE (`shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` ) as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` ) as `shipping_method.deliveryTime.customFields` , `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation.languageId` , `shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` as `shipping_method.technicalName` , `shipping_method` . `created_at` as `shipping_method.createdAt` , `shipping_method` . `updated_at` as `shipping_method.updatedAt` , `shipping_method.media` . `id` as `shipping_method.media.id` , `shipping_method.media` . `user_id` as `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` as `shipping_method.media.fileName` , `shipping_method.media` . `file_size` as `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` as `shipping_method.media.metaData` , `shipping_method.media` . `path` as `shipping_method.media.path` , `shipping_method.media` . `private` as `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` as `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` , `shipping_method.media.translation.title` , COALESCE (`shipping_method.media.translation.title` , `shipping_method.media.translation.title` ) as `shipping_method.media.title` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` ) as `shipping_method.media.alt` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` ) as `shipping_method.media.customFields` , `shipping_method.media.translation.createdAt` , `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation.mediaId` , `shipping_method.media.translation.languageId` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.name` , `shipping_method.translation.name` ) as `shipping_method.name` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.description` , `shipping_method.translation.description` ) as `shipping_method.description` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` ) as `shipping_method.trackingUrl` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.customFields` , `shipping_method.translation.customFields` ) as `shipping_method.customFields` , `shipping_method.translation.createdAt` , `shipping_method.translation.updatedAt` , `shipping_method.translation.shippingMethodId` , `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation` . shipping_method_id , `shipping_method.translation` . name as `shipping_method.translation.name` , `shipping_method.translation` . description as `shipping_method.translation.description` , `shipping_method.translation` . tracking_url as `shipping_method.translation.trackingUrl` , `shipping_method.translation` . custom_fields as `shipping_method.translation.customFields` , `shipping_method.translation` . created_at as `shipping_method.translation.createdAt` , `shipping_method.translation` . updated_at as `shipping_method.translation.updatedAt` , `shipping_method.translation` . shipping_method_id as `shipping_method.translation.shippingMethodId` , `shipping_method.translation` . language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation` . language_id = ? ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . delivery_time_id , `shipping_method.deliveryTime.translation` . name as `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation` . custom_fields as `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation` . created_at as `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation` . updated_at as `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation` . delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation` . language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation` . language_id = ? ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . media_id , `shipping_method.media.translation` . title as `shipping_method.media.translation.title` , `shipping_method.media.translation` . alt as `shipping_method.media.translation.alt` , `shipping_method.media.translation` . custom_fields as `shipping_method.media.translation.customFields` , `shipping_method.media.translation` . created_at as `shipping_method.media.translation.createdAt` , `shipping_method.media.translation` . updated_at as `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation` . media_id as `shipping_method.media.translation.mediaId` , `shipping_method.media.translation` . language_id as `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation` . language_id = ? ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x04 ´È\x13 ø€Cß‘ó\x7F àúÒ¨* ]
SELECT
`shipping_method` . `id` as `shipping_method.id` ,
`shipping_method` . `active` as `shipping_method.active` ,
`shipping_method` . `position` as `shipping_method.position` ,
`shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` ,
`shipping_method` . `media_id` as `shipping_method.mediaId` ,
`shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` ,
`shipping_method` . `tax_type` as `shipping_method.taxType` ,
`shipping_method` . `tax_id` as `shipping_method.taxId` ,
`shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` ,
`shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` ,
`shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` ,
`shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` ,
`shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` ,
`shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` ,
`shipping_method.deliveryTime.translation.name` ,
COALESCE (
`shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation.name`
) as `shipping_method.deliveryTime.name` ,
`shipping_method.deliveryTime.translation.customFields` ,
COALESCE (
`shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation.customFields`
) as `shipping_method.deliveryTime.customFields` ,
`shipping_method.deliveryTime.translation.createdAt` ,
`shipping_method.deliveryTime.translation.updatedAt` ,
`shipping_method.deliveryTime.translation.deliveryTimeId` ,
`shipping_method.deliveryTime.translation.languageId` ,
`shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` ,
`shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` ,
`shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` ,
`shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` ,
`shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` ,
`shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` ,
`shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` ,
`shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` ,
`shipping_method` . `technical_name` as `shipping_method.technicalName` ,
`shipping_method` . `created_at` as `shipping_method.createdAt` ,
`shipping_method` . `updated_at` as `shipping_method.updatedAt` ,
`shipping_method.media` . `id` as `shipping_method.media.id` ,
`shipping_method.media` . `user_id` as `shipping_method.media.userId` ,
`shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` ,
`shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` ,
`shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` ,
`shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` ,
`shipping_method.media` . `file_name` as `shipping_method.media.fileName` ,
`shipping_method.media` . `file_size` as `shipping_method.media.fileSize` ,
`shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` ,
`shipping_method.media` . `meta_data` as `shipping_method.media.metaData` ,
`shipping_method.media` . `path` as `shipping_method.media.path` ,
`shipping_method.media` . `private` as `shipping_method.media.private` ,
`shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` ,
`shipping_method.media` . `created_at` as `shipping_method.media.createdAt` ,
`shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` ,
`shipping_method.media.translation.title` ,
COALESCE (
`shipping_method.media.translation.title` ,
`shipping_method.media.translation.title`
) as `shipping_method.media.title` ,
`shipping_method.media.translation.alt` ,
COALESCE (
`shipping_method.media.translation.alt` ,
`shipping_method.media.translation.alt`
) as `shipping_method.media.alt` ,
`shipping_method.media.translation.customFields` ,
COALESCE (
`shipping_method.media.translation.customFields` ,
`shipping_method.media.translation.customFields`
) as `shipping_method.media.customFields` ,
`shipping_method.media.translation.createdAt` ,
`shipping_method.media.translation.updatedAt` ,
`shipping_method.media.translation.mediaId` ,
`shipping_method.media.translation.languageId` ,
`shipping_method.translation.name` ,
COALESCE (
`shipping_method.translation.name` ,
`shipping_method.translation.name`
) as `shipping_method.name` ,
`shipping_method.translation.description` ,
COALESCE (
`shipping_method.translation.description` ,
`shipping_method.translation.description`
) as `shipping_method.description` ,
`shipping_method.translation.trackingUrl` ,
COALESCE (
`shipping_method.translation.trackingUrl` ,
`shipping_method.translation.trackingUrl`
) as `shipping_method.trackingUrl` ,
`shipping_method.translation.customFields` ,
COALESCE (
`shipping_method.translation.customFields` ,
`shipping_method.translation.customFields`
) as `shipping_method.customFields` ,
`shipping_method.translation.createdAt` ,
`shipping_method.translation.updatedAt` ,
`shipping_method.translation.shippingMethodId` ,
`shipping_method.translation.languageId`
FROM
`shipping_method`
LEFT JOIN (
SELECT
`shipping_method.translation` . shipping_method_id ,
`shipping_method.translation` . name as `shipping_method.translation.name` ,
`shipping_method.translation` . description as `shipping_method.translation.description` ,
`shipping_method.translation` . tracking_url as `shipping_method.translation.trackingUrl` ,
`shipping_method.translation` . custom_fields as `shipping_method.translation.customFields` ,
`shipping_method.translation` . created_at as `shipping_method.translation.createdAt` ,
`shipping_method.translation` . updated_at as `shipping_method.translation.updatedAt` ,
`shipping_method.translation` . shipping_method_id as `shipping_method.translation.shippingMethodId` ,
`shipping_method.translation` . language_id as `shipping_method.translation.languageId`
FROM
`shipping_method_translation` `shipping_method.translation`
WHERE
`shipping_method.translation` . language_id = ?
) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id`
LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id`
LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id`
LEFT JOIN (
SELECT
`shipping_method.deliveryTime.translation` . delivery_time_id ,
`shipping_method.deliveryTime.translation` . name as `shipping_method.deliveryTime.translation.name` ,
`shipping_method.deliveryTime.translation` . custom_fields as `shipping_method.deliveryTime.translation.customFields` ,
`shipping_method.deliveryTime.translation` . created_at as `shipping_method.deliveryTime.translation.createdAt` ,
`shipping_method.deliveryTime.translation` . updated_at as `shipping_method.deliveryTime.translation.updatedAt` ,
`shipping_method.deliveryTime.translation` . delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId` ,
`shipping_method.deliveryTime.translation` . language_id as `shipping_method.deliveryTime.translation.languageId`
FROM
`delivery_time_translation` `shipping_method.deliveryTime.translation`
WHERE
`shipping_method.deliveryTime.translation` . language_id = ?
) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id`
LEFT JOIN (
SELECT
`shipping_method.media.translation` . media_id ,
`shipping_method.media.translation` . title as `shipping_method.media.translation.title` ,
`shipping_method.media.translation` . alt as `shipping_method.media.translation.alt` ,
`shipping_method.media.translation` . custom_fields as `shipping_method.media.translation.customFields` ,
`shipping_method.media.translation` . created_at as `shipping_method.media.translation.createdAt` ,
`shipping_method.media.translation` . updated_at as `shipping_method.media.translation.updatedAt` ,
`shipping_method.media.translation` . media_id as `shipping_method.media.translation.mediaId` ,
`shipping_method.media.translation` . language_id as `shipping_method.media.translation.languageId`
FROM
`media_translation` `shipping_method.media.translation`
WHERE
`shipping_method.media.translation` . language_id = ?
) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id`
WHERE
`shipping_method` . `id` IN (? )
Copy
SELECT `shipping_method` . `id` as `shipping_method.id` , `shipping_method` . `active` as `shipping_method.active` , `shipping_method` . `position` as `shipping_method.position` , `shipping_method` . `availability_rule_id` as `shipping_method.availabilityRuleId` , `shipping_method` . `media_id` as `shipping_method.mediaId` , `shipping_method` . `delivery_time_id` as `shipping_method.deliveryTimeId` , `shipping_method` . `tax_type` as `shipping_method.taxType` , `shipping_method` . `tax_id` as `shipping_method.taxId` , `shipping_method.deliveryTime` . `id` as `shipping_method.deliveryTime.id` , `shipping_method.deliveryTime` . `min` as `shipping_method.deliveryTime.min` , `shipping_method.deliveryTime` . `max` as `shipping_method.deliveryTime.max` , `shipping_method.deliveryTime` . `unit` as `shipping_method.deliveryTime.unit` , `shipping_method.deliveryTime` . `created_at` as `shipping_method.deliveryTime.createdAt` , `shipping_method.deliveryTime` . `updated_at` as `shipping_method.deliveryTime.updatedAt` , `shipping_method.deliveryTime.translation.name` , COALESCE (`shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation.name` ) as `shipping_method.deliveryTime.name` , `shipping_method.deliveryTime.translation.customFields` , COALESCE (`shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation.customFields` ) as `shipping_method.deliveryTime.customFields` , `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation.languageId` , `shipping_method.appShippingMethod` . `id` as `shipping_method.appShippingMethod.id` , `shipping_method.appShippingMethod` . `app_name` as `shipping_method.appShippingMethod.appName` , `shipping_method.appShippingMethod` . `identifier` as `shipping_method.appShippingMethod.identifier` , `shipping_method.appShippingMethod` . `app_id` as `shipping_method.appShippingMethod.appId` , `shipping_method.appShippingMethod` . `shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId` , `shipping_method.appShippingMethod` . `original_media_id` as `shipping_method.appShippingMethod.originalMediaId` , `shipping_method.appShippingMethod` . `created_at` as `shipping_method.appShippingMethod.createdAt` , `shipping_method.appShippingMethod` . `updated_at` as `shipping_method.appShippingMethod.updatedAt` , `shipping_method` . `technical_name` as `shipping_method.technicalName` , `shipping_method` . `created_at` as `shipping_method.createdAt` , `shipping_method` . `updated_at` as `shipping_method.updatedAt` , `shipping_method.media` . `id` as `shipping_method.media.id` , `shipping_method.media` . `user_id` as `shipping_method.media.userId` , `shipping_method.media` . `media_folder_id` as `shipping_method.media.mediaFolderId` , `shipping_method.media` . `mime_type` as `shipping_method.media.mimeType` , `shipping_method.media` . `file_extension` as `shipping_method.media.fileExtension` , `shipping_method.media` . `uploaded_at` as `shipping_method.media.uploadedAt` , `shipping_method.media` . `file_name` as `shipping_method.media.fileName` , `shipping_method.media` . `file_size` as `shipping_method.media.fileSize` , `shipping_method.media` . `media_type` as `shipping_method.media.mediaTypeRaw` , `shipping_method.media` . `meta_data` as `shipping_method.media.metaData` , `shipping_method.media` . `path` as `shipping_method.media.path` , `shipping_method.media` . `private` as `shipping_method.media.private` , `shipping_method.media` . `thumbnails_ro` as `shipping_method.media.thumbnailsRo` , `shipping_method.media` . `created_at` as `shipping_method.media.createdAt` , `shipping_method.media` . `updated_at` as `shipping_method.media.updatedAt` , `shipping_method.media.translation.title` , COALESCE (`shipping_method.media.translation.title` , `shipping_method.media.translation.title` ) as `shipping_method.media.title` , `shipping_method.media.translation.alt` , COALESCE (`shipping_method.media.translation.alt` , `shipping_method.media.translation.alt` ) as `shipping_method.media.alt` , `shipping_method.media.translation.customFields` , COALESCE (`shipping_method.media.translation.customFields` , `shipping_method.media.translation.customFields` ) as `shipping_method.media.customFields` , `shipping_method.media.translation.createdAt` , `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation.mediaId` , `shipping_method.media.translation.languageId` , `shipping_method.translation.name` , COALESCE (`shipping_method.translation.name` , `shipping_method.translation.name` ) as `shipping_method.name` , `shipping_method.translation.description` , COALESCE (`shipping_method.translation.description` , `shipping_method.translation.description` ) as `shipping_method.description` , `shipping_method.translation.trackingUrl` , COALESCE (`shipping_method.translation.trackingUrl` , `shipping_method.translation.trackingUrl` ) as `shipping_method.trackingUrl` , `shipping_method.translation.customFields` , COALESCE (`shipping_method.translation.customFields` , `shipping_method.translation.customFields` ) as `shipping_method.customFields` , `shipping_method.translation.createdAt` , `shipping_method.translation.updatedAt` , `shipping_method.translation.shippingMethodId` , `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation` . shipping_method_id , `shipping_method.translation` . name as `shipping_method.translation.name` , `shipping_method.translation` . description as `shipping_method.translation.description` , `shipping_method.translation` . tracking_url as `shipping_method.translation.trackingUrl` , `shipping_method.translation` . custom_fields as `shipping_method.translation.customFields` , `shipping_method.translation` . created_at as `shipping_method.translation.createdAt` , `shipping_method.translation` . updated_at as `shipping_method.translation.updatedAt` , `shipping_method.translation` . shipping_method_id as `shipping_method.translation.shippingMethodId` , `shipping_method.translation` . language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method` . `id` = `shipping_method.appShippingMethod` . `shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method` . `media_id` = `shipping_method.media` . `id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation` . delivery_time_id , `shipping_method.deliveryTime.translation` . name as `shipping_method.deliveryTime.translation.name` , `shipping_method.deliveryTime.translation` . custom_fields as `shipping_method.deliveryTime.translation.customFields` , `shipping_method.deliveryTime.translation` . created_at as `shipping_method.deliveryTime.translation.createdAt` , `shipping_method.deliveryTime.translation` . updated_at as `shipping_method.deliveryTime.translation.updatedAt` , `shipping_method.deliveryTime.translation` . delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId` , `shipping_method.deliveryTime.translation` . language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation` . `delivery_time_id` = `shipping_method.deliveryTime` . `id` LEFT JOIN (SELECT `shipping_method.media.translation` . media_id , `shipping_method.media.translation` . title as `shipping_method.media.translation.title` , `shipping_method.media.translation` . alt as `shipping_method.media.translation.alt` , `shipping_method.media.translation` . custom_fields as `shipping_method.media.translation.customFields` , `shipping_method.media.translation` . created_at as `shipping_method.media.translation.createdAt` , `shipping_method.media.translation` . updated_at as `shipping_method.media.translation.updatedAt` , `shipping_method.media.translation` . media_id as `shipping_method.media.translation.mediaId` , `shipping_method.media.translation` . language_id as `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation` . `media_id` = `shipping_method.media` . `id` WHERE `shipping_method` . `id` IN (0x04B4C813F88043DF91F37FE0FAD2A82A );
Copy
0.89 ms
1
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel.analytics` . `id` as `sales_channel.analytics.id` , `sales_channel.analytics` . `tracking_id` as `sales_channel.analytics.trackingId` , `sales_channel.analytics` . `active` as `sales_channel.analytics.active` , `sales_channel.analytics` . `track_orders` as `sales_channel.analytics.trackOrders` , `sales_channel.analytics` . `anonymize_ip` as `sales_channel.analytics.anonymizeIp` , `sales_channel.analytics` . `created_at` as `sales_channel.analytics.createdAt` , `sales_channel.analytics` . `updated_at` as `sales_channel.analytics.updatedAt` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.currency` . `id` as `sales_channel.currency.id` , `sales_channel.currency` . `factor` as `sales_channel.currency.factor` , `sales_channel.currency` . `symbol` as `sales_channel.currency.symbol` , `sales_channel.currency` . `iso_code` as `sales_channel.currency.isoCode` , `sales_channel.currency` . `position` as `sales_channel.currency.position` , `sales_channel.currency` . `tax_free_from` as `sales_channel.currency.taxFreeFrom` , `sales_channel.currency` . `item_rounding` as `sales_channel.currency.itemRounding` , `sales_channel.currency` . `total_rounding` as `sales_channel.currency.totalRounding` , `sales_channel.currency` . `created_at` as `sales_channel.currency.createdAt` , `sales_channel.currency` . `updated_at` as `sales_channel.currency.updatedAt` , `sales_channel.currency.translation.shortName` , COALESCE (`sales_channel.currency.translation.shortName` , `sales_channel.currency.translation.shortName` ) as `sales_channel.currency.shortName` , `sales_channel.currency.translation.name` , COALESCE (`sales_channel.currency.translation.name` , `sales_channel.currency.translation.name` ) as `sales_channel.currency.name` , `sales_channel.currency.translation.customFields` , COALESCE (`sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.customFields` ) as `sales_channel.currency.customFields` , `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation.languageId` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name as `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name as `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` , `sales_channel.translation` . created_at as `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = ? ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id` LEFT JOIN (SELECT `sales_channel.currency.translation` . currency_id , `sales_channel.currency.translation` . short_name as `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation` . name as `sales_channel.currency.translation.name` , `sales_channel.currency.translation` . custom_fields as `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation` . created_at as `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation` . updated_at as `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation` . currency_id as `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation` . language_id as `sales_channel.currency.translation.languageId` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation` . language_id = ? ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id` WHERE `sales_channel` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT
`sales_channel` . `id` as `sales_channel.id` ,
`sales_channel` . `type_id` as `sales_channel.typeId` ,
`sales_channel` . `language_id` as `sales_channel.languageId` ,
`sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` ,
`sales_channel` . `currency_id` as `sales_channel.currencyId` ,
`sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` ,
`sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` ,
`sales_channel` . `country_id` as `sales_channel.countryId` ,
`sales_channel` . `analytics_id` as `sales_channel.analyticsId` ,
`sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` ,
`sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` ,
`sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` ,
`sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` ,
`sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` ,
`sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` ,
`sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` ,
`sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` ,
`sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` ,
`sales_channel` . `short_name` as `sales_channel.shortName` ,
`sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` ,
`sales_channel` . `access_key` as `sales_channel.accessKey` ,
`sales_channel` . `configuration` as `sales_channel.configuration` ,
`sales_channel` . `active` as `sales_channel.active` ,
`sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` ,
`sales_channel` . `maintenance` as `sales_channel.maintenance` ,
`sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` ,
`sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` ,
`sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` ,
`sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` ,
`sales_channel.analytics` . `id` as `sales_channel.analytics.id` ,
`sales_channel.analytics` . `tracking_id` as `sales_channel.analytics.trackingId` ,
`sales_channel.analytics` . `active` as `sales_channel.analytics.active` ,
`sales_channel.analytics` . `track_orders` as `sales_channel.analytics.trackOrders` ,
`sales_channel.analytics` . `anonymize_ip` as `sales_channel.analytics.anonymizeIp` ,
`sales_channel.analytics` . `created_at` as `sales_channel.analytics.createdAt` ,
`sales_channel.analytics` . `updated_at` as `sales_channel.analytics.updatedAt` ,
`sales_channel` . `created_at` as `sales_channel.createdAt` ,
`sales_channel` . `updated_at` as `sales_channel.updatedAt` ,
`sales_channel.currency` . `id` as `sales_channel.currency.id` ,
`sales_channel.currency` . `factor` as `sales_channel.currency.factor` ,
`sales_channel.currency` . `symbol` as `sales_channel.currency.symbol` ,
`sales_channel.currency` . `iso_code` as `sales_channel.currency.isoCode` ,
`sales_channel.currency` . `position` as `sales_channel.currency.position` ,
`sales_channel.currency` . `tax_free_from` as `sales_channel.currency.taxFreeFrom` ,
`sales_channel.currency` . `item_rounding` as `sales_channel.currency.itemRounding` ,
`sales_channel.currency` . `total_rounding` as `sales_channel.currency.totalRounding` ,
`sales_channel.currency` . `created_at` as `sales_channel.currency.createdAt` ,
`sales_channel.currency` . `updated_at` as `sales_channel.currency.updatedAt` ,
`sales_channel.currency.translation.shortName` ,
COALESCE (
`sales_channel.currency.translation.shortName` ,
`sales_channel.currency.translation.shortName`
) as `sales_channel.currency.shortName` ,
`sales_channel.currency.translation.name` ,
COALESCE (
`sales_channel.currency.translation.name` ,
`sales_channel.currency.translation.name`
) as `sales_channel.currency.name` ,
`sales_channel.currency.translation.customFields` ,
COALESCE (
`sales_channel.currency.translation.customFields` ,
`sales_channel.currency.translation.customFields`
) as `sales_channel.currency.customFields` ,
`sales_channel.currency.translation.createdAt` ,
`sales_channel.currency.translation.updatedAt` ,
`sales_channel.currency.translation.currencyId` ,
`sales_channel.currency.translation.languageId` ,
`sales_channel.translation.name` ,
COALESCE (
`sales_channel.translation.name` ,
`sales_channel.translation.name`
) as `sales_channel.name` ,
`sales_channel.translation.homeSlotConfig` ,
COALESCE (
`sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation.homeSlotConfig`
) as `sales_channel.homeSlotConfig` ,
`sales_channel.translation.homeEnabled` ,
COALESCE (
`sales_channel.translation.homeEnabled` ,
`sales_channel.translation.homeEnabled`
) as `sales_channel.homeEnabled` ,
`sales_channel.translation.homeName` ,
COALESCE (
`sales_channel.translation.homeName` ,
`sales_channel.translation.homeName`
) as `sales_channel.homeName` ,
`sales_channel.translation.homeMetaTitle` ,
COALESCE (
`sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation.homeMetaTitle`
) as `sales_channel.homeMetaTitle` ,
`sales_channel.translation.homeMetaDescription` ,
COALESCE (
`sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation.homeMetaDescription`
) as `sales_channel.homeMetaDescription` ,
`sales_channel.translation.homeKeywords` ,
COALESCE (
`sales_channel.translation.homeKeywords` ,
`sales_channel.translation.homeKeywords`
) as `sales_channel.homeKeywords` ,
`sales_channel.translation.customFields` ,
COALESCE (
`sales_channel.translation.customFields` ,
`sales_channel.translation.customFields`
) as `sales_channel.customFields` ,
`sales_channel.translation.createdAt` ,
`sales_channel.translation.updatedAt` ,
`sales_channel.translation.salesChannelId` ,
`sales_channel.translation.languageId`
FROM
`sales_channel`
LEFT JOIN (
SELECT
`sales_channel.translation` . sales_channel_id ,
`sales_channel.translation` . name as `sales_channel.translation.name` ,
`sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` ,
`sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` ,
`sales_channel.translation` . home_name as `sales_channel.translation.homeName` ,
`sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` ,
`sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` ,
`sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` ,
`sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` ,
`sales_channel.translation` . created_at as `sales_channel.translation.createdAt` ,
`sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` ,
`sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` ,
`sales_channel.translation` . language_id as `sales_channel.translation.languageId`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation` . language_id = ?
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id`
LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id`
LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id`
LEFT JOIN (
SELECT
`sales_channel.currency.translation` . currency_id ,
`sales_channel.currency.translation` . short_name as `sales_channel.currency.translation.shortName` ,
`sales_channel.currency.translation` . name as `sales_channel.currency.translation.name` ,
`sales_channel.currency.translation` . custom_fields as `sales_channel.currency.translation.customFields` ,
`sales_channel.currency.translation` . created_at as `sales_channel.currency.translation.createdAt` ,
`sales_channel.currency.translation` . updated_at as `sales_channel.currency.translation.updatedAt` ,
`sales_channel.currency.translation` . currency_id as `sales_channel.currency.translation.currencyId` ,
`sales_channel.currency.translation` . language_id as `sales_channel.currency.translation.languageId`
FROM
`currency_translation` `sales_channel.currency.translation`
WHERE
`sales_channel.currency.translation` . language_id = ?
) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id`
WHERE
`sales_channel` . `id` IN (? )
Copy
SELECT `sales_channel` . `id` as `sales_channel.id` , `sales_channel` . `type_id` as `sales_channel.typeId` , `sales_channel` . `language_id` as `sales_channel.languageId` , `sales_channel` . `customer_group_id` as `sales_channel.customerGroupId` , `sales_channel` . `currency_id` as `sales_channel.currencyId` , `sales_channel` . `payment_method_id` as `sales_channel.paymentMethodId` , `sales_channel` . `shipping_method_id` as `sales_channel.shippingMethodId` , `sales_channel` . `country_id` as `sales_channel.countryId` , `sales_channel` . `analytics_id` as `sales_channel.analyticsId` , `sales_channel` . `navigation_category_id` as `sales_channel.navigationCategoryId` , `sales_channel` . `navigation_category_version_id` as `sales_channel.navigationCategoryVersionId` , `sales_channel` . `navigation_category_depth` as `sales_channel.navigationCategoryDepth` , `sales_channel` . `footer_category_id` as `sales_channel.footerCategoryId` , `sales_channel` . `footer_category_version_id` as `sales_channel.footerCategoryVersionId` , `sales_channel` . `service_category_id` as `sales_channel.serviceCategoryId` , `sales_channel` . `service_category_version_id` as `sales_channel.serviceCategoryVersionId` , `sales_channel` . `mail_header_footer_id` as `sales_channel.mailHeaderFooterId` , `sales_channel` . `hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId` , `sales_channel` . `short_name` as `sales_channel.shortName` , `sales_channel` . `tax_calculation_type` as `sales_channel.taxCalculationType` , `sales_channel` . `access_key` as `sales_channel.accessKey` , `sales_channel` . `configuration` as `sales_channel.configuration` , `sales_channel` . `active` as `sales_channel.active` , `sales_channel` . `hreflang_active` as `sales_channel.hreflangActive` , `sales_channel` . `maintenance` as `sales_channel.maintenance` , `sales_channel` . `maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist` , `sales_channel` . `payment_method_ids` as `sales_channel.paymentMethodIds` , `sales_channel` . `home_cms_page_id` as `sales_channel.homeCmsPageId` , `sales_channel` . `home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId` , `sales_channel.analytics` . `id` as `sales_channel.analytics.id` , `sales_channel.analytics` . `tracking_id` as `sales_channel.analytics.trackingId` , `sales_channel.analytics` . `active` as `sales_channel.analytics.active` , `sales_channel.analytics` . `track_orders` as `sales_channel.analytics.trackOrders` , `sales_channel.analytics` . `anonymize_ip` as `sales_channel.analytics.anonymizeIp` , `sales_channel.analytics` . `created_at` as `sales_channel.analytics.createdAt` , `sales_channel.analytics` . `updated_at` as `sales_channel.analytics.updatedAt` , `sales_channel` . `created_at` as `sales_channel.createdAt` , `sales_channel` . `updated_at` as `sales_channel.updatedAt` , `sales_channel.currency` . `id` as `sales_channel.currency.id` , `sales_channel.currency` . `factor` as `sales_channel.currency.factor` , `sales_channel.currency` . `symbol` as `sales_channel.currency.symbol` , `sales_channel.currency` . `iso_code` as `sales_channel.currency.isoCode` , `sales_channel.currency` . `position` as `sales_channel.currency.position` , `sales_channel.currency` . `tax_free_from` as `sales_channel.currency.taxFreeFrom` , `sales_channel.currency` . `item_rounding` as `sales_channel.currency.itemRounding` , `sales_channel.currency` . `total_rounding` as `sales_channel.currency.totalRounding` , `sales_channel.currency` . `created_at` as `sales_channel.currency.createdAt` , `sales_channel.currency` . `updated_at` as `sales_channel.currency.updatedAt` , `sales_channel.currency.translation.shortName` , COALESCE (`sales_channel.currency.translation.shortName` , `sales_channel.currency.translation.shortName` ) as `sales_channel.currency.shortName` , `sales_channel.currency.translation.name` , COALESCE (`sales_channel.currency.translation.name` , `sales_channel.currency.translation.name` ) as `sales_channel.currency.name` , `sales_channel.currency.translation.customFields` , COALESCE (`sales_channel.currency.translation.customFields` , `sales_channel.currency.translation.customFields` ) as `sales_channel.currency.customFields` , `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation.languageId` , `sales_channel.translation.name` , COALESCE (`sales_channel.translation.name` , `sales_channel.translation.name` ) as `sales_channel.name` , `sales_channel.translation.homeSlotConfig` , COALESCE (`sales_channel.translation.homeSlotConfig` , `sales_channel.translation.homeSlotConfig` ) as `sales_channel.homeSlotConfig` , `sales_channel.translation.homeEnabled` , COALESCE (`sales_channel.translation.homeEnabled` , `sales_channel.translation.homeEnabled` ) as `sales_channel.homeEnabled` , `sales_channel.translation.homeName` , COALESCE (`sales_channel.translation.homeName` , `sales_channel.translation.homeName` ) as `sales_channel.homeName` , `sales_channel.translation.homeMetaTitle` , COALESCE (`sales_channel.translation.homeMetaTitle` , `sales_channel.translation.homeMetaTitle` ) as `sales_channel.homeMetaTitle` , `sales_channel.translation.homeMetaDescription` , COALESCE (`sales_channel.translation.homeMetaDescription` , `sales_channel.translation.homeMetaDescription` ) as `sales_channel.homeMetaDescription` , `sales_channel.translation.homeKeywords` , COALESCE (`sales_channel.translation.homeKeywords` , `sales_channel.translation.homeKeywords` ) as `sales_channel.homeKeywords` , `sales_channel.translation.customFields` , COALESCE (`sales_channel.translation.customFields` , `sales_channel.translation.customFields` ) as `sales_channel.customFields` , `sales_channel.translation.createdAt` , `sales_channel.translation.updatedAt` , `sales_channel.translation.salesChannelId` , `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation` . sales_channel_id , `sales_channel.translation` . name as `sales_channel.translation.name` , `sales_channel.translation` . home_slot_config as `sales_channel.translation.homeSlotConfig` , `sales_channel.translation` . home_enabled as `sales_channel.translation.homeEnabled` , `sales_channel.translation` . home_name as `sales_channel.translation.homeName` , `sales_channel.translation` . home_meta_title as `sales_channel.translation.homeMetaTitle` , `sales_channel.translation` . home_meta_description as `sales_channel.translation.homeMetaDescription` , `sales_channel.translation` . home_keywords as `sales_channel.translation.homeKeywords` , `sales_channel.translation` . custom_fields as `sales_channel.translation.customFields` , `sales_channel.translation` . created_at as `sales_channel.translation.createdAt` , `sales_channel.translation` . updated_at as `sales_channel.translation.updatedAt` , `sales_channel.translation` . sales_channel_id as `sales_channel.translation.salesChannelId` , `sales_channel.translation` . language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation` . `sales_channel_id` = `sales_channel` . `id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel` . `analytics_id` = `sales_channel.analytics` . `id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel` . `currency_id` = `sales_channel.currency` . `id` LEFT JOIN (SELECT `sales_channel.currency.translation` . currency_id , `sales_channel.currency.translation` . short_name as `sales_channel.currency.translation.shortName` , `sales_channel.currency.translation` . name as `sales_channel.currency.translation.name` , `sales_channel.currency.translation` . custom_fields as `sales_channel.currency.translation.customFields` , `sales_channel.currency.translation` . created_at as `sales_channel.currency.translation.createdAt` , `sales_channel.currency.translation` . updated_at as `sales_channel.currency.translation.updatedAt` , `sales_channel.currency.translation` . currency_id as `sales_channel.currency.translation.currencyId` , `sales_channel.currency.translation` . language_id as `sales_channel.currency.translation.languageId` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation` . `currency_id` = `sales_channel.currency` . `id` WHERE `sales_channel` . `id` IN (0x2F9B056E1C484931A120DFE36BF5AA13 );
Copy
0.81 ms
1
SELECT `shipping_method` . `id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method` . `id` = `shipping_method.salesChannels.mapping` . `shipping_method_id` LEFT JOIN (SELECT `shipping_method.translation` . shipping_method_id , `shipping_method.translation` . name as `shipping_method.translation.name` , `shipping_method.translation` . description as `shipping_method.translation.description` , `shipping_method.translation` . tracking_url as `shipping_method.translation.trackingUrl` , `shipping_method.translation` . custom_fields as `shipping_method.translation.customFields` , `shipping_method.translation` . created_at as `shipping_method.translation.createdAt` , `shipping_method.translation` . updated_at as `shipping_method.translation.updatedAt` , `shipping_method.translation` . shipping_method_id as `shipping_method.translation.shippingMethodId` , `shipping_method.translation` . language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation` . language_id = ? ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping` . `sales_channel_id` = `shipping_method.salesChannels` . `id` WHERE (`shipping_method` . `active` = ? AND `shipping_method.salesChannels` . `id` = ? ) GROUP BY `shipping_method` . `id` ORDER BY MIN (`shipping_method` . `position` ) ASC , MIN (COALESCE (`shipping_method.translation.name` )) ASC
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
true
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT `shipping_method` . `id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method` . `id` = `shipping_method.salesChannels.mapping` . `shipping_method_id` LEFT JOIN (SELECT `shipping_method.translation` . shipping_method_id , `shipping_method.translation` . name as `shipping_method.translation.name` , `shipping_method.translation` . description as `shipping_method.translation.description` , `shipping_method.translation` . tracking_url as `shipping_method.translation.trackingUrl` , `shipping_method.translation` . custom_fields as `shipping_method.translation.customFields` , `shipping_method.translation` . created_at as `shipping_method.translation.createdAt` , `shipping_method.translation` . updated_at as `shipping_method.translation.updatedAt` , `shipping_method.translation` . shipping_method_id as `shipping_method.translation.shippingMethodId` , `shipping_method.translation` . language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation` . `shipping_method_id` = `shipping_method` . `id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping` . `sales_channel_id` = `shipping_method.salesChannels` . `id` WHERE (`shipping_method` . `active` = 1 AND `shipping_method.salesChannels` . `id` = 0x2F9B056E1C484931A120DFE36BF5AA13 ) GROUP BY `shipping_method` . `id` ORDER BY MIN (`shipping_method` . `position` ) ASC , MIN (COALESCE (`shipping_method.translation.name` )) ASC ;
Copy
0.78 ms
1
SELECT `payment_method` . `id` as `payment_method.id` , `payment_method` . `plugin_id` as `payment_method.pluginId` , `payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` , `payment_method` . `position` as `payment_method.position` , `payment_method` . `active` as `payment_method.active` , `payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` , `payment_method` . `media_id` as `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.media` . `id` as `payment_method.media.id` , `payment_method.media` . `user_id` as `payment_method.media.userId` , `payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` as `payment_method.media.mimeType` , `payment_method.media` . `file_extension` as `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` as `payment_method.media.fileName` , `payment_method.media` . `file_size` as `payment_method.media.fileSize` , `payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` as `payment_method.media.metaData` , `payment_method.media` . `path` as `payment_method.media.path` , `payment_method.media` . `private` as `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` as `payment_method.media.createdAt` , `payment_method.media` . `updated_at` as `payment_method.media.updatedAt` , `payment_method.media.translation.title` , COALESCE (`payment_method.media.translation.title` , `payment_method.media.translation.title` ) as `payment_method.media.title` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.alt` , `payment_method.media.translation.alt` ) as `payment_method.media.alt` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` ) as `payment_method.media.customFields` , `payment_method.media.translation.createdAt` , `payment_method.media.translation.updatedAt` , `payment_method.media.translation.mediaId` , `payment_method.media.translation.languageId` , `payment_method.translation.name` , COALESCE (`payment_method.translation.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.description` , COALESCE (`payment_method.translation.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` , `payment_method.translation.createdAt` , `payment_method.translation.updatedAt` , `payment_method.translation.paymentMethodId` , `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation` . payment_method_id , `payment_method.translation` . name as `payment_method.translation.name` , `payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` , `payment_method.translation` . description as `payment_method.translation.description` , `payment_method.translation` . custom_fields as `payment_method.translation.customFields` , `payment_method.translation` . created_at as `payment_method.translation.createdAt` , `payment_method.translation` . updated_at as `payment_method.translation.updatedAt` , `payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` , `payment_method.translation` . language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation` . language_id = ? ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.media.translation` . media_id , `payment_method.media.translation` . title as `payment_method.media.translation.title` , `payment_method.media.translation` . alt as `payment_method.media.translation.alt` , `payment_method.media.translation` . custom_fields as `payment_method.media.translation.customFields` , `payment_method.media.translation` . created_at as `payment_method.media.translation.createdAt` , `payment_method.media.translation` . updated_at as `payment_method.media.translation.updatedAt` , `payment_method.media.translation` . media_id as `payment_method.media.translation.mediaId` , `payment_method.media.translation` . language_id as `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation` . language_id = ? ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"¯aŽ6ÈÍC§…Ù^7ÿÉì\x0E "
]
SELECT
`payment_method` . `id` as `payment_method.id` ,
`payment_method` . `plugin_id` as `payment_method.pluginId` ,
`payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` ,
`payment_method` . `position` as `payment_method.position` ,
`payment_method` . `active` as `payment_method.active` ,
`payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` ,
`payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` ,
`payment_method` . `media_id` as `payment_method.mediaId` ,
`payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` ,
`payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` ,
`payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` ,
`payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` ,
`payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` ,
`payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` ,
`payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` ,
`payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` ,
`payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` ,
`payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` ,
`payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` ,
`payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` ,
`payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` ,
`payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` ,
`payment_method` . `technical_name` as `payment_method.technicalName` ,
`payment_method` . `created_at` as `payment_method.createdAt` ,
`payment_method` . `updated_at` as `payment_method.updatedAt` ,
`payment_method.media` . `id` as `payment_method.media.id` ,
`payment_method.media` . `user_id` as `payment_method.media.userId` ,
`payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` ,
`payment_method.media` . `mime_type` as `payment_method.media.mimeType` ,
`payment_method.media` . `file_extension` as `payment_method.media.fileExtension` ,
`payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` ,
`payment_method.media` . `file_name` as `payment_method.media.fileName` ,
`payment_method.media` . `file_size` as `payment_method.media.fileSize` ,
`payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` ,
`payment_method.media` . `meta_data` as `payment_method.media.metaData` ,
`payment_method.media` . `path` as `payment_method.media.path` ,
`payment_method.media` . `private` as `payment_method.media.private` ,
`payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` ,
`payment_method.media` . `created_at` as `payment_method.media.createdAt` ,
`payment_method.media` . `updated_at` as `payment_method.media.updatedAt` ,
`payment_method.media.translation.title` ,
COALESCE (
`payment_method.media.translation.title` ,
`payment_method.media.translation.title`
) as `payment_method.media.title` ,
`payment_method.media.translation.alt` ,
COALESCE (
`payment_method.media.translation.alt` ,
`payment_method.media.translation.alt`
) as `payment_method.media.alt` ,
`payment_method.media.translation.customFields` ,
COALESCE (
`payment_method.media.translation.customFields` ,
`payment_method.media.translation.customFields`
) as `payment_method.media.customFields` ,
`payment_method.media.translation.createdAt` ,
`payment_method.media.translation.updatedAt` ,
`payment_method.media.translation.mediaId` ,
`payment_method.media.translation.languageId` ,
`payment_method.translation.name` ,
COALESCE (
`payment_method.translation.name` ,
`payment_method.translation.name`
) as `payment_method.name` ,
`payment_method.translation.distinguishableName` ,
COALESCE (
`payment_method.translation.distinguishableName` ,
`payment_method.translation.distinguishableName`
) as `payment_method.distinguishableName` ,
`payment_method.translation.description` ,
COALESCE (
`payment_method.translation.description` ,
`payment_method.translation.description`
) as `payment_method.description` ,
`payment_method.translation.customFields` ,
COALESCE (
`payment_method.translation.customFields` ,
`payment_method.translation.customFields`
) as `payment_method.customFields` ,
`payment_method.translation.createdAt` ,
`payment_method.translation.updatedAt` ,
`payment_method.translation.paymentMethodId` ,
`payment_method.translation.languageId`
FROM
`payment_method`
LEFT JOIN (
SELECT
`payment_method.translation` . payment_method_id ,
`payment_method.translation` . name as `payment_method.translation.name` ,
`payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` ,
`payment_method.translation` . description as `payment_method.translation.description` ,
`payment_method.translation` . custom_fields as `payment_method.translation.customFields` ,
`payment_method.translation` . created_at as `payment_method.translation.createdAt` ,
`payment_method.translation` . updated_at as `payment_method.translation.updatedAt` ,
`payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` ,
`payment_method.translation` . language_id as `payment_method.translation.languageId`
FROM
`payment_method_translation` `payment_method.translation`
WHERE
`payment_method.translation` . language_id = ?
) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id`
LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id`
LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id`
LEFT JOIN (
SELECT
`payment_method.media.translation` . media_id ,
`payment_method.media.translation` . title as `payment_method.media.translation.title` ,
`payment_method.media.translation` . alt as `payment_method.media.translation.alt` ,
`payment_method.media.translation` . custom_fields as `payment_method.media.translation.customFields` ,
`payment_method.media.translation` . created_at as `payment_method.media.translation.createdAt` ,
`payment_method.media.translation` . updated_at as `payment_method.media.translation.updatedAt` ,
`payment_method.media.translation` . media_id as `payment_method.media.translation.mediaId` ,
`payment_method.media.translation` . language_id as `payment_method.media.translation.languageId`
FROM
`media_translation` `payment_method.media.translation`
WHERE
`payment_method.media.translation` . language_id = ?
) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id`
WHERE
`payment_method` . `id` IN (? )
Copy
SELECT `payment_method` . `id` as `payment_method.id` , `payment_method` . `plugin_id` as `payment_method.pluginId` , `payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` , `payment_method` . `position` as `payment_method.position` , `payment_method` . `active` as `payment_method.active` , `payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` , `payment_method` . `media_id` as `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.media` . `id` as `payment_method.media.id` , `payment_method.media` . `user_id` as `payment_method.media.userId` , `payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` as `payment_method.media.mimeType` , `payment_method.media` . `file_extension` as `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` as `payment_method.media.fileName` , `payment_method.media` . `file_size` as `payment_method.media.fileSize` , `payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` as `payment_method.media.metaData` , `payment_method.media` . `path` as `payment_method.media.path` , `payment_method.media` . `private` as `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` as `payment_method.media.createdAt` , `payment_method.media` . `updated_at` as `payment_method.media.updatedAt` , `payment_method.media.translation.title` , COALESCE (`payment_method.media.translation.title` , `payment_method.media.translation.title` ) as `payment_method.media.title` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.alt` , `payment_method.media.translation.alt` ) as `payment_method.media.alt` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` ) as `payment_method.media.customFields` , `payment_method.media.translation.createdAt` , `payment_method.media.translation.updatedAt` , `payment_method.media.translation.mediaId` , `payment_method.media.translation.languageId` , `payment_method.translation.name` , COALESCE (`payment_method.translation.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.description` , COALESCE (`payment_method.translation.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` , `payment_method.translation.createdAt` , `payment_method.translation.updatedAt` , `payment_method.translation.paymentMethodId` , `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation` . payment_method_id , `payment_method.translation` . name as `payment_method.translation.name` , `payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` , `payment_method.translation` . description as `payment_method.translation.description` , `payment_method.translation` . custom_fields as `payment_method.translation.customFields` , `payment_method.translation` . created_at as `payment_method.translation.createdAt` , `payment_method.translation` . updated_at as `payment_method.translation.updatedAt` , `payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` , `payment_method.translation` . language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.media.translation` . media_id , `payment_method.media.translation` . title as `payment_method.media.translation.title` , `payment_method.media.translation` . alt as `payment_method.media.translation.alt` , `payment_method.media.translation` . custom_fields as `payment_method.media.translation.customFields` , `payment_method.media.translation` . created_at as `payment_method.media.translation.createdAt` , `payment_method.media.translation` . updated_at as `payment_method.media.translation.updatedAt` , `payment_method.media.translation` . media_id as `payment_method.media.translation.mediaId` , `payment_method.media.translation` . language_id as `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (0xAF618E36C8CD43A785D95E37FFC9EC0E );
Copy
0.78 ms
1
SELECT `language` . `id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language` . `id` = `language.salesChannelDomains` . `language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language` . `id` = `language.salesChannels.mapping` . `language_id` LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping` . `sales_channel_id` = `language.salesChannels` . `id` WHERE (`language.salesChannelDomains` . `sales_channel_id` = ? AND `language.salesChannels` . `id` = ? ) GROUP BY `language` . `id` ORDER BY MIN (`language` . `name` ) ASC
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT `language` . `id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language` . `id` = `language.salesChannelDomains` . `language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language` . `id` = `language.salesChannels.mapping` . `language_id` LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping` . `sales_channel_id` = `language.salesChannels` . `id` WHERE (`language.salesChannelDomains` . `sales_channel_id` = 0x2F9B056E1C484931A120DFE36BF5AA13 AND `language.salesChannels` . `id` = 0x2F9B056E1C484931A120DFE36BF5AA13 ) GROUP BY `language` . `id` ORDER BY MIN (`language` . `name` ) ASC ;
Copy
0.77 ms
3
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters :
[
b"""
eÿ¦’úYHÓŽ†\n
]\v œ¦\x16
"""
b"""
eÿ¦’úYHÓŽ†\n
]\v œ¦\x16
"""
b"""
eÿ¦’úYHÓŽ†\n
]\v œ¦\x16
"""
]
SELECT LOWER (HEX (`id` )), `path` , `level`
FROM `category`
WHERE `id` = 0x65FFA692FA5948D38E860A5D0B9CA616 OR `parent_id` = 0x65FFA692FA5948D38E860A5D0B9CA616 OR `id` = 0x65FFA692FA5948D38E860A5D0B9CA616
;
Copy
0.72 ms
1
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters :
[
"payload "
]
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload' ; Copy
0.68 ms
1
SELECT CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) `key` , CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) url , LOWER (HEX (domain . id )) id , LOWER (HEX (sales_channel . id )) salesChannelId , LOWER (HEX (sales_channel . type_id )) typeId , LOWER (HEX (domain . snippet_set_id )) snippetSetId , LOWER (HEX (domain . currency_id )) currencyId , LOWER (HEX (domain . language_id )) languageId , LOWER (HEX (theme . id )) themeId , sales_channel . maintenance maintenance , sales_channel . maintenance_ip_whitelist maintenanceIpWhitelist , snippet_set . iso as locale , theme . technical_name as themeName , parentTheme . technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain . sales_channel_id = sales_channel . id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel . id = theme_sales_channel . sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set . id = domain . snippet_set_id LEFT JOIN theme theme ON theme_sales_channel . theme_id = theme . id LEFT JOIN theme parentTheme ON theme . parent_theme_id = parentTheme . id WHERE (sales_channel . type_id = UNHEX (? )) AND (sales_channel . active )
Parameters :
[
"8a243080f92e4c719546314b577cf82b "
]
SELECT CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) `key` , CONCAT (TRIM (TRAILING '/' FROM domain . url ), '/' ) url , LOWER (HEX (domain . id )) id , LOWER (HEX (sales_channel . id )) salesChannelId , LOWER (HEX (sales_channel . type_id )) typeId , LOWER (HEX (domain . snippet_set_id )) snippetSetId , LOWER (HEX (domain . currency_id )) currencyId , LOWER (HEX (domain . language_id )) languageId , LOWER (HEX (theme . id )) themeId , sales_channel . maintenance maintenance , sales_channel . maintenance_ip_whitelist maintenanceIpWhitelist , snippet_set . iso as locale , theme . technical_name as themeName , parentTheme . technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain . sales_channel_id = sales_channel . id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel . id = theme_sales_channel . sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set . id = domain . snippet_set_id LEFT JOIN theme theme ON theme_sales_channel . theme_id = theme . id LEFT JOIN theme parentTheme ON theme . parent_theme_id = parentTheme . id WHERE (sales_channel . type_id = UNHEX ('8a243080f92e4c719546314b577cf82b' )) AND (sales_channel . active ); Copy
0.61 ms
1
SELECT `payment_method` . `id` as `payment_method.id` , `payment_method` . `plugin_id` as `payment_method.pluginId` , `payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` , `payment_method` . `position` as `payment_method.position` , `payment_method` . `active` as `payment_method.active` , `payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` , `payment_method` . `media_id` as `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.media` . `id` as `payment_method.media.id` , `payment_method.media` . `user_id` as `payment_method.media.userId` , `payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` as `payment_method.media.mimeType` , `payment_method.media` . `file_extension` as `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` as `payment_method.media.fileName` , `payment_method.media` . `file_size` as `payment_method.media.fileSize` , `payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` as `payment_method.media.metaData` , `payment_method.media` . `path` as `payment_method.media.path` , `payment_method.media` . `private` as `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` as `payment_method.media.createdAt` , `payment_method.media` . `updated_at` as `payment_method.media.updatedAt` , `payment_method.media.translation.title` , COALESCE (`payment_method.media.translation.title` , `payment_method.media.translation.title` ) as `payment_method.media.title` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.alt` , `payment_method.media.translation.alt` ) as `payment_method.media.alt` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` ) as `payment_method.media.customFields` , `payment_method.media.translation.createdAt` , `payment_method.media.translation.updatedAt` , `payment_method.media.translation.mediaId` , `payment_method.media.translation.languageId` , `payment_method.translation.name` , COALESCE (`payment_method.translation.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.description` , COALESCE (`payment_method.translation.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` , `payment_method.translation.createdAt` , `payment_method.translation.updatedAt` , `payment_method.translation.paymentMethodId` , `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation` . payment_method_id , `payment_method.translation` . name as `payment_method.translation.name` , `payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` , `payment_method.translation` . description as `payment_method.translation.description` , `payment_method.translation` . custom_fields as `payment_method.translation.customFields` , `payment_method.translation` . created_at as `payment_method.translation.createdAt` , `payment_method.translation` . updated_at as `payment_method.translation.updatedAt` , `payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` , `payment_method.translation` . language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation` . language_id = ? ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.media.translation` . media_id , `payment_method.media.translation` . title as `payment_method.media.translation.title` , `payment_method.media.translation` . alt as `payment_method.media.translation.alt` , `payment_method.media.translation` . custom_fields as `payment_method.media.translation.customFields` , `payment_method.media.translation` . created_at as `payment_method.media.translation.createdAt` , `payment_method.media.translation` . updated_at as `payment_method.media.translation.updatedAt` , `payment_method.media.translation` . media_id as `payment_method.media.translation.mediaId` , `payment_method.media.translation` . language_id as `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation` . language_id = ? ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
b"¯aŽ6ÈÍC§…Ù^7ÿÉì\x0E "
b"U¦┼O¨eB═Ø:}¨ÃÛÇ\x1E "
]
SELECT
`payment_method` . `id` as `payment_method.id` ,
`payment_method` . `plugin_id` as `payment_method.pluginId` ,
`payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` ,
`payment_method` . `position` as `payment_method.position` ,
`payment_method` . `active` as `payment_method.active` ,
`payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` ,
`payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` ,
`payment_method` . `media_id` as `payment_method.mediaId` ,
`payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` ,
`payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` ,
`payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` ,
`payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` ,
`payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` ,
`payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` ,
`payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` ,
`payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` ,
`payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` ,
`payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` ,
`payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` ,
`payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` ,
`payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` ,
`payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` ,
`payment_method` . `technical_name` as `payment_method.technicalName` ,
`payment_method` . `created_at` as `payment_method.createdAt` ,
`payment_method` . `updated_at` as `payment_method.updatedAt` ,
`payment_method.media` . `id` as `payment_method.media.id` ,
`payment_method.media` . `user_id` as `payment_method.media.userId` ,
`payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` ,
`payment_method.media` . `mime_type` as `payment_method.media.mimeType` ,
`payment_method.media` . `file_extension` as `payment_method.media.fileExtension` ,
`payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` ,
`payment_method.media` . `file_name` as `payment_method.media.fileName` ,
`payment_method.media` . `file_size` as `payment_method.media.fileSize` ,
`payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` ,
`payment_method.media` . `meta_data` as `payment_method.media.metaData` ,
`payment_method.media` . `path` as `payment_method.media.path` ,
`payment_method.media` . `private` as `payment_method.media.private` ,
`payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` ,
`payment_method.media` . `created_at` as `payment_method.media.createdAt` ,
`payment_method.media` . `updated_at` as `payment_method.media.updatedAt` ,
`payment_method.media.translation.title` ,
COALESCE (
`payment_method.media.translation.title` ,
`payment_method.media.translation.title`
) as `payment_method.media.title` ,
`payment_method.media.translation.alt` ,
COALESCE (
`payment_method.media.translation.alt` ,
`payment_method.media.translation.alt`
) as `payment_method.media.alt` ,
`payment_method.media.translation.customFields` ,
COALESCE (
`payment_method.media.translation.customFields` ,
`payment_method.media.translation.customFields`
) as `payment_method.media.customFields` ,
`payment_method.media.translation.createdAt` ,
`payment_method.media.translation.updatedAt` ,
`payment_method.media.translation.mediaId` ,
`payment_method.media.translation.languageId` ,
`payment_method.translation.name` ,
COALESCE (
`payment_method.translation.name` ,
`payment_method.translation.name`
) as `payment_method.name` ,
`payment_method.translation.distinguishableName` ,
COALESCE (
`payment_method.translation.distinguishableName` ,
`payment_method.translation.distinguishableName`
) as `payment_method.distinguishableName` ,
`payment_method.translation.description` ,
COALESCE (
`payment_method.translation.description` ,
`payment_method.translation.description`
) as `payment_method.description` ,
`payment_method.translation.customFields` ,
COALESCE (
`payment_method.translation.customFields` ,
`payment_method.translation.customFields`
) as `payment_method.customFields` ,
`payment_method.translation.createdAt` ,
`payment_method.translation.updatedAt` ,
`payment_method.translation.paymentMethodId` ,
`payment_method.translation.languageId`
FROM
`payment_method`
LEFT JOIN (
SELECT
`payment_method.translation` . payment_method_id ,
`payment_method.translation` . name as `payment_method.translation.name` ,
`payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` ,
`payment_method.translation` . description as `payment_method.translation.description` ,
`payment_method.translation` . custom_fields as `payment_method.translation.customFields` ,
`payment_method.translation` . created_at as `payment_method.translation.createdAt` ,
`payment_method.translation` . updated_at as `payment_method.translation.updatedAt` ,
`payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` ,
`payment_method.translation` . language_id as `payment_method.translation.languageId`
FROM
`payment_method_translation` `payment_method.translation`
WHERE
`payment_method.translation` . language_id = ?
) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id`
LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id`
LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id`
LEFT JOIN (
SELECT
`payment_method.media.translation` . media_id ,
`payment_method.media.translation` . title as `payment_method.media.translation.title` ,
`payment_method.media.translation` . alt as `payment_method.media.translation.alt` ,
`payment_method.media.translation` . custom_fields as `payment_method.media.translation.customFields` ,
`payment_method.media.translation` . created_at as `payment_method.media.translation.createdAt` ,
`payment_method.media.translation` . updated_at as `payment_method.media.translation.updatedAt` ,
`payment_method.media.translation` . media_id as `payment_method.media.translation.mediaId` ,
`payment_method.media.translation` . language_id as `payment_method.media.translation.languageId`
FROM
`media_translation` `payment_method.media.translation`
WHERE
`payment_method.media.translation` . language_id = ?
) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id`
WHERE
`payment_method` . `id` IN (? , ? )
Copy
SELECT `payment_method` . `id` as `payment_method.id` , `payment_method` . `plugin_id` as `payment_method.pluginId` , `payment_method` . `handler_identifier` as `payment_method.handlerIdentifier` , `payment_method` . `position` as `payment_method.position` , `payment_method` . `active` as `payment_method.active` , `payment_method` . `after_order_enabled` as `payment_method.afterOrderEnabled` , `payment_method` . `availability_rule_id` as `payment_method.availabilityRuleId` , `payment_method` . `media_id` as `payment_method.mediaId` , `payment_method.appPaymentMethod` . `id` as `payment_method.appPaymentMethod.id` , `payment_method.appPaymentMethod` . `app_name` as `payment_method.appPaymentMethod.appName` , `payment_method.appPaymentMethod` . `identifier` as `payment_method.appPaymentMethod.identifier` , `payment_method.appPaymentMethod` . `pay_url` as `payment_method.appPaymentMethod.payUrl` , `payment_method.appPaymentMethod` . `finalize_url` as `payment_method.appPaymentMethod.finalizeUrl` , `payment_method.appPaymentMethod` . `validate_url` as `payment_method.appPaymentMethod.validateUrl` , `payment_method.appPaymentMethod` . `capture_url` as `payment_method.appPaymentMethod.captureUrl` , `payment_method.appPaymentMethod` . `refund_url` as `payment_method.appPaymentMethod.refundUrl` , `payment_method.appPaymentMethod` . `recurring_url` as `payment_method.appPaymentMethod.recurringUrl` , `payment_method.appPaymentMethod` . `app_id` as `payment_method.appPaymentMethod.appId` , `payment_method.appPaymentMethod` . `original_media_id` as `payment_method.appPaymentMethod.originalMediaId` , `payment_method.appPaymentMethod` . `payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId` , `payment_method.appPaymentMethod` . `created_at` as `payment_method.appPaymentMethod.createdAt` , `payment_method.appPaymentMethod` . `updated_at` as `payment_method.appPaymentMethod.updatedAt` , `payment_method` . `technical_name` as `payment_method.technicalName` , `payment_method` . `created_at` as `payment_method.createdAt` , `payment_method` . `updated_at` as `payment_method.updatedAt` , `payment_method.media` . `id` as `payment_method.media.id` , `payment_method.media` . `user_id` as `payment_method.media.userId` , `payment_method.media` . `media_folder_id` as `payment_method.media.mediaFolderId` , `payment_method.media` . `mime_type` as `payment_method.media.mimeType` , `payment_method.media` . `file_extension` as `payment_method.media.fileExtension` , `payment_method.media` . `uploaded_at` as `payment_method.media.uploadedAt` , `payment_method.media` . `file_name` as `payment_method.media.fileName` , `payment_method.media` . `file_size` as `payment_method.media.fileSize` , `payment_method.media` . `media_type` as `payment_method.media.mediaTypeRaw` , `payment_method.media` . `meta_data` as `payment_method.media.metaData` , `payment_method.media` . `path` as `payment_method.media.path` , `payment_method.media` . `private` as `payment_method.media.private` , `payment_method.media` . `thumbnails_ro` as `payment_method.media.thumbnailsRo` , `payment_method.media` . `created_at` as `payment_method.media.createdAt` , `payment_method.media` . `updated_at` as `payment_method.media.updatedAt` , `payment_method.media.translation.title` , COALESCE (`payment_method.media.translation.title` , `payment_method.media.translation.title` ) as `payment_method.media.title` , `payment_method.media.translation.alt` , COALESCE (`payment_method.media.translation.alt` , `payment_method.media.translation.alt` ) as `payment_method.media.alt` , `payment_method.media.translation.customFields` , COALESCE (`payment_method.media.translation.customFields` , `payment_method.media.translation.customFields` ) as `payment_method.media.customFields` , `payment_method.media.translation.createdAt` , `payment_method.media.translation.updatedAt` , `payment_method.media.translation.mediaId` , `payment_method.media.translation.languageId` , `payment_method.translation.name` , COALESCE (`payment_method.translation.name` , `payment_method.translation.name` ) as `payment_method.name` , `payment_method.translation.distinguishableName` , COALESCE (`payment_method.translation.distinguishableName` , `payment_method.translation.distinguishableName` ) as `payment_method.distinguishableName` , `payment_method.translation.description` , COALESCE (`payment_method.translation.description` , `payment_method.translation.description` ) as `payment_method.description` , `payment_method.translation.customFields` , COALESCE (`payment_method.translation.customFields` , `payment_method.translation.customFields` ) as `payment_method.customFields` , `payment_method.translation.createdAt` , `payment_method.translation.updatedAt` , `payment_method.translation.paymentMethodId` , `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation` . payment_method_id , `payment_method.translation` . name as `payment_method.translation.name` , `payment_method.translation` . distinguishable_name as `payment_method.translation.distinguishableName` , `payment_method.translation` . description as `payment_method.translation.description` , `payment_method.translation` . custom_fields as `payment_method.translation.customFields` , `payment_method.translation` . created_at as `payment_method.translation.createdAt` , `payment_method.translation` . updated_at as `payment_method.translation.updatedAt` , `payment_method.translation` . payment_method_id as `payment_method.translation.paymentMethodId` , `payment_method.translation` . language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation` . `payment_method_id` = `payment_method` . `id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method` . `id` = `payment_method.appPaymentMethod` . `payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method` . `media_id` = `payment_method.media` . `id` LEFT JOIN (SELECT `payment_method.media.translation` . media_id , `payment_method.media.translation` . title as `payment_method.media.translation.title` , `payment_method.media.translation` . alt as `payment_method.media.translation.alt` , `payment_method.media.translation` . custom_fields as `payment_method.media.translation.customFields` , `payment_method.media.translation` . created_at as `payment_method.media.translation.createdAt` , `payment_method.media.translation` . updated_at as `payment_method.media.translation.updatedAt` , `payment_method.media.translation` . media_id as `payment_method.media.translation.mediaId` , `payment_method.media.translation` . language_id as `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `payment_method.media.media_translation` ON `payment_method.media.media_translation` . `media_id` = `payment_method.media` . `id` WHERE `payment_method` . `id` IN (0xAF618E36C8CD43A785D95E37FFC9EC0E , 0x55DDC54FF96542CD9D3A7DF9C7EA801E );
Copy
0.57 ms
1
SELECT custom_entity . name , custom_entity . fields , custom_entity . flags
FROM custom_entity
LEFT JOIN app ON app . id = custom_entity . app_id
WHERE (custom_entity . app_id IS NULL OR app . active = 1 ) AND custom_entity . deleted_at IS NULL ;
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
0.52 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC ; Copy
0.50 ms
1
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` , `language.productSearchConfig` . `id` as `language.productSearchConfig.id` , `language.productSearchConfig` . `language_id` as `language.productSearchConfig.languageId` , `language.productSearchConfig` . `and_logic` as `language.productSearchConfig.andLogic` , `language.productSearchConfig` . `min_search_length` as `language.productSearchConfig.minSearchLength` , `language.productSearchConfig` . `excluded_terms` as `language.productSearchConfig.excludedTerms` , `language.productSearchConfig` . `created_at` as `language.productSearchConfig.createdAt` , `language.productSearchConfig` . `updated_at` as `language.productSearchConfig.updatedAt` , `language.translationCode` . `id` as `language.translationCode.id` , `language.translationCode` . `code` as `language.translationCode.code` , `language.translationCode` . `created_at` as `language.translationCode.createdAt` , `language.translationCode` . `updated_at` as `language.translationCode.updatedAt` , `language.translationCode.translation.name` , COALESCE (`language.translationCode.translation.name` , `language.translationCode.translation.name` ) as `language.translationCode.name` , `language.translationCode.translation.territory` , COALESCE (`language.translationCode.translation.territory` , `language.translationCode.translation.territory` ) as `language.translationCode.territory` , `language.translationCode.translation.customFields` , COALESCE (`language.translationCode.translation.customFields` , `language.translationCode.translation.customFields` ) as `language.translationCode.customFields` , `language.translationCode.translation.createdAt` , `language.translationCode.translation.updatedAt` , `language.translationCode.translation.localeId` , `language.translationCode.translation.languageId` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language` . `id` = `language.productSearchConfig` . `language_id` LEFT JOIN `locale` `language.translationCode` ON `language` . `translation_code_id` = `language.translationCode` . `id` LEFT JOIN (SELECT `language.translationCode.translation` . locale_id , `language.translationCode.translation` . name as `language.translationCode.translation.name` , `language.translationCode.translation` . territory as `language.translationCode.translation.territory` , `language.translationCode.translation` . custom_fields as `language.translationCode.translation.customFields` , `language.translationCode.translation` . created_at as `language.translationCode.translation.createdAt` , `language.translationCode.translation` . updated_at as `language.translationCode.translation.updatedAt` , `language.translationCode.translation` . locale_id as `language.translationCode.translation.localeId` , `language.translationCode.translation` . language_id as `language.translationCode.translation.languageId` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation` . language_id = ? ) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation` . `locale_id` = `language.translationCode` . `id` WHERE `language` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` , `language.productSearchConfig` . `id` as `language.productSearchConfig.id` , `language.productSearchConfig` . `language_id` as `language.productSearchConfig.languageId` , `language.productSearchConfig` . `and_logic` as `language.productSearchConfig.andLogic` , `language.productSearchConfig` . `min_search_length` as `language.productSearchConfig.minSearchLength` , `language.productSearchConfig` . `excluded_terms` as `language.productSearchConfig.excludedTerms` , `language.productSearchConfig` . `created_at` as `language.productSearchConfig.createdAt` , `language.productSearchConfig` . `updated_at` as `language.productSearchConfig.updatedAt` , `language.translationCode` . `id` as `language.translationCode.id` , `language.translationCode` . `code` as `language.translationCode.code` , `language.translationCode` . `created_at` as `language.translationCode.createdAt` , `language.translationCode` . `updated_at` as `language.translationCode.updatedAt` , `language.translationCode.translation.name` , COALESCE (`language.translationCode.translation.name` , `language.translationCode.translation.name` ) as `language.translationCode.name` , `language.translationCode.translation.territory` , COALESCE (`language.translationCode.translation.territory` , `language.translationCode.translation.territory` ) as `language.translationCode.territory` , `language.translationCode.translation.customFields` , COALESCE (`language.translationCode.translation.customFields` , `language.translationCode.translation.customFields` ) as `language.translationCode.customFields` , `language.translationCode.translation.createdAt` , `language.translationCode.translation.updatedAt` , `language.translationCode.translation.localeId` , `language.translationCode.translation.languageId` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language` . `id` = `language.productSearchConfig` . `language_id` LEFT JOIN `locale` `language.translationCode` ON `language` . `translation_code_id` = `language.translationCode` . `id` LEFT JOIN (SELECT `language.translationCode.translation` . locale_id , `language.translationCode.translation` . name as `language.translationCode.translation.name` , `language.translationCode.translation` . territory as `language.translationCode.translation.territory` , `language.translationCode.translation` . custom_fields as `language.translationCode.translation.customFields` , `language.translationCode.translation` . created_at as `language.translationCode.translation.createdAt` , `language.translationCode.translation` . updated_at as `language.translationCode.translation.updatedAt` , `language.translationCode.translation` . locale_id as `language.translationCode.translation.localeId` , `language.translationCode.translation` . language_id as `language.translationCode.translation.languageId` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation` . `locale_id` = `language.translationCode` . `id` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B );
Copy
0.49 ms
1
SELECT `tax_rule` . `id` as `tax_rule.id` , `tax_rule` . `tax_rule_type_id` as `tax_rule.taxRuleTypeId` , `tax_rule` . `country_id` as `tax_rule.countryId` , `tax_rule` . `tax_rate` as `tax_rule.taxRate` , `tax_rule` . `data` as `tax_rule.data` , `tax_rule` . `tax_id` as `tax_rule.taxId` , `tax_rule` . `active_from` as `tax_rule.activeFrom` , `tax_rule.type` . `id` as `tax_rule.type.id` , `tax_rule.type` . `technical_name` as `tax_rule.type.technicalName` , `tax_rule.type` . `position` as `tax_rule.type.position` , `tax_rule.type` . `created_at` as `tax_rule.type.createdAt` , `tax_rule.type` . `updated_at` as `tax_rule.type.updatedAt` , `tax_rule.type.translation.typeName` , COALESCE (`tax_rule.type.translation.typeName` , `tax_rule.type.translation.typeName` ) as `tax_rule.type.typeName` , `tax_rule.type.translation.createdAt` , `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation.taxRuleTypeId` , `tax_rule.type.translation.languageId` , `tax_rule` . `created_at` as `tax_rule.createdAt` , `tax_rule` . `updated_at` as `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule` . `tax_rule_type_id` = `tax_rule.type` . `id` LEFT JOIN (SELECT `tax_rule.type.translation` . tax_rule_type_id , `tax_rule.type.translation` . type_name as `tax_rule.type.translation.typeName` , `tax_rule.type.translation` . created_at as `tax_rule.type.translation.createdAt` , `tax_rule.type.translation` . updated_at as `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation` . tax_rule_type_id as `tax_rule.type.translation.taxRuleTypeId` , `tax_rule.type.translation` . language_id as `tax_rule.type.translation.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation` . language_id = ? ) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation` . `tax_rule_type_id` = `tax_rule.type` . `id` WHERE (`tax_rule` . `tax_id` IN (? , ? , ? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"4ç¤‗Ä┌Oýë▓┌!÷É|³ "
b"¸•M&g\x10 Gf¹8©N½v\x1C ÿ "
b"ðþ-\t ▀ÇEâÅU$u┴Ãô² "
b"à\t ëÒðÉ@|¿þ\x18 €Œê€Ò "
]
SELECT `tax_rule` . `id` as `tax_rule.id` , `tax_rule` . `tax_rule_type_id` as `tax_rule.taxRuleTypeId` , `tax_rule` . `country_id` as `tax_rule.countryId` , `tax_rule` . `tax_rate` as `tax_rule.taxRate` , `tax_rule` . `data` as `tax_rule.data` , `tax_rule` . `tax_id` as `tax_rule.taxId` , `tax_rule` . `active_from` as `tax_rule.activeFrom` , `tax_rule.type` . `id` as `tax_rule.type.id` , `tax_rule.type` . `technical_name` as `tax_rule.type.technicalName` , `tax_rule.type` . `position` as `tax_rule.type.position` , `tax_rule.type` . `created_at` as `tax_rule.type.createdAt` , `tax_rule.type` . `updated_at` as `tax_rule.type.updatedAt` , `tax_rule.type.translation.typeName` , COALESCE (`tax_rule.type.translation.typeName` , `tax_rule.type.translation.typeName` ) as `tax_rule.type.typeName` , `tax_rule.type.translation.createdAt` , `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation.taxRuleTypeId` , `tax_rule.type.translation.languageId` , `tax_rule` . `created_at` as `tax_rule.createdAt` , `tax_rule` . `updated_at` as `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule` . `tax_rule_type_id` = `tax_rule.type` . `id` LEFT JOIN (SELECT `tax_rule.type.translation` . tax_rule_type_id , `tax_rule.type.translation` . type_name as `tax_rule.type.translation.typeName` , `tax_rule.type.translation` . created_at as `tax_rule.type.translation.createdAt` , `tax_rule.type.translation` . updated_at as `tax_rule.type.translation.updatedAt` , `tax_rule.type.translation` . tax_rule_type_id as `tax_rule.type.translation.taxRuleTypeId` , `tax_rule.type.translation` . language_id as `tax_rule.type.translation.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation` . `tax_rule_type_id` = `tax_rule.type` . `id` WHERE (`tax_rule` . `tax_id` IN (0x3487CFF28EDA4FEC89B2DA21F6907CFC , 0xB8954D2667104766B938A94EBD761CFF , 0xD0E72D09DF8045838F552475C1C793FD , 0xE009EBD2F0C9407CBFFE18808CEA80D2 ));
Copy
0.49 ms
1
SELECT `theme` . `id` as `theme.id` , `theme` . `technical_name` as `theme.technicalName` , `theme` . `name` as `theme.name` , `theme` . `author` as `theme.author` , `theme` . `preview_media_id` as `theme.previewMediaId` , `theme` . `parent_theme_id` as `theme.parentThemeId` , `theme` . `theme_json` as `theme.themeJson` , `theme` . `base_config` as `theme.baseConfig` , `theme` . `config_values` as `theme.configValues` , `theme` . `active` as `theme.active` , `theme` . `created_at` as `theme.createdAt` , `theme` . `updated_at` as `theme.updatedAt` , `theme.translation.description` , COALESCE (`theme.translation.description` , `theme.translation.description` ) as `theme.description` , `theme.translation.labels` , COALESCE (`theme.translation.labels` , `theme.translation.labels` ) as `theme.labels` , `theme.translation.helpTexts` , COALESCE (`theme.translation.helpTexts` , `theme.translation.helpTexts` ) as `theme.helpTexts` , `theme.translation.customFields` , COALESCE (`theme.translation.customFields` , `theme.translation.customFields` ) as `theme.customFields` , `theme.translation.createdAt` , `theme.translation.updatedAt` , `theme.translation.themeId` , `theme.translation.languageId` FROM `theme` LEFT JOIN (SELECT `theme.translation` . theme_id , `theme.translation` . description as `theme.translation.description` , `theme.translation` . labels as `theme.translation.labels` , `theme.translation` . help_texts as `theme.translation.helpTexts` , `theme.translation` . custom_fields as `theme.translation.customFields` , `theme.translation` . created_at as `theme.translation.createdAt` , `theme.translation` . updated_at as `theme.translation.updatedAt` , `theme.translation` . theme_id as `theme.translation.themeId` , `theme.translation` . language_id as `theme.translation.languageId` FROM `theme_translation` `theme.translation` WHERE `theme.translation` . language_id = ? ) `theme.theme_translation` ON `theme.theme_translation` . `theme_id` = `theme` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `theme` . `id` as `theme.id` , `theme` . `technical_name` as `theme.technicalName` , `theme` . `name` as `theme.name` , `theme` . `author` as `theme.author` , `theme` . `preview_media_id` as `theme.previewMediaId` , `theme` . `parent_theme_id` as `theme.parentThemeId` , `theme` . `theme_json` as `theme.themeJson` , `theme` . `base_config` as `theme.baseConfig` , `theme` . `config_values` as `theme.configValues` , `theme` . `active` as `theme.active` , `theme` . `created_at` as `theme.createdAt` , `theme` . `updated_at` as `theme.updatedAt` , `theme.translation.description` , COALESCE (`theme.translation.description` , `theme.translation.description` ) as `theme.description` , `theme.translation.labels` , COALESCE (`theme.translation.labels` , `theme.translation.labels` ) as `theme.labels` , `theme.translation.helpTexts` , COALESCE (`theme.translation.helpTexts` , `theme.translation.helpTexts` ) as `theme.helpTexts` , `theme.translation.customFields` , COALESCE (`theme.translation.customFields` , `theme.translation.customFields` ) as `theme.customFields` , `theme.translation.createdAt` , `theme.translation.updatedAt` , `theme.translation.themeId` , `theme.translation.languageId` FROM `theme` LEFT JOIN (SELECT `theme.translation` . theme_id , `theme.translation` . description as `theme.translation.description` , `theme.translation` . labels as `theme.translation.labels` , `theme.translation` . help_texts as `theme.translation.helpTexts` , `theme.translation` . custom_fields as `theme.translation.customFields` , `theme.translation` . created_at as `theme.translation.createdAt` , `theme.translation` . updated_at as `theme.translation.updatedAt` , `theme.translation` . theme_id as `theme.translation.themeId` , `theme.translation` . language_id as `theme.translation.languageId` FROM `theme_translation` `theme.translation` WHERE `theme.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `theme.theme_translation` ON `theme.theme_translation` . `theme_id` = `theme` . `id` ;
Copy
0.46 ms
1
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , COALESCE (`country.translation.name` , `country.translation.name` ) as `country.name` , `country.translation.addressFormat` , COALESCE (`country.translation.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.customFields` , COALESCE (`country.translation.customFields` , `country.translation.customFields` ) as `country.customFields` , `country.translation.createdAt` , `country.translation.updatedAt` , `country.translation.countryId` , `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation` . country_id , `country.translation` . name as `country.translation.name` , `country.translation` . address_format as `country.translation.addressFormat` , `country.translation` . custom_fields as `country.translation.customFields` , `country.translation` . created_at as `country.translation.createdAt` , `country.translation` . updated_at as `country.translation.updatedAt` , `country.translation` . country_id as `country.translation.countryId` , `country.translation` . language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation` . language_id = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x06 I\x11 IñTJ`ì `\x1C ¼Õ$\x0E \x07 ÓfxIV@¹§RÙ¸‰áHª\x12 c╠+Ë7C4┐·½└}╠°Ø\x18 %²╚hí@ØÜ<9m└í?\x18 \x1A …»Üš·KY¯wª¿\e ÒÓQ\e ~uú&ñKö„T9Øy\t M±\x1E Øàb?░N\f øú'[zFéó&ej\x17 É\x04 IPº‡oêÄpÓ» "
b"+┤À²µYD\x18 æ═¢█\x02 Sì& "
b"/\x03\x07\x7F rPJ‘£šh9\x13 Göf "
b"7]ÆZ‚rOn£º1\x07 ÃgY\x06 "
b"Bk\x08 G®ÌB%´›%K1 ž\x02 "
b"""
R\n
ø▒MLEËÅÖø┌>Égf
"""
b"uÔ\x19 ┐╝LIJüª\x1A ág┬w; "
b"y\x01 +µ0†HV„©LP±à•G "
b"|ÙEN÷\x13 E‚ŸRaûÈاà "
b"üVÚÞkîCÓÁ\x03 ╣.ê@ÄÛ "
b"ü■Ö^Ð\x12 Nwå¸zM÷\x04 áÕ "
b"‚túÿ*gMŒ¨\x01 ¹Û"Ã\r + "
b"ꤥ▄õÙH▒╝\x15 ]\x1E ²Åýo "
b"žéƒ(‘\x14 M9€ïã&Xèù "
b"""
¥,\x1A T4•@\¥\n
\e B\x17 üÞðª=óÏÅâHðê█!4ûìÞ└ "
b"0\x14 ,\x19 OKr˜ÜN—ÿfù\x00 "
b"Ý\x0E «Ý¨L\x7F ™WF\x14 s#Ä® "
b"¢\x04 ®K3ñN$Ø╠Gs=ê2\r "
b"ÎÄÂ8ÕsMP“nɽ¼{4Û "
b"ÔQÚs€ÛB\v ƒan¶Q6‡ "
b"ôK\”ÉZL¹’Î}f¯keé "
]
SELECT
`country` . `id` as `country.id` ,
`country` . `iso` as `country.iso` ,
`country` . `position` as `country.position` ,
`country` . `active` as `country.active` ,
`country` . `shipping_available` as `country.shippingAvailable` ,
`country` . `iso3` as `country.iso3` ,
`country` . `display_state_in_registration` as `country.displayStateInRegistration` ,
`country` . `force_state_in_registration` as `country.forceStateInRegistration` ,
`country` . `check_vat_id_pattern` as `country.checkVatIdPattern` ,
`country` . `vat_id_required` as `country.vatIdRequired` ,
`country` . `vat_id_pattern` as `country.vatIdPattern` ,
`country` . `customer_tax` as `country.customerTax` ,
`country` . `company_tax` as `country.companyTax` ,
`country` . `postal_code_required` as `country.postalCodeRequired` ,
`country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` ,
`country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` ,
`country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` ,
`country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` ,
`country` . `created_at` as `country.createdAt` ,
`country` . `updated_at` as `country.updatedAt` ,
`country.translation.name` ,
COALESCE (
`country.translation.name` , `country.translation.name`
) as `country.name` ,
`country.translation.addressFormat` ,
COALESCE (
`country.translation.addressFormat` ,
`country.translation.addressFormat`
) as `country.addressFormat` ,
`country.translation.customFields` ,
COALESCE (
`country.translation.customFields` ,
`country.translation.customFields`
) as `country.customFields` ,
`country.translation.createdAt` ,
`country.translation.updatedAt` ,
`country.translation.countryId` ,
`country.translation.languageId`
FROM
`country`
LEFT JOIN (
SELECT
`country.translation` . country_id ,
`country.translation` . name as `country.translation.name` ,
`country.translation` . address_format as `country.translation.addressFormat` ,
`country.translation` . custom_fields as `country.translation.customFields` ,
`country.translation` . created_at as `country.translation.createdAt` ,
`country.translation` . updated_at as `country.translation.updatedAt` ,
`country.translation` . country_id as `country.translation.countryId` ,
`country.translation` . language_id as `country.translation.languageId`
FROM
`country_translation` `country.translation`
WHERE
`country.translation` . language_id = ?
) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id`
WHERE
`country` . `id` IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
)Copy
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , COALESCE (`country.translation.name` , `country.translation.name` ) as `country.name` , `country.translation.addressFormat` , COALESCE (`country.translation.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.customFields` , COALESCE (`country.translation.customFields` , `country.translation.customFields` ) as `country.customFields` , `country.translation.createdAt` , `country.translation.updatedAt` , `country.translation.countryId` , `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation` . country_id , `country.translation` . name as `country.translation.name` , `country.translation` . address_format as `country.translation.addressFormat` , `country.translation` . custom_fields as `country.translation.customFields` , `country.translation` . created_at as `country.translation.createdAt` , `country.translation` . updated_at as `country.translation.updatedAt` , `country.translation` . country_id as `country.translation.countryId` , `country.translation` . language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x06491149A4544A608D20601CACE5240E , 0x07D36678495640B9A752D9B889E148AA , 0x1263CC2BD3374334BFFAABC07DCCF89D , 0x1825FDC868A1409D9A3C396DC0A13F18 , 0x1A85BBDC9AB74B59AF77AABF1BD2D351 , 0x1B7E75FA26F14BF6845439D879094DB1 , 0x1E9D85623FB04E0C9BA3275B7A4682A2 , 0x26656A17C9044950BA876FEAC470D3BB , 0x2BB4B7FDE659441891CDBDDB02538D26 , 0x2F03077F72504A91A39A68391347F666 , 0x375DC65A82724F6EA3BA3107C3675906 , 0x426B0847AECC4225B49B254B31209E02 , 0x520A9BB14D4C45D38F999BDA3E906766 , 0x75E219BFBC4C494A81A61AA067C2773B , 0x79012BB53086485684A94C50B1E09547 , 0x7CD9454EF71345829F5261FBC8D8A7E0 , 0x8156E9E86B8C43E0B503B92E88408EEA , 0x81FE995ED1124E7786F77A4DF604A0E5 , 0x8274FAFF2A674D8CA801B9DB22C30D2B , 0x88CFBEDCE4EB48B1BC155D1EFD8FEC6F , 0x9EE9832891144D3980EFE32658E8C3B9 , 0xA52C1A543495405CA50A1B4217FCDEF0 , 0xA63DA2D88F8348D088DB2134968DE8C0 , 0xAD30142C194F4B7298DC4E97FF66F900 , 0xADDD0EABDDA84C7F995746147323C4AE , 0xBD04A94B33A44E249DCC47733D88320D , 0xCEC4C238D5734D50936EC9BDBC7B34DB , 0xD451DA7380DB420B83616EB6AD513687 , 0xF44B5C94C95A4CB992CE7D66AF6B65E9 ); Copy
0.45 ms
1
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
0.45 ms
1
SELECT `currency` . `id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency` . `id` = `currency.salesChannels.mapping` . `currency_id` LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping` . `sales_channel_id` = `currency.salesChannels` . `id` WHERE (`currency.salesChannels` . `id` = ? ) GROUP BY `currency` . `id`
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT `currency` . `id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency` . `id` = `currency.salesChannels.mapping` . `currency_id` LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping` . `sales_channel_id` = `currency.salesChannels` . `id` WHERE (`currency.salesChannels` . `id` = 0x2F9B056E1C484931A120DFE36BF5AA13 ) GROUP BY `currency` . `id` ;
Copy
0.43 ms
1
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , COALESCE (`currency.translation.shortName` , `currency.translation.shortName` ) as `currency.shortName` , `currency.translation.name` , COALESCE (`currency.translation.name` , `currency.translation.name` ) as `currency.name` , `currency.translation.customFields` , COALESCE (`currency.translation.customFields` , `currency.translation.customFields` ) as `currency.customFields` , `currency.translation.createdAt` , `currency.translation.updatedAt` , `currency.translation.currencyId` , `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation` . currency_id , `currency.translation` . short_name as `currency.translation.shortName` , `currency.translation` . name as `currency.translation.name` , `currency.translation` . custom_fields as `currency.translation.customFields` , `currency.translation` . created_at as `currency.translation.createdAt` , `currency.translation` . updated_at as `currency.translation.updatedAt` , `currency.translation` . currency_id as `currency.translation.currencyId` , `currency.translation` . language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . language_id = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"·ÒUK\f èGÍ‚ó¬›ÑÀßÊ "
]
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , COALESCE (`currency.translation.shortName` , `currency.translation.shortName` ) as `currency.shortName` , `currency.translation.name` , COALESCE (`currency.translation.name` , `currency.translation.name` ) as `currency.name` , `currency.translation.customFields` , COALESCE (`currency.translation.customFields` , `currency.translation.customFields` ) as `currency.customFields` , `currency.translation.createdAt` , `currency.translation.updatedAt` , `currency.translation.currencyId` , `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation` . currency_id , `currency.translation` . short_name as `currency.translation.shortName` , `currency.translation` . name as `currency.translation.name` , `currency.translation` . custom_fields as `currency.translation.customFields` , `currency.translation` . created_at as `currency.translation.createdAt` , `currency.translation` . updated_at as `currency.translation.updatedAt` , `currency.translation` . currency_id as `currency.translation.currencyId` , `currency.translation` . language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (0xB7D2554B0CE847CD82F3AC9BD1C0DFCA );
Copy
0.42 ms
1
SELECT `media` . `id` as `media.id` , `media` . `user_id` as `media.userId` , `media` . `media_folder_id` as `media.mediaFolderId` , `media` . `mime_type` as `media.mimeType` , `media` . `file_extension` as `media.fileExtension` , `media` . `uploaded_at` as `media.uploadedAt` , `media` . `file_name` as `media.fileName` , `media` . `file_size` as `media.fileSize` , `media` . `media_type` as `media.mediaTypeRaw` , `media` . `meta_data` as `media.metaData` , `media` . `path` as `media.path` , `media` . `private` as `media.private` , `media` . `thumbnails_ro` as `media.thumbnailsRo` , `media` . `created_at` as `media.createdAt` , `media` . `updated_at` as `media.updatedAt` , `media.translation.title` , COALESCE (`media.translation.title` , `media.translation.title` ) as `media.title` , `media.translation.alt` , COALESCE (`media.translation.alt` , `media.translation.alt` ) as `media.alt` , `media.translation.customFields` , COALESCE (`media.translation.customFields` , `media.translation.customFields` ) as `media.customFields` , `media.translation.createdAt` , `media.translation.updatedAt` , `media.translation.mediaId` , `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . media_id , `media.translation` . title as `media.translation.title` , `media.translation` . alt as `media.translation.alt` , `media.translation` . custom_fields as `media.translation.customFields` , `media.translation` . created_at as `media.translation.createdAt` , `media.translation` . updated_at as `media.translation.updatedAt` , `media.translation` . media_id as `media.translation.mediaId` , `media.translation` . language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation` . language_id = ? ) `media.media_translation` ON `media.media_translation` . `media_id` = `media` . `id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder` . `default_folder_id` = `media.mediaFolder.defaultFolder` . `id` WHERE (((`media` . `private` = ? OR (`media` . `private` = ? AND `media.mediaFolder.defaultFolder` . `entity` = ? )))) AND (`media` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
false
true
"product_download "
b"lOr›\x11 ×Jà¿ÒĦí!\x17 i "
]
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` . `path` as `media.path` , `media` . `private` as `media.private` , `media` . `thumbnails_ro` as `media.thumbnailsRo` , `media` . `created_at` as `media.createdAt` , `media` . `updated_at` as `media.updatedAt` , `media.translation.title` , COALESCE (`media.translation.title` , `media.translation.title` ) as `media.title` , `media.translation.alt` , COALESCE (`media.translation.alt` , `media.translation.alt` ) as `media.alt` , `media.translation.customFields` , COALESCE (`media.translation.customFields` , `media.translation.customFields` ) as `media.customFields` , `media.translation.createdAt` , `media.translation.updatedAt` , `media.translation.mediaId` , `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media` . `media_folder_id` = `media.mediaFolder` . `id` LEFT JOIN (SELECT `media.translation` . media_id , `media.translation` . title as `media.translation.title` , `media.translation` . alt as `media.translation.alt` , `media.translation` . custom_fields as `media.translation.customFields` , `media.translation` . created_at as `media.translation.createdAt` , `media.translation` . updated_at as `media.translation.updatedAt` , `media.translation` . media_id as `media.translation.mediaId` , `media.translation` . language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation` . language_id = 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 (0x6C4F729B11D74AE0BFD2C4A6ED211769 ));
Copy
0.41 ms
1
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , COALESCE (`country.translation.name` , `country.translation.name` ) as `country.name` , `country.translation.addressFormat` , COALESCE (`country.translation.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.customFields` , COALESCE (`country.translation.customFields` , `country.translation.customFields` ) as `country.customFields` , `country.translation.createdAt` , `country.translation.updatedAt` , `country.translation.countryId` , `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation` . country_id , `country.translation` . name as `country.translation.name` , `country.translation` . address_format as `country.translation.addressFormat` , `country.translation` . custom_fields as `country.translation.customFields` , `country.translation` . created_at as `country.translation.createdAt` , `country.translation` . updated_at as `country.translation.updatedAt` , `country.translation` . country_id as `country.translation.countryId` , `country.translation` . language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation` . language_id = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"ꤥ▄õÙH▒╝\x15 ]\x1E ²Åýo "
]
SELECT `country` . `id` as `country.id` , `country` . `iso` as `country.iso` , `country` . `position` as `country.position` , `country` . `active` as `country.active` , `country` . `shipping_available` as `country.shippingAvailable` , `country` . `iso3` as `country.iso3` , `country` . `display_state_in_registration` as `country.displayStateInRegistration` , `country` . `force_state_in_registration` as `country.forceStateInRegistration` , `country` . `check_vat_id_pattern` as `country.checkVatIdPattern` , `country` . `vat_id_required` as `country.vatIdRequired` , `country` . `vat_id_pattern` as `country.vatIdPattern` , `country` . `customer_tax` as `country.customerTax` , `country` . `company_tax` as `country.companyTax` , `country` . `postal_code_required` as `country.postalCodeRequired` , `country` . `check_postal_code_pattern` as `country.checkPostalCodePattern` , `country` . `check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern` , `country` . `advanced_postal_code_pattern` as `country.advancedPostalCodePattern` , `country` . `default_postal_code_pattern` as `country.defaultPostalCodePattern` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.name` , COALESCE (`country.translation.name` , `country.translation.name` ) as `country.name` , `country.translation.addressFormat` , COALESCE (`country.translation.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.customFields` , COALESCE (`country.translation.customFields` , `country.translation.customFields` ) as `country.customFields` , `country.translation.createdAt` , `country.translation.updatedAt` , `country.translation.countryId` , `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation` . country_id , `country.translation` . name as `country.translation.name` , `country.translation` . address_format as `country.translation.addressFormat` , `country.translation` . custom_fields as `country.translation.customFields` , `country.translation` . created_at as `country.translation.createdAt` , `country.translation` . updated_at as `country.translation.updatedAt` , `country.translation` . country_id as `country.translation.countryId` , `country.translation` . language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x88CFBEDCE4EB48B1BC155D1EFD8FEC6F );
Copy
0.39 ms
1
SELECT `customer_group` . `id` as `customer_group.id` , `customer_group` . `display_gross` as `customer_group.displayGross` , `customer_group` . `registration_active` as `customer_group.registrationActive` , `customer_group` . `created_at` as `customer_group.createdAt` , `customer_group` . `updated_at` as `customer_group.updatedAt` , `customer_group.translation.name` , COALESCE (`customer_group.translation.name` , `customer_group.translation.name` ) as `customer_group.name` , `customer_group.translation.registrationTitle` , COALESCE (`customer_group.translation.registrationTitle` , `customer_group.translation.registrationTitle` ) as `customer_group.registrationTitle` , `customer_group.translation.registrationIntroduction` , COALESCE (`customer_group.translation.registrationIntroduction` , `customer_group.translation.registrationIntroduction` ) as `customer_group.registrationIntroduction` , `customer_group.translation.registrationOnlyCompanyRegistration` , COALESCE (`customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` ) as `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationSeoMetaDescription` , COALESCE (`customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` ) as `customer_group.registrationSeoMetaDescription` , `customer_group.translation.customFields` , COALESCE (`customer_group.translation.customFields` , `customer_group.translation.customFields` ) as `customer_group.customFields` , `customer_group.translation.createdAt` , `customer_group.translation.updatedAt` , `customer_group.translation.customerGroupId` , `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation` . customer_group_id , `customer_group.translation` . name as `customer_group.translation.name` , `customer_group.translation` . registration_title as `customer_group.translation.registrationTitle` , `customer_group.translation` . registration_introduction as `customer_group.translation.registrationIntroduction` , `customer_group.translation` . registration_only_company_registration as `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation` . registration_seo_meta_description as `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation` . custom_fields as `customer_group.translation.customFields` , `customer_group.translation` . created_at as `customer_group.translation.createdAt` , `customer_group.translation` . updated_at as `customer_group.translation.updatedAt` , `customer_group.translation` . customer_group_id as `customer_group.translation.customerGroupId` , `customer_group.translation` . language_id as `customer_group.translation.languageId` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation` . language_id = ? ) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id` WHERE `customer_group` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"ÿ¼IXr–G^˜éÉF\x00 :ßU "
]
SELECT `customer_group` . `id` as `customer_group.id` , `customer_group` . `display_gross` as `customer_group.displayGross` , `customer_group` . `registration_active` as `customer_group.registrationActive` , `customer_group` . `created_at` as `customer_group.createdAt` , `customer_group` . `updated_at` as `customer_group.updatedAt` , `customer_group.translation.name` , COALESCE (`customer_group.translation.name` , `customer_group.translation.name` ) as `customer_group.name` , `customer_group.translation.registrationTitle` , COALESCE (`customer_group.translation.registrationTitle` , `customer_group.translation.registrationTitle` ) as `customer_group.registrationTitle` , `customer_group.translation.registrationIntroduction` , COALESCE (`customer_group.translation.registrationIntroduction` , `customer_group.translation.registrationIntroduction` ) as `customer_group.registrationIntroduction` , `customer_group.translation.registrationOnlyCompanyRegistration` , COALESCE (`customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationOnlyCompanyRegistration` ) as `customer_group.registrationOnlyCompanyRegistration` , `customer_group.translation.registrationSeoMetaDescription` , COALESCE (`customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation.registrationSeoMetaDescription` ) as `customer_group.registrationSeoMetaDescription` , `customer_group.translation.customFields` , COALESCE (`customer_group.translation.customFields` , `customer_group.translation.customFields` ) as `customer_group.customFields` , `customer_group.translation.createdAt` , `customer_group.translation.updatedAt` , `customer_group.translation.customerGroupId` , `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation` . customer_group_id , `customer_group.translation` . name as `customer_group.translation.name` , `customer_group.translation` . registration_title as `customer_group.translation.registrationTitle` , `customer_group.translation` . registration_introduction as `customer_group.translation.registrationIntroduction` , `customer_group.translation` . registration_only_company_registration as `customer_group.translation.registrationOnlyCompanyRegistration` , `customer_group.translation` . registration_seo_meta_description as `customer_group.translation.registrationSeoMetaDescription` , `customer_group.translation` . custom_fields as `customer_group.translation.customFields` , `customer_group.translation` . created_at as `customer_group.translation.createdAt` , `customer_group.translation` . updated_at as `customer_group.translation.updatedAt` , `customer_group.translation` . customer_group_id as `customer_group.translation.customerGroupId` , `customer_group.translation` . language_id as `customer_group.translation.languageId` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation` . `customer_group_id` = `customer_group` . `id` WHERE `customer_group` . `id` IN (0xFFBC49587296475E98E9C946003ADF55 );
Copy
0.38 ms
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
"iWmnHMmwFWcfQYCZDTVBzHyP5nLWK2PN "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x2F9B056E1C484931A120DFE36BF5AA13 ) AND (token = 'iWmnHMmwFWcfQYCZDTVBzHyP5nLWK2PN' ) LIMIT 1 ; Copy
0.38 ms
1
SELECT `salutation` . `id` as `salutation.id` , `salutation` . `salutation_key` as `salutation.salutationKey` , `salutation` . `created_at` as `salutation.createdAt` , `salutation` . `updated_at` as `salutation.updatedAt` , `salutation.translation.displayName` , COALESCE (`salutation.translation.displayName` , `salutation.translation.displayName` ) as `salutation.displayName` , `salutation.translation.letterName` , COALESCE (`salutation.translation.letterName` , `salutation.translation.letterName` ) as `salutation.letterName` , `salutation.translation.customFields` , COALESCE (`salutation.translation.customFields` , `salutation.translation.customFields` ) as `salutation.customFields` , `salutation.translation.createdAt` , `salutation.translation.updatedAt` , `salutation.translation.salutationId` , `salutation.translation.languageId` FROM `salutation` LEFT JOIN (SELECT `salutation.translation` . salutation_id , `salutation.translation` . display_name as `salutation.translation.displayName` , `salutation.translation` . letter_name as `salutation.translation.letterName` , `salutation.translation` . custom_fields as `salutation.translation.customFields` , `salutation.translation` . created_at as `salutation.translation.createdAt` , `salutation.translation` . updated_at as `salutation.translation.updatedAt` , `salutation.translation` . salutation_id as `salutation.translation.salutationId` , `salutation.translation` . language_id as `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation` . language_id = ? ) `salutation.salutation_translation` ON `salutation.salutation_translation` . `salutation_id` = `salutation` . `id`
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `salutation` . `id` as `salutation.id` , `salutation` . `salutation_key` as `salutation.salutationKey` , `salutation` . `created_at` as `salutation.createdAt` , `salutation` . `updated_at` as `salutation.updatedAt` , `salutation.translation.displayName` , COALESCE (`salutation.translation.displayName` , `salutation.translation.displayName` ) as `salutation.displayName` , `salutation.translation.letterName` , COALESCE (`salutation.translation.letterName` , `salutation.translation.letterName` ) as `salutation.letterName` , `salutation.translation.customFields` , COALESCE (`salutation.translation.customFields` , `salutation.translation.customFields` ) as `salutation.customFields` , `salutation.translation.createdAt` , `salutation.translation.updatedAt` , `salutation.translation.salutationId` , `salutation.translation.languageId` FROM `salutation` LEFT JOIN (SELECT `salutation.translation` . salutation_id , `salutation.translation` . display_name as `salutation.translation.displayName` , `salutation.translation` . letter_name as `salutation.translation.letterName` , `salutation.translation` . custom_fields as `salutation.translation.customFields` , `salutation.translation` . created_at as `salutation.translation.createdAt` , `salutation.translation` . updated_at as `salutation.translation.updatedAt` , `salutation.translation` . salutation_id as `salutation.translation.salutationId` , `salutation.translation` . language_id as `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `salutation.salutation_translation` ON `salutation.salutation_translation` . `salutation_id` = `salutation` . `id` ; Copy
0.37 ms
1
SELECT `sales_channel_domain` . `id` as `sales_channel_domain.id` , `sales_channel_domain` . `url` as `sales_channel_domain.url` , `sales_channel_domain` . `sales_channel_id` as `sales_channel_domain.salesChannelId` , `sales_channel_domain` . `language_id` as `sales_channel_domain.languageId` , `sales_channel_domain` . `currency_id` as `sales_channel_domain.currencyId` , `sales_channel_domain` . `snippet_set_id` as `sales_channel_domain.snippetSetId` , `sales_channel_domain` . `hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale` , `sales_channel_domain` . `custom_fields` as `sales_channel_domain.customFields` , `sales_channel_domain` . `created_at` as `sales_channel_domain.createdAt` , `sales_channel_domain` . `updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain` . `sales_channel_id` IN (? ))
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT `sales_channel_domain` . `id` as `sales_channel_domain.id` , `sales_channel_domain` . `url` as `sales_channel_domain.url` , `sales_channel_domain` . `sales_channel_id` as `sales_channel_domain.salesChannelId` , `sales_channel_domain` . `language_id` as `sales_channel_domain.languageId` , `sales_channel_domain` . `currency_id` as `sales_channel_domain.currencyId` , `sales_channel_domain` . `snippet_set_id` as `sales_channel_domain.snippetSetId` , `sales_channel_domain` . `hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale` , `sales_channel_domain` . `custom_fields` as `sales_channel_domain.customFields` , `sales_channel_domain` . `created_at` as `sales_channel_domain.createdAt` , `sales_channel_domain` . `updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain` . `sales_channel_id` IN (0x2F9B056E1C484931A120DFE36BF5AA13 ));
Copy
0.37 ms
1
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config . sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT configuration_key , configuration_value FROM system_config WHERE sales_channel_id = 0x2F9B056E1C484931A120DFE36BF5AA13 OR system_config . sales_channel_id IS NULL ORDER BY sales_channel_id ASC ; Copy
0.37 ms
1
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 = ? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
"account/login "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND ((sales_channel_id = 0x2F9B056E1C484931A120DFE36BF5AA13 OR sales_channel_id IS NULL )) AND (seo_path_info = 'account/login' );
Copy
0.36 ms
1
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? )
Parameters :
[
b"\r )œSá\x17 Cô°ÎÊ\x18 NkÑ\x16 Jè”,ýì@S’}ÓV‘±VÇ "
b"®×.mö\t GS\x04 mÑhøE\f "
b"á+d\x04 K©Dö¾ßêЯ€\x15 Ö "
b"■ì\x13 (Q|L▄èYêu‗¼¤\x11 "
]
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 (0x0D299C53E11743F4B0CECA184E6BD116 , 0x4AE8942CFDEC4053927DD35691B156C7 , 0xAED72E6DF6094753AD046DD168F8450C , 0xE12B64044BA944F6BEDFEAD0AF8015D6 , 0xFE8D1328517C4CDC8A598875F2ACCF11 ); Copy
0.36 ms
1
SELECT
sales_channel . id as sales_channel_id ,
sales_channel . language_id as sales_channel_default_language_id ,
sales_channel . currency_id as sales_channel_currency_id ,
currency . factor as sales_channel_currency_factor ,
GROUP_CONCAT (LOWER (HEX (sales_channel_language . language_id ))) as sales_channel_language_ids
FROM sales_channel
INNER JOIN currency
ON sales_channel . currency_id = currency . id
LEFT JOIN sales_channel_language
ON sales_channel_language . sales_channel_id = sales_channel . id
WHERE sales_channel . id = ?
GROUP BY sales_channel . id , sales_channel . language_id , sales_channel . currency_id , currency . factor
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT
sales_channel . id as sales_channel_id ,
sales_channel . language_id as sales_channel_default_language_id ,
sales_channel . currency_id as sales_channel_currency_id ,
currency . factor as sales_channel_currency_factor ,
GROUP_CONCAT (LOWER (HEX (sales_channel_language . language_id ))) as sales_channel_language_ids
FROM sales_channel
INNER JOIN currency
ON sales_channel . currency_id = currency . id
LEFT JOIN sales_channel_language
ON sales_channel_language . sales_channel_id = sales_channel . id
WHERE sales_channel . id = 0x2F9B056E1C484931A120DFE36BF5AA13
GROUP BY sales_channel . id , sales_channel . language_id , sales_channel . currency_id , currency . factor ;
Copy
0.35 ms
1
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , COALESCE (`currency.translation.shortName` , `currency.translation.shortName` ) as `currency.shortName` , `currency.translation.name` , COALESCE (`currency.translation.name` , `currency.translation.name` ) as `currency.name` , `currency.translation.customFields` , COALESCE (`currency.translation.customFields` , `currency.translation.customFields` ) as `currency.customFields` , `currency.translation.createdAt` , `currency.translation.updatedAt` , `currency.translation.currencyId` , `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation` . currency_id , `currency.translation` . short_name as `currency.translation.shortName` , `currency.translation` . name as `currency.translation.name` , `currency.translation` . custom_fields as `currency.translation.customFields` , `currency.translation` . created_at as `currency.translation.createdAt` , `currency.translation` . updated_at as `currency.translation.updatedAt` , `currency.translation` . currency_id as `currency.translation.currencyId` , `currency.translation` . language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . language_id = ? ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"·ÒUK\f èGÍ‚ó¬›ÑÀßÊ "
]
SELECT `currency` . `id` as `currency.id` , `currency` . `factor` as `currency.factor` , `currency` . `symbol` as `currency.symbol` , `currency` . `iso_code` as `currency.isoCode` , `currency` . `position` as `currency.position` , `currency` . `tax_free_from` as `currency.taxFreeFrom` , `currency` . `item_rounding` as `currency.itemRounding` , `currency` . `total_rounding` as `currency.totalRounding` , `currency` . `created_at` as `currency.createdAt` , `currency` . `updated_at` as `currency.updatedAt` , `currency.translation.shortName` , COALESCE (`currency.translation.shortName` , `currency.translation.shortName` ) as `currency.shortName` , `currency.translation.name` , COALESCE (`currency.translation.name` , `currency.translation.name` ) as `currency.name` , `currency.translation.customFields` , COALESCE (`currency.translation.customFields` , `currency.translation.customFields` ) as `currency.customFields` , `currency.translation.createdAt` , `currency.translation.updatedAt` , `currency.translation.currencyId` , `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation` . currency_id , `currency.translation` . short_name as `currency.translation.shortName` , `currency.translation` . name as `currency.translation.name` , `currency.translation` . custom_fields as `currency.translation.customFields` , `currency.translation` . created_at as `currency.translation.createdAt` , `currency.translation` . updated_at as `currency.translation.updatedAt` , `currency.translation` . currency_id as `currency.translation.currencyId` , `currency.translation` . language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `currency.currency_translation` ON `currency.currency_translation` . `currency_id` = `currency` . `id` WHERE `currency` . `id` IN (0xB7D2554B0CE847CD82F3AC9BD1C0DFCA );
Copy
0.33 ms
3
SELECT `base_class` AS `baseClass` , `author`
FROM `plugin`
SELECT `base_class` AS `baseClass` , `author`
FROM `plugin`
; Copy
0.31 ms
1
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country` . `active` = ? AND `country` . `active` = ? AND `country.salesChannels` . `id` = ? ) GROUP BY `country` . `id`
Parameters :
[
true
true
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE (`country` . `active` = 1 AND `country` . `active` = 1 AND `country.salesChannels` . `id` = 0x2F9B056E1C484931A120DFE36BF5AA13 ) GROUP BY `country` . `id` ; Copy
0.31 ms
1
SELECT `rule` . `id` as `rule.id` , `rule` . `name` as `rule.name` , `rule` . `priority` as `rule.priority` , `rule` . `description` as `rule.description` , `rule` . `payload` as `rule.payload` , `rule` . `invalid` as `rule.invalid` , `rule` . `areas` as `rule.areas` , `rule` . `custom_fields` as `rule.customFields` , `rule` . `module_types` as `rule.moduleTypes` , `rule` . `created_at` as `rule.createdAt` , `rule` . `updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule` . `id` IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
b"""
\f ║X╝\x19 ─HØ┤2/\n \x08 Ò■\n \r )œSá\x17 Cô°ÎÊ\x18 NkÑ\x16 Jè”,ýì@S’}ÓV‘±VÇ "
b"Z\x18 FÓï!J╔ñ\f yGɹ¤³ "
b"ƒÒÑ\x13 ÿfHH¸¬\e Ö³\x1C 1î "
b"®×.mö\t GS\x04 mÑhøE\f "
b"á+d\x04 K©Dö¾ßêЯ€\x15 Ö "
b"ᦖÑáJE<Ÿ·Tš\x1D 0\v\x0E "
b"■ì\x13 (Q|L▄èYêu‗¼¤\x11 "
b"/†R6íÈGÜ€Q\f ÇÇ9\x14 ' "
b"\x06 <Ó\x04 !ÂLƲ\x1F '\x1D ´J®-\x0F\x19\x1C ,╝oM!É`h╝\x07 nDt\x1A <˜Á\x18 ´Mç ¸'§§\x05 ÄPEÕÔÉ«.N º╔╚║¤┼.\ "
b"R+\x04\x19 ¯gL ¥48’j]"p "
b"mÙ\x05 /»wG"–ò¥gšM \f "
b"vĶÕú¾@¢¾1Ó0\ETÝ "
b"|\x05 N\x05 †¼I£—›¥Y•GöR "
b"í]-\x05 ÛÔHì¥Uê2åÏ0 "
b"½2S¯ëá@½ü└³6gÄsL "
b"¸ÅÀî<çH‹ºÞ’‘iŽkÎ "
b"ÁYÑàpÝIå›ßWÅvj € "
b"¤│b6├ÏGÞª'þ‗Ö^ü¯ "
b"ÓˆàœÑ1@n°A˜\x1F\x06 Ùž$ "
b"âÑÞ{EÝK\x06 ŽÇŠc¼lãG "
b"å–¦CëJOº¶Îì-A™ýP "
b"ý<RÒÕ/N\f ¹ÐAdãå\x07 ¿ "
]
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 (0x0CBA58BC19C4489DB4322F0A08E3FE0A , 0x0D299C53E11743F4B0CECA184E6BD116 , 0x4AE8942CFDEC4053927DD35691B156C7 , 0x5A1846E08B214AC9A40C794790FBCFFC , 0x83D2D113FF664848B8AC1BD6B31C31EE , 0xAED72E6DF6094753AD046DD168F8450C , 0xE12B64044BA944F6BEDFEAD0AF8015D6 , 0xE1A696D1E14A453C9FB7549A1D300B0E , 0xFE8D1328517C4CDC8A598875F2ACCF11 , 0x2F865236EDC847DC80510CC7C7391427 , 0x063CD30421C24CC6B21F271DB44AAE2D , 0x0F191C2CBC6F4D21906068BC076E4474 , 0x1A3C98C118B44DE7A0B827A7A705C450 , 0x45E5E290AE2E4E20A7C9C8BACFC52E5C , 0x522B0419AF674C20A53438926A5D2270 , 0x6DD9052FBB77472296F2A5679A4DA00C , 0x76C4B6D5FABE40A2BE31D3305C4554DD , 0x7C054E0586BC49A3979BA5599547F652 , 0xA15D2D05EAE2488DBE558832F086D830 , 0xAB3253EE89A040AB81C0FC36678E734C , 0xB8C5C0EE3CE7488BBADE9291698E6BCE , 0xC159D1E070DD49E59BDF57C5766AA080 , 0xCFB36236C3D847E8A627E7F2995E81EE , 0xD388E09CD131406EB041981F06D99E24 , 0xE2D1DE7B45DD4B068EC78A63BC6CE347 , 0xE596A643EB4A4FBAB6CEEC2D4199FD50 , 0xFD3C52D2D52F4E0CB9D04164E3E507BF );
Copy
0.30 ms
1
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
0.29 ms
1
SELECT `payment_method` . `id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method` . `id` = `payment_method.salesChannels.mapping` . `payment_method_id` LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping` . `sales_channel_id` = `payment_method.salesChannels` . `id` WHERE (`payment_method` . `active` = ? AND `payment_method.salesChannels` . `id` = ? ) GROUP BY `payment_method` . `id` ORDER BY MIN (`payment_method` . `position` ) ASC
Parameters :
[
true
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT `payment_method` . `id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method` . `id` = `payment_method.salesChannels.mapping` . `payment_method_id` LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping` . `sales_channel_id` = `payment_method.salesChannels` . `id` WHERE (`payment_method` . `active` = 1 AND `payment_method.salesChannels` . `id` = 0x2F9B056E1C484931A120DFE36BF5AA13 ) GROUP BY `payment_method` . `id` ORDER BY MIN (`payment_method` . `position` ) ASC ;
Copy
0.29 ms
1
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` , `language.locale` . `id` as `language.locale.id` , `language.locale` . `code` as `language.locale.code` , `language.locale` . `created_at` as `language.locale.createdAt` , `language.locale` . `updated_at` as `language.locale.updatedAt` , `language.locale.translation.name` , COALESCE (`language.locale.translation.name` , `language.locale.translation.name` ) as `language.locale.name` , `language.locale.translation.territory` , COALESCE (`language.locale.translation.territory` , `language.locale.translation.territory` ) as `language.locale.territory` , `language.locale.translation.customFields` , COALESCE (`language.locale.translation.customFields` , `language.locale.translation.customFields` ) as `language.locale.customFields` , `language.locale.translation.createdAt` , `language.locale.translation.updatedAt` , `language.locale.translation.localeId` , `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language` . `locale_id` = `language.locale` . `id` LEFT JOIN (SELECT `language.locale.translation` . locale_id , `language.locale.translation` . name as `language.locale.translation.name` , `language.locale.translation` . territory as `language.locale.translation.territory` , `language.locale.translation` . custom_fields as `language.locale.translation.customFields` , `language.locale.translation` . created_at as `language.locale.translation.createdAt` , `language.locale.translation` . updated_at as `language.locale.translation.updatedAt` , `language.locale.translation` . locale_id as `language.locale.translation.localeId` , `language.locale.translation` . language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation` . language_id = ? ) `language.locale.locale_translation` ON `language.locale.locale_translation` . `locale_id` = `language.locale` . `id` WHERE `language` . `id` IN (? )
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `language` . `id` as `language.id` , `language` . `parent_id` as `language.parentId` , `language` . `locale_id` as `language.localeId` , `language` . `translation_code_id` as `language.translationCodeId` , `language` . `name` as `language.name` , `language` . `custom_fields` as `language.customFields` , `language` . `created_at` as `language.createdAt` , `language` . `updated_at` as `language.updatedAt` , `language.locale` . `id` as `language.locale.id` , `language.locale` . `code` as `language.locale.code` , `language.locale` . `created_at` as `language.locale.createdAt` , `language.locale` . `updated_at` as `language.locale.updatedAt` , `language.locale.translation.name` , COALESCE (`language.locale.translation.name` , `language.locale.translation.name` ) as `language.locale.name` , `language.locale.translation.territory` , COALESCE (`language.locale.translation.territory` , `language.locale.translation.territory` ) as `language.locale.territory` , `language.locale.translation.customFields` , COALESCE (`language.locale.translation.customFields` , `language.locale.translation.customFields` ) as `language.locale.customFields` , `language.locale.translation.createdAt` , `language.locale.translation.updatedAt` , `language.locale.translation.localeId` , `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language` . `locale_id` = `language.locale` . `id` LEFT JOIN (SELECT `language.locale.translation` . locale_id , `language.locale.translation` . name as `language.locale.translation.name` , `language.locale.translation` . territory as `language.locale.translation.territory` , `language.locale.translation` . custom_fields as `language.locale.translation.customFields` , `language.locale.translation` . created_at as `language.locale.translation.createdAt` , `language.locale.translation` . updated_at as `language.locale.translation.updatedAt` , `language.locale.translation` . locale_id as `language.locale.translation.localeId` , `language.locale.translation` . language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation` . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `language.locale.locale_translation` ON `language.locale.locale_translation` . `locale_id` = `language.locale` . `id` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ); Copy
0.24 ms
1
SELECT `rule` . `id` FROM `rule` ORDER BY `rule` . `priority` DESC , `rule` . `id` ASC LIMIT 500
SELECT `rule` . `id` FROM `rule` ORDER BY `rule` . `priority` DESC , `rule` . `id` ASC LIMIT 500 ;
Copy
0.24 ms
1
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ? ) AND (sales_channel_id = ? ) AND (path_info = ? ) AND (is_canonical = 1 ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
"/account/login "
]
SELECT path_info pathInfo , seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (sales_channel_id = 0x2F9B056E1C484931A120DFE36BF5AA13 ) AND (path_info = '/account/login' ) AND (is_canonical = 1 ) LIMIT 1 ;
Copy
0.24 ms
1
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE ((`country.salesChannels` . `id` = ? )) AND (`country` . `id` IN (? )) GROUP BY `country` . `id`
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
b"ꤥ▄õÙH▒╝\x15 ]\x1E ²Åýo "
]
SELECT `country` . `id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country` . `id` = `country.salesChannels.mapping` . `country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping` . `sales_channel_id` = `country.salesChannels` . `id` WHERE ((`country.salesChannels` . `id` = 0x2F9B056E1C484931A120DFE36BF5AA13 )) AND (`country` . `id` IN (0x88CFBEDCE4EB48B1BC155D1EFD8FEC6F )) GROUP BY `country` . `id` ; Copy
0.24 ms
1
SELECT `currency_country_rounding` . `id` FROM `currency_country_rounding` WHERE (`currency_country_rounding` . `currency_id` = ? AND `currency_country_rounding` . `country_id` = ? ) LIMIT 1
Parameters :
[
b"·ÒUK\f èGÍ‚ó¬›ÑÀßÊ "
b"ꤥ▄õÙH▒╝\x15 ]\x1E ²Åýo "
]
SELECT `currency_country_rounding` . `id` FROM `currency_country_rounding` WHERE (`currency_country_rounding` . `currency_id` = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA AND `currency_country_rounding` . `country_id` = 0x88CFBEDCE4EB48B1BC155D1EFD8FEC6F ) LIMIT 1 ;
Copy
0.23 ms
1
SELECT `seo_path_info` AS seoPathInfo , `language_id` AS languageId
FROM `seo_url`
WHERE `path_info` = ? AND `is_canonical` = 1 AND
`sales_channel_id` = ? AND `language_id` IN (? )
Parameters :
[
"/account/login "
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `seo_path_info` AS seoPathInfo , `language_id` AS languageId
FROM `seo_url`
WHERE `path_info` = '/account/login' AND `is_canonical` = 1 AND
`sales_channel_id` = 0x2F9B056E1C484931A120DFE36BF5AA13 AND `language_id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ); Copy
0.22 ms
1
SELECT LOWER (HEX (language . id )) AS array_key , LOWER (HEX (language . id )) AS id , locale . code , LOWER (HEX (language . parent_id )) parentId FROM language LEFT JOIN locale locale ON language . translation_code_id = locale . id
SELECT LOWER (HEX (language . id )) AS array_key , LOWER (HEX (language . id )) AS id , locale . code , LOWER (HEX (language . parent_id )) parentId FROM language LEFT JOIN locale locale ON language . translation_code_id = locale . id ; Copy
0.22 ms
1
SELECT `domain` . `language_id` AS languageId ,
`domain` . `id` AS id ,
`domain` . `url` AS url ,
`domain` . `hreflang_use_only_locale` AS onlyLocale ,
`locale` . `code` AS locale
FROM `sales_channel_domain` AS `domain`
INNER JOIN `language` ON `language` . `id` = `domain` . `language_id`
INNER JOIN `locale` ON `locale` . `id` = `language` . `locale_id`
WHERE `domain` . `sales_channel_id` = ?
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT `domain` . `language_id` AS languageId ,
`domain` . `id` AS id ,
`domain` . `url` AS url ,
`domain` . `hreflang_use_only_locale` AS onlyLocale ,
`locale` . `code` AS locale
FROM `sales_channel_domain` AS `domain`
INNER JOIN `language` ON `language` . `id` = `domain` . `language_id`
INNER JOIN `locale` ON `locale` . `id` = `language` . `locale_id`
WHERE `domain` . `sales_channel_id` = 0x2F9B056E1C484931A120DFE36BF5AA13 ; Copy
0.19 ms
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
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
0.19 ms
1
SELECT `tax` . `id` as `tax.id` , `tax` . `tax_rate` as `tax.taxRate` , `tax` . `name` as `tax.name` , `tax` . `position` as `tax.position` , `tax` . `custom_fields` as `tax.customFields` , `tax` . `created_at` as `tax.createdAt` , `tax` . `updated_at` as `tax.updatedAt` FROM `tax`
SELECT `tax` . `id` as `tax.id` , `tax` . `tax_rate` as `tax.taxRate` , `tax` . `name` as `tax.name` , `tax` . `position` as `tax.position` , `tax` . `custom_fields` as `tax.customFields` , `tax` . `created_at` as `tax.createdAt` , `tax` . `updated_at` as `tax.updatedAt` FROM `tax` ;
Copy
0.19 ms
1
SELECT LOWER (HEX (assoc . `sales_channel_id` ))
FROM `sales_channel_payment_method` AS assoc
LEFT JOIN `payment_method` AS pm
ON pm . `id` = assoc . `payment_method_id`
WHERE
assoc . `payment_method_id` = ? AND
pm . `active` = 1
Parameters :
[
b"¯aŽ6ÈÍC§…Ù^7ÿÉì\x0E "
]
SELECT LOWER (HEX (assoc . `sales_channel_id` ))
FROM `sales_channel_payment_method` AS assoc
LEFT JOIN `payment_method` AS pm
ON pm . `id` = assoc . `payment_method_id`
WHERE
assoc . `payment_method_id` = 0xAF618E36C8CD43A785D95E37FFC9EC0E AND
pm . `active` = 1 ; Copy
0.18 ms
1
SELECT `cart` . `cart` as payload , `cart` . `rule_ids` , 0 as `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"iWmnHMmwFWcfQYCZDTVBzHyP5nLWK2PN "
]
SELECT `cart` . `cart` as payload , `cart` . `rule_ids` , 0 as `compressed` FROM cart WHERE `token` = 'iWmnHMmwFWcfQYCZDTVBzHyP5nLWK2PN' ;
Copy
0.17 ms
1
SELECT translation_key , value FROM snippet WHERE snippet_set_id = ?
Parameters :
[
b"ràt³#¨JCºl@µ%çɸ "
]
SELECT translation_key , value FROM snippet WHERE snippet_set_id = 0x728574FC23F94A43A76C40E6258790F7 ; Copy
0.17 ms
1
SELECT LOWER (HEX (theme . id )) themeId , theme . technical_name as themeName , parentTheme . technical_name as parentThemeName
FROM sales_channel
LEFT JOIN theme_sales_channel ON sales_channel . id = theme_sales_channel . sales_channel_id
LEFT JOIN theme ON theme_sales_channel . theme_id = theme . id
LEFT JOIN theme AS parentTheme ON parentTheme . id = theme . parent_theme_id
WHERE sales_channel . id = ?
Parameters :
[
b"/›\x05 n\x1C HI1¡ ßãkõª\x13 "
]
SELECT LOWER (HEX (theme . id )) themeId , theme . technical_name as themeName , parentTheme . technical_name as parentThemeName
FROM sales_channel
LEFT JOIN theme_sales_channel ON sales_channel . id = theme_sales_channel . sales_channel_id
LEFT JOIN theme ON theme_sales_channel . theme_id = theme . id
LEFT JOIN theme AS parentTheme ON parentTheme . id = theme . parent_theme_id
WHERE sales_channel . id = 0x2F9B056E1C484931A120DFE36BF5AA13
; Copy
0.16 ms
1
SELECT `handler_identifier` , LOWER (HEX (`id` )) FROM `payment_method`
SELECT `handler_identifier` , LOWER (HEX (`id` )) FROM `payment_method` ; Copy
0.16 ms
1
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' ))
SET @@group_concat_max_len = CAST (IF (@@group_concat_max_len > 320000 , @@group_concat_max_len , 320000 ) AS UNSIGNED ); SET sql_mode = (SELECT REPLACE (@@sql_mode , 'ONLY_FULL_GROUP_BY' , '' )); Copy
0.14 ms
1
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (? ) LIMIT 1
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
]
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) LIMIT 1 ; Copy
0.13 ms
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ; Copy
0.11 ms
1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author`
FROM `app`
WHERE `active` = 1
; Copy
0.11 ms
1
SELECT iso FROM snippet_set WHERE id = ?
Parameters :
[
b"ràt³#¨JCºl@µ%çɸ "
]
SELECT iso FROM snippet_set WHERE id = 0x728574FC23F94A43A76C40E6258790F7 ; Copy