GET https://staging.luminairestotal.fr/detail/b83a5570288a4cd79a12761adf999095

Response
200 OK
Browse referrer URL
IP
216.73.216.50
Profiled on
Token
e634e3

Query Metrics

34 Database Queries
25 Different statements
17.54 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
8.69 ms
(49.57%) 		1 
SELECT `lampentotaal_redirect`.`id` FROM `lampentotaal_redirect` WHERE (`lampentotaal_redirect`.`url` = ?) LIMIT 1
Parameters: 
[
  "https://staging.luminairestotal.fr/6-meter-1200-led-warm-white-no-pole-94155"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.06 ms
(11.76%) 		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: 
[
  "/detail/b83a5570288a4cd79a12761adf999095"
  "/profitmetrics/tracking"
  "/navigation/019ae8aa7d107d6389bc43b910c9bec5"
  "/navigation/420cb4063ad779862fa41f0a19417e4c"
  "/navigation/a769c7b3c35acdf17ff9b9ba7d57de3e"
  "/navigation/b16ceb266f8498138c41fd6bde9d51b4"
  "/navigation/9e984c108157cea74c894b5cf34efc44"
  "/navigation/f0dd4a99fba6075a9494772b58f95280"
  "/navigation/7c4473df6a4b4b63a3e1302d94616c97"
  "/navigation/cfa5301358b9fcbe7aa45b1ceea088c6"
  "/navigation/01e00f2f4bfcbb7505cb641066f2859b"
  "/navigation/f39ae9ff3a81f499230c4126e01f421b"
  "/navigation/9fdb62f932adf55af2c0e09e55861964"
  "/navigation/08f90c1a417155361a5c4b8d297e0d78"
  "/navigation/e93028bdc1aacdfb3687181f2031765d"
  "/navigation/f899139df5e1059396431415e770c6dd"
  "/navigation/5f93f983524def3dca464469d2cf9f3e"
  "/navigation/da4fb5c6e93e74d3df8527599fa62642"
  "/navigation/9b8619251a19057cff70779273e95aa6"
  "/navigation/1385974ed5904a438616ff7bdb3f7439"
  "/navigation/7ef605fc8dba5425d6965fbd4c8fbe1f"
  "/navigation/b73ce398c39f506af761d2277d853a92"
  "/navigation/149e9677a5989fd342ae44213df68868"
  "/navigation/3644a684f98ea8fe223c713b77189a77"
  "/navigation/019a39e23b2c7e279df87b0aa358ad91"
  "/navigation/56ef1f00cd5845fda57aa9872909c4ff"
  "/navigation/1bb780577fd64cf48e5120d0293c0b39"
  "/navigation/61cdd800001945958264ef4e5bc92679"
  "/navigation/bf37ceadd2f94d8cbb87de0250bbc9b8"
  "/navigation/94f6d7e04a4d452035300f18b984988c"
  "/navigation/06eb61b839a0cefee4967c67ccb099dc"
  "/navigation/320722549d1751cf3f247855f937b982"
  "/navigation/fe73f687e5bc5280214e0486b273a5f9"
  "/navigation/40008b9a5380fcacce3976bf7c08af5b"
  "/navigation/9de6d14fff9806d4bcd1ef555be766cd"
  "/navigation/e7b24b112a44fdd9ee93bdf998c6ca0e"
  "/navigation/d709f38ef758b5066ef31b18039b8ce5"
  "/navigation/1068c6e4c8051cfd4e9ea8072e3189e2"
  "/navigation/648c1037b2d94f67804668f6aa8fbc82"
  "/navigation/1e046b60fd2b4aa5a77ff8364a68c911"
  "/navigation/138838f8557c45ffb6970faf8543cabd"
  "/navigation/7169563d15ea44e7a67ebaa5f0a753d9"
  "/navigation/0190c01862bb7299a889e9122eaa5380"
  "/navigation/0190c01932e570bb933cc02b6327917f"
  "/navigation/0190c01a8ed27f47af7fa5c7682025de"
  "/navigation/0190c01ab0837469855dba83f91e75fc"
  "/navigation/0190c01aca5476e9bdfa37166f759232"
  "/navigation/0190c01adf7e729e843b0f7996a1688f"
  "/navigation/bcd3d2d0d08644f3bbf3956df55cbe6e"
  "/navigation/d7a84628c025d30f7b2c52c958767e76"
  "/navigation/7b7a53e239400a13bd6be6c91c4f6c4e"
  "/navigation/2d579dc29360d8bbfbb4aa541de5afa9"
  "/navigation/4c144c47ecba6f8318128703ca9e2601"
  "/navigation/d490d7b4576290fa60eb31b5fc917ad1"
  "/navigation/00ac8ed3b4327bdd4ebbebcb2ba10a00"
  "/navigation/0166adc792b8409e857a3c7360748e09"
  "/navigation/b73dfe25b4b8714c029b37a6ad3006fa"
  "/navigation/9cc138f8dc04cbf16240daa92d8d50e2"
  "/navigation/c442481e2e1f425996cf42770aa4a825"
  "/navigation/1873d66284734bcc867233da154ef29e"
  "/navigation/004000429675402385039e805f5ababf"
  "/navigation/e5841df2166dd424a57127423d276bbe"
  "/navigation/e70611883d2760c8bbafb4acb29e3446"
  "/navigation/5f2c22cb4a5380af7ca75622a6426917"
  "/navigation/d5cfead94f5350c12c322b5b664544c1"
  "/navigation/edfbe1afcf9246bb0d40eb4d8027d90f"
  "/navigation/b137fdd1f79d56c7edf3365fea7520f2"
  "/navigation/7a53928fa4dd31e82c6ef826f341daec"
  "/navigation/ddd5a9cb033f455ca4bdde8c11ff1872"
  "/navigation/1607c31dcf504bdd80c025b15bb8b9c4"
  "/navigation/b6edc1cd1f36e45daf6d7824d7bb2283"
  "/navigation/e2a2dcc36a08a345332c751b2f2e476c"
  "/navigation/ce52eccc353c43abb9e30d62ff7e37b0"
  "/navigation/8e82ab7243b7c66d768f1b8ce1c967eb"
  "/navigation/e205ee2a5de471a70c1fd1b46033a75f"
  "/navigation/d40b2194b7fd4c36837b8f415577be66"
  "/navigation/7188fdfa6d364b28a2ab5e7bf1f3e155"
  "/navigation/be98ddd1fa4f45649c7fc73fb9bce4e4"
  "/navigation/4a8dcdb9a24349708162cec124ddaa93"
  "/navigation/e1d4d8cc81f44afc97b763e61f195db6"
  "/navigation/09cfb08891114e58aabe6578cdd41c18"
  "/navigation/a9b7ba70783b617e9998dc4dd82eb3c5"
  "/navigation/1e6e0a04d20f50967c64dac2d639a577"
  "/navigation/fe2d010308a6b3799a3d9c728ee74244"
  "/navigation/6f3e29a35278d71c7f65495871231324"
  "/navigation/535ab76633d94208236a2e829ea6d888"
  "/navigation/2a50e9c2d6b89b95bcb416d6857f8b45"
  "/navigation/be3dc9680c364d9695c3b568d5e23cab"
  "/navigation/ea3b4f8c7a1e4551b9c86e611dec3762"
  "/navigation/a14ac55a4f27472c5d894ec1c3c743d2"
  "/navigation/806beafe154032a5b818e97b4420ad98"
  "/navigation/46031b3d04dc90994ca317a7c55c4289"
  "/navigation/b41c65cb92e04ba8804ee5710c6fa232"
  "/navigation/84f0f20482cde7e5eacaf7364a643d33"
  "/navigation/b283883b00d743bb98262300fe11c609"
  "/navigation/ffb8f1cc58344d7186bfbf84b3f2e018"
  "/navigation/239bd1c81ec54a6ab05acfabf14fb3da"
  "/navigation/973a5f0ccbc4ee3524ccf035d35b284b"
  "/navigation/9a4400501febb2a95e79248486a5f6d3"
  "/navigation/148510031349642de5ca0c544f31b2ef"
  "/navigation/11d0e6287202fced83f79975ec59a3a6"
  "/navigation/7e7990ca35db471fbfbc38289659efef"
  "/navigation/075ced4801ba4ca993add836425377b9"
  "/navigation/17c5a52d44664a88be7a9c59165fefd3"
  "/navigation/5a142a55461d5fef016acfb927fee0bd"
  "/navigation/feb419e961034f89b10fb89874a5314d"
  "/navigation/1c74e423bff24bef8325750876b38796"
  "/navigation/a456700357c7491ba92c3ec7fb84d0d0"
  "/navigation/8511c99cb1e64db88aca07fc8509e4a3"
  "/navigation/f7f5c9bbef224a52bedbf88e96c2af96"
  "/navigation/3dc465dbdebc42b1a74fd5cd065408c2"
  "/navigation/c0c5c9de5ba240859db6ebf0bb390db9"
  "/navigation/f8a51e51de3a4588aa9e86e09d434cc4"
  "/navigation/99731f952989409bb1695b6bfedab6de"
  "/navigation/6e766b48c86445819fddbceb0cafb9e8"
  "/navigation/eda91523e3d942fb96e7bd86d541d147"
  "/navigation/ed9a6f3394504cc299326333a4da153a"
  "/navigation/7a2cf6e0963b477192bf9b7ffdb74ec5"
  "/navigation/0cf49822a98149259ed7b28275578573"
  "/navigation/6e79ed05baec2754e25b4eac73a332d2"
  "/navigation/f67d3f9e3aa445359d02fef446aad91b"
  "/navigation/f5511f99187541cfa4605f549b777e60"
  "/navigation/1f2e9a5f85294c51affdcc0f5ab97193"
  "/navigation/f2d887e01a80e813d9080038decbbabb"
  "/navigation/39bfda3ee6a64c7191996bb3f6fdda71"
  "/navigation/069654d5ce089c13f642d19f09a3d1c0"
  "/navigation/5d6c744218214b879c4850af4e9a5ec3"
  "/navigation/bb955ecb8ed44c888326d2ed398b641c"
  "/navigation/08302b9965df47d0b656bc43ccf131fa"
  "/navigation/bb7c05da0905452a9e2f6ac0551c41c0"
  "/navigation/1389eba422784335a65458ba009b44f1"
  "/navigation/403943f831664b7e98bb6d986d5e4b9b"
  "/navigation/0dd727dc1afc4540af56a59f101ea73f"
  "/navigation/465d49e638984793a991b97e79d8c33c"
  "/navigation/3ff9b23b7cd14c74ac8b5b02642f9fd3"
  "/navigation/ebd3023a82954114aa7d0ad7d25e889a"
  "/navigation/2adf844de4824675909453eb79a92b40"
  "/navigation/201d7288b4c18a679e48b31c72c30ded"
  "/navigation/c18873da94ed476e927b67ab7cac2921"
  "/navigation/31cb96f0a0b74901910d569fba1b919d"
  "/navigation/f718e94a87c14754b13b5acdb9c3e976"
  "/navigation/0a372253f62f44e0a0b0089455c7eb0b"
  "/navigation/bb6a026bba4944e2b6f18e4cfb545ca1"
  "/navigation/c3a77154db6b454bb2158adef1e37284"
  "/navigation/8c3039bd5842dca3d944faab91447818"
  "/navigation/6e183c98f4b94b7bb757c4cfe83cfc57"
  "/navigation/be7508c3915040f9a23437c44f1e47d4"
  "/navigation/b2f13392a0f14fa990f2959e7787145d"
  "/navigation/83058d4650354d8c8b5df771f824dfd0"
  "/navigation/964e6c4b27aa475ba4c1e0bb1abdceac"
  "/navigation/4d79e8fd0ab84fe0af8a9a5ff2f6daf7"
  "/navigation/96c5c28becf18e71190460a9955aa4d8"
  "/navigation/5e54342bb2c0410fbda18d1ba49c88be"
  "/navigation/31e0fbae548b463bb8547f273cfc9682"
  "/navigation/5045ab551c324123a31922707e2cc40a"
  "/navigation/9ac96369cfe745288f69a12e72269560"
  "/navigation/d305281faf947ca7acade9ad5c8c818c"
  "/navigation/2712c35c698c4a9b94c24a0843001dbd"
  "/navigation/3214a6d842cc69597f9edf26df552e43"
  "/navigation/b18749c5368e45479e84912f878560a6"
  "/navigation/daa7e0b91aa045cab881151b359a384c"
  "/navigation/96edcd649c6d400991ef1ae5b4c70ec6"
  "/navigation/a4847544df7a4a829d40fed80999a56d"
  "/navigation/ab7314887865c4265e896c6e209d1cd6"
  "/navigation/8f2848b2c5fd4e8a95a5f229245e5cb3"
  "/navigation/39b9ff833d684ee8a6b756780aed09a4"
  "/navigation/0a892543332e4883af1115e70ec4045c"
  "/navigation/5d0aa65b5e584e2aa2a0f82166c92b07"
  "/navigation/acd1b4d8a29c462ca699691be95c659e"
  "/navigation/fb041c536f8e4314aa4327a237c4d4ba"
  "/navigation/f1258e5e4b3b475388ce66f69f0d77b5"
  "/navigation/c3538b8ea6b240749a03d3c3308a6b0d"
  "/navigation/e07aa19942cb409f9328c170bab267bb"
  "/navigation/d97da247278b4af18a3cbcef5601f2e6"
  "/navigation/dcbb92ec76bd4210bfd410c8035e3898"
  "/navigation/d1ee81ae803343da86029e3beabcab4a"
  "/navigation/47b378fa926e4ce8959f89a541c31fdf"
  "/navigation/b883b2998c8243c9bbf0150bbe0faef6"
  "/navigation/94483519a46f4633aea3bd491c983eba"
  "/navigation/7542fa00c7e94499b3f878bb777feb8b"
  "/navigation/b546a5413bbf41cc8c878066570a4ad1"
  "/navigation/0b0909e1afbc473a87adc27cf82e8018"
  "/navigation/0a715e89c33f408b80fe5097dac0c7a5"
  "/navigation/877a7db01e8b43dc8ed38525c1d36707"
  "/navigation/30d0de7539cc447ab1347f65ed6fa4ad"
  "/navigation/a2877fcaaa93440e806c6305276f999a"
  "/navigation/8e0ccdda4cbd46dc867fd9c527837bcf"
  "/navigation/e4cbadf51e1a4f689a125dc29954b1f2"
  "/navigation/7169bab79fc04284b63f2a40c33f178b"
  "/navigation/3238968d8de0447b80b2344d4da249fd"
  "/navigation/49ec46f0ce4e4a3e8fd00dfb1677dd61"
  "/navigation/71077ab180704f27bd70247b9afe9b7c"
  "/navigation/7c14c249c04648819671cdf81402edbc"
  "/navigation/0f99a0c1f6974e4f9e962868ccd4fe1b"
  "/navigation/802bd3bc61c742d4bf142e4819ee555c"
  "/navigation/2118052c17a746f092aa8080acfe4ca5"
  "/navigation/ae14e3d38c804ea1877a71f0c2eb6a1a"
  "/navigation/1ac2cef811d24cc5823270343d7af512"
  "/navigation/9fc923cb9eb146d19115c452c07a136e"
  "/navigation/fa631caa27e449d79f7ffc6fbd5dc8e3"
  "/navigation/70dba2be898442058136afadf34fe415"
  "/navigation/9136720bbb9d49fca3e714f5ccce4c08"
  "/navigation/36b5d2ebd8324a8eaeed9d8dac286476"
  "/navigation/0190c019c8fe7a6cb2c4be556537603a"
  "/navigation/b291fd64e1cb4a84a44312442e86f86e"
  "/navigation/019817aa43ef72ad8c9faafff3bf1109"
  "/navigation/4c5a6d1ef448483cb37e7938bf05196d"
  "/navigation/9e01faf4a6d3406cadd9b576a84f4c06"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.34 ms
(7.65%) 		1 
SELECT `product`.`id` AS `product.id`, `product`.`version_id` AS `product.versionId`, `product`.`parent_id` AS `product.parentId`, `product`.`parent_version_id` AS `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) AS `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) AS `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) AS `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) AS `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) AS `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) AS `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) AS `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) AS `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) AS `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) AS `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) AS `product.cmsPageVersionId`, `product.parent`.`price` AS `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) AS `product.price`, `product`.`product_number` AS `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) AS `product.restockTime`, `product`.`auto_increment` AS `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) AS `product.active`, `product`.`available` AS `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) AS `product.isCloseout`, `product`.`display_group` AS `product.displayGroup`, `product.parent`.`variant_listing_config` AS `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) AS `product.variantListingConfig`, `product`.`variant_restrictions` AS `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) AS `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) AS `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) AS `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) AS `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) AS `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) AS `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) AS `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) AS `product.shippingFree`, `product.parent`.`purchase_prices` AS `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) AS `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) AS `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) AS `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) AS `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) AS `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) AS `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) AS `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) AS `product.ratingAverage`, `product.parent`.`category_tree` AS `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) AS `product.categoryTree`, `product.parent`.`property_ids` AS `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) AS `product.propertyIds`, `product.parent`.`option_ids` AS `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) AS `product.optionIds`, `product.parent`.`stream_ids` AS `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) AS `product.streamIds`, `product.parent`.`tag_ids` AS `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) AS `product.tagIds`, `product.parent`.`category_ids` AS `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) AS `product.categoryIds`, `product`.`child_count` AS `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) AS `product.customFieldSetSelectionActive`, `product`.`sales` AS `product.sales`, `product`.`states` AS `product.states`, `product.tax`.`id` AS `product.tax.id`, `product.tax`.`tax_rate` AS `product.tax.taxRate`, `product.tax`.`name` AS `product.tax.name`, `product.tax`.`position` AS `product.tax.position`, `product.tax`.`custom_fields` AS `product.tax.customFields`, `product.tax`.`created_at` AS `product.tax.createdAt`, `product.tax`.`updated_at` AS `product.tax.updatedAt`, `product`.`available_stock` AS `product.availableStock`, `product`.`stock` AS `product.stock`, `product`.`created_at` AS `product.createdAt`, `product`.`updated_at` AS `product.updatedAt`, `product.manufacturer`.`id` AS `product.manufacturer.id`, `product.manufacturer`.`version_id` AS `product.manufacturer.versionId`, `product.manufacturer`.`media_id` AS `product.manufacturer.mediaId`, `product.manufacturer`.`link` AS `product.manufacturer.link`, `product.manufacturer`.`created_at` AS `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` AS `product.manufacturer.updatedAt`, `product.manufacturer.translation.fallback_1.name`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.fallback_1.name`,`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) AS `product.manufacturer.name`, `product.manufacturer.translation.fallback_1.description`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.fallback_1.description`,`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) AS `product.manufacturer.description`, `product.manufacturer.translation.fallback_1.customFields`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.fallback_1.customFields`,`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) AS `product.manufacturer.customFields`, `product.manufacturer.translation.fallback_1.createdAt`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.fallback_1.updatedAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.fallback_1.productManufacturerId`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.fallback_1.languageId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.fallback_1.productManufacturerVersionId`, `product.manufacturer.translation.productManufacturerVersionId`, `product.translation.fallback_1.metaDescription`, `product.parent.translation.fallback_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.fallback_1.metaDescription`,`product.parent.translation.fallback_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) AS `product.metaDescription`, `product.translation.fallback_1.name`, `product.parent.translation.fallback_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.fallback_1.name`,`product.parent.translation.fallback_1.name`,`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) AS `product.name`, `product.translation.fallback_1.keywords`, `product.parent.translation.fallback_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.fallback_1.keywords`,`product.parent.translation.fallback_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) AS `product.keywords`, `product.translation.fallback_1.description`, `product.parent.translation.fallback_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.fallback_1.description`,`product.parent.translation.fallback_1.description`,`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) AS `product.description`, `product.translation.fallback_1.metaTitle`, `product.parent.translation.fallback_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.fallback_1.metaTitle`,`product.parent.translation.fallback_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) AS `product.metaTitle`, `product.translation.fallback_1.packUnit`, `product.parent.translation.fallback_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.fallback_1.packUnit`,`product.parent.translation.fallback_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) AS `product.packUnit`, `product.translation.fallback_1.packUnitPlural`, `product.parent.translation.fallback_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.fallback_1.packUnitPlural`,`product.parent.translation.fallback_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) AS `product.packUnitPlural`, `product.translation.fallback_1.customSearchKeywords`, `product.parent.translation.fallback_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.fallback_1.customSearchKeywords`,`product.parent.translation.fallback_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) AS `product.customSearchKeywords`, `product.translation.fallback_1.slotConfig`, `product.parent.translation.fallback_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.fallback_1.slotConfig`,`product.parent.translation.fallback_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) AS `product.slotConfig`, `product.translation.fallback_1.customFields`, `product.parent.translation.fallback_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.fallback_1.customFields`,`product.parent.translation.fallback_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) AS `product.customFields`, `product.translation.fallback_1.createdAt`, `product.parent.translation.fallback_1.createdAt`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.fallback_1.updatedAt`, `product.parent.translation.fallback_1.updatedAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.fallback_1.productId`, `product.parent.translation.fallback_1.productId`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.fallback_1.languageId`, `product.parent.translation.fallback_1.languageId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.fallback_1.productVersionId`, `product.parent.translation.fallback_1.productVersionId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId`, `product.translation.fallback_1`.meta_description AS `product.translation.fallback_1.metaDescription`, `product.translation.fallback_1`.name AS `product.translation.fallback_1.name`, `product.translation.fallback_1`.keywords AS `product.translation.fallback_1.keywords`, `product.translation.fallback_1`.description AS `product.translation.fallback_1.description`, `product.translation.fallback_1`.meta_title AS `product.translation.fallback_1.metaTitle`, `product.translation.fallback_1`.pack_unit AS `product.translation.fallback_1.packUnit`, `product.translation.fallback_1`.pack_unit_plural AS `product.translation.fallback_1.packUnitPlural`, `product.translation.fallback_1`.custom_search_keywords AS `product.translation.fallback_1.customSearchKeywords`, `product.translation.fallback_1`.slot_config AS `product.translation.fallback_1.slotConfig`, `product.translation.fallback_1`.custom_fields AS `product.translation.fallback_1.customFields`, `product.translation.fallback_1`.created_at AS `product.translation.fallback_1.createdAt`, `product.translation.fallback_1`.updated_at AS `product.translation.fallback_1.updatedAt`, `product.translation.fallback_1`.product_id AS `product.translation.fallback_1.productId`, `product.translation.fallback_1`.language_id AS `product.translation.fallback_1.languageId`, `product.translation.fallback_1`.product_version_id AS `product.translation.fallback_1.productVersionId` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.fallback_1` ON `product.translation`.`product_id` = `product.translation.fallback_1`.`product_id` AND `product.translation.fallback_1`.language_id = ? AND `product.translation`.product_version_id = `product.translation.fallback_1`.product_version_id WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId`, `product.parent.translation.fallback_1`.meta_description AS `product.parent.translation.fallback_1.metaDescription`, `product.parent.translation.fallback_1`.name AS `product.parent.translation.fallback_1.name`, `product.parent.translation.fallback_1`.keywords AS `product.parent.translation.fallback_1.keywords`, `product.parent.translation.fallback_1`.description AS `product.parent.translation.fallback_1.description`, `product.parent.translation.fallback_1`.meta_title AS `product.parent.translation.fallback_1.metaTitle`, `product.parent.translation.fallback_1`.pack_unit AS `product.parent.translation.fallback_1.packUnit`, `product.parent.translation.fallback_1`.pack_unit_plural AS `product.parent.translation.fallback_1.packUnitPlural`, `product.parent.translation.fallback_1`.custom_search_keywords AS `product.parent.translation.fallback_1.customSearchKeywords`, `product.parent.translation.fallback_1`.slot_config AS `product.parent.translation.fallback_1.slotConfig`, `product.parent.translation.fallback_1`.custom_fields AS `product.parent.translation.fallback_1.customFields`, `product.parent.translation.fallback_1`.created_at AS `product.parent.translation.fallback_1.createdAt`, `product.parent.translation.fallback_1`.updated_at AS `product.parent.translation.fallback_1.updatedAt`, `product.parent.translation.fallback_1`.product_id AS `product.parent.translation.fallback_1.productId`, `product.parent.translation.fallback_1`.language_id AS `product.parent.translation.fallback_1.languageId`, `product.parent.translation.fallback_1`.product_version_id AS `product.parent.translation.fallback_1.productVersionId` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.fallback_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.fallback_1`.`product_id` AND `product.parent.translation.fallback_1`.language_id = ? AND `product.parent.translation`.product_version_id = `product.parent.translation.fallback_1`.product_version_id WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name AS `product.manufacturer.translation.name`, `product.manufacturer.translation`.description AS `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields AS `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at AS `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at AS `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id AS `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id AS `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id AS `product.manufacturer.translation.productManufacturerVersionId`, `product.manufacturer.translation.fallback_1`.name AS `product.manufacturer.translation.fallback_1.name`, `product.manufacturer.translation.fallback_1`.description AS `product.manufacturer.translation.fallback_1.description`, `product.manufacturer.translation.fallback_1`.custom_fields AS `product.manufacturer.translation.fallback_1.customFields`, `product.manufacturer.translation.fallback_1`.created_at AS `product.manufacturer.translation.fallback_1.createdAt`, `product.manufacturer.translation.fallback_1`.updated_at AS `product.manufacturer.translation.fallback_1.updatedAt`, `product.manufacturer.translation.fallback_1`.product_manufacturer_id AS `product.manufacturer.translation.fallback_1.productManufacturerId`, `product.manufacturer.translation.fallback_1`.language_id AS `product.manufacturer.translation.fallback_1.languageId`, `product.manufacturer.translation.fallback_1`.product_manufacturer_version_id AS `product.manufacturer.translation.fallback_1.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product.manufacturer.translation.fallback_1` ON `product.manufacturer.translation`.`product_manufacturer_id` = `product.manufacturer.translation.fallback_1`.`product_manufacturer_id` AND `product.manufacturer.translation.fallback_1`.language_id = ? AND `product.manufacturer.translation`.product_manufacturer_version_id = `product.manufacturer.translation.fallback_1`.product_manufacturer_version_id WHERE `product.manufacturer.translation`.language_id = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id WHERE (`product`.`version_id` = ?) AND ((`product`.`id` = ?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"©:Up(èLÎÜ\x12v\x1A▀ÖÉò"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.89 ms
(5.06%) 		8 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(3.02%) 		1 
# breadcrumb-extension::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId`, `category.translation.fallback_1`.name AS `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb AS `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config AS `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type AS `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link AS `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link AS `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab AS `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description AS `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title AS `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description AS `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords AS `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields AS `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at AS `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at AS `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id AS `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id AS `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id AS `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_1`.category_version_id WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ï¥0\x13X¹ü¾z¤[\x1Cî ˆÆ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(2.62%) 		1 
SELECT `acris_rrp_price`.`id` AS `acris_rrp_price.id`, `acris_rrp_price`.`version_id` AS `acris_rrp_price.versionId`, `acris_rrp_price`.`active` AS `acris_rrp_price.active`, `acris_rrp_price`.`priority` AS `acris_rrp_price.priority`, `acris_rrp_price`.`display_tax` AS `acris_rrp_price.displayTax`, `acris_rrp_price`.`fallback_price` AS `acris_rrp_price.fallbackPrice`, `acris_rrp_price`.`rrp_representation` AS `acris_rrp_price.rrpRepresentation`, `acris_rrp_price`.`box_display` AS `acris_rrp_price.boxDisplay`, `acris_rrp_price`.`detail_display` AS `acris_rrp_price.detailDisplay`, `acris_rrp_price`.`created_at` AS `acris_rrp_price.createdAt`, `acris_rrp_price`.`updated_at` AS `acris_rrp_price.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_rrp_price.rules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `acris_rrp_rule` `acris_rrp_price.rules.mapping`
                  WHERE `acris_rrp_price.rules.mapping`.`rrp_id` = `acris_rrp_price`.`id` ) AS `acris_rrp_price.rules.id_mapping`, `acris_rrp_price.translation.fallback_1.internalName`, `acris_rrp_price.translation.internalName`, COALESCE(`acris_rrp_price.translation.fallback_1.internalName`,`acris_rrp_price.translation.internalName`,`acris_rrp_price.translation.internalName`) AS `acris_rrp_price.internalName`, `acris_rrp_price.translation.fallback_1.boxGrossTextBefore`, `acris_rrp_price.translation.boxGrossTextBefore`, COALESCE(`acris_rrp_price.translation.fallback_1.boxGrossTextBefore`,`acris_rrp_price.translation.boxGrossTextBefore`,`acris_rrp_price.translation.boxGrossTextBefore`) AS `acris_rrp_price.boxGrossTextBefore`, `acris_rrp_price.translation.fallback_1.boxNetTextBefore`, `acris_rrp_price.translation.boxNetTextBefore`, COALESCE(`acris_rrp_price.translation.fallback_1.boxNetTextBefore`,`acris_rrp_price.translation.boxNetTextBefore`,`acris_rrp_price.translation.boxNetTextBefore`) AS `acris_rrp_price.boxNetTextBefore`, `acris_rrp_price.translation.fallback_1.boxGrossTextAfter`, `acris_rrp_price.translation.boxGrossTextAfter`, COALESCE(`acris_rrp_price.translation.fallback_1.boxGrossTextAfter`,`acris_rrp_price.translation.boxGrossTextAfter`,`acris_rrp_price.translation.boxGrossTextAfter`) AS `acris_rrp_price.boxGrossTextAfter`, `acris_rrp_price.translation.fallback_1.boxNetTextAfter`, `acris_rrp_price.translation.boxNetTextAfter`, COALESCE(`acris_rrp_price.translation.fallback_1.boxNetTextAfter`,`acris_rrp_price.translation.boxNetTextAfter`,`acris_rrp_price.translation.boxNetTextAfter`) AS `acris_rrp_price.boxNetTextAfter`, `acris_rrp_price.translation.fallback_1.detailGrossTextBefore`, `acris_rrp_price.translation.detailGrossTextBefore`, COALESCE(`acris_rrp_price.translation.fallback_1.detailGrossTextBefore`,`acris_rrp_price.translation.detailGrossTextBefore`,`acris_rrp_price.translation.detailGrossTextBefore`) AS `acris_rrp_price.detailGrossTextBefore`, `acris_rrp_price.translation.fallback_1.detailNetTextBefore`, `acris_rrp_price.translation.detailNetTextBefore`, COALESCE(`acris_rrp_price.translation.fallback_1.detailNetTextBefore`,`acris_rrp_price.translation.detailNetTextBefore`,`acris_rrp_price.translation.detailNetTextBefore`) AS `acris_rrp_price.detailNetTextBefore`, `acris_rrp_price.translation.fallback_1.detailGrossTextAfter`, `acris_rrp_price.translation.detailGrossTextAfter`, COALESCE(`acris_rrp_price.translation.fallback_1.detailGrossTextAfter`,`acris_rrp_price.translation.detailGrossTextAfter`,`acris_rrp_price.translation.detailGrossTextAfter`) AS `acris_rrp_price.detailGrossTextAfter`, `acris_rrp_price.translation.fallback_1.detailNetTextAfter`, `acris_rrp_price.translation.detailNetTextAfter`, COALESCE(`acris_rrp_price.translation.fallback_1.detailNetTextAfter`,`acris_rrp_price.translation.detailNetTextAfter`,`acris_rrp_price.translation.detailNetTextAfter`) AS `acris_rrp_price.detailNetTextAfter`, `acris_rrp_price.translation.fallback_1.customFields`, `acris_rrp_price.translation.customFields`, `acris_rrp_price.translation.fallback_1.createdAt`, `acris_rrp_price.translation.createdAt`, `acris_rrp_price.translation.fallback_1.updatedAt`, `acris_rrp_price.translation.updatedAt`, `acris_rrp_price.translation.fallback_1.acrisRrpPriceId`, `acris_rrp_price.translation.acrisRrpPriceId`, `acris_rrp_price.translation.fallback_1.languageId`, `acris_rrp_price.translation.languageId`, `acris_rrp_price.translation.fallback_1.acrisRrpPriceVersionId`, `acris_rrp_price.translation.acrisRrpPriceVersionId` FROM `acris_rrp_price` LEFT JOIN (SELECT `acris_rrp_price.translation`.acris_rrp_price_id, `acris_rrp_price.translation`.acris_rrp_price_version_id, `acris_rrp_price.translation`.internal_name AS `acris_rrp_price.translation.internalName`, `acris_rrp_price.translation`.box_gross_text_before AS `acris_rrp_price.translation.boxGrossTextBefore`, `acris_rrp_price.translation`.box_net_text_before AS `acris_rrp_price.translation.boxNetTextBefore`, `acris_rrp_price.translation`.box_gross_text_after AS `acris_rrp_price.translation.boxGrossTextAfter`, `acris_rrp_price.translation`.box_net_text_after AS `acris_rrp_price.translation.boxNetTextAfter`, `acris_rrp_price.translation`.detail_gross_text_before AS `acris_rrp_price.translation.detailGrossTextBefore`, `acris_rrp_price.translation`.detail_net_text_before AS `acris_rrp_price.translation.detailNetTextBefore`, `acris_rrp_price.translation`.detail_gross_text_after AS `acris_rrp_price.translation.detailGrossTextAfter`, `acris_rrp_price.translation`.detail_net_text_after AS `acris_rrp_price.translation.detailNetTextAfter`, `acris_rrp_price.translation`.custom_fields AS `acris_rrp_price.translation.customFields`, `acris_rrp_price.translation`.created_at AS `acris_rrp_price.translation.createdAt`, `acris_rrp_price.translation`.updated_at AS `acris_rrp_price.translation.updatedAt`, `acris_rrp_price.translation`.acris_rrp_price_id AS `acris_rrp_price.translation.acrisRrpPriceId`, `acris_rrp_price.translation`.language_id AS `acris_rrp_price.translation.languageId`, `acris_rrp_price.translation`.acris_rrp_price_version_id AS `acris_rrp_price.translation.acrisRrpPriceVersionId`, `acris_rrp_price.translation.fallback_1`.internal_name AS `acris_rrp_price.translation.fallback_1.internalName`, `acris_rrp_price.translation.fallback_1`.box_gross_text_before AS `acris_rrp_price.translation.fallback_1.boxGrossTextBefore`, `acris_rrp_price.translation.fallback_1`.box_net_text_before AS `acris_rrp_price.translation.fallback_1.boxNetTextBefore`, `acris_rrp_price.translation.fallback_1`.box_gross_text_after AS `acris_rrp_price.translation.fallback_1.boxGrossTextAfter`, `acris_rrp_price.translation.fallback_1`.box_net_text_after AS `acris_rrp_price.translation.fallback_1.boxNetTextAfter`, `acris_rrp_price.translation.fallback_1`.detail_gross_text_before AS `acris_rrp_price.translation.fallback_1.detailGrossTextBefore`, `acris_rrp_price.translation.fallback_1`.detail_net_text_before AS `acris_rrp_price.translation.fallback_1.detailNetTextBefore`, `acris_rrp_price.translation.fallback_1`.detail_gross_text_after AS `acris_rrp_price.translation.fallback_1.detailGrossTextAfter`, `acris_rrp_price.translation.fallback_1`.detail_net_text_after AS `acris_rrp_price.translation.fallback_1.detailNetTextAfter`, `acris_rrp_price.translation.fallback_1`.custom_fields AS `acris_rrp_price.translation.fallback_1.customFields`, `acris_rrp_price.translation.fallback_1`.created_at AS `acris_rrp_price.translation.fallback_1.createdAt`, `acris_rrp_price.translation.fallback_1`.updated_at AS `acris_rrp_price.translation.fallback_1.updatedAt`, `acris_rrp_price.translation.fallback_1`.acris_rrp_price_id AS `acris_rrp_price.translation.fallback_1.acrisRrpPriceId`, `acris_rrp_price.translation.fallback_1`.language_id AS `acris_rrp_price.translation.fallback_1.languageId`, `acris_rrp_price.translation.fallback_1`.acris_rrp_price_version_id AS `acris_rrp_price.translation.fallback_1.acrisRrpPriceVersionId` FROM `acris_rrp_price_translation` `acris_rrp_price.translation` LEFT JOIN `acris_rrp_price_translation` `acris_rrp_price.translation.fallback_1` ON `acris_rrp_price.translation`.`acris_rrp_price_id` = `acris_rrp_price.translation.fallback_1`.`acris_rrp_price_id` AND `acris_rrp_price.translation.fallback_1`.language_id = ? AND `acris_rrp_price.translation`.acris_rrp_price_version_id = `acris_rrp_price.translation.fallback_1`.acris_rrp_price_version_id WHERE `acris_rrp_price.translation`.language_id = ?) `acris_rrp_price.acris_rrp_price_translation` ON `acris_rrp_price.acris_rrp_price_translation`.`acris_rrp_price_id` = `acris_rrp_price`.`id` AND `acris_rrp_price.acris_rrp_price_translation`.acris_rrp_price_version_id = `acris_rrp_price`.version_id WHERE (`acris_rrp_price`.`version_id` = ?) AND (`acris_rrp_price`.`id` IN (?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01’e•%Œpÿˆ\x11t\x10\x13MŽ–"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(2.48%) 		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"ñ\x174IyÁ%.\e²4ü▄s"ó"
  b"]└ã\rù\x16O<ÇAÅÊO\x7F¬╗"
  b"Ë\x1F\eÙ¨\x17BУ'Å;█ûfæ"
  b"ÔÍžôõ\vNá©\x10M\x1CD¢¾—"
  b"ð-É\f4K@ ¥1\x01kMiàP"
  b"Qr╠\v®┤JÑÅò╩‗\x1Fòı""
  b"‗qÄü\x07IEl¢<j@)/Õ\x07"
  b"\x10qûÑ\x15nF\x16§†;ÉÙ±ö9"
  b"E†ýi–°Lc„AOÊ™&­Ÿ"
  b"ýeok¸ÏL\x17¬çÖ%Û5oj"
  b"\x0Eô“+V\x15K˜·§îcGÚ§O"
  b""âÛEÀA@źmŸéxÉQm"
  b"Ђµ—F\N\x05­Æd+C¦° "
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(1.63%) 		1 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "6-meter-1200-led-warm-white-no-pole-94155"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(1.61%) 		1 
SELECT `acris_rrp_price`.`id` FROM `acris_rrp_price` LEFT JOIN `acris_rrp_rule` `acris_rrp_price.rules.mapping` ON `acris_rrp_price`.`id` = `acris_rrp_price.rules.mapping`.`rrp_id`  LEFT JOIN `rule` `acris_rrp_price.rules` ON `acris_rrp_price.rules.mapping`.`rule_id` = `acris_rrp_price.rules`.`id`  WHERE (`acris_rrp_price`.`version_id` = ?) AND ((`acris_rrp_price`.`active` = ? AND (`acris_rrp_price.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR `acris_rrp_price.rules`.`id` <=> ?))) GROUP BY `acris_rrp_price`.`id` ORDER BY MAX(`acris_rrp_price`.`priority`) DESC
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  b"ñ\x174IyÁ%.\e²4ü▄s"ó"
  b"]└ã\rù\x16O<ÇAÅÊO\x7F¬╗"
  b"Ë\x1F\eÙ¨\x17BУ'Å;█ûfæ"
  b"ÔÍžôõ\vNá©\x10M\x1CD¢¾—"
  b"ð-É\f4K@ ¥1\x01kMiàP"
  b"Qr╠\v®┤JÑÅò╩‗\x1Fòı""
  b"‗qÄü\x07IEl¢<j@)/Õ\x07"
  b"\x10qûÑ\x15nF\x16§†;ÉÙ±ö9"
  b"E†ýi–°Lc„AOÊ™&­Ÿ"
  b"ýeok¸ÏL\x17¬çÖ%Û5oj"
  b"\x0Eô“+V\x15K˜·§îcGÚ§O"
  b""âÛEÀA@źmŸéxÉQm"
  b"Ђµ—F\N\x05­Æd+C¦° "
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(1.50%) 		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.23 ms
(1.29%) 		1 
SELECT option_translation.name FROM product product INNER JOIN product_option product_group ON product_group.product_id = product.id INNER JOIN property_group_option product_option ON product_group.property_group_option_id = product_option.id INNER JOIN property_group_option_translation option_translation ON option_translation.property_group_option_id = product_option.id WHERE (product.id = ?) AND (product.parent_id IS NOT NULL) AND (product.option_ids IS NOT NULL) AND (option_translation.language_id = ?)
Parameters: 
[
  b"©:Up(èLÎÜ\x12v\x1A▀ÖÉò"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(1.27%) 		1 
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id IS NULL) AND (property.module = ?)
Parameters: 
[
  "frontend.detail.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(1.20%) 		1 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name AS composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(1.19%) 		3 
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id = ?) AND (property.module = ?)
Parameters: 
[
  b"1ýOf\,L\x0EÉ\x16mo╚▄êÑ"
  "frontend.detail.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(1.18%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "nl-NL"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(1.08%) 		1 
SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?
Parameters: 
[
  b"Úıº¡O!@\x02Å{Q\x08t▄▓°"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.95%) 		1 
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.79%) 		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"¡éPb╚¶Gƒü\x1D S«Sö¤"
  b"\x07\x04ÅT¥YOΨ•ã8˜<åö"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.74%) 		1 
SELECT LOWER(HEX(id)) FROM sales_channel
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.64%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.64%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "EnhN7uUNPYmaXSTkkCkoiznHm5VYqpy8"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.63%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.56%) 		1 
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.52%) 		1 
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.43%) 		1 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.