0.65 ms
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.override_1.name` , `category.translation.name` , COALESCE (`category.translation.override_1.name` , `category.translation.name` ) as `category.name` , `category.translation.override_1.breadcrumb` , `category.translation.breadcrumb` , COALESCE (`category.translation.override_1.breadcrumb` , `category.translation.breadcrumb` ) as `category.breadcrumb` , `category.translation.override_1.slotConfig` , `category.translation.slotConfig` , COALESCE (`category.translation.override_1.slotConfig` , `category.translation.slotConfig` ) as `category.slotConfig` , `category.translation.override_1.linkType` , `category.translation.linkType` , COALESCE (`category.translation.override_1.linkType` , `category.translation.linkType` ) as `category.linkType` , `category.translation.override_1.internalLink` , `category.translation.internalLink` , COALESCE (`category.translation.override_1.internalLink` , `category.translation.internalLink` ) as `category.internalLink` , `category.translation.override_1.externalLink` , `category.translation.externalLink` , COALESCE (`category.translation.override_1.externalLink` , `category.translation.externalLink` ) as `category.externalLink` , `category.translation.override_1.linkNewTab` , `category.translation.linkNewTab` , COALESCE (`category.translation.override_1.linkNewTab` , `category.translation.linkNewTab` ) as `category.linkNewTab` , `category.translation.override_1.description` , `category.translation.description` , COALESCE (`category.translation.override_1.description` , `category.translation.description` ) as `category.description` , `category.translation.override_1.metaTitle` , `category.translation.metaTitle` , COALESCE (`category.translation.override_1.metaTitle` , `category.translation.metaTitle` ) as `category.metaTitle` , `category.translation.override_1.metaDescription` , `category.translation.metaDescription` , COALESCE (`category.translation.override_1.metaDescription` , `category.translation.metaDescription` ) as `category.metaDescription` , `category.translation.override_1.keywords` , `category.translation.keywords` , COALESCE (`category.translation.override_1.keywords` , `category.translation.keywords` ) as `category.keywords` , `category.translation.override_1.customFields` , `category.translation.customFields` , COALESCE (`category.translation.override_1.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.override_1` . `breadcrumb` as `category.translation.override_1.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation.override_1` . `name` as `category.translation.override_1.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation.override_1` . `custom_fields` as `category.translation.override_1.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation.override_1` . `slot_config` as `category.translation.override_1.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation.override_1` . `link_type` as `category.translation.override_1.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation.override_1` . `internal_link` as `category.translation.override_1.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation.override_1` . `external_link` as `category.translation.override_1.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation.override_1` . `link_new_tab` as `category.translation.override_1.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation.override_1` . `description` as `category.translation.override_1.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation.override_1` . `meta_title` as `category.translation.override_1.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation.override_1` . `meta_description` as `category.translation.override_1.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` , `category.translation.override_1` . `keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation` . `category_id` = `category.translation.override_1` . `category_id` AND `category.translation.override_1` . `language_id` = ? AND `category.translation` . `category_version_id` = `category.translation.override_1` . `category_version_id` 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"oVúÚY™A ¶~ð±¥ymñ "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x0F ©\x1C ãéjK¾KÙÎu,4%pÞ»Û²l4ïŸ(ûX…öØ° "
b"\x04 ¾·┘¸ÈNç×ÿì(\x00 ÚÖ\x12 ]
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.override_1.name` ,
`category.translation.name` ,
COALESCE (
`category.translation.override_1.name` ,
`category.translation.name`
) as `category.name` ,
`category.translation.override_1.breadcrumb` ,
`category.translation.breadcrumb` ,
COALESCE (
`category.translation.override_1.breadcrumb` ,
`category.translation.breadcrumb`
) as `category.breadcrumb` ,
`category.translation.override_1.slotConfig` ,
`category.translation.slotConfig` ,
COALESCE (
`category.translation.override_1.slotConfig` ,
`category.translation.slotConfig`
) as `category.slotConfig` ,
`category.translation.override_1.linkType` ,
`category.translation.linkType` ,
COALESCE (
`category.translation.override_1.linkType` ,
`category.translation.linkType`
) as `category.linkType` ,
`category.translation.override_1.internalLink` ,
`category.translation.internalLink` ,
COALESCE (
`category.translation.override_1.internalLink` ,
`category.translation.internalLink`
) as `category.internalLink` ,
`category.translation.override_1.externalLink` ,
`category.translation.externalLink` ,
COALESCE (
`category.translation.override_1.externalLink` ,
`category.translation.externalLink`
) as `category.externalLink` ,
`category.translation.override_1.linkNewTab` ,
`category.translation.linkNewTab` ,
COALESCE (
`category.translation.override_1.linkNewTab` ,
`category.translation.linkNewTab`
) as `category.linkNewTab` ,
`category.translation.override_1.description` ,
`category.translation.description` ,
COALESCE (
`category.translation.override_1.description` ,
`category.translation.description`
) as `category.description` ,
`category.translation.override_1.metaTitle` ,
`category.translation.metaTitle` ,
COALESCE (
`category.translation.override_1.metaTitle` ,
`category.translation.metaTitle`
) as `category.metaTitle` ,
`category.translation.override_1.metaDescription` ,
`category.translation.metaDescription` ,
COALESCE (
`category.translation.override_1.metaDescription` ,
`category.translation.metaDescription`
) as `category.metaDescription` ,
`category.translation.override_1.keywords` ,
`category.translation.keywords` ,
COALESCE (
`category.translation.override_1.keywords` ,
`category.translation.keywords`
) as `category.keywords` ,
`category.translation.override_1.customFields` ,
`category.translation.customFields` ,
COALESCE (
`category.translation.override_1.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.override_1` . `breadcrumb` as `category.translation.override_1.breadcrumb` ,
`category.translation` . `name` as `category.translation.name` ,
`category.translation.override_1` . `name` as `category.translation.override_1.name` ,
`category.translation` . `custom_fields` as `category.translation.customFields` ,
`category.translation.override_1` . `custom_fields` as `category.translation.override_1.customFields` ,
`category.translation` . `slot_config` as `category.translation.slotConfig` ,
`category.translation.override_1` . `slot_config` as `category.translation.override_1.slotConfig` ,
`category.translation` . `link_type` as `category.translation.linkType` ,
`category.translation.override_1` . `link_type` as `category.translation.override_1.linkType` ,
`category.translation` . `internal_link` as `category.translation.internalLink` ,
`category.translation.override_1` . `internal_link` as `category.translation.override_1.internalLink` ,
`category.translation` . `external_link` as `category.translation.externalLink` ,
`category.translation.override_1` . `external_link` as `category.translation.override_1.externalLink` ,
`category.translation` . `link_new_tab` as `category.translation.linkNewTab` ,
`category.translation.override_1` . `link_new_tab` as `category.translation.override_1.linkNewTab` ,
`category.translation` . `description` as `category.translation.description` ,
`category.translation.override_1` . `description` as `category.translation.override_1.description` ,
`category.translation` . `meta_title` as `category.translation.metaTitle` ,
`category.translation.override_1` . `meta_title` as `category.translation.override_1.metaTitle` ,
`category.translation` . `meta_description` as `category.translation.metaDescription` ,
`category.translation.override_1` . `meta_description` as `category.translation.override_1.metaDescription` ,
`category.translation` . `keywords` as `category.translation.keywords` ,
`category.translation.override_1` . `keywords` as `category.translation.override_1.keywords`
FROM
`category_translation` `category.translation`
LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation` . `category_id` = `category.translation.override_1` . `category_id`
AND `category.translation.override_1` . `language_id` = ?
AND `category.translation` . `category_version_id` = `category.translation.override_1` . `category_version_id`
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.override_1.name` , `category.translation.name` , COALESCE (`category.translation.override_1.name` , `category.translation.name` ) as `category.name` , `category.translation.override_1.breadcrumb` , `category.translation.breadcrumb` , COALESCE (`category.translation.override_1.breadcrumb` , `category.translation.breadcrumb` ) as `category.breadcrumb` , `category.translation.override_1.slotConfig` , `category.translation.slotConfig` , COALESCE (`category.translation.override_1.slotConfig` , `category.translation.slotConfig` ) as `category.slotConfig` , `category.translation.override_1.linkType` , `category.translation.linkType` , COALESCE (`category.translation.override_1.linkType` , `category.translation.linkType` ) as `category.linkType` , `category.translation.override_1.internalLink` , `category.translation.internalLink` , COALESCE (`category.translation.override_1.internalLink` , `category.translation.internalLink` ) as `category.internalLink` , `category.translation.override_1.externalLink` , `category.translation.externalLink` , COALESCE (`category.translation.override_1.externalLink` , `category.translation.externalLink` ) as `category.externalLink` , `category.translation.override_1.linkNewTab` , `category.translation.linkNewTab` , COALESCE (`category.translation.override_1.linkNewTab` , `category.translation.linkNewTab` ) as `category.linkNewTab` , `category.translation.override_1.description` , `category.translation.description` , COALESCE (`category.translation.override_1.description` , `category.translation.description` ) as `category.description` , `category.translation.override_1.metaTitle` , `category.translation.metaTitle` , COALESCE (`category.translation.override_1.metaTitle` , `category.translation.metaTitle` ) as `category.metaTitle` , `category.translation.override_1.metaDescription` , `category.translation.metaDescription` , COALESCE (`category.translation.override_1.metaDescription` , `category.translation.metaDescription` ) as `category.metaDescription` , `category.translation.override_1.keywords` , `category.translation.keywords` , COALESCE (`category.translation.override_1.keywords` , `category.translation.keywords` ) as `category.keywords` , `category.translation.override_1.customFields` , `category.translation.customFields` , COALESCE (`category.translation.override_1.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.override_1` . `breadcrumb` as `category.translation.override_1.breadcrumb` , `category.translation` . `name` as `category.translation.name` , `category.translation.override_1` . `name` as `category.translation.override_1.name` , `category.translation` . `custom_fields` as `category.translation.customFields` , `category.translation.override_1` . `custom_fields` as `category.translation.override_1.customFields` , `category.translation` . `slot_config` as `category.translation.slotConfig` , `category.translation.override_1` . `slot_config` as `category.translation.override_1.slotConfig` , `category.translation` . `link_type` as `category.translation.linkType` , `category.translation.override_1` . `link_type` as `category.translation.override_1.linkType` , `category.translation` . `internal_link` as `category.translation.internalLink` , `category.translation.override_1` . `internal_link` as `category.translation.override_1.internalLink` , `category.translation` . `external_link` as `category.translation.externalLink` , `category.translation.override_1` . `external_link` as `category.translation.override_1.externalLink` , `category.translation` . `link_new_tab` as `category.translation.linkNewTab` , `category.translation.override_1` . `link_new_tab` as `category.translation.override_1.linkNewTab` , `category.translation` . `description` as `category.translation.description` , `category.translation.override_1` . `description` as `category.translation.override_1.description` , `category.translation` . `meta_title` as `category.translation.metaTitle` , `category.translation.override_1` . `meta_title` as `category.translation.override_1.metaTitle` , `category.translation` . `meta_description` as `category.translation.metaDescription` , `category.translation.override_1` . `meta_description` as `category.translation.override_1.metaDescription` , `category.translation` . `keywords` as `category.translation.keywords` , `category.translation.override_1` . `keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation` . `category_id` = `category.translation.override_1` . `category_id` AND `category.translation.override_1` . `language_id` = 0x6F56FADA599941A0B67EF0B1A5796DF1 AND `category.translation` . `category_version_id` = `category.translation.override_1` . `category_version_id` 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 (0x70DEBBDBB26C34EF9F28FB5885F6D8B0 , 0x04F3FAD9F7D44E879E988D2800E99912 ));
Copy
0.61 ms
2
SELECT `sales_channel` . `id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel` . `id` = `sales_channel.paymentMethods.mapping` . `sales_channel_id` LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping` . `payment_method_id` = `sales_channel.paymentMethods` . `id` WHERE ((`sales_channel` . `id` = ? AND `sales_channel.paymentMethods` . `id` = ? AND `sales_channel.paymentMethods` . `active` = ? )) LIMIT 1
Parameters :
[
b"Ã@<\x05\x05 ŽAó™\x19 úZu|÷ "
b"¸©Å╔└\x10 G\x02 ®ofM½■&V "
true
]
SELECT `sales_channel` . `id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel` . `id` = `sales_channel.paymentMethods.mapping` . `sales_channel_id` LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping` . `payment_method_id` = `sales_channel.paymentMethods` . `id` WHERE ((`sales_channel` . `id` = 0xC3403C05058E41F39919A0FA5A757CF7 AND `sales_channel.paymentMethods` . `id` = 0xF7B88FC9C0104702A96F664DABFE2656 AND `sales_channel.paymentMethods` . `active` = 1 )) LIMIT 1 ; Copy
0.50 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 :
[
"/detail/e18c393a956f455ebf0bd5b415838f4b "
"/navigation/01cc1be8a894278e4a4dc08a4939fe6a "
"/navigation/01909b675712761c8731d9a12b7f506d "
"/navigation/60cda19ce0904569845f4a6e76baabf1 "
"/navigation/04f3fad9f7d44e879e988d2800e99912 "
"/account/recover "
b"oVúÚY™A ¶~ð±¥ymñ "
b"Ã@<\x05\x05 ŽAó™\x19 úZu|÷ "
]
SELECT seo_path_info , path_info , sales_channel_id FROM seo_url WHERE (seo_url . is_canonical = 1 ) AND (seo_url . path_info IN ('/detail/e18c393a956f455ebf0bd5b415838f4b' , '/navigation/01cc1be8a894278e4a4dc08a4939fe6a' , '/navigation/01909b675712761c8731d9a12b7f506d' , '/navigation/60cda19ce0904569845f4a6e76baabf1' , '/navigation/04f3fad9f7d44e879e988d2800e99912' , '/account/recover' )) AND (seo_url . language_id = 0x6F56FADA599941A0B67EF0B1A5796DF1 ) AND (seo_url . sales_channel_id = 0xC3403C05058E41F39919A0FA5A757CF7 OR seo_url . sales_channel_id IS NULL ) AND (seo_url . is_deleted = 0 );
Copy
0.44 ms
1
SELECT `cbax_gpsr_manufacturer` . `id` as `cbax_gpsr_manufacturer.id` , `cbax_gpsr_manufacturer` . `internal_name` as `cbax_gpsr_manufacturer.internalName` , `cbax_gpsr_manufacturer` . `import_id` as `cbax_gpsr_manufacturer.importId` , `cbax_gpsr_manufacturer` . `created_at` as `cbax_gpsr_manufacturer.createdAt` , `cbax_gpsr_manufacturer` . `updated_at` as `cbax_gpsr_manufacturer.updatedAt` , `cbax_gpsr_manufacturer.translation.override_1.name` , `cbax_gpsr_manufacturer.translation.name` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.name` , `cbax_gpsr_manufacturer.translation.name` ) as `cbax_gpsr_manufacturer.name` , `cbax_gpsr_manufacturer.translation.override_1.street1` , `cbax_gpsr_manufacturer.translation.street1` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.street1` , `cbax_gpsr_manufacturer.translation.street1` ) as `cbax_gpsr_manufacturer.street1` , `cbax_gpsr_manufacturer.translation.override_1.street2` , `cbax_gpsr_manufacturer.translation.street2` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.street2` , `cbax_gpsr_manufacturer.translation.street2` ) as `cbax_gpsr_manufacturer.street2` , `cbax_gpsr_manufacturer.translation.override_1.zipcode` , `cbax_gpsr_manufacturer.translation.zipcode` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.zipcode` , `cbax_gpsr_manufacturer.translation.zipcode` ) as `cbax_gpsr_manufacturer.zipcode` , `cbax_gpsr_manufacturer.translation.override_1.city` , `cbax_gpsr_manufacturer.translation.city` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.city` , `cbax_gpsr_manufacturer.translation.city` ) as `cbax_gpsr_manufacturer.city` , `cbax_gpsr_manufacturer.translation.override_1.phoneNumber` , `cbax_gpsr_manufacturer.translation.phoneNumber` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.phoneNumber` , `cbax_gpsr_manufacturer.translation.phoneNumber` ) as `cbax_gpsr_manufacturer.phoneNumber` , `cbax_gpsr_manufacturer.translation.override_1.email` , `cbax_gpsr_manufacturer.translation.email` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.email` , `cbax_gpsr_manufacturer.translation.email` ) as `cbax_gpsr_manufacturer.email` , `cbax_gpsr_manufacturer.translation.override_1.url` , `cbax_gpsr_manufacturer.translation.url` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.url` , `cbax_gpsr_manufacturer.translation.url` ) as `cbax_gpsr_manufacturer.url` , `cbax_gpsr_manufacturer.translation.override_1.countryId` , `cbax_gpsr_manufacturer.translation.countryId` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.countryId` , `cbax_gpsr_manufacturer.translation.countryId` ) as `cbax_gpsr_manufacturer.countryId` FROM `cbax_gpsr_manufacturer` LEFT JOIN (SELECT `cbax_gpsr_manufacturer.translation` . `cbax_gpsr_manufacturer_id` , `cbax_gpsr_manufacturer.translation` . `name` as `cbax_gpsr_manufacturer.translation.name` , `cbax_gpsr_manufacturer.translation.override_1` . `name` as `cbax_gpsr_manufacturer.translation.override_1.name` , `cbax_gpsr_manufacturer.translation` . `street1` as `cbax_gpsr_manufacturer.translation.street1` , `cbax_gpsr_manufacturer.translation.override_1` . `street1` as `cbax_gpsr_manufacturer.translation.override_1.street1` , `cbax_gpsr_manufacturer.translation` . `street2` as `cbax_gpsr_manufacturer.translation.street2` , `cbax_gpsr_manufacturer.translation.override_1` . `street2` as `cbax_gpsr_manufacturer.translation.override_1.street2` , `cbax_gpsr_manufacturer.translation` . `zipcode` as `cbax_gpsr_manufacturer.translation.zipcode` , `cbax_gpsr_manufacturer.translation.override_1` . `zipcode` as `cbax_gpsr_manufacturer.translation.override_1.zipcode` , `cbax_gpsr_manufacturer.translation` . `city` as `cbax_gpsr_manufacturer.translation.city` , `cbax_gpsr_manufacturer.translation.override_1` . `city` as `cbax_gpsr_manufacturer.translation.override_1.city` , `cbax_gpsr_manufacturer.translation` . `phone_number` as `cbax_gpsr_manufacturer.translation.phoneNumber` , `cbax_gpsr_manufacturer.translation.override_1` . `phone_number` as `cbax_gpsr_manufacturer.translation.override_1.phoneNumber` , `cbax_gpsr_manufacturer.translation` . `email` as `cbax_gpsr_manufacturer.translation.email` , `cbax_gpsr_manufacturer.translation.override_1` . `email` as `cbax_gpsr_manufacturer.translation.override_1.email` , `cbax_gpsr_manufacturer.translation` . `url` as `cbax_gpsr_manufacturer.translation.url` , `cbax_gpsr_manufacturer.translation.override_1` . `url` as `cbax_gpsr_manufacturer.translation.override_1.url` , `cbax_gpsr_manufacturer.translation` . `country_id` as `cbax_gpsr_manufacturer.translation.countryId` , `cbax_gpsr_manufacturer.translation.override_1` . `country_id` as `cbax_gpsr_manufacturer.translation.override_1.countryId` FROM `cbax_gpsr_manufacturer_translation` `cbax_gpsr_manufacturer.translation` LEFT JOIN `cbax_gpsr_manufacturer_translation` `cbax_gpsr_manufacturer.translation.override_1` ON `cbax_gpsr_manufacturer.translation` . `cbax_gpsr_manufacturer_id` = `cbax_gpsr_manufacturer.translation.override_1` . `cbax_gpsr_manufacturer_id` AND `cbax_gpsr_manufacturer.translation.override_1` . `language_id` = ? WHERE `cbax_gpsr_manufacturer.translation` . `language_id` = ? ) `cbax_gpsr_manufacturer.cbax_gpsr_manufacturer_translation` ON `cbax_gpsr_manufacturer.cbax_gpsr_manufacturer_translation` . `cbax_gpsr_manufacturer_id` = `cbax_gpsr_manufacturer` . `id` WHERE (`cbax_gpsr_manufacturer` . `id` = ? )
Parameters :
[
b"oVúÚY™A ¶~ð±¥ymñ "
b"/»_ââšMpªXTÎ|ãâ\v "
b"\x01 “µ-|!r#¤¡4\x1F ÏÈ\x10  ]
SELECT
`cbax_gpsr_manufacturer` . `id` as `cbax_gpsr_manufacturer.id` ,
`cbax_gpsr_manufacturer` . `internal_name` as `cbax_gpsr_manufacturer.internalName` ,
`cbax_gpsr_manufacturer` . `import_id` as `cbax_gpsr_manufacturer.importId` ,
`cbax_gpsr_manufacturer` . `created_at` as `cbax_gpsr_manufacturer.createdAt` ,
`cbax_gpsr_manufacturer` . `updated_at` as `cbax_gpsr_manufacturer.updatedAt` ,
`cbax_gpsr_manufacturer.translation.override_1.name` ,
`cbax_gpsr_manufacturer.translation.name` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.name` ,
`cbax_gpsr_manufacturer.translation.name`
) as `cbax_gpsr_manufacturer.name` ,
`cbax_gpsr_manufacturer.translation.override_1.street1` ,
`cbax_gpsr_manufacturer.translation.street1` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.street1` ,
`cbax_gpsr_manufacturer.translation.street1`
) as `cbax_gpsr_manufacturer.street1` ,
`cbax_gpsr_manufacturer.translation.override_1.street2` ,
`cbax_gpsr_manufacturer.translation.street2` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.street2` ,
`cbax_gpsr_manufacturer.translation.street2`
) as `cbax_gpsr_manufacturer.street2` ,
`cbax_gpsr_manufacturer.translation.override_1.zipcode` ,
`cbax_gpsr_manufacturer.translation.zipcode` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.zipcode` ,
`cbax_gpsr_manufacturer.translation.zipcode`
) as `cbax_gpsr_manufacturer.zipcode` ,
`cbax_gpsr_manufacturer.translation.override_1.city` ,
`cbax_gpsr_manufacturer.translation.city` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.city` ,
`cbax_gpsr_manufacturer.translation.city`
) as `cbax_gpsr_manufacturer.city` ,
`cbax_gpsr_manufacturer.translation.override_1.phoneNumber` ,
`cbax_gpsr_manufacturer.translation.phoneNumber` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.phoneNumber` ,
`cbax_gpsr_manufacturer.translation.phoneNumber`
) as `cbax_gpsr_manufacturer.phoneNumber` ,
`cbax_gpsr_manufacturer.translation.override_1.email` ,
`cbax_gpsr_manufacturer.translation.email` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.email` ,
`cbax_gpsr_manufacturer.translation.email`
) as `cbax_gpsr_manufacturer.email` ,
`cbax_gpsr_manufacturer.translation.override_1.url` ,
`cbax_gpsr_manufacturer.translation.url` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.url` ,
`cbax_gpsr_manufacturer.translation.url`
) as `cbax_gpsr_manufacturer.url` ,
`cbax_gpsr_manufacturer.translation.override_1.countryId` ,
`cbax_gpsr_manufacturer.translation.countryId` ,
COALESCE (
`cbax_gpsr_manufacturer.translation.override_1.countryId` ,
`cbax_gpsr_manufacturer.translation.countryId`
) as `cbax_gpsr_manufacturer.countryId`
FROM
`cbax_gpsr_manufacturer`
LEFT JOIN (
SELECT
`cbax_gpsr_manufacturer.translation` . `cbax_gpsr_manufacturer_id` ,
`cbax_gpsr_manufacturer.translation` . `name` as `cbax_gpsr_manufacturer.translation.name` ,
`cbax_gpsr_manufacturer.translation.override_1` . `name` as `cbax_gpsr_manufacturer.translation.override_1.name` ,
`cbax_gpsr_manufacturer.translation` . `street1` as `cbax_gpsr_manufacturer.translation.street1` ,
`cbax_gpsr_manufacturer.translation.override_1` . `street1` as `cbax_gpsr_manufacturer.translation.override_1.street1` ,
`cbax_gpsr_manufacturer.translation` . `street2` as `cbax_gpsr_manufacturer.translation.street2` ,
`cbax_gpsr_manufacturer.translation.override_1` . `street2` as `cbax_gpsr_manufacturer.translation.override_1.street2` ,
`cbax_gpsr_manufacturer.translation` . `zipcode` as `cbax_gpsr_manufacturer.translation.zipcode` ,
`cbax_gpsr_manufacturer.translation.override_1` . `zipcode` as `cbax_gpsr_manufacturer.translation.override_1.zipcode` ,
`cbax_gpsr_manufacturer.translation` . `city` as `cbax_gpsr_manufacturer.translation.city` ,
`cbax_gpsr_manufacturer.translation.override_1` . `city` as `cbax_gpsr_manufacturer.translation.override_1.city` ,
`cbax_gpsr_manufacturer.translation` . `phone_number` as `cbax_gpsr_manufacturer.translation.phoneNumber` ,
`cbax_gpsr_manufacturer.translation.override_1` . `phone_number` as `cbax_gpsr_manufacturer.translation.override_1.phoneNumber` ,
`cbax_gpsr_manufacturer.translation` . `email` as `cbax_gpsr_manufacturer.translation.email` ,
`cbax_gpsr_manufacturer.translation.override_1` . `email` as `cbax_gpsr_manufacturer.translation.override_1.email` ,
`cbax_gpsr_manufacturer.translation` . `url` as `cbax_gpsr_manufacturer.translation.url` ,
`cbax_gpsr_manufacturer.translation.override_1` . `url` as `cbax_gpsr_manufacturer.translation.override_1.url` ,
`cbax_gpsr_manufacturer.translation` . `country_id` as `cbax_gpsr_manufacturer.translation.countryId` ,
`cbax_gpsr_manufacturer.translation.override_1` . `country_id` as `cbax_gpsr_manufacturer.translation.override_1.countryId`
FROM
`cbax_gpsr_manufacturer_translation` `cbax_gpsr_manufacturer.translation`
LEFT JOIN `cbax_gpsr_manufacturer_translation` `cbax_gpsr_manufacturer.translation.override_1` ON `cbax_gpsr_manufacturer.translation` . `cbax_gpsr_manufacturer_id` = `cbax_gpsr_manufacturer.translation.override_1` . `cbax_gpsr_manufacturer_id`
AND `cbax_gpsr_manufacturer.translation.override_1` . `language_id` = ?
WHERE
`cbax_gpsr_manufacturer.translation` . `language_id` = ?
) `cbax_gpsr_manufacturer.cbax_gpsr_manufacturer_translation` ON `cbax_gpsr_manufacturer.cbax_gpsr_manufacturer_translation` . `cbax_gpsr_manufacturer_id` = `cbax_gpsr_manufacturer` . `id`
WHERE
(
`cbax_gpsr_manufacturer` . `id` = ?
)Copy
SELECT `cbax_gpsr_manufacturer` . `id` as `cbax_gpsr_manufacturer.id` , `cbax_gpsr_manufacturer` . `internal_name` as `cbax_gpsr_manufacturer.internalName` , `cbax_gpsr_manufacturer` . `import_id` as `cbax_gpsr_manufacturer.importId` , `cbax_gpsr_manufacturer` . `created_at` as `cbax_gpsr_manufacturer.createdAt` , `cbax_gpsr_manufacturer` . `updated_at` as `cbax_gpsr_manufacturer.updatedAt` , `cbax_gpsr_manufacturer.translation.override_1.name` , `cbax_gpsr_manufacturer.translation.name` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.name` , `cbax_gpsr_manufacturer.translation.name` ) as `cbax_gpsr_manufacturer.name` , `cbax_gpsr_manufacturer.translation.override_1.street1` , `cbax_gpsr_manufacturer.translation.street1` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.street1` , `cbax_gpsr_manufacturer.translation.street1` ) as `cbax_gpsr_manufacturer.street1` , `cbax_gpsr_manufacturer.translation.override_1.street2` , `cbax_gpsr_manufacturer.translation.street2` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.street2` , `cbax_gpsr_manufacturer.translation.street2` ) as `cbax_gpsr_manufacturer.street2` , `cbax_gpsr_manufacturer.translation.override_1.zipcode` , `cbax_gpsr_manufacturer.translation.zipcode` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.zipcode` , `cbax_gpsr_manufacturer.translation.zipcode` ) as `cbax_gpsr_manufacturer.zipcode` , `cbax_gpsr_manufacturer.translation.override_1.city` , `cbax_gpsr_manufacturer.translation.city` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.city` , `cbax_gpsr_manufacturer.translation.city` ) as `cbax_gpsr_manufacturer.city` , `cbax_gpsr_manufacturer.translation.override_1.phoneNumber` , `cbax_gpsr_manufacturer.translation.phoneNumber` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.phoneNumber` , `cbax_gpsr_manufacturer.translation.phoneNumber` ) as `cbax_gpsr_manufacturer.phoneNumber` , `cbax_gpsr_manufacturer.translation.override_1.email` , `cbax_gpsr_manufacturer.translation.email` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.email` , `cbax_gpsr_manufacturer.translation.email` ) as `cbax_gpsr_manufacturer.email` , `cbax_gpsr_manufacturer.translation.override_1.url` , `cbax_gpsr_manufacturer.translation.url` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.url` , `cbax_gpsr_manufacturer.translation.url` ) as `cbax_gpsr_manufacturer.url` , `cbax_gpsr_manufacturer.translation.override_1.countryId` , `cbax_gpsr_manufacturer.translation.countryId` , COALESCE (`cbax_gpsr_manufacturer.translation.override_1.countryId` , `cbax_gpsr_manufacturer.translation.countryId` ) as `cbax_gpsr_manufacturer.countryId` FROM `cbax_gpsr_manufacturer` LEFT JOIN (SELECT `cbax_gpsr_manufacturer.translation` . `cbax_gpsr_manufacturer_id` , `cbax_gpsr_manufacturer.translation` . `name` as `cbax_gpsr_manufacturer.translation.name` , `cbax_gpsr_manufacturer.translation.override_1` . `name` as `cbax_gpsr_manufacturer.translation.override_1.name` , `cbax_gpsr_manufacturer.translation` . `street1` as `cbax_gpsr_manufacturer.translation.street1` , `cbax_gpsr_manufacturer.translation.override_1` . `street1` as `cbax_gpsr_manufacturer.translation.override_1.street1` , `cbax_gpsr_manufacturer.translation` . `street2` as `cbax_gpsr_manufacturer.translation.street2` , `cbax_gpsr_manufacturer.translation.override_1` . `street2` as `cbax_gpsr_manufacturer.translation.override_1.street2` , `cbax_gpsr_manufacturer.translation` . `zipcode` as `cbax_gpsr_manufacturer.translation.zipcode` , `cbax_gpsr_manufacturer.translation.override_1` . `zipcode` as `cbax_gpsr_manufacturer.translation.override_1.zipcode` , `cbax_gpsr_manufacturer.translation` . `city` as `cbax_gpsr_manufacturer.translation.city` , `cbax_gpsr_manufacturer.translation.override_1` . `city` as `cbax_gpsr_manufacturer.translation.override_1.city` , `cbax_gpsr_manufacturer.translation` . `phone_number` as `cbax_gpsr_manufacturer.translation.phoneNumber` , `cbax_gpsr_manufacturer.translation.override_1` . `phone_number` as `cbax_gpsr_manufacturer.translation.override_1.phoneNumber` , `cbax_gpsr_manufacturer.translation` . `email` as `cbax_gpsr_manufacturer.translation.email` , `cbax_gpsr_manufacturer.translation.override_1` . `email` as `cbax_gpsr_manufacturer.translation.override_1.email` , `cbax_gpsr_manufacturer.translation` . `url` as `cbax_gpsr_manufacturer.translation.url` , `cbax_gpsr_manufacturer.translation.override_1` . `url` as `cbax_gpsr_manufacturer.translation.override_1.url` , `cbax_gpsr_manufacturer.translation` . `country_id` as `cbax_gpsr_manufacturer.translation.countryId` , `cbax_gpsr_manufacturer.translation.override_1` . `country_id` as `cbax_gpsr_manufacturer.translation.override_1.countryId` FROM `cbax_gpsr_manufacturer_translation` `cbax_gpsr_manufacturer.translation` LEFT JOIN `cbax_gpsr_manufacturer_translation` `cbax_gpsr_manufacturer.translation.override_1` ON `cbax_gpsr_manufacturer.translation` . `cbax_gpsr_manufacturer_id` = `cbax_gpsr_manufacturer.translation.override_1` . `cbax_gpsr_manufacturer_id` AND `cbax_gpsr_manufacturer.translation.override_1` . `language_id` = 0x6F56FADA599941A0B67EF0B1A5796DF1 WHERE `cbax_gpsr_manufacturer.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `cbax_gpsr_manufacturer.cbax_gpsr_manufacturer_translation` ON `cbax_gpsr_manufacturer.cbax_gpsr_manufacturer_translation` . `cbax_gpsr_manufacturer_id` = `cbax_gpsr_manufacturer` . `id` WHERE (`cbax_gpsr_manufacturer` . `id` = 0x0193B52D7C217223A4A1341FCFC810C2 ); Copy
0.43 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` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.override_1.name` , `country.translation.name` , COALESCE (`country.translation.override_1.name` , `country.translation.name` ) as `country.name` , `country.translation.override_1.addressFormat` , `country.translation.addressFormat` , COALESCE (`country.translation.override_1.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.override_1.customFields` , `country.translation.customFields` , COALESCE (`country.translation.override_1.customFields` , `country.translation.customFields` ) as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation.override_1` . `name` as `country.translation.override_1.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation.override_1` . `custom_fields` as `country.translation.override_1.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` , `country.translation.override_1` . `address_format` as `country.translation.override_1.addressFormat` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation` . `country_id` = `country.translation.override_1` . `country_id` AND `country.translation.override_1` . `language_id` = ? WHERE `country.translation` . `language_id` = ? ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (? , ? , ? , ? )
Parameters :
[
b"oVúÚY™A ¶~ð±¥ymñ "
b"/»_ââšMpªXTÎ|ãâ\v "
b"y7f6…æC€’¾'70g\x7F ä "
b"«O\x1F »`¹I~¥M-ÇèZz\x1A "
b"Ìœâ|œ·Gä¹ò\x1D àÐùÍ° "
b"ø˜ë›Ó¤E^•ŠÉ P÷§\ "
]
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` . `is_eu` as `country.isEu` ,
`country` . `created_at` as `country.createdAt` ,
`country` . `updated_at` as `country.updatedAt` ,
`country.translation.override_1.name` ,
`country.translation.name` ,
COALESCE (
`country.translation.override_1.name` ,
`country.translation.name`
) as `country.name` ,
`country.translation.override_1.addressFormat` ,
`country.translation.addressFormat` ,
COALESCE (
`country.translation.override_1.addressFormat` ,
`country.translation.addressFormat`
) as `country.addressFormat` ,
`country.translation.override_1.customFields` ,
`country.translation.customFields` ,
COALESCE (
`country.translation.override_1.customFields` ,
`country.translation.customFields`
) as `country.customFields`
FROM
`country`
LEFT JOIN (
SELECT
`country.translation` . `country_id` ,
`country.translation` . `name` as `country.translation.name` ,
`country.translation.override_1` . `name` as `country.translation.override_1.name` ,
`country.translation` . `custom_fields` as `country.translation.customFields` ,
`country.translation.override_1` . `custom_fields` as `country.translation.override_1.customFields` ,
`country.translation` . `address_format` as `country.translation.addressFormat` ,
`country.translation.override_1` . `address_format` as `country.translation.override_1.addressFormat`
FROM
`country_translation` `country.translation`
LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation` . `country_id` = `country.translation.override_1` . `country_id`
AND `country.translation.override_1` . `language_id` = ?
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` . `is_eu` as `country.isEu` , `country` . `created_at` as `country.createdAt` , `country` . `updated_at` as `country.updatedAt` , `country.translation.override_1.name` , `country.translation.name` , COALESCE (`country.translation.override_1.name` , `country.translation.name` ) as `country.name` , `country.translation.override_1.addressFormat` , `country.translation.addressFormat` , COALESCE (`country.translation.override_1.addressFormat` , `country.translation.addressFormat` ) as `country.addressFormat` , `country.translation.override_1.customFields` , `country.translation.customFields` , COALESCE (`country.translation.override_1.customFields` , `country.translation.customFields` ) as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation` . `country_id` , `country.translation` . `name` as `country.translation.name` , `country.translation.override_1` . `name` as `country.translation.override_1.name` , `country.translation` . `custom_fields` as `country.translation.customFields` , `country.translation.override_1` . `custom_fields` as `country.translation.override_1.customFields` , `country.translation` . `address_format` as `country.translation.addressFormat` , `country.translation.override_1` . `address_format` as `country.translation.override_1.addressFormat` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation` . `country_id` = `country.translation.override_1` . `country_id` AND `country.translation.override_1` . `language_id` = 0x6F56FADA599941A0B67EF0B1A5796DF1 WHERE `country.translation` . `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B ) `country.country_translation` ON `country.country_translation` . `country_id` = `country` . `id` WHERE `country` . `id` IN (0x7937663685E6438092BE273730677FE4 , 0xAB4F1FBB60B9497EA54D2DC7E85A7A1A , 0xCC9CE27C9CB747E4B9F21DE0D0F9CDB0 , 0xF898EB9BD3A4455E958AC9A050F7A75C ); Copy
0.34 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.override_1.name` , `language.locale.translation.name` , COALESCE (`language.locale.translation.override_1.name` , `language.locale.translation.name` ) as `language.locale.name` , `language.locale.translation.override_1.territory` , `language.locale.translation.territory` , COALESCE (`language.locale.translation.override_1.territory` , `language.locale.translation.territory` ) as `language.locale.territory` , `language.locale.translation.override_1.customFields` , `language.locale.translation.customFields` , COALESCE (`language.locale.translation.override_1.customFields` , `language.locale.translation.customFields` ) as `language.locale.customFields` 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.override_1` . `name` as `language.locale.translation.override_1.name` , `language.locale.translation` . `territory` as `language.locale.translation.territory` , `language.locale.translation.override_1` . `territory` as `language.locale.translation.override_1.territory` , `language.locale.translation` . `custom_fields` as `language.locale.translation.customFields` , `language.locale.translation.override_1` . `custom_fields` as `language.locale.translation.override_1.customFields` FROM `locale_translation` `language.locale.translation` LEFT JOIN `locale_translation` `language.locale.translation.override_1` ON `language.locale.translation` . `locale_id` = `language.locale.translation.override_1` . `locale_id` AND `language.locale.translation.override_1` . `language_id` = ? 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"oVúÚY™A ¶~ð±¥ymñ "
b"/»_ââšMpªXTÎ|ãâ\v "
b"oVúÚY™A ¶~ð±¥ymñ "
]
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.override_1.name` , `language.locale.translation.name` , COALESCE (`language.locale.translation.override_1.name` , `language.locale.translation.name` ) as `language.locale.name` , `language.locale.translation.override_1.territory` , `language.locale.translation.territory` , COALESCE (`language.locale.translation.override_1.territory` , `language.locale.translation.territory` ) as `language.locale.territory` , `language.locale.translation.override_1.customFields` , `language.locale.translation.customFields` , COALESCE (`language.locale.translation.override_1.customFields` , `language.locale.translation.customFields` ) as `language.locale.customFields` 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.override_1` . `name` as `language.locale.translation.override_1.name` , `language.locale.translation` . `territory` as `language.locale.translation.territory` , `language.locale.translation.override_1` . `territory` as `language.locale.translation.override_1.territory` , `language.locale.translation` . `custom_fields` as `language.locale.translation.customFields` , `language.locale.translation.override_1` . `custom_fields` as `language.locale.translation.override_1.customFields` FROM `locale_translation` `language.locale.translation` LEFT JOIN `locale_translation` `language.locale.translation.override_1` ON `language.locale.translation` . `locale_id` = `language.locale.translation.override_1` . `locale_id` AND `language.locale.translation.override_1` . `language_id` = 0x6F56FADA599941A0B67EF0B1A5796DF1 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 (0x6F56FADA599941A0B67EF0B1A5796DF1 ); Copy
0.34 ms
2
SELECT `key` , `value` FROM `app_config`
SELECT `key` , `value` FROM `app_config` ; Copy
0.33 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 = ? OR seo_path_info = ? ))
Parameters :
[
b"oVúÚY™A ¶~ð±¥ymñ "
b"Ã@<\x05\x05 ŽAó™\x19 úZu|÷ "
"Gepaecktraeger-28-Zoll-2-strebig-schwarz/632075 "
"Gepaecktraeger-28-Zoll-2-strebig-schwarz/632075/ "
]
SELECT id , path_info pathInfo , is_canonical isCanonical , sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x6F56FADA599941A0B67EF0B1A5796DF1 ) AND ((sales_channel_id = 0xC3403C05058E41F39919A0FA5A757CF7 OR sales_channel_id IS NULL )) AND ((seo_path_info = 'Gepaecktraeger-28-Zoll-2-strebig-schwarz/632075' OR seo_path_info = 'Gepaecktraeger-28-Zoll-2-strebig-schwarz/632075/' ));
Copy
0.30 ms
1
SELECT `country` . `id` FROM `country` WHERE (`country` . `active` = ? ) LIMIT 500
SELECT `country` . `id` FROM `country` WHERE (`country` . `active` = 1 ) LIMIT 500 ; Copy
0.29 ms
1
SELECT `handler_identifier` , LOWER (HEX (`id` )) FROM `payment_method`
SELECT `handler_identifier` , LOWER (HEX (`id` )) FROM `payment_method` ; Copy
0.24 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"\x01 ‹×•\x1D zv\x07 žM£ž°Ó\x12 h\x01 ‹ë¾Jyp\‰}W'ê£e¢\x01 ŽW\v\x00\x08 tQŸ\x7F\x0F ›\x05 gf\x01 ïËKDs{\x0F ┤߯¦èØ«/\x01 ïËA>\x05 tnék,░ìªSr\x01 ì\x1C ı¼Ï\x7F Üô9üL¶╬\x14 »äNg‚ÆBG·–¸‘Ï%®8÷ "
]
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 (0x018BD7951D7A76079E4DA39EB0D31268 , 0x018BEBBE4A79705C897D5727EAA365A2 , 0x018E570B000874519F7F0F9B05A06766 , 0x018BD34B44737B0FB4E1EEDD8A9DAE2F , 0x018BD3413E05746E826B2CB08DA65372 , 0x018D1CD5ACD87F9A9339814CF4CE14AF , 0xE44E6782C64247B796B891CF25AE38F7 ); Copy
0.24 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.23 ms
1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1
SELECT `name` , `type` FROM `custom_field` WHERE `active` = 1 ; Copy
0.22 ms
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ? ) AND (token = ? ) LIMIT 1
Parameters :
[
b"Ã@<\x05\x05 ŽAó™\x19 úZu|÷ "
"0LNs4Sv4JIJTO6zqU24se7IZ0Kjgu2Jc "
]
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xC3403C05058E41F39919A0FA5A757CF7 ) AND (token = '0LNs4Sv4JIJTO6zqU24se7IZ0Kjgu2Jc' ) LIMIT 1 ; Copy
0.20 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"H2E:mmF\x1D žc\x00 æ Ôžë "
]
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` = 0x4832453A6D6D461D9E6300E6A0D49EEB AND
pm . `active` = 1 ; Copy
0.19 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.18 ms
1
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = ?
Parameters :
[
"0LNs4Sv4JIJTO6zqU24se7IZ0Kjgu2Jc "
]
SELECT `cart` . `payload` , `cart` . `rule_ids` , `cart` . `compressed` FROM cart WHERE `token` = '0LNs4Sv4JIJTO6zqU24se7IZ0Kjgu2Jc' ;
Copy
0.17 ms
1
SELECT path FROM category WHERE id = ?
Parameters :
[
b"\x04 ¾·┘¸ÈNç×ÿì(\x00 ÚÖ\x12 ]
SELECT path FROM category WHERE id = 0x04F3FAD9F7D44E879E988D2800E99912 ; Copy
0.17 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.17 ms
1
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = ?
SELECT LOWER (HEX (id )) FROM snippet_set WHERE iso = 'de-DE' ; Copy
0.16 ms
1
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (? ) LIMIT 1
Parameters :
[
b"oVúÚY™A ¶~ð±¥ymñ "
]
SELECT `language` . `id` FROM `language` WHERE `language` . `id` IN (0x6F56FADA599941A0B67EF0B1A5796DF1 ) LIMIT 1 ; 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.16 ms
1
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = ? AND `sales_channel_country` . `country_id` = ? )
Parameters :
[
b"Ã@<\x05\x05 ŽAó™\x19 úZu|÷ "
b"ø˜ë›Ó¤E^•ŠÉ P÷§\ "
]
SELECT `sales_channel_country` . `sales_channel_id` , `sales_channel_country` . `country_id` FROM `sales_channel_country` WHERE (`sales_channel_country` . `sales_channel_id` = 0xC3403C05058E41F39919A0FA5A757CF7 AND `sales_channel_country` . `country_id` = 0xF898EB9BD3A4455E958AC9A050F7A75C ); Copy
0.14 ms
1
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters :
[
b"oVúÚY™A ¶~ð±¥ymñ "
]
SELECT min_search_length FROM product_search_config WHERE language_id = 0x6F56FADA599941A0B67EF0B1A5796DF1 ; Copy
0.13 ms
1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name` , `path` , `author` , `self_managed`
FROM `app`
WHERE `active` = 1
; Copy