Skip to main content

Introducing QuickSwap's Merkl Tree Integration: Seamless Liquidity Providing & Farming

January 10th 2024

Share on Social Platforms

Say goodbye to the old days of separately providing liquidity and farming. QuickSwap is all about innovation, and the DEX’s UI/UX has just gotten a massive upgrade for LPs.

QuickSwap has implemented its new Merkl tree integration, taking V3 LPing and farming to a whole new level on Polygon.

Easier process. Greater efficiency. Seamless experience.

Available for all supported ALM (Automated Liquidity Management) V3 farms on Polygon PoS.

Learn more about what it means for the DEX and community below.

Line Break Blog

1-Click LP & Farm

Merkl is a platform that lets LPs on concentrated liquidity pools receive flexible token rewards from projects that incentivise liquidity. Check them out at https://merkl.xyz/.

So far, QuickSwap has integrated Gamma, Steer Protocol, Ichi, and DeFiEdge V3 ALM farms, which are a more capital-efficient way to provide liquidity and farm, keeping a user’s liquidity in range, auto-compounding rewards, and much more.

With QuickSwap’s Merkl tree integration, users can LP and farm in 1 click instead of going through the previous 2–step process: providing liquidity to a token pair and then separately staking those LP tokens in a few to earn the additional farming rewards.

Now, once a user provides liquidity to a token pair on V3 that is supported by one of the 4 ALM farms (mentioned above), their liquidity position starts earning LP rewards in addition to the extra farming rewards. 

LP and farming made easy!

Line Break Blog

Mechanics

So how exactly does the Merkl tree integration work, and why is it so much more efficient?

Merkl’s system and technology has the ability to automatically read every user’s on-chain LP position. By doing so, it can evaluate which users have qualified to receive a piece of the farming rewards pie before distribution.

All emissions (LP and farm rewards) are pooled together through Merkl’s new farming method, also allowing the ALM providers to access additional token rewards and more seamlessly create custom strategies for supported tokens.

Not only does the Merkl tree integration for ALM farms benefit the community with an easier process but also improves the efficiency for rewards management and distribution for the DEX and ALM farms.

A win-win!

Line Break Blog

ALMs (Automated Liquidity Managers)

Below is a list of the currently supported ALMs where you can LP and farm using the new Merkl tree integration:

Gamma

A protocol for active liquidity management and market making strategies. They manage liquidity of leading DeFi and Web3 protocols using tailor-made strategies, which aim to maximise capital efficiency, reduce the cost of emissions, or maintain consistent in-range liquidity with low price impact.

DeFiEdge

DefiEdge is the most innovative solution to deploy liquidity and optimise yields on concentrated DEXs. They create a non-custodial, permissionless layer over concentrated liquidity AMMs, enabling seamless liquidity deployment with efficient management tools.

In-built limit orders and support for multiple ranges (up to 20) expand the management capabilities of strategy managers so that they may use their entire repertoire of market understanding to manage liquidity.

They also provide an easy interface for liquidity providers and strategy managers to monitor their token positions in real time from their intuitive UI. Built-in liquidity mining rewards and automatic integration with Merkl protocols make incentivising liquidity on selected pools quick and easy.

Steer Protocol

Steer Protocol distinguishes itself through its innovative off-chain compute protocol, seamlessly integrating off-chain and on-chain data to propel its advanced liquidity automation. It excels in managing over 780 liquidity strategies and supports more than 250+ assets, offering LPs superior fees with some of the highest APRs in the industry. 

A distinctive feature of Steer Protocol is the ability for users to quickly create Smart Pools permissionlessly. This capability is coupled with access to the largest library of data-driven algorithmic LP strategies and a customizable SDK for strategy development. Additionally, Steer Protocol is the only platform offering strategists a share of generated fees from pools using their strategies. 

With its ability to support a vast range of assets across 17 chains and over 90% of concentrated liquidity AMMs, Steer Protocol is a leader in providing adaptable, efficient, and secure liquidity solutions. For further details, visit https://steer.finance

ICHI

ICHI's Yield IQ vault technology introduces efficient and profitable liquidity provision on QuickSwap, operating on the principle of dynamic liquidity management. 

ICHI's algorithm ensures optimal token concentration, mitigating risks and offering LPs protection from significant losses during market fluctuations. This is all single-sided, so users only need to deposit one side of the pair to earn more of their favorite token. 

Line Break Blog

How Can I Get Started?

Getting started is easy - make sure to follow the steps below to LP, farm, and earn rewards on QuickSwap!

1. Go to https://quickswap.exchange/#/pools and connect your Web3 wallet - make sure the network is switched to Polygon PoS (Proof of Stake)

2. Supply liquidity by selecting two tokens from the dropdown menu and choose your desired range. To see which LP token pairs are eligible for farms, you can check https://quickswap.exchange/#/farm

Untitled

To be eligible to earn farming rewards from a supported ALM farm (in addition to LP rewards), the different ALM strategies will appear with the range options (narrow/wide) and total APR displayed. Choose the one you want and finish depositing the token pair.

wmatic usdt 2

WMATIC USDT 3

 

3. You’re all set! You’ll immediately begin earning LP and farming rewards on your liquidity position. Go to the “My Pools” section on the top right of the Pools tab to check your portfolio.

You can also go back to the "Farms" tab and view all of the different ALM strategies and rewards for each eligible token pair.

wmatic usdt

 

Happy LPing and farming, dragons!

Line Break Blog

Unstake from Old/Legacy Farms

If you're still staking your LP tokens/farming in the old pools and want to use your liquidity to LP with the new Merkl integration, you'll want to unstake your liquidity to do so.

Head over to https://quickswap.exchange/#/pools/, find your token pair, and unstake.

If you're still providing liquiity to legacy pools (around 2021 or before), go to https://legacy.quickswap.exchange/#/archive, connect your wallet to the Polygon network, and simply unstake your LP from the pool under the "Old Pools" section.

Once you're all set, follow the tutorial above to LP with the new Merkl tree integration!

36.01MBMemory Usage647msRequest 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" => 1744730430 "last" => 1744730430...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.08MB) (29.91ms)
  • afterInitialise (11.41MB) (143ms)
  • afterRoute (2.22MB) (64.48ms)
  • beforeRenderComponent com_content (24.64KB) (754μs)
  • Before Access::preloadComponents (all components) (461.38KB) (4.69ms)
  • After Access::preloadComponents (all components) (126.34KB) (9.81ms)
  • Before Access::preloadPermissions (com_content) (3.88KB) (26μs)
  • After Access::preloadPermissions (com_content) (130.73KB) (849μs)
  • Before Access::getAssetRules (id:289 name:com_content.article.179) (10.8KB) (27μs)
  • After Access::getAssetRules (id:289 name:com_content.article.179) (27.73KB) (429μs)
  • afterRenderComponent com_content (13.45MB) (265ms)
  • afterDispatch (92.56KB) (17.18ms)
  • beforeRenderRawModule mod_menu () (389.61KB) (36.42ms)
  • afterRenderRawModule mod_menu () (166.23KB) (8.39ms)
  • beforeRenderModule mod_menu () (696B) (19μs)
  • afterRenderModule mod_menu () (4.21KB) (526μs)
  • beforeRenderRawModule mod_finder () (2.39KB) (45μs)
  • afterRenderRawModule mod_finder () (1.85MB) (23.81ms)
  • beforeRenderModule mod_finder () (704B) (18μs)
  • afterRenderModule mod_finder () (3.27KB) (439μs)
  • beforeRenderRawModule mod_custom () (2.68KB) (1.47ms)
  • afterRenderRawModule mod_custom () (38.3KB) (3.08ms)
  • beforeRenderModule mod_custom () (704B) (15μs)
  • afterRenderModule mod_custom () (1.23KB) (317μs)
  • beforeRenderRawModule mod_finder () (3.79KB) (2.47ms)
  • afterRenderRawModule mod_finder () (6.2KB) (2.72ms)
  • beforeRenderModule mod_finder () (704B) (13μs)
  • afterRenderModule mod_finder () (1.23KB) (355μs)
  • beforeRenderRawModule mod_menu () (736B) (42μs)
  • afterRenderRawModule mod_menu () (35.34KB) (4.67ms)
  • beforeRenderModule mod_menu () (696B) (12μs)
  • afterRenderModule mod_menu () (1.23KB) (298μs)
  • beforeRenderRawModule mod_yootheme_builder (Mobile Dialog) (560B) (35μs)
  • afterRenderRawModule mod_yootheme_builder (Mobile Dialog) (91.42KB) (10.78ms)
  • beforeRenderModule mod_yootheme_builder (Mobile Dialog) (720B) (12μs)
  • afterRenderModule mod_yootheme_builder (Mobile Dialog) (1.25KB) (283μs)
  • beforeRenderRawModule mod_custom () (13.24KB) (1.37ms)
  • afterRenderRawModule mod_custom () (944B) (444μs)
  • beforeRenderModule mod_custom () (704B) (10μs)
  • afterRenderModule mod_custom () (2.59KB) (236μs)
  • beforeRenderRawModule mod_custom () (368B) (903μs)
  • afterRenderRawModule mod_custom () (896B) (367μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (2.52KB) (235μs)
  • afterRender (422.58KB) (10.24ms)
  • 1 x afterRenderComponent com_content (13.45MB) (41.02%)
    265.32ms
    1 x afterInitialise (11.41MB) (22.08%)
    142.82ms
    1 x afterRoute (2.22MB) (9.97%)
    64.48ms
    1 x beforeRenderRawModule mod_menu () (389.61KB) (5.63%)
    36.42ms
    1 x afterLoad (4.08MB) (4.62%)
    29.91ms
    1 x afterRenderRawModule mod_finder () (1.85MB) (3.68%)
    23.81ms
    1 x afterDispatch (92.56KB) (2.66%)
    17.18ms
    1 x afterRenderRawModule mod_yootheme_builder (Mobile Dialog) (91.42KB) (1.67%)
    10.78ms
    1 x afterRender (422.58KB) (1.58%)
    10.24ms
    1 x After Access::preloadComponents (all components) (126.34KB) (1.52%)
    9.81ms
    1 x afterRenderRawModule mod_menu () (166.23KB) (1.3%)
    8.39ms
    1 x Before Access::preloadComponents (all components) (461.38KB) (0.73%)
    4.69ms
    1 x afterRenderRawModule mod_menu () (35.34KB) (0.72%)
    4.67ms
    1 x afterRenderRawModule mod_custom () (38.3KB) (0.48%)
    3.08ms
    1 x afterRenderRawModule mod_finder () (6.2KB) (0.42%)
    2.72ms
    1 x beforeRenderRawModule mod_finder () (3.79KB) (0.38%)
    2.47ms
    1 x beforeRenderRawModule mod_custom () (2.68KB) (0.23%)
    1.47ms
    1 x beforeRenderRawModule mod_custom () (13.24KB) (0.21%)
    1.37ms
    1 x beforeRenderRawModule mod_custom () (368B) (0.14%)
    903μs
    1 x After Access::preloadPermissions (com_content) (130.73KB) (0.13%)
    849μs
    1 x beforeRenderComponent com_content (24.64KB) (0.12%)
    754μs
    1 x afterRenderModule mod_menu () (4.21KB) (0.08%)
    526μs
    1 x afterRenderRawModule mod_custom () (944B) (0.07%)
    444μs
    1 x afterRenderModule mod_finder () (3.27KB) (0.07%)
    439μs
    1 x After Access::getAssetRules (id:289 name:com_content.article.179) (27.73KB) (0.07%)
    429μs
    1 x afterRenderRawModule mod_custom () (896B) (0.06%)
    367μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.05%)
    355μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.05%)
    317μs
    1 x afterRenderModule mod_menu () (1.23KB) (0.05%)
    298μs
    1 x afterRenderModule mod_yootheme_builder (Mobile Dialog) (1.25KB) (0.04%)
    283μs
    1 x afterRenderModule mod_custom () (2.59KB) (0.04%)
    236μs
    1 x afterRenderModule mod_custom () (2.52KB) (0.04%)
    235μs
    1 x beforeRenderRawModule mod_finder () (2.39KB) (0.01%)
    45μs
    1 x beforeRenderRawModule mod_menu () (736B) (0.01%)
    42μs
    1 x beforeRenderRawModule mod_yootheme_builder (Mobile Dialog) (560B) (0.01%)
    35μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    34μs
    2 x beforeRenderModule mod_menu () (696B) (0%)
    31μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    31μs
    1 x Before Access::getAssetRules (id:289 name:com_content.article.179) (10.8KB) (0%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (3.88KB) (0%)
    26μs
    1 x beforeRenderModule mod_yootheme_builder (Mobile Dialog) (720B) (0%)
    12μs
38 statements were executed, 5 of which were duplicates, 33 unique18.62ms329.49KB
  • SELECT @@SESSION.sql_mode;106μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `pde83_session` WHERE `session_id` = ?771μs1.68KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `pde83_session` WHERE `session_id` = :session_id LIMIT 1166μ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)265μs912BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `pde83_viewlevels`75μ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` = :guest685μs1.68KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `pde83_admintools_storage` WHERE `key` = 'cparams'91μs912B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `pde83_admintools_wafexceptions`688μs3.36KB/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `pde83_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'64μs2.14KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yooessentials' AND folder = 'system'3.9ms2.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`159μs7.09KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `pde83_content` WHERE `alias` = :alias AND `catid` = :catid296μs1.7KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 181μ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)3.49ms23.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` = 0134μs18.22KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `pde83_content`985μs2.61KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `pde83_content` SET `hits` = (`hits` + 1) WHERE `id` = '179'922μ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)610μs25.19KBParams/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`167μ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)440μs7.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`144μ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 ASC157μs8.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` = :itemid265μs1.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 DESC1.57ms5.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`135μs7.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1200μs104.89KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT * FROM `pde83_content_types`112μs4.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 ASC174μs7.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 ASC148μs7.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 ASC166μs7.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 ASC159μs7.39KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name`,`element` FROM `pde83_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1115μ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)104μ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 ASC282μ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)105μ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` = 1109μs1.85KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `pde83_session` WHERE `session_id` = ?271μs1.9KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `pde83_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?319μs840BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy