Social Care

Social Worker
Care Assistanst
Support Workers
And many other services

Commercial

Administration
Call Centre / Customer Service
Industry
IT
And many other services

Industrial

Driving
Warehouse
Cleaning
Machine Operators
And many other services

Bettter Care Starts with You!

CAREGIVER JOBS

Client Testimonials

"It has been a great pleasure to be working with Hayes-Staff.

For the last 5 years the team at Hayes have been providing us with both long, medium and short term staff members of a very high quality and reliability

The training that Hayes-Staff provide to their staff has meant that each person has been able to step into our organisation confidently and become part of our team from day one.

The client focused approach of all the Management Team at Hayes means that we are offered staff who are an excellent match to the needs and ethos of our organisation"

Catherine T

Read more....

Christmas Time-sheets and Payroll

Christmas is just around the corner, so we want to give you plenty of notice of the Christmas Payroll information

Find out more...

Call us today
Hayes: 0208 569 2662
Watford: 01923 229 227

Email: care@hayes-staff.co.uk

Facebook

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1537399256,
                "last": 1537399256,
                "now": 1537399256
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Memory Usage

Database Queries

19 Queries Logged 15.61 ms

Query Time: 0.70 ms Query memory: 0.017 MB Memory before query: 2.421 MB Rows returned: 0

SELECT `data`

  FROM `jos3_session`

  WHERE `session_id` = 'r4l5a8ta0dfbikc068nsbpd1r2'

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.02 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
System lock	0.02 ms
Waiting for query cache lock	0.05 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
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:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	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: 1.59 ms Query memory: 0.010 MB Memory before query: 2.572 MB Rows returned: 0

SELECT `session_id`

  FROM `jos3_session`

  WHERE `session_id` = 'r4l5a8ta0dfbikc068nsbpd1r2' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.04 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
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:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:49

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

Query Time: 2.73 ms After last query: 0.27 ms Query memory: 0.009 MB Memory before query: 2.585 MB

INSERT INTO `jos3_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('r4l5a8ta0dfbikc068nsbpd1r2', 0, '1537399256')

Explain

EXPLAIN not possible on query: INSERT INTO `jos3_session` (`session_id`, `client_id`, `time`) VALUES ('r4l5a8ta0dfbikc068nsbpd1r2', 0, '1537399256')

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.02 ms
update	0.12 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.01 ms
query end	2.36 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
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:404
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 1.79 ms Query memory: 0.012 MB Memory before query: 2.858 MB Rows returned: 37

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

  FROM jos3_extensions

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos3_extensions	ref	extension	extension	82	const	37	Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.17 ms After last query: 1.27 ms Query memory: 0.012 MB Memory before query: 3.015 MB Rows returned: 1

SELECT b.id

  FROM jos3_usergroups AS a

  LEFT JOIN jos3_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using index

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:852
8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:921
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.14 ms After last query: 0.40 ms Query memory: 0.011 MB Memory before query: 3.058 MB Rows returned: 5

SELECT id, rules

  FROM `jos3_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:938
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 1.00 ms After last query: 0.43 ms Query memory: 0.009 MB Memory before query: 3.077 MB Rows returned: 49

SELECT folder AS type, element AS name, params

  FROM jos3_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	jos3_extensions	ref	extension	extension	82	const	63	Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.32 ms
Sending data	0.21 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 1.07 ms After last query: 11.19 ms Query memory: 0.019 MB Memory before query: 4.395 MB Rows returned: 12

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 jos3_menu AS m

  LEFT JOIN jos3_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	72	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	joomla.m.component_id	1

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.04 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.26 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
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:133
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.50 ms After last query: 2.16 ms Query memory: 0.016 MB Memory before query: 4.601 MB Rows returned: 1

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

  FROM jos3_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos3_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.06 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 3.77 ms After last query: 0.45 ms Query memory: 0.012 MB Memory before query: 4.603 MB

UPDATE `jos3_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.07 ms
Updating	0.08 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.08 ms
query end	3.34 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.14 ms After last query: 1.14 ms Query memory: 0.009 MB Memory before query: 4.795 MB Rows returned: 1

SELECT *

  FROM jos3_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.55 ms After last query: 0.74 ms Query memory: 0.008 MB Memory before query: 4.818 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM jos3_template_styles as s

  LEFT JOIN jos3_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	3	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomla.s.template,const	1	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 1.22 ms After last query: 6.73 ms Query memory: 0.028 MB Memory before query: 5.574 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `jos3_assets`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jos3_assets`

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.40 ms
System lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.05 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
freeing items	0.06 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
18	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:304
17	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:714
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
14	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
13	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:439
12	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
11	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:401
10	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
9	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.17 ms After last query: 0.91 ms Query memory: 0.023 MB Memory before query: 5.643 MB Rows returned: 1

SELECT *

  FROM jos3_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
17	JTable->load()	JROOT/libraries/joomla/access/access.php:715
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
14	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
13	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:439
12	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
11	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:401
10	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
9	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.13 ms After last query: 0.36 ms Query memory: 0.021 MB Memory before query: 5.663 MB Rows returned: 1

SELECT a.rules

  FROM jos3_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:670
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
14	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
13	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:439
12	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
11	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:401
10	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
9	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.57 ms After last query: 0.68 ms Query memory: 0.023 MB Memory before query: 5.713 MB Rows returned: 37

SELECT element

  FROM jos3_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos3_extensions	ref	extension	extension	82	const	37	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.06 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:412
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
13	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:439
12	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
11	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:401
10	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
9	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.15 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 5.745 MB Rows returned: 37

SELECT a.name, a.rules

  FROM jos3_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_jobgroklist','com_joomlaupdate','com_jsjobs','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocamaps','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:439
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
13	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:439
12	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
11	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:401
10	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
9	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 0.19 ms After last query: 3.69 ms Query memory: 0.016 MB Memory before query: 6.017 MB Rows returned: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM jos3_sppagebuilder as a

  LEFT JOIN `jos3_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN jos3_users AS ua 
  ON ua.id = a.created_user_id

  WHERE a.id = 1 
  AND a.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	8	const	1
1	SIMPLE	l	const	idx_langcode	idx_langcode	28	const	0	unique row not found
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
11	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:401
10	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:20
9	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:690
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:16
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:257
1	JApplicationCms->execute()	JROOT/index.php:52

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

Query Time: 1.24 ms After last query: 23.69 ms Query memory: 0.019 MB Memory before query: 7.764 MB Rows returned: 7

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM jos3_modules AS m

  LEFT JOIN jos3_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN jos3_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 <= '2018-09-19 23:20:56') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-09-19 23:20:56') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 437 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	ref	PRIMARY,published,newsfeeds	published	1	const	16	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	joomla.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	joomla.m.module,const	1	Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.05 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.17 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
logging slow query	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:502
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:458
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:222
8	Helix3::generatelayout()	JROOT/templates/shaper_helix3/index.php:157
7	require JROOT/templates/shaper_helix3/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
1	JApplicationCms->execute()	JROOT/index.php:52

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

18 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jos3_extensions

1 × SELECT a.rules 
  FROM jos3_assets AS a

```
1 × SELECT * 
  FROM jos3_assets
```

1 × SELECT element 
  FROM jos3_extensions

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
  FROM jos3_sppagebuilder as a 
  LEFT JOIN `jos3_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos3_users AS ua 
  ON ua.id = a.created_user_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jos3_modules AS m 
  LEFT JOIN jos3_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jos3_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id, home, template, s.params 
  FROM jos3_template_styles as s 
  LEFT JOIN jos3_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT a.name, a.rules 
  FROM jos3_assets AS a

```
1 × SELECT * 
  FROM jos3_languages
```

1 × SELECT b.id 
  FROM jos3_usergroups AS a 
  LEFT JOIN jos3_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `session_id` 
  FROM `jos3_session`

1 × SELECT id, rules 
  FROM `jos3_viewlevels

1 × SELECT folder AS type, element AS name, params 
  FROM jos3_extensions

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM jos3_menu AS m 
  LEFT JOIN jos3_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `data` 
  FROM `jos3_session`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `jos3_assets

1 × UPDATE `jos3_extensions` 
  SET `params` = '{\"mediaversion\":\"c3bfd726eefa66930cd8ff189a6a4370\"}'

1 × INSERT INTO `jos3_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('r4l5a8ta0dfbikc068nsbpd1r2', 0, '1537399256'