در این قمست اطلاعات با ساختار زیر ارائه می‌شود
اهمیت گردآوری اطلاعات درست
انواع اطلاعاتی که گردآوری می‌شود
روش‌های مختلف گردآوری اطلاعات
نکاتی که در گردآوری انواع محختلف اطلاعات باید مد نظر باشد.
|
|
 |
در این قمست اطلاعات با ساختار زیر ارائه می‌شود
اهمیت گردآوری اطلاعات درست
انواع اطلاعاتی که گردآوری می‌شود
روش‌های مختلف گردآوری اطلاعات
نکاتی که در گردآوری انواع محختلف اطلاعات باید مد نظر باشد.
| Joomla! Version | 4.4.2 |
| PHP Version | 8.2.13 |
| Identity | guest |
| Response | 200 |
| Template | fumlibrary |
| Database |
|
| 1 x afterInitialise (1.29MB) (24.78%) | 60.90ms |
| 1 x afterRoute (1.43MB) (16.77%) | 41.22ms |
| 1 x afterRenderRawModule mod_menu (منوی سمت راست(فارسی)) (392.14KB) (13.04%) | 32.04ms |
| 1 x afterRenderComponent com_content (233.94KB) (9.86%) | 24.24ms |
| 1 x afterRenderRawModule mod_articles_category (گام‌های فرایند پژوهش) (105.04KB) (7.25%) | 17.83ms |
| 1 x After Access::preloadPermissions (com_content) (2.77MB) (4.75%) | 11.67ms |
| 1 x afterRender (80KB) (4.59%) | 11.27ms |
| 1 x beforeRenderRawModule mod_articles_category (گام‌های فرایند پژوهش) (331.18KB) (4.42%) | 10.87ms |
| 1 x afterRenderRawModule mod_menu (منوی بالا(فارسی)) (100.5KB) (2.98%) | 7.34ms |
| 1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (744.1KB) (2.58%) | 6.35ms |
| 1 x Before Access::getAssetRules (id:8 name:com_content) (23.46KB) (1.41%) | 3.45ms |
| 1 x afterLoad (455.48KB) (1.14%) | 2.80ms |
| 1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (7.77KB) (0.88%) | 2.16ms |
| 1 x afterDispatch (13.1KB) (0.82%) | 2.02ms |
| 1 x Before Access::preloadComponents (all components) (40.2KB) (0.78%) | 1.92ms |
| 1 x beforeRenderComponent com_content (47.13KB) (0.76%) | 1.87ms |
| 1 x afterRenderRawModule mod_custom (لوگو) (4.2KB) (0.66%) | 1.63ms |
| 1 x After Access::preloadComponents (all components) (123.05KB) (0.29%) | 719μs |
| 1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.37KB) (0.24%) | 598μs |
| 1 x afterRenderModule mod_articles_category (گام‌های فرایند پژوهش) (5.84KB) (0.21%) | 507μs |
| 1 x Before Access::getAssetRules (id:10076 name:com_content.article.12678) (130.65KB) (0.15%) | 365μs |
| 1 x afterRenderRawModule mod_custom (middle) (976B) (0.11%) | 273μs |
| 1 x afterRenderRawModule mod_custom (شبکه های اجتماعی) (928B) (0.11%) | 271μs |
| 1 x afterRenderRawModule mod_custom (آرم کتابخانه مرکزی) (928B) (0.1%) | 252μs |
| 1 x afterRenderModule mod_menu (منوی سمت راست(فارسی)) (15.58KB) (0.08%) | 203μs |
| 1 x beforeRenderModule mod_articles_category (گام‌های فرایند پژوهش) (7.42KB) (0.07%) | 161μs |
| 1 x After Access::getAssetRules (id:10076 name:com_content.article.12678) (9.16KB) (0.06%) | 158μs |
| 1 x afterRenderModule mod_custom (middle) (2.48KB) (0.06%) | 157μs |
| 1 x beforeRenderRawModule mod_menu (منوی بالا(فارسی)) (4.9KB) (0.06%) | 153μs |
| 1 x afterRenderModule mod_custom (شبکه های اجتماعی) (3.83KB) (0.06%) | 150μs |
| 1 x afterRenderModule mod_custom (آرم کتابخانه مرکزی) (2.95KB) (0.06%) | 150μs |
| 1 x beforeRenderRawModule mod_custom (middle) (2.16KB) (0.05%) | 128μs |
| 1 x beforeRenderModule mod_custom (لوگو) (1.73KB) (0.04%) | 106μs |
| 1 x beforeRenderRawModule mod_custom (آرم کتابخانه مرکزی) (136B) (0.04%) | 98μs |
| 1 x beforeRenderRawModule mod_custom (شبکه های اجتماعی) (8.38KB) (0.04%) | 97μs |
| 1 x beforeRenderModule mod_menu (منوی بالا(فارسی)) (1.41KB) (0.04%) | 97μs |
| 1 x beforeRenderRawModule mod_menu (منوی سمت راست(فارسی)) (1.51KB) (0.04%) | 91μs |
| 1 x beforeRenderRawModule mod_custom (لوگو) (1.14KB) (0.04%) | 90μs |
| 1 x afterRenderModule mod_menu (منوی بالا(فارسی)) (2.71KB) (0.03%) | 72μs |
| 1 x afterRenderModule mod_custom (لوگو) (2.18KB) (0.03%) | 70μs |
| 1 x Before Access::preloadPermissions (com_content) (1.85KB) (0.02%) | 52μs |
| 1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%) | 36μs |
| 1 x beforeRenderModule mod_menu (منوی سمت راست(فارسی)) (736B) (0.01%) | 21μs |
| 1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0.01%) | 17μs |
| 1 x beforeRenderModule mod_custom (middle) (704B) (0%) | 11μs |
| 1 x beforeRenderModule mod_custom (آرم کتابخانه مرکزی) (736B) (0%) | 10μs |
| 1 x beforeRenderModule mod_custom (شبکه های اجتماعی) (736B) (0%) | 9μs |
SELECT `data`
FROM `hcnov_session`
WHERE `session_id` = ?2ms17KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `hcnov_session`
WHERE `session_id` = :session_id LIMIT 1551μs16.98KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `hcnov_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)1.32ms1.66KBParamsCopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `hcnov_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1217μs16.84KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `hcnov_viewlevels`170μs16.44KB/libraries/src/Access/Access.php:955CopySELECT `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` = :guest162μs17.03KBParams/libraries/src/Access/Access.php:868CopySELECT `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`200μs19.82KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT *
FROM `hcnov_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC184μs16.42KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `hcnov_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1143μs16.88KB/libraries/src/Language/LanguageHelper.php:213CopySELECT *
FROM hcnov_rsform_config181μs16.48KB/administrator/components/com_rsform/helpers/config.php:52CopySELECT `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`13.51ms1.47MBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `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 (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`3.87ms18.94KBParams/libraries/src/Categories/Categories.php:375CopySELECT `id`
FROM `hcnov_content`
WHERE `alias` = :alias1.99ms16.92KBParams/components/com_content/src/Service/Router.php:264CopySELECT *
FROM hcnov_extensions
WHERE element = "com_multicats"179μs16.63KB/administrator/components/com_multicats/helpers/multicats.php:759CopySELECT `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` = 1236μs16.19KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT `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)265μs26.7KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `hcnov_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.13ms230.44KBParams/libraries/src/Access/Access.php:301CopySELECT `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)1.51ms20.51KBParams/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticleModel.php:215CopySELECT id,alias FROM hcnov_categories WHERE id = 850389μs16.06KB/components/com_multicats/helpers/content.php:105CopySELECT `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`365μs19.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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)881μs18.27KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT `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`209μs19.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 AND `a`.`language` IN (:preparedArray8,:preparedArray9)
ORDER BY a.ordering ASC7.82ms20.56KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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`209μs19.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `language`,`id`
FROM `hcnov_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0155μs16.13KB/libraries/src/Language/Multilanguage.php:123CopySELECT `alias`
FROM `hcnov_content`
WHERE `id` = :id531μs16.92KBParams/components/com_content/src/Service/Router.php:168CopySELECT `alias`
FROM `hcnov_content`
WHERE `id` = :id212μs16.92KBParams/components/com_content/src/Service/Router.php:168CopySELECT `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-06-07 22:17:50') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-06-07 22:17:50') AND c2.state = 11.54ms17.85KBParams/libraries/src/Language/Associations.php:145CopySELECT `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.39ms330.67KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `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 ASC9.34ms117.61KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT c.id
FROM hcnov_categories AS c
WHERE c.id = 850 AND c.access IN (1,5)161μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752CopySELECT c.id
FROM hcnov_categories AS c
WHERE c.id = 850 AND c.access IN (1,5)121μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752CopySELECT c.id
FROM hcnov_categories AS c
WHERE c.id = 850 AND c.access IN (1,5)112μs18.54KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752CopySELECT c.id
FROM hcnov_categories AS c
WHERE c.id = 850 AND c.access IN (1,5)112μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752CopySELECT c.id
FROM hcnov_categories AS c
WHERE c.id = 850 AND c.access IN (1,5)108μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752CopySELECT c.id
FROM hcnov_categories AS c
WHERE c.id = 850 AND c.access IN (1,5)104μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752CopySELECT c.id
FROM hcnov_categories AS c
WHERE c.id = 850 AND c.access IN (1,5)119μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752CopySELECT c.id
FROM hcnov_categories AS c
WHERE c.id = 850 AND c.access IN (1,5)103μs16.04KB/administrator/components/com_multicats/copy/code/com_content/src/Model/ArticlesModel.php:752CopySELECT `alias`
FROM `hcnov_content`
WHERE `id` = :id165μs16.92KBParams/components/com_content/src/Service/Router.php:168CopySELECT `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`178μs19.13KBParams/libraries/src/Categories/Categories.php:375CopySELECT `alias`
FROM `hcnov_content`
WHERE `id` = :id235μs16.92KBParams/components/com_content/src/Service/Router.php:168CopySELECT 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` = 1193μs17.1KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `hcnov_session`
WHERE `session_id` = ?560μs16.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `hcnov_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?1.37ms1.66KBParamsCopy