HomeNews

Warning: Division by zero in /var/www/html/arches/templates/yoo_quantum/warp/systems/joomla/layouts/com_content/category/blog.php on line 55

Warning: Division by zero in /var/www/html/arches/templates/yoo_quantum/warp/systems/joomla/layouts/com_content/category/blog.php on line 55

Warning: Division by zero in /var/www/html/arches/templates/yoo_quantum/warp/systems/joomla/layouts/com_content/category/blog.php on line 55

Warning: Division by zero in /var/www/html/arches/templates/yoo_quantum/warp/systems/joomla/layouts/com_content/category/blog.php on line 55

26 May

New publication

"Infrared identification of hard X-ray sources in the Galaxy" by A. Nebot Gómez - Morán, C. Motch, F.-X. Pineau, F. J. Carrera, M. W. Pakull, F. Riddick, has been accepted for publication in Monthly Notices of the Royal Astronomical Society.

22 May

Release of the new version (3XMM-DR5) of the XMM-Newton Serendipitious source catalogue:

The first incremental release of the 3XMM catalogue, 3XMM-DR5, was made public in April 2015 (Rosen et al., 2015; http://arxiv.org/abs/1504.07051). 3XMM-DR5, which supersedes the previous release, 3XMM-DR4, contains 565962 detections arising from 396910 unique sources drawn from 7781 XMM observations. The incremental catalogue covers around 880 square degrees of sky, taking account of overlaps between observations.

Please follow this link for further details

17 Nov

Welcome to Francisco Jiménez

Francisco Jiménez has joined the ARCHES team at INTA.

30 Oct

Welcome to Estrella Sanchez

Welcome to Estrella Sanchez who has joined the ARCHES team at Strasbourg Astronomical Observatory.

02 Sep

ARCHES is progressing well!

The ARCHES science work and management were reported to be very satisfactory following the technical review held in May 2014 and the approval of the mid-term periodic report.

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

35 Queries Logged 26.7 ms

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

SELECT `data`

  FROM `arches_session`

  WHERE `session_id` = 'f6f9a05e16de500e54a06c4bd47e045f'

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.82 ms Query memory: 0.012 MB Memory before query: 2.395 MB Rows returned: 0

SELECT `session_id`

  FROM `arches_session`

  WHERE `session_id` = 'f6f9a05e16de500e54a06c4bd47e045f' 
  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.82 ms After last query: 0.21 ms Query memory: 0.009 MB Memory before query: 2.408 MB

INSERT INTO `arches_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('f6f9a05e16de500e54a06c4bd47e045f', 0, '1685637774')

Explain

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

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.61 ms After last query: 6.05 ms Query memory: 0.014 MB Memory before query: 2.767 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.60 ms After last query: 2.10 ms Query memory: 0.014 MB Memory before query: 2.870 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.46 ms After last query: 1.11 ms Query memory: 0.013 MB Memory before query: 2.933 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: 1.02 ms After last query: 0.31 ms Query memory: 0.013 MB Memory before query: 2.951 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.53 ms After last query: 0.63 ms Query memory: 0.014 MB Memory before query: 3.019 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.53 ms After last query: 15.82 ms Query memory: 0.019 MB Memory before query: 4.012 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.15 ms Query memory: 0.031 MB Memory before query: 4.596 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.7 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.50 ms After last query: 4.06 ms Query memory: 0.024 MB Memory before query: 5.121 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.88 ms After last query: 0.33 ms Query memory: 0.017 MB Memory before query: 5.129 MB

UPDATE `arches_extensions`

  SET `params` = '{\"mediaversion\":\"84b074098c50fbfba47e3588390f5a6d\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `arches_extensions` SET `params` = '{\"mediaversion\":\"84b074098c50fbfba47e3588390f5a6d\"}' 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.54 ms After last query: 3.77 ms Query memory: 0.015 MB Memory before query: 5.373 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.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: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.46 ms After last query: 1.24 ms Query memory: 0.013 MB Memory before query: 5.425 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.64 ms After last query: 0.79 ms Query memory: 0.010 MB Memory before query: 5.445 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.50 ms After last query: 13.13 ms Query memory: 0.024 MB Memory before query: 6.332 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/category.php:129

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

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

JROOT/libraries/legacy/view/category.php:107

JROOT/components/com_content/views/category/view.html.php:72

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.11 ms After last query: 0.99 ms Query memory: 0.025 MB Memory before query: 6.388 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.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
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/category.php:129

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

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

JROOT/libraries/legacy/view/category.php:107

JROOT/components/com_content/views/category/view.html.php:72

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: 2.29 ms After last query: 2.38 ms Query memory: 0.030 MB Memory before query: 6.524 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,COUNT(i.`id`) AS numitems

  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

  LEFT JOIN `arches_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

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

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<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 temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	9	Using where
1	PRIMARY	i	ref	idx_state,idx_catid	idx_catid	4	arches.c.id	23
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
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
executing	0.0 ms
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
Creating tmp table	0.5 ms
executing	0.0 ms
Copying to tmp table	0.4 ms
Sorting result	0.0 ms
Sending data	0.1 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
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/models/category.php:326

JROOT/components/com_content/models/category.php:214

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.17 ms After last query: 0.46 ms Query memory: 0.025 MB Memory before query: 6.559 MB Rows returned: 3

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.category.9')

  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	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	99

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
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/category.php:335

JROOT/components/com_content/models/category.php:214

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.58 ms After last query: 2.38 ms Query memory: 0.034 MB Memory before query: 6.734 MB Rows returned: 7

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

  FROM arches_content AS a

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

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

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

  LEFT JOIN arches_users AS uam 
  ON uam.id = a.modified_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 != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 9 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-01 16:42:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-01 16:42:54')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 0, 9

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	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using filesort
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	13	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	arches.a.id	1	Using index
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	arches.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	arches.a.modified_by	1
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	arches.a.id	1
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
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.0 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.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
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/model/legacy.php:301

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

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

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.46 ms After last query: 3.05 ms Query memory: 0.028 MB Memory before query: 7.032 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.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/helper/tags.php:389

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

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.54 ms After last query: 0.25 ms Query memory: 0.029 MB Memory before query: 7.041 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` = 40 
  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/models/articles.php:663

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.53 ms After last query: 0.66 ms Query memory: 0.029 MB Memory before query: 7.079 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` = 43 
  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/models/articles.php:663

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.61 ms Query memory: 0.029 MB Memory before query: 7.117 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` = 34 
  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/models/articles.php:663

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.67 ms After last query: 0.60 ms Query memory: 0.029 MB Memory before query: 7.154 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` = 33 
  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.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
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/models/articles.php:663

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.56 ms After last query: 0.74 ms Query memory: 0.029 MB Memory before query: 7.192 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` = 32 
  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/models/articles.php:663

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.62 ms After last query: 0.67 ms Query memory: 0.029 MB Memory before query: 7.230 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` = 30 
  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.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
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/models/articles.php:663

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.57 ms After last query: 0.65 ms Query memory: 0.029 MB Memory before query: 7.268 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` = 29 
  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/models/articles.php:663

JROOT/components/com_content/models/category.php:234

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.04 ms After last query: 1.93 ms Query memory: 0.024 MB Memory before query: 7.406 MB Rows returned: 1

SELECT COUNT(*)

  FROM arches_content AS a

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

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

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

  LEFT JOIN arches_users AS uam 
  ON uam.id = a.modified_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 != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid = 9 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-01 16:42:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-01 16:42:54')

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	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	13	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	arches.a.id	1	Using index
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	arches.a.created_by	1	Using index
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	arches.a.modified_by	1	Using index
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using index
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	arches.a.id	1	Using index
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.1 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
Opening tables	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
executing	0.0 ms
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.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
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/model/legacy.php:327

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

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

JROOT/components/com_content/models/category.php:246

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.58 ms After last query: 0.50 ms Query memory: 0.025 MB Memory before query: 7.412 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.category' 
  AND `m`.`content_item_id` = 9 
  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.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
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/libraries/legacy/view/category.php:179

JROOT/components/com_content/views/category/view.html.php:72

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.22 ms After last query: 19.81 ms Query memory: 0.036 MB Memory before query: 8.552 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=9 
  AND badcats.id is null

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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<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.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
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/templates/yoo_quantum/layouts/com_content/category/blog_item.php:22

JROOT/templates/yoo_quantum/html/com_content/category/blog_item.php:12

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

JROOT/templates/yoo_quantum/warp/systems/joomla/layouts/com_content/category/blog.php:47

JROOT/templates/yoo_quantum/html/com_content/category/blog.php:12

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

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

JROOT/libraries/legacy/view/category.php:195

JROOT/components/com_content/views/category/view.html.php:174

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: 9.04 ms Query memory: 0.021 MB Memory before query: 8.596 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.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/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.48 ms After last query: 1.16 ms Query memory: 0.022 MB Memory before query: 8.642 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.98 ms After last query: 18.93 ms Query memory: 0.026 MB Memory before query: 9.843 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 16:42:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-01 16:42:54') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 118 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.98 ms After last query: 35.04 ms Query memory: 0.003 MB Memory before query: 10.514 MB

UPDATE `arches_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685637774;s:18:\"session.timer.last\";i:1685637774;s:17:\"session.timer.now\";i:1685637774;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` = '1685637774'

  WHERE `session_id` = 'f6f9a05e16de500e54a06c4bd47e045f'

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:1685637774;s:18:\"session.timer.last\";i:1685637774;s:17:\"session.timer.now\";i:1685637774;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` = '1685637774' WHERE `session_id` = 'f6f9a05e16de500e54a06c4bd47e045f'

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

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

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

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

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM arches_content AS a 
  LEFT JOIN arches_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN arches_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN arches_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN arches_users AS uam 
  ON uam.id = a.modified_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 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,COUNT(i.`id`) AS numitems 
  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 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 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 COUNT(*) 
  FROM arches_content AS a 
  LEFT JOIN arches_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN arches_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN arches_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN arches_users AS uam 
  ON uam.id = a.modified_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 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:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1685637774;s:18:\"session.timer.last\";i:1685637774;s:17:\"session.timer.now\";i:1685637774;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` = '1685637774'

1 × UPDATE `arches_extensions` 
  SET `params` = '{\"mediaversion\":\"84b074098c50fbfba47e3588390f5a6d\"}'

1 × INSERT INTO `arches_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('f6f9a05e16de500e54a06c4bd47e045f', 0, '1685637774'

More Articles...

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

35 Queries Logged 26.7 ms

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: