Textile - رزین سازان

Home
Products
Textiles

Sunday, 06 September 2026

Product Name	Chemical Composition	S.C.%	pH	Viscosity	Film Character	MFFT℃
RS-TB601	AC	40±1 %	4-5	500> (cp)	VS	0> ℃
RS-TB602	AC	40±1 %	4-5	500> (cp)	VS	0> ℃
RS-TB603	AC	40±1 %	4-5	500> (cp)	VS	0> ℃
RSH-900	VA	50±1 %	3-4	60000-120000 (cp)	H	16 ℃
RSH-906	VA	40±1 %	4-5	500> (cp)	H	15 ℃
RSH-910	VA	50±1 %	3-4	80000-120000 (cp)	H	16 ℃
RSH-920	VA	50±1 %	4-5	80000-90000 (cp)	S	1 ℃
RSH-945	VA	50±1 %	4-5	110000-140000 (cp)	S	6 ℃
RSH-950	VA	50±1 %	4-5	80000-100000 (cp)	H	16 ℃
RSH-952	VA	50±1 %	4-5	70000-100000 (cp)	H	18 ℃
RSH-955	VA	47±1 %	4-5	50000-80000 (cp)	S	4 ℃
RSH-965	VA	50±1 %	4-5	2000-4000 (cp)	H	17 ℃
RSH-966	VA	50±1 %	4-5	5000-8000 (cp)	H	19 ℃
RSS-640	ST / AC	50±1 %	8-9	500-2000 (cp)	VH	30 ℃

TOP

Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 1.464 MB / 1.46 MB Application: afterLoad

Time: 298.3 ms / 298.3 ms Memory: 10.402 MB / 11.87 MB Application: afterInitialise

Time: 101.7 ms / 399.9 ms Memory: 3.360 MB / 15.23 MB Application: afterRoute

Time: 1272.5 ms / 1672.5 ms Memory: 9.793 MB / 25.02 MB Application: beforeRenderModule mod_k2_tools (جستجوی محصولات)

Time: 19.2 ms / 1691.6 ms Memory: 0.931 MB / 25.95 MB Application: afterRenderModule mod_k2_tools (جستجوی محصولات)

Time: 5.1 ms / 1696.8 ms Memory: 0.008 MB / 25.96 MB Application: beforeRenderModule mod_k2_tools (Product Search)

Time: 52.9 ms / 1749.7 ms Memory: 0.371 MB / 26.33 MB Application: afterRenderModule mod_k2_tools (Product Search)

Time: 7.1 ms / 1756.8 ms Memory: 0.026 MB / 26.35 MB Application: afterDispatch

Time: 48.4 ms / 1805.3 ms Memory: 0.602 MB / 26.96 MB Application: beforeRenderModule mod_menu (Menu)

Time: 8.5 ms / 1813.8 ms Memory: 0.018 MB / 26.97 MB Application: afterRenderModule mod_menu (Menu)

Time: 0.9 ms / 1814.7 ms Memory: 0.000 MB / 26.93 MB Application: beforeRenderModule mod_jb_googlemap (Google Map)

Time: 3.7 ms / 1818.4 ms Memory: 0.103 MB / 27.03 MB Application: afterRenderModule mod_jb_googlemap (Google Map)

Time: 1.0 ms / 1819.5 ms Memory: 0.039 MB / 27.07 MB Application: beforeRenderModule mod_custom (Contact Us)

Time: 4.0 ms / 1823.5 ms Memory: 0.019 MB / 27.09 MB Application: afterRenderModule mod_custom (Contact Us)

Time: 3.6 ms / 1827.1 ms Memory: 0.027 MB / 27.11 MB Application: beforeRenderModule mod_currentdatetime (date)

Time: 4.4 ms / 1831.6 ms Memory: 0.320 MB / 27.43 MB Application: afterRenderModule mod_currentdatetime (date)

Time: 2.8 ms / 1834.4 ms Memory: 0.068 MB / 27.50 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 4.3 ms / 1838.7 ms Memory: 0.041 MB / 27.54 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 4.8 ms / 1843.5 ms Memory: 0.030 MB / 27.57 MB Application: beforeRenderModule mod_k2_tools (Site Search)

Time: 3.5 ms / 1847.0 ms Memory: 0.019 MB / 27.59 MB Application: afterRenderModule mod_k2_tools (Site Search)

Time: 2.2 ms / 1849.1 ms Memory: 0.000 MB / 27.56 MB Application: beforeRenderModule mod_languages (انتخاب زبان)

Time: 10.4 ms / 1859.6 ms Memory: 0.236 MB / 27.80 MB Application: afterRenderModule mod_languages (انتخاب زبان)

Time: 72.8 ms / 1932.3 ms Memory: 0.082 MB / 27.88 MB Application: afterRender

Database queries total: 393.5 ms

Memory Usage

Database Queries

132 Queries Logged 393.5 ms

26 duplicate found!

3 duplicates: #48 #57 #61

14 duplicates: #49 #58 #62 #67 #73 #78 #83 #88 #92 #96 #100 #104 #108 #113

6 duplicates: #72 #77 #91 #95 #103 #107

3 duplicates: #82 #87 #99

Query Time: 1.98 ms Query memory: 0.014 MB Memory before query: 4.241 MB Rows returned: 0
```
SELECT `data`

  FROM `skm6h_session`

  WHERE `session_id` = 'a0vqpi8dhq33nupfugtpt4ok42'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_session const PRIMARY PRIMARY 602 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:665
JROOT/libraries/joomla/session/session.php:603
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 7.53 ms After last query: 6.14 ms Query memory: 0.008 MB Memory before query: 4.539 MB
```
DELETE 

  FROM `skm6h_session`

  WHERE `time` < '1788672823'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_session range time time 45 NULL 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:756
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 7.92 ms After last query: 1.22 ms Query memory: 0.011 MB Memory before query: 4.554 MB Rows returned: 0
```
SELECT `session_id`

  FROM `skm6h_session`

  WHERE `session_id` = 'a0vqpi8dhq33nupfugtpt4ok42' 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_session const PRIMARY PRIMARY 602 const 1 100.00 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 6.04 ms After last query: 0.96 ms Query memory: 0.009 MB Memory before query: 4.566 MB
```
INSERT INTO `skm6h_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('a0vqpi8dhq33nupfugtpt4ok42', 0, '1788673723')
```
Explain
EXPLAIN not possible on query: INSERT INTO `skm6h_session` (`session_id`, `client_id`, `time`) VALUES ('a0vqpi8dhq33nupfugtpt4ok42', 0, '1788673723')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.71 ms After last query: 10.67 ms Query memory: 0.013 MB Memory before query: 5.200 MB Rows returned: 43
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM skm6h_extensions

  WHERE `type` = 'component'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_extensions ref extension extension 62 const 43 100.00 Using index condition
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:434
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:119
JROOT/libraries/cms/application/site.php:568
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
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	filtered	Extra
1	SIMPLE	skm6h_session	const	PRIMARY	PRIMARY	602	const	1	100.00

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_session	range	time	time	45	NULL	1	100.00	Using where

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_extensions	ref	extension	extension	62	const	43	100.00	Using index condition

Query Time: 2.74 ms After last query: 4.90 ms Query memory: 0.013 MB Memory before query: 5.407 MB Rows returned: 1

SELECT b.id

  FROM skm6h_usergroups AS a

  LEFT JOIN skm6h_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	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	100.00	Using where; Using index

Profile

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

Call Stack

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.92 ms After last query: 1.76 ms Query memory: 0.012 MB Memory before query: 5.497 MB Rows returned: 5
```
SELECT id, rules

  FROM `skm6h_viewlevels`
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:573
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 3.41 ms After last query: 1.54 ms Query memory: 0.010 MB Memory before query: 5.516 MB Rows returned: 68
```
SELECT folder AS type, element AS name, params

  FROM skm6h_extensions

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

  ORDER BY ordering
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_extensions ref extension extension 62 const 88 100.00 Using index condition; Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:573
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.56 ms After last query: 7.34 ms Query memory: 0.012 MB Memory before query: 5.865 MB Rows returned: 2
```
SELECT *

  FROM skm6h_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 100.00 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:164
JROOT/plugins/system/languagefilter/languagefilter.php:59
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/site.php:573
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.81 ms After last query: 13.47 ms Query memory: 0.016 MB Memory before query: 6.725 MB Rows returned: 0
```
SELECT `path`

  FROM skm6h_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_rsfirewall/helpers/config.php:52
JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
JROOT/administrator/components/com_rsfirewall/helpers/config.php:159
JROOT/plugins/system/rsfirewall/rsfirewall.php:25
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.75 ms After last query: 0.47 ms Query memory: 0.016 MB Memory before query: 6.742 MB Rows returned: 0
```
SELECT `file`

  FROM skm6h_rsfirewall_hashes

  WHERE `type`='protect'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 21 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_rsfirewall/helpers/config.php:58
JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
JROOT/administrator/components/com_rsfirewall/helpers/config.php:159
JROOT/plugins/system/rsfirewall/rsfirewall.php:25
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.89 ms After last query: 0.37 ms Query memory: 0.016 MB Memory before query: 6.756 MB Rows returned: 48
```
SELECT *

  FROM skm6h_rsfirewall_configuration
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_rsfirewall_configuration ALL NULL NO INDEX KEY COULD BE USED NULL NULL 48 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_rsfirewall/helpers/config.php:66
JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
JROOT/administrator/components/com_rsfirewall/helpers/config.php:159
JROOT/plugins/system/rsfirewall/rsfirewall.php:25
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 4.06 ms After last query: 26.08 ms Query memory: 0.021 MB Memory before query: 7.507 MB Rows returned: 10
```
SHOW FULL COLUMNS 
  FROM `skm6h_rsfirewall_logs`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `skm6h_rsfirewall_logs`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_rsfirewall/tables/logs.php:35
JROOT/libraries/joomla/table/table.php:305
JROOT/administrator/components/com_rsfirewall/helpers/log.php:22
JROOT/administrator/components/com_rsfirewall/helpers/log.php:56
JROOT/plugins/system/rsfirewall/rsfirewall.php:46
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
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	filtered	Extra
1	SIMPLE	skm6h_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_extensions	ref	extension	extension	62	const	88	100.00	Using index condition; Using where; Using filesort

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

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

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

Query Time: 4.53 ms After last query: 66.89 ms Query memory: 0.024 MB Memory before query: 10.238 MB Rows returned: 73

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

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

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

  ORDER BY m.lft

Explain

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

Profile

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

Call Stack

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

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

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

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

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

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

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

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

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

JROOT/plugins/system/languagefilter/languagefilter.php:94

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.19 ms After last query: 64.30 ms Query memory: 0.014 MB Memory before query: 12.312 MB Rows returned: 0
```
SELECT *

  FROM skm6h_rsfirewall_hashes

  WHERE (`type`='3.4.1' OR `type`='protect') 
  AND `flag`!='C'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_rsfirewall_hashes ALL NULL NO INDEX KEY COULD BE USED NULL NULL 21 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/rsfirewall/rsfirewall.php:839
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
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: 2.16 ms Query memory: 0.015 MB Memory before query: 12.387 MB Rows returned: 0
```
SELECT *

  FROM skm6h_rsfirewall_snapshots

  WHERE `type`='protect'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:46
JROOT/plugins/system/rsfirewall/rsfirewall.php:862
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.11 ms After last query: 0.99 ms Query memory: 0.016 MB Memory before query: 12.403 MB Rows returned: 0
```
SELECT `ip`,`reason`

  FROM skm6h_rsfirewall_lists

  WHERE (`ip`='18.97.14.89' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/rsfirewall/rsfirewall.php:164
JROOT/plugins/system/rsfirewall/rsfirewall.php:143
JROOT/plugins/system/rsfirewall/rsfirewall.php:890
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.92 ms After last query: 1.00 ms Query memory: 0.016 MB Memory before query: 12.419 MB Rows returned: 0
```
SELECT `ip`,`reason`

  FROM skm6h_rsfirewall_lists

  WHERE (`ip`='18.97.14.89' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/rsfirewall/rsfirewall.php:164
JROOT/plugins/system/rsfirewall/rsfirewall.php:133
JROOT/plugins/system/rsfirewall/rsfirewall.php:894
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.58 ms After last query: 2.66 ms Query memory: 0.015 MB Memory before query: 12.541 MB Rows returned: 0
```
SELECT *

  FROM skm6h_rsfirewall_exceptions

  WHERE `published`='1'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/rsfirewall/rsfirewall.php:532
JROOT/plugins/system/rsfirewall/rsfirewall.php:929
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
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	filtered	Extra
1	SIMPLE	skm6h_rsfirewall_hashes	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	21	100.00	Using where

Query Time: 2.60 ms After last query: 4.06 ms Query memory: 0.024 MB Memory before query: 12.817 MB Rows returned: 7

SELECT id, home, template, s.params

  FROM skm6h_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	10	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	resinsaz_joomla.s.template,const	1	100.00	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:484

JROOT/libraries/cms/html/html.php:334

JROOT/libraries/cms/html/html.php:680

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/libraries/cms/html/jquery.php:53

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/plugins/system/jquery/jquery.php:38

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.17 ms After last query: 5.73 ms Query memory: 0.031 MB Memory before query: 12.953 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM skm6h_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using index condition
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
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:177
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/libraries/cms/html/html.php:701
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/libraries/cms/html/jquery.php:53
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/plugins/system/jquery/jquery.php:38
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 5.32 ms After last query: 1.74 ms Query memory: 0.025 MB Memory before query: 12.944 MB
```
UPDATE `skm6h_extensions`

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

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_extensions range element_clientid,element_folder_clientid,extension extension 364 NULL 1 100.00 Using where
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:228
JROOT/libraries/cms/version/version.php:187
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/libraries/cms/html/html.php:701
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/libraries/cms/html/jquery.php:53
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/plugins/system/jquery/jquery.php:38
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.36 ms After last query: 49.15 ms Query memory: 0.013 MB Memory before query: 15.338 MB Rows returned: 1
```
SELECT a.rules

  FROM skm6h_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 filtered Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/components/com_k2/k2.php:16
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
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	filtered	Extra
1	SIMPLE	skm6h_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

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

Query Time: 3.78 ms After last query: 2.79 ms Query memory: 0.014 MB Memory before query: 15.407 MB Rows returned: 2

SELECT b.rules

  FROM skm6h_assets AS a

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

  WHERE (a.name = 'com_k2')

  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	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	264	99.24	Using where

Profile

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

Call Stack

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

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

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

JROOT/components/com_k2/k2.php:16

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.81 ms After last query: 21.26 ms Query memory: 0.019 MB Memory before query: 17.469 MB Rows returned: 55
```
SELECT id 
  FROM skm6h_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_k2_categories range category,published,access,trash category 8 NULL 54 100.00 Using index condition
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/helpers/permissions.php:261
JROOT/components/com_k2/views/itemlist/view.html.php:29
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 3.18 ms After last query: 2.88 ms Query memory: 0.024 MB Memory before query: 17.616 MB Rows returned: 14
```
SHOW FULL COLUMNS 
  FROM `skm6h_k2_categories`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `skm6h_k2_categories`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_k2/tables/k2category.php:34
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_k2/views/itemlist/view.html.php:41
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.98 ms After last query: 0.88 ms Query memory: 0.019 MB Memory before query: 17.665 MB Rows returned: 1
```
SELECT * 
  FROM skm6h_k2_categories 
  WHERE id = '65'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_k2_categories const PRIMARY PRIMARY 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_k2/tables/k2category.php:65
JROOT/components/com_k2/views/itemlist/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.57 ms After last query: 1.85 ms Query memory: 0.019 MB Memory before query: 17.718 MB Rows returned: 1
```
SELECT * 
  FROM skm6h_k2_categories 
  WHERE id = '4'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_k2_categories const PRIMARY PRIMARY 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_k2/tables/k2category.php:65
JROOT/components/com_k2/views/itemlist/view.html.php:116
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.26 ms After last query: 23.71 ms Query memory: 0.019 MB Memory before query: 19.221 MB Rows returned: 6
```
SELECT * 
  FROM skm6h_k2_categories 
  WHERE parent=65 
  AND published=1 
  AND trash=0 
  AND access IN(1,1)  
  AND language IN('en-GB', '*') 
  ORDER BY  id ASC
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_k2_categories ref category,parent,published,access,trash,language parent 5 const 6 100.00 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:748
JROOT/components/com_k2/views/itemlist/view.html.php:173
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.92 ms After last query: 1.07 ms Query memory: 0.020 MB Memory before query: 19.274 MB Rows returned: 0
```
SELECT id
						
  FROM skm6h_k2_categories 
						
  WHERE parent IN (66) 
						
  AND id NOT IN (66) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_k2_categories ref PRIMARY,category,parent,published,access,trash,language parent 5 const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:642
JROOT/components/com_k2/models/itemlist.php:771
JROOT/components/com_k2/views/itemlist/view.html.php:180
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.38 ms After last query: 0.37 ms Query memory: 0.019 MB Memory before query: 19.295 MB Rows returned: 1
```
SELECT COUNT(*) 
  FROM skm6h_k2_items 
  WHERE catid IN (66) 
  AND published=1 
  AND trash=0 
  AND access IN(1,1)  
  AND language IN('en-GB', '*') 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-06 05:48:44' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-06 05:48:44' )
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_k2_items ref item,catid,language catid 4 const 9 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:790
JROOT/components/com_k2/views/itemlist/view.html.php:180
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 2.26 ms After last query: 2.71 ms Query memory: 0.020 MB Memory before query: 19.317 MB Rows returned: 0
```
SELECT id
						
  FROM skm6h_k2_categories 
						
  WHERE parent IN (67) 
						
  AND id NOT IN (67) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_k2_categories ref PRIMARY,category,parent,published,access,trash,language parent 5 const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:642
JROOT/components/com_k2/models/itemlist.php:771
JROOT/components/com_k2/views/itemlist/view.html.php:180
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.39 ms After last query: 0.41 ms Query memory: 0.019 MB Memory before query: 19.338 MB Rows returned: 1
```
SELECT COUNT(*) 
  FROM skm6h_k2_items 
  WHERE catid IN (67) 
  AND published=1 
  AND trash=0 
  AND access IN(1,1)  
  AND language IN('en-GB', '*') 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-06 05:48:44' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-06 05:48:44' )
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE skm6h_k2_items ref item,catid,language catid 4 const 3 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:790
JROOT/components/com_k2/views/itemlist/view.html.php:180
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/itemlist.php:49
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
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	filtered	Extra
1	SIMPLE	skm6h_k2_categories	range	category,published,access,trash	category	8	NULL	54	100.00	Using index condition

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_items	ref	item,catid,language	catid	4	const	3	100.00	Using where

Query Time: 1.28 ms After last query: 2.28 ms Query memory: 0.020 MB Memory before query: 19.361 MB Rows returned: 0

SELECT id
						
  FROM skm6h_k2_categories 
						
  WHERE parent IN (68) 
						
  AND id NOT IN (68) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	PRIMARY,category,parent,published,access,trash,language	parent	5	const	1	100.00	Using where

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:642

JROOT/components/com_k2/models/itemlist.php:771

JROOT/components/com_k2/views/itemlist/view.html.php:180

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.32 ms After last query: 0.37 ms Query memory: 0.019 MB Memory before query: 19.381 MB Rows returned: 1

SELECT COUNT(*) 
  FROM skm6h_k2_items 
  WHERE catid IN (68) 
  AND published=1 
  AND trash=0 
  AND access IN(1,1)  
  AND language IN('en-GB', '*') 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-06 05:48:44' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-06 05:48:44' )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_items	ref	item,catid,language	catid	4	const	9	100.00	Using where

Profile

Status	Duration
Starting	0.2 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.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
End of update loop	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:790

JROOT/components/com_k2/views/itemlist/view.html.php:180

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.70 ms After last query: 2.48 ms Query memory: 0.020 MB Memory before query: 19.404 MB Rows returned: 0

SELECT id
						
  FROM skm6h_k2_categories 
						
  WHERE parent IN (69) 
						
  AND id NOT IN (69) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	PRIMARY,category,parent,published,access,trash,language	parent	5	const	1	100.00	Using where

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.1 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.1 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.1 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.3 ms
Updating status	0.2 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:642

JROOT/components/com_k2/models/itemlist.php:771

JROOT/components/com_k2/views/itemlist/view.html.php:180

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.04 ms After last query: 0.40 ms Query memory: 0.019 MB Memory before query: 19.424 MB Rows returned: 1

SELECT COUNT(*) 
  FROM skm6h_k2_items 
  WHERE catid IN (69) 
  AND published=1 
  AND trash=0 
  AND access IN(1,1)  
  AND language IN('en-GB', '*') 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-06 05:48:44' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-06 05:48:44' )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_items	ref	item,catid,language	catid	4	const	1	100.00	Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:790

JROOT/components/com_k2/views/itemlist/view.html.php:180

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.92 ms After last query: 2.41 ms Query memory: 0.020 MB Memory before query: 19.446 MB Rows returned: 0

SELECT id
						
  FROM skm6h_k2_categories 
						
  WHERE parent IN (70) 
						
  AND id NOT IN (70) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	PRIMARY,category,parent,published,access,trash,language	parent	5	const	1	100.00	Using where

Profile

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

Call Stack

JROOT/components/com_k2/models/itemlist.php:642

JROOT/components/com_k2/models/itemlist.php:771

JROOT/components/com_k2/views/itemlist/view.html.php:180

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.17 ms After last query: 0.35 ms Query memory: 0.019 MB Memory before query: 19.466 MB Rows returned: 1

SELECT COUNT(*) 
  FROM skm6h_k2_items 
  WHERE catid IN (70) 
  AND published=1 
  AND trash=0 
  AND access IN(1,1)  
  AND language IN('en-GB', '*') 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-06 05:48:44' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-06 05:48:44' )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_items	ref	item,catid,language	catid	4	const	6	100.00	Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 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.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:790

JROOT/components/com_k2/views/itemlist/view.html.php:180

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.45 ms After last query: 2.25 ms Query memory: 0.020 MB Memory before query: 19.489 MB Rows returned: 0

SELECT id
						
  FROM skm6h_k2_categories 
						
  WHERE parent IN (71) 
						
  AND id NOT IN (71) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	PRIMARY,category,parent,published,access,trash,language	parent	5	const	1	100.00	Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.3 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:642

JROOT/components/com_k2/models/itemlist.php:771

JROOT/components/com_k2/views/itemlist/view.html.php:180

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.37 ms After last query: 0.44 ms Query memory: 0.019 MB Memory before query: 19.509 MB Rows returned: 1

SELECT COUNT(*) 
  FROM skm6h_k2_items 
  WHERE catid IN (71) 
  AND published=1 
  AND trash=0 
  AND access IN(1,1)  
  AND language IN('en-GB', '*') 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-09-06 05:48:44' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-09-06 05:48:44' )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_items	ref	item,catid,language	catid	4	const	16	100.00	Using where

Profile

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

Call Stack

JROOT/components/com_k2/models/itemlist.php:790

JROOT/components/com_k2/views/itemlist/view.html.php:180

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.37 ms After last query: 5.20 ms Query memory: 0.020 MB Memory before query: 19.566 MB Rows returned: 6

SELECT id
						
  FROM skm6h_k2_categories 
						
  WHERE parent IN (65) 
						
  AND id NOT IN (65) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	PRIMARY,category,parent,published,access,trash,language	parent	5	const	6	100.00	Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Executing	0.1 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.1 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:642

JROOT/components/com_k2/models/itemlist.php:122

JROOT/components/com_k2/views/itemlist/view.html.php:380

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.01 ms After last query: 0.47 ms Query memory: 0.020 MB Memory before query: 19.588 MB Rows returned: 0

SELECT id
						
  FROM skm6h_k2_categories 
						
  WHERE parent IN (66,67,68,69,70,71) 
						
  AND id NOT IN (66,67,68,69,70,71) 
								
  AND published=1 
								
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	range	PRIMARY,category,parent,published,access,trash,language	parent	5	NULL	6	83.33	Using index condition; Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 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.1 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.3 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:642

JROOT/components/com_k2/models/itemlist.php:122

JROOT/components/com_k2/views/itemlist/view.html.php:380

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 27.71 ms After last query: 0.71 ms Query memory: 0.019 MB Memory before query: 19.608 MB Rows returned: 14

SELECT DISTINCT i.`id`,i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM skm6h_k2_items as i RIGHT JOIN skm6h_k2_categories AS c 
  ON c.id = i.catid  
  LEFT JOIN  skm6h_k2_additional_categories AS ca 
  ON ca.`itemID`  = i.`id` 
  WHERE  i.published = 1 
  AND i.access IN(1,1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1) 
  AND c.trash = 0 
  AND c.language IN ('en-GB','*') 
						
  AND i.language IN ('en-GB','*') 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-09-06 05:48:44' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-09-06 05:48:44' ) 
  AND (c.id IN (65,66,67,68,69,70,71) OR ca.`catid` IN (65,66,67,68,69,70,71)) 
  ORDER BY i.title 
  LIMIT 0, 21

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	ref	item,catid,language	item	2	const	101	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash,language	PRIMARY	4	resinsaz_joomla.i.catid	1	100.00	Using index condition; Using where
1	SIMPLE	ca	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	129	100.00	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.5 ms
Init	0.2 ms
Optimizing	0.1 ms
Statistics	0.4 ms
Preparing	0.2 ms
Creating tmp table	0.3 ms
Sorting result	0.2 ms
Executing	0.0 ms
Sending data	22.4 ms
Creating sort index	1.5 ms
Removing tmp table	0.4 ms
Creating sort index	0.1 ms
End of update loop	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:357

JROOT/components/com_k2/views/itemlist/view.html.php:380

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 10.29 ms After last query: 4.36 ms Query memory: 0.019 MB Memory before query: 19.797 MB Rows returned: 1

SELECT COUNT(DISTINCT i.`id`) 
  FROM skm6h_k2_items as i RIGHT JOIN skm6h_k2_categories c 
  ON c.id = i.catid  
  LEFT JOIN  skm6h_k2_additional_categories AS ca 
  ON ca.`itemID`  = i.`id` 
  WHERE  i.published = 1 
  AND i.access IN(1,1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1) 
  AND c.trash = 0 
  AND c.language IN ('en-GB','*') 
						
  AND i.language IN ('en-GB','*') 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-09-06 05:48:44' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-09-06 05:48:44' ) 
  AND (c.id IN (65,66,67,68,69,70,71) OR ca.`catid` IN (65,66,67,68,69,70,71))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	ref	item,catid,language	item	2	const	101	100.00	Using index condition; Using where
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash,language	PRIMARY	4	resinsaz_joomla.i.catid	1	100.00	Using index condition; Using where
1	SIMPLE	ca	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	129	100.00	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.4 ms
Preparing	0.3 ms
Executing	0.0 ms
Sending data	7.3 ms
End of update loop	0.1 ms
Removing tmp table	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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:592

JROOT/components/com_k2/views/itemlist/view.html.php:385

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.15 ms After last query: 4.77 ms Query memory: 0.023 MB Memory before query: 20.037 MB Rows returned: 1

SELECT * 
  FROM skm6h_k2_categories 
  WHERE id = '66'

Explain

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

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/administrator/components/com_k2/tables/k2category.php:65

JROOT/components/com_k2/models/item.php:75

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.99 ms After last query: 5.86 ms Query memory: 0.023 MB Memory before query: 20.163 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 95 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 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.1 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

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: 5.97 ms Query memory: 0.023 MB Memory before query: 20.374 MB Rows returned: 1

Duplicate queries: #57 #61

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=66

Explain

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

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table 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.1 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.86 ms After last query: 0.22 ms Query memory: 0.023 MB Memory before query: 20.398 MB Rows returned: 6

Duplicate queries: #58 #62 #67 #73 #78 #83 #88 #92 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.56 ms After last query: 7.82 ms Query memory: 0.023 MB Memory before query: 20.435 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=95

Explain

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

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 4.71 ms After last query: 2.37 ms Query memory: 0.034 MB Memory before query: 20.618 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `skm6h_users`

Explain

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

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Closing tables	0.1 ms
Opening tables	1.0 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Executing	0.1 ms
Filling schema table	0.1 ms
Opening tables	0.2 ms
After opening tables	0.1 ms
Checking permissions	0.4 ms
Closing tables	0.1 ms
Executing	0.1 ms
Sending data	0.2 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Removing tmp table	0.3 ms
Closing tables	0.1 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/libraries/joomla/table/user.php:38

JROOT/libraries/joomla/table/table.php:305

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

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

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

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

JROOT/libraries/joomla/factory.php:248

JROOT/components/com_k2/models/item.php:247

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

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

SELECT *

  FROM `skm6h_users`

  WHERE `id` = 904

Explain

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

Profile

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

Call Stack

JROOT/libraries/joomla/table/user.php:84

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

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

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

JROOT/libraries/joomla/factory.php:248

JROOT/components/com_k2/models/item.php:247

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.12 ms After last query: 10.67 ms Query memory: 0.028 MB Memory before query: 21.770 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `skm6h_usergroups` AS g

  INNER JOIN `skm6h_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 904

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	resinsaz_joomla.m.group_id	1	100.00

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.2 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.2 ms
Executing	0.1 ms
Sending data	0.3 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/libraries/joomla/table/user.php:109

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

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

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

JROOT/libraries/joomla/factory.php:248

JROOT/components/com_k2/models/item.php:247

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.96 ms After last query: 4.17 ms Query memory: 0.023 MB Memory before query: 21.830 MB Rows returned: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM skm6h_k2_users 
  WHERE userID=904

Explain

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

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1811

JROOT/components/com_k2/models/item.php:250

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.83 ms After last query: 21.58 ms Query memory: 0.028 MB Memory before query: 22.036 MB Rows returned: 0

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

  FROM skm6h_categories as c

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

  LEFT JOIN  (SELECT cat.id as id 
  FROM skm6h_categories AS cat JOIN skm6h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=66 
  AND badcats.id is null

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.7 ms
Checking permissions	0.1 ms
Opening tables	0.4 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.0 ms
Init	0.3 ms
Optimizing	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Statistics	0.3 ms
Preparing	0.1 ms
Preparing	0.0 ms
Executing	0.4 ms
End of update loop	0.1 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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:289

JROOT/libraries/legacy/categories/categories.php:182

JROOT/components/com_content/helpers/route.php:44

JROOT/plugins/content/jw_disqus/jw_disqus.php:185

JROOT/plugins/content/jw_disqus/jw_disqus.php:47

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

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

JROOT/components/com_k2/models/item.php:714

JROOT/components/com_k2/views/itemlist/view.html.php:444

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.47 ms After last query: 29.29 ms Query memory: 0.023 MB Memory before query: 22.298 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 96 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

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: 4.61 ms Query memory: 0.023 MB Memory before query: 22.329 MB Rows returned: 1

Duplicate queries: #48 #61

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=66

Explain

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

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.0 ms
Statistics	0.2 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.04 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 22.353 MB Rows returned: 6

Duplicate queries: #49 #62 #67 #73 #78 #83 #88 #92 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.82 ms After last query: 8.42 ms Query memory: 0.023 MB Memory before query: 22.380 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=96

Explain

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

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.1 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.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.71 ms After last query: 43.72 ms Query memory: 0.023 MB Memory before query: 22.473 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 97 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.2 ms
Statistics	0.2 ms
Preparing	0.2 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.10 ms After last query: 3.75 ms Query memory: 0.023 MB Memory before query: 22.505 MB Rows returned: 1

Duplicate queries: #48 #57

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=66

Explain

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

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.1 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
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.95 ms After last query: 0.35 ms Query memory: 0.024 MB Memory before query: 22.529 MB Rows returned: 6

Duplicate queries: #49 #58 #67 #73 #78 #83 #88 #92 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
Creating sort index	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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.69 ms After last query: 8.00 ms Query memory: 0.023 MB Memory before query: 22.556 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=97

Explain

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

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.89 ms After last query: 38.84 ms Query memory: 0.023 MB Memory before query: 22.550 MB Rows returned: 1

SELECT * 
  FROM skm6h_k2_categories 
  WHERE id = '70'

Explain

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

Profile

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

Call Stack

JROOT/administrator/components/com_k2/tables/k2category.php:65

JROOT/components/com_k2/models/item.php:75

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.43 ms After last query: 8.71 ms Query memory: 0.024 MB Memory before query: 22.679 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 75 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.2 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.58 ms After last query: 3.98 ms Query memory: 0.023 MB Memory before query: 22.711 MB Rows returned: 1

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=70

Explain

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

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.38 ms After last query: 0.39 ms Query memory: 0.023 MB Memory before query: 22.735 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #73 #78 #83 #88 #92 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
End of update loop	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.44 ms After last query: 8.57 ms Query memory: 0.023 MB Memory before query: 22.762 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=75

Explain

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

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.1 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.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 4.11 ms After last query: 15.35 ms Query memory: 0.028 MB Memory before query: 22.736 MB Rows returned: 0

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

  FROM skm6h_categories as c

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

  LEFT JOIN  (SELECT cat.id as id 
  FROM skm6h_categories AS cat JOIN skm6h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=70 
  AND badcats.id is null

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.8 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.3 ms
Optimizing	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Statistics	0.2 ms
Preparing	0.1 ms
Preparing	0.0 ms
Executing	0.4 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Removing tmp table	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:289

JROOT/libraries/legacy/categories/categories.php:182

JROOT/components/com_content/helpers/route.php:44

JROOT/plugins/content/jw_disqus/jw_disqus.php:185

JROOT/plugins/content/jw_disqus/jw_disqus.php:47

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

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

JROOT/components/com_k2/models/item.php:714

JROOT/components/com_k2/views/itemlist/view.html.php:444

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.27 ms After last query: 22.19 ms Query memory: 0.023 MB Memory before query: 22.786 MB Rows returned: 1

SELECT * 
  FROM skm6h_k2_categories 
  WHERE id = '71'

Explain

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

Profile

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

Call Stack

JROOT/administrator/components/com_k2/tables/k2category.php:65

JROOT/components/com_k2/models/item.php:75

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.71 ms After last query: 7.31 ms Query memory: 0.023 MB Memory before query: 22.913 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 77 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 9.06 ms After last query: 4.71 ms Query memory: 0.023 MB Memory before query: 22.945 MB Rows returned: 1

Duplicate queries: #77 #91 #95 #103 #107

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=71

Explain

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

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	6.3 ms
Unlocking tables	0.1 ms
Preparing	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.3 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.21 ms After last query: 0.52 ms Query memory: 0.023 MB Memory before query: 22.968 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #78 #83 #88 #92 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.79 ms After last query: 7.76 ms Query memory: 0.023 MB Memory before query: 22.996 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=77

Explain

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

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.61 ms After last query: 18.31 ms Query memory: 0.028 MB Memory before query: 22.970 MB Rows returned: 0

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

  FROM skm6h_categories as c

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

  LEFT JOIN  (SELECT cat.id as id 
  FROM skm6h_categories AS cat JOIN skm6h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=71 
  AND badcats.id is null

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.8 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.3 ms
Optimizing	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Statistics	0.2 ms
Preparing	0.1 ms
Preparing	0.0 ms
Executing	0.2 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Removing tmp table	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:289

JROOT/libraries/legacy/categories/categories.php:182

JROOT/components/com_content/helpers/route.php:44

JROOT/plugins/content/jw_disqus/jw_disqus.php:185

JROOT/plugins/content/jw_disqus/jw_disqus.php:47

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

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

JROOT/components/com_k2/models/item.php:714

JROOT/components/com_k2/views/itemlist/view.html.php:444

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.32 ms After last query: 23.65 ms Query memory: 0.023 MB Memory before query: 23.119 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 78 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.95 ms After last query: 4.09 ms Query memory: 0.023 MB Memory before query: 23.150 MB Rows returned: 1

Duplicate queries: #72 #91 #95 #103 #107

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=71

Explain

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

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.2 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Unlocking tables	0.0 ms
Preparing	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.2 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.3 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.69 ms After last query: 0.60 ms Query memory: 0.024 MB Memory before query: 23.174 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #83 #88 #92 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.2 ms
Optimizing	0.2 ms
Statistics	0.3 ms
Preparing	0.2 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
Creating sort index	0.4 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.3 ms
Updating status	0.2 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.26 ms After last query: 11.33 ms Query memory: 0.023 MB Memory before query: 23.201 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=78

Explain

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

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.12 ms After last query: 41.81 ms Query memory: 0.023 MB Memory before query: 23.195 MB Rows returned: 1

SELECT * 
  FROM skm6h_k2_categories 
  WHERE id = '68'

Explain

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

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table 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
Executing	0.1 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/administrator/components/com_k2/tables/k2category.php:65

JROOT/components/com_k2/models/item.php:75

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.50 ms After last query: 6.37 ms Query memory: 0.023 MB Memory before query: 23.323 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 72 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.1 ms
Table lock	0.0 ms
Init	0.2 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 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.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.33 ms After last query: 4.53 ms Query memory: 0.023 MB Memory before query: 23.354 MB Rows returned: 1

Duplicate queries: #87 #99

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=68

Explain

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

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.60 ms After last query: 0.66 ms Query memory: 0.023 MB Memory before query: 23.378 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #78 #88 #92 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.2 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
Creating sort index	0.3 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.4 ms
Updating status	0.2 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.93 ms After last query: 7.59 ms Query memory: 0.023 MB Memory before query: 23.405 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=72

Explain

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

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 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.2 ms
Updating status	0.2 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 4.02 ms After last query: 26.22 ms Query memory: 0.028 MB Memory before query: 23.379 MB Rows returned: 0

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

  FROM skm6h_categories as c

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

  LEFT JOIN  (SELECT cat.id as id 
  FROM skm6h_categories AS cat JOIN skm6h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=68 
  AND badcats.id is null

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.8 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.4 ms
Optimizing	0.2 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Statistics	0.2 ms
Preparing	0.2 ms
Preparing	0.1 ms
Executing	0.3 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:289

JROOT/libraries/legacy/categories/categories.php:182

JROOT/components/com_content/helpers/route.php:44

JROOT/plugins/content/jw_disqus/jw_disqus.php:185

JROOT/plugins/content/jw_disqus/jw_disqus.php:47

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

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

JROOT/components/com_k2/models/item.php:714

JROOT/components/com_k2/views/itemlist/view.html.php:444

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.80 ms After last query: 30.17 ms Query memory: 0.023 MB Memory before query: 23.528 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 73 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.80 ms After last query: 3.97 ms Query memory: 0.023 MB Memory before query: 23.559 MB Rows returned: 1

Duplicate queries: #82 #99

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=68

Explain

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

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.1 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
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.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.00 ms After last query: 0.25 ms Query memory: 0.023 MB Memory before query: 23.583 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #78 #83 #92 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	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.1 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.48 ms After last query: 11.77 ms Query memory: 0.023 MB Memory before query: 23.611 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=73

Explain

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

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.19 ms After last query: 44.40 ms Query memory: 0.023 MB Memory before query: 23.704 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 79 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.1 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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.66 ms After last query: 5.30 ms Query memory: 0.023 MB Memory before query: 23.736 MB Rows returned: 1

Duplicate queries: #72 #77 #95 #103 #107

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=71

Explain

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

Profile

Status	Duration
Starting	0.6 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Unlocking tables	0.0 ms
Preparing	0.1 ms
Executing	0.1 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.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.50 ms After last query: 0.48 ms Query memory: 0.024 MB Memory before query: 23.759 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #78 #83 #88 #96 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.2 ms
End of update loop	0.1 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.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.30 ms After last query: 9.10 ms Query memory: 0.023 MB Memory before query: 23.787 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=79

Explain

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

Profile

Status	Duration
Starting	0.6 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 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.1 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.55 ms After last query: 49.51 ms Query memory: 0.023 MB Memory before query: 23.882 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 80 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.9 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.3 ms
Sorting result	0.2 ms
Executing	0.1 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.1 ms
Closing tables	0.0 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 4.26 ms After last query: 5.17 ms Query memory: 0.023 MB Memory before query: 23.914 MB Rows returned: 1

Duplicate queries: #72 #77 #91 #103 #107

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=71

Explain

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

Profile

Status	Duration
Starting	0.9 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.3 ms
Statistics	0.2 ms
Preparing	0.1 ms
Unlocking tables	0.1 ms
Preparing	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.4 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.3 ms
Updating status	0.2 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.85 ms After last query: 0.53 ms Query memory: 0.023 MB Memory before query: 23.937 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #78 #83 #88 #92 #100 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.03 ms After last query: 15.57 ms Query memory: 0.023 MB Memory before query: 23.965 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=80

Explain

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

Profile

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

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.32 ms After last query: 49.06 ms Query memory: 0.023 MB Memory before query: 24.057 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 74 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.9 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
Creating sort index	0.1 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.0 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.3 ms
Updating status	0.2 ms
Reset for next command	0.3 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.45 ms After last query: 2.81 ms Query memory: 0.023 MB Memory before query: 24.089 MB Rows returned: 1

Duplicate queries: #82 #87

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=68

Explain

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

Profile

Status	Duration
Starting	0.7 ms
Checking permissions	0.0 ms
Opening tables	0.1 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.2 ms
Preparing	0.0 ms
Unlocking tables	0.1 ms
Preparing	0.0 ms
Executing	0.3 ms
Sending data	0.1 ms
End of update loop	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.97 ms After last query: 0.40 ms Query memory: 0.023 MB Memory before query: 24.113 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #78 #83 #88 #92 #96 #104 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.4 ms
Optimizing	0.2 ms
Statistics	0.2 ms
Preparing	0.2 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
Creating sort index	0.6 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.0 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.3 ms
Updating status	0.3 ms
Reset for next command	0.2 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.41 ms After last query: 7.40 ms Query memory: 0.023 MB Memory before query: 24.140 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=74

Explain

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

Profile

Status	Duration
Starting	0.6 ms
Checking permissions	0.4 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Executing	0.1 ms
Sending data	0.4 ms
End of update loop	0.2 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.3 ms
Updating status	0.5 ms
Reset for next command	0.2 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.33 ms After last query: 41.47 ms Query memory: 0.023 MB Memory before query: 24.234 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 81 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.2 ms
Reset for next command	0.5 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.83 ms After last query: 2.99 ms Query memory: 0.023 MB Memory before query: 24.266 MB Rows returned: 1

Duplicate queries: #72 #77 #91 #95 #107

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=71

Explain

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

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table 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.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

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

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

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

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

JROOT/components/com_k2/k2.php:63

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

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

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

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.58 ms After last query: 0.41 ms Query memory: 0.023 MB Memory before query: 24.289 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #78 #83 #88 #92 #96 #100 #108 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.2 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.2 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.26 ms After last query: 5.79 ms Query memory: 0.023 MB Memory before query: 24.317 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=81

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_attachments	ref	itemID	itemID	4	const	1	100.00

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 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.1 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.24 ms After last query: 38.77 ms Query memory: 0.023 MB Memory before query: 24.410 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 82 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.8 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.3 ms
Preparing	0.2 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
Creating sort index	0.1 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.4 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.11 ms After last query: 6.15 ms Query memory: 0.023 MB Memory before query: 24.441 MB Rows returned: 1

Duplicate queries: #72 #77 #91 #95 #103

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=71

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.0 ms
Unlocking tables	0.1 ms
Preparing	0.1 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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.67 ms After last query: 0.30 ms Query memory: 0.023 MB Memory before query: 24.465 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #78 #83 #88 #92 #96 #100 #104 #113

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.2 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
Creating sort index	0.3 ms
End of update loop	0.1 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.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.25 ms After last query: 9.16 ms Query memory: 0.023 MB Memory before query: 24.493 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=82

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_attachments	ref	itemID	itemID	4	const	1	100.00

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.22 ms After last query: 39.05 ms Query memory: 0.024 MB Memory before query: 24.486 MB Rows returned: 1

SELECT * 
  FROM skm6h_k2_categories 
  WHERE id = '67'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Unlocking tables	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.1 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/administrator/components/com_k2/tables/k2category.php:65

JROOT/components/com_k2/models/item.php:75

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.02 ms After last query: 8.48 ms Query memory: 0.023 MB Memory before query: 24.614 MB Rows returned: 0

SELECT tag.*
		
  FROM skm6h_k2_tags AS tag
		JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 83 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	resinsaz_joomla.xref.tagID	1	100.00	Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.53 ms After last query: 3.13 ms Query memory: 0.023 MB Memory before query: 24.646 MB Rows returned: 1

SELECT extraFieldsGroup 
  FROM skm6h_k2_categories 
  WHERE id=67

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 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.1 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.1 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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1395

JROOT/components/com_k2/models/item.php:184

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.56 ms After last query: 0.20 ms Query memory: 0.023 MB Memory before query: 24.669 MB Rows returned: 6

Duplicate queries: #49 #58 #62 #67 #73 #78 #83 #88 #92 #96 #100 #104 #108

SELECT * 
  FROM skm6h_k2_extra_fields 
  WHERE `
  group` = 1 
  AND published=1 
  AND (id IN (1,2,3,4,5,6) OR `type` = 'header') 
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_extra_fields	ALL	PRIMARY,group,published	NO INDEX KEY COULD BE USED	NULL	NULL	6	83.33	Using where; Using filesort

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 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.1 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1399

JROOT/components/com_k2/models/item.php:184

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.38 ms After last query: 6.84 ms Query memory: 0.023 MB Memory before query: 24.697 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_attachments 
  WHERE itemID=83

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_attachments	ref	itemID	itemID	4	const	1	100.00

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.2 ms
Query end	0.1 ms
Commit	0.0 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/item.php:1642

JROOT/components/com_k2/models/item.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/joomla/cache/controller/callback.php:41

JROOT/components/com_k2/views/itemlist/view.html.php:435

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.05 ms After last query: 26.69 ms Query memory: 0.028 MB Memory before query: 24.671 MB Rows returned: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM skm6h_categories as c

  LEFT JOIN skm6h_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM skm6h_categories AS cat JOIN skm6h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=67 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.8 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.3 ms
Optimizing	0.1 ms
Optimizing	0.0 ms
Statistics	0.2 ms
Statistics	0.2 ms
Preparing	0.2 ms
Preparing	0.1 ms
Executing	0.4 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Removing tmp table	0.1 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.2 ms
Reset for next command	0.1 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:289

JROOT/libraries/legacy/categories/categories.php:182

JROOT/components/com_content/helpers/route.php:44

JROOT/plugins/content/jw_disqus/jw_disqus.php:185

JROOT/plugins/content/jw_disqus/jw_disqus.php:47

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/components/com_k2/models/item.php:714

JROOT/components/com_k2/views/itemlist/view.html.php:444

JROOT/libraries/joomla/cache/controller/view.php:96

JROOT/libraries/legacy/controller/legacy.php:686

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/itemlist.php:49

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_k2/k2.php:63

JROOT/libraries/cms/component/helper.php:391

JROOT/libraries/cms/component/helper.php:371

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.85 ms After last query: 48.50 ms Query memory: 0.020 MB Memory before query: 24.750 MB Rows returned: 1

SELECT m.*

  FROM skm6h_modules AS m

  LEFT JOIN skm6h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.client_id = 0 
  AND m.id = 322 
  AND m.access IN (1,1) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1	100.00
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	const,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.4 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.2 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.1 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.1 ms
Unlocking tables	0.1 ms
Closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/plugins/system/modulesanywhere/helper.php:568

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.20 ms After last query: 21.17 ms Query memory: 0.027 MB Memory before query: 25.939 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_categories 
  WHERE parent=17 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')  
  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	5	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:562

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.91 ms After last query: 3.50 ms Query memory: 0.020 MB Memory before query: 25.865 MB Rows returned: 1

SELECT m.*

  FROM skm6h_modules AS m

  LEFT JOIN skm6h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.client_id = 0 
  AND m.id = 330 
  AND m.access IN (1,1) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1	100.00
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	const,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.1 ms
Executing	0.0 ms
Sending data	0.2 ms
End of update loop	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/plugins/system/modulesanywhere/helper.php:568

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.61 ms After last query: 9.04 ms Query memory: 0.027 MB Memory before query: 26.047 MB Rows returned: 5

SELECT * 
  FROM skm6h_k2_categories 
  WHERE parent=11 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')  
  ORDER BY id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	7	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.3 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.1 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:562

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.87 ms After last query: 0.57 ms Query memory: 0.028 MB Memory before query: 26.102 MB Rows returned: 4

SELECT * 
  FROM skm6h_k2_categories  
  WHERE parent=49 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	4	100.00	Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.3 ms
Preparing	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:473

JROOT/modules/mod_k2_tools/helper.php:592

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.87 ms After last query: 3.60 ms Query memory: 0.028 MB Memory before query: 26.133 MB Rows returned: 4

SELECT * 
  FROM skm6h_k2_categories 
  WHERE parent=49 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')  
  ORDER BY id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	4	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
Creating sort index	0.4 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.1 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:562

JROOT/modules/mod_k2_tools/helper.php:595

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.51 ms After last query: 0.74 ms Query memory: 0.028 MB Memory before query: 26.161 MB Rows returned: 5

SELECT * 
  FROM skm6h_k2_categories  
  WHERE parent=58 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	5	100.00	Using where

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.1 ms
System lock	0.1 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.4 ms
Preparing	0.1 ms
Executing	0.1 ms
Sending data	0.2 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.1 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:473

JROOT/modules/mod_k2_tools/helper.php:592

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.57 ms After last query: 3.50 ms Query memory: 0.028 MB Memory before query: 26.192 MB Rows returned: 5

SELECT * 
  FROM skm6h_k2_categories 
  WHERE parent=58 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')  
  ORDER BY id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	5	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.3 ms
Preparing	0.2 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:562

JROOT/modules/mod_k2_tools/helper.php:595

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.61 ms After last query: 0.91 ms Query memory: 0.028 MB Memory before query: 26.220 MB Rows returned: 0

SELECT * 
  FROM skm6h_k2_categories  
  WHERE parent=64 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	1	100.00	Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:473

JROOT/modules/mod_k2_tools/helper.php:592

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.36 ms After last query: 2.42 ms Query memory: 0.031 MB Memory before query: 26.257 MB Rows returned: 40

SELECT id, name,  parent	
  FROM skm6h_k2_categories 
  WHERE published=1  
  AND trash=0 
  AND access IN(1,1) 
  AND language IN('en-GB', '*') 
  ORDER BY parent

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,published,access,trash,language	category	2	const	54	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.3 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.1 ms
Optimizing	0.1 ms
Statistics	0.1 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.8 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/components/com_k2/models/itemlist.php:1239

JROOT/components/com_k2/helpers/route.php:321

JROOT/components/com_k2/helpers/route.php:58

JROOT/modules/mod_k2_tools/helper.php:600

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.46 ms After last query: 3.46 ms Query memory: 0.028 MB Memory before query: 26.310 MB Rows returned: 6

SELECT * 
  FROM skm6h_k2_categories  
  WHERE parent=65 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	6	100.00	Using where

Profile

Status	Duration
Starting	0.4 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.1 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Executing	0.0 ms
Sending data	0.3 ms
End of update loop	0.1 ms
Query end	0.1 ms
Commit	0.1 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:473

JROOT/modules/mod_k2_tools/helper.php:592

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.31 ms After last query: 1.47 ms Query memory: 0.028 MB Memory before query: 26.339 MB Rows returned: 6

SELECT * 
  FROM skm6h_k2_categories 
  WHERE parent=65 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')  
  ORDER BY id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	6	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.1 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.4 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.1 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:562

JROOT/modules/mod_k2_tools/helper.php:595

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.64 ms After last query: 0.68 ms Query memory: 0.028 MB Memory before query: 26.367 MB Rows returned: 4

SELECT * 
  FROM skm6h_k2_categories  
  WHERE parent=74 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	4	100.00	Using where

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:473

JROOT/modules/mod_k2_tools/helper.php:592

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.88 ms After last query: 2.28 ms Query memory: 0.029 MB Memory before query: 26.401 MB Rows returned: 4

SELECT * 
  FROM skm6h_k2_categories 
  WHERE parent=74 
  AND published=1 
  AND trash=0  
  AND access IN(1,1)  
  AND language IN ('en-GB', '*')  
  ORDER BY id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	4	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.2 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.2 ms
Preparing	0.1 ms
Sorting result	0.1 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	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.1 ms
Starting cleanup	0.0 ms
Freeing items	0.2 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/modules/mod_k2_tools/helper.php:562

JROOT/modules/mod_k2_tools/helper.php:595

JROOT/modules/mod_k2_tools/mod_k2_tools.php:88

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/module/helper.php:585

JROOT/libraries/joomla/document/html/renderer/module.php:99

JROOT/plugins/system/modulesanywhere/helper.php:659

JROOT/plugins/system/modulesanywhere/helper.php:468

JROOT/plugins/system/modulesanywhere/helper.php:350

JROOT/plugins/system/modulesanywhere/helper.php:308

JROOT/plugins/system/modulesanywhere/helper.php:225

JROOT/plugins/system/modulesanywhere/helper.php:135

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:55

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.40 ms After last query: 16.04 ms Query memory: 0.017 MB Memory before query: 26.765 MB Rows returned: 10

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM skm6h_modules AS m

  LEFT JOIN skm6h_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN skm6h_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 <= '2026-09-06 05:48:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-06 05:48:44') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 453 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	33	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	resinsaz_joomla.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	resinsaz_joomla.m.id	1	100.00	Using where; Using index

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.0 ms
System lock	0.1 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.3 ms
Preparing	0.3 ms
Sorting result	0.1 ms
Executing	0.1 ms
Sending data	0.1 ms
Creating sort index	2.3 ms
End of update loop	0.1 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.1 ms
Freeing items	0.3 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/libraries/cms/module/helper.php:408

JROOT/libraries/cms/module/helper.php:351

JROOT/libraries/cms/module/helper.php:84

JROOT/libraries/joomla/document/html/html.php:514

JROOT/templates/kallyas/index.php:17

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.99 ms After last query: 83.28 ms Query memory: 0.018 MB Memory before query: 27.749 MB Rows returned: 0

SELECT m2.language, m2.id

  FROM skm6h_menu as m

  INNER JOIN skm6h_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN skm6h_associations as a2 
  ON a.key=a2.key

  INNER JOIN skm6h_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=453

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.5 ms
Checking permissions	0.1 ms
Opening tables	0.2 ms
After opening tables	0.1 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.1 ms
Statistics	0.3 ms
Preparing	0.0 ms
Executing	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.1 ms
Updating status	0.1 ms
Reset for next command	0.1 ms

Call Stack

JROOT/administrator/components/com_menus/helpers/menus.php:283

JROOT/modules/mod_languages/helper.php:62

JROOT/modules/mod_languages/mod_languages.php:18

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:399

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.71 ms After last query: 78.56 ms Query memory: 0.003 MB Memory before query: 27.850 MB

UPDATE `skm6h_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1788673723;s:18:\"session.timer.last\";i:1788673723;s:17:\"session.timer.now\";i:1788673723;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":27:{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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}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:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";}'
	, `time` = '1788673725'

  WHERE `session_id` = 'a0vqpi8dhq33nupfugtpt4ok42'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	skm6h_session	range	PRIMARY	PRIMARY	602	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.3 ms
Checking permissions	0.0 ms
Opening tables	0.1 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.3 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	4.3 ms
Closing tables	0.1 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.1 ms
Updating status	0.1 ms
Reset for next command	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:84

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

43 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

19 × SELECT * 
  FROM skm6h_k2_categories

14 × SELECT * 
  FROM skm6h_k2_attachments

14 × SELECT * 
  FROM skm6h_k2_extra_fields

14 × SELECT extraFieldsGroup 
  FROM skm6h_k2_categories

14 × SELECT tag.*   
  FROM skm6h_k2_tags AS tag   JOIN skm6h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

8 × SELECT id       
  FROM skm6h_k2_categories

6 × SELECT COUNT(*) 
  FROM skm6h_k2_items

5 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM skm6h_categories as c 
  LEFT JOIN skm6h_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM skm6h_categories AS cat JOIN skm6h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM skm6h_extensions

2 × SELECT m.* 
  FROM skm6h_modules AS m 
  LEFT JOIN skm6h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

2 × SELECT `ip`,`reason` 
  FROM skm6h_rsfirewall_lists

1 × SELECT DISTINCT i.`id`,i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
  FROM skm6h_k2_items as i RIGHT JOIN skm6h_k2_categories AS c 
  ON c.id = i.catid  
  LEFT JOIN  skm6h_k2_additional_categories AS ca 
  ON ca.`itemID`  = i.`id`

1 × SELECT COUNT(DISTINCT i.`id`) 
  FROM skm6h_k2_items as i RIGHT JOIN skm6h_k2_categories c 
  ON c.id = i.catid  
  LEFT JOIN  skm6h_k2_additional_categories AS ca 
  ON ca.`itemID`  = i.`id`

```
1 × SELECT * 
  FROM `skm6h_users`
```

1 × SELECT m2.language, m2.id 
  FROM skm6h_menu as m 
  INNER JOIN skm6h_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item' 
  INNER JOIN skm6h_associations as a2 
  ON a.key=a2.key 
  INNER JOIN skm6h_menu as m2 
  ON a2.id=m2.id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM skm6h_modules AS m 
  LEFT JOIN skm6h_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN skm6h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id, name,  parent 
  FROM skm6h_k2_categories

1 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM skm6h_k2_users

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `skm6h_usergroups` AS g 
  INNER JOIN `skm6h_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × SELECT b.rules 
  FROM skm6h_assets AS a 
  LEFT JOIN skm6h_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

```
1 × SELECT * 
  FROM skm6h_languages
```

1 × SELECT `path` 
  FROM skm6h_rsfirewall_ignored

1 × SELECT `file` 
  FROM skm6h_rsfirewall_hashes

1 × SELECT folder AS type, element AS name, params 
  FROM skm6h_extensions

1 × SELECT id, rules 
  FROM `skm6h_viewlevels

1 × SELECT `session_id` 
  FROM `skm6h_session`

1 × SELECT b.id 
  FROM skm6h_usergroups AS a 
  LEFT JOIN skm6h_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT * 
  FROM skm6h_rsfirewall_configuratio

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 skm6h_menu AS m 
  LEFT JOIN skm6h_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT a.rules 
  FROM skm6h_assets AS a

1 × SELECT `data` 
  FROM `skm6h_session`

1 × SELECT id, home, template, s.params 
  FROM skm6h_template_styles as s 
  LEFT JOIN skm6h_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM skm6h_rsfirewall_exceptions

1 × SELECT * 
  FROM skm6h_rsfirewall_hashes

1 × SELECT * 
  FROM skm6h_rsfirewall_snapshots

1 × SELECT id 
  FROM skm6h_k2_categories

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `skm6h_users

1 × UPDATE `skm6h_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1788673723;s:18:\"session.timer.last\";i:1788673723;s:17:\"session.timer.now\";i:1788673723;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":27:{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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}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:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";}'  , `time` = '1788673725'

1 × SHOW FULL COLUMNS 
  FROM `skm6h_k2_categories

1 × UPDATE `skm6h_extensions` 
  SET `params` = '{\"mediaversion\":\"bfcefacabddb6698138e4b850d58c517\"}'

1 × INSERT INTO `skm6h_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('a0vqpi8dhq33nupfugtpt4ok42', 0, '1788673723'

1 × SHOW FULL COLUMNS 
  FROM `skm6h_rsfirewall_logs

```
1 × DELETE  
  FROM `skm6h_session`
```

Textile - رزین سازان

Product Search

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

132 Queries Logged 393.5 ms

26 duplicate found!

43 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings