Joomla! Debug Console

63 Queries Logged 46.6 ms

16 duplicate found!

2 duplicates: #9 #10

2 duplicates: #19 #21

8 duplicates: #36 #37 #46 #47 #49 #50 #55 #56

2 duplicates: #53 #54

2 duplicates: #59 #60

Query Time: 0.45 ms
```
SELECT `data`

  FROM `op4k6_session`

  WHERE `session_id` = 'tt49h05jkhrdg4lesgmp2p2ns1'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_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:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:668
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.80 ms After last query: 0.98 ms
```
SELECT `session_id`

  FROM `op4k6_session`

  WHERE `session_id` = 'tt49h05jkhrdg4lesgmp2p2ns1' 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_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:175
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.45 ms After last query: 0.14 ms
```
INSERT INTO `op4k6_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('tt49h05jkhrdg4lesgmp2p2ns1', 0, '1750365546')
```
Explain
EXPLAIN not possible on query: INSERT INTO `op4k6_session` (`session_id`, `client_id`, `time`) VALUES ('tt49h05jkhrdg4lesgmp2p2ns1', 0, '1750365546')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_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	op4k6_session	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

Query Time: 0.76 ms After last query: 1.41 ms

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

  FROM op4k6_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	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/joomla/cache/controller/callback.php:158

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.60 ms After last query: 0.51 ms

SELECT b.id

  FROM op4k6_usergroups AS a

  LEFT JOIN op4k6_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:334

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.46 ms After last query: 0.17 ms
```
SELECT id, rules

  FROM `op4k6_viewlevels`
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_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:420
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.82 ms After last query: 0.14 ms
```
SELECT folder AS type, element AS name, params

  FROM op4k6_extensions

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

  ORDER BY ordering
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 207 42.51 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_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	op4k6_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	207	42.51	Using where; Using filesort

Query Time: 0.91 ms After last query: 0.35 ms

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

  FROM op4k6_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	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/joomla/cache/controller/callback.php:158

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.58 ms After last query: 7.68 ms
Duplicate queries: #10
```
SELECT template

  FROM op4k6_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 5 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:96
JROOT/plugins/system/rokcommon/rokcommon.php:54
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.05 ms After last query: 0.07 ms
Duplicate queries: #9
```
SELECT template

  FROM op4k6_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 5 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:96
JROOT/plugins/system/rokcommon/rokcommon.php:54
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 3.17 ms After last query: 3.72 ms
```
SELECT extension, file, type

  FROM op4k6_rokcommon_configs

  ORDER BY priority
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 100.00 Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/rokcommon/rokcommon.php:132
JROOT/plugins/system/rokcommon/rokcommon.php:76
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.87 ms After last query: 6.71 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM op4k6_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_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:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/helix/core/helix.php:50
JROOT/plugins/system/helix/core/helix.php:36
JROOT/plugins/system/helix/helix.php:21
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.58 ms After last query: 0.19 ms
```
UPDATE `op4k6_extensions`

  SET `params` = '{\"mediaversion\":\"1f2b0f02d2bfe4a13f606f925ed82c74\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_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:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/helix/core/helix.php:50
JROOT/plugins/system/helix/core/helix.php:36
JROOT/plugins/system/helix/helix.php:21
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_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	op4k6_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	NULL	1	100.00	Using where

Query Time: 0.85 ms After last query: 0.93 ms

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

  LEFT JOIN op4k6_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	95	64.19	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	u944685417_mundoferretero.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:47

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

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

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

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

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

JROOT/plugins/system/helix/core/helix.php:65

JROOT/plugins/system/helix/core/helix.php:114

JROOT/plugins/system/helix/core/helix.php:302

JROOT/plugins/system/helix/core/helix.php:290

JROOT/plugins/system/helix/core/helix.php:1592

JROOT/plugins/system/helix/helix.php:22

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.54 ms After last query: 0.71 ms

SELECT id, home, template, s.params

  FROM op4k6_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	5	100.00	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	Using where; Using join buffer (flat, BNL join)

Profile

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

Call Stack

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

JROOT/plugins/system/helix/core/helix.php:65

JROOT/plugins/system/helix/core/helix.php:114

JROOT/plugins/system/helix/core/helix.php:302

JROOT/plugins/system/helix/core/helix.php:290

JROOT/plugins/system/helix/core/helix.php:1592

JROOT/plugins/system/helix/helix.php:22

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.48 ms After last query: 3.30 ms

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

  FROM op4k6_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	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/joomla/cache/controller/callback.php:158

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

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

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.18 ms After last query: 1.40 ms
```
SHOW FULL COLUMNS 
  FROM `op4k6_extensions`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `op4k6_extensions`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/libraries/joomla/table/extension.php:31
JROOT/libraries/joomla/table/table.php:301
JROOT/plugins/system/roksprocket/roksprocket.php:46
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.43 ms After last query: 0.74 ms
```
SELECT `extension_id`

  FROM `op4k6_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/extension.php:108
JROOT/plugins/system/roksprocket/roksprocket.php:50
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.40 ms After last query: 0.11 ms
Duplicate queries: #21
```
SELECT *

  FROM op4k6_extensions

  WHERE `extension_id` = '10009'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_extensions 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/table/table.php:723
JROOT/plugins/system/roksprocket/roksprocket.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.58 ms After last query: 0.10 ms
```
SELECT `extension_id`

  FROM `op4k6_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/extension.php:108
JROOT/plugins/system/roksprocket/roksprocket.php:73
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.05 ms After last query: 0.14 ms
Duplicate queries: #19
```
SELECT *

  FROM op4k6_extensions

  WHERE `extension_id` = '10009'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_extensions 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/table/table.php:723
JROOT/plugins/system/roksprocket/roksprocket.php:77
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.82 ms After last query: 38.74 ms
```
SELECT *

  FROM op4k6_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 op4k6_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 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:166
JROOT/libraries/cms/application/site.php:336
JROOT/components/com_k2/helpers/utilities.php:315
JROOT/administrator/components/com_k2/helpers/html.php:56
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.58 ms After last query: 1.77 ms
```
SELECT a.rules

  FROM op4k6_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:248
JROOT/libraries/joomla/user/user.php:364
JROOT/components/com_k2/k2.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where; Using index

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where; Using index

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

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

Query Time: 1.38 ms After last query: 0.63 ms

SELECT b.rules

  FROM op4k6_assets AS a

  LEFT JOIN op4k6_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	241	96.27	Using where

Profile

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

Call Stack

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

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

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

JROOT/components/com_k2/k2.php:16

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.04 ms After last query: 2.63 ms

SELECT id 
  FROM op4k6_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	op4k6_k2_categories	index_merge	category,published,access,trash	trash,published	2,2	NULL	14	100.00	Using intersect(trash,published); Using where

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/item/view.html.php:36

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.56 ms After last query: 0.10 ms
```
SELECT * 
  FROM op4k6_k2_items 
  WHERE id=1360 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_items const PRIMARY PRIMARY 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:36
JROOT/components/com_k2/views/item/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.32 ms After last query: 0.59 ms
```
SHOW FULL COLUMNS 
  FROM `op4k6_k2_categories`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `op4k6_k2_categories`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/administrator/components/com_k2/tables/k2category.php:34
JROOT/libraries/joomla/table/table.php:301
JROOT/components/com_k2/models/item.php:74
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.35 ms After last query: 0.18 ms
```
SELECT * 
  FROM op4k6_k2_categories 
  WHERE id = '3'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_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/models/item.php:75
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.61 ms After last query: 1.75 ms
```
SELECT * 
  FROM op4k6_k2_categories 
  WHERE id = '1'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_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/models/item.php:96
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

Query Time: 0.69 ms After last query: 0.50 ms

SELECT tag.*
		
  FROM op4k6_k2_tags AS tag
		JOIN op4k6_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 1360 
  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	5	100.00	Using where; Using filesort
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	u944685417_mundoferretero.xref.tagID	1	99.52	Using where

Profile

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

Call Stack

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

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

JROOT/components/com_k2/views/item/view.html.php:51

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.47 ms After last query: 1.07 ms
```
SELECT * 
  FROM op4k6_k2_attachments 
  WHERE itemID=1360
```
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/components/com_k2/models/item.php:1642
JROOT/components/com_k2/models/item.php:190
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.47 ms After last query: 0.08 ms
```
SELECT * 
  FROM op4k6_k2_rating 
  WHERE itemID = 1360
```
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/components/com_k2/models/item.php:990
JROOT/components/com_k2/models/item.php:1046
JROOT/components/com_k2/models/item.php:196
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.22 ms After last query: 0.40 ms
```
SHOW FULL COLUMNS 
  FROM `op4k6_users`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `op4k6_users`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/libraries/joomla/table/user.php:38
JROOT/libraries/joomla/table/table.php:301
JROOT/libraries/joomla/user/user.php:541
JROOT/libraries/joomla/user/user.php:824
JROOT/libraries/joomla/user/user.php:226
JROOT/libraries/joomla/user/user.php:275
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.63 ms After last query: 0.18 ms
```
SELECT *

  FROM `op4k6_users`

  WHERE `id` = 936
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_users 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/table/user.php:84
JROOT/libraries/joomla/user/user.php:827
JROOT/libraries/joomla/user/user.php:226
JROOT/libraries/joomla/user/user.php:275
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.63 ms After last query: 1.41 ms
```
SELECT `g`.`id`,`g`.`title`

  FROM `op4k6_usergroups` AS g

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

  WHERE `m`.`user_id` = 936
```
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 u944685417_mundoferretero.m.group_id 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/user.php:109
JROOT/libraries/joomla/user/user.php:827
JROOT/libraries/joomla/user/user.php:226
JROOT/libraries/joomla/user/user.php:275
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.46 ms After last query: 1.48 ms
Duplicate queries: #37 #46 #47 #49 #50 #55 #56
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=936
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_users ref userID userID 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/models/item.php:250
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.05 ms After last query: 0.12 ms
Duplicate queries: #36 #46 #47 #49 #50 #55 #56
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=936
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_users ref userID userID 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/helpers/utilities.php:65
JROOT/components/com_k2/models/item.php:251
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.33 ms After last query: 5.06 ms
```
SHOW FULL COLUMNS 
  FROM `op4k6_k2_items`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `op4k6_k2_items`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/administrator/components/com_k2/tables/k2item.php:56
JROOT/libraries/joomla/table/table.php:301
JROOT/components/com_k2/models/item.php:895
JROOT/components/com_k2/views/item/view.html.php:135
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

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

Query Time: 0.51 ms After last query: 0.27 ms

UPDATE op4k6_k2_items

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

  WHERE `id` = '1360'

Explain

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

Profile

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

Call Stack

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

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

JROOT/components/com_k2/views/item/view.html.php:135

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.50 ms After last query: 0.15 ms

SELECT * 
  FROM op4k6_k2_comments 
  WHERE itemID=1360 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where; Using filesort

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.3 ms
Preparing	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.9 ms
End of update loop	0.0 ms
Query end	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Query end	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

JROOT/components/com_k2/views/item/view.html.php:231

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.99 ms After last query: 0.43 ms

SELECT i.*, c.alias as categoryalias 
  FROM op4k6_k2_items as i 
				
  LEFT JOIN op4k6_k2_categories c 
  ON c.id = i.catid 
				
  WHERE i.id != 1360 
				
  AND i.published = 1 
				
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-06-19 20:39:06' ) 
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-06-19 20:39:06' )  
  AND i.access IN(1,1)  
  AND i.trash = 0 
				
  AND i.created_by = 936 
				
  AND i.created_by_alias='' 
				
  AND c.published = 1  
  AND c.access IN(1,1)  
  AND c.trash = 0 
				
  ORDER BY i.created DESC 
  LIMIT 0, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	index	PRIMARY,item,catid,created_by	created	5	NULL	18	81.17	Using where
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	u944685417_mundoferretero.i.catid	1	51.52	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
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
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Query end	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

JROOT/components/com_k2/views/item/view.html.php:275

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.32 ms After last query: 0.69 ms

SELECT id, name,  parent	
  FROM op4k6_k2_categories 
  WHERE published=1  
  AND trash=0 
  AND access IN(1,1) 
  ORDER BY parent

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_k2_categories	index_merge	category,published,access,trash	trash,published	2,2	NULL	14	100.00	Using intersect(trash,published); Using where; Using filesort

Profile

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

Call Stack

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

JROOT/components/com_k2/helpers/route.php:321

JROOT/components/com_k2/helpers/route.php:41

JROOT/components/com_k2/views/item/view.html.php:280

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 5.20 ms After last query: 0.96 ms

SELECT DISTINCT itemID 
  FROM op4k6_k2_tags_xref 
  WHERE tagID IN (188,15,4,189,67) 
  AND itemID!=1360

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	op4k6_k2_tags_xref	range	tagID,itemID	tagID	4	NULL	699	99.92	Using index condition; Using where; Using temporary

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
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
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Query end	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 2.54 ms After last query: 0.54 ms

SELECT i.*, c.alias as categoryalias 
  FROM op4k6_k2_items as i 
				
  LEFT JOIN op4k6_k2_categories c 
  ON c.id = i.catid 
				
  WHERE i.published = 1 
				
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-06-19 20:39:06' ) 
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-06-19 20:39:06' )  
  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 (i.id) IN (13,41,44,24,15,220,259,368,373,432,452,455,466,471,493,515,535,549,550,551,557,575,582,589,590,594,595,596,597,598,602,627,628,626,629,630,631,632,633,636,648,649,654,660,668,667,671,678,682,683,684,685,686,692,696,713,746,772,773,778,796,815,818,820,837,844,847,861,895,898,899,900,916,919,921,926,948,949,952,954,956,957,958,959,965,966,967,968,969,970,971,972,978,980,981,984,993,1005,1007,1009,1011,1012,1014,1015,1016,1017,1018,1019,1025,1038,1039,1048,1058,1059,1060,1061,1066,1067,1068,1069,1075,1076,1086,1087,1091,1096,1099,1103,1109,1110,1112,1114,1116,1120,1130,1131,1133,1132,1137,1139,1141,1159,1162,1165,1171,1177,1192,1198,1202,1215,1221,1222,1225,1241,1244,1262,1276,1277,1281,1308,1311,1313,1315,1328,1329,1343,1349,1361,1364,1365,1366,1369,1374,1378,1380,1381,1389,1394,1395,1398,1400,1403,1405,1404,1407,1408,1409,1412,1414,1425,1426,1436,1440,1444,1456,1461,1469,1474,1475,1476,1477,1490,1494,1500,1501,1505,1506,1507,1509,1530,1535,1545,1550,1551,1558,1559,1563,1567,1572,1573,1574,1577,25,27,157,204,219,341,343,344,350,351,352,353,363,377,378,379,380,381,382,383,390,418,429,430,457,469,470,473,476,475,480,481,482,483,484,486,487,488,489,490,491,495,497,503,504,506,508,507,510,511,512,513,517,520,521,522,523,528,536,537,538,540,541,542,543,544,547,548,560,561,565,566,592,593,607,608,611,612,613,614,615,616,617,618,621,622,623,624,625,634,635,637,638,639,640,641,643,644,647,656,658,657,663,661,664,675,676,679,681,680,688,691,694,695,700,701,707,708,709,711,712,714,719,720,722,723,731,734,742,743,749,750,751,752,753,758,771,776,782,785,788,789,791,793,794,808,811,817,816,819,821,834,842,841,846,859,860,888,889,917,928,927,929,955,983,992,998,1003,1004,1008,1040,1095,1097,1113,1122,1136,1135,1164,1170,1188,1189,1191,1197,1203,1210,1213,1220,1235,1236,1238,1243,1248,1245,1249,1260,1261,1269,1271,1310,1321,1322,1323,1324,1325,1345,1346,1347,1351,1359,1363,1371,1382,1399,1401,1402,1410,1427,1438,1439,1452,1453,1467,1429,1471,1470,1472,1473,1479,1480,1481,1482,1495,1498,1503,1519,1523,1522,1524,1525,1529,1536,1537,1538,1539,1540,1541,53,20,115,221,224,300,301,802,824,835,848,855,875,885,887,904,907,912,914,1033,1044,1074,1077,1083,1118,1140,1149,1180,1186,1204,1211,1263,1288,1289,1290,1291,1292,1293,1300,1318,1326,1332,1358,1397,1487,1547,1352,1353,1354,1356,1355,1357,1362,1367,1368) 
				
  ORDER BY i.created DESC 
  LIMIT 0, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	index	PRIMARY,item,catid	created	5	NULL	29	30.81	Using where
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	u944685417_mundoferretero.i.catid	1	51.52	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
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
Query end	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Query end	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.82 ms After last query: 0.33 ms

SELECT * 
  FROM op4k6_k2_categories 
  WHERE id = '19'

Explain

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

Profile

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

Call Stack

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

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.29 ms After last query: 2.88 ms

Duplicate queries: #36 #37 #47 #49 #50 #55 #56

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=936

Explain

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

Profile

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

Call Stack

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

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.05 ms After last query: 0.12 ms

Duplicate queries: #36 #37 #46 #49 #50 #55 #56

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=936

Explain

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

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
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
Query end	0.0 ms
closing tables	0.0 ms
Unlocking tables	0.0 ms
closing tables	0.0 ms
Query end	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

JROOT/components/com_k2/helpers/utilities.php:65

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.45 ms After last query: 1.00 ms

SELECT * 
  FROM op4k6_k2_categories 
  WHERE id = '6'

Explain

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

Profile

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

Call Stack

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

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.07 ms After last query: 1.75 ms

Duplicate queries: #36 #37 #46 #47 #50 #55 #56

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=936

Explain

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

Profile

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

Call Stack

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

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.04 ms After last query: 0.12 ms

Duplicate queries: #36 #37 #46 #47 #49 #55 #56

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=936

Explain

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

Profile

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

Call Stack

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

JROOT/components/com_k2/helpers/utilities.php:65

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.63 ms After last query: 1.92 ms

SELECT *

  FROM `op4k6_users`

  WHERE `id` = 939

Explain

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

Profile

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

Call Stack

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

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

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

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

JROOT/libraries/joomla/factory.php:246

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.57 ms After last query: 0.18 ms

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

  FROM `op4k6_usergroups` AS g

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

  WHERE `m`.`user_id` = 939

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	u944685417_mundoferretero.m.group_id	1	100.00

Profile

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

Call Stack

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

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

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

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

JROOT/libraries/joomla/factory.php:246

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.41 ms After last query: 0.84 ms

Duplicate queries: #54

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=939

Explain

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

Profile

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

Call Stack

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

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

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

JROOT/components/com_k2/views/item/view.html.php:290

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

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

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.04 ms After last query: 0.11 ms
Duplicate queries: #53
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=939
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_users ref userID userID 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/helpers/utilities.php:65
JROOT/components/com_k2/models/item.php:251
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.07 ms After last query: 2.38 ms
Duplicate queries: #36 #37 #46 #47 #49 #50 #56
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=936
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_users ref userID userID 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/models/item.php:250
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.04 ms After last query: 0.08 ms
Duplicate queries: #36 #37 #46 #47 #49 #50 #55
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=936
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_users ref userID userID 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/helpers/utilities.php:65
JROOT/components/com_k2/models/item.php:251
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.53 ms After last query: 1.85 ms
```
SELECT *

  FROM `op4k6_users`

  WHERE `id` = 959
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_users 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/table/user.php:84
JROOT/libraries/joomla/user/user.php:827
JROOT/libraries/joomla/user/user.php:226
JROOT/libraries/joomla/user/user.php:275
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.51 ms After last query: 0.17 ms
```
SELECT `g`.`id`,`g`.`title`

  FROM `op4k6_usergroups` AS g

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

  WHERE `m`.`user_id` = 959
```
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 u944685417_mundoferretero.m.group_id 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/user.php:109
JROOT/libraries/joomla/user/user.php:827
JROOT/libraries/joomla/user/user.php:226
JROOT/libraries/joomla/user/user.php:275
JROOT/libraries/joomla/factory.php:246
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.43 ms After last query: 0.84 ms
Duplicate queries: #60
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=959
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_users ref userID userID 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/models/item.php:250
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.05 ms After last query: 0.10 ms
Duplicate queries: #59
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users 
  WHERE userID=959
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_users ref userID userID 4 const 1 100.00
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/helpers/utilities.php:65
JROOT/components/com_k2/models/item.php:251
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.75 ms After last query: 1.11 ms
```
SELECT * 
  FROM op4k6_k2_items 
  WHERE id != 1360 
  AND catid=3 
  AND ordering > 51 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-06-19 20:39:06' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-06-19 20:39:06' )  
  AND access IN(1,1) 
  AND trash=0  
  ORDER BY ordering ASC 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_items range PRIMARY,item,catid,ordering ordering 4 NULL 586 34.52 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1792
JROOT/components/com_k2/views/item/view.html.php:307
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.57 ms After last query: 0.44 ms
```
SELECT * 
  FROM op4k6_k2_items 
  WHERE id != 1360 
  AND catid=3 
  AND ordering < 51 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-06-19 20:39:06' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-06-19 20:39:06' )  
  AND access IN(1,1) 
  AND trash=0  
  ORDER BY ordering DESC 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE op4k6_k2_items range PRIMARY,item,catid,ordering ordering 4 NULL 1002 59.02 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1747
JROOT/components/com_k2/views/item/view.html.php:348
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.64 ms After last query: 16.75 ms

UPDATE `op4k6_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1750365546;s:18:\"session.timer.last\";i:1750365546;s:17:\"session.timer.now\";i:1750365546;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"8f871dd9255c5b7afc867d5eefb099ceec4b5ab9\";O:8:\"stdClass\":2:{s:4:\"link\";s:94:\"https://mundoferretero.mx/index.php/construccion/item/1360-por-mi-rumbo?print=1&tmpl=component\";s:6:\"expiry\";i:1750365546;}}}'
	, `time` = '1750365546'

  WHERE `session_id` = 'tt49h05jkhrdg4lesgmp2p2ns1'

Explain

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

Profile

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

Call Stack

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

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

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

12 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM op4k6_k2_users

4 × SELECT * 
  FROM op4k6_k2_categories

4 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM op4k6_extensions

```
3 × SELECT * 
  FROM `op4k6_users`
```
```
3 × SELECT * 
  FROM op4k6_k2_items
```

3 × SELECT `g`.`id`,`g`.`title` 
  FROM `op4k6_usergroups` AS g 
  INNER JOIN `op4k6_user_usergroup_map` AS m 
  ON m.group_id = g.id

2 × SELECT template 
  FROM op4k6_template_styles as s

```
2 × SELECT * 
  FROM op4k6_extensions
```

2 × SELECT i.*, c.alias as categoryalias 
  FROM op4k6_k2_items as i      
  LEFT JOIN op4k6_k2_categories c 
  ON c.id = i.catid

2 × SELECT `extension_id` 
  FROM `op4k6_extensions`

1 × SELECT tag.*   
  FROM op4k6_k2_tags AS tag   JOIN op4k6_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

1 × SELECT id, name,  parent 
  FROM op4k6_k2_categories

1 × SELECT * 
  FROM op4k6_k2_attachments

```
1 × SELECT * 
  FROM op4k6_k2_rating
```

1 × SELECT * 
  FROM op4k6_k2_comments

1 × SELECT DISTINCT itemID 
  FROM op4k6_k2_tags_xref

1 × SELECT a.rules 
  FROM op4k6_assets AS a

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

1 × SELECT id, rules 
  FROM `op4k6_viewlevels

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

1 × SELECT `session_id` 
  FROM `op4k6_session`

1 × SELECT extension, file, type 
  FROM op4k6_rokcommon_configs

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

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

1 × SELECT `data` 
  FROM `op4k6_session`

```
1 × SELECT * 
  FROM op4k6_languages
```

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

1 × SELECT id 
  FROM op4k6_k2_categories

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `op4k6_k2_items

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

1 × UPDATE `op4k6_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1750365546;s:18:\"session.timer.last\";i:1750365546;s:17:\"session.timer.now\";i:1750365546;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"8f871dd9255c5b7afc867d5eefb099ceec4b5ab9\";O:8:\"stdClass\":2:{s:4:\"link\";s:94:\"https://mundoferretero.mx/index.php/construccion/item/1360-por-mi-rumbo?print=1&tmpl=component\";s:6:\"expiry\";i:1750365546;}}}'  , `time` = '1750365546'

1 × SHOW FULL COLUMNS 
  FROM `op4k6_users

1 × SHOW FULL COLUMNS 
  FROM `op4k6_k2_categories

1 × UPDATE `op4k6_extensions` 
  SET `params` = '{\"mediaversion\":\"1f2b0f02d2bfe4a13f606f925ed82c74\"}'

1 × SHOW FULL COLUMNS 
  FROM `op4k6_extensions

1 × INSERT INTO `op4k6_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('tt49h05jkhrdg4lesgmp2p2ns1', 0, '1750365546'

Por mi rumbo

La redacción

Latest from La redacción

Related items

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

63 Queries Logged 46.6 ms

16 duplicate found!

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: