Symfony Profiler

Query Metrics

51 Database Queries
49 Different statements
41.36 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 item_rounding FROM currency WHERE id = ?
SELECT id FROM integration WHERE access_key = ?
SELECT `acl_role`.`privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`integration_id` = ?
SELECT admin FROM `integration` WHERE id = ?
SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = ?
SELECT 1 as `exists`, `id`, `product_version_id` FROM `product_cross_selling_assigned_products` WHERE (`id`,`product_version_id`) IN ((?,?))
SELECT 1 as `exists` FROM `product_cross_selling_assigned_products` WHERE (`id` = ?) AND (`product_version_id` = ?)
SELECT LOWER(HEX(`product_id`)) FROM `product_cross_selling` WHERE `id` = ?
"START TRANSACTION"
UPDATE `product_cross_selling_assigned_products` SET `cross_selling_id` = ?, `product_id` = ?, `product_version_id` = ?, `position` = ?, `updated_at` = ? WHERE id = ? AND product_version_id = ?
"COMMIT"
"START TRANSACTION"
DELETE FROM b2b_order_number WHERE custom_ordernumber IN (NULL)
"COMMIT"
SELECT DISTINCT LOWER(HEX(product_stream_id))
             FROM product_stream_mapping
             WHERE product_stream_mapping.product_id IN (?)
             AND product_stream_mapping.product_version_id = ?
UPDATE `product` SET `prices` = IFNULL(
                        (
                            SELECT `product_price`.`product_id`
                            FROM   `product_price`
                            WHERE  `product_price`.`product_id`         = `product`.id
                            AND `product_price`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `media` = IFNULL(
                        (
                            SELECT `product_media`.`product_id`
                            FROM   `product_media`
                            WHERE  `product_media`.`product_id`         = `product`.id
                            AND `product_media`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `crossSellings` = IFNULL(
                        (
                            SELECT `product_cross_selling`.`product_id`
                            FROM   `product_cross_selling`
                            WHERE  `product_cross_selling`.`product_id`         = `product`.id
                            AND `product_cross_selling`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `visibilities` = IFNULL(
                        (
                            SELECT `product_visibility`.`product_id`
                            FROM   `product_visibility`
                            WHERE  `product_visibility`.`product_id`         = `product`.id
                            AND `product_visibility`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `properties` = IFNULL(
                        (
                            SELECT `product_property`.`product_id`
                            FROM   `product_property`
                            WHERE  `product_property`.`product_id`         = `product`.id
                            AND `product_property`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `categories` = IFNULL(
                        (
                            SELECT `product_category`.`product_id`
                            FROM   `product_category`
                            WHERE  `product_category`.`product_id`         = `product`.id
                            AND `product_category`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `tags` = IFNULL(
                        (
                            SELECT `product_tag`.`product_id`
                            FROM   `product_tag`
                            WHERE  `product_tag`.`product_id`         = `product`.id
                            AND `product_tag`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `customFieldSets` = IFNULL(
                        (
                            SELECT `product_custom_field_set`.`product_id`
                            FROM   `product_custom_field_set`
                            WHERE  `product_custom_field_set`.`product_id`         = `product`.id
                            AND `product_custom_field_set`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `translations` = IFNULL(
                        (
                            SELECT `product_translation`.`product_id`
                            FROM   `product_translation`
                            WHERE  `product_translation`.`product_id`         = `product`.id
                            AND `product_translation`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `customPrice` = IFNULL(
                        (
                            SELECT `custom_price`.`product_id`
                            FROM   `custom_price`
                            WHERE  `custom_price`.`product_id`         = `product`.id
                            AND `custom_price`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `subscriptionPlans` = IFNULL(
                        (
                            SELECT `subscription_plan_product_mapping`.`product_id`
                            FROM   `subscription_plan_product_mapping`
                            WHERE  `subscription_plan_product_mapping`.`product_id`         = `product`.id
                            AND `subscription_plan_product_mapping`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `warehouseGroups` = IFNULL(
                        (
                            SELECT `product_warehouse_group`.`product_id`
                            FROM   `product_warehouse_group`
                            WHERE  `product_warehouse_group`.`product_id`         = `product`.id
                            AND `product_warehouse_group`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` SET `warehouses` = IFNULL(
                        (
                            SELECT `product_warehouse`.`product_id`
                            FROM   `product_warehouse`
                            WHERE  `product_warehouse`.`product_id`         = `product`.id
                            AND `product_warehouse`.`product_version_id` = `product`.version_id
                            LIMIT 1
                        ),
                        IFNULL(`product`.parent_id, `product`.id)
                     )
                     WHERE `product`.id IN (?)
                     AND `product`.version_id = ?
UPDATE `product` as `product`, `product` as parent
                    SET `product`.`deliveryTime` = IFNULL(`product`.`delivery_time_id`, parent.`delivery_time_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?
UPDATE `product` AS `product`
                    SET `product`.`deliveryTime` = `product`.`delivery_time_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
UPDATE `product` as `product`, `product` as parent
                    SET `product`.`tax` = IFNULL(`product`.`tax_id`, parent.`tax_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?
UPDATE `product` AS `product`
                    SET `product`.`tax` = `product`.`tax_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
UPDATE `product` as `product`, `product` as parent
                    SET `product`.`manufacturer` = IFNULL(`product`.`product_manufacturer_id`, parent.`product_manufacturer_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?
UPDATE `product` AS `product`
                    SET `product`.`manufacturer` = `product`.`product_manufacturer_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
UPDATE `product` as `product`, `product` as parent
                    SET `product`.`unit` = IFNULL(`product`.`unit_id`, parent.`unit_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?
UPDATE `product` AS `product`
                    SET `product`.`unit` = `product`.`unit_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
UPDATE `product` as `product`, `product` as parent
                    SET `product`.`cover` = IFNULL(`product`.`product_media_id`, parent.`product_media_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?
UPDATE `product` AS `product`
                    SET `product`.`cover` = `product`.`product_media_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
UPDATE `product` as `product`, `product` as parent
                    SET `product`.`featureSet` = IFNULL(`product`.`product_feature_set_id`, parent.`product_feature_set_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?
UPDATE `product` AS `product`
                    SET `product`.`featureSet` = `product`.`product_feature_set_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
UPDATE `product` as `product`, `product` as parent
                    SET `product`.`cmsPage` = IFNULL(`product`.`cms_page_id`, parent.`cms_page_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?
UPDATE `product` AS `product`
                    SET `product`.`cmsPage` = `product`.`cms_page_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
UPDATE `product` as `product`, `product` as parent
                    SET `product`.`canonicalProduct` = IFNULL(`product`.`canonical_product_id`, parent.`canonical_product_id`)
                    WHERE `product`.parent_id = parent.id
                    AND `product`.parent_id IS NOT NULL
                    AND `product`.id IN (?)AND `product`.version_id = parent.version_id
                         AND `product`.version_id = ?
UPDATE `product` AS `product`
                    SET `product`.`canonicalProduct` = `product`.`canonical_product_id`
                    WHERE `product`.parent_id IS NULL
                    AND `product`.id IN (?)AND `product`.version_id = ?
SELECT DISTINCT LOWER(HEX(product.parent_id)) as id FROM product WHERE id IN (?)
SELECT DISTINCT LOWER(HEX(id)) as id FROM product WHERE parent_id IN (?)
DELETE FROM admin_elasticsearch_index_task WHERE `entity` IN (NULL)
SELECT `alias`, `index` FROM admin_elasticsearch_index_task
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://sw6staging.behr-labor.eu/api/_action/sync

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache
