Accéder au contenu principal
Imprimer
Numéro 166 - Septembre 2021

Coût réel pour l’État du deuxième pilier belge de pension pour salariés : l’approche actuarielle bouscule quelques à priori

RE166Diverses études macroéconomiques ont été publiées ces derniers mois, relatives au deuxième pilier de pension en Belgique (pilier des pensions complémentaires formé des assurances de groupe et des fonds de pension), notamment de la part de la Cour des Comptes et du Bureau Fédéral du Plan. Un des objectifs de ces analyses a été de tenter d’évaluer le coût pour l’Etat des avantages fiscaux et parafiscaux accordés aux affiliés de ce deuxième pilier. En effet, le deuxième pilier jouit d’un traitement fiscal et parafiscal particulier visant notamment à encourager, dans le contexte du vieillissement bien connu, l’épargne retraite à long terme. Ces études ont aussi porté sur le caractère plus ou moins inégalitaire de ce deuxième pilier dans sa configuration actuelle. S’il faut saluer ces analyses qui manquaient jusqu’à présent, et qui enrichissent le débat sur les pensions, il n’est pas inutile par ailleurs d’en examiner la méthodologie et d’en discuter les principes.

Ces études sont ainsi caractérisées par une approche budgétaire qui vise à comparer, une année donnée, les avantages accordés (principalement des cotisations sociales à taux réduit et la déductibilité des contributions versées) et les taxes prélevées (principalement la taxation des prestations obtenues à la retraite). Cette approche peut se comprendre dans une vision purement comptable mais elle ne prend pas en compte la dynamique de long terme intrinsèque à la constitution de pension : les contributions d’aujourd’hui payées pendant la durée d’activité sont le pendant des prestations de demain à la retraite, pas des prestations payées aujourd’hui ! Ce phénomène est d’autant plus marqué que le deuxième pilier belge est en pleine mutation depuis la loi de 2003 sur les pensions complémentaires. Un deuxième point d’attention est que ces évaluations ont été faites sur le seul deuxième pilier, sans prise en compte d’interactions avec le premier pilier.

Notre étude vise à pallier à ces critiques; nous mesurons les avantages fiscaux et parafiscaux du deuxième pilier pour travailleurs salariés, d’une part tout au long du cycle de vie d’un individu et d’autre part en intégrant les liens avec le premier pilier. En particulier, nous avons voulu mettre en parallèle aux avantages accordés aux affiliés du deuxième pilier, la taxe implicite résultant du mode de financement particulier à la Belgique de nos pensions légales de premier pilier pour salariés. En effet, si, comme dans la plupart des pays, un plafond de rémunération existe pour la détermination de la pension légale (actuellement de l’ordre de 61.000 €), ce plafond ne joue pas en Belgique, contrairement aux autres pays, pour le calcul des cotisations sociales. Les salariés se voient ainsi prélever sur la partie de leur salaire au-dessus du plafond des cotisations sans aucune ouverture de droit. On pourrait ainsi dire, en regardant l’ensemble des pensions d’un salarié, que l’Etat donne d’une main par les avantages au deuxième pilier ce qu’il reprend de l’autre par cette taxe de premier pilier. L’étude chiffre ces effets sur la base de différentes hypothèses portant notamment sur le profil d ‘un affilié type et d’un plan de pension de référence; des études de sensibilité sont ensuite présentées.

Ainsi, pour le profil individuel de référence choisi, le coût brut annuel moyen du seul deuxième pilier s’élève à 47 % des contributions de ce deuxième pilier. L’étude du Bureau du plan mettait en évidence un coût annuel du deuxième pilier des salariés de 2,1 milliards sur 3,988 milliards de contributions (soit 53 %). Si on tient compte des effets sur le premier pilier, principalement la taxe implicite mentionnée ci avant, le coût est diminué de plus de moitié, passant à 21 % des contributions. L’étude met également en évidence les effets de solidarité et illustre que si les avantages de deuxième pilier analysé isolément croissent avec le salaire, notre système global de pension premier et deuxième pilier reste bien largement solidaire du fait principalement de la présence de cette taxe implicite.

 

télécharger l'annexe technique

PDF Télécharger le numéro en PDF

On en parle dans la presse...

31.116MBMemory Usage266msRequest Duration
Joomla! Version5.2.6
PHP Version8.2.28
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
10.6.18-MariaDB-deb11-log
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:3 [ "cid" => "216" "option" => "com_reco" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:62 [ "TEMP" => "/home/clients/c76502dcd0092cafe8460c17f647856e/tmp" "TMPDIR" => "/home/cli...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744341860 "last" => 1744341860...
registry
array:3 [ "data" => array:1 [ "com_reco" => array:1 [ "article" => array:2 [ "or...
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.82MB) (14.91ms)
  • afterInitialise (11.1MB) (63.98ms)
  • afterRoute (2.01MB) (10.73ms)
  • beforeRenderComponent com_reco (29.4KB) (991μs)
  • beforeRenderRawModule mod_custom (RE-Social NEW (mobile)) (6.1MB) (58.16ms)
  • afterRenderRawModule mod_custom (RE-Social NEW (mobile)) (36.64KB) (1.11ms)
  • beforeRenderModule mod_custom (RE-Social NEW (mobile)) (720B) (7μs)
  • afterRenderModule mod_custom (RE-Social NEW (mobile)) (85.05KB) (1.01ms)
  • afterRenderComponent com_reco (14.6KB) (2.1ms)
  • afterDispatch (109.51KB) (2.53ms)
  • beforeRenderRawModule mod_custom (RE-Social NEW) (82.74KB) (2.77ms)
  • afterRenderRawModule mod_custom (RE-Social NEW) (1.05KB) (129μs)
  • beforeRenderRawModule mod_custom (IRES présentation) (1.27KB) (32μs)
  • afterRenderRawModule mod_custom (IRES présentation) (101.92KB) (3ms)
  • beforeRenderRawModule mod_menu (Liste des numéros) (2.48KB) (36μs)
  • afterRenderRawModule mod_menu (Liste des numéros) (91.64KB) (2.41ms)
  • beforeRenderRawModule mod_menu (Liste des focus) (720B) (35μs)
  • afterRenderRawModule mod_menu (Liste des focus) (21.84KB) (1.29ms)
  • beforeRenderModule mod_custom (RE-Social NEW) (181.31KB) (10.64ms)
  • afterRenderModule mod_custom (RE-Social NEW) (1.91KB) (151μs)
  • beforeRenderModule mod_custom (IRES présentation) (408B) (32μs)
  • afterRenderModule mod_custom (IRES présentation) (1.76KB) (100μs)
  • beforeRenderModule mod_menu (Liste des numéros) (1.62KB) (30μs)
  • afterRenderModule mod_menu (Liste des numéros) (1.76KB) (84μs)
  • beforeRenderModule mod_menu (Liste des focus) (168B) (27μs)
  • afterRenderModule mod_menu (Liste des focus) (1.76KB) (83μs)
  • beforeRenderRawModule mod_menu () (5.48KB) (1.24ms)
  • afterRenderRawModule mod_menu () (33.5KB) (1.84ms)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.22KB) (120μs)
  • beforeRenderRawModule mod_finder () (2.01KB) (18μs)
  • afterRenderRawModule mod_finder () (914.29KB) (11.22ms)
  • beforeRenderModule mod_finder () (704B) (12μs)
  • afterRenderModule mod_finder () (4.69KB) (151μs)
  • beforeRenderRawModule mod_custom () (624B) (774μs)
  • afterRenderRawModule mod_custom () (1.19KB) (366μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (1.73KB) (112μs)
  • beforeRenderRawModule mod_custom (Oreille) (2.67KB) (488μs)
  • beforeRenderRawModule mod_menu (Menu oreille) (43.59KB) (307μs)
  • afterRenderRawModule mod_menu (Menu oreille) (214.12KB) (3.6ms)
  • beforeRenderModule mod_menu (Menu oreille) (720B) (7μs)
  • afterRenderModule mod_menu (Menu oreille) (3.19KB) (128μs)
  • afterRenderRawModule mod_custom (Oreille) (43.36KB) (377μs)
  • beforeRenderModule mod_custom (Oreille) (704B) (6μs)
  • afterRenderModule mod_custom (Oreille) (1.74KB) (109μs)
  • beforeRenderRawModule mod_custom (Toolbar-R (UCL)) (168B) (28μs)
  • afterRenderRawModule mod_custom (Toolbar-R (UCL)) (976B) (104μs)
  • beforeRenderModule mod_custom (Toolbar-R (UCL)) (720B) (4μs)
  • afterRenderModule mod_custom (Toolbar-R (UCL)) (1.76KB) (94μs)
  • beforeRenderRawModule mod_menu () (256B) (829μs)
  • afterRenderRawModule mod_menu () (3.17KB) (1.38ms)
  • beforeRenderModule mod_menu () (696B) (6μs)
  • afterRenderModule mod_menu () (1.8KB) (108μs)
  • beforeRenderRawModule mod_menu (Menu oreille (mobile)) (3.07KB) (27μs)
  • afterRenderRawModule mod_menu (Menu oreille (mobile)) (2.66KB) (1.27ms)
  • beforeRenderModule mod_menu (Menu oreille (mobile)) (720B) (5μs)
  • afterRenderModule mod_menu (Menu oreille (mobile)) (2.13KB) (107μs)
  • beforeRenderRawModule mod_finder (Recherche (mobile)) (392B) (25μs)
  • afterRenderRawModule mod_finder (Recherche (mobile)) (10.93KB) (1.78ms)
  • beforeRenderModule mod_finder (Recherche (mobile)) (720B) (6μs)
  • afterRenderModule mod_finder (Recherche (mobile)) (2.13KB) (104μs)
  • beforeRenderModule mod_custom (RE-Social NEW (mobile)) (1.6KB) (25μs)
  • afterRenderModule mod_custom (RE-Social NEW (mobile)) (1.76KB) (81μs)
  • beforeRenderRawModule mod_custom () (1.17KB) (1.28ms)
  • afterRenderRawModule mod_custom () (3.53KB) (362μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (2.94KB) (104μs)
  • beforeRenderRawModule mod_custom () (184B) (601μs)
  • afterRenderRawModule mod_custom () (1.03KB) (328μs)
  • beforeRenderModule mod_custom () (704B) (6μs)
  • afterRenderModule mod_custom () (3.41KB) (100μs)
  • afterRender (5.63MB) (59.13ms)
  • 1 x afterInitialise (11.1MB) (24.05%)
    63.98ms
    1 x afterRender (5.63MB) (22.23%)
    59.13ms
    1 x beforeRenderRawModule mod_custom (RE-Social NEW (mobile)) (6.1MB) (21.86%)
    58.16ms
    1 x afterLoad (3.82MB) (5.61%)
    14.91ms
    1 x afterRenderRawModule mod_finder () (914.29KB) (4.22%)
    11.22ms
    1 x afterRoute (2.01MB) (4.03%)
    10.73ms
    1 x beforeRenderModule mod_custom (RE-Social NEW) (181.31KB) (4%)
    10.64ms
    1 x afterRenderRawModule mod_menu (Menu oreille) (214.12KB) (1.36%)
    3.60ms
    1 x afterRenderRawModule mod_custom (IRES présentation) (101.92KB) (1.13%)
    3.00ms
    1 x beforeRenderRawModule mod_custom (RE-Social NEW) (82.74KB) (1.04%)
    2.77ms
    1 x afterDispatch (109.51KB) (0.95%)
    2.53ms
    1 x afterRenderRawModule mod_menu (Liste des numéros) (91.64KB) (0.91%)
    2.41ms
    1 x afterRenderComponent com_reco (14.6KB) (0.79%)
    2.10ms
    1 x afterRenderRawModule mod_menu () (33.5KB) (0.69%)
    1.84ms
    1 x afterRenderRawModule mod_finder (Recherche (mobile)) (10.93KB) (0.67%)
    1.78ms
    1 x afterRenderRawModule mod_menu () (3.17KB) (0.52%)
    1.38ms
    1 x afterRenderRawModule mod_menu (Liste des focus) (21.84KB) (0.48%)
    1.29ms
    1 x beforeRenderRawModule mod_custom () (1.17KB) (0.48%)
    1.28ms
    1 x afterRenderRawModule mod_menu (Menu oreille (mobile)) (2.66KB) (0.48%)
    1.27ms
    1 x beforeRenderRawModule mod_menu () (5.48KB) (0.47%)
    1.24ms
    1 x afterRenderRawModule mod_custom (RE-Social NEW (mobile)) (36.64KB) (0.42%)
    1.11ms
    1 x afterRenderModule mod_custom (RE-Social NEW (mobile)) (85.05KB) (0.38%)
    1.01ms
    1 x beforeRenderComponent com_reco (29.4KB) (0.37%)
    991μs
    1 x beforeRenderRawModule mod_menu () (256B) (0.31%)
    829μs
    1 x beforeRenderRawModule mod_custom () (624B) (0.29%)
    774μs
    1 x beforeRenderRawModule mod_custom () (184B) (0.23%)
    601μs
    1 x beforeRenderRawModule mod_custom (Oreille) (2.67KB) (0.18%)
    488μs
    1 x afterRenderRawModule mod_custom (Oreille) (43.36KB) (0.14%)
    377μs
    1 x afterRenderRawModule mod_custom () (1.19KB) (0.14%)
    366μs
    1 x afterRenderRawModule mod_custom () (3.53KB) (0.14%)
    362μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.12%)
    328μs
    1 x beforeRenderRawModule mod_menu (Menu oreille) (43.59KB) (0.12%)
    307μs
    1 x afterRenderModule mod_custom (RE-Social NEW) (1.91KB) (0.06%)
    151μs
    1 x afterRenderModule mod_finder () (4.69KB) (0.06%)
    151μs
    1 x afterRenderRawModule mod_custom (RE-Social NEW) (1.05KB) (0.05%)
    129μs
    1 x afterRenderModule mod_menu (Menu oreille) (3.19KB) (0.05%)
    128μs
    1 x afterRenderModule mod_menu () (3.22KB) (0.05%)
    120μs
    1 x afterRenderModule mod_custom () (1.73KB) (0.04%)
    112μs
    1 x afterRenderModule mod_custom (Oreille) (1.74KB) (0.04%)
    109μs
    1 x afterRenderModule mod_menu () (1.8KB) (0.04%)
    108μs
    1 x afterRenderModule mod_menu (Menu oreille (mobile)) (2.13KB) (0.04%)
    107μs
    1 x afterRenderModule mod_finder (Recherche (mobile)) (2.13KB) (0.04%)
    104μs
    1 x afterRenderRawModule mod_custom (Toolbar-R (UCL)) (976B) (0.04%)
    104μs
    1 x afterRenderModule mod_custom () (2.94KB) (0.04%)
    104μs
    1 x afterRenderModule mod_custom (IRES présentation) (1.76KB) (0.04%)
    100μs
    1 x afterRenderModule mod_custom () (3.41KB) (0.04%)
    100μs
    1 x afterRenderModule mod_custom (Toolbar-R (UCL)) (1.76KB) (0.04%)
    94μs
    1 x afterRenderModule mod_menu (Liste des numéros) (1.76KB) (0.03%)
    84μs
    1 x afterRenderModule mod_menu (Liste des focus) (1.76KB) (0.03%)
    83μs
    1 x afterRenderModule mod_custom (RE-Social NEW (mobile)) (1.76KB) (0.03%)
    81μs
    1 x beforeRenderRawModule mod_menu (Liste des numéros) (2.48KB) (0.01%)
    36μs
    1 x beforeRenderRawModule mod_menu (Liste des focus) (720B) (0.01%)
    35μs
    1 x beforeRenderRawModule mod_custom (IRES présentation) (1.27KB) (0.01%)
    32μs
    1 x beforeRenderModule mod_custom (IRES présentation) (408B) (0.01%)
    32μs
    1 x beforeRenderModule mod_menu (Liste des numéros) (1.62KB) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_custom (Toolbar-R (UCL)) (168B) (0.01%)
    28μs
    1 x beforeRenderModule mod_menu (Liste des focus) (168B) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_menu (Menu oreille (mobile)) (3.07KB) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_finder (Recherche (mobile)) (392B) (0.01%)
    25μs
    1 x beforeRenderModule mod_custom (RE-Social NEW (mobile)) (1.6KB) (0.01%)
    25μs
    3 x beforeRenderModule mod_custom () (704B) (0.01%)
    19μs
    1 x beforeRenderRawModule mod_finder () (2.01KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_finder () (704B) (0%)
    12μs
    2 x beforeRenderModule mod_menu () (696B) (0%)
    11μs
    1 x beforeRenderModule mod_custom (RE-Social NEW (mobile)) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_menu (Menu oreille) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Oreille) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_finder (Recherche (mobile)) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_menu (Menu oreille (mobile)) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Toolbar-R (UCL)) (720B) (0%)
    4μs
50 statements were executed, 9 of which were duplicates, 41 unique20.5ms113.31KB
  • SELECT @@SESSION.sql_mode;155μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `rej_session` WHERE `session_id` = ?396μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `rej_session` WHERE `session_id` = :session_id LIMIT 1202μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `rej_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)362μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `rej_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 11.58ms17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `rej_viewlevels`209μs624B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `rej_usergroups` AS `a` LEFT JOIN `rej_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest288μs1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `rej_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`1.81ms3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `rej_admintools_storage` WHERE `key` = 'cparams'702μs1.15KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `rej_admintools_wafexceptions`142μs640B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `rej_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'241μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT `params` FROM `rej_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'237μs536B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM `rej_admintools_ipautoban`141μs640B/plugins/system/admintools/src/Utility/Cache.php:126Copy
  • SELECT `ip` FROM `rej_admintools_ipblock`153μs520B/plugins/system/admintools/src/Utility/Cache.php:136Copy
  • SELECT * FROM `rej_admintools_storage` WHERE `key` LIKE 'timestamp_%'209μs592B/plugins/system/admintools/src/Feature/Base.php:253Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `rej_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC167μs640B/plugins/system/admintools/src/Utility/Cache.php:162Copy
  • SELECT `value` FROM rej_acym_configuration WHERE `name` = 'level'141μs1.77KB/plugins/system/acymtriggers/acymtriggers.php:643Copy
  • SELECT `value` FROM rej_acym_configuration WHERE `name` = 'active_cron'130μs536B/plugins/system/acymtriggers/acymtriggers.php:643Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `rej_menu` AS `m` LEFT JOIN `rej_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`869μs19.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `rej_template_styles` AS `s` LEFT JOIN `rej_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1650μs16.83KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application` FROM `rej_admintools_wafblacklists` WHERE `enabled` = 1200μs976B/plugins/system/admintools/src/Utility/Cache.php:182Copy
  • SELECT * FROM `rej_languages` WHERE `published` = 1 ORDER BY `ordering` ASC235μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT id FROM rej_reco_articles WHERE id=216 AND state=1178μs536B/components/com_reco/src/Model/ArticleModel.php:45Copy
  • SELECT a.*, GROUP_CONCAT(CONCAT("<a href=\"index.php/auteurs?cid=",c.id,"\">",c.surname," ",c.name,"</a>") ORDER BY c.name ASC SEPARATOR ", ") AS authors FROM rej_reco_articles AS a LEFT JOIN rej_reco_artxaut AS b ON a.id = b.art_id LEFT JOIN rej_reco_auteurs AS c ON b.aut_id = c.id WHERE a.id = 216 AND a.state = 1 GROUP BY a.id792μs2.5KB/components/com_reco/src/Model/ArticleModel.php:33Copy
  • SELECT id FROM rej_reco_articles WHERE id=216 AND state=1155μs536B/components/com_reco/src/Model/ArticleModel.php:45Copy
  • SELECT b.id,b.surname,b.name,b.biocourte FROM rej_reco_artxaut AS a LEFT JOIN rej_reco_auteurs AS b ON b.id = a.aut_id WHERE a.art_id = 216 AND b.state = 1 ORDER BY b.name ASC266μs704B/components/com_reco/src/Model/ArticleModel.php:77Copy
  • SELECT id FROM rej_reco_articles WHERE id=216 AND state=1141μs536B/components/com_reco/src/Model/ArticleModel.php:45Copy
  • SELECT b.id,b.name FROM rej_reco_artxth AS a LEFT JOIN rej_reco_themes AS b ON b.id = a.th_id WHERE a.art_id = 216 AND b.state = 1 ORDER BY b.name ASC285μs592B/components/com_reco/src/Model/ArticleModel.php:100Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `rej_modules` AS `m` LEFT JOIN `rej_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `rej_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)) 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`930μs2.03KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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 rej_fields AS a LEFT JOIN `rej_languages` AS l ON l.lang_code = a.language LEFT JOIN rej_users AS uc ON uc.id=a.checked_out LEFT JOIN rej_viewlevels AS ag ON ag.id = a.access LEFT JOIN rej_users AS ua ON ua.id = a.created_user_id LEFT JOIN rej_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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 ASC739μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `name`,`element` FROM `rej_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1345μs608B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `rej_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)253μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT custom_data FROM rej_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1211μs3.02KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT `title` FROM `rej_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)220μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM rej_acym_configuration813μs4.56KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM rej_acym_list WHERE type = 'standard'246μs1.66KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM rej_acym_field241μs1.69KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM rej_acym_form WHERE active = 1 AND type != 'shortcode'201μs912B/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM rej_jmap_metainfo WHERE `linkurl` = 'https://regards-economiques.be/index.php?cid=216&option=com_reco&view=article' AND `published` = 1227μs912B/plugins/system/jmap/jmap.php:838Copy
  • SELECT * FROM rej_jmap_canonicals WHERE `linkurl` = 'https://regards-economiques.be/index.php?cid=216&option=com_reco&view=article'153μs640B/plugins/system/jmap/jmap.php:968Copy
  • 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 `rej_scheduler_tasks` AS `a` WHERE `a`.`state` = 1205μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `value` FROM rej_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"469μs536B/plugins/system/acymtriggers/acymtriggers.php:434Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"2.65ms3.56KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM rej_acym_plugin240μs1.52KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM rej_acym_plugin222μs1.52KB/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM rej_usergroups AS `groups`205μs1008B/administrator/components/com_acym/Core/joomla/database.php:36Copy
  • SELECT * FROM rej_jmap_headings WHERE `linkurl` = 'https://regards-economiques.be/index.php?cid=216&option=com_reco&view=article'198μs752B/plugins/system/jmap/jmap.php:1192Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `rej_jmap_text_replacements` WHERE `published` = 1182μs688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `session_id` FROM `rej_session` WHERE `session_id` = ?182μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `rej_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?337μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy