Symfony Profiler

Query Metrics

69 Database Queries
61 Different statements
40.96 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`, `product_id`, `language_id`, `product_version_id` FROM `product_translation` WHERE (`product_id`,`language_id`,`product_version_id`) IN ((?,?,?),(?,?,?))
SELECT 1 as `exists`, parent_id, `id`, `version_id` FROM `product` WHERE (`id` IN (?,?)) AND (version_id = ?)
SELECT 1 as `exists`, parent_id FROM `product` WHERE (`id` = ?) AND (`version_id` = ?)
SELECT 1 as `exists` FROM `product_translation` WHERE (`product_id` = ?) AND (`language_id` = ?) AND (`product_version_id` = ?)
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
SELECT 1 as `exists`, parent_id FROM `product` WHERE (`id` = ?) AND (`version_id` = ?)
SELECT 1 as `exists` FROM `product_translation` WHERE (`product_id` = ?) AND (`language_id` = ?) AND (`product_version_id` = ?)
"START TRANSACTION"
SAVEPOINT DOCTRINE_2
REPLACE INTO `product_category` (`product_id`, `product_version_id`, `category_id`, `category_version_id`) VALUES (?,?,?,?), (?,?,?,?);
RELEASE SAVEPOINT DOCTRINE_2
UPDATE `product` SET `version_id` = ?, `parent_version_id` = ?, `product_manufacturer_id` = ?, `product_manufacturer_version_id` = ?, `product_media_version_id` = ?, `canonical_product_version_id` = ?, `cms_page_version_id` = ?, `product_number` = ?, `active` = ?, `variant_listing_config` = ?, `updated_at` = ? WHERE id = ? AND version_id = ?
UPDATE `product` SET `version_id` = ?, `parent_id` = ?, `parent_version_id` = ?, `product_manufacturer_id` = ?, `product_manufacturer_version_id` = ?, `product_media_version_id` = ?, `canonical_product_version_id` = ?, `cms_page_version_id` = ?, `product_number` = ?, `active` = ?, `variant_listing_config` = ?, `updated_at` = ? WHERE id = ? AND version_id = ?
UPDATE `product_translation` SET custom_fields = JSON_SET(IFNULL(`custom_fields`, "{}"), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WHERE (`product_id` = ?) AND (`language_id` = ?) AND (`product_version_id` = ?)
UPDATE `product_translation` SET `product_id` = ?, `language_id` = ?, `product_version_id` = ?, `name` = ?, `description` = ?, `custom_search_keywords` = ?, `updated_at` = ? WHERE product_id = ? AND language_id = ? AND product_version_id = ?
UPDATE `product_translation` SET custom_fields = JSON_SET(IFNULL(`custom_fields`, "{}"), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) WHERE (`product_id` = ?) AND (`language_id` = ?) AND (`product_version_id` = ?)
UPDATE `product_translation` SET `product_id` = ?, `language_id` = ?, `product_version_id` = ?, `name` = ?, `description` = ?, `custom_search_keywords` = ?, `updated_at` = ? WHERE product_id = ? AND language_id = ? AND product_version_id = ?
SAVEPOINT DOCTRINE_2
REPLACE INTO `product_property` (`product_id`, `property_group_option_id`, `product_version_id`) VALUES (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?);
RELEASE SAVEPOINT DOCTRINE_2
"COMMIT"
"START TRANSACTION"
DELETE FROM b2b_order_number WHERE custom_ordernumber IN (?, ?)
"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
SELECT LOWER(HEX(product.id)) as id,
                   GROUP_CONCAT(DISTINCT translation.name SEPARATOR " ") as name,
                   CONCAT("[", GROUP_CONCAT(translation.custom_search_keywords), "]") as custom_search_keywords,
                   GROUP_CONCAT(DISTINCT tag.name SEPARATOR " ") as tags,
                   product.product_number,
                   product.ean,
                   product.manufacturer_number
            FROM product
                INNER JOIN product_translation AS translation
                    ON product.id = translation.product_id AND product.version_id = translation.product_version_id
                LEFT JOIN product_tag
                    ON product.id = product_tag.product_id AND product.version_id = product_tag.product_version_id
                LEFT JOIN tag
                    ON product_tag.tag_id = tag.id
            WHERE product.id IN (?, ?)
            AND product.version_id = ?
            GROUP BY product.id
SELECT
        LOWER(HEX(w.id)) as webhookId,
        w.name as webhookName,
        w.event_name as eventName,
        w.url as webhookUrl,
        w.only_live_version as onlyLiveVersion,
        LOWER(HEX(a.id)) AS appId,
        a.name AS appName,
        a.active AS appActive,
        a.source_type AS appSourceType,
        a.version AS appVersion,
        a.app_secret AS appSecret,
        LOWER(HEX(a.acl_role_id)) as appAclRoleId
    FROM webhook w
    LEFT JOIN app a ON (a.id = w.app_id)
    WHERE w.active = 1
SELECT `id`, `privileges`
    FROM `acl_role`
    WHERE `id` IN (?)
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
