Konsola diagnostyczna Joomla!

Informacje o wydajności

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.345 MB / 0.34 MB Application: afterLoad

Time: 35.9 ms / 35.9 ms Memory: 1.864 MB / 2.21 MB Application: afterInitialise

Time: 21.6 ms / 57.5 ms Memory: 1.783 MB / 3.99 MB Application: afterRoute

Time: 18.4 ms / 75.9 ms Memory: 0.672 MB / 4.66 MB Application: afterDispatch

Time: 6.9 ms / 82.8 ms Memory: 0.226 MB / 4.89 MB Application: beforeRenderModule mod_acymailing (NEWSLETTER)

Time: 8.2 ms / 90.9 ms Memory: 0.537 MB / 5.43 MB Application: afterRenderModule mod_acymailing (NEWSLETTER)

Time: 0.1 ms / 91.0 ms Memory: 0.000 MB / 5.40 MB Application: beforeRenderModule mod_menu (INFORMACJE)

Time: 3.5 ms / 94.5 ms Memory: 0.089 MB / 5.49 MB Application: afterRenderModule mod_menu (INFORMACJE)

Time: 0.1 ms / 94.6 ms Memory: 0.000 MB / 5.49 MB Application: beforeRenderModule mod_menu (MENU UŻYTKOWNIKA)

Time: 18.9 ms / 113.4 ms Memory: 0.983 MB / 6.47 MB Application: afterRenderModule mod_menu (MENU UŻYTKOWNIKA)

Time: 0.1 ms / 113.5 ms Memory: 0.000 MB / 6.47 MB Application: beforeRenderModule mod_custom (SZYBKI KONTAKT)

Time: 1.5 ms / 115.0 ms Memory: 0.010 MB / 6.48 MB Application: afterRenderModule mod_custom (SZYBKI KONTAKT)

Time: 0.1 ms / 115.1 ms Memory: 0.000 MB / 6.47 MB Application: beforeRenderModule mod_custom (PDF)

Time: 0.4 ms / 115.5 ms Memory: 0.006 MB / 6.48 MB Application: afterRenderModule mod_custom (PDF)

Time: 0.1 ms / 115.5 ms Memory: 0.000 MB / 6.48 MB Application: beforeRenderModule mod_breadcrumbs (BREADCRUMBS)

Time: 2.0 ms / 117.5 ms Memory: 0.020 MB / 6.50 MB Application: afterRenderModule mod_breadcrumbs (BREADCRUMBS)

Time: 0.1 ms / 117.6 ms Memory: 0.000 MB / 6.49 MB Application: beforeRenderModule mod_virtuemart_search (SZUKAJ)

Time: 3.7 ms / 121.3 ms Memory: 0.111 MB / 6.61 MB Application: afterRenderModule mod_virtuemart_search (SZUKAJ)

Time: 0.1 ms / 121.4 ms Memory: 0.000 MB / 6.60 MB Application: beforeRenderModule mod_languages (JĘZYKI)

Time: 3.2 ms / 124.6 ms Memory: 0.130 MB / 6.73 MB Application: afterRenderModule mod_languages (JĘZYKI)

Time: 0.1 ms / 124.7 ms Memory: 0.005 MB / 6.74 MB Application: beforeRenderModule mod_js_social_tabs_slider (Techto.pl)

Time: 0.5 ms / 125.2 ms Memory: 0.025 MB / 6.76 MB Application: afterRenderModule mod_js_social_tabs_slider (Techto.pl)

Time: 0.1 ms / 125.2 ms Memory: 0.000 MB / 6.75 MB Application: beforeRenderModule mod_running_text (TEXT PL)

Time: 0.2 ms / 125.4 ms Memory: 0.013 MB / 6.77 MB Application: afterRenderModule mod_running_text (TEXT PL)

Time: 106.6 ms / 232.0 ms Memory: 0.350 MB / 7.12 MB Application: afterRender

Database queries total: 26.4 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_session	const	PRIMARY	PRIMARY	602	const	1

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

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

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

EXPLAIN not possible on query: UPDATE `shop_extensions` SET `params` = '{\"mediaversion\":\"320270dafff2f19d6de8394c8fb8f67f\",\"Array\":[\"6b0c230dba445a8e246bba39cf1fa577\"]}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.0 ms
Updating	0.1 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/library/helper.php:119

JROOT/libraries/cms/version/version.php:230

JROOT/libraries/cms/version/version.php:189

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/ytshortcodes/ytshortcodes.php:32

JROOT/libraries/cms/plugin/helper.php:257

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:582

JROOT/libraries/cms/application/site.php:649

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.55 ms After last query: 4.69 ms Query memory: 0.028 MB Memory before query: 1.976 MB Rows returned: 1

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

  FROM shop_extensions

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

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/plugins/system/k2/k2.php:435

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:583

JROOT/libraries/cms/application/site.php:649

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 2.49 ms After last query: 3.08 ms Query memory: 0.043 MB Memory before query: 2.232 MB Rows returned: 119

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

  LEFT JOIN shop_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	119	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	serwer100271_techt2.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.7 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.3 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.3 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.2 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.3 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:353

JROOT/libraries/cms/application/site.php:279

JROOT/libraries/cms/router/site.php:218

JROOT/libraries/cms/router/router.php:408

JROOT/libraries/cms/router/router.php:192

JROOT/libraries/cms/router/site.php:90

JROOT/libraries/cms/application/cms.php:1018

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.62 ms After last query: 6.74 ms Query memory: 0.018 MB Memory before query: 3.606 MB Rows returned: 9

SELECT id, home, template, s.params

  FROM shop_template_styles as s

  LEFT JOIN shop_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	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	9	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	152	serwer100271_techt2.e.element	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.1 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
Waiting for query cache lock	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/cms/application/site.php:486

JROOT/plugins/system/t3/includes/core/t3.php:308

JROOT/plugins/system/t3/t3.php:81

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.69 ms After last query: 9.77 ms Query memory: 0.022 MB Memory before query: 3.957 MB Rows returned: 1

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

  FROM shop_extensions

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

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.2 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:13

JROOT/plugins/system/rokcandy/rokcandy.php:28

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.46 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 3.981 MB Rows returned: 35

SELECT * 
  FROM shop_rokcandy 
  WHERE published=1

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/joomla/cache/controller/callback.php:43

JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17

JROOT/plugins/system/rokcandy/rokcandy.php:28

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.51 ms After last query: 0.37 ms Query memory: 0.016 MB Memory before query: 4.015 MB Rows returned: 1

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

  FROM shop_extensions

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

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:328

JROOT/libraries/cms/application/site.php:135

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.67 ms After last query: 7.05 ms Query memory: 0.022 MB Memory before query: 4.453 MB Rows returned: 1

SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias 
  FROM shop_phocadownload_categories AS cc 
  LEFT JOIN shop_phocadownload_categories AS pc 
  ON pc.id = cc.parent_id 
  WHERE  cc.id= 1 
  AND  cc.access IN (1,1) 
  AND  cc.published = 1 
  AND  cc.language IN ('pl-PL','*') 
  ORDER BY cc.ordering 
  LIMIT 0, 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	pc	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.1 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.2 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/legacy/model/legacy.php:301

JROOT/components/com_phocadownload/models/category.php:79

JROOT/components/com_phocadownload/views/category/view.html.php:34

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_phocadownload/controller.php:34

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_phocadownload/phocadownload.php:52

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 1.62 ms After last query: 0.25 ms Query memory: 0.020 MB Memory before query: 4.475 MB Rows returned: 0

SELECT  cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc 
  FROM shop_phocadownload_categories AS cc 
  LEFT JOIN shop_phocadownload AS c 
  ON c.catid = cc.id 
  AND c.published = 1 
  AND c.textonly = 0 
  WHERE  cc.parent_id = 1 
  AND  cc.access IN (1,1) 
  AND  cc.published = 1 
  AND  cc.language IN ('pl-PL','*') 
  GROUP BY cc.id 
  ORDER BY cc.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	index	idx_access	PRIMARY	4	NULL	18	Using where; Using temporary; Using filesort
1	SIMPLE	c	ref	catid	catid	5	serwer100271_techt2.cc.id,const	5	Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.1 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting for group	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.7 ms
Creating sort index	0.0 ms
Removing tmp table	0.2 ms
Creating sort index	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/legacy/model/legacy.php:301

JROOT/components/com_phocadownload/models/category.php:87

JROOT/components/com_phocadownload/views/category/view.html.php:35

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_phocadownload/controller.php:34

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_phocadownload/phocadownload.php:52

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.83 ms After last query: 0.16 ms Query memory: 0.033 MB Memory before query: 4.496 MB Rows returned: 0

SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
  FROM shop_phocadownload AS c 
  LEFT JOIN shop_phocadownload_categories AS cc 
  ON cc.id = c.catid 
  WHERE  c.catid= 1 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND c.access IN (1,1) ) ) 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND cc.access IN (1,1) ) ) 
  AND  c.published = 1 
  AND  c.approved = 1 
  AND  cc.published = 1 
  AND  c.language IN ('pl-PL','*') 
  AND  cc.language IN ('pl-PL','*') 
  AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-12-09 11:43:35' ) 
  AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-12-09 11:43:35' ) 
  ORDER BY c.ordering ASC 
  LIMIT 0, 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	c	ref	catid	catid	5	const,const	1	Using where; Using filesort

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/legacy/model/legacy.php:301

JROOT/components/com_phocadownload/models/category.php:71

JROOT/components/com_phocadownload/views/category/view.html.php:36

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_phocadownload/controller.php:34

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_phocadownload/phocadownload.php:52

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.88 ms After last query: 0.31 ms Query memory: 0.033 MB Memory before query: 4.539 MB Rows returned: 0

SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
  FROM shop_phocadownload AS c 
  LEFT JOIN shop_phocadownload_categories AS cc 
  ON cc.id = c.catid 
  WHERE  c.catid= 1 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND c.access IN (1,1) ) ) 
  AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
  AND cc.access IN (1,1) ) ) 
  AND  c.published = 1 
  AND  c.approved = 1 
  AND  cc.published = 1 
  AND  c.language IN ('pl-PL','*') 
  AND  cc.language IN ('pl-PL','*') 
  AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2023-12-09 11:43:35' ) 
  AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2023-12-09 11:43:35' ) 
  ORDER BY c.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	c	ref	catid	catid	5	const,const	1	Using where; Using filesort

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/legacy/model/legacy.php:332

JROOT/components/com_phocadownload/models/category.php:63

JROOT/components/com_phocadownload/models/category.php:55

JROOT/components/com_phocadownload/views/category/view.html.php:37

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_phocadownload/controller.php:34

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_phocadownload/phocadownload.php:52

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.46 ms After last query: 0.21 ms Query memory: 0.019 MB Memory before query: 4.562 MB Rows returned: 3

SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM shop_phocadownload_styles AS a 
  WHERE a.published = 1 
  ORDER BY a.type, a.ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.4 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_phocadownload/libraries/phocadownload/render/renderfront.php:22

JROOT/components/com_phocadownload/views/category/view.html.php:39

JROOT/libraries/legacy/controller/legacy.php:693

JROOT/components/com_phocadownload/controller.php:34

JROOT/libraries/legacy/controller/legacy.php:730

JROOT/components/com_phocadownload/phocadownload.php:52

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 1.08 ms After last query: 8.29 ms Query memory: 0.026 MB Memory before query: 4.815 MB Rows returned: 10

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

  FROM shop_modules AS m

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

  LEFT JOIN shop_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 <= '2023-12-09 11:43:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-09 11:43:35') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 346 OR mm.menuid <= 0) 
  AND m.language IN ('pl-PL','*')

  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,idx_language	published	1	const	72	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	serwer100271_techt2.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	serwer100271_techt2.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.5 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102

JROOT/libraries/joomla/document/html/html.php:510

JROOT/plugins/system/t3/includes/core/template.php:656

JROOT/templates/t3_bs3_blank/tpls/blocks/topheader.php:15

JROOT/plugins/system/t3/includes/core/template.php:195

JROOT/templates/t3_bs3_blank/tpls/boxedLeftSidebar.php:38

JROOT/plugins/system/t3/includes/core/template.php:219

JROOT/templates/t3_bs3_blank/index.php:34

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:974

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.73 ms After last query: 8.63 ms Query memory: 0.024 MB Memory before query: 5.255 MB Rows returned: 132

SELECT * 
  FROM shop_acymailing_config

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.2 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_acymailing/classes/cpanel.php:17

JROOT/administrator/components/com_acymailing/helpers/helper.php:402

JROOT/administrator/components/com_acymailing/helpers/helper.php:862

JROOT/modules/mod_acymailing/mod_acymailing.php:12

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.34 ms After last query: 0.76 ms Query memory: 0.022 MB Memory before query: 5.415 MB Rows returned: 1

SELECT * 
  FROM shop_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_acymailing/classes/list.php:29

JROOT/modules/mod_acymailing/mod_acymailing.php:117

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.33 ms After last query: 2.21 ms Query memory: 0.031 MB Memory before query: 5.466 MB Rows returned: 1

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

  FROM shop_extensions

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

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/components/com_content/router.php:37

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/modules/mod_menu/helper.php:125

JROOT/modules/mod_menu/mod_menu.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.40 ms After last query: 4.96 ms Query memory: 0.033 MB Memory before query: 6.029 MB Rows returned: 1

SELECT a.rules

  FROM shop_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Explain

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

Profile

Status	Duration
Starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/user/user.php:364

JROOT/administrator/components/com_virtuemart/helpers/config.php:522

JROOT/administrator/components/com_virtuemart/helpers/config.php:504

JROOT/administrator/components/com_virtuemart/helpers/config.php:780

JROOT/components/com_virtuemart/router.php:704

JROOT/components/com_virtuemart/router.php:27

JROOT/libraries/cms/component/router/legacy.php:70

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/modules/mod_menu/helper.php:125

JROOT/modules/mod_menu/mod_menu.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 1.68 ms After last query: 0.36 ms Query memory: 0.034 MB Memory before query: 6.072 MB Rows returned: 2

SELECT b.rules

  FROM shop_assets AS a

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

  WHERE (a.name = 'com_virtuemart')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	133	Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.7 ms
Creating sort index	0.1 ms
Removing tmp table	0.3 ms
Creating sort index	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/access/access.php:109

JROOT/libraries/joomla/user/user.php:373

JROOT/administrator/components/com_virtuemart/helpers/config.php:522

JROOT/administrator/components/com_virtuemart/helpers/config.php:504

JROOT/administrator/components/com_virtuemart/helpers/config.php:780

JROOT/components/com_virtuemart/router.php:704

JROOT/components/com_virtuemart/router.php:27

JROOT/libraries/cms/component/router/legacy.php:70

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/modules/mod_menu/helper.php:125

JROOT/modules/mod_menu/mod_menu.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 1.52 ms After last query: 0.81 ms Query memory: 0.029 MB Memory before query: 6.145 MB Rows returned: 1

SHOW TABLES LIKE "shop_virtuemart_configs"

Explain

EXPLAIN not possible on query: SHOW TABLES LIKE "shop_virtuemart_configs"

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Filling schema table	0.0 ms
checking permissions	1.2 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Removing tmp table	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/models/config.php:479

JROOT/administrator/components/com_virtuemart/helpers/config.php:783

JROOT/components/com_virtuemart/router.php:704

JROOT/components/com_virtuemart/router.php:27

JROOT/libraries/cms/component/router/legacy.php:70

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/modules/mod_menu/helper.php:125

JROOT/modules/mod_menu/mod_menu.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.39 ms After last query: 0.14 ms Query memory: 0.028 MB Memory before query: 6.174 MB Rows returned: 1

SELECT `config` 
  FROM `shop_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_virtuemart/helpers/config.php:827

JROOT/components/com_virtuemart/router.php:704

JROOT/components/com_virtuemart/router.php:27

JROOT/libraries/cms/component/router/legacy.php:70

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/modules/mod_menu/helper.php:125

JROOT/modules/mod_menu/mod_menu.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.40 ms After last query: 6.33 ms Query memory: 0.035 MB Memory before query: 6.319 MB Rows returned: 1

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

  FROM shop_extensions

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

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/components/com_virtuemart/router.php:973

JROOT/components/com_virtuemart/router.php:686

JROOT/components/com_virtuemart/router.php:706

JROOT/components/com_virtuemart/router.php:27

JROOT/libraries/cms/component/router/legacy.php:70

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/modules/mod_menu/helper.php:125

JROOT/modules/mod_menu/mod_menu.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.73 ms After last query: 0.15 ms Query memory: 0.036 MB Memory before query: 6.333 MB Rows returned: 9

SELECT * 
  FROM `shop_menu`  
  where `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "pl-PL"  )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	219	Using where

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.4 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_virtuemart/router.php:984

JROOT/components/com_virtuemart/router.php:686

JROOT/components/com_virtuemart/router.php:706

JROOT/components/com_virtuemart/router.php:27

JROOT/libraries/cms/component/router/legacy.php:70

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/modules/mod_menu/helper.php:125

JROOT/modules/mod_menu/mod_menu.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.53 ms After last query: 12.07 ms Query memory: 0.019 MB Memory before query: 6.648 MB Rows returned: 0

SELECT m2.language, m2.id

  FROM shop_menu as m

  INNER JOIN shop_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN shop_associations as a2 
  ON a.key=a2.key

  INNER JOIN shop_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=346

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.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.1 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.2 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_menus/helpers/menus.php:257

JROOT/modules/mod_languages/helper.php:58

JROOT/modules/mod_languages/mod_languages.php:18

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.57 ms After last query: 4.35 ms Query memory: 0.027 MB Memory before query: 6.950 MB Rows returned: 1

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

  FROM shop_extensions

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

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.1 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/components/com_contact/router.php:37

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/plugins/system/t3/includes/menu/megamenu.php:162

JROOT/plugins/system/t3/includes/renderer/megamenurender.php:84

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.85 ms After last query: 86.52 ms Query memory: 0.014 MB Memory before query: 7.092 MB Rows returned: 1

Duplicate queries: #38

select id, password 
  from shop_users as u join shop_user_usergroup_map as m 
  on u.id = m.user_id  
  where m.group_id in(8)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	u	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	12
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	8	serwer100271_techt2.u.id,const	1	Using where; Using index

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
Waiting for query cache lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Waiting for query cache lock	0.0 ms
Updating status	0.0 ms
Storing result in query cache	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/spadaj/spadaj.php:147

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:994

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

[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.04 ms Query memory: 0.014 MB Memory before query: 7.105 MB Rows returned: 1

Duplicate queries: #37

select id, password 
  from shop_users as u join shop_user_usergroup_map as m 
  on u.id = m.user_id  
  where m.group_id in(8)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	u	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	12
1	SIMPLE	m	eq_ref	PRIMARY	PRIMARY	8	serwer100271_techt2.u.id,const	1	Using where; Using index

Profile

Status	Duration
Starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
Checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
Sending cached result to clien	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/spadaj/spadaj.php:148

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:994

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.54 ms After last query: 16.46 ms Query memory: 0.003 MB Memory before query: 7.119 MB

UPDATE `shop_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1702122215;s:18:\"session.timer.last\";i:1702122215;s:17:\"session.timer.now\";i:1702122215;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"124cb2bcca7e4178696e9b9aca7049a8\";}'
	, `time` = '1702122215'

  WHERE `session_id` = 'iadb1pfhsrbbb8kgd2bn663ee3'

Explain

EXPLAIN not possible on query: UPDATE `shop_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1702122215;s:18:\"session.timer.last\";i:1702122215;s:17:\"session.timer.now\";i:1702122215;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"124cb2bcca7e4178696e9b9aca7049a8\";}' , `time` = '1702122215' WHERE `session_id` = 'iadb1pfhsrbbb8kgd2bn663ee3'

Profile

Status	Duration
Starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.1 ms
Updating	0.1 ms
End of update loop	0.0 ms
Waiting for query cache lock	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:85

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

29 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

9 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM shop_extensions

2 × select id, password 
  from shop_users as u join shop_user_usergroup_map as m 
  on u.id = m.user_id

2 × SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
  FROM shop_phocadownload AS c 
  LEFT JOIN shop_phocadownload_categories AS cc 
  ON cc.id = c.catid

1 × SELECT * 
  FROM shop_acymailing_confi

1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM shop_phocadownload_styles AS a

1 × SELECT * 
  FROM shop_acymailing_list

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM shop_modules AS m 
  LEFT JOIN shop_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN shop_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `config` 
  FROM `shop_virtuemart_configs`

1 × SELECT m2.language, m2.id 
  FROM shop_menu as m 
  INNER JOIN shop_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item' 
  INNER JOIN shop_associations as a2 
  ON a.key=a2.key 
  INNER JOIN shop_menu as m2 
  ON a2.id=m2.id

```
1 × SELECT * 
  FROM `shop_menu`
```

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

1 × SELECT a.rules 
  FROM shop_assets AS a

1 × SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias 
  FROM shop_phocadownload_categories AS cc 
  LEFT JOIN shop_phocadownload_categories AS pc 
  ON pc.id = cc.parent_id

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

1 × SELECT id, rules 
  FROM `shop_viewlevels

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

1 × SELECT `session_id` 
  FROM `shop_session`

```
1 × SELECT * 
  FROM shop_languages
```

1 × SELECT COUNT(*) 
  FROM `shop_menu`

1 × SELECT `data` 
  FROM `shop_session`

```
1 × SELECT * 
  FROM shop_rokcandy
```

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

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

1 × SELECT  cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc 
  FROM shop_phocadownload_categories AS cc 
  LEFT JOIN shop_phocadownload AS c 
  ON c.catid = cc.id 
  AND c.published = 1 
  AND c.textonly = 0

INNE tabele:

1 × UPDATE `shop_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1702122215;s:18:\"session.timer.last\";i:1702122215;s:17:\"session.timer.now\";i:1702122215;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"124cb2bcca7e4178696e9b9aca7049a8\";}'  , `time` = '1702122215'

1 × SHOW TABLES LIKE "shop_virtuemart_configs

1 × UPDATE `shop_extensions` 
  SET `params` = '{\"mediaversion\":\"320270dafff2f19d6de8394c8fb8f67f\",\"Array\":[\"6b0c230dba445a8e246bba39cf1fa577\"]}'

1 × INSERT INTO `shop_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('iadb1pfhsrbbb8kgd2bn663ee3', 0, '1702122215'

```
1 × DELETE  
  FROM `shop_session`
```

Techto.pl

Formularz kontaktowy

Deklaracje CE

Informacje o plikach cookie

Konsola diagnostyczna Joomla!

Sesja

__default

Informacje o wydajności

Time

Memory

Użycie pamięci

Zapytania do bazy danych

39 zapytań zarejestrowanych 26.4 ms

2 duplicate found!

29 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

INNE tabele: