Home

J! Info Request Session Profile Queries35

20.526MB261ms

Joomla! Version	5.2.6
PHP Version	8.2.28
Identity	guest
Response	200
Template	purity_iii
Database	Server mysql Version 10.6.21-MariaDB-log Collation latin1_swedish_ci Conn Collation utf8mb4_general_ci

$_GET: array:1 [ "Itemid" => "101" ]
$_POST: []
$_SESSION: array:1 [ "joomla" => "***redacted***" ]
$_COOKIE: []
$_SERVER: array:58 [ "CONTEXT_DOCUMENT_ROOT" => "/home/bermyxpo/public_html" "CONTEXT_PREFIX" => "" "DOC...

session: array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745976981 "last" => 1745976981...
registry: array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user: array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...

afterLoad (3.65MB) (34.01ms)
afterInitialise (7.21MB) (74.48ms)
afterRoute (1.65MB) (19.44ms)
beforeRenderComponent com_users (391.01KB) (4.85ms)
afterRenderComponent com_users (2.94MB) (37.94ms)
afterDispatch (4.95KB) (432μs)
beforeRenderModule mod_articles_latest (From the Editor) (733.86KB) (10.1ms)
afterRenderRawModule mod_articles_latest (From the Editor) (438.36KB) (8.1ms)
beforeRenderModule mod_articles_latest (From the Editor) (720B) (12μs)
afterRenderModule mod_articles_latest (From the Editor) (112.88KB) (991μs)
beforeRenderModule mod_custom (Spacer) (472B) (94μs)
afterRenderRawModule mod_custom (Spacer) (8.84KB) (709μs)
beforeRenderModule mod_custom (Spacer) (704B) (8μs)
afterRenderModule mod_custom (Spacer) (1.78KB) (155μs)
beforeRenderModule mod_igallery (Rogue's Gallery) (576B) (25μs)
beforeRenderComponent com_igallery (130.19KB) (1.69ms)
afterRenderComponent com_igallery (1.07MB) (23.55ms)
afterRenderRawModule mod_igallery (Rogue's Gallery) (35.15KB) (25μs)
beforeRenderModule mod_igallery (Rogue's Gallery) (720B) (5μs)
afterRenderModule mod_igallery (Rogue's Gallery) (1.67KB) (219μs)
beforeRenderModule mod_articles_category (Latest Articles) (18.77KB) (52μs)
afterRenderRawModule mod_articles_category (Latest Articles) (270.27KB) (8.05ms)
beforeRenderModule mod_articles_category (Latest Articles) (720B) (11μs)
afterRenderModule mod_articles_category (Latest Articles) (1.8KB) (226μs)
beforeRenderModule mod_articles_category (Press Releases) (160B) (49μs)
afterRenderRawModule mod_articles_category (Press Releases) (40.71KB) (3.75ms)
beforeRenderModule mod_articles_category (Press Releases) (720B) (13μs)
afterRenderModule mod_articles_category (Press Releases) (2.05KB) (227μs)
beforeRenderModule mod_articles_latest (Interesting Articles) (3.08KB) (50μs)
afterRenderRawModule mod_articles_latest (Interesting Articles) (35KB) (4.06ms)
beforeRenderModule mod_articles_latest (Interesting Articles) (720B) (10μs)
afterRenderModule mod_articles_latest (Interesting Articles) (2.06KB) (194μs)
beforeRenderModule mod_finder (Smart Search) (104B) (87μs)
afterRenderRawModule mod_finder (Smart Search) (603.73KB) (12.03ms)
beforeRenderModule mod_finder (Smart Search) (720B) (11μs)
afterRenderModule mod_finder (Smart Search) (1.95KB) (216μs)
afterRender (847.58KB) (14.53ms)

1 x afterInitialise (7.21MB) (28.5%)	74.48ms
1 x afterRenderComponent com_users (2.94MB) (14.52%)	37.94ms
1 x afterLoad (3.65MB) (13.02%)	34.01ms
1 x afterRenderComponent com_igallery (1.07MB) (9.01%)	23.55ms
1 x afterRoute (1.65MB) (7.44%)	19.44ms
1 x afterRender (847.58KB) (5.56%)	14.53ms
1 x afterRenderRawModule mod_finder (Smart Search) (603.73KB) (4.6%)	12.03ms
1 x beforeRenderModule mod_articles_latest (From the Editor) (733.86KB) (3.86%)	10.10ms
1 x afterRenderRawModule mod_articles_latest (From the Editor) (438.36KB) (3.1%)	8.10ms
1 x afterRenderRawModule mod_articles_category (Latest Articles) (270.27KB) (3.08%)	8.05ms
1 x beforeRenderComponent com_users (391.01KB) (1.86%)	4.85ms
1 x afterRenderRawModule mod_articles_latest (Interesting Articles) (35KB) (1.55%)	4.06ms
1 x afterRenderRawModule mod_articles_category (Press Releases) (40.71KB) (1.44%)	3.75ms
1 x beforeRenderComponent com_igallery (130.19KB) (0.65%)	1.69ms
1 x afterRenderModule mod_articles_latest (From the Editor) (112.88KB) (0.38%)	991μs
1 x afterRenderRawModule mod_custom (Spacer) (8.84KB) (0.27%)	709μs
1 x afterDispatch (4.95KB) (0.17%)	432μs
1 x afterRenderModule mod_articles_category (Press Releases) (2.05KB) (0.09%)	227μs
1 x afterRenderModule mod_articles_category (Latest Articles) (1.8KB) (0.09%)	226μs
1 x afterRenderModule mod_igallery (Rogue's Gallery) (1.67KB) (0.08%)	219μs
1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.08%)	216μs
1 x afterRenderModule mod_articles_latest (Interesting Articles) (2.06KB) (0.07%)	194μs
1 x afterRenderModule mod_custom (Spacer) (1.78KB) (0.06%)	155μs
1 x beforeRenderModule mod_custom (Spacer) (472B) (0.04%)	94μs
1 x beforeRenderModule mod_finder (Smart Search) (104B) (0.03%)	87μs
1 x beforeRenderModule mod_articles_category (Latest Articles) (18.77KB) (0.02%)	52μs
1 x beforeRenderModule mod_articles_latest (Interesting Articles) (3.08KB) (0.02%)	50μs
1 x beforeRenderModule mod_articles_category (Press Releases) (160B) (0.02%)	49μs
1 x afterRenderRawModule mod_igallery (Rogue's Gallery) (35.15KB) (0.01%)	25μs
1 x beforeRenderModule mod_igallery (Rogue's Gallery) (576B) (0.01%)	25μs
1 x beforeRenderModule mod_articles_category (Press Releases) (720B) (0%)	13μs
1 x beforeRenderModule mod_articles_latest (From the Editor) (720B) (0%)	12μs
1 x beforeRenderModule mod_articles_category (Latest Articles) (720B) (0%)	11μs
1 x beforeRenderModule mod_finder (Smart Search) (720B) (0%)	11μs
1 x beforeRenderModule mod_articles_latest (Interesting Articles) (720B) (0%)	10μs
1 x beforeRenderModule mod_custom (Spacer) (704B) (0%)	8μs
1 x beforeRenderModule mod_igallery (Rogue's Gallery) (720B) (0%)	5μs

35 statements were executed18.22ms440.53KB

SELECT @@SESSION.sql_mode;84μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
SELECT `data` FROM `dztir_session` WHERE `session_id` = ?137μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
SELECT `session_id` FROM `dztir_session` WHERE `session_id` = :session_id LIMIT 185μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
INSERT INTO `dztir_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)257μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `dztir_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1316μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
SELECT `id`,`rules` FROM `dztir_viewlevels`93μs624B/libraries/src/Access/Access.php:955Copy
SELECT `b`.`id` FROM `dztir_usergroups` AS `a` LEFT JOIN `dztir_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest140μs1.31KBParams/libraries/src/Access/Access.php:868Copy
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `dztir_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`769μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `dztir_menu` AS `m` LEFT JOIN `dztir_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`613μs52.67KBParams/libraries/src/Menu/SiteMenu.php:166Copy
SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `dztir_template_styles` AS `s` LEFT JOIN `dztir_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` = 1291μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
SELECT * FROM `dztir_languages` WHERE `published` = 1 ORDER BY `ordering` ASC152μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
SELECT * FROM dztir_wf_profiles WHERE published = 1 ORDER BY ordering ASC173μs1.63KB/components/com_jce/editor/libraries/classes/application.php:284Copy
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 dztir_fields AS a LEFT JOIN `dztir_languages` AS l ON l.lang_code = a.language LEFT JOIN dztir_users AS uc ON uc.id=a.checked_out LEFT JOIN dztir_viewlevels AS ag ON ag.id = a.access LEFT JOIN dztir_users AS ua ON ua.id = a.created_user_id LEFT JOIN dztir_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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 ASC713μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `dztir_modules` AS `m` LEFT JOIN `dztir_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `dztir_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)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`985μs162.78KBParams/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`,`fp`.`ordering`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `dztir_content` AS `a` LEFT JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `dztir_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`featured` = 1 AND (`fp`.`featured_up` IS NULL OR `fp`.`featured_up` <= :featuredUp) AND (`fp`.`featured_down` IS NULL OR `fp`.`featured_down` >= :featuredDown) AND `a`.`catid` IN (:preparedArray3) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.publish_up DESC LIMIT 5698μs6.37KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
SELECT c.*,u.name AS displayname, u.username FROM dztir_igallery AS c LEFT JOIN `dztir_users` AS u ON c.user = u.id WHERE c.id = 15 AND c.published = 1 AND c.moderate = 1 AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2025-04-30 01:36:21' OR c.publish_up IS NULL) AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2025-04-30 01:36:21' OR c.publish_down IS NULL)321μs3.16KB/components/com_igallery/src/Model/CategoryModel.php:94Copy
SELECT * FROM dztir_igallery_profiles WHERE published = 1 AND id = 3704μs31.06KB/components/com_igallery/src/Model/CategoryModel.php:119Copy
SELECT * FROM dztir_igallery ORDER BY parent, ordering424μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18Copy
SELECT id FROM dztir_igallery_img as i WHERE i.gallery_id IN(1,24,16,17,18,23,14,20,26,27,28,29,12,13,11,10,7,9,6,2,3,4,5,19,21,22,25,15) AND i.published = 1 AND i.moderate = 1 AND i.access IN (1)1.27ms16.51KB/components/com_igallery/src/Model/CategoryModel.php:970Copy
SELECT COUNT(*) FROM dztir_igallery_img AS i INNER JOIN `dztir_igallery` AS c ON c.id = i.gallery_id INNER JOIN `dztir_igallery_profiles` AS p ON p.id = c.profile LEFT JOIN `dztir_users` AS u ON i.user = u.id WHERE i.id IN(140,227,877) AND i.gallery_id IN(1,24,16,17,18,23,14,20,26,27,28,29,12,13,11,10,7,9,6,2,3,4,5,19,21,22,25,15) AND i.published = 1 AND i.moderate = 1 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-30 01:36:21' OR i.publish_up IS NULL) AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-30 01:36:21' OR i.publish_down IS NULL) AND i.access IN (1)537μs536B/libraries/src/MVC/Model/BaseDatabaseModel.php:197Copy
SELECT i.*,c.name, c.folder,p.thumb_pagination_amount, p.thumb_pagination, p.image_ordering,u.name AS displayname, u.username FROM dztir_igallery_img AS i INNER JOIN `dztir_igallery` AS c ON c.id = i.gallery_id INNER JOIN `dztir_igallery_profiles` AS p ON p.id = c.profile LEFT JOIN `dztir_users` AS u ON i.user = u.id WHERE i.id IN(140,227,877) AND i.gallery_id IN(1,24,16,17,18,23,14,20,26,27,28,29,12,13,11,10,7,9,6,2,3,4,5,19,21,22,25,15) AND i.published = 1 AND i.moderate = 1 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-30 01:36:21' OR i.publish_up IS NULL) AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-30 01:36:21' OR i.publish_down IS NULL) AND i.access IN (1) ORDER BY RAND() LIMIT 31.1ms4.91KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
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`,`fp`.`ordering`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `dztir_content` AS `a` LEFT JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `dztir_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray3) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.created DESC LIMIT 51.65ms38.42KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
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 `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`344μs3.89KBParams/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`,`fp`.`ordering`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `dztir_content` AS `a` LEFT JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `dztir_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray3) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.created DESC LIMIT 5793μs38.42KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
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 `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`465μs3.89KBParams/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`,`fp`.`ordering`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `dztir_content` AS `a` LEFT JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `dztir_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `dztir_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1) AND `c`.`access` IN (:preparedArray2) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray3) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.created DESC LIMIT 11.66ms22.36KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
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 `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`450μs3.89KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT `name`,`element` FROM `dztir_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1523μs704B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
SELECT f.data, f.params FROM `dztir_finder_filters` AS f WHERE f.filter_id = 1128μs592B/administrator/components/com_finder/src/Indexer/Query.php:514Copy
SELECT t1.id, t1.title, t2.title AS branch FROM `dztir_finder_taxonomy` AS t1 LEFT JOIN `dztir_finder_taxonomy` AS t2 ON t2.lft < t1.lft AND t1.rgt < t2.rgt AND t2.level = 1 WHERE t1.state = 1 AND t1.access IN (1) AND t1.id IN (4,39,57,58,59,60,74,41,46,66,67,71,43,47,49,50,51,52,61,62,63,64,65,68,72,69,70,73,75) AND t2.state = 1 AND t2.access IN (1)860μs1.13KB/administrator/components/com_finder/src/Indexer/Query.php:566Copy
SELECT `title` FROM `dztir_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)194μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
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 `dztir_scheduler_tasks` AS `a` WHERE `a`.`state` = 1298μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
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 `dztir_categories` AS `s` INNER JOIN `dztir_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`538μs6.39KBParams/libraries/src/Categories/Categories.php:375Copy
SELECT `session_id` FROM `dztir_session` WHERE `session_id` = ?156μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
UPDATE `dztir_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?305μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy

Home

Rogue's Gallery

Latest Articles

Press Releases

Interesting Articles