Consola de depuración de Joomla!

Información del perfil

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.593 MB / 0.59 MB Application: afterLoad

Time: 35.2 ms / 35.2 ms Memory: 4.470 MB / 5.06 MB Application: afterInitialise

Time: 18.7 ms / 53.9 ms Memory: 1.988 MB / 7.05 MB Application: afterRoute

Time: 23.8 ms / 77.7 ms Memory: 1.667 MB / 8.72 MB Application: afterDispatch

Time: 21.9 ms / 99.7 ms Memory: 2.656 MB / 11.37 MB Application: beforeRenderModule mod_custom (Chat)

Time: 1.4 ms / 101.1 ms Memory: 0.062 MB / 11.44 MB Application: afterRenderModule mod_custom (Chat)

Time: 0.1 ms / 101.1 ms Memory: 0.000 MB / 11.43 MB Application: beforeRenderModule mod_custom (Copyright)

Time: 0.3 ms / 101.4 ms Memory: 0.007 MB / 11.44 MB Application: afterRenderModule mod_custom (Copyright)

Time: 0.1 ms / 101.5 ms Memory: 0.000 MB / 11.44 MB Application: beforeRenderModule mod_custom (Mapa del sitio)

Time: 0.3 ms / 101.8 ms Memory: 0.007 MB / 11.45 MB Application: afterRenderModule mod_custom (Mapa del sitio)

Time: 0.1 ms / 102.0 ms Memory: 0.007 MB / 11.45 MB Application: beforeRenderModule mod_latestnewsenhanced (Noticias)

Time: 6.9 ms / 108.9 ms Memory: 0.633 MB / 12.09 MB Application: afterRenderModule mod_latestnewsenhanced (Noticias)

Time: 0.1 ms / 109.0 ms Memory: 0.000 MB / 12.06 MB Application: beforeRenderModule mod_articleplacedanywhere (BANNER Lateral)

Time: 13.5 ms / 122.5 ms Memory: 0.834 MB / 12.90 MB Application: afterRenderModule mod_articleplacedanywhere (BANNER Lateral)

Time: 0.1 ms / 122.6 ms Memory: 0.000 MB / 12.88 MB Application: beforeRenderModule mod_acymailing (SUSCRÍBETE!)

Time: 9.0 ms / 131.6 ms Memory: 0.972 MB / 13.85 MB Application: afterRenderModule mod_acymailing (SUSCRÍBETE!)

Time: 0.1 ms / 131.6 ms Memory: 0.000 MB / 13.82 MB Application: beforeRenderModule mod_custom (Trabaja con nosotros)

Time: 0.3 ms / 131.9 ms Memory: 0.007 MB / 13.83 MB Application: afterRenderModule mod_custom (Trabaja con nosotros)

Time: 0.0 ms / 131.9 ms Memory: 0.000 MB / 13.83 MB Application: beforeRenderModule mod_custom (Registra tu inmueble)

Time: 0.2 ms / 132.2 ms Memory: 0.007 MB / 13.83 MB Application: afterRenderModule mod_custom (Registra tu inmueble)

Time: 0.1 ms / 132.3 ms Memory: 0.000 MB / 13.83 MB Application: beforeRenderModule mod_articleplacedanywhere (Info contatco)

Time: 4.7 ms / 137.0 ms Memory: 0.114 MB / 13.95 MB Application: afterRenderModule mod_articleplacedanywhere (Info contatco)

Time: 0.1 ms / 137.1 ms Memory: 0.000 MB / 13.93 MB Application: beforeRenderModule mod_reslider (BANNER Header dinámico)

Time: 4.4 ms / 141.5 ms Memory: 0.294 MB / 14.23 MB Application: afterRenderModule mod_reslider (BANNER Header dinámico)

Time: 0.1 ms / 141.6 ms Memory: 0.000 MB / 14.20 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.3 ms / 141.9 ms Memory: 0.007 MB / 14.21 MB Application: afterRenderModule mod_custom (Logo)

Time: 16.1 ms / 158.0 ms Memory: 0.402 MB / 14.61 MB Application: afterRender

Database queries total: 22.6 ms

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

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	9	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	incolmen_joomdb.m.component_id	1	Using where

EXPLAIN not possible on query: UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"20c5598ccb37620951b77eba78f71220\",\"Array\":[\"449d0bd2e4e562e7d26a1f9750097a16\"]}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
table lock	0.0 ms
init for update	0.0 ms
Updating	0.1 ms
End of update loop	0.0 ms
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/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/k2/k2.php:52

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

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

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

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

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: 2.03 ms Query memory: 0.022 MB Memory before query: 5.907 MB Rows returned: 2

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

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.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
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/language/helper.php:166

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.33 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 5.949 MB Rows returned: 1

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

  FROM jos_extensions

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

Explain

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

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.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/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:350

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

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

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

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

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: 1.55 ms Query memory: 0.027 MB Memory before query: 6.218 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM jos_template_styles as s

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

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

Explain

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

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.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/libraries/cms/application/site.php:473

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

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

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

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

JROOT/libraries/cms/html/behavior.php:63

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

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

JROOT/administrator/components/com_k2/helpers/html.php:76

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.11 ms After last query: 48.46 ms Query memory: 0.026 MB Memory before query: 11.226 MB Rows returned: 11

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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 <= '2024-12-07 14:51:43') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-07 14:51:43') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	22	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	incolmen_joomdb.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	incolmen_joomdb.m.module,const	1	Using index condition; 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.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.3 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.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

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

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

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

JROOT/templates/t3_bs3_blank/tpls/blocks/spotlight-3-CUSTOM.php:11

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

JROOT/templates/t3_bs3_blank/tpls/CUSTOM.php:32

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

JROOT/templates/t3_bs3_blank/index.php:34

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

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

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

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

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

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: 2.77 ms Query memory: 0.015 MB Memory before query: 11.300 MB Rows returned: 1

SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1)

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

Explain

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

Profile

Status	Duration
Starting	0.1 ms
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/libraries/joomla/access/access.php:250

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

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

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

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

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

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

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

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.00 ms After last query: 0.47 ms Query memory: 0.016 MB Memory before query: 11.348 MB Rows returned: 2

SELECT b.rules

  FROM jos_assets AS a

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

  WHERE (a.name = 'com_menus')

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

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	27	Using where

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
Unlocking tables	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.3 ms
Creating sort index	0.0 ms
Removing tmp table	0.1 ms
Creating sort index	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/libraries/joomla/access/access.php:250

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

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

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

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

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

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

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

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

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: 5.99 ms Query memory: 0.024 MB Memory before query: 12.070 MB Rows returned: 1

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

  FROM jos_extensions

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

Explain

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

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
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/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/modules/mod_latestnewsenhanced/helpers/helper_standard.php:45

JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:36

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

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

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

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

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

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

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

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

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.92 ms After last query: 0.35 ms Query memory: 0.026 MB Memory before query: 12.109 MB Rows returned: 2

SELECT b.rules

  FROM jos_assets AS a

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

  WHERE (a.name = 'com_content')

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

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	10	Using where

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
Unlocking tables	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.2 ms
Creating sort index	0.1 ms
Removing tmp table	0.1 ms
Creating sort index	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.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

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

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

JROOT/components/com_content/models/articles.php:449

JROOT/libraries/legacy/model/list.php:131

JROOT/libraries/legacy/model/list.php:183

JROOT/components/com_content/models/articles.php:537

JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:143

JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:36

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

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

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

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

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

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

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

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

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.16 ms After last query: 0.19 ms Query memory: 0.030 MB Memory before query: 12.138 MB Rows returned: 0

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM jos_content AS a

  LEFT JOIN jos_content_frontpage AS fp 
  ON fp.content_id = a.id

  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_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 a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (11) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-07 14:51:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-07 14:51:43')

  ORDER BY a.publish_up DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	1	Using where; Using filesort
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	incolmen_joomdb.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	incolmen_joomdb.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	incolmen_joomdb.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.2 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
Optimizing	0.0 ms
Statistics	0.1 ms
Statistics	0.1 ms
Preparing	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
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.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

JROOT/libraries/legacy/model/list.php:187

JROOT/components/com_content/models/articles.php:537

JROOT/modules/mod_latestnewsenhanced/helpers/helper_standard.php:143

JROOT/modules/mod_latestnewsenhanced/mod_latestnewsenhanced.php:36

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

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

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

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

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

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

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

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

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.01 ms After last query: 2.35 ms Query memory: 0.027 MB Memory before query: 12.159 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM jos_content AS a

  LEFT JOIN jos_categories AS c 
  on c.id = a.catid

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 4 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-07 14:51:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-07 14:51:43') 
  AND a.access IN (1,1,5) 
  AND a.state = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_access,idx_state	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	<derived2>	ref	key0	key0	5	const	1
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	11	Using where; Using index; Using join buffer (flat, BNL join)

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.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Statistics	0.1 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	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
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
Removing tmp table	0.0 ms
Creating sort index	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
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/modules/mod_articleplacedanywhere/helper.php:117

JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:25

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

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

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

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

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

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

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

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

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.55 ms After last query: 1.26 ms Query memory: 0.029 MB Memory before query: 12.351 MB Rows returned: 2

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

  FROM jos_categories as c

  LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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,5) 
  AND c.published = 1 
  AND s.id=8 
  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	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	11	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	incolmen_joomdb.c.id	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	11	Using where; Using index; Using join buffer (flat, BNL join)

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.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Statistics	0.1 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
Removing tmp table	0.0 ms
Creating sort index	0.3 ms
Creating sort index	0.1 ms
Removing tmp table	0.1 ms
Creating sort index	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
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.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

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

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

JROOT/modules/mod_articleplacedanywhere/helper.php:19

JROOT/modules/mod_articleplacedanywhere/tmpl/default.php:13

JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:48

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

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

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

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

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

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

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

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

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.14 ms After last query: 6.24 ms Query memory: 0.024 MB Memory before query: 12.933 MB Rows returned: 4

SELECT b.rules

  FROM jos_assets AS a

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

  WHERE (a.name = 'com_content.article.4')

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

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	14	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.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.3 ms
Creating sort index	0.1 ms
Removing tmp table	0.1 ms
Creating sort index	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.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

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

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

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

JROOT/modules/mod_articleplacedanywhere/tmpl/_item.php:32

JROOT/modules/mod_articleplacedanywhere/helper.php:54

JROOT/modules/mod_articleplacedanywhere/tmpl/default.php:13

JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:48

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

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

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

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

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

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

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

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

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: 5.96 ms Query memory: 0.022 MB Memory before query: 13.570 MB Rows returned: 77

SELECT * 
  FROM jos_acymailing_config

Explain

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

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.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/administrator/components/com_acymailing/classes/cpanel.php:17

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

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

JROOT/modules/mod_acymailing/mod_acymailing.php:12

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

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

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

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

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

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

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

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

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.39 ms After last query: 1.75 ms Query memory: 0.022 MB Memory before query: 13.921 MB Rows returned: 1

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

Explain

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

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.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/administrator/components/com_acymailing/classes/list.php:29

JROOT/modules/mod_acymailing/mod_acymailing.php:117

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

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

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

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

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

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

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

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

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.00 ms After last query: 1.87 ms Query memory: 0.027 MB Memory before query: 13.880 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM jos_content AS a

  LEFT JOIN jos_categories AS c 
  on c.id = a.catid

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-07 14:51:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-07 14:51:43') 
  AND a.access IN (1,1,5) 
  AND a.state = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_access,idx_state	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	<derived2>	ref	key0	key0	5	const	1
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	11	Using where; Using index; Using join buffer (flat, BNL join)

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.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Statistics	0.1 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	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
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
Removing tmp table	0.0 ms
Creating sort index	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
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/modules/mod_articleplacedanywhere/helper.php:117

JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:25

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

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

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

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

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

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

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

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

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.16 ms After last query: 0.36 ms Query memory: 0.029 MB Memory before query: 13.911 MB Rows returned: 2

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

  FROM jos_categories as c

  LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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,5) 
  AND c.published = 1 
  AND s.id=9 
  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	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	11	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	incolmen_joomdb.c.id	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	11	Using where; Using index; Using join buffer (flat, BNL join)

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.1 ms
Optimizing	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
Removing tmp table	0.0 ms
Creating sort index	0.2 ms
Creating sort index	0.0 ms
Removing tmp table	0.1 ms
Creating sort index	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
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/libraries/legacy/categories/categories.php:288

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

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

JROOT/modules/mod_articleplacedanywhere/helper.php:19

JROOT/modules/mod_articleplacedanywhere/tmpl/default.php:13

JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:48

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

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

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

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

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

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

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

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

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.81 ms After last query: 0.76 ms Query memory: 0.024 MB Memory before query: 13.981 MB Rows returned: 4

SELECT b.rules

  FROM jos_assets AS a

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

  WHERE (a.name = 'com_content.article.1')

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

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	16	Using where

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.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.2 ms
Creating sort index	0.0 ms
Removing tmp table	0.1 ms
Creating sort index	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/libraries/joomla/access/access.php:250

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

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

JROOT/modules/mod_articleplacedanywhere/tmpl/_item.php:32

JROOT/modules/mod_articleplacedanywhere/helper.php:54

JROOT/modules/mod_articleplacedanywhere/tmpl/default.php:13

JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:48

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

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

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

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

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

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

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

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

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.29 ms After last query: 0.82 ms Query memory: 0.018 MB Memory before query: 14.002 MB Rows returned: 1

Duplicate queries: #32 #33 #34 #35 #36 #37 #38 #39

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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.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/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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.28 ms After last query: 0.73 ms Query memory: 0.018 MB Memory before query: 14.108 MB Rows returned: 1

Duplicate queries: #31 #33 #34 #35 #36 #37 #38 #39

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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.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/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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.26 ms After last query: 0.08 ms Query memory: 0.018 MB Memory before query: 14.125 MB Rows returned: 1

Duplicate queries: #31 #32 #34 #35 #36 #37 #38 #39

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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.29 ms After last query: 0.07 ms Query memory: 0.018 MB Memory before query: 14.142 MB Rows returned: 1

Duplicate queries: #31 #32 #33 #35 #36 #37 #38 #39

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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.1 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.25 ms After last query: 0.07 ms Query memory: 0.018 MB Memory before query: 14.159 MB Rows returned: 1

Duplicate queries: #31 #32 #33 #34 #36 #37 #38 #39

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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.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/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.24 ms After last query: 0.06 ms Query memory: 0.018 MB Memory before query: 14.176 MB Rows returned: 1

Duplicate queries: #31 #32 #33 #34 #35 #37 #38 #39

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.25 ms After last query: 0.06 ms Query memory: 0.018 MB Memory before query: 14.193 MB Rows returned: 1

Duplicate queries: #31 #32 #33 #34 #35 #36 #38 #39

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.23 ms After last query: 0.07 ms Query memory: 0.018 MB Memory before query: 14.209 MB Rows returned: 1

Duplicate queries: #31 #32 #33 #34 #35 #36 #37 #39

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.23 ms After last query: 0.06 ms Query memory: 0.018 MB Memory before query: 14.226 MB Rows returned: 1

Duplicate queries: #31 #32 #33 #34 #35 #36 #37 #38

SELECT link 
  FROM jos_menu 
  WHERE id = 165

Explain

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

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/modules/mod_reslider/helper.php:22

JROOT/modules/mod_reslider/mod_reslider.php:18

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

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

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

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

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

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

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

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

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: 17.13 ms Query memory: 0.003 MB Memory before query: 14.617 MB

UPDATE `jos_session`

  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1733583103;s:18:\"session.timer.last\";i:1733583103;s:17:\"session.timer.now\";i:1733583103;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:13:\"current_theme\";s:19:\"inmobiliariacolmena\";s:17:\"current_direction\";s:3:\"ltr\";s:17:\"current_key_sufix\";s:24:\"_inmobiliariacolmena_ltr\";}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}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:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"328e82592b1d1498bfae786bfe176c37\";}'
	, `time` = '1733583104'

  WHERE `session_id` = '7t72nb36l5crtbshehq42eghn2'

Explain

EXPLAIN not possible on query: UPDATE `jos_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1733583103;s:18:\"session.timer.last\";i:1733583103;s:17:\"session.timer.now\";i:1733583103;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:13:\"current_theme\";s:19:\"inmobiliariacolmena\";s:17:\"current_direction\";s:3:\"ltr\";s:17:\"current_key_sufix\";s:24:\"_inmobiliariacolmena_ltr\";}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}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:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"328e82592b1d1498bfae786bfe176c37\";}' , `time` = '1733583104' WHERE `session_id` = '7t72nb36l5crtbshehq42eghn2'

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/session/storage/database.php:85

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

22 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

```
9 × SELECT link 
  FROM jos_menu
```

6 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jos_extensions

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

2 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jos_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM jos_categories as c 
  LEFT JOIN jos_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 jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM jos_content AS a 
  LEFT JOIN jos_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT * 
  FROM jos_acymailing_confi

1 × SELECT * 
  FROM jos_acymailing_list

1 × SELECT a.rules 
  FROM jos_assets AS a

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

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

1 × SELECT `session_id` 
  FROM `jos_session`

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

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

1 × SELECT `data` 
  FROM `jos_session`

```
1 × SELECT * 
  FROM jos_languages
```

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

OTRAS tablas:

1 × UPDATE `jos_session` 
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1733583103;s:18:\"session.timer.last\";i:1733583103;s:17:\"session.timer.now\";i:1733583103;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:13:\"current_theme\";s:19:\"inmobiliariacolmena\";s:17:\"current_direction\";s:3:\"ltr\";s:17:\"current_key_sufix\";s:24:\"_inmobiliariacolmena_ltr\";}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}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:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"328e82592b1d1498bfae786bfe176c37\";}'  , `time` = '1733583104'

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"20c5598ccb37620951b77eba78f71220\",\"Array\":[\"449d0bd2e4e562e7d26a1f9750097a16\"]}'

1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('7t72nb36l5crtbshehq42eghn2', 0, '1733583103'

```
1 × DELETE  
  FROM `jos_session`
```

SUSCRÍBETE!

Consola de depuración de Joomla!

Sesión

__default

Información del perfil

Time

Memory

Uso de la memoria

Consultas de la base de datos

40 consultas registradas 22.6 ms

9 duplicate found!

22 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: