Debug Console

$_GET

Array( ) Array(

)

$_POST

Array( ) Array(

)

$_COOKIE

Array( ) Array(

)

$_SERVER

Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
LD_LIBRARY_PATH => /usr/local/lib:/usr/lib64/:/opt/rh/rh-python36/root/usr/lib64/:/opt/remi/php56/root/usr/lib64,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /tags/cyclicloads,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/tags/cyclicloads,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /tags/cyclicloads,
SCRIPT_URI => https://datacenterhub.org/tags/cyclicloads,
HTTPS => on,
SSL_TLS_SNI => datacenterhub.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => datacenterhub.org,
HTTP_CONNECTION => Keep-Alive,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache,
SERVER_NAME => datacenterhub.org,
SERVER_ADDR => 10.111.11.100,
SERVER_PORT => 443,
REMOTE_ADDR => 3.231.25.104,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 47810,
REDIRECT_URL => /tags/cyclicloads,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /tags/cyclicloads,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1596600719.4865,
REQUEST_TIME => 1596600719,
argv => Array(

)
,
argc => 0
)

• site 0.046 seconds (+0.046); 12.25 MB (+12.250) - afterInitialise
• site 0.066 seconds (+0.020); 13.50 MB (+1.250) - afterRoute
• site 0.253 seconds (+0.187); 21.75 MB (+8.250) - afterDispatch
• site 0.262 seconds (+0.008); 22.25 MB (+0.500) - beforeRenderModule mod_custom (Footer: info and navigation)
• site 0.263 seconds (+0.002); 22.25 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
• site 0.263 seconds (+0.000); 22.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
• site 0.279 seconds (+0.016); 22.50 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
• site 0.284 seconds (+0.004); 22.75 MB (+0.250) - onAfterRender
• site 0.286 seconds (+0.002); 22.75 MB (0.000) - sessionStore

1. SELECT data
  FROM `jos_session`
  WHERE `session_id` = '46d0ddc9800565c251516dfa31048f61'
2. DELETE
  FROM `jos_session`
  WHERE `session_id` = '46d0ddc9800565c251516dfa31048f61'
3. SELECT data
  FROM `jos_session`
  WHERE `session_id` = '28a9c96b3ad5c7f4f7da97ba3a05e884'
4. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
5. SELECT session_id
  FROM `jos_session`
  WHERE `session_id` = '28a9c96b3ad5c7f4f7da97ba3a05e884'
  LIMIT 1
6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
  VALUES ('28a9c96b3ad5c7f4f7da97ba3a05e884','0','1596600719','3.231.25.104')
7. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_members'
8. SELECT b.id
  FROM `jos_usergroups` AS `a`
  LEFT JOIN jos_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE `a`.`id` = '1'
9. SELECT *
  FROM `jos_viewlevels`
10. SELECT folder AS type,element AS name,protected,params
  FROM `jos_extensions`
  WHERE `enabled` >= '1'
  AND `type` = 'plugin'
  AND `state` >= '0'
  AND `access` IN ('1','1','4')
  ORDER BY `ordering` ASC
11. 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 `jos_menu` AS `m`
  LEFT JOIN jos_extensions AS e
  ON e.extension_id = m.component_id
  WHERE `m`.`published` = '1'
  AND `m`.`parent_id` > '0'
  AND `m`.`client_id` = '0'
  ORDER BY `m`.`lft` ASC
12. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_tags'
13. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
  FROM `jos_template_styles`
  INNER JOIN jos_extensions
  ON jos_extensions.element = jos_template_styles.template
  WHERE `jos_template_styles`.`client_id` = '0'
  AND `jos_extensions`.`enabled` = '1'
  AND `jos_extensions`.`type` = 'template'
  AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
  ORDER BY `home` DESC
14. SELECT *
  FROM `jos_tags`
  WHERE `jos_tags`.`tag` = 'cyclicloads'
15. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_resources'
16. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_publications'
17. SELECT *
  FROM `jos_resource_types`
  WHERE `jos_resource_types`.`category` = '27'
  ORDER BY `type` ASC
18. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
  FROM jos_xgroups AS g, jos_xgroups_applicants AS m
  WHERE m.gidNumber=g.gidNumber
  AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
  FROM jos_xgroups AS g, jos_xgroups_members AS m
  WHERE m.gidNumber=g.gidNumber
  AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
  FROM jos_xgroups AS g, jos_xgroups_managers AS m
  WHERE m.gidNumber=g.gidNumber
  AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
  FROM jos_xgroups AS g, jos_xgroups_invitees AS m
  WHERE m.gidNumber=g.gidNumber
  AND m.uidNumber=0 )
19. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=68
  GROUP BY r.id
  HAVING uniques=1 ) AS f
20. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=76
  GROUP BY r.id
  HAVING uniques=1 ) AS f
21. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=73
  GROUP BY r.id
  HAVING uniques=1 ) AS f
22. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=6
  GROUP BY r.id
  HAVING uniques=1 ) AS f
23. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=72
  GROUP BY r.id
  HAVING uniques=1 ) AS f
24. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=9
  GROUP BY r.id
  HAVING uniques=1 ) AS f
25. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=69
  GROUP BY r.id
  HAVING uniques=1 ) AS f
26. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=66
  GROUP BY r.id
  HAVING uniques=1 ) AS f
27. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=67
  GROUP BY r.id
  HAVING uniques=1 ) AS f
28. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=10
  GROUP BY r.id
  HAVING uniques=1 ) AS f
29. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=3
  GROUP BY r.id
  HAVING uniques=1 ) AS f
30. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=1
  GROUP BY r.id
  HAVING uniques=1 ) AS f
31. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=31
  GROUP BY r.id
  HAVING uniques=1 ) AS f
32. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=39
  GROUP BY r.id
  HAVING uniques=1 ) AS f
33. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=7
  GROUP BY r.id
  HAVING uniques=1 ) AS f
34. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=77
  GROUP BY r.id
  HAVING uniques=1 ) AS f
35. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  AND r.type=2
  GROUP BY r.id
  HAVING uniques=1 ) AS f
36. SELECT COUNT(f.id)
  FROM (SELECT v.page_id AS id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_wiki_pages AS w
  INNER JOIN jos_wiki_versions AS v
  ON v.id=w.version_id
  LEFT JOIN `jos_xgroups` xg
  ON xg.gidNumber = w.scope_id
  AND w.scope='
  group'
  LEFT JOIN `jos_projects` xp
  ON xp.id = w.scope_id
  AND w.scope='project', jos_tags_object AS t
  WHERE w.id=v.page_id
  AND v.approved=1
  AND w.state < 2
  AND (xg.gidNumber IS NULL OR (xg.plugins LIKE '%wiki=anyone%'))
  AND w.id=t.objectid
  AND t.tbl='wiki'
  AND t.tagid IN (101)
  GROUP BY page_id
  HAVING uniques=1 ) AS f
37. SELECT COUNT(f.id)
  FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_users AS a
  LEFT JOIN jos_user_profiles AS b
  ON a.id=b.user_id
  AND b.profile_key='bio', jos_tags_object AS t
  WHERE a.access IN (1,1,4)
  AND a.block=0
  AND a.activation > 0
  AND a.id=t.objectid
  AND t.tbl='xprofiles'
  AND t.tagid IN (101)
  GROUP BY a.id, b.profile_value
  HAVING uniques=1) AS f
38. SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_events AS e, jos_tags_object AS t
  WHERE e.state=1
  AND t.objectid=e.id
  AND t.tbl='events'
  AND t.tagid IN (101)
  GROUP BY e.id
  HAVING uniques=1) AS f
39. SELECT a.rules
  FROM `jos_assets` AS `a`
  WHERE `a`.`id` = '1'
  GROUP BY a.id, a.rules, a.lft
40. SELECT b.rules
  FROM `jos_assets` AS `a`
  LEFT JOIN jos_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE `a`.`name` = 'com_groups'
  GROUP BY b.id, b.rules, b.lft
  ORDER BY `b`.`lft` ASC
41. SELECT COUNT(f.gidNumber)
  FROM (SELECT a.gidNumber, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
  ON m.gidNumber=a.gidNumber
  AND m.uidNumber=0 JOIN jos_tags_object AS t
  WHERE (a.type=1 OR a.type=3)
  AND a.discoverability=0
  AND a.gidNumber=t.objectid
  AND t.tbl='groups'
  AND t.tagid IN (101)
  GROUP BY a.gidNumber
  HAVING uniques=1) AS f
42. SELECT COUNT(f.id)
  FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_answers_questions` AS a, `jos_tags_object` AS t
  WHERE a.id=t.objectid
  AND t.tbl='answers'
  AND t.tagid IN (101)
  AND a.state!=2
  GROUP BY a.id
  HAVING uniques=1) AS f
43. SELECT DISTINCT gidNumber
  FROM `jos_xgroups_members`
  WHERE uidNumber=0
44. SELECT b.rules
  FROM `jos_assets` AS `a`
  LEFT JOIN jos_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE `a`.`name` = 'com_forum'
  GROUP BY b.id, b.rules, b.lft
  ORDER BY `b`.`lft` ASC
45. SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_forum_posts AS e
  LEFT JOIN jos_forum_categories c
  ON c.id = e.category_id
  LEFT JOIN jos_forum_sections s
  ON s.id = c.section_id
  LEFT JOIN jos_xgroups g
  ON g.gidNumber = e.scope_id
  LEFT JOIN jos_tags_object AS t
  ON t.objectid=e.id
  AND t.tbl='forum'
  AND t.tagid IN (101)
  WHERE e.state=1
  AND e.parent=0
  AND e.scope_id IN (0)
  GROUP BY e.id
  HAVING uniques=1) AS f
46. SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
  WHERE e.created_by=u.id
  AND t.objectid=e.id
  AND t.tbl='blog'
  AND t.tagid IN (101)
  AND e.state=1
  AND (e.publish_up IS NULL OR e.publish_up <= '2020-08-05 04:11:59')
  AND (e.publish_down IS NULL OR e.publish_down >= '2020-08-05 04:11:59')
  GROUP BY e.id
  HAVING uniques=1) AS f
47. SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_citations` AS e, `jos_tags_object` AS t
  WHERE t.objectid=e.id
  AND t.tbl='citations'
  AND t.tagid IN (101)
  AND e.published=1
  AND e.id!=''
  GROUP BY e.id
  HAVING uniques=1) AS f
48. SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_kb_articles` AS e
  LEFT JOIN `jos_categories` AS cc
  ON cc.id = e.category
  LEFT JOIN `jos_tags_object` AS t
  ON t.objectid=e.id
  AND t.tbl='kb'
  AND t.tagid IN (101)
  WHERE e.state=1
  AND e.access IN (1,1,4)
  GROUP BY e.id
  HAVING uniques=1) AS f
49. SHOW FULL COLUMNS
  FROM `jos_publication_categories`
50. SELECT *
  FROM jos_publication_categories as C
  WHERE C.state=1
  ORDER BY C.name ASC
51. SHOW FULL COLUMNS
  FROM `jos_publications`
52. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
  FROM jos_xgroups AS g, jos_xgroups_applicants AS m
  WHERE m.gidNumber=g.gidNumber
  AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
  FROM jos_xgroups AS g, jos_xgroups_members AS m
  WHERE m.gidNumber=g.gidNumber
  AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
  FROM jos_xgroups AS g, jos_xgroups_managers AS m
  WHERE m.gidNumber=g.gidNumber
  AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
  FROM jos_xgroups AS g, jos_xgroups_invitees AS m
  WHERE m.gidNumber=g.gidNumber
  AND m.uidNumber=0 )
53. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_publication_versions as V, jos_publications AS r
  LEFT JOIN jos_publication_categories AS rt
  ON r.category=rt.id, jos_tags_object AS t
  WHERE V.publication_id=r.id
  AND V.state=1
  AND V.main = 1
  AND t.objectid=V.id
  AND t.tbl='publications'
  AND t.tagid IN (101)
  AND r.category=1
  GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
  HAVING uniques=1 ) AS f
54. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_publication_versions as V, jos_publications AS r
  LEFT JOIN jos_publication_categories AS rt
  ON r.category=rt.id, jos_tags_object AS t
  WHERE V.publication_id=r.id
  AND V.state=1
  AND V.main = 1
  AND t.objectid=V.id
  AND t.tbl='publications'
  AND t.tagid IN (101)
  AND r.category=3
  GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
  HAVING uniques=1 ) AS f
55. SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_publication_versions as V, jos_publications AS r
  LEFT JOIN jos_publication_categories AS rt
  ON r.category=rt.id, jos_tags_object AS t
  WHERE V.publication_id=r.id
  AND V.state=1
  AND V.main = 1
  AND t.objectid=V.id
  AND t.tbl='publications'
  AND t.tagid IN (101)
  AND r.category=7
  GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
  HAVING uniques=1 ) AS f
56. SELECT COUNT(f.id)
  FROM (SELECT p.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_collections_posts AS p
  INNER JOIN jos_collections AS c
  ON c.id=p.collection_id
  INNER JOIN jos_collections_items AS i
  ON p.item_id=i.id
  INNER JOIN jos_tags_object AS t
  WHERE i.state=1
  AND c.state=1
  AND t.objectid=p.item_id
  AND t.tbl='bulletinboard'
  AND t.tagid IN (101)
  AND i.access=0
  AND c.access=0
  GROUP BY p.id
  HAVING uniques=1) AS f
57. SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
  WHERE e.created_by=u.id
  AND e.state=1
  AND t.objectid=e.id
  AND t.tbl='courses'
  AND t.tagid IN (101)
  AND e.access IN (1,1,4)
  GROUP BY e.id
  HAVING uniques=1) AS f
58. (SELECT DISTINCT r.id, r.title, r.alias, r.introtext AS itext, r.fulltxt AS ftext, r.published AS state, r.created, r.created_by, r.modified, r.publish_up, r.publish_down, CONCAT('index.php?option=com_resources&id=', r.id) AS href, 'resources' AS section , COUNT(DISTINCT t.tagid) AS uniques , r.params, r.rating AS rcount, r.type AS data1, r.access AS data2, r.ranking data3
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
  WHERE r.standalone=1
  AND r.published=1
  AND r.access<4
  AND t.objectid=r.id
  AND t.tbl='resources'
  AND t.tagid IN (101)
  GROUP BY r.id
  HAVING uniques=1
  ORDER BY publish_up DESC) UNION (SELECT v.page_id AS id, w.title, w.pagename AS alias, v.pagetext AS itext, v.pagehtml AS ftext, w.state, v.created, v.created_by, v.created AS modified, v.created AS publish_up, NULL AS publish_down,
  CASE WHEN w.scope = 'project' THEN concat('index.php?option=com_projects&alias=', xp.alias, '&active=notes&pagename=', w.path, '/', w.pagename) WHEN w.scope = '
  group' THEN CONCAT('index.php?option=com_groups&cn=', xg.cn, '&active=wiki&pagename=', w.path, '/', w.pagename) ELSE CONCAT('index.php?option=com_wiki&pagename=', w.pagename) END AS href, 'wiki' AS section , COUNT(DISTINCT t.tagid) AS uniques , w.params, NULL AS rcount, w.scope AS data1, NULL AS data2, NULL AS data3
  FROM jos_wiki_pages AS w
  INNER JOIN jos_wiki_versions AS v
  ON v.id=w.version_id
  LEFT JOIN `jos_xgroups` xg
  ON xg.gidNumber = w.scope_id
  AND w.scope='
  group'
  LEFT JOIN `jos_projects` xp
  ON xp.id = w.scope_id
  AND w.scope='project', jos_tags_object AS t
  WHERE w.id=v.page_id
  AND v.approved=1
  AND w.state < 2
  AND (xg.gidNumber IS NULL OR (xg.plugins LIKE '%wiki=anyone%'))
  AND w.id=t.objectid
  AND t.tbl='wiki'
  AND t.tagid IN (101)
  GROUP BY page_id
  HAVING uniques=1
  ORDER BY created DESC) UNION (SELECT a.id, a.name AS title, a.username as alias, NULL AS itext, b.profile_value AS ftext, a.activation AS state, a.registerDate AS created, a.id AS created_by, NULL AS modified, a.registerDate AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_members&id=', a.id) AS href, 'members' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
  FROM jos_users AS a
  LEFT JOIN jos_user_profiles AS b
  ON a.id=b.user_id
  AND b.profile_key='bio', jos_tags_object AS t
  WHERE a.access IN (1,1,4)
  AND a.block=0
  AND a.activation > 0
  AND a.id=t.objectid
  AND t.tbl='xprofiles'
  AND t.tagid IN (101)
  GROUP BY a.id, b.profile_value
  HAVING uniques=1) UNION (SELECT e.id, e.title, NULL AS alias, NULL AS itext, e.content AS ftext, e.state, e.created, e.created_by, NULL AS modified, e.publish_up, e.publish_down, CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href, 'events' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
  FROM jos_events AS e, jos_tags_object AS t
  WHERE e.state=1
  AND t.objectid=e.id
  AND t.tbl='events'
  AND t.tagid IN (101)
  GROUP BY e.id
  HAVING uniques=1) UNION (SELECT a.gidNumber AS id, a.description AS title, a.cn AS alias, NULL AS itext, a.public_desc AS ftext, a.type AS state, a.created, a.created_by, NULL AS modified, NULL AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_groups&cn=', a.cn) AS href, 'groups' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.params, NULL AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
  FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
  ON m.gidNumber=a.gidNumber
  AND m.uidNumber=0 JOIN jos_tags_object AS t
  WHERE (a.type=1 OR a.type=3)
  AND a.discoverability=0
  AND a.gidNumber=t.objectid
  AND t.tbl='groups'
  AND t.tagid IN (101)
  GROUP BY a.gidNumber
  HAVING uniques=1) UNION (SELECT a.id, a.subject AS title, NULL AS alias, NULL AS itext, a.question AS ftext, a.state, a.created, a.created_by, NULL AS modified, a.created AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_answers&task=question&id=', a.id) AS href, 'answers' AS section, COUNT(DISTINCT t.tagid) AS uniques, a.anonymous AS params, (SELECT COUNT(*)
  FROM `jos_answers_responses` AS r
  WHERE r.question_id=a.id) AS rcount, NULL AS data1, NULL AS data2, NULL AS data3
  FROM `jos_answers_questions` AS a, `jos_tags_object` AS t
  WHERE a.id=t.objectid
  AND t.tbl='answers'
  AND t.tagid IN (101)
  AND a.state!=2
  GROUP BY a.id
  HAVING uniques=1) UNION (SELECT e.id, e.title, e.id AS alias, e.comment AS itext, e.comment AS ftext, e.state, e.created, e.created_by, e.modified, e.created AS publish_up, NULL AS publish_down, (
  CASE WHEN e.scope_id > 0
  AND e.scope='
  group' THEN concat('/groups/', g.cn, concat('/forum/', coalesce(concat(s.alias, '/', coalesce(concat(c.alias, '/'), ''))),
  CASE WHEN e.parent > 0 THEN e.parent ELSE e.id END)) ELSE concat('/forum/', coalesce(concat(s.alias, '/', coalesce(concat(c.alias, '/'), ''))),
  CASE WHEN e.parent > 0 THEN e.parent ELSE e.id END) END) AS href, 'forum' AS section, COUNT(DISTINCT t.tagid) AS uniques, CONCAT(e.thread, ':', e.parent) AS params, e.scope AS rcount, c.alias AS data1, s.alias AS data2, e.scope_id AS data3
  FROM jos_forum_posts AS e
  LEFT JOIN jos_forum_categories c
  ON c.id = e.category_id
  LEFT JOIN jos_forum_sections s
  ON s.id = c.section_id
  LEFT JOIN jos_xgroups g
  ON g.gidNumber = e.scope_id
  LEFT JOIN jos_tags_object AS t
  ON t.objectid=e.id
  AND t.tbl='forum'
  AND t.tagid IN (101)
  WHERE e.state=1
  AND e.parent=0
  AND e.scope_id IN (0)
  GROUP BY e.id
  HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, NULL AS itext, e.content AS ftext, e.state, e.created, e.created_by, NULL AS modified, e.publish_up, e.publish_down, CONCAT('index.php?option=com_blog&task=view&id=', e.id) AS href, 'blogs' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, e.scope AS rcount, u.name AS data1, e.scope_id AS data2, NULL AS data3
  FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
  WHERE e.created_by=u.id
  AND t.objectid=e.id
  AND t.tbl='blog'
  AND t.tagid IN (101)
  AND e.state=1
  AND (e.publish_up IS NULL OR e.publish_up <= '2020-08-05 04:11:59')
  AND (e.publish_down IS NULL OR e.publish_down >= '2020-08-05 04:11:59')
  GROUP BY e.id
  HAVING uniques=1) UNION (SELECT e.id, e.title, e.author, e.booktitle, e.doi, e.published, e.created, e.year, e.month, e.isbn, e.journal, e.url as href, 'citations' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.volume, e.number, e.type, e.pages, e.publisher
  FROM `jos_citations` AS e, `jos_tags_object` AS t
  WHERE t.objectid=e.id
  AND t.tbl='citations'
  AND t.tagid IN (101)
  AND e.published=1
  AND e.id!=''
  GROUP BY e.id
  HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, e.fulltxt AS itext, e.fulltxt AS ftext, e.state, e.created, e.created_by, e.modified, e.created AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_kb&category=&alias=', e.alias) AS href, 'kb' AS section, COUNT(DISTINCT t.tagid) AS uniques, NULL AS params, e.helpful AS rcount, cc.alias AS data1, NULL AS data2, NULL AS data3
  FROM `jos_kb_articles` AS e
  LEFT JOIN `jos_categories` AS cc
  ON cc.id = e.category
  LEFT JOIN `jos_tags_object` AS t
  ON t.objectid=e.id
  AND t.tbl='kb'
  AND t.tagid IN (101)
  WHERE e.state=1
  AND e.access IN (1,1,4)
  GROUP BY e.id
  HAVING uniques=1) UNION (SELECT DISTINCT r.id, V.title, V.version_number as alias, V.abstract as itext, V.id as ftext, V.state AS state, V.created, V.created_by, V.modified, V.published_up as publish_up, V.published_down as publish_down, CONCAT('index.php?option=com_publications&id=', r.id) AS href, 'publications' AS section , COUNT(DISTINCT t.tagid) AS uniques , V.params, r.rating AS rcount, r.category AS data1, rt.name AS data2, r.ranking data3
  FROM jos_publication_versions as V, jos_publications AS r
  LEFT JOIN jos_publication_categories AS rt
  ON r.category=rt.id, jos_tags_object AS t
  WHERE V.publication_id=r.id
  AND V.state=1
  AND V.main = 1
  AND t.objectid=V.id
  AND t.tbl='publications'
  AND t.tagid IN (101)
  GROUP BY r.id, V.id, V.version_number, V.title, V.abstract
  HAVING uniques=1
  ORDER BY publish_up DESC) UNION (SELECT p.id, i.title, c.alias, NULL AS itext,
  CASE WHEN (p.description!=''
  AND p.description IS NOT NULL) THEN p.description ELSE i.description END AS ftext, i.state, p.created, p.created_by, NULL AS modified, p.created AS publish_up, NULL AS publish_down, concat('index.php?option=com_collections&controller=posts&post=', p.id) AS href, 'collections' AS section, COUNT(DISTINCT t.tagid) AS uniques, c.object_type AS params, c.object_id AS rcount, i.type AS data1, i.object_id AS data2, NULL AS data3
  FROM jos_collections_posts AS p
  INNER JOIN jos_collections AS c
  ON c.id=p.collection_id
  INNER JOIN jos_collections_items AS i
  ON p.item_id=i.id
  INNER JOIN jos_tags_object AS t
  WHERE i.state=1
  AND c.state=1
  AND t.objectid=p.item_id
  AND t.tbl='bulletinboard'
  AND t.tagid IN (101)
  AND i.access=0
  AND c.access=0
  GROUP BY p.id
  HAVING uniques=1) UNION (SELECT e.id, e.title, e.alias, e.blurb AS itext, e.description AS ftext, e.state, e.created, e.created_by, NULL AS modified, NULL AS publish_up, NULL AS publish_down, CONCAT('index.php?option=com_courses&gid=', e.alias) AS href, 'courses' AS section, COUNT(DISTINCT t.tagid) AS uniques, e.params, 0 AS rcount, u.name AS data1, NULL AS data2, NULL AS data3
  FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
  WHERE e.created_by=u.id
  AND e.state=1
  AND t.objectid=e.id
  AND t.tbl='courses'
  AND t.tagid IN (101)
  AND e.access IN (1,1,4)
  GROUP BY e.id
  HAVING uniques=1)
  ORDER BY publish_up DESC, title
  LIMIT 0,20
59. SELECT *
  FROM `jos_resource_types`
  WHERE `jos_resource_types`.`id` = NULL
60. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_tools'
61. SELECT *
  FROM `jos_author_assoc`
  WHERE `jos_author_assoc`.`subid` = '14610'
  AND `jos_author_assoc`.`subtable` = 'resources'
  ORDER BY `ordering` ASC
62. SELECT *
  FROM `jos_author_assoc`
  WHERE `jos_author_assoc`.`subid` = '14610'
  AND `jos_author_assoc`.`subtable` = 'resources'
63. SELECT *
  FROM `jos_author_assoc`
  WHERE `jos_author_assoc`.`subid` = '128'
  AND `jos_author_assoc`.`subtable` = 'resources'
  ORDER BY `ordering` ASC
64. SELECT *
  FROM `jos_author_assoc`
  WHERE `jos_author_assoc`.`subid` = '128'
  AND `jos_author_assoc`.`subtable` = 'resources'
65. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_users'
66. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
  FROM `jos_modules` AS `m`
  LEFT JOIN jos_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jos_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` IS NULL OR `m`.`publish_up` <= '2020-08-05 04:11:59' )
  AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-08-05 04:11:59' )
  AND `m`.`access` IN ('1','1','4')
  AND `m`.`client_id` = '0'
  AND (`mm`.`menuid` = '89' OR `mm`.`menuid` <= '0' )
  ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
67. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_content'
68. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_categories'
69. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_usage'
70. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_groups'
71. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_feedback'
72. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_support'
73. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_wishlist'
74. UPDATE `jos_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1596600719;s:18:\"session.timer.last\";i:1596600719;s:17:\"session.timer.now\";i:1596600719;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":2:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"28a9c96b3ad5c7f4f7da97ba3a05e884\";s:12:\"tracker.ssid\";s:32:\"28a9c96b3ad5c7f4f7da97ba3a05e884\";s:12:\"tracker.rsid\";s:32:\"28a9c96b3ad5c7f4f7da97ba3a05e884\";}',`time` = '1596600719',`ip` = '3.231.25.104'
  WHERE `session_id` = '28a9c96b3ad5c7f4f7da97ba3a05e884'

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 17 × SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
2. 14 × SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
3. 4 × SELECT *
  FROM `jos_author_assoc`
4. 3 × SELECT count(f.id)
  FROM (SELECT r.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_publication_versions as V, jos_publications AS r
  LEFT JOIN jos_publication_categories AS rt
  ON r.category=rt.id, jos_tags_object AS t
5. 2 × SELECT *
  FROM `jos_resource_types`
6. 2 × SELECT data
  FROM `jos_session`
7. 2 × SELECT b.rules
  FROM `jos_assets` AS `a`
  LEFT JOIN jos_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
8. 1 × SELECT DISTINCT gidNumber
  FROM `jos_xgroups_members`
9. 1 × SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_blog_entries AS e, jos_tags_object AS t, jos_users AS u
10. 1 × SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_forum_posts AS e
  LEFT JOIN jos_forum_categories c
  ON c.id = e.category_id
  LEFT JOIN jos_forum_sections s
  ON s.id = c.section_id
  LEFT JOIN jos_xgroups g
  ON g.gidNumber = e.scope_id
  LEFT JOIN jos_tags_object AS t
  ON t.objectid=e.id
  AND t.tbl='forum'
  AND t.tagid IN (101)
11. 1 × SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_citations` AS e, `jos_tags_object` AS t
12. 1 × SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_kb_articles` AS e
  LEFT JOIN `jos_categories` AS cc
  ON cc.id = e.category
  LEFT JOIN `jos_tags_object` AS t
  ON t.objectid=e.id
  AND t.tbl='kb'
  AND t.tagid IN (101)
13. 1 × SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
  FROM `jos_modules` AS `m`
  LEFT JOIN jos_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jos_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
14. 1 × SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_courses` AS e, `jos_tags_object` AS t, `jos_users` AS u
15. 1 × SELECT COUNT(f.id)
  FROM (SELECT p.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_collections_posts AS p
  INNER JOIN jos_collections AS c
  ON c.id=p.collection_id
  INNER JOIN jos_collections_items AS i
  ON p.item_id=i.id
  INNER JOIN jos_tags_object AS t
16. 1 × SELECT *
  FROM jos_publication_categories as C
17. 1 × SELECT COUNT(f.id)
  FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM `jos_answers_questions` AS a, `jos_tags_object` AS t
18. 1 × SELECT a.rules
  FROM `jos_assets` AS `a`
19. 1 × SELECT folder AS type,element AS name,protected,params
  FROM `jos_extensions`
20. 1 × SELECT *
  FROM `jos_viewlevels
21. 1 × SELECT b.id
  FROM `jos_usergroups` AS `a`
  LEFT JOIN jos_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
22. 1 × SELECT session_id
  FROM `jos_session`
23. 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 `jos_menu` AS `m`
  LEFT JOIN jos_extensions AS e
  ON e.extension_id = m.component_id
24. 1 × SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
  FROM `jos_template_styles`
  INNER JOIN jos_extensions
  ON jos_extensions.element = jos_template_styles.template
25. 1 × SELECT COUNT(f.id)
  FROM (SELECT e.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_events AS e, jos_tags_object AS t
26. 1 × SELECT COUNT(f.id)
  FROM (SELECT a.id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_users AS a
  LEFT JOIN jos_user_profiles AS b
  ON a.id=b.user_id
  AND b.profile_key='bio', jos_tags_object AS t
27. 1 × SELECT COUNT(f.id)
  FROM (SELECT v.page_id AS id, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_wiki_pages AS w
  INNER JOIN jos_wiki_versions AS v
  ON v.id=w.version_id
  LEFT JOIN `jos_xgroups` xg
  ON xg.gidNumber = w.scope_id
  AND w.scope='
  group'
  LEFT JOIN `jos_projects` xp
  ON xp.id = w.scope_id
  AND w.scope='project', jos_tags_object AS t
28. 1 × SELECT *
  FROM `jos_tags`
29. 1 × SELECT COUNT(f.gidNumber)
  FROM (SELECT a.gidNumber, COUNT(DISTINCT t.tagid) AS uniques
  FROM jos_xgroups AS a JOIN jos_xgroups_members AS m
  ON m.gidNumber=a.gidNumber
  AND m.uidNumber=0 JOIN jos_tags_object AS t

OTHER Tables:

1. 2 × ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
  FROM jos_xgroups AS g, jos_xgroups_applicants AS m
2. 1 × (SELECT DISTINCT r.id, r.title, r.alias, r.introtext AS itext, r.fulltxt AS ftext, r.published AS state, r.created, r.created_by, r.modified, r.publish_up, r.publish_down, CONCAT('index.php?option=com_resources&id=', r.id) AS href, 'resources' AS section , COUNT(DISTINCT t.tagid) AS uniques , r.params, r.rating AS rcount, r.type AS data1, r.access AS data2, r.ranking data3
  FROM `jos_resources` AS r
  LEFT JOIN jos_resource_types AS rt
  ON r.type=rt.id , `jos_tags_object` AS t
3. 1 × UPDATE `jos_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1596600719;s:18:\"session.timer.last\";i:1596600719;s:17:\"session.timer.now\";i:1596600719;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":2:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"28a9c96b3ad5c7f4f7da97ba3a05e884\";s:12:\"tracker.ssid\";s:32:\"28a9c96b3ad5c7f4f7da97ba3a05e884\";s:12:\"tracker.rsid\";s:32:\"28a9c96b3ad5c7f4f7da97ba3a05e884\";}',`time` = '1596600719',`ip` = '3.231.25.104'
4. 1 × SHOW FULL COLUMNS
  FROM `jos_publications
5. 1 × SHOW FULL COLUMNS
  FROM `jos_publication_categories
6. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
  VALUES ('28a9c96b3ad5c7f4f7da97ba3a05e884','0','1596600719','3.231.25.104'
7. 1 × DELETE
  FROM `jos_session`

• onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:21
• onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:20
• onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:21
• onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:21
• onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:113
• onAfterInitialise — Method — plgSystemReferrerpolicy::onAfterInitialise → /core/plugins/system/referrerpolicy/referrerpolicy.php:21
• onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:21
• onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:21
• onAfterRoute — Method — plgSystemPassword::onAfterRoute → /core/plugins/system/password/password.php:21
• onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:21
• onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:21
• onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:21
• onTagView — Method — plgTagsResources::onTagView → /core/plugins/tags/resources/resources.php:47
• onTagView — Method — plgTagsWiki::onTagView → /core/plugins/tags/wiki/wiki.php:33
• onTagView — Method — plgTagsMembers::onTagView → /core/plugins/tags/members/members.php:33
• onTagView — Method — plgTagsEvents::onTagView → /core/plugins/tags/events/events.php:33
• onTagView — Method — plgTagsGroups::onTagView → /core/plugins/tags/groups/groups.php:33
• onTagView — Method — plgTagsAnswers::onTagView → /core/plugins/tags/answers/answers.php:33
• onTagView — Method — plgTagsForum::onTagView → /core/plugins/tags/forum/forum.php:48
• onTagView — Method — plgTagsBlogs::onTagView → /core/plugins/tags/blogs/blogs.php:33
• onTagView — Method — plgTagsCitations::onTagView → /core/plugins/tags/citations/citations.php:33
• onTagView — Method — plgTagsKb::onTagView → /core/plugins/tags/kb/kb.php:33
• onTagView — Method — plgTagsPublications::onTagView → /core/plugins/tags/publications/publications.php:48
• onTagView — Method — plgTagsCollections::onTagView → /core/plugins/tags/collections/collections.php:33
• onTagView — Method — plgTagsCourses::onTagView → /core/plugins/tags/courses/courses.php:33
• onGetMultiEntry — Method — plgHubzeroAutocompleter::onGetMultiEntry → /core/plugins/hubzero/autocompleter/autocompleter.php:139
• onResourcesList — Method — plgResourcesCoins::onResourcesList → /core/plugins/resources/coins/coins.php:57
• onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:60
• onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:25
• onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:21