28 query eseguite

1. SELECT `data`
  FROM `beach_session`
  WHERE `session_id` = '470e1f6c440b4fd30b60f02028a58407'
2. DELETE
  FROM `beach_session`
  WHERE `time` < '1531723031'
3. SELECT `session_id`
  FROM `beach_session`
  WHERE `session_id` = '470e1f6c440b4fd30b60f02028a58407'
  LIMIT 0, 1
4. INSERT INTO `beach_session` (`session_id`, `client_id`, `time`)
  VALUES ('470e1f6c440b4fd30b60f02028a58407', 0, '1531723931')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM beach_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM beach_usergroups AS a
  LEFT JOIN beach_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `beach_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM beach_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1)
  ORDER BY ordering
9. SELECT *
  FROM beach_languages
  WHERE published=1
  ORDER BY ordering ASC
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM beach_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
11. SELECT language,id
  FROM `beach_menu`
  WHERE home = 1
  AND published = 1
  AND client_id = 0
12. 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 beach_menu AS m
  LEFT JOIN beach_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
13. SELECT id, home, template, s.params
  FROM beach_template_styles as s
  LEFT JOIN beach_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. SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM beach_modules AS m
  LEFT JOIN beach_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN beach_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-07-16 06:52:11')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-07-16 06:52:11')
  AND m.access IN (1)
  AND m.client_id = 0
  AND (mm.menuid = 435 OR mm.menuid <= 0)
  AND m.language IN ('it-IT','*')
  ORDER BY m.position, m.ordering
15. SELECT extension_id AS id, element AS "option", params, enabled
  FROM beach_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
16. SELECT a.rules
  FROM beach_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
17. SELECT b.rules
  FROM beach_assets AS a
  LEFT JOIN beach_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
18. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM beach_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by
  AND (contact.language in ('it-IT','*') OR contact.language IS NULL)) 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,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM beach_content AS a
  LEFT JOIN beach_categories AS c
  ON c.id = a.catid
  LEFT JOIN beach_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN beach_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN beach_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN beach_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM beach_categories AS cat JOIN beach_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
  INNER JOIN beach_content_frontpage AS fp
  ON fp.content_id = a.id
  WHERE a.access IN (1)
  AND c.access IN (1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-07-16 06:52:11')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-07-16 06:52:11')
  AND a.language in ('it-IT','*')
  AND a.catid IN (92)
  ORDER BY a.ordering, a.created DESC
  LIMIT 0, 4
19. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM beach_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by
  AND (contact.language in ('it-IT','*') OR contact.language IS NULL)) 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,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM beach_content AS a
  LEFT JOIN beach_categories AS c
  ON c.id = a.catid
  LEFT JOIN beach_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN beach_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN beach_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN beach_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM beach_categories AS cat JOIN beach_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
  INNER JOIN beach_content_frontpage AS fp
  ON fp.content_id = a.id
  WHERE a.access IN (1)
  AND c.access IN (1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-07-16 06:52:11')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-07-16 06:52:11')
  AND a.language in ('it-IT','*')
  AND a.catid IN (92)
  ORDER BY a.ordering, a.created DESC
20. SELECT extension_id AS id, element AS "option", params, enabled
  FROM beach_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_phocagallery'
21. SELECT extension_id AS id, element AS "option", params, enabled
  FROM beach_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contact'
22. SELECT extension_id AS id, element AS "option", params, enabled
  FROM beach_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_phocaguestbook'
23. SELECT extension_id AS id, element AS "option", params, enabled
  FROM beach_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_weblinks'
24. SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid
  FROM beach_phocagallery_categories AS cc
  WHERE cc.published = 1
  AND cc.access IN (1)
  AND cc.id IN (20)
  ORDER BY cc.ordering
25. SELECT cc.id AS idcat, a.id AS idimage
  FROM beach_phocagallery_categories AS cc
  LEFT JOIN beach_phocagallery AS a
  ON a.catid = cc.id
  WHERE a.published = 1
  AND a.approved = 1
  AND cc.published = 1
  AND cc.id IN (20)
  ORDER BY a.ordering ASC
  LIMIT 0,150
26. SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM beach_phocagallery_categories AS cc
  LEFT JOIN beach_phocagallery AS a
  ON a.catid = cc.id
  WHERE a.id in (518,226,249,399,250,520,400,228,251,521,252,403,298,253,52,254,508,256,257,510,258,511,259,260,513,261,307,262,515,240,413,263,264,265,415,266,267,268,269,270,271,272,422,273,318,423,274,275,276,277,278,77,279,429,280,281,282,283,328,284,285,286,288,439,290,291,443,449,454,459,464,468,476,479,481,484,334,337,338,349,350,354,356,358,359,361,363,366,367,369,375,377,382,385,389,395)
  ORDER BY a.ordering ASC
27. SELECT m2.language, m2.id
  FROM beach_menu as m
  INNER JOIN beach_associations as a
  ON a.id=m.id
  AND a.context='com_menus.item'
  INNER JOIN beach_associations as a2
  ON a.key=a2.key
  INNER JOIN beach_menu as m2
  ON a2.id=m2.id
  WHERE m.id=435
28. UPDATE `beach_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1531723931;s:18:\"session.timer.last\";i:1531723931;s:17:\"session.timer.now\";i:1531723931;s:24:\"session.client.forwarded\";s:12:\"54.161.40.41\";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\":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:1:{i:0;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;}}' , `time` = '1531723932'
  WHERE `session_id` = '470e1f6c440b4fd30b60f02028a58407'

21 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 7 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM beach_extensions
2. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM beach_contact_details AS contact
3. 1 × SELECT b.rules
  FROM beach_assets AS a
  LEFT JOIN beach_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
4. 1 × SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid
  FROM beach_phocagallery_categories AS cc
5. 1 × SELECT a.rules
  FROM beach_assets AS a
6. 1 × SELECT cc.id AS idcat, a.id AS idimage
  FROM beach_phocagallery_categories AS cc
  LEFT JOIN beach_phocagallery AS a
  ON a.catid = cc.id
7. 1 × SELECT m2.language, m2.id
  FROM beach_menu as m
  INNER JOIN beach_associations as a
  ON a.id=m.id
  AND a.context='com_menus.item'
  INNER JOIN beach_associations as a2
  ON a.key=a2.key
  INNER JOIN beach_menu as m2
  ON a2.id=m2.id
8. 1 × SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM beach_phocagallery_categories AS cc
  LEFT JOIN beach_phocagallery AS a
  ON a.catid = cc.id
9. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM beach_modules AS m
  LEFT JOIN beach_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN beach_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
10. 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 beach_menu AS m
  LEFT JOIN beach_extensions AS e
  ON m.component_id = e.extension_id
11. 1 × SELECT id, rules
  FROM `beach_viewlevels
12. 1 × SELECT b.id
  FROM beach_usergroups AS a
  LEFT JOIN beach_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
13. 1 × SELECT `session_id`
  FROM `beach_session`
14. 1 × SELECT folder AS type, element AS name, params
  FROM beach_extensions
15. 1 × SELECT *
  FROM beach_languages
16. 1 × SELECT `data`
  FROM `beach_session`
17. 1 × SELECT language,id
  FROM `beach_menu`
18. 1 × SELECT id, home, template, s.params
  FROM beach_template_styles as s
  LEFT JOIN beach_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id

ALTRE tabelle:

1. 1 × UPDATE `beach_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1531723931;s:18:\"session.timer.last\";i:1531723931;s:17:\"session.timer.now\";i:1531723931;s:24:\"session.client.forwarded\";s:12:\"54.161.40.41\";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\":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:1:{i:0;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;}}' , `time` = '1531723932'
2. 1 × INSERT INTO `beach_session` (`session_id`, `client_id`, `time`)
  VALUES ('470e1f6c440b4fd30b60f02028a58407', 0, '1531723931'
3. 1 × DELETE
  FROM `beach_session`