Wirtualny Oddział Terenowy Polskiego Związku Krótkofalowców (OT-73). Witamy!
kwiecień 08, 2025

Badania obwodów rezonansowych analizatorem NanoVNA

vna

Od pewnego  czasu zastanawiałem się jak szerzej wykorzystać mój wektorowy analizator NanoVNA V 2_2 niż pomiary anten czy filtrów.

Pierwsza rzecz, która przyszła mi do głowy do pomiary pojemności i indukcyjności. Pomiar analizatorem ma istotną przewagę od pomiarów miernikami RLC, ponieważ możemy zbadać parametry elementu w zakresie częstotliwości na których ma on pracować. Mierniki RLC dają tu pewien wybór, ale zwykle kończy się zakres na kilkuset kilohercach. Np. LC-200A mierzy indukcyjności kilku mikrohenrów na częstotliwościach 500 - 650 KHz, co jest znacznie poniżej częstotliwości pracy urządzeń krótkofalarskich.

Drugi temat to badanie obwodów rezonansowych. Kiedyś używało się do tego Grid / gate dip metry czyli generatory z cewką na wierzchu obudowy, którą sprzęgało się z badanym obwodem. Gdy dostroiliśmy częstotliwość do rezonansu, część energii była pobierana przez badany obwód co widać było w postaci spadku napięcia na siatce lampy lub bramce feta i można było ze skali odczytać częstotliwość rezonansu badanego obwodu. Słabą stroną tych mierników był wpływ badanego obwodu na częstotliwość generatora, ale na podłączonym liczniku częstotliwości można było odczytać dokładną częstotliwość.

 Postanowiłem spróbować wykorzystać VNA w podobny sposób.

Tyle na wstępie, a teraz do rzeczy.

Marcin SP5IOU

Downloads:

 

10.213MBMemory Usage304msRequest Duration
Joomla! Version5.2.5
PHP Version8.2.21
Identityguest
Response200
Templatejl_zmagazine_pro
Database
Server
mysql
Version
8.0.31-23
Collation
utf8mb4_polish_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:74 [ "UNIQUE_ID" => "Z_TfOyCdskVdsA1GnUQhwAAAAAA" "HTTP_AUTHORIZATION" => "" "HTTPS" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744101179 "last" => 1744101179...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (75.39KB) (6.34ms)
  • afterInitialise (1.53MB) (39.92ms)
  • afterRoute (409.84KB) (37.53ms)
  • beforeRenderComponent com_content (39.74KB) (3.53ms)
  • Before Access::preloadComponents (all components) (34.3KB) (1.49ms)
  • After Access::preloadComponents (all components) (136.52KB) (2.16ms)
  • Before Access::preloadPermissions (com_content) (1.76KB) (19μs)
  • After Access::preloadPermissions (com_content) (130.96KB) (2.36ms)
  • Before Access::getAssetRules (id:351 name:com_content.article.179) (6.65KB) (22μs)
  • After Access::getAssetRules (id:351 name:com_content.article.179) (8.63KB) (193μs)
  • Before Access::getAssetRules (id:1 name:root.1) (1.31MB) (64.34ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.02KB) (37μs)
  • Before Access::getAssetRules (id:364 name:com_jdownloads) (1.57KB) (90μs)
  • After Access::getAssetRules (id:364 name:com_jdownloads) (6.34KB) (24μs)
  • Before Access::preloadPermissions (com_jdownloads) (23.7KB) (79μs)
  • After Access::preloadPermissions (com_jdownloads) (20.98KB) (1.83ms)
  • Before Access::getAssetRules (id:371 name:com_jdownloads.download.3) (280B) (18μs)
  • After Access::getAssetRules (id:371 name:com_jdownloads.download.3) (1.92KB) (10μs)
  • afterRenderComponent com_content (574.88KB) (58.86ms)
  • afterDispatch (2.78KB) (264μs)
  • beforeRenderRawModule mod_gantry5_particle (Date) (566.66KB) (18.26ms)
  • afterRenderRawModule mod_gantry5_particle (Date) (8.94KB) (1.43ms)
  • beforeRenderModule mod_gantry5_particle (Date) (720B) (6μs)
  • afterRenderModule mod_gantry5_particle (Date) (3.44KB) (402μs)
  • afterRender (1.33MB) (62.59ms)
  • 1 x Before Access::getAssetRules (id:1 name:root.1) (1.31MB) (21.16%)
    64.34ms
    1 x afterRender (1.33MB) (20.58%)
    62.59ms
    1 x afterRenderComponent com_content (574.88KB) (19.35%)
    58.86ms
    1 x afterInitialise (1.53MB) (13.13%)
    39.92ms
    1 x afterRoute (409.84KB) (12.34%)
    37.53ms
    1 x beforeRenderRawModule mod_gantry5_particle (Date) (566.66KB) (6%)
    18.26ms
    1 x afterLoad (75.39KB) (2.08%)
    6.34ms
    1 x beforeRenderComponent com_content (39.74KB) (1.16%)
    3.53ms
    1 x After Access::preloadPermissions (com_content) (130.96KB) (0.78%)
    2.36ms
    1 x After Access::preloadComponents (all components) (136.52KB) (0.71%)
    2.16ms
    1 x After Access::preloadPermissions (com_jdownloads) (20.98KB) (0.6%)
    1.83ms
    1 x Before Access::preloadComponents (all components) (34.3KB) (0.49%)
    1.49ms
    1 x afterRenderRawModule mod_gantry5_particle (Date) (8.94KB) (0.47%)
    1.43ms
    1 x afterRenderModule mod_gantry5_particle (Date) (3.44KB) (0.13%)
    402μs
    1 x afterDispatch (2.78KB) (0.09%)
    264μs
    1 x After Access::getAssetRules (id:351 name:com_content.article.179) (8.63KB) (0.06%)
    193μs
    1 x Before Access::getAssetRules (id:364 name:com_jdownloads) (1.57KB) (0.03%)
    90μs
    1 x Before Access::preloadPermissions (com_jdownloads) (23.7KB) (0.03%)
    79μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0.01%)
    37μs
    1 x After Access::getAssetRules (id:364 name:com_jdownloads) (6.34KB) (0.01%)
    24μs
    1 x Before Access::getAssetRules (id:351 name:com_content.article.179) (6.65KB) (0.01%)
    22μs
    1 x Before Access::preloadPermissions (com_content) (1.76KB) (0.01%)
    19μs
    1 x Before Access::getAssetRules (id:371 name:com_jdownloads.download.3) (280B) (0.01%)
    18μs
    1 x After Access::getAssetRules (id:371 name:com_jdownloads.download.3) (1.92KB) (0%)
    10μs
    1 x beforeRenderModule mod_gantry5_particle (Date) (720B) (0%)
    6μs
67 statements were executed, 18 of which were duplicates, 49 unique80.59ms225.45KB
  • SELECT @@SESSION.sql_mode;1.1ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `uon3_session` WHERE `session_id` = ?277μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `uon3_session` WHERE `session_id` = :session_id LIMIT 1237μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `uon3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)904μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `uon3_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 11.08ms17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `uon3_viewlevels`305μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `uon3_usergroups` AS `a` LEFT JOIN `uon3_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest643μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `uon3_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.51ms3.98KBParams/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 `uon3_menu` AS `m` LEFT JOIN `uon3_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`2.18ms36.8KBParams/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 `uon3_categories` AS `s` INNER JOIN `uon3_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.42ms3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `uon3_content` WHERE `alias` = :segment AND `catid` = :id648μs1.34KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `uon3_template_styles` AS `s` LEFT JOIN `uon3_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` = 1813μs944B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM uon3_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_zmagazine_pro' ORDER BY s.id667μs848B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"5.15ms3.06KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635Copy
  • SELECT * FROM `uon3_languages` WHERE `published` = 1 ORDER BY `ordering` ASC639μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `uon3_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,:preparedArray44,:preparedArray45)1.46ms7.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `uon3_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.84ms6.73KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `uon3_content`2.61ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `uon3_content` SET `hits` = (`hits` + 1) WHERE `id` = '179'1.37ms48B/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 `uon3_content` AS `a` INNER JOIN `uon3_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `uon3_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `uon3_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `uon3_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `uon3_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)1.06ms6.12KBParams/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 `uon3_categories` AS `s` INNER JOIN `uon3_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`1.31ms3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `uon3_contentitem_tag_map` AS `m` INNER JOIN `uon3_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)1.62ms3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT id, link from uon3_menu WHERE link LIKE 'index.php?option=com_jdownloads&view=category%' AND published = 1764μs576B/plugins/content/jdownloads/jdownloads.php:76Copy
  • SELECT id, link, published, access, language FROM uon3_menu WHERE (link LIKE 'index.php?option=com_jdownloads%') AND published = 1 AND client_id = 0 AND language = 'pl-pl' AND access IN (1,5)490μs752B/components/com_jdownloads/src/Helper/JDHelper.php:247Copy
  • SELECT id, link, published, access, language FROM uon3_menu WHERE (link LIKE 'index.php?option=com_jdownloads%') AND published = 1 AND client_id = 0 AND access IN (1,5)1.02ms768B/components/com_jdownloads/src/Helper/JDHelper.php:252Copy
  • SELECT id FROM uon3_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND language = 'pl-pl' AND access IN (1,5)674μs520B/components/com_jdownloads/src/Helper/JDHelper.php:305Copy
  • SELECT id FROM uon3_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND access IN (1,5)1.2ms536B/components/com_jdownloads/src/Helper/JDHelper.php:310Copy
  • SELECT id FROM uon3_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND language = 'pl-pl' AND access IN (1,5)678μs520B/components/com_jdownloads/src/Helper/JDHelper.php:359Copy
  • SELECT id FROM uon3_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND access IN (1,5)750μs536B/components/com_jdownloads/src/Helper/JDHelper.php:364Copy
  • SELECT id FROM uon3_menu WHERE link = 'index.php?option=com_jdownloads&view=search' AND published = 1 AND client_id = 0 AND access IN (1,5)606μs520B/components/com_jdownloads/src/Helper/JDHelper.php:378Copy
  • SELECT id FROM uon3_menu WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit' AND published = 1 AND client_id = 0 AND access IN (1,5)602μs520B/components/com_jdownloads/src/Helper/JDHelper.php:383Copy
  • SELECT id, link from uon3_menu WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%' AND published = 1 AND access IN (1,5)579μs576B/components/com_jdownloads/src/Helper/JDHelper.php:415Copy
  • 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 `uon3_categories` AS `s` INNER JOIN `uon3_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`2.03ms6.42KBParams/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 uon3_fields AS a LEFT JOIN `uon3_languages` AS l ON l.lang_code = a.language LEFT JOIN uon3_users AS uc ON uc.id=a.checked_out LEFT JOIN uon3_viewlevels AS ag ON ag.id = a.access LEFT JOIN uon3_users AS ua ON ua.id = a.created_user_id LEFT JOIN uon3_fields_groups AS g ON g.id = a.group_id LEFT JOIN `uon3_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 ORDER BY a.ordering ASC2.05ms4.83KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `field_id`,`value` FROM `uon3_fields_values` WHERE `field_id` IN (:preparedArray1) AND `item_id` = :itemid923μs1.39KBParams/administrator/components/com_fields/src/Model/FieldModel.php:739Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `uon3_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.35ms1.73KBParams/libraries/src/Access/Access.php:301Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM uon3_jdownloads_files AS a LEFT JOIN uon3_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN uon3_jdownloads_categories AS c on c.id = a.catid LEFT JOIN uon3_users AS u on u.id = a.created_by LEFT JOIN uon3_users AS u2 on u2.id = a.modified_by LEFT JOIN uon3_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM uon3_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN uon3_jdownloads_licenses AS l on l.id = a.license LEFT JOIN uon3_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN uon3_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM uon3_jdownloads_categories AS cat JOIN uon3_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 3) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)2.12ms10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • 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 uon3_fields AS a LEFT JOIN `uon3_languages` AS l ON l.lang_code = a.language LEFT JOIN uon3_users AS uc ON uc.id=a.checked_out LEFT JOIN uon3_viewlevels AS ag ON ag.id = a.access LEFT JOIN uon3_users AS ua ON ua.id = a.created_user_id LEFT JOIN uon3_fields_groups AS g ON g.id = a.group_id LEFT JOIN `uon3_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.34ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `uon3_contentitem_tag_map` AS `m` INNER JOIN `uon3_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)1.11ms3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM uon3_jdownloads_templates WHERE (template_name = 'Alternate Files Layout v3.9') AND (template_typ = 2)921μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM uon3_jdownloads_usergroups_limits ORDER BY importance825μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM uon3_jdownloads_usergroups_limits WHERE group_id IN (1)1.5ms11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `uon3_usergroups` WHERE `id` = :id873μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SET SESSION SQL_BIG_SELECTS = 1718μs0B/components/com_jdownloads/src/Helper/CategoriesHelper.php:236Copy
  • SELECT c.*, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as slug,( SELECT COUNT(`files`.`id`) FROM `uon3_jdownloads_files` AS `files` WHERE `files`.`catid` = `c`.`id` AND `files`.`published` = 1 AND files.access IN (1,5) AND files.user_access = 0 AND (files.publish_up IS NULL OR files.publish_up <= '2025-04-08 08:32:59') AND (files.publish_down IS NULL OR files.publish_down >= '2025-04-08 08:32:59')) AS `numitems`,( SELECT COUNT(*) FROM `uon3_jdownloads_categories` AS `cat` WHERE `cat`.`parent_id` = `c`.`id` AND cat.parent_id > 1 AND cat.published = 1 AND cat.access IN (1,5)) AS `subcatitems`,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM `uon3_jdownloads_categories` AS `s` INNER JOIN `uon3_jdownloads_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) LEFT JOIN `uon3_jdownloads_files` AS files ON files.`catid` = c.id AND files.published = 1 LEFT JOIN uon3_users AS u on u.id = files.created_by LEFT JOIN uon3_users AS u2 on u2.id = files.modified_by LEFT JOIN (SELECT id, link, access, published from uon3_menu GROUP BY link) AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=', c.id) AND menu.published = 1 AND menu.access IN (1,5) WHERE c.access IN (1,5) AND c.published = 1 AND `s`.`id` = c.id GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.access ORDER BY c.lft4.22ms4.8KB/components/com_jdownloads/src/Helper/CategoriesHelper.php:433Copy
  • SET SESSION SQL_BIG_SELECTS = 1184μs0B/components/com_jdownloads/src/Helper/CategoriesHelper.php:236Copy
  • SELECT c.*, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as slug,( SELECT COUNT(`files`.`id`) FROM `uon3_jdownloads_files` AS `files` WHERE `files`.`catid` = `c`.`id` AND `files`.`published` = 1 AND files.access IN (1,5) AND files.user_access = 0 AND (files.publish_up IS NULL OR files.publish_up <= '2025-04-08 08:32:59') AND (files.publish_down IS NULL OR files.publish_down >= '2025-04-08 08:32:59')) AS `numitems`,( SELECT COUNT(*) FROM `uon3_jdownloads_categories` AS `cat` WHERE `cat`.`parent_id` = `c`.`id` AND cat.parent_id > 1 AND cat.published = 1 AND cat.access IN (1,5)) AS `subcatitems`,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM `uon3_jdownloads_categories` AS `s` INNER JOIN `uon3_jdownloads_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) LEFT JOIN `uon3_jdownloads_files` AS files ON files.`catid` = c.id AND files.published = 1 LEFT JOIN uon3_users AS u on u.id = files.created_by LEFT JOIN uon3_users AS u2 on u2.id = files.modified_by LEFT JOIN (SELECT id, link, access, published from uon3_menu GROUP BY link) AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=', c.id) AND menu.published = 1 AND menu.access IN (1,5) WHERE c.access IN (1,5) AND c.published = 1 AND `s`.`id` = c.id GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.access ORDER BY c.lft4.35ms4.8KB/components/com_jdownloads/src/Helper/CategoriesHelper.php:433Copy
  • 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 uon3_fields AS a LEFT JOIN `uon3_languages` AS l ON l.lang_code = a.language LEFT JOIN uon3_users AS uc ON uc.id=a.checked_out LEFT JOIN uon3_viewlevels AS ag ON ag.id = a.access LEFT JOIN uon3_users AS ua ON ua.id = a.created_user_id LEFT JOIN uon3_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC1.05ms4.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 `uon3_content` AS `a` LEFT JOIN `uon3_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 DESC855μs1.81KBParams/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 `uon3_categories` AS `s` INNER JOIN `uon3_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`1.19ms3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `uon3_modules` AS `m` LEFT JOIN `uon3_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `uon3_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`1.46ms1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `uon3_menu_types` AS `a` WHERE `a`.`client_id` = 0483μs624B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM uon3_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft1.5ms1.48KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT `params` FROM `uon3_comprofiler_plugin` WHERE `id` = 11.01ms536BCopy
  • SELECT * FROM `uon3_comprofiler_lists` WHERE `listid` = 12351μs1.28KBCopy
  • SELECT * FROM `uon3_comprofiler_lists` WHERE `listid` = 18413μs1.28KBCopy
  • SELECT * FROM `uon3_comprofiler_lists` WHERE `listid` = 7498μs1.28KBCopy
  • SELECT * FROM `uon3_comprofiler_lists` WHERE `listid` = 19416μs1.28KBCopy
  • SELECT * FROM `uon3_comprofiler_lists` WHERE `listid` = 8421μs1.28KBCopy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM uon3_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft1.19ms1.48KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM `uon3_schemaorg` WHERE `itemId` = :itemId AND `context` = :context357μ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 `uon3_content` AS `a` INNER JOIN `uon3_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `uon3_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `uon3_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `uon3_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `uon3_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)1.21ms6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `uon3_content` AS `a` INNER JOIN `uon3_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `uon3_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `uon3_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `uon3_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `uon3_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)1.1ms6.17KBParams/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 `uon3_scheduler_tasks` AS `a` WHERE `a`.`state` = 1416μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"3.33ms14.06KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:635Copy
  • SELECT `session_id` FROM `uon3_session` WHERE `session_id` = ?413μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `uon3_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.17ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy