Symfony Profiler

SELECT
  `key`,
  `value`
FROM
  `app_config`

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

# 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
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

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;

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

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
  `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`,
  `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`,
  `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`,
  `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`,
  `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`,
  `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`,
  `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`,
  `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`,
  `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`,
  `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`,
  `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`,
  `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`,
  `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`,
  `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`,
  `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`,
  `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`,
  `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`,
  `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`,
  `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`,
  `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`,
  `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`,
  `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`,
  `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`,
  `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt`
FROM
  `dreisc_seo_redirect`
WHERE
  (
    (
      `dreisc_seo_redirect`.`active` = ?
      AND `dreisc_seo_redirect`.`source_type` = ?
      AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = ?
      AND `dreisc_seo_redirect`.`source_path` = ?
    )
  )

SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = 1 AND `dreisc_seo_redirect`.`source_type` = 'url' AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = 0xDB78CF3395EE41CAA1682E8913D8B549 AND `dreisc_seo_redirect`.`source_path` = ''));

SELECT
  `as_custom_fields_filter`.`id`
FROM
  `as_custom_fields_filter`
WHERE
  (
    `as_custom_fields_filter`.`active` = ?
  )
ORDER BY
  `as_custom_fields_filter`.`position` ASC

SELECT `as_custom_fields_filter`.`id` FROM `as_custom_fields_filter` WHERE (`as_custom_fields_filter`.`active` = 1) ORDER BY `as_custom_fields_filter`.`position` ASC;

SELECT
  `as_custom_fields_filter`.`id` as `as_custom_fields_filter.id`,
  `as_custom_fields_filter`.`custom_field_id` as `as_custom_fields_filter.customFieldId`,
  `as_custom_fields_filter`.`type` as `as_custom_fields_filter.type`,
  `as_custom_fields_filter`.`display_name` as `as_custom_fields_filter.displayName`,
  `as_custom_fields_filter`.`request_parameter` as `as_custom_fields_filter.requestParameter`,
  `as_custom_fields_filter`.`active` as `as_custom_fields_filter.active`,
  `as_custom_fields_filter`.`position` as `as_custom_fields_filter.position`,
  `as_custom_fields_filter`.`created_at` as `as_custom_fields_filter.createdAt`,
  `as_custom_fields_filter`.`updated_at` as `as_custom_fields_filter.updatedAt`
FROM
  `as_custom_fields_filter`
WHERE
  `as_custom_fields_filter`.`id` IN (?, ?, ?, ?)

SELECT `as_custom_fields_filter`.`id` as `as_custom_fields_filter.id`, `as_custom_fields_filter`.`custom_field_id` as `as_custom_fields_filter.customFieldId`, `as_custom_fields_filter`.`type` as `as_custom_fields_filter.type`, `as_custom_fields_filter`.`display_name` as `as_custom_fields_filter.displayName`, `as_custom_fields_filter`.`request_parameter` as `as_custom_fields_filter.requestParameter`, `as_custom_fields_filter`.`active` as `as_custom_fields_filter.active`, `as_custom_fields_filter`.`position` as `as_custom_fields_filter.position`, `as_custom_fields_filter`.`created_at` as `as_custom_fields_filter.createdAt`, `as_custom_fields_filter`.`updated_at` as `as_custom_fields_filter.updatedAt` FROM `as_custom_fields_filter` WHERE `as_custom_fields_filter`.`id` IN (0x1E014F2D31BC461FBDFF453BBBB3E542, 0x7102C0FE8A36496DB58584772CF22431, 0xE910CC41500D4DDE8239C678055039EC, 0x113E49F0D4D642ED8FC27D29057FF260);

SELECT
  `custom_field`.`id` as `custom_field.id`,
  `custom_field`.`name` as `custom_field.name`,
  `custom_field`.`type` as `custom_field.type`,
  `custom_field`.`config` as `custom_field.config`,
  `custom_field`.`active` as `custom_field.active`,
  `custom_field`.`set_id` as `custom_field.customFieldSetId`,
  `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`,
  `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`,
  `custom_field`.`created_at` as `custom_field.createdAt`,
  `custom_field`.`updated_at` as `custom_field.updatedAt`
FROM
  `custom_field`
WHERE
  `custom_field`.`id` IN (?)

SELECT `custom_field`.`id` as `custom_field.id`, `custom_field`.`name` as `custom_field.name`, `custom_field`.`type` as `custom_field.type`, `custom_field`.`config` as `custom_field.config`, `custom_field`.`active` as `custom_field.active`, `custom_field`.`set_id` as `custom_field.customFieldSetId`, `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`, `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`, `custom_field`.`created_at` as `custom_field.createdAt`, `custom_field`.`updated_at` as `custom_field.updatedAt` FROM `custom_field` WHERE `custom_field`.`id` IN (0x6677BF46EF174ACC9EC5BA88FDB2A712);

SELECT
  DISTINCT JSON_UNQUOTE(
    JSON_EXTRACT(
      custom_fields, '$."gefahrgutsw6"'
    )
  ) as value
FROM
  product_translation
WHERE
  JSON_EXTRACT(
    custom_fields, '$."gefahrgutsw6"'
  ) IS NOT NULL

SELECT DISTINCT JSON_UNQUOTE(JSON_EXTRACT(custom_fields, '$."gefahrgutsw6"')) as value FROM product_translation WHERE JSON_EXTRACT(custom_fields, '$."gefahrgutsw6"') IS NOT NULL;

SELECT
  `custom_field`.`id` as `custom_field.id`,
  `custom_field`.`name` as `custom_field.name`,
  `custom_field`.`type` as `custom_field.type`,
  `custom_field`.`config` as `custom_field.config`,
  `custom_field`.`active` as `custom_field.active`,
  `custom_field`.`set_id` as `custom_field.customFieldSetId`,
  `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`,
  `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`,
  `custom_field`.`created_at` as `custom_field.createdAt`,
  `custom_field`.`updated_at` as `custom_field.updatedAt`
FROM
  `custom_field`
WHERE
  `custom_field`.`id` IN (?)

SELECT `custom_field`.`id` as `custom_field.id`, `custom_field`.`name` as `custom_field.name`, `custom_field`.`type` as `custom_field.type`, `custom_field`.`config` as `custom_field.config`, `custom_field`.`active` as `custom_field.active`, `custom_field`.`set_id` as `custom_field.customFieldSetId`, `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`, `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`, `custom_field`.`created_at` as `custom_field.createdAt`, `custom_field`.`updated_at` as `custom_field.updatedAt` FROM `custom_field` WHERE `custom_field`.`id` IN (0xD7A1779A957441878DE816725366FD4B);

SELECT
  DISTINCT JSON_UNQUOTE(
    JSON_EXTRACT(
      custom_fields, '$."versandklasse"'
    )
  ) as value
FROM
  product_translation
WHERE
  JSON_EXTRACT(
    custom_fields, '$."versandklasse"'
  ) IS NOT NULL

SELECT DISTINCT JSON_UNQUOTE(JSON_EXTRACT(custom_fields, '$."versandklasse"')) as value FROM product_translation WHERE JSON_EXTRACT(custom_fields, '$."versandklasse"') IS NOT NULL;

SELECT
  `custom_field`.`id` as `custom_field.id`,
  `custom_field`.`name` as `custom_field.name`,
  `custom_field`.`type` as `custom_field.type`,
  `custom_field`.`config` as `custom_field.config`,
  `custom_field`.`active` as `custom_field.active`,
  `custom_field`.`set_id` as `custom_field.customFieldSetId`,
  `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`,
  `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`,
  `custom_field`.`created_at` as `custom_field.createdAt`,
  `custom_field`.`updated_at` as `custom_field.updatedAt`
FROM
  `custom_field`
WHERE
  `custom_field`.`id` IN (?)

SELECT `custom_field`.`id` as `custom_field.id`, `custom_field`.`name` as `custom_field.name`, `custom_field`.`type` as `custom_field.type`, `custom_field`.`config` as `custom_field.config`, `custom_field`.`active` as `custom_field.active`, `custom_field`.`set_id` as `custom_field.customFieldSetId`, `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`, `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`, `custom_field`.`created_at` as `custom_field.createdAt`, `custom_field`.`updated_at` as `custom_field.updatedAt` FROM `custom_field` WHERE `custom_field`.`id` IN (0xA849D9E26FAF4D839EEF977B0AA8C5A6);

SELECT
  DISTINCT JSON_UNQUOTE(
    JSON_EXTRACT(custom_fields, '$."deposit"')
  ) as value
FROM
  product_translation
WHERE
  JSON_EXTRACT(custom_fields, '$."deposit"') IS NOT NULL

SELECT DISTINCT JSON_UNQUOTE(JSON_EXTRACT(custom_fields, '$."deposit"')) as value FROM product_translation WHERE JSON_EXTRACT(custom_fields, '$."deposit"') IS NOT NULL;

SELECT
  `custom_field`.`id` as `custom_field.id`,
  `custom_field`.`name` as `custom_field.name`,
  `custom_field`.`type` as `custom_field.type`,
  `custom_field`.`config` as `custom_field.config`,
  `custom_field`.`active` as `custom_field.active`,
  `custom_field`.`set_id` as `custom_field.customFieldSetId`,
  `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`,
  `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`,
  `custom_field`.`created_at` as `custom_field.createdAt`,
  `custom_field`.`updated_at` as `custom_field.updatedAt`
FROM
  `custom_field`
WHERE
  `custom_field`.`id` IN (?)

SELECT `custom_field`.`id` as `custom_field.id`, `custom_field`.`name` as `custom_field.name`, `custom_field`.`type` as `custom_field.type`, `custom_field`.`config` as `custom_field.config`, `custom_field`.`active` as `custom_field.active`, `custom_field`.`set_id` as `custom_field.customFieldSetId`, `custom_field`.`allow_customer_write` as `custom_field.allowCustomerWrite`, `custom_field`.`allow_cart_expose` as `custom_field.allowCartExpose`, `custom_field`.`created_at` as `custom_field.createdAt`, `custom_field`.`updated_at` as `custom_field.updatedAt` FROM `custom_field` WHERE `custom_field`.`id` IN (0x3D08A9663486413EBAF3DC7BD50BBC42);

SELECT
  DISTINCT JSON_UNQUOTE(
    JSON_EXTRACT(custom_fields, '$."taxrate"')
  ) as value
FROM
  product_translation
WHERE
  JSON_EXTRACT(custom_fields, '$."taxrate"') IS NOT NULL

SELECT DISTINCT JSON_UNQUOTE(JSON_EXTRACT(custom_fields, '$."taxrate"')) as value FROM product_translation WHERE JSON_EXTRACT(custom_fields, '$."taxrate"') IS NOT NULL;