(0.00032305717468262): SELECT *
FROM jos_session
WHERE session_id = 'gb9e59ms8mp30iicmfotto1j12'
(0.00019192695617676): DELETE
FROM `jos_session`
WHERE session_id = 'gb9e59ms8mp30iicmfotto1j12'
(0.00035500526428223): SELECT *
FROM jos_session
WHERE session_id = '4a48b2a65c7cc5f1650ba754a9bcb292'
(0.00016093254089355): SELECT *
FROM jos_components
WHERE parent = 0
(0.00018620491027832): SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
(0.00023102760314941): SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
(0.00013494491577148): SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
(0.00013399124145508): SELECT id, title, alias
FROM jos_jumi
WHERE published = 1
(0.00087404251098633): SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 1
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-22 06:24:28' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-22 06:24:28' ) ) OR ( a.state = -1 ) )
(0.00082707405090332): UPDATE LOW_PRIORITY jos_content
SET hits = ( hits + 1 )
WHERE id='1'
(0.00017499923706055): SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 1 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
(0.00076389312744141): SELECT jos_events.*
FROM jos_events, jos_categories AS b
WHERE jos_events.catid = b.id
AND b.access <= 0
AND jos_events.access <= 0
AND (jos_events.state='1'
AND jos_events.checked_out='0')
AND ((publish_up <= '2013-05-22 00:00:00%'
AND publish_down >= '2013-05-22 00:00:00%')
OR (publish_up <= '2014-05-22 23:59:59%'
AND publish_down >= '2014-05-22 23:59:59%')
OR (publish_up <= '2014-05-22 23:59:59%'
AND publish_up >= '2013-05-22 00:00:00%')
OR (publish_down <= '2014-05-22 23:59:59%'
AND publish_down >= '2013-05-22 00:00:00%'))
ORDER BY publish_up ASC
(0.00015497207641602): SELECT *
FROM jos_resource_types
WHERE category=27
ORDER BY TYPE
(0.00069403648376465): ( SELECT g.gidNumber, g.published, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_members AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM jos_xgroups AS g, jos_xgroups_managers AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_invitees AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 )
(0.047500133514404): SELECT DISTINCT r.id, r.title, r.alias, r.introtext AS itext, r.fulltxt AS ftext, r.published AS state, r.created, r.created_by, r.modified, r.publish_up, r.params,
CONCAT('index.php?option=com_resources&id=', r.id) AS href, 'resources' AS SECTION, rt.TYPE AS area, r.TYPE AS category, r.rating, r.times_rated, r.ranking, r.access
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.TYPE=rt.id
WHERE r.standalone=1
AND r.published=1
AND (r.access=0 OR r.access=3)
AND r.publish_up > '1969-12-31 18:00:00'
AND r.publish_up < '2013-05-22 01:24:28'
ORDER BY publish_up DESC
LIMIT 0,8
(0.00013399124145508): SELECT custom_script
FROM jos_jumi
WHERE id = 4
(0.00071501731872559): ( SELECT g.gidNumber, g.published, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_members AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM jos_xgroups AS g, jos_xgroups_managers AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_invitees AS m
WHERE m.gidNumber=g.gidNumber
AND m.uidNumber=0 )
(0.047372102737427): SELECT DISTINCT r.id, r.title, r.alias, r.introtext AS itext, r.fulltxt AS ftext, r.published AS state, r.created, r.created_by, r.modified, r.publish_up, r.params,
CONCAT('index.php?option=com_resources&id=', r.id) AS href, 'resources' AS SECTION, rt.TYPE AS area, r.TYPE AS category, r.rating, r.times_rated, r.ranking, r.access
FROM jos_resources AS r
LEFT JOIN jos_resource_types AS rt
ON r.TYPE=rt.id
WHERE r.standalone=1
AND r.published=1
AND (r.access=0 OR r.access=3)
AND r.publish_up > '1969-12-31 18:00:00'
AND r.publish_up < '2013-05-22 01:24:28'
ORDER BY publish_up DESC
LIMIT 0,5
(0.019659042358398): SELECT D.id, D.filename, D.collection_type, D.title
FROM `jos_medici_datasets` D JOIN `jos_resources` R USING(id)
WHERE R.published=1
ORDER BY id DESC
