5.76 ms (51.96%)
|
5 |
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');
|
0.94 ms (8.49%)
|
1 |
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`;;
|
0.41 ms (3.69%)
|
1 |
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',''));
|