par Emmanuel Dupuy, le vendredi 02 mai 2008

Le monde semble découvrir le rôle central de l'agriculture à mesure que s'amplifient les dramatiques "émeutes de la faim" un peu partout dans le monde. L'insécurité alimentaire, pouvant potentiellement "alimenter" des troubles politiques et des désordres sociaux, préalables à d'éventuelles guerres civiles ou rivalités armées entre Etats, comme cela a été mis en exergue dans plusieurs rapports émanant de la Banque mondiale, du FMI, de la FAO et du Centre International de Hautes Agronomiques Méditerranéennes CIHEAM, notamment dans son dernier rapport Mediterra 2008 portant sur les futurs agricoles et alimentaires en Méditerranée. La communauté internationale cherche les bonnes parades...


La conjonction du doublement du prix des denrées alimentaires avec celui du prix du pétrole, d'une crise financière dont les turbulences ne font que débuter et des effets du changement climatique, de l'effet pervers de l'accroissement de la production des biocarburants, rendent la situation dramatiquement explosive.

La mondialisation aurait-elle accouché d'un monstre ? Comment n'avons-nous rien vu venir ? Que peuvent faire les Etats, qui hormis appeler de leur vœux la tenue en toute urgence d'une conférence mondiale sur la sécurité alimentaire des pays fragiles, n'ont guère les moyens de faire face, seuls, à l'ampleur de la crise. Que sont, en effet, les 500 millions dollars de déficit qu'accuse le Programme alimentaire des Nations Unis, au regard des 300 milliards de dollars des fonds souverains, appelés à la rescousse ?

On le voit, la crise va durer et sans doute s'amplifier, des gouvernements seront sans doute déstabilisés, des populations encore plus lésées, des choix politiques, liés aux ajustements structurels, pointés du doigt.

Cet important débat en révèle un autre, celui sur la grave crise de la gouvernance mondiale qui, au moment où seulement 1 personne sur 6 est issue de "l'Occident", ne correspond plus à la réalité géopolitique. La réforme attendue du Conseil de sécurité des Nations, comme du fonctionnement des institutions issues du système de Bretton Woods n'en sont que quelques révélateurs. La pérennisation d'un G-13, plus en conformité que le G-8, avec les dynamiques économiques actuelles en complète le panorama.

La globalisation stratégique s'impose donc à nous avec cette actualité dramatique. Elle semble nous rappeler aussi que "la faim est aussi faite de la main d'homme", comme le prophétise depuis de nombreuses années, le rapporteur spécial de l'ONU pour le droit à l'alimentation, Jean Ziegler…




Emmanuel Dupuy est président Institut Prospective et Sécurité en Europe (IPSE)
http://www.ipse-eu.org


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

 
5MBMemory Usage170msRequest 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/1074-mourir-de-la-faim...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744778591 "last" => 1744778591...
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.15KB) (1.72ms)
  • afterInitialise (1.36MB) (34.19ms)
  • afterRoute (267.88KB) (10.55ms)
  • beforeRenderComponent com_content (153.39KB) (5.23ms)
  • Before Access::preloadComponents (all components) (55.47KB) (576μs)
  • After Access::preloadComponents (all components) (113.89KB) (2.46ms)
  • Before Access::preloadPermissions (com_content) (3.85KB) (19μs)
  • After Access::preloadPermissions (com_content) (811.96KB) (2.97ms)
  • Before Access::getAssetRules (id:1134 name:com_content.article.1074) (66.8KB) (50μs)
  • After Access::getAssetRules (id:1134 name:com_content.article.1074) (10.69KB) (107μs)
  • afterRenderComponent com_content (490.66KB) (36.48ms)
  • afterDispatch (2.25KB) (95μs)
  • beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (335.8KB) (5.06ms)
  • afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (8.09KB) (429μs)
  • beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (24μs)
  • afterRenderRawModule mod_rss_reader_david (PODCAST) (8.77KB) (1.72ms)
  • beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (35μs)
  • Before Access::getAssetRules (id:8 name:com_content) (71.54KB) (672μs)
  • After Access::getAssetRules (id:8 name:com_content) (7.88KB) (55μs)
  • afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (72B) (40.26ms)
  • beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (65μs)
  • afterRenderRawModule mod_menu (Menu principal) (69.02KB) (762μs)
  • beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (45μs)
  • afterRenderRawModule mod_custom (Partenaires) (912B) (73μs)
  • beforeRenderModule mod_custom (Partenaires) (3.13KB) (131μs)
  • afterRenderModule mod_custom (Partenaires) (6.51KB) (94μs)
  • beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (23μs)
  • afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (45μs)
  • beforeRenderModule mod_rss_reader_david (PODCAST) (3.2KB) (14μs)
  • afterRenderModule mod_rss_reader_david (PODCAST) (3.95KB) (23μs)
  • beforeRenderModule mod_articles_category (L'EUROPE DES IDEES...) (6.21KB) (16μs)
  • afterRenderModule mod_articles_category (L'EUROPE DES IDEES...) (5.96KB) (21μs)
  • beforeRenderModule mod_menu (Menu principal) (6.07KB) (34μs)
  • afterRenderModule mod_menu (Menu principal) (5.63KB) (46μs)
  • afterRender (202.98KB) (5.84ms)
  • 1 x afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (72B) (23.74%)
    40.26ms
    1 x afterRenderComponent com_content (490.66KB) (21.51%)
    36.48ms
    1 x afterInitialise (1.36MB) (20.16%)
    34.19ms
    1 x afterRoute (267.88KB) (6.22%)
    10.55ms
    1 x afterRender (202.98KB) (3.45%)
    5.84ms
    1 x beforeRenderComponent com_content (153.39KB) (3.09%)
    5.23ms
    1 x beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (335.8KB) (2.98%)
    5.06ms
    1 x After Access::preloadPermissions (com_content) (811.96KB) (1.75%)
    2.97ms
    1 x After Access::preloadComponents (all components) (113.89KB) (1.45%)
    2.46ms
    1 x afterRenderRawModule mod_rss_reader_david (PODCAST) (8.77KB) (1.02%)
    1.72ms
    1 x afterLoad (568.15KB) (1.01%)
    1.72ms
    1 x afterRenderRawModule mod_menu (Menu principal) (69.02KB) (0.45%)
    762μs
    1 x Before Access::getAssetRules (id:8 name:com_content) (71.54KB) (0.4%)
    672μs
    1 x Before Access::preloadComponents (all components) (55.47KB) (0.34%)
    576μs
    1 x afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (8.09KB) (0.25%)
    429μs
    1 x beforeRenderModule mod_custom (Partenaires) (3.13KB) (0.08%)
    131μs
    1 x After Access::getAssetRules (id:1134 name:com_content.article.1074) (10.69KB) (0.06%)
    107μs
    1 x afterDispatch (2.25KB) (0.06%)
    95μs
    1 x afterRenderModule mod_custom (Partenaires) (6.51KB) (0.06%)
    94μs
    1 x afterRenderRawModule mod_custom (Partenaires) (912B) (0.04%)
    73μs
    1 x beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (0.04%)
    65μs
    1 x After Access::getAssetRules (id:8 name:com_content) (7.88KB) (0.03%)
    55μs
    1 x Before Access::getAssetRules (id:1134 name:com_content.article.1074) (66.8KB) (0.03%)
    50μs
    1 x afterRenderModule mod_menu (Menu principal) (5.63KB) (0.03%)
    46μs
    1 x beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (0.03%)
    45μs
    1 x afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (0.03%)
    45μs
    1 x beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (0.02%)
    35μs
    1 x beforeRenderModule mod_menu (Menu principal) (6.07KB) (0.02%)
    34μs
    1 x beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (0.01%)
    24μs
    1 x beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (0.01%)
    23μs
    1 x afterRenderModule mod_rss_reader_david (PODCAST) (3.95KB) (0.01%)
    23μs
    1 x afterRenderModule mod_articles_category (L'EUROPE DES IDEES...) (5.96KB) (0.01%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%)
    19μs
    1 x beforeRenderModule mod_articles_category (L'EUROPE DES IDEES...) (6.21KB) (0.01%)
    16μs
    1 x beforeRenderModule mod_rss_reader_david (PODCAST) (3.2KB) (0.01%)
    14μs
28 statements were executed, 3 of which were duplicates, 25 unique68.42ms750.56KB
  • SELECT @@SESSION.sql_mode;376μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `ju3mf_session` WHERE `session_id` = ?896μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ju3mf_session` WHERE `session_id` = :session_id LIMIT 1433μ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)2.15ms944BParams/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` = 11.31ms4.73KB/libraries/src/Component/ComponentHelper.php:393Copy
  • SELECT `id`,`rules` FROM `ju3mf_viewlevels`1.76ms1.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` = :guest961μ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.72ms11.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`1.53ms7.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`567μs5.98KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT * FROM `ju3mf_languages` WHERE `published` = 1 ORDER BY `ordering` ASC483μ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` = 1576μ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)880μs10.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` = 01.53ms145.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ju3mf_content`2.6ms10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE `ju3mf_content` SET `hits` = (`hits` + 1) WHERE `id` = '1074'1.84ms48B/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.08ms11.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`733μ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)559μs5.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`735μs6.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 ASC1.04ms6KBParams/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 DESC6.21ms294.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`711μ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`849μ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 535.21ms188.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 ASC836μ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` asc486μ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` asc371μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy