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

Server

The data base for the collection and archival of sensor data, the resources for their processing and the TDRM website are hosted by a professional ISP on a root server operated by FIfF e.V.

Sensor data are rooted to this server. A MySQL data base is the kernel of the TDRM server. All incoming sensor data are registered by the data base and deployed for web publishing as well as for retrospective evaluation. The data base is encapsulated by a ReST API. By means of the ReST API sensor data can be transmitted end-to-end encrypted via common router ports which are open by default. Vice versa the website accesses the data base to fetch the data required for presentation on its pages via the ReST API.

The server supervises the operation of all sensor stations and informs, by email, the administrator as well as the host of the respective station about changes of its state of operation.Transmission of sensor data from sensor station to server

Once every minute every sensor station generates a data string representing the current dose rate. The string is completed by a time stamp and the station's ID, encrypted and transmitted, via ethernet cable, to the router at the premises of its host. Via Internet the router passes the string to the server. For security reasons a sensor station cannot be addressed from the outside.

DSC00844sAt locations which are not supplied with internet access we will prospectively apply the novel LoRaWAN wireless technology. LoRaWAN facilitates a narrow-band transmission over up to 10km in the 868 MHz band. This technology is employed, among others, for public open networks of internet gateways which are built up and operated by the TTN community—the acronym TTN standing for The Things Network. A project group of Karel-de-Grote Hogeschool, Campus Hoboken, Antwerpen has developed a hardware module and appropriate software extensions for TDRM sensor stations to transmit their sensor data via TTN gateways to the TDRM server. #TTN

Local website

Current and past sensor data can be retrieved locally within the local network to which the station is connected. For this purpose the operating system of sensor stations contains an own local web server. Local web pages can be accessed by the web browser of any computer connected to the same local network. #local

PiGI 4a

Source: Openresource project PiGI

The home page of the local web server is to be addressed by its local URL or by its IP number:

  • The local URL of a sensor station reads http://tdrmNN (occasionally http://tdrmNN.local, http://tdrmNN.lan or http://tdrmNN.fritz.box). NN is the unique identification number of the station.
  • Unfortunately routers which resolve the local URL of connected devices are quite rare. Alternatively the local home page can be adressed by the stations IP number. The IP number which the router 'leased' to the station (e.g. 192.168.1.234) can be found on the administartion pages of the router on the page 'connected devices'.

Please ignore "Websocket Error" messages!

4.4MBMemory Usage67.83msRequest 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/en/technology-en/infrastructure-en" "SCRIPT_URI" => "http...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744781889 "last" => 1744781889...
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" ]
plg_system_webauthn
array:1 [ "returnUrl" => "https://tdrm.fiff.de/index.php/en/technology-en/infrastructure-en" ]
  • afterLoad (87.79KB) (1.42ms)
  • afterInitialise (1.43MB) (14.17ms)
  • afterRoute (652.72KB) (3.79ms)
  • beforeRenderComponent com_content (124.55KB) (1.27ms)
  • Before Access::preloadComponents (all components) (40.28KB) (809μs)
  • After Access::preloadComponents (all components) (120.65KB) (750μs)
  • Before Access::preloadPermissions (com_content) (1.54KB) (14μs)
  • After Access::preloadPermissions (com_content) (103.13KB) (787μs)
  • Before Access::getAssetRules (id:177 name:com_content.article.37) (6.65KB) (20μs)
  • After Access::getAssetRules (id:177 name:com_content.article.37) (8.3KB) (75μs)
  • beforeRenderRawModule mod_login (Login Form) (504.63KB) (14.67ms)
  • afterRenderRawModule mod_login (Login Form) (352.2KB) (4.29ms)
  • beforeRenderModule mod_login (Login Form) (720B) (7μs)
  • afterRenderModule mod_login (Login Form) (7.26KB) (163μs)
  • afterRenderComponent com_content (27.84KB) (23μs)
  • Before Access::getAssetRules (id:8 name:com_content) (32.35KB) (2.65ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (14μs)
  • afterDispatch (95.86KB) (3.22ms)
  • beforeRenderRawModule mod_menu (Main Menu de) (35.97KB) (537μs)
  • afterRenderRawModule mod_menu (Main Menu de) (4.22KB) (269μs)
  • beforeRenderRawModule mod_menu (Main Menu en) (720B) (25μs)
  • afterRenderRawModule mod_menu (Main Menu en) (142.88KB) (1.67ms)
  • beforeRenderRawModule mod_menu (Main Menu fr) (720B) (29μs)
  • afterRenderRawModule mod_menu (Main Menu fr) (880B) (100μs)
  • beforeRenderRawModule mod_menu (Main Menu nl) (720B) (23μs)
  • afterRenderRawModule mod_menu (Main Menu nl) (912B) (91μs)
  • beforeRenderRawModule mod_languages (Sprachauswahl ) (944B) (33μs)
  • afterRenderRawModule mod_languages (Sprachauswahl ) (13.05KB) (1.18ms)
  • beforeRenderRawModule mod_custom (Fuss) (560B) (53μs)
  • afterRenderRawModule mod_custom (Fuss) (3.84KB) (184μ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) (22μs)
  • afterRenderRawModule mod_menu (Foot Menu (en)) (33.62KB) (569μs)
  • beforeRenderRawModule mod_menu (Foot Menu (fr)) (720B) (26μs)
  • afterRenderRawModule mod_menu (Foot Menu (fr)) (880B) (93μs)
  • beforeRenderRawModule mod_gkstand (gkstand) (2.45KB) (24μs)
  • afterRenderRawModule mod_gkstand (gkstand) (4.26KB) (228μs)
  • beforeRenderModule mod_gkstand (gkstand) (1.33KB) (291μs)
  • afterRenderModule mod_gkstand (gkstand) (2.41KB) (83μs)
  • beforeRenderModule mod_menu (Foot Menu) (2.79KB) (178μs)
  • afterRenderModule mod_menu (Foot Menu) (2.98KB) (95μs)
  • beforeRenderModule mod_menu (Foot Menu (en)) (952B) (24μs)
  • afterRenderModule mod_menu (Foot Menu (en)) (2.94KB) (65μs)
  • beforeRenderModule mod_menu (Foot Menu (fr)) (864B) (22μs)
  • afterRenderModule mod_menu (Foot Menu (fr)) (1.76KB) (61μs)
  • beforeRenderModule mod_custom (Fuss) (1.47KB) (307μs)
  • afterRenderModule mod_custom (Fuss) (3.41KB) (80μs)
  • beforeRenderModule mod_languages (Sprachauswahl ) (112B) (284μs)
  • afterRenderModule mod_languages (Sprachauswahl ) (6.11KB) (78μs)
  • beforeRenderModule mod_menu (Main Menu de) (680B) (484μ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) (6.44KB) (63μs)
  • beforeRenderModule mod_menu (Main Menu fr) (864B) (22μs)
  • afterRenderModule mod_menu (Main Menu fr) (1.76KB) (59μs)
  • beforeRenderModule mod_menu (Main Menu nl) (168B) (22μs)
  • afterRenderModule mod_menu (Main Menu nl) (1.76KB) (59μs)
  • afterRender (176.34KB) (11.6ms)
  • 1 x beforeRenderRawModule mod_login (Login Form) (504.63KB) (21.63%)
    14.67ms
    1 x afterInitialise (1.43MB) (20.88%)
    14.17ms
    1 x afterRender (176.34KB) (17.1%)
    11.60ms
    1 x afterRenderRawModule mod_login (Login Form) (352.2KB) (6.32%)
    4.29ms
    1 x afterRoute (652.72KB) (5.58%)
    3.79ms
    1 x afterDispatch (95.86KB) (4.75%)
    3.22ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (32.35KB) (3.9%)
    2.65ms
    1 x afterRenderRawModule mod_menu (Main Menu en) (142.88KB) (2.46%)
    1.67ms
    1 x afterLoad (87.79KB) (2.09%)
    1.42ms
    1 x beforeRenderComponent com_content (124.55KB) (1.87%)
    1.27ms
    1 x afterRenderRawModule mod_languages (Sprachauswahl ) (13.05KB) (1.74%)
    1.18ms
    1 x Before Access::preloadComponents (all components) (40.28KB) (1.19%)
    809μs
    1 x After Access::preloadPermissions (com_content) (103.13KB) (1.16%)
    787μs
    1 x After Access::preloadComponents (all components) (120.65KB) (1.11%)
    750μs
    1 x afterRenderRawModule mod_menu (Foot Menu (en)) (33.62KB) (0.84%)
    569μs
    1 x beforeRenderRawModule mod_menu (Main Menu de) (35.97KB) (0.79%)
    537μs
    1 x beforeRenderModule mod_menu (Main Menu de) (680B) (0.71%)
    484μs
    1 x beforeRenderModule mod_custom (Fuss) (1.47KB) (0.45%)
    307μs
    1 x beforeRenderModule mod_gkstand (gkstand) (1.33KB) (0.43%)
    291μs
    1 x beforeRenderModule mod_languages (Sprachauswahl ) (112B) (0.42%)
    284μs
    1 x afterRenderRawModule mod_menu (Main Menu de) (4.22KB) (0.4%)
    269μs
    1 x afterRenderRawModule mod_gkstand (gkstand) (4.26KB) (0.34%)
    228μs
    1 x afterRenderRawModule mod_custom (Fuss) (3.84KB) (0.27%)
    184μs
    1 x beforeRenderModule mod_menu (Foot Menu) (2.79KB) (0.26%)
    178μs
    1 x afterRenderModule mod_login (Login Form) (7.26KB) (0.24%)
    163μs
    1 x afterRenderRawModule mod_menu (Main Menu fr) (880B) (0.15%)
    100μ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%)
    95μs
    1 x afterRenderRawModule mod_menu (Foot Menu (fr)) (880B) (0.14%)
    93μs
    1 x afterRenderRawModule mod_menu (Main Menu nl) (912B) (0.13%)
    91μs
    1 x afterRenderModule mod_gkstand (gkstand) (2.41KB) (0.12%)
    83μs
    1 x afterRenderModule mod_custom (Fuss) (3.41KB) (0.12%)
    80μs
    1 x afterRenderModule mod_languages (Sprachauswahl ) (6.11KB) (0.11%)
    78μs
    1 x After Access::getAssetRules (id:177 name:com_content.article.37) (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 (Foot Menu (en)) (2.94KB) (0.1%)
    65μs
    1 x afterRenderModule mod_menu (Main Menu en) (6.44KB) (0.09%)
    63μs
    1 x afterRenderModule mod_menu (Foot Menu (fr)) (1.76KB) (0.09%)
    61μs
    1 x afterRenderModule mod_menu (Main Menu fr) (1.76KB) (0.09%)
    59μs
    1 x afterRenderModule mod_menu (Main Menu nl) (1.76KB) (0.09%)
    59μs
    1 x beforeRenderRawModule mod_custom (Fuss) (560B) (0.08%)
    53μs
    1 x beforeRenderRawModule mod_menu (Foot Menu) (2.48KB) (0.05%)
    35μs
    1 x beforeRenderRawModule mod_languages (Sprachauswahl ) (944B) (0.05%)
    33μs
    1 x beforeRenderRawModule mod_menu (Main Menu fr) (720B) (0.04%)
    29μs
    1 x beforeRenderRawModule mod_menu (Foot Menu (fr)) (720B) (0.04%)
    26μs
    1 x beforeRenderRawModule mod_menu (Main Menu en) (720B) (0.04%)
    25μs
    1 x beforeRenderModule mod_menu (Foot Menu (en)) (952B) (0.04%)
    24μs
    1 x beforeRenderRawModule mod_gkstand (gkstand) (2.45KB) (0.04%)
    24μs
    1 x afterRenderComponent com_content (27.84KB) (0.03%)
    23μs
    1 x beforeRenderRawModule mod_menu (Main Menu nl) (720B) (0.03%)
    23μs
    1 x beforeRenderModule mod_menu (Main Menu en) (168B) (0.03%)
    23μs
    1 x beforeRenderModule mod_menu (Main Menu nl) (168B) (0.03%)
    22μs
    1 x beforeRenderRawModule mod_menu (Foot Menu (en)) (688B) (0.03%)
    22μs
    1 x beforeRenderModule mod_menu (Foot Menu (fr)) (864B) (0.03%)
    22μs
    1 x beforeRenderModule mod_menu (Main Menu fr) (864B) (0.03%)
    22μs
    1 x Before Access::getAssetRules (id:177 name:com_content.article.37) (6.65KB) (0.03%)
    20μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.02%)
    14μs
    1 x Before Access::preloadPermissions (com_content) (1.54KB) (0.02%)
    14μs
    1 x beforeRenderModule mod_login (Login Form) (720B) (0.01%)
    7μs
34 statements were executed, 4 of which were duplicates, 30 unique10.55ms220.08KB
  • 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 175μ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)335μ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` = 1242μ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` = :guest112μ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`564μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tdrm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC154μ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` = 1170μ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`737μ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` = 1184μ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)385μ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` = 0357μs5.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `tdrm_content`499μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `tdrm_content` SET `hits` = (`hits` + 1) WHERE `id` = '37'298μ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)314μ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`380μ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)189μ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`381μ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 ASC849μ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 DESC274μ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`923μs2.16KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `language`,`id` FROM `tdrm_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0222μ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` = :id188μ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 != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-04-16 05:38:09') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-16 05:38:09') AND c2.state = 1291μ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`404μ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`356μ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`356μs3.98KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `tdrm_schemaorg` WHERE `itemId` = :itemId AND `context` = :context134μ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)314μ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` = 1123μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `tdrm_session` WHERE `session_id` = ?108μs3.5KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `tdrm_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?359μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy