GET https://weitblick-demo-live.amicaldo.dev/navigation/eb04f480dd5b4ffcbc339624a0f4117e

Response
200 OK
IP
216.73.216.148
Profiled on
Token
e35188

Query Metrics

114 Database Queries
40 Different statements
192.06 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
101.26 ms
(52.72%) 		1 
SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`path_info` = ? AND `seo_url`.`route_name` = ? AND `seo_url`.`sales_channel_id` = ?)
Parameters: 
[
  "/navigation/eb04f480dd5b4ffcbc339624a0f4117e"
  "frontend.navigation.page"
  b"ɦÖ┴@âD\x14쵺2Ú¦[\f"
]
View formatted query    View runnable query    Explain query    View query backtrace
12.72 ms
(6.62%) 		1 
SELECT seo_path_info, path_info 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 (is_deleted = 0) ORDER BY seo_url.sales_channel_id ASC
Parameters: 
[
  "/navigation/eb04f480dd5b4ffcbc339624a0f4117e"
  "/navigation/335964deaf6f4d73b7b1eef5e3a58a85"
  "/navigation/7e376e0270e84ee3829b6408c52a78e7"
  "/navigation/a4f03ffae45e460ebb9897953fe17946"
  "/navigation/da13903ddd2a412fafa7e9e58b8f47c6"
  "/navigation/1a2ca571876846d4ba6e6b6fe734e5dc"
  "/navigation/013a946c4a00425b815bb4650af53f40"
  "/navigation/4310db68451c40c9b2f0384daefe6263"
  "/navigation/e157c878a1b84989aa7060d70f66ccc2"
  "/navigation/eab4232820d7490590664de04814e82e"
  "/navigation/57fcbfbfbcd34fd7b3dc339a9a83735c"
  "/navigation/0df8d3db8c784174910122214fe63f2c"
  "/navigation/16723c95c4b54d478b17f8afe8835a84"
  "/navigation/4a546763544a436397841938f737a887"
  "/navigation/d54626d29f4b4db480f7c5706eed85b7"
  "/navigation/d72860fe62a44efbadde16ccdab54377"
  "/navigation/f2443e3297ba46c6bf1a3b0cc7a74705"
  "/navigation/7bff424c58144a0e8bc00e2949aef5a1"
  "/navigation/68d1595e26e247fb9ec9b40b7c9fc1ed"
  "/navigation/b414335907824fbc854d7e989bc9d32c"
  "/navigation/d175038e6ec547b1befbfb594c954e9e"
  "/navigation/d23844ddadc0454081cc8b73784b3206"
  "/navigation/ee88a24468de4a69a31d782d793e2472"
  "/navigation/fdccb267c47043348d17585fe336a0a7"
  "/navigation/c95cb34fe58a4720a35167e13d918b87"
  "/navigation/6a8116a42d2941229a6d0e5fee1cfc15"
  "/navigation/70c383ab86d64eb0a38ad591d88fe721"
  "/navigation/c1721fa9f46d4f6282d89c12ecfa5db1"
  "/navigation/d5a01ae3fd95497bb5583c42908e3c37"
  "/navigation/cc686892258943a684f02672bc0be45f"
  "/navigation/0e769fb76e5d4adeb3e774e6ab2ab60b"
  "/navigation/f604b6400698493198065a5eec771925"
  "/navigation/cc80f177f79249479dda13154a1fdd2b"
  "/navigation/09391298494544f98684c1bea90dee0b"
  "/navigation/114471b0e31f419f920b16c0e1a9947a"
  "/navigation/150757789d1d47218c48374737790104"
  "/navigation/20acb814b49a4587a678c321a5d72772"
  "/navigation/716c77919a9c4e88a95347522007eb05"
  "/navigation/7206ced9039b46ec80fd737f8b29e1c2"
  "/navigation/aabfb1edb1284d28beb9c3f17bc2fa39"
  "/navigation/cf7d5271289f46bfbc0316f3b0cac1e0"
  "/navigation/ee44c48ba30e4ff59b70d5d34471e87f"
  "/navigation/db8b08752ac2462ca7d280dfff8bee1f"
  "/navigation/22388fe60c1748eaa3eceb0488a2ee31"
  "/navigation/b6629078bdd44195987a8a499a2e6c37"
  "/navigation/f9c907be5e6f4834bcb2cd15d69e4d28"
  "/navigation/0cf4814399fd4c8fae307ca878601f27"
  "/navigation/2aed370a79b44b5684013dd12f897e0d"
  "/navigation/38302cc2a9a74a4a9bfc3b8072beb480"
  "/navigation/3f1016933121464c8a7f7cff0b3cf0d6"
  "/navigation/6da12099db6c4d31b8d0fa020ec8bcb3"
  "/navigation/7e6a3d9ca7c54935b0d849cdf80a0aac"
  "/navigation/a0495af247fa475ea12ac6019b31404b"
  "/navigation/a06550958d824722b470a8026decfe03"
  "/navigation/f3089c9cc537417cbb313ca87053e0f4"
  "/navigation/fcf67c468afd43368061e33b962ecc28"
  "/navigation/0155961194544363b18c46102e818ec8"
  "/navigation/1bca35fec01745408c2b1bea4f0668d3"
  "/navigation/30166788f85e45a8bbdb662b71664905"
  "/navigation/6f69ed0a322f4b9f943019de9bf31a5c"
  "/navigation/7ba98d455c32441aa1506780257987a4"
  "/navigation/8f8226d837d341c09d1ba9bc2463f4ff"
  "/navigation/ab0aad4ae8b9470e8aac13f4b9d0d419"
  "/navigation/ab31c79f7aa54426b49c1322b2086b1e"
  "/navigation/eb9a11d31eef495091f717b1c4aaa096"
  "/navigation/30bc038b2b1a4b8fbb09393999be3499"
  "/navigation/46a348d1468f4a5fb04b3cd4d94722c6"
  "/navigation/2ab308eba4944cdaa6db62405a8379bc"
  "/navigation/4d58d7698f964e07a7e890aceb40bf3f"
  "/navigation/4e8749163193433ba24b6e2460119165"
  "/navigation/5b867e5fae0a4a49af8dd5237425592f"
  "/navigation/71e36666150f4cb488659d12a9a87482"
  "/navigation/a7da21eaea074a74b469c4a47ccd4578"
  "/navigation/b033c45e7df24c84bcb15c47882d6106"
  "/navigation/b2f7c9f9a2cd4412821bcc3cee816d5b"
  "/navigation/e90520e403c94b68bc790debbeb3b5f8"
  "/navigation/63f4f6ac33b14ec08dd77032fa55957a"
  "/navigation/0c430766b4874f3ea6da9be76167719a"
  "/navigation/466df7ab7b354c29bfe6b9084ee67362"
  "/navigation/4f955ef85a9642c8b4a6b7ab68ab0f49"
  "/navigation/56d8cf0a219447939050529288ab985c"
  "/navigation/68c7f9e0ff2943e9a8d90487e0f5bb05"
  "/navigation/b19c95d60dfe40e8bfc95c22eb164829"
  "/navigation/d1481634d59f4adfb635c3c8fcea2964"
  "/navigation/e9bd43797faf42eeb6b0e90ca1c43523"
  "/navigation/f87663901fc243fabf8c3abce0599cef"
  "/navigation/6506773fe4444d6f8bc9035726e832c6"
  "/navigation/2ede0e1012f049a1abb927c99e4f12a3"
  "/navigation/9805068cc49f41eca34fd6ed07eb743a"
  "/navigation/a3eb9ef9f07d4f599d8bc53fabd0e019"
  "/navigation/aee703ddf11a425ab968b7a0b7fd875e"
  "/navigation/db98bce24d6a4a9c8977b063a22ae151"
  "/navigation/ee035874fcff41fbaef878704befaa13"
  "/navigation/709ba1bdfe41410394a2034d87e3cda4"
  "/navigation/8b58db26ba71477f92bc83ee0e4cab69"
  "/navigation/ac78f4a60fc44a868493f9e993a1cabc"
  "/navigation/77db9cc58f0c44839fe281e5588d04cf"
  "/navigation/0314782b9f28491cb9596915bf38f682"
  "/navigation/1f133439ccbe4dee81d37507f6718930"
  "/navigation/2ce74a00c40e4def83c07f0f2c2a9669"
  "/navigation/7f964cdab9974d2fa044306ecee90419"
  "/navigation/981a84af365d4e64b32d0bffbb00416f"
  "/navigation/14bb4f2962884876ba780da2365dcc12"
  "/navigation/26a4677696c444c29cb9f2a2b2ec8667"
  "/navigation/4593da5b45b944ab91131bb261f0a4cb"
  "/navigation/724a2acaa3ef40ecb478ba5c3d5034dc"
  "/navigation/c27a91cc76794cceb76d96e1cb512344"
  "/navigation/58b2aceb05304e0ca898a8ae8fc154a4"
  "/navigation/b5998df260d14be4a813ce617fca0982"
  "/navigation/cbc8c51fea99440893cc7eff89b4480f"
  "/navigation/c4c1bac570cf491a9750e3d49f97f822"
  "/navigation/01636b3d5ced44a881be8968796b26ba"
  "/navigation/42ba01836a184d598f4bd1d22e3cd5e3"
  "/navigation/62cfe1dab7d746ca9de3c72b7d0b07fe"
  "/navigation/7a9cc7d5bbb14d72b77c73c07476f162"
  "/navigation/885f8af63f7e4336b378ddbd75137392"
  "/navigation/a5851e8dc0464d9f8025dc84e0956b8c"
  "/navigation/d13b75f47f414eb0b7958db6a817863b"
  "/navigation/d4cab2ee64544ac0b15e2b06f8ad2e92"
  "/navigation/ef8a570e2f6b43afb449439eba5d9dde"
  "/navigation/ccc8eb99903d45fd89e235d9458231a0"
  "/navigation/b08821cce18442d294db02a0a6924e00"
  "/navigation/0fdc4d5e5e034772b14952556af0638e"
  "/navigation/611606f0c6f845518fba411a41bf9088"
  "/navigation/e2eccc7809cb4b78957c1e72f95b4212"
  "/navigation/08d5a4c68d65410482e5b4f4f92df258"
  "/navigation/388ec84b031e4f0882ae4ab422927108"
  "/navigation/a59847e876ee46fdbc4b92e8ea5ac6fd"
  "/navigation/0d8f3c2248374fd1976acc79884cd9d6"
  "/navigation/1b5aab4da1934178891ab55472205eda"
  "/navigation/66ae8f7f71264628ab68a2258c141408"
  "/navigation/717a2d89395c4697a669272a6721ef99"
  "/navigation/332268af9eaf40b48f57e5ebc702d80f"
  "/navigation/191707d4a55148f19d4bfa82bea4fc29"
  "/navigation/4693f25f63754ea6b600dee369e8d312"
  "/navigation/61ae8498322e468cbe6176d3f784b072"
  "/navigation/7d2fc6af690a42a88955d76c7ec38b7f"
  "/navigation/91238d03eb7a4b2593fc3347dedb27cd"
  "/navigation/a058b4aee5924383839cddaf824cf4d2"
  "/navigation/aea2db9adf1b4528a8a07f99d0268a2a"
  "/navigation/be17a30bc90b451bb841692f4eaba96f"
  "/navigation/fd8745517f574b44aaab262d19c0ac88"
  "/navigation/38bb3ee19f5d4a6e87356c7e5bcc5315"
  "/navigation/47fb9a98d41f436b8f0f6295d1ec9fa2"
  "/navigation/56915b2e5e37466fb73e2abdcf29c6be"
  "/navigation/946a1c3279d846fcb06d26d9af63b183"
  "/navigation/a28e4e234bda465bb24ef4f48a440a20"
  "/navigation/a692442802e146fb841e633ec7817283"
  "/navigation/a95792710bab4eafbd77819e51b16e66"
  "/navigation/ce4620ab8deb4b839f9241c6c7046cd1"
  "/navigation/df6528ea52674b998631c492d77d62b8"
  "/navigation/efaae3ec9a6548cdabf29bfebb6bf75b"
  "/navigation/3cb747aa73f449dfada13f90962572b5"
  "/navigation/061ddc303fef4bc0bce34836e8e01ebd"
  "/navigation/0e140f9242f74a49b94aaa2db959a90e"
  "/navigation/5041ae7d467e4ebbaa28486453880f27"
  "/navigation/56fcbbbd9ed24f719842a9e7925c0dd5"
  "/navigation/5848a3e5124e43998080a5a4bb86856b"
  "/navigation/b333500c9b554095875f6dd4576ad4ba"
  "/navigation/6faba04724bb4000aae41d1c7bd04e29"
  "/navigation/23582f436dd642be85d2f2ec27c9d4e1"
  "/navigation/572ea40135134c139336e414fb631f25"
  "/navigation/73b53df0dab34ef1b135374413700eea"
  "/navigation/cd839f66d988450f854dd28a57763e27"
  "/navigation/b9c50c7b0101421689a730d31713bae1"
  "/navigation/00bd67ff1b844dd583b5d3c5a964c87b"
  "/navigation/806082c4c35e4e2dbf801fd51705bd00"
  "/navigation/c31cc0d9457042fda1ca3b39afd058d9"
  "/navigation/76465373b9a4467e9f419c20713ca31e"
  "/navigation/dc73d3eed6a846da8bc7980f22716037"
  "/navigation/15de5bb5bf6b42dab5ccf9ce37635a5d"
  "/navigation/2762116f46bd4cb4aa1f6dacb271d01f"
  "/navigation/b3e8b1c8dd1148afa4c0fe1d2a485b30"
  "/navigation/ca903238dc4b45fdbef13da77da9252a"
  "/navigation/fe7bb49ea32341eebca56a8b1a2bc02d"
  "/navigation/1cd75c55556d4da29e62ca385285f099"
  "/navigation/34d0c098d7cf4d83b4f9959930c30544"
  "/navigation/47464b4e5b59429fa3d5a3f61cefd755"
  "/navigation/53c3d460603a446698944265a42a5796"
  "/navigation/84577fc556c64484803487987d322b06"
  "/navigation/9ea7643e2e2b4b7d820b64c8354db40b"
  "/navigation/b16e3d5f13704b66b7ceb0399f955ef0"
  "/navigation/d01f945ad647477194b483f4e64f652f"
  "/navigation/daf62e84c93342c583511692f10519fb"
  "/navigation/8915a19e32e9417288d1afa133f5f85d"
  "/navigation/5accdb1ef7fe4a3e860bee1394d79972"
  "/navigation/02c7f428277947d2b690c2ae01c57a45"
  "/navigation/3cd37086f7de42549d3ade50aac606a8"
  "/navigation/449c621f3a7a4790bda9a24464dc5650"
  "/navigation/4e76a8f695c14a96824aa2b323d5c46b"
  "/navigation/78165b84127d42ac8687cb40145f7d4e"
  "/navigation/82528e6b05bb42a4aebff0e35ca396ae"
  "/navigation/a359604ca4404c96bf6b54e483c349ea"
  "/navigation/c716b72b34be4555a06005124bbdab65"
  "/navigation/e56a24e5c4db4749b14f5edea2c0d6b2"
  "/navigation/5ca56bae47874b5890b7120cfe14af1f"
  "/navigation/0d2d350032914ea2835578a0313f699f"
  "/navigation/42acf4da438242aab8108378dda43073"
  "/navigation/7df07fb18e8c41c3b88160bb91de93f0"
  "/navigation/ca3de38eb3474583a2f0634ae53799d1"
  "/navigation/64f61d742814453fabea19815dd14076"
  "/navigation/a9b9fc0cad944d83be4ab033eb9469a4"
  "/navigation/7c212c0bec7b49c493cbb8c95194a3b1"
  "/navigation/04c216d79f464ff1a361952df0ce3b6a"
  "/navigation/30f913d443334e3f86cf657056cc9677"
  "/navigation/40c7a33fcf3249239ff6b973403c22d8"
  "/navigation/435d02efb8af4af594538c8fa3db9c1f"
  "/navigation/5d6f5d2000e14acfb3924136d96cc207"
  "/navigation/abd363348e1949c2a8d92036592c7f73"
  "/navigation/e1b8f09d3f2d48c3a62968702a0449ad"
  "/navigation/f4a13cca33844654affe903719a78f94"
  "/navigation/fba2b02c10d64468910b59ad3d985c54"
  "/navigation/883951f0d4b549e88d8fbbeec5feaa25"
  "/navigation/2d015da12f8347dcaa48292bc06a0617"
  "/navigation/a2ec057a28424e6b8e41ca6425fffc95"
  "/navigation/ae48faa0d25a4cc6bacb0feed63534e2"
  "/navigation/0c559ff69e9542ed9d3682fecb98b35e"
  "/navigation/2e6fa61a57754aae8d01d628e2b84b54"
  "/navigation/50b477160ecf4fef844b72785399fc1c"
  "/navigation/7b2a62a6357442cba3c2116081913deb"
  "/navigation/ca65f74e11fc41dcacc34c243a79e36f"
  "/navigation/02e97d83856e41bca2101396d11c524a"
  "/navigation/100cb54eedca46e1a54879d396d0843f"
  "/navigation/30d84d9275a34b098b64f2e9ca288009"
  "/navigation/aee49fc9caee4e9ab608c47c50c4011a"
  "/navigation/f53d4ad89ae54e05b24b4b9bab2d2c9d"
  "/navigation/fdc8db7d1cf445c79e566c84e5dac9db"
  "/navigation/cbac585042444649aaf5dc7c4323ea12"
  "/navigation/51fc3688156a4a79bc81c7869b910638"
  "/navigation/9449ba0509064650829328fa085d614f"
  "/navigation/f6c9cc9574a4457b955855e627ea1689"
  "/navigation/07bf28f0cf9d448dade276ee52d64197"
  "/navigation/211c7e1e6a1044fa8b1db661809c55dd"
  "/navigation/53c40abaff0f49dd8d307b092de2d245"
  "/navigation/6ac560ca139a48abb6b8e3fa5376d635"
  "/navigation/7df5848745c84c148cab458351aa2ad0"
  "/navigation/82b442afd73044a5826f9acc05c0bb04"
  "/navigation/97910f1d6f31468aa06c4338968336cb"
  "/navigation/9a3c925d590f4ba186948edfac382c0c"
  "/navigation/9f7682458b784f4baa93c14ee6be8a8a"
  "/navigation/f98c0573f57d4a0da8f3b75b85f68cfd"
  "/navigation/39ad92815cb14dba80e3d63ccfee0819"
  "/navigation/7496adc2ca65441b9664e51a07099921"
  "/navigation/91ad40c086e74933a265e4eaf2bb0017"
  "/navigation/8ad78e9f086f4d89b54e74be8d9b40fa"
  "/navigation/7b2364dfe2d44b4baf7320c6c50b50fb"
  "/navigation/0190da608d6a78869ef1f9585a52d20e"
  "/navigation/0190e5241732787ea1328614417f220c"
  "/navigation/65c653175e4e435683152def65996565"
  "/navigation/0016175714a14da3a523756da7f905d0"
  "/navigation/972ef6b21b214d1f955330dab7c85da9"
  "/navigation/1f961226ba864952a44f5d9f51f3b6f5"
  "/navigation/46f5c54bcf26448f9d3b2811650ba6b1"
  "/navigation/2a213d1a069849f4867beb72df16784b"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ɦÖ┴@âD\x14쵺2Ú¦[\f"
]
View formatted query    View runnable query    Explain query    View query backtrace
11.78 ms
(6.13%) 		14 
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`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01ì▒ìnlq\x1E¬pì\x00E`└-"
]
View formatted query    View runnable query    Explain query    View query backtrace
9.15 ms
(4.76%) 		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: 
[
  b"ɦÖ┴@âD\x14쵺2Ú¦[\f"
  "MolliePayments.config.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
6.89 ms
(3.59%) 		7 
# 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
5.71 ms
(2.97%) 		14 
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters: 
[
  b"\x01ì▒ìnlq\x1E¬pì\x00E`└-"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.54 ms
(2.88%) 		1 
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
5.18 ms
(2.70%) 		8 
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, COALESCE(`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"\x06[·^÷(OD½èÊ_¼\x06ù²"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.76 ms
(2.48%) 		7 
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
3.49 ms
(1.82%) 		7 
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
2.90 ms
(1.51%) 		2 
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters: 
[
  "payload"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.44 ms
(1.27%) 		1 
SELECT `country_state`.`id` as `country_state.id`, `country_state`.`country_id` as `country_state.countryId`, `country_state`.`short_code` as `country_state.shortCode`, `country_state`.`position` as `country_state.position`, `country_state`.`active` as `country_state.active`, `country_state`.`created_at` as `country_state.createdAt`, `country_state`.`updated_at` as `country_state.updatedAt`, `country_state.translation.name`, COALESCE(`country_state.translation.name`,`country_state.translation.name`) as `country_state.name`, `country_state.translation.customFields`, COALESCE(`country_state.translation.customFields`,`country_state.translation.customFields`) as `country_state.customFields`, `country_state.translation.createdAt`, `country_state.translation.updatedAt`, `country_state.translation.countryStateId`, `country_state.translation.languageId` FROM `country_state` LEFT JOIN (SELECT `country_state.translation`.country_state_id, `country_state.translation`.name as `country_state.translation.name`, `country_state.translation`.custom_fields as `country_state.translation.customFields`, `country_state.translation`.created_at as `country_state.translation.createdAt`, `country_state.translation`.updated_at as `country_state.translation.updatedAt`, `country_state.translation`.country_state_id as `country_state.translation.countryStateId`, `country_state.translation`.language_id as `country_state.translation.languageId` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation`.language_id = ?) `country_state.country_state_translation` ON `country_state.country_state_translation`.`country_state_id` = `country_state`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.23 ms
(1.16%) 		2 
# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"~7n\x02pèNã‚›d\x08Å*xç"
  b"0╝\x03ï+\x1AKÅ╗\t99Ö¥4Ö"
  b"ë\x04ô€Ý[Oü¼3–$ ô\x11~"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.76 ms
(0.92%) 		3 
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`parent_id` = ? AND `category`.`active` = ?)) ORDER BY `category`.`auto_increment` ASC
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"¡Æ\x0E.Z÷B§‡÷¹:|wd&"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
1.73 ms
(0.90%) 		2 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ä°UÈ~ÔAÊÀ"╩\x0EÅ%╚¼"
  b"»`ÀïѨ@@ƒA\x18\x1ETœ\x7FÂ"
  b"Ts,\x1A¯¥A▒àOØÇ%¢p░"
  b"L\x07ì╣:¼ASá┌¨▄á\x12N╔"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.35 ms
(0.71%) 		2 
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, `plugin.translation.description`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, `plugin.translation.changelog`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, `plugin.translation.customFields`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = ?) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`name` = ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "EnderecoShopware6ClientStore"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.32 ms
(0.69%) 		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ïBBXhq█ѾÉ`,F▀║"
  b"%k\x1F‚y\tI\x11–EŸ’sØ\vT"
  b"qFJn§àL¹Š\f\t\e\eŒÙF"
  b"""
    ¥3´~<TBT’…\n
    ?SMhÃ
    """
  b"‘¯ú0ßÛA\x19‡7MËçsŠÇ"
  b"\x01‹BGLår¨™\x08ÿjY;Ú/"
  b"\x01‹BGP\x17q™º\x11°\x08µ\x0FÜ£"
  b"\x01‹BGR¡qâ”1or+Üï¨"
  b"\x01ïBGR¥qÍÉ\x1DÑ┌î╠lY"
  b"\x01‹BGRÇpþ˜­±çý|·‘"
  b"\x01‹BGRÐp¹¯¶4§h¦kc"
  b"\x01‹BGRÙpÅ•º‚\x0EŠ¿M/"
  b"\x01ïBGRÔs.Øk2­%C├ "
  b"\x01‹BGRìr£¿õ\òUÑ%°"
  b"\x01‹BGRõqп½³).›‚("
  b"""
    \x01‹BGRÿpn¡Æ\n
    \fPÚÎè
    """
  b"\x01‹BGS\tpøž4Ð7ªŒÅd"
  b"\x01ïBGS\x12qç©]"\x15\r\x03Iü"
  b"\x01‹BGS\x1CsϱÏ\x06\x00¨¯]]"
  b"\x01ïBGS$s&ØP%½a/û^"
  b"\x01‹BGS/qE¾\x0Fò™õ‚¶œ"
  b"\x01‹BGS8p៙}ÁHÊÌW"
  b"\x01‹BGSAs8¹É7\x04“)t¦"
  b"\x01‹BGSdq#³s\x10e¢«¡t"
  b"\x01‹BGSppGª\x1A¸IKøåÌ"
  b"\x01ïBGSzpV«nJÍfo\x06ì"
  b"\x01‹BGS„rj‹™d‚Ós¾Ë"
  b"\x01‹BGS¤p¶‹)ÀÛ=‘úª"
  b"\x01‹BGS¸s²‘Ãf\x15*«\t4"
  b"""
    \x01‹BGSÁq€¾\n
    „«¹\x15ÒY
    """
  b"\x01‹BGSËsÔ·9\x11ŒÝ\x14ŽM"
  b"\x01‹BGSÓpŽ¡ÑB\x02Vu\x1D\x13"
  b"\x01‹BGSÜrö¥•ûNù‘À*"
  b"\x01‹BGSæp(½:˜ç§Li3"
  b"\x01‹BGSïpˆž¼\x1F§ú¬lW"
  b"\x01‹BGSùq?¬™\eUè´ç¥"
  b"\x01‹BGT\x03sØšŠ\x00‰Ù&\x1CÚ"
  b"\x01‹BGV\x1Dq\x7F»3†6d\f/h"
  b"\x01‹BGV)q\x07‡}û,<ÞwŒ"
  b"\x01ïBGV4qý┐RM│WÉiU"
  b"\x01‹BGVdrò­Î=â<,Ô¢"
  b"\x01‹BGY>ra‘\x0E‹x¦}\x0Fy"
  b"""
    \x01‹BGYGp)†\n
    ˆó\fŽ\x1Dë
    """
  b"\x01ïBGYSp=│üÓk)§ƒX"
  b"\x01‹BGY^sV‹\x08!¤·ÝG\x01"
  b"\x01‹BGYjpS‹ŽúÈ\x10ù­Î"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.02 ms
(0.53%) 		2 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"ɦÖ┴@âD\x14쵺2Ú¦[\f"
  "kI92xuDKA2hPVkdvnY500FyrJ41otpw7"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.91 ms
(0.47%) 		1 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ë\x04ô€Ý[Oü¼3–$ ô\x11~"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(0.46%) 		2 
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.84 ms
(0.44%) 		1 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"a\x16\x06­ã°EQÅ║A\x1AA┐Éê"
  b"\x0FÜM^^\x03Gr±IRUjðcŽ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(0.33%) 		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/eb04f480dd5b4ffcbc339624a0f4117e"
  b"ɦÖ┴@âD\x14쵺2Ú¦[\f"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(0.30%) 		1 
SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.30%) 		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"ɦÖ┴@âD\x14쵺2Ú¦[\f"
  b"Ùlw§MyBð¢Ú,ÂÎsÂ8"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(0.30%) 		1 
SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = ?
Parameters: 
[
  b"ɦÖ┴@âD\x14쵺2Ú¦[\f"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(0.28%) 		1 
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.locale_id, `language.locale.translation`.name as `language.locale.translation.name`, `language.locale.translation`.territory as `language.locale.translation.territory`, `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.language_id = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(0.28%) 		2 
#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "kI92xuDKA2hPVkdvnY500FyrJ41otpw7"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(0.27%) 		1 
SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.displayName`, COALESCE(`salutation.translation.displayName`,`salutation.translation.displayName`) as `salutation.displayName`, `salutation.translation.letterName`, COALESCE(`salutation.translation.letterName`,`salutation.translation.letterName`) as `salutation.letterName`, `salutation.translation.customFields`, COALESCE(`salutation.translation.customFields`,`salutation.translation.customFields`) as `salutation.customFields`, `salutation.translation.createdAt`, `salutation.translation.updatedAt`, `salutation.translation.salutationId`, `salutation.translation.languageId` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.salutation_id, `salutation.translation`.display_name as `salutation.translation.displayName`, `salutation.translation`.letter_name as `salutation.translation.letterName`, `salutation.translation`.custom_fields as `salutation.translation.customFields`, `salutation.translation`.created_at as `salutation.translation.createdAt`, `salutation.translation`.updated_at as `salutation.translation.updatedAt`, `salutation.translation`.salutation_id as `salutation.translation.salutationId`, `salutation.translation`.language_id as `salutation.translation.languageId` FROM `salutation_translation` `salutation.translation` WHERE `salutation.translation`.language_id = ?) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.21%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(0.21%) 		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.40 ms
(0.21%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  "CrefoPay.config.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(0.20%) 		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.37 ms
(0.19%) 		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"Ú\x163QîÆI\x19©uØpÖ"-."
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.19%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.15%) 		1 
SELECT `app`.`id` FROM `app` LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.15%) 		1 
SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.14%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.14%) 		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
0.23 ms
(0.12%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
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.