­
Chris Appleby Ministries

Chris Appleby Ministries

 

Search

Introduction

Joomla! Is a content management system (CMS). That is, it allows a user to add content to a website without having to know a lot about what runs behind the website. While a knowledge of the html language may help with formatting in some cases, this is not essential.

Administrator access (the backend) is gained by going to www.mywebsite/administrator. Users must have manager level or higher to access the backend. This level is set by a 'Superuser' through the user menu.

Major Structural Elements

The main elements of the Joomla! structure are:

The latter 4 are also known as extensions.

Along with these elements are connected elements:

  • Categories - used for cataloguing and sorting  - e.g.  Articles of a given category can be displayed on a page via the menu element.
  • Plug-ins
  • Media - video, audio
  • Images - jpg, png, gif, etc. these are normally stored in a folder images/stories but other folders may be used.

top

Articles 

Articles are usd to display information. Articles can be linked to the Joomla menu system, or you can create hyper-links to other articles, within the article content itself.

To start a new article simply click the menu Content  Articles  Add New Article. You can also use choose Manage Articles from which you can edit existing articles or create a new one. 

To edit an existing article, enter a word from the article heading in the search box and click on the magnifying glass. Select New to begin a new article

You will be presented with a content editor,which will allow you to edit using a WYSIWYG editor or a code view editor.

An article must have a title. It should also have a category (set in the right hand panel of the Content tab).

For an article to appear on the website it must be set to Published in the right hand panel of the content tab.

The Publishing tab allows articles to be published and unpublished on particular dates. It also allows an author's name to be added. This defaults to the person who creates the article but may be changed by the entry of an alias.

Articles and menus can be set to be accessible to public, guest, registered, special or super users. In most cases this will be guest.

It is possible to set up a particular category of user in order to allow only them to access particular articles or menus.

The Options tab allows various options to be shown or hidden: e.g. the create, or modify date, author, category, etc.  The defaults for these  options are set under the options menu within the articles menu (the gear icon opens this menu).  

These options are also set in the Menu options and can override the article options on occasions.

Articles can be set to Featured in which case they will appear on the Featured menu - generally the Home menu.

Once an article is saved and set to Published it is ready to appear on the website. If it is Featured it will appear on the Featured page ( normally the home page). Otherwise it will appear where a menu is set to display it.

 

Menus

A number of menus can be created. These will appear in Modules at a place on the Template set in the Module parameters.

Generally the Main Menu will appear at the top of the page.

Menus may appear on all or a selection of pages, set in the Modules parameters or under the Menu Assignment  tab of the particular menu.
Menus can be a variety of types. Most of these will be Article menus. Article menus can be single articles, category lists or blogs, featured articles, lists of categories, etc.

Some components have their own menu type.

Parameters to be set are:

  • The menu to which this menu belongs
  • The parent menu item for this menu
  • The ordering of this menu within its parent menu (available once the menu is saved)
  • Who will have access to this menu.
  • Which modules the menu is to be assigned to.
  • The options tab set options similar to this in the content/articles setup.

There are various other option tabs, most of which can be ignored.

top

Modules

Modules are provided to allow content to be displayed. A number of modules are created as part of the standard setup.

Modules may be associated with a particular component.

The module's position on the website is set by selecting menus under the Menu Assignment tab (all, all except, those selected) and by selecting the Template position required.

A custom module allows you enter content into a single module without have to first create an article. e.g. To put an address and contact box at the bottom of the home page use a custom module positioned at the bottom element of the Template.

top

Components

Components are the software elements that do the work to create website presentations.  E.g. com_content is the component that controls the presentation of content.

Many of these are standard but others can be downloaded from the web.

If you need some particular facility do a web search for it. Most Joomla! components are free though some will need to be paid for.
e.g. Content (com_content), Banners (com_banners), Contacts (com_contact), News Feeds (com_newsfeeds) and Web Links (com_weblinks)

Often a component comes with an associated plugin (see below) which must also be installed.

To install a component or plugin download it. Generally it will come in a zip file which can then be uploaded using the install item in the Extensions/manage menu tab. In some cases you will need to unpack a compressed file first.

top

Templates

Templates determine the look and feel of the website. They set positions for content, fonts, colours, indenting, heading levels, etc.
Depending on the Template some parameters may be adjustable from the Template component. e.g. colour,  menu positions, menu animation, display of sub-menus, logo selection, image or text, which menus this template applies to.

These settings can be changed by adjusting the css and php files of the template if you're confident in operating on these types of files.
Joomla comes with a few standard templates but others can be downloaded from the web (some free, others paid).

Note: the favicon, the tiny icon that appears in the website tab is supplied by the template. To use your own you need to create your own favicon and transfer it to the template folder via FTP. This is probably the task for your website manager/designer assuming you have one (it is recommended you have someone who is competent with FTP, css and php who is available to help you maintain and modify the website, keep components updated, etc.).

Module positions are set by the Template but these can be changed in the template settings - Extensions/Templates tab. Standard positions for RSJuno are shown here.

top

Categories

Joomla! comes with one category - uncategorised. The user needs to create others prior to creating articles.

Articles can be created in a hierarchical structure, with sub-categories, to a number of levels.

These categories are used by, for example, the article category menu to select which articles will be displayed.

top

Plug-ins

Joomla! comes with a variety of plugins connected with standard components. Many of these can be ignored, but others will included elements that need to be adjusted.

Where the component has been paid for it may have a serial number that needs to be entered in the plugin or in the component itself.

top

User Names and Passwords

User names are unique as are the associated email addresses.

Joomla! includes the facility for using Two Factor Authentication using Google Authenticator. This provides a 6 digit code on your mobile that must be entered along with your name and password in order to log in.

This ensures that only you can get in to the backend of the website. This is set in the user name parameters.

It is important to realise that efforts are constantly being made to break into your website, from countries all over the globe. On one website my firewall log shows around 20 attempts to break in over a 2 hour period.

Avoid obvious user names like admin, user, manager. The initial setup will create a user "admin". Change this to something you can remember or create a new super user log in as that user then delete the admin user.

Ensure that passwords are not guessable. Attempts to break in regularly try such password as qwerty, asdfgh, 123456, qwe123, qazwsx. Hard as it is to believe some people do use these sorts of passwords. Don't be one of them!

A super user can add users and designate them to one of the available user levels.

 

More information can be found at  https://docs.joomla.org/Portal:Beginners.

Getting Started

To start creating or editing your website go to http://www.yourwebsite.org.au/administrator

You will be presented with a Logon page requiring your USERNAME, PASSWORD and, if you've set it up, your Google Authenticator 6 digit code.

Click on Log In and it will take you to the website's Control Panel. After a minute or so any new extension updates should appear at the top of the screen. Clicking on this notification takes you to the update page (also accessible via the Extensions/Manage menu tab) where you can update your extensions. In some cases this will required downloading an updated package from the provider's site which is normally indicated under the URL heading.

If the user menu is installed you can also log in to the Front End. This allows basic editing of articles without going to the administrator site.

top

Contact Details

Phone: 0422187127
 
­
Settings9.282MBMemory Usage622msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.3
PHP Version8.1.31
Identityguest
Response200
Templatersjuno
Database
Server
mysql
Version
8.0.28-0ubuntu0.20.04.3
Collation
utf8_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" "CONTENT_LEN...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1758234153 "last" => 1758234153...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
com_rsfirewall
array:1 [ "geoip" => array:1 [ "216.73.216.36" => "US" ] ]
tpl_rsjuno
array:1 [ "queue" => array:6 [ "components/com_content.css" => true "modules/mod_custom.cs...
  • afterLoad (93.31KB) (615μs)
  • afterInitialise (1.51MB) (86.48ms)
  • afterRoute (2.13MB) (78.01ms)
  • beforeRenderComponent com_content (177.28KB) (10.68ms)
  • Before Access::preloadComponents (all components) (51.37KB) (7.08ms)
  • After Access::preloadComponents (all components) (142.98KB) (2.4ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (14μs)
  • After Access::preloadPermissions (com_content) (153.71KB) (6.99ms)
  • Before Access::getAssetRules (id:133 name:com_content.article.551) (18.8KB) (21μs)
  • After Access::getAssetRules (id:133 name:com_content.article.551) (72.75KB) (1.06ms)
  • afterRenderComponent com_content (799.04KB) (243ms)
  • afterDispatch (98.14KB) (995μs)
  • beforeRenderRawModule mod_custom (footer) (512.99KB) (38.72ms)
  • afterRenderRawModule mod_custom (footer) (5.52KB) (2.74ms)
  • beforeRenderModule mod_custom (footer) (704B) (6μs)
  • afterRenderModule mod_custom (footer) (2.07KB) (839μs)
  • beforeRenderRawModule mod_banners (Dreamhost Banner) (5.06KB) (967μs)
  • afterRenderRawModule mod_banners (Dreamhost Banner) (109.8KB) (28.38ms)
  • beforeRenderModule mod_banners (Dreamhost Banner) (704B) (7μs)
  • afterRenderModule mod_banners (Dreamhost Banner) (4.13KB) (280μs)
  • beforeRenderRawModule mod_custom (Contact Details) (3.12KB) (1.39ms)
  • afterRenderRawModule mod_custom (Contact Details) (39.96KB) (5.73ms)
  • beforeRenderModule mod_custom (Contact Details) (720B) (6μs)
  • afterRenderModule mod_custom (Contact Details) (2.88KB) (68μs)
  • beforeRenderRawModule mod_addtoany (AddToAny Buttons) (22.04KB) (333μs)
  • afterRenderRawModule mod_addtoany (AddToAny Buttons) (4.85KB) (954μs)
  • beforeRenderModule mod_addtoany (AddToAny Buttons) (720B) (5μs)
  • afterRenderModule mod_addtoany (AddToAny Buttons) (2.75KB) (59μs)
  • beforeRenderRawModule mod_menu (Main Menu) (24.54KB) (715μs)
  • afterRenderRawModule mod_menu (Main Menu) (1.71MB) (40.72ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (8μs)
  • afterRenderModule mod_menu (Main Menu) (47.4KB) (382μs)
  • beforeRenderRawModule mod_finder (Search) (67KB) (426μs)
  • afterRenderRawModule mod_finder (Search) (126.46KB) (16.57ms)
  • beforeRenderModule mod_finder (Search) (704B) (6μs)
  • afterRenderModule mod_finder (Search) (3.73KB) (457μs)
  • beforeRenderRawModule mod_custom (Chris Appleby Ministries) (20.43KB) (1.42ms)
  • afterRenderRawModule mod_custom (Chris Appleby Ministries) (1000B) (105μs)
  • beforeRenderModule mod_custom (Chris Appleby Ministries) (736B) (3μs)
  • afterRenderModule mod_custom (Chris Appleby Ministries) (2.75KB) (58μs)
  • afterRender (410.09KB) (43.57ms)
  • 1 x afterRenderComponent com_content (799.04KB) (39.02%)
    243ms
    1 x afterInitialise (1.51MB) (13.89%)
    86.48ms
    1 x afterRoute (2.13MB) (12.53%)
    78.01ms
    1 x afterRender (410.09KB) (7%)
    43.57ms
    1 x afterRenderRawModule mod_menu (Main Menu) (1.71MB) (6.54%)
    40.72ms
    1 x beforeRenderRawModule mod_custom (footer) (512.99KB) (6.22%)
    38.72ms
    1 x afterRenderRawModule mod_banners (Dreamhost Banner) (109.8KB) (4.56%)
    28.38ms
    1 x afterRenderRawModule mod_finder (Search) (126.46KB) (2.66%)
    16.57ms
    1 x beforeRenderComponent com_content (177.28KB) (1.72%)
    10.68ms
    1 x Before Access::preloadComponents (all components) (51.37KB) (1.14%)
    7.08ms
    1 x After Access::preloadPermissions (com_content) (153.71KB) (1.12%)
    6.99ms
    1 x afterRenderRawModule mod_custom (Contact Details) (39.96KB) (0.92%)
    5.73ms
    1 x afterRenderRawModule mod_custom (footer) (5.52KB) (0.44%)
    2.74ms
    1 x After Access::preloadComponents (all components) (142.98KB) (0.39%)
    2.40ms
    1 x beforeRenderRawModule mod_custom (Chris Appleby Ministries) (20.43KB) (0.23%)
    1.42ms
    1 x beforeRenderRawModule mod_custom (Contact Details) (3.12KB) (0.22%)
    1.39ms
    1 x After Access::getAssetRules (id:133 name:com_content.article.551) (72.75KB) (0.17%)
    1.06ms
    1 x afterDispatch (98.14KB) (0.16%)
    995μs
    1 x beforeRenderRawModule mod_banners (Dreamhost Banner) (5.06KB) (0.16%)
    967μs
    1 x afterRenderRawModule mod_addtoany (AddToAny Buttons) (4.85KB) (0.15%)
    954μs
    1 x afterRenderModule mod_custom (footer) (2.07KB) (0.13%)
    839μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (24.54KB) (0.11%)
    715μs
    1 x afterLoad (93.31KB) (0.1%)
    615μs
    1 x afterRenderModule mod_finder (Search) (3.73KB) (0.07%)
    457μs
    1 x beforeRenderRawModule mod_finder (Search) (67KB) (0.07%)
    426μs
    1 x afterRenderModule mod_menu (Main Menu) (47.4KB) (0.06%)
    382μs
    1 x beforeRenderRawModule mod_addtoany (AddToAny Buttons) (22.04KB) (0.05%)
    333μs
    1 x afterRenderModule mod_banners (Dreamhost Banner) (4.13KB) (0.04%)
    280μs
    1 x afterRenderRawModule mod_custom (Chris Appleby Ministries) (1000B) (0.02%)
    105μs
    1 x afterRenderModule mod_custom (Contact Details) (2.88KB) (0.01%)
    68μs
    1 x afterRenderModule mod_addtoany (AddToAny Buttons) (2.75KB) (0.01%)
    59μs
    1 x afterRenderModule mod_custom (Chris Appleby Ministries) (2.75KB) (0.01%)
    58μs
    1 x Before Access::getAssetRules (id:133 name:com_content.article.551) (18.8KB) (0%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0%)
    14μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    8μs
    1 x beforeRenderModule mod_banners (Dreamhost Banner) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (footer) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Contact Details) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_finder (Search) (704B) (0%)
    6μs
    1 x beforeRenderModule mod_addtoany (AddToAny Buttons) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Chris Appleby Ministries) (736B) (0%)
    3μs
41 statements were executed, 5 of which were duplicates, 36 unique196ms501.68KB
  • SELECT @@SESSION.sql_mode;1.7ms1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `J30_session` WHERE `session_id` = ?284μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `J30_session` WHERE `session_id` = :session_id LIMIT 1385μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `J30_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.98ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `J30_viewlevels`1.83ms1.58KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `J30_usergroups` AS `a` LEFT JOIN `J30_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest351μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `path` FROM J30_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'1.97ms840B/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM J30_rsfirewall_hashes WHERE `type`='protect'787μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM J30_rsfirewall_configuration679μs3.44KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `J30_rsfirewall_logs`32.76ms2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM J30_rsfirewall_hashes WHERE (`type`='5.3.3' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)577μs1.11KB/plugins/system/rsfirewall/rsfirewall.php:1107Copy
  • SELECT * FROM J30_rsfirewall_snapshots WHERE `type`='protect'4.65ms1008B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT `ip`,`reason` FROM J30_rsfirewall_lists WHERE (`ip`='216.73.216.36' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'1.38ms896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM J30_rsfirewall_lists WHERE (`ip`='216.73.216.36' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'728μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM J30_rsfirewall_exceptions WHERE `published`='1'769μs2.05KB/plugins/system/rsfirewall/rsfirewall.php:758Copy
  • SELECT * FROM `J30_languages` WHERE `published` = 1 ORDER BY `ordering` ASC5.2ms2.22KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `J30_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)1.19ms10.63KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `J30_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 06.38ms25.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `J30_content`42.32ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `J30_content` SET `hits` = (`hits` + 1) WHERE `id` = '551'22.02ms48B/libraries/src/Table/Table.php:1348Copy
  • 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 `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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)756μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `J30_categories` AS `s` INNER JOIN `J30_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`950μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `J30_contentitem_tag_map` AS `m` INNER JOIN `J30_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)3.53ms5.22KBParams/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 `J30_categories` AS `s` INNER JOIN `J30_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`2.22ms5.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 J30_fields AS a LEFT JOIN `J30_languages` AS l ON l.lang_code = a.language LEFT JOIN J30_users AS uc ON uc.id=a.checked_out LEFT JOIN J30_viewlevels AS ag ON ag.id = a.access LEFT JOIN J30_users AS ua ON ua.id = a.created_user_id LEFT JOIN J30_fields_groups AS g ON g.id = a.group_id LEFT JOIN `J30_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 ORDER BY a.ordering ASC763μs6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `contact`.`id` AS `contactid`,`contact`.`alias`,`contact`.`catid`,`contact`.`webpage`,`contact`.`email_to` FROM `J30_contact_details` AS `contact` WHERE `contact`.`published` = 1 AND `contact`.`user_id` = :createdby ORDER BY `contact`.`id` DESC LIMIT 11.61ms1.84KBParams/plugins/content/contact/src/Extension/Contact.php:158Copy
  • SHOW FULL COLUMNS FROM `J30_users`21.33ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `J30_users` WHERE `id` = :userid949μs4.41KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `J30_usergroups` AS `g` INNER JOIN `J30_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid704μs1.68KBParams/libraries/src/Table/User.php:134Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `J30_modules` AS `m` LEFT JOIN `J30_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `J30_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) ORDER BY `m`.`position`,`m`.`ordering`6.28ms298.13KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT * FROM `J30_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)2.33ms7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions` FROM `J30_banners` AS `a` LEFT JOIN `J30_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid` WHERE ( ( (`a`.`state` = 1) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND (`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 52.51ms2.91KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • UPDATE `J30_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)9.16ms11.84KBParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • 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 J30_fields AS a LEFT JOIN `J30_languages` AS l ON l.lang_code = a.language LEFT JOIN J30_users AS uc ON uc.id=a.checked_out LEFT JOIN J30_viewlevels AS ag ON ag.id = a.access LEFT JOIN J30_users AS ua ON ua.id = a.created_user_id LEFT JOIN J30_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,: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 ASC4.16ms5.27KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `title` FROM `J30_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)475μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `J30_schemaorg` WHERE `itemId` = :itemId AND `context` = :context1.19ms1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:429Copy
  • 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 `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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)1.16ms24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `J30_content` AS `a` INNER JOIN `J30_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `J30_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `J30_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `J30_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `J30_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)1.65ms24.67KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `J30_scheduler_tasks` AS `a` WHERE `a`.`state` = 1497μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `J30_session` WHERE `session_id` = ?4.1ms1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `J30_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?987μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy