Skip to main content

Is the Chinese New Year Influencing the Cryptocurrency Market?

February 2nd 2022

Share on Social Platforms

Coincidence or not, every Chinese New Year, the price of crypto, and especially Bitcoin, has gone on a downward trend. This trend is known as the “Chinese New Year Dump”, and some have issued theories about this being a multi-year Bitcoin crash pattern.

Regardless of your predictions and personal theories, the proof is in the pudding. So let’s dig it out.

2022-02-02_Is-the-Chinese-New-Year-Influencing-the-Cryptocurrency-Market--af86576350b0

The Chinese New Year Dump

If you’ve been paying attention to financial markets in the last few years, you’ve probably heard of the “Santa Claus rally,” when stock markets rise in December. Similarly, some have observed that bitcoin’s price seems to be affected by the Chinese New Year. While it looks like an abnormality at first, it can make sense if we look a bit more into these market trends.

Every new year is marked by a steady pattern of a decline in BTC prices. This continues through the Chinese New Year, which falls at the end of January or beginning of February. The downward trend is typically followed with a slight recovery after the holiday concludes.

At the same time, there are spikes in the Chinese Yuan and bitcoin trading volumes, which means that despite the unfavourable Chinese regulations, there are many crypto investors in China.

2022-02-02_Is-the-Chinese-New-Year-Influencing-the-Cryptocurrency-Market--af86576350b0

Chinese New Year & the Hongbao Tradition

The Chinese New Year’s date changes each year according to the Lunar Calendar. This is different from the Gregorian Calendar that most countries use. While each Chinese New Year has different dates and a different symbol, it usually takes place between January 21st and February 20th, when the new moon occurs.

For instance, in 2022, the Chinese New Year started on February 1st. The start of the Chinese New Year is marked by huge celebrations all over the world, in the major Chinese communities. But over the past few years, some have started to issue theories about how the Chinese New Year influences bitcoin’s price. One particular Chinese tradition can be connected to BTC’s price.

One of the essential traditions of the Chinese New Year is the Hongbao tradition (translated as “red package”), which are basically small red envelopes. Chinese people give these cash-containing red envelopes to their loved ones. These red packages, which are intended to symbolise luck and prosperity, are the one time a year in China that cash gifts are acceptable.

Tradition dictates that married couples should distribute red packages to unmarried young adults, the elderly, and service personnel. Managers and executives of companies should give money to their employees. Some packets can be as high as the monthly wage.

Since most people still stick to the Hongbao tradition, it is possible that it can trigger a noticeable cryptocurrency sell-off, as Chinese crypto investors might sell some of their crypto funds to pay for their Hongbao packages. This could cause bitcoin’s prices to fall as does the asset’s exchange volume.

2022-02-02_Is-the-Chinese-New-Year-Influencing-the-Cryptocurrency-Market--af86576350b0

Examining China’s Crypto Sell-off

Since most people start to prepare for the Chinese New Year a few weeks in advance, that’s when bitcoin prices almost always fall. But is there really a Chinese New Year dump? You be the judge of that.

In 2017, BTC’s price dropped 30% from $1,130 down to $784 just before the festival.

In 2018, bitcoin’s price dumped from more than $18,000 on January 6 to reach $6,800 by February 6.

In 2019, bitcoin’s prices fell from $3,491 just before the Chinese New Year to $3,397 during the holiday.

In 2020, prices dropped again before the Chinese New Year, breaking the initial resistance of $8,300. It then plummeted below $8,300 the next day. The prices stagnated on the 2nd day of the Chinese New Year holiday, as prices only began to rise on the final day.

The tides turned in 2021 with a steady increase from $32,000 to $39,000 during the first week in February and a massive 2-day rally to $48,000 the days before the festival. However, prices began to retrace to $46,200 following the Chinese New Year dip trend. This, however, did not wipe out the pre-Chinese New Year rally.

2022-02-02_Is-the-Chinese-New-Year-Influencing-the-Cryptocurrency-Market--af86576350b0

Chinese New Year & Bitcoin’s Trading Volume

The Chinese crypto inventors tend to prefer Binance and Huobi as their personal choice for centralised exchanges. In the past few years, these exchanges show lower trading volumes during the Chinese New Year holiday celebrations. In fact, trading volumes tend to decrease during other Chinese national holidays, such as the Golden Week that happened in October, as well.

At the same time, it’s important to note that the crypto market accommodates trading bots. Actually, a huge chunk of the market volume comes from these trading bots. While most do not know this, most Chinese and other Asian countries shut down most of their operations during national holidays, which leads to a decline in trading volume that can be visible on major CeFi exchanges.

Although trading bots and algorithms are automated, humans must still monitor the daily operations to ensure there are no errors.

Another consequence of the China-wide close-downs is a more volatile and less liquid cryptocurrency market.

2022-02-02_Is-the-Chinese-New-Year-Influencing-the-Cryptocurrency-Market--af86576350b0

Did the Chinese New Year dump happen in 2022?

This year, the situation could be slightly different because China’s impact on the crypto market has been greatly reduced with China’s latest ban on cryptocurrency mining. While bitcoin’s price did decrease in the weeks leading up to the holiday, bitcoin (along with most of the cryptocurrency market) has been on a steady decline since early November, which might mean that this dump is not related to the holiday festivities in the world’s second largest economy.

As we said before, you can be the judge of that. Yesterday, February 1st, was the first day of the Chinese New Year. At the time of writing, bitcoin’s price was down 43% from its November 2021 all time high of $68,789.63; it was down 18.9% from one month prior, and down 11.35% in the last two weeks, from $42,466.39 on January 18th to $37,712.66 on February 2nd.

Again though, this recent dump may be unrelated to the Chinese New Year. Huobi, Asia’s biggest exchange, has stopped retail trading in China. Bitcoin has been moving from Asia to Europe and the US for some time. The final effect of the Chinese cryptocurrency ban is now underway. Huobi’s share in the global open interest has dropped to 2% after gradually eliminating Chinese mainland users. This is a decrease from 20% at its peak on February 20, 2020. Naturally, China’s crypto mining dropped dramatically after the September 2021 ban.

While China was once the center of bitcoin mining, with a hash rate of over 65%, China’s aggressive actions against all crypto mining activities resulted in many miners leaving the country or closing down their operations. The good news is that a lot of the mining equipment has been shipped overseas, especially to the US. Over $400 million worth of mining equipment was shipped from China to America. China’s influence over bitcoin may soon become negligible.

2022-02-02_Is-the-Chinese-New-Year-Influencing-the-Cryptocurrency-Market--af86576350b0

Looking Forward…

Some might say we are currently experiencing a bearish market, as crypto prices have plummeted since December 2021. The mass sell-offs that started in early November 2021 have caused retail investors worldwide to panic sell and put off potential new investors.

We hope that there will be fewer dips associated with the Chinese national holidays in the future. For now, we must wait and see if cryptocurrency prices recover after the holidays end.

While nobody can predict the future, we know you all love to issue theories for the past trends of the market. Ready to make your own calculations about the last Chinese New Year dumps?

Here are the exact dates of recent Chinese New Years:

  • 2016: February 8 to February 10
  • 2017: January 28 to January 30
  • 2018: February 16 to February 18
  • 2019: February 5 to February 7
  • 2020: January 25 to January 27
  • 2021: February 12 to February 14
  • 2022: February 1st to February 3rd

2022-02-02_Is-the-Chinese-New-Year-Influencing-the-Cryptocurrency-Market--af86576350b0

Let us know if you think that the Chinese New Year is affecting the cryptocurrency market. Don’t forget to follow us on social media, and join us across social media to stay up-to-date on all things QuickSwap — Polygon’s most-established DEX.

Twitter | Telegram | Announcements | Medium | Discord | Reddit

By QuickSwap Official on February 2, 2022.

Canonical link

Exported from Medium on May 2, 2023.

