par Philippe Gortych, le mardi 07 octobre 2008

Le 26 septembre dernier, dans le cadre de la Présidence Française de l'Union Européenne (PFUE), les langues du vieux continent étaient en fête. A cette occasion, de très nombreux responsables européens, chefs d'entreprises, traducteurs et journalistes se sont donnés rendez-vous dans le Grand Amphithéâtre de la Sorbonne, où se sont déroulés les Etats généraux du multilinguisme. Multilinguisme pour la compétitivité des entreprises, multilinguisme pour l'identité européenne et multilinguisme pour le dialogue interculturel, tels ont été les thèmes abordés.


Au siècle dernier, Fernand Braudel disait « la culture est la langue commune de l'Europe ». Dans cette affirmation, l'historien français faisait référence à l'ensemble des œuvres de l'esprit européennes telles que les livres, les musiques ou encore les peintures. Des œuvres qui s'exprimaient dans la diversité des langues et des traditions européennes. De nos jours, au fur et à mesure que l'Union européenne s'est élargie, les langues européennes ont continuellement dû répondre à de nouveaux défis.

A ce jour, avec ses 27 Etats membres et ses 495 millions d'habitants, l'Union européenne (U.E.) possède 23 langues officielles dans lesquelles l'intégralité de sa législation est traduite. Au palmarès des langues les plus parlées au sein de l'U.E., on retrouve dans l'ordre l'anglais, le français, l'allemand, l'italien et l'espagnol. Par ailleurs, selon de récentes statistiques on a appris que 56% des citoyens des Etats membres de l'Union européenne se disent capables de participer à une conversation dans une autre langue que leur langue maternelle. Enfin, il faut savoir que l'Union européenne débourse 1% de son budget annuel pour les langues, soit 2,5 euros par an et par habitant.

Toute cette série de données constitue plusieurs enjeux majeurs pour l'Union européenne. Premièrement, du point de vue de l'entreprise : il faut dire que les langues constituent un formidable vecteur de compétitivité pour les entreprises européennes. En effet, 84% des européens estiment que la maîtrise d'une ou plusieurs langues étrangères est très importante dans la vie professionnelle. Deuxièmement, du point de vue de l'identité européenne qui grâce à son multilinguisme, peut s'affirmer face aux autres grandes puissances du monde. Et enfin, troisième et dernière raison pour laquelle le multilinguisme constitue une chance pour l'Europe, c'est sa faculté de contribuer au dialogue interculturel et à la circulation des œuvres.


En définitive, il faut bien dire que le multilinguisme en Europe pourra être avant tout favorisé par l'apprentissage de plusieurs langues étrangères dès le plus jeune âge, comme le pensent 78% des européens. Et dans ce domaine, la France n'est pas un exemple à suivre. Bien que des progrès aient été faits en la matière, il y a encore quelques années, les écoliers français révisaient les jours de la semaine et les couleurs en cours d'anglais à leur entrée au collège, un âge bien trop tardif pour perfectionner les bases élémentaires d'une première langue étrangère.

Faisons vivre nos langues, faisons de nos langues une force, faisons de nos langues une richesse, car comme dit si bien un proverbe slovaque, « plus on connaît de langues, plus on est homme ».


