{
   
}

query 1: select * from userSession where sessionId=?
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ']
query 2: select * from settings
query 3: update userSession set adminOn=?, userId=?, lastIP=?, lastPageView=?, expires=? where sessionId=?
  with placeholders:  ['0', '1', '38.107.191.115', '1283950645', '1283954245', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 4: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/vacaturebank']
query 5: select name,value from userSessionScratch where sessionId=?
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ']
query 6: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['r0zKrVQa_ZLRItujjV7QMQ', '']
query 7: select asset.assetId, asset.className, asset.parentId, assetData.revisionDate from asset left join assetData on asset.assetId=assetData.assetId where asset.state='published' and (assetData.status='approved' or assetData.tagId=NULL) and (asset.className not like 'WebGUI::Asset::Wobject::Layout%') and ((asset.parentId='r0zKrVQa_ZLRItujjV7QMQ')) and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId and (assetData.status='approved' or assetData.tagId=NULL)) group by assetData.assetId order by asset.lineage asc
query 8: select groupId from groups where groupId=?
  with placeholders:  ['3']
query 9: select asset.assetId, asset.className, asset.parentId, assetData.revisionDate from asset left join assetData on asset.assetId=assetData.assetId where asset.state='published' and (assetData.status='approved' or assetData.tagId=NULL) and (asset.className not like 'WebGUI::Asset::Wobject::Layout%') and ((asset.parentId='r0zKrVQa_ZLRItujjV7QMQ')) and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId and (assetData.status='approved' or assetData.tagId=NULL)) group by assetData.assetId order by asset.lineage asc
query 10: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBtmpl0000000000000054', '']
query 11: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_ea92e98a7df3ad26', '']
query 12: select className from asset where assetId='nDCJm9pcBgSHCBGxoLWo1A'
query 13: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['nDCJm9pcBgSHCBGxoLWo1A', '']
query 14: Select distinct assetData.synopsis From Shortcut Inner Join asset ON Shortcut.assetId = asset.assetId Inner Join assetData ON asset.assetId=assetData.assetId Where asset.state = 'published' AND asset.parentId = (select assetId from assetData where url='leden/vacaturebank' and revisionDate= (select max(revisionDate) from assetData where url='leden/vacaturebank' )) and assetData.revisionDate = (Select max(assetData.revisionDate) From Shortcut Inner Join asset ON Shortcut.assetId = asset.assetId Inner Join assetData ON asset.assetId=assetData.assetId Where asset.state = 'published' AND asset.parentId = (select assetId from assetData where url='leden/vacaturebank' and revisionDate= (select max(revisionDate) from assetData where url='leden/vacaturebank' )))
query 15: Select distinct assetData.synopsis From Shortcut Inner Join asset ON Shortcut.assetId = asset.assetId Inner Join assetData ON asset.assetId=assetData.assetId Where asset.state = 'published' AND url='leden/vacaturebank' and assetData.revisionDate =(Select max(assetData.revisionDate) From Shortcut Inner Join asset ON Shortcut.assetId = asset.assetId Inner Join assetData ON asset.assetId=assetData.assetId Where asset.state = 'published' AND url='leden/vacaturebank' )
query 16: select groupId from groups where groupId=?
  with placeholders:  ['yCPQyxIuP00BOqeT2hTJZg']
query 17: select groupId from groups where groupId=?
  with placeholders:  ['MtJtrwq3PX0mz5JadisdsQ']
query 18: select userId from groupings where expireDate > ? and groupId = ?
  with placeholders:  ['0', 'MtJtrwq3PX0mz5JadisdsQ']
query 19: select * from groups where groupId=?
  with placeholders:  ['MtJtrwq3PX0mz5JadisdsQ']
query 20: select groupId from groupGroupings where inGroup=?
  with placeholders:  ['MtJtrwq3PX0mz5JadisdsQ']
query 21: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'FhnS9S_GUUwKFmFoL9fWEQ_sortBy', '']
query 22: select template FROM template where assetId ='ewise_df9c18388e5f8290' and revisionDate =(select max(revisionDate) from template where assetId ='ewise_df9c18388e5f8290')
query 23: SELECT SQL_CALC_FOUND_ROWS asset.*,assetData.*,EwiseThread.*,username,content,EwisePost.storageId,EwisePost.dateSubmitted,EwisePost.dateUpdated,EwisePost.assetId,EwisePost.revisionDate,EwisePost.threadId,EwisePost.rating,EwisePost.views ,HTMLArea1 From asset
Inner Join EwisePost ON EwisePost.assetId = asset.assetId
Inner Join assetData on assetData.assetId = asset.assetId and assetData.revisionDate= EwisePost.revisionDate
Inner Join EwiseThread on EwiseThread.assetId = asset.assetId and EwiseThread.revisionDate= EwisePost.revisionDate
where asset.parentId='FhnS9S_GUUwKFmFoL9fWEQ' and asset.className='WebGUI::Asset::EwisePost::EwiseThread' and state='published' and (assetData.status='approved'
or assetData.tagId=NULL) and EwisePost.revisionDate=( select max(EwisePost.revisionDate) From EwisePost where EwisePost.assetId=asset.assetId ) order by EwiseThread.isSticky desc, dateSubmitted desc LIMIT 0,30
query 24: select found_rows()
query 25: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['postSql', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 26: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'FhnS9S_GUUwKFmFoL9fWEQ_sortBy', '']
query 27: select template FROM template where assetId ='ewise_df9c18388e5f8290' and revisionDate =(select max(revisionDate) from template where assetId ='ewise_df9c18388e5f8290')
query 28: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'postSql', 'Select asset.*,assetData.*,EwiseThread.*,username,content,EwisePost.storageId,EwisePost.dateSubmitted,EwisePost.dateUpdated,EwisePost.assetId,EwisePost.revisionDate,EwisePost.threadId,EwisePost.rating,EwisePost.views ,HTMLArea1 From asset
Inner Join EwisePost ON EwisePost.assetId = asset.assetId
Inner Join assetData on assetData.assetId = asset.assetId and assetData.revisionDate= EwisePost.revisionDate
Inner Join EwiseThread on EwiseThread.assetId = asset.assetId and EwiseThread.revisionDate= EwisePost.revisionDate
where asset.parentId='FhnS9S_GUUwKFmFoL9fWEQ' and asset.className='WebGUI::Asset::EwisePost::EwiseThread' and state='published' and (assetData.status='approved'
or assetData.tagId=NULL) and EwisePost.revisionDate=( select max(EwisePost.revisionDate) From EwisePost where EwisePost.assetId=asset.assetId ) order by EwiseThread.isSticky desc, dateSubmitted desc']
query 29: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'FhnS9S_GUUwKFmFoL9fWEQ_sortBy', '']
query 30: select threadId,lineage From asset
Inner Join EwisePost ON EwisePost.assetId = asset.assetId
Inner Join assetData on assetData.assetId = asset.assetId and assetData.revisionDate= EwisePost.revisionDate
Inner Join EwiseThread on EwiseThread.assetId = asset.assetId and EwiseThread.revisionDate= EwisePost.revisionDate
where asset.parentId='FhnS9S_GUUwKFmFoL9fWEQ' and asset.className='WebGUI::Asset::EwisePost::EwiseThread' and state='published' and (assetData.status='approved'
or assetData.tagId=NULL) and EwisePost.revisionDate=( select max(EwisePost.revisionDate) From EwisePost where EwisePost.assetId=asset.assetId ) order by EwiseThread.isSticky desc, dateSubmitted desc
query 31: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['-WRP4o0zoDsZERf20y2U2g', '38.107.191.115']
query 32: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['AjOnQ-UkTXWrxQGEvOZxRQ', '38.107.191.115']
query 33: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['b-4xO4e7liVAz6k2TVqezA', '38.107.191.115']
query 34: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['jMaYAVzaXLAz_7ddJrIFSQ', '38.107.191.115']
query 35: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['A-gJ5xIj27v7iBbYJQumcQ', '38.107.191.115']
query 36: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['NL19bvbG1sgm87oJWLsbfg', '38.107.191.115']
query 37: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['qj8CwqAI9WnKlOP3vo2xqw', '38.107.191.115']
query 38: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['p3fl67l7mY61UBNAqs-5tg', '38.107.191.115']
query 39: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['67xiiiZlYaIuZxgXXYWlUg', '38.107.191.115']
query 40: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['07uXtgf_alUt0OzRCHtWPQ', '38.107.191.115']
query 41: select count(*) from EwisePost_rating where assetId=? and ipAddress=?
  with placeholders:  ['efTdxqpoXBplJmE189htow', '38.107.191.115']
query 42: delete from userSessionScratch where name=? and sessionId=?
  with placeholders:  ['items', 'ke_QWOa1uTMARZ5T2WHGwQ']
query 43: insert into userSessionScratch (sessionId, name, value) values (?,?,?) on duplicate key update value=VALUES(value)
  with placeholders:  ['ke_QWOa1uTMARZ5T2WHGwQ', 'items', '11']
MISS
query 44: select groupId from groups where groupId=?
  with placeholders:  ['2']
query 45: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PwNXWFH4E7CKrG614tZW8A', '']
query 46: select groupId from groups where groupName=?
  with placeholders:  ['Admins']
query 47: select groupId from groups where groupName=?
  with placeholders:  ['Admins']
query 48: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['menu']
query 49: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['cM8Lblc9XE-tDX57zNIIyg', '']
query 50: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ZQ_RHjZxwX0bhwaDnHQ8iA', '']
query 51: select assetId, className from asset where lineage=?
  with placeholders:  ['000001']
query 52: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['PBasset000000000000001', '']
query 53: select asset.assetId, asset.className, asset.parentId, assetData.revisionDate from asset left join assetData on asset.assetId=assetData.assetId where asset.state='published' and (assetData.status='approved' or assetData.tagId=NULL) and ( (asset.parentId='infinity' and asset.assetId<>'PBasset000000000000001') or (asset.lineage in ('000001')) or (asset.lineage like '000001%' and asset.lineage<>'000001' and length(asset.lineage) <= 30)) and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId and (assetData.status='approved' or assetData.tagId=NULL)) group by assetData.assetId order by asset.lineage asc
query 54: select count(distinct asset.assetId) from asset, assetData where asset.assetId=assetData.assetId and asset.state='published' and parentId=? and (assetData.status in ('approved', 'archived') or assetData.tagId=?)
  with placeholders:  ['r0zKrVQa_ZLRItujjV7QMQ', '']
query 55: select groupId from groups where groupId=?
  with placeholders:  ['YWnUFSm5b6V3VHyIrKzHAw']
query 56: select count(distinct asset.assetId) from asset, assetData where asset.assetId=assetData.assetId and asset.state='published' and parentId=? and (assetData.status in ('approved', 'archived') or assetData.tagId=?)
  with placeholders:  ['EJXz1AlMsEokBzanJSvVqw', '']
query 57: select count(distinct asset.assetId) from asset, assetData where asset.assetId=assetData.assetId and asset.state='published' and parentId=? and (assetData.status in ('approved', 'archived') or assetData.tagId=?)
  with placeholders:  ['h8DIZynbkMmPccJl2R-6CQ', '']
query 58: select count(distinct asset.assetId) from asset, assetData where asset.assetId=assetData.assetId and asset.state='published' and parentId=? and (assetData.status in ('approved', 'archived') or assetData.tagId=?)
  with placeholders:  ['YgsXv3za5yXvC1s7KXv0Lg', '']
query 59: select groupId from groups where groupId=?
  with placeholders:  ['a5mzxJmC0jcMkaF0nC_nRA']
query 60: select groupId from groups where groupName=?
  with placeholders:  ['Registered Users']
query 61: select groupId from groups where groupId=?
  with placeholders:  ['12']
query 62: select groupId from groups where groupName=?
  with placeholders:  ['Turn Admin On']
query 63: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/nieuws/top5']
query 64: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['2kUJPcAVqjqDCjWVwDTAkw', '']
query 65: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['ewise_286576fbf1e62b54', '']
query 66: select title, epoch1 as date, url

from EwiseThread

left join asset on EwiseThread.assetId=asset.assetId
left join EwisePost on EwisePost.assetId=EwiseThread.assetId and EwiseThread.revisionDate = EwisePost.revisionDate
left join assetData on assetData.assetId=EwiseThread.assetId and EwiseThread.revisionDate = assetData.revisionDate

where asset.parentId='pBOuKv6BqKRqlb-bHfOZbA' and
asset.state='published' and
asset.className='WebGUI::Asset::EwisePost::EwiseThread' and
assetData.revisionDate=(SELECT max(revisionDate) from assetData
where assetData.assetId=asset.assetId) and (assetData.status='approved' or assetData.tagId=NULL)
group by assetData.assetId
order by epoch1 desc LIMIT 5

query 67: select asset.assetId, asset.className from assetData join asset using (assetId) where assetData.url = ? limit 1
  with placeholders:  ['leden/congresagenda/top5']
query 68: select max(revisionDate) from assetData where assetId=? and
(status='approved' or status='archived' or tagId=?) order by assetData.revisionDate
  with placeholders:  ['vlksBAvBdwAnxA5JMuQqeA', '']
query 69: select asset.assetId, asset.className, asset.parentId, assetData.revisionDate from asset left join assetData on asset.assetId=assetData.assetId where asset.state='published' and (assetData.status='approved' or assetData.tagId=NULL) and (asset.className not like 'WebGUI::Asset::Wobject::Layout%') and ((asset.parentId='r0zKrVQa_ZLRItujjV7QMQ')) and assetData.revisionDate=(SELECT max(revisionDate) from assetData where assetData.assetId=asset.assetId and (assetData.status='approved' or assetData.tagId=NULL)) group by assetData.assetId order by asset.lineage asc