Minutes of the Bermuda Ex-Police Officers Association AGM
held at the Police Recreation Club on 12th April 2012
Our Association held its Annual General Meeting on 12th April 2012 at the Police Recretation Club. CLICK HERE to view the Minutes.
Joomla! Version | 5.2.3 |
PHP Version | 8.2.27 |
Identity | guest |
Response | 200 |
Template | purity_iii |
Database |
|
1 x afterInitialise (7.2MB) (29.11%) | 97.89ms |
1 x afterRenderComponent com_content (3.73MB) (22.26%) | 74.83ms |
1 x afterRender (1.51MB) (11.45%) | 38.49ms |
1 x afterLoad (3.65MB) (10.94%) | 36.77ms |
1 x afterRoute (1.93MB) (10.23%) | 34.38ms |
1 x afterRenderRawModule mod_finder (Smart Search) (478.77KB) (4.63%) | 15.57ms |
1 x beforeRenderModule mod_custom (Spacer) (312.37KB) (2.89%) | 9.71ms |
1 x Before Access::preloadComponents (all components) (483.66KB) (2.26%) | 7.59ms |
1 x beforeRenderComponent com_content (407.04KB) (2.13%) | 7.15ms |
1 x After Access::preloadPermissions (com_content) (926.09KB) (1.65%) | 5.54ms |
1 x afterRenderRawModule mod_custom (Spacer) (99.21KB) (0.67%) | 2.24ms |
1 x After Access::preloadComponents (all components) (120.02KB) (0.47%) | 1.60ms |
1 x afterRenderModule mod_custom (Spacer) (43.19KB) (0.41%) | 1.37ms |
1 x After Access::getAssetRules (id:173 name:com_content.article.119) (25.52KB) (0.19%) | 635μs |
1 x afterDispatch (4.59KB) (0.16%) | 554μs |
1 x afterRenderModule mod_finder (Smart Search) (1.95KB) (0.08%) | 285μs |
1 x Before Access::getAssetRules (id:173 name:com_content.article.119) (34.65KB) (0.05%) | 157μs |
1 x beforeRenderModule mod_finder (Smart Search) (648B) (0.03%) | 116μs |
1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%) | 37μs |
1 x beforeRenderModule mod_custom (Spacer) (704B) (0.01%) | 19μs |
1 x beforeRenderModule mod_finder (Smart Search) (720B) (0.01%) | 17μs |
SELECT @@SESSION.sql_mode;
136μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `dztir_session`
WHERE `session_id` = ?
208μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `dztir_session`
WHERE `session_id` = :session_id LIMIT 1
175μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `dztir_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
362μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `dztir_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
383μs1.61KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `dztir_viewlevels`
139μs624B/libraries/src/Access/Access.php:955CopySELECT `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` = :guest
222μs1.31KBParams/libraries/src/Access/Access.php:868CopySELECT `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`
1.13ms3.96KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `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`
963μs52.67KBParams/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 `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`.`published` = 1 AND `s`.`id` = :id
ORDER BY `c`.`lft`
472μs3.86KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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` = 1
493μs864B/administrator/components/com_templates/src/Model/StyleModel.php:775CopySELECT *
FROM `dztir_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
282μs1.59KB/libraries/src/Language/LanguageHelper.php:177CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `dztir_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)
932μs7.44KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `dztir_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
2.24ms137.48KBParams/libraries/src/Access/Access.php:301CopySHOW FULL COLUMNS FROM `dztir_content`
637μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopyUPDATE `dztir_content`
SET `hits` = (`hits` + 1)
WHERE `id` = '119'
347μs48B/libraries/src/Table/Table.php:1348CopySELECT `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 `dztir_content` AS `a`
INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) 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 (:preparedArray1,:preparedArray2)
624μs7.38KBParams/components/com_content/src/Model/ArticleModel.php:215CopySELECT `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`
434μs3.89KBParams/libraries/src/Categories/Categories.php:375CopySELECT `m`.`tag_id`,`t`.*
FROM `dztir_contentitem_tag_map` AS `m`
INNER JOIN `dztir_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)
358μs3.95KBParams/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 `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`
572μs3.89KBParams/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 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
LEFT JOIN `dztir_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)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) 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 ASC
1.04ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug`
FROM `dztir_content` AS `a`
LEFT JOIN `dztir_categories` AS `cc` ON `cc`.`id` = `a`.`catid`
WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2)
ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC
4.07ms41.69KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188CopySELECT `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`
409μs3.89KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
1.4ms146.66KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `name`,`element`
FROM `dztir_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
591μs704B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135CopySELECT f.data, f.params
FROM `dztir_finder_filters` AS f
WHERE f.filter_id = 1
214μs592B/administrator/components/com_finder/src/Indexer/Query.php:514CopySELECT 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)
805μs1.13KB/administrator/components/com_finder/src/Indexer/Query.php:566CopySELECT `title`
FROM `dztir_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)
196μs648B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325CopySELECT * FROM dztir_igallery ORDER BY parent, ordering
528μs19.58KB/administrator/components/com_igallery/src/Helper/StaticHelper.php:18CopySELECT *
FROM `dztir_schemaorg`
WHERE `itemId` = :itemId AND `context` = :context
207μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403CopySELECT `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 `dztir_content` AS `a`
INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) 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 (:preparedArray1,:preparedArray2)
574μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215CopySELECT `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 `dztir_content` AS `a`
INNER JOIN `dztir_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `dztir_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `dztir_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `dztir_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `dztir_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) 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 (:preparedArray1,:preparedArray2)
464μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215CopySELECT 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` = 1
339μs3.87KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465CopySELECT `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`
682μs3.89KBParams/libraries/src/Categories/Categories.php:375CopySELECT `session_id`
FROM `dztir_session`
WHERE `session_id` = ?
174μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `dztir_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
453μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy