Query Metrics
68
Database Queries
56
Different statements
451.37 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
288.88 ms (64.00%) |
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/99c810a8fcde3ae4a69f83301e808a98" "/navigation/b9ecb2e5d808346997636f272883b192" "/navigation/ea0100f34d3832c586f2fc543aa707a5" "/navigation/69db25793d0c33afbd61653fd7d1a8ed" "/navigation/1fd1f0e45b613fb688d2787c9b8177df" "/navigation/fb2b9ee997903f0b80fd5b6264c4d2c3" "/navigation/02a49671b8bd3771b4d230654332dbfa" "/navigation/ee20ad3f46333401a7b34c4d0210cba9" "/navigation/4bc0dd1bc8f93b9b92e47c438d699efe" "/navigation/6ecbf5d03f6536b7983862c6f46e93d9" "/navigation/a0c70996590e3c5ba4fe80ded59535f0" "/navigation/c3490384794c325e93ba96be02c6ce9e" "/navigation/f45c6568b49a34798feaf0628fedeac7" "/navigation/996017561c3a3ded8f2110cc95c50967" "/navigation/0e2978c6cf7a37ec88cb13b1a7fcbf6b" "/navigation/3f9fa2969d833972ba3ec04a7b3d72cd" "/navigation/a134553c512b3512adebdfc609b69081" "/navigation/61d49bea020f345cbe1e8d05f61e899d" "/navigation/e53e7e77a9ec37eeb47c7a1b98f07416" "/navigation/6129ef7a36d73851936da7c1e93a1b76" "/navigation/642d6ed7b19f3f70bd8af1775481525a" "/navigation/3a684c3bcd3f336fb3a0a792da353f82" "/navigation/273e2b0e7ef8310dbaae263f960ed292" "/navigation/12a65d1b06933a2da8657c6357d4bc4e" "/navigation/5e859863990c36ce8dd7ee59d9f90ed3" "/navigation/fd4a6b835d2a34648f064610584b932d" "/navigation/ff966bb5db513439ac76171b82b4ee2e" "/navigation/770443c5bf923a779b61c7a496980cee" "/navigation/89130563e0e13abdb4f235de414bf390" "/navigation/9929c147d34d3a4cad11fbb4401d8913" "/navigation/a153deecedc73865bb0eeb9fa8229552" "/navigation/6d983a29e89231a3aba85c7c8eb0f2cc" "/navigation/26350cb75b62356ca5da6f402783d749" "/navigation/9a8a0a9eda2c3b7eaa476c2d6d3229ab" "/navigation/1e8266f34fa832e68443f0e7e11342e0" "/navigation/dab2cc762cf335879241484e9d0b0428" "/navigation/d380c592ac053c8780373621c53c0905" "/navigation/99a8e174649e349ea0f3af9858a5d79e" "/navigation/565c9044a34534db8448284dfb523733" "/navigation/850155c674653355a3a05667341e33dd" "/navigation/2c64b93b49193679ad44e612a6c1796d" "/navigation/34ebcef0ddfa3085be11a6b3dee7116c" "/navigation/dcf4759f7eb83169927642f62b56d945" "/navigation/4fafea52d53f3866b9cd8a295b390815" "/navigation/154df2f85c3533ee9b68beeb002ac2b3" "/navigation/fb34018223d537e28df69e0706e43314" "/navigation/61918fa57da336d98cb881b774f445a9" "/navigation/92bb7d4c36713afeb2e1c98150479ae2" "/navigation/8974017b8b8438a98353a6710e309c79" "/navigation/f8f3476a387938aaae13cf8b8f20cadd" "/navigation/e6b47db614033da8a01faaa42a0ff220" "/navigation/498d7b828d103206899ed2d7885dff16" "/navigation/a46e35d0a00738b59c12d93d6bad08a3" "/navigation/1660672f22e836ec91f0a251e0b02347" "/navigation/61ede7a8592e3cb2a69e2e46a785975a" "/navigation/aad72f58f54c358b954e4689e9de23da" "/navigation/3fbc87d7deb835ecab10bd323f8e8d34" "/navigation/1c2fbbf3141a35949241fc63ad745a65" "/navigation/3059425a157c381185b39db97bd80c70" "/navigation/6e8c58f1a4f93e29b0acac315fd43b57" "/navigation/102ea4c371cd303dad05953309ad8247" "/navigation/90376df44783334b84f0a0907f1eee84" "/navigation/213630dc1fc73721b95b3d9b97015af8" "/navigation/320420f91c3033cba3f478f898ecf689" "/navigation/4cd546da2d473412abe2249ff018cab0" "/navigation/3d59d275f0b436b5b646747040db30af" "/navigation/8f59ecead94c3857b1ac0337131f4b24" "/navigation/1219414aff3b39509c48f90bb18568f6" "/navigation/904895db190137c39d7c232fe4412f18" "/navigation/91379a0118cf30078dc8b8808c74a838" "/navigation/87841a697e6f3cd380ba735df2c8395d" "/navigation/eb0a7027553b3094895647a6ae1c8a38" "/navigation/fc0dee50f0e33e79b02fc3d067ac7997" "/navigation/dd57369da1cd32f598606df232904979" "/navigation/aadf53758ffb383e9b0bb6b0fc5d3f60" "/navigation/816d470e6cea374abb27bbbb1be49d16" "/navigation/2088a35b6c943648a4bce4d77592628f" "/navigation/a75499b09abe3189ac35cee35cd2d3b7" "/navigation/a4ec3f6c2fcc3633b18f3141035e5013" "/navigation/5d87ece43383392a875d734e89db1a45" "/navigation/99c0a1e888cf383f94d60f7cc002b5a3" "/navigation/67d7b4ffcd4d391fa52283fa3871fd15" "/navigation/e2dcb9dcd374342084642742c670c212" "/navigation/f38c923b02e03f3daed92d700ec545ab" "/navigation/d8d475917bde3b20ba445b6f4d158f3a" "/navigation/591af7c793933d89b447dc1f8d03b2f0" "/navigation/9d9bb1f814be3bd9a394b071187f4b9c" "/navigation/a63d8cee931f34f4a8dcb322198fa334" "/navigation/c150229b4bd539e692ff11d3e677d64c" "/navigation/ff021e18cb88358796657191fe977ad5" "/navigation/d1fe32e933433ae49ef866534d80ce18" "/navigation/7a4396e2dbff372ebc99a0c9f7022dad" "/navigation/d1b9b730b3f434b98351ed53d39a0fb2" "/navigation/f45f0261047d3947b64ee5fb390f9ba8" "/navigation/c3d9bc3b82443ffe850820bcc2054cb2" "/navigation/e2392ef33b4737f6a6e49606588da207" "/navigation/1f5c268b3ab531e2b2c4aab4fe9985f5" "/navigation/32ba096b59803ddea65d20e5ba19b450" "/navigation/2d1c638f723434e5beb731f6bc80da8a" "/navigation/001a5cc006ef374f8804f0aad4c01607" "/navigation/5521a13632e93e37b8ee9afb6d7f0a2b" "/navigation/6f1f33dfd45c3e23bca7f9e184da8261" "/navigation/40debcb1f7c731bfb3897422539c9dec" "/navigation/7e59af1b8d583d69b3b31a8d296124c2" "/navigation/d5238b8fe4643dfa84c6593bc84911ef" "/navigation/3a1d34d073b03e3c973be1de1ccb1dd3" "/navigation/429b816b02b533d2b1a70c41cd655ab9" "/navigation/31109e6a747532e48a66f8ac4758a9b4" "/navigation/a639576494f93446b170c09365d7edeb" "/navigation/ed9f665e02b13d01aae8d0432b7bd2a5" "/navigation/76ef7775fb2936d8b885f9a24d8d2844" "/navigation/dfbeb09f9c1d3be19e11768dcb0327c4" "/navigation/27723bc4ac0f35929a5369fd77a0c2dd" "/navigation/06fc171642293162a574b7941bf49cf8" "/navigation/1b27a5a02a6d3e03ad2e722326a01dbb" "/navigation/0cbb132e05f6388f9171c4566a5a8020" "/navigation/ce49a27ea23c3b3a9daad4f35f9ab5fd" "/navigation/1a27c9ec23b63f60b3f138fefa30877d" "/navigation/b17aba3ef4b13df98cf8033c6726d969" "/navigation/4005b576fcc432f09b84c29895afb643" "/navigation/9f06dbf7fd243b81b50e712e5201aaaf" "/navigation/486131dfec67315e8b488097190a5c7b" "/navigation/505e54c2af833031a039f73c57f376d9" "/navigation/81233ed801cd3c2bbcc4a95ec5e881d0" "/navigation/6d0a96fea0dd32a6b2ebacfbff7a0657" "/navigation/8a32f8eaad113371ac99925d921df725" "/navigation/a54fdcc278a53dca99dca1b02c2d4781" "/navigation/c79538911dd53b90b06aeebe9837a39b" "/navigation/b836f4b0a40c3d8ea29b37d49b6172cf" "/navigation/47c1d76038ad327dbcedc8a3e1e0661b" "/navigation/f68ea73402ee3c3bac9745da7cc24103" "/navigation/2144f1e70e8132e6bd20f43718752dd4" "/navigation/6e12a1a3f1883566afaecb0f83f26c10" "/navigation/6ab8cd9c91fd33c28dd95d93b688fcd0" "/navigation/4f8ef89c10653bebaa99647c9a8c078c" "/navigation/c1c70b8d1e2d35efa73a35baa0c81f5a" "/navigation/efe98b7f10f63244ba403e78023659a9" "/navigation/4eb1b6df3c533f29ba8d4d378a9fbf0e" "/navigation/26365228e7a432c4b287ba0054b519a6" "/navigation/f2126840a34a30ccb3975db7f5a89a8a" "/navigation/9dbce4d3864a393daec43294530d83d3" "/navigation/129a932d7801309a9dfb048beefe94e8" "/navigation/1c0dd4a1ecfc3eb48c21dde06c31dca4" "/navigation/d6181012fad53ca9b4bffa3f0edd4774" "/navigation/c8f140de9e483de8b0d3ec24b1b27d75" "/navigation/fbd77d80fed43d56b062d848af661dc5" "/navigation/3e67eee6e6bb3d138bebc36ce95478e3" "/navigation/b1d3a8c97d443b4da83d6afcdefffe36" "/navigation/47083f3a95193f3ab9f0cf70c3d7eb9a" "/navigation/f73789304ec5339e95ff1c09a12f2618" "/navigation/4372a67e926a322392c69aa6ff481972" "/navigation/9882aff1b1933b59a426f7c6605268d3" "/navigation/16d58404d28a33ec805b41e20ccac2b1" "/navigation/fd5de55984953218ab7a753fea92d3a5" "/navigation/cb4ffcaa43c639209c06d94f83b2efe7" "/navigation/1be0f7d609693e4c98505b4efc6979b1" "/navigation/66fd8b40046634c6a306eeb3f916f9b1" "/navigation/2bf4db60938e3f6cba30aae41babbc33" "/navigation/dc64fa61b42330a78d2ef5a01444b3a2" "/navigation/be521908034b3e5c9fa37d035834fb44" "/navigation/c21105c0054432c38470a0491e64e4d2" "/navigation/f8637cb09ac43dc7b718763ec7aef877" "/navigation/c592f5159cc53f38aada5fe3daf4afc8" "/navigation/671bf139cccc35ca836af2eec45643cc" "/navigation/6bf42cbccecc373e8b21cfbac8a2486a" "/navigation/fa39bf73997a319bbb811277a07e2772" "/navigation/8422a184bda936c68acda1f150e9a757" "/navigation/135b50c3b67734159e4c3cfb33ccffa3" "/navigation/c60c12b4c6a03af8bf68ff4349531404" "/navigation/ffa966fd272430419541e610352ad9c6" "/navigation/e47a350c01773622856c6dd936a1dc84" "/navigation/f2483b49d9ca30f281478d12585a6c1c" "/navigation/3057b106dc2f3c939c2f34610e8056e5" "/navigation/25fc1e9ad3863d92a2e7dc818889455c" "/navigation/3d87dd2f01ab3f09a1b86506ae5f74aa" "/navigation/728277c1e5cc32aab06e254326b324bc" "/navigation/175e4df6b6f23d44acebf5aef8314674" "/navigation/c3bb1ca16d4d3e3cb5f2111b5818d78f" "/navigation/393d456f4a613bd8821913c0ea573bde" "/navigation/0bb232a0a70538d3bb5532359eb11d35" "/navigation/47099dfa8e4a3198ad6cf49e42be6fe8" "/navigation/d5d213d59cdf3afb8c9f6a0f1ce421c0" "/navigation/761e4840c817341e8ad40a3d8831fea1" "/navigation/850df1df0d0839569b9414f6990ff34b" "/navigation/cfde4946b7de31b383279cdcfd5dc259" "/navigation/705bf018d3623b00894508ac0f2b17d2" "/navigation/5e3286fd47823e2b928ca52cbec7622e" "/navigation/4aaa61ddefca39678b32a5f951e25416" "/navigation/776b31ee46ce3558bfe6b5728b6684ba" "/navigation/3512a2d5811e37c2bfd8f1155f401385" "/navigation/ad17fc972262366fa7bcc37fb3edec82" "/navigation/95cf49a61c8838d4bdd013b83679342d" "/navigation/ff58fda691353846936ad21ba39c0f49" "/navigation/d4954e6a2df63b9293e462743f49b126" "/navigation/b21ed040596d3a5497f2bf9d4a947d49" "/navigation/63eb82335f503c8ea40e06709b9bf03f" "/navigation/5882dd9891e93222adddd4be25611f08" "/navigation/4f3a64a6a44f38138db3bfcac8333219" "/navigation/cc72b6aca49333a1918a37c0159ed615" "/navigation/4b4a02d133ae3d0e93e7c0ea304946bd" "/navigation/7ac1aac7097a3cd68adb4f07e32ab2ad" "/navigation/bd21cf7b23e63939a5c0d433f9167c65" "/navigation/80a2db7463933324a83161dffe2e8cf2" "/navigation/20bbd9fe646b375fbb3ac174b87a8134" "/navigation/ce703a3762363713a7bd41345dfbf225" "/navigation/c486f659897e341ab89852f00a38c0df" "/navigation/6573ee472d7d3361945450175fa2f317" "/navigation/030e4d9a126a37c2929e7969765dadc6" "/navigation/e60502a93e6c3feeba7b0890ebb71997" "/navigation/c41fe71616253cf99e76024a397e53e2" "/navigation/718cce5ace4835bd8438cf8c8a71b22e" "/navigation/42cae68e75343eafbd9f4dc0d68acd16" "/navigation/466d1d5922cd3d1aa471ad5436576ee3" "/navigation/d4a11e7b234d34f88d0f47f7743fabf2" "/navigation/14415687e7a13e87814199ab2dffc119" "/navigation/1280deba45e03160bafacdb10cc6d2dd" "/navigation/7ea71dee706f3502a3d8eea5c84d9b91" "/navigation/5c2136c083d83720b90378184c4668d6" "/navigation/f1983abe5bf036e998247eb1f8f92597" "/navigation/c3b2ff8967bc3bf7932bfd7daba485cf" "/navigation/8198923f57ea3084a370e96abffe4f8c" "/navigation/07e796058b5d37b9a0ed2a009d59b774" "/navigation/f7532b3f892a3739a8864a5c89267f0f" "/navigation/3ede7c9c478733c796434be423dc438a" "/navigation/cadcc36730f0303c91bf27b47e3720b0" "/navigation/c17b0a437051388c8125043e9b51a0ed" "/navigation/d9893db556be35fe9008d200f0992f05" "/navigation/0ff213cd9c1030178e736950315a5eb8" "/navigation/e586fe57528430b4ac9a97374cbcaa65" "/navigation/e0138e4375e83d3b9c282a8ab031f580" "/navigation/7f8b1a8a813e3c77b892c7ac10475bd3" "/navigation/74253864d3953b14b9e3fe4bc87b692f" "/navigation/1d372710e1ec31a2a0fef5e3d7480017" "/navigation/83a351f1ef6f3c618d3cd50dc5dc4d6d" "/navigation/148b6e9309dd38b5936f0b232fe72d0a" "/navigation/d10e747e34e937b68de6b98db535131a" "/navigation/bd40db757d7631dd8af05aede6b2d07e" "/navigation/94eba224822b3281894ad5431108d60c" "/navigation/f8c9e7c712113abc8f927056a76ce37a" "/navigation/b5809e4e0e2c3167ac04b78d48dd7183" "/navigation/f2f440f9367736ff8d01ace324cd9017" "/navigation/97341cc356b834f18021882de1751fec" "/navigation/aad83743597d33b8a5b6f87709536c92" "/navigation/aecdb0229f6c3a52a3c9256dda84c972" "/navigation/56af68e261b23472bb7687963ebd8567" "/navigation/81ebdeb5f6213a58a8a6cf61b7f9452e" "/navigation/2c9844303e6436f98ecde25bb6bd599f" "/navigation/abb6507bcaa23d21b575e3b0126384c9" "/navigation/b6b73d315a683e8db0cb452519e1f600" "/navigation/88c4eba60f87388d92022aafbda71ec7" "/navigation/0cad8db96a6f37139e45400b7a4fa913" "/navigation/663c09e8e2513ec484a63a13fda39723" "/navigation/77dec9353e3236b0a8ef86a082fac137" "/navigation/665c882761bd34c8bb547d57b623f747" "/navigation/52aa122273bd3260afda533e15635b16" "/navigation/dd11829d103538a780652033e5475501" "/navigation/8a10cc82e5963a0da99755dfa0ad97e6" "/navigation/e864b27f6f5f322685595804989678bb" "/navigation/1d9b9401241a33c18c20593c5022118a" "/navigation/8255690942f8340ba8eb050a6c569e59" "/navigation/2935f81dd2dd3c2cb9772147c9efc1e0" "/navigation/c9d20bc8b6553a5ab2f66cb965df1157" "/navigation/e2212c2302d734eab7c5cf25e7818bd4" "/navigation/c60b96e54f5d3894bc0f760479c2f6a4" "/navigation/1f431bde1a213bd0810414800a045ba7" "/navigation/49899019c6773a31a29e9c570047f5e1" "/navigation/259e40b784203a42b03da7978304e1dc" "/navigation/416ff8ad916835a9a4d33ff140bbc451" "/navigation/bc0c3aa4ad2839f7889af97edc3bec05" "/navigation/b1c228ef21653092a1a0709321ee37bd" "/navigation/a57e5486737939a2989e3cb8e577b972" "/navigation/873445446c6931998386625203c7ab86" "/navigation/43d5682be20f313a95638081ccfe1f55" "/navigation/80fe5994464b3fc699dcd61675833629" "/navigation/a634de8c7d6c32328ea88217bd734644" "/navigation/a81e9737be5d3a3fba219d611f76f9da" "/navigation/5e7cccdb4eb4360f9ed16a2b73809b44" "/navigation/d61333f5d1e634219d96cff245878cbb" "/navigation/690eed01488f380089af80d7d0a05ca1" "/navigation/256ed76fb69537ce84dde7a8d376b51c" "/navigation/4d12d87a965634b8af913182b57656d5" "/navigation/ffa8d1ebf7ad3e41a1703e60b35ab02b" "/navigation/3a2dd5c6d8d23b85a05406f1d1310fcc" "/navigation/dbde9c03a83b34b98cc8accef652baf3" "/navigation/e801cf56e6ae3483a27f0256fa087b9b" "/navigation/c5bc63034bc332f3b13833f9498548ba" "/navigation/38299800a86b3e27b829ad3e592235a2" "/navigation/1c572db2001a37d1a06678af17a7942e" "/navigation/03998c3b40e83fe3acd4c4e13032f0ee" "/account/recover" b"/»_ââšMpªXTÎ|ãâ\v" b""" VDLgæœFï¼\x12*\n 2¼»° """ ] |
||||||||||||||||||||||||
|
85.18 ms (18.87%) |
1 |
# header::navigation::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.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|b354c5c506a04847b4fe9fee984deaea|%" 1 5 ] |
||||||||||||||||||||||||
|
25.19 ms (5.58%) |
1 |
# theme-service::load-config::read SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.description`, COALESCE(`theme.translation.description`,`theme.translation.description`) as `theme.description`, `theme.translation.labels`, COALESCE(`theme.translation.labels`,`theme.translation.labels`) as `theme.labels`, `theme.translation.helpTexts`, COALESCE(`theme.translation.helpTexts`,`theme.translation.helpTexts`) as `theme.helpTexts`, `theme.translation.customFields`, COALESCE(`theme.translation.customFields`,`theme.translation.customFields`) as `theme.customFields`, `theme.translation.createdAt`, `theme.translation.updatedAt`, `theme.translation.themeId`, `theme.translation.languageId` FROM `theme` LEFT JOIN (SELECT `theme.translation`.theme_id, `theme.translation`.description as `theme.translation.description`, `theme.translation`.labels as `theme.translation.labels`, `theme.translation`.help_texts as `theme.translation.helpTexts`, `theme.translation`.custom_fields as `theme.translation.customFields`, `theme.translation`.created_at as `theme.translation.createdAt`, `theme.translation`.updated_at as `theme.translation.updatedAt`, `theme.translation`.theme_id as `theme.translation.themeId`, `theme.translation`.language_id as `theme.translation.languageId` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.language_id = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||||
|
11.91 ms (2.64%) |
1 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b"Ca~d\x01╠Lì▓ÄIA┌)\x03┼"
]
|
||||||||||||||||||||||||
|
7.38 ms (1.64%) |
1 |
SELECT `country_state`.`id` as `country_state.id`, `country_state`.`country_id` as `country_state.countryId`, `country_state`.`short_code` as `country_state.shortCode`, `country_state`.`position` as `country_state.position`, `country_state`.`active` as `country_state.active`, `country_state`.`created_at` as `country_state.createdAt`, `country_state`.`updated_at` as `country_state.updatedAt`, `country_state.translation.name`, COALESCE(`country_state.translation.name`,`country_state.translation.name`) as `country_state.name`, `country_state.translation.customFields`, COALESCE(`country_state.translation.customFields`,`country_state.translation.customFields`) as `country_state.customFields`, `country_state.translation.createdAt`, `country_state.translation.updatedAt`, `country_state.translation.countryStateId`, `country_state.translation.languageId` FROM `country_state` LEFT JOIN `country` `country_state.country` ON `country_state`.`country_id` = `country_state.country`.`id` LEFT JOIN (SELECT `country_state.translation`.country_state_id, `country_state.translation`.name as `country_state.translation.name`, `country_state.translation`.custom_fields as `country_state.translation.customFields`, `country_state.translation`.created_at as `country_state.translation.createdAt`, `country_state.translation`.updated_at as `country_state.translation.updatedAt`, `country_state.translation`.country_state_id as `country_state.translation.countryStateId`, `country_state.translation`.language_id as `country_state.translation.languageId` FROM `country_state_translation` `country_state.translation` WHERE `country_state.translation`.language_id = ?) `country_state.country_state_translation` ON `country_state.country_state_translation`.`country_state_id` = `country_state`.`id` LEFT JOIN `sales_channel_country` `country_state.country.salesChannels.mapping` ON `country_state.country`.`id` = `country_state.country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country_state.country.salesChannels` ON `country_state.country.salesChannels.mapping`.`sales_channel_id` = `country_state.country.salesChannels`.`id` WHERE (`country_state.country.salesChannels`.`id` = ? AND `country_state`.`country_id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b""" VDLgæœFï¼\x12*\n 2¼»° """ b"Z:#~alF]×═─■&\x1Eì▒" ] |
||||||||||||||||||||||||
|
5.89 ms (1.30%) |
1 |
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|b354c5c506a04847b4fe9fee984deaea|%" 5 true true ] |
||||||||||||||||||||||||
|
5.37 ms (1.19%) |
1 |
# header::languages::read SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.productSearchConfig`.`id` as `language.productSearchConfig.id`, `language.productSearchConfig`.`language_id` as `language.productSearchConfig.languageId`, `language.productSearchConfig`.`and_logic` as `language.productSearchConfig.andLogic`, `language.productSearchConfig`.`min_search_length` as `language.productSearchConfig.minSearchLength`, `language.productSearchConfig`.`excluded_terms` as `language.productSearchConfig.excludedTerms`, `language.productSearchConfig`.`created_at` as `language.productSearchConfig.createdAt`, `language.productSearchConfig`.`updated_at` as `language.productSearchConfig.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.name`,`language.translationCode.translation.name`) as `language.translationCode.name`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.territory`,`language.translationCode.translation.territory`) as `language.translationCode.territory`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.customFields`,`language.translationCode.translation.customFields`) as `language.translationCode.customFields`, `language.translationCode.translation.createdAt`, `language.translationCode.translation.updatedAt`, `language.translationCode.translation.localeId`, `language.translationCode.translation.languageId` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language`.`id` = `language.productSearchConfig`.`language_id` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.locale_id, `language.translationCode.translation`.name as `language.translationCode.translation.name`, `language.translationCode.translation`.territory as `language.translationCode.translation.territory`, `language.translationCode.translation`.custom_fields as `language.translationCode.translation.customFields`, `language.translationCode.translation`.created_at as `language.translationCode.translation.createdAt`, `language.translationCode.translation`.updated_at as `language.translationCode.translation.updatedAt`, `language.translationCode.translation`.locale_id as `language.translationCode.translation.localeId`, `language.translationCode.translation`.language_id as `language.translationCode.translation.languageId` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.language_id = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b";6\x1DÐcrKõéÂÌ\x06"ÅV5" ] |
||||||||||||||||||||||||
|
3.85 ms (0.85%) |
1 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters:
[ b"³TÅÅ\x06 HG´þŸî˜Mêê" b"³TÅÅ\x06 HG´þŸî˜Mêê" b"³TÅÅ\x06 HG´þŸî˜Mêê" ] |
||||||||||||||||||||||||
|
3.58 ms (0.79%) |
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"
]
|
||||||||||||||||||||||||
|
1.88 ms (0.42%) |
1 |
# theme-service::resolve-media::read 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"=î/¬\HC╣ØÚ¹ãHêüH" ] |
||||||||||||||||||||||||
|
1.16 ms (0.26%) |
1 |
# header::navigation::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.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"³TÅÅ\x06 HG´þŸî˜Mêê" ] |
||||||||||||||||||||||||
|
1.14 ms (0.25%) |
1 |
# header::languages::search-ids SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id` LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id` WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters:
[
b"""
VDLgæœFï¼\x12*\n
2¼»°
"""
b"""
VDLgæœFï¼\x12*\n
2¼»°
"""
]
|
||||||||||||||||||||||||
|
0.81 ms (0.18%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[
b"""
VDLgæœFï¼\x12*\n
2¼»°
"""
]
|
||||||||||||||||||||||||
|
0.70 ms (0.16%) |
1 |
# generic-page::shipping-methods::search-ids SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id` WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true b""" VDLgæœFï¼\x12*\n 2¼»° """ ] |
||||||||||||||||||||||||
|
0.65 ms (0.14%) |
1 |
# generic-page::payment-methods::search-ids SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id` LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id` WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters:
[ true b""" VDLgæœFï¼\x12*\n 2¼»° """ ] |
||||||||||||||||||||||||
|
0.64 ms (0.14%) |
1 |
# generic-page::payment-methods::read SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.media_id, `payment_method.media.translation`.title as `payment_method.media.translation.title`, `payment_method.media.translation`.alt as `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields as `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at as `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at as `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id as `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id as `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.language_id = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x06@>Û©\x10IB£‰ÄùŠ\x00bÅ" ] |
||||||||||||||||||||||||
|
0.60 ms (0.13%) |
1 |
# header::currencies::search-ids SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id` LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id` WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters:
[
b"""
VDLgæœFï¼\x12*\n
2¼»°
"""
]
|
||||||||||||||||||||||||
|
0.56 ms (0.12%) |
1 |
# generic-page::shipping-methods::read SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.media_id, `shipping_method.media.translation`.title as `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields as `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at as `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at as `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id as `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id as `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.language_id = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"3ðåh╗ÎD¨üVD¥\x18Mä╦" ] |
||||||||||||||||||||||||
|
0.42 ms (0.09%) |
5 |
# 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 ] |
||||||||||||||||||||||||
|
0.34 ms (0.08%) |
1 |
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"Z:#~alF]×═─■&\x1Eì▒" ] |
||||||||||||||||||||||||
|
0.33 ms (0.07%) |
1 |
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters:
[
"payload"
]
|
||||||||||||||||||||||||
|
0.31 ms (0.07%) |
1 |
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id
Parameters:
[] |
||||||||||||||||||||||||
|
0.30 ms (0.07%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||
|
0.29 ms (0.07%) |
1 |
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id` WHERE (`country`.`active` = ? AND `country`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters:
[ true true b""" VDLgæœFï¼\x12*\n 2¼»° """ ] |
||||||||||||||||||||||||
|
0.29 ms (0.06%) |
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:
[] |
||||||||||||||||||||||||
|
0.28 ms (0.06%) |
1 |
# header::currencies::read SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||||||
|
0.26 ms (0.06%) |
1 |
# cart-rule-loader::load-rules::read 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"\x11U├©╚(@RÑu┼\\x13¾╦É" b"`†u\x07YBJ9¸m›1±Fá\x15" b"€jU”FüD¬…éÜœƒ8\x07Ñ" b"„¢9͵FDm™o\eÿc'‡\x06" b"Îi°ÄnóFÅ„³L 5g\x14¨" b"GööI=®F!¤sàv{¹^ö" b"\x00\r$óɹó3YóQŒ°o Ã" b"\x00'\x08cÄ$v▄ldgØ\[#V" b"\x00KkpÅ5”¡&χz=3Ú\x00" b""" \x01½\n #Eü\x0FU\x07┴ô~\x1E°AÖ """ b"\x02*ÛëlÝÉ·Pþ̹³Ï9›" b"\x02Ñ0¡Õád±Ô\x1A&ar\x0F¡Ä" b"\x03;Gžië\x05ÍÎÕwðG1÷¸" b"\x03┘§'‗\x7F0|├\x17 ´\tÓ╩Å" b"\x04§±ÿ›Ÿ€Èâ\x1Ayárº¢0" b"\x04¤-Ë\x13ü┘zÐ-å3\x14Öà¨" b"\x05/`q\x12飪Ÿß\x1Eµâ}r" b"\x06c¾ûæÓñcôdËà\x11¡ß›" b"\x06‰Œ~š£\x00G:²\x12½7RG\e" b"\x07\t\x17\x1E,—‘†’\x01h\x18Ö\x0E’T" b"\x07ŸNPÞïU©\r–\x00±žüÒm" b""" \x08.ªv/±ÏÐ/%\n \x1E°‰íq """ b"\x08>ΈhË*{>éªbüâù\x07" b"\x08UaÆQ.n5¾»ÇûlhÂÙ" b"\x08x╗©¤}~%╣º!\rì\x15L■" b"\x08žÖä.ôU½ø˜¬‡\x01\x08:"" b"\t6'„±D\x13,€\töœ\r×#N" b""" \n €D¾õ0ۼΨîg\x1D€ü‰ """ b""" \n ¤Ñ§BÍ\‗\ú▓:¨ìÁø """ b"\f\x0EÈ}È\x12?)ñ\rÁ\tÃeÒ<" b"\f!•\x15œ‚ãÓ_U]*Ý\x17\x12" b"\r‰Ïx7"{\x7FG0\x08¸žƒ\x08{" b"\r¨k«@œ\x06S9!Ž]+xø2" b"\r½D'nÕ—¯ìËf2ÐÊûê" b"\rÕ‘õÔ*»\x00˜&\e/pL³'" b"\x0EØ\ª¤S{│¦z_\x1AH\tñW" b"\x0FÅ’ÝE˜ë\x15ü÷ôoÿ¬Ðg" b"\x10ho*8ž©ÜÃÊk‡á\x12\x01Ï" b"\x10ÌÎqwg-┐ä±Öüß┼i£" b"\x11qmg¼¥\tzäWäüïÜÖ_" b"\x12\x02─$$N|p좡‗¤QÍ\x02" b"\x13$dÅ1\eôʲ¾\x10ê{%Ÿâ" b"\x13o&äÏ@§6‘‹ÞS梸" b"\x13꣮襢»‚&\x12ô'f±¡" b"\x14\x12ì´–»\x11\x17ZÙû&÷DÙ~" b"\x15\x7FÐ.p;\x02*¤Ÿ'Ìæé]ú" b"\x15·®Êh<\x0604+\x1E÷±øÃj" b"\x18ƒŒKÇ\x17\t—«Å\x1FÚ\x05@¶ç" b"\x18˜„\x0FOû2K÷T~ú €»w" b"\x19*Ȳ¦þ\eZYØfMT¡Ù%" b"\x1A\x05îì&¼KJ`Â}»■è▒`" b"\x1AŽB\x1Dlœcú3[@ªB\x0F¤s" b"\x1A§´²È¬xÃӸÅ\x16nDn" b""" \ed╣╗@■.mïV\n a(ظ¿ """ b"\e«¾²{ú©¹\x04ói2ÿ8Êñ" b"\x1Dú¦)ä>^¶.J=>ïLÙƒ" b"\x1E»N\x15FNq¿&¯ð\x13XÄ;^" b" h■┬N)þvÉ┤!?.r<ë" b"#"ƒ\x17J\x05¬ÃJFœ\x04Þ7Õ'" b"#¨µæÁ#2´¤Ñܨì¾s;" b"$MÀI’\x04l&¥ø¦Ë\x03˜&e" b"%o5»)^§\rdCö\x075Ž\x17\x1F" b"&8,ì_\x08°'tË[\x01ÜL~=" b"&€&º,]u—Ô~-¸SžJ\x16" b"&κܧHè¨mÙd¼Å\x14ÍÒ" b"& ù\eÖ|9ÉK×P°ÛmßÎ" b""" '\n KáÌ5nSˆ•mATÅ-• """ b"(§:i:5┴╗ìSÅ┐\x17:Å1" b"(ùS\x01¸\x1CÈÌx÷u“.,ÄŽ" b"(û5¯Ç9soBë•ÜÑm´\x01" b")ò\x06{>#“MvGÔ³¹6×\x1C" b""" *B\x1EB÷\x1Fı ò@\n í\x0F\x1D║Å """ b"+\x02-ýcò¼Úÿšo\x17Lå` " b"-N>Ë/\e<°Kq\x16…ùçÝæ" b"-▒█îôJ\x14üz▓¡BØR2¢" b"-┬üJµ"§u>Úf\x15Bø?u" b".Ñ╗¨ñ,┴\x12\x00░\e\t║ªÅ\t" b".ºô²§\x1C¾H,í‘‘\x1E\x19;’" b"/¬\x1F¿ù‚çªÖ\x1A\x1EŽ€K<" b"0\x0FiM\x03åJ@³¹±X\x04˜õ\x11" b"1;qj’*' ô\x00\x03¹Û~f:" b"1Ò\x10ülC¿ší:\\x16„HÎ\x1F" b"2\x11ÌÚÿ•\rs_áñ\x08$Ú”:" b"2³Å\x17¶\x7F\eˆ6\e,\eâ\x19\fþ" b"2ºŠÄ0Ü}bàþ˜Aq\x128" b"2Ò\x18,Œ\x1C ±9’HGáåˆ\x17" b"3\x10W„q±•žLeAaTÿ(" b"3þ¤¥Å`6¤ü-\x13ðƒ0s¿" b"4‹š(Ú\tD1ž\eÁ¶§GÝ}" b"6Nm\x1EÕ‡'æ1¢¤\x14\rÙ®x" b"8[Í!ðᙺ’1u矃,†" b"97Aä\x7Fžh6û•Oômm¾Ö" b":¤¿ø”™ŽÖš\x08\x0E+Ô\x16\x02û" b"<=\x05£‚+X\x1C®†wxÕ—}" b"=Dɽ\v©;ØTʧ]úÔE¹" b"=Lä2*\x02\x1E){}¿ü²=ÿ2" b">XżÞY#\x19)ÙÀMø4\x10\x1D" b">uIJûDwÙ‘ùù¬a©ò~" b"?.k¹lèwR1L”\fôÍ\x05z" b"?‡<ôø9pB¶é%T_‡.\x13" b"?╝qD\x1C¿\x06\x18bK┐(╠\x14üö" b"A »ƒp\x0EaÝ\x175Ó¼BÚÅó" b"AE¼h\eÇÒc"Òýçeì╝~" b"A¥_ïœt\x00Áô‡\x12\x14s/ƒ\x16" b""" B\x14|\n ØÐö0bÙ'Tú[B' """ b"BA\x03í·nª—»’µòÿG\x02ˆ" b"BX ™kõÆoPºðŽ‘l\x19¬" b"EýÅ×"▀È3+ï┘æ╔-j " b"H<[ƒ1\x1CË îƒ\x1Eà─éì´" b"HX4‹ªl2¨FüU8Œ\x1Fæ>" b"H°¤Ése├\8R5PJ\x11EL" b"I.*Û¤ì鱉¨ti\x03Ì{¡" b"I˧\x04k\rZ»!Ü^C%²__" b"Jú\x02/ñîÓã@‚jƒÖ´ýá" b"KrÅ"â\x1A\x11J«Òu}þþ3M" b"KÂY╣Xü'S¾Èznf_Ùf" b"KÂd\x00vÐûÿlœ\x049å9Áø" b"L£K/ØO%_UÀm]Ó(qk" b"M‡\fa°°^—ó0+«Ž»ñ:" b""" OÀP¿Ï\n J¿”KµxÄB5n """ b"QGê\x02\x1Fø\x1FS^\x15%ŒžÑz9" b""" R¸\x02Z\x0Eˆ\n yºù=ã¼¥q¼ """ b"Ràª9~&ÿ¯\x00Ñ™‚°ö“ " b"S\x02A┴=AAs$8ɪ\x08§ó2" b"S\x11š¸9«\x11.ã_XÉÎn)s" b"T\x0EzåõÐ╚ð°5ÉhdÞ²‗" b"TžR€@[ež¡¢½¾E\f¸V" b"VO$\r6\x06±RQàöÓz\x13°Ø" b"Vњ˗õ›CƺëMŸ\vÉJ" b""" W¬ëË_‗\rÛ┤\n D\x12Å╚ö| """ b"W╗õEÞkÝ]▓Y■ôÅ║Z4" b"X.Çä\x1F€Ãjy›RµZ©öü" b"X·ó┌LÅliÜ×Ò}\x02\x03&?" b"[dD9?àž½šöR\x02MÚ\x04t" b"[Šn\x03ƒ»hI¿sÔzn‹¯u" b"\ñˆv\x02\x01\x04–-ø¡C#Æ3¥" b"^\x00\x0F½pì╔æ=Ïüïk\x19I3" b"^_2îµo\x141%B²T@ì¸[" b"^úY÷¾N~„\f\x19›\x06\x14oå›" b"_I\x10¡ÊnμkŸH(}í>J" b"_Õm€Š¨ ©ž³F_&Ç\x13Õ" b"_ÖDÂÑ7ä en\x13¡¸aœý" b"aÛü\x1F9±í«n\x16æ ˇ6‰" b"b\x032ë?œ\x10-\x08vI!(\x03ña" b"b{ã,ñf¦Å\x12ÈO▒Ü\x1Aè]" b"c\eþ„\tbµî\x19@¬$N»¡ÿ" b"cØ¡u╠Î)4Òï\x01▓/¡╔õ" b"cß¹╩®U┬i\x1Dü>áÙ¿B¥" b"dÿ÷²ÊÓÉÙ?S\x08›nÅ‚\x00" b"eÊ9r5{ØË\x04µ╝0Ù╦║I" b"eÙµ¹Üä˜\x081-\S‚ò›" b"f$\vÍýé\x07{Ãåຄ\x08r\x1E" b"f³\x03■ƒÝAìp<]N*¤6O" b"gó1ZOÕa9ãLšÿ¾æE\x1A" b"hL\x1EkKªå¿}ö\x14â庀¨" b"h^ú½üèxª9¢q\x10Õ\x08ø{" b"h‘ç‘ŒEû\x10PÅ\x1A‡=Øs°" b"h¼\x15┐OH\x0EQ\¬Ø \x06┌³\x10" b"k43Ð▓Y8aÏ█ÔM\vÒ\x1DØ" b"l\x00þ¥ÊàÊX\x05‰ÝqŠI\x1Có" b"l@ü@ÇHxòBù\x03)Zñåž" b"l›\x16‘/›GMèÍ¢ë-\x02ss" b"lÞÑûi™\x00—ZÏ\x19\x1EK‰æ[" b"nÒ\x03awÊÁ\x13j\x0EPj¤§—G" b"oN╗\x06õõ¶s■\x7FBT+ì=l" b"p╚Ñ\x170@Ù┘\x18¼C \x1CøÉL" b"q‚´\x1D@ôŽð\x08Í/NãXPu" b"qÐ*\x03u¯èÒóÈ5\x19®\x1D·\x1E" b"q×Iç\x02QÞÏž4ÖŒ\vä*‡" b"ræÕïêÿfàÚ[ìòd|ï\x01" b"s—«RO”wLôÑnÉÝÄb«" b"u\f8½¤ŸÔ\x05©\x11ˆ7A\x02©4" b"uãVÏ\tQ׃ž#òÌJä5½" b"v\x17$Î'\x03¾\x13Mï1¼Jö?a" b"w!©\x11\fJ\x18ã£Ç)ý75;ã" b""" wß\n HçNå¥;°\f›n\\x05u """ b"xút¶\x00\tG\x1C¿žyõƒ‚„i" b"zDa¥KéÔVö€7Œl€*¯" b"zí¦úTž×"\x02öþ`ž³³I" b"züã\x07–Ñšo†\vsû¸_5\x07" b"{k'I\f\x1A\x16\tËÒS‡È\x06Ä" b"|@JªbÇšíÄ\x02iÀ€u\x08¢" b""" }2\x1E#J‚!_eK›ÂE\n àÅ """ b"}p¢¥\x1AÊ\x01ÒÉÐeèµ7ýð" b"~-\x00¾ïü}Ïò\x01t\x16Ë\x070ñ" b"\x7F-½Ë¯*Õ\x1F└;ÉWà╔CÙ" b"\x7Fó¾«ÜêM\eÔÔ)‘šIpí" b""" üôÌC»}4\n \f«ä Å■Þ; """ b"üßV\x1E\x14Ï\x07Ö<\x1Ef\x1E©\x1FR■" b"‚-¸¶!Ö¶Šd\x1D\tW`˜KM" b"‚êÎê¾H¥óÔ¶Š§â"µF" b"ƒ6öÂ.1ÚRÂÎqÅ@" b"ƒEO)¸\r“\x13ñMÄ(\x15Õ9Q" b"âHíÎLıD╬ì\ró┐Y\x1Agõ" b"„\x1CÉèæ˜/ýºÒ\x16‘ÑüåŒ" b"„H«Y´³"kü€žl\x14ÔŠh" b"„u\x14~‡Í<‰Jô\x1F\x1Eê¬ÄÌ" b"„À>Åo\ecM\x14С=mÝê_" b"àÅ┴¡┐gxߨf·ìnó]#" b"…ǹ\x13–´û¬hÁaË£„ŒÃ" b"†“ì|î}ÿ4\x045AM§*ž¼" b"‡7\x1DÄ\x1F§I\x16c\x00Æðã\x19Yp" b"çU\x00£ÌO\x05àðhûmËÞ«ü" b"êK\x1A┬N&ú3\x15╗\x13ýW:ƒÅ" b"ˆT«àc9\x138³‡\x0ECŽR§\x07" b"ë!■BüÈæ¢░\t\x1E╦ù│v\" b"‰.Õ\x04`.Ûʦ&ê:\x19slm" b"è\x18¬+Éq\e±ªI┴Lª\x1Fç~" b"Š¥£€Á€GŽÎ9;\x18ÿBæ\x06" b"Šþ¥ÇɵñŽ:pRo\x04Ç€Z" b"‹R\x1Eo½ÝoÆy\fT,|>C_" b"‹áE<\eDA\x1C €¨\x18“š‚\x12" b"Œ‡I+.²£ÌüÞôë™Õ¤?" b"Œ§%ô\x1D/MM?ÈFóÆŽ´Í" b"ŒÎé„_§ÔÉ\x02J#\v\x0EE\x17ˆ" b"ìz\x1F K´·ÝDÏ ─a÷EP" b"ÄsëëÄ5ì▄▄a█=xÀ║Í" b"ŃX}ÞòSoGCH▒\x11¯┼Ú" b""" ‘\x04Ÿ#L;`*ò\n ‡öšv à """ b"‘:\vZÅ/¯67ý×ø\f“É•" b"‘‡h^³žQ¦ÏŒ\x0F}Ù|¦0" b""" æÒ\x1A½\n (l̃\x15LþöïEü """ b"’³Õ£\x14|\x01µÓç.½‡#Æ\x13" b"’ÿ\x06S¬¼¸\x16\x03é.¦´~\r_" b"ô\x1Cb`¬×Ö\x1E[ì:■ëk▓6" b"òé>²3rQ.´\x19ÅLÇx\e\x12" b"—3Ë%Å…9íˆ\x04\eÀÝaE•" b"ùáRËü?\x00▄®pÑ@r│B¯" b"—ílùÐÿç\x7Fu[&&£“\x06”" b"ÿ▄ì\x14D+\x16¥ïqk¬\x1FX!└" b"ÖwÐ5¤!,.g>JçÅ7┤»" b"øÉ▀\x05Â{×]r@\x12\x1Dz\x10ó\x15" b""" øãè\n Ó╩É\x1Df▀ÉcP\n dr """ b"œx"Õ\x005*\x03]ŸôL\x0EÖ\x16~" b"Ø\x0EüU┤qÈ\x1AxhA│░ée\x03" b"ØWY^2ª║ÈdS\vÒx▓óæ" b"×V\e?╬\x04\x07ù\x0E┌GØ<9F]" b"Ÿ±\eºÕ3³Ñ|6údÓ‘už" b"Ÿëï%kÖ¹!€‡vj[°Ã@" b""" ƒ \n É+Ê<H╦Ç╚xeö┌\x13 """ b" G\x08ßÓVP\x05\x06Øs\x103“Ä" b"¡u¢¡Cµ™üøH|Dz+§*" b"¢\x1DQêr±\x07Hµ*\x1A\x7F¡Ûãi" b"ú%╚mÐ*FSóü5ƒù¸d~" b"úë\x17>9äÕjCïªiÔ(=ü" b"¤ƒ4çáHQ4Ë\x0EV\x18âú`¹" b"ñØ\f\x1CFòMLá\x08Keå<Ù9" b"§ÿÑp¹pø¿íþ\x1FN¥èËK" b"©Ø;š˜\x7F\x11¸7;)¶\eIj" b"½E▓%▓Å\x13\x0E\x11\x11¶§#òCþ" b"«‘H›{D+6ŠÕ\x12)™ŸWõ" b"¬Æ\x19|FœYøÞ—óÊz)à¹" b"¬Ò *òèzV×\x08\v\x17Êú}\x0F" b"\x11v×ÿ\x1F¸\x03TÀÍí\x16¶:˜" b"®7¥U\x7F@ýFá1O¼R\x15Òà" b"®›î?\x1D'î\x1Ad.\x05e`‚ËY" b"¯nØÞ/Ù$wøÂ\x1FÜÄê¾B" b"°\e_º\x01\x04PíDUj[\f‡\x1Fõ" b"°4õm,²Ý}xìƒQºˆ\x0F6" b"░@H\x06\x12[\v▄Ûæ╔ÅE║ê\x0E" b"▒s\x11É{\x06╚åxo4Ê█ óR" b""" ±Æs;ôIÇ—X\n fžy½‘` """ b"´È\x11ª´g¯ŒdìGH\x19‡\x1F³" b"µô‘„·_ÔïFR†ÊFœ\x08²" b"¶T¬å^´±%j\x01‹Xå¦_Y" b""" À\n ÅÝc├Ʋx?ìãè\x7FÖ┬ """ b"·³ªJÇ4ßšx¤“œ˜îlÙ" b"¸G%ó˜q"C\ù\fžOÏ¢-" b""" ¸”Ä\x1FÕ¯\n Á\x05GÊ\x18J܃— """ b"¹*©€…œƒÙ\x19øÊTz¶vz" b"¹Ä\x14«”íäWð;£hsÅ|î" b"»m¡§]ŽÒ€(ï%_¿\@‡" b"»Å.(º\x7F-ì®!]dvîíä" b"╝\x08;îCõÖ╬É\x7FßØ<\x01î)" b"╝Ç{[\x7FfÜ\x0EªF¤\x1CdØÚ" b"¼—Ô·¾ÛÙsi‚‰\v茛\x1A" b"¢┤\x19ú\fÌÉÚËí┌«\x1Afг" b""" ½íB²‡\n Û–h’ë_.Ú‰Á """ b"ÀÚ\x15ÁX\x17&yÙœËä±%7Ž" b""" ÀôÔ\eÓRT\n \x1C²ö)Ú@›Š """ b"Á=Ž®»Ž~XÇk3W9B¸Â" b"Âu^k\tª…M'Ü£«~\f•Y" b"¶ÿíIÇÔ3\ed\x1Co39§s" b"ÃÞ\x14ðÀ\f2ô‚\x1FðlÕ¢*\x7F" b"┼E┬úý░\vY░╩øvÓ \x14ì" b"Å„\x07!7Ø› í1^\x1E\vQoé" b"ã\x08,9Ð╠«¯\x0F╠ì├FQû┴" b"Æd§0!ã\x06º¢ÖGaÌwåÊ" b"Ç\x03\x1Fo³—÷§ò\t\x05mY+™\n" b"Ç#!l6;<_%¨,0?\x1F.…" b"ǽa,Ë‚CâZ…t<’\x04\ê" b"È\x17ÄÎF˜Cî<\x1E/ʨŸ¦ÿ" b"È•¦ý\vW›+]¶É\x18µ±>ã" b"Éj…Õ9ãÅZñÐá#Aż" b"ÉÖ…UC$SÖmîÌøUÞ+ö" b"ËIbY À›\x15\x1EdnL\x13øP" b"ËcË)g<Áx‰»®…ó\x00ü" b"Ìo¦>Ù\x0E½\vR´"@\x18w\x7FÇ" b"Ì´Þ?g9M\x08öMRˆÉ²±÷" b"ÍR\x05\x00\x151P\x7FºËÂ@\x0Es¶Ž" b"Íš\x1D@ÞÇð<>\x0E0>o™\f^" b""" ÍÔX%‰t¿1J^—\v\n ¸\x08Ú """ b""" ÎVCŠ2¾M%µ´\n 4Œ%ol """ b"Îim_©ïÉC¸~f\x12È-\x02X" b"ΗŠÛexv4£à\x19§;À×\x1E" b"Ð\x06\x1Dh2 /ñ\x00\x0E–ãµ,)E" b"Ð"O‹‚’\x0Fj4°öÊÈ\x15ü#" b""" ÑI#t\x04MJ¶\n xZy[ÿ6L """ b"Ð|ýñ³b¦\x07ì8\x1C┐Ï┐Âp" b"ÑŒhlÿ¹<ÅQÃ\x15Ú-÷" b"Ô\x02ðüÔˆw°ñ‘ÕðŽS\x02¥" b"ÔÓ´1s\x7F#y¸\x11´+U‡EÍ" b"×\x185‘\e\x0E\e\x10Â\x1DÿÑ<0†\x18" b"׫v8Õ‚âЮ\x1F\x17N¦Ü!\t" b"×È9Ì\x14ço»£0\x03¼DH\x15\x11" b"ØjtÈíÞ¦\x7F\x19±’'Qµø;" b"صL15®\x03%·ÃF€³\x00„\x05" b"ØÚ@_gÒÁÓŒìn×GO{\x02" b"Ù7O}ÒÎq‚ %\x13¤KK:\x17" b"Ù´*ŠºÕ5ç\x7Fþòlz\x18€\f" b"ÚÄ.Æ\x00\x1E<½õ]üÁÐ4p¿" b"Û\vÏ´§Àm~c\x02”?÷â\x1D." b"█\x0Fa\eFËÉo:!\x00!8$íÙ" b"ÛDL\x15Ó§^Hø%\x7F\x00S}g‰" b"ÛH\x00½Ê'‘\x195º«õ“̾ä" b"Û_\x00µù§\nS*§œ\x1Aïnô3" b"▄ÅÅ\x18OJ/T\x1D\x14\x1E╠æª\t3" b"Ü÷µEµ<dú3#\x0Fv†\x05ñ1" b"ÝF¸N\x01æF÷…¸Db?8\x116" b"ÝL†ÝuNЪœ4ŽjR·ôå" b"Ýߘ\föò‰\t«˜U]/v„\x0E" b"ÝàŽ\x08 3g"¯™\x02\x19“·g" b"Ýõ~ñÄC—©j÷™Þ\x1Fß÷v" b""" Ì\x16ì¤)\x1C(æ`r\x1F\n ýP«á """ b"ß¹™7\x14ùÝ}<ûÉG\x11“q\x03" b"à†ÈÑìËR§/M\x01‘‰#w!" b"à‘]”\x0ESYÏÒÁ#5ú[óg" b"áݱ\x01ó\x01¯0e[-™Q\x7Fpÿ" b"â\x1CuIœŸ\x00èid8À\x07M×”" b"â\x7F·ð°\vŸ ñWrrÉo\x10Ù" b"â±p%ÝÆu)}*1F>\rîF" b"âÊ3pEØ\x06e¾´l1ÏE^ä" b"Ò\x1AlØeý3\x0E\x18┤J■Í\x0F■\v" b"Ò▓òNûÛü▒¡¸Ù%á¹Ä/" b"äP8ÀC®†í\x13Â\x01\x00”_\nù" b"ç\x08§LÜ–õå§Á0.\x18ÿÚ†" b"çzhñSLÿ`ö»ä¤\x13âa\f" b"è³íŽXr³˜\rýïa=gg¢" b"èѳí7ûâ\x03F»Û¨Œ$y–" b"ÛDºòo¾t╝!ÿèüç ├╝" b"Ûd`\x0E gÉ▒╣â²#╦\x15ãº" b"ê–˜ F\x1Am뼜¦%¸áÒ¨" b"Û¬▀╬öê©6Õ¯Rúã©Ø‗" b"ì8Ó\x08ï÷sI&\x11Õ~°ð\x17â" b"ìh>HG$5wHŒà±òMÕ”" b"ýu°MÖ╣ó MI\x04ü\x04¸¯2" b"ìØY<SQ\x07à Àè{Gæã’" b"ìþP59泂¥Yüvv\x1CC8" b"í@ÙÍX\x00äÞ¾ë°f`Ö6æ" b"íLMß\x08ÖëDL&Åj“F$©" b"Ý║\x1Eü)+\x19▓B\x16ªÇ■│╚;" b"Ý´¾ÍWÍ\t©ú·\x18\x02Dì╦╦" b""" ¯ÆRóØÇJ[{]╗½\n \Ѧ """ b"îš±"¥'Q\x0F\vŒ©¾\x1FSá" b"ïY\x18_òçµÙÕô·\x05tO\x07„" b"ïø¬“´©i齋úà¿”Ã" b"ð—³ ž£Á“@‰m™c‘¸P" b"ñ\r\t߀R<„t\x1Em\x02ÎÞê¾" b"±Z{`▄▄\x15o¤üK¨|Õ§═" b"ó\x1C\x072–Ð,ª\x00mTk¡àp" b"õ¶\x08/\v´Iå¨+¡^㬽\x13" b"õÒä"ŒkGIB0k0lÕ´Š" b"°╝Bw3¿Ü úìQ1┬&®0" b"øÇÄÜ\x1Eše×\e\x08\eÞê/çÁ" b"ù7û\x07!æðü\x15b`Î:"j§" b"ù‰ú>~\fnwíîj\x08úþ?ª" b"ù—맱t#d¤¾-¢ˆ\x17ïr" b"ùûFø\x1D\x04?\x15L8ΨˆEÓö" b"·9 \f¢\e Øö╚IÐ,┐ôÛ" b"úQ.é\x07Pþ\x18\x19\r5\x03÷Z\x16®" b"ú´§õÑdÈ‚ï\x02\x19"Ì%Ø\x15" b"û¢È…eÜë\x04w¼æ9€\x07¦‘" b"û³`løŽ‚&ض<\x1Dé}\x0Fq" b"³xtñÝÆ┬8^Éû\x1Fä2Û¸" b"þ\x03I9Íå\x17Ú%‹›æì-èÙ" b"■\x107┤─üû°àƒ\x12\x13dxq$" b"þ‘‰uºpÕYÓ‹lóà1Rä" b"þêž!\x10þ¡]t4úw\x13&Š|" ] |
||||||||||||||||||||||||
|
0.24 ms (0.05%) |
1 |
# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b""" VDLgæœFï¼\x12*\n 2¼»° """ "account/login" ] |
||||||||||||||||||||||||
|
0.22 ms (0.05%) |
5 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||
|
0.20 ms (0.04%) |
1 |
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (id != ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b""" VDLgæœFï¼\x12*\n 2¼»° """ "" "/account/login" ] |
||||||||||||||||||||||||
|
0.18 ms (0.04%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.17 ms (0.04%) |
1 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||||||||
|
0.16 ms (0.04%) |
1 |
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id WHERE sales_channel.id = ?
Parameters:
[
b"""
VDLgæœFï¼\x12*\n
2¼»°
"""
]
|
||||||||||||||||||||||||
|
0.16 ms (0.04%) |
5 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||||||
|
0.14 ms (0.03%) |
1 |
# base-context-factory::sales-channel::read SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, COALESCE(`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) as `sales_channel.currency.customFields`, `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.currency_id, `sales_channel.currency.translation`.short_name as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.name as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.custom_fields as `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation`.created_at as `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation`.updated_at as `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation`.currency_id as `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation`.language_id as `sales_channel.currency.translation.languageId` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.language_id = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b""" VDLgæœFï¼\x12*\n 2¼»° """ ] |
||||||||||||||||||||||||
|
0.13 ms (0.03%) |
1 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b"Ca~d\x01╠Lì▓ÄIA┌)\x03┼"
]
|
||||||||||||||||||||||||
|
0.12 ms (0.03%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||||||
|
0.11 ms (0.02%) |
1 |
# base-context-factory::shipping-method::read SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.media_id, `shipping_method.media.translation`.title as `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields as `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at as `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at as `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id as `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id as `shipping_method.media.translation.languageId` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.language_id = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"3ðåh╗ÎD¨üVD¥\x18Mä╦" ] |
||||||||||||||||||||||||
|
0.11 ms (0.02%) |
1 |
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters:
[
"8a243080f92e4c719546314b577cf82b"
]
|
||||||||||||||||||||||||
|
0.10 ms (0.02%) |
1 |
# base-context-factory::payment-method::read SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.language_id = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.media_id, `payment_method.media.translation`.title as `payment_method.media.translation.title`, `payment_method.media.translation`.alt as `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields as `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at as `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at as `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id as `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id as `payment_method.media.translation.languageId` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.language_id = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x06@>Û©\x10IB£‰ÄùŠ\x00bÅ" ] |
||||||||||||||||||||||||
|
0.09 ms (0.02%) |
1 |
# cart-rule-loader::load-rules::search-ids SELECT `rule`.`id` FROM `rule` ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[] |
||||||||||||||||||||||||
|
0.08 ms (0.02%) |
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:
[]
|
||||||||||||||||||||||||
|
0.08 ms (0.02%) |
1 |
# base-context-factory::taxes::association::rules::read SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.translation.typeName`, COALESCE(`tax_rule.type.translation.typeName`,`tax_rule.type.translation.typeName`) as `tax_rule.type.typeName`, `tax_rule.type.translation.createdAt`, `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation.languageId`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.tax_rule_type_id, `tax_rule.type.translation`.type_name as `tax_rule.type.translation.typeName`, `tax_rule.type.translation`.created_at as `tax_rule.type.translation.createdAt`, `tax_rule.type.translation`.updated_at as `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation`.tax_rule_type_id as `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation`.language_id as `tax_rule.type.translation.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.language_id = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x03\x00\x7F{8cF┤âÉ®B£y└°" b"/¡#O¹\F¾‰±ç…[•AW" b"=4Õ všC‚§c —}éS\x07" ] |
||||||||||||||||||||||||
|
0.08 ms (0.02%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[
b"""
VDLgæœFï¼\x12*\n
2¼»°
"""
"VhbZhpUMQ7SsNEFq8dEOdtAacwDAbEAc"
]
|
||||||||||||||||||||||||
|
0.08 ms (0.02%) |
1 |
# base-context-factory::currency::read SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||||||
|
0.08 ms (0.02%) |
1 |
# base-context-factory::country::read SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"Z:#~alF]×═─■&\x1Eì▒" ] |
||||||||||||||||||||||||
|
0.08 ms (0.02%) |
1 |
# base-context-factory::customer-group::read SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.name`, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields`, `customer_group.translation.createdAt`, `customer_group.translation.updatedAt`, `customer_group.translation.customerGroupId`, `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.customer_group_id, `customer_group.translation`.name as `customer_group.translation.name`, `customer_group.translation`.registration_title as `customer_group.translation.registrationTitle`, `customer_group.translation`.registration_introduction as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.registration_only_company_registration as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.registration_seo_meta_description as `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation`.custom_fields as `customer_group.translation.customFields`, `customer_group.translation`.created_at as `customer_group.translation.createdAt`, `customer_group.translation`.updated_at as `customer_group.translation.updatedAt`, `customer_group.translation`.customer_group_id as `customer_group.translation.customerGroupId`, `customer_group.translation`.language_id as `customer_group.translation.languageId` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.language_id = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í" ] |
||||||||||||||||||||||||
|
0.07 ms (0.02%) |
1 |
# base-context-factory::sales-channel::association::domains::read 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"""
VDLgæœFï¼\x12*\n
2¼»°
"""
]
|
||||||||||||||||||||||||
|
0.07 ms (0.02%) |
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:
[]
|
||||||||||||||||||||||||
|
0.07 ms (0.01%) |
1 |
# context-factory::base-context SELECT sales_channel.id as sales_channel_id, sales_channel.language_id as sales_channel_default_language_id, sales_channel.currency_id as sales_channel_currency_id, currency.factor as sales_channel_currency_factor, GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids FROM sales_channel INNER JOIN currency ON sales_channel.currency_id = currency.id LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id WHERE sales_channel.id = ? GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters:
[
b"""
VDLgæœFï¼\x12*\n
2¼»°
"""
]
|
||||||||||||||||||||||||
|
0.07 ms (0.01%) |
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"""
VDLgæœFï¼\x12*\n
2¼»°
"""
b"Z:#~alF]×═─■&\x1Eì▒"
]
|
||||||||||||||||||||||||
|
0.06 ms (0.01%) |
1 |
# base-context-factory::taxes::read SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters:
[] |
||||||||||||||||||||||||
|
0.06 ms (0.01%) |
1 |
#cart-persister::load SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = ?
Parameters:
[
"VhbZhpUMQ7SsNEFq8dEOdtAacwDAbEAc"
]
|
||||||||||||||||||||||||
|
0.06 ms (0.01%) |
1 |
# base-context-factory::cash-rounding::search-ids SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters:
[ b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" b"Z:#~alF]×═─■&\x1Eì▒" ] |
||||||||||||||||||||||||
|
0.05 ms (0.01%) |
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"\x11U├©╚(@RÑu┼\\x13¾╦É" b"`†u\x07YBJ9¸m›1±Fá\x15" b"„¢9͵FDm™o\eÿc'‡\x06" b"GööI=®F!¤sàv{¹^ö" b"õ¶\x08/\v´Iå¨+¡^㬽\x13" ] |
||||||||||||||||||||||||
|
0.05 ms (0.01%) |
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:
[]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.