Lag of 5600 ms in category view

[Folamour]

hi folks, we achevied incredible result on optimistion, but i've got a lag of 5600 ms on the first html document on category view, i'll tried to sort out, and googled a bit, but no luck,

does any one can have an idea ? (putted off jspeed and so on but no improvment)

https://ibb.co/2jLT64d

all the best,

f.

[SharkyKZ]

Does this happen randomly or on every request? Enable debug and post profiling information.

[Folamour]

there is no error on gtmetrix or web page speed test

https://ibb.co/0QN3gTq

that seem internal joomla,

instant preloading is disabled

hope you can help

[Folamour]

hi that happen on every request of category view as i saw, not inside the article view,

It's not very important but we have category view for navigation at the top of the page, and you know user, if they wait, they simply leave the site,

thanks,

i will debug and post,

keep you updated,

thanks,

f.

[Folamour]

profile :

afterLoad (569.63KB) (2.68ms)
afterInitialise (4.31MB) (41.94ms)
Before Access::preloadComponents (all components) (288.74KB) (2.64ms)
After Access::preloadComponents (all components) (141.02KB) (560μs)
Before Access::getAssetRules (id:1 name:root.1) (3.98KB) (25μs)
After Access::getAssetRules (id:1 name:root.1) (9.18KB) (72μs)
afterRoute (551.8KB) (9.35ms)
beforeRenderComponent com_content (35.14KB) (642μs)
Before Access::getAssetRules (id:1 name:root.1) (218.26KB) (2.14ms)
After Access::getAssetRules (id:1 name:root.1) (2.22KB) (12μs)
afterRenderComponent com_content (2.3MB) (5.45s)
afterDispatch (12.34KB) (1.8ms)
beforeRenderModule mod_articles_category (Derniers articles) (1.22MB) (13.56ms)
afterRenderRawModule mod_articles_category (Derniers articles) (109.57KB) (40.77ms)
beforeRenderModule mod_articles_category (Derniers articles) (736B) (16μs)
afterRenderModule mod_articles_category (Derniers articles) (2.24KB) (639μs)
beforeRenderModule mod_articles_category (Actualités Françaises) (10.44KB) (492μs)
afterRenderRawModule mod_articles_category (Actualités Françaises) (89.05KB) (16.37ms)
beforeRenderModule mod_articles_category (Actualités Françaises) (736B) (13μs)
afterRenderModule mod_articles_category (Actualités Françaises) (1.78KB) (341μs)
beforeRenderModule mod_acymailing (Inscription à la Crashletter quotidienne) (12.14KB) (190μs)
afterRenderRawModule mod_acymailing (Inscription à la Crashletter quotidienne) (622.75KB) (12.14ms)
beforeRenderModule mod_acymailing (Inscription à la Crashletter quotidienne) (752B) (11μs)
afterRenderModule mod_acymailing (Inscription à la Crashletter quotidienne) (1.8KB) (387μs)
beforeRenderModule mod_banners (Sites ami(e)s) (7.13KB) (186μs)
afterRenderRawModule mod_banners (Sites ami(e)s) (49.32KB) (5.37ms)
beforeRenderModule mod_banners (Sites ami(e)s) (720B) (16μs)
afterRenderModule mod_banners (Sites ami(e)s) (1.77KB) (420μs)
beforeRenderModule mod_banners (Banner top) (3.2KB) (213μs)
afterRenderRawModule mod_banners (Banner top) (34.66KB) (3.16ms)
beforeRenderModule mod_banners (Banner top) (720B) (9μs)
afterRenderModule mod_banners (Banner top) (1.73KB) (334μs)
beforeRenderModule mod_ja_acm (Suivez-nous !) (2.21KB) (284μs)
afterRenderRawModule mod_ja_acm (Suivez-nous !) (10.36KB) (1.69ms)
beforeRenderModule mod_ja_acm (Suivez-nous !) (720B) (9μs)
afterRenderModule mod_ja_acm (Suivez-nous !) (1.71KB) (350μs)
beforeRenderModule mod_menu (Topbar Menu) (2.59KB) (193μs)
afterRenderRawModule mod_menu (Topbar Menu) (7.18KB) (3.91ms)
beforeRenderModule mod_menu (Topbar Menu) (720B) (10μs)
afterRenderModule mod_menu (Topbar Menu) (1.73KB) (353μs)
beforeRenderModule mod_ja_acm (Time) (1.88KB) (86μs)
afterRenderRawModule mod_ja_acm (Time) (2.16KB) (502μs)
beforeRenderModule mod_ja_acm (Time) (704B) (6μs)
afterRenderModule mod_ja_acm (Time) (1.7KB) (387μs)
afterRender (1.53MB) (291ms)
1 x afterRenderComponent com_content (2.3MB) (92.15%)
5.45s
1 x afterRender (1.53MB) (4.92%)
290.69ms
1 x afterInitialise (4.31MB) (0.71%)
41.94ms
1 x afterRenderRawModule mod_articles_category (Derniers articles) (109.57KB) (0.69%)
40.77ms
1 x afterRenderRawModule mod_articles_category (Actualités Françaises) (89.05KB) (0.28%)
16.37ms
1 x beforeRenderModule mod_articles_category (Derniers articles) (1.22MB) (0.23%)
13.56ms
1 x afterRenderRawModule mod_acymailing (Inscription à la Crashletter quotidienne) (622.75KB) (0.21%)
12.14ms
1 x afterRoute (551.8KB) (0.16%)
9.35ms
1 x afterRenderRawModule mod_banners (Sites ami(e)s) (49.32KB) (0.09%)
5.37ms
1 x afterRenderRawModule mod_menu (Topbar Menu) (7.18KB) (0.07%)
3.91ms
1 x afterRenderRawModule mod_banners (Banner top) (34.66KB) (0.05%)
3.16ms
1 x afterLoad (569.63KB) (0.05%)
2.68ms
1 x Before Access::preloadComponents (all components) (288.74KB) (0.04%)
2.64ms
1 x Before Access::getAssetRules (id:1 name:root.1) (218.26KB) (0.04%)
2.14ms
1 x afterDispatch (12.34KB) (0.03%)
1.80ms
1 x afterRenderRawModule mod_ja_acm (Suivez-nous !) (10.36KB) (0.03%)
1.69ms
1 x beforeRenderComponent com_content (35.14KB) (0.01%)
642μs
1 x afterRenderModule mod_articles_category (Derniers articles) (2.24KB) (0.01%)
639μs
1 x After Access::preloadComponents (all components) (141.02KB) (0.01%)
560μs
1 x afterRenderRawModule mod_ja_acm (Time) (2.16KB) (0.01%)
502μs
1 x beforeRenderModule mod_articles_category (Actualités Françaises) (10.44KB) (0.01%)
492μs
1 x afterRenderModule mod_banners (Sites ami(e)s) (1.77KB) (0.01%)
420μs
1 x afterRenderModule mod_acymailing (Inscription à la Crashletter quotidienne) (1.8KB) (0.01%)
387μs
1 x afterRenderModule mod_ja_acm (Time) (1.7KB) (0.01%)
387μs
1 x afterRenderModule mod_menu (Topbar Menu) (1.73KB) (0.01%)
353μs
1 x afterRenderModule mod_ja_acm (Suivez-nous !) (1.71KB) (0.01%)
350μs
1 x afterRenderModule mod_articles_category (Actualités Françaises) (1.78KB) (0.01%)
341μs
1 x afterRenderModule mod_banners (Banner top) (1.73KB) (0.01%)
334μs
1 x beforeRenderModule mod_ja_acm (Suivez-nous !) (2.21KB) (0%)
284μs
1 x beforeRenderModule mod_banners (Banner top) (3.2KB) (0%)
213μs
1 x beforeRenderModule mod_menu (Topbar Menu) (2.59KB) (0%)
193μs
1 x beforeRenderModule mod_acymailing (Inscription à la Crashletter quotidienne) (12.14KB) (0%)
190μs
1 x beforeRenderModule mod_banners (Sites ami(e)s) (7.13KB) (0%)
186μs
1 x beforeRenderModule mod_ja_acm (Time) (1.88KB) (0%)
86μs
1 x After Access::getAssetRules (id:1 name:root.1) (9.18KB) (0%)
72μs
1 x Before Access::getAssetRules (id:1 name:root.1) (3.98KB) (0%)
25μs
1 x beforeRenderModule mod_articles_category (Derniers articles) (736B) (0%)
16μs
1 x beforeRenderModule mod_banners (Sites ami(e)s) (720B) (0%)
16μs
1 x beforeRenderModule mod_articles_category (Actualités Françaises) (736B) (0%)
13μs
1 x After Access::getAssetRules (id:1 name:root.1) (2.22KB) (0%)
12μs
1 x beforeRenderModule mod_acymailing (Inscription à la Crashletter quotidienne) (752B) (0%)
11μs
1 x beforeRenderModule mod_menu (Topbar Menu) (720B) (0%)
10μs
1 x beforeRenderModule mod_banners (Banner top) (720B) (0%)
9μs
1 x beforeRenderModule mod_ja_acm (Suivez-nous !) (720B) (0%)
9μs
1 x beforeRenderModule mod_ja_acm (Time) (704B) (0%)

[Folamour]

Queries :

112 statements were executed, 15 of which were duplicates, 97 unique142ms1.25MB
Uniques
Duplicates 1
Duplicates 2
Duplicates 3
Duplicates 4
Duplicates 5
Duplicates 6
Duplicates 7

SELECT @@SESSION.sql_mode;215μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
SELECT `data`
FROM `s8c9k_session`
WHERE `session_id` = ?201μs1.64KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
SHOW FULL COLUMNS FROM `s8c9k_users`361μs4.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
SELECT *
FROM `s8c9k_users`
WHERE `id` = :userid192μs4.73KBParams/libraries/src/Table/User.php:104Copy
SELECT `g`.`id`,`g`.`title`
FROM `s8c9k_usergroups` AS `g`
INNER JOIN `s8c9k_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid128μs2.34KBParams/libraries/src/Table/User.php:132Copy
SELECT `session_id`
FROM `s8c9k_session`
WHERE `session_id` = :session_id LIMIT 1157μs1.64KBParams/libraries/src/Session/MetadataManager.php:187Copy
UPDATE `s8c9k_session`
SET `guest` = :guest
, `time` = :time
, `userid` = :user_id
, `username` = :username
, `client_id` = :client_id
WHERE `session_id` = :session_id502μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
SELECT `id`,`rules`
FROM `s8c9k_viewlevels`135μs1.2KB/libraries/src/Access/Access.php:955Copy
SELECT `b`.`id`
FROM `s8c9k_user_usergroup_map` AS `map`
LEFT JOIN `s8c9k_usergroups` AS `a` ON `a`.`id` = `map`.`group_id`
LEFT JOIN `s8c9k_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `map`.`user_id` = :userId127μs2.92KBParams/libraries/src/Access/Access.php:868Copy
SELECT `value`
FROM `s8c9k_admintools_storage`
WHERE `key` = 'cparams'189μs872B/administrator/components/com_admintools/src/Helper/Storage.php:118Copy
SELECT `option`,`view`,`query`
FROM `s8c9k_admintools_wafexceptions`118μs960B/plugins/system/admintools/src/Utility/Cache.php:181Copy
SELECT `path`
FROM s8c9k_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'130μs840B/administrator/components/com_rsfirewall/helpers/config.php:53Copy
SELECT `file`
FROM s8c9k_rsfirewall_hashes
WHERE `type`='protect'136μs840B/administrator/components/com_rsfirewall/helpers/config.php:60Copy
SELECT *
FROM s8c9k_rsfirewall_configuration150μs6.19KB/administrator/components/com_rsfirewall/helpers/config.php:68Copy
SHOW FULL COLUMNS FROM `s8c9k_rsfirewall_logs`311μs3.55KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
SELECT params FROM s8c9k_extensions WHERE element = 'cookiespolicynotificationbar' AND folder = 'system'168μs40.85KB/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:174Copy
UPDATE s8c9k_extensions
SET enabled=1
WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'207μs2.55KB/plugins/system/jacontenttype/jacontenttype.php:62Copy
SELECT *
FROM `s8c9k_admintools_ipautoban`155μs1.02KB/plugins/system/admintools/src/Utility/Cache.php:121Copy
SELECT `ip`
FROM `s8c9k_admintools_ipblock`128μs2.57KB/plugins/system/admintools/src/Utility/Cache.php:131Copy
SELECT *
FROM `s8c9k_admintools_storage`
WHERE `key` LIKE 'timestamp_%'168μs944B/plugins/system/admintools/src/Feature/Base.php:256Copy
SELECT `source`,`dest`,`keepurlparams`
FROM `s8c9k_admintools_redirects`
WHERE `published` = 1
ORDER BY `ordering` ASC137μs960B/plugins/system/admintools/src/Utility/Cache.php:147Copy
SELECT `a`.`id`
FROM `s8c9k_user_usergroup_map` AS `map`
LEFT JOIN `s8c9k_usergroups` AS `a` ON `a`.`id` = `map`.`group_id`
WHERE `map`.`user_id` = :userId109μs1.64KBParams/libraries/src/Access/Access.php:868Copy
SELECT
`original_link`,
`target_link`,
`original_link_regex`,
`target_link_regex`,
`only_mobile`
FROM
`s8c9k_jredirects_patterns_redirect`
WHERE
`published` = 1140μs1.05KB/plugins/system/jredirects/jredirects.php:1690Copy
SELECT `id`
FROM `s8c9k_content`
WHERE `alias`='actualites-france'223μs840B/plugins/system/jredirects/jredirects.php:878Copy
SELECT
`link`,
`evaluate_params`
FROM
`s8c9k_jredirects_links`
WHERE
`alias` = 'actualites-france'
AND published = 1
AND menu_active = 0
AND (language = '*' OR language = 'fr-FR')133μs896B/plugins/system/jredirects/jredirects.php:388Copy
SELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application`
FROM `s8c9k_admintools_wafblacklists`
WHERE `enabled` = 1138μs1.63KB/plugins/system/admintools/src/Utility/Cache.php:167Copy
SELECT `id`
FROM `s8c9k_usergroups`136μs1.45KB/administrator/components/com_rsfirewall/helpers/users.php:25Copy
SELECT `id`,`name`,`rules`,`parent_id`
FROM `s8c9k_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,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51,:preparedArray52,:preparedArray53,:preparedArray54,:preparedArray55)188μs12.5KBParams/libraries/src/Access/Access.php:357Copy
SELECT DISTINCT(`user_id`)
FROM `s8c9k_usergroups` AS `ug1`
INNER JOIN `s8c9k_usergroups` AS `ug2` ON `ug2`.`lft` >= `ug1`.`lft` AND `ug1`.`rgt` >= `ug2`.`rgt`
INNER JOIN `s8c9k_user_usergroup_map` AS `m` ON `ug2`.`id` = `m`.`group_id`
WHERE `ug1`.`id` = :groupId179μs1.61KBParams/libraries/src/Access/Access.php:922Copy
SELECT DISTINCT(`user_id`)
FROM `s8c9k_usergroups` AS `ug1`
INNER JOIN `s8c9k_usergroups` AS `ug2` ON `ug2`.`lft` >= `ug1`.`lft` AND `ug1`.`rgt` >= `ug2`.`rgt`
INNER JOIN `s8c9k_user_usergroup_map` AS `m` ON `ug2`.`id` = `m`.`group_id`
WHERE `ug1`.`id` = :groupId131μs1.77KBParams/libraries/src/Access/Access.php:922Copy
SELECT u.*
FROM s8c9k_users u
WHERE u.id IN (63,601,605,724,1004)
ORDER BY u.username ASC147μs5.19KB/administrator/components/com_rsfirewall/helpers/users.php:58Copy
SELECT *
FROM s8c9k_rsfirewall_hashes
WHERE (`type`='4.2.6' OR `type`='protect') AND `flag`!='C'145μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1068Copy
SELECT *
FROM s8c9k_rsfirewall_snapshots
WHERE `type`='protect'152μs12.06KB/administrator/components/com_rsfirewall/helpers/snapshot.php:47Copy
SELECT *
FROM `s8c9k_users`
WHERE `id` = '724'194μs3.94KB/plugins/system/rsfirewall/rsfirewall.php:1106Copy
SELECT group_id
FROM s8c9k_user_usergroup_map
WHERE `user_id`=724158μs872B/administrator/components/com_rsfirewall/helpers/snapshot.php:68Copy
SELECT `ip`,`reason`
FROM s8c9k_rsfirewall_lists
WHERE (`ip`='2a01:cb04:18a9c27:6cb2:99a3:f43a' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'118μs992B/plugins/system/rsfirewall/rsfirewall.php:174Copy
SELECT `ip`,`reason`
FROM s8c9k_rsfirewall_lists
WHERE (`ip`='2a01:cb04:18a9c27:6cb2:99a3:f43a' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'125μs2.75KB/plugins/system/rsfirewall/rsfirewall.php:174Copy
SELECT *
FROM s8c9k_rsfirewall_exceptions
WHERE `published`='1'146μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:719Copy
SELECT
`original_link`,
`target_link`,
`original_link_regex`,
`target_link_regex`,
`only_mobile`
FROM
`s8c9k_jredirects_patterns_redirect`
WHERE
`published` = 1122μs1.05KB/plugins/system/jredirects/jredirects.php:1690Copy
SELECT `id`
FROM `s8c9k_content`
WHERE `alias`='actualites-france'131μs840B/plugins/system/jredirects/jredirects.php:878Copy
SELECT
`link`,
`evaluate_params`
FROM
`s8c9k_jredirects_links`
WHERE
`alias` = 'actualites-france'
AND published = 1
AND menu_active = 0
AND (language = '*' OR language = 'fr-FR')115μs896B/plugins/system/jredirects/jredirects.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`,(
SELECT COUNT(`i`.`id`)
FROM `s8c9k_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `s8c9k_categories` AS `s`
INNER JOIN `s8c9k_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`12.25ms6.66KBParams/libraries/src/Categories/Categories.php:360Copy
SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`
FROM `s8c9k_content` AS `a`
LEFT JOIN `s8c9k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `s8c9k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `s8c9k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `s8c9k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `s8c9k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `c`.`published` = 1 AND `a`.`state` IN (:preparedArray11,:preparedArray12) AND `a`.`catid` = :categoryId
ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 2013.14ms569.84KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
SELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `s8c9k_contentitem_tag_map` AS `m`
INNER JOIN `s8c9k_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20) AND `t`.`access` IN (:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25)327μs7.66KBParams/libraries/src/Helper/TagsHelper.php:424Copy
SELECT COUNT(*)
FROM `s8c9k_content` AS `a`
LEFT JOIN `s8c9k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `s8c9k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `s8c9k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `s8c9k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `s8c9k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `c`.`published` = 1 AND `a`.`state` IN (:preparedArray11,:preparedArray12) AND `a`.`catid` = :categoryId9.05ms7.73KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:198Copy
SELECT `m`.`tag_id`,`t`.*
FROM `s8c9k_contentitem_tag_map` AS `m`
INNER JOIN `s8c9k_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,:preparedArray3,:preparedArray4,:preparedArray5)358μs5.31KBParams/libraries/src/Helper/TagsHelper.php:364Copy
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 `s8c9k_categories` AS `s`
INNER JOIN `s8c9k_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,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`165μs6.77KBParams/libraries/src/Categories/Categories.php:360Copy
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 s8c9k_fields AS a
LEFT JOIN `s8c9k_languages` AS l ON l.lang_code = a.language
LEFT JOIN s8c9k_users AS uc ON uc.id=a.checked_out
LEFT JOIN s8c9k_viewlevels AS ag ON ag.id = a.access
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_user_id
LEFT JOIN s8c9k_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `s8c9k_fields_categories` AS fc ON fc.field_id = a.id

[Folamour]

Queries 2

WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13)) 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 ASC173μs23.44KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
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 `s8c9k_categories` AS `s`
INNER JOIN `s8c9k_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,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`169μs6.77KBParams/libraries/src/Categories/Categories.php:360Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19573'163μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19571'193μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19568'221μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19567'144μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19564'137μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19558'254μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19552'248μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19550'202μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19547'144μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19546'217μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19545'204μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19544'192μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19543'236μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19542'226μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19541'258μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19540'200μs8.92KB/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19539'215μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19534'241μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19533'255μs944B/plugins/content/yrvote/yrvote.php:256Copy
SELECT rating_sum,rating_count
FROM s8c9k_content_rating
WHERE content_id='19532'264μs944B/plugins/content/yrvote/yrvote.php:256Copy
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 s8c9k_fields AS a
LEFT JOIN `s8c9k_languages` AS l ON l.lang_code = a.language
LEFT JOIN s8c9k_users AS uc ON uc.id=a.checked_out
LEFT JOIN s8c9k_viewlevels AS ag ON ag.id = a.access
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_user_id
LEFT JOIN s8c9k_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10)) 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 ASC269μs6.12KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
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 `s8c9k_categories` AS `s`
INNER JOIN `s8c9k_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,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`285μs6.77KBParams/libraries/src/Categories/Categories.php:360Copy
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 s8c9k_fields AS a
LEFT JOIN `s8c9k_languages` AS l ON l.lang_code = a.language
LEFT JOIN s8c9k_users AS uc ON uc.id=a.checked_out
LEFT JOIN s8c9k_viewlevels AS ag ON ag.id = a.access
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_user_id
LEFT JOIN s8c9k_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `s8c9k_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13)) 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 ASC789μs7.44KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
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 s8c9k_fields AS a
LEFT JOIN `s8c9k_languages` AS l ON l.lang_code = a.language
LEFT JOIN s8c9k_users AS uc ON uc.id=a.checked_out
LEFT JOIN s8c9k_viewlevels AS ag ON ag.id = a.access
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_user_id
LEFT JOIN s8c9k_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10)) 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 ASC201μs6.12KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
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 s8c9k_fields AS a
LEFT JOIN `s8c9k_languages` AS l ON l.lang_code = a.language
LEFT JOIN s8c9k_users AS uc ON uc.id=a.checked_out
LEFT JOIN s8c9k_viewlevels AS ag ON ag.id = a.access
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_user_id
LEFT JOIN s8c9k_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10)) 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 ASC212μs6.12KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
SELECT extension_id FROM s8c9k_extensions WHERE type='plugin' AND element = 'cookiespolicynotificationbar' AND folder='system'140μs872B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:698Copy
SELECT extension_id FROM s8c9k_extensions WHERE type='plugin' AND element = 'cookiespolicynotificationbar' AND folder='system'136μs0B/plugins/system/cookiespolicynotificationbar/cookiespolicynotificationbar.php:699Copy
SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `s8c9k_modules` AS `m`
LEFT JOIN `s8c9k_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `s8c9k_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id`

[Folamour]

Queries 3

WHERE
(
(
(`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5)) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND
(`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0)
ORDER BY `m`.`position`,`m`.`ordering`624μs4.81KBParams/libraries/src/Cache/Controller/CallbackController.php:132Copy
SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`
FROM `s8c9k_content` AS `a`
LEFT JOIN `s8c9k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `s8c9k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `s8c9k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `s8c9k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `s8c9k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20)
ORDER BY a.created DESC LIMIT 333.9ms145.52KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
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 `s8c9k_categories` AS `s`
INNER JOIN `s8c9k_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,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`297μs6.77KBParams/libraries/src/Categories/Categories.php:360Copy
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 `s8c9k_categories` AS `s`
INNER JOIN `s8c9k_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,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`196μs6.77KBParams/libraries/src/Categories/Categories.php:360Copy
SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`
FROM `s8c9k_content` AS `a`
LEFT JOIN `s8c9k_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `s8c9k_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `s8c9k_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `s8c9k_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `s8c9k_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `c`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray11)
ORDER BY a.hits DESC LIMIT 313.56ms180.08KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
SHOW TABLES733μs6.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:637Copy
SELECT * FROM s8c9k_acymailing_config202μs11.88KB/administrator/components/com_acymailing/compat/joomla.php:628Copy
SELECT * FROM s8c9k_acymailing_subscriber WHERE email = '[email protected]' LIMIT 1184μs4.06KB/administrator/components/com_acymailing/compat/joomla.php:637Copy
SELECT a.*, b.* FROM s8c9k_acymailing_list as b LEFT JOIN s8c9k_acymailing_listsub as a on a.listid = b.listid AND a.subid = 5 WHERE b.type = 'list' ORDER BY b.ordering ASC248μs4.34KB/administrator/components/com_acymailing/compat/joomla.php:628Copy
SELECT * FROM `s8c9k_acymailing_fields` as a WHERE a.`published` = 1 AND (a.access = 'all' OR a.access LIKE ('%,8,%')) ORDER BY a.`ordering` ASC211μs5.28KB/administrator/components/com_acymailing/compat/joomla.php:628Copy
SELECT * FROM `s8c9k_acymailing_fields`224μs5.28KB/administrator/components/com_acymailing/compat/joomla.php:628Copy
SELECT *
FROM `s8c9k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)385μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `s8c9k_banners` AS `a`
LEFT JOIN `s8c9k_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1)
ORDER BY `a`.`sticky` DESC, RAND() LIMIT 3572μs3.56KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
UPDATE `s8c9k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1,:preparedArray2,:preparedArray3)212μs912BParams/components/com_banners/src/Model/BannersModel.php:315Copy
SELECT *
FROM `s8c9k_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)590μs7.84KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `s8c9k_banners` AS `a`
LEFT JOIN `s8c9k_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1)
ORDER BY `a`.`sticky` DESC, RAND() LIMIT 1613μs3.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
UPDATE `s8c9k_banners`
SET `impmade` = `impmade` + 1
WHERE `id` IN (:preparedArray1)279μs856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
SELECT * FROM `s8c9k_easyfrontendseo` WHERE `url` = 'actualites-france'34.2ms2.08KB/plugins/system/easyfrontendseo/easyfrontendseo.php:559Copy
SELECT *
FROM `s8c9k_extensions`
WHERE `element` = 'com_gsd' AND `type` = 'component'242μs4.09KB/plugins/system/nrframework/NRFramework/Extension.php:124Copy
SHOW FULL COLUMNS FROM `s8c9k_gsd_config`507μs2.23KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
SELECT *
FROM s8c9k_gsd_config
WHERE `name` = 'config'144μs944B/libraries/src/Table/Table.php:749Copy
SELECT *
FROM s8c9k_jmap_metainfo
WHERE `linkurl` = 'https://www.crashdebug.fr/actualites-france'
AND `published` = 1383μs1.2KB/plugins/system/jmap/jmap.php:547Copy
SELECT *
FROM s8c9k_jmap_canonicals
WHERE `linkurl` = 'https://www.crashdebug.fr/actualites-fr ... hp:624Copy
SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `s8c9k_scheduler_tasks` AS `a`
LEFT JOIN `s8c9k_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now
ORDER BY `a`.`title` asc1.19ms4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor`
FROM `s8c9k_scheduler_tasks` AS `a`
LEFT JOIN `s8c9k_users` AS `uc` ON `uc`.`id` = `a`.`checked_out`
WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL
ORDER BY `a`.`title` asc262μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
SELECT `value`
FROM `s8c9k_extrawatch_settings`
WHERE `key` = 'extrawatch-projectId' LIMIT 1237μs872B/administrator/components/com_extrawatch/ew-plg-common/cms/ExtraWatchJoomlaSpecific.php:72Copy
SELECT `value`
FROM `s8c9k_admintools_storage`
WHERE `key` = 'criticalfiles'214μs872B/plugins/system/admintools/src/Feature/CriticalFilesMonitoring.php:185Copy
SHOW TABLES757μs6.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:637Copy
SHOW FULL COLUMNS FROM `s8c9k_autotweet_automator`364μs2.38KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
SELECT s8c9k_autotweet_automator.*
FROM s8c9k_autotweet_automator
WHERE `s8c9k_autotweet_automator`.`plugin` = 'automator'191μs1KB/libraries/autotweet/vendor/extly/xt-fof254/src/database/driver/joomla.php:360Copy
SELECT s8c9k_autotweet_automator.*
FROM s8c9k_autotweet_automator
WHERE `s8c9k_autotweet_automator`.`id` = '1'216μs1KB/libraries/autotweet/vendor/extly/xt-fof254/src/database/driver/joomla.php:360Copy
SET sql_big_selects=1157μs0B/libraries/autotweet/src/Infrastructure/PlgAutotweetBase.php:215Copy
SELECT s8c9k_autotweet_automator.*
FROM s8c9k_autotweet_automator
WHERE `s8c9k_autotweet_automator`.`plugin` = 'content'119μs1KB/libraries/autotweet/vendor/extly/xt-fof254/src/database/driver/joomla.php:360Copy
SELECT s8c9k_autotweet_automator.*
FROM s8c9k_autotweet_automator
WHERE `s8c9k_autotweet_automator`.`id` = '2'124μs1KB/libraries/autotweet/vendor/extly/xt-fof254/src/database/driver/joomla.php:360Copy
SELECT folder AS type, element AS name, params, extension_id
FROM s8c9k_extensions
WHERE element = 'jspeed' AND type = 'plugin'156μs1.06KB/plugins/system/jspeed/Framework/Plugin.php:33Copy
SELECT *
FROM s8c9k_jmap_headings
WHERE `linkurl` = 'https://www.crashdebug.fr/actualites-france'

[Folamour]

no one as an advice ?

[SharkyKZ]

The slowdown occurs during component dispatch phase. It's most likely caused by a content plugin (or system plugin with onAfterDispatch event). Have you tried disabling some of the plugins?

[Folamour]

hi thanks, i've disablet YR vote, and one cookie related to a old template, i've tried to play on all parameter from the view category, but without luck, the strange thing is that on web page speed test, ive a 210ms using uk local test

here in france with chrome or firefox the network analyzer show this long wait of 5600 ms

once the page is cached all is fine,

the things is that we have 15 k article

so perhaps the query on the database or thing like that take this time,

but we would like to correct this lag of 5.6 when clicking on a category view page not cached,

i will try to saw what i can disable

thanks for the information,

f.

[Folamour]

ok i've found it was s social share plug in who was activated in category view, disabling the plugin in these view fix the issue

Now the time is about 150ms ; )))))))))))

All is fine !

Thanks a lot to the comunity and SharkyKZ for the help,

f.