Question Massive amount of sql queries with components sef urls enabled.

Profile Information
Application afterLoad: 0.000 seconds, 0.44 MB
Application afterInitialise: 0.117 seconds, 6.17 MB
Application afterRoute: 0.162 seconds, 8.37 MB
Application afterDispatch: 0.989 seconds, 28.87 MB
Application afterRender: 1.027 seconds, 29.20 MB
Memory Usage
30657448
79 queries logged

1.
SELECT *
FROM jos_session
WHERE session_id = 'a052cb10ba960a4e1d293dd2b9a4d0d5'
2.
DELETE
FROM jos_session
WHERE ( time < '1291067592' )
3.
SELECT *
FROM jos_session
WHERE session_id = 'a052cb10ba960a4e1d293dd2b9a4d0d5'
4.
UPDATE `jos_session`
SET `time`='1291069392',`userid`='111',`usertype`='Super Administrator',`username`='misterpat',`gid`='25',`guest`='0',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:46;s:19:\"session.timer.start\";i:1291067138;s:18:\"session.timer.last\";i:1291069376;s:17:\"session.timer.now\";i:1291069389;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12\";s:8:\"registry\";O:9:\"JRegistry\":{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:10:\"com_kunena\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:10:\"ActionBulk\";s:18:\"/forum/photography\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:3:\"111\";s:4:\"name\";s:9:\"MisterPat\";s:8:\"username\";s:9:\"misterpat\";s:5:\"email\";s:31:\"[email protected]\";s:8:\"password\";s:65:\"6cce356d1c3b9010cf4ba9fb9ed7c483:FU04jEinYG0jP100rCH3ae4MI2RC7S9A\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-04-18 13:54:01\";s:13:\"lastvisitDate\";s:19:\"2010-11-29 12:12:43\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:28:\"language=en-GB\ntimezone=-5\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/phayes4/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:8:\"language\";s:5:\"en-GB\";s:8:\"timezone\";s:2:\"-5\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"4157c2d2a0b4d330472d84d7803286e6\";s:17:\"application.queue\";a:2:{i:0;a:2:{s:7:\"message\";s:41:\"Your message has been successfully posted\";s:4:\"type\";s:7:\"message\";}i:1;a:2:{s:7:\"message\";s:41:\"The message has been successfully edited.\";s:4:\"type\";s:7:\"message\";}}}__XIJC|a:1:{s:6:\"curUrl\";s:44:\"aHR0cDovL3d3dy5vdmVyYnJvb2tob3NwaXRhbC5uZXQv\";}'
WHERE session_id='a052cb10ba960a4e1d293dd2b9a4d0d5'
5.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
6.
SELECT *
FROM jos_components
WHERE parent = 0
7.
SELECT *
FROM jos_xijc_config
WHERE name = 'config'
8.
SELECT grp.name, grp.id
FROM jos_core_acl_aro_groups AS grp, jos_noixacl_multigroups multigrp
WHERE grp.id = multigrp.id_group
AND multigrp.id_user = 111
9.
SELECT id_levels
FROM jos_noixacl_groups_level
WHERE id_group IN (25)
10.
SELECT aco_section,aco_value,aro_section,aro_value,axo_section,axo_value
FROM jos_noixacl_rules
WHERE aro_section = 'users'
AND aro_value IN ('Super Administrator')
11.
SELECT id, title, adapter
FROM jos_noixacl_adapters
WHERE enabled = 1
ORDER BY ordering
12.
SELECT id, title, adapter
FROM jos_noixacl_adapters
WHERE enabled = 1
ORDER BY ordering
13.
SELECT id, title, adapter
FROM jos_noixacl_adapters
WHERE enabled = 1
ORDER BY ordering
14.
SELECT *
FROM jos_kunena_config
15.
SELECT u.name, u.username, u.block AS blocked, ku.*

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid

WHERE u.id = 111
16.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 78)
ORDER BY menuid DESC
LIMIT 0, 1
17.
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name

FROM jos_comprofiler_plugin

WHERE published = 1
AND access <= 2
AND type = 'user'

ORDER BY ordering
18.
SELECT COUNT(*)
FROM jos_kunena_whoisonline
WHERE userip='67.85.153.82'
AND userid='111'
19.
UPDATE jos_kunena_whoisonline
SET time='1291087393', what='User is viewing list of category', do='', task='', link=' www.overbrookhospital.net/index.php?Item..._kunena&view=listcat ', func='listcat'
WHERE userid='111'
AND userip='67.85.153.82'
20.
SELECT *
FROM jos_kunena_sessions
WHERE userid = '111'
21.
UPDATE `jos_kunena_sessions`
SET `allowed`='34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40',`lasttime`='1291050896',`readtopics`='0,11684,9803',`currvisit`='1291087393'
WHERE userid='111'
22.
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 <= 2
AND m.client_id = 0
AND ( mm.menuid = 78 OR mm.menuid = 0 )
ORDER BY position, ordering
23.
SELECT *
FROM jos_users
WHERE id = '111'
24.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 111
25.
SELECT `gid`

FROM `jos_users`

WHERE `id` = 111
26.
SELECT g1.`id` AS group_id, g1.`name`

FROM `jos_core_acl_aro_groups` AS g1

LEFT JOIN `jos_core_acl_aro_groups` AS g2
ON g2.`lft` >= g1.`lft`

WHERE g2.`id` = 25

ORDER BY g1.`name`
27.
SELECT f.*
FROM jos_comprofiler_fields f

INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)

WHERE f.published = 1
AND ( f.profile != 0 OR f.name = 'username')
AND t.enabled = 1
AND t.useraccessgroupid IN (24,19,20,32,23,33,31,30,29,21,18,17,25,28,-2,-1)

ORDER BY t.position, t.ordering, f.ordering
28.
SELECT count(a.id)
FROM jos_uddeim AS a
WHERE a.toid=111
AND a.totrash=0
AND archived=0
AND a.toread=0
29.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
30.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=0
AND access<=2
LIMIT 1
31.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_uddeim&Itemid=77&task=inbox'
32.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 2
33.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=111'
34.
SELECT *
FROM jos_kunena_categories
WHERE parent='0'
AND published='1'
AND id IN (34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40)
ORDER BY ordering, name
35.
SELECT *
FROM jos_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1
36.
SELECT w.userid, w.func, u.username AS username, k.showOnline
FROM jos_kunena_whoisonline AS w

LEFT JOIN jos_users AS u
ON u.id=w.userid

LEFT JOIN jos_kunena_users AS k
ON k.userid=w.userid

WHERE w.link LIKE ' www.overbrookhospital.net/index.php?Item...kunena&view=listcat% '
AND w.func='listcat'

GROUP BY w.userid
ORDER BY u.username ASC
37.
SELECT u.id
FROM jos_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
38.
SELECT u.id AS uid, m.catid
FROM jos_users AS u
INNER JOIN jos_kunena_users AS p
ON u.id=p.userid
LEFT JOIN jos_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jos_kunena_categories AS c
ON m.catid=c.id
WHERE u.block='0'
AND p.moderator='1'
AND (m.catid IS NULL OR c.moderated='1')
39.
SELECT u.name, u.username, u.block AS blocked, ku.*

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid

WHERE u.id = 93
40.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 93
41.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=93'
42.
SELECT *
FROM jos_kunena_categories
WHERE id IN (34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40)
ORDER BY ordering, name
43.
SELECT c.*, m.id AS mesid, m.thread, m.catid, t.subject AS topicsubject, m.subject, m.name AS mname, u.id AS userid, u.username, u.name AS uname,
(SELECT COUNT(*)
FROM jos_kunena_messages AS mm
WHERE m.thread=mm.thread) AS msgcount, (SELECT COUNT(DISTINCT thread)
FROM jos_kunena_messages AS mmm
WHERE c.id=mmm.catid
AND mmm.hold='0'
AND mmm.time>'1291050896'
AND mmm.thread NOT IN (0,11684,9803)) AS new

FROM jos_kunena_categories AS c

LEFT JOIN jos_kunena_messages AS m
ON c.id_last_msg=m.id

LEFT JOIN jos_kunena_messages AS t
ON m.thread=t.id

LEFT JOIN jos_users AS u
ON u.id=m.userid

WHERE c.parent IN (13,1,4,26)
AND c.published='1'
AND c.id IN(34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40)
ORDER BY ordering, name
44.
SELECT c.id, c.name, c.description, c.parent, c.numTopics, c.numPosts, (SELECT COUNT(DISTINCT thread)
FROM jos_kunena_messages AS m
WHERE c.id=m.catid
AND m.hold='0'
AND m.time>'1291050896'
AND m.thread NOT IN (0,11684,9803)) AS new

FROM jos_kunena_categories AS c

WHERE c.parent IN (11,38,5,39,6,9,14,22,20,36,33,7,10,25,16,32,30,29,28,8,40)
AND c.published='1'
AND c.id IN(34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40)
ORDER BY c.ordering, c.name
45.
SELECT catid, COUNT(*) AS count

FROM jos_kunena_messages

WHERE catid IN (11,38,5,39,6,9,14,22,20,36,33,7,10,25,16,32,30,29,28,8,40)
AND hold='1'

GROUP BY catid
46.
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS k
ON k.userid=u.id

INNER JOIN jos_session AS s
ON s.client_id=0
AND s.userid=u.id

GROUP BY s.userid

ORDER BY username ASC
47.
SELECT id, username AS username
FROM jos_users
WHERE block='0' OR activation=''
ORDER BY id DESC
LIMIT 0, 1
48.
SELECT u.name, u.username, u.block AS blocked, ku.*

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid

WHERE u.id IN (111,124,125,147,155,117,127,93,133,148,256)
49.
SELECT code, `location`
FROM jos_kunena_smileys
50.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 148
51.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=148'
52.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 124
53.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=124'
54.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 147
55.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=147'
56.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 155
57.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=155'
58.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 117
59.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=117'
60.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 127
61.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=127'
62.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 125
63.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=125'
64.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 133
65.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=133'
66.
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
67.
SELECT COUNT(*)
FROM jos_users
WHERE block=0 OR activation=''
68.
SELECT SUM(time >= '1291006800'
AND parent='0') AS todayopen,
SUM(time >= '1290920400'
AND time < '1291006800'
AND parent='0') AS yesterdayopen,
SUM(time >= '1291006800'
AND parent>'0') AS todayanswer,
SUM(time >= '1290920400'
AND time < '1291006800'
AND parent>'0') AS yesterdayanswer

FROM jos_kunena_messages
WHERE time >= '1290920400'
AND hold='0'
69.
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jos_kunena_categories
WHERE parent='0'
AND published=1
70.
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jos_kunena_categories
WHERE published=1
71.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&task=usersList'
72.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&task=usersList'
73.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 256
74.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&Itemid=95&task=userProfile&user=256'
75.
SELECT *
FROM jos_acesef_metadata
WHERE published = '1'
AND url_sef = ''
76.
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 2
77.
SELECT count(u.id)
FROM jos_uddeim AS u
WHERE u.totrash=0
AND u.toread=0
AND u.toid=111
78.
SELECT id
FROM jos_menu
WHERE published>=0
AND link LIKE '%com_uddeim%'
79.
SELECT DISTINCT a.username, a.userid, u.name

FROM jos_session AS a, jos_users AS u

WHERE (a.userid = u.id)
AND (a.guest = 0)
AND (a.client_id = 0)

ORDER BY a.username ASC

Language Files Loaded

* /home/phayes4/public_html/language/en-GB/en-GB.ini 1
* /home/phayes4/public_html/administrator/language/en-GB/en-GB.plg_system_jfusion.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.com_xijc.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.com_kunena.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.com_awdwall.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.plg_content_pagebreak.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.com_comprofiler.ini
* /home/phayes4/public_html/language/en-GB/en-GB.tpl_subblack.ini
* /home/phayes4/public_html/language/en-GB/en-GB.mod_cblogin.ini
* /home/phayes4/public_html/language/en-GB/en-GB.mod_login.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.mod_comprofileronline.ini

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

Profile Information
Application afterLoad: 0.000 seconds, 0.44 MB
Application afterInitialise: 0.098 seconds, 6.17 MB
Application afterRoute: 0.152 seconds, 8.43 MB
Application afterDispatch: 8.428 seconds, 28.90 MB
Application afterRender: 8.532 seconds, 29.22 MB
Memory Usage
30684600
73 queries logged

