Frosted privacy film for balcony glass balustrade and pool fencing

Glass balustrading and pool fencing is a stunning design feature now found in both commercial and residential applications. Glass balustrades are finding creative application as a pool fence, a balcony balustrade or a stylish safety barrier for a staircase.

Frosted Film for Pool Fencing

Tropi Cool Window Tinting Pool Fence Frosting

Frosted film being installed on a glass pool fence - by Tropi-Cool in Cairns.

I don't usually show jobs done by other companies, but this shot is iconic. From the perspective of a film installer, it doesn't get much better than this! ... perhaps a beer.

Hot day - in the pool - and earning a dollar | very nice

A glass pool fence is a stylish alternative to traditional pool fencing materials. Not only does it keep your family safe around the pool but provides you a clear view of the pool and its occupants.

From some angles, the glass pool fencing is a great safety feature allowlng parents to maintain an unobstructed view of their kids in the pool for their safety

But who else may be watching?

Keep you family safe from prying eyes and unwanted attention by installing a frosted privacy film on some glass panels to obscrue the view from neighbours or the street

Externally installed Frosted Films

Lowest Price Promise: If you are quoted a price less than our online price on a film we stock,

the boss won't lamely match the price - he'll smash the price by $51, Plus FREE freight (worth $20).

He doesn't like to be beaten - see our price promise conditions

Diamond Frost installed by Tintplus on a pool fence in Brisbane
Frosted film for the Glass Balustrade (Balcony Glass) Catering to the growing demand for day and night-time privacy many owners of an inner city townhouse or apartment are turning to frosted film for privacy, both from passers-by in the street and from a nosy neighbour. Frequently, frosted film installed on the glass balustrade on the balcony can provide the privacy required.
	Please Note: Frosted Film installed externally on a balcony or pool fencing must be a premium quality cast vinyl to withstand exposure to the elements. (ie a cast vinyl is higher quality UV stabilised vinyl film that is expected to last 5 - 7 years when installed externally). For external installation we recommend: For a sparkly appearance: 3M Frosted Crystal or Smart Films Diamond Frost For a matt appearance: 3M Dusted Crystal or Smart Films Diamond Dust Most frosted films are medium quality calendared vinyl films intended for internal installation only. Our Sparkling Vinyl Frost (SV02) and most acid-etch type frosted films are intended for internal installation only. If installed externally they may last 18 months. If a calendared film is installed externally and fails after a couple of years this is not a manufacturers warranty issue. Reputable Vinyl manufacturers clearly state which films are designed for external installation and these films are priced accordingly. It is the responsibility of the film seller/installer to advise the customer if a film is not suited for the intended installation. Do Not install a Calendared vinyl film externally - it will fail (Guaranteed)
Diamond Frost installed by Tint4Less on balcony facing a neighbour in Enoggera QLD

Print Email

Service Centres - Capital Cities

Service Centres - Regions

Products

Company

Contact Us

Phone: (07) 3849 2022
Phone: 1300 658 503

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1558419903,
                "last": 1558419903,
                "now": 1558419903
            },
            "token": "ox4uMUFNFpAsASbimcQhbID4A9maOrk8"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "a337495606e0c5581b126c6a443c46b76ea24efb": {
                    "link": "https:\/\/tintplus.com.au\/frosted-privacy-film\/frosted-privacy-film-for-balcony-glass-balustrade-and-pool-fencing.html",
                    "expiry": 1558419904
                }
            }
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Profile Information

Memory Usage

Database Queries

58 Queries Logged 56.73 ms

4 duplicate found!

2 duplicates: #49 #50

2 duplicates: #51 #52

Query Time: 0.70 ms Query memory: 0.025 MB Memory before query: 1.198 MB Rows returned: 0

SELECT `data`

  FROM `mdahc_session`

  WHERE `session_id` = 'de7d9a8a06284edb9053428b03b2b787'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_session	const	PRIMARY	PRIMARY	194	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.51 ms After last query: 0.77 ms Query memory: 0.022 MB Memory before query: 1.276 MB Rows returned: 0

SELECT `session_id`

  FROM `mdahc_session`

  WHERE `session_id` = 'de7d9a8a06284edb9053428b03b2b787' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.23 ms After last query: 0.16 ms Query memory: 0.004 MB Memory before query: 1.281 MB

INSERT INTO `mdahc_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('de7d9a8a06284edb9053428b03b2b787', 1, 1558419903, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `mdahc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('de7d9a8a06284edb9053428b03b2b787', 1, 1558419903, 0, '', 0)

Profile

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 0.60 ms After last query: 3.35 ms Query memory: 0.023 MB Memory before query: 1.396 MB Rows returned: 8

SELECT id, rules

  FROM `mdahc_viewlevels`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 1.409 MB Rows returned: 2

SELECT b.id

  FROM mdahc_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 10.20 ms Query memory: 0.022 MB Memory before query: 2.143 MB Rows returned: 1

SELECT `enabled`

  FROM `mdahc_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 13.95 ms Query memory: 0.025 MB Memory before query: 2.776 MB Rows returned: 21

SELECT *

  FROM mdahc_rsform_config

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 1.14 ms Query memory: 0.023 MB Memory before query: 2.805 MB Rows returned: 0

select email 
  from mdahc_users 
  where id=0 
  LIMIT 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/bfstop/helpers/db.php:246
12	BFStopDBHelper->getUserEmailWhere()	JROOT/plugins/system/bfstop/helpers/db.php:253
11	BFStopDBHelper->getUserEmailByID()	JROOT/plugins/system/bfstop/helpers/notify.php:23
10	BFStopNotifier->__construct()	JROOT/plugins/system/bfstop/bfstop.php:197
9	plgSystembfstop->init()	JROOT/plugins/system/bfstop/bfstop.php:367
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 2.814 MB Rows returned: 0

SELECT id, ipaddress 
  from mdahc_bfstop_whitelist 
  WHERE (ipaddress='34.229.76.193' 
  AND LOCATE('/', ipaddress) = 0)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:189
9	BFStopDBHelper->isIPWhiteListed()	JROOT/plugins/system/bfstop/bfstop.php:386
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 2.820 MB Rows returned: 0

SELECT id, ipaddress 
  from mdahc_bfstop_whitelist 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('34.229.76.193') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:190
9	BFStopDBHelper->isIPWhiteListed()	JROOT/plugins/system/bfstop/bfstop.php:386
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 2.826 MB Rows returned: 0

SELECT id, ipaddress, crdate, duration 
  FROM mdahc_bfstop_bannedip b 
  WHERE (ipaddress='34.229.76.193' 
  AND LOCATE('/', ipaddress) = 0) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2019-05-21 06:25:03') 
  AND NOT EXISTS (SELECT 1 
  FROM mdahc_bfstop_unblock u 
  WHERE b.id = u.block_id)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	158	Using where
2	MATERIALIZED	u	index	PRIMARY	PRIMARY	4	NULL	1	Using index

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:179
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:390
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.833 MB Rows returned: 0

SELECT id, ipaddress, crdate, duration 
  FROM mdahc_bfstop_bannedip b 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('34.229.76.193') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2019-05-21 06:25:03') 
  AND NOT EXISTS (SELECT 1 
  FROM mdahc_bfstop_unblock u 
  WHERE b.id = u.block_id)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	158	Using where
2	MATERIALIZED	u	index	PRIMARY	PRIMARY	4	NULL	1	Using index

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:180
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:390
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 2.06 ms Query memory: 0.028 MB Memory before query: 2.921 MB Rows returned: 2

SELECT *

  FROM mdahc_languages

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:215
12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:167
11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:63
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 2.36 ms Query memory: 0.036 MB Memory before query: 3.090 MB Rows returned: 1

SELECT `params` 
  FROM mdahc_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:160
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:656
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:121
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:86
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.90 ms After last query: 13.37 ms Query memory: 0.028 MB Memory before query: 3.513 MB Rows returned: 0

SELECT * 
  FROM `mdahc_sh404sef_aliases` 
  WHERE `state` = 1 
  and (`alias` = 'https://tintplus.com.au/frosted-privacy-film/frosted-privacy-film-for-balcony-glass-balustrade-
  and-pool-fencing.html') 
  order by `ordering` asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_sh404sef_aliases	ref	state,alias	alias	573	const	1	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
16	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/models/redirector.php:221
15	Sh404sefModelRedirector->findHardcodedMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:115
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:188
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:645
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:263
10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 0.13 ms Query memory: 0.030 MB Memory before query: 3.520 MB Rows returned: 8

SELECT * 
  FROM mdahc_sh404sef_aliases 
  WHERE state = 1 
  and (type = 1 or type = 2);

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_sh404sef_aliases	range	type,state	type	1	NULL	9	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/redirector.php:285
15	Sh404sefModelRedirector->findWildcardMatchedRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:116
14	Sh404sefModelRedirector->loadMatchRules()	JROOT/administrator/components/com_sh404sef/models/redirector.php:86
13	Sh404sefModelRedirector->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:188
12	Sh404sefFactory::getRedirector()	JROOT/administrator/components/com_sh404sef/classes/router.php:645
11	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:263
10	Sh404sefClassRouterInternal->preprocessParseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.18 ms After last query: 1.72 ms Query memory: 0.029 MB Memory before query: 3.559 MB Rows returned: 6

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM mdahc_sh404sef_urls 
  WHERE `oldurl`='frosted-privacy-film/frosted-privacy-film-for-balcony-glass-balustrade-
  and-pool-fencing.html' 
  ORDER BY `rank`;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_sh404sef_urls	ref	oldurl	oldurl	573	const	6	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:661
18	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:455
17	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
16	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
15	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1638
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1298
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2282
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:399
11	Sh404sefClassRouterInternal->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.35 ms After last query: 0.28 ms Query memory: 0.008 MB Memory before query: 3.571 MB

UPDATE `mdahc_sh404sef_urls` 
  SET `cpt`=612, `last_hit`='2019-05-21 06:25:03' 
  WHERE `id`='93' 
  AND `rank`=0;

Explain

EXPLAIN not possible on query: UPDATE `mdahc_sh404sef_urls` SET `cpt`=612, `last_hit`='2019-05-21 06:25:03' WHERE `id`='93' AND `rank`=0;

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
17	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:478
16	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:467
15	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
14	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1317
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2282
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:399
11	Sh404sefClassRouterInternal->parseRule()	Same as call in the line below.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.43 ms After last query: 6.22 ms Query memory: 0.006 MB Memory before query: 3.719 MB

UPDATE `mdahc_extensions`

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

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helixultimate/helixultimate.php:134
8	plgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 2.45 ms Query memory: 0.026 MB Memory before query: 3.818 MB Rows returned: 8

SELECT s.*

  FROM mdahc_template_styles as s

  WHERE s.client_id = 0

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedtemplates/src/Document.php:195
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyles()	JROOT/plugins/system/advancedtemplates/src/Document.php:123
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:104
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/src/Helper.php:37
11	RegularLabs\Plugin\System\AdvancedTemplates\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedtemplates/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedTemplates\Plugin->run()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:62
8	PlgSystemAdvancedTemplates->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 3.845 MB Rows returned: 1

SELECT a.params

  FROM mdahc_advancedtemplates AS a

  WHERE a.styleid = 4

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:302
17	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:209
16	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:272
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:175
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:129
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:104
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/src/Helper.php:37
11	RegularLabs\Plugin\System\AdvancedTemplates\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedtemplates/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedTemplates\Plugin->run()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:62
8	PlgSystemAdvancedTemplates->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 1.09 ms Query memory: 0.026 MB Memory before query: 3.865 MB Rows returned: 1

SELECT a.params

  FROM mdahc_advancedtemplates AS a

  WHERE a.styleid = 7

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:302
17	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:209
16	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:272
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:175
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:129
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:104
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/src/Helper.php:37
11	RegularLabs\Plugin\System\AdvancedTemplates\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedtemplates/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedTemplates\Plugin->run()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:62
8	PlgSystemAdvancedTemplates->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 3.877 MB Rows returned: 1

SELECT a.params

  FROM mdahc_advancedtemplates AS a

  WHERE a.styleid = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:302
17	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:209
16	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:272
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:175
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:129
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:104
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/src/Helper.php:37
11	RegularLabs\Plugin\System\AdvancedTemplates\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedtemplates/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedTemplates\Plugin->run()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:62
8	PlgSystemAdvancedTemplates->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 3.889 MB Rows returned: 1

SELECT a.params

  FROM mdahc_advancedtemplates AS a

  WHERE a.styleid = 10

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:302
17	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:209
16	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:272
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:175
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:129
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:104
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/src/Helper.php:37
11	RegularLabs\Plugin\System\AdvancedTemplates\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedtemplates/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedTemplates\Plugin->run()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:62
8	PlgSystemAdvancedTemplates->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 3.897 MB Rows returned: 1

SELECT a.params

  FROM mdahc_advancedtemplates AS a

  WHERE a.styleid = 11

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:302
17	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:209
16	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:272
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:175
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:129
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:104
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/src/Helper.php:37
11	RegularLabs\Plugin\System\AdvancedTemplates\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedtemplates/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedTemplates\Plugin->run()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:62
8	PlgSystemAdvancedTemplates->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 3.906 MB Rows returned: 1

SELECT a.params

  FROM mdahc_advancedtemplates AS a

  WHERE a.styleid = 12

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:302
17	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:209
16	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:272
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:175
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:129
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:104
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/src/Helper.php:37
11	RegularLabs\Plugin\System\AdvancedTemplates\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedtemplates/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedTemplates\Plugin->run()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:62
8	PlgSystemAdvancedTemplates->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 3.915 MB Rows returned: 1

SELECT a.params

  FROM mdahc_advancedtemplates AS a

  WHERE a.styleid = 14

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
18	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:302
17	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:209
16	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:272
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:175
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:129
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:104
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/src/Helper.php:37
11	RegularLabs\Plugin\System\AdvancedTemplates\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedtemplates/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedTemplates\Plugin->run()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:62
8	PlgSystemAdvancedTemplates->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.93 ms After last query: 5.98 ms Query memory: 0.031 MB Memory before query: 4.020 MB Rows returned: 46

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

  FROM `mdahc_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedtemplates','com_advisor','com_ajax','com_akeeba','com_associations','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_sh404sef','com_sppagebuilder','com_sptransfer','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.27 ms After last query: 0.35 ms Query memory: 0.038 MB Memory before query: 4.077 MB Rows returned: 122

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

  FROM `mdahc_assets`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.35 ms After last query: 3.05 ms Query memory: 0.035 MB Memory before query: 4.279 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `mdahc_content`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 8.42 ms Query memory: 0.047 MB Memory before query: 4.353 MB Rows returned: 1

SELECT *

  FROM mdahc_content

  WHERE `id` = '189'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.45 ms After last query: 0.23 ms Query memory: 0.005 MB Memory before query: 4.383 MB

UPDATE mdahc_content

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

  WHERE `id` = '189'

Explain

EXPLAIN not possible on query: UPDATE mdahc_content SET `hits` = (`hits` + 1) WHERE `id` = '189'

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.25 ms After last query: 2.56 ms Query memory: 0.038 MB Memory before query: 4.436 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM mdahc_content AS a

  INNER JOIN mdahc_categories AS c 
  on c.id = a.catid

  LEFT JOIN mdahc_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 189 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-05-21 06:25:03') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-05-21 06:25:03') 
  AND (a.state = 1 OR a.state =2)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 1.80 ms Query memory: 0.040 MB Memory before query: 4.556 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 `mdahc_categories` AS `s`

  INNER JOIN `mdahc_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	57	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 2.89 ms Query memory: 0.035 MB Memory before query: 4.652 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `mdahc_contentitem_tag_map` AS m 

  INNER JOIN `mdahc_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 189 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5,10)

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.13 ms After last query: 20.79 ms Query memory: 0.038 MB Memory before query: 4.782 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, g.note as group_note

  FROM mdahc_fields AS a

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

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

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

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

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

  LEFT JOIN `mdahc_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (41,0)) 
  AND a.access IN (1,1,5,10) 
  AND (a.group_id = 0 OR g.access IN (1,1,5,10)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 5.92 ms After last query: 7.97 ms Query memory: 0.039 MB Memory before query: 4.891 MB Rows returned: 36

SHOW FULL COLUMNS 
  FROM `mdahc_sh404sef_metas`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:127
19	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:33
17	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
16	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:406
15	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:280
14	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 0.24 ms Query memory: 0.041 MB Memory before query: 4.963 MB Rows returned: 0

SELECT * 
  FROM mdahc_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_content&Itemid=653&id=189&lang=en&view=article';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_sh404sef_metas	ref	newurl	newurl	573	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
21	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
20	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
19	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
18	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:34
17	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:92
16	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:406
15	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:280
14	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.32 ms After last query: 3.43 ms Query memory: 0.027 MB Memory before query: 4.990 MB Rows returned: 7

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM mdahc_content AS a

  LEFT JOIN mdahc_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 41 
  AND a.state = 1 
  AND a.access IN (1,1,5,10)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-05-21 06:25:03') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-05-21 06:25:03')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	7	Using where; Using filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 16.19 ms Query memory: 0.035 MB Memory before query: 5.153 MB Rows returned: 0

SELECT `oldurl`, `dateadd` 
  FROM mdahc_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_mailto&lang=en&link=a337495606e0c5581b126c6a443c46b76ea24efb&template=shaper_helixultimate&tmpl=component';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_sh404sef_urls	ref	newurl	newurl	573	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
36	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
35	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
34	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
33	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:767
32	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:804
31	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1469
30	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1157
29	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2288
28	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1011
27	Sh404sefClassRouterInternal->buildRule()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
25	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
24	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
23	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
19	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/helpers/icon.php:85
18	JHtmlIcon::email()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/shaper_helixultimate/html/com_content/article/default.php:147
14	include JROOT/templates/shaper_helixultimate/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 2.54 ms Query memory: 0.024 MB Memory before query: 5.139 MB Rows returned: 1

SELECT params 
  FROM mdahc_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 0.42 ms Query memory: 0.023 MB Memory before query: 5.147 MB Rows returned: 1

SELECT id,template 
  FROM mdahc_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 2.61 ms Query memory: 0.030 MB Memory before query: 5.298 MB Rows returned: 0

SELECT `oldurl`, `dateadd` 
  FROM mdahc_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_widgetkit&format=raw&id=&lang=en';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_sh404sef_urls	ref	newurl	newurl	573	const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
27	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
26	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
25	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
24	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:767
23	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:804
22	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1469
21	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1157
20	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2288
19	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1011
18	Sh404sefClassRouterInternal->buildRule()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Router/Router.php:638
16	Joomla\CMS\Router\Router->processBuildRules()	JROOT/libraries/src/Router/SiteRouter.php:657
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:614
14	Joomla\CMS\Router\Router->_processBuildRules()	JROOT/libraries/src/Router/Router.php:270
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
10	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_widgetkit/helpers/system.php:186
9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 8.51 ms Query memory: 0.025 MB Memory before query: 5.388 MB Rows returned: 1

SELECT `params` 
  FROM mdahc_extensions 
  WHERE `type`='plugin' 
  AND `folder`='system' 
  AND `element`='sef';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:687
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:377
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:182
11	Sh404sefHelperGeneral::getExtensionParams()	JROOT/administrator/components/com_sh404sef/helpers/url.php:541
10	Sh404sefHelperUrl::canonicalRoutedToAbs()	JROOT/components/com_sh404sef/meta_ext/com_content.php:125
9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:482
8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 1.22 ms Query memory: 0.026 MB Memory before query: 5.413 MB Rows returned: 1

SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM mdahc_content 
  WHERE `id`=189;

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/slugs.php:55
11	Sh404sefModelSlugs->getArticle()	JROOT/components/com_sh404sef/sef_ext.php:693
10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:145
9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:482
8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 0.37 ms Query memory: 0.032 MB Memory before query: 5.424 MB Rows returned: 1

SELECT * 
  FROM mdahc_categories 
  WHERE parent_id > 0 
  and extension = 'com_content' 
  and path = 'uncategorised' 
  and level = 1;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_categories	ref	cat_idx,idx_path	idx_path	402	const	6	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:628
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:442
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
11	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/components/com_sh404sef/sef_ext.php:707
10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:145
9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:482
8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 0.31 ms Query memory: 0.037 MB Memory before query: 5.503 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 `mdahc_categories` AS `s`

  INNER JOIN `mdahc_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND s.id = 41

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	57	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_sh404sef/models/slugs.php:161
13	Sh404sefModelSlugs->getCategory()	JROOT/administrator/components/com_sh404sef/models/slugs.php:199
12	Sh404sefModelSlugs->getCategoryPathArray()	JROOT/administrator/components/com_sh404sef/models/slugs.php:290
11	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:714
10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:145
9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:482
8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:229
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.27 ms After last query: 16.46 ms Query memory: 0.079 MB Memory before query: 5.762 MB Rows returned: 37

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

  FROM mdahc_modules AS m

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

  LEFT JOIN mdahc_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 <= '2019-05-21 06:25:03') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-05-21 06:25:03') 
  AND m.access IN (1,1,5,10) 
  AND m.client_id = 0 
  AND (mm.menuid = 653 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helixultimate/core/helixultimate.php:562
11	HelixUltimate->count_modules()	JROOT/plugins/system/helixultimate/core/helixultimate.php:370
10	HelixUltimate->get_current_row()	JROOT/plugins/system/helixultimate/core/helixultimate.php:304
9	HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/core/helixultimate.php:272
8	HelixUltimate->render_layout()	JROOT/templates/shaper_helixultimate/index.php:129
7	require JROOT/templates/shaper_helixultimate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 532.08 ms Query memory: 0.024 MB Memory before query: 5.838 MB Rows returned: 1

Duplicate queries: #50

SELECT 
				COUNT(network) AS cnt
				
  FROM `mdahc_cleantalk_sfw`
				
  WHERE network = 585452737 & mask

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:41
15	CleantalkSFW->unversal_query()	JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:88
14	CleantalkSFW->check_ip()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:1980
13	plgSystemAntispambycleantalk->sfw_check()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:743
12	plgSystemAntispambycleantalk->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->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: 0.05 ms Query memory: 0.025 MB Memory before query: 5.845 MB Rows returned: 1

Duplicate queries: #49

SELECT 
				COUNT(network) AS cnt
				
  FROM `mdahc_cleantalk_sfw`
				
  WHERE network = 585452737 & mask

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
16	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:49
15	CleantalkSFW->unversal_fetch()	JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:89
14	CleantalkSFW->check_ip()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:1980
13	plgSystemAntispambycleantalk->sfw_check()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:743
12	plgSystemAntispambycleantalk->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 5.853 MB Rows returned: 0

Duplicate queries: #52

SELECT * 
  FROM `mdahc_cleantalk_sfw_logs`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_cleantalk_sfw_logs	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:41
15	CleantalkSFW->unversal_query()	JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:190
14	CleantalkSFW->send_logs()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:1998
13	plgSystemAntispambycleantalk->sfw_check()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:743
12	plgSystemAntispambycleantalk->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 5.860 MB Rows returned: 0

Duplicate queries: #51

SELECT * 
  FROM `mdahc_cleantalk_sfw_logs`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdahc_cleantalk_sfw_logs	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:54
15	CleantalkSFW->unversal_fetch_all()	JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:191
14	CleantalkSFW->send_logs()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:1998
13	plgSystemAntispambycleantalk->sfw_check()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:743
12	plgSystemAntispambycleantalk->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.91 ms After last query: 0.26 ms Query memory: 0.032 MB Memory before query: 5.872 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `mdahc_extensions`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
16	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2010
14	plgSystemAntispambycleantalk->saveCTConfig()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2002
13	plgSystemAntispambycleantalk->sfw_check()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:743
12	plgSystemAntispambycleantalk->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 0.19 ms Query memory: 0.031 MB Memory before query: 5.917 MB Rows returned: 1

SELECT *

  FROM mdahc_extensions

  WHERE `extension_id` = '10139'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
15	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2011
14	plgSystemAntispambycleantalk->saveCTConfig()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2002
13	plgSystemAntispambycleantalk->sfw_check()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:743
12	plgSystemAntispambycleantalk->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.61 ms After last query: 0.20 ms Query memory: 0.008 MB Memory before query: 5.940 MB

UPDATE `mdahc_extensions` 
  SET `package_id`='0',`name`='PLG_SYSTEM_CLEANTALK_NAME',`type`='plugin',`element`='antispambycleantalk',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"PLG_SYSTEM_CLEANTALK_NAME\",\"type\":\"plugin\",\"creationDate\":\"01.12.2017\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"6.1\",\"description\":\"PLG_CLEANTALK_DESCRIPTION\",\"
  group\":\"\",\"filename\":\"antispambycleantalk\"}',`params`='{\"apikey\":\"syna2uvujaje\",\"check_register\":\"1\",\"general_contact_forms_test\":\"1\",\"sfw_enable\":\"1\",\"check_external\":\"1\",\"check_all_post\":\"1\",\"sfw_last_check\":1558346299,\"sfw_check_interval\":\"86400\",\"sfw_reload_timeout\":\"3\",\"sfw_last_send_log\":1558419904,\"server_url\":\"http:\\/\\/moderate.cleantalk.org\",\"work_url\":\"http:\\/\\/moderate6.cleantalk.org\",\"server_ttl\":1079,\"server_changed\":1558312991,\"user_token\":\"juQudu6ame7yMe3ujajy9umyWe3aBu5y\",\"service_id\":515782,\"spam_count\":138,\"show_notice\":0,\"renew\":0,\"trial\":0,\"show_review\":0,\"show_review_done\":\"0\",\"ip_license\":0,\"license_trial\":0,\"valid\":0,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"moderate_ip\":0,\"moderate\":1,\"acc_status_last_check\":1556256341,\"acc_status_check_interval\":\"86400\",\"ct_key_is_ok\":1,\"js_keys_store_days\":\"14\",\"js_key_lifetime\":\"86400\",\"groups\":[\"1\"],\"connection_reports\":{\"success\":347,\"negative\":0,\"negative_report\":null},\"js_keys\":{\"590635126\":1558415044}}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='22',`state`='0' 
  WHERE `extension_id` = '10139'

Explain

EXPLAIN not possible on query: UPDATE `mdahc_extensions` SET `package_id`='0',`name`='PLG_SYSTEM_CLEANTALK_NAME',`type`='plugin',`element`='antispambycleantalk',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"PLG_SYSTEM_CLEANTALK_NAME\",\"type\":\"plugin\",\"creationDate\":\"01.12.2017\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"6.1\",\"description\":\"PLG_CLEANTALK_DESCRIPTION\",\"group\":\"\",\"filename\":\"antispambycleantalk\"}',`params`='{\"apikey\":\"syna2uvujaje\",\"check_register\":\"1\",\"general_contact_forms_test\":\"1\",\"sfw_enable\":\"1\",\"check_external\":\"1\",\"check_all_post\":\"1\",\"sfw_last_check\":1558346299,\"sfw_check_interval\":\"86400\",\"sfw_reload_timeout\":\"3\",\"sfw_last_send_log\":1558419904,\"server_url\":\"http:\\/\\/moderate.cleantalk.org\",\"work_url\":\"http:\\/\\/moderate6.cleantalk.org\",\"server_ttl\":1079,\"server_changed\":1558312991,\"user_token\":\"juQudu6ame7yMe3ujajy9umyWe3aBu5y\",\"service_id\":515782,\"spam_count\":138,\"show_notice\":0,\"renew\":0,\"trial\":0,\"show_review\":0,\"show_review_done\":\"0\",\"ip_license\":0,\"license_trial\":0,\"valid\":0,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"moderate_ip\":0,\"moderate\":1,\"acc_status_last_check\":1556256341,\"acc_status_check_interval\":\"86400\",\"ct_key_is_ok\":1,\"js_keys_store_days\":\"14\",\"js_key_lifetime\":\"86400\",\"groups\":[\"1\"],\"connection_reports\":{\"success\":347,\"negative\":0,\"negative_report\":null},\"js_keys\":{\"590635126\":1558415044}}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='22',`state`='0' WHERE `extension_id` = '10139'

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2283
16	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:801
15	Joomla\CMS\Table\Table->store()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2016
14	plgSystemAntispambycleantalk->saveCTConfig()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2002
13	plgSystemAntispambycleantalk->sfw_check()	JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:743
12	plgSystemAntispambycleantalk->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.68 ms After last query: 0.26 ms Query memory: 0.026 MB Memory before query: 5.918 MB Rows returned: 0

SELECT *
 
  FROM mdahc_jmap_metainfo
 
  WHERE `linkurl` = 'https://tintplus.com.au/frosted-privacy-film/frosted-privacy-film-for-balcony-glass-balustrade-
  and-pool-fencing.html'
 
  AND `published` = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.94 ms After last query: 3.17 ms Query memory: 0.038 MB Memory before query: 6.113 MB Rows returned: 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 `mdahc_categories` AS `s`

  INNER JOIN `mdahc_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.12 ms After last query: 2.95 ms Query memory: 0.038 MB Memory before query: 6.186 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 `mdahc_categories` AS `s`

  INNER JOIN `mdahc_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	57	Using where; Using filesort

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

42 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT a.params 
  FROM mdahc_advancedtemplates AS a

4 × 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 `mdahc_categories` AS `s` 
  INNER JOIN `mdahc_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

2 × SELECT `oldurl`, `dateadd` 
  FROM mdahc_sh404sef_urls

2 × SELECT * 
  FROM `mdahc_cleantalk_sfw_logs

2 × SELECT      COUNT(network) AS cnt     
  FROM `mdahc_cleantalk_sfw`

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `mdahc_assets`

2 × SELECT id, ipaddress 
  from mdahc_bfstop_whitelist

2 × SELECT id, ipaddress, crdate, duration 
  FROM mdahc_bfstop_bannedip b

2 × SELECT `params` 
  FROM mdahc_extensions

1 × SELECT `data` 
  FROM `mdahc_session`

1 × SELECT * 
  FROM mdahc_sh404sef_metas

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM mdahc_content AS a 
  LEFT JOIN mdahc_categories AS cc 
  ON cc.id = a.catid

1 × SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM mdahc_content

1 × SELECT params 
  FROM mdahc_extensions AS e

1 × SELECT id,template 
  FROM mdahc_template_styles

```
1 × SELECT * 
  FROM mdahc_categories
```

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

```
1 × SELECT * 
  FROM mdahc_extensions
```

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, g.note as group_note 
  FROM mdahc_fields AS a 
  LEFT JOIN `mdahc_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN mdahc_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN mdahc_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN mdahc_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN mdahc_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `mdahc_fields_categories` AS fc 
  ON fc.field_id = a.id

```
1 × SELECT * 
  FROM mdahc_content
```

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `mdahc_contentitem_tag_map` AS m  
  INNER JOIN `mdahc_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM mdahc_content AS a 
  INNER JOIN mdahc_categories AS c 
  on c.id = a.catid 
  LEFT JOIN mdahc_users AS u 
  on u.id = a.created_by 
  LEFT JOIN mdahc_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN mdahc_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id` 
  FROM `mdahc_session`

1 × SELECT s.* 
  FROM mdahc_template_styles as s

1 × SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM mdahc_sh404sef_urls

1 × SELECT * 
  FROM mdahc_sh404sef_aliases

1 × SELECT * 
  FROM `mdahc_sh404sef_aliases`

```
1 × SELECT * 
  FROM mdahc_languages
```
```
1 × select email 
  from mdahc_users
```

1 × SELECT * 
  FROM mdahc_rsform_confi

1 × SELECT `enabled` 
  FROM `mdahc_extensions`

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

1 × SELECT id, rules 
  FROM `mdahc_viewlevels

1 × SELECT *  
  FROM mdahc_jmap_metainfo

OTHER Tables:

1 × INSERT INTO `mdahc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('de7d9a8a06284edb9053428b03b2b787', 1, 1558419903, 0, '', 0

1 × UPDATE `mdahc_sh404sef_urls` 
  SET `cpt`=612, `last_hit`='2019-05-21 06:25:03'

1 × UPDATE `mdahc_extensions` 
  SET `params` = '{\"mediaversion\":\"dd0a818ea292edf5b910587cadb4607c\"}'

1 × SHOW FULL COLUMNS 
  FROM `mdahc_content

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

1 × SHOW FULL COLUMNS 
  FROM `mdahc_sh404sef_metas

1 × SHOW FULL COLUMNS 
  FROM `mdahc_extensions

1 × UPDATE `mdahc_extensions` 
  SET `package_id`='0',`name`='PLG_SYSTEM_CLEANTALK_NAME',`type`='plugin',`element`='antispambycleantalk',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"PLG_SYSTEM_CLEANTALK_NAME\",\"type\":\"plugin\",\"creationDate\":\"01.12.2017\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"6.1\",\"description\":\"PLG_CLEANTALK_DESCRIPTION\",\"
  group\":\"\",\"filename\":\"antispambycleantalk\"}',`params`='{\"apikey\":\"syna2uvujaje\",\"check_register\":\"1\",\"general_contact_forms_test\":\"1\",\"sfw_enable\":\"1\",\"check_external\":\"1\",\"check_all_post\":\"1\",\"sfw_last_check\":1558346299,\"sfw_check_interval\":\"86400\",\"sfw_reload_timeout\":\"3\",\"sfw_last_send_log\":1558419904,\"server_url\":\"http:\\/\\/moderate.cleantalk.org\",\"work_url\":\"http:\\/\\/moderate6.cleantalk.org\",\"server_ttl\":1079,\"server_changed\":1558312991,\"user_token\":\"juQudu6ame7yMe3ujajy9umyWe3aBu5y\",\"service_id\":515782,\"spam_count\":138,\"show_notice\":0,\"renew\":0,\"trial\":0,\"show_review\":0,\"show_review_done\":\"0\",\"ip_license\":0,\"license_trial\":0,\"valid\":0,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"moderate_ip\":0,\"moderate\":1,\"acc_status_last_check\":1556256341,\"acc_status_check_interval\":\"86400\",\"ct_key_is_ok\":1,\"js_keys_store_days\":\"14\",\"js_key_lifetime\":\"86400\",\"groups\":[\"1\"],\"connection_reports\":{\"success\":347,\"negative\":0,\"negative_report\":null},\"js_keys\":{\"590635126\":1558415044}}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='22',`state`='0'

Frosted privacy film for balcony glass balustrade and pool fencing

Frosted Film for Pool Fencing

A glass pool fence is a stylish alternative to traditional pool fencing materials. Not only does it keep your family safe around the pool but provides you a clear view of the pool and its occupants.

Frosted film for the Glass Balustrade (Balcony Glass)

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

58 Queries Logged 56.73 ms

4 duplicate found!

42 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: