فهرست‌

logo with site

 

گام‌های فرایند پژوهش

بخش‌های کتابخانه

شاخص جی G-index

توضیحات
دسته: 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! InfoRequestSessionProfileQueries52
8.648MBMemory Usage337msRequest Duration
Joomla! Version4.4.2
PHP Version8.2.13
Identityguest
Response200
Templatefumlibrary
Database
Server
mysql
Version
10.5.28-MariaDB-0+deb11u1-log
Collation
utf8mb4_persian_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:3 [ "catid" => "819" "id" => "4624:g-index" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:42 [ "HTTPS" => "on" "SSL_TLS_SNI" => "library2.um.ac.ir" "HTTP_HOST" => "library2.um.ac...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1742152792 "last" => 1742152792...
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" => "fa-IR" ]
  • afterLoad (455.54KB) (6.76ms)
  • afterInitialise (1.29MB) (93.51ms)
  • afterRoute (1.33MB) (48.53ms)
  • beforeRenderComponent com_content (53.98KB) (3.91ms)
  • Before Access::preloadComponents (all components) (47.17KB) (6.98ms)
  • After Access::preloadComponents (all components) (123.05KB) (788μs)
  • Before Access::preloadPermissions (com_content) (1.85KB) (43μs)
  • After Access::preloadPermissions (com_content) (2.75MB) (11.76ms)
  • Before Access::getAssetRules (id:5674 name:com_content.article.4624) (130.65KB) (345μs)
  • After Access::getAssetRules (id:5674 name:com_content.article.4624) (9.16KB) (314μs)
  • afterRenderComponent com_content (348.94KB) (35.79ms)
  • Before Access::getAssetRules (id:8 name:com_content) (3.77KB) (3.25ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (35μs)
  • afterDispatch (14.66KB) (2.55ms)
  • beforeRenderRawModule mod_articles_category (گام‌های فرایند پژوهش) (333.13KB) (13.64ms)
  • afterRenderRawModule mod_articles_category (گام‌های فرایند پژوهش) (142.3KB) (21.54ms)
  • beforeRenderRawModule mod_articles_category (بخش‌های کتابخانه) (736B) (107μs)
  • afterRenderRawModule mod_articles_category (بخش‌های کتابخانه) (163.22KB) (18.87ms)
  • beforeRenderRawModule mod_menu (منوی بالا(فارسی)) (4.93KB) (180μs)
  • afterRenderRawModule mod_menu (منوی بالا(فارسی)) (79.34KB) (10.54ms)
  • beforeRenderRawModule mod_custom (لوگو) (1.14KB) (85μs)
  • afterRenderRawModule mod_custom (لوگو) (4.2KB) (2.28ms)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (673.63KB) (6.29ms)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (10.56KB) (3.72ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (12μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.74KB) (625μs)
  • beforeRenderModule mod_articles_category (گام‌های فرایند پژوهش) (7.42KB) (86μs)
  • afterRenderModule mod_articles_category (گام‌های فرایند پژوهش) (5.84KB) (538μs)
  • beforeRenderModule mod_articles_category (بخش‌های کتابخانه) (1.07KB) (45μs)
  • afterRenderModule mod_articles_category (بخش‌های کتابخانه) (6.76KB) (53μs)
  • beforeRenderRawModule mod_custom (شبکه های اجتماعی) (6.88KB) (63μs)
  • afterRenderRawModule mod_custom (شبکه های اجتماعی) (928B) (273μs)
  • beforeRenderModule mod_custom (شبکه های اجتماعی) (736B) (6μs)
  • afterRenderModule mod_custom (شبکه های اجتماعی) (5.08KB) (136μs)
  • beforeRenderRawModule mod_menu (منوی سمت راست(فارسی)) (1.51KB) (54μs)
  • afterRenderRawModule mod_menu (منوی سمت راست(فارسی)) (336.11KB) (26.77ms)
  • beforeRenderModule mod_menu (منوی سمت راست(فارسی)) (736B) (10μs)
  • afterRenderModule mod_menu (منوی سمت راست(فارسی)) (14.33KB) (151μs)
  • beforeRenderRawModule mod_custom (middle) (2.16KB) (66μs)
  • afterRenderRawModule mod_custom (middle) (976B) (262μs)
  • beforeRenderModule mod_custom (middle) (704B) (5μs)
  • afterRenderModule mod_custom (middle) (2.48KB) (129μs)
  • beforeRenderRawModule mod_custom (آرم کتابخانه مرکزی) (136B) (50μs)
  • afterRenderRawModule mod_custom (آرم کتابخانه مرکزی) (928B) (245μs)
  • beforeRenderModule mod_custom (آرم کتابخانه مرکزی) (736B) (5μs)
  • afterRenderModule mod_custom (آرم کتابخانه مرکزی) (2.95KB) (124μs)
  • beforeRenderModule mod_menu (منوی بالا(فارسی)) (1.41KB) (51μs)
  • afterRenderModule mod_menu (منوی بالا(فارسی)) (2.71KB) (37μs)
  • beforeRenderModule mod_custom (لوگو) (1.73KB) (40μs)
  • afterRenderModule mod_custom (لوگو) (2.18KB) (34μs)
  • afterRender (135.71KB) (13.98ms)
  • 1 x afterInitialise (1.29MB) (27.77%)
    93.51ms
    1 x afterRoute (1.33MB) (14.42%)
    48.53ms
    1 x afterRenderComponent com_content (348.94KB) (10.63%)
    35.79ms
    1 x afterRenderRawModule mod_menu (منوی سمت راست(فارسی)) (336.11KB) (7.95%)
    26.77ms
    1 x afterRenderRawModule mod_articles_category (گام‌های فرایند پژوهش) (142.3KB) (6.4%)
    21.54ms
    1 x afterRenderRawModule mod_articles_category (بخش‌های کتابخانه) (163.22KB) (5.61%)
    18.87ms
    1 x afterRender (135.71KB) (4.15%)
    13.98ms
    1 x beforeRenderRawModule mod_articles_category (گام‌های فرایند پژوهش) (333.13KB) (4.05%)
    13.64ms
    1 x After Access::preloadPermissions (com_content) (2.75MB) (3.49%)
    11.76ms
    1 x afterRenderRawModule mod_menu (منوی بالا(فارسی)) (79.34KB) (3.13%)
    10.54ms
    1 x Before Access::preloadComponents (all components) (47.17KB) (2.07%)
    6.98ms
    1 x afterLoad (455.54KB) (2.01%)
    6.76ms
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (673.63KB) (1.87%)
    6.29ms
    1 x beforeRenderComponent com_content (53.98KB) (1.16%)
    3.91ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (10.56KB) (1.1%)
    3.72ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (3.77KB) (0.97%)
    3.25ms
    1 x afterDispatch (14.66KB) (0.76%)
    2.55ms
    1 x afterRenderRawModule mod_custom (لوگو) (4.2KB) (0.68%)
    2.28ms
    1 x After Access::preloadComponents (all components) (123.05KB) (0.23%)
    788μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.74KB) (0.19%)
    625μs
    1 x afterRenderModule mod_articles_category (گام‌های فرایند پژوهش) (5.84KB) (0.16%)
    538μs
    1 x Before Access::getAssetRules (id:5674 name:com_content.article.4624) (130.65KB) (0.1%)
    345μs
    1 x After Access::getAssetRules (id:5674 name:com_content.article.4624) (9.16KB) (0.09%)
    314μs
    1 x afterRenderRawModule mod_custom (شبکه های اجتماعی) (928B) (0.08%)
    273μs
    1 x afterRenderRawModule mod_custom (middle) (976B) (0.08%)
    262μs
    1 x afterRenderRawModule mod_custom (آرم کتابخانه مرکزی) (928B) (0.07%)
    245μs
    1 x beforeRenderRawModule mod_menu (منوی بالا(فارسی)) (4.93KB) (0.05%)
    180μs
    1 x afterRenderModule mod_menu (منوی سمت راست(فارسی)) (14.33KB) (0.04%)
    151μs
    1 x afterRenderModule mod_custom (شبکه های اجتماعی) (5.08KB) (0.04%)
    136μs
    1 x afterRenderModule mod_custom (middle) (2.48KB) (0.04%)
    129μs
    1 x afterRenderModule mod_custom (آرم کتابخانه مرکزی) (2.95KB) (0.04%)
    124μs
    1 x beforeRenderRawModule mod_articles_category (بخش‌های کتابخانه) (736B) (0.03%)
    107μs
    1 x beforeRenderModule mod_articles_category (گام‌های فرایند پژوهش) (7.42KB) (0.03%)
    86μs
    1 x beforeRenderRawModule mod_custom (لوگو) (1.14KB) (0.03%)
    85μs
    1 x beforeRenderRawModule mod_custom (middle) (2.16KB) (0.02%)
    66μs
    1 x beforeRenderRawModule mod_custom (شبکه های اجتماعی) (6.88KB) (0.02%)
    63μs
    1 x beforeRenderRawModule mod_menu (منوی سمت راست(فارسی)) (1.51KB) (0.02%)
    54μs
    1 x afterRenderModule mod_articles_category (بخش‌های کتابخانه) (6.76KB) (0.02%)
    53μs
    1 x beforeRenderModule mod_menu (منوی بالا(فارسی)) (1.41KB) (0.02%)
    51μs
    1 x beforeRenderRawModule mod_custom (آرم کتابخانه مرکزی) (136B) (0.01%)
    50μs
    1 x beforeRenderModule mod_articles_category (بخش‌های کتابخانه) (1.07KB) (0.01%)
    45μs
    1 x Before Access::preloadPermissions (com_content) (1.85KB) (0.01%)
    43μs
    1 x beforeRenderModule mod_custom (لوگو) (1.73KB) (0.01%)
    40μs
    1 x afterRenderModule mod_menu (منوی بالا(فارسی)) (2.71KB) (0.01%)
    37μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)
    35μs
    1 x afterRenderModule mod_custom (لوگو) (2.18KB) (0.01%)
    34μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    12μs
    1 x beforeRenderModule mod_menu (منوی سمت راست(فارسی)) (736B) (0%)
    10μ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%)
    5μs
52 statements were executed, 23 of which were duplicates, 29 unique73.83ms3.09MB
UniquesDuplicates 1Duplicates 2Duplicates 3
  • SELECT `data` FROM `hcnov_session` WHERE `session_id` = ?2.64ms17KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `hcnov_session` WHERE `session_id` = :session_id LIMIT 11.16ms16.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.94ms1.66KBParamsCopy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `hcnov_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1243μs16.84KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `hcnov_viewlevels`189μ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` = :guest159μ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`244μs19.82KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `hcnov_languages` WHERE `published` = 1 ORDER BY `ordering` ASC215μ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` = 1172μs16.88KB/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM hcnov_rsform_config2.06ms16.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`15.84ms1.41MBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM hcnov_extensions WHERE element = "com_multicats"248μs16.63KB/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` = 1201μ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)360μ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.23ms229.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)10.76ms76.51KBParams/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT id,alias FROM hcnov_categories WHERE id = 819173μ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`325μ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)2.59ms18.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`294μ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 ASC344μ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`315μs19.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `language`,`id` FROM `hcnov_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0301μs16.13KB/libraries/src/Language/Multilanguage.php:123Copy
  • 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 != 'fa-IR' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-03-16 19:19:52') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-03-16 19:19:52') AND c2.state = 11.87ms17.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.01ms330.67KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,mc.catid AS mcatids,m.ordering AS m_ordering FROM `hcnov_content` AS `a` LEFT JOIN `hcnov_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `hcnov_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `hcnov_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `hcnov_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `hcnov_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN hcnov_multicats_content_catid AS mc ON mc.item_id = a.id LEFT JOIN hcnov_content_multicats AS m ON (m.content_id = a.id AND FIND_IN_SET(m.catid,mc.catid) ) WHERE (`a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition) AND (`a`.`featured` = 0 OR (`fp`.`featured_up` IS NOT NULL AND `fp`.`featured_up` >= :featuredUp) OR (`fp`.`featured_down` IS NOT NULL AND `fp`.`featured_down` <= :featuredDown)) AND ( FIND_IN_SET("850",mc.catid) ) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray3,:preparedArray4) GROUP BY a.id,a.id ORDER BY a.title ASC10.49ms117.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 850 AND c.access IN (1,5)153μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 850 AND c.access IN (1,5)132μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 850 AND c.access IN (1,5)126μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 850 AND c.access IN (1,5)124μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 850 AND c.access IN (1,5)158μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 850 AND c.access IN (1,5)124μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 850 AND c.access IN (1,5)127μs18.54KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 850 AND c.access IN (1,5)136μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • 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`221μs19.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,mc.catid AS mcatids,m.ordering AS m_ordering FROM `hcnov_content` AS `a` LEFT JOIN `hcnov_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `hcnov_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `hcnov_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `hcnov_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `hcnov_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN hcnov_multicats_content_catid AS mc ON mc.item_id = a.id LEFT JOIN hcnov_content_multicats AS m ON (m.content_id = a.id AND FIND_IN_SET(m.catid,mc.catid) ) WHERE (`a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition) AND (`a`.`featured` = 0 OR (`fp`.`featured_up` IS NOT NULL AND `fp`.`featured_up` >= :featuredUp) OR (`fp`.`featured_down` IS NOT NULL AND `fp`.`featured_down` <= :featuredDown)) AND ( FIND_IN_SET("1173",mc.catid) ) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray3,:preparedArray4) GROUP BY a.id,a.id ORDER BY a.title ASC9.54ms205.67KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)151μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)132μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)138μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)166μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)172μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)135μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)140μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)130μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)128μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)131μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)130μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • SELECT c.id FROM hcnov_categories AS c WHERE c.id = 1173 AND c.access IN (1,5)129μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752Copy
  • 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`230μs19.16KBParams/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.26ms17.1KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `hcnov_session` WHERE `session_id` = ?409μs16.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `hcnov_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.02ms1.66KBParamsCopy