36 Queries Logged

1. SELECT `data`
  FROM `wr9jf_session`
  WHERE `session_id` = 'bdvhu95rtmnvvbqae79lmhl9n7'
2. DELETE
  FROM `wr9jf_session`
  WHERE `time` < '1603541833'
3. SELECT `session_id`
  FROM `wr9jf_session`
  WHERE `session_id` = 'bdvhu95rtmnvvbqae79lmhl9n7'
  LIMIT 0, 1
4. INSERT INTO `wr9jf_session` (`session_id`, `client_id`, `time`)
  VALUES ('bdvhu95rtmnvvbqae79lmhl9n7', 0, '1603542733')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wr9jf_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM wr9jf_usergroups AS a
  LEFT JOIN wr9jf_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `wr9jf_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM wr9jf_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wr9jf_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wr9jf_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_chameleon'
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 wr9jf_menu AS m
  LEFT JOIN wr9jf_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
12. SELECT *
  FROM wr9jf_languages
  WHERE published=1
  ORDER BY ordering ASC
13. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wr9jf_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_menus'
14. SELECT r.*
  FROM wr9jf_chameleon_rule AS r
  WHERE r.published = 1
  ORDER BY r.ordering
15. 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 `wr9jf_content` a
  LEFT JOIN `wr9jf_categories` cat1
  ON a.catid = cat1.id
  LEFT JOIN `wr9jf_categories` cat2
  ON cat1.parent_id = cat2.id
  LEFT JOIN `wr9jf_categories` cat3
  ON cat2.parent_id = cat3.id
  LEFT JOIN `wr9jf_categories` cat4
  ON cat3.parent_id = cat4.id
  LEFT JOIN `wr9jf_categories` cat5
  ON cat4.parent_id = cat5.id
  LEFT JOIN `wr9jf_categories` cat6
  ON cat5.parent_id = cat6.id
  LEFT JOIN `wr9jf_categories` cat7
  ON cat6.parent_id = cat7.id
  LEFT JOIN `wr9jf_categories` cat8
  ON cat7.parent_id = cat8.id
  WHERE a.id = '15'
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  LIMIT 0, 1
16. SELECT template, params
  FROM wr9jf_template_styles
  WHERE client_id = 0
  AND id = 7
17. SHOW FULL COLUMNS
  FROM `wr9jf_content`
18. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wr9jf_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
19. SELECT a.rules
  FROM wr9jf_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
20. SELECT b.rules
  FROM wr9jf_assets AS a
  LEFT JOIN wr9jf_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
21. 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,contact.id 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 wr9jf_content AS a
  LEFT JOIN wr9jf_categories AS c
  on c.id = a.catid
  LEFT JOIN wr9jf_users AS u
  on u.id = a.created_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM wr9jf_contact_details AS contact
  WHERE contact.published = 1
  GROUP BY contact.user_id, contact.language) AS contact
  ON contact.user_id = a.created_by
  LEFT JOIN wr9jf_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN wr9jf_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM wr9jf_categories AS cat JOIN wr9jf_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 = 15
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13')
  AND (a.state = 1 OR a.state =2)
22. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM wr9jf_categories as c
  LEFT JOIN wr9jf_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 wr9jf_categories AS cat JOIN wr9jf_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=9
  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
23. UPDATE wr9jf_content
  SET hits = hits + 1
  WHERE id = 15
24. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM wr9jf_modules AS m
  LEFT JOIN wr9jf_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN wr9jf_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 <= '2020-10-24 12:32:13')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-10-24 12:32:13')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 101 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
25. SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
  WHERE (a.title = 'Home Desktop' OR a.alias = 'Home Desktop')
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  AND a.access IN(1, 1)
  ORDER BY a.ordering
26. SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
  WHERE (a.title = 'Leasing' OR a.alias = 'Leasing')
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  AND a.access IN(1, 1)
  ORDER BY a.ordering
27. SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
  WHERE (a.title = 'Bare Rental' OR a.alias = 'Bare Rental')
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  AND a.access IN(1, 1)
  ORDER BY a.ordering
28. SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
  WHERE (a.title = 'Sale & Lease back' OR a.alias = 'Sale & Lease back')
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  AND a.access IN(1, 1)
  ORDER BY a.ordering
29. SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
  WHERE (a.title = 'Buying & selling' OR a.alias = 'Buying & selling')
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  AND a.access IN(1, 1)
  ORDER BY a.ordering
30. SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
  WHERE (a.title = 'Valuations' OR a.alias = 'Valuations')
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  AND a.access IN(1, 1)
  ORDER BY a.ordering
31. SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
  WHERE (a.title = 'Consulting' OR a.alias = 'Consulting')
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  AND a.access IN(1, 1)
  ORDER BY a.ordering
32. SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
  WHERE (a.title = 'Shipping Services' OR a.alias = 'Shipping Services')
  AND a.state = 1
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-24 12:32:13' )
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-24 12:32:13' )
  AND a.access IN(1, 1)
  ORDER BY a.ordering
33. SELECT m.*
  FROM wr9jf_menu AS m
  WHERE menutype='hoofdmenu'
  AND published = 1
  AND access IN (1,1)
  AND parent_id = (SELECT id
  FROM wr9jf_menu
  WHERE alias = 'root')
  ORDER BY lft
34. SHOW FULL COLUMNS
  FROM `wr9jf_jnews_xonfig`
35. SELECT *
  FROM `wr9jf_jnews_xonfig`
36. UPDATE `wr9jf_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1603542733;s:18:\"session.timer.last\";i:1603542733;s:17:\"session.timer.now\";i:1603542733;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\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:8:\"usertype\";N;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:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}jomgenius_categorizr|s:7:\"desktop\";' , `time` = '1603542733'
  WHERE `session_id` = 'bdvhu95rtmnvvbqae79lmhl9n7'

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 8 × SELECT a.`id`, a.`asset_id`, a.`title`, a.`alias`, a.`title_alias`, a.`state`, a.`sectionid`, a.`mask`, a.`catid`, a.`created`, a.`created_by`, a.`created_by_alias`, a.`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`, a.`introtext`, a.`fulltext`,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS catslug
  FROM wr9jf_content as a
  LEFT JOIN wr9jf_categories AS c
  ON c.id = a.catid
2. 5 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM wr9jf_extensions
3. 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,contact.id 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 wr9jf_content AS a
  LEFT JOIN wr9jf_categories AS c
  on c.id = a.catid
  LEFT JOIN wr9jf_users AS u
  on u.id = a.created_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM wr9jf_contact_details AS contact
4. 1 × SELECT b.rules
  FROM wr9jf_assets AS a
  LEFT JOIN wr9jf_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
5. 1 × SELECT a.rules
  FROM wr9jf_assets AS a
6. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM wr9jf_categories as c
  LEFT JOIN wr9jf_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 wr9jf_categories AS cat JOIN wr9jf_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM wr9jf_modules AS m
  LEFT JOIN wr9jf_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN wr9jf_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
8. 1 × SELECT m.*
  FROM wr9jf_menu AS m
9. 1 × SELECT template, params
  FROM wr9jf_template_styles
10. 1 × SELECT *
  FROM `wr9jf_jnews_xonfig
11. 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 `wr9jf_content` a
  LEFT JOIN `wr9jf_categories` cat1
  ON a.catid = cat1.id
  LEFT JOIN `wr9jf_categories` cat2
  ON cat1.parent_id = cat2.id
  LEFT JOIN `wr9jf_categories` cat3
  ON cat2.parent_id = cat3.id
  LEFT JOIN `wr9jf_categories` cat4
  ON cat3.parent_id = cat4.id
  LEFT JOIN `wr9jf_categories` cat5
  ON cat4.parent_id = cat5.id
  LEFT JOIN `wr9jf_categories` cat6
  ON cat5.parent_id = cat6.id
  LEFT JOIN `wr9jf_categories` cat7
  ON cat6.parent_id = cat7.id
  LEFT JOIN `wr9jf_categories` cat8
  ON cat7.parent_id = cat8.id
12. 1 × SELECT id, rules
  FROM `wr9jf_viewlevels
13. 1 × SELECT b.id
  FROM wr9jf_usergroups AS a
  LEFT JOIN wr9jf_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
14. 1 × SELECT `session_id`
  FROM `wr9jf_session`
15. 1 × SELECT folder AS type, element AS name, params
  FROM wr9jf_extensions
16. 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 wr9jf_menu AS m
  LEFT JOIN wr9jf_extensions AS e
  ON m.component_id = e.extension_id
17. 1 × SELECT r.*
  FROM wr9jf_chameleon_rule AS r
18. 1 × SELECT *
  FROM wr9jf_languages
19. 1 × SELECT `data`
  FROM `wr9jf_session`

OTHER Tables:

1. 1 × SHOW FULL COLUMNS
  FROM `wr9jf_jnews_xonfig
2. 1 × UPDATE `wr9jf_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1603542733;s:18:\"session.timer.last\";i:1603542733;s:17:\"session.timer.now\";i:1603542733;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\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:8:\"usertype\";N;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:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}jomgenius_categorizr|s:7:\"desktop\";' , `time` = '1603542733'
3. 1 × UPDATE wr9jf_content
  SET hits = hits + 1
4. 1 × SHOW FULL COLUMNS
  FROM `wr9jf_content
5. 1 × INSERT INTO `wr9jf_session` (`session_id`, `client_id`, `time`)
  VALUES ('bdvhu95rtmnvvbqae79lmhl9n7', 0, '1603542733'
6. 1 × DELETE
  FROM `wr9jf_session`