The Arches Database is Online

ARCHES - Astronomical Resource Cross-matching for High Energy Studies

The ARCHES project brings together leading scientists and the Consortium federates institutes from different European countries (France, Britain, Germany and Spain) with complementary skills and fields of expertise.

The goal of the project:

ARCHES will focus on the 3XMM (DR4) catalogue data from the XMM-Newton mission. New tools will be developed for cross-correlation with extensive archival resources, producing well-characterised multi-wavelength data in the form of spectral energy distributions for large sets of objects. These enhanced resources will significantly broaden the effective exploitation of the data by the scientific community in the exploration of a wide range of forefront astrophysical questions.

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

29 Queries Logged 20.2 ms

Query Time: 0.44 ms Query memory: 0.015 MB Memory before query: 2.252 MB Rows returned: 0

SELECT `data`

  FROM `arches_session`

  WHERE `session_id` = '4489454b7ebeb0753a4ea108cc490393'

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:38

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

Query Time: 0.44 ms After last query: 2.87 ms Query memory: 0.012 MB Memory before query: 2.390 MB Rows returned: 0

SELECT `session_id`

  FROM `arches_session`

  WHERE `session_id` = '4489454b7ebeb0753a4ea108cc490393' 
  LIMIT 0, 1

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:38

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

Query Time: 0.86 ms After last query: 0.23 ms Query memory: 0.009 MB Memory before query: 2.403 MB

INSERT INTO `arches_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('4489454b7ebeb0753a4ea108cc490393', 0, '1687442384')

Explain

EXPLAIN not possible on query: INSERT INTO `arches_session` (`session_id`, `client_id`, `time`) VALUES ('4489454b7ebeb0753a4ea108cc490393', 0, '1687442384')

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
update	0.1 ms
Waiting for query cache lock	0.0 ms
update	0.0 ms
end	0.0 ms
query end	0.4 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:38

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

Query Time: 0.60 ms After last query: 6.22 ms Query memory: 0.014 MB Memory before query: 2.762 MB Rows returned: 1

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

  FROM arches_extensions

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

Explain

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

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	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:541

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

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

JROOT/index.php:41

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

Query Time: 0.60 ms After last query: 2.13 ms Query memory: 0.014 MB Memory before query: 2.865 MB Rows returned: 2

SELECT b.id

  FROM arches_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.44 ms After last query: 1.11 ms Query memory: 0.013 MB Memory before query: 2.928 MB Rows returned: 4

SELECT id, rules

  FROM `arches_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

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

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

JROOT/index.php:41

[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.31 ms Query memory: 0.013 MB Memory before query: 2.946 MB Rows returned: 46

SELECT folder AS type, element AS name, params

  FROM arches_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	arches_extensions	ref	extension	extension	62	const	57	Using where; Using filesort

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.2 ms
Sending data	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.52 ms After last query: 0.61 ms Query memory: 0.014 MB Memory before query: 3.014 MB Rows returned: 1

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

  FROM arches_extensions

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

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	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:599

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

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

JROOT/index.php:41

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

Query Time: 0.54 ms After last query: 16.24 ms Query memory: 0.019 MB Memory before query: 4.006 MB Rows returned: 1

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

  FROM arches_extensions

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

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	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/plugins/system/widgetkit_zoo/widgetkit_zoo.php:35

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

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

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

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

JROOT/index.php:41

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

Query Time: 1.33 ms After last query: 8.29 ms Query memory: 0.031 MB Memory before query: 4.589 MB Rows returned: 40

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	47	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	arches.m.component_id	1

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.2 ms
Sending data	0.6 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.52 ms After last query: 4.14 ms Query memory: 0.024 MB Memory before query: 5.113 MB Rows returned: 1

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

  FROM arches_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	arches_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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/sef/sef.php:30

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.94 ms After last query: 0.31 ms Query memory: 0.017 MB Memory before query: 5.120 MB

UPDATE `arches_extensions`

  SET `params` = '{\"mediaversion\":\"8feb231a9e6383167b3e150787c7f085\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

EXPLAIN not possible on query: UPDATE `arches_extensions` SET `params` = '{\"mediaversion\":\"8feb231a9e6383167b3e150787c7f085\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.1 ms
Updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	0.4 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	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/sef/sef.php:30

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.50 ms After last query: 3.58 ms Query memory: 0.015 MB Memory before query: 5.365 MB Rows returned: 1

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

  FROM arches_extensions

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

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	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:299

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

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

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

JROOT/index.php:41

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

Query Time: 0.41 ms After last query: 1.22 ms Query memory: 0.013 MB Memory before query: 5.417 MB Rows returned: 1

SELECT *

  FROM arches_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/language/helper.php:166

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.62 ms After last query: 0.65 ms Query memory: 0.010 MB Memory before query: 5.437 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM arches_template_styles as s

  LEFT JOIN arches_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	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	arches.s.template,const	1	Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.41 ms After last query: 10.98 ms Query memory: 0.024 MB Memory before query: 6.157 MB Rows returned: 1

SELECT a.rules

  FROM arches_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.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

JROOT/components/com_content/models/article.php:55

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

JROOT/components/com_content/models/article.php:75

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:37

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 1.01 ms After last query: 0.98 ms Query memory: 0.025 MB Memory before query: 6.213 MB Rows returned: 2

SELECT b.rules

  FROM arches_assets AS a

  LEFT JOIN arches_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	12	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.3 ms
executing	0.0 ms
Copying to tmp table	0.1 ms
Sorting result	0.0 ms
Sending data	0.0 ms
end	0.0 ms
removing tmp table	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	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:365

JROOT/components/com_content/models/article.php:55

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

JROOT/components/com_content/models/article.php:75

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:37

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 1.14 ms After last query: 0.84 ms Query memory: 0.030 MB Memory before query: 6.259 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 = '0000-00-00 00:00:00' 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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM arches_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM arches_categories AS cat JOIN arches_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 <= '2023-06-22 13:59:44') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-22 13:59:44') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	PRIMARY	a	const	PRIMARY,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	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	9	Using where; Using index; Using join buffer

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.1 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
executing	0.0 ms
Copying to tmp table	0.0 ms
Sorting result	0.0 ms
Sending data	0.0 ms
removing tmp table	0.0 ms
Sending data	0.0 ms
init	0.1 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_content/models/article.php:158

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:37

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 1.02 ms After last query: 3.06 ms Query memory: 0.026 MB Memory before query: 6.473 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 arches_categories as c

  LEFT JOIN arches_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 arches_categories AS cat JOIN arches_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=2 
  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	<derived2>	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	9	Using where; Using index; Using join buffer

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
executing	0.0 ms
Copying to tmp table	0.0 ms
Sorting result	0.0 ms
Sending data	0.0 ms
removing tmp table	0.0 ms
Sending data	0.0 ms
init	0.1 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	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:39

JROOT/components/com_content/views/article/view.html.php:65

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.43 ms After last query: 3.27 ms Query memory: 0.024 MB Memory before query: 6.695 MB Rows returned: 1

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

  FROM arches_extensions

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

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	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/helper/tags.php:389

JROOT/components/com_content/views/article/view.html.php:148

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

[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.24 ms Query memory: 0.024 MB Memory before query: 6.700 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `arches_contentitem_tag_map` AS m 

  INNER JOIN `arches_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	arches.m.tag_id	1	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/helper/tags.php:409

JROOT/components/com_content/views/article/view.html.php:148

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 1.39 ms After last query: 6.76 ms Query memory: 0.028 MB Memory before query: 7.067 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `arches_content`

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.3 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.1 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

JROOT/libraries/legacy/table/content.php:31

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

JROOT/components/com_content/models/article.php:263

JROOT/components/com_content/views/article/view.html.php:169

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.50 ms After last query: 2.47 ms Query memory: 0.026 MB Memory before query: 7.251 MB Rows returned: 1

SELECT *

  FROM arches_content

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

JROOT/components/com_content/models/article.php:264

JROOT/components/com_content/views/article/view.html.php:169

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.73 ms After last query: 0.33 ms Query memory: 0.016 MB Memory before query: 7.269 MB

UPDATE arches_content

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

  WHERE `id` = '1'

Explain

EXPLAIN not possible on query: UPDATE arches_content SET `hits` = (`hits` + 1) WHERE `id` = '1'

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
Updating	0.0 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	0.4 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

JROOT/components/com_content/models/article.php:265

JROOT/components/com_content/views/article/view.html.php:169

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.45 ms After last query: 14.60 ms Query memory: 0.021 MB Memory before query: 7.850 MB Rows returned: 1

SELECT params 
  FROM arches_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_widgetkit/helpers/system.php:254

JROOT/administrator/components/com_widgetkit/helpers/system.php:54

JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129

JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76

JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137

JROOT/administrator/components/com_widgetkit/widgetkit.php:17

JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20

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/site.php:183

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

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

JROOT/index.php:41

[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.46 ms Query memory: 0.022 MB Memory before query: 7.895 MB Rows returned: 1

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

  FROM arches_extensions

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

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

JROOT/administrator/components/com_widgetkit/helpers/system.php:80

JROOT/administrator/components/com_widgetkit/widgetkit.php:17

JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20

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/site.php:183

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

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

JROOT/index.php:41

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

Query Time: 0.99 ms After last query: 26.20 ms Query memory: 0.023 MB Memory before query: 9.184 MB Rows returned: 6

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

  FROM arches_modules AS m

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

  LEFT JOIN arches_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-22 13:59:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-22 13:59:44') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 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	8	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	arches.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	arches.m.module,const	1	Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.1 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 ms
executing	0.0 ms
Sorting result	0.1 ms
Sending data	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/module/helper.php:376

JROOT/libraries/cms/module/helper.php:84

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

JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:49

JROOT/templates/yoo_quantum/layouts/template.config.php:23

JROOT/templates/yoo_quantum/layouts/template.php:10

JROOT/templates/yoo_quantum/warp/helpers/template.php:49

JROOT/templates/yoo_quantum/index.php:51

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

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.54 ms After last query: 32.80 ms Query memory: 0.028 MB Memory before query: 9.811 MB Rows returned: 1

SELECT * 
  FROM arches_widgetkit_widget 
  WHERE id=1

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_widgetkit/helpers/widget.php:42

JROOT/administrator/components/com_widgetkit/helpers/widget.php:160

JROOT/modules/mod_widgetkit/mod_widgetkit.php:22

JROOT/libraries/cms/module/helper.php:190

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

JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:86

JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/modules.php:10

JROOT/templates/yoo_quantum/warp/helpers/template.php:49

JROOT/templates/yoo_quantum/warp/systems/joomla/helpers/modules.php:64

JROOT/templates/yoo_quantum/layouts/template.php:109

JROOT/templates/yoo_quantum/warp/helpers/template.php:49

JROOT/templates/yoo_quantum/index.php:51

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

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

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

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

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

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

JROOT/index.php:41

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

Query Time: 0.90 ms After last query: 8.94 ms Query memory: 0.003 MB Memory before query: 9.937 MB

UPDATE `arches_session`

  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1687442384;s:18:\"session.timer.last\";i:1687442384;s:17:\"session.timer.now\";i:1687442384;s:22:\"session.client.browser\";s:50:\"Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{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:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":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;}}'
	, `time` = '1687442384'

  WHERE `session_id` = '4489454b7ebeb0753a4ea108cc490393'

Explain

EXPLAIN not possible on query: UPDATE `arches_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1687442384;s:18:\"session.timer.last\";i:1687442384;s:17:\"session.timer.now\";i:1687442384;s:22:\"session.client.browser\";s:50:\"Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{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:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":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;}}' , `time` = '1687442384' WHERE `session_id` = '4489454b7ebeb0753a4ea108cc490393'

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
Updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	0.4 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	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]

23 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

7 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM arches_extensions

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `arches_contentitem_tag_map` AS m  
  INNER JOIN `arches_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × 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 arches_categories as c 
  LEFT JOIN arches_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 arches_categories AS cat JOIN arches_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM arches_content
```

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 = '0000-00-00 00:00:00' 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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM arches_content AS a 
  LEFT JOIN arches_categories AS c 
  on c.id = a.catid 
  LEFT JOIN arches_users AS u 
  on u.id = a.created_by 
  LEFT JOIN arches_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN arches_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM arches_categories AS cat JOIN arches_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT params 
  FROM arches_extensions AS e

1 × SELECT * 
  FROM arches_widgetkit_widget

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM arches_modules AS m 
  LEFT JOIN arches_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN arches_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

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

1 × SELECT id, rules 
  FROM `arches_viewlevels

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

1 × SELECT `session_id` 
  FROM `arches_session`

1 × SELECT folder AS type, element AS name, params 
  FROM arches_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 arches_menu AS m 
  LEFT JOIN arches_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `data` 
  FROM `arches_session`

```
1 × SELECT * 
  FROM arches_languages
```

1 × SELECT a.rules 
  FROM arches_assets AS a

OTHER Tables:

1 × UPDATE `arches_session` 
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1687442384;s:18:\"session.timer.last\";i:1687442384;s:17:\"session.timer.now\";i:1687442384;s:22:\"session.client.browser\";s:50:\"Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{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:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":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;}}'  , `time` = '1687442384'

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

1 × SHOW FULL COLUMNS 
  FROM `arches_content

1 × UPDATE `arches_extensions` 
  SET `params` = '{\"mediaversion\":\"8feb231a9e6383167b3e150787c7f085\"}'

1 × INSERT INTO `arches_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('4489454b7ebeb0753a4ea108cc490393', 0, '1687442384'