https://test.steinco.com/api/sendcloud/async/247684_680c6b58c6618

Query Metrics

69 Database Queries
Different statements
19.79 ms Query time
Invalid entities

Queries

Group similar statements

# Time Info
1 0.36 ms
# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = :key
2 0.23 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.40 ms
SELECT custom_entity.name, custom_entity.fields
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
4 0.48 ms
SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
5 0.61 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_1601388975_IS_ACTIVE = TRUE;SET @MIGRATION_1610965670_IS_ACTIVE = TRUE;SET @MIGRATION_1610974673_IS_ACTIVE = TRUE;SET @MIGRATION_1614240671_IS_ACTIVE = TRUE;SET @MIGRATION_1594104496_IS_ACTIVE = TRUE;SET @MIGRATION_1604585230_IS_ACTIVE = TRUE;SET @MIGRATION_1610337444_IS_ACTIVE = TRUE;SET @MIGRATION_1610523548_IS_ACTIVE = TRUE;SET @MIGRATION_1610616655_IS_ACTIVE = TRUE;SET @MIGRATION_1610621999_IS_ACTIVE = TRUE;SET @MIGRATION_1610625925_IS_ACTIVE = TRUE;SET @MIGRATION_1610634383_IS_ACTIVE = TRUE;SET @MIGRATION_1611732852_IS_ACTIVE = TRUE;SET @MIGRATION_1611817467_IS_ACTIVE = TRUE;SET @MIGRATION_1612184092_IS_ACTIVE = TRUE;SET @MIGRATION_1612442685_IS_ACTIVE = TRUE;SET @MIGRATION_1612442686_IS_ACTIVE = TRUE;SET @MIGRATION_1612442786_IS_ACTIVE = TRUE;SET @MIGRATION_1612851765_IS_ACTIVE = TRUE;SET @MIGRATION_1612865237_IS_ACTIVE = TRUE;SET @MIGRATION_1612970642_IS_ACTIVE = TRUE;SET @MIGRATION_1612980753_IS_ACTIVE = TRUE;SET @MIGRATION_1613665555_IS_ACTIVE = TRUE;SET @MIGRATION_1614249488_IS_ACTIVE = TRUE;SET @MIGRATION_1614691876_IS_ACTIVE = TRUE;SET @MIGRATION_1614765170_IS_ACTIVE = TRUE;SET @MIGRATION_1614765785_IS_ACTIVE = TRUE;SET @MIGRATION_1615359964_IS_ACTIVE = TRUE;SET @MIGRATION_1615366708_IS_ACTIVE = TRUE;SET @MIGRATION_1615452749_IS_ACTIVE = TRUE;SET @MIGRATION_1615802866_IS_ACTIVE = TRUE;SET @MIGRATION_1615819992_IS_ACTIVE = TRUE;SET @MIGRATION_1616076922_IS_ACTIVE = TRUE;SET @MIGRATION_1616496610_IS_ACTIVE = TRUE;SET @MIGRATION_1616555956_IS_ACTIVE = TRUE;SET @MIGRATION_1617000878_IS_ACTIVE = TRUE;SET @MIGRATION_1617356092_IS_ACTIVE = TRUE;SET @MIGRATION_1617784658_IS_ACTIVE = TRUE;SET @MIGRATION_1617864895_IS_ACTIVE = TRUE;SET @MIGRATION_1617868381_IS_ACTIVE = TRUE;SET @MIGRATION_1617877887_IS_ACTIVE = TRUE;SET @MIGRATION_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1617935350_IS_ACTIVE = TRUE;SET @MIGRATION_1617953690_IS_ACTIVE = TRUE;SET @MIGRATION_1617960456_IS_ACTIVE = TRUE;SET @MIGRATION_1617974402_IS_ACTIVE = TRUE;SET @MIGRATION_1618218491_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1618476427_IS_ACTIVE = TRUE;SET @MIGRATION_1618569201_IS_ACTIVE = TRUE;SET @MIGRATION_1618900427_IS_ACTIVE = TRUE;SET @MIGRATION_1618989442_IS_ACTIVE = TRUE;SET @MIGRATION_1619070236_IS_ACTIVE = TRUE;SET @MIGRATION_1619428555_IS_ACTIVE = TRUE;SET @MIGRATION_1619604605_IS_ACTIVE = TRUE;SET @MIGRATION_1619703075_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620201616_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620632460_IS_ACTIVE = TRUE;SET @MIGRATION_1620634856_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620820321_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1622010069_IS_ACTIVE = TRUE;SET @MIGRATION_1622104463_IS_ACTIVE = TRUE;SET @MIGRATION_1622782058_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_IS_ACTIVE = TRUE;SET @MIGRATION_1623391399_IS_ACTIVE = TRUE;SET @MIGRATION_1623828962_IS_ACTIVE = TRUE;SET @MIGRATION_1624262862_IS_ACTIVE = TRUE;SET @MIGRATION_1624884801_IS_ACTIVE = TRUE;SET @MIGRATION_1624967118_IS_ACTIVE = TRUE;SET @MIGRATION_1625304609_IS_ACTIVE = TRUE;SET @MIGRATION_1625465756_IS_ACTIVE = TRUE;SET @MIGRATION_1625505190_IS_ACTIVE = TRUE;SET @MIGRATION_1625554302_IS_ACTIVE = TRUE;SET @MIGRATION_1625569667_IS_ACTIVE = TRUE;SET @MIGRATION_1625583596_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1625816310_IS_ACTIVE = TRUE;SET @MIGRATION_1625819412_IS_ACTIVE = TRUE;SET @MIGRATION_1625831469_IS_ACTIVE = TRUE;SET @MIGRATION_1626241110_IS_ACTIVE = TRUE;SET @MIGRATION_1626442868_IS_ACTIVE = TRUE;SET @MIGRATION_1626696809_IS_ACTIVE = TRUE;SET @MIGRATION_1626785125_IS_ACTIVE = TRUE;SET @MIGRATION_1627292049_IS_ACTIVE = TRUE;SET @MIGRATION_1627540693_IS_ACTIVE = TRUE;SET @MIGRATION_1627541488_IS_ACTIVE = TRUE;SET @MIGRATION_1627562945_IS_ACTIVE = TRUE;SET @MIGRATION_1627650101_IS_ACTIVE = TRUE;SET @MIGRATION_1627929168_IS_ACTIVE = TRUE;SET @MIGRATION_1627983652_IS_ACTIVE = TRUE;SET @MIGRATION_1628519513_IS_ACTIVE = TRUE;SET @MIGRATION_1628749113_IS_ACTIVE = TRUE;SET @MIGRATION_1629204538_IS_ACTIVE = TRUE;SET @MIGRATION_1629700169_IS_ACTIVE = TRUE;SET @MIGRATION_1629877210_IS_ACTIVE = TRUE;SET @MIGRATION_1630074081_IS_ACTIVE = TRUE;SET @MIGRATION_1630485317_IS_ACTIVE = TRUE;SET @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1631863869_IS_ACTIVE = TRUE;SET @MIGRATION_1632111590_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_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_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_1675420139_IS_ACTIVE = TRUE;SET @MIGRATION_1572012839_IS_ACTIVE = TRUE;SET @MIGRATION_1572012863_IS_ACTIVE = TRUE;SET @MIGRATION_1572012872_IS_ACTIVE = TRUE;SET @MIGRATION_1572172912_IS_ACTIVE = TRUE;SET @MIGRATION_1573059308_IS_ACTIVE = TRUE;SET @MIGRATION_1574260096_IS_ACTIVE = TRUE;SET @MIGRATION_1596724410_IS_ACTIVE = TRUE;SET @MIGRATION_1602017170_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1589963718_IS_ACTIVE = TRUE;SET @MIGRATION_1619069101_IS_ACTIVE = TRUE;SET @MIGRATION_1623656945_IS_ACTIVE = TRUE;SET @MIGRATION_1623820553_IS_ACTIVE = TRUE;SET @MIGRATION_1624275180_IS_ACTIVE = TRUE;SET @MIGRATION_1633436214_IS_ACTIVE = TRUE
6 0.75 ms
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
7 0.37 ms
SELECT item_rounding FROM currency WHERE id = :id
8 0.29 ms
SELECT `sendcloud_processes`.`id` as `sendcloud_processes.id`, `sendcloud_processes`.`guid` as `sendcloud_processes.guid`, `sendcloud_processes`.`runner` as `sendcloud_processes.runner` FROM `sendcloud_processes` WHERE (`sendcloud_processes`.`guid` = :param_da88c0e5f2ce4096b1b6ec195841059d)
9 0.18 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
10 0.11 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
11 0.09 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
12 0.10 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
13 0.09 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
14 0.09 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
15 0.09 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
16 0.09 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
17 0.25 ms
SELECT `sendcloud_queues`.`id` FROM `sendcloud_queues` WHERE (`sendcloud_queues`.`status` = :param_b4ed4f7cd8d74e3a81b3c4c819310cba) LIMIT 10
18 0.14 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
19 0.13 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
20 0.11 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
21 0.11 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
22 0.12 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
23 0.18 ms
SELECT `sendcloud_queues`.`id` FROM `sendcloud_queues` WHERE (`sendcloud_queues`.`status` = :param_b8e04641576a47f6988446d08f073ab1) LIMIT 10
24 0.42 ms
SELECT * 
                  FROM (
                    SELECT queueName, min(internalId) AS internalId
                    FROM sendcloud_queues AS t
                    WHERE t.status='queued' AND t.queueName NOT IN (SELECT DISTINCT queueName 
                               FROM sendcloud_queues qi2 
                               WHERE qi2.status='in_progress')
                    GROUP BY queueName LIMIT 8
                  ) AS queueView
                  INNER JOIN sendcloud_queues AS qi ON queueView.queueName=qi.queueName and queueView.internalId=qi.internalId
25 0.16 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
26 0.12 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
27 0.10 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
28 0.10 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
29 0.10 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
30 0.48 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
31 0.15 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
32 1.25 ms
UPDATE sendcloud_configs SET `key` = ?, `value` = ? WHERE `id` = ?
33 0.17 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
34 0.14 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
35 0.14 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
36 0.14 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
37 0.14 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
38 0.91 ms
UPDATE sendcloud_configs SET `key` = ?, `value` = ? WHERE `id` = ?
39 0.30 ms
SELECT `sendcloud_processes`.`id` as `sendcloud_processes.id`, `sendcloud_processes`.`guid` as `sendcloud_processes.guid`, `sendcloud_processes`.`runner` as `sendcloud_processes.runner` FROM `sendcloud_processes` WHERE (`sendcloud_processes`.`guid` = :param_da49739466be4a8b9c6c0d6ff3ce8632)
40 0.36 ms
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id
41 0.19 ms
SELECT 1 as `exists`, `id` FROM `sendcloud_processes` WHERE `id` IN (?)
42 0.07 ms
"START TRANSACTION"
43 0.31 ms
INSERT INTO `sendcloud_processes` (`id`, `guid`, `runner`) VALUES (,'245823_680c6b5de2d86','C:70:\"Sendcloud\\Shipping\\Core\\Infrastructure\\TaskExecution\\TaskRunnerStarter\":38:{a:1:{i:0;s:20:\"245823_680c6b5de281a\";}}');
44 0.88 ms
"COMMIT"
45 1.38 ms
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_5a6e54bbda9f442ea93081420c3e8c0e)
46 0.54 ms
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
47 0.36 ms
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
48 0.40 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
49 0.12 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
50 0.19 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
51 0.33 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
52 0.10 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
53 0.21 ms
SELECT `sendcloud_queues`.`id` FROM `sendcloud_queues` WHERE (`sendcloud_queues`.`type` = :param_e37e4f63f6094c84a11dd4db2ba6a24a) ORDER BY `sendcloud_queues`.`queueTimestamp` DESC LIMIT 50
54 0.28 ms
SELECT `sendcloud_queues`.`id` as `sendcloud_queues.id`, `sendcloud_queues`.`internalId` as `sendcloud_queues.internalId`, `sendcloud_queues`.`status` as `sendcloud_queues.status`, `sendcloud_queues`.`type` as `sendcloud_queues.type`, `sendcloud_queues`.`queueName` as `sendcloud_queues.queueName`, `sendcloud_queues`.`progress` as `sendcloud_queues.progress`, `sendcloud_queues`.`lastExecutionProgress` as `sendcloud_queues.lastExecutionProgress`, `sendcloud_queues`.`retries` as `sendcloud_queues.retries`, `sendcloud_queues`.`failureDescription` as `sendcloud_queues.failureDescription`, `sendcloud_queues`.`serializedTask` as `sendcloud_queues.serializedTask`, `sendcloud_queues`.`createTimestamp` as `sendcloud_queues.createTimestamp`, `sendcloud_queues`.`queueTimestamp` as `sendcloud_queues.queueTimestamp`, `sendcloud_queues`.`lastUpdateTimestamp` as `sendcloud_queues.lastUpdateTimestamp`, `sendcloud_queues`.`startTimestamp` as `sendcloud_queues.startTimestamp`, `sendcloud_queues`.`finishTimestamp` as `sendcloud_queues.finishTimestamp`, `sendcloud_queues`.`failTimestamp` as `sendcloud_queues.failTimestamp` FROM `sendcloud_queues` WHERE `sendcloud_queues`.`id` IN (:ids)
55 0.12 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
56 0.21 ms
SELECT `sendcloud_queues`.`id` FROM `sendcloud_queues` WHERE (`sendcloud_queues`.`type` = :param_49575c39bbd34c8db2c489fcf7345d7d) ORDER BY `sendcloud_queues`.`queueTimestamp` DESC LIMIT 50
57 0.24 ms
SELECT `sendcloud_queues`.`id` as `sendcloud_queues.id`, `sendcloud_queues`.`internalId` as `sendcloud_queues.internalId`, `sendcloud_queues`.`status` as `sendcloud_queues.status`, `sendcloud_queues`.`type` as `sendcloud_queues.type`, `sendcloud_queues`.`queueName` as `sendcloud_queues.queueName`, `sendcloud_queues`.`progress` as `sendcloud_queues.progress`, `sendcloud_queues`.`lastExecutionProgress` as `sendcloud_queues.lastExecutionProgress`, `sendcloud_queues`.`retries` as `sendcloud_queues.retries`, `sendcloud_queues`.`failureDescription` as `sendcloud_queues.failureDescription`, `sendcloud_queues`.`serializedTask` as `sendcloud_queues.serializedTask`, `sendcloud_queues`.`createTimestamp` as `sendcloud_queues.createTimestamp`, `sendcloud_queues`.`queueTimestamp` as `sendcloud_queues.queueTimestamp`, `sendcloud_queues`.`lastUpdateTimestamp` as `sendcloud_queues.lastUpdateTimestamp`, `sendcloud_queues`.`startTimestamp` as `sendcloud_queues.startTimestamp`, `sendcloud_queues`.`finishTimestamp` as `sendcloud_queues.finishTimestamp`, `sendcloud_queues`.`failTimestamp` as `sendcloud_queues.failTimestamp` FROM `sendcloud_queues` WHERE `sendcloud_queues`.`id` IN (:ids)
58 0.11 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
59 0.17 ms
SELECT `sendcloud_queues`.`id` FROM `sendcloud_queues` WHERE (`sendcloud_queues`.`type` = :param_a1f07a5a73634a8eba1e28d972ef2bc7) ORDER BY `sendcloud_queues`.`queueTimestamp` DESC LIMIT 50
60 0.23 ms
SELECT `sendcloud_queues`.`id` as `sendcloud_queues.id`, `sendcloud_queues`.`internalId` as `sendcloud_queues.internalId`, `sendcloud_queues`.`status` as `sendcloud_queues.status`, `sendcloud_queues`.`type` as `sendcloud_queues.type`, `sendcloud_queues`.`queueName` as `sendcloud_queues.queueName`, `sendcloud_queues`.`progress` as `sendcloud_queues.progress`, `sendcloud_queues`.`lastExecutionProgress` as `sendcloud_queues.lastExecutionProgress`, `sendcloud_queues`.`retries` as `sendcloud_queues.retries`, `sendcloud_queues`.`failureDescription` as `sendcloud_queues.failureDescription`, `sendcloud_queues`.`serializedTask` as `sendcloud_queues.serializedTask`, `sendcloud_queues`.`createTimestamp` as `sendcloud_queues.createTimestamp`, `sendcloud_queues`.`queueTimestamp` as `sendcloud_queues.queueTimestamp`, `sendcloud_queues`.`lastUpdateTimestamp` as `sendcloud_queues.lastUpdateTimestamp`, `sendcloud_queues`.`startTimestamp` as `sendcloud_queues.startTimestamp`, `sendcloud_queues`.`finishTimestamp` as `sendcloud_queues.finishTimestamp`, `sendcloud_queues`.`failTimestamp` as `sendcloud_queues.failTimestamp` FROM `sendcloud_queues` WHERE `sendcloud_queues`.`id` IN (:ids)
61 0.11 ms
SELECT * FROM `sendcloud_configs` WHERE `key` = ?
62 0.15 ms
SELECT `sendcloud_processes`.`id` as `sendcloud_processes.id`, `sendcloud_processes`.`guid` as `sendcloud_processes.guid`, `sendcloud_processes`.`runner` as `sendcloud_processes.runner` FROM `sendcloud_processes` WHERE (`sendcloud_processes`.`guid` = :param_e2c32357387647ec99931c44b9247c72)
63 0.10 ms
SELECT 1 as `exists`, `id` FROM `sendcloud_processes` WHERE `id` IN (?)
64 0.03 ms
"START TRANSACTION"
65 0.14 ms
DELETE FROM `sendcloud_processes` WHERE id = ?
66 0.62 ms
"COMMIT"
67 0.93 ms
# app-scripts::refresh::read
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_389de095f7e4410489d1d9a79425f225)
68 0.42 ms
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
69 0.30 ms
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`

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