Ecological Landscape Design Online
Schedules And Registration
Course Overview
Overview and Outline
Please note: This course has pre-requisites
This is a very comprehensive course, beginning with an overview of historical garden design perspectives and include examinations of art, statuary, wildlife, water, and native ecosystems in the design process. The principles of landscape design and how the various elements are used in softscaping and hardscaping will be examined in detail on how to achieve particular aesthetics and function. Design terminology and drafting skills will be applied when following the steps of the design process. Through case studies and project work, the topics of site analysis, hardscape construction and grading, estimating and landscape supplies, drainage and water solutions, site remediation and special needs will be covered. Throughout, presentation skills will be emphasized.
Student Comment
I am over the top impressed with the ELD course which should not have surprised me after the courses I've enjoyed and learned so much coming from Gaia College.
Chris Morrison, Toronto
Read the Course Outline
If you have any questions about studying online with Gaia College please see our FAQs page.
Fees
Fees: $795.00
Fees include:
- Comprehensive on-line educational materials
- Unlimited access to our on-line course resources, community center, including libraries, discussion forums and much more.
Payment Options
By Mail: Cheque drawn on a Canadian bank; Money order in Canadian funds
On-line: Visa, Mastercard
Policies
Please be sure you are familiar with our policies.
Prerequisites
The successful completion of the following course is pre-requisite for the online Ecological Landscape Design course:
Landscape Design Basics with Sketchup Pro (formerly Sketchup Pro for Landscape Design)
(Sketchup Pro maybe taken as a co-requisite.)
Additionally, it is highly recommended that students have previously completed the Organic Master Gardener course (Classroom or Online) or Organic Horticulture Specialist course (Classroom or Online), as well as Ecological Plant Knowledge for Organic Gardeners course (or the Ecological Plant Knowledge 1 - Natives Online course). Either intend to take them concurrently or otherwise have extensive knowledge in the topics covered in above mentioned courses.
Also, students must
- be proficient in English (written)
- be comfortable with current computer and internet technology, including spreadsheets and word processing programs
- have an email account capable of receiving a large number of messages for the duration of the course
- have access to high-speed internet
- have access to a computer capable of running a current version of FireFox or Chrome.
Student Comment
Thanks for putting together such a great program, and you have awesome teachers!
Liz Nienaber, Victoria
Evaluations
There are no formal exams in this course, as the emphasis is on developing practical skills and the ability to synthesize information.
To receive a Certificate of Completion students must contribute to all on-line discussions and satisfactorily complete all assignments.
Student Comment
I am very grateful for the Gaia College courses because I can actually answer the questions that my clients have and sell them on things they didn't even know existed!
Elly Cruickshank, Organic Landscaper
Texts
Required Text
Reid, Grant W., Landscape Graphics, 2002 Edition, Whitney Library of Design, New York. Easily available through Amazon.ca.
Access to our extensive online resource library is included in the tuition.
Credits
This program is eligible for Continuing Education Credits (CECs) with the following:
Canadian Nursery Landscape Association (CNLA)
Also applies to B.C. Landscape & Nursery Association (BCLNA) and Landscape Ontario
Pre-approved: 24 Credits
National Association of Landcare Professionals - American (NALP)
Pre-approved: 24 Credits
International Society of Arboriculture: Certified Arborist
Pre-approved: 10 Credits
International Society of Arboriculture: Board Certified Management Arborist
Pre-approved: 10 Credits (Practice)
International Society of Arboriculture: Municipal Specialist
Pre-approved: 10 Credits
International Society of Arboriculture: Tree Worker/Aerial Lift
Pre-approved: 1.5 Credits
B.C. Society of Landscape Architects
As per certification renewal guidelines - eligibility of this program has been confirmed
Master Gardeners of Ontario Inc. (MGOI)
Pre-approved: 24 Credits
Canadian Society for Organic Urban Land Care (SOUL)
Pre-approved: 6 Credits
Integrated Pest Management (IPM) Canada
Pre-approved: 1.76 Credits
Northeast Organic Farming Association (NOFA)
Pre-approved: 4 Credits
This course partially satisfies the requirements of:
- Gaia College: Core course for Diploma in Organic Land Care
- Royal Roads: Core course for Joint Royal Roads/ Gaia College Diploma in Organic Land Care
- CLD designation offered through CNLA. Successful completion of the course may be used toward the achievement of the requirements for the Education component of the recertification process.
Log in
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1631849265,
"last": 1631849265,
"now": 1631849265
},
"token": "9a9DP0bXGSJDT335L11uGFU1XY07c4QS"
},
"registry": {
"com_snippets": {
"list": {
"limitstart": 0
}
},
"com_virtuemart": {
"categoryc62m0": {
"limitstart": 0
}
}
},
"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
},
"wb_sh404sef_404_redirect_message": null
},
"__vm": {
"manage": 0,
"vmlastvisitedItemid": 205,
"vmlastvisitedcategoryid": 62,
"vmlastvisitedmanuid": -1
}
}
Time
Memory
Time: 11.38 ms / 11.38 ms Memory: 1.787 MB / 2.15 MB Application: afterLoad
Time: 126.37 ms / 137.75 ms Memory: 10.390 MB / 12.54 MB Application: afterInitialise
Time: 30.26 ms / 168.01 ms Memory: 2.781 MB / 15.33 MB Application: afterRoute
Time: 10.77 ms / 178.78 ms Memory: 0.279 MB / 15.60 MB Application: beforeRenderComponent com_virtuemart
Time: 12.10 ms / 190.88 ms Memory: 1.028 MB / 16.63 MB Application: Before Access::preloadComponents (all components)
Time: 1.29 ms / 192.17 ms Memory: 0.077 MB / 16.71 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 192.21 ms Memory: 0.000 MB / 16.71 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.34 ms / 192.55 ms Memory: 0.026 MB / 16.73 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 0.02 ms / 192.57 ms Memory: 0.001 MB / 16.73 MB Application: Before Access::getAssetRules (id:54 name:com_virtuemart)
Time: 0.09 ms / 192.66 ms Memory: 0.039 MB / 16.77 MB Application: After Access::getAssetRules (id:54 name:com_virtuemart)
Time: 171.76 ms / 364.42 ms Memory: 8.160 MB / 24.93 MB Application: afterRenderComponent com_virtuemart
Time: 5.48 ms / 369.90 ms Memory: 0.373 MB / 25.30 MB Application: afterDispatch
Time: 30.57 ms / 400.46 ms Memory: 1.114 MB / 26.42 MB Application: beforeRenderModule mod_login (Login Form)
Time: 3.40 ms / 403.86 ms Memory: 0.054 MB / 26.47 MB Application: afterRenderModule mod_login (Login Form)
Time: 0.06 ms / 403.92 ms Memory: 0.000 MB / 26.47 MB Application: beforeRenderModule mod_menu (Footer-gk-uniersity)
Time: 3.16 ms / 407.08 ms Memory: 0.144 MB / 26.61 MB Application: afterRenderModule mod_menu (Footer-gk-uniersity)
Time: 0.06 ms / 407.15 ms Memory: 0.000 MB / 26.61 MB Application: beforeRenderModule mod_banners (Banner1)
Time: 7.27 ms / 414.41 ms Memory: 0.124 MB / 26.73 MB Application: afterRenderModule mod_banners (Banner1)
Time: 0.08 ms / 414.49 ms Memory: 0.000 MB / 26.73 MB Application: beforeRenderModule mod_menu (Header Menu)
Time: 0.83 ms / 415.32 ms Memory: 0.009 MB / 26.74 MB Application: afterRenderModule mod_menu (Header Menu)
Time: 0.05 ms / 415.37 ms Memory: 0.000 MB / 26.74 MB Application: beforeRenderModule mod_custom (Banner logo - gk university)
Time: 0.71 ms / 416.08 ms Memory: 0.006 MB / 26.74 MB Application: afterRenderModule mod_custom (Banner logo - gk university)
Time: 606.00 ms / 1022.08 ms Memory: 3.058 MB / 29.80 MB Application: afterRender
Database queries total: 102.81 ms
30.82 MB (32,313,864 Bytes)
181 Queries Logged 102.81 ms
- Query Time: 0.45 ms Query memory: 0.023 MB Memory before query: 3.878 MB Rows returned: 0
SELECT `data`
FROM `r083x_session`
WHERE `session_id` = X'6562323964373832306161656565633337386364663263653130306432386637'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.18 ms After last query: 1.16 ms Query memory: 0.020 MB Memory before query: 4.036 MB Rows returned: 0
SELECT `session_id`
FROM `r083x_session`
WHERE `session_id` = X'6562323964373832306161656565633337386364663263653130306432386637'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index No SHOW PROFILE (maybe because there are more than 100 queries)# 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 8.36 ms After last query: 0.06 ms Query memory: 0.004 MB Memory before query: 4.041 MB
INSERT INTO `r083x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6562323964373832306161656565633337386364663263653130306432386637', 1, 1631849265, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `r083x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6562323964373832306161656565633337386364663263653130306432386637', 1, 1631849265, 0, '', 0)No SHOW PROFILE (maybe because there are more than 100 queries)# 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 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:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.71 ms After last query: 2.52 ms Query memory: 0.096 MB Memory before query: 4.255 MB Rows returned: 53
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `r083x_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 r083x_extensions NULL ref extension extension 82 const 57 1.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 3.35 ms Query memory: 0.021 MB Memory before query: 4.496 MB Rows returned: 5
SELECT id, rules
FROM `r083x_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.39 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 4.508 MB Rows returned: 2
SELECT b.id
FROM r083x_usergroups AS a
LEFT JOIN r083x_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 No SHOW PROFILE (maybe because there are more than 100 queries)# 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:321 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 0.59 ms Query memory: 0.051 MB Memory before query: 4.577 MB Rows returned: 168
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM r083x_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 r083x_extensions NULL ALL extension NO INDEX KEY COULD BE USED NULL NULL 425 0.45 Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 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:359 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 25.07 ms Query memory: 0.022 MB Memory before query: 7.015 MB Rows returned: 1
SELECT `value`
FROM `r083x_admintools_storage`
WHERE `key` = 'cparams'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_admintools_storage NULL const PRIMARY PRIMARY 402 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:123 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:53 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:41 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:278 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:874 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 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:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 1.83 ms Query memory: 0.021 MB Memory before query: 7.201 MB Rows returned: 0
SELECT *
FROM `r083x_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')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 no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:592 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:503 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:883 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 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:625 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.83 ms After last query: 29.48 ms Query memory: 0.022 MB Memory before query: 9.982 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/libraries/joomla/database/driver/mysqli.php:342 11 JDatabaseDriverMysqli->getCollation() JROOT/plugins/system/admintools/feature/utf8mb4.php:28 10 AtsystemFeatureUtf8mb4->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:753 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.11 ms After last query: 0.06 ms Query memory: 0.005 MB Memory before query: 9.988 MB
SET NAMES utf8mb4 COLLATE utf8mb4_general_ciEXPLAIN not possible on query: SET NAMES utf8mb4 COLLATE utf8mb4_general_ciNo SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/plugins/system/admintools/feature/utf8mb4.php:39 10 AtsystemFeatureUtf8mb4->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:753 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 0.50 ms Query memory: 0.021 MB Memory before query: 10.022 MB Rows returned: 0
SELECT *
FROM `r083x_admintools_ipautoban`
WHERE `ip` = '3.215.177.171'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 no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/plugins/system/admintools/feature/autoipfiltering.php:74 11 AtsystemFeatureAutoipfiltering->isIPBlocked() JROOT/plugins/system/admintools/feature/autoipfiltering.php:23 10 AtsystemFeatureAutoipfiltering->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:753 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 10.027 MB Rows returned: 0
SELECT `ip`
FROM `r083x_admintools_ipblock`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 no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 12 JDatabaseDriver->loadColumn() JROOT/plugins/system/admintools/feature/ipblacklist.php:139 11 AtsystemFeatureIpblacklist->isIPBlocked() JROOT/plugins/system/admintools/feature/ipblacklist.php:33 10 AtsystemFeatureIpblacklist->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:753 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 10.033 MB Rows returned: 1
SELECT *
FROM `r083x_admintools_storage`
WHERE `key` LIKE 'timestamp_%'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_admintools_storage NULL range PRIMARY PRIMARY 402 NULL 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/feature/abstract.php:269 12 AtsystemFeatureAbstract->loadTimestamps() JROOT/plugins/system/admintools/feature/abstract.php:349 11 AtsystemFeatureAbstract->getTimestamp() JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:113 10 AtsystemFeatureDisableobsoleteadmins->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:753 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 0.66 ms Query memory: 0.021 MB Memory before query: 10.053 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `r083x_admintools_redirects`
WHERE ((`dest` = 'ecological-landscape-design-online.html') OR (`dest` = 'ecological-landscape-design-online.html') OR ('ecological-landscape-design-online.html' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id 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 no matching row in const table No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:89 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:753 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 4.69 ms Query memory: 0.022 MB Memory before query: 10.551 MB Rows returned: 1
SELECT *
FROM r083x_languages
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_sh404sef/helpers/language.php:215 12 Sh404sefHelperLanguage::getAllContentLanguages() JROOT/administrator/components/com_sh404sef/helpers/language.php:167 11 Sh404sefHelperLanguage::getUrlCodeFromTag() JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84 10 Sh404sefClassPageinfo->setCurrentLanguage() JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100 9 Sh404sefClassPageinfo->init() JROOT/plugins/system/sh404sef/sh404sef.php:63 8 plgSystemSh404sef->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.69 ms After last query: 0.98 ms Query memory: 0.165 MB Memory before query: 10.625 MB Rows returned: 139
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 r083x_menu AS m
LEFT JOIN r083x_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 415 6.96 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 gaiacollege_joomla30.m.component_id 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 19 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() 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/Menu/SiteMenu.php:101 16 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 15 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 14 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 13 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 12 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 11 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:130 10 Sh404sefClassPageinfo->loadHomepages() JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:102 9 Sh404sefClassPageinfo->init() JROOT/plugins/system/sh404sef/sh404sef.php:63 8 plgSystemSh404sef->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 8.71 ms Query memory: 0.023 MB Memory before query: 11.938 MB Rows returned: 1
SELECT `params`
FROM r083x_extensions
WHERE `element`='com_sh404sef'
AND `type`='component';id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714 14 ShlDbClass->loadResult() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363 13 ShlDbClass->shlLoadResult() JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 12 ShlDbHelper::selectResult() JROOT/administrator/components/com_sh404sef/helpers/general.php:160 11 Sh404sefHelperGeneral::getComponentParams() JROOT/administrator/components/com_sh404sef/classes/config.php:641 10 Sh404sefClassConfig->__construct() JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121 9 Sh404sefFactory::getConfig() JROOT/plugins/system/sh404sef/sh404sef.php:86 8 plgSystemSh404sef->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:626 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.63 ms After last query: 19.11 ms Query memory: 0.024 MB Memory before query: 14.157 MB Rows returned: 0
SELECT *
FROM `r083x_sh404sef_aliases`
WHERE `state` = 1
and (`alias` = 'https://gaiacollege.net/ecological-landscape-design-online.html')
order by `ordering` ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_sh404sef_aliases NULL ref alias,state alias 767 const 1 99.21 Using index condition; Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 16 ShlDbClass->loadObject() JROOT/administrator/components/com_sh404sef/models/redirector.php:218 15 Sh404sefModelRedirector->findHardcodedMatchedRules() JROOT/administrator/components/com_sh404sef/models/redirector.php:115 14 Sh404sefModelRedirector->loadMatchRules() JROOT/administrator/components/com_sh404sef/models/redirector.php:86 13 Sh404sefModelRedirector->__construct() JROOT/administrator/components/com_sh404sef/sh404seffactory.php:188 12 Sh404sefFactory::getRedirector() JROOT/administrator/components/com_sh404sef/classes/router.php:582 11 Sh404sefClassRouterInternal->_checkAliases() JROOT/administrator/components/com_sh404sef/classes/router.php:235 10 Sh404sefClassRouterInternal->preprocessParseRule() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 8 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 7 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:212 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 14.164 MB Rows returned: 0
SELECT *
FROM r083x_sh404sef_aliases
WHERE state = 1
and (type = 1 or type = 2);id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_sh404sef_aliases NULL range type,state type 1 NULL 2 99.21 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:688 18 ShlDbClass->loadObjectList() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:470 17 ShlDbClass->shlLoadObjectList() JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686 16 ShlDbHelper::selectObjectList() JROOT/administrator/components/com_sh404sef/models/redirector.php:271 15 Sh404sefModelRedirector->findWildcardMatchedRules() JROOT/administrator/components/com_sh404sef/models/redirector.php:116 14 Sh404sefModelRedirector->loadMatchRules() JROOT/administrator/components/com_sh404sef/models/redirector.php:86 13 Sh404sefModelRedirector->__construct() JROOT/administrator/components/com_sh404sef/sh404seffactory.php:188 12 Sh404sefFactory::getRedirector() JROOT/administrator/components/com_sh404sef/classes/router.php:582 11 Sh404sefClassRouterInternal->_checkAliases() JROOT/administrator/components/com_sh404sef/classes/router.php:235 10 Sh404sefClassRouterInternal->preprocessParseRule() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 8 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 7 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:212 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 14.178 MB Rows returned: 1
SELECT *
FROM r083x_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 17 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/administrator/components/com_sh404sef/classes/router.php:1527 16 Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode() JROOT/administrator/components/com_sh404sef/classes/router.php:1497 15 Sh404sefClassRouterInternal->_isSimpleEncodingSef() JROOT/administrator/components/com_sh404sef/classes/router.php:1446 14 Sh404sefClassRouterInternal->_lookupSef() JROOT/administrator/components/com_sh404sef/classes/router.php:1167 13 Sh404sefClassRouterInternal->_parseSefRouteInternal() JROOT/administrator/components/com_sh404sef/classes/router.php:1992 12 Sh404sefClassRouter->_parseSefRoute() JROOT/administrator/components/com_sh404sef/classes/router.php:362 11 Sh404sefClassRouterInternal->parseRule() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.55 ms After last query: 1.23 ms Query memory: 0.029 MB Memory before query: 14.343 MB Rows returned: 34
SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank`
FROM r083x_sh404sef_urls
WHERE `oldurl`='ecological-landscape-design-online.html'
ORDER BY `rank`;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_sh404sef_urls NULL ref oldurl oldurl 767 const 16 100.00 Using index condition; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:688 18 ShlDbClass->loadObjectList() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:470 17 ShlDbClass->shlLoadObjectList() JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686 16 ShlDbHelper::selectObjectList() JROOT/administrator/components/com_sh404sef/models/sefurls.php:103 15 Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase() JROOT/administrator/components/com_sh404sef/classes/router.php:1458 14 Sh404sefClassRouterInternal->_lookupSef() JROOT/administrator/components/com_sh404sef/classes/router.php:1167 13 Sh404sefClassRouterInternal->_parseSefRouteInternal() JROOT/administrator/components/com_sh404sef/classes/router.php:1992 12 Sh404sefClassRouter->_parseSefRoute() JROOT/administrator/components/com_sh404sef/classes/router.php:362 11 Sh404sefClassRouterInternal->parseRule() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.38 ms After last query: 0.52 ms Query memory: 0.008 MB Memory before query: 14.378 MB
UPDATE `r083x_sh404sef_urls`
SET `cpt`=30989, `last_hit`='2021-09-17 03:27:45'
WHERE `id`='766'
AND `rank`=0;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE r083x_sh404sef_urls NULL range PRIMARY,rank PRIMARY 4 const 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41 17 ShlSystem_Abstractdecorator->__call() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:499 16 ShlDbClass->shlExecute() JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:488 15 ShlDbClass->shlQuery() JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797 14 ShlDbHelper::update() JROOT/administrator/components/com_sh404sef/classes/router.php:1183 13 Sh404sefClassRouterInternal->_parseSefRouteInternal() JROOT/administrator/components/com_sh404sef/classes/router.php:1992 12 Sh404sefClassRouter->_parseSefRoute() JROOT/administrator/components/com_sh404sef/classes/router.php:362 11 Sh404sefClassRouterInternal->parseRule() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:593 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1074 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.63 ms After last query: 2.43 ms Query memory: 0.021 MB Memory before query: 14.590 MB Rows returned: 1
SELECT *
FROM `r083x_admintools_wafblacklists`
WHERE `verb` IN('','GET')
AND `option` IN('','com_virtuemart')
AND `view` IN('','category')
AND `task` IN('','category.')
AND `enabled` = '1'
GROUP BY `query`
ORDER BY `query` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_admintools_wafblacklists NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 33.33 Using where; Using temporary; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/admintools/feature/wafblacklist.php:87 10 AtsystemFeatureWafblacklist->onAfterRoute() JROOT/plugins/system/admintools/admintools/main.php:753 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:145 8 plgSystemAdmintools->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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.76 ms After last query: 6.43 ms Query memory: 0.023 MB Memory before query: 15.268 MB Rows returned: 5
SELECT a.*
FROM `r083x_snippets` AS `a`
WHERE ( `a`.`published` IN ( 0,1,2 ) )
ORDER BY a.published asc, a.ordering ascid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 50.00 Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_snippets/models/list.php:177 12 SnippetsModelList->getItems() JROOT/plugins/system/snippets/helper.php:74 11 PlgSystemSnippetsHelper->__construct() JROOT/plugins/system/nnframework/helpers/helper.php:40 10 NNFrameworkHelper::getPluginHelper() JROOT/plugins/system/snippets/snippets.php:114 9 PlgSystemSnippets->getHelper() JROOT/plugins/system/snippets/snippets.php:28 8 PlgSystemSnippets->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:1122 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 1.81 ms Query memory: 0.022 MB Memory before query: 15.360 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `r083x_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE r083x_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 6.99 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 15.351 MB
UPDATE `r083x_extensions`
SET `params` = '{\"mediaversion\":\"c5b9d79da35736a113c9c2ffeb592819\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE r083x_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.64 ms After last query: 1.75 ms Query memory: 0.019 MB Memory before query: 15.589 MB Rows returned: 5
SELECT id, home, template, s.params
FROM r083x_template_styles as s
LEFT JOIN r083x_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 ALL idx_template,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 6 83.33 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension element_clientid 403 gaiacollege_joomla30.s.template,const 1 4.44 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 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:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.66 ms After last query: 10.27 ms Query memory: 0.021 MB Memory before query: 16.569 MB Rows returned: 1
SHOW TABLES LIKE "r083x_virtuemart_configs"
EXPLAIN not possible on query: SHOW TABLES LIKE "r083x_virtuemart_configs"No SHOW PROFILE (maybe because there are more than 100 queries)# Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:701 9 VmTable::checkTableExists()