Dairy carrier
Once you make the decision to start a dairy carrier business, there are several steps to follow before you can legally operate.
Take a look at each of the sections below for all the information you'll need to get started, including a checklist of requirements before you apply for a dairy licence with Dairy Food Safety Victoria (DFSV).
To operate a dairy carrier business in Victoria you are required under the Dairy Act 2000 to be licensed with DFSV and comply with the conditions of that licence. Dairy carrier licence holders must also comply with all relevant provisions of the Food Act 1984 and the Australia New Zealand Food Standards Code in relation to the transport of dairy food.
The Victorian dairy licence handbook outlines what is required to obtain and operate under a DFSV dairy licence.
- Ensure your vehicles meet the requirements
Your business and vehicles must comply with Standard 3.2.3 and Division 3 of Standard 4.2.4 - Primary production and processing standard for dairy products of the Australia New Zealand Food Standards Code. Further information is available in the FSANZ Guide to Part 2: Dairy Collection and Transport Requirements. - Develop a food safety program
The Food Standards Code requires dairy carrier businesses to control potential food safety hazards by implementing a documented food safety program based on Codex HACCP principles.The program must outline the control measures and procedures in place to reduce or eliminate potential food safety hazards associated with the collection and transportation of dairy products. DFSV has developed the Model food safety program , which can be used as a template that you can modify to suit your business.
Additional requirements – transporting raw milk for raw milk cheese production
If you intend to collect and transport milk for raw milk cheese you must address the additional requirements under Standard 4.2.4 in a documented and validated food safety program for DFSV approval. Further information, including a checklist of the additional requirements, is available here. - Ensure adequate skills
Ensure you have the necessary skills and competency to manage food safety in your business.
Need help?
If you have any questions or need more information contact us at This email address is being protected from spambots. You need JavaScript enabled to view it. or on 03 9810 5900.
If you have any questions or need more information contact us at This email address is being protected from spambots. You need JavaScript enabled to view it. or on 03 9810 5900.
A dairy carrier licence must be held by the person or entity in charge of operating the business and therefore ultimately responsible for the safety of the dairy food handled. The applicant must be a licenseable legal entity (e.g. natural person in law, registered partnership, company or Trustee and trust).
Submitting your application
Applications for new licences and licence cancellations can be downloaded and printed. Return completed forms to DFSV with applicable payment made by EFT (EFT details are on the application form).
New licence Cancel a dairy licence
Click here for a dairy carrier application information pack
Click here for information regarding application terminology
Please note that it is an offence under the Dairy Act 2000 to commence operations prior to the licence being issued by Dairy Food Safety Victoria.
Once your application is received a DFSV food safety manager will make contact with you within seven business days after a full application has been submitted ie, an application where the application form, fee and food safety program have been submitted. You will have 14 days to supply full details after submitting your application, otherwise your application may be refused and the application fee refunded.
In order to assist DFSV in processing your application within 60 business days from receipt, please ensure that:
- The application form is complete and includes relevant payment, and
- A food safety program is provided that meets the relevant legislation.
- Any requested changes to your food safety program draft submitted must be completed and returned within a 30 day period. Failure to do so may result in your application being refused and the application fee forfeited.
The premise where the vehicles are to be based should also be compliant with the relevant legislation.
If these conditions are not met your licence application may not be progressed within this period and may be subject to cancellation after three months from the date of application unless an extension is granted by a member of DFSV's Senior Management Team. Applicants will be advised that their application has been refused and that a new application will be required to be submitted. No refund is issued.
A licence application may be refused if the applicant fails to meet the licence approval requirements.
Application fee
The one-off application fee for new dairy distributor licences is $192.90
Licence fees
These are paid to DFSV annually from 1 January to 31 December.
| Rate per annum | |
|---|---|
| Any number | $63.90 |
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1734184331,
"last": 1734184331,
"now": 1734184331
}
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 3.68 ms / 3.68 ms Memory: 0.410 MB / 0.73 MB Application: afterLoad
Time: 41.52 ms / 45.20 ms Memory: 4.103 MB / 4.84 MB Application: afterInitialise
Time: 12.11 ms / 57.31 ms Memory: 0.942 MB / 5.78 MB Application: afterRoute
Time: 0.50 ms / 57.81 ms Memory: 0.027 MB / 5.81 MB Application: beforeRenderComponent com_content
Time: 1.13 ms / 58.94 ms Memory: 0.054 MB / 5.86 MB Application: Before Access::preloadComponents (all components)
Time: 0.67 ms / 59.60 ms Memory: 0.071 MB / 5.93 MB Application: After Access::preloadComponents (all components)
Time: 0.02 ms / 59.62 ms Memory: -0.004 MB / 5.93 MB Application: Before Access::preloadPermissions (com_content)
Time: 0.94 ms / 60.56 ms Memory: 0.353 MB / 6.28 MB Application: After Access::preloadPermissions (com_content)
Time: 0.02 ms / 60.58 ms Memory: -0.018 MB / 6.26 MB Application: Before Access::getAssetRules (id:793 name:com_content.article.818)
Time: 0.23 ms / 60.81 ms Memory: 0.009 MB / 6.27 MB Application: After Access::getAssetRules (id:793 name:com_content.article.818)
Time: 106.67 ms / 167.48 ms Memory: 3.587 MB / 9.86 MB Application: afterRenderComponent com_content
Time: 1.70 ms / 169.18 ms Memory: 0.027 MB / 9.88 MB Application: afterDispatch
Time: 0.63 ms / 169.81 ms Memory: 0.050 MB / 9.93 MB Application: beforeRenderModule mod_custom (Footer - Social)
Time: 0.35 ms / 170.16 ms Memory: 0.006 MB / 9.94 MB Application: afterRenderModule mod_custom (Footer - Social)
Time: 0.02 ms / 170.18 ms Memory: -0.001 MB / 9.94 MB Application: beforeRenderModule mod_menu (Footer - Menu)
Time: 1.39 ms / 171.57 ms Memory: 0.051 MB / 9.99 MB Application: afterRenderModule mod_menu (Footer - Menu)
Time: 0.02 ms / 171.59 ms Memory: -0.004 MB / 9.98 MB Application: beforeRenderModule mod_custom (Footer - Contact)
Time: 0.12 ms / 171.71 ms Memory: 0.004 MB / 9.99 MB Application: afterRenderModule mod_custom (Footer - Contact)
Time: 0.01 ms / 171.72 ms Memory: 0.000 MB / 9.99 MB Application: beforeRenderModule mod_menu (I want to learn more about)
Time: 1.07 ms / 172.79 ms Memory: 0.055 MB / 10.04 MB Application: afterRenderModule mod_menu (I want to learn more about)
Time: 0.02 ms / 172.81 ms Memory: -0.003 MB / 10.04 MB Application: beforeRenderModule mod_menu (Footer - Main menu)
Time: 0.85 ms / 173.66 ms Memory: 0.125 MB / 10.17 MB Application: afterRenderModule mod_menu (Footer - Main menu)
Time: 0.05 ms / 173.71 ms Memory: -0.003 MB / 10.16 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.58 ms / 174.29 ms Memory: 0.022 MB / 10.19 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.03 ms / 174.32 ms Memory: -0.005 MB / 10.18 MB Application: beforeRenderModule mod_menu (Left - Accordion menu)
Time: 5.76 ms / 180.08 ms Memory: 0.277 MB / 10.46 MB Application: afterRenderModule mod_menu (Left - Accordion menu)
Time: 0.04 ms / 180.12 ms Memory: -0.006 MB / 10.45 MB Application: beforeRenderModule mod_banners (Internal banner carrier)
Time: 4.79 ms / 184.91 ms Memory: 0.060 MB / 10.51 MB Application: afterRenderModule mod_banners (Internal banner carrier)
Time: 0.03 ms / 184.94 ms Memory: -0.006 MB / 10.51 MB Application: beforeRenderModule mod_menu (Main menu)
Time: 4.67 ms / 189.61 ms Memory: 0.023 MB / 10.53 MB Application: afterRenderModule mod_menu (Main menu)
Time: 0.05 ms / 189.67 ms Memory: -0.005 MB / 10.52 MB Application: beforeRenderModule mod_menu (Device menu - Bottom menu)
Time: 0.58 ms / 190.24 ms Memory: 0.033 MB / 10.56 MB Application: afterRenderModule mod_menu (Device menu - Bottom menu)
Time: 0.03 ms / 190.27 ms Memory: -0.003 MB / 10.55 MB Application: beforeRenderModule mod_search (Device menu - Search)
Time: 0.37 ms / 190.64 ms Memory: 0.016 MB / 10.57 MB Application: afterRenderModule mod_search (Device menu - Search)
Time: 0.03 ms / 190.68 ms Memory: -0.004 MB / 10.57 MB Application: beforeRenderModule mod_menu (Top - Menu)
Time: 0.47 ms / 191.15 ms Memory: 0.020 MB / 10.59 MB Application: afterRenderModule mod_menu (Top - Menu)
Time: 0.01 ms / 191.16 ms Memory: -0.004 MB / 10.58 MB Application: beforeRenderModule mod_custom (Top - Social)
Time: 0.11 ms / 191.28 ms Memory: 0.003 MB / 10.59 MB Application: afterRenderModule mod_custom (Top - Social)
Time: 0.01 ms / 191.29 ms Memory: 0.000 MB / 10.59 MB Application: beforeRenderModule mod_search (Top - Search)
Time: 0.17 ms / 191.46 ms Memory: 0.005 MB / 10.59 MB Application: afterRenderModule mod_search (Top - Search)
Time: 3.51 ms / 194.97 ms Memory: 0.245 MB / 10.84 MB Application: afterRender
Database queries total: 29.92 ms
11.82 MB (12,389,968 Bytes)
53 Queries Logged 29.92 ms
- Query Time: 0.20 ms Query memory: 0.023 MB Memory before query: 1.013 MB Rows returned: 0
SELECT `data`
FROM `jla_session`
WHERE `session_id` = X'3730643661626263326432633032646565353935613833626632626265613665'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.12 ms After last query: 0.42 ms Query memory: 0.020 MB Memory before query: 1.027 MB Rows returned: 0
SELECT `session_id`
FROM `jla_session`
WHERE `session_id` = X'3730643661626263326432633032646565353935613833626632626265613665'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 3.89 ms After last query: 0.04 ms Query memory: 0.004 MB Memory before query: 1.033 MB
INSERT INTO `jla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3730643661626263326432633032646565353935613833626632626265613665', 1, 1734184331, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `jla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3730643661626263326432633032646565353935613833626632626265613665', 1, 1734184331, 0, '', 0)Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms update 0.79 ms end 0.01 ms query end 0.00 ms waiting for handler commit 2.99 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.36 ms After last query: 0.56 ms Query memory: 0.025 MB Memory before query: 1.064 MB Rows returned: 45
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jla_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_extensions NULL ref extension extension 82 const 52 1.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.13 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.16 ms After last query: 0.56 ms Query memory: 0.021 MB Memory before query: 1.098 MB Rows returned: 5
SELECT id, rules
FROM `jla_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 1.110 MB Rows returned: 2
SELECT b.id
FROM jla_usergroups AS a
LEFT JOIN jla_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 0.09 ms Query memory: 0.030 MB Memory before query: 1.131 MB Rows returned: 106
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jla_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_extensions NULL ref extension extension 82 const 169 0.60 Using where; Using filesort Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.45 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.16 ms After last query: 1.89 ms Query memory: 0.021 MB Memory before query: 1.415 MB Rows returned: 0
SELECT `path`
FROM jla_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsfirewall_ignored NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:53 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:27 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 1.422 MB Rows returned: 0
SELECT `file`
FROM jla_rsfirewall_hashes
WHERE `type`='protect'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsfirewall_hashes NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 58 10.00 Using where Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_rsfirewall/helpers/config.php:60 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:27 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.18 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 1.427 MB Rows returned: 66
SELECT *
FROM jla_rsfirewall_configurationid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsfirewall_configuration NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 62 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/config.php:68 10 RSFirewallConfig->load() JROOT/administrator/components/com_rsfirewall/helpers/config.php:19 9 RSFirewallConfig->__construct() JROOT/administrator/components/com_rsfirewall/helpers/config.php:161 8 RSFirewallConfig::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:27 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.99 ms After last query: 1.52 ms Query memory: 0.024 MB Memory before query: 1.671 MB Rows returned: 10
SHOW FULL COLUMNS
FROM `jla_rsfirewall_logs`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jla_rsfirewall_logs`Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.36 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.08 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_rsfirewall/tables/logs.php:36 11 RsfirewallTableLogs->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_rsfirewall/helpers/log.php:23 9 RSFirewallLogger->__construct() JROOT/administrator/components/com_rsfirewall/helpers/log.php:77 8 RSFirewallLogger::getInstance() JROOT/plugins/system/rsfirewall/rsfirewall.php:47 7 plgSystemRsfirewall->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.73 ms After last query: 19.92 ms Query memory: 0.021 MB Memory before query: 4.588 MB Rows returned: 0
SELECT *
FROM ( SELECT *
FROM jla_redj_redirects
WHERE ( ( (CAST('/licensees/starting-a-dairy-business/carriers' AS BINARY) REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url<>0)
AND (request_only<>0) ) OR ( (CAST('/licensees/starting-a-dairy-business/carriers' AS BINARY) REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url=0)
AND (request_only<>0) ) OR ( (CAST('https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers' AS BINARY) REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url<>0)
AND (request_only=0) ) OR ( (CAST('https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers' AS BINARY) REGEXP BINARY fromurl)>0
AND (case_sensitive<>0)
AND (decode_url=0)
AND (request_only=0) ) OR ( ('/licensees/starting-a-dairy-business/carriers' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url<>0)
AND (request_only<>0) ) OR ( ('/licensees/starting-a-dairy-business/carriers' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url=0)
AND (request_only<>0) ) OR ( ('https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url<>0)
AND (request_only=0) ) OR ( ('https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers' REGEXP fromurl)>0
AND (case_sensitive=0)
AND (decode_url=0)
AND (request_only=0) ) )
AND published=1
ORDER BY ordering ) AS A
WHERE A.skip='' OR ( (CAST('https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers' AS BINARY) REGEXP BINARY A.skip)=0
AND (case_sensitive<>0)
AND (decode_url<>0) ) OR ( (CAST('https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers' AS BINARY) REGEXP BINARY A.skip)=0
AND (case_sensitive<>0)
AND (decode_url=0) ) OR ( ('https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers' REGEXP A.skip)=0
AND (case_sensitive=0)
AND (decode_url<>0) ) OR ( ('https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers' REGEXP A.skip)=0
AND (case_sensitive=0)
AND (decode_url=0) )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_redj_redirects NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 10 10.00 Using where; Using filesort Status Duration starting 0.13 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.00 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.03 ms preparing 0.05 ms executing 0.30 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/redj/redj.php:1441 9 plgSystemReDJ->setRedirect() JROOT/plugins/system/redj/redj.php:1290 8 plgSystemReDJ->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.18 ms After last query: 1.97 ms Query memory: 0.023 MB Memory before query: 4.827 MB Rows returned: 36
SELECT *
FROM jla_rsform_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsform_config NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 36 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsform/helpers/config.php:50 11 RSFormProConfig->load() JROOT/administrator/components/com_rsform/helpers/config.php:17 10 RSFormProConfig->__construct() JROOT/administrator/components/com_rsform/helpers/config.php:102 9 RSFormProConfig::getInstance() JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26 8 plgSystemRsformdeletesubmissions->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.17 ms After last query: 0.76 ms Query memory: 0.214 MB Memory before query: 4.875 MB Rows returned: 159
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM jla_menu AS m
LEFT JOIN jla_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 300 7.47 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 dairysafe.m.component_id 1 100.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.92 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 3.90 ms Query memory: 0.020 MB Memory before query: 5.631 MB Rows returned: 0
SELECT *
FROM jla_rsfirewall_hashes
WHERE (`type`='3.10.10' OR `type`='protect')
AND `flag`!='C'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsfirewall_hashes NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 58 17.10 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:1049 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.13 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 5.643 MB Rows returned: 0
SELECT *
FROM jla_rsfirewall_snapshots
WHERE `type`='protect'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsfirewall_snapshots NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47 9 RSFirewallSnapshot::get() JROOT/plugins/system/rsfirewall/rsfirewall.php:1072 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 5.657 MB Rows returned: 3
SELECT `ip`,`reason`
FROM jla_rsfirewall_lists
WHERE (`ip`='3.139.104.9' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsfirewall_lists NULL ref published,type,ip type 1 const 10 34.49 Using where Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:165 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:144 9 plgSystemRsfirewall->isWhitelisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1108 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.20 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 5.670 MB Rows returned: 0
SELECT `ip`,`reason`
FROM jla_rsfirewall_lists
WHERE (`ip`='3.139.104.9' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsfirewall_lists NULL ref published,type,ip type 1 const 22 34.49 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:165 10 plgSystemRsfirewall->isListed() JROOT/plugins/system/rsfirewall/rsfirewall.php:134 9 plgSystemRsfirewall->isBlacklisted() JROOT/plugins/system/rsfirewall/rsfirewall.php:1112 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.14 ms After last query: 0.30 ms Query memory: 0.021 MB Memory before query: 5.681 MB Rows returned: 0
SELECT *
FROM jla_rsfirewall_exceptions
WHERE `published`='1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_rsfirewall_exceptions NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/rsfirewall/rsfirewall.php:700 9 plgSystemRsfirewall->isException() JROOT/plugins/system/rsfirewall/rsfirewall.php:1243 8 plgSystemRsfirewall->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.66 ms Query memory: 0.025 MB Memory before query: 5.745 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jla_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 18 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 15 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 14 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 13 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/helper.php:18 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.20 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 5.746 MB
UPDATE `jla_extensions`
SET `params` = '{\"mediaversion\":\"8f681c5b431eb0746b35ed9dc7c3a04b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `jla_extensions` SET `params` = '{\"mediaversion\":\"8f681c5b431eb0746b35ed9dc7c3a04b\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.04 ms updating 0.08 ms end 0.00 ms query end 0.00 ms waiting for handler commit 2.98 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/helper.php:18 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.44 ms Query memory: 0.021 MB Memory before query: 5.773 MB Rows returned: 2
SELECT id, home, template, s.params
FROM jla_template_styles as s
LEFT JOIN jla_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 2 100.00 NULL 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 dairysafe.s.template,const 1 4.50 Using index condition; Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/jqueryeasy/helper.php:24 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.22 ms Query memory: 0.019 MB Memory before query: 5.795 MB Rows returned: 1
SELECT *
FROM jla_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.55 ms After last query: 1.38 ms Query memory: 0.028 MB Memory before query: 5.873 MB Rows returned: 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jla_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_cjlib','com_communitysurveys','com_config','com_content','com_contenthistory','com_cpanel','com_docman','com_fields','com_files','com_installer','com_jce','com_jmap','com_joomlaupdate','com_languages','com_licensees','com_login','com_mailto','com_media','com_menus','com_messages','com_miniorange_oauth','com_modules','com_plugins','com_postinstall','com_privacy','com_redirect','com_redj','com_rsfirewall','com_rsform','com_search','com_searchlicensee','com_tags','com_templates','com_users','com_wrapper','com_xmap')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_assets NULL range idx_asset_name idx_asset_name 202 NULL 46 100.00 Using index condition Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms executing 0.28 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 0.11 ms Query memory: 0.087 MB Memory before query: 5.937 MB Rows returned: 373
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jla_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 758 21.38 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.44 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.02 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.26 ms After last query: 0.72 ms Query memory: 0.031 MB Memory before query: 6.281 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `jla_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jla_content`Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.32 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.06 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.04 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.36 ms After last query: 0.83 ms Query memory: 0.005 MB Memory before query: 6.398 MB
UPDATE jla_content
SET `hits` = (`hits` + 1)
WHERE `id` = '818'EXPLAIN not possible on query: UPDATE jla_content SET `hits` = (`hits` + 1) WHERE `id` = '818'Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.04 ms updating 0.10 ms end 0.00 ms query end 0.00 ms waiting for handler commit 4.11 ms closing tables 0.02 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.50 ms Query memory: 0.038 MB Memory before query: 6.428 MB Rows returned: 1
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,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as 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, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jla_content AS a
INNER JOIN jla_categories AS c
on c.id = a.catid
LEFT JOIN jla_users AS u
on u.id = a.created_by
LEFT JOIN jla_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jla_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 818
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-14 13:52:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-14 13:52:11')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.84 ms Query memory: 0.022 MB Memory before query: 6.505 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `jla_contentitem_tag_map` AS m
INNER JOIN `jla_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 818
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 dairysafe.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.38 ms After last query: 1.92 ms Query memory: 0.027 MB Memory before query: 6.643 MB Rows returned: 3
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 `jla_categories` AS `s`
INNER JOIN `jla_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='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 69
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 14 58.82 Using index condition; Using where Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms executing 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.50 ms After last query: 0.19 ms Query memory: 0.025 MB Memory before query: 6.680 MB Rows returned: 0
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,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 jla_fields AS a
LEFT JOIN `jla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jla_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (69,0,68))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 dairysafe.a.language 1 100.00 Using index condition 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 dairysafe.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 dairysafe.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 dairysafe.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 dairysafe.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 dairysafe.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.07 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.02 ms Creating tmp table 0.06 ms executing 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.14 ms After last query: 87.75 ms Query memory: 0.023 MB Memory before query: 9.587 MB Rows returned: 1
SELECT title,docman_category_id
FROM jla_docman_documents
WHERE docman_document_id = 475id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_documents NULL const docman_document_id docman_document_id 8 const 1 100.00 NULL Status Duration starting 0.02 ms Opening tables 0.01 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:85 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.11 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 9.610 MB Rows returned: 1Duplicate queries: #35
SELECT title
FROM jla_docman_categories
WHERE docman_category_id = 36id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_categories NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.38 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.05 ms executing 0.17 ms checking permissions 0.44 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:95 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.11 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 9.626 MB Rows returned: 1
SELECT title,docman_category_id
FROM jla_docman_documents
WHERE docman_document_id = 478id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_documents NULL const docman_document_id docman_document_id 8 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.28 ms init 0.01 ms System lock 0.03 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.04 ms checking permissions 0.12 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:85 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.11 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 9.641 MB Rows returned: 1Duplicate queries: #33
SELECT title
FROM jla_docman_categories
WHERE docman_category_id = 36id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_categories NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.27 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:95 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.11 ms After last query: 0.03 ms Query memory: 0.023 MB Memory before query: 9.656 MB Rows returned: 1
SELECT title,docman_category_id
FROM jla_docman_documents
WHERE docman_document_id = 440id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_documents NULL const docman_document_id docman_document_id 8 const 1 100.00 NULL Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.13 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:85 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 9.671 MB Rows returned: 1
SELECT title
FROM jla_docman_categories
WHERE docman_category_id = 50id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_categories NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Creating tmp table 0.05 ms executing 0.02 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:95 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 9.686 MB Rows returned: 1
SELECT title,docman_category_id
FROM jla_docman_documents
WHERE docman_document_id = 259id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_documents NULL const docman_document_id docman_document_id 8 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.35 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.24 ms checking permissions 0.37 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:85 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 9.702 MB Rows returned: 1
SELECT title
FROM jla_docman_categories
WHERE docman_category_id = 50id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_categories NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.26 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.03 ms checking permissions 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:95 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 9.717 MB Rows returned: 1
SELECT title,docman_category_id
FROM jla_docman_documents
WHERE docman_document_id = 282id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_documents NULL const docman_document_id docman_document_id 8 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.30 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.04 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:85 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 9.732 MB Rows returned: 1
SELECT title
FROM jla_docman_categories
WHERE docman_category_id = 50id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_docman_categories NULL const PRIMARY PRIMARY 8 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/content/docman_ga/docman_ga.php:95 13 PlgContentDocman_GA->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.04 ms After last query: 4.26 ms Query memory: 0.114 MB Memory before query: 9.857 MB Rows returned: 167
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jla_modules AS m
LEFT JOIN jla_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jla_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-12-14 13:52:11')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-14 13:52:11')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 419 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 82 1.22 Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 dairysafe.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 dairysafe.m.id 5 40.00 Using where; Using index Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.33 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.20 ms checking permissions 0.35 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 16 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 15 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 14 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/templates/dairysafe/html/com_content/article/default.php:46 13 include JROOT/templates/dairysafe/html/com_content/article/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_content/views/article/view.html.php:210 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.18 ms After last query: 13.62 ms Query memory: 0.022 MB Memory before query: 10.482 MB Rows returned: 0
SELECT *
FROM jla_banners
WHERE '2024-12-14 13:52:11' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.25 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.03 ms checking permissions 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_banners/helpers/banners.php:79 11 BannersHelper::updateReset() JROOT/modules/mod_banners/mod_banners.php:19 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.29 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 10.508 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jla_banners as a
LEFT JOIN jla_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-14 13:52:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-14 13:52:11')
AND (a.imptotal = 0 OR a.impmade < a.imptotal)
AND a.catid IN (94)
ORDER BY a.sticky DESC,a.ordering
LIMIT 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_banner_catid idx_banner_catid 4 const 1 6.40 Using where; Using filesort 1 SIMPLE cl NULL eq_ref PRIMARY PRIMARY 4 dairysafe.a.cid 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.27 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.03 ms executing 0.04 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_banners/models/banners.php:222 12 BannersModelBanners->getItems() JROOT/modules/mod_banners/helper.php:48 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.56 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 10.527 MB
UPDATE jla_banners
SET impmade = (impmade + 1)
WHERE id IN (11)EXPLAIN not possible on query: UPDATE jla_banners SET impmade = (impmade + 1) WHERE id IN (11)Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.26 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/components/com_banners/models/banners.php:268 12 BannersModelBanners->impress() JROOT/modules/mod_banners/helper.php:54 11 ModBannersHelper::getList() JROOT/modules/mod_banners/mod_banners.php:20 10 include JROOT/modules/mod_banners/mod_banners.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.20 ms After last query: 7.11 ms Query memory: 0.022 MB Memory before query: 10.595 MB Rows returned: 0
SELECT *
FROM jla_jmap_metainfo
WHERE `linkurl` = 'https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers'
AND `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_jmap_metainfo NULL ref linkurl,published linkurl 766 const 1 100.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.24 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:514 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.13 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 10.608 MB Rows returned: 0
SELECT *
FROM jla_jmap_canonicals
WHERE `linkurl` = 'https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_jmap_canonicals NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.22 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:593 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.14 ms After last query: 0.77 ms Query memory: 0.021 MB Memory before query: 10.691 MB Rows returned: 1
SELECT sleep_until < '2024-12-14 13:52:11'
FROM jla_scheduler_metadata
WHERE type = 'metadata'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_scheduler_metadata NULL const unique_type unique_type 98 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.22 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128 8 PlgSystemJoomlatoolsscheduler->onAfterRender() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167 6 PlgSystemJoomlatoolsscheduler->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.12 ms After last query: 0.10 ms Query memory: 0.020 MB Memory before query: 10.753 MB Rows returned: 0
SELECT *
FROM jla_jmap_headings
WHERE `linkurl` = 'https://regtechstaging.dairysafe.vic.gov.au/licensees/starting-a-dairy-business/carriers'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jla_jmap_headings NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.22 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:909 7 plgSystemJMap->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 10.772 MB Rows returned: 1
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `jla_docman_category_relations` as r
INNER JOIN `jla_docman_categories` AS c2
ON c2.slug = 'guidelines'
LEFT JOIN `jla_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2 NULL const PRIMARY,slug slug 767 const 1 100.00 Using index 1 SIMPLE r NULL ref path_index path_index 8 const 2 100.00 Using index 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 8 dairysafe.r.ancestor_id 1 100.00 NULL Status Duration starting 0.10 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.13 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_docman/router.php:83 17 ComDocmanRouter->getCategoryPath() JROOT/components/com_docman/router.php:192 16 ComDocmanRouter->build() JROOT/components/com_docman/router.php:398 15 DocmanBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.03 ms Query memory: 0.024 MB Memory before query: 10.791 MB Rows returned: 1
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `jla_docman_category_relations` as r
INNER JOIN `jla_docman_categories` AS c2
ON c2.slug = 'resouce'
LEFT JOIN `jla_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2 NULL const PRIMARY,slug slug 767 const 1 100.00 Using index 1 SIMPLE r NULL ref path_index path_index 8 const 1 100.00 Using index 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 8 dairysafe.r.ancestor_id 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Creating tmp table 0.04 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_docman/router.php:83 17 ComDocmanRouter->getCategoryPath() JROOT/components/com_docman/router.php:203 16 ComDocmanRouter->build() JROOT/components/com_docman/router.php:398 15 DocmanBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 10.857 MB Rows returned: 1
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `jla_docman_category_relations` as r
INNER JOIN `jla_docman_categories` AS c2
ON c2.slug = 'other-guidelines'
LEFT JOIN `jla_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2 NULL const PRIMARY,slug slug 767 const 1 100.00 Using index 1 SIMPLE r NULL ref path_index path_index 8 const 2 100.00 Using index 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 8 dairysafe.r.ancestor_id 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.23 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_docman/router.php:83 17 ComDocmanRouter->getCategoryPath() JROOT/components/com_docman/router.php:192 16 ComDocmanRouter->build() JROOT/components/com_docman/router.php:398 15 DocmanBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.21 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 10.878 MB Rows returned: 1
SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `jla_docman_category_relations` as r
INNER JOIN `jla_docman_categories` AS c2
ON c2.slug = 'licence-applications'
LEFT JOIN `jla_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
WHERE r.descendant_id = c2.docman_category_id
ORDER BY r.level DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c2 NULL const PRIMARY,slug slug 767 const 1 100.00 Using index 1 SIMPLE r NULL ref path_index path_index 8 const 2 100.00 Using index 1 SIMPLE c NULL eq_ref PRIMARY PRIMARY 8 dairysafe.r.ancestor_id 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_docman/router.php:83 17 ComDocmanRouter->getCategoryPath() JROOT/components/com_docman/router.php:192 16 ComDocmanRouter->build() JROOT/components/com_docman/router.php:398 15 DocmanBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1118 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
42 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × SELECT title
FROM jla_docman_categories5 × SELECT title,docman_category_id
FROM jla_docman_documents2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jla_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jla_extensions`2 × SELECT `ip`,`reason`
FROM jla_rsfirewall_lists1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jla_banners as a
LEFT JOIN jla_banner_clients AS cl
ON cl.id = a.cid1 × 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,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 jla_fields AS a
LEFT JOIN `jla_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jla_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jla_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jla_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jla_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jla_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jla_modules AS m
LEFT JOIN jla_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jla_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM jla_banners1 × SELECT *
FROM jla_jmap_metainfo1 × SELECT `m`.`tag_id`,`t`.*
FROM `jla_contentitem_tag_map` AS m
INNER JOIN `jla_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT *
FROM jla_jmap_canonicals1 × SELECT sleep_until < '2024-12-14 13:52:11'
FROM jla_scheduler_metadata1 × SELECT *
FROM jla_jmap_headings1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `jla_docman_category_relations` as r
INNER JOIN `jla_docman_categories` AS c2
ON c2.slug = 'guidelines'
LEFT JOIN `jla_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `jla_docman_category_relations` as r
INNER JOIN `jla_docman_categories` AS c2
ON c2.slug = 'resouce'
LEFT JOIN `jla_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `jla_docman_category_relations` as r
INNER JOIN `jla_docman_categories` AS c2
ON c2.slug = 'other-guidelines'
LEFT JOIN `jla_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id1 × 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 `jla_categories` AS `s`
INNER JOIN `jla_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT `data`
FROM `jla_session`1 × 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,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as 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, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jla_content AS a
INNER JOIN jla_categories AS c
on c.id = a.catid
LEFT JOIN jla_users AS u
on u.id = a.created_by
LEFT JOIN jla_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jla_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM ( SELECT *
FROM jla_redj_redirects1 × SELECT id, rules
FROM `jla_viewlevels1 × SELECT b.id
FROM jla_usergroups AS a
LEFT JOIN jla_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jla_extensions1 × SELECT `path`
FROM jla_rsfirewall_ignored1 × SELECT `file`
FROM jla_rsfirewall_hashes1 × SELECT *
FROM jla_rsfirewall_configuratio1 × SELECT *
FROM jla_rsform_confi1 × SELECT `session_id`
FROM `jla_session`1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component
FROM jla_menu AS m
LEFT JOIN jla_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM jla_rsfirewall_hashes1 × SELECT *
FROM jla_rsfirewall_snapshots1 × SELECT *
FROM jla_rsfirewall_exceptions1 × SELECT id, home, template, s.params
FROM jla_template_styles as s
LEFT JOIN jla_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM jla_languages1 × SELECT GROUP_CONCAT(c.slug
ORDER BY r.level DESC SEPARATOR '/')
FROM `jla_docman_category_relations` as r
INNER JOIN `jla_docman_categories` AS c2
ON c2.slug = 'licence-applications'
LEFT JOIN `jla_docman_categories` AS c
ON c.docman_category_id = r.ancestor_id
OTHER Tables:
1 × INSERT INTO `jla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3730643661626263326432633032646565353935613833626632626265613665', 1, 1734184331, 0, '', 01 × SHOW FULL COLUMNS
FROM `jla_rsfirewall_logs1 × UPDATE `jla_extensions`
SET `params` = '{\"mediaversion\":\"8f681c5b431eb0746b35ed9dc7c3a04b\"}'1 × SHOW FULL COLUMNS
FROM `jla_content1 × UPDATE jla_content
SET `hits` = (`hits` + 1)1 × UPDATE jla_banners
SET impmade = (impmade + 1)