zamiren bleuU

Power Grid Experts - Interoperability - Standards CEI 61968 61970 61850 62325 63110

Vedecom/Renault have proposed to Zamiren to study architectural alternatives for the management of ChargingStations.

The goal was to build an end-to-end model based on the IEC61850 standard in order to measure its feasibility and to have an instrument to study different alternatives.

This approach for the first mock-up is summarized by the following figure here , its implementation achitecture is summarized here

In this first mock-up the vehicle was connected using an IED.

The second mock-up evolved the implementation in two directions:

for more realism, the raspberrys, embarking the simulation of the vehicles, have been physically conected by cables to the raspberrys embarking the simulation of the EVSEs
IEC61850 modelling has evolved from that of IEC61850-90-8 DTR to that of IEC61850-420, that is to say to DER.

A series of slides shows the approach of this second model and are visible here

A series of videos show different aspects of the model’s use.

Two use-case scenarios are followed for the demonstrations:

Scenario 1 is a V2G scenario. It involves 3 vehicles having reserved the EVSEs of a ChargingStation and having previously registered in the CSMS energy offers negotiated beforehand with a flexibility operator (negotiation outside the scope of the demonstration) which proceed to a discharge. Its sequence diagram is visible here
Scenario 2 is a "smart charging" scenario. It involves 3 vehicles. One of the vehicles has reserved an EVSE, the others arrive spontaneously. The scenario simulates a network hazard limiting the load possibilities. Its sequence diagram is visible here

The demo videos of the mock-up 2 are accessible through the mock-up 2 menu

Settings22.517MBMemory Usage508msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.2
PHP Version8.1.32
Identityguest
Response200
Templatebasic2
Database
Server
mysql
Version
8.0.42-33
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:61 [ "USER" => "zamiren" "PATH_TRANSLATED" => "/homez.422/zamiren/zamiren/en/mock-up/mock-...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1752719069 "last" => 1752719069...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (3.49MB) (41.44ms)
  • afterInitialise (7.9MB) (150ms)
  • afterRoute (1.21MB) (10.71ms)
  • beforeRenderComponent com_content (1.12MB) (24.71ms)
  • Before Access::preloadComponents (all components) (935.53KB) (18.94ms)
  • After Access::preloadComponents (all components) (142.34KB) (4.76ms)
  • Before Access::preloadPermissions (com_content) (3.98KB) (18μs)
  • After Access::preloadPermissions (com_content) (42.51KB) (826μs)
  • Before Access::getAssetRules (id:258 name:com_content.article.50) (6.8KB) (15μs)
  • After Access::getAssetRules (id:258 name:com_content.article.50) (28.66KB) (679μs)
  • Before Access::getAssetRules (id:8 name:com_content) (763.03KB) (17.96ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (11μs)
  • afterRenderComponent com_content (1.87MB) (66.93ms)
  • afterDispatch (242.78KB) (4.94ms)
  • beforeRenderRawModule mod_custom (Bas) (700.45KB) (13.86ms)
  • afterRenderRawModule mod_custom (Bas) (103.41KB) (3.65ms)
  • beforeRenderModule mod_custom (Bas) (704B) (6μs)
  • afterRenderModule mod_custom (Bas) (17.37KB) (1.39ms)
  • beforeRenderRawModule mod_breadcrumbs (Fil de navigation) (3.38KB) (55μs)
  • afterRenderRawModule mod_breadcrumbs (Fil de navigation) (48.31KB) (3.89ms)
  • beforeRenderModule mod_breadcrumbs (Fil de navigation) (704B) (6μs)
  • afterRenderModule mod_breadcrumbs (Fil de navigation) (3.42KB) (269μs)
  • beforeRenderRawModule mod_maximenuck (menu en) (30.97KB) (65μs)
  • afterRenderRawModule mod_maximenuck (menu en) (2.73MB) (46.01ms)
  • beforeRenderModule mod_maximenuck (menu en) (720B) (8μs)
  • afterRenderModule mod_maximenuck (menu en) (18.42KB) (270μs)
  • beforeRenderRawModule mod_languages (Language) (26.23KB) (69μs)
  • afterRenderRawModule mod_languages (Language) (33.96KB) (3.1ms)
  • beforeRenderModule mod_languages (Language) (704B) (5μs)
  • afterRenderModule mod_languages (Language) (3.69KB) (168μs)
  • beforeRenderRawModule mod_custom (haut_en) (632B) (47μs)
  • afterRenderRawModule mod_custom (haut_en) (992B) (93μs)
  • beforeRenderModule mod_custom (haut_en) (704B) (3μs)
  • afterRenderModule mod_custom (haut_en) (5.41KB) (141μs)
  • afterRender (740.98KB) (91.84ms)
  • 1 x afterInitialise (7.9MB) (29.42%)
    150ms
    1 x afterRender (740.98KB) (18.07%)
    91.84ms
    1 x afterRenderComponent com_content (1.87MB) (13.17%)
    66.93ms
    1 x afterRenderRawModule mod_maximenuck (menu en) (2.73MB) (9.05%)
    46.01ms
    1 x afterLoad (3.49MB) (8.15%)
    41.44ms
    1 x beforeRenderComponent com_content (1.12MB) (4.86%)
    24.71ms
    1 x Before Access::preloadComponents (all components) (935.53KB) (3.73%)
    18.94ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (763.03KB) (3.53%)
    17.96ms
    1 x beforeRenderRawModule mod_custom (Bas) (700.45KB) (2.73%)
    13.86ms
    1 x afterRoute (1.21MB) (2.11%)
    10.71ms
    1 x afterDispatch (242.78KB) (0.97%)
    4.94ms
    1 x After Access::preloadComponents (all components) (142.34KB) (0.94%)
    4.76ms
    1 x afterRenderRawModule mod_breadcrumbs (Fil de navigation) (48.31KB) (0.77%)
    3.89ms
    1 x afterRenderRawModule mod_custom (Bas) (103.41KB) (0.72%)
    3.65ms
    1 x afterRenderRawModule mod_languages (Language) (33.96KB) (0.61%)
    3.10ms
    1 x afterRenderModule mod_custom (Bas) (17.37KB) (0.27%)
    1.39ms
    1 x After Access::preloadPermissions (com_content) (42.51KB) (0.16%)
    826μs
    1 x After Access::getAssetRules (id:258 name:com_content.article.50) (28.66KB) (0.13%)
    679μs
    1 x afterRenderModule mod_maximenuck (menu en) (18.42KB) (0.05%)
    270μs
    1 x afterRenderModule mod_breadcrumbs (Fil de navigation) (3.42KB) (0.05%)
    269μs
    1 x afterRenderModule mod_languages (Language) (3.69KB) (0.03%)
    168μs
    1 x afterRenderModule mod_custom (haut_en) (5.41KB) (0.03%)
    141μs
    1 x afterRenderRawModule mod_custom (haut_en) (992B) (0.02%)
    93μs
    1 x beforeRenderRawModule mod_languages (Language) (26.23KB) (0.01%)
    69μs
    1 x beforeRenderRawModule mod_maximenuck (menu en) (30.97KB) (0.01%)
    65μs
    1 x beforeRenderRawModule mod_breadcrumbs (Fil de navigation) (3.38KB) (0.01%)
    55μs
    1 x beforeRenderRawModule mod_custom (haut_en) (632B) (0.01%)
    47μs
    1 x Before Access::preloadPermissions (com_content) (3.98KB) (0%)
    18μs
    1 x Before Access::getAssetRules (id:258 name:com_content.article.50) (6.8KB) (0%)
    15μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0%)
    11μs
    1 x beforeRenderModule mod_maximenuck (menu en) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Bas) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_breadcrumbs (Fil de navigation) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_languages (Language) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (haut_en) (704B) (0%)
    3μs
32 statements were executed, 4 of which were duplicates, 28 unique26.83ms889.26KB
  • SELECT @@SESSION.sql_mode;261μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `vha0j_session` WHERE `session_id` = ?503μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `vha0j_session` WHERE `session_id` = :session_id LIMIT 1259μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `vha0j_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.5ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `vha0j_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1523μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `vha0j_viewlevels`268μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `vha0j_usergroups` AS `a` LEFT JOIN `vha0j_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest404μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `vha0j_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`756μs4.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `vha0j_languages` WHERE `published` = 1 ORDER BY `ordering` ASC436μs3.48KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `vha0j_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1463μs1.08KB/libraries/src/Language/LanguageHelper.php:252Copy
  • 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 `vha0j_menu` AS `m` LEFT JOIN `vha0j_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`3.16ms709.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `vha0j_template_styles` AS `s` LEFT JOIN `vha0j_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` = 1991μs1.19KB/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `vha0j_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,:preparedArray41,:preparedArray42,:preparedArray43)1.97ms8KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `vha0j_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0406μs3.55KBParams/libraries/src/Access/Access.php:301Copy
  • 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 `vha0j_content` AS `a` INNER JOIN `vha0j_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `vha0j_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `vha0j_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `vha0j_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `vha0j_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) 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 (:preparedArray3,:preparedArray4)764μs8.73KBParams/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 `vha0j_categories` AS `s` INNER JOIN `vha0j_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`658μs5.23KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `vha0j_contentitem_tag_map` AS `m` INNER JOIN `vha0j_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)533μs7.72KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `vha0j_content` AS `c` INNER JOIN `vha0j_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `vha0j_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `vha0j_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `vha0j_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-07-17 02:24:29') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-07-17 02:24:29') AND c2.state = 1723μs1.8KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `language`,`id` FROM `vha0j_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0548μs944B/libraries/src/Language/Multilanguage.php:123Copy
  • 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 `vha0j_categories` AS `s` INNER JOIN `vha0j_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`584μs5.23KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 vha0j_fields AS a LEFT JOIN `vha0j_languages` AS l ON l.lang_code = a.language LEFT JOIN vha0j_users AS uc ON uc.id=a.checked_out LEFT JOIN vha0j_viewlevels AS ag ON ag.id = a.access LEFT JOIN vha0j_users AS ua ON ua.id = a.created_user_id LEFT JOIN vha0j_fields_groups AS g ON g.id = a.group_id LEFT JOIN `vha0j_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray8,:preparedArray9) ORDER BY a.ordering ASC760μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `vha0j_categories` AS `s` INNER JOIN `vha0j_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`713μs5.23KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias`,`catid` FROM vha0j_content WHERE `id` = :key269μs1.68KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `vha0j_menu` AS `c` INNER JOIN `vha0j_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `vha0j_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `vha0j_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id349μs1.72KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `vha0j_modules` AS `m` LEFT JOIN `vha0j_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `vha0j_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`606μs2.23KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM vha0j_modules WHERE published=1 ORDER BY id657μs20.39KB/administrator/components/com_maximenuck/helpers/ckfof.php:168Copy
  • SELECT a.params, a.layoutcss, a.customcss FROM vha0j_maximenuck_styles as a WHERE (a.state IN (0, 1)) AND a.id = 1995μs64.95KB/administrator/components/com_maximenuck/helpers/ckfof.php:176Copy
  • SELECT * FROM `vha0j_schemaorg` WHERE `itemId` = :itemId AND `context` = :context513μs1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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 `vha0j_content` AS `a` INNER JOIN `vha0j_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `vha0j_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `vha0j_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `vha0j_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `vha0j_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) 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 (:preparedArray3,:preparedArray4)824μs8.73KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `vha0j_scheduler_tasks` AS `a` WHERE `a`.`state` = 1325μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `vha0j_session` WHERE `session_id` = ?2.8ms1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `vha0j_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.31ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy