شاخص جی G-index

Details: Category: scientometric

یکی دیگر از ضعف‌های شاخص اچ، نادیده گرفتن مقالات پراستناد است. در سال ۲۰۰۶ شاخص G برای تکمیل عملکرد شاخص h و رفع این ضعف توسط دانشمندی بلژیکی به نام اگه معرفی شد. در این شاخص بر خلاف شاخص هرش به مقالاتی که بیشتر مورد استناد قرار می‌گیرد وزن بیشتری داده می‌شود. بنا به تعریف شاخص g برابر است با بالاترین رتبه در لیست نزولی مقالات به ترتیبی که g مقاله اول حداقل تعداد g2 استناد دریافت کرده باشند و مجموع استناد‌های مقالات تا g بزرگتر یا مساوی g2 باشد. با توجه و دقت در نحوه محاسبه G-Index در می‌یابیم که میزان G-Index هیچ وقت کمتر از H-Index نخواهد بود.

برای برجسته کردن مقالات پراستناد و اصلاح شاخص اچ مطرح شد. بالاترین تعداد مقالات است که جی به توان 2 یا بیشتر به آن استناد شده است.

به عنوان مثال در جدول زیر عدد 6 شاخص جی است زیرا از 6 به توان 2 به بعد فراوانی تجمعی استنادات کمتر از کمتر از ضریب جی به توان 2 است.

تعداد مقالات	11	10	9	8	7	6	5	4	3	2	1
تعداد استنادات	0	0	1	3	4	5	5	6	6	7	8
فراوانی تجمعی استنادات	45	45	45	44	41	37	32	27	21	15	8
جی به توان 2	121	100	81	64	49	36	25	16	9	4	1

شاخص جی: برای برجسته کردن مقالات پراستناد و اصلاح شاخص اچ مطرح شد. بالاترین تعداد مقالات است که جی به توان 2 (g2) یا بیشتر به آن استناد شده است.

J! Info Request Session Profile Queries33

11.232MB685ms

Joomla! Version	4.4.2
PHP Version	8.2.13
Identity	guest
Response	200
Template	fumlibrary
Database	Server mysql Version 10.5.28-MariaDB-0+deb11u1-log Collation utf8mb4_persian_ci Conn Collation utf8mb4_general_ci

$_GET: array:2 [ "id" => "4624" "view" => "article" ]
$_POST: []
$_SESSION: array:1 [ "joomla" => "***redacted***" ]
$_COOKIE: []
$_SERVER: array:42 [ "HTTPS" => "on" "SSL_TLS_SNI" => "stp2.um.ac.ir" "HTTP_HOST" => "stp2.um.ac.ir" "...

session: array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746569945 "last" => 1746569945...
registry: array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user: array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter: array:1 [ "language" => "en-GB" ]

afterLoad (455.43KB) (18.26ms)
afterInitialise (1.29MB) (64.62ms)
afterRoute (1.64MB) (39.69ms)
beforeRenderComponent com_content (53.12KB) (2.26ms)
Before Access::preloadComponents (all components) (45.61KB) (4.41ms)
After Access::preloadComponents (all components) (123.05KB) (773μs)
Before Access::preloadPermissions (com_content) (1.85KB) (42μs)
After Access::preloadPermissions (com_content) (2.75MB) (13.09ms)
Before Access::getAssetRules (id:5674 name:com_content.article.4624) (130.65KB) (364μs)
After Access::getAssetRules (id:5674 name:com_content.article.4624) (9.16KB) (305μs)
afterRenderComponent com_content (354.07KB) (22.8ms)
Before Access::getAssetRules (id:8 name:com_content) (36.75KB) (4.69ms)
After Access::getAssetRules (id:8 name:com_content) (1.28KB) (37μs)
afterDispatch (13.11KB) (1.85ms)
beforeRenderRawModule mod_menu (منوی اصلی - انگلیسی) (323.8KB) (11.63ms)
afterRenderRawModule mod_menu (منوی اصلی - انگلیسی) (1.16MB) (461ms)
beforeRenderRawModule mod_custom (لوگو) (1.19KB) (135μs)
afterRenderRawModule mod_custom (لوگو) (4.47KB) (1ms)
beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (711.85KB) (3.85ms)
afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.29KB) (2.18ms)
beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (12μs)
afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.73KB) (373μs)
beforeRenderRawModule mod_custom (شبکه های اجتماعی) (128B) (63μs)
afterRenderRawModule mod_custom (شبکه های اجتماعی) (928B) (147μs)
beforeRenderModule mod_custom (شبکه های اجتماعی) (736B) (6μs)
afterRenderModule mod_custom (شبکه های اجتماعی) (3.83KB) (93μs)
beforeRenderRawModule mod_menu (منوی سمت راست(فارسی)) (1.51KB) (52μs)
afterRenderRawModule mod_menu (منوی سمت راست(فارسی)) (310.72KB) (14.02ms)
beforeRenderModule mod_menu (منوی سمت راست(فارسی)) (736B) (27μs)
afterRenderModule mod_menu (منوی سمت راست(فارسی)) (14.33KB) (141μs)
beforeRenderRawModule mod_custom (middle) (2.32KB) (96μs)
afterRenderRawModule mod_custom (middle) (976B) (160μs)
beforeRenderModule mod_custom (middle) (704B) (5μs)
afterRenderModule mod_custom (middle) (3.73KB) (84μs)
beforeRenderRawModule mod_custom (آرم کتابخانه مرکزی) (184B) (49μs)
afterRenderRawModule mod_custom (آرم کتابخانه مرکزی) (928B) (131μs)
beforeRenderModule mod_custom (آرم کتابخانه مرکزی) (736B) (4μs)
afterRenderModule mod_custom (آرم کتابخانه مرکزی) (2.95KB) (76μs)
beforeRenderModule mod_menu (منوی اصلی - انگلیسی) (1.96KB) (52μs)
afterRenderModule mod_menu (منوی اصلی - انگلیسی) (271.32KB) (658μs)
beforeRenderModule mod_custom (لوگو) (2.56KB) (56μs)
afterRenderModule mod_custom (لوگو) (2.18KB) (59μs)
afterRender (656.57KB) (15.2ms)

1 x afterRenderRawModule mod_menu (منوی اصلی - انگلیسی) (1.16MB) (67.2%)	460.56ms
1 x afterInitialise (1.29MB) (9.43%)	64.62ms
1 x afterRoute (1.64MB) (5.79%)	39.69ms
1 x afterRenderComponent com_content (354.07KB) (3.33%)	22.80ms
1 x afterLoad (455.43KB) (2.66%)	18.26ms
1 x afterRender (656.57KB) (2.22%)	15.20ms
1 x afterRenderRawModule mod_menu (منوی سمت راست(فارسی)) (310.72KB) (2.05%)	14.02ms
1 x After Access::preloadPermissions (com_content) (2.75MB) (1.91%)	13.09ms
1 x beforeRenderRawModule mod_menu (منوی اصلی - انگلیسی) (323.8KB) (1.7%)	11.63ms
1 x Before Access::getAssetRules (id:8 name:com_content) (36.75KB) (0.68%)	4.69ms
1 x Before Access::preloadComponents (all components) (45.61KB) (0.64%)	4.41ms
1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (711.85KB) (0.56%)	3.85ms
1 x beforeRenderComponent com_content (53.12KB) (0.33%)	2.26ms
1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.29KB) (0.32%)	2.18ms
1 x afterDispatch (13.11KB) (0.27%)	1.85ms
1 x afterRenderRawModule mod_custom (لوگو) (4.47KB) (0.15%)	1.00ms
1 x After Access::preloadComponents (all components) (123.05KB) (0.11%)	773μs
1 x afterRenderModule mod_menu (منوی اصلی - انگلیسی) (271.32KB) (0.1%)	658μs
1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.73KB) (0.05%)	373μs
1 x Before Access::getAssetRules (id:5674 name:com_content.article.4624) (130.65KB) (0.05%)	364μs
1 x After Access::getAssetRules (id:5674 name:com_content.article.4624) (9.16KB) (0.04%)	305μs
1 x afterRenderRawModule mod_custom (middle) (976B) (0.02%)	160μs
1 x afterRenderRawModule mod_custom (شبکه های اجتماعی) (928B) (0.02%)	147μs
1 x afterRenderModule mod_menu (منوی سمت راست(فارسی)) (14.33KB) (0.02%)	141μs
1 x beforeRenderRawModule mod_custom (لوگو) (1.19KB) (0.02%)	135μs
1 x afterRenderRawModule mod_custom (آرم کتابخانه مرکزی) (928B) (0.02%)	131μs
1 x beforeRenderRawModule mod_custom (middle) (2.32KB) (0.01%)	96μs
1 x afterRenderModule mod_custom (شبکه های اجتماعی) (3.83KB) (0.01%)	93μs
1 x afterRenderModule mod_custom (middle) (3.73KB) (0.01%)	84μs
1 x afterRenderModule mod_custom (آرم کتابخانه مرکزی) (2.95KB) (0.01%)	76μs
1 x beforeRenderRawModule mod_custom (شبکه های اجتماعی) (128B) (0.01%)	63μs
1 x afterRenderModule mod_custom (لوگو) (2.18KB) (0.01%)	59μs
1 x beforeRenderModule mod_custom (لوگو) (2.56KB) (0.01%)	56μs
1 x beforeRenderRawModule mod_menu (منوی سمت راست(فارسی)) (1.51KB) (0.01%)	52μs
1 x beforeRenderModule mod_menu (منوی اصلی - انگلیسی) (1.96KB) (0.01%)	52μs
1 x beforeRenderRawModule mod_custom (آرم کتابخانه مرکزی) (184B) (0.01%)	49μs
1 x Before Access::preloadPermissions (com_content) (1.85KB) (0.01%)	42μs
1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)	37μs
1 x beforeRenderModule mod_menu (منوی سمت راست(فارسی)) (736B) (0%)	27μs
1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)	12μs
1 x beforeRenderModule mod_custom (شبکه های اجتماعی) (736B) (0%)	6μs
1 x beforeRenderModule mod_custom (middle) (704B) (0%)	5μs
1 x beforeRenderModule mod_custom (آرم کتابخانه مرکزی) (736B) (0%)	4μs

33 statements were executed, 5 of which were duplicates, 28 unique35.74ms2.51MB

SELECT `data` FROM `hcnov_session` WHERE `session_id` = ?816μs17KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
SELECT `session_id` FROM `hcnov_session` WHERE `session_id` = :session_id LIMIT 1397μs16.98KBParams/libraries/src/Session/MetadataManager.php:187Copy
INSERT INTO `hcnov_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.65ms1.66KBParamsCopy
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `hcnov_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1306μs16.84KB/libraries/src/Component/ComponentHelper.php:399Copy
SELECT `id`,`rules` FROM `hcnov_viewlevels`129μs16.44KB/libraries/src/Access/Access.php:955Copy
SELECT `b`.`id` FROM `hcnov_usergroups` AS `a` LEFT JOIN `hcnov_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest118μs17.03KBParams/libraries/src/Access/Access.php:868Copy
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `hcnov_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`154μs19.82KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
SELECT * FROM `hcnov_languages` WHERE `published` = 1 ORDER BY `ordering` ASC181μs16.42KB/libraries/src/Language/LanguageHelper.php:142Copy
SELECT `element`,`name`,`client_id`,`extension_id` FROM `hcnov_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1106μs16.88KB/libraries/src/Language/LanguageHelper.php:213Copy
SELECT * FROM hcnov_rsform_config168μs16.48KB/administrator/components/com_rsform/helpers/config.php:52Copy
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 `hcnov_menu` AS `m` LEFT JOIN `hcnov_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`12.22ms1.41MBParams/libraries/src/Menu/SiteMenu.php:166Copy
SELECT * FROM hcnov_extensions WHERE element = "com_multicats"236μs16.59KB/administrator/components/com_multicats/helpers/multicats.php:759Copy
SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `hcnov_template_styles` AS `s` LEFT JOIN `hcnov_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` = 1145μs16.19KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
SELECT `id`,`name`,`rules`,`parent_id` FROM `hcnov_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,:preparedArray46,:preparedArray47)309μs26.7KBParams/libraries/src/Access/Access.php:357Copy
SELECT `id`,`name`,`rules`,`parent_id` FROM `hcnov_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.61ms229.19KBParams/libraries/src/Access/Access.php:301Copy
SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `hcnov_content` AS `a` INNER JOIN `hcnov_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `hcnov_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `hcnov_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `hcnov_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `hcnov_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)3.71ms76.51KBParams/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticleModel.php:215Copy
SELECT id,alias FROM hcnov_categories WHERE id = 819191μs17.31KB/components/com_multicats/helpers/content.php:105Copy
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 `hcnov_categories` AS `s` INNER JOIN `hcnov_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`267μs19.2KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT `m`.`tag_id`,`t`.* FROM `hcnov_contentitem_tag_map` AS `m` INNER JOIN `hcnov_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.38ms18.27KBParams/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 `hcnov_categories` AS `s` INNER JOIN `hcnov_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`189μs19.2KBParams/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 hcnov_fields AS a LEFT JOIN `hcnov_languages` AS l ON l.lang_code = a.language LEFT JOIN hcnov_users AS uc ON uc.id=a.checked_out LEFT JOIN hcnov_viewlevels AS ag ON ag.id = a.access LEFT JOIN hcnov_users AS ua ON ua.id = a.created_user_id LEFT JOIN hcnov_fields_groups AS g ON g.id = a.group_id LEFT JOIN `hcnov_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 ASC241μs20.33KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `hcnov_categories` AS `s` INNER JOIN `hcnov_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`181μs19.2KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT `language`,`id` FROM `hcnov_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0172μs16.13KB/libraries/src/Language/Multilanguage.php:123Copy
SELECT `alias` FROM `hcnov_content` WHERE `id` = :id519μs16.92KBParams/components/com_content/src/Service/Router.php:168Copy
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 `hcnov_categories` AS `s` INNER JOIN `hcnov_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`891μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT `alias` FROM `hcnov_content` WHERE `id` = :id120μs16.92KBParams/components/com_content/src/Service/Router.php:168Copy
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `hcnov_content` AS `c` INNER JOIN `hcnov_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `hcnov_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `hcnov_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `hcnov_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-05-06 22:19:05') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-05-06 22:19:05') AND c2.state = 11.43ms17.85KBParams/libraries/src/Language/Associations.php:145Copy
SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `hcnov_modules` AS `m` LEFT JOIN `hcnov_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `hcnov_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`4.33ms330.67KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
SELECT `alias` FROM `hcnov_content` WHERE `id` = :id249μs16.92KBParams/components/com_content/src/Service/Router.php:168Copy
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 `hcnov_categories` AS `s` INNER JOIN `hcnov_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`145μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
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 `hcnov_scheduler_tasks` AS `a` WHERE `a`.`state` = 11.12ms17.1KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
SELECT `session_id` FROM `hcnov_session` WHERE `session_id` = ?810μs16.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
UPDATE `hcnov_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.24ms4.16KBParamsCopy