CANBERRA

Counselling & Psychotherapy

Welcome to the Counselling Clinic, How May We Help You?

Are you dealing with a specific challenge in your life? Are you experiencing a general sense of anxiety that you simply cannot explain? If you know that something is wrong and you cannot cope with it on your own, you’ve come to the right place.

We are here to help you identify the problem and overcome it in a healthy, and life enriching process.

The Counselling Clinic offers psychotherapy and counselling for conditions like addiction, depression and anxiety in either one-on-one or group sessions. Just let us know your needs and we’ll work together to get you the treatment and support you deserve.

Are you dealing with...

We cover

Addiction Counselling

If you or a loved one are struggling with an addiction or compulsive behaviour and want to be free, without feeling exposed, judged or ashamed. Our confidential treatment program can help you get your lives back on track.
Read More

We cover

Mental Health Counselling

If you're dealing with mental health barriers and you want to understand and manage your experience without feeling labelled, judged or alone. Our supportive therapy will empower you to take control.
Read More

We cover

Trauma Counselling

Do you want assistance to heal your emotional and psychological pain without feeling pressured, boxed in or misunderstood. Our supportive therapists’ are here to help and will gently walk the journey with you.
Read More

Who We Are

We are counselling and psychotherapy professionals committed to making mental health treatment effective and accessible.

The principal clinician at the Counselling Clinic is John Couto, a professionally trained counsellor and psychotherapist. Over the past 12 years, John has specialised in treating diverse mental health issues like addiction and trauma, through to relationship and family counselling, working with all ages from children to adults in various settings.

John and the rest of the Counselling Clinic team focus on providing in-depth counselling to:

Identify issues and behaviour at the root of problems

Develop care plans to relieve symptoms or angst associated with the problems

Facilitate a greater sense of freedom and autonomy through mental health improvement

Assist in improving self-esteem, resilience and healthy behaviour patterns

Strengthen and maintain relationships and supportive network

Step 1

Contact Us

Touch base with us via phone or email and organise a phone consultation

Step 2

Book

Together we will explore your needs, book an appointment and begin the journey

Step 3

Discover

Give yourself the chance to discover who you really are and what you really need

Step 4

Transform

Your habits, your relationships, your health and your life

Reasons to Contact Us

Can psychotherapy and counselling help you? Should you seek therapy? There are several reasons you should get in touch with professionals like the team working at the Counselling Clinic.

Are you dealing with any of the following:

Grief or loss
Adjustment to major life transitions
Insomnia, anxiety, mood swings, depression or persistent feelings of sadness
Abusive or difficult relationships
Feeling stuck or unable to shift behaviour patterns
Difficulty understanding your own self, who you are and what you want to accomplish in life

If you identify with any of these issues, you might benefit from professional counselling. Together, we’ll take a deeper look at the issue and its root causes. Through the process, you will gain a better understanding of yourself, what moves you forward and which coping strategies are best for you.

John Couto and the professional psychotherapy staff at the Counselling Clinic can help you cope with your issues in healthy and enriching ways. Simply complete the form or call us on 02 6294 8013 and we can begin the journey together.

Enquire Now

ABOUT TCC

The Counselling Clinic was conceived to make in-depth counselling and psychotherapy services benefits known and easily accessible and available to the broader community.

Book Now 02 6294 8013

ADDRESS

The Counselling Clinic
12 Wootton Crescent
Gordon Canberra
ACT 2906

FROM THE BLOG

Addiction Counselling and Psychotherapy 06 July 2017

Mental Health Counselling and Psychotherapy 06 July 2017

Trauma Counselling and Psychotherapy 06 July 2017

SERVICES

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1603203095,
                "last": 1603203095,
                "now": 1603203095
            }
        },
        "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

Time

Memory

Time: 3.32 ms / 3.32 ms Memory: 0.065 MB / 0.44 MB Application: afterLoad

Time: 29.33 ms / 32.64 ms Memory: 1.117 MB / 1.56 MB Application: afterInitialise

Time: 13.41 ms / 46.05 ms Memory: 0.559 MB / 2.12 MB Application: afterRoute

Time: 0.40 ms / 46.45 ms Memory: 0.113 MB / 2.23 MB Application: beforeRenderComponent com_sppagebuilder

Time: 2.04 ms / 48.49 ms Memory: 0.060 MB / 2.29 MB Application: Before JAccess::preloadComponents (all components)

Time: 0.80 ms / 49.29 ms Memory: 0.058 MB / 2.35 MB Application: After JAccess::preloadComponents (all components)

Time: 0.02 ms / 49.31 ms Memory: 0.000 MB / 2.34 MB Application: Before JAccess::getAssetRules (id:180 name:com_sppagebuilder)

Time: 0.21 ms / 49.52 ms Memory: 0.009 MB / 2.35 MB Application: After JAccess::getAssetRules (id:180 name:com_sppagebuilder)

Time: 46.95 ms / 96.47 ms Memory: 0.779 MB / 3.13 MB Application: beforeRenderModule mod_unite_revolution2 (Home Slider)

Time: 12.40 ms / 108.87 ms Memory: 0.632 MB / 3.76 MB Application: afterRenderModule mod_unite_revolution2 (Home Slider)

Time: 5.85 ms / 114.72 ms Memory: 0.000 MB / 3.57 MB Application: beforeRenderModule mod_sp_quickcontact (Contact Form)

Time: 0.54 ms / 115.26 ms Memory: 0.010 MB / 3.58 MB Application: afterRenderModule mod_sp_quickcontact (Contact Form)

Time: 1.83 ms / 117.09 ms Memory: 0.007 MB / 3.58 MB Application: beforeRenderModule mod_sppagebuilder (Google Maps)

Time: 0.85 ms / 117.95 ms Memory: 0.009 MB / 3.59 MB Application: afterRenderModule mod_sppagebuilder (Google Maps)

Time: 0.33 ms / 118.28 ms Memory: 0.000 MB / 3.27 MB Application: afterRenderComponent com_sppagebuilder

Time: 1.04 ms / 119.32 ms Memory: 0.009 MB / 3.28 MB Application: afterDispatch

Time: 19.94 ms / 139.26 ms Memory: 0.323 MB / 3.61 MB Application: beforeRenderModule mod_custom (ABOUT TCC)

Time: 0.38 ms / 139.65 ms Memory: 0.006 MB / 3.61 MB Application: afterRenderModule mod_custom (ABOUT TCC)

Time: 10.32 ms / 149.97 ms Memory: 0.055 MB / 3.67 MB Application: beforeRenderModule mod_search (Search)

Time: 1.26 ms / 151.23 ms Memory: 0.015 MB / 3.68 MB Application: afterRenderModule mod_search (Search)

Time: 0.46 ms / 151.68 ms Memory: 0.000 MB / 3.68 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 1.86 ms / 153.54 ms Memory: 0.051 MB / 3.73 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.43 ms / 153.97 ms Memory: 0.000 MB / 3.73 MB Application: beforeRenderModule mod_custom (Footer 1)

Time: 0.13 ms / 154.10 ms Memory: 0.003 MB / 3.73 MB Application: afterRenderModule mod_custom (Footer 1)

Time: 0.28 ms / 154.39 ms Memory: 0.000 MB / 3.73 MB Application: beforeRenderModule mod_menu (SERVICES)

Time: 0.89 ms / 155.28 ms Memory: 0.032 MB / 3.77 MB Application: afterRenderModule mod_menu (SERVICES)

Time: 0.38 ms / 155.66 ms Memory: 0.000 MB / 3.77 MB Application: beforeRenderModule mod_articles_latest (FROM THE BLOG)

Time: 8.53 ms / 164.19 ms Memory: 0.041 MB / 3.81 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Time: 0.05 ms / 164.24 ms Memory: 0.007 MB / 3.81 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Time: 19.87 ms / 184.11 ms Memory: 0.065 MB / 3.88 MB Application: afterRenderModule mod_articles_latest (FROM THE BLOG)

Time: 0.40 ms / 184.52 ms Memory: 0.000 MB / 3.83 MB Application: beforeRenderModule mod_custom (ADDRESS)

Time: 266.44 ms / 450.96 ms Memory: 0.104 MB / 3.93 MB Application: afterRenderModule mod_custom (ADDRESS)

Time: 0.57 ms / 451.53 ms Memory: 0.000 MB / 3.93 MB Application: beforeRenderModule mod_custom (ABOUT TCC)

Time: 0.16 ms / 451.70 ms Memory: 0.005 MB / 3.94 MB Application: afterRenderModule mod_custom (ABOUT TCC)

Time: 9.30 ms / 460.99 ms Memory: 0.162 MB / 4.10 MB Application: afterRender

Database queries total: 67.00 ms

Memory Usage

Database Queries

37 Queries Logged 67.00 ms

6 duplicate found!

6 duplicates: #25 #26 #27 #28 #29 #30

Query Time: 0.34 ms Query memory: 0.003 MB Memory before query: 0.734 MB

DELETE 

  FROM `jos_session`

  WHERE `time` < '1603113095'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	jos_session	NULL	range	time	time	59	const	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.06 ms
updating	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
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:413
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.16 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 0.742 MB Rows returned: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = 'a7b3316e6ba6b86ffd26f906819e4ac6'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	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:829
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:413
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.15 ms After last query: 0.49 ms Query memory: 0.019 MB Memory before query: 0.820 MB Rows returned: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'a7b3316e6ba6b86ffd26f906819e4ac6' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	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:831
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:413
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.18 ms After last query: 0.05 ms Query memory: 0.003 MB Memory before query: 0.825 MB

INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('a7b3316e6ba6b86ffd26f906819e4ac6', 1, '1603203095', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('a7b3316e6ba6b86ffd26f906819e4ac6', 1, '1603203095', 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
update	0.99 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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:831
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:413
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: 7.86 ms After last query: 1.34 ms Query memory: 0.039 MB Memory before query: 0.860 MB Rows returned: 40

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

  FROM `jos_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	40	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	7.60 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	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:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
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.23 ms After last query: 1.17 ms Query memory: 0.021 MB Memory before query: 0.899 MB Rows returned: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	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:1061
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
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.50 ms After last query: 0.06 ms Query memory: 0.021 MB Memory before query: 0.911 MB Rows returned: 1

SELECT b.id

  FROM jos_usergroups AS a

  LEFT JOIN jos_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	1.28 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	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:1093
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
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.61 ms After last query: 0.49 ms Query memory: 0.026 MB Memory before query: 0.937 MB Rows returned: 80

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

  FROM jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	101	0.47	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.35 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	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:327
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
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.87 ms After last query: 7.72 ms Query memory: 0.068 MB Memory before query: 1.594 MB Rows returned: 37

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

  LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	154	6.10	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dbrrnfxgpmeqcn.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.41 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	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:444
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:549
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
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.21 ms After last query: 3.91 ms Query memory: 0.021 MB Memory before query: 1.867 MB Rows returned: 1

Select attribs 
  From jos_breezingcommerce_configuration 
  Order By id Desc 
  Limit 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_breezingcommerce_configuration	NULL	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_breezingcommerce/classes/CrBcHelpers.php:1118
9	CrBcHelpers::getBcConfig()	JROOT/plugins/system/breezingcommerce/breezingcommerce.php:26
8	PlgSystemBreezingcommerce->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:1155
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.32 ms After last query: 0.65 ms Query memory: 0.021 MB Memory before query: 1.907 MB Rows returned: 0

Select * 
  From jos_breezingcommerce_plugins 
  Where `type` = 'theme' 
  And published = 1 
  Order By ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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_breezingcommerce/classes/plugin/CrBcPlugin.php:248
9	CrBcPlugin::getPlugins()	JROOT/plugins/system/breezingcommerce/breezingcommerce.php:38
8	PlgSystemBreezingcommerce->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:1155
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.28 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 1.934 MB Rows returned: 1

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

  FROM `jos_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
16	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
14	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:388
8	plgSystemK2->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:1155
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.28 ms After last query: 0.20 ms Query memory: 0.006 MB Memory before query: 1.926 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"3dc1a3c3b6a1e0a61279ec080f36a81d\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jos_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.07 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:388
8	plgSystemK2->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:1155
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.33 ms After last query: 1.24 ms Query memory: 0.022 MB Memory before query: 1.993 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
12	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
11	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
8	plgSystemK2->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:1155
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: 1.95 ms After last query: 1.33 ms Query memory: 0.024 MB Memory before query: 2.080 MB Rows returned: 1

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	2	2.50	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template	idx_template	202	dbrrnfxgpmeqcn.e.element	1	50.00	Using index condition; Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	1.68 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	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/cms/application/site.php:485
17	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:359
16	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:706
15	JHtml::script()	JROOT/libraries/cms/html/html.php:233
14	JHtml::call()	JROOT/libraries/cms/html/html.php:140
13	JHtml::_()	JROOT/libraries/cms/html/jquery.php:52
12	JHtmlJquery::framework()	JROOT/libraries/cms/html/html.php:233
11	JHtml::call()	JROOT/libraries/cms/html/html.php:140
10	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
8	plgSystemK2->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:1155
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.64 ms After last query: 3.28 ms Query memory: 0.028 MB Memory before query: 2.292 MB Rows returned: 40

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_admin','com_advportfoliopro','com_ajax','com_akeeba','com_associations','com_banners','com_breezingcommerce','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sitemapgenerator','com_sppagebuilder','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	178	23.03	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:434
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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: 11.44 ms After last query: 0.45 ms Query memory: 0.148 MB Memory before query: 2.356 MB Rows returned: 1

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

  FROM jos_sppagebuilder as a

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

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	4.29 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	6.70 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	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_sppagebuilder/models/page.php:82
12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.61 ms After last query: 0.38 ms Query memory: 0.029 MB Memory before query: 2.429 MB Rows returned: 23

SHOW FULL COLUMNS 
  FROM `jos_sppagebuilder`

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	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/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
13	SppagebuilderTablePage->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:176
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.35 ms After last query: 0.39 ms Query memory: 0.148 MB Memory before query: 2.467 MB Rows returned: 1

SELECT *

  FROM jos_sppagebuilder

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_sppagebuilder	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_sppagebuilder/models/page.php:177
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.31 ms After last query: 0.17 ms Query memory: 0.006 MB Memory before query: 2.535 MB

UPDATE jos_sppagebuilder

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

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jos_sppagebuilder	NULL	range	PRIMARY	PRIMARY	8	const	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.03 ms
updating	0.08 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
12	JTable->hit()	JROOT/components/com_sppagebuilder/models/page.php:178
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.29 ms After last query: 1.69 ms Query memory: 0.022 MB Memory before query: 2.603 MB Rows returned: 1

SELECT `template`

  FROM `jos_template_styles`

  WHERE `client_id` = '0' 
  AND `home` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_template_styles	NULL	ref	idx_home	idx_home	28	const	2	50.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/components/com_sppagebuilder/helpers/helper.php:32
12	SppagebuilderHelperSite::getTemplate()	JROOT/components/com_sppagebuilder/helpers/helper.php:19
11	SppagebuilderHelperSite::loadLanguage()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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: 9.00 ms After last query: 21.85 ms Query memory: 0.025 MB Memory before query: 3.121 MB Rows returned: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM jos_modules AS m

  WHERE m.published = 1 
  AND m.id = 126 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-20 14:11:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-20 14:11:35') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	8.59 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	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_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.44 ms After last query: 8.10 ms Query memory: 0.028 MB Memory before query: 3.445 MB Rows returned: 1

select * 
  from jos_revslider_sliders 
  where id=5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_revslider_sliders	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:223
21	UniteDBRev->fetchSingle()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:76
20	RevSlider->initByID()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:119
19	RevSlider->initByMixed()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:1909
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.97 ms After last query: 0.12 ms Query memory: 0.044 MB Memory before query: 3.474 MB Rows returned: 3

select * 
  from jos_revslider_slides 
  where slider_id=5 
  order by slide_order

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.60 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
24	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
23	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1502
22	RevSlider->getSlidesFromGallery()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1395
21	RevSlider->getSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1581
20	RevSlider->getSlidesForOutput()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:260
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.78 ms After last query: 1.06 ms Query memory: 0.027 MB Memory before query: 3.695 MB Rows returned: 0

Duplicate queries: #26 #27 #28 #29 #30

select * 
  from jos_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.61 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.15 ms After last query: 0.05 ms Query memory: 0.027 MB Memory before query: 3.707 MB Rows returned: 0

Duplicate queries: #25 #27 #28 #29 #30

select * 
  from jos_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.14 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 3.719 MB Rows returned: 0

Duplicate queries: #25 #26 #28 #29 #30

select * 
  from jos_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.08 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 3.731 MB Rows returned: 0

Duplicate queries: #25 #26 #27 #29 #30

select * 
  from jos_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.07 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 3.743 MB Rows returned: 0

Duplicate queries: #25 #26 #27 #28 #30

select * 
  from jos_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.05 ms After last query: 0.02 ms Query memory: 0.027 MB Memory before query: 3.755 MB Rows returned: 0

Duplicate queries: #25 #26 #27 #28 #29

select * 
  from jos_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/libraries/cms/module/helper.php:198
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.95 ms After last query: 5.20 ms Query memory: 0.025 MB Memory before query: 3.556 MB Rows returned: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM jos_modules AS m

  WHERE m.published = 1 
  AND m.id = 141 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-20 14:11:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-20 14:11:35') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.68 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	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_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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: 1.14 ms Query memory: 0.025 MB Memory before query: 3.571 MB Rows returned: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM jos_modules AS m

  WHERE m.published = 1 
  AND m.id = 155 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-20 14:11:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-20 14:11:35') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.96 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
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.07 ms After last query: 21.08 ms Query memory: 0.026 MB Memory before query: 3.577 MB Rows returned: 1

SELECT id, title, module, position, content, showtitle, params

  FROM jos_modules AS m

  WHERE m.published = 1 
  AND m.id = 94 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-10-20 14:11:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-20 14:11:35') 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY position, ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.76 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/helix3/core/classes/menu.php:522
17	Helix3Menu->load_module()	JROOT/plugins/system/helix3/core/classes/menu.php:364
16	Helix3Menu->mega()	JROOT/plugins/system/helix3/core/classes/menu.php:201
15	Helix3Menu->getItem()	JROOT/plugins/system/helix3/core/classes/menu.php:189
14	Helix3Menu->navigation()	JROOT/plugins/system/helix3/core/classes/menu.php:132
13	Helix3Menu->render()	JROOT/plugins/system/helix3/core/classes/menu.php:32
12	Helix3Menu->__construct()	JROOT/plugins/system/helix3/core/helix3.php:830
11	Helix3::loadMegaMenu()	JROOT/templates/lt_finex/features/menu.php:29
10	Helix3FeatureMenu->renderFeature()	JROOT/plugins/system/helix3/core/helix3.php:200
9	Helix3::importFeatures()	JROOT/plugins/system/helix3/core/helix3.php:241
8	Helix3::generatelayout()	JROOT/templates/lt_finex/index.php:156
7	require JROOT/templates/lt_finex/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
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: 3.41 ms After last query: 1.19 ms Query memory: 0.043 MB Memory before query: 3.630 MB Rows returned: 22

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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 <= '2020-10-20 14:11:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-20 14:11:35') 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	66	1.52	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	dbrrnfxgpmeqcn.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dbrrnfxgpmeqcn.m.id	1	40.00	Using where; Using index

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	1.15 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.88 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
15	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
14	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:507
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:454
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:263
8	Helix3::generatelayout()	JROOT/templates/lt_finex/index.php:156
7	require JROOT/templates/lt_finex/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
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: 14.08 ms After last query: 20.48 ms Query memory: 0.058 MB Memory before query: 3.813 MB Rows returned: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM jos_content AS a

  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (79) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-20 14:11:35') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-20 14:11:35')

  ORDER BY a.created DESC 
  LIMIT 3

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	5	11.87	Using index condition; Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dbrrnfxgpmeqcn.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dbrrnfxgpmeqcn.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dbrrnfxgpmeqcn.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.20 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.80 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	5.04 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	6.61 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.04 ms
cleaning up	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/legacy/model/legacy.php:307
16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
13	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
12	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:586
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
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:1116
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: 2.38 ms After last query: 1.85 ms Query memory: 0.028 MB Memory before query: 3.880 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 jos_categories as c

  LEFT JOIN jos_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=79

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	1.89 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
23	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
22	JCategories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
20	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
19	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
18	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
17	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
16	JRouter->build()	JROOT/libraries/cms/router/site.php:149
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/modules/mod_articles_latest/helper.php:128
13	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
12	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:586
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
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:1116
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: 2.25 ms After last query: 5.06 ms Query memory: 0.027 MB Memory before query: 3.942 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 jos_fields AS a

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

  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access

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

  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  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)

  ORDER BY a.ordering ASC

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.21 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	1.62 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	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/legacy/model/legacy.php:307
22	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
21	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
20	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
15	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
14	JHtml::call()	JROOT/libraries/cms/html/html.php:140
13	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
12	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
11	JModuleHelper::renderModule()	JROOT/libraries/joomla/cache/controller/callback.php:169
10	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:586
9	JModuleHelper::moduleCache()	JROOT/libraries/joomla/document/renderer/html/module.php:90
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:1116
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.]

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

6 × select * 
  from jos_revslider_layer_animation

3 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params 
  FROM jos_modules AS m

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

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT * 
  FROM jos_sppagebuilder

1 × 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 jos_categories as c 
  LEFT JOIN jos_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,         COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

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

1 × SELECT id, title, module, position, content, showtitle, params 
  FROM jos_modules AS m

1 × select * 
  from jos_revslider_slides

1 × select * 
  from jos_revslider_sliders

1 × SELECT `template` 
  FROM `jos_template_styles`

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
  FROM jos_sppagebuilder as a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos_assets`

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

```
1 × SELECT * 
  FROM jos_languages
```

1 × Select * 
  From jos_breezingcommerce_plugins

1 × Select attribs 
  From jos_breezingcommerce_configuration

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 jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM jos_extensions

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

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 jos_fields AS a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id

OTHER Tables:

```
1 × DELETE  
  FROM `jos_session`
```

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('a7b3316e6ba6b86ffd26f906819e4ac6', 1, '1603203095', 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"3dc1a3c3b6a1e0a61279ec080f36a81d\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_sppagebuilder

1 × UPDATE jos_sppagebuilder 
  SET `hits` = (`hits` + 1)