GET https://tinbe.generationshop.dev/navigation/6041ac629ff74981aaa6aa1fdb80d1c7

Response
200 OK
IP
66.249.70.1
Profiled on
Token
5166fe

Query Metrics

78 Database Queries
35 Different statements
35.01 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
5.54 ms
(15.82%) 		1 
# seo_url::replacement
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/6041ac629ff74981aaa6aa1fdb80d1c7"
  "/navigation/dd1ba816880040fdac3bf9839b3409e2"
  "/navigation/de547c6d204c418fbd3e1fb25e37cec1"
  "/navigation/09a0ede5b6024a1188169a1698257db0"
  "/navigation/dcae9805bf87402c91ff65192f4c6d39"
  "/navigation/3e3786427f3745668d85c1700d8f6dc4"
  "/navigation/210a507d02494830ac7f9cd0e44bce63"
  "/navigation/018bd791dbe47781bd06a26ef992eb03"
  "/navigation/5d8ad572dd24426c8f3b5abc340cf1e0"
  "/navigation/c70243cec476472a9f27ef41f6de1263"
  "/navigation/0ea2ef9abda6407db54ad6bd17321ae1"
  "/navigation/8ca5e5a13d854c26bc06316d448e2e33"
  "/navigation/9dd9a7be22084026b3c0c80748a2b650"
  "/navigation/018bd7bb7bd5747ba6b2123e107ba46a"
  "/navigation/d387b5437e08428081a4322725714c70"
  "/navigation/018bd7c74eee774c929fe063692f6438"
  "/navigation/018bd7c7c19e796a85772cc72155784c"
  "/navigation/018bd7c7ed727223b82addcd3d99a0a6"
  "/navigation/746ef7d056884b43b9ea715e2ccd1004"
  "/navigation/6983903fa8f447fabe478a5d036ccce8"
  "/navigation/97539461afc94a4ba2e94ecc02c50e91"
  "/navigation/93a64522c07f41e9940a48687d7a9de9"
  "/navigation/6e671e43c0ec44909a7532fcc60799d0"
  "/navigation/76f654081d49467688f1fee985033186"
  "/navigation/018bd82e162f7661ab6352322801dcfa"
  "/navigation/006a311f810f4a90a7d9edf3f3e04bdd"
  "/navigation/303e495ddda64b9f97109f8f7277cb01"
  "/navigation/2fea4e8dc478455c80e78a7c9a9549db"
  "/navigation/9df078f8c56c40be81590260a0e882d4"
  "/navigation/0f196697b9134f05aead0ee205778f3f"
  "/navigation/0931c7404d334a70a9b26e19b7ff1596"
  "/navigation/136fb1d824db4650ab869d00dc563b92"
  "/navigation/f496849e2e1b4a8a9182eb3b9e5b4955"
  "/navigation/7259223ac335478f9ea3ee94ed686171"
  "/navigation/c83982e05cb644e4aad72edb7a050149"
  "/navigation/130430dbc57445fe88d5c7b0d1562b19"
  "/navigation/3a02503acba54961982efcd0637849ca"
  "/navigation/9d359fd841a74f5d902f3fea0f7f267c"
  "/navigation/edcdb491bab148af98891db83d714d64"
  "/navigation/ba18c8c299cd4d6cbbb002cc638ae476"
  "/navigation/018deecdd9f47c679274a757e35582dc"
  "/navigation/d7396d7de88040e08752c05c50a42af0"
  "/navigation/018deb5bed6678d7bfab7d3c0c363929"
  "/navigation/80722507a8e04bf4adf8da352f09d9db"
  "/navigation/018deb6a88ea7ab6bfd60014c57e78eb"
  "/navigation/d310019432cf489a81a15c9e1b3fed12"
  "/navigation/7505bd05eb434a06a8e08f5ea45c8e22"
  "/navigation/57f6eea92ad2454199d66b3f373cd798"
  "/navigation/e17e79e0795d40198517b4b30f3c5958"
  "/navigation/9bcbce7f90e444889bf5793b1a1535bd"
  "/navigation/7db6a3a4fd174e8f96e92f3fea8af73a"
  "/navigation/ecb1ff13ef66444098ed6b1b393af6cb"
  "/navigation/638264e5676c4392b5d6ffb0cf0bbd8a"
  "/navigation/9158c41954fe4b1aa58028ea5bdf60c8"
  "/navigation/6ef3fd2f16c044eda561a923a4b0c5a4"
  "/navigation/83d4d1012f4443e8bca2d3c72324bd02"
  "/navigation/1272d660a184459cbd4f251d519c1434"
  "/navigation/275649d9330c4ab8b340197274ed1a17"
  "/navigation/f1617d75e5d04ce7b79057a11531e5d5"
  "/navigation/b9bc9f37ab0b4282b3184b084840fdc9"
  "/navigation/d77e7367ef464dc3bf2dea88916b924b"
  "/navigation/a7a530ae60a84acbbeab8b1bbd936add"
  "/navigation/e1bc84cfe0c24e16a48029293023f6d1"
  "/navigation/91d513b49de9404e9546bc56ff0108af"
  "/navigation/d57fbe09e19e4e57911fc72993a81be6"
  "/navigation/133439abeb2f4264b9caf030a12ec3c7"
  "/navigation/94a57d259fbf4fa48b61e7b06c40aafb"
  "/navigation/87341c2a85a34a339103d152f49662e9"
  "/navigation/15fe45c5d0f2453b96df8368d67e9931"
  "/navigation/976b49fac2ea4b83a8581f2b199d6e91"
  "/detail/269896df53174bc7acd92f6be1b8d7b9"
  "/navigation/1bf0d6251ac546aaa95723063f8aec23"
  "/navigation/e860a9f1b87e439db76f1f5672e5dcb5"
  "/navigation/a8051eaa592e4fa28286559bfdef221f"
  "/navigation/2842a9b5ab7a49589e0c9ce67095dadf"
  "/navigation/bc5142b6174c41778f8bfc5b5bff9d44"
  "/navigation/89acb45d240b4448951d2fdd8f27c069"
  "/navigation/153eaaec48aa4a22aab5ce4a4e032ce9"
  "/navigation/7c4f802d0e3b46f197ae3b7d804c2973"
  "/detail/018ec1db6eed73a3abbb360a8a985a15"
  "/detail/018ec1e138e573cfb106b39a38a9de18"
  "/detail/018ec1cb02f872dfa73fcbc845ee3aa9"
  "/navigation/2b0d8806038c47c3997225b405d890db"
  "/navigation/00b058bc4b9148c9b0c7c616f6c9b8d5"
  "/navigation/a4cc9589f6eb4d6e9a2b9e7a04344ca1"
  "/navigation/be432b5bef5540ab97646bf296dda98b"
  "/navigation/3a168a99437f4161bfb64f2d74bc59a1"
  "/navigation/b768cab78b6a4249b059f6402bb04ce6"
  "/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7"
  "/detail/70858eb69d604037869ebb6566e56203"
  "/navigation/88fda88a92bb415a81ecdb55cad77a19"
  "/navigation/6f33b8b26fc74ed0ad29de64da1f9cdf"
  "/navigation/06e0709e1ff542569f0ef0bf73748fd7"
  "/navigation/977b6fd0a4a444ec837febd2dec119a4"
  "/navigation/cc68f4e32abb4971a1aa983cd0fcff2f"
  "/navigation/21dd1fc46966402d8661fbda2cf5e0bc"
  "/navigation/c157e9398c3a4e47a4b5e93feb73b121"
  "/navigation/d1367ab402ca49e7837c3c50201d4cac"
  "/navigation/f3df76b7c84b47f798c77d2f913eed91"
  "/navigation/f3e9be797473451baed3e8465a86dedb"
  "/navigation/a3e75d8056de4f3f841aafa61044b6da"
  "/navigation/77700d219eab4e12bd754dd31bcd7c45"
  "/navigation/18c287a81016486db014a6b12f842d80"
  "/navigation/614e860d3d7a4cd3a302edd00ccc384f"
  "/navigation/a22732ded4cf4a9699bdf718383c2e0c"
  "/navigation/9f765a78682e44f686358031d242dacb"
  "/navigation/aeb3081167ff43e3a7cad358b73934cc"
  "/navigation/05668311095d49f9959f90cad7a0cd4e"
  "/navigation/d240c1d282874be8a650c49e4430d019"
  "/navigation/a9514ed3727c4e238d52b367305efecb"
  "/navigation/ae92020fc70647f7a822e1a5ffc323cf"
  "/navigation/e7f381b818a74e97bcb62a770dbc0a3f"
  "/navigation/3885dbf3a63c4b1b84f85792fb8a4536"
  "/navigation/5aed49078d6f4a66be3c1c7b28f28ecc"
  "/navigation/e998fa5f026b467d86418f9a053dde3a"
  "/navigation/9bdb2d41fd05409380f2962a30a305ec"
  "/navigation/019fef3ea2034a02923ff6e29b9fd586"
  "/navigation/8b3d60ccfcb647d5a92992f7ce2ba69e"
  "/navigation/e5bd89229efa4fd8bdc40961e44af7c2"
  "/navigation/991eefe06ff64c17bf7d1200f5eff970"
  "/navigation/5e84685cc49b44ab9ac019c1d9aeea2b"
  "/navigation/193cff7fd2fc47838b7709396d9f7bf8"
  "/navigation/8919cfec1b134954a3b45e934861ba4f"
  "/navigation/54e57ca9300e4a1880421eea97d43da0"
  "/navigation/39012a41817f44af87d33cf4490d2b38"
  "/navigation/a016a87c446f4c9880f3f269f4ac16c1"
  "/navigation/64115a40330b4543b464cffdf12c345f"
  "/navigation/08b13d7084154c92b2eb2075b287307c"
  "/navigation/7641236cd7e545c19259015da0d7dafc"
  "/navigation/5a2f79dbf7fc45a7b3ef662499db9800"
  "/navigation/018cf811d9a9772484a6c381d3249b6c"
  "/navigation/1954e5bbe16a4d0dade155ad59ce4e01"
  "/navigation/d668890f1fca4488a358f0f4f7e6f931"
  "/navigation/018b615e1337726aa9da148cc7aa5fa4"
  "/navigation/018b61f0a9c674228b777f6b5eb4280a"
  b"\x08\ºvä÷Bˆ°úܾB\–¤"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.16 ms
(14.73%) 		15 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "MolliePayments.config.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.60 ms
(13.13%) 		9 
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
3.17 ms
(9.04%) 		9 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2.30 ms
(6.57%) 		2 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters: 
[
  "payload"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.86 ms
(5.32%) 		9 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.46 ms
(4.16%) 		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.fallback_2.name`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_2.name`,`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.fallback_2.breadcrumb`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_2.breadcrumb`,`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.fallback_2.slotConfig`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_2.slotConfig`,`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.fallback_2.linkType`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_2.linkType`,`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.fallback_2.internalLink`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_2.internalLink`,`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.fallback_2.externalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_2.externalLink`,`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.fallback_2.linkNewTab`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_2.linkNewTab`,`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.fallback_2.description`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_2.description`,`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.fallback_2.metaTitle`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_2.metaTitle`,`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.fallback_2.metaDescription`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_2.metaDescription`,`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.fallback_2.keywords`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_2.keywords`,`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.fallback_2.customFields`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_2.customFields`,`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.fallback_2.createdAt`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_2.updatedAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_2.categoryId`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_2.languageId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_2.categoryVersionId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId`, `category.translation.fallback_1`.name as `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb as `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config as `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type as `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link as `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link as `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab as `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description as `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title as `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description as `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords as `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields as `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at as `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at as `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id as `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id as `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id as `category.translation.fallback_1.categoryVersionId`, `category.translation.fallback_2`.name as `category.translation.fallback_2.name`, `category.translation.fallback_2`.breadcrumb as `category.translation.fallback_2.breadcrumb`, `category.translation.fallback_2`.slot_config as `category.translation.fallback_2.slotConfig`, `category.translation.fallback_2`.link_type as `category.translation.fallback_2.linkType`, `category.translation.fallback_2`.internal_link as `category.translation.fallback_2.internalLink`, `category.translation.fallback_2`.external_link as `category.translation.fallback_2.externalLink`, `category.translation.fallback_2`.link_new_tab as `category.translation.fallback_2.linkNewTab`, `category.translation.fallback_2`.description as `category.translation.fallback_2.description`, `category.translation.fallback_2`.meta_title as `category.translation.fallback_2.metaTitle`, `category.translation.fallback_2`.meta_description as `category.translation.fallback_2.metaDescription`, `category.translation.fallback_2`.keywords as `category.translation.fallback_2.keywords`, `category.translation.fallback_2`.custom_fields as `category.translation.fallback_2.customFields`, `category.translation.fallback_2`.created_at as `category.translation.fallback_2.createdAt`, `category.translation.fallback_2`.updated_at as `category.translation.fallback_2.updatedAt`, `category.translation.fallback_2`.category_id as `category.translation.fallback_2.categoryId`, `category.translation.fallback_2`.language_id as `category.translation.fallback_2.languageId`, `category.translation.fallback_2`.category_version_id as `category.translation.fallback_2.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_1`.category_version_id LEFT JOIN `category_translation` `category.translation.fallback_2` ON `category.translation`.`category_id` = `category.translation.fallback_2`.`category_id` AND `category.translation.fallback_2`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_2`.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"É(Ü\x17ÎWI\x05¾ù%-Ò¤hò"
  b"\x08\ºvä÷Bˆ°úܾB\–¤"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"`A¼bƒ¸Iü¬ª¬\x1F█ÇÐÃ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.98 ms
(2.81%) 		1 
SELECT seo_path_info FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?) AND (is_canonical = ?) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1
Parameters: 
[
  b"\x08\ºvä÷Bˆ°úܾB\–¤"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "Over-ons"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
0.98 ms
(2.80%) 		1 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.fallback_2.name`, `sales_channel.translation.fallback_1.name`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.fallback_2.name`,`sales_channel.translation.fallback_1.name`,`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.fallback_2.homeSlotConfig`, `sales_channel.translation.fallback_1.homeSlotConfig`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.fallback_2.homeSlotConfig`,`sales_channel.translation.fallback_1.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.fallback_2.homeEnabled`, `sales_channel.translation.fallback_1.homeEnabled`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.fallback_2.homeEnabled`,`sales_channel.translation.fallback_1.homeEnabled`,`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.fallback_2.homeName`, `sales_channel.translation.fallback_1.homeName`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.fallback_2.homeName`,`sales_channel.translation.fallback_1.homeName`,`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.fallback_2.homeMetaTitle`, `sales_channel.translation.fallback_1.homeMetaTitle`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.fallback_2.homeMetaTitle`,`sales_channel.translation.fallback_1.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.fallback_2.homeMetaDescription`, `sales_channel.translation.fallback_1.homeMetaDescription`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.fallback_2.homeMetaDescription`,`sales_channel.translation.fallback_1.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.fallback_2.homeKeywords`, `sales_channel.translation.fallback_1.homeKeywords`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.fallback_2.homeKeywords`,`sales_channel.translation.fallback_1.homeKeywords`,`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.fallback_2.customFields`, `sales_channel.translation.fallback_1.customFields`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.fallback_2.customFields`,`sales_channel.translation.fallback_1.customFields`,`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.fallback_2.createdAt`, `sales_channel.translation.fallback_1.createdAt`, `sales_channel.translation.createdAt`, `sales_channel.translation.fallback_2.updatedAt`, `sales_channel.translation.fallback_1.updatedAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.fallback_2.salesChannelId`, `sales_channel.translation.fallback_1.salesChannelId`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.fallback_2.languageId`, `sales_channel.translation.fallback_1.languageId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId`, `sales_channel.translation.fallback_1`.name as `sales_channel.translation.fallback_1.name`, `sales_channel.translation.fallback_1`.home_slot_config as `sales_channel.translation.fallback_1.homeSlotConfig`, `sales_channel.translation.fallback_1`.home_enabled as `sales_channel.translation.fallback_1.homeEnabled`, `sales_channel.translation.fallback_1`.home_name as `sales_channel.translation.fallback_1.homeName`, `sales_channel.translation.fallback_1`.home_meta_title as `sales_channel.translation.fallback_1.homeMetaTitle`, `sales_channel.translation.fallback_1`.home_meta_description as `sales_channel.translation.fallback_1.homeMetaDescription`, `sales_channel.translation.fallback_1`.home_keywords as `sales_channel.translation.fallback_1.homeKeywords`, `sales_channel.translation.fallback_1`.custom_fields as `sales_channel.translation.fallback_1.customFields`, `sales_channel.translation.fallback_1`.created_at as `sales_channel.translation.fallback_1.createdAt`, `sales_channel.translation.fallback_1`.updated_at as `sales_channel.translation.fallback_1.updatedAt`, `sales_channel.translation.fallback_1`.sales_channel_id as `sales_channel.translation.fallback_1.salesChannelId`, `sales_channel.translation.fallback_1`.language_id as `sales_channel.translation.fallback_1.languageId`, `sales_channel.translation.fallback_2`.name as `sales_channel.translation.fallback_2.name`, `sales_channel.translation.fallback_2`.home_slot_config as `sales_channel.translation.fallback_2.homeSlotConfig`, `sales_channel.translation.fallback_2`.home_enabled as `sales_channel.translation.fallback_2.homeEnabled`, `sales_channel.translation.fallback_2`.home_name as `sales_channel.translation.fallback_2.homeName`, `sales_channel.translation.fallback_2`.home_meta_title as `sales_channel.translation.fallback_2.homeMetaTitle`, `sales_channel.translation.fallback_2`.home_meta_description as `sales_channel.translation.fallback_2.homeMetaDescription`, `sales_channel.translation.fallback_2`.home_keywords as `sales_channel.translation.fallback_2.homeKeywords`, `sales_channel.translation.fallback_2`.custom_fields as `sales_channel.translation.fallback_2.customFields`, `sales_channel.translation.fallback_2`.created_at as `sales_channel.translation.fallback_2.createdAt`, `sales_channel.translation.fallback_2`.updated_at as `sales_channel.translation.fallback_2.updatedAt`, `sales_channel.translation.fallback_2`.sales_channel_id as `sales_channel.translation.fallback_2.salesChannelId`, `sales_channel.translation.fallback_2`.language_id as `sales_channel.translation.fallback_2.languageId` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.fallback_1` ON `sales_channel.translation`.`sales_channel_id` = `sales_channel.translation.fallback_1`.`sales_channel_id` AND `sales_channel.translation.fallback_1`.language_id = ? LEFT JOIN `sales_channel_translation` `sales_channel.translation.fallback_2` ON `sales_channel.translation`.`sales_channel_id` = `sales_channel.translation.fallback_2`.`sales_channel_id` AND `sales_channel.translation.fallback_2`.language_id = ? WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` WHERE (`sales_channel`.`active` = ?)
Parameters: 
[
  b"É(Ü\x17ÎWI\x05¾ù%-Ò¤hò"
  b"\x08\ºvä÷Bˆ°úܾB\–¤"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(1.92%) 		3 
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id = ?) AND (property.module = ?)
Parameters: 
[
  b"\x16+š\x16†}JP¾\x7F¿Û»\x1DíÓ"
  "frontend.navigation.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(1.78%) 		1 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(1.57%) 		1 
SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = ? AND `is_canonical` = 1 AND
                  `sales_channel_id` = ? AND `language_id` IN (?, ?, ?)
Parameters: 
[
  "/navigation/6041ac629ff74981aaa6aa1fdb80d1c7"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"L\x036²A\x05CÚ±Êò6O:xt"
  b"\x08\ºvä÷Bˆ°úܾB\–¤"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(1.44%) 		2 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "t4opWgwWXNBgGuLczHn96dcndAjyK4E4"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(1.40%) 		1 
SELECT `jett_mce_setting`.`id` as `jett_mce_setting.id`, `jett_mce_setting`.`active` as `jett_mce_setting.active`, `jett_mce_setting`.`label` as `jett_mce_setting.label`, `jett_mce_setting`.`api_key` as `jett_mce_setting.apiKey`, `jett_mce_setting`.`list_id` as `jett_mce_setting.listId`, `jett_mce_setting`.`list_name` as `jett_mce_setting.listName`, `jett_mce_setting`.`store_id` as `jett_mce_setting.storeId`, `jett_mce_setting`.`store_name` as `jett_mce_setting.storeName`, `jett_mce_setting`.`store_domain_id` as `jett_mce_setting.storeDomainId`, `jett_mce_setting`.`store_currency_code` as `jett_mce_setting.storeCurrencyCode`, `jett_mce_setting`.`store_connected_site` as `jett_mce_setting.storeConnectedSite`, `jett_mce_setting`.`embed_connected_site` as `jett_mce_setting.embedConnectedSite`, `jett_mce_setting`.`customer_groups` as `jett_mce_setting.customerGroups`, `jett_mce_setting`.`subscriber_status` as `jett_mce_setting.subscriberStatus`, `jett_mce_setting`.`abandoned_carts` as `jett_mce_setting.abandonedCarts`, `jett_mce_setting`.`log_storage_period` as `jett_mce_setting.logStoragePeriod`, `jett_mce_setting`.`sync_limit` as `jett_mce_setting.syncLimit`, `jett_mce_setting`.`stats` as `jett_mce_setting.stats`, `jett_mce_setting`.`merge_fields` as `jett_mce_setting.mergeFields`, `jett_mce_setting`.`subscriber_sync_active` as `jett_mce_setting.subscriberSyncActive`, `jett_mce_setting`.`sync_all_languages` as `jett_mce_setting.syncAllLanguages`, `jett_mce_setting`.`sync_custom_fields_active` as `jett_mce_setting.syncCustomFieldsActive`, `jett_mce_setting`.`vendor_option` as `jett_mce_setting.vendorOption`, `jett_mce_setting`.`stats_sync_date` as `jett_mce_setting.statsSyncDate`, `jett_mce_setting`.`last_sync_date_for_orders` as `jett_mce_setting.lastSyncDateForOrders`, `jett_mce_setting`.`last_sync_date_for_products` as `jett_mce_setting.lastSyncDateForProducts`, `jett_mce_setting`.`last_sync_date_for_customers` as `jett_mce_setting.lastSyncDateForCustomers`, `jett_mce_setting`.`last_sync_date_for_subscribers` as `jett_mce_setting.lastSyncDateForSubscribers`, `jett_mce_setting`.`created_at` as `jett_mce_setting.createdAt`, `jett_mce_setting`.`updated_at` as `jett_mce_setting.updatedAt`, (SELECT GROUP_CONCAT(HEX(`jett_mce_setting.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `jett_mce_setting_sales_channel` `jett_mce_setting.salesChannels.mapping`
                  WHERE `jett_mce_setting.salesChannels.mapping`.`jett_mce_setting_id` = `jett_mce_setting`.`id` ) as `jett_mce_setting.salesChannels.id_mapping`, (SELECT GROUP_CONCAT(HEX(`jett_mce_setting.languages.mapping`.`language_id`) SEPARATOR '||')
                  FROM `jett_mce_setting_language` `jett_mce_setting.languages.mapping`
                  WHERE `jett_mce_setting.languages.mapping`.`jett_mce_setting_id` = `jett_mce_setting`.`id` ) as `jett_mce_setting.languages.id_mapping` FROM `jett_mce_setting` WHERE `jett_mce_setting`.`id` IN (?)
Parameters: 
[
  b"\x01ŒCÇóãv€›5Ôx»À¸ì"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(1.38%) 		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"Rmi0±ÝIÕºwö)¦¤w÷"
  b"­Çò‚X¶Oš¨wÒ7³@ˆ®"
  b"ÅL|g\x0E'EL¶\x13ÉÖÑéç‹"
  b"l›î.G\x08OàžßP\x01€Èéº"
  b"""
    ~/ëàÕd@- ë\n
    \x0FB]ü¸
    """
  b"¥¶6o\x10+A÷’LÚ¯+‹¿."
  b"®ÇÐj÷sFu¡®\rÔ˜£N="
  b"ʃ$Ã\tUCö¦Ÿ’0PxfW"
  b"Þ$U¿Œ¢Kš„|ž9~@ri"
  b"­ã:╔\x06▀AÉɳ\x07x\x01E¦k"
  b"\x01ÅQ▄-Ïuvè.ýqkB\x00\x00"
  b"\x01ÅQÔ¶Øs\x19░A\x05Ȩ═ V"
  b"È\f¨É\vðIPïô│Ú╚Ç°÷"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(1.30%) 		1 
# dbal-plugin-loader
        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`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(1.30%) 		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;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(1.29%) 		1 
SELECT `jett_mce_setting`.`id` FROM `jett_mce_setting` LEFT JOIN `jett_mce_setting_sales_channel` `jett_mce_setting.salesChannels.mapping` ON `jett_mce_setting`.`id` = `jett_mce_setting.salesChannels.mapping`.`jett_mce_setting_id`  LEFT JOIN `sales_channel` `jett_mce_setting.salesChannels` ON `jett_mce_setting.salesChannels.mapping`.`sales_channel_id` = `jett_mce_setting.salesChannels`.`id`  WHERE (`jett_mce_setting.salesChannels`.`id` = ?) GROUP BY `jett_mce_setting`.`id`
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(1.14%) 		1 
SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = ? AND `payment_method`.`active` = ?)
Parameters: 
[
  "Kiener\MolliePayments\Handler\Method\ApplePayPayment"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(1.09%) 		1 
SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          JSON_UNQUOTE(JSON_EXTRACT(`domain`.custom_fields, '$.isoCode')) AS overriddenLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = ?
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(1.00%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.96%) 		1 
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id IS NULL) AND (property.module = ?)
Parameters: 
[
  "frontend.navigation.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.85%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)
Parameters: 
[
  b"\x08\ºvä÷Bˆ°úܾB\–¤"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "Over-ons/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.81%) 		1 
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"\x10\x1E\x15J¹$M\x0E•‘˜\x7Fƒ! ±"
  b"\x12£:î\x1C\x1F@–¬c¬\x01=ˆËí"
  b"(\r─\x1C«ôM\x13ôÔó8ÅC9c"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  b"¸R$ô\x07jHl¢\x00¹JÐÒ/Ç"
  b"¿¤éßj¹Fû°ï?eÀߊ^"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.80%) 		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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.76%) 		2 
#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "t4opWgwWXNBgGuLczHn96dcndAjyK4E4"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.73%) 		1 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  b"CÕL P»L\x07Ÿ3|-'i’\x16"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.64%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.60%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "nl-BE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.57%) 		1 
SELECT `sales_channel_domain`.`id` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` = ?) LIMIT 1
Parameters: 
[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.57%) 		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` FROM `language` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"\x08\ºvä÷Bˆ°úܾB\–¤"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.53%) 		1 
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE `sales_channel_domain`.`id` IN (?)
Parameters: 
[
  b"""
    \x01Å\x17ÏïNrnĹÌMÂ\n
    Ë«
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.46%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.42%) 		1 
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.28%) 		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',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.