par Fréderic Greiner, le samedi 05 décembre 2009

L'ARE (Assemblée des régions d'Europe) a tenu son AG à Belfort, au siège de GE Energy Europe. Ensemble, ils ont lancé l'"Appel de Belfort" en vue de Copenhague. Fréderic Greiner, commercial operations manager de GE Energy Europe, Afrique et Inde et Moyen-Orient, a pris le temps de répondre aux questions de Samir Mathieu. Il présente entre autre le "smart grid" ou réseaux intelligents.


Fréderic Greiner est à la tête d'une équipe de commerciaux à Belfort et à travers toute l'Europe qui vend les produits GE Energy. Il est plus précisément le commercial operations manager de GE Energy sur l'Europe, l'Afrique, l'Inde et Middle East.


Quels produits commercialisez-vous ?


Le spectre d'activités est large. Tout d'abord, l'ensemble de nos produits est livré clé en mains. Nous proposons notre savoir-faire pour les énergies solaires, éoliennes. Mais nous avons aussi développés des produits phares comme des centrales de charbon propres, ou encore les turbines à gaz, produites ici à Belfort.


Quels sont les réseaux intelligents ?


Nous parlons pour ça de "smart grid". Nous développons les réseaux intelligents, tout simplement pour pallier les variations des énergies renouvelables.

Nous comptons donc avec ce système, optimiser la sécurité de l'approvisionnement aux niveaux de particuliers, collectivités locales, régions et même pour un pays.

L'utilisation de l'énergie se fait sur l'ensemble d'un réseau.


Dans quel cadre rentre votre partenariat avec les régions ?


Nous leur apportons notre expertise. Que ce soit à travers, de façon globale, nos réseaux intelligents. Mais nous offrons des solutions pour l'ensemble des acteurs européens : particuliers, régions, industriels.

Nous avons un portefeuille de produits (bois, déchets dynamiques, éolien, solaire) vaste. Nous proposons ainsi une mixité de portefeuilles, de moyens d'énergie.

Nous sommes en fait un laboratoire de consultants. Nous développons des moyens de production.


Vous vous voulez donc à la pointe de la recherche ?


Oui ! Nous développons en permanence notre portefeuille de produits pour améliorer les rendements. En Autriche, nous fabriquons les moteurs gaz. En Allemagne, c'est principalement l'éolien. Pour chaque produit, nous avons des solutions. C'est ça la mixité de l'offre, l'avenir.

Nous avons mis au point la production de charbon propre. Tout ça grâce à des centrales combinées. Nous séquestrons le carbone avant sa combustion, au cours de la pré-combustion. Nous avons des projets pour le charbon propre en Angleterre, en Allemagne et dans les pays nordiques.

Nous avons aussi mis en place l'IGCC Integrated gazification combustion carbone.

Aujourd'hui on marque notre empreinte énergétique. Il faut qu'elle devienne rentable. Et sur le plan industriel, nous tablons sur après 2020.

Samir Mathieu


http://www.ge.com

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

 
5MBMemory Usage160msRequest 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/1013-energie-frederic-...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744250628 "last" => 1744250628...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (569.2KB) (1.54ms)
  • afterInitialise (1.36MB) (36.01ms)
  • afterRoute (267.68KB) (8.26ms)
  • beforeRenderComponent com_content (153.47KB) (12.05ms)
  • Before Access::preloadComponents (all components) (55.47KB) (448μs)
  • After Access::preloadComponents (all components) (112.33KB) (2.23ms)
  • Before Access::preloadPermissions (com_content) (3.85KB) (13μs)
  • After Access::preloadPermissions (com_content) (811.88KB) (2.15ms)
  • Before Access::getAssetRules (id:1073 name:com_content.article.1013) (66.8KB) (33μs)
  • After Access::getAssetRules (id:1073 name:com_content.article.1013) (10.69KB) (75μs)
  • afterRenderComponent com_content (489.86KB) (30.85ms)
  • afterDispatch (2.25KB) (74μs)
  • beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (335.65KB) (4.38ms)
  • afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (8.09KB) (328μs)
  • beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (17μs)
  • afterRenderRawModule mod_rss_reader_david (PODCAST) (8.77KB) (1.1ms)
  • beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (27μs)
  • Before Access::getAssetRules (id:8 name:com_content) (71.54KB) (507μs)
  • After Access::getAssetRules (id:8 name:com_content) (7.88KB) (28μs)
  • afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (536B) (43.23ms)
  • beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (62μs)
  • afterRenderRawModule mod_menu (Menu principal) (69.02KB) (668μs)
  • beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (41μs)
  • afterRenderRawModule mod_custom (Partenaires) (912B) (71μs)
  • beforeRenderModule mod_custom (Partenaires) (3.13KB) (110μs)
  • afterRenderModule mod_custom (Partenaires) (6.51KB) (82μs)
  • beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (18μs)
  • afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (28μs)
  • beforeRenderModule mod_rss_reader_david (PODCAST) (3.2KB) (13μ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) (22μs)
  • beforeRenderModule mod_menu (Menu principal) (6.07KB) (34μs)
  • afterRenderModule mod_menu (Menu principal) (5.63KB) (47μs)
  • afterRender (210.99KB) (5.5ms)
  • 1 x afterRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (536B) (27%)
    43.23ms
    1 x afterInitialise (1.36MB) (22.5%)
    36.01ms
    1 x afterRenderComponent com_content (489.86KB) (19.27%)
    30.85ms
    1 x beforeRenderComponent com_content (153.47KB) (7.53%)
    12.05ms
    1 x afterRoute (267.68KB) (5.16%)
    8.26ms
    1 x afterRender (210.99KB) (3.44%)
    5.50ms
    1 x beforeRenderRawModule mod_custom (RESEAUX SOCIAUX ) (335.65KB) (2.74%)
    4.38ms
    1 x After Access::preloadComponents (all components) (112.33KB) (1.39%)
    2.23ms
    1 x After Access::preloadPermissions (com_content) (811.88KB) (1.34%)
    2.15ms
    1 x afterLoad (569.2KB) (0.96%)
    1.54ms
    1 x afterRenderRawModule mod_rss_reader_david (PODCAST) (8.77KB) (0.68%)
    1.10ms
    1 x afterRenderRawModule mod_menu (Menu principal) (69.02KB) (0.42%)
    668μs
    1 x Before Access::getAssetRules (id:8 name:com_content) (71.54KB) (0.32%)
    507μs
    1 x Before Access::preloadComponents (all components) (55.47KB) (0.28%)
    448μs
    1 x afterRenderRawModule mod_custom (RESEAUX SOCIAUX ) (8.09KB) (0.2%)
    328μs
    1 x beforeRenderModule mod_custom (Partenaires) (3.13KB) (0.07%)
    110μs
    1 x afterRenderModule mod_custom (Partenaires) (6.51KB) (0.05%)
    82μs
    1 x After Access::getAssetRules (id:1073 name:com_content.article.1013) (10.69KB) (0.05%)
    75μs
    1 x afterDispatch (2.25KB) (0.05%)
    74μs
    1 x afterRenderRawModule mod_custom (Partenaires) (912B) (0.04%)
    71μs
    1 x beforeRenderRawModule mod_menu (Menu principal) (5.09KB) (0.04%)
    62μs
    1 x afterRenderModule mod_menu (Menu principal) (5.63KB) (0.03%)
    47μs
    1 x beforeRenderRawModule mod_custom (Partenaires) (1.17KB) (0.03%)
    41μs
    1 x beforeRenderModule mod_menu (Menu principal) (6.07KB) (0.02%)
    34μs
    1 x Before Access::getAssetRules (id:1073 name:com_content.article.1013) (66.8KB) (0.02%)
    33μs
    1 x afterRenderModule mod_custom (RESEAUX SOCIAUX ) (2.95KB) (0.02%)
    28μs
    1 x After Access::getAssetRules (id:8 name:com_content) (7.88KB) (0.02%)
    28μs
    1 x beforeRenderRawModule mod_articles_category (L'EUROPE DES IDEES...) (5.27KB) (0.02%)
    27μ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%)
    22μs
    1 x beforeRenderModule mod_custom (RESEAUX SOCIAUX ) (16B) (0.01%)
    18μs
    1 x beforeRenderRawModule mod_rss_reader_david (PODCAST) (4.25KB) (0.01%)
    17μs
    1 x beforeRenderModule mod_articles_category (L'EUROPE DES IDEES...) (6.21KB) (0.01%)
    16μs
    1 x Before Access::preloadPermissions (com_content) (3.85KB) (0.01%)
    13μ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 unique73.83ms750.56KB
  • SELECT @@SESSION.sql_mode;236μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `ju3mf_session` WHERE `session_id` = ?1.05ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `ju3mf_session` WHERE `session_id` = :session_id LIMIT 1796μ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)5.86ms944BParams/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` = 13.79ms4.73KB/libraries/src/Component/ComponentHelper.php:393Copy
  • SELECT `id`,`rules` FROM `ju3mf_viewlevels`392μ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` = :guest1.06ms1.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.55ms11.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`657μ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`1.05ms5.98KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT * FROM `ju3mf_languages` WHERE `published` = 1 ORDER BY `ordering` ASC415μ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` = 1414μ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)768μ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.3ms145.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ju3mf_content`2.45ms10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE `ju3mf_content` SET `hits` = (`hits` + 1) WHERE `id` = '1013'1.32ms48B/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)984μs11.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`788μ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)480μ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`645μ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 ASC790μ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 DESC5.55ms294.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`631μ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`724μ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 538.47ms188.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 ASC877μ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` asc415μ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` asc358μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy