UCT’s commitment is to provide high performance and durable solutions in an economical manner for all types of underground construction such as:

Motorways & Long and/or Deep Road Tunnels to connect populations
Underground Parking
Mass Transit Systems
Public Utilities (hydroelectric, water & wastewater, flood control)
By-Pass Historic, Cultural, Scenic, & Congested Locations

Highlighted below are the specific products that cater to the requirements of underground construction that cover all aspects of our customer needs.

Joomla! Debug Console

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.2 ms
updating	0.2 ms
end	0.0 ms
query end	13.8 ms
closing tables	0.1 ms
freeing items	0.0 ms
updating status	0.1 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.1 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.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
update	0.1 ms
end	0.0 ms
query end	9.8 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.2 ms
preparing	0.1 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.0 ms
updating status	0.0 ms
cleaning up	0.1 ms

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

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

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.1 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay1gs_extensions	ref	extension	extension	62	const	69	Using index condition; Using where; Using filesort

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.1 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 ms
executing	0.0 ms
Sorting result	0.5 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
updating status	0.0 ms
cleaning up	0.0 ms

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

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.2 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.0 ms
updating status	0.1 ms
cleaning up	0.0 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ay1gs_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	151	Using where

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.1 ms
statistics	0.1 ms
preparing	0.1 ms
executing	0.0 ms
Sending data	0.6 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.1 ms
cleaning up	0.0 ms

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

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

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
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.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

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	150	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	healthjo_UCT.m.component_id	1	Using where

Status	Duration
starting	0.4 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.1 ms
optimizing	0.1 ms
statistics	0.1 ms
preparing	0.1 ms
executing	0.0 ms
Sorting result	0.8 ms
Sending data	0.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.1 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 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.0 ms
updating status	0.0 ms
cleaning up	0.1 ms

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.0 ms
cleaning up	0.1 ms

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.1 ms
Updating	0.1 ms
end	0.0 ms
query end	13.7 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.1 ms
cleaning up	0.0 ms

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.7 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Filling schema table	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
checking permissions	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.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
checking permissions	0.1 ms
checking permissions	0.1 ms
closing tables	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.2 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.1 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 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.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.1 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	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.0 ms
updating status	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 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
updating status	0.0 ms
cleaning up	0.0 ms

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

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

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table 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
updating status	0.0 ms
cleaning up	0.0 ms

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	13	Using where

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.0 ms
optimizing	0.1 ms
statistics	0.2 ms
preparing	0.1 ms
executing	0.0 ms
Creating tmp table	0.8 ms
Copying to tmp table	0.3 ms
Sorting result	0.1 ms
Sending data	0.1 ms
end	0.0 ms
removing tmp table	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
updating status	0.1 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.4 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.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
After table lock	0.0 ms
init	0.3 ms
optimizing	0.0 ms
optimizing	0.1 ms
statistics	0.2 ms
preparing	0.1 ms
statistics	0.3 ms
preparing	0.1 ms
executing	0.0 ms
Sending data	0.1 ms
executing	0.0 ms
Creating tmp table	0.1 ms
Copying to tmp table	0.2 ms
Sorting result	0.0 ms
Sending data	0.0 ms
removing tmp table	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.0 ms
updating status	0.1 ms
cleaning up	0.0 ms

EXPLAIN not possible on query: UPDATE `ay1gs_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713969827;s:18:\"session.timer.last\";i:1713969827;s:17:\"session.timer.now\";i:1713969827;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` = '1713969828' WHERE `session_id` = 'mjmqp4rs02jf8qdt1uav08ljp5'

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.1 ms
After table lock	0.0 ms
init	0.2 ms
Updating	0.2 ms
end	0.0 ms
query end	10.5 ms
closing tables	0.1 ms
freeing items	0.0 ms
updating status	0.1 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]

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

```
2 × SELECT * 
  FROM ay1gs_extensions
```

2 × SELECT `extension_id` 
  FROM `ay1gs_extensions`

2 × SELECT template 
  FROM ay1gs_template_styles as s

1 × SELECT a.rules 
  FROM ay1gs_assets AS a

1 × SELECT b.rules 
  FROM ay1gs_assets AS a 
  LEFT JOIN ay1gs_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.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 ay1gs_categories as c 
  LEFT JOIN ay1gs_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 ay1gs_categories AS cat JOIN ay1gs_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 ay1gs_modules AS m 
  LEFT JOIN ay1gs_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ay1gs_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

```
1 × SELECT * 
  FROM ay1gs_content
```

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

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 ay1gs_content AS a 
  LEFT JOIN ay1gs_categories AS c 
  on c.id = a.catid 
  LEFT JOIN ay1gs_users AS u 
  on u.id = a.created_by 
  LEFT JOIN ay1gs_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ay1gs_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM ay1gs_categories AS cat JOIN ay1gs_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 ay1gs_menu AS m 
  LEFT JOIN ay1gs_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, rules 
  FROM `ay1gs_viewlevels

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

1 × SELECT `session_id` 
  FROM `ay1gs_session`

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

```
1 × SELECT * 
  FROM ay1gs_languages
```

1 × SELECT `data` 
  FROM `ay1gs_session`

1 × SELECT extension, file, type 
  FROM ay1gs_rokcommon_configs

1 × SELECT COUNT(*) 
  FROM `ay1gs_menu`

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

OTHER Tables:

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

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

1 × SHOW FULL COLUMNS 
  FROM `ay1gs_content

1 × SHOW FULL COLUMNS 
  FROM `ay1gs_extensions

1 × INSERT INTO `ay1gs_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('mjmqp4rs02jf8qdt1uav08ljp5', 0, '1713969827'

1 × UPDATE `ay1gs_extensions` 
  SET `params` = '{\"mediaversion\":\"4151815ebd92594da86ba8e609358f99\"}'

```
1 × DELETE  
  FROM `ay1gs_session`
```

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

35 Queries Logged 129.3 ms

4 duplicate found!

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: