Symfony Profiler

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

INSERT INTO `pickware_license_bundle_plugin_installation` (
  `id`, `installation_id`, `created_at`
)
VALUES
  (
    ?,
    UNHEX(
      CONCAT(
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        "4",
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0x0fff
            )
          ),
          3,
          "0"
        ),
        HEX(
          FLOOR(
            RAND() * 4 + 8
          )
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0x0fff
            )
          ),
          3,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        ),
        LPAD(
          HEX(
            FLOOR(
              RAND() * 0xffff
            )
          ),
          4,
          "0"
        )
      )
    ),
    UTC_TIMESTAMP(3)
  ) ON DUPLICATE KEY
UPDATE
  `id` = `id`

INSERT INTO `pickware_license_bundle_plugin_installation` (
                `id`,
                `installation_id`,
                `created_at`
            ) VALUES (
                0xB854730116074151886328CC3929A369,
                
        UNHEX(CONCAT(
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            "4",
            LPAD(HEX(FLOOR(RAND() * 0x0fff)), 3, "0"),
            HEX(FLOOR(RAND() * 4 + 8)),
            LPAD(HEX(FLOOR(RAND() * 0x0fff)), 3, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0"),
            LPAD(HEX(FLOOR(RAND() * 0xffff)), 4, "0")
        )),
                UTC_TIMESTAMP(3)
            ) ON DUPLICATE KEY UPDATE `id` = `id`;

SELECT
  `pickware_license_bundle_plugin_installation`.`id` as `pickware_license_bundle_plugin_installation.id`,
  `pickware_license_bundle_plugin_installation`.`installation_id` as `pickware_license_bundle_plugin_installation.installationId`,
  `pickware_license_bundle_plugin_installation`.`installation_uuid` as `pickware_license_bundle_plugin_installation.installationUuid`,
  `pickware_license_bundle_plugin_installation`.`pickware_account_access_token` as `pickware_license_bundle_plugin_installation.pickwareAccountAccessToken`,
  `pickware_license_bundle_plugin_installation`.`pickware_license` as `pickware_license_bundle_plugin_installation.pickwareLicense`,
  `pickware_license_bundle_plugin_installation`.`pickware_license_lease` as `pickware_license_bundle_plugin_installation.pickwareLicenseLease`,
  `pickware_license_bundle_plugin_installation`.`latest_pickware_license_lease_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseLeaseRefreshError`,
  `pickware_license_bundle_plugin_installation`.`latest_pickware_license_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseRefreshError`,
  `pickware_license_bundle_plugin_installation`.`latest_usage_report_error` as `pickware_license_bundle_plugin_installation.latestUsageReportError`,
  `pickware_license_bundle_plugin_installation`.`last_pickware_license_lease_refreshed_at` as `pickware_license_bundle_plugin_installation.lastPickwareLicenseLeaseRefreshedAt`,
  `pickware_license_bundle_plugin_installation`.`created_at` as `pickware_license_bundle_plugin_installation.createdAt`,
  `pickware_license_bundle_plugin_installation`.`updated_at` as `pickware_license_bundle_plugin_installation.updatedAt`
FROM
  `pickware_license_bundle_plugin_installation`
WHERE
  `pickware_license_bundle_plugin_installation`.`id` IN (?)

SELECT `pickware_license_bundle_plugin_installation`.`id` as `pickware_license_bundle_plugin_installation.id`, `pickware_license_bundle_plugin_installation`.`installation_id` as `pickware_license_bundle_plugin_installation.installationId`, `pickware_license_bundle_plugin_installation`.`installation_uuid` as `pickware_license_bundle_plugin_installation.installationUuid`, `pickware_license_bundle_plugin_installation`.`pickware_account_access_token` as `pickware_license_bundle_plugin_installation.pickwareAccountAccessToken`, `pickware_license_bundle_plugin_installation`.`pickware_license` as `pickware_license_bundle_plugin_installation.pickwareLicense`, `pickware_license_bundle_plugin_installation`.`pickware_license_lease` as `pickware_license_bundle_plugin_installation.pickwareLicenseLease`, `pickware_license_bundle_plugin_installation`.`latest_pickware_license_lease_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseLeaseRefreshError`, `pickware_license_bundle_plugin_installation`.`latest_pickware_license_refresh_error` as `pickware_license_bundle_plugin_installation.latestPickwareLicenseRefreshError`, `pickware_license_bundle_plugin_installation`.`latest_usage_report_error` as `pickware_license_bundle_plugin_installation.latestUsageReportError`, `pickware_license_bundle_plugin_installation`.`last_pickware_license_lease_refreshed_at` as `pickware_license_bundle_plugin_installation.lastPickwareLicenseLeaseRefreshedAt`, `pickware_license_bundle_plugin_installation`.`created_at` as `pickware_license_bundle_plugin_installation.createdAt`, `pickware_license_bundle_plugin_installation`.`updated_at` as `pickware_license_bundle_plugin_installation.updatedAt` FROM `pickware_license_bundle_plugin_installation` WHERE `pickware_license_bundle_plugin_installation`.`id` IN (0xB854730116074151886328CC3929A369);

SELECT
  item_rounding
FROM
  currency
WHERE
  id = ?

SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;

SELECT
  `system_config`.`id` as `system_config.id`,
  `system_config`.`configuration_key` as `system_config.configurationKey`,
  `system_config`.`configuration_value` as `system_config.configurationValue`,
  `system_config`.`sales_channel_id` as `system_config.salesChannelId`,
  `system_config`.`created_at` as `system_config.createdAt`,
  `system_config`.`updated_at` as `system_config.updatedAt`
FROM
  `system_config`
WHERE
  (
    IF(
      JSON_TYPE(
        JSON_EXTRACT(
          `system_config`.`configuration_value`,
          '$._value'
        )
      ) != "NULL",
      CONVERT(
        JSON_UNQUOTE(
          JSON_EXTRACT(
            `system_config`.`configuration_value`,
            '$._value'
          )
        ) USING "utf8mb4"
      ) COLLATE utf8mb4_unicode_ci,
      NULL
    ) = ?
  )

SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE (IF(JSON_TYPE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL) = 'r7PJ7uFm5bcDht86a7pIfeEIc2sDhtLT');

SELECT
  id
FROM
  `pickware_erp_return_order_line_item`
LIMIT
  1

SELECT id FROM `pickware_erp_return_order_line_item` LIMIT 1;

SELECT
  shipping_costs
FROM
  `pickware_erp_return_order`
LIMIT
  1

SELECT shipping_costs FROM `pickware_erp_return_order` LIMIT 1;

SELECT
  id
FROM
  `order_return`
LIMIT
  1

SELECT id FROM `order_return` LIMIT 1;

SELECT
  COUNT(*)
FROM
  `wallee_transaction`
LIMIT
  1

SELECT COUNT(*) FROM `wallee_transaction` LIMIT 1;