1.79 ms (20.39%)
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/383ac47a208b4902995ac1d8501a6508 "
"/navigation/018a8e05871277b3a98578efc759b2ae "
"/navigation/018b0514daa07661a240c4784f1607fb "
"/navigation/7a87c3a0613e473aa36bc385ecc48ba5 "
"/navigation/de55ac55c8744b3ba91b40943e39df3c "
"/navigation/4d22bc54ff254743b336c146b3123ccc "
"/navigation/018bfb93368a704e8af377e7aee49656 "
"/navigation/018eeb03f4c578b99eb910e577d32e50 "
"/navigation/00e4c01624c947fc844677be6041823b "
"/navigation/0c5b4ddfaf954f009425d95b676966c4 "
"/navigation/f97a7bd4acb04faeba5a712260189f31 "
"/navigation/b402cab0b2c14e149544f53befcfed9f "
"/navigation/2321866ea02f445f8fe99ab86154ab39 "
"/navigation/523e1fc48edb4fa49f4646cbdfc363f3 "
"/navigation/480c057d500b42bb93f2637f023ab85e "
"/navigation/54e6efb5b26f4b7a9820940f4ec66b23 "
"/navigation/9f2d5ccf1e1b4e5a936541e0075c042b "
"/navigation/018a466213977684a147cad54481e914 "
"/navigation/018b27df7b6b779b945a4d9f32a586ed "
"/navigation/018bb31e02ff7f75813589fcc073faab "
"/navigation/018c5d3a0dd37a90ae96d8f612981f17 "
"/navigation/018de54cf1e37130a702d8f14411136f "
"/navigation/018fa009510f7950bc30514f13f17150 "
"/navigation/01900b15d11376e0975bf5b0c59759e2 "
"/navigation/1be10bc161df4d8fb4b2d7d794d7d70b "
"/navigation/0192c3a069f579aa843a9cf369328e13 "
"/navigation/8aac33a98cd2432e8e5bc815ea190b8c "
"/navigation/1de51695f23c4c4cb18945804a6be7c9 "
"/navigation/dc894dac99af4299814040fdf7f8f8de "
"/navigation/5b93b0d06b634346af8bbd4a86478f0f "
"/navigation/b819de59af684d9c97629478c63c43f0 "
"/navigation/018c19eefe757082a2b5543639d38b94 "
"/navigation/b9c63eb740be4bc4806693973a0417a5 "
"/navigation/99ec5149ab9e4588bdd9b8c93f7757f7 "
"/navigation/cf56d9e7a1d740569f14aa63a194d160 "
"/navigation/93f676700eed4a489d7ed42dc728f2e0 "
"/navigation/018b03e09e4871b29a575f75dbc07380 "
"/navigation/b3e8b65b967f4cd5a876a323039ebf6d "
"/navigation/294ff0a0d4684cdb8a7afb02bf601d5d "
"/navigation/47a458bf51fb4c21a9b0e361ee2fccad "
"/navigation/b689a161eb1841c28b82f64d1acf2322 "
"/navigation/f479edb2a8754436893e6f9495ad5eae "
"/navigation/018bc7ae2c9a7209b27a5ce880f4e621 "
"/navigation/f1243af5c0ae4a548d85a8e9944de228 "
"/navigation/0cf9d7e6a92343feaf2143d68e4fa2f3 "
"/navigation/018b23b3be28720881be1be7d85aaf22 "
"/navigation/018c90807d7a7ee4a491f8e0922bfd68 "
"/navigation/018dc68486f974c0823096bcc9863fc1 "
"/navigation/018de54c816376b194f2233fc6dfce7e "
"/navigation/59209182e0c94b91b420c670c4662d14 "
"/navigation/5c3bc1e7533b47ca93637a785d855444 "
"/navigation/b2a3dd3856c348a099065eae1aaf3bca "
"/navigation/4c41b51b942c4844998aee954bbeae8b "
"/navigation/f34bfee8839e418abc3529e5f5153312 "
"/navigation/898edb7ebeae4ad8ad662ae3c33f7864 "
"/navigation/0504d971c57f4831b805453304d92dba "
"/navigation/3b5cc999670243b29c2803580a42b805 "
"/navigation/018e13080490792fb97c0872296cc5a5 "
"/navigation/018f5742b7be786da8ed9d1c12ab3254 "
"/navigation/018f61629cbb70d0aa40be7a29061ca9 "
"/navigation/4f8cbc189ffc451b83501f047cd03b87 "
"/navigation/e11deed955854b88bb433f3960039144 "
"/navigation/a40362dba93a4cf08738785207dc712e "
"/navigation/804520db365f4281ad819ab97670a467 "
"/navigation/f8198bf6f56542208e1e5d633f176bf8 "
"/navigation/018bfb951ffb74ee887375f65eeab002 "
"/navigation/018bfb9538e871bd86a4533b16a9642e "
"/detail/01931af6884b736ca31577f90c5bee60 "
"/detail/0923a8ba1c6f4309af32b495664f71da "
"/detail/201422c5bc1e4053926362889c3c47dd "
"/detail/300dac9aa767400396d235fd897cd137 "
"/detail/3b53c14fa20543e4aec3835a3309bf93 "
"/detail/446a498118794a7fbffdad2d74599c34 "
"/detail/4ec788768f9548249268270830715c38 "
"/detail/555fd737de804d24ba4ecbbd188992b3 "
"/detail/61030e283e72449c85a0eb90b5b25d1e "
"/detail/6f0b3b0bd2f540e889691c8465d1226b "
"/detail/77975a9cdd6f4894b860a6b249a14db2 "
"/detail/7a661e506a3b4acfa5aa889721e11bba "
"/detail/8040362af832460bb7b5129a1028e64d "
"/detail/8688e982a9444c68b4106b830dc56332 "
"/detail/95df5fc34aad4473b8f3933a528e94cc "
"/detail/9ae7f7c0f6d34503acc7a6993ef91bf7 "
"/detail/9b71dfbc5070437c9c7ca5c782064c66 "
"/detail/a6c77d0470684ae5a8f8392d40e83342 "
"/detail/a6ffe906a3e346f9a0c66e192984d59a "
"/detail/b8a2a9864af44b828306d8899392f225 "
"/detail/c2405af772b244b6b5fd8ddc7ce5c6ac "
"/detail/db159ada61f1432680578d7766e4d9eb "
"/detail/e0350e02fe1c4ea19208ee559ad0f7ea "
"/detail/e07668b437ce44a9a6a4bbd80083fb0c "
"/navigation/44d0c741f1c04c008728f1d3ab7ec5bf "
"/navigation/591c1da6b3dd4940bf3872ac851abd04 "
"/navigation/484a749a1a2345f396c30b6078e4bbb2 "
"/navigation/805f99bd458c4176ae973f800e3c6f48 "
"/navigation/a89173a67c3341f998a1efb8b101547d "
"/navigation/74c703ceae8c4d1e91ea8edfd9c7b233 "
b"/»_ââšMpªXTÎ|ãâ\v "
b"ä}!╠\t SO»ÑØ=└ò\x00\x7F ² "
]
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/383ac47a208b4902995ac1d8501a6508' , '/navigation/018a8e05871277b3a98578efc759b2ae' , '/navigation/018b0514daa07661a240c4784f1607fb' , '/navigation/7a87c3a0613e473aa36bc385ecc48ba5' , '/navigation/de55ac55c8744b3ba91b40943e39df3c' , '/navigation/4d22bc54ff254743b336c146b3123ccc' , '/navigation/018bfb93368a704e8af377e7aee49656' , '/navigation/018eeb03f4c578b99eb910e577d32e50' , '/navigation/00e4c01624c947fc844677be6041823b' , '/navigation/0c5b4ddfaf954f009425d95b676966c4' , '/navigation/f97a7bd4acb04faeba5a712260189f31' , '/navigation/b402cab0b2c14e149544f53befcfed9f' , '/navigation/2321866ea02f445f8fe99ab86154ab39' , '/navigation/523e1fc48edb4fa49f4646cbdfc363f3' , '/navigation/480c057d500b42bb93f2637f023ab85e' , '/navigation/54e6efb5b26f4b7a9820940f4ec66b23' , '/navigation/9f2d5ccf1e1b4e5a936541e0075c042b' , '/navigation/018a466213977684a147cad54481e914' , '/navigation/018b27df7b6b779b945a4d9f32a586ed' , '/navigation/018bb31e02ff7f75813589fcc073faab' , '/navigation/018c5d3a0dd37a90ae96d8f612981f17' , '/navigation/018de54cf1e37130a702d8f14411136f' , '/navigation/018fa009510f7950bc30514f13f17150' , '/navigation/01900b15d11376e0975bf5b0c59759e2' , '/navigation/1be10bc161df4d8fb4b2d7d794d7d70b' , '/navigation/0192c3a069f579aa843a9cf369328e13' , '/navigation/8aac33a98cd2432e8e5bc815ea190b8c' , '/navigation/1de51695f23c4c4cb18945804a6be7c9' , '/navigation/dc894dac99af4299814040fdf7f8f8de' , '/navigation/5b93b0d06b634346af8bbd4a86478f0f' , '/navigation/b819de59af684d9c97629478c63c43f0' , '/navigation/018c19eefe757082a2b5543639d38b94' , '/navigation/b9c63eb740be4bc4806693973a0417a5' , '/navigation/99ec5149ab9e4588bdd9b8c93f7757f7' , '/navigation/cf56d9e7a1d740569f14aa63a194d160' , '/navigation/93f676700eed4a489d7ed42dc728f2e0' , '/navigation/018b03e09e4871b29a575f75dbc07380' , '/navigation/b3e8b65b967f4cd5a876a323039ebf6d' , '/navigation/294ff0a0d4684cdb8a7afb02bf601d5d' , '/navigation/47a458bf51fb4c21a9b0e361ee2fccad' , '/navigation/b689a161eb1841c28b82f64d1acf2322' , '/navigation/f479edb2a8754436893e6f9495ad5eae' , '/navigation/018bc7ae2c9a7209b27a5ce880f4e621' , '/navigation/f1243af5c0ae4a548d85a8e9944de228' , '/navigation/0cf9d7e6a92343feaf2143d68e4fa2f3' , '/navigation/018b23b3be28720881be1be7d85aaf22' , '/navigation/018c90807d7a7ee4a491f8e0922bfd68' , '/navigation/018dc68486f974c0823096bcc9863fc1' , '/navigation/018de54c816376b194f2233fc6dfce7e' , '/navigation/59209182e0c94b91b420c670c4662d14' , '/navigation/5c3bc1e7533b47ca93637a785d855444' , '/navigation/b2a3dd3856c348a099065eae1aaf3bca' , '/navigation/4c41b51b942c4844998aee954bbeae8b' , '/navigation/f34bfee8839e418abc3529e5f5153312' , '/navigation/898edb7ebeae4ad8ad662ae3c33f7864' , '/navigation/0504d971c57f4831b805453304d92dba' , '/navigation/3b5cc999670243b29c2803580a42b805' , '/navigation/018e13080490792fb97c0872296cc5a5' , '/navigation/018f5742b7be786da8ed9d1c12ab3254' , '/navigation/018f61629cbb70d0aa40be7a29061ca9' , '/navigation/4f8cbc189ffc451b83501f047cd03b87' , '/navigation/e11deed955854b88bb433f3960039144' , '/navigation/a40362dba93a4cf08738785207dc712e' , '/navigation/804520db365f4281ad819ab97670a467' , '/navigation/f8198bf6f56542208e1e5d633f176bf8' , '/navigation/018bfb951ffb74ee887375f65eeab002' , '/navigation/018bfb9538e871bd86a4533b16a9642e' , '/detail/01931af6884b736ca31577f90c5bee60' , '/detail/0923a8ba1c6f4309af32b495664f71da' , '/detail/201422c5bc1e4053926362889c3c47dd' , '/detail/300dac9aa767400396d235fd897cd137' , '/detail/3b53c14fa20543e4aec3835a3309bf93' , '/detail/446a498118794a7fbffdad2d74599c34' , '/detail/4ec788768f9548249268270830715c38' , '/detail/555fd737de804d24ba4ecbbd188992b3' , '/detail/61030e283e72449c85a0eb90b5b25d1e' , '/detail/6f0b3b0bd2f540e889691c8465d1226b' , '/detail/77975a9cdd6f4894b860a6b249a14db2' , '/detail/7a661e506a3b4acfa5aa889721e11bba' , '/detail/8040362af832460bb7b5129a1028e64d' , '/detail/8688e982a9444c68b4106b830dc56332' , '/detail/95df5fc34aad4473b8f3933a528e94cc' , '/detail/9ae7f7c0f6d34503acc7a6993ef91bf7' , '/detail/9b71dfbc5070437c9c7ca5c782064c66' , '/detail/a6c77d0470684ae5a8f8392d40e83342' , '/detail/a6ffe906a3e346f9a0c66e192984d59a' , '/detail/b8a2a9864af44b828306d8899392f225' , '/detail/c2405af772b244b6b5fd8ddc7ce5c6ac' , '/detail/db159ada61f1432680578d7766e4d9eb' , '/detail/e0350e02fe1c4ea19208ee559ad0f7ea' , '/detail/e07668b437ce44a9a6a4bbd80083fb0c' , '/navigation/44d0c741f1c04c008728f1d3ab7ec5bf' , '/navigation/591c1da6b3dd4940bf3872ac851abd04' , '/navigation/484a749a1a2345f396c30b6078e4bbb2' , '/navigation/805f99bd458c4176ae973f800e3c6f48' , '/navigation/a89173a67c3341f998a1efb8b101547d' , '/navigation/74c703ceae8c4d1e91ea8edfd9c7b233' )) AND (seo_url . language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) AND (seo_url . sales_channel_id = 0x847D21CC09534FAFA59D3DC095007FFD OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
1.48 ms (16.87%)
2
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? , ? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"M"¼Tÿ%GC³6ÁF³\x12 <Ì "
b"8:Äz ‹I\x02 ™ZÁØP\x1A e\x08 "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? , ? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x4D22BC54FF254743B336C146B3123CCC , 0x383AC47A208B4902995AC1D8501A6508 ));
Copy
0.78 ms (8.92%)
1
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = ? ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = ? ) AND (`category` . `id` IN (? ))
Parameters :
[
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4% "
b"8:Äz ‹I\x02 ™ZÁØP\x1A e\x08 "
]
SELECT
`category` . `id` as `category.id` ,
`category` . `version_id` as `category.versionId` ,
`category` . `parent_id` as `category.parentId` ,
`category` . `parent_version_id` as `category.parentVersionId` ,
`category` . `after_category_id` as `category.afterCategoryId` ,
`category` . `after_category_version_id` as `category.afterCategoryVersionId` ,
`category` . `media_id` as `category.mediaId` ,
`category` . `display_nested_products` as `category.displayNestedProducts` ,
`category` . `auto_increment` as `category.autoIncrement` ,
`category` . `level` as `category.level` ,
`category` . `path` as `category.path` ,
`category` . `child_count` as `category.childCount` ,
`category` . `type` as `category.type` ,
`category` . `product_assignment_type` as `category.productAssignmentType` ,
`category` . `visible` as `category.visible` ,
`category` . `active` as `category.active` ,
`category` . `cms_page_id` as `category.cmsPageId` ,
`category` . `cms_page_version_id` as `category.cmsPageVersionId` ,
`category` . `product_stream_id` as `category.productStreamId` ,
`category` . `custom_entity_type_id` as `category.customEntityTypeId` ,
`category` . `created_at` as `category.createdAt` ,
`category` . `updated_at` as `category.updatedAt` ,
`category.translation.name` ,
`category.translation.name` as `category.name` ,
`category.translation.breadcrumb` ,
`category.translation.breadcrumb` as `category.breadcrumb` ,
`category.translation.slotConfig` ,
`category.translation.slotConfig` as `category.slotConfig` ,
`category.translation.linkType` ,
`category.translation.linkType` as `category.linkType` ,
`category.translation.internalLink` ,
`category.translation.internalLink` as `category.internalLink` ,
`category.translation.externalLink` ,
`category.translation.externalLink` as `category.externalLink` ,
`category.translation.linkNewTab` ,
`category.translation.linkNewTab` as `category.linkNewTab` ,
`category.translation.description` ,
`category.translation.description` as `category.description` ,
`category.translation.metaTitle` ,
`category.translation.metaTitle` as `category.metaTitle` ,
`category.translation.metaDescription` ,
`category.translation.metaDescription` as `category.metaDescription` ,
`category.translation.keywords` ,
`category.translation.keywords` as `category.keywords` ,
`category.translation.customFields` ,
`category.translation.customFields` as `category.customFields`
FROM
`category`
LEFT JOIN (
SELECT
`category.translation` . `category_id` ,
`category.translation` . `category_version_id` ,
`category.translation` . `breadcrumb` as `category.translation.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords`
FROM
`category_translation` `category.translation`
WHERE
`category.translation` . `language_id` = ?
) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id`
AND `category.category_translation` . `category_version_id` = `category` . `version_id`
WHERE
(`category` . `version_id` = ? )
AND (
`category` . `id` IN (? )
)
Copy
SELECT `category` . `id` as `category.id` , `category` . `version_id` as `category.versionId` , `category` . `parent_id` as `category.parentId` , `category` . `parent_version_id` as `category.parentVersionId` , `category` . `after_category_id` as `category.afterCategoryId` , `category` . `after_category_version_id` as `category.afterCategoryVersionId` , `category` . `media_id` as `category.mediaId` , `category` . `display_nested_products` as `category.displayNestedProducts` , `category` . `auto_increment` as `category.autoIncrement` , `category` . `level` as `category.level` , `category` . `path` as `category.path` , `category` . `child_count` as `category.childCount` , `category` . `type` as `category.type` , `category` . `product_assignment_type` as `category.productAssignmentType` , `category` . `visible` as `category.visible` , `category` . `active` as `category.active` , `category` . `cms_page_id` as `category.cmsPageId` , `category` . `cms_page_version_id` as `category.cmsPageVersionId` , `category` . `product_stream_id` as `category.productStreamId` , `category` . `custom_entity_type_id` as `category.customEntityTypeId` , `category` . `created_at` as `category.createdAt` , `category` . `updated_at` as `category.updatedAt` , `category.translation.name` , `category.translation.name` as `category.name` , `category.translation.breadcrumb` , `category.translation.breadcrumb` as `category.breadcrumb` , `category.translation.slotConfig` , `category.translation.slotConfig` as `category.slotConfig` , `category.translation.linkType` , `category.translation.linkType` as `category.linkType` , `category.translation.internalLink` , `category.translation.internalLink` as `category.internalLink` , `category.translation.externalLink` , `category.translation.externalLink` as `category.externalLink` , `category.translation.linkNewTab` , `category.translation.linkNewTab` as `category.linkNewTab` , `category.translation.description` , `category.translation.description` as `category.description` , `category.translation.metaTitle` , `category.translation.metaTitle` as `category.metaTitle` , `category.translation.metaDescription` , `category.translation.metaDescription` as `category.metaDescription` , `category.translation.keywords` , `category.translation.keywords` as `category.keywords` , `category.translation.customFields` , `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation` . `category_id` , `category.translation` . `category_version_id` , `category.translation` . `breadcrumb` as `category.translation.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `category.category_translation` ON `category.category_translation` . `category_id` = `category` . `id` AND `category.category_translation` . `category_version_id` = `category` . `version_id` WHERE (`category` . `version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 ) AND (`category` . `id` IN (0x383AC47A208B4902995AC1D8501A6508 ));
Copy