| 1 |
0.57 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
| 2 |
0.81 ms |
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
`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.39 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 @@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',''));
|
| 4 |
0.59 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
| 5 |
7.41 ms |
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 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;
;
|
| 6 |
1.53 ms |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;
|
| 7 |
0.69 ms |
SELECT `name`, `path`, `author`, `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name`, `path`, `author`, `self_managed`
FROM `app`
WHERE `active` = 1
;
|
| 8 |
0.70 ms |
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters: [
b"ÚЇ¼3IN^‚hÙ*ý¤\x1D’"
]
SELECT last_updated_password_at FROM user WHERE id = 0xDAD087BC33494E5E8268D92AFDA41D92;
|
| 9 |
0.42 ms |
SELECT item_rounding FROM currency WHERE id = ?
Parameters: [
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
|
| 10 |
0.71 ms |
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = ?
Parameters: [
b"ÚЇ¼3IN^‚hÙ*ý¤\x1D’"
]
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0xDAD087BC33494E5E8268D92AFDA41D92;
|
| 11 |
0.28 ms |
SELECT admin FROM `user` WHERE id = ?
Parameters: [
b"ÚЇ¼3IN^‚hÙ*ý¤\x1D’"
]
SELECT admin FROM `user` WHERE id = 0xDAD087BC33494E5E8268D92AFDA41D92;
|
| 12 |
1.63 ms |
SELECT `key` as array_key, `pool`, `cluster`, `key`, `count`
FROM `increment` WHERE `cluster` = ? AND `pool` = ?
ORDER BY `count` DESC, `updated_at` DESC
Parameters: [
"message_queue_stats"
"message_queue"
]
SELECT `key` as array_key, `pool`, `cluster`, `key`, `count`
FROM `increment` WHERE `cluster` = 'message_queue_stats' AND `pool` = 'message_queue'
ORDER BY `count` DESC, `updated_at` DESC;
|
| 13 |
0.81 ms |
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters: [
true
false
]
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = 1 AND `app`.`self_managed` = 0);
|
| 14 |
1.26 ms |
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`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `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`.`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`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` 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` 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` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"\x01Éã\x1AµFs‗ضÖ\x11Ìt1C"
]
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`.`checkout_gateway_url` as `app.checkoutGatewayUrl`,
`app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`,
`app`.`source_type` as `app.sourceType`,
`app`.`source_config` as `app.sourceConfig`,
`app`.`self_managed` as `app.selfManaged`,
`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`.`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`,
`app.translation.label` as `app.label`,
`app.translation.description`,
`app.translation.description` as `app.description`,
`app.translation.privacyPolicyExtensions`,
`app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`,
`app.translation.customFields`,
`app.translation.customFields` as `app.customFields`
FROM
`app`
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`
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`
FROM
`app_translation` `app.translation`
WHERE
`app.translation`.`language_id` = ?
) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
WHERE
`app`.`id` IN (?)
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`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `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`.`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`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` 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` 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` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE `app`.`id` IN (0x0190C61AE64673F29DF49911DE743143);
|
| 15 |
0.85 ms |
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters: [
b"\x01Éã\x1AµFs‗ضÖ\x11Ìt1C"
]
SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (0x0190C61AE64673F29DF49911DE743143));
|
| 16 |
1.44 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`
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`
;
|
| 17 |
1.10 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`
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`
;
|
| 18 |
1.24 ms |
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = ?) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = ?) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = ? AND `state_machine_state.stateMachine`.`technical_name` = ?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"/»_ââšMpªXTÎ|ãâ\v"
"active"
"netcon_stock_item.state"
]
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = 'active' AND `state_machine_state.stateMachine`.`technical_name` = 'netcon_stock_item.state');
|
| 19 |
1.06 ms |
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = ?) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = ?) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = ? AND `state_machine_state.stateMachine`.`technical_name` = ?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"/»_ââšMpªXTÎ|ãâ\v"
"reserved"
"netcon_stock_item.state"
]
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = 'reserved' AND `state_machine_state.stateMachine`.`technical_name` = 'netcon_stock_item.state');
|
| 20 |
1.16 ms |
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = ?) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = ?) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = ? AND `state_machine_state.stateMachine`.`technical_name` = ?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"/»_ââšMpªXTÎ|ãâ\v"
"assigned"
"netcon_stock_item.state"
]
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = 'assigned' AND `state_machine_state.stateMachine`.`technical_name` = 'netcon_stock_item.state');
|
| 21 |
1.15 ms |
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = ?) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = ?) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = ? AND `state_machine_state.stateMachine`.`technical_name` = ?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"/»_ââšMpªXTÎ|ãâ\v"
"deactivated"
"netcon_stock_item.state"
]
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = 'deactivated' AND `state_machine_state.stateMachine`.`technical_name` = 'netcon_stock_item.state');
|
| 22 |
1.16 ms |
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = ?) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = ?) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = ? AND `state_machine_state.stateMachine`.`technical_name` = ?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"/»_ââšMpªXTÎ|ãâ\v"
"none"
"netcon_stock_item.rma_state"
]
SELECT `state_machine_state`.`id` as `state_machine_state.id`, `state_machine_state`.`technical_name` as `state_machine_state.technicalName`, `state_machine_state`.`state_machine_id` as `state_machine_state.stateMachineId`, `state_machine_state`.`created_at` as `state_machine_state.createdAt`, `state_machine_state`.`updated_at` as `state_machine_state.updatedAt`, `state_machine_state.stateMachine`.`id` as `state_machine_state.stateMachine.id`, `state_machine_state.stateMachine`.`technical_name` as `state_machine_state.stateMachine.technicalName`, `state_machine_state.stateMachine`.`initial_state_id` as `state_machine_state.stateMachine.initialStateId`, `state_machine_state.stateMachine`.`created_at` as `state_machine_state.stateMachine.createdAt`, `state_machine_state.stateMachine`.`updated_at` as `state_machine_state.stateMachine.updatedAt`, `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation.name` as `state_machine_state.stateMachine.name`, `state_machine_state.stateMachine.translation.customFields`, `state_machine_state.stateMachine.translation.customFields` as `state_machine_state.stateMachine.customFields`, `state_machine_state.translation.name`, `state_machine_state.translation.name` as `state_machine_state.name`, `state_machine_state.translation.customFields`, `state_machine_state.translation.customFields` as `state_machine_state.customFields` FROM `state_machine_state` LEFT JOIN `state_machine` `state_machine_state.stateMachine` ON `state_machine_state`.`state_machine_id` = `state_machine_state.stateMachine`.`id` LEFT JOIN (SELECT `state_machine_state.translation`.`state_machine_state_id`, `state_machine_state.translation`.`name` as `state_machine_state.translation.name`, `state_machine_state.translation`.`custom_fields` as `state_machine_state.translation.customFields` FROM `state_machine_state_translation` `state_machine_state.translation` WHERE `state_machine_state.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.state_machine_state_translation` ON `state_machine_state.state_machine_state_translation`.`state_machine_state_id` = `state_machine_state`.`id` LEFT JOIN (SELECT `state_machine_state.stateMachine.translation`.`state_machine_id`, `state_machine_state.stateMachine.translation`.`name` as `state_machine_state.stateMachine.translation.name`, `state_machine_state.stateMachine.translation`.`custom_fields` as `state_machine_state.stateMachine.translation.customFields` FROM `state_machine_translation` `state_machine_state.stateMachine.translation` WHERE `state_machine_state.stateMachine.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine_state.stateMachine.state_machine_translation` ON `state_machine_state.stateMachine.state_machine_translation`.`state_machine_id` = `state_machine_state.stateMachine`.`id` WHERE (`state_machine_state`.`technical_name` = 'none' AND `state_machine_state.stateMachine`.`technical_name` = 'netcon_stock_item.rma_state');
|