Add value to our customers’ businesses through high-end products & services.
Derives its strength from a 50 plus year history of excellence & Multinational outlook.
The Premier & Prestigious Companies, the Proud of Pakistan are our valued Clients.
Founded in 1962, Wah Nobel is a joint venture between Wah Industries Limited, Saab (Sweden) and Almisehal (Saudi Arabia). Wah Nobel Group is a multinational group with six companies on its orbit. It is engaged in production of Commercial Explosives/Accessories, wide range of Industrial Chemicals and Acetates and has a presence in the Energy Sector.
The primary aim of this Joint Venture was to start production of Commercial Explosives indigenously....
Wah Nobel operates as a Commercial Subsidiary of POF on commercial frequency and wavelength. The shareholders of Wah Nobel are: WIL (Pakistan) - 51.75%, SAAB (Sweden) - 27.23%, Al-Misehal Group (Saudi Arabia) - 21.02%. Since 1962, Wah Nobel Group has experienced rapid expansion of business and has grown into one of the largest manufacturing conglomerates in Pakistan with 6 Companies on its orbit. This has been the result of our team of dedicated workforce working diligently to satisfy the needs of our customers.
In pursuit of excellence, we are driven by Customer Satisfaction, Quality Control and Corporate Social Responsibility
SELECT `data`
FROM `sfd57_session`
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
executing | 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 |
DELETE
FROM `sfd57_session`
WHERE `time` < '1736352867'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | DELETE | sfd57_session | NULL | range | time | time | 59 | const | 1 | 100.00 | Using where |
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.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `session_id`
FROM `sfd57_session`
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
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 |
executing | 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 |
INSERT INTO `sfd57_session` (`session_id`, `client_id`, `time`)
VALUES ('6pu97fobiggdaodfahk9b7mjv5', 0, '1736353767')
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 |
update | 0.0 ms |
end | 0.0 ms |
query end | 0.2 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
WHERE `type` = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | extension | extension | 82 | const | 37 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.2 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 |
SELECT b.id
FROM sfd57_usergroups AS a
LEFT JOIN sfd57_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
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 | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT id, rules
FROM `sfd57_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 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.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 |
SELECT folder AS type, element AS name, params
FROM sfd57_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | extension | extension | 82 | const | 123 | 0.43 | Using index condition; Using where; Using filesort |
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 |
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 |
SELECT *
FROM sfd57_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 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 |
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 sfd57_menu AS m
LEFT JOIN sfd57_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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 261 | 8.28 | Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 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 | 1.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 |
SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
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.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 |
cleaning up | 0.0 ms |
UPDATE `sfd57_extensions`
SET `params` = '{\"mediaversion\":\"ac52775144fe14d1d442413ad671ebc7\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | sfd57_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
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 |
updating | 0.0 ms |
end | 0.0 ms |
query end | 0.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT id, home, template, s.params
FROM sfd57_template_styles as s
LEFT JOIN sfd57_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
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 | 9 | 11.11 | Using where |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | wahnobel_theemedia.s.template,const | 1 | 4.53 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 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.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 |
SELECT a.rules
FROM sfd57_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
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 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT b.rules
FROM sfd57_assets AS a
LEFT JOIN sfd57_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
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 | 202 | const | 1 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | b | NULL | range | idx_lft_rgt | idx_lft_rgt | 4 | NULL | 14 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 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 |
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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
INNER JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
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 DESC
LIMIT 0, 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | fp | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 9 | 100.00 | Using index; Using temporary; Using filesort |
1 | PRIMARY | a | NULL | eq_ref | PRIMARY,idx_access,idx_catid,idx_language | PRIMARY | 4 | wahnobel_theemedia.fp.content_id | 1 | 16.00 | Using where |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | wahnobel_theemedia.a.catid | 1 | 100.00 | Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.c.parent_id | 1 | 100.00 | Using where |
1 | PRIMARY | v | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | wahnobel_theemedia.c.id | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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.7 ms |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.2 ms |
preparing | 0.0 ms |
Creating tmp table | 0.1 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 242.1 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 ms |
Creating sort index | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 54
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT COUNT(*)
FROM sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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
INNER JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | fp | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 9 | 100.00 | Using index |
1 | PRIMARY | a | NULL | eq_ref | PRIMARY,idx_access,idx_catid,idx_language | PRIMARY | 4 | wahnobel_theemedia.fp.content_id | 1 | 16.00 | Using where |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | wahnobel_theemedia.a.catid | 1 | 100.00 | Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.c.parent_id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | wahnobel_theemedia.c.id | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 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 |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_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)
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
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 | 53 | 38.78 | Using where |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | 10.00 | Using where; Not exists; Using join buffer (Block Nested Loop) |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.4 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
SELECT *
FROM sfd57_template_styles
WHERE template = 'corpway';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_template_styles | NULL | ref | idx_template | idx_template | 202 | const | 1 | 100.00 | NULL |
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 |
SELECT *
FROM sfd57_menu
WHERE template_style_id IN (17)
AND alias = 'home'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_alias | idx_alias | 402 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 ms |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sfd57_modules AS m
LEFT JOIN sfd57_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sfd57_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 <= '2025-01-08 16:29:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-08 16:29:27')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds,idx_language | published | 5 | NULL | 59 | 1.60 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | wahnobel_theemedia.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.id | 8 | 40.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 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 | 1.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 |
SELECT menutype
FROM sfd57_menu
WHERE language = 'en-GB'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 ms |
SELECT menutype
FROM sfd57_menu
WHERE language = 'en-GB'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 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 sfd57_menu AS m
LEFT JOIN sfd57_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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 261 | 8.28 | Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 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 |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.9 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 |
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.featured = 0
AND a.catid IN (27)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
ORDER BY a.created DESC
LIMIT 0, 7
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | PRIMARY | a | NULL | ref | idx_access,idx_catid,idx_featured_catid,idx_language | idx_catid | 4 | const | 8 | 8.00 | Using index condition; Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where |
1 | PRIMARY | fp | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | const | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 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.2 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 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 |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 134
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 86
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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.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 |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 73
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 72
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 71
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 69
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 68
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_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)
AND c.published = 1
AND s.id=27
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
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 | 53 | 38.78 | Using where |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | 10.00 | Using where; Not exists; Using join buffer (Block Nested Loop) |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
Opening tables | 0.0 ms |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.1 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
UPDATE `sfd57_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1736353767;s:18:\"session.timer.last\";i:1736353767;s:17:\"session.timer.now\";i:1736353767;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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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:\"1\";}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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5fd7cbb066563669ca05f9ad0063e416\";}' , `time` = '1736353767'
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | sfd57_session | NULL | range | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using where |
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 |
updating | 0.1 ms |
end | 0.0 ms |
query end | 0.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
8 × SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × SELECT menutype
FROM sfd57_menu
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
2 × 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 sfd57_menu AS m
LEFT JOIN sfd57_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT COUNT(*)
FROM sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM sfd57_menu
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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 sfd57_modules AS m
LEFT JOIN sfd57_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sfd57_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM sfd57_template_styles
1 × SELECT a.rules
FROM sfd57_assets AS a
1 × SELECT id, rules
FROM `sfd57_viewlevels
1 × SELECT b.id
FROM sfd57_usergroups AS a
LEFT JOIN sfd57_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `sfd57_session`
1 × SELECT folder AS type, element AS name, params
FROM sfd57_extensions
1 × SELECT *
FROM sfd57_languages
1 × SELECT `data`
FROM `sfd57_session`
1 × SELECT id, home, template, s.params
FROM sfd57_template_styles as s
LEFT JOIN sfd57_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT b.rules
FROM sfd57_assets AS a
LEFT JOIN sfd57_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × UPDATE `sfd57_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1736353767;s:18:\"session.timer.last\";i:1736353767;s:17:\"session.timer.now\";i:1736353767;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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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:\"1\";}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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5fd7cbb066563669ca05f9ad0063e416\";}' , `time` = '1736353767'
1 × UPDATE `sfd57_extensions`
SET `params` = '{\"mediaversion\":\"ac52775144fe14d1d442413ad671ebc7\"}'
1 × INSERT INTO `sfd57_session` (`session_id`, `client_id`, `time`)
VALUES ('6pu97fobiggdaodfahk9b7mjv5', 0, '1736353767'
1 × DELETE
FROM `sfd57_session`
The company was established in 1962 and has enjoyed phenomenal progress. The company has been providing a one stop solution for a complete range of Commercial Explosives and related Services for the past 5 decades. We also produce Emulsion & Seismic Explosives and complete range of Accessories and Detonators.
Wah Nobel Chemicals produces an impressive range of high quality Industrial Chemicals and Raisins which have diverse applications in numerous industries.
The chemical products of Wah Nobel are used in industries like textile, leather, food, agriculture, pharmaceutical, printing, dying, paint, lacquer, varnish, plywood, chipboard, hardboard, sugar and in foundries.
Pakistan Ordnance Factory
Saab Group - Sweden
Al Misehal Group - Saudi Arabia
We are here to serve you during the following business hours:
Monday to Friday: 8:00am to 4:30pm
Saturday and Sunday: Closed
Phone: (92-51)4545243-6
Contact Us Today
Wah Nobel Group of Companies, GT Road, Wah, Punjab, Pakistan
SELECT `data`
FROM `sfd57_session`
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
executing | 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 |
DELETE
FROM `sfd57_session`
WHERE `time` < '1736352867'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | DELETE | sfd57_session | NULL | range | time | time | 59 | const | 1 | 100.00 | Using where |
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.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `session_id`
FROM `sfd57_session`
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
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 |
executing | 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 |
INSERT INTO `sfd57_session` (`session_id`, `client_id`, `time`)
VALUES ('6pu97fobiggdaodfahk9b7mjv5', 0, '1736353767')
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 |
update | 0.0 ms |
end | 0.0 ms |
query end | 0.2 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
WHERE `type` = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | extension | extension | 82 | const | 37 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.2 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 |
SELECT b.id
FROM sfd57_usergroups AS a
LEFT JOIN sfd57_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
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 | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT id, rules
FROM `sfd57_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 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.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 |
SELECT folder AS type, element AS name, params
FROM sfd57_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | extension | extension | 82 | const | 123 | 0.43 | Using index condition; Using where; Using filesort |
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 |
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 |
SELECT *
FROM sfd57_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 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 |
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 sfd57_menu AS m
LEFT JOIN sfd57_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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 261 | 8.28 | Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 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 | 1.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 |
SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
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.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 |
cleaning up | 0.0 ms |
UPDATE `sfd57_extensions`
SET `params` = '{\"mediaversion\":\"ac52775144fe14d1d442413ad671ebc7\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | sfd57_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
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 |
updating | 0.0 ms |
end | 0.0 ms |
query end | 0.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT id, home, template, s.params
FROM sfd57_template_styles as s
LEFT JOIN sfd57_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
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 | 9 | 11.11 | Using where |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | wahnobel_theemedia.s.template,const | 1 | 4.53 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 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.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 |
SELECT a.rules
FROM sfd57_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
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 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT b.rules
FROM sfd57_assets AS a
LEFT JOIN sfd57_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
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 | 202 | const | 1 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | b | NULL | range | idx_lft_rgt | idx_lft_rgt | 4 | NULL | 14 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 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 |
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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
INNER JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
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 DESC
LIMIT 0, 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | fp | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 9 | 100.00 | Using index; Using temporary; Using filesort |
1 | PRIMARY | a | NULL | eq_ref | PRIMARY,idx_access,idx_catid,idx_language | PRIMARY | 4 | wahnobel_theemedia.fp.content_id | 1 | 16.00 | Using where |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | wahnobel_theemedia.a.catid | 1 | 100.00 | Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.c.parent_id | 1 | 100.00 | Using where |
1 | PRIMARY | v | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | wahnobel_theemedia.c.id | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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.7 ms |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.2 ms |
preparing | 0.0 ms |
Creating tmp table | 0.1 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 242.1 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 ms |
Creating sort index | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 54
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT COUNT(*)
FROM sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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
INNER JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | fp | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 9 | 100.00 | Using index |
1 | PRIMARY | a | NULL | eq_ref | PRIMARY,idx_access,idx_catid,idx_language | PRIMARY | 4 | wahnobel_theemedia.fp.content_id | 1 | 16.00 | Using where |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | wahnobel_theemedia.a.catid | 1 | 100.00 | Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.c.parent_id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | wahnobel_theemedia.c.id | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 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 |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_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)
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
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 | 53 | 38.78 | Using where |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | 10.00 | Using where; Not exists; Using join buffer (Block Nested Loop) |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.4 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
SELECT *
FROM sfd57_template_styles
WHERE template = 'corpway';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_template_styles | NULL | ref | idx_template | idx_template | 202 | const | 1 | 100.00 | NULL |
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 |
SELECT *
FROM sfd57_menu
WHERE template_style_id IN (17)
AND alias = 'home'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_alias | idx_alias | 402 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 ms |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sfd57_modules AS m
LEFT JOIN sfd57_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sfd57_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 <= '2025-01-08 16:29:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-08 16:29:27')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds,idx_language | published | 5 | NULL | 59 | 1.60 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | wahnobel_theemedia.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.id | 8 | 40.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 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 | 1.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 |
SELECT menutype
FROM sfd57_menu
WHERE language = 'en-GB'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 ms |
SELECT menutype
FROM sfd57_menu
WHERE language = 'en-GB'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 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 sfd57_menu AS m
LEFT JOIN sfd57_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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 261 | 8.28 | Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 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 |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.9 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 |
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.featured = 0
AND a.catid IN (27)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
ORDER BY a.created DESC
LIMIT 0, 7
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | PRIMARY | a | NULL | ref | idx_access,idx_catid,idx_featured_catid,idx_language | idx_catid | 4 | const | 8 | 8.00 | Using index condition; Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where |
1 | PRIMARY | fp | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | const | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 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.2 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 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 |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 134
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 86
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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.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 |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 73
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 72
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 71
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 69
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 68
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_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)
AND c.published = 1
AND s.id=27
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
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 | 53 | 38.78 | Using where |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | 10.00 | Using where; Not exists; Using join buffer (Block Nested Loop) |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
Opening tables | 0.0 ms |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.1 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
UPDATE `sfd57_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1736353767;s:18:\"session.timer.last\";i:1736353767;s:17:\"session.timer.now\";i:1736353767;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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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:\"1\";}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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5fd7cbb066563669ca05f9ad0063e416\";}' , `time` = '1736353767'
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | sfd57_session | NULL | range | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using where |
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 |
updating | 0.1 ms |
end | 0.0 ms |
query end | 0.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
8 × SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × SELECT menutype
FROM sfd57_menu
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
2 × 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 sfd57_menu AS m
LEFT JOIN sfd57_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT COUNT(*)
FROM sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM sfd57_menu
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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 sfd57_modules AS m
LEFT JOIN sfd57_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sfd57_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM sfd57_template_styles
1 × SELECT a.rules
FROM sfd57_assets AS a
1 × SELECT id, rules
FROM `sfd57_viewlevels
1 × SELECT b.id
FROM sfd57_usergroups AS a
LEFT JOIN sfd57_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `sfd57_session`
1 × SELECT folder AS type, element AS name, params
FROM sfd57_extensions
1 × SELECT *
FROM sfd57_languages
1 × SELECT `data`
FROM `sfd57_session`
1 × SELECT id, home, template, s.params
FROM sfd57_template_styles as s
LEFT JOIN sfd57_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT b.rules
FROM sfd57_assets AS a
LEFT JOIN sfd57_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × UPDATE `sfd57_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1736353767;s:18:\"session.timer.last\";i:1736353767;s:17:\"session.timer.now\";i:1736353767;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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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:\"1\";}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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5fd7cbb066563669ca05f9ad0063e416\";}' , `time` = '1736353767'
1 × UPDATE `sfd57_extensions`
SET `params` = '{\"mediaversion\":\"ac52775144fe14d1d442413ad671ebc7\"}'
1 × INSERT INTO `sfd57_session` (`session_id`, `client_id`, `time`)
VALUES ('6pu97fobiggdaodfahk9b7mjv5', 0, '1736353767'
1 × DELETE
FROM `sfd57_session`
Founded in 1962, Wah Nobel is a joint venture between the Wah Industries Limited, Saab Sweden & Almisehal Company Saudi Arabia.Wah Nobel Group is a multinational group with six companies on its orbit. It is engaged in production of Commercial Explosives/Accessories, wide range of Industrial Chemicals & Acetates & has a presence in the Energy Sector.
SELECT `data`
FROM `sfd57_session`
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
executing | 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 |
DELETE
FROM `sfd57_session`
WHERE `time` < '1736352867'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | DELETE | sfd57_session | NULL | range | time | time | 59 | const | 1 | 100.00 | Using where |
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.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `session_id`
FROM `sfd57_session`
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_session | NULL | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
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 |
executing | 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 |
INSERT INTO `sfd57_session` (`session_id`, `client_id`, `time`)
VALUES ('6pu97fobiggdaodfahk9b7mjv5', 0, '1736353767')
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 |
update | 0.0 ms |
end | 0.0 ms |
query end | 0.2 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
WHERE `type` = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | extension | extension | 82 | const | 37 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.2 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 |
SELECT b.id
FROM sfd57_usergroups AS a
LEFT JOIN sfd57_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
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 | 1 | 100.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT id, rules
FROM `sfd57_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | NULL |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 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.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 |
SELECT folder AS type, element AS name, params
FROM sfd57_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | extension | extension | 82 | const | 123 | 0.43 | Using index condition; Using where; Using filesort |
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 |
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 |
SELECT *
FROM sfd57_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 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 |
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 sfd57_menu AS m
LEFT JOIN sfd57_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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 261 | 8.28 | Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 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 | 1.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 |
SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
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.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 |
cleaning up | 0.0 ms |
UPDATE `sfd57_extensions`
SET `params` = '{\"mediaversion\":\"ac52775144fe14d1d442413ad671ebc7\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | sfd57_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
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 |
updating | 0.0 ms |
end | 0.0 ms |
query end | 0.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT id, home, template, s.params
FROM sfd57_template_styles as s
LEFT JOIN sfd57_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
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 | 9 | 11.11 | Using where |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | wahnobel_theemedia.s.template,const | 1 | 4.53 | Using index condition; Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 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.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 |
SELECT a.rules
FROM sfd57_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
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 |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.2 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT b.rules
FROM sfd57_assets AS a
LEFT JOIN sfd57_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
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 | 202 | const | 1 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | b | NULL | range | idx_lft_rgt | idx_lft_rgt | 4 | NULL | 14 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 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 |
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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
INNER JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
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 DESC
LIMIT 0, 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | fp | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 9 | 100.00 | Using index; Using temporary; Using filesort |
1 | PRIMARY | a | NULL | eq_ref | PRIMARY,idx_access,idx_catid,idx_language | PRIMARY | 4 | wahnobel_theemedia.fp.content_id | 1 | 16.00 | Using where |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | wahnobel_theemedia.a.catid | 1 | 100.00 | Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.c.parent_id | 1 | 100.00 | Using where |
1 | PRIMARY | v | NULL | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | wahnobel_theemedia.c.id | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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.7 ms |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.2 ms |
preparing | 0.0 ms |
Creating tmp table | 0.1 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 242.1 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 ms |
Creating sort index | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 54
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 ms |
System lock | 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 |
cleaning up | 0.0 ms |
SELECT COUNT(*)
FROM sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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
INNER JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | fp | NULL | index | PRIMARY | PRIMARY | 4 | NULL | 9 | 100.00 | Using index |
1 | PRIMARY | a | NULL | eq_ref | PRIMARY,idx_access,idx_catid,idx_language | PRIMARY | 4 | wahnobel_theemedia.fp.content_id | 1 | 16.00 | Using where |
1 | PRIMARY | c | NULL | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | wahnobel_theemedia.a.catid | 1 | 100.00 | Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | parent | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.c.parent_id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | wahnobel_theemedia.c.id | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 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 |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_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)
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
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 | 53 | 38.78 | Using where |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | 10.00 | Using where; Not exists; Using join buffer (Block Nested Loop) |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.4 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
SELECT *
FROM sfd57_template_styles
WHERE template = 'corpway';
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_template_styles | NULL | ref | idx_template | idx_template | 202 | const | 1 | 100.00 | NULL |
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 |
SELECT *
FROM sfd57_menu
WHERE template_style_id IN (17)
AND alias = 'home'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_alias | idx_alias | 402 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 ms |
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sfd57_modules AS m
LEFT JOIN sfd57_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sfd57_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 <= '2025-01-08 16:29:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-08 16:29:27')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds,idx_language | published | 5 | NULL | 59 | 1.60 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | wahnobel_theemedia.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.id | 8 | 40.00 | Using where; Using index |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.3 ms |
init | 0.0 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 | 1.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 |
SELECT menutype
FROM sfd57_menu
WHERE language = 'en-GB'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 ms |
SELECT menutype
FROM sfd57_menu
WHERE language = 'en-GB'
AND home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | sfd57_menu | NULL | ref | idx_language | idx_language | 28 | const | 1 | 10.00 | Using where |
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.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 |
cleaning up | 0.0 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 sfd57_menu AS m
LEFT JOIN sfd57_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
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 261 | 8.28 | Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.1 ms |
checking permissions | 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 |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.9 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 |
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.featured = 0
AND a.catid IN (27)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-08 16:29:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-08 16:29:27')
AND a.language in ('en-GB','*')
ORDER BY a.created DESC
LIMIT 0, 7
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
1 | PRIMARY | a | NULL | ref | idx_access,idx_catid,idx_featured_catid,idx_language | idx_catid | 4 | const | 8 | 8.00 | Using index condition; Using where |
1 | PRIMARY | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.created_by | 1 | 100.00 | Using where |
1 | PRIMARY | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.modified_by | 1 | 100.00 | Using where |
1 | PRIMARY | fp | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where; Using index |
1 | PRIMARY | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
1 | PRIMARY | v | NULL | eq_ref | PRIMARY | PRIMARY | 4 | wahnobel_theemedia.a.id | 1 | 100.00 | Using where |
1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | const | 4 | 100.00 | Using where; Using index |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 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.2 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 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 |
removing tmp table | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 134
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 86
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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.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 |
cleaning up | 0.0 ms |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 73
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 72
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 71
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 69
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 68
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | NULL | ALL | idx_tag_type | 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 | wahnobel_theemedia.m.tag_id | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.0 ms |
checking permissions | 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 |
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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_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)
AND c.published = 1
AND s.id=27
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
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 | 53 | 38.78 | Using where |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 40 | 10.00 | Using where; Not exists; Using join buffer (Block Nested Loop) |
2 | DERIVED | parent | NULL | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 3 | 100.00 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | NULL | index | PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias | idx_left_right | 8 | NULL | 53 | 11.11 | Using where; Using index; Using join buffer (Block Nested Loop) |
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 |
Opening tables | 0.0 ms |
init | 0.1 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
statistics | 0.1 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.0 ms |
executing | 0.0 ms |
Sending data | 0.1 ms |
Creating sort index | 0.3 ms |
Creating sort index | 0.0 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 0.1 ms |
query end | 0.0 ms |
removing tmp table | 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 |
cleaning up | 0.0 ms |
UPDATE `sfd57_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1736353767;s:18:\"session.timer.last\";i:1736353767;s:17:\"session.timer.now\";i:1736353767;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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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:\"1\";}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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5fd7cbb066563669ca05f9ad0063e416\";}' , `time` = '1736353767'
WHERE `session_id` = '6pu97fobiggdaodfahk9b7mjv5'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | UPDATE | sfd57_session | NULL | range | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using where |
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 |
updating | 0.1 ms |
end | 0.0 ms |
query end | 0.3 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
8 × SELECT `m`.`tag_id`,`t`.*
FROM `sfd57_contentitem_tag_map` AS m
INNER JOIN `sfd57_tags` AS t
ON `m`.`tag_id` = `t`.`id`
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 sfd57_categories as c
LEFT JOIN sfd57_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 sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
2 × SELECT menutype
FROM sfd57_menu
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM sfd57_extensions
2 × 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 sfd57_menu AS m
LEFT JOIN sfd57_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT COUNT(*)
FROM sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM sfd57_menu
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_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 sfd57_modules AS m
LEFT JOIN sfd57_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sfd57_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
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, a.language, 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 sfd57_content AS a
LEFT JOIN sfd57_categories AS c
ON c.id = a.catid
LEFT JOIN sfd57_users AS ua
ON ua.id = a.created_by
LEFT JOIN sfd57_users AS uam
ON uam.id = a.modified_by
LEFT JOIN sfd57_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sfd57_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sfd57_categories AS cat JOIN sfd57_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM sfd57_template_styles
1 × SELECT a.rules
FROM sfd57_assets AS a
1 × SELECT id, rules
FROM `sfd57_viewlevels
1 × SELECT b.id
FROM sfd57_usergroups AS a
LEFT JOIN sfd57_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `sfd57_session`
1 × SELECT folder AS type, element AS name, params
FROM sfd57_extensions
1 × SELECT *
FROM sfd57_languages
1 × SELECT `data`
FROM `sfd57_session`
1 × SELECT id, home, template, s.params
FROM sfd57_template_styles as s
LEFT JOIN sfd57_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT b.rules
FROM sfd57_assets AS a
LEFT JOIN sfd57_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × UPDATE `sfd57_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1736353767;s:18:\"session.timer.last\";i:1736353767;s:17:\"session.timer.now\";i:1736353767;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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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:\"1\";}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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5fd7cbb066563669ca05f9ad0063e416\";}' , `time` = '1736353767'
1 × UPDATE `sfd57_extensions`
SET `params` = '{\"mediaversion\":\"ac52775144fe14d1d442413ad671ebc7\"}'
1 × INSERT INTO `sfd57_session` (`session_id`, `client_id`, `time`)
VALUES ('6pu97fobiggdaodfahk9b7mjv5', 0, '1736353767'
1 × DELETE
FROM `sfd57_session`