50 query eseguite

1. SELECT extension_id AS id, element AS "option", params, enabled
  FROM avjos16_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
2. SELECT extension_id AS id, element AS "option", params, enabled
  FROM avjos16_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_coalawebtraffic'
3. SELECT count(*)
  FROM `avjos16_cwtraffic`
  WHERE ip = '18.191.132.194'
  AND tm + '3600'>'1713488889'
4. SHOW TABLES
5. SELECT file_id
  from avjos16_jdownloads_files
  WHERE published = 1
  AND use_timeframe = 1
  AND publish_to != '0000-00-00 00:00:00'
  AND publish_to <= '2024-04-19 03:08:09'
6. SELECT file_id
  from avjos16_jdownloads_files
  WHERE published = 0
  AND use_timeframe = 1
  AND publish_from != '0000-00-00 00:00:00'
  AND publish_from <= '2024-04-19 03:08:09'
7. 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 avjos16_menu AS m
  LEFT JOIN avjos16_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
8. SELECT joomlatablename,tablepkID
  FROM `avjos16_falang_tableinfo`
9. SELECT *
  FROM avjos16_languages
  ORDER BY ordering
10. SHOW FULL COLUMNS
  FROM `avjos16_languages`
11. SELECT extension_id AS id, element AS "option", params, enabled
  FROM avjos16_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_falang'
12. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM avjos16_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(115,282,283,284,285,286,288,475,317,366,367,368,400,416,476,123,124,126,127,356,357,358,359,360,361,362,363,364,128,136,137,138,139,140,377,378,379,383,384,385,386,380,381,382,415,141,412,413,151,152,153,477,495,494,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,496,129,130,133,132,134,229,135,156,355,281,101,301,302,455,304,306,307,308,309,310,311,312,313,314,316,315,456,457,458,473,254)
  AND falang_content.reference_table='menu'
13. SELECT id, home, template, s.params
  FROM avjos16_template_styles as s
  LEFT JOIN avjos16_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
14. SHOW TABLES
15. SELECT extension_id AS id, element AS "option", params, enabled
  FROM avjos16_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_icagenda'
16. SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
  FROM `avjos16_icagenda_events` AS e
  WHERE e.state = 1 OR e.state = 0
17. SELECT DISTINCT(user_id)
  FROM avjos16_usergroups as ug1
  INNER JOIN avjos16_usergroups AS ug2
  ON ug2.lft=ug1.lft
  AND ug1.rgt=ug2.rgt
  INNER JOIN avjos16_user_usergroup_map AS m
  ON ug2.id=m.group_id
  WHERE ug1.id='8'
18. SELECT e.id, e.title, e.alias, e.state, e.approval, e.created_by_email, e.username, e.access, e.language, e.params, e.catid, e.image, e.file, e.displaytime, e.dates, e.period, e.startdate, e.enddate, e.weekdays, e.time, e.next, e.desc, e.metadesc, e.address, e.city, e.country, e.phone, e.email, e.name, e.website, e.place as place_name, e.coordinate as coordinate, e.lat as lat, e.lng as lng, c.id as cat_id, c.title as cat_title, c.color as cat_color, c.desc as cat_desc, c.alias as cat_alias
  FROM `avjos16_icagenda_events` AS e
  LEFT JOIN `avjos16_icagenda_category` AS c
  ON c.id = e.catid
  WHERE e.state =1
  AND e.approval <> 1
  AND e.next <> '%0000-00-00 00:00:00%'
  AND e.access IN (1, 1)
  AND (e.`language` = 'it-IT' OR e.`language` = '*')
  AND e.id=16
  ORDER BY e.next
  LIMIT 0, 10
19. SELECT next AS tNext, dates AS tDates, period AS tPeriod, id AS tId, state AS tState, access AS tAccess
  FROM `avjos16_icagenda_events` AS e
  WHERE e.state = 1
20. SELECT count(e.id) AS max
  FROM avjos16_icagenda_events AS e
  LIMIT 0, 10
21. SELECT DISTINCT(user_id)
  FROM avjos16_usergroups as ug1
  INNER JOIN avjos16_usergroups AS ug2
  ON ug2.lft=ug1.lft
  AND ug1.rgt=ug2.rgt
  INNER JOIN avjos16_user_usergroup_map AS m
  ON ug2.id=m.group_id
  WHERE ug1.id='8'
22. SELECT count(id) AS nbevents
  FROM avjos16_icagenda_events AS e
  WHERE (e.state = 1)
  AND (e.next != '0000-00-00 00:00:00')
  AND ((e.language = 'it-IT') OR (e.language = '*') OR (e.language = NULL) OR (e.language = ''))
  AND e.access IN (1, 1)
  AND e.approval <> 1
23. SELECT a.title, a.published, a.id
  FROM `avjos16_menu` AS a
  WHERE (link = 'index.php?option=com_icagenda&view=list')
  AND (published > 0)
24. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM avjos16_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(229)
  AND falang_content.reference_table='menu'
25. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
26. SELECT DISTINCT(user_id)
  FROM avjos16_usergroups as ug1
  INNER JOIN avjos16_usergroups AS ug2
  ON ug2.lft=ug1.lft
  AND ug1.rgt=ug2.rgt
  INNER JOIN avjos16_user_usergroup_map AS m
  ON ug2.id=m.group_id
  WHERE ug1.id='8'
27. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
28. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
29. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
30. SELECT c.color AS cat_color
  FROM avjos16_icagenda_category AS c
  WHERE (c.id=4)
31. SELECT sum(r.people) AS registered
  FROM avjos16_icagenda_registration AS r
  WHERE (r.eventId=16)
  AND (r.state > 0)
32. SELECT sum(r.people) AS registered
  FROM avjos16_icagenda_registration AS r
  WHERE (r.eventId=16)
  AND (r.state > 0)
33. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
34. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
35. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
36. SELECT sum(r.people) AS registered
  FROM avjos16_icagenda_registration AS r
  WHERE (r.eventId=16)
  AND (r.state > 0)
37. SELECT r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail
  FROM avjos16_icagenda_registration AS r
  WHERE (r.eventId=16)
  AND (r.state > 0)
38. SELECT sum(r.people) AS registered
  FROM avjos16_icagenda_registration AS r
  WHERE (r.eventId=16)
  AND (r.state > 0)
39. SELECT sum(r.people) AS registered
  FROM avjos16_icagenda_registration AS r
  WHERE (r.eventId=16)
  AND (r.state > 0)
40. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
41. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
42. SELECT alias
  FROM avjos16_icagenda_events
  WHERE id=16
43. SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
  FROM `avjos16_icagenda_events` AS e
  LEFT JOIN `avjos16_viewlevels` AS v
  ON v.id = e.access
  WHERE `e`.`id` = '16'
44. SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
  FROM `avjos16_icagenda_events` AS e
  LEFT JOIN `avjos16_viewlevels` AS v
  ON v.id = e.access
  WHERE `e`.`id` = '16'
45. SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
  FROM `avjos16_icagenda_events` AS e
  LEFT JOIN `avjos16_viewlevels` AS v
  ON v.id = e.access
  WHERE `e`.`id` = '16'
46. SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
  FROM `avjos16_icagenda_events` AS e
  LEFT JOIN `avjos16_viewlevels` AS v
  ON v.id = e.access
  WHERE `e`.`id` = '16'
47. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM avjos16_modules AS m
  LEFT JOIN avjos16_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN avjos16_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 <= '2024-04-19 01:08:09')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 01:08:09')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 229 OR mm.menuid <= 0)
  AND m.language IN ('it-IT','*')
  ORDER BY m.position, m.ordering
48. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM avjos16_falang_content AS falang_content
  WHERE falang_content.language_id=2
  AND falang_content.published=1
  AND falang_content.reference_id IN(193,138,155,173,174,192,108,144,113,171,191,83,73,30,76,96,194,195,176,170,166,42)
  AND falang_content.reference_table='modules'
49. SHOW TABLES
50. UPDATE `avjos16_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713488889;s:18:\"session.timer.last\";i:1713488889;s:17:\"session.timer.now\";i:1713488889;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\";N;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:10:\"date_value\";s:0:\"\";}' , `time` = '1713488889'
  WHERE `session_id` = 'p6qtb9p078li7c797pio9d5jg1'

24 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 10 × SELECT alias
  FROM avjos16_icagenda_events
2. 5 × SELECT sum(r.people) AS registered
  FROM avjos16_icagenda_registration AS r
3. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM avjos16_extensions
4. 4 × SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
  FROM `avjos16_icagenda_events` AS e
  LEFT JOIN `avjos16_viewlevels` AS v
  ON v.id = e.access
5. 3 × SELECT DISTINCT(user_id)
  FROM avjos16_usergroups as ug1
  INNER JOIN avjos16_usergroups AS ug2
  ON ug2.lft=ug1.lft
  AND ug1.rgt=ug2.rgt
  INNER JOIN avjos16_user_usergroup_map AS m
  ON ug2.id=m.group_id
6. 3 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM avjos16_falang_content AS falang_content
7. 2 × SELECT file_id
  from avjos16_jdownloads_files
8. 1 × SELECT a.title, a.published, a.id
  FROM `avjos16_menu` AS a
9. 1 × SELECT r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail
  FROM avjos16_icagenda_registration AS r
10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM avjos16_modules AS m
  LEFT JOIN avjos16_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN avjos16_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
11. 1 × SELECT c.color AS cat_color
  FROM avjos16_icagenda_category AS c
12. 1 × SELECT count(id) AS nbevents
  FROM avjos16_icagenda_events AS e
13. 1 × SELECT e.id, e.title, e.alias, e.state, e.approval, e.created_by_email, e.username, e.access, e.language, e.params, e.catid, e.image, e.file, e.displaytime, e.dates, e.period, e.startdate, e.enddate, e.weekdays, e.time, e.next, e.desc, e.metadesc, e.address, e.city, e.country, e.phone, e.email, e.name, e.website, e.place as place_name, e.coordinate as coordinate, e.lat as lat, e.lng as lng, c.id as cat_id, c.title as cat_title, c.color as cat_color, c.desc as cat_desc, c.alias as cat_alias
  FROM `avjos16_icagenda_events` AS e
  LEFT JOIN `avjos16_icagenda_category` AS c
  ON c.id = e.catid
14. 1 × SELECT joomlatablename,tablepkID
  FROM `avjos16_falang_tableinfo
15. 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 avjos16_menu AS m
  LEFT JOIN avjos16_extensions AS e
  ON m.component_id = e.extension_id
16. 1 × SELECT count(*)
  FROM `avjos16_cwtraffic`
17. 1 × SELECT *
  FROM avjos16_languages
18. 1 × SELECT id, home, template, s.params
  FROM avjos16_template_styles as s
  LEFT JOIN avjos16_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
19. 1 × SELECT next AS tNext, dates AS tDates, period AS tPeriod, id AS tId, state AS tState, access AS tAccess
  FROM `avjos16_icagenda_events` AS e
20. 1 × SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
  FROM `avjos16_icagenda_events` AS e
21. 1 × SELECT count(e.id) AS max
  FROM avjos16_icagenda_events AS e
  LIMIT 0, 1

ALTRE tabelle:

1. 3 × SHOW TABLE
2. 1 × UPDATE `avjos16_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713488889;s:18:\"session.timer.last\";i:1713488889;s:17:\"session.timer.now\";i:1713488889;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\";N;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:10:\"date_value\";s:0:\"\";}' , `time` = '1713488889'
3. 1 × SHOW FULL COLUMNS
  FROM `avjos16_languages