**Joomla! Debug Console**

**124 Queries Logged**

1. SELECT `data`
  FROM `chall_session`
  WHERE `session_id` = '0ab21f3118b95dd60a01c33875c51b1c'
2. SELECT `session_id`
  FROM `chall_session`
  WHERE `session_id` = '0ab21f3118b95dd60a01c33875c51b1c'
  LIMIT 0, 1
3. INSERT INTO `chall_session` (`session_id`, `client_id`, `time`)
  VALUES ('0ab21f3118b95dd60a01c33875c51b1c', 0, '1524220002')
4. SELECT b.id
  FROM chall_usergroups AS a
  LEFT JOIN chall_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
5. SELECT id, rules
  FROM `chall_viewlevels`
6. SELECT template
  FROM chall_template_styles as s
  WHERE s.client_id = 0
  AND s.home = 1
7. SELECT template
  FROM chall_template_styles as s
  WHERE s.client_id = 0
  AND s.home = 1
8. SELECT extension, file, type
  FROM chall_rokcommon_configs
  ORDER BY priority
9. SHOW FULL COLUMNS
  FROM `chall_extensions`
10. SELECT `extension_id`
  FROM `chall_extensions`
  WHERE type = 'component'
  AND element = 'com_roksprocket'
11. SELECT *
  FROM chall_extensions
  WHERE `extension_id` = '10036'
12. SELECT `extension_id`
  FROM `chall_extensions`
  WHERE type = 'module'
  AND element = 'mod_roksprocket'
13. SELECT *
  FROM chall_extensions
  WHERE `extension_id` = '10036'
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 chall_menu AS m
  LEFT JOIN chall_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 a.rules
  FROM chall_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
16. SELECT b.rules
  FROM chall_assets AS a
  LEFT JOIN chall_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_k2')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
17. SELECT id
  FROM chall_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
18. SELECT *
  FROM chall_k2_items
  WHERE id=42
  LIMIT 0, 1
19. SHOW FULL COLUMNS
  FROM `chall_k2_categories`
20. SELECT *
  FROM chall_k2_categories
  WHERE id = '3'
21. SELECT id, name, parent
  FROM chall_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
  ORDER BY parent
22. SELECT *
  FROM chall_k2_categories
  WHERE id = '19'
23. SELECT `name`, `value`
  FROM `chall_jsn_imageshow_config`
  WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')
24. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
25. SHOW FULL COLUMNS
  FROM `chall_k2_items`
26. UPDATE chall_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '42'
27. SELECT params
  FROM chall_extensions AS e
  WHERE e.element='com_widgetkit'
28. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM chall_modules AS m
  LEFT JOIN chall_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN chall_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 <= '2018-04-20 10:26:43')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-20 10:26:43')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 239 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
29. SELECT ts.template
  FROM chall_template_styles AS ts
  INNER JOIN chall_menu AS m
  ON ts.id=m.template_style_id
  WHERE m.id = 239
  AND m.template_style_id != 0
30. SELECT template
  FROM chall_template_styles
  WHERE home = 1
  AND client_id = 0
31. SELECT *
  FROM chall_acymailing_config
32. SELECT *
  FROM chall_acymailing_list
  WHERE type = 'list'
  ORDER BY ordering ASC
33. SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM chall_k2_categories AS c
  LEFT JOIN chall_k2_items AS content
  ON c.id = content.catid
  WHERE ( c.id = 21 )
  AND c.published = 1
  AND c.access <= 1;
34. SELECT DISTINCT cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.id AS ID, content.alias AS alias, content.hits AS hits, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, content.plugins AS plugins
  FROM chall_k2_items AS content
  LEFT JOIN chall_k2_categories AS cats
  ON cats.id = content.catid
  LEFT JOIN chall_users AS users
  ON users.id = content.created_by
  LEFT JOIN chall_k2_rating AS content_rating
  ON content.id = content_rating.itemID
  WHERE content.trash = 0
  AND cats.access <= 1
  AND content.access <= 1
  AND content.published = 1
  AND cats.published = 1
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2018-04-20 10:26:43' )
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2018-04-20 10:26:43' )
  AND ( content.catid = 21 )
  ORDER BY RAND()
  LIMIT 0,10;