Philippe Gortych est étudaint en relations internationales

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

 
18MBMemory Usage492msRequest 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/1137-le-multilinguisme...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743948948 "last" => 1743948948...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (4.18MB) (55.61ms)
  • afterInitialise (5.63MB) (124ms)
  • afterRoute (1.04MB) (38.14ms)
  • beforeRenderComponent com_content (997.03KB) (30.04ms)
  • Before Access::preloadComponents (all components) (509.53KB) (6.38ms)
  • After Access::preloadComponents (all components) (113.89KB) (6.06ms)
  • Before Access::preloadPermissions (com_content) (4.59KB) (12μs)
  • After Access::preloadPermissions (com_content) (811.96KB) (5.51ms)
  • Before Access::getAssetRules (id:1197 name:com_content.article.1137) (67.17KB) (37μs)
  • After Access::getAssetRules (id:1197 name:com_content.article.1137) (28.8KB) (672μs)
  • afterRenderComponent com_content (1.71MB) (78.86ms)
  • afterDispatch (2.25KB) (79μs)
  • beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (630.17KB) (17.36ms)
  • afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (37.88KB) (4.12ms)
  • beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (26μs)
  • afterRenderRawModule mod_rss_reader_david (PODCAST) (68.7KB) (4.16ms)
  • beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (31μs)
  • Before Access::getAssetRules (id:8 name:com_content) (295.02KB) (3.26ms)
  • After Access::getAssetRules (id:8 name:com_content) (7.88KB) (48μs)
  • afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (53.52KB) (50.26ms)
  • beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (69μs)
  • afterRenderRawModule mod_menu (Menu principal) (137.16KB) (4.22ms)
  • beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (57μs)
  • afterRenderRawModule mod_custom (Partenaires) (912B) (117μs)
  • beforeRenderModule mod_custom (Partenaires) (34.73KB) (939μs)
  • afterRenderModule mod_custom (Partenaires) (6.62KB) (649μs)
  • beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (31μs)
  • afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (76μs)
  • beforeRenderModule mod_rss_reader_david (PODCAST) (3.2KB) (15μs)
  • afterRenderModule mod_rss_reader_david (PODCAST) (3.95KB) (60μs)
  • beforeRenderModule mod_articles_category (L'EUROPE DES IDEES...) (6.21KB) (21μs)
  • afterRenderModule mod_articles_category (L'EUROPE DES IDEES...) (5.96KB) (56μs)
  • beforeRenderModule mod_menu (Menu principal) (6.07KB) (43μs)
  • afterRenderModule mod_menu (Menu principal) (5.73KB) (487μs)
  • afterRender (586.29KB) (26.83ms)
  • 1 x afterInitialise (5.63MB) (25.22%)
    124.03ms
    1 x afterRenderComponent com_content (1.71MB) (16.03%)
    78.86ms
    1 x afterLoad (4.18MB) (11.31%)
    55.61ms
    1 x afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (53.52KB) (10.22%)
    50.26ms
    1 x afterRoute (1.04MB) (7.75%)
    38.14ms
    1 x beforeRenderComponent com_content (997.03KB) (6.11%)
    30.04ms
    1 x afterRender (586.29KB) (5.45%)
    26.83ms
    1 x beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (630.17KB) (3.53%)
    17.36ms
    1 x Before Access::preloadComponents (all components) (509.53KB) (1.3%)
    6.38ms
    1 x After Access::preloadComponents (all components) (113.89KB) (1.23%)
    6.06ms
    1 x After Access::preloadPermissions (com_content) (811.96KB) (1.12%)
    5.51ms
    1 x afterRenderRawModule mod_menu (Menu principal) (137.16KB) (0.86%)
    4.22ms
    1 x afterRenderRawModule mod_rss_reader_david (PODCAST) (68.7KB) (0.85%)
    4.16ms
    1 x afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (37.88KB) (0.84%)
    4.12ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (295.02KB) (0.66%)
    3.26ms
    1 x beforeRenderModule mod_custom (Partenaires) (34.73KB) (0.19%)
    939μs
    1 x After Access::getAssetRules (id:1197 name:com_content.article.1137) (28.8KB) (0.14%)
    672μs
    1 x afterRenderModule mod_custom (Partenaires) (6.62KB) (0.13%)
    649μs
    1 x afterRenderModule mod_menu (Menu principal) (5.73KB) (0.1%)
    487μs
    1 x afterRenderRawModule mod_custom (Partenaires) (912B) (0.02%)
    117μs
    1 x afterDispatch (2.25KB) (0.02%)
    79μs
    1 x afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (0.02%)
    76μs
    1 x beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (0.01%)
    69μs
    1 x afterRenderModule mod_rss_reader_david (PODCAST) (3.95KB) (0.01%)
    60μs
    1 x beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (0.01%)
    57μs
    1 x afterRenderModule mod_articles_category (L'EUROPE DES IDEES...) (5.96KB) (0.01%)
    56μs
    1 x After Access::getAssetRules (id:8 name:com_content) (7.88KB) (0.01%)
    48μs
    1 x beforeRenderModule mod_menu (Menu principal) (6.07KB) (0.01%)
    43μs
    1 x Before Access::getAssetRules (id:1197 name:com_content.article.1137) (67.17KB) (0.01%)
    37μs
    1 x beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (0.01%)
    31μs
    1 x beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (0.01%)
    31μs
    1 x beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (0.01%)
    26μs
    1 x beforeRenderModule mod_articles_category (L'EUROPE DES IDEES...) (6.21KB) (0%)
    21μs
    1 x beforeRenderModule mod_rss_reader_david (PODCAST) (3.2KB) (0%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (4.59KB) (0%)
    12μs
28 statements were executed, 3 of which were duplicates, 25 unique87.48ms750.56KB
  • SELECT @@SESSION.sql_mode;385μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `ju3mf_session` WHERE `session_id` = ?1.53ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ju3mf_session` WHERE `session_id` = :session_id LIMIT 1475μ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.33ms944BParams/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` = 1847μs4.73KB/libraries/src/Component/ComponentHelper.php:393Copy
  • SELECT `id`,`rules` FROM `ju3mf_viewlevels`358μ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` = :guest602μ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.4ms11.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.05ms7.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`1.03ms5.98KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT * FROM `ju3mf_languages` WHERE `published` = 1 ORDER BY `ordering` ASC611μ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` = 12.43ms1.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)2.24ms10.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` = 04.26ms145.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ju3mf_content`4.64ms10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE `ju3mf_content` SET `hits` = (`hits` + 1) WHERE `id` = '1137'1.47ms48B/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)2.04ms11.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`1.01ms6.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)711μ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`1.14ms6.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.4ms6KBParams/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 DESC9.49ms294.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`783μ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`1.53ms2.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 541.92ms188.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 ASC731μ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` asc468μ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` asc620μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy