Message for screen reader users

Welcome, If you are using a screen reader we recommend switching to "Full Access Mode". This mode is designed to help different types of navigation:

Each page is divided into sections and each section is described by a title (headings navigation).
The most important sections are assigned to a role (landmark navigation).
On the top of each page you will find the quick links menu (internal link navigation). Each link is assigned to an accesskey (keyboard shortcut).

Jump to main content

Top

Layout:

Legibility:

Layout width:

Top

Close x

Ready to do a quiz?

We trust you are enjoying using the training tools – or maybe you are about to start - either way this section is where you find out everything you need to know about doing the quizzes within the training. Once you've read through a training module, click on a link below to start the quiz for that module:

Would you like more information?

Whilst it is perfectly ok to just study the learning modules without doing the assessment - or even dip in here and there or find an answer to a question - we feel there is considerable learning benefit in attempting the assessment for each module that you are interested in. Doing the assessment cements your understanding of a topic – or the whole course – and since there is no limit to the number of times you can do it, it can be used to revise your understanding at any time. All the answers for the quiz are based on the course material, which you can revisit at any time, so there is no 'exam' pressure - this is about learning at your own pace.

How does it work?

1. Study a module at your leisure and when you think you are ready, click 'assessment' on the side bar menu (or find it via the 'quiz' menu item on top right of your screen)
2. Proceed through each section answering the questions (you are always looking for the one item in the list that is incorrect).
3. All the answers for the quiz are based on the course material, which you can revisit at any time, so there is no 'exam' pressure - this is about learning at your own pace.
4. At the end of each quiz you will be asked to 'Leave your contact details to get your results'.
5. Email address only is required to get your test results, but if you like to leave your name and number we can call you to add you to our 'friends' page and promote your business for free on our social media.
6. Your results and the correct answers will arrive shortly in your email inbox and you can perform a self-assessment to see how you went.
7. If you wish to do the assessment again, you will see that the system has returned you to the start of the questions. Just proceed through the above steps again.

Become a friend and get free promotion for your business.

We are currently running an exciting campaign where we are offering to promote your business for free! For more information on how to get involved, go to our promotion page.

For more help on how to complete the quiz click here.

**0 out of 11 questions answered** 0% completed

Social Media: Question 1

1. Which of the following are included in social media?

Facebook
Blog Posts
YouTube
Your web site
Twitter
Instagram

Congratulations!

You've completed the quiz.

Now you can:

> Proceed to next module 'Using The Cloud'

> Redo the Quiz

Visit another part of our site – click any of the menu items

Top

Top. Jump to top of the page.

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685742486,
                "last": 1685742486,
                "now": 1685742486
            },
            "token": "iJzLdrnZrQGGCEESug04DuGgbWiwafYi"
        },
        "registry": {
            "com_communityquiz": {
                "response": {
                    "317757": {
                        "id": 317757,
                        "created": "2023-06-02 21:48:06",
                        "rating": 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
        },
        "com_rsfirewall": {
            "geoip": ""
        },
        "com_communityquiz": {
            "question_numbering_map": {
                "8": {
                    "140": 1
                }
            }
        }
    }
}

Profile Information

Time

Memory

**Time**: 11.59 ms / 11.59 ms **Memory**: 0.552 MB / 0.94 MB Application: afterLoad

**Time**: 67.30 ms / 78.89 ms **Memory**: 4.356 MB / 5.29 MB Application: afterInitialise

**Time**: 21.81 ms / 100.70 ms **Memory**: 1.613 MB / 6.91 MB Application: afterRoute

**Time**: 9.21 ms / 109.91 ms **Memory**: 0.315 MB / 7.22 MB Application: beforeRenderComponent com_content

**Time**: 4.02 ms / 113.93 ms **Memory**: 0.217 MB / 7.44 MB Application: Before JAccess::preloadComponents (all components)

**Time**: 1.54 ms / 115.47 ms **Memory**: 0.059 MB / 7.50 MB Application: After JAccess::preloadComponents (all components)

**Time**: 0.07 ms / 115.54 ms **Memory**: 0.000 MB / 7.50 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

**Time**: 0.56 ms / 116.10 ms **Memory**: 0.025 MB / 7.52 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

**Time**: 55.68 ms / 171.78 ms **Memory**: 3.538 MB / 11.06 MB Application: Before JAccess::getAssetRules (id:1897 name:com_communityquiz)

**Time**: 0.07 ms / 171.85 ms **Memory**: 0.010 MB / 11.07 MB Application: After JAccess::getAssetRules (id:1897 name:com_communityquiz)

**Time**: 4.79 ms / 176.64 ms **Memory**: 0.197 MB / 11.26 MB Application: Before JAccess::preloadPermissions (com_communityquiz)

**Time**: 1.52 ms / 178.15 ms **Memory**: 0.020 MB / 11.28 MB Application: After JAccess::preloadPermissions (com_communityquiz)

**Time**: 0.03 ms / 178.18 ms **Memory**: 0.000 MB / 11.28 MB Application: Before JAccess::getAssetRules (id:1921 name:com_communityquiz.quiz.8)

**Time**: 0.07 ms / 178.25 ms **Memory**: 0.009 MB / 11.29 MB Application: After JAccess::getAssetRules (id:1921 name:com_communityquiz.quiz.8)

**Time**: 94.87 ms / 273.12 ms **Memory**: 0.622 MB / 11.91 MB Application: beforeRenderModule mod_custom (Quiz help)

**Time**: 1.21 ms / 274.34 ms **Memory**: 0.025 MB / 11.94 MB Application: afterRenderModule mod_custom (Quiz help)

**Time**: 0.86 ms / 275.20 ms **Memory**: 0.003 MB / 11.94 MB Application: beforeRenderModule mod_custom (Quiz message )

**Time**: 0.35 ms / 275.54 ms **Memory**: 0.004 MB / 11.95 MB Application: afterRenderModule mod_custom (Quiz message )

**Time**: 10.01 ms / 285.55 ms **Memory**: 0.365 MB / 12.31 MB Application: Before JAccess::getAssetRules (id:18 name:com_modules)

**Time**: 0.07 ms / 285.62 ms **Memory**: 0.007 MB / 12.32 MB Application: After JAccess::getAssetRules (id:18 name:com_modules)

**Time**: 0.31 ms / 285.94 ms **Memory**: 0.001 MB / 12.32 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)

**Time**: 0.02 ms / 285.96 ms **Memory**: 0.002 MB / 12.32 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

**Time**: 0.28 ms / 286.23 ms **Memory**: 0.001 MB / 12.32 MB Application: Before JAccess::getAssetRules (id:7 name:com_contact)

**Time**: 0.06 ms / 286.29 ms **Memory**: 0.007 MB / 12.33 MB Application: After JAccess::getAssetRules (id:7 name:com_contact)

**Time**: 0.87 ms / 287.16 ms **Memory**: 0.004 MB / 12.33 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

**Time**: 0.05 ms / 287.21 ms **Memory**: 0.007 MB / 12.34 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

**Time**: 2.12 ms / 289.33 ms **Memory**: 0.036 MB / 12.38 MB Application: Before JAccess::preloadPermissions (com_content)

**Time**: 1.99 ms / 291.32 ms **Memory**: 0.361 MB / 12.74 MB Application: After JAccess::preloadPermissions (com_content)

**Time**: 0.09 ms / 291.41 ms **Memory**: 0.000 MB / 12.72 MB Application: Before JAccess::getAssetRules (id:1492 name:com_content.category.194)

**Time**: 0.02 ms / 291.42 ms **Memory**: 0.002 MB / 12.72 MB Application: After JAccess::getAssetRules (id:1492 name:com_content.category.194)

**Time**: 0.03 ms / 291.46 ms **Memory**: 0.000 MB / 12.72 MB Application: Before JAccess::getAssetRules (id:1482 name:com_content.category.200)

**Time**: 0.07 ms / 291.53 ms **Memory**: 0.008 MB / 12.73 MB Application: After JAccess::getAssetRules (id:1482 name:com_content.category.200)

**Time**: 0.03 ms / 291.56 ms **Memory**: 0.001 MB / 12.73 MB Application: Before JAccess::getAssetRules (id:1483 name:com_content.category.202)

**Time**: 0.01 ms / 291.57 ms **Memory**: 0.004 MB / 12.73 MB Application: After JAccess::getAssetRules (id:1483 name:com_content.category.202)

**Time**: 0.02 ms / 291.58 ms **Memory**: 0.000 MB / 12.73 MB Application: Before JAccess::getAssetRules (id:1489 name:com_content.category.203)

**Time**: 0.01 ms / 291.59 ms **Memory**: 0.002 MB / 12.73 MB Application: After JAccess::getAssetRules (id:1489 name:com_content.category.203)

**Time**: 0.02 ms / 291.61 ms **Memory**: 0.000 MB / 12.73 MB Application: Before JAccess::getAssetRules (id:1484 name:com_content.category.205)

**Time**: 0.01 ms / 291.61 ms **Memory**: 0.002 MB / 12.74 MB Application: After JAccess::getAssetRules (id:1484 name:com_content.category.205)

**Time**: 0.02 ms / 291.63 ms **Memory**: 0.000 MB / 12.74 MB Application: Before JAccess::getAssetRules (id:1485 name:com_content.category.206)

**Time**: 0.01 ms / 291.64 ms **Memory**: 0.002 MB / 12.74 MB Application: After JAccess::getAssetRules (id:1485 name:com_content.category.206)

**Time**: 0.01 ms / 291.65 ms **Memory**: 0.000 MB / 12.74 MB Application: Before JAccess::getAssetRules (id:1486 name:com_content.category.207)

**Time**: 0.01 ms / 291.66 ms **Memory**: 0.002 MB / 12.74 MB Application: After JAccess::getAssetRules (id:1486 name:com_content.category.207)

**Time**: 0.01 ms / 291.67 ms **Memory**: 0.001 MB / 12.74 MB Application: Before JAccess::getAssetRules (id:1487 name:com_content.category.208)

**Time**: 0.01 ms / 291.68 ms **Memory**: 0.002 MB / 12.74 MB Application: After JAccess::getAssetRules (id:1487 name:com_content.category.208)

**Time**: 0.01 ms / 291.69 ms **Memory**: 0.000 MB / 12.74 MB Application: Before JAccess::getAssetRules (id:1488 name:com_content.category.209)

**Time**: 0.01 ms / 291.70 ms **Memory**: 0.002 MB / 12.74 MB Application: After JAccess::getAssetRules (id:1488 name:com_content.category.209)

**Time**: 0.05 ms / 291.75 ms **Memory**: 0.000 MB / 12.74 MB Application: Before JAccess::getAssetRules (id:1493 name:com_content.category.211)

**Time**: 0.01 ms / 291.76 ms **Memory**: 0.002 MB / 12.75 MB Application: After JAccess::getAssetRules (id:1493 name:com_content.category.211)

**Time**: 0.02 ms / 291.79 ms **Memory**: 0.001 MB / 12.75 MB Application: Before JAccess::getAssetRules (id:1727 name:com_content.category.216)

**Time**: 0.06 ms / 291.84 ms **Memory**: 0.007 MB / 12.75 MB Application: After JAccess::getAssetRules (id:1727 name:com_content.category.216)

**Time**: 0.02 ms / 291.86 ms **Memory**: 0.000 MB / 12.75 MB Application: Before JAccess::getAssetRules (id:1729 name:com_content.category.217)

**Time**: 0.01 ms / 291.87 ms **Memory**: 0.002 MB / 12.76 MB Application: After JAccess::getAssetRules (id:1729 name:com_content.category.217)

**Time**: 0.01 ms / 291.88 ms **Memory**: 0.000 MB / 12.76 MB Application: Before JAccess::getAssetRules (id:1733 name:com_content.category.218)

**Time**: 0.01 ms / 291.89 ms **Memory**: 0.002 MB / 12.76 MB Application: After JAccess::getAssetRules (id:1733 name:com_content.category.218)

**Time**: 0.01 ms / 291.90 ms **Memory**: 0.000 MB / 12.76 MB Application: Before JAccess::getAssetRules (id:1788 name:com_content.category.219)

**Time**: 0.01 ms / 291.91 ms **Memory**: 0.002 MB / 12.76 MB Application: After JAccess::getAssetRules (id:1788 name:com_content.category.219)

**Time**: 0.02 ms / 291.93 ms **Memory**: 0.000 MB / 12.76 MB Application: Before JAccess::getAssetRules (id:1797 name:com_content.category.220)

**Time**: 0.01 ms / 291.93 ms **Memory**: 0.002 MB / 12.76 MB Application: After JAccess::getAssetRules (id:1797 name:com_content.category.220)

**Time**: 0.01 ms / 291.95 ms **Memory**: 0.000 MB / 12.76 MB Application: Before JAccess::getAssetRules (id:1805 name:com_content.category.221)

**Time**: 0.01 ms / 291.96 ms **Memory**: 0.002 MB / 12.76 MB Application: After JAccess::getAssetRules (id:1805 name:com_content.category.221)

**Time**: 0.01 ms / 291.97 ms **Memory**: 0.000 MB / 12.76 MB Application: Before JAccess::getAssetRules (id:1872 name:com_content.category.222)

**Time**: 0.01 ms / 291.98 ms **Memory**: 0.002 MB / 12.77 MB Application: After JAccess::getAssetRules (id:1872 name:com_content.category.222)

**Time**: 3.64 ms / 295.62 ms **Memory**: 0.037 MB / 12.80 MB Application: Before JAccess::getAssetRules (id:15 name:com_media)

**Time**: 0.06 ms / 295.69 ms **Memory**: 0.008 MB / 12.81 MB Application: After JAccess::getAssetRules (id:15 name:com_media)

**Time**: 2.95 ms / 298.64 ms **Memory**: 0.000 MB / 12.79 MB Application: afterRenderComponent com_content

**Time**: 0.52 ms / 299.16 ms **Memory**: 0.015 MB / 12.81 MB Application: afterDispatch

**Time**: 36.17 ms / 335.33 ms **Memory**: 0.807 MB / 13.62 MB Application: beforeRenderModule mod_menu (footer menu)

**Time**: 3.21 ms / 338.54 ms **Memory**: 0.085 MB / 13.70 MB Application: afterRenderModule mod_menu (footer menu)

**Time**: 0.08 ms / 338.62 ms **Memory**: 0.000 MB / 13.70 MB Application: beforeRenderModule mod_menu (Subnavigation for Kits)

**Time**: 3.95 ms / 342.57 ms **Memory**: 0.276 MB / 13.97 MB Application: afterRenderModule mod_menu (Subnavigation for Kits)

**Time**: 0.08 ms / 342.65 ms **Memory**: 0.000 MB / 13.96 MB Application: beforeRenderModule mod_menu (Main Menu)

**Time**: 2.30 ms / 344.95 ms **Memory**: 0.068 MB / 14.03 MB Application: afterRenderModule mod_menu (Main Menu)

**Time**: 0.07 ms / 345.01 ms **Memory**: 0.000 MB / 14.01 MB Application: beforeRenderModule mod_finder (Smart search)

**Time**: 10.95 ms / 355.96 ms **Memory**: 0.307 MB / 14.32 MB Application: afterRenderModule mod_finder (Smart search)

**Time**: 0.08 ms / 356.04 ms **Memory**: 0.000 MB / 14.31 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

**Time**: 3.91 ms / 359.95 ms **Memory**: 0.679 MB / 14.99 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

**Time**: 14.58 ms / 374.53 ms **Memory**: 0.786 MB / 15.78 MB Application: afterRender

**Database queries total: 113.54 ms**

Memory Usage

Database Queries

54 Queries Logged 113.54 ms

4 duplicate found!

**2 duplicates**: #42 #44

**2 duplicates**: #50 #54

**Query Time: 0.55 ms** **Query memory: 0.023 MB Memory before query: 2.566 MB** **Rows returned: 0**

SELECT `data`

  FROM `jla_session`

  WHERE `session_id` = '1fc49c4487d82b2365c2c4baef716e88'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_session	const	PRIMARY	PRIMARY	766	const	1

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.39 ms** **After last query: 1.29 ms** **Query memory: 0.019 MB Memory before query: 2.647 MB** **Rows returned: 0**

SELECT `session_id`

  FROM `jla_session`

  WHERE `session_id` = '1fc49c4487d82b2365c2c4baef716e88' 
  LIMIT 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_session	const	PRIMARY	PRIMARY	766	const	1	Using index

**Profile**

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.57 ms** **After last query: 0.10 ms** **Query memory: 0.003 MB Memory before query: 2.652 MB**

INSERT INTO `jla_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('1fc49c4487d82b2365c2c4baef716e88', 1, '1685742486', 0, '', 0)

**Explain**

**EXPLAIN not possible on query: INSERT INTO `jla_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('1fc49c4487d82b2365c2c4baef716e88', 1, '1685742486', 0, '', 0)**

**Profile**

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.02 ms
Update	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.20 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.74 ms** **After last query: 2.64 ms** **Query memory: 0.040 MB Memory before query: 2.823 MB** **Rows returned: 42**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jla_extensions`

  WHERE `type` = 'component'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_extensions	ref	extension	extension	82	const	42	Using index condition

**Profile**

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.58 ms** **After last query: 3.13 ms** **Query memory: 0.021 MB Memory before query: 3.003 MB** **Rows returned: 1**

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 = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.42 ms** **After last query: 0.74 ms** **Query memory: 0.021 MB Memory before query: 3.049 MB** **Rows returned: 5**

SELECT id, rules

  FROM `jla_viewlevels`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

**Profile**

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.08 ms** **After last query: 0.14 ms** **Query memory: 0.030 MB Memory before query: 3.076 MB** **Rows returned: 94**

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM jla_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_extensions	ref	extension	extension	82	const	118	Using index condition; Using where; Using filesort

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.59 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.48 ms** **After last query: 9.51 ms** **Query memory: 0.021 MB Memory before query: 3.873 MB** **Rows returned: 0**

SELECT `path`

  FROM jla_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_rsfirewall_ignored	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:52
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.37 ms** **After last query: 0.07 ms** **Query memory: 0.021 MB Memory before query: 3.880 MB** **Rows returned: 0**

SELECT `file`

  FROM jla_rsfirewall_hashes

  WHERE `type`='protect'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where

**Profile**

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:59
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.40 ms** **After last query: 0.06 ms** **Query memory: 0.024 MB Memory before query: 3.885 MB** **Rows returned: 48**

SELECT *

  FROM jla_rsfirewall_configuration

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_rsfirewall_configuration	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	48

**Profile**

Status	Duration
Starting	0.02 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:67
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:25
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.28 ms** **After last query: 7.01 ms** **Query memory: 0.024 MB Memory before query: 4.346 MB** **Rows returned: 10**

SHOW FULL COLUMNS 
  FROM `jla_rsfirewall_logs`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jla_rsfirewall_logs`**

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.52 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.08 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:35
11	RSFirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:22
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:56
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:46
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 2.45 ms** **After last query: 15.93 ms** **Query memory: 0.258 MB Memory before query: 5.525 MB** **Rows returned: 200**

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.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	220	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	staging2016_butterfly.m.component_id	1	Using where

**Profile**

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.60 ms
End of update loop	0.03 ms
Query end	0.05 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1141
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.69 ms** **After last query: 12.36 ms** **Query memory: 0.020 MB Memory before query: 6.751 MB** **Rows returned: 0**

SELECT *

  FROM jla_rsfirewall_hashes

  WHERE (`type`='3.7.2' OR `type`='protect') 
  AND `flag`!='C'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where

**Profile**

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.06 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:856
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/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.40 ms** **After last query: 0.43 ms** **Query memory: 0.021 MB Memory before query: 6.839 MB** **Rows returned: 0**

SELECT *

  FROM jla_rsfirewall_snapshots

  WHERE `type`='protect'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_rsfirewall_snapshots	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

**Profile**

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:46
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:879
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/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.44 ms** **After last query: 0.08 ms** **Query memory: 0.021 MB Memory before query: 6.845 MB** **Rows returned: 0**

SELECT `ip`,`reason`

  FROM jla_rsfirewall_lists

  WHERE (`ip`='3.233.219.103' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_rsfirewall_lists	ALL	published,type	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where

**Profile**

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:164
10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:143
9	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:907
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/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.47 ms** **After last query: 0.06 ms** **Query memory: 0.021 MB Memory before query: 6.851 MB** **Rows returned: 0**

SELECT `ip`,`reason`

  FROM jla_rsfirewall_lists

  WHERE (`ip`='3.233.219.103' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_rsfirewall_lists	ref	published,type	type	1	const	1	Using where

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:164
10	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:133
9	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:911
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/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.53 ms** **After last query: 1.05 ms** **Query memory: 0.021 MB Memory before query: 6.904 MB** **Rows returned: 0**

SELECT *

  FROM jla_rsfirewall_exceptions

  WHERE `published`='1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_rsfirewall_exceptions	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

**Profile**

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:549
9	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:946
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/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.59 ms** **After last query: 1.12 ms** **Query memory: 0.022 MB Memory before query: 6.943 MB** **Rows returned: 1**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jla_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.74 ms** **After last query: 0.17 ms** **Query memory: 0.005 MB Memory before query: 6.933 MB**

UPDATE `jla_extensions`

  SET `params` = '{\"mediaversion\":\"e7c14799052e27201083f7d2970febac\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

**EXPLAIN not possible on query: UPDATE `jla_extensions` SET `params` = '{\"mediaversion\":\"e7c14799052e27201083f7d2970febac\"}' WHERE `type` = 'library' AND `element` = 'joomla'**

**Profile**

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.07 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	1.29 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.63 ms** **After last query: 3.07 ms** **Query memory: 0.019 MB Memory before query: 7.095 MB** **Rows returned: 1**

SELECT *

  FROM jla_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.04 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.78 ms** **After last query: 0.34 ms** **Query memory: 0.105 MB Memory before query: 7.107 MB** **Rows returned: 4**

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 = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	7	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	staging2016_butterfly.s.template,const	1	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.27 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.04 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.24 ms** **After last query: 5.49 ms** **Query memory: 0.028 MB Memory before query: 7.444 MB** **Rows returned: 42**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jla_assets`

  WHERE `name` IN ('com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cjlib','com_communityquiz','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_iponedata','com_jce','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsfirewall','com_search','com_sptransfer','com_spupgrade','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	43	Using sort_union(idx_asset_name,idx_parent_id); Using where

**Profile**

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.20 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.43 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.29 ms** **After last query: 1.53 ms** **Query memory: 0.031 MB Memory before query: 7.559 MB** **Rows returned: 30**

SHOW FULL COLUMNS 
  FROM `jla_content`

**Explain**

**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jla_content`**

**Profile**

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.45 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.03 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.16 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.14 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.60 ms** **After last query: 2.97 ms** **Query memory: 0.022 MB Memory before query: 7.821 MB** **Rows returned: 1**

SELECT *

  FROM jla_content

  WHERE `id` = '1137'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_content	const	PRIMARY	PRIMARY	4	const	1

**Profile**

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.58 ms** **After last query: 0.13 ms** **Query memory: 0.005 MB Memory before query: 7.828 MB**

UPDATE jla_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1137'

**Explain**

**EXPLAIN not possible on query: UPDATE jla_content SET `hits` = (`hits` + 1) WHERE `id` = '1137'**

**Profile**

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.05 ms
Updating	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.17 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
10	JTable->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.91 ms** **After last query: 1.89 ms** **Query memory: 0.023 MB Memory before query: 7.941 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 = 1137 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-02 21:48:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-02 21:48:06') 
  AND (a.state = 1 OR a.state =2)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

**Profile**

Status	Duration
Starting	0.15 ms
Checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.12 ms** **After last query: 3.06 ms** **Query memory: 0.027 MB Memory before query: 8.095 MB** **Rows returned: 2**

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 c

  LEFT JOIN jla_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=207

  GROUP BY 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

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	18	Using index condition; Using where; Using filesort

**Profile**

Status	Duration
Starting	0.15 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.08 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.05 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
19	JCategories->get()	JROOT/components/com_content/router.php:70
18	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
17	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
16	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
15	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
14	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.59 ms** **After last query: 0.51 ms** **Query memory: 0.022 MB Memory before query: 8.124 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` = 1137 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	staging2016_butterfly.m.tag_id	1	Using where

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.04 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.85 ms** **After last query: 20.55 ms** **Query memory: 0.025 MB Memory before query: 9.841 MB** **Rows returned: 0**

SELECT 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

  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 (207,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	staging2016_butterfly.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	staging2016_butterfly.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	staging2016_butterfly.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	staging2016_butterfly.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	staging2016_butterfly.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	staging2016_butterfly.a.id	1	Using where; Using index

**Profile**

Status	Duration
Starting	0.22 ms
Checking permissions	0.03 ms
Opening tables	0.13 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.08 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.53 ms
Creating sort index	0.06 ms
Removing tmp table	0.09 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
17	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.81 ms** **After last query: 18.05 ms** **Query memory: 0.025 MB Memory before query: 11.074 MB** **Rows returned: 1**

SELECT a.id, a.title, a.alias, a.description, a.responses, a.metakey, a.metadesc, a.access, a.metadata, a.language, a.ip_address, a.certificates,a.quiz_type, a.max_qns_per_page, a.qns_ordering, a.badge, a.duration, a.secret, a.cutoff, a.messages, a.max_questions, a.difficulty_level,
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, 
  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.attribs, a.ordering,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,lv.title AS level_title, lv.description AS level_description,u.name AS author,u.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM jla_quiz_quizzes AS a

  LEFT JOIN jla_categories AS c 
  on c.id = a.catid

  LEFT JOIN jla_quiz_levels AS lv 
  ON lv.id = a.difficulty_level

  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 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jla_categories AS cat JOIN jla_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_communityquiz' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 8 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-02 21:48:06') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-02 21:48:06') 
  AND (a.published = 1 OR a.published =2)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_quiz_quizzes_published	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	lv	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	<derived2>	ref	key0	key0	5	const	10
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	144	Using where; Using index; Using join buffer (flat, BNL join)

**Profile**

Status	Duration
Starting	0.20 ms
Checking permissions	0.02 ms
Opening tables	0.31 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.14 ms
Optimizing	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Statistics	0.22 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.08 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_communityquiz/models/quiz.php:132
16	CommunityQuizModelQuiz->getItem()	JROOT/plugins/content/quizzes/quizzes.php:97
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.31 ms** **After last query: 2.97 ms** **Query memory: 0.027 MB Memory before query: 11.261 MB** **Rows returned: 14**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jla_assets`

  WHERE `name` LIKE 'com_communityquiz.%' OR `name` = 'com_communityquiz' OR `parent_id` = 0

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	663	Using where

**Profile**

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.74 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.06 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
21	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
19	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
18	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
17	JUser->authorise()	JROOT/components/com_communityquiz/models/response.php:176
16	CommunityQuizModelResponse->createOrUpdateResponse()	JROOT/plugins/content/quizzes/quizzes.php:122
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.47 ms** **After last query: 0.23 ms** **Query memory: 0.024 MB Memory before query: 11.293 MB** **Rows returned: 1**

SELECT id, published, secret, attribs

  FROM jla_quiz_quizzes

  WHERE id = 8

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_quiz_quizzes	const	PRIMARY	PRIMARY	4	const	1

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/components/com_communityquiz/models/response.php:189
16	CommunityQuizModelResponse->createOrUpdateResponse()	JROOT/plugins/content/quizzes/quizzes.php:122
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.64 ms** **After last query: 1.96 ms** **Query memory: 0.010 MB Memory before query: 11.410 MB**

INSERT INTO `jla_quiz_responses`
(`quiz_id`,`created_by`,`completed`,`created`,`ip_address`) 
  VALUES 
('8','0','0','2023-06-02 21:48:06','3.233.219.103')

**Explain**

**EXPLAIN not possible on query: INSERT INTO `jla_quiz_responses` (`quiz_id`,`created_by`,`completed`,`created`,`ip_address`) VALUES ('8','0','0','2023-06-02 21:48:06','3.233.219.103')**

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.02 ms
Update	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.15 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1401
17	JDatabaseDriver->insertObject()	JROOT/components/com_communityquiz/models/response.php:259
16	CommunityQuizModelResponse->createOrUpdateResponse()	JROOT/plugins/content/quizzes/quizzes.php:122
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 66.19 ms** **After last query: 0.19 ms** **Query memory: 0.008 MB Memory before query: 11.418 MB**

UPDATE jla_quiz_quizzes

  SET responses = ( select count(*) 
  from jla_quiz_responses 
  where quiz_id = 8 )

  WHERE id = 8

**Explain**

**EXPLAIN not possible on query: UPDATE jla_quiz_quizzes SET responses = ( select count(*) from jla_quiz_responses where quiz_id = 8 ) WHERE id = 8**

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.03 ms
Optimizing	0.02 ms
Statistics	0.13 ms
Preparing	0.05 ms
Updating	0.04 ms
Executing	0.01 ms
Sending data	64.42 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	1.13 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.91 ms
Reset for next command	0.03 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/components/com_communityquiz/models/response.php:276
16	CommunityQuizModelResponse->createOrUpdateResponse()	JROOT/plugins/content/quizzes/quizzes.php:122
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.79 ms** **After last query: 13.37 ms** **Query memory: 0.008 MB Memory before query: 11.610 MB**

INSERT INTO `jla_quiz_tracking`
(`post_id`,`post_type`,`ip_address`,`country`,`city`,`os`,`browser_name`,`browser_version`,`browser_info`) 
  VALUES 
('317757','1','3.233.219.103','US','Fairfield','Unknown','Unknown','Unknown','CCBot/2.0 (https://commoncrawl.org/faq/)')

**Explain**

**EXPLAIN not possible on query: INSERT INTO `jla_quiz_tracking` (`post_id`,`post_type`,`ip_address`,`country`,`city`,`os`,`browser_name`,`browser_version`,`browser_info`) VALUES ('317757','1','3.233.219.103','US','Fairfield','Unknown','Unknown','Unknown','CCBot/2.0 (https://commoncrawl.org/faq/)')**

**Profile**

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.02 ms
Update	0.32 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.99 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1401
17	JDatabaseDriver->insertObject()	JROOT/components/com_communityquiz/models/response.php:298
16	CommunityQuizModelResponse->createOrUpdateResponse()	JROOT/plugins/content/quizzes/quizzes.php:122
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.67 ms** **After last query: 0.13 ms** **Query memory: 0.026 MB Memory before query: 11.672 MB** **Rows returned: 11**

SELECT id, title, sort_order

  FROM jla_quiz_pages

  WHERE quiz_id = 8

  ORDER BY sort_order ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_quiz_pages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	92	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.25 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_communityquiz/helpers/pagination.php:127
18	QuizPagination->build()	JROOT/components/com_communityquiz/helpers/pagination.php:46
17	QuizPagination->__construct()	JROOT/components/com_communityquiz/models/response.php:1163
16	CommunityQuizModelResponse->getPagination()	JROOT/plugins/content/quizzes/quizzes.php:125
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.85 ms** **After last query: 1.09 ms** **Query memory: 0.025 MB Memory before query: 11.733 MB** **Rows returned: 1**

SELECT a.id, a.title, a.description, a.quiz_id, a.question_type, a.page_number, a.sort_order, a.include_custom,a.mandatory, a.answer_explanation, a.orientation, 0 as total_votes, a.params

  FROM jla_quiz_questions AS a

  INNER JOIN jla_quiz_pages p 
  on p.id = a.page_number

  WHERE a.quiz_id = 8 
  AND a.page_number = 54

  ORDER BY a.quiz_id, a.sort_order asc

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	89	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.27 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
17	JModelList->getItems()	JROOT/components/com_communityquiz/models/questions.php:230
16	CommunityQuizModelQuestions->getItems()	JROOT/plugins/content/quizzes/quizzes.php:152
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.68 ms** **After last query: 0.14 ms** **Query memory: 0.025 MB Memory before query: 11.747 MB** **Rows returned: 6**

SELECT a.id, a.title, a.question_id, a.answer_type, a.responses, a.correct_answer, a.sort_order, a.image, a.marks

  FROM jla_quiz_answers AS a

  WHERE a.question_id IN (140)

  ORDER BY a.sort_order ASC

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	FK_QUIZ_QUESTIONS_QUESTION_ID	FK_QUIZ_QUESTIONS_QUESTION_ID	4	const	6	Using where; Using filesort

**Profile**

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.08 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_communityquiz/models/questions.php:263
16	CommunityQuizModelQuestions->getItems()	JROOT/plugins/content/quizzes/quizzes.php:152
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.99 ms** **After last query: 1.15 ms** **Query memory: 0.027 MB Memory before query: 11.816 MB** **Rows returned: 2**

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 c

  LEFT JOIN jla_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_communityquiz' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=225

  GROUP BY 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

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	2	Using index condition; Using where; Using filesort

**Profile**

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.09 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
20	JCategories->get()	JROOT/components/com_communityquiz/helpers/route.php:26
19	CommunityQuizHelperRoute::getQuizRoute()	JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php:22
18	include JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/components/com_communityquiz/helpers/helper.php:347
16	QuizHelper::renderLayout()	JROOT/plugins/content/quizzes/quizzes.php:174
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.72 ms** **After last query: 1.67 ms** **Query memory: 0.028 MB Memory before query: 11.909 MB** **Rows returned: 7**

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 <= '2023-06-02 21:48:06') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-02 21:48:06') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1016 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	48	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	staging2016_butterfly.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	staging2016_butterfly.m.id	7	Using where; Using index

**Profile**

Status	Duration
Starting	0.09 ms
Checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.99 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
22	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
21	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
20	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
19	JModuleHelper::getModules()	JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php:52
18	include JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/components/com_communityquiz/helpers/helper.php:347
16	QuizHelper::renderLayout()	JROOT/plugins/content/quizzes/quizzes.php:174
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.98 ms** **After last query: 14.30 ms** **Query memory: 0.028 MB Memory before query: 12.342 MB** **Rows returned: 0**

SELECT c.id AS id, a.name AS asset_name

  FROM (
SELECT id,asset_id

  FROM jla_categories

  WHERE extension = '' 
  AND published = 1) AS c

  INNER JOIN jla_assets AS a 
  ON c.asset_id = a.id

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_categories	ref	cat_idx	cat_idx	203	const,const	1	Using index condition
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	staging2016_butterfly.jla_categories.asset_id	1

**Profile**

Status	Duration
Starting	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.09 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/user/user.php:423
26	JUser->getAuthorisedCategories()	JROOT/plugins/editors-xtd/image/image.php:55
25	PlgButtonImage->onDisplay()	JROOT/libraries/cms/editor/editor.php:489
24	JEditor->getButtons()	JROOT/plugins/editors/tinymce/tinymce.php:749
23	PlgEditorTinymce->tinyButtons()	JROOT/plugins/editors/tinymce/tinymce.php:1275
22	PlgEditorTinymce->onDisplayLegacy()	JROOT/plugins/editors/tinymce/tinymce.php:154
21	PlgEditorTinymce->onDisplay()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/cms/editor/editor.php:323
19	JEditor->display()	JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php:230
18	include JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/components/com_communityquiz/helpers/helper.php:347
16	QuizHelper::renderLayout()	JROOT/plugins/content/quizzes/quizzes.php:174
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.84 ms** **After last query: 0.11 ms** **Query memory: 0.029 MB Memory before query: 12.354 MB** **Rows returned: 17**

**Duplicate queries**: #44

SELECT c.id AS id, a.name AS asset_name

  FROM (
SELECT id,asset_id

  FROM jla_categories

  WHERE extension = 'com_content' 
  AND published = 1) AS c

  INNER JOIN jla_assets AS a 
  ON c.asset_id = a.id

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_categories	ref	cat_idx	cat_idx	203	const,const	17	Using index condition
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	staging2016_butterfly.jla_categories.asset_id	1

**Profile**

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.04 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/user/user.php:423
26	JUser->getAuthorisedCategories()	JROOT/plugins/editors-xtd/image/image.php:57
25	PlgButtonImage->onDisplay()	JROOT/libraries/cms/editor/editor.php:489
24	JEditor->getButtons()	JROOT/plugins/editors/tinymce/tinymce.php:749
23	PlgEditorTinymce->tinyButtons()	JROOT/plugins/editors/tinymce/tinymce.php:1275
22	PlgEditorTinymce->onDisplayLegacy()	JROOT/plugins/editors/tinymce/tinymce.php:154
21	PlgEditorTinymce->onDisplay()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/cms/editor/editor.php:323
19	JEditor->display()	JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php:230
18	include JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/components/com_communityquiz/helpers/helper.php:347
16	QuizHelper::renderLayout()	JROOT/plugins/content/quizzes/quizzes.php:174
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 1.23 ms** **After last query: 0.19 ms** **Query memory: 0.125 MB Memory before query: 12.380 MB** **Rows returned: 368**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jla_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	663	Using where

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.70 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.08 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
31	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
30	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
29	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
28	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
27	JUser->authorise()	JROOT/libraries/joomla/user/user.php:428
26	JUser->getAuthorisedCategories()	JROOT/plugins/editors-xtd/image/image.php:57
25	PlgButtonImage->onDisplay()	JROOT/libraries/cms/editor/editor.php:489
24	JEditor->getButtons()	JROOT/plugins/editors/tinymce/tinymce.php:749
23	PlgEditorTinymce->tinyButtons()	JROOT/plugins/editors/tinymce/tinymce.php:1275
22	PlgEditorTinymce->onDisplayLegacy()	JROOT/plugins/editors/tinymce/tinymce.php:154
21	PlgEditorTinymce->onDisplay()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/cms/editor/editor.php:323
19	JEditor->display()	JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php:230
18	include JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/components/com_communityquiz/helpers/helper.php:347
16	QuizHelper::renderLayout()	JROOT/plugins/content/quizzes/quizzes.php:174
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.75 ms** **After last query: 1.39 ms** **Query memory: 0.029 MB Memory before query: 12.755 MB** **Rows returned: 17**

**Duplicate queries**: #42

SELECT c.id AS id, a.name AS asset_name

  FROM (
SELECT id,asset_id

  FROM jla_categories

  WHERE extension = 'com_content' 
  AND published = 1) AS c

  INNER JOIN jla_assets AS a 
  ON c.asset_id = a.id

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_categories	ref	cat_idx	cat_idx	203	const,const	17	Using index condition
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	staging2016_butterfly.jla_categories.asset_id	1

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.19 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.05 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.78 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/user/user.php:423
26	JUser->getAuthorisedCategories()	JROOT/plugins/editors-xtd/image/image.php:58
25	PlgButtonImage->onDisplay()	JROOT/libraries/cms/editor/editor.php:489
24	JEditor->getButtons()	JROOT/plugins/editors/tinymce/tinymce.php:749
23	PlgEditorTinymce->tinyButtons()	JROOT/plugins/editors/tinymce/tinymce.php:1275
22	PlgEditorTinymce->onDisplayLegacy()	JROOT/plugins/editors/tinymce/tinymce.php:154
21	PlgEditorTinymce->onDisplay()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/cms/editor/editor.php:323
19	JEditor->display()	JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php:230
18	include JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/components/com_communityquiz/helpers/helper.php:347
16	QuizHelper::renderLayout()	JROOT/plugins/content/quizzes/quizzes.php:174
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.57 ms** **After last query: 1.91 ms** **Query memory: 0.027 MB Memory before query: 12.777 MB** **Rows returned: 1**

SELECT template

  FROM jla_template_styles

  WHERE client_id=0 
  AND home='1'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_template_styles	ref	idx_home	idx_home	28	const	2	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.05 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	4.33 ms
Reset for next command	0.03 ms

**Call Stack**

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
23	JDatabaseDriver->loadResult()	JROOT/plugins/editors/tinymce/tinymce.php:1363
22	PlgEditorTinymce->onDisplayLegacy()	JROOT/plugins/editors/tinymce/tinymce.php:154
21	PlgEditorTinymce->onDisplay()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/cms/editor/editor.php:323
19	JEditor->display()	JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php:230
18	include JROOT/templates/portal/html/layouts/com_communityquiz/default/quiz/form.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/components/com_communityquiz/helpers/helper.php:347
16	QuizHelper::renderLayout()	JROOT/plugins/content/quizzes/quizzes.php:174
15	PlgContentQuizzes->{closure}()	*Same as call in the line below.*
14	preg_replace_callback()	JROOT/plugins/content/quizzes/quizzes.php:177
13	PlgContentQuizzes->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:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.87 ms** **After last query: 51.67 ms** **Query memory: 0.022 MB Memory before query: 14.079 MB** **Rows returned: 6**

SELECT `name`,`element`

  FROM `jla_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'finder' 
  AND `enabled` = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_extensions	ref	extension	extension	82	const	118	Using index condition; Using where

**Profile**

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.18 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:125
11	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.56 ms** **After last query: 3.59 ms** **Query memory: 0.023 MB Memory before query: 14.245 MB** **Rows returned: 1**

SELECT f.data, f.params

  FROM `jla_finder_filters` AS f

  WHERE f.filter_id = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	const	PRIMARY	PRIMARY	4	const	1

**Profile**

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:498
13	FinderIndexerQuery->processStaticTaxonomy()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:214
12	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:86
11	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.48 ms** **After last query: 0.11 ms** **Query memory: 0.023 MB Memory before query: 14.254 MB** **Rows returned: 1**

SELECT t1.id, t1.title, t2.title AS branch

  FROM `jla_finder_taxonomy` AS t1

  INNER JOIN `jla_finder_taxonomy` AS t2 
  ON t2.id = t1.parent_id

  WHERE t1.state = 1 
  AND t1.access IN (1,1) 
  AND t1.id IN (11) 
  AND t2.state = 1 
  AND t2.access IN (1,1)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	const	PRIMARY,parent_id,state,access,idx_parent_published	PRIMARY	4	const	1
1	SIMPLE	t2	const	PRIMARY,state,access	PRIMARY	4	const	1

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:553
13	FinderIndexerQuery->processStaticTaxonomy()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:214
12	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:86
11	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.51 ms** **After last query: 0.64 ms** **Query memory: 0.023 MB Memory before query: 14.305 MB** **Rows returned: 3**

SELECT `title`

  FROM `jla_finder_taxonomy`

  WHERE `parent_id` = 1 
  AND `state` = 1 
  AND `access` IN (1,1)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_finder_taxonomy	range	parent_id,state,access,idx_parent_published	idx_parent_published	6	NULL	3	Using index condition

**Profile**

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
14	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:749
13	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
12	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:86
11	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.49 ms** **After last query: 3.42 ms** **Query memory: 0.025 MB Memory before query: 14.353 MB** **Rows returned: 1**

**Duplicate queries**: #54

SELECT `alias`

  FROM `jla_content`

  WHERE id = '1137'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_content	const	PRIMARY	PRIMARY	4	const	1

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
20	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:123
19	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_breadcrumbs/helper.php:56
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.67 ms** **After last query: 0.12 ms** **Query memory: 0.026 MB Memory before query: 14.366 MB** **Rows returned: 0**

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 c

  LEFT JOIN jla_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=1137

  GROUP BY 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

  ORDER BY c.lft

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

**Profile**

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Executing	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

**Call Stack**

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
20	JCategories->get()	JROOT/components/com_content/router.php:70
19	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_breadcrumbs/helper.php:56
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.49 ms** **After last query: 2.26 ms** **Query memory: 0.022 MB Memory before query: 15.074 MB** **Rows returned: 0**

SELECT *
 
  FROM jla_jmap_metainfo
 
  WHERE `linkurl` = 'http://digitalready.org.au/training/social-media/assessment-sm'
 
  AND `published` = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_jmap_metainfo	ref	linkurl,published	linkurl	767	const	1	Using where

**Profile**

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
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/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:63
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.71 ms** **After last query: 9.65 ms** **Query memory: 0.032 MB Memory before query: 15.546 MB** **Rows returned: 154**

SELECT * 
  FROM jla_acymailing_config

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_acymailing_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	154

**Profile**

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.15 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:454
9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1127
8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

**Query Time: 0.50 ms** **After last query: 1.74 ms** **Query memory: 0.024 MB Memory before query: 15.764 MB** **Rows returned: 1**

**Duplicate queries**: #50

SELECT `alias`

  FROM `jla_content`

  WHERE id = '1137'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jla_content	const	PRIMARY	PRIMARY	4	const	1

**Profile**

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

**Call Stack**

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:123
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	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/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

**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 c 
  LEFT JOIN jla_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)**

**3 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jla_assets`**

**3 × SELECT c.id AS id, a.name AS asset_name 
  FROM ( SELECT id,asset_id 
  FROM jla_categories**

**2 × SELECT `ip`,`reason` 
  FROM jla_rsfirewall_lists**

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `jla_extensions`**

**2 × SELECT `alias` 
  FROM `jla_content`**

**1 × SELECT *  
  FROM jla_jmap_metainfo**

**1 × SELECT a.id, a.title, a.alias, a.description, a.responses, a.metakey, a.metadesc, a.access, a.metadata, a.language, a.ip_address, a.certificates,a.quiz_type, a.max_qns_per_page, a.qns_ordering, a.badge, a.duration, a.secret, a.cutoff, a.messages, a.max_questions, a.difficulty_level,
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, 
  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.attribs, a.ordering,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,lv.title AS level_title, lv.description AS level_description,u.name AS author,u.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM jla_quiz_quizzes AS a 
  LEFT JOIN jla_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jla_quiz_levels AS lv 
  ON lv.id = a.difficulty_level 
  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 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jla_categories AS cat JOIN jla_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt**

**1 × SELECT id, published, secret, attribs 
  FROM jla_quiz_quizzes**

**1 × SELECT id, title, sort_order 
  FROM jla_quiz_pages**

**1 × SELECT a.id, a.title, a.description, a.quiz_id, a.question_type, a.page_number, a.sort_order, a.include_custom,a.mandatory, a.answer_explanation, a.orientation, 0 as total_votes, a.params 
  FROM jla_quiz_questions AS a 
  INNER JOIN jla_quiz_pages p 
  on p.id = a.page_number**

**1 × SELECT a.id, a.title, a.question_id, a.answer_type, a.responses, a.correct_answer, a.sort_order, a.image, a.marks 
  FROM jla_quiz_answers AS a**

**1 × 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**

**1 × SELECT 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 
  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**

**1 × SELECT template 
  FROM jla_template_styles**

**1 × SELECT `name`,`element` 
  FROM `jla_extensions`**

**1 × SELECT f.data, f.params 
  FROM `jla_finder_filters` AS f**

**1 × SELECT t1.id, t1.title, t2.title AS branch 
  FROM `jla_finder_taxonomy` AS t1 
  INNER JOIN `jla_finder_taxonomy` AS t2 
  ON t2.id = t1.parent_id**

**1 × SELECT `title` 
  FROM `jla_finder_taxonomy`**

**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_o

Layout:

Font size:

Legibility:

Layout width:

Digital Skills Training

Social Media

Ready to do a quiz?

Would you like more information?

How does it work?

Become a friend and get free promotion for your business.

Please wait..

Message for screen reader users

Toolbox

Accessibility options

Layout:

Font size:

Legibility:

Layout width:

Search

Main content

Alert message

Social Media

Ready to do a quiz?

Would you like more information?

How does it work?

Become a friend and get free promotion for your business.

**Please wait..**

**Joomla! Debug Console**

**Session**

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**54 Queries Logged** 113.54 ms

**4 duplicate found!**

**45 Query Types Logged, Sorted by Occurrences.**

**SELECT Tables:**

Please wait..

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

54 Queries Logged 113.54 ms

4 duplicate found!

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables: