JOHN WILSON MEDIA

TV Video Production | Commercial Video/ Photography | Aerial Photography/Video | International Photojournalist & Cameraman

CONTACT JOHN - T: +61 0419716107 E: This email address is being protected from spambots. You need JavaScript enabled to view it.

All images are Copyrighted to Photographer John Wilson

International Photojournalism Blog Here

See Our INSTAGRAM Feed HERE

Bundaberg photographers, Hervey Bay photographers, Gladstone photographers for real estate photography services including aerial photography and International photographer and cameraman Asia South Pacific

MEDIA SERVICES

Get in touch for professional photography Hervey Bay or photographer services in Maryborough, Bundaberg, Gladstone or Rockhampton. We also offer Sunshine Coast, Maroochydore, Noosa Heads and Mary Valley Gympie photography and video services. Commercial photography and video services for business marketing, promotions of services and products.

We also offer commercial video production for Hervey Bay, video production in Bundaberg and Gladstone for real estate and commercial properties. You can also use our photography and video services in the South Burnett, Chinchilla, Miles and Roma areas.

Internationally we can film breaking news stories throughout Asia and South Pacific using the latest broadcast equipment and live broadcast facility.

Owner John Wilson is an International Photographer and Master News Photojournalist. You can read about his travels documenting stories around the world via the link below.

PLEASE VISIT OUR BLOG FOR STORIES FROM THE FIELD, TRAVEL TIPS AND INFORMATION HERE

We are Bundaberg photographers, Hervey Bay photographers, Gladstone photographers for real estate photography services including aerial photography and International photographer and cameraman Asia South Pacific

Regional centres serviced in Queensland Australia for video production, aerial photography and commercial photography

John Wilson Media professional photography and video services for Hervey Bay Maryborough, Bundaberg and Gympie photographers. Also working throughout SE Queensland in the Burnett, Western Downs, Maranoa, and Capricorn region. Some of the towns serviced for professional photography and aerial photography include Biloela, Gladstone, Rockhampton, Emerald, Chinchilla, Roma, Kingaroy, Agnes Water, 1770, and Dalby to name a few.

Drone photography Hervey Bay and Bundaberg is also offered as part of our aerial photography services in the Wide Bay and Burnett region

Commercial Photography

Commercial Photography for business and events

Real Estate Photography Hervey Bay Bundaberg Maryborough

Real estate photography and aerial photography, drone photographer. Real estate floor plans. Walkthrough video.

Get in touch for professional photography Hervey Bay or photographer services in Maryborough, Bundaberg, Gladstone or Rockhampton. We also operate in the Sunshine Coast, Maroochydore, Noosa Heads and Mary Valley Gympie region. Commercial photography and video services for business marketing, promotions of services and products.

Video production services videography

Video Production services for business. Product reviews, business introduction videos. Breaking News coverage and Live Broadcast facility throughout QLD

Comments closed!

About us

John Wilson Media is operated by Professional Photographer and Videographer John Wilson.

John is a career professional and a master news photojournalist with 25+years experience nationally and internationally with both print and broadcast media.

READ MORE

Contact us

Johnwilsonmedia.com

P.O. Box 672

Hervey Bay, QLD 4655

and Goodwood Rd, Bundaberg, Q

+61 0419716107

info@johnwilsonmedia.com

Mo-Fr: 08.00 - 18.00 GMT+10

Joomla! Debug Console

Session

{"__default":{"session":{"counter":1,"timer":{"start":1498682993,"last":1498682993,"now":1498682993}},"registry":{"separator":"."},"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: 6.69 ms / 6.69 ms Memory: 1.178 MB / 1.78 MB Application: afterLoad

Time: 86.35 ms / 93.03 ms Memory: 9.999 MB / 11.78 MB Application: afterInitialise

Time: 14.24 ms / 107.28 ms Memory: 1.738 MB / 13.51 MB Application: afterRoute

Time: 4.81 ms / 112.08 ms Memory: 0.525 MB / 14.04 MB Application: beforeRenderComponent com_content

Time: 3.08 ms / 115.16 ms Memory: 0.563 MB / 14.60 MB Application: Before JAccess::preloadComponents (all components)

Time: 1.65 ms / 116.80 ms Memory: 0.094 MB / 14.70 MB Application: After JAccess::preloadComponents (all components)

Time: 0.05 ms / 116.85 ms Memory: 0.000 MB / 14.69 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Time: 0.60 ms / 117.45 ms Memory: 0.065 MB / 14.76 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Time: 52.46 ms / 169.91 ms Memory: 7.041 MB / 21.80 MB Application: afterRenderComponent com_content

Time: 0.80 ms / 170.71 ms Memory: 0.010 MB / 21.81 MB Application: afterDispatch

Time: 5.04 ms / 175.75 ms Memory: 0.579 MB / 22.39 MB Application: beforeRenderModule mod_custom (About us)

Time: 1.02 ms / 176.77 ms Memory: 0.054 MB / 22.44 MB Application: afterRenderModule mod_custom (About us)

Time: 0.07 ms / 176.84 ms Memory: 0.000 MB / 22.44 MB Application: beforeRenderModule mod_custom (Contact us)

Time: 0.35 ms / 177.19 ms Memory: 0.008 MB / 22.44 MB Application: afterRenderModule mod_custom (Contact us)

Time: 4.79 ms / 181.98 ms Memory: 0.259 MB / 22.70 MB Application: beforeRenderModule mod_custom (Logo Desktop)

Time: 5.26 ms / 187.24 ms Memory: 1.092 MB / 23.80 MB Application: afterRenderModule mod_custom (Logo Desktop)

Time: 0.65 ms / 187.90 ms Memory: 0.000 MB / 23.79 MB Application: beforeRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Time: 105.08 ms / 292.98 ms Memory: 5.681 MB / 29.47 MB Application: afterRenderModule mod_extrawatch_agent (ExtraWatch Agent Module)

Time: 0.15 ms / 293.12 ms Memory: 0.000 MB / 29.47 MB Application: beforeRenderModule mod_smartslider3 (John Wilson Media photography and video)

Time: 0.30 ms / 293.43 ms Memory: 0.009 MB / 29.48 MB Application: afterRenderModule mod_smartslider3 (John Wilson Media photography and video)

Time: 1.95 ms / 295.38 ms Memory: 0.000 MB / 29.48 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 12.49 ms / 307.87 ms Memory: 0.316 MB / 29.80 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 6.97 ms / 314.83 ms Memory: 0.437 MB / 30.23 MB Application: beforeRenderModule mod_custom (Logo Mobile)

Time: 0.47 ms / 315.30 ms Memory: 0.008 MB / 30.24 MB Application: afterRenderModule mod_custom (Logo Mobile)

Time: 1.98 ms / 317.29 ms Memory: 0.000 MB / 30.24 MB Application: beforeRenderModule mod_custom (Social)

Time: 0.34 ms / 317.63 ms Memory: 0.008 MB / 30.25 MB Application: afterRenderModule mod_custom (Social)

Time: 0.74 ms / 318.38 ms Memory: 0.000 MB / 30.25 MB Application: beforeRenderModule mod_menu (Main Menu Offcanvas)

Time: 2.69 ms / 321.07 ms Memory: 0.014 MB / 30.26 MB Application: afterRenderModule mod_menu (Main Menu Offcanvas)

Time: 82.34 ms / 403.41 ms Memory: 11.082 MB / 41.35 MB Application: afterRender

Database queries total: 96.52 ms

Memory Usage

Database Queries

48 Queries Logged 96.52 ms

6 duplicate found!

2 duplicates: #9 #10

2 duplicates: #14 #16

2 duplicates: #37 #38

Query Time: 0.24 ms Query memory: 0.008 MB Memory before query: 5.147 MB

DELETE 

  FROM `s5mza_session`

  WHERE `time` < '1498682093'

Explain

EXPLAIN not possible on query: DELETE FROM `s5mza_session` WHERE `time` < '1498682093'

Profile

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

Call Stack

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

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

Query Time: 0.21 ms After last query: 0.35 ms Query memory: 0.019 MB Memory before query: 5.186 MB Rows returned: 0

SELECT `data`

  FROM `s5mza_session`

  WHERE `session_id` = 'a932a5794e6f053d6b5af2c3bcc12cd5'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 0.13 ms After last query: 1.14 ms Query memory: 0.011 MB Memory before query: 5.394 MB Rows returned: 0

SELECT `session_id`

  FROM `s5mza_session`

  WHERE `session_id` = 'a932a5794e6f053d6b5af2c3bcc12cd5' 
  LIMIT 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.26 ms After last query: 0.17 ms Query memory: 0.009 MB Memory before query: 5.408 MB

INSERT INTO `s5mza_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('a932a5794e6f053d6b5af2c3bcc12cd5', 1, '1498682993', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `s5mza_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('a932a5794e6f053d6b5af2c3bcc12cd5', 1, '1498682993', 0, '', 0)

Profile

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

Call Stack

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

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

Query Time: 0.32 ms After last query: 2.08 ms Query memory: 0.013 MB Memory before query: 5.840 MB Rows returned: 40

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

  FROM `s5mza_extensions`

  WHERE `type` = 'component'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.34 ms After last query: 2.08 ms Query memory: 0.014 MB Memory before query: 6.260 MB Rows returned: 1

SELECT b.id

  FROM s5mza_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.21 ms After last query: 0.57 ms Query memory: 0.013 MB Memory before query: 6.394 MB Rows returned: 3

SELECT id, rules

  FROM `s5mza_viewlevels`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.01 ms After last query: 0.24 ms Query memory: 0.013 MB Memory before query: 6.458 MB Rows returned: 65

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

  FROM s5mza_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_extensions	ref	extension	extension	82	const	81	Using where; Using filesort

Profile

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

Call Stack

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

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

Query Time: 0.28 ms After last query: 12.77 ms Query memory: 0.018 MB Memory before query: 8.156 MB Rows returned: 1

Duplicate queries: #10

SELECT template

  FROM s5mza_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.15 ms Query memory: 0.019 MB Memory before query: 8.175 MB Rows returned: 1

Duplicate queries: #9

SELECT template

  FROM s5mza_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 4.43 ms Query memory: 0.013 MB Memory before query: 8.620 MB Rows returned: 2

SELECT extension, file, type

  FROM s5mza_rokcommon_configs

  ORDER BY priority

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 10.49 ms Query memory: 0.019 MB Memory before query: 10.615 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `s5mza_extensions`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
11	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:46
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.78 ms Query memory: 0.015 MB Memory before query: 10.713 MB Rows returned: 1

SELECT `extension_id`

  FROM `s5mza_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:120
10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:50
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.27 ms After last query: 0.21 ms Query memory: 0.015 MB Memory before query: 10.730 MB Rows returned: 1

Duplicate queries: #16

SELECT *

  FROM s5mza_extensions

  WHERE `extension_id` = '10057'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:55
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.19 ms Query memory: 0.015 MB Memory before query: 10.744 MB Rows returned: 1

SELECT `extension_id`

  FROM `s5mza_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:120
10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:73
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.18 ms After last query: 0.21 ms Query memory: 0.015 MB Memory before query: 10.759 MB Rows returned: 1

Duplicate queries: #14

SELECT *

  FROM s5mza_extensions

  WHERE `extension_id` = '10057'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:77
9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.13 ms After last query: 24.62 ms Query memory: 0.023 MB Memory before query: 12.229 MB Rows returned: 30

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

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

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

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.33 ms
Sending data	0.35 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.44 ms After last query: 11.55 ms Query memory: 0.018 MB Memory before query: 13.602 MB Rows returned: 1

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

  FROM `s5mza_extensions`

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.43 ms After last query: 0.27 ms Query memory: 0.012 MB Memory before query: 13.579 MB

UPDATE `s5mza_extensions`

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

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.22 ms After last query: 1.87 ms Query memory: 0.010 MB Memory before query: 14.002 MB Rows returned: 1

SELECT *

  FROM s5mza_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.45 ms After last query: 0.43 ms Query memory: 0.008 MB Memory before query: 14.029 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM s5mza_template_styles as s

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

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

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.16 ms After last query: 3.56 ms Query memory: 0.023 MB Memory before query: 14.609 MB Rows returned: 40

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

  FROM `s5mza_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extrawatch','com_finder','com_installer','com_jce','com_joomlaupdate','com_jxtcvtubepro','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_redirect','com_roksprocket','com_rsblog','com_rscomments','com_rsform','com_search','com_smartslider3','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.21 ms After last query: 1.73 ms Query memory: 0.020 MB Memory before query: 14.865 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `s5mza_content`

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.33 ms After last query: 3.36 ms Query memory: 0.016 MB Memory before query: 15.352 MB Rows returned: 1

SELECT *

  FROM s5mza_content

  WHERE `id` = '53'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.27 ms After last query: 0.26 ms Query memory: 0.014 MB Memory before query: 15.370 MB

UPDATE s5mza_content

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

  WHERE `id` = '53'

Explain

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

Profile

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

Call Stack

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

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

Query Time: 0.69 ms After last query: 2.24 ms Query memory: 0.018 MB Memory before query: 15.662 MB Rows returned: 1

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

  FROM s5mza_content AS a

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

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

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

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

  WHERE a.id = 53 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-28 20:49:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-28 20:49:54') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.17 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
Opening tables	0.03 ms
System lock	0.01 ms
init	0.07 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 0.65 ms After last query: 3.94 ms Query memory: 0.028 MB Memory before query: 16.076 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM s5mza_categories as c

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

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

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.07 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.06 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.47 ms After last query: 0.99 ms Query memory: 0.017 MB Memory before query: 16.128 MB Rows returned: 0

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

  FROM `s5mza_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	1	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	johnwils_media.t.id	1	Using where

Profile

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

Call Stack

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

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

Query Time: 0.47 ms After last query: 28.85 ms Query memory: 0.021 MB Memory before query: 21.064 MB Rows returned: 1

SELECT `params`

  FROM `s5mza_extensions`

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_rscomments/helpers/rscomments.php:33
15	RSCommentsHelper::getConfig()	JROOT/plugins/content/rscomments/rscomments.php:40
14	plgContentRSComments->onContentAfterDisplay()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.35 ms Query memory: 0.021 MB Memory before query: 21.109 MB Rows returned: 1

SELECT `content`

  FROM `s5mza_rscomments_messages`

  WHERE `tag` = 'en-GB' 
  AND `type` = 'comments_closed'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_rscomments/helpers/rscomments.php:1390
15	RSCommentsHelper::getMessage()	JROOT/plugins/content/rscomments/rscomments.php:98
14	plgContentRSComments->onContentAfterDisplay()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.97 ms After last query: 10.54 ms Query memory: 0.024 MB Memory before query: 22.339 MB Rows returned: 25

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

  FROM s5mza_modules AS m

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

  LEFT JOIN s5mza_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 <= '2017-06-28 20:49:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-06-28 20:49:54') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	10	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	johnwils_media.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	johnwils_media.m.module,const	1	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	0.50 ms
Sending data	0.93 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
12	JDocumentHtml->countModules()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/jp-adventures/layouts/theme.config.php:28
10	include JROOT/templates/jp-adventures/layouts/theme.config.php	JROOT/templates/jp-adventures/layouts/theme.php:10
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.79 ms After last query: 35.16 ms Query memory: 0.029 MB Memory before query: 29.186 MB Rows returned: 64

select name, value 
  from s5mza_extrawatch_config 
  order by value

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:95
21	ExtraWatchDBWrapJoomla->objectListQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.config.php:116
20	ExtraWatchConfig->reloadConfigValues()	JROOT/components/com_extrawatch/src/class.extrawatch.config.php:131
19	ExtraWatchConfig->getConfigValue()	JROOT/components/com_extrawatch/src/class.extrawatch.config.php:181
18	ExtraWatchConfig->getLanguage()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:50
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 2.27 ms Query memory: 0.029 MB Memory before query: 29.352 MB Rows returned: 1

select count(ip) as count 
  from s5mza_extrawatch_blocked 
  where ip = '107.22.17.220' 
  limit 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:76
21	ExtraWatchDBWrapJoomla->resultQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.block.php:77
20	ExtraWatchBlock->searchBlockedIp()	JROOT/components/com_extrawatch/src/class.extrawatch.block.php:110
19	ExtraWatchBlock->getBlockedIp()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:437
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.24 ms After last query: 0.17 ms Query memory: 0.029 MB Memory before query: 29.382 MB Rows returned: 1

select count(ip) as count 
  from s5mza_extrawatch_blocked 
  where ip like '107.22.17.*%' 
  limit 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_extrawatch_blocked	range	ip_2,ip	ip_2	768	NULL	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:76
21	ExtraWatchDBWrapJoomla->resultQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.block.php:100
20	ExtraWatchBlock->searchBlockedIpWildcard()	JROOT/components/com_extrawatch/src/class.extrawatch.block.php:117
19	ExtraWatchBlock->getBlockedIp()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:437
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 29.411 MB Rows returned: 1

select count(ip) as count 
  from s5mza_extrawatch_blocked 
  where ip like '107.22.*%' 
  limit 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_extrawatch_blocked	range	ip_2,ip	ip_2	768	NULL	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:76
21	ExtraWatchDBWrapJoomla->resultQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.block.php:100
20	ExtraWatchBlock->searchBlockedIpWildcard()	JROOT/components/com_extrawatch/src/class.extrawatch.block.php:121
19	ExtraWatchBlock->getBlockedIp()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:437
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 29.440 MB Rows returned: 1

select count(ip) as count 
  from s5mza_extrawatch_blocked 
  where ip like '107.*%' 
  limit 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_extrawatch_blocked	range	ip_2,ip	ip_2	768	NULL	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:76
21	ExtraWatchDBWrapJoomla->resultQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.block.php:100
20	ExtraWatchBlock->searchBlockedIpWildcard()	JROOT/components/com_extrawatch/src/class.extrawatch.block.php:125
19	ExtraWatchBlock->getBlockedIp()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:437
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.20 ms Query memory: 0.029 MB Memory before query: 29.469 MB Rows returned: 1

Duplicate queries: #38

select id 
  from s5mza_extrawatch 
  where ip = '107.22.17.220' 
  limit 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_extrawatch	ref	ip	ip	768	const	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:76
21	ExtraWatchDBWrapJoomla->resultQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:1500
20	ExtraWatchVisit->checkIfVisitAlreadyInserted()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:1466
19	ExtraWatchVisit->insertBotVisit()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:450
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.15 ms After last query: 0.16 ms Query memory: 0.028 MB Memory before query: 29.499 MB Rows returned: 1

Duplicate queries: #37

select id 
  from s5mza_extrawatch 
  where ip = '107.22.17.220' 
  limit 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_extrawatch	ref	ip	ip	768	const	1	Using where; Using index

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:95
20	ExtraWatchDBWrapJoomla->objectListQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:1478
19	ExtraWatchVisit->insertBotVisit()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:450
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 75.11 ms After last query: 0.11 ms Query memory: 0.026 MB Memory before query: 29.527 MB

insert into s5mza_extrawatch_uri (fk, timestamp, uri, title) 
  values ('4262', '1498682994', '/', '')

Explain

EXPLAIN not possible on query: insert into s5mza_extrawatch_uri (fk, timestamp, uri, title) values ('4262', '1498682994', '/', '')

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:45
20	ExtraWatchDBWrapJoomla->executeQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:1484
19	ExtraWatchVisit->insertBotVisit()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:450
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.43 ms Query memory: 0.030 MB Memory before query: 29.554 MB Rows returned: 1

select id 
  from s5mza_extrawatch_uri 
  where uri = '/' 
  order by id desc 
  limit 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_extrawatch_uri	index	NULL	PRIMARY	4	NULL	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
23	JDatabaseDriver->loadResult()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:76
22	ExtraWatchDBWrapJoomla->resultQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:1596
21	ExtraWatchVisit->getUriIdByUri()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:1575
20	ExtraWatchVisit->savePostParams()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:1487
19	ExtraWatchVisit->insertBotVisit()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:450
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 0.37 ms Query memory: 0.028 MB Memory before query: 29.582 MB Rows returned: 0

select * 
  from s5mza_extrawatch_goals

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_extrawatch/src/env/joomla/class.extrawatch.db.joomla.php:95
20	ExtraWatchDBWrapJoomla->objectListQuery()	JROOT/components/com_extrawatch/src/class.extrawatch.goal.php:163
19	ExtraWatchGoal->checkGoals()	JROOT/components/com_extrawatch/src/class.extrawatch.visit.php:453
18	ExtraWatchVisit->insertVisit()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:59
17	renderExtraWatchAgent()	JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php:85
16	include JROOT/modules/mod_extrawatch_agent/mod_extrawatch_agent.php	JROOT/libraries/cms/module/helper.php:198
15	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
14	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/jp-adventures/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-adventures/layouts/theme.php:92
9	include JROOT/templates/jp-adventures/layouts/theme.php	JROOT/templates/jp-adventures/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-adventures/index.php:16
7	require JROOT/templates/jp-adventures/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 39.36 ms Query memory: 0.031 MB Memory before query: 31.624 MB Rows returned: 0

SELECT `id`,`referencekey`,`value`,`system`,`editable`

  FROM `s5mza_nextend2_section_storage`

  WHERE `application` = 'system' 
  AND `section` = 'global'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_nextend2_section_storage	ref	application,application_2	application	160	const,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
26	JDatabaseDriver->loadAssocList()	JROOT/libraries/nextend2/nextend/joomla/libraries/mvc/db.php:122
25	N2DBConnector->findAllByAttributes()	JROOT/libraries/nextend2/nextend/library/libraries/storage/section.php:72
24	N2StorageSectionAdmin::getAll()	JROOT/libraries/nextend2/nextend/library/settings.php:23
23	N2Settings::init()	JROOT/libraries/nextend2/nextend/library/settings.php:59
22	require_once JROOT/libraries/nextend2/nextend/library/settings.php	JROOT/libraries/nextend2/nextend/library/loader.php:45
21	N2Loader::importPath()	JROOT/libraries/nextend2/nextend/library/loader.php:23
20	N2Loader::import()	JROOT/libraries/nextend2/nextend/library/library.php:39
19	require_once JROOT/libraries/nextend2/nextend/library/library.php	JROOT/libraries/nextend2/nextend/joomla/library.php:18
18	include_once JROOT/libraries/nextend2/nextend/joomla/library.php	JROOT/libraries/loader.php:226
17	JLoader::import()	JROOT/libraries/loader.php:758
16	jimport()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:58
15	nextend_smartslider3()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:45
14	plgSystemNextendSmartslider3->prepare()	Same as call in the line below.
13	preg_replace_callback()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:31
12	plgSystemNextendSmartslider3->onNextendBeforeCompileHead()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/plugins/system/nextend2/nextend2.php:29
8	plgSystemNextend2->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 36.58 ms Query memory: 0.035 MB Memory before query: 38.835 MB Rows returned: 0

SELECT `id`,`referencekey`,`value`,`system`,`editable`

  FROM `s5mza_nextend2_section_storage`

  WHERE `application` = 'system' 
  AND `section` = 'fonts'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_nextend2_section_storage	ref	application,application_2	application	160	const,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
29	JDatabaseDriver->loadAssocList()	JROOT/libraries/nextend2/nextend/joomla/libraries/mvc/db.php:122
28	N2DBConnector->findAllByAttributes()	JROOT/libraries/nextend2/nextend/library/libraries/storage/section.php:72
27	N2StorageSectionAdmin::getAll()	JROOT/libraries/nextend2/nextend/library/libraries/fonts/fonts.php:17
26	N2Fonts::loadSettings()	JROOT/libraries/nextend2/nextend/library/libraries/fonts/fonts.php:47
25	require_once JROOT/libraries/nextend2/nextend/library/libraries/fonts/fonts.php	JROOT/libraries/nextend2/nextend/library/loader.php:45
24	N2Loader::importPath()	JROOT/libraries/nextend2/nextend/library/loader.php:23
23	N2Loader::import()	JROOT/libraries/nextend2/nextend/library/libraries/assets/predefined.php:60
22	N2AssetsPredefined::frontend()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/controller.php:38
21	N2ControllerAbstract->initialize()	JROOT/libraries/nextend2/smartslider/smartslider/widget/controllers/Home.php:7
20	N2SmartSliderWidgetHomeController->initialize()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/controller.php:30
19	N2ControllerAbstract->__construct()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:174
18	N2ApplicationType->createControllerObject()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:93
17	N2ApplicationType->run()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:184
16	N2ApplicationType->render()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:69
15	nextend_smartslider3()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:45
14	plgSystemNextendSmartslider3->prepare()	Same as call in the line below.
13	preg_replace_callback()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:31
12	plgSystemNextendSmartslider3->onNextendBeforeCompileHead()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/plugins/system/nextend2/nextend2.php:29
8	plgSystemNextend2->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.28 ms After last query: 15.66 ms Query memory: 0.043 MB Memory before query: 41.246 MB Rows returned: 1

SELECT *

  FROM `s5mza_nextend2_section_storage`

  WHERE `application` = 'smartslider' 
  AND `section` = 'sliderChanged' 
  AND `referencekey` = 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s5mza_nextend2_section_storage	ref	application,application_2	application	160	const,const	1	Using where

Profile

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

Call Stack

#	Caller	File and line number
37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
36	JDatabaseDriver->loadAssoc()	JROOT/libraries/nextend2/nextend/joomla/libraries/mvc/db.php:73
35	N2DBConnector->findByAttributes()	JROOT/libraries/nextend2/nextend/library/libraries/storage/section.php:183
34	N2StorageSection->get()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/helper.php:27
33	N2SmartSliderHelper->isSliderChanged()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/cache/slider.php:28
32	N2CacheManifestSlider->isCacheValid()	JROOT/libraries/nextend2/nextend/library/libraries/cache/manifest.php:33
31	N2CacheManifest->isCached()	JROOT/libraries/nextend2/nextend/library/libraries/cache/manifest.php:14
30	N2CacheManifest->makeCache()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/cache/slider.php:18
29	N2CacheManifestSlider->makeCache()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:45
28	N2SmartSliderManager->cacheSlider()	JROOT/libraries/nextend2/smartslider/smartslider/libraries/slider/manager.php:35
27	N2SmartSliderManager->render()	JROOT/libraries/nextend2/smartslider/smartslider/widget/views/home/joomla.phtml:4
26	include JROOT/libraries/nextend2/smartslider/smartslider/widget/views/home/joomla.phtml	JROOT/libraries/nextend2/nextend/library/libraries/mvc/view.php:55
25	N2View->renderInline()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:81
24	N2Layout->renderFragmentBlock()	JROOT/libraries/nextend2/smartslider/smartslider/widget/layouts/default.phtml:4
23	include JROOT/libraries/nextend2/smartslider/smartslider/widget/layouts/default.phtml	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:53
22	N2Layout->renderLayout()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/layout.php:72
21	N2Layout->render()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/controller.php:69
20	N2ControllerAbstract->render()	JROOT/libraries/nextend2/smartslider/smartslider/widget/controllers/Home.php:26
19	N2SmartSliderWidgetHomeController->actionJoomla()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:96
17	N2ApplicationType->run()	JROOT/libraries/nextend2/nextend/library/libraries/mvc/application/type.php:184
16	N2ApplicationType->render()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:69
15	nextend_smartslider3()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:45
14	plgSystemNextendSmartslider3->prepare()	Same as call in the line below.
13	preg_replace_callback()	JROOT/plugins/system/nextendsmartslider3/nextendsmartslider3.php:31
12	plgSystemNextendSmartslider3->onNextendBeforeCompileHead()	Same as call in the line below.
11	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
10	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
9	JEventDispatcher->trigger()	JROOT/plugins/system/nextend2/nextend2.php:29
8	plgSystemNextend2->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 11.70 ms Query memory: 0.025 MB Memory before query: 41.286 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM s5mza_categories as c

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

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

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
18	JCategories->get()	JROOT/components/com_content/router.php:70
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.23 ms After last query: 0.54 ms Query memory: 0.022 MB Memory before query: 41.314 MB Rows returned: 1

SELECT `alias`

  FROM `s5mza_content`

  WHERE id = '65'

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System 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.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:123
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.52 ms After last query: 0.26 ms Query memory: 0.025 MB Memory before query: 41.343 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM s5mza_categories as c

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

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

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
18	JCategories->get()	JROOT/components/com_content/router.php:70
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.14 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 41.367 MB Rows returned: 1

SELECT alias

  FROM s5mza_content

  WHERE id=65

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/cms/component/router/view.php:241
14	JComponentRouterView->build()	JROOT/libraries/cms/router/site.php:519
13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
8	PlgSystemSef->onAfterRender()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1118
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × select count(ip) as count 
  from s5mza_extrawatch_blocked

3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM s5mza_categories as c 
  LEFT JOIN s5mza_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

```
2 × SELECT * 
  FROM s5mza_extensions
```

2 × SELECT template 
  FROM s5mza_template_styles as s

2 × select id 
  from s5mza_extrawatch

2 × SELECT `extension_id` 
  FROM `s5mza_extensions`

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

2 × SELECT `id`,`referencekey`,`value`,`system`,`editable` 
  FROM `s5mza_nextend2_section_storage`

1 × select name, value 
  from s5mza_extrawatch_config

1 × SELECT `content` 
  FROM `s5mza_rscomments_messages`

1 × SELECT alias 
  FROM s5mza_content

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

1 × SELECT `alias` 
  FROM `s5mza_content`

1 × select * 
  from s5mza_extrawatch_goal

1 × SELECT `params` 
  FROM `s5mza_extensions`

1 × SELECT * 
  FROM `s5mza_nextend2_section_storage`

1 × select id 
  from s5mza_extrawatch_uri

```
1 × SELECT * 
  FROM s5mza_content
```

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

1 × SELECT extension, file, type 
  FROM s5mza_rokcommon_configs

1 × SELECT id, rules 
  FROM `s5mza_viewlevels

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

1 × SELECT `session_id` 
  FROM `s5mza_session`

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

```
1 × SELECT * 
  FROM s5mza_languages
```

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

1 × SELECT `data` 
  FROM `s5mza_session`

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

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

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

OTHER Tables:

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

1 × insert into s5mza_extrawatch_uri (fk, timestamp, uri, title) 
  values ('4262', '1498682994', '/', ''

1 × SHOW FULL COLUMNS 
  FROM `s5mza_content

1 × UPDATE `s5mza_extensions` 
  SET `params` = '{\"mediaversion\":\"b1d8fb0c5527caa74950d2f280432378\"}'

1 × INSERT INTO `s5mza_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('a932a5794e6f053d6b5af2c3bcc12cd5', 1, '1498682993', 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `s5mza_extensions

```
1 × DELETE  
  FROM `s5mza_session`
```