TDRM

monitoring radioactivity around nuclear facilities Doel, Tihange, Chooz, Borssele --

Infrastructure

Serveur

Les ressources nécessaires pour archiver les données de mesure, pour leur traitement et pour le site Web sont hébergées par un fournisseur de services Internet professionnel sur un serveur racine exploité par le FIfF e.V.

Les données de mesure des stations de détection convergent dans ce serveur. Le noyau du serveur est une base de données MySQL, qui archive les données entrantes et les fournit pour la présentation sur nos sites Web ainsi que pour une évaluation rétrospective. La base de données est encapsulée par une API ReST. L'interface ReST permet de transmettre les données du capteur sous forme de paquets HTTPS cryptés de bout en bout via les ports ouverts standard des routeurs. De même, le site Web récupère les données requises pour les représentations côté utilisateur à partir de la base de données via l'interface ReST.

Le serveur surveille le fonctionnement de toutes les stations de détection et informe automatiquement l'administrateur et l'opérateur des changements d'état de fonctionnement par courrier électronique.

Transmission des données de mesure des stations de détection au serveur

La station de mesure produit les valeurs mesurées actuelles toutes les minutes. Sur le site d'installation, il est connecté via un câble de données au routeur local de l'opérateur. Chaque minute, la station de détection envoie au routeur un paquet de données cryptées comprenant la valeur mesurée actuelle, l'horodatage et l'identifiant de la station. Le routeur transmet le paquet de données au serveur via Internet. Pour des raisons de sécurité, il n'est pas possible de s'adresser aux stations de détection  de l'extérieur.

DSC00844sDans les endroits sans accès à Internet, nous serons à l'avenir en mesure d'utiliser les connexions sans fil basées sur LoRaWAN . La technologie de communication LoRaWAN a été créée pour les applications IoT. Elle permet la transmission de données dans la bande 868 MHz sur des distances allant jusqu'à environ 10 km avec un faible débit. Avec cette technologie, la communauté TTN - TTN signifie «The Things Network» - crée des réseaux ouverts de passerelles vers Internet que nous utilisons pour transmettre nos données de mesure à notre serveur. Le matériel et les logiciels pour cette extension de la station de détection TDRM ont été développés par un groupe de recherche de la Hogeschool Karel-de-Grote, Campus Hoboken, Anvers.

Site web local

Au sein du réseau local dans lequel la station de détection fonctionne, les valeurs mesurées actuelles et passées de cette station de détection peuvent être appelées localement, voir les captures d'écran ci-dessous. Le logiciel des stations de détection comprend également un serveur Web local dont les pages peuvent être sélectionnées avec des navigateurs provenant d'ordinateurs connectés au même réseau local.

PiGI 4a

Source: Openresource project PiGI

La page d'accueil de la station de détection est appelée avec son URL locale ou avec son adresse IP:

  • L'URL locale d'une station de détection est http://tdrmNN (éventuellement aussi http://tdrmNN.local, http://tdrmNN.lan ou http://tdrmNN.fritz.box). NN représente le numéro d'identification de la station de détection respective.
  • Malheureusement, seuls quelques routeurs permettent de résoudre les noms des périphériques qui sont connectés. Si ce n'est pas le cas, la page de démarrage peut être appelée en entrant l'adresse IP. L'adresse IP attribuée à la station de détection par le routeur (par exemple 192.168.1.234) se trouve sur les pages d'administration du routeur dans la liste des 'périphériques connectés'.

Le message "Websocket Error" peut être ignoré! [#local]

 
 
J! InfoRequestSessionProfileQueries34
4.443MBMemory Usage68.79msRequest Duration
Joomla! Version5.2.6
PHP Version8.2.22
Identityguest
Response200
Templatecassiopeia_tdrm
Database
Server
mysql
Version
10.11.8-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:45 [ "SCRIPT_URL" => "/index.php/fr/technologie-fr/infrastructure-fr" "SCRIPT_URI" => "htt...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744542609 "last" => 1744542609...
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" => "fr-FR" ]
plg_system_webauthn
array:1 [ "returnUrl" => "https://tdrm.fiff.de/index.php/fr/technologie-fr/infrastructure-fr" ]
  • afterLoad (87.79KB) (1.43ms)
  • afterInitialise (1.43MB) (13.86ms)
  • afterRoute (678.16KB) (4.76ms)
  • beforeRenderComponent com_content (124.94KB) (1.24ms)
  • Before Access::preloadComponents (all components) (40.86KB) (856μs)
  • After Access::preloadComponents (all components) (120.65KB) (752μs)
  • Before Access::preloadPermissions (com_content) (1.54KB) (15μs)
  • After Access::preloadPermissions (com_content) (103.13KB) (777μs)
  • Before Access::getAssetRules (id:215 name:com_content.article.56) (6.65KB) (19μs)
  • After Access::getAssetRules (id:215 name:com_content.article.56) (8.3KB) (75μs)
  • beforeRenderRawModule mod_login (Login Form) (507.03KB) (14.87ms)
  • afterRenderRawModule mod_login (Login Form) (354.53KB) (4.3ms)
  • beforeRenderModule mod_login (Login Form) (720B) (7μs)
  • afterRenderModule mod_login (Login Form) (7.26KB) (161μs)
  • afterRenderComponent com_content (27.84KB) (20μs)
  • Before Access::getAssetRules (id:8 name:com_content) (32.35KB) (2.5ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (12μs)
  • afterDispatch (95.84KB) (3.08ms)
  • beforeRenderRawModule mod_menu (Main Menu de) (36.33KB) (534μs)
  • afterRenderRawModule mod_menu (Main Menu de) (4.5KB) (284μs)
  • beforeRenderRawModule mod_menu (Main Menu en) (720B) (24μs)
  • afterRenderRawModule mod_menu (Main Menu en) (912B) (97μs)
  • beforeRenderRawModule mod_menu (Main Menu fr) (720B) (22μs)
  • afterRenderRawModule mod_menu (Main Menu fr) (142.66KB) (1.64ms)
  • beforeRenderRawModule mod_menu (Main Menu nl) (720B) (27μs)
  • afterRenderRawModule mod_menu (Main Menu nl) (880B) (103μs)
  • beforeRenderRawModule mod_languages (Sprachauswahl ) (944B) (32μs)
  • afterRenderRawModule mod_languages (Sprachauswahl ) (13.36KB) (1.18ms)
  • beforeRenderRawModule mod_custom (Fuss) (560B) (52μs)
  • afterRenderRawModule mod_custom (Fuss) (3.98KB) (218μs)
  • beforeRenderRawModule mod_menu (Foot Menu) (2.48KB) (35μs)
  • afterRenderRawModule mod_menu (Foot Menu) (1.19KB) (96μs)
  • beforeRenderRawModule mod_menu (Foot Menu (en)) (688B) (23μs)
  • afterRenderRawModule mod_menu (Foot Menu (en)) (2.14KB) (90μs)
  • beforeRenderRawModule mod_menu (Foot Menu (fr)) (720B) (22μs)
  • afterRenderRawModule mod_menu (Foot Menu (fr)) (32.5KB) (562μs)
  • beforeRenderRawModule mod_gkstand (gkstand) (2.48KB) (28μs)
  • afterRenderRawModule mod_gkstand (gkstand) (4.51KB) (267μs)
  • beforeRenderModule mod_gkstand (gkstand) (1.33KB) (280μs)
  • afterRenderModule mod_gkstand (gkstand) (2.41KB) (83μs)
  • beforeRenderModule mod_menu (Foot Menu) (2.79KB) (175μs)
  • afterRenderModule mod_menu (Foot Menu) (2.98KB) (93μs)
  • beforeRenderModule mod_menu (Foot Menu (en)) (952B) (23μs)
  • afterRenderModule mod_menu (Foot Menu (en)) (1.76KB) (64μs)
  • beforeRenderModule mod_menu (Foot Menu (fr)) (168B) (23μs)
  • afterRenderModule mod_menu (Foot Menu (fr)) (3.06KB) (62μs)
  • beforeRenderModule mod_custom (Fuss) (2.15KB) (308μs)
  • afterRenderModule mod_custom (Fuss) (3.41KB) (81μs)
  • beforeRenderModule mod_languages (Sprachauswahl ) (112B) (284μs)
  • afterRenderModule mod_languages (Sprachauswahl ) (6.11KB) (76μs)
  • beforeRenderModule mod_menu (Main Menu de) (680B) (481μs)
  • afterRenderModule mod_menu (Main Menu de) (1.66KB) (71μs)
  • beforeRenderModule mod_menu (Main Menu en) (168B) (23μs)
  • afterRenderModule mod_menu (Main Menu en) (1.76KB) (61μs)
  • beforeRenderModule mod_menu (Main Menu fr) (168B) (22μs)
  • afterRenderModule mod_menu (Main Menu fr) (6.44KB) (60μs)
  • beforeRenderModule mod_menu (Main Menu nl) (864B) (22μs)
  • afterRenderModule mod_menu (Main Menu nl) (1.76KB) (68μs)
  • afterRender (182.28KB) (11.87ms)
  • 1 x beforeRenderRawModule mod_login (Login Form) (507.03KB) (21.62%)
    14.87ms
    1 x afterInitialise (1.43MB) (20.15%)
    13.86ms
    1 x afterRender (182.28KB) (17.26%)
    11.87ms
    1 x afterRoute (678.16KB) (6.93%)
    4.76ms
    1 x afterRenderRawModule mod_login (Login Form) (354.53KB) (6.26%)
    4.30ms
    1 x afterDispatch (95.84KB) (4.48%)
    3.08ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (32.35KB) (3.64%)
    2.50ms
    1 x afterRenderRawModule mod_menu (Main Menu fr) (142.66KB) (2.38%)
    1.64ms
    1 x afterLoad (87.79KB) (2.07%)
    1.43ms
    1 x beforeRenderComponent com_content (124.94KB) (1.8%)
    1.24ms
    1 x afterRenderRawModule mod_languages (Sprachauswahl ) (13.36KB) (1.72%)
    1.18ms
    1 x Before Access::preloadComponents (all components) (40.86KB) (1.24%)
    856μs
    1 x After Access::preloadPermissions (com_content) (103.13KB) (1.13%)
    777μs
    1 x After Access::preloadComponents (all components) (120.65KB) (1.09%)
    752μs
    1 x afterRenderRawModule mod_menu (Foot Menu (fr)) (32.5KB) (0.82%)
    562μs
    1 x beforeRenderRawModule mod_menu (Main Menu de) (36.33KB) (0.78%)
    534μs
    1 x beforeRenderModule mod_menu (Main Menu de) (680B) (0.7%)
    481μs
    1 x beforeRenderModule mod_custom (Fuss) (2.15KB) (0.45%)
    308μs
    1 x beforeRenderModule mod_languages (Sprachauswahl ) (112B) (0.41%)
    284μs
    1 x afterRenderRawModule mod_menu (Main Menu de) (4.5KB) (0.41%)
    284μs
    1 x beforeRenderModule mod_gkstand (gkstand) (1.33KB) (0.41%)
    280μs
    1 x afterRenderRawModule mod_gkstand (gkstand) (4.51KB) (0.39%)
    267μs
    1 x afterRenderRawModule mod_custom (Fuss) (3.98KB) (0.32%)
    218μs
    1 x beforeRenderModule mod_menu (Foot Menu) (2.79KB) (0.25%)
    175μs
    1 x afterRenderModule mod_login (Login Form) (7.26KB) (0.23%)
    161μs
    1 x afterRenderRawModule mod_menu (Main Menu nl) (880B) (0.15%)
    103μs
    1 x afterRenderRawModule mod_menu (Main Menu en) (912B) (0.14%)
    97μs
    1 x afterRenderRawModule mod_menu (Foot Menu) (1.19KB) (0.14%)
    96μs
    1 x afterRenderModule mod_menu (Foot Menu) (2.98KB) (0.14%)
    93μs
    1 x afterRenderRawModule mod_menu (Foot Menu (en)) (2.14KB) (0.13%)
    90μs
    1 x afterRenderModule mod_gkstand (gkstand) (2.41KB) (0.12%)
    83μs
    1 x afterRenderModule mod_custom (Fuss) (3.41KB) (0.12%)
    81μs
    1 x afterRenderModule mod_languages (Sprachauswahl ) (6.11KB) (0.11%)
    76μs
    1 x After Access::getAssetRules (id:215 name:com_content.article.56) (8.3KB) (0.11%)
    75μs
    1 x afterRenderModule mod_menu (Main Menu de) (1.66KB) (0.1%)
    71μs
    1 x afterRenderModule mod_menu (Main Menu nl) (1.76KB) (0.1%)
    68μs
    1 x afterRenderModule mod_menu (Foot Menu (en)) (1.76KB) (0.09%)
    64μs
    1 x afterRenderModule mod_menu (Foot Menu (fr)) (3.06KB) (0.09%)
    62μs
    1 x afterRenderModule mod_menu (Main Menu en) (1.76KB) (0.09%)
    61μs
    1 x afterRenderModule mod_menu (Main Menu fr) (6.44KB) (0.09%)
    60μs
    1 x beforeRenderRawModule mod_custom (Fuss) (560B) (0.08%)
    52μs
    1 x beforeRenderRawModule mod_menu (Foot Menu) (2.48KB) (0.05%)
    35μs
    1 x beforeRenderRawModule mod_languages (Sprachauswahl ) (944B) (0.05%)
    32μs
    1 x beforeRenderRawModule mod_gkstand (gkstand) (2.48KB) (0.04%)
    28μs
    1 x beforeRenderRawModule mod_menu (Main Menu nl) (720B) (0.04%)
    27μs
    1 x beforeRenderRawModule mod_menu (Main Menu en) (720B) (0.04%)
    24μs
    1 x beforeRenderRawModule mod_menu (Foot Menu (en)) (688B) (0.03%)
    23μs
    1 x beforeRenderModule mod_menu (Foot Menu (en)) (952B) (0.03%)
    23μs
    1 x beforeRenderModule mod_menu (Foot Menu (fr)) (168B) (0.03%)
    23μs
    1 x beforeRenderModule mod_menu (Main Menu en) (168B) (0.03%)
    23μs
    1 x beforeRenderRawModule mod_menu (Main Menu fr) (720B) (0.03%)
    22μs
    1 x beforeRenderRawModule mod_menu (Foot Menu (fr)) (720B) (0.03%)
    22μs
    1 x beforeRenderModule mod_menu (Main Menu fr) (168B) (0.03%)
    22μs
    1 x beforeRenderModule mod_menu (Main Menu nl) (864B) (0.03%)
    22μs
    1 x afterRenderComponent com_content (27.84KB) (0.03%)
    20μs
    1 x Before Access::getAssetRules (id:215 name:com_content.article.56) (6.65KB) (0.03%)
    19μs
    1 x Before Access::preloadPermissions (com_content) (1.54KB) (0.02%)
    15μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.02%)
    12μs
    1 x beforeRenderModule mod_login (Login Form) (720B) (0.01%)
    7μs
34 statements were executed, 4 of which were duplicates, 30 unique10.17ms220.08KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;85μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `tdrm_session` WHERE `session_id` = ?106μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `tdrm_session` WHERE `session_id` = :session_id LIMIT 191μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `tdrm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)354μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tdrm_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1253μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tdrm_viewlevels`77μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `tdrm_usergroups` AS `a` LEFT JOIN `tdrm_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest110μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `tdrm_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`578μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tdrm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC149μs2.27KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `tdrm_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1149μs880B/libraries/src/Language/LanguageHelper.php:250Copy
  • 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 `tdrm_menu` AS `m` LEFT JOIN `tdrm_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`758μs84.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `tdrm_template_styles` AS `s` LEFT JOIN `tdrm_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` = 1185μs848B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tdrm_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)381μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tdrm_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0362μs5.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tdrm_content`486μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `tdrm_content` SET `hits` = (`hits` + 1) WHERE `id` = '56'311μs48B/libraries/src/Table/Table.php:1348Copy
  • 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 `tdrm_content` AS `a` INNER JOIN `tdrm_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tdrm_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `tdrm_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `tdrm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tdrm_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)291μs23.44KBParams/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 `tdrm_categories` AS `s` INNER JOIN `tdrm_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`371μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `tdrm_contentitem_tag_map` AS `m` INNER JOIN `tdrm_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)192μs3.97KBParams/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 `tdrm_categories` AS `s` INNER JOIN `tdrm_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`363μs3.98KBParams/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 tdrm_fields AS a LEFT JOIN `tdrm_languages` AS l ON l.lang_code = a.language LEFT JOIN tdrm_users AS uc ON uc.id=a.checked_out LEFT JOIN tdrm_viewlevels AS ag ON ag.id = a.access LEFT JOIN tdrm_users AS ua ON ua.id = a.created_user_id LEFT JOIN tdrm_fields_groups AS g ON g.id = a.group_id LEFT JOIN `tdrm_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 ASC689μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `tdrm_content` AS `a` LEFT JOIN `tdrm_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) AND `a`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC234μs1.77KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `tdrm_modules` AS `m` LEFT JOIN `tdrm_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `tdrm_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`818μs2.16KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `language`,`id` FROM `tdrm_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0189μs656B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `tdrm_menu` AS `c` INNER JOIN `tdrm_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `tdrm_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `tdrm_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id176μs1.44KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `tdrm_content` AS `c` INNER JOIN `tdrm_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `tdrm_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `tdrm_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `tdrm_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 != 'fr-FR' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-04-13 11:10:09') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-13 11:10:09') AND c2.state = 1268μs1.52KBParams/libraries/src/Language/Associations.php:145Copy
  • 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 `tdrm_categories` AS `s` INNER JOIN `tdrm_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`366μs19.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `tdrm_categories` AS `s` INNER JOIN `tdrm_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`350μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `tdrm_categories` AS `s` INNER JOIN `tdrm_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`350μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `tdrm_schemaorg` WHERE `itemId` = :itemId AND `context` = :context107μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `tdrm_content` AS `a` INNER JOIN `tdrm_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tdrm_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `tdrm_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `tdrm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tdrm_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)282μs22.23KBParams/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 `tdrm_scheduler_tasks` AS `a` WHERE `a`.`state` = 1110μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `tdrm_session` WHERE `session_id` = ?91μs3.5KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `tdrm_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?484μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy