Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Time

Memory

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

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

Time: 35.5 ms / 66.6 ms Memory: 2.960 MB / 5.17 MB Application: afterRoute

Time: 81.8 ms / 148.4 ms Memory: 6.032 MB / 11.20 MB Application: afterDispatch

Time: 5.2 ms / 153.6 ms Memory: 0.256 MB / 11.46 MB Application: beforeRenderModule mod_acymailing (NEWSLETTER)

Time: 7.7 ms / 161.3 ms Memory: 0.567 MB / 12.02 MB Application: afterRenderModule mod_acymailing (NEWSLETTER)

Time: 0.1 ms / 161.4 ms Memory: 0.000 MB / 12.00 MB Application: beforeRenderModule mod_menu (INFORMACJE)

Time: 3.4 ms / 164.7 ms Memory: 0.092 MB / 12.09 MB Application: afterRenderModule mod_menu (INFORMACJE)

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

Time: 1.4 ms / 166.3 ms Memory: 0.026 MB / 12.11 MB Application: afterRenderModule mod_menu (MENU UŻYTKOWNIKA)

Time: 0.1 ms / 166.3 ms Memory: 0.000 MB / 12.11 MB Application: beforeRenderModule mod_custom (SZYBKI KONTAKT)

Time: 1.2 ms / 167.5 ms Memory: 0.010 MB / 12.12 MB Application: afterRenderModule mod_custom (SZYBKI KONTAKT)

Time: 0.1 ms / 167.5 ms Memory: 0.000 MB / 12.12 MB Application: beforeRenderModule mod_virtuemart_category (KATEGORIE)

Time: 36.5 ms / 204.0 ms Memory: 1.632 MB / 13.75 MB Application: afterRenderModule mod_virtuemart_category (KATEGORIE)

Time: 0.1 ms / 204.2 ms Memory: 0.008 MB / 13.76 MB Application: beforeRenderModule mod_virtuemart_param_filter (ZNAJDŹ PRODUKT)

Time: 6.1 ms / 210.2 ms Memory: 0.172 MB / 13.93 MB Application: afterRenderModule mod_virtuemart_param_filter (ZNAJDŹ PRODUKT)

Time: 0.1 ms / 210.4 ms Memory: 0.000 MB / 13.87 MB Application: beforeRenderModule mod_comparelist (PORÓWNYWARKA)

Time: 3.8 ms / 214.1 ms Memory: 0.018 MB / 13.89 MB Application: afterRenderModule mod_comparelist (PORÓWNYWARKA)

Time: 0.1 ms / 214.2 ms Memory: 0.000 MB / 13.89 MB Application: beforeRenderModule mod_wishlist (SCHOWEK)

Time: 2.7 ms / 216.9 ms Memory: 0.015 MB / 13.90 MB Application: afterRenderModule mod_wishlist (SCHOWEK)

Time: 0.1 ms / 217.0 ms Memory: 0.002 MB / 13.90 MB Application: beforeRenderModule mod_virtuemart_product (BESTSELLERY)

Time: 23.3 ms / 240.2 ms Memory: 0.982 MB / 14.88 MB Application: afterRenderModule mod_virtuemart_product (BESTSELLERY)

Time: 0.2 ms / 240.4 ms Memory: 0.000 MB / 14.84 MB Application: beforeRenderModule mod_breadcrumbs (BREADCRUMBS)

Time: 2.8 ms / 243.2 ms Memory: 0.020 MB / 14.86 MB Application: afterRenderModule mod_breadcrumbs (BREADCRUMBS)

Time: 0.1 ms / 243.3 ms Memory: 0.000 MB / 14.85 MB Application: beforeRenderModule mod_virtuemart_search (SZUKAJ)

Time: 4.2 ms / 247.6 ms Memory: 0.018 MB / 14.87 MB Application: afterRenderModule mod_virtuemart_search (SZUKAJ)

Time: 0.1 ms / 247.7 ms Memory: 0.000 MB / 14.87 MB Application: beforeRenderModule mod_virtuemart_cart (KOSZYK)

Time: 37.7 ms / 285.4 ms Memory: 1.949 MB / 16.82 MB Application: afterRenderModule mod_virtuemart_cart (KOSZYK)

Time: 0.1 ms / 285.5 ms Memory: 0.000 MB / 16.81 MB Application: beforeRenderModule mod_virtuemart_currencies (WALUTY)

Time: 0.0 ms / 285.5 ms Memory: 0.004 MB / 16.81 MB Application: afterRenderModule mod_virtuemart_currencies (WALUTY)

Time: 0.0 ms / 285.6 ms Memory: 0.001 MB / 16.81 MB Application: beforeRenderModule mod_languages (JĘZYKI)

Time: 3.4 ms / 288.9 ms Memory: 0.129 MB / 16.94 MB Application: afterRenderModule mod_languages (JĘZYKI)

Time: 0.1 ms / 289.0 ms Memory: 0.000 MB / 16.94 MB Application: beforeRenderModule mod_comparelist (PORÓWNYWARKA IKONA)

Time: 0.4 ms / 289.4 ms Memory: 0.007 MB / 16.95 MB Application: afterRenderModule mod_comparelist (PORÓWNYWARKA IKONA)

Time: 0.0 ms / 289.5 ms Memory: 0.000 MB / 16.94 MB Application: beforeRenderModule mod_wishlist (SCHOWEK IKONA)

Time: 0.3 ms / 289.8 ms Memory: 0.007 MB / 16.95 MB Application: afterRenderModule mod_wishlist (SCHOWEK IKONA)

Time: 0.1 ms / 289.9 ms Memory: 0.000 MB / 16.95 MB Application: beforeRenderModule mod_menu (TOP MENU)

Time: 1.1 ms / 291.0 ms Memory: 0.018 MB / 16.97 MB Application: afterRenderModule mod_menu (TOP MENU)

Time: 0.1 ms / 291.1 ms Memory: 0.002 MB / 16.97 MB Application: beforeRenderModule mod_js_social_tabs_slider (Techto.pl)

Time: 0.3 ms / 291.4 ms Memory: 0.025 MB / 17.00 MB Application: afterRenderModule mod_js_social_tabs_slider (Techto.pl)

Time: 0.1 ms / 291.4 ms Memory: 0.000 MB / 16.98 MB Application: beforeRenderModule mod_custom (INFOLINIA)

Time: 0.2 ms / 291.6 ms Memory: 0.007 MB / 16.99 MB Application: afterRenderModule mod_custom (INFOLINIA)

Time: 0.0 ms / 291.6 ms Memory: 0.000 MB / 16.99 MB Application: beforeRenderModule mod_yj_pop_login (LOGOWANIE)

Time: 2.8 ms / 294.5 ms Memory: 0.031 MB / 17.02 MB Application: afterRenderModule mod_yj_pop_login (LOGOWANIE)

Time: 248.6 ms / 543.0 ms Memory: 0.453 MB / 17.47 MB Application: afterRender

Database queries total: 68.9 ms

Użycie pamięci

Zapytania do bazy danych

173 zapytań zarejestrowanych 68.9 ms

4 duplicate found!

2 duplicates: #135 #136

2 duplicates: #171 #172

Query Time: 0.38 ms Query memory: 0.015 MB Memory before query: 0.764 MB Rows returned: 0
```
SELECT `data`

  FROM `shop_session`

  WHERE `session_id` = 'tg9il3n58m1ac70a0oh6r4vku7'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE shop_session const PRIMARY PRIMARY 602 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:668
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.29 ms After last query: 0.40 ms Query memory: 0.008 MB Memory before query: 0.811 MB
```
DELETE 

  FROM `shop_session`

  WHERE `time` < '1695589441'
```
Explain
EXPLAIN not possible on query: DELETE FROM `shop_session` WHERE `time` < '1695589441'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:685
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.17 ms After last query: 0.08 ms Query memory: 0.012 MB Memory before query: 0.823 MB Rows returned: 0
```
SELECT `session_id`

  FROM `shop_session`

  WHERE `session_id` = 'tg9il3n58m1ac70a0oh6r4vku7' 
  LIMIT 0, 1
```
Explain
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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[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.11 ms Query memory: 0.009 MB Memory before query: 0.835 MB
```
INSERT INTO `shop_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('tg9il3n58m1ac70a0oh6r4vku7', 0, '1695590341')
```
Explain
EXPLAIN not possible on query: INSERT INTO `shop_session` (`session_id`, `client_id`, `time`) VALUES ('tg9il3n58m1ac70a0oh6r4vku7', 0, '1695590341')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.33 ms After last query: 0.61 ms Query memory: 0.015 MB Memory before query: 0.913 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM shop_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_users'
```
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
No SHOW PROFILE (maybe because there are more than 100 queries)
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:570
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.33 ms After last query: 0.28 ms Query memory: 0.014 MB Memory before query: 0.931 MB Rows returned: 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

  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 range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:334
JROOT/libraries/joomla/access/access.php:403
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
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.19 ms After last query: 0.11 ms Query memory: 0.013 MB Memory before query: 0.950 MB Rows returned: 3
```
SELECT id, rules

  FROM `shop_viewlevels`
```
Explain
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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:420
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
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: 1.65 ms After last query: 0.16 ms Query memory: 0.018 MB Memory before query: 0.968 MB Rows returned: 159
```
SELECT folder AS type, element AS name, params

  FROM shop_extensions

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

  ORDER BY ordering
```
Explain
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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
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.36 ms After last query: 1.56 ms Query memory: 0.016 MB Memory before query: 1.191 MB Rows returned: 1
```
SELECT *

  FROM shop_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:166
JROOT/plugins/system/languagefilter/languagefilter.php:67
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:575
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.66 ms After last query: 0.16 ms Query memory: 0.018 MB Memory before query: 1.225 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM shop_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
```
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
No SHOW PROFILE (maybe because there are more than 100 queries)
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/languagefilter/languagefilter.php:69
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:575
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.51 ms After last query: 0.26 ms Query memory: 0.013 MB Memory before query: 1.228 MB Rows returned: 1
```
SELECT COUNT(*)

  FROM `shop_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
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 NO INDEX KEY COULD BE USED NULL NULL 219 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32
JROOT/plugins/system/languagefilter/languagefilter.php:71
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:575
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.58 ms After last query: 4.76 ms Query memory: 0.023 MB Memory before query: 1.581 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM shop_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
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 extension 364 const,const 1 Using index condition
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
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.24 ms After last query: 0.23 ms Query memory: 0.016 MB Memory before query: 1.588 MB
```
UPDATE `shop_extensions`

  SET `params` = '{\"mediaversion\":\"e0d89ca6960c1317fa4380ffa0ca849f\",\"Array\":[\"6b0c230dba445a8e246bba39cf1fa577\"]}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `shop_extensions` SET `params` = '{\"mediaversion\":\"e0d89ca6960c1317fa4380ffa0ca849f\",\"Array\":[\"6b0c230dba445a8e246bba39cf1fa577\"]}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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.40 ms After last query: 5.38 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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]

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_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; 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_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using index condition; Using where

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

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

Query Time: 1.89 ms After last query: 4.27 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.77 ms After last query: 8.87 ms Query memory: 0.023 MB Memory before query: 4.110 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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:300
JROOT/libraries/cms/component/router/legacy.php:106
JROOT/libraries/cms/router/site.php:369
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]

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

Query Time: 1.25 ms After last query: 0.42 ms Query memory: 0.025 MB Memory before query: 4.143 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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:300

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

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

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: 1.30 ms After last query: 0.44 ms Query memory: 0.020 MB Memory before query: 4.207 MB Rows returned: 1
```
SHOW TABLES LIKE "shop_virtuemart_configs"
```
Explain
EXPLAIN not possible on query: SHOW TABLES LIKE "shop_virtuemart_configs"
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:300
JROOT/libraries/cms/component/router/legacy.php:106
JROOT/libraries/cms/router/site.php:369
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.41 ms After last query: 0.12 ms Query memory: 0.019 MB Memory before query: 4.227 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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_virtuemart/helpers/config.php:827
JROOT/components/com_virtuemart/router.php:704
JROOT/components/com_virtuemart/router.php:300
JROOT/libraries/cms/component/router/legacy.php:106
JROOT/libraries/cms/router/site.php:369
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.44 ms After last query: 2.01 ms Query memory: 0.025 MB Memory before query: 4.339 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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:300
JROOT/libraries/cms/component/router/legacy.php:106
JROOT/libraries/cms/router/site.php:369
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.85 ms After last query: 0.11 ms Query memory: 0.027 MB Memory before query: 4.342 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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:300
JROOT/libraries/cms/component/router/legacy.php:106
JROOT/libraries/cms/router/site.php:369
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]

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

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

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

Query Time: 0.43 ms After last query: 1.86 ms Query memory: 0.018 MB Memory before query: 4.439 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

No SHOW PROFILE (maybe because there are more than 100 queries)

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.57 ms After last query: 9.51 ms Query memory: 0.026 MB Memory before query: 4.844 MB Rows returned: 1
```
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  shop_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 47
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE xref ref category_child_id category_child_id 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_virtuemart/models/category.php:682
JROOT/components/com_virtuemart/router.php:745
JROOT/components/com_virtuemart/router.php:724
JROOT/components/com_virtuemart/router.php:76
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/plugins/system/sef/sef.php:49
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.23 ms After last query: 0.06 ms Query memory: 0.028 MB Memory before query: 4.871 MB Rows returned: 1
```
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  shop_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 35
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE xref ref category_child_id category_child_id 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_virtuemart/models/category.php:682
JROOT/administrator/components/com_virtuemart/models/category.php:689
JROOT/components/com_virtuemart/router.php:745
JROOT/components/com_virtuemart/router.php:724
JROOT/components/com_virtuemart/router.php:76
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/plugins/system/sef/sef.php:49
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.31 ms After last query: 0.11 ms Query memory: 0.036 MB Memory before query: 4.911 MB Rows returned: 1
```
SELECT `shop_virtuemart_categories`.* ,`shop_virtuemart_categories_pl_pl`.*  
  FROM `shop_virtuemart_categories` 
  INNER JOIN `shop_virtuemart_categories_pl_pl` using (`virtuemart_category_id`) 
  WHERE `shop_virtuemart_categories`.`virtuemart_category_id` = "35"
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE shop_virtuemart_categories const PRIMARY PRIMARY 3 const 1
1 SIMPLE shop_virtuemart_categories_pl_pl const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1014
JROOT/administrator/components/com_virtuemart/models/category.php:70
JROOT/components/com_virtuemart/router.php:784
JROOT/components/com_virtuemart/router.php:760
JROOT/components/com_virtuemart/router.php:724
JROOT/components/com_virtuemart/router.php:76
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/plugins/system/sef/sef.php:49
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.36 ms After last query: 0.44 ms Query memory: 0.029 MB Memory before query: 5.023 MB Rows returned: 1
```
SELECT `virtuemart_media_id` 
  FROM `shop_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "35" 
  ORDER BY `ordering`
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE shop_virtuemart_category_medias ref virtuemart_category_id virtuemart_category_id 3 const 1 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:123
JROOT/administrator/components/com_virtuemart/models/category.php:73
JROOT/components/com_virtuemart/router.php:784
JROOT/components/com_virtuemart/router.php:760
JROOT/components/com_virtuemart/router.php:724
JROOT/components/com_virtuemart/router.php:76
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/plugins/system/sef/sef.php:49
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.37 ms After last query: 0.13 ms Query memory: 0.036 MB Memory before query: 5.056 MB Rows returned: 1
```
SELECT `shop_virtuemart_categories`.* ,`shop_virtuemart_categories_pl_pl`.*  
  FROM `shop_virtuemart_categories` 
  INNER JOIN `shop_virtuemart_categories_pl_pl` using (`virtuemart_category_id`) 
  WHERE `shop_virtuemart_categories`.`virtuemart_category_id` = "47"
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE shop_virtuemart_categories const PRIMARY PRIMARY 3 const 1
1 SIMPLE shop_virtuemart_categories_pl_pl const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1014
JROOT/administrator/components/com_virtuemart/models/category.php:70
JROOT/components/com_virtuemart/router.php:784
JROOT/components/com_virtuemart/router.php:760
JROOT/components/com_virtuemart/router.php:724
JROOT/components/com_virtuemart/router.php:76
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/plugins/system/sef/sef.php:49
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.24 ms After last query: 0.22 ms Query memory: 0.029 MB Memory before query: 5.095 MB Rows returned: 1
```
SELECT `virtuemart_media_id` 
  FROM `shop_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "47" 
  ORDER BY `ordering`
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE shop_virtuemart_category_medias ref virtuemart_category_id virtuemart_category_id 3 const 1 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:123
JROOT/administrator/components/com_virtuemart/models/category.php:73
JROOT/components/com_virtuemart/router.php:784
JROOT/components/com_virtuemart/router.php:760
JROOT/components/com_virtuemart/router.php:724
JROOT/components/com_virtuemart/router.php:76
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/plugins/system/sef/sef.php:49
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.25 ms After last query: 0.33 ms Query memory: 0.022 MB Memory before query: 5.135 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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.20 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 5.158 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
No SHOW PROFILE (maybe because there are more than 100 queries)
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: 15.57 ms Query memory: 0.017 MB Memory before query: 5.996 MB Rows returned: 0
```
SELECT `virtuemart_custom_id`, `custom_title` 
  FROM `shop_virtuemart_customs` 
  WHERE `field_type` ="P"
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE shop_virtuemart_customs ref field_type field_type 6 const 1 Using index condition
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_virtuemart/views/category/view.html.php:382
JROOT/components/com_virtuemart/views/category/view.html.php:65
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_virtuemart/virtuemart.php:122
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.36 ms After last query: 7.13 ms Query memory: 0.021 MB Memory before query: 6.354 MB Rows returned: 0
```
SELECT `virtuemart_custom_id`, `custom_title` 
  FROM `shop_virtuemart_customs` 
  WHERE `custom_element` ="specification"
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE shop_virtuemart_customs ref custom_element custom_element 150 const 1 Using index condition
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/vmcustom/specification/specification.php:77
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_virtuemart/views/category/view.html.php:399
JROOT/components/com_virtuemart/views/category/view.html.php:65
JROOT/components/com_virtuemart/controllers/category.php:54
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_virtuemart/virtuemart.php:122
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.36 ms After last query: 3.35 ms Query memory: 0.017 MB Memory before query: 7.031 MB Rows returned: 0

Techto.pl

Formularz kontaktowy

Transformatory medyczne

KATEGORIE

ZNAJDŹ PRODUKT

PORÓWNYWARKA

SCHOWEK

BESTSELLERY

Informacje o plikach cookie

Konsola diagnostyczna Joomla!

Sesja

__default

__vm

recent

Informacje o wydajności

Time

Memory

Użycie pamięci

Zapytania do bazy danych

173 zapytań zarejestrowanych 68.9 ms

4 duplicate found!

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	shop_virtuemart_categories	const	PRIMARY	PRIMARY	3	const	1
1	SIMPLE	shop_virtuemart_categories_pl_pl	const	PRIMARY	PRIMARY	4	const	1