Securing the Future PortalHealth and Social Care PortalEfficiency and Productivity Portal

The ‘Pause’ has ended, the NHS Future Forum have reported and the Government has responded.Meanwhile, the Health & Social Care Bill continues to go through Parliament and heads for the Lords. Has anything changed?

Clinical Commissioning Groups (CCGs), previously known as GP Commissioning Consortia, have felt more than a little left out. Their future has been discussed by the NHS Future Forum, which consisted of many more managers and secondary care clinicians than GPs. The new CCGs will have to have a nurse and consultant on their governing board and their plans (and any changes to them) ratified by the Health & Wellbeing Board with clinical senates and clinical networks adding another lot of seeming ‘nosey parkers’, who can quash their plans. What happened to the Health White Paper’s promise of commissioning groups having “assumed responsibility” rather than “earned autonomy”?

Are we still on track for an NHS whose behaviour is dictated not by high-minded centralism but from the frontline consulting room? In short, have CCGs had their wings clipped? For most commentators the answer to that question is a resounding ‘yes!’. It is an impression that is not much altered by the widely-leaked plans of the new National Commissioning Board. While every Tom, Dick and Harry was commenting on CCGs – who should be on their Board, what they should do and to whom they should be accountable – the mandarins at the centre of the NHS quietly drew up their own draft proposals for the new National Commissioning Board, which have been issued for consultation. Those plans look very much like a Department of Health ‘off-the-shelf’ model. The Board will have the usual Medical Director (presumably as usual from secondary care), Nursing Director and leads in the five areas of Government policy.

Nowhere in the plans, as far as I can see, is there more than tokenistic recognition that the rules of the game have changed. There is no direct connection to CCGs and more than a hint that they will be sorted through born-again PCT clusters acting more or less as Strategic Health Authorities do at present. The National Commissioning Board looks like ‘NHS mission control’ and not the promised ‘support for clinical commissioning groups’. Why on earth aren’t they featured on it?

Phoney war

You may say that all this sounds depressing. I will admit to having been in a deep depression over the past two months. I am past that now because it is now abundantly clear that things have changed and are about to change utterly. The ‘Pause’ will, in retrospect, be seen to have been a ‘phoney war’. Idealists, some well-meaning and some full of wind, have been battling it out, while the solutions have been staring us all in the face. Those solutions are simply about how we transfer appropriate services from secondary to primary care and how we de-professionalise care and better enable individuals and communities We have done pitifully little of all of that to date and when everyone puts their boxing gloves away, these problems and the much-needed solutions will be exactly the same as they were before it all began. So the outcome of all this is that CCGs will go forward because they have to go forward.

We may have restrictions, but in truth some CCGs already have nurses and consultants on their Boards anyway. Those being held back by their PCT clusters will become bolshy, rightly so. They will increasingly show that they are the new order and increasingly show that they can deliver, like so many have in our recent NHS Alliance document Making it Better. There are now too many CCG leaders with the bit between their teeth. They are good, talented and principled people, who are concerned about their patients and prepared to fight off any forces that stand in their way. The less strong leaders simply need to realise that there are not really any rule books now. No-one else is going to liberate them, they must liberate themselves. NHS Alliance will support their cause.


Nicholson’s diary

What about the National Commissioning Board? The worst case scenario is that it proceeds according to the plans of its first draft and becomes an inward-looking autocracy with its own agenda, trying to dictate to CCGs. Its leaders will then pull on all of the old levers that used to get things done – but find the cogs and strings are broken and nothing happens. I think that is unlikely. David Nicholson is in a very odd situation. Everyone is prattling on about corporate governance, yet we have a Commissioning Board, where there is now a chief executive long before the non-exec majority have been nominated or had a chance to get their feet under the table! Which rule book of corporate governance did that come from? I hear people say that David Nicholson is now running the NHS with a rod of iron. It’s an illusion.

The NHS accounts may seem reasonably satisfactory to outsiders at present but unless we actually do something and create changes to practice and services at the frontline, the only direction is downwards. In truth, he is a man without clothes and unable to push the buttons or pull the levers of the past. He is far too intelligent to continue in this state of undress and lead a dysfunctional National Commissioning Board hoping the NHS will continue to obey the rules of old centralism. He will sue for peace. He will recognise that CCGs and the National Commissioning Board will rise or fall together. He will make sure that the National Commissioning Board is a mirror reflection of those CCGs; that they see him as their paths to success and vice versa. If this prediction is correct then expect his diary to change from seeing mainly senior DH managers and SHA chiefs or secondary care consultants and managers to a diary that prioritises CCG group leaders and an increasing number of primary care clinicians.

Sweat and status

We all have to change a little. PCT clusters must become servants not masters. CCGs must grasp the gauntlet and persuade their frontline clinicians to join the effort rather than take to the hills. David Nicholson needs to see his role as facilitator not controller. NHS Alliance needs to raise its game to become an ever-more fiercely supportive organisation of frontline clinical commissioners. These changes, all of them essential, can now be achieved without too much sweat or spilt blood if we can all recognise that the rules of the game have changed forever. Some Royal Colleges will protest, senior managers will bemoan their perceived lost status, frontline clinicians will say they are being shackled and the media will say this is one reform too much. Their wrong assumption is that the present system has done anything substantial to improvproductivity, to mainstream innovation, to support radical redesign or even to put patients first.

Improving secondary care waiting lists and introducing the GP Quality Framework were the gods of yesterday. Since then, the NHS has failed to stretch itself towards the new and more urgent priorities that it now faces. That is why CCGs represent the only cavalry that we have. That is why the NHS around them – whether it be PCT clusters, the National Commissioning Board, frontline primary care or Foundation Trusts – must now adapt to their existence, rather than vice versa. To assume that CCGs will be simply ‘will-o’-the-wisp’ and we can carry on as normal is no longer an option in any sense!

T H E  N H S A L L I A N C E :

• Is strongly supportive of Clinical Commissioning, with the purpose of improving population health and health care to individuals. The NHS Alliance
believes that there should be an appropriate balance between local freedom to meet local needs and accountability both to the centre and local
populations.

• Believes that Clinical Commissioning Group Boards should have GPs as majority members. Boards need to ensure the appropriate involvement of other clinicians and managers and have a strong representation from local communities and Independent Directors.

• Considers that NHS Commissioning is and should continue to be a function exercised by statutory bodies in the public sector alone.Recognises that NHS provision is already distributed across public, third, and independent sectors, which should continue where it can be shown in the public interest. Competition is a means to an end and not an end in itself. Those providing NHS services should clearly subscribe to NHS values of openness, transparency and accountability and behave in a manner consistent with those values.

• Is supportive of an NHS that promotes the delivery of integrated care, both vertically and horizontally. We believe that this requires reform of payment systems, particularly Payment by Results. This includes the ability of Clinical Commissioning Groups to set activity caps and financial ceilings.

• Is concerned that the new structure will be cumbersome and top down. The NHS Commissioning Board may have too much power and requires better two way connections to clinical commissioning groups, locally and nationally – as an organisation that enables rather than controls their work. The NHS Alliance wishes to see a strengthening of the Secretary of State's mandate to intervene if the National Commissioning Board becomes a hindrance to the autonomy of clinical commissioning groups.

• Welcomes the creation of Clinical Senates, Clinical Networks, and Local Health and Wellbeing Boards as a means of wider clinical involvement. They
should help, not hinder Clinical Commissioning Groups however, who are the final decision makers for their patients.

• Considers that Monitor and CQC should be required to demonstrate that they are acting in pursuit of the public interest. Their decisions and policies should be subject to challenge by commissioning groups.

• Is supportive of the purpose of Quality premiums to reward those Clinical Commissioning Groups that commission effectively. Regulations should require that Premiums should only be used to enhance patient services.

This article was first published by The National Health Executive magazine

Written by Dr Michael Dixon
Monday, 26 September 2011 9:09

Add comment



Refresh

Most Read Tags

Interviews

The Govtoday Debate

David Wathey, Head of Sustainable Procurement, Department of Health

FORTHCOMING EVENTS / POST-EVENT DEBATES

GovToday Limited Peter House Oxford Street Manchester M1 5AN

Copyright © 2012 Govtoday. All Rights Reserved.

Profile Information

Application 0.001 seconds (+0.001); 1.15 MB (+1.151) - afterLoad
Application 0.047 seconds (+0.047); 6.35 MB (+5.200) - afterInitialise
Application 0.076 seconds (+0.029); 12.01 MB (+5.656) - afterRoute
Application 0.110 seconds (+0.034); 15.87 MB (+3.865) - afterDispatch
Application 0.115 seconds (+0.005); 16.17 MB (+0.296) - beforeRenderModule mod_footer (Footer)
Application 0.116 seconds (+0.001); 16.20 MB (+0.035) - afterRenderModule mod_footer (Footer)
Application 0.116 seconds (+0.000); 16.20 MB (-0.003) - beforeRenderModule mod_menu (Footer Menu)
Application 0.120 seconds (+0.004); 16.27 MB (+0.073) - afterRenderModule mod_menu (Footer Menu)
Application 0.120 seconds (+0.000); 16.27 MB (-0.007) - beforeRenderModule mod_gov_tv (Govtoday TV)
Application 0.123 seconds (+0.003); 16.31 MB (+0.042) - afterRenderModule mod_gov_tv (Govtoday TV)
Application 0.123 seconds (+0.000); 16.28 MB (-0.023) - beforeRenderModule mod_banners (FORTHCOMING EVENTS / POST-EVENT DEBATES)
Application 0.129 seconds (+0.006); 16.56 MB (+0.280) - afterRenderModule mod_banners (FORTHCOMING EVENTS / POST-EVENT DEBATES)
Application 0.129 seconds (+0.000); 16.55 MB (-0.017) - beforeRenderModule mod_gtsearch (GT Search)
Application 0.130 seconds (+0.001); 16.56 MB (+0.015) - afterRenderModule mod_gtsearch (GT Search)
Application 0.130 seconds (+0.000); 16.56 MB (-0.002) - beforeRenderModule mod_feature (Editor's Feature)
Application 0.193 seconds (+0.063); 16.60 MB (+0.040) - afterRenderModule mod_feature (Editor's Feature)
Application 0.193 seconds (+0.000); 16.60 MB (+0.001) - beforeRenderModule mod_comments_read (Comment and Most Read)
Application 0.223 seconds (+0.030); 16.65 MB (+0.048) - afterRenderModule mod_comments_read (Comment and Most Read)
Application 0.223 seconds (+0.000); 16.66 MB (+0.015) - beforeRenderModule mod_gttag (Most Read Tags)
Application 0.234 seconds (+0.011); 16.80 MB (+0.139) - afterRenderModule mod_gttag (Most Read Tags)
Application 0.234 seconds (+0.000); 16.77 MB (-0.039) - beforeRenderModule mod_menu (Gov Menu)
Application 0.242 seconds (+0.008); 16.79 MB (+0.026) - afterRenderModule mod_menu (Gov Menu)
Application 0.242 seconds (+0.000); 16.79 MB (-0.004) - beforeRenderModule mod_menu (Top Menu)
Application 0.245 seconds (+0.003); 16.80 MB (+0.014) - afterRenderModule mod_menu (Top Menu)
Application 0.245 seconds (+0.000); 16.79 MB (-0.013) - beforeRenderModule mod_syndicate (Syndication)
Application 0.247 seconds (+0.002); 16.84 MB (+0.048) - afterRenderModule mod_syndicate (Syndication)
Application 0.247 seconds (+0.000); 16.84 MB (+0.001) - beforeRenderModule mod_cblogin (CB Login)
Application 0.259 seconds (+0.012); 18.76 MB (+1.924) - afterRenderModule mod_cblogin (CB Login)
Application 0.264 seconds (+0.005); 18.84 MB (+0.076) - afterRender

Memory Usage

18.86 MB (19,776,192 Bytes)

76 Queries Logged

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '7op7pud180fdav772gqv2ejns4'
  2. DELETE
      FROM `jos_session`
      WHERE `time` < 1330901729
  3. SELECT folder AS type, element AS name, params
      FROM jos_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1)
      ORDER BY ordering
  4. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kunena'
  6. SELECT m.id, m.menutype, m.title, m.alias, 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 jos_menu AS m
      LEFT JOIN jos_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
  7. SELECT *
      FROM jos_jcomments_settings
  8. select *
      from jos_web
      where weburl like '%http://www.govtoday.co.uk/%'
      LIMIT 0, 1
  9. SELECT id, home, template, s.params
      FROM jos_template_styles as s
      LEFT JOIN jos_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
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT *
      FROM jos_languages
      WHERE published=1
      ORDER BY ordering ASC
  12. SELECT b.rules
      FROM jos_assets AS a
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.name = 'com_content'
      ORDER BY b.lft
  13. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  14. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id 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 ) AS rating, v.rating_count as rating_count
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      on c.id = a.catid
      LEFT JOIN jos_users AS u
      on u.id = a.created_by
      LEFT JOIN jos_contact_details AS contact
      on contact.user_id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE a.id = 8052
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-03-05 00:55:29')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-03-05 00:55:29')
  15. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jos_categories as c
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_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
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1)
      AND c.published = 1
      AND s.id=12
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  16. select *
      from jos_tag_term_content as a, jos_tag_term as b
      where a.tid = b.id
      and a.cid = 8052
  17. SELECT *
      FROM `jos_jcomments_objects`
      WHERE `object_id` = '8052'
      AND `object_group` = 'com_content'
      AND `lang` = 'en-GB'
  18. SELECT count(*)
      FROM jos_jcomments AS c
      WHERE c.object_id = 8052
      AND c.object_group = 'com_content'
      AND c.published = 1
  19. UPDATE jos_content
      SET hits = hits + 1
      WHERE id = 8052
  20. select (a.catid)catid,(b.level)level
      from jos_content as a, jos_categories as b
      where a.catid = b.id
      and a.id = 8052
  21. SELECT *
      FROM jos_categories
      WHERE id='12'
  22. SELECT *
      FROM jos_categories
      WHERE id='12'
  23. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_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 <= '2012-03-05 00:55:29')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-03-05 00:55:29')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  24. select *
      from jos_web_media
      where active = 1
      and webtype = 'interview'
      and govtoday = 1
      order by id desc
      limit 10
  25. SELECT *
      FROM jos_banners
      WHERE NOW() >= `reset`
      AND `reset` != '0000-00-00 00:00:00'
      AND `reset`!=NULL
      AND (`checked_out` = 0 OR `checked_out` = 0)
  26. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM jos_banners as a
      LEFT JOIN jos_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN jos_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 2
      AND cl.state = 1
      AND a.catid IN (130)
      ORDER BY a.sticky DESC,a.ordering
  27. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
      FROM jos_banners as a
      LEFT JOIN jos_banner_clients AS cl
      ON cl.id = a.cid
      LEFT JOIN jos_categories as cat
      ON a.catid = cat.id
      WHERE a.state=1
      AND (NOW() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
      AND (NOW() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
      AND a.cid = 2
      AND cl.state = 1
      AND a.catid IN (130)
      ORDER BY a.sticky DESC,a.ordering
      LIMIT 0, 3
  28. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 6
  29. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 7
  30. UPDATE jos_banners
      SET impmade = (impmade + 1)
      WHERE id = 1
  31. select *
      from jos_event_web as a
      inner join jos_web as b
      on b.id = a.webid
      where main = 1
      and webid = 2
  32. select id,title,catid,introtext,created_by
      from jos_content
      where state = 1
      and attribs like '%"feature":"1"%'
      order by created desc
      limit 6
  33. select id,title,catid,introtext,created_by
      from jos_content
      where state = 1
      and attribs like '%"feature":"1"%'
      order by created desc
      limit 6
  34. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 28203
  35. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 43
  36. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 23436
  37. SELECT *
      FROM jos_categories
      WHERE id='31'
  38. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 31
  39. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 9264
  40. SELECT *
      FROM jos_categories
      WHERE id='12'
  41. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 12
  42. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 28076
  43. SELECT *
      FROM jos_categories
      WHERE id='106'
  44. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 106
  45. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 28034
  46. SELECT *
      FROM jos_categories
      WHERE id='21'
  47. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 21
  48. select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar
      from jos_users as a,jos_comprofiler as b
      where a.id = b.user_id
      and a.id = 27984
  49. SELECT *
      FROM jos_categories
      WHERE id='106'
  50. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 106
  51. SELECT *
      FROM jos_categories
      WHERE id='43'
  52. select *
      from jos_jcomments
      where object_group = 'com_content'
      and published = 1
      order by id desc
      limit 5
  53. select *
      from jos_comprofiler
      where user_id = '703'
  54. select *
      from jos_content
      where id = 9836
  55. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  56. select *
      from jos_comprofiler
      where user_id = '702'
  57. select *
      from jos_content
      where id = 9836
  58. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  59. select *
      from jos_comprofiler
      where user_id = '27989'
  60. select *
      from jos_content
      where id = 9836
  61. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  62. select *
      from jos_comprofiler
      where user_id = '4322'
  63. select *
      from jos_content
      where id = 9836
  64. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  65. select *
      from jos_comprofiler
      where user_id = '0'
  66. select *
      from jos_content
      where id = 10013
  67. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 14
  68. select *
      from jos_content
      where state = 1
      and created >= '2011-11-14 12:11:29'
      order by hits desc
      limit 5
  69. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 10
  70. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 16
  71. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 108
  72. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 109
  73. select (b.id)id
      from jos_categories as a,jos_menu as b
      where a.path = b.path
      and a.id = 29
  74. select *
      from jos_tag_term
      order by hits desc
      limit 25
  75. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published=1
      AND access <= 1
  76. UPDATE `jos_session`
      SET `data` = '__default|a:7:{s:15:\"session.counter\";i:15;s:19:\"session.timer.start\";i:1330907045;s:18:\"session.timer.last\";i:1330908840;s:17:\"session.timer.now\";i:1330908929;s:22:\"session.client.browser\";s:89:\"Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{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: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;}}', `time` = 1330908929
      WHERE `session_id` = '7op7pud180fdav772gqv2ejns4'

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 16 × select (b.id)id from jos_categories as a,jos_menu as b
  2. 8 × SELECT * FROM jos_categories
  3. 6 × select * from jos_content
  4. 6 × select (a.username)username,(a.email)email,(b.firstname)firstname,(b.lastname)lastname,(b.cb_org)cb_org,(b.cb_title)cb_title,(b.cb_jobtitle)cb_jobtitle,(b.avatar)avatar from jos_users as a,jos_comprofiler as b
  5. 5 × select * from jos_comprofiler
  6. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
  7. 2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions FROM jos_banners as a LEFT JOIN jos_banner_clients AS cl ON cl.id = a.cid LEFT JOIN jos_categories as cat ON a.catid = cat.id
  8. 2 × select id,title,catid,introtext,created_by from jos_content
  9. 1 × select * from jos_web_media
  10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  11. 1 × SELECT * FROM jos_banners
  12. 1 × select * from jos_jcomments
  13. 1 × select * from jos_tag_term
  14. 1 × select * from jos_event_web as a inner join jos_web as b on b.id = a.webid
  15. 1 × SELECT id FROM jos_menu
  16. 1 × select (a.catid)catid,(b.level)level from jos_content as a, jos_categories as b
  17. 1 × select * from jos_web
  18. 1 × SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  19. 1 × SELECT * FROM jos_jcomments_setting
  20. 1 × SELECT m.id, m.menutype, m.title, m.alias, 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 jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
  21. 1 × SELECT folder AS type, element AS name, params FROM jos_extensions
  22. 1 × SELECT * FROM jos_languages
  23. 1 × SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  24. 1 × SELECT * FROM `jos_jcomments_objects`
  25. 1 × SELECT count(*) FROM jos_jcomments AS c
  26. 1 × select * from jos_tag_term_content as a, jos_tag_term as b
  27. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN jos_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  28. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id 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 ) AS rating, v.rating_count as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  29. 1 × SELECT `data` FROM `jos_session`
OTHER Tables:
  1. 3 × UPDATE jos_banners SET impmade = (impmade + 1)
  2. 1 × UPDATE `jos_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:15;s:19:\"session.timer.start\";i:1330907045;s:18:\"session.timer.last\";i:1330908840;s:17:\"session.timer.now\";i:1330908929;s:22:\"session.client.browser\";s:89:\"Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{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: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;}}', `time` = 1330908929
  3. 1 × UPDATE jos_content SET hits = hits + 1
  4. 1 × DELETE FROM `jos_session`