35. SELECT content.id AS id, COUNT(comments.itemID) AS count
  FROM chall_k2_items AS content
  LEFT JOIN chall_k2_comments AS comments
  ON comments.itemID = content.id
  WHERE comments.published
  AND ( content.id = 119 OR content.id = 121 OR content.id = 122 OR content.id = 26 OR content.id = 23 OR content.id = 25 OR content.id = 120 )
  GROUP BY comments.itemID ;
36. SELECT id
  FROM chall_k2_categories
  WHERE parent IN (43)
  AND id NOT IN (43)
  AND published=1
  AND trash=0
  AND access IN(1,1)
37. SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.ordering, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
  FROM chall_k2_items as a
  LEFT JOIN chall_k2_categories AS c
  ON c.id = a.catid
  LEFT JOIN chall_k2_extra_fields_groups AS fg
  ON fg.id = c.extraFieldsGroup
  LEFT JOIN chall_k2_extra_fields AS f
  ON f.
  group = fg.id
  LEFT JOIN chall_k2_tags_xref AS tx
  ON tx.itemID = a.id
  LEFT JOIN chall_k2_tags AS t
  ON t.id = tx.tagID
  LEFT JOIN chall_k2_comments AS co
  ON co.itemID = a.id
  LEFT JOIN chall_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN chall_users AS um
  ON um.id = a.modified_by
  LEFT JOIN chall_k2_rating AS v
  ON a.id = v.itemID
  LEFT JOIN chall_viewlevels AS vl
  ON a.access = vl.id
  LEFT JOIN chall_languages AS l
  ON a.language = l.lang_code
  WHERE ((a.access IN(1,1)
  AND a.trash = 0
  AND a.published = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-20 10:26:43')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-20 10:26:43'))
  AND (a.catid IN (43)))
  GROUP BY a.id
38. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
39. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
40. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
41. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
42. SELECT i.provider_id as id, i.
  order, i.params
  FROM chall_roksprocket_items as i
  WHERE i.module_id = '327'
  AND i.provider = 'k2'
43. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
44. SELECT id
  FROM chall_k2_categories
  WHERE parent IN (41)
  AND id NOT IN (41)
  AND published=1
  AND trash=0
  AND access IN(1,1)
45. SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.ordering, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
  FROM chall_k2_items as a
  LEFT JOIN chall_k2_categories AS c
  ON c.id = a.catid
  LEFT JOIN chall_k2_extra_fields_groups AS fg
  ON fg.id = c.extraFieldsGroup
  LEFT JOIN chall_k2_extra_fields AS f
  ON f.
  group = fg.id
  LEFT JOIN chall_k2_tags_xref AS tx
  ON tx.itemID = a.id
  LEFT JOIN chall_k2_tags AS t
  ON t.id = tx.tagID
  LEFT JOIN chall_k2_comments AS co
  ON co.itemID = a.id
  LEFT JOIN chall_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN chall_users AS um
  ON um.id = a.modified_by
  LEFT JOIN chall_k2_rating AS v
  ON a.id = v.itemID
  LEFT JOIN chall_viewlevels AS vl
  ON a.access = vl.id
  LEFT JOIN chall_languages AS l
  ON a.language = l.lang_code
  LEFT
  OUTER JOIN (select rsi.provider_id, rsi.
  order
  from chall_roksprocket_items as rsi
  where module_id = 215) rsi
  on a.id = rsi.provider_id
  WHERE ((a.access IN(1,1)
  AND a.trash = 0
  AND a.published = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-20 10:26:43')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-20 10:26:43'))
  AND (a.catid IN (41)))
  GROUP BY a.id
  ORDER BY IF(ISNULL(rsi.
  order),1,0),rsi.
  order
46. SELECT i.provider_id as id, i.
  order, i.params
  FROM chall_roksprocket_items as i
  WHERE i.module_id = '215'
  AND i.provider = 'k2'
47. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
48. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
49. SELECT c.introtext, c.fulltext
  FROM chall_imageshow_showlist sl
  INNER JOIN chall_content c
  ON sl.alter_autid = c.id
  WHERE sl.showlist_id=3
50. SELECT *
  FROM chall_imageshow_showlist
  WHERE published = 1
  AND showlist_id = 3
51. SELECT *
  FROM chall_imageshow_showcase
  WHERE published = 1
  AND showcase_id = 1
52. SELECT *
  FROM chall_imageshow_theme_profile
  WHERE showcase_id =1
53. SHOW FULL COLUMNS
  FROM `chall_imageshow_showlist`
54. SELECT *
  FROM chall_imageshow_showlist
  WHERE `showlist_id` = '3'
55. UPDATE chall_extensions
  SET enabled = 1
  WHERE element LIKE 'source%'
  AND folder = 'jsnimageshow'
  AND enabled = 0
56. SELECT *
  FROM chall_extensions
  WHERE element LIKE 'source%'
  AND folder = 'jsnimageshow'
  AND enabled = 1
57. SELECT album_extid
  FROM chall_imageshow_images
  WHERE showlist_id =3
  AND sync = 1
  GROUP BY album_extid
58. SELECT image_id, image_title, image_small, image_big, image_medium, image_description, image_link, image_extid, album_extid, image_size, custom_data, exif_data
  FROM chall_imageshow_images
  WHERE showlist_id =3
  ORDER BY ordering ASC
59. SELECT *
  FROM chall_extensions
  WHERE folder = 'jsnimageshow'
  AND element='themecarousel'
60. SELECT *
  FROM chall_imageshow_showlist
  WHERE published = 1
  AND showlist_id = 3
61. SELECT *
  FROM chall_imageshow_showlist
  WHERE `showlist_id` = '3'
62. SELECT *
  FROM chall_imageshow_showlist
  WHERE `showlist_id` = '3'
63. SELECT album_extid
  FROM chall_imageshow_images
  WHERE showlist_id =3
  AND sync = 1
  GROUP BY album_extid
64. SELECT image_id, image_title, image_small, image_big, image_medium, image_description, image_link, image_extid, album_extid, image_size, custom_data, exif_data
  FROM chall_imageshow_images
  WHERE showlist_id =3
  ORDER BY ordering ASC
65. SELECT *
  FROM chall_imageshow_showlist
  WHERE published = 1
  AND showlist_id = 3
66. SHOW FULL COLUMNS
  FROM `chall_imageshow_theme_carousel`
67. SELECT *
  FROM chall_imageshow_theme_carousel
  WHERE `theme_id` = '4'
68. SELECT id
  FROM chall_k2_categories
  WHERE parent IN (42)
  AND id NOT IN (42)
  AND published=1
  AND trash=0
  AND access IN(1,1)
69. SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.ordering, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
  FROM chall_k2_items as a
  LEFT JOIN chall_k2_categories AS c
  ON c.id = a.catid
  LEFT JOIN chall_k2_extra_fields_groups AS fg
  ON fg.id = c.extraFieldsGroup
  LEFT JOIN chall_k2_extra_fields AS f
  ON f.
  group = fg.id
  LEFT JOIN chall_k2_tags_xref AS tx
  ON tx.itemID = a.id
  LEFT JOIN chall_k2_tags AS t
  ON t.id = tx.tagID
  LEFT JOIN chall_k2_comments AS co
  ON co.itemID = a.id
  LEFT JOIN chall_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN chall_users AS um
  ON um.id = a.modified_by
  LEFT JOIN chall_k2_rating AS v
  ON a.id = v.itemID
  LEFT JOIN chall_viewlevels AS vl
  ON a.access = vl.id
  LEFT JOIN chall_languages AS l
  ON a.language = l.lang_code
  LEFT
  OUTER JOIN (select rsi.provider_id, rsi.
  order
  from chall_roksprocket_items as rsi
  where module_id = 216) rsi
  on a.id = rsi.provider_id
  WHERE ((a.access IN(1,1)
  AND a.trash = 0
  AND a.published = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-20 10:26:43')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-20 10:26:43'))
  AND (a.catid IN (42)))
  GROUP BY a.id
  ORDER BY IF(ISNULL(rsi.
  order),1,0),rsi.
  order
70. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
71. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
72. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
73. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
74. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
75. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
76. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
77. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
78. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
79. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
80. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
81. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
82. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
83. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
84. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
85. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
86. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
87. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
88. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
89. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
90. SELECT i.provider_id as id, i.
  order, i.params
  FROM chall_roksprocket_items as i
  WHERE i.module_id = '216'
  AND i.provider = 'k2'
91. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
92. SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.ordering, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
  FROM chall_k2_items as a
  LEFT JOIN chall_k2_categories AS c
  ON c.id = a.catid
  LEFT JOIN chall_k2_extra_fields_groups AS fg
  ON fg.id = c.extraFieldsGroup
  LEFT JOIN chall_k2_extra_fields AS f
  ON f.
  group = fg.id
  LEFT JOIN chall_k2_tags_xref AS tx
  ON tx.itemID = a.id
  LEFT JOIN chall_k2_tags AS t
  ON t.id = tx.tagID
  LEFT JOIN chall_k2_comments AS co
  ON co.itemID = a.id
  LEFT JOIN chall_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN chall_users AS um
  ON um.id = a.modified_by
  LEFT JOIN chall_k2_rating AS v
  ON a.id = v.itemID
  LEFT JOIN chall_viewlevels AS vl
  ON a.access = vl.id
  LEFT JOIN chall_languages AS l
  ON a.language = l.lang_code
  WHERE ((a.access IN(1,1)
  AND a.trash = 0
  AND a.published = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-20 10:26:43')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-20 10:26:43'))
  AND a.id IN (11,12,13,14,15,16))
  GROUP BY a.id
  LIMIT 6
93. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
94. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
95. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
96. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
97. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
98. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
99. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
100. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
101. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
102. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
103. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
104. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
105. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
106. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
107. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
108. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
109. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
110. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
111. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
112. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
113. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
114. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
115. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
116. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
117. SELECT i.provider_id as id, i.
  order, i.params
  FROM chall_roksprocket_items as i
  WHERE i.module_id = '217'
  AND i.provider = 'k2'
118. SELECT *
  FROM chall_extensions
  WHERE element='com_imageshow'
  AND type='component'
119. SELECT *
  FROM `chall_chronoforms`
  WHERE `name` = 'Enquiry'
  AND `published` = '1'
  ORDER BY `id` DESC
120. SELECT *
  FROM `chall_chronoform_actions`
  WHERE `chronoform_id` = '1'
  ORDER BY `
  order`
121. SELECT *
  FROM `chall_extensions`
  WHERE `element` = 'com_chronoforms'
  AND `type` = 'component'
122. SHOW FULL COLUMNS
  FROM `chall_template_styles`
123. SELECT *
  FROM chall_template_styles
  WHERE `id` = '19'
124. UPDATE `chall_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1524220002;s:18:\"session.timer.last\";i:1524220002;s:17:\"session.timer.now\";i:1524220002;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"4594a70b8eada9c095b053db1cfac0034c0f7f51\";O:8:\"stdClass\":2:{s:4:\"link\";s:84:\"http://www.cih.com.au/index.php?option=com_k2&view=item&layout=item&id=42&Itemid=239\";s:6:\"expiry\";i:1524220003;}}s:13:\"session.token\";s:32:\"85427c9cfba1e27189674f0311b9cba4\";}' , `time` = '1524220004'
  WHERE `session_id` = '0ab21f3118b95dd60a01c33875c51b1c'

**53 Query Types Logged, Sorted by Occurrences.**

**SELECT Tables:**

1. **56 × SELECT *
  FROM chall_extensions**
2. **4 × SELECT i.provider_id as id, i.
  order, i.params
  FROM chall_roksprocket_items as i**
3. **3 × SELECT *
  FROM chall_imageshow_showlist**
4. **3 × SELECT id
  FROM chall_k2_categories**
5. **3 × SELECT *
  FROM chall_imageshow_showlist**
6. **2 × SELECT *
  FROM chall_k2_categories**
7. **2 × SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.ordering, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
  FROM chall_k2_items as a
  LEFT JOIN chall_k2_categories AS c
  ON c.id = a.catid
  LEFT JOIN chall_k2_extra_fields_groups AS fg
  ON fg.id = c.extraFieldsGroup
  LEFT JOIN chall_k2_extra_fields AS f
  ON f.
  group = fg.id
  LEFT JOIN chall_k2_tags_xref AS tx
  ON tx.itemID = a.id
  LEFT JOIN chall_k2_tags AS t
  ON t.id = tx.tagID
  LEFT JOIN chall_k2_comments AS co
  ON co.itemID = a.id
  LEFT JOIN chall_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN chall_users AS um
  ON um.id = a.modified_by
  LEFT JOIN chall_k2_rating AS v
  ON a.id = v.itemID
  LEFT JOIN chall_viewlevels AS vl
  ON a.access = vl.id
  LEFT JOIN chall_languages AS l
  ON a.language = l.lang_code
  LEFT
  OUTER JOIN (select rsi.provider_id, rsi.
  order
  from chall_roksprocket_items as rsi**
8. **2 × SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.ordering, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
  FROM chall_k2_items as a
  LEFT JOIN chall_k2_categories AS c
  ON c.id = a.catid
  LEFT JOIN chall_k2_extra_fields_groups AS fg
  ON fg.id = c.extraFieldsGroup
  LEFT JOIN chall_k2_extra_fields AS f
  ON f.
  group = fg.id
  LEFT JOIN chall_k2_tags_xref AS tx
  ON tx.itemID = a.id
  LEFT JOIN chall_k2_tags AS t
  ON t.id = tx.tagID
  LEFT JOIN chall_k2_comments AS co
  ON co.itemID = a.id
  LEFT JOIN chall_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN chall_users AS um
  ON um.id = a.modified_by
  LEFT JOIN chall_k2_rating AS v
  ON a.id = v.itemID
  LEFT JOIN chall_viewlevels AS vl
  ON a.access = vl.id
  LEFT JOIN chall_languages AS l
  ON a.language = l.lang_code**
9. **2 × SELECT image_id, image_title, image_small, image_big, image_medium, image_description, image_link, image_extid, album_extid, image_size, custom_data, exif_data
  FROM chall_imageshow_images**
10. **2 × SELECT album_extid
  FROM chall_imageshow_images**
11. **2 × SELECT `extension_id`
  FROM `chall_extensions`**
12. **2 × SELECT template
  FROM chall_template_styles as s**
13. **1 × SELECT c.introtext, c.fulltext
  FROM chall_imageshow_showlist sl
  INNER JOIN chall_content c
  ON sl.alter_autid = c.id**
14. **1 × SELECT *
  FROM `chall_chronoform_actions`**
15. **1 × SELECT *
  FROM chall_template_styles**
16. **1 × SELECT *
  FROM `chall_extensions`**
17. **1 × SELECT *
  FROM `chall_chronoforms`**
18. **1 × SELECT *
  FROM chall_imageshow_showcase**
19. **1 × SELECT content.id AS id, COUNT(comments.itemID) AS count
  FROM chall_k2_items AS content
  LEFT JOIN chall_k2_comments AS comments
  ON comments.itemID = content.id**
20. **1 × SELECT *
  FROM chall_extensions**
21. **1 × SELECT *
  FROM chall_imageshow_theme_carousel**
22. **1 × SELECT *
  FROM chall_imageshow_theme_profile**
23. **1 × SELECT *
  FROM chall_extensions**
24. **1 × SELECT *
  FROM chall_acymailing_list**
25. **1 × SELECT a.rules
  FROM chall_assets AS a**
26. **1 × SELECT b.rules
  FROM chall_assets AS a
  LEFT JOIN chall_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt**
27. **1 × SELECT id
  FROM chall_k2_categories**
28. **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 chall_menu AS m
  LEFT JOIN chall_extensions AS e
  ON m.component_id = e.extension_id**
29. **1 × SELECT extension, file, type
  FROM chall_rokcommon_configs**
30. **1 × SELECT `session_id`
  FROM `chall_session`**
31. **1 × SELECT b.id
  FROM chall_usergroups AS a
  LEFT JOIN chall_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt**
32. **1 × SELECT id, rules
  FROM `chall_viewlevels**
33. **1 × SELECT *
  FROM chall_k2_items**
34. **1 × SELECT id, name, parent
  FROM chall_k2_categories**
35. **1 × SELECT *
  FROM chall_acymailing_confi**
36. **1 × SELECT `data`
  FROM `chall_session`**
37. **1 × SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM chall_k2_categories AS c
  LEFT JOIN chall_k2_items AS content
  ON c.id = content.catid**
38. **1 × SELECT template
  FROM chall_template_styles**
39. **1 × SELECT ts.template
  FROM chall_template_styles AS ts
  INNER JOIN chall_menu AS m
  ON ts.id=m.template_style_id**
40. **1 × SELECT `name`, `value`
  FROM `chall_jsn_imageshow_config`**
41. **1 × SELECT params
  FROM chall_extensions AS e**
42. **1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM chall_modules AS m
  LEFT JOIN chall_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN chall_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id**
43. **1 × SELECT DISTINCT cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.id AS ID, content.alias AS alias, content.hits AS hits, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, content.plugins AS plugins
  FROM chall_k2_items AS content
  LEFT JOIN chall_k2_categories AS cats
  ON cats.id = content.catid
  LEFT JOIN chall_users AS users
  ON users.id = content.created_by
  LEFT JOIN chall_k2_rating AS content_rating
  ON content.id = content_rating.itemID**

**OTHER Tables:**

1. **1 × UPDATE chall_extensions
  SET enabled = 1**
2. **1 × SHOW FULL COLUMNS
  FROM `chall_imageshow_theme_carousel**
3. **1 × SHOW FULL COLUMNS
  FROM `chall_template_styles**
4. **1 × UPDATE `chall_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1524220002;s:18:\"session.timer.last\";i:1524220002;s:17:\"session.timer.now\";i:1524220002;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"4594a70b8eada9c095b053db1cfac0034c0f7f51\";O:8:\"stdClass\":2:{s:4:\"link\";s:84:\"http://www.cih.com.au/index.php?option=com_k2&view=item&layout=item&id=42&Itemid=239\";s:6:\"expiry\";i:1524220003;}}s:13:\"session.token\";s:32:\"85427c9cfba1e27189674f0311b9cba4\";}' , `time` = '1524220004'**
5. **1 × SHOW FULL COLUMNS
  FROM `chall_imageshow_showlist**
6. **1 × UPDATE chall_k2_items
  SET `hits` = (`hits` + 1)**
7. **1 × SHOW FULL COLUMNS
  FROM `chall_extensions**
8. **1 × SHOW FULL COLUMNS
  FROM `chall_k2_categories**
9. **1 × SHOW FULL COLUMNS
  FROM `chall_k2_items**
10. **1 × INSERT INTO `chall_session` (`session_id`, `client_id`, `time`)
  VALUES ('0ab21f3118b95dd60a01c33875c51b1c', 0, '1524220002'**

**None**

• **Loaded** : JROOT/language/en-GB/en-GB.ini
• **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_plugin_googlemap2.ini
• **Not loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_gantry.ini
• **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_logout.ini
• **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_jsnframework.ini
• **Loaded** : JROOT/language/en-GB/en-GB.lib_joomla.ini
• **Loaded** : JROOT/language/en-GB/en-GB.com_k2.ini
• **Loaded** : JROOT/administrator/language/en-GB/en-GB.com_k2.j16.ini
• **Not loaded** : JROOT/language/en-GB/en-GB.tpl_elitefx.ini
• **Not loaded** : JROOT/templates/elitefx/language/en-GB/en-GB.tpl_elitefx.ini
• **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_content_pagebreak.ini
• **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_content_vote.ini
• **Loaded** : JROOT/language/en-GB/en-GB.plg_content_imageshow.ini
• **Loaded** : JROOT\administrator\components\com_widgetkit/language/en-GB/en-GB.widgetkit.ini
• **Loaded** : JROOT/language/en-GB/en-GB.mod_roknavmenu.ini
• **Not loaded** : JROOT/language/en-GB/en-GB.mod_acymailing.ini
• **Not loaded** : JROOT/modules/mod_acymailing/language/en-GB/en-GB.mod_acymailing.ini
• **Loaded** : JROOT/language/en-GB/en-GB.com_acymailing.ini
• **Not loaded** : JROOT/language/en-GB/en-GB.com_acymailing_custom.ini
• **Loaded** : JROOT/language/en-GB/en-GB.mod_news_pro_gk4.ini
• **Not loaded** : JROOT/language/en-GB/en-GB.mod_roksprocket.ini
• **Loaded** : JROOT/modules/mod_roksprocket/language/en-GB/en-GB.mod_roksprocket.ini
• **Not loaded** : JROOT/language/en-GB/en-GB.com_roksprocket.ini
• **Loaded** : JROOT/components/com_roksprocket/language/en-GB/en-GB.com_roksprocket.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\features/language/en-GB/en-GB.roksprocket_layout_features.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\grids/language/en-GB/en-GB.roksprocket_layout_grids.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\headlines/language/en-GB/en-GB.roksprocket_layout_headlines.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\lists/language/en-GB/en-GB.roksprocket_layout_lists.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\mosaic/language/en-GB/en-GB.roksprocket_layout_mosaic.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\quotes/language/en-GB/en-GB.roksprocket_layout_quotes.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\sliders/language/en-GB/en-GB.roksprocket_layout_sliders.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\strips/language/en-GB/en-GB.roksprocket_layout_strips.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\tables/language/en-GB/en-GB.roksprocket_layout_tables.ini
• **Loaded** : JROOT/components/com_roksprocket/layouts\tabs/language/en-GB/en-GB.roksprocket_layout_tabs.ini
• **Loaded** : JROOT/language/en-GB/en-GB.mod_imageshow.ini
• **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_jsnimageshow_themecarousel.ini
• **Not loaded** : JROOT/language/en-GB/en-GB.mod_chronoforms.ini
• **Not loaded** : JROOT/modules/mod_chronoforms/language/en-GB/en-GB.mod_chronoforms.ini
• **Not loaded** : JROOT/language/en-GB/en-GB.mod_AutsonSlideShow.ini
• **Not loaded** : JROOT/modules/mod_AutsonSlideShow/language/en-GB/en-GB.mod_AutsonSlideShow.ini
• **Loaded** : JROOT/language/en-GB/en-GB.mod_menu.ini
• **Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_debug.ini

# **Unknown file**

GANTRY_INITIALIZED_FROM="INITIALIZED FROM"

# JROOT\libraries\rokcommon\RokCommon\I18N\Joomla.php

LOADING_CONTAINER_CONFIG_FILE_FOR_S_FROM_S="container config file for %s from %s"
REGISTERING_LIBRARY_PATH_S_FOR_S="library path %s for %s"

# JROOT\administrator\components\com_imageshow\classes\jsn_is_source.php

LOCAL_IMAGE_FOLDER="image folder"
LOCAL_IMAGE_FOLDER_DESCRIPTION="image folder description"