1.
SELECT *
FROM jos_session
WHERE session_id = 'a052cb10ba960a4e1d293dd2b9a4d0d5'
2.
DELETE
FROM jos_session
WHERE ( time < '1291068605' )
3.
SELECT *
FROM jos_session
WHERE session_id = 'a052cb10ba960a4e1d293dd2b9a4d0d5'
4.
UPDATE `jos_session`
SET `time`='1291070405',`userid`='111',`usertype`='Super Administrator',`username`='misterpat',`gid`='25',`guest`='0',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:65;s:19:\"session.timer.start\";i:1291067138;s:18:\"session.timer.last\";i:1291070400;s:17:\"session.timer.now\";i:1291070405;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12\";s:8:\"registry\";O:9:\"JRegistry\":{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:10:\"com_kunena\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:10:\"ActionBulk\";s:25:\"/forum/overbrook-hospital\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:3:\"111\";s:4:\"name\";s:9:\"MisterPat\";s:8:\"username\";s:9:\"misterpat\";s:5:\"email\";s:31:\"[email protected]\";s:8:\"password\";s:65:\"6cce356d1c3b9010cf4ba9fb9ed7c483:FU04jEinYG0jP100rCH3ae4MI2RC7S9A\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-04-18 13:54:01\";s:13:\"lastvisitDate\";s:19:\"2010-11-29 12:12:43\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:28:\"language=en-GB\ntimezone=-5\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:65:\"/home/phayes4/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:8:\"language\";s:5:\"en-GB\";s:8:\"timezone\";s:2:\"-5\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"4157c2d2a0b4d330472d84d7803286e6\";s:17:\"application.queue\";a:2:{i:0;a:2:{s:7:\"message\";s:41:\"Your message has been successfully posted\";s:4:\"type\";s:7:\"message\";}i:1;a:2:{s:7:\"message\";s:41:\"The message has been successfully edited.\";s:4:\"type\";s:7:\"message\";}}}__XIJC|a:1:{s:6:\"curUrl\";s:44:\"aHR0cDovL3d3dy5vdmVyYnJvb2tob3NwaXRhbC5uZXQv\";}'
WHERE session_id='a052cb10ba960a4e1d293dd2b9a4d0d5'
5.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
6.
SELECT *
FROM jos_components
WHERE parent = 0
7.
SELECT *
FROM jos_xijc_config
WHERE name = 'config'
8.
UPDATE jos_acesef_urls
SET hits = (hits+1)
WHERE id = '60914'
9.
SELECT *
FROM jos_acesef_metadata
WHERE published = '1'
AND url_sef = 'forum/index'
10.
SELECT grp.name, grp.id
FROM jos_core_acl_aro_groups AS grp, jos_noixacl_multigroups multigrp
WHERE grp.id = multigrp.id_group
AND multigrp.id_user = 111
11.
SELECT id_levels
FROM jos_noixacl_groups_level
WHERE id_group IN (25)
12.
SELECT aco_section,aco_value,aro_section,aro_value,axo_section,axo_value
FROM jos_noixacl_rules
WHERE aro_section = 'users'
AND aro_value IN ('Super Administrator')
13.
SELECT id, title, adapter
FROM jos_noixacl_adapters
WHERE enabled = 1
ORDER BY ordering
14.
SELECT id, title, adapter
FROM jos_noixacl_adapters
WHERE enabled = 1
ORDER BY ordering
15.
SELECT id, title, adapter
FROM jos_noixacl_adapters
WHERE enabled = 1
ORDER BY ordering
16.
SELECT *
FROM jos_kunena_config
17.
SELECT u.name, u.username, u.block AS blocked, ku.*

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid

WHERE u.id = 111
18.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 78)
ORDER BY menuid DESC
LIMIT 0, 1
19.
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name

FROM jos_comprofiler_plugin

WHERE published = 1
AND access <= 2
AND type = 'user'

ORDER BY ordering
20.
SELECT COUNT(*)
FROM jos_kunena_whoisonline
WHERE userip='67.85.153.82'
AND userid='111'
21.
UPDATE jos_kunena_whoisonline
SET time='1291088405', what='User is viewing list of category', do='', task='', link=' www.overbrookhospital.net/forum/index ', func='listcat'
WHERE userid='111'
AND userip='67.85.153.82'
22.
SELECT *
FROM jos_kunena_sessions
WHERE userid = '111'
23.
UPDATE `jos_kunena_sessions`
SET `allowed`='34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40',`lasttime`='1291050896',`readtopics`='0,11684,9803,7793,11484',`currvisit`='1291088405'
WHERE userid='111'
24.
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 <= 2
AND m.client_id = 0
AND ( mm.menuid = 78 OR mm.menuid = 0 )
ORDER BY position, ordering
25.
SELECT *
FROM jos_users
WHERE id = '111'
26.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 111
27.
SELECT `gid`

FROM `jos_users`

WHERE `id` = 111
28.
SELECT g1.`id` AS group_id, g1.`name`

FROM `jos_core_acl_aro_groups` AS g1

LEFT JOIN `jos_core_acl_aro_groups` AS g2
ON g2.`lft` >= g1.`lft`

WHERE g2.`id` = 25

ORDER BY g1.`name`
29.
SELECT f.*
FROM jos_comprofiler_fields f

INNER JOIN jos_comprofiler_tabs AS t
ON (f.tabid = t.tabid)

WHERE f.published = 1
AND ( f.profile != 0 OR f.name = 'username')
AND t.enabled = 1
AND t.useraccessgroupid IN (24,19,20,32,23,33,31,30,29,21,18,17,25,28,-2,-1)

ORDER BY t.position, t.ordering, f.ordering
30.
SELECT count(a.id)
FROM jos_uddeim AS a
WHERE a.toid=111
AND a.totrash=0
AND archived=0
AND a.toread=0
31.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
32.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=0
AND access<=2
LIMIT 1
33.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 2
34.
SELECT *
FROM jos_kunena_categories
WHERE parent='0'
AND published='1'
AND id IN (34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40)
ORDER BY ordering, name
35.
SELECT *
FROM jos_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1
36.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_kunena&Itemid=77'
37.
SELECT name AS name, parent, id
FROM jos_menu
WHERE id = '77'
AND published > 0
38.
SELECT w.userid, w.func, u.username AS username, k.showOnline
FROM jos_kunena_whoisonline AS w

LEFT JOIN jos_users AS u
ON u.id=w.userid

LEFT JOIN jos_kunena_users AS k
ON k.userid=w.userid

WHERE w.link LIKE ' www.overbrookhospital.net/forum/index% '
AND w.func='listcat'

GROUP BY w.userid
ORDER BY u.username ASC
39.
SELECT *
FROM jos_kunena_categories
WHERE id IN (34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40)
ORDER BY ordering, name
40.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_kunena&Itemid=77'
41.
SELECT c.*, m.id AS mesid, m.thread, m.catid, t.subject AS topicsubject, m.subject, m.name AS mname, u.id AS userid, u.username, u.name AS uname,
(SELECT COUNT(*)
FROM jos_kunena_messages AS mm
WHERE m.thread=mm.thread) AS msgcount, (SELECT COUNT(DISTINCT thread)
FROM jos_kunena_messages AS mmm
WHERE c.id=mmm.catid
AND mmm.hold='0'
AND mmm.time>'1291050896'
AND mmm.thread NOT IN (0,11684,9803,7793,11484)) AS new

FROM jos_kunena_categories AS c

LEFT JOIN jos_kunena_messages AS m
ON c.id_last_msg=m.id

LEFT JOIN jos_kunena_messages AS t
ON m.thread=t.id

LEFT JOIN jos_users AS u
ON u.id=m.userid

WHERE c.parent IN (13,1,4,26)
AND c.published='1'
AND c.id IN(34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40)
ORDER BY ordering, name
42.
SELECT c.id, c.name, c.description, c.parent, c.numTopics, c.numPosts, (SELECT COUNT(DISTINCT thread)
FROM jos_kunena_messages AS m
WHERE c.id=m.catid
AND m.hold='0'
AND m.time>'1291050896'
AND m.thread NOT IN (0,11684,9803,7793,11484)) AS new

FROM jos_kunena_categories AS c

WHERE c.parent IN (11,38,5,39,6,9,14,22,20,36,33,7,10,25,16,32,30,29,28,8,40)
AND c.published='1'
AND c.id IN(34,1,4,5,6,7,9,10,11,13,14,16,20,22,25,32,33,36,38,39,26,28,29,30,8,40)
ORDER BY c.ordering, c.name
43.
SELECT catid, COUNT(*) AS count

FROM jos_kunena_messages

WHERE catid IN (11,38,5,39,6,9,14,22,20,36,33,7,10,25,16,32,30,29,28,8,40)
AND hold='1'

GROUP BY catid
44.
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS k
ON k.userid=u.id

INNER JOIN jos_session AS s
ON s.client_id=0
AND s.userid=u.id

GROUP BY s.userid

ORDER BY username ASC
45.
SELECT id, username AS username
FROM jos_users
WHERE block='0' OR activation=''
ORDER BY id DESC
LIMIT 0, 1
46.
SELECT u.name, u.username, u.block AS blocked, ku.*

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid

WHERE u.id IN (111,124,125,147,155,117,127,93,133,148,256)
47.
SELECT code, `location`
FROM jos_kunena_smileys
48.
SELECT u.id
FROM jos_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
49.
SELECT u.id AS uid, m.catid
FROM jos_users AS u
INNER JOIN jos_kunena_users AS p
ON u.id=p.userid
LEFT JOIN jos_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jos_kunena_categories AS c
ON m.catid=c.id
WHERE u.block='0'
AND p.moderator='1'
AND (m.catid IS NULL OR c.moderated='1')
50.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 148
51.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_kunena&Itemid=77&catid=34&func=view&id=817&limit=20&limitstart=620'
52.
SELECT id, name, parent
FROM jos_kunena_categories
WHERE published=1
53.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 124
54.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 147
55.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 155
56.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 117
57.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 127
58.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 93
59.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 125
60.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 133
61.
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
62.
SELECT COUNT(*)
FROM jos_users
WHERE block=0 OR activation=''
63.
SELECT SUM(time >= '1291006800'
AND parent='0') AS todayopen,
SUM(time >= '1290920400'
AND time < '1291006800'
AND parent='0') AS yesterdayopen,
SUM(time >= '1291006800'
AND parent>'0') AS todayanswer,
SUM(time >= '1290920400'
AND time < '1291006800'
AND parent>'0') AS yesterdayanswer

FROM jos_kunena_messages
WHERE time >= '1290920400'
AND hold='0'
64.
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jos_kunena_categories
WHERE parent='0'
AND published=1
65.
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jos_kunena_categories
WHERE published=1
66.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&task=usersList'
67.
SELECT id, url_sef, url_real, used, params
FROM jos_acesef_urls
WHERE params LIKE '%notfound=0%'
AND url_real = 'index.php?option=com_comprofiler&task=usersList'
68.
SELECT *

FROM jos_users AS u

LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 256
69.
SELECT *
FROM jos_acesef_metadata
WHERE published = '1'
AND url_sef = 'forum/index'
70.
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 2
71.
SELECT count(u.id)
FROM jos_uddeim AS u
WHERE u.totrash=0
AND u.toread=0
AND u.toid=111
72.
SELECT id
FROM jos_menu
WHERE published>=0
AND link LIKE '%com_uddeim%'
73.
SELECT DISTINCT a.username, a.userid, u.name

FROM jos_session AS a, jos_users AS u

WHERE (a.userid = u.id)
AND (a.guest = 0)
AND (a.client_id = 0)

ORDER BY a.username ASC

Language Files Loaded

* /home/phayes4/public_html/language/en-GB/en-GB.ini 1
* /home/phayes4/public_html/administrator/language/en-GB/en-GB.plg_system_jfusion.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.com_xijc.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.com_kunena.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.com_awdwall.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.plg_content_pagebreak.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.com_comprofiler.ini
* /home/phayes4/public_html/language/en-GB/en-GB.tpl_subblack.ini
* /home/phayes4/public_html/language/en-GB/en-GB.mod_cblogin.ini
* /home/phayes4/public_html/language/en-GB/en-GB.mod_login.ini 1
* /home/phayes4/public_html/language/en-GB/en-GB.mod_comprofileronline.ini

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None