1 |
0.63 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
2 |
0.56 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.20 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.35 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
5 |
0.42 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 |
0.55 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.38 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.34 ms |
SELECT item_rounding FROM currency WHERE id = ?
Parameters: [
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
|
9 |
0.24 ms |
SELECT id FROM integration WHERE access_key = ?
Parameters: [
"SWIAWKZ5EUZSAZDDBG5ZT1JJYW"
]
SELECT id FROM integration WHERE access_key = 'SWIAWKZ5EUZSAZDDBG5ZT1JJYW';
|
10 |
0.23 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"\x01•|\x7FUÈpÓ½…rð\x03\x07Tk"
]
SELECT `acl_role`.`privileges`
FROM `acl_role`
INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE `app`.`integration_id` = 0x01957C7F55C870D3BD8572F00307546B
;
|
11 |
0.20 ms |
SELECT admin FROM `integration` WHERE id = ?
Parameters: [
b"\x01•|\x7FUÈpÓ½…rð\x03\x07Tk"
]
SELECT admin FROM `integration` WHERE id = 0x01957C7F55C870D3BD8572F00307546B;
|
12 |
0.21 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"\x01•|\x7FUÈpÓ½…rð\x03\x07Tk"
]
SELECT role.privileges FROM integration_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.integration_id = 0x01957C7F55C870D3BD8572F00307546B;
|
13 |
0.34 ms |
SELECT `state_machine`.`id` FROM `state_machine` LIMIT 50
SELECT `state_machine`.`id` FROM `state_machine` LIMIT 50;
|
14 |
0.21 ms |
SELECT COUNT(*) FROM (SELECT `state_machine`.`id` FROM `state_machine`) total
SELECT COUNT(*) FROM (SELECT `state_machine`.`id` FROM `state_machine`) total;
|
15 |
0.55 ms |
SELECT `state_machine`.`id` as `state_machine.id`, `state_machine`.`technical_name` as `state_machine.technicalName`, `state_machine`.`initial_state_id` as `state_machine.initialStateId`, `state_machine`.`created_at` as `state_machine.createdAt`, `state_machine`.`updated_at` as `state_machine.updatedAt`, `state_machine.translation.name`, `state_machine.translation.name` as `state_machine.name`, `state_machine.translation.customFields`, `state_machine.translation.customFields` as `state_machine.customFields` FROM `state_machine` LEFT JOIN (SELECT `state_machine.translation`.`state_machine_id`, `state_machine.translation`.`name` as `state_machine.translation.name`, `state_machine.translation`.`custom_fields` as `state_machine.translation.customFields` FROM `state_machine_translation` `state_machine.translation` WHERE `state_machine.translation`.`language_id` = ?) `state_machine.state_machine_translation` ON `state_machine.state_machine_translation`.`state_machine_id` = `state_machine`.`id` WHERE `state_machine`.`id` IN (?, ?, ?, ?, ?)
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"\x01•|`9är`¶Ë'o.Ò˜w"
b"\x01ò|`C\x1ApKüU÷3§FÛ&"
b"\x01ò|`L▒sÑì\x18ÓGÊ7ø┬"
b"\x01•|jâmr\x19‚òK²ÒãÑå"
b"""
\x01•|jè\n
qQ¬‹»Xµ\x01N¤
"""
]
SELECT `state_machine`.`id` as `state_machine.id`, `state_machine`.`technical_name` as `state_machine.technicalName`, `state_machine`.`initial_state_id` as `state_machine.initialStateId`, `state_machine`.`created_at` as `state_machine.createdAt`, `state_machine`.`updated_at` as `state_machine.updatedAt`, `state_machine.translation.name`, `state_machine.translation.name` as `state_machine.name`, `state_machine.translation.customFields`, `state_machine.translation.customFields` as `state_machine.customFields` FROM `state_machine` LEFT JOIN (SELECT `state_machine.translation`.`state_machine_id`, `state_machine.translation`.`name` as `state_machine.translation.name`, `state_machine.translation`.`custom_fields` as `state_machine.translation.customFields` FROM `state_machine_translation` `state_machine.translation` WHERE `state_machine.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `state_machine.state_machine_translation` ON `state_machine.state_machine_translation`.`state_machine_id` = `state_machine`.`id` WHERE `state_machine`.`id` IN (0x01957C6039E47260B6CB276F2ED29877, 0x01957C60431A704B8155F633F546EA26, 0x01957C604CB173A58D18E047D2379BC2, 0x01957C6AE26D721982F24BB2D2E3D1E5, 0x01957C6AE80A7151AC8BBB58B5014EA4);
|
16 |
0.46 ms |
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`state_machine_id` IN (?, ?, ?, ?, ?))
Parameters: [
b"\x01•|`9är`¶Ë'o.Ò˜w"
b"\x01ò|`C\x1ApKüU÷3§FÛ&"
b"\x01ò|`L▒sÑì\x18ÓGÊ7ø┬"
b"\x01•|jâmr\x19‚òK²ÒãÑå"
b"""
\x01•|jè\n
qQ¬‹»Xµ\x01N¤
"""
]
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`state_machine_id` IN (0x01957C6039E47260B6CB276F2ED29877, 0x01957C60431A704B8155F633F546EA26, 0x01957C604CB173A58D18E047D2379BC2, 0x01957C6AE26D721982F24BB2D2E3D1E5, 0x01957C6AE80A7151AC8BBB58B5014EA4));
|
17 |
0.57 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.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 (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` WHERE (`state_machine_state`.`state_machine_id` IN (?, ?, ?, ?, ?))
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"\x01•|`9är`¶Ë'o.Ò˜w"
b"\x01ò|`C\x1ApKüU÷3§FÛ&"
b"\x01ò|`L▒sÑì\x18ÓGÊ7ø┬"
b"\x01•|jâmr\x19‚òK²ÒãÑå"
b"""
\x01•|jè\n
qQ¬‹»Xµ\x01N¤
"""
]
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.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 (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` WHERE (`state_machine_state`.`state_machine_id` IN (0x01957C6039E47260B6CB276F2ED29877, 0x01957C60431A704B8155F633F546EA26, 0x01957C604CB173A58D18E047D2379BC2, 0x01957C6AE26D721982F24BB2D2E3D1E5, 0x01957C6AE80A7151AC8BBB58B5014EA4));
|
18 |
0.56 ms |
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`from_state_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: [
b"\x01•|`9är`¶Ë'o/~³Û"
b"\x01•|`9är`¶Ë'o0=\x1Da"
b"\x01•|`9är`¶Ë'o0§JÇ"
b"\x01•|`9är`¶Ë'o0ðµC"
b"\x01ò|`C\x1ApKüU÷3§¹Ñé"
b"\x01ò|`C\x1ApKüU÷3÷"®ÿ"
b"\x01ò|`C\x1ApKüU÷3÷yÞò"
b"\x01ò|`C\x1ApKüU÷3¸9s%"
b"\x01ò|`C\x1ApKüU÷3¸Ô|,"
b"\x01ò|`C\x1ApKüU÷3° Ê="
b"\x01ò|`L▒sÑì\x18ÓGË":┐"
b"\x01ò|`L▒sÑì\x18ÓGËc\x07\r"
b"\x01ò|`L▒sÑì\x18ÓGËı$Þ"
b"\x01ò|`L▒sÑì\x18ÓGÈëÖm"
b"\x01ò|`L▒sÑì\x18ÓGÈö╩"
b"\x01ò|`L▒sÑì\x18ÓGıîL╦"
b"\x01ò|`L▒sÑì\x18ÓGı§\x16Ê"
b"\x01•|c¶´r¯»>Öµg&M²"
b"\x01•|c¶´r¯»>ÖµgžiÏ"
b"\x01•|ew\x0Fp\x03¤×Άk]€‘"
b"\x01•|eyÚs²•\x04à\t¶_þ"
b"\x01•|j\x1E2qØ—ÁÐ7M\e‚F"
b"\x01•|jã@s\x0F¬AµÐRÌš’"
b"\x01ò|jõÉsÄ¡.▒(╠\x00ü\x15"
b"\x01•|jåGs\x12¬UŸUÂcÿÅ"
b"\x01•|jé£q&…7Ƕ\x19ž”„"
b"\x01ò|jÙ&s▀íÉ¡\x16ıuêb"
b"\x01•|jìºrP„½õý\eÊM\x13"
b"\x01•|jîFq³”\x1F¨æÉ\eÕÉ"
b"\x01•|jïls\x07„·å4\x7F\x00‘W"
]
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`from_state_id` IN (0x01957C6039E47260B6CB276F2F7EB3DB, 0x01957C6039E47260B6CB276F303D1D61, 0x01957C6039E47260B6CB276F30A74AC7, 0x01957C6039E47260B6CB276F30F0B543, 0x01957C60431A704B8155F633F5FBA582, 0x01957C60431A704B8155F633F622A998, 0x01957C60431A704B8155F633F679E895, 0x01957C60431A704B8155F633F7397325, 0x01957C60431A704B8155F633F7E27C2C, 0x01957C60431A704B8155F633F820D23D, 0x01957C604CB173A58D18E047D3223ABF, 0x01957C604CB173A58D18E047D363070D, 0x01957C604CB173A58D18E047D3D524E8, 0x01957C604CB173A58D18E047D489996D, 0x01957C604CB173A58D18E047D4F094CA, 0x01957C604CB173A58D18E047D58C4CCB, 0x01957C604CB173A58D18E047D5F516D2, 0x01957C63B6B472AFBB3ED6B567264DB2, 0x01957C63B6B472AFBB3ED6B5679E69CF, 0x01957C65770F7003A4D7CE866B5D8091, 0x01957C6579DA73B29504E009B65FADFE, 0x01957C6A1E3271D897C1D0374D1B8246, 0x01957C6AE340730FAC41B5D052CC9A92, 0x01957C6AE490738EAD2EB128CC008115, 0x01957C6AE5477312AC559F55C263FFC5, 0x01957C6AE9A371268537C7B6199E9484, 0x01957C6AEB2673DFA190AD16D5758862, 0x01957C6AECBA725084BDF5FD1BCA4D13, 0x01957C6AEE4671B3941FA8E6C91BD5C9, 0x01957C6AEF6C730784B7E5347F009157));
|
19 |
0.56 ms |
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`to_state_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: [
b"\x01•|`9är`¶Ë'o/~³Û"
b"\x01•|`9är`¶Ë'o0=\x1Da"
b"\x01•|`9är`¶Ë'o0§JÇ"
b"\x01•|`9är`¶Ë'o0ðµC"
b"\x01ò|`C\x1ApKüU÷3§¹Ñé"
b"\x01ò|`C\x1ApKüU÷3÷"®ÿ"
b"\x01ò|`C\x1ApKüU÷3÷yÞò"
b"\x01ò|`C\x1ApKüU÷3¸9s%"
b"\x01ò|`C\x1ApKüU÷3¸Ô|,"
b"\x01ò|`C\x1ApKüU÷3° Ê="
b"\x01ò|`L▒sÑì\x18ÓGË":┐"
b"\x01ò|`L▒sÑì\x18ÓGËc\x07\r"
b"\x01ò|`L▒sÑì\x18ÓGËı$Þ"
b"\x01ò|`L▒sÑì\x18ÓGÈëÖm"
b"\x01ò|`L▒sÑì\x18ÓGÈö╩"
b"\x01ò|`L▒sÑì\x18ÓGıîL╦"
b"\x01ò|`L▒sÑì\x18ÓGı§\x16Ê"
b"\x01•|c¶´r¯»>Öµg&M²"
b"\x01•|c¶´r¯»>ÖµgžiÏ"
b"\x01•|ew\x0Fp\x03¤×Άk]€‘"
b"\x01•|eyÚs²•\x04à\t¶_þ"
b"\x01•|j\x1E2qØ—ÁÐ7M\e‚F"
b"\x01•|jã@s\x0F¬AµÐRÌš’"
b"\x01ò|jõÉsÄ¡.▒(╠\x00ü\x15"
b"\x01•|jåGs\x12¬UŸUÂcÿÅ"
b"\x01•|jé£q&…7Ƕ\x19ž”„"
b"\x01ò|jÙ&s▀íÉ¡\x16ıuêb"
b"\x01•|jìºrP„½õý\eÊM\x13"
b"\x01•|jîFq³”\x1F¨æÉ\eÕÉ"
b"\x01•|jïls\x07„·å4\x7F\x00‘W"
]
SELECT `state_machine_transition`.`id` as `state_machine_transition.id`, `state_machine_transition`.`action_name` as `state_machine_transition.actionName`, `state_machine_transition`.`state_machine_id` as `state_machine_transition.stateMachineId`, `state_machine_transition`.`from_state_id` as `state_machine_transition.fromStateId`, `state_machine_transition`.`to_state_id` as `state_machine_transition.toStateId`, `state_machine_transition`.`custom_fields` as `state_machine_transition.customFields`, `state_machine_transition`.`created_at` as `state_machine_transition.createdAt`, `state_machine_transition`.`updated_at` as `state_machine_transition.updatedAt` FROM `state_machine_transition` WHERE (`state_machine_transition`.`to_state_id` IN (0x01957C6039E47260B6CB276F2F7EB3DB, 0x01957C6039E47260B6CB276F303D1D61, 0x01957C6039E47260B6CB276F30A74AC7, 0x01957C6039E47260B6CB276F30F0B543, 0x01957C60431A704B8155F633F5FBA582, 0x01957C60431A704B8155F633F622A998, 0x01957C60431A704B8155F633F679E895, 0x01957C60431A704B8155F633F7397325, 0x01957C60431A704B8155F633F7E27C2C, 0x01957C60431A704B8155F633F820D23D, 0x01957C604CB173A58D18E047D3223ABF, 0x01957C604CB173A58D18E047D363070D, 0x01957C604CB173A58D18E047D3D524E8, 0x01957C604CB173A58D18E047D489996D, 0x01957C604CB173A58D18E047D4F094CA, 0x01957C604CB173A58D18E047D58C4CCB, 0x01957C604CB173A58D18E047D5F516D2, 0x01957C63B6B472AFBB3ED6B567264DB2, 0x01957C63B6B472AFBB3ED6B5679E69CF, 0x01957C65770F7003A4D7CE866B5D8091, 0x01957C6579DA73B29504E009B65FADFE, 0x01957C6A1E3271D897C1D0374D1B8246, 0x01957C6AE340730FAC41B5D052CC9A92, 0x01957C6AE490738EAD2EB128CC008115, 0x01957C6AE5477312AC559F55C263FFC5, 0x01957C6AE9A371268537C7B6199E9484, 0x01957C6AEB2673DFA190AD16D5758862, 0x01957C6AECBA725084BDF5FD1BCA4D13, 0x01957C6AEE4671B3941FA8E6C91BD5C9, 0x01957C6AEF6C730784B7E5347F009157));
|