Joomla! Debug Console

35 Queries Logged

1. DELETE
  FROM `hoshc_session`
  WHERE `time` < '1765959211'
2. SELECT `session_id`
  FROM `hoshc_session`
  WHERE `session_id` = 'uaf6btlchm61ep6k77hri3qfq3'
  LIMIT 0, 1
3. INSERT INTO `hoshc_session` (`session_id`, `client_id`, `time`)
  VALUES ('uaf6btlchm61ep6k77hri3qfq3', 0, '1765960111')
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM hoshc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
5. SELECT b.id
  FROM hoshc_usergroups AS a
  LEFT JOIN hoshc_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `hoshc_viewlevels`
7. SELECT folder AS type, element AS name, params
  FROM hoshc_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
8. SELECT extension_id AS id, element AS "option", params, enabled
  FROM hoshc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
9. SELECT `path`
  FROM hoshc_rsfirewall_ignored
  WHERE `type`='ignore_folder' OR `type`='ignore_file'
10. SELECT `file`
  FROM hoshc_rsfirewall_hashes
  WHERE `type`='protect'
11. SELECT *
  FROM hoshc_rsfirewall_configuration
12. SHOW FULL COLUMNS
  FROM `hoshc_rsfirewall_logs`
13. SELECT extension_id AS id, element AS "option", params, enabled
  FROM hoshc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_chameleon'
14. 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 hoshc_menu AS m
  LEFT JOIN hoshc_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
15. SELECT *
  FROM hoshc_languages
  WHERE published=1
  ORDER BY ordering ASC
16. SELECT extension_id AS id, element AS "option", params, enabled
  FROM hoshc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_menus'
17. SELECT r.*
  FROM hoshc_chameleon_rule AS r
  WHERE r.published = 1
  ORDER BY r.ordering
18. SELECT DISTINCT a.id as article_id, a.title as article_title, a.alias as article_alias, a.language as article_language, a.featured as article_featured, a.hits as article_hits, a.version as article_version, a.created_by as article_created_by, a.modified_by as article_modified_by, a.introtext as article_introtext, a.fulltext as article_fulltext, a.created as article_created, a.modified as article_modified, a.publish_up as article_publishup, a.publish_down as article_publishdown, a.metakey as article_metakeywords, a.metadesc as article_metadescription, floor(time_to_sec(timediff(now(),a.created))/60) as article_created_age, floor(time_to_sec(timediff(now(),a.modified))/60) as article_modified_age, a.catid as category_id, cat1.title as category_title, cat1.alias as category_alias, cat1.language as category_language, cat1.description as category_description, cat1.note as category_note, cat1.title as ct1, cat1.id as ci1, cat2.title as ct2, cat2.id as ci2, cat3.title as ct3, cat3.id as ci3, cat4.title as ct4, cat4.id as ci4, cat5.title as ct5, cat5.id as ci5, cat6.title as ct6, cat6.id as ci6, cat7.title as ct7, cat7.id as ci7, cat8.title as ct8, cat8.id as ci8
  FROM `hoshc_content` a
  LEFT JOIN `hoshc_categories` cat1
  ON a.catid = cat1.id
  LEFT JOIN `hoshc_categories` cat2
  ON cat1.parent_id = cat2.id
  LEFT JOIN `hoshc_categories` cat3
  ON cat2.parent_id = cat3.id
  LEFT JOIN `hoshc_categories` cat4
  ON cat3.parent_id = cat4.id
  LEFT JOIN `hoshc_categories` cat5
  ON cat4.parent_id = cat5.id
  LEFT JOIN `hoshc_categories` cat6
  ON cat5.parent_id = cat6.id
  LEFT JOIN `hoshc_categories` cat7
  ON cat6.parent_id = cat7.id
  LEFT JOIN `hoshc_categories` cat8
  ON cat7.parent_id = cat8.id
  WHERE a.id = '38'
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-17 08:28:31' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-17 08:28:31' )
  LIMIT 0, 1
19. SELECT *
  FROM hoshc_rsfirewall_hashes
  WHERE (`type`='2.5.20' OR `type`='protect')
  AND `flag`!='C'
20. SELECT *
  FROM hoshc_rsfirewall_snapshots
  WHERE `type`='protect'
21. SELECT `ip`,`reason`
  FROM hoshc_rsfirewall_lists
  WHERE (`ip`='216.73.216.156' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
  AND `type`='1'
  AND `published`='1'
22. SELECT `ip`,`reason`
  FROM hoshc_rsfirewall_lists
  WHERE (`ip`='216.73.216.156' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
  AND `type`='0'
  AND `published`='1'
23. SELECT *
  FROM hoshc_rsfirewall_exceptions
  WHERE `published`='1'
24. SELECT extension_id AS id, element AS "option", params, enabled
  FROM hoshc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
25. SELECT id, home, template, s.params
  FROM hoshc_template_styles as s
  LEFT JOIN hoshc_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
26. SELECT a.rules
  FROM hoshc_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
27. SELECT b.rules
  FROM hoshc_assets AS a
  LEFT JOIN hoshc_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
28. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
  FROM hoshc_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
  FROM hoshc_content AS a
  LEFT JOIN hoshc_categories AS c
  on c.id = a.catid
  LEFT JOIN hoshc_users AS u
  on u.id = a.created_by
  LEFT JOIN hoshc_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN hoshc_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM hoshc_categories AS cat JOIN hoshc_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published <= 0
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE a.id = 38
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-12-17 08:28:31')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-12-17 08:28:31')
  AND (a.state = 1 OR a.state =2)
29. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM hoshc_categories as c
  LEFT JOIN hoshc_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 hoshc_categories AS cat JOIN hoshc_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=10
  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
  ORDER BY c.lft
30. UPDATE hoshc_content
  SET hits = hits + 1
  WHERE id = 38
31. SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
  FROM hoshc_modules AS m
  LEFT JOIN hoshc_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN hoshc_advancedmodules as am
  ON am.moduleid = m.id
  WHERE m.published = 1
  AND e.enabled = 1
  AND m.client_id = 0
  AND m.access IN (1,1)
  ORDER BY m.ordering, m.id
32. SELECT extension_id AS id, element AS "option", params, enabled
  FROM hoshc_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_advancedmodules'
33. SELECT m.menutype
  FROM hoshc_menu AS m
  WHERE m.id = 150
34. SELECT m.*
  FROM hoshc_menu AS m
  WHERE menutype='footernav'
  AND published = 1
  AND access IN (1,1)
  ORDER BY lft
35. SELECT *
  FROM hoshc_content
  WHERE id=38
  LIMIT 1

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 6 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM hoshc_extensions
2. 2 × SELECT `ip`,`reason`
  FROM hoshc_rsfirewall_lists
3. 1 × SELECT b.rules
  FROM hoshc_assets AS a
  LEFT JOIN hoshc_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
4. 1 × SELECT a.rules
  FROM hoshc_assets AS a
5. 1 × SELECT *
  FROM hoshc_rsfirewall_exceptions
6. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
  FROM hoshc_contact_details AS contact
7. 1 × SELECT id, home, template, s.params
  FROM hoshc_template_styles as s
  LEFT JOIN hoshc_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
8. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM hoshc_categories as c
  LEFT JOIN hoshc_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 hoshc_categories AS cat JOIN hoshc_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
9. 1 × SELECT *
  FROM hoshc_content
10. 1 × SELECT m.*
  FROM hoshc_menu AS m
11. 1 × SELECT m.menutype
  FROM hoshc_menu AS m
12. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
  FROM hoshc_modules AS m
  LEFT JOIN hoshc_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN hoshc_advancedmodules as am
  ON am.moduleid = m.id
13. 1 × SELECT *
  FROM hoshc_rsfirewall_snapshots
14. 1 × SELECT *
  FROM hoshc_rsfirewall_hashes
15. 1 × SELECT `path`
  FROM hoshc_rsfirewall_ignored
16. 1 × SELECT folder AS type, element AS name, params
  FROM hoshc_extensions
17. 1 × SELECT id, rules
  FROM `hoshc_viewlevels
18. 1 × SELECT b.id
  FROM hoshc_usergroups AS a
  LEFT JOIN hoshc_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
19. 1 × SELECT `file`
  FROM hoshc_rsfirewall_hashes
20. 1 × SELECT *
  FROM hoshc_rsfirewall_configuratio
21. 1 × SELECT DISTINCT a.id as article_id, a.title as article_title, a.alias as article_alias, a.language as article_language, a.featured as article_featured, a.hits as article_hits, a.version as article_version, a.created_by as article_created_by, a.modified_by as article_modified_by, a.introtext as article_introtext, a.fulltext as article_fulltext, a.created as article_created, a.modified as article_modified, a.publish_up as article_publishup, a.publish_down as article_publishdown, a.metakey as article_metakeywords, a.metadesc as article_metadescription, floor(time_to_sec(timediff(now(),a.created))/60) as article_created_age, floor(time_to_sec(timediff(now(),a.modified))/60) as article_modified_age, a.catid as category_id, cat1.title as category_title, cat1.alias as category_alias, cat1.language as category_language, cat1.description as category_description, cat1.note as category_note, cat1.title as ct1, cat1.id as ci1, cat2.title as ct2, cat2.id as ci2, cat3.title as ct3, cat3.id as ci3, cat4.title as ct4, cat4.id as ci4, cat5.title as ct5, cat5.id as ci5, cat6.title as ct6, cat6.id as ci6, cat7.title as ct7, cat7.id as ci7, cat8.title as ct8, cat8.id as ci8
  FROM `hoshc_content` a
  LEFT JOIN `hoshc_categories` cat1
  ON a.catid = cat1.id
  LEFT JOIN `hoshc_categories` cat2
  ON cat1.parent_id = cat2.id
  LEFT JOIN `hoshc_categories` cat3
  ON cat2.parent_id = cat3.id
  LEFT JOIN `hoshc_categories` cat4
  ON cat3.parent_id = cat4.id
  LEFT JOIN `hoshc_categories` cat5
  ON cat4.parent_id = cat5.id
  LEFT JOIN `hoshc_categories` cat6
  ON cat5.parent_id = cat6.id
  LEFT JOIN `hoshc_categories` cat7
  ON cat6.parent_id = cat7.id
  LEFT JOIN `hoshc_categories` cat8
  ON cat7.parent_id = cat8.id
22. 1 × SELECT r.*
  FROM hoshc_chameleon_rule AS r
23. 1 × SELECT *
  FROM hoshc_languages
24. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM hoshc_menu AS m
  LEFT JOIN hoshc_extensions AS e
  ON m.component_id = e.extension_id
25. 1 × SELECT `session_id`
  FROM `hoshc_session`

OTHER Tables:

1. 1 × UPDATE hoshc_content
  SET hits = hits + 1
2. 1 × SHOW FULL COLUMNS
  FROM `hoshc_rsfirewall_logs
3. 1 × INSERT INTO `hoshc_session` (`session_id`, `client_id`, `time`)
  VALUES ('uaf6btlchm61ep6k77hri3qfq3', 0, '1765960111'
4. 1 × DELETE
  FROM `hoshc_session`