- Posts: 52
- Thank you received: 0
Kunena 6.4.7 Released
The Kunena team has announce the arrival of Kunena 6.4.7[K 6.4.7] in stable which is now available for download as a native Joomla extension for J! 5.0.x/5.1.x/5.2.x/5.3.x/5.4.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 6.4
Important note: Go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated. This is particularly necessary for major version jumps so that the table changes are adapted.
Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.
Question More than 150 Queries by Recent Topic (bis)
14 years 1 month ago - 13 years 7 months ago #1
by baboon
More than 150 Queries by Recent Topic (bis) was created by baboon
My kunena forum generate around 150 queries on Recent topic page and around 100 on index page
I try different configuration but don't succeed to reduce this charge
1 - I am using Kunena 1.7.0, CB 1.7.0, J1.5.23
2 - I have set the admin as global moderator.
3 - Here is the Forum Configuration
4 - here is the log on the recent topic page:
(Sorry I have to create an another topic as the original generate a blank page :
www.kunena.org/forum/168-k-16-and-k-17-s...t=10&start=10#106946 )
I try different configuration but don't succeed to reduce this charge
1 - I am using Kunena 1.7.0, CB 1.7.0, J1.5.23
2 - I have set the admin as global moderator.
3 - Here is the Forum Configuration
This message contains confidential information
Database collation check: The collation of your table fields are correct
Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Enabled |
This message contains confidential informationhtaccess: Exists | PHP environment: Max execution time: 10 seconds | Max execution memory: 96M | Max file upload: 300M
This message contains confidential information
Joomla default template details : mywebsite | author: JoomlArt.com | version: 1.2.0 | creationdate: 12/26/07
Kunena default template details : Blue Eagle (default) | author: Kunena Team | version: 1.7.0 | creationdate: 2011-08-29
Kunena version detailled: Installed version: 1.7.0 | Build: 5135 | Version name: Tale | Kunena detailled configuration:
Warning: Spoiler![th]Kunena config settings:[/th]
board_title ---- board_offline 0 board_ofset 0 offline_message <h2>The Forum is currently offline for maintenance.</h2>
Check back soon!enablerss 0 enablepdf 0 threads_per_page 20 messages_per_page 6 messages_per_page_search 15 showhistory 1 historylimit 6 shownew 1 jmambot 1 disemoticons 0 template default showannouncement 1 avataroncat 1 catimagepath category_images/ showchildcaticon 1 annmodid 62 rtewidth 450 rteheight 300 enableforumjump 1 reportmsg 1 username 1 askemail 0 showemail 0 showuserstats 1 showkarma 1 useredit 1 useredittime 0 useredittimegrace 600 editmarkup 1 allowsubscriptions 1 subscriptionschecked 1 allowfavorites 1 maxsubject 50 maxsig 300 regonly 0 changename 0 pubwrite 0 floodprotection 0 mailmod 0 mailadmin 0 captcha 0 mailfull 1 allowavatar 1 allowavatarupload 1 allowavatargallery 1 avatarquality 65 avatarsize 2048 allowimageupload 0 allowimageregupload 1 imageheight 800 imagewidth 800 imagesize 150 allowfileupload 0 allowfileregupload 1 filetypes zip,txt,doc,gz,tgz filesize 120 showranking 1 rankimages 1 avatar_src fb_profile pm_component userlist_rows 30 userlist_online 1 userlist_avatar 1 userlist_name 1 userlist_username 1 userlist_posts 1 userlist_karma 1 userlist_email 0 userlist_usertype 0 userlist_joindate 1 userlist_lastvisitdate 1 userlist_userhits 1 latestcategory 0 showstats 1 showwhoisonline 1 showgenstats 1 showpopuserstats 1 popusercount 5 showpopsubjectstats 1 popsubjectcount 5 usernamechange 0 rules_infb 1 rules_cid 51 help_infb 0 help_cid 1 showspoilertag 1 showvideotag 1 showebaytag 0 trimlongurls 0 trimlongurlsfront 40 trimlongurlsback 20 autoembedyoutube 0 autoembedebay 0 ebaylanguagecode en-us fbsessiontimeout 1800 highlightcode 1 rss_type recent rss_timelimit week rss_limit 10 rss_included_categories rss_excluded_categories rss_specification rss2.0 rss_allow_html 1 rss_author_format name rss_author_in_title 1 rss_word_count 0 rss_old_titles 1 rss_cache 3600 fbdefaultpage recent default_sort asc alphauserpointsnumchars 0 sef 1 sefcats 0 sefutf8 0 showimgforguest 1 showfileforguest 1 pollnboptions 4 pollallowvoteone 1 pollenabled 0 poppollscount 5 showpoppollstats 1 polltimebtvotes 00:15:00 pollnbvotesbyuser 100 pollresultsuserslist 1 maxpersotext 50 ordering_system mesid post_dateformat ago post_dateformat_hover datetime hide_ip 1 js_actstr_integration 0 imagetypes jpg,jpeg,gif,png checkmimetypes 1 imagemimetypes image/jpeg,image/jpg,image/gif,image/png imagequality 50 thumbheight 32 thumbwidth 32 hideuserprofileinfo put_empty integration_access joomla integration_login none integration_avatar communitybuilder integration_profile communitybuilder integration_private uddeim integration_activity none boxghostmessage 0 userdeletetmessage 0 latestcategory_in 1 topicicons 1 onlineusers 1 debug 0 catsautosubscribed 0 showbannedreason 0 version_check 1 showthankyou 1 showpopthankyoustats 1 popthankscount 5 mod_see_deleted 0 bbcode_img_secure text listcat_show_moderators 1 lightbox 1 activity_limit 0 show_list_time 720 show_session_type 0 show_session_starttime 0 userlist_allowed 0 userlist_count_users 1 enable_threaded_layouts 0 category_subscriptions post topic_subscriptions every pubprofile 1 thankyou_max 10 email_recipient_count 0 email_recipient_privacy bcc email_visible_address captcha_post_limit 0 recaptcha_publickey recaptcha_privatekey recaptcha_theme white
Third-party components: CommunityBuilder 1.7 | UddeIm
Third-party SEF components: None
Plugins: System - Mootools Upgrade: Enabled | System - Mootools12: Disabled | Kunena Search 1.7.0
Modules: Kunena Latest 1.6.4
4 - here is the log on the recent topic page:
Warning: Spoiler!
Profile Information
Application afterLoad: 0.001 seconds, 0.27 MB
Application afterInitialise: 0.050 seconds, 2.82 MB
Application afterRoute: 0.058 seconds, 3.32 MB
Application afterDispatch: 1.408 seconds, 17.78 MB
Application afterRender: 1.978 seconds, 23.38 MB
Memory Usage
24562708
148 queries logged
SELECT *
FROM jos_session
WHERE session_id = 'e1d209ee67ea09ccc95c861ec6a3621692f'
SELECT *
FROM jos_session
WHERE session_id = 'e1d209ee67ea09ccc95c861ec6a3621692f'
DELETE
FROM jos_session
WHERE ( TIME < '1316007790' )
SELECT *
FROM jos_session
WHERE session_id = 'e1d209ee67ea09ccc95c861ec6a3621692f'
UPDATE `jos_session`
---- deleta some confidential info
WHERE session_id='e1d209ee67ea09ccc95c861ec6a3621692f'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
SELECT *
FROM jos_kunena_config
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 = 62
SELECT u.id AS userid, 0 AS catid
FROM jos_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 92)
ORDER BY menuid DESC
LIMIT 0, 1
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
SELECT COUNT(*)
FROM jos_kunena_whoisonline
WHERE userip='82.121.141.218'
AND userid='62'
UPDATE jos_kunena_whoisonline
SET TIME='1316001491', what='User is viewing recent discussions', do='', task='',
link=' www.mywebsite.com/forum/recent.html ', func='latest'
WHERE userid='62'
AND userip='82.121.141.218'
SELECT *
FROM jos_kunena_sessions
WHERE userid = '62'
UPDATE `jos_kunena_sessions`
SET `allowed`='13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34',
`lasttime`='1315995680',`readtopics`='0',`currvisit`='1316001491'
WHERE userid='62'
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 = 92 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT *
FROM jos_users
WHERE id = '62'
SELECT c.*, u.*
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 62
SELECT `gid`
FROM `jos_users`
WHERE `id` = 62
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`
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
AND t.enabled = 1
AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)
ORDER BY t.POSITION, t.ordering, f.ordering
SELECT COUNT(a.id)
FROM jos_uddeim AS a
WHERE a.toid=62
AND a.totrash=0
AND archived=0
AND a.toread=0
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_comprofiler'
AND published=1
AND access <= 2
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT COUNT(DISTINCT t.thread)
FROM jos_kunena_messages AS t
INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0,1,2,3)
AND m.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.hold IN (0,1,2,3)
AND t.moved=0
AND t.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.time>'1313416691'
SELECT m.id, MAX(t.id) AS lastid
FROM jos_kunena_messages AS t
INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0,1,2,3)
AND m.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.hold IN (0,1,2,3)
AND t.moved='0'
AND t.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.time>'1313416691'
GROUP BY t.thread
ORDER BY lastid DESC
LIMIT 0, 20
SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments,
l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, j.username, j.name AS uname, c.name AS catname, c.class_sfx
FROM (
SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT NULL
AND f.userid='62') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount,
COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='62', m.id, NULL)) AS mycount,
MAX(m.id) AS lastid, MAX(IF(m.userid='62', m.id, 0)) AS mylastid, MAX(m.TIME) AS lasttime
FROM jos_kunena_messages AS m
LEFT JOIN jos_kunena_favorites AS f
ON f.thread = m.thread
LEFT JOIN jos_kunena_attachments AS a
ON a.mesid = m.id
WHERE m.hold IN (0,1,2,3)
AND m.moved='0'
AND m.thread IN (2970,2971,2972,2960,2928,2955,2950,2947,2942,2940,2938,2929,2925,2923,2920,2918,2916,2912,2904,2898)
GROUP BY thread
) AS l
INNER JOIN jos_kunena_messages AS a
ON a.thread = l.thread
INNER JOIN jos_kunena_messages_text AS t
ON a.id = t.mesid
LEFT JOIN jos_users AS j
ON j.id = a.userid
LEFT JOIN jos_kunena_users AS u
ON u.userid = j.id
LEFT JOIN jos_kunena_categories AS c
ON c.id = a.catid
LEFT JOIN jos_kunena_attachments AS aa
ON aa.mesid = a.id
WHERE (a.parent='0' OR a.id=l.lastid )
GROUP BY a.id
ORDER BY lastid DESC
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
AND s.userid>0
GROUP BY s.userid
ORDER BY username ASC
SELECT id, username AS username
FROM jos_users
WHERE block=0 OR activation=""
ORDER BY id DESC
LIMIT 0, 1
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 (15414,22254,62,21815,19250,22150,21876,15392,21952,19980,21918,21842,21401,10933,21129,21573,22315,20159,21886,22316)
SELECT thread, MIN(id) AS lastread, SUM(1) AS unread
FROM jos_kunena_messages
WHERE hold IN (0,1,2,3)
AND moved='0'
AND thread NOT IN (0)
AND thread IN (2970,2971,2972,2960,2928,2955,2950,2947,2942,2940,2938,2929,2925,2923,2920,2918,2916,2912,2904,2898)
AND time>'1315995680'
GROUP BY thread
SELECT *
FROM jos_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1
SELECT *
FROM jos_kunena_categories
WHERE id IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND published='1'
ORDER BY ordering, name
SELECT id, name, parent
FROM jos_kunena_categories
WHERE published=1
SELECT code, `location`
FROM jos_kunena_smileys
SELECT u.id AS userid, m.catid
FROM jos_users AS u
INNER JOIN jos_kunena_users AS ku
ON u.id=ku.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 ku.moderator='1'
AND (m.catid IS NULL OR c.moderated='1')
SELECT *, u.id
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id IN (15414,22254,21815,19250,22150,21876,15392,21952,19980,21918,21842,21401,10933,21129,21573,22315,20159,21886,22316)
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 22254
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21815
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19250
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19250
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19250
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 22150
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 22150
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21876
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21876
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21876
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15392
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21952
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19980
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19980
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 19980
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21918
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21918
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21918
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21842
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21401
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21401
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21401
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT *
FROM jos_kunena_categories
WHERE id IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND published='1'
ORDER BY ordering, name
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
SELECT username
FROM jos_users
WHERE id = 62
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 15414
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 10933
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21129
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21573
LIMIT 0, 1
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 = 22315
SELECT username
FROM jos_users
WHERE id = 22315
LIMIT 0, 1
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 = 20159
SELECT username
FROM jos_users
WHERE id = 20159
LIMIT 0, 1
SELECT username
FROM jos_users
WHERE id = 21886
LIMIT 0, 1
SELECT COUNT(*)
FROM jos_users
WHERE block=0 OR activation=""
SELECT SUM(TIME >= '1315951200'
AND parent='0') AS todayopen,
SUM(TIME >= '1315864800'
AND TIME < '1315951200'
AND parent='0') AS yesterdayopen,
SUM(TIME >= '1315951200'
AND parent>'0') AS todayanswer,
SUM(TIME >= '1315864800'
AND TIME < '1315951200'
AND parent>'0') AS yesterdayanswer
FROM jos_kunena_messages
WHERE TIME >= '1315864800'
AND hold='0'
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jos_kunena_categories
WHERE parent='0'
AND published=1
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jos_kunena_categories
WHERE published=1
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 = 22316
SELECT username
FROM jos_users
WHERE id = 22316
LIMIT 0, 1
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 92
LIMIT 1
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 90
LIMIT 1
SELECT COUNT(*)
FROM jos_menu AS m
WHERE menutype='kunenamenu'
AND published=1
AND parent=0
AND ordering < 1
AND access <= '2'
SELECT `id`
FROM `jos_components`
WHERE `name`='RSMonials'
AND `enabled`='1'
SELECT *
FROM `jos_rsmonials`
WHERE `status`='1'
ORDER BY `id`
SELECT name
FROM jos_users
WHERE id = 62
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
SELECT a.*, b.username AS displayname
FROM jos_uddeim AS a
LEFT JOIN jos_users AS b
ON a.fromid=b.id
WHERE a.toread=0
AND a.totrash=0
AND a.toid=62
ORDER BY a.datum
SELECT popup
FROM jos_uddeim_emn
WHERE userid=62
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 2
SELECT COUNT(*)
FROM jos_comprofiler_members AS m
LEFT JOIN jos_comprofiler AS c
ON m.referenceid=c.id
LEFT JOIN jos_users AS u
ON m.referenceid=u.id
WHERE m.memberid=62
AND m.pending=1
AND c.approved=1
AND c.confirmed=1
AND c.banned=0
AND u.block=0
SELECT *
FROM jos_acctexp_config
WHERE id = '1'
SELECT `id`
FROM jos_acctexp_metauser
WHERE `userid` = '62'
SELECT *
FROM jos_acctexp_metauser
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '62'
SELECT `id`
FROM jos_acctexp_subscr
WHERE `userid` = '62'
ORDER BY `primary` DESC
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
SELECT `a`.`id`, `a`.`plan`, `a`.`expiration`, `a`.`recurring`, `a`.`lifetime`, `b`.`name`
FROM jos_acctexp_subscr AS a
INNER JOIN jos_acctexp_plans AS b
ON a.plan = b.id
WHERE `userid` = '62'
AND `status` != 'Expired'
AND `status` != 'Closed'
AND `status` != 'Hold'
ORDER BY `lastpay_date` DESC
SELECT `id`
FROM jos_acctexp_displaypipeline
WHERE `userid` = '62'
AND `only_user` = '1'
SELECT `id`
FROM jos_acctexp_displaypipeline
WHERE `only_user` = '0'
SELECT `id`
FROM jos_acctexp_cart
WHERE userid = '62'
SELECT *
FROM jos_acctexp_cart
WHERE id = '895'
SELECT `id`
FROM jos_acctexp_metauser
WHERE `userid` = '62'
SELECT *
FROM jos_acctexp_metauser
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '62'
SELECT `id`
FROM jos_acctexp_subscr
WHERE `userid` = '62'
ORDER BY `primary` DESC
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
(Sorry I have to create an another topic as the original generate a blank page :
www.kunena.org/forum/168-k-16-and-k-17-s...t=10&start=10#106946 )
Last edit: 13 years 7 months ago by sozzled. Reason: Add spoiler tag to post
Please Log in or Create an account to join the conversation.
14 years 1 month ago #2
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re: More than 150 Queries by Recent Topic (bis)
This looks like an issue with the CB integration. Can you please turn off the CB integration for user profiles (just for the test) and recount the queries? Kunena itself should do approx. 18-22 queries on top of Joomla (~18).
I am seeing a lot of redundant user queries that usually point to an integration or 3rd party component issue.
I am seeing a lot of redundant user queries that usually point to an integration or 3rd party component issue.
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
14 years 1 month ago - 13 years 7 months ago #3
by baboon
Replied by baboon on topic Re: More than 150 Queries by Recent Topic (bis)
Hello,
thanks for help
so i disable CB integration and here the log result :
thanks for help
so i disable CB integration and here the log result :
Warning: Spoiler!
Profile Information
Application afterLoad: 0.001 seconds, 0.27 MB
Application afterInitialise: 0.077 seconds, 2.82 MB
Application afterRoute: 0.095 seconds, 3.32 MB
Application afterDispatch: 0.970 seconds, 7.88 MB
Application afterRender: 1.534 seconds, 16.39 MB
Memory Usage
17227572
72 queries logged
1.
SELECT *
FROM jos_session
WHERE session_id = 'bbbbbbbbbbbbbbbbbbbbbbbb'
2.
SELECT *
FROM jos_session
WHERE session_id = 'bbbbbbbbbbbbbbbbbbbbbbbb'
3.
DELETE
FROM jos_session
WHERE ( TIME < '1316029522' )
4.
SELECT *
FROM jos_session
WHERE session_id = 'bbbbbbbbbbbbbbbbbbbbbbbb'
5.
UPDATE `jos_session`
remove-confidential
WHERE session_id='bbbbbbbbbbbbbbbbbbbbbbbb'
6.
SELECT *
FROM jos_components
WHERE parent = 0
7.
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
8.
SELECT *
FROM jos_kunena_config
9.
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 = 62
10.
SELECT u.id AS userid, 0 AS catid
FROM jos_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
11.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 92)
ORDER BY menuid DESC
LIMIT 0, 1
12.
SELECT COUNT(*)
FROM jos_kunena_whoisonline
WHERE userip='80.214.9.23'
AND userid='62'
13.
UPDATE jos_kunena_whoisonline
SET TIME='1316023222', what='User is viewing recent discussions', do='', task='',
link=' www.mywebsite.com/forum/recent.html ', func='latest'
WHERE userid='62'
AND userip='80.214.9.23'
14.
SELECT *
FROM jos_kunena_sessions
WHERE userid = '62'
15.
UPDATE `jos_kunena_sessions`
SET `allowed`='13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34',
`lasttime`='1316017957',`readtopics`='0',`currvisit`='1316023222'
WHERE userid='62'
16.
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 = 92 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
17.
SELECT *
FROM jos_users
WHERE id = '62'
18.
SELECT COUNT(DISTINCT t.thread)
FROM jos_kunena_messages AS t
INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0,1,2,3)
AND m.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.hold IN (0,1,2,3)
AND t.moved=0
AND t.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.time>'1313438422'
19.
SELECT m.id, MAX(t.id) AS lastid
FROM jos_kunena_messages AS t
INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread
WHERE m.moved='0'
AND m.hold IN (0,1,2,3)
AND m.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.hold IN (0,1,2,3)
AND t.moved='0'
AND t.catid IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND t.time>'1313438422'
GROUP BY t.thread
ORDER BY lastid DESC
LIMIT 0, 20
20.
SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime,
l.threadattachments, COUNT(aa.id) AS attachments,
l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread,
0 AS unread, u.avatar, j.username, j.name AS uname, c.name AS catname, c.class_sfx
FROM (
SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT NULL
AND f.userid='62') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount,
COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount,
COUNT(DISTINCT IF(m.userid='62', m.id, NULL)) AS mycount,
MAX(m.id) AS lastid, MAX(IF(m.userid='62', m.id, 0)) AS mylastid, MAX(m.TIME) AS lasttime
FROM jos_kunena_messages AS m
LEFT JOIN jos_kunena_favorites AS f
ON f.thread = m.thread
LEFT JOIN jos_kunena_attachments AS a
ON a.mesid = m.id
WHERE m.hold IN (0,1,2,3)
AND m.moved='0'
AND m.thread IN (2970,2971,2972,2960,2928,2955,2950,2947,2942,2940,2938,2929,2925,2923,2920,2918,2916,2912,2904,2898)
GROUP BY thread
) AS l
INNER JOIN jos_kunena_messages AS a
ON a.thread = l.thread
INNER JOIN jos_kunena_messages_text AS t
ON a.id = t.mesid
LEFT JOIN jos_users AS j
ON j.id = a.userid
LEFT JOIN jos_kunena_users AS u
ON u.userid = j.id
LEFT JOIN jos_kunena_categories AS c
ON c.id = a.catid
LEFT JOIN jos_kunena_attachments AS aa
ON aa.mesid = a.id
WHERE (a.parent='0' OR a.id=l.lastid )
GROUP BY a.id
ORDER BY lastid DESC
21.
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
AND s.userid>0
GROUP BY s.userid
ORDER BY username ASC
22.
SELECT id, username AS username
FROM jos_users
WHERE block=0 OR activation=""
ORDER BY id DESC
LIMIT 0, 1
23.
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 (15414,22254,62,21815,19250,22150,21876,15392,21952,19980,21918,21842,
21401,22323,19076,21820,22146,6654,22319,22321,20159,21886)
24.
SELECT thread, MIN(id) AS lastread, SUM(1) AS unread
FROM jos_kunena_messages
WHERE hold IN (0,1,2,3)
AND moved='0'
AND thread NOT IN (0)
AND thread IN (2970,2971,2972,2960,2928,2955,2950,2947,2942,2940,2938,2929,2925,2923,2920,2918,2916,2912,2904,2898)
AND time>'1316017957'
GROUP BY thread
25.
SELECT *
FROM jos_kunena_announcement
WHERE published='1'
ORDER BY created DESC
LIMIT 0, 1
26.
SELECT *
FROM jos_kunena_categories
WHERE id IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND published='1'
ORDER BY ordering, name
27.
SELECT id, name, parent
FROM jos_kunena_categories
WHERE published=1
28.
SELECT code, `location`
FROM jos_kunena_smileys
29.
SELECT u.id AS userid, m.catid
FROM jos_users AS u
INNER JOIN jos_kunena_users AS ku
ON u.id=ku.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 ku.moderator='1'
AND (m.catid IS NULL OR c.moderated='1')
30.
SELECT *
FROM jos_kunena_categories
WHERE id IN (13,14,15,16,8,9,10,11,12,4,5,6,7,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34)
AND published='1'
ORDER BY ordering, name
31.
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
32.
SELECT guest, TIME, usertype, client_id
FROM jos_session
WHERE client_id = 0
33.
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 = 22323
34.
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 = 19076
35.
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 = 22146
36.
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 = 22319
37.
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 = 22321
38.
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 = 20159
39.
SELECT COUNT(*)
FROM jos_users
WHERE block=0 OR activation=""
40.
SELECT SUM(TIME >= '1315951200'
AND parent='0') AS todayopen,
SUM(TIME >= '1315864800'
AND TIME < '1315951200'
AND parent='0') AS yesterdayopen,
SUM(TIME >= '1315951200'
AND parent>'0') AS todayanswer,
SUM(TIME >= '1315864800'
AND TIME < '1315951200'
AND parent>'0') AS yesterdayanswer
FROM jos_kunena_messages
WHERE TIME >= '1315864800'
AND hold='0'
41.
SELECT SUM(numTopics) AS titles, SUM(numPosts) AS msgs
FROM jos_kunena_categories
WHERE parent='0'
AND published=1
42.
SELECT SUM(parent='0') AS totalcats, SUM(parent>'0') AS totalsections
FROM jos_kunena_categories
WHERE published=1
43.
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 92
LIMIT 1
44.
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 90
LIMIT 1
45.
SELECT COUNT(*)
FROM jos_menu AS m
WHERE menutype='kunenamenu'
AND published=1
AND parent=0
AND ordering < 1
AND access <= '2'
46.
SELECT `id`
FROM `jos_components`
WHERE `name`='RSMonials'
AND `enabled`='1'
47.
SELECT *
FROM `jos_rsmonials`
WHERE `status`='1'
ORDER BY `id`
48.
SELECT name
FROM jos_users
WHERE id = 62
49.
SELECT id
FROM jos_menu
WHERE link LIKE '%com_uddeim%'
AND published=1
AND access<=2
LIMIT 1
50.
SELECT a.*, b.username AS displayname
FROM jos_uddeim AS a
LEFT JOIN jos_users AS b
ON a.fromid=b.id
WHERE a.toread=0
AND a.totrash=0
AND a.toid=62
ORDER BY a.datum
51.
SELECT popup
FROM jos_uddeim_emn
WHERE userid=62
52.
SELECT c.*, u.*
FROM jos_users AS u
LEFT JOIN jos_comprofiler AS c
ON c.id = u.id
WHERE u.id = 62
53.
SELECT id
FROM jos_menu
WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
AND published=1
AND access <= 2
54.
SELECT COUNT(*)
FROM jos_comprofiler_members AS m
LEFT JOIN jos_comprofiler AS c
ON m.referenceid=c.id
LEFT JOIN jos_users AS u
ON m.referenceid=u.id
WHERE m.memberid=62
AND m.pending=1
AND c.approved=1
AND c.confirmed=1
AND c.banned=0
AND u.block=0
55.
SELECT *
FROM jos_acctexp_config
WHERE id = '1'
56.
SELECT `id`
FROM jos_acctexp_metauser
WHERE `userid` = '62'
57.
SELECT *
FROM jos_acctexp_metauser
WHERE id = '1'
58.
SELECT *
FROM jos_users
WHERE id = '62'
59.
SELECT `id`
FROM jos_acctexp_subscr
WHERE `userid` = '62'
ORDER BY `primary` DESC
60.
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
61.
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
62.
SELECT `a`.`id`, `a`.`plan`, `a`.`expiration`, `a`.`recurring`, `a`.`lifetime`, `b`.`name`
FROM jos_acctexp_subscr AS a
INNER JOIN jos_acctexp_plans AS b
ON a.plan = b.id
WHERE `userid` = '62'
AND `status` != 'Expired'
AND `status` != 'Closed'
AND `status` != 'Hold'
ORDER BY `lastpay_date` DESC
63.
SELECT `id`
FROM jos_acctexp_displaypipeline
WHERE `userid` = '62'
AND `only_user` = '1'
64.
SELECT `id`
FROM jos_acctexp_displaypipeline
WHERE `only_user` = '0'
65.
SELECT `id`
FROM jos_acctexp_cart
WHERE userid = '62'
66.
SELECT *
FROM jos_acctexp_cart
WHERE id = '895'
67.
SELECT `id`
FROM jos_acctexp_metauser
WHERE `userid` = '62'
68.
SELECT *
FROM jos_acctexp_metauser
WHERE id = '1'
69.
SELECT *
FROM jos_users
WHERE id = '62'
70.
SELECT `id`
FROM jos_acctexp_subscr
WHERE `userid` = '62'
ORDER BY `primary` DESC
71.
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
72.
SELECT *
FROM jos_acctexp_subscr
WHERE id = '1'
Last edit: 13 years 7 months ago by sozzled. Reason: Add spoiler tag to post
Please Log in or Create an account to join the conversation.
14 years 1 month ago #4
by baboon
Replied by baboon on topic Re: More than 150 Queries by Recent Topic (bis)
Any help on this ?
Please Log in or Create an account to join the conversation.
14 years 1 month ago #5
by Matias
Replied by Matias on topic Re: More than 150 Queries by Recent Topic (bis)
1-7 (7): Joomla
8-42 (35): Kunena
43-45 (3): Unknown
46-48 (3): RSMonials
49-54 (6): UddeIM
55-72 (18): aactexp
Kunena: 34 queries (6 too much), but it still looks OK. Over half of your queries comes outside Kunena, so you should check especially aactexp, whatever it is...
8-42 (35): Kunena
43-45 (3): Unknown
46-48 (3): RSMonials
49-54 (6): UddeIM
55-72 (18): aactexp
Kunena: 34 queries (6 too much), but it still looks OK. Over half of your queries comes outside Kunena, so you should check especially aactexp, whatever it is...
Please Log in or Create an account to join the conversation.
14 years 1 month ago #6
by baboon
Replied by baboon on topic Re: More than 150 Queries by Recent Topic (bis)
Ok for aactexp but this is not the main query -> 18 queries only.
As understand the main query come from the integration of CB with Kunena, 147-72 = 75 queries for the CB integration for me this is the main issue, so why CB integration in Kunena generate so much queries ?
As understand the main query come from the integration of CB with Kunena, 147-72 = 75 queries for the CB integration for me this is the main issue, so why CB integration in Kunena generate so much queries ?
Please Log in or Create an account to join the conversation.
14 years 1 month ago #7
by Matias
Replied by Matias on topic Re: More than 150 Queries by Recent Topic (bis)
I still think that 18 queries in one module is a lot, but yes, the main issue seems to relate to CB integration. Still if I enable CB integration in my test site, I get only few extra queries. So maybe the issue is related to CB but not CB itself..
Have you integrated UddeIM to CB? Maybe that's the issue? Change Private messaging integration in Kunena to None and see what happens.
Have you integrated UddeIM to CB? Maybe that's the issue? Change Private messaging integration in Kunena to None and see what happens.
Please Log in or Create an account to join the conversation.
14 years 1 month ago #8
by baboon
Replied by baboon on topic Re: More than 150 Queries by Recent Topic (bis)
Hello,
I have disable UddeIM in Kunena integration it doesn't change the number of queries.
I have disable UddeIM in Kunena integration it doesn't change the number of queries.
Please Log in or Create an account to join the conversation.
14 years 1 month ago #9
by Matias
Replied by Matias on topic Re: More than 150 Queries by Recent Topic (bis)
The truth is that we have seen this happening for 2 users -- most of the CB users are happy and do not have this issue, including JoomlaPolis, which is running Kunena. So tracking down what is happening is like hunting shadows.
We need to find out a way how to reproduce this issue. What is needed to get this issue? Honestly I have no idea where to start from.. Except that there was a bug in K1.6 where you got many extra queries IF you had no moderators in your site.
We need to find out a way how to reproduce this issue. What is needed to get this issue? Honestly I have no idea where to start from.. Except that there was a bug in K1.6 where you got many extra queries IF you had no moderators in your site.
Please Log in or Create an account to join the conversation.
Time to create page: 0.357 seconds