Symfony Profiler

SELECT
  last_updated_password_at
FROM
  user
WHERE
  id = ?

SELECT last_updated_password_at FROM user WHERE id = 0xA396D3E391D8465FABA588EA62EE8672;

SELECT
  `app_action_button`.`id` as `app_action_button.id`,
  `app_action_button`.`entity` as `app_action_button.entity`,
  `app_action_button`.`view` as `app_action_button.view`,
  `app_action_button`.`url` as `app_action_button.url`,
  `app_action_button`.`action` as `app_action_button.action`,
  `app_action_button`.`app_id` as `app_action_button.appId`,
  `app_action_button`.`created_at` as `app_action_button.createdAt`,
  `app_action_button`.`updated_at` as `app_action_button.updatedAt`,
  `app_action_button.app`.`id` as `app_action_button.app.id`,
  `app_action_button.app`.`name` as `app_action_button.app.name`,
  `app_action_button.app`.`path` as `app_action_button.app.path`,
  `app_action_button.app`.`author` as `app_action_button.app.author`,
  `app_action_button.app`.`copyright` as `app_action_button.app.copyright`,
  `app_action_button.app`.`license` as `app_action_button.app.license`,
  `app_action_button.app`.`active` as `app_action_button.app.active`,
  `app_action_button.app`.`configurable` as `app_action_button.app.configurable`,
  `app_action_button.app`.`privacy` as `app_action_button.app.privacy`,
  `app_action_button.app`.`version` as `app_action_button.app.version`,
  `app_action_button.app`.`icon` as `app_action_button.app.iconRaw`,
  `app_action_button.app`.`app_secret` as `app_action_button.app.appSecret`,
  `app_action_button.app`.`modules` as `app_action_button.app.modules`,
  `app_action_button.app`.`main_module` as `app_action_button.app.mainModule`,
  `app_action_button.app`.`cookies` as `app_action_button.app.cookies`,
  `app_action_button.app`.`allow_disable` as `app_action_button.app.allowDisable`,
  `app_action_button.app`.`base_app_url` as `app_action_button.app.baseAppUrl`,
  `app_action_button.app`.`allowed_hosts` as `app_action_button.app.allowedHosts`,
  `app_action_button.app`.`template_load_priority` as `app_action_button.app.templateLoadPriority`,
  `app_action_button.app`.`integration_id` as `app_action_button.app.integrationId`,
  `app_action_button.app.integration`.`id` as `app_action_button.app.integration.id`,
  `app_action_button.app.integration`.`label` as `app_action_button.app.integration.label`,
  `app_action_button.app.integration`.`access_key` as `app_action_button.app.integration.accessKey`,
  `app_action_button.app.integration`.`secret_access_key` as `app_action_button.app.integration.secretAccessKey`,
  `app_action_button.app.integration`.`write_access` as `app_action_button.app.integration.writeAccess`,
  `app_action_button.app.integration`.`last_usage_at` as `app_action_button.app.integration.lastUsageAt`,
  `app_action_button.app.integration`.`admin` as `app_action_button.app.integration.admin`,
  `app_action_button.app.integration`.`custom_fields` as `app_action_button.app.integration.customFields`,
  `app_action_button.app.integration`.`deleted_at` as `app_action_button.app.integration.deletedAt`,
  `app_action_button.app.integration`.`created_at` as `app_action_button.app.integration.createdAt`,
  `app_action_button.app.integration`.`updated_at` as `app_action_button.app.integration.updatedAt`,
  `app_action_button.app`.`acl_role_id` as `app_action_button.app.aclRoleId`,
  `app_action_button.app.aclRole`.`id` as `app_action_button.app.aclRole.id`,
  `app_action_button.app.aclRole`.`name` as `app_action_button.app.aclRole.name`,
  `app_action_button.app.aclRole`.`description` as `app_action_button.app.aclRole.description`,
  `app_action_button.app.aclRole`.`privileges` as `app_action_button.app.aclRole.privileges`,
  `app_action_button.app.aclRole`.`deleted_at` as `app_action_button.app.aclRole.deletedAt`,
  `app_action_button.app.aclRole`.`created_at` as `app_action_button.app.aclRole.createdAt`,
  `app_action_button.app.aclRole`.`updated_at` as `app_action_button.app.aclRole.updatedAt`,
  `app_action_button.app`.`created_at` as `app_action_button.app.createdAt`,
  `app_action_button.app`.`updated_at` as `app_action_button.app.updatedAt`,
  `app_action_button.app.translation.label`,
  COALESCE(
    `app_action_button.app.translation.label`,
    `app_action_button.app.translation.label`
  ) as `app_action_button.app.label`,
  `app_action_button.app.translation.description`,
  COALESCE(
    `app_action_button.app.translation.description`,
    `app_action_button.app.translation.description`
  ) as `app_action_button.app.description`,
  `app_action_button.app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app_action_button.app.translation.privacyPolicyExtensions`,
    `app_action_button.app.translation.privacyPolicyExtensions`
  ) as `app_action_button.app.privacyPolicyExtensions`,
  `app_action_button.app.translation.customFields`,
  COALESCE(
    `app_action_button.app.translation.customFields`,
    `app_action_button.app.translation.customFields`
  ) as `app_action_button.app.customFields`,
  `app_action_button.app.translation.createdAt`,
  `app_action_button.app.translation.updatedAt`,
  `app_action_button.app.translation.appId`,
  `app_action_button.app.translation.languageId`,
  `app_action_button.translation.label`,
  COALESCE(
    `app_action_button.translation.label`,
    `app_action_button.translation.label`
  ) as `app_action_button.label`,
  `app_action_button.translation.createdAt`,
  `app_action_button.translation.updatedAt`,
  `app_action_button.translation.appActionButtonId`,
  `app_action_button.translation.languageId`
FROM
  `app_action_button`
  LEFT JOIN `app` `app_action_button.app` ON `app_action_button`.`app_id` = `app_action_button.app`.`id`
  LEFT JOIN (
    SELECT
      `app_action_button.translation`.app_action_button_id,
      `app_action_button.translation`.label as `app_action_button.translation.label`,
      `app_action_button.translation`.created_at as `app_action_button.translation.createdAt`,
      `app_action_button.translation`.updated_at as `app_action_button.translation.updatedAt`,
      `app_action_button.translation`.app_action_button_id as `app_action_button.translation.appActionButtonId`,
      `app_action_button.translation`.language_id as `app_action_button.translation.languageId`
    FROM
      `app_action_button_translation` `app_action_button.translation`
    WHERE
      `app_action_button.translation`.language_id = ?
  ) `app_action_button.app_action_button_translation` ON `app_action_button.app_action_button_translation`.`app_action_button_id` = `app_action_button`.`id`
  LEFT JOIN (
    SELECT
      `app_action_button.app.translation`.app_id,
      `app_action_button.app.translation`.label as `app_action_button.app.translation.label`,
      `app_action_button.app.translation`.description as `app_action_button.app.translation.description`,
      `app_action_button.app.translation`.privacy_policy_extensions as `app_action_button.app.translation.privacyPolicyExtensions`,
      `app_action_button.app.translation`.custom_fields as `app_action_button.app.translation.customFields`,
      `app_action_button.app.translation`.created_at as `app_action_button.app.translation.createdAt`,
      `app_action_button.app.translation`.updated_at as `app_action_button.app.translation.updatedAt`,
      `app_action_button.app.translation`.app_id as `app_action_button.app.translation.appId`,
      `app_action_button.app.translation`.language_id as `app_action_button.app.translation.languageId`
    FROM
      `app_translation` `app_action_button.app.translation`
    WHERE
      `app_action_button.app.translation`.language_id = ?
  ) `app_action_button.app.app_translation` ON `app_action_button.app.app_translation`.`app_id` = `app_action_button.app`.`id`
  LEFT JOIN `integration` `app_action_button.app.integration` ON `app_action_button.app`.`integration_id` = `app_action_button.app.integration`.`id`
  LEFT JOIN `acl_role` `app_action_button.app.aclRole` ON `app_action_button.app`.`acl_role_id` = `app_action_button.app.aclRole`.`id`
WHERE
  (
    `app_action_button`.`entity` = ?
    AND `app_action_button`.`view` = ?
    AND `app_action_button.app`.`active` = ?
  )

SELECT `app_action_button`.`id` as `app_action_button.id`, `app_action_button`.`entity` as `app_action_button.entity`, `app_action_button`.`view` as `app_action_button.view`, `app_action_button`.`url` as `app_action_button.url`, `app_action_button`.`action` as `app_action_button.action`, `app_action_button`.`app_id` as `app_action_button.appId`, `app_action_button`.`created_at` as `app_action_button.createdAt`, `app_action_button`.`updated_at` as `app_action_button.updatedAt`, `app_action_button.app`.`id` as `app_action_button.app.id`, `app_action_button.app`.`name` as `app_action_button.app.name`, `app_action_button.app`.`path` as `app_action_button.app.path`, `app_action_button.app`.`author` as `app_action_button.app.author`, `app_action_button.app`.`copyright` as `app_action_button.app.copyright`, `app_action_button.app`.`license` as `app_action_button.app.license`, `app_action_button.app`.`active` as `app_action_button.app.active`, `app_action_button.app`.`configurable` as `app_action_button.app.configurable`, `app_action_button.app`.`privacy` as `app_action_button.app.privacy`, `app_action_button.app`.`version` as `app_action_button.app.version`, `app_action_button.app`.`icon` as `app_action_button.app.iconRaw`, `app_action_button.app`.`app_secret` as `app_action_button.app.appSecret`, `app_action_button.app`.`modules` as `app_action_button.app.modules`, `app_action_button.app`.`main_module` as `app_action_button.app.mainModule`, `app_action_button.app`.`cookies` as `app_action_button.app.cookies`, `app_action_button.app`.`allow_disable` as `app_action_button.app.allowDisable`, `app_action_button.app`.`base_app_url` as `app_action_button.app.baseAppUrl`, `app_action_button.app`.`allowed_hosts` as `app_action_button.app.allowedHosts`, `app_action_button.app`.`template_load_priority` as `app_action_button.app.templateLoadPriority`, `app_action_button.app`.`integration_id` as `app_action_button.app.integrationId`, `app_action_button.app.integration`.`id` as `app_action_button.app.integration.id`, `app_action_button.app.integration`.`label` as `app_action_button.app.integration.label`, `app_action_button.app.integration`.`access_key` as `app_action_button.app.integration.accessKey`, `app_action_button.app.integration`.`secret_access_key` as `app_action_button.app.integration.secretAccessKey`, `app_action_button.app.integration`.`write_access` as `app_action_button.app.integration.writeAccess`, `app_action_button.app.integration`.`last_usage_at` as `app_action_button.app.integration.lastUsageAt`, `app_action_button.app.integration`.`admin` as `app_action_button.app.integration.admin`, `app_action_button.app.integration`.`custom_fields` as `app_action_button.app.integration.customFields`, `app_action_button.app.integration`.`deleted_at` as `app_action_button.app.integration.deletedAt`, `app_action_button.app.integration`.`created_at` as `app_action_button.app.integration.createdAt`, `app_action_button.app.integration`.`updated_at` as `app_action_button.app.integration.updatedAt`, `app_action_button.app`.`acl_role_id` as `app_action_button.app.aclRoleId`, `app_action_button.app.aclRole`.`id` as `app_action_button.app.aclRole.id`, `app_action_button.app.aclRole`.`name` as `app_action_button.app.aclRole.name`, `app_action_button.app.aclRole`.`description` as `app_action_button.app.aclRole.description`, `app_action_button.app.aclRole`.`privileges` as `app_action_button.app.aclRole.privileges`, `app_action_button.app.aclRole`.`deleted_at` as `app_action_button.app.aclRole.deletedAt`, `app_action_button.app.aclRole`.`created_at` as `app_action_button.app.aclRole.createdAt`, `app_action_button.app.aclRole`.`updated_at` as `app_action_button.app.aclRole.updatedAt`, `app_action_button.app`.`created_at` as `app_action_button.app.createdAt`, `app_action_button.app`.`updated_at` as `app_action_button.app.updatedAt`, `app_action_button.app.translation.label`, COALESCE(`app_action_button.app.translation.label`,`app_action_button.app.translation.label`) as `app_action_button.app.label`, `app_action_button.app.translation.description`, COALESCE(`app_action_button.app.translation.description`,`app_action_button.app.translation.description`) as `app_action_button.app.description`, `app_action_button.app.translation.privacyPolicyExtensions`, COALESCE(`app_action_button.app.translation.privacyPolicyExtensions`,`app_action_button.app.translation.privacyPolicyExtensions`) as `app_action_button.app.privacyPolicyExtensions`, `app_action_button.app.translation.customFields`, COALESCE(`app_action_button.app.translation.customFields`,`app_action_button.app.translation.customFields`) as `app_action_button.app.customFields`, `app_action_button.app.translation.createdAt`, `app_action_button.app.translation.updatedAt`, `app_action_button.app.translation.appId`, `app_action_button.app.translation.languageId`, `app_action_button.translation.label`, COALESCE(`app_action_button.translation.label`,`app_action_button.translation.label`) as `app_action_button.label`, `app_action_button.translation.createdAt`, `app_action_button.translation.updatedAt`, `app_action_button.translation.appActionButtonId`, `app_action_button.translation.languageId` FROM `app_action_button` LEFT JOIN `app` `app_action_button.app` ON `app_action_button`.`app_id` = `app_action_button.app`.`id` LEFT JOIN (SELECT `app_action_button.translation`.app_action_button_id, `app_action_button.translation`.label as `app_action_button.translation.label`, `app_action_button.translation`.created_at as `app_action_button.translation.createdAt`, `app_action_button.translation`.updated_at as `app_action_button.translation.updatedAt`, `app_action_button.translation`.app_action_button_id as `app_action_button.translation.appActionButtonId`, `app_action_button.translation`.language_id as `app_action_button.translation.languageId` FROM `app_action_button_translation` `app_action_button.translation` WHERE `app_action_button.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app_action_button.app_action_button_translation` ON `app_action_button.app_action_button_translation`.`app_action_button_id` = `app_action_button`.`id` LEFT JOIN (SELECT `app_action_button.app.translation`.app_id, `app_action_button.app.translation`.label as `app_action_button.app.translation.label`, `app_action_button.app.translation`.description as `app_action_button.app.translation.description`, `app_action_button.app.translation`.privacy_policy_extensions as `app_action_button.app.translation.privacyPolicyExtensions`, `app_action_button.app.translation`.custom_fields as `app_action_button.app.translation.customFields`, `app_action_button.app.translation`.created_at as `app_action_button.app.translation.createdAt`, `app_action_button.app.translation`.updated_at as `app_action_button.app.translation.updatedAt`, `app_action_button.app.translation`.app_id as `app_action_button.app.translation.appId`, `app_action_button.app.translation`.language_id as `app_action_button.app.translation.languageId` FROM `app_translation` `app_action_button.app.translation` WHERE `app_action_button.app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app_action_button.app.app_translation` ON `app_action_button.app.app_translation`.`app_id` = `app_action_button.app`.`id` LEFT JOIN `integration` `app_action_button.app.integration` ON `app_action_button.app`.`integration_id` = `app_action_button.app.integration`.`id` LEFT JOIN `acl_role` `app_action_button.app.aclRole` ON `app_action_button.app`.`acl_role_id` = `app_action_button.app.aclRole`.`id` WHERE (`app_action_button`.`entity` = 'product' AND `app_action_button`.`view` = 'list' AND `app_action_button.app`.`active` = 1);

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

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

SELECT
  role.privileges
FROM
  acl_user_role mapping
  INNER JOIN acl_role role ON mapping.acl_role_id = role.id
WHERE
  mapping.user_id = ?

SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0xA396D3E391D8465FABA588EA62EE8672;

SELECT
  admin
FROM
  `user`
WHERE
  id = ?

SELECT admin FROM `user` WHERE id = 0xA396D3E391D8465FABA588EA62EE8672;

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