Query Metrics
34
Database Queries
31
Different statements
114.38 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
12.77 ms (11.16%) |
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`.`track_offcanvas_cart` as `sales_channel_analytics.trackOffcanvasCart`, `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Á:Wc|¸—º\x02\x19ª<Oé"
]
|
||||||||||||||||||||||||
|
12.55 ms (10.97%) |
1 |
SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = ? AND `dreisc_seo_redirect`.`source_type` = ? AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = ? AND `dreisc_seo_redirect`.`source_path` = ?))
Parameters:
[ true "url" b"k:ßè\r+Iå®öÂ\x7Fˆ°×" "lexikon/w" ] |
||||||||||||||||||||||||
|
11.82 ms (10.33%) |
1 |
SELECT `cbax_lexicon_entry`.`id` as `cbax_lexicon_entry.id`, `cbax_lexicon_entry`.`import_id` as `cbax_lexicon_entry.importId`, `cbax_lexicon_entry`.`impressions` as `cbax_lexicon_entry.impressions`, `cbax_lexicon_entry`.`date` as `cbax_lexicon_entry.date`, `cbax_lexicon_entry`.`link` as `cbax_lexicon_entry.link`, `cbax_lexicon_entry`.`link_target` as `cbax_lexicon_entry.linkTarget`, `cbax_lexicon_entry`.`listing_type` as `cbax_lexicon_entry.listingType`, `cbax_lexicon_entry`.`product_stream_id` as `cbax_lexicon_entry.productStreamId`, `cbax_lexicon_entry`.`product_layout` as `cbax_lexicon_entry.productLayout`, `cbax_lexicon_entry`.`product_template` as `cbax_lexicon_entry.productTemplate`, `cbax_lexicon_entry`.`product_slider_width` as `cbax_lexicon_entry.productSliderWidth`, `cbax_lexicon_entry`.`product_sorting` as `cbax_lexicon_entry.productSorting`, `cbax_lexicon_entry`.`product_limit` as `cbax_lexicon_entry.productLimit`, `cbax_lexicon_entry`.`attribute2` as `cbax_lexicon_entry.attribute2`, `cbax_lexicon_entry`.`attribute3` as `cbax_lexicon_entry.attribute3`, `cbax_lexicon_entry`.`media2_id` as `cbax_lexicon_entry.media2Id`, `cbax_lexicon_entry`.`media3_id` as `cbax_lexicon_entry.media3Id`, `cbax_lexicon_entry`.`created_at` as `cbax_lexicon_entry.createdAt`, `cbax_lexicon_entry`.`updated_at` as `cbax_lexicon_entry.updatedAt`, `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation.title` as `cbax_lexicon_entry.title`, `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation.keyword` as `cbax_lexicon_entry.keyword`, `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation.description` as `cbax_lexicon_entry.description`, `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation.descriptionLong` as `cbax_lexicon_entry.descriptionLong`, `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation.linkDescription` as `cbax_lexicon_entry.linkDescription`, `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation.altCmsPageLexicon` as `cbax_lexicon_entry.altCmsPageLexicon`, `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation.metaTitle` as `cbax_lexicon_entry.metaTitle`, `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation.metaKeywords` as `cbax_lexicon_entry.metaKeywords`, `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation.metaDescription` as `cbax_lexicon_entry.metaDescription`, `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation.headline` as `cbax_lexicon_entry.headline`, `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation.attribute1` as `cbax_lexicon_entry.attribute1`, `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation.attribute4` as `cbax_lexicon_entry.attribute4`, `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation.attribute5` as `cbax_lexicon_entry.attribute5`, `cbax_lexicon_entry.translation.attribute6`, `cbax_lexicon_entry.translation.attribute6` as `cbax_lexicon_entry.attribute6` FROM `cbax_lexicon_entry` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation`.`keyword` as `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation`.`description` as `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation`.`description_long` as `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation`.`link_description` as `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation`.`alt_cms_page_lexicon` as `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation`.`meta_title` as `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation`.`meta_keywords` as `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation`.`meta_description` as `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation`.`headline` as `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation`.`attribute1` as `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation`.`attribute4` as `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation`.`attribute5` as `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation`.`attribute6` as `cbax_lexicon_entry.translation.attribute6` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = ?) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE `cbax_lexicon_entry`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‹³Êž\x06qµšdže\x1A"¸" b"\x01Ž~»òEpÀ¬ß\x0E@*hý" b"\x01Ž\x0E•_Âpòˆš0!\fá\x15\r" b"\x01Ž\\x1C\x15]pÊ»¦°iÅÒ]Ù" b"\x01\x0EׯÏtƧºTàfé_Ý" b"±JÈe{tO{»{翲CD"" b"\x01\x11¡[CpX—Ž&\x18\x1AEŽ" b"\x01’\x05\x04\x12ŠrŸ\x05Ä'ð†:£" b"\x01“º[½q¯‚»\x0FZÅ:0\x7F" b"\x01”Ö{DQp\f†3\x1Fѽ%ê~" b"\x01•7\x7F(êsLöÚpDÒš" b"\x01–{ \x0EvÑ«‡pŽ(#òx" b"\x01–©·³!pˆ¹\x13\x1F3Œí"" b"\x01–ÎI,wp]½…ÕÛÐö¨A" b"5|\tÒñjN\x02«â·Œ‚ã\x0F—" b"\x01˜ƒÇ° s;‡ œÅo\x0Ew" b"1…¹{~\x1DFOž§\fù¶tÿï" b"¢¡k±ø\x07Jõ¨‰ú¡ƒÏ–´" b"\x18=LÎ\e\rKºª\x7Fu¾é\x05 " b"lƒ+&¿\x02C+±^\x15‚F\x03D8" b"—Qµ[èhF\x05®°ÿdJì" b""" \x01™”kKíp\n ¸Xñ…þŽÝ\x01 """ b"¡\x19nWûÛLí¥¨‰\x19Ú\x0E–%" b"\x01ŽcJ\x14\x15sŠ£a˜Ã_s " b"8Ï=C™˜M\x1E¹‰\x7FÁX}\f‚" b"êy\eÏÄ\x00GƤøuµ~\x02ô" b"߶\x05ÀãŒBˆ®D\x15sP|Ã[" b"*†ÐÑLdDm»ÛbU\x06YŽÔ" b"¦O\x03™cuKB†\x7FÔª¢Ùºr" b"j“Ž#V\eM\x18…imVv"\x1C\x06" b"׶%sx÷Os¼LÙT¹Å–å" b""" [ j²'\vLè‘}°Mø\n Û< """ b"ËuÔ™‰÷AlŽYFÌVSk" b""" Ôß\n ‡›"HC°ÑG&\f@T& """ b"æéO70+I\x06§´\x1AÚT\x16“" b"9OÓF™@v¾\x07²\x128¯õ·" b"ÿ#D\x14Ê}FÍ·¬p‹‹¦¢\x1D" b"F»}û€ÜNW»ø´¹îoâ+" b""" \x18ûB³\n NR†¼„¬@s\x17\x15 """ b"\tíDZ\x01VFõœ@4b\x04€Žj" b"´1à\x02COAŽŸ:»Ž-V6¬" b"è\x1D8Kð\fH\x12#£¼KVU¬" b"·\v[Ü\rñE\x04Sî4Â]gM" b"@ ¼tØ\rAÒƒÔ'èä?C" b"ªz|î,ñF™<\x012¦`Ѧ" b"†áÚ…-ŒEÀ ŽçÕ]Û;V" b"$>\H–ÃCÜ·Üí\x11¶4¿·" b"ï\x11\x1F=|FE#€”ÒZ=C9ú" b"é\vë¼ú"C¿Ž¨ÃÔ»Ê\x0Fì" b"\x16Ëñ\x10ü8Aµ´\x1AS\x12(Ñè»" b"-üÇ\x0F>BJ\x1F‹>F©"Ûåê" b"\x02Â×r3OD)Ž\x1FÛù1߯·" b"ß6\x03Ý4N#µ\x07„j\x19¾cc" b"\x05…ùù\x18š@ë®iõŠµÅ€Ñ" b"OÒ=Ží†G0’ý¾-þ-t·" b"šDƒ‚§N+¬›‰\x00Øk—4" b"tãÏ*ï\vD†\x00Ú®"Á²K" b"íÑÉP\x0FÖA\x16¢õPTe·\x1A\x17" b"\x7F`_MIòN\x13º›§-\x05õ—" b"Y·œ];gOœšÌz5º>$Ø" b"ÔE…=\x1CwK‚ƒ;þ\x10¬¤ðS" b"KŠZ²“\x10A±…œ\x1D3ñO\x19‹" b"Õ»W×qíI¾Bêô\x18L–\r" b"¨\x1C\x7Fn~ÇM{²\x03íW™9)" b"¨…\x14\x08v’LŒ€²1¹Lë›" ] |
||||||||||||||||||||||||
|
8.99 ms (7.86%) |
1 |
SELECT `cbax_lexicon_entry`.`id` as `cbax_lexicon_entry.id`, `cbax_lexicon_entry`.`import_id` as `cbax_lexicon_entry.importId`, `cbax_lexicon_entry`.`impressions` as `cbax_lexicon_entry.impressions`, `cbax_lexicon_entry`.`date` as `cbax_lexicon_entry.date`, `cbax_lexicon_entry`.`link` as `cbax_lexicon_entry.link`, `cbax_lexicon_entry`.`link_target` as `cbax_lexicon_entry.linkTarget`, `cbax_lexicon_entry`.`listing_type` as `cbax_lexicon_entry.listingType`, `cbax_lexicon_entry`.`product_stream_id` as `cbax_lexicon_entry.productStreamId`, `cbax_lexicon_entry`.`product_layout` as `cbax_lexicon_entry.productLayout`, `cbax_lexicon_entry`.`product_template` as `cbax_lexicon_entry.productTemplate`, `cbax_lexicon_entry`.`product_slider_width` as `cbax_lexicon_entry.productSliderWidth`, `cbax_lexicon_entry`.`product_sorting` as `cbax_lexicon_entry.productSorting`, `cbax_lexicon_entry`.`product_limit` as `cbax_lexicon_entry.productLimit`, `cbax_lexicon_entry`.`attribute2` as `cbax_lexicon_entry.attribute2`, `cbax_lexicon_entry`.`attribute3` as `cbax_lexicon_entry.attribute3`, `cbax_lexicon_entry`.`media2_id` as `cbax_lexicon_entry.media2Id`, `cbax_lexicon_entry`.`media3_id` as `cbax_lexicon_entry.media3Id`, `cbax_lexicon_entry`.`created_at` as `cbax_lexicon_entry.createdAt`, `cbax_lexicon_entry`.`updated_at` as `cbax_lexicon_entry.updatedAt`, `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation.title` as `cbax_lexicon_entry.title`, `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation.keyword` as `cbax_lexicon_entry.keyword`, `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation.description` as `cbax_lexicon_entry.description`, `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation.descriptionLong` as `cbax_lexicon_entry.descriptionLong`, `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation.linkDescription` as `cbax_lexicon_entry.linkDescription`, `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation.altCmsPageLexicon` as `cbax_lexicon_entry.altCmsPageLexicon`, `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation.metaTitle` as `cbax_lexicon_entry.metaTitle`, `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation.metaKeywords` as `cbax_lexicon_entry.metaKeywords`, `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation.metaDescription` as `cbax_lexicon_entry.metaDescription`, `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation.headline` as `cbax_lexicon_entry.headline`, `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation.attribute1` as `cbax_lexicon_entry.attribute1`, `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation.attribute4` as `cbax_lexicon_entry.attribute4`, `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation.attribute5` as `cbax_lexicon_entry.attribute5`, `cbax_lexicon_entry.translation.attribute6`, `cbax_lexicon_entry.translation.attribute6` as `cbax_lexicon_entry.attribute6` FROM `cbax_lexicon_entry` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation`.`keyword` as `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation`.`description` as `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation`.`description_long` as `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation`.`link_description` as `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation`.`alt_cms_page_lexicon` as `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation`.`meta_title` as `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation`.`meta_keywords` as `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation`.`meta_description` as `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation`.`headline` as `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation`.`attribute1` as `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation`.`attribute4` as `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation`.`attribute5` as `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation`.`attribute6` as `cbax_lexicon_entry.translation.attribute6` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = ?) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE `cbax_lexicon_entry`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"5|\tÒñjN\x02«â·Œ‚ã\x0F—" ] |
||||||||||||||||||||||||
|
8.40 ms (7.35%) |
1 |
-- Lexicon getCmsPage::read 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.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.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`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` 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` = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01Šd#cÌsy¿MÞ}v?HK" ] |
||||||||||||||||||||||||
|
8.35 ms (7.30%) |
1 |
-- theme-service::resolve-media::read SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.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`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)) AND (`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" false true "product_download" b"R\x11È"J`A·¡BöáwhK{" b"\x7FLÕc:\x04JW¯¸|fŠÅo©" ] |
||||||||||||||||||||||||
|
7.19 ms (6.29%) |
1 |
SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`language_id` = ? AND `seo_url`.`sales_channel_id` = ? AND `seo_url`.`route_name` = ? AND `seo_url`.`path_info` = ? AND `seo_url`.`is_deleted` = ? AND `seo_url`.`is_canonical` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"i„öTY#Hêh€Ã_MPÂ" "frontend.cbax.lexicon.listing" "/cbax/lexicon/listing/W" 0 1 ] |
||||||||||||||||||||||||
|
7.06 ms (6.18%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"i„öTY#Hêh€Ã_MPÂ" "Sendinblue.%" ] |
||||||||||||||||||||||||
|
6.26 ms (5.48%) |
2 |
SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> ?)
Parameters:
[
null
]
|
||||||||||||||||||||||||
|
4.66 ms (4.07%) |
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:
[]
|
||||||||||||||||||||||||
|
3.57 ms (3.12%) |
1 |
-- seo_url::replacement SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters:
[ "/navigation/4912bdd9d4c042098b5e9e7478cd9dd6" "/navigation/c80366c5226f45ac82449e3a3f0b8554" "/navigation/018a986c0c4a723b83d5960ccff667f5" "/navigation/5823b6e8cb914633acc74170f3c77f02" "/navigation/dd140f7d0b994c06b023ee7cde2201a4" "/navigation/76b109f7f2d44034a0c0447f671a4503" "/navigation/3bddd8e8619e40cf91ff1518c797d4bf" "/navigation/dc41fb6b09814c76b08c03e40fe5eb0a" "/navigation/5c48d65e3c4e4e27b4df712e66aed602" "/navigation/1ac4c3cf38f44ae39135cd3e4567d36a" "/navigation/385ba29df28849b088bb29f6d9dce9c5" "/navigation/444fabf3549f413ba0fdf72cc4b885c9" "/navigation/4b854ba426344e1b9ff3da51fa8ecf23" "/navigation/7dd915fb41ee4ff2a21378afb1b6ce37" "/navigation/cb9ff02bc6e14c4c989c21af04a3786a" "/navigation/61fe82c5fb5b4e2cb5299f1e987d20d4" "/navigation/cf8b7678f7854fcdbb9d97123f07e8dd" "/navigation/d3e0eb6222134422b7281c6751c1fc6c" "/navigation/b82de77f91e74a0c98811854bc0b3a7c" "/navigation/ee45615539294876a9c21bdbd866c7f4" "/navigation/dd6902bc5e0245899ab4837358e372d3" "/navigation/019cae10fe3c7485baa1c77e9db41fde" "/navigation/0077b6e61bb34418affe5490289418ab" "/navigation/01931f4d0e4e762a9e2371e1d626d12c" "/navigation/019897dd94a27c8ea23dff42540848c8" "/navigation/04e5f5b673f847a089cbed532321dfc4" "/navigation/086b89f81e8c4a05a59b1068210db735" "/navigation/13fc36da34a1482f87f736af8cc0ef60" "/navigation/25171e8aa3114ccf8f010554b0386ee5" "/navigation/26e7ffd6ef8244ba90a8555f68683eb5" "/navigation/2c3253cb458b4dd9916196a5891b4dd9" "/navigation/32956a3d7fe040349e0589460051bb2a" "/navigation/338d19185ae342f3acdfec0f23ebb4fb" "/navigation/4af44b3637fe437087030cf990ce693d" "/navigation/ad3da067904c461baba07391c0f023e5" "/navigation/ca4dbd63d30c4ffcb1ea5d633f597978" "/navigation/cc931fdc54534d9aba33b7529a7d30a0" "/navigation/e541a725803d41708f7dc129d567739f" "/navigation/e56ce6de4c1b44e38c56a9c59d0ca812" "/navigation/f89c121dd216458a81922f507aa24edf" "/navigation/fd0eb548ccda4b46b25c0a17e1b2696f" "/navigation/62cfdd15304b46d9ae9c9ddac4a24536" "/navigation/018d1bebfedc7b65a267aa983ff97e69" "/navigation/3e15316a11a94370a995f2cd5d906449" "/navigation/6f1984108a3c4d939aa38fb4985f6844" "/navigation/61497408e8d2444ea1e756bcf10f19f1" "/navigation/018b5c1848fb7eb584c55d0d9e9fc96f" "/navigation/0196aae9606a7de49157ac37aeadc4b0" "/navigation/0196aae9b4ce7b5dbd1a833d5295318c" "/navigation/02e9b55b435045949d3849cfcdc5b316" "/navigation/122090eb5ba3469d8858204a6a2998c1" "/navigation/e374de9754e647d7973a7b36d0057814" "/navigation/5e1e94f100ea4a44b82b49cf0c9ee9cc" "/navigation/d97162e581be45f29254cbcf0d86b3a4" "/navigation/0191313c8ec57587b0a40b74c992c61f" "/navigation/dfbea89f5a7d4503a32b24d1457dfd3e" "/navigation/0198c7ccf1eb784986c8aac35e3b4de0" "/navigation/ef83486861004b3e98f011cb75a2c524" "/navigation/f03cb2fe004740b3904490014117d170" "/navigation/767aacbdc90f4830a0574960a2a84489" "/navigation/bb0722914ec8479fb167336e7275ba5e" "/navigation/75ee129fd62e4356a518e6b6b73aa89f" "/cbax/lexicon/listing/A" "/cbax/lexicon/listing/B" "/cbax/lexicon/listing/C" "/cbax/lexicon/listing/D" "/cbax/lexicon/listing/E" "/cbax/lexicon/listing/F" "/cbax/lexicon/listing/G" "/cbax/lexicon/listing/I" "/cbax/lexicon/listing/L" "/cbax/lexicon/listing/M" "/cbax/lexicon/listing/O" "/cbax/lexicon/listing/P" "/cbax/lexicon/listing/R" "/cbax/lexicon/listing/S" "/cbax/lexicon/listing/T" "/cbax/lexicon/listing/V" "/cbax/lexicon/listing/W" "/cbax/lexicon/index" "/cbax/lexicon/content" "/cbax/lexicon/detail/357c09d2f16a4e02abe2b78c82e30f97" b"/»_ââšMpªXTÎ|ãâ\v" b"i„öTY#Hêh€Ã_MPÂ" ] |
||||||||||||||||||||||||
|
2.66 ms (2.32%) |
1 |
-- Lexicon getCmsPage::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `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`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.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`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` 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"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01Šd#cÌsy¿MÞ}v´fH" b"\x01Šd#cÍq–’\x12¹³x\e˜O" b"\x01Šd#cÍq–’\x12¹³y%Iê" b"\x01Šd#cÍq–’\x12¹³{\x0F´U" ] |
||||||||||||||||||||||||
|
2.59 ms (2.27%) |
1 |
-- Lexicon getCmsPage::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `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`.`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`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.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`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` 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"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01Šd#cÌsy¿MÞ}vñ\x0E" b"\x01Šd#cÌsy¿MÞ}wT“U" ] |
||||||||||||||||||||||||
|
2.37 ms (2.07%) |
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"i„öTY#Hêh€Ã_MPÂ" b"æwŒ™’SLŸ˜K£«%¿æ7" ] |
||||||||||||||||||||||||
|
2.03 ms (1.78%) |
2 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `id` = ?
Parameters:
[ b"\x0FŘD¦{BɼfËo\v;N‡" b"\x0FŘD¦{BɼfËo\v;N‡" ] |
||||||||||||||||||||||||
|
2.03 ms (1.77%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||
|
1.88 ms (1.65%) |
1 |
-- Lexicon getCmsPage::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `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`.`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`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.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`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` 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"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01Šd#cÌsy¿MÞ}v?HK" ] |
||||||||||||||||||||||||
|
1.83 ms (1.60%) |
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:
[] |
||||||||||||||||||||||||
|
1.82 ms (1.59%) |
1 |
-- seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"i„öTY#Hêh€Ã_MPÂ" "lexikon/w" "lexikon/w/" ] |
||||||||||||||||||||||||
|
1.33 ms (1.17%) |
1 |
SELECT `cbax_lexicon_entry`.`id` FROM `cbax_lexicon_entry` LEFT JOIN `cbax_lexicon_sales_channel` `cbax_lexicon_entry.saleschannels` ON `cbax_lexicon_entry`.`id` = `cbax_lexicon_entry.saleschannels`.`cbax_lexicon_entry_id` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = ?) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE ((`cbax_lexicon_entry`.`date` <= ?) AND `cbax_lexicon_entry.saleschannels`.`sales_channel_id` = ? AND (COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ?)) GROUP BY `cbax_lexicon_entry`.`id` ORDER BY MIN(COALESCE(`cbax_lexicon_entry.translation.title`)) ASC
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" "2026-04-02 22:32:48" b"i„öTY#Hêh€Ã_MPÂ" "W%" "&W%" "#W%" "+W%" "-W%" "@W%" ] |
||||||||||||||||||||||||
|
0.81 ms (0.70%) |
1 |
SELECT `cbax_lexicon_entry`.`id` FROM `cbax_lexicon_entry` LEFT JOIN `cbax_lexicon_sales_channel` `cbax_lexicon_entry.saleschannels` ON `cbax_lexicon_entry`.`id` = `cbax_lexicon_entry.saleschannels`.`cbax_lexicon_entry_id` WHERE ((`cbax_lexicon_entry`.`date` <= ?) AND `cbax_lexicon_entry.saleschannels`.`sales_channel_id` = ?) GROUP BY `cbax_lexicon_entry`.`id`
Parameters:
[ "2026-04-02 22:32:48" b"i„öTY#Hêh€Ã_MPÂ" ] |
||||||||||||||||||||||||
|
0.52 ms (0.45%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"i„öTY#Hêh€Ã_MPÂ" "3HPWGWqZSHZ5D88u9A398VLiFuvWnc2N" ] |
||||||||||||||||||||||||
|
0.48 ms (0.42%) |
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:
[]
|
||||||||||||||||||||||||
|
0.44 ms (0.38%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||
|
0.44 ms (0.38%) |
1 |
SELECT HEX(id) as id, name FROM language
Parameters:
[] |
||||||||||||||||||||||||
|
0.34 ms (0.30%) |
1 |
SELECT DISTINCT `technical_name` FROM `theme_runtime_config` WHERE `technical_name` IS NOT NULL
Parameters:
[] |
||||||||||||||||||||||||
|
0.29 ms (0.25%) |
1 |
SELECT path FROM category WHERE id = ?
Parameters:
[
b"\x0FŘD¦{BɼfËo\v;N‡"
]
|
||||||||||||||||||||||||
|
0.28 ms (0.25%) |
1 |
SELECT `theme_id`, `technical_name`, `resolved_config`, `view_inheritance`, `script_files`, `icon_sets`, `updated_at` FROM `theme_runtime_config` WHERE `technical_name` = ?
Parameters:
[
"NetzhautMPlusM"
]
|
||||||||||||||||||||||||
|
0.24 ms (0.21%) |
2 |
SELECT url FROM sales_channel_domain
Parameters:
[] |
||||||||||||||||||||||||
|
0.22 ms (0.19%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.15 ms (0.13%) |
1 |
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.