فهرست‌
 

 

 

 

The human’s life has advanced with “questions” since the beginning of creation and this issue is as old as the human himself. Hence, mankind has always had many questions in his mind. The initial questions were simple and on the other hand, human’s answer to these questions was based on the experienced humans’ memory. As the human made progress and knowledge was developed, mental memories weren’t able to answer plentiful and various questions in different topics of the science and also the mental knowledge was not recordable and therefore, it wasn’t transferable to the next generation.

 

Nowadays, the huge resources of human’s knowledge are recorded and recoverable in printed and electronic sets. We need a knowledge and service named the “reference service” and the “reference interview” to understand what question is answered in what science resource and how to understand the client’s question with the best method. The reference unit is a place for keeping these resources i.e. resources with generally alphabetic structure (like dictionaries, encyclopedias, thesaurus, etc) and also for providing reference services such as answering the reference questions.

The central library and information center has dealt with gathering world reference sets and resources since foundation as when the reference unit of the library started to work in 1996, it had 1500 Persian and Latin books kept separately in two halls with 200 meters area. Before transferring the library to its new building in 2012, its stock was 7000 topics. After transferring the library to the new location and aggregating the libraries of the units in the central library, this library’s reference books were increased to 12000 topics. After weeding the old resources, it now (November 2014) has 12104 Persian and Latin books. Two rooms with the area of 740 square meters have been assigned to the reference unit in the new library which Persian and Latin resources are kept separately by two librarians in each of them. 

95-1      95-2    95-3

 

                animated-arrow-image-0147

Course Name Time Location

 

Introducing different kinds of printed reference resources, how to search and recover information

Tuesdays 12 p.m. to 2 p.m.

 

Thursday 10 a.m. to 12 p.m.

 

The Reference unit of the central library

more information...

 

Activities

Some of this unit’s activities have been accounted briefly below:

 

  • Responding to referential, reality-demander, subject and research-based questions
  • Carrying out reference services via telephone, chat and E-mail؛
  • Consulting and helping students in choosing research topic regarding the reference and non-reference resources؛
  • Helping and accompanying clients in subject computer searching؛
  • Teaching the users how to use the reference resources ؛
  • Preparation for holding “Research Method” classes at the reference unit and introducing resources؛
  • Holding individual and group meetings for introducing reference services؛
  • Training librarianship students and apprentices who have reference lessons؛
  • Vast activity in identifying reference resources and suggesting to buy them ؛
  • Preparing educational handbooks and all kinds of guidelines to guide clients in using the resources
  • Introducing major and important resources in the form of article in library’s publications
  • Helping researchers to find “References” to carry out the concerned research
  • Preparing scan and copy of requested resources and sending them
  • Providing consultation services and guiding in preparing resources to found information centers and libraries؛
  • Guiding clients in research method and accomplishing it
  • Weeding old and repetitive resources؛
  • Receiving suggestion of buying new resources required by clients in person or via telephone, chat, Email ؛

 

 

colleagues 

chat1Online Chat Conversation

The Software Guidance of the Chat System for Librarians

Introduction and History of the Chat System

 clock e0 Time of the unit’s service providing 

 

Mahmoud Sedighi

In Charge of the Reference Unit

M.A. in Information and Knowledge Science

Telephone: 38806540

Email:

marjacl@um.ac.ir

 Mahboubeh Farashbashi Astaneh

Senior Expert of the Reference Unit

M.A in Information and Knowledge Science

Telephone: 38806553

Email:

astaneh@um.ac.ir

 

Related topics

 

 

 

 

Some of this unit’s activities have been accounted briefly below:

·         Responding to referential, reality-demander, subject and research-based questions

·         Carrying out reference services via telephone, chat and E-mail

·         Consulting and helping students in choosing research topic regarding the reference and non-reference resources

·         Helping and accompanying clients in subject computer searching

·         Teaching the users how to use the reference resources

·         Preparation for holding “Research Method” classes at the reference unit and introducing resources

·         Holding individual and group meetings for introducing reference services

·         Training librarianship students and apprentices who have reference lessons.

·         Vast activity in identifying reference resources and suggesting to buy them

·         Preparing educational handbooks and all kinds of guidelines to guide clients in using the resources

·         Introducing major and important resources in the form of article in library’s publications

·         Helping researchers to find “References” to carry out the concerned research

·         Preparing scan and copy of requested resources and sending them

·         Providing consultation services and guiding in preparing resources to found information centers and libraries

·         Guiding clients in research method and accomplishing it

·         Weeding old and repetitive resources

Receiving suggestion of buying new resources required by clients in person or via telephone, chat, Email

11.422MBMemory Usage604msRequest 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:2 [ "id" => "4843" "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" => 1745079713 "last" => 1745079713...
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.41KB) (7.65ms)
  • afterInitialise (1.29MB) (60.9ms)
  • afterRoute (1.63MB) (44.25ms)
  • beforeRenderComponent com_content (53.53KB) (2.65ms)
  • Before Access::preloadComponents (all components) (45.61KB) (4.22ms)
  • After Access::preloadComponents (all components) (123.05KB) (799μs)
  • Before Access::preloadPermissions (com_content) (1.85KB) (66μs)
  • After Access::preloadPermissions (com_content) (2.75MB) (11.51ms)
  • Before Access::getAssetRules (id:5893 name:com_content.article.4843) (130.65KB) (320μs)
  • After Access::getAssetRules (id:5893 name:com_content.article.4843) (9.16KB) (414μs)
  • afterRenderComponent com_content (584.34KB) (31.92ms)
  • Before Access::getAssetRules (id:8 name:com_content) (36.74KB) (3.25ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (32μs)
  • afterDispatch (13.09KB) (1.62ms)
  • beforeRenderRawModule mod_menu (منوی اصلی - انگلیسی) (125.34KB) (7.17ms)
  • afterRenderRawModule mod_menu (منوی اصلی - انگلیسی) (1.16MB) (375ms)
  • beforeRenderRawModule mod_custom (لوگو) (1.19KB) (150μs)
  • afterRenderRawModule mod_custom (لوگو) (4.47KB) (907μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (681.52KB) (3.56ms)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (17.98KB) (4.58ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (21μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.48KB) (364μs)
  • beforeRenderRawModule mod_custom (شبکه های اجتماعی) (128B) (62μs)
  • afterRenderRawModule mod_custom (شبکه های اجتماعی) (928B) (155μs)
  • beforeRenderModule mod_custom (شبکه های اجتماعی) (736B) (5μs)
  • afterRenderModule mod_custom (شبکه های اجتماعی) (3.83KB) (83μs)
  • beforeRenderRawModule mod_menu (منوی سمت راست(فارسی)) (1.51KB) (52μs)
  • afterRenderRawModule mod_menu (منوی سمت راست(فارسی)) (283.8KB) (13.76ms)
  • beforeRenderModule mod_menu (منوی سمت راست(فارسی)) (736B) (23μs)
  • afterRenderModule mod_menu (منوی سمت راست(فارسی)) (14.33KB) (106μs)
  • beforeRenderRawModule mod_custom (middle) (2.32KB) (64μs)
  • afterRenderRawModule mod_custom (middle) (976B) (163μs)
  • beforeRenderModule mod_custom (middle) (704B) (5μs)
  • afterRenderModule mod_custom (middle) (3.73KB) (100μs)
  • beforeRenderRawModule mod_custom (آرم کتابخانه مرکزی) (184B) (47μs)
  • afterRenderRawModule mod_custom (آرم کتابخانه مرکزی) (928B) (129μs)
  • beforeRenderModule mod_custom (آرم کتابخانه مرکزی) (736B) (5μs)
  • afterRenderModule mod_custom (آرم کتابخانه مرکزی) (2.95KB) (85μs)
  • beforeRenderModule mod_menu (منوی اصلی - انگلیسی) (1.96KB) (49μs)
  • afterRenderModule mod_menu (منوی اصلی - انگلیسی) (271.32KB) (769μs)
  • beforeRenderModule mod_custom (لوگو) (2.56KB) (68μs)
  • afterRenderModule mod_custom (لوگو) (2.18KB) (57μs)
  • afterRender (883.59KB) (26.27ms)
  • 1 x afterRenderRawModule mod_menu (منوی اصلی - انگلیسی) (1.16MB) (62.02%)
    374.88ms
    1 x afterInitialise (1.29MB) (10.08%)
    60.90ms
    1 x afterRoute (1.63MB) (7.32%)
    44.25ms
    1 x afterRenderComponent com_content (584.34KB) (5.28%)
    31.92ms
    1 x afterRender (883.59KB) (4.35%)
    26.27ms
    1 x afterRenderRawModule mod_menu (منوی سمت راست(فارسی)) (283.8KB) (2.28%)
    13.76ms
    1 x After Access::preloadPermissions (com_content) (2.75MB) (1.91%)
    11.51ms
    1 x afterLoad (455.41KB) (1.27%)
    7.65ms
    1 x beforeRenderRawModule mod_menu (منوی اصلی - انگلیسی) (125.34KB) (1.19%)
    7.17ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (17.98KB) (0.76%)
    4.58ms
    1 x Before Access::preloadComponents (all components) (45.61KB) (0.7%)
    4.22ms
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (681.52KB) (0.59%)
    3.56ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (36.74KB) (0.54%)
    3.25ms
    1 x beforeRenderComponent com_content (53.53KB) (0.44%)
    2.65ms
    1 x afterDispatch (13.09KB) (0.27%)
    1.62ms
    1 x afterRenderRawModule mod_custom (لوگو) (4.47KB) (0.15%)
    907μs
    1 x After Access::preloadComponents (all components) (123.05KB) (0.13%)
    799μs
    1 x afterRenderModule mod_menu (منوی اصلی - انگلیسی) (271.32KB) (0.13%)
    769μs
    1 x After Access::getAssetRules (id:5893 name:com_content.article.4843) (9.16KB) (0.07%)
    414μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.48KB) (0.06%)
    364μs
    1 x Before Access::getAssetRules (id:5893 name:com_content.article.4843) (130.65KB) (0.05%)
    320μs
    1 x afterRenderRawModule mod_custom (middle) (976B) (0.03%)
    163μs
    1 x afterRenderRawModule mod_custom (شبکه های اجتماعی) (928B) (0.03%)
    155μs
    1 x beforeRenderRawModule mod_custom (لوگو) (1.19KB) (0.02%)
    150μs
    1 x afterRenderRawModule mod_custom (آرم کتابخانه مرکزی) (928B) (0.02%)
    129μs
    1 x afterRenderModule mod_menu (منوی سمت راست(فارسی)) (14.33KB) (0.02%)
    106μs
    1 x afterRenderModule mod_custom (middle) (3.73KB) (0.02%)
    100μs
    1 x afterRenderModule mod_custom (آرم کتابخانه مرکزی) (2.95KB) (0.01%)
    85μs
    1 x afterRenderModule mod_custom (شبکه های اجتماعی) (3.83KB) (0.01%)
    83μs
    1 x beforeRenderModule mod_custom (لوگو) (2.56KB) (0.01%)
    68μs
    1 x Before Access::preloadPermissions (com_content) (1.85KB) (0.01%)
    66μs
    1 x beforeRenderRawModule mod_custom (middle) (2.32KB) (0.01%)
    64μs
    1 x beforeRenderRawModule mod_custom (شبکه های اجتماعی) (128B) (0.01%)
    62μs
    1 x afterRenderModule mod_custom (لوگو) (2.18KB) (0.01%)
    57μs
    1 x beforeRenderRawModule mod_menu (منوی سمت راست(فارسی)) (1.51KB) (0.01%)
    52μs
    1 x beforeRenderModule mod_menu (منوی اصلی - انگلیسی) (1.96KB) (0.01%)
    49μs
    1 x beforeRenderRawModule mod_custom (آرم کتابخانه مرکزی) (184B) (0.01%)
    47μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)
    32μs
    1 x beforeRenderModule mod_menu (منوی سمت راست(فارسی)) (736B) (0%)
    23μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    21μs
    1 x beforeRenderModule mod_custom (شبکه های اجتماعی) (736B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (middle) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (آرم کتابخانه مرکزی) (736B) (0%)
    5μs
50 statements were executed, 15 of which were duplicates, 35 unique39.46ms2.83MB
  • SELECT `data` FROM `hcnov_session` WHERE `session_id` = ?674μs17KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `hcnov_session` WHERE `session_id` = :session_id LIMIT 1342μ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.46ms1.66KBParamsCopy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `hcnov_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1218μs16.84KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `hcnov_viewlevels`144μ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` = :guest117μ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`157μs19.82KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `hcnov_languages` WHERE `published` = 1 ORDER BY `ordering` ASC183μ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` = 1144μs16.88KB/libraries/src/Language/LanguageHelper.php:213Copy
  • SELECT * FROM hcnov_rsform_config204μ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`15.99ms1.41MBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM hcnov_extensions WHERE element = "com_multicats"194μ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` = 1182μ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)285μ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.12ms229.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)2.95ms100.51KBParams/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT id,alias FROM hcnov_categories WHERE id = 785162μ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`227μs19.16KBParams/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.09ms18.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`197μs19.16KBParams/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)) 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 AND `a`.`language` IN (:preparedArray7,:preparedArray8) ORDER BY a.ordering ASC301μs20.45KBParams/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`214μs19.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `language`,`id` FROM `hcnov_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0133μs16.13KB/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id163μ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`190μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id107μ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-04-19 16:21:53') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-04-19 16:21:53') AND c2.state = 11.14ms17.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`3.81ms330.67KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • 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` = 1713μs17.1KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id137μ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`154μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id440μ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`655μs21.63KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id81μs16.92KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id266μ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`461μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id70μs16.92KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id314μ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`441μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id102μs16.92KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id324μ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`449μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id78μs16.92KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id271μ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`480μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id116μ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`163μs19.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `hcnov_content` WHERE `id` = :id80μs16.92KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `session_id` FROM `hcnov_session` WHERE `session_id` = ?286μs16.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `hcnov_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.28ms1.66KBParamsCopy