par Christian Capmas, le lundi 09 janvier 2012

Le projet de TVA, dite sociale, consiste, pour l'essentiel, à supprimer la cotisation patronale sur les salaires, versée à la Caisse Nationale des Allocations Familiales (CNAF). Le taux de cotisation sur le salaire brut s'établit à 5,4%, entièrement à la charge de l'employeur. Les non salariés (artisans, commerçants, professions libérales) y sont assujettis, au même taux, sur la base de leur revenu professionnel imposable.


Au titre de 2011, les prévisions de recettes du régime général, en cotisations, s'élèvent à 181 milliards € et ce toutes branches confondues, dont 144,19 milliards € pour la part patronale.

Pour la CNAF, les cotisations patronales sur les salaires s'établissent à 30, 248 milliards €, soit près de 21 % de la totalité des cotisations employeurs au régime général. Celles des non salariés représentent prés de 4 milliards €.
Les recettes prévisionnelles 2011 en TVA , du budget de l'Etat, s'élèvent à 131 milliards €, soit 48% des recettes totales de 272 milliards €.

Un transfert intégral des cotisations à destination de la CNAF entrainerait une hausse mécanique des recettes de TVA de26 %. Une application automatique ferait passer les taux de 5,5%, 7% et 19.6%, respectivement à 6.94%, 8.26% et 24.72 %.

Les effets induits mécaniques, dont étrangement personne ne parle, seraient une hausse des recettes de l'Etat aux titres de l'impôt sur les sociétés et de l'impôt sur le revenu des non salariés.

En effet, les cotisations sont des charges déductibles pour la détermination du bénéfice fiscal. Avec un taux d'Impôt sur les sociétés à 33%, 30 milliards € de baisse des charges entrainerait une hausse des rentrées, au titre de cet impôt, de 10 milliards €. Cela représente 22% des recettes prévisionnelles 2011 à ce titre.

Pour les non salariés, sur la base du taux médian du barême de l'impôt sur le revenu, soit 14%, l'augmentation des recettes de l'Etat serait de 560 millions €, soi 1% de hausse des recettes de l'I.R.P.P.

Ces hausses toucheront tant les importations que les productions nationales. 1% de hausse de TVA génère 0,4 % d'inflation, l'application mécanique se traduira par une dose d'inflation supplémentaire de 1,6%. Ajoutée à l'inflation actuelle de 2,5%, sur la base du taux de 11/2011, elle avoisinera les 4% entrainant un inévitable recul du pouvoir d'achat.

Concernant les importations des pays à bas coûts de main d'oeuvre, l'effet sera négligeable. Un teeshirt vendu T.T.C. à 10 € passerait à 10,48 €.
Cela aurait les mêmes conséquences qu'un cours de l'Euro à 1.24 Dollar US, au lieu de 1.28 actuellement, sur les biens importés hors produits pétroliers. Pas de quoi rapatrier des usines en urgenc


Ch.CAPMAS est ancien Directeur général adjoint d'une Banque cotée en bourse de Paris

Organisations en lien avec Fenêtre sur l'Europe :

 
5MBMemory Usage162msRequest Duration
Joomla! Version4.2.8
PHP Version8.0.30
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
8.0.41-32
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:67 [ "USER" => "fsmkhtwp" "PATH_TRANSLATED" => "redirect:/index.php/245-tva-dite-sociale" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743786036 "last" => 1743786036...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (568.23KB) (1.58ms)
  • afterInitialise (1.36MB) (26.94ms)
  • afterRoute (267.8KB) (8.12ms)
  • beforeRenderComponent com_content (153.47KB) (7.76ms)
  • Before Access::preloadComponents (all components) (55.46KB) (480μs)
  • After Access::preloadComponents (all components) (113.89KB) (3.24ms)
  • Before Access::preloadPermissions (com_content) (3.85KB) (14μs)
  • After Access::preloadPermissions (com_content) (811.96KB) (3.15ms)
  • Before Access::getAssetRules (id:305 name:com_content.article.245) (66.8KB) (34μs)
  • After Access::getAssetRules (id:305 name:com_content.article.245) (10.69KB) (92μs)
  • afterRenderComponent com_content (489.1KB) (41.51ms)
  • afterDispatch (2.25KB) (93μs)
  • beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (337.28KB) (6.33ms)
  • afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (8.09KB) (449μs)
  • beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (27μs)
  • afterRenderRawModule mod_rss_reader_david (PODCAST) (8.77KB) (1.4ms)
  • beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (29μs)
  • Before Access::getAssetRules (id:8 name:com_content) (71.54KB) (690μs)
  • After Access::getAssetRules (id:8 name:com_content) (7.88KB) (40μs)
  • afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (8B) (35.33ms)
  • beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (84μs)
  • afterRenderRawModule mod_menu (Menu principal) (69.02KB) (882μs)
  • beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (67μs)
  • afterRenderRawModule mod_custom (Partenaires) (912B) (104μs)
  • beforeRenderModule mod_custom (Partenaires) (3.13KB) (148μs)
  • afterRenderModule mod_custom (Partenaires) (6.51KB) (85μs)
  • beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (21μs)
  • afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (29μs)
  • beforeRenderModule mod_rss_reader_david (PODCAST) (3.2KB) (13μs)
  • afterRenderModule mod_rss_reader_david (PODCAST) (3.95KB) (27μs)
  • beforeRenderModule mod_articles_category (L'EUROPE DES IDEES...) (6.21KB) (27μs)
  • afterRenderModule mod_articles_category (L'EUROPE DES IDEES...) (5.96KB) (35μs)
  • beforeRenderModule mod_menu (Menu principal) (6.07KB) (55μs)
  • afterRenderModule mod_menu (Menu principal) (5.63KB) (69μs)
  • afterRender (203.06KB) (5.93ms)
  • 1 x afterRenderComponent com_content (489.1KB) (25.65%)
    41.51ms
    1 x afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (8B) (21.83%)
    35.33ms
    1 x afterInitialise (1.36MB) (16.65%)
    26.94ms
    1 x afterRoute (267.8KB) (5.02%)
    8.12ms
    1 x beforeRenderComponent com_content (153.47KB) (4.8%)
    7.76ms
    1 x beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (337.28KB) (3.91%)
    6.33ms
    1 x afterRender (203.06KB) (3.67%)
    5.93ms
    1 x After Access::preloadComponents (all components) (113.89KB) (2.01%)
    3.24ms
    1 x After Access::preloadPermissions (com_content) (811.96KB) (1.95%)
    3.15ms
    1 x afterLoad (568.23KB) (0.98%)
    1.58ms
    1 x afterRenderRawModule mod_rss_reader_david (PODCAST) (8.77KB) (0.87%)
    1.40ms
    1 x afterRenderRawModule mod_menu (Menu principal) (69.02KB) (0.55%)
    882μs
    1 x Before Access::getAssetRules (id:8 name:com_content) (71.54KB) (0.43%)
    690μs
    1 x Before Access::preloadComponents (all components) (55.46KB) (0.3%)
    480μs
    1 x afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (8.09KB) (0.28%)
    449μs
    1 x beforeRenderModule mod_custom (Partenaires) (3.13KB) (0.09%)
    148μs
    1 x afterRenderRawModule mod_custom (Partenaires) (912B) (0.06%)
    104μs
    1 x afterDispatch (2.25KB) (0.06%)
    93μs
    1 x After Access::getAssetRules (id:305 name:com_content.article.245) (10.69KB) (0.06%)
    92μs
    1 x afterRenderModule mod_custom (Partenaires) (6.51KB) (0.05%)
    85μs
    1 x beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (0.05%)
    84μs
    1 x afterRenderModule mod_menu (Menu principal) (5.63KB) (0.04%)
    69μs
    1 x beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (0.04%)
    67μs
    1 x beforeRenderModule mod_menu (Menu principal) (6.07KB) (0.03%)
    55μs
    1 x After Access::getAssetRules (id:8 name:com_content) (7.88KB) (0.02%)
    40μs
    1 x afterRenderModule mod_articles_category (L'EUROPE DES IDEES...) (5.96KB) (0.02%)
    35μs
    1 x Before Access::getAssetRules (id:305 name:com_content.article.245) (66.8KB) (0.02%)
    34μs
    1 x beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (0.02%)
    29μs
    1 x afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (0.02%)
    29μs
    1 x afterRenderModule mod_rss_reader_david (PODCAST) (3.95KB) (0.02%)
    27μs
    1 x beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (0.02%)
    27μs
    1 x beforeRenderModule mod_articles_category (L'EUROPE DES IDEES...) (6.21KB) (0.02%)
    27μs
    1 x beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (0.01%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%)
    14μs
    1 x beforeRenderModule mod_rss_reader_david (PODCAST) (3.2KB) (0.01%)
    13μs
28 statements were executed, 3 of which were duplicates, 25 unique65.66ms750.56KB
  • SELECT @@SESSION.sql_mode;502μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `ju3mf_session` WHERE `session_id` = ?759μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ju3mf_session` WHERE `session_id` = :session_id LIMIT 1781μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ju3mf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.63ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ju3mf_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1837μs4.73KB/libraries/src/Component/ComponentHelper.php:393Copy
  • SELECT `id`,`rules` FROM `ju3mf_viewlevels`303μs1.11KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ju3mf_usergroups` AS `a` LEFT JOIN `ju3mf_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest488μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ju3mf_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.47ms11.8KBParams/libraries/src/Plugin/PluginHelper.php:283Copy
  • 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 `ju3mf_menu` AS `m` LEFT JOIN `ju3mf_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`670μs7.89KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `ju3mf_categories` AS `s` INNER JOIN `ju3mf_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`719μs5.98KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT * FROM `ju3mf_languages` WHERE `published` = 1 ORDER BY `ordering` ASC689μs2.67KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ju3mf_template_styles` AS `s` LEFT JOIN `ju3mf_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` = 1641μs1.33KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ju3mf_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)1.08ms10.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ju3mf_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 02.18ms145.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ju3mf_content`3.68ms10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE `ju3mf_content` SET `hits` = (`hits` + 1) WHERE `id` = '245'1.3ms48B/libraries/src/Table/Table.php:1320Copy
  • 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 `ju3mf_content` AS `a` INNER JOIN `ju3mf_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ju3mf_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ju3mf_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ju3mf_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ju3mf_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)1.25ms11.88KBParams/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 `ju3mf_categories` AS `s` INNER JOIN `ju3mf_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`724μs6.03KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ju3mf_contentitem_tag_map` AS `m` INNER JOIN `ju3mf_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)1.55ms5.22KBParams/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 `ju3mf_categories` AS `s` INNER JOIN `ju3mf_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`1.01ms6.03KBParams/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 ju3mf_fields AS a LEFT JOIN `ju3mf_languages` AS l ON l.lang_code = a.language LEFT JOIN ju3mf_users AS uc ON uc.id=a.checked_out LEFT JOIN ju3mf_viewlevels AS ag ON ag.id = a.access LEFT JOIN ju3mf_users AS ua ON ua.id = a.created_user_id LEFT JOIN ju3mf_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ju3mf_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 ASC829μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • 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 `ju3mf_content` AS `a` LEFT JOIN `ju3mf_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 DESC8.53ms294.03KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • 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 `ju3mf_categories` AS `s` INNER JOIN `ju3mf_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`889μs6.03KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ju3mf_modules` AS `m` LEFT JOIN `ju3mf_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ju3mf_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`921μs2.83KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • 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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `ju3mf_content` AS `a` LEFT JOIN `ju3mf_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ju3mf_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `ju3mf_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `ju3mf_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ju3mf_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ju3mf_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY publish_up DESC LIMIT 530.37ms188.92KBParams/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 ju3mf_fields AS a LEFT JOIN `ju3mf_languages` AS l ON l.lang_code = a.language LEFT JOIN ju3mf_users AS uc ON uc.id=a.checked_out LEFT JOIN ju3mf_viewlevels AS ag ON ag.id = a.access LEFT JOIN ju3mf_users AS ua ON ua.id = a.created_user_id LEFT JOIN ju3mf_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC931μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • 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 `ju3mf_scheduler_tasks` AS `a` LEFT JOIN `ju3mf_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc483μs4.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 `ju3mf_scheduler_tasks` AS `a` LEFT JOIN `ju3mf_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc446μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy