GET https://smoxy-shopware-demo-stage.scalecommerce.cloud/checkout/cart

Response
200 OK
IP
18.216.156.12
Profiled on
Token
268305

Query Metrics

40 Database Queries
22 Different statements
18.86 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
8.36 ms
(44.31%) 		1 
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters: 
[
  "/navigation/018f2db8610870799d023fe5ce1aa11d"
  "/navigation/018f2db8610a708eb7a4f08ea9010600"
  "/navigation/018f2db8610e7265ac895c8a460bbf5f"
  "/navigation/018f2db86114703ca41e46dcb50d0d89"
  "/navigation/018f2db86118716d8c7a9750010a965a"
  "/navigation/018f2db8612571ce8deafb996bf42132"
  "/navigation/018f2db8612c73879d8f18a848fcaed9"
  "/navigation/018f2db8612d72a2a5c03de1f0dfb4d0"
  "/navigation/018f2db8612f70049369bf1088c7c8d6"
  "/navigation/018f2db86130700799d93512c84647a7"
  "/navigation/018f2db86109712ab769bd569fdaf65d"
  "/navigation/018f2db86109712ab769bd56a098fd0a"
  "/navigation/018f2db86109712ab769bd56a17ffcdc"
  "/navigation/018f2db86109712ab769bd56a1d0ceb0"
  "/navigation/018f2db86109712ab769bd56a26dfaa3"
  "/navigation/018f2db86109712ab769bd56a2caa420"
  "/navigation/018f2db86109712ab769bd56a32580cc"
  "/navigation/018f2db8610a708eb7a4f08ea53f5f7e"
  "/navigation/018f2db8610a708eb7a4f08ea5b18715"
  "/navigation/018f2db8610a708eb7a4f08ea62e861b"
  "/navigation/018f2db8610a708eb7a4f08ea64ecd37"
  "/navigation/018f2db8610a708eb7a4f08ea71d303a"
  "/navigation/018f2db8610a708eb7a4f08ea73c885f"
  "/navigation/018f2db8610a708eb7a4f08ea81f65fc"
  "/navigation/018f2db8610a708eb7a4f08ea8a28f6b"
  "/navigation/018f2db8610a708eb7a4f08ea95d2677"
  "/navigation/018f2db8610a708eb7a4f08eaa565ce1"
  "/navigation/018f2db8610a708eb7a4f08eab3fa124"
  "/navigation/018f2db8610a708eb7a4f08eab4bbb32"
  "/navigation/018f2db8610a708eb7a4f08eabf4080f"
  "/navigation/018f2db8610b7324a38219a84b7fdccb"
  "/navigation/018f2db8610b7324a38219a84c6a444a"
  "/navigation/018f2db8610b7324a38219a84c9b2f78"
  "/navigation/018f2db8610b7324a38219a84d4ac098"
  "/navigation/018f2db8610b7324a38219a84d646578"
  "/navigation/018f2db8610b7324a38219a84d9be2ea"
  "/navigation/018f2db8610b7324a38219a84e1cca5a"
  "/navigation/018f2db8610b7324a38219a84efbb095"
  "/navigation/018f2db8610b7324a38219a84f2426f9"
  "/navigation/018f2db8610b7324a38219a84f4a9670"
  "/navigation/018f2db8610b7324a38219a84f8313ac"
  "/navigation/018f2db8610b7324a38219a84fcc5c67"
  "/navigation/018f2db8610b7324a38219a850a617aa"
  "/navigation/018f2db8610c735c83900d75ef3101ba"
  "/navigation/018f2db8610c735c83900d75ef52dcea"
  "/navigation/018f2db8610c735c83900d75efe23d83"
  "/navigation/018f2db8610c735c83900d75eff1779b"
  "/navigation/018f2db8610c735c83900d75effc6ac8"
  "/navigation/018f2db8610c735c83900d75f0441fb5"
  "/navigation/018f2db8610c735c83900d75f0dec764"
  "/navigation/018f2db8610c735c83900d75f1a2d218"
  "/navigation/018f2db8610c735c83900d75f24e2f8a"
  "/navigation/018f2db8610c735c83900d75f2d462e2"
  "/navigation/018f2db8610c735c83900d75f3b2962e"
  "/navigation/018f2db8610c735c83900d75f4588d81"
  "/navigation/018f2db8610c735c83900d75f4a1054d"
  "/navigation/018f2db8610d708e8359a44f5464d9e6"
  "/navigation/018f2db8610d708e8359a44f552ddf4c"
  "/navigation/018f2db8610d708e8359a44f55e28feb"
  "/navigation/018f2db8610d708e8359a44f55f1867d"
  "/navigation/018f2db8610d708e8359a44f5696ae17"
  "/navigation/018f2db8610d708e8359a44f5708a0eb"
  "/navigation/018f2db8610d708e8359a44f575bec8c"
  "/navigation/018f2db8610d708e8359a44f57d7985c"
  "/navigation/018f2db8610d708e8359a44f57f2783e"
  "/navigation/018f2db8610d708e8359a44f588363ff"
  "/navigation/018f2db8610d708e8359a44f59307ff2"
  "/navigation/018f2db8610d708e8359a44f598c7e2c"
  "/navigation/018f2db8610d708e8359a44f59ab0baa"
  "/navigation/018f2db8610e7265ac895c8a429a703d"
  "/navigation/018f2db8610e7265ac895c8a43780ee7"
  "/navigation/018f2db8610e7265ac895c8a43be57dc"
  "/navigation/018f2db8610e7265ac895c8a442a6e9d"
  "/navigation/018f2db8610e7265ac895c8a44a7d2f0"
  "/navigation/018f2db8610e7265ac895c8a458daab6"
  "/navigation/018f2db8610e7265ac895c8a46e3eb3d"
  "/navigation/018f2db8610e7265ac895c8a470cad04"
  "/navigation/018f2db8610e7265ac895c8a477c4665"
  "/navigation/018f2db8610e7265ac895c8a48233656"
  "/navigation/018f2db8610e7265ac895c8a48da201a"
  "/navigation/018f2db8610f70c7bbb3fcd87812e0ef"
  "/navigation/018f2db8610f70c7bbb3fcd87905545f"
  "/navigation/018f2db8610f70c7bbb3fcd879b6932b"
  "/navigation/018f2db8610f70c7bbb3fcd87a286ac5"
  "/navigation/018f2db8610f70c7bbb3fcd87a689520"
  "/navigation/018f2db8610f70c7bbb3fcd87ac5a8eb"
  "/navigation/018f2db8610f70c7bbb3fcd87b5a376d"
  "/navigation/018f2db8610f70c7bbb3fcd87b76632c"
  "/navigation/018f2db8610f70c7bbb3fcd87c415152"
  "/navigation/018f2db8610f70c7bbb3fcd87cc211b6"
  "/navigation/018f2db8610f70c7bbb3fcd87d217f54"
  "/navigation/018f2db8610f70c7bbb3fcd87e209ad0"
  "/navigation/018f2db8610f70c7bbb3fcd87e9e1db3"
  "/navigation/018f2db86110730296b878762a217fad"
  "/navigation/018f2db86110730296b878762aedb141"
  "/navigation/018f2db86110730296b878762af102c9"
  "/navigation/018f2db86110730296b878762bd92dca"
  "/navigation/018f2db86110730296b878762c0f8fcf"
  "/navigation/018f2db86110730296b878762ce5d213"
  "/navigation/018f2db86110730296b878762de12b12"
  "/navigation/018f2db86110730296b878762de9cfe6"
  "/navigation/018f2db86110730296b878762e6c3d8e"
  "/navigation/018f2db86110730296b878762e9f8f9b"
  "/navigation/018f2db86110730296b878762ea8efc4"
  "/navigation/018f2db86110730296b878762ef768fa"
  "/navigation/018f2db86110730296b878762f5a4e2e"
  "/navigation/018f2db86111709cb656399517c608e6"
  "/navigation/018f2db86111709cb656399518388637"
  "/navigation/018f2db86111709cb6563995191211a4"
  "/navigation/018f2db86111709cb6563995194a7b28"
  "/navigation/018f2db86111709cb6563995199163b6"
  "/navigation/018f2db86111709cb656399519f3fff7"
  "/navigation/018f2db86111709cb65639951a76c081"
  "/navigation/018f2db86111709cb65639951b71996d"
  "/navigation/018f2db86111709cb65639951b810207"
  "/navigation/018f2db86111709cb65639951c624f6d"
  "/navigation/018f2db86111709cb65639951d530e73"
  "/navigation/018f2db86111709cb65639951e37f4ca"
  "/navigation/018f2db86111709cb65639951e706530"
  "/navigation/018f2db8611273418a96d51b1ac81c63"
  "/navigation/018f2db8611273418a96d51b1accff82"
  "/navigation/018f2db8611273418a96d51b1adccb0f"
  "/navigation/018f2db8611273418a96d51b1b40a06c"
  "/navigation/018f2db8611273418a96d51b1b49ec40"
  "/navigation/018f2db8611273418a96d51b1ba06d10"
  "/navigation/018f2db8611273418a96d51b1ba74209"
  "/navigation/018f2db8611273418a96d51b1c598248"
  "/navigation/018f2db8611273418a96d51b1cddf24b"
  "/navigation/018f2db8611273418a96d51b1d200552"
  "/navigation/018f2db8611273418a96d51b1db5a9ce"
  "/navigation/018f2db8611273418a96d51b1e2b7054"
  "/navigation/018f2db8611371fdbaa835860367d236"
  "/navigation/018f2db8611371fdbaa83586040889a7"
  "/navigation/018f2db8611371fdbaa83586049fa5f9"
  "/navigation/018f2db8611371fdbaa8358605853722"
  "/navigation/018f2db8611371fdbaa8358606476045"
  "/navigation/018f2db8611371fdbaa835860715fab7"
  "/navigation/018f2db8611371fdbaa8358607acf39d"
  "/navigation/018f2db8611371fdbaa83586080300fa"
  "/navigation/018f2db8611371fdbaa8358608679bf9"
  "/navigation/018f2db8611371fdbaa835860965897b"
  "/navigation/018f2db8611371fdbaa835860a46f75e"
  "/navigation/018f2db8611371fdbaa835860b01a166"
  "/navigation/018f2db86114703ca41e46dcb25e3708"
  "/navigation/018f2db86114703ca41e46dcb2b2b608"
  "/navigation/018f2db86114703ca41e46dcb3755e0c"
  "/navigation/018f2db86114703ca41e46dcb40d3cdc"
  "/navigation/018f2db86114703ca41e46dcb45a0485"
  "/navigation/018f2db86114703ca41e46dcb572773a"
  "/navigation/018f2db86114703ca41e46dcb610d862"
  "/navigation/018f2db86114703ca41e46dcb6ee7903"
  "/navigation/018f2db86114703ca41e46dcb709113f"
  "/navigation/018f2db86114703ca41e46dcb7ae20ac"
  "/navigation/018f2db86114703ca41e46dcb883bdfa"
  "/navigation/018f2db86115703bb9e50a9981277e3c"
  "/navigation/018f2db86115703bb9e50a9981da800d"
  "/navigation/018f2db86115703bb9e50a9982840252"
  "/navigation/018f2db86115703bb9e50a9982f96355"
  "/navigation/018f2db86115703bb9e50a9983627465"
  "/navigation/018f2db86115703bb9e50a998394f58e"
  "/navigation/018f2db86115703bb9e50a99844d222d"
  "/navigation/018f2db86115703bb9e50a99845d194c"
  "/navigation/018f2db86115703bb9e50a9984eace1c"
  "/navigation/018f2db86115703bb9e50a9985d4269e"
  "/navigation/018f2db86115703bb9e50a9985d5bd39"
  "/navigation/018f2db86115703bb9e50a9985f53058"
  "/navigation/018f2db86115703bb9e50a9986362560"
  "/navigation/018f2db8611673cd9d44bc532e3b95f4"
  "/navigation/018f2db8611673cd9d44bc532ee591a5"
  "/navigation/018f2db8611673cd9d44bc532f18e9fc"
  "/navigation/018f2db8611673cd9d44bc532f1c4a30"
  "/navigation/018f2db8611673cd9d44bc53301aea58"
  "/navigation/018f2db8611673cd9d44bc53303ebd07"
  "/navigation/018f2db8611673cd9d44bc53306fbab2"
  "/navigation/018f2db8611673cd9d44bc53311e4b0b"
  "/navigation/018f2db8611673cd9d44bc5331678484"
  "/navigation/018f2db8611673cd9d44bc5332560bd4"
  "/navigation/018f2db8611673cd9d44bc5332994421"
  "/navigation/018f2db8611673cd9d44bc53335a756e"
  "/navigation/018f2db8611673cd9d44bc5333d056c0"
  "/navigation/018f2db8611772af84043572e0691b95"
  "/navigation/018f2db8611772af84043572e13d0d41"
  "/navigation/018f2db8611772af84043572e1cc274e"
  "/navigation/018f2db8611772af84043572e20b6ff3"
  "/navigation/018f2db8611772af84043572e28b7450"
  "/navigation/018f2db8611772af84043572e339139c"
  "/navigation/018f2db8611772af84043572e354da95"
  "/navigation/018f2db8611772af84043572e419ed2d"
  "/navigation/018f2db8611772af84043572e5018f41"
  "/navigation/018f2db8611772af84043572e5879017"
  "/navigation/018f2db8611772af84043572e5ba92eb"
  "/navigation/018f2db8611772af84043572e5f319c7"
  "/navigation/018f2db8611772af84043572e5f87926"
  "/navigation/018f2db86118716d8c7a974ffb40a7b2"
  "/navigation/018f2db86118716d8c7a974ffc3e8919"
  "/navigation/018f2db86118716d8c7a974ffcd05ed5"
  "/navigation/018f2db86118716d8c7a974ffd311d0a"
  "/navigation/018f2db86118716d8c7a974ffdec2d19"
  "/navigation/018f2db86118716d8c7a974ffea8eb26"
  "/navigation/018f2db86118716d8c7a974ffefd79f9"
  "/navigation/018f2db86118716d8c7a974fff5cb0c9"
  "/navigation/018f2db86118716d8c7a9750001bcd49"
  "/navigation/018f2db86118716d8c7a975001634285"
  "/navigation/018f2db86118716d8c7a975001f56dfa"
  "/navigation/018f2db86119707cbbc2271ee972f16f"
  "/navigation/018f2db86119707cbbc2271eebaaa70a"
  "/navigation/018f2db86119707cbbc2271eec1d6f26"
  "/navigation/018f2db8611a70738e2b104997bd2e8a"
  "/navigation/018f2db8611a70738e2b104998af1e04"
  "/navigation/018f2db8611a70738e2b10499b124261"
  "/navigation/018f2db8611a70738e2b10499c68ea9d"
  "/navigation/018f2db8611b73fb81c76d9ef5280d62"
  "/navigation/018f2db8611b73fb81c76d9ef6c0707d"
  "/navigation/018f2db8611b73fb81c76d9ef78f7976"
  "/navigation/018f2db8611b73fb81c76d9ef8653b19"
  "/navigation/018f2db8611c7350a3eae9f112148acc"
  "/navigation/018f2db8611c7350a3eae9f114dbbd23"
  "/navigation/018f2db8611c7350a3eae9f1151c87a8"
  "/navigation/018f2db8611d73679b2443e0e2747cb7"
  "/navigation/018f2db8611d73679b2443e0e4618c3b"
  "/navigation/018f2db8611d73679b2443e0e531c995"
  "/navigation/018f2db8611e7304a2fac2c1474959ba"
  "/navigation/018f2db8611e7304a2fac2c1490fd031"
  "/navigation/018f2db8611e7304a2fac2c14a009b97"
  "/navigation/018f2db8611e7304a2fac2c14a5cec30"
  "/navigation/018f2db8611f71a1815e9b7605a9957f"
  "/navigation/018f2db8611f71a1815e9b7607e94bb7"
  "/navigation/018f2db8611f71a1815e9b760860b1ae"
  "/navigation/018f2db8611f71a1815e9b7609c501ad"
  "/navigation/018f2db86120727e8c711d0cf1087da5"
  "/navigation/018f2db86120727e8c711d0cf3a03098"
  "/navigation/018f2db86120727e8c711d0cf55095d6"
  "/navigation/018f2db86121709eb021d7b43f2d4df8"
  "/navigation/018f2db86121709eb021d7b440151296"
  "/navigation/018f2db86121709eb021d7b44038652c"
  "/navigation/018f2db86121709eb021d7b4414b439d"
  "/navigation/018f2db86122711d80daace2750db792"
  "/navigation/018f2db86122711d80daace2778db707"
  "/navigation/018f2db86122711d80daace277cbc39e"
  "/navigation/018f2db8612371be9df37d88394ffc82"
  "/navigation/018f2db8612371be9df37d883c167c5e"
  "/navigation/018f2db8612371be9df37d883d11e00b"
  "/navigation/018f2db8612371be9df37d883e0a8fa7"
  "/navigation/018f2db8612371be9df37d883f703184"
  "/navigation/018f2db86124703ca534a9a23c0aaded"
  "/navigation/018f2db86124703ca534a9a23f638845"
  "/navigation/018f2db8612571ce8deafb9969a9fb3e"
  "/navigation/018f2db8612571ce8deafb996c1bb48e"
  "/navigation/018f2db8612571ce8deafb996c4c28b9"
  "/navigation/018f2db8612671fdb0d288fb01305450"
  "/navigation/018f2db8612671fdb0d288fb01b8c84d"
  "/navigation/018f2db8612671fdb0d288fb026c0955"
  "/navigation/018f2db8612671fdb0d288fb02f9d9ec"
  "/navigation/018f2db8612671fdb0d288fb0303787e"
  "/navigation/018f2db8612671fdb0d288fb035f4586"
  "/navigation/018f2db8612671fdb0d288fb037f73d6"
  "/navigation/018f2db8612671fdb0d288fb04141bf3"
  "/navigation/018f2db8612671fdb0d288fb04dd6f87"
  "/navigation/018f2db8612671fdb0d288fb05ca487e"
  "/navigation/018f2db8612671fdb0d288fb065841a8"
  "/navigation/018f2db8612671fdb0d288fb066849de"
  "/navigation/018f2db8612671fdb0d288fb074bdcff"
  "/navigation/018f2db861277300b8499e08d49c40df"
  "/navigation/018f2db861277300b8499e08d55ad558"
  "/navigation/018f2db861277300b8499e08d599413b"
  "/navigation/018f2db861277300b8499e08d60db751"
  "/navigation/018f2db861277300b8499e08d659aec4"
  "/navigation/018f2db861277300b8499e08d6f935d4"
  "/navigation/018f2db861277300b8499e08d772b491"
  "/navigation/018f2db861277300b8499e08d7c703b1"
  "/navigation/018f2db861277300b8499e08d826e888"
  "/navigation/018f2db861277300b8499e08d8b4c7ff"
  "/navigation/018f2db861277300b8499e08d9a94f4f"
  "/navigation/018f2db861277300b8499e08da464eba"
  "/navigation/018f2db8612872a9b8d5fab22b249454"
  "/navigation/018f2db8612872a9b8d5fab22bffc7cc"
  "/navigation/018f2db8612872a9b8d5fab22c0a49f0"
  "/navigation/018f2db8612872a9b8d5fab22c12eb18"
  "/navigation/018f2db8612872a9b8d5fab22d0ba7e6"
  "/navigation/018f2db8612872a9b8d5fab22da93650"
  "/navigation/018f2db8612872a9b8d5fab22e2ffd31"
  "/navigation/018f2db8612872a9b8d5fab22ef6ae9c"
  "/navigation/018f2db8612872a9b8d5fab22f6492ad"
  "/navigation/018f2db8612872a9b8d5fab22ffeb8d0"
  "/navigation/018f2db8612872a9b8d5fab23087f8e5"
  "/navigation/018f2db8612872a9b8d5fab23101020c"
  "/navigation/018f2db8612872a9b8d5fab2311c91b4"
  "/navigation/018f2db8612970c3ba48a576b044519a"
  "/navigation/018f2db8612970c3ba48a576b067df12"
  "/navigation/018f2db8612970c3ba48a576b084398e"
  "/navigation/018f2db8612970c3ba48a576b14cb256"
  "/navigation/018f2db8612970c3ba48a576b2042ab7"
  "/navigation/018f2db8612970c3ba48a576b2eab871"
  "/navigation/018f2db8612970c3ba48a576b36b155e"
  "/navigation/018f2db8612970c3ba48a576b44286bb"
  "/navigation/018f2db8612970c3ba48a576b49ca8a5"
  "/navigation/018f2db8612970c3ba48a576b5956160"
  "/navigation/018f2db8612970c3ba48a576b5f82a22"
  "/navigation/018f2db8612a72e0a6f38c562e96aa12"
  "/navigation/018f2db8612a72e0a6f38c562ee6e58b"
  "/navigation/018f2db8612a72e0a6f38c562ef67832"
  "/navigation/018f2db8612a72e0a6f38c562f0af66b"
  "/navigation/018f2db8612a72e0a6f38c562fcda6c0"
  "/navigation/018f2db8612a72e0a6f38c56301b46eb"
  "/navigation/018f2db8612a72e0a6f38c5630cb417f"
  "/navigation/018f2db8612a72e0a6f38c56312cbcf1"
  "/navigation/018f2db8612a72e0a6f38c5631b5377e"
  "/navigation/018f2db8612a72e0a6f38c56328d0ed1"
  "/navigation/018f2db8612a72e0a6f38c5633206620"
  "/navigation/018f2db8612a72e0a6f38c563345aa5c"
  "/navigation/018f2db8612b7133b4eec0a76ebeedf3"
  "/navigation/018f2db8612b7133b4eec0a76ee3b98a"
  "/navigation/018f2db8612b7133b4eec0a76fcc1b19"
  "/navigation/018f2db8612b7133b4eec0a77050aee7"
  "/navigation/018f2db8612b7133b4eec0a771184de4"
  "/navigation/018f2db8612b7133b4eec0a7711df61d"
  "/navigation/018f2db8612b7133b4eec0a771ffef11"
  "/navigation/018f2db8612b7133b4eec0a7721c4786"
  "/navigation/018f2db8612b7133b4eec0a772fdef07"
  "/navigation/018f2db8612b7133b4eec0a77352cf56"
  "/navigation/018f2db8612b7133b4eec0a774328883"
  "/navigation/018f2db8612b7133b4eec0a774329d1c"
  "/navigation/018f2db8612b7133b4eec0a774fd63c1"
  "/navigation/018f2db8612c73879d8f18a8494448b3"
  "/navigation/018f2db8612c73879d8f18a84a0c1d9d"
  "/navigation/018f2db8612c73879d8f18a84aa53c82"
  "/navigation/018f2db8612c73879d8f18a84b374b88"
  "/navigation/018f2db8612c73879d8f18a84b86738b"
  "/navigation/018f2db8612c73879d8f18a84c199d2d"
  "/navigation/018f2db8612c73879d8f18a84c7103f0"
  "/navigation/018f2db8612c73879d8f18a84d1e4c00"
  "/navigation/018f2db8612c73879d8f18a84dfd1ade"
  "/navigation/018f2db8612c73879d8f18a84ee4ff3a"
  "/navigation/018f2db8612c73879d8f18a84f1f7fa8"
  "/navigation/018f2db8612d72a2a5c03de1ef6d7d7e"
  "/navigation/018f2db8612d72a2a5c03de1f011a2ed"
  "/navigation/018f2db8612d72a2a5c03de1f01d61c4"
  "/navigation/018f2db8612d72a2a5c03de1f1ace2be"
  "/navigation/018f2db8612d72a2a5c03de1f1c09f5b"
  "/navigation/018f2db8612d72a2a5c03de1f1f49008"
  "/navigation/018f2db8612d72a2a5c03de1f269d0da"
  "/navigation/018f2db8612d72a2a5c03de1f30021b3"
  "/navigation/018f2db8612d72a2a5c03de1f37c8905"
  "/navigation/018f2db8612e72958e799f98c0816280"
  "/navigation/018f2db8612e72958e799f98c0d78cba"
  "/navigation/018f2db8612e72958e799f98c1425a85"
  "/navigation/018f2db8612e72958e799f98c210fd30"
  "/navigation/018f2db8612e72958e799f98c2dbaa2f"
  "/navigation/018f2db8612e72958e799f98c33ee41b"
  "/navigation/018f2db8612e72958e799f98c38c684c"
  "/navigation/018f2db8612e72958e799f98c3e5815e"
  "/navigation/018f2db8612e72958e799f98c462545a"
  "/navigation/018f2db8612e72958e799f98c50ffd90"
  "/navigation/018f2db8612e72958e799f98c60cedd3"
  "/navigation/018f2db8612e72958e799f98c6cc1f0c"
  "/navigation/018f2db8612e72958e799f98c6e6258c"
  "/navigation/018f2db8612f70049369bf1088934c19"
  "/navigation/018f2db8612f70049369bf1088a5bd05"
  "/navigation/018f2db8612f70049369bf1089139cf8"
  "/navigation/018f2db8612f70049369bf108974470a"
  "/navigation/018f2db8612f70049369bf108a3cb6bf"
  "/navigation/018f2db8612f70049369bf108a66c8b6"
  "/navigation/018f2db8612f70049369bf108a9ab87b"
  "/navigation/018f2db8612f70049369bf108aee0789"
  "/navigation/018f2db8612f70049369bf108b843a82"
  "/navigation/018f2db8612f70049369bf108ba3baf2"
  "/navigation/018f2db86130700799d93512c3c15e85"
  "/navigation/018f2db86130700799d93512c49d786a"
  "/navigation/018f2db86130700799d93512c523da4e"
  "/navigation/018f2db86130700799d93512c53c6953"
  "/navigation/018f2db86130700799d93512c5ee15d0"
  "/navigation/018f2db86130700799d93512c63a16d4"
  "/navigation/018f2db86130700799d93512c7246b99"
  "/navigation/018f2db86130700799d93512c7d3e578"
  "/navigation/018f2db86130700799d93512c859799d"
  "/navigation/018f2db86130700799d93512c8ad1a92"
  "/navigation/018f2db8613170cd95363d602a3f7c6a"
  "/navigation/018f2db8613170cd95363d602ba00372"
  "/navigation/018f2db8613170cd95363d602e1d2051"
  "/navigation/018f2db861327056b348d6ea8a88f654"
  "/navigation/018f2db861327056b348d6ea8d5636cd"
  "/navigation/018f2db861327056b348d6ea8d7e9937"
  "/navigation/018f2db861327056b348d6ea8feaa18f"
  "/navigation/018f2db8613372cfac410d9945065518"
  "/navigation/018f2db8613372cfac410d99465e04e6"
  "/navigation/018f2db8613372cfac410d9948397156"
  "/navigation/018f2db8613372cfac410d99491040f7"
  "/navigation/018f2db861347043a489cc925380f706"
  "/navigation/018f2db861347043a489cc9256038997"
  "/navigation/018f2db861347043a489cc9256eb3cad"
  "/navigation/018f2db8613572ecac623aba27fb17a2"
  "/navigation/018f2db8613572ecac623aba28ed01f9"
  "/navigation/018f2db8613572ecac623aba292dfad7"
  "/navigation/018f2db8613572ecac623aba2b50878d"
  "/navigation/018f2db86136739c9eb57e90a1d10b96"
  "/navigation/018f2db86136739c9eb57e90a3996918"
  "/navigation/018f2db86136739c9eb57e90a53c9e91"
  "/navigation/018f2db8613771d0a5d57313771b561e"
  "/navigation/018f2db8613771d0a5d57313772f40aa"
  "/navigation/018f2db8613771d0a5d57313778b2586"
  "/navigation/018f2db8613771d0a5d573137909c5db"
  "/navigation/018f2db86138720fab015b2d0616413a"
  "/navigation/018f2db86138720fab015b2d08818a49"
  "/navigation/018f2db86138720fab015b2d09e8971a"
  "/navigation/018f2db86139723b972fb501292c81f7"
  "/navigation/018f2db86139723b972fb5012a088290"
  "/navigation/018f2db86139723b972fb5012ca0df90"
  "/navigation/018f2db8613a73059b90282ecb5ca6bb"
  "/navigation/018f2db8613a73059b90282ecd72bc9c"
  "/navigation/018f2db8613a73059b90282ece886b5a"
  "/navigation/018f2db8613b734ea75f449f30d04d1a"
  "/navigation/018f2db8613b734ea75f449f319ee1c3"
  "/navigation/018f2db8613b734ea75f449f3328c23e"
  "/navigation/018f2db8613b734ea75f449f34fb4461"
  "/navigation/018f2db8613c7375b9ba77999ef396c7"
  "/navigation/018f2db8613c7375b9ba7799a1eee91b"
  "/navigation/018f2db8613d713fa9efd09c6827f61e"
  "/navigation/018f2db8613d713fa9efd09c68ac9d4b"
  "/navigation/018f2db8613d713fa9efd09c6babd8b7"
  "/navigation/018f2db8613e7129a3ae7f3a4b331ee8"
  "/navigation/018f2db8613e7129a3ae7f3a4e37583c"
  "/navigation/018f2db8613e7129a3ae7f3a5036dbc0"
  "/navigation/018f2db8613f7196becdcb40c0a709ac"
  "/navigation/018f2db8613f7196becdcb40c19fac48"
  "/navigation/018f2db8613f7196becdcb40c3e48265"
  "/navigation/018f2db861407348bebbd5f975d08b81"
  "/navigation/018f2db861407348bebbd5f975f2f5c6"
  "/navigation/018f2db861407348bebbd5f9761ed581"
  "/navigation/018f2db861407348bebbd5f97899a9fd"
  "/navigation/018f2db861407348bebbd5f97b441d26"
  "/navigation/018f2db861417199afda7a68bf386f63"
  "/navigation/018f2db861417199afda7a68c1e51e94"
  "/navigation/018f2db861417199afda7a68c2f4a390"
  "/navigation/018f2db86142711d9f2cef360e0ef67d"
  "/navigation/018f2db86142711d9f2cef360f94bee3"
  "/navigation/018f2db86142711d9f2cef3610659140"
  "/navigation/018f2db86142711d9f2cef3611633b15"
  "/navigation/018f2db8614371529c2f87d9091060dd"
  "/navigation/018f2db8614371529c2f87d90add349b"
  "/navigation/018f2db8614371529c2f87d90bb96def"
  "/navigation/018f2db86144710fb47708d1e0461523"
  "/navigation/018f2db86144710fb47708d1e2799580"
  "/navigation/018f2db8614571aa91996e4abdf2080e"
  "/navigation/018f2db8614571aa91996e4ac06efa56"
  "/navigation/018f2db8614672cda814fb4f23f11426"
  "/navigation/018f2db8614672cda814fb4f249fb1ea"
  "/navigation/018f2db8614672cda814fb4f251927f6"
  "/navigation/018f2db8614672cda814fb4f272f0c1c"
  "/navigation/018f2db86147730f8ae5c07c34d422a6"
  "/navigation/018f2db86147730f8ae5c07c3628f4d8"
  "/navigation/018f2db8614872938af625f79719341d"
  "/navigation/018f2db8614872938af625f798123517"
  "/navigation/018f2db8614872938af625f79cc9d78a"
  "/navigation/018f2db8614971a2acdcd318fd537a0c"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01Å-©\x14æq█¬À´Âu8¼á"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.91 ms
(10.11%) 		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"\x01Å-À▀Qq▀ç┌╗¶G7÷Ð"
  b"\x01Å-À▀Wsoë█▀óÕ¤éÄ"
  b"\x01Å-À▀Wsoë█▀óµU\\x08"
  b"\x01Å-À▀èq*Ä1TÙ2\x100╠"
  b"\x01Å-À▀èq*Ä1TÙ2GF╩"
  b"\x01Å-À▀ïr\x0F¡┘,Ö11>-"
  b"\x01Å-À▀ïr\x0F¡┘,Ö1┘░w"
  b"\x01Å-À▀ïr\x0F¡┘,Ö2╬\x03§"
  b"\x01Å-À▀ïr\x0F¡┘,Ö3vt?"
  b"\x01Å-À▀îr\rüô\x16µ\n‗<\x00"
  b"""
    \x01Å-À▀îr\rüô\x16µ\n
    ¹‗\x0F
    """
  b"\x01Å-À▀îr\rüô\x16µ\v║"▓"
  b"\x01Å-À▀îr\rüô\x16µ\fdña"
  b"\x01Å-À▀ìqeóØE-\v)áª"
  b"\x01Å-À▀ìqeóØE-\v8«│"
  b"\x01Å-À▀ìqeóØE-\vÂ\x02ñ"
  b"\x01Å-À▀ìqeóØE-\v°)."
  b"\x01Å-À▀ÄpÀÆè&µƒ=%\x18"
  b"\x01Å-À▀Ösõ¥ß■¿ãà\x12æ"
  b"\x01Å-À▀Ösõ¥ß■¿ãÈ°O"
  b"\x01Å-À▀ÜrCû▓H]ü,{³"
  b"\x01Å-À▀ÜrCû▓H]é\x06{ê"
  b"\x01Å-À▀ÜrCû▓H]é`Öó"
  b"\x01Å-À▀ør[ó±Ã\x10╚\v¡g"
  b"\x01Å-À▀ør[ó±Ã\x10╔\x00\x0F\x00"
  b"\x01Å-À▀£sä¿Í\QÇ­çN"
  b"\x01Å-À▀£sä¿Í\QǨ6Þ"
  b"\x01Å-À▀£sä¿Í\Qüo­ý"
  b"\x01Å-À▀Øsüö²┘¿\x18ó±\x16"
  b"\x01Å-À▀Øsüö²┘¿\x196\x01Æ"
  b"\x01Å-À▀Øsüö²┘¿\x19ï╔╚"
  b"\x01Å-À▀×p─ë2u\x18À\x04\x10▀"
  b"""
    \x01Å-À▀×p─ë2u\x18Ài\n
    ▀
    """
  b"\x01Å-ÀÛ8q\x0Fù▄\x1F=Jàͼ"
  b"\x01Å-ÀÛ8q\x0Fù▄\x1F=JÚQÉ"
  b"\x01Å-ÀÛ9s¦▒»■Ó╬ÎNÜ"
  b"\x01Å-ÀÛ9s¦▒»■Ó¤\x18ÔÆ"
  b"\x01Å-ÀÛ:rh®«°ùôÅ»t"
  b"\x01Å-ÀÛ:rh®«°ùô▓¨Â"
  b"\x01Å-ÀÛ;szí§[Ný«\x03Å"
  b"\x01Å-ÀÛ;szí§[NÝ!▀{"
  b"\x01Å-ÀÛ;szí§[NÝ ╝╝"
  b"\x01Å-ÀÛ<sg▒±/ýîùF}"
  b"\x01Å-ÀÛ<sg▒±/ýì&l\x1C"
  b"\x01Å-ÀÛ<sg▒±/ý줷c"
  b"\x01Å-ÀÛ=pÎÑJÖùk&v‗"
  b"\x01Å-ÀÛ=pÎÑJÖùk▒¢²"
  b"\x01Å-ÀÛ=pÎÑJÖùl\x1Ad "
  b"\x01Å-ÀÛ>r<£¹;▓Ò:Ìw"
  b"\x01Å-ÀÛ>r<£¹;▓õ&:_"
  b"\x01Å-ÀÛ?s┘¡\x15ÿıú╚ÅÉ"
  b"\x01Å-ÀÛ?s┘¡\x15ÿıñ\x7F\x18░"
  b"\x01Å-ÀÛ@rx¡T=+\x08/l&"
  b"\x01Å-ÀÛ@rx¡T=+\t'ãÞ"
  b"\x01Å-ÀÛ@rx¡T=+\t┬õ▒"
  b"\x01Å-ÀÛAráÖf¨íAYïÅ"
  b"\x01Å-ÀÛAráÖf¨íAîgI"
  b"\x01Å-ÀÛAráÖf¨íB\x18ÜZ"
  b"\x01Å-ÀÛBpeàËç¹ÐRSÅ"
  b"\x01Å-ÀÛBpeàËç¹Ê\x18Èa"
  b"\x01Å-ÀÛBpeàËç¹Ê9\x7Fï"
  b"\x01Å-ÀÛCq!┤\x06à°╦«öI"
  b"\x01Å-ÀÛCq!┤\x06à°╠\x03\x0F‗"
  b"\x01Å-ÀÛCq!┤\x06à°╠±$^"
  b"\x01Å-ÀÛDrÊ×<ã>~─Dı"
  b"\x01Å-ÀÛDrÊ×<ã>\x7F{\x06="
  b"\x01Å-ÀÛDrÊ×<ã>\x7Fú╗n"
  b"\x01Å-ÀÛEryÆ\x08\x07 vÿ>5"
  b"\x01Å-ÀÛEryÆ\x08\x07 w(Åã"
  b"\x01Å-ÀÛEryÆ\x08\x07 w9õ┼"
  b"\x01Å-ÀÛFswê\x07q1i\e÷¿"
  b"\x01Å-ÀÛFswê\x07q1i3^°"
  b"\x01Å-ÀÛFswê\x07q1j\x1Fµ¬"
  b"\x01Å-ÀÛGp ░êBÊ\°'&"
  b"\x01Å-ÀÛGp ░êBÊ]Ë[%"
  b"\x01Å-ÀÛGp ░êBÊ^uÙ="
  b"\x01Å-ÀÛHsm│|ÂR(í┤³"
  b"\x01Å-ÀÛHsm│|ÂR(ÓÞù"
  b"\x01Å-ÀÛIq│öý\x03v]+\x19Å"
  b"\x01Å-ÀÛIq│öý\x03v]|¾ó"
  b"\x01Å-ÀÛIq│öý\x03v^d\x12F"
  b"\x01Å-ÀÛJs>¬´¹\x00Ì╝h¯"
  b"\x01Å-ÀÛJs>¬´¹\x00▀1¦G"
  b"\x01Å-ÀÛJs>¬´¹\x00▀└þ▒"
  b"\x01Å-ÀÛKpøí\x01Y╚ G╠£"
  b"\x01Å-ÀÛKpøí\x01Y╚!<É\x05"
  b"\x01Å-ÀÛKpøí\x01Y╚!Å┼þ"
  b"\x01Å-ÀÛLrþªs©ÉÓ╩╗`"
  b"\x01Å-ÀÛLrþªs©Éß6ýe"
  b"\x01Å-ÀÛLrþªs©Éß{\x15├"
  b"\x01Å-ÀÛMsFî═J§è‗■c"
  b"\x01Å-ÀÛMsFî═J§ï{Á║"
  b"\x01Å-ÀÛMsFî═J§ïÇÉ\x11"
  b"\x01Å-ÀÛNr±┤#ÊðäŤâ"
  b"\x01Å-ÀÛNr±┤#ÊðàhöË"
  b"\x01Å-ÀÛNr±┤#Êðå\x1DÞ\x07"
  b"\x01Å-ÀÛOp\¬e*£WÕ«¬"
  b"\x01Å-ÀÛOp\¬e*£X0┬\x06"
  b"\x01Å-ÀÛOp\¬e*£Y/╔ê"
  b"\x01Å-ÀÛPq«å^î¶aÁÌm"
  b"\x01Å-ÀÛPq«å^î¶b.▓S"
  b"\x01Å-ÀÛPq«å^î¶bvè/"
  b"\x01Å-ÀÛQp\x03ñÐû¯ÆÐ\N"
  b"""
    \x01Å-ÀÛQp\x03ñÐû¯ôg\n
    Å
    """
  b"\x01Å-ÀÛRq?▓]\x11çÇ=3\x04"
  b"\x01Å-ÀÛRq?▓]\x11çÇ´§X"
  b"\x01Å-ÀÛRq?▓]\x11çüd¦|"
  b"\x01Å-ÀÛSp|É\x0Eô║>'<K"
  b"\x01Å-ÀÛSp|É\x0Eô║>¦\x10J"
  b"\x01Å-ÀÛTq¦ª\x16╚\x13BC«é"
  b"\x01Å-ÀÛTq¦ª\x16╚\x13Bò╗h"
  b"\x01Å-ÀÛTq¦ª\x16╚\x13BÓã "
  b"\x01Å-ÀÛUq¼ÿ\x07¿\vúd{\x15"
  b"\x01Å-ÀÛUq¼ÿ\x07¿\vñ\x16^¼"
  b"\x01Å-ÀÛUq¼ÿ\x07¿\vñÊî\x13"
  b"\x01Å-ÀÛVq\x7F¡È\eâ²xÂ╗"
  b"\x01Å-ÀÛVq\x7F¡È\eâ²┬ñ`"
  b"\x01Å-ÀÛVq\x7F¡È\eâ■/%Å"
  b"\x01Å-ÀÛWs┤ö\x02ÿÕ\x16Þ\x15N"
  b"""
    \x01Å-ÀÛWs┤ö\x02ÿÕ\x17É\n
    d
    """
  b"\x01Å-ÀÛWs┤ö\x02ÿÕ\x17▄\x12Ñ"
  b"\x01Å-ÀÛXr╗¿\týä╚└└\x1C"
  b"\x01Å-ÀÛXr╗¿\týä╔£uê"
  b"\x01Å-ÀÛXr╗¿\týä╔µyÑ"
  b"\x01Å-ÀÛYsäû1╠Þ71­w"
  b"\x01Å-ÀÛYsäû1╠Þ7╚Ã\x05"
  b"\x01Å-ÀÛZs\x1F½g\x03╚gFv¢"
  b"\x01Å-ÀÛZs\x1F½g\x03╚gÆoÔ"
  b"\x01Å-ÀÛZs\x1F½g\x03╚g¨ÿÅ"
  b"\x01Å-ÀÛ[s╝½aÁi·«¾ý"
  b"\x01Å-ÀÛ[s╝½aÁi¹¡®?"
  b"\x01Å-ÀÛ[s╝½aÁi³-|c"
  b"\x01Å-ÀÛ\r­ô\x03H5\x1D\x0FcÚ"
  b"\x01Å-ÀÛ\r­ô\x03H5\x1D╗\x14º"
  b"\x01Å-ÀÛ\r­ô\x03H5\x1D¥{w"
  b"\x01Å-ÀÛ]s%╣▀°ÛoMä "
  b"\x01Å-ÀÛ]s%╣▀°ÛoÊ@="
  b"\x01Å-ÀÛ]s%╣▀°Ûpï║±"
  b"\x01Å-ÀÛ^s¬│\x1AÑ»´RV¢"
  b"\x01Å-ÀÛ^s¬│\x1AÑ»´c/Z"
  b"\x01Å-ÀÛ^s¬│\x1AÑ»­P┘¨"
  b"\x01Å-ÀÛ_s1£Åä!\x05£\x0E»"
  b"\x01Å-ÀÛ_s1£Åä!\x06åÔ\"
  b"\x01Å-ÀÛ_s1£Åä!\x06®¢ì"
  b"\x01Å-ÀÛ`sb▒íóGª┼yþ"
  b"\x01Å-ÀÛ`sb▒íóGº\x1F┐R"
  b"\x01Å-ÀÛasÎöÇI:\x1E\x11Bp"
  b"\x01Å-ÀÛasÎöÇI:\x1E┴kþ"
  b"\x01Å-ÀÛasÎöÇI:\x1E¨Ëf"
  b"\x01Å-ÀÛbrüè#\x1A;~-Òý"
  b"\x01Å-ÀÛbrüè#\x1A;~ÿ¬â"
  b"\x01Å-ÀÛbrüè#\x1A;\x7F\â\x11"
  b"\x01Å-ÀÛcqZ®Í´?ø8├ë"
  b"\x01Å-ÀÛcqZ®Í´?øÀ÷ÿ"
  b"\x01Å-ÀÛcqZ®Í´?£\v\x17ò"
  b"\x01Å-ÀÛdqö║▒ÁV\x14£ò├"
  b"\x01Å-ÀÛdqö║▒ÁV\x14ÈÉ\t"
  b"\x01Å-ÀÛdqö║▒ÁV\x15ú¯ "
  b"\x01Å-ÀÛeq█û ljÖ■\x15Y"
  b"\x01Å-ÀÛeq█û ljÜøû\x16"
  b"\x01Å-ÀÛeq█û ljøä\e\x01"
  b"\x01Å-ÀÛfrÇëRT\tJ_@Ö"
  b"\x01Å-ÀÛgr\x0Fï8þR&\x12Ã\v"
  b"\x01Å-ÀÛgr\x0Fï8þR'\x02ÖÊ"
  b"\x01Å-ÀÛgr\x0Fï8þR'\x7F\Ë"
  b"\x01Å-ÀÛhr1Àñ\x07Å░║Ôe"
  b"\x01Å-ÀÛhr1Àñ\x07Å▒këø"
  b"\x01Å-ÀÛhr1Àñ\x07Å▓\x08Û╦"
  b"\x01Å-ÀÛirWä\e'\x00¹\rÉ+"
  b"\x01Å-ÀÛirWä\e'\x00¹Ã\x03D"
  b"\x01Å-ÀÛjpáª*─éH[\x7Fµ"
  b"\x01Å-ÀÛjpáª*─éI\x02°\x1F"
  b"\x01Å-ÀÛjpáª*─éI\r­g"
  b"\x01Å-ÀÛkqùï°¹ƒq\x18\x1FA"
  b"\x01Å-ÀÛkqùï°¹ƒq\x1Fi§"
  b"\x01Å-ÀÛlr░öy\x1CÈ║\x7F(r"
  b"\x01Å-ÀÛlr░öy\x1CÈ╗p-ñ"
  b"\x01Å-ÀÛmp=│\x15¹^ ;Ö├"
  b"\x01Å-ÀÛmp=│\x15¹^ G\rý"
  b"\x01Å-ÀÛmp=│\x15¹_\x00\x16%╩"
  b"\x01Å-ÀÛnq╔å├5Å\e\x11vb"
  b"\x01Å-ÀÛnq╔å├5Å\eÏ\x11┌"
  b"\x01Å-ÀÛorwìp»®@îïT"
  b"\x01Å-ÀÛorwìp»®@¾ƒ\x1D"
  b"\x01Å-ÀÛorwìp»®AM|Ò"
  b"\x01Å-ÀÛpr╗░Ñï╝\x1F,lÎ"
  b"\x01Å-ÀÛpr╗░Ñï╝\x1Ff\x04\x06"
  b"\x01Å-ÀÛpr╗░Ñï╝\x1FÜÌi"
  b"\x01Å-ÀÛqr|ñ¾╝\x10·9\x00Ñ"
  b"\x01Å-ÀÛqr|ñ¾╝\x10·Aèä"
  b"\x01Å-ÀÛrs¢ú®¯Q©KÈ\x04"
  b"\x01Å-ÀÛrs¢ú®¯Q©º\x15╣"
  b"\x01Å-ÀÛrs¢ú®¯Q©©Q\x1F"
  b"\x01Å-ÀÛsr{¬¬\x11'h\x17XE"
  b"\x01Å-ÀÛsr{¬¬\x11'h ´l"
  b"\x01Å-ÀÛsr{¬¬\x11'iúÅ°"
  b"\x01Å-ÀÛtpóÑ┬\r¹U\x0Fɲ"
  b"\x01Å-ÀÛtpóÑ┬\r¹U¹n\x0E"
  b"\x01Å-ÀÛtpóÑ┬\r¹V\x1E╦Ê"
  b"\x01Å-ÀÛur\vÁç┤¶Å╠Y\x0F"
  b"\x01Å-ÀÛur\vÁç┤¶É5Àê"
  b"\x01Å-ÀÛvr5¬\e`ܧ│┘!"
  b"\x01Å-ÀÛvr5¬\e`ܧҢ^"
  b"\x01Å-ÀÛvr5¬\e`Ü÷O\x11F"
  b"\x01Å-ÀÛwp\eïË└\x1Aïä\x1E▀"
  b"\x01Å-ÀÛwp\eïË└\x1Aîj╬;"
  b"\x01Å-ÀÛwp\eïË└\x1Aîïdþ"
  b"\x01Å-ÀÛxq`ú┬T#8═vi"
  b"\x01Å-ÀÛxq`ú┬T#9kEH"
  b"\x01Å-ÀÛysÞáO╝ôöiGQ"
  b"\x01Å-ÀÛysÞáO╝ôömH╬"
  b"\x01Å-ÀÛysÞáO╝ôò\x14Ìè"
  b"\x01Å-ÀÛzp¤Öúq2_ëSÒ"
  b"\x01Å-ÀÛzp¤Öúq2_ã┘["
  b"\x01Å-ÀÛzp¤Öúq2`ÿ±É"
  b"\x01Å-ÀÛ{r\x12Ü{¢░n½\x10¬"
  b"\x01Å-ÀÛ{r\x12Ü{¢░oñÝÌ"
  b"\x01Å-ÀÛ|q4í░Óß^N\x0E`"
  b"\x01Å-ÀÛ}qr▓Ø‗3╝;\x08\x13"
  b"\x01Å-ÀÛ}qr▓Ø‗3¢\x1DÍT"
  b"\x01Å-ÀÛ~s\x18╝Ký╝À"Bj"
  b"\x01Å-ÀÛ~s\x18╝Ký╝À╣4\x05"
  b"\x01Å-ÀÛ~s\x18╝Ký╝©=ÂC"
  b"\x01Å-ÀÛ\x7Fp:║FGsÒ¤èê"
  b"\x01Å-ÀÛ\x7Fp:║FGsõÇNê"
  b"\x01Å-ÀÛ\x7Fp:║FGsõ┐éÄ"
  b"\x01Å-ÀÛÇqú½@²\x1Cð.Ñ█"
  b"\x01Å-ÀÛÇqú½@²\x1CÐ+ý\x0F"
  b"\x01Å-ÀÛÇqú½@²\x1CÐÁjS"
  b"\x01Å-ÀÛüqê¬$j®}£µ}"
  b"\x01Å-ÀÛüqê¬$j®~"|Ë"
  b"\x01Å-ÀÛéss╗4'o¢\x14╗¶"
  b"\x01Å-ÀÛéss╗4'o¥\x06íÏ"
  b"\x01Å-ÀÛéss╗4'o¥Þ·º"
  b"\x01Å-ÀÛâr‗╣\x1D¹òrmN‗"
  b"\x01Å-ÀÛâr‗╣\x1D¹òrn²┌"
  b"\x01Å-ÀÛâr‗╣\x1D¹òr═\x148"
  b"\x01Å-ÀÛäp³ä╗þ7pÚû?"
  b"\x01Å-ÀÛäp³ä╗þ7q¡╝æ"
  b"\x01Å-ÀÛàrßææ\x1F\x16=?▀t"
  b"\x01Å-ÀÛàrßææ\x1F\x16=éûc"
  b"\x01Å-ÀÛàrßææ\x1F\x16>L#d"
  b"\x01Å-ÀÛåsP░Cp[¤ê6w"
  b"\x01Å-ÀÛåsP░Cp[ð\x14&æ"
  b"\x01Å-ÀÛçqQ║YLª´)pw"
  b"\x01Å-ÀÛçqQ║YLª´èBc"
  b"\x01Å-ÀÛês┴ÄDºI¼$y═"
  b"\x01Å-ÀÛês┴ÄDºI¡\x10-2"
  b"\x01Å-ÀÛês┴ÄDºI¡#è¸"
  b"""
    \x01Å-ÀÛër\£<i╣│\n
    ª╩
    """
]
View formatted query    View runnable query    Explain query    View query backtrace
1.61 ms
(8.51%) 		7 
SELECT LOWER(HEX(`script`.`app_id`)) AS `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.03 ms
(5.47%) 		7 
SELECT LOWER(HEX(`script`.`app_id`)) AS `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.81 ms
(4.32%) 		7 
# app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ?)
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(4.05%) 		1 
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.appShippingMethod`.`id` AS `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` AS `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` AS `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` AS `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` AS `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` AS `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` AS `shipping_method.appShippingMethod.updatedAt`, `shipping_method.appShippingMethod.app`.`id` AS `shipping_method.appShippingMethod.app.id`, `shipping_method.appShippingMethod.app`.`name` AS `shipping_method.appShippingMethod.app.name`, `shipping_method.appShippingMethod.app`.`path` AS `shipping_method.appShippingMethod.app.path`, `shipping_method.appShippingMethod.app`.`author` AS `shipping_method.appShippingMethod.app.author`, `shipping_method.appShippingMethod.app`.`copyright` AS `shipping_method.appShippingMethod.app.copyright`, `shipping_method.appShippingMethod.app`.`license` AS `shipping_method.appShippingMethod.app.license`, `shipping_method.appShippingMethod.app`.`active` AS `shipping_method.appShippingMethod.app.active`, `shipping_method.appShippingMethod.app`.`configurable` AS `shipping_method.appShippingMethod.app.configurable`, `shipping_method.appShippingMethod.app`.`privacy` AS `shipping_method.appShippingMethod.app.privacy`, `shipping_method.appShippingMethod.app`.`version` AS `shipping_method.appShippingMethod.app.version`, `shipping_method.appShippingMethod.app`.`icon` AS `shipping_method.appShippingMethod.app.iconRaw`, `shipping_method.appShippingMethod.app`.`app_secret` AS `shipping_method.appShippingMethod.app.appSecret`, `shipping_method.appShippingMethod.app`.`modules` AS `shipping_method.appShippingMethod.app.modules`, `shipping_method.appShippingMethod.app`.`main_module` AS `shipping_method.appShippingMethod.app.mainModule`, `shipping_method.appShippingMethod.app`.`cookies` AS `shipping_method.appShippingMethod.app.cookies`, `shipping_method.appShippingMethod.app`.`allow_disable` AS `shipping_method.appShippingMethod.app.allowDisable`, `shipping_method.appShippingMethod.app`.`base_app_url` AS `shipping_method.appShippingMethod.app.baseAppUrl`, `shipping_method.appShippingMethod.app`.`allowed_hosts` AS `shipping_method.appShippingMethod.app.allowedHosts`, `shipping_method.appShippingMethod.app`.`template_load_priority` AS `shipping_method.appShippingMethod.app.templateLoadPriority`, `shipping_method.appShippingMethod.app`.`checkout_gateway_url` AS `shipping_method.appShippingMethod.app.checkoutGatewayUrl`, `shipping_method.appShippingMethod.app`.`integration_id` AS `shipping_method.appShippingMethod.app.integrationId`, `shipping_method.appShippingMethod.app.integration`.`id` AS `shipping_method.appShippingMethod.app.integration.id`, `shipping_method.appShippingMethod.app.integration`.`label` AS `shipping_method.appShippingMethod.app.integration.label`, `shipping_method.appShippingMethod.app.integration`.`access_key` AS `shipping_method.appShippingMethod.app.integration.accessKey`, `shipping_method.appShippingMethod.app.integration`.`secret_access_key` AS `shipping_method.appShippingMethod.app.integration.secretAccessKey`, `shipping_method.appShippingMethod.app.integration`.`last_usage_at` AS `shipping_method.appShippingMethod.app.integration.lastUsageAt`, `shipping_method.appShippingMethod.app.integration`.`admin` AS `shipping_method.appShippingMethod.app.integration.admin`, `shipping_method.appShippingMethod.app.integration`.`custom_fields` AS `shipping_method.appShippingMethod.app.integration.customFields`, `shipping_method.appShippingMethod.app.integration`.`deleted_at` AS `shipping_method.appShippingMethod.app.integration.deletedAt`, `shipping_method.appShippingMethod.app.integration`.`created_at` AS `shipping_method.appShippingMethod.app.integration.createdAt`, `shipping_method.appShippingMethod.app.integration`.`updated_at` AS `shipping_method.appShippingMethod.app.integration.updatedAt`, `shipping_method.appShippingMethod.app`.`acl_role_id` AS `shipping_method.appShippingMethod.app.aclRoleId`, `shipping_method.appShippingMethod.app.aclRole`.`id` AS `shipping_method.appShippingMethod.app.aclRole.id`, `shipping_method.appShippingMethod.app.aclRole`.`name` AS `shipping_method.appShippingMethod.app.aclRole.name`, `shipping_method.appShippingMethod.app.aclRole`.`description` AS `shipping_method.appShippingMethod.app.aclRole.description`, `shipping_method.appShippingMethod.app.aclRole`.`privileges` AS `shipping_method.appShippingMethod.app.aclRole.privileges`, `shipping_method.appShippingMethod.app.aclRole`.`deleted_at` AS `shipping_method.appShippingMethod.app.aclRole.deletedAt`, `shipping_method.appShippingMethod.app.aclRole`.`created_at` AS `shipping_method.appShippingMethod.app.aclRole.createdAt`, `shipping_method.appShippingMethod.app.aclRole`.`updated_at` AS `shipping_method.appShippingMethod.app.aclRole.updatedAt`, `shipping_method.appShippingMethod.app`.`created_at` AS `shipping_method.appShippingMethod.app.createdAt`, `shipping_method.appShippingMethod.app`.`updated_at` AS `shipping_method.appShippingMethod.app.updatedAt`, `shipping_method.appShippingMethod.app.translation.label`, COALESCE(`shipping_method.appShippingMethod.app.translation.label`,`shipping_method.appShippingMethod.app.translation.label`) AS `shipping_method.appShippingMethod.app.label`, `shipping_method.appShippingMethod.app.translation.description`, COALESCE(`shipping_method.appShippingMethod.app.translation.description`,`shipping_method.appShippingMethod.app.translation.description`) AS `shipping_method.appShippingMethod.app.description`, `shipping_method.appShippingMethod.app.translation.privacyPolicyExtensions`, COALESCE(`shipping_method.appShippingMethod.app.translation.privacyPolicyExtensions`,`shipping_method.appShippingMethod.app.translation.privacyPolicyExtensions`) AS `shipping_method.appShippingMethod.app.privacyPolicyExtensions`, `shipping_method.appShippingMethod.app.translation.customFields`, COALESCE(`shipping_method.appShippingMethod.app.translation.customFields`,`shipping_method.appShippingMethod.app.translation.customFields`) AS `shipping_method.appShippingMethod.app.customFields`, `shipping_method.appShippingMethod.app.translation.createdAt`, `shipping_method.appShippingMethod.app.translation.updatedAt`, `shipping_method.appShippingMethod.app.translation.appId`, `shipping_method.appShippingMethod.app.translation.languageId`, `shipping_method`.`technical_name` AS `shipping_method.technicalName`, `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`.`config` AS `shipping_method.media.config`, `shipping_method.media`.`path` AS `shipping_method.media.path`, `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 `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_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 `app` `shipping_method.appShippingMethod.app` ON `shipping_method.appShippingMethod`.`app_id` = `shipping_method.appShippingMethod.app`.`id` LEFT JOIN (SELECT `shipping_method.appShippingMethod.app.translation`.app_id, `shipping_method.appShippingMethod.app.translation`.label AS `shipping_method.appShippingMethod.app.translation.label`, `shipping_method.appShippingMethod.app.translation`.description AS `shipping_method.appShippingMethod.app.translation.description`, `shipping_method.appShippingMethod.app.translation`.privacy_policy_extensions AS `shipping_method.appShippingMethod.app.translation.privacyPolicyExtensions`, `shipping_method.appShippingMethod.app.translation`.custom_fields AS `shipping_method.appShippingMethod.app.translation.customFields`, `shipping_method.appShippingMethod.app.translation`.created_at AS `shipping_method.appShippingMethod.app.translation.createdAt`, `shipping_method.appShippingMethod.app.translation`.updated_at AS `shipping_method.appShippingMethod.app.translation.updatedAt`, `shipping_method.appShippingMethod.app.translation`.app_id AS `shipping_method.appShippingMethod.app.translation.appId`, `shipping_method.appShippingMethod.app.translation`.language_id AS `shipping_method.appShippingMethod.app.translation.languageId` FROM `app_translation` `shipping_method.appShippingMethod.app.translation` WHERE `shipping_method.appShippingMethod.app.translation`.language_id = ?) `shipping_method.appShippingMethod.app.app_translation` ON `shipping_method.appShippingMethod.app.app_translation`.`app_id` = `shipping_method.appShippingMethod.app`.`id` LEFT JOIN `integration` `shipping_method.appShippingMethod.app.integration` ON `shipping_method.appShippingMethod.app`.`integration_id` = `shipping_method.appShippingMethod.app.integration`.`id` LEFT JOIN `acl_role` `shipping_method.appShippingMethod.app.aclRole` ON `shipping_method.appShippingMethod.app`.`acl_role_id` = `shipping_method.appShippingMethod.app.aclRole`.`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"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01Å-À▀ºr÷ÑÚ└T7æa""
  b"\x01Å-À▀ºr÷ÑÚ└T7\x1AÍm"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(3.69%) 		1 
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`.`recurring_url` AS `payment_method.appPaymentMethod.recurringUrl`, `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.appPaymentMethod.app`.`id` AS `payment_method.appPaymentMethod.app.id`, `payment_method.appPaymentMethod.app`.`name` AS `payment_method.appPaymentMethod.app.name`, `payment_method.appPaymentMethod.app`.`path` AS `payment_method.appPaymentMethod.app.path`, `payment_method.appPaymentMethod.app`.`author` AS `payment_method.appPaymentMethod.app.author`, `payment_method.appPaymentMethod.app`.`copyright` AS `payment_method.appPaymentMethod.app.copyright`, `payment_method.appPaymentMethod.app`.`license` AS `payment_method.appPaymentMethod.app.license`, `payment_method.appPaymentMethod.app`.`active` AS `payment_method.appPaymentMethod.app.active`, `payment_method.appPaymentMethod.app`.`configurable` AS `payment_method.appPaymentMethod.app.configurable`, `payment_method.appPaymentMethod.app`.`privacy` AS `payment_method.appPaymentMethod.app.privacy`, `payment_method.appPaymentMethod.app`.`version` AS `payment_method.appPaymentMethod.app.version`, `payment_method.appPaymentMethod.app`.`icon` AS `payment_method.appPaymentMethod.app.iconRaw`, `payment_method.appPaymentMethod.app`.`app_secret` AS `payment_method.appPaymentMethod.app.appSecret`, `payment_method.appPaymentMethod.app`.`modules` AS `payment_method.appPaymentMethod.app.modules`, `payment_method.appPaymentMethod.app`.`main_module` AS `payment_method.appPaymentMethod.app.mainModule`, `payment_method.appPaymentMethod.app`.`cookies` AS `payment_method.appPaymentMethod.app.cookies`, `payment_method.appPaymentMethod.app`.`allow_disable` AS `payment_method.appPaymentMethod.app.allowDisable`, `payment_method.appPaymentMethod.app`.`base_app_url` AS `payment_method.appPaymentMethod.app.baseAppUrl`, `payment_method.appPaymentMethod.app`.`allowed_hosts` AS `payment_method.appPaymentMethod.app.allowedHosts`, `payment_method.appPaymentMethod.app`.`template_load_priority` AS `payment_method.appPaymentMethod.app.templateLoadPriority`, `payment_method.appPaymentMethod.app`.`checkout_gateway_url` AS `payment_method.appPaymentMethod.app.checkoutGatewayUrl`, `payment_method.appPaymentMethod.app`.`integration_id` AS `payment_method.appPaymentMethod.app.integrationId`, `payment_method.appPaymentMethod.app.integration`.`id` AS `payment_method.appPaymentMethod.app.integration.id`, `payment_method.appPaymentMethod.app.integration`.`label` AS `payment_method.appPaymentMethod.app.integration.label`, `payment_method.appPaymentMethod.app.integration`.`access_key` AS `payment_method.appPaymentMethod.app.integration.accessKey`, `payment_method.appPaymentMethod.app.integration`.`secret_access_key` AS `payment_method.appPaymentMethod.app.integration.secretAccessKey`, `payment_method.appPaymentMethod.app.integration`.`last_usage_at` AS `payment_method.appPaymentMethod.app.integration.lastUsageAt`, `payment_method.appPaymentMethod.app.integration`.`admin` AS `payment_method.appPaymentMethod.app.integration.admin`, `payment_method.appPaymentMethod.app.integration`.`custom_fields` AS `payment_method.appPaymentMethod.app.integration.customFields`, `payment_method.appPaymentMethod.app.integration`.`deleted_at` AS `payment_method.appPaymentMethod.app.integration.deletedAt`, `payment_method.appPaymentMethod.app.integration`.`created_at` AS `payment_method.appPaymentMethod.app.integration.createdAt`, `payment_method.appPaymentMethod.app.integration`.`updated_at` AS `payment_method.appPaymentMethod.app.integration.updatedAt`, `payment_method.appPaymentMethod.app`.`acl_role_id` AS `payment_method.appPaymentMethod.app.aclRoleId`, `payment_method.appPaymentMethod.app.aclRole`.`id` AS `payment_method.appPaymentMethod.app.aclRole.id`, `payment_method.appPaymentMethod.app.aclRole`.`name` AS `payment_method.appPaymentMethod.app.aclRole.name`, `payment_method.appPaymentMethod.app.aclRole`.`description` AS `payment_method.appPaymentMethod.app.aclRole.description`, `payment_method.appPaymentMethod.app.aclRole`.`privileges` AS `payment_method.appPaymentMethod.app.aclRole.privileges`, `payment_method.appPaymentMethod.app.aclRole`.`deleted_at` AS `payment_method.appPaymentMethod.app.aclRole.deletedAt`, `payment_method.appPaymentMethod.app.aclRole`.`created_at` AS `payment_method.appPaymentMethod.app.aclRole.createdAt`, `payment_method.appPaymentMethod.app.aclRole`.`updated_at` AS `payment_method.appPaymentMethod.app.aclRole.updatedAt`, `payment_method.appPaymentMethod.app`.`created_at` AS `payment_method.appPaymentMethod.app.createdAt`, `payment_method.appPaymentMethod.app`.`updated_at` AS `payment_method.appPaymentMethod.app.updatedAt`, `payment_method.appPaymentMethod.app.translation.label`, COALESCE(`payment_method.appPaymentMethod.app.translation.label`,`payment_method.appPaymentMethod.app.translation.label`) AS `payment_method.appPaymentMethod.app.label`, `payment_method.appPaymentMethod.app.translation.description`, COALESCE(`payment_method.appPaymentMethod.app.translation.description`,`payment_method.appPaymentMethod.app.translation.description`) AS `payment_method.appPaymentMethod.app.description`, `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`, COALESCE(`payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`,`payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`) AS `payment_method.appPaymentMethod.app.privacyPolicyExtensions`, `payment_method.appPaymentMethod.app.translation.customFields`, COALESCE(`payment_method.appPaymentMethod.app.translation.customFields`,`payment_method.appPaymentMethod.app.translation.customFields`) AS `payment_method.appPaymentMethod.app.customFields`, `payment_method.appPaymentMethod.app.translation.createdAt`, `payment_method.appPaymentMethod.app.translation.updatedAt`, `payment_method.appPaymentMethod.app.translation.appId`, `payment_method.appPaymentMethod.app.translation.languageId`, `payment_method`.`technical_name` AS `payment_method.technicalName`, `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`.`config` AS `payment_method.media.config`, `payment_method.media`.`path` AS `payment_method.media.path`, `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 `app` `payment_method.appPaymentMethod.app` ON `payment_method.appPaymentMethod`.`app_id` = `payment_method.appPaymentMethod.app`.`id` LEFT JOIN (SELECT `payment_method.appPaymentMethod.app.translation`.app_id, `payment_method.appPaymentMethod.app.translation`.label AS `payment_method.appPaymentMethod.app.translation.label`, `payment_method.appPaymentMethod.app.translation`.description AS `payment_method.appPaymentMethod.app.translation.description`, `payment_method.appPaymentMethod.app.translation`.privacy_policy_extensions AS `payment_method.appPaymentMethod.app.translation.privacyPolicyExtensions`, `payment_method.appPaymentMethod.app.translation`.custom_fields AS `payment_method.appPaymentMethod.app.translation.customFields`, `payment_method.appPaymentMethod.app.translation`.created_at AS `payment_method.appPaymentMethod.app.translation.createdAt`, `payment_method.appPaymentMethod.app.translation`.updated_at AS `payment_method.appPaymentMethod.app.translation.updatedAt`, `payment_method.appPaymentMethod.app.translation`.app_id AS `payment_method.appPaymentMethod.app.translation.appId`, `payment_method.appPaymentMethod.app.translation`.language_id AS `payment_method.appPaymentMethod.app.translation.languageId` FROM `app_translation` `payment_method.appPaymentMethod.app.translation` WHERE `payment_method.appPaymentMethod.app.translation`.language_id = ?) `payment_method.appPaymentMethod.app.app_translation` ON `payment_method.appPaymentMethod.app.app_translation`.`app_id` = `payment_method.appPaymentMethod.app`.`id` LEFT JOIN `integration` `payment_method.appPaymentMethod.app.integration` ON `payment_method.appPaymentMethod.app`.`integration_id` = `payment_method.appPaymentMethod.app.integration`.`id` LEFT JOIN `acl_role` `payment_method.appPaymentMethod.app.aclRole` ON `payment_method.appPaymentMethod.app`.`acl_role_id` = `payment_method.appPaymentMethod.app.aclRole`.`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"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01Å-À▀ñp┌á&\sÛe1("
  b"\x01Å-À▀ñp┌á&\sÛÑ_ "
  b"\x01Å-À▀ñp┌á&\sÛ\x194Y"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(3.06%) 		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.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters: 
[
  true
  b"\x01Å-©\x14æq█¬À´Âu8¼á"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(1.89%) 		1 
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"\x01Å-©\x14æq█¬À´Âu8¼á"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(1.82%) 		1 
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"\x01Å-©\x14æq█¬À´Âu8¼á"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(1.79%) 		1 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name AS composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(1.64%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x01Å-©\x14æq█¬À´Âu8¼á"
  "neGd5ALBIOKRczmt8gDLg9eVODoAeK7T"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(1.55%) 		1 
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`.`checkout_gateway_url` AS `app.checkoutGatewayUrl`, `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`.`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` = ? AND NOT (`app`.`checkout_gateway_url` <=> ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(1.45%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01Å-©\x14æq█¬À´Âu8¼á"
  "checkout/cart"
  "checkout/cart/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(1.26%) 		1 
SELECT `rule`.`id` AS `rule.id`, `rule`.`name` AS `rule.name`, `rule`.`priority` AS `rule.priority`, `rule`.`description` AS `rule.description`, `rule`.`payload` AS `rule.payload`, `rule`.`invalid` AS `rule.invalid`, `rule`.`areas` AS `rule.areas`, `rule`.`custom_fields` AS `rule.customFields`, `rule`.`module_types` AS `rule.moduleTypes`, `rule`.`created_at` AS `rule.createdAt`, `rule`.`updated_at` AS `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?)
Parameters: 
[
  b"\x01Å-À▀íp(ܳ'\x08├+©Ü"
  b"\x01Å-À▀ºr÷ÑÚ└T7ý╦["
  b"\x01Å-Àþór_║╚Q┼á#┘5"
  b"\x01Å-À▀Às_▒ÀõªÅäFF"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.92%) 		1 
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.87%) 		1 
# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01Å-©\x14æq█¬À´Âu8¼á"
  "/checkout/cart"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.80%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.68%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.67%) 		1 
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters: 
[
  b"\x01Å-©\x14æq█¬À´Âu8¼á"
  b"\x01Å-À▀Qq▀ç┌╗¶G7÷Ð"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.58%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.57%) 		1 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.