Je viens de m'apercevoir que (au moins) 90 % des adresses e-mails liées aux abonnements aux commentaires sont de fausses adresses.

Mais où est ce que la connerie humaine ne va pas se loger !!!

Du coup, j'ai tout supprimé. Désolé pour les exceptions  qui ont joué le jeu correctement.

En même temps, il faut bien reconnaître que ces commentaires sont creux dans leur immense majorité, quand ce ne sont pas des spams...

On va repartir sur des bases saines. Désormais, je surveillerai les adresses régulièrement.

Merci de votre compréhension.

Comments (0)

    Attach images by dragging & dropping or by selecting them.
    The maximum file size for uploads is 10MB. Only gif,jpg,png files are allowed.
     
    The maximum number of 3 allowed files to upload has been reached. If you want to upload more files you have to delete one of the existing uploaded files first.
    The maximum number of 3 allowed files to upload has been reached. If you want to upload more files you have to delete one of the existing uploaded files first.
    Posting as

    Comments powered by CComment

    Settings9.294MBMemory Usage347msRequest Duration
    Theme
    Open Button Position
    Hide Empty Tabs
    Autoshow
    Reset to defaults
    Joomla! Version5.4.0-alpha1
    PHP Version8.3.22
    Identityguest
    Response200
    Templatecassiopeia
    Database
    Server
    mysql
    Version
    10.11.11-MariaDB-0+deb12u1
    Collation
    utf8mb3_general_ci
    Conn Collation
    utf8mb4_general_ci
    $_GET
    []
    $_POST
    []
    $_SESSION
    array:1 [ "joomla" => "***redacted***" ]
    $_COOKIE
    []
    $_SERVER
    array:51 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "PP_CUSTOM_P...
    session
    array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1750690904 "last" => 1750690904...
    registry
    array:3 [ "data" => [] "initialized" => false "separator" => "." ]
    user
    array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
    plg_system_webauthn
    array:1 [ "returnUrl" => "https://www.doubsastuces.fr/index.php/quoi-de-neuf/122-a-propos-des-comm...
    • afterLoad (83.9KB) (6.12ms)
    • afterInitialise (1.14MB) (29.71ms)
    • afterRoute (210.48KB) (13.03ms)
    • beforeRenderComponent com_content (102.12KB) (2.77ms)
    • Before Access::preloadComponents (all components) (34.63KB) (3.84ms)
    • After Access::preloadComponents (all components) (122.53KB) (879μs)
    • Before Access::preloadPermissions (com_content) (1.66KB) (19μs)
    • After Access::preloadPermissions (com_content) (93.53KB) (656μs)
    • Before Access::getAssetRules (id:289 name:com_content.article.122) (6.65KB) (23μs)
    • After Access::getAssetRules (id:289 name:com_content.article.122) (7.56KB) (833μs)
    • Before Access::getAssetRules (id:305 name:com_comment) (1.43MB) (68.7ms)
    • After Access::getAssetRules (id:305 name:com_comment) (7.12KB) (33μs)
    • afterRenderComponent com_content (37.59KB) (9.53ms)
    • afterDispatch (2.14KB) (307μs)
    • beforeRenderRawModule mod_login (Connexion) (28.02KB) (1.03ms)
    • afterRenderRawModule mod_login (Connexion) (51.88KB) (3.45ms)
    • beforeRenderRawModule mod_tags_popular (Tags populaires) (848B) (20μs)
    • afterRenderRawModule mod_tags_popular (Tags populaires) (30.3KB) (6.08ms)
    • beforeRenderRawModule mod_breadcrumbs (Fil de navigation) (44.3KB) (914μs)
    • afterRenderRawModule mod_breadcrumbs (Fil de navigation) (10.84KB) (1.76ms)
    • beforeRenderRawModule mod_search (Recherche) (3.93KB) (1.57ms)
    • afterRenderRawModule mod_search (Recherche) (16.07KB) (1.62ms)
    • beforeRenderRawModule mod_menu (Menu principal) (1.66KB) (1.47ms)
    • afterRenderRawModule mod_menu (Menu principal) (71.16KB) (5.41ms)
    • beforeRenderModule mod_breadcrumbs (Fil de navigation) (3.34MB) (5.24ms)
    • afterRenderModule mod_breadcrumbs (Fil de navigation) (4.41KB) (1.06ms)
    • beforeRenderModule mod_search (Recherche) (240B) (1.53ms)
    • afterRenderModule mod_search (Recherche) (3.19KB) (153μs)
    • beforeRenderModule mod_login (Connexion) (222.27KB) (89.77ms)
    • afterRenderModule mod_login (Connexion) (10.42KB) (220μs)
    • beforeRenderModule mod_tags_popular (Tags populaires) (752B) (16μs)
    • afterRenderModule mod_tags_popular (Tags populaires) (1.76KB) (93μs)
    • beforeRenderModule mod_menu (Menu principal) (90KB) (29.16ms)
    • afterRenderModule mod_menu (Menu principal) (7.34KB) (305μs)
    • beforeRenderRawModule mod_menu (Menu utilisateur) (59.57KB) (21.71ms)
    • afterRenderRawModule mod_menu (Menu utilisateur) (1008B) (1.4ms)
    • beforeRenderModule mod_menu (Menu utilisateur) (720B) (10μs)
    • afterRenderModule mod_menu (Menu utilisateur) (1.66KB) (158μs)
    • afterRender (3.42MB) (35.39ms)
    • 1 x beforeRenderModule mod_login (Connexion) (222.27KB) (25.9%)
      89.77ms
      1 x Before Access::getAssetRules (id:305 name:com_comment) (1.43MB) (19.83%)
      68.70ms
      1 x afterRender (3.42MB) (10.21%)
      35.39ms
      1 x afterInitialise (1.14MB) (8.57%)
      29.71ms
      1 x beforeRenderModule mod_menu (Menu principal) (90KB) (8.42%)
      29.16ms
      1 x beforeRenderRawModule mod_menu (Menu utilisateur) (59.57KB) (6.26%)
      21.71ms
      1 x afterRoute (210.48KB) (3.76%)
      13.03ms
      1 x afterRenderComponent com_content (37.59KB) (2.75%)
      9.53ms
      1 x afterLoad (83.9KB) (1.77%)
      6.12ms
      1 x afterRenderRawModule mod_tags_popular (Tags populaires) (30.3KB) (1.75%)
      6.08ms
      1 x afterRenderRawModule mod_menu (Menu principal) (71.16KB) (1.56%)
      5.41ms
      1 x beforeRenderModule mod_breadcrumbs (Fil de navigation) (3.34MB) (1.51%)
      5.24ms
      1 x Before Access::preloadComponents (all components) (34.63KB) (1.11%)
      3.84ms
      1 x afterRenderRawModule mod_login (Connexion) (51.88KB) (0.99%)
      3.45ms
      1 x beforeRenderComponent com_content (102.12KB) (0.8%)
      2.77ms
      1 x afterRenderRawModule mod_breadcrumbs (Fil de navigation) (10.84KB) (0.51%)
      1.76ms
      1 x afterRenderRawModule mod_search (Recherche) (16.07KB) (0.47%)
      1.62ms
      1 x beforeRenderRawModule mod_search (Recherche) (3.93KB) (0.45%)
      1.57ms
      1 x beforeRenderModule mod_search (Recherche) (240B) (0.44%)
      1.53ms
      1 x beforeRenderRawModule mod_menu (Menu principal) (1.66KB) (0.43%)
      1.47ms
      1 x afterRenderRawModule mod_menu (Menu utilisateur) (1008B) (0.4%)
      1.40ms
      1 x afterRenderModule mod_breadcrumbs (Fil de navigation) (4.41KB) (0.31%)
      1.06ms
      1 x beforeRenderRawModule mod_login (Connexion) (28.02KB) (0.3%)
      1.03ms
      1 x beforeRenderRawModule mod_breadcrumbs (Fil de navigation) (44.3KB) (0.26%)
      914μs
      1 x After Access::preloadComponents (all components) (122.53KB) (0.25%)
      879μs
      1 x After Access::getAssetRules (id:289 name:com_content.article.122) (7.56KB) (0.24%)
      833μs
      1 x After Access::preloadPermissions (com_content) (93.53KB) (0.19%)
      656μs
      1 x afterDispatch (2.14KB) (0.09%)
      307μs
      1 x afterRenderModule mod_menu (Menu principal) (7.34KB) (0.09%)
      305μs
      1 x afterRenderModule mod_login (Connexion) (10.42KB) (0.06%)
      220μs
      1 x afterRenderModule mod_menu (Menu utilisateur) (1.66KB) (0.05%)
      158μs
      1 x afterRenderModule mod_search (Recherche) (3.19KB) (0.04%)
      153μs
      1 x afterRenderModule mod_tags_popular (Tags populaires) (1.76KB) (0.03%)
      93μs
      1 x After Access::getAssetRules (id:305 name:com_comment) (7.12KB) (0.01%)
      33μs
      1 x Before Access::getAssetRules (id:289 name:com_content.article.122) (6.65KB) (0.01%)
      23μs
      1 x beforeRenderRawModule mod_tags_popular (Tags populaires) (848B) (0.01%)
      20μs
      1 x Before Access::preloadPermissions (com_content) (1.66KB) (0.01%)
      19μs
      1 x beforeRenderModule mod_tags_popular (Tags populaires) (752B) (0%)
      16μs
      1 x beforeRenderModule mod_menu (Menu utilisateur) (720B) (0%)
      10μs
    33 statements were executed, 6 of which were duplicates, 27 unique16.99ms87.61KB
    • SELECT @@SESSION.sql_mode;82μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
    • SELECT `data` FROM `sn27j_session` WHERE `session_id` = ?523μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
    • SELECT `session_id` FROM `sn27j_session` WHERE `session_id` = :session_id LIMIT 1116μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
    • INSERT INTO `sn27j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)984μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
    • SELECT `id`,`rules` FROM `sn27j_viewlevels`99μs976B/libraries/src/Access/Access.php:955Copy
    • SELECT `b`.`id` FROM `sn27j_usergroups` AS `a` LEFT JOIN `sn27j_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest138μs1.33KBParams/libraries/src/Access/Access.php:868Copy
    • 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 `sn27j_categories` AS `s` INNER JOIN `sn27j_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`374μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
    • SELECT `alias` FROM `sn27j_content` WHERE `id` = :id445μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
    • SELECT `id`,`name`,`rules`,`parent_id` FROM `sn27j_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)471μs8.19KBParams/libraries/src/Access/Access.php:357Copy
    • SELECT `id`,`name`,`rules`,`parent_id` FROM `sn27j_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0292μs4.48KBParams/libraries/src/Access/Access.php:301Copy
    • SHOW FULL COLUMNS FROM `sn27j_content`2.52ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
    • UPDATE `sn27j_content` SET `hits` = (`hits` + 1) WHERE `id` = '122'505μs48B/libraries/src/Table/Table.php:1414Copy
    • 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 `sn27j_content` AS `a` INNER JOIN `sn27j_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sn27j_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sn27j_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `sn27j_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sn27j_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)254μs6.12KBParams/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 `sn27j_categories` AS `s` INNER JOIN `sn27j_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`243μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
    • SELECT `m`.`tag_id`,`t`.* FROM `sn27j_contentitem_tag_map` AS `m` INNER JOIN `sn27j_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)180μs3.97KBParams/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 `sn27j_categories` AS `s` INNER JOIN `sn27j_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`318μs3.91KBParams/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 sn27j_fields AS a LEFT JOIN `sn27j_languages` AS l ON l.lang_code = a.language LEFT JOIN sn27j_users AS uc ON uc.id=a.checked_out LEFT JOIN sn27j_viewlevels AS ag ON ag.id = a.access LEFT JOIN sn27j_users AS ua ON ua.id = a.created_user_id LEFT JOIN sn27j_fields_groups AS g ON g.id = a.group_id LEFT JOIN `sn27j_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 ASC2.43ms6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
    • 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 `sn27j_content` AS `a` LEFT JOIN `sn27j_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 DESC755μs2.03KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
    • SELECT * FROM `sn27j_comment_setting` WHERE `component`='com_content'109μs704B/administrator/components/com_comment/library/config.php:85Copy
    • SELECT * FROM sn27j_comment_queue WHERE status = 0 ORDER BY created ASC LIMIT 5126μs1.27KB/components/com_comment/helpers/queue.php:40Copy
    • SELECT COUNT(*) FROM sn27j_comment WHERE contentid='122' AND component='com_content' AND published=1126μs536B/components/com_comment/models/comment.php:152Copy
    • SELECT f.*, c.catid as catid FROM sn27j_compojoom_customfields as f LEFT JOIN sn27j_compojoom_customfields_cats AS c ON f.id = c.compojoom_customfields_id WHERE `f`.`show`='all' AND `f`.`enabled` = '1' AND `f`.`component` = 'com_comment'121μs2.39KB/libraries/compojoom/model/customfieldsconfig.php:51Copy
    • SELECT f.* FROM sn27j_compojoom_customfields AS f INNER JOIN sn27j_compojoom_customfields_cats AS c ON f.id = c.compojoom_customfields_id WHERE `f`.`show`='category' AND `c`.`catid` IN ('1') AND `f`.`enabled` = '1' AND `f`.`component` = 'com_comment'98μs2.36KB/libraries/compojoom/model/customfieldsconfig.php:70Copy
    • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `sn27j_modules` AS `m` LEFT JOIN `sn27j_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `sn27j_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) 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`330μs1.94KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
    • 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 `sn27j_categories` AS `s` INNER JOIN `sn27j_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`480μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
    • SELECT `alias`,`catid` FROM sn27j_content WHERE `id` = :key182μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
    • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `sn27j_contentitem_tag_map` AS `m` INNER JOIN `sn27j_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `sn27j_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `sn27j_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `sn27j_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray3,:preparedArray4) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 103.07ms1.81KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
    • SELECT * FROM `sn27j_schemaorg` WHERE `itemId` = :itemId AND `context` = :context147μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
    • 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 `sn27j_content` AS `a` INNER JOIN `sn27j_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sn27j_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sn27j_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `sn27j_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sn27j_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)397μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
    • 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 `sn27j_content` AS `a` INNER JOIN `sn27j_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `sn27j_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `sn27j_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `sn27j_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `sn27j_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)327μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
    • 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 `sn27j_scheduler_tasks` AS `a` WHERE `a`.`state` = 1133μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
    • SELECT `session_id` FROM `sn27j_session` WHERE `session_id` = ?114μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
    • UPDATE `sn27j_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?499μs3.08KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy