Symfony Profiler

SELECT
  `magmodules_wevshopnl_product_feed`.`id` as `magmodules_wevshopnl_product_feed.id`,
  `magmodules_wevshopnl_product_feed`.`sales_channel_id` as `magmodules_wevshopnl_product_feed.salesChannelId`,
  `magmodules_wevshopnl_product_feed`.`product_feed_url` as `magmodules_wevshopnl_product_feed.productFeedUrl`,
  `magmodules_wevshopnl_product_feed`.`product_count` as `magmodules_wevshopnl_product_feed.productCount`,
  `magmodules_wevshopnl_product_feed`.`cron` as `magmodules_wevshopnl_product_feed.cron`,
  `magmodules_wevshopnl_product_feed`.`updated_at` as `magmodules_wevshopnl_product_feed.updatedAt`,
  `magmodules_wevshopnl_product_feed`.`created_at` as `magmodules_wevshopnl_product_feed.createdAt`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`id` as `magmodules_wevshopnl_product_feed.salesChannel.id`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`type_id` as `magmodules_wevshopnl_product_feed.salesChannel.typeId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`language_id` as `magmodules_wevshopnl_product_feed.salesChannel.languageId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`customer_group_id` as `magmodules_wevshopnl_product_feed.salesChannel.customerGroupId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`currency_id` as `magmodules_wevshopnl_product_feed.salesChannel.currencyId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`payment_method_id` as `magmodules_wevshopnl_product_feed.salesChannel.paymentMethodId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`shipping_method_id` as `magmodules_wevshopnl_product_feed.salesChannel.shippingMethodId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`country_id` as `magmodules_wevshopnl_product_feed.salesChannel.countryId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`analytics_id` as `magmodules_wevshopnl_product_feed.salesChannel.analyticsId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`navigation_category_id` as `magmodules_wevshopnl_product_feed.salesChannel.navigationCategoryId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`navigation_category_version_id` as `magmodules_wevshopnl_product_feed.salesChannel.navigationCategoryVersionId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`navigation_category_depth` as `magmodules_wevshopnl_product_feed.salesChannel.navigationCategoryDepth`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`footer_category_id` as `magmodules_wevshopnl_product_feed.salesChannel.footerCategoryId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`footer_category_version_id` as `magmodules_wevshopnl_product_feed.salesChannel.footerCategoryVersionId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`service_category_id` as `magmodules_wevshopnl_product_feed.salesChannel.serviceCategoryId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`service_category_version_id` as `magmodules_wevshopnl_product_feed.salesChannel.serviceCategoryVersionId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`mail_header_footer_id` as `magmodules_wevshopnl_product_feed.salesChannel.mailHeaderFooterId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`hreflang_default_domain_id` as `magmodules_wevshopnl_product_feed.salesChannel.hreflangDefaultDomainId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`short_name` as `magmodules_wevshopnl_product_feed.salesChannel.shortName`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`tax_calculation_type` as `magmodules_wevshopnl_product_feed.salesChannel.taxCalculationType`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`access_key` as `magmodules_wevshopnl_product_feed.salesChannel.accessKey`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`configuration` as `magmodules_wevshopnl_product_feed.salesChannel.configuration`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`active` as `magmodules_wevshopnl_product_feed.salesChannel.active`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`hreflang_active` as `magmodules_wevshopnl_product_feed.salesChannel.hreflangActive`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`maintenance` as `magmodules_wevshopnl_product_feed.salesChannel.maintenance`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`maintenance_ip_whitelist` as `magmodules_wevshopnl_product_feed.salesChannel.maintenanceIpWhitelist`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`payment_method_ids` as `magmodules_wevshopnl_product_feed.salesChannel.paymentMethodIds`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`home_cms_page_id` as `magmodules_wevshopnl_product_feed.salesChannel.homeCmsPageId`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`home_cms_page_version_id` as `magmodules_wevshopnl_product_feed.salesChannel.homeCmsPageVersionId`,
  `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`id` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.id`,
  `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`tracking_id` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.trackingId`,
  `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`active` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.active`,
  `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`track_orders` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.trackOrders`,
  `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`anonymize_ip` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.anonymizeIp`,
  `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`created_at` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.createdAt`,
  `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`updated_at` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.updatedAt`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`created_at` as `magmodules_wevshopnl_product_feed.salesChannel.createdAt`,
  `magmodules_wevshopnl_product_feed.salesChannel`.`updated_at` as `magmodules_wevshopnl_product_feed.salesChannel.updatedAt`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.name`,
  COALESCE(
    `magmodules_wevshopnl_product_feed.salesChannel.translation.name`,
    `magmodules_wevshopnl_product_feed.salesChannel.translation.name`
  ) as `magmodules_wevshopnl_product_feed.salesChannel.name`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.homeSlotConfig`,
  COALESCE(
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeSlotConfig`,
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeSlotConfig`
  ) as `magmodules_wevshopnl_product_feed.salesChannel.homeSlotConfig`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.homeEnabled`,
  COALESCE(
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeEnabled`,
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeEnabled`
  ) as `magmodules_wevshopnl_product_feed.salesChannel.homeEnabled`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.homeName`,
  COALESCE(
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeName`,
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeName`
  ) as `magmodules_wevshopnl_product_feed.salesChannel.homeName`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaTitle`,
  COALESCE(
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaTitle`,
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaTitle`
  ) as `magmodules_wevshopnl_product_feed.salesChannel.homeMetaTitle`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaDescription`,
  COALESCE(
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaDescription`,
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaDescription`
  ) as `magmodules_wevshopnl_product_feed.salesChannel.homeMetaDescription`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.homeKeywords`,
  COALESCE(
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeKeywords`,
    `magmodules_wevshopnl_product_feed.salesChannel.translation.homeKeywords`
  ) as `magmodules_wevshopnl_product_feed.salesChannel.homeKeywords`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.customFields`,
  COALESCE(
    `magmodules_wevshopnl_product_feed.salesChannel.translation.customFields`,
    `magmodules_wevshopnl_product_feed.salesChannel.translation.customFields`
  ) as `magmodules_wevshopnl_product_feed.salesChannel.customFields`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.createdAt`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.updatedAt`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.salesChannelId`,
  `magmodules_wevshopnl_product_feed.salesChannel.translation.languageId`
FROM
  `magmodules_wevshopnl_product_feed`
  LEFT JOIN `sales_channel` `magmodules_wevshopnl_product_feed.salesChannel` ON `magmodules_wevshopnl_product_feed`.`sales_channel_id` = `magmodules_wevshopnl_product_feed.salesChannel`.`id`
  LEFT JOIN (
    SELECT
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.sales_channel_id,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.name as `magmodules_wevshopnl_product_feed.salesChannel.translation.name`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_slot_config as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeSlotConfig`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_enabled as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeEnabled`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_name as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeName`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_meta_title as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaTitle`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_meta_description as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaDescription`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_keywords as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeKeywords`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.custom_fields as `magmodules_wevshopnl_product_feed.salesChannel.translation.customFields`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.created_at as `magmodules_wevshopnl_product_feed.salesChannel.translation.createdAt`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.updated_at as `magmodules_wevshopnl_product_feed.salesChannel.translation.updatedAt`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.sales_channel_id as `magmodules_wevshopnl_product_feed.salesChannel.translation.salesChannelId`,
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.language_id as `magmodules_wevshopnl_product_feed.salesChannel.translation.languageId`
    FROM
      `sales_channel_translation` `magmodules_wevshopnl_product_feed.salesChannel.translation`
    WHERE
      `magmodules_wevshopnl_product_feed.salesChannel.translation`.language_id = ?
  ) `magmodules_wevshopnl_product_feed.salesChannel.sales_channel_translation` ON `magmodules_wevshopnl_product_feed.salesChannel.sales_channel_translation`.`sales_channel_id` = `magmodules_wevshopnl_product_feed.salesChannel`.`id`
  LEFT JOIN `sales_channel_analytics` `magmodules_wevshopnl_product_feed.salesChannel.analytics` ON `magmodules_wevshopnl_product_feed.salesChannel`.`analytics_id` = `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`id`
WHERE
  (
    `magmodules_wevshopnl_product_feed.salesChannel`.`active` = ?
  )

SELECT `magmodules_wevshopnl_product_feed`.`id` as `magmodules_wevshopnl_product_feed.id`, `magmodules_wevshopnl_product_feed`.`sales_channel_id` as `magmodules_wevshopnl_product_feed.salesChannelId`, `magmodules_wevshopnl_product_feed`.`product_feed_url` as `magmodules_wevshopnl_product_feed.productFeedUrl`, `magmodules_wevshopnl_product_feed`.`product_count` as `magmodules_wevshopnl_product_feed.productCount`, `magmodules_wevshopnl_product_feed`.`cron` as `magmodules_wevshopnl_product_feed.cron`, `magmodules_wevshopnl_product_feed`.`updated_at` as `magmodules_wevshopnl_product_feed.updatedAt`, `magmodules_wevshopnl_product_feed`.`created_at` as `magmodules_wevshopnl_product_feed.createdAt`, `magmodules_wevshopnl_product_feed.salesChannel`.`id` as `magmodules_wevshopnl_product_feed.salesChannel.id`, `magmodules_wevshopnl_product_feed.salesChannel`.`type_id` as `magmodules_wevshopnl_product_feed.salesChannel.typeId`, `magmodules_wevshopnl_product_feed.salesChannel`.`language_id` as `magmodules_wevshopnl_product_feed.salesChannel.languageId`, `magmodules_wevshopnl_product_feed.salesChannel`.`customer_group_id` as `magmodules_wevshopnl_product_feed.salesChannel.customerGroupId`, `magmodules_wevshopnl_product_feed.salesChannel`.`currency_id` as `magmodules_wevshopnl_product_feed.salesChannel.currencyId`, `magmodules_wevshopnl_product_feed.salesChannel`.`payment_method_id` as `magmodules_wevshopnl_product_feed.salesChannel.paymentMethodId`, `magmodules_wevshopnl_product_feed.salesChannel`.`shipping_method_id` as `magmodules_wevshopnl_product_feed.salesChannel.shippingMethodId`, `magmodules_wevshopnl_product_feed.salesChannel`.`country_id` as `magmodules_wevshopnl_product_feed.salesChannel.countryId`, `magmodules_wevshopnl_product_feed.salesChannel`.`analytics_id` as `magmodules_wevshopnl_product_feed.salesChannel.analyticsId`, `magmodules_wevshopnl_product_feed.salesChannel`.`navigation_category_id` as `magmodules_wevshopnl_product_feed.salesChannel.navigationCategoryId`, `magmodules_wevshopnl_product_feed.salesChannel`.`navigation_category_version_id` as `magmodules_wevshopnl_product_feed.salesChannel.navigationCategoryVersionId`, `magmodules_wevshopnl_product_feed.salesChannel`.`navigation_category_depth` as `magmodules_wevshopnl_product_feed.salesChannel.navigationCategoryDepth`, `magmodules_wevshopnl_product_feed.salesChannel`.`footer_category_id` as `magmodules_wevshopnl_product_feed.salesChannel.footerCategoryId`, `magmodules_wevshopnl_product_feed.salesChannel`.`footer_category_version_id` as `magmodules_wevshopnl_product_feed.salesChannel.footerCategoryVersionId`, `magmodules_wevshopnl_product_feed.salesChannel`.`service_category_id` as `magmodules_wevshopnl_product_feed.salesChannel.serviceCategoryId`, `magmodules_wevshopnl_product_feed.salesChannel`.`service_category_version_id` as `magmodules_wevshopnl_product_feed.salesChannel.serviceCategoryVersionId`, `magmodules_wevshopnl_product_feed.salesChannel`.`mail_header_footer_id` as `magmodules_wevshopnl_product_feed.salesChannel.mailHeaderFooterId`, `magmodules_wevshopnl_product_feed.salesChannel`.`hreflang_default_domain_id` as `magmodules_wevshopnl_product_feed.salesChannel.hreflangDefaultDomainId`, `magmodules_wevshopnl_product_feed.salesChannel`.`short_name` as `magmodules_wevshopnl_product_feed.salesChannel.shortName`, `magmodules_wevshopnl_product_feed.salesChannel`.`tax_calculation_type` as `magmodules_wevshopnl_product_feed.salesChannel.taxCalculationType`, `magmodules_wevshopnl_product_feed.salesChannel`.`access_key` as `magmodules_wevshopnl_product_feed.salesChannel.accessKey`, `magmodules_wevshopnl_product_feed.salesChannel`.`configuration` as `magmodules_wevshopnl_product_feed.salesChannel.configuration`, `magmodules_wevshopnl_product_feed.salesChannel`.`active` as `magmodules_wevshopnl_product_feed.salesChannel.active`, `magmodules_wevshopnl_product_feed.salesChannel`.`hreflang_active` as `magmodules_wevshopnl_product_feed.salesChannel.hreflangActive`, `magmodules_wevshopnl_product_feed.salesChannel`.`maintenance` as `magmodules_wevshopnl_product_feed.salesChannel.maintenance`, `magmodules_wevshopnl_product_feed.salesChannel`.`maintenance_ip_whitelist` as `magmodules_wevshopnl_product_feed.salesChannel.maintenanceIpWhitelist`, `magmodules_wevshopnl_product_feed.salesChannel`.`payment_method_ids` as `magmodules_wevshopnl_product_feed.salesChannel.paymentMethodIds`, `magmodules_wevshopnl_product_feed.salesChannel`.`home_cms_page_id` as `magmodules_wevshopnl_product_feed.salesChannel.homeCmsPageId`, `magmodules_wevshopnl_product_feed.salesChannel`.`home_cms_page_version_id` as `magmodules_wevshopnl_product_feed.salesChannel.homeCmsPageVersionId`, `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`id` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.id`, `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`tracking_id` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.trackingId`, `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`active` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.active`, `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`track_orders` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.trackOrders`, `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`anonymize_ip` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.anonymizeIp`, `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`created_at` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.createdAt`, `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`updated_at` as `magmodules_wevshopnl_product_feed.salesChannel.analytics.updatedAt`, `magmodules_wevshopnl_product_feed.salesChannel`.`created_at` as `magmodules_wevshopnl_product_feed.salesChannel.createdAt`, `magmodules_wevshopnl_product_feed.salesChannel`.`updated_at` as `magmodules_wevshopnl_product_feed.salesChannel.updatedAt`, `magmodules_wevshopnl_product_feed.salesChannel.translation.name`, COALESCE(`magmodules_wevshopnl_product_feed.salesChannel.translation.name`,`magmodules_wevshopnl_product_feed.salesChannel.translation.name`) as `magmodules_wevshopnl_product_feed.salesChannel.name`, `magmodules_wevshopnl_product_feed.salesChannel.translation.homeSlotConfig`, COALESCE(`magmodules_wevshopnl_product_feed.salesChannel.translation.homeSlotConfig`,`magmodules_wevshopnl_product_feed.salesChannel.translation.homeSlotConfig`) as `magmodules_wevshopnl_product_feed.salesChannel.homeSlotConfig`, `magmodules_wevshopnl_product_feed.salesChannel.translation.homeEnabled`, COALESCE(`magmodules_wevshopnl_product_feed.salesChannel.translation.homeEnabled`,`magmodules_wevshopnl_product_feed.salesChannel.translation.homeEnabled`) as `magmodules_wevshopnl_product_feed.salesChannel.homeEnabled`, `magmodules_wevshopnl_product_feed.salesChannel.translation.homeName`, COALESCE(`magmodules_wevshopnl_product_feed.salesChannel.translation.homeName`,`magmodules_wevshopnl_product_feed.salesChannel.translation.homeName`) as `magmodules_wevshopnl_product_feed.salesChannel.homeName`, `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaTitle`, COALESCE(`magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaTitle`,`magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaTitle`) as `magmodules_wevshopnl_product_feed.salesChannel.homeMetaTitle`, `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaDescription`, COALESCE(`magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaDescription`,`magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaDescription`) as `magmodules_wevshopnl_product_feed.salesChannel.homeMetaDescription`, `magmodules_wevshopnl_product_feed.salesChannel.translation.homeKeywords`, COALESCE(`magmodules_wevshopnl_product_feed.salesChannel.translation.homeKeywords`,`magmodules_wevshopnl_product_feed.salesChannel.translation.homeKeywords`) as `magmodules_wevshopnl_product_feed.salesChannel.homeKeywords`, `magmodules_wevshopnl_product_feed.salesChannel.translation.customFields`, COALESCE(`magmodules_wevshopnl_product_feed.salesChannel.translation.customFields`,`magmodules_wevshopnl_product_feed.salesChannel.translation.customFields`) as `magmodules_wevshopnl_product_feed.salesChannel.customFields`, `magmodules_wevshopnl_product_feed.salesChannel.translation.createdAt`, `magmodules_wevshopnl_product_feed.salesChannel.translation.updatedAt`, `magmodules_wevshopnl_product_feed.salesChannel.translation.salesChannelId`, `magmodules_wevshopnl_product_feed.salesChannel.translation.languageId` FROM `magmodules_wevshopnl_product_feed` LEFT JOIN `sales_channel` `magmodules_wevshopnl_product_feed.salesChannel` ON `magmodules_wevshopnl_product_feed`.`sales_channel_id` = `magmodules_wevshopnl_product_feed.salesChannel`.`id` LEFT JOIN (SELECT `magmodules_wevshopnl_product_feed.salesChannel.translation`.sales_channel_id, `magmodules_wevshopnl_product_feed.salesChannel.translation`.name as `magmodules_wevshopnl_product_feed.salesChannel.translation.name`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_slot_config as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeSlotConfig`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_enabled as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeEnabled`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_name as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeName`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_meta_title as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaTitle`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_meta_description as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeMetaDescription`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.home_keywords as `magmodules_wevshopnl_product_feed.salesChannel.translation.homeKeywords`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.custom_fields as `magmodules_wevshopnl_product_feed.salesChannel.translation.customFields`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.created_at as `magmodules_wevshopnl_product_feed.salesChannel.translation.createdAt`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.updated_at as `magmodules_wevshopnl_product_feed.salesChannel.translation.updatedAt`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.sales_channel_id as `magmodules_wevshopnl_product_feed.salesChannel.translation.salesChannelId`, `magmodules_wevshopnl_product_feed.salesChannel.translation`.language_id as `magmodules_wevshopnl_product_feed.salesChannel.translation.languageId` FROM `sales_channel_translation` `magmodules_wevshopnl_product_feed.salesChannel.translation` WHERE `magmodules_wevshopnl_product_feed.salesChannel.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `magmodules_wevshopnl_product_feed.salesChannel.sales_channel_translation` ON `magmodules_wevshopnl_product_feed.salesChannel.sales_channel_translation`.`sales_channel_id` = `magmodules_wevshopnl_product_feed.salesChannel`.`id` LEFT JOIN `sales_channel_analytics` `magmodules_wevshopnl_product_feed.salesChannel.analytics` ON `magmodules_wevshopnl_product_feed.salesChannel`.`analytics_id` = `magmodules_wevshopnl_product_feed.salesChannel.analytics`.`id` WHERE (`magmodules_wevshopnl_product_feed.salesChannel`.`active` = 1);

SELECT
  `plugin`.`id` as `plugin.id`,
  `plugin`.`base_class` as `plugin.baseClass`,
  `plugin`.`name` as `plugin.name`,
  `plugin`.`composer_name` as `plugin.composerName`,
  `plugin`.`autoload` as `plugin.autoload`,
  `plugin`.`active` as `plugin.active`,
  `plugin`.`managed_by_composer` as `plugin.managedByComposer`,
  `plugin`.`path` as `plugin.path`,
  `plugin`.`author` as `plugin.author`,
  `plugin`.`copyright` as `plugin.copyright`,
  `plugin`.`license` as `plugin.license`,
  `plugin`.`version` as `plugin.version`,
  `plugin`.`upgrade_version` as `plugin.upgradeVersion`,
  `plugin`.`installed_at` as `plugin.installedAt`,
  `plugin`.`upgraded_at` as `plugin.upgradedAt`,
  `plugin`.`icon` as `plugin.iconRaw`,
  `plugin`.`created_at` as `plugin.createdAt`,
  `plugin`.`updated_at` as `plugin.updatedAt`,
  `plugin.translation.label`,
  COALESCE(
    `plugin.translation.label`, `plugin.translation.label`
  ) as `plugin.label`,
  `plugin.translation.description`,
  COALESCE(
    `plugin.translation.description`,
    `plugin.translation.description`
  ) as `plugin.description`,
  `plugin.translation.manufacturerLink`,
  COALESCE(
    `plugin.translation.manufacturerLink`,
    `plugin.translation.manufacturerLink`
  ) as `plugin.manufacturerLink`,
  `plugin.translation.supportLink`,
  COALESCE(
    `plugin.translation.supportLink`,
    `plugin.translation.supportLink`
  ) as `plugin.supportLink`,
  `plugin.translation.changelog`,
  COALESCE(
    `plugin.translation.changelog`,
    `plugin.translation.changelog`
  ) as `plugin.changelog`,
  `plugin.translation.customFields`,
  COALESCE(
    `plugin.translation.customFields`,
    `plugin.translation.customFields`
  ) as `plugin.customFields`,
  `plugin.translation.createdAt`,
  `plugin.translation.updatedAt`,
  `plugin.translation.pluginId`,
  `plugin.translation.languageId`
FROM
  `plugin`
  LEFT JOIN (
    SELECT
      `plugin.translation`.plugin_id,
      `plugin.translation`.label as `plugin.translation.label`,
      `plugin.translation`.description as `plugin.translation.description`,
      `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`,
      `plugin.translation`.support_link as `plugin.translation.supportLink`,
      `plugin.translation`.changelog as `plugin.translation.changelog`,
      `plugin.translation`.custom_fields as `plugin.translation.customFields`,
      `plugin.translation`.created_at as `plugin.translation.createdAt`,
      `plugin.translation`.updated_at as `plugin.translation.updatedAt`,
      `plugin.translation`.plugin_id as `plugin.translation.pluginId`,
      `plugin.translation`.language_id as `plugin.translation.languageId`
    FROM
      `plugin_translation` `plugin.translation`
    WHERE
      `plugin.translation`.language_id = ?
  ) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id`
WHERE
  (`plugin`.`name` = ?)

SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, `plugin.translation.description`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, `plugin.translation.changelog`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, `plugin.translation.customFields`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`name` = 'MagmodulesWebshopnl');

SELECT
  configuration_key,
  configuration_value
FROM
  system_config
WHERE
  sales_channel_id = ?
  OR system_config.sales_channel_id IS NULL
ORDER BY
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = 0xE1FB5F7271A8437BA11250D97B8C2ECC OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC;

# cache-id-loader
SELECT
  `value`
FROM
  app_config
WHERE
  `key` = ?

# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = 'cache-id';

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

SELECT
  configuration_key,
  configuration_value
FROM
  system_config
WHERE
  sales_channel_id IS NULL
ORDER BY
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;

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',
        ''
      )
  )

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',''));

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

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
            ;

# 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`;

# 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`;;