IT Outsourcing Services

Visitor counter

Today 0

Yesterday 16

Week 0

Month 165

All 6769

Joomla! Debug Console

Session

Profile Information

Time

Memory

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

Time: 42.2 ms / 42.2 ms Memory: 3.304 MB / 3.90 MB Application: afterInitialise

Time: 20.9 ms / 63.1 ms Memory: 1.723 MB / 5.62 MB Application: afterRoute

Time: 42.3 ms / 105.4 ms Memory: 2.730 MB / 8.35 MB Application: afterDispatch

Time: 6.5 ms / 111.9 ms Memory: 0.420 MB / 8.77 MB Application: beforeRenderModule mod_custom (footer)

Time: 1.3 ms / 113.2 ms Memory: 0.042 MB / 8.81 MB Application: afterRenderModule mod_custom (footer)

Time: 0.1 ms / 113.3 ms Memory: 0.000 MB / 8.81 MB Application: beforeRenderModule mod_custom (Physical Address)

Time: 0.4 ms / 113.7 ms Memory: 0.007 MB / 8.82 MB Application: afterRenderModule mod_custom (Physical Address)

Time: 0.1 ms / 113.8 ms Memory: 0.000 MB / 8.81 MB Application: beforeRenderModule mod_custom (Services)

Time: 0.3 ms / 114.1 ms Memory: 0.007 MB / 8.82 MB Application: afterRenderModule mod_custom (Services)

Time: 0.1 ms / 114.2 ms Memory: 0.000 MB / 8.82 MB Application: beforeRenderModule mod_custom (About InfraTEL)

Time: 0.3 ms / 114.5 ms Memory: 0.007 MB / 8.83 MB Application: afterRenderModule mod_custom (About InfraTEL)

Time: 0.1 ms / 114.6 ms Memory: 0.000 MB / 8.82 MB Application: beforeRenderModule mod_custom (Quick Links)

Time: 0.3 ms / 114.9 ms Memory: 0.007 MB / 8.83 MB Application: afterRenderModule mod_custom (Quick Links)

Time: 0.1 ms / 115.0 ms Memory: 0.000 MB / 8.83 MB Application: beforeRenderModule mod_sp_social (SP Social)

Time: 1.4 ms / 116.4 ms Memory: 0.057 MB / 8.89 MB Application: afterRenderModule mod_sp_social (SP Social)

Time: 0.1 ms / 116.5 ms Memory: 0.000 MB / 8.88 MB Application: beforeRenderModule mod_custom (left banner)

Time: 0.3 ms / 116.9 ms Memory: 0.007 MB / 8.89 MB Application: afterRenderModule mod_custom (left banner)

Time: 0.1 ms / 117.0 ms Memory: 0.005 MB / 8.89 MB Application: beforeRenderModule mod_visitorcounter (Visitor counter)

Time: 10.9 ms / 127.9 ms Memory: 0.234 MB / 9.12 MB Application: afterRenderModule mod_visitorcounter (Visitor counter)

Time: 0.5 ms / 128.4 ms Memory: 0.000 MB / 9.11 MB Application: beforeRenderModule mod_custom (CSMA Shares)

Time: 0.8 ms / 129.2 ms Memory: 0.007 MB / 9.11 MB Application: afterRenderModule mod_custom (CSMA Shares)

Time: 0.2 ms / 129.4 ms Memory: 0.000 MB / 9.11 MB Application: beforeRenderModule mod_custom (tob banner)

Time: 0.6 ms / 130.0 ms Memory: 0.007 MB / 9.12 MB Application: afterRenderModule mod_custom (tob banner)

Time: 0.3 ms / 130.3 ms Memory: 0.000 MB / 9.12 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 15.4 ms / 145.7 ms Memory: 0.129 MB / 9.25 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 32.4 ms / 178.1 ms Memory: 0.177 MB / 9.42 MB Application: beforeRenderModule mod_menu (Quick Links)

Time: 5.0 ms / 183.1 ms Memory: 0.023 MB / 9.45 MB Application: afterRenderModule mod_menu (Quick Links)

Time: 2.8 ms / 185.9 ms Memory: 0.012 MB / 9.46 MB Application: beforeRenderModule mod_menu (About InfraTEL)

Time: 4.9 ms / 190.8 ms Memory: 0.023 MB / 9.48 MB Application: afterRenderModule mod_menu (About InfraTEL)

Time: 2.8 ms / 193.6 ms Memory: 0.012 MB / 9.49 MB Application: beforeRenderModule mod_menu (Our Services)

Time: 4.9 ms / 198.4 ms Memory: 0.023 MB / 9.52 MB Application: afterRenderModule mod_menu (Our Services)

Time: 2.7 ms / 201.1 ms Memory: 0.012 MB / 9.53 MB Application: beforeRenderModule mod_custom (Our Physical Address)

Time: 0.8 ms / 201.9 ms Memory: 0.007 MB / 9.53 MB Application: afterRenderModule mod_custom (Our Physical Address)

Time: 12.3 ms / 214.2 ms Memory: 0.000 MB / 9.48 MB Application: afterRender

Database queries total: 31.4 ms

Memory Usage

Database Queries

32 Queries Logged 31.4 ms

Query Time: 0.66 ms
```
SELECT `data`

  FROM `bdarx_session`

  WHERE `session_id` = 'fgcui3usj86cdua3jmohrri3o3'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_session NULL const PRIMARY PRIMARY 602 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:662
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.80 ms After last query: 4.64 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM bdarx_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_users'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:557
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.88 ms After last query: 1.04 ms
```
SELECT folder AS type, element AS name, params

  FROM bdarx_extensions

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

  ORDER BY ordering
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_extensions NULL ref extension extension 62 const 58 3.33 Using index condition; Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.46 ms After last query: 0.44 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM bdarx_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:615
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.65 ms After last query: 14.12 ms

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM bdarx_menu AS m

  LEFT JOIN bdarx_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	91	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	infratel_INFRA.m.component_id	1	100.00	Using where

Profile

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

Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.60 ms After last query: 10.80 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM bdarx_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_extensions NULL ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/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:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.42 ms After last query: 0.32 ms
```
UPDATE `bdarx_extensions`

  SET `params` = '{\"mediaversion\":\"d92e2317bd68c4b52a0a0d030ddbf035\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 UPDATE bdarx_extensions NULL range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/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:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.49 ms After last query: 3.06 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM bdarx_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_content'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/components/com_content/router.php:37
JROOT/libraries/cms/router/site.php:463
JROOT/libraries/cms/router/site.php:426
JROOT/libraries/cms/router/router.php:231
JROOT/libraries/cms/router/site.php:106
JROOT/libraries/joomla/application/route.php:63
JROOT/plugins/system/sef/sef.php:49
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.52 ms After last query: 1.05 ms
```
SELECT *

  FROM bdarx_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:166
JROOT/libraries/cms/application/site.php:323
JROOT/libraries/cms/application/site.php:122
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.55 ms After last query: 0.49 ms

SELECT id, home, template, s.params

  FROM bdarx_template_styles as s

  LEFT JOIN bdarx_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	infratel_INFRA.s.template,const	1	4.55	Using index condition; Using where

Profile

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

Call Stack

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.24 ms After last query: 9.05 ms

SELECT b.rules

  FROM bdarx_assets AS a

  LEFT JOIN bdarx_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	NULL	range	idx_lft_rgt	idx_lft_rgt	4	NULL	19	100.00	Using where

Profile

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

Call Stack

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

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

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

JROOT/components/com_content/models/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:44

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

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

JROOT/index.php:40

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

Query Time: 0.50 ms After last query: 0.94 ms

SELECT b.id

  FROM bdarx_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.79 ms After last query: 1.17 ms

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 bdarx_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM bdarx_categories AS cat JOIN bdarx_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 = 52 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-20 02:03:54') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-20 02:03:54') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	17	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.87 ms After last query: 2.36 ms

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 bdarx_categories as c

  LEFT JOIN bdarx_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 bdarx_categories AS cat JOIN bdarx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

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

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

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	17	16.34	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	infratel_INFRA.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	17	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

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

Call Stack

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

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

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

JROOT/components/com_content/views/article/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:224

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

JROOT/index.php:40

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

Query Time: 0.38 ms After last query: 2.56 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM bdarx_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_tags'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/helper/tags.php:389
JROOT/components/com_content/views/article/view.html.php:155
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:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.54 ms After last query: 0.30 ms

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

  FROM `bdarx_contentitem_tag_map` AS m 

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

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

Explain

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

Profile

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

Call Stack

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.21 ms After last query: 5.05 ms
```
SHOW FULL COLUMNS 
  FROM `bdarx_content`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bdarx_content`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:176
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:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.42 ms After last query: 1.86 ms
```
SELECT *

  FROM bdarx_content

  WHERE `id` = '52'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bdarx_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
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:176
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:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.37 ms After last query: 0.24 ms

UPDATE bdarx_content

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

  WHERE `id` = '52'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	bdarx_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	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:176

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

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

JROOT/index.php:40

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

Query Time: 1.32 ms After last query: 11.75 ms

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

  FROM bdarx_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-20 02:03:54') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-20 02:03:54') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	25	2.50	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	infratel_INFRA.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	infratel_INFRA.m.id	5	40.00	Using where; Using index

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	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/infratel32/library/Artx/Page.php:42

JROOT/templates/infratel32/index.php:65

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

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

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

JROOT/index.php:40

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

Query Time: 0.34 ms After last query: 8.59 ms
```
CREATE TABLE IF NOT EXISTS `bdarx_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(16) NOT NULL DEFAULT '0.0.0.0')
```
Explain
EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS `bdarx_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(16) NOT NULL DEFAULT '0.0.0.0')
Profile
Status Duration
starting 0.1 ms
checking permissions 0.0 ms
Opening tables 0.1 ms
After create 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
cleaning up 0.0 ms
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:47
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:60
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:982
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.25 ms After last query: 0.13 ms
```
CREATE TABLE IF NOT EXISTS `bdarx_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0')
```
Explain
EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS `bdarx_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0')
Profile
Status Duration
starting 0.0 ms
checking permissions 0.0 ms
Opening tables 0.1 ms
After create 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
cleaning up 0.0 ms
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:53
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:60
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:982
JROOT/libraries/cms/application/site.php:718
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.43 ms After last query: 0.09 ms

SELECT count(*) 
  FROM `bdarx_vcnt_pc`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bdarx_vcnt_pc	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_visitorcounter/helper.php:57

JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:60

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.23 ms After last query: 0.46 ms

SELECT count(*) 
  FROM `bdarx_vcnt` 
  WHERE `ip` = '18.219.103.183' 
  AND (`tm` + '86400') > '1716170634'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bdarx_vcnt	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	277	10.00	Using where

Profile

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

Call Stack

JROOT/modules/mod_visitorcounter/helper.php:142

JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:63

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.80 ms After last query: 0.32 ms

SELECT count(*) 
  FROM `bdarx_vcnt` 
  WHERE `tm` < '1713830400'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bdarx_vcnt	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	277	33.33	Using where

Profile

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

Call Stack

JROOT/modules/mod_visitorcounter/helper.php:237

JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:67

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 3.14 ms After last query: 0.52 ms

SELECT count(*) 
  FROM `bdarx_vcnt` UNION ALL SELECT count(*) 
  FROM `bdarx_vcnt` 
  WHERE `tm` > '1716163200' UNION ALL SELECT count(*) 
  FROM `bdarx_vcnt` 
  WHERE `tm` > '1716076800' 
  AND `tm` < '1716163200' UNION ALL SELECT count(*) 
  FROM `bdarx_vcnt` 
  WHERE `tm` >= '1716163200' UNION ALL SELECT count(*) 
  FROM `bdarx_vcnt` 
  WHERE `tm` >= '1714521600' UNION ALL SELECT `cnt` 
  FROM `bdarx_vcnt_pc`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	bdarx_vcnt	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	277	100.00	NULL
2	UNION	bdarx_vcnt	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	277	33.33	Using where
3	UNION	bdarx_vcnt	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	277	11.11	Using where
4	UNION	bdarx_vcnt	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	277	33.33	Using where
5	UNION	bdarx_vcnt	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	277	33.33	Using where
6	UNION	bdarx_vcnt_pc	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

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
Opening tables	0.2 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.6 ms
executing	0.0 ms
Sending data	0.4 ms
executing	0.0 ms
Sending data	0.4 ms
executing	0.0 ms
Sending data	0.4 ms
executing	0.0 ms
Sending data	0.4 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_visitorcounter/helper.php:194

JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:84

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 1.51 ms After last query: 47.49 ms

SELECT m.*

  FROM bdarx_modules AS m

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

  WHERE m.client_id = 0 
  AND m.title = 'CMSA share' 
  AND m.access IN (1,1,5) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	25	2.50	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	infratel_INFRA.m.module,const	1	10.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/plugins/system/modulesanywhere/helper.php:537

JROOT/plugins/system/modulesanywhere/helper.php:389

JROOT/plugins/system/modulesanywhere/helper.php:288

JROOT/plugins/system/modulesanywhere/helper.php:268

JROOT/plugins/system/modulesanywhere/helper.php:224

JROOT/plugins/system/modulesanywhere/helper.php:184

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116

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

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

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

JROOT/index.php:40

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

Query Time: 1.37 ms After last query: 0.74 ms

SELECT m.*

  FROM bdarx_modules AS m

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

  WHERE m.client_id = 0 
  AND m.title = 'Quick Links' 
  AND m.access IN (1,1,5) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	25	2.50	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	infratel_INFRA.m.module,const	1	10.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/plugins/system/modulesanywhere/helper.php:537

JROOT/plugins/system/modulesanywhere/helper.php:389

JROOT/plugins/system/modulesanywhere/helper.php:288

JROOT/plugins/system/modulesanywhere/helper.php:268

JROOT/plugins/system/modulesanywhere/helper.php:224

JROOT/plugins/system/modulesanywhere/helper.php:184

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116

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

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

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

JROOT/index.php:40

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

Query Time: 1.57 ms After last query: 6.20 ms

SELECT m.*

  FROM bdarx_modules AS m

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

  WHERE m.client_id = 0 
  AND m.title = 'About InfraTEL' 
  AND m.access IN (1,1,5) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	25	2.50	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	infratel_INFRA.m.module,const	1	10.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/plugins/system/modulesanywhere/helper.php:537

JROOT/plugins/system/modulesanywhere/helper.php:389

JROOT/plugins/system/modulesanywhere/helper.php:288

JROOT/plugins/system/modulesanywhere/helper.php:268

JROOT/plugins/system/modulesanywhere/helper.php:224

JROOT/plugins/system/modulesanywhere/helper.php:184

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116

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

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

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

JROOT/index.php:40

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

Query Time: 1.62 ms After last query: 6.03 ms

SELECT m.*

  FROM bdarx_modules AS m

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

  WHERE m.client_id = 0 
  AND m.title = 'Our Services' 
  AND m.access IN (1,1,5) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	25	2.50	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	infratel_INFRA.m.module,const	1	10.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/plugins/system/modulesanywhere/helper.php:537

JROOT/plugins/system/modulesanywhere/helper.php:389

JROOT/plugins/system/modulesanywhere/helper.php:288

JROOT/plugins/system/modulesanywhere/helper.php:268

JROOT/plugins/system/modulesanywhere/helper.php:224

JROOT/plugins/system/modulesanywhere/helper.php:184

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116

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

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

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

JROOT/index.php:40

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

Query Time: 1.50 ms After last query: 6.06 ms

SELECT m.*

  FROM bdarx_modules AS m

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

  WHERE m.client_id = 0 
  AND m.title = 'Our Physical Address' 
  AND m.access IN (1,1,5) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	25	2.50	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	infratel_INFRA.m.module,const	1	10.00	Using index condition; Using where

Profile

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

Call Stack

JROOT/plugins/system/modulesanywhere/helper.php:537

JROOT/plugins/system/modulesanywhere/helper.php:389

JROOT/plugins/system/modulesanywhere/helper.php:288

JROOT/plugins/system/modulesanywhere/helper.php:268

JROOT/plugins/system/modulesanywhere/helper.php:224

JROOT/plugins/system/modulesanywhere/helper.php:184

JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116

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

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

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

JROOT/index.php:40

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

Query Time: 0.95 ms After last query: 14.07 ms

UPDATE `bdarx_session`

  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1716170633;s:18:\"session.timer.last\";i:1716170633;s:17:\"session.timer.now\";i:1716170634;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
	, `time` = '1716170634'

  WHERE `session_id` = 'fgcui3usj86cdua3jmohrri3o3'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	bdarx_session	NULL	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.3 ms
end	0.0 ms
query end	0.1 ms
closing tables	0.0 ms
freeing items	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:

5 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM bdarx_extensions

5 × SELECT m.* 
  FROM bdarx_modules AS m 
  LEFT JOIN bdarx_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

2 × SELECT count(*) 
  FROM `bdarx_vcnt`

```
1 × SELECT * 
  FROM bdarx_content
```

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

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

1 × SELECT count(*) 
  FROM `bdarx_vcnt_pc

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 bdarx_categories as c 
  LEFT JOIN bdarx_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 bdarx_categories AS cat JOIN bdarx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT count(*) 
  FROM `bdarx_vcnt` UNION ALL SELECT count(*) 
  FROM `bdarx_vcnt`

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 bdarx_content AS a 
  LEFT JOIN bdarx_categories AS c 
  on c.id = a.catid 
  LEFT JOIN bdarx_users AS u 
  on u.id = a.created_by 
  LEFT JOIN bdarx_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN bdarx_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM bdarx_categories AS cat JOIN bdarx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

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

```
1 × SELECT * 
  FROM bdarx_languages
```

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

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

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

1 × SELECT `data` 
  FROM `bdarx_session`

OTHER Tables:

1 × CREATE TABLE IF NOT EXISTS `bdarx_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0'

1 × UPDATE `bdarx_session` 
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1716170633;s:18:\"session.timer.last\";i:1716170633;s:17:\"session.timer.now\";i:1716170634;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'  , `time` = '1716170634'

1 × CREATE TABLE IF NOT EXISTS `bdarx_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(16) NOT NULL DEFAULT '0.0.0.0'

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

1 × SHOW FULL COLUMNS 
  FROM `bdarx_content

1 × UPDATE `bdarx_extensions` 
  SET `params` = '{\"mediaversion\":\"d92e2317bd68c4b52a0a0d030ddbf035\"}'