Sidebar

Login Form

Remember Me

Since I've had the auto radiosonde running for the last few months I thought I'd do another update. For the most part there is nothing but good to report, with a little bit of not so good as well as a little bit of ugly.

The Good

Lets start with the good. Since June 15th, the first day a weather balloon was detected, I have received a signal from a whopping 515 balloons. Out of all those balloons, two of them surprisingly landed within 30km of me. Here is a breakdown of the different types of radiosondes that I have picked up.

  Radiosonde Type    Quantity Received 
  RS41   267
  DMF-09   1
  DMF-17   247
  Total   515

The majority of these balloons were launched by the NWS in Midland. In second place we have the Automated Radiosonde Observing System in Del Rio, TX. Scattered in the mix are a few balloons from NWS in Ft. Worth as well as a couple rogue balloons from the NWS in Corpus Christi.

The Bad

Now onto the bad that has happened over since June, something happened to the antenna. Well a couple somethings actually. The first being that the PLA mount that I 3D printed started to sag a little under the brutal Texas sun. This wasn't really surprising at all. I went with PLA more as an experiment to see how it would hold up, as well as not having the best results with ABS at the time. A little sagging was expected. Something else happened to the antenna though, and this was quite unexpected. I don't know how, but one of the radials managed to get bent at about a 45 degree angle up! Not sure if this was a bird or wind or possibly even a rogue sasquatch or toddler.

 

 

As a result, we now have the radiosonde quarter wave ground plane version 2.0 antenna. Really nothing much is different to be honest. I bent the radial back down to where it belongs and came up with a different mounting solution. For something a little more robust, I scavenged a piece of 1/2" EMT from an old weather sensor mount. Next I just ran the cable through the EMT, taped the connector for the antenna to the top and secured it to the fascia. This left me with just enough cable to run inside and connect to the SDR. As an added benefit, the antenna is now about 4 feet higher than before. So in theory that means I can see a balloon from at least 50 feet farther away, give or take. The upgrade isn't exactly the prettiest, however I haven't heard any complaints from the XYL so I'll consider it a win until I hear otherwise.

The Ugly

There is one thing that is starting to cause me some concern, and that is I believe there is a chance my SDR may be slowly dying. It does get quite warm and over the last few days there have been some launches that I have missed. I typically end up pulling the SDR from it's USB port, plugging it back in and restarting the auto_rx service. Afterwards it works without issue for a bit more time. Since I've only had it about 5 months this is somewhat concerning. If it does die then I'll have to decide whether to see if I can warranty this one some how or possibly move to a different type of SDR.

In the End

In the end I think that is is a simple and interesting project. It doesn't take much more than an SDR and an antenna to get going and I find it interesting to watch the balloons and the different directions they move throughout the year.


We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.

4.27MBMemory Usage161msRequest Duration
Joomla! Version5.0.3
PHP Version8.1.27
Identityguest
Response200
Templatepurity_iii
Database
Server
mysql
Version
10.6.17-MariaDB
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "2397ac86c89105aa197d1198af919a37" => "90v9uhugqls48bdak9ej1jgna0" ]
$_SERVER
array:44 [ "UNIQUE_ID" => "Z-TggkaLMPVr1NGzY5357AAAABE" "HTTPS" => "on" "SSL_TLS_SNI" => "n5be...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1744101506 "last" => 1744101506...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_webauthn
array:1 [ "returnUrl" => "https://n5bew.us/index.php/articles/weather/27-update-2-tracking-weather...
gtag
false
  • afterLoad (74.1KB) (465μs)
  • afterInitialise (1.31MB) (52.56ms)
  • afterRoute (609.26KB) (6.91ms)
  • beforeRenderComponent com_content (51.02KB) (1.17ms)
  • Before Access::preloadComponents (all components) (34.72KB) (454μs)
  • After Access::preloadComponents (all components) (109.05KB) (1.51ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (23μs)
  • After Access::preloadPermissions (com_content) (14.58KB) (679μs)
  • Before Access::getAssetRules (id:119 name:com_content.article.27) (1.3KB) (20μs)
  • After Access::getAssetRules (id:119 name:com_content.article.27) (8.47KB) (75μs)
  • afterRenderComponent com_content (1.1MB) (28.09ms)
  • afterDispatch (2.33KB) (135μs)
  • beforeRenderModule mod_tags_popular (Tags) (42.78KB) (1.45ms)
  • afterRenderRawModule mod_tags_popular (Tags) (38.95KB) (4.65ms)
  • beforeRenderModule mod_tags_popular (Tags) (720B) (11μs)
  • afterRenderModule mod_tags_popular (Tags) (2.52KB) (292μs)
  • beforeRenderModule mod_custom (HF Propogation (qsl small)) (2.63KB) (67μs)
  • afterRenderRawModule mod_custom (HF Propogation (qsl small)) (5.16KB) (276μs)
  • beforeRenderModule mod_custom (HF Propogation (qsl small)) (736B) (7μs)
  • afterRenderModule mod_custom (HF Propogation (qsl small)) (1.84KB) (131μs)
  • beforeRenderModule mod_search (Search) (4.57KB) (76μs)
  • afterRenderRawModule mod_search (Search) (25.03KB) (1.58ms)
  • beforeRenderModule mod_search (Search) (704B) (9μs)
  • afterRenderModule mod_search (Search) (1.7KB) (144μs)
  • beforeRenderModule mod_login (Login Form) (1.44KB) (71μs)
  • afterRenderRawModule mod_login (Login Form) (48.3KB) (1.43ms)
  • beforeRenderModule mod_login (Login Form) (720B) (8μs)
  • afterRenderModule mod_login (Login Form) (2.73KB) (160μs)
  • afterRender (372.28KB) (57.87ms)
  • 1 x afterRender (372.28KB) (35.98%)
    57.87ms
    1 x afterInitialise (1.31MB) (32.68%)
    52.56ms
    1 x afterRenderComponent com_content (1.1MB) (17.46%)
    28.09ms
    1 x afterRoute (609.26KB) (4.29%)
    6.91ms
    1 x afterRenderRawModule mod_tags_popular (Tags) (38.95KB) (2.89%)
    4.65ms
    1 x afterRenderRawModule mod_search (Search) (25.03KB) (0.98%)
    1.58ms
    1 x After Access::preloadComponents (all components) (109.05KB) (0.94%)
    1.51ms
    1 x beforeRenderModule mod_tags_popular (Tags) (42.78KB) (0.9%)
    1.45ms
    1 x afterRenderRawModule mod_login (Login Form) (48.3KB) (0.89%)
    1.43ms
    1 x beforeRenderComponent com_content (51.02KB) (0.72%)
    1.17ms
    1 x After Access::preloadPermissions (com_content) (14.58KB) (0.42%)
    679μs
    1 x afterLoad (74.1KB) (0.29%)
    465μs
    1 x Before Access::preloadComponents (all components) (34.72KB) (0.28%)
    454μs
    1 x afterRenderModule mod_tags_popular (Tags) (2.52KB) (0.18%)
    292μs
    1 x afterRenderRawModule mod_custom (HF Propogation (qsl small)) (5.16KB) (0.17%)
    276μs
    1 x afterRenderModule mod_login (Login Form) (2.73KB) (0.1%)
    160μs
    1 x afterRenderModule mod_search (Search) (1.7KB) (0.09%)
    144μs
    1 x afterDispatch (2.33KB) (0.08%)
    135μs
    1 x afterRenderModule mod_custom (HF Propogation (qsl small)) (1.84KB) (0.08%)
    131μs
    1 x beforeRenderModule mod_search (Search) (4.57KB) (0.05%)
    76μs
    1 x After Access::getAssetRules (id:119 name:com_content.article.27) (8.47KB) (0.05%)
    75μs
    1 x beforeRenderModule mod_login (Login Form) (1.44KB) (0.04%)
    71μs
    1 x beforeRenderModule mod_custom (HF Propogation (qsl small)) (2.63KB) (0.04%)
    67μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.01%)
    23μs
    1 x Before Access::getAssetRules (id:119 name:com_content.article.27) (1.3KB) (0.01%)
    20μs
    1 x beforeRenderModule mod_tags_popular (Tags) (720B) (0.01%)
    11μs
    1 x beforeRenderModule mod_search (Search) (704B) (0.01%)
    9μs
    1 x beforeRenderModule mod_login (Login Form) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (HF Propogation (qsl small)) (736B) (0%)
    7μs
32 statements were executed, 7 of which were duplicates, 25 unique18.49ms153.81KB
  • SELECT @@SESSION.sql_mode;85μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `hdazu_session` WHERE `session_id` = ?190μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `hdazu_session` WHERE `session_id` = :session_id LIMIT 1145μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `hdazu_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id167μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `hdazu_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1366μs2.19KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `hdazu_viewlevels`136μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `hdazu_usergroups` AS `a` LEFT JOIN `hdazu_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest193μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `hdazu_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`938μs4.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • 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 `hdazu_menu` AS `m` LEFT JOIN `hdazu_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`620μs22.17KBParams/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 `hdazu_categories` AS `s` INNER JOIN `hdazu_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`510μs5.14KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `hdazu_template_styles` AS `s` LEFT JOIN `hdazu_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` = 1305μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `hdazu_languages` WHERE `published` = 1 ORDER BY `ordering` ASC224μs2.22KB/libraries/src/Language/LanguageHelper.php:145Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `hdazu_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)568μs7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `hdazu_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0350μs2.67KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `hdazu_content`1.59ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `hdazu_content` SET `hits` = (`hits` + 1) WHERE `id` = '27'1.11ms48B/libraries/src/Table/Table.php:1349Copy
  • 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 `hdazu_content` AS `a` INNER JOIN `hdazu_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `hdazu_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `hdazu_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `hdazu_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `hdazu_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)453μs27.13KBParams/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 `hdazu_categories` AS `s` INNER JOIN `hdazu_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`532μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `hdazu_contentitem_tag_map` AS `m` INNER JOIN `hdazu_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)443μs5.34KBParams/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 `hdazu_categories` AS `s` INNER JOIN `hdazu_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`474μs5.19KBParams/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 hdazu_fields AS a LEFT JOIN `hdazu_languages` AS l ON l.lang_code = a.language LEFT JOIN hdazu_users AS uc ON uc.id=a.checked_out LEFT JOIN hdazu_viewlevels AS ag ON ag.id = a.access LEFT JOIN hdazu_users AS ua ON ua.id = a.created_user_id LEFT JOIN hdazu_fields_groups AS g ON g.id = a.group_id LEFT JOIN `hdazu_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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.92ms6.06KBParams/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 `hdazu_content` AS `a` LEFT JOIN `hdazu_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 DESC492μs2.08KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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 `hdazu_categories` AS `s` INNER JOIN `hdazu_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`525μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `hdazu_modules` AS `m` LEFT JOIN `hdazu_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `hdazu_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`736μs2.22KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `hdazu_contentitem_tag_map` AS `m` INNER JOIN `hdazu_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `hdazu_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `hdazu_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `hdazu_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `t`.`parent_id` IN (:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6) AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray7,:preparedArray8) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY RAND() LIMIT 102.55ms3.03KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:183Copy
  • SELECT `alias` FROM `hdazu_content` WHERE `id` = :id296μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `hdazu_content` WHERE `id` = :id133μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT * FROM `hdazu_schemaorg` WHERE `itemId` = :itemId AND `context` = :context252μs1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:408Copy
  • 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 `hdazu_content` AS `a` INNER JOIN `hdazu_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `hdazu_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `hdazu_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `hdazu_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `hdazu_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)531μs24.67KBParams/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 `hdazu_scheduler_tasks` AS `a` WHERE `a`.`state` = 1214μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `hdazu_session` WHERE `session_id` = ?186μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `hdazu_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.27ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy