Home TOOLS & DATA Online ToolsCross Match Service

Arches X-match Service

The ARCHES X-Match tool is a versatile tool allowing to perform various types of xmatches between two or more tables.
It supports notably n-catalogues chi-square xmatches and is able to compute probabilities of identification.
So far, the user have to write xmatch scripts and submit them through a HTTP API.
The link below points to a web page from which the user can execute pre-made or its own scripts.

Click here to connect the service

A complete documentation of the service can be found here.

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

29 Queries Logged 20.1 ms

Query Time: 0.48 ms Query memory: 0.015 MB Memory before query: 2.256 MB Rows returned: 0

SELECT `data`

  FROM `arches_session`

  WHERE `session_id` = 'b6ba9be1e889daa2faf18f66db5d2b5c'

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.47 ms After last query: 2.77 ms Query memory: 0.008 MB Memory before query: 2.394 MB

DELETE 

  FROM `arches_session`

  WHERE `time` < '1685630393'

Explain

EXPLAIN not possible on query: DELETE FROM `arches_session` WHERE `time` < '1685630393'

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.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:689

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.38 ms After last query: 0.22 ms Query memory: 0.012 MB Memory before query: 2.405 MB Rows returned: 0

SELECT `session_id`

  FROM `arches_session`

  WHERE `session_id` = 'b6ba9be1e889daa2faf18f66db5d2b5c' 
  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.87 ms After last query: 0.20 ms Query memory: 0.009 MB Memory before query: 2.418 MB

INSERT INTO `arches_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('b6ba9be1e889daa2faf18f66db5d2b5c', 0, '1685631293')

Explain

EXPLAIN not possible on query: INSERT INTO `arches_session` (`session_id`, `client_id`, `time`) VALUES ('b6ba9be1e889daa2faf18f66db5d2b5c', 0, '1685631293')

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.5 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.59 ms After last query: 5.95 ms Query memory: 0.014 MB Memory before query: 2.775 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.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: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.52 ms After last query: 1.98 ms Query memory: 0.014 MB Memory before query: 2.878 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: 0.98 ms Query memory: 0.013 MB Memory before query: 2.941 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.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: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.93 ms After last query: 0.32 ms Query memory: 0.013 MB Memory before query: 2.959 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.51 ms After last query: 0.61 ms Query memory: 0.014 MB Memory before query: 3.027 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.56 ms After last query: 16.21 ms Query memory: 0.019 MB Memory before query: 4.020 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.34 ms After last query: 8.52 ms Query memory: 0.031 MB Memory before query: 4.604 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.1 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.57 ms After last query: 4.08 ms Query memory: 0.024 MB Memory before query: 5.128 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.92 ms After last query: 0.42 ms Query memory: 0.017 MB Memory before query: 5.136 MB

UPDATE `arches_extensions`

  SET `params` = '{\"mediaversion\":\"65393556b5ebb2c714d51c48faf4752f\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `arches_extensions` SET `params` = '{\"mediaversion\":\"65393556b5ebb2c714d51c48faf4752f\"}' 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.52 ms After last query: 3.54 ms Query memory: 0.015 MB Memory before query: 5.381 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.40 ms After last query: 1.16 ms Query memory: 0.013 MB Memory before query: 5.432 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.54 ms After last query: 0.64 ms Query memory: 0.010 MB Memory before query: 5.452 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.69 ms Query memory: 0.024 MB Memory before query: 6.173 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.02 ms After last query: 0.92 ms Query memory: 0.025 MB Memory before query: 6.229 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.23 ms After last query: 0.85 ms Query memory: 0.027 MB Memory before query: 6.274 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 = 62 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-01 14:54:53') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-01 14:54:53') 
  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.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
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.08 ms After last query: 3.40 ms Query memory: 0.026 MB Memory before query: 6.485 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.48 ms After last query: 3.47 ms Query memory: 0.024 MB Memory before query: 6.706 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.52 ms After last query: 0.27 ms Query memory: 0.024 MB Memory before query: 6.711 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` = 62 
  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.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/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.37 ms After last query: 7.01 ms Query memory: 0.028 MB Memory before query: 7.078 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.49 ms After last query: 2.39 ms Query memory: 0.026 MB Memory before query: 7.263 MB Rows returned: 1

SELECT *

  FROM arches_content

  WHERE `id` = '62'

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.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/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.85 ms After last query: 0.40 ms Query memory: 0.016 MB Memory before query: 7.280 MB

UPDATE arches_content

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

  WHERE `id` = '62'

Explain

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

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/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.43 ms After last query: 15.52 ms Query memory: 0.021 MB Memory before query: 7.914 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.36 ms Query memory: 0.022 MB Memory before query: 7.959 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.87 ms After last query: 24.79 ms Query memory: 0.026 MB Memory before query: 9.247 MB Rows returned: 4

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-01 14:54:53') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-01 14:54:53') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 161 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.0 ms
executing	0.0 ms
Sorting result	0.1 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/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.85 ms After last query: 36.75 ms Query memory: 0.003 MB Memory before query: 9.848 MB

UPDATE `arches_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685631293;s:18:\"session.timer.last\";i:1685631293;s:17:\"session.timer.now\";i:1685631293;s:24:\"session.client.forwarded\";s:12:\"3.235.40.122\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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` = '1685631293'

  WHERE `session_id` = 'b6ba9be1e889daa2faf18f66db5d2b5c'

Explain

EXPLAIN not possible on query: UPDATE `arches_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685631293;s:18:\"session.timer.last\";i:1685631293;s:17:\"session.timer.now\";i:1685631293;s:24:\"session.client.forwarded\";s:12:\"3.235.40.122\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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` = '1685631293' WHERE `session_id` = 'b6ba9be1e889daa2faf18f66db5d2b5c'

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 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 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 `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 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 * 
  FROM arches_content
```

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 params 
  FROM arches_extensions AS e

1 × SELECT a.rules 
  FROM arches_assets AS a

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 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 id, rules 
  FROM `arches_viewlevels

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

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

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`

OTHER Tables:

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

1 × UPDATE `arches_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685631293;s:18:\"session.timer.last\";i:1685631293;s:17:\"session.timer.now\";i:1685631293;s:24:\"session.client.forwarded\";s:12:\"3.235.40.122\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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` = '1685631293'

1 × SHOW FULL COLUMNS 
  FROM `arches_content

1 × UPDATE `arches_extensions` 
  SET `params` = '{\"mediaversion\":\"65393556b5ebb2c714d51c48faf4752f\"}'

1 × INSERT INTO `arches_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('b6ba9be1e889daa2faf18f66db5d2b5c', 0, '1685631293'

```
1 × DELETE  
  FROM `arches_session`
```