https://shop-dev.kaylo.net/admin/.env

Query Metrics

8 Database Queries
Different statements
3.22 ms Query time
Invalid entities

Queries

Group similar statements

# Time Info
1 0.13 ms
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = :key
2 0.06 ms
# 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`;
3 0.10 ms
SELECT `creation_timestamp`
            FROM `migration`
            WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
4 0.46 ms
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 @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1580205548_IS_ACTIVE = TRUE;SET @MIGRATION_1580205549_IS_ACTIVE = TRUE;SET @MIGRATION_1580205550_IS_ACTIVE = TRUE;SET @MIGRATION_1580205549_IS_ACTIVE = TRUE;SET @MIGRATION_1623059999_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1590425608_IS_ACTIVE = TRUE;SET @MIGRATION_1618323278_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1643902985_IS_ACTIVE = TRUE;SET @MIGRATION_1643907023_IS_ACTIVE = TRUE;SET @MIGRATION_1643908626_IS_ACTIVE = TRUE;SET @MIGRATION_1647443705_IS_ACTIVE = TRUE;SET @MIGRATION_1647613235_IS_ACTIVE = TRUE;SET @MIGRATION_1648564206_IS_ACTIVE = TRUE;SET @MIGRATION_1650965928_IS_ACTIVE = TRUE;SET @MIGRATION_1685702879_IS_ACTIVE = TRUE;SET @MIGRATION_1690142324_IS_ACTIVE = TRUE;SET @MIGRATION_1696164933_IS_ACTIVE = TRUE;SET @MIGRATION_1698748783_IS_ACTIVE = TRUE;SET @MIGRATION_1701279517_IS_ACTIVE = TRUE
5 0.13 ms
# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> :param_6e17d62e426d47b3be7f22b5089ae231) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500
6 0.25 ms
# system-config::load::read
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 `system_config`.`id` IN (:ids)
7 0.08 ms
# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> :param_27270e74f6754262bcb519f019803e42) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500
8 2.01 ms
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, `plugin.translation.description`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, `plugin.translation.changelog`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, `plugin.translation.customFields`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = :languageId) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = :param_9d9ece7bf96e44a2a13df4aa0168d3ed)

Database Connections

There are no configured database connections.

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping