How many articles /categories do yuo have ?

So despite not having any tags,
the tags SELECT query takes:
33% * 1.81 seconds = 0.59 seconds ?

Can you also use the Joomla Debug option ?

• and from it copy paste here the real SQL query and the function Call stack

the above will answer questions:

• which is the SQL query, is it core Joomla, or some 3rd party plugin/module, or a joomla module ?
• is it 1 SELECT query or multiple SELECT queries ?

@hans2103 Please can you provide the requested informaton

sorry... totally missed the request. Will do

Problem only occurs on a 404 page. Joomla can't find the page, therefor it will try non existing tags... so it seems.

SQL statement copied from New Relic.

SELECT m.tag_id, t.*FROM t?hu_contentitem_tag_map AS m INNER JOIN t?hu_tags AS t ON m.tag_id = t.idWHERE m.type_alias = ? AND m.content_item_id = ? AND t.published = ? AND t.access IN (?, ?, ?)

I cant replicate this. With debug on I dont see any queries for tags on a 404 page. As the 404 page uses the error.php from your template I am wondering if there is something in that file in your template

@brianteeman I will check

I can't reproduce the problem either. Joomla's debug does not show any queries on a 404 page.
The issue has not been followed up since last year so I'll ask to close it.
Thanks @hans2103

Closing

Set to "closed" on behalf of @zero-24 by The JTracker Application at issues.joomla.org/joomla-cms/7124

check