36.032MBMemory Usage1.47sRequest Duration
Joomla! Version4.4.9
PHP Version8.1.31
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" => 1743429797 "last" => 1743429797...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.08MB) (35.02ms)
  • afterInitialise (11.4MB) (162ms)
  • afterRoute (2.19MB) (64.44ms)
  • beforeRenderComponent com_content (24.64KB) (673μs)
  • Before Access::preloadComponents (all components) (461.38KB) (4.93ms)
  • After Access::preloadComponents (all components) (126.34KB) (663μs)
  • Before Access::preloadPermissions (com_content) (3.88KB) (22μs)
  • After Access::preloadPermissions (com_content) (129.77KB) (685μs)
  • Before Access::getAssetRules (id:177 name:com_content.article.74) (10.8KB) (25μs)
  • After Access::getAssetRules (id:177 name:com_content.article.74) (27.73KB) (443μs)
  • afterRenderComponent com_content (13.33MB) (1.09s)
  • afterDispatch (156.56KB) (9.94ms)
  • beforeRenderRawModule mod_menu () (409.78KB) (24.48ms)
  • afterRenderRawModule mod_menu () (101.91KB) (5.07ms)
  • beforeRenderModule mod_menu () (696B) (10μs)
  • afterRenderModule mod_menu () (4.21KB) (299μs)
  • beforeRenderRawModule mod_finder () (2.39KB) (25μs)
  • afterRenderRawModule mod_finder () (1.91MB) (15.93ms)
  • beforeRenderModule mod_finder () (704B) (10μs)
  • afterRenderModule mod_finder () (3.27KB) (280μs)
  • beforeRenderRawModule mod_custom () (2.68KB) (922μs)
  • afterRenderRawModule mod_custom () (56.29KB) (2.33ms)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (1.23KB) (210μs)
  • beforeRenderRawModule mod_finder () (3.96KB) (1.46ms)
  • afterRenderRawModule mod_finder () (6.2KB) (1.31ms)
  • beforeRenderModule mod_finder () (704B) (7μs)
  • afterRenderModule mod_finder () (1.23KB) (222μs)
  • beforeRenderRawModule mod_menu () (736B) (25μs)
  • afterRenderRawModule mod_menu () (35.34KB) (2.93ms)
  • beforeRenderModule mod_menu () (696B) (8μs)
  • afterRenderModule mod_menu () (1.23KB) (196μs)
  • beforeRenderRawModule mod_yootheme_builder (Mobile Dialog) (560B) (24μs)
  • afterRenderRawModule mod_yootheme_builder (Mobile Dialog) (27.42KB) (34.17ms)
  • beforeRenderModule mod_yootheme_builder (Mobile Dialog) (720B) (11μs)
  • afterRenderModule mod_yootheme_builder (Mobile Dialog) (1.25KB) (253μs)
  • beforeRenderRawModule mod_custom () (13.24KB) (1.59ms)
  • afterRenderRawModule mod_custom () (944B) (450μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (2.59KB) (240μs)
  • beforeRenderRawModule mod_custom () (368B) (879μs)
  • afterRenderRawModule mod_custom () (896B) (393μs)
  • beforeRenderModule mod_custom () (704B) (9μs)
  • afterRenderModule mod_custom () (2.52KB) (228μs)
  • afterRender (486.78KB) (9.1ms)
  • 1 x afterRenderComponent com_content (13.33MB) (74.02%)
    1.09s
    1 x afterInitialise (11.4MB) (11%)
    161.86ms
    1 x afterRoute (2.19MB) (4.38%)
    64.44ms
    1 x afterLoad (4.08MB) (2.38%)
    35.02ms
    1 x afterRenderRawModule mod_yootheme_builder (Mobile Dialog) (27.42KB) (2.32%)
    34.17ms
    1 x beforeRenderRawModule mod_menu () (409.78KB) (1.66%)
    24.48ms
    1 x afterRenderRawModule mod_finder () (1.91MB) (1.08%)
    15.93ms
    1 x afterDispatch (156.56KB) (0.68%)
    9.94ms
    1 x afterRender (486.78KB) (0.62%)
    9.10ms
    1 x afterRenderRawModule mod_menu () (101.91KB) (0.34%)
    5.07ms
    1 x Before Access::preloadComponents (all components) (461.38KB) (0.33%)
    4.93ms
    1 x afterRenderRawModule mod_menu () (35.34KB) (0.2%)
    2.93ms
    1 x afterRenderRawModule mod_custom () (56.29KB) (0.16%)
    2.33ms
    1 x beforeRenderRawModule mod_custom () (13.24KB) (0.11%)
    1.59ms
    1 x beforeRenderRawModule mod_finder () (3.96KB) (0.1%)
    1.46ms
    1 x afterRenderRawModule mod_finder () (6.2KB) (0.09%)
    1.31ms
    1 x beforeRenderRawModule mod_custom () (2.68KB) (0.06%)
    922μs
    1 x beforeRenderRawModule mod_custom () (368B) (0.06%)
    879μs
    1 x After Access::preloadPermissions (com_content) (129.77KB) (0.05%)
    685μs
    1 x beforeRenderComponent com_content (24.64KB) (0.05%)
    673μs
    1 x After Access::preloadComponents (all components) (126.34KB) (0.05%)
    663μs
    1 x afterRenderRawModule mod_custom () (944B) (0.03%)
    450μs
    1 x After Access::getAssetRules (id:177 name:com_content.article.74) (27.73KB) (0.03%)
    443μs
    1 x afterRenderRawModule mod_custom () (896B) (0.03%)
    393μs
    1 x afterRenderModule mod_menu () (4.21KB) (0.02%)
    299μs
    1 x afterRenderModule mod_finder () (3.27KB) (0.02%)
    280μs
    1 x afterRenderModule mod_yootheme_builder (Mobile Dialog) (1.25KB) (0.02%)
    253μs
    1 x afterRenderModule mod_custom () (2.59KB) (0.02%)
    240μs
    1 x afterRenderModule mod_custom () (2.52KB) (0.02%)
    228μs
    1 x afterRenderModule mod_finder () (1.23KB) (0.02%)
    222μs
    1 x afterRenderModule mod_custom () (1.23KB) (0.01%)
    210μs
    1 x afterRenderModule mod_menu () (1.23KB) (0.01%)
    196μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    27μs
    1 x Before Access::getAssetRules (id:177 name:com_content.article.74) (10.8KB) (0%)
    25μs
    1 x beforeRenderRawModule mod_finder () (2.39KB) (0%)
    25μs
    1 x beforeRenderRawModule mod_menu () (736B) (0%)
    25μs
    1 x beforeRenderRawModule mod_yootheme_builder (Mobile Dialog) (560B) (0%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (3.88KB) (0%)
    22μs
    2 x beforeRenderModule mod_menu () (696B) (0%)
    18μs
    2 x beforeRenderModule mod_finder () (704B) (0%)
    17μs
    1 x beforeRenderModule mod_yootheme_builder (Mobile Dialog) (720B) (0%)
    11μs
38 statements were executed, 5 of which were duplicates, 33 unique62.44ms329.47KB
  • SELECT @@SESSION.sql_mode;150μs1.95KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `pde83_session` WHERE `session_id` = ?703μs1.68KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `pde83_session` WHERE `session_id` = :session_id LIMIT 1137μ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)789μs912BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `pde83_viewlevels`160μ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` = :guest262μs1.68KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `pde83_admintools_storage` WHERE `key` = 'cparams'88μs912B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `pde83_admintools_wafexceptions`82μs3.36KB/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `pde83_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'93μs2.14KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yooessentials' AND folder = 'system'79μ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`2.7ms7.09KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `pde83_content` WHERE `alias` = :alias AND `catid` = :catid1.68ms1.7KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 183μ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)156μ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` = 0118μs18.22KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `pde83_content`748μs2.61KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `pde83_content` SET `hits` = (`hits` + 1) WHERE `id` = '74'2.24ms2.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)3.92ms25.16KBParams/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`250μ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)4.52ms7.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`160μ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 ASC6.34ms8.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.64ms1.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 DESC10.86ms5.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`226μs7.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT custom_data FROM pde83_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 112.58ms104.89KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT * FROM `pde83_content_types`1.95ms4.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.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 ASC2.43ms7.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.04ms7.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.01ms7.39KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `name`,`element` FROM `pde83_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 179μ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)70μ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 ASC166μ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)67μ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` = 1283μs1.85KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `pde83_session` WHERE `session_id` = ?2.14ms1.9KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `pde83_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.06ms840BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy