GET https://staging.luminairestotal.fr/navigation/343add50aba94e7ebbda2660a57a3c48

Response
200 OK
IP
216.73.216.50
Profiled on
Token
e79225

Query Metrics

82 Database Queries
55 Different statements
30.54 ms Query time

Queries

Group similar statements

#▲ Time Info
1 0.09 ms 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.16 ms 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name AS composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.36 ms 
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
4 0.10 ms 
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
5 0.44 ms 
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "les-cables-in-lite"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.30 ms 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "qo46eKtH0QnOOAb9VSo2tKpNBi2kPv9S"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.19 ms 
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  b"\x07\x04ÅT¥YOΨ•ã8˜<åö"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.34 ms 
SELECT `acris_rrp_price`.`id` FROM `acris_rrp_price` LEFT JOIN `acris_rrp_rule` `acris_rrp_price.rules.mapping` ON `acris_rrp_price`.`id` = `acris_rrp_price.rules.mapping`.`rrp_id`  LEFT JOIN `rule` `acris_rrp_price.rules` ON `acris_rrp_price.rules.mapping`.`rule_id` = `acris_rrp_price.rules`.`id`  WHERE (`acris_rrp_price`.`version_id` = ?) AND ((`acris_rrp_price`.`active` = ? AND (`acris_rrp_price.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR `acris_rrp_price.rules`.`id` <=> ?))) GROUP BY `acris_rrp_price`.`id` ORDER BY MAX(`acris_rrp_price`.`priority`) DESC
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  b"ñ\x174IyÁ%.\e²4ü▄s"ó"
  b"]└ã\rù\x16O<ÇAÅÊO\x7F¬╗"
  b"Ë\x1F\eÙ¨\x17BУ'Å;█ûfæ"
  b"ÔÍžôõ\vNá©\x10M\x1CD¢¾—"
  b"ð-É\f4K@ ¥1\x01kMiàP"
  b"Qr╠\v®┤JÑÅò╩‗\x1Fòı""
  b"‗qÄü\x07IEl¢<j@)/Õ\x07"
  b"\x10qûÑ\x15nF\x16§†;ÉÙ±ö9"
  b"E†ýi–°Lc„AOÊ™&­Ÿ"
  b"ýeok¸ÏL\x17¬çÖ%Û5oj"
  b"\x0Eô“+V\x15K˜·§îcGÚ§O"
  b""âÛEÀA@źmŸéxÉQm"
  b"Ђµ—F\N\x05­Æd+C¦° "
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.45 ms 
SELECT `acris_rrp_price`.`id` AS `acris_rrp_price.id`, `acris_rrp_price`.`version_id` AS `acris_rrp_price.versionId`, `acris_rrp_price`.`active` AS `acris_rrp_price.active`, `acris_rrp_price`.`priority` AS `acris_rrp_price.priority`, `acris_rrp_price`.`display_tax` AS `acris_rrp_price.displayTax`, `acris_rrp_price`.`fallback_price` AS `acris_rrp_price.fallbackPrice`, `acris_rrp_price`.`rrp_representation` AS `acris_rrp_price.rrpRepresentation`, `acris_rrp_price`.`box_display` AS `acris_rrp_price.boxDisplay`, `acris_rrp_price`.`detail_display` AS `acris_rrp_price.detailDisplay`, `acris_rrp_price`.`created_at` AS `acris_rrp_price.createdAt`, `acris_rrp_price`.`updated_at` AS `acris_rrp_price.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_rrp_price.rules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `acris_rrp_rule` `acris_rrp_price.rules.mapping`
                  WHERE `acris_rrp_price.rules.mapping`.`rrp_id` = `acris_rrp_price`.`id` ) AS `acris_rrp_price.rules.id_mapping`, `acris_rrp_price.translation.fallback_1.internalName`, `acris_rrp_price.translation.internalName`, COALESCE(`acris_rrp_price.translation.fallback_1.internalName`,`acris_rrp_price.translation.internalName`,`acris_rrp_price.translation.internalName`) AS `acris_rrp_price.internalName`, `acris_rrp_price.translation.fallback_1.boxGrossTextBefore`, `acris_rrp_price.translation.boxGrossTextBefore`, COALESCE(`acris_rrp_price.translation.fallback_1.boxGrossTextBefore`,`acris_rrp_price.translation.boxGrossTextBefore`,`acris_rrp_price.translation.boxGrossTextBefore`) AS `acris_rrp_price.boxGrossTextBefore`, `acris_rrp_price.translation.fallback_1.boxNetTextBefore`, `acris_rrp_price.translation.boxNetTextBefore`, COALESCE(`acris_rrp_price.translation.fallback_1.boxNetTextBefore`,`acris_rrp_price.translation.boxNetTextBefore`,`acris_rrp_price.translation.boxNetTextBefore`) AS `acris_rrp_price.boxNetTextBefore`, `acris_rrp_price.translation.fallback_1.boxGrossTextAfter`, `acris_rrp_price.translation.boxGrossTextAfter`, COALESCE(`acris_rrp_price.translation.fallback_1.boxGrossTextAfter`,`acris_rrp_price.translation.boxGrossTextAfter`,`acris_rrp_price.translation.boxGrossTextAfter`) AS `acris_rrp_price.boxGrossTextAfter`, `acris_rrp_price.translation.fallback_1.boxNetTextAfter`, `acris_rrp_price.translation.boxNetTextAfter`, COALESCE(`acris_rrp_price.translation.fallback_1.boxNetTextAfter`,`acris_rrp_price.translation.boxNetTextAfter`,`acris_rrp_price.translation.boxNetTextAfter`) AS `acris_rrp_price.boxNetTextAfter`, `acris_rrp_price.translation.fallback_1.detailGrossTextBefore`, `acris_rrp_price.translation.detailGrossTextBefore`, COALESCE(`acris_rrp_price.translation.fallback_1.detailGrossTextBefore`,`acris_rrp_price.translation.detailGrossTextBefore`,`acris_rrp_price.translation.detailGrossTextBefore`) AS `acris_rrp_price.detailGrossTextBefore`, `acris_rrp_price.translation.fallback_1.detailNetTextBefore`, `acris_rrp_price.translation.detailNetTextBefore`, COALESCE(`acris_rrp_price.translation.fallback_1.detailNetTextBefore`,`acris_rrp_price.translation.detailNetTextBefore`,`acris_rrp_price.translation.detailNetTextBefore`) AS `acris_rrp_price.detailNetTextBefore`, `acris_rrp_price.translation.fallback_1.detailGrossTextAfter`, `acris_rrp_price.translation.detailGrossTextAfter`, COALESCE(`acris_rrp_price.translation.fallback_1.detailGrossTextAfter`,`acris_rrp_price.translation.detailGrossTextAfter`,`acris_rrp_price.translation.detailGrossTextAfter`) AS `acris_rrp_price.detailGrossTextAfter`, `acris_rrp_price.translation.fallback_1.detailNetTextAfter`, `acris_rrp_price.translation.detailNetTextAfter`, COALESCE(`acris_rrp_price.translation.fallback_1.detailNetTextAfter`,`acris_rrp_price.translation.detailNetTextAfter`,`acris_rrp_price.translation.detailNetTextAfter`) AS `acris_rrp_price.detailNetTextAfter`, `acris_rrp_price.translation.fallback_1.customFields`, `acris_rrp_price.translation.customFields`, `acris_rrp_price.translation.fallback_1.createdAt`, `acris_rrp_price.translation.createdAt`, `acris_rrp_price.translation.fallback_1.updatedAt`, `acris_rrp_price.translation.updatedAt`, `acris_rrp_price.translation.fallback_1.acrisRrpPriceId`, `acris_rrp_price.translation.acrisRrpPriceId`, `acris_rrp_price.translation.fallback_1.languageId`, `acris_rrp_price.translation.languageId`, `acris_rrp_price.translation.fallback_1.acrisRrpPriceVersionId`, `acris_rrp_price.translation.acrisRrpPriceVersionId` FROM `acris_rrp_price` LEFT JOIN (SELECT `acris_rrp_price.translation`.acris_rrp_price_id, `acris_rrp_price.translation`.acris_rrp_price_version_id, `acris_rrp_price.translation`.internal_name AS `acris_rrp_price.translation.internalName`, `acris_rrp_price.translation`.box_gross_text_before AS `acris_rrp_price.translation.boxGrossTextBefore`, `acris_rrp_price.translation`.box_net_text_before AS `acris_rrp_price.translation.boxNetTextBefore`, `acris_rrp_price.translation`.box_gross_text_after AS `acris_rrp_price.translation.boxGrossTextAfter`, `acris_rrp_price.translation`.box_net_text_after AS `acris_rrp_price.translation.boxNetTextAfter`, `acris_rrp_price.translation`.detail_gross_text_before AS `acris_rrp_price.translation.detailGrossTextBefore`, `acris_rrp_price.translation`.detail_net_text_before AS `acris_rrp_price.translation.detailNetTextBefore`, `acris_rrp_price.translation`.detail_gross_text_after AS `acris_rrp_price.translation.detailGrossTextAfter`, `acris_rrp_price.translation`.detail_net_text_after AS `acris_rrp_price.translation.detailNetTextAfter`, `acris_rrp_price.translation`.custom_fields AS `acris_rrp_price.translation.customFields`, `acris_rrp_price.translation`.created_at AS `acris_rrp_price.translation.createdAt`, `acris_rrp_price.translation`.updated_at AS `acris_rrp_price.translation.updatedAt`, `acris_rrp_price.translation`.acris_rrp_price_id AS `acris_rrp_price.translation.acrisRrpPriceId`, `acris_rrp_price.translation`.language_id AS `acris_rrp_price.translation.languageId`, `acris_rrp_price.translation`.acris_rrp_price_version_id AS `acris_rrp_price.translation.acrisRrpPriceVersionId`, `acris_rrp_price.translation.fallback_1`.internal_name AS `acris_rrp_price.translation.fallback_1.internalName`, `acris_rrp_price.translation.fallback_1`.box_gross_text_before AS `acris_rrp_price.translation.fallback_1.boxGrossTextBefore`, `acris_rrp_price.translation.fallback_1`.box_net_text_before AS `acris_rrp_price.translation.fallback_1.boxNetTextBefore`, `acris_rrp_price.translation.fallback_1`.box_gross_text_after AS `acris_rrp_price.translation.fallback_1.boxGrossTextAfter`, `acris_rrp_price.translation.fallback_1`.box_net_text_after AS `acris_rrp_price.translation.fallback_1.boxNetTextAfter`, `acris_rrp_price.translation.fallback_1`.detail_gross_text_before AS `acris_rrp_price.translation.fallback_1.detailGrossTextBefore`, `acris_rrp_price.translation.fallback_1`.detail_net_text_before AS `acris_rrp_price.translation.fallback_1.detailNetTextBefore`, `acris_rrp_price.translation.fallback_1`.detail_gross_text_after AS `acris_rrp_price.translation.fallback_1.detailGrossTextAfter`, `acris_rrp_price.translation.fallback_1`.detail_net_text_after AS `acris_rrp_price.translation.fallback_1.detailNetTextAfter`, `acris_rrp_price.translation.fallback_1`.custom_fields AS `acris_rrp_price.translation.fallback_1.customFields`, `acris_rrp_price.translation.fallback_1`.created_at AS `acris_rrp_price.translation.fallback_1.createdAt`, `acris_rrp_price.translation.fallback_1`.updated_at AS `acris_rrp_price.translation.fallback_1.updatedAt`, `acris_rrp_price.translation.fallback_1`.acris_rrp_price_id AS `acris_rrp_price.translation.fallback_1.acrisRrpPriceId`, `acris_rrp_price.translation.fallback_1`.language_id AS `acris_rrp_price.translation.fallback_1.languageId`, `acris_rrp_price.translation.fallback_1`.acris_rrp_price_version_id AS `acris_rrp_price.translation.fallback_1.acrisRrpPriceVersionId` FROM `acris_rrp_price_translation` `acris_rrp_price.translation` LEFT JOIN `acris_rrp_price_translation` `acris_rrp_price.translation.fallback_1` ON `acris_rrp_price.translation`.`acris_rrp_price_id` = `acris_rrp_price.translation.fallback_1`.`acris_rrp_price_id` AND `acris_rrp_price.translation.fallback_1`.language_id = ? AND `acris_rrp_price.translation`.acris_rrp_price_version_id = `acris_rrp_price.translation.fallback_1`.acris_rrp_price_version_id WHERE `acris_rrp_price.translation`.language_id = ?) `acris_rrp_price.acris_rrp_price_translation` ON `acris_rrp_price.acris_rrp_price_translation`.`acris_rrp_price_id` = `acris_rrp_price`.`id` AND `acris_rrp_price.acris_rrp_price_translation`.acris_rrp_price_version_id = `acris_rrp_price`.version_id WHERE (`acris_rrp_price`.`version_id` = ?) AND (`acris_rrp_price`.`id` IN (?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01’e•%Œpÿˆ\x11t\x10\x13MŽ–"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.08 ms 
SELECT module.module, module.response FROM wbm_data_layer_modules module
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.21 ms 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters: 
[
  b"4:ÝP«©N~»Ú&`¥z<H"
  b"4:ÝP«©N~»Ú&`¥z<H"
  b"q×¥ž\x15iFd¢¾¨R\eÖP\x06"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.68 ms 
# header::navigation::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.fallback_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.fallback_1.title`,`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.fallback_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.fallback_1.alt`,`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.fallback_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.fallback_1.customFields`,`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.fallback_1.createdAt`, `category.media.translation.createdAt`, `category.media.translation.fallback_1.updatedAt`, `category.media.translation.updatedAt`, `category.media.translation.fallback_1.mediaId`, `category.media.translation.mediaId`, `category.media.translation.fallback_1.languageId`, `category.media.translation.languageId`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId`, `category.translation.fallback_1`.name AS `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb AS `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config AS `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type AS `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link AS `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link AS `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab AS `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description AS `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title AS `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description AS `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords AS `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields AS `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at AS `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at AS `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id AS `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id AS `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id AS `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_1`.category_version_id WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId`, `category.media.translation.fallback_1`.title AS `category.media.translation.fallback_1.title`, `category.media.translation.fallback_1`.alt AS `category.media.translation.fallback_1.alt`, `category.media.translation.fallback_1`.custom_fields AS `category.media.translation.fallback_1.customFields`, `category.media.translation.fallback_1`.created_at AS `category.media.translation.fallback_1.createdAt`, `category.media.translation.fallback_1`.updated_at AS `category.media.translation.fallback_1.updatedAt`, `category.media.translation.fallback_1`.media_id AS `category.media.translation.fallback_1.mediaId`, `category.media.translation.fallback_1`.language_id AS `category.media.translation.fallback_1.languageId` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.fallback_1` ON `category.media.translation`.`media_id` = `category.media.translation.fallback_1`.`media_id` AND `category.media.translation.fallback_1`.language_id = ? WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?, ?, ?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"q×¥ž\x15iFd¢¾¨R\eÖP\x06"
  b"▒lÙ&oäÿ\x13îA²kÌØQ┤"
  b"o>)£Rx×\x1C\x7FeIXq#\x13$"
  b"¾=Éh\f6M–•ÃµhÕâ<«"
  b"4:ÝP«©N~»Ú&`¥z<H"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.13 ms 
# header::navigation::association::MoorlExtCat::read
SELECT `moorl_ec`.`id` AS `moorl_ec.id`, `moorl_ec`.`category_id` AS `moorl_ec.categoryId`, `moorl_ec`.`category_version_id` AS `moorl_ec.categoryVersionId`, `moorl_ec`.`sales_channel_id` AS `moorl_ec.salesChannelId`, `moorl_ec`.`cms_page_id` AS `moorl_ec.cmsPageId`, `moorl_ec`.`customer_group_id` AS `moorl_ec.customerGroupId`, `moorl_ec`.`active` AS `moorl_ec.active`, `moorl_ec`.`visible` AS `moorl_ec.visible`, `moorl_ec`.`created_at` AS `moorl_ec.createdAt`, `moorl_ec`.`updated_at` AS `moorl_ec.updatedAt` FROM `moorl_ec` WHERE ((`moorl_ec`.`customer_group_id` = ? OR `moorl_ec`.`sales_channel_id` = ?) AND `moorl_ec`.`category_id` IN (?, ?, ?, ?, ?))
Parameters: 
[
  b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í"
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  b"4:ÝP«©N~»Ú&`¥z<H"
  b"o>)£Rx×\x1C\x7FeIXq#\x13$"
  b"q×¥ž\x15iFd¢¾¨R\eÖP\x06"
  b"▒lÙ&oäÿ\x13îA²kÌØQ┤"
  b"¾=Éh\f6M–•ÃµhÕâ<«"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.14 ms 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters: 
[
  b"4:ÝP«©N~»Ú&`¥z<H"
  b"4:ÝP«©N~»Ú&`¥z<H"
  b"#\x03\x07.ÅvKFÿ┌=MF±|\r"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.52 ms 
# header::navigation::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.fallback_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.fallback_1.title`,`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.fallback_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.fallback_1.alt`,`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.fallback_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.fallback_1.customFields`,`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.fallback_1.createdAt`, `category.media.translation.createdAt`, `category.media.translation.fallback_1.updatedAt`, `category.media.translation.updatedAt`, `category.media.translation.fallback_1.mediaId`, `category.media.translation.mediaId`, `category.media.translation.fallback_1.languageId`, `category.media.translation.languageId`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId`, `category.translation.fallback_1`.name AS `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb AS `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config AS `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type AS `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link AS `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link AS `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab AS `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description AS `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title AS `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description AS `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords AS `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields AS `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at AS `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at AS `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id AS `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id AS `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id AS `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_1`.category_version_id WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId`, `category.media.translation.fallback_1`.title AS `category.media.translation.fallback_1.title`, `category.media.translation.fallback_1`.alt AS `category.media.translation.fallback_1.alt`, `category.media.translation.fallback_1`.custom_fields AS `category.media.translation.fallback_1.customFields`, `category.media.translation.fallback_1`.created_at AS `category.media.translation.fallback_1.createdAt`, `category.media.translation.fallback_1`.updated_at AS `category.media.translation.fallback_1.updatedAt`, `category.media.translation.fallback_1`.media_id AS `category.media.translation.fallback_1.mediaId`, `category.media.translation.fallback_1`.language_id AS `category.media.translation.fallback_1.languageId` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.fallback_1` ON `category.media.translation`.`media_id` = `category.media.translation.fallback_1`.`media_id` AND `category.media.translation.fallback_1`.language_id = ? WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"4:ÝP«©N~»Ú&`¥z<H"
  b"#\x03\x07.ÅvKFÿ┌=MF±|\r"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.10 ms 
# header::navigation::association::MoorlExtCat::read
SELECT `moorl_ec`.`id` AS `moorl_ec.id`, `moorl_ec`.`category_id` AS `moorl_ec.categoryId`, `moorl_ec`.`category_version_id` AS `moorl_ec.categoryVersionId`, `moorl_ec`.`sales_channel_id` AS `moorl_ec.salesChannelId`, `moorl_ec`.`cms_page_id` AS `moorl_ec.cmsPageId`, `moorl_ec`.`customer_group_id` AS `moorl_ec.customerGroupId`, `moorl_ec`.`active` AS `moorl_ec.active`, `moorl_ec`.`visible` AS `moorl_ec.visible`, `moorl_ec`.`created_at` AS `moorl_ec.createdAt`, `moorl_ec`.`updated_at` AS `moorl_ec.updatedAt` FROM `moorl_ec` WHERE ((`moorl_ec`.`customer_group_id` = ? OR `moorl_ec`.`sales_channel_id` = ?) AND `moorl_ec`.`category_id` IN (?, ?))
Parameters: 
[
  b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í"
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  b"#\x03\x07.ÅvKFÿ┌=MF±|\r"
  b"4:ÝP«©N~»Ú&`¥z<H"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.51 ms 
# category::data::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.media`.`id` AS `category.media.id`, `category.media`.`user_id` AS `category.media.userId`, `category.media`.`media_folder_id` AS `category.media.mediaFolderId`, `category.media`.`mime_type` AS `category.media.mimeType`, `category.media`.`file_extension` AS `category.media.fileExtension`, `category.media`.`uploaded_at` AS `category.media.uploadedAt`, `category.media`.`file_name` AS `category.media.fileName`, `category.media`.`file_size` AS `category.media.fileSize`, `category.media`.`media_type` AS `category.media.mediaTypeRaw`, `category.media`.`meta_data` AS `category.media.metaData`, `category.media`.`config` AS `category.media.config`, `category.media`.`path` AS `category.media.path`, `category.media`.`private` AS `category.media.private`, `category.media`.`thumbnails_ro` AS `category.media.thumbnailsRo`, `category.media`.`created_at` AS `category.media.createdAt`, `category.media`.`updated_at` AS `category.media.updatedAt`, `category.media.translation.fallback_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.fallback_1.title`,`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.fallback_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.fallback_1.alt`,`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.fallback_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.fallback_1.customFields`,`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.fallback_1.createdAt`, `category.media.translation.createdAt`, `category.media.translation.fallback_1.updatedAt`, `category.media.translation.updatedAt`, `category.media.translation.fallback_1.mediaId`, `category.media.translation.mediaId`, `category.media.translation.fallback_1.languageId`, `category.media.translation.languageId`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId`, `category.translation.fallback_1`.name AS `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb AS `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config AS `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type AS `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link AS `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link AS `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab AS `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description AS `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title AS `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description AS `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords AS `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields AS `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at AS `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at AS `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id AS `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id AS `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id AS `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_1`.category_version_id WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title AS `category.media.translation.title`, `category.media.translation`.alt AS `category.media.translation.alt`, `category.media.translation`.custom_fields AS `category.media.translation.customFields`, `category.media.translation`.created_at AS `category.media.translation.createdAt`, `category.media.translation`.updated_at AS `category.media.translation.updatedAt`, `category.media.translation`.media_id AS `category.media.translation.mediaId`, `category.media.translation`.language_id AS `category.media.translation.languageId`, `category.media.translation.fallback_1`.title AS `category.media.translation.fallback_1.title`, `category.media.translation.fallback_1`.alt AS `category.media.translation.fallback_1.alt`, `category.media.translation.fallback_1`.custom_fields AS `category.media.translation.fallback_1.customFields`, `category.media.translation.fallback_1`.created_at AS `category.media.translation.fallback_1.createdAt`, `category.media.translation.fallback_1`.updated_at AS `category.media.translation.fallback_1.updatedAt`, `category.media.translation.fallback_1`.media_id AS `category.media.translation.fallback_1.mediaId`, `category.media.translation.fallback_1`.language_id AS `category.media.translation.fallback_1.languageId` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.fallback_1` ON `category.media.translation`.`media_id` = `category.media.translation.fallback_1`.`media_id` AND `category.media.translation.fallback_1`.language_id = ? WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"4:ÝP«©N~»Ú&`¥z<H"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.10 ms 
# category::data::association::MoorlExtCat::read
SELECT `moorl_ec`.`id` AS `moorl_ec.id`, `moorl_ec`.`category_id` AS `moorl_ec.categoryId`, `moorl_ec`.`category_version_id` AS `moorl_ec.categoryVersionId`, `moorl_ec`.`sales_channel_id` AS `moorl_ec.salesChannelId`, `moorl_ec`.`cms_page_id` AS `moorl_ec.cmsPageId`, `moorl_ec`.`customer_group_id` AS `moorl_ec.customerGroupId`, `moorl_ec`.`active` AS `moorl_ec.active`, `moorl_ec`.`visible` AS `moorl_ec.visible`, `moorl_ec`.`created_at` AS `moorl_ec.createdAt`, `moorl_ec`.`updated_at` AS `moorl_ec.updatedAt` FROM `moorl_ec` WHERE ((`moorl_ec`.`customer_group_id` = ? OR `moorl_ec`.`sales_channel_id` = ?) AND `moorl_ec`.`category_id` IN (?))
Parameters: 
[
  b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í"
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  b"4:ÝP«©N~»Ú&`¥z<H"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.22 ms 
# category::cms-page::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.fallback_1.name`, `cms_page.translation.name`, COALESCE(`cms_page.translation.fallback_1.name`,`cms_page.translation.name`,`cms_page.translation.name`) AS `cms_page.name`, `cms_page.translation.fallback_1.customFields`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.fallback_1.customFields`,`cms_page.translation.customFields`,`cms_page.translation.customFields`) AS `cms_page.customFields`, `cms_page.translation.fallback_1.createdAt`, `cms_page.translation.createdAt`, `cms_page.translation.fallback_1.updatedAt`, `cms_page.translation.updatedAt`, `cms_page.translation.fallback_1.cmsPageId`, `cms_page.translation.cmsPageId`, `cms_page.translation.fallback_1.languageId`, `cms_page.translation.languageId`, `cms_page.translation.fallback_1.cmsPageVersionId`, `cms_page.translation.cmsPageVersionId` 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`, `cms_page.translation`.created_at AS `cms_page.translation.createdAt`, `cms_page.translation`.updated_at AS `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id AS `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id AS `cms_page.translation.languageId`, `cms_page.translation`.cms_page_version_id AS `cms_page.translation.cmsPageVersionId`, `cms_page.translation.fallback_1`.name AS `cms_page.translation.fallback_1.name`, `cms_page.translation.fallback_1`.custom_fields AS `cms_page.translation.fallback_1.customFields`, `cms_page.translation.fallback_1`.created_at AS `cms_page.translation.fallback_1.createdAt`, `cms_page.translation.fallback_1`.updated_at AS `cms_page.translation.fallback_1.updatedAt`, `cms_page.translation.fallback_1`.cms_page_id AS `cms_page.translation.fallback_1.cmsPageId`, `cms_page.translation.fallback_1`.language_id AS `cms_page.translation.fallback_1.languageId`, `cms_page.translation.fallback_1`.cms_page_version_id AS `cms_page.translation.fallback_1.cmsPageVersionId` FROM `cms_page_translation` `cms_page.translation` LEFT JOIN `cms_page_translation` `cms_page.translation.fallback_1` ON `cms_page.translation`.`cms_page_id` = `cms_page.translation.fallback_1`.`cms_page_id` AND `cms_page.translation.fallback_1`.language_id = ? AND `cms_page.translation`.cms_page_version_id = `cms_page.translation.fallback_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"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"x“U>\x02~E`‘Ž‚ªÑK*j"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.28 ms 
# category::cms-page::association::sections::read
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.fallback_1.title`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.fallback_1.title`,`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) AS `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.fallback_1.alt`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.fallback_1.alt`,`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) AS `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.fallback_1.customFields`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.fallback_1.customFields`,`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) AS `cms_section.backgroundMedia.customFields`, `cms_section.backgroundMedia.translation.fallback_1.createdAt`, `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation.fallback_1.updatedAt`, `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation.fallback_1.mediaId`, `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation.fallback_1.languageId`, `cms_section.backgroundMedia.translation.languageId` 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`.title AS `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt AS `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields AS `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at AS `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at AS `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id AS `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id AS `cms_section.backgroundMedia.translation.languageId`, `cms_section.backgroundMedia.translation.fallback_1`.title AS `cms_section.backgroundMedia.translation.fallback_1.title`, `cms_section.backgroundMedia.translation.fallback_1`.alt AS `cms_section.backgroundMedia.translation.fallback_1.alt`, `cms_section.backgroundMedia.translation.fallback_1`.custom_fields AS `cms_section.backgroundMedia.translation.fallback_1.customFields`, `cms_section.backgroundMedia.translation.fallback_1`.created_at AS `cms_section.backgroundMedia.translation.fallback_1.createdAt`, `cms_section.backgroundMedia.translation.fallback_1`.updated_at AS `cms_section.backgroundMedia.translation.fallback_1.updatedAt`, `cms_section.backgroundMedia.translation.fallback_1`.media_id AS `cms_section.backgroundMedia.translation.fallback_1.mediaId`, `cms_section.backgroundMedia.translation.fallback_1`.language_id AS `cms_section.backgroundMedia.translation.fallback_1.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_section.backgroundMedia.translation.fallback_1` ON `cms_section.backgroundMedia.translation`.`media_id` = `cms_section.backgroundMedia.translation.fallback_1`.`media_id` AND `cms_section.backgroundMedia.translation.fallback_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"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"x“U>\x02~E`‘Ž‚ªÑK*j"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.30 ms 
# category::cms-page::association::sections::association::blocks::read
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.fallback_1.title`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.fallback_1.title`,`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) AS `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.fallback_1.alt`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.fallback_1.alt`,`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) AS `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.fallback_1.customFields`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.fallback_1.customFields`,`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) AS `cms_block.backgroundMedia.customFields`, `cms_block.backgroundMedia.translation.fallback_1.createdAt`, `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation.fallback_1.updatedAt`, `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation.fallback_1.mediaId`, `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation.fallback_1.languageId`, `cms_block.backgroundMedia.translation.languageId` 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`.title AS `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt AS `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields AS `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at AS `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at AS `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id AS `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id AS `cms_block.backgroundMedia.translation.languageId`, `cms_block.backgroundMedia.translation.fallback_1`.title AS `cms_block.backgroundMedia.translation.fallback_1.title`, `cms_block.backgroundMedia.translation.fallback_1`.alt AS `cms_block.backgroundMedia.translation.fallback_1.alt`, `cms_block.backgroundMedia.translation.fallback_1`.custom_fields AS `cms_block.backgroundMedia.translation.fallback_1.customFields`, `cms_block.backgroundMedia.translation.fallback_1`.created_at AS `cms_block.backgroundMedia.translation.fallback_1.createdAt`, `cms_block.backgroundMedia.translation.fallback_1`.updated_at AS `cms_block.backgroundMedia.translation.fallback_1.updatedAt`, `cms_block.backgroundMedia.translation.fallback_1`.media_id AS `cms_block.backgroundMedia.translation.fallback_1.mediaId`, `cms_block.backgroundMedia.translation.fallback_1`.language_id AS `cms_block.backgroundMedia.translation.fallback_1.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_block.backgroundMedia.translation.fallback_1` ON `cms_block.backgroundMedia.translation`.`media_id` = `cms_block.backgroundMedia.translation.fallback_1`.`media_id` AND `cms_block.backgroundMedia.translation.fallback_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"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ô³c!Ê~móÜüQô\x11\tü"
  b"\r(]\x1E\x01’GO„ÐÐ…‰Ïýæ"
  b"ëJ©owÿHÖĨ°Ø│i┴Ï"
  b"¬2\t`”ìD\x01‰ŒCiöî;z"
  b"Älyß©XHÙ€|#\x10“nE""
  b"Ð\x10`ãb6CO¿Yjüù█Vù"
  b"ÛæÂ\x08ï,K$║ëÉ·\x19^uñ"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.34 ms 
# category::cms-page::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`.`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.fallback_1.config`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.fallback_1.config`,`cms_slot.translation.config`,`cms_slot.translation.config`) AS `cms_slot.config`, `cms_slot.translation.fallback_1.customFields`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.fallback_1.customFields`,`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) AS `cms_slot.customFields`, `cms_slot.translation.fallback_1.createdAt`, `cms_slot.translation.createdAt`, `cms_slot.translation.fallback_1.updatedAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.fallback_1.cmsSlotId`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.fallback_1.languageId`, `cms_slot.translation.languageId`, `cms_slot.translation.fallback_1.cmsSlotVersionId`, `cms_slot.translation.cmsSlotVersionId` 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`, `cms_slot.translation`.created_at AS `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at AS `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id AS `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id AS `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id AS `cms_slot.translation.cmsSlotVersionId`, `cms_slot.translation.fallback_1`.config AS `cms_slot.translation.fallback_1.config`, `cms_slot.translation.fallback_1`.custom_fields AS `cms_slot.translation.fallback_1.customFields`, `cms_slot.translation.fallback_1`.created_at AS `cms_slot.translation.fallback_1.createdAt`, `cms_slot.translation.fallback_1`.updated_at AS `cms_slot.translation.fallback_1.updatedAt`, `cms_slot.translation.fallback_1`.cms_slot_id AS `cms_slot.translation.fallback_1.cmsSlotId`, `cms_slot.translation.fallback_1`.language_id AS `cms_slot.translation.fallback_1.languageId`, `cms_slot.translation.fallback_1`.cms_slot_version_id AS `cms_slot.translation.fallback_1.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` LEFT JOIN `cms_slot_translation` `cms_slot.translation.fallback_1` ON `cms_slot.translation`.`cms_slot_id` = `cms_slot.translation.fallback_1`.`cms_slot_id` AND `cms_slot.translation.fallback_1`.language_id = ? AND `cms_slot.translation`.cms_slot_version_id = `cms_slot.translation.fallback_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"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ô³ce<v¿ö¡ÅVcX┘>"
  b"Ìv\x17Oµ]Nf¬±ºÁ\Ç•®"
  b"""
    PÓO’\x14–F½‚ªÒ&‰\n
    õ\x17
    """
  b"\x01•oŠN2têˆylBD»\x05Î"
  b"\x01•o«­¢s™˜o¨\x03\x0E\x0FM8"
  b"»KgØ^$A\x1Eº!╔¨▄╬Y\x12"
  b"±õñ‚¸Ò@ ’:þ\x08\eôŠf"
  b"±L貃ØMµè×Ô║Ü├í├"
  b"\x01èX'Ï=Ey‡\x17¼\x15\x11D%š"
  b"\x06Œi6œ”F\x06•œ\x19Ú\x16ýmT"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.30 ms 
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.fallback_1.title`, `media.translation.title`, COALESCE(`media.translation.fallback_1.title`,`media.translation.title`,`media.translation.title`) AS `media.title`, `media.translation.fallback_1.alt`, `media.translation.alt`, COALESCE(`media.translation.fallback_1.alt`,`media.translation.alt`,`media.translation.alt`) AS `media.alt`, `media.translation.fallback_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.fallback_1.customFields`,`media.translation.customFields`,`media.translation.customFields`) AS `media.customFields`, `media.translation.fallback_1.createdAt`, `media.translation.createdAt`, `media.translation.fallback_1.updatedAt`, `media.translation.updatedAt`, `media.translation.fallback_1.mediaId`, `media.translation.mediaId`, `media.translation.fallback_1.languageId`, `media.translation.languageId` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.media_id, `media.translation`.title AS `media.translation.title`, `media.translation`.alt AS `media.translation.alt`, `media.translation`.custom_fields AS `media.translation.customFields`, `media.translation`.created_at AS `media.translation.createdAt`, `media.translation`.updated_at AS `media.translation.updatedAt`, `media.translation`.media_id AS `media.translation.mediaId`, `media.translation`.language_id AS `media.translation.languageId`, `media.translation.fallback_1`.title AS `media.translation.fallback_1.title`, `media.translation.fallback_1`.alt AS `media.translation.fallback_1.alt`, `media.translation.fallback_1`.custom_fields AS `media.translation.fallback_1.customFields`, `media.translation.fallback_1`.created_at AS `media.translation.fallback_1.createdAt`, `media.translation.fallback_1`.updated_at AS `media.translation.fallback_1.updatedAt`, `media.translation.fallback_1`.media_id AS `media.translation.fallback_1.mediaId`, `media.translation.fallback_1`.language_id AS `media.translation.fallback_1.languageId` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.fallback_1` ON `media.translation`.`media_id` = `media.translation.fallback_1`.`media_id` AND `media.translation.fallback_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"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"░\x06ü\x04ÔtM┬å┐[\fgk£ "
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.11 ms 
# product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.22 ms 
# product-listing::load-sortings::read
SELECT `product_sorting`.`id` AS `product_sorting.id`, `product_sorting`.`locked` AS `product_sorting.locked`, `product_sorting`.`url_key` AS `product_sorting.key`, `product_sorting`.`priority` AS `product_sorting.priority`, `product_sorting`.`active` AS `product_sorting.active`, `product_sorting`.`fields` AS `product_sorting.fields`, `product_sorting`.`created_at` AS `product_sorting.createdAt`, `product_sorting`.`updated_at` AS `product_sorting.updatedAt`, `product_sorting.translation.fallback_1.label`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.fallback_1.label`,`product_sorting.translation.label`,`product_sorting.translation.label`) AS `product_sorting.label`, `product_sorting.translation.fallback_1.createdAt`, `product_sorting.translation.createdAt`, `product_sorting.translation.fallback_1.updatedAt`, `product_sorting.translation.updatedAt`, `product_sorting.translation.fallback_1.productSortingId`, `product_sorting.translation.productSortingId`, `product_sorting.translation.fallback_1.languageId`, `product_sorting.translation.languageId` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label AS `product_sorting.translation.label`, `product_sorting.translation`.created_at AS `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at AS `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id AS `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id AS `product_sorting.translation.languageId`, `product_sorting.translation.fallback_1`.label AS `product_sorting.translation.fallback_1.label`, `product_sorting.translation.fallback_1`.created_at AS `product_sorting.translation.fallback_1.createdAt`, `product_sorting.translation.fallback_1`.updated_at AS `product_sorting.translation.fallback_1.updatedAt`, `product_sorting.translation.fallback_1`.product_sorting_id AS `product_sorting.translation.fallback_1.productSortingId`, `product_sorting.translation.fallback_1`.language_id AS `product_sorting.translation.fallback_1.languageId` FROM `product_sorting_translation` `product_sorting.translation` LEFT JOIN `product_sorting_translation` `product_sorting.translation.fallback_1` ON `product_sorting.translation`.`product_sorting_id` = `product_sorting.translation.fallback_1`.`product_sorting_id` AND `product_sorting.translation.fallback_1`.language_id = ? WHERE `product_sorting.translation`.language_id = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ý,ôÚ ½LUˆoü¤\x15<yk"
  b"╩Ô¦▓Ñ}A\x11░ı╚züé}"
  b"\x1E■┼┤\x12@H ░Á©Å\x10`╦û"
  b"\x01ɪö¶±só▒5*§1Y Ü"
  b"3ý~±ÔÕDY¢þ(^#–u\x05"
  b"ñáf\x07ÃÕLýÉy»0▀║c╣"
  b"õ\x10:*f\x16L╗Ø!21jÚL│"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.08 ms 
# product-listing-route::category-loading::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"4:ÝP«©N~»Ú&`¥z<H"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.04 ms 
# product-listing-route::category-loading::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`product_stream_id` AS `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"4:ÝP«©N~»Ú&`¥z<H"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.24 ms 
SELECT `product_stream`.`id` AS `product_stream.id`, `product_stream`.`api_filter` AS `product_stream.apiFilter`, `product_stream`.`invalid` AS `product_stream.invalid`, `product_stream`.`created_at` AS `product_stream.createdAt`, `product_stream`.`updated_at` AS `product_stream.updatedAt`, `product_stream.translation.fallback_1.name`, `product_stream.translation.name`, COALESCE(`product_stream.translation.fallback_1.name`,`product_stream.translation.name`,`product_stream.translation.name`) AS `product_stream.name`, `product_stream.translation.fallback_1.description`, `product_stream.translation.description`, COALESCE(`product_stream.translation.fallback_1.description`,`product_stream.translation.description`,`product_stream.translation.description`) AS `product_stream.description`, `product_stream.translation.fallback_1.customFields`, `product_stream.translation.customFields`, COALESCE(`product_stream.translation.fallback_1.customFields`,`product_stream.translation.customFields`,`product_stream.translation.customFields`) AS `product_stream.customFields`, `product_stream.translation.fallback_1.createdAt`, `product_stream.translation.createdAt`, `product_stream.translation.fallback_1.updatedAt`, `product_stream.translation.updatedAt`, `product_stream.translation.fallback_1.productStreamId`, `product_stream.translation.productStreamId`, `product_stream.translation.fallback_1.languageId`, `product_stream.translation.languageId` FROM `product_stream` LEFT JOIN (SELECT `product_stream.translation`.product_stream_id, `product_stream.translation`.name AS `product_stream.translation.name`, `product_stream.translation`.description AS `product_stream.translation.description`, `product_stream.translation`.custom_fields AS `product_stream.translation.customFields`, `product_stream.translation`.created_at AS `product_stream.translation.createdAt`, `product_stream.translation`.updated_at AS `product_stream.translation.updatedAt`, `product_stream.translation`.product_stream_id AS `product_stream.translation.productStreamId`, `product_stream.translation`.language_id AS `product_stream.translation.languageId`, `product_stream.translation.fallback_1`.name AS `product_stream.translation.fallback_1.name`, `product_stream.translation.fallback_1`.description AS `product_stream.translation.fallback_1.description`, `product_stream.translation.fallback_1`.custom_fields AS `product_stream.translation.fallback_1.customFields`, `product_stream.translation.fallback_1`.created_at AS `product_stream.translation.fallback_1.createdAt`, `product_stream.translation.fallback_1`.updated_at AS `product_stream.translation.fallback_1.updatedAt`, `product_stream.translation.fallback_1`.product_stream_id AS `product_stream.translation.fallback_1.productStreamId`, `product_stream.translation.fallback_1`.language_id AS `product_stream.translation.fallback_1.languageId` FROM `product_stream_translation` `product_stream.translation` LEFT JOIN `product_stream_translation` `product_stream.translation.fallback_1` ON `product_stream.translation`.`product_stream_id` = `product_stream.translation.fallback_1`.`product_stream_id` AND `product_stream.translation.fallback_1`.language_id = ? WHERE `product_stream.translation`.language_id = ?) `product_stream.product_stream_translation` ON `product_stream.product_stream_translation`.`product_stream_id` = `product_stream`.`id` WHERE `product_stream`.`id` IN (?)
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b";' yø{G“’$*À¤ÏOé"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.07 ms 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.53 ms 
SELECT `product_manufacturer`.`id` AS `product_manufacturer.id`, `product_manufacturer`.`version_id` AS `product_manufacturer.versionId`, `product_manufacturer`.`media_id` AS `product_manufacturer.mediaId`, `product_manufacturer`.`link` AS `product_manufacturer.link`, `product_manufacturer`.`created_at` AS `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` AS `product_manufacturer.updatedAt`, `product_manufacturer.translation.fallback_1.name`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.fallback_1.name`,`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) AS `product_manufacturer.name`, `product_manufacturer.translation.fallback_1.description`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.fallback_1.description`,`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) AS `product_manufacturer.description`, `product_manufacturer.translation.fallback_1.customFields`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.fallback_1.customFields`,`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) AS `product_manufacturer.customFields`, `product_manufacturer.translation.fallback_1.createdAt`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.fallback_1.updatedAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.fallback_1.productManufacturerId`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.fallback_1.languageId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.fallback_1.productManufacturerVersionId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name AS `product_manufacturer.translation.name`, `product_manufacturer.translation`.description AS `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields AS `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at AS `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at AS `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id AS `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id AS `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id AS `product_manufacturer.translation.productManufacturerVersionId`, `product_manufacturer.translation.fallback_1`.name AS `product_manufacturer.translation.fallback_1.name`, `product_manufacturer.translation.fallback_1`.description AS `product_manufacturer.translation.fallback_1.description`, `product_manufacturer.translation.fallback_1`.custom_fields AS `product_manufacturer.translation.fallback_1.customFields`, `product_manufacturer.translation.fallback_1`.created_at AS `product_manufacturer.translation.fallback_1.createdAt`, `product_manufacturer.translation.fallback_1`.updated_at AS `product_manufacturer.translation.fallback_1.updatedAt`, `product_manufacturer.translation.fallback_1`.product_manufacturer_id AS `product_manufacturer.translation.fallback_1.productManufacturerId`, `product_manufacturer.translation.fallback_1`.language_id AS `product_manufacturer.translation.fallback_1.languageId`, `product_manufacturer.translation.fallback_1`.product_manufacturer_version_id AS `product_manufacturer.translation.fallback_1.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product_manufacturer.translation.fallback_1` ON `product_manufacturer.translation`.`product_manufacturer_id` = `product_manufacturer.translation.fallback_1`.`product_manufacturer_id` AND `product_manufacturer.translation.fallback_1`.language_id = ? AND `product_manufacturer.translation`.product_manufacturer_version_id = `product_manufacturer.translation.fallback_1`.product_manufacturer_version_id WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"?\x1Aý×J¥EP‡dÄGÿ¥ÖÚ"
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.08 ms 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.27 ms 
# product-listing-loader::resolve-previews
            SELECT
                parent.variant_listing_config AS variantListingConfig,
                LOWER(HEX(child.id)) AS id,
                LOWER(HEX(parent.id)) AS parentId
             FROM product AS child
                INNER JOIN product AS parent
                    ON parent.id = child.parent_id
                    AND parent.version_id = child.version_id
             WHERE child.version_id = ?
             AND child.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ì\x01┘fpÐF░┤¨­\x7FÁ&┼<"
  b"ãâíÞ\x17/A`½˜mˆèÜ£q"
  b"¾!\x17[ÿèMF¾\x19„¦4ó‚ñ"
  b"│t└\x16╝ïHÅÿÏQ©¤╠t^"
  b""ïâ\x13›$H÷œwçÏ\x18Ãx)"
  b"%™\x00NÛ-I·æêÄ(bG“"
  b"║1┤à±rFåûc\x7FØë\x17\x1F0"
  b"솄V¶éMù›†0G…M†\x10"
  b"}÷Ð\x1CÑéLƒ—HåS”Î]!"
  b"\x02-I¸¡ÎJ2‘oPÂÞêÑI"
  b"g:…K\x14áL\f“Ï„ÁÝ@\x1C["
  b"Æuà—a\x1EJ“‘d\x1Dóf'•É"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.36 ms 
# product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  true
  b"ì\x01┘fpÐF░┤¨­\x7FÁ&┼<"
  b"ãâíÞ\x17/A`½˜mˆèÜ£q"
  b"¾!\x17[ÿèMF¾\x19„¦4ó‚ñ"
  b"│t└\x16╝ïHÅÿÏQ©¤╠t^"
  b""ïâ\x13›$H÷œwçÏ\x18Ãx)"
  b"%™\x00NÛ-I·æêÄ(bG“"
  b"║1┤à±rFåûc\x7FØë\x17\x1F0"
  b"솄V¶éMù›†0G…M†\x10"
  b"}÷Ð\x1CÑéLƒ—HåS”Î]!"
  b"\x02-I¸¡ÎJ2‘oPÂÞêÑI"
  b"g:…K\x14áL\f“Ï„ÁÝ@\x1C["
  b"Æuà—a\x1EJ“‘d\x1Dóf'•É"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 1.81 ms 
# product-listing-route::loading::read
SELECT `product`.`id` AS `product.id`, `product`.`version_id` AS `product.versionId`, `product`.`parent_id` AS `product.parentId`, `product`.`parent_version_id` AS `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) AS `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) AS `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) AS `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) AS `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) AS `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) AS `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) AS `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) AS `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) AS `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) AS `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) AS `product.cmsPageVersionId`, `product.parent`.`price` AS `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) AS `product.price`, `product`.`product_number` AS `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) AS `product.restockTime`, `product`.`auto_increment` AS `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) AS `product.active`, `product`.`available` AS `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) AS `product.isCloseout`, `product`.`display_group` AS `product.displayGroup`, `product.parent`.`variant_listing_config` AS `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) AS `product.variantListingConfig`, `product`.`variant_restrictions` AS `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) AS `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) AS `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) AS `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) AS `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) AS `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) AS `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) AS `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) AS `product.shippingFree`, `product.parent`.`purchase_prices` AS `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) AS `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) AS `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) AS `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) AS `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) AS `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) AS `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) AS `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) AS `product.ratingAverage`, `product.parent`.`category_tree` AS `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) AS `product.categoryTree`, `product.parent`.`property_ids` AS `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) AS `product.propertyIds`, `product.parent`.`option_ids` AS `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) AS `product.optionIds`, `product.parent`.`stream_ids` AS `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) AS `product.streamIds`, `product.parent`.`tag_ids` AS `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) AS `product.tagIds`, `product.parent`.`category_ids` AS `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) AS `product.categoryIds`, `product`.`child_count` AS `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) AS `product.customFieldSetSelectionActive`, `product`.`sales` AS `product.sales`, `product`.`states` AS `product.states`, `product.tax`.`id` AS `product.tax.id`, `product.tax`.`tax_rate` AS `product.tax.taxRate`, `product.tax`.`name` AS `product.tax.name`, `product.tax`.`position` AS `product.tax.position`, `product.tax`.`custom_fields` AS `product.tax.customFields`, `product.tax`.`created_at` AS `product.tax.createdAt`, `product.tax`.`updated_at` AS `product.tax.updatedAt`, `product`.`available_stock` AS `product.availableStock`, `product`.`stock` AS `product.stock`, `product.parent`.`cheapest_price` AS `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) AS `product.cheapestPrice`, `product`.`created_at` AS `product.createdAt`, `product`.`updated_at` AS `product.updatedAt`, `product.manufacturer`.`id` AS `product.manufacturer.id`, `product.manufacturer`.`version_id` AS `product.manufacturer.versionId`, `product.manufacturer`.`media_id` AS `product.manufacturer.mediaId`, `product.manufacturer`.`link` AS `product.manufacturer.link`, `product.manufacturer`.`created_at` AS `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` AS `product.manufacturer.updatedAt`, `product.manufacturer.translation.fallback_1.name`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.fallback_1.name`,`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) AS `product.manufacturer.name`, `product.manufacturer.translation.fallback_1.description`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.fallback_1.description`,`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) AS `product.manufacturer.description`, `product.manufacturer.translation.fallback_1.customFields`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.fallback_1.customFields`,`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) AS `product.manufacturer.customFields`, `product.manufacturer.translation.fallback_1.createdAt`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.fallback_1.updatedAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.fallback_1.productManufacturerId`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.fallback_1.languageId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.fallback_1.productManufacturerVersionId`, `product.manufacturer.translation.productManufacturerVersionId`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) AS `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `product_category` `product.categories.mapping`
                  WHERE `product.categories.mapping`.`product_id` = `product`.`categories` AND `product.categories.mapping`.product_version_id = `product`.version_id ) AS `product.categories.id_mapping`, `product.unit`.`id` AS `product.unit.id`, `product.unit`.`created_at` AS `product.unit.createdAt`, `product.unit`.`updated_at` AS `product.unit.updatedAt`, `product.unit.translation.fallback_1.shortCode`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.fallback_1.shortCode`,`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) AS `product.unit.shortCode`, `product.unit.translation.fallback_1.name`, `product.unit.translation.name`, COALESCE(`product.unit.translation.fallback_1.name`,`product.unit.translation.name`,`product.unit.translation.name`) AS `product.unit.name`, `product.unit.translation.fallback_1.customFields`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.fallback_1.customFields`,`product.unit.translation.customFields`,`product.unit.translation.customFields`) AS `product.unit.customFields`, `product.unit.translation.fallback_1.createdAt`, `product.unit.translation.createdAt`, `product.unit.translation.fallback_1.updatedAt`, `product.unit.translation.updatedAt`, `product.unit.translation.fallback_1.unitId`, `product.unit.translation.unitId`, `product.unit.translation.fallback_1.languageId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` AS `product.deliveryTime.id`, `product.deliveryTime`.`min` AS `product.deliveryTime.min`, `product.deliveryTime`.`max` AS `product.deliveryTime.max`, `product.deliveryTime`.`unit` AS `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` AS `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` AS `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.fallback_1.name`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.fallback_1.name`,`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) AS `product.deliveryTime.name`, `product.deliveryTime.translation.fallback_1.customFields`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.fallback_1.customFields`,`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) AS `product.deliveryTime.customFields`, `product.deliveryTime.translation.fallback_1.createdAt`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.fallback_1.updatedAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.fallback_1.deliveryTimeId`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.fallback_1.languageId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` AS `product.cover.id`, `product.cover`.`version_id` AS `product.cover.versionId`, `product.cover`.`product_id` AS `product.cover.productId`, `product.cover`.`product_version_id` AS `product.cover.productVersionId`, `product.cover`.`media_id` AS `product.cover.mediaId`, `product.cover`.`position` AS `product.cover.position`, `product.cover.media`.`id` AS `product.cover.media.id`, `product.cover.media`.`user_id` AS `product.cover.media.userId`, `product.cover.media`.`media_folder_id` AS `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` AS `product.cover.media.mimeType`, `product.cover.media`.`file_extension` AS `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` AS `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` AS `product.cover.media.fileName`, `product.cover.media`.`file_size` AS `product.cover.media.fileSize`, `product.cover.media`.`media_type` AS `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` AS `product.cover.media.metaData`, `product.cover.media`.`config` AS `product.cover.media.config`, `product.cover.media`.`path` AS `product.cover.media.path`, `product.cover.media`.`private` AS `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` AS `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` AS `product.cover.media.createdAt`, `product.cover.media`.`updated_at` AS `product.cover.media.updatedAt`, `product.cover.media.translation.fallback_1.title`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.fallback_1.title`,`product.cover.media.translation.title`,`product.cover.media.translation.title`) AS `product.cover.media.title`, `product.cover.media.translation.fallback_1.alt`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.fallback_1.alt`,`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) AS `product.cover.media.alt`, `product.cover.media.translation.fallback_1.customFields`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.fallback_1.customFields`,`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) AS `product.cover.media.customFields`, `product.cover.media.translation.fallback_1.createdAt`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.fallback_1.updatedAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.fallback_1.mediaId`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.fallback_1.languageId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` AS `product.cover.customFields`, `product.cover`.`created_at` AS `product.cover.createdAt`, `product.cover`.`updated_at` AS `product.cover.updatedAt`, `product.translation.fallback_1.metaDescription`, `product.parent.translation.fallback_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.fallback_1.metaDescription`,`product.parent.translation.fallback_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) AS `product.metaDescription`, `product.translation.fallback_1.name`, `product.parent.translation.fallback_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.fallback_1.name`,`product.parent.translation.fallback_1.name`,`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) AS `product.name`, `product.translation.fallback_1.keywords`, `product.parent.translation.fallback_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.fallback_1.keywords`,`product.parent.translation.fallback_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) AS `product.keywords`, `product.translation.fallback_1.description`, `product.parent.translation.fallback_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.fallback_1.description`,`product.parent.translation.fallback_1.description`,`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) AS `product.description`, `product.translation.fallback_1.metaTitle`, `product.parent.translation.fallback_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.fallback_1.metaTitle`,`product.parent.translation.fallback_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) AS `product.metaTitle`, `product.translation.fallback_1.packUnit`, `product.parent.translation.fallback_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.fallback_1.packUnit`,`product.parent.translation.fallback_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) AS `product.packUnit`, `product.translation.fallback_1.packUnitPlural`, `product.parent.translation.fallback_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.fallback_1.packUnitPlural`,`product.parent.translation.fallback_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) AS `product.packUnitPlural`, `product.translation.fallback_1.customSearchKeywords`, `product.parent.translation.fallback_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.fallback_1.customSearchKeywords`,`product.parent.translation.fallback_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) AS `product.customSearchKeywords`, `product.translation.fallback_1.slotConfig`, `product.parent.translation.fallback_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.fallback_1.slotConfig`,`product.parent.translation.fallback_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) AS `product.slotConfig`, `product.translation.fallback_1.customFields`, `product.parent.translation.fallback_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.fallback_1.customFields`,`product.parent.translation.fallback_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) AS `product.customFields`, `product.translation.fallback_1.createdAt`, `product.parent.translation.fallback_1.createdAt`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.fallback_1.updatedAt`, `product.parent.translation.fallback_1.updatedAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.fallback_1.productId`, `product.parent.translation.fallback_1.productId`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.fallback_1.languageId`, `product.parent.translation.fallback_1.languageId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.fallback_1.productVersionId`, `product.parent.translation.fallback_1.productVersionId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId`, `product.translation.fallback_1`.meta_description AS `product.translation.fallback_1.metaDescription`, `product.translation.fallback_1`.name AS `product.translation.fallback_1.name`, `product.translation.fallback_1`.keywords AS `product.translation.fallback_1.keywords`, `product.translation.fallback_1`.description AS `product.translation.fallback_1.description`, `product.translation.fallback_1`.meta_title AS `product.translation.fallback_1.metaTitle`, `product.translation.fallback_1`.pack_unit AS `product.translation.fallback_1.packUnit`, `product.translation.fallback_1`.pack_unit_plural AS `product.translation.fallback_1.packUnitPlural`, `product.translation.fallback_1`.custom_search_keywords AS `product.translation.fallback_1.customSearchKeywords`, `product.translation.fallback_1`.slot_config AS `product.translation.fallback_1.slotConfig`, `product.translation.fallback_1`.custom_fields AS `product.translation.fallback_1.customFields`, `product.translation.fallback_1`.created_at AS `product.translation.fallback_1.createdAt`, `product.translation.fallback_1`.updated_at AS `product.translation.fallback_1.updatedAt`, `product.translation.fallback_1`.product_id AS `product.translation.fallback_1.productId`, `product.translation.fallback_1`.language_id AS `product.translation.fallback_1.languageId`, `product.translation.fallback_1`.product_version_id AS `product.translation.fallback_1.productVersionId` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.fallback_1` ON `product.translation`.`product_id` = `product.translation.fallback_1`.`product_id` AND `product.translation.fallback_1`.language_id = ? AND `product.translation`.product_version_id = `product.translation.fallback_1`.product_version_id WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId`, `product.parent.translation.fallback_1`.meta_description AS `product.parent.translation.fallback_1.metaDescription`, `product.parent.translation.fallback_1`.name AS `product.parent.translation.fallback_1.name`, `product.parent.translation.fallback_1`.keywords AS `product.parent.translation.fallback_1.keywords`, `product.parent.translation.fallback_1`.description AS `product.parent.translation.fallback_1.description`, `product.parent.translation.fallback_1`.meta_title AS `product.parent.translation.fallback_1.metaTitle`, `product.parent.translation.fallback_1`.pack_unit AS `product.parent.translation.fallback_1.packUnit`, `product.parent.translation.fallback_1`.pack_unit_plural AS `product.parent.translation.fallback_1.packUnitPlural`, `product.parent.translation.fallback_1`.custom_search_keywords AS `product.parent.translation.fallback_1.customSearchKeywords`, `product.parent.translation.fallback_1`.slot_config AS `product.parent.translation.fallback_1.slotConfig`, `product.parent.translation.fallback_1`.custom_fields AS `product.parent.translation.fallback_1.customFields`, `product.parent.translation.fallback_1`.created_at AS `product.parent.translation.fallback_1.createdAt`, `product.parent.translation.fallback_1`.updated_at AS `product.parent.translation.fallback_1.updatedAt`, `product.parent.translation.fallback_1`.product_id AS `product.parent.translation.fallback_1.productId`, `product.parent.translation.fallback_1`.language_id AS `product.parent.translation.fallback_1.languageId`, `product.parent.translation.fallback_1`.product_version_id AS `product.parent.translation.fallback_1.productVersionId` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.fallback_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.fallback_1`.`product_id` AND `product.parent.translation.fallback_1`.language_id = ? AND `product.parent.translation`.product_version_id = `product.parent.translation.fallback_1`.product_version_id WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name AS `product.manufacturer.translation.name`, `product.manufacturer.translation`.description AS `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields AS `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at AS `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at AS `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id AS `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id AS `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id AS `product.manufacturer.translation.productManufacturerVersionId`, `product.manufacturer.translation.fallback_1`.name AS `product.manufacturer.translation.fallback_1.name`, `product.manufacturer.translation.fallback_1`.description AS `product.manufacturer.translation.fallback_1.description`, `product.manufacturer.translation.fallback_1`.custom_fields AS `product.manufacturer.translation.fallback_1.customFields`, `product.manufacturer.translation.fallback_1`.created_at AS `product.manufacturer.translation.fallback_1.createdAt`, `product.manufacturer.translation.fallback_1`.updated_at AS `product.manufacturer.translation.fallback_1.updatedAt`, `product.manufacturer.translation.fallback_1`.product_manufacturer_id AS `product.manufacturer.translation.fallback_1.productManufacturerId`, `product.manufacturer.translation.fallback_1`.language_id AS `product.manufacturer.translation.fallback_1.languageId`, `product.manufacturer.translation.fallback_1`.product_manufacturer_version_id AS `product.manufacturer.translation.fallback_1.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product.manufacturer.translation.fallback_1` ON `product.manufacturer.translation`.`product_manufacturer_id` = `product.manufacturer.translation.fallback_1`.`product_manufacturer_id` AND `product.manufacturer.translation.fallback_1`.language_id = ? AND `product.manufacturer.translation`.product_manufacturer_version_id = `product.manufacturer.translation.fallback_1`.product_manufacturer_version_id WHERE `product.manufacturer.translation`.language_id = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code AS `product.unit.translation.shortCode`, `product.unit.translation`.name AS `product.unit.translation.name`, `product.unit.translation`.custom_fields AS `product.unit.translation.customFields`, `product.unit.translation`.created_at AS `product.unit.translation.createdAt`, `product.unit.translation`.updated_at AS `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id AS `product.unit.translation.unitId`, `product.unit.translation`.language_id AS `product.unit.translation.languageId`, `product.unit.translation.fallback_1`.short_code AS `product.unit.translation.fallback_1.shortCode`, `product.unit.translation.fallback_1`.name AS `product.unit.translation.fallback_1.name`, `product.unit.translation.fallback_1`.custom_fields AS `product.unit.translation.fallback_1.customFields`, `product.unit.translation.fallback_1`.created_at AS `product.unit.translation.fallback_1.createdAt`, `product.unit.translation.fallback_1`.updated_at AS `product.unit.translation.fallback_1.updatedAt`, `product.unit.translation.fallback_1`.unit_id AS `product.unit.translation.fallback_1.unitId`, `product.unit.translation.fallback_1`.language_id AS `product.unit.translation.fallback_1.languageId` FROM `unit_translation` `product.unit.translation` LEFT JOIN `unit_translation` `product.unit.translation.fallback_1` ON `product.unit.translation`.`unit_id` = `product.unit.translation.fallback_1`.`unit_id` AND `product.unit.translation.fallback_1`.language_id = ? WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name AS `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields AS `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at AS `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at AS `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id AS `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id AS `product.deliveryTime.translation.languageId`, `product.deliveryTime.translation.fallback_1`.name AS `product.deliveryTime.translation.fallback_1.name`, `product.deliveryTime.translation.fallback_1`.custom_fields AS `product.deliveryTime.translation.fallback_1.customFields`, `product.deliveryTime.translation.fallback_1`.created_at AS `product.deliveryTime.translation.fallback_1.createdAt`, `product.deliveryTime.translation.fallback_1`.updated_at AS `product.deliveryTime.translation.fallback_1.updatedAt`, `product.deliveryTime.translation.fallback_1`.delivery_time_id AS `product.deliveryTime.translation.fallback_1.deliveryTimeId`, `product.deliveryTime.translation.fallback_1`.language_id AS `product.deliveryTime.translation.fallback_1.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `product.deliveryTime.translation.fallback_1` ON `product.deliveryTime.translation`.`delivery_time_id` = `product.deliveryTime.translation.fallback_1`.`delivery_time_id` AND `product.deliveryTime.translation.fallback_1`.language_id = ? WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title AS `product.cover.media.translation.title`, `product.cover.media.translation`.alt AS `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields AS `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at AS `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at AS `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id AS `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id AS `product.cover.media.translation.languageId`, `product.cover.media.translation.fallback_1`.title AS `product.cover.media.translation.fallback_1.title`, `product.cover.media.translation.fallback_1`.alt AS `product.cover.media.translation.fallback_1.alt`, `product.cover.media.translation.fallback_1`.custom_fields AS `product.cover.media.translation.fallback_1.customFields`, `product.cover.media.translation.fallback_1`.created_at AS `product.cover.media.translation.fallback_1.createdAt`, `product.cover.media.translation.fallback_1`.updated_at AS `product.cover.media.translation.fallback_1.updatedAt`, `product.cover.media.translation.fallback_1`.media_id AS `product.cover.media.translation.fallback_1.mediaId`, `product.cover.media.translation.fallback_1`.language_id AS `product.cover.media.translation.fallback_1.languageId` FROM `media_translation` `product.cover.media.translation` LEFT JOIN `media_translation` `product.cover.media.translation.fallback_1` ON `product.cover.media.translation`.`media_id` = `product.cover.media.translation.fallback_1`.`media_id` AND `product.cover.media.translation.fallback_1`.language_id = ? WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"ì\x01┘fpÐF░┤¨­\x7FÁ&┼<"
  b"ãâíÞ\x17/A`½˜mˆèÜ£q"
  b"¾!\x17[ÿèMF¾\x19„¦4ó‚ñ"
  b"│t└\x16╝ïHÅÿÏQ©¤╠t^"
  b""ïâ\x13›$H÷œwçÏ\x18Ãx)"
  b"%™\x00NÛ-I·æêÄ(bG“"
  b"║1┤à±rFåûc\x7FØë\x17\x1F0"
  b"솄V¶éMù›†0G…M†\x10"
  b"}÷Ð\x1CÑéLƒ—HåS”Î]!"
  b"\x02-I¸¡ÎJ2‘oPÂÞêÑI"
  b"g:…K\x14áL\f“Ï„ÁÝ@\x1C["
  b"Æuà—a\x1EJ“‘d\x1Dóf'•É"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 0.43 ms 
# product-listing-route::loading::association::prices::read
SELECT `product_price`.`id` AS `product_price.id`, `product_price`.`version_id` AS `product_price.versionId`, `product_price`.`product_id` AS `product_price.productId`, `product_price`.`product_version_id` AS `product_price.productVersionId`, `product_price`.`rule_id` AS `product_price.ruleId`, `product_price`.`price` AS `product_price.price`, `product_price`.`quantity_start` AS `product_price.quantityStart`, `product_price`.`quantity_end` AS `product_price.quantityEnd`, `product_price`.`custom_fields` AS `product_price.customFields`, `product_price`.`created_at` AS `product_price.createdAt`, `product_price`.`updated_at` AS `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x02-I¸¡ÎJ2‘oPÂÞêÑI"
  b""ïâ\x13›$H÷œwçÏ\x18Ãx)"
  b"%™\x00NÛ-I·æêÄ(bG“"
  b"g:…K\x14áL\f“Ï„ÁÝ@\x1C["
  b"}÷Ð\x1CÑéLƒ—HåS”Î]!"
  b"ì\x01┘fpÐF░┤¨­\x7FÁ&┼<"
  b"│t└\x16╝ïHÅÿÏQ©¤╠t^"
  b"║1┤à±rFåûc\x7FØë\x17\x1F0"
  b"¾!\x17[ÿèMF¾\x19„¦4ó‚ñ"
  b"Æuà—a\x1EJ“‘d\x1Dóf'•É"
  b"ãâíÞ\x17/A`½˜mˆèÜ£q"
  b"솄V¶éMù›†0G…M†\x10"
]
View formatted query    View runnable query    Explain query    View query backtrace
36 1.02 ms 
# product-listing-route::loading::association::upSellings::read
SELECT `lampen_product_upsell`.`id` AS `lampen_product_upsell.id`, `lampen_product_upsell`.`position` AS `lampen_product_upsell.position`, `lampen_product_upsell`.`sort_by` AS `lampen_product_upsell.sortBy`, `lampen_product_upsell`.`sort_direction` AS `lampen_product_upsell.sortDirection`, `lampen_product_upsell`.`type` AS `lampen_product_upsell.type`, `lampen_product_upsell`.`active` AS `lampen_product_upsell.active`, `lampen_product_upsell`.`limit` AS `lampen_product_upsell.limit`, `lampen_product_upsell`.`product_id` AS `lampen_product_upsell.productId`, `lampen_product_upsell`.`product_version_id` AS `lampen_product_upsell.productVersionId`, `lampen_product_upsell`.`product_stream_id` AS `lampen_product_upsell.productStreamId`, `lampen_product_upsell`.`created_at` AS `lampen_product_upsell.createdAt`, `lampen_product_upsell`.`updated_at` AS `lampen_product_upsell.updatedAt`, `lampen_product_upsell.translation.fallback_1.name`, `lampen_product_upsell.translation.name`, COALESCE(`lampen_product_upsell.translation.fallback_1.name`,`lampen_product_upsell.translation.name`,`lampen_product_upsell.translation.name`) AS `lampen_product_upsell.name`, `lampen_product_upsell.translation.fallback_1.createdAt`, `lampen_product_upsell.translation.createdAt`, `lampen_product_upsell.translation.fallback_1.updatedAt`, `lampen_product_upsell.translation.updatedAt`, `lampen_product_upsell.translation.fallback_1.lampenProductUpsellId`, `lampen_product_upsell.translation.lampenProductUpsellId`, `lampen_product_upsell.translation.fallback_1.languageId`, `lampen_product_upsell.translation.languageId` FROM `lampen_product_upsell` LEFT JOIN (SELECT `lampen_product_upsell.translation`.lampen_product_upsell_id, `lampen_product_upsell.translation`.name AS `lampen_product_upsell.translation.name`, `lampen_product_upsell.translation`.created_at AS `lampen_product_upsell.translation.createdAt`, `lampen_product_upsell.translation`.updated_at AS `lampen_product_upsell.translation.updatedAt`, `lampen_product_upsell.translation`.lampen_product_upsell_id AS `lampen_product_upsell.translation.lampenProductUpsellId`, `lampen_product_upsell.translation`.language_id AS `lampen_product_upsell.translation.languageId`, `lampen_product_upsell.translation.fallback_1`.name AS `lampen_product_upsell.translation.fallback_1.name`, `lampen_product_upsell.translation.fallback_1`.created_at AS `lampen_product_upsell.translation.fallback_1.createdAt`, `lampen_product_upsell.translation.fallback_1`.updated_at AS `lampen_product_upsell.translation.fallback_1.updatedAt`, `lampen_product_upsell.translation.fallback_1`.lampen_product_upsell_id AS `lampen_product_upsell.translation.fallback_1.lampenProductUpsellId`, `lampen_product_upsell.translation.fallback_1`.language_id AS `lampen_product_upsell.translation.fallback_1.languageId` FROM `lampen_product_upsell_translation` `lampen_product_upsell.translation` LEFT JOIN `lampen_product_upsell_translation` `lampen_product_upsell.translation.fallback_1` ON `lampen_product_upsell.translation`.`lampen_product_upsell_id` = `lampen_product_upsell.translation.fallback_1`.`lampen_product_upsell_id` AND `lampen_product_upsell.translation.fallback_1`.language_id = ? WHERE `lampen_product_upsell.translation`.language_id = ?) `lampen_product_upsell.lampen_product_upsell_translation` ON `lampen_product_upsell.lampen_product_upsell_translation`.`lampen_product_upsell_id` = `lampen_product_upsell`.`id` WHERE (`lampen_product_upsell`.`active` = ? AND `lampen_product_upsell`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"\x02-I¸¡ÎJ2‘oPÂÞêÑI"
  b""ïâ\x13›$H÷œwçÏ\x18Ãx)"
  b"%™\x00NÛ-I·æêÄ(bG“"
  b"g:…K\x14áL\f“Ï„ÁÝ@\x1C["
  b"}÷Ð\x1CÑéLƒ—HåS”Î]!"
  b"ì\x01┘fpÐF░┤¨­\x7FÁ&┼<"
  b"│t└\x16╝ïHÅÿÏQ©¤╠t^"
  b"║1┤à±rFåûc\x7FØë\x17\x1F0"
  b"¾!\x17[ÿèMF¾\x19„¦4ó‚ñ"
  b"Æuà—a\x1EJ“‘d\x1Dóf'•É"
  b"ãâíÞ\x17/A`½˜mˆèÜ£q"
  b"솄V¶éMù›†0G…M†\x10"
]
View formatted query    View runnable query    Explain query    View query backtrace
37 1.77 ms 
# product-listing-route::loading::association::upSellings::association::assignedProducts::read
SELECT `lampen_assigned_upsell_products`.`id` AS `lampen_assigned_upsell_products.id`, `lampen_assigned_upsell_products`.`upsell_id` AS `lampen_assigned_upsell_products.upSellId`, `lampen_assigned_upsell_products`.`product_id` AS `lampen_assigned_upsell_products.productId`, `lampen_assigned_upsell_products`.`product_version_id` AS `lampen_assigned_upsell_products.productVersionId`, `lampen_assigned_upsell_products`.`position` AS `lampen_assigned_upsell_products.position`, `lampen_assigned_upsell_products`.`created_at` AS `lampen_assigned_upsell_products.createdAt`, `lampen_assigned_upsell_products`.`updated_at` AS `lampen_assigned_upsell_products.updatedAt`, `lampen_assigned_upsell_products.product`.`id` AS `lampen_assigned_upsell_products.product.id`, `lampen_assigned_upsell_products.product`.`version_id` AS `lampen_assigned_upsell_products.product.versionId`, `lampen_assigned_upsell_products.product`.`parent_id` AS `lampen_assigned_upsell_products.product.parentId`, `lampen_assigned_upsell_products.product`.`parent_version_id` AS `lampen_assigned_upsell_products.product.parentVersionId`, COALESCE(`lampen_assigned_upsell_products.product`.`product_manufacturer_id`, `lampen_assigned_upsell_products.product.parent`.`product_manufacturer_id`) AS `lampen_assigned_upsell_products.product.manufacturerId`, COALESCE(`lampen_assigned_upsell_products.product`.`product_manufacturer_version_id`, `lampen_assigned_upsell_products.product.parent`.`product_manufacturer_version_id`) AS `lampen_assigned_upsell_products.product.productManufacturerVersionId`, COALESCE(`lampen_assigned_upsell_products.product`.`unit_id`, `lampen_assigned_upsell_products.product.parent`.`unit_id`) AS `lampen_assigned_upsell_products.product.unitId`, COALESCE(`lampen_assigned_upsell_products.product`.`tax_id`, `lampen_assigned_upsell_products.product.parent`.`tax_id`) AS `lampen_assigned_upsell_products.product.taxId`, COALESCE(`lampen_assigned_upsell_products.product`.`product_media_id`, `lampen_assigned_upsell_products.product.parent`.`product_media_id`) AS `lampen_assigned_upsell_products.product.coverId`, COALESCE(`lampen_assigned_upsell_products.product`.`product_media_version_id`, `lampen_assigned_upsell_products.product.parent`.`product_media_version_id`) AS `lampen_assigned_upsell_products.product.productMediaVersionId`, COALESCE(`lampen_assigned_upsell_products.product`.`delivery_time_id`, `lampen_assigned_upsell_products.product.parent`.`delivery_time_id`) AS `lampen_assigned_upsell_products.product.deliveryTimeId`, COALESCE(`lampen_assigned_upsell_products.product`.`product_feature_set_id`, `lampen_assigned_upsell_products.product.parent`.`product_feature_set_id`) AS `lampen_assigned_upsell_products.product.featureSetId`, COALESCE(`lampen_assigned_upsell_products.product`.`canonical_product_id`, `lampen_assigned_upsell_products.product.parent`.`canonical_product_id`) AS `lampen_assigned_upsell_products.product.canonicalProductId`, COALESCE(`lampen_assigned_upsell_products.product`.`cms_page_id`, `lampen_assigned_upsell_products.product.parent`.`cms_page_id`) AS `lampen_assigned_upsell_products.product.cmsPageId`, COALESCE(`lampen_assigned_upsell_products.product`.`cms_page_version_id`, `lampen_assigned_upsell_products.product.parent`.`cms_page_version_id`) AS `lampen_assigned_upsell_products.product.cmsPageVersionId`, `lampen_assigned_upsell_products.product.parent`.`price` AS `lampen_assigned_upsell_products.product.price.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`price`, `lampen_assigned_upsell_products.product.parent`.`price`) AS `lampen_assigned_upsell_products.product.price`, `lampen_assigned_upsell_products.product`.`product_number` AS `lampen_assigned_upsell_products.product.productNumber`, COALESCE(`lampen_assigned_upsell_products.product`.`restock_time`, `lampen_assigned_upsell_products.product.parent`.`restock_time`) AS `lampen_assigned_upsell_products.product.restockTime`, `lampen_assigned_upsell_products.product`.`auto_increment` AS `lampen_assigned_upsell_products.product.autoIncrement`, COALESCE(`lampen_assigned_upsell_products.product`.`active`, `lampen_assigned_upsell_products.product.parent`.`active`) AS `lampen_assigned_upsell_products.product.active`, `lampen_assigned_upsell_products.product`.`available` AS `lampen_assigned_upsell_products.product.available`, COALESCE(`lampen_assigned_upsell_products.product`.`is_closeout`, `lampen_assigned_upsell_products.product.parent`.`is_closeout`) AS `lampen_assigned_upsell_products.product.isCloseout`, `lampen_assigned_upsell_products.product`.`display_group` AS `lampen_assigned_upsell_products.product.displayGroup`, `lampen_assigned_upsell_products.product.parent`.`variant_listing_config` AS `lampen_assigned_upsell_products.product.variantListingConfig.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`variant_listing_config`, `lampen_assigned_upsell_products.product.parent`.`variant_listing_config`) AS `lampen_assigned_upsell_products.product.variantListingConfig`, `lampen_assigned_upsell_products.product`.`variant_restrictions` AS `lampen_assigned_upsell_products.product.variantRestrictions`, COALESCE(`lampen_assigned_upsell_products.product`.`manufacturer_number`, `lampen_assigned_upsell_products.product.parent`.`manufacturer_number`) AS `lampen_assigned_upsell_products.product.manufacturerNumber`, COALESCE(`lampen_assigned_upsell_products.product`.`ean`, `lampen_assigned_upsell_products.product.parent`.`ean`) AS `lampen_assigned_upsell_products.product.ean`, COALESCE(`lampen_assigned_upsell_products.product`.`purchase_steps`, `lampen_assigned_upsell_products.product.parent`.`purchase_steps`) AS `lampen_assigned_upsell_products.product.purchaseSteps`, COALESCE(`lampen_assigned_upsell_products.product`.`max_purchase`, `lampen_assigned_upsell_products.product.parent`.`max_purchase`) AS `lampen_assigned_upsell_products.product.maxPurchase`, COALESCE(`lampen_assigned_upsell_products.product`.`min_purchase`, `lampen_assigned_upsell_products.product.parent`.`min_purchase`) AS `lampen_assigned_upsell_products.product.minPurchase`, COALESCE(`lampen_assigned_upsell_products.product`.`purchase_unit`, `lampen_assigned_upsell_products.product.parent`.`purchase_unit`) AS `lampen_assigned_upsell_products.product.purchaseUnit`, COALESCE(`lampen_assigned_upsell_products.product`.`reference_unit`, `lampen_assigned_upsell_products.product.parent`.`reference_unit`) AS `lampen_assigned_upsell_products.product.referenceUnit`, COALESCE(`lampen_assigned_upsell_products.product`.`shipping_free`, `lampen_assigned_upsell_products.product.parent`.`shipping_free`) AS `lampen_assigned_upsell_products.product.shippingFree`, `lampen_assigned_upsell_products.product.parent`.`purchase_prices` AS `lampen_assigned_upsell_products.product.purchasePrices.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`purchase_prices`, `lampen_assigned_upsell_products.product.parent`.`purchase_prices`) AS `lampen_assigned_upsell_products.product.purchasePrices`, COALESCE(`lampen_assigned_upsell_products.product`.`mark_as_topseller`, `lampen_assigned_upsell_products.product.parent`.`mark_as_topseller`) AS `lampen_assigned_upsell_products.product.markAsTopseller`, COALESCE(`lampen_assigned_upsell_products.product`.`weight`, `lampen_assigned_upsell_products.product.parent`.`weight`) AS `lampen_assigned_upsell_products.product.weight`, COALESCE(`lampen_assigned_upsell_products.product`.`width`, `lampen_assigned_upsell_products.product.parent`.`width`) AS `lampen_assigned_upsell_products.product.width`, COALESCE(`lampen_assigned_upsell_products.product`.`height`, `lampen_assigned_upsell_products.product.parent`.`height`) AS `lampen_assigned_upsell_products.product.height`, COALESCE(`lampen_assigned_upsell_products.product`.`length`, `lampen_assigned_upsell_products.product.parent`.`length`) AS `lampen_assigned_upsell_products.product.length`, COALESCE(`lampen_assigned_upsell_products.product`.`release_date`, `lampen_assigned_upsell_products.product.parent`.`release_date`) AS `lampen_assigned_upsell_products.product.releaseDate`, COALESCE(`lampen_assigned_upsell_products.product`.`rating_average`, `lampen_assigned_upsell_products.product.parent`.`rating_average`) AS `lampen_assigned_upsell_products.product.ratingAverage`, `lampen_assigned_upsell_products.product.parent`.`category_tree` AS `lampen_assigned_upsell_products.product.categoryTree.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`category_tree`, `lampen_assigned_upsell_products.product.parent`.`category_tree`) AS `lampen_assigned_upsell_products.product.categoryTree`, `lampen_assigned_upsell_products.product.parent`.`property_ids` AS `lampen_assigned_upsell_products.product.propertyIds.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`property_ids`, `lampen_assigned_upsell_products.product.parent`.`property_ids`) AS `lampen_assigned_upsell_products.product.propertyIds`, `lampen_assigned_upsell_products.product.parent`.`option_ids` AS `lampen_assigned_upsell_products.product.optionIds.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`option_ids`, `lampen_assigned_upsell_products.product.parent`.`option_ids`) AS `lampen_assigned_upsell_products.product.optionIds`, `lampen_assigned_upsell_products.product.parent`.`stream_ids` AS `lampen_assigned_upsell_products.product.streamIds.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`stream_ids`, `lampen_assigned_upsell_products.product.parent`.`stream_ids`) AS `lampen_assigned_upsell_products.product.streamIds`, `lampen_assigned_upsell_products.product.parent`.`tag_ids` AS `lampen_assigned_upsell_products.product.tagIds.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`tag_ids`, `lampen_assigned_upsell_products.product.parent`.`tag_ids`) AS `lampen_assigned_upsell_products.product.tagIds`, `lampen_assigned_upsell_products.product.parent`.`category_ids` AS `lampen_assigned_upsell_products.product.categoryIds.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`category_ids`, `lampen_assigned_upsell_products.product.parent`.`category_ids`) AS `lampen_assigned_upsell_products.product.categoryIds`, `lampen_assigned_upsell_products.product`.`child_count` AS `lampen_assigned_upsell_products.product.childCount`, COALESCE(`lampen_assigned_upsell_products.product`.`custom_field_set_selection_active`, `lampen_assigned_upsell_products.product.parent`.`custom_field_set_selection_active`) AS `lampen_assigned_upsell_products.product.customFieldSetSelectionActive`, `lampen_assigned_upsell_products.product`.`sales` AS `lampen_assigned_upsell_products.product.sales`, `lampen_assigned_upsell_products.product`.`states` AS `lampen_assigned_upsell_products.product.states`, `lampen_assigned_upsell_products.product.tax`.`id` AS `lampen_assigned_upsell_products.product.tax.id`, `lampen_assigned_upsell_products.product.tax`.`tax_rate` AS `lampen_assigned_upsell_products.product.tax.taxRate`, `lampen_assigned_upsell_products.product.tax`.`name` AS `lampen_assigned_upsell_products.product.tax.name`, `lampen_assigned_upsell_products.product.tax`.`position` AS `lampen_assigned_upsell_products.product.tax.position`, `lampen_assigned_upsell_products.product.tax`.`custom_fields` AS `lampen_assigned_upsell_products.product.tax.customFields`, `lampen_assigned_upsell_products.product.tax`.`created_at` AS `lampen_assigned_upsell_products.product.tax.createdAt`, `lampen_assigned_upsell_products.product.tax`.`updated_at` AS `lampen_assigned_upsell_products.product.tax.updatedAt`, `lampen_assigned_upsell_products.product`.`available_stock` AS `lampen_assigned_upsell_products.product.availableStock`, `lampen_assigned_upsell_products.product`.`stock` AS `lampen_assigned_upsell_products.product.stock`, `lampen_assigned_upsell_products.product.parent`.`cheapest_price` AS `lampen_assigned_upsell_products.product.cheapestPrice.inherited`, COALESCE(`lampen_assigned_upsell_products.product`.`cheapest_price`, `lampen_assigned_upsell_products.product.parent`.`cheapest_price`) AS `lampen_assigned_upsell_products.product.cheapestPrice`, `lampen_assigned_upsell_products.product`.`created_at` AS `lampen_assigned_upsell_products.product.createdAt`, `lampen_assigned_upsell_products.product`.`updated_at` AS `lampen_assigned_upsell_products.product.updatedAt`, `lampen_assigned_upsell_products.product.cover`.`id` AS `lampen_assigned_upsell_products.product.cover.id`, `lampen_assigned_upsell_products.product.cover`.`version_id` AS `lampen_assigned_upsell_products.product.cover.versionId`, `lampen_assigned_upsell_products.product.cover`.`product_id` AS `lampen_assigned_upsell_products.product.cover.productId`, `lampen_assigned_upsell_products.product.cover`.`product_version_id` AS `lampen_assigned_upsell_products.product.cover.productVersionId`, `lampen_assigned_upsell_products.product.cover`.`media_id` AS `lampen_assigned_upsell_products.product.cover.mediaId`, `lampen_assigned_upsell_products.product.cover`.`position` AS `lampen_assigned_upsell_products.product.cover.position`, `lampen_assigned_upsell_products.product.cover.media`.`id` AS `lampen_assigned_upsell_products.product.cover.media.id`, `lampen_assigned_upsell_products.product.cover.media`.`user_id` AS `lampen_assigned_upsell_products.product.cover.media.userId`, `lampen_assigned_upsell_products.product.cover.media`.`media_folder_id` AS `lampen_assigned_upsell_products.product.cover.media.mediaFolderId`, `lampen_assigned_upsell_products.product.cover.media`.`mime_type` AS `lampen_assigned_upsell_products.product.cover.media.mimeType`, `lampen_assigned_upsell_products.product.cover.media`.`file_extension` AS `lampen_assigned_upsell_products.product.cover.media.fileExtension`, `lampen_assigned_upsell_products.product.cover.media`.`uploaded_at` AS `lampen_assigned_upsell_products.product.cover.media.uploadedAt`, `lampen_assigned_upsell_products.product.cover.media`.`file_name` AS `lampen_assigned_upsell_products.product.cover.media.fileName`, `lampen_assigned_upsell_products.product.cover.media`.`file_size` AS `lampen_assigned_upsell_products.product.cover.media.fileSize`, `lampen_assigned_upsell_products.product.cover.media`.`media_type` AS `lampen_assigned_upsell_products.product.cover.media.mediaTypeRaw`, `lampen_assigned_upsell_products.product.cover.media`.`meta_data` AS `lampen_assigned_upsell_products.product.cover.media.metaData`, `lampen_assigned_upsell_products.product.cover.media`.`config` AS `lampen_assigned_upsell_products.product.cover.media.config`, `lampen_assigned_upsell_products.product.cover.media`.`path` AS `lampen_assigned_upsell_products.product.cover.media.path`, `lampen_assigned_upsell_products.product.cover.media`.`private` AS `lampen_assigned_upsell_products.product.cover.media.private`, `lampen_assigned_upsell_products.product.cover.media`.`thumbnails_ro` AS `lampen_assigned_upsell_products.product.cover.media.thumbnailsRo`, `lampen_assigned_upsell_products.product.cover.media`.`created_at` AS `lampen_assigned_upsell_products.product.cover.media.createdAt`, `lampen_assigned_upsell_products.product.cover.media`.`updated_at` AS `lampen_assigned_upsell_products.product.cover.media.updatedAt`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.title`, `lampen_assigned_upsell_products.product.cover.media.translation.title`, COALESCE(`lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.title`,`lampen_assigned_upsell_products.product.cover.media.translation.title`,`lampen_assigned_upsell_products.product.cover.media.translation.title`) AS `lampen_assigned_upsell_products.product.cover.media.title`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.alt`, `lampen_assigned_upsell_products.product.cover.media.translation.alt`, COALESCE(`lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.alt`,`lampen_assigned_upsell_products.product.cover.media.translation.alt`,`lampen_assigned_upsell_products.product.cover.media.translation.alt`) AS `lampen_assigned_upsell_products.product.cover.media.alt`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.customFields`, `lampen_assigned_upsell_products.product.cover.media.translation.customFields`, COALESCE(`lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.customFields`,`lampen_assigned_upsell_products.product.cover.media.translation.customFields`,`lampen_assigned_upsell_products.product.cover.media.translation.customFields`) AS `lampen_assigned_upsell_products.product.cover.media.customFields`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.createdAt`, `lampen_assigned_upsell_products.product.cover.media.translation.createdAt`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.updatedAt`, `lampen_assigned_upsell_products.product.cover.media.translation.updatedAt`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.mediaId`, `lampen_assigned_upsell_products.product.cover.media.translation.mediaId`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.languageId`, `lampen_assigned_upsell_products.product.cover.media.translation.languageId`, `lampen_assigned_upsell_products.product.cover`.`custom_fields` AS `lampen_assigned_upsell_products.product.cover.customFields`, `lampen_assigned_upsell_products.product.cover`.`created_at` AS `lampen_assigned_upsell_products.product.cover.createdAt`, `lampen_assigned_upsell_products.product.cover`.`updated_at` AS `lampen_assigned_upsell_products.product.cover.updatedAt`, `lampen_assigned_upsell_products.product.deliveryTime`.`id` AS `lampen_assigned_upsell_products.product.deliveryTime.id`, `lampen_assigned_upsell_products.product.deliveryTime`.`min` AS `lampen_assigned_upsell_products.product.deliveryTime.min`, `lampen_assigned_upsell_products.product.deliveryTime`.`max` AS `lampen_assigned_upsell_products.product.deliveryTime.max`, `lampen_assigned_upsell_products.product.deliveryTime`.`unit` AS `lampen_assigned_upsell_products.product.deliveryTime.unit`, `lampen_assigned_upsell_products.product.deliveryTime`.`created_at` AS `lampen_assigned_upsell_products.product.deliveryTime.createdAt`, `lampen_assigned_upsell_products.product.deliveryTime`.`updated_at` AS `lampen_assigned_upsell_products.product.deliveryTime.updatedAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.name`, `lampen_assigned_upsell_products.product.deliveryTime.translation.name`, COALESCE(`lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.name`,`lampen_assigned_upsell_products.product.deliveryTime.translation.name`,`lampen_assigned_upsell_products.product.deliveryTime.translation.name`) AS `lampen_assigned_upsell_products.product.deliveryTime.name`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.customFields`, `lampen_assigned_upsell_products.product.deliveryTime.translation.customFields`, COALESCE(`lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.customFields`,`lampen_assigned_upsell_products.product.deliveryTime.translation.customFields`,`lampen_assigned_upsell_products.product.deliveryTime.translation.customFields`) AS `lampen_assigned_upsell_products.product.deliveryTime.customFields`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.createdAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation.createdAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.updatedAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation.updatedAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.deliveryTimeId`, `lampen_assigned_upsell_products.product.deliveryTime.translation.deliveryTimeId`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.languageId`, `lampen_assigned_upsell_products.product.deliveryTime.translation.languageId`, (SELECT GROUP_CONCAT(HEX(`lampen_assigned_upsell_products.product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_property` `lampen_assigned_upsell_products.product.properties.mapping`
                  WHERE `lampen_assigned_upsell_products.product.properties.mapping`.`product_id` = `lampen_assigned_upsell_products.product`.`properties` ) AS `lampen_assigned_upsell_products.product.properties.id_mapping`, `lampen_assigned_upsell_products.product.translation.fallback_1.metaDescription`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.metaDescription`, `lampen_assigned_upsell_products.product.translation.metaDescription`, `lampen_assigned_upsell_products.product.parent.translation.metaDescription`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.metaDescription`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.metaDescription`,`lampen_assigned_upsell_products.product.translation.metaDescription`,`lampen_assigned_upsell_products.product.parent.translation.metaDescription`,`lampen_assigned_upsell_products.product.translation.metaDescription`) AS `lampen_assigned_upsell_products.product.metaDescription`, `lampen_assigned_upsell_products.product.translation.fallback_1.name`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.name`, `lampen_assigned_upsell_products.product.translation.name`, `lampen_assigned_upsell_products.product.parent.translation.name`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.name`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.name`,`lampen_assigned_upsell_products.product.translation.name`,`lampen_assigned_upsell_products.product.parent.translation.name`,`lampen_assigned_upsell_products.product.translation.name`) AS `lampen_assigned_upsell_products.product.name`, `lampen_assigned_upsell_products.product.translation.fallback_1.keywords`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.keywords`, `lampen_assigned_upsell_products.product.translation.keywords`, `lampen_assigned_upsell_products.product.parent.translation.keywords`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.keywords`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.keywords`,`lampen_assigned_upsell_products.product.translation.keywords`,`lampen_assigned_upsell_products.product.parent.translation.keywords`,`lampen_assigned_upsell_products.product.translation.keywords`) AS `lampen_assigned_upsell_products.product.keywords`, `lampen_assigned_upsell_products.product.translation.fallback_1.description`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.description`, `lampen_assigned_upsell_products.product.translation.description`, `lampen_assigned_upsell_products.product.parent.translation.description`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.description`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.description`,`lampen_assigned_upsell_products.product.translation.description`,`lampen_assigned_upsell_products.product.parent.translation.description`,`lampen_assigned_upsell_products.product.translation.description`) AS `lampen_assigned_upsell_products.product.description`, `lampen_assigned_upsell_products.product.translation.fallback_1.metaTitle`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.metaTitle`, `lampen_assigned_upsell_products.product.translation.metaTitle`, `lampen_assigned_upsell_products.product.parent.translation.metaTitle`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.metaTitle`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.metaTitle`,`lampen_assigned_upsell_products.product.translation.metaTitle`,`lampen_assigned_upsell_products.product.parent.translation.metaTitle`,`lampen_assigned_upsell_products.product.translation.metaTitle`) AS `lampen_assigned_upsell_products.product.metaTitle`, `lampen_assigned_upsell_products.product.translation.fallback_1.packUnit`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.packUnit`, `lampen_assigned_upsell_products.product.translation.packUnit`, `lampen_assigned_upsell_products.product.parent.translation.packUnit`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.packUnit`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.packUnit`,`lampen_assigned_upsell_products.product.translation.packUnit`,`lampen_assigned_upsell_products.product.parent.translation.packUnit`,`lampen_assigned_upsell_products.product.translation.packUnit`) AS `lampen_assigned_upsell_products.product.packUnit`, `lampen_assigned_upsell_products.product.translation.fallback_1.packUnitPlural`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.packUnitPlural`, `lampen_assigned_upsell_products.product.translation.packUnitPlural`, `lampen_assigned_upsell_products.product.parent.translation.packUnitPlural`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.packUnitPlural`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.packUnitPlural`,`lampen_assigned_upsell_products.product.translation.packUnitPlural`,`lampen_assigned_upsell_products.product.parent.translation.packUnitPlural`,`lampen_assigned_upsell_products.product.translation.packUnitPlural`) AS `lampen_assigned_upsell_products.product.packUnitPlural`, `lampen_assigned_upsell_products.product.translation.fallback_1.customSearchKeywords`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.customSearchKeywords`, `lampen_assigned_upsell_products.product.translation.customSearchKeywords`, `lampen_assigned_upsell_products.product.parent.translation.customSearchKeywords`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.customSearchKeywords`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.customSearchKeywords`,`lampen_assigned_upsell_products.product.translation.customSearchKeywords`,`lampen_assigned_upsell_products.product.parent.translation.customSearchKeywords`,`lampen_assigned_upsell_products.product.translation.customSearchKeywords`) AS `lampen_assigned_upsell_products.product.customSearchKeywords`, `lampen_assigned_upsell_products.product.translation.fallback_1.slotConfig`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.slotConfig`, `lampen_assigned_upsell_products.product.translation.slotConfig`, `lampen_assigned_upsell_products.product.parent.translation.slotConfig`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.slotConfig`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.slotConfig`,`lampen_assigned_upsell_products.product.translation.slotConfig`,`lampen_assigned_upsell_products.product.parent.translation.slotConfig`,`lampen_assigned_upsell_products.product.translation.slotConfig`) AS `lampen_assigned_upsell_products.product.slotConfig`, `lampen_assigned_upsell_products.product.translation.fallback_1.customFields`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.customFields`, `lampen_assigned_upsell_products.product.translation.customFields`, `lampen_assigned_upsell_products.product.parent.translation.customFields`, COALESCE(`lampen_assigned_upsell_products.product.translation.fallback_1.customFields`,`lampen_assigned_upsell_products.product.parent.translation.fallback_1.customFields`,`lampen_assigned_upsell_products.product.translation.customFields`,`lampen_assigned_upsell_products.product.parent.translation.customFields`,`lampen_assigned_upsell_products.product.translation.customFields`) AS `lampen_assigned_upsell_products.product.customFields`, `lampen_assigned_upsell_products.product.translation.fallback_1.createdAt`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.createdAt`, `lampen_assigned_upsell_products.product.translation.createdAt`, `lampen_assigned_upsell_products.product.parent.translation.createdAt`, `lampen_assigned_upsell_products.product.translation.fallback_1.updatedAt`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.updatedAt`, `lampen_assigned_upsell_products.product.translation.updatedAt`, `lampen_assigned_upsell_products.product.parent.translation.updatedAt`, `lampen_assigned_upsell_products.product.translation.fallback_1.productId`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.productId`, `lampen_assigned_upsell_products.product.translation.productId`, `lampen_assigned_upsell_products.product.parent.translation.productId`, `lampen_assigned_upsell_products.product.translation.fallback_1.languageId`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.languageId`, `lampen_assigned_upsell_products.product.translation.languageId`, `lampen_assigned_upsell_products.product.parent.translation.languageId`, `lampen_assigned_upsell_products.product.translation.fallback_1.productVersionId`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1.productVersionId`, `lampen_assigned_upsell_products.product.translation.productVersionId`, `lampen_assigned_upsell_products.product.parent.translation.productVersionId` FROM `lampen_assigned_upsell_products` LEFT JOIN `product` `lampen_assigned_upsell_products.product` ON `lampen_assigned_upsell_products`.`product_id` = `lampen_assigned_upsell_products.product`.`id` AND `lampen_assigned_upsell_products`.`product_version_id` = `lampen_assigned_upsell_products.product`.`version_id` LEFT JOIN `product` `lampen_assigned_upsell_products.product.parent` ON `lampen_assigned_upsell_products.product`.`parent_id` = `lampen_assigned_upsell_products.product.parent`.`id` AND `lampen_assigned_upsell_products.product`.`parent_version_id` = `lampen_assigned_upsell_products.product.parent`.`version_id` LEFT JOIN (SELECT `lampen_assigned_upsell_products.product.translation`.product_id, `lampen_assigned_upsell_products.product.translation`.product_version_id, `lampen_assigned_upsell_products.product.translation`.meta_description AS `lampen_assigned_upsell_products.product.translation.metaDescription`, `lampen_assigned_upsell_products.product.translation`.name AS `lampen_assigned_upsell_products.product.translation.name`, `lampen_assigned_upsell_products.product.translation`.keywords AS `lampen_assigned_upsell_products.product.translation.keywords`, `lampen_assigned_upsell_products.product.translation`.description AS `lampen_assigned_upsell_products.product.translation.description`, `lampen_assigned_upsell_products.product.translation`.meta_title AS `lampen_assigned_upsell_products.product.translation.metaTitle`, `lampen_assigned_upsell_products.product.translation`.pack_unit AS `lampen_assigned_upsell_products.product.translation.packUnit`, `lampen_assigned_upsell_products.product.translation`.pack_unit_plural AS `lampen_assigned_upsell_products.product.translation.packUnitPlural`, `lampen_assigned_upsell_products.product.translation`.custom_search_keywords AS `lampen_assigned_upsell_products.product.translation.customSearchKeywords`, `lampen_assigned_upsell_products.product.translation`.slot_config AS `lampen_assigned_upsell_products.product.translation.slotConfig`, `lampen_assigned_upsell_products.product.translation`.custom_fields AS `lampen_assigned_upsell_products.product.translation.customFields`, `lampen_assigned_upsell_products.product.translation`.created_at AS `lampen_assigned_upsell_products.product.translation.createdAt`, `lampen_assigned_upsell_products.product.translation`.updated_at AS `lampen_assigned_upsell_products.product.translation.updatedAt`, `lampen_assigned_upsell_products.product.translation`.product_id AS `lampen_assigned_upsell_products.product.translation.productId`, `lampen_assigned_upsell_products.product.translation`.language_id AS `lampen_assigned_upsell_products.product.translation.languageId`, `lampen_assigned_upsell_products.product.translation`.product_version_id AS `lampen_assigned_upsell_products.product.translation.productVersionId`, `lampen_assigned_upsell_products.product.translation.fallback_1`.meta_description AS `lampen_assigned_upsell_products.product.translation.fallback_1.metaDescription`, `lampen_assigned_upsell_products.product.translation.fallback_1`.name AS `lampen_assigned_upsell_products.product.translation.fallback_1.name`, `lampen_assigned_upsell_products.product.translation.fallback_1`.keywords AS `lampen_assigned_upsell_products.product.translation.fallback_1.keywords`, `lampen_assigned_upsell_products.product.translation.fallback_1`.description AS `lampen_assigned_upsell_products.product.translation.fallback_1.description`, `lampen_assigned_upsell_products.product.translation.fallback_1`.meta_title AS `lampen_assigned_upsell_products.product.translation.fallback_1.metaTitle`, `lampen_assigned_upsell_products.product.translation.fallback_1`.pack_unit AS `lampen_assigned_upsell_products.product.translation.fallback_1.packUnit`, `lampen_assigned_upsell_products.product.translation.fallback_1`.pack_unit_plural AS `lampen_assigned_upsell_products.product.translation.fallback_1.packUnitPlural`, `lampen_assigned_upsell_products.product.translation.fallback_1`.custom_search_keywords AS `lampen_assigned_upsell_products.product.translation.fallback_1.customSearchKeywords`, `lampen_assigned_upsell_products.product.translation.fallback_1`.slot_config AS `lampen_assigned_upsell_products.product.translation.fallback_1.slotConfig`, `lampen_assigned_upsell_products.product.translation.fallback_1`.custom_fields AS `lampen_assigned_upsell_products.product.translation.fallback_1.customFields`, `lampen_assigned_upsell_products.product.translation.fallback_1`.created_at AS `lampen_assigned_upsell_products.product.translation.fallback_1.createdAt`, `lampen_assigned_upsell_products.product.translation.fallback_1`.updated_at AS `lampen_assigned_upsell_products.product.translation.fallback_1.updatedAt`, `lampen_assigned_upsell_products.product.translation.fallback_1`.product_id AS `lampen_assigned_upsell_products.product.translation.fallback_1.productId`, `lampen_assigned_upsell_products.product.translation.fallback_1`.language_id AS `lampen_assigned_upsell_products.product.translation.fallback_1.languageId`, `lampen_assigned_upsell_products.product.translation.fallback_1`.product_version_id AS `lampen_assigned_upsell_products.product.translation.fallback_1.productVersionId` FROM `product_translation` `lampen_assigned_upsell_products.product.translation` LEFT JOIN `product_translation` `lampen_assigned_upsell_products.product.translation.fallback_1` ON `lampen_assigned_upsell_products.product.translation`.`product_id` = `lampen_assigned_upsell_products.product.translation.fallback_1`.`product_id` AND `lampen_assigned_upsell_products.product.translation.fallback_1`.language_id = ? AND `lampen_assigned_upsell_products.product.translation`.product_version_id = `lampen_assigned_upsell_products.product.translation.fallback_1`.product_version_id WHERE `lampen_assigned_upsell_products.product.translation`.language_id = ?) `lampen_assigned_upsell_products.product.product_translation` ON `lampen_assigned_upsell_products.product.product_translation`.`product_id` = `lampen_assigned_upsell_products.product`.`id` AND `lampen_assigned_upsell_products.product.product_translation`.product_version_id = `lampen_assigned_upsell_products.product`.version_id LEFT JOIN (SELECT `lampen_assigned_upsell_products.product.parent.translation`.product_id, `lampen_assigned_upsell_products.product.parent.translation`.product_version_id, `lampen_assigned_upsell_products.product.parent.translation`.meta_description AS `lampen_assigned_upsell_products.product.parent.translation.metaDescription`, `lampen_assigned_upsell_products.product.parent.translation`.name AS `lampen_assigned_upsell_products.product.parent.translation.name`, `lampen_assigned_upsell_products.product.parent.translation`.keywords AS `lampen_assigned_upsell_products.product.parent.translation.keywords`, `lampen_assigned_upsell_products.product.parent.translation`.description AS `lampen_assigned_upsell_products.product.parent.translation.description`, `lampen_assigned_upsell_products.product.parent.translation`.meta_title AS `lampen_assigned_upsell_products.product.parent.translation.metaTitle`, `lampen_assigned_upsell_products.product.parent.translation`.pack_unit AS `lampen_assigned_upsell_products.product.parent.translation.packUnit`, `lampen_assigned_upsell_products.product.parent.translation`.pack_unit_plural AS `lampen_assigned_upsell_products.product.parent.translation.packUnitPlural`, `lampen_assigned_upsell_products.product.parent.translation`.custom_search_keywords AS `lampen_assigned_upsell_products.product.parent.translation.customSearchKeywords`, `lampen_assigned_upsell_products.product.parent.translation`.slot_config AS `lampen_assigned_upsell_products.product.parent.translation.slotConfig`, `lampen_assigned_upsell_products.product.parent.translation`.custom_fields AS `lampen_assigned_upsell_products.product.parent.translation.customFields`, `lampen_assigned_upsell_products.product.parent.translation`.created_at AS `lampen_assigned_upsell_products.product.parent.translation.createdAt`, `lampen_assigned_upsell_products.product.parent.translation`.updated_at AS `lampen_assigned_upsell_products.product.parent.translation.updatedAt`, `lampen_assigned_upsell_products.product.parent.translation`.product_id AS `lampen_assigned_upsell_products.product.parent.translation.productId`, `lampen_assigned_upsell_products.product.parent.translation`.language_id AS `lampen_assigned_upsell_products.product.parent.translation.languageId`, `lampen_assigned_upsell_products.product.parent.translation`.product_version_id AS `lampen_assigned_upsell_products.product.parent.translation.productVersionId`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.meta_description AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.metaDescription`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.name AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.name`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.keywords AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.keywords`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.description AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.description`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.meta_title AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.metaTitle`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.pack_unit AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.packUnit`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.pack_unit_plural AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.packUnitPlural`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.custom_search_keywords AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.customSearchKeywords`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.slot_config AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.slotConfig`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.custom_fields AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.customFields`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.created_at AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.createdAt`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.updated_at AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.updatedAt`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.product_id AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.productId`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.language_id AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.languageId`, `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.product_version_id AS `lampen_assigned_upsell_products.product.parent.translation.fallback_1.productVersionId` FROM `product_translation` `lampen_assigned_upsell_products.product.parent.translation` LEFT JOIN `product_translation` `lampen_assigned_upsell_products.product.parent.translation.fallback_1` ON `lampen_assigned_upsell_products.product.parent.translation`.`product_id` = `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.`product_id` AND `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.language_id = ? AND `lampen_assigned_upsell_products.product.parent.translation`.product_version_id = `lampen_assigned_upsell_products.product.parent.translation.fallback_1`.product_version_id WHERE `lampen_assigned_upsell_products.product.parent.translation`.language_id = ?) `lampen_assigned_upsell_products.product.product_translation.parent` ON `lampen_assigned_upsell_products.product.product_translation.parent`.`product_id` = `lampen_assigned_upsell_products.product.parent`.`id` AND `lampen_assigned_upsell_products.product.product_translation.parent`.product_version_id = `lampen_assigned_upsell_products.product.parent`.version_id LEFT JOIN `tax` `lampen_assigned_upsell_products.product.tax` ON `lampen_assigned_upsell_products.product`.`tax` = `lampen_assigned_upsell_products.product.tax`.`id` LEFT JOIN `product_media` `lampen_assigned_upsell_products.product.cover` ON `lampen_assigned_upsell_products.product`.`cover` = `lampen_assigned_upsell_products.product.cover`.`id` AND IFNULL(`lampen_assigned_upsell_products.product`.`product_media_version_id`, `lampen_assigned_upsell_products.product.parent`.`product_media_version_id`) = `lampen_assigned_upsell_products.product.cover`.`version_id` LEFT JOIN `delivery_time` `lampen_assigned_upsell_products.product.deliveryTime` ON `lampen_assigned_upsell_products.product`.`deliveryTime` = `lampen_assigned_upsell_products.product.deliveryTime`.`id` LEFT JOIN `media` `lampen_assigned_upsell_products.product.cover.media` ON `lampen_assigned_upsell_products.product.cover`.`media_id` = `lampen_assigned_upsell_products.product.cover.media`.`id` LEFT JOIN (SELECT `lampen_assigned_upsell_products.product.cover.media.translation`.media_id, `lampen_assigned_upsell_products.product.cover.media.translation`.title AS `lampen_assigned_upsell_products.product.cover.media.translation.title`, `lampen_assigned_upsell_products.product.cover.media.translation`.alt AS `lampen_assigned_upsell_products.product.cover.media.translation.alt`, `lampen_assigned_upsell_products.product.cover.media.translation`.custom_fields AS `lampen_assigned_upsell_products.product.cover.media.translation.customFields`, `lampen_assigned_upsell_products.product.cover.media.translation`.created_at AS `lampen_assigned_upsell_products.product.cover.media.translation.createdAt`, `lampen_assigned_upsell_products.product.cover.media.translation`.updated_at AS `lampen_assigned_upsell_products.product.cover.media.translation.updatedAt`, `lampen_assigned_upsell_products.product.cover.media.translation`.media_id AS `lampen_assigned_upsell_products.product.cover.media.translation.mediaId`, `lampen_assigned_upsell_products.product.cover.media.translation`.language_id AS `lampen_assigned_upsell_products.product.cover.media.translation.languageId`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.title AS `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.title`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.alt AS `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.alt`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.custom_fields AS `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.customFields`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.created_at AS `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.createdAt`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.updated_at AS `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.updatedAt`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.media_id AS `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.mediaId`, `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.language_id AS `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1.languageId` FROM `media_translation` `lampen_assigned_upsell_products.product.cover.media.translation` LEFT JOIN `media_translation` `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1` ON `lampen_assigned_upsell_products.product.cover.media.translation`.`media_id` = `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.`media_id` AND `lampen_assigned_upsell_products.product.cover.media.translation.fallback_1`.language_id = ? WHERE `lampen_assigned_upsell_products.product.cover.media.translation`.language_id = ?) `lampen_assigned_upsell_products.product.cover.media.media_translation` ON `lampen_assigned_upsell_products.product.cover.media.media_translation`.`media_id` = `lampen_assigned_upsell_products.product.cover.media`.`id` LEFT JOIN (SELECT `lampen_assigned_upsell_products.product.deliveryTime.translation`.delivery_time_id, `lampen_assigned_upsell_products.product.deliveryTime.translation`.name AS `lampen_assigned_upsell_products.product.deliveryTime.translation.name`, `lampen_assigned_upsell_products.product.deliveryTime.translation`.custom_fields AS `lampen_assigned_upsell_products.product.deliveryTime.translation.customFields`, `lampen_assigned_upsell_products.product.deliveryTime.translation`.created_at AS `lampen_assigned_upsell_products.product.deliveryTime.translation.createdAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation`.updated_at AS `lampen_assigned_upsell_products.product.deliveryTime.translation.updatedAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation`.delivery_time_id AS `lampen_assigned_upsell_products.product.deliveryTime.translation.deliveryTimeId`, `lampen_assigned_upsell_products.product.deliveryTime.translation`.language_id AS `lampen_assigned_upsell_products.product.deliveryTime.translation.languageId`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1`.name AS `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.name`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1`.custom_fields AS `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.customFields`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1`.created_at AS `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.createdAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1`.updated_at AS `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.updatedAt`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1`.delivery_time_id AS `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.deliveryTimeId`, `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1`.language_id AS `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1.languageId` FROM `delivery_time_translation` `lampen_assigned_upsell_products.product.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1` ON `lampen_assigned_upsell_products.product.deliveryTime.translation`.`delivery_time_id` = `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1`.`delivery_time_id` AND `lampen_assigned_upsell_products.product.deliveryTime.translation.fallback_1`.language_id = ? WHERE `lampen_assigned_upsell_products.product.deliveryTime.translation`.language_id = ?) `lampen_assigned_upsell_products.product.deliveryTime.delivery_time_translation` ON `lampen_assigned_upsell_products.product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `lampen_assigned_upsell_products.product.deliveryTime`.`id` WHERE (`lampen_assigned_upsell_products`.`upsell_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    \x01É~bâ\n
    |âªß▄9,A9x
    """
  b"\x01É}▒J\x0Fv\x0F┐▄U6ÀneB"
  b"\x01Éüå\x06m|Ìüx╬\x06D^_╩"
  b"\x01É~b\x7F¬u▒¼Ç²%:b8\x1A"
  b"\x01É~b}ùrÊ▓3e\vL¶┬p"
  b"\x01É}ÇàÚ{┘«¡z¿z┴¢Ù"
  b"\x01É}░É vc¬º\x17T-L═\x0F"
  b"\x1FhÌ\t24M\x12ª¢G\x05û?I4"
  b"\x01É}░ïbw\x1DÑß5/Û~xå"
  b"\x01É}░Äîu£ò╠<"Ôåøv"
  b"\x01É~bü^t"│w\x02┼┴-Ý\x00"
]
View formatted query    View runnable query    Explain query    View query backtrace
38 0.83 ms 
# product-listing-route::loading::association::upSellings::association::assignedProducts::association::product::association::properties::read
SELECT `property_group_option`.`id` AS `property_group_option.id`, `property_group_option`.`property_group_id` AS `property_group_option.groupId`, `property_group_option`.`color_hex_code` AS `property_group_option.colorHexCode`, `property_group_option`.`media_id` AS `property_group_option.mediaId`, `property_group_option`.`created_at` AS `property_group_option.createdAt`, `property_group_option`.`updated_at` AS `property_group_option.updatedAt`, `property_group_option.group`.`id` AS `property_group_option.group.id`, `property_group_option.group`.`display_type` AS `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` AS `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` AS `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` AS `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` AS `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` AS `property_group_option.group.updatedAt`, `property_group_option.group.translation.fallback_1.name`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.fallback_1.name`,`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) AS `property_group_option.group.name`, `property_group_option.group.translation.fallback_1.description`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.fallback_1.description`,`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) AS `property_group_option.group.description`, `property_group_option.group.translation.fallback_1.position`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.fallback_1.position`,`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) AS `property_group_option.group.position`, `property_group_option.group.translation.fallback_1.customFields`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.fallback_1.customFields`,`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) AS `property_group_option.group.customFields`, `property_group_option.group.translation.fallback_1.createdAt`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.fallback_1.updatedAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.fallback_1.propertyGroupId`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.fallback_1.languageId`, `property_group_option.group.translation.languageId`, `property_group_option.translation.fallback_1.name`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.fallback_1.name`,`property_group_option.translation.name`,`property_group_option.translation.name`) AS `property_group_option.name`, `property_group_option.translation.fallback_1.position`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.fallback_1.position`,`property_group_option.translation.position`,`property_group_option.translation.position`) AS `property_group_option.position`, `property_group_option.translation.fallback_1.customFields`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.fallback_1.customFields`,`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) AS `property_group_option.customFields`, `property_group_option.translation.fallback_1.createdAt`, `property_group_option.translation.createdAt`, `property_group_option.translation.fallback_1.updatedAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.fallback_1.propertyGroupOptionId`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.fallback_1.languageId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name AS `property_group_option.translation.name`, `property_group_option.translation`.position AS `property_group_option.translation.position`, `property_group_option.translation`.custom_fields AS `property_group_option.translation.customFields`, `property_group_option.translation`.created_at AS `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at AS `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id AS `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id AS `property_group_option.translation.languageId`, `property_group_option.translation.fallback_1`.name AS `property_group_option.translation.fallback_1.name`, `property_group_option.translation.fallback_1`.position AS `property_group_option.translation.fallback_1.position`, `property_group_option.translation.fallback_1`.custom_fields AS `property_group_option.translation.fallback_1.customFields`, `property_group_option.translation.fallback_1`.created_at AS `property_group_option.translation.fallback_1.createdAt`, `property_group_option.translation.fallback_1`.updated_at AS `property_group_option.translation.fallback_1.updatedAt`, `property_group_option.translation.fallback_1`.property_group_option_id AS `property_group_option.translation.fallback_1.propertyGroupOptionId`, `property_group_option.translation.fallback_1`.language_id AS `property_group_option.translation.fallback_1.languageId` FROM `property_group_option_translation` `property_group_option.translation` LEFT JOIN `property_group_option_translation` `property_group_option.translation.fallback_1` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.fallback_1`.`property_group_option_id` AND `property_group_option.translation.fallback_1`.language_id = ? WHERE `property_group_option.translation`.language_id = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name AS `property_group_option.group.translation.name`, `property_group_option.group.translation`.description AS `property_group_option.group.translation.description`, `property_group_option.group.translation`.position AS `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields AS `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at AS `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at AS `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id AS `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id AS `property_group_option.group.translation.languageId`, `property_group_option.group.translation.fallback_1`.name AS `property_group_option.group.translation.fallback_1.name`, `property_group_option.group.translation.fallback_1`.description AS `property_group_option.group.translation.fallback_1.description`, `property_group_option.group.translation.fallback_1`.position AS `property_group_option.group.translation.fallback_1.position`, `property_group_option.group.translation.fallback_1`.custom_fields AS `property_group_option.group.translation.fallback_1.customFields`, `property_group_option.group.translation.fallback_1`.created_at AS `property_group_option.group.translation.fallback_1.createdAt`, `property_group_option.group.translation.fallback_1`.updated_at AS `property_group_option.group.translation.fallback_1.updatedAt`, `property_group_option.group.translation.fallback_1`.property_group_id AS `property_group_option.group.translation.fallback_1.propertyGroupId`, `property_group_option.group.translation.fallback_1`.language_id AS `property_group_option.group.translation.fallback_1.languageId` FROM `property_group_translation` `property_group_option.group.translation` LEFT JOIN `property_group_translation` `property_group_option.group.translation.fallback_1` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.fallback_1`.`property_group_id` AND `property_group_option.group.translation.fallback_1`.language_id = ? WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"\tâÖÏ\x1A3L\x16“ÿî \v(FO"
  b"\x14¨Žå‚K©ƒ\x19\x1AX\t¤\x1E\x1E]"
  b"\x19Q!Ä™×DÒ²-^÷,d‘."
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"ˆ‘PééFiÍ\e¹}ÜëyZó"
  b"ŸkZ^~\x1FL7—B•a\x1AZ›`"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"­(5\e°JLÉ┤àðûCÅã─"
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"]█QÈÙ¡Lnå\x1Fì┘¹P ù"
  b"‹êüž\x15\fƒ\x7Fov\x02|aÔ c"
  b"Ø╝"g×\x02z\x0E1┌x)p\x0FãÐ"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"¿ÅÏ\x07\x18zø¡Çèo]°51·"
  b"Á»ßˆýó@mšÊ\x17pî/â¡"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"ï$ÒO¥ÂB†¯þ-ZR:÷Ç"
  b"­(5\e°JLÉ┤àðûCÅã─"
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"]█QÈÙ¡Lnå\x1Fì┘¹P ù"
  b"r¢ƒnNEI5ìS\x07Ó\x06\eM¬"
  b"âeú!ÍØ├n\x11\x15 "¢tý@"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"¿ÅÏ\x07\x18zø¡Çèo]°51·"
  b"Á»ßˆýó@mšÊ\x17pî/â¡"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"ï$ÒO¥ÂB†¯þ-ZR:÷Ç"
  b"­(5\e°JLÉ┤àðûCÅã─"
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"ˆ‘PééFiÍ\e¹}ÜëyZó"
  b"ÉIO{A▄ýÄ!n!\vW\e\x17"
  b"ŸkZ^~\x1FL7—B•a\x1AZ›`"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"­(5\e°JLÉ┤àðûCÅã─"
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"\x02ÐI\x17ÕÊÙOáƱ'\x03\x18ß*"
  b"=üs\x1C\x1DPMt┐C\r§╝>¿I"
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"]█QÈÙ¡Lnå\x1Fì┘¹P ù"
  b"r¢ƒnNEI5ìS\x07Ó\x06\eM¬"
  b"ˆ‘PééFiÍ\e¹}ÜëyZó"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"åo|\x03¥ýœ0Õ\x1A´‹÷4\x00("
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"­(5\e°JLÉ┤àðûCÅã─"
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"\x14• +†_AÀ„\x0Fqr­z¤r"
  b"\x1F\x17§¯]\tO\x12™‚T:—Þ•"
  b""¤\x10\x06‡¸Mê˜ö–†Ž\fèÄ"
  b"1Zı┘▄òAÏÿØwì▄┐╚\x1A"
  b"=üs\x1C\x1DPMt┐C\r§╝>¿I"
  b"?§ÀÀU²ú¹TTA+þYj‰"
  b"L!Ù÷Ñ­Cî½<8³\e]\™"
  b"PÏXBITOg˜òÓ”Ê;Øã"
  b"QÝ`Lò«╠ëÍÊ║8G─Å─"
  b"X<1\x05r\x0EEF”ïÐ]£ŒP^"
  b"Yh¨¹\x02\H¥‘iÖnŸÒ›ã"
  b"[ê¯âÓ%N\x19¥ð³ÞÅ\x1DR^"
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"]█QÈÙ¡Lnå\x1Fì┘¹P ù"
  b"k|íq┬\O\x1AØÆ╗╣øq╗╔"
  b"‰Äî\x1Cò÷šHê=\t1•f»…"
  b"ɪ®ßêxD\f¡E\x0Eü<«îÔ"
  b"ûá¾Øà$L└ï,ùNÌè÷Ë"
  b"░├ÛåÓ¨HÜô\x0F¥uWuÉo"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"Á»ßˆýó@mšÊ\x17pî/â¡"
  b"Éšá¬ìØE\x13¬Zžq%\x01¥ü"
  b"ËÍ”\x0EC¿CŠƒœ Q\x03+\x10\x17"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"åb\x14uVÀI8›\x1FL\x0FØ¿¬\x06"
  b"å‘——œÓA' qÚ’ßuºÌ"
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"Ù\x10P?;ßLØ×17i\x1A+┌:"
  b"ì“\x01éJqIs‡«ÜͧÐÇ\x17"
  b"ï$ÒO¥ÂB†¯þ-ZR:÷Ç"
  b"ö‰çÌ0•l\x17ðNBÁ—&Á²"
]
View formatted query    View runnable query    Explain query    View query backtrace
39 0.33 ms 
# product-listing-route::loading::association::upSellings::association::assignedProducts::association::product::association::properties::association::translations::read
SELECT `property_group_option_translation`.`name` AS `property_group_option_translation.name`, `property_group_option_translation`.`position` AS `property_group_option_translation.position`, `property_group_option_translation`.`custom_fields` AS `property_group_option_translation.customFields`, `property_group_option_translation`.`created_at` AS `property_group_option_translation.createdAt`, `property_group_option_translation`.`updated_at` AS `property_group_option_translation.updatedAt`, `property_group_option_translation`.`property_group_option_id` AS `property_group_option_translation.propertyGroupOptionId`, `property_group_option_translation`.`language_id` AS `property_group_option_translation.languageId` FROM `property_group_option_translation` WHERE (`property_group_option_translation`.`property_group_option_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"\x02ÐI\x17ÕÊÙOáƱ'\x03\x18ß*"
  b"\tâÖÏ\x1A3L\x16“ÿî \v(FO"
  b"\x14• +†_AÀ„\x0Fqr­z¤r"
  b"\x14¨Žå‚K©ƒ\x19\x1AX\t¤\x1E\x1E]"
  b"\x19Q!Ä™×DÒ²-^÷,d‘."
  b"\x1F\x17§¯]\tO\x12™‚T:—Þ•"
  b""¤\x10\x06‡¸Mê˜ö–†Ž\fèÄ"
  b"1Zı┘▄òAÏÿØwì▄┐╚\x1A"
  b"=üs\x1C\x1DPMt┐C\r§╝>¿I"
  b"?§ÀÀU²ú¹TTA+þYj‰"
  b"L!Ù÷Ñ­Cî½<8³\e]\™"
  b"PÏXBITOg˜òÓ”Ê;Øã"
  b"QÝ`Lò«╠ëÍÊ║8G─Å─"
  b"X<1\x05r\x0EEF”ïÐ]£ŒP^"
  b"Yh¨¹\x02\H¥‘iÖnŸÒ›ã"
  b"[ê¯âÓ%N\x19¥ð³ÞÅ\x1DR^"
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"]█QÈÙ¡Lnå\x1Fì┘¹P ù"
  b"k|íq┬\O\x1AØÆ╗╣øq╗╔"
  b"r¢ƒnNEI5ìS\x07Ó\x06\eM¬"
  b"âeú!ÍØ├n\x11\x15 "¢tý@"
  b"ˆ‘PééFiÍ\e¹}ÜëyZó"
  b"‰Äî\x1Cò÷šHê=\t1•f»…"
  b"‹êüž\x15\fƒ\x7Fov\x02|aÔ c"
  b"ÉIO{A▄ýÄ!n!\vW\e\x17"
  b"ɪ®ßêxD\f¡E\x0Eü<«îÔ"
  b"ûá¾Øà$L└ï,ùNÌè÷Ë"
  b"Ø╝"g×\x02z\x0E1┌x)p\x0FãÐ"
  b"ŸkZ^~\x1FL7—B•a\x1AZ›`"
  b"░├ÛåÓ¨HÜô\x0F¥uWuÉo"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"¿ÅÏ\x07\x18zø¡Çèo]°51·"
  b"Á»ßˆýó@mšÊ\x17pî/â¡"
  b"Éšá¬ìØE\x13¬Zžq%\x01¥ü"
  b"ËÍ”\x0EC¿CŠƒœ Q\x03+\x10\x17"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"åb\x14uVÀI8›\x1FL\x0FØ¿¬\x06"
  b"åo|\x03¥ýœ0Õ\x1A´‹÷4\x00("
  b"å‘——œÓA' qÚ’ßuºÌ"
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"Ù\x10P?;ßLØ×17i\x1A+┌:"
  b"ì“\x01éJqIs‡«ÜͧÐÇ\x17"
  b"ï$ÒO¥ÂB†¯þ-ZR:÷Ç"
  b"­(5\e°JLÉ┤àðûCÅã─"
  b"ö‰çÌ0•l\x17ðNBÁ—&Á²"
]
View formatted query    View runnable query    Explain query    View query backtrace
40 0.21 ms 
# product-listing-route::loading::association::upSellings::association::assignedProducts::association::product::association::prices::read
SELECT `product_price`.`id` AS `product_price.id`, `product_price`.`version_id` AS `product_price.versionId`, `product_price`.`product_id` AS `product_price.productId`, `product_price`.`product_version_id` AS `product_price.productVersionId`, `product_price`.`rule_id` AS `product_price.ruleId`, `product_price`.`price` AS `product_price.price`, `product_price`.`quantity_start` AS `product_price.quantityStart`, `product_price`.`quantity_end` AS `product_price.quantityEnd`, `product_price`.`custom_fields` AS `product_price.customFields`, `product_price`.`created_at` AS `product_price.createdAt`, `product_price`.`updated_at` AS `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Qƒ\tÒvÁG¼¥ŒG\x1FÞôWa"
  b"║1┤à±rFåûc\x7FØë\x17\x1F0"
  b"%™\x00NÛ-I·æêÄ(bG“"
  b"┴\x08ø╩óÉBq¼!+%/÷\x04\x08"
  b"ì\x01┘fpÐF░┤¨­\x7FÁ&┼<"
  b"¾!\x17[ÿèMF¾\x19„¦4ó‚ñ"
]
View formatted query    View runnable query    Explain query    View query backtrace
41 0.19 ms 
# product-price-calculator::units::read
SELECT `unit`.`id` AS `unit.id`, `unit`.`created_at` AS `unit.createdAt`, `unit`.`updated_at` AS `unit.updatedAt`, `unit.translation.fallback_1.shortCode`, `unit.translation.shortCode`, COALESCE(`unit.translation.fallback_1.shortCode`,`unit.translation.shortCode`,`unit.translation.shortCode`) AS `unit.shortCode`, `unit.translation.fallback_1.name`, `unit.translation.name`, COALESCE(`unit.translation.fallback_1.name`,`unit.translation.name`,`unit.translation.name`) AS `unit.name`, `unit.translation.fallback_1.customFields`, `unit.translation.customFields`, COALESCE(`unit.translation.fallback_1.customFields`,`unit.translation.customFields`,`unit.translation.customFields`) AS `unit.customFields`, `unit.translation.fallback_1.createdAt`, `unit.translation.createdAt`, `unit.translation.fallback_1.updatedAt`, `unit.translation.updatedAt`, `unit.translation.fallback_1.unitId`, `unit.translation.unitId`, `unit.translation.fallback_1.languageId`, `unit.translation.languageId` FROM `unit` LEFT JOIN (SELECT `unit.translation`.unit_id, `unit.translation`.short_code AS `unit.translation.shortCode`, `unit.translation`.name AS `unit.translation.name`, `unit.translation`.custom_fields AS `unit.translation.customFields`, `unit.translation`.created_at AS `unit.translation.createdAt`, `unit.translation`.updated_at AS `unit.translation.updatedAt`, `unit.translation`.unit_id AS `unit.translation.unitId`, `unit.translation`.language_id AS `unit.translation.languageId`, `unit.translation.fallback_1`.short_code AS `unit.translation.fallback_1.shortCode`, `unit.translation.fallback_1`.name AS `unit.translation.fallback_1.name`, `unit.translation.fallback_1`.custom_fields AS `unit.translation.fallback_1.customFields`, `unit.translation.fallback_1`.created_at AS `unit.translation.fallback_1.createdAt`, `unit.translation.fallback_1`.updated_at AS `unit.translation.fallback_1.updatedAt`, `unit.translation.fallback_1`.unit_id AS `unit.translation.fallback_1.unitId`, `unit.translation.fallback_1`.language_id AS `unit.translation.fallback_1.languageId` FROM `unit_translation` `unit.translation` LEFT JOIN `unit_translation` `unit.translation.fallback_1` ON `unit.translation`.`unit_id` = `unit.translation.fallback_1`.`unit_id` AND `unit.translation.fallback_1`.language_id = ? WHERE `unit.translation`.language_id = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
42 0.39 ms 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500
Parameters: 
[
  true
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"]█QÈÙ¡Lnå\x1Fì┘¹P ù"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"Á»ßˆýó@mšÊ\x17pî/â¡"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"ï$ÒO¥ÂB†¯þ-ZR:÷Ç"
  b"=üs\x1C\x1DPMt┐C\r§╝>¿I"
  b"\x1F\x17§¯]\tO\x12™‚T:—Þ•"
  b""¤\x10\x06‡¸Mê˜ö–†Ž\fèÄ"
  b"1Zı┘▄òAÏÿØwì▄┐╚\x1A"
  b"L!Ù÷Ñ­Cî½<8³\e]\™"
  b"X<1\x05r\x0EEF”ïÐ]£ŒP^"
  b"Yh¨¹\x02\H¥‘iÖnŸÒ›ã"
  b"[ê¯âÓ%N\x19¥ð³ÞÅ\x1DR^"
  b"k|íq┬\O\x1AØÆ╗╣øq╗╔"
  b"ûá¾Øà$L└ï,ùNÌè÷Ë"
  b"░├ÛåÓ¨HÜô\x0F¥uWuÉo"
  b"Éšá¬ìØE\x13¬Zžq%\x01¥ü"
  b"ËÍ”\x0EC¿CŠƒœ Q\x03+\x10\x17"
  b"åb\x14uVÀI8›\x1FL\x0FØ¿¬\x06"
  b"Ù\x10P?;ßLØ×17i\x1A+┌:"
  b"ì“\x01éJqIs‡«ÜͧÐÇ\x17"
  b"­(5\e°JLÉ┤àðûCÅã─"
  b"ö‰çÌ0•l\x17ðNBÁ—&Á²"
  b"\x14• +†_AÀ„\x0Fqr­z¤r"
  b"PÏXBITOg˜òÓ”Ê;Øã"
  b"ɪ®ßêxD\f¡E\x0Eü<«îÔ"
  b"å‘——œÓA' qÚ’ßuºÌ"
  b"ˆ‘PééFiÍ\e¹}ÜëyZó"
  b"¿ÅÏ\x07\x18zø¡Çèo]°51·"
  b"güå„mj\t‚•4…îHlÝÌ"
  b"r¢ƒnNEI5ìS\x07Ó\x06\eM¬"
  b"Ø╝"g×\x02z\x0E1┌x)p\x0FãÐ"
  b"åo|\x03¥ýœ0Õ\x1A´‹÷4\x00("
  b"\x02ÐI\x17ÕÊÙOáƱ'\x03\x18ß*"
  b"\x17 ¡³”ììº%"ÐŒBên>"
  b"\eCuüþ¾Ä¹!Þ║\x05°ı˲"
  b"\ecÂ’4üÛÙ¥v:\rJœŠ\x17"
  b"+\x03í\x19×È\x17\x11‰¯–á5sÇÄ"
  b"8-G6ä‡\™ò8:zå¶ë7"
  b"?§ÀÀU²ú¹TTA+þYj‰"
  b"?¾¦y\e├O$»\x7Fı\x14ð,ËÉ"
  b"QÝ`Lò«╠ëÍÊ║8G─Å─"
  b"V|\x13~’»Lr®“÷Z\ej`\x03"
  b"`ÂÉÌ\x01åf\x18░\x01*¢v>█I"
  b"âeú!ÍØ├n\x11\x15 "¢tý@"
  b"‰Äî\x1Cò÷šHê=\t1•f»…"
  b"‹êüž\x15\fƒ\x7Fov\x02|aÔ c"
  b"É\x1D¡Ù°\x05ä\r═î\x067áZæ"
  b"ö\x07)╗äÕ\x04Zü¾\x0EÂù¶Æ,"
  b"³e×\vø£Vâ\e­çÌF–\x126"
  b"¹çW© ‹]—¸ú\x12,\x123ÞÇ"
  b"║─ƒ3‗\x05Èñ‗╦¦Å░nì`"
  b"×–8\vlÝJ[ªâý’'Ñ®’"
  b"ÛþÊñÎñÏ÷Ë=üíQ\x18¶I"
  b"à»[xμɑ¥âËâ*òz<"
  b"µ°{ÁÀ\x13@Åó\x02╔hÁ¹Ò¹"
  b"ù×Âð^²—m?é,k_ZÐô"
]
View formatted query    View runnable query    Explain query    View query backtrace
43 0.74 ms 
# product-listing::property-filter::read
SELECT `property_group_option`.`id` AS `property_group_option.id`, `property_group_option`.`property_group_id` AS `property_group_option.groupId`, `property_group_option`.`color_hex_code` AS `property_group_option.colorHexCode`, `property_group_option`.`media_id` AS `property_group_option.mediaId`, `property_group_option`.`created_at` AS `property_group_option.createdAt`, `property_group_option`.`updated_at` AS `property_group_option.updatedAt`, `property_group_option.group`.`id` AS `property_group_option.group.id`, `property_group_option.group`.`display_type` AS `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` AS `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` AS `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` AS `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` AS `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` AS `property_group_option.group.updatedAt`, `property_group_option.group.translation.fallback_1.name`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.fallback_1.name`,`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) AS `property_group_option.group.name`, `property_group_option.group.translation.fallback_1.description`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.fallback_1.description`,`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) AS `property_group_option.group.description`, `property_group_option.group.translation.fallback_1.position`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.fallback_1.position`,`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) AS `property_group_option.group.position`, `property_group_option.group.translation.fallback_1.customFields`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.fallback_1.customFields`,`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) AS `property_group_option.group.customFields`, `property_group_option.group.translation.fallback_1.createdAt`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.fallback_1.updatedAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.fallback_1.propertyGroupId`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.fallback_1.languageId`, `property_group_option.group.translation.languageId`, `property_group_option.media`.`id` AS `property_group_option.media.id`, `property_group_option.media`.`user_id` AS `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` AS `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` AS `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` AS `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` AS `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` AS `property_group_option.media.fileName`, `property_group_option.media`.`file_size` AS `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` AS `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` AS `property_group_option.media.metaData`, `property_group_option.media`.`config` AS `property_group_option.media.config`, `property_group_option.media`.`path` AS `property_group_option.media.path`, `property_group_option.media`.`private` AS `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` AS `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` AS `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` AS `property_group_option.media.updatedAt`, `property_group_option.media.translation.fallback_1.title`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.fallback_1.title`,`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) AS `property_group_option.media.title`, `property_group_option.media.translation.fallback_1.alt`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.fallback_1.alt`,`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) AS `property_group_option.media.alt`, `property_group_option.media.translation.fallback_1.customFields`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.fallback_1.customFields`,`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) AS `property_group_option.media.customFields`, `property_group_option.media.translation.fallback_1.createdAt`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.fallback_1.updatedAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.fallback_1.mediaId`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.fallback_1.languageId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.fallback_1.name`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.fallback_1.name`,`property_group_option.translation.name`,`property_group_option.translation.name`) AS `property_group_option.name`, `property_group_option.translation.fallback_1.position`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.fallback_1.position`,`property_group_option.translation.position`,`property_group_option.translation.position`) AS `property_group_option.position`, `property_group_option.translation.fallback_1.customFields`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.fallback_1.customFields`,`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) AS `property_group_option.customFields`, `property_group_option.translation.fallback_1.createdAt`, `property_group_option.translation.createdAt`, `property_group_option.translation.fallback_1.updatedAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.fallback_1.propertyGroupOptionId`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.fallback_1.languageId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name AS `property_group_option.translation.name`, `property_group_option.translation`.position AS `property_group_option.translation.position`, `property_group_option.translation`.custom_fields AS `property_group_option.translation.customFields`, `property_group_option.translation`.created_at AS `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at AS `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id AS `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id AS `property_group_option.translation.languageId`, `property_group_option.translation.fallback_1`.name AS `property_group_option.translation.fallback_1.name`, `property_group_option.translation.fallback_1`.position AS `property_group_option.translation.fallback_1.position`, `property_group_option.translation.fallback_1`.custom_fields AS `property_group_option.translation.fallback_1.customFields`, `property_group_option.translation.fallback_1`.created_at AS `property_group_option.translation.fallback_1.createdAt`, `property_group_option.translation.fallback_1`.updated_at AS `property_group_option.translation.fallback_1.updatedAt`, `property_group_option.translation.fallback_1`.property_group_option_id AS `property_group_option.translation.fallback_1.propertyGroupOptionId`, `property_group_option.translation.fallback_1`.language_id AS `property_group_option.translation.fallback_1.languageId` FROM `property_group_option_translation` `property_group_option.translation` LEFT JOIN `property_group_option_translation` `property_group_option.translation.fallback_1` ON `property_group_option.translation`.`property_group_option_id` = `property_group_option.translation.fallback_1`.`property_group_option_id` AND `property_group_option.translation.fallback_1`.language_id = ? WHERE `property_group_option.translation`.language_id = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name AS `property_group_option.group.translation.name`, `property_group_option.group.translation`.description AS `property_group_option.group.translation.description`, `property_group_option.group.translation`.position AS `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields AS `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at AS `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at AS `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id AS `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id AS `property_group_option.group.translation.languageId`, `property_group_option.group.translation.fallback_1`.name AS `property_group_option.group.translation.fallback_1.name`, `property_group_option.group.translation.fallback_1`.description AS `property_group_option.group.translation.fallback_1.description`, `property_group_option.group.translation.fallback_1`.position AS `property_group_option.group.translation.fallback_1.position`, `property_group_option.group.translation.fallback_1`.custom_fields AS `property_group_option.group.translation.fallback_1.customFields`, `property_group_option.group.translation.fallback_1`.created_at AS `property_group_option.group.translation.fallback_1.createdAt`, `property_group_option.group.translation.fallback_1`.updated_at AS `property_group_option.group.translation.fallback_1.updatedAt`, `property_group_option.group.translation.fallback_1`.property_group_id AS `property_group_option.group.translation.fallback_1.propertyGroupId`, `property_group_option.group.translation.fallback_1`.language_id AS `property_group_option.group.translation.fallback_1.languageId` FROM `property_group_translation` `property_group_option.group.translation` LEFT JOIN `property_group_translation` `property_group_option.group.translation.fallback_1` ON `property_group_option.group.translation`.`property_group_id` = `property_group_option.group.translation.fallback_1`.`property_group_id` AND `property_group_option.group.translation.fallback_1`.language_id = ? WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.media_id, `property_group_option.media.translation`.title AS `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt AS `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields AS `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at AS `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at AS `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id AS `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id AS `property_group_option.media.translation.languageId`, `property_group_option.media.translation.fallback_1`.title AS `property_group_option.media.translation.fallback_1.title`, `property_group_option.media.translation.fallback_1`.alt AS `property_group_option.media.translation.fallback_1.alt`, `property_group_option.media.translation.fallback_1`.custom_fields AS `property_group_option.media.translation.fallback_1.customFields`, `property_group_option.media.translation.fallback_1`.created_at AS `property_group_option.media.translation.fallback_1.createdAt`, `property_group_option.media.translation.fallback_1`.updated_at AS `property_group_option.media.translation.fallback_1.updatedAt`, `property_group_option.media.translation.fallback_1`.media_id AS `property_group_option.media.translation.fallback_1.mediaId`, `property_group_option.media.translation.fallback_1`.language_id AS `property_group_option.media.translation.fallback_1.languageId` FROM `media_translation` `property_group_option.media.translation` LEFT JOIN `media_translation` `property_group_option.media.translation.fallback_1` ON `property_group_option.media.translation`.`media_id` = `property_group_option.media.translation.fallback_1`.`media_id` AND `property_group_option.media.translation.fallback_1`.language_id = ? WHERE `property_group_option.media.translation`.language_id = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\eCuüþ¾Ä¹!Þ║\x05°ı˲"
  b"\ecÂ’4üÛÙ¥v:\rJœŠ\x17"
  b"=üs\x1C\x1DPMt┐C\r§╝>¿I"
  b"?§ÀÀU²ú¹TTA+þYj‰"
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"Ø╝"g×\x02z\x0E1┌x)p\x0FãÐ"
  b"║─ƒ3‗\x05Èñ‗╦¦Å░nì`"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"×–8\vlÝJ[ªâý’'Ñ®’"
  b"ï$ÒO¥ÂB†¯þ-ZR:÷Ç"
]
View formatted query    View runnable query    Explain query    View query backtrace
44 0.32 ms 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 500
Parameters: 
[
  true
  b"\x00\x19#'Óz±k•\x17§>Ö \x03 "
  b"]█QÈÙ¡Lnå\x1Fì┘¹P ù"
  b"¾X5«ýûD_®.Ñ.Áç„\x07"
  b"¿“û\r\¦@ë¬ÜÇØŽÜ\t¥"
  b"èx\v,2PIWƒ\x7F ³º=(¸"
  b"\È®Å\x10°B"¬Çı\x02S─Õ¦"
  b"┐\x16■ìÑeIÀ¥╗\v·Õ¹Á6"
  b"Á»ßˆýó@mšÊ\x17pî/â¡"
  b"ÏÖ8kv…DIˆÐ\x1FÒ€Q\x12p"
  b"ï$ÒO¥ÂB†¯þ-ZR:÷Ç"
  b"=üs\x1C\x1DPMt┐C\r§╝>¿I"
  b"\x1F\x17§¯]\tO\x12™‚T:—Þ•"
  b""¤\x10\x06‡¸Mê˜ö–†Ž\fèÄ"
  b"1Zı┘▄òAÏÿØwì▄┐╚\x1A"
  b"L!Ù÷Ñ­Cî½<8³\e]\™"
  b"X<1\x05r\x0EEF”ïÐ]£ŒP^"
  b"Yh¨¹\x02\H¥‘iÖnŸÒ›ã"
  b"[ê¯âÓ%N\x19¥ð³ÞÅ\x1DR^"
  b"k|íq┬\O\x1AØÆ╗╣øq╗╔"
  b"ûá¾Øà$L└ï,ùNÌè÷Ë"
  b"░├ÛåÓ¨HÜô\x0F¥uWuÉo"
  b"Éšá¬ìØE\x13¬Zžq%\x01¥ü"
  b"ËÍ”\x0EC¿CŠƒœ Q\x03+\x10\x17"
  b"åb\x14uVÀI8›\x1FL\x0FØ¿¬\x06"
  b"Ù\x10P?;ßLØ×17i\x1A+┌:"
  b"ì“\x01éJqIs‡«ÜͧÐÇ\x17"
  b"­(5\e°JLÉ┤àðûCÅã─"
  b"ö‰çÌ0•l\x17ðNBÁ—&Á²"
  b"\x14• +†_AÀ„\x0Fqr­z¤r"
  b"PÏXBITOg˜òÓ”Ê;Øã"
  b"ɪ®ßêxD\f¡E\x0Eü<«îÔ"
  b"å‘——œÓA' qÚ’ßuºÌ"
  b"ˆ‘PééFiÍ\e¹}ÜëyZó"
  b"¿ÅÏ\x07\x18zø¡Çèo]°51·"
  b"güå„mj\t‚•4…îHlÝÌ"
  b"r¢ƒnNEI5ìS\x07Ó\x06\eM¬"
  b"Ø╝"g×\x02z\x0E1┌x)p\x0FãÐ"
  b"åo|\x03¥ýœ0Õ\x1A´‹÷4\x00("
  b"\x02ÐI\x17ÕÊÙOáƱ'\x03\x18ß*"
  b"\x17 ¡³”ììº%"ÐŒBên>"
  b"\eCuüþ¾Ä¹!Þ║\x05°ı˲"
  b"\ecÂ’4üÛÙ¥v:\rJœŠ\x17"
  b"+\x03í\x19×È\x17\x11‰¯–á5sÇÄ"
  b"8-G6ä‡\™ò8:zå¶ë7"
  b"?§ÀÀU²ú¹TTA+þYj‰"
  b"?¾¦y\e├O$»\x7Fı\x14ð,ËÉ"
  b"QÝ`Lò«╠ëÍÊ║8G─Å─"
  b"V|\x13~’»Lr®“÷Z\ej`\x03"
  b"`ÂÉÌ\x01åf\x18░\x01*¢v>█I"
  b"âeú!ÍØ├n\x11\x15 "¢tý@"
  b"‰Äî\x1Cò÷šHê=\t1•f»…"
  b"‹êüž\x15\fƒ\x7Fov\x02|aÔ c"
  b"É\x1D¡Ù°\x05ä\r═î\x067áZæ"
  b"ö\x07)╗äÕ\x04Zü¾\x0EÂù¶Æ,"
  b"³e×\vø£Vâ\e­çÌF–\x126"
  b"¹çW© ‹]—¸ú\x12,\x123ÞÇ"
  b"║─ƒ3‗\x05Èñ‗╦¦Å░nì`"
  b"×–8\vlÝJ[ªâý’'Ñ®’"
  b"ÛþÊñÎñÏ÷Ë=üíQ\x18¶I"
  b"à»[xμɑ¥âËâ*òz<"
  b"µ°{ÁÀ\x13@Åó\x02╔hÁ¹Ò¹"
  b"ù×Âð^²—m?é,k_ZÐô"
]
View formatted query    View runnable query    Explain query    View query backtrace
45 0.13 ms 
SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?
Parameters: 
[
  b"Úıº¡O!@\x02Å{Q\x08t▄▓°"
]
View formatted query    View runnable query    Explain query    View query backtrace
46 0.08 ms 
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
47 0.16 ms 
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id IS NULL) AND (property.module = ?)
Parameters: 
[
  "frontend.navigation.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
48 0.08 ms 
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id = ?) AND (property.module = ?)
Parameters: 
[
  b"\x16+š\x16†}JP¾\x7F¿Û»\x1DíÓ"
  "frontend.navigation.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
49 0.09 ms 
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id = ?) AND (property.module = ?)
Parameters: 
[
  b"pFÒ\x1D¦ôDÄ¢¤\x1F\x19Tßl˜"
  "frontend.navigation.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
50 0.05 ms 
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id = ?) AND (property.module = ?)
Parameters: 
[
  b"}\x17Y║§ÄC;ó¦%┌îŨD"
  "frontend.navigation.page"
]
View formatted query    View runnable query    Explain query    View query backtrace
51 0.42 ms 
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId`, `category.translation.fallback_1`.name AS `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb AS `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config AS `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type AS `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link AS `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link AS `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab AS `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description AS `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title AS `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description AS `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords AS `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields AS `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at AS `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at AS `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id AS `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id AS `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id AS `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_1`.category_version_id WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"4:ÝP«©N~»Ú&`¥z<H"
]
View formatted query    View runnable query    Explain query    View query backtrace
52 0.12 ms 
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
53 0.09 ms 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "nl-NL"
]
View formatted query    View runnable query    Explain query    View query backtrace
54 0.46 ms 
# breadcrumb-extension::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name AS `category.translation.name`, `category.translation`.breadcrumb AS `category.translation.breadcrumb`, `category.translation`.slot_config AS `category.translation.slotConfig`, `category.translation`.link_type AS `category.translation.linkType`, `category.translation`.internal_link AS `category.translation.internalLink`, `category.translation`.external_link AS `category.translation.externalLink`, `category.translation`.link_new_tab AS `category.translation.linkNewTab`, `category.translation`.description AS `category.translation.description`, `category.translation`.meta_title AS `category.translation.metaTitle`, `category.translation`.meta_description AS `category.translation.metaDescription`, `category.translation`.keywords AS `category.translation.keywords`, `category.translation`.custom_fields AS `category.translation.customFields`, `category.translation`.created_at AS `category.translation.createdAt`, `category.translation`.updated_at AS `category.translation.updatedAt`, `category.translation`.category_id AS `category.translation.categoryId`, `category.translation`.language_id AS `category.translation.languageId`, `category.translation`.category_version_id AS `category.translation.categoryVersionId`, `category.translation.fallback_1`.name AS `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb AS `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config AS `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type AS `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link AS `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link AS `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab AS `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description AS `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title AS `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description AS `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords AS `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields AS `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at AS `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at AS `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id AS `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id AS `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id AS `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_1`.category_version_id WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?, ?))
Parameters: 
[
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"▒lÙ&oäÿ\x13îA²kÌØQ┤"
  b"o>)£Rx×\x1C\x7FeIXq#\x13$"
  b"¾=Éh\f6M–•ÃµhÕâ<«"
  b"4:ÝP«©N~»Ú&`¥z<H"
]
View formatted query    View runnable query    Explain query    View query backtrace
55 0.18 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
56 0.06 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
57 0.07 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
58 0.05 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
59 0.07 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
60 0.05 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
61 0.05 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
62 0.06 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
63 0.14 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
64 0.07 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
65 0.10 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
66 0.05 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
67 0.09 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
68 0.05 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
69 0.09 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
70 0.05 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
71 0.09 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
72 0.06 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
73 0.09 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
74 0.06 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
75 0.08 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
76 0.05 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
77 0.09 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
78 0.05 ms 
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters: 
[
  null
  "LampentotaalChangePriceFormat.%"
]
View formatted query    View runnable query    Explain query    View query backtrace
79 2.40 ms 
# 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/343add50aba94e7ebbda2660a57a3c48"
  "/profitmetrics/tracking"
  "/navigation/019ae8aa7d107d6389bc43b910c9bec5"
  "/navigation/420cb4063ad779862fa41f0a19417e4c"
  "/navigation/a769c7b3c35acdf17ff9b9ba7d57de3e"
  "/navigation/b16ceb266f8498138c41fd6bde9d51b4"
  "/navigation/9e984c108157cea74c894b5cf34efc44"
  "/navigation/f0dd4a99fba6075a9494772b58f95280"
  "/navigation/7c4473df6a4b4b63a3e1302d94616c97"
  "/navigation/cfa5301358b9fcbe7aa45b1ceea088c6"
  "/navigation/01e00f2f4bfcbb7505cb641066f2859b"
  "/navigation/f39ae9ff3a81f499230c4126e01f421b"
  "/navigation/9fdb62f932adf55af2c0e09e55861964"
  "/navigation/08f90c1a417155361a5c4b8d297e0d78"
  "/navigation/e93028bdc1aacdfb3687181f2031765d"
  "/navigation/f899139df5e1059396431415e770c6dd"
  "/navigation/5f93f983524def3dca464469d2cf9f3e"
  "/navigation/da4fb5c6e93e74d3df8527599fa62642"
  "/navigation/9b8619251a19057cff70779273e95aa6"
  "/navigation/1385974ed5904a438616ff7bdb3f7439"
  "/navigation/7ef605fc8dba5425d6965fbd4c8fbe1f"
  "/navigation/b73ce398c39f506af761d2277d853a92"
  "/navigation/149e9677a5989fd342ae44213df68868"
  "/navigation/3644a684f98ea8fe223c713b77189a77"
  "/navigation/019a39e23b2c7e279df87b0aa358ad91"
  "/navigation/56ef1f00cd5845fda57aa9872909c4ff"
  "/navigation/1bb780577fd64cf48e5120d0293c0b39"
  "/navigation/61cdd800001945958264ef4e5bc92679"
  "/navigation/bf37ceadd2f94d8cbb87de0250bbc9b8"
  "/navigation/94f6d7e04a4d452035300f18b984988c"
  "/navigation/06eb61b839a0cefee4967c67ccb099dc"
  "/navigation/320722549d1751cf3f247855f937b982"
  "/navigation/fe73f687e5bc5280214e0486b273a5f9"
  "/navigation/40008b9a5380fcacce3976bf7c08af5b"
  "/navigation/9de6d14fff9806d4bcd1ef555be766cd"
  "/navigation/e7b24b112a44fdd9ee93bdf998c6ca0e"
  "/navigation/d709f38ef758b5066ef31b18039b8ce5"
  "/navigation/1068c6e4c8051cfd4e9ea8072e3189e2"
  "/navigation/648c1037b2d94f67804668f6aa8fbc82"
  "/navigation/1e046b60fd2b4aa5a77ff8364a68c911"
  "/navigation/138838f8557c45ffb6970faf8543cabd"
  "/navigation/7169563d15ea44e7a67ebaa5f0a753d9"
  "/navigation/0190c01862bb7299a889e9122eaa5380"
  "/navigation/0190c01932e570bb933cc02b6327917f"
  "/navigation/0190c01a8ed27f47af7fa5c7682025de"
  "/navigation/0190c01ab0837469855dba83f91e75fc"
  "/navigation/0190c01aca5476e9bdfa37166f759232"
  "/navigation/0190c01adf7e729e843b0f7996a1688f"
  "/navigation/bcd3d2d0d08644f3bbf3956df55cbe6e"
  "/navigation/d7a84628c025d30f7b2c52c958767e76"
  "/navigation/7b7a53e239400a13bd6be6c91c4f6c4e"
  "/navigation/2d579dc29360d8bbfbb4aa541de5afa9"
  "/navigation/4c144c47ecba6f8318128703ca9e2601"
  "/navigation/d490d7b4576290fa60eb31b5fc917ad1"
  "/navigation/00ac8ed3b4327bdd4ebbebcb2ba10a00"
  "/navigation/0166adc792b8409e857a3c7360748e09"
  "/navigation/b73dfe25b4b8714c029b37a6ad3006fa"
  "/navigation/9cc138f8dc04cbf16240daa92d8d50e2"
  "/navigation/c442481e2e1f425996cf42770aa4a825"
  "/navigation/1873d66284734bcc867233da154ef29e"
  "/navigation/004000429675402385039e805f5ababf"
  "/navigation/e5841df2166dd424a57127423d276bbe"
  "/navigation/e70611883d2760c8bbafb4acb29e3446"
  "/navigation/5f2c22cb4a5380af7ca75622a6426917"
  "/navigation/d5cfead94f5350c12c322b5b664544c1"
  "/navigation/edfbe1afcf9246bb0d40eb4d8027d90f"
  "/navigation/b137fdd1f79d56c7edf3365fea7520f2"
  "/navigation/7a53928fa4dd31e82c6ef826f341daec"
  "/navigation/ddd5a9cb033f455ca4bdde8c11ff1872"
  "/navigation/1607c31dcf504bdd80c025b15bb8b9c4"
  "/navigation/b6edc1cd1f36e45daf6d7824d7bb2283"
  "/navigation/e2a2dcc36a08a345332c751b2f2e476c"
  "/navigation/ce52eccc353c43abb9e30d62ff7e37b0"
  "/navigation/8e82ab7243b7c66d768f1b8ce1c967eb"
  "/navigation/e205ee2a5de471a70c1fd1b46033a75f"
  "/navigation/d40b2194b7fd4c36837b8f415577be66"
  "/navigation/7188fdfa6d364b28a2ab5e7bf1f3e155"
  "/navigation/be98ddd1fa4f45649c7fc73fb9bce4e4"
  "/navigation/4a8dcdb9a24349708162cec124ddaa93"
  "/navigation/e1d4d8cc81f44afc97b763e61f195db6"
  "/navigation/09cfb08891114e58aabe6578cdd41c18"
  "/navigation/a9b7ba70783b617e9998dc4dd82eb3c5"
  "/navigation/1e6e0a04d20f50967c64dac2d639a577"
  "/navigation/fe2d010308a6b3799a3d9c728ee74244"
  "/navigation/6f3e29a35278d71c7f65495871231324"
  "/navigation/535ab76633d94208236a2e829ea6d888"
  "/navigation/2a50e9c2d6b89b95bcb416d6857f8b45"
  "/navigation/be3dc9680c364d9695c3b568d5e23cab"
  "/navigation/ea3b4f8c7a1e4551b9c86e611dec3762"
  "/navigation/a14ac55a4f27472c5d894ec1c3c743d2"
  "/navigation/806beafe154032a5b818e97b4420ad98"
  "/navigation/46031b3d04dc90994ca317a7c55c4289"
  "/navigation/b41c65cb92e04ba8804ee5710c6fa232"
  "/navigation/84f0f20482cde7e5eacaf7364a643d33"
  "/navigation/b283883b00d743bb98262300fe11c609"
  "/navigation/ffb8f1cc58344d7186bfbf84b3f2e018"
  "/navigation/239bd1c81ec54a6ab05acfabf14fb3da"
  "/navigation/973a5f0ccbc4ee3524ccf035d35b284b"
  "/navigation/9a4400501febb2a95e79248486a5f6d3"
  "/navigation/148510031349642de5ca0c544f31b2ef"
  "/navigation/11d0e6287202fced83f79975ec59a3a6"
  "/navigation/7e7990ca35db471fbfbc38289659efef"
  "/navigation/075ced4801ba4ca993add836425377b9"
  "/navigation/17c5a52d44664a88be7a9c59165fefd3"
  "/navigation/5a142a55461d5fef016acfb927fee0bd"
  "/navigation/feb419e961034f89b10fb89874a5314d"
  "/navigation/1c74e423bff24bef8325750876b38796"
  "/navigation/a456700357c7491ba92c3ec7fb84d0d0"
  "/navigation/8511c99cb1e64db88aca07fc8509e4a3"
  "/navigation/f7f5c9bbef224a52bedbf88e96c2af96"
  "/navigation/3dc465dbdebc42b1a74fd5cd065408c2"
  "/navigation/c0c5c9de5ba240859db6ebf0bb390db9"
  "/navigation/f8a51e51de3a4588aa9e86e09d434cc4"
  "/navigation/99731f952989409bb1695b6bfedab6de"
  "/navigation/6e766b48c86445819fddbceb0cafb9e8"
  "/navigation/eda91523e3d942fb96e7bd86d541d147"
  "/navigation/ed9a6f3394504cc299326333a4da153a"
  "/navigation/7a2cf6e0963b477192bf9b7ffdb74ec5"
  "/navigation/0cf49822a98149259ed7b28275578573"
  "/navigation/6e79ed05baec2754e25b4eac73a332d2"
  "/navigation/f67d3f9e3aa445359d02fef446aad91b"
  "/navigation/f5511f99187541cfa4605f549b777e60"
  "/navigation/1f2e9a5f85294c51affdcc0f5ab97193"
  "/navigation/f2d887e01a80e813d9080038decbbabb"
  "/navigation/39bfda3ee6a64c7191996bb3f6fdda71"
  "/navigation/069654d5ce089c13f642d19f09a3d1c0"
  "/navigation/5d6c744218214b879c4850af4e9a5ec3"
  "/navigation/bb955ecb8ed44c888326d2ed398b641c"
  "/navigation/08302b9965df47d0b656bc43ccf131fa"
  "/navigation/bb7c05da0905452a9e2f6ac0551c41c0"
  "/navigation/1389eba422784335a65458ba009b44f1"
  "/navigation/403943f831664b7e98bb6d986d5e4b9b"
  "/navigation/0dd727dc1afc4540af56a59f101ea73f"
  "/navigation/465d49e638984793a991b97e79d8c33c"
  "/navigation/3ff9b23b7cd14c74ac8b5b02642f9fd3"
  "/navigation/ebd3023a82954114aa7d0ad7d25e889a"
  "/navigation/2adf844de4824675909453eb79a92b40"
  "/navigation/201d7288b4c18a679e48b31c72c30ded"
  "/navigation/c18873da94ed476e927b67ab7cac2921"
  "/navigation/31cb96f0a0b74901910d569fba1b919d"
  "/navigation/f718e94a87c14754b13b5acdb9c3e976"
  "/navigation/0a372253f62f44e0a0b0089455c7eb0b"
  "/navigation/bb6a026bba4944e2b6f18e4cfb545ca1"
  "/navigation/c3a77154db6b454bb2158adef1e37284"
  "/navigation/8c3039bd5842dca3d944faab91447818"
  "/navigation/6e183c98f4b94b7bb757c4cfe83cfc57"
  "/navigation/be7508c3915040f9a23437c44f1e47d4"
  "/navigation/b2f13392a0f14fa990f2959e7787145d"
  "/navigation/83058d4650354d8c8b5df771f824dfd0"
  "/navigation/964e6c4b27aa475ba4c1e0bb1abdceac"
  "/navigation/4d79e8fd0ab84fe0af8a9a5ff2f6daf7"
  "/navigation/96c5c28becf18e71190460a9955aa4d8"
  "/navigation/5e54342bb2c0410fbda18d1ba49c88be"
  "/navigation/31e0fbae548b463bb8547f273cfc9682"
  "/navigation/5045ab551c324123a31922707e2cc40a"
  "/navigation/9ac96369cfe745288f69a12e72269560"
  "/navigation/d305281faf947ca7acade9ad5c8c818c"
  "/navigation/2712c35c698c4a9b94c24a0843001dbd"
  "/navigation/3214a6d842cc69597f9edf26df552e43"
  "/navigation/b18749c5368e45479e84912f878560a6"
  "/navigation/daa7e0b91aa045cab881151b359a384c"
  "/navigation/96edcd649c6d400991ef1ae5b4c70ec6"
  "/navigation/a4847544df7a4a829d40fed80999a56d"
  "/navigation/ab7314887865c4265e896c6e209d1cd6"
  "/navigation/8f2848b2c5fd4e8a95a5f229245e5cb3"
  "/navigation/39b9ff833d684ee8a6b756780aed09a4"
  "/navigation/0a892543332e4883af1115e70ec4045c"
  "/navigation/5d0aa65b5e584e2aa2a0f82166c92b07"
  "/navigation/acd1b4d8a29c462ca699691be95c659e"
  "/navigation/fb041c536f8e4314aa4327a237c4d4ba"
  "/navigation/f1258e5e4b3b475388ce66f69f0d77b5"
  "/navigation/c3538b8ea6b240749a03d3c3308a6b0d"
  "/navigation/e07aa19942cb409f9328c170bab267bb"
  "/navigation/d97da247278b4af18a3cbcef5601f2e6"
  "/navigation/dcbb92ec76bd4210bfd410c8035e3898"
  "/navigation/d1ee81ae803343da86029e3beabcab4a"
  "/navigation/47b378fa926e4ce8959f89a541c31fdf"
  "/navigation/b883b2998c8243c9bbf0150bbe0faef6"
  "/navigation/94483519a46f4633aea3bd491c983eba"
  "/navigation/7542fa00c7e94499b3f878bb777feb8b"
  "/navigation/b546a5413bbf41cc8c878066570a4ad1"
  "/navigation/0b0909e1afbc473a87adc27cf82e8018"
  "/navigation/0a715e89c33f408b80fe5097dac0c7a5"
  "/navigation/877a7db01e8b43dc8ed38525c1d36707"
  "/navigation/30d0de7539cc447ab1347f65ed6fa4ad"
  "/navigation/a2877fcaaa93440e806c6305276f999a"
  "/navigation/8e0ccdda4cbd46dc867fd9c527837bcf"
  "/navigation/e4cbadf51e1a4f689a125dc29954b1f2"
  "/navigation/7169bab79fc04284b63f2a40c33f178b"
  "/navigation/3238968d8de0447b80b2344d4da249fd"
  "/detail/8d01d96670d146b0b4f9f07fb526c53c"
  "/detail/e3e2edde172f4160bd986d88e8dca371"
  "/detail/be21175bffe84d46be1984a634f382f1"
  "/detail/b374c016bc8b488f98d851b8cfcc745e"
  "/detail/22efe2139b2448f79c77e7cf18c37829"
  "/detail/2599004edb2d49c2b7e6eac428624793"
  "/detail/ba31b485f172468696637f9d89171f30"
  "/detail/ec868456b6e94df99b863047854d8610"
  "/detail/7df7d01cd1e94c839748e55394ce5d21"
  "/detail/022d49b8a1ce4a32916f50c2deead149"
  "/detail/673a854b14e14c0c93cf84c1dd401c5b"
  "/detail/c675e097611e4a9391641df3662795c9"
  "/navigation/49ec46f0ce4e4a3e8fd00dfb1677dd61"
  "/navigation/71077ab180704f27bd70247b9afe9b7c"
  "/navigation/7c14c249c04648819671cdf81402edbc"
  "/navigation/0f99a0c1f6974e4f9e962868ccd4fe1b"
  "/navigation/802bd3bc61c742d4bf142e4819ee555c"
  "/navigation/2118052c17a746f092aa8080acfe4ca5"
  "/navigation/ae14e3d38c804ea1877a71f0c2eb6a1a"
  "/navigation/1ac2cef811d24cc5823270343d7af512"
  "/navigation/9fc923cb9eb146d19115c452c07a136e"
  "/navigation/fa631caa27e449d79f7ffc6fbd5dc8e3"
  "/navigation/70dba2be898442058136afadf34fe415"
  "/navigation/9136720bbb9d49fca3e714f5ccce4c08"
  "/navigation/36b5d2ebd8324a8eaeed9d8dac286476"
  "/navigation/0190c019c8fe7a6cb2c4be556537603a"
  "/navigation/b291fd64e1cb4a84a44312442e86f86e"
  "/navigation/019817aa43ef72ad8c9faafff3bf1109"
  "/navigation/4c5a6d1ef448483cb37e7938bf05196d"
  "/navigation/9e01faf4a6d3406cadd9b576a84f4c06"
  b"┐¡┴\x01üìNúö`r‗ô█Üt"
  b"¡éPb╚¶Gƒü\x1D S«Sö¤"
]
View formatted query    View runnable query    Explain query    View query backtrace
80 0.14 ms 
SELECT `rule`.`id` AS `rule.id`, `rule`.`name` AS `rule.name`, `rule`.`priority` AS `rule.priority`, `rule`.`description` AS `rule.description`, `rule`.`payload` AS `rule.payload`, `rule`.`invalid` AS `rule.invalid`, `rule`.`areas` AS `rule.areas`, `rule`.`custom_fields` AS `rule.customFields`, `rule`.`module_types` AS `rule.moduleTypes`, `rule`.`created_at` AS `rule.createdAt`, `rule`.`updated_at` AS `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"ñ\x174IyÁ%.\e²4ü▄s"ó"
  b"]└ã\rù\x16O<ÇAÅÊO\x7F¬╗"
  b"Ë\x1F\eÙ¨\x17BУ'Å;█ûfæ"
  b"ÔÍžôõ\vNá©\x10M\x1CD¢¾—"
  b"ð-É\f4K@ ¥1\x01kMiàP"
  b"Qr╠\v®┤JÑÅò╩‗\x1Fòı""
  b"‗qÄü\x07IEl¢<j@)/Õ\x07"
  b"\x10qûÑ\x15nF\x16§†;ÉÙ±ö9"
  b"E†ýi–°Lc„AOÊ™&­Ÿ"
  b"ýeok¸ÏL\x17¬çÖ%Û5oj"
  b"\x0Eô“+V\x15K˜·§îcGÚ§O"
  b""âÛEÀA@źmŸéxÉQm"
  b"Ђµ—F\N\x05­Æd+C¦° "
]
View formatted query    View runnable query    Explain query    View query backtrace
81 0.08 ms 
SELECT LOWER(HEX(id)) FROM sales_channel
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
82 8.04 ms 
SELECT `lampentotaal_redirect`.`id` FROM `lampentotaal_redirect` WHERE (`lampentotaal_redirect`.`url` = ?) LIMIT 1
Parameters: 
[
  "https://staging.luminairestotal.fr/les-cables-in-lite"
]
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.