29 Queries Logged

1. SELECT `data`
  FROM `jori6_session`
  WHERE `session_id` = 'f92p3b8lvqu1ba8car6l57g480'
2. SELECT `session_id`
  FROM `jori6_session`
  WHERE `session_id` = 'f92p3b8lvqu1ba8car6l57g480'
  LIMIT 0, 1
3. INSERT INTO `jori6_session` (`session_id`, `client_id`, `time`)
  VALUES ('f92p3b8lvqu1ba8car6l57g480', 0, '1558859558')
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jori6_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
5. SELECT b.id
  FROM jori6_usergroups AS a
  LEFT JOIN jori6_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `jori6_viewlevels`
7. SELECT folder AS type, element AS name, params
  FROM jori6_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
8. SELECT *
  FROM jori6_languages
  WHERE published=1
  ORDER BY ordering ASC
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jori6_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT a.rules
  FROM jori6_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
11. SELECT b.rules
  FROM jori6_assets AS a
  LEFT JOIN jori6_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_banners' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
12. SELECT `value`
  FROM `jori6_admintools_storage`
  WHERE `key` = 'cparams'
13. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jori6_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
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 jori6_menu AS m
  LEFT JOIN jori6_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 id, home, template, s.params
  FROM jori6_template_styles as s
  LEFT JOIN jori6_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
16. INSERT INTO `jori6_rokuserstats` (`user_id`,`ip`,`session_id`,`page`,`referrer`)
  VALUES ('0','35.175.248.25','f92p3b8lvqu1ba8car6l57g480','/products/iot/item/384-cloud-monitoring-air-sensor','')
17. SELECT b.rules
  FROM jori6_assets AS a
  LEFT JOIN jori6_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_k2' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
18. SELECT id
  FROM jori6_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
19. SELECT *
  FROM jori6_k2_items
  WHERE id=384
  AND language IN ('en-GB','*')
  LIMIT 0, 1
20. SHOW FULL COLUMNS
  FROM `jori6_k2_categories`
21. SELECT *
  FROM jori6_k2_categories
  WHERE id = '66'
22. SELECT *
  FROM jori6_k2_categories
  WHERE id = '16'
23. SELECT COUNT(*)
  FROM jori6_k2_comments
  WHERE itemID=384
  AND published=1
24. SHOW FULL COLUMNS
  FROM `jori6_k2_items`
25. UPDATE jori6_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '384'
26. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jori6_modules AS m
  LEFT JOIN jori6_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jori6_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 <= '2019-05-26 08:32:38')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-05-26 08:32:38')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 290 OR mm.menuid <= 0)
  AND m.language IN ('en-GB','*')
  ORDER BY m.position, m.ordering
27. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jori6_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_djimageslider'
28. SELECT a.*
  FROM jori6_djimageslider AS a
  WHERE a.catid = 65
  AND a.published = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-05-26 08:32:38')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-05-26 08:32:38')
  ORDER BY a.ordering ASC
  LIMIT 0, 10
29. UPDATE `jori6_session`
  SET `data` = '6qlQQsA4xtiRxxlgMexHDDbCvlg8DItMVSjyOHdC4wSekGtbh5CL0yH7LxB-UsTl5UhejsU68juWePOIaZgBFEiAiV4BVX7tTpSX1Jyq3w6HhkvGadBZmV9BXQahybdYpngYlKeBlgU0DALGtTqwhp8CpkE-5ByaioahtIdFaQR5Wbxi1iEjMdZP7fCdJRCiAX4HsShJAJbfx4rb4XnyxfDM3uWztAzlwhjykXwVWKbkOy86mqIe9YSSYOgnE75mvceqS0TZDY-5GvrDv5de6RxKl3FklT-YeB88FWcglV5X5DUO5-owE2wLBfKZYKstTPHxsDeumZOv7zQjQwmwA8iOxE74dhfoJpf_soPABJ7rhpula8GeIeZnt6FlVYHpSyWxYqDxoy6Hoop2nCh0nB9d3hACoc86O7N-2zarFpC5IzXYJCzEye8Rj2vskqC0e-wG0van86MZk-LJ9Qg-VVRwIHTLdQ1oY3IhlPGxJ1t0KUElq1E_dLAAj2sXdF1yO2qRPYuqPS9y2qKiX8L5nbsJOO2Y4cpfMJqEZcEntE63UBIO1_Sl0PgyB4OFKca5U86EByyjfQGfN4CoS7aPF25extILF-FHkluVdxLntLYDgeEmFzITV4BxGl7mDR-SVBGIwoFaYL2zCBf-Ney28SFCdIjEZi7_DkkIZdNy7_dPK9RvoSSZ6GPOZmDmEEN4HppNvI1i1xS7oQ58Vv04ZJUX9Z2gB_Mmiifi1dKz3jkF46W7L8kXJ1hT3skaod57dlUt9wViJezrSChcP7Qlb0bj0D2Y96RbR7_yX8CvBubZGCD98Q0SGpsUrt1OrjnXOuQh0Viq5-txq5GZMOeezKL0Pl5Rmz9OyEXcAE1HRnDmIfOzDKMkDf6lAfXcqm3GPwXBoFtpUJ_Vumo9XSGrWNU816cwgADS4BwY2abSK7A71xnfLr_NadpjdlO12Gwq4F4fueRLCxJjN8Mrs8D1HGr8ltX5EqWIm6BXnGj8R1Qsar7smWEgvWBW9FAu8OSeU75zmLz1lrbsVbJ-H6sbQnOCOAlSFgCa3Hg5jvrT87xs2RVZZi4CSJPm8RQaRgT_phwoDMNnYt5ORJ0yiZAmNL2SVrsx3OQOnPOLTLOiopT0ANeiAhh6DLBDj7D-D2q6XC9QLs59jR6dUlxNJPqCO07ojdlfz2ZELzumRsAxvvCosbVnP60t7Er428QFDBS7lTRGyJ6wj3RpToB3tKcz_6c1_eoG96WisB5-q--e_DkeuB1hDVn59-I9_9jL_C9cRKOXLge72trAWa7aS8EJbZc2jyev2QeuKzm42iAWpl-USm2A71s9nsX_2J-q5QOXxeV-xetWzt2mFkT2M1CEro-tTZfvaw2wBUQzxWBjWDpNe-NzVl94sV4Y1-K0761vOc9nrrnw4S2SdA-y9uqFaFYN_C_Hscq5erj5TSRmhYpp40f2L1PkBImzDCilkZJfQ5IWLr8YOr0FBRsdVCt0nA..' , `time` = '1558859558'
  WHERE `session_id` = 'f92p3b8lvqu1ba8car6l57g480'

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM jori6_extensions
2. 2 × SELECT *
  FROM jori6_k2_categories
3. 2 × SELECT b.rules
  FROM jori6_assets AS a
  LEFT JOIN jori6_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
4. 1 × SELECT *
  FROM jori6_k2_items
5. 1 × SELECT id
  FROM jori6_k2_categories
6. 1 × SELECT `session_id`
  FROM `jori6_session`
7. 1 × SELECT COUNT(*)
  FROM jori6_k2_comments
8. 1 × SELECT a.*
  FROM jori6_djimageslider AS a
9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jori6_modules AS m
  LEFT JOIN jori6_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jori6_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
10. 1 × SELECT id, home, template, s.params
  FROM jori6_template_styles as s
  LEFT JOIN jori6_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
11. 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 jori6_menu AS m
  LEFT JOIN jori6_extensions AS e
  ON m.component_id = e.extension_id
12. 1 × SELECT folder AS type, element AS name, params
  FROM jori6_extensions
13. 1 × SELECT id, rules
  FROM `jori6_viewlevels
14. 1 × SELECT *
  FROM jori6_languages
15. 1 × SELECT a.rules
  FROM jori6_assets AS a
16. 1 × SELECT `value`
  FROM `jori6_admintools_storage`
17. 1 × SELECT `data`
  FROM `jori6_session`
18. 1 × SELECT b.id
  FROM jori6_usergroups AS a
  LEFT JOIN jori6_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt

OTHER Tables:

1. 1 × UPDATE jori6_k2_items
  SET `hits` = (`hits` + 1)
2. 1 × UPDATE `jori6_session`
  SET `data` = '6qlQQsA4xtiRxxlgMexHDDbCvlg8DItMVSjyOHdC4wSekGtbh5CL0yH7LxB-UsTl5UhejsU68juWePOIaZgBFEiAiV4BVX7tTpSX1Jyq3w6HhkvGadBZmV9BXQahybdYpngYlKeBlgU0DALGtTqwhp8CpkE-5ByaioahtIdFaQR5Wbxi1iEjMdZP7fCdJRCiAX4HsShJAJbfx4rb4XnyxfDM3uWztAzlwhjykXwVWKbkOy86mqIe9YSSYOgnE75mvceqS0TZDY-5GvrDv5de6RxKl3FklT-YeB88FWcglV5X5DUO5-owE2wLBfKZYKstTPHxsDeumZOv7zQjQwmwA8iOxE74dhfoJpf_soPABJ7rhpula8GeIeZnt6FlVYHpSyWxYqDxoy6Hoop2nCh0nB9d3hACoc86O7N-2zarFpC5IzXYJCzEye8Rj2vskqC0e-wG0van86MZk-LJ9Qg-VVRwIHTLdQ1oY3IhlPGxJ1t0KUElq1E_dLAAj2sXdF1yO2qRPYuqPS9y2qKiX8L5nbsJOO2Y4cpfMJqEZcEntE63UBIO1_Sl0PgyB4OFKca5U86EByyjfQGfN4CoS7aPF25extILF-FHkluVdxLntLYDgeEmFzITV4BxGl7mDR-SVBGIwoFaYL2zCBf-Ney28SFCdIjEZi7_DkkIZdNy7_dPK9RvoSSZ6GPOZmDmEEN4HppNvI1i1xS7oQ58Vv04ZJUX9Z2gB_Mmiifi1dKz3jkF46W7L8kXJ1hT3skaod57dlUt9wViJezrSChcP7Qlb0bj0D2Y96RbR7_yX8CvBubZGCD98Q0SGpsUrt1OrjnXOuQh0Viq5-txq5GZMOeezKL0Pl5Rmz9OyEXcAE1HRnDmIfOzDKMkDf6lAfXcqm3GPwXBoFtpUJ_Vumo9XSGrWNU816cwgADS4BwY2abSK7A71xnfLr_NadpjdlO12Gwq4F4fueRLCxJjN8Mrs8D1HGr8ltX5EqWIm6BXnGj8R1Qsar7smWEgvWBW9FAu8OSeU75zmLz1lrbsVbJ-H6sbQnOCOAlSFgCa3Hg5jvrT87xs2RVZZi4CSJPm8RQaRgT_phwoDMNnYt5ORJ0yiZAmNL2SVrsx3OQOnPOLTLOiopT0ANeiAhh6DLBDj7D-D2q6XC9QLs59jR6dUlxNJPqCO07ojdlfz2ZELzumRsAxvvCosbVnP60t7Er428QFDBS7lTRGyJ6wj3RpToB3tKcz_6c1_eoG96WisB5-q--e_DkeuB1hDVn59-I9_9jL_C9cRKOXLge72trAWa7aS8EJbZc2jyev2QeuKzm42iAWpl-USm2A71s9nsX_2J-q5QOXxeV-xetWzt2mFkT2M1CEro-tTZfvaw2wBUQzxWBjWDpNe-NzVl94sV4Y1-K0761vOc9nrrnw4S2SdA-y9uqFaFYN_C_Hscq5erj5TSRmhYpp40f2L1PkBImzDCilkZJfQ5IWLr8YOr0FBRsdVCt0nA..' , `time` = '1558859558'
3. 1 × SHOW FULL COLUMNS
  FROM `jori6_k2_items
4. 1 × SHOW FULL COLUMNS
  FROM `jori6_k2_categories
5. 1 × INSERT INTO `jori6_rokuserstats` (`user_id`,`ip`,`session_id`,`page`,`referrer`)
  VALUES ('0','35.175.248.25','f92p3b8lvqu1ba8car6l57g480','/products/iot/item/384-cloud-monitoring-air-sensor',''
6. 1 × INSERT INTO `jori6_session` (`session_id`, `client_id`, `time`)
  VALUES ('f92p3b8lvqu1ba8car6l57g480', 0, '1558859558'