Skip to main content

Governance Proposal: Webacy’s DYOR Tool - Bringing An Increased Security Presence to QuickSwap and its Users

October 17th 2024

Share on Social Platforms

2024 is shaping up to be a pivotal year for QuickSwap as the decentralised exchange (DEX) continues to expand across multiple blockchain ecosystems. With recent deployments on zkEVM solutions like Polygon zkEVM and Immutable zkEVM, QuickSwap is quickly conquering the multichain landscape.

As QuickSwap's presence grows, it's crucial for users to have access to reliable tools that help them make informed decisions about the tokens they engage with. 

That’s where Webacy’s DYOR (Do Your Own Research) tool comes in. 

This proposal has been written by Webacy on behalf of QuickSwap. They are asking the dragon community if the DEX should integrate their DYOR tool (at no cost - this will be a free product) on the DEX swap page frontend to bring a higher security presence to users and - more information in the proposal below.

  • To begin, the governance discussion on the official QuickSwap Reddit will run until Sunday, October 20 at 5:30 AM UTC
  • Once the Reddit discussions finish, a formal Snapshot vote will run until Thursday, October 24 at 5:30 AM UTC
  • Once you’ve read this entire blog post, make sure to visit the official QuickSwap Reddit discussion forum to share your perspective with your fellow community members

What is Webacy’s DYOR Tool?

The DYOR tool (available at https://dapp.webacy.com/dyor) is designed to give users deep insights into token risks, security, and liquidity. By linking QuickSwap users directly to this tool, they can easily assess the safety and legitimacy of tokens before making any trades.


With QuickSwap expanding to new chains and adding more tokens, having Webacy’s DYOR tool natively integrated into the platform and UI would provide an extra layer of security and research for users without requiring them to leave the platform. 

The DYOR tool enables:

  • Comprehensive Token Analysis: Users can get crucial information on token liquidity, market data, and security risks in real-time, helping them better understand the assets they’re trading.
  • Risk Assessment & Alerts: DYOR highlights potential risks in token contracts or behaviour, ensuring users have all the facts before making investment decisions.
  • Seamless Integration: QuickSwap can easily provide links to DYOR, giving users direct access to in-depth research and risk assessment tools with just a few clicks.

As QuickSwap expands its token offerings and adds more chains, Webacy’s DYOR tool can help ensure the platform remains a secure place to trade. Users will be empowered to evaluate token risks, liquidity, and contract data directly through DYOR, making informed decisions and minimising the chances of engaging with unsafe or risky assets.

Why This Integration Matters

By linking out to Webacy’s DYOR tool, QuickSwap is taking steps to ensure that its users are well-equipped to handle the complexities of token research. This potential integration would:

  • Increase user safety by offering a straightforward way to evaluate tokens before trading.
  • Boost confidence among traders and LPs (liquidity providers) who want transparent, data-driven insights into the tokens listed on QuickSwap.
  • Reinforce QuickSwap’s commitment to user security, providing not only liquidity and trading options but also the tools necessary for careful, informed decision-making.

As QuickSwap continues to grow and innovate across various blockchain ecosystems, partnering with Webacy will provide users with an invaluable resource to help them navigate the ever-evolving DeFi landscape with confidence.

Join the Discussion

As always, QuickSwap community members are encouraged to participate in and contribute to QuickSwap governance discussions and proposals across all of QuickSwap’s online forums, especially on Reddit. As a Dragon, you are a valued community member and your opinion matters – but you have to participate in community voting procedures to make it count.

Critical decisions guiding QuickSwap’s strategic development will always be determined by way of decentralised governance. QuickSwap’s future is in your hands, so make your voice heard!

36.038MBMemory Usage1.83sRequest Duration
Joomla! Version4.4.9
PHP Version8.1.32
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
10.6.20-MariaDB-cll-lve
Collation
latin1_swedish_ci
Conn Collation
utf8mb3_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:51 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743448135 "last" => 1743448135...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.08MB) (38.71ms)
  • afterInitialise (11.41MB) (156ms)
  • afterRoute (2.19MB) (43.83ms)
  • beforeRenderComponent com_content (24.64KB) (827μs)
  • Before Access::preloadComponents (all components) (461.38KB) (5.39ms)
  • After Access::preloadComponents (all components) (126.34KB) (915μs)
  • Before Access::preloadPermissions (com_content) (3.88KB) (24μs)
  • After Access::preloadPermissions (com_content) (129.77KB) (841μs)
  • Before Access::getAssetRules (id:333 name:com_content.article.220) (10.8KB) (28μs)
  • After Access::getAssetRules (id:333 name:com_content.article.220) (27.73KB) (478μs)
  • afterRenderComponent com_content (13.42MB) (1.46s)
  • afterDispatch (92.56KB) (13.51ms)
  • beforeRenderRawModule mod_menu () (389.78KB) (30.26ms)
  • afterRenderRawModule mod_menu () (166.23KB) (5.46ms)
  • beforeRenderModule mod_menu () (696B) (10μs)
  • afterRenderModule mod_menu () (4.21KB) (326μs)
  • beforeRenderRawModule mod_finder () (2.39KB) (24μs)
  • afterRenderRawModule mod_finder () (1.85MB) (25.28ms)
  • beforeRenderModule mod_finder () (704B) (16μs)
  • afterRenderModule mod_finder () (3.27KB) (465μs)
  • beforeRenderRawModule mod_custom () (2.68KB) (1.07ms)
  • afterRenderRawModule mod_custom () (38.3KB) (2.56ms)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (1.23KB) (204μs)
  • beforeRenderRawModule mod_finder () (3.96KB) (1.57ms)
  • afterRenderRawModule mod_finder () (6.2KB) (3.11ms)
  • beforeRenderModule mod_finder () (704B) (8μs)
  • afterRenderModule mod_finder () (1.23KB) (209μs)
  • beforeRenderRawModule mod_menu () (736B) (25μs)
  • afterRenderRawModule mod_menu () (35.34KB) (3.35ms)
  • beforeRenderModule mod_menu () (696B) (10μs)
  • afterRenderModule mod_menu () (1.23KB) (241μs)
  • beforeRenderRawModule mod_yootheme_builder (Mobile Dialog) (560B) (35μs)
  • afterRenderRawModule mod_yootheme_builder (Mobile Dialog) (27.42KB) (24.54ms)
  • beforeRenderModule mod_yootheme_builder (Mobile Dialog) (720B) (13μs)
  • afterRenderModule mod_yootheme_builder (Mobile Dialog) (1.25KB) (304μs)
  • beforeRenderRawModule mod_custom () (13.24KB) (1.68ms)
  • afterRenderRawModule mod_custom () (944B) (574μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (2.59KB) (220μs)
  • beforeRenderRawModule mod_custom () (64.36KB) (906μs)
  • afterRenderRawModule mod_custom () (896B) (364μs)
  • beforeRenderModule mod_custom () (704B) (8μs)
  • afterRenderModule mod_custom () (2.52KB) (233μs)
  • afterRender (414.78KB) (9.93ms)
  • 1 x afterRenderComponent com_content (13.42MB) (79.59%)
    1.46s
    1 x afterInitialise (11.41MB) (8.51%)
    155.73ms
    1 x afterRoute (2.19MB) (2.4%)
    43.83ms
    1 x afterLoad (4.08MB) (2.12%)
    38.71ms
    1 x beforeRenderRawModule mod_menu () (389.78KB) (1.65%)
    30.26ms
    1 x afterRenderRawModule mod_finder () (1.85MB) (1.38%)
    25.28ms
    1 x afterRenderRawModule mod_yootheme_builder (Mobile Dialog) (27.42KB) (1.34%)
    24.54ms
    1 x afterDispatch (92.56KB) (0.74%)
    13.51ms
    1 x afterRender (414.78KB) (0.54%)
    9.93ms
    1 x afterRenderRawModule mod_menu () (166.23KB) (0.3%)
    5.46ms
    1 x Before Access::preloadComponents (all components) (461.38KB) (0.29%)
    5.39ms
    1 x afterRenderRawModule mod_menu () (35.34KB) (0.18%)
    3.35ms
    1 x afterRenderRawModule mod_finder () (6.2KB) (0.17%)
    3.11ms
    1 x afterRenderRawModule mod_custom () (38.3KB) (0.14%)
    2.56ms
    1 x beforeRenderRawModule mod_custom () (13.24KB) (0.09%)
    1.68ms
    1 x beforeRenderRawModule mod_finder () (3.96KB) (0.09%)
    1.57ms
    1 x beforeRenderRawModule mod_custom () (2.68KB) (0.06%)
    1.07ms
    1 x After Access::preloadComponents (all components) (126.34KB) (0.05%)
    915μs
    1 x beforeRenderRawModule mod_custom () (64.36KB) (0.05%)
    906μs
    1 x After Access::preloadPermissions (com_content) (129.77KB) (0.05%)
    841μs
    1 x beforeRenderComponent com_content (24.64KB) (0.05%)
    827μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    574μs
    1 x After Access::getAssetRules (id:333 name:com_content.article.220) (27.73KB) (0.03%)
    478μs
    1 x afterRenderModule mod_finder () (3.27KB) (0.03%)
    465μs
    1 x afterRenderRawModule mod_custom () (896B) (0.02%)
    364μs
    1 x afterRenderModule mod_menu () (4.21KB) (0.02%)
    326μs
    1 x afterRenderModule mod_yootheme_builder (Mobile Dialog) (1.25KB) (0.02%)
    304μs
    1 x afterRenderModule mod_menu () (1.23KB) (0.01%)
    241μs
    1 x afterRenderModule mod_custom () (2.52KB) (0.01%)
    233μs
    1 x afterRenderModule mod_custom () (2.59KB) (0.01%)
    220μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.01%)
    209μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    204μs
    1 x beforeRenderRawModule mod_yootheme_builder (Mobile Dialog) (560B) (0%)
    35μs
    1 x Before Access::getAssetRules (id:333 name:com_content.article.220) (10.8KB) (0%)
    28μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    27μs
    1 x beforeRenderRawModule mod_menu () (736B) (0%)
    25μs
    1 x beforeRenderRawModule mod_finder () (2.39KB) (0%)
    24μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (3.88KB) (0%)
    24μs
    2 x beforeRenderModule mod_menu () (696B) (0%)
    20μs
    1 x beforeRenderModule mod_yootheme_builder (Mobile Dialog) (720B) (0%)
    13μs
38 statements were executed, 5 of which were duplicates, 33 unique168ms325.34KB
  • SELECT @@SESSION.sql_mode;318μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `pde83_session` WHERE `session_id` = ?394μs1.68KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `pde83_session` WHERE `session_id` = :session_id LIMIT 1231μs1.9KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `pde83_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (:session_id, :guest, :time, :user_id, :username)345μs912BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `pde83_viewlevels`103μs17.63KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `pde83_usergroups` AS `a` LEFT JOIN `pde83_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest112μs1.68KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `pde83_admintools_storage` WHERE `key` = 'cparams'106μs912B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `pde83_admintools_wafexceptions`89μs3.36KB/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `pde83_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'108μs2.14KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yooessentials' AND folder = 'system'124μs2.64KB/plugins/system/yooessentials/helper.php:152Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `pde83_categories` AS `s` INNER JOIN `pde83_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`3.29ms7.09KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `pde83_content` WHERE `alias` = :alias AND `catid` = :catid1.92ms1.7KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 190μs2.64KB/plugins/system/yooessentials/modules/core-joomla/src/Database.php:54Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `pde83_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40)208μs23.22KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `pde83_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0125μs18.22KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `pde83_content`982μs2.61KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `pde83_content` SET `hits` = (`hits` + 1) WHERE `id` = '220'552μs2.5KB/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `pde83_content` AS `a` INNER JOIN `pde83_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `pde83_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `pde83_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `pde83_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `pde83_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)5.5ms21.03KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `pde83_categories` AS `s` INNER JOIN `pde83_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`358μs7.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `pde83_contentitem_tag_map` AS `m` INNER JOIN `pde83_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)5.28ms7.58KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `pde83_categories` AS `s` INNER JOIN `pde83_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`208μs7.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM pde83_fields AS a LEFT JOIN `pde83_languages` AS l ON l.lang_code = a.language LEFT JOIN pde83_users AS uc ON uc.id=a.checked_out LEFT JOIN pde83_viewlevels AS ag ON ag.id = a.access LEFT JOIN pde83_users AS ua ON ua.id = a.created_user_id LEFT JOIN pde83_fields_groups AS g ON g.id = a.group_id LEFT JOIN `pde83_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC112ms8.42KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `pde83_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2) AND `item_id` = :itemid1.6ms1.88KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `pde83_content` AS `a` LEFT JOIN `pde83_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC13.66ms5.62KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `pde83_categories` AS `s` INNER JOIN `pde83_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`253μs7.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 19.18ms104.89KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT * FROM `pde83_content_types`4.11ms4.03KB/libraries/src/Helper/TagsHelper.php:807Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM pde83_fields AS a LEFT JOIN `pde83_languages` AS l ON l.lang_code = a.language LEFT JOIN pde83_users AS uc ON uc.id=a.checked_out LEFT JOIN pde83_viewlevels AS ag ON ag.id = a.access LEFT JOIN pde83_users AS ua ON ua.id = a.created_user_id LEFT JOIN pde83_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.3ms7.39KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM pde83_fields AS a LEFT JOIN `pde83_languages` AS l ON l.lang_code = a.language LEFT JOIN pde83_users AS uc ON uc.id=a.checked_out LEFT JOIN pde83_viewlevels AS ag ON ag.id = a.access LEFT JOIN pde83_users AS ua ON ua.id = a.created_user_id LEFT JOIN pde83_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.34ms7.76KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM pde83_fields AS a LEFT JOIN `pde83_languages` AS l ON l.lang_code = a.language LEFT JOIN pde83_users AS uc ON uc.id=a.checked_out LEFT JOIN pde83_viewlevels AS ag ON ag.id = a.access LEFT JOIN pde83_users AS ua ON ua.id = a.created_user_id LEFT JOIN pde83_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.37ms7.39KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM pde83_fields AS a LEFT JOIN `pde83_languages` AS l ON l.lang_code = a.language LEFT JOIN pde83_users AS uc ON uc.id=a.checked_out LEFT JOIN pde83_viewlevels AS ag ON ag.id = a.access LEFT JOIN pde83_users AS ua ON ua.id = a.created_user_id LEFT JOIN pde83_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.15ms7.39KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name`,`element` FROM `pde83_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 195μs1.63KB/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `pde83_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)456μs12.63KB/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM pde83_fields AS a LEFT JOIN `pde83_languages` AS l ON l.lang_code = a.language LEFT JOIN pde83_users AS uc ON uc.id=a.checked_out LEFT JOIN pde83_viewlevels AS ag ON ag.id = a.access LEFT JOIN pde83_users AS ua ON ua.id = a.created_user_id LEFT JOIN pde83_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC270μs7.39KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `title` FROM `pde83_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)85μs1.63KB/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `pde83_scheduler_tasks` AS `a` WHERE `a`.`state` = 1194μs1.85KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `pde83_session` WHERE `session_id` = ?259μs1.9KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `pde83_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?447μs840BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy