72 ausgeführte Abfragen

1. SELECT `data`
  FROM `sobi11_session`
  WHERE `session_id` = 'e9dc64475243be6f9a67739a3e5c1a09'
2. SELECT `session_id`
  FROM `sobi11_session`
  WHERE `session_id` = 'e9dc64475243be6f9a67739a3e5c1a09'
  LIMIT 0, 1
3. INSERT INTO `sobi11_session` (`session_id`, `client_id`, `time`)
  VALUES ('e9dc64475243be6f9a67739a3e5c1a09', 0, '1558594162')
4. SELECT b.id
  FROM sobi11_usergroups AS a
  LEFT JOIN sobi11_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 9
5. SELECT id, rules
  FROM `sobi11_viewlevels`
6. SELECT `query`
  FROM `sobi11_admintools_wafexceptions`
  WHERE (`option` IS NULL OR `option` = '')
  AND (`view` IS NULL OR `view` = '')
  GROUP BY `query`
  ORDER BY `query` ASC
7. SELECT `value`
  FROM `sobi11_admintools_storage`
  WHERE `key` = 'cparams'
8. SELECT *
  FROM `sobi11_admintools_ipautoban`
  WHERE `ip` = '34.229.151.87'
9. SELECT `ip`
  FROM `sobi11_admintools_ipblock`
10. SELECT `source`,`keepurlparams`
  FROM `sobi11_admintools_redirects`
  WHERE ((`dest` = 'kategorien/155-uhren_schmuck') OR (`dest` = 'kategorien/155-uhren_schmuck') OR ('kategorien/155-uhren_schmuck' LIKE `dest`))
  AND `published` = '1'
  ORDER BY `ordering` DESC
  LIMIT 0, 1
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 sobi11_menu AS m
  LEFT JOIN sobi11_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 a.rules
  FROM sobi11_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
13. SELECT b.rules
  FROM sobi11_assets AS a
  LEFT JOIN sobi11_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.id = 1)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
14. SELECT *
  FROM sobi11_languages
  WHERE published=1
  ORDER BY ordering ASC
15. SELECT id, home, template, s.params
  FROM sobi11_template_styles as s
  LEFT JOIN sobi11_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. SELECT *
  FROM sobi11_sobipro_object
  WHERE ( id ='155' )
17. SELECT pid
  FROM sobi11_sobipro_relations
  WHERE ( id ='155' )
18. SELECT pid
  FROM sobi11_sobipro_relations
  WHERE ( id ='2' )
19. SELECT pid
  FROM sobi11_sobipro_relations
  WHERE ( id ='1' )
20. SELECT *
  FROM sobi11_sobipro_object
  WHERE ( id ='1' )
21. SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue
  FROM sobi11_sobipro_config
  WHERE ( section IN ( '0','1' ) )
  ORDER BY section, configsection
22. SELECT *
  FROM sobi11_sobipro_field
  WHERE ( fid ='1' )
23. SELECT pid
  FROM sobi11_sobipro_plugin_task
  WHERE ( onAction IN ( '*','*' ) )
24. SELECT pid
  FROM sobi11_sobipro_plugin_section
  WHERE ( section ='1' )
  AND ( enabled ='1' )
  AND ( pid IN ( 'notifications' ) )
25. SELECT sValue,sKey
  FROM sobi11_sobipro_language
  WHERE ( fid ='1' )
  AND ( sKey IN ( 'name','description','suffix' ) )
  AND ( oType ='field' )
  ORDER BY FIELD( language, 'de-DE', '%' ) ASC
26. SELECT id AS id, sKey AS label, sValue AS value, language
  FROM sobi11_sobipro_language
  WHERE ( id ='1' )
  AND ( oType ='section' )
  AND ( sKey IN ( 'name' ) )
  ORDER BY FIELD( language, 'de-DE', 'de-DE' )
27. SELECT rel.gid
  FROM sobi11_sobipro_user_group AS grp
  LEFT JOIN sobi11_sobipro_users_relation AS rel
  ON grp.gid = rel.gid
  WHERE ( ( rel.validUntil > '2019-05-23 06:49:22' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
  AND ( rel.validSince < '2019-05-23 06:49:22' OR rel.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
  AND grp.enabled = 1 )
  AND ( uid ='0' )
28. SELECT parent.id, parent.lft, parent.rgt
  FROM sobi11_usergroups AS parent
  ORDER BY parent.lft
29. SELECT *
  FROM sobi11_sobipro_category
  WHERE ( id ='155' )
30. SELECT counter
  FROM sobi11_sobipro_counter
  WHERE ( sid ='155' )
31. SELECT sValue, sKey
  FROM sobi11_sobipro_language
  WHERE ( id ='155' )
  AND ( sKey IN ( 'description','introtext','name','metaKeys','metaDesc','nid','metaDesc','metaKeys' ) )
  AND ( language ='de-DE' )
  AND ( oType ='category' )
32. SELECT position,pid
  FROM sobi11_sobipro_relations
  WHERE ( id ='155' )
33. SELECT DISTINCT sprl.rid
  FROM sobi11_sobipro_permissions_groups AS spgr
  LEFT JOIN sobi11_sobipro_permissions_rules AS sprl
  ON spgr.rid = sprl.rid
  WHERE ( ( sprl.validUntil > '2019-05-23 06:49:22' OR sprl.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
  AND ( sprl.validSince < '2019-05-23 06:49:22' OR sprl.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
  AND state = 1 )
  AND spgr.gid in( 0 )
34. SELECT pid
  FROM sobi11_sobipro_permissions_map
  WHERE ( sid ='1' )
  AND ( rid IN ( '3','5' ) )
35. SELECT *
  FROM sobi11_sobipro_permissions
  WHERE ( site ='front' )
  AND ( published ='1' )
36. SELECT pid
  FROM sobi11_sobipro_plugin_task
  WHERE ( onAction IN ( '*','category.view','category.*' ) )
37. SELECT pid
  FROM sobi11_sobipro_plugin_section
  WHERE ( section ='1' )
  AND ( enabled ='1' )
  AND ( pid IN ( 'notifications' ) )
38. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='155' )
39. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='36' )
40. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='32' )
41. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='47' )
42. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='87' )
43. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='119' )
44. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='51' )
45. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='101' )
46. SELECT DISTINCT spo.id
  FROM sobi11_sobipro_relations AS sprl
  LEFT JOIN sobi11_sobipro_object AS spo
  ON sprl.id = spo.id
  WHERE ( sprl.pid IN ( '155' ) )
  AND ( spo.oType ='entry' )
  AND ( spo.state ='1' )
  AND ( ( spo.validUntil > '2019-05-23 06:49:22' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
  AND ( spo.validSince < '2019-05-23 06:49:22' OR spo.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) )
  AND ( sprl.copy ='0' )
  ORDER BY updatedTime desc
47. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='155' )
48. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='36' )
49. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='32' )
50. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='47' )
51. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='87' )
52. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='119' )
53. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='51' )
54. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='101' )
55. SELECT DISTINCT spo.id
  FROM sobi11_sobipro_relations AS sprl
  LEFT JOIN sobi11_sobipro_object AS spo
  ON sprl.id = spo.id
  WHERE ( sprl.pid IN ( '155' ) )
  AND ( spo.oType ='entry' )
  AND ( spo.state ='1' )
  AND ( ( spo.validUntil > '2019-05-23 06:49:22' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
  AND ( spo.validSince < '2019-05-23 06:49:22' OR spo.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) )
  AND ( sprl.copy ='0' )
  ORDER BY updatedTime desc
  LIMIT 0, 15
56. SELECT id,oType
  FROM sobi11_sobipro_relations
  WHERE ( pid ='155' )
57. INSERT INTO sobi11_sobipro_counter (`sid`,`counter`,`lastUpdate`)
  VALUES ('155','10428','2019-05-23 06:49:23')
  ON DUPLICATE KEY UPDATE sid = '155',counter = '10428',lastUpdate = '2019-05-23 06:49:23'
58. SELECT counter,sid
  FROM sobi11_sobipro_counter
  WHERE ( sid IN ( '51','119','101','32','36' ) )
59. SELECT pid
  FROM sobi11_sobipro_plugin_task
  WHERE ( onAction IN ( '*','list.custom','list.*' ) )
60. SELECT pid
  FROM sobi11_sobipro_plugin_section
  WHERE ( section ='1' )
  AND ( enabled ='1' )
  AND ( pid IN ( 'download_field','notifications' ) )
61. SELECT *
  FROM sobi11_sobipro_registry
  WHERE ( section ='messages' )
  ORDER BY value
62. SELECT *
  FROM sobi11_sobipro_registry
  WHERE ( section ='reports' )
  ORDER BY value
63. SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
  FROM sobi11_modules AS m
  LEFT JOIN sobi11_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN sobi11_advancedmodules as am
  ON am.moduleid = m.id
  WHERE m.published = 1
  AND e.enabled = 1
  AND m.client_id = 0
  AND m.access IN (1,1,4)
  ORDER BY m.ordering, m.id
64. SELECT m.menutype
  FROM sobi11_menu AS m
  WHERE m.id = 356
65. SELECT *
  FROM sobi11_sobipro_category
  WHERE ( id ='0' )
66. SELECT counter
  FROM sobi11_sobipro_counter
  WHERE ( sid ='0' )
67. SELECT sValue, sKey
  FROM sobi11_sobipro_language
  WHERE ( id ='0' )
  AND ( sKey IN ( 'description','introtext','name','metaKeys','metaDesc','nid','metaDesc','metaKeys' ) )
  AND ( language ='de-DE' )
  AND ( oType ='category' )
68. SELECT position,pid
  FROM sobi11_sobipro_relations
  WHERE ( id ='0' )
69. SELECT DISTINCT spo.id
  FROM sobi11_sobipro_relations AS sprl
  LEFT JOIN sobi11_sobipro_object AS spo
  ON sprl.id = spo.id
  WHERE ( sprl.pid IN ( '2','204','143','148','149','150','202','151','155','156','157','201','195','198','200','203','207','244','3','107','109','196','205','4','141','142','144','146','147','152','153','154','158','160','161','162','170','197','199','263','298','354','108','159','110','111','145','173','227','270','271','194','268','261','502','276','0' ) )
  AND ( spo.oType ='entry' )
  AND ( spo.state ='1' )
  AND ( ( spo.validUntil > '2019-05-23 06:49:23' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
  AND ( spo.validSince < '2019-05-23 06:49:23' OR spo.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) )
  AND ( sprl.copy ='0' )
  ORDER BY updatedTime desc
  LIMIT 0, 10
70. SELECT counter,sid
  FROM sobi11_sobipro_counter
  WHERE ( sid IN ( '431','295','522','299','78','472','523','139','57','461' ) )
71. SELECT *
  FROM sobi11_acymailing_config
72. UPDATE `sobi11_session`
  SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1558594162;s:18:\"session.timer.last\";i:1558594162;s:17:\"session.timer.now\";i:1558594162;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:11:\"com_sobipro\";O:8:\"stdClass\":3:{s:8:\"back_url\";s:29:\"/kategorien/155-uhren_schmuck\";s:27:\"currently-displayed-entries\";a:5:{i:0;s:2:\"51\";i:1;s:3:\"119\";i:2;s:3:\"101\";i:3;s:2:\"32\";i:4;s:2:\"36\";}s:14:\"messages-queue\";a: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:2:{i:0;i:1;i:1;i:9;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:4;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}skipped_email|b:0;' , `time` = '1558594163'
  WHERE `session_id` = 'e9dc64475243be6f9a67739a3e5c1a09'

41 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 17 × SELECT id,oType
  FROM sobi11_sobipro_relations
2. 3 × SELECT pid
  FROM sobi11_sobipro_plugin_section
3. 3 × SELECT DISTINCT spo.id
  FROM sobi11_sobipro_relations AS sprl
  LEFT JOIN sobi11_sobipro_object AS spo
  ON sprl.id = spo.id
4. 3 × SELECT pid
  FROM sobi11_sobipro_relations
5. 3 × SELECT pid
  FROM sobi11_sobipro_plugin_task
6. 2 × SELECT sValue, sKey
  FROM sobi11_sobipro_language
7. 2 × SELECT position,pid
  FROM sobi11_sobipro_relations
8. 2 × SELECT *
  FROM sobi11_sobipro_object
9. 2 × SELECT counter,sid
  FROM sobi11_sobipro_counter
10. 2 × SELECT *
  FROM sobi11_sobipro_registry
11. 2 × SELECT counter
  FROM sobi11_sobipro_counter
12. 2 × SELECT *
  FROM sobi11_sobipro_category
13. 1 × SELECT parent.id, parent.lft, parent.rgt
  FROM sobi11_usergroups AS parent
14. 1 × SELECT DISTINCT sprl.rid
  FROM sobi11_sobipro_permissions_groups AS spgr
  LEFT JOIN sobi11_sobipro_permissions_rules AS sprl
  ON spgr.rid = sprl.rid
15. 1 × SELECT pid
  FROM sobi11_sobipro_permissions_map
16. 1 × SELECT *
  FROM sobi11_sobipro_permissions
17. 1 × SELECT m.menutype
  FROM sobi11_menu AS m
18. 1 × SELECT *
  FROM sobi11_acymailing_confi
19. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
  FROM sobi11_modules AS m
  LEFT JOIN sobi11_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN sobi11_advancedmodules as am
  ON am.moduleid = m.id
20. 1 × SELECT `session_id`
  FROM `sobi11_session`
21. 1 × SELECT b.id
  FROM sobi11_usergroups AS a
  LEFT JOIN sobi11_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
22. 1 × SELECT rel.gid
  FROM sobi11_sobipro_user_group AS grp
  LEFT JOIN sobi11_sobipro_users_relation AS rel
  ON grp.gid = rel.gid
23. 1 × SELECT id AS id, sKey AS label, sValue AS value, language
  FROM sobi11_sobipro_language
24. 1 × SELECT a.rules
  FROM sobi11_assets AS a
25. 1 × SELECT b.rules
  FROM sobi11_assets AS a
  LEFT JOIN sobi11_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
26. 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 sobi11_menu AS m
  LEFT JOIN sobi11_extensions AS e
  ON m.component_id = e.extension_id
27. 1 × SELECT `source`,`keepurlparams`
  FROM `sobi11_admintools_redirects`
28. 1 × SELECT *
  FROM `sobi11_admintools_ipautoban`
29. 1 × SELECT `ip`
  FROM `sobi11_admintools_ipblock
30. 1 × SELECT *
  FROM sobi11_languages
31. 1 × SELECT id, home, template, s.params
  FROM sobi11_template_styles as s
  LEFT JOIN sobi11_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
32. 1 × SELECT id, rules
  FROM `sobi11_viewlevels
33. 1 × SELECT sValue,sKey
  FROM sobi11_sobipro_language
34. 1 × SELECT `data`
  FROM `sobi11_session`
35. 1 × SELECT *
  FROM sobi11_sobipro_field
36. 1 × SELECT `query`
  FROM `sobi11_admintools_wafexceptions`
37. 1 × SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue
  FROM sobi11_sobipro_config
38. 1 × SELECT `value`
  FROM `sobi11_admintools_storage`

Andere Tabellen:

1. 1 × UPDATE `sobi11_session`
  SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1558594162;s:18:\"session.timer.last\";i:1558594162;s:17:\"session.timer.now\";i:1558594162;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:11:\"com_sobipro\";O:8:\"stdClass\":3:{s:8:\"back_url\";s:29:\"/kategorien/155-uhren_schmuck\";s:27:\"currently-displayed-entries\";a:5:{i:0;s:2:\"51\";i:1;s:3:\"119\";i:2;s:3:\"101\";i:3;s:2:\"32\";i:4;s:2:\"36\";}s:14:\"messages-queue\";a: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:2:{i:0;i:1;i:1;i:9;}s:14:\"\0*\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:4;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}skipped_email|b:0;' , `time` = '1558594163'
2. 1 × INSERT INTO sobi11_sobipro_counter (`sid`,`counter`,`lastUpdate`)
  VALUES ('155','10428','2019-05-23 06:49:23')
  ON DUPLICATE KEY UPDATE sid = '155',counter = '10428',lastUpdate = '2019-05-23 06:49:23
3. 1 × INSERT INTO `sobi11_session` (`session_id`, `client_id`, `time`)
  VALUES ('e9dc64475243be6f9a67739a3e5c1a09', 0, '1558594162'