ALL THE REQUIRED DATA TO MONITOR EVERYTHING IN YOUR BUSINESS

A SMART TRANSACTION MONITORING SYSTEM

CleverEyelog

CleverEye is a unique business controling system, that not only records everything there is happening in your bussiness in a daily basis, it also depics in electronic form every receipt issue for your POS system.

CleverEye platform measures the productivity and the quallity of service that your bussiness deliver.

REVOLUTIONARY COVER OF AREA WITH ONLY ONE PANORAMIC CAMERA

A new company product is our unique 180o degrees panoramic cameras that are design to be perfect compatible with a CleverEye software.

Our revolutionary 180o degrees cameras with 2Mpixel resolution, combined with a digital zoom feuture, it allows you to survilance a bigger area than before only with one camera instead of two. This CleverEye unique feuture not only saving you money but also time because now you have to watch fewer cameras than before.

People Counting

Smart Shop

Measure exactly how many customers entry your shop in a daily basis, with a 98% accuracy in real time.

Discover your peak times, the customer circulation and the points of interest, meaning in which, points of your area your customers dwell and which products attract customers more.

People Counting

Lost Prevetion System Clevereye

Control

Check all transactions in cash or credit card, purchase, sales and production controls

Business Operations

Manage your business operation and the way customers behave inside your shop.

Troubleshooting and Support

Our company has a help line from 9:00 am to 17:00 pm

+302310555090

Theft prevention

Theft prevention inside the shop

Productivity

Manage your productivity rates and a the quallity of service your business deliver.

Multiviewing

Revolutionary surveillance of all your stores from a control room

Restriction

Restriction of loosing funds from the cashier by "friendly" sales

Excellent image and video quallity

Our surveillance system has top notch video and image quallity

All in one Solution

Clevereye not only secure the transactions inside your stores but it is also a CCTV System, People Counting System and much more.

CONTACT US FOR A OFFER TAILORED TO YOUR NEEDS

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 3.79 ms / 3.79 ms Memory: 0.195 MB / 0.40 MB Application: afterLoad

Time: 33.52 ms / 37.31 ms Memory: 2.644 MB / 3.05 MB Application: afterInitialise

Time: 11.67 ms / 48.98 ms Memory: 0.933 MB / 3.98 MB Application: afterRoute

Time: 0.53 ms / 49.51 ms Memory: 0.054 MB / 4.04 MB Application: beforeRenderComponent com_sppagebuilder

Time: 2.22 ms / 51.73 ms Memory: 0.319 MB / 4.35 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.26 ms / 51.99 ms Memory: 0.040 MB / 4.39 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.03 ms / 52.02 ms Memory: 0.000 MB / 4.39 MB Application: Start JAccess::preload(components)

Time: 2.12 ms / 54.13 ms Memory: 0.403 MB / 4.79 MB Application: Finish JAccess::preload(components)

Time: 16.24 ms / 70.37 ms Memory: 1.428 MB / 6.22 MB Application: beforeRenderModule mod_unite_revolution2 (Unite Responsive three)

Time: 4.13 ms / 74.50 ms Memory: 0.662 MB / 6.88 MB Application: afterRenderModule mod_unite_revolution2 (Unite Responsive three)

Time: 18.51 ms / 93.01 ms Memory: 0.026 MB / 6.91 MB Application: beforeRenderModule mod_visforms (CONTACT US FOR A OFFER TAILORED TO YOUR NEEDS)

Time: 4.03 ms / 97.04 ms Memory: 0.207 MB / 7.12 MB Application: New JAccess Preloading Process(com_visforms.visform)

Time: 0.29 ms / 97.33 ms Memory: 0.050 MB / 7.17 MB Application: After preloadPermissionsParentIdMapping (com_visforms.visform)

Time: 0.39 ms / 97.72 ms Memory: 0.069 MB / 7.23 MB Application: After preloadPermissions (com_visforms.visform)

Time: 0.01 ms / 97.73 ms Memory: 0.002 MB / 7.24 MB Application: End New JAccess Preloading Process(com_visforms.visform)

Time: 0.01 ms / 97.74 ms Memory: 0.002 MB / 7.24 MB Application: Start JAccess::getAssetRules New (com_visforms.visform.2)

Time: 0.05 ms / 97.79 ms Memory: 0.010 MB / 7.25 MB Application: Finish JAccess::getAssetRules New (com_visforms.visform.2)

Time: 11.83 ms / 109.62 ms Memory: 0.607 MB / 7.85 MB Application: afterRenderModule mod_visforms (CONTACT US FOR A OFFER TAILORED TO YOUR NEEDS)

Time: 0.88 ms / 110.50 ms Memory: 0.000 MB / 7.02 MB Application: afterRenderComponent com_sppagebuilder

Time: 2.21 ms / 112.71 ms Memory: 0.080 MB / 7.10 MB Application: afterDispatch

Time: 3.60 ms / 116.31 ms Memory: 0.182 MB / 7.28 MB Application: beforeRenderModule mod_custom (Copyrighten)

Time: 0.50 ms / 116.81 ms Memory: 0.012 MB / 7.29 MB Application: afterRenderModule mod_custom (Copyrighten)

Time: 0.08 ms / 116.88 ms Memory: 0.000 MB / 7.29 MB Application: beforeRenderModule mod_custom (Contact Info Top en)

Time: 0.13 ms / 117.02 ms Memory: 0.007 MB / 7.30 MB Application: afterRenderModule mod_custom (Contact Info Top en)

Time: 0.10 ms / 117.12 ms Memory: 0.017 MB / 7.31 MB Application: beforeRenderModule mod_flyout (Flyout Tabs)

Time: 0.31 ms / 117.43 ms Memory: 0.046 MB / 7.36 MB Application: afterRenderModule mod_flyout (Flyout Tabs)

Time: 0.04 ms / 117.47 ms Memory: 0.000 MB / 7.31 MB Application: beforeRenderModule mod_languages (Language)

Time: 0.99 ms / 118.46 ms Memory: 0.026 MB / 7.34 MB Application: afterRenderModule mod_languages (Language)

Time: 39.89 ms / 158.35 ms Memory: 0.389 MB / 7.73 MB Application: afterRender

Database queries total: 17.48 ms

Memory Usage

Database Queries

39 Queries Logged 17.48 ms

4 duplicate found!

4 duplicates: #28 #29 #30 #31

Query Time: 0.75 ms Query memory: 0.017 MB Memory before query: 0.892 MB Rows returned: 0

SELECT `data`

  FROM `p69ev_session`

  WHERE `session_id` = 'kk7fufhldh632ggpe7efvonss6'

Explain

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

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.06 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.59 ms After last query: 0.53 ms Query memory: 0.010 MB Memory before query: 0.956 MB Rows returned: 0

SELECT `session_id`

  FROM `p69ev_session`

  WHERE `session_id` = 'kk7fufhldh632ggpe7efvonss6' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 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
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.10 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.12 ms

Call Stack

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

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

Query Time: 0.79 ms After last query: 0.12 ms Query memory: 0.009 MB Memory before query: 0.971 MB

INSERT INTO `p69ev_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('kk7fufhldh632ggpe7efvonss6', 0, 1, '1571697406', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `p69ev_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('kk7fufhldh632ggpe7efvonss6', 0, 1, '1571697406', 0, '')

Profile

Status	Duration
starting	0.16 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
update	0.20 ms
Waiting for query cache lock	0.01 ms
update	0.05 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.14 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.11 ms After last query: 1.15 ms Query memory: 0.012 MB Memory before query: 1.028 MB Rows returned: 41

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

  FROM `p69ev_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_extensions	ref	extension	extension	82	const	41	100.00	Using index condition

Profile

Status	Duration
starting	0.12 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.13 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.33 ms
Waiting for query cache lock	0.01 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.11 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.14 ms After last query: 1.00 ms Query memory: 0.014 MB Memory before query: 1.107 MB Rows returned: 2

SELECT b.id

  FROM p69ev_usergroups AS a

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

  WHERE a.id = 13

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.08 ms After last query: 0.29 ms Query memory: 0.012 MB Memory before query: 1.128 MB Rows returned: 5

SELECT id, rules

  FROM `p69ev_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.77 ms After last query: 0.11 ms Query memory: 0.010 MB Memory before query: 1.146 MB Rows returned: 77

SELECT folder AS type, element AS name, params

  FROM p69ev_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_extensions	ref	extension	extension	82	const	106	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.04 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
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.40 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.04 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.13 ms After last query: 6.22 ms Query memory: 0.012 MB Memory before query: 1.777 MB Rows returned: 2

SELECT *

  FROM p69ev_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:97
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.20 ms Query memory: 0.012 MB Memory before query: 1.800 MB Rows returned: 2

SELECT element

  FROM p69ev_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_extensions	ref	extension	extension	82	const	4	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 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
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.57 ms After last query: 4.75 ms Query memory: 0.022 MB Memory before query: 2.352 MB Rows returned: 1

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	6	100.00	Using where

Profile

Status	Duration
starting	0.15 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache 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.03 ms
Waiting for query cache lock	0.01 ms
Sending data	0.01 ms
storing result in query cache	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
17	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Container.php:240
16	YOOtheme\Widgetkit\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
15	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
14	call_user_func_array()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113
13	YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:149
12	YOOtheme\Widgetkit\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:92
11	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
10	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
9	plgSystemWidgetkit->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 1.27 ms Query memory: 0.031 MB Memory before query: 2.468 MB Rows returned: 36

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM p69ev_menu AS m

  LEFT JOIN p69ev_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 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
Waiting for query cache lock	0.02 ms
init	0.08 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.27 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
26	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
25	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
24	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
23	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
22	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
21	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
14	JHtmlBehavior::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
11	JHtml::_()	JROOT/plugins/system/niceslideshowlite/niceslideshowlite.php:105
10	plgSystemNiceSlideShowCore->onAfterInitialise()	JROOT/plugins/system/niceslideshowlite/niceslideshow-lib/helpers/niceslideshowlite.php:9
9	plgSystemNiceSlideShowLite->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.99 ms Query memory: 0.024 MB Memory before query: 2.822 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM p69ev_template_styles as s

  LEFT JOIN p69ev_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	100.00	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where

Profile

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 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
Waiting for query cache lock	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
14	JHtmlBehavior::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
11	JHtml::_()	JROOT/plugins/system/niceslideshowlite/niceslideshowlite.php:105
10	plgSystemNiceSlideShowCore->onAfterInitialise()	JROOT/plugins/system/niceslideshowlite/niceslideshow-lib/helpers/niceslideshowlite.php:9
9	plgSystemNiceSlideShowLite->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.46 ms Query memory: 0.031 MB Memory before query: 2.879 MB Rows returned: 1

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

  FROM `p69ev_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 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
Waiting for query cache lock	0.08 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.12 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
27	JDatabaseDriver->loadObject()	Same as call in the line below.
26	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
25	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
24	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
23	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
22	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
21	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
20	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
19	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:705
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
14	JHtmlBehavior::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
11	JHtml::_()	JROOT/plugins/system/niceslideshowlite/niceslideshowlite.php:105
10	plgSystemNiceSlideShowCore->onAfterInitialise()	JROOT/plugins/system/niceslideshowlite/niceslideshow-lib/helpers/niceslideshowlite.php:9
9	plgSystemNiceSlideShowLite->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.53 ms After last query: 0.18 ms Query memory: 0.027 MB Memory before query: 2.895 MB

UPDATE `p69ev_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
23	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
22	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
21	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
20	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
19	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:705
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
14	JHtmlBehavior::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
11	JHtml::_()	JROOT/plugins/system/niceslideshowlite/niceslideshowlite.php:105
10	plgSystemNiceSlideShowCore->onAfterInitialise()	JROOT/plugins/system/niceslideshowlite/niceslideshow-lib/helpers/niceslideshowlite.php:9
9	plgSystemNiceSlideShowLite->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 15.16 ms Query memory: 0.029 MB Memory before query: 4.274 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `p69ev_assets`

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.00 ms
Opening tables	0.12 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.03 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.34 ms Query memory: 0.024 MB Memory before query: 4.335 MB Rows returned: 1

SELECT *

  FROM p69ev_assets

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_assets	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.06 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 4.357 MB Rows returned: 1

SELECT a.rules

  FROM p69ev_assets AS a

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.23 ms Query memory: 0.024 MB Memory before query: 4.393 MB Rows returned: 41

SELECT element

  FROM p69ev_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_extensions	ref	extension	extension	82	const	41	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.09 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.07 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 4.427 MB Rows returned: 41

SELECT a.name, a.rules

  FROM p69ev_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_ose_firewall','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_tcpdf','com_templates','com_uniterevolution2','com_users','com_virtuemart_allinone','com_visforms','com_widgetkit','com_wrapper') OR a.name = 'root.1')

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.70 ms After last query: 1.59 ms Query memory: 0.017 MB Memory before query: 4.790 MB Rows returned: 1

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

  FROM p69ev_sppagebuilder as a

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

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

  WHERE a.id = 127 
  AND a.published = 1 
  AND a.language in ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered
1	SIMPLE	a	const	PRIMARY	PRIMARY	8	const	1	100.00
1	SIMPLE	l	const	idx_langcode	idx_langcode	28	const	1	100.00
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.31 ms
Waiting for query cache lock	0.00 ms
Sending data	0.01 ms
Waiting for query cache lock	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
12	SppagebuilderModelPage->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.28 ms Query memory: 0.022 MB Memory before query: 4.909 MB Rows returned: 23

SHOW FULL COLUMNS 
  FROM `p69ev_sppagebuilder`

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.02 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
13	SppagebuilderTablePage->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:176
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 0.26 ms Query memory: 0.017 MB Memory before query: 4.985 MB Rows returned: 1

SELECT *

  FROM p69ev_sppagebuilder

  WHERE `id` = '127'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.01 ms
Sending data	0.42 ms
Waiting for query cache lock	0.00 ms
Sending data	0.05 ms
Waiting for query cache lock	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.01 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_sppagebuilder/models/page.php:177
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.24 ms Query memory: 0.016 MB Memory before query: 5.077 MB

UPDATE p69ev_sppagebuilder

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

  WHERE `id` = '127'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_sppagebuilder	range	PRIMARY	PRIMARY	8	NULL	1	100.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.03 ms
updating	0.08 ms
end	0.00 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
12	JTable->hit()	JROOT/components/com_sppagebuilder/models/page.php:178
11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 3.53 ms Query memory: 0.018 MB Memory before query: 5.259 MB Rows returned: 1

SELECT `template`

  FROM `p69ev_template_styles`

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_sppagebuilder/helpers/helper.php:32
12	SppagebuilderHelperSite::getTemplate()	JROOT/components/com_sppagebuilder/helpers/helper.php:19
11	SppagebuilderHelperSite::loadLanguage()	JROOT/components/com_sppagebuilder/views/page/view.html.php:40
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 8.71 ms Query memory: 0.022 MB Memory before query: 6.189 MB Rows returned: 1

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

  FROM p69ev_modules AS m

  WHERE m.published = 1 
  AND m.id = 193 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-10-21 22:36:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-10-21 22:36:46') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND m.language IN ('en-GB','*')

Explain

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

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	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
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 1.67 ms Query memory: 0.031 MB Memory before query: 6.669 MB Rows returned: 1

select * 
  from p69ev_revslider_sliders 
  where id=9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_revslider_sliders	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:223
21	UniteDBRev->fetchSingle()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:76
20	RevSlider->initByID()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:119
19	RevSlider->initByMixed()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:1909
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.32 ms Query memory: 0.032 MB Memory before query: 6.727 MB Rows returned: 1

select * 
  from p69ev_revslider_slides 
  where slider_id=9 
  order by slide_order

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 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
Waiting for query cache lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
24	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
23	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1575
22	RevSlider->getSlidesFromGallery()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1468
21	RevSlider->getSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1654
20	RevSlider->getSlidesForOutput()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:260
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.16 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 6.770 MB Rows returned: 4

Duplicate queries: #29 #30 #31

select * 
  from p69ev_revslider_layer_animations

Explain

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

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.12 ms Query memory: 0.031 MB Memory before query: 6.803 MB Rows returned: 4

Duplicate queries: #28 #30 #31

select * 
  from p69ev_revslider_layer_animations

Explain

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

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.10 ms After last query: 0.13 ms Query memory: 0.031 MB Memory before query: 6.834 MB Rows returned: 4

Duplicate queries: #28 #29 #31

select * 
  from p69ev_revslider_layer_animations

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.09 ms After last query: 0.10 ms Query memory: 0.031 MB Memory before query: 6.866 MB Rows returned: 4

Duplicate queries: #28 #29 #30

select * 
  from p69ev_revslider_layer_animations

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178
23	UniteDBRev->fetchSql()	JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213
22	UniteDBRev->fetch()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533
21	RevOperations::getCustomAnimations()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687
20	RevSliderOutput->putCreativeLayer()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654
19	RevSliderOutput->putSlides()	JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162
18	RevSliderOutput->putSliderBase()	JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:82
17	include JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 18.25 ms Query memory: 0.022 MB Memory before query: 6.883 MB Rows returned: 1

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

  FROM p69ev_modules AS m

  WHERE m.published = 1 
  AND m.id = 209 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-10-21 22:36:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-10-21 22:36:46') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND m.language IN ('en-GB','*')

Explain

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

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.03 ms
updating status	0.00 ms
Waiting for query cache lock	0.00 ms
updating status	0.03 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
16	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 2.75 ms Query memory: 0.028 MB Memory before query: 7.022 MB Rows returned: 1

SELECT * 
  FROM p69ev_visforms 
  where id=2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_visforms	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.06 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
20	JDatabaseDriver->loadObject()	JROOT/components/com_visforms/models/visforms.php:262
19	VisformsModelVisforms->getForm()	JROOT/modules/mod_visforms/helper.php:24
18	modVisformsHelper::getForm()	JROOT/modules/mod_visforms/mod_visforms.php:24
17	include JROOT/modules/mod_visforms/mod_visforms.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.78 ms Query memory: 0.031 MB Memory before query: 7.121 MB Rows returned: 20

SELECT a.id, a.parent_id

  FROM p69ev_assets AS a

  WHERE (a.name LIKE 'com_visforms.%' OR a.name = 'com_visforms' OR a.id = 1)

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
23	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
22	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
20	JUser->authorise()	JROOT/administrator/components/com_visforms/helpers/visforms.php:65
19	VisformsHelper::getActions()	JROOT/modules/mod_visforms/helper.php:37
18	modVisformsHelper::getForm()	JROOT/modules/mod_visforms/mod_visforms.php:24
17	include JROOT/modules/mod_visforms/mod_visforms.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 7.181 MB Rows returned: 20

SELECT a.id, a.name, a.rules

  FROM p69ev_assets AS a

  WHERE (a.name LIKE 'com_visforms.%' OR a.name = 'com_visforms' OR a.id = 1 )

Explain

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

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
24	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
23	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
22	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
20	JUser->authorise()	JROOT/administrator/components/com_visforms/helpers/visforms.php:65
19	VisformsHelper::getActions()	JROOT/modules/mod_visforms/helper.php:37
18	modVisformsHelper::getForm()	JROOT/modules/mod_visforms/mod_visforms.php:24
17	include JROOT/modules/mod_visforms/mod_visforms.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.34 ms Query memory: 0.029 MB Memory before query: 7.242 MB Rows returned: 8

SELECT *

  FROM `p69ev_visfields`

  WHERE `fid` = 2 
  AND `published` = 1 
  AND not `editonlyfield` = 1 
  AND `typefield` in ('text','password','email','date','number','url','hidden','checkbox','multicheckbox','radio','select','file','image','submit','reset','fieldsep','textarea')

  ORDER BY `ordering` asc

Explain

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

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.07 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
22	JModelLegacy->_getList()	JROOT/components/com_visforms/models/visforms.php:398
21	VisformsModelVisforms->getItems()	JROOT/components/com_visforms/models/visforms.php:414
20	VisformsModelVisforms->getValidatedFields()	JROOT/components/com_visforms/models/visforms.php:557
19	VisformsModelVisforms->getFields()	JROOT/modules/mod_visforms/helper.php:61
18	modVisformsHelper::getForm()	JROOT/modules/mod_visforms/mod_visforms.php:24
17	include JROOT/modules/mod_visforms/mod_visforms.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
16	JModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
15	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:267
14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:80
13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 11.92 ms Query memory: 0.013 MB Memory before query: 7.027 MB Rows returned: 3

SELECT language,id

  FROM `p69ev_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p69ev_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	42	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.45 ms Query memory: 0.014 MB Memory before query: 7.063 MB Rows returned: 2

SELECT `c2`.`language`,`c2`.`id`

  FROM `p69ev_menu` AS `c`

  INNER JOIN `p69ev_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `p69ev_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `p69ev_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 828

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	100.00	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	cle10992_cleverdatabasefinal.a2.id	1	100.00

Profile

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 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
Waiting for query cache lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.04 ms
freeing items	0.05 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
10	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
8	PlgSystemLanguageFilter->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.25 ms After last query: 1.96 ms Query memory: 0.024 MB Memory before query: 7.230 MB Rows returned: 17

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

  FROM p69ev_modules AS m

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

  LEFT JOIN p69ev_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-10-21 22:36:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-10-21 22:36:46') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 828 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	29	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	cle10992_cleverdatabasefinal.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	cle10992_cleverdatabasefinal.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 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
Waiting for query cache lock	0.02 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.53 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.07 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
17	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:446
16	JModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:382
15	JModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:84
14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:678
12	T3Template->checkSpotlight()	JROOT/templates/itl_mark/tpls/blocks/top-header.php:11
11	include JROOT/templates/itl_mark/tpls/blocks/top-header.php	JROOT/plugins/system/t3/includes/core/template.php:195
10	T3Template->loadBlock()	JROOT/templates/itl_mark/tpls/alternative-1.php:38
9	include JROOT/templates/itl_mark/tpls/alternative-1.php	JROOT/plugins/system/t3/includes/core/template.php:221
8	T3Template->loadLayout()	JROOT/templates/itl_mark/index.php:41
7	require JROOT/templates/itl_mark/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × select * 
  from p69ev_revslider_layer_animation

2 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params 
  FROM p69ev_modules AS m

2 × SELECT element 
  FROM p69ev_extensions

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

1 × select * 
  from p69ev_revslider_slides

1 × select * 
  from p69ev_revslider_sliders

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

1 × SELECT `template` 
  FROM `p69ev_template_styles`

```
1 × SELECT * 
  FROM p69ev_visforms
```

1 × SELECT a.id, a.parent_id 
  FROM p69ev_assets AS a

1 × SELECT language,id 
  FROM `p69ev_menu`

1 × SELECT * 
  FROM `p69ev_visfields`

1 × SELECT a.id, a.name, a.rules 
  FROM p69ev_assets AS a

1 × SELECT * 
  FROM p69ev_sppagebuilder

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `p69ev_menu` AS `c` 
  INNER JOIN `p69ev_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `p69ev_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `p69ev_menu` AS `c2` 
  ON a2.id = c2.`id`

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

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

```
1 × SELECT * 
  FROM p69ev_languages
```

1 × SELECT id, rules 
  FROM `p69ev_viewlevels

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

1 × SELECT `session_id` 
  FROM `p69ev_session`

1 × SELECT id,template 
  FROM p69ev_template_styles

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

1 × SELECT `data` 
  FROM `p69ev_session`

1 × SELECT a.rules 
  FROM p69ev_assets AS a

```
1 × SELECT * 
  FROM p69ev_assets
```

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

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

OTHER Tables:

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

1 × SHOW FULL COLUMNS 
  FROM `p69ev_sppagebuilder

1 × SHOW FULL COLUMNS 
  FROM `p69ev_assets

1 × UPDATE `p69ev_extensions` 
  SET `params` = '{\"mediaversion\":\"f66efdfe351363126af4d77144c6b88b\"}'

1 × INSERT INTO `p69ev_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('kk7fufhldh632ggpe7efvonss6', 0, 1, '1571697406', 0, ''

ALL THE REQUIRED DATA TO MONITOR EVERYTHING IN YOUR BUSINESS

A SMART TRANSACTION MONITORING SYSTEM

REVOLUTIONARY COVER OF AREA WITH ONLY ONE PANORAMIC CAMERA

People Counting

People Counting

CLEVEREYE BUSINESS CONTROLLING PLATFORM

Lost Prevetion System Clevereye

REASONS TO PURCHASE CLEVEREYE SMART PLATFORM TODAY

Control

Business Operations

Troubleshooting and Support

Theft prevention

Productivity

Multiviewing

Restriction

Excellent image and video quallity

All in one Solution

CONTACT US FOR A OFFER TAILORED TO YOUR NEEDS

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

39 Queries Logged 17.48 ms

4 duplicate found!

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: