| 1 |
0.28 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
| 2 |
0.28 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.26 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;
;
|
| 4 |
0.12 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',''));
|
| 5 |
0.54 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;
|
| 6 |
0.15 ms |
SELECT item_rounding FROM currency WHERE id = ?
Parameters: [
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
|
| 7 |
0.16 ms |
SELECT id FROM integration WHERE access_key = ?
Parameters: [
"SWIANUXAQM0WTUFOUW45S2HTTG"
]
SELECT id FROM integration WHERE access_key = 'SWIANUXAQM0WTUFOUW45S2HTTG';
|
| 8 |
0.22 ms |
SELECT `acl_role`.`privileges`
FROM `acl_role`
INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE `app`.`integration_id` = ?
Parameters: [
b"?ñö}©ÑIÖ J&È’Ë×ý"
]
SELECT `acl_role`.`privileges`
FROM `acl_role`
INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE `app`.`integration_id` = 0x3FF1F67DA9D149D6A04A26C892CBD7FD
;
|
| 9 |
0.08 ms |
SELECT admin FROM `integration` WHERE id = ?
Parameters: [
b"?ñö}©ÑIÖ J&È’Ë×ý"
]
SELECT admin FROM `integration` WHERE id = 0x3FF1F67DA9D149D6A04A26C892CBD7FD;
|
| 10 |
0.12 ms |
SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = ?
Parameters: [
b"?ñö}©ÑIÖ J&È’Ë×ý"
]
SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = 0x3FF1F67DA9D149D6A04A26C892CBD7FD;
|
| 11 |
0.30 ms |
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule`
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule`;
|