1 |
0.37 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`;;
|
2 |
0.25 ms |
SELECT `key`, `value` FROM `app_config`
SELECT `key`, `value` FROM `app_config`;
|
3 |
0.27 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 |
1.16 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;
|
5 |
0.21 ms |
SELECT `name`, `path`, `author`, `self_managed`
FROM `app`
WHERE `active` = 1
SELECT `name`, `path`, `author`, `self_managed`
FROM `app`
WHERE `active` = 1
;
|
6 |
0.28 ms |
SELECT last_updated_password_at FROM user WHERE id = ?
Parameters: [
b"\x01—ϵxØ\x7F¦ƒq9&Çíat"
]
SELECT last_updated_password_at FROM user WHERE id = 0x0197CFB578D87FA683713926C7ED6174;
|
7 |
0.20 ms |
SELECT item_rounding FROM currency WHERE id = ?
Parameters: [
b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA;
|
8 |
0.28 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"\x01—ϵxØ\x7F¦ƒq9&Çíat"
]
SELECT role.privileges FROM acl_user_role mapping INNER JOIN acl_role role ON mapping.acl_role_id = role.id WHERE mapping.user_id = 0x0197CFB578D87FA683713926C7ED6174;
|
9 |
0.19 ms |
SELECT admin FROM `user` WHERE id = ?
Parameters: [
b"\x01—ϵxØ\x7F¦ƒq9&Çíat"
]
SELECT admin FROM `user` WHERE id = 0x0197CFB578D87FA683713926C7ED6174;
|
10 |
0.19 ms |
SELECT module.module, module.response FROM wbm_data_layer_modules module
SELECT module.module, module.response FROM wbm_data_layer_modules module;
|
11 |
0.31 ms |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1;
|
12 |
0.93 ms |
SELECT `cms_page`.`id`, SUM(IF(COALESCE(`cms_page.translation.name`) = ? , '1', 0) + IF(COALESCE(`cms_page.translation.name`) LIKE ? , '0.5', 0) + IF(COALESCE(`cms_page.translation.customFields`) = ? , '1', 0) + IF(COALESCE(`cms_page.translation.customFields`) LIKE ? , '0.5', 0)) / COUNT(cms_page.id) as _score FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (COALESCE(`cms_page.translation.name`) = ? OR COALESCE(`cms_page.translation.name`) LIKE ? OR COALESCE(`cms_page.translation.customFields`) = ? OR COALESCE(`cms_page.translation.customFields`) LIKE ?) GROUP BY `cms_page`.`id` HAVING _score >= ? ORDER BY _score DESC LIMIT 25
Parameters: [
"sc"
"%sc%"
"sc"
"%sc%"
b"/»_ââšMpªXTÎ|ãâ\v"
b"\x0F©\x1CãéjK¾KÙÎu,4%"
"sc"
"%sc%"
"sc"
"%sc%"
0.5
]
SELECT `cms_page`.`id`, SUM(IF(COALESCE(`cms_page.translation.name`) = 'sc' , '1', 0) + IF(COALESCE(`cms_page.translation.name`) LIKE '%sc%' , '0.5', 0) + IF(COALESCE(`cms_page.translation.customFields`) = 'sc' , '1', 0) + IF(COALESCE(`cms_page.translation.customFields`) LIKE '%sc%' , '0.5', 0)) / COUNT(cms_page.id) as _score FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (COALESCE(`cms_page.translation.name`) = 'sc' OR COALESCE(`cms_page.translation.name`) LIKE '%sc%' OR COALESCE(`cms_page.translation.customFields`) = 'sc' OR COALESCE(`cms_page.translation.customFields`) LIKE '%sc%') GROUP BY `cms_page`.`id` HAVING _score >= 0.5 ORDER BY _score DESC LIMIT 25;
|
13 |
0.55 ms |
SELECT COUNT(*) FROM (SELECT `cms_page`.`id`, SUM(IF(COALESCE(`cms_page.translation.name`) = ? , '1', 0) + IF(COALESCE(`cms_page.translation.name`) LIKE ? , '0.5', 0) + IF(COALESCE(`cms_page.translation.customFields`) = ? , '1', 0) + IF(COALESCE(`cms_page.translation.customFields`) LIKE ? , '0.5', 0)) / COUNT(cms_page.id) as _score FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (COALESCE(`cms_page.translation.name`) = ? OR COALESCE(`cms_page.translation.name`) LIKE ? OR COALESCE(`cms_page.translation.customFields`) = ? OR COALESCE(`cms_page.translation.customFields`) LIKE ?) GROUP BY `cms_page`.`id` HAVING _score >= ?) total
Parameters: [
"sc"
"%sc%"
"sc"
"%sc%"
b"/»_ââšMpªXTÎ|ãâ\v"
b"\x0F©\x1CãéjK¾KÙÎu,4%"
"sc"
"%sc%"
"sc"
"%sc%"
0.5
]
SELECT COUNT(*) FROM (SELECT `cms_page`.`id`, SUM(IF(COALESCE(`cms_page.translation.name`) = 'sc' , '1', 0) + IF(COALESCE(`cms_page.translation.name`) LIKE '%sc%' , '0.5', 0) + IF(COALESCE(`cms_page.translation.customFields`) = 'sc' , '1', 0) + IF(COALESCE(`cms_page.translation.customFields`) LIKE '%sc%' , '0.5', 0)) / COUNT(cms_page.id) as _score FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (COALESCE(`cms_page.translation.name`) = 'sc' OR COALESCE(`cms_page.translation.name`) LIKE '%sc%' OR COALESCE(`cms_page.translation.customFields`) = 'sc' OR COALESCE(`cms_page.translation.customFields`) LIKE '%sc%') GROUP BY `cms_page`.`id` HAVING _score >= 0.5) total;
|
14 |
0.35 ms |
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?, ?, ?, ?, ?))
Parameters: [
b"/»_ââšMpªXTÎ|ãâ\v"
b"\x0F©\x1CãéjK¾KÙÎu,4%"
b"\x01˜.a'°vŽ¡·õz>\v£‘"
b"\x01ÿöþFkph£ü].U\x7FR╚"
b"\x01ÿ╝³ê\x1ApdªE¯ü+í\x11t"
b"\x01ÿÓZ■|r\x03¥\x10ìÖ³╦7U"
b"\x01ûå; ¼sëÅáTÏæPi?"
]
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`cms_page`.`id` IN (0x01982E6127B0768EA1B7F57A3E0BA391, 0x019894E7466B70689C815D2E557F52C8, 0x0198BCFC881A7064A645EE812BA11174, 0x0198E05AFE7C7203BE108D99FCCB3755, 0x0196863BFFAC73898FA054D89150693F));
|
15 |
0.46 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);
|
16 |
0.61 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 |
0.41 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`
;
|