Symfony Profiler

Query Metrics

39 Database Queries
25 Different statements
21.82 ms Query time
Queries


SELECT `key`, `value` FROM `app_config`
# 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`;
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;
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',''))
# 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 = ?)
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
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
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 (?))
SELECT module.module, module.response FROM wbm_data_layer_modules module
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
SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
SELECT property.name, property.value, property.id, property.child_count, property.on_event, property.event_name, property.parent_id FROM wbm_data_layer_properties property WHERE (property.parent_id IS NULL) AND (property.module = ?)
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 = ?)
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 = ?)
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 = ?)
SELECT `product`.`id` AS `product.id`, `product`.`version_id` AS `product.versionId`, `product`.`parent_id` AS `product.parentId`, `product`.`parent_version_id` AS `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) AS `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) AS `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) AS `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) AS `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) AS `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) AS `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) AS `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) AS `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) AS `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) AS `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) AS `product.cmsPageVersionId`, `product.parent`.`price` AS `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) AS `product.price`, `product`.`product_number` AS `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) AS `product.restockTime`, `product`.`auto_increment` AS `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) AS `product.active`, `product`.`available` AS `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) AS `product.isCloseout`, `product`.`display_group` AS `product.displayGroup`, `product.parent`.`variant_listing_config` AS `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) AS `product.variantListingConfig`, `product`.`variant_restrictions` AS `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) AS `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) AS `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) AS `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) AS `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) AS `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) AS `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) AS `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) AS `product.shippingFree`, `product.parent`.`purchase_prices` AS `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) AS `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) AS `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) AS `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) AS `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) AS `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) AS `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) AS `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) AS `product.ratingAverage`, `product.parent`.`category_tree` AS `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) AS `product.categoryTree`, `product.parent`.`property_ids` AS `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) AS `product.propertyIds`, `product.parent`.`option_ids` AS `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) AS `product.optionIds`, `product.parent`.`stream_ids` AS `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) AS `product.streamIds`, `product.parent`.`tag_ids` AS `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) AS `product.tagIds`, `product.parent`.`category_ids` AS `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) AS `product.categoryIds`, `product`.`child_count` AS `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) AS `product.customFieldSetSelectionActive`, `product`.`sales` AS `product.sales`, `product`.`states` AS `product.states`, `product.tax`.`id` AS `product.tax.id`, `product.tax`.`tax_rate` AS `product.tax.taxRate`, `product.tax`.`name` AS `product.tax.name`, `product.tax`.`position` AS `product.tax.position`, `product.tax`.`custom_fields` AS `product.tax.customFields`, `product.tax`.`created_at` AS `product.tax.createdAt`, `product.tax`.`updated_at` AS `product.tax.updatedAt`, `product`.`available_stock` AS `product.availableStock`, `product`.`stock` AS `product.stock`, `product`.`created_at` AS `product.createdAt`, `product`.`updated_at` AS `product.updatedAt`, `product.manufacturer`.`id` AS `product.manufacturer.id`, `product.manufacturer`.`version_id` AS `product.manufacturer.versionId`, `product.manufacturer`.`media_id` AS `product.manufacturer.mediaId`, `product.manufacturer`.`link` AS `product.manufacturer.link`, `product.manufacturer`.`created_at` AS `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` AS `product.manufacturer.updatedAt`, `product.manufacturer.translation.fallback_1.name`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.fallback_1.name`,`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) AS `product.manufacturer.name`, `product.manufacturer.translation.fallback_1.description`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.fallback_1.description`,`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) AS `product.manufacturer.description`, `product.manufacturer.translation.fallback_1.customFields`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.fallback_1.customFields`,`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) AS `product.manufacturer.customFields`, `product.manufacturer.translation.fallback_1.createdAt`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.fallback_1.updatedAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.fallback_1.productManufacturerId`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.fallback_1.languageId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.fallback_1.productManufacturerVersionId`, `product.manufacturer.translation.productManufacturerVersionId`, `product.translation.fallback_1.metaDescription`, `product.parent.translation.fallback_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.fallback_1.metaDescription`,`product.parent.translation.fallback_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) AS `product.metaDescription`, `product.translation.fallback_1.name`, `product.parent.translation.fallback_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.fallback_1.name`,`product.parent.translation.fallback_1.name`,`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) AS `product.name`, `product.translation.fallback_1.keywords`, `product.parent.translation.fallback_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.fallback_1.keywords`,`product.parent.translation.fallback_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) AS `product.keywords`, `product.translation.fallback_1.description`, `product.parent.translation.fallback_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.fallback_1.description`,`product.parent.translation.fallback_1.description`,`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) AS `product.description`, `product.translation.fallback_1.metaTitle`, `product.parent.translation.fallback_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.fallback_1.metaTitle`,`product.parent.translation.fallback_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) AS `product.metaTitle`, `product.translation.fallback_1.packUnit`, `product.parent.translation.fallback_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.fallback_1.packUnit`,`product.parent.translation.fallback_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) AS `product.packUnit`, `product.translation.fallback_1.packUnitPlural`, `product.parent.translation.fallback_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.fallback_1.packUnitPlural`,`product.parent.translation.fallback_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) AS `product.packUnitPlural`, `product.translation.fallback_1.customSearchKeywords`, `product.parent.translation.fallback_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.fallback_1.customSearchKeywords`,`product.parent.translation.fallback_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) AS `product.customSearchKeywords`, `product.translation.fallback_1.slotConfig`, `product.parent.translation.fallback_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.fallback_1.slotConfig`,`product.parent.translation.fallback_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) AS `product.slotConfig`, `product.translation.fallback_1.customFields`, `product.parent.translation.fallback_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.fallback_1.customFields`,`product.parent.translation.fallback_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) AS `product.customFields`, `product.translation.fallback_1.createdAt`, `product.parent.translation.fallback_1.createdAt`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.fallback_1.updatedAt`, `product.parent.translation.fallback_1.updatedAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.fallback_1.productId`, `product.parent.translation.fallback_1.productId`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.fallback_1.languageId`, `product.parent.translation.fallback_1.languageId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.fallback_1.productVersionId`, `product.parent.translation.fallback_1.productVersionId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId`, `product.translation.fallback_1`.meta_description AS `product.translation.fallback_1.metaDescription`, `product.translation.fallback_1`.name AS `product.translation.fallback_1.name`, `product.translation.fallback_1`.keywords AS `product.translation.fallback_1.keywords`, `product.translation.fallback_1`.description AS `product.translation.fallback_1.description`, `product.translation.fallback_1`.meta_title AS `product.translation.fallback_1.metaTitle`, `product.translation.fallback_1`.pack_unit AS `product.translation.fallback_1.packUnit`, `product.translation.fallback_1`.pack_unit_plural AS `product.translation.fallback_1.packUnitPlural`, `product.translation.fallback_1`.custom_search_keywords AS `product.translation.fallback_1.customSearchKeywords`, `product.translation.fallback_1`.slot_config AS `product.translation.fallback_1.slotConfig`, `product.translation.fallback_1`.custom_fields AS `product.translation.fallback_1.customFields`, `product.translation.fallback_1`.created_at AS `product.translation.fallback_1.createdAt`, `product.translation.fallback_1`.updated_at AS `product.translation.fallback_1.updatedAt`, `product.translation.fallback_1`.product_id AS `product.translation.fallback_1.productId`, `product.translation.fallback_1`.language_id AS `product.translation.fallback_1.languageId`, `product.translation.fallback_1`.product_version_id AS `product.translation.fallback_1.productVersionId` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.fallback_1` ON `product.translation`.`product_id` = `product.translation.fallback_1`.`product_id` AND `product.translation.fallback_1`.language_id = ? AND `product.translation`.product_version_id = `product.translation.fallback_1`.product_version_id WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId`, `product.parent.translation.fallback_1`.meta_description AS `product.parent.translation.fallback_1.metaDescription`, `product.parent.translation.fallback_1`.name AS `product.parent.translation.fallback_1.name`, `product.parent.translation.fallback_1`.keywords AS `product.parent.translation.fallback_1.keywords`, `product.parent.translation.fallback_1`.description AS `product.parent.translation.fallback_1.description`, `product.parent.translation.fallback_1`.meta_title AS `product.parent.translation.fallback_1.metaTitle`, `product.parent.translation.fallback_1`.pack_unit AS `product.parent.translation.fallback_1.packUnit`, `product.parent.translation.fallback_1`.pack_unit_plural AS `product.parent.translation.fallback_1.packUnitPlural`, `product.parent.translation.fallback_1`.custom_search_keywords AS `product.parent.translation.fallback_1.customSearchKeywords`, `product.parent.translation.fallback_1`.slot_config AS `product.parent.translation.fallback_1.slotConfig`, `product.parent.translation.fallback_1`.custom_fields AS `product.parent.translation.fallback_1.customFields`, `product.parent.translation.fallback_1`.created_at AS `product.parent.translation.fallback_1.createdAt`, `product.parent.translation.fallback_1`.updated_at AS `product.parent.translation.fallback_1.updatedAt`, `product.parent.translation.fallback_1`.product_id AS `product.parent.translation.fallback_1.productId`, `product.parent.translation.fallback_1`.language_id AS `product.parent.translation.fallback_1.languageId`, `product.parent.translation.fallback_1`.product_version_id AS `product.parent.translation.fallback_1.productVersionId` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.fallback_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.fallback_1`.`product_id` AND `product.parent.translation.fallback_1`.language_id = ? AND `product.parent.translation`.product_version_id = `product.parent.translation.fallback_1`.product_version_id WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name AS `product.manufacturer.translation.name`, `product.manufacturer.translation`.description AS `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields AS `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at AS `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at AS `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id AS `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id AS `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id AS `product.manufacturer.translation.productManufacturerVersionId`, `product.manufacturer.translation.fallback_1`.name AS `product.manufacturer.translation.fallback_1.name`, `product.manufacturer.translation.fallback_1`.description AS `product.manufacturer.translation.fallback_1.description`, `product.manufacturer.translation.fallback_1`.custom_fields AS `product.manufacturer.translation.fallback_1.customFields`, `product.manufacturer.translation.fallback_1`.created_at AS `product.manufacturer.translation.fallback_1.createdAt`, `product.manufacturer.translation.fallback_1`.updated_at AS `product.manufacturer.translation.fallback_1.updatedAt`, `product.manufacturer.translation.fallback_1`.product_manufacturer_id AS `product.manufacturer.translation.fallback_1.productManufacturerId`, `product.manufacturer.translation.fallback_1`.language_id AS `product.manufacturer.translation.fallback_1.languageId`, `product.manufacturer.translation.fallback_1`.product_manufacturer_version_id AS `product.manufacturer.translation.fallback_1.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product.manufacturer.translation.fallback_1` ON `product.manufacturer.translation`.`product_manufacturer_id` = `product.manufacturer.translation.fallback_1`.`product_manufacturer_id` AND `product.manufacturer.translation.fallback_1`.language_id = ? AND `product.manufacturer.translation`.product_manufacturer_version_id = `product.manufacturer.translation.fallback_1`.product_manufacturer_version_id WHERE `product.manufacturer.translation`.language_id = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id WHERE (`product`.`version_id` = ?) AND ((`product`.`id` = ?))
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
SELECT option_translation.name FROM product product INNER JOIN product_option product_group ON product_group.product_id = product.id INNER JOIN property_group_option product_option ON product_group.property_group_option_id = product_option.id INNER JOIN property_group_option_translation option_translation ON option_translation.property_group_option_id = product_option.id WHERE (product.id = ?) AND (product.parent_id IS NOT NULL) AND (product.option_ids IS NOT NULL) AND (option_translation.language_id = ?)
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
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
# 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 (?))
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
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
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
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
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
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
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
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
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
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
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
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
# 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)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT LOWER(HEX(id)) FROM sales_channel
SELECT `lampentotaal_redirect`.`id` FROM `lampentotaal_redirect` WHERE (`lampentotaal_redirect`.`url` = ?) LIMIT 1
Database Connections

Name	Service
0	default
Entity Managers

There are no configured entity managers.
Second Level Cache

Second Level Cache is not enabled.
Symfony Profiler

GET https://staging.luminairestotal.fr/detail/07a2395f618342af9623892a7fa830df

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache
