Symfony Profiler

Query Metrics

31 Database Queries
25 Different statements
10.89 ms Query time
Queries


# 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 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 configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT last_updated_password_at, active FROM user WHERE id = ?
SELECT item_rounding FROM currency WHERE 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 = ?
SELECT admin FROM `user` WHERE id = ?
"START TRANSACTION"
SELECT m.* FROM messenger_messages m WHERE (m.queue_name = ?) AND (m.delivered_at is null OR m.delivered_at < ?) AND (m.available_at <= ?) ORDER BY available_at ASC LIMIT 1 FOR UPDATE SKIP LOCKED
UPDATE messenger_messages SET delivered_at = ? WHERE id = ?
"COMMIT"
SELECT `scheduled_task`.`id` as `scheduled_task.id`, `scheduled_task`.`name` as `scheduled_task.name`, `scheduled_task`.`scheduled_task_class` as `scheduled_task.scheduledTaskClass`, `scheduled_task`.`run_interval` as `scheduled_task.runInterval`, `scheduled_task`.`default_run_interval` as `scheduled_task.defaultRunInterval`, `scheduled_task`.`status` as `scheduled_task.status`, `scheduled_task`.`last_execution_time` as `scheduled_task.lastExecutionTime`, `scheduled_task`.`next_execution_time` as `scheduled_task.nextExecutionTime`, `scheduled_task`.`created_at` as `scheduled_task.createdAt`, `scheduled_task`.`updated_at` as `scheduled_task.updatedAt` FROM `scheduled_task` WHERE `scheduled_task`.`id` IN (?)
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
SELECT 1 as `exists`, `id` FROM `scheduled_task` WHERE `id` IN (?)
"START TRANSACTION"
UPDATE `scheduled_task` SET `status` = ?, `updated_at` = ? WHERE id = ?
"COMMIT"
-- app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   `app`.`name` AS appName,
                   `app`.`version` AS appVersion,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   IF(`script`.`active` = 1 AND (`app`.id IS NULL OR `app`.`active` = 1), 1, 0) AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(id))
    FROM `sales_channel`
    WHERE `type_id` IN (?, ?)
      AND `active` = 1
SELECT
        LOWER(HEX(product_export.id)) AS id,
        product_export.generated_at,
        product_export.next_generation_at,
        product_export.interval,
        product_export.is_running,
        product_export.updated_at,
        product_export.created_at
    FROM product_export
    INNER JOIN sales_channel
        ON sales_channel.id = product_export.sales_channel_id
    INNER JOIN sales_channel_domain
        ON sales_channel_domain.id = product_export.sales_channel_domain_id
    WHERE product_export.generate_by_cronjob = 1
      AND sales_channel.active = 1
      AND (
            product_export.storefront_sales_channel_id = ?
            OR sales_channel_domain.sales_channel_id = ?
      )
SELECT
        LOWER(HEX(product_export.id)) AS id,
        product_export.generated_at,
        product_export.next_generation_at,
        product_export.interval,
        product_export.is_running,
        product_export.updated_at,
        product_export.created_at
    FROM product_export
    INNER JOIN sales_channel
        ON sales_channel.id = product_export.sales_channel_id
    INNER JOIN sales_channel_domain
        ON sales_channel_domain.id = product_export.sales_channel_domain_id
    WHERE product_export.generate_by_cronjob = 1
      AND sales_channel.active = 1
      AND (
            product_export.storefront_sales_channel_id = ?
            OR sales_channel_domain.sales_channel_id = ?
      )
SELECT 1 as `exists`, `id` FROM `scheduled_task` WHERE `id` IN (?)
"START TRANSACTION"
UPDATE `scheduled_task` SET `status` = ?, `last_execution_time` = ?, `next_execution_time` = ?, `updated_at` = ? WHERE id = ?
"COMMIT"
UPDATE `increment`
            SET `count` = `count` - 1, `updated_at` = ?
            WHERE `pool` = ? AND `cluster` = ? AND `key` = ? AND `count` > 0;
INSERT INTO messenger_stats (message_type, time_in_queue, created_at) VALUES (?, ?, ?)
DELETE FROM messenger_stats WHERE created_at < ?
DELETE FROM messenger_messages WHERE id = ?
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

POST https://airwave.mittwald2.salesmachine.biz/api/_action/message-queue/consume

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache
