GET https://menziebz.webwirkungdev.ch/sas_blog/0191c0f7ace67685949492c21d4bb43f

Response
200 OK
IP
216.73.216.67
Profiled on
Token
4be938

Query Metrics

33 Database Queries
31 Different statements
17.61 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
3.37 ms
(19.13%) 		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: 
[
  "/sas_blog/0191c0f7ace67685949492c21d4bb43f"
  "/navigation/a4eba85b194f484295e1db368487d998"
  "/navigation/6d6ee80f2700478598d2a2dd73db596c"
  "/navigation/019054bb2b5170a9a01d7c52f31f4ea9"
  "/navigation/fd83c2142ea34ff79f669fc3b470c847"
  "/navigation/4caf7ca43166417fbc51a18c8d3b35b5"
  "/navigation/4c3cb605bb5f46d0b8815e225822bb38"
  "/navigation/ec69130494f64dcda67f1b66ee15e944"
  "/navigation/1d01dbdb4fc341dc9a290a794584bb7c"
  "/navigation/047fa5566a90433099a68b4482400a3b"
  "/navigation/af1ada8ff50041b2a7d8214ab38073e7"
  "/navigation/223a73dedbd74d6f9e646bfb26c17644"
  "/navigation/cbe776f2f17445b5b71a4dcd1f17684d"
  "/navigation/df8b1327dc5b43f9bcd2a4acd91292bc"
  "/navigation/6fcab224d2624b1d878a27b23573a3b0"
  "/navigation/2c510ce953744e019e61d3c91a263630"
  "/navigation/a57540baf2404a14bea6b645e586a4bc"
  "/navigation/52860544a42142929223dc983f564868"
  "/navigation/6afcd0f2aa004fcf90e75d26804e6aba"
  "/navigation/ace73fce4a18439ca507e5ef8a621405"
  "/navigation/015cded59f9643cbbb9abe36fe26853c"
  "/navigation/682c3e125204499fbe42ab14ba4be8bc"
  "/navigation/a84134df514649299a5e74a135bd6202"
  "/navigation/2accf100594b4a18b86548e573816b54"
  "/navigation/5f0f26157e27471d975bc7cc1a376544"
  "/navigation/5c56e77c506e40839eb8e46fbe301a2f"
  "/navigation/8b7aa8324bbe4134af70d1498ffca82a"
  "/navigation/529080be909a4c99bdfd83bb642d3e5b"
  "/navigation/377741c87cbb4f81ada4bfa2263a9327"
  "/navigation/08597fcdfd33419eaa40edcee02e108d"
  "/navigation/54cbf57c7c84417291be74e20d339923"
  "/navigation/67137434aa8148c7ac9b6ad0c4e939d6"
  "/navigation/aa796c4af5074afda19790c91972c71c"
  "/navigation/53a4b9bc9c81421da0c93d1df0d30a05"
  "/navigation/61058fc42b244c1785b45c1035c66f56"
  "/navigation/031aa1700ccf4c48bcf1af4dfa1a1ed7"
  "/navigation/fc69b7e724e040889b0cf12da505d36c"
  "/navigation/1b84ab6c827b47fbb1bb3dc82c030e45"
  "/navigation/17830a0aef264dbfaa48994e6c56eab0"
  "/navigation/504b975fc2a14ef98defbebd48d4ce56"
  "/navigation/5d557a1e0e29406b81fe2e2486b6e11a"
  "/navigation/329dd51d6fd8423a960e7c8f26dd008a"
  "/navigation/e4babda014724d45b2a51362ada93000"
  "/navigation/31db06e32f474000b38b730ba8cb7a66"
  "/navigation/402848d7bfda40fa8cd123c23f90a3f2"
  "/navigation/706802a8b40d44c3a7cde9cec363bbea"
  "/navigation/8a7567c6c84542b3b512e66c878c42da"
  "/navigation/10abdfaa320f44e1a066e34e02694fed"
  "/navigation/96d703f3e5184525adea87d4f2a343b6"
  "/navigation/2c368932efa343a79f1c158fd6f9b74a"
  "/navigation/582d16fca3ae4dd6a1d642583f30e51f"
  "/navigation/4a7e5308a0d64685b8a7951ab335d636"
  "/navigation/200d6e2092f04ed78d93156f44c5dcc5"
  "/navigation/603938ad7d2841c4892e7a976d33f355"
  "/navigation/91aa4913710445719d928f4760cd5f72"
  "/navigation/e32c15534c54487d816306309ee3df79"
  "/navigation/f869c1b352984703842b46de65154eda"
  "/navigation/42a1b4a1be8347868a00a19c6f2fd1bd"
  "/navigation/b1cbc7b817624af78dbbcf136346dcb4"
  "/navigation/37456140c9fc4891be3d1d83976e25af"
  "/navigation/8851c6eabf8a45999b0c259c2291f956"
  "/navigation/6cd9878b596e4f08a1ad09f7295cf0bc"
  "/navigation/e78fe328b7d44b2db251867adaaf4d40"
  "/navigation/6a566dc5b6a1411da95731b89b5ecba7"
  "/navigation/04f4be699afa469a9858c79b02c14bd6"
  "/navigation/5fcca137c497482c971e528a59ac5682"
  "/navigation/3f4ea6ea8cc344c1b310990f899b406a"
  "/navigation/53eed4cc11874022b00d6c2224361cd9"
  "/navigation/ca189a3f460141de9513fd718ca02f92"
  "/navigation/ca8e5a5739fb4de5a0e027599b1fcc21"
  "/navigation/f21fde8bbc7d495b8201585439a0e053"
  "/navigation/ae25489caa554f64a962d59ec3614479"
  "/navigation/019150ed7c667a3999470ccbc1702a49"
  "/navigation/ba36106b03bd4fe0bb09f7b1ab699314"
  "/navigation/477404fd7e9d4ab78586e0d26e266f8b"
  "/navigation/019150eddab57d86bf4c4d5eafe6b157"
  "/navigation/5e15e148ad6a4ce189e00bcc6f037ec4"
  "/navigation/228b5086995b4797b2ca631844ba3d44"
  "/navigation/aafdb3c39e004c05850a51612e1875ac"
  "/navigation/7cb74b64b20941d7aafb19b42e5f2fe0"
  "/navigation/99f5ee3a5bd648279a1c28509736d8f7"
  "/navigation/fff53c4488b648a9b9dd095e53bb2440"
  "/navigation/0cdb9daa09fa4d65b8ea01e4559e4efd"
  "/navigation/3292be97c8de4e73b39e5a71e38fbab9"
  "/navigation/0190e90525ff70a89d17aed5e552d36d"
  "/navigation/0190e90565347ca2a4ddcde9c405a8f3"
  "/navigation/019150eba46674b985e95aedd2f28c4e"
  "/navigation/0190e9067f427309af029facda17e279"
  "/navigation/0190e9069c927eecb7b37cb70c885cf1"
  "/navigation/0190e90703467f05960cdf393d2b9334"
  "/navigation/0190e90838d67625a7019d87909e7d2e"
  "/navigation/0190e9106c9e77a2b56ffa46f769f08c"
  "/navigation/0190e94d44e47d94a7f205b85b155086"
  "/navigation/0190e94d5ce2740aa5a658ac5f68d3ce"
  "/navigation/0190e946c6977e1092a7739913a80511"
  "/navigation/0190e94b139e70d49f734c7f0d447eb1"
  "/navigation/0190e94b5379790eae0f4ba3d58d0aae"
  "/navigation/0190e94b72637cb0935dffb236ba6d9b"
  "/navigation/0190e94b83ed7159a7d08dc5864cae3c"
  "/navigation/0190e94b94517b20b9122a5b78be7897"
  "/navigation/b2d347310ba8447a9dac9a9f860a078f"
  "/navigation/0190e955be0472ef926b093587aeec25"
  "/navigation/0190e955d6d276de901444c4a12b4e8c"
  "/navigation/0190e95739267f8099ed81a69c5303e0"
  "/navigation/0190ee64a2637051a9c7c179a0aedc86"
  "/navigation/52eadbc235f2414b9f2abf92bc3d2745"
  "/navigation/164a96bd7d4342de881b37867c767677"
  "/navigation/019150d6e0a37a9787423845e973327a"
  "/navigation/019150d7032b79029708d471a8179169"
  "/navigation/01918eb5428779e5b343828a0c27999f"
  "/navigation/eb8c4e8c0eeb4d61a9cc948194d03837"
  "/navigation/3fca686965c44f0f8cc10d7deba98065"
  "/navigation/0191f155bf31719ba36094641801aa92"
  "/navigation/877581eca99543f69b6dd437d1e52231"
  "/navigation/2f23ce7a9fef421b8712a8398843a212"
  "/navigation/8539fa0bcf884fb6992d29526525b0c2"
  "/navigation/0190e958a3aa7c20af04eb97a5e7275b"
  "/navigation/86830b38338047ff81c4d6c99c3456e5"
  "/navigation/f60703628bef44eab3f8086b8446f142"
  "/navigation/0190e95890bf7becab53fd219c2e2a8c"
  "/navigation/9817a203826d462680aef526185a6e46"
  "/navigation/76f18a459ead4933a7c480f128884e2e"
  "/navigation/c23856d608f2427d8bf020df8c54dcc8"
  "/navigation/0190e9587cf777ce8abf5b0040dea2b7"
  "/navigation/2730b7df44e54f52a07f810653775d14"
  "/navigation/ae62acbe5c624ae1a6cb3aa14b229931"
  "/navigation/2c680d7edafb454eb68276ebf56e6c43"
  "/navigation/bee82e199aee43eebc458a57706362ca"
  "/navigation/0dcd561162fb416c9715b9d8c600dffc"
  "/navigation/7186ebfb563a410989dc3de99beec5ca"
  "/navigation/b8be3bb6650b459aa3192e395f4a80e1"
  "/navigation/38f7724f59454bc4a44e19924bd4a4cf"
  "/navigation/a903d001e82d4c709e2545176fc4afb6"
  "/navigation/cda2229891094652915ae7d767a6c2b4"
  "/navigation/01922a02bf21757caf06ceba1fc61d95"
  "/navigation/f19f9d07a7d34771bb004d673c4005ca"
  "/navigation/06e0851ac15549adb6a228a033ed3619"
  "/navigation/786f48a8e73747c29fd2887b74d9a5e2"
  "/navigation/29e040585255439c9e4fce9fc8e699b3"
  "/navigation/8f09f653a0df4381a2f532d833c5bc03"
  "/navigation/1fb05e61003e421d8dd8daaca863946f"
  "/navigation/3660c6ec7cbb4b51b472e3f17cb4a7eb"
  "/navigation/70afc5c43eed4d1ea4d2e38b3074b5dd"
  "/navigation/1217fc23af1649b68ef836300994a05e"
  "/navigation/019151070d8a74b09fe6479b1f54a5a3"
  "/navigation/89845eafc8b64f47ab81f17702eb537b"
  "/navigation/01915107ba82739ebe07e12fbc4746e7"
  "/navigation/01915107cd647ed5950ff40cfac4a32a"
  "/sas_blog_category/0191bd2ebbd071cfad4ec0133db32231"
  "/navigation/0190de58b01475beb3663897fc94b575"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"õ½iA_mMÇ’\x18}2m}”M"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.54 ms
(14.45%) 		1 
SELECT `sas_blog_entries`.`id` as `sas_blog_entries.id`, `sas_blog_entries`.`active` as `sas_blog_entries.active`, `sas_blog_entries`.`detail_teaser_image` as `sas_blog_entries.detailTeaserImage`, `sas_blog_entries`.`media_id` as `sas_blog_entries.mediaId`, `sas_blog_entries`.`author_id` as `sas_blog_entries.authorId`, `sas_blog_entries`.`cms_page_id` as `sas_blog_entries.cmsPageId`, `sas_blog_entries`.`cms_page_version_id` as `sas_blog_entries.cmsPageVersionId`, `sas_blog_entries.media`.`id` as `sas_blog_entries.media.id`, `sas_blog_entries.media`.`user_id` as `sas_blog_entries.media.userId`, `sas_blog_entries.media`.`media_folder_id` as `sas_blog_entries.media.mediaFolderId`, `sas_blog_entries.media`.`mime_type` as `sas_blog_entries.media.mimeType`, `sas_blog_entries.media`.`file_extension` as `sas_blog_entries.media.fileExtension`, `sas_blog_entries.media`.`uploaded_at` as `sas_blog_entries.media.uploadedAt`, `sas_blog_entries.media`.`file_name` as `sas_blog_entries.media.fileName`, `sas_blog_entries.media`.`file_size` as `sas_blog_entries.media.fileSize`, `sas_blog_entries.media`.`media_type` as `sas_blog_entries.media.mediaTypeRaw`, `sas_blog_entries.media`.`meta_data` as `sas_blog_entries.media.metaData`, `sas_blog_entries.media`.`config` as `sas_blog_entries.media.config`, `sas_blog_entries.media`.`path` as `sas_blog_entries.media.path`, `sas_blog_entries.media`.`private` as `sas_blog_entries.media.private`, `sas_blog_entries.media`.`thumbnails_ro` as `sas_blog_entries.media.thumbnailsRo`, `sas_blog_entries.media`.`created_at` as `sas_blog_entries.media.createdAt`, `sas_blog_entries.media`.`updated_at` as `sas_blog_entries.media.updatedAt`, `sas_blog_entries.media.translation.override_1.title`, `sas_blog_entries.media.translation.title`, COALESCE(`sas_blog_entries.media.translation.override_1.title`,`sas_blog_entries.media.translation.title`) as `sas_blog_entries.media.title`, `sas_blog_entries.media.translation.override_1.alt`, `sas_blog_entries.media.translation.alt`, COALESCE(`sas_blog_entries.media.translation.override_1.alt`,`sas_blog_entries.media.translation.alt`) as `sas_blog_entries.media.alt`, `sas_blog_entries.media.translation.override_1.customFields`, `sas_blog_entries.media.translation.customFields`, COALESCE(`sas_blog_entries.media.translation.override_1.customFields`,`sas_blog_entries.media.translation.customFields`) as `sas_blog_entries.media.customFields`, `sas_blog_entries`.`published_at` as `sas_blog_entries.publishedAt`, `sas_blog_entries`.`created_at` as `sas_blog_entries.createdAt`, `sas_blog_entries`.`updated_at` as `sas_blog_entries.updatedAt`, `sas_blog_entries.blogAuthor`.`id` as `sas_blog_entries.blogAuthor.id`, `sas_blog_entries.blogAuthor`.`media_id` as `sas_blog_entries.blogAuthor.mediaId`, `sas_blog_entries.blogAuthor`.`salutation_id` as `sas_blog_entries.blogAuthor.salutationId`, `sas_blog_entries.blogAuthor`.`first_name` as `sas_blog_entries.blogAuthor.firstName`, `sas_blog_entries.blogAuthor`.`last_name` as `sas_blog_entries.blogAuthor.lastName`, `sas_blog_entries.blogAuthor`.`email` as `sas_blog_entries.blogAuthor.email`, `sas_blog_entries.blogAuthor`.`display_name` as `sas_blog_entries.blogAuthor.displayName`, `sas_blog_entries.blogAuthor.media`.`id` as `sas_blog_entries.blogAuthor.media.id`, `sas_blog_entries.blogAuthor.media`.`user_id` as `sas_blog_entries.blogAuthor.media.userId`, `sas_blog_entries.blogAuthor.media`.`media_folder_id` as `sas_blog_entries.blogAuthor.media.mediaFolderId`, `sas_blog_entries.blogAuthor.media`.`mime_type` as `sas_blog_entries.blogAuthor.media.mimeType`, `sas_blog_entries.blogAuthor.media`.`file_extension` as `sas_blog_entries.blogAuthor.media.fileExtension`, `sas_blog_entries.blogAuthor.media`.`uploaded_at` as `sas_blog_entries.blogAuthor.media.uploadedAt`, `sas_blog_entries.blogAuthor.media`.`file_name` as `sas_blog_entries.blogAuthor.media.fileName`, `sas_blog_entries.blogAuthor.media`.`file_size` as `sas_blog_entries.blogAuthor.media.fileSize`, `sas_blog_entries.blogAuthor.media`.`media_type` as `sas_blog_entries.blogAuthor.media.mediaTypeRaw`, `sas_blog_entries.blogAuthor.media`.`meta_data` as `sas_blog_entries.blogAuthor.media.metaData`, `sas_blog_entries.blogAuthor.media`.`config` as `sas_blog_entries.blogAuthor.media.config`, `sas_blog_entries.blogAuthor.media`.`path` as `sas_blog_entries.blogAuthor.media.path`, `sas_blog_entries.blogAuthor.media`.`private` as `sas_blog_entries.blogAuthor.media.private`, `sas_blog_entries.blogAuthor.media`.`thumbnails_ro` as `sas_blog_entries.blogAuthor.media.thumbnailsRo`, `sas_blog_entries.blogAuthor.media`.`created_at` as `sas_blog_entries.blogAuthor.media.createdAt`, `sas_blog_entries.blogAuthor.media`.`updated_at` as `sas_blog_entries.blogAuthor.media.updatedAt`, `sas_blog_entries.blogAuthor.media.translation.override_1.title`, `sas_blog_entries.blogAuthor.media.translation.title`, COALESCE(`sas_blog_entries.blogAuthor.media.translation.override_1.title`,`sas_blog_entries.blogAuthor.media.translation.title`) as `sas_blog_entries.blogAuthor.media.title`, `sas_blog_entries.blogAuthor.media.translation.override_1.alt`, `sas_blog_entries.blogAuthor.media.translation.alt`, COALESCE(`sas_blog_entries.blogAuthor.media.translation.override_1.alt`,`sas_blog_entries.blogAuthor.media.translation.alt`) as `sas_blog_entries.blogAuthor.media.alt`, `sas_blog_entries.blogAuthor.media.translation.override_1.customFields`, `sas_blog_entries.blogAuthor.media.translation.customFields`, COALESCE(`sas_blog_entries.blogAuthor.media.translation.override_1.customFields`,`sas_blog_entries.blogAuthor.media.translation.customFields`) as `sas_blog_entries.blogAuthor.media.customFields`, `sas_blog_entries.blogAuthor`.`created_at` as `sas_blog_entries.blogAuthor.createdAt`, `sas_blog_entries.blogAuthor`.`updated_at` as `sas_blog_entries.blogAuthor.updatedAt`, `sas_blog_entries.blogAuthor.salutation`.`id` as `sas_blog_entries.blogAuthor.salutation.id`, `sas_blog_entries.blogAuthor.salutation`.`salutation_key` as `sas_blog_entries.blogAuthor.salutation.salutationKey`, `sas_blog_entries.blogAuthor.salutation`.`created_at` as `sas_blog_entries.blogAuthor.salutation.createdAt`, `sas_blog_entries.blogAuthor.salutation`.`updated_at` as `sas_blog_entries.blogAuthor.salutation.updatedAt`, `sas_blog_entries.blogAuthor.salutation.translation.override_1.displayName`, `sas_blog_entries.blogAuthor.salutation.translation.displayName`, COALESCE(`sas_blog_entries.blogAuthor.salutation.translation.override_1.displayName`,`sas_blog_entries.blogAuthor.salutation.translation.displayName`) as `sas_blog_entries.blogAuthor.salutation.displayName`, `sas_blog_entries.blogAuthor.salutation.translation.override_1.letterName`, `sas_blog_entries.blogAuthor.salutation.translation.letterName`, COALESCE(`sas_blog_entries.blogAuthor.salutation.translation.override_1.letterName`,`sas_blog_entries.blogAuthor.salutation.translation.letterName`) as `sas_blog_entries.blogAuthor.salutation.letterName`, `sas_blog_entries.blogAuthor.salutation.translation.override_1.customFields`, `sas_blog_entries.blogAuthor.salutation.translation.customFields`, COALESCE(`sas_blog_entries.blogAuthor.salutation.translation.override_1.customFields`,`sas_blog_entries.blogAuthor.salutation.translation.customFields`) as `sas_blog_entries.blogAuthor.salutation.customFields`, `sas_blog_entries.blogAuthor.translation.override_1.description`, `sas_blog_entries.blogAuthor.translation.description`, COALESCE(`sas_blog_entries.blogAuthor.translation.override_1.description`,`sas_blog_entries.blogAuthor.translation.description`) as `sas_blog_entries.blogAuthor.description`, `sas_blog_entries.blogAuthor.translation.override_1.customFields`, `sas_blog_entries.blogAuthor.translation.customFields`, COALESCE(`sas_blog_entries.blogAuthor.translation.override_1.customFields`,`sas_blog_entries.blogAuthor.translation.customFields`) as `sas_blog_entries.blogAuthor.customFields`, (SELECT GROUP_CONCAT(HEX(`sas_blog_entries.blogCategories.mapping`.`sas_blog_category_id`) SEPARATOR '||')
                  FROM `sas_blog_blog_category` `sas_blog_entries.blogCategories.mapping`
                  WHERE `sas_blog_entries.blogCategories.mapping`.`sas_blog_entries_id` = `sas_blog_entries`.`id` ) as `sas_blog_entries.blogCategories.id_mapping`, `sas_blog_entries.translation.override_1.title`, `sas_blog_entries.translation.title`, COALESCE(`sas_blog_entries.translation.override_1.title`,`sas_blog_entries.translation.title`) as `sas_blog_entries.title`, `sas_blog_entries.translation.override_1.slug`, `sas_blog_entries.translation.slug`, COALESCE(`sas_blog_entries.translation.override_1.slug`,`sas_blog_entries.translation.slug`) as `sas_blog_entries.slug`, `sas_blog_entries.translation.override_1.teaser`, `sas_blog_entries.translation.teaser`, COALESCE(`sas_blog_entries.translation.override_1.teaser`,`sas_blog_entries.translation.teaser`) as `sas_blog_entries.teaser`, `sas_blog_entries.translation.override_1.metaTitle`, `sas_blog_entries.translation.metaTitle`, COALESCE(`sas_blog_entries.translation.override_1.metaTitle`,`sas_blog_entries.translation.metaTitle`) as `sas_blog_entries.metaTitle`, `sas_blog_entries.translation.override_1.metaDescription`, `sas_blog_entries.translation.metaDescription`, COALESCE(`sas_blog_entries.translation.override_1.metaDescription`,`sas_blog_entries.translation.metaDescription`) as `sas_blog_entries.metaDescription`, `sas_blog_entries.translation.override_1.metaKeywords`, `sas_blog_entries.translation.metaKeywords`, COALESCE(`sas_blog_entries.translation.override_1.metaKeywords`,`sas_blog_entries.translation.metaKeywords`) as `sas_blog_entries.metaKeywords`, `sas_blog_entries.translation.override_1.content`, `sas_blog_entries.translation.content`, COALESCE(`sas_blog_entries.translation.override_1.content`,`sas_blog_entries.translation.content`) as `sas_blog_entries.content`, `sas_blog_entries.translation.override_1.customFields`, `sas_blog_entries.translation.customFields`, COALESCE(`sas_blog_entries.translation.override_1.customFields`,`sas_blog_entries.translation.customFields`) as `sas_blog_entries.customFields` FROM `sas_blog_entries` LEFT JOIN `media` `sas_blog_entries.media` ON `sas_blog_entries`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN `sas_blog_author` `sas_blog_entries.blogAuthor` ON `sas_blog_entries`.`author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`title` as `sas_blog_entries.translation.title`, `sas_blog_entries.translation.override_1`.`title` as `sas_blog_entries.translation.override_1.title`, `sas_blog_entries.translation`.`slug` as `sas_blog_entries.translation.slug`, `sas_blog_entries.translation.override_1`.`slug` as `sas_blog_entries.translation.override_1.slug`, `sas_blog_entries.translation`.`teaser` as `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation.override_1`.`teaser` as `sas_blog_entries.translation.override_1.teaser`, `sas_blog_entries.translation`.`meta_title` as `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation.override_1`.`meta_title` as `sas_blog_entries.translation.override_1.metaTitle`, `sas_blog_entries.translation`.`meta_description` as `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation.override_1`.`meta_description` as `sas_blog_entries.translation.override_1.metaDescription`, `sas_blog_entries.translation`.`meta_keywords` as `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation.override_1`.`meta_keywords` as `sas_blog_entries.translation.override_1.metaKeywords`, `sas_blog_entries.translation`.`content` as `sas_blog_entries.translation.content`, `sas_blog_entries.translation.override_1`.`content` as `sas_blog_entries.translation.override_1.content`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields`, `sas_blog_entries.translation.override_1`.`custom_fields` as `sas_blog_entries.translation.override_1.customFields` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` LEFT JOIN `sas_blog_entries_translation` `sas_blog_entries.translation.override_1` ON `sas_blog_entries.translation`.`sas_blog_entries_id` = `sas_blog_entries.translation.override_1`.`sas_blog_entries_id` AND `sas_blog_entries.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` LEFT JOIN (SELECT `sas_blog_entries.media.translation`.`media_id`, `sas_blog_entries.media.translation`.`alt` as `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation.override_1`.`alt` as `sas_blog_entries.media.translation.override_1.alt`, `sas_blog_entries.media.translation`.`title` as `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation.override_1`.`title` as `sas_blog_entries.media.translation.override_1.title`, `sas_blog_entries.media.translation`.`custom_fields` as `sas_blog_entries.media.translation.customFields`, `sas_blog_entries.media.translation.override_1`.`custom_fields` as `sas_blog_entries.media.translation.override_1.customFields` FROM `media_translation` `sas_blog_entries.media.translation` LEFT JOIN `media_translation` `sas_blog_entries.media.translation.override_1` ON `sas_blog_entries.media.translation`.`media_id` = `sas_blog_entries.media.translation.override_1`.`media_id` AND `sas_blog_entries.media.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.media.translation`.`language_id` = ?) `sas_blog_entries.media.media_translation` ON `sas_blog_entries.media.media_translation`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN `media` `sas_blog_entries.blogAuthor.media` ON `sas_blog_entries.blogAuthor`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` LEFT JOIN `salutation` `sas_blog_entries.blogAuthor.salutation` ON `sas_blog_entries.blogAuthor`.`salutation_id` = `sas_blog_entries.blogAuthor.salutation`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.translation`.`sas_blog_author_id`, `sas_blog_entries.blogAuthor.translation`.`description` as `sas_blog_entries.blogAuthor.translation.description`, `sas_blog_entries.blogAuthor.translation.override_1`.`description` as `sas_blog_entries.blogAuthor.translation.override_1.description`, `sas_blog_entries.blogAuthor.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.translation.customFields`, `sas_blog_entries.blogAuthor.translation.override_1`.`custom_fields` as `sas_blog_entries.blogAuthor.translation.override_1.customFields` FROM `sas_blog_author_translation` `sas_blog_entries.blogAuthor.translation` LEFT JOIN `sas_blog_author_translation` `sas_blog_entries.blogAuthor.translation.override_1` ON `sas_blog_entries.blogAuthor.translation`.`sas_blog_author_id` = `sas_blog_entries.blogAuthor.translation.override_1`.`sas_blog_author_id` AND `sas_blog_entries.blogAuthor.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.blogAuthor.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.sas_blog_author_translation` ON `sas_blog_entries.blogAuthor.sas_blog_author_translation`.`sas_blog_author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.media.translation`.`media_id`, `sas_blog_entries.blogAuthor.media.translation`.`alt` as `sas_blog_entries.blogAuthor.media.translation.alt`, `sas_blog_entries.blogAuthor.media.translation.override_1`.`alt` as `sas_blog_entries.blogAuthor.media.translation.override_1.alt`, `sas_blog_entries.blogAuthor.media.translation`.`title` as `sas_blog_entries.blogAuthor.media.translation.title`, `sas_blog_entries.blogAuthor.media.translation.override_1`.`title` as `sas_blog_entries.blogAuthor.media.translation.override_1.title`, `sas_blog_entries.blogAuthor.media.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.media.translation.customFields`, `sas_blog_entries.blogAuthor.media.translation.override_1`.`custom_fields` as `sas_blog_entries.blogAuthor.media.translation.override_1.customFields` FROM `media_translation` `sas_blog_entries.blogAuthor.media.translation` LEFT JOIN `media_translation` `sas_blog_entries.blogAuthor.media.translation.override_1` ON `sas_blog_entries.blogAuthor.media.translation`.`media_id` = `sas_blog_entries.blogAuthor.media.translation.override_1`.`media_id` AND `sas_blog_entries.blogAuthor.media.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.blogAuthor.media.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.media.media_translation` ON `sas_blog_entries.blogAuthor.media.media_translation`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.salutation.translation`.`salutation_id`, `sas_blog_entries.blogAuthor.salutation.translation`.`display_name` as `sas_blog_entries.blogAuthor.salutation.translation.displayName`, `sas_blog_entries.blogAuthor.salutation.translation.override_1`.`display_name` as `sas_blog_entries.blogAuthor.salutation.translation.override_1.displayName`, `sas_blog_entries.blogAuthor.salutation.translation`.`letter_name` as `sas_blog_entries.blogAuthor.salutation.translation.letterName`, `sas_blog_entries.blogAuthor.salutation.translation.override_1`.`letter_name` as `sas_blog_entries.blogAuthor.salutation.translation.override_1.letterName`, `sas_blog_entries.blogAuthor.salutation.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.salutation.translation.customFields`, `sas_blog_entries.blogAuthor.salutation.translation.override_1`.`custom_fields` as `sas_blog_entries.blogAuthor.salutation.translation.override_1.customFields` FROM `salutation_translation` `sas_blog_entries.blogAuthor.salutation.translation` LEFT JOIN `salutation_translation` `sas_blog_entries.blogAuthor.salutation.translation.override_1` ON `sas_blog_entries.blogAuthor.salutation.translation`.`salutation_id` = `sas_blog_entries.blogAuthor.salutation.translation.override_1`.`salutation_id` AND `sas_blog_entries.blogAuthor.salutation.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.blogAuthor.salutation.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.salutation.salutation_translation` ON `sas_blog_entries.blogAuthor.salutation.salutation_translation`.`salutation_id` = `sas_blog_entries.blogAuthor.salutation`.`id` WHERE `sas_blog_entries`.`id` IN (?)
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‘À÷¬æv…””’Â\x1DK´?"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.04 ms
(11.59%) 		1 
SELECT `sas_blog_entries`.`id` as `sas_blog_entries.id`, `sas_blog_entries`.`active` as `sas_blog_entries.active`, `sas_blog_entries`.`detail_teaser_image` as `sas_blog_entries.detailTeaserImage`, `sas_blog_entries`.`media_id` as `sas_blog_entries.mediaId`, `sas_blog_entries`.`author_id` as `sas_blog_entries.authorId`, `sas_blog_entries`.`cms_page_id` as `sas_blog_entries.cmsPageId`, `sas_blog_entries`.`cms_page_version_id` as `sas_blog_entries.cmsPageVersionId`, `sas_blog_entries.media`.`id` as `sas_blog_entries.media.id`, `sas_blog_entries.media`.`user_id` as `sas_blog_entries.media.userId`, `sas_blog_entries.media`.`media_folder_id` as `sas_blog_entries.media.mediaFolderId`, `sas_blog_entries.media`.`mime_type` as `sas_blog_entries.media.mimeType`, `sas_blog_entries.media`.`file_extension` as `sas_blog_entries.media.fileExtension`, `sas_blog_entries.media`.`uploaded_at` as `sas_blog_entries.media.uploadedAt`, `sas_blog_entries.media`.`file_name` as `sas_blog_entries.media.fileName`, `sas_blog_entries.media`.`file_size` as `sas_blog_entries.media.fileSize`, `sas_blog_entries.media`.`media_type` as `sas_blog_entries.media.mediaTypeRaw`, `sas_blog_entries.media`.`meta_data` as `sas_blog_entries.media.metaData`, `sas_blog_entries.media`.`config` as `sas_blog_entries.media.config`, `sas_blog_entries.media`.`path` as `sas_blog_entries.media.path`, `sas_blog_entries.media`.`private` as `sas_blog_entries.media.private`, `sas_blog_entries.media`.`thumbnails_ro` as `sas_blog_entries.media.thumbnailsRo`, `sas_blog_entries.media`.`created_at` as `sas_blog_entries.media.createdAt`, `sas_blog_entries.media`.`updated_at` as `sas_blog_entries.media.updatedAt`, `sas_blog_entries.media.translation.override_1.title`, `sas_blog_entries.media.translation.title`, COALESCE(`sas_blog_entries.media.translation.override_1.title`,`sas_blog_entries.media.translation.title`) as `sas_blog_entries.media.title`, `sas_blog_entries.media.translation.override_1.alt`, `sas_blog_entries.media.translation.alt`, COALESCE(`sas_blog_entries.media.translation.override_1.alt`,`sas_blog_entries.media.translation.alt`) as `sas_blog_entries.media.alt`, `sas_blog_entries.media.translation.override_1.customFields`, `sas_blog_entries.media.translation.customFields`, COALESCE(`sas_blog_entries.media.translation.override_1.customFields`,`sas_blog_entries.media.translation.customFields`) as `sas_blog_entries.media.customFields`, `sas_blog_entries`.`published_at` as `sas_blog_entries.publishedAt`, `sas_blog_entries`.`created_at` as `sas_blog_entries.createdAt`, `sas_blog_entries`.`updated_at` as `sas_blog_entries.updatedAt`, `sas_blog_entries.blogAuthor`.`id` as `sas_blog_entries.blogAuthor.id`, `sas_blog_entries.blogAuthor`.`media_id` as `sas_blog_entries.blogAuthor.mediaId`, `sas_blog_entries.blogAuthor`.`salutation_id` as `sas_blog_entries.blogAuthor.salutationId`, `sas_blog_entries.blogAuthor`.`first_name` as `sas_blog_entries.blogAuthor.firstName`, `sas_blog_entries.blogAuthor`.`last_name` as `sas_blog_entries.blogAuthor.lastName`, `sas_blog_entries.blogAuthor`.`email` as `sas_blog_entries.blogAuthor.email`, `sas_blog_entries.blogAuthor`.`display_name` as `sas_blog_entries.blogAuthor.displayName`, `sas_blog_entries.blogAuthor.media`.`id` as `sas_blog_entries.blogAuthor.media.id`, `sas_blog_entries.blogAuthor.media`.`user_id` as `sas_blog_entries.blogAuthor.media.userId`, `sas_blog_entries.blogAuthor.media`.`media_folder_id` as `sas_blog_entries.blogAuthor.media.mediaFolderId`, `sas_blog_entries.blogAuthor.media`.`mime_type` as `sas_blog_entries.blogAuthor.media.mimeType`, `sas_blog_entries.blogAuthor.media`.`file_extension` as `sas_blog_entries.blogAuthor.media.fileExtension`, `sas_blog_entries.blogAuthor.media`.`uploaded_at` as `sas_blog_entries.blogAuthor.media.uploadedAt`, `sas_blog_entries.blogAuthor.media`.`file_name` as `sas_blog_entries.blogAuthor.media.fileName`, `sas_blog_entries.blogAuthor.media`.`file_size` as `sas_blog_entries.blogAuthor.media.fileSize`, `sas_blog_entries.blogAuthor.media`.`media_type` as `sas_blog_entries.blogAuthor.media.mediaTypeRaw`, `sas_blog_entries.blogAuthor.media`.`meta_data` as `sas_blog_entries.blogAuthor.media.metaData`, `sas_blog_entries.blogAuthor.media`.`config` as `sas_blog_entries.blogAuthor.media.config`, `sas_blog_entries.blogAuthor.media`.`path` as `sas_blog_entries.blogAuthor.media.path`, `sas_blog_entries.blogAuthor.media`.`private` as `sas_blog_entries.blogAuthor.media.private`, `sas_blog_entries.blogAuthor.media`.`thumbnails_ro` as `sas_blog_entries.blogAuthor.media.thumbnailsRo`, `sas_blog_entries.blogAuthor.media`.`created_at` as `sas_blog_entries.blogAuthor.media.createdAt`, `sas_blog_entries.blogAuthor.media`.`updated_at` as `sas_blog_entries.blogAuthor.media.updatedAt`, `sas_blog_entries.blogAuthor.media.translation.override_1.title`, `sas_blog_entries.blogAuthor.media.translation.title`, COALESCE(`sas_blog_entries.blogAuthor.media.translation.override_1.title`,`sas_blog_entries.blogAuthor.media.translation.title`) as `sas_blog_entries.blogAuthor.media.title`, `sas_blog_entries.blogAuthor.media.translation.override_1.alt`, `sas_blog_entries.blogAuthor.media.translation.alt`, COALESCE(`sas_blog_entries.blogAuthor.media.translation.override_1.alt`,`sas_blog_entries.blogAuthor.media.translation.alt`) as `sas_blog_entries.blogAuthor.media.alt`, `sas_blog_entries.blogAuthor.media.translation.override_1.customFields`, `sas_blog_entries.blogAuthor.media.translation.customFields`, COALESCE(`sas_blog_entries.blogAuthor.media.translation.override_1.customFields`,`sas_blog_entries.blogAuthor.media.translation.customFields`) as `sas_blog_entries.blogAuthor.media.customFields`, `sas_blog_entries.blogAuthor`.`created_at` as `sas_blog_entries.blogAuthor.createdAt`, `sas_blog_entries.blogAuthor`.`updated_at` as `sas_blog_entries.blogAuthor.updatedAt`, `sas_blog_entries.blogAuthor.translation.override_1.description`, `sas_blog_entries.blogAuthor.translation.description`, COALESCE(`sas_blog_entries.blogAuthor.translation.override_1.description`,`sas_blog_entries.blogAuthor.translation.description`) as `sas_blog_entries.blogAuthor.description`, `sas_blog_entries.blogAuthor.translation.override_1.customFields`, `sas_blog_entries.blogAuthor.translation.customFields`, COALESCE(`sas_blog_entries.blogAuthor.translation.override_1.customFields`,`sas_blog_entries.blogAuthor.translation.customFields`) as `sas_blog_entries.blogAuthor.customFields`, (SELECT GROUP_CONCAT(HEX(`sas_blog_entries.blogCategories.mapping`.`sas_blog_category_id`) SEPARATOR '||')
                  FROM `sas_blog_blog_category` `sas_blog_entries.blogCategories.mapping`
                  WHERE `sas_blog_entries.blogCategories.mapping`.`sas_blog_entries_id` = `sas_blog_entries`.`id` ) as `sas_blog_entries.blogCategories.id_mapping`, `sas_blog_entries.cmsPage`.`id` as `sas_blog_entries.cmsPage.id`, `sas_blog_entries.cmsPage`.`version_id` as `sas_blog_entries.cmsPage.versionId`, `sas_blog_entries.cmsPage`.`type` as `sas_blog_entries.cmsPage.type`, `sas_blog_entries.cmsPage`.`entity` as `sas_blog_entries.cmsPage.entity`, `sas_blog_entries.cmsPage`.`css_class` as `sas_blog_entries.cmsPage.cssClass`, `sas_blog_entries.cmsPage`.`config` as `sas_blog_entries.cmsPage.config`, `sas_blog_entries.cmsPage`.`preview_media_id` as `sas_blog_entries.cmsPage.previewMediaId`, `sas_blog_entries.cmsPage`.`locked` as `sas_blog_entries.cmsPage.locked`, `sas_blog_entries.cmsPage`.`created_at` as `sas_blog_entries.cmsPage.createdAt`, `sas_blog_entries.cmsPage`.`updated_at` as `sas_blog_entries.cmsPage.updatedAt`, `sas_blog_entries.cmsPage.translation.override_1.name`, `sas_blog_entries.cmsPage.translation.name`, COALESCE(`sas_blog_entries.cmsPage.translation.override_1.name`,`sas_blog_entries.cmsPage.translation.name`) as `sas_blog_entries.cmsPage.name`, `sas_blog_entries.cmsPage.translation.override_1.customFields`, `sas_blog_entries.cmsPage.translation.customFields`, COALESCE(`sas_blog_entries.cmsPage.translation.override_1.customFields`,`sas_blog_entries.cmsPage.translation.customFields`) as `sas_blog_entries.cmsPage.customFields`, `sas_blog_entries.translation.override_1.title`, `sas_blog_entries.translation.title`, COALESCE(`sas_blog_entries.translation.override_1.title`,`sas_blog_entries.translation.title`) as `sas_blog_entries.title`, `sas_blog_entries.translation.override_1.slug`, `sas_blog_entries.translation.slug`, COALESCE(`sas_blog_entries.translation.override_1.slug`,`sas_blog_entries.translation.slug`) as `sas_blog_entries.slug`, `sas_blog_entries.translation.override_1.teaser`, `sas_blog_entries.translation.teaser`, COALESCE(`sas_blog_entries.translation.override_1.teaser`,`sas_blog_entries.translation.teaser`) as `sas_blog_entries.teaser`, `sas_blog_entries.translation.override_1.metaTitle`, `sas_blog_entries.translation.metaTitle`, COALESCE(`sas_blog_entries.translation.override_1.metaTitle`,`sas_blog_entries.translation.metaTitle`) as `sas_blog_entries.metaTitle`, `sas_blog_entries.translation.override_1.metaDescription`, `sas_blog_entries.translation.metaDescription`, COALESCE(`sas_blog_entries.translation.override_1.metaDescription`,`sas_blog_entries.translation.metaDescription`) as `sas_blog_entries.metaDescription`, `sas_blog_entries.translation.override_1.metaKeywords`, `sas_blog_entries.translation.metaKeywords`, COALESCE(`sas_blog_entries.translation.override_1.metaKeywords`,`sas_blog_entries.translation.metaKeywords`) as `sas_blog_entries.metaKeywords`, `sas_blog_entries.translation.override_1.content`, `sas_blog_entries.translation.content`, COALESCE(`sas_blog_entries.translation.override_1.content`,`sas_blog_entries.translation.content`) as `sas_blog_entries.content`, `sas_blog_entries.translation.override_1.customFields`, `sas_blog_entries.translation.customFields`, COALESCE(`sas_blog_entries.translation.override_1.customFields`,`sas_blog_entries.translation.customFields`) as `sas_blog_entries.customFields` FROM `sas_blog_entries` LEFT JOIN `media` `sas_blog_entries.media` ON `sas_blog_entries`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN `sas_blog_author` `sas_blog_entries.blogAuthor` ON `sas_blog_entries`.`author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN `cms_page` `sas_blog_entries.cmsPage` ON `sas_blog_entries`.`cms_page_id` = `sas_blog_entries.cmsPage`.`id` AND `sas_blog_entries`.`cms_page_version_id` = `sas_blog_entries.cmsPage`.`version_id` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields`, `sas_blog_entries.translation.override_1`.`custom_fields` as `sas_blog_entries.translation.override_1.customFields`, `sas_blog_entries.translation`.`title` as `sas_blog_entries.translation.title`, `sas_blog_entries.translation.override_1`.`title` as `sas_blog_entries.translation.override_1.title`, `sas_blog_entries.translation`.`slug` as `sas_blog_entries.translation.slug`, `sas_blog_entries.translation.override_1`.`slug` as `sas_blog_entries.translation.override_1.slug`, `sas_blog_entries.translation`.`teaser` as `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation.override_1`.`teaser` as `sas_blog_entries.translation.override_1.teaser`, `sas_blog_entries.translation`.`meta_title` as `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation.override_1`.`meta_title` as `sas_blog_entries.translation.override_1.metaTitle`, `sas_blog_entries.translation`.`meta_description` as `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation.override_1`.`meta_description` as `sas_blog_entries.translation.override_1.metaDescription`, `sas_blog_entries.translation`.`meta_keywords` as `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation.override_1`.`meta_keywords` as `sas_blog_entries.translation.override_1.metaKeywords`, `sas_blog_entries.translation`.`content` as `sas_blog_entries.translation.content`, `sas_blog_entries.translation.override_1`.`content` as `sas_blog_entries.translation.override_1.content` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` LEFT JOIN `sas_blog_entries_translation` `sas_blog_entries.translation.override_1` ON `sas_blog_entries.translation`.`sas_blog_entries_id` = `sas_blog_entries.translation.override_1`.`sas_blog_entries_id` AND `sas_blog_entries.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` LEFT JOIN (SELECT `sas_blog_entries.media.translation`.`media_id`, `sas_blog_entries.media.translation`.`alt` as `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation.override_1`.`alt` as `sas_blog_entries.media.translation.override_1.alt`, `sas_blog_entries.media.translation`.`title` as `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation.override_1`.`title` as `sas_blog_entries.media.translation.override_1.title`, `sas_blog_entries.media.translation`.`custom_fields` as `sas_blog_entries.media.translation.customFields`, `sas_blog_entries.media.translation.override_1`.`custom_fields` as `sas_blog_entries.media.translation.override_1.customFields` FROM `media_translation` `sas_blog_entries.media.translation` LEFT JOIN `media_translation` `sas_blog_entries.media.translation.override_1` ON `sas_blog_entries.media.translation`.`media_id` = `sas_blog_entries.media.translation.override_1`.`media_id` AND `sas_blog_entries.media.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.media.translation`.`language_id` = ?) `sas_blog_entries.media.media_translation` ON `sas_blog_entries.media.media_translation`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN `media` `sas_blog_entries.blogAuthor.media` ON `sas_blog_entries.blogAuthor`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.translation`.`sas_blog_author_id`, `sas_blog_entries.blogAuthor.translation`.`description` as `sas_blog_entries.blogAuthor.translation.description`, `sas_blog_entries.blogAuthor.translation.override_1`.`description` as `sas_blog_entries.blogAuthor.translation.override_1.description`, `sas_blog_entries.blogAuthor.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.translation.customFields`, `sas_blog_entries.blogAuthor.translation.override_1`.`custom_fields` as `sas_blog_entries.blogAuthor.translation.override_1.customFields` FROM `sas_blog_author_translation` `sas_blog_entries.blogAuthor.translation` LEFT JOIN `sas_blog_author_translation` `sas_blog_entries.blogAuthor.translation.override_1` ON `sas_blog_entries.blogAuthor.translation`.`sas_blog_author_id` = `sas_blog_entries.blogAuthor.translation.override_1`.`sas_blog_author_id` AND `sas_blog_entries.blogAuthor.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.blogAuthor.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.sas_blog_author_translation` ON `sas_blog_entries.blogAuthor.sas_blog_author_translation`.`sas_blog_author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.media.translation`.`media_id`, `sas_blog_entries.blogAuthor.media.translation`.`alt` as `sas_blog_entries.blogAuthor.media.translation.alt`, `sas_blog_entries.blogAuthor.media.translation.override_1`.`alt` as `sas_blog_entries.blogAuthor.media.translation.override_1.alt`, `sas_blog_entries.blogAuthor.media.translation`.`title` as `sas_blog_entries.blogAuthor.media.translation.title`, `sas_blog_entries.blogAuthor.media.translation.override_1`.`title` as `sas_blog_entries.blogAuthor.media.translation.override_1.title`, `sas_blog_entries.blogAuthor.media.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.media.translation.customFields`, `sas_blog_entries.blogAuthor.media.translation.override_1`.`custom_fields` as `sas_blog_entries.blogAuthor.media.translation.override_1.customFields` FROM `media_translation` `sas_blog_entries.blogAuthor.media.translation` LEFT JOIN `media_translation` `sas_blog_entries.blogAuthor.media.translation.override_1` ON `sas_blog_entries.blogAuthor.media.translation`.`media_id` = `sas_blog_entries.blogAuthor.media.translation.override_1`.`media_id` AND `sas_blog_entries.blogAuthor.media.translation.override_1`.`language_id` = ? WHERE `sas_blog_entries.blogAuthor.media.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.media.media_translation` ON `sas_blog_entries.blogAuthor.media.media_translation`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` LEFT JOIN (SELECT `sas_blog_entries.cmsPage.translation`.`cms_page_id`, `sas_blog_entries.cmsPage.translation`.`cms_page_version_id`, `sas_blog_entries.cmsPage.translation`.`name` as `sas_blog_entries.cmsPage.translation.name`, `sas_blog_entries.cmsPage.translation.override_1`.`name` as `sas_blog_entries.cmsPage.translation.override_1.name`, `sas_blog_entries.cmsPage.translation`.`custom_fields` as `sas_blog_entries.cmsPage.translation.customFields`, `sas_blog_entries.cmsPage.translation.override_1`.`custom_fields` as `sas_blog_entries.cmsPage.translation.override_1.customFields` FROM `cms_page_translation` `sas_blog_entries.cmsPage.translation` LEFT JOIN `cms_page_translation` `sas_blog_entries.cmsPage.translation.override_1` ON `sas_blog_entries.cmsPage.translation`.`cms_page_id` = `sas_blog_entries.cmsPage.translation.override_1`.`cms_page_id` AND `sas_blog_entries.cmsPage.translation.override_1`.`language_id` = ? AND `sas_blog_entries.cmsPage.translation`.`cms_page_version_id` = `sas_blog_entries.cmsPage.translation.override_1`.`cms_page_version_id` WHERE `sas_blog_entries.cmsPage.translation`.`language_id` = ?) `sas_blog_entries.cmsPage.cms_page_translation` ON `sas_blog_entries.cmsPage.cms_page_translation`.`cms_page_id` = `sas_blog_entries.cmsPage`.`id` AND `sas_blog_entries.cmsPage.cms_page_translation`.`cms_page_version_id` = `sas_blog_entries.cmsPage`.`version_id` WHERE (`sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?) AND `sas_blog_entries`.`id` = ? AND (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.override_1.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.override_1.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL),IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE ? OR COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.override_1.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.override_1.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL),IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> ?))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  "2025-05-13T01:14:30+00:00"
  b"\x01‘À÷¬æv…””’Â\x1DK´?"
  "%f5bd69415f6d4dc792187d326d7d944d%"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.98 ms
(5.59%) 		2 
SELECT `sas_blog_category`.`id` as `sas_blog_category.id`, `sas_blog_category`.`version_id` as `sas_blog_category.versionId`, `sas_blog_category`.`parent_id` as `sas_blog_category.parentId`, `sas_blog_category`.`parent_version_id` as `sas_blog_category.parentVersionId`, `sas_blog_category`.`after_category_id` as `sas_blog_category.afterCategoryId`, `sas_blog_category`.`level` as `sas_blog_category.level`, `sas_blog_category`.`path` as `sas_blog_category.path`, `sas_blog_category`.`child_count` as `sas_blog_category.childCount`, `sas_blog_category`.`created_at` as `sas_blog_category.createdAt`, `sas_blog_category`.`updated_at` as `sas_blog_category.updatedAt`, `sas_blog_category.translation.override_1.name`, `sas_blog_category.translation.name`, COALESCE(`sas_blog_category.translation.override_1.name`,`sas_blog_category.translation.name`) as `sas_blog_category.name`, `sas_blog_category.translation.override_1.breadcrumb`, `sas_blog_category.translation.breadcrumb`, COALESCE(`sas_blog_category.translation.override_1.breadcrumb`,`sas_blog_category.translation.breadcrumb`) as `sas_blog_category.breadcrumb`, `sas_blog_category.translation.override_1.customFields`, `sas_blog_category.translation.customFields`, COALESCE(`sas_blog_category.translation.override_1.customFields`,`sas_blog_category.translation.customFields`) as `sas_blog_category.customFields` FROM `sas_blog_category` LEFT JOIN (SELECT `sas_blog_category.translation`.`sas_blog_category_id`, `sas_blog_category.translation`.`sas_blog_category_version_id`, `sas_blog_category.translation`.`name` as `sas_blog_category.translation.name`, `sas_blog_category.translation.override_1`.`name` as `sas_blog_category.translation.override_1.name`, `sas_blog_category.translation`.`custom_fields` as `sas_blog_category.translation.customFields`, `sas_blog_category.translation.override_1`.`custom_fields` as `sas_blog_category.translation.override_1.customFields`, `sas_blog_category.translation`.`breadcrumb` as `sas_blog_category.translation.breadcrumb`, `sas_blog_category.translation.override_1`.`breadcrumb` as `sas_blog_category.translation.override_1.breadcrumb` FROM `sas_blog_category_translation` `sas_blog_category.translation` LEFT JOIN `sas_blog_category_translation` `sas_blog_category.translation.override_1` ON `sas_blog_category.translation`.`sas_blog_category_id` = `sas_blog_category.translation.override_1`.`sas_blog_category_id` AND `sas_blog_category.translation.override_1`.`language_id` = ? AND `sas_blog_category.translation`.`sas_blog_category_version_id` = `sas_blog_category.translation.override_1`.`sas_blog_category_version_id` WHERE `sas_blog_category.translation`.`language_id` = ?) `sas_blog_category.sas_blog_category_translation` ON `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_id` = `sas_blog_category`.`id` AND `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_version_id` = `sas_blog_category`.`version_id` WHERE (`sas_blog_category`.`version_id` = ?) AND (`sas_blog_category`.`id` IN (?))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‘½.»ÐqÏ­NÀ\x13=³"1"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.80 ms
(4.52%) 		1 
# blog-category-breadcrumb-extension::read
SELECT `sas_blog_category`.`id` as `sas_blog_category.id`, `sas_blog_category`.`version_id` as `sas_blog_category.versionId`, `sas_blog_category`.`parent_id` as `sas_blog_category.parentId`, `sas_blog_category`.`parent_version_id` as `sas_blog_category.parentVersionId`, `sas_blog_category`.`after_category_id` as `sas_blog_category.afterCategoryId`, `sas_blog_category`.`level` as `sas_blog_category.level`, `sas_blog_category`.`path` as `sas_blog_category.path`, `sas_blog_category`.`child_count` as `sas_blog_category.childCount`, `sas_blog_category`.`created_at` as `sas_blog_category.createdAt`, `sas_blog_category`.`updated_at` as `sas_blog_category.updatedAt`, `sas_blog_category.translation.override_1.name`, `sas_blog_category.translation.name`, COALESCE(`sas_blog_category.translation.override_1.name`,`sas_blog_category.translation.name`) as `sas_blog_category.name`, `sas_blog_category.translation.override_1.breadcrumb`, `sas_blog_category.translation.breadcrumb`, COALESCE(`sas_blog_category.translation.override_1.breadcrumb`,`sas_blog_category.translation.breadcrumb`) as `sas_blog_category.breadcrumb`, `sas_blog_category.translation.override_1.customFields`, `sas_blog_category.translation.customFields`, COALESCE(`sas_blog_category.translation.override_1.customFields`,`sas_blog_category.translation.customFields`) as `sas_blog_category.customFields` FROM `sas_blog_category` LEFT JOIN (SELECT `sas_blog_category.translation`.`sas_blog_category_id`, `sas_blog_category.translation`.`sas_blog_category_version_id`, `sas_blog_category.translation`.`name` as `sas_blog_category.translation.name`, `sas_blog_category.translation.override_1`.`name` as `sas_blog_category.translation.override_1.name`, `sas_blog_category.translation`.`custom_fields` as `sas_blog_category.translation.customFields`, `sas_blog_category.translation.override_1`.`custom_fields` as `sas_blog_category.translation.override_1.customFields`, `sas_blog_category.translation`.`breadcrumb` as `sas_blog_category.translation.breadcrumb`, `sas_blog_category.translation.override_1`.`breadcrumb` as `sas_blog_category.translation.override_1.breadcrumb` FROM `sas_blog_category_translation` `sas_blog_category.translation` LEFT JOIN `sas_blog_category_translation` `sas_blog_category.translation.override_1` ON `sas_blog_category.translation`.`sas_blog_category_id` = `sas_blog_category.translation.override_1`.`sas_blog_category_id` AND `sas_blog_category.translation.override_1`.`language_id` = ? AND `sas_blog_category.translation`.`sas_blog_category_version_id` = `sas_blog_category.translation.override_1`.`sas_blog_category_version_id` WHERE `sas_blog_category.translation`.`language_id` = ?) `sas_blog_category.sas_blog_category_translation` ON `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_id` = `sas_blog_category`.`id` AND `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_version_id` = `sas_blog_category`.`version_id` WHERE (`sas_blog_category`.`version_id` = ?) AND (`sas_blog_category`.`id` IN (?))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‘½.»ÐqÏ­NÀ\x13=³"1"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(3.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 = ? OR seo_path_info = ?))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"õ½iA_mMÇ’\x18}2m}”M"
  "blog/innovation-et-tradition-le-nouveau-design-de-la-scene-du-prix-du-cinema-suisse"
  "blog/innovation-et-tradition-le-nouveau-design-de-la-scene-du-prix-du-cinema-suisse/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(3.49%) 		1 
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.override_1.title`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.override_1.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.override_1.alt`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.override_1.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.override_1.customFields`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.override_1.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.override_1`.`alt` as `cms_section.backgroundMedia.translation.override_1.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.override_1`.`title` as `cms_section.backgroundMedia.translation.override_1.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.override_1`.`custom_fields` as `cms_section.backgroundMedia.translation.override_1.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_section.backgroundMedia.translation.override_1` ON `cms_section.backgroundMedia.translation`.`media_id` = `cms_section.backgroundMedia.translation.override_1`.`media_id` AND `cms_section.backgroundMedia.translation.override_1`.`language_id` = ? WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?))) ORDER BY `cms_section`.`position` ASC
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‘À÷¬æv…””’Á\x7FÆ;ä"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.61 ms
(3.44%) 		1 
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.override_1.title`, `media.translation.title`, COALESCE(`media.translation.override_1.title`,`media.translation.title`) as `media.title`, `media.translation.override_1.alt`, `media.translation.alt`, COALESCE(`media.translation.override_1.alt`,`media.translation.alt`) as `media.alt`, `media.translation.override_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.override_1.customFields`,`media.translation.customFields`) as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation.override_1`.`alt` as `media.translation.override_1.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation.override_1`.`title` as `media.translation.override_1.title`, `media.translation`.`custom_fields` as `media.translation.customFields`, `media.translation.override_1`.`custom_fields` as `media.translation.override_1.customFields` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.override_1` ON `media.translation`.`media_id` = `media.translation.override_1`.`media_id` AND `media.translation.override_1`.`language_id` = ? WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"\x01‘Á\x07U·sü§Ü©¤£Â“!"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(3.41%) 		1 
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.override_1.title`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.override_1.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.override_1.alt`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.override_1.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.override_1.customFields`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.override_1.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.override_1`.`alt` as `cms_block.backgroundMedia.translation.override_1.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.override_1`.`title` as `cms_block.backgroundMedia.translation.override_1.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.override_1`.`custom_fields` as `cms_block.backgroundMedia.translation.override_1.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_block.backgroundMedia.translation.override_1` ON `cms_block.backgroundMedia.translation`.`media_id` = `cms_block.backgroundMedia.translation.override_1`.`media_id` AND `cms_block.backgroundMedia.translation.override_1`.`language_id` = ? WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?))) ORDER BY `cms_block`.`position` ASC
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‘Á\x06\x04Ïpú€Šß±„\x1F‘¢"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(3.24%) 		1 
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.override_1.title`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.override_1.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.override_1.alt`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.override_1.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.override_1.customFields`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.override_1.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.override_1`.`alt` as `cms_section.backgroundMedia.translation.override_1.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.override_1`.`title` as `cms_section.backgroundMedia.translation.override_1.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.override_1`.`custom_fields` as `cms_section.backgroundMedia.translation.override_1.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_section.backgroundMedia.translation.override_1` ON `cms_section.backgroundMedia.translation`.`media_id` = `cms_section.backgroundMedia.translation.override_1`.`media_id` AND `cms_section.backgroundMedia.translation.override_1`.`language_id` = ? WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01æÅ-Ú»rÂâ÷~cÌK?┌"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(3.22%) 		1 
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.override_1.name`, `cms_page.translation.name`, COALESCE(`cms_page.translation.override_1.name`,`cms_page.translation.name`) as `cms_page.name`, `cms_page.translation.override_1.customFields`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.override_1.customFields`,`cms_page.translation.customFields`) as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation.override_1`.`name` as `cms_page.translation.override_1.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields`, `cms_page.translation.override_1`.`custom_fields` as `cms_page.translation.override_1.customFields` FROM `cms_page_translation` `cms_page.translation` LEFT JOIN `cms_page_translation` `cms_page.translation.override_1` ON `cms_page.translation`.`cms_page_id` = `cms_page.translation.override_1`.`cms_page_id` AND `cms_page.translation.override_1`.`language_id` = ? AND `cms_page.translation`.`cms_page_version_id` = `cms_page.translation.override_1`.`cms_page_version_id` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01æÅ-Ú»rÂâ÷~cÌK?┌"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(3.08%) 		1 
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.override_1.title`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.override_1.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.override_1.alt`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.override_1.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.override_1.customFields`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.override_1.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.override_1`.`alt` as `cms_block.backgroundMedia.translation.override_1.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.override_1`.`title` as `cms_block.backgroundMedia.translation.override_1.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.override_1`.`custom_fields` as `cms_block.backgroundMedia.translation.override_1.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_block.backgroundMedia.translation.override_1` ON `cms_block.backgroundMedia.translation`.`media_id` = `cms_block.backgroundMedia.translation.override_1`.`media_id` AND `cms_block.backgroundMedia.translation.override_1`.`language_id` = ? WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?)))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01æÅ-Ú»rÂâ÷~c▀\eíÑ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(2.69%) 		1 
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.override_1.config`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.override_1.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.override_1.customFields`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.override_1.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation.override_1`.`config` as `cms_slot.translation.override_1.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields`, `cms_slot.translation.override_1`.`custom_fields` as `cms_slot.translation.override_1.customFields` FROM `cms_slot_translation` `cms_slot.translation` LEFT JOIN `cms_slot_translation` `cms_slot.translation.override_1` ON `cms_slot.translation`.`cms_slot_id` = `cms_slot.translation.override_1`.`cms_slot_id` AND `cms_slot.translation.override_1`.`language_id` = ? AND `cms_slot.translation`.`cms_slot_version_id` = `cms_slot.translation.override_1`.`cms_slot_version_id` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?)))
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01æÅ-Ú░sÒé┌|]\x10i`╚"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(2.69%) 		1 
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.override_1.config`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.override_1.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.override_1.customFields`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.override_1.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation.override_1`.`config` as `cms_slot.translation.override_1.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields`, `cms_slot.translation.override_1`.`custom_fields` as `cms_slot.translation.override_1.customFields` FROM `cms_slot_translation` `cms_slot.translation` LEFT JOIN `cms_slot_translation` `cms_slot.translation.override_1` ON `cms_slot.translation`.`cms_slot_id` = `cms_slot.translation.override_1`.`cms_slot_id` AND `cms_slot.translation.override_1`.`language_id` = ? AND `cms_slot.translation`.`cms_slot_version_id` = `cms_slot.translation.override_1`.`cms_slot_version_id` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?))) ORDER BY `cms_slot`.`slot` ASC
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‘Á\x065Ip\x08•[Õ¶Ì'£†"
  b"\x01‘Á\x07!‰rx¤Òv\x05¾ŒŒó"
  b"\x01‘Á\x07‹UuO‘Ês·Ð¬£X"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(2.54%) 		1 
SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = ? AND `is_canonical` = 1 AND
                  `sales_channel_id` = ? AND `language_id` IN (?, ?)
Parameters: 
[
  "/sas_blog/0191c0f7ace67685949492c21d4bb43f"
  b"õ½iA_mMÇ’\x18}2m}”M"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(1.90%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"”QGèÇÿOo¹Ð3ªEÁ”\t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(1.77%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(1.13%) 		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.19 ms
(1.05%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.89%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"õ½iA_mMÇ’\x18}2m}”M"
  "uH1x4wnNlYhHgnrddxVAef3GxjUxDb4t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.87%) 		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‘x•'òra‰™Ù$ÜÎ\n
    ë
    """
  b"p\fÆ©uðEe”á¥TvÙ\x0F\x0E"
  b"•\x12Ù×>ºI\x04·GïÞï\r\x1C®"
  b"×?Û\x13r\x19ByürHÕNC`\n"
  b"º\x13gÔ€±K˜±´Ö½åü‰æ"
  b"\x01ô\x00ÆþH{ñü6Amj\rLÿ"
  b"…Ì\x13AƒÓI†¤–Iî<\x13>Ð"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.85%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "uH1x4wnNlYhHgnrddxVAef3GxjUxDb4t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.79%) 		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"õ½iA_mMÇ’\x18}2m}”M"
  b"q\x01œ¾ \x07Hȇ9\x04[\x05‹§\x01"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.76%) 		1 
# sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters: 
[
  b"\x01‘×jk\x11z\x12½€à\x1E\x1Ee\x18%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.76%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "fr-FR"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.50%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.47%) 		1 
SELECT active FROM `app` WHERE name = ?
Parameters: 
[
  "ReqserApp"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(0.42%) 		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.07 ms
(0.41%) 		1 
SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = ?
Parameters: 
[
  b"õ½iA_mMÇ’\x18}2m}”M"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(0.40%) 		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.05 ms
(0.31%) 		1 
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters: 
[
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
]